Loading...
06.b Treasurer's Monthly Report 2024City ofScandiaaug Treasurer’sReport September 30, 2024 FUND ACCOUNTING Beginning Cash Balance $ 4,722,740.459/1/2024 Beginning Checking Balance$ 276,061.71 Checking Receipts 53,844.50 Transfers to Checking 321,480.03 Total Deposits 375,324.53 Expenditures 418,048.59) CASH BALANCES6/30/2024 Payroll$ (46,088.74) Transfers to Money Market G 101-10100GENERAL FUND$ 1,571,152.98 Total Payments 464,137.33) G 203-10100COVID-19 RELIEF$466,422.00 G 225-10100EDA$39,970.23 Ending Checking Balance 187,248.91G 226-10100CABLE TV$ 28,460.24 G 230-10100GATEWAY TRAIL$ - Beginning Money Market Balance 1,180,601.90 G 240-10100PUBLIC SAFETY AID$ 176,529.00 Money Market Receipts 1,039.62G 313-101002013 EQUIP CERT$ 31,943.24 Transfer to Checking 100,000.00) G 318-101002018 EQUIP CERT$ 192,075.68 Transfer from Checking G 324-101002024 ROAD PROJECTS$ (177,294.12) G 401-10100CAPITAL IMPROVEMENT$ 731,821.59 Ending Money Market Balance 1,081,641.52G 404-10100PARK DEVELOPMENT$ 217,004.75 G 406-10100EQUIPMENT REPLACE$ (233,112.32) Beginning Investments Balance 3,273,614.37 G 408-10100LRIF$ 1,211,710.61 Investments Receipts-Interest 18,261.00G 602-10100BLISS SEWER$ 919.58 Transfer from Checking G 612-10100UPTOWN SEWER$ 22,035.31 221,480.03) G 624-10100A-E SEWER$ 33,308.40TransferstoChecking Ending Investments Balance$ 3,070,395.34G 801-10100ESCROW$ 18,092.95 4,331,040.12 Outstanding Checks$ (8,245.65) 9/30/2024EndingCashBalance $ 4,331,040.12 G602-10425Bliss Accounts Receivable$ 37,432.04 G624-10425A-EAccounts Receivable$ 12,616.74 G 612-10425Uptown Accounts Receivable$ 8,219.89 CHECKING, MONEY MARKET & INVESTMENT CD's Checking *102$ 276,061.71BegBal Credits$ 375,324.53 Debits$ (464,137.33) Receipt in Transit 187,248.91EndBal Money Market *105 - Rate 1.25%$ 1,180,601.90BegBal rate change from .25% Credits 1,039.62 Debits 100,000.00) End Bal$ 1,081,641.52 Investments CD *4422 - Rate 5.10% 12 mo., 3/25/2025$ 339,230.35 CD *4424 - Rate 5.00% 12 mo., 7/27/2025$ 473,174.27 CD *4428 - Rate 5.10% 7 mo., 05/01/25 $ 794,944.50 CD *4427 - Rate 5.10% 9 mo., 10/30/2024 557,829.30 Bond Proceeds 905,216.92 Total Investments$ 3,070,395.34 Total Bank & Investment Accounts 4,339,285.77 8,245.65) Checks in Transit *3102 Total Funds$ 4,331,040.12 Submitted by: Colleen Firkus, Treasurer CITY OF SCANDIA Revenue - Expenditure Summary SEPTEMBER 2024 Description2024 Budget2024 YTD AmountSEPT AmountBudget Balance% of BudgetComments GENERAL FUND RevenueR 101-41000-31000 Washington Cty. Tax Settlement$ 1,865,916 $ 1,003,106 $ - $ 862,810 53.76% Distributed July1andDec. 1 R 101-41000-31040 Fiscal Disparities$ 107,857 $ 76,018 $ - $ 31,839 70.48% R 101-41000-31701 Gravel Taxes$ 20,000 $ 5,565 $ - $ 14,435 27.83% R 101-41000-31830 Solar Energy Production Tax$ 5,500 $ 2,000 $ - $ 3,500 36.37% R 101-41000-31900 Penalties & Interest Del Tax$ 1,000 $ - $ - $ 1,000 0.00% R 101-41000-32150 ROW Utility Permit$ 5,000 $ 3,000 $ 600 $ 2,000 60.00% R 101-41000-32180 Tobacco & Liquor Licenses$ 11,000 $ 1,175 $ - $ 9,825 10.68% R 101-41000-32190 Other City Permits$ 3,000 $ 2,019 $ 50 $ 981 67.30% R 101-41000-32210 Building Permits$ 160,000 $ 150,786 $ 18,793 $ 9,214 94.24% R 101-41000-32260 Gambling Permits$ 100 $ 145 $ 15 $ (45)145.00% R 101-41000-33401 LGA/MVHC/AG/PERA Aid$ 7,000 $ - $ - $ 7,000 0.00% R 101-41000-33420 Fire Relief State PERA$ 40,474 $ - $ - $ 40,474 0.00% Fire Training Grants; $5k Street R 101-41000-33422 Other State Grants & Aids$ 6,000 $ 19,324 $ - $ (13,324) 322.06%Sweeping Grant R 101-41000-33428 PILOT$ 6,000 $ 3,302 $ - $ 2,698 55.03% R 101-41000-33620 Recycling Grant$ 11,000 $ 8,164 $ - $ 2,836 74.22% R 101-41000-33630 Local Govt Grants & Aids$ 10,000 $ 10,228 $ - $ (228) 102.28%Washington County Dive Gear Grant R 101-41000-33640 Other Grants$ 1,200 $ 1,900 $ - $ (700) 158.33% Watershed Street Sweeping Grant R 101-41000-34103 Zoning and Planning$ 5,000 $ 5,546 $ 400 $ (546) 110.92% R 101-41000-34107 Assessment Search Fees$ 20 $ - $ - $ 20 0.00% R 101-41000-34109 Water Usage$ 100 $ - $ - $ 100 0.00% R 101-41000-34202 Fire Protection Services$ 33,915 $ 35,816 $ - $ (1,901) 105.61%Town ofMay FireService Contract R 101-41000-34301 Damage Repairs$ - $ 3,070 $ - $ (3,070) 0.00% R 101-41000-34303 Dust Control$ 3,630 $ 2,673 $ - $ 957 73.63% R 101-41000-34304 Reimbursement for Services$ 1,000 $ 2,700 $ 900 $ (1,700)270.00% FLCC bookkeeping services $3,600/yr. R 101-41000-34305 Other Street Services$ - $ - $ - $ - 0.00% R 101-41000-34730 Ad Revenue$ 1,000 $ 450 $ - $ 550 45.00% R 101-41000-34750 Facilities Rental$ 7,400 $ 6,367 $ 1,205 $ 1,033 86.04% R 101-41000-34760 Cleaning Fees$ - $ - $ - $ - 0.00% R 101-41000-34790 Recreation Programs$ 1,500 $ 1,429 $ 20 $ 71 95.28% R 101-41000-35101 Fines & Forfeitures$ 7,000 $ 3,626 $ 337 $ 3,374 51.80% R 101-41000-36210 Interest Income$ 5,636 $ 69,287 $ 15,437 $ (63,651) 1229.37% distributed among funds atEOY R 101-41000-36230 Donations$ 7,195 $ 2,886 $ 350 $ 4,309 40.11% Vinterfest button donations R 101-41000-36240 Insurance Dividend$ 4,000 $ 2 $ - $ 3,998 0.05% R 101-41000-36250 Misc. Refund$ 2,000 $ 829 $ 1 $ 1,171 41.46% Total General Fund Revenue$ 2,340,443 $ 1,421,414 $ 38,108 $ 919,029 60.73% Operating TransfersR 101-41000-39200 Interfund Operating Transfer$ - R 101-49000-39203 Transfer from Other Funds$ - $ 2,508,813 $ 321,480 $ (2,508,813) R 101-49000-39204 Money Market Transfer$ - $ 5,153,697 $ - $ (5,153,697) Total Operating Transfers$ 7,662,511$ 321,480 $ (7,662,511) CITY OF SCANDIA Revenue - Expenditure Summary SEPTEMBER 2024 Description2024 Budget2024 YTD AmountSEPT AmountBudget Balance% of BudgetComments GENERAL FUND ExpenditureADMINISTRATION & FINANCE E 101-41000-101 Regular Wages & Salaries$ 196,713 $ 123,904 $ 14,212 $ 72,809 62.99% E 101-41000-121 PERA Coord. Employer Contribu.$ 13,801 $ 9,930 $ 1,066 $ 3,871 71.95% E 101-41000-122 FICA Employer Contribution$ 12,196 $ 7,848 $ 851 $ 4,348 64.35% E 101-41000-126 MEDICARE Employer Contribution$ 2,852 $ 1,965 $ 199 $ 887 68.90% E 101-41000-131 Employer Paid Health$ 46,482 $ 30,669 $ 3,147 $ 15,813 65.98% E 101-41000-132 Dental Insurance$ 1,990 $ 1,279 $ 128 $ 711 64.27% E 101-41000-134 Employer Paid Life$ 643 $ 498 $ 50 $ 145 77.45% E 101-41000-135 Employer Paid Disability$ 960 $ 717 $ 72 $ 243 74.66% E 101-41000-151 Worker s Comp Insurance Prem$ 1,339 $ 1,837 $ - $ (498)137.19% E 101-41000-200 Office Supplies$ 1,133 $ 526 $ 106 $ 607 46.46% E 101-41000-203 Printed Forms & Papers$ 1,957 $ 1,874 $ - $ 83 95.78% E 101-41000-210 Operating Supplies$ 824 $ 386 $ - $ 438 46.89% E 101-41000-301 Auditing and Acct g Services$ 27,000 $ 32,050 $ - $ (5,050) 118.70% E 101-41000-303 Engineering Fees$ - $ - $ - $ - 0.00% E 101-41000-304 Legal Services$ 65,000 $ 26,136 $ 2,195 $ 38,864 40.21% E 101-41000-306 Personal Testing & Recruit$ - $ - $ - $ -0.00% American Legal Web Fee & Ordinance E 101-41000-308 Other Professional Services$ 5,000 $ 1,747 $ - $ 3,253 34.94% Updates E 101-41000-309 Software Support & Maintenance$ 18,746 $ 11,408 $ 2,640 $ 7,338 60.86% E 101-41000-316 Conferences & Seminars$ 721 $ 20 $ - $ 701 2.77% E 101-41000-317 Employee Training$ 206 $ - $ - $ 206 0.00% E 101-41000-319 Other Services$ 700 $ 281 $ 46 $ 419 40.14% E 101-41000-321 Telephone$ 5,100 $ 4,065 $ 447 $ 1,035 79.70% E 101-41000-322 Postage$ 2,200 $ 1,633 $ 19 $ 567 74.22% E 101-41000-331 Travel Expenses$ 1,000 $ 487 $ - $ 513 48.74% E 101-41000-351 Legal Notices Publishing$ 1,500 $ 1,444 $ 105 $ 56 96.24% E 101-41000-361 Liability/Property Ins$ 11,516 $ 9,166 $ - $ 2,350 79.60% E 101-41000-365 Insurance Claims$ 1,000 $ - $ - $ 1,000 0.00% E 101-41000-381 Utilities-Electric & Gas$ 12,000 $ 7,535 $ 1,538 $ 4,465 62.79% E 101-41000-413 Equipment Rental$ 1,800 $ 1,230 $ 88 $ 570 68.35% E 101-41000-430 Recycling$ - $ 50 $ - $ (50) 0.00% E 101-41000-433 Dues and Subscriptions$ 5,000 $ 1,877 $ 1,787 $ 3,123 37.54% E 101-41000-434 Youth Service Bureau$ 5,500 $ 5,500 $ - $ - 100.00% E 101-41000-435 Misc Expense$ - $ 7 $ - $ (7) 0.00% Annual website host & maintenance; E 101-41000-438 Misc. Contractual$ 4,120 $ 2,198 $ - $ 1,923 53.34% ABDO help E 101-41000-439 Refunds Issued$ - $ 601 $ 50 $ (601) 0.00% E 101-41000-560 Furniture and Fixtures$ - $ 233 $ - $ (233) 0.00% E 101-41000-570 Office Equipment$ 1,500 $ 122 $ - $ 1,378 8.15% Total Admin & Finance Dept. Expenditures$ 450,499 $ 289,224 $ 28,744 $ 161,27564.20% CITY OF SCANDIA Revenue - Expenditure Summary SEPTEMBER 2024 Description2024 Budget2024 YTD AmountSEPT AmountBudget Balance% of BudgetComments GENERAL FUND CONT.CITY COUNCIL ExpendituresE 101-41110-101 Regular Wages & Salaries$ 20,772 $ 10,386 $ - $ 10,386 50.00% E 101-41110-122 FICA Employer Contribution$ 1,288 $ 185 $ - $ 1,103 14.33% E 101-41110-126 MEDICARE Employer Contribution$ 301 $ 99 $ - $ 202 32.74% E 101-41110-127 PERA Defined$ 703 $ 370 $ - $ 333 52.69% E 101-41110-151 Worker s Comp Insurance Prem$ 100 $ 52 $ - $ 48 52.00% E 101-41110-308 Other Professional Services$ - $ - $ - $ -0.00% E 101-41110-316 Conferences & Seminars$ 350 $ 30 $ - $ 320 8.57% E 101-41110-331 Travel Expenses$ - $ - $ - $ - 0.00% E 101-41110-560 Furniture and Fixtures$ - $ - $ - $ - 0.00% E 101-41110-570 Office Equipment$ - $ - $ - $ - 0.00% Total City Council Dept. Expenditures$ 23,514 $ 11,121 $ - $ 12,393 47.30% ELECTIONS ExpendituresE 101-41410-199 Election Judge$ 5,400 $ 3,879 $ - $ 1,521 71.83% E 101-41410-200 Office Supplies$ 50 $ 45 $ - $ 5 90.20% E 101-41410-203 Printed Forms & Papers$ - $ - $ - $ - 0.00% E 101-41410-210 Operating Supplies$ 750 $ 592 $ 109 $ 158 78.93% E 101-41410-351 Legal Notices Publishing$ 200 $ 56 $ - $ 144 27.91% E 101-41410-413 Equipment Rental$ 1,700 $ 1,672 $ - $ 28 98.35% Wash. Cty. Equip. Maintenance Fee Total Elections Dept. Expenditures$ 8,100 $ 6,243 $ 109 $ 1,857 77.08% PLANNING & BUILDING ExpendituresE 101-41910-101 Regular Wages & Salaries$ 60,010 $ 43,363 $ 4,489 $ 16,647 72.26% E 101-41910-121 PERA Coord. Employer Contribu.$ 4,263 $ 3,250 $ 337 $ 1,013 76.24% E 101-41910-122 FICA Employer Contribution$ 3,721 $ 2,553 $ 265 $ 1,168 68.61% E 101-41910-126 MEDICARE Employer Contribution$ 870 $ 621 $ 62 $ 249 71.43% E 101-41910-131 Employer Paid Health$ 17,353 $ 13,116 $ 1,345 $ 4,237 75.58% E 101-41910-132 Dental Insurance$ 724 $ 548 $ 55 $ 176 75.72% E 101-41910-134 Employer Paid Life$ 173 $ 144 $ 14 $ 29 83.24% E 101-41910-135 Employer Paid Disability$ 416 $ 346 $ 35 $ 70 83.25% E 101-41910-203 Printed Forms & Papers$ 100 $ - $ - $ 100 0.00% E 101-41910-311 Contract Permit Inspections$ 60,000 $ 51,867 $ 9,923 $ 8,133 86.45% E 101-41910-312 Planning Services$ 60,000 $ 37,163 $ 5,436 $ 22,838 61.94% E 101-41910-313 Committee & Commission Reimbur$ 5,200 $ 3,900 $ 1,300 $ 1,300 75.00% E 101-41910-316 Conferences & Seminars$ - $ 30 $ - $ (30)0.00% E 101-41910-319 Other Services$ - $ - $ - $ - 0.00% E 101-41910-361 Liability/Property Ins$ 5,563 $ 4,937 $ - $ 626 88.75% E 101-41910-438 Misc. Contractual$ 5,000 $ 2,391 $ - $ 2,609 47.82% E 101-41910-439 Refunds Issued$ - $ - $ - $ - 0.00% E 101-41910-720 Operating Transfers$ - $ - $ - $ - 0.00% Total Planning & Building Dept. Expenditures$ 223,393 $ 164,230 $ 23,261 $ 59,163 73.52% ASSESSOR ExpendituresE 101-41960-300 Assessor$ 23,200 $ 17,260 $ 2,000 $ 5,940 74.40% POLICE ExpendituresE 101-42100-318 Police Contract$ 183,442 $ 91,721 $ 91,721 $ 91,721 50.00% Code Red System; Taco Daze Security E 101-42100-319 Other Services$ 960 $ 1,189 $ 880 $ (229) 123.89%880 Total GF Police Dept. Expenditures$ 184,402 $ 92,910 $ 92,601 $ 91,492 50.38% CITY OF SCANDIA Revenue - Expenditure Summary SEPTEMBER 2024 Description2024 Budget2024 YTD AmountSEPT AmountBudget Balance% of BudgetComments GENERAL FUND CONT.FIRE ExpendituresE 101-42200-101 Regular Wages & Salaries$ 160,554 $ 138,836 $ 17,557 $ 21,718 86.47% E 101-42200-121 PERA Coord. Employer Contribu.$ - $ - $ - $ 0.00% E 101-42200-122 FICA Employer Contribution$ 9,954 $ 8,523 $ 1,008 $ 1,431 85.63% E 101-42200-124 Police & Fire PERA$ 8,983 $ 7,411 $ 835 $ 1,572 82.50% E 101-42200-126 MEDICARE Employer Contribution$ 2,328 $ 1,655 $ 258 $ 673 71.08% E 101-42200-134 Employer Paid Life$ 192 $ 160 $ 16 $ 32 83.33% E 101-42200-135 Employer Paid Disability$ - $ - $ - $ - 0.00% E 101-42200-141 Unemployment Compensation$ - $ - $ - $ - 0.00% E 101-42200-151 Worker s Comp Insurance Prem$ 12,000 $ 6,249 $ - $ 5,751 52.08% E 101-42200-200 Office Supplies$ 200 $ 150 $ - $ 50 75.00% E 101-42200-203 Printed Forms & Papers$ - $ - $ - $ - 0.00% E 101-42200-209 Medical Supplies$ 3,500 $ 663 $ 216 $ 2,837 18.94% E 101-42200-210 Operating Supplies$ 8,800 $ 5,434 $ 599 $ 3,366 61.75% E 101-42200-211 Cleaning Supplies$ 100 $ - $ - $ 100 0.00% E 101-42200-212 Fuel$ 4,000 $ 3,465 $ 623 $ 535 86.63% E 101-42200-217 Uniforms & Safety Equipment$ 10,000 $ 18,028 $ 9 $ (8,028)180.28% new employee uniforms E 101-42200-221 Equipment Parts$ 1,500 $ - $ - $ 1,500 0.00% E 101-42200-222 Tires$ - $ - $ - $ - 0.00% E 101-42200-223 Structure Repair & Supplies$ 800 $ 6 $ - $ 794 0.81% E 101-42200-240 Small Tools and Minor Equip$ 22,195 $ 15,810 $ 1,524 $ 6,385 71.23% SCBA medical exams & flow testsE101-42200-305 Medical Services$ 5,600 $ 5,630 $ - $ (30) 100.54% E 101-42200-306 Personal Testing & Recruit$ 500 $ - $ - $ 500 0.00% E 101-42200-309 Software Support & Maintenance$ 17,000 $ 10,569 $ 672 $ 6,431 62.17% E 101-42200-310 Medical Training$ 2,000 $ 50 $ - $ 1,950 2.50% E 101-42200-316 Conferences & Seminars$ 250 $ - $ - $ 250 0.00% E 101-42200-317 Employee Training$ 12,000 $ 2,505 $ - $ 9,495 20.87% E 101-42200-319 Other Services$ 500 $ 105 $ - $ 395 21.00% E 101-42200-321 Telephone$ 7,000 $ 4,193 $ 229 $ 2,807 59.90% E 101-42200-322 Postage$ - $ 18 $ - $ (18) 0.00% E 101-42200-324 State of MN-Fire Relief$ 40,474 $ - $ - $ 40,474 0.00% E 101-42200-325 City Match-Fire Relief$ - $ - $ - $ - 0.00% E 101-42200-331 Travel Expenses$ 2,000 $ 1,818 $ - $ 182 90.91% Fire School travel costs MN Board ofFirefighter Training & E 101-42200-334 Licenses & Permits$ 500 $ 368 $ 368 $ 133 73.50%Education License E 101-42200-340 Advertising$ - $ - $ - $ - 0.00% E 101-42200-361 Liability/Property Ins$ 7,339 $ 7,208 $ - $ 131 98.21% E 101-42200-381 Utilities-Electric & Gas$ 8,000 $ 2,420 $ (93) $ 5,580 30.26% E 101-42200-384 Refuse/Garbage Disposal$ - $ 72 $ - $ (72)0.00% E 101-42200-385 Sewer Pumping & Maintenance$ 550 $ 526 $ - $ 24 95.64% E 101-42200-401 Building Maintenance/Repairs$ 3,500 $ 1,857 $ 226 $ 1,643 53.06% E 101-42200-403 Improvements Other Than Bldgs$ - $ - $ - $ 0.00% E 101-42200-404 Repair Machinery/Equipment$ 8,500 $ 6,549 $ 24 $ 1,951 77.04% E 101-42200-407 Well Repair & Maintenance$ - $ - $ - $ - 0.00% E 101-42200-433 Dues and Subscriptions$ 3,200 $ 3,245 $ - $ (45) 101.42% E 101-42200-438 Misc. Contractual$ 3,500 $ 1,440 $ - $ 2,060 41.14% E 101-42200-440 Events$ 1,000 $ 187 $ 39 $ 813 18.70% E 101-42200-520 Capital Improvements to Bldgs$ - $ - $ - $ 0.00% E 101-42200-530 Capital Impr Other Than Bldgs$ - $ - $ - $ 0.00% E 101-42200-540 Heavy Machinery Capital$ - $ - $ - $ - 0.00% E 101-42200-560 Furniture and Fixtures$ 500 $ 51 $ - $ 449 10.18% E 101-42200-570 Office Equipment$ 900 $ 1,078 $ - $ (178) 119.81%computer equipment Total Fire Dept Expenditures$ 369,919 $ 256,281 $ 24,109 $ 113,638 69.28% ANIMAL CONTROL ExpendituresE 101-42700-314 Animal Control$ 6,000 $ 5,314 $ 441 $ 686 88.56% CITY OF SCANDIA Revenue - Expenditure Summary SEPTEMBER 2024 Description2024 Budget2024 YTD AmountSEPT AmountBudget Balance% of BudgetComments GENERAL FUND CONT.PUBLIC WORKS ExpendituresE 101-43000-101 Regular Wages & Salaries$ 255,022 $ 198,597 $ 20,372 $ 56,425 77.87% E 101-43000-102 OT Regular Wages$ 5,014 $ 2,884 $ - $ 2,130 57.51% E 101-43000-104 Temporary Employee Wages$ 2,262 $ 338 $ - $ 1,924 14.93% E 101-43000-121 PERA Coord. Employer Contribu.$ 19,503 $ 14,450 $ 1,528 $ 5,053 74.09% E 101-43000-122 FICA Employer Contribution$ 16,262 $ 11,297 $ 1,200 $ 4,965 69.47% E 101-43000-126 MEDICARE Employer Contribution$ 3,803 $ 2,794 $ 281 $ 1,009 73.46% E 101-43000-131 Employer Paid Health$ 66,939 $ 49,144 $ 4,949 $ 17,795 73.42% E 101-43000-132 Dental Insurance$ 1,164 $ 885 $ 88 $ 279 76.01% E 101-43000-133 Union Training Center$ 1,872 $ 1,224 $ 144 $ 648 65.38% E 101-43000-134 Employer Paid Life$ 698 $ 594 $ 58 $ 104 85.14% E 101-43000-135 Employer Paid Disability$ 1,365 $ 1,169 $ 120 $ 196 85.64% E 101-43000-141 Unemployment Compensation$ - $ - $ - $ - 0.00% E 101-43000-151 Worker s Comp Insurance Prem$ 27,000 $ 22,615 $ - $ 4,385 83.76% E 101-43000-200 Office Supplies$ 50 $ - $ - $ 50 0.00% E 101-43000-210 Operating Supplies$ 8,500 $ 4,521 $ 82 $ 3,979 53.19% E 101-43000-212 Fuel$ 25,000 $ 17,940 $ 2,539 $ 7,061 71.76% E 101-43000-217 Uniforms & Safety Equipment$ 2,300 $ 1,111 $ - $ 1,189 48.30% E 101-43000-221 Equipment Parts$ 17,000 $ 8,098 $ 336 $ 8,902 47.63% E 101-43000-222 Tires$ 7,500 $ 4,754 $ - $ 2,746 63.39% E 101-43000-223 Structure Repair & Supplies$ 2,000 $ - $ - $ 2,000 0.00% E 101-43000-224 Materials for Road Maintenance$ 7,000 $ 16,795 $ - $ (9,795)239.93% Cold Patch; New Streetlight Flags E 101-43000-226 Sign Replacement and Repair$ 750 $ 494 $ 494 $ 256 65.93% E 101-43000-228 Gravel$ 10,000 $ 330 $ - $ 9,670 3.30% E 101-43000-229 Salt$ 22,000 $ 12,375 $ - $ 9,625 56.25% E 101-43000-240 Small Tools and Minor Equip$ 8,000 $ 6,802 $ - $ 1,198 85.02% E 101-43000-302 Surveying$ - $ - $ - $ - 0.00% E 101-43000-303 Engineering Fees$ 10,500 $ 8,348 $ 1,110 $ 2,153 79.50% E 101-43000-304 Legal Services$ - $ - $ - $ - 0.00% E 101-43000-305 Medical Services$ 1,000 $ 53 $ 53 $ 947 5.34% E 101-43000-309 Software Support & Maintenance$ 6,000 $ 200 $ - $ 5,800 3.33% E 101-43000-317 Employee Training$ 1,500 $ 579 $ 120 $ 921 38.63% E 101-43000-319 Other Services$ 7,000 $ 4,169 $ 22 $ 2,831 59.55% E 101-43000-321 Telephone$ 4,000 $ 3,184 $ 349 $ 816 79.59% Travel toArborist workshop & Water E 101-43000-331 Travel Expenses$ 500 $ 291 $ - $ 209 58.14%School E 101-43000-334 Licenses & Permits$ 500 $ 10 $ - $ 490 2.00% E 101-43000-361 Liability/Property Ins$ 8,766 $ 9,713 $ - $ (947) 110.80% E 101-43000-365 Insurance Claims$ - $ - $ - $ - 0.00% E 101-43000-381 Utilities-Electric & Gas$ 6,000 $ 1,783 $ (36) $ 4,217 29.72% E 101-43000-384 Refuse/Garbage Disposal$ - $ 120 $ 120 $ (120)0.00% holding tank & floor drain oil separator E 101-43000-385 Sewer Pumping & Maintenance$ 1,500 $ 2,285 $ - $ (785)152.35% tank pumping E 101-43000-387 Street Light Utilities$ 4,200 $ 2,265 $ 210 $ 1,935 53.94% E 101-43000-401 Building Maintenance/Repairs$ 6,000 $ 3,091 $ 274 $ 2,909 51.52% E 101-43000-403 Improvements Other Than Bldgs$ - $ - $ - $ 0.00% E 101-43000-404 Repair Machinery/Equipment$ 25,000 $ 5,115 $ - $ 19,885 20.46% E 101-43000-405 Contractual Road Maint/Repair$ 200,000 $ 119,379 $ - $ 80,621 59.69% E 101-43000-407 Well Repair & Maintenance$ 500 $ - $ - $ 500 0.00% E 101-43000-413 Equipment Rental$ 4,000 $ 26 $ - $ 3,974 0.65% E 101-43000-417 Uniform Rental$ 1,200 $ 703 $ 85 $ 497 58.62% E 101-43000-433 Dues and Subscriptions$ 200 $ - $ - $ 200 0.00% E 101-43000-438 Misc. Contractual$ 16,000 $ 9,059 $ 4,059 $ 6,941 56.62% E 101-43000-439 Refunds Issued$ - $ - $ - $ - 0.00% E 101-43000-530 Capital Impr Other Than Bldgs$ 9,900 $ - $ - $ 9,900 0.00% E 101-43000-550 Motor Vehicles Capital$ - $ - $ - $ - 0.00% E 101-43000-560 Furniture and Fixtures$ 1,000 $ - $ - $ 1,000 0.00% E 101-43000-570 Office Equipment$ - $ 487 $ - $ (487) 0.00% E 101-43000-720 Operating Transfers$ - $ - $ - $ - 0.00% Total Public Works Dept. Expenditures$ 826,270 $ 550,071 $ 38,557 $ 276,199 66.57% CITY OF SCANDIA Revenue - Expenditure Summary SEPTEMBER 2024 Description2024 Budget2024 YTD AmountSEPT AmountBudget Balance% of BudgetComments GENERAL FUND CONT.PARKS & RECREATION ExpendituresE 101-45000-101 Regular Wages & Salaries$ 11,328 $ 8,021 $ 846 $ 3,307 70.81% E 101-45000-104 Temporary Employee Wages$ 39,985 $ 16,544 $ 2,503 $ 23,441 41.38% E 101-45000-121 PERA Coord. Employer Contribu.$ 850 $ 601 $ 63 $ 249 70.70% E 101-45000-122 FICA Employer Contribution$ 3,181 $ 1,494 $ 205 $ 1,687 46.98% E 101-45000-126 MEDICARE Employer Contribution$ 744 $ 356 $ 48 $ 388 47.85% E 101-45000-131 Employer Paid Health$ 2,562 $ 1,744 $ 189 $ 818 68.09% E 101-45000-132 Dental Insurance$ 42 $ 29 $ 3 $ 13 68.57% E 101-45000-134 Employer Paid Life$ 27 $ 22 $ 2 $ 5 82.96% E 101-45000-135 Employer Paid Disability$ 76 $ 46 $ 5 $ 30 59.89% E 101-45000-141 Unemployment Compensation$ - $ - $ - $ - 0.00% E 101-45000-151 Worker s Comp Insurance Prem$ 2,700 $ 2,251 $ - $ 449 83.37% E 101-45000-200 Office Supplies$ 100 $ - $ - $ 100 0.00% E 101-45000-203 Printed Forms & Papers$ 200 $ - $ - $ 200 0.00% E 101-45000-210 Operating Supplies$ 1,000 $ 777 $ 230 $ 223 77.66% E 101-45000-212 Fuel$ 1,000 $ 138 $ - $ 862 13.80% E 101-45000-221 Equipment Parts$ 2,500 $ 676 $ 88 $ 1,824 27.04% E 101-45000-223 Structure Repair & Supplies$ 2,500 $ 138 $ - $ 2,362 5.52% E 101-45000-240 Small Tools and Minor Equip$ 500 $ - $ - $ 500 0.00% E 101-45000-312 Planning Services$ - $ - $ - $ - 0.00% E 101-45000-313 Committee & Commission Reimbur$ - $ 720 $ 240 $ 720) 0.00% E 101-45000-319 Other Services$ 1,750 $ 1,019 $ - $ 731 58.24% E 101-45000-322 Postage$ - $ - $ - $ - 0.00% E 101-45000-340 Advertising$ - $ 275 $ - $ (275) 0.00% E 101-45000-353 Sales& Use Tax$ - $ - $ - $ - 0.00% E 101-45000-361 Liability/Property Ins$ 3,489 $ 5,333 $ - $ (1,844) 152.86% E 101-45000-381 Utilities-Electric & Gas$ 6,500 $ 2,529 $ 287 $ 3,971 38.91% E 101-45000-384 Refuse/Garbage Disposal$ 5,000 $ 3,281 $ 624 $ 1,719 65.63% E 101-45000-385 Sewer Pumping & Maintenance$ 1,250 $ 384 $ - $ 866 30.73% Lighted ballfield fence repair - insurance E 101-45000-401 Building Maintenance/Repairs$ 6,000 $ 4,391 $ 120 $ 1,609 73.18% reimbursed E 101-45000-403 Improvements Other Than Bldgs$ 2,500 $ 716 $ - $ 1,784 28.63% E 101-45000-404 Repair Machinery/Equipment$ 1,000 $ 482 $ 64 $ 518 48.17% E 101-45000-406 Grounds Care$ 4,000 $ 1,265 $ - $ 2,735 31.62% Liten Park spraying, Lilleskogen & lawn E 101-45000-438 Misc. Contractual$ 8,000 $ 6,583 $ 625 $ 1,417 82.28% service E 101-45000-439 Refunds Issued$ - $ - $ - $ - 0.00% E 101-45000-440 Events$ 7,000 $ 1,522 $ 73 $ 5,478 21.75% E 101-45000-490 Financial Assistance$ - $ - $ - $ - 0.00% E 101-45000-530 Capital Impr Other Than Bldgs$ 9,900 $ 4,214 $ 2,414 $ 5,686 42.57% E 101-45000-720 Operating Transfers$ - $ - $ - $ - 0.00% Total Parks & Rec Dept. Expenditures$ 125,684 $ 65,552 $ 8,628 $ 60,132 52.16% CITY OF SCANDIA Revenue - Expenditure Summary SEPTEMBER 2024 Description2024 Budget2024 YTD AmountSEPT AmountBudget Balance% of BudgetComments GENERAL FUND CONT.COMMUNITY CENTER ExpendituresE 101-45180-101 Regular Wages & Salaries$ 16,600 $ 11,909 $ 1,244 $ 4,691 71.74% E 101-45180-104 Temporary Employee Wages$ - $ - $ - $ - 0.00% E 101-45180-121 PERA Coord. Employer Contribu.$ 1,245 $ 883 $ 93 $ 362 70.96% E 101-45180-122 FICA Employer Contribution$ 1,029 $ 695 $ 73 $ 334 67.56% E 101-45180-126 MEDICARE Employer Contribution$ 241 $ 172 $ 17 $ 69 71.44% E 101-45180-131 Employer Paid Health$ 3,692 $ 2,380 $ 266 $ 1,312 64.45% E 101-45180-134 Employer Paid Life$ 43 $ 36 $ 4 $ 7 83.72% E 101-45180-135 Employer Paid Disability$ 95 $ 86 $ 9 $ 9 90.91% E 101-45180-151 Worker s Comp Insurance Prem$ - $ 152 $ - $ (152)0.00% E 101-45180-210 Operating Supplies$ 2,900 $ 1,123 $ 67 $ 1,777 38.73% E 101-45180-223 Structure Repair & Supplies$ 4,000 $ 236 $ - $ 3,764 5.91% E 101-45180-321 Telephone$ - $ 380 $ 73 $ (380) 0.00% E 101-45180-334 Licenses & Permits$ 1,000 $ 955 $ - $ 45 95.50% E 101-45180-361 Liability/Property Ins$ 835 $ 801 $ - $ 34 95.89% E 101-45180-381 Utilities-Electric & Gas$ 9,135 $ 4,477 $ 383 $ 4,658 49.01% E 101-45180-384 Refuse/Garbage Disposal$ - $ 156 $ - $ (156)0.00% E 101-45180-385 Sewer Pumping & Maintenance$ 4,000 $ 1,971 $ - $ 2,029 49.28% E 101-45180-401 Building Maintenance/Repairs$ 15,000 $ 7,540 $ 815 $ 7,460 50.27% E 101-45180-404 Repair Machinery/Equipment$ 5,000 $ 125 $ - $ 4,875 2.49% E 101-45180-406 Grounds Care$ 1,300 $ 117 $ - $ 1,183 9.00% E 101-45180-407 Well Repair & Maintenance$ 1,000 $ - $ - $ 1,000 0.00% Seasonal lightingE101-45180-438 Misc. Contractual$ 3,500 $ 1,500 $ - $ 2,000 42.86% E 101-45180-439 Refunds Issued$ - $ - $ - $ - 0.00% E 101-45180-520 Capital Improvements to Bldgs$ 9,900 $ - $ - $ 9,900 0.00% E 101-45180-530 Capital Impr Other Than Bldgs$ - $ - $ - $ 0.00% E 101-45180-570 Office Equipment$ - $ - $ - $ - 0.00% E 101-45180-720 Operating Transfers$ - $ - $ - $ - 0.00% Total Community Center Dept. Expenditures$ 80,515 $ 35,694 $ 3,044 $ 44,821 44.33% TOTAL GENERAL FUND EXPENDITURES$ 2,321,496.00 $ 1,493,898.96 $ 221,494.23 $ 827,597.04 64.35% E 101-49000-421 Cash Over/Short Operating TransfersE 101-49000-720 Operating Transfers$ 7,441,031 $ 100,000 $ (7,441,031) TOTAL GENERAL FUND EXPENDITURES W/TRANSFERS$ 2,321,496.00 $ 8,934,929.82 $ 321,494.23 $ (6,613,433.82) CITY OF SCANDIA Revenue - Expenditure Summary SEPTEMBER 2024 Description2024 Budget2024 YTD AmountSEPT AmountBudget Balance% of BudgetComments COVID RELIEF FUND RevenueR 203-46200-33150 Federal Grant$ - $ - $ - $ - ExpendituresE 203-49000-720 Operating Transfers$ - $ - $ - $ EDA FUND RevenueR 225-46500-31000 Washington Cty. Tax Settlement$ 5,300 $ 2,650 $ 2,650 $ 2,650 50.00% R 225-46500-33640 Other Grants$ - $ - $ - $ - 0.00% R 225-46500-34750 Facilities Rental$ - $ - $ - $ - 0.00% R 225-46500-36210 Interest Income$ 100 $ - $ - $ 100 0.00% R 225-46500-36230 Donations$ - $ 310 $ - $ (310) 0.00% R 225-46500-39200 Interfund Operating Transfer$ - $ 33,356 $ - $ (33,356)0.00% closed checking account Total EDA Fund Revenue$ 5,400$ 36,316$ 2,650$ (30,916)672.52% ExpenditureE 225-46500-210 Operating Supplies$ 300 $23$0$2777.74% E 225-46500-303 Engineering Fees$ - $0$0$00.00% E 225-46500-304 Legal Services$ - $0$0$00.00% E 225-46500-308 Other Professional Services$ 100 $0$0$1000.00% EDAM Membership; Sister City DuesE225-46500-340 Advertising$ 1,500 $0$0$1,5000.00% E 225-46500-433 Dues and Subscriptions$ 1,203 $364$0$83930.26% E 225-46500-440 Events$ 1,500 $310$0$1,19020.67% E 225-46500-720 Operating Transfers$ - $33,356$0($33,356)0.00% closed checking account Total EDA Fund Expenditures$ 4,603$ 34,053$ -$ (29,450)739.81% CABLE TV FUND RevenueR 226-41950-36210 Interest Income$ 100 $ - $ - $ 100 0.00% R 226-41950-36260 Sale of Equipment$ - $ - $ - $ - 0.00% R 226-41950-38050 Cable TV Franchise Rebates$ 16,700 $ 13,689 $ 1,649 $ 3,011 81.97% R 226-41950-38051 PEG Fees$ 4,400 $ 3,010 $ 416 $ 1,390 68.41% Total Cable TV Fund Revenue$ 21,200$ 16,699$ 2,066$ 4,501 78.77% ExpenditureE 226-41950-240 Small Tools and Minor Equip$ 300 $ - $ - $ 300 0.00% E 226-41950-309 Software Support & Maintenance$ 3,500 $ 2,698 $ 176 $ 802 77.10% Boxcast streaming & storage E 226-41950-438 Misc. Contractual$ 7,750 $ 6,919 $ 3,749 $ 831 89.28% Filming Govt meetings; Zoom contract E 226-41950-570 Office Equipment$ - $ - $ - $ - 0.00% Total Cable TV Fund Expenditures$ 11,550$ 9,617$ 3,925$ 1,933 83.27% GATEWAY TRAIL FUND RevenueR 230-45000-36230 Donations$ - $ - $ - $ - 0.00% ExpenditureE 230-45000-308 Other Professional Services$ - $ - $ - $ 0.00% CITY OF SCANDIA Revenue - Expenditure Summary SEPTEMBER 2024 Description2024 Budget2024 YTD AmountSEPT AmountBudget Balance% of BudgetComments 2018 STREET RECONSTRUCTION RevenueR 318-47000-31000 Washington Cty. Tax Settlement$ 345,634 $ 172,817 $ - $ 172,817 50.00% ExpenditureE 318-47000-601 Long Term Debt Principal$ 245,000 $ - $ - $ 245,000 0.00% E 318-47000-611 Long Term Debt Interest$ 84,175 $ 42,088 $ - $ 42,087 50.00% E 318-47000-620 Fiscal Agent s Fees$ 495 $ 1,045 $ - $ (550) 211.11%2023 & 2024 fees Total 2018 Street Reconstruction Fund Expenditures$ 329,670 $ 43,133$ -$ 286,53713.08% 2024 STREET RECONSTRUCTION RevenueR 324-47000-31000 Washington Cty. Tax Settlement$ - $ - $ - $ 0.00% R 324-47000-36210 Interest Income$ - $ 44,186 $ 3,866 $ (44,186) 0.00% Total 2024 Street Reconstruction Fund Revenues$ - $ 44,186 $ 3,866 $ (44,186)0.00% ExpenditureE 324-47000-601 Long Term Debt Principal$ - $ - E 324-47000-611 Long Term Debt Interest$ - E 324-47000-620 Fiscal Agent s Fees$ 495 $ - $ 495 0.00% Total 2024 Street Reconstruction Fund Expenditures$ 495 $ -$ -$ 4950.00% CAPITAL IMPROVEMENTS RevenueR 401-48000-31000 Washington Cty. Tax Settlement$ 235,000 $ 117,500 $ - $ 117,500 50.00% R 401-48000-33422 Other State Grants & Aids$ - $ 34,110 $ - $ (34,110) 0.00% R 401-48000-33640 Other Grants$ - $ 10,972 $ - $ (10,972) 0.00% R 401-48000-36210 Interest Income$ 3,000 $ - $ - $ 3,000 0.00% Total Capital Improvement Fund Revenue$ 238,000 $ 162,582 $ -$ 75,418 68.31% ExpenditureE 401-41000-312 Planning Services$ - $ - $ - $ 0.00% E 401-41000-520 Capital Improvements to Bldgs$ - $ - $ - $ 0.00% E 401-41000-530 Capital Impr Other Than Bldgs$ 250,000 $ - $ - $ 250,000 0.00% E 401-42200-520 Capital Improvements to Bldgs$ - 0.00% E 401-45180-520 Capital Improvements to Bldgs$ 67,548 $ - $ - $ 67,548 0.00% E 401-48000-303 Engineering Fees$ - $ 48,712 $ 12,618 $ (48,712) 0.00% Gateway Trail Engineering E 401-48000-308 Other Professional Services$ - $ 4,800 $ - $ (4,800)0.00% Gateway Trail Lobbying E 401-48000-435 Misc Expense$ - $ - $ - $ - 0.00% E 401-48000-438 Misc. Contractual$ - $ - $ - $ - 0.00% E 401-48000-520 Capital Improvements to Bldgs$ - $ - $ - $ 0.00% E 401-48000-530 Capital Impr Other Than Bldgs$ 160,000 $ - $ - $ 160,000 0.00% E 401-48000-720 Operating Transfers$ - $ 150,000 $ - $ (150,000) 0.00% transfer toPark Fund forcourt recon 477,548 $ 53,512 $ 12,618 $ 424,036 11.21% PARK DEVELOPMENT RevenueR 404-48000-31000 Washington Cty. Tax Settlement$ 60,000 $ 30,000 $ - $ 30,000 50.00% R 404-48000-33422 Other State Grants & Aids$ - $ 101,250 $ - $ (101,250) 0.00%2023 Playground grant R 404-48000-34780 Park Dedication Fees$ - $ - $ - $ - 0.00% R 404-48000-39203 Transfer from Other Funds$ - $ 150,000 $ - $ (150,000) 0.00%from Park Fund balance R 404-48000-36210 Interest Income$ 66 $ - $ - $ 66 0.00% R 404-48000-36230 Donations$ - $ - $ - $ - 0.00% Total Park Development Fund Revenue$ 60,066$ 281,250 $ -$ (221,184)468.23% ExpenditureE 404-48000-303 Engineering Fees$0.00$ 51,767 $ 3,871 $ (51,767) 0.00%tennis courts E 404-48000-308 Other Professional Services$0.00$ 410 $ - $ (410) 0.00% E 404-48000-312 Planning Services$ - $ - $ - $ - 0.00% E 404-48000-520 Capital Improvements to Bldgs$ - $ - $ - $ 0.00% E 404-48000-530 Capital Impr Other Than Bldgs$ 150,000 $ 2,686 $ - $ 147,314 1.79% E 404-48000-720 Operating Transfers$ - $ - $ - $ - 0.00% Total Park Development Fund Expenditures$ 150,000 $ 54,863$ 3,871$ 95,137 36.58% EQUIPMENT REPLACEMENT RevenueR 406-48500-31000 Washington Cty. Tax Settlement$ 110,000 $ 55,000 $ - $ 55,000 50.00% R 406-48500-36210 Interest Income$ 1,045 $ - $ - $ 1,045 0.00% R 406-48500-36260 Sale of Equipment$ - $ - $ - $ - 0.00% R 406-48500-39350 Certificate of Indebtedness$ 350,000 $ - $ - $ 350,000 0.00% Total Equipment Replacement Fund Revenue$ 461,045 $ 55,000$ -$ 406,04511.93% ExpenditureE 406-48500-540 Heavy Machinery Capital$ 867,000 $ 264,304 $ 38,192 $ 602,696 30.48%Fire Truck & Drum Mulcher E 406-48500-550 Motor Vehicles Capital$ 84,356 $ 161,429 $ 41,913 $ (77,073) 191.37%FD Utility Truck(2023) & PW F550 Total Equipment Replacement Fund Expenditures$ 951,356 $ 425,733 $ 80,105 $ 525,62344.75% CITY OF SCANDIA Revenue - Expenditure Summary SEPTEMBER 2024 Description2024 Budget2024 YTD AmountSEPT AmountBudget Balance% of BudgetComments LOCAL ROAD IMPROVEMENT FUND RevenueR 408-43100-31000 Washington Cty. Tax Settlement$ 375,000 $ 187,500 $ - $ 187,500 50.00% R 408-43100-33422 Other State Grants & Aids$ 63,082 $ - $ (63,082) 0.00% R 408-43100-36210 Interest Income$ 10,705 $ - $ - $ 10,705 0.00% R 408-43100-39310 Proceeds-Gen Obligation Bond$ 4,000,000 $ 3,868,542 $ - $ 131,458 96.71% Total LRIF Revenue$ 4,385,705$ 4,119,123$ -$ 266,58293.92% ExpenditureE 408-43100-303 Engineering Fees$ 120,000 $ 285,378 $ 66,876 $ (165,378) 237.81% E 408-43100-319 Other Services$ - $ 375 $ - $ (375) 0.00% E 408-43100-351 Legal Notices Publishing$ - $ 59 $ - $ (59)0.00% E 408-43100-530 Capital Impr Other Than Bldgs$ 3,575,000 $ 2,721,699 $ 154,605 $ 853,301 76.13% Total LRIF Expenditures$ 3,695,000 $ 3,007,511 $ 221,480 $ 687,489 81.39% BLISS SEWER RevenueR 602-43210-31951 Special Assessments Principal$ - $ 2,652 $ - $ 2,652) 0.00% R 602-43210-31952 SA Penalties & Interest$ 420 $ 318 $ - $ 102 75.76% R 602-43210-33422 Other State Grants & Aids$ - $ - $ - $ -0.00% R 602-43210-34401 Sewer User Fees$ 125,230 $ 67,602 $ 11,488 $ 57,628 53.98% R 602-43210-34402 Sewer Connection Fee$ - $ - $ - $ - 0.00% R 602-43210-36100 Special Assessments$ - $ 47 $ - $ (47)0.00% R 602-43210-36102 Penalties and Interest$ - $ 138 $ 45 $ (138)0.00% R 602-43210-36210 Interest Income$ 210 $ - $ - $ 210 0.00% Total BLISS Sewer Revenue$ 125,860 $ 70,756 $ 11,533 $ 55,104 56.22% ExpenditureE 602-43210-101 Regular Wages & Salaries$ 17,458 $ 14,839 $ 1,621 $ 2,619 85.00% E 602-43210-120 Pension Expense$ - $ - $ - $ - 0.00% E 602-43210-121 PERA Coord. Employer Contribu.$ 1,309 $ 1,112 $ 122 $ 197 84.93% E 602-43210-122 FICA Employer Contribution$ 1,082 $ 867 $ 96 $ 215 80.15% E 602-43210-126 MEDICARE Employer Contribution$ 253 $ 217 $ 22 $ 36 85.96% E 602-43210-131 Employer Paid Health$ - $ - $ - $ - 0.00% E 602-43210-151 Worker s Comp Insurance Prem$ 525 $ 783 $ - $ 258) 149.14% E 602-43210-200 Office Supplies$ 91 $ 102 $ - $ (11) 112.31% E 602-43210-210 Operating Supplies$ 700 $ 32 $ 3 $ 668 4.53% E 602-43210-240 Small Tools and Minor Equip$ 420 $ - $ - $ 420 0.00% E 602-43210-303 Engineering Fees$ 7,718 $ 74,633 $ 1,080 $ (66,915) 967.00% Bliss Treatment Project E 602-43210-304 Legal Services$ - $ - $ - $ - 0.00% E 602-43210-308 Other Professional Services$ 3,500 $ 15,841 $ 474 $ (12,341) 452.60%Monthly Sampling & Lobbying E 602-43210-309 Software Support & Maintenance$ 910 $ - $ - $ 910 0.00% E 602-43210-317 Employee Training$ 980 $ 598 $ - $ 382 61.05% E 602-43210-321 Telephone$ 1,750 $ 1,492 $ - $ 258 85.27% E 602-43210-322 Postage$ 420 $ - $ - $ 420 0.00% E 602-43210-331 Travel Expenses$ 525 $ 78 $ - $ 447 14.93% E 602-43210-334 Licenses & Permits$ 1,400 $ 505 $ - $ 895 36.07% E 602-43210-361 Liability/Property Ins$ 2,535 $ 2,383 $ - $ 152 93.99% E 602-43210-381 Utilities-Electric & Gas$ 2,100 $ 934 $ 141 $ 1,166 44.48% E 602-43210-385 Sewer Pumping & Maintenance$ 14,000 $ 1,820 $ - $ 12,180 13.00% E 602-43210-386 Operation & Maintenance$ 3,500 $ - $ - $ 3,500 0.00% E 602-43210-404 Repair Machinery/Equipment$ 11,200 $ 2,611 $ - $ 8,589 23.31% E 602-43210-413 Equipment Rental$ 700 $ - $ - $ 700 0.00% E 602-43210-420 Depreciation Expense$ 40,600 $ - $ - $ 40,600 0.00% 30% ofFund Balance moved tonew A-E E 602-43210-438 Misc. Contractual$ 7,000 $ 1,470 $ 140 $ 5,530 21.00% Fund 624 E 602-43210-439 Refunds Issued$ - $ - $ - $ - 0.00% E 602-43210-530 Capital Impr Other Than Bldgs$ 6,930 $ - $ - $ 6,930 0.00% E 602-43210-720 Operating Transfers$ - $ 17,584 $ - $ (17,584) 0.00% Total BLISS Sewer Expenditures$ 127,606 $ 137,902 $ 3,697$ (10,296)108.07% CITY OF SCANDIA Revenue - Expenditure Summary SEPTEMBER 2024 Description2024 Budget2024 YTD AmountSEPT AmountBudget Balance% of BudgetComments UPTOWN SEWER RevenueR 612-43210-34401 Sewer User Fees$ 22,400 $ 11,142 $ - $ 11,258 49.74% R 612-43210-36210 Interest Income$ 50 $ - $ - $ 50 0.00% Total Uptown Sewer Revenue$ 22,450$ 11,142$ -$ 11,308 49.63% ExpenditureE 612-43210-101 Regular Wages & Salaries$ 10,725 $ 5,971 $ 635 $ 4,754 55.67% E 612-43210-120 Pension Expense$ - $ - $ - $ - 0.00% E 612-43210-121 PERA Coord. Employer Contribu.$ 804 $ 447 $ 48 $ 357 55.60% E 612-43210-122 FICA Employer Contribution$ 665 $ 348 $ 37 $ 317 52.36% E 612-43210-126 MEDICARE Employer Contribution$ 156 $ 88 $ 9 $ 68 56.24% E 612-43210-151 Worker s Comp Insurance Prem$ 300 $ 522 $ - $ 222) 174.00% E 612-43210-200 Office Supplies$ 100 $ - $ - $ 100 0.00% E 612-43210-210 Operating Supplies$ 500 $ - $ - $ 500 0.00% E 612-43210-221 Equipment Parts$ 500 $ - $ - $ 500 0.00% E 612-43210-303 Engineering Fees$ 1,050 $ - $ - $ 1,050 0.00% E 612-43210-308 Other Professional Services$ 750 $ 310 $ - $ 441 41.27% E 612-43210-309 Software Support & Maintenance$ 84 $ - $ - $ 84 0.00% E 612-43210-317 Employee Training$ 200 $ 1,138 $ - $ (938) 568.82%Water Operator training E 612-43210-319 Other Services$ 1,500 $ - $ - $ 1,500 0.00% E 612-43210-322 Postage$ - $ - $ - $ - 0.00% E 612-43210-334 Licenses & Permits$ 250 $ 231 $ - $ 19 92.40% E 612-43210-361 Liability/Property Ins$ 502 $ 464 $ - $ 38 92.41% E 612-43210-381 Utilities-Electric & Gas$ 1,000 $ 295 $ (8) $ 705 29.48% E 612-43210-385 Sewer Pumping & Maintenance$ 1,500 $ 1,484 $ 400 $ 17 98.90% E 612-43210-386 Operation & Maintenance$ 1,000 $ 30 $ 30 $ 970 2.96% E 612-43210-404 Repair Machinery/Equipment$ 2,000 $ - $ - $ 2,000 0.00% E 612-43210-420 Depreciation Expense$ 4,900 $ - $ - $ 4,900 0.00% E 612-43210-438 Misc. Contractual$ 1,500 $ 589 $ 140 $ 911 39.26% E 612-43210-530 Capital Impr Other Than Bldgs$ 9,900 $ - $ - $ 9,900 0.00% E 612-43210-720 Operating Transfers$ 2,640 $ - $ - $ 2,640 0.00% Total Uptown Sewer Expenditures$ 42,526$ 11,914$ 1,290$ 30,612 28.02% A-E SEWER RevenueR 624-43210-31952 SA Penalties & Interest$ 180 $ - $ - $ 180 0.00% R 624-43210-34401 Sewer User Fees$ 53,670 $ 28,623 $ 5,159 $ 25,047 53.33% R 624-43210-36102 Penalties and Interest$ - $ 40 $ 10 $ 40) 0.00% R 624-43210-36210 Interest Income$ 90 $ - $ - $ 90 0.00% R 624-43210-39200 Interfund Operating Transfer$ - $ 17,584 $ - $ (17,584)0.00% Total A-E Sewer Revenue$ 53,940 $ 46,247 $ 5,169 $ 7,693 85.74% ExpenditureE 624-43210-101 Regular Wages & Salaries$ 7,482 $ - $ - $ 7,482 0.00% E 624-43210-121 PERA Coord. Employer Contribu.$ 561 $ - $ - $ 561 0.00% E 624-43210-122 FICA Employer Contribution$ 464 $ - $ - $ 464 0.00% E 624-43210-126 MEDICARE Employer Contribution$ 108 $ - $ - $ 108 0.00% E 624-43210-131 Employer Paid Health$ - $ - $ - $ - 0.00% E 624-43210-151 Worker s Comp Insurance Prem$ 225 $ - $ - $ 225 0.00% E 624-43210-199 Election Judge$ - $ - $ - $ - 0.00% E 624-43210-200 Office Supplies$ 39 $ 44 $ - $ (5) 112.31% E 624-43210-210 Operating Supplies$ 300 $ - $ - $ 300 0.00% E 624-43210-240 Small Tools and Minor Equip$ 180 $ - $ - $ 180 0.00% E 624-43210-303 Engineering Fees$ - $ - $ - $ - 0.00% E 624-43210-308 Other Professional Services$ 1,500 $ 310 $ - $ 1,191 20.63% E 624-43210-309 Software Support & Maintenance$ 390 $ - $ - $ 390 0.00% E 624-43210-317 Employee Training$ 420 $ 109 $ - $ 311 25.99% E 624-43210-321 Telephone$ 750 $ 705 $ - $ 45 94.00% E 624-43210-322 Postage$ 180 $ - $ - $ 180 0.00% E 624-43210-331 Travel Expenses$ 225 $ 78 $ - $ 147 34.84% E 624-43210-334 Licenses & Permits$ 600 $ 231 $ - $ 369 38.50% E 624-43210-361 Liability/Property Ins$ 1,086 $ 985 $ - $ 101 90.74% E 624-43210-381 Utilities-Electric & Gas$ 900 $ 358 $ 38 $ 542 39.81% E 624-43210-385 Sewer Pumping & Maintenance$ 6,000 $ - $ - $ 6,000 0.00% E 624-43210-386 Operation & Maintenance$ 1,500 $ - $ - $ 1,500 0.00% E 624-43210-404 Repair Machinery/Equipment$ 4,800 $ 1,289 $ - $ 3,511 26.86% E 624-43210-413 Equipment Rental$ 300 $ - $ - $ 300 0.00% E 624-43210-420 Depreciation Expense$ 17,400 $ - $ - $ 17,400 0.00% Riser Replacement; Sewer Rate Study; LS E 624-43210-438 Misc. Contractual$ 3,000 $ 4,508 $ 140 $ (1,508) 150.27% Pump Inspection E 624-43210-530 Capital Impr Other Than Bldgs$ 2,970 $ - $ - $ 2,970 0.00% Total A-E Sewer Expenditures$ 51,380$ 8,618$ 178$ 42,762 16.77%