Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
6.b Treasurer's Report January 2021
aug SC iLY DIA FUND ACCOUNTING Beginning Cash Balance 1/1/2021 Beginning Checking Balance Checking Receipts Transfers to Checking Expenditures Transfers from Checking - Tax Settlement Payroll Ending Checking Balance Beginnging Money Market Balance Money Market Receipts Transfers from Checking - Tax Settlement Tranfers to Checking Ending Money Market Balance Beginning Investments Balance Investments Receipts Ending Investments Balance City of Scandia Treasurer's Report 1/31/2021 $ 4,790,326.03 $ 115,414.44 $ 33,412.71 $ 117,000.00 $ (184,163.35) $ (35,687.26) $ 45,976.54 $ 2,689,443.23 $ 33,796.80 $ (117,000.00) $ 2,606,240.03 $ 2,018,879.73 $ 2.483.38 $ 2,021.363.11 Beginning EDA Balance $ 24,928.76 Transfer from Checking Jan. Tax Settlement $ 2,030.40 Ending EDA Balance $ 26,959.16 Outstanding Checks $ (68,898.57) Ending Cash Balance 1/31/2021 $ 4,631,640.27 CHECKING MONEY MARKET & INVESTMENT CD's Checking *102 Beg Bal $ 115,414.44 Credits $ 150,412.71 Debits $ (219,850.61) End Bal $ 45,976.54 Money Market *105 - Rate .25°x6 Beg Bal rate change from 1.25% Credits Debits End Bal Investments CD *4422 - Rate .90% 12 mo., 3/25/2021 CD *4424 - Rate .30% 12 mo., 7/25/2021 CD *4425 - Rate 1.75% 12 mo., 9/28/2021 CD *4426 - Rate 1.60% 12 mo., 1/29/2021 Total Investments Total Bank & Investment Accounts $ 2,689,443.23 $ 33,796.80 $ (117,000.00) $ 2.606,240.03 $ 315,566.31 $ 439,388.14 $ 730,795.90 $ 535,612.76 $ 2,021,363.11 $ 4,673,579.68 Checks in Transit *3102 $ (68,898.57) Deposit in transit checking Deposit in transit money market Total Adjusted Undesignated Funds Scandia EDA *6301 Bal 10/31/20 Receipts Expenditures Checks in Transit Deposit in Transit Tax Settlement Total Designated Funds Total Funds Submitted by: Colleen Firkus, Treasurer $ 24,928.76 $ 2,030.40 $ 4,604,681.11 $ 26,959.16 S 4,631,640.27 City of Scandia nnTT Expenditure Summary SCAND L X Jan -21 2020 YTD Budget % of YTD GENERAL FUND 2021 YTD Budget 2021 YTD Amount 2021 MTD Amount Balance Budget Administration & Finance $387,272 $27,165.95 $27,165.95 $357,939.70 7.01% City Council $19,982 $4,864.83 $4,864.83 $15,117.17 24.35% Elections $1,030 $1,470.00 $1,470.00 -$440.00 14272% Planning & Building $118,050 $12,555.73 $12,555.73 $105,494.27 1064% Assessor $21,600 $1,700.00 $1,700.00 $21,600.00 787% Police $147,460 $69,377.13 $69,377.13 $78,082.87 47.05% Fire Department $262,778 $16,50220 $16,502.20 $246,275.80 6.28% Animal Control $2,000 $466.35 $466.35 $2,000.00 23.32% Public Works $658,253 $38,251 44 $38,251.44 $620,001.56 5.81% Parks & Recreation $90,797 $10,074.65 $10,074.65 $80,722.35 11.10% Community Center $68,500 $4,870.40 $4,870.40 $63,629.60 7.11% Transfers Between Accounts $280,000 $117,000.00 $117,000.00 $163,000.00 41.79% TOTAL GENERAL FUND $2,057,722 $304,298.68 $304,298.68 $1,753,423.32 14.79% EDA $1,900 $000 $0.00 $1,90000 000% GATEWAY DONATIONS $0 $0.00 $0.00 $0.00 000% CABLE TV $10,500 $0.00 $0.00 $10,500.00 000% DEBT 2007 ROAD PROJECT BOND $0 $0.00 $0.00 $0.00 0.00% 2013 EQUIPMENT CERTIFICATES $64,995 $0.00 $0.00 $64,995.00 0.00% 2017 EQUIPMENT CERTIFICATE $34,223 $864.00 $864.00 $33,359.00 2.52% 2018 BLACKTOP $325,220 $0,00 $0.00 $325,220.00 0.00% TOTAL DEBT SERVICE FUNDS $424,438 $864.00 $864.00 $423,574.00 0.20% CAPITAL IMPROVEMENTS Administration & Finance $250,000 $0.00 $0.00 $250,000.00 0.00% Fire Department $75,000 $0.00 $0.00 $75,000.00 0.00% Public Works $10,000 $0.00 $0.00 $10,000.00 0.00% Community Center $15,000 $3,694.20 $3,694.20 $11,305.80 24.63% "General Capital Improvements $57,000 $726.96 $726.96 $56,273.04 1.28% TOTAL CAPITAL IMPROVEMENTS $407,000 $4,421.16 $4,421.16 $402,578.84 1.09% PARK CAPITAL IMPROVEMENTS $42,025 $900.00 $900.00 $41,125.00 2.14% EQUIPMENT REPLACEMENT $ 52,500 $ - $ - $52,500.00 0.00% LOCAL ROAD IMPROVEMENT FUND $ 845,000 $ 17,303 50 $ 17,303 50 $827.69650 2.05% BIG MARINE SEWER FUND $ 167,005 $ 9,209 30 $ 9,209 30 $157,795.70 5.51% $ 27,607 $ 524.23 $ 52423 $27,082.77 1.90% UPTOWN SEWER FUND Report Total $4,035,697 $337,520.87 $337,520.87 $3,698,176.13 8.36% IVA CJS..SCANDIIA 2021 FUND 101 GENERAL 203 COVID-19 RELIEF 226 CABLE TV 230 RESTRICTED DONATIONS 307 BLACKTOP 2007 313 EQUIPMENT CERTIFICATES 315 EQUIPMENT CERTIFICATES 317 EQUIPMENT CERTIFICATES 318 BLACKTOP PROJECT 401 CAPITAL IMPR 404 PARK CAP IMPR 406 EQUIPMENT REPLACEMENT 408 LOCAL ROAD IMPROVEMENT 602 BIG MARINE SEWER 612 UPTOWN SEWER 801 ESCROW 225 EDA SUBTOTAL TOTAL CASH BALANCES END OF MONTH JANUARY $1,587,928 ($2,690) $21,930 $175 $91 $21,089 $15,452 ($2,468) ($15,633) $939,628 $157,785 $181,596 $1,599,921 $48,621 $22,458 $28,797 $4,604,681 $26,959 $4,631,640 ($4,631,640) $0