Loading...
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