Loading...
06.b Treasurer's ReportCity ofScandia Treasurer’sReport Jul-2025 FUND ACCOUNTING Beginning Cash Balance $ 2,592,273.277/1/2025 Beginning Checking Balance$ 275,265.96 Checking Receipts 1,809,274.26 Transfers to Checking Total Deposits 1,809,274.26 Expenditures 565,814.49) CASH BALANCES7/31/2025 Payroll$ (73,963.58) Transfers to Money Market G 101-10100GENERAL FUND$ 2,427,203.82 Total Payments 639,778.07) G 203-10100COVID-19 RELIEF$ - G 225-10100EDA$ 42,739.42 Ending Checking Balance 1,444,762.15G 226-10100CABLE TV$ 41,218.11 G 230-10100GATEWAY TRAIL$ - Beginning Money Market Balance 42,957.10G 240-10100PUBLIC SAFETY AID$ 22,371.00 Money Market Receipts 38.31G 313-101002013 EQUIP CERT$ - Transfer to Checking G 318-101002018 ROAD PROJECT$ 194,393.05 Transfer from Checking G 324-101002024 ROAD PROJECTS$ (84,216.36) G 325-10100 2025 EQUIPMENT BOND$ (7,567.47) Ending Money Market Balance 42,995.41 G 401-10100CAPITAL IMPROVEMENT$ 401,193.91 G 404-10100PARK DEVELOPMENT$ (10,140.58) Beginning Investments Balance 2,292,844.47 G 406-10100EQUIPMENT REPLACE$ 130,127.13 Investments Receipts-Interest 27,016.39G 408-10100LRIF$ 541,577.80 Transfer from Checking G 602-10100BLISS SEWER$ 732.43 G 612-10100UPTOWN SEWER$ 32,156.14TransferstoChecking Ending Investments Balance$ 2,319,860.86G 624-10100A-E SEWER$ 49,988.74 G 801-10100ESCROW$ 25,841.28 Outstanding Checks$ (12,695.12)$ 3,807,618.42 7/31/2025$ - Ending Cash Balance $ 3,807,618.42 CHECKING, MONEY MARKET & INVESTMENT CD's Checking *102$ 275,265.96BegBal Credits$ 1,810,257.54 Debits$ (628,066.23) Receipt in Transit 1,457,457.27EndBal Money Market *105 - Rate 1.05%$ 42,957.10BegBal rate change from 1.25% Credits 38.31 Debits End Bal$ 42,995.41 Investments CD *4424 - Rate 5.00% 12 mo., 7/27/2025$ 497,156.49 CD *4428 - Rate 5.10% 7 mo., 05/01/25 $ 815,721.95 CD *4427 - Rate 4.50% 9 mo., 07/30/25 598,612.28 Bond 3109 Account @4.98% 408,370.14 Total Investments$ 2,319,860.86 Total Bank & Investment Accounts 3,820,313.54 12,695.12) Checks in Transit *3102 Total Funds$ 3,807,618.42 Submitted by: Veronica Korby, Treasurer CITY OF SCANDIA Revenue - Expenditure Summary JULY 2025 2025 YTD % of Description 2025 Budget Amount Month Amount Budget Balance Budget Comments GENERAL FUND RevenueR 101-41000-31000 Washington Cty. Tax Settlement$1,893,907.00$1,102,935.37$1,102,935.37$790,971.6358.24% R101-41000-31040 Fiscal Disparities$123,679.00$88,065.91$88,065.91$35,613.0971.21% R101-41000-31701 Gravel Taxes$20,000.00$5,664.18$5,664.18$14,335.8228.32% R 101-41000-31830 Solar Energy Production Tax$5,500.00$4,195.82$4,195.82$1,304.1876.29% R 101-41000-31900 Penalties & Interest Del Tax$0.00$0.00$0.00$0.000.00% R 101-41000-32150 ROW Utility Permit$5,000.00$3,600.00$600.00$1,400.0072.00% R101-41000-32180 Tobacco & Liquor Licenses$15,000.00$125.00$25.00$14,875.000.83% R 101-41000-32190 Other City Permits$3,000.00$1,087.00$75.00$1,913.0036.23% R101-41000-32210 Building Permits$160,000.00$114,512.30$23,576.22$45,487.7071.57% R 101-41000-32260 Gambling Permits$100.00$30.00$15.00$70.0030.00% R 101-41000-33401 LGA/MVHC/AG/PERA Aid$7,000.00$0.00$0.00$7,000.000.00% R 101-41000-33420 Fire Relief State PERA$42,000.00$0.00$0.00$42,000.000.00% R 101-41000-33422 Other State Grants & Aids$6,000.00$9,273.00$4,842.00($3,273.00)154.55% R101-41000-33428 PILOT$6,000.00$3,355.99$3,355.99$2,644.0155.93% R101-41000-33620 Recycling Grant$8,000.00$8,198.00$0.00($198.00)102.48% R101-41000-33630 Local Govt Grants & Aids$0.00$0.00$0.00$0.000.00% R101-41000-33640 Other Grants$0.00$0.00$0.00$0.000.00% R 101-41000-34103 Zoning and Planning$6,000.00$3,500.00$100.00$2,500.0058.33% R 101-41000-34107 Assessment Search Fees$20.00$0.00$0.00$20.000.00% R101-41000-34109 Water Usage$150.00$0.00$0.00$150.000.00% R 101-41000-34202 Fire Protection Services$36,443.00$36,443.00$0.00$0.00100.00% R101-41000-34301 Restitution$0.00$0.00$0.00$0.000.00% R101-41000-34303 Dust Control$2,700.00$3,529.12$0.00($829.12)130.71% R 101-41000-34304 Reimbursement for Services$0.00$900.00$900.00($900.00)0.00% R 101-41000-34305 Other Street Services$0.00$0.00$0.00$0.000.00% R 101-41000-34730 Ad Revenue$1,000.00$450.00$0.00$550.0045.00% R101-41000-34750 Facilities Rental$7,400.00$13,504.06$1,726.84($6,104.06)182.49% R 101-41000-34760 Cleaning Fees$0.00$0.00$0.00$0.000.00% R101-41000-34790 Recreation Programs$1,500.00$960.00$0.00$540.0064.00% R 101-41000-35101 Fines & Forfeitures$6,000.00$5,467.93$1,136.61$532.0791.13% R 101-41000-36210 Interest Income$300,000.00$83,571.60$27,066.87$216,428.4027.86% R101-41000-36230 Donations$4,000.00$883.31$0.00$3,116.6922.08% R 101-41000-36240 Insurance Dividend$4,000.00$6,360.00$0.00($2,360.00)159.00% R101-41000-36250 Misc. Refund$1,500.00$4,096.31$72.00($2,596.31)273.09% R 101-41000-39101 Sales of General Fixed Assets$0.00$10,500.00$0.00($10,500.00)0.00% Total General Fund Revenue$ 2,665,899 $ 1,511,208 $ 1,264,353 $ 1,154,691 56.69% Operating TransfersR 101-41000-39200 Interfund Operating Transfer$0.00$0.00$0.00$0.000.00% R101-41000-39204 Transfer from MM$0.00$90,000.00$0.00($90,000.00)0.00% R101-49000-39203 Transfer from Other Funds$0.00$613,301.00$0.00($613,301.00)0.00% R101-49000-39204 Transfer from MM$0.00$1,505,000.00$0.00($1,505,000.00)0.00% R 101-49000-39205 Transfer from Investments$0.00$343,543.69$0.00($343,543.69)0.00% Total Operating Transfers$ -$ 2,551,845$ -$ (2,551,845) CITY OF SCANDIA Revenue - Expenditure Summary JULY 2025 2025 YTD % of Description 2025 Budget Amount Month Amount Budget Balance Budget Comments GENERAL FUND ExpenditureADMINISTRATION & FINANCE E 101-41000-101 Regular Wages & Salaries$213,000.00$122,661.93$23,652.29$90,338.0757.59% E101-41000-121 PERA Coord. Employer Contribu.$15,000.00$9,191.17$1,773.90$5,808.8361.27% E101-41000-122 FICA Employer Contribution$13,200.00$7,401.42$1,441.39$5,798.5856.07% E101-41000-126 MEDICARE Employer Contribution$3,100.00$1,763.20$337.11$1,336.8056.88% E 101-41000-131 Employer Paid Health$53,400.00$25,259.96$3,477.36$28,140.0447.30% E 101-41000-132 Dental Insurance$2,400.00$1,107.02$147.96$1,292.9846.13% E 101-41000-134 Employer Paid Life$700.00$374.40$46.40$325.6053.49% E101-41000-135 Employer Paid Disability$900.00$822.98$111.88$77.0291.44% E101-41000-151 Worker sComp Insurance Prem$1,874.00$1,254.00$0.00$620.0066.92% E 101-41000-200 Office Supplies$1,000.00$391.54$202.91$608.4639.15% E 101-41000-203 Printed Forms & Papers$2,000.00$2,099.91$0.00($99.91)105.00% E 101-41000-210 Operating Supplies$600.00$462.85$130.52$137.1577.14% E 101-41000-301 Auditing and Acct g Services$28,700.00$38,100.00$0.00($9,400.00)132.75% E101-41000-303 Engineering Fees$0.00$0.00$0.00$0.000.00% E 101-41000-304 Legal Services$50,000.00$13,510.00$671.00$36,490.0027.02% E 101-41000-306 Personal Testing & Recruit$0.00$0.00$0.00$0.000.00% E 101-41000-308 Other Professional Services$2,500.00$1,557.85$0.00$942.1562.31% E101-41000-309 Software Support & Maintenance$20,219.00$4,769.45$303.08$15,449.5523.59% E 101-41000-316 Conferences & Seminars$300.00$695.00$0.00($395.00)231.67% E 101-41000-317 Employee Training$500.00$1,150.00$0.00($650.00)230.00% E 101-41000-319 Other Services$150.00$377.38$92.00($227.38)251.59% E 101-41000-321 Telephone$6,000.00$3,432.37$540.07$2,567.6357.21% E 101-41000-322 Postage$2,600.00$1,392.06$79.80$1,207.9453.54% E 101-41000-331 Travel Expenses$1,000.00$1,347.16$1,065.76($347.16)134.72% E 101-41000-351 Legal Notices Publishing$2,000.00$495.21$83.13$1,504.7924.76% E 101-41000-361 Liability/Property Ins$9,166.00$7,761.84$0.00$1,404.1684.68% E 101-41000-365 Insurance Claims$0.00$0.00$0.00$0.000.00% E 101-41000-381 Utilities-Electric & Gas$12,000.00$3,469.12$0.00$8,530.8828.91% E 101-41000-413 Equipment Rental$1,800.00$1,082.69$79.26$717.3160.15% E 101-41000-430 Recycling$0.00$40.00$0.00($40.00)0.00% E 101-41000-433 Dues and Subscriptions$7,230.00$5,671.99$0.00$1,558.0178.45% E 101-41000-434 Youth Service Bureau$5,500.00$5,500.00$5,500.00$0.00100.00% E 101-41000-435 Misc Expense$0.00$27.00$0.00($27.00)0.00% E 101-41000-438 Misc. Contractual$3,000.00$3,127.50$0.00($127.50)104.25% E 101-41000-439 Refunds Issued$0.00$200.00$150.00($200.00)0.00% E 101-41000-560 Furniture and Fixtures$0.00$139.89$0.00($139.89)0.00% E 101-41000-570 Office Equipment$10,000.00$477.43$0.00$9,522.574.77% E 101-41000-720 Operating Transfers$0.00$200,000.00$0.00($200,000.00)0.00% Total Admin & Finance Dept. Expenditures$ 469,839 $ 467,114 $ 39,886 $ 2,725 99.42% CITY OF SCANDIA Revenue - Expenditure Summary JULY 2025 2025 YTD % of Description 2025 Budget Amount Month Amount Budget Balance Budget Comments GENERAL FUND CONT.CITY COUNCIL ExpendituresE 101-41110-101 Regular Wages & Salaries$22,000.00$10,008.91$5,500.60$11,991.0945.50% E101-41110-122 FICA Employer Contribution$1,400.00$191.86$65.17$1,208.1413.70% E101-41110-126 MEDICARE Employer Contribution$300.00$145.14$79.76$154.8648.38% E 101-41110-127 PERA Defined$700.00$345.70$222.47$354.3049.39% E101-41110-151 Worker sComp Insurance Prem$52.00$80.00$0.00($28.00)153.85% E 101-41110-308 Other Professional Services$0.00$85.00$0.00($85.00)0.00% E 101-41110-316 Conferences & Seminars$400.00$1,079.00$0.00($679.00)269.75% E 101-41110-331 Travel Expenses$600.00$0.00$0.00$600.000.00% E 101-41110-560 Furniture and Fixtures$0.00$0.00$0.00$0.000.00% E 101-41110-570 Office Equipment$0.00$0.00$0.00$0.000.00% Total City Council Dept. Expenditures$ 25,452 $ 11,936 $ 5,868 $ 13,516 46.89% ExpendituresELECTIONS E 101-41410-199 Election Judge$0.00$0.00$0.00$0.000.00% E 101-41410-200 Office Supplies$0.00$0.00$0.00$0.000.00% E 101-41410-203 Printed Forms & Papers$0.00$0.00$0.00$0.000.00% E 101-41410-210 Operating Supplies$0.00$0.00$0.00$0.000.00% E 101-41410-351 Legal Notices Publishing$0.00$0.00$0.00$0.000.00% E 101-41410-413 Equipment Rental$1,839.00$1,820.00$0.00$19.0098.97% Total Elections Dept. Expenditures$ 1,839 $ 1,820 $ - $ 19 ExpendituresPLANNING & BUILDING E 101-41910-101 Regular Wages & Salaries$62,000.00$35,610.79$7,166.25$26,389.2157.44% E101-41910-121 PERA Coord. Employer Contribu.$4,400.00$2,670.40$537.48$1,729.6060.69% E101-41910-122 FICA Employer Contribution$3,900.00$2,117.07$431.91$1,782.9354.28% E101-41910-126 MEDICARE Employer Contribution$900.00$500.42$101.00$399.5855.60% E 101-41910-131 Employer Paid Health$15,500.00$10,116.10$1,394.20$5,383.9065.27% E 101-41910-132 Dental Insurance$700.00$438.48$54.81$261.5262.64% E 101-41910-134 Employer Paid Life$200.00$86.40$14.40$113.6043.20% E101-41910-135 Employer Paid Disability$400.00$285.60$38.91$114.4071.40% E 101-41910-203 Printed Forms & Papers$0.00$0.00$0.00$0.000.00% E101-41910-309 Software Support & Maintenance$0.00$4,940.00$0.00($4,940.00)0.00% E101-41910-311 Contract Permit Inspections$60,000.00$37,020.10$11,527.02$22,979.9061.70% E 101-41910-312 Planning Services$60,000.00$41,086.50$9,822.00$18,913.5068.48% E101-41910-313 Committee & Commission Reimbur$5,200.00$2,600.00$0.00$2,600.0050.00% E 101-41910-316 Conferences & Seminars$0.00$0.00$0.00$0.000.00% E 101-41910-319 Other Services$0.00$0.00$0.00$0.000.00% E 101-41910-361 Liability/Property Ins$4,937.00$4,121.00$0.00$816.0083.47% E 101-41910-438 Misc. Contractual$5,000.00$1,132.08$0.00$3,867.9222.64% E 101-41910-439 Refunds Issued$0.00$206.00$30.00($206.00)0.00% E 101-41910-720 Operating Transfers$0.00$0.00$0.00$0.000.00% Total Planning & Building Dept. Expenditures$ 223,137 $ 142,931 $ 31,118 $ 80,206 64.06% ExpendituresASSESSOR E 101-41960-300 Assessor$23,200.00$14,060.92$2,000.00$9,139.0860.61% ExpendituresPOLICE E 101-42100-318 Police Contract$194,293.00$0.00$0.00$194,293.000.00% E 101-42100-319 Other Services$1,000.00$0.00$0.00$1,000.000.00% Total GF Police Dept. Expenditures$ 195,293 $ - $ - $ 195,293 0.00% CITY OF SCANDIA Revenue - Expenditure Summary JULY 2025 2025 YTD % of Description 2025 Budget Amount Month Amount Budget Balance Budget Comments GENERAL FUND CONT.FIRE ExpendituresE 101-42200-101 Regular Wages & Salaries$198,800.00$99,882.28$21,889.50$98,917.7250.24% E101-42200-121 PERA Coord. Employer Contribu.$9,300.00$0.00$0.00$9,300.000.00% E101-42200-122 FICA Employer Contribution$12,300.00$5,273.06$1,143.24$7,026.9442.87% E 101-42200-124 Police & Fire PERA$0.00$6,228.93$1,217.04($6,228.93)0.00% E101-42200-126 MEDICARE Employer Contribution$2,900.00$1,622.91$320.31$1,277.0955.96% E 101-42200-134 Employer Paid Life$200.00$112.00$16.00$88.0056.00% E101-42200-135 Employer Paid Disability$0.00$0.00$0.00$0.000.00% E101-42200-141 Unemployment Compensation$0.00$0.00$0.00$0.000.00% E101-42200-151 Worker sComp Insurance Prem$6,250.00$6,718.00$0.00($468.00)107.49% E 101-42200-200 Office Supplies$300.00$57.83$0.00$242.1719.28% E 101-42200-203 Printed Forms & Papers$200.00$0.00$0.00$200.000.00% E 101-42200-209 Medical Supplies$3,000.00$1,186.97$0.00$1,813.0339.57% E 101-42200-210 Operating Supplies$8,800.00$5,443.16$115.98$3,356.8461.85% E101-42200-211 Cleaning Supplies$100.00$83.70$0.00$16.3083.70% E 101-42200-212 Fuel$4,800.00$1,571.17$0.00$3,228.8332.73% E101-42200-217 Uniforms & Safety Equipment$15,000.00$1,712.36$1,226.36$13,287.6411.42% E 101-42200-221 Equipment Parts$1,500.00$308.65$0.00$1,191.3520.58% E 101-42200-222 Tires$0.00$0.00$0.00$0.000.00% E 101-42200-223 Structure Repair & Supplies$800.00$91.47$0.00$708.5311.43% E 101-42200-240 Small Tools and Minor Equip$8,000.00$4,884.32$1,654.54$3,115.6861.05% E 101-42200-305 Medical Services$6,000.00$5,655.00$0.00$345.0094.25% E 101-42200-306 Personal Testing & Recruit$500.00$1,104.00$1,104.00($604.00)220.80% E101-42200-309 Software Support & Maintenance$17,700.00$5,872.56$72.00$11,827.4433.18% E 101-42200-310 Medical Training$1,000.00$0.00$0.00$1,000.000.00% E 101-42200-316 Conferences & Seminars$250.00$0.00$0.00$250.000.00% E 101-42200-317 Employee Training$5,000.00$6,056.00$0.00($1,056.00)121.12% E 101-42200-319 Other Services$500.00$114.84$0.00$385.1622.97% E 101-42200-321 Telephone$6,500.00$4,126.49$1,207.44$2,373.5163.48% E 101-42200-322 Postage$0.00$0.00$0.00$0.000.00% E 101-42200-324 State of MN-Fire Relief$40,474.00$0.00$0.00$40,474.000.00% E 101-42200-325 City Match-Fire Relief$0.00$0.00$0.00$0.000.00% E 101-42200-331 Travel Expenses$2,500.00$1,001.64$0.00$1,498.3640.07% E 101-42200-334 Licenses & Permits$500.00$29.62$0.00$470.385.92% E 101-42200-340 Advertising$0.00$0.00$0.00$0.000.00% E 101-42200-361 Liability/Property Ins$7,208.00$7,932.69$0.00($724.69)110.05% E 101-42200-381 Utilities-Electric & Gas$6,000.00$2,644.18($94.50)$3,355.8244.07% E 101-42200-384 Refuse/Garbage Disposal$0.00$0.00$0.00$0.000.00% E101-42200-385 Sewer Pumping & Maintenance$550.00$323.50$0.00$226.5058.82% E101-42200-401 Building Maintenance/Repairs$3,500.00$1,271.20$226.23$2,228.8036.32% E101-42200-403 Improvements Other Than Bldgs$0.00$0.00$0.00$0.000.00% E101-42200-404 Repair Machinery/Equipment$10,000.00$10,856.53$9,158.75($856.53)108.57% E101-42200-407 Well Repair & Maintenance$0.00$0.00$0.00$0.000.00% E 101-42200-433 Dues and Subscriptions$3,500.00$3,277.43$0.00$222.5793.64% E 101-42200-438 Misc. Contractual$4,000.00$128.64$0.00$3,871.363.22% E 101-42200-440 Events$1,000.00$17.97$0.00$982.031.80% E101-42200-520 Capital Improvements to Bldgs$0.00$0.00$0.00$0.000.00% E 101-42200-530 Capital Impr Other Than Bldgs$0.00$0.00$0.00$0.000.00% E101-42200-540 Heavy Machinery Capital$0.00$0.00$0.00$0.000.00% E 101-42200-560 Furniture and Fixtures$500.00$0.00$0.00$500.000.00% E 101-42200-570 Office Equipment$900.00$0.00$0.00$900.000.00% Total Fire Dept Expenditures$ 390,332 $ 185,589 $ 39,257 $ 204,743 47.55% ANIMAL CONTROL ExpendituresE 101-42700-314 Animal Control$7,000.00$3,434.30$410.00$3,565.7049.06% CITY OF SCANDIA Revenue - Expenditure Summary JULY 2025 2025 YTD % of Description 2025 Budget Amount Month Amount Budget Balance Budget Comments GENERAL FUND CONT.PUBLIC WORKS ExpendituresE 101-43000-101 Regular Wages & Salaries$271,500.00$157,425.09$31,480.61$114,074.9157.98% E 101-43000-102 OT Regular Wages$5,200.00$3,645.98$697.21$1,554.0270.12% E101-43000-104 Temporary Employee Wages$2,300.00$7,040.64$3,754.13($4,740.64)306.11% E101-43000-121 PERA Coord. Employer Contribu.$20,800.00$11,830.75$2,413.31$8,969.2556.88% E101-43000-122 FICA Employer Contribution$17,300.00$9,738.93$2,162.38$7,561.0756.29% E101-43000-126 MEDICARE Employer Contribution$4,000.00$2,314.90$505.73$1,685.1057.87% E 101-43000-131 Employer Paid Health$64,600.00$39,729.39$5,074.89$24,870.6161.50% E 101-43000-132 Dental Insurance$1,200.00$705.28$88.16$494.7258.77% E101-43000-133 Union Training Center$1,872.00$936.00$144.00$936.0050.00% E 101-43000-134 Employer Paid Life$700.00$426.76$59.96$273.2460.97% E101-43000-135 Employer Paid Disability$1,400.00$966.60$124.29$433.4069.04% E101-43000-141 Unemployment Compensation$0.00$0.00$0.00$0.000.00% E101-43000-151 Worker sComp Insurance Prem$22,615.00$13,930.00$0.00$8,685.0061.60% E 101-43000-200 Office Supplies$600.00$69.98$0.00$530.0211.66% E 101-43000-210 Operating Supplies$8,500.00$2,909.84$174.66$5,590.1634.23% E 101-43000-212 Fuel$24,000.00$7,051.46$0.00$16,948.5429.38% E101-43000-217 Uniforms & Safety Equipment$2,300.00$377.53$168.42$1,922.4716.41% E 101-43000-221 Equipment Parts$14,500.00$4,495.47$2,754.96$10,004.5331.00% E 101-43000-222 Tires$7,500.00$0.00$0.00$7,500.000.00% E 101-43000-223 Structure Repair & Supplies$2,200.00$210.20$0.00$1,989.809.55% E 101-43000-224 Materials for Road Maintenance$26,000.00$8,888.42$152.84$17,111.5834.19% E101-43000-226 Sign Replacement and Repair$500.00$1,905.34$0.00($1,405.34)381.07% E 101-43000-228 Gravel$0.00$1,056.30$0.00($1,056.30)0.00% E 101-43000-229 Salt$22,000.00$16,213.98$0.00$5,786.0273.70% E 101-43000-240 Small Tools and Minor Equip$8,000.00$548.00$0.00$7,452.006.85% E 101-43000-302 Surveying$0.00$0.00$0.00$0.000.00% E101-43000-303 Engineering Fees$11,000.00$5,585.50$1,034.50$5,414.5050.78% E 101-43000-304 Legal Services$0.00$0.00$0.00$0.000.00% E 101-43000-305 Medical Services$1,200.00$54.44$0.00$1,145.564.54% E101-43000-309 Software Support & Maintenance$8,000.00$4,316.00$4,316.00$3,684.0053.95% E 101-43000-317 Employee Training$1,700.00$180.00$0.00$1,520.0010.59% E 101-43000-319 Other Services$7,000.00$3,857.06$14.85$3,142.9455.10% E 101-43000-321 Telephone$4,000.00$2,516.55$358.76$1,483.4562.91% E 101-43000-331 Travel Expenses$550.00$487.20$0.00$62.8088.58% E 101-43000-334 Licenses & Permits$550.00$0.00$0.00$550.000.00% E 101-43000-361 Liability/Property Ins$9,713.00$9,201.69$0.00$511.3194.74% E 101-43000-365 Insurance Claims$0.00$0.00$0.00$0.000.00% E 101-43000-381 Utilities-Electric & Gas$4,500.00$1,875.57($62.99)$2,624.4341.68% E 101-43000-384 Refuse/Garbage Disposal$700.00$72.00$0.00$628.0010.29% E101-43000-385 Sewer Pumping & Maintenance$1,800.00$323.50$0.00$1,476.5017.97% E 101-43000-387 Street Light Utilities$5,000.00$1,886.76$208.41$3,113.2437.74% E101-43000-401 Building Maintenance/Repairs$8,000.00$3,111.09$238.27$4,888.9138.89% E101-43000-403 Improvements Other Than Bldgs$0.00$0.00$0.00$0.000.00% E101-43000-404 Repair Machinery/Equipment$20,000.00$17,208.05$0.00$2,791.9586.04% E 101-43000-405 Contractual Road Maint/Repair$175,000.00$58,016.13$1,835.62$116,983.8733.15% E101-43000-407 Well Repair & Maintenance$1,000.00$0.00$0.00$1,000.000.00% E 101-43000-413 Equipment Rental$4,000.00$1,418.10$877.80$2,581.9035.45% E 101-43000-417 Uniform Rental$1,300.00$511.75$103.55$788.2539.37% E 101-43000-433 Dues and Subscriptions$200.00$0.00$0.00$200.000.00% E 101-43000-438 Misc. Contractual$16,000.00$5,716.65$5,716.65$10,283.3535.73% E 101-43000-439 Refunds Issued$0.00$0.00$0.00$0.000.00% E 101-43000-530 Capital Impr Other Than Bldgs$9,900.00$0.00$0.00$9,900.000.00% E 101-43000-550 Motor Vehicles Capital$0.00$0.00$0.00$0.000.00% E 101-43000-560 Furniture and Fixtures$500.00$0.00$0.00$500.000.00% E 101-43000-570 Office Equipment$0.00$0.00$0.00$0.000.00% E 101-43000-720 Operating Transfers$0.00$0.00$0.00$0.000.00% Total Public Works Dept. Expenditures$ 821,200 $ 408,755 $ 64,397 $ 412,445 49.78% CITY OF SCANDIA Revenue - Expenditure Summary JULY 2025 2025 YTD % of Description 2025 Budget Amount Month Amount Budget Balance Budget Comments GENERAL FUND CONT.PARKS & RECREATION ExpendituresE 101-45000-101 Regular Wages & Salaries$23,900.00$13,266.34$2,729.94$10,633.6655.51% E101-45000-104 Temporary Employee Wages$40,000.00$5,806.38$0.00$34,193.6214.52% E101-45000-121 PERA Coord. Employer Contribu.$1,800.00$994.48$204.72$805.5255.25% E101-45000-122 FICA Employer Contribution$4,000.00$1,125.98$161.59$2,874.0228.15% E101-45000-126 MEDICARE Employer Contribution$900.00$268.08$37.80$631.9229.79% E 101-45000-131 Employer Paid Health$6,800.00$4,288.02$552.58$2,511.9863.06% E 101-45000-132 Dental Insurance$300.00$171.84$21.48$128.1657.28% E 101-45000-134 Employer Paid Life$100.00$32.64$5.44$67.3632.64% E101-45000-135 Employer Paid Disability$200.00$99.58$14.66$100.4249.79% E101-45000-141 Unemployment Compensation$0.00$0.00$0.00$0.000.00% E101-45000-151 Worker sComp Insurance Prem$2,251.00$3,010.00$0.00($759.00)133.72% E 101-45000-200 Office Supplies$100.00$0.00$0.00$100.000.00% E 101-45000-203 Printed Forms & Papers$200.00$0.00$0.00$200.000.00% E 101-45000-210 Operating Supplies$1,200.00$798.76$133.11$401.2466.56% E 101-45000-212 Fuel$1,500.00$346.67$0.00$1,153.3323.11% E 101-45000-221 Equipment Parts$2,500.00$1,279.75$921.66$1,220.2551.19% E 101-45000-223 Structure Repair & Supplies$2,500.00$65.75$19.96$2,434.252.63% E 101-45000-240 Small Tools and Minor Equip$600.00$0.00$0.00$600.000.00% E 101-45000-312 Planning Services$0.00$0.00$0.00$0.000.00% E101-45000-313 Committee & Commission Reimbur$0.00$540.00$0.00($540.00)0.00% E 101-45000-319 Other Services$2,000.00$620.92$0.00$1,379.0831.05% E 101-45000-322 Postage$0.00$0.00$0.00$0.000.00% E 101-45000-340 Advertising$250.00$123.25$0.00$126.7549.30% E 101-45000-353 Sales& Use Tax$0.00$0.00$0.00$0.000.00% E 101-45000-361 Liability/Property Ins$5,333.00$5,754.58$0.00($421.58)107.91% E 101-45000-381 Utilities-Electric & Gas$6,000.00$2,251.03$437.64$3,748.9737.52% E 101-45000-384 Refuse/Garbage Disposal$500.00$2,201.40$499.00($1,701.40)440.28% E101-45000-385 Sewer Pumping & Maintenance$1,250.00$349.89$0.00$900.1127.99% E101-45000-401 Building Maintenance/Repairs$6,000.00$1,338.00$120.00$4,662.0022.30% E101-45000-403 Improvements Other Than Bldgs$1,000.00$0.00$0.00$1,000.000.00% E101-45000-404 Repair Machinery/Equipment$1,000.00$927.89$0.00$72.1192.79% E 101-45000-406 Grounds Care$4,000.00$2,359.40$1,536.06$1,640.6058.99% E 101-45000-438 Misc. Contractual$8,000.00$5,517.79$1,692.79$2,482.2168.97% E 101-45000-439 Refunds Issued$0.00$0.00$0.00$0.000.00% E 101-45000-440 Events$0.00$1,255.38$192.38($1,255.38)0.00% E 101-45000-490 Financial Assistance$0.00$0.00$0.00$0.000.00% E 101-45000-530 Capital Impr Other Than Bldgs$6,000.00$0.00$0.00$6,000.000.00% E 101-45000-720 Operating Transfers$0.00$0.00$0.00$0.000.00% Total Parks & Rec Dept. Expenditures$ 130,184 $ 54,794 $ 9,281 $ 75,390 42.09% CITY OF SCANDIA Revenue - Expenditure Summary JULY 2025 2025 YTD % of Description 2025 Budget Amount Month Amount Budget Balance Budget Comments GENERAL FUND CONT.COMMUNITY CENTER ExpendituresE 101-45180-101 Regular Wages & Salaries$17,200.00$9,763.15$2,050.36$7,436.8556.76% E101-45180-104 Temporary Employee Wages$0.00$0.00$0.00$0.000.00% E101-45180-121 PERA Coord. Employer Contribu.$1,300.00$713.96$144.77$586.0454.92% E101-45180-122 FICA Employer Contribution$1,100.00$574.21$122.88$525.7952.20% E101-45180-126 MEDICARE Employer Contribution$300.00$136.26$28.71$163.7445.42% E 101-45180-131 Employer Paid Health$0.00$2,221.20$281.70($2,221.20)0.00% E 101-45180-134 Employer Paid Life$0.00$21.60$3.60($21.60)0.00% E101-45180-135 Employer Paid Disability$0.00$71.74$9.26($71.74)0.00% E101-45180-151 Worker sComp Insurance Prem$152.00$272.00$0.00($120.00)178.95% E 101-45180-210 Operating Supplies$3,000.00$1,423.13$347.37$1,576.8747.44% E 101-45180-223 Structure Repair & Supplies$2,500.00$0.00$0.00$2,500.000.00% E 101-45180-321 Telephone$0.00$1,068.54$152.55($1,068.54)0.00% E 101-45180-334 Licenses & Permits$1,000.00$838.00$0.00$162.0083.80% E 101-45180-361 Liability/Property Ins$801.00$860.44$0.00($59.44)107.42% E 101-45180-381 Utilities-Electric & Gas$10,000.00$3,605.26$171.52$6,394.7436.05% E 101-45180-384 Refuse/Garbage Disposal$500.00$0.00$0.00$500.000.00% E101-45180-385 Sewer Pumping & Maintenance$4,000.00$1,805.21$0.00$2,194.7945.13% E101-45180-401 Building Maintenance/Repairs$15,000.00$4,227.20$793.51$10,772.8028.18% E101-45180-404 Repair Machinery/Equipment$5,000.00$1,297.09$745.65$3,702.9125.94% E 101-45180-406 Grounds Care$1,300.00$85.49$0.00$1,214.516.58% E101-45180-407 Well Repair & Maintenance$1,000.00$0.00$0.00$1,000.000.00% E 101-45180-438 Misc. Contractual$3,500.00$377.31$0.00$3,122.6910.78% E 101-45180-439 Refunds Issued$0.00$0.00$0.00$0.000.00% E101-45180-520 Capital Improvements to Bldgs$9,900.00$0.00$0.00$9,900.000.00% E 101-45180-530 Capital Impr Other Than Bldgs$0.00$0.00$0.00$0.000.00% E 101-45180-570 Office Equipment$0.00$0.00$0.00$0.000.00% E 101-45180-720 Operating Transfers$0.00$0.00$0.00$0.000.00% Total Community Center Dept. Expenditures$ 77,553 $ 29,362 $ 4,852 $ 48,191 37.86% TOTAL GENERAL FUND EXPENDITURES$ 2,365,029 $ 1,319,796 $ 197,068 $ 1,045,233 55.80% E 101-49000-421 Cash Over/Short Operating TransfersE 101-49000-720 Operating Transfers$0.00$1,756,276.00$0.00($1,756,276.00)0.00% TOTAL GENERAL FUND EXPENDITURES W/TRANSFERS$ 2,365,029 $ 3,076,072 $ 197,068 $ (711,043) CITY OF SCANDIA Revenue - Expenditure Summary JULY 2025 2025 YTD % of Description 2025 Budget Amount Month Amount Budget Balance Budget Comments EDA FUND RevenueR 225-46500-31000 Washington Cty. Tax Settlement$0.00$0.00$0.00$0.000.00% R225-46500-33640 Other Grants$0.00$0.00$0.00$0.000.00% R225-46500-34750 Facilities Rental$0.00$200.00$0.00($200.00)0.00% R 225-46500-36210 Interest Income$750.00$0.00$0.00$750.000.00% R225-46500-36230 Donations$0.00$0.00$0.00$0.000.00% R 225-46500-39200 Interfund Operating Transfer$0.00$0.00$0.00$0.000.00% Total EDA Fund Revenue$ 750$ 200$ -$ 55026.67% ExpenditureE 225-46500-210 Operating Supplies$50.00$0.00$0.00$50.000.00% E225-46500-303 Engineering Fees$0.00$0.00$0.00$0.000.00% E 225-46500-304 Legal Services$0.00$0.00$0.00$0.000.00% E 225-46500-308 Other Professional Services$0.00$0.00$0.00$0.000.00% E 225-46500-340 Advertising$0.00$519.84$264.84($519.84)0.00% E 225-46500-433 Dues and Subscriptions$879.00$375.00$0.00$504.0042.66% E 225-46500-440 Events$2,000.00$364.75$0.00$1,635.2518.24% E 225-46500-720 Operating Transfers$0.00$0.00$0.00$0.000.00% Total EDA Fund Expenditures$ 2,929$ 1,260$ 265$ 1,66943.00% CABLE TV FUND RevenueR 226-41950-34304 Reimbursement for Services$3,600.00$0.00$0.00$3,600.000.00% R 226-41950-36210 Interest Income$300.00$0.00$0.00$300.000.00% R 226-41950-36260 Sale of Equipment$0.00$0.00$0.00$0.000.00% R 226-41950-38050 Cable TV Franchise Rebates$20,819.00$9,712.63$1,610.36$11,106.3746.65% R226-41950-38051 PEG Fees$4,340.00$2,429.94$402.59$1,910.0655.99% Total Cable TV Fund Revenue$ 29,059$ 12,143$ 2,013$ 16,91641.79% ExpenditureE 226-41950-240 Small Tools and Minor Equip$300.00$0.00$0.00$300.000.00% E226-41950-309 Software Support & Maintenance$3,760.00$2,989.99$205.15$770.0179.52% E 226-41950-438 Misc. Contractual$7,750.00$1,550.00$0.00$6,200.0020.00% E 226-41950-570 Office Equipment$1,000.00$0.00$0.00$1,000.000.00% Total Cable TV Fund Expenditures$ 12,810$ 4,540$ 205$ 8,27035.44% CITY OF SCANDIA Revenue - Expenditure Summary JULY 2025 2025 YTD % of Description 2025 Budget Amount Month Amount Budget Balance Budget Comments RevenueR 240-42400-33422 Other State Grants & Aids$ - $ 22,371 $ 22,371 $ (22,371) 0.00% 2018 STREET RECONSTRUCTION RevenueR 318-47000-31000 Washington Cty. Tax Settlement$ 343,166 $ 156,573 $ 156,573 $ 186,593 45.63% ExpenditureE 318-47000-601 Long Term Debt Principal$250,000.00$0.00$0.00$250,000.000.00% E318-47000-611 Long Term Debt Interest$76,825.00$38,412.51$0.00$38,412.4950.00% E 318-47000-620 Fiscal Agent s Fees$500.00$1,045.00$0.00($545.00)209.00% Total 2018 Street Reconstruction Fund Expenditures$ 327,325$ 39,458$ -$ 287,86712.05% 2024 STREET RECONSTRUCTION RevenueR 324-47000-31000 Washington Cty. Tax Settlement$112,124.00$0.00$0.00$112,124.000.00% R 324-47000-36210 Interest Income$0.00$3,168.03$0.00($3,168.03)0.00% R 324-47000-39203 Transfer from Other Funds$0.00$300,000.00$0.00($300,000.00)0.00% Total 2024 Street Reconstruction Fund Revenue$ 112,124$ 303,168$ -$ (191,044)270.39% ExpenditureE 324-47000-601 Long Term Debt Principal$180,000.00$0.00$0.00$180,000.000.00% E324-47000-611 Long Term Debt Interest$159,150.00$193,943.75$81,375.00($34,793.75)121.86% E 324-47000-620 Fiscal Agent s Fees$500.00$475.00$0.00$25.0095.00% E 324-49000-720 Operating Transfers$0.00$945,652.87$0.00($945,652.87)0.00% Total 2024 Street Reconstruction Fund Expenditures$ 339,650$ 1,140,072$ 81,375$ (800,422)335.66% 2025 EQUIPMENT BOND RevenueR 325-47000-31000 Washington Cty. Tax Settlement$38,997.00$0.00$0.00$38,997.000.00% R 325-47000-36210 Interest Income$0.00$0.00$0.00$0.000.00% Total 2025 Equipment Bond Fund Revenue$ 38,997$ -$ -$ 38,9970.00% ExpenditureE 325-47000-601 Long Term Debt Principal$0.00$0.00$0.00$0.000.00% E325-47000-611 Long Term Debt Interest$37,140.00$7,567.47$0.00$29,572.5320.38% Total 2025 Equipment Bond Fund Expenditures$ 37,140$ 7,567$ -$ 29,57320.38% CAPITAL IMPROVEMENTS RevenueR 401-48000-31000 Washington Cty. Tax Settlement$125,000.00$62,500.00$62,500.00$62,500.0050.00% R 401-48000-33422 Other State Grants & Aids$0.00$115,257.20$0.00($115,257.20)0.00% R401-48000-33640 Other Grants$0.00$0.00$0.00$0.000.00% R 401-48000-36210 Interest Income$1,000.00$0.00$0.00$1,000.000.00% Total Capital Improvement Fund Revenue$ 126,000$ 177,757$ 62,500$ (51,757) 141.08% ExpenditureE 401-41000-530 Capital Impr Other Than Bldgs$92,000.00$49,349.34$0.00$42,650.6653.64% E401-42200-520 Capital Improvements to Bldgs$15,500.00$18,905.26$0.00($3,405.26)121.97% E 401-42200-530 Capital Impr Other Than Bldgs$76,041.00$0.00$0.00$76,041.000.00% E401-43000-520 Capital Improvements to Bldgs$15,500.00$56,715.78$0.00($41,215.78)365.91% E401-45180-520 Capital Improvements to Bldgs$0.00$2,681.41$0.00($2,681.41)0.00% E401-48000-303 Engineering Fees$30,000.00$40,939.00$9,709.00($10,939.00)136.46% CITY OF SCANDIA Revenue - Expenditure Summary JULY 2025 2025 YTD % of Description 2025 Budget Amount Month Amount Budget Balance Budget Comments E 401-48000-308 Other Professional Services$0.00$16,287.25$108.75($16,287.25)0.00% 229,041 $ 184,878 $ 9,818 $ 44,163 80.72% PARK DEVELOPMENT RevenueR 404-48000-31000 Washington Cty. Tax Settlement$40,000.00$20,000.00$20,000.00$20,000.0050.00% R 404-48000-33422 Other State Grants & Aids$0.00$0.00$0.00$0.000.00% R 404-48000-34780 Park Dedication Fees$0.00$24,000.00$0.00($24,000.00)0.00% R 404-48000-36210 Interest Income$66.00$0.00$0.00$66.000.00% R404-48000-36230 Donations$0.00$0.00$0.00$0.000.00% R404-48000-39203 Transfer from Other Funds$0.00$0.00$0.00$0.000.00% Total Park Development Fund Revenue$ 40,066$ 44,000$ 20,000$ (3,934)109.82% ExpenditureE 404-48000-303 Engineering Fees$0.00$2,564.60$1,931.50($2,564.60)0.00% E 404-48000-308 Other Professional Services$0.00$0.00$0.00$0.000.00% E 404-48000-312 Planning Services$0.00$0.00$0.00$0.000.00% E404-48000-520 Capital Improvements to Bldgs$0.00$0.00$0.00$0.000.00% E 404-48000-530 Capital Impr Other Than Bldgs$93,000.00$111,436.24$19,900.41($18,436.24)119.82% E 404-48000-720 Operating Transfers$0.00$0.00$0.00$0.000.00% Total Park Development Fund Expenditures$ 93,000$ 114,001$ 21,832$ (21,001) 122.58% EQUIPMENT REPLACEMENT RevenueR 406-48500-31000 Washington Cty. Tax Settlement$125,000.00$62,500.00$62,500.00$62,500.0050.00% R 406-48500-36210 Interest Income$1,061.00$0.00$0.00$1,061.000.00% R 406-48500-36260 Sale of Equipment$0.00$70,250.00$0.00($70,250.00)0.00% R 406-48500-39310 Proceeds-Gen Obligation Bond$0.00$640,000.00$0.00($640,000.00)0.00% Total Equipment Replacement Fund Revenue$ 126,061$ 772,750$ 62,500$ (646,689)613.00% ExpenditureE 406-48500-319 Other Services$0.00$13,250.00$6,500.00($13,250.00)0.00% E406-48500-540 Heavy Machinery Capital$592,296.00$1,085,662.29$133,655.29($493,366.29)183.30% E 406-48500-550 Motor Vehicles Capital$0.00$4,915.97$0.00($4,915.97)0.00% Total Equipment Replacement Fund Expenditures$ 592,296$ 1,103,828$ 140,155$ (511,532)186.36% LOCAL ROAD IMPROVEMENT FUND RevenueR 408-43100-31000 Washington Cty. Tax Settlement$440,000.00$220,000.00$220,000.00$220,000.0050.00% R 408-43100-33422 Other State Grants & Aids$0.00$0.00$0.00$0.000.00% R 408-43100-36100 Special Assessments$0.00$5,119.12$0.00($5,119.12)0.00% R 408-43100-36210 Interest Income$15,795.00$0.00$0.00$15,795.000.00% R408-43100-39203 Transfer from Other Funds$0.00$49,065.00$0.00($49,065.00)0.00% R 408-43100-39310 Proceeds-Gen Obligation Bond$0.00$0.00$0.00$0.000.00% Total LRIF Revenue$ 455,795$ 274,184$ 220,000$ 181,61160.16% ExpenditureE 408-43100-303 Engineering Fees$0.00$31,191.00$6,028.00($31,191.00)0.00% E 408-43100-319 Other Services$0.00$0.00$0.00$0.000.00% E 408-43100-351 Legal Notices Publishing$0.00$0.00$0.00$0.000.00% E 408-43100-530 Capital Impr Other Than Bldgs$665,000.00$250,733.31$152,049.55$414,266.6937.70% E 408-43100-720 Operating Transfers$0.00$3,301.00$0.00($3,301.00)0.00% CITY OF SCANDIA Revenue - Expenditure Summary JULY 2025 2025 YTD % of Description 2025 Budget Amount Month Amount Budget Balance Budget Comments Total LRIF Expenditures$ 665,000 $ 285,225 $ 158,078 $ 379,775 42.89% BLISS SEWERR 602-43210-31951 Special Assessments Principal$ - $ 2,675 $ 2,675 $ (2,675) 0.00% RevenueR 602-43210-31952 SA Penalties & Interest$400.00$321.02$321.02$78.9880.26% R 602-43210-33422 Other State Grants & Aids$0.00$0.00$0.00$0.000.00% R 602-43210-34304 Reimbursement for Services$20,000.00$0.00$0.00$20,000.000.00% R 602-43210-34401 Sewer User Fees$111,400.00$45,033.72$13,224.50$66,366.2840.43% R 602-43210-34402 Sewer Connection Fee$0.00$0.00$0.00$0.000.00% R 602-43210-36100 Special Assessments$0.00$0.00$0.00$0.000.00% R 602-43210-36102 Penalties and Interest$0.00$0.00$0.00$0.000.00% R 602-43210-36210 Interest Income$200.00$0.00$0.00$200.000.00% Total BLISS Sewer Revenue$ 132,000 $ 48,030 $ 16,221 $ 83,970 36.39% ExpenditureE 602-43210-101 Regular Wages & Salaries$19,800.00$10,765.12$2,278.67$9,034.8854.37% E 602-43210-120 Pension Expense$0.00$0.00$0.00$0.000.00% E602-43210-121 PERA Coord. Employer Contribu.$1,500.00$807.34$170.92$692.6653.82% E602-43210-122 FICA Employer Contribution$1,200.00$637.04$136.94$562.9653.09% E602-43210-126 MEDICARE Employer Contribution$300.00$150.55$32.02$149.4550.18% E 602-43210-131 Employer Paid Health$0.00$0.00$0.00$0.000.00% E602-43210-151 Worker sComp Insurance Prem$625.00$0.00$0.00$625.000.00% E 602-43210-200 Office Supplies$100.00$112.00$0.00($12.00)112.00% E 602-43210-210 Operating Supplies$750.00$401.83$2.69$348.1753.58% E 602-43210-240 Small Tools and Minor Equip$500.00$0.00$0.00$500.000.00% E602-43210-303 Engineering Fees$6,000.00$898.50$408.00$5,101.5014.98% E 602-43210-304 Legal Services$0.00$0.00$0.00$0.000.00% E 602-43210-308 Other Professional Services$20,440.00$16,268.00$507.00$4,172.0079.59% E602-43210-309 Software Support & Maintenance$1,000.00$0.00$0.00$1,000.000.00% E 602-43210-317 Employee Training$750.00$2,117.58$0.00($1,367.58)282.34% E 602-43210-321 Telephone$1,750.00$629.78$93.42$1,120.2235.99% E 602-43210-322 Postage$200.00$10.95$0.00$189.055.48% E 602-43210-331 Travel Expenses$500.00$1,100.35$0.00($600.35)220.07% E 602-43210-334 Licenses & Permits$1,250.00$23.49$0.00$1,226.511.88% E 602-43210-361 Liability/Property Ins$2,300.00$2,668.26$0.00($368.26)116.01% E 602-43210-381 Utilities-Electric & Gas$3,000.00$1,003.09$131.24$1,996.9133.44% E602-43210-385 Sewer Pumping & Maintenance$10,000.00$580.00$0.00$9,420.005.80% E 602-43210-386 Operation & Maintenance$2,000.00$0.00$0.00$2,000.000.00% E602-43210-404 Repair Machinery/Equipment$8,000.00$3,410.26$0.00$4,589.7442.63% E 602-43210-413 Equipment Rental$500.00$0.00$0.00$500.000.00% E602-43210-420 Depreciation Expense$40,000.00$0.00$0.00$40,000.000.00% E 602-43210-438 Misc. Contractual$4,000.00$2,150.00$0.00$1,850.0053.75% E 602-43210-439 Refunds Issued$0.00$0.00$0.00$0.000.00% E 602-43210-530 Capital Impr Other Than Bldgs$10,000.00$0.00$0.00$10,000.000.00% E 602-43210-720 Operating Transfers$0.00$0.00$0.00$0.000.00% CITY OF SCANDIA Revenue - Expenditure Summary JULY 2025 2025 YTD % of Description 2025 Budget Amount Month Amount Budget Balance Budget Comments Total BLISS Sewer Expenditures$ 136,465$ 43,734$ 3,761$ 92,73132.05% UPTOWN SEWER RevenueR 612-43210-34401 Sewer User Fees$21,560.00$6,653.66$364.71$14,906.3430.86% R 612-43210-34403 Sewer Base Rate$5,670.00$0.00$0.00$5,670.000.00% R 612-43210-36210 Interest Income$50.00$0.00$0.00$50.000.00% Total Uptown Sewer Revenue$ 27,280$ 6,654$ 365$ 20,62624.39% ExpenditureE 612-43210-101 Regular Wages & Salaries$0.00$1,259.98$24.60($1,259.98)0.00% E 612-43210-120 Pension Expense$0.00$0.00$0.00$0.000.00% E612-43210-121 PERA Coord. Employer Contribu.$0.00$94.39$1.84($94.39)0.00% E612-43210-122 FICA Employer Contribution$0.00$73.44$1.51($73.44)0.00% E612-43210-126 MEDICARE Employer Contribution$0.00$18.05$0.37($18.05)0.00% E612-43210-151 Worker sComp Insurance Prem$522.00$219.00$0.00$303.0041.95% E 612-43210-200 Office Supplies$100.00$0.00$0.00$100.000.00% E 612-43210-210 Operating Supplies$500.00$0.00$0.00$500.000.00% E 612-43210-221 Equipment Parts$500.00$0.00$0.00$500.000.00% E612-43210-303 Engineering Fees$1,000.00$0.00$0.00$1,000.000.00% E 612-43210-308 Other Professional Services$900.00$0.00$0.00$900.000.00% E612-43210-309 Software Support & Maintenance$87.00$0.00$0.00$87.000.00% E 612-43210-317 Employee Training$200.00$0.00$0.00$200.000.00% E 612-43210-319 Other Services$500.00$0.00$0.00$500.000.00% E 612-43210-322 Postage$25.00$0.00$0.00$25.000.00% E 612-43210-334 Licenses & Permits$250.00$238.00$0.00$12.0095.20% E 612-43210-361 Liability/Property Ins$464.00$1,518.27$0.00($1,054.27)327.21% E 612-43210-381 Utilities-Electric & Gas$1,000.00$262.20($0.90)$737.8026.22% E612-43210-385 Sewer Pumping & Maintenance$1,250.00$0.00$0.00$1,250.000.00% E 612-43210-386 Operation & Maintenance$500.00$0.00$0.00$500.000.00% E612-43210-404 Repair Machinery/Equipment$1,000.00$0.00$0.00$1,000.000.00% E612-43210-420 Depreciation Expense$4,900.00$0.00$0.00$4,900.000.00% E 612-43210-438 Misc. Contractual$1,500.00$0.00$0.00$1,500.000.00% E 612-43210-530 Capital Impr Other Than Bldgs$5,000.00$0.00$0.00$5,000.000.00% E 612-43210-720 Operating Transfers$2,640.00$0.00$0.00$2,640.000.00% Total Uptown Sewer Expenditures$ 22,838$ 3,683$ 27$ 19,15516.13% CITY OF SCANDIA Revenue - Expenditure Summary JULY 2025 2025 YTD % of Description 2025 Budget Amount Month Amount Budget Balance Budget Comments A-ESEWER RevenueR 624-43210-31952 SA Penalties & Interest$200.00$0.00$0.00$200.000.00% R 624-43210-34304 Reimbursement for Services$10,000.00$0.00$0.00$10,000.000.00% R 624-43210-34401 Sewer User Fees$40,060.00$17,441.92$5,549.26$22,618.0843.54% R 624-43210-36102 Penalties and Interest$0.00$10.00$10.00($10.00)0.00% R 624-43210-36210 Interest Income$100.00$0.00$0.00$100.000.00% R 624-43210-39200 Interfund Operating Transfer$0.00$0.00$0.00$0.000.00% Total A-E Sewer Revenue$ 50,360 $ 17,452 $ 5,559 $ 32,908 34.65% ExpenditureE 624-43210-101 Regular Wages & Salaries$6,100.00$3,419.52$738.02$2,680.4856.06% E624-43210-121 PERA Coord. Employer Contribu.$500.00$256.65$55.39$243.3551.33% E624-43210-122 FICA Employer Contribution$400.00$202.91$44.40$197.0950.73% E624-43210-126 MEDICARE Employer Contribution$100.00$47.46$10.38$52.5447.46% E 624-43210-131 Employer Paid Health$250.00$0.00$0.00$250.000.00% E624-43210-151 Worker sComp Insurance Prem$50.00$219.00$0.00($169.00)438.00% E 624-43210-200 Office Supplies$250.00$48.00$0.00$202.0019.20% E 624-43210-210 Operating Supplies$150.00$98.02$0.00$51.9865.35% E 624-43210-240 Small Tools and Minor Equip$4,000.00$0.00$0.00$4,000.000.00% E624-43210-303 Engineering Fees$0.00$0.00$0.00$0.000.00% E 624-43210-308 Other Professional Services$1,500.00$0.00$0.00$1,500.000.00% E624-43210-309 Software Support & Maintenance$300.00$0.00$0.00$300.000.00% E 624-43210-317 Employee Training$350.00$0.00$0.00$350.000.00% E 624-43210-321 Telephone$550.00$536.84$89.39$13.1697.61% E 624-43210-322 Postage$100.00$0.00$0.00$100.000.00% E 624-43210-331 Travel Expenses$225.00$0.00$0.00$225.000.00% E 624-43210-334 Licenses & Permits$500.00$238.00$0.00$262.0047.60% E 624-43210-361 Liability/Property Ins$1,000.00$1,164.23$0.00($164.23)116.42% E 624-43210-381 Utilities-Electric & Gas$1,000.00$299.19$42.64$700.8129.92% E624-43210-385 Sewer Pumping & Maintenance$4,000.00$0.00$0.00$4,000.000.00% E 624-43210-386 Operation & Maintenance$1,000.00$0.00$0.00$1,000.000.00% E624-43210-404 Repair Machinery/Equipment$3,000.00$1,530.00$1,530.00$1,470.0051.00% E 624-43210-413 Equipment Rental$300.00$0.00$0.00$300.000.00% E624-43210-420 Depreciation Expense$10,000.00$0.00$0.00$10,000.000.00% E 624-43210-438 Misc. Contractual$3,000.00$0.00$0.00$3,000.000.00% E 624-43210-530 Capital Impr Other Than Bldgs$4,000.00$0.00$0.00$4,000.000.00% Total A-E Sewer Expenditures$ 42,625$ 8,060$ 2,510$ 34,56518.91%