Loading...
06.b Treasurer's Monthly ReportCity of Scandiaaug Treasurer’sReport 1/31/2022 FUND ACCOUNTING Beginning Cash Balance $ 4,566,274.701/1/2022 Beginning Checking Balance$ 936,111.63 Checking Receipts 57,307.66 Transfers to Checking Total Deposits 57,307.66 Expenditures$ (234,772.27) Payroll$ (40,025.21) Total Payments 274,797.48) Ending Checking Balance 718,621.81 Beginnging Money Market Balance 1,645,365.61 Money Market Receipts 349.36 Tranfers to Checking Ending Money Market Balance 1,645,714.97 Beginning Investments Balance 2,027,139.44 Investments Receipts 738.90 Ending Investments Balance$ 2,027,878.34 Beginning EDA Balance 26,923.67 EDA Receipts $ 2,500.00 EDA Expenditures 520.00) EDA Transfers from Checking - in transit$ - Ending EDA Balance$ 28,903.67 Outstanding Checks 28,169.59) 1/31/2022EndingCashBalance $ 4,392,949.20 CHECKING, MONEY MARKET & INVESTMENT CD's Checking *102$ 936,111.63BegBal Credits$ 57,307.66 Debits$ (274,797.48) 718,621.81EndBal Money Market *105 - Rate .25%$ 1,645,365.61BegBal rate change from 1.25% Credits 349.36 Debits End Bal$ 1,645,714.97 Investments CD *4422 - Rate .90% 12 mo., 3/25/2022$ 316,981.13 CD *4424 - Rate .30% 12 mo., 7/25/2022$ 440,699.35 CD *4425 - Rate .30% 12 mo., 9/28/2022$ 732,986.74 CD *4426 - Rate .30% 12 mo., 1/29/2023 537,211.12 Total Investments$ 2,027,878.34 Total Bank & Investment Accounts 4,392,215.12 28,169.59) Checks in Transit *3102 Deposit in transit checking Deposit in transit money market 4,364,045.53TotalAdjustedUndesignatedFunds Scandia EDA *6301 $ 26,923.67 Receipts 2,500.00 Expenditures 520.00) Checks in Transit Deposit in Transit Total Designated EDA Funds$ 28,903.67 Total Funds$ 4,392,949.20 Submitted by: Colleen Firkus, Treasurer CASH BALANCES 2022END OF MONTH FUNDJANUARY 101 GENERAL$1,375,256 203 COVID-19 RELIEF$228,181 226 CABLE TV$39,431 230 RESTRICTED DONATIONS$175 307 BLACKTOP 2007$0 313 EQUIPMENT CERTIFICATES$24,314 315 EQUIPMENT CERTIFICATES$15,452 317 EQUIPMENT CERTIFICATES($298) 318 BLACKTOP PROJECT$603 401 CAPITAL IMPR$818,050 404 PARK CAP IMPR$144,888 406 EQUIPMENT REPLACEMENT$316,105 408 LOCAL ROAD IMPROVEMENT$1,258,340 602 BIG MARINE SEWER$96,113 612 UPTOWN SEWER$14,094 801 ESCROW$33,341 SUBTOTAL$4,364,046 225 EDA$28,904 TOTAL$4,392,949