Loading...
5.b Treasurer's Report November 2019City of Scandia Treasurer's Report SC � NDI � 11/30/2019 Beginning Balance 11/1/2019 $ 4,150,954.02 Receipts $ 52,999.21 Expenditures $ 344,230.38 Payroll $ 27,180.63 $ (371,411.01) Adjustments: Ending Balance 11/30/2019 $ 3,832,542.22 Ending Balance includes the following Investments: 17 Checking *102 $ 39,796.98 I�,0I ,Q Money Market *105 - Rate .25% $ 1,824,071.65 CD *2920/4426 - Rate 2.50% 12 mo., 1/29/2020 $ 523,822.15 CD *4422 - Rate 2.50% 12 mo., 3/25/2020 $ 309,569.81 CD *4424 - Rate 2.00% 12 mo., 7/25/2020 $ 432,154.59 CD *4425 - Rate 1.75% 12 mo., 9/28/2020 $ 717,664.73 Total Undesignated Funds $ 3,847,079.91 Checking Account *3102 Checks in Transit $ (11,809.74) Transfer to EDA correct cash account *105 Deposit in transit $ (2,678.45) Adj: Refund permit $ (49.50) Total Undesignated Funds $ 3,832,542.22 Scandia EDA *6301 $ 16,789.34 Receipts Expenditures $ (3,130.00) Checks in Transit Deposit in Transit Total Designated Funds $ 13,659.34 Total Funds $ 3,846,201.56 Submitted by: Colleen Firkus, Treasurer City of Scandia �T r Expenditure Summary S1.�[�'� 17�.� � DIA $473,133.00 $471,419.01 November -19 $1,713.99 99.64% CAPITAL IMPROVEMENTS $224,200.00 $171,604.94 $12,47350 $52,59506 7654% ROAD CONSTRUCTION $0.00 $0.00 2019 YTD Budget % of YTD GENERAL FUND 2019 YTD Budget 2019 YTD Amount 2019 MTD Amount Balance Budget Administration & Finance`* $791,862.00 $774,171.22 $25,931.63 $17,690.78 97.77% City Council $31,000.00 $25,230.49 $1,10076 $5,769.51 81.39% Elections $2,200.00 $830.00 $000 $1,370.00 37.73% Planning & Building $119,200.00 $110,816.89 $11,164.23 $8,38311 92.97% Police $136,000.00 $68,127.51 $000 $67,872.49 50.09% Fire Department $262,400.00 $235,982.77 $55,57004 $26,41723 89.93% Public Works $661,000.00 $517,356.65 $38,150.76 $143,643.35 78.27% Parks & Recreation $85,100.00 $60,298.14 $1,73621 $24,801 86 7086% Community Center $49,800.00 $34,965.43 $3,25916 $14.83457 70.21% Total General Fund $2,138,562.00 $1,827,779.10 $136,912.79 $310,782.90 85.47% EDA $80000 $10,190.00 $3,13000 -$9,390.00 1273.75% CABLE TV $22,20000 $17,265.59 $000 $4,934.41 77.77% GATEWAY DONATIONS $0.00 $0.00 $0.00 $0.00 0.00% DEBT 2007 ROAD PROJECT BOND $0.00 $0.00 $0.00 $0.00 0.00% 2013 EQUIPMENT CERTIFICATES $62.91800 $62,912.50 $3,420.00 $550 99.99% 2015 EQUIPMENT CERTIFICATE $44,941.00 $43.94600 $0.00 $99500 9779% 2017 EQUIPMENT CERTIFICATE $35,636.00 $35,328.00 $0.00 $308.00 99.14% 2018 BLACKTOP $329,638.00 $329,232.51 $212,912.51 $405.49 9988% $473,133.00 $471,419.01 $216,332.51 $1,713.99 99.64% CAPITAL IMPROVEMENTS $224,200.00 $171,604.94 $12,47350 $52,59506 7654% ROAD CONSTRUCTION $0.00 $0.00 $000 $0.00 PARK CAPITAL IMPROVEMENTS $207,24000 $112,539.91 $4,734.65 $94,700.09 54.30% EQUIPMENT REPLACEMENT $73,00000 $72,421 26 $4,384.43 $578.74 9921% LOCAL ROAD IMPROVEMENT FUND $368,29000 $138,670.77 $4,009.50 $229,619.23 37.65% 201 SEWER FUND $137,525.00 $93,783.56 $16,484.58 $43,741.44 68.19% UPTOWN SEWER $21,397.00 $9,46854 $517.12 $11,928.46 44.25% Report Total $3,666,347.00 $2,925,142.68 $398,979.08 $741,204.32 79.78% co W W A A A A Aj W t� w N N N — T O O O O O O O O W N N O C N N co W A N W V O W V O W N z m C N r m T m 0 m m m m m m 0 m O G w T O O D O D c 0 0 O m D O m X O D C DO n C C C n � m D m Z 2 m D O E O m m m p n 1 D y m X 3 m 0 0 0 N m0 < r X T A m m m o 0 a X v m�� x" z to a r 0 n T T T m m Z D D D O m m m m m Z Z Z m m> ox A TD N EA A N69 60 (ten fA fA EA W Z O D OAI 69 W W (AD (JJI W N O (D EA EA W A O Z z OD O O V O N A O w W W a 1 m O W 69 N O TV O W OOO O co OD O V O O 40 69 69 T A — m EA fA fA W N fA ji A N N N O fA fA fA m A W O O A V W EA fA j O C A pN A V W W N O W � EA W N D A W OD N N ID O W N A O W w N W co W to O V (D fA O W O W V W tD M V to W W V V A O O N co A O O W V H fA EA A 69 fA H EA fA EA — A N N O 69 EA V) W 3 N W A V V EA j (n a (n N N tD (A (A 00 (n W N A W (D O A N A O w W A V W W W V W EAO W O V V W CIO O W V A 00 O W N O V W x fA EA fA A fA EA FA EA O fA A N � W EA EA 69 N A W fA O A V O V fA N W D 01 O 00 A W W W W N O (D 19 t9 w O O to N O j W tD A O N A O W V N N A WA V CD EA W O ID O V V O W W 22 W A V W W V N O W O (D N O O W W r fAf9 !A W EA EA EA FA V fA fA fA A N W_ fA 69 fA N_ co O w A V O A fA ? EA N W (D � CI V O tD V w W O W N A A W W (D O W V O EA W N O tD W V VW W D O W W A W V W O A O O A mo W w A 1 M EA EA W fA 69 EA 69 EA _ C) fA fA A N W EA fA FA co O 8 O W V O w -+ 69 W W O O W ) O OD W N O Oy) W A C iD V W O A W W W W N A A W V W W Z K) O) O V W EA W N O W W W V O N A N W V W O co O O A CD O O W OD m fA fA EA fA A fA fA fA V EA fA _ W N O EA EA f9 W W Oto s to O O O w 69 fA r2 OD W A O A W N D O w W W O fA fA O L N OD N (D W W W N W O O W W W A C coOv W (wit (W11 A O A (AD (Wn OD V (wD (Vn N fA EA EA A EA EA D A fA fA fA (n N O EA 19 EA N C to O(D tD O O O fA 69 69 EA j A N A A OD W N tD W t0 W W O EA N N W C O A W W N W N W O O W W V_ W A A N W O 0 W A W (D N W V .1t. W V N O W O N O W V O) O tD A O 1 y fA fA EA EA m A EA EA fA 1 m (�jJ1 �' O �' N '1 N N �' 69 69 f j 3 A A N O (D W (D W W O j 01 W N N O W N V O (O N W O O W 69 J W m W O (ODI A N O W O W (AO (WDI W v two N O W W X fA fA EA fA EA EA EA EA EA EA EA EA EA (A fA fA EA FA A O N O O n V W W o A A o O ( ND OD W (J UI W W 0 V OW V W . W N W O O W A V W m A A N t0 O O N O A W (D N W V W W W m GI N O W O W (O W (D O W V W O V W W A w fA fA fA EA EA EA EA EA EA EA EA EA EA EA f9 fA EA z w f co (n O tD m DA) (AJI V OWI O (D W _(ND W W W ao W :-4 3 N 0) V V i W W W O t0 W O W W W O W a O O V fD O W co (D A W V N O N m N O O W A