Loading...
5.b Jan 2019 Treasurer's Report■ A Li i n n e 5 01. Beginning Balance 01/01/18 Receipts Expenditures Payroll Adjustments: Ending Balance 1/31/2019 City of Scandia Treasurer's Report 1/31/2019 Checking *102 Money Market *105 - Rate .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 Scandia EDA *6301 Receipts Expenditures Total Designated Funds Deposit in Transit Checks in Transit Further HSA Account in process Total Funds Submitted by: Colleen Firkus, Treasurer $ 4,505,648.13 $ 91,876.88 $ 319,821.60 $ 30,835.30 $ (350,656.90) $ 4,246,868.11 $ 116,755.95 $ 2,189,862.39 $ 514,148.23 $ 304,315.04 $ 424,989.53 $ 704,363.01 $ 4,254,434.15 $ 17,656.57 $ (197.50) $ 17,459.07 $ (20,205.50) $ (4,816.61) $ (3.00) $ 4,246,868.11 I�f City of Scandia i Expenditure Summary SCANDIA Jan -19 2019 YTD Budget % of YTD GENERAL FUND 2019 YTD Budget 2019 YTD Amount 2019 MTD Amount Balance Budget Administration & Finance $352,900.00 $23,648.61 $23,648.61 $329,251.39 6.70% City Council $31,000.00 $4,546.32 $4,546.32 $26,45368 14.67% Elections $2,200.00 $0.00 $0.00 $2,200.00 0.00% Planning & Building $119,200.00 $1,711.33 $1,711.33 $117,488.67 1.44% Police $136,000.00 $309.36 $309.36 $135,690.64 0.23% Fire Department $262,400.00 $27,905.88 $27,905.88 $234,494.12 10.63% Public Works $661,000.00 $53,024.81 $53,024.81 $607,975.19 8.02% Parks & Recreation $83,100.00 $11,964.17 $11,964.17 $71,135.83 14.40% Community Center $49,800.00 $4,544.52 $4,544.52 X45,255.48 9.13% Total General Fund $1,697,600.00 $127,655.00 $127,655.00 $1,569,945.00 7.52% EDA $800.00 $15,711.40 $5,603.00 -$14,911.40 0.00% GATEWAY DONATIONS $0.00 $5,000.00 $000 $0.00 0.00% CABLE TV $7,30000 $3,168.75 $1,15000 $4,131.25 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 $45,709.00 $0.00 -$768.00 101.71% 2017 EQUIPMENT CERTIFICAT $35,636.00 $31,923.84 -$3,997.50 $3,712.16 89.58% 2018 BLACKTOP $329,638.00 $000 $0.00 $329,638.00 0.00% $473,133.00 $77,632.84 -$3,997.50 $395,500.16 16.41% CAPITAL IMPROVEMENTS $198,00000 $0.00 $0.00 $198,00000 0.00% ROAD CONSTRUCTION $000 $0.00 $000 $0.00 #DIV/0! PARK CAPITAL IMPROVEMENT $163,520.00 $29.33 $29.33 $163,490.67 0.02% EQUIPMENT REPLACEMENT $73,00000 $0.00 $0.00 $73,000.00 0.00% LOCAL ROAD IMPROVEMENT 1 $66,00000 $0.00 $0.00 $66,000.00 000% 201 SEWER FUND $137,525.00 $3,169.16 $3,169.16 $134,35584 2.30% UPTOWN SEWER $21,397.00 $1,216.31 $1,216.31 $20,180.69 5.68% Report Total $2,838,275.00 $233,582.79 $134,825.30 $2,609,692.21 SCDIA CASH BALANCES 2019 END OF MONTH FUND JANUARY 101 GENERAL $1,620,605 225 EDA $14,839 226 CABLE TV $6,302 230 RESTRICTED DONATIONS $175 307 BLACKTOP 2007 $164 313 EQUIPMENT CERTIFICATES $19,059 315 EQUIPMENT CERTIFICATES $15,495 317 EQUIPMENT CERTIFICATES -$2,201 401 CAPITAL IMPR $581,181 402 ROAD CONSTRUCTION $0 404 PARK CAP IMPR $118,585 406 EQUIPMENT REPLACEMENT $275,777 408 LOCAL ROAD IMPROVEMENT $1,449,555 602 201 SEWER $108,142 612 UPTOWN SEWER $8,131 801 ESCROW $31,058 TOTAL $4,246,868