06.b Treasurer's Monthly Report
City of Scandia
aug
Treasurer’s Report
12/31/2022
FUND ACCOUNTING
Beginning Cash Balance $ 3,335,497.41
12/1/2022
Beginning Checking Balance$ 109,785.73
Checking Receipts
$ 1,166,873.71
Transfers to Checking
Total Deposits
$ 1,166,873.71
Expenditures$ (1,099,728.81)
Payroll$ (36,125.40)
Transfer to EDA in Transit$ (3,526.53)
Total Payments
$ (1,139,380.74)
Ending Checking Balance
$ 137,278.70
Beginnging Money Market Balance
$ 1,169,172.57
Money Market Receipts
$ 960,327.15
Tranfer to Checking
$ -
0
Ending Money Market Balance
$ 2,129,499.72
Beginning Investments Balance
$ 2,034,697.24
Investments Receipts
$ 5,101.04
Ending Investments Balance$ 2,039,798.28
Beginning EDA Balance$ 30,326.13
EDA Receipts
$ -
EDA Expenditures
$ (495.00)
EDA De;posit in Transit$ 3,526.53
EDA Transfers from Checking
Ending EDA Balance$ 33,357.66
Outstanding Checks
$ (44,676.00)
12/31/2022
Ending Cash Balance $ 4,295,258.36
CHECKING, MONEY MARKET & INVESTMENT CD's
Checking *102$ 109,785.73
Beg Bal
Credits$ 1,166,873.71
Debits$ (1,135,854.21)
Transfer in Transit
$ 140,805.23
End Bal
Money Market *105 - Rate .25%$ 1,169,172.57
Beg Bal
rate change from 1.25% Credits
$ 960,327.15
Debits
$ -
End Bal$ 2,129,499.72
Investments
CD *4422 - Rate .45% 12 mo., 3/25/2023$ 317,693.84
CD *4424 - Rate 2.50% 12 mo., 7/17/2023 **NEW RATE$ 444,108.54
CD *4425 - Rate 2.875% 12 mo., 9/28/2023 **NEW RATE$ 739,581.42
CD *4426 - Rate .30% 12 mo., 1/29/2023
$ 538,414.48
Total Investments$ 2,039,798.28
Total Bank & Investment Accounts
$ 4,310,103.23
$ (44,676.00)
Checks in Transit *3102
Transfer to EDA in Transit$ (3,526.53)
Deposit in transit money market
$ 4,261,900.70
Total Adjusted Undesignated Funds
Scandia EDA *6301 $ 30,326.13
Receipts
$ -
Expenditures
$ (495.00)
Checks in Transit
$ 3,526.53
Deposit in Transit
Total Designated EDA Funds$ 33,357.66
Total Funds$ 4,295,258.36
Submitted by: Colleen Firkus, Treasurer
2022 CASH BALANCES
END OF MONTH
FUNDJANUARYFEBRUARYMARCHAPRILMAYJUNE
101 GENERAL$ 1,375,256.03$ 1,243,313.89$ 1,124,142.19$ 1,012,873.90$ 890,924.57$ 1,701,216.18
203 COVID-19 RELIEF$ 228,181.31$ 228,181.31$ 228,181.31$ 228,181.31$ 228,181.31$ 228,181.31
226 CABLE TV$ 39,431.38$ 41,288.08$ 42,940.54$ 43,836.65$ 44,302.18$ 17,599.67
230 RESTRICTED DONATIONS$ 175.00$ 175.00$ 925.00$ 2,525.00$ 3,575.00$ 3,575.00
307 BLACKTOP PROJECT 2007$ -$ -$ 6,463.65$ 6,463.65$ 6,463.65$ 6,730.52
313 EQUIPMENT CERTIFICATES$ 24,314.07$ 24,314.07$ 24,314.07$ 25,110.07$ 25,110.07$ (3,744.93)
315 EQUIPMENT CERTIFICATES$ 15,452.35$ 15,452.35$ 15,452.35$ 15,951.35$ 15,951.35$ 15,951.35
317 EQUIPMENT CERTIFICATES$ (297.54)$ (297.54)$ (297.54)$ 103.46$ 103.46$ 17,365.46
318 BLACKTOP PROJECT$ 603.14$ 603.14$ 603.14$ 4,359.14$ (45,198.37) $ 127,067.13
401 CAPITAL IMPR$ 818,049.51$ 811,649.51$ 719,740.45$ 716,800.12$ 716,431.08$ 822,054.08
404 PARK CAP IMPR$ 144,888.28$ 144,888.28$ 153,888.28$ 154,216.28$ 154,216.28$ 165,491.28
406 EQUIPMENT REPLACEMENT$ 316,104.69$ 316,104.69$ 316,104.69$ 104,259.83$ 104,259.83$ 155,827.01
408 LOCAL ROAD IMPROVEMENT$ 1,258,339.81$ 1,248,055.95$ 1,220,765.95$ 1,226,717.45$ 1,220,617.45$ 1,329,096.45
602 BIG MARINE SEWER$ 96,112.55$ 91,195.97$ 78,021.72$ 79,320.98$ 49,281.22$ 64,260.55
612 UPTOWN SEWER$ 14,094.48$ 16,430.41$ 15,020.58$ 15,050.60$ 14,347.68$ 13,148.48
801 ESCROW$ 33,340.59$ 38,526.39$ 34,870.13$ 33,870.23$ 36,986.33$ 42,880.49
SUBTOTAL$ 4,364,045.65$ 4,219,881.50$ 3,981,136.51$ 3,669,640.02$ 3,465,553.09$ 4,706,700.03
225 EDA$ 28,903.67$ 28,903.67$ 27,702.55$ 27,344.55$ 27,399.55$ 27,019.70
TOTAL$ 4,392,949.32$ 4,248,785.17$ 4,008,839.06$ 3,696,984.57$ 3,492,952.64$ 4,733,719.73
FUNDJULYAUGUSTSEPTEMBEROCTOBERNOVEMBERDECEMBER
101 GENERAL$ 1,517,797.37 $ 1,400,512.58 $1,267,186$1,160,922$1,082,091$1,592,723
210 EDA
211 HRA
203 COVID-19 RELIEF$ 456,362.62$ 456,362.62$456,363$456,363$456,363$456,363
226 CABLE TV$ 19,525.37$ 19,480.07$21,421$21,964$23,876$9,410
230 RESTRICTED DONATIONS$ -$0$0$0$0
307 BLACKTOP PROJECT 2007$ 6,730.52$ 6,730.52$6,731$6,731$6,731$6,731
313 EQUIPMENT CERTIFICATES$ (3,744.93)$ (3,744.93)($3,745)($3,745)($4,675)$28,825
315 EQUIPMENT CERTIFICATES$ 15,951.35$ 15,951.35$15,951$15,951$15,951$15,951
317 EQUIPMENT CERTIFICATES$ (15,074.54) $ (15,074.54) ($15,075)($15,075)($15,075)$2,187
318 BLACKTOP PROJECT$ 127,067.13$ 127,067.13$127,067($151,995)($151,995)$20,270
401 CAPITAL IMPR$ 819,894.08$ 817,494.08$815,094$647,694$647,694$751,562
404 PARK CAP IMPR$ 165,616.28$ 165,616.28$162,616$133,305$133,829$138,177
406 EQUIPMENT REPLACEMENT$ 155,827.01$ 155,827.01$155,827$155,827$155,827$199,727
408 LOCAL ROAD IMPROVEMENT$ 1,319,327.95 $ 1,058,762.40 $1,010,303$844,072$841,438$928,143
602 BIG MARINE SEWER$ 71,515.96$ 67,011.85$62,716$67,543$66,353$71,149
612 UPTOWN SEWER$ 9,512.61$ 12,143.58$11,439$10,187$13,169$12,185
801 ESCROW$ 40,645.19$ 40,327.82$34,577$35,089$32,769$28,498
SUBTOTAL$ 4,706,953.97 $ 4,324,467.82 $4,128,470$3,384,833$3,304,346$4,261,901
225 EDA$ 31,019.70$ 30,995.62$30,996$30,677$29,831$33,358
TOTAL$ 4,737,973.67 $ 4,355,463.44 $4,159,466$3,415,511$3,334,177$4,295,258
CITY OF SCANDIA
Revenue - Expenditure Summary
Dec-22
2022 YTD November Budget % of
BudgetAmountAmountBalanceBudget
Comments
Description
GENERAL FUND
RevenueADMINISTRATION & FINANCE
R 101-41000-31000 Washington Cty. Tax Settlement$1,583,000.00$1,386,171.66$574,253.31$196,828.3487.57%
R 101-41000-31040 Fiscal Disparities$0.00$132,738.46$43,199.26($132,738.46)0.00%
R 101-41000-31701 Gravel Taxes$20,000.00$6,457.10$0.00$13,542.9032.29%
R 101-41000-31830 Solar Energy Production Tax$5,000.00$4,115.14$0.00$884.8682.30%
R 101-41000-31900 Penalties & Interest Del Tax$400.00$234.87$0.00$165.1358.72%
R 101-41000-32150 Utility Permits$3,000.00$5,700.00$300.00($2,700.00)190.00%
R 101-41000-32180 Tobacco & Liquor Licenses$8,500.00$11,357.00$5,316.00($2,857.00)133.61%
R 101-41000-32190 Other City Permits$3,000.00$3,345.00$225.00($345.00)111.50%
R 101-41000-32210 Building Permits$135,000.00$162,113.32$13,295.51($27,113.32)120.08%
R 101-41000-32260 Gambling Permits$0.00$245.00$0.00($245.00)0.00%
R 101-41000-33401 LGA/MVHC/AG/PERA Aid$13,200.00$7,323.97$6,913.97$5,876.0355.48%
R 101-41000-33420 Fire Relief State PERA$39,600.00$0.00$0.00$39,600.000.00%
R 101-41000-33422 Other State Grants & Aids$5,400.00$8,889.09$0.00($3,489.09)164.61%
R 101-41000-33428 PILOT$6,000.00$8,241.72$5,139.70($2,241.72)137.36%
R 101-41000-33620 Recycling Grant$9,000.00$13,188.00$0.00($4,188.00)146.53%
R 101-41000-33630 Local Govt Grants & Aids$0.00$0.00$0.00$0.000.00%
R 101-41000-33640 Other Grants$1,000.00$0.00$0.00$1,000.000.00%
R 101-41000-34103 Zoning and Planning$4,300.00$4,742.00$50.00($442.00)110.28%
R 101-41000-34107 Assessment Search Fees$100.00$20.00$0.00$80.0020.00%
R 101-41000-34109 Water Usage$200.00$0.00$0.00$200.000.00%
R 101-41000-34201 Impound Fees$0.00$592.58$0.00($592.58)0.00%
R 101-41000-34202 Fire Protection Services$31,493.00$31,493.00$0.00$0.00100.00%
R 101-41000-34303 Dust Control$2,400.00$3,180.46$0.00($780.46)132.52%
R 101-41000-34304 Reimbursement for Services$3,600.00$3,600.00$0.00$0.00100.00%
R 101-41000-34730 Ad Revenue$2,100.00$2,400.00$0.00($300.00)114.29%
R 101-41000-34750 Facilities Rental$5,000.00$12,016.40$982.75($7,016.40)240.33%
R 101-41000-34760 Cleaning Fees$200.00$0.00$0.00$200.000.00%
R 101-41000-34790 Recreation Programs$1,000.00$1,955.00$115.00($955.00)195.50%
R 101-41000-35101 Fines & Forfeitures$7,000.00$5,721.44$316.98$1,278.5681.73%
R 101-41000-36210 Interest Income$15,900.00$16,837.04$5,435.11($937.04)105.89%
R 101-41000-36230 Donations$1,500.00$4,841.35$0.00($3,341.35)322.76%
Ice Sculpture Donations
R 101-41000-36240 Insurance Dividend$2,000.00$4,927.00$4,927.00($2,927.00)246.35%
R 101-41000-36250 Misc. Refund$2,500.00$1,284.29$0.00$1,215.7151.37%
Total General Fund Revenue$1,911,393.00$1,843,730.89$660,469.59$67,662.1196.46%
Operating TransfersR 101-49000-39203 Transfer from Other Funds$0.00$2,240,000.00($2,240,000.00)
R 101-49000-39204 Money Market Transfer$0.00$1,725,000.00$960,000.00($1,725,000.00)
Total Operating Transfers$3,965,000.00$960,000.00($3,965,000.00)
CITY OF SCANDIA
Revenue - Expenditure Summary
Dec-22
2022 YTD November Budget % of
BudgetAmountAmountBalanceBudget
Comments
Description
GENERAL FUNDADMINISTRATION & FINANCE
ExpendituresE 101-41000-101 Regular Wages & Salaries$162,600.00$150,034.82$12,631.18$12,565.1892.27%
E 101-41000-121 PERA Coord. Employer Contribu.$12,000.00$11,242.13$947.34$757.8793.68%
E 101-41000-122 FICA Employer Contribution$10,100.00$8,133.47$769.73$1,966.5380.53%
E 101-41000-126 MEDICARE Employer Contribution$2,400.00$2,216.00$180.02$184.0092.33%
E 101-41000-131 Employer Paid Health$23,600.00$24,287.28$495.75($687.28)102.91%
E 101-41000-132 Dental Insurance$2,900.00$886.71$0.00$2,013.2930.58%
E 101-41000-134 Employer Paid Life$600.00$480.00$40.00$120.0080.00%
E 101-41000-135 Employer Paid Disability$1,200.00$502.68$41.89$697.3241.89%
E 101-41000-151 Worker s Comp Insurance Prem$1,200.00$1,775.67$0.00($575.67)147.97%
E 101-41000-200 Office Supplies$1,000.00$1,111.64$282.61($111.64)111.16%
E 101-41000-203 Printed Forms & Papers$1,800.00$2,263.53$327.00($463.53)125.75%
E 101-41000-210 Operating Supplies$900.00$753.97$15.81$146.0383.77%
E 101-41000-301 Auditing and Acct g Services$20,800.00$21,600.00$0.00($800.00)103.85%
E 101-41000-303 Engineering Fees$0.00$180.00$0.00($180.00)0.00%
E 101-41000-304 Legal Services$40,000.00$28,895.45$4,204.55$11,104.5572.24%
E 101-41000-306 Personal Testing & Recruit$0.00$0.00$0.00$0.000.00%
American Legal $1,315;
E 101-41000-308 Other Professional Services$1,000.00$10,358.95$8,955.00($9,358.95)1035.90%PSN $89
E 101-41000-309 Software Support & Maintenance$12,000.00$20,133.10$3,338.84($8,133.10)167.78%
E 101-41000-314 Animal Control$800.00$1,049.00$0.00($249.00)131.13%
E 101-41000-316 Conferences & Seminars$500.00$0.00$0.00$500.000.00%
E 101-41000-317 Employee Training$1,300.00$155.00$0.00$1,145.0011.92%
E 101-41000-319 Other Services$4,500.00$4,970.09$421.72($470.09)110.45%
E 101-41000-321 Telephone$2,300.00$2,200.25$0.00$99.7595.66%
E 101-41000-322 Postage$2,500.00$1,557.17$420.47$942.8362.29%
E 101-41000-331 Travel Expenses$2,000.00$979.16$0.00$1,020.8448.96%
E 101-41000-351 Legal Notices Publishing$4,100.00$4,568.15$0.00($468.15)111.42%
E 101-41000-361 Liability/Property Ins$12,000.00$10,550.07$1,158.18$1,449.9387.92%
E 101-41000-381 Utilities-Electric & Gas$2,800.00$1,743.35$298.46$1,056.6562.26%
E 101-41000-413 Equipment Rental$27,800.00$27,846.00$2,320.50($46.00)100.17%
E 101-41000-430 Recycling$5,900.00$5,561.62$0.00$338.3894.26%
E 101-41000-433 Dues and Subscriptions$5,500.00$5,500.00$0.00$0.00100.00%
E 101-41000-434 Youth Service Bureau$0.00$0.00$539.76$0.000.00%
E 101-41000-438 Misc. Contractual$3,600.00$3,562.00$0.00$38.0098.94%
E 101-41000-570 Office Equipment$4,000.00$4,974.26$2,252.00($974.26)124.36%
Total Admin & Finance Dept. Expenditures$373,700.00$360,071.52$39,640.81$13,628.4896.35%
CITY OF SCANDIA
Revenue - Expenditure Summary
Dec-22
2022 YTD November Budget % of
BudgetAmountAmountBalanceBudget
Comments
Description
CITY COUNCIL
ExpendituresE 101-41110-101 Regular Wages & Salaries$18,100.00$13,459.15$0.00$4,640.8574.36%
E 101-41110-122 FICA Employer Contribution$1,100.00$212.60$0.00$887.4019.33%
E 101-41110-126 MEDICARE Employer Contribution$300.00$143.07$0.00$156.9347.69%
E 101-41110-127 PERA Defined$600.00$501.48$0.00$98.5283.58%
E 101-41110-151 Worker s Comp Insurance Prem$100.00$3.20$0.00$96.803.20%
E 101-41110-308 Other Professional Services$0.00$30.00$0.00($30.00)0.00%
E 101-41110-316 Conferences & Seminars$1,000.00$398.00$0.00$602.0039.80%
E 101-41110-331 Travel Expenses$1,800.00$0.00$0.00$1,800.000.00%
Total City Council Dept. Expenditures$23,000.00$14,747.50$0.00$8,252.5064.12%
ELECTIONS
ExpendituresE 101-41410-199 Election Judge$4,800.00$3,900.37$0.00$899.6381.26%
E 101-41410-200 Office Supplies$100.00$53.51$0.00$46.4953.51%
E 101-41410-203 Printed Forms & Papers$0.00$0.00$0.00$0.000.00%
E 101-41410-210 Operating Supplies$1,000.00$576.06$79.13$423.9457.61%
E 101-41410-351 Legal Notices Publishing$200.00$181.69$0.00$18.3190.85%
E 101-41410-413 Equipment Rental$1,500.00$1,515.00$0.00($15.00)101.00%
Total Elections Dept. Expenditures$7,600.00$6,226.63$79.13$1,373.3781.93%
PLANNING & BUILDING
ExpendituresE 101-41910-101 Regular Wages & Salaries$49,800.00$49,819.03$3,971.96($19.03)100.04%
E 101-41910-121 PERA Coord. Employer Contribution$3,600.00$3,735.50$297.92($135.50)103.76%
E 101-41910-122 FICA Employer Contribution$3,100.00$2,904.58$237.35$195.4293.70%
E 101-41910-126 MEDICARE Employer Contribution$700.00$692.09$55.50$7.9198.87%
E 101-41910-131 Employer Paid Health$11,400.00$11,997.77$262.50($597.77)105.24%
E 101-41910-132 Dental Insurance$1,900.00$458.59$0.00$1,441.4124.14%
E 101-41910-134 Employer Paid Life$200.00$172.80$14.40$27.2086.40%
E 101-41910-135 Employer Paid Disability$400.00$402.36$33.53($2.36)100.59%
2 copies of Unified Dev
E 101-41910-203 Printed Forms & Papers$20.00$253.55$0.00($233.55)1267.75%Code
E 101-41910-311 Contract Permit Inspections$55,000.00$66,968.23$11,143.89($11,968.23)121.76%
E 101-41910-312 Planning Services$28,000.00$25,466.61$2,721.88$2,533.3990.95%
E 101-41910-313 Committee & Commission Reimbur$5,000.00$4,950.00$1,300.00$50.0099.00%
E 101-41910-316 Conferences & Seminars$0.00$0.00$0.00$0.000.00%
E 101-41910-319 Other Services$0.00$0.00$0.00$0.000.00%
E 101-41910-361 Liability/Property Ins$1,800.00$2,005.53$0.00($205.53)111.42%
E 101-41910-438 Misc. Contractual$11,000.00$4,067.18$0.00$6,932.8236.97%
E 101-41910-439 Refunds Issued$0.00($572.80)$0.00$572.800.00%
E 101-41910-720 Operating Transfers$0.00$0.00$0.00$0.000.00%
Total Planning & Building Dept. Expenditures$171,920.00$121,014.10$12,792.40$72,505.9062.53%
ASSESSOR
GENERAL FUND CONT.
ExpendituresE 101-41960-300 Assessor$21,600.00$21,678.19$1,800.00($78.19)100.36%
POLICE
E 101-42100-318 Police Contract$150,400.00$75,206.76$0.00$75,193.2450.00%
E 101-42100-319 Other Services$500.00$309.36$0.00$190.6461.87%
Total GF Police Dept. Expenditures$150,900.00$75,516.12$0.00$75,383.8850.04%
CITY OF SCANDIA
Revenue - Expenditure Summary
Dec-22
2022 YTD November Budget % of
BudgetAmountAmountBalanceBudget
Comments
Description
FIRE
ExpendituresE 101-42200-101 Regular Wages & Salaries$95,000.00$122,206.30$10,928.04($27,206.30)128.64%
E 101-42200-121 PERA Coord. Employer Contribu.$9,700.00$0.00$0.00$9,700.000.00%
E 101-42200-122 FICA Employer Contribution$5,900.00$6,173.63$542.09($273.63)104.64%
E 101-42200-124 Police & Fire PERA$0.00$8,583.82$689.91($8,583.82)0.00%
E 101-42200-126 MEDICARE Employer Contribution$1,400.00$1,460.38$159.90($60.38)104.31%
E 101-42200-134 Employer Paid Life$200.00$192.00$16.00$8.0096.00%
E 101-42200-135 Employer Paid Disability$700.00$0.00$0.00$700.000.00%
E 101-42200-151 Worker s Comp Insurance Prem$9,550.00$13,008.42$0.00($3,458.42)136.21%
E 101-42200-200 Office Supplies$400.00$165.41$0.00$234.5941.35%
E 101-42200-203 Printed Forms & Papers$150.00$0.00$0.00$150.000.00%
E 101-42200-209 Medical Supplies$2,500.00$2,804.18$171.77($304.18)112.17%
E 101-42200-210 Operating Supplies$8,000.00$2,053.60$205.41$5,946.4025.67%
E 101-42200-211 Cleaning Supplies$100.00$44.34$0.00$55.6644.34%
E 101-42200-212 Fuel$2,500.00$5,130.66$530.05($2,630.66)205.23%
E 101-42200-217 Uniforms & Safety Equipment$10,000.00$550.00$0.00$9,450.005.50%
E 101-42200-221 Equipment Parts$3,000.00$290.29$0.00$2,709.719.68%
E 101-42200-222 Tires$0.00$1,540.36$0.00($1,540.36)0.00%
E 101-42200-223 Structure Repair & Supplies$5,300.00$440.88$21.26$4,859.128.32%
E 101-42200-240 Small Tools and Minor Equip$8,500.00$10,085.32$145.95($1,585.32)118.65%
SCBA user exams $2,595;
SCBA fit test $1,695
E 101-42200-305 Medical Services$4,500.00$7,330.00$0.00($2,830.00)162.89%
E 101-42200-306 Personal Testing & Recruit$1,500.00$1,205.26$251.00$294.7480.35%
E 101-42200-309 Software Support & Maintenance$17,000.00$14,523.53$558.00$2,476.4785.43%
E 101-42200-310 Medical Training$11,000.00$0.00$0.00$11,000.000.00%
E 101-42200-316 Conferences & Seminars$300.00$0.00$0.00$300.000.00%
E 101-42200-317 Employee Training$8,000.00$1,980.00$0.00$6,020.0024.75%
E 101-42200-319 Other Services$500.00$548.00$0.00($48.00)109.60%
E 101-42200-321 Telephone$6,400.00$6,392.28$527.03$7.7299.88%
E 101-42200-324 State of MN-Fire Relief$35,300.00$0.00$0.00$35,300.000.00%
E 101-42200-325 City Match-Fire Relief$0.00$0.00$0.00$0.000.00%
E 101-42200-331 Travel Expenses$2,000.00$0.00$0.00$2,000.000.00%
E 101-42200-334 Licenses & Permits$200.00$250.00$0.00($50.00)125.00%
E 101-42200-361 Liability/Property Ins$6,000.00$6,685.09$0.00($685.09)111.42%
E 101-42200-381 Utilities-Electric & Gas$4,000.00$6,085.77$239.56($2,085.77)152.14%
E 101-42200-384 Refuse/Garbage Disposal$850.00$954.75$0.00($104.75)112.32%
E 101-42200-385 Sewer Pumping & Maintenance$700.00$550.00$250.00$150.0078.57%
E 101-42200-401 Building Maintenance/Repairs$2,500.00$3,470.45$228.03($970.45)138.82%
E 101-42200-404 Repair Machinery/Equipment$8,000.00$8,594.68$0.00($594.68)107.43%
E 101-42200-407 Well Repair & Maintenance$140.00$0.00$0.00$140.000.00%
E 101-42200-433 Dues and Subscriptions$2,100.00$2,349.58$0.00($249.58)111.88%
E 101-42200-438 Misc. Contractual$4,100.00$2,013.62$408.62$2,086.3849.11%
E 101-42200-440 Events$800.00$1,156.65$318.71($356.65)144.58%
E 101-42200-530 Capital Impr Other Than Bldgs$0.00$1,178.00$0.00($1,178.00)0.00%
E 101-42200-560 Furniture and Fixtures$500.00$0.00$0.00$500.000.00%
E 101-42200-570 Office Equipment$900.00$0.00$0.00$900.000.00%
Total Fire Dept Expenditures$280,190.00$239,997.25$16,191.33$40,192.7585.66%
ANIMAL CONTROL
ExpendituresE 101-42700-314 Animal Control$4,000.00$5,081.83$765.31($1,081.83)127.05%
CITY OF SCANDIA
Revenue - Expenditure Summary
Dec-22
2022 YTD November Budget % of
BudgetAmountAmountBalanceBudget
Comments
Description
PUBLIC WORKS
GENERAL FUND CONT.
ExpendituresE 101-43000-101 Regular Wages & Salaries$220,300.00$210,255.92$17,044.72$10,044.0895.44%
E 101-43000-102 OT Regular Wages$4,900.00$8,865.58$1,132.90($3,965.58)180.93%
E 101-43000-104 Temporary Employee Wages$3,700.00$4,434.19$1,422.59($734.19)119.84%
E 101-43000-121 PERA Coord. Employer Contribu.$16,900.00$16,417.90$1,363.31$482.1097.15%
E 101-43000-122 FICA Employer Contribution$14,000.00$13,690.52$1,113.28$309.4897.79%
E 101-43000-126 MEDICARE Employer Contribution$3,300.00$3,237.21$270.46$62.7998.10%
E 101-43000-131 Employer Paid Health$53,600.00$55,964.04$485.25($2,364.04)104.41%
E 101-43000-132 Dental Insurance$2,000.00$914.54$0.00$1,085.4645.73%
E 101-43000-134 Employer Paid Life$700.00$740.64$61.72($40.64)105.81%
E 101-43000-135 Employer Paid Disability$1,700.00$1,737.48$144.79($37.48)102.20%
E 101-43000-141 Unemployment Compensation$1,500.00$0.00$0.00$1,500.000.00%
E 101-43000-151 Worker s Comp Insurance Prem$16,890.00$23,017.71$0.00($6,127.71)136.28%
E 101-43000-200 Office Supplies$600.00$0.00$0.00$600.000.00%
E 101-43000-210 Operating Supplies$8,000.00$8,992.71$486.62($992.71)112.41%
E 101-43000-212 Fuel$18,000.00$23,667.38$2,779.68($5,667.38)131.49%
E 101-43000-217 Uniforms & Safety Equipment$2,000.00$827.52$183.98$1,172.4841.38%
E 101-43000-221 Equipment Parts$12,100.00$14,070.81$997.07($1,970.81)116.29%
E 101-43000-222 Tires$6,500.00$7,384.98$1,292.28($884.98)113.62%
E 101-43000-223 Structure Repair & Supplies$2,000.00$0.00$0.00$2,000.000.00%
E 101-43000-224 Materials for Road Maintenance$15,000.00$11,809.07$0.00$3,190.9378.73%
E 101-43000-226 Sign Replacement and Repair$2,000.00$3,062.62$0.00($1,062.62)153.13%
E 101-43000-228 Gravel$9,900.00$1,830.17$0.00$8,069.8318.49%
E 101-43000-229 Salt$19,000.00$15,652.75$0.00$3,347.2582.38%
E 101-43000-240 Small Tools and Minor Equip$5,000.00$1,620.09$743.19$3,379.9132.40%
E 101-43000-302 Surveying$0.00$0.00$0.00$0.000.00%
E 101-43000-303 Engineering Fees$9,400.00$7,049.97$891.00$2,350.0375.00%
E 101-43000-305 Medical Services$1,200.00$874.25$139.95$325.7572.85%
E 101-43000-309 Software Support & Maintenance$1,900.00$2,854.00$1,219.00($954.00)150.21%
E 101-43000-317 Employee Training$1,700.00$798.55$0.00$901.4546.97%
E 101-43000-319 Other Services$13,200.00$6,099.55$1,225.55$7,100.4546.21%
E 101-43000-321 Telephone$4,800.00$5,252.81$348.68($452.81)109.43%
E 101-43000-331 Travel Expenses$500.00$0.00$0.00$500.000.00%
E 101-43000-334 Licenses & Permits$500.00$183.25$0.00$316.7536.65%
E 101-43000-361 Liability/Property Ins$9,300.00$10,361.91$0.00($1,061.91)111.42%
E 101-43000-381 Utilities-Electric & Gas$3,200.00$4,407.58$193.74($1,207.58)137.74%
E 101-43000-384 Refuse/Garbage Disposal$900.00$1,032.63$0.00($132.63)114.74%
E 101-43000-385 Sewer Pumping & Maintenance$800.00$1,005.80$250.00($205.80)125.73%
E 101-43000-387 Street Light Utilities$4,000.00$3,977.50$439.79$22.5099.44%
E 101-43000-401 Building Maintenance/Repairs$5,500.00$9,959.21$240.62($4,459.21)181.08%
E 101-43000-404 Repair Machinery/Equipment$14,000.00$19,807.67$368.26($5,807.67)141.48%
E 101-43000-405 Contractual Road Maint/Repair$150,000.00$91,929.60$1,223.63$58,070.4061.29%
E 101-43000-407 Well Repair & Maintenance$0.00$0.00$0.00$0.000.00%
E 101-43000-413 Equipment Rental$3,500.00$2,276.29$0.00$1,223.7165.04%
E 101-43000-417 Uniform Rental$1,000.00$898.16$76.76$101.8489.82%
E 101-43000-433 Dues and Subscriptions$200.00$0.00$0.00$200.000.00%
E 101-43000-438 Misc. Contractual$15,000.00$6,796.52$650.00$8,203.4845.31%
E 101-43000-530 Capital Impr Other Than Bldgs$0.00$1,178.00$0.00($1,178.00)0.00%
E 101-43000-570 Office Equipment$3,300.00$2,921.45$65.99$378.5588.53%
Total Public Works Dept. Expenditures$683,490.00$607,858.53$36,854.81$75,631.4788.93%
CITY OF SCANDIA
Revenue - Expenditure Summary
Dec-22
2022 YTD November Budget % of
BudgetAmountAmountBalanceBudget
Comments
Description
GENERAL FUND CONT.PARKS & RECREATION
ExpendituresE 101-45000-101 Regular Wages & Salaries$9,800.00$8,617.73$742.58$1,182.2787.94%
E 101-45000-104 Temporary Employee Wages$29,100.00$12,691.01$0.00$16,408.9943.61%
E 101-45000-121 PERA Coord. Employer Contribu.$700.00$644.80$55.68$55.2092.11%
E 101-45000-122 FICA Employer Contribution$2,600.00$1,279.72$43.64$1,320.2849.22%
E 101-45000-126 MEDICARE Employer Contribution$600.00$316.23$10.22$283.7752.71%
E 101-45000-131 Employer Paid Health$2,100.00$2,440.95$17.50($340.95)116.24%
E 101-45000-132 Dental Insurance$100.00$33.22$0.00$66.7833.22%
E 101-45000-134 Employer Paid Life$0.00$143.76$11.98($143.76)0.00%
E 101-45000-135 Employer Paid Disability$1,000.00$372.60$31.05$627.4037.26%
E 101-45000-141 Unemployment Compensation$0.00$119.13$0.00($119.13)0.00%
E 101-45000-151 Worker s Comp Insurance Prem$1,450.00$1,970.60$0.00($520.60)135.90%
E 101-45000-200 Office Supplies$300.00$0.00$0.00$300.000.00%
E 101-45000-203 Printed Forms & Papers$900.00$77.60$0.00$822.408.62%
E 101-45000-210 Operating Supplies$900.00$820.91$14.99$79.0991.21%
E 101-45000-212 Fuel$1,500.00$516.71$0.00$983.2934.45%
E 101-45000-221 Equipment Parts$2,000.00$970.72$0.00$1,029.2848.54%
E 101-45000-223 Structure Repair & Supplies$500.00$362.26$0.00$137.7472.45%
E 101-45000-240 Small Tools and Minor Equip$0.00$359.90$0.00($359.90)0.00%
E 101-45000-312 Planning Services$0.00$0.00$0.00$0.000.00%
E 101-45000-313 Committee & Commission Reimbur$1,200.00$1,140.00$300.00$60.0095.00%
E 101-45000-319 Other Services$0.00$1,861.01$0.00($1,861.01)0.00%
E 101-45000-322 Postage$0.00$0.00$0.00$0.000.00%
E 101-45000-340 Advertising$0.00$180.00$0.00($180.00)0.00%
E 101-45000-353 Sales& Use Tax$0.00$0.00$0.00$0.000.00%
E 101-45000-361 Liability/Property Ins$7,100.00$7,910.69$0.00($810.69)111.42%
E 101-45000-381 Utilities-Electric & Gas$4,000.00$7,219.35$319.05($3,219.35)180.48%
E 101-45000-384 Refuse/Garbage Disposal$1,900.00$5,079.12$230.00($3,179.12)267.32%
E 101-45000-385 Sewer Pumping & Maintenance$500.00$457.68$0.00$42.3291.54%
E 101-45000-401 Building Maintenance/Repairs$6,000.00$3,997.80$60.00$2,002.2066.63%
E 101-45000-403 Improvements Other Than Bldgs$0.00$2,451.46$170.49($2,451.46)0.00%
E 101-45000-404 Repair Machinery/Equipment$700.00$308.46$208.46$391.5444.07%
E 101-45000-406 Grounds Care$4,000.00$2,728.09$1,197.00$1,271.9168.20%
E 101-45000-438 Misc. Contractual$3,000.00$1,500.00$1,000.00$1,500.0050.00%
E 101-45000-439 Refunds Issued$0.00$0.00$0.00$0.000.00%
E 101-45000-440 Events$3,000.00$9,124.28$2,613.63($6,124.28)304.14%Ice Sculpture $5,000
E 101-45000-490 Financial Assistance$0.00$0.00$0.00$0.000.00%
E 101-45000-530 Capital Impr Other Than Bldgs$10,000.00$4,993.82$4,943.82$5,006.1849.94%
E 101-45000-720 Operating Transfers$0.00$0.00$0.00$0.000.00%
Total Parks & Rec Dept. Expenditures$94,950.00$80,689.61$11,970.09$14,260.3984.98%
CITY OF SCANDIA
Revenue - Expenditure Summary
Dec-22
2022 YTD November Budget % of
BudgetAmountAmountBalanceBudget
Comments
Description
COMMUNITY CENTER
ExpendituresE 101-45180-101 Regular Wages & Salaries$14,400.00$13,871.74$1,071.34$528.2696.33%
E 101-45180-104 Temporary Employee Wages$0.00$0.00$0.00$0.000.00%
E 101-45180-121 PERA Coord. Employer Contribu.$1,100.00$1,003.07$80.32$96.9391.19%
E 101-45180-122 FICA Employer Contribution$900.00$810.24$62.93$89.7690.03%
E 101-45180-126 MEDICARE Employer Contribution$200.00$198.78$14.73$1.2299.39%
E 101-45180-131 Employer Paid Health$3,100.00$2,708.87$0.00$391.1387.38%
E 101-45180-134 Employer Paid Life$0.00$46.80$3.90($46.80)0.00%
E 101-45180-135 Employer Paid Disability$100.00$137.28$11.44($37.28)137.28%
E 101-45180-151 Worker s Comp Insurance Prem$0.00$0.00$0.00$0.000.00%
E 101-45180-210 Operating Supplies$2,800.00$2,407.28$146.87$392.7285.97%
E 101-45180-223 Structure Repair & Supplies$6,500.00$117.71$0.00$6,382.291.81%
E 101-45180-334 Licenses & Permits$900.00$777.00$0.00$123.0086.33%
E 101-45180-361 Liability/Property Ins$2,300.00$2,562.62$0.00($262.62)111.42%
E 101-45180-381 Utilities-Electric & Gas$10,600.00$9,296.02$734.83$1,303.9887.70%
E 101-45180-384 Refuse/Garbage Disposal$1,800.00$1,602.52$0.00$197.4889.03%
E 101-45180-385 Sewer Pumping & Maintenance$3,500.00$3,193.59$0.00$306.4191.25%
E 101-45180-401 Building Maintenance/Repairs$13,000.00$15,354.95$4,705.90($2,354.95)118.12%
E 101-45180-404 Repair Machinery/Equipment$3,000.00$332.00$0.00$2,668.0011.07%
E 101-45180-406 Grounds Care$650.00$519.71$519.71$130.2979.96%
E 101-45180-407 Well Repair & Maintenance$600.00$13,675.00$0.00($13,075.00)2279.17%Well repair
E 101-45180-438 Misc. Contractual$2,500.00$669.43$669.43$1,830.5726.78%
E 101-45180-439 Refunds Issued$0.00$0.00$0.00$0.000.00%
E 101-45180-520 Capital Improvements to Bldgs$6,000.00$9,779.31$5,657.81($3,779.31)162.99%
E 101-45180-530 Capital Impr Other Than Bldgs$0.00$0.00$0.00$0.000.00%
E 101-45180-570 Office Equipment$0.00$0.00$0.00$0.000.00%
E 101-45180-720 Operating Transfers$0.00$0.00$0.00$0.000.00%
Total Community Center Dept. Expenditures$73,950.00$79,063.92$13,679.21($5,113.92)106.92%
Operating TransfersE 101-49000-720 Operating Transfers$3,965,825.00$960,000.00($3,965,825.00)0.00%
TOTAL GENERAL FUND EXPENDITURES$1,885,300.00$1,490,931.10$120,980.69$222,448.9079.08%
CITY OF SCANDIA
Revenue - Expenditure Summary
Dec-22
2022 YTD November Budget % of
BudgetAmountAmountBalanceBudget
Comments
Description
COVID RELIEF FUND
RevenueR 203-46200-33150 Federal Grant$0.00$228,181.31$0.00($228,181.31)0.00%
ExpendituresE 203-49000-720 Operating Transfers$0.00$0.00$0.00$0.000.00%
EDA FUND
RevenueR 225-46500-31000 Washington Cty. Tax Settlement$8,000.00$8,000.00$4,000.00$0.00100.00%
R 225-46500-33640 Other Grants$0.00$0.00$0.00$0.000.00%
$0.00$750.00$0.00($750.00)0.00%
R 225-46500-34750 Facilities Rental
R 225-46500-36210 Interest Income$200.00$0.00$0.00$200.000.00%
R 225-46500-36230 Donations$0.00$300.00$0.00($300.00)0.00%
R 225-46500-39203 Transfer from Other Funds$0.00$0.00$0.00$0.000.00%
Total EDA Fund Revenue$8,200.00$9,050.00$4,000.00($850.00)110.37%
ExpenditureE 225-46500-210 Operating Supplies$0.00$176.06$155.06($176.06)0.00%
E 225-46500-303 Engineering Fees$5,000.00$0.00$0.00$5,000.000.00%
E 225-46500-308 Other Professional Services$0.00$0.00$0.00$0.000.00%
E 225-46500-340 Advertising$125.00$0.00$0.00$125.000.00%
E 225-46500-433 Dues and Subscriptions$2,000.00$75.00$0.00$1,925.003.75%
E 225-46500-440 Events$2,650.00$1,653.00$0.00$997.0062.38%
E 225-46500-720 Operating Transfers$400.00$2,808.42$0.00($2,408.42)702.11%
Total EDA Fund Expenditures$10,175.00$4,712.48$155.06$5,462.5246.31%
CABLE TV FUND
RevenueR 226-41950-36210 Interest Income$0.00$442.31$0.00($442.31)0.00%
R 226-41950-38050 Cable TV Franchise Rebates$15,400.00$17,418.99$1,588.01($2,018.99)113.11%
R 226-41950-38051 PEG Fees$3,500.00$4,329.89$437.86($829.89)123.71%
Total Cable TV Fund Revenue$18,900.00$22,191.19$2,025.87($3,291.19)1.174137
ExpendituresE 226-41950-240 Small Tools and Minor Equip$0.00$498.00$0.00($498.00)0.00%
E 226-41950-309 Software Support & Maintenance$3,500.00$2,725.28$129.12$774.7277.87%
E 226-41950-438 Misc. Contractual$8,000.00$7,519.00$1,840.00$481.0093.99%
Council Chambers AV
E 226-41950-570 Office Equipment$250.00$41,511.57$14,521.94($41,261.57)16604.63%equipment 1/2
Total Cable TV Fund Expenditures$11,750.00$52,253.85$16,491.06($40,503.85)444.71%
GATEWAY TRAIL FUND
RevenueR 230-45000-36230 Donations$0.00$3,400.00$0.00($3,400.00)0.00%
ExpendituresE 230-45000-308 Other Professional Services$0.00$3,575.00$0.00($3,575.00)0.00%
CITY OF SCANDIA
Revenue - Expenditure Summary
Dec-22
2022 YTD November Budget % of
BudgetAmountAmountBalanceBudget
Comments
Description
BLACKTOP PROJECT 2007
RevenueR 307-47000-31952 SA Penalties & Interest$0.00$6,698.52$0.00($6,698.52)0.00%
2013 EQUIPMENT CERTIFICATES
RevenueR 313-47000-31000 Washington Cty. Tax Settlement$67,000.00$67,000.00$33,500.00$0.00100.00%
ExpenditureE 313-47000-601 Long Term Debt Principal$60,000.00$60,000.00$0.00$0.00100.00%
E 313-47000-611 Long Term Debt Interest$2,790.00$2,790.00$0.00$0.00100.00%
E 313-47000-620 Fiscal Agent s Fees$495.00$495.00$0.00$0.00100.00%
Total 2013 Fund Expenditures$63,285.00$63,285.00$0.00$0.00100.00%
2017 EQUIPMENT CERTIFICATES
RevenueR 317-47000-31000 Washington Cty. Tax Settlement$34,524.00$34,524.00$17,262.00$0.00100.00%
ExpendituresE 317-47000-601 Long Term Debt Principal$32,000.00$32,000.00$0.00$0.00100.00%
E 317-47000-611 Long Term Debt Interest$880.00$880.00$0.00$0.00100.00%
E 317-47000-620 Fiscal Agent s Fees$495.00$0.00$0.00$495.000.00%
Total 2017 Fund Expenditures$33,375.00$32,880.00$0.00$495.0098.52%
2018 STREET RECONSTRUCTION
RevenueR 318-47000-31000 Washington Cty. Tax Settlement$344,531.00$344,531.00$172,265.50$0.00100.00%
ExpenditureE 318-47000-601 Long Term Debt Principal$230,000.00$230,000.00$0.00$0.00100.00%
E 318-47000-611 Long Term Debt Interest$98,125.00$98,125.02$0.00($0.02)100.00%
E 318-47000-620 Fiscal Agent s Fees$495.00$495.00$0.00$0.00100.00%
Total 2018 Street Reconstruction Fund Expenditures$328,620.00$328,620.02$0.00($0.02)100.00%
CITY OF SCANDIA
Revenue - Expenditure Summary
Dec-22
2022 YTD November Budget % of
BudgetAmountAmountBalanceBudget
Comments
Description
CAPITAL IMPROVEMENTS
RevenueR 401-48000-31000 Washington Cty. Tax Settlement$217,336.00$217,336.00$108,668.00$0.00100.00%
R 401-48000-33422 Other State Grants & Aids$240,625.00$0.00$0.00$240,625.000.00%
R 401-48000-36100 Special Assessments$510.00$0.00$0.00$510.000.00%
R 401-48000-36210 Interest Income$4,500.00$0.00$0.00$4,500.000.00%
Total Capital Improvement Fund Revenue$462,971.00$217,336.00$108,668.00$245,635.0046.94%
ExpendituresE 401-41000-312 Planning Services$0.00$5,771.25$0.00($5,771.25)0.00%
E 401-41000-520 Capital Improvements to Bldgs$0.00$12,750.00$0.00($12,750.00)0.00%
E 401-41000-530 Capital Impr Other Than Bldgs$319,280.00$4,950.00$0.00$314,330.001.55%
E 401-45180-520 Capital Improvements to Bldgs$52,000.00$16,609.43$0.00$35,390.5731.94%
E 401-48000-435 Misc Expense$0.00$12,000.00$4,800.00($12,000.00)0.00%
E 401-48000-438 Misc. Contractual$286,000.00$0.00$0.00$286,000.000.00%
E 401-48000-530 Capital Impr Other Than Bldgs$0.00$7,800.00$0.00($7,800.00)0.00%
Total Capital Improvement Fund Expenditures$657,280.00$59,880.68$4,800.00$597,399.329.11%
PARK DEVELOPMENT
RevenueR 404-48000-31000 Washington Cty. Tax Settlement$20,000.00$10,000.00$0.00$10,000.0050.00%
R 404-48000-33422 Other State Grants & Aids$104,000.00$1,125.00$0.00$102,875.001.08%
R 404-48000-34780 Park Dedication Fees$3,000.00$0.00$0.00$3,000.000.00%
R 404-48000-36210 Interest Income$1,200.00$0.00$0.00$1,200.000.00%
R 404-48000-36230 Donations$0.00$7,948.98$5,024.49($7,948.98)0.00%
Total Park Development Fund Revenue$128,200.00$19,073.98$5,024.49$109,126.0214.88%
ExpenditureE 404-48000-312 Planning Services$15,600.00$10,500.00$3,000.00$5,100.0067.31%
E 404-48000-530 Capital Impr Other Than Bldgs$219,008.00$37,612.86$2,651.86$181,395.1417.17%
E 404-48000-720 Operating Transfers$1,440.00$0.00$0.00$1,440.000.00%
Total Park Development Fund Expenditures$236,048.00$48,112.86$5,651.86$187,935.140.2038266
EQUIPMENT REPLACEMENT FUND
RevenueR 406-48500-31000 Washington Cty. Tax Settlement$87,800.00$87,800.00$43,900.00$0.00100.00%
R 406-48500-36210 Interest Income$1,015.00$0.00$0.00$1,015.000.00%
R 406-48500-36260 Sale of Equipment$0.00$0.00$0.00$0.000.00%
Total Equipment Replacement Fund Revenue$88,815.00$87,800.00$43,900.00$1,015.0098.86%
ExpenditureE 406-48500-540 Heavy Machinery Capital$198,500.00$204,505.68$0.00($6,005.68)103.03%
E 406-48500-550 Motor Vehicles Capital$0.00$0.00$0.00$0.000.00%
Total Equipment Replacement Fund Expenditures$198,500.00$204,505.68$0.00($6,005.68)103.03%
LOCAL ROAD IMPROVEMENT FUND
RevenueR 408-43100-31000 Washington Cty. Tax Settlement$216,860.00$216,860.00$108,430.00$0.00100.00%
R 408-43100-33422 Other State Grants & Aids$0.00$17,743.50$6,453.50($17,743.50)0.00%
R 408-43100-36210 Interest Income$19,613.00$0.00$0.00$19,613.000.00%
Total LRIF Revenue$236,473.00$234,603.50$114,883.50$1,869.5099.21%
ExpenditureE 408-43100-303 Engineering Fees$0.00$119,069.10$7,562.90($119,069.10)0.00%
E 408-43100-530 Capital Impr Other Than Bldgs$707,200.00$439,941.62$14,162.83$267,258.3862.21%
Total LRIF Expenditures$707,200.00$559,010.72$21,725.73$148,189.2879.05%
CITY OF SCANDIA
Revenue - Expenditure Summary
Dec-22
2022 YTD November Budget % of
BudgetAmountAmountBalanceBudget
Comments
Description
BIG MARINE SEWER
RevenueR 602-43210-31951 Special Assessments Principal$0.00$2,845.85$0.00($2,845.85)0.00%
R 602-43210-31952 SA Penalties & Interest$0.00$537.86$176.33($537.86)0.00%
R 602-43210-33422 Other State Grants & Aids$0.00$0.00$0.00$0.000.00%
R 602-43210-34401 Sewer User Fees$109,592.00$84,470.30$7,370.60$25,121.7077.08%
R 602-43210-34402 SEWER HOOKUP FEE$0.00$8,000.00$0.00($8,000.00)0.00%
R 602-43210-36100 Special Assessments$300.00$0.00$0.00$300.000.00%
R 602-43210-36102 Penalties and Interest$0.00$40.87$0.00($40.87)0.00%
R 602-43210-36210 Interest Income$49.00$0.00$0.00$49.000.00%
Total Big Marine Sewer Revenue$109,941.00$95,894.88$7,546.93$14,046.1287.22%
ExpenditureE 602-43210-101 Regular Wages & Salaries$21,600.00$20,887.59$1,698.58$712.4196.70%
E 602-43210-121 PERA Coord. Employer Contribu.$1,600.00$1,565.66$127.40$34.3497.85%
E 602-43210-122 FICA Employer Contribution$1,300.00$1,222.16$99.97$77.8494.01%
E 602-43210-126 MEDICARE Employer Contribution$300.00$298.65$23.38$1.3599.55%
E 602-43210-151 Worker s Comp Insurance Prem$900.00$1,214.73$0.00($314.73)134.97%
E 602-43210-200 Office Supplies$200.00$127.77$0.00$72.2363.89%
E 602-43210-210 Operating Supplies$2,400.00$670.80$540.09$1,729.2027.95%
E 602-43210-240 Small Tools and Minor Equip$550.00$216.56$0.00$333.4439.37%
E 602-43210-303 Engineering Fees$10,400.00$17,670.00$378.00($7,270.00)169.90%
E 602-43210-304 Legal Services$2,200.00$5,236.04$444.17($3,036.04)238.00%
E 602-43210-308 Other Professional Services$1,200.00$756.00$756.00$444.0063.00%monthly testing
E 602-43210-309 Software Support & Maintenance$1,400.00$925.26$0.00$474.7466.09%
E 602-43210-317 Employee Training$2,100.00$1,926.93$0.00$173.0791.76%
E 602-43210-321 Telephone$550.00$200.00$0.00$350.0036.36%
E 602-43210-322 Postage$200.00$157.95$0.00$42.0578.98%
E 602-43210-331 Travel Expenses$1,600.00$824.15$0.00$775.8551.51%
E 602-43210-334 Licenses & Permits$900.00$1,002.76$0.00($102.76)111.42%
E 602-43210-361 Liability/Property Ins$2,500.00($1,703.54)$160.94$4,203.54-68.14%
E 602-43210-381 Utilities-Electric & Gas$11,000.00$11,410.00$0.00($410.00)103.73%
E 602-43210-385 Sewer Pumping & Maintenance$5,000.00$2,888.43$337.15$2,111.5757.77%
E 602-43210-386 Operation & Maintenance$16,000.00$2,401.09$0.00$13,598.9115.01%
E 602-43210-404 Repair Machinery/Equipment$350.00$0.00$0.00$350.000.00%
E 602-43210-413 Equipment Rental$52,200.00$0.00$0.00$52,200.000.00%
E 602-43210-420 Depreciation Expense$9,000.00$2,549.51$893.75$6,450.4928.33%
E 602-43210-438 Misc. Contractual$0.00$0.00$0.00$0.000.00%
E 602-43210-530 Capital Impr Other Than Bldgs$79,612.00$45,830.00$0.00$33,782.0057.57%
Total Big Marine Sewer Expenditures$225,062.00$118,278.50$5,459.43$106,783.5052.55%
CITY OF SCANDIA
Revenue - Expenditure Summary
Dec-22
2022 YTD November Budget % of
BudgetAmountAmountBalanceBudget
Comments
Description
UPTOWN SEWER
RevenueR 612-43210-34401 Sewer User Fees$19,500.00$11,192.74$4,812.47$8,307.2657.40%
R 612-43210-36210 Interest Income$92.00$0.00$0.00$92.000.00%
Total Uptown Sewer Revenue$19,592.00$11,192.74$4,812.47$8,399.2657.13%
ExpenditureE 612-43210-101 Regular Wages & Salaries$9,300.00$8,928.60$705.82$371.4096.01%
E 612-43210-121 PERA Coord. Employer Contribu.$700.00$669.58$52.98$30.4295.65%
E 612-43210-122 FICA Employer Contribution$600.00$523.48$41.48$76.5287.25%
E 612-43210-126 MEDICARE Employer Contribution$100.00$126.29$9.68($26.29)126.29%
E 612-43210-151 Worker s Comp Insurance Prem$0.00$303.67$0.00($303.67)0.00%
E 612-43210-200 Office Supplies$100.00$0.00$0.00$100.000.00%
E 612-43210-210 Operating Supplies$200.00$500.00$0.00($300.00)250.00%
E 612-43210-221 Equipment Parts$200.00$0.00$0.00$200.000.00%
E 612-43210-303 Engineering Fees$300.00$0.00$0.00$300.000.00%
E 612-43210-308 Other Professional Services$400.00$422.00$0.00($22.00)105.50%
E 612-43210-309 Software Support & Maintenance$0.00$84.00$84.00($84.00)0.00%
E 612-43210-317 Employee Training$350.00$0.00$0.00$350.000.00%
E 612-43210-322 Postage$0.00$0.00$0.00$0.000.00%
E 612-43210-334 Licenses & Permits$400.00$217.00$0.00$183.0054.25%
E 612-43210-361 Liability/Property Ins$300.00$334.25$0.00($34.25)111.42%
E 612-43210-381 Utilities-Electric & Gas$1,700.00$535.03$90.12$1,164.9731.47%
E 612-43210-385 Sewer Pumping & Maintenance$1,200.00$327.17$0.00$872.8327.26%
E 612-43210-386 Operation & Maintenance$600.00$461.55$0.00$138.4576.93%
E 612-43210-404 Repair Machinery/Equipment$1,500.00$465.00$0.00$1,035.0031.00%
E 612-43210-420 Depreciation Expense$55,100.00$0.00$0.00$55,100.000.00%
E 612-43210-438 Misc. Contractual$1,200.00$548.00$0.00$652.0045.67%
E 612-43210-530 Capital Impr Other Than Bldgs$2,600.00$0.00$0.00$2,600.000.00%
Total Uptown Sewer Expenditures$76,850.00$14,445.62$984.08$62,404.3818.80%