5.b Treasurer's Report Dec. 2017m in n c s o t a
Beginning Balance
Receipts
Expenditures
Payroll
Adjustments
Ending Balance
12/1/2017
Tax Settlement
VISA rewards
delete old checks
12/31/2017
City of Scandia
Treasurer's Report
12/31/2017
Ending Balance includes the following Investments:
$ 160,191.33
$ 23,992.09
$ 3,381,700.73
$ 80,072.55
$ (184,183.42)
$ 1,042,465.60
$ 825.00
$ 27.20
$ 4,320,907.66
Checking *102
$
118,609.59
Money Market *105 - Rate .25%
$
1,708,589.89
transfer in transit
$
(4,646.42)
CD *3138 — Rate 1.20% 18 mo., 7/24/2018
$
1,109,902.44
CD *2920 — Rate 1.00% 12 mo., 1/24/2018
$
503,749.06
CD *4420 — Rate 1.00% 12 mo., 3/21/2018
$
503,776.59
CD *4421— Rate 1.35% 9 mo., 9/19/2018
$
402,496.98
Total Undesignated Funds
$
4,342,478.13
Scandia EDA *6301
$
4,745.47
deposit in transit
$
4,646.42
Total Designated Funds
$
9,391.89
Checks in Transit
$
(56,511.71)
Deposits in Transit
$
25,549.35
Total Funds
$ 4,320,907.66
Submitted by: Colleen Firkus, Treasurer
*4
City of Scandia
SCANDIA Expenditure Summary
December 2017
2017 YTD Budget
% of YTD
GENERAL FUND
2017 YTD Budget
2017 YTD Amount
2017 MTD Amount
Balance
Budget
Administration & Finance
$342,600.00
$324,213.50
$17,875.65
$18,386.50
94.63%
City Council
$18,900.00
$14,809.23
$0.00
$4,090.77
78.36%
Elections
$1,300.00
$1,765.24
$29.74
-$46524
135.79%
Planning & Building
$149,000.00
$194,892.25
$18,695.75
-$45,892.25
130.80%
Police
$120,50000
$64,055.48
$0.00
$56,444.52
53.16%
Fire Department
$254,030.00
$192,189.23
$9,676.64
$61,840.77
75.66%
Public Works
$1,371,800.00
$1,188,643.22
$81,162.16
$183,156.78
86.65%
Parks & Recreation
$60,900.00
$61,763.90
$4,443.21
-$863.90
101.42%
Community Center
$40,200.00
$33,968.03
$1,811.67
$6,231.97
84.50%
Total General Fund
$2,359,230.00
$2,076,300.08
$133,694.82
$282,929.92
88.01%
EDA
$0.00
$325.00
0
-$325.00
0.00%
DEBT
2007 ROAD PROJECT BOND
$77,000.00
$79,317.56
$0.00
-$2,317.56
0.00%
2010 EQUIPMENT CERTIFICATES
$10,060.00
$10,177.13
$0.00
-$117.13
101.16%
2011 EQUIPMENT CERTIFICATES
$8,294.00
$8,311.93
$0.00
-$1793
100.22%
2013 EQUIPMENT CERTIFICATES
$65,063.00
$65,492.50
-$429.50
10066%
2015 EQUIPMENT CERTIFICATE
$46,364.00
$46,418.50
$0.00
-$54.50
100.12%
2017 EQUIPMENT CERTIFICATE
$0.00
$2,500.00
$0.00
-$2,500.00
$206,781.00
$209,717.62
$0.00
-$2,936.62
101.42%
CAPITAL IMPROVEMENTS
$266,700.00
$13,641.52
$253,058.48
5.11%
PARK CAPITAL IMPROVEMENTS
$44,900.00
$3,768.28
$0.00
$41,131.72
8.39%
EQUIPMENT REPLACEMENT
$438,000.00
$195,093.15
$37.65
$242,906.85
44.54%
LOCAL ROAD IMPROVEMENT FUP
$50,00000
$33,462.00
$27,512.00
$16,538.00
66.92%
201 SEWER FUND
$62,000.00
$59,856.84
$3,302.70
$2,143.16
96.54%
UPTOWN SEWER
$15,400.00
$12,662.78
$882.62
$2,737.22
82.23%
Report Total
$3,443,011.00
$2,607,327.27
$165,429.79
$835,683.73
$4.93
N N 000 00) A V fn W N OJ (n w C
m C N r m T 0 m m m m m w m T O a
(n T o O 0 D D O O D 0 O � o C m
0 -1 0 C x T C C C C C D y Z
0 * m n y v v v v (7
Z m 0 m r m m m m m
U) x o z z z z z z T c F
o T X 0 0 0 0 0 o
a v v " -4
O
m m D D D D n
M
Z ai ai ai umi ai
-6
ms
2 y
OS
40
w fA O o0
Ta
N69 fA W A w W EA fA fA V Z 3 5
W (/1J V (0 N N fA V fA O
0) N O W (O O N W DD O (0 N V s Z 0
W N O W N W m W N N O O A
V A N W 0) OD 0) (A N O O O 0) O V 69 W = m
V N 0) (n Cl) O 0 A OD O O O ) O N O O 01 fA
6A �69 T
w m
O 69 fA A (ten j W 4) W
INO A A V !D V W EA W 'A 469
(�1) OND a
00 O W O W O A WW W to O
V fA N
O W W j j j N t (0 fA a)
OJ N NN W WO O OD V 0 O
H fA
N fA 169 fA
i0 fA'AO (T fA W fA fA O 3
W OJ W A W (0D V ) O W VP Ow)
w N A N W A W (n W O n
O W D) w V j O fA O j fA 69 fA (D fA W
W W O Q7 V w W O J O O O O N S
H
N fA fA fA fA
i0 fA 69 w m 6N w 62 69 N
N co A OJI (0D 00 W O W A co
W W (wn co W V A co EA O A fA 6A 69 OJ) 6N (AD A
W W N A J W -� w O J O O O a) O W r
M
N 6A fA 6A fA
V fA 69 O) NfA W fA Z900
(0 EA V V O N A f9 O
A 00 0)O1 01 (0 O W o J A W 3
A A O) (n W (J 00 (nV N
W V O) W V (0 O 69 O A fA W fA 0) fA W
n J a
( W V W W O V N O O O 0) O W
a
N 69 69 69 d)
M (A fA to (n 6A (a 6A Z) V
W O 0 0 T O WAJ )0 V A
CA
AACl JW(n (D W V .9O A6AEAAO) A Z
W N N V W W O V N O O O O O
0) m
N fA T
W 6A iA
V fA N A W
fA
0)
O W 6 6A
A
(0 O_N V 00 V
) N DDD O OJ U1 O W (0 V N L
W W (0J (Ai) W W N fA coW6A fA (n A W r
(D O N OD V O W A O O (n J O
fA fA fA
w � FA
V b) fA W EA W FA FA A
00 d! J a) m W W f9 V) A
00 W 0) O OD O O A O w (0 J N
O (OD) O W A NV 6A (wD Ifl EA N A 6A OJ y
N N W J -� W N OW
A OOM V O O 1
y
m
w y fA-1
cn 69 N N 1 W c� <� (J m
fA V 0 JW fA 69 64 V 3
W A N W O V) A N O W OD J N W
N
A OD OD j OD N V O (O
WOO(n A 6A O m
A A W N O W A-4 O N V O ;a
W n
fn _ N N W N 1
N V 0 V N -+ OD
OD V W A O O fD DD N O W U) V W O
W
10 W N m W � w 0 O W -+ N A m
N V N N j 00 N A O (D V) A 69 W
(0 V O 0) W O O W A O O Ut V O V A
Z
w
W N A w IV m
m V A 000 A 07 co N O J (0 V A W
V (0 w — m w O 0 O (0 -� N m m
O W O j N C2 O 01 N A 6A 0)
0) A0 aD W O W co (n V O O M
O
m
A n
N m
W OAD VA ((nn �+
O V A W A (D N V W N W
(D A OW N N O in O A 0) W UD m
O W C2 (D N W A O O V (D (0 fA ;Mu00 0 O 00 O W 0 0 0 A0
0
N N 0 J