5.b1 Treasurer's Report Dec. 2019RAO MCI , 464
City of Scandia
Treasurer's Report
12/31/2019
Beginning Balance 12/1/2019 $ 3,832,542.22
Receipts $ 1,058,488.80
Expenditures $ 211,675.95
Payroll $ 28,653.39
$ (240,329.34)
Adjustments: Transfer EDA receipts to EDA Cash Account $ (9,979.00)
Ending Balance 12/31/2019 $ 4,640,722.68
Ending Balance includes the following Investments:
Checking *102
Money Market *105 - Rate .25%
CD *2920/4426 - Rate 2.50% 12 mo., 1/29/2020
CD *4422 - Rate 2.50% 12 mo., 3/25/2020
CD *4424 - Rate 2.00% 12 mo., 7/25/2020
CD *4425 - Rate 1.75% 12 mo., 9/28/2020
Total Undesignated Funds
Checking Account *3102
Checks in Transit
Transfer to EDA correct cash account *105
Deposit in transit
Adj: Refund permit
Total Undesignated Funds
Scandia EDA *6301
Receipts
Expenditures
Checks in Transit
Deposit in Transit
Total Designated Funds
Total Funds
Submitted by: Colleen Firkus, Treasurer
$ 37,740.19
$ 2,631,075.22
$ 523,822.15
$ 311,499.32
$ 432,154.59
$ 720,713.33
$ 4,657,004.80
$ (6,253.62)
$ (9,979.00)
$ (49.50)
$ 4,640,722.68
$ 13,659.34
$ (758.78)
$ 9,979.00
$ 22,879.56
$ 4,663,602.24
City of Scandia
i f Expenditure Summary
SCANDIA
December -19
2019 YTD Budget % of YTD
GENERAL FUND 2019 YTD Budget 2019 YTD Amount 2019 MTD Amount Balance Budget
Administration & Finance" $791,86200 $796,239.59 $22,06837 -$4,37759 10055%
City Council $31,00000 $25,23049 $000 $5,769.51 81.39%
Elections $2,20000 $83000 $000 $1,370.00 3773%
Planning & Building $119,200.00 $121,96221 $11,145.32 -$2,76221 10232%
Police $136,000.00 $135,94566 $67,81815 $5434 99.96%
Fire Department $262,400.00 $251.21729 $15,234.52 $11,182.71 9574%
Public Works $661,00000 $569,82084 $52,46419 $91,17916 86.21%
Parks & Recreation $85,100.00 $68,031.81 $7,733.67 $17,06819 79.94%
Community Center $49,800.00 $43,096.70 $8,131 27 $6,703.30 86.54%
Total General Fund $2,138,562.00 $2,012,374.59 $184,595.49 $126,187.41 94.10%
EDA $80000 $10,948.78 $758.78 -$10,14878 136860%
CABLE TV $22,200.00 $16,656.02 $1,39043 $3,543.98 64.04%
GATEWAY DONATIONS $000 $000 $0.00 $000 0.00%
DEBT
2007 ROAD PROJECT BOND $0.00 $0.00 $0.00 $000 000%
2013 EQUIPMENT CERTIFICATES $62,918.00 $62,912.50 $3,42000 $5.50 99.99%
2015 EQUIPMENT CERTIFICATE $44,941.00 $44,440.50 $49450 $500.50 9889%
2017 EQUIPMENT CERTIFICATE $35.63600 $35,328.00 $0.00 $306.00 9914%
2018 BLACKTOP $329,63800 $329,23251 $000 5405.49 9988%
$473,133.00 $471,913.51 $3,914.50 $1,219.49 99.74%
CAPITAL IMPROVEMENTS $224,20000 $173,646.44 $2,04350 $50,551.56 7745%
ROAD CONSTRUCTION $000 $0.00 $000 $0.00
PARK CAPITAL IMPROVEMENTS $207,240.00 $125,121.91 $12,58200 $62,118 09 60.36%
EQUIPMENT REPLACEMENT $73,000.00 $75,961 26 $3,540.00 -$2,961 26 10406%
LOCAL ROAD IMPROVEMENT FUND $368,290.00 $154,22527 $15,554.50 $214,064.73 41.88%
201 SEWER FUND $137.52500 $102,25783 $8.47427 $35,26717 7436%
UPTOWN SEWER $21,39700 $10,47336 $1,004.82 $10.923.64 46.95%
Report Total $3,666,347.00 $3,155,580.97 $233,858.29 $510,766.03 86.07%
OD O O A A A A A W w W W W N N N 71
O 1 O O O O O O s 1 W O W N N O C
N N O O) A N W J N W V O O) No Z
m C N r m v zl (� m m m m m w 0 m c) o
(n O O D O D O O A 1; m D o m
O D C OD C1 C C C n D m
Z m D O O m m m O n
i O m oz z K v ZZZ
T m ommmo
X -0m C O v
a X X O
tm zX O 0 0T T Z 1
m M F3 DDD K z
M
z
N
Z ? m m
A
m
2y
O=
to fA n O
fA fA fA fA ` T D
N EA A N _ Z O D
W OOD (AD (Vl) 00 W N 0 O fA V)0) A O D � n
N v
OD O (n N A O w OD O) m
O) (n� A N V 0o fA W O (D W O7 V O W O �
co OO N m J 0 O 0 0 A M N (O N = V%
W fA fA T
P fA — m
'AA EA fA fA
W69 fn O A V Q1 fA fA N OA)
A lD N A V O) W N N V) EA EA W N C
a w o) (n N (D (n aD N A O O) N)
W DD (O (D O V (D fA 21D (n - V D) W A
V (O W co J V A O O (n co A (n 0) W V
fA fA FA
A fA fA w fA
EA fA _— A N N (n fA fA fA W 3
N N (n A OVi N N N O) fAfA O � (n >
Ln
W — N A W w (n A N A0 — w W n
A V OD CO D) V O) (A O CO N V V W
OI O O W V A O O N to N N V W m
fA fA fA
A fA fA 69 fA
O fA A N 0) FA EA fA N
A 0) fA O A V N VfA N O D
01 O w A W 4) W O N 0) co fA (O O O
(D N N CnO) W A0 N A O O V N 22
N A 0) A V (D fA O O (D 0) V V (D) (D W
W A V w OD V N O D) (n (D N N N W DO r
fA fA fA
W fA E9 fA fA
V fA fA 6, ? N 0) fA 61(A N
O ut (D A V N A fA A fA N
W (D V N O W N D) N Sn O (D O O 3
0 J N (D V co OD O W N A A N V A_
W w O (n OD V O fA O N O (D W V V OD O D
O W co A W V W O A O N A N N O W A j
VP fA EA
w fA fA fA fA fA _
O) W EA A N 0) fA FA fA
co N O CO V NW fA A to W
W ) O N W ) O ao W N N O�q O'y (D A C
t0 V W O A w O 0) W N A A W V ao W Z
N) W(n V 0) fA O) N O O W W V O N
A N D1 J W O OD O N A (D N O W Qo m
N E2 fA fA
A fA fA fA
V fA fA _ O) N O fA fA fA W
W N O N Ut (n 69 69 H) N co
01 A O A O) N OD O O 0) W U1 fA fA O L
N m N O OD W W N W N U1 W OD W A C
O) O A N W (D V fA A aD O N W V O r
ao V W W 0) A O A (D (n W V (D 0) (n A O
fA fA fA fA
p a
A W fA W O N - O W fA N C
(O fn O O w ( fn n N N fA fA fA fA N A
N A A m W N O O) O7 O) W (n N N C
O A 2 N 8 W N W N O W W 01 V
j A N fA OO A ao O N W 4 A N
W V N 0 W O O N OD V O (n O A O —f
N
tR fA GN y
A fA fA EA T
ca 69 fA N O fA fA fA m
CO U) O (n D1 (n (n 6A b9 fA 3
A A N (n O O O) O) W (n j 0) W
K) N O w V O w N OD (n N W fA V m
W O m . N O 0) 469
w (AD ((n OOD J (WO 0 O (mD W 17
fA f/) f9 fA f/) fA fA fA fA ffl fA fA fA fA fA fA fA iA
A O
V W W O A A O OO O 01 W (n W DD O
V N O J -+ O i W N w 0 0 w A vw W
A A N (O N N N 0) A OV co N Cl) V m W O) m
W N O W O OD O 0) w OD w w V (D O)
fA fA fA fA 'A fA fA fA fA fA fA fA fA fA fA fA fA fA
Z
w O
0o in N — o m <
A m
O) ut V O)
O O a O W O V fD O A W V N N N m
N
00 m A A fn OG)0o(0 OD N A cn oD s O N N O O X
N fA fA fA fA fA fA 69 fA fA fA fA E9 fA 69 fA V) fA o
m
A n
O) 01 N O A m
O) A OD A N A Cl) .. N O 3
W W 0) (DW W (O W fD OI (D W N 0) W
W N A0 N V O V N N w V W N O w m
O � w N OD (n W W A J (n 0) W V W W O
N (n 0 V O V v v N V W (n A 0 N