Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
06.b May 2023 Treasurer's Report
City of Scandiaaug Treasurer’s Report 5/31/2023 FUND ACCOUNTING Beginning Cash Balance $ 3,761,990.305/1/2023 Beginning Checking Balance$ 130,745.83 Checking Receipts 65,753.65 Transfers toChecking 150,000.00 Total Deposits 215,753.65 Expenditures$ (255,309.71) Payroll$ (38,837.54) Transfer to EDA inTransit Total Payments 294,147.25) Ending Checking Balance 52,352.23 Beginnging Money Market Balance 1,332,999.10 Money Market Receipts 1,332.98 Tranfer to Checking 150,000.00) 0 Ending Money Market Balance 1,184,332.08 Beginning Investments Balance 2,055,711.07 Investments Receipts Ending Investments Balance$ 2,055,711.07 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 8,126.83) 5/31/2023EndingCashBalance $ 3,317,624.62 CHECKING, MONEY MARKET & INVESTMENT CD's Checking *102$ 130,745.83BegBal Credits$ 215,753.65 Debits$ (294,147.25) Transfer inTransit 52,352.23EndBal Money Market *105 - Rate 1.25%$ 1,332,999.10BegBal rate change from .25% Credits 1,332.98 Debits 150,000.00) End Bal$ 1,184,332.08 Investments CD *4422 - Rate 4.00% 12mo., 3/25/2024 **NEW RATE$ 317,850.51 CD *4424 - Rate 2.50% 12 mo., 7/17/2023 $ 449,661.94 CD *4425 - Rate 2.875% 12 mo., 9/28/2023 $ 744,824.34 CD *4426 - Rate 3.50%% 12mo., 1/29/2024 543,374.28 Total Investments$ 2,055,711.07 Total Bank & Investment Accounts 3,292,395.38 8,126.83) Checks in Transit *3102 Transfer toEDA in Transit Deposit in transit money market 3,284,268.55TotalAdjustedUndesignatedFunds Scandia EDA *6301 $ 33,356.07 Receipts Expenditures Checks inTransit Deposit inTransit Total Designated EDA Funds$ 33,356.07 Total Funds$ 3,317,624.62 Submitted by: Colleen Firkus, Treasurer 2023CASH BALANCES ENDOFMONTH FUNDJANUARYFEBRUARYMARCHAPRILMAY 101 GENERAL$1,365,932$1,204,052$1,078,538$925,847$839,539 203 COVID-19 RELIEF$456,363$456,363$456,363$456,363456,362.62 226 CABLE TV$11,271$12,786$9,481$11,524$13,529 230 GATEWAY TRAIL$0$0$0$0$0 307 BLACKTOP PROJECT 2007$6,731$0$0$0$0 313 EQUIPMENT CERTIFICATES$28,825$28,873$28,873$28,873($32,057) 315 EQUIPMENT CERTIFICATES$15,951$0$0$0$0 317 EQUIPMENT CERTIFICATES$2,187$0$0$0$0 318 BLACKTOP PROJECT$20,270$45,284$45,284($823)($823) 401 CAPITAL IMPR$749,162$749,497$745,297$668,380$665,980 404 PARK CAP IMPR$148,177$148,797$148,797$144,297$144,297 406 EQUIPMENT REPLACEMENT$199,727$200,548$200,548$200,548$200,548 408 LOCAL ROAD IMPROVEMENT$916,080$910,085$901,556$895,518$893,593 602 BIG MARINE SEWER$80,462$74,771$75,858$58,322$49,682 612 UPTOWN SEWER$10,330$15,160$13,957$12,136$15,967 801 ESCROW$21,817$32,240$24,131$35,421$37,650 SUBTOTAL$4,033,286$3,878,456$3,728,684$3,436,405$3,284,269 225 EDA$33,356$33,356$33,356$33,356$33,356 TOTAL$4,066,642$3,911,812$3,762,040$3,469,761$3,317,625 CITY OF SCANDIA Revenue - Expenditure Summary May-23 2023 YTD May Budget Description2023 BudgetAmountAmountBalance% 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,500.00$300.00$1,500.0050.00% R101-41000-32180 Tobacco & Liquor Licenses$10,000$75.00$25.00$9,925.000.75% R101-41000-32190 Other City Permits$3,000$970.00$375.00$2,030.0032.33% R101-41000-32210 Building Permits$145,000$55,589.50$15,141.66$89,410.5038.34% R101-41000-32260 Gambling Permits$100$15.00$0.00$85.0015.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$3,050.00$950.00$3,650.0045.52% 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$32,300.00$2,000.00100.00% R101-41000-34301 Damage Repairs$0$0.00$0.00$0.000.00% R101-41000-34303 Dust Control$2,700$0.00$0.00$2,700.000.00% 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$300.00$300.00($300.00)0.00% R101-41000-34750 Facilities Rental$5,500$2,587.67$550.00$2,912.3347.05% R101-41000-34760 Cleaning Fees$100$0.00$0.00$100.000.00% R101-41000-34790 Recreation Programs$2,100$1,488.33$503.33$611.6770.87% R101-41000-35101 Fines & Forfeitures$7,400$2,590.08$306.63$4,809.9235.00% distributed among funds atEOYR101-41000-36210 Interest Income$12,100$20,750.67$1,334.10($8,650.67)171.49% Veterans Memorial Upkeep $1,090; Lions: R101-41000-36230 Donations$2,000$4,191.30$0.00($2,191.30)209.57% Vinterfest 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$141,374.55$52,085.72$2,069,143.456.40% Operating TransfersR 101-49000-39203 Transfer from Other Funds$0$595,000.00$150,000.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$150,000.00($950,000.01) 2023 YTD May Budget Description2023 BudgetAmountAmountBalance% of BudgetComments GENERAL FUNDADMINISTRATION & FINANCE ExpenditureE 101-41000-101 Regular Wages & Salaries$192,700$33,293.62$13,457.05$159,406.3817.28% audit journal entriesE101-41000-121 PERA Coord. Employer Contribu.$13,400($105.76)$1,009.28$13,505.76-0.79% E101-41000-122 FICA Employer Contribution$11,900$1,323.64$803.29$10,576.3611.12% E101-41000-126 MEDICARE Employer Contribution$2,700$1,171.06$187.85$1,528.9443.37% E101-41000-131 Employer Paid Health$47,300$14,594.93$3,195.57$32,705.0730.86% E101-41000-132 Dental Insurance$3,400$475.05$127.90$2,924.9513.97% E101-41000-134 Employer Paid Life$600$213.10$49.60$386.9035.52% E101-41000-135 Employer Paid Disability$900$413.99$83.59$486.0146.00% 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$42.86$23.18$1,057.143.90% E101-41000-203 Printed Forms & Papers$1,900$1,041.55$82.50$858.4554.82% Award frames; March 10 meeting suppliesE101-41000-210 Operating Supplies$800$428.51$0.00$371.4953.56% E101-41000-300 Assessor$0$0.00$0.00$0.000.00% E101-41000-301 Auditing and Acct gServices$23,500$17,000.00$17,000.00$6,500.0072.34% E101-41000-303 Engineering Fees$0$0.00$0.00$0.000.00% E101-41000-304 Legal Services$55,000$22,202.00$6,874.50$32,798.0040.37% 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$7,822.50($49,299.19)5029.92% E101-41000-309 Software Support & Maintenance$18,200$4,376.65$1,582.18$13,823.3524.05% E101-41000-314 Animal Control$0$0.00$0.00$0.000.00% 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$551.00$0.00$46,149.001.18% E101-41000-321 Telephone$3,700$2,067.38$421.59$1,632.6255.88% E101-41000-322 Postage$2,200$1,012.79$307.77$1,187.2146.04% 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$57.38$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$2,121.56$0.00$10,878.4416.32% E101-41000-413 Equipment Rental$1,900$684.69$112.13$1,215.3136.04% E101-41000-430 Recycling$30,100$0.00$0.00$30,100.000.00% E101-41000-433 Dues and Subscriptions$6,100$157.00$45.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$0.00$0.00$5,500.000.00% Total Admin & Finance Dept. Expenditures$504,700$177,770.87$53,242.86$326,929.1335.22% 2023 YTD May Budget Description2023 BudgetAmountAmountBalance% 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$23,854.47$4,258.26$35,745.5340.02% E101-41910-121 PERA Coord. Employer Contribu.$4,200$1,154.93$319.38$3,045.0727.50% E101-41910-122 FICA Employer Contribution$3,700$1,409.11$250.70$2,290.8938.08% E101-41910-126 MEDICARE Employer Contribution$900$351.97$58.64$548.0339.11% E101-41910-131 Employer Paid Health$20,000$6,428.13$1,367.18$13,571.8732.14% E101-41910-132 Dental Insurance$1,500$255.78$54.81$1,244.2217.05% E101-41910-134 Employer Paid Life$200$59.20$14.40$140.8029.60% E101-41910-135 Employer Paid Disability$500$164.21$37.61$335.7932.84% E101-41910-203 Printed Forms & Papers$600$0.00$0.00$600.000.00% E101-41910-311 Contract Permit Inspections$50,000$19,430.66$1,713.60$30,569.3438.86% E101-41910-312 Planning Services$50,000$23,959.91$6,413.50$26,040.0947.92% E101-41910-313 Committee & Commission Reimbur$5,000$550.00$0.00$4,450.0011.00% E101-41910-316 Conferences & Seminars$50$0.00$0.00$50.000.00% E101-41910-319 Other Services$0$123.00$123.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$84,330.40$14,611.08$122,019.6040.87% ASSESSOR ExpendituresE 101-41960-300 Assessor$21,600$9,000.00$1,800.00$12,600.0041.67% 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% 2023 YTD May Budget Description2023 BudgetAmountAmountBalance% of BudgetComments FIREGENERALFUNDCONT. ExpendituresE 101-42200-101 Regular Wages & Salaries$147,200$49,348.10$13,190.08$97,851.9033.52% E101-42200-121 PERA Coord. Employer Contribu.$0$0.00$0.00$0.000.00% E101-42200-122 FICA Employer Contribution$9,100$2,885.98$760.49$6,214.0231.71% E101-42200-124 Police & Fire PERA$3,600$3,626.83$769.96($26.83)100.75% E101-42200-126 MEDICARE Employer Contribution$2,100$480.05$194.16$1,619.9522.86% E101-42200-134 Employer Paid Life$200$80.00$16.00$120.0040.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$0.00$0.00$400.000.00% E101-42200-203 Printed Forms & Papers$150$0.00$0.00$150.000.00% E101-42200-209 Medical Supplies$3,000$959.92$764.42$2,040.0832.00% Pagers $2,730; Fire Suppression supplies $686; E101-42200-210 Operating Supplies$8,000$3,466.63($322.60)$4,533.3743.33%Cintas; Dinners E101-42200-211 Cleaning Supplies$100$0.00$0.00$100.000.00% E101-42200-212 Fuel$3,500$1,325.15$447.88$2,174.8537.86% E101-42200-217 Uniforms & Safety Equipment$10,000$1,073.13$0.00$8,926.8710.73% E101-42200-221 Equipment Parts$3,000$226.44$170.71$2,773.567.55% E101-42200-222 Tires$0$0.00$0.00$0.000.00% E101-42200-223 Structure Repair & Supplies$2,000$336.93$151.32$1,663.0716.85% E101-42200-240 Small Tools and Minor Equip$9,000$38.00$0.00$8,962.000.42% 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$0.00$0.00$1,300.000.00% E101-42200-309 Software Support & Maintenance$17,000$5,032.56$3,358.56$11,967.4429.60% 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,363.50$178.50$12,636.5015.76% E101-42200-319 Other Services$500$0.00$0.00$500.000.00% E101-42200-321 Telephone$6,800$2,345.14$529.51$4,454.8634.49% 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,346.93$846.55$153.0789.80% 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$4,936.45$367.28$3,063.5561.71% E101-42200-384 Refuse/Garbage Disposal$1,100$374.00$97.94$726.0034.00% E101-42200-385 Sewer Pumping & Maintenance$700$0.00$0.00$700.000.00% E101-42200-401 Building Maintenance/Repairs$2,500$1,480.06$374.00$1,019.9459.20%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,047.59$2,395.28$3,952.4150.59% E101-42200-407 Well Repair & Maintenance$0$0.00$0.00$0.000.00% E101-42200-433 Dues and Subscriptions$2,400$1,474.00$290.00$926.0061.42% 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$0.00$0.00$500.000.00% E101-42200-570 Office Equipment$900$0.00$0.00$900.000.00% E101-42200-720 Operating Transfers$0$0.00$0.00$0.000.00% Total Fire Dept Expenditures$330,000$110,763.76$24,580.04$219,236.2433.56% ANIMAL CONTROL ExpendituresE 101-42700-314 Animal Control$5,000$1,650.25$587.62$3,349.7533.01% 2023 YTD May Budget Description2023 BudgetAmountAmountBalance% of BudgetComments PUBLIC WORKSGENERALFUNDCONT. ExpendituresE 101-43000-101 Regular Wages & Salaries$229,700$86,232.60$17,512.31$143,467.4037.54% 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$6,798.65$1,313.39$10,801.3538.63% E101-43000-122 FICA Employer Contribution$14,600$5,340.31$1,025.41$9,259.6936.58% E101-43000-126 MEDICARE Employer Contribution$3,400$1,446.79$239.82$1,953.2142.55% E101-43000-131 Employer Paid Health$70,900$29,518.05$4,860.27$41,381.9541.63% E101-43000-132 Dental Insurance$2,300$528.91$88.15$1,771.0923.00% E101-43000-134 Employer Paid Life$700$305.92$66.16$394.0843.70% E101-43000-135 Employer Paid Disability$1,700$885.90$144.80$814.1052.11% 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$2,074.36$1,367.06$6,325.6424.69% E101-43000-212 Fuel$20,000$12,324.14$1,798.14$7,675.8661.62% E101-43000-217 Uniforms & Safety Equipment$2,200$509.62$308.18$1,690.3823.16% plow repair partsE101-43000-221 Equipment Parts$14,000$10,493.09$156.76$3,506.9174.95% 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,020.41$835.59$14,479.5912.24% E101-43000-226 Sign Replacement and Repair$0$173.83$173.83($173.83)0.00% E101-43000-228 Gravel$10,000$0.00$0.00$10,000.000.00% 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$3,830.50$909.00$6,169.5038.31% 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 subscriptionE101-43000-309 Software Support & Maintenance$2,000$6,554.00$1,554.00($4,554.00)327.70% E101-43000-317 Employee Training$1,700$1,010.00$0.00$690.0059.41% E101-43000-319 Other Services$13,600$86.45$22.95$13,513.550.64% E101-43000-321 Telephone$3,000$1,632.12$223.67$1,367.8854.40% 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,431.34$271.15$568.6685.78% E101-43000-384 Refuse/Garbage Disposal$1,000$309.37$125.29$690.6330.94% E101-43000-385 Sewer Pumping & Maintenance$1,600$0.00$0.00$1,600.000.00% E101-43000-387 Street Light Utilities$4,200$1,992.13$340.05$2,207.8747.43% E101-43000-401 Building Maintenance/Repairs$8,000$1,228.57$213.60$6,771.4315.36% 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$10,662.61$0.00$4,837.3968.79% E101-43000-405 Contractual Road Maint/Repair$157,500$3,422.53$0.00$154,077.472.17% 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$326.23$76.76$773.7729.66% E101-43000-433 Dues and Subscriptions$200$0.00$0.00$200.000.00% E101-43000-438 Misc. Contractual$15,750$1,800.00$1,800.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$260,157.72$35,426.34$472,592.2835.50% 2023 YTD May Budget Description2023 BudgetAmountAmountBalance% of BudgetComments GENERAL FUND CONT.PARKS & RECREATION ExpendituresE 101-45000-101 Regular Wages & Salaries$10,200$2,595.40$757.48$7,604.6025.45% E101-45000-104 Temporary Employee Wages$40,200$6,176.38$1,400.00$34,023.6215.36% E101-45000-121 PERA Coord. Employer Contribu.$800$192.25$56.80$607.7524.03% E101-45000-122 FICA Employer Contribution$3,300$510.90$131.15$2,789.1015.48% E101-45000-126 MEDICARE Employer Contribution$800$146.90$30.67$653.1018.36% E101-45000-131 Employer Paid Health$2,700$969.62$185.45$1,730.3835.91% E101-45000-132 Dental Insurance$100$19.20$3.20$80.8019.20% E101-45000-134 Employer Paid Life$0$11.48$2.24($11.48)0.00% E101-45000-135 Employer Paid Disability$1,000$28.35$5.67$971.652.84% 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$100.37$68.41$829.6310.79% 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$240.00$0.00$960.0020.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,315.61$464.99$2,184.3951.46% E101-45000-384 Refuse/Garbage Disposal$2,500$803.18$383.18$1,696.8232.13% 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,192.91$0.00$1,607.0966.52% 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$488.88$3,511.1212.22% E101-45000-438 Misc. Contractual$3,300$0.00$0.00$3,300.000.00% E101-45000-439 Refunds Issued$0$565.01$0.00($565.01)0.00% VinterfestE101-45000-440 Events$7,000$2,393.99$32.99$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$28,173.98$4,011.11$83,496.0225.23% 2023 YTD May Budget Description2023 BudgetAmountAmountBalance% of BudgetComments GENERAL FUND CONT.COMMUNITY CENTER ExpendituresE 101-45180-101 Regular Wages & Salaries$15,000$5,516.36$1,103.27$9,483.6436.78% E101-45180-104 Temporary Employee Wages$0$0.00$0.00$0.000.00% E101-45180-121 PERA Coord. Employer Contribu.$1,100$412.83$82.72$687.1737.53% E101-45180-122 FICA Employer Contribution$900$316.42$64.46$583.5835.16% E101-45180-126 MEDICARE Employer Contribution$200$83.46$15.10$116.5441.73% E101-45180-131 Employer Paid Health$3,700$1,264.50$255.60$2,435.5034.18% E101-45180-134 Employer Paid Life$0$18.60$3.60($18.60)0.00% E101-45180-135 Employer Paid Disability$200$57.15$11.43$142.8528.58% E101-45180-151 Worker sComp Insurance Prem$0$0.00$0.00$0.000.00% E101-45180-210 Operating Supplies$2,900$789.97$124.44$2,110.0327.24% E101-45180-223 Structure Repair & Supplies$6,500$0.00$0.00$6,500.000.00% E101-45180-334 Licenses & Permits$1,000$792.00$40.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,235.60$802.54$5,964.4046.75% E101-45180-384 Refuse/Garbage Disposal$1,900$886.69$255.30$1,013.3146.67% 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$8,981.76$1,775.59$6,018.2459.88% E101-45180-404 Repair Machinery/Equipment$5,000$298.00$248.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$1,500.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$36,702.26$6,282.05$42,787.7446.17% Operating TransfersE 101-49000-720 Operating Transfers$950,000.01$150,000.01($950,000.01) TOTAL GENERAL FUND EXPENDITURES$2,182,509$716,878.60$140,541.10$1,465,630.4032.85% 2023 YTD May Budget Description2023 BudgetAmountAmountBalance% 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 of property tax settlement 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$0.00$0.00$0.000.00% 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$0.00$0.00$2,000.000.00% EDAM Membership; Sister City DuesE225-46500-433 Dues and Subscriptions$1,700$805.00$0.00$895.0047.35% E225-46500-440 Events$800$0.00$0.00$800.000.00% E225-46500-720 Operating Transfers$0$3,524.94$0.00$0.000.00% transfer of property tax settlement from checking Total EDA Fund Expenditures$5,300.00$4,329.94$0.00$3,995.0081.70% 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$6,637.13$1,715.03$9,562.8740.97% R226-41950-38051 PEG Fees$4,200$1,783.74$453.18$2,416.2642.47% Total Cable TVFund Revenue$20,500.00$8,720.87$2,168.21$11,779.1342.54% 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$163.13$3,032.1513.37% E226-41950-438 Misc. Contractual$5,300$1,380.00$0.00$3,920.0026.04% E226-41950-570 Office Equipment$0$4,128.98$0.00($4,128.98)0.00% Total Cable TV Fund Expenditures$9,100.00$6,570.31$163.13$2,529.6972.20% 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$60,000.00$0.00100.00% E313-47000-611 Long Term Debt Interest$3,047$930.00$930.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$60,930.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% 2023 YTD May Budget Description2023 BudgetAmountAmountBalance% 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 E401-48000-303 Engineering Fees$2,542.50$2,542.50($2,542.50)0.00% 0Gateway Trail Engineering E101-48000-308 Other Professional Services$0$12,000.00$12,000.00($12,000.00)0.00% Gateway Trail Lobbying E401-48000-435 Misc Expense$0$0.00($12,142.50)$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$88,317.50$2,400.00$246,182.5026.40% 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 donationR404-48000-36230 Donations$0$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$4,500.00$4,500.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$4,500.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$16,481.50$1,924.50$3,518.5082.41% E408-43100-530 Capital Impr Other Than Bldgs$973,000$260.08$0.00$972,739.920.03% Total LRIF Expenditures$973,000.00$260.08$0.00$972,739.920.03% 2023 YTD May Budget Description2023 BudgetAmountAmountBalance% 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$32,460.40$308.52$108,239.6023.07% 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$40,500.36$308.52$101,199.6428.58% ExpenditureE 602-43210-101 Regular Wages & Salaries$22,500$8,377.81$1,675.56$14,122.1937.23% 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$627.14$125.68$16,372.863.69% E602-43210-122 FICA Employer Contribution$1,400$481.11$98.22$918.8934.37% E602-43210-126 MEDICARE Employer Contribution$300$127.01$22.97$172.9942.34% 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$19.36$6.99$2,480.640.77% 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$36,699.50$5,308.00($26,199.50)349.52% 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$1,180.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,292.43$241.42$1,107.5753.85% E602-43210-322 Postage$600$0.00$0.00$600.000.00% E602-43210-331 Travel Expenses$200$0.00$0.00$200.000.00% 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,182.84$289.71$317.1687.31%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$9,428.30$0.00$6,571.7058.93%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$60,024.15$7,272.99$99,175.8537.70% UPTOWN SEWER RevenueR 612-43210-34401 Sewer User Fees$22,300$4,867.74$4,724.18$17,432.2621.83% R612-43210-36210 Interest Income$200$0.00$0.00$200.000.00% Total Uptown Sewer Revenue$22,500.00$4,867.74$4,724.18$17,632.2621.63% ExpenditureE 612-43210-101 Regular Wages & Salaries$9,700$3,592.90$718.58$6,107.1037.04% E612-43210-121 PERA Coord. Employer Contribu.$700$269.19$53.94$430.8138.46% E612-43210-122 FICA Employer Contribution$600$206.35$42.11$393.6534.39% E612-43210-126 MEDICARE Employer Contribution$100$54.34$9.82$45.6654.34% 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$486.98$68.87$1,213.0228.65% 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,498.09$120.80$18,551.9111.87%