Loading...
06.b Treasurer's Monthly ReportCity of Scandiaaug Treasurer’sReport 5/31/2022 FUND ACCOUNTING Beginning Cash Balance $ 3,696,984.575/1/2022 Beginning Checking Balance$ 17,404.96 Checking Receipts 67,378.40 Transfers to Checking 260,000.00 Total Deposits 327,378.40 Expenditures$ (243,616.82) Payroll$ (34,340.40) Total Payments 277,957.22) Ending Checking Balance 66,826.14 Beginnging Money Market Balance 1,636,729.39 Money Market Receipts 306.01 Tranfers to Checking 260,000.00) Ending Money Market Balance 1,377,035.40 Beginning Investments Balance 2,029,375.47 Investments Receipts Ending Investments Balance$ 2,029,375.47 Beginning EDA Balance$ 27,757.55 EDA Receipts EDA Expenditures 358.00) EDA Transfers from Checking - in transit Ending EDA Balance$ 27,399.55 Outstanding Checks 7,683.92) 5/31/2022EndingCashBalance $ 3,492,952.64 CHECKING, MONEY MARKET & INVESTMENT CD's Checking *102$ 17,459.96BegBal Credits$ 327,378.40 Debits$ (278,012.22) 66,826.14EndBal Money Market *105 - Rate .25%$ 1,636,729.39BegBal rate change from 1.25% Credits 306.01 Debits 260,000.00) End Bal$ 1,377,035.40 Investments CD *4422 - Rate .45% 12 mo., 3/25/2023$ 317,215.61 CD *4424 - Rate .30% 12 mo., 7/25/2022$ 441,025.35 CD *4425 - Rate .30% 12 mo., 9/28/2022$ 733,528.95 CD *4426 - Rate .30% 12 mo., 1/29/2023 537,605.56 Total Investments$ 2,029,375.47 Total Bank & Investment Accounts 3,473,237.01 7,683.92) Checks in Transit *3102 Deposit in transit checking Deposit in transit money market 3,465,553.09TotalAdjustedUndesignatedFunds Scandia EDA *6301 $ 27,757.55 Receipts Expenditures Checks in Transit$ (358.00) Deposit in Transit Total Designated EDA Funds$ 27,399.55 Total Funds$ 3,492,952.64 Submitted by: Colleen Firkus, Treasurer CASH BALANCES 2022END OF MONTH FUNDJANUARYFEBRUARYMARCHAPRILMAY 101 GENERAL$1,375,256$1,243,314$1,124,142$1,012,874$890,925 203 COVID-19 RELIEF$228,181$228,181$228,181$228,181$228,181 226 CABLE TV$39,431$41,288$42,941$43,837$44,302 230 RESTRICTED DONATIONS$175$175$925$2,525$3,575 307 BLACKTOP PROJECT 2007$0$0$6,464$6,464$6,464 313 EQUIPMENT CERTIFICATES$24,314$24,314$24,314$25,110$25,110 315 EQUIPMENT CERTIFICATES$15,452$15,452$15,452$15,951$15,951 317 EQUIPMENT CERTIFICATES($298)($298)($298)$103$103 318 BLACKTOP PROJECT$603$603$603$4,359($45,198) 401 CAPITAL IMPR$818,050$811,650$719,740$716,800$716,431 404 PARK CAP IMPR$144,888$144,888$153,888$154,216$154,216 406 EQUIPMENT REPLACEMENT$316,105$316,105$316,105$104,260$104,260 408 LOCAL ROAD IMPROVEMENT$1,258,340$1,248,056$1,220,766$1,226,717$1,220,617 602 BIG MARINE SEWER$96,113$91,196$78,022$79,321$49,281 612 UPTOWN SEWER$14,094$16,430$15,021$15,051$14,348 801 ESCROW$33,341$38,526$34,870$33,870$36,986 SUBTOTAL$4,364,046$4,219,882$3,981,137$3,669,640$3,465,553 225 EDA$28,904$28,904$27,703$27,345$27,400 TOTAL$4,392,949$4,248,785$4,008,839$3,696,985$3,492,953 2022YTD 2022BudgetYTD AmountMay AmountBudget% ofBudgetDescription GENERAL FUND RevenueR 101-41000-31000 Washington Cty. Tax Settlement$1,583,000.00$0.00$0.00$1,583,000.000.00% R101-41000-31040 Fiscal Disparities$0.00$0.00$0.00$0.000.00% R101-41000-31701 Gravel Taxes$20,000.00$0.00$0.00$20,000.000.00% R101-41000-31830 Solar Energy Production Tax$5,000.00$0.00$0.00$5,000.000.00% R101-41000-31900 Penalties & Interest Del Tax$400.00$0.00$0.00$400.000.00% R 101-41000-32150 Utility Permits$3,000.00$2,250.00$150.00$750.0075.00% R101-41000-32180 Tobacco & Liquor Licenses$8,500.00$397.00$0.00$8,103.004.67% R 101-41000-32190 Other City Permits$3,000.00$1,240.00$150.00$1,760.0041.33% R 101-41000-32210 Building Permits$135,000.00$62,340.26$20,309.64$72,659.7446.18% R 101-41000-32260 Gambling Permits$0.00$115.00$0.00($115.00)0.00% R101-41000-33401 LGA/MVHC/AG/PERA Aid$13,200.00$0.00$0.00$13,200.000.00% R101-41000-33420 Fire Relief State PERA$39,600.00$0.00$0.00$39,600.000.00% R101-41000-33422 Other State Grants & Aids$5,400.00$0.00$0.00$5,400.000.00% R 101-41000-33428 PILOT$6,000.00$0.00$0.00$6,000.000.00% R 101-41000-33620 Recycling Grant$9,000.00$0.00$0.00$9,000.000.00% R101-41000-33630 Local Govt Grants & Aids$0.00$0.00$0.00$0.000.00% R101-41000-33640 Other Grants$1,000.00$0.00$0.00$1,000.000.00% R101-41000-34102 Legal Services$0.00$0.00$0.00$0.000.00% R101-41000-34103 Zoning and Planning$4,300.00$1,400.00$800.00$2,900.0032.56% R101-41000-34106 Engineering Fees$0.00$0.00$0.00$0.000.00% R101-41000-34107 Assessment Search Fees$100.00$20.00$0.00$80.0020.00% R101-41000-34109 Water Usage$200.00$0.00$0.00$200.000.00% R101-41000-34201 Impound Fees$0.00$0.00$0.00$0.000.00% R101-41000-34202 Fire Protection Services$31,493.00$31,493.00$31,493.00$0.00100.00% R101-41000-34301 Damage Repairs$0.00$0.00$0.00$0.000.00% R101-41000-34303 Dust Control$2,400.00$0.00$0.00$2,400.000.00% R101-41000-34304 Reimbursement for Services$3,600.00$900.00$0.00$2,700.0025.00% R101-41000-34305 Other Street Services$0.00$0.00$0.00$0.000.00% R101-41000-34730 Ad Revenue$2,100.00$1,250.00$150.00$850.0059.52% R101-41000-34740 Coffee Sales$0.00$0.00$0.00$0.000.00% R 101-41000-34750 Facilities Rental$5,000.00$5,459.80$975.00($459.80)109.20% R101-41000-34760 Cleaning Fees$200.00$0.00$0.00$200.000.00% R101-41000-34790 Recreation Programs$1,000.00$1,400.00$0.00($400.00)140.00% R101-41000-34950 Solar Subscription$0.00$0.00$0.00$0.000.00% R101-41000-35101 Fines & Forfeitures$7,000.00$2,736.38$578.27$4,263.6239.09% R101-41000-35201 Forfeited Land Sales$0.00$0.00$0.00$0.000.00% R101-41000-36210 Interest Income$15,900.00$3,924.72$306.82$11,975.2824.68% R101-41000-36230 Donations$1,500.00$2,841.35($930.00)($1,341.35)189.42% R101-41000-36240 Insurance Dividend$2,000.00$0.00$0.00$2,000.000.00% R101-41000-36250 Misc. Refund$2,500.00$149.85$49.95$2,350.155.99% 1,911,393.00$117,917.36$54,032.68$1,793,475.646.17% MiscellaneousR 101-49000-39203 Transfer from Other Funds$0.00$25,000.00$25,000.00($25,000.00)0.00% R101-49000-39204 Money Market Transfer$0.00$270,000.00$260,000.00($270,000.00)0.00% 295,000.00$285,000.00($295,000.00) 2022YTD 2022BudgetYTD AmountMay AmountBudget% ofBudgetDescription GENERAL FUND ExpenditureE 101-41000-101 Regular Wages & Salaries$162,600.00$58,784.94$11,988.94$103,815.0636.15% E101-41000-121 PERA Coord. Employer Contribu.$12,000.00$4,398.36$899.19$7,601.6436.65% E101-41000-122 FICA Employer Contribution$10,100.00$2,625.76$720.58$7,474.2426.00% E101-41000-126 MEDICARE Employer Contribution$2,400.00$927.97$168.52$1,472.0338.67% E101-41000-131 Employer Paid Health$23,600.00$10,387.89$1,748.24$13,212.1144.02% E101-41000-132 Dental Insurance$2,900.00$403.05$80.61$2,496.9513.90% E 101-41000-134 Employer Paid Life$600.00$200.00$40.00$400.0033.33% E 101-41000-135 Employer Paid Disability$1,200.00$209.45$41.89$990.5517.45% E101-41000-151 Worker s Comp Insurance Prem$1,200.00$1,728.55$0.00($528.55)144.05% E101-41000-200 Office Supplies$1,000.00$266.38$21.88$733.6226.64% E101-41000-203 Printed Forms & Papers$1,800.00$973.07$0.00$826.9354.06% E101-41000-210 Operating Supplies$900.00$501.83$145.84$398.1755.76% E101-41000-301 Auditing and Acct gServices$20,800.00$17,200.00$17,200.00$3,600.0082.69% E101-41000-304 Legal Services$40,000.00$15,125.40$5,231.90$24,874.6037.81% E101-41000-308 Other Professional Services$1,000.00$1,403.95$0.00($403.95)140.40% E101-41000-309 Software Support & Maintenance$12,000.00$11,460.80$8,490.10$539.2095.51% E101-41000-316 Conferences & Seminars$800.00$1,049.00$399.00($249.00)131.13% E101-41000-317 Employee Training$500.00$0.00$0.00$500.000.00% E101-41000-319 Other Services$1,300.00$39.00$0.00$1,261.003.00% E101-41000-321 Telephone$4,500.00$1,976.91$368.18$2,523.0943.93% E 101-41000-322 Postage$2,300.00$942.31$369.95$1,357.6940.97% E101-41000-331 Travel Expenses$2,500.00$268.62$0.00$2,231.3810.74% E101-41000-351 Legal Notices Publishing$2,000.00$868.65$641.42$1,131.3543.43% E101-41000-361 Liability/Property Ins$4,100.00$4,568.15$4,568.15($468.15)111.42% E101-41000-381 Utilities-Electric & Gas$12,000.00$1,939.36$911.97$10,060.6416.16% E101-41000-413 Equipment Rental$2,800.00$514.22$86.71$2,285.7818.37% E 101-41000-430 Recycling$27,800.00$11,602.50$2,320.50$16,197.5041.74% E101-41000-433 Dues and Subscriptions$5,900.00$104.00$0.00$5,796.001.76% E101-41000-434 Youth Service Bureau$5,500.00$0.00$0.00$5,500.000.00% E101-41000-438 Misc. Contractual$3,600.00$3,562.00$82.00$38.0098.94% E101-41000-570 Office Equipment$4,000.00$2,603.23$0.00$1,396.7765.08% 373,700.00$156,635.35$56,525.57$217,064.6541.91% 150.00 enc) City CouncilE 101-41110-101 Regular Wages & Salaries$18,100.00$4,486.39$0.00$13,613.6124.79% E101-41110-122 FICA Employer Contribution$1,100.00$106.30$0.00$993.709.66% E101-41110-126 MEDICARE Employer Contribution$300.00$12.97$0.00$287.034.32% E101-41110-127 PERA Defined$600.00$138.58$0.00$461.4223.10% E101-41110-151 Worker s Comp Insurance Prem$100.00$0.00$0.00$100.000.00% E101-41110-316 Conferences & Seminars$1,000.00$398.00$398.00$602.0039.80% E101-41110-331 Travel Expenses$1,800.00$0.00$0.00$1,800.000.00% 23,000.00$5,142.24$398.00$17,857.7622.36% ElectionsE 101-41410-199 Election Judge$4,800.00$0.00$0.00$4,800.000.00% E101-41410-200 Office Supplies$100.00$0.00$0.00$100.000.00% E101-41410-203 Printed Forms & Papers$0.00$0.00$0.00$0.000.00% E101-41410-210 Operating Supplies$1,000.00$0.00$0.00$1,000.000.00% E101-41410-351 Legal Notices Publishing$200.00$0.00$0.00$200.000.00% E101-41410-413 Equipment Rental$1,500.00$1,515.00$0.00($15.00)101.00% 7,600.00$1,515.00$0.00$6,085.0019.93% Planning & BuildingE 101-41910-101 Regular Wages & Salaries$49,800.00$20,472.69$3,872.66$29,327.3141.11% E101-41910-121 PERA Coord. Employer Contribu.$3,600.00$1,534.42$290.46$2,065.5842.62% E101-41910-122 FICA Employer Contribution$3,100.00$1,184.43$225.04$1,915.5738.21% E101-41910-126 MEDICARE Employer Contribution$700.00$289.83$52.62$410.1741.40% E101-41910-131 Employer Paid Health$11,400.00$5,064.73$857.84$6,335.2744.43% E101-41910-132 Dental Insurance$1,900.00$208.45$41.69$1,691.5510.97% E 101-41910-134 Employer Paid Life$200.00$72.00$14.40$128.0036.00% E 101-41910-135 Employer Paid Disability$400.00$167.65$33.53$232.3541.91% E101-41910-203 Printed Forms & Papers$20.00$253.55$0.00($233.55)1267.75% E101-41910-311 Contract Permit Inspections$55,000.00$19,228.29$6,950.50$35,771.7134.96% E101-41910-312 Planning Services$28,000.00$3,543.48$0.00$24,456.5212.66% E101-41910-313 Committee & Commission Reimbur$5,000.00$1,300.00$0.00$3,700.0026.00% E101-41910-361 Liability/Property Ins$1,800.00$2,005.53$2,005.53($205.53)111.42% E101-41910-438 Misc. Contractual$11,000.00$2,342.32$2,227.32$8,657.6821.29% E101-41910-439 Refunds Issued$0.00($572.80)($572.80)$572.800.00% 171,920.00$57,094.57$15,998.79$114,825.4333.21% 2022YTD 2022BudgetYTD AmountMay AmountBudget% ofBudgetDescription GENERAL FUND CONT. AssessorE 101-41960-300 Assessor$21,600.00$9,000.00$1,800.00$12,600.0041.67% PoliceE 101-42100-318 Police Contract$150,400.00$0.00$0.00$150,400.000.00% E101-42100-319 Other Services$500.00$309.36$0.00$190.6461.87% 150,900.00$309.36$0.00$150,590.640.21% Fire DeptE 101-42200-101 Regular Wages & Salaries$95,000.00$41,809.28$10,555.19$53,190.7244.01% E101-42200-121 PERA Coord. Employer Contribu.$9,700.00$0.00$0.00$9,700.000.00% E101-42200-122 FICA Employer Contribution$5,900.00$2,215.03$535.48$3,684.9737.54% E 101-42200-124 Police & Fire PERA$0.00$3,532.35$642.75($3,532.35)0.00% E101-42200-126 MEDICARE Employer Contribution$1,400.00$284.40$154.53$1,115.6020.31% E 101-42200-134 Employer Paid Life$200.00$80.00$16.00$120.0040.00% E 101-42200-135 Employer Paid Disability$700.00$0.00$0.00$700.000.00% E101-42200-151 Worker s Comp Insurance Prem$9,550.00$12,640.48$0.00($3,090.48)132.36% E101-42200-200 Office Supplies$400.00$0.00$0.00$400.000.00% E101-42200-203 Printed Forms & Papers$150.00$0.00$0.00$150.000.00% E101-42200-209 Medical Supplies$2,500.00$2,152.61$0.00$347.3986.10% E101-42200-210 Operating Supplies$8,000.00$685.83$411.03$7,314.178.57% E101-42200-211 Cleaning Supplies$100.00$17.88$0.00$82.1217.88% E 101-42200-212 Fuel$2,500.00$1,174.46$474.32$1,325.5446.98% E101-42200-217 Uniforms & Safety Equipment$10,000.00$0.00$0.00$10,000.000.00% E101-42200-221 Equipment Parts$3,000.00$204.50$204.50$2,795.506.82% E101-42200-222 Tires$0.00$1,540.36$0.00($1,540.36)0.00% E101-42200-223 Structure Repair & Supplies$5,300.00$12.84$12.84$5,287.160.24% E101-42200-240 Small Tools and Minor Equip$8,500.00$7,942.44$25.98$557.5693.44% E101-42200-305 Medical Services$4,500.00$5,470.00$595.00($970.00)121.56% E101-42200-306 Personal Testing & Recruit$1,500.00$0.00$0.00$1,500.000.00% E101-42200-309 Software Support & Maintenance$17,000.00$4,912.56$528.00$12,087.4428.90% E101-42200-310 Medical Training$11,000.00$0.00$0.00$11,000.000.00% E101-42200-316 Conferences & Seminars$300.00$0.00$0.00$300.000.00% E101-42200-317 Employee Training$8,000.00($7,500.00)$0.00$15,500.00-93.75% E101-42200-319 Other Services$500.00$70.00$70.00$430.0014.00% E101-42200-321 Telephone$6,400.00$2,445.28$218.72$3,954.7238.21% E 101-42200-322 Postage$0.00$0.00$0.00$0.000.00% E101-42200-324 State of MN-Fire Relief$35,300.00$0.00$0.00$35,300.000.00% E101-42200-325 City Match-Fire Relief$0.00$0.00$0.00$0.000.00% E101-42200-331 Travel Expenses$2,000.00$0.00$0.00$2,000.000.00% E101-42200-334 Licenses & Permits$200.00$0.00$0.00$200.000.00% E101-42200-361 Liability/Property Ins$6,000.00$6,685.09$6,685.09($685.09)111.42% E101-42200-381 Utilities-Electric & Gas$4,000.00$5,679.06$579.91($1,679.06)141.98% E101-42200-384 Refuse/Garbage Disposal$850.00$409.75$97.89$440.2548.21% E101-42200-385 Sewer Pumping & Maintenance$700.00$300.00$300.00$400.0042.86% E101-42200-401 Building Maintenance/Repairs$2,500.00$1,152.46$150.00$1,347.5446.10% E101-42200-404 Repair Machinery/Equipment$8,000.00$2,204.59$111.82$5,795.4127.56% E101-42200-407 Well Repair & Maintenance$140.00$0.00$0.00$140.000.00% E101-42200-433 Dues and Subscriptions$2,100.00$1,095.00$0.00$1,005.0052.14% E101-42200-438 Misc. Contractual$4,100.00$1,605.00$1,605.00$2,495.0039.15% E101-42200-440 Events$800.00$0.00$0.00$800.000.00% E101-42200-530 Capital Impr Other Than Bldgs$0.00$1,178.00$0.00($1,178.00)0.00% E101-42200-540 Heavy Machinery Capital$0.00$0.00$0.00$0.000.00% E101-42200-560 Furniture and Fixtures$500.00$0.00$0.00$500.000.00% E101-42200-570 Office Equipment$900.00$0.00$0.00$900.000.00% 280,190.00$99,999.25$23,974.05$180,190.7535.69% Animal ControlE 101-42700-314 Animal Control$4,000.00$1,075.04$150.00$3,074.9626.88% 2022YTD 2022BudgetYTD AmountMay AmountBudget% ofBudgetDescription GENERAL FUND CONT. Public WorksE 101-43000-101 Regular Wages & Salaries$220,300.00$82,231.59$16,857.36$138,068.4137.33% E101-43000-102 OT Regular Wages$4,900.00$6,723.46$90.71($1,823.46)137.21% E101-43000-104 Temporary Employee Wages$3,700.00$2,721.07$0.00$978.9373.54% E101-43000-121 PERA Coord. Employer Contribu.$16,900.00$6,655.42$1,271.12$10,244.5839.38% E101-43000-122 FICA Employer Contribution$14,000.00$5,970.48$993.56$8,029.5242.65% E101-43000-126 MEDICARE Employer Contribution$3,300.00$1,419.04$232.37$1,880.9643.00% E101-43000-131 Employer Paid Health$53,600.00$26,029.07$4,306.12$27,570.9348.56% E101-43000-132 Dental Insurance$2,000.00$415.70$83.14$1,584.3020.79% E 101-43000-134 Employer Paid Life$700.00$305.04$58.16$394.9643.58% E 101-43000-135 Employer Paid Disability$1,700.00$723.95$144.79$976.0542.59% E101-43000-141 Unemployment Compensation$1,500.00$0.00$0.00$1,500.000.00% E101-43000-151 Worker s Comp Insurance Prem$16,890.00$22,366.65$0.00($5,476.65)132.43% E101-43000-200 Office Supplies$600.00$0.00$0.00$600.000.00% E101-43000-210 Operating Supplies$8,000.00$3,822.89$358.38$4,177.1147.79% E 101-43000-212 Fuel$18,000.00$8,039.73$1,240.48$9,960.2744.67% E101-43000-217 Uniforms & Safety Equipment$2,000.00$343.81$0.00$1,656.1917.19% E101-43000-221 Equipment Parts$12,100.00$6,363.86$319.50$5,736.1452.59% E101-43000-222 Tires$6,500.00$0.00$0.00$6,500.000.00% E101-43000-223 Structure Repair & Supplies$2,000.00$0.00$0.00$2,000.000.00% E101-43000-224 Materials for Road Maintenance$15,000.00$3,459.21$453.09$11,540.7923.06% E101-43000-226 Sign Replacement and Repair$2,000.00$75.00$0.00$1,925.003.75% E101-43000-228 Gravel$9,900.00$0.00$0.00$9,900.000.00% E 101-43000-229 Salt$19,000.00$15,652.75$15,281.00$3,347.2582.38% E101-43000-240 Small Tools and Minor Equip$5,000.00$32.09$0.00$4,967.910.64% E 101-43000-302 Surveying$0.00$0.00$0.00$0.000.00% E101-43000-303 Engineering Fees$9,400.00$3,079.00$1,130.00$6,321.0032.76% E101-43000-304 Legal Services$0.00$0.00$0.00$0.000.00% E101-43000-305 Medical Services$1,200.00$407.70$49.95$792.3033.98% E101-43000-309 Software Support & Maintenance$1,900.00$0.00$0.00$1,900.000.00% E101-43000-317 Employee Training$1,700.00$0.00$0.00$1,700.000.00% E101-43000-319 Other Services$13,200.00$1,139.26$8.10$12,060.748.63% E101-43000-321 Telephone$4,800.00$1,808.83$396.91$2,991.1737.68% E101-43000-331 Travel Expenses$500.00$0.00$0.00$500.000.00% E101-43000-334 Licenses & Permits$500.00$173.25$0.00$326.7534.65% E101-43000-361 Liability/Property Ins$9,300.00$10,361.91$10,361.91($1,061.91)111.42% E101-43000-365 Insurance Claims$0.00$0.00$0.00$0.000.00% E101-43000-381 Utilities-Electric & Gas$3,200.00$3,905.78$411.95($705.78)122.06% E101-43000-384 Refuse/Garbage Disposal$900.00$580.57$65.26$319.4364.51% E101-43000-385 Sewer Pumping & Maintenance$800.00$755.80$200.00$44.2094.48% E 101-43000-387 Street Light Utilities$4,000.00$1,890.58$344.70$2,109.4247.26% E101-43000-401 Building Maintenance/Repairs$5,500.00$1,022.47$225.44$4,477.5318.59% E101-43000-404 Repair Machinery/Equipment$14,000.00$378.25$65.00$13,621.752.70% E101-43000-405 Contractual Road Maint/Repair$150,000.00$0.00$0.00$150,000.000.00% E101-43000-413 Equipment Rental$3,500.00$45.10$0.00$3,454.901.29% E101-43000-417 Uniform Rental$1,000.00$322.46$76.36$677.5432.25% E101-43000-433 Dues and Subscriptions$200.00$0.00$0.00$200.000.00% E101-43000-438 Misc. Contractual$15,000.00$0.00$0.00$15,000.000.00% E101-43000-439 Refunds Issued$0.00$0.00$0.00$0.000.00% E101-43000-530 Capital Impr Other Than Bldgs$0.00$1,178.00$0.00($1,178.00)0.00% E101-43000-560 Furniture and Fixtures$0.00$0.00$0.00$0.000.00% E101-43000-570 Office Equipment$3,300.00$589.49$589.49$2,710.5117.86% 683,490.00$220,989.26$55,614.85$462,500.7432.33% 2022YTD 2022BudgetYTD AmountMay AmountBudget% ofBudgetDescription GENERAL FUND CONT. ParksE 101-45000-101 Regular Wages & Salaries$9,800.00$3,060.68$734.38$6,739.3231.23% E101-45000-104 Temporary Employee Wages$29,100.00$7,634.13$868.00$21,465.8726.23% E101-45000-121 PERA Coord. Employer Contribu.$700.00$228.10$55.08$471.9032.59% E101-45000-122 FICA Employer Contribution$2,600.00$638.77$96.89$1,961.2324.57% E101-45000-126 MEDICARE Employer Contribution$600.00$166.37$22.65$433.6327.73% E101-45000-131 Employer Paid Health$2,100.00$1,302.97$260.93$797.0362.05% E101-45000-132 Dental Insurance$100.00$15.10$3.02$84.9015.10% E 101-45000-134 Employer Paid Life$0.00$59.76$11.84($59.76)0.00% E 101-45000-135 Employer Paid Disability$1,000.00$155.25$31.05$844.7515.53% E101-45000-151 Worker s Comp Insurance Prem$1,450.00$1,914.86$0.00($464.86)132.06% E101-45000-200 Office Supplies$300.00$0.00$0.00$300.000.00% E101-45000-203 Printed Forms & Papers$900.00$0.00$0.00$900.000.00% E101-45000-210 Operating Supplies$900.00$219.33$0.00$680.6724.37% E 101-45000-212 Fuel$1,500.00$450.77$0.00$1,049.2330.05% E101-45000-221 Equipment Parts$2,000.00$161.78$161.78$1,838.228.09% E101-45000-223 Structure Repair & Supplies$500.00$0.00$0.00$500.000.00% E101-45000-240 Small Tools and Minor Equip$0.00$359.90$0.00($359.90)0.00% E101-45000-313 Committee & Commission Reimbur$1,200.00$240.00$0.00$960.0020.00% E101-45000-319 Other Services$0.00$121.60$0.00($121.60)0.00% E 101-45000-322 Postage$0.00$0.00$0.00$0.000.00% E101-45000-340 Advertising$0.00$180.00$0.00($180.00)0.00% E101-45000-353 Sales& Use Tax$0.00$0.00$0.00$0.000.00% E101-45000-361 Liability/Property Ins$7,100.00$7,910.69$7,910.69($810.69)111.42% E101-45000-381 Utilities-Electric & Gas$4,000.00$3,507.28$925.42$492.7287.68% E101-45000-384 Refuse/Garbage Disposal$1,900.00$1,333.13$578.13$566.8770.16% E101-45000-385 Sewer Pumping & Maintenance$500.00$142.97$0.00$357.0328.59% E101-45000-401 Building Maintenance/Repairs$6,000.00$287.98$0.00$5,712.024.80% E101-45000-403 Improvements Other Than Bldgs$0.00$1,486.49$0.00($1,486.49)0.00% E101-45000-404 Repair Machinery/Equipment$700.00$100.00$0.00$600.0014.29% E101-45000-406 Grounds Care$4,000.00$0.00$0.00$4,000.000.00% E101-45000-438 Misc. Contractual$3,000.00$0.00$0.00$3,000.000.00% E101-45000-439 Refunds Issued$0.00$0.00$0.00$0.000.00% E101-45000-440 Events$3,000.00$6,492.69$550.04($3,492.69)216.42% E101-45000-490 Financial Assistance$0.00$0.00$0.00$0.000.00% E101-45000-530 Capital Impr Other Than Bldgs$10,000.00$0.00$0.00$10,000.000.00% 94,950.00$38,170.60$12,209.90$56,779.4040.20% Community CenterE 101-45180-101 Regular Wages & Salaries$14,400.00$5,596.75$1,191.33$8,803.2538.87% E101-45180-121 PERA Coord. Employer Contribu.$1,100.00$400.76$80.30$699.2436.43% E101-45180-122 FICA Employer Contribution$900.00$322.98$70.11$577.0235.89% E101-45180-126 MEDICARE Employer Contribution$200.00$84.69$16.42$115.3142.35% E101-45180-131 Employer Paid Health$3,100.00$1,256.27$242.10$1,843.7340.52% E 101-45180-134 Employer Paid Life$0.00$19.20$3.60($19.20)0.00% E 101-45180-135 Employer Paid Disability$100.00$57.20$11.44$42.8057.20% E101-45180-210 Operating Supplies$2,800.00$536.54$216.79$2,263.4619.16% E101-45180-223 Structure Repair & Supplies$6,500.00$8.77$0.00$6,491.230.13% E101-45180-334 Licenses & Permits$900.00$737.00$0.00$163.0081.89% E101-45180-361 Liability/Property Ins$2,300.00$2,562.62$2,562.62($262.62)111.42% E101-45180-381 Utilities-Electric & Gas$10,600.00$5,343.83$664.70$5,256.1750.41% E101-45180-384 Refuse/Garbage Disposal$1,800.00$650.76$153.42$1,149.2436.15% E101-45180-385 Sewer Pumping & Maintenance$3,500.00$1,575.81$0.00$1,924.1945.02% E101-45180-401 Building Maintenance/Repairs$13,000.00$6,674.53$3,819.30$6,325.4751.34% E101-45180-404 Repair Machinery/Equipment$3,000.00$0.00$0.00$3,000.000.00% E101-45180-406 Grounds Care$650.00$0.00$0.00$650.000.00% E101-45180-407 Well Repair & Maintenance$600.00$345.00$0.00$255.0057.50% E101-45180-438 Misc. Contractual$2,500.00$0.00$0.00$2,500.000.00% E101-45180-439 Refunds Issued$0.00$0.00$0.00$0.000.00% E101-45180-520 Capital Improvements to Bldgs$6,000.00$1,999.00$0.00$4,001.0033.32% 73,950.00$28,171.71$9,032.13$45,778.2938.10% E101-49000-720 Operating Transfers$0.00$295,000.00$285,000.00($295,000.00)0.00% TOTAL GENERAL FUND EXPENDITURES$1,885,300.00$618,102.38$175,703.29$1,267,347.6232.79% 2022YTD 2022BudgetYTD AmountMay AmountBudget% ofBudgetDescription COVID RELIEF FUND RevenueR 203-46200-33150 Federal Grant$0.00$0.00$0.00$0.000.00% ExpenditureE 101-49000-720 Operating Transfers$0.00$0.00$0.00$0.000.00% EDA FUND RevenueR 225-46500-31000 Washington Cty. Tax Settlement$8,000.00$0.00$0.00$8,000.000.00% R225-46500-33640 Other Grants$0.00$0.00$0.00$0.000.00% R225-46500-36210 Interest Income$200.00$0.00$0.00$200.000.00% 8,200.00$0.00$0.00$8,200.000.00% ExpenditureE 225-46500-210 Operating Supplies$0.00$0.00$0.00$0.000.00% E225-46500-303 Engineering Fees$5,000.00$0.00$0.00$5,000.000.00% E225-46500-304 Legal Services$0.00$0.00$0.00$0.000.00% E225-46500-308 Other Professional Services$125.00$0.00$0.00$125.000.00% E225-46500-340 Advertising$2,000.00$75.00$75.00$1,925.003.75% E225-46500-433 Dues and Subscriptions$2,650.00$1,653.00$0.00$997.0062.38% E225-46500-440 Events$400.00$286.00$0.00$114.0071.50% 10,175.00$2,014.00$75.00$8,161.0019.79% CABLE TV FUND RevenueR 226-41950-36210 Interest Income$0.00$0.00$0.00$0.000.00% R226-41950-38050 Cable TV Franchise Rebates$15,400.00$6,226.72$1,596.67$9,173.2840.43% R 226-41950-38051 PEG Fees$3,500.00$1,688.92$428.62$1,811.0848.25% 18,900.00$7,915.64$2,025.29$10,984.3641.88% ExpenditureE 226-41950-240 Small Tools and Minor Equip$0.00$498.00$0.00($498.00)0.00% E226-41950-309 Software Support & Maintenance$3,500.00$1,898.53$1,559.76$1,601.4754.24% E226-41950-438 Misc. Contractual$8,000.00$690.00$0.00$7,310.008.63% E226-41950-570 Office Equipment$250.00$0.00$0.00$250.000.00% 11,750.00$3,086.53$1,559.76$8,663.4726.27% GATEWAY TRAIL FUND RevenueR 230-45000-36230 Donations$0.00$3,400.00$1,050.00($3,400.00)0.00% ExpenditureE 230-45000-308 Other Professional Services$0.00$0.00$0.00$0.000.00% BLACKTOP PROJECCT 2007 RevenueR 307-47000-31952 SA Penalties & Interest$0.00$6,463.65$0.00($6,463.65)0.00% 2013 EQUIPMENT CERTIFICATES RevenueR 313-47000-31000 Washington Cty. Tax Settlement$67,000.00$0.00$0.00$67,000.000.00% ExpenditureE 313-47000-601 Long Term Debt Principal$60,000.00$0.00$0.00$60,000.000.00% E313-47000-611 Long Term Debt Interest$2,790.00$0.00$0.00$2,790.000.00% E313-47000-620 Fiscal Agent s Fees$495.00$0.00$0.00$495.000.00% 63,285.00$0.00$0.00$63,285.000.00% 2017 EQUIPMENT CERTIFICATES RevenueR 317-47000-31000 Washington Cty. Tax Settlement$34,524.00$0.00$0.00$34,524.000.00% ExpenditureE 317-47000-601 Long Term Debt Principal$32,000.00$0.00$0.00$32,000.000.00% E317-47000-611 Long Term Debt Interest$880.00$440.00$0.00$440.0050.00% E317-47000-620 Fiscal Agent s Fees$495.00$0.00$0.00$495.000.00% 33,375.00$440.00$0.00$32,935.001.32% 2018 STREET RECONSTRUCTION RevenueR 318-47000-31000 Washington Cty. Tax Settlement$344,531.00$0.00$0.00$344,531.000.00% ExpenditureE 318-47000-601 Long Term Debt Principal$230,000.00$0.00$0.00$230,000.000.00% E318-47000-611 Long Term Debt Interest$98,125.00$49,062.51$49,062.51$49,062.4950.00% E318-47000-620 Fiscal Agent s Fees$495.00$495.00$495.00$0.00100.00% 328,620.00$49,557.51$49,557.51$279,062.4915.08% 2022YTD 2022BudgetYTD AmountMay AmountBudget% ofBudgetDescription CAPITAL IMPROVEMENTS RevenueR 401-48000-31000 Washington Cty. Tax Settlement$217,336.00$0.00$0.00$217,336.000.00% R401-48000-33422 Other State Grants & Aids$240,625.00$0.00$0.00$240,625.000.00% R401-48000-36100 Special Assessments$510.00$0.00$0.00$510.000.00% R401-48000-36210 Interest Income$4,500.00$0.00$0.00$4,500.000.00% R401-48000-39200 Interfund Operating Transfer$200,000.00$0.00$0.00$200,000.000.00% 662,971.00$0.00$0.00$662,971.000.00% ExpenditureE 401-41000-312 Planning Services$0.00$2,726.25$0.00($2,726.25)0.00% E401-41000-520 Capital Improvements to Bldgs$0.00$12,750.00$0.00($12,750.00)0.00% E401-41000-530 Capital Impr Other Than Bldgs$319,280.00$4,950.00$0.00$314,330.001.55% E401-45180-520 Capital Improvements to Bldgs$52,000.00$16,609.43$369.04$35,390.5731.94% E401-48000-438 Misc. Contractual$286,000.00$0.00$0.00$286,000.000.00% 657,280.00$37,035.68$369.04$620,244.325.63% PARK DEVELOPMENT RevenueR 404-48000-31000 Washington Cty. Tax Settlement$20,000.00$0.00$0.00$20,000.000.00% R404-48000-33422 Other State Grants & Aids$104,000.00$0.00$0.00$104,000.000.00% R404-48000-34780 Park Dedication Fees$3,000.00$0.00$0.00$3,000.000.00% R404-48000-36210 Interest Income$1,200.00$0.00$0.00$1,200.000.00% R404-48000-36230 Donations$0.00$0.00$0.00$0.000.00% 128,200.00$0.00$0.00$128,200.000.00% ExpenditureE 404-48000-312 Planning Services$15,600.00$0.00$0.00$15,600.000.00% E404-48000-530 Capital Impr Other Than Bldgs$219,008.00$3,000.00$0.00$216,008.001.37% E404-48000-720 Operating Transfers$1,440.00$0.00$0.00$1,440.000.00% 236,048.00$3,000.00$0.00$233,048.001.27% EQUIPMENT REPLACEMENT FUND RevenueR 406-48500-31000 Washington Cty. Tax Settlement$87,800.00$0.00$0.00$87,800.000.00% R406-48500-36210 Interest Income$1,015.00$0.00$0.00$1,015.000.00% R406-48500-36260 Sale of Equipment$0.00$0.00$0.00$0.000.00% 88,815.00$0.00$0.00$88,815.000.00% ExpenditureE 406-48500-540 Heavy Machinery Capital$198,500.00$212,172.86$0.00($13,672.86)106.89% E406-48500-550 Motor Vehicles Capital$0.00$0.00$0.00$0.000.00% 198,500.00$212,172.86$0.00($13,672.86)106.89% LOCAL ROAD IMPROVEMENT FUND RevenueR 408-43100-31000 Washington Cty. Tax Settlement$216,860.00$0.00$0.00$216,860.000.00% R408-43100-36210 Interest Income$19,613.00$0.00$0.00$19,613.000.00% 236,473.00$0.00$0.00$236,473.000.00% ExpenditureE 408-43100-303 Engineering Fees$0.00$39,055.50$6,100.00($39,055.50)0.00% E408-43100-530 Capital Impr Other Than Bldgs$707,200.00$321.86$0.00$706,878.140.05% 707,200.00$39,377.36$6,100.00$667,822.645.57% 2022YTD 2022BudgetYTD AmountMay AmountBudget% ofBudgetDescription BIG MARINE SEWER RevneueR 602-43210-34401 Sewer User Fees$109,592.00$26,895.53$4,147.98$82,696.4724.54% R 602-43210-34402 SEWER HOOKUP FEE$0.00$0.00$0.00$0.000.00% R602-43210-36100 Special Assessments$300.00$0.00$0.00$300.000.00% R602-43210-36210 Interest Income$49.00$0.00$0.00$49.000.00% 109,941.00$26,895.53$4,147.98$83,045.4724.46% ExpenditureE 602-43210-101 Regular Wages & Salaries$21,600.00$8,273.39$1,634.49$13,326.6138.30% E602-43210-120 Pension Expense$0.00$0.00$0.00$0.000.00% E602-43210-121 PERA Coord. Employer Contribu.$1,600.00$619.52$122.61$980.4838.72% E602-43210-122 FICA Employer Contribution$1,300.00$477.53$95.96$822.4736.73% E602-43210-126 MEDICARE Employer Contribution$300.00$124.56$22.44$175.4441.52% E602-43210-151 Worker s Comp Insurance Prem$900.00$1,180.37$0.00($280.37)131.15% E602-43210-200 Office Supplies$200.00$85.00$0.00$115.0042.50% E602-43210-210 Operating Supplies$2,400.00$84.48$5.49$2,315.523.52% E602-43210-240 Small Tools and Minor Equip$550.00$0.00$0.00$550.000.00% E602-43210-303 Engineering Fees$10,400.00$5,068.50$2,179.00$5,331.5048.74% E602-43210-304 Legal Services$0.00$3,600.00$1,200.00($3,600.00)0.00% E602-43210-308 Other Professional Services$2,200.00$2,184.00$1,418.00$16.0099.27% E602-43210-309 Software Support & Maintenance$1,200.00$0.00$0.00$1,200.000.00% E602-43210-317 Employee Training$1,400.00$572.84$0.00$827.1640.92% E602-43210-321 Telephone$2,100.00$883.98$202.60$1,216.0242.09% E 602-43210-322 Postage$550.00$200.00$0.00$350.0036.36% E602-43210-331 Travel Expenses$200.00$157.95$0.00$42.0578.98% E602-43210-334 Licenses & Permits$1,600.00$722.00$0.00$878.0045.13% E602-43210-361 Liability/Property Ins$900.00$1,002.76$1,002.76($102.76)111.42% E602-43210-381 Utilities-Electric & Gas$2,500.00$854.78$217.14$1,645.2234.19% E602-43210-385 Sewer Pumping & Maintenance$11,000.00$0.00$0.00$11,000.000.00% E602-43210-386 Operation & Maintenance$5,000.00$712.25$712.25$4,287.7514.25% E602-43210-404 Repair Machinery/Equipment$16,000.00$0.00$0.00$16,000.000.00% E602-43210-413 Equipment Rental$350.00$0.00$0.00$350.000.00% E602-43210-420 Depreciation Expense$52,200.00$0.00$0.00$52,200.000.00% E602-43210-438 Misc. Contractual$9,000.00$1,123.00$1,123.00$7,877.0012.48% E602-43210-530 Capital Impr Other Than Bldgs$79,612.00$45,830.00$24,252.00$33,782.0057.57% 225,062.00$73,756.91$34,187.74$151,305.0932.77% UPTOWN SEWER RevenueR 612-43210-34401 Sewer User Fees$19,500.00$2,033.41$948.46$17,466.5910.43% R612-43210-36210 Interest Income$92.00$0.00$0.00$92.000.00% 19,592.00$2,033.41$948.46$17,558.5910.38% ExpenditureE 612-43210-101 Regular Wages & Salaries$9,300.00$3,625.78$696.46$5,674.2238.99% E612-43210-120 Pension Expense$0.00$0.00$0.00$0.000.00% E612-43210-121 PERA Coord. Employer Contribu.$700.00$271.60$52.24$428.4038.80% E612-43210-122 FICA Employer Contribution$600.00$210.81$40.85$389.1935.14% E612-43210-126 MEDICARE Employer Contribution$100.00$53.21$9.55$46.7953.21% E612-43210-151 Worker s Comp Insurance Prem$0.00$295.09$0.00($295.09)0.00% E612-43210-200 Office Supplies$100.00$0.00$0.00$100.000.00% E612-43210-210 Operating Supplies$200.00$0.00$0.00$200.000.00% E612-43210-221 Equipment Parts$200.00$0.00$0.00$200.000.00% E612-43210-303 Engineering Fees$300.00$0.00$0.00$300.000.00% E612-43210-308 Other Professional Services$400.00$162.00$0.00$238.0040.50% E612-43210-309 Software Support & Maintenance$0.00$0.00$0.00$0.000.00% E612-43210-317 Employee Training$350.00$0.00$0.00$350.000.00% E612-43210-334 Licenses & Permits$400.00$217.00$0.00$183.0054.25% E612-43210-353 Sales& Use Tax$0.00$0.00$0.00$0.000.00% E612-43210-361 Liability/Property Ins$300.00$334.25$334.25($34.25)111.42% E612-43210-381 Utilities-Electric & Gas$1,700.00$145.57$70.03$1,554.438.56% E612-43210-385 Sewer Pumping & Maintenance$1,200.00$0.00$0.00$1,200.000.00% E612-43210-386 Operation & Maintenance$600.00$0.00$0.00$600.000.00% E612-43210-404 Repair Machinery/Equipment$1,500.00$0.00$0.00$1,500.000.00% E612-43210-420 Depreciation Expense$55,100.00$0.00$0.00$55,100.000.00% E612-43210-438 Misc. Contractual$1,200.00$448.00$448.00$752.0037.33% E612-43210-530 Capital Impr Other Than Bldgs$2,600.00$0.00$0.00$2,600.000.00% 76,850.00$5,763.31$1,651.38$71,086.697.50%