Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
06.b Treasurer's Monthly Report 2023
City of Scandiaaug Treasurer’s Report 7/31/2023 FUND ACCOUNTING Beginning Cash Balance $ 2,890,642.547/1/2023 Beginning Checking Balance$ 105,416.62 Checking Receipts 1,673,952.22 Transfers toChecking 700,000.00 Total Deposits 2,373,952.22 Expenditures$ (1,856,073.10) Payroll$ (44,896.98) Transfer to EDA inTransit Total Payments 1,900,970.08) Ending Checking Balance 578,398.76 Beginnging Money Market Balance 715,346.07 Money Market Receipts 1,509.69 Tranfer to Checking 700,000.00) Tranfer from Checking 1,578,000.00 0 Ending Money Market Balance 1,594,855.76 Beginning Investments Balance 2,064,280.04 Investments Receipts 7,544.19 Ending Investments Balance$ 2,071,824.23 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 505,212.45) 7/31/2023EndingCashBalance $ 3,773,222.37 CHECKING, MONEY MARKET & INVESTMENT CD's Checking *102$ 105,416.62BegBal Credits$ 2,374,285.13 Debits$ (1,901,302.99) Transfer inTransit 578,398.76EndBal Money Market *105 - Rate 1.25%$ 715,346.07BegBal rate change from .25% Credits 1,579,509.69 Debits 700,000.00) End Bal$ 1,594,855.76 Investments CD *4422 - Rate 4.00% 12mo., 3/25/2024 **NEW RATE$ 321,022.05 CD *4424 - Rate 4.50% 12mo., 7/27/2024 **NEW RATE$ 452,464.63 CD *4425 - Rate 2.875% 12 mo., 9/28/2023 $ 750,221.77 CD *4426 - Rate 3.50%% 12mo., 1/29/2024 548,115.78 Total Investments$ 2,071,824.23 Total Bank & Investment Accounts 4,245,078.75 505,212.45) Checks in Transit *3102 Transfer toEDA in Transit Deposit in transit money market 3,739,866.30TotalAdjustedUndesignatedFunds Scandia EDA *6301 $ 33,356.07 Receipts Expenditures Checks inTransit Deposit inTransit Total Designated EDA Funds$ 33,356.07 Total Funds$ 3,773,222.37 Submitted by: Colleen Firkus, Treasurer 2023CASHBALANCES ENDOFMONTH FUNDJANUARYFEBRUARYMARCHAPRILMAYJUNEJULY 101 GENERAL$1,365,932$1,204,052$1,078,538$925,847$839,539$1,564,703539,283.54 203 COVID-19 RELIEF$456,363$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$12,55114,106.51 230 GATEWAY TRAIL$0$0$0$0$0$0$0 307 BLACKTOP PROJECT 2007$6,731$0$0$0$0$0$0 313 EQUIPMENT CERTIFICATES$28,825$28,873$28,873$28,873($32,057)$ (32,056.76) ($57) 315 EQUIPMENT CERTIFICATES$15,951$0$0$0$0$0$0 317 EQUIPMENT CERTIFICATES$2,187$0$0$0$0$0$0 318 BLACKTOP PROJECT$20,270$45,284$45,284($823)($823)$ (823.23)$170,445 401 CAPITAL IMPR$749,162$749,497$745,297$668,380$665,980$ 663,579.71$861,809 404 PARK CAP IMPR$148,177$148,797$148,797$144,297$144,297$ 145,898.33$158,898 406 EQUIPMENT REPLACEMENT$199,727$200,548$200,548$200,548$200,548$ 200,548.37$200,548 408 LOCAL ROAD IMPROVEMENT$916,080$910,085$901,556$895,518$893,593$ 744,491.50$187,297 602 BIG MARINE SEWER$80,462$74,771$75,858$58,322$49,682$ 60,689.30$68,166 612 UPTOWN SEWER$10,330$15,160$13,957$12,136$15,967$ 15,833.56$15,646 801 ESCROW$21,817$32,240$24,131$35,421$37,650$ 32,645.90$43,496 SUBTOTAL$4,033,286$3,878,456$3,728,684$3,436,405$3,284,269$2,840,559$3,739,866 225 EDA$33,356$33,356$33,356$33,356$33,356$ 33,356.07$ 33,356.07 TOTAL$4,066,642$3,911,812$3,762,040$3,469,761$3,317,625$2,873,915$3,773,222 CITYOFSCANDIA Revenue - ExpenditureSummary Jul-23 2023 YTD Description2023 BudgetAmountJuly AmountBudget Balance% of BudgetComments GENERAL FUND RevenueR 101-41000-31000 Washington Cty. Tax Settlement$1,865,918.00$989,520.53$989,520.53$876,397.4753.03% R101-41000-31040 Fiscal Disparities$0.00$86,949.38$86,949.38($86,949.38)0.00% R101-41000-31701 Gravel Taxes$20,000.00$3,329.37$3,329.37$16,670.6316.65% R101-41000-31830 Solar Energy Production Tax$6,000.00$5,873.56$5,873.56$126.4497.89% R101-41000-31900 Penalties & Interest Del Tax$400.00$51.94$51.94$348.0612.99% R 101-41000-32150 ROW Utility Permit$3,000.00$2,550.00$900.00$450.0085.00% R101-41000-32180 Tobacco & Liquor Licenses$10,000.00$75.00$0.00$9,925.000.75% R 101-41000-32190 Other City Permits$3,000.00$1,295.00$125.00$1,705.0043.17% R 101-41000-32210 Building Permits$145,000.00$94,102.58$9,984.22$50,897.4264.90% R 101-41000-32260 Gambling Permits$100.00$30.00$0.00$70.0030.00% R101-41000-33401 LGA/MVHC/AG/PERA Aid$7,000.00$0.00$0.00$7,000.000.00% R101-41000-33420 Fire Relief State PERA$37,000.00$0.00$0.00$37,000.000.00% R101-41000-33422 Other State Grants & Aids$11,000.00$9,052.50$2,155.50$1,947.5082.30%Fire Training grants R 101-41000-33428 PILOT$6,000.00$3,108.39$3,108.39$2,891.6151.81% R 101-41000-33620 Recycling Grant$10,500.00$8,165.00$0.00$2,335.0077.76% R101-41000-33630 Local Govt Grants & Aids$0.00$0.00$0.00$0.000.00% R101-41000-33640 Other Grants$1,200.00$0.00$0.00$1,200.000.00% R101-41000-34103 Zoning and Planning$6,700.00$6,196.00$200.00$504.0092.48% R101-41000-34106 Engineering Fees$500.00$0.00$0.00$500.000.00% R101-41000-34107 Assessment Search Fees$0.00$5.00$0.00($5.00)0.00% R101-41000-34109 Water Usage$100.00$0.00$0.00$100.000.00% R101-41000-34201 Impound Fees$0.00$0.00$0.00$0.000.00% R101-41000-34202 Fire Protection Services$32,300.00$32,300.00$0.00$0.00100.00% R101-41000-34301 Damage Repairs$0.00$0.00$0.00$0.000.00% R101-41000-34303 Dust Control$2,700.00$3,524.46$0.00($824.46)130.54% R101-41000-34304 Reimbursement for Services$3,000.00$900.00$0.00$2,100.0030.00% R101-41000-34305 Other Street Services$0.00$0.00$0.00$0.000.00% R101-41000-34730 Ad Revenue$0.00$900.00$0.00($900.00)0.00% R 101-41000-34750 Facilities Rental$5,500.00$3,909.67$560.00$1,590.3371.08% R101-41000-34760 Cleaning Fees$100.00$0.00$0.00$100.000.00% R101-41000-34790 Recreation Programs$2,100.00$1,488.33$0.00$611.6770.87% R101-41000-35101 Fines & Forfeitures$7,400.00$3,924.94$478.29$3,475.0653.04% distributed among funds at EOYR101-41000-36210 Interest Income$12,100.00$39,395.79$9,060.25($27,295.79)325.59% Veterans Memorial Upkeep $1,090; Lions: Vinterfest R101-41000-36230 Donations$2,000.00$4,191.30$0.00($2,191.30)209.57% Fireworks $2,000; Sister City $250 R101-41000-36240 Insurance Dividend$4,100.00$0.00$0.00$4,100.000.00% R101-41000-36250 Misc. Refund$3,800.00$4.00$4.00$3,796.000.11% Total General Fund Revenue$2,208,518$1,300,842.74$1,112,300.43$907,675.2658.90% Operating TransfersR 101-49000-39203 Transfer from Other Funds$0.00$2,173,000.00$1,578,000.00($2,173,000.00) R101-49000-39204 Money Market Transfer$0.00$355,000.01$0.00($355,000.01) Total Operating Transfers$2,528,000.01$1,578,000.00($2,528,000.01) CITYOFSCANDIA Revenue - ExpenditureSummary Jul-23 2023 YTD Description2023 BudgetAmountJuly AmountBudget Balance% of BudgetComments GENERAL FUND ExpenditureADMINISTRATION & FINANCE E101-41000-101 Regular Wages & Salaries$192,700.00$60,508.10$13,577.20$132,191.9031.40% E101-41000-121 PERA Coord. Employer Contribu.$13,400.00$1,935.32$1,018.29$11,464.6814.44% E101-41000-122 FICA Employer Contribution$11,900.00$2,948.83$810.74$8,951.1724.78% E101-41000-126 MEDICARE Employer Contribution$2,700.00$1,551.11$189.59$1,148.8957.45% E101-41000-131 Employer Paid Health$47,300.00$20,991.57$3,198.32$26,308.4344.38% E101-41000-132 Dental Insurance$3,400.00$730.85$127.90$2,669.1521.50% E 101-41000-134 Employer Paid Life$600.00$312.30$49.60$287.7052.05% E 101-41000-135 Employer Paid Disability$900.00$557.33$71.67$342.6761.93% E101-41000-151 Worker s Comp Insurance Prem$1,300.00$1,651.00$0.00($351.00)127.00% E101-41000-200 Office Supplies$1,100.00$164.85$0.00$935.1514.99% E101-41000-203 Printed Forms & Papers$1,900.00$1,530.05$0.00$369.9580.53% Award frames; March 10 meeting suppliesE101-41000-210 Operating Supplies$800.00$549.18$70.68$250.8268.65% E101-41000-300 Assessor$0.00$0.00$0.00$0.000.00% E101-41000-301 Auditing and Acct gServices$23,500.00$28,500.00$0.00($5,000.00)121.28% E101-41000-303 Engineering Fees$0.00$0.00$0.00$0.000.00% E101-41000-304 Legal Services$55,000.00$31,143.50$3,478.00$23,856.5056.62% E101-41000-306 Personal Testing & Recruit$0.00$0.00$0.00$0.000.00% Intermin City Admin SalaryE101-41000-308 Other Professional Services$1,000.00$50,299.19$0.00($49,299.19)5029.92% E101-41000-309 Software Support & Maintenance$18,200.00$6,068.24$912.21$12,131.7633.34% E101-41000-314 Animal Control$0.00$0.00$0.00$0.000.00% E101-41000-316 Conferences & Seminars$700.00$30.00$30.00$670.004.29% E101-41000-317 Employee Training$200.00$0.00$0.00$200.000.00% E101-41000-319 Other Services$46,700.00$586.00$0.00$46,114.001.25% E101-41000-321 Telephone$3,700.00$2,910.69$471.39$789.3178.67% E 101-41000-322 Postage$2,200.00$1,103.33$0.00$1,096.6750.15% E101-41000-331 Travel Expenses$600.00$1,033.37$0.00($433.37)172.23%reimburse city admin applicant E101-41000-351 Legal Notices Publishing$1,200.00$1,043.31$24.75$156.6986.94% E 101-41000-361 Liability/Property Ins$7,100.00$10,967.38$0.00($3,867.38)154.47% E101-41000-365 Insurance Claims$0.00$1,000.00$0.00($1,000.00)0.00% budget for all depts in Fund 101E101-41000-381 Utilities-Electric & Gas$13,000.00$6,294.01$1,533.71$6,705.9948.42% E101-41000-413 Equipment Rental$1,900.00$1,093.54$331.70$806.4657.55% E 101-41000-430 Recycling$30,100.00$0.00$0.00$30,100.000.00% E101-41000-433 Dues and Subscriptions$6,100.00$157.00$0.00$5,943.002.57% E101-41000-434 Youth Service Bureau$5,500.00$5,500.00$0.00$0.00100.00% E101-41000-435 Misc Expense$500.00$0.00$0.00$500.000.00% Website Host; ABDO accounting assistanceE101-41000-438 Misc. Contractual$4,000.00$3,235.75$0.00$764.2580.89% E101-41000-439 Refunds Issued$0.00$0.00$0.00$0.000.00% E101-41000-560 Furniture and Fixtures$0.00$0.00$0.00$0.000.00% E101-41000-570 Office Equipment$5,500.00$1,585.52$0.00$3,914.4828.83% Total Admin & Finance Dept. Expenditures48.74% 504,700$245,981$25,896$258,719 CITYOFSCANDIA Revenue - ExpenditureSummary Jul-23 2023 YTD Description2023 BudgetAmountJuly AmountBudget Balance% of BudgetComments GENERAL FUND CONT.CITY COUNCIL ExpendituresE 101-41110-101 Regular Wages & Salaries$18,100.00$10,385.96$5,192.98$7,714.0457.38% E101-41110-122 FICA Employer Contribution$1,100.00$176.19$61.52$923.8116.02% E101-41110-126 MEDICARE Employer Contribution$300.00$98.54$75.31$201.4632.85% E101-41110-127 PERA Defined$600.00$377.17$210.02$222.8362.86% E101-41110-151 Worker s Comp Insurance Prem$100.00$95.00$0.00$5.0095.00% E101-41110-308 Other Professional Services$0.00$0.00$0.00$0.000.00% E101-41110-316 Conferences & Seminars$700.00$350.00$0.00$350.0050.00% E101-41110-331 Travel Expenses$0.00$561.97$0.00($561.97)0.00% E101-41110-439 Refunds Issued$0.00$0.00$0.00$0.000.00% E101-41110-560 Furniture and Fixtures$0.00$0.00$0.00$0.000.00% E101-41110-570 Office Equipment$0.00$0.00$0.00$0.000.00% Total City Council Dept. Expenditures$20,900$12,045$5,540$8,85557.63% ELECTIONS ExpendituresE 101-41410-199 Election Judge$0.00$0.00$0.00$0.000.00% E101-41410-200 Office Supplies$0.00$0.00$0.00$0.000.00% E101-41410-203 Printed Forms & Papers$0.00$0.00$0.00$0.000.00% E101-41410-210 Operating Supplies$200.00$0.00$0.00$200.000.00% E101-41410-351 Legal Notices Publishing$0.00$0.00$0.00$0.000.00% E101-41410-413 Equipment Rental$850.00$1,515.00$0.00($665.00)178.24%Wash. Cty. Equip. Maintenance Fee Total Elections Dept. Expenditures$1,050$1,515$0($465)144.29% PLANNING & BUILDING ExpendituresE 101-41910-101 Regular Wages & Salaries$59,600.00$32,370.99$4,258.26$27,229.0154.31% E101-41910-121 PERA Coord. Employer Contribu.$4,200.00$1,793.69$319.38$2,406.3142.71% E101-41910-122 FICA Employer Contribution$3,700.00$1,910.51$250.70$1,789.4951.64% E101-41910-126 MEDICARE Employer Contribution$900.00$469.25$58.64$430.7552.14% E101-41910-131 Employer Paid Health$20,000.00$9,162.49$1,367.18$10,837.5145.81% E101-41910-132 Dental Insurance$1,500.00$365.40$54.81$1,134.6024.36% E 101-41910-134 Employer Paid Life$200.00$88.00$14.40$112.0044.00% E 101-41910-135 Employer Paid Disability$500.00$233.47$34.63$266.5346.69% E101-41910-203 Printed Forms & Papers$600.00$0.00$0.00$600.000.00% E101-41910-311 Contract Permit Inspections$50,000.00$40,399.99$9,338.02$9,600.0180.80% E101-41910-312 Planning Services$50,000.00$33,970.91$2,707.50$16,029.0967.94% E101-41910-313 Committee & Commission Reimbur$5,000.00$1,850.00$0.00$3,150.0037.00% E101-41910-316 Conferences & Seminars$50.00$0.00$0.00$50.000.00% E101-41910-319 Other Services$0.00$123.00$0.00($123.00)0.00% E 101-41910-361 Liability/Property Ins$4,900.00$5,400.60$0.00($500.60)110.22% E101-41910-438 Misc. Contractual$5,000.00$2,660.94$1,472.51$2,339.0653.22% E101-41910-439 Refunds Issued$200.00$0.00$0.00$200.000.00% E101-41910-720 Operating Transfers$0.00$0.00$0.00$0.000.00% Total Planning & Building Dept. Expenditures$206,350$130,799$19,876$75,55163.39% ASSESSOR ExpendituresE 101-41960-300 Assessor$21,600.00$12,958.52$1,800.00$8,641.4859.99% POLICE ExpendituresE 101-42100-318 Police Contract$168,499.00$84,249.53$84,249.53$84,249.4750.00% E101-42100-319 Other Services$500.00$309.36$0.00$190.6461.87%2023 Code Red System Total GF Police Dept. Expenditures$168,999$84,559$84,250$84,44033.33% CITYOFSCANDIA Revenue - ExpenditureSummary Jul-23 2023 YTD Description2023 BudgetAmountJuly AmountBudget Balance% of BudgetComments GENERAL FUND CONT.FIRE ExpendituresE 101-42200-101 Regular Wages & Salaries$147,200.00$77,558.73$12,402.82$69,641.2752.69% E101-42200-121 PERA Coord. Employer Contribu.$0.00$0.00$0.00$0.000.00% E101-42200-122 FICA Employer Contribution$9,100.00$4,568.78$759.36$4,531.2250.21% E 101-42200-124 Police & Fire PERA$3,600.00$5,028.70$633.81($1,428.70)139.69% E101-42200-126 MEDICARE Employer Contribution$2,100.00$894.93$182.76$1,205.0742.62% E 101-42200-134 Employer Paid Life$200.00$112.00$16.00$88.0056.00% E 101-42200-135 Employer Paid Disability$700.00$0.00$0.00$700.000.00% E101-42200-141 Unemployment Compensation$0.00$0.00$0.00$0.000.00% E101-42200-151 Worker s Comp Insurance Prem$9,100.00$11,617.00$0.00($2,517.00)127.66% E101-42200-200 Office Supplies$400.00$174.01$150.22$225.9943.50% E101-42200-203 Printed Forms & Papers$150.00$0.00$0.00$150.000.00% E101-42200-209 Medical Supplies$3,000.00$3,221.83$549.99($221.83)107.39% Pagers $2,730; Fire Suppression supplies $686; Cintas; E101-42200-210 Operating Supplies$8,000.00$4,190.76$249.86$3,809.2452.38% Dinners E101-42200-211 Cleaning Supplies$100.00$0.00$0.00$100.000.00% E 101-42200-212 Fuel$3,500.00$2,796.20$1,103.81$703.8079.89% E101-42200-217 Uniforms & Safety Equipment$10,000.00$4,434.57$1,327.41$5,565.4344.35% E101-42200-221 Equipment Parts$3,000.00$271.56$0.00$2,728.449.05% E 101-42200-222 Tires$0.00$0.00$0.00$0.000.00% E101-42200-223 Structure Repair & Supplies$2,000.00$368.85$0.00$1,631.1518.44% E101-42200-240 Small Tools and Minor Equip$9,000.00$748.58$74.97$8,251.428.32% SCBA User Exams + Annual Fit TestE101-42200-305 Medical Services$3,500.00$4,610.00$0.00($1,110.00)131.71% E101-42200-306 Personal Testing & Recruit$1,300.00$1,391.30$0.00($91.30)107.02% E101-42200-309 Software Support & Maintenance$17,000.00$8,421.12$2,860.56$8,578.8849.54% E101-42200-310 Medical Training$2,000.00$0.00$0.00$2,000.000.00% E101-42200-316 Conferences & Seminars$250.00$0.00$0.00$250.000.00% E101-42200-317 Employee Training$15,000.00$4,423.76$1,977.00$10,576.2429.49% E101-42200-319 Other Services$500.00$0.00$0.00$500.000.00% E101-42200-321 Telephone$6,800.00$3,404.25$835.44$3,395.7550.06% E 101-42200-322 Postage$0.00$0.00$0.00$0.000.00% E101-42200-324 State of MN-Fire Relief$35,300.00$0.00$0.00$35,300.000.00% E101-42200-325 City Match-Fire Relief$0.00$0.00$0.00$0.000.00% E101-42200-331 Travel Expenses$1,500.00$1,693.39$0.00($193.39)112.89% E101-42200-334 Licenses & Permits$200.00$300.00$0.00($100.00)150.00% MN Board of Firefighter Training & Education License E101-42200-340 Advertising$0.00$0.00$0.00$0.000.00% E 101-42200-361 Liability/Property Ins$6,500.00$6,989.37$0.00($489.37)107.53% E101-42200-381 Utilities-Electric & Gas$8,000.00$4,871.75($206.27)$3,128.2560.90% E101-42200-384 Refuse/Garbage Disposal$1,100.00$569.88$97.94$530.1251.81% E101-42200-385 Sewer Pumping & Maintenance$700.00$0.00$0.00$700.000.00% E101-42200-401 Building Maintenance/Repairs$2,500.00$1,890.81$150.00$609.1975.63%Cleaning, Pest Control, Glass door repair E101-42200-403 Improvements Other Than Bldgs$0.00$0.00$0.00$0.000.00% E101-42200-404 Repair Machinery/Equipment$8,000.00$4,855.21$728.19$3,144.7960.69% E101-42200-407 Well Repair & Maintenance$0.00$0.00$0.00$0.000.00% E101-42200-433 Dues and Subscriptions$2,400.00$3,214.90$0.00($814.90)133.95%Truck inspection renewal $1,685 E101-42200-438 Misc. Contractual$4,100.00$1,080.00$1,080.00$3,020.0026.34% E101-42200-440 Events$800.00$0.00$0.00$800.000.00% E101-42200-520 Capital Improvements to Bldgs$0.00$0.00$0.00$0.000.00% E101-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% E101-42200-560 Furniture and Fixtures$500.00$235.90$0.00$264.1047.18% E101-42200-570 Office Equipment$900.00$179.98$0.00$720.0220.00% Total Fire Dept Expenditures$330,000$164,118$24,974$165,88249.73% ANIMAL CONTROL ExpendituresE 101-42700-314 Animal Control$5,000$3,059.54$566.88$1,940.4661.19% CITYOFSCANDIA Revenue - ExpenditureSummary Jul-23 2023 YTD Description2023 BudgetAmountJuly AmountBudget Balance% of BudgetComments GENERAL FUND CONT.PUBLIC WORKS ExpendituresE 101-43000-101 Regular Wages & Salaries$229,700.00$119,866.08$15,961.15$109,833.9252.18% E101-43000-102 OT Regular Wages$5,000.00$4,610.96$0.00$389.0492.22% E101-43000-104 Temporary Employee Wages$2,300.00$4,162.73$0.00($1,862.73)180.99%snowplowing E101-43000-121 PERA Coord. Employer Contribu.$17,600.00$9,305.62$1,181.58$8,294.3852.87% E101-43000-122 FICA Employer Contribution$14,600.00$7,333.19$943.49$7,266.8150.23% E101-43000-126 MEDICARE Employer Contribution$3,400.00$1,912.87$220.65$1,487.1356.26% E101-43000-131 Employer Paid Health$70,900.00$37,216.51$3,849.23$33,683.4952.49% E101-43000-132 Dental Insurance$2,300.00$705.21$88.15$1,594.7930.66% E 101-43000-134 Employer Paid Life$700.00$414.00$45.92$286.0059.14% E 101-43000-135 Employer Paid Disability$1,700.00$1,089.45$101.77$610.5564.09% E101-43000-141 Unemployment Compensation$0.00$0.00$0.00$0.000.00% E101-43000-151 Worker s Comp Insurance Prem$19,800.00$25,976.50$303.50($6,176.50)131.19% E101-43000-200 Office Supplies$600.00$53.99$0.00$546.019.00% E101-43000-210 Operating Supplies$8,400.00$4,903.53$1,383.35$3,496.4758.38% E 101-43000-212 Fuel$20,000.00$16,908.11$1,916.09$3,091.8984.54% E101-43000-217 Uniforms & Safety Equipment$2,200.00$1,013.88$202.47$1,186.1246.09% plow repair partsE101-43000-221 Equipment Parts$14,000.00$11,459.66$107.13$2,540.3481.85% E 101-43000-222 Tires$7,500.00$0.00$0.00$7,500.000.00% E101-43000-223 Structure Repair & Supplies$2,200.00$0.00$0.00$2,200.000.00% E101-43000-224 Materials for Road Maintenance$16,500.00$2,738.18$75.46$13,761.8216.60% E101-43000-226 Sign Replacement and Repair$0.00$173.83$0.00($173.83)0.00% E101-43000-228 Gravel$10,000.00$6,862.87$0.00$3,137.1368.63% snow, snow & snowE101-43000-229 Salt$20,000.00$18,093.42$0.00$1,906.5890.47% E101-43000-240 Small Tools and Minor Equip$8,000.00$3,770.62$0.00$4,229.3847.13% E 101-43000-302 Surveying$0.00$0.00$0.00$0.000.00% E101-43000-303 Engineering Fees$10,000.00$9,799.00$1,918.50$201.0097.99%Gen. Eng. & Crack filling & seal coat fees E101-43000-304 Legal Services$0.00$0.00$0.00$0.000.00% E101-43000-305 Medical Services$1,200.00$99.90$0.00$1,100.108.33% IWORQ subscription; GIS map updatesE101-43000-309 Software Support & Maintenance$2,000.00$7,784.00$0.00($5,784.00)389.20% E101-43000-317 Employee Training$1,700.00$1,010.00$0.00$690.0059.41% E101-43000-319 Other Services$13,600.00$3,930.55$20.25$9,669.4528.90% E101-43000-321 Telephone$3,000.00$2,334.62$351.30$665.3877.82% E101-43000-331 Travel Expenses$500.00$0.00$0.00$500.000.00% E101-43000-334 Licenses & Permits$500.00$0.00$0.00$500.000.00% E 101-43000-361 Liability/Property Ins$9,000.00$8,348.14$0.00$651.8692.76% E101-43000-365 Insurance Claims$0.00$0.00$0.00$0.000.00% E101-43000-381 Utilities-Electric & Gas$4,000.00$3,433.75($117.08)$566.2585.84% E101-43000-384 Refuse/Garbage Disposal$1,000.00$439.95$65.29$560.0544.00% E101-43000-385 Sewer Pumping & Maintenance$1,600.00$0.00$0.00$1,600.000.00% E 101-43000-387 Street Light Utilities$4,200.00$2,480.52$152.49$1,719.4859.06% E101-43000-401 Building Maintenance/Repairs$8,000.00$1,933.27$195.44$6,066.7324.17% E101-43000-403 Improvements Other Than Bldgs$0.00$0.00$0.00$0.000.00% plow truck repairsE101-43000-404 Repair Machinery/Equipment$15,500.00$15,643.22$0.00($143.22)100.92% Streetlightrepair $3,422; Patching $10,488, DustControl E101-43000-405 Contractual Road Maint/Repair$157,500.00$91,065.08($95,599.37)$66,434.9257.82% 21,900; CrackFill & SealCoat $150,824movedtoLRIF E101-43000-407 Well Repair & Maintenance$0.00$0.00$0.00$0.000.00% E101-43000-413 Equipment Rental$4,000.00$0.00$0.00$4,000.000.00% E101-43000-417 Uniform Rental$1,100.00$512.08$82.60$587.9246.55% E101-43000-433 Dues and Subscriptions$200.00$0.00$0.00$200.000.00% E101-43000-438 Misc. Contractual$15,750.00$1,800.00$0.00$13,950.0011.43% E101-43000-439 Refunds Issued$0.00$0.00$0.00$0.000.00% E101-43000-530 Capital Impr Other Than Bldgs$0.00$0.00$0.00$0.000.00% E101-43000-550 Motor Vehicles Capital$0.00$0.00$0.00$0.000.00% E101-43000-560 Furniture and Fixtures$0.00$0.00$0.00$0.000.00% E101-43000-570 Office Equipment$1,000.00$406.53$0.00$593.4740.65% E101-43000-720 Operating Transfers$0.00$0.00$0.00$0.000.00% Total Public Works Dept. Expenditures$732,750$429,592($66,551)$303,15858.63% CITYOFSCANDIA Revenue - ExpenditureSummary Jul-23 2023 YTD Description2023 BudgetAmountJuly AmountBudget Balance% of BudgetComments GENERAL FUND CONT.PARKS & RECREATION ExpendituresE 101-45000-101 Regular Wages & Salaries$10,200.00$4,048.36$695.48$6,151.6439.69% E101-45000-104 Temporary Employee Wages$40,200.00$13,987.76$4,778.25$26,212.2434.80% E101-45000-121 PERA Coord. Employer Contribu.$800.00$300.53$51.48$499.4737.57% E101-45000-122 FICA Employer Contribution$3,300.00$1,081.32$337.38$2,218.6832.77% E101-45000-126 MEDICARE Employer Contribution$800.00$280.27$78.88$519.7335.03% E101-45000-131 Employer Paid Health$2,700.00$1,261.00$145.69$1,439.0046.70% E101-45000-132 Dental Insurance$100.00$25.60$3.20$74.4025.60% E 101-45000-134 Employer Paid Life$0.00$15.40$1.68($15.40)0.00% E 101-45000-135 Employer Paid Disability$1,000.00$36.27$3.96$963.733.63% E101-45000-141 Unemployment Compensation$0.00$0.00$0.00$0.000.00% E101-45000-151 Worker s Comp Insurance Prem$1,900.00$2,614.50$303.50($714.50)137.61% E101-45000-200 Office Supplies$310.00$0.00$0.00$310.000.00% E101-45000-203 Printed Forms & Papers$930.00$0.00$0.00$930.000.00% E101-45000-210 Operating Supplies$930.00$579.28$66.33$350.7262.29% E 101-45000-212 Fuel$1,650.00$229.92$0.00$1,420.0813.93% E101-45000-221 Equipment Parts$2,100.00$290.38$0.00$1,809.6213.83% E101-45000-223 Structure Repair & Supplies$2,100.00$1,091.50$1,091.50$1,008.5051.98% E101-45000-240 Small Tools and Minor Equip$400.00$0.00$0.00$400.000.00% E101-45000-312 Planning Services$0.00$0.00$0.00$0.000.00% E101-45000-313 Committee & Commission Reimbur$1,200.00$540.00$0.00$660.0045.00% E101-45000-319 Other Services$0.00$284.00$0.00($284.00)0.00% E 101-45000-322 Postage$0.00$0.00$0.00$0.000.00% SCVRTA 2023 AdE101-45000-340 Advertising$200.00$250.00$0.00($50.00)125.00% E101-45000-353 Sales& Use Tax$0.00$0.00$0.00$0.000.00% E 101-45000-361 Liability/Property Ins$3,300.00$3,323.03$0.00($23.03)100.70% E101-45000-381 Utilities-Electric & Gas$4,500.00$3,012.84$324.58$1,487.1666.95% E101-45000-384 Refuse/Garbage Disposal$2,500.00$2,000.12$598.47$499.8880.00% E101-45000-385 Sewer Pumping & Maintenance$700.00$712.44$147.71($12.44)101.78%Warming House ice melt productE101-45000-401 Building Maintenance/Repairs$4,800.00$3,432.91$120.00$1,367.0971.52% E101-45000-403 Improvements Other Than Bldgs$0.00$170.49$0.00($170.49)0.00% E101-45000-404 Repair Machinery/Equipment$750.00$280.58$280.58$469.4237.41% E101-45000-406 Grounds Care$4,000.00$2,144.22$1,655.34$1,855.7853.61% E101-45000-438 Misc. Contractual$3,300.00$1,440.00$0.00$1,860.0043.64% E101-45000-439 Refunds Issued$0.00$565.01$0.00($565.01)0.00% VinterfestE101-45000-440 Events$7,000.00$2,393.99$0.00$4,606.0134.20% E101-45000-490 Financial Assistance$0.00$0.00$0.00$0.000.00% E101-45000-530 Capital Impr Other Than Bldgs$10,000.00$0.00$0.00$10,000.000.00% E101-45000-720 Operating Transfers$0.00$0.00$0.00$0.000.00% Total Parks & Rec Dept. Expenditures$111,670$46,392$10,684$65,27841.54% CITYOFSCANDIA Revenue - ExpenditureSummary Jul-23 2023 YTD Description2023 BudgetAmountJuly AmountBudget Balance% of BudgetComments GENERAL FUND CONT.COMMUNITY CENTER ExpendituresE 101-45180-101 Regular Wages & Salaries$15,000.00$7,703.64$964.03$7,296.3651.36% E101-45180-104 Temporary Employee Wages$0.00$0.00$0.00$0.000.00% E101-45180-121 PERA Coord. Employer Contribu.$1,100.00$566.42$70.86$533.5851.49% E101-45180-122 FICA Employer Contribution$900.00$446.81$57.12$453.1949.65% E101-45180-126 MEDICARE Employer Contribution$200.00$114.00$13.39$86.0057.00% E101-45180-131 Employer Paid Health$3,700.00$1,605.30$170.40$2,094.7043.39% E 101-45180-134 Employer Paid Life$0.00$24.60$2.40($24.60)0.00% E 101-45180-135 Employer Paid Disability$200.00$71.88$7.37$128.1235.94% E101-45180-151 Worker s Comp Insurance Prem$0.00$0.00$0.00$0.000.00% E101-45180-210 Operating Supplies$2,900.00$1,737.26$741.91$1,162.7459.91% E101-45180-223 Structure Repair & Supplies$6,500.00$74.31$0.00$6,425.691.14% E101-45180-334 Licenses & Permits$1,000.00$792.00$0.00$208.0079.20% E 101-45180-361 Liability/Property Ins$800.00$795.60$0.00$4.4099.45% E101-45180-381 Utilities-Electric & Gas$11,200.00$6,014.25$162.15$5,185.7553.70% E101-45180-384 Refuse/Garbage Disposal$1,900.00$1,321.85$255.30$578.1569.57% E101-45180-385 Sewer Pumping & Maintenance$3,700.00$2,377.93$550.22$1,322.0764.27% Remove ice from Comm Ctr roofE101-45180-401 Building Maintenance/Repairs$15,000.00$10,241.66$609.57$4,758.3468.28% E101-45180-404 Repair Machinery/Equipment$5,000.00$1,148.90$850.90$3,851.1022.98% E101-45180-406 Grounds Care$690.00$0.00$0.00$690.000.00% E101-45180-407 Well Repair & Maintenance$1,000.00$0.00$0.00$1,000.000.00% Helke's winter lighting workE101-45180-438 Misc. Contractual$2,700.00$1,500.00$0.00$1,200.0055.56% E101-45180-439 Refunds Issued$0.00$450.00$0.00($450.00)0.00% Council Chambers remodelE101-45180-520 Capital Improvements to Bldgs$6,000.00$7,475.61$0.00($1,475.61)124.59% E101-45180-530 Capital Impr Other Than Bldgs$0.00$0.00$0.00$0.000.00% E101-45180-570 Office Equipment$0.00$0.00$0.00$0.000.00% E101-45180-720 Operating Transfers$0.00$0.00$0.00$0.000.00% Total Community Center Dept. Expenditures$79,490$44,462$4,456$35,02855.93% TOTAL GENERAL FUND EXPENDITURES$2,182,509$1,175,481$111,491$1,007,02853.86% E101-49000-421 Cash Over/Short$0.00$50.00$0.00($50.00)0.00% Operating TransfersE 101-49000-720 Operating Transfers$0.00$2,528,000.01$1,578,000.00($2,528,000.01)0.00% TOTAL GENERAL FUND EXPENDITURES W/TRANSFERS$2,182,509.00$3,703,531.03$1,689,490.88($1,521,022.03)$0.54 CITYOFSCANDIA Revenue - ExpenditureSummary Jul-23 2023 YTD Description2023 BudgetAmountJuly 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.00$2,650.00$2,650.00$2,650.0050.00% R225-46500-33640 Other Grants$0.00$0.00$0.00$0.000.00% R 225-46500-34750 Facilities Rental$0.00$0.00$0.00$0.000.00% R225-46500-36210 Interest Income$200.00$0.00$0.00$200.000.00% R225-46500-36230 Donations$0.00$0.00$0.00$0.000.00% R225-46500-39203 Transfer from Other Funds$0.00$3,524.94$0.00($3,524.94)0.00% transfer of property tax settlement from checking Total EDA Fund Revenue$5,500.00$6,174.94$2,650.00($674.94)112.27% ExpenditureE 225-46500-210 Operating Supplies$500.00$3,524.94$0.00($3,024.94)704.99% E225-46500-303 Engineering Fees$0.00$0.00$0.00$0.000.00% E225-46500-304 Legal Services$0.00$0.00$0.00$0.000.00% E225-46500-308 Other Professional Services$300.00$0.00$0.00$300.000.00% E225-46500-340 Advertising$2,000.00$645.00$0.00$1,355.0032.25% EDAM Membership; Sister City DuesE225-46500-433 Dues and Subscriptions$1,700.00$1,168.00$0.00$532.0068.71% E225-46500-440 Events$800.00$580.00$0.00$220.0072.50% E225-46500-720 Operating Transfers$0.00$0.00$0.00$0.000.00% Total EDA Fund Expenditures$5,300.00$2,393.00$0.00($617.94)45.15% CABLE TV FUND RevenueR 226-41950-36210 Interest Income$100.00$0.00$0.00$100.000.00% R226-41950-36260 Sale of Equipment$0.00$300.00$0.00($300.00)0.00% R226-41950-38050 Cable TV Franchise Rebates$16,200.00$10,080.76$1,714.32$6,119.2462.23% R 226-41950-38051 PEG Fees$4,200.00$2,700.51$458.48$1,499.4964.30% Total Cable TV Fund Revenue$20,500.00$13,081.27$2,172.80$7,418.7363.81% ExpenditureE 226-41950-240 Small Tools and Minor Equip$300.00$593.48$0.00($293.48)197.83% E226-41950-309 Software Support & Maintenance$3,500.00$2,197.85$1,730.00$1,302.1562.80% E226-41950-438 Misc. Contractual$5,300.00$4,989.00$1,999.00$311.0094.13% E226-41950-570 Office Equipment$0.00$4,128.98$0.00($4,128.98)0.00% Total Cable TV Fund Expenditures$9,100.00$11,909.31$3,729.00($2,809.31)130.87% 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$32,000.00$32,000.00$32,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 s Fees$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$171,268.00$171,268.00$171,278.0050.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 s Fees$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% CITYOFSCANDIA Revenue - ExpenditureSummary Jul-23 2023 YTD Description2023 BudgetAmountJuly AmountBudget Balance% of BudgetComments CAPITAL IMPROVEMENTS RevenueR 401-48000-31000 Washington Cty. Tax Settlement$293,791.00$146,895.00$146,895.00$146,896.0050.00% R401-48000-33422 Other State Grants & Aids$0.00$56,231.78$56,231.78($56,231.78)0.00% R401-48000-36210 Interest Income$2,300.00$0.00$0.00$2,300.000.00% Total Capital Improvement Fund Revenue$296,091.00$203,126.78$203,126.78$92,964.2268.60% ExpenditureE 401-41000-312 Planning Services$0.00$0.00$0.00$0.000.00% E401-41000-520 Capital Improvements to Bldgs$0.00$0.00$0.00$0.000.00% E401-41000-530 Capital Impr Other Than Bldgs$169,500.00$0.00$0.00$169,500.000.00% E401-42200-520 Capital Improvements to Bldgs$65,000.00$73,775.00$0.00($8,775.00)113.50%Generator E401-48000-303 Engineering Fees$0.00$5,040.00$2,497.50($5,040.00)0.00%Gateway Trail Engineering E401-48000-308 Other Professional Services$0.00$16,800.00$2,400.00($16,800.00)0.00%Gateway Trail Lobbying E401-48000-312 Planning Services$0.00$0.00$0.00$0.000.00% E401-48000-435 Misc Expense$0.00$0.00$0.00$0.000.00% E401-48000-438 Misc. Contractual$0.00$0.00$0.00$0.000.00% E401-48000-520 Capital Improvements to Bldgs$0.00$0.00$0.00$0.000.00% E401-48000-530 Capital Impr Other Than Bldgs$100,000.00$0.00$0.00$100,000.000.00% Total Capital Improvement Fund Expenditures$334,500.00$95,615.00$4,897.50$238,885.0028.58% PARK DEVELOPMENT RevenueR 404-48000-31000 Washington Cty. Tax Settlement$20,000.00$10,000.00$10,000.00$10,000.0050.00% R404-48000-33422 Other State Grants & Aids$0.00$0.00$0.00$0.000.00% R404-48000-34780 Park Dedication Fees$21,000.00$3,000.00$3,000.00$18,000.0014.29% R404-48000-36210 Interest Income$66.00$0.00$0.00$66.000.00% Lions Playground donation; Bench donationR404-48000-36230 Donations$0.00$11,601.15$0.00($11,601.15)0.00% Total Park Development Fund Revenue$41,066.00$24,601.15$13,000.00$16,464.8559.91% ExpenditureE 404-48000-312 Planning Services$0.00$4,500.00$0.00($4,500.00)0.00% E404-48000-520 Capital Improvements to Bldgs$17,306.00$0.00$0.00$17,306.000.00% E404-48000-720 Operating Transfers$0.00$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.00$0.00$0.00$0.000.00% R406-48500-36210 Interest Income$1,030.00$0.00$0.00$1,030.000.00% R406-48500-36260 Sale of Equipment$35,000.00$0.00$0.00$35,000.000.00% R406-48500-39350 Certificate of Indebtedness$819,500.00$0.00$0.00$819,500.000.00% Total Equipment Replacement Fund Revenue$855,530.00$0.00$0.00$855,530.000.00% ExpenditureE 406-48500-540 Heavy Machinery Capital$325,000.00$0.00$0.00$325,000.000.00% E406-48500-550 Motor Vehicles Capital$189,500.00$0.00$0.00$189,500.000.00% Total Equipment Replacement Fund Expenditures$514,500.00$0.00$0.00$514,500.000.00% LOCAL ROAD IMPROVEMENT FUND RevenueR 408-43100-31000 Washington Cty. Tax Settlement$212,012.00$106,006.00$106,006.00$106,006.0050.00% R408-43100-33422 Other State Grants & Aids$0.00$0.00$0.00$0.000.00% R408-43100-36210 Interest Income$12,115.00$0.00$0.00$12,115.000.00% R408-43100-39310 Proceeds-Gen Obligation Bond$0.00$0.00$0.00$0.000.00% Total LRIF Revenue$224,127.00$106,006.00$106,006.00$118,121.0047.30% ExpenditureE 408-43100-303 Engineering Fees$20,000.00$34,084.50$13,210.00($14,084.50)170.42% E408-43100-530 Capital Impr Other Than Bldgs$973,000.00$794,959.09$649,990.10$178,040.9181.70% Total LRIF Expenditures$993,000.00$829,043.59$663,200.10$163,956.4183.49% CITYOFSCANDIA Revenue - ExpenditureSummary Jul-23 2023 YTD Description2023 BudgetAmountJuly AmountBudget Balance% of BudgetComments BIG MARINE SEWER RevenueR 602-43210-31951 Special Assessments Principal$0.00$2,065.94$2,065.94($2,065.94)0.00% R602-43210-31952 SA Penalties & Interest$0.00$257.92$247.92($257.92)0.00% R602-43210-33422 Other State Grants & Aids$0.00$0.00$0.00$0.000.00% R602-43210-34401 Sewer User Fees$140,700.00$59,997.80$9,888.64$80,702.2042.64% R602-43210-34402 Sewer Connection Fee$0.00$8,000.00$0.00($8,000.00)0.00% R602-43210-36100 Special Assessments$600.00$0.00$0.00$600.000.00% R602-43210-36102 Penalties and Interest$0.00$29.96$0.00($29.96)0.00% R602-43210-36210 Interest Income$400.00$0.00$0.00$400.000.00% Total Big Marine Sewer Revenue$141,700.00$70,351.62$12,202.50$71,348.3849.65% ExpenditureE 602-43210-101 Regular Wages & Salaries$22,500.00$11,685.53$1,584.10$10,814.4751.94% E602-43210-102 OT Regular Wages$0.00$0.00$0.00$0.000.00% E602-43210-120 Pension Expense$0.00$0.00$0.00$0.000.00% E602-43210-121 PERA Coord. Employer Contribu.$17,000.00$874.18$117.76$16,125.825.14% E602-43210-122 FICA Employer Contribution$1,400.00$676.79$93.49$723.2148.34% E602-43210-126 MEDICARE Employer Contribution$300.00$172.78$21.86$127.2257.59% E602-43210-131 Employer Paid Health$0.00$0.00$0.00$0.000.00% E602-43210-151 Worker s Comp Insurance Prem$700.00$736.40$0.00($36.40)105.20% E602-43210-200 Office Supplies$200.00$0.00$0.00$200.000.00% E602-43210-210 Operating Supplies$2,500.00$57.13$6.99$2,442.872.29% E602-43210-240 Small Tools and Minor Equip$600.00$0.00$0.00$600.000.00% Bliss Collector Permit RenewalE602-43210-303 Engineering Fees$10,500.00$42,361.50$4,839.50($31,861.50)403.44% E602-43210-304 Legal Services$0.00$18.00$0.00($18.00)0.00% E602-43210-308 Other Professional Services$2,500.00$2,491.00$396.00$9.0099.64%Pace Analytical monthly testing E602-43210-309 Software Support & Maintenance$1,300.00$0.00$0.00$1,300.000.00% E602-43210-317 Employee Training$1,400.00$0.00$0.00$1,400.000.00% E602-43210-321 Telephone$2,400.00$1,649.36$241.37$750.6468.72% E 602-43210-322 Postage$600.00$0.00$0.00$600.000.00% E602-43210-331 Travel Expenses$200.00$632.55$0.00($432.55)316.28% E602-43210-334 Licenses & Permits$1,600.00$729.00$0.00$871.0045.56% E 602-43210-361 Liability/Property Ins$3,000.00$3,449.06$0.00($449.06)114.97% E602-43210-381 Utilities-Electric & Gas$2,500.00$15.70($2,575.57)$2,484.300.63%Connexus & Excel E602-43210-385 Sewer Pumping & Maintenance$15,000.00$0.00$0.00$15,000.000.00% E602-43210-386 Operation & Maintenance$5,000.00$2,139.00$0.00$2,861.0042.78% E602-43210-404 Repair Machinery/Equipment$16,000.00$12,100.90$0.00$3,899.1075.63%Lift Station #2pump replacement E602-43210-413 Equipment Rental$400.00$0.00$0.00$400.000.00% E602-43210-420 Depreciation Expense$54,300.00$0.00$0.00$54,300.000.00% E602-43210-438 Misc. Contractual$10,000.00$0.00$0.00$10,000.000.00% E602-43210-439 Refunds Issued$0.00$0.00$0.00$0.000.00% E602-43210-530 Capital Impr Other Than Bldgs$9,800.00$0.00$0.00$9,800.000.00% Total Big Marine Sewer Expenditures$181,700.00$79,788.88$4,725.50$101,911.1243.91% CITYOFSCANDIA Revenue - ExpenditureSummary Jul-23 2023 YTD Description2023 BudgetAmountJuly AmountBudget Balance% of BudgetComments UPTOWN SEWER RevenueR 612-43210-34401 Sewer User Fees$22,300.00$6,191.79$575.83$16,108.2127.77% R612-43210-36210 Interest Income$200.00$0.00$0.00$200.000.00% Total Uptown Sewer Revenue$22,500.00$6,191.79$575.83$16,308.2127.52% ExpenditureE 612-43210-101 Regular Wages & Salaries$9,700.00$4,977.79$666.31$4,722.2151.32% E612-43210-102 OT Regular Wages$0.00$0.00$0.00$0.000.00% E612-43210-120 Pension Expense$0.00$0.00$0.00$0.000.00% E612-43210-121 PERA Coord. Employer Contribu.$700.00$372.55$49.42$327.4553.22% E612-43210-122 FICA Employer Contribution$600.00$288.37$39.37$311.6348.06% E612-43210-126 MEDICARE Employer Contribution$100.00$73.48$9.19$26.5273.48% E612-43210-131 Employer Paid Health$0.00$0.00$0.00$0.000.00% E612-43210-151 Worker s Comp Insurance Prem$200.00$315.60$0.00($115.60)157.80% E612-43210-200 Office Supplies$100.00$0.00$0.00$100.000.00% E612-43210-210 Operating Supplies$300.00$0.00$0.00$300.000.00% E612-43210-221 Equipment Parts$300.00$0.00$0.00$300.000.00% E612-43210-303 Engineering Fees$1,000.00$0.00$0.00$1,000.000.00% E612-43210-304 Legal Services$0.00$0.00$0.00$0.000.00% E612-43210-308 Other Professional Services$500.00$733.00$0.00($233.00)146.60%58% increase in testing costs E612-43210-309 Software Support & Maintenance$0.00$0.00$0.00$0.000.00% E612-43210-317 Employee Training$350.00$0.00$0.00$350.000.00% E612-43210-319 Other Services$0.00$0.00$0.00$0.000.00% E 612-43210-322 Postage$0.00$0.00$0.00$0.000.00% E612-43210-334 Licenses & Permits$400.00$224.00$0.00$176.0056.00% E 612-43210-361 Liability/Property Ins$400.00$477.82$0.00($77.82)119.46% E612-43210-381 Utilities-Electric & Gas$1,700.00$542.04($1.39)$1,157.9631.88% E612-43210-385 Sewer Pumping & Maintenance$1,500.00$0.00$0.00$1,500.000.00% E612-43210-386 Operation & Maintenance$700.00$0.00$0.00$700.000.00% E612-43210-404 Repair Machinery/Equipment$2,000.00$0.00$0.00$2,000.000.00% E612-43210-420 Depreciation Expense$5,100.00$0.00$0.00$5,100.000.00% E612-43210-438 Misc. Contractual$1,300.00$0.00$0.00$1,300.000.00% E612-43210-530 Capital Impr Other Than Bldgs$4,500.00$0.00$0.00$4,500.000.00% Total Uptown Sewer Expenditures$31,450.00$8,004.65$762.90$23,445.3525.45%