7.b Treasurer's September 2020 Report'Ug, 1"
SCANDILA
m i n n c s n t a
Beginning Cash Balance 9/1/2020
Receipts Checking
Transfers to Checking
Receipts Money Mrkt
Receipts Investments
Expenditures
Payroll
Transfers
Total Disbursements
Adjustments
City of Scandia
Treasurer's Report
9/30/2019
$ 147,401.23
$ 41,812.98
$ 4,623,427.23
$ 37,012.79
$ 24,934.96
$ 3,919.63
$ (189,214.21)
Ending Cash Balance 9/30/2019
$ 4,500,080.40
Ending Balance includes the following Investments:
Checking *102
Beg Bal
$
1,411,453.49
Credits
$
37,012.79
Debits
$
(192,865.24)
End Bal
$ 1,255,601.04
Money Market *105 - Rate .25%
Beg Bal
$
1,206,947.64
rate change from 1.25%
Credits
$
24,934.96
Debits
$
-
End Bal
$ 1,231,882.60
Investments
CD *4422 - Rate .90% 12 mo., 3/25/2021 $ 314,859.82
CD *4424 - Rate .30% 12 mo., 7/25/2021 $ 438,723.19
CD *4425 - Rate 1.75% 12 mo., 9/28/2020 $ 730,257.71
CD *4426 - Rate 1.60% 12 mo., 1/29/2021 $ 531,318.64
Total Investments $ 2,015,159.36
Total Bank & Investment Accounts $ 4,502,643.00
Checks in Transit *3102 $ (2,562.60)
Deposit in transit $
Total Adjusted Undesignated Funds $ 4,500,080.40
Scandia EDA *6301 Bal 6/30/19 $ 25,298.76
Receipts $ -
Expenditures $
Checks in Transit $
Deposit in Transit
Total Designated Funds $ 25,298.76
Total Funds $ 4,525,379.16
Submitted by: Colleen Firkus, Treasurer
t City of Scandia
rExpenditure Summary
SCANDIA
Report Total $3,966,787.50 $2,087,550.94 $188,593.93 $1,879,236.56
September -20
2020 YTD Budget
% of YTD
GENERAL FUND
2020 YTD Budget
2020 YTD Amount 2020
MTD Amount
Balance
Budget
Administration & Finance"
$404,600.00
$305,19324
$41,399.04
$99,40676
75.43%
City Council
$21,00000
$9,297.16
$0.00
$11,702.84
44.27%
Elections
$6,400.00
$5,858.08
$70.67
$541.92
91.53%
Planning & Building
$131,400.00
$67,050.97
$7,085.42
$64,349.03
51.03%
Police
$139,10000
$69,738.50
$0.00
$69,361.50
5014%
Fire Department
$296,11400
$162,62926
$18,384.27
$133,484.74
54.92%
Public Works
$690,70000
$466,481.01
$100,406.90
$224,21899
67.54%
Parks & Recreation
$77,60000
$63,28695
$8,715.54
$14,31305
81.56%
Community Center
$49,500.00
$25,08366
$1.59672
$24,416.34
5067%
Total General Fund
$1,816,414.00
$1,174,618.83
$177,658.56
$641,795.17
64.67%
EDA
$800.00
$32500
$000
$47500
0.00%
CABLE TV
$8,92000
$3.10836
$2785
$5,811 64
GATEWAY DONATIONS
$0.00
$000
$000
$000
0.00%
DEBT
2007 ROAD PROJECT BOND
$000
$000
$000
$000
000%
2013 EQUIPMENT CERTIFICATI
$66,56000
$63,915.00
$000
$2,64500
96.03%
2015 EQUIPMENT CERTIFICATI
$43,995.00
$43,494.50
$000
$500.50
98.86%
2017 EQUIPMENT CERTIFICATI
$34,94800
$34,54400
$000
$404.00
9884%
2018 BLACKTOP
$327,175.00
$56,082.51
$0.00
$271,092.49
1714%_
$472,678.00
$198,036.01
$0.00
$274,641.99
41.90%
CAPITAL IMPROVEMENTS
$430,000.00
$31,63653
$1,33300
$398,36347
736%
PARK CAPITAL IMPROVEMENT
$81,62000
$24,83038
$616.29
$56,769.62
3042%
EQUIPMENT REPLACEMENT
$256,000.00
$93,49807
$0.00
$162,501.93
3652%
LOCAL ROAD IMPROVEMENT F
$637,00000
$398,51561
$3,79500
$238,48439
6256%
BIG MARINE SEWER FUND
$240,908.50
$155,999 15
$4,319.18
$84,90935
64.75%
UPTOWN SEWER
$22.44700
$6,983.00
$844.05
$15,464.00
3111%
Report Total $3,966,787.50 $2,087,550.94 $188,593.93 $1,879,236.56
N 00 O 0 A A A A W W O W N O O T
CNn
NN W A Cb V (n W J O CD W C
Z
m m c W r m M n W m m m W X n 0 O 0
D n O O p m C C C W O< Z
A o> D> m o
z m x m D r O m m m O >r-
w2
uD D z -OR M Z Z Z -om
N m n
W � 0 0 X � � w n n n O 0 r
0 N
0 m m m O x m Z -' O � o g
D m A rr m -i -i -i z
r D O D n T �n T
r m m D D D O
m m �
m m m
m
z z w w w
�
mn
zN
v=
o®
;) -n n
a? EA D 3 r
N ffl m fA fA Efl (A N O EA 69 j Z o D
N N N A co O W j A
O W V (A D A W Cb V N (D y) {A 00 D Z n
A N N CA V N N_ N W N A_ 0 W J O (D m
CD CD OODD V 0 cn V 000 W A N W CJn W N = N
T
EA EA m
A A fp EA i W
EAfA
N Z1
A N A N CD mW0.� A EA EA C
O W m A
WP (D O V N (A O EA EA 0 D
O N 00 co W W O V (D CD A Cn W V A
A O W A N a) 00 W O A
Ln 0 V N J
0 m co N O V O 00 W A N V j cn A O
A ' Efl EA
Efl EA Efl 512
O
A N N A N EA A A j A -4 K) a) D
10 W O) J N U) N O V V N CA (O Efl 69-4
00 N N O N A (n N O A A cn W J (D N
O CO O N 0 W co W Cil s A Ln Cr V V Cn
N C9) m CD cn —� N J CD m W A N J (n A N =
w w EA EA
A W EA G9
'GA
Va CD
N COO (fin N E9 W p 0 (2 N CA &9 EA 0 D
O 00 W 00 W N CA (D EH b9 (n y
A CD A
cn N O 00 V (D m ? cn W —I (n 0 M
V 00 00 W CD O 00 W N CD A Cn CA V cn A
p (O A V V (D CD (n A N J Cn OD 0 r
ER &i VJEA
W W 69 fA GA
C" EA W fA ffl G9 W O EA b9 EA fA OD
mN W N W (Ii W i 0 EA N A
O N V A A w W W N (A O EA
A W m V A A fJ V V A CJ o) V
-4 CD N A Wv-4 VvwvOWD
6) 0 Ui V O L, co
W
EA W Efl EA EH
W fA W Efl EA Efl N O 69Efi EA to w0
m N A W N m 0 W 0 .A N A � O L
<JI N N O W O N W V W NCA W EA C
0) Oo N Cn A (D W V m J A w w J N O Z
N (b W Cb CP Cb CD m Ln N W A O 00 EA J W A
p (O O O 0 W J A V Ln V A A O Ln N m m
EA E�
A A EA EflEAtR
V G9 V EA EA A O
w N m W N EA CT CA A O Efl 4fl C) 0
V Cn N O N O (n m J J N J A m EA C
(O N m W CD Oo CA N 0 W m W w Cn EA j O A
(O O CO L" A O co CDC0 V O V O V cD J 0 w r
N (D V co co 00 00 N -+ A (A J N O (n N O O
69 EA EA
A A
EA EA O EA Efl W W C
IQ 1.6EA w AW
m p O Cn W 2 00 Ln V N J A 00 EA W 0 C)
V C
N A 0 O V 00 N (D 0 00 w 0 EA O O wN (D N CD W N O w Cn O V O J CD V (DN
m O V V O m N O CT CA V N O (Ji O O
cn
m
j, 469A A Efl EA EA
N Efl N Efl EA EA A O EA EA W rN m
N N O W N A A (A A O EA EA
N Cn O O A N Oo 00 (r Cn N J A oo A 00
W N O 0) O N W Oo m co 00 01 EA V O
O CD CD j O m N O J O V (D V W OD N m
V (D QD
w (D O O J OD N A N CA J N O Cn 0 O M �1