Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
06.b July 2021 Treasurer's Report (2)
2021 Budget 2021 YTD 2021 MTD 2021 Budget Bal % of Budget Notes 101 GENERAL FUND Revenue Accounts R 101-41000-31000 Washington Cty. Tax Settlement $1,381,700.00 $753,614.59 $753,614.59 $628,085.41 0.00% R 101-41000-31040 Fiscal Disparities $0.00 $82,986.81 $82,986.81 ($82,986.81)0.00% R 101-41000-31701 Gravel Taxes $10,000.00 $0.00 $0.00 $10,000.00 0.00% R 101-41000-31830 Solar Energy Production Tax $6,000.00 $5,066.61 $4,460.84 $933.39 89.90% R 101-41000-31900 Penalties & Interest Del Tax $1,000.00 $663.67 $663.67 $336.33 0.00% R 101-41000-32150 Utility Permits $1,800.00 $2,100.00 $450.00 $600.00 58.33% R 101-41000-32180 Tobacco & Liquor Licenses $8,200.00 $2,200.00 $0.00 $6,000.00 26.83% R 101-41000-32190 Other City Permits $2,900.00 $2,067.50 $275.00 $832.50 42.50% R 101-41000-32210 Building Permits $95,500.00 $136,415.82 $38,195.55 ($40,915.82)50.88% R 101-41000-32260 Gambling Permits $0.00 $130.00 $30.00 ($130.00)0.00% R 101-41000-33401 LGA/MVHC/AG/PERA Aid $13,000.00 $0.00 $0.00 $13,000.00 0.00% R 101-41000-33420 Fire Relief State PERA $33,700.00 $0.00 $0.00 $33,700.00 0.00% R 101-41000-33422 Other State Grants & Aids $10,200.00 $3,810.00 $0.00 $6,390.00 3.04% R 101-41000-33428 PILOT $6,000.00 $3,036.10 $3,036.10 $2,963.90 0.00% R 101-41000-33620 Recycling Grant $8,000.00 $13,062.00 $0.00 ($5,062.00)0.00% R 101-41000-33630 Local Govt Grants & Aids $0.00 $0.00 $0.00 $0.00 0.00% R 101-41000-33640 Other Grants $4,000.00 $724.00 $0.00 $3,276.00 18.10% R 101-41000-34102 Legal Services $0.00 $0.00 $0.00 $0.00 0.00% R 101-41000-34103 Zoning and Planning $3,400.00 $5,250.00 $950.00 ($1,850.00)105.88% R 101-41000-34106 Engineering Fees $0.00 $482.00 $482.00 ($482.00)0.00% R 101-41000-34107 Assessment Search Fees $0.00 $20.00 $0.00 ($20.00)0.00% R 101-41000-34109 Water Usage $200.00 $0.00 $0.00 $200.00 0.00% R 101-41000-34201 Impound Fees $200.00 $0.00 $0.00 $200.00 0.00% R 101-41000-34202 Fire Protection Services $36,800.00 $30,710.00 $0.00 $6,090.00 83.45% R 101-41000-34301 Damage Repairs $0.00 $3,678.24 $0.00 ($3,678.24)0.00% R 101-41000-34303 Dust Control $2,400.00 $0.00 $0.00 $2,400.00 0.00% R 101-41000-34304 Reimbursement for Services $3,600.00 $3,600.00 $0.00 $0.00 50.00% R 101-41000-34305 Other Street Services $0.00 $2,076.95 $0.00 ($2,076.95)0.00% R 101-41000-34730 Ad Revenue $1,600.00 $2,100.00 $0.00 ($500.00)0.00% R 101-41000-34750 Facilities Rental $3,000.00 $3,139.18 $450.00 ($139.18)46.07% R 101-41000-34760 Cleaning Fees $0.00 $100.00 ($50.00)($100.00)0.00% R 101-41000-34790 Recreation Programs $0.00 $765.00 $0.00 ($765.00)0.00% R 101-41000-34950 Solar Subscription $9,000.00 $0.00 $0.00 $9,000.00 0.00% R 101-41000-35101 Fines & Forfeitures $8,100.00 $4,397.92 $830.46 $3,702.08 32.36% R 101-41000-36210 Interest Income $17,900.00 $9,095.47 $1,122.09 $8,804.53 36.04% R 101-41000-36230 Donations $5,000.00 $1,450.00 $0.00 $3,550.00 29.00% R 101-41000-36240 Insurance Dividend $1,400.00 $0.00 $0.00 $1,400.00 0.00% R 101-41000-36250 Misc. Refund $500.00 $2,256.00 $167.40 ($1,756.00)333.72% R 101-41000-39200 Interfund Operating Transfer $1,440.00 $0.00 $0.00 $1,440.00 0.00% No more transfers from 404- ballfield ad revenue and maintenance now in Gen Fund TOTAL GENERAL FUND REVENUES $1,676,540.00 $1,074,997.86 $887,664.51 $601,542.14 64.12% R 101-49000-39204 Money Market Transfer -$ $2,974,401.52 $1,237,345.00 R 101-49000-39203 Transfers from Other Funds ($845.00)Balancing EDA account 101 GENERAL FUND Expenditure Accounts 2021 Budget 2021 YTD 2021 MTD 2021 Budget Bal % of Budget Administration & Finance 387,272.00$ $241,511.10 $31,925.61 $145,760.90 62.36% City Council 19,982.00$ $18,185.56 $4,786.03 $1,796.44 91.01% Elections 1,030.00$ $1,470.00 $0.00 ($440.00)142.72% Planning & Building 118,050.00$ $75,507.31 $20,597.77 $42,542.69 63.96% Assessor 21,600.00$ $13,076.65 $1,800.00 $8,523.35 60.54% Police 147,460.00$ $73,868.19 $73,558.83 $73,591.81 50.09% Fire Dept 262,778.00$ $122,419.37 $25,494.87 $140,358.63 46.59% Animal Control 2,000.00$ $1,676.30 $746.13 $323.70 83.82% Public Works 658,253.00$ $296,907.04 $58,127.52 $361,345.96 45.11% Parks & Recreation 90,797.00$ $48,128.04 $6,754.13 $42,668.96 53.01% Community Center 68,500.00$ $21,960.88 $1,870.35 $46,539.12 32.06% TOTAL GENERAL FUND EXPENDITURES 1,777,722.00$ $914,710.44 225,661.24$ $863,011.56 51.45% Budgeted Transfers Between Accounts 280,000.00$ 280,000.00$ 280,000.00$ $0.00 Transfers Between Accounts -$ 2,958,965.40$ 957,000.00$ ($2,958,965.40) Total Transfers 3,238,965.40$ 1,462,661.24$ ($3,238,965.40) CITY OF SCANDIA BUDGET YTD REVENUE AND EXPENSES JULY 2021 Page 1 of 4 2021 Budget 2021 YTD 2021 MTD 2021 Budget Bal % of Budget Notes CITY OF SCANDIA BUDGET YTD REVENUE AND EXPENSES JULY 2021 203 AMERICAN RESCUE PLAN FUND Revenue Accounts -$ 224,911.34$ 220,945.94$ ($224,911.34) Expenditure Accounts -$ $0.00 $0.00 $0.00 225 EDA FUND Revenue Accounts 5,000.00$ 2,500.00$ 2,500.00$ $2,500.00 50.00% Expenditure Accounts E 225-46500-210 Operating Supplies $500.00 $175.00 $0.00 $325.00 35.00% E 225-46500-308 Other Professional Services $250.00 $68.97 $68.97 $181.03 27.59% E 225-46500-433 Dues and Subscriptions $1,150.00 $1,795.00 $0.00 -$645.00 156.09% E 225-46500-720 Operating Transfers $0.00 $345.00 $345.00 -$345.00 0.00% TOTAL EDA EXPENDITURES 1,900.00$ $2,383.97 $413.97 ($483.97)125.47% 226 CABLE TV FUND Revenue Accounts 16,500.00$ 11,650.91$ 1,920.05$ $4,849.09 70.61% Expenditure Accounts E 226-41950-240 Small Tools and Minor Equip $0.00 $52.49 $0.00 -$52.49 #DIV/0! E 226-41950-309 Software Support & Maintenance $3,500.00 $1,822.52 $56.78 $1,677.48 52.07% E 226-41950-438 Misc. Contractual $7,000.00 $0.00 $0.00 $7,000.00 0.00% E 226-41950-570 Office Equipment $0.00 $230.39 $0.00 -$230.39 #DIV/0! TOTAL CABLE TV EXPENDITURES $10,500.00 $2,105.40 $56.78 $8,394.60 20.05% 313 EQUIPMENT CERTIFICATE 2013 FUND Revenue Accounts 68,220.00$ 34,110.00$ 34,110.00$ $34,110.00 50.00% Expenditure Accounts 64,995.00$ 63,135.00$ -$ $1,860.00 97.14% 317 EQUIPMENT CERTIFICATE 2017 FUND Revenue Accounts 35,909.00$ 17,954.50$ 17,954.50$ $17,954.50 50.00% Expenditure Accounts 34,223.00$ 864.00$ -$ $33,359.00 2.52% 318 BLACKTOP PROJECT 2018 FUND Revenue Accounts 341,456.00$ 170,728.00$ 170,728.00$ $170,728.00 50.00% Expenditure Accounts 325,220.00$ 52,857.51$ -$ $272,362.49 16.25% Page 2 of 4 2021 Budget 2021 YTD 2021 MTD 2021 Budget Bal % of Budget Notes CITY OF SCANDIA BUDGET YTD REVENUE AND EXPENSES JULY 2021 401 CAPITAL IMPROVEMENTS FUND Revenue Accounts 300,500.00$ 256,124.45$ 50,035.41$ $44,375.55 85.23% Expenditure Accounts Administration & Finance 250,000.00$ $18,815.00 $10,938.75 $231,185.00 7.53% Fire Dept 75,000.00$ $141,873.24 $0.00 ($66,873.24)189.16% Public Works 10,000.00$ $0.00 $0.00 $10,000.00 0.00% Community Center 15,000.00$ $0.00 -$3,694.20 $15,000.00 0.00% Capital Improvements 47,000.00$ $181,094.24 $17,980.45 ($134,094.24)385.31% Operating Transfer 10,000.00$ $0.00 $0.00 $10,000.00 TOTAL CAPITAL IMPROVEMENT EXPENDITURES 407,000.00$ $341,782.48 $25,225.00 65,217.52$ 83.98% 404 PARK DEVELOPMENT FUND 2021 Budget 2021 YTD 2021 MTD 2021 Budget Bal % of Budget Revenue Accounts 26,585.00$ 8,857.00$ 5,000.00$ $17,728.00 33.32% Expenditure Accounts E 404-48000-530 Capital Impr Other Than Bldgs $40,585.00 $1,757.00 $0.00 $38,828.00 4.33% E 404-48000-720 Operating Transfers $1,440.00 $0.00 $0.00 $1,440.00 0.00% TOTAL PARK DEVELOPMENT EXPENDITURES 42,025.00$ 1,757.00$ -$ $40,268.00 4.18% 406 EQUIPMENT REPLACEMENT FUND Revenue Accounts 138,000.00$ 65,000.00$ 65,000.00$ $73,000.00 47.10% Expenditure Accounts 52,500.00$ 11,224.04$ -$ $41,275.96 21.38% 408 LOCAL ROAD IMPROVEMENT FUND Revenue Accounts 518,539.00$ 343,950.50$ 263,950.50$ $174,588.50 66.33% Expenditure Accounts 845,000.00$ 732,757.36$ 80,869.88$ $112,242.64 86.72% Page 3 of 4 2021 Budget 2021 YTD 2021 MTD 2021 Budget Bal % of Budget Notes CITY OF SCANDIA BUDGET YTD REVENUE AND EXPENSES JULY 2021 602 BIG MARINE SEWER FUND Revenue Accounts 98,945.00$ 46,000.52$ 10,203.19$ $52,944.48 46.49% Expenditure Accounts E 602-43210-101 Regular Wages & Salaries $20,000.00 $5,541.18 $429.82 $14,458.82 27.71% E 602-43210-102 OT Regular Wages $0.00 $220.28 $0.00 -$220.28 0.00% E 602-43210-121 PERA Coord. Employer Contribu.$1,500.00 $378.30 $32.24 $1,121.70 25.22% E 602-43210-122 FICA Employer Contribution $1,200.00 $334.26 $24.23 $865.74 27.86% E 602-43210-126 MEDICARE Employer Contribution $300.00 $86.97 $5.66 $213.03 28.99% E 602-43210-151 Worker s Comp Insurance Prem $455.00 $422.00 $0.00 $33.00 92.75% E 602-43210-200 Office Supplies $200.00 $75.00 $0.00 $125.00 37.50% E 602-43210-210 Operating Supplies $2,400.00 $550.47 $5.49 $1,849.53 22.94% E 602-43210-240 Small Tools and Minor Equip $550.00 $0.00 $0.00 $550.00 0.00% E 602-43210-303 Engineering Fees $8,000.00 $5,146.00 $373.50 $2,854.00 64.33% E 602-43210-308 Other Professional Services $2,200.00 $1,409.50 $389.00 $790.50 64.07% E 602-43210-309 Software Support & Maintenance $1,200.00 $0.00 $0.00 $1,200.00 0.00% E 602-43210-317 Employee Training $1,400.00 $130.00 $0.00 $1,270.00 9.29% E 602-43210-321 Telephone $2,100.00 $1,305.05 $197.46 $794.95 62.15% E 602-43210-322 Postage $550.00 $0.00 $0.00 $550.00 0.00% E 602-43210-331 Travel Expenses $200.00 $0.00 $0.00 $200.00 0.00% E 602-43210-334 Licenses & Permits $1,600.00 $714.00 $0.00 $886.00 44.63% E 602-43210-361 Liability/Property Ins $1,100.00 $1,648.86 $0.00 -$548.86 149.90% E 602-43210-381 Utilities-Electric & Gas $2,500.00 $1,011.50 $139.41 $1,488.50 40.46% E 602-43210-385 Sewer Pumping & Maintenance $9,000.00 $0.00 $0.00 $9,000.00 0.00% E 602-43210-386 Operation & Maintenance $5,000.00 $1,574.26 $0.00 $3,425.74 31.49% E 602-43210-404 Repair Machinery/Equipment $16,000.00 $10,064.69 $0.00 $5,935.31 62.90% E 602-43210-413 Equipment Rental $350.00 $0.00 $0.00 $350.00 0.00% E 602-43210-420 Depreciation Expense $51,200.00 $0.00 $0.00 $51,200.00 0.00% E 602-43210-438 Misc. Contractual $9,000.00 $0.00 $0.00 $9,000.00 0.00% E 602-43210-530 Capital Impr Other Than Bldgs $29,000.00 $0.00 $0.00 $29,000.00 0.00% TOTAL BIG MARINE SEWER EXPENDITURES 167,005.00$ 30,612.32$ 1,596.81$ 136,392.68$ 18.33% 612 UPTOWN SEWER FUND Revenue Accounts 23,000.00$ 3,393.38$ 122.36$ $19,606.62 14.75% Expenditure Accounts E 612-43210-101 Regular Wages & Salaries $8,700.00 $1,977.74 $133.95 $6,722.26 22.73% E 612-43210-121 PERA Coord. Employer Contribu.$700.00 $131.06 $10.05 $568.94 18.72% E 612-43210-122 FICA Employer Contribution $500.00 $115.15 $7.53 $384.85 23.03% E 612-43210-126 MEDICARE Employer Contribution $100.00 $29.55 $1.76 $70.45 29.55% E 612-43210-151 Worker s Comp Insurance Prem $235.00 $217.00 $0.00 $18.00 92.34% E 612-43210-200 Office Supplies $100.00 $0.00 $0.00 $100.00 0.00% E 612-43210-210 Operating Supplies $200.00 $0.00 $0.00 $200.00 0.00% E 612-43210-221 Equipment Parts $200.00 $0.00 $0.00 $200.00 0.00% E 612-43210-303 Engineering Fees $300.00 $600.00 $600.00 -$300.00 200.00% E 612-43210-308 Other Professional Services $400.00 $128.00 $64.00 $272.00 32.00% E 612-43210-317 Employee Training $350.00 $0.00 $0.00 $350.00 0.00% E 612-43210-322 Postage $45.00 $0.00 $0.00 $45.00 0.00% E 612-43210-334 Licenses & Permits $400.00 $209.00 $0.00 $191.00 52.25% E 612-43210-361 Liability/Property Ins $300.00 $370.37 $0.00 -$70.37 123.46% E 612-43210-381 Utilities-Electric & Gas $1,700.00 $425.70 $13.74 $1,274.30 25.04% E 612-43210-385 Sewer Pumping & Maintenance $1,200.00 -$260.00 $0.00 $1,460.00 -21.67% E 612-43210-386 Operation & Maintenance $600.00 $0.00 $0.00 $600.00 0.00% E 612-43210-404 Repair Machinery/Equipment $1,500.00 $0.00 $0.00 $1,500.00 0.00% E 612-43210-420 Depreciation Expense $4,877.00 $0.00 $0.00 $4,877.00 0.00% E 612-43210-438 Misc. Contractual $1,200.00 $0.00 $0.00 $1,200.00 0.00% E 612-43210-530 Capital Impr Other Than Bldgs $4,000.00 $0.00 $0.00 $4,000.00 0.00% TOTAL UPTOWN SEWER EXPENDITURES 27,607.00$ 3,943.57$ 831.03$ $23,663.43 14.28% TOTAL REVENUE WITHOUT TRANSFERS 3,249,194.00$ 2,260,178.46$ 1,730,134.46$ 989,015.54$ 69.56% TOTAL REVENUE ACCOUNTS 3,249,194.00$ 5,234,579.98$ 2,967,479.46$ 1,213,926.88$ 161.10% TOTAL EXPENDITURES WITHOUT TRANSFERS 3,690,702.00$ 2,094,998.09$ 334,654.71$ 1,595,703.91$ 56.76% TOTAL EXPENDITURE ACCOUNTS 4,035,697.00$ 5,397,098.49$ 1,571,654.71$ (1,361,401.49)$ 133.73% Page 4 of 4