Press Alt + R to read the document text or Alt + P to download or print.
This document contains no pages.
06.b Treasurer's ReportCity of Scandiaaug
Treasurer’sReport
January 31, 2024
FUNDACCOUNTING
Beginning CashBalance $ 3,559,685.061/1/2024
BeginningCheckingBalance$ 303,425.97
CheckingReceipts 88,357.53
Transfers toChecking 350,000.00
TotalDeposits 438,357.53
Expenditures 337,722.87)
Payroll$ (70,559.14)
TransferstoMoneyMarket$ -
TotalPayments 408,282.01)
Ending CheckingBalance 333,501.49
Beginning MoneyMarketBalance 1,129,409.02
MoneyMarketReceipts 897.66
TransfertoChecking 350,000.00)
TransferfromChecking
EndingMoneyMarket Balance 780,306.68
BeginningInvestmentsBalance 2,103,152.07
InvestmentsReceipts 10,067.76
EndingInvestmentsBalance$ 2,113,219.83
Beginning EDABalance$ 33,356.07
EDAReceipts
EDAExpenditures
EDADe;positinTransit
EDATransfers fromChecking
EndingEDABalance$ 33,356.07
Outstanding Checks 5,451.19)
1/31/2024EndingCashBalance $ 3,254,932.88
CHECKING, MONEYMARKET & INVESTMENTCD's
Checking *102$ 303,425.97BegBal
Credits$ 438,357.53
Debits$ (408,282.01)
Transfer inTransit
333,501.49EndBal
MoneyMarket *105 - Rate1.25%$ 1,129,409.02BegBal
ratechangefrom .25% Credits 897.66
Debits 350,000.00)
EndBal$ 780,306.68
Investments
CD *4422 - Rate4.00% 12mo., 3/25/2024 $ 327,492.36
CD *4424 - Rate4.50% 12mo., 7/27/2024 $ 462,733.06
CD *4425 - Rate5.10% 12mo., 9/28/2024$ 765,165.11
CD *4426 - Rate5.10% 9mo., 10/30/2024 557,829.30
TotalInvestments$ 2,113,219.83
TotalBank & Investment Accounts 3,227,028.00
5,451.19) ChecksinTransit *3102
TransfertoEDAinTransit
Depositintransitmoneymarket
3,221,576.81TotalAdjustedUndesignatedFunds
ScandiaEDA *6301 $ 33,356.07
Receipts
Expenditures
ChecksinTransit
DepositinTransit
TotalDesignated EDAFunds$ 33,356.07
TotalFunds$ 3,254,932.88
Submitted by: ColleenFirkus, Treasurer
2024 CASH BALANCES
END OF MONTH
FUNDJANUARY
101 GENERAL$1,379,620
203 COVID-19 RELIEF$456,363
226 CABLE TV$21,223
230 GATEWAY TRAIL$0
240 PUBIC SAFETY AID$176,529
313 EQUIPMENT CERTIFICATES$31,943
318 BLACKTOP PROJECT$61,100
401 CAPITAL IMPR$757,508
404 PARK CAP IMPR-$15,577
406 EQUIPMENT REPLACEMENT$133,663
408 LOCAL ROAD IMPROVEMENT$120,442
602 BIG MARINE SEWER$65,723
612 UPTOWN SEWER$15,868
801 ESCROW$17,172
SUBTOTAL$3,221,577
225 EDA$33,356
TOTAL$3,254,933
CITY OF SCANDIA
Revenue - Expenditure Summary
JANUARY 2024
Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments
GENERAL FUND
RevenueR 101-41000-31000 Washington Cty. Tax Settlement$ 1,865,916 $ 36,655 $ 36,655 $ 1,829,261 1.96%
R 101-41000-31040 Fiscal Disparities$ 107,857 $ 557 $ 557 $ 107,300 0.52%
R 101-41000-31701 Gravel Taxes$ 20,000 $ - $ - $ 20,000 0.00%
R 101-41000-31830 Solar Energy Production Tax$ 5,500 $ - $ - $ 5,500 0.00%
R 101-41000-31900 Penalties & Interest Del Tax$ 1,000 $ - $ - $ 1,000 0.00%
R 101-41000-32150 ROW Utility Permit$ 5,000 $ - $ - $ 5,000 0.00%
R 101-41000-32180 Tobacco & Liquor Licenses$ 11,000 $ 3,725 $ 3,725 $ 7,275 33.86%
R 101-41000-32190 Other City Permits$ 3,000 $ - $ - $ 3,000 0.00%
R 101-41000-32210 Building Permits$ 160,000 $ 13,726 $ 13,726 $ 146,274 8.58%
R 101-41000-32260 Gambling Permits$ 100 $ - $ - $ 100 0.00%
R 101-41000-33401 LGA/MVHC/AG/PERA Aid$ 7,000 $ 286 $ 286 $ 6,714 4.08%
R 101-41000-33420 Fire Relief State PERA$ 40,474 $ - $ - $ 40,474 0.00%
R 101-41000-33422 Other State Grants & Aids$ 6,000 $ 6,600 $ 6,600 $ (600) 110.00%Fire Training grants
R 101-41000-33428 PILOT$ 6,000 $ 44 $ 44 $ 5,956 0.74%
R 101-41000-33620 Recycling Grant$ 11,000 $ - $ - $ 11,000 0.00%
R 101-41000-33630 Local Govt Grants & Aids$ - $ - $ - $ - 0.00%
R 101-41000-33640 Other Grants$ 1,200 $ - $ - $ 1,200 0.00%
R 101-41000-34103 Zoning and Planning$ 5,000 $ 700 $ 700 $ 4,300 14.00%
R 101-41000-34106 Engineering Fees$ - $ - $ - $ - 0.00%
R 101-41000-34107 Assessment Search Fees$ 20 $ - $ - $ 20 0.00%
R 101-41000-34109 Water Usage$ 100 $ - $ - $ 100 0.00%
R 101-41000-34201 Impound Fees$ - $ - $ - $ - 0.00%
R 101-41000-34202 Fire Protection Services$ 33,915 $ - $ - $ 33,915 0.00%
R 101-41000-34301 Damage Repairs$ - $ - $ - $ - 0.00%
R 101-41000-34303 Dust Control$ 3,630 $ - $ - $ 3,630 0.00%
R 101-41000-34304 Reimbursement for Services$ 1,000 $ - $ - $ 1,000 0.00%
R 101-41000-34305 Other Street Services$ - $ - $ - $ - 0.00%
R 101-41000-34730 Ad Revenue$ 1,000 $ - $ - $ 1,000 0.00%
R 101-41000-34750 Facilities Rental$ 7,400 $ 200 $ 200 $ 7,200 2.70%
R 101-41000-34760 Cleaning Fees$ - $ - $ - $ - 0.00%
R 101-41000-34790 Recreation Programs$ 1,500 $ 10 $ 10 $ 1,490 0.67%
R 101-41000-35101 Fines & Forfeitures$ 7,000 $ 1,045 $ 1,045 $ 5,955 14.93%
distributed among funds at EOYR101-41000-36210 Interest Income$ 5,636 $ 10,969 $ 10,969 $ (5,333) 194.62%
R 101-41000-36230 Donations$ 5,000 $ 38 $ 38 $ 4,962 0.76%
R 101-41000-36240 Insurance Dividend$ 4,000 $ - $ - $ 4,000 0.00%
R 101-41000-36250 Misc. Refund$ 2,000 $ - $ - $ 2,000 0.00%
Total General Fund Revenue$ 2,328,248 $ 74,555 $ 74,555 $ 2,253,693 3.20%
Operating TransfersR 101-41000-39200 Interfund Operating Transfer$ -
R 101-49000-39203 Transfer from Other Funds$ -
R 101-49000-39204 Money Market Transfer$ - $ 350,000 $ 350,000 $ (350,000)
Total Operating Transfers$ 350,000$ 350,000$ (350,000)
CITY OF SCANDIA
Revenue - Expenditure Summary
JANUARY 2024
Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments
GENERAL FUND
ExpenditureADMINISTRATION & FINANCE
E 101-41000-101 Regular Wages & Salaries$ 196,713 $ 20,531 $ 20,531 $ 176,182 10.44%
E 101-41000-121 PERA Coord. Employer Contribu.$ 13,801 $ 1,540 $ 1,540 $ 12,261 11.16%
E 101-41000-122 FICA Employer Contribution$ 12,196 $ 1,243 $ 1,243 $ 10,953 10.19%
E 101-41000-126 MEDICARE Employer Contribution$ 2,852 $ 291 $ 291 $ 2,561 10.19%
E 101-41000-131 Employer Paid Health$ 46,482 $ 3,147 $ 3,147 $ 43,335 6.77%
E 101-41000-132 Dental Insurance$ 1,990 $ 128 $ 128 $ 1,862 6.43%
E 101-41000-134 Employer Paid Life$ 643 $ 50 $ 50 $ 593 7.71%
E 101-41000-135 Employer Paid Disability$ 960 $ 72 $ 72 $ 888 7.47%
E 101-41000-151 Worker s Comp Insurance Prem$ 1,339 $ 1,837 $ 1,837 $ (498) 137.19%
E 101-41000-200 Office Supplies$ 1,133 $ 29 $ 29 $ 1,104 2.55%
E 101-41000-203 Printed Forms & Papers$ 1,957 $ - $ - $ 1,957 0.00%
E 101-41000-210 Operating Supplies$ 824 $ 41 $ 41 $ 783 4.95%
E 101-41000-301 Auditing and Acct g Services$ 27,000 $ 590 $ 590 $ 26,410 2.19%
E 101-41000-303 Engineering Fees$ - $ - $ - $ - 0.00%
E 101-41000-304 Legal Services$ 65,000 $ 5,531 $ 5,531 $ 59,470 8.51%
E 101-41000-306 Personal Testing & Recruit$ - $ - $ - $ - 0.00%
E 101-41000-308 Other Professional Services$ 5,000 $ 500 $ 500 $ 4,500 10.00%
E 101-41000-309 Software Support & Maintenance$ 18,746 $ 796 $ 796 $ 17,950 4.25%
E 101-41000-314 Animal Control$ - $ - $ - $ - 0.00%
E 101-41000-316 Conferences & Seminars$ 721 $ 330 $ 330 $ 391 45.77%
E 101-41000-317 Employee Training$ 206 $ - $ - $ 206 0.00%
E 101-41000-319 Other Services$ 700 $ 550 $ 550 $ 150 78.57%
E 101-41000-321 Telephone$ 5,100 $ 475 $ 475 $ 4,625 9.31%
E 101-41000-322 Postage$ 2,200 $ 26 $ 26 $ 2,174 1.17%
E 101-41000-331 Travel Expenses$ 1,000 $ 42 $ 42 $ 958 4.19%
E 101-41000-351 Legal Notices Publishing$ 1,500 $ 747 $ 747 $ 753 49.78%
E 101-41000-361 Liability/Property Ins$ 11,516 $ - $ - $ 11,516 0.00%
E 101-41000-365 Insurance Claims$ 1,000 $ - $ - $ 1,000 0.00%
E 101-41000-381 Utilities-Electric & Gas$ 12,000 $ 511 $ 511 $ 11,489 4.26%
E 101-41000-413 Equipment Rental$ 1,800 $ 32 $ 32 $ 1,768 1.76%
E 101-41000-430 Recycling$ - $ - $ - $ - 0.00%
E 101-41000-433 Dues and Subscriptions$ 5,000 $ - $ - $ 5,000 0.00%
E 101-41000-434 Youth Service Bureau$ 5,500 $ - $ - $ 5,500 0.00%
E 101-41000-435 Misc Expense$ - $ - $ - $ - 0.00%
Website Host; ABDO accounting assistanceE101-41000-438 Misc. Contractual$ 4,120 $ - $ - $ 4,120 0.00%
E 101-41000-439 Refunds Issued$ - $ - $ - $ - 0.00%
E 101-41000-560 Furniture and Fixtures$ - $ - $ - $ - 0.00%
E 101-41000-570 Office Equipment$ 1,500 $ - $ - $ 1,500 0.00%
Total Admin & Finance Dept. Expenditures$ 450,499$ 39,035$ 39,035 $ 411,4648.66%
CITY OF SCANDIA
Revenue - Expenditure Summary
JANUARY 2024
Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments
GENERAL FUND CONT.CITY COUNCIL
ExpendituresE 101-41110-101 Regular Wages & Salaries$ 20,772 $ 5,193 $ 5,193 $ 15,579 25.00%
E 101-41110-122 FICA Employer Contribution$ 1,288 $ 62 $ 62 $ 1,226 4.78%
E 101-41110-126 MEDICARE Employer Contribution$ 301 $ 75 $ 75 $ 226 25.02%
E 101-41110-127 PERA Defined$ 703 $ 210 $ 210 $ 493 29.87%
E 101-41110-151 Worker s Comp Insurance Prem$ 100 $ 52 $ 52 $ 48 52.00%
E 101-41110-308 Other Professional Services$ - $ - $ - $ - 0.00%
E 101-41110-316 Conferences & Seminars$ 350 $ - $ - $ 350 0.00%
E 101-41110-331 Travel Expenses$ - $ - $ - $ - 0.00%
E 101-41110-439 Refunds Issued$ - $ - $ - $ - 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 $ 5,592 $ 5,592 $ 17,922 23.78%
ELECTIONS
ExpendituresE 101-41410-199 Election Judge$ 5,400 $ - $ - $ 5,400 0.00%
E 101-41410-200 Office Supplies$ 50 $ - $ - $ 50 0.00%
E 101-41410-203 Printed Forms & Papers$ - $ - $ - $ - 0.00%
E 101-41410-210 Operating Supplies$ 750 $ - $ - $ 750 0.00%
E 101-41410-351 Legal Notices Publishing$ 200 $ - $ - $ 200 0.00%
E 101-41410-413 Equipment Rental$ 1,700 $ - $ - $ 1,700 0.00%Wash. Cty. Equip. Maintenance Fee
Total Elections Dept. Expenditures$ 8,100 $ - $ - $ 8,100 0.00%
PLANNING & BUILDING
ExpendituresE 101-41910-101 Regular Wages & Salaries$ 60,010 $ 6,583 $ 6,583 $ 53,427 10.97%
E 101-41910-121 PERA Coord. Employer Contribu.$ 4,263 $ 494 $ 494 $ 3,769 11.58%
E 101-41910-122 FICA Employer Contribution$ 3,721 $ 395 $ 395 $ 3,326 10.62%
E 101-41910-126 MEDICARE Employer Contribution$ 870 $ 92 $ 92 $ 778 10.62%
E 101-41910-131 Employer Paid Health$ 17,353 $ 1,345 $ 1,345 $ 16,008 7.75%
E 101-41910-132 Dental Insurance$ 724 $ 55 $ 55 $ 669 7.57%
E 101-41910-134 Employer Paid Life$ 173 $ 14 $ 14 $ 159 8.32%
E 101-41910-135 Employer Paid Disability$ 416 $ 35 $ 35 $ 381 8.32%
E 101-41910-203 Printed Forms & Papers$ 100 $ - $ - $ 100 0.00%
E 101-41910-311 Contract Permit Inspections$ 60,000 $ 2,055 $ 2,055 $ 57,945 3.42%
E 101-41910-312 Planning Services$ 60,000 $ 3,409 $ 3,409 $ 56,591 5.68%
E 101-41910-313 Committee & Commission Reimbur$ 5,200 $ - $ - $ 5,200 0.00%
E 101-41910-316 Conferences & Seminars$ - $ - $ - $ - 0.00%
E 101-41910-319 Other Services$ - $ - $ - $ - 0.00%
E 101-41910-361 Liability/Property Ins$ 5,563 $ - $ - $ 5,563 0.00%
E 101-41910-438 Misc. Contractual$ 5,000 $ - $ - $ 5,000 0.00%
E 101-41910-439 Refunds Issued$ - $ - $ - $ - 0.00%
E 101-41910-720 Operating Transfers$ - $ - $ - $ - 0.00%
Total Planning & Building Dept. Expenditures$ 223,393 $ 14,477 $ 14,477 $ 208,916 6.48%
ASSESSOR
ExpendituresE 101-41960-300 Assessor$ 23,200 $ 1,800 $ 1,800 $ 21,400 7.76%
POLICE
ExpendituresE 101-42100-318 Police Contract$ 183,442 $ 84,250 $ 84,250 $ 99,192 45.93%
E 101-42100-319 Other Services$ 960 $ - $ - $ 960 0.00%Code Red System
Total GF Police Dept. Expenditures$ 184,402 $ 84,250 $ 84,250 $ 100,152 45.69%
CITY OF SCANDIA
Revenue - Expenditure Summary
JANUARY 2024
Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments
GENERAL FUND CONT.FIRE
ExpendituresE 101-42200-101 Regular Wages & Salaries$ 160,554 $ 25,128 $ 25,128 $ 135,426 15.65%
E 101-42200-121 PERA Coord. Employer Contribu.$ - $ - $ - $ - 0.00%
E 101-42200-122 FICA Employer Contribution$ 9,954 $ 1,600 $ 1,600 $ 8,354 16.07%
E 101-42200-124 Police & Fire PERA$ 8,983 $ 1,093 $ 1,093 $ 7,890 12.16%
E 101-42200-126 MEDICARE Employer Contribution$ 2,328 $ 370 $ 370 $ 1,958 15.90%
E 101-42200-134 Employer Paid Life$ 192 $ 16 $ 16 $ 176 8.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 $ 5,909 $ 5,909 $ 6,091 49.24%
E 101-42200-200 Office Supplies$ 200 $ - $ - $ 200 0.00%
E 101-42200-203 Printed Forms & Papers$ - $ - $ - $ - 0.00%
E 101-42200-209 Medical Supplies$ 3,500 $ 157 $ 157 $ 3,343 4.47%
E 101-42200-210 Operating Supplies$ 8,800 $ 139 $ 139 $ 8,661 1.58%
E 101-42200-211 Cleaning Supplies$ 100 $ - $ - $ 100 0.00%
E 101-42200-212 Fuel$ 4,000 $ 207 $ 207 $ 3,793 5.16%
E 101-42200-217 Uniforms & Safety Equipment$ 10,000 $ - $ - $ 10,000 0.00%
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 $ - $ - $ 800 0.00%
E 101-42200-240 Small Tools and Minor Equip$ 10,000 $ - $ - $ 10,000 0.00%
SCBA User Exams + Annual Fit TestE101-42200-305 Medical Services$ 5,600 $ - $ - $ 5,600 0.00%
E 101-42200-306 Personal Testing & Recruit$ 500 $ - $ - $ 500 0.00%
E 101-42200-309 Software Support & Maintenance$ 17,000 $ 648 $ 648 $ 16,352 3.81%
E 101-42200-310 Medical Training$ 2,000 $ - $ - $ 2,000 0.00%
E 101-42200-316 Conferences & Seminars$ 250 $ - $ - $ 250 0.00%
E 101-42200-317 Employee Training$ 12,000 $ - $ - $ 12,000 0.00%
E 101-42200-319 Other Services$ 500 $ 889 $ 889 $ (389) 177.89%
E 101-42200-321 Telephone$ 7,000 $ 532 $ 532 $ 6,468 7.60%
E 101-42200-322 Postage$ - $ - $ - $ - 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 $ - $ - $ 2,000 0.00%
E 101-42200-334 Licenses & Permits$ 500 $ - $ - $ 500 0.00% MNBoard ofFirefighter Training & Education License
E 101-42200-340 Advertising$ - $ - $ - $ - 0.00%
E 101-42200-361 Liability/Property Ins$ 7,339 $ - $ - $ 7,339 0.00%
E 101-42200-381 Utilities-Electric & Gas$ 8,000 $ 785 $ 785 $ 7,215 9.82%
E 101-42200-384 Refuse/Garbage Disposal$ - $ 98 $ 98 $ (98) 0.00%
E 101-42200-385 Sewer Pumping & Maintenance$ 550 $ - $ - $ 550 0.00%
E 101-42200-401 Building Maintenance/Repairs$ 3,500 $ 150 $ 150 $ 3,350 4.29%Cleaning, Pest Control,Repairs
E 101-42200-403 Improvements Other Than Bldgs$ - $ - $ - $ - 0.00%
E 101-42200-404 Repair Machinery/Equipment$ 8,500 $ 19 $ 19 $ 8,481 0.22%
E 101-42200-407 Well Repair & Maintenance$ - $ - $ - $ - 0.00%
E 101-42200-433 Dues and Subscriptions$ 3,200 $ 50 $ 50 $ 3,150 1.56%Truck inspection renewal
E 101-42200-438 Misc. Contractual$ 3,500 $ - $ - $ 3,500 0.00%
E 101-42200-440 Events$ 1,000 $ - $ - $ 1,000 0.00%
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 $ - $ - $ 500 0.00%
E 101-42200-570 Office Equipment$ 900 $ - $ - $ 900 0.00%
Total Fire Dept Expenditures$ 357,724 $ 37,790 $ 37,790 $ 319,934 10.56%
ANIMAL CONTROL
ExpendituresE 101-42700-314 Animal Control$ 6,000 $ 150 $ 150 $ 5,850 2.50%
CITY OF SCANDIA
Revenue - Expenditure Summary
JANUARY 2024
Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments
GENERAL FUND CONT.PUBLIC WORKS
ExpendituresE 101-43000-101 Regular Wages & Salaries$ 255,022 $ 28,489 $ 28,489 $ 226,533 11.17%
E 101-43000-102 OT Regular Wages$ 5,014 $ 1,039 $ 1,039 $ 3,975 20.73%
E 101-43000-104 Temporary Employee Wages$ 2,262 $ - $ - $ 2,262 0.00%snowplowing
E 101-43000-121 PERA Coord. Employer Contribu.$ 19,503 $ 2,215 $ 2,215 $ 17,288 11.36%
E 101-43000-122 FICA Employer Contribution$ 16,262 $ 1,769 $ 1,769 $ 14,493 10.88%
E 101-43000-126 MEDICARE Employer Contribution$ 3,803 $ 414 $ 414 $ 3,389 10.88%
E 101-43000-131 Employer Paid Health$ 66,939 $ 4,832 $ 4,832 $ 62,107 7.22%
E 101-43000-132 Dental Insurance$ 1,164 $ 88 $ 88 $ 1,076 7.57%
E 101-43000-133 Union Training Center$ 1,872 $ - $ - $ 1,872 0.00%
E 101-43000-134 Employer Paid Life$ 698 $ 58 $ 58 $ 640 8.33%
E 101-43000-135 Employer Paid Disability$ 1,365 $ 115 $ 115 $ 1,250 8.43%
E 101-43000-141 Unemployment Compensation$ - $ - $ - $ - 0.00%
E 101-43000-151 Worker s Comp Insurance Prem$ 27,000 $ 22,615 $ 22,615 $ 4,385 83.76%
E 101-43000-200 Office Supplies$ 50 $ - $ - $ 50 0.00%
E 101-43000-210 Operating Supplies$ 8,500 $ 68 $ 68 $ 8,432 0.80%
E 101-43000-212 Fuel$ 25,000 $ 1,880 $ 1,880 $ 23,120 7.52%
E 101-43000-217 Uniforms & Safety Equipment$ 2,300 $ - $ - $ 2,300 0.00%
E 101-43000-221 Equipment Parts$ 17,000 $ - $ - $ 17,000 0.00%
E 101-43000-222 Tires$ 7,500 $ - $ - $ 7,500 0.00%
E 101-43000-223 Structure Repair & Supplies$ 2,000 $ - $ - $ 2,000 0.00%
E 101-43000-224 Materials for Road Maintenance$ 7,000 $ 2,627 $ 2,627 $ 4,373 37.52%
E 101-43000-226 Sign Replacement and Repair$ 750 $ - $ - $ 750 0.00%
E 101-43000-228 Gravel$ 10,000 $ - $ - $ 10,000 0.00%
E 101-43000-229 Salt$ 22,000 $ - $ - $ 22,000 0.00%
E 101-43000-240 Small Tools and Minor Equip$ 8,000 $ - $ - $ 8,000 0.00%
E 101-43000-302 Surveying$ - $ - $ - $ - 0.00%
E 101-43000-303 Engineering Fees$ 10,500 $ 123 $ 123 $ 10,377 1.17%Gen. Eng. & Crack filling & seal coat fees
E 101-43000-304 Legal Services$ - $ - $ - $ - 0.00%
E 101-43000-305 Medical Services$ 1,000 $ - $ - $ 1,000 0.00%
IWORQ subscription; GIS map updatesE101-43000-309 Software Support & Maintenance$ 6,000 $ - $ - $ 6,000 0.00%
E 101-43000-317 Employee Training$ 1,500 $ - $ - $ 1,500 0.00%
E 101-43000-319 Other Services$ 7,000 $ 8 $ 8 $ 6,992 0.12%
E 101-43000-321 Telephone$ 4,000 $ 354 $ 354 $ 3,646 8.85%
E 101-43000-331 Travel Expenses$ 500 $ - $ - $ 500 0.00%
E 101-43000-334 Licenses & Permits$ 500 $ 182 $ 182 $ 318 36.45%
E 101-43000-361 Liability/Property Ins$ 8,766 $ - $ - $ 8,766 0.00%
E 101-43000-365 Insurance Claims$ - $ - $ - $ - 0.00%
E 101-43000-381 Utilities-Electric & Gas$ 6,000 $ 570 $ 570 $ 5,430 9.50%
E 101-43000-384 Refuse/Garbage Disposal$ - $ 65 $ 65 $ (65) 0.00%
E 101-43000-385 Sewer Pumping & Maintenance$ 1,500 $ - $ - $ 1,500 0.00%
E 101-43000-387 Street Light Utilities$ 4,200 $ 1,020 $ 1,020 $ 3,180 24.28%
E 101-43000-401 Building Maintenance/Repairs$ 6,000 $ 220 $ 220 $ 5,780 3.67%
E 101-43000-403 Improvements Other Than Bldgs$ - $ - $ - $ - 0.00%
E 101-43000-404 Repair Machinery/Equipment$ 25,000 $ - $ - $ 25,000 0.00%
E 101-43000-405 Contractual Road Maint/Repair$ 200,000 $ - $ - $ 200,000 0.00%
E 101-43000-407 Well Repair & Maintenance$ 500 $ - $ - $ 500 0.00%
E 101-43000-413 Equipment Rental$ 4,000 $ - $ - $ 4,000 0.00%
E 101-43000-417 Uniform Rental$ 1,200 $ 77 $ 77 $ 1,123 6.43%
E 101-43000-433 Dues and Subscriptions$ 200 $ - $ - $ 200 0.00%
E 101-43000-438 Misc. Contractual$ 16,000 $ - $ - $ 16,000 0.00%
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$ - $ - $ - $ -
E 101-43000-720 Operating Transfers$ - $ - $ - $ -
Total Public Works Dept. Expenditures$ 826,270 $ 68,828 $ 68,828 $ 757,442 8.33%
CITY OF SCANDIA
Revenue - Expenditure Summary
JANUARY 2024
Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments
GENERAL FUND CONT.PARKS & RECREATION
ExpendituresE 101-45000-101 Regular Wages & Salaries$ 11,328 $ 1,213 $ 1,213 $ 10,115 10.71%
E 101-45000-104 Temporary Employee Wages$ 39,985 $ 1,691 $ 1,691 $ 38,294 4.23%
E 101-45000-121 PERA Coord. Employer Contribu.$ 850 $ 91 $ 91 $ 759 10.70%
E 101-45000-122 FICA Employer Contribution$ 3,181 $ 178 $ 178 $ 3,003 5.58%
E 101-45000-126 MEDICARE Employer Contribution$ 744 $ 42 $ 42 $ 703 5.58%
E 101-45000-131 Employer Paid Health$ 2,562 $ 184 $ 184 $ 2,378 7.20%
E 101-45000-132 Dental Insurance$ 42 $ 3 $ 3 $ 39 7.62%
E 101-45000-134 Employer Paid Life$ 27 $ 2 $ 2 $ 25 8.30%
E 101-45000-135 Employer Paid Disability$ 76 $ 4 $ 4 $ 72 5.89%
E 101-45000-141 Unemployment Compensation$ - $ - $ - $ - 0.00%
E 101-45000-151 Worker s Comp Insurance Prem$ 2,700 $ 2,251 $ 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 $ 47 $ 47 $ 953 4.70%
E 101-45000-212 Fuel$ 1,000 $ - $ - $ 1,000 0.00%
E 101-45000-221 Equipment Parts$ 2,500 $ 120 $ 120 $ 2,380 4.79%
E 101-45000-223 Structure Repair & Supplies$ 2,500 $ - $ - $ 2,500 0.00%
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$ - $ - $ - $ - 0.00%
E 101-45000-319 Other Services$ 1,750 $ 11 $ 11 $ 1,739 0.64%
E 101-45000-322 Postage$ - $ - $ - $ - 0.00%
E 101-45000-340 Advertising$ - $ - $ - $ - 0.00%
E 101-45000-353 Sales& Use Tax$ - $ - $ - $ - 0.00%
E 101-45000-361 Liability/Property Ins$ 3,489 $ - $ - $ 3,489 0.00%
E 101-45000-381 Utilities-Electric & Gas$ 6,500 $ 360 $ 360 $ 6,140 5.53%
E 101-45000-384 Refuse/Garbage Disposal$ 5,000 $ 149 $ 149 $ 4,851 2.98%
E 101-45000-385 Sewer Pumping & Maintenance$ 1,250 $ 168 $ 168 $ 1,082 13.43%
E 101-45000-401 Building Maintenance/Repairs$ 6,000 $ 120 $ 120 $ 5,880 2.00%
E 101-45000-403 Improvements Other Than Bldgs$ 2,500 $ - $ - $ 2,500 0.00%
E 101-45000-404 Repair Machinery/Equipment$ 1,000 $ - $ - $ 1,000 0.00%
E 101-45000-406 Grounds Care$ 4,000 $ - $ - $ 4,000 0.00%
E 101-45000-438 Misc. Contractual$ 8,000 $ 2,500 $ 2,500 $ 5,500 31.25%
E 101-45000-439 Refunds Issued$ - $ - $ - $ - 0.00%
E 101-45000-440 Events$ 7,000 $ 404 $ 404 $ 6,596 5.77%
E 101-45000-490 Financial Assistance$ - $ - $ - $ - 0.00%
E 101-45000-530 Capital Impr Other Than Bldgs$ 9,900 $ 4,500 $ 4,500 $ 5,400 45.45%
E 101-45000-720 Operating Transfers$ - $ - #DIV/0!
Total Parks & Rec Dept. Expenditures$ 125,684 $ 14,038 $ 14,038 $ 111,646 11.17%
CITY OF SCANDIA
Revenue - Expenditure Summary
JANUARY 2024
Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments
GENERAL FUND CONT.COMMUNITY CENTER
ExpendituresE 101-45180-101 Regular Wages & Salaries$ 16,600 $ 1,772 $ 1,772 $ 14,828 10.67%
E 101-45180-104 Temporary Employee Wages$ - $ - $ - $ - 0.00%
E 101-45180-121 PERA Coord. Employer Contribu.$ 1,245 $ 133 $ 133 $ 1,112 10.67%
E 101-45180-122 FICA Employer Contribution$ 1,029 $ 106 $ 106 $ 923 10.31%
E 101-45180-126 MEDICARE Employer Contribution$ 241 $ 25 $ 25 $ 216 10.29%
E 101-45180-131 Employer Paid Health$ 3,692 $ 256 $ 256 $ 3,436 6.92%
E 101-45180-134 Employer Paid Life$ 43 $ 4 $ 4 $ 39 8.37%
E 101-45180-135 Employer Paid Disability$ 95 $ 8 $ 8 $ 87 8.93%
E 101-45180-151 Worker s Comp Insurance Prem$ - $ 152 $ 152 $ (152) 0.00%
E 101-45180-210 Operating Supplies$ 2,900 $ 58 $ 58 $ 2,842 2.00%
E 101-45180-223 Structure Repair & Supplies$ 4,000 $ - $ - $ 4,000 0.00%
E 101-45180-334 Licenses & Permits$ 1,000 $ - $ - $ 1,000 0.00%
E 101-45180-361 Liability/Property Ins$ 835 $ - $ - $ 835 0.00%
E 101-45180-381 Utilities-Electric & Gas$ 9,135 $ 929 $ 929 $ 8,206 10.17%
E 101-45180-384 Refuse/Garbage Disposal$ - $ 240 $ 240 $ (240) 0.00%
E 101-45180-385 Sewer Pumping & Maintenance$ 4,000 $ 1,201 $ 1,201 $ 2,799 30.03%
E 101-45180-401 Building Maintenance/Repairs$ 15,000 $ 580 $ 580 $ 14,420 3.87%
E 101-45180-404 Repair Machinery/Equipment$ 5,000 $ 290 $ 290 $ 4,710 5.81%Kitchen/HVACrepairandmaintenance
E 101-45180-406 Grounds Care$ 1,300 $ - $ - $ 1,300 0.00%
E 101-45180-407 Well Repair & Maintenance$ 1,000 $ - $ - $ 1,000 0.00%
E 101-45180-438 Misc. Contractual$ 3,500 $ - $ - $ 3,500 0.00%
E 101-45180-439 Refunds Issued$ - $ - $ - $ - 0.00%
E 101-45180-520 Capital Improvements to Bldgs$ 9,900 $ - $ - $ 9,900 0.00%Building/Equipment Improvements
E 101-45180-530 Capital Impr Other Than Bldgs$ - $ - #DIV/0!
E 101-45180-570 Office Equipment$ - $ - #DIV/0!
E 101-45180-720 Operating Transfers$ - $ - #DIV/0!
Total Community Center Dept. Expenditures$ 80,515 $ 5,754 $ 5,754 $ 74,761 7.15%
TOTAL GENERAL FUND EXPENDITURES$ 2,309,301 $ 271,713$ 271,713$ 2,037,588 11.77%
E 101-49000-421 Cash Over/Short
Operating TransfersE 101-49000-720 Operating Transfers$ 350,000 $ 350,000 $ (350,000)
TOTAL GENERAL FUND EXPENDITURES W/TRANSFERS$ 2,309,301 $ 621,713 $ 621,713 $ 1,687,588
CITY OF SCANDIA
Revenue - Expenditure Summary
JANUARY 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$ - $ - $ - $ -
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$ - $ - $ - $ - 0.00%
R 225-46500-36210 Interest Income$ 100 $ - $ - $ 100 0.00%
R 225-46500-36230 Donations$ - $ - $ - $ - 0.00%
R 225-46500-39203 Transfer from Other Funds$ - $ - $ - $ - 0.00%
Total EDA Fund Revenue$ 5,400$ - $ -$ 5,4000.00%
ExpenditureE 225-46500-210 Operating Supplies$ 300 $ - $ - $ 300 0.00%
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%
E 225-46500-340 Advertising$ 1,500 $ - $ - $ 1,500 0.00%
EDAM Membership; Sister City DuesE225-46500-433 Dues and Subscriptions$ 1,203 $ - $ - $ 1,203 0.00%
E 225-46500-440 Events$ 1,500 $ - $ - $ 1,500 0.00%
E 225-46500-720 Operating Transfers$ - $ - $ - $ - #DIV/0!
Total EDA Fund Expenditures$ 4,603$ - $ -$ 4,6030.00%
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 $ 1,636 $ 1,636 $ 15,064 9.80%
R 226-41950-38051 PEG Fees$ 4,400 $ 442 $ 442 $ 3,958 10.05%
Total Cable TV Fund Revenue$ 21,200$ 2,078$ 2,078$ 19,1229.80%
ExpenditureE 226-41950-240 Small Tools and Minor Equip$ 300 $ - $ - $ 300 0.00%
E 226-41950-309 Software Support & Maintenance$ 3,500 $ 184 $ 184 $ 3,316 5.26%
E 226-41950-438 Misc. Contractual$ 7,750 $ - $ - $ 7,750 0.00%
E 226-41950-570 Office Equipment$ - $ - $ - $ - 0.00%
Total Cable TV Fund Expenditures$ 11,550$ 184 $ 184$ 11,3661.59%
GATEWAY TRAIL FUND
RevenueR 230-45000-36230 Donations$ - $ - $ - $ - 0.00%
ExpenditureE 230-45000-308 Other Professional Services$ - $ - $ - $ - 0.00%
2017 EQUIPMENT CERTIFICATES
RevenueR 317-47000-31000 Washington Cty. Tax Settlement$ 34,524 $ - $ - $ 34,524 0.00%
ExpenditureE 317-47000-601 Long Term Debt Principal$ 32,000 $ - $ - $ 32,000 0.00%
E 317-47000-611 Long Term Debt Interest$ 880 $ - $ - $ 880 0.00%
E 317-47000-620 Fiscal Agent s Fees$ - $ - $ - $ - 0.00%
Total 2017 Fund Expenditures$ - $ 32,880$ -$ - #DIV/0!
2018 STREET RECONSTRUCTION
RevenueR 318-47000-31000 Washington Cty. Tax Settlement$ - $ - $ 345,634 0.00% 345,634
ExpenditureE 318-47000-601 Long Term Debt Principal$ 245,000 $ - $ - $ 245,000 0.00%
E 318-47000-611 Long Term Debt Interest$ 84,175 $ - $ - $ 84,175 0.00%
E 318-47000-620 Fiscal Agent s Fees$ 495 $ - $ - $ 495 0.00%
Total 2018 Street Reconstruction Fund Expenditures$ 329,670$ - $ -$ 329,6700.00%
CITY OF SCANDIA
Revenue - Expenditure Summary
JANUARY 2024
Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments
2024 STREET RECONSTRUCTION
RevenueR 324-47000-31000 Washington Cty. Tax Settlement$ - $ - $ - $ - 0.00%
R 324-47000-36210 Interest Income$ - $ - $ - $ - 0.00%
Total 2024 Street Reconstruction Fund Revenue$ - $ - $ -$ - #DIV/0!
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%
Total 2018 Street Reconstruction Fund Expenditures$ 495 $ - $ -$ 495 0.00%
CAPITAL IMPROVEMENTS
RevenueR 401-48000-31000 Washington Cty. Tax Settlement$ 235,000 $ - $ 235,000 0.00%
R 401-48000-33422 Other State Grants & Aids$ - $ - $ - #DIV/0!
R 401-48000-36210 Interest Income$ 3,000 $ - $ - $ 3,000 0.00%
Total Capital Improvement Fund Revenue$ 238,000$ - $ -$ 238,0000.00%
ExpenditureE 401-41000-312 Planning Services$ - $ - $ - $ - #DIV/0!
E 401-41000-520 Capital Improvements to Bldgs$ - $ - $ - $ - #DIV/0!
E 401-41000-530 Capital Impr Other Than Bldgs$ 250,000 $ - $ - $ 250,000 0.00%
E 401-42200-520 Capital Improvements to Bldgs$ - $ - #DIV/0!
E 401-45180-520 Capital Improvements to Bldgs$ 67,548 $ 67,548 0.00%
E 401-48000-303 Engineering Fees$ - $ 7,098 $ 7,098 $ (7,098) 0.00%Gateway Trail Engineering
E 401-48000-308 Other Professional Services$ - $ 2,400 $ 2,400 $ (2,400) 0.00%Gateway Trail Lobbying
E 401-48000-312 Planning Services$ - $ - $ - $ - #DIV/0!
E 401-48000-435 Misc Expense$ - $ - $ - $ - #DIV/0!
E 401-48000-438 Misc. Contractual$ - $ - $ - $ - #DIV/0!
E 401-48000-520 Capital Improvements to Bldgs$ - $ - $ - $ - #DIV/0!
E 401-48000-530 Capital Impr Other Than Bldgs$ 160,000 $ - $ - $ 160,000 0.00%
477,548 $ 9,498 $ 9,498 $ 468,051 1.99%
PARK DEVELOPMENT
RevenueR 404-48000-31000 Washington Cty. Tax Settlement$ 60,000 $ 60,000 0.00%
R 404-48000-33422 Other State Grants & Aids$ - $ - #DIV/0!
R 404-48000-34780 Park Dedication Fees$ - $ - #DIV/0!
R 404-48000-36210 Interest Income$ 66 $ 66 0.00%
R 404-48000-36230 Donations$ - $ - #DIV/0!
Total Park Development Fund Revenue$ 60,066$ - $ -$ 60,0660.00%
ExpenditureE 404-48000-312 Planning Services$ - $ - #DIV/0!
E 404-48000-520 Capital Improvements to Bldgs$ - $ - #DIV/0!
E 404-48000-530 Capital Impr Other Than Bldgs$ 150,000 $ 150,000 0.00%
E 404-48000-720 Operating Transfers$ - $ - #DIV/0!
Total Park Development Fund Expenditures$ 150,000$ - $ -$ 150,0000.00%
EQUIPMENT REPLACEMENT
RevenueR 406-48500-31000 Washington Cty. Tax Settlement$ 110,000 $ - $ - $ 110,000 0.00%
R 406-48500-36210 Interest Income$ 1,045 $ - $ - $ 1,045 0.00%
R 406-48500-36260 Sale of Equipment$ - $ - $ - $ - #DIV/0!
R 406-48500-39350 Certificate of Indebtedness$ 350,000 $ - $ - $ 350,000 0.00%
Total Equipment Replacement Fund Revenue$ 461,045$ - $ -$ 461,0450.00%
ExpenditureE 406-48500-540 Heavy Machinery Capital$ 867,000 $ 10,000 $ 10,000 $ 857,000 1.15%
E 406-48500-550 Motor Vehicles Capital$ 84,356 $ - $ - $ 84,356 0.00%
Total Equipment Replacement Fund Expenditures$ 951,356$ 10,000$ 10,000 $ 941,3561.05%
LOCAL ROAD IMPROVEMENT FUND
RevenueR 408-43100-31000 Washington Cty. Tax Settlement$ 375,000 $ - $ - $ 375,000 0.00%
R 408-43100-33422 Other State Grants & Aids$ - $ - $ - $ - #DIV/0!
R 408-43100-36210 Interest Income$ 10,705 $ - $ - $ 10,705 0.00%
R 408-43100-39310 Proceeds-Gen Obligation Bond$ 4,000,000 $ - $ - $ 4,000,000 0.00%
Total LRIF Revenue$ 4,385,705 $ - $ -$ 4,385,705 0.00%
ExpenditureE 408-43100-303 Engineering Fees$ 120,000 $ 23,284 $ 23,284 $ 96,717 19.40%
E 408-43100-530 Capital Impr Other Than Bldgs$ 3,575,000 $ - $ - $ 3,575,000 0.00%
Total LRIF Expenditures$ 3,695,000 $ 23,284 $ 23,284 $ 3,671,717 0.63%
CITY OF SCANDIA
Revenue - Expenditure Summary
JANUARY 2024
Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments
BLISS SEWER
RevenueR 602-43210-31951 Special Assessments Principal$ - $ - $ - $ - 0.00%
R 602-43210-31952 SA Penalties & Interest$ 420 $ - $ - $ 420 0.00%
R 602-43210-33422 Other State Grants & Aids$ - $ - $ - $ - 0.00%
R 602-43210-34401 Sewer User Fees$ 125,230 $ 894 $ 894 $ 124,336 0.71%
R 602-43210-34402 Sewer Connection Fee$ - $ - $ - $ - 0.00%
R 602-43210-36100 Special Assessments$ - $ - $ - $ - 0.00%
R 602-43210-36102 Penalties and Interest$ - $ - $ - $ - 0.00%
R 602-43210-36210 Interest Income$ 210 $ - $ - $ 210 0.00%
Total Big Marine Sewer Revenue$ 125,860 $ 894 $ 894 $ 124,966 0.71%
ExpenditureE 602-43210-101 Regular Wages & Salaries$ 17,458 $ 2,261 $ 2,261 $ 15,197 12.95%
E 602-43210-120 Pension Expense$ - $ - $ - $ - 0.00%
E 602-43210-121 PERA Coord. Employer Contribu.$ 1,309 $ 170 $ 170 $ 1,139 12.95%
E 602-43210-122 FICA Employer Contribution$ 1,082 $ 136 $ 136 $ 946 12.53%
E 602-43210-126 MEDICARE Employer Contribution$ 253 $ 32 $ 32 $ 221 12.53%
E 602-43210-131 Employer Paid Health$ - $ - $ - $ - 0.00%
E 602-43210-151 Worker s Comp Insurance Prem$ 525 $ 783 $ 783 $ (258) 149.14%
E 602-43210-200 Office Supplies$ 91 $ 48 $ 48 $ 43 53.12%
E 602-43210-210 Operating Supplies$ 700 $ 10 $ 10 $ 690 1.38%
E 602-43210-240 Small Tools and Minor Equip$ 420 $ - $ - $ 420 0.00%
Bliss Collector Permit RenewalE602-43210-303 Engineering Fees$ 7,718 $ 752 $ 752 $ 6,966 9.74%
E 602-43210-304 Legal Services$ - $ - $ - $ - 0.00%
E 602-43210-308 Other Professional Services$ 3,500 $ - $ - $ 3,500 0.00%Water/Wastewateranalyticaltesting
E 602-43210-309 Software Support & Maintenance$ 910 $ - $ - $ 910 0.00%SCADA
E 602-43210-317 Employee Training$ 980 $ - $ - $ 980 0.00%
E 602-43210-321 Telephone$ 1,750 $ 131 $ 131 $ 1,619 7.46%SCADAdialers
E 602-43210-322 Postage$ 420 $ - $ - $ 420 0.00%
E 602-43210-331 Travel Expenses$ 525 $ - $ - $ 525 0.00%
E 602-43210-334 Licenses & Permits$ 1,400 $ - $ - $ 1,400 0.00%WastewaterCertification/PermitRenewal
E 602-43210-361 Liability/Property Ins$ 2,535 $ - $ - $ 2,535 0.00%
E 602-43210-381 Utilities-Electric & Gas$ 2,100 $ 157 $ 157 $ 1,943 7.49%Connexus & Excel
E 602-43210-385 Sewer Pumping & Maintenance$ 14,000 $ - $ - $ 14,000 0.00%
E 602-43210-386 Operation & Maintenance$ 3,500 $ - $ - $ 3,500 0.00%
E 602-43210-404 Repair Machinery/Equipment$ 11,200 $ - $ - $ 11,200 0.00%Pumpandcontrolrepair/replacement
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 $ 1,830 $ 1,830 $ 5,170 26.15%
E 602-43210-439 Refunds Issued$ - $ - $ - $ - 0.00%
E 602-43210-530 Capital Impr Other Than Bldgs$ 6,930 $ - $ - $ 6,930 0.00%
Total BLISS Sewer Expenditures$ 127,606$ 6,309$ 6,309$ 121,2974.94%
CITY OF SCANDIA
Revenue - Expenditure Summary
JANUARY 2024
Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments
UPTOWN SEWER
RevenueR 612-43210-34401 Sewer User Fees$ 22,400 $ - $ - $ 22,400 0.00%
R 612-43210-36210 Interest Income$ 50 $ - $ - $ 50 0.00%
Total Uptown Sewer Revenue$ 22,450$ - $ -$ 22,4500.00%
ExpenditureE 612-43210-101 Regular Wages & Salaries$ 10,725 $ 922 $ 922 $ 9,803 8.60%
E 612-43210-120 Pension Expense$ - $ - $ - $ - 0.00%
E 612-43210-121 PERA Coord. Employer Contribu.$ 804 $ 69 $ 69 $ 735 8.60%
E 612-43210-122 FICA Employer Contribution$ 665 $ 55 $ 55 $ 610 8.32%
E 612-43210-126 MEDICARE Employer Contribution$ 156 $ 13 $ 13 $ 143 8.30%
E 612-43210-151 Worker s Comp Insurance Prem$ 300 $ 522 $ 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 $ 310 $ 441 41.27%WastewaterAnalyticaltesting
E 612-43210-309 Software Support & Maintenance$ 84 $ - $ - $ 84 0.00%
E 612-43210-317 Employee Training$ 200 $ - $ - $ 200 0.00%
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 $ - $ - $ 250 0.00%
E 612-43210-361 Liability/Property Ins$ 502 $ - $ - $ 502 0.00%
E 612-43210-381 Utilities-Electric & Gas$ 1,000 $ 118 $ 118 $ 882 11.83%
E 612-43210-385 Sewer Pumping & Maintenance$ 1,500 $ - $ - $ 1,500 0.00%
E 612-43210-386 Operation & Maintenance$ 1,000 $ - $ - $ 1,000 0.00%
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 $ 449 $ 449 $ 1,051 29.92%LiftStationInspection/PumpTesting
E 612-43210-530 Capital Impr Other Than Bldgs$ 9,900 $ - $ - $ 9,900 0.00%PumpReplacement
E 612-43210-720 Operating Transfers$ 2,640 $ - $ - $ 2,640 0.00%
Total Uptown Sewer Expenditures$ 42,526$ 2,458$ 2,458$ 40,0685.78%
A-E SEWER
RevenueR 624-43210-31952 SA Penalties & Interest$ 180 $ - $ - $ 180 0.00%
R 624-43210-34401 Sewer User Fees$ 53,670 $ - $ - $ 53,670 0.00%
R 624-43210-36210 Interest Income$ 90 $ - $ - $ 90 0.00%
Total A-E Sewer Revenue$ 53,940 $ - $ - $ 53,940 0.00%
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 $ - $ - $ 39 0.00%
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 $ 310 $ 1,191 20.63%
E 624-43210-309 Software Support & Maintenance$ 390 $ - $ - $ 390 0.00%
E 624-43210-317 Employee Training$ 420 $ - $ - $ 420 0.00%
E 624-43210-321 Telephone$ 750 $ 120 $ 120 $ 630 16.04%
E 624-43210-322 Postage$ 180 $ - $ - $ 180 0.00%
E 624-43210-331 Travel Expenses$ 225 $ - $ - $ 225 0.00%
E 624-43210-334 Licenses & Permits$ 600 $ - $ - $ 600 0.00%
E 624-43210-361 Liability/Property Ins$ 1,086 $ - $ - $ 1,086 0.00%
E 624-43210-381 Utilities-Electric & Gas$ 900 $ 42 $ 42 $ 858 4.63%
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 $ - $ - $ 4,800 0.00%
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 $ 624 $ 624 $ 2,376 20.81%
E 624-43210-530 Capital Impr Other Than Bldgs$ 2,970 $ - $ - $ 2,970 0.00%
E 602-43210-438 Misc. Contractual$ - $ - $ - $ - #DIV/0!
E 602-43210-439 Refunds Issued$ - $ - $ - $ - #DIV/0!
E 602-43210-530 Capital Impr Other Than Bldgs$ - $ - $ - $ - #DIV/0!
Total A-E Sewer Expenditures$ 51,380$ 1,096$ 1,096$ 50,2842.13%