Loading...
5.b Treasurer's Report October 2020aug*4,City of Scandia Treasurer's Report SCANDIA 10/31/2020 Beginning Cash Balance 10/1/2020 $ 4,500,080.40 Receipts Checking $ 17,240.62 Transfers to Checking $ _ Receipts Money Mrkt $ 932,244.63 Receipts Investments $ 2,475.69 Expenditures $ 1,194,824.09 Payroll $ 33,903.73 Transfers t _ Total Disbursements $ (1,228,727.82) Adjustments Ending Cash Balance 10/31/2020 $ 4,223,313.52 Ending Balance includes the following Investments: Checking *102 Beg Bal $ 1,255,601.04 Credits $ 17,042.90 Debits $ (1,206,251.13) End Bal $ 66,392.81 Money Market *105 - Rate .25% Beg Bal $ 1,231,882.60 rate change from 1.25% Credits $ 925,360.45 Debits $ - End Bal $ 2,157,243.05 Investments CD *4422 - Rate .90% 12 mo., 3/25/2021 CD *4424 - Rate .30% 12 mo., 7/25/2021 CD *4425 - Rate 1.75% 12 mo., 9/28/2021 CD *4426 - Rate 1.60% 12 mo., 1/29/2021 Total Investments Total Bank & Investment Accounts Checks in Transit *3102 Deposit in transit checking Deposit in transit money market Total Adjusted Undesignated Funds $ 314,859.82 $ 439,056.14 $ 730,257.71 5 533,461.38 Scandia EDA *6301 Bal 10/31/20 $ 25,298.76 Receipts $ Expenditures $ Checks in Transit $ Deposit in Transit Total Designated Funds Total Funds Submitted by: Colleen Firkus, Treasurer $ 2,017,635.05 $ (25,039.29) $ 197.72 $ 6,884.18 $ 4,223,313.52 $ 25,298.76 ��T r SCA 1.!1nT .11 GENERALFUND Administration & Finance - City Council Elections Planning & Building Police Fire Department Public Works Parks & Recreation Community Center Total General Fund EDA CABLE TV GATEWAY DONATIONS DEBT 2007 ROAD PROJECT BOND 2013 EQUIPMENT CERTIFICATI 2015 EQUIPMENT CERTIFICATI 2017 EQUIPMENT CERTIFICATI 2018 BLACKTOP CAPITAL IMPROVEMENTS PARK CAPITAL IMPROVEMENT EQUIPMENT REPLACEMENT LOCALROADIMPROVEMENTF BIG MARINE SEWER FUND UPTOWN SEWER City of Scandia Expenditure Summary $1,816,414.00 $1,306,651.12 October -20 $509,762.88 71.94% $80000 $32500 $0.00 $47500 0.00% 2020 YTD Budget % of YTD 2020 YTD Budget 2020 YTD Amount 2020 MTD Amount Balance Budget $404,600.00 $000 $338,347,67 $33,154.43 $66,25233 83.63% $21,000.00 000% $13,986.99 $4,689.83 $7,01301 66.60% $6,40000 $43,99500 $5,916.64 $58.56 $48336 92.45% $131,40000 $34,54400 $83,216.68 $16,165.71 $48,183.32 63.33% $139,10000 $000 $69,768.49 $29.99 $69,331.51 50.16% $296,11400 $274,641.99 $195,894.36 $33,265.10 $100,219.64 66.16% $690,70000 4808% $492,686.43 $26,205.42 $198,013.57 7133% $77,60000 $256,00000 $79,65637 $16,369.42 -$2,056.37 102.65% $49,50000 $398,51561 $27,177.49 $2.093.83 $22,32251 54.90% $1,816,414.00 $1,306,651.12 $132,032.29 $509,762.88 71.94% $80000 $32500 $0.00 $47500 0.00% $8,92000 $3,16840 $60.04 $5,751.60 $0.00 $000 $000 $000 000% $0.00 $000 $0.00 $000 000% $66,560.00 $63,915.00 $0.00 $2,64500 9603% $43,99500 $43,49450 $0.00 $50050 9886% $34,94800 $34,54400 $0.00 $404.00 9884% $327.17500 $56,08251 $000 $271,092.49 1714% $472,678.00 $198,036.01 $0.00 $274,641.99 41.90% $430,00000 $206,75333 $175,116.80 $223,24667 4808% $81,620.00 $30,94312 $6,112.74 $50,67688 37.91% $256,00000 $93,49807 $000 $162,501 93 3652% $637,00000 $398,51561 $0.00 $238,48439 62.56% $240,90850 $159,72267 $3,72352 $81,18583 6630% $22,447 00 $7,14065 $15765 $15,306.35 31.81% Report Total $3,966,787.50 $2,404,753.98 $317,203.04 $1,562,033.52 N 00O O A A A A W W j W W N N N — m N O O O O O O --� -+ O W N O O C CilN N co O A OD J CT W J O O W Z m m c w r m m n w m m m w X 0 0 0 o 0 W T 5 O O D D0 O 0 m D O m D A O D c x -u O c c c � w W< z D rn w Z O Z -UR m z z z m m < r - c m m o v T -4 � -1 N OW m m K m m O m m m 0o D O r o * m m � x x x J O -mn o r D m m --i --i --iz r ;o O n m K m - D OZ m C/)z � cmn cmn cmn I m v= A A ICA L O D ()) 69 N E4 69 EA O N O EA EA N Z D N N N A (D O W � A EA 69 EA O W V m :N W ao J N m (D EA EA A C Z Z A N N m J N N N O N A (n W J 00 O D -4 m 4� O W J N OD W m � A (P 0) J (T .� O O OD J m C1) J m W A N J (31 W A A m m w EA w EA EA EA 0) o E9 rj _, W A N — A N O (n W j A EA 69EA W O W Of A W O (D OD V N m O 69 EA m N D O N 00 O W W (0 V CD (D 41 m W J ? 03 4� O W �2A N 0) W W co A (n 0) V N V X 0) CO co N O J O m W A N V m A O -� 69 EA fA EA V3 A A EA 69 �) 3 A N N A N EA A A j ? Efl 69 EA W t0 W Of J N (T N O J J 69 D N m (D 6A J A > 00 N N co N A () N (D A A m W J O N OO (O N O W OD W (J( A (h O J J ()) 0 N m O) (D C" N J O 00 W A N J 0) A N 2 69 69 69 69 A W EA 69 EA O EA i0 EA EA 0) o EA 69 !A O N cn j 69 0 � N m 6A69 O n A N O 0o W (p W N m O EA fD CJ) A O A Cn N O 00 J (D 0) A D) W J CT 0) V m CO W W (D O w W N O A m O J m A O w A i J J (D (o Cr A N J (n OD m r 69 EA EA 69 W W i T 69 O) 69 to EA W - - Ow wEA co O) N W j N OD N W j m EA N V A OD W J ? A N V J V O Do O W A OD V 00 W N O A W EA J W W D N i A W J V m V CD V ()) V O CT 00 EA EA 69 EA W W W EA W 69 EA 69 N 0 O &s fA 6fl 000 N N N 00 W O N W J W N m W EAW C O) 00 V m A co W J m J A W W J —4 N O N OD W w m 00 O 00 (7) N (D A OD 00 EA J W A z O O O co m W J A J m J A A O CA N m m fA 69 69 69 yw A A y) EA f9 <A V 6 9 �I EA 694&9 O EA U3 j CO N CD W N V U) m :4-4 O FA _ (n N O N O U) m J J N J A m EA CP C_ (D N O) W co Oo m N m W m m w Ln 69 O ? C w co w Cn A O co (D Oo J O J O J O J W W r N (D v (D O w 00 N s A m J N O Cn N O O -< W 69 0) EA ffl A o EA 69 W W C A N N W N EA j m A O EA kn _ 00 00 CP W O (T W 00 m V N J A ao � W A Gi -4 EA —4 O o 0o C N co N co j OD N m W 00 m O V O V CO J m O N O CO V J O m N O Cr m V N0 Ch C) O O � N A A � EA m N EA N V) 69 69 A O EA EA W N m N N O W N A A m A O EA EA N N Cn O O A N 00 OD n n N J A Cb EA A � co W W N O m O V (D W m N W M m aD C0 Cn {A J O m O (D O W O J O V (D J W co N m t0 (D O co J 00 � m N A N m J N O m O ao .� A En 69 EA ER EA EA Efl EA EA &H EA EA 69 EA 69 69 69 EA N oAo A O OD 0 Cn W (D A 00 90 O O N J ? 00 m O N N W (D Cn J O N N J 0 Co m m W O m W CO (D A W N N j N m m 00) V N 0 - Cn m O m m s A