Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
5.b Treasurer's Report - January 2020
City of Scandia Treasurer's Report 1/31/2020 Beginning Balance 01/01/20 $ 4,640,722.68 Receipts $ 65,652.90 Expenditures $ 145,882.87 Payroll $ 32,436.57 $ (178,319.44) Adjustments- Jan Tax Settlement reversed $ (820.59) moved from Cash to Taxes Receivable Ending Balance 1/31/2020 $ 4,527,235.55 $ 4,527,235.55 $ Ending Balance includes the following Investments. Checking *102 Money Market *105 - Rate .25% CD *4422 - Rate 2.50% 12 mo., 3/25/2020 CD *4424 - Rate 2.00% 12 mo., 7/25/2020 CD *4425 - Rate 1.75% 12 mo., 9/28/2020 CD *4426 - Rate 2.50% 12 mo., 1/29/2020 Total Undesignated Funds Checking Account *3102 Checks in Transit Transfer to EDA Jan Tax Settlement Transfer to EDA 2019 Interest Void check 37760 1/21/20 Void check 37766 1/21/20 Deposit in transit Audit journal entries adjustment Total Undesignated Funds Scandia EDA *6301 Receipts Expenditures Checks in Transit Deposit in Transit - 2019 Interest Total Designated Funds Total Funds Submitted by: Colleen Firkus, Treasurer $ 58,262.31 $ 2,493,364.60 $ 311,499.32 $ 434,333.12 $ 720,713.33 $ 527,122.95 $ 4,545,295.63 $ (15,994.72) $ (299.77) $ (432.00) $ (1,333.20) $ (0.39) $ 4,527,235.55 $ - $ 22,879.56 $ 22,879.56 $ 4,550,115.11 City of Scandia a + Expenditure Summary SCANDIA Jan-20 2020 YTD Budget % of YTD GENERAL FUND 2020 YTD Budget 2020 YTD Amount 2020 MTD Amount Balance Budget Administration & Finance $397,80000 $17,852.57 $17,852.57 $379,94743 449% City Council $21,000.00 -$262.50 -$262.50 $21,26250 -125% Elections $6,400,00 $0.00 $0.00 $6,40000 0.00% Planning & Building $131,400.00 $2,277.68 $2,277.68 $129,12232 1.73% Police $139,100.00 $361.36 $361.36 $138,738.64 0.26% Fire Department $281,214.00 $4,469.99 $4,469.99 $276,744.01 1.59% Public Works $770,900.00 $25,651.95 $25,651.95 $745,24805 3.33% Parks & Recreation $77,600.00 $4,940.36 $4,940.36 $72,659.64 6.37% Community Center $49,500.00 $906.64 $90664 $48,593.36 1.83% Total General Fund $1,874,914.00 $56,198.05 $56,198.05 $1,818,715.95 3.00% EDA $800.00 $0.00 $000 $80000 0.00% GATEWAY DONATIONS $0.00 $0.00 $0.00 $0.00 0.00% CABLE TV $19,620.00 $0.00 $0.00 $19,620.00 0.00% DEBT 2007 ROAD PROJECT BOND $0.00 $0.00 $000 $0.00 0.00% 2013 EQUIPMENT CERTIFICAT $66,560.00 $0.00 $000 $66,56000 0.00% 2015 EQUIPMENT CERTIFICAT $43,995.00 $0.00 $0.00 $43,995.00 0.00% 2017 EQUIPMENT CERTIFICAT $34,948.00 $1,272.00 $1,27200 $33,67600 364% 2018 BLACKTOP $327,17500 $0.00 $000 $327,17500 0.00% $472,678.00 $1,272.00 $1,272.00 $471,406.00 0.27% CAPITAL IMPROVEMENTS $430,000.00 $0.00 $000 $430,000.00 0.00% ROAD CONSTRUCTION $0.00 $0.00 $000 $000 #DIV/0! PARK CAPITAL IMPROVEMENT $152,620.00 $0.00 $0.00 $152,620.00 0.00% EQUIPMENT REPLACEMENT $256,000.00 $0.00 $0.00 $256,000.00 0.00% LOCAL ROAD IMPROVEMENT f $637,000.00 $0.00 $0.00 $637,000.00 0.00% 201 SEWER FUND $135,375.00 $851.89 $851.89 $134,523,11 0.63% UPTOWN SEWER $22,447.00 $321.39 $321.39 $22,125.61 1.43% Report Total $4,001,454.00 $58,643.33 $58,643.33 $3,942,810.67 2020 FUND 101 GENERAL 226 CABLE TV 230 RESTRICTED DONATIONS 307 BLACKTOP 2007 313 EQUIPMENT CERTIFICATES 315 EQUIPMENT CERTIFICATES 317 EQUIPMENT CERTIFICATES 318 BLACKTOP PROJECT 401 CAPITAL IMPR 402 ROAD CONSTRUCTION 404 PARK CAP IMPR 406 EQUIPMENT REPLACEMENT 408 LOCAL ROAD IMPROVEMENT 602 201 SEWER 612 UPTOWN SEWER 801 ESCROW SUBTOTAL 225 EDA TOTAL CASH BALANCES END OF MONTH JANUARY $1,241,912 $4,853 $175 $111 $19,767 $16,352 -$2,544 -$7,413 $1,048,268 $0 $151,637 $233,285 $1,661,216 $94,211 $18,727 $46,678 $4,527,236 $23,206 $4,550,441