6.b Treasurer's Report Dec. 2020 & Nov. 2020 Expenditure Summaryaug �j� _
Cw -
SCANDIA
FUND ACCOUNTING
Beginning Cash Balance 12/1/2020
Beginning Checking Balance
Checking Receipts
Transfers to Checking
Expenditures
Transfers from Checking -Tax Settlement
Payroll
Ending Checking Balance
Beginnging Money Market Balance
Money Market Receipts
Transfers from Checking - Tax Settlement
Tranfers to Checking
Ending Money Market Balance
Beginning Investments Balance
Investments Receipts
Ending Investments Balance
EDA Balance
Outstanding Checks
Ending Cash Balance 12/31/2020
City of Scandia
Treasurer's Report
12/31/2020
C H EC KI IN G,. M 0 N EY MARKET & INVESTMENT CID `s
Checking *102
Beg Bal
Credits
Debits
End Bal
Money Market *105 - Rate .25%
Beg Bal
rate change from 1.25%
Credits
Debits
End Bal
Investments
CD *4422 - Rate .90% 12 mo., 3/25/2021
CD *4424 - Rate .30% 12 mo., 7/25/2021
CD *4425 - Rate 1.75% 12 mo., 9/28/2021
CD *4426 - Rate 1.60% 12 mo., 1/29/2021
Total Investments
Total Bank & Investment Accounts
$ 3,754,639.58
$ 30,297.82
$ 1,115,930.00
$ 21,000.00
$ (106,357.70)
$ (916,000.00)
$ (29,455.68)
$ 115,414.44
$ 1,756,629.47
$ 37,813.76
$ 916,000.00
$ (21,000.00)
$ 2,689,443.23
$ 2,017,635.05
$ 1,244.68
$ 2,018,879.73
$ (58,340.13)
$ 30,092.09
$ 1,136,930.00
$ (1,051,607.65)
$ 1,756,629.47
$ 953,813.76
$ (21,000.00)
$ 2,689,443.23
$ 315,566.31
$ 439,056.14
$ 730,795.90
$ 533,461.38
Checks in Transit *3102
Deposit in transit checking
Deposit in transit money market
Total Adjusted Undesignated Funds
Scandia EDA *6301 Bal 10/31/20 $
Receipts $
Expenditures $
Checks in Transit $
Deposit in Transit Tax Settlement
Total Designated Funds
Total Funds
Submitted by: Colleen Firkus, Treasurer
$ 2,018,879.73
$ 4,823,737.40
$ (58,340.13)
$ 4,765,397.27
25,223.76
(295.00)
$ 24,928.76
City of Scandia
i� Expenditure Summary
SCAND] A,
� 9" IF December -20
2020 YTD Budget % of YTD
GENERAL FUND 2020 Budget 2020 YTD Amount 2020 MTD Amount BalanceBudget
Administration & Fin,incc:" $404,600.00 $387,951.63 -$396,681.89 $16,648.37 95.89%
City Council $21,000.00 $13,986.99 $0.00 $7,013.01 66.60%
Elections $6,400-00 $8,605.87 $102.83 -$2,205.87 134.47%
Planning & Building $131,400.00 $103,197.60 $10,990.30 $28,202.40 78.54%
Police $139,100.00 $51,155.48 $0.00 $87,944.52 36.78%
Fire Department $296,114.00 $185,446.09 $21,135.61 $110,667.91 62.63%
Public Works $690,700.00 $555,043.23 $25,346.42 $135,656.77 80.36%
Parks & Recreation $77,600.00 $90,155.73 $7,539.57 -$12,555.73 116.18%
Community Center $49,500,00 $35,296.59 $2,003.85 $14,203.41 71,31%
Interfund Transfers $0,00 $1,358,000.00 $1,358,000.00 -$1,358,000.00
Total Genera Fund $1,816,414.00 $2,788,839.21 $1,028,436.69 -$972,425.21 78.77%
COVID-19 RELIEF 0 $313,770.40 $6.20899 -$313,770.40
EDA $800.00 $881.60 $186.60 -$81 60 000%
CABLE TV $8,920.00 $3,236.29 $6789 $5,68371
GATEWAY DONATIO14S $0.00 $0.00 $000 $000 0.00%
DEBT
2013 EQUIPMENT CERTIFICATI $66,56000 $66,555.00 $2,64000 $500 99.99%
2015 EQUIPMENT CERTiFICATI $43.99500 $43,49450 $000 $500.50 98.86%
2017 EQUIPMENT CERTIFICATI $34,948.00 $34,544.00 $000 $404.00 98.84%
2018 BLACKTOP $327,175.00 $326,67002 $000 $504.98 99.85%
$472,678.00 $471,263.52 $2,640.00 $1,414.48 99.70%
CAPITAL IMPROVEMEN`-S $430,000.00 $286,551 49 $160,264.02 $143,448.51 66.64%
PARK CAPITAL IMPROVEMENT $81,620,00 $30,943.12 $0.00 $50,676.88 37.91%
EQUIPMENT REPLACEMENT $256,000.00 $93,498.07 $0.00 $162,501.93 36.52%
LOCAL ROAD IMPROVEMENT F $637,000.00 $398,515.61 $000 $238,484.39 62.56%
BIG MARINE SEWER FUND $240,908.50 $184,113.37 $6,81844 $56,795.13 76.42%
UPTOWN SEWER $22,447.00 $8,363.21 $73578 $14.08379 37.26%
Report rotal $3,966,787.50 $4,579,975.89 $1,205,358.41 -$613,188.39
N OD m W A A A A W W W W W N N N m
(N 20 w JtN N m 001 A m V N W V O a) m c
Z
m m c m r m n m m m m m x n n G7 v
D n O D > > D D c D (min m O< Z
0O DD m
m Cn Z D Z 0 Z Z Z 0 < r
m
c m m o m o m
a o x* v T o x x x o - o
� m - z
M m D D D D
3 m � � z
Z z ai in cn m
m
Z y
vx
w Im fA w T 003
A A V1 to m D
to ffl tT Hi fA 69 m N o fA fA N a r
L" N N A (D m W A EA fA iA A Z O D
O W V m m A W m V N m m A c Z
A N N m J N N m N m W V m (�O D Z 0
O W V N m W m A m m J 0)
m m m V N J m W A N V W
EA fA fA fA fA m
A A y1 69 m
W fA to EA fA fA O1 c fA fA W
A N A N V7 m W m A fA fA fA W �I
O W m A W O OJ m J N m m fA Gn 91 N c
O N Oo m W W m V f0 f0 m W J A m D
m OWI OAD N O -1 (WD W A N v -+ (Jn A (JD z
in EA di fA di
A A fA fA
fA fA d1 U) O FA FA O
A N N A N fA A A UI A fA fA W a
f0 W O1 V N O1 N O 1 J N m m fA y1 V A
W N fT w N A m N (D A Vt W J (D Ila
10.1 m m cc (NO (mJ1 N v m coNW A N v � (JJi A N 0
2
in W fA fA
A W GN EA fA
O ffl w fA fA o FA FA fA m
N (D N EA (T N m fA fA m
A N O m W m W N m m y1 fA m N D
A m A Vt m O m v w m A m W J m m m
V m OD W W m O m W N (O A M m V N A X
O to A V V (D In N A N J ut m m r
fA fA �_ �_
W W fA fA fA
M fA m fA b) fA W O EA fA fA m
O1 N W N N m N W N_ m fA N _ J
O N J A A W W W N O O FA A
A m (D V A A N V - V A W m V
m m O W A m J m W N W A fA J OJ W D
N A m V V m J m J N .J. O (P m j
fA fA fA fA
W W fA fA fA
to In W fA V)fA N O_ fA ffl fA m
m N A W N m m W m fA N A _ O
N N N W W O N W V W N m W pc -
NZ
O t0 O t0 m W J A V .m.. J A A O m N m m
to (A fA fA fA
A A fA fA fA fA
V 4H-4 fA fA fA A o_ fA fA W m
co Nm W N N O A O fA fA _
V N N O N O Ot m V V N V A m fA m L
t0 N m W (D m D) N m w D) m m (n fA - O A c
co (D (D N A O co m m J O J O J W V m W r
01 w V m co m m N A 0) N O o N O O j
fA in dl fA fA
A A
m69 C1 69 fA A O !A fA W W D
A N N W N (A m A O fA fA_ m c
m m W O ut W m m V N V A m y1 W A
V N A m O J W N O7 m m m Ut FA O O m c
N tD N OD OD N (D m Ut O J O V f0 V O m f0 y
m OJ V J O O N (D U1 0) N O m O O I
N
fA fA �+ �1 f� m
P. U fA N fA d) fA A - O fA EA W N
N N O W N A A m A O N m
N N O O A N m 91 N m N J A W A m 3
W N O O O N W m m m m m fA V O W
V (D m O V) 10 W W m N O V O J m J W m N m
O7 (0 O m V m N A N m � N O m m O W X
fA H fA fA
A A 6D fA fA bH fA _ o
N ffl N di (A fA A m fA Efl
N A m W A O fA fA m -i
W N m N J O N N V m m m ut FA W O m
N f00 A W N N N (Olt m v N O (1) CD O m m
.Zl
fA fA fA FA Z
W W FA FA fA fA__ 0
N N N G2 N fA A m A j m - (A fA fA V m
A A 10 N O m m D 0) _ V V A m fy m W c0
(D OJ V m m O O N W t0 m m N fA m m W
4N) V A m O7 m m J O V (O V W A m
O (O t0 A O N N N O Ut J f0 O
v
IA fA � fA m
A A fA fA fA
V fA 0) fA fA 69 O) m d_1 FA FA V1 J m
m
O A N A O N V A m N fA (D N co
to m W A O N U m O m m A O fA w m A W
N N V7 A O A N (D m A W O N m m J N N A m
0 (D V 0 m W A m 0 10 W A N (D ut m O m rm
City of Scandia
�i Expenditure Summary
SCANDIA
Report Total $3,966,787.50 $3,374,617.48 $969,863.50 $592,170.02
November -20
2020 YTD Budget
% of YTD
GENERAL FUND
2020 Budget
2020 YTD Amount 2020
MTD Amount
Balance
Budget
Administration & Finance"
$404.60000
$363,633,52
$25,285.85
$40,966.48
89.87%
City Council
$21,000.00
$13,986,99
$0.00
$7,013.01
66.60%
Elections
$6,400.00
$8,503.04
$2,586.40
-$2,103.04
132.86%
Planning & Building
$131,400.00
$92,207.30
$8,990.62
$39,192.70
70,17%
Police
$139,100.00
$51,155.48
-$18,613.01
$87,94452
36.78%
Fire Department
$296,114.00
$164,310.48
-$31,583.88
$131,80352
55.49%
Public Works
$690,700.00
$529,696.81
$37,010.38
$161,003.19
76.69%
Parks & Recreation
$77,600.00
$82,616,16
$2,959,79
-$5,016.16
106.46%
Community Center
$49,500.00
$33,292.74
$6,115.25
$16,207.26
67.26%
Interfund Transfers
$0.00
$421,000.00
$421,000.00
-$421,000.00
Total General Fund
$1,816,414.00
$1,760,402.52
$453,751.40
$56,011.48
96.92%
COVID-19 RELIEF
0
$307,561.41
$307,561.41
-$307,561.41
EDA
$80000
$69500
$370.00
$105.00
0.00%
CABLE TV
$8,92000
$3.16840
$0.00
$5,751.60
GATEWAY DONATIONS
$0.00
$000
$0.00
$0.00
0.00%
DEBT
2013 EQUIPMENT CERTIFICATI
$66,560.00
$63,91500
$000
$2,645.00
96.03%
2015 EQUIPMENT CERTIFICATI
$43,995.00
$43,49450
$000
$50050
98.86%
2017 EQUIPMENT CERTIFICATI
$34,948.00
$34,544.00
$000
$404.00
98.84%
2018 BLACKTOP
$327,175.00
$326,670.02
$270,58751
$50498
99.85%
$472,678.00
$468,623.52
$270,587.51
$4,054.48
99.14%
CAPITAL IMPROVEMENTS
$430,00000
$126,287.47
-$80,46586
$303,712.53
29.37%
PARK CAPITAL IMPROVEMENT
$81,620.00
$30,943.12
$000
$50,67688
37.91%
EQUIPMENT REPLACEMENT
$256,000.00
$93,498.07
$0.00
$162,501.93
36.52%
LOCAL ROAD IMPROVEMENT F
$637,000.00
$398,515.61
$0.00
$238,484.39
62.56%
BIG MARINE SEWER FUND
$240,908.50
$177,294.93
$17,572.26
$63,613.57
73.59%
UPTOWN SEWER
$22,447.00
$7,627.43
$486,78
$14,819,57
33.98%
Report Total $3,966,787.50 $3,374,617.48 $969,863.50 $592,170.02