06.b Treasurer's Monthly Report 2023
City of Scandia
aug
Treasurer’s Report
3/31/2023
FUND ACCOUNTING
Beginning Cash Balance $ 3,911,802.57
3/1/2023
Beginning Checking Balance$ 156,938.29
Checking Receipts
$ 31,606.96
Transfers to Checking
$ 180,000.00
Total Deposits
$ 211,606.96
Expenditures$ (209,001.55)
Payroll$ (34,470.97)
Transfer to EDA in Transit
Total Payments
$ (243,472.52)
Ending Checking Balance
$ 125,072.73
Beginnging Money Market Balance
$ 1,740,282.75
Money Market Receipts
$ 1,321.32
Tranfer to Checking
$ (180,000.00)
0
Ending Money Market Balance
$ 1,561,604.07
Beginning Investments Balance
$ 2,043,003.90
Investments Receipts
$ 5,399.59
Ending Investments Balance$ 2,048,403.49
Beginning EDA Balance$ 33,356.07
EDA Receipts
$ -
EDA Expenditures
EDA De;posit in Transit
EDA Transfers from Checking
Ending EDA Balance$ 33,356.07
Outstanding Checks
$ (6,446.06)
3/31/2023
Ending Cash Balance $ 3,761,990.30
CHECKING, MONEY MARKET & INVESTMENT CD's
Checking *102$ 156,938.29
Beg Bal
Credits$ 211,606.96
Debits$ (243,472.52)
Transfer in Transit
$ 125,072.73
End Bal
Money Market *105 - Rate 1.25%$ 1,740,282.75
Beg Bal
rate change from .25% Credits
$ 1,321.32
Debits
$ (180,000.00)
End Bal$ 1,561,604.07
Investments
CD *4422 - Rate 4.00% 12 mo., 3/25/2024 **NEW RATE$ 317,850.51
CD *4424 - Rate 2.50% 12 mo., 7/17/2023 $ 446,907.03
CD *4425 - Rate 2.875% 12 mo., 9/28/2023 $ 744,824.34
CD *4426 - Rate 3.50%% 12 mo., 1/29/2024
$ 538,821.61
Total Investments$ 2,048,403.49
Total Bank & Investment Accounts
$ 3,735,080.29
$ (6,446.06)
Checks in Transit *3102
Transfer to EDA in Transit
Deposit in transit money market
$ 3,728,634.23
Total Adjusted Undesignated Funds
Scandia EDA *6301 $ 33,356.07
Receipts
Expenditures
Checks in Transit
Deposit in Transit
Total Designated EDA Funds$ 33,356.07
Total Funds$ 3,761,990.30
Submitted by: Colleen Firkus, Treasurer
2023 CASH BALANCES
END OF MONTH
FUNDJANUARYFEBRUARYMARCH
101 GENERAL$1,365,932$1,204,052$1,078,538
203 COVID-19 RELIEF$456,363$456,363
$456,362.62
226 CABLE TV$11,271$12,786$9,481
230 GATEWAY TRAIL$0$0$0
307 BLACKTOP PROJECT 2007$6,731$0$0
313 EQUIPMENT CERTIFICATES$28,825$28,873$28,873
315 EQUIPMENT CERTIFICATES$15,951$0$0
317 EQUIPMENT CERTIFICATES$2,187$0$0
318 BLACKTOP PROJECT$20,270$45,284$45,284
401 CAPITAL IMPR$749,162$749,497$745,297
404 PARK CAP IMPR$148,177$148,797$148,797
406 EQUIPMENT REPLACEMENT$199,727$200,548$200,548
408 LOCAL ROAD IMPROVEMENT$916,080$910,085$901,556
602 BIG MARINE SEWER$80,462$74,771$75,858
612 UPTOWN SEWER$10,330$15,160$13,957
801 ESCROW$21,817$32,240$24,131
SUBTOTAL$4,033,286$3,878,456$3,728,684
225 EDA$33,356$33,356$33,356
TOTAL$4,066,642$3,911,812$3,762,040
CITY OF SCANDIA
Revenue - Expenditure Summary
Mar-23
2023 YTD Budget
2023 BudgetAmountFebruaryBalance% of BudgetComments
Description
GENERAL FUND
RevenueR 101-41000-31000 Washington Cty. Tax Settlement$1,865,918.00$0.00$0.00$1,865,918.000.00%
R 101-41000-31040 Fiscal Disparities$0.00$0.00$0.00$0.000.00%
R 101-41000-31701 Gravel Taxes$20,000.00$0.00$0.00$20,000.000.00%
R 101-41000-31830 Solar Energy Production Tax$6,000.00$0.00$0.00$6,000.000.00%
R 101-41000-31900 Penalties & Interest Del Tax$400.00$0.00$0.00$400.000.00%
R 101-41000-32150 Utility Permits$3,000.00$1,050.00$450.00$1,950.0035.00%
R 101-41000-32180 Tobacco & Liquor Licenses$10,000.00$50.00$0.00$9,950.000.50%
R 101-41000-32190 Other City Permits$3,000.00$425.00$100.00$2,575.0014.17%
R 101-41000-32210 Building Permits$145,000.00$35,062.80$4,019.20$109,937.2024.18%
R 101-41000-32260 Gambling Permits$100.00$0.00$0.00$100.000.00%
R 101-41000-33401 LGA/MVHC/AG/PERA Aid$7,000.00$0.00$0.00$7,000.000.00%
R 101-41000-33420 Fire Relief State PERA$37,000.00$0.00$0.00$37,000.000.00%
Fire Training grants
R 101-41000-33422 Other State Grants & Aids$11,000.00$6,897.00$5,175.00$4,103.0062.70%
R 101-41000-33428 PILOT$6,000.00$0.00$0.00$6,000.000.00%
R 101-41000-33620 Recycling Grant$10,500.00$0.00$0.00$10,500.000.00%
R 101-41000-33630 Local Govt Grants & Aids$0.00$0.00$0.00$0.000.00%
R 101-41000-33640 Other Grants$1,200.00$0.00$0.00$1,200.000.00%
R 101-41000-34103 Zoning and Planning$6,700.00$1,200.00$0.00$5,500.0017.91%
R 101-41000-34106 Engineering Fees$500.00$0.00$0.00$500.000.00%
R 101-41000-34107 Assessment Search Fees$0.00$5.00$0.00($5.00)0.00%
R 101-41000-34109 Water Usage$100.00$0.00$0.00$100.000.00%
R 101-41000-34201 Impound Fees$0.00$0.00$0.00$0.000.00%
R 101-41000-34202 Fire Protection Services$34,300.00$0.00$0.00$34,300.000.00%
R 101-41000-34301 Damage Repairs$0.00$0.00$0.00$0.000.00%
R 101-41000-34303 Dust Control$2,700.00$0.00$0.00$2,700.000.00%
R 101-41000-34304 Reimbursement for Services$3,000.00$300.00$300.00$2,700.0010.00%
R 101-41000-34305 Other Street Services$0.00$0.00$0.00$0.000.00%
R 101-41000-34730 Ad Revenue$0.00$0.00$0.00$0.000.00%
R 101-41000-34750 Facilities Rental$5,500.00$966.67$350.00$4,533.3317.58%
R 101-41000-34760 Cleaning Fees$100.00$0.00$0.00$100.000.00%
R 101-41000-34790 Recreation Programs$2,100.00$760.00$0.00$1,340.0036.19%
R 101-41000-35101 Fines & Forfeitures$7,400.00$1,201.90$875.25$6,198.1016.24%
distributed among funds at EOY
R 101-41000-36210 Interest Income$12,100.00$10,712.65$6,722.11$1,387.3588.53%
Veterans Memorial Upkeep $1,090; Lions
R 101-41000-36230 Donations$2,000.00$3,941.30$1,090.20($1,941.30)197.07%
Vinterfest Fireworks $2,000
R 101-41000-36240 Insurance Dividend$4,100.00$0.00$0.00$4,100.000.00%
R 101-41000-36250 Misc. Refund$3,800.00$0.00$0.00$3,800.000.00%
R 101-41000-39200 Interfund Operating Transfer$0.00$0.00$0.00$0.000.00%
Total General Fund Revenue$2,210,518.00$62,572.32$19,081.76$2,147,945.682.83%
Operating TransfersR 101-49000-39203 Transfer from Other Funds$0.00$215,000.00$0.00($215,000.00)
R 101-49000-39204 Money Market Transfer$0.00$355,000.01$180,000.01($355,000.01)
Total Operating Transfers$570,000.01$180,000.01($570,000.01)
CITY OF SCANDIA
Revenue - Expenditure Summary
Mar-23
2023 YTD Budget
2023 BudgetAmountFebruaryBalance% of BudgetComments
Description
GENERAL FUNDADMINISTRATION & FINANCE
ExpenditureE 101-41000-101 Regular Wages & Salaries$192,700.00$11,531.01$6,980.89$181,168.995.98%
audit journal entries
E 101-41000-121 PERA Coord. Employer Contribu.$13,400.00($1,737.97)$523.58$15,137.97-12.97%
E 101-41000-122 FICA Employer Contribution$11,900.00$36.47$419.51$11,863.530.31%
E 101-41000-126 MEDICARE Employer Contribution$2,700.00$870.05$98.10$1,829.9532.22%
E 101-41000-131 Employer Paid Health$47,300.00$8,601.04$1,785.86$38,698.9618.18%
E 101-41000-132 Dental Insurance$3,400.00$219.25$54.81$3,180.756.45%
E 101-41000-134 Employer Paid Life$600.00$126.70$73.60$473.3021.12%
E 101-41000-135 Employer Paid Disability$900.00$270.65$59.75$629.3530.07%
E 101-41000-151 Worker s Comp Insurance Prem$1,300.00$0.00$0.00$1,300.000.00%
E 101-41000-200 Office Supplies$1,100.00$19.68$0.00$1,080.321.79%
E 101-41000-203 Printed Forms & Papers$1,900.00$185.68$185.68$1,714.329.77%
Award frames; March 10 meeting supplies
E 101-41000-210 Operating Supplies$800.00$349.93$340.03$450.0743.74%
E 101-41000-300 Assessor$0.00$0.00$0.00$0.000.00%
E 101-41000-301 Auditing and Acct g Services$23,500.00$0.00$0.00$23,500.000.00%
E 101-41000-303 Engineering Fees$0.00$0.00$0.00$0.000.00%
E 101-41000-304 Legal Services$55,000.00$8,740.50$4,716.75$46,259.5015.89%
E 101-41000-306 Personal Testing & Recruit$0.00$0.00$0.00$0.000.00%
Intermin City Admin Salary
E 101-41000-308 Other Professional Services$1,000.00$26,205.00$15,972.50($25,205.00)2620.50%
E 101-41000-309 Software Support & Maintenance$18,200.00$1,824.62$780.91$16,375.3810.03%
E 101-41000-314 Animal Control$0.00$0.00$0.00$700.000.00%
E 101-41000-316 Conferences & Seminars$700.00$0.00$0.00$200.000.00%
E 101-41000-317 Employee Training$200.00$0.00$0.00$200.000.00%
E 101-41000-319 Other Services$46,700.00$551.00$116.00$46,149.001.18%
E 101-41000-321 Telephone$3,700.00$1,224.20$424.64$2,475.8033.09%
E 101-41000-322 Postage$2,200.00$406.81$372.15$1,793.1918.49%
reimburse city admin applicant
E 101-41000-331 Travel Expenses$600.00$1,000.00$1,000.00($400.00)166.67%
E 101-41000-351 Legal Notices Publishing$1,200.00$839.66$0.00$360.3469.97%
E 101-41000-361 Liability/Property Ins$7,100.00$10,967.38$0.00($3,867.38)154.47%
E 101-41000-365 Insurance Claims$0.00$1,000.00$0.00($1,000.00)0.00%
budget for all depts in Fund 101
E 101-41000-381 Utilities-Electric & Gas$13,000.00$314.75$0.00$12,685.252.42%
E 101-41000-413 Equipment Rental$1,900.00$483.24$118.98$1,416.7625.43%
E 101-41000-430 Recycling$30,100.00$0.00$0.00$30,100.000.00%
E 101-41000-433 Dues and Subscriptions$6,100.00$75.00$0.00$6,025.001.23%
E 101-41000-434 Youth Service Bureau$5,500.00$0.00$0.00$5,500.000.00%
E 101-41000-435 Misc Expense$500.00$0.00$0.00$500.000.00%
Website Host; ABDO accounting assistance
E 101-41000-438 Misc. Contractual$4,000.00$2,496.25$2,032.50$1,503.7562.41%
E 101-41000-439 Refunds Issued$0.00$0.00$0.00$0.000.00%
E 101-41000-560 Furniture and Fixtures$0.00$0.00$0.00$0.000.00%
E 101-41000-570 Office Equipment$5,500.00$0.00$0.00$5,500.000.00%
E 101-41000-720 Operating Transfers$0.00$0.00$0.00$0.000.00%
Total Admin & Finance Dept. Expenditures$504,700.00$76,600.90$36,056.24$428,299.1015.18%
CITY OF SCANDIA
Revenue - Expenditure Summary
Mar-23
2023 YTD Budget
2023 BudgetAmountFebruaryBalance% of BudgetComments
Description
GENERAL FUND CONT.CITY COUNCIL
ExpendituresE 101-41110-101 Regular Wages & Salaries$18,100.00$0.00$0.00$18,100.000.00%
E 101-41110-122 FICA Employer Contribution$1,100.00$53.15$0.00$1,046.854.83%
audit journal entries
E 101-41110-126 MEDICARE Employer Contribution$300.00($52.08)$0.00$352.08-17.36%
audit journal entries
E 101-41110-127 PERA Defined$600.00($42.87)$0.00$642.87-7.15%
E 101-41110-151 Worker s Comp Insurance Prem$100.00$0.00$0.00$100.000.00%
E 101-41110-308 Other Professional Services$0.00$0.00$0.00$0.000.00%
E 101-41110-316 Conferences & Seminars$700.00$350.00$0.00$350.0050.00%
E 101-41110-331 Travel Expenses$0.00$561.97$561.97($561.97)0.00%
E 101-41110-439 Refunds Issued$0.00$0.00$0.00$0.000.00%
E 101-41110-560 Furniture and Fixtures$0.00$0.00$0.00$0.000.00%
E 101-41110-570 Office Equipment$0.00$0.00$0.00$0.000.00%
Total City Council Dept. Expenditures$20,900.00$870.17$561.97$20,029.834.16%
ELECTIONS
ExpendituresE 101-41410-199 Election Judge$0.00$0.00$0.00$0.000.00%
E 101-41410-200 Office Supplies$0.00$0.00$0.00$0.000.00%
E 101-41410-203 Printed Forms & Papers$0.00$0.00$0.00$0.000.00%
E 101-41410-210 Operating Supplies$200.00$0.00$0.00$200.000.00%
E 101-41410-351 Legal Notices Publishing$0.00$0.00$0.00$0.000.00%
E 101-41410-413 Equipment Rental$850.00$1,515.00$0.00($665.00)178.24%
Total Elections Dept. Expenditures$1,050.00$1,515.00$0.00($465.00)144.29%
PLANNING & BUILDING
ExpendituresE 101-41910-101 Regular Wages & Salaries$59,600.00$16,664.88$2,489.02$42,935.1227.96%
E 101-41910-121 PERA Coord. Employer Contribu.$4,200.00$615.70$186.68$3,584.3014.66%
E 101-41910-122 FICA Employer Contribution$3,700.00$989.98$145.44$2,710.0226.76%
E 101-41910-126 MEDICARE Employer Contribution$900.00$253.93$34.02$646.0728.21%
E 101-41910-131 Employer Paid Health$20,000.00$3,793.77$1,014.07$16,206.2318.97%
E 101-41910-132 Dental Insurance$1,500.00$146.16$36.54$1,353.849.74%
E 101-41910-134 Employer Paid Life$200.00$33.60$22.40$166.4016.80%
E 101-41910-135 Employer Paid Disability$500.00$94.95$31.65$405.0518.99%
E 101-41910-203 Printed Forms & Papers$600.00$0.00$0.00$600.000.00%
E 101-41910-311 Contract Permit Inspections$50,000.00$14,755.64$10,865.74$35,244.3629.51%
E 101-41910-312 Planning Services$50,000.00$10,928.41$10,833.56$39,071.5921.86%
E 101-41910-313 Committee & Commission Reimbur$5,000.00$550.00$550.00$4,450.0011.00%
E 101-41910-316 Conferences & Seminars$50.00$0.00$0.00$50.000.00%
E 101-41910-319 Other Services$0.00$0.00$0.00$0.000.00%
E 101-41910-361 Liability/Property Ins$4,900.00$5,400.60$0.00($500.60)110.22%
E 101-41910-438 Misc. Contractual$5,000.00$0.00$0.00$5,000.000.00%
E 101-41910-439 Refunds Issued$200.00$0.00$0.00$200.000.00%
E 101-41910-720 Operating Transfers$0.00$0.00$0.00$0.000.00%
Total Planning & Building Dept. Expenditures$206,350.00$54,227.62$26,209.12$152,122.3826.28%
ASSESSOR
ExpendituresE 101-41960-300 Assessor$21,600.00$5,400.00$1,800.00$16,200.0025.00%
POLICE
ExpendituresE 101-42100-318 Police Contract$168,499.00$0.00$0.00$168,499.000.00%
E 101-42100-319 Other Services$500.00$309.36$0.00$190.6461.87%
Total GF Police Dept. Expenditures$168,999.00$309.36$0.00$168,689.640.18%
CITY OF SCANDIA
Revenue - Expenditure Summary
Mar-23
2023 YTD Budget
2023 BudgetAmountFebruaryBalance% of BudgetComments
Description
FIRE
GENERAL FUND CONT.
ExpendituresE 101-42200-101 Regular Wages & Salaries$147,200.00$23,423.06$13,710.52$123,776.9415.91%
E 101-42200-121 PERA Coord. Employer Contribu.$0.00$0.00$0.00$0.000.00%
E 101-42200-122 FICA Employer Contribution$9,100.00$1,360.53$814.12$7,739.4714.95%
E 101-42200-124 Police & Fire PERA$3,600.00$2,180.30$708.98$1,419.7060.56%
E 101-42200-126 MEDICARE Employer Contribution$2,100.00$98.33$201.74$2,001.674.68%
E 101-42200-134 Employer Paid Life$200.00$48.00$32.00$152.0024.00%
E 101-42200-135 Employer Paid Disability$700.00$0.00$0.00$700.000.00%
E 101-42200-141 Unemployment Compensation$0.00$0.00$0.00$0.000.00%
E 101-42200-151 Worker s Comp Insurance Prem$9,100.00$0.00$0.00$9,100.000.00%
E 101-42200-200 Office Supplies$400.00$0.00$0.00$400.000.00%
E 101-42200-203 Printed Forms & Papers$150.00$0.00$0.00$150.000.00%
E 101-42200-209 Medical Supplies$3,000.00$195.50$0.00$2,804.506.52%
E 101-42200-210 Operating Supplies$8,000.00$3,739.69$3,586.19$4,260.3146.75%
E 101-42200-211 Cleaning Supplies$100.00$0.00$0.00$100.000.00%
E 101-42200-212 Fuel$3,500.00$683.85$431.60$2,816.1519.54%
E 101-42200-217 Uniforms & Safety Equipment$10,000.00$1,073.13$996.33$8,926.8710.73%
E 101-42200-221 Equipment Parts$3,000.00$55.73$0.00$2,944.271.86%
E 101-42200-222 Tires$0.00$0.00$0.00$0.000.00%
E 101-42200-223 Structure Repair & Supplies$2,000.00$185.61$0.00$1,814.399.28%
E 101-42200-240 Small Tools and Minor Equip$9,000.00$38.00$0.00$8,962.000.42%
SCBA User Exams + Annual Fit Test
E 101-42200-305 Medical Services$3,500.00$4,610.00$2,060.00($1,110.00)131.71%
E 101-42200-306 Personal Testing & Recruit$1,300.00$0.00$0.00$1,300.000.00%
E 101-42200-309 Software Support & Maintenance$17,000.00$1,116.00$588.00$15,884.006.56%
E 101-42200-310 Medical Training$2,000.00$0.00$0.00$2,000.000.00%
E 101-42200-316 Conferences & Seminars$250.00$0.00$0.00$250.000.00%
E 101-42200-317 Employee Training$15,000.00$1,440.00$870.00$13,560.009.60%
E 101-42200-319 Other Services$500.00$0.00$0.00$500.000.00%
E 101-42200-321 Telephone$6,800.00$1,286.12$531.35$5,513.8818.91%
E 101-42200-322 Postage$0.00$0.00$0.00$0.000.00%
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$1,500.00$500.38$317.42$999.6233.36%
E 101-42200-334 Licenses & Permits$200.00$0.00$0.00$200.000.00%
E 101-42200-340 Advertising$0.00$0.00$0.00$0.000.00%
E 101-42200-361 Liability/Property Ins$6,500.00$6,989.37$0.00($489.37)107.53%
E 101-42200-381 Utilities-Electric & Gas$8,000.00$3,458.95$1,720.83$4,541.0543.24%
E 101-42200-384 Refuse/Garbage Disposal$1,100.00$184.04$92.02$915.9616.73%
E 101-42200-385 Sewer Pumping & Maintenance$700.00$0.00$0.00$700.000.00%
E 101-42200-401 Building Maintenance/Repairs$2,500.00$378.03$150.00$2,121.9715.12%
E 101-42200-403 Improvements Other Than Bldgs$0.00$0.00$0.00$0.000.00%
E 101-42200-404 Repair Machinery/Equipment$8,000.00$1,088.93$1,088.93$6,911.0713.61%
E 101-42200-407 Well Repair & Maintenance$0.00$0.00$0.00$0.000.00%
E 101-42200-433 Dues and Subscriptions$2,400.00$1,184.00$0.00$1,216.0049.33%
E 101-42200-438 Misc. Contractual$4,100.00$0.00$0.00$4,100.000.00%
E 101-42200-440 Events$800.00$0.00$0.00$800.000.00%
E 101-42200-520 Capital Improvements to Bldgs$0.00$0.00$0.00$0.000.00%
E 101-42200-530 Capital Impr Other Than Bldgs$0.00$0.00$0.00$0.000.00%
E 101-42200-540 Heavy Machinery Capital$0.00$0.00$0.00$0.000.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%
E 101-42200-720 Operating Transfers$0.00$0.00$0.00$0.000.00%
Total Fire Dept Expenditures$330,000.00$55,317.55$27,900.03$274,682.4516.76%
ANIMAL CONTROL
ExpendituresE 101-42700-314 Animal Control$5,000.00$506.25$150.00$4,493.7510.13%
CITY OF SCANDIA
Revenue - Expenditure Summary
Mar-23
2023 YTD Budget
2023 BudgetAmountFebruaryBalance% of BudgetComments
Description
PUBLIC WORKS
GENERAL FUND CONT.
ExpendituresE 101-43000-101 Regular Wages & Salaries$229,700.00$51,332.97$17,387.32$178,367.0322.35%
E 101-43000-102 OT Regular Wages$5,000.00$3,607.76$1,072.10$1,392.2472.16%
snow plowing
E 101-43000-104 Temporary Employee Wages$2,300.00$3,980.23$1,159.13($1,680.23)173.05%
E 101-43000-121 PERA Coord. Employer Contribu.$17,600.00$4,106.00$1,384.42$13,494.0023.33%
E 101-43000-122 FICA Employer Contribution$14,600.00$3,224.22$1,116.97$11,375.7822.08%
E 101-43000-126 MEDICARE Employer Contribution$3,400.00$951.88$270.24$2,448.1228.00%
E 101-43000-131 Employer Paid Health$70,900.00$19,797.51$4,860.27$51,102.4927.92%
E 101-43000-132 Dental Insurance$2,300.00$352.61$88.15$1,947.3915.33%
E 101-43000-134 Employer Paid Life$700.00$181.60$116.32$518.4025.94%
E 101-43000-135 Employer Paid Disability$1,700.00$596.30$144.80$1,103.7035.08%
E 101-43000-141 Unemployment Compensation$0.00$0.00$0.00$0.000.00%
E 101-43000-151 Worker s Comp Insurance Prem$19,800.00$0.00$0.00$19,800.000.00%
E 101-43000-200 Office Supplies$600.00$0.00$0.00$600.000.00%
E 101-43000-210 Operating Supplies$8,400.00$314.03$222.63$8,085.973.74%
E 101-43000-212 Fuel$20,000.00$7,100.56$2,380.93$12,899.4435.50%
E 101-43000-217 Uniforms & Safety Equipment$2,200.00$201.44$0.00$1,998.569.16%
plow repair parts
E 101-43000-221 Equipment Parts$14,000.00$10,060.90$1,288.40$3,939.1071.86%
E 101-43000-222 Tires$7,500.00$0.00$0.00$7,500.000.00%
E 101-43000-223 Structure Repair & Supplies$2,200.00$0.00$0.00$2,200.000.00%
E 101-43000-224 Materials for Road Maintenance$16,500.00$1,114.83$610.15$15,385.176.76%
E 101-43000-226 Sign Replacement and Repair$0.00$0.00$0.00$0.000.00%
E 101-43000-228 Gravel$10,000.00$0.00$0.00$10,000.000.00%
snow, snow & snow
E 101-43000-229 Salt$20,000.00$18,093.42$0.00$1,906.5890.47%
E 101-43000-240 Small Tools and Minor Equip$8,000.00$3,623.62$0.00$4,376.3845.30%
E 101-43000-302 Surveying$0.00$0.00$0.00$0.000.00%
E 101-43000-303 Engineering Fees$10,000.00$132.00$346.50$9,868.001.32%
E 101-43000-304 Legal Services$0.00$0.00$0.00$0.000.00%
E 101-43000-305 Medical Services$1,200.00$99.90$0.00$1,100.108.33%
IWORQ subscription
E 101-43000-309 Software Support & Maintenance$2,000.00$5,000.00$0.00($3,000.00)250.00%
E 101-43000-317 Employee Training$1,700.00$1,010.00$0.00$690.0059.41%
E 101-43000-319 Other Services$13,600.00$58.10$4.05$13,541.900.43%
E 101-43000-321 Telephone$3,000.00$929.64$353.11$2,070.3630.99%
E 101-43000-331 Travel Expenses$500.00$0.00$0.00$500.000.00%
E 101-43000-334 Licenses & Permits$500.00$0.00$0.00$500.000.00%
E 101-43000-361 Liability/Property Ins$9,000.00$8,348.14$0.00$651.8692.76%
E 101-43000-365 Insurance Claims$0.00$0.00$0.00$0.000.00%
E 101-43000-381 Utilities-Electric & Gas$4,000.00$2,388.68$1,184.72$1,611.3259.72%
E 101-43000-384 Refuse/Garbage Disposal$1,000.00$122.72$61.36$877.2812.27%
E 101-43000-385 Sewer Pumping & Maintenance$1,600.00$0.00$0.00$1,600.000.00%
E 101-43000-387 Street Light Utilities$4,200.00$1,186.36$567.88$3,013.6428.25%
E 101-43000-401 Building Maintenance/Repairs$8,000.00$451.37$188.60$7,548.635.64%
E 101-43000-403 Improvements Other Than Bldgs$0.00$0.00$0.00$0.000.00%
plow truck repairs
E 101-43000-404 Repair Machinery/Equipment$15,500.00$9,252.74$3,049.00$6,247.2659.70%
E 101-43000-405 Contractual Road Maint/Repair$157,500.00$0.00$0.00$157,500.000.00%
E 101-43000-407 Well Repair & Maintenance$0.00$0.00$0.00$0.000.00%
E 101-43000-413 Equipment Rental$4,000.00$0.00$0.00$4,000.000.00%
E 101-43000-417 Uniform Rental$1,100.00$172.71$76.76$927.2915.70%
E 101-43000-433 Dues and Subscriptions$200.00$0.00$0.00$200.000.00%
E 101-43000-438 Misc. Contractual$15,750.00$0.00$0.00$15,750.000.00%
E 101-43000-439 Refunds Issued$0.00$0.00$0.00$0.000.00%
E 101-43000-530 Capital Impr Other Than Bldgs$0.00$0.00$0.00$0.000.00%
E 101-43000-550 Motor Vehicles Capital$0.00$0.00$0.00$0.000.00%
E 101-43000-560 Furniture and Fixtures$0.00$0.00$0.00$0.000.00%
E 101-43000-570 Office Equipment$1,000.00$0.00$0.00$1,000.000.00%
E 101-43000-720 Operating Transfers$0.00$0.00$0.00$0.000.00%
Total Public Works Dept. Expenditures$732,750.00$157,792.24$37,933.81$574,957.7621.53%
CITY OF SCANDIA
Revenue - Expenditure Summary
Mar-23
2023 YTD Budget
2023 BudgetAmountFebruaryBalance% of BudgetComments
Description
GENERAL FUND CONT.PARKS & RECREATION
ExpendituresE 101-45000-101 Regular Wages & Salaries$10,200.00$1,080.44$757.48$9,119.5610.59%
E 101-45000-104 Temporary Employee Wages$40,200.00$4,776.38$0.00$35,423.6211.88%
E 101-45000-121 PERA Coord. Employer Contribu.$800.00$78.65$56.80$721.359.83%
E 101-45000-122 FICA Employer Contribution$3,300.00$335.31$44.45$2,964.6910.16%
E 101-45000-126 MEDICARE Employer Contribution$800.00$105.85$10.39$694.1513.23%
E 101-45000-131 Employer Paid Health$2,700.00$598.72$185.45$2,101.2822.17%
E 101-45000-132 Dental Insurance$100.00$12.80$3.20$87.2012.80%
E 101-45000-134 Employer Paid Life$0.00$7.00$4.48($7.00)0.00%
E 101-45000-135 Employer Paid Disability$1,000.00$17.01$5.67$982.991.70%
E 101-45000-141 Unemployment Compensation$0.00$0.00$0.00$0.000.00%
E 101-45000-151 Worker s Comp Insurance Prem$1,900.00$0.00$0.00$1,900.000.00%
E 101-45000-200 Office Supplies$310.00$0.00$0.00$310.000.00%
E 101-45000-203 Printed Forms & Papers$930.00$0.00$0.00$930.000.00%
E 101-45000-210 Operating Supplies$930.00$31.96$31.96$898.043.44%
E 101-45000-212 Fuel$1,650.00$229.92$115.96$1,420.0813.93%
E 101-45000-221 Equipment Parts$2,100.00$290.38$9.98$1,809.6213.83%
E 101-45000-223 Structure Repair & Supplies$2,100.00$0.00$0.00$2,100.000.00%
E 101-45000-240 Small Tools and Minor Equip$400.00$0.00$0.00$400.000.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$240.00$240.00$960.0020.00%
E 101-45000-319 Other Services$0.00$0.00$0.00$0.000.00%
E 101-45000-322 Postage$0.00$0.00$0.00$0.000.00%
SCVRTA 2023 Ad
E 101-45000-340 Advertising$200.00$250.00$250.00($50.00)125.00%
E 101-45000-353 Sales& Use Tax$0.00$0.00$0.00$0.000.00%
E 101-45000-361 Liability/Property Ins$3,300.00$3,323.03$0.00($23.03)100.70%
E 101-45000-381 Utilities-Electric & Gas$4,500.00$1,389.15$703.98$3,110.8530.87%
E 101-45000-384 Refuse/Garbage Disposal$2,500.00$305.00$115.00$2,195.0012.20%
E 101-45000-385 Sewer Pumping & Maintenance$700.00$369.00$0.00$331.0052.71%
ice melt product
E 101-45000-401 Building Maintenance/Repairs$4,800.00$3,192.91$2,417.91$1,607.0966.52%
E 101-45000-403 Improvements Other Than Bldgs$0.00$170.49$170.49($170.49)0.00%
E 101-45000-404 Repair Machinery/Equipment$750.00$0.00$0.00$750.000.00%
E 101-45000-406 Grounds Care$4,000.00$0.00$0.00$4,000.000.00%
E 101-45000-438 Misc. Contractual$3,300.00$0.00$0.00$3,300.000.00%
E 101-45000-439 Refunds Issued$0.00$565.01$0.00($565.01)0.00%
Vinterfest
E 101-45000-440 Events$7,000.00$2,361.00$0.00$4,639.0033.73%
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$0.00$0.00$10,000.000.00%
E 101-45000-720 Operating Transfers$0.00$0.00$0.00$0.000.00%
Total Parks & Rec Dept. Expenditures$111,670.00$19,730.01$5,123.20$91,939.9917.67%
CITY OF SCANDIA
Revenue - Expenditure Summary
Mar-23
2023 YTD Budget
2023 BudgetAmountFebruaryBalance% of BudgetComments
Description
GENERAL FUND CONT.COMMUNITY CENTER
ExpendituresE 101-45180-101 Regular Wages & Salaries$15,000.00$3,309.83$1,103.28$11,690.1722.07%
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$247.38$82.73$852.6222.49%
E 101-45180-122 FICA Employer Contribution$900.00$187.30$64.67$712.7020.81%
E 101-45180-126 MEDICARE Employer Contribution$200.00$53.22$15.13$146.7826.61%
E 101-45180-131 Employer Paid Health$3,700.00$753.30$255.60$2,946.7020.36%
E 101-45180-134 Employer Paid Life$0.00$11.40$7.20($11.40)0.00%
E 101-45180-135 Employer Paid Disability$200.00$34.29$11.43$165.7117.15%
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,900.00$511.11$135.43$2,388.8917.62%
E 101-45180-223 Structure Repair & Supplies$6,500.00$0.00$0.00$6,500.000.00%
E 101-45180-334 Licenses & Permits$1,000.00$752.00$0.00$248.0075.20%
E 101-45180-361 Liability/Property Ins$800.00$795.60$0.00$4.4099.45%
E 101-45180-381 Utilities-Electric & Gas$11,200.00$3,310.82$1,596.81$7,889.1829.56%
E 101-45180-384 Refuse/Garbage Disposal$1,900.00$395.78$160.17$1,504.2220.83%
E 101-45180-385 Sewer Pumping & Maintenance$3,700.00$0.00$0.00$3,700.000.00%
Remove ice from Comm Ctr roof
E 101-45180-401 Building Maintenance/Repairs$15,000.00$6,214.37$5,593.78$8,785.6341.43%
E 101-45180-404 Repair Machinery/Equipment$5,000.00$50.00$0.00$4,950.001.00%
E 101-45180-406 Grounds Care$690.00$0.00$0.00$690.000.00%
E 101-45180-407 Well Repair & Maintenance$1,000.00$0.00$0.00$1,000.000.00%
E 101-45180-438 Misc. Contractual$2,700.00$0.00$0.00$2,700.000.00%
E 101-45180-439 Refunds Issued$0.00$450.00$0.00($450.00)0.00%
Council Chambers remodel
E 101-45180-520 Capital Improvements to Bldgs$6,000.00$7,475.61$0.00($1,475.61)124.59%
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$79,490.00$24,552.01$9,026.23$54,937.9930.89%
Operating TransfersE 101-49000-720 Operating Transfers$0.00$570,000.00$180,000.00($570,000.00)
TOTAL GENERAL FUND EXPENDITURES$2,182,509.00$396,821.11$144,760.60$1,785,887.8918.18%
CITY OF SCANDIA
Revenue - Expenditure Summary
Mar-23
2023 YTD Budget
2023 BudgetAmountFebruaryBalance% of BudgetComments
Description
COVID RELIEF FUND
RevenueR 203-46200-33150 Federal Grant$0.00$0.00$0.00$0.00
ExpendituresE 203-49000-720 Operating Transfers$0.00$0.00$0.00$0.00
EDA FUND
Revenue
R 225-46500-31000 Washington Cty. Tax Settlement$5,300.00$0.00$0.00$5,300.000.00%
R 225-46500-33640 Other Grants$0.00$0.00$0.00$0.000.00%
R 225-46500-34750 Facilities Rental$0.00$0.00$0.00$0.000.00%
R 225-46500-36210 Interest Income$200.00$0.00$0.00$200.000.00%
R 225-46500-36230 Donations$0.00$0.00$0.00$0.000.00%
R 225-46500-39203 Transfer from Other Funds$0.00$3,524.94$0.00($3,524.94)0.00%
Total EDA Fund Revenue$5,500.00$3,524.94$0.00$1,975.0664.09%
Expenditure
E 225-46500-210 Operating Supplies$500.00$0.00$0.00$500.000.00%
E 225-46500-303 Engineering Fees$0.00$0.00$0.00$0.000.00%
E 225-46500-304 Legal Services$0.00$0.00$0.00$0.000.00%
E 225-46500-308 Other Professional Services$300.00$0.00$0.00$300.000.00%
E 225-46500-340 Advertising$2,000.00$0.00$0.00$2,000.000.00%
EDAM Membership; Sister City Dues
E 225-46500-433 Dues and Subscriptions$1,700.00$805.00$190.00$895.0047.35%
E 225-46500-440 Events$800.00$0.00$0.00$800.000.00%
E 225-46500-720 Operating Transfers$0.00$3,524.94$0.00($3,524.94)0.00%
Total EDA Fund Expenditures$5,300.00$4,329.94$190.00$470.0681.70%
CABLE TV FUND
Revenue
R 226-41950-36210 Interest Income$100.00$0.00$0.00$100.000.00%
R 226-41950-38050 Cable TV Franchise Rebates$16,200.00$3,220.80$1,644.34$12,979.2019.88%
R 226-41950-38051 PEG Fees$4,200.00$884.05$445.34$3,315.9521.05%
Total Cable TV Fund Revenue$20,500.00$4,104.85$2,089.68$16,395.1520.02%
Expenditure
Council Chambers AV equipment
E 226-41950-240 Small Tools and Minor Equip$300.00$344.48$0.00($44.48)114.83%
E 226-41950-309 Software Support & Maintenance$3,500.00$149.16$149.16$3,350.844.26%
E 226-41950-438 Misc. Contractual$5,300.00$1,380.00$1,380.00$3,920.0026.04%
E 226-41950-570 Office Equipment$0.00$4,128.98$3,865.98($4,128.98)0.00%
Total Cable TV Fund Expenditures$9,100.00$6,002.62$5,395.14$3,097.3865.96%
GATEWAY TRAIL FUND
RevenueR 230-45000-36230 Donations$0.00$0.00$0.00$0.000.00%
ExpendituresE 230-45000-308 Other Professional Services$0.00$0.00$0.00$0.000.00%
2013 EQUIPMENT CERTIFICATES
Revenue
R 313-47000-31000 Washington Cty. Tax Settlement$64,000.00$0.00$0.00$64,000.000.00%
ExpenditureE 313-47000-601 Long Term Debt Principal$60,000.00$0.00$0.00$60,000.000.00%
E 313-47000-611 Long Term Debt Interest$3,047.00$0.00$0.00$3,047.000.00%
E 313-47000-620 Fiscal Agent s Fees$500.00$0.00$0.00$500.000.00%
Total 2013 Fund Expenditures$63,547.00$0.00$0.00$63,547.000.00%
2018 STREET RECONSTRUCTION
RevenueR 318-47000-31000 Washington Cty. Tax Settlement$342,546.00$0.00$0.00$342,546.000.00%
ExpenditureE 318-47000-601 Long Term Debt Principal$250,000.00$0.00$0.00$250,000.000.00%
E 318-47000-611 Long Term Debt Interest$91,225.00$0.00$0.00$91,225.000.00%
E 318-47000-620 Fiscal Agent s Fees$500.00$0.00$0.00$500.000.00%
Total 2018 Street Reconstruction Fund Expenditures$341,725.00$0.00$0.00$341,725.000.00%
CITY OF SCANDIA
Revenue - Expenditure Summary
Mar-23
2023 YTD Budget
2023 BudgetAmountFebruaryBalance% of BudgetComments
Description
CAPITAL IMPROVEMENTS
RevenueR 401-43100-36100 Special Assessments$0.00$0.00$0.00$0.000.00%
R 401-48000-31000 Washington Cty. Tax Settlement$293,791.00$0.00$0.00$293,791.000.00%
R 401-48000-33422 Other State Grants & Aids$0.00$0.00$0.00$0.000.00%
R 401-48000-36210 Interest Income$2,300.00$0.00$0.00$2,300.000.00%
Total Capital Improvement Fund Revenue$296,091.00$0.00$0.00$296,091.000.00%
ExpenditureE 401-41000-312 Planning Services$0.00$0.00$0.00$0.000.00%
E 401-41000-520 Capital Improvements to Bldgs$0.00$0.00$0.00$0.000.00%
E 401-41000-530 Capital Impr Other Than Bldgs$169,500.00$0.00$0.00$169,500.000.00%
E 401-42200-520 Capital Improvements to Bldgs$65,000.00$0.00$0.00$65,000.000.00%
Gateway Trail Lobbying
E 401-48000-435 Misc Expense$0.00$9,000.00$4,200.00($9,000.00)0.00%
E 401-48000-438 Misc. Contractual$0.00$0.00$0.00$0.000.00%
E 401-48000-520 Capital Improvements to Bldgs$0.00$0.00$0.00$0.000.00%
E 401-48000-530 Capital Impr Other Than Bldgs$100,000.00$0.00$0.00$100,000.000.00%
Total Capital Improvement Fund Expenditures$334,500.00$9,000.00$4,200.00$325,500.002.69%
PARK DEVELOPMENT
RevenueR 404-48000-31000 Washington Cty. Tax Settlement$20,000.00$0.00$0.00$20,000.000.00%
R 404-48000-33422 Other State Grants & Aids$0.00$0.00$0.00$0.000.00%
R 404-48000-34780 Park Dedication Fees$21,000.00$0.00$0.00$21,000.000.00%
R 404-48000-36210 Interest Income$66.00$0.00$0.00$66.000.00%
Lions Playground donation
R 404-48000-36230 Donations$0.00$10,000.00$0.00($10,000.00)0.00%
Total Park Development Fund Revenue$41,066.00$10,000.00$0.00$31,066.0024.35%
ExpenditureE 404-48000-312 Planning Services$0.00$0.00$0.00$0.000.00%
E 404-48000-520 Capital Improvements to Bldgs$17,306.00$0.00$0.00$17,306.000.00%
E 404-48000-720 Operating Transfers$0.00$0.00$0.00$0.000.00%
Total Park Development Fund Expenditures$17,306.00$0.00$0.00$17,306.000.00%
EQUIPMENT REPLACEMENT
RevenueR 406-48500-31000 Washington Cty. Tax Settlement$0.00$0.00$0.00$0.000.00%
R 406-48500-36210 Interest Income$1,030.00$0.00$0.00$1,030.000.00%
R 406-48500-36260 Sale of Equipment$35,000.00$0.00$0.00$35,000.000.00%
R 406-48500-39350 Certificate of Indebtedness$819,500.00$0.00$0.00$819,500.000.00%
Total Equipment Replacement Fund Revenue$855,530.00$0.00$0.00$855,530.000.00%
ExpenditureE 406-48500-540 Heavy Machinery Capital$325,000.00$0.00$0.00$325,000.000.00%
E 406-48500-550 Motor Vehicles Capital$189,500.00$0.00$0.00$189,500.000.00%
Total Equipment Replacement Fund Expenditures$514,500.00$0.00$0.00$514,500.000.00%
LOCAL ROAD IMPROVEMENT FUND
RevenueR 408-43100-31000 Washington Cty. Tax Settlement$212,012.00$0.00$0.00$212,012.000.00%
R 408-43100-33422 Other State Grants & Aids$0.00$0.00$0.00$0.000.00%
R 408-43100-36210 Interest Income$12,115.00$0.00$0.00$12,115.000.00%
R 408-43100-39310 Proceeds-Gen Obligation Bond$0.00$0.00$0.00$0.000.00%
Total LRIF Revenue$224,127.00$0.00$0.00$224,127.00$0.00
2023 Street Improvement Project
ExpenditureE 408-43100-303 Engineering Fees$20,000.00$8,518.50$8,518.50$11,481.5042.59%
E 408-43100-530 Capital Impr Other Than Bldgs$973,000.00$260.08$0.00$972,739.920.03%
Total LRIF Expenditures$993,000.00$8,778.58$8,518.50$984,221.420.88%
CITY OF SCANDIA
Revenue - Expenditure Summary
Mar-23
2023 YTD Budget
2023 BudgetAmountFebruaryBalance% of BudgetComments
Description
BIG MARINE SEWER
RevenueR 602-43210-31951 Special Assessments Principal$0.00$0.00$0.00$0.000.00%
R 602-43210-31952 SA Penalties & Interest$0.00$0.00$0.00$0.000.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$140,700.00$16,516.60$15,881.60$124,183.4011.74%
R 602-43210-34402 Sewer Connection Fee$0.00$8,000.00$0.00($8,000.00)0.00%
R 602-43210-36100 Special Assessments$600.00$0.00$0.00$600.000.00%
R 602-43210-36102 Penalties and Interest$0.00$0.00$0.00$0.000.00%
R 602-43210-36210 Interest Income$400.00$0.00$0.00$400.000.00%
Total Big Marine Sewer Revenue$141,700.00$24,516.60$15,881.60$117,183.4017.30%
ExpenditureE 602-43210-101 Regular Wages & Salaries$22,500.00$5,026.69$1,675.56$17,473.3122.34%
E 602-43210-120 Pension Expense$0.00$0.00$0.00$0.000.00%
E 602-43210-121 PERA Coord. Employer Contribu.$17,000.00$375.79$125.67$16,624.212.21%
E 602-43210-122 FICA Employer Contribution$1,400.00$284.53$98.38$1,115.4720.32%
E 602-43210-126 MEDICARE Employer Contribution$300.00$81.04$23.01$218.9627.01%
E 602-43210-131 Employer Paid Health$0.00$0.00$0.00$0.000.00%
E 602-43210-151 Worker s Comp Insurance Prem$700.00$0.00$0.00$700.000.00%
E 602-43210-200 Office Supplies$200.00$0.00$0.00$200.000.00%
E 602-43210-210 Operating Supplies$2,500.00$5.38$5.38$2,494.620.22%
E 602-43210-240 Small Tools and Minor Equip$600.00$0.00$0.00$600.000.00%
Bliss Collector Permit Renewal
E 602-43210-303 Engineering Fees$10,500.00$10,687.50$10,687.50($187.50)101.79%
E 602-43210-304 Legal Services$0.00$18.00$18.00($18.00)0.00%
E 602-43210-308 Other Professional Services$2,500.00$523.00$250.00$1,977.0020.92%
E 602-43210-309 Software Support & Maintenance$1,300.00$0.00$0.00$1,300.000.00%
E 602-43210-317 Employee Training$1,400.00$0.00$0.00$1,400.000.00%
E 602-43210-321 Telephone$2,400.00$1,051.01$490.04$1,348.9943.79%
E 602-43210-322 Postage$600.00$0.00$0.00$600.000.00%
E 602-43210-331 Travel Expenses$200.00$0.00$0.00$200.000.00%
E 602-43210-334 Licenses & Permits$1,600.00$729.00$729.00$871.0045.56%
E 602-43210-361 Liability/Property Ins$3,000.00$3,449.06$0.00($449.06)114.97%
E 602-43210-381 Utilities-Electric & Gas$2,500.00$1,157.03$938.74$1,342.9746.28%
E 602-43210-385 Sewer Pumping & Maintenance$15,000.00$0.00$0.00$15,000.000.00%
E 602-43210-386 Operation & Maintenance$5,000.00$2,139.00$0.00$2,861.0042.78%
E 602-43210-404 Repair Machinery/Equipment$16,000.00($0.20)$0.00$16,000.200.00%
E 602-43210-413 Equipment Rental$400.00$0.00$0.00$400.000.00%
E 602-43210-420 Depreciation Expense$54,300.00$0.00$0.00$54,300.000.00%
E 602-43210-438 Misc. Contractual$10,000.00$0.00$0.00$10,000.000.00%
E 602-43210-439 Refunds Issued$0.00$0.00$0.00$0.000.00%
E 602-43210-530 Capital Impr Other Than Bldgs$9,800.00$0.00$0.00$9,800.000.00%
Total Big Marine Sewer Expenditures$181,700.00$25,526.83$15,041.28$156,173.1714.05%
UPTOWN SEWER
RevenueR 612-43210-34401 Sewer User Fees$22,300.00$0.00$0.00$22,300.000.00%
R 612-43210-36210 Interest Income$200.00$0.00$0.00$200.000.00%
Total Uptown Sewer Revenue$22,500.00$0.00$0.00$22,500.000.00%
ExpenditureE 612-43210-101 Regular Wages & Salaries$9,700.00$2,155.74$718.58$7,544.2622.22%
E 612-43210-121 PERA Coord. Employer Contribu.$700.00$161.31$53.94$538.6923.04%
E 612-43210-122 FICA Employer Contribution$600.00$122.06$42.19$477.9420.34%
E 612-43210-126 MEDICARE Employer Contribution$100.00$34.68$9.85$65.3234.68%
E 612-43210-151 Worker s Comp Insurance Prem$200.00$0.00$0.00$200.000.00%
E 612-43210-200 Office Supplies$100.00$0.00$0.00$100.000.00%
E 612-43210-210 Operating Supplies$300.00$0.00$0.00$300.000.00%
E 612-43210-221 Equipment Parts$300.00$0.00$0.00$300.000.00%
E 612-43210-303 Engineering Fees$1,000.00$0.00$0.00$1,000.000.00%
E 612-43210-308 Other Professional Services$500.00$0.00$0.00$500.000.00%
E 612-43210-309 Software Support & Maintenance$0.00$0.00$0.00$0.000.00%
E 612-43210-317 Employee Training$350.00$0.00$0.00$350.000.00%
E 612-43210-319 Other Services$0.00$0.00$0.00$0.000.00%
E 612-43210-322 Postage$0.00$0.00$0.00$0.000.00%
E 612-43210-334 Licenses & Permits$400.00$224.00$224.00$176.0056.00%
E 612-43210-361 Liability/Property Ins$400.00$477.82$0.00($77.82)119.46%
E 612-43210-381 Utilities-Electric & Gas$1,700.00$326.87$154.61$1,373.1319.23%
E 612-43210-385 Sewer Pumping & Maintenance$1,500.00$0.00$0.00$1,500.000.00%
E 612-43210-386 Operation & Maintenance$700.00$0.00$0.00$700.000.00%
E 612-43210-404 Repair Machinery/Equipment$2,000.00$0.00$0.00$2,000.000.00%
E 612-43210-420 Depreciation Expense$5,100.00$0.00$0.00$5,100.000.00%
E 612-43210-438 Misc. Contractual$1,300.00$0.00$0.00$1,300.000.00%
E 612-43210-530 Capital Impr Other Than Bldgs$4,500.00$0.00$0.00$4,500.000.00%
Total Uptown Sewer Expenditures$31,450.00$3,502.48$1,203.17$27,947.5211.14%
City of Scandiaaug
Treasurer’s Report
3/31/2023
FUND ACCOUNTING
Beginning Cash Balance $ 3,911,802.573/1/2023
Beginning Checking Balance$ 156,938.29
Checking Receipts 31,606.96
Transfers toChecking 180,000.00
Total Deposits 211,606.96
Expenditures$ (243,472.52)
Payroll$ -
Transfer to EDA inTransit
Total Payments 243,472.52)
Ending Checking Balance 125,072.73
Beginnging Money Market Balance 1,740,282.75
Money Market Receipts 1,321.32
Tranfer to Checking 180,000.00)
0
Ending Money Market Balance 1,561,604.07
Beginning Investments Balance 2,043,003.90
Investments Receipts 5,399.59
Ending Investments Balance$ 2,048,403.49
Beginning EDA Balance$ 33,356.07
EDA Receipts
EDA Expenditures
EDA De;positin Transit
EDA Transfers from Checking
Ending EDA Balance$ 33,356.07
Outstanding Checks 6,446.06)
3/31/2023EndingCashBalance $ 3,761,990.30
CHECKING, MONEY MARKET & INVESTMENT CD's
Checking *102$ 156,938.29BegBal
Credits$ 211,606.96
Debits$ (243,472.52)
Transfer inTransit
125,072.73EndBal
Money Market *105 - Rate .25%$ 1,740,282.75BegBal
rate change from 1.25% Credits 1,321.32
Debits 180,000.00)
End Bal$ 1,561,604.07
Investments
CD *4422 - Rate 4.00% 12mo., 3/25/2024 **NEW RATE$ 317,850.51
CD *4424 - Rate 2.50% 12 mo., 7/17/2023 $ 446,907.03
CD *4425 - Rate 2.875% 12 mo., 9/28/2023 $ 744,824.34
CD *4426 - Rate 3.50%% 12mo., 1/29/2024 538,821.61
Total Investments$ 2,048,403.49
Total Bank & Investment Accounts 3,735,080.29
6,446.06) Checks in Transit *3102
Transfer toEDA in Transit
Deposit in transit money market
3,728,634.23TotalAdjustedUndesignatedFunds
Scandia EDA *6301 $ 33,356.07
Receipts
Expenditures
Checks inTransit
Deposit inTransit
Total Designated EDA Funds$ 33,356.07
Total Funds$ 3,761,990.30
Submitted by: Colleen Firkus, Treasurer
2023CASH BALANCES
ENDOFMONTH
FUNDJANUARYFEBRUARYMARCH
101 GENERAL$1,365,932$1,204,052$1,078,538
203 COVID-19 RELIEF$456,363$456,363456,362.62
226 CABLE TV$11,271$12,786$9,481
230 GATEWAY TRAIL$0$0$0
307 BLACKTOP PROJECT 2007$6,731$0$0
313 EQUIPMENT CERTIFICATES$28,825$28,873$28,873
315 EQUIPMENT CERTIFICATES$15,951$0$0
317 EQUIPMENT CERTIFICATES$2,187$0$0
318 BLACKTOP PROJECT$20,270$45,284$45,284
401 CAPITAL IMPR$749,162$749,497$745,297
404 PARK CAP IMPR$148,177$148,797$148,797
406 EQUIPMENT REPLACEMENT$199,727$200,548$200,548
408 LOCAL ROAD IMPROVEMENT$916,080$910,085$901,556
602 BIG MARINE SEWER$80,462$74,771$75,858
612 UPTOWN SEWER$10,330$15,160$13,957
801 ESCROW$21,817$32,240$24,131
SUBTOTAL$4,033,286$3,878,456$3,728,684
225 EDA$33,356$33,356$33,356
TOTAL$4,066,642$3,911,812$3,762,040
CITY OF SCANDIA
Revenue - Expenditure Summary
Mar-23
2023 YTD Budget
2023 BudgetAmountFebruaryBalance% of BudgetCommentsDescription
GENERAL FUND
RevenueR 101-41000-31000 Washington Cty. Tax Settlement$1,865,918.00$0.00$0.00$1,865,918.000.00%
R 101-41000-31040 Fiscal Disparities$0.00$0.00$0.00$0.000.00%
R 101-41000-31701 Gravel Taxes$20,000.00$0.00$0.00$20,000.000.00%
R 101-41000-31830 Solar Energy Production Tax$6,000.00$0.00$0.00$6,000.000.00%
R 101-41000-31900 Penalties & Interest Del Tax$400.00$0.00$0.00$400.000.00%
R 101-41000-32150 Utility Permits$3,000.00$1,050.00$450.00$1,950.0035.00%
R 101-41000-32180 Tobacco & Liquor Licenses$10,000.00$50.00$0.00$9,950.000.50%
R 101-41000-32190 Other City Permits$3,000.00$425.00$100.00$2,575.0014.17%
R 101-41000-32210 Building Permits$145,000.00$35,062.80$4,019.20$109,937.2024.18%
R 101-41000-32260 Gambling Permits$100.00$0.00$0.00$100.000.00%
R 101-41000-33401 LGA/MVHC/AG/PERA Aid$7,000.00$0.00$0.00$7,000.000.00%
R 101-41000-33420 Fire Relief State PERA$37,000.00$0.00$0.00$37,000.000.00%
Fire Training grantsR101-41000-33422 Other State Grants & Aids$11,000.00$6,897.00$5,175.00$4,103.0062.70%
R 101-41000-33428 PILOT$6,000.00$0.00$0.00$6,000.000.00%
R 101-41000-33620 Recycling Grant$10,500.00$0.00$0.00$10,500.000.00%
R 101-41000-33630 Local Govt Grants & Aids$0.00$0.00$0.00$0.000.00%
R 101-41000-33640 Other Grants$1,200.00$0.00$0.00$1,200.000.00%
R 101-41000-34103 Zoning and Planning$6,700.00$1,200.00$0.00$5,500.0017.91%
R 101-41000-34106 Engineering Fees$500.00$0.00$0.00$500.000.00%
R 101-41000-34107 Assessment Search Fees$0.00$5.00$0.00($5.00)0.00%
R 101-41000-34109 Water Usage$100.00$0.00$0.00$100.000.00%
R 101-41000-34201 Impound Fees$0.00$0.00$0.00$0.000.00%
R 101-41000-34202 Fire Protection Services$34,300.00$0.00$0.00$34,300.000.00%
R 101-41000-34301 Damage Repairs$0.00$0.00$0.00$0.000.00%
R 101-41000-34303 Dust Control$2,700.00$0.00$0.00$2,700.000.00%
R 101-41000-34304 Reimbursement for Services$3,000.00$300.00$300.00$2,700.0010.00%
R 101-41000-34305 Other Street Services$0.00$0.00$0.00$0.000.00%
R 101-41000-34730 Ad Revenue$0.00$0.00$0.00$0.000.00%
R 101-41000-34750 Facilities Rental$5,500.00$966.67$350.00$4,533.3317.58%
R 101-41000-34760 Cleaning Fees$100.00$0.00$0.00$100.000.00%
R 101-41000-34790 Recreation Programs$2,100.00$760.00$0.00$1,340.0036.19%
R 101-41000-35101 Fines & Forfeitures$7,400.00$1,201.90$875.25$6,198.1016.24%
distributed among funds at EOYR101-41000-36210 Interest Income$12,100.00$10,712.65$6,722.11$1,387.3588.53%
Veterans Memorial Upkeep $1,090; Lions
R 101-41000-36230 Donations$2,000.00$3,941.30$1,090.20($1,941.30)197.07% Vinterfest Fireworks $2,000
R 101-41000-36240 Insurance Dividend$4,100.00$0.00$0.00$4,100.000.00%
R 101-41000-36250 Misc. Refund$3,800.00$0.00$0.00$3,800.000.00%
R 101-41000-39200 Interfund Operating Transfer$0.00$0.00$0.00$0.000.00%
Total General Fund Revenue$2,210,518.00$62,572.32$19,081.76$2,147,945.682.83%
Operating TransfersR 101-49000-39203 Transfer from Other Funds$0.00$215,000.00$0.00($215,000.00)
R 101-49000-39204 Money Market Transfer$0.00$355,000.01$180,000.01($355,000.01)
Total Operating Transfers$570,000.01$180,000.01($570,000.01)
CITY OF SCANDIA
Revenue - Expenditure Summary
Mar-23
2023 YTD Budget
2023 BudgetAmountFebruaryBalance% of BudgetCommentsDescription
GENERAL FUNDADMINISTRATION & FINANCE
ExpenditureE 101-41000-101 Regular Wages & Salaries$192,700.00$11,531.01$6,980.89$181,168.995.98%
audit journal entriesE101-41000-121 PERA Coord. Employer Contribu.$13,400.00($1,737.97)$523.58$15,137.97-12.97%
E 101-41000-122 FICA Employer Contribution$11,900.00$36.47$419.51$11,863.530.31%
E 101-41000-126 MEDICARE Employer Contribution$2,700.00$870.05$98.10$1,829.9532.22%
E 101-41000-131 Employer Paid Health$47,300.00$8,601.04$1,785.86$38,698.9618.18%
E 101-41000-132 Dental Insurance$3,400.00$219.25$54.81$3,180.756.45%
E 101-41000-134 Employer Paid Life$600.00$126.70$73.60$473.3021.12%
E 101-41000-135 Employer Paid Disability$900.00$270.65$59.75$629.3530.07%
E 101-41000-151 Worker s Comp Insurance Prem$1,300.00$0.00$0.00$1,300.000.00%
E 101-41000-200 Office Supplies$1,100.00$19.68$0.00$1,080.321.79%
E 101-41000-203 Printed Forms & Papers$1,900.00$185.68$185.68$1,714.329.77%
Award frames; March 10 meeting suppliesE101-41000-210 Operating Supplies$800.00$349.93$340.03$450.0743.74%
E 101-41000-300 Assessor$0.00$0.00$0.00$0.000.00%
E 101-41000-301 Auditing and Acct g Services$23,500.00$0.00$0.00$23,500.000.00%
E 101-41000-303 Engineering Fees$0.00$0.00$0.00$0.000.00%
E 101-41000-304 Legal Services$55,000.00$8,740.50$4,716.75$46,259.5015.89%
E 101-41000-306 Personal Testing & Recruit$0.00$0.00$0.00$0.000.00%
Intermin City Admin SalaryE101-41000-308 Other Professional Services$1,000.00$26,205.00$15,972.50($25,205.00)2620.50%
E 101-41000-309 Software Support & Maintenance$18,200.00$1,824.62$780.91$16,375.3810.03%
E 101-41000-314 Animal Control$0.00$0.00$0.00$700.000.00%
E 101-41000-316 Conferences & Seminars$700.00$0.00$0.00$200.000.00%
E 101-41000-317 Employee Training$200.00$0.00$0.00$200.000.00%
E 101-41000-319 Other Services$46,700.00$551.00$116.00$46,149.001.18%
E 101-41000-321 Telephone$3,700.00$1,224.20$424.64$2,475.8033.09%
E 101-41000-322 Postage$2,200.00$406.81$372.15$1,793.1918.49%
reimburse city admin applicantE101-41000-331 Travel Expenses$600.00$1,000.00$1,000.00($400.00)166.67%
E 101-41000-351 Legal Notices Publishing$1,200.00$839.66$0.00$360.3469.97%
E 101-41000-361 Liability/Property Ins$7,100.00$10,967.38$0.00($3,867.38)154.47%
E 101-41000-365 Insurance Claims$0.00$1,000.00$0.00($1,000.00)0.00%
budget for all depts in Fund 101E101-41000-381 Utilities-Electric & Gas$13,000.00$314.75$0.00$12,685.252.42%
E 101-41000-413 Equipment Rental$1,900.00$483.24$118.98$1,416.7625.43%
E 101-41000-430 Recycling$30,100.00$0.00$0.00$30,100.000.00%
E 101-41000-433 Dues and Subscriptions$6,100.00$75.00$0.00$6,025.001.23%
E 101-41000-434 Youth Service Bureau$5,500.00$0.00$0.00$5,500.000.00%
E 101-41000-435 Misc Expense$500.00$0.00$0.00$500.000.00%
Website Host; ABDO accounting assistanceE101-41000-438 Misc. Contractual$4,000.00$2,496.25$2,032.50$1,503.7562.41%
E 101-41000-439 Refunds Issued$0.00$0.00$0.00$0.000.00%
E 101-41000-560 Furniture and Fixtures$0.00$0.00$0.00$0.000.00%
E 101-41000-570 Office Equipment$5,500.00$0.00$0.00$5,500.000.00%
E 101-41000-720 Operating Transfers$0.00$0.00$0.00$0.000.00%
Total Admin & Finance Dept. Expenditures$504,700.00$76,600.90$36,056.24$428,299.1015.18%
CITY OF SCANDIA
Revenue - Expenditure Summary
Mar-23
2023 YTD Budget
2023 BudgetAmountFebruaryBalance% of BudgetCommentsDescription
GENERAL FUND CONT.CITY COUNCIL
ExpendituresE 101-41110-101 Regular Wages & Salaries$18,100.00$0.00$0.00$18,100.000.00%
E 101-41110-122 FICA Employer Contribution$1,100.00$53.15$0.00$1,046.854.83%
audit journal entriesE101-41110-126 MEDICARE Employer Contribution$300.00($52.08)$0.00$352.08-17.36%
audit journal entriesE101-41110-127 PERA Defined$600.00($42.87)$0.00$642.87-7.15%
E 101-41110-151 Worker s Comp Insurance Prem$100.00$0.00$0.00$100.000.00%
E 101-41110-308 Other Professional Services$0.00$0.00$0.00$0.000.00%
E 101-41110-316 Conferences & Seminars$700.00$350.00$0.00$350.0050.00%
E 101-41110-331 Travel Expenses$0.00$561.97$561.97($561.97)0.00%
E 101-41110-439 Refunds Issued$0.00$0.00$0.00$0.000.00%
E 101-41110-560 Furniture and Fixtures$0.00$0.00$0.00$0.000.00%
E 101-41110-570 Office Equipment$0.00$0.00$0.00$0.000.00%
Total City Council Dept. Expenditures$20,900.00$870.17$561.97$20,029.834.16%
ELECTIONS
ExpendituresE 101-41410-199 Election Judge$0.00$0.00$0.00$0.000.00%
E 101-41410-200 Office Supplies$0.00$0.00$0.00$0.000.00%
E 101-41410-203 Printed Forms & Papers$0.00$0.00$0.00$0.000.00%
E 101-41410-210 Operating Supplies$200.00$0.00$0.00$200.000.00%
E 101-41410-351 Legal Notices Publishing$0.00$0.00$0.00$0.000.00%
E 101-41410-413 Equipment Rental$850.00$1,515.00$0.00($665.00)178.24%
Total Elections Dept. Expenditures$1,050.00$1,515.00$0.00($465.00)144.29%
PLANNING & BUILDING
ExpendituresE 101-41910-101 Regular Wages & Salaries$59,600.00$16,664.88$2,489.02$42,935.1227.96%
E 101-41910-121 PERA Coord. Employer Contribu.$4,200.00$615.70$186.68$3,584.3014.66%
E 101-41910-122 FICA Employer Contribution$3,700.00$989.98$145.44$2,710.0226.76%
E 101-41910-126 MEDICARE Employer Contribution$900.00$253.93$34.02$646.0728.21%
E 101-41910-131 Employer Paid Health$20,000.00$3,793.77$1,014.07$16,206.2318.97%
E 101-41910-132 Dental Insurance$1,500.00$146.16$36.54$1,353.849.74%
E 101-41910-134 Employer Paid Life$200.00$33.60$22.40$166.4016.80%
E 101-41910-135 Employer Paid Disability$500.00$94.95$31.65$405.0518.99%
E 101-41910-203 Printed Forms & Papers$600.00$0.00$0.00$600.000.00%
E 101-41910-311 Contract Permit Inspections$50,000.00$14,755.64$10,865.74$35,244.3629.51%
E 101-41910-312 Planning Services$50,000.00$10,928.41$10,833.56$39,071.5921.86%
E 101-41910-313 Committee & Commission Reimbur$5,000.00$550.00$550.00$4,450.0011.00%
E 101-41910-316 Conferences & Seminars$50.00$0.00$0.00$50.000.00%
E 101-41910-319 Other Services$0.00$0.00$0.00$0.000.00%
E 101-41910-361 Liability/Property Ins$4,900.00$5,400.60$0.00($500.60)110.22%
E 101-41910-438 Misc. Contractual$5,000.00$0.00$0.00$5,000.000.00%
E 101-41910-439 Refunds Issued$200.00$0.00$0.00$200.000.00%
E 101-41910-720 Operating Transfers$0.00$0.00$0.00$0.000.00%
Total Planning & Building Dept. Expenditures$206,350.00$54,227.62$26,209.12$152,122.3826.28%
ASSESSOR
ExpendituresE 101-41960-300 Assessor$21,600.00$5,400.00$1,800.00$16,200.0025.00%
POLICE
ExpendituresE 101-42100-318 Police Contract$168,499.00$0.00$0.00$168,499.000.00%
E 101-42100-319 Other Services$500.00$309.36$0.00$190.6461.87%
Total GF Police Dept. Expenditures$168,999.00$309.36$0.00$168,689.640.18%
CITY OF SCANDIA
Revenue - Expenditure Summary
Mar-23
2023 YTD Budget
2023 BudgetAmountFebruaryBalance% of BudgetCommentsDescription
FIREGENERALFUNDCONT.
ExpendituresE 101-42200-101 Regular Wages & Salaries$147,200.00$23,423.06$13,710.52$123,776.9415.91%
E 101-42200-121 PERA Coord. Employer Contribu.$0.00$0.00$0.00$0.000.00%
E 101-42200-122 FICA Employer Contribution$9,100.00$1,360.53$814.12$7,739.4714.95%
E 101-42200-124 Police & Fire PERA$3,600.00$2,180.30$708.98$1,419.7060.56%
E 101-42200-126 MEDICARE Employer Contribution$2,100.00$98.33$201.74$2,001.674.68%
E 101-42200-134 Employer Paid Life$200.00$48.00$32.00$152.0024.00%
E 101-42200-135 Employer Paid Disability$700.00$0.00$0.00$700.000.00%
E 101-42200-141 Unemployment Compensation$0.00$0.00$0.00$0.000.00%
E 101-42200-151 Worker s Comp Insurance Prem$9,100.00$0.00$0.00$9,100.000.00%
E 101-42200-200 Office Supplies$400.00$0.00$0.00$400.000.00%
E 101-42200-203 Printed Forms & Papers$150.00$0.00$0.00$150.000.00%
E 101-42200-209 Medical Supplies$3,000.00$195.50$0.00$2,804.506.52%
E 101-42200-210 Operating Supplies$8,000.00$3,739.69$3,586.19$4,260.3146.75%
E 101-42200-211 Cleaning Supplies$100.00$0.00$0.00$100.000.00%
E 101-42200-212 Fuel$3,500.00$683.85$431.60$2,816.1519.54%
E 101-42200-217 Uniforms & Safety Equipment$10,000.00$1,073.13$996.33$8,926.8710.73%
E 101-42200-221 Equipment Parts$3,000.00$55.73$0.00$2,944.271.86%
E 101-42200-222 Tires$0.00$0.00$0.00$0.000.00%
E 101-42200-223 Structure Repair & Supplies$2,000.00$185.61$0.00$1,814.399.28%
E 101-42200-240 Small Tools and Minor Equip$9,000.00$38.00$0.00$8,962.000.42%
SCBA User Exams + Annual Fit TestE101-42200-305 Medical Services$3,500.00$4,610.00$2,060.00($1,110.00)131.71%
E 101-42200-306 Personal Testing & Recruit$1,300.00$0.00$0.00$1,300.000.00%
E 101-42200-309 Software Support & Maintenance$17,000.00$1,116.00$588.00$15,884.006.56%
E 101-42200-310 Medical Training$2,000.00$0.00$0.00$2,000.000.00%
E 101-42200-316 Conferences & Seminars$250.00$0.00$0.00$250.000.00%
E 101-42200-317 Employee Training$15,000.00$1,440.00$870.00$13,560.009.60%
E 101-42200-319 Other Services$500.00$0.00$0.00$500.000.00%
E 101-42200-321 Telephone$6,800.00$1,286.12$531.35$5,513.8818.91%
E 101-42200-322 Postage$0.00$0.00$0.00$0.000.00%
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$1,500.00$500.38$317.42$999.6233.36%
E 101-42200-334 Licenses & Permits$200.00$0.00$0.00$200.000.00%
E 101-42200-340 Advertising$0.00$0.00$0.00$0.000.00%
E 101-42200-361 Liability/Property Ins$6,500.00$6,989.37$0.00($489.37)107.53%
E 101-42200-381 Utilities-Electric & Gas$8,000.00$3,458.95$1,720.83$4,541.0543.24%
E 101-42200-384 Refuse/Garbage Disposal$1,100.00$184.04$92.02$915.9616.73%
E 101-42200-385 Sewer Pumping & Maintenance$700.00$0.00$0.00$700.000.00%
E 101-42200-401 Building Maintenance/Repairs$2,500.00$378.03$150.00$2,121.9715.12%
E 101-42200-403 Improvements Other Than Bldgs$0.00$0.00$0.00$0.000.00%
E 101-42200-404 Repair Machinery/Equipment$8,000.00$1,088.93$1,088.93$6,911.0713.61%
E 101-42200-407 Well Repair & Maintenance$0.00$0.00$0.00$0.000.00%
E 101-42200-433 Dues and Subscriptions$2,400.00$1,184.00$0.00$1,216.0049.33%
E 101-42200-438 Misc. Contractual$4,100.00$0.00$0.00$4,100.000.00%
E 101-42200-440 Events$800.00$0.00$0.00$800.000.00%
E 101-42200-520 Capital Improvements to Bldgs$0.00$0.00$0.00$0.000.00%
E 101-42200-530 Capital Impr Other Than Bldgs$0.00$0.00$0.00$0.000.00%
E 101-42200-540 Heavy Machinery Capital$0.00$0.00$0.00$0.000.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%
E 101-42200-720 Operating Transfers$0.00$0.00$0.00$0.000.00%
Total Fire Dept Expenditures$330,000.00$55,317.55$27,900.03$274,682.4516.76%
ANIMAL CONTROL
ExpendituresE 101-42700-314 Animal Control$5,000.00$506.25$150.00$4,493.7510.13%
CITY OF SCANDIA
Revenue - Expenditure Summary
Mar-23
2023 YTD Budget
2023 BudgetAmountFebruaryBalance% of BudgetCommentsDescription
PUBLIC WORKSGENERALFUNDCONT.
ExpendituresE 101-43000-101 Regular Wages & Salaries$229,700.00$51,332.97$17,387.32$178,367.0322.35%
E 101-43000-102 OT Regular Wages$5,000.00$3,607.76$1,072.10$1,392.2472.16%
snow plowingE101-43000-104 Temporary Employee Wages$2,300.00$3,980.23$1,159.13($1,680.23)173.05%
E 101-43000-121 PERA Coord. Employer Contribu.$17,600.00$4,106.00$1,384.42$13,494.0023.33%
E 101-43000-122 FICA Employer Contribution$14,600.00$3,224.22$1,116.97$11,375.7822.08%
E 101-43000-126 MEDICARE Employer Contribution$3,400.00$951.88$270.24$2,448.1228.00%
E 101-43000-131 Employer Paid Health$70,900.00$19,797.51$4,860.27$51,102.4927.92%
E 101-43000-132 Dental Insurance$2,300.00$352.61$88.15$1,947.3915.33%
E 101-43000-134 Employer Paid Life$700.00$181.60$116.32$518.4025.94%
E 101-43000-135 Employer Paid Disability$1,700.00$596.30$144.80$1,103.7035.08%
E 101-43000-141 Unemployment Compensation$0.00$0.00$0.00$0.000.00%
E 101-43000-151 Worker s Comp Insurance Prem$19,800.00$0.00$0.00$19,800.000.00%
E 101-43000-200 Office Supplies$600.00$0.00$0.00$600.000.00%
E 101-43000-210 Operating Supplies$8,400.00$314.03$222.63$8,085.973.74%
E 101-43000-212 Fuel$20,000.00$7,100.56$2,380.93$12,899.4435.50%
E 101-43000-217 Uniforms & Safety Equipment$2,200.00$201.44$0.00$1,998.569.16%
plow repair partsE101-43000-221 Equipment Parts$14,000.00$10,060.90$1,288.40$3,939.1071.86%
E 101-43000-222 Tires$7,500.00$0.00$0.00$7,500.000.00%
E 101-43000-223 Structure Repair & Supplies$2,200.00$0.00$0.00$2,200.000.00%
E 101-43000-224 Materials for Road Maintenance$16,500.00$1,114.83$610.15$15,385.176.76%
E 101-43000-226 Sign Replacement and Repair$0.00$0.00$0.00$0.000.00%
E 101-43000-228 Gravel$10,000.00$0.00$0.00$10,000.000.00%
snow, snow & snowE101-43000-229 Salt$20,000.00$18,093.42$0.00$1,906.5890.47%
E 101-43000-240 Small Tools and Minor Equip$8,000.00$3,623.62$0.00$4,376.3845.30%
E 101-43000-302 Surveying$0.00$0.00$0.00$0.000.00%
E 101-43000-303 Engineering Fees$10,000.00$132.00$346.50$9,868.001.32%
E 101-43000-304 Legal Services$0.00$0.00$0.00$0.000.00%
E 101-43000-305 Medical Services$1,200.00$99.90$0.00$1,100.108.33%
IWORQ subscriptionE101-43000-309 Software Support & Maintenance$2,000.00$5,000.00$0.00($3,000.00)250.00%
E 101-43000-317 Employee Training$1,700.00$1,010.00$0.00$690.0059.41%
E 101-43000-319 Other Services$13,600.00$58.10$4.05$13,541.900.43%
E 101-43000-321 Telephone$3,000.00$929.64$353.11$2,070.3630.99%
E 101-43000-331 Travel Expenses$500.00$0.00$0.00$500.000.00%
E 101-43000-334 Licenses & Permits$500.00$0.00$0.00$500.000.00%
E 101-43000-361 Liability/Property Ins$9,000.00$8,348.14$0.00$651.8692.76%
E 101-43000-365 Insurance Claims$0.00$0.00$0.00$0.000.00%
E 101-43000-381 Utilities-Electric & Gas$4,000.00$2,388.68$1,184.72$1,611.3259.72%
E 101-43000-384 Refuse/Garbage Disposal$1,000.00$122.72$61.36$877.2812.27%
E 101-43000-385 Sewer Pumping & Maintenance$1,600.00$0.00$0.00$1,600.000.00%
E 101-43000-387 Street Light Utilities$4,200.00$1,186.36$567.88$3,013.6428.25%
E 101-43000-401 Building Maintenance/Repairs$8,000.00$451.37$188.60$7,548.635.64%
E 101-43000-403 Improvements Other Than Bldgs$0.00$0.00$0.00$0.000.00%
plow truck repairsE101-43000-404 Repair Machinery/Equipment$15,500.00$9,252.74$3,049.00$6,247.2659.70%
E 101-43000-405 Contractual Road Maint/Repair$157,500.00$0.00$0.00$157,500.000.00%
E 101-43000-407 Well Repair & Maintenance$0.00$0.00$0.00$0.000.00%
E 101-43000-413 Equipment Rental$4,000.00$0.00$0.00$4,000.000.00%
E 101-43000-417 Uniform Rental$1,100.00$172.71$76.76$927.2915.70%
E 101-43000-433 Dues and Subscriptions$200.00$0.00$0.00$200.000.00%
E 101-43000-438 Misc. Contractual$15,750.00$0.00$0.00$15,750.000.00%
E 101-43000-439 Refunds Issued$0.00$0.00$0.00$0.000.00%
E 101-43000-530 Capital Impr Other Than Bldgs$0.00$0.00$0.00$0.000.00%
E 101-43000-550 Motor Vehicles Capital$0.00$0.00$0.00$0.000.00%
E 101-43000-560 Furniture and Fixtures$0.00$0.00$0.00$0.000.00%
E 101-43000-570 Office Equipment$1,000.00$0.00$0.00$1,000.000.00%
E 101-43000-720 Operating Transfers$0.00$0.00$0.00$0.000.00%
Total Public Works Dept. Expenditures$732,750.00$157,792.24$37,933.81$574,957.7621.53%
CITY OF SCANDIA
Revenue - Expenditure Summary
Mar-23
2023 YTD Budget
2023 BudgetAmountFebruaryBalance% of BudgetCommentsDescription
GENERAL FUND CONT.PARKS & RECREATION
ExpendituresE 101-45000-101 Regular Wages & Salaries$10,200.00$1,080.44$757.48$9,119.5610.59%
E 101-45000-104 Temporary Employee Wages$40,200.00$4,776.38$0.00$35,423.6211.88%
E 101-45000-121 PERA Coord. Employer Contribu.$800.00$78.65$56.80$721.359.83%
E 101-45000-122 FICA Employer Contribution$3,300.00$335.31$44.45$2,964.6910.16%
E 101-45000-126 MEDICARE Employer Contribution$800.00$105.85$10.39$694.1513.23%
E 101-45000-131 Employer Paid Health$2,700.00$598.72$185.45$2,101.2822.17%
E 101-45000-132 Dental Insurance$100.00$12.80$3.20$87.2012.80%
E 101-45000-134 Employer Paid Life$0.00$7.00$4.48($7.00)0.00%
E 101-45000-135 Employer Paid Disability$1,000.00$17.01$5.67$982.991.70%
E 101-45000-141 Unemployment Compensation$0.00$0.00$0.00$0.000.00%
E 101-45000-151 Worker s Comp Insurance Prem$1,900.00$0.00$0.00$1,900.000.00%
E 101-45000-200 Office Supplies$310.00$0.00$0.00$310.000.00%
E 101-45000-203 Printed Forms & Papers$930.00$0.00$0.00$930.000.00%
E 101-45000-210 Operating Supplies$930.00$31.96$31.96$898.043.44%
E 101-45000-212 Fuel$1,650.00$229.92$115.96$1,420.0813.93%
E 101-45000-221 Equipment Parts$2,100.00$290.38$9.98$1,809.6213.83%
E 101-45000-223 Structure Repair & Supplies$2,100.00$0.00$0.00$2,100.000.00%
E 101-45000-240 Small Tools and Minor Equip$400.00$0.00$0.00$400.000.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$240.00$240.00$960.0020.00%
E 101-45000-319 Other Services$0.00$0.00$0.00$0.000.00%
E 101-45000-322 Postage$0.00$0.00$0.00$0.000.00%
SCVRTA 2023 AdE101-45000-340 Advertising$200.00$250.00$250.00($50.00)125.00%
E 101-45000-353 Sales& Use Tax$0.00$0.00$0.00$0.000.00%
E 101-45000-361 Liability/Property Ins$3,300.00$3,323.03$0.00($23.03)100.70%
E 101-45000-381 Utilities-Electric & Gas$4,500.00$1,389.15$703.98$3,110.8530.87%
E 101-45000-384 Refuse/Garbage Disposal$2,500.00$305.00$115.00$2,195.0012.20%
E 101-45000-385 Sewer Pumping & Maintenance$700.00$369.00$0.00$331.0052.71%
ice melt productE101-45000-401 Building Maintenance/Repairs$4,800.00$3,192.91$2,417.91$1,607.0966.52%
E 101-45000-403 Improvements Other Than Bldgs$0.00$170.49$170.49($170.49)0.00%
E 101-45000-404 Repair Machinery/Equipment$750.00$0.00$0.00$750.000.00%
E 101-45000-406 Grounds Care$4,000.00$0.00$0.00$4,000.000.00%
E 101-45000-438 Misc. Contractual$3,300.00$0.00$0.00$3,300.000.00%
E 101-45000-439 Refunds Issued$0.00$565.01$0.00($565.01)0.00%
VinterfestE101-45000-440 Events$7,000.00$2,361.00$0.00$4,639.0033.73%
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$0.00$0.00$10,000.000.00%
E 101-45000-720 Operating Transfers$0.00$0.00$0.00$0.000.00%
Total Parks & Rec Dept. Expenditures$111,670.00$19,730.01$5,123.20$91,939.9917.67%
CITY OF SCANDIA
Revenue - Expenditure Summary
Mar-23
2023 YTD Budget
2023 BudgetAmountFebruaryBalance% of BudgetCommentsDescription
GENERAL FUND CONT.COMMUNITY CENTER
ExpendituresE 101-45180-101 Regular Wages & Salaries$15,000.00$3,309.83$1,103.28$11,690.1722.07%
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$247.38$82.73$852.6222.49%
E 101-45180-122 FICA Employer Contribution$900.00$187.30$64.67$712.7020.81%
E 101-45180-126 MEDICARE Employer Contribution$200.00$53.22$15.13$146.7826.61%
E 101-45180-131 Employer Paid Health$3,700.00$753.30$255.60$2,946.7020.36%
E 101-45180-134 Employer Paid Life$0.00$11.40$7.20($11.40)0.00%
E 101-45180-135 Employer Paid Disability$200.00$34.29$11.43$165.7117.15%
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,900.00$511.11$135.43$2,388.8917.62%
E 101-45180-223 Structure Repair & Supplies$6,500.00$0.00$0.00$6,500.000.00%
E 101-45180-334 Licenses & Permits$1,000.00$752.00$0.00$248.0075.20%
E 101-45180-361 Liability/Property Ins$800.00$795.60$0.00$4.4099.45%
E 101-45180-381 Utilities-Electric & Gas$11,200.00$3,310.82$1,596.81$7,889.1829.56%
E 101-45180-384 Refuse/Garbage Disposal$1,900.00$395.78$160.17$1,504.2220.83%
E 101-45180-385 Sewer Pumping & Maintenance$3,700.00$0.00$0.00$3,700.000.00%
Remove ice from Comm Ctr roofE101-45180-401 Building Maintenance/Repairs$15,000.00$6,214.37$5,593.78$8,785.6341.43%
E 101-45180-404 Repair Machinery/Equipment$5,000.00$50.00$0.00$4,950.001.00%
E 101-45180-406 Grounds Care$690.00$0.00$0.00$690.000.00%
E 101-45180-407 Well Repair & Maintenance$1,000.00$0.00$0.00$1,000.000.00%
E 101-45180-438 Misc. Contractual$2,700.00$0.00$0.00$2,700.000.00%
E 101-45180-439 Refunds Issued$0.00$450.00$0.00($450.00)0.00%
Council Chambers remodelE101-45180-520 Capital Improvements to Bldgs$6,000.00$7,475.61$0.00($1,475.61)124.59%
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$79,490.00$24,552.01$9,026.23$54,937.9930.89%
Operating TransfersE 101-49000-720 Operating Transfers$0.00$570,000.00$180,000.00($570,000.00)
TOTAL GENERAL FUND EXPENDITURES$2,182,509.00$396,821.11$144,760.60$1,785,887.8918.18%
CITY OF SCANDIA
Revenue - Expenditure Summary
Mar-23
2023 YTD Budget
2023 BudgetAmountFebruaryBalance% of BudgetCommentsDescription
COVID RELIEF FUND
RevenueR 203-46200-33150 Federal Grant$0.00$0.00$0.00$0.00
ExpendituresE 203-49000-720 Operating Transfers$0.00$0.00$0.00$0.00
EDA FUND
Revenue
R 225-46500-31000 Washington Cty. Tax Settlement$5,300.00$0.00$0.00$5,300.000.00%
R 225-46500-33640 Other Grants$0.00$0.00$0.00$0.000.00%
R 225-46500-34750 Facilities Rental$0.00$0.00$0.00$0.000.00%
R 225-46500-36210 Interest Income$200.00$0.00$0.00$200.000.00%
R 225-46500-36230 Donations$0.00$0.00$0.00$0.000.00%
R 225-46500-39203 Transfer from Other Funds$0.00$3,524.94$0.00($3,524.94)0.00%
Total EDA Fund Revenue$5,500.00$3,524.94$0.00$1,975.0664.09%
Expenditure
E 225-46500-210 Operating Supplies$500.00$0.00$0.00$500.000.00%
E 225-46500-303 Engineering Fees$0.00$0.00$0.00$0.000.00%
E 225-46500-304 Legal Services$0.00$0.00$0.00$0.000.00%
E 225-46500-308 Other Professional Services$300.00$0.00$0.00$300.000.00%
E 225-46500-340 Advertising$2,000.00$0.00$0.00$2,000.000.00%
EDAM Membership; Sister City DuesE225-46500-433 Dues and Subscriptions$1,700.00$805.00$190.00$895.0047.35%
E 225-46500-440 Events$800.00$0.00$0.00$800.000.00%
E 225-46500-720 Operating Transfers$0.00$3,524.94$0.00($3,524.94)0.00%
Total EDA Fund Expenditures$5,300.00$4,329.94$190.00$470.0681.70%
CABLE TV FUND
Revenue
R 226-41950-36210 Interest Income$100.00$0.00$0.00$100.000.00%
R 226-41950-38050 Cable TV Franchise Rebates$16,200.00$3,220.80$1,644.34$12,979.2019.88%
R 226-41950-38051 PEG Fees$4,200.00$884.05$445.34$3,315.9521.05%
Total Cable TV Fund Revenue$20,500.00$4,104.85$2,089.68$16,395.1520.02%
Expenditure
Council Chambers AV equipmentE226-41950-240 Small Tools and Minor Equip$300.00$344.48$0.00($44.48)114.83%
E 226-41950-309 Software Support & Maintenance$3,500.00$149.16$149.16$3,350.844.26%
E 226-41950-438 Misc. Contractual$5,300.00$1,380.00$1,380.00$3,920.0026.04%
E 226-41950-570 Office Equipment$0.00$4,128.98$3,865.98($4,128.98)0.00%
Total Cable TV Fund Expenditures$9,100.00$6,002.62$5,395.14$3,097.3865.96%
GATEWAY TRAIL FUND
RevenueR 230-45000-36230 Donations$0.00$0.00$0.00$0.000.00%
ExpendituresE 230-45000-308 Other Professional Services$0.00$0.00$0.00$0.000.00%
2013 EQUIPMENT CERTIFICATES
Revenue
R 313-47000-31000 Washington Cty. Tax Settlement$64,000.00$0.00$0.00$64,000.000.00%
ExpenditureE 313-47000-601 Long Term Debt Principal$60,000.00$0.00$0.00$60,000.000.00%
E 313-47000-611 Long Term Debt Interest$3,047.00$0.00$0.00$3,047.000.00%
E 313-47000-620 Fiscal Agent s Fees$500.00$0.00$0.00$500.000.00%
Total 2013 Fund Expenditures$63,547.00$0.00$0.00$63,547.000.00%
2018 STREET RECONSTRUCTION
RevenueR 318-47000-31000 Washington Cty. Tax Settlement$342,546.00$0.00$0.00$342,546.000.00%
ExpenditureE 318-47000-601 Long Term Debt Principal$250,000.00$0.00$0.00$250,000.000.00%
E 318-47000-611 Long Term Debt Interest$91,225.00$0.00$0.00$91,225.000.00%
E 318-47000-620 Fiscal Agent s Fees$500.00$0.00$0.00$500.000.00%
Total 2018 Street Reconstruction Fund Expenditures$341,725.00$0.00$0.00$341,725.000.00%
CITY OF SCANDIA
Revenue - Expenditure Summary
Mar-23
2023 YTD Budget
2023 BudgetAmountFebruaryBalance% of BudgetCommentsDescription
CAPITAL IMPROVEMENTS
RevenueR 401-43100-36100 Special Assessments$0.00$0.00$0.00$0.000.00%
R 401-48000-31000 Washington Cty. Tax Settlement$293,791.00$0.00$0.00$293,791.000.00%
R 401-48000-33422 Other State Grants & Aids$0.00$0.00$0.00$0.000.00%
R 401-48000-36210 Interest Income$2,300.00$0.00$0.00$2,300.000.00%
Total Capital Improvement Fund Revenue$296,091.00$0.00$0.00$296,091.000.00%
ExpenditureE 401-41000-312 Planning Services$0.00$0.00$0.00$0.000.00%
E 401-41000-520 Capital Improvements to Bldgs$0.00$0.00$0.00$0.000.00%
E 401-41000-530 Capital Impr Other Than Bldgs$169,500.00$0.00$0.00$169,500.000.00%
E 401-42200-520 Capital Improvements to Bldgs$65,000.00$0.00$0.00$65,000.000.00%
Gateway Trail LobbyingE401-48000-435 Misc Expense$0.00$9,000.00$4,200.00($9,000.00)0.00%
E 401-48000-438 Misc. Contractual$0.00$0.00$0.00$0.000.00%
E 401-48000-520 Capital Improvements to Bldgs$0.00$0.00$0.00$0.000.00%
E 401-48000-530 Capital Impr Other Than Bldgs$100,000.00$0.00$0.00$100,000.000.00%
Total Capital Improvement Fund Expenditures$334,500.00$9,000.00$4,200.00$325,500.002.69%
PARK DEVELOPMENT
RevenueR 404-48000-31000 Washington Cty. Tax Settlement$20,000.00$0.00$0.00$20,000.000.00%
R 404-48000-33422 Other State Grants & Aids$0.00$0.00$0.00$0.000.00%
R 404-48000-34780 Park Dedication Fees$21,000.00$0.00$0.00$21,000.000.00%
R 404-48000-36210 Interest Income$66.00$0.00$0.00$66.000.00%
Lions Playground donationR404-48000-36230 Donations$0.00$10,000.00$0.00($10,000.00)0.00%
Total Park Development Fund Revenue$41,066.00$10,000.00$0.00$31,066.0024.35%
ExpenditureE 404-48000-312 Planning Services$0.00$0.00$0.00$0.000.00%
E 404-48000-520 Capital Improvements to Bldgs$17,306.00$0.00$0.00$17,306.000.00%
E 404-48000-720 Operating Transfers$0.00$0.00$0.00$0.000.00%
Total Park Development Fund Expenditures$17,306.00$0.00$0.00$17,306.000.00%
EQUIPMENT REPLACEMENT
RevenueR 406-48500-31000 Washington Cty. Tax Settlement$0.00$0.00$0.00$0.000.00%
R 406-48500-36210 Interest Income$1,030.00$0.00$0.00$1,030.000.00%
R 406-48500-36260 Sale of Equipment$35,000.00$0.00$0.00$35,000.000.00%
R 406-48500-39350 Certificate of Indebtedness$819,500.00$0.00$0.00$819,500.000.00%
Total Equipment Replacement Fund Revenue$855,530.00$0.00$0.00$855,530.000.00%
ExpenditureE 406-48500-540 Heavy Machinery Capital$325,000.00$0.00$0.00$325,000.000.00%
E 406-48500-550 Motor Vehicles Capital$189,500.00$0.00$0.00$189,500.000.00%
Total Equipment Replacement Fund Expenditures$514,500.00$0.00$0.00$514,500.000.00%
LOCAL ROAD IMPROVEMENT FUND
RevenueR 408-43100-31000 Washington Cty. Tax Settlement$212,012.00$0.00$0.00$212,012.000.00%
R 408-43100-33422 Other State Grants & Aids$0.00$0.00$0.00$0.000.00%
R 408-43100-36210 Interest Income$12,115.00$0.00$0.00$12,115.000.00%
R 408-43100-39310 Proceeds-Gen Obligation Bond$0.00$0.00$0.00$0.000.00%
Total LRIF Revenue$224,127.00$0.00$0.00$224,127.00$0.00
2023 Street Improvement ProjectExpenditureE408-43100-303 Engineering Fees$20,000.00$8,518.50$8,518.50$11,481.5042.59%
E 408-43100-530 Capital Impr Other Than Bldgs$973,000.00$260.08$0.00$972,739.920.03%
Total LRIF Expenditures$993,000.00$8,778.58$8,518.50$984,221.420.88%
CITY OF SCANDIA
Revenue - Expenditure Summary
Mar-23
2023 YTD Budget
2023 BudgetAmountFebruaryBalance% of BudgetCommentsDescription
BIG MARINE SEWER
RevenueR 602-43210-31951 Special Assessments Principal$0.00$0.00$0.00$0.000.00%
R 602-43210-31952 SA Penalties & Interest$0.00$0.00$0.00$0.000.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$140,700.00$16,516.60$15,881.60$124,183.4011.74%
R 602-43210-34402 Sewer Connection Fee$0.00$8,000.00$0.00($8,000.00)0.00%
R 602-43210-36100 Special Assessments$600.00$0.00$0.00$600.000.00%
R 602-43210-36102 Penalties and Interest$0.00$0.00$0.00$0.000.00%
R 602-43210-36210 Interest Income$400.00$0.00$0.00$400.000.00%
Total Big Marine Sewer Revenue$141,700.00$24,516.60$15,881.60$117,183.4017.30%
ExpenditureE 602-43210-101 Regular Wages & Salaries$22,500.00$5,026.69$1,675.56$17,473.3122.34%
E 602-43210-120 Pension Expense$0.00$0.00$0.00$0.000.00%
E 602-43210-121 PERA Coord. Employer Contribu.$17,000.00$375.79$125.67$16,624.212.21%
E 602-43210-122 FICA Employer Contribution$1,400.00$284.53$98.38$1,115.4720.32%
E 602-43210-126 MEDICARE Employer Contribution$300.00$81.04$23.01$218.9627.01%
E 602-43210-131 Employer Paid Health$0.00$0.00$0.00$0.000.00%
E 602-43210-151 Worker s Comp Insurance Prem$700.00$0.00$0.00$700.000.00%
E 602-43210-200 Office Supplies$200.00$0.00$0.00$200.000.00%
E 602-43210-210 Operating Supplies$2,500.00$5.38$5.38$2,494.620.22%
E 602-43210-240 Small Tools and Minor Equip$600.00$0.00$0.00$600.000.00%
Bliss Collector Permit RenewalE602-43210-303 Engineering Fees$10,500.00$10,687.50$10,687.50($187.50)101.79%
E 602-43210-304 Legal Services$0.00$18.00$18.00($18.00)0.00%
E 602-43210-308 Other Professional Services$2,500.00$523.00$250.00$1,977.0020.92%
E 602-43210-309 Software Support & Maintenance$1,300.00$0.00$0.00$1,300.000.00%
E 602-43210-317 Employee Training$1,400.00$0.00$0.00$1,400.000.00%
E 602-43210-321 Telephone$2,400.00$1,051.01$490.04$1,348.9943.79%
E 602-43210-322 Postage$600.00$0.00$0.00$600.000.00%
E 602-43210-331 Travel Expenses$200.00$0.00$0.00$200.000.00%
E 602-43210-334 Licenses & Permits$1,600.00$729.00$729.00$871.0045.56%
E 602-43210-361 Liability/Property Ins$3,000.00$3,449.06$0.00($449.06)114.97%
E 602-43210-381 Utilities-Electric & Gas$2,500.00$1,157.03$938.74$1,342.9746.28%
E 602-43210-385 Sewer Pumping & Maintenance$15,000.00$0.00$0.00$15,000.000.00%
E 602-43210-386 Operation & Maintenance$5,000.00$2,139.00$0.00$2,861.0042.78%
E 602-43210-404 Repair Machinery/Equipment$16,000.00($0.20)$0.00$16,000.200.00%
E 602-43210-413 Equipment Rental$400.00$0.00$0.00$400.000.00%
E 602-43210-420 Depreciation Expense$54,300.00$0.00$0.00$54,300.000.00%
E 602-43210-438 Misc. Contractual$10,000.00$0.00$0.00$10,000.000.00%
E 602-43210-439 Refunds Issued$0.00$0.00$0.00$0.000.00%
E 602-43210-530 Capital Impr Other Than Bldgs$9,800.00$0.00$0.00$9,800.000.00%
Total Big Marine Sewer Expenditures$181,700.00$25,526.83$15,041.28$156,173.1714.05%
UPTOWN SEWER
RevenueR 612-43210-34401 Sewer User Fees$22,300.00$0.00$0.00$22,300.000.00%
R 612-43210-36210 Interest Income$200.00$0.00$0.00$200.000.00%
Total Uptown Sewer Revenue$22,500.00$0.00$0.00$22,500.000.00%
ExpenditureE 612-43210-101 Regular Wages & Salaries$9,700.00$2,155.74$718.58$7,544.2622.22%
E 612-43210-121 PERA Coord. Employer Contribu.$700.00$161.31$53.94$538.6923.04%
E 612-43210-122 FICA Employer Contribution$600.00$122.06$42.19$477.9420.34%
E 612-43210-126 MEDICARE Employer Contribution$100.00$34.68$9.85$65.3234.68%
E 612-43210-151 Worker s Comp Insurance Prem$200.00$0.00$0.00$200.000.00%
E 612-43210-200 Office Supplies$100.00$0.00$0.00$100.000.00%
E 612-43210-210 Operating Supplies$300.00$0.00$0.00$300.000.00%
E 612-43210-221 Equipment Parts$300.00$0.00$0.00$300.000.00%
E 612-43210-303 Engineering Fees$1,000.00$0.00$0.00$1,000.000.00%
E 612-43210-308 Other Professional Services$500.00$0.00$0.00$500.000.00%
E 612-43210-309 Software Support & Maintenance$0.00$0.00$0.00$0.000.00%
E 612-43210-317 Employee Training$350.00$0.00$0.00$350.000.00%
E 612-43210-319 Other Services$0.00$0.00$0.00$0.000.00%
E 612-43210-322 Postage$0.00$0.00$0.00$0.000.00%
E 612-43210-334 Licenses & Permits$400.00$224.00$224.00$176.0056.00%
E 612-43210-361 Liability/Property Ins$400.00$477.82$0.00($77.82)119.46%
E 612-43210-381 Utilities-Electric & Gas$1,700.00$326.87$154.61$1,373.1319.23%
E 612-43210-385 Sewer Pumping & Maintenance$1,500.00$0.00$0.00$1,500.000.00%
E 612-43210-386 Operation & Maintenance$700.00$0.00$0.00$700.000.00%
E 612-43210-404 Repair Machinery/Equipment$2,000.00$0.00$0.00$2,000.000.00%
E 612-43210-420 Depreciation Expense$5,100.00$0.00$0.00$5,100.000.00%
E 612-43210-438 Misc. Contractual$1,300.00$0.00$0.00$1,300.000.00%
E 612-43210-530 Capital Impr Other Than Bldgs$4,500.00$0.00$0.00$4,500.000.00%
Total Uptown Sewer Expenditures$31,450.00$3,502.48$1,203.17$27,947.5211.14%