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
City ofScandiaaug Treasurer’sReport December 31, 2024 FUND ACCOUNTING Beginning Cash Balance $ 4,592,971.1512/1/2024 Beginning Checking Balance$ 1,500,024.51 Checking Receipts 136,752.09 Transfers to Checking Total Deposits 136,752.09 Expenditures 460,913.49) CASH BALANCES12/31/2024 Payroll$ (57,837.73) Transfers to Money Market$ (725,000.00) G 101-10100GENERAL FUND$ 1,958,651.99 Total Payments 1,243,751.22)G 203-10100COVID-19 RELIEF$0.00 G 225-10100EDA$42,289.70 Ending Checking Balance 393,025.38G 226-10100CABLE TV$ 31,100.03 G 230-10100GATEWAY TRAIL$ - Beginning Money Market Balance 162,945.05G 240-10100PUBLIC SAFETY AID$ - Money Market Receipts 500.73 G 313-101002013 EQUIP CERT$ - Transfer to Checking G 318-101002018 ROAD PROJECT$ 77,805.17 Transfer from Checking 725,000.00G 324-101002024 ROAD PROJECTS$ 703,622.23 G 401-10100CAPITAL IMPROVEMENT$ 428,769.22 Ending Money Market Balance 888,445.78G 404-10100PARK DEVELOPMENT$ 213,747.04 G 406-10100EQUIPMENT REPLACE$ 449,894.92 Beginning Investments Balance 2,934,949.41 G 408-10100LRIF$ 170,924.58 Investments Receipts-Interest 7,272.74G 602-10100BLISS SEWER$ (7,716.89) Transfer from Checking G 612-10100UPTOWN SEWER$ 22,867.36 41,907.67)G 624-10100A-E SEWER$ 32,562.47TransferstoChecking Ending Investments Balance$ 2,900,314.48G 801-10100ESCROW$ 11,670.96 4,136,188.78 Outstanding Checks$ (45,596.86) 12/31/2024EndingCashBalance $ 4,136,188.78 CHECKING, MONEY MARKET & INVESTMENT CD's Checking *102$ 1,500,024.51BegBal Credits$ 134,553.09 Debits$ (1,241,552.22) Receipt in Transit 393,025.38EndBal Money Market *105 - Rate 1.25%$ 162,945.05BegBal rate change from .25% Credits 725,500.73 Debits End Bal$ 888,445.78 Investments CD *4422 - Rate 5.10% 12 mo., 3/25/2025$ 343,543.69 CD *4424 - Rate 5.00% 12 mo., 7/27/2025$ 479,018.30 CD *4428 - Rate 5.10% 7 mo., 05/01/25 $ 794,944.50 CD *4427 - Rate 4.50% 9 mo., 07/30/25 579,185.76 Bond Proceeds @4.98% 703,622.23 Total Investments$ 2,900,314.48 Total Bank & Investment Accounts 4,181,785.64 45,596.86) Checks in Transit *3102 Total Funds$ 4,136,188.78 Submitted by: Colleen Firkus, Treasurer CITY OF SCANDIA Revenue - Expenditure Summary DECEMBER 2024 Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments GENERAL FUND RevenueR 101-41000-31000 Washington Cty. Tax Settlement$ 1,865,916 $ 1,678,931 $ - $ 186,985 89.98% Distributed July1andDec. 1 R 101-41000-31040 Fiscal Disparities$ 107,857 $ 103,218 $ - $ 4,639 95.70% R 101-41000-31701 Gravel Taxes$ 20,000 $ 5,565 $ - $ 14,435 27.83% R 101-41000-31830 Solar Energy Production Tax$ 5,500 $ 5,763 $ - $ (263)104.78% R 101-41000-31900 Penalties & Interest Del Tax$ 1,000 $ - $ - $ 1,000 0.00% R 101-41000-32150 ROW Utility Permit$ 5,000 $ 5,550 $ 450 $ (550) 111.00% R 101-41000-32180 Tobacco & Liquor Licenses$ 11,000 $ 13,735 $ 7,244 $ (2,735) 124.86% R 101-41000-32190 Other City Permits$ 3,000 $ 2,556 $ 25 $ 444 85.20% R 101-41000-32210 Building Permits$ 160,000 $ 215,924 $ 10,045 $ (55,924) 134.95% R 101-41000-32260 Gambling Permits$ 100 $ 145 $ - $ (45) 145.00% R 101-41000-33401 LGA/MVHC/AG/PERA Aid$ 7,000 $ 14,430 $ 7,227 $ (7,430) 206.14% R 101-41000-33420 Fire Relief State PERA$ 52,719 $ - $ - $ 52,719 0.00% Fire Training Grants; Turnout Gear & R 101-41000-33422 Other State Grants & Aids$ 6,000 $ 19,324 $ - $ (13,324) 322.06%Election Reimbursements R 101-41000-33428 PILOT$ 6,000 $ 6,585 $ - $ (585) 109.75% R 101-41000-33620 Recycling Grant$ 11,000 $ 8,164 $ - $ 2,836 74.22% R 101-41000-33630 Local Govt Grants & Aids$ 10,000 $ 11,111 $ 882 $ (1,111) 111.11%Washington County Dive Gear Grant R 101-41000-33640 Other Grants$ 1,200 $ 1,900 $ - $ (700) 158.33% CMSWD Street Sweeping Grant R 101-41000-34103 Zoning and Planning$ 5,000 $ 6,363 $ 100 $ (1,363) 127.26% 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 $ 3,600 $ 900 $ (2,600)360.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 $ 11,487 $ 1,976 $ (4,087) 155.24% R 101-41000-34760 Cleaning Fees$ - $ - $ - $ - 0.00% R 101-41000-34790 Recreation Programs$ 1,500 $ 2,203 $ 279 $ (703) 146.88% R 101-41000-35101 Fines & Forfeitures$ 7,000 $ 4,833 $ 157 $ 2,167 69.04% R 101-41000-36210 Interest Income$ 5,636 $ 102,619 $ 4,822 $ (96,983) 1820.78% distributed among funds atEOY R 101-41000-36230 Donations$ 7,195 $ 3,186 $ 300 $ 4,009 44.28% Vinterfest button donations R 101-41000-36240 Insurance Dividend$ 4,000 $ 5,281 $ 5,279 $ (1,281) 132.03% R 101-41000-36250 Misc. Refund$ 2,000 $ 880 $ - $ 1,120 44.01% Total General Fund Revenue$ 2,352,688 $ 2,275,361 $ 39,686 $ 77,326 96.71% Operating TransfersR 101-41000-39200 Interfund Operating Transfer$ - $ 3,445,273 $ 766,908 $ 3,445,273) R 101-49000-39203 Transfer from Other Funds$ - $ 6,073,697 $ - $ (6,073,697) R 101-49000-39204 Money Market Transfer$ - Total Operating Transfers$ 9,518,971$ 766,908 $ (9,518,971) CITY OF SCANDIA Revenue - Expenditure Summary DECEMBER 2024 Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments GENERAL FUND ExpenditureADMINISTRATION & FINANCE E 101-41000-101 Regular Wages & Salaries$ 196,713 $ 173,007 $ 20,876 $ 23,706 87.95% E 101-41000-121 PERA Coord. Employer Contribu.$ 13,801 $ 13,612 $ 1,566 $ 189 98.63% E 101-41000-122 FICA Employer Contribution$ 12,196 $ 10,802 $ 1,265 $ 1,394 88.57% E 101-41000-126 MEDICARE Employer Contribution$ 2,852 $ 2,656 $ 296 $ 196 93.13% E 101-41000-131 Employer Paid Health$ 46,482 $ 37,759 $ 796 $ 8,723 81.23% E 101-41000-132 Dental Insurance$ 1,990 $ 1,535 $ - $ 455 77.13% E 101-41000-134 Employer Paid Life$ 643 $ 597 $ - $ 46 92.88% E 101-41000-135 Employer Paid Disability$ 960 $ 860 $ - $ 100 89.59% E 101-41000-151 Worker s Comp Insurance Prem$ 1,339 $ 1,837 $ - $ (498)137.19% E 101-41000-200 Office Supplies$ 1,133 $ 915 $ 122 $ 218 80.73% E 101-41000-203 Printed Forms & Papers$ 1,957 $ 3,655 $ 88 $ (1,698) 186.78%Newsletters $3,000 E 101-41000-210 Operating Supplies$ 824 $ 876 $ 193 $ (52) 106.25% 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 $ 33,953 $ 1,882 $ 31,047 52.24% E 101-41000-306 Personal Testing & Recruit$ - $ - $ - $ -0.00% American Legal Web Fee & OrdinanceE101-41000-308 Other Professional Services$ 5,000 $ 1,747 $ - $ 3,253 34.94% Updates E 101-41000-309 Software Support & Maintenance$ 18,746 $ 17,852 $ 677 $ 894 95.23% E 101-41000-316 Conferences & Seminars$ 721 $ 50 $ - $ 671 6.93% E 101-41000-317 Employee Training$ 206 $ - $ - $ 206 0.00% E 101-41000-319 Other Services$ 700 $ 935 $ 527 $ (235) 133.51% E 101-41000-321 Telephone$ 5,100 $ 5,540 $ 478 $ (440) 108.63% E 101-41000-322 Postage$ 2,200 $ 2,621 $ 77 $ (421) 119.11% E 101-41000-331 Travel Expenses$ 1,000 $ 711 $ 89 $ 289 71.12% E 101-41000-351 Legal Notices Publishing$ 1,500 $ 1,548 $ 42 $ (48)103.21% 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 $ 11,130 $ - $ 870 92.75% E 101-41000-413 Equipment Rental$ 1,800 $ 1,691 $ 89 $ 109 93.94% E 101-41000-430 Recycling$ - $ 80 $ - $ (80) 0.00% E 101-41000-433 Dues and Subscriptions$ 5,000 $ 1,877 $ - $ 3,123 37.54% E 101-41000-434 Youth Service Bureau$ 5,500 $ 5,500 $ - $ - 100.00% E 101-41000-435 Misc Expense$ - $ 14 $ - $ (14) 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 $ - $ (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% E 101-41000-720 Operating Transfers$ - $ 128,000 $ 128,000 $ (128,000) 125k toPark; $3k forCIP LED loan Total Admin & Finance Dept. Expenditures$ 450,499 $ 377,731 $ 29,061 $ 72,768 83.85% CITY OF SCANDIA Revenue - Expenditure Summary DECEMBER 2024 Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments GENERAL FUND CONT.CITY COUNCIL ExpendituresE 101-41110-101 Regular Wages & Salaries$ 20,772 $ 15,579 $ - $ 5,193 75.00% E 101-41110-122 FICA Employer Contribution$ 1,288 $ 246 $ - $ 1,042 19.11% E 101-41110-126 MEDICARE Employer Contribution$ 301 $ 174 $ - $ 127 57.76% E 101-41110-127 PERA Defined$ 703 $ 580 $ - $ 123 82.56% 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 $ 16,661 $ - $ 6,853 70.86% ELECTIONS ExpendituresE 101-41410-199 Election Judge$ 5,400.00 $ 6,533.02 $ 2,654.42 $ (1,133.02) 120.98% E 101-41410-200 Office Supplies$ 50.00 $ 54.04 $ 8.94 $ (4.04) 108.08% E 101-41410-203 Printed Forms & Papers$ - $ - $ - $ - 0.00% E 101-41410-210 Operating Supplies$ 750.00 $ 1,313 $ 133 $ (563) 175.03% E 101-41410-351 Legal Notices Publishing$ 200.00 $ 102.14 $ 46.32 $ 97.86 51.07% E 101-41410-413 Equipment Rental$ 1,700.00 $ 1,672.00 $ - $ 28.00 98.35% Wash. Cty. Equip. Maintenance Fee Total Elections Dept. Expenditures$ 8,100 $ 9,674 $ 2,842 $ (1,574) 119.43% PLANNING & BUILDING ExpendituresE 101-41910-101 Regular Wages & Salaries$ 60,010 $ 59,074 $ 6,733 $ 936 98.44% E 101-41910-121 PERA Coord. Employer Contribu.$ 4,263 $ 4,428 $ 505 $ 165) 103.88% E 101-41910-122 FICA Employer Contribution$ 3,721 $ 3,489 $ 405 $ 232 93.76% E 101-41910-126 MEDICARE Employer Contribution$ 870 $ 840 $ 95 $ 30 96.58% E 101-41910-131 Employer Paid Health$ 17,353 $ 16,144 $ 338 $ 1,209 93.03% E 101-41910-132 Dental Insurance$ 724 $ 658 $ - $ 66 90.86% E 101-41910-134 Employer Paid Life$ 173 $ 173 $ - $ 0 99.88% E 101-41910-135 Employer Paid Disability$ 416 $ 416 $ - $ 0 99.89% E 101-41910-203 Printed Forms & Papers$ 100 $ - $ - $ 100 0.00% E 101-41910-311 Contract Permit Inspections$ 60,000 $ 81,431 $ 11,347 $ (21,431) 135.72% E 101-41910-312 Planning Services$ 60,000 $ 51,991 $ 7,964 $ 8,010 86.65% E 101-41910-313 Committee & Commission Reimbur$ 5,200 $ 5,200 $ 1,050 $ 100.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 $ 3,624 $ - $ 1,376 72.49% E 101-41910-439 Refunds Issued$ - $ 169 $ - $ (169) 0.00% E 101-41910-720 Operating Transfers$ - $ - $ - $ - Total Planning & Building Dept. Expenditures$ 223,393 $ 232,603 $ 28,437 $ (9,210) 104.12% ASSESSOR ExpendituresE 101-41960-300 Assessor$ 23,200 $ 23,260 $ 2,000 $ (60) 100.26% POLICE ExpendituresE 101-42100-318 Police Contract$ 183,442 $ 183,442 $ 91,721 $ 0 100.00% 309 Code Red System; E 101-42100-319 Other Services$ 960 $ 1,189 $ - $ (229) 123.89% 880 Taco Daze Total GF Police Dept. Expenditures$ 184,402 $ 184,631 $ 91,721 $ (229) 100.12% CITY OF SCANDIA Revenue - Expenditure Summary DECEMBER 2024 Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments GENERAL FUND CONT.FIRE ExpendituresE 101-42200-101 Regular Wages & Salaries$ 160,554.00 $ 188,156.40 $ 15,832.07 $ (27,602.40) 117.19% E 101-42200-121 PERA Coord. Employer Contribu.$ - $ - $ - $ 0.00% E 101-42200-122 FICA Employer Contribution$ 9,954.00 $ 11,272.24 $ 794.20 $ (1,318.24) 113.24% E 101-42200-124 Police & Fire PERA$ 8,983.00 $ 10,112.55 $ 1,141.32 $ (1,129.55) 112.57% E 101-42200-126 MEDICARE Employer Contribution$ 2,328.00 $ 2,378.74 $ 232.48 $ (50.74) 102.18% E 101-42200-134 Employer Paid Life$ 192.00 $ 192.00 $ - $ - 100.00% 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.00 $ 6,249.00 $ - $ 5,751.00 52.08% E 101-42200-200 Office Supplies$ 200.00 $ 149.99 $ - $ 50.01 75.00% E 101-42200-203 Printed Forms & Papers$ - $ - $ - $ - 0.00% E 101-42200-209 Medical Supplies$ 3,500.00 $ 784.51 $ - $ 2,715.49 22.41% E 101-42200-210 Operating Supplies$ 8,800.00 $ 6,466.67 $ 49.55 $ 2,333.33 73.48% E 101-42200-211 Cleaning Supplies$ 100.00 $ - $ - $ 100.00 0.00% E 101-42200-212 Fuel$ 4,000.00 $ 4,692.67 $ 303.05 $ (692.67) 117.32% E 101-42200-217 Uniforms & Safety Equipment$ 10,000.00 $ 18,275.20 $ 166.92 $ (8,275.20) 182.75% new employee uniforms E 101-42200-221 Equipment Parts$ 1,500.00 $ - $ - $ 1,500.00 0.00% E 101-42200-222 Tires$ - $ - $ - $ - 0.00% E 101-42200-223 Structure Repair & Supplies$ 800.00 $ 48.84 $ - $ 751.16 6.11% E 101-42200-240 Small Tools and Minor Equip$ 22,195.00 $ 16,978.59 $ 323.97 $ 5,216.41 76.50% SCBA medical exams & flow testsE101-42200-305 Medical Services$ 5,600.00 $ 5,630.00 $ - $ (30.00) 100.54% E 101-42200-306 Personal Testing & Recruit$ 500.00 $ - $ - $ 500.00 0.00% E 101-42200-309 Software Support & Maintenance$ 17,000.00 $ 15,169.70 $ 144.00 $ 1,830.30 89.23% E 101-42200-310 Medical Training$ 2,000.00 $ 50.00 $ - $ 1,950.00 2.50% E 101-42200-316 Conferences & Seminars$ 250.00 $ - $ - $ 250.00 0.00% E 101-42200-317 Employee Training$ 12,000.00 $ 2,504.85 $ - $ 9,495.15 20.87% E 101-42200-319 Other Services$ 500.00 $ 105.00 $ - $ 395.00 21.00% E 101-42200-321 Telephone$ 7,000.00 $ 6,105.59 $ 535.49 $ 894.41 87.22% E 101-42200-322 Postage$ - $ 18.40 $ - $ (18.40) 0.00% E 101-42200-324 State of MN-Fire Relief$ 52,718.58 $ - $ - $ 52,718.58 0.00% E 101-42200-325 City Match-Fire Relief$ - $ - $ - $ - 0.00% E 101-42200-331 Travel Expenses$ 2,000.00 $ 1,818.13 $ - $ 181.87 90.91% Fire School travel costs MN Board ofFirefighter Training & E 101-42200-334 Licenses & Permits$ 500.00 $ 367.50 $ - $ 132.50 73.50% Education License E 101-42200-340 Advertising$ - $ - $ - $ - 0.00% E 101-42200-361 Liability/Property Ins$ 7,339.00 $ 7,207.65 $ - $ 131.35 98.21% E 101-42200-381 Utilities-Electric & Gas$ 8,000.00 $ 2,705.91 $ 186.83 $ 5,294.09 33.82% E 101-42200-384 Refuse/Garbage Disposal$ - $ 72.00 $ - $ (72.00) 0.00% E 101-42200-385 Sewer Pumping & Maintenance$ 550.00 $ 526.00 $ - $ 24.00 95.64% E 101-42200-401 Building Maintenance/Repairs$ 3,500.00 $ 2,348.20 $ 150.00 $ 1,151.80 67.09% E 101-42200-403 Improvements Other Than Bldgs$ - $ - $ - $ 0.00% E 101-42200-404 Repair Machinery/Equipment$ 8,500.00 $ 14,969.05 $ 2,067.53 $ (6,469.05) 176.11% E 101-42200-407 Well Repair & Maintenance$ - $ - $ - $ - 0.00% E 101-42200-433 Dues and Subscriptions$ 3,200.00 $ 3,245.39 $ - $ (45.39) 101.42% E 101-42200-438 Misc. Contractual$ 3,500.00 $ 3,125.32 $ 1,685.32 $ 374.68 89.29% E 101-42200-440 Events$ 1,000.00 $ 672.10 $ 162.95 $ 327.90 67.21% 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.00 $ 50.91 $ - $ 449.09 10.18% E 101-42200-570 Office Equipment$ 900.00 $ 1,078.27 $ - $ (178.27) 119.81% Total Fire Dept Expenditures$ 382,164 $ 333,527 $ 23,776 $ 48,636 87.27% ANIMAL CONTROL ExpendituresE 101-42700-314 Animal Control$ 6,000 $ 6,775 $ 706 $ (775)112.92% CITY OF SCANDIA Revenue - Expenditure Summary DECEMBER 2024 Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments GENERAL FUND CONT.PUBLIC WORKS ExpendituresE 101-43000-101 Regular Wages & Salaries$ 255,022 $ 267,024 $ 29,124 $ (12,002)104.71% E 101-43000-102 OT Regular Wages$ 5,014 $ 3,144 $ 52 $ 1,871 62.69% E 101-43000-104 Temporary Employee Wages$ 2,262 $ 612 $ 275 $ 1,650 27.06% E 101-43000-121 PERA Coord. Employer Contribu.$ 19,503 $ 19,602 $ 2,188 $ (99)100.51% E 101-43000-122 FICA Employer Contribution$ 16,262 $ 15,387 $ 1,765 $ 875 94.62% E 101-43000-126 MEDICARE Employer Contribution$ 3,803 $ 3,750 $ 413 $ 53 98.61% E 101-43000-131 Employer Paid Health$ 66,939 $ 59,528 $ 485 $ 7,411 88.93% E 101-43000-132 Dental Insurance$ 1,164 $ 1,061 $ - $ 103 91.16% E 101-43000-133 Union Training Center$ 1,872 $ 1,728 $ 216 $ 144 92.31% E 101-43000-134 Employer Paid Life$ 698 $ 717 $ - $ (19) 102.67% E 101-43000-135 Employer Paid Disability$ 1,365 $ 1,408 $ - $ (43)103.17% 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 $ 58 $ - $ (8) 116.66% E 101-43000-210 Operating Supplies$ 8,500 $ 5,161 $ 1,209 $ 3,339 60.72% E 101-43000-212 Fuel$ 25,000 $ 25,383 $ 2,250 $ (383) 101.53% E 101-43000-217 Uniforms & Safety Equipment$ 2,300 $ 1,903 $ 685 $ 397 82.72% E 101-43000-221 Equipment Parts$ 17,000 $ 26,034 $ 13,507 $ (9,034) 153.14% Loader parts $9,932 E 101-43000-222 Tires$ 7,500 $ 5,705 $ 951 $ 1,795 76.07% E 101-43000-223 Structure Repair & Supplies$ 2,000 $ - $ - $ 2,000 0.00% E 101-43000-224 Materials for Road Maintenance$ 7,000 $ 16,849 $ - $ (9,849)240.70% Cold Patch; New Streetlight Flags E 101-43000-226 Sign Replacement and Repair$ 750 $ 494 $ - $ 256 65.93% E 101-43000-228 Gravel$ 10,000 $ 330 $ - $ 9,670 3.30% E 101-43000-229 Salt$ 22,000 $ 14,847 $ 2,472 $ 7,153 67.49% E 101-43000-240 Small Tools and Minor Equip$ 8,000 $ 8,121 $ - $ (121)101.51% E 101-43000-302 Surveying$ - $ - $ - $ - 0.00% E 101-43000-303 Engineering Fees$ 10,500 $ 9,246 $ 267 $ 1,254 88.06% E 101-43000-304 Legal Services$ - $ - $ - $ - 0.00% E 101-43000-305 Medical Services$ 1,000 $ 65 $ - $ 935 6.52% E 101-43000-309 Software Support & Maintenance$ 6,000 $ 331 $ - $ 5,669 5.51% E 101-43000-317 Employee Training$ 1,500 $ 579 $ - $ 921 38.63% E 101-43000-319 Other Services$ 7,000 $ 4,227 $ 12 $ 2,773 60.38% E 101-43000-321 Telephone$ 4,000 $ 4,254 $ 358 $ (254) 106.35% 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 $ 2,062 $ 144 $ 3,938 34.37% E 101-43000-384 Refuse/Garbage Disposal$ - $ 120 $ - $ (120)0.00% holding tank & floor drainoil 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 $ 4,278 $ 334 $ (78) 101.87% E 101-43000-401 Building Maintenance/Repairs$ 6,000 $ 3,834 $ 295 $ 2,166 63.90% E 101-43000-403 Improvements Other Than Bldgs$ - $ - $ - $ 0.00% E 101-43000-404 Repair Machinery/Equipment$ 25,000 $ 10,063 $ 300 $ 14,937 40.25% E 101-43000-405 Contractual Road Maint/Repair$ 200,000 $ 131,264 $ - $ 68,736 65.63% E 101-43000-407 Well Repair & Maintenance$ 500 $ - $ - $ 500 0.00% E 101-43000-413 Equipment Rental$ 4,000 $ 169 $ - $ 3,831 4.23% E 101-43000-417 Uniform Rental$ 1,200 $ 964 $ 82 $ 236 80.35% E 101-43000-433 Dues and Subscriptions$ 200 $ - $ - $ 200 0.00% E 101-43000-438 Misc. Contractual$ 16,000 $ 9,817 $ 758 $ 6,183 61.36% 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$ - $ - $ - $ - Total Public Works Dept. Expenditures$ 826,270 $ 695,521 $ 58,140 $ 130,749 84.18% CITY OF SCANDIA Revenue - Expenditure Summary DECEMBER 2024 Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments GENERAL FUND CONT.PARKS & RECREATION ExpendituresE 101-45000-101 Regular Wages & Salaries$ 11,328 $ 10,982 $ 1,269 $ 346 96.94% E 101-45000-104 Temporary Employee Wages$ 39,985 $ 21,469 $ 2,474 $ 18,516 53.69% E 101-45000-121 PERA Coord. Employer Contribu.$ 850 $ 823 $ 95 $ 27 96.81% E 101-45000-122 FICA Employer Contribution$ 3,181 $ 1,975 $ 229 $ 1,206 62.09% E 101-45000-126 MEDICARE Employer Contribution$ 744 $ 468 $ 54 $ 276 62.96% E 101-45000-131 Employer Paid Health$ 2,562 $ 2,140 $ 18 $ 422 83.53% E 101-45000-132 Dental Insurance$ 42 $ 35 $ - $ 7 83.81% E 101-45000-134 Employer Paid Life$ 27 $ 27 $ - $ 0 99.56% E 101-45000-135 Employer Paid Disability$ 76 $ 55 $ - $ 21 72.16% E 101-45000-141 Unemployment Compensation$ - $ 16 $ - $ 16) 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 $ 848 $ 26 $ 152 84.78% E 101-45000-212 Fuel$ 1,000 $ 138 $ - $ 862 13.80% E 101-45000-221 Equipment Parts$ 2,500 $ 1,148 $ - $ 1,352 45.92% E 101-45000-223 Structure Repair & Supplies$ 2,500 $ 138 $ - $ 2,362 5.52% E 101-45000-240 Small Tools and Minor Equip$ 500 $ 148 $ - $ 352 29.64% E 101-45000-312 Planning Services$ - $ - $ - $ - 0.00% E 101-45000-313 Committee & Commission Reimbur$ - $ 900 $ 180 $ 900) 0.00% E 101-45000-319 Other Services$ 1,750 $ 1,464 $ - $ 286 83.68% 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 $ 3,504 $ 568 $ 2,996 53.90% E 101-45000-384 Refuse/Garbage Disposal$ 5,000 $ 4,053 $ 149 $ 947 81.07% E 101-45000-385 Sewer Pumping & Maintenance$ 1,250 $ 1,260 $ - $ (10)100.78% Lighted ballfield fence repair - insurance E 101-45000-401 Building Maintenance/Repairs$ 6,000 $ 4,858 $ 150 $ 1,142 80.96% 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 $ 507 $ - $ 493 50.67% E 101-45000-406 Grounds Care$ 4,000 $ 2,535 $ - $ 1,465 63.37% Liten & Lilleskogen Pakrs; Watercraft E 101-45000-438 Misc. Contractual$ 8,000 $ 11,251 $ 2,793 $ (3,251) 140.64% Inspections E 101-45000-439 Refunds Issued$ - $ - $ - $ - 0.00% E 101-45000-440 Events$ 7,000 $ 3,196 $ 104 $ 3,804 45.66% E 101-45000-490 Financial Assistance$ - $ - $ - $ - 0.00% E 101-45000-530 Capital Impr Other Than Bldgs$ 9,900 $ 10,210 $ 5,996 $ (310)103.13% E 101-45000-720 Operating Transfers$ - $ - $ - $ - Total Parks & Rec Dept. Expenditures$ 125,684 $ 92,723 $ 14,105 $ 32,961 73.77% CITY OF SCANDIA Revenue - Expenditure Summary DECEMBER 2024 Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments GENERAL FUND CONT.COMMUNITY CENTER ExpendituresE 101-45180-101 Regular Wages & Salaries$ 16,600 $ 16,503 $ 1,866 $ 97 99.41% E 101-45180-104 Temporary Employee Wages$ - $ - $ - $ - 0.00% E 101-45180-121 PERA Coord. Employer Contribu.$ 1,245 $ 1,210 $ 140 $ 35 97.19% E 101-45180-122 FICA Employer Contribution$ 1,029 $ 968 $ 112 $ 61 94.05% E 101-45180-126 MEDICARE Employer Contribution$ 241 $ 236 $ 26 $ 5 97.90% E 101-45180-131 Employer Paid Health$ 3,692 $ 2,911 $ - $ 781 78.84% E 101-45180-134 Employer Paid Life$ 43 $ 43 $ - $ (0)100.47% E 101-45180-135 Employer Paid Disability$ 95 $ 104 $ - $ 9) 109.58% E 101-45180-151 Worker s Comp Insurance Prem$ - $ 152 $ - $ (152)0.00% E 101-45180-210 Operating Supplies$ 2,900 $ 4,185 $ 591 $ (1,285) 144.30%ECOLAB kitchen cleaning $2,163 E 101-45180-223 Structure Repair & Supplies$ 4,000 $ 335 $ - $ 3,665 8.37% E 101-45180-321 Telephone$ - $ 850 $ 318 $ (850) 0.00%Annex internet paid by Lions 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 $ 5,867 $ 923 $ 3,268 64.22% E 101-45180-384 Refuse/Garbage Disposal$ - $ 156 $ - $ (156)0.00% E 101-45180-385 Sewer Pumping & Maintenance$ 4,000 $ 3,233 $ - $ 767 80.84% E 101-45180-401 Building Maintenance/Repairs$ 15,000 $ 15,402 $ 591 $ (402)102.68% E 101-45180-404 Repair Machinery/Equipment$ 5,000 $ 505 $ 150 $ 4,495 10.09% E 101-45180-406 Grounds Care$ 1,300 $ 237 $ 120 $ 1,063 18.22% E 101-45180-407 Well Repair & Maintenance$ 1,000 $ - $ - $ 1,000 0.00% Seasonal lightingE101-45180-438 Misc. Contractual$ 3,500 $ 1,846 $ 346 $ 1,654 52.75% E 101-45180-439 Refunds Issued$ - $ - $ - $ - 0.00% E 101-45180-520 Capital Improvements to Bldgs$ 9,900 $ 7,121 $ 7,121 $ 2,779 71.93%portable stage 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$ - $ - $ - $ - $ Total Community Center Dept. Expenditures$ 80,515 $ 63,619 $ 12,304 $ 16,896 79.01% TOTAL GENERAL FUND EXPENDITURES$ 2,333,741 $ 2,036,725 $ 263,092 $ 297,016 79.01% E 101-49000-421 Cash Over/Short Operating TransfersE 101-49000-720 Operating Transfers$ 9,086,031 $ 725,000 $ (9,086,031) 0.00% TOTAL GENERAL FUND EXPENDITURES W/TRANSFERS$ 2,333,741 $ 11,122,756 $ 988,092 $ (8,789,015) CITY OF SCANDIA Revenue - Expenditure Summary DECEMBER 2024 Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments COVID RELIEF FUND RevenueR 203-46200-33150 Federal Grant$ - $ - $ - $ - 0.00% ExpendituresE 203-49000-720 Operating Transfers$ - $ 466,422 $ 466,422 $ (466,422) 0.00% EDA FUND RevenueR 225-46500-31000 Washington Cty. Tax Settlement$ 5,300 $ 5,300 $ - $ 0.00% R 225-46500-33640 Other Grants$ - $ - $ - $ - 0.00% R 225-46500-34750 Facilities Rental$ - $ 750 $ - $ (750) 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$ 39,716$ -$ (34,316)735.48% ExpenditureE 225-46500-210 Operating Supplies$ 300 $ 23 $ - $ 277 7.74% E 225-46500-303 Engineering Fees$ - $ - $ - $ - 0.00% E 225-46500-304 Legal Services$ - $ - $ - $ - 0.00% E 225-46500-308 Other Professional Services$ 100 $ - $ - $ 100 0.00% EDAM Membership; Sister City DuesE225-46500-340 Advertising$ 1,500 $ - $ - $ 1,500 0.00% E 225-46500-433 Dues and Subscriptions$ 1,203 $ 364 $ - $ 839 30.26% E 225-46500-440 Events$ 1,500 $ 1,391 $ 545 $ 109 92.70% E 225-46500-720 Operating Transfers$ - $ 33,356 $ - $ (33,356) 0.00% closed checking account Total EDA Fund Expenditures$ 4,603$ 35,111$ 545$ (30,531)762.78% CABLE TV FUND RevenueR 226-41950-36210 Interest Income$ 100.00 $ - $ - $ 100.00 0.00% R 226-41950-36260 Sale of Equipment$ - $ - $ - $ - 0.00% R 226-41950-38050 Cable TV Franchise Rebates$ 16,700.00 $ 16,945 $ 1,628 $ (245) 101.47% R 226-41950-38051 PEG Fees$ 4,400.00 $ 5,917 $ 418 $ (1,517) 134.47% Total Cable TV Fund Revenue$ 21,200$ 22,862$ 2,046$ (1,662)107.84% ExpenditureE 226-41950-240 Small Tools and Minor Equip$ 300 $ - $ - $ 300 0.00% E 226-41950-309 Software Support & Maintenance$ 3,500 $ 4,052 $ 773 $ 552) 115.76% Boxcast storage & AV Repair E 226-41950-438 Misc. Contractual$ 7,750 $ 9,089 $ (29) $ (1,339) 117.28%LATV filming & Zoom service E 226-41950-570 Office Equipment$ - $ - $ - $ - 0.00% Total Cable TV Fund Expenditures$ 11,550$ 13,141$ 744$ (1,591)113.77% CITY OF SCANDIA Revenue - Expenditure Summary DECEMBER 2024 Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments PUBLIC SAFETY AID RevenueR 240-42400-33422 Other State Grants & Aids$ - $ - $ - $ 0.00% ExpenditureE 240-42400-720 Operating Transfers$ - $ 176,529 $ 176,529 $ (176,529) 0.00% 2018 STREET RECONSTRUCTION RevenueR 318-47000-31000 Washington Cty. Tax Settlement$ 345,634 $ 345,634 $ - $ 100.00% ExpenditureE 318-47000-601 Long Term Debt Principal$ 245,000 $ 245,000 $ 245,000 $ 100.00% E 318-47000-611 Long Term Debt Interest$ 84,175 $ 84,175 $ 42,088 $ (0) 100.00% E 318-47000-620 Fiscal Agent s Fees$ 495 $ 1,045 $ - $ (550) 211.11% Total 2018 Street Reconstruction Fund Expenditures$ 329,670 $ 330,220 $ 287,088 $ (550)100.17% 2024 STREET RECONSTRUCTION RevenueR 324-47000-31000 Washington Cty. Tax Settlement$ - $ - $ - $ 0.00% R 324-47000-36210 Interest Income$ - $ 54,051 $ 2,959 $ (54,051) 0.00% R 324-47000-39203$ - $ 1,082,511 $ 1,082,511 $ (1,082,511) Total 2024 Street Reconstruction Fund Revenue$ -$ 1,136,562$ 1,085,470$ (1,136,562) 0.00% ExpenditureE 324-47000-601 Long Term Debt Principal$ - $ - 0.00% E 324-47000-611 Long Term Debt Interest$ - 0.00% E 324-47000-620 Fiscal Agent s Fees$ 495 $ - $ 495 0.00% 432,940 $ 41,908 $ (432,940) Total 2024 Street Reconstruction Fund Expenditures$ 495 $ 432,940 $ 41,908 $ (432,445)87462.58% CAPITAL IMPROVEMENTS RevenueR 401-48000-31000 Washington Cty. Tax Settlement$ 235,000 $ 235,000 $ - $ 100.00% R 401-48000-33422 Other State Grants & Aids$ - $ 34,110 $ - $ (34,110) 0.00% Cty Gateway Tr.Grant; CMSWD R 401-48000-33640 Other Grants$ - $ 21,750 $ - $ (21,750) 0.00% Stormwater Quality Grant R 401-48000-36210 Interest Income$ 3,000 $ - $ - $ 3,000 0.00% Total Capital Improvement Fund Revenue$ 238,000 $ 290,860 $ -$ (52,860)122.21% 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 $ 300,000 $ 300,000 $ (50,000) 120.00%Midco Cost Sharing Agreement E 401-42200-520 Capital Improvements to Bldgs$ - $ 26,500 $ 9,500 $ (26,500)0.00%Cold Storage Building E 401-43000-520 Capital Improvements to Bldgs$ - $ 79,500 $ 28,500 $ (79,500) 0.00%Cold Storage Building E 401-45180-520 Capital Improvements to Bldgs$ 67,548 $ 47,545 $ - $ 20,003 70.39% E 401-48000-303 Engineering Fees$ - $ 104,037 $ 27,730 $ (104,037) 0.00%Gateway Trail Engineering E 401-48000-308 Other Professional Services$ - $ (9,600) $ (14,400) $ 9,600 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% Tranfer to Park Cap Fund CourtsE401-48000-720 Operating Transfers$ - $ 300,000 $ 150,000 $ (300,000) 0.00% 477,548 $ 847,982 $ 501,330 $ (370,434) 177.57% CITY OF SCANDIA Revenue - Expenditure Summary DECEMBER 2024 Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments PARK DEVELOPMENT RevenueR 404-48000-31000 Washington Cty. Tax Settlement$ 60,000 $ 60,000 $ - $ 100.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-36210 Interest Income$ 66 $ - $ - $ 66 0.00% R 404-48000-36230 Donations$ - $ - $ - $ - 0.00% R 404-48000-39203 Transfer from Other Funds$ - $ 425,000 $ 275,000 $ (425,000) 0.00%Transfers from Gen & Cap Impr Funds Total Park Development Fund Revenue$ 60,066$ 586,250 $ 275,000 $ (526,184)976.01% ExpenditureE 404-48000-312 Planning Services$ - $ - $ - $ 0.00% E 404-48000-303 Engineering Fees$ - $ 69,714 $ 10,226 $ (69,714) 0.00%Courts E 404-48000-308 Other Professional Services$ - $ 410 $ - $ (410)0.00% E 404-48000-520 Capital Improvements to Bldgs$ - $ - $ - $ 0.00% E 404-48000-530 Capital Impr Other Than Bldgs$ 150,000 $ 292,997 $ - $ (142,997) 195.33%Courts E 404-48000-720 Operating Transfers$ - $ - $ - $ - 0.00% Total Park Development Fund Expenditures$ 150,000 $ 363,121 $ 10,226 $ (213,121)242.08% EQUIPMENT REPLACEMENT RevenueR 406-48500-31000 Washington Cty. Tax Settlement$ 110,000 $ 110,000 $ - $ 100.00% R 406-48500-36210 Interest Income$ 1,045 $ - $ - $ 1,045 0.00% Saleof2014 F550, Fire boat & utility R 406-48500-36260 Sale of Equipment$ - $ 45,100 $ 16,550 $ (45,100) 0.00% truck Transfers from ARPA & Public Safety Aid R 406-48500-39350 Certificate of Indebtedness$ 350,000 $ 674,894 $ 674,894 $ (674,894) 0.00%Funds Total Equipment Replacement Fund Revenue$ 461,045 $ 829,994 $ 691,444 $ (718,949)180.02% FDPumper & Rescue Boat; Drum ExpenditureE 406-48500-540 Heavy Machinery Capital$ 867,000 $ 356,291 $ 91,987 $ 510,709 41.09% Mulcher & Skit Steer E 406-48500-550 Motor Vehicles Capital$ 84,356 $ 161,429 $ - $ (77,073) 191.37% FD Utility Truck; PW F-550 Truck Total Equipment Replacement Fund Expenditures$ 951,356 $ 517,720 $ 91,987 $ 433,63654.42% LOCAL ROAD IMPROVEMENT FUND RevenueR 408-43100-31000 Washington Cty. Tax Settlement$ 375,000 $ 375,000 $ - $ 100.00% R 408-43100-33422 Other State Grants & Aids$ - $ 69,413 $ 6,332 $ (69,413) 0.00%Small Cities Assist Grant Deferred SA Paid OffR408-43100-36100 Special Assessments$ - $ 7,560 $ - $ (7,560) 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.00$3,868,541.90$0.00$131,458.1096.71% Total LRIF Revenue$ 4,385,705$ 4,320,515$ 6,332$ 65,190 98.51% ExpenditureE 408-43100-303 Engineering Fees$ 120,000 $ 351,896 $ 11,837 $ (231,896) 293.25% 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,814,847 $ - $ 760,153 78.74% Balance ofBond proceeds transferred to E 408-43100-720$ - $ 1,082,511 $ 1,082,511 $ (1,082,511) Debt Fund 324 Total LRIF Expenditures$ 3,695,000 $ 4,249,688 $ 1,094,348 $ (554,688) 115.01% CITY OF SCANDIA Revenue - Expenditure Summary DECEMBER 2024 Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments BLISS SEWER RevenueR 602-43210-31951 Special Assessments Principal$ - $ 2,983 $ - $ 2,983) 0.00% R 602-43210-31952 SA Penalties & Interest$ 420 $ 477 $ - $ 57) 113.66% R 602-43210-33422 Other State Grants & Aids$ - $ - $ - $ -0.00% R 602-43210-34401 Sewer User Fees$ 125,230 $ 102,070 $ 14,622 $ 23,160 81.51% 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$ - $ 382 $ 50 $ (382)0.00% R 602-43210-36210 Interest Income$ 210 $ - $ - $ 210 0.00% Total BLISS Sewer Revenue$ 125,860 $ 105,959 $ 14,672 $ 19,901 84.19% ExpenditureE 602-43210-101 Regular Wages & Salaries$ 17,458 $ 15,613 $ 2,492 $ 1,845 89.43% E 602-43210-120 Pension Expense$ - $ - $ - $ - 0.00% E 602-43210-121 PERA Coord. Employer Contribu.$ 1,309 $ 1,170 $ 187 $ 139 89.36% E 602-43210-122 FICA Employer Contribution$ 1,082 $ 917 $ 150 $ 165 84.79% E 602-43210-126 MEDICARE Employer Contribution$ 253 $ 265 $ 35 $ 12) 104.59% E 602-43210-131 Employer Paid Health$ - $ - $ - $ - 0.00% E 602-43210-151 Worker s Comp Insurance Prem$ 525 $ 716 $ - $ 191) 136.38% E 602-43210-200 Office Supplies$ 91 $ 102 $ - $ (11) 112.31% E 602-43210-210 Operating Supplies$ 700 $ 361 $ 320 $ 339 51.61% E 602-43210-240 Small Tools and Minor Equip$ 420 $ - $ - $ 420 0.00% E 602-43210-303 Engineering Fees$ 7,718 $ 78,211 $ 415 $ (70,493) 1013.36% Nitrate Treatment Project E 602-43210-304 Legal Services$ - $ - $ - $ - 0.00% E 602-43210-308 Other Professional Services$ 3,500 $ 37,791 $ 17,274 $ (34,291) 1079.74%Lobbying Service; Water Testing E 602-43210-309 Software Support & Maintenance$ 910 $ 529 $ 529 $ 381 58.15% E 602-43210-317 Employee Training$ 980 $ 598 $ - $ 382 61.05% E 602-43210-321 Telephone$ 1,750 $ 1,649 $ - $ 101 94.22% 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 $ 1,243 $ 191 $ 857 59.17% E 602-43210-385 Sewer Pumping & Maintenance$ 14,000 $ 17,075 $ - $ (3,075) 121.96% E 602-43210-386 Operation & Maintenance$ 3,500 $ 1,546 $ 514 $ 1,954 44.16% 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% E 602-43210-438 Misc. Contractual$ 7,000 $ 3,170 $ - $ 3,830 45.29% E 602-43210-439 Refunds Issued$ - $ - $ - $ - 0.00% E 602-43210-530 Capital Impr Other Than Bldgs$ 6,930 $ - $ - $ 6,930 0.00% 30% ofFund Balance moved tonew A-E E 602-43210-720 Operating Transfers$ - $ 17,584 $ - $ (17,584) 0.00% Fund 624 Total BLISS Sewer Expenditures$ 127,606 $ 184,116 $ 22,107 $ (56,510)144.29% CITY OF SCANDIA Revenue - Expenditure Summary DECEMBER 2024 Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments UPTOWN SEWER RevenueR 612-43210-34401 Sewer User Fees$ 22,400 $ 19,380 $ - $ 3,020 86.52% R 612-43210-36210 Interest Income$ 50 $ - $ - $ 50 0.00% Total Uptown Sewer Revenue$ 22,450$ 19,380$ -$ 3,070 86.32% ExpenditureE 612-43210-101 Regular Wages & Salaries$ 10,725 $ 8,607 $ 1,201 $ 2,118 80.25% E 612-43210-120 Pension Expense$ - $ - $ - $ - 0.00% E 612-43210-121 PERA Coord. Employer Contribu.$ 804 $ 645 $ 90 $ 159 80.17% E 612-43210-122 FICA Employer Contribution$ 665 $ 505 $ 72 $ 160 75.89% E 612-43210-126 MEDICARE Employer Contribution$ 156 $ 124 $ 17 $ 32 79.70% E 612-43210-151 Worker s Comp Insurance Prem$ 300 $ 522 $ - $ 222) 174.00% E 612-43210-200 Office Supplies$ 100 $ 35 $ - $ 65 34.64% 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 $ 84 $ 100.00% E 612-43210-317 Employee Training$ 200 $ 1,138 $ - $ (938) 568.82% 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 $ 1,464 $ - $ (962)291.61% E 612-43210-381 Utilities-Electric & Gas$ 1,000 $ 399 $ 78 $ 601 39.88% E 612-43210-385 Sewer Pumping & Maintenance$ 1,500 $ 1,484 $ - $ 17 98.90% E 612-43210-386 Operation & Maintenance$ 1,000 $ 546 $ - $ 454 54.59% 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 $ - $ 911 39.26% E 612-43210-530 Capital Impr Other Than Bldgs$ 9,900 $ - $ - $ 9,900 0.00% 2,640 $ - $ - $ 2,640 0.00% E 612-43210-720 Operating Transfers Total Uptown Sewer Expenditures$ 42,526$ 16,680$ 1,542$ 25,846 39.22% A-E SEWER RevenueR 624-43210-31952 SA Penalties & Interest$ 180 $ - $ - $ 180 0.00% R 624-43210-34401 Sewer User Fees$ 53,670 $ 42,099 $ 6,556 $ 11,571 78.44% R 624-43210-36102 Penalties and Interest$ - $ 90 $ 20 $ 90) 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 $ 59,772 $ 6,576 $ (5,832) 110.81% ExpenditureE 624-43210-101 Regular Wages & Salaries$ 7,482 $ 5,457 $ 323 $ 2,025 72.94% E 624-43210-121 PERA Coord. Employer Contribu.$ 561 $ 409 $ 24 $ 152 72.98% E 624-43210-122 FICA Employer Contribution$ 464 $ 320 $ 19 $ 144 68.96% E 624-43210-126 MEDICARE Employer Contribution$ 108 $ 39 $ 5 $ 69 36.54% E 624-43210-131 Employer Paid Health$ - $ - $ - $ - 0.00% E 624-43210-151 Worker s Comp Insurance Prem$ 225 $ 67 $ - $ 158 29.78% 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 $ 227 $ 227 $ 163 58.15% E 624-43210-317 Employee Training$ 420 $ 109 $ - $ 311 25.99% E 624-43210-321 Telephone$ 750 $ 1,131 $ 280 $ (381) 150.84% 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 $ 462 $ 34 $ 438 51.31% E 624-43210-385 Sewer Pumping & Maintenance$ 6,000 $ 3,690 $ - $ 2,310 61.50% E 624-43210-386 Operation & Maintenance$ 1,500 $ 1,032 $ - $ 468 68.80% E 624-43210-404 Repair Machinery/Equipment$ 4,800 $ 3,289 $ - $ 1,511 68.53% E 624-43210-413 Equipment Rental$ 300 $ - $ - $ 300 0.00% E 624-43210-420 Depreciation Expense$ 17,400 $ - $ - $ 17,400 0.00% E 624-43210-438 Misc. Contractual$ 3,000 $ 5,008 $ - $ (2,008) 166.94% E 624-43210-530 Capital Impr Other Than Bldgs$ 2,970 $ - $ - $ 2,970 0.00% Total A-E Sewer Expenditures$ 51,380$ 22,890$ 913$ 28,490 44.55%