Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
6.b Treasurer's Monthly Report 2023
City of Scandiaaug Treasurer’s Report 6/30/2023 FUND ACCOUNTING Beginning Cash Balance $ 3,317,624.626/1/2023 Beginning Checking Balance$ 52,352.23 Checking Receipts 75,099.53 Transfers toChecking 470,000.00 Total Deposits 545,099.53 Expenditures$ (449,001.86) Payroll$ (43,033.28) Transfer to EDA inTransit Total Payments 492,035.14) Ending Checking Balance 105,416.62 Beginnging Money Market Balance 1,184,332.08 Money Market Receipts 1,013.99 Tranfer to Checking 470,000.00) 0 Ending Money Market Balance 715,346.07 Beginning Investments Balance 2,055,711.07 Investments Receipts 8,568.97 Ending Investments Balance$ 2,064,280.04 Beginning EDA Balance$ 33,356.07 EDA Receipts EDA Expenditures EDA De;positin Transit EDA Transfers from Checking Ending EDA Balance$ 33,356.07 Outstanding Checks 27,756.26) 6/30/2023EndingCashBalance $ 2,890,642.54 CHECKING, MONEY MARKET & INVESTMENT CD's Checking *102$ 52,352.23BegBal Credits$ 545,099.53 Debits$ (492,035.14) Transfer inTransit 105,416.62EndBal Money Market *105 - Rate 1.25%$ 1,184,332.08BegBal rate change from .25% Credits 1,013.99 Debits 470,000.00) End Bal$ 715,346.07 Investments CD *4422 - Rate 4.00% 12mo., 3/25/2024 **NEW RATE$ 321,022.05 CD *4424 - Rate 2.50% 12 mo., 7/17/2023 $ 449,661.94 CD *4425 - Rate 2.875% 12 mo., 9/28/2023 $ 750,221.77 CD *4426 - Rate 3.50%% 12mo., 1/29/2024 543,374.28 Total Investments$ 2,064,280.04 Total Bank & Investment Accounts 2,885,042.73 27,756.26) Checks in Transit *3102 Transfer toEDA in Transit Deposit in transit money market 2,857,286.47TotalAdjustedUndesignatedFunds Scandia EDA *6301 $ 33,356.07 Receipts Expenditures Checks inTransit Deposit inTransit Total Designated EDA Funds$ 33,356.07 Total Funds$ 2,890,642.54 Submitted by: Colleen Firkus, Treasurer 2023CASHBALANCES ENDOFMONTH FUNDJANUARYFEBRUARYMARCHAPRILMAYJUNE 101 GENERAL$1,365,932$1,204,052$1,078,538$925,847$839,539 539,283.54 203 COVID-19 RELIEF$456,363$456,363$456,363$456,363456,362.62$ 456,362.62 226 CABLE TV$11,271$12,786$9,481$11,524$13,529 14,106.51 230 GATEWAY TRAIL$0$0$0$0$0$0 307 BLACKTOP PROJECT 2007$6,731$0$0$0$0$0 313 EQUIPMENT CERTIFICATES$28,825$28,873$28,873$28,873($32,057)$ (32,056.76) 315 EQUIPMENT CERTIFICATES$15,951$0$0$0$0$0 317 EQUIPMENT CERTIFICATES$2,187$0$0$0$0$0 318 BLACKTOP PROJECT$20,270$45,284$45,284($823)($823)$ (823.23) 401 CAPITAL IMPR$749,162$749,497$745,297$668,380$665,980$ 663,579.71 404 PARK CAP IMPR$148,177$148,797$148,797$144,297$144,297$ 145,898.33 406 EQUIPMENT REPLACEMENT$199,727$200,548$200,548$200,548$200,548$ 200,548.37 408 LOCAL ROAD IMPROVEMENT$916,080$910,085$901,556$895,518$893,593$ 744,491.50 602 BIG MARINE SEWER$80,462$74,771$75,858$58,322$49,682$ 60,689.30 612 UPTOWN SEWER$10,330$15,160$13,957$12,136$15,967$ 15,833.56 801 ESCROW$21,817$32,240$24,131$35,421$37,650$ 32,645.90 SUBTOTAL$4,033,286$3,878,456$3,728,684$3,436,405$3,284,269$2,840,559 225 EDA$33,356$33,356$33,356$33,356$33,356$ 33,356.07 TOTAL$4,066,642$3,911,812$3,762,040$3,469,761$3,317,625$2,873,915 CITY OF SCANDIA Revenue - Expenditure Summary Jun-23 Description2023 Budget2023 YTD AmountMay AmountBudget Balance% of BudgetComments GENERAL FUND RevenueR 101-41000-31000 Washington Cty. Tax Settlement$1,865,918$0.00$0.00$1,865,918.000.00% R101-41000-31040 Fiscal Disparities$0$0.00$0.00$0.000.00% R101-41000-31701 Gravel Taxes$20,000$0.00$0.00$20,000.000.00% R101-41000-31830 Solar Energy Production Tax$6,000$0.00$0.00$6,000.000.00% R101-41000-31900 Penalties & Interest Del Tax$400$0.00$0.00$400.000.00% R101-41000-32150 ROW Utility Permit$3,000$1,650.00$150.00$1,350.0055.00% R101-41000-32180 Tobacco & Liquor Licenses$10,000$75.00$0.00$9,925.000.75% R101-41000-32190 Other City Permits$3,000$1,170.00$200.00$1,830.0039.00% R101-41000-32210 Building Permits$145,000$84,118.36$28,528.86$60,881.6458.01% R101-41000-32260 Gambling Permits$100$30.00$15.00$70.0030.00% R101-41000-33401 LGA/MVHC/AG/PERA Aid$7,000$0.00$0.00$7,000.000.00% R101-41000-33420 Fire Relief State PERA$37,000$0.00$0.00$37,000.000.00% Fire Training grantsR101-41000-33422 Other State Grants & Aids$11,000$6,897.00$0.00$4,103.0062.70% R101-41000-33428 PILOT$6,000$0.00$0.00$6,000.000.00% R101-41000-33620 Recycling Grant$10,500$8,165.00$0.00$2,335.0077.76% R101-41000-33630 Local Govt Grants & Aids$0$0.00$0.00$0.000.00% R101-41000-33640 Other Grants$1,200$0.00$0.00$1,200.000.00% R101-41000-34103 Zoning and Planning$6,700$5,996.00$2,946.00$704.0089.49% R101-41000-34106 Engineering Fees$500$0.00$0.00$500.000.00% R101-41000-34107 Assessment Search Fees$0$5.00$0.00($5.00)0.00% R101-41000-34109 Water Usage$100$0.00$0.00$100.000.00% R101-41000-34201 Impound Fees$0$0.00$0.00$0.000.00% R101-41000-34202 Fire Protection Services$32,300$32,300.00$0.00$0.00100.00% R101-41000-34301 Damage Repairs$0$0.00$0.00$0.000.00% R101-41000-34303 Dust Control$2,700$3,524.46$3,524.46($824.46)130.54% R101-41000-34304 Reimbursement for Services$3,000$900.00$0.00$2,100.0030.00% R101-41000-34305 Other Street Services$0$0.00$0.00$0.000.00% R101-41000-34730 Ad Revenue$0$900.00$600.00($900.00)0.00% R101-41000-34750 Facilities Rental$5,500$3,349.67$762.00$2,150.3360.90% R101-41000-34760 Cleaning Fees$100$0.00$0.00$100.000.00% R101-41000-34790 Recreation Programs$2,100$1,488.33$0.00$611.6770.87% R101-41000-35101 Fines & Forfeitures$7,400$3,446.65$856.57$3,953.3546.58% distributed among funds atEOYR101-41000-36210 Interest Income$12,100$30,335.54$9,584.87($18,235.54)250.71% Veterans Memorial Upkeep $1,090; Lions: Vinterfest R101-41000-36230 Donations$2,000$4,191.30$0.00($2,191.30)209.57% Fireworks $2,000; Sister City $250 R101-41000-36240 Insurance Dividend$4,100$0.00$0.00$4,100.000.00% R101-41000-36250 Misc. Refund$3,800$0.00$0.00$3,800.000.00% Total General Fund Revenue$2,208,518$188,542.31$47,167.76$2,019,975.698.54% Operating TransfersR 101-49000-39203 Transfer from Other Funds$0$595,000.00$0.00($595,000.00)0.00% R101-49000-39204 Money Market Transfer$0$355,000.01$0.00($355,000.01)0.00% Total Operating Transfers$950,000.01$0.00($950,000.01) Description2023 Budget2023 YTD AmountMay AmountBudget Balance% of BudgetComments GENERAL FUNDADMINISTRATION & FINANCE ExpenditureE 101-41000-101 Regular Wages & Salaries$192,700$46,930.90$13,637.28$145,769.1024.35% audit journal entriesE101-41000-121 PERA Coord. Employer Contribu.$13,400$917.03$1,022.79$12,482.976.84% E101-41000-122 FICA Employer Contribution$11,900$2,138.09$814.45$9,761.9117.97% E101-41000-126 MEDICARE Employer Contribution$2,700$1,361.52$190.46$1,338.4850.43% E101-41000-131 Employer Paid Health$47,300$17,793.25$3,198.32$29,506.7537.62% E101-41000-132 Dental Insurance$3,400$602.95$127.90$2,797.0517.73% E101-41000-134 Employer Paid Life$600$262.70$49.60$337.3043.78% E101-41000-135 Employer Paid Disability$900$485.66$71.67$414.3453.96% E101-41000-151 Worker sComp Insurance Prem$1,300$1,651.00$0.00($351.00)127.00% E101-41000-200 Office Supplies$1,100$164.85$121.99$935.1514.99% E101-41000-203 Printed Forms & Papers$1,900$1,530.05$488.50$369.9580.53% Award frames; March 10 meeting suppliesE101-41000-210 Operating Supplies$800$478.50$49.99$321.5059.81% E101-41000-301 Auditing and Acct gServices$23,500$28,500.00$11,500.00($5,000.00)121.28% E101-41000-303 Engineering Fees$0$0.00$0.00$0.000.00% E101-41000-304 Legal Services$55,000$27,665.50$5,463.50$27,334.5050.30% E101-41000-306 Personal Testing & Recruit$0$0.00$0.00$0.000.00% Intermin City Admin SalaryE101-41000-308 Other Professional Services$1,000$50,299.19$0.00($49,299.19)5029.92% E101-41000-309 Software Support & Maintenance$18,200$5,156.03$779.38$13,043.9728.33% E101-41000-316 Conferences & Seminars$700$0.00$0.00$700.000.00% E101-41000-317 Employee Training$200$0.00$0.00$200.000.00% E101-41000-319 Other Services$46,700$586.00$35.00$46,114.001.25% E101-41000-321 Telephone$3,700$2,439.30$371.92$1,260.7065.93% E101-41000-322 Postage$2,200$1,103.33$90.54$1,096.6750.15% E101-41000-331 Travel Expenses$600$1,033.37$0.00($433.37)172.23%reimburse city admin applicant E101-41000-351 Legal Notices Publishing$1,200$1,018.56$0.00$181.4484.88% E101-41000-361 Liability/Property Ins$7,100$10,967.38$0.00($3,867.38)154.47% E101-41000-365 Insurance Claims$0$1,000.00$0.00($1,000.00)0.00% budget for alldepts inFund 101E101-41000-381 Utilities-Electric & Gas$13,000$4,760.30$2,638.74$8,239.7036.62% E101-41000-413 Equipment Rental$1,900$761.84$77.15$1,138.1640.10% E101-41000-430 Recycling$30,100$0.00$0.00$30,100.000.00% E101-41000-433 Dues and Subscriptions$6,100$157.00$0.00$5,943.002.57% E101-41000-434 Youth Service Bureau$5,500$5,500.00$0.00$0.00100.00% E101-41000-435 Misc Expense$500$0.00$0.00$500.000.00% Website Host; ABDO accounting assistanceE101-41000-438 Misc. Contractual$4,000$3,235.75$0.00$764.2580.89% E101-41000-439 Refunds Issued$0$0.00$0.00$0.000.00% E101-41000-560 Furniture and Fixtures$0$0.00$0.00$0.000.00% E101-41000-570 Office Equipment$5,500$1,585.52$1,585.52$3,914.4828.83% Total Admin & Finance Dept. Expenditures43.61% 504,700$220,085.57$42,314.70$284,614.43 Description2023 Budget2023 YTD AmountMay AmountBudget Balance% of BudgetComments GENERAL FUND CONT.CITY COUNCIL ExpendituresE 101-41110-101 Regular Wages & Salaries$18,100$5,192.98$0.00$12,907.0228.69% E101-41110-122 FICA Employer Contribution$1,100$114.67$0.00$985.3310.42% E101-41110-126 MEDICARE Employer Contribution$300$23.23$0.00$276.777.74% E101-41110-127 PERA Defined$600$167.15$0.00$432.8527.86% E101-41110-151 Worker sComp Insurance Prem$100$95.00$0.00$5.0095.00% E101-41110-308 Other Professional Services$0$0.00$0.00$0.000.00% E101-41110-316 Conferences & Seminars$700$350.00$0.00$350.0050.00% E101-41110-331 Travel Expenses$0$561.97$0.00($561.97)0.00% E101-41110-439 Refunds Issued$0$0.00$0.00$0.000.00% E101-41110-560 Furniture and Fixtures$0$0.00$0.00$0.000.00% E101-41110-570 Office Equipment$0$0.00$0.00$0.000.00% Total City Council Dept. Expenditures$20,900$6,505.00$0.00$14,395.0031.12% ELECTIONS ExpendituresE 101-41410-199 Election Judge$0$0.00$0.00$0.000.00% E101-41410-200 Office Supplies$0$0.00$0.00$0.000.00% E101-41410-203 Printed Forms & Papers$0$0.00$0.00$0.000.00% E101-41410-210 Operating Supplies$200$0.00$0.00$200.000.00% E101-41410-351 Legal Notices Publishing$0$0.00$0.00$0.000.00% E101-41410-413 Equipment Rental$850$1,515.00$0.00($665.00)178.24%Wash. Cty. Equip. Maintenance Fee Total Elections Dept. Expenditures$1,050$1,515.00$0.00($465.00)144.29% PLANNING & BUILDING ExpendituresE 101-41910-101 Regular Wages & Salaries$59,600$28,112.73$4,258.26$31,487.2747.17% E101-41910-121 PERA Coord. Employer Contribu.$4,200$1,474.31$319.38$2,725.6935.10% E101-41910-122 FICA Employer Contribution$3,700$1,659.81$250.70$2,040.1944.86% E101-41910-126 MEDICARE Employer Contribution$900$410.61$58.64$489.3945.62% E101-41910-131 Employer Paid Health$20,000$7,795.31$1,367.18$12,204.6938.98% E101-41910-132 Dental Insurance$1,500$310.59$54.81$1,189.4120.71% E101-41910-134 Employer Paid Life$200$73.60$14.40$126.4036.80% E101-41910-135 Employer Paid Disability$500$198.84$34.63$301.1639.77% E101-41910-203 Printed Forms & Papers$600$0.00$0.00$600.000.00% E101-41910-311 Contract Permit Inspections$50,000$31,061.97$11,631.31$18,938.0362.12% E101-41910-312 Planning Services$50,000$31,263.41$7,303.50$18,736.5962.53% E101-41910-313 Committee & Commission Reimbur$5,000$1,850.00$1,300.00$3,150.0037.00% E101-41910-316 Conferences & Seminars$50$0.00$0.00$50.000.00% E101-41910-319 Other Services$0$123.00$0.00($123.00)0.00% E101-41910-361 Liability/Property Ins$4,900$5,400.60$0.00($500.60)110.22% E101-41910-438 Misc. Contractual$5,000$1,188.43$0.00$3,811.5723.77% E101-41910-439 Refunds Issued$200$0.00$0.00$200.000.00% E101-41910-720 Operating Transfers$0$0.00$0.00$0.000.00% Total Planning & Building Dept. Expenditures$206,350$110,923.21$26,592.81$95,426.7953.75% ASSESSOR ExpendituresE 101-41960-300 Assessor$21,600$11,158.52$2,158.52$10,441.4851.66% POLICE ExpendituresE 101-42100-318 Police Contract$168,499$0.00$0.00$168,499.000.00% E101-42100-319 Other Services$500$309.36$0.00$190.6461.87%2023 Code Red System Total GF Police Dept. Expenditures$168,999$309.36$0.00$168,689.6433.33% Description2023 Budget2023 YTD AmountMay AmountBudget Balance% of BudgetComments GENERAL FUND CONT.FIRE ExpendituresE 101-42200-101 Regular Wages & Salaries$147,200$65,155.91$15,807.81$82,044.0944.26% E101-42200-121 PERA Coord. Employer Contribu.$0$0.00$0.00$0.000.00% E101-42200-122 FICA Employer Contribution$9,100$3,809.42$923.44$5,290.5841.86% E101-42200-124 Police & Fire PERA$3,600$4,394.89$768.06($794.89)122.08% E101-42200-126 MEDICARE Employer Contribution$2,100$712.17$232.12$1,387.8333.91% E101-42200-134 Employer Paid Life$200$96.00$16.00$104.0048.00% E101-42200-135 Employer Paid Disability$700$0.00$0.00$700.000.00% E101-42200-141 Unemployment Compensation$0$0.00$0.00$0.000.00% E101-42200-151 Worker sComp Insurance Prem$9,100$11,617.00$0.00($2,517.00)127.66% E101-42200-200 Office Supplies$400$23.79$23.79$376.215.95% E101-42200-203 Printed Forms & Papers$150$0.00$0.00$150.000.00% E101-42200-209 Medical Supplies$3,000$2,671.84$1,711.92$328.1689.06% Pagers $2,730; FireSuppression supplies $686; Cintas; E101-42200-210 Operating Supplies$8,000$3,940.90$474.27$4,059.1049.26%Dinners E101-42200-211 Cleaning Supplies$100$0.00$0.00$100.000.00% E101-42200-212 Fuel$3,500$1,692.39$367.24$1,807.6148.35% E101-42200-217 Uniforms & Safety Equipment$10,000$3,107.16$2,034.03$6,892.8431.07% E101-42200-221 Equipment Parts$3,000$271.56$45.12$2,728.449.05% E101-42200-222 Tires$0$0.00$0.00$0.000.00% E101-42200-223 Structure Repair & Supplies$2,000$368.85$31.92$1,631.1518.44% E101-42200-240 Small Tools and Minor Equip$9,000$673.61$635.61$8,326.397.48% SCBA User Exams + Annual Fit TestE101-42200-305 Medical Services$3,500$4,610.00$0.00($1,110.00)131.71% E101-42200-306 Personal Testing & Recruit$1,300$1,391.30$1,391.30($91.30)107.02% E101-42200-309 Software Support & Maintenance$17,000$5,560.56$528.00$11,439.4432.71% E101-42200-310 Medical Training$2,000$0.00$0.00$2,000.000.00% E101-42200-316 Conferences & Seminars$250$0.00$0.00$250.000.00% E101-42200-317 Employee Training$15,000$2,446.76$83.26$12,553.2416.31% E101-42200-319 Other Services$500$0.00$0.00$500.000.00% E101-42200-321 Telephone$6,800$2,568.81$223.67$4,231.1937.78% E101-42200-322 Postage$0$0.00$0.00$0.000.00% E101-42200-324 State ofMN-Fire Relief$35,300$0.00$0.00$35,300.000.00% E101-42200-325 City Match-Fire Relief$0$0.00$0.00$0.000.00% E101-42200-331 Travel Expenses$1,500$1,693.39$346.46($193.39)112.89% E101-42200-334 Licenses & Permits$200$300.00$0.00($100.00)150.00% MN Board of Firefighter Training & Education License E101-42200-340 Advertising$0$0.00$0.00$0.000.00% E101-42200-361 Liability/Property Ins$6,500$6,989.37$0.00($489.37)107.53% E101-42200-381 Utilities-Electric & Gas$8,000$5,078.02$141.57$2,921.9863.48% E101-42200-384 Refuse/Garbage Disposal$1,100$471.94$97.94$628.0642.90% E101-42200-385 Sewer Pumping & Maintenance$700$0.00$0.00$700.000.00% E101-42200-401 Building Maintenance/Repairs$2,500$1,740.81$260.75$759.1969.63%Cleaning, Pest Control, Glass door repair E101-42200-403 Improvements Other Than Bldgs$0$0.00$0.00$0.000.00% E101-42200-404 Repair Machinery/Equipment$8,000$4,127.02$79.43$3,872.9851.59% E101-42200-407 Well Repair & Maintenance$0$0.00$0.00$0.000.00% E101-42200-433 Dues and Subscriptions$2,400$3,214.90$1,740.90($814.90)133.95%Truck inspection renewal $1,685 E101-42200-438 Misc. Contractual$4,100$0.00$0.00$4,100.000.00% E101-42200-440 Events$800$0.00$0.00$800.000.00% E101-42200-520 Capital Improvements toBldgs$0$0.00$0.00$0.000.00% E101-42200-530 Capital Impr Other Than Bldgs$0$0.00$0.00$0.000.00% E101-42200-540 Heavy Machinery Capital$0$0.00$0.00$0.000.00% E101-42200-560 Furniture and Fixtures$500$235.90$235.90$264.1047.18% E101-42200-570 Office Equipment$900$179.98$179.98$720.0220.00% E101-42200-720 Operating Transfers$0$0.00$0.00$0.000.00% Total Fire Dept Expenditures$330,000$139,144.25$28,380.49$190,855.7542.16% ANIMAL CONTROL ExpendituresE 101-42700-314 Animal Control$5,000$2,492.66$842.41$2,507.3449.85% Description2023 Budget2023 YTD AmountMay AmountBudget Balance% of BudgetComments GENERAL FUND CONT.PUBLIC WORKS ExpendituresE 101-43000-101 Regular Wages & Salaries$229,700$103,904.93$17,672.33$125,795.0745.24% E101-43000-102 OT Regular Wages$5,000$4,610.96$0.00$389.0492.22% snow plowingE101-43000-104 Temporary Employee Wages$2,300$4,162.73$0.00($1,862.73)180.99% E101-43000-121 PERA Coord. Employer Contribu.$17,600$8,124.04$1,325.39$9,475.9646.16% E101-43000-122 FICA Employer Contribution$14,600$6,389.70$1,049.39$8,210.3043.77% E101-43000-126 MEDICARE Employer Contribution$3,400$1,692.22$245.43$1,707.7849.77% E101-43000-131 Employer Paid Health$70,900$33,367.28$3,849.23$37,532.7247.06% E101-43000-132 Dental Insurance$2,300$617.06$88.15$1,682.9426.83% E101-43000-134 Employer Paid Life$700$368.08$62.16$331.9252.58% E101-43000-135 Employer Paid Disability$1,700$987.68$101.78$712.3258.10% E101-43000-141 Unemployment Compensation$0$0.00$0.00$0.000.00% E101-43000-151 Worker sComp Insurance Prem$19,800$25,673.00$0.00($5,873.00)129.66% E101-43000-200 Office Supplies$600$53.99$0.00$546.019.00% E101-43000-210 Operating Supplies$8,400$3,520.18$1,445.82$4,879.8241.91% E101-43000-212 Fuel$20,000$14,992.02$2,667.88$5,007.9874.96% E101-43000-217 Uniforms & Safety Equipment$2,200$811.41$301.79$1,388.5936.88% plow repair partsE101-43000-221 Equipment Parts$14,000$11,352.53$859.44$2,647.4781.09% E101-43000-222 Tires$7,500$0.00$0.00$7,500.000.00% E101-43000-223 Structure Repair & Supplies$2,200$0.00$0.00$2,200.000.00% E101-43000-224 Materials for Road Maintenance$16,500$2,662.72$642.31$13,837.2816.14% E101-43000-226 Sign Replacement and Repair$0$173.83$0.00($173.83)0.00% E101-43000-228 Gravel$10,000$6,862.87$6,862.87$3,137.1368.63% snow, snow & snowE101-43000-229 Salt$20,000$18,093.42$0.00$1,906.5890.47% E101-43000-240 Small Tools and Minor Equip$8,000$3,770.62$0.00$4,229.3847.13% E101-43000-302 Surveying$0$0.00$0.00$0.000.00% E101-43000-303 Engineering Fees$10,000$7,880.50$4,050.00$2,119.5078.81%Gen. Eng. & Crack filling & seal coat fees E101-43000-304 Legal Services$0$0.00$0.00$0.000.00% E101-43000-305 Medical Services$1,200$99.90$0.00$1,100.108.33% IWORQ subscription; GIS map updatesE101-43000-309 Software Support & Maintenance$2,000$7,784.00$1,230.00($5,784.00)389.20% E101-43000-317 Employee Training$1,700$1,010.00$0.00$690.0059.41% E101-43000-319 Other Services$13,600$3,910.30$3,823.85$9,689.7028.75% E101-43000-321 Telephone$3,000$1,983.32$351.20$1,016.6866.11% E101-43000-331 Travel Expenses$500$0.00$0.00$500.000.00% E101-43000-334 Licenses & Permits$500$0.00$0.00$500.000.00% E101-43000-361 Liability/Property Ins$9,000$8,348.14$0.00$651.8692.76% E101-43000-365 Insurance Claims$0$0.00$0.00$0.000.00% E101-43000-381 Utilities-Electric & Gas$4,000$3,550.83$119.49$449.1788.77% E101-43000-384 Refuse/Garbage Disposal$1,000$374.66$65.29$625.3437.47% E101-43000-385 Sewer Pumping & Maintenance$1,600$0.00$0.00$1,600.000.00% E101-43000-387 Street Light Utilities$4,200$2,328.03$335.90$1,871.9755.43% E101-43000-401 Building Maintenance/Repairs$8,000$1,737.83$509.26$6,262.1721.72% E101-43000-403 Improvements Other Than Bldgs$0$0.00$0.00$0.000.00% plow truck repairsE101-43000-404 Repair Machinery/Equipment$15,500$15,643.22$4,980.61($143.22)100.92% Street light repair $3,422; Crack Fill & Seal Coat E101-43000-405 Contractual Road Maint/Repair$157,500$186,664.45$183,241.92($29,164.45)118.52%$150,824; Patching $10,488, Dust Control $21,900 E101-43000-407 Well Repair & Maintenance$0$0.00$0.00$0.000.00% E101-43000-413 Equipment Rental$4,000$0.00$0.00$4,000.000.00% E101-43000-417 Uniform Rental$1,100$429.48$103.25$670.5239.04% E101-43000-433 Dues and Subscriptions$200$0.00$0.00$200.000.00% E101-43000-438 Misc. Contractual$15,750$1,800.00$0.00$13,950.0011.43% E101-43000-439 Refunds Issued$0$0.00$0.00$0.000.00% E101-43000-530 Capital Impr Other Than Bldgs$0$0.00$0.00$0.000.00% E101-43000-550 Motor Vehicles Capital$0$0.00$0.00$0.000.00% E101-43000-560 Furniture and Fixtures$0$0.00$0.00$0.000.00% E101-43000-570 Office Equipment$1,000$406.53$0.00$593.4740.65% E101-43000-720 Operating Transfers$0$0.00$0.00$0.000.00% Total Public Works Dept. Expenditures$732,750$496,142.46$235,984.74$236,607.5467.71% Description2023 Budget2023 YTD AmountMay AmountBudget Balance% of BudgetComments GENERAL FUND CONT.PARKS & RECREATION ExpendituresE 101-45000-101 Regular Wages & Salaries$10,200$3,352.88$757.48$6,847.1232.87% E101-45000-104 Temporary Employee Wages$40,200$9,209.51$3,033.13$30,990.4922.91% E101-45000-121 PERA Coord. Employer Contribu.$800$249.05$56.80$550.9531.13% E101-45000-122 FICA Employer Contribution$3,300$743.94$233.04$2,556.0622.54% E101-45000-126 MEDICARE Employer Contribution$800$201.39$54.49$598.6125.17% E101-45000-131 Employer Paid Health$2,700$1,115.31$145.69$1,584.6941.31% E101-45000-132 Dental Insurance$100$22.40$3.20$77.6022.40% E101-45000-134 Employer Paid Life$0$13.72$2.24($13.72)0.00% E101-45000-135 Employer Paid Disability$1,000$32.31$3.96$967.693.23% E101-45000-141 Unemployment Compensation$0$0.00$0.00$0.000.00% E101-45000-151 Worker sComp Insurance Prem$1,900$2,311.00$0.00($411.00)121.63% E101-45000-200 Office Supplies$310$0.00$0.00$310.000.00% E101-45000-203 Printed Forms & Papers$930$0.00$0.00$930.000.00% E101-45000-210 Operating Supplies$930$512.95$412.58$417.0555.16% E101-45000-212 Fuel$1,650$229.92$0.00$1,420.0813.93% E101-45000-221 Equipment Parts$2,100$290.38$0.00$1,809.6213.83% E101-45000-223 Structure Repair & Supplies$2,100$0.00$0.00$2,100.000.00% E101-45000-240 Small Tools and Minor Equip$400$0.00$0.00$400.000.00% E101-45000-312 Planning Services$0$0.00$0.00$0.000.00% E101-45000-313 Committee & Commission Reimbur$1,200$540.00$300.00$660.0045.00% E101-45000-319 Other Services$0$284.00$0.00($284.00)0.00% E101-45000-322 Postage$0$0.00$0.00$0.000.00% SCVRTA 2023 AdE101-45000-340 Advertising$200$250.00$0.00($50.00)125.00% E101-45000-353 Sales& Use Tax$0$0.00$0.00$0.000.00% E101-45000-361 Liability/Property Ins$3,300$3,323.03$0.00($23.03)100.70% E101-45000-381 Utilities-Electric & Gas$4,500$2,688.26$372.65$1,811.7459.74% E101-45000-384 Refuse/Garbage Disposal$2,500$1,401.65$598.47$1,098.3556.07% E101-45000-385 Sewer Pumping & Maintenance$700$564.73$0.00$135.2780.68%Warming House ice melt productE101-45000-401 Building Maintenance/Repairs$4,800$3,312.91$120.00$1,487.0969.02% E101-45000-403 Improvements Other Than Bldgs$0$170.49$0.00($170.49)0.00% E101-45000-404 Repair Machinery/Equipment$750$0.00$0.00$750.000.00% E101-45000-406 Grounds Care$4,000$488.88$0.00$3,511.1212.22% E101-45000-438 Misc. Contractual$3,300$1,440.00$1,440.00$1,860.0043.64% E101-45000-439 Refunds Issued$0$565.01$0.00($565.01)0.00% VinterfestE101-45000-440 Events$7,000$2,393.99$0.00$4,606.0134.20% E101-45000-490 Financial Assistance$0$0.00$0.00$0.000.00% E101-45000-530 Capital Impr Other Than Bldgs$10,000$0.00$0.00$10,000.000.00% E101-45000-720 Operating Transfers$0$0.00$0.00$0.000.00% Total Parks & Rec Dept. Expenditures$111,670$35,707.71$7,533.73$75,962.2931.98% Description2023 Budget2023 YTD AmountMay AmountBudget Balance% of BudgetComments GENERAL FUND CONT.COMMUNITY CENTER ExpendituresE 101-45180-101 Regular Wages & Salaries$15,000$6,739.61$1,223.25$8,260.3944.93% E101-45180-104 Temporary Employee Wages$0$0.00$0.00$0.000.00% E101-45180-121 PERA Coord. Employer Contribu.$1,100$495.56$82.73$604.4445.05% E101-45180-122 FICA Employer Contribution$900$389.69$73.27$510.3143.30% E101-45180-126 MEDICARE Employer Contribution$200$100.61$17.15$99.3950.31% E101-45180-131 Employer Paid Health$3,700$1,434.90$170.40$2,265.1038.78% E101-45180-134 Employer Paid Life$0$22.20$3.60($22.20)0.00% E101-45180-135 Employer Paid Disability$200$64.51$7.36$135.4932.26% E101-45180-151 Worker sComp Insurance Prem$0$0.00$0.00$0.000.00% E101-45180-210 Operating Supplies$2,900$995.35$205.38$1,904.6534.32% E101-45180-223 Structure Repair & Supplies$6,500$74.31$74.31$6,425.691.14% E101-45180-334 Licenses & Permits$1,000$792.00$0.00$208.0079.20% E101-45180-361 Liability/Property Ins$800$795.60$0.00$4.4099.45% E101-45180-381 Utilities-Electric & Gas$11,200$5,852.10$616.50$5,347.9052.25% E101-45180-384 Refuse/Garbage Disposal$1,900$1,066.55$179.86$833.4556.13% E101-45180-385 Sewer Pumping & Maintenance$3,700$1,827.71$0.00$1,872.2949.40% Remove ice from Comm Ctr roofE101-45180-401 Building Maintenance/Repairs$15,000$9,632.09$650.33$5,367.9164.21% E101-45180-404 Repair Machinery/Equipment$5,000$298.00$0.00$4,702.005.96% E101-45180-406 Grounds Care$690$0.00$0.00$690.000.00% E101-45180-407 Well Repair & Maintenance$1,000$0.00$0.00$1,000.000.00% Helke'swinter lighting workE101-45180-438 Misc. Contractual$2,700$1,500.00$0.00$1,200.0055.56% E101-45180-439 Refunds Issued$0$450.00$0.00($450.00)0.00% Council Chambers remodelE101-45180-520 Capital Improvements toBldgs$6,000$7,475.61$0.00($1,475.61)124.59% E101-45180-530 Capital Impr Other Than Bldgs$0$0.00$0.00$0.000.00% E101-45180-570 Office Equipment$0$0.00$0.00$0.000.00% E101-45180-720 Operating Transfers$0$0.00$0.00$0.000.00% Total Community Center Dept. Expenditures$79,490$40,006.40$3,304.14$39,483.6050.33% Operating TransfersE 101-49000-720 Operating Transfers$950,050.01$0.00($950,050.01) TOTAL GENERAL FUND EXPENDITURES$2,182,509$1,063,990$347,112$1,118,51948.75% Description2023 Budget2023 YTD AmountMay AmountBudget Balance% of BudgetComments COVID RELIEF FUND RevenueR 203-46200-33150 Federal Grant$0$0.00$0.00$0.000.00% ExpendituresE 203-49000-720 Operating Transfers$0.00$0.00$0.00$0.00 EDA FUND RevenueR 225-46500-31000 Washington Cty. Tax Settlement$5,300$0.00$0.00$5,300.000.00% R225-46500-33640 Other Grants$0$0.00$0.00$0.000.00% R225-46500-34750 Facilities Rental$0$0.00$0.00$0.000.00% R225-46500-36210 Interest Income$200$0.00$0.00$200.000.00% R225-46500-36230 Donations$0$0.00$0.00$0.000.00% R225-46500-39203 Transfer from Other Funds$0$3,524.94$0.00($3,524.94)0.00% transfer ofproperty taxsettlement from checking Total EDA Fund Revenue$5,500.00$3,524.94$0.00$1,975.0664.09% ExpenditureE 225-46500-210 Operating Supplies$500$3,524.94$0.00($3,024.94)704.99% transfer ofproperty taxsettlement from checking E225-46500-303 Engineering Fees$0$0.00$0.00$0.000.00% E225-46500-304 Legal Services$0$0.00$0.00$0.000.00% E225-46500-308 Other Professional Services$300$0.00$0.00$300.000.00% E225-46500-340 Advertising$2,000$645.00$645.00$1,355.0032.25% EDAM Membership; Sister City DuesE225-46500-433 Dues and Subscriptions$1,700$1,168.00$363.00$532.0068.71% E225-46500-440 Events$800$580.00$0.00$220.0072.50% E225-46500-720 Operating Transfers$0$0.00$0.00$0.000.00% Total EDA Fund Expenditures$5,300.00$2,393.00$1,008.00($617.94)45.15% CABLE TVFUND RevenueR 226-41950-36210 Interest Income$100$0.00$0.00$100.000.00% R226-41950-36260 Sale ofEquipment$0$300.00$0.00($300.00)0.00% R226-41950-38050 Cable TV Franchise Rebates$16,200$8,366.44$1,729.31$7,833.5651.64% R226-41950-38051 PEG Fees$4,200$2,242.03$458.29$1,957.9753.38% Total Cable TV Fund Revenue$20,500.00$10,908.47$2,187.60$9,591.5353.21% Council Chambers AV equipmentExpenditureE226-41950-240 Small Tools and Minor Equip$300$593.48$0.00($293.48)197.83% E226-41950-309 Software Support & Maintenance$3,500$467.85$0.00$3,032.1513.37% E226-41950-438 Misc. Contractual$5,300$2,990.00$1,610.00$2,310.0056.42% E226-41950-570 Office Equipment$0$4,128.98$0.00($4,128.98)0.00% Total Cable TV Fund Expenditures$9,100.00$8,180.31$1,610.00$919.6989.89% GATEWAY TRAIL FUND RevenueR 230-45000-36230 Donations$0$0.00$0.00$0.000.00% ExpenditureE 230-45000-308 Other Professional Services$0$0.00$0.00$0.000.00% 2013 EQUIPMENT CERTIFICATES RevenueR 313-47000-31000 Washington Cty. Tax Settlement$64,000$0.00$0.00$64,000.000.00% ExpenditureE 313-47000-601 Long Term Debt Principal$60,000$60,000.00$0.00$0.00100.00% E313-47000-611 Long Term Debt Interest$3,047$930.00$0.00$2,117.0030.52% E313-47000-620 Fiscal Agent sFees$500$0.00$0.00$500.000.00% Total 2013 Fund Expenditures$63,547.00$60,930.00$0.00$2,617.0095.88% 2018 STREET RECONSTRUCTION RevenueR 318-47000-31000 Washington Cty. Tax Settlement$342,546$0.00$0.00$342,546.000.00% ExpenditureE 318-47000-601 Long Term Debt Principal$250,000$0.00$0.00$250,000.000.00% E318-47000-611 Long Term Debt Interest$91,225$45,612.51$0.00$45,612.4950.00% E318-47000-620 Fiscal Agent sFees$500$495.00$0.00$5.0099.00% Total 2018 Street Reconstruction Fund Expenditures$341,725.00$46,107.51$0.00$295,617.4913.49% Description2023 Budget2023 YTD AmountMay AmountBudget Balance% of BudgetComments CAPITAL IMPROVEMENTS RevenueR 401-48000-31000 Washington Cty. Tax Settlement$293,791$0.00$0.00$293,791.000.00% R401-48000-33422 Other State Grants & Aids$0$0.00$0.00$0.000.00% R401-48000-36210 Interest Income$2,300$0.00$0.00$2,300.000.00% Total Capital Improvement Fund Revenue$0.00$0.00$296,091.00$0.000.00% ExpenditureE 401-41000-312 Planning Services$0$0.00$0.00$0.000.00% E401-41000-520 Capital Improvements toBldgs$0$0.00$0.00$0.000.00% E401-41000-530 Capital Impr Other Than Bldgs$169,500$0.00$0.00$169,500.000.00% E401-42200-520 Capital Improvements toBldgs$65,000$73,775.00$0.00($8,775.00)113.50%Generator E 401-48000-303 Engineering Fees0$2,542.50$0.00($2,542.50)0.00%Gateway Trail Engineering E101-48000-308 Other Professional Services$0$14,400.00$2,400.00($14,400.00)0.00%Gateway Trail Lobbying E401-48000-435 Misc Expense$0$0.00$0.00$0.000.00% E401-48000-438 Misc. Contractual$0$0.00$0.00$0.000.00% E401-48000-520 Capital Improvements toBldgs$0$0.00$0.00$0.000.00% E401-48000-530 Capital Impr Other Than Bldgs$100,000$0.00$0.00$100,000.000.00% Total Capital Improvement Fund Expenditures$334,500.00$90,717.50$2,400.00$243,782.5027.12% PARK DEVELOPMENT RevenueR 404-48000-31000 Washington Cty. Tax Settlement$20,000$0.00$0.00$20,000.000.00% R404-48000-33422 Other State Grants & Aids$0$0.00$0.00$0.000.00% R404-48000-34780 Park Dedication Fees$21,000$0.00$0.00$21,000.000.00% R404-48000-36210 Interest Income$66$0.00$0.00$66.000.00% Lions Playground donation; Bench donationR404-48000-36230 Donations$0$11,601.15$1,601.15($11,601.15)0.00% Total Park Development Fund Revenue$41,066.00$11,601.15$1,601.15$29,464.8528.25% ExpenditureE 404-48000-312 Planning Services$0$4,500.00$0.00($4,500.00)0.00% E404-48000-520 Capital Improvements toBldgs$17,306$0.00$0.00$17,306.000.00% E404-48000-720 Operating Transfers$0$0.00$0.00$0.000.00% Total Park Development Fund Expenditures$17,306.00$4,500.00$0.00$12,806.0026.00% EQUIPMENT REPLACEMENT RevenueR 406-48500-31000 Washington Cty. Tax Settlement$0$0.00$0.00$0.000.00% R406-48500-36210 Interest Income$1,030$0.00$0.00$1,030.000.00% R406-48500-36260 Sale ofEquipment$35,000$0.00$0.00$35,000.000.00% R406-48500-39350 Certificate ofIndebtedness$819,500$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$0.00$0.00$325,000.000.00% E406-48500-550 Motor Vehicles Capital$189,500$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$0.00$0.00$212,012.000.00% R408-43100-33422 Other State Grants & Aids$0$0.00$0.00$0.000.00% R408-43100-36210 Interest Income$12,115$0.00$0.00$12,115.000.00% R408-43100-39310 Proceeds-Gen Obligation Bond$0$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$20,874.50$4,393.00($874.50)104.37% E408-43100-530 Capital Impr Other Than Bldgs$973,000$144,968.99$144,708.91$828,031.0114.90% Total LRIF Expenditures$973,000.00$144,968.99$144,708.91$828,031.0114.90% Description2023 Budget2023 YTD AmountMay AmountBudget Balance% of BudgetComments BIG MARINE SEWER RevenueR 602-43210-31951 Special Assessments Principal$0$0.00$0.00$0.000.00% R602-43210-31952 SA Penalties & Interest$0$10.00$0.00($10.00)0.00% R602-43210-33422 Other State Grants & Aids$0$0.00$0.00$0.000.00% R602-43210-34401 Sewer User Fees$140,700$50,109.16$17,648.76$90,590.8435.61% R602-43210-34402 Sewer Connection Fee$0$8,000.00$0.00($8,000.00)0.00% R602-43210-36100 Special Assessments$600$0.00$0.00$600.000.00% R602-43210-36102 Penalties and Interest$0$29.96$0.00($29.96)0.00% R602-43210-36210 Interest Income$400$0.00$0.00$400.000.00% Total Big Marine Sewer Revenue$141,700.00$58,149.12$17,648.76$83,550.8841.04% ExpenditureE 602-43210-101 Regular Wages & Salaries$22,500$10,101.43$1,723.62$12,398.5744.90% E602-43210-102 OT Regular Wages$0$0.00$0.00$0.000.00% E602-43210-120 Pension Expense$0$0.00$0.00$0.000.00% E602-43210-121 PERA Coord. Employer Contribu.$17,000$756.42$129.28$16,243.584.45% E602-43210-122 FICA Employer Contribution$1,400$583.30$102.19$816.7041.66% E602-43210-126 MEDICARE Employer Contribution$300$150.92$23.91$149.0850.31% E602-43210-131 Employer Paid Health$0$0.00$0.00$0.000.00% E602-43210-151 Worker sComp Insurance Prem$700$736.40$0.00($36.40)105.20% E602-43210-200 Office Supplies$200$0.00$0.00$200.000.00% E602-43210-210 Operating Supplies$2,500$50.14$30.78$2,449.862.01% E602-43210-240 Small Tools and Minor Equip$600$0.00$0.00$600.000.00% Bliss Collector Permit RenewalE602-43210-303 Engineering Fees$10,500$37,522.00$822.50($27,022.00)357.35% E602-43210-304 Legal Services$0$18.00$0.00($18.00)0.00% E602-43210-308 Other Professional Services$2,500$2,095.00$0.00$405.0083.80%Pace Analytical monthly testing E602-43210-309 Software Support & Maintenance$1,300$0.00$0.00$1,300.000.00% E602-43210-317 Employee Training$1,400$0.00$0.00$1,400.000.00% E602-43210-321 Telephone$2,400$1,407.99$115.56$992.0158.67% E602-43210-322 Postage$600$0.00$0.00$600.000.00% E602-43210-331 Travel Expenses$200$632.55$632.55($432.55)316.28% E602-43210-334 Licenses & Permits$1,600$729.00$0.00$871.0045.56% E602-43210-361 Liability/Property Ins$3,000$3,449.06$0.00($449.06)114.97% E602-43210-381 Utilities-Electric & Gas$2,500$2,591.27$408.43($91.27)103.65%Connexus & Excel E602-43210-385 Sewer Pumping & Maintenance$15,000$0.00$0.00$15,000.000.00% E602-43210-386 Operation & Maintenance$5,000$2,139.00$0.00$2,861.0042.78% E602-43210-404 Repair Machinery/Equipment$16,000$12,100.90$2,672.60$3,899.1075.63%Lift Station #2pump replacement E602-43210-413 Equipment Rental$400$0.00$0.00$400.000.00% E602-43210-420 Depreciation Expense$54,300$0.00$0.00$54,300.000.00% E602-43210-438 Misc. Contractual$10,000$0.00$0.00$10,000.000.00% E602-43210-439 Refunds Issued$0$0.00$0.00$0.000.00% E602-43210-530 Capital Impr Other Than Bldgs$9,800$0.00$0.00$9,800.000.00% Total Big Marine Sewer Expenditures$159,200.00$64,961.95$4,937.80$94,238.0540.81% UPTOWN SEWER RevenueR 612-43210-34401 Sewer User Fees$22,300$5,615.96$748.22$16,684.0425.18% R612-43210-36210 Interest Income$200$0.00$0.00$200.000.00% Total Uptown Sewer Revenue$22,500.00$5,615.96$748.22$16,884.0424.96% ExpenditureE 612-43210-101 Regular Wages & Salaries$9,700$4,311.48$718.58$5,388.5244.45% E612-43210-121 PERA Coord. Employer Contribu.$700$323.13$53.94$376.8746.16% E612-43210-122 FICA Employer Contribution$600$249.00$42.65$351.0041.50% E612-43210-126 MEDICARE Employer Contribution$100$64.29$9.95$35.7164.29% E612-43210-131 Employer Paid Health$0$0.00$0.00$0.000.00% E612-43210-151 Worker sComp Insurance Prem$200$315.60$0.00($115.60)157.80% E612-43210-200 Office Supplies$100$0.00$0.00$100.000.00% E612-43210-210 Operating Supplies$300$0.00$0.00$300.000.00% E612-43210-221 Equipment Parts$300$0.00$0.00$300.000.00% E612-43210-303 Engineering Fees$1,000$0.00$0.00$1,000.000.00% E612-43210-304 Legal Services$0$0.00$0.00$0.000.00% E612-43210-308 Other Professional Services$500$733.00$0.00($233.00)146.60%58% increase intesting costs E612-43210-309 Software Support & Maintenance$0$0.00$0.00$0.000.00% E612-43210-317 Employee Training$350$0.00$0.00$350.000.00% E612-43210-319 Other Services$0$0.00$0.00$0.000.00% E612-43210-322 Postage$0$0.00$0.00$0.000.00% E612-43210-334 Licenses & Permits$400$224.00$0.00$176.0056.00% E612-43210-361 Liability/Property Ins$400$477.82$0.00($77.82)119.46% E612-43210-381 Utilities-Electric & Gas$1,700$543.43$56.45$1,156.5731.97% E612-43210-385 Sewer Pumping & Maintenance$1,500$0.00$0.00$1,500.000.00% E612-43210-386 Operation & Maintenance$700$0.00$0.00$700.000.00% E612-43210-404 Repair Machinery/Equipment$2,000$0.00$0.00$2,000.000.00% E612-43210-420 Depreciation Expense$5,100$0.00$0.00$5,100.000.00% E612-43210-438 Misc. Contractual$1,300$0.00$0.00$1,300.000.00% E612-43210-530 Capital Impr Other Than Bldgs$4,500$0.00$0.00$4,500.000.00% Total Uptown Sewer Expenditures$21,050.00$2,607.14$109.05$18,442.8612.39%