Loading...
06.b Treasurer's Report May 2021aug S►o„ ANDIA FUND ACCOUNTING Beginning Cash Balance 5/1/2021 Beginning Checking Balance Checking Receipts Transfers to Checking Total Deposits Expenditures Payroll Total Payments Ending Checking Balance Beginnging Money Market Balance Money Market Receipts Tranfers to Checking Ending Money Market Balance City of Scandia Treasurer's Report 5/31/2021 $ 65,137.77 $ 11,647.84 $ 368,000.00 $ 379,647.84 $ (390,880.98) $ (26,598.46) $ (417,479.44) $ 4,278,063.26 $ 27,306.17 $ 2,176,553.64 $ 25,822.20 $ (368,000.00) $ 1,834,375.84 Beginning Investments Balance $ 2,023,314.97 Investrnents Receipts $ Ending Investments Balance $ 2,023,314.97 Beginning EDA Balance $ 26,827.64 EDA Receipts EDA Expenditures $ (345.00) EDA Transfers Ending EDA Balance $ 26,482.64 Outstanding Checks $ (3,274.68) Ending Cash Balance 5/31/2021 $ 3,908,204.94 CHECKING, MONEY MARKET& INVFSTMENT CD's Checking *102 Beg Bal $ 65,137.77 Credits $ 379,647.84 Debits $ (417,479.44) End Bal $ 27,306.17 Money Market *105 - Rate .25% rate change from 1.25% Investments CD *4422 - Rate .90% 12 mo., 3/25/2022 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/2022 Total Investments Beg Bal $ 2,176,553.64 Credits $ 25,822.20 Debits $ (368,000.00) End Bal $ 1,834,375.84 Total Bank & Investment Accounts $ 316,266.61 $ 439,713.17 $ 731,336.49 $ 535,998.70 $ 2,023,314.97 $ 3,884,996.98 Checks in Transit *3102 S (3,274.68) Deposit in transit checking $ 50.00 Deposit in transit money market Total Adjusted Undesignated Funds $ 3,881,772.30 Scandia EDA *6301 $ 26,827.64 Receipts $ - Expenditures Checks in Transit $ (395.00) Deposit in Transit $ Total Designated EDA Funds $ 26,432.64 Total Funds $ 3,908,204.94 Submitted by: Colleen Firkus, Treasurer CASH BALANCES 2021 END OF MONTH REVISED 3-25-21 FUND JANUARY FEBRUARY MARCH APRIL MAY 101 GENERAL $1,587,928 $1,434,436 $1,297,969 $1,254,652 $1,171,412 203 COVID-19 RELIEF ($2,690) ($2,690) ($2,690) ($2,690) ($2,690) 226 CABLE TV $21,930 $23,775 $25,569 $27,490 $27,816 230 RESTRICTED DONATIONS $175 $175 $175 $175 $175 307 BLACKTOP 2007 $91 $0 $0 $0 $0 313 EQUIPMENT CERTIFICATES $21,089 $21,089 $21,089 $21,089 ($42,046) 315 EQUIPMENT CERTIFICATES $15,452 $15,452 $15,452 $15,452 $15,452 317 EQUIPMENT CERTIFICATES ($2,468) ($2,468) ($2,468) ($2,468) ($2,468) 318 BLACKTOP PROJECT ($15,633) ($15,633) ($15,633) ($15,633) ($68,490) 401 CAPITAL IMPR $939,628 $957,772 $957,772 $956,400 $920,311 404 PARK CAP IMPR $157,785 $149,599 $152,599 $152,599 $151,742 406 EQUIPMENT REPLACEMENT $181,596 $183,483 $183,483 $172,259 $172,259 408 LOCAL ROAD IMPROVEMENT $1,599,921 $1,596,279 $1,578,514 $1,570,663 $1,438,677 602 BIG MARINE SEWER $48,621 $43,641 $49,211 $48,727 $45,513 612 UPTOWN SEWER $22,458 $20,116 $18,996 $18,189 $21,112 801 ESCROW $28,797 $27,605 $37,583 $34,332 $32,997 SUBTOTAL $4,604,681 $4,452,631.91 $4,317,621 $4,251,236 $3,881,772 225 EDA $26,959 $26,852.64 $26,828 $26,828 $26,433 TOTAL $4,631,640 $4,479,484.55 $4,344,449 $4,278,063 $3,908,205 CITY OF SCANDIA i� 3 A �� DI Budget Contol Summary E �1j jJ May 2021 FUND 101 GENERAL FUND 2021 Budget 2021 YTD 2021 MTD 202_1 Budget Bel % of Budget Revenue Accounts Expenditure Accounts 2021 Budget 2021 YTD 2021 MTD R 101-41000-31000 Washington Cb- Tax Settlement $1,381,700.00 $0-00 $000 $1,381,700.00 000% R 101-:1000-31040 Fiscal Disparities $0.00 $0-00 $000 $000 0.00% R 10141000-31701 Gravel Taxes $10,000.00 $0.00 $000 $10,00000 0.00% P. 101-:1000-31830 Soler Energy Production Tax $6,000-00 $605.77 $000 $5.39423 89.90% R 101-41000-31900 Penalties & Interest Del Tax $1,000-00 $000 $000 $1,000.00 0.00% R 101-41000-32150 Utility Permits $1,800.00 $1,200 00 $15000 $600.00 5833% R 101-41000-32180 Tobacco & Liquor Licenses $8,200.00 $2,200.00 $0.00 $6,00000 2683% R 101-91000-32190 Other City Permits $2,900.00 $1,232.50 $000 $1.66750 4250% R 101-41000-32210 Building Permits $95,50000 $69,787.68 $21,201.12 $25,712-32 5088% R 101-41000-32260 Gambling Permits $0.00 $100.00 $000 ($100.00) 0.00% R 101-41000-33401 LGA/MVHC/AG/PERA Aid $13,000.00 $0.00 $000 $13,000.00 0.00% R 10141000-33420 Fire Relief State PERA $33,70000 $000 $000 $33.70000 0.00% R 10141000-33422 Other State Grants & Aids $10,200.00 $310.00 $0.00 $9.89000 3.04% R 101-41000-33428 PILOT $6,00000 $000 $000 $6,000.00 0.00% R 101 :1000-33620 Recycling Grant $8,000.00 $000 $000 $8,00000 000% R 10131000-33630 Local Govt Grants & Aids $0.00 $000 $000 $0.00 000% R 101-41000-33840 Other Grants $4,000.00 $72400 $0.00 $3,276.00 18.10% R 101-41000-34102 Legal Services $0-00 $000 $0.00 $0.00 0.00% R 10131000-34103 Zoning and Planning $3,400.00 $3,650.00 $5000 ($25000) 105.88% P, 10131000-34106 Engineering Fees $0.00 $000 $000 $000 000% R 10131000-34107 Assessment Search Fees $0.00 $2000 $20.00 ($2000) 000% R 101-41000-34109 Water Usage $200.00 $000 $0.00 $20000 0.00% R 10131000-34201 Impound Fees $200.00 $000 $000 $20000 000% R 101-41000.34202 Fire Protection Services $36,80000 $30,71000 $6,090.00 83.45% R 101-41000-34301 Damage Repairs $0-00 $3,678.24 $000 ($3,678.24) 0.00% R 101-41000-34303 Dust Control $2,400.00 $000 $0.00 $2,40000 000% R 101-1000-34304 Reimbursement for Services $3,600.00 $3,77695 $0.00 ($17695) 5000% R 101-:1000-34305 Other Street Services $0.00 $10000 $0.00 ($100.00) 0.00% R 10141000-34730 Ad Revenue $1,600-00 $1,25000 $35000 0.00% R 101-4100034740 Coffee Sales $000 $000 $0.00 $000 000% R 101-41000-34750 Facilities Rental $3,000.00 $2,02850 $971 50 4607% R 101-41000-34760 Cleaning Fees $000 $0.00 $0.00 $0.00 000% R 101-41000-34790 Recreation Programs $000 $765.00 ($76500) 0.00% R 101-41000-34950 Soler Subscription $9,00000 $000 $000 $9,000.00 000% R 1014100035101 Fines & Forfeitures $8,10000 $3.34304 $4,75696 3236% R 101-4100035201 Forfeited Land Sales $0.00 $000 $0.00 $0.00 0.00% R 101-41000-36210 Interest Income $17,90000 $6,852.90 $11,04710 3604% R 1013100036230 Donations $5,000.00 $1.45000 $0.00 $3,55000 2900% R 10131000-36240 Insurance Dividend $1,400.00 $0.00 $000 $1,40000 000% R 101-41000-36250 Misc. Refund $50000 $1,66860 $000 ($1,168.60) 33372% R 101-4100038050 Cable TV Franchise Rebates $0-00 $000 $000 $000 000% R 1171.41000.39200 Ifrterfund Opi3raMQ Transfer $1,44000 SO -00 '10J4 $144G.00 C.RO`•1 TOTAL GENERAL FUND REVENUES $1,676.540.00 $135,453.18 $21,421.12 $1,541.086.82 Y 8.08% R 101-19000-39204 Mon Msrket TransF%r $ $1,019.056.52 $366 000-00 FUND 101 GENERAL FUND Expenditure Accounts 2021 Budget 2021 YTD 2021 MTD 2021 Budget Bal % of Budget Administration & Finance 5 387,272.00 $183,795.00 $ 61,841.19 $203,477.00 47.46% City Council S 19,982.00 $13,399.53 $ $6,582.47 67.06% Elections $ 1,030.00 $1,470.00 $ - ($440.00) 14272% Planning & Building $ 118,050 00 $41,618.61 $ 9.42368 $76,431.39 35.26% Assessor S 21,60000 $8,500.00 $ 1,700.00 $13,10000 39.35% Polio 5 147,460.00 $309.36 $ - $147,15064 0.21% Fire Dept S 262,77800 $80,96128 $ 19,929.29 $181,81672 30.81% Animal Control S 2,000.00 $930.17 $ 150.00 $1,059.83 46.51% Public Works S 658,253.00 $195,047.99 $ 22,060.86 $463.20501 2963% Parks & Recreation 5 90,797.00 $35,131.88 $ 8,976,73 $55,665.12 36.69% Community Center $ 66500-00 $17.151.66 S 4625.10 $51.348.34 25-04% TOTAL GENERAL EXPENDITURES $ 1,777,722.00 $ 578,315-48 $ 128 906.85 S1,199.406.52 32.53% Transfers Between Accounts $ 280,00000 $1.000,00000 S 349,000.00 $720 DOO-00 Page 1 of 2 Page 2 of 2 CITY OF SCANDIA Budget Contol Summary May 2021 FUND 225 EDA Revenue Accounts $ 5,000 DO $ - $ - $5,000.00 000% Expenditure Accounts $ 1,900.00 $ 520.00 $ 395.00 $1,380.00 27.37% FUND 125 CAELE TV Revenue Accounts $ 16,500.00 $ 7,774,81 $ 1,979.08 $8,725.19 47.12% Expenditure Accounts $ 10,500.00 $ 2,048.62 $ 1,652.98 $8,451.38 19.51% FUND 313 2013 EQUIPMENT CERTIFICATES Revenue Accounts $ 68,220 00 $ - $68,220.00 0.00% Expenciture Accounts S 64,99500 $ 63,13500 $ 63,135.00 $1,860.00 97,14% FUND 317 2017 EQUIPMENT CERTIFICATES Revenue Accounts $ 35,909.00 $ - $35,909.00 0.00% Expenditure Accounts $ 34,223 00 $ 864.00 $33,359.00 2.52% FUND 318 BLACKTOP PROJECT 2018 Revenue Accounts $ 341,456.00 $ - $ - $341,456.00 0.00% Expenciture Accounts $ 325,220 00 $ 52,857 51 $ 52,857.51 $272,362.49 16.25% FUND 401 CAPITAL IMPROVEMENTS Revenue Accounts $ 300 500.00 S $ $300.50000 0.00% Expenditure Accounts Administration & Finance S 250,000.00 $ 7,876.25 $ - $242,123.75 315% Fire Crept S 75,000.00 $ 36,089.04 $ 36,089 04 $38,91096 4812% Publi: Works S 10,000.00 S - $10.00000 000% Community Center S 15,000.00 S 3,694.20 $11,30580 24.63% Capital Improvements 5 47,000.00 $ (3,69420) $50,69420 -7.86% Open4ng Transfer S 10.0130.00 S - S10,0130.013 TOTAL CAPITAL IMPROVEMENTS $ 407,000.00 5 43 955.29 5 36 089.04 $ 363 034.71 10.80% FUND 404 PARK CAPITAL IMPROVEMENTS 2021 Budget 2021 YTD 2021 MTD 2021 Bud et Bal % of Budget Revenue Accounts $ 26,585.00 $ 3,000.00 $ - $23,58500 11.28% Expenditure Accounts $ 42,025-00 $ 1,757.00 $ 857.00 $40,268.00 4.18% FUND 406 EQUIPMENT REPLACEMENT Revenue Accounts $ 138,000 00 $ - $ $138,000.00 0.00% Expenditure Accounts $ 52,500.00 $ 11,224.04 $ - $41,27596 21.38% 408 LOCAL ROAD IMPROVEMENT FUND _FUND Revenue Accounts $ 518,539.00 $ - $ $518,539.00 0,00% Expenditure Accounts $ 845,000.00 $ 157,60123 $ 131,985.27 $687,398,77 18.65% FUND 602 BIG MARINE SEWER Revenue Accounts $ 96,945.00 $ 23,120.89 $ 433.73 $75,824.11 23.37% Expenciture Accounts $ 167,005.00 $ 25,798.35 $ 4,468.38 $ 141,206.65 15.45% FUND 612 UPTOWN SEW>=R Revenue Accounts $ 23,000.00 $ 3,27102 $ 3,133.72 $19,728.98 14.22% Expenditure Accounts $ 27,607.00 $ 3,01589 $ 210.83 $24,591.11 1092% TOTAL REVENUE ACCOUNTS $ 3,249,194.00 $1,191,676.42 $ 394,967.65 $ 3,076,574.10 36.68% TOTAL EXPENDITURE ACCOUNTS $ 4,035,697.00 $1,941,102.41 $ 769,557.86 $ 2,094,594.59 22.55% Page 2 of 2