5.b Treasurer's Oct. 2017 ReportSCA DILA
Beginning Balance 10/1/2017
Receipts
Expenditures
Payroll
Adjustments:
Ending Balance
City of Scandia
Treasurer's Report
10/31/2017
10/31/2017
Ending Balance includes the following Investments:
Checking *102
Money Market *105 - Rate .25%
CD *3138 — Rate 1.20% 18 mo., 7/24/2018
CD *2920 — Rate 1.00% 12 mo., 1/24/2018
CD *2921— Rate 1.00% 12 mo., 12/19/2017
CD *4420 — Rate 1.00% 12 mo., 3/21/2018
Total Undesignated Funds
Scandia EDA *6301
Total Designated Funds
$ 3,651,540.72
$ 57,384.93
$111,773.55
$38,192.93
$ (149,966.48)
$ 24,595.16
$ 1,013,990.36
$1,109,902.44
$503,749.06
$ 401,388.49
$ 502,523.72
$ 4,745.47
$ 3,558,959.17
$ 3,556,149.23
$ 4,745.47
Checks in Transit $ (2,597.80)
Deposits in Recorded in November $ (6,580.00)
3rd Quarter State Surcharge Recorded in October $ 7,242.27
Total Funds
Submitted by: Colleen Firkus, Treasurer
$ 3,558,959.17
SCANDIA
City of Scandia
Expenditure Summary
October 2017
2017 YTD Budget
% of YTD
GENERAL FUND
2017 YTD Budget
2017 YTD Amount
2017 MTD Amount
Balance
Budget
Administration & Finance
$342,600.00
$278,106.42
$29,031 40
$64,493.58
8118%
City Council
$18,900.00
$14,80923
$4,481.32
$4,090.77
7836%
Elections
$1,300.00
$830.00
$0.00
$470.00
63.85%
Planning & Building
$149,000.00
$156,353.74
$32,005.71
-$7,353.74
10494%
Police
$120,500.00
$64,055.48
$0.00
$56,444.52
53.16%
Fire Department
$244,490.00
$155,43333
$44,518.31
$89,056.67
63.57%
Public Works
$1,371,800 00
$1,069,004 62
$40,388.86
$302,79538
77.93%
Parks & Recreation
$60,90000
$52,43912
$11,78534
$8,460.88
86.11%
Community Center
$40.20000
$29,551.80
$5,511.96
$10.648.20
73.51%
Total General Fund
$2,349,690.00
$1,820,583.74
$167,722.90
$529,106.26
7748%
EDA
$0.00
$32500
0
-$325.00
0.00%
DEBT
2007 ROAD PROJECT BOND
$77,00000
$79,317.56
$000
-$2,317.56
000%
2010 EQUIPMENT CERTIFICATES
$10,060.00
$10,17713
$0.00
-$117.13
101.16%
2011 EQUIPMENT CERTIFICATES
$8,294.00
$8,311.93
$000
-$17.93
10022%
2013 EQUIPMENT CERTIFICATES
$65,06300
$60,917.50
$0.00
$4,145.50
93.63%
2015 EQUIPMENT CERTIFICATE
$46,364.00
$46,41850
$0.00
-$54.50
10012%
2017 EQUIPMENT CERTIFICATE
$0.00
$2,500.00
$000
-$2,500.00
$206,781.00
$205,142.62
$0.00
$1,638.38
99.21%
CAPITAL IMPROVEMENTS
$266,700.00
$12,851.90
$6,131.90
$253,848.10
4.82%
PARK CAPITAL IMPROVEMENTS
$44,90000
$3,768.28
$000
$41,131 72
8.39%
EQUIPMENT REPLACEMENT
$438,000.00
$98,99250
$0.00
$339,007.50
22.60%
LOCAL ROAD IMPROVEMENT FUP
$50,000.00
$5,950.00
$000
$44,05000
1190%
201 SEWER FUND
$62,000.00
$50,87235
$3,490.49
$11,127.65
82.05%
UPTOWN SEWER
$15,40000
$11,087.35
$1,125.70
$4,312.65
72.00%
Report Total
$3,433,471.00
$2,212,073.74
$178,470.99
$1,221,397.26
$3.78
N N tb O A V Cn W N OJ CNII W C
M C N r m -0 0 m m m m m W m -0 ,n p
0 m o O Q D D 0 0 fJ 0 O 5; 0 C m
m O 0 c X M C C C C C C) D W Z
O
m r v n m
(� D
Z m 0O m '- m m m m m p = D
D z Z Z Z Z Z m OC r F"
m 0 -I X 0 0 0 0 0 N
O m K m X m m m m m O Z N
a J G' G
M m 0 0 0 0 0
m � -4 �
K
m
Z � cmi> w w 0 w
m0
zN
0x
wn>
N to to w ? to W to to to -I a �+
A CWT N c0 Oo N W O7 O tD ZW 69 J V co N N fA o co a oz WWO JJ Q
� W0� N xiAV N 0 00 O O O co A O O O cn
m
m
W to
CD to to a cci) t9 W fA b) W
iN0 A A � O aV CA yi W EA N O D c
0 O O O W O A 00 W W EAj O N
V O N M 0 A O fA W j N O 0 (T
c0 N 01W W O fA V O O
to (!3
N to to to
c0 to EA 0 0 b9 W fA fo O Pr
W CO W A W COO J O W (0T O a.Zl
N CO CT A (A W A 00 0 W O
O) W O W J ' O toO A to 69A CO to 0 o
W W O 0 J W Cl) O J O O O O N x
M
N fAfo 0) to
c0 to to CO (T fo W fA fo CO
CA c0 A ) ) ,c00 co ON) O W A A a
N N CO 00 O W O 00 Cn W J A
W W CT 00 W J A O fA O A fo to to (P to c0
W W N A V W W O V O O O O O O) r
to
N 69to to to
c0 lig J -4 O N A to to
A OD U) ) O) O O W O J A W 3
W A A O Cn co W 00 01
W0v OW N VO OOWco C)V 00 W O N O O O
N tf: to fo CA
A N fo 000 co-4
JO O N N A to W L
W O A W 0 CO O J A W C
N A A CAO W V O O to O A to 69 60 W 69 N Z
W s (T 0 V W W O J N O O O 0) O CA m
to to ffl
W 0 fo
J fA to N A to W to fA 0
c0 0 N OD O CO CT O W O J CT L
A V 00 A 0 N W co O W s N 00 C
co NOWW A0vCO CT 00 O A O O cn J O
V! fA to
Gfa
V fA to N W 69 W 69 to A C
OD m CT 00 OD O CO A O W c00 J N G)
NO 0 A N CO O W O O
N W co O
N V W O CV O O C
CO)
w IG9 to m
M
os t� to iv cin t� w T T w m
00 A N 000 O CO A N O W c�0 J N 3
c0 0 W Cn O W N N m
NA OW 00W j W N JCO O O Efl fo Cn A fA 0 m
A A W N O W A O O U) V O
W n
OD J 0 A 00 O CO (b N O W co J OD W W
10 W 0 0 WO (n O W N A m
N J CJ) N j 00 N A O co Cn A b9 W
c0 J O 0 W O O W A O O Cn V O V X