Loading...
5.b Treasurer's Report March 20191"Mq, .SCAM PW r Beginning Balance 3/1/2019 Receipts Expenditures Payroll Adjustments: City of Scandia Treasurer's Report 3/31/2019 $ 97,734.81 $ 31,872.22 $ 4,234,436.52 $ 50,516.14 $ (129,607.03) Ending Balance 3/31/2019 $ 4,155,345.63 Ending Balance includes the following Investments: Checking *102 Money Market *105 - Rate .25% CD *2920/4426 - Rate 2.50% 12 mo., 1/28/2020 CD *4422 - Rate 2.50% 12 mo., 3/25/2020 CD *4424 - Rate 2.40% 12 mo., 7/25/2019 CD *4425 - Rate 2.50% 12 mo., 9/28/2019 Total Undesignated Funds Scandia EDA *6301 Total Designated Funds Checks in Transit Deposits in Transit Further HSA reversed Total Funds Submitted by: Colleen Firkus, Treasurer $ 22,277.32 $ 2,164, 510.74 $ 514,148.23 $ 305,740.74 $ 424,989.53 $ 708,704.97 $ 17,459.07 $ 4,140,371.53 $ 17,459.07 $ (2,481.97) S $ (3.00) $ 4,155,345.63 w� City of Scandia Expenditure Summary 10 } 1 'a k_s as �. March-19 2019 YTD Budget % of YTD GENERAL FUND 2019 YTD Budget 2019 YTD Amount 2019 MTD Amount Balance Budget Administration & Finance $352,90000 $73,845.94 $23,289.17 $279,054.06 20.93% City Council $31,000.00 $5,515.32 $130.00 $25,484.68 17.79% Elections $2,200.00 $830.00 $0.00 $1,370.00 37.73% Planning & Building $119,200.00 $20,022.28 $9,190.26 $99,177.72 16.80% Police $136,000.00 $30936 $0.00 $135,690.64 0.23% Fire Department $262,400.00 $67,664.31 $27,654.98 $194,735.69 25.79% Public Works $661,000.00 $148,77550 $44,852.86 $512,224.50 22.51% Parks & Recreation $83,100.00 $23,459.98 $4,805.73 $59,640.02 28.23% Community Center $49,800.00 $9,214.92 $2,44423 $40,585.06 18.50% Total General Fund $1,697,600.00 $349,637.61 $112,367.23 $1,347,962.39 20.60% EDA $80000 $0.00 $0.00 $800.00 0.00% CABLE TV $7,300.00 $000 $0.00 $7,300.00 GATEWAY DONATIONS $0.00 $0.00 $000 $0.00 0.00% DEBT 2007 ROAD PROJECT BOND $0.00 $000 $0.00 $0.00 0.00% 2013 EQUIPMENT CERTIFICAT $62,91800 $0.00 $0.00 $62,918.00 0.00% 2015 EQUIPMENT CERTIFICAT $44,941.00 $0.00 $0.00 $44,941.00 0.00% 2017 EQUIPMENT CERTIFICAT $35,636.00 $1,664.00 $0.00 $33,972.00 467% 2018 BLACKTOP $329,63800 $0.00 $000 $329,638.00 0.00% $473,133.00 $1,664.00 $0.00 $471,469.00 0.35% CAPITAL IMPROVEMENTS $198.00000 $41,13737 $8,561.00 $156,862.63 20.78% ROAD CONSTRUCTION $0.00 $0.00 $0.00 $0.00 4DIV/0! PARK CAPITAL IMPROVEMENI $163,520.00 $8804 $29.37 $163,431 96 0.05% EQUIPMENT REPLACEMENT $73,000.00 $0.00 $0.00 $73,000.00 0.00% LOCAL ROAD IMPROVEMENT I $66,000.00 $2,836.50 $2,836.50 $63,163.50 4.30% 201 SEWER FUND $137,52500 $10,489.55 $3,49306 $127,035.45 7.63% UPTOWN SEWER $21,397.00 $2.831-743 $612.10 $18,559.57 13.26% Report Total $2,838,275.00 $408,690.50 $127,899.26 $2,429,584.50 CASH BALANCES 2019 END OF MONTH FUND JANUARY FEBRUARY MARCH 101 GENERAL $1,620,605 $1,452,297 $1,355,921 225 EDA $14,839 $21,313 $21,313 226 CABLE TV $6,302 $6,666 $8,167 230 RESTRICTED DONATIONS $175 $175 $175 307 BLACKTOP 2007 $164 $164 $172 313 EQUIPMENT CERTIFICATES $19,059 $19,059 $19,059 315 EQUIPMENT CERTIFICATES $15,495 $15,495 $15,495 317 EQUIPMENT CERTIFICATES -$2,201 -$2,201 -$2,201 401 CAPITAL IMPR $581,181 $568,810 $575,410 402 ROAD CONSTRUCTION $0 $0 $0 404 PARK CAP IMPR $118,585 $251,594 $251,564 406 EQUIPMENT REPLACEMENT $275,777 $276,977 $276,977 408 LOCAL ROAD IMPROVEMENT $1,449,555 $1,447,207 $1,444,363 602 201 SEWER $108,142 $104,598 $115,480 612 UPTOWN SEWER $8,131 $12,893 $12,281 801 ESCROW $31,058 $59,389 $61,170 TOTAL $4,246,868 $4,234,437 $4,155,346