Loading...
6.b-Revised Treasurer's Report February 2021aug,� City of Scandia Treasurers Report SCANDIA 2i28i3021 REVISED 3-16-21 FUND ACCOUNTING Beginning Cash Balance 2/1/2021 $ 4,631,640.27 Beginning Checking Balance $ 45,976.54 Checking Receipts $ 28,469.55 Transfers to Checking $ 228,000.00 Expenditures $ (209,170.01) Transfers from EDA $ 6.52 Payroll $ (33,853.52) Ending Checking Balance $ 59,429.08 Beginnging Money Market Balance $ 2,606,240.03 Money Market Receipts $ 18,204.21 Tranfers to Checking $ (228,000.00) Ending Money Market Balance $ 2,396,444.24 Beginning Investments Balance $ 2,021,363.11 Investments Receipts $ Ending Investments Balance $ 2,021,363.11 Beginning EDA Balance $ 26,959.16 Transfer to Checking $ (6.52) Expenditures $ (50.00) Ending EDA Balance $ 26,902.64 Outstanding Checks $ (24,654.52) Ending Cash Balance 2/28/2021 $ 4,479,484.55 CHECKING, MONEY MARKET& INVESTMENT CD's Checking *102 Beg Bal $ 45,976.54 Credits $ 256,469.55 Debits $ (243,023.53) End Bal $ 59,422.56 Money Market •105 - Rate .25% Beg Bal $ 2,606,240.03 rate change from 1.25% Credits $ 18,204.21 Debits $ (228,000.00) End Bal $ 2,396,444.24 Investments CD *4422 - Rate .90% 12 mo., 3/25/2021 $ 315,566.31 CD *4424 - Rate .30% 12 mo., 7/25/2021 $ 439,388.14 CD *4425 - Rate 1.75% 12 mo., 9/28/2021 $ 730,795.90 CD *4426 - Rate 1.60% 12 mo., 1/29/2021 $ 535,612.76 Total Investments $ 2,021,363.11 Total Bank & Investment Accounts $ 4,477,229.91 Checks in Transit *3102 $ (24,654.52) Deposit in transit checking $ 56.52 Deposit in transit money market Total Adjusted Undesignated Funds $ 4,452,631.91 Scandia EDA *6301 Bal 10/31/20 $ 26,959.16 Receipts $ - Expenditures $ (50.00) Checks in Transit $ (56.52) Deposit in Transit $ Total Designated Funds $ 26,852.64 Total Funds $ 4,479,484.55 Submitted by: Colleen Firkus, Treasurer