Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
06.b Treasurer's Monthly Report
City of Scandia aug Treasurer’s Report 1/31/2023 FUND ACCOUNTING Beginning Cash Balance $ 4,295,258.36 1/1/2023 Beginning Checking Balance$ 140,805.23 Checking Receipts $ 299,210.85 Transfers to Checking Total Deposits $ 299,210.85 Expenditures$ (269,732.54) Payroll$ (89,249.88) Transfer to EDA in Transit Total Payments $ (358,982.42) Ending Checking Balance $ 81,033.66 Beginnging Money Market Balance $ 2,129,499.72 Money Market Receipts $ 425.37 Tranfer to Checking $ (215,000.00) 0 Ending Money Market Balance $ 1,914,925.09 Beginning Investments Balance $ 2,039,798.28 Investments Receipts $ 3,205.62 Ending Investments Balance$ 2,043,003.90 Beginning EDA Balance$ 29,831.13 EDA Receipts $ - EDA Expenditures $ (475.06) EDA De;posit in Transit$ - EDA Transfers from Checking $ 4,000.00 Ending EDA Balance$ 33,356.07 Outstanding Checks $ (5,676.35) 1/31/2023 Ending Cash Balance $ 4,066,642.37 CHECKING, MONEY MARKET & INVESTMENT CD's Checking *102$ 140,805.23 Beg Bal Credits$ 299,685.91 Debits$ (359,457.48) Transfer in Transit $ 81,033.66 End Bal Money Market *105 - Rate .25%$ 2,129,499.72 Beg Bal rate change from 1.25% Credits $ 425.37 Debits $ (215,000.00) End Bal$ 1,914,925.09 Investments CD *4422 - Rate .45% 12 mo., 3/25/2023$ 317,693.84 CD *4424 - Rate 2.50% 12 mo., 7/17/2023 $ 446,907.03 CD *4425 - Rate 2.875% 12 mo., 9/28/2023 $ 739,581.42 CD *4426 - Rate 3.50%% 12 mo., 1/29/2024 **NEW RATE $ 538,821.61 Total Investments$ 2,043,003.90 Total Bank & Investment Accounts $ 4,038,962.65 $ (5,676.35) Checks in Transit *3102 Transfer to EDA in Transit Deposit in transit money market $ 4,033,286.30 Total Adjusted Undesignated Funds Scandia EDA *6301 $ 30,326.13 Receipts$ 3,524.94 Expenditures $ (495.00) Checks in Transit Deposit in Transit Total Designated EDA Funds$ 33,356.07 Total Funds$ 4,066,642.37 Submitted by: Colleen Firkus, Treasurer 2023 CASH BALANCES END OF MONTH FUNDJANUARY 101 GENERAL$1,365,931.69 203 COVID-19 RELIEF$456,362.62 226 CABLE TV$11,271.00 230 GATEWAY TRAIL$0.00 307 BLACKTOP PROJECT 2007$6,730.52 313 EQUIPMENT CERTIFICATES$28,825.07 315 EQUIPMENT CERTIFICATES$15,951.35 317 EQUIPMENT CERTIFICATES$2,187.46 318 BLACKTOP PROJECT$20,270.12 401 CAPITAL IMPR$749,162.08 404 PARK CAP IMPR$148,177.40 406 EQUIPMENT REPLACEMENT$199,727.01 408 LOCAL ROAD IMPROVEMENT$916,079.86 602 BIG MARINE SEWER$80,462.45 612 UPTOWN SEWER$10,330.21 801 ESCROW$21,817.46 SUBTOTAL$ 4,033,286.30 225 EDA$33,356.07 TOTAL$ 4,066,642.37