Loading...
5.b Treasurer's April 2019 ReportBeginning Balance 4/1/2019 Receipts Expenditures Payroll EDA Expenditures City of Scandia Treasurer's Report 4/30/2019 $ 105,487.35 $ 38,329.26 $ 4,155,345.63 $ 35,910.69 $ (143,816.61) Adjustments: JE duplicate HSA expenditure $ 3.00 Tranfer EDA cash to separate account $ (21,313.34) Ending Balance 4/30/2019 $ 4,026,129.37 Ending Balance includes the following Investments: Checking *102 Money Market *105 - Rate 1.25% CD *2920/4426 - Rate 2.50% 12 mo., 1/29/2020 CD *4422 - Rate 1.90% 12 mo., 3/21/2019 CD *4424 - Rate 2.40% 12 mo., 7/25/20198 CD *4425 - Rate 2.50% 12 mo., 9/28/2019 Total Undesignated Funds $ 30,609.09 $ 2,049,315.26 NEW RATE $ 517,317.64 $ 305,740.74 $ 427,504.54 $ 708,704.97 $ 4,039,192.24 Checks in Transit $ (9,208.60) Transfer EDA cash to separate account $ (21,313.34) Transfer prior revenue from *102 checking to EDA *6301 $ (3,334.27) Scandia EDA *6301 $ 21,313.34 Receipts $ - Expenditures $ (195.00) Checks in Transit $ (325.00) Total Designated Funds Total Funds Submitted by: Colleen Firkus, Treasurer $ 20,793.34 $ 4,026,129.37 r City of Scandia Expenditure Summary SCANDIA April -19 2019 YTD Budget % of YTD GENERAL FUND 2019 YTD Budget 2019 YTD Amount 2019 MTD Amount Balance Budget Administration & Finance $352,900.00 $105.77617 $31,930.23 $247,123.83 29.97% City Council $31,000.00 $10,195.07 $4,679.75 $20,80493 3289% Elections $2,200.00 $83000 $000 $1,37000 37.73% Planning & Building $119,200.00 $28,94055 $8,918.27 $90,259.45 2428% Police $136,00000 $30936 $0.00 $135,690.64 023% Fire Department $262,400.00 $84,501.74 $16,83743 $177,89826 3220% Public Works $661,00000 $195,370.23 $46,59473 $465,629.77 29.56% Parks & Recreation $85,10000 $26,787.30 $3,327.32 $58,312.70 3148% Community Center $49,800.00 $15,572.94 $6,358.02 $34,22706 31 27% Total General Fund $1,699,600.00 $468,283.36 $118,645.75 $1,231,316.64 27.55% EDA $80000 $520.00 $520.00 $280.00 0.00% CABLE TV $17,500.00 $0.00 $0.00 $17,500.00 GATEWAY DONATIONS $0.00 $0.00 $000 $0.00 0.00% DEBT 2007 ROAD PROJECT BOND $0.00 $0.00 $0.00 $0.00 0.00% 2013 EQUIPMENT CERTIFICAT $62,918.00 $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,63600 $1,664.00 $0.00 $33,972.00 4.67% 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 $224,200.00 $46,090.87 $4,953.50 $178,109-13 20.56% ROAD CONSTRUCTION $0.00 $0.00 $000 $000 #DIV/0! PARK CAPITAL IMPROVEMENT $202,240.00 $100,117.41 $100,029.37 $102,122.59 49.50% EQUIPMENT REPLACEMENT $73,000.00 $0.00 $0.00 $73,00000 0.00% LOCAL ROAD IMPROVEMENT I $66,000.00 $3,551 50 $71500 $62,448.50 5.38% 201 SEWER FUND $137,525.00 $26,840.71 $16,351.16 $110,684.29 19.52% UPTOWN SEWER $21,397.00 $3,911.05 $1,073.62 $17,485.95 18.280/6 Report Total $2,915,395.00 $650,978.90 $242,288.40 $2,264,416.10 r.:. a mrr n e s n t a CASH BALANCES 2019 END OF MONTH FUND JANUARY FEBRUARY MARCH APRIL 101 GENERAL $1,620,605 $1,452,297 $1,355,921 $1,260,238 225 EDA $14,839 $21,313 $21,313 $20,793 226 CABLE TV $6,302 $6,666 $8,167 $9,655 230 RESTRICTED DONATIONS $175 $175 $175 $175 307 BLACKTOP 2007 $164 $164 $172 $172 313 EQUIPMENT CERTIFICATES $19,059 $19,059 $19,059 $19,059 315 EQUIPMENT CERTIFICATES $15,495 $15,495 $15,495 $15,495 317 EQUIPMENT CERTIFICATES -$2,201 -$2,201 -$2,201 -$2,201 401 CAPITAL IMPR $581,181 $568,810 $575,410 $676,096 402 ROAD CONSTRUCTION $0 $0 $0 $0 404 PARK CAP IMPR $118,585 $251,594 $251,564 $153,492 406 EQUIPMENT REPLACEMENT $275,777 $276,977 $276,977 $276,977 408 LOCAL ROAD IMPROVEMENT $1,449,555 $1,447,207 $1,444,363 $1,443,648 602 201 SEWER $108,142 $104,598 $115,480 $104,513 612 UPTOWN SEWER $8,131 $12,893 $12,281 $8,567 801 ESCROW $31,058 $59,389 $61,170 $60,244 TOTAL $4,246,868 $4,234,437 $4,155,346 $4,046,923