Loading...
6.b Treasurer's Report February 202111�1aug ti7C1-11M DIIA FUND ACCOUNTING Beginning Cash Balance 2/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 Tranfers to Checking Ending Money Market Balance Beginning Investments Balance Investments Receipts Ending Investments Balance Beginning EDA Balance Transfer from Checking Jan. Tax Settlement Ending EDA Balance Outstanding Checks City of Scandia Treasurer's Report 2/28/2021 $ 4,631,640.27 $ 45,976.54 $ 28,469.55 $ 228,000.00 $ (209,170.01) 5 - $ [33,853.52) S 59,422..56 $ 2,606,240.03 $ 18,204.21 $ (728,000.Da) $ 2,396,444.24 $ 2,021,363.11 $ 2,021,363.11 $ 26,959.16 $ (50.00) $ 26,909.16 $ (24,654.52) Ending Cash Balance 2/28/2021 $ 4,479,484.55 CHECKING, MONEY MARKET & INVESTMENT CD's Checking 0102 Money Market *105 - Rate .25% rate change from 1.25% 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 Beg Bal $ 45,976.54 Credits $ 256,469.55 Debits $ (243,023.53) End Bal Total Designated Funds $ 59,422.56 Beg Bal $ 2,606,240.03 Credits $ 18,204.21 Debits $ (228,000.00) End Bal 5 2,396,444.24 Total Bank & Investment Accounts $ 315,566.31 $ 439,388.14 $ 730,795.90 $ 535,612.76 $ 2,021,363.11 $ 4,477,229.91 Checks in Transit *3102 $ (24,654.52) 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 $ 26,959.16 $ (50.00) $ 4,452,575.39 $ 26,909.16 $ 4,479,484.55 City of Scandia hExpenditure Summary SCANDIA Feb -21 GENERAL FUND 2021 Budget 2021 YTD Amount 2021 MTD Amount 2020 Budget Balance % of Budget Administration & Finance $ 387,272 00 $50,55816 $21,22586 $ 336,713 84 1305% City Council $ 19,982.00 $13,565.83 $8,701.00 $ 6,416.17 67.89% Elections $ 1,03000 $1,470.00 $0.00 $ (440 00) 142.72% Planning & Building $ 118,050.00 $10,112.02 -$2,443.71 $ 107,937.98 8.57% Assessor $ 21,600 00 $3,400.00 $3,400.00 $ 18,200.00 15.74% Police $ 147,460.00 $000 -$69,377.13 $ 147,460.00 0.00% Fire Department $ 262,778 00 $33,014.44 $16,512.24 $ 229,763 56 12-56% Animal Control $ 2,000.00 $327.84 $327.84 $ 1,672.16 16.39% Public Works $ 658,253 00 $85,432.13 $47,180.69 $ 572,820 87 1298% Parks & Recreation $ 90,797 00 $17,377.03 $7,30238 $ 73,419.97 19.14% Community Center $ 68,500.00 $5,202.49 $332.09 $ 63,297.51 7.59% Transfers Between Accounts $ 280,000.00 $345,000-00 $228.00000 $ (65,000 00) 123.21% TOTAL GENERAL FUND $ 2,057,722.00 $ 565,459.94 $ 261,161.26 $ 1,492,262.06 14.79% EDA $ 1,900.00 $ 10000 $ 10000 $ 1,80000 0-00% GATEWAY DONATIONS $ - $ - $ - $ - 0.00% CABLE TV $ 10,500.00 $275.21 $275.21 $ 10,224 79 0.00% DEBT 2013 EQUIPMENT CERTIFICATES $ 64,995.00 $ $ - $ 64,995.00 0.00% 2017 EQUIPMENT CERTIFICATE $ 34,223 00 $ 86400 $ $ 33,359.00 252% 2018 BLACKTOP $ 325,220 00 $ - $ $ 325,220 00 000% TOTAL DEBT SERVICE FUNDS $ 424,438.00 $ 864.00 $ $ 423,574.00 0.20% CAPITAL IMPROVEMENTS Administration & Finance $ 250,000.00 $6,503.75 $6,503.75 $ 243,496 25 2.60% Fire Department $ 75,000 00 $ - $ - $ 75,000.00 000% Public Works $ 10,000.00 $ - $ - S 10,000 00 0.00% Community Center $ 15,000 00 $3,69420 $0.00 $ 11,305 80 2463% "General Capital Improvements $ 57,000.00 -$3,69420 -$4,421.16 $ 60,694 20 -6.48% TOTAL CAPITAL IMPROVEMENTS $ 407,000.00 $ 6,503.75 $ 2,082.59 $ 400,496.25 1.60% PARK CAPITAL IMPROVEMENTS $ 42,025 00 $ 900.00 $ - $ 41.125.00 214% EQUIPMENT REPLACEMENT $ 52,500.00 $ - $ - $ 52,500 00 0.00% LOCAL ROAD IMPROVEMENT FUND $ 845,000.00 $ -$17,303.50 $ 845,000.00 000% BIG MARINE SEWER FUND $ 167.005.00 $3,796.22 -$5.41308 $ 163,208.78 227% $ 27,607.00 $1,172.07 $647.84 $ 26,434.93 4.25% UPTOWN SEWER FUND Report Total $ 4,035,697.00 $ 579,071.19 $ 241,550.32 $ 3,456,625.81 8.36% SCA DIA CASH BALANCES 2021 END OF MONTH FUND JANUARY FEBRUARY 101 GENERAL $1,587,928 $1,434,380 203 COVID-19 RELIEF ($2,690) ($2,690) 226 CABLE TV $21,930 $23,740 230 RESTRICTED DONATIONS $175 $175 307 BLACKTOP 2007 $91 $0 313 EQUIPMENT CERTIFICATES $21,089 $21,089 315 EQUIPMENT CERTIFICATES $15,452 $15,452 317 EQUIPMENT CERTIFICATES ($2,468) ($2,468) 318 BLACKTOP PROJECT ($15,633) ($15,633) 401 CAPITAL IMPR $939,628 $957,772 404 PARK CAP IMPR $157,785 $149,599 406 EQUIPMENT REPLACEMENT $181,596 $183,483 408 LOCAL ROAD IMPROVEMENT $1,599,921 $1,596,279 602 BIG MARINE SEWER $48,621 $43,641 612 UPTOWN SEWER $22,458 $20,116 801 ESCROW $28,797 $27,605 SUBTOTAL $4,604,681 $4,452,540 225 EDA $26,959 $26,853 TOTAL $4,631,640 $4,479,393