5.b Treasurer's Report October 2020aug*4,City of Scandia
Treasurer's Report
SCANDIA 10/31/2020
Beginning Cash Balance 10/1/2020
$ 4,500,080.40
Receipts Checking
$ 17,240.62
Transfers to Checking
$ _
Receipts Money Mrkt
$ 932,244.63
Receipts Investments
$ 2,475.69
Expenditures
$ 1,194,824.09
Payroll
$ 33,903.73
Transfers
t _
Total Disbursements $ (1,228,727.82)
Adjustments
Ending Cash Balance 10/31/2020
$ 4,223,313.52
Ending Balance includes the following Investments:
Checking *102
Beg Bal
$
1,255,601.04
Credits
$
17,042.90
Debits
$
(1,206,251.13)
End Bal
$ 66,392.81
Money Market *105 - Rate .25%
Beg Bal
$
1,231,882.60
rate change from 1.25%
Credits
$
925,360.45
Debits
$
-
End Bal
$ 2,157,243.05
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
Checks in Transit *3102
Deposit in transit checking
Deposit in transit money market
Total Adjusted Undesignated Funds
$ 314,859.82
$ 439,056.14
$ 730,257.71
5 533,461.38
Scandia EDA *6301 Bal 10/31/20 $ 25,298.76
Receipts $
Expenditures $
Checks in Transit $
Deposit in Transit
Total Designated Funds
Total Funds
Submitted by: Colleen Firkus, Treasurer
$ 2,017,635.05
$ (25,039.29)
$ 197.72
$ 6,884.18
$ 4,223,313.52
$ 25,298.76
��T r
SCA 1.!1nT
.11
GENERALFUND
Administration & Finance -
City Council
Elections
Planning & Building
Police
Fire Department
Public Works
Parks & Recreation
Community Center
Total General Fund
EDA
CABLE TV
GATEWAY DONATIONS
DEBT
2007 ROAD PROJECT BOND
2013 EQUIPMENT CERTIFICATI
2015 EQUIPMENT CERTIFICATI
2017 EQUIPMENT CERTIFICATI
2018 BLACKTOP
CAPITAL IMPROVEMENTS
PARK CAPITAL IMPROVEMENT
EQUIPMENT REPLACEMENT
LOCALROADIMPROVEMENTF
BIG MARINE SEWER FUND
UPTOWN SEWER
City of Scandia
Expenditure Summary
$1,816,414.00
$1,306,651.12
October -20
$509,762.88
71.94%
$80000
$32500
$0.00
$47500
0.00%
2020 YTD Budget
% of YTD
2020 YTD Budget
2020 YTD Amount 2020
MTD Amount
Balance
Budget
$404,600.00
$000
$338,347,67
$33,154.43
$66,25233
83.63%
$21,000.00
000%
$13,986.99
$4,689.83
$7,01301
66.60%
$6,40000
$43,99500
$5,916.64
$58.56
$48336
92.45%
$131,40000
$34,54400
$83,216.68
$16,165.71
$48,183.32
63.33%
$139,10000
$000
$69,768.49
$29.99
$69,331.51
50.16%
$296,11400
$274,641.99
$195,894.36
$33,265.10
$100,219.64
66.16%
$690,70000
4808%
$492,686.43
$26,205.42
$198,013.57
7133%
$77,60000
$256,00000
$79,65637
$16,369.42
-$2,056.37
102.65%
$49,50000
$398,51561
$27,177.49
$2.093.83
$22,32251
54.90%
$1,816,414.00
$1,306,651.12
$132,032.29
$509,762.88
71.94%
$80000
$32500
$0.00
$47500
0.00%
$8,92000
$3,16840
$60.04
$5,751.60
$0.00
$000
$000
$000
000%
$0.00
$000
$0.00
$000
000%
$66,560.00
$63,915.00
$0.00
$2,64500
9603%
$43,99500
$43,49450
$0.00
$50050
9886%
$34,94800
$34,54400
$0.00
$404.00
9884%
$327.17500
$56,08251
$000
$271,092.49
1714%
$472,678.00
$198,036.01
$0.00
$274,641.99
41.90%
$430,00000
$206,75333
$175,116.80
$223,24667
4808%
$81,620.00
$30,94312
$6,112.74
$50,67688
37.91%
$256,00000
$93,49807
$000
$162,501 93
3652%
$637,00000
$398,51561
$0.00
$238,48439
62.56%
$240,90850
$159,72267
$3,72352
$81,18583
6630%
$22,447 00
$7,14065
$15765
$15,306.35
31.81%
Report Total $3,966,787.50 $2,404,753.98 $317,203.04 $1,562,033.52
N 00O O A A A A W W j W W N N N — m
N O O O O O O --� -+ O W N O O C
CilN N co O A OD J CT W J O O W Z
m m c w r m m n w m m m w X 0 0 0 o
0 W T 5 O O D D0 O 0 m D O m
D A O D c x -u O c c c � w W< z
D
rn w Z O Z -UR m z z z m m < r
- c m m o v T -4 � -1 N
OW m m K m m O m m m 0o
D O r o
* m m � x x x J O -mn o
r D m m --i --i --iz
r ;o O n m
K m - D OZ
m C/)z � cmn cmn cmn
I
m
v=
A A ICA L O D
()) 69 N E4 69 EA O N O EA EA N Z D
N N N A (D O W � A EA 69 EA
O W V m :N W ao J N m (D EA EA A C Z Z
A N N m J N N N O N A (n W J 00 O D -4 m
4� O W J N OD W m � A (P 0) J (T .�
O O OD J m C1) J m W A N J (31 W
A A m
m
w EA w EA EA EA 0) o E9 rj _, W
A N — A N O (n W j A EA 69EA W
O W Of A W O (D OD V N m O 69 EA m N D
O N 00 O W W (0 V CD (D 41 m W J ? 03
4� O W �2A N 0) W W co A (n 0) V N V X
0) CO co N O J O m W A N V m A O -�
69 EA fA EA V3
A A EA 69
�) 3
A N N A N EA A A j ? Efl 69 EA W
t0 W Of J N (T N O J J 69 D N m (D 6A J A >
00 N N co N A () N (D A A m W J O N
OO (O N O W OD W (J( A (h O J J ()) 0
N m O) (D C" N J O 00 W A N J 0) A N 2
69 69 69 69
A W EA 69 EA
O EA i0 EA EA 0) o EA 69 !A O
N cn j 69 0 � N m 6A69 O n
A N O 0o W (p W N m O EA fD CJ)
A O A Cn N O 00 J (D 0) A D) W J CT 0)
V m CO W W (D O w W N O A m O J m A
O w A i J J (D (o Cr A N J (n OD m r
69 EA EA 69
W W i
T 69 O) 69 to EA W - - Ow wEA co
O) N W j N OD N W j m EA N V
A
OD W J ? A N V J V
O Do O W A OD V 00 W N O A W EA J W W D
N i A W J V m V CD V ()) V O CT 00
EA EA 69 EA
W W
W EA W 69 EA 69 N 0
O &s fA 6fl 000
N N N 00 W O N W J W N m W EAW C
O) 00 V m A co W J m J A W W J —4 N O
N OD W w m 00 O 00 (7) N (D A OD 00 EA J W A z
O O O co m W J A J m J A A O CA N m m
fA 69 69 69 yw
A A y) EA f9 <A
V 6 9 �I EA 694&9 O EA U3 j
CO N CD W N V U) m :4-4
O FA _
(n N O N O U) m J J N J A m EA CP C_
(D N O) W co Oo m N m W m m w Ln 69 O ? C
w co w Cn A O co (D Oo J O J O J O J W W r
N (D v (D O w 00 N s A m J N O Cn N O O -<
W 69 0) EA ffl A o EA 69 W W C
A N N W N EA j m A O EA kn _ 00
00 CP W O (T W 00 m V N J A ao � W A Gi
-4 EA —4 O o 0o C
N co N co j OD N m W 00 m O V O V CO J m O N
O CO V J O m N O Cr m V N0 Ch C) O O �
N
A A � EA m
N EA N V) 69 69 A O EA EA W N m
N N O W N A A m A O EA EA N
N Cn O O A N 00 OD n n N J A Cb EA A � co W
W N O m O
V (D W m N W M m aD C0 Cn {A J O
m O (D O W O J O V (D J W co N m
t0 (D O co J 00 � m N A N m J N O m O ao .�
A En 69 EA ER EA EA Efl EA EA &H EA EA 69 EA 69 69 69 EA
N
oAo A O
OD 0
Cn W (D A 00 90 O O N J ? 00 m O
N N W (D Cn J O N N J 0 Co m m W O m W
CO (D A W N N j N m m 00) V N 0 - Cn m O m m
s A