Loading...
6.b Treasurer's Monthly Report 2023-1aug FUND ACCOUNTING Beginning Cash Balance 3/1/2023 3,911,802.57$ Beginning Checking Balance 156,938.29$ Checking Receipts 31,606.96$ Transfers to Checking 180,000.00$ Total Deposits 211,606.96$ Expenditures (209,001.55)$ Payroll (34,470.97)$ Transfer to EDA in Transit Total Payments (243,472.52)$ Ending Checking Balance 125,072.73$ Beginnging Money Market Balance 1,740,282.75$ Money Market Receipts 1,321.32$ Tranfer to Checking (180,000.00)$ 0 Ending Money Market Balance 1,561,604.07$ Beginning Investments Balance 2,043,003.90$ Investments Receipts 5,399.59$ Ending Investments Balance 2,048,403.49$ Beginning EDA Balance 33,356.07$ EDA Receipts -$ EDA Expenditures EDA De;posit in Transit EDA Transfers from Checking Ending EDA Balance 33,356.07$ Outstanding Checks (6,446.06)$ Ending Cash Balance 3/31/2023 3,761,990.30$ CHECKING, MONEY MARKET & INVESTMENT CD's Checking *102 Beg Bal 156,938.29$ Credits 211,606.96$ Debits (243,472.52)$ Transfer in Transit End Bal 125,072.73$ Money Market *105 - Rate 1.25%Beg Bal 1,740,282.75$ rate change from .25% Credits 1,321.32$ Debits (180,000.00)$ End Bal 1,561,604.07$ Investments CD *4422 - Rate 4.00% 12 mo., 3/25/2024 **NEW RATE 317,850.51$ CD *4424 - Rate 2.50% 12 mo., 7/17/2023 446,907.03$ CD *4425 - Rate 2.875% 12 mo., 9/28/2023 744,824.34$ CD *4426 - Rate 3.50%% 12 mo., 1/29/2024 538,821.61$ Total Investments 2,048,403.49$ Total Bank & Investment Accounts 3,735,080.29$ Checks in Transit *3102 (6,446.06)$ Transfer to EDA in Transit Deposit in transit money market Total Adjusted Undesignated Funds 3,728,634.23$ Scandia EDA *6301 33,356.07$ Receipts Expenditures Checks in Transit Deposit in Transit Total Designated EDA Funds 33,356.07$ Total Funds 3,761,990.30$ Submitted by: Colleen Firkus, Treasurer City of Scandia Treasurer’s Report 3/31/2023