Loading...
6.b2 Feb 2021 Revised Treasurer's ReportCity of Scandia 14 Treasurer's Report CANDIA 2/ REVISSEDED 3 3-25-2-21 - FUND ACCOUNTING Beginning Cash Balance 2/1/2021 $ 4,632,823.78 Beginning Checking Balance $ 45,976.54 Checking Receipts $ 28,469.55 Transfers to Checking $ 228,000.00 Total Deposits $ 256,469.55 Expenditures $ (209,170.01) Payroll $ (33,853.52) Total Payments $ (243,023.53) Ending Checking Balance $ 59,422.56 Beginnging Money Market Balance $ 2,606,240.03 Money Market Receipts $ 18,204.21 Tranfersto 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 EDA Receipts EDA Expenditures $ (50.00) Ending EDA Balance $ 26,909.16 Outstanding Checks $ (24,654.52) Ending Cash Balance 2/28/2021 $ 4,479,484.55 CHECKING, MONEY MARKET& I NVESTM ENT 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 $ 41479,484.55 Submitted by: Colleen Firkus, Treasurer City of Scandia ' + Expenditure Summary ISVAN1. IA REVISED 3-25-21 Feb -21 GENERAL FUND 2021 Budget 2021 YTD Amount 2021 MTD Amount 2020 Budget Balance % of Budget Administration & Finance S 387,272.00 $50,558.16 $21,22586 $ 336,713 84 13.05% City Council $ 19,982.00 $13,565.83 $8,701.00 $ 6,416.17 67.89% Elections $ 1,030.00 $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 $0.00 -$69,37713 $ 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.43213 $47,18069 $ 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,000.00 $ (65,000.00) 123.21% TOTAL GENERAL FUND $ 2,057,722.00 $ 565,459.94 $ 261,161.26 $ 1,492,262.06 27.48% EDA $ 1,90000 $ 100.00 $ 100.00 $ 1,800.00 5.26% GATEWAY DONATIONS $ - $ - $ - $ - CABLE TV $ 10,500.00 $275.21 $275.21 $ 10,224.79 2.62% DEBT 2013 EQUIPMENT CERTIFICATES $ 64,995.00 $ $ $ 64,995.00 0.00% 2017 EQUIPMENT CERTIFICATE $ 34,223.00 $ 864.00 $ - $ 33,359 00 2-52% 2016 BLACKTOP $ 325,220 00 $ - $ - $ 325,220 00 0.000k TOTAL DEBT SERVICE FUNDS $ 424,438.00 $ 864.00 $ - $ 423,574.00 0.200% 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 $ $ - $ 10,000.00 0.00% Community Center $ 15,000.00 $3694.20 $0.00 $ 11,305 80 24.63% "General Capital Improvements $ 57,000 00 -$3-694.20 -$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 2.14% EQUIPMENT REPLACEMENT $ 52,500.00 $ $ - $ 52,500 00 000% LOCAL ROAD IMPROVEMENT FUND $ 845,000 00 $ - -$17,303.50 $ 845,000 00 000% BIG MARINE SEWER FUND $ 167,005 00 $3,79622 -$5,413.08 $ 163,208 78 227% $ 27,607 00 $1,172.07 $647.84 $ 26,434.93 4.25% UPTOWN SEWER FUND ReportTotal $ 4,035,697.00 $ 579,071.19 $ 241,550.32 $ 3,456,625.81 14.35% ■ ` ■ n� i n n r :� ❑ t a CASH BALANCES 2021 END OF MONTH REVISED 3-25-21 FUND JANUARY FEBRUARY 101 GENERAL $1,587,928 $1,434,436 203 COVID-19 RELIEF ($2,690) ($2,690) 226 CABLE TV $21,930 $23,775 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,631.91 225 EDA $26,959 $26,852.64 TOTAL $4,631,640 $4,479,484.55