Loading...
06.b Monthly Treasurer's Report City of Scandia aug Treasurer’s Report 2/28/2023 FUND ACCOUNTING Beginning Cash Balance $ 4,066,642.37 2/1/2023 Beginning Checking Balance$ 81,033.66 Checking Receipts $ 67,934.34 Transfers to Checking $ 175,000.00 Total Deposits $ 242,934.34 Expenditures$ (135,136.05) Payroll$ (31,893.66) Transfer to EDA in Transit Total Payments $ (167,029.71) Ending Checking Balance $ 156,938.29 Beginnging Money Market Balance $ 1,914,925.09 Money Market Receipts $ 357.66 Tranfer to Checking $ (175,000.00) 0 Ending Money Market Balance $ 1,740,282.75 Beginning Investments Balance $ 2,043,003.90 Investments Receipts Ending Investments Balance$ 2,043,003.90 Beginning EDA Balance$ 33,356.07 EDA Receipts $ - EDA Expenditures EDA De;posit in Transit EDA Transfers from Checking Ending EDA Balance$ 33,356.07 Outstanding Checks $ (61,778.44) 2/28/2023 Ending Cash Balance $ 3,911,802.57 CHECKING, MONEY MARKET & INVESTMENT CD's Checking *102$ 81,033.66 Beg Bal Credits$ 242,934.34 Debits$ (167,029.71) Transfer in Transit $ 156,938.29 End Bal Money Market *105 - Rate .25%$ 1,914,925.09 Beg Bal rate change from 1.25% Credits $ 357.66 Debits $ (175,000.00) End Bal$ 1,740,282.75 Investments CD *4422 - Rate .45% 12 mo., 3/25/2023$ 317,693.84 CD *4424 - Rate 2.50% 12 mo., 7/17/2023 $ 446,907.03 CD *4425 - Rate 2.875% 12 mo., 9/28/2023 $ 739,581.42 CD *4426 - Rate 3.50%% 12 mo., 1/29/2024 **NEW RATE $ 538,821.61 Total Investments$ 2,043,003.90 Total Bank & Investment Accounts $ 3,940,224.94 $ (61,778.44) Checks in Transit *3102 Transfer to EDA in Transit Deposit in transit money market $ 3,878,446.50 Total Adjusted Undesignated Funds Scandia EDA *6301 $ 33,356.07 Receipts Expenditures Checks in Transit Deposit in Transit Total Designated EDA Funds$ 33,356.07 Total Funds$ 3,911,802.57 Submitted by: Colleen Firkus, Treasurer 2023 CASH BALANCES END OF MONTH FUNDJANUARYFEBRUARY 101 GENERAL$1,365,932$1,204,052 203 COVID-19 RELIEF$456,363 $456,362.62 226 CABLE TV$11,271$12,786 230 GATEWAY TRAIL$0$0 307 BLACKTOP PROJECT 2007$6,731$0 313 EQUIPMENT CERTIFICATES$28,825$28,873 315 EQUIPMENT CERTIFICATES$15,951$0 317 EQUIPMENT CERTIFICATES$2,187$0 318 BLACKTOP PROJECT$20,270$45,284 401 CAPITAL IMPR$749,162$749,497 404 PARK CAP IMPR$148,177$148,797 406 EQUIPMENT REPLACEMENT$199,727$200,548 408 LOCAL ROAD IMPROVEMENT$916,080$910,085 602 BIG MARINE SEWER$80,462$74,771 612 UPTOWN SEWER$10,330$15,160 801 ESCROW$21,817$32,240 SUBTOTAL$4,033,286$3,878,456 225 EDA$33,356$33,356 TOTAL$4,066,642$3,911,812 General Fund cash is off $10.00 due to audit journal entries. CITY OF SCANDIA Revenue - Expenditure Summary Feb-23 2023 YTD Budget 2023 BudgetAmountFebruaryBalance% of BudgetComments Description GENERAL FUND RevenueR 101-41000-31000 Washington Cty. Tax Settlement$1,865,918.00$0.00$0.00$1,865,918.000.00% R 101-41000-31040 Fiscal Disparities$0.00$0.00$0.00$0.000.00% R 101-41000-31701 Gravel Taxes$20,000.00$0.00$0.00$20,000.000.00% R 101-41000-31830 Solar Energy Production Tax$6,000.00$0.00$0.00$6,000.000.00% R 101-41000-31900 Penalties & Interest Del Tax$400.00$0.00$0.00$400.000.00% R 101-41000-32150 Utility Permits$3,000.00$600.00$150.00$2,400.0020.00% R 101-41000-32180 Tobacco & Liquor Licenses$10,000.00$50.00$50.00$9,950.000.50% R 101-41000-32190 Other City Permits$3,000.00$325.00$100.00$2,675.0010.83% R 101-41000-32210 Building Permits$145,000.00$31,043.60$28,825.10$113,956.4021.41% R 101-41000-32260 Gambling Permits$100.00$0.00$0.00$100.000.00% R 101-41000-33401 LGA/MVHC/AG/PERA Aid$7,000.00$0.00$0.00$7,000.000.00% R 101-41000-33420 Fire Relief State PERA$37,000.00$0.00$0.00$37,000.000.00% R 101-41000-33422 Other State Grants & Aids$11,000.00$1,722.00$1,722.00$9,278.0015.65% R 101-41000-33428 PILOT$6,000.00$0.00$0.00$6,000.000.00% R 101-41000-33620 Recycling Grant$10,500.00$0.00$0.00$10,500.000.00% R 101-41000-33630 Local Govt Grants & Aids$0.00$0.00$0.00$0.000.00% R 101-41000-33640 Other Grants$1,200.00$0.00$0.00$1,200.000.00% R 101-41000-34103 Zoning and Planning$6,700.00$1,200.00$1,150.00$5,500.0017.91% R 101-41000-34106 Engineering Fees$500.00$0.00$0.00$500.000.00% R 101-41000-34107 Assessment Search Fees$0.00$5.00$0.00($5.00)0.00% R 101-41000-34109 Water Usage$100.00$0.00$0.00$100.000.00% R 101-41000-34201 Impound Fees$0.00$0.00$0.00$0.000.00% R 101-41000-34202 Fire Protection Services$34,300.00$0.00$0.00$34,300.000.00% R 101-41000-34301 Damage Repairs$0.00$0.00$0.00$0.000.00% R 101-41000-34303 Dust Control$2,700.00$0.00$0.00$2,700.000.00% R 101-41000-34304 Reimbursement for Services$3,000.00$0.00$0.00$3,000.000.00% R 101-41000-34305 Other Street Services$0.00$0.00$0.00$0.000.00% R 101-41000-34730 Ad Revenue$0.00$0.00$0.00$0.000.00% R 101-41000-34750 Facilities Rental$5,500.00$616.67$316.67$4,883.3311.21% R 101-41000-34760 Cleaning Fees$100.00$0.00$0.00$100.000.00% R 101-41000-34790 Recreation Programs$2,100.00$760.00$0.00$1,340.0036.19% R 101-41000-35101 Fines & Forfeitures$7,400.00$326.65$326.65$7,073.354.41% R 101-41000-36210 Interest Income$12,100.00$3,990.54$358.63$8,109.4632.98% R 101-41000-36230 Donations$2,000.00$2,851.10$395.10($851.10)142.56% R 101-41000-36240 Insurance Dividend$4,100.00$0.00$0.00$4,100.000.00% R 101-41000-36250 Misc. Refund$3,800.00$0.00$0.00$3,800.000.00% R 101-41000-39200 Interfund Operating Transfer$0.00$0.00$0.00$0.000.00% R 101-41000-39204 Money Market Transfer$0.00$0.00$0.00$0.000.00% R 101-41910-32210 Building Permits$0.00$0.00$0.00$0.000.00% R 101-45000-34730 Ad Revenue$0.00$0.00$0.00$0.000.00% Total General Fund Revenue$2,210,518.00$43,490.56$33,394.15$2,167,027.441.97% Operating TransfersR 101-49000-39203 Transfer from Other Funds$0.00$215,000.00$0.00($215,000.00) R 101-49000-39204 Money Market Transfer$0.00$175,000.00$175,000.00($175,000.00) Total Operating Transfers$390,000.00$175,000.00($390,000.00) GENERAL FUNDADMINISTRATION & FINANCE ExpenditureE 101-41000-101 Regular Wages & Salaries$192,700.00$4,550.12$6,764.62$188,149.882.36% E 101-41000-121 PERA Coord. Employer Contribu.$13,400.00($2,261.55)$507.36$15,661.55-16.88% E 101-41000-122 FICA Employer Contribution$11,900.00($383.04)$406.10$12,283.04-3.22% E 101-41000-126 MEDICARE Employer Contribution$2,700.00$771.95$94.97$1,928.0528.59% E 101-41000-131 Employer Paid Health$47,300.00$3,571.73$1,785.87$43,728.277.55% E 101-41000-132 Dental Insurance$3,400.00$109.62$54.81$3,290.383.22% E 101-41000-134 Employer Paid Life$600.00$36.80$0.00$563.206.13% E 101-41000-135 Employer Paid Disability$900.00$119.50$59.75$780.5013.28% E 101-41000-151 Worker s Comp Insurance Prem$1,300.00$0.00$0.00$1,300.000.00% E 101-41000-200 Office Supplies$1,100.00$19.68$19.68$1,080.321.79% E 101-41000-203 Printed Forms & Papers$1,900.00$0.00$0.00$1,900.000.00% E 101-41000-210 Operating Supplies$800.00$9.90$9.90$790.101.24% E 101-41000-300 Assessor$0.00$0.00$0.00$0.000.00% E 101-41000-301 Auditing and Acct g Services$23,500.00$0.00$0.00$23,500.000.00% E 101-41000-303 Engineering Fees$0.00$0.00$0.00$0.000.00% E 101-41000-304 Legal Services$55,000.00$4,023.75$4,023.75$50,976.257.32% E 101-41000-306 Personal Testing & Recruit$0.00$0.00$0.00$0.000.00% E 101-41000-308 Other Professional Services$1,000.00$9,782.50$9,782.50($8,782.50)978.25% E 101-41000-309 Software Support & Maintenance$18,200.00$954.71$1,179.76$17,245.295.25% E 101-41000-314 Animal Control$0.00$0.00$0.00$0.000.00% E 101-41000-316 Conferences & Seminars$700.00$0.00$0.00$700.000.00% E 101-41000-317 Employee Training$200.00$0.00$0.00$200.000.00% E 101-41000-319 Other Services$46,700.00$435.00$0.00$46,265.000.93% E 101-41000-321 Telephone$3,700.00$799.56$424.64$2,900.4421.61% E 101-41000-322 Postage$2,200.00$34.66$34.66$2,165.341.58% E 101-41000-331 Travel Expenses$600.00$0.00$0.00$600.000.00% E 101-41000-351 Legal Notices Publishing$1,200.00$839.66$196.13$360.3469.97% E 101-41000-361 Liability/Property Ins$7,100.00$10,967.38$10,967.38($3,867.38)154.47% E 101-41000-365 Insurance Claims$0.00$1,000.00$1,000.00($1,000.00)0.00% E 101-41000-381 Utilities-Electric & Gas$13,000.00$314.75$314.75$12,685.252.42% E 101-41000-413 Equipment Rental$1,900.00$364.26$364.26$1,535.7419.17% E 101-41000-430 Recycling$30,100.00$0.00$0.00$30,100.000.00% E 101-41000-433 Dues and Subscriptions$6,100.00$0.00$0.00$6,100.000.00% E 101-41000-434 Youth Service Bureau$5,500.00$0.00$0.00$5,500.000.00% E 101-41000-435 Misc Expense$500.00$0.00$0.00$500.000.00% E 101-41000-438 Misc. Contractual$4,000.00$463.75$463.75$3,536.2511.59% E 101-41000-439 Refunds Issued$0.00$0.00$0.00$0.000.00% E 101-41000-560 Furniture and Fixtures$0.00$0.00$0.00$0.000.00% E 101-41000-570 Office Equipment$5,500.00$0.00$0.00$5,500.000.00% E 101-41000-720 Operating Transfers$0.00$0.00$0.00$0.000.00% Total Admin & Finance Dept. Expenditures$504,700.00$36,524.69$38,454.64$468,175.317.24% GENERAL FUND CONT.CITY COUNCIL ExpendituresE 101-41110-101 Regular Wages & Salaries$18,100.00$0.00$0.00$18,100.000.00% E 101-41110-122 FICA Employer Contribution$1,100.00$53.15$0.00$1,046.854.83% E 101-41110-126 MEDICARE Employer Contribution$300.00($52.08)$0.00$352.08-17.36% E 101-41110-127 PERA Defined$600.00($42.87)$0.00$642.87-7.15% E 101-41110-151 Worker s Comp Insurance Prem$100.00$0.00$0.00$100.000.00% E 101-41110-308 Other Professional Services$0.00$0.00$0.00$0.000.00% E 101-41110-316 Conferences & Seminars$700.00$0.00$0.00$700.000.00% E 101-41110-331 Travel Expenses$0.00$0.00$0.00$0.000.00% E 101-41110-439 Refunds Issued$0.00$0.00$0.00$0.000.00% E 101-41110-560 Furniture and Fixtures$0.00$0.00$0.00$0.000.00% E 101-41110-570 Office Equipment$0.00$0.00$0.00$0.000.00% Total City Council Dept. Expenditures$20,900.00($41.80)$0.00$20,941.80-0.20% ELECTIONS ExpendituresE 101-41410-199 Election Judge$0.00$0.00$0.00$0.000.00% E 101-41410-200 Office Supplies$0.00$0.00$0.00$0.000.00% E 101-41410-203 Printed Forms & Papers$0.00$0.00$0.00$0.000.00% E 101-41410-210 Operating Supplies$200.00$0.00$0.00$200.000.00% E 101-41410-351 Legal Notices Publishing$0.00$0.00$0.00$0.000.00% E 101-41410-413 Equipment Rental$850.00$1,515.00$1,515.00($665.00)178.24% Total Elections Dept. Expenditures$1,050.00$1,515.00$1,515.00($465.00)144.29% PLANNING & BUILDING ExpendituresE 101-41910-101 Regular Wages & Salaries$59,600.00$14,175.86$2,489.02$45,424.1423.79% E 101-41910-121 PERA Coord. Employer Contribu.$4,200.00$429.02$186.68$3,770.9810.21% E 101-41910-122 FICA Employer Contribution$3,700.00$844.54$145.44$2,855.4622.83% E 101-41910-126 MEDICARE Employer Contribution$900.00$219.91$34.02$680.0924.43% E 101-41910-131 Employer Paid Health$20,000.00$2,028.14$1,014.07$17,971.8610.14% E 101-41910-132 Dental Insurance$1,500.00$73.08$36.54$1,426.924.87% E 101-41910-134 Employer Paid Life$200.00$11.20$0.00$188.805.60% E 101-41910-135 Employer Paid Disability$500.00$63.30$31.65$436.7012.66% E 101-41910-203 Printed Forms & Papers$600.00$0.00$0.00$600.000.00% E 101-41910-311 Contract Permit Inspections$50,000.00$3,889.90$3,889.90$46,110.107.78% E 101-41910-312 Planning Services$50,000.00$94.85$6,754.85$49,905.150.19% E 101-41910-313 Committee & Commission Reimbur$5,000.00$0.00$0.00$5,000.000.00% E 101-41910-316 Conferences & Seminars$50.00$0.00$0.00$50.000.00% E 101-41910-319 Other Services$0.00$0.00$0.00$0.000.00% E 101-41910-361 Liability/Property Ins$4,900.00$5,400.60$5,400.60($500.60)110.22% E 101-41910-438 Misc. Contractual$5,000.00$0.00$0.00$5,000.000.00% E 101-41910-439 Refunds Issued$200.00$0.00$0.00$200.000.00% E 101-41910-720 Operating Transfers$0.00$0.00$0.00$0.000.00% Total Planning & Building Dept. Expenditures$206,350.00$27,230.40$19,982.77$179,119.6013.20% ASSESSOR ExpendituresE 101-41960-300 Assessor$21,600.00$3,600.00$1,800.00$18,000.0016.67% POLICE ExpendituresE 101-42100-318 Police Contract$168,499.00$0.00$0.00$168,499.000.00% E 101-42100-319 Other Services$500.00$309.36$0.00$190.6461.87% Total GF Police Dept. Expenditures$168,999.00$309.36$0.00$168,689.640.18% FIRE GENERAL FUND CONT. ExpendituresE 101-42200-101 Regular Wages & Salaries$147,200.00$9,712.54$10,463.65$137,487.466.60% E 101-42200-121 PERA Coord. Employer Contribu.$0.00$0.00$0.00$0.000.00% E 101-42200-122 FICA Employer Contribution$9,100.00$546.41$495.93$8,553.596.00% E 101-42200-124 Police & Fire PERA$3,600.00$1,471.32$739.47$2,128.6840.87% E 101-42200-126 MEDICARE Employer Contribution$2,100.00($103.41)$153.21$2,203.41-4.92% E 101-42200-134 Employer Paid Life$200.00$16.00$0.00$184.008.00% E 101-42200-135 Employer Paid Disability$700.00$0.00$0.00$700.000.00% E 101-42200-141 Unemployment Compensation$0.00$0.00$0.00$0.000.00% E 101-42200-151 Worker s Comp Insurance Prem$9,100.00$0.00$0.00$9,100.000.00% E 101-42200-200 Office Supplies$400.00$0.00$0.00$400.000.00% E 101-42200-203 Printed Forms & Papers$150.00$0.00$0.00$150.000.00% E 101-42200-209 Medical Supplies$3,000.00$195.50$195.50$2,804.506.52% E 101-42200-210 Operating Supplies$8,000.00$153.50$153.50$7,846.501.92% E 101-42200-211 Cleaning Supplies$100.00$0.00$0.00$100.000.00% E 101-42200-212 Fuel$3,500.00$252.25$252.25$3,247.757.21% E 101-42200-217 Uniforms & Safety Equipment$10,000.00$76.80$76.80$9,923.200.77% E 101-42200-221 Equipment Parts$3,000.00$55.73$55.73$2,944.271.86% E 101-42200-222 Tires$0.00$0.00$0.00$0.000.00% E 101-42200-223 Structure Repair & Supplies$2,000.00$185.61$185.61$1,814.399.28% E 101-42200-240 Small Tools and Minor Equip$9,000.00$38.00$38.00$8,962.000.42% E 101-42200-305 Medical Services$3,500.00$2,550.00$2,550.00$950.0072.86% E 101-42200-306 Personal Testing & Recruit$1,300.00$0.00$0.00$1,300.000.00% E 101-42200-309 Software Support & Maintenance$17,000.00$528.00$528.00$16,472.003.11% E 101-42200-310 Medical Training$2,000.00$0.00$0.00$2,000.000.00% E 101-42200-316 Conferences & Seminars$250.00$0.00$0.00$250.000.00% E 101-42200-317 Employee Training$15,000.00$570.00$5,745.00$14,430.003.80% E 101-42200-319 Other Services$500.00$0.00$0.00$500.000.00% E 101-42200-321 Telephone$6,800.00$754.77$531.76$6,045.2311.10% E 101-42200-322 Postage$0.00$0.00$0.00$0.000.00% E 101-42200-324 State of MN-Fire Relief$35,300.00$0.00$0.00$35,300.000.00% E 101-42200-325 City Match-Fire Relief$0.00$0.00$0.00$0.000.00% E 101-42200-331 Travel Expenses$1,500.00$182.96$182.96$1,317.0412.20% E 101-42200-334 Licenses & Permits$200.00$0.00$0.00$200.000.00% E 101-42200-340 Advertising$0.00$0.00$0.00$0.000.00% E 101-42200-361 Liability/Property Ins$6,500.00$6,989.37$6,989.37($489.37)107.53% E 101-42200-381 Utilities-Electric & Gas$8,000.00$1,738.12$1,738.12$6,261.8821.73% E 101-42200-384 Refuse/Garbage Disposal$1,100.00$92.02$184.04$1,007.988.37% E 101-42200-385 Sewer Pumping & Maintenance$700.00$0.00$0.00$700.000.00% E 101-42200-401 Building Maintenance/Repairs$2,500.00$228.03$228.03$2,271.979.12% E 101-42200-403 Improvements Other Than Bldgs$0.00$0.00$0.00$0.000.00% E 101-42200-404 Repair Machinery/Equipment$8,000.00$0.00$0.00$8,000.000.00% E 101-42200-407 Well Repair & Maintenance$0.00$0.00$0.00$0.000.00% E 101-42200-433 Dues and Subscriptions$2,400.00$100.00$100.00$2,300.004.17% E 101-42200-438 Misc. Contractual$4,100.00$0.00$0.00$4,100.000.00% E 101-42200-440 Events$800.00$0.00$0.00$800.000.00% E 101-42200-520 Capital Improvements to Bldgs$0.00$0.00$0.00$0.000.00% E 101-42200-530 Capital Impr Other Than Bldgs$0.00$0.00$0.00$0.000.00% E 101-42200-540 Heavy Machinery Capital$0.00$0.00$0.00$0.000.00% E 101-42200-560 Furniture and Fixtures$500.00$0.00$0.00$500.000.00% E 101-42200-570 Office Equipment$900.00$0.00$0.00$900.000.00% E 101-42200-720 Operating Transfers$0.00$0.00$0.00$0.000.00% Total Fire Dept Expenditures$330,000.00$26,333.52$31,586.93$303,666.487.98% ANIMAL CONTROL ExpendituresE 101-42700-314 Animal Control$5,000.00$356.25$356.25$4,643.757.13% PUBLIC WORKS GENERAL FUND CONT. ExpendituresE 101-43000-101 Regular Wages & Salaries$229,700.00$33,945.65$17,577.31$195,754.3514.78% E 101-43000-102 OT Regular Wages$5,000.00$2,535.66$806.33$2,464.3450.71% E 101-43000-104 Temporary Employee Wages$2,300.00$2,821.10$823.40($521.10)122.66% E 101-43000-121 PERA Coord. Employer Contribu.$17,600.00$2,721.58$1,378.74$14,878.4215.46% E 101-43000-122 FICA Employer Contribution$14,600.00$2,107.25$1,101.53$12,492.7514.43% E 101-43000-126 MEDICARE Employer Contribution$3,400.00$681.64$264.24$2,718.3620.05% E 101-43000-131 Employer Paid Health$70,900.00$9,560.34$4,860.27$61,339.6613.48% E 101-43000-132 Dental Insurance$2,300.00$176.30$88.15$2,123.707.67% E 101-43000-134 Employer Paid Life$700.00$65.28$3.56$634.729.33% E 101-43000-135 Employer Paid Disability$1,700.00$289.60$144.80$1,410.4017.04% E 101-43000-141 Unemployment Compensation$0.00$0.00$0.00$0.000.00% E 101-43000-151 Worker s Comp Insurance Prem$19,800.00$0.00$0.00$19,800.000.00% E 101-43000-200 Office Supplies$600.00$0.00$0.00$600.000.00% E 101-43000-210 Operating Supplies$8,400.00$91.40$91.40$8,308.601.09% E 101-43000-212 Fuel$20,000.00$4,719.63$4,719.63$15,280.3723.60% E 101-43000-217 Uniforms & Safety Equipment$2,200.00$201.44$201.44$1,998.569.16% E 101-43000-221 Equipment Parts$14,000.00$8,772.50$8,154.14$5,227.5062.66% E 101-43000-222 Tires$7,500.00$0.00$0.00$7,500.000.00% E 101-43000-223 Structure Repair & Supplies$2,200.00$0.00$0.00$2,200.000.00% E 101-43000-224 Materials for Road Maintenance$16,500.00$504.68$504.68$15,995.323.06% E 101-43000-226 Sign Replacement and Repair$0.00$0.00$0.00$0.000.00% E 101-43000-228 Gravel$10,000.00$0.00$0.00$10,000.000.00% E 101-43000-229 Salt$20,000.00$18,093.42$13,782.74$1,906.5890.47% E 101-43000-240 Small Tools and Minor Equip$8,000.00$3,623.62$333.97$4,376.3845.30% E 101-43000-302 Surveying$0.00$0.00$0.00$0.000.00% E 101-43000-303 Engineering Fees$10,000.00($214.50)$379.50$10,214.50-2.15% E 101-43000-304 Legal Services$0.00$0.00$0.00$0.000.00% E 101-43000-305 Medical Services$1,200.00$99.90$99.90$1,100.108.33% E 101-43000-309 Software Support & Maintenance$2,000.00$5,000.00$390.00($3,000.00)250.00% E 101-43000-317 Employee Training$1,700.00$0.00$0.00$1,700.000.00% E 101-43000-319 Other Services$13,600.00$54.05$54.05$13,545.950.40% E 101-43000-321 Telephone$3,000.00$576.53$353.53$2,423.4719.22% E 101-43000-331 Travel Expenses$500.00$0.00$0.00$500.000.00% E 101-43000-334 Licenses & Permits$500.00$0.00$0.00$500.000.00% E 101-43000-361 Liability/Property Ins$9,000.00$8,348.14$8,348.14$651.8692.76% E 101-43000-365 Insurance Claims$0.00$0.00$0.00$0.000.00% E 101-43000-381 Utilities-Electric & Gas$4,000.00$1,203.96$1,219.74$2,796.0430.10% E 101-43000-384 Refuse/Garbage Disposal$1,000.00$61.36$122.72$938.646.14% E 101-43000-385 Sewer Pumping & Maintenance$1,600.00$0.00$0.00$1,600.000.00% E 101-43000-387 Street Light Utilities$4,200.00$618.48$618.48$3,581.5214.73% E 101-43000-401 Building Maintenance/Repairs$8,000.00$262.77$262.77$7,737.233.28% E 101-43000-403 Improvements Other Than Bldgs$0.00$0.00$0.00$0.000.00% E 101-43000-404 Repair Machinery/Equipment$15,500.00$6,203.74$6,203.74$9,296.2640.02% E 101-43000-405 Contractual Road Maint/Repair$157,500.00$0.00$0.00$157,500.000.00% E 101-43000-407 Well Repair & Maintenance$0.00$0.00$0.00$0.000.00% E 101-43000-413 Equipment Rental$4,000.00$0.00$0.00$4,000.000.00% E 101-43000-417 Uniform Rental$1,100.00$95.95$95.95$1,004.058.72% E 101-43000-433 Dues and Subscriptions$200.00$0.00$0.00$200.000.00% E 101-43000-438 Misc. Contractual$15,750.00$0.00$0.00$15,750.000.00% E 101-43000-439 Refunds Issued$0.00$0.00$0.00$0.000.00% E 101-43000-530 Capital Impr Other Than Bldgs$0.00$0.00$0.00$0.000.00% E 101-43000-550 Motor Vehicles Capital$0.00$0.00$0.00$0.000.00% E 101-43000-560 Furniture and Fixtures$0.00$0.00$0.00$0.000.00% E 101-43000-570 Office Equipment$1,000.00$0.00$0.00$1,000.000.00% E 101-43000-720 Operating Transfers$0.00$0.00$0.00$0.000.00% Total Public Works Dept. Expenditures$732,750.00$113,221.47$72,984.85$619,528.5315.45% GENERAL FUND CONT.PARKS & RECREATION ExpendituresE 101-45000-101 Regular Wages & Salaries$10,200.00$322.96$757.48$9,877.043.17% E 101-45000-104 Temporary Employee Wages$40,200.00$4,776.38$964.50$35,423.6211.88% E 101-45000-121 PERA Coord. Employer Contribu.$800.00$21.85$56.80$778.152.73% E 101-45000-122 FICA Employer Contribution$3,300.00$290.86$104.21$3,009.148.81% E 101-45000-126 MEDICARE Employer Contribution$800.00$95.46$24.38$704.5411.93% E 101-45000-131 Employer Paid Health$2,700.00$364.60$185.45$2,335.4013.50% E 101-45000-132 Dental Insurance$100.00$6.40$3.20$93.606.40% E 101-45000-134 Employer Paid Life$0.00$2.52$0.14($2.52)0.00% E 101-45000-135 Employer Paid Disability$1,000.00$11.34$5.67$988.661.13% E 101-45000-141 Unemployment Compensation$0.00$0.00$0.00$0.000.00% E 101-45000-151 Worker s Comp Insurance Prem$1,900.00$0.00$0.00$1,900.000.00% E 101-45000-200 Office Supplies$310.00$0.00$0.00$310.000.00% E 101-45000-203 Printed Forms & Papers$930.00$0.00$0.00$930.000.00% E 101-45000-210 Operating Supplies$930.00$0.00$0.00$930.000.00% E 101-45000-212 Fuel$1,650.00$113.96$57.98$1,536.046.91% E 101-45000-221 Equipment Parts$2,100.00$280.40$0.00$1,819.6013.35% E 101-45000-223 Structure Repair & Supplies$2,100.00$0.00$0.00$2,100.000.00% E 101-45000-240 Small Tools and Minor Equip$400.00$0.00$0.00$400.000.00% E 101-45000-312 Planning Services$0.00$0.00$0.00$0.000.00% E 101-45000-313 Committee & Commission Reimbur$1,200.00$0.00$0.00$1,200.000.00% E 101-45000-319 Other Services$0.00$0.00$0.00$0.000.00% E 101-45000-322 Postage$0.00$0.00$0.00$0.000.00% E 101-45000-340 Advertising$200.00$0.00$0.00$200.000.00% E 101-45000-353 Sales& Use Tax$0.00$0.00$2.00$0.000.00% E 101-45000-361 Liability/Property Ins$3,300.00$3,323.03$3,323.03($23.03)100.70% E 101-45000-381 Utilities-Electric & Gas$4,500.00$685.17$669.39$3,814.8315.23% E 101-45000-384 Refuse/Garbage Disposal$2,500.00$190.00$75.00$2,310.007.60% E 101-45000-385 Sewer Pumping & Maintenance$700.00$369.00$369.00$331.0052.71% E 101-45000-401 Building Maintenance/Repairs$4,800.00$775.00$775.00$4,025.0016.15% E 101-45000-403 Improvements Other Than Bldgs$0.00$0.00$0.00$0.000.00% E 101-45000-404 Repair Machinery/Equipment$750.00$0.00$0.00$750.000.00% E 101-45000-406 Grounds Care$4,000.00$0.00$0.00$4,000.000.00% E 101-45000-438 Misc. Contractual$3,300.00$0.00$1,752.75$3,300.000.00% E 101-45000-439 Refunds Issued$0.00$565.01$565.01($565.01)0.00% E 101-45000-440 Events$7,000.00$2,361.00$2,136.00$4,639.0033.73% E 101-45000-490 Financial Assistance$0.00$0.00$0.00$0.000.00% E 101-45000-530 Capital Impr Other Than Bldgs$10,000.00$0.00$0.00$10,000.000.00% E 101-45000-720 Operating Transfers$0.00$0.00$0.00$0.000.00% Total Parks & Rec Dept. Expenditures$111,670.00$14,554.94$11,826.99$97,115.0613.03% GENERAL FUND CONT.COMMUNITY CENTER ExpendituresE 101-45180-101 Regular Wages & Salaries$15,000.00$2,206.55$1,103.28$12,793.4514.71% E 101-45180-104 Temporary Employee Wages$0.00$0.00$0.00$0.000.00% E 101-45180-121 PERA Coord. Employer Contribu.$1,100.00$164.65$82.74$935.3514.97% E 101-45180-122 FICA Employer Contribution$900.00$122.63$64.69$777.3713.63% E 101-45180-126 MEDICARE Employer Contribution$200.00$38.09$15.14$161.9119.05% E 101-45180-131 Employer Paid Health$3,700.00$497.70$255.60$3,202.3013.45% E 101-45180-134 Employer Paid Life$0.00$4.20$0.30($4.20)0.00% E 101-45180-135 Employer Paid Disability$200.00$22.86$11.43$177.1411.43% E 101-45180-151 Worker s Comp Insurance Prem$0.00$0.00$0.00$0.000.00% E 101-45180-210 Operating Supplies$2,900.00$375.68$375.68$2,524.3212.95% E 101-45180-223 Structure Repair & Supplies$6,500.00$0.00$0.00$6,500.000.00% E 101-45180-334 Licenses & Permits$1,000.00$0.00$0.00$1,000.000.00% E 101-45180-361 Liability/Property Ins$800.00$795.60$795.60$4.4099.45% E 101-45180-381 Utilities-Electric & Gas$11,200.00$1,714.01$1,714.01$9,485.9915.30% E 101-45180-384 Refuse/Garbage Disposal$1,900.00$235.61$395.78$1,664.3912.40% E 101-45180-385 Sewer Pumping & Maintenance$3,700.00$0.00$0.00$3,700.000.00% E 101-45180-401 Building Maintenance/Repairs$15,000.00$620.59$620.59$14,379.414.14% E 101-45180-404 Repair Machinery/Equipment$5,000.00$50.00$50.00$4,950.001.00% E 101-45180-406 Grounds Care$690.00$0.00$0.00$690.000.00% E 101-45180-407 Well Repair & Maintenance$1,000.00$0.00$0.00$1,000.000.00% E 101-45180-438 Misc. Contractual$2,700.00$0.00$0.00$2,700.000.00% E 101-45180-439 Refunds Issued$0.00$450.00$450.00($450.00)0.00% E 101-45180-520 Capital Improvements to Bldgs$6,000.00$7,475.61$103.98($1,475.61)124.59% E 101-45180-530 Capital Impr Other Than Bldgs$0.00$0.00$0.00$0.000.00% E 101-45180-570 Office Equipment$0.00$0.00$0.00$0.000.00% E 101-45180-720 Operating Transfers$0.00$0.00$0.00$0.000.00% Total Community Center Dept. Expenditures$79,490.00$14,773.78$6,038.82$64,716.2218.59% Operating TransfersE 101-49000-720 Operating Transfers$0.00$390,000.00$175,000.00($390,000.00) TOTAL GENERAL FUND EXPENDITURES$2,182,509.00$238,377.61$184,546.25$1,944,131.3910.92% COVID RELIEF FUND RevenueR 203-46200-33150 Federal Grant$0.00$0.00$0.00$0.00 ExpendituresE 203-49000-720 Operating Transfers$0.00$0.00$0.00$0.00 EDA FUND Revenue R 225-46500-31000 Washington Cty. Tax Settlement$5,300.00$0.00$0.00$5,300.000.00% R 225-46500-33640 Other Grants$0.00$0.00$0.00$0.000.00% R 225-46500-34750 Facilities Rental$0.00$0.00$0.00$0.000.00% R 225-46500-36210 Interest Income$200.00$0.00$0.00$200.000.00% R 225-46500-36230 Donations$0.00$0.00$0.00$0.000.00% R 225-46500-39203 Transfer from Other Funds$0.00$3,524.94$0.00($3,524.94)0.00% Total EDA Fund Revenue$5,500.00$3,524.94$0.00$1,975.0664.09% Expenditure E 225-46500-210 Operating Supplies$500.00$3,524.94$0.00($3,024.94)704.99% E 225-46500-303 Engineering Fees$0.00$0.00$0.00$0.000.00% E 225-46500-304 Legal Services$0.00$0.00$0.00$0.000.00% E 225-46500-308 Other Professional Services$300.00$0.00$0.00$300.000.00% E 225-46500-340 Advertising$2,000.00$0.00$0.00$2,000.000.00% E 225-46500-433 Dues and Subscriptions$1,700.00$320.00$0.00$1,380.0018.82% E 225-46500-440 Events$800.00$0.00$0.00$800.000.00% E 225-46500-720 Operating Transfers$0.00$0.00$0.00$0.000.00% Total EDA Fund Expenditures$5,300.00$3,844.94$0.00$1,455.0672.55% CABLE TV FUND Revenue R 226-41950-36210 Interest Income$100.00$0.00$0.00$100.000.00% R 226-41950-38050 Cable TV Franchise Rebates$16,200.00$1,576.46$1,576.46$14,623.549.73% R 226-41950-38051 PEG Fees$4,200.00$438.71$438.71$3,761.2910.45% Total Cable TV Fund Revenue$20,500.00$2,015.17$2,015.17$18,484.839.83% Expenditure E 226-41950-240 Small Tools and Minor Equip$300.00$344.48$335.92($44.48)114.83% E 226-41950-309 Software Support & Maintenance$3,500.00$0.00$142.22$3,500.000.00% E 226-41950-438 Misc. Contractual$5,300.00$0.00$0.00$5,300.000.00% E 226-41950-570 Office Equipment$0.00$263.00$263.00($263.00)0.00% Total Cable TV Fund Expenditures$9,100.00$607.48$741.14$8,492.526.68% GATEWAY TRAIL FUND RevenueR 230-45000-36230 Donations$0.00$0.00$0.00$0.000.00% ExpendituresE 230-45000-308 Other Professional Services$0.00$0.00$0.00$0.000.00% 2013 EQUIPMENT CERTIFICATES Revenue R 313-47000-31000 Washington Cty. Tax Settlement$64,000.00$0.00$0.00$64,000.000.00% ExpenditureE 313-47000-601 Long Term Debt Principal$60,000.00$0.00$0.00$60,000.000.00% E 313-47000-611 Long Term Debt Interest$3,047.00$0.00$0.00$3,047.000.00% E 313-47000-620 Fiscal Agent s Fees$500.00$0.00$0.00$500.000.00% Total 2013 Fund Expenditures$63,547.00$0.00$0.00$63,547.000.00% 2018 STREET RECONSTRUCTION RevenueR 318-47000-31000 Washington Cty. Tax Settlement$342,546.00$0.00$0.00$342,546.000.00% ExpenditureE 318-47000-601 Long Term Debt Principal$250,000.00$0.00$0.00$250,000.000.00% E 318-47000-611 Long Term Debt Interest$91,225.00$0.00$0.00$91,225.000.00% E 318-47000-620 Fiscal Agent s Fees$500.00$0.00$0.00$500.000.00% Total 2018 Street Reconstruction Fund Expenditures$341,725.00$0.00$0.00$341,725.000.00% CAPITAL IMPROVEMENTS RevenueR 401-43100-36100 Special Assessments$0.00$0.00$0.00$0.000.00% R 401-48000-31000 Washington Cty. Tax Settlement$293,791.00$0.00$0.00$293,791.000.00% R 401-48000-33422 Other State Grants & Aids$0.00$0.00$0.00$0.000.00% R 401-48000-36210 Interest Income$2,300.00$0.00$0.00$2,300.000.00% Total Capital Improvement Fund Revenue$296,091.00$0.00$0.00$296,091.000.00% ExpenditureE 401-41000-312 Planning Services$0.00$0.00$0.00$0.000.00% E 401-41000-520 Capital Improvements to Bldgs$0.00$0.00$0.00$0.000.00% E 401-41000-530 Capital Impr Other Than Bldgs$169,500.00$0.00$0.00$169,500.000.00% E 401-42200-520 Capital Improvements to Bldgs$65,000.00$0.00$0.00$65,000.000.00% E 401-48000-435 Misc Expense$0.00$4,800.00$2,400.00($4,800.00)0.00% E 401-48000-438 Misc. Contractual$0.00$0.00$0.00$0.000.00% E 401-48000-520 Capital Improvements to Bldgs$0.00$0.00$0.00$0.000.00% E 401-48000-530 Capital Impr Other Than Bldgs$100,000.00$0.00$0.00$100,000.000.00% Total Capital Improvement Fund Expenditures$334,500.00$4,800.00$2,400.00$329,700.001.43% PARK DEVELOPMENT RevenueR 404-48000-31000 Washington Cty. Tax Settlement$20,000.00$0.00$0.00$20,000.000.00% R 404-48000-33422 Other State Grants & Aids$0.00$0.00$0.00$0.000.00% R 404-48000-34780 Park Dedication Fees$21,000.00$0.00$0.00$21,000.000.00% R 404-48000-36210 Interest Income$66.00$0.00$0.00$66.000.00% R 404-48000-36230 Donations$0.00$10,000.00$0.00($10,000.00)0.00% Total Park Development Fund Revenue$41,066.00$10,000.00$0.00$31,066.0024.35% ExpenditureE 404-48000-312 Planning Services$0.00$0.00$0.00$0.000.00% E 404-48000-520 Capital Improvements to Bldgs$17,306.00$0.00$0.00$17,306.000.00% E 404-48000-720 Operating Transfers$0.00$0.00$0.00$0.000.00% Total Park Development Fund Expenditures$17,306.00$0.00$0.00$17,306.000.00% EQUIPMENT REPLACEMENT RevenueR 406-48500-31000 Washington Cty. Tax Settlement$0.00$0.00$0.00$0.000.00% R 406-48500-36210 Interest Income$1,030.00$0.00$0.00$1,030.000.00% R 406-48500-36260 Sale of Equipment$35,000.00$0.00$0.00$35,000.000.00% R 406-48500-39350 Certificate of Indebtedness$819,500.00$0.00$0.00$819,500.000.00% Total Equipment Replacement Fund Revenue$855,530.00$0.00$0.00$855,530.000.00% ExpenditureE 406-48500-540 Heavy Machinery Capital$325,000.00$0.00$0.00$325,000.000.00% E 406-48500-550 Motor Vehicles Capital$189,500.00$0.00$0.00$189,500.000.00% Total Equipment Replacement Fund Expenditures$514,500.00$0.00$0.00$514,500.000.00% LOCAL ROAD IMPROVEMENT FUND RevenueR 408-43100-31000 Washington Cty. Tax Settlement$212,012.00$0.00$0.00$212,012.000.00% R 408-43100-33422 Other State Grants & Aids$0.00$0.00$0.00$0.000.00% R 408-43100-36210 Interest Income$12,115.00$0.00$0.00$12,115.000.00% R 408-43100-39310 Proceeds-Gen Obligation Bond$0.00$0.00$0.00$0.000.00% Total LRIF Revenue$224,127.00$0.00$0.00$224,127.00$0.00 ExpenditureE 408-43100-303 Engineering Fees$20,000.00$0.00$10,400.10$20,000.000.00% E 408-43100-530 Capital Impr Other Than Bldgs$973,000.00$260.08$260.08$972,739.920.03% Total LRIF Expenditures$993,000.00$260.08$10,660.18$992,739.920.03% BIG MARINE SEWER RevenueR 602-43210-31951 Special Assessments Principal$0.00$0.00$0.00$0.000.00% R 602-43210-31952 SA Penalties & Interest$0.00$0.00$0.00$0.000.00% R 602-43210-33422 Other State Grants & Aids$0.00$0.00$0.00$0.000.00% R 602-43210-34401 Sewer User Fees$140,700.00$635.00$0.00$140,065.000.45% R 602-43210-34402 Sewer Connection Fee$0.00$8,000.00$8,000.00($8,000.00)0.00% R 602-43210-36100 Special Assessments$600.00$0.00$0.00$600.000.00% R 602-43210-36102 Penalties and Interest$0.00$0.00$0.00$0.000.00% R 602-43210-36210 Interest Income$400.00$0.00$0.00$400.000.00% Total Big Marine Sewer Revenue$141,700.00$8,635.00$8,000.00$133,065.006.09% ExpenditureE 602-43210-101 Regular Wages & Salaries$22,500.00$3,351.13$1,675.56$19,148.8714.89% E 602-43210-120 Pension Expense$0.00$0.00$0.00$0.000.00% E 602-43210-121 PERA Coord. Employer Contribu.$17,000.00$250.12$125.68$16,749.881.47% E 602-43210-122 FICA Employer Contribution$1,400.00$186.15$98.37$1,213.8513.30% E 602-43210-126 MEDICARE Employer Contribution$300.00$58.03$23.01$241.9719.34% E 602-43210-131 Employer Paid Health$0.00$0.00$0.00$0.000.00% E 602-43210-151 Worker s Comp Insurance Prem$700.00$0.00$0.00$700.000.00% E 602-43210-200 Office Supplies$200.00$0.00$0.00$200.000.00% E 602-43210-210 Operating Supplies$2,500.00$0.00$0.00$2,500.000.00% E 602-43210-240 Small Tools and Minor Equip$600.00$0.00$0.00$600.000.00% E 602-43210-303 Engineering Fees$10,500.00$0.00$1,367.00$10,500.000.00% E 602-43210-304 Legal Services$0.00$0.00$0.00$0.000.00% E 602-43210-308 Other Professional Services$2,500.00$273.00$273.00$2,227.0010.92% E 602-43210-309 Software Support & Maintenance$1,300.00$0.00$0.00$1,300.000.00% E 602-43210-317 Employee Training$1,400.00$0.00$0.00$1,400.000.00% E 602-43210-321 Telephone$2,400.00$560.97$916.45$1,839.0323.37% E 602-43210-322 Postage$600.00$0.00$0.00$600.000.00% E 602-43210-331 Travel Expenses$200.00$0.00$0.00$200.000.00% E 602-43210-334 Licenses & Permits$1,600.00$0.00$0.00$1,600.000.00% E 602-43210-361 Liability/Property Ins$3,000.00$0.00$0.00$3,000.000.00% E 602-43210-381 Utilities-Electric & Gas$2,500.00$3,667.35$3,667.35($1,167.35)146.69% E 602-43210-385 Sewer Pumping & Maintenance$15,000.00$0.00$0.00$15,000.000.00% E 602-43210-386 Operation & Maintenance$5,000.00$2,139.00$2,139.00$2,861.0042.78% E 602-43210-404 Repair Machinery/Equipment$16,000.00($0.20)$3,455.80$16,000.200.00% E 602-43210-413 Equipment Rental$400.00$0.00$0.00$400.000.00% E 602-43210-420 Depreciation Expense$54,300.00$0.00$0.00$54,300.000.00% E 602-43210-438 Misc. Contractual$10,000.00$0.00$0.00$10,000.000.00% E 602-43210-439 Refunds Issued$0.00$0.00$0.00$0.000.00% E 602-43210-530 Capital Impr Other Than Bldgs$9,800.00$0.00$0.00$9,800.000.00% Total Big Marine Sewer Expenditures$181,700.00$10,485.55$13,741.22$171,214.455.77% UPTOWN SEWER RevenueR 612-43210-34401 Sewer User Fees$22,300.00$0.00$0.00$22,300.000.00% R 612-43210-36210 Interest Income$200.00$0.00$0.00$200.000.00% Total Uptown Sewer Revenue$22,500.00$0.00$0.00$22,500.000.00% ExpenditureE 612-43210-101 Regular Wages & Salaries$9,700.00$1,437.16$718.58$8,262.8414.82% E 612-43210-121 PERA Coord. Employer Contribu.$700.00$107.37$53.94$592.6315.34% E 612-43210-122 FICA Employer Contribution$600.00$79.87$42.19$520.1313.31% E 612-43210-126 MEDICARE Employer Contribution$100.00$24.83$9.86$75.1724.83% E 612-43210-151 Worker s Comp Insurance Prem$200.00$0.00$0.00$200.000.00% E 612-43210-200 Office Supplies$100.00$0.00$0.00$100.000.00% E 612-43210-210 Operating Supplies$300.00$0.00$0.00$300.000.00% E 612-43210-221 Equipment Parts$300.00$0.00$0.00$300.000.00% E 612-43210-303 Engineering Fees$1,000.00$0.00$0.00$1,000.000.00% E 612-43210-308 Other Professional Services$500.00$0.00$0.00$500.000.00% E 612-43210-309 Software Support & Maintenance$0.00$0.00$0.00$0.000.00% E 612-43210-317 Employee Training$350.00$0.00$0.00$350.000.00% E 612-43210-319 Other Services$0.00$0.00$0.00$0.000.00% E 612-43210-322 Postage$0.00$0.00$0.00$0.000.00% E 612-43210-334 Licenses & Permits$400.00$0.00$0.00$400.000.00% E 612-43210-361 Liability/Property Ins$400.00$477.82$477.82($77.82)119.46% E 612-43210-381 Utilities-Electric & Gas$1,700.00$172.26$172.26$1,527.7410.13% E 612-43210-385 Sewer Pumping & Maintenance$1,500.00$0.00$0.00$1,500.000.00% E 612-43210-386 Operation & Maintenance$700.00$0.00$0.00$700.000.00% E 612-43210-404 Repair Machinery/Equipment$2,000.00$0.00$0.00$2,000.000.00% E 612-43210-420 Depreciation Expense$5,100.00$0.00$0.00$5,100.000.00% E 612-43210-438 Misc. Contractual$1,300.00$0.00$0.00$1,300.000.00% E 612-43210-530 Capital Impr Other Than Bldgs$4,500.00$0.00$0.00$4,500.000.00% Total Uptown Sewer Expenditures$31,450.00$2,299.31$1,474.65$29,150.697.31%