Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
06.b Treasurer's Monthly Report
City of Scandiaaug Treasurer’sReport 6/30/2022 FUND ACCOUNTING Beginning Cash Balance $ 3,492,952.646/1/2022 Beginning Checking Balance$ 66,826.14 Checking Receipts 1,513,554.25 Transfers to Checking 200,000.00 Total Deposits 1,713,554.25 Expenditures$ (220,884.47) Payroll$ (37,064.25) Total Payments 257,948.72) Ending Checking Balance 1,522,431.67 Beginnging Money Market Balance 1,377,035.40 Money Market Receipts 273.36 Tranfers to Checking 200,000.00) Ending Money Market Balance 1,177,308.76 Beginning Investments Balance 2,029,375.47 Investments Receipts 714.58 Ending Investments Balance$ 2,030,090.05 Beginning EDA Balance$ 27,399.55 EDA Receipts EDA Expenditures 379.85) EDA Transfers from Checking - in transit Ending EDA Balance$ 27,019.70 Outstanding Checks 23,130.45) 6/30/2022EndingCashBalance $ 4,733,719.73 CHECKING, MONEY MARKET & INVESTMENT CD's Checking *102$ 66,826.14BegBal Credits$ 1,713,554.25 Debits$ (257,948.72) 1,522,431.67EndBal Money Market *105 - Rate .25%$ 1,377,035.40BegBal rate change from 1.25% Credits 273.36 Debits 200,000.00) End Bal$ 1,177,308.76 Investments CD *4422 - Rate .45% 12 mo., 3/25/2023$ 317,375.52 CD *4424 - Rate .30% 12 mo., 7/25/2022$ 441,025.35 CD *4425 - Rate .30% 12 mo., 9/28/2022$ 734,083.62 CD *4426 - Rate .30% 12 mo., 1/29/2023 537,605.56 Total Investments$ 2,030,090.05 Total Bank & Investment Accounts 4,729,830.48 23,130.45) Checks in Transit *3102 Deposit in transit checking Deposit in transit money market 4,706,700.03TotalAdjustedUndesignatedFunds Scandia EDA *6301 $ 27,399.55 Receipts Expenditures Checks in Transit$ (379.85) Deposit in Transit Total Designated EDA Funds$ 27,019.70 Total Funds$ 4,733,719.73 Submitted by: Colleen Firkus, Treasurer CASH BALANCES 2022ENDOF MONTH FUNDJANUARYFEBRUARYMARCHAPRILMAYJUNE 101 GENERAL$1,375,256$1,243,314$1,124,142$1,012,874$890,925$1,701,216 203 COVID-19 RELIEF$228,181$228,181$228,181$228,181$228,181$228,181 226 CABLE TV$39,431$41,288$42,941$43,837$44,302$17,600 230 RESTRICTED DONATIONS$175$175$925$2,525$3,575$3,575 307 BLACKTOP PROJECT 2007$0$0$6,464$6,464$6,464$6,731 313 EQUIPMENT CERTIFICATES$24,314$24,314$24,314$25,110$25,110($3,745) 315 EQUIPMENT CERTIFICATES$15,452$15,452$15,452$15,951$15,951$15,951 317 EQUIPMENT CERTIFICATES($298)($298)($298)$103$103$17,365 318 BLACKTOP PROJECT$603$603$603$4,359($45,198)$127,067 401 CAPITAL IMPR$818,050$811,650$719,740$716,800$716,431$822,054 404 PARK CAP IMPR$144,888$144,888$153,888$154,216$154,216$165,491 406 EQUIPMENT REPLACEMENT$316,105$316,105$316,105$104,260$104,260$155,827 408 LOCAL ROAD IMPROVEMENT$1,258,340$1,248,056$1,220,766$1,226,717$1,220,617$1,329,096 602 BIG MARINE SEWER$96,113$91,196$78,022$79,321$49,281$64,261 612 UPTOWN SEWER$14,094$16,430$15,021$15,051$14,348$13,148 801 ESCROW$33,341$38,526$34,870$33,870$36,986$42,880 SUBTOTAL$4,364,046$4,219,882$3,981,137$3,669,640$3,465,553$4,706,700 225 EDA$28,904$28,904$27,703$27,345$27,400$27,020 TOTAL$4,392,949$4,248,785$4,008,839$3,696,985$3,492,953$4,733,720 CITY OF SCANDIA Revenue - Expenditure Summary June 2022 Description2022 BudgetYTD AmountJune AmountBudget Balance% of BudgetComments GENERAL FUND RevenueR 101-41000-31000 Washington Cty. TaxSettlement$1,583,000.00$811,918.35$811,918.35$771,081.6551.29% R101-41000-31040Fiscal Disparities$0.00$89,539.20$89,539.20-$89,539.200.00% R101-41000-31701 GravelTaxes$20,000.00$0.00$0.00$20,000.000.00% R101-41000-31830Solar Energy Production Tax$5,000.00$4,115.14$4,115.14$884.8682.30% R101-41000-31900 Penalties & Interest DelTax$400.00$234.87$234.87$165.1358.72% R101-41000-32150 Utility Permits$3,000.00$2,250.00$0.00$750.0075.00% R101-41000-32180 Tobacco & Liquor Licenses$8,500.00$422.00$25.00$8,078.004.96% R101-41000-32190 Other CityPermits$3,000.00$1,740.00$500.00$1,260.0058.00% R101-41000-32210 Building Permits$135,000.00$77,453.43$15,113.17$57,546.5757.37% R101-41000-32260 Gambling Permits$0.00$115.00$0.00-$115.000.00% R101-41000-33401 LGA/MVHC/AG/PERAAid$13,200.00$0.00$0.00$13,200.000.00% R101-41000-33420 FireRelief StatePERA$39,600.00$0.00$0.00$39,600.000.00% R101-41000-33422 Other State Grants & Aids$5,400.00$0.00$0.00$5,400.000.00% R101-41000-33428PILOT$6,000.00$3,102.02$3,102.02$2,897.9851.70% R101-41000-33620Recycling Grant$9,000.00$13,188.00$13,188.00-$4,188.00146.53% R101-41000-33630 Local Govt Grants & Aids$0.00$0.00$0.00$0.000.00% R101-41000-33640 Other Grants$1,000.00$0.00$0.00$1,000.000.00% R101-41000-34102Legal Services$0.00$0.00$0.00$0.000.00% R101-41000-34103 Zoning andPlanning$4,300.00$3,050.00$1,650.00$1,250.0070.93% R101-41000-34106Engineering Fees$0.00$0.00$0.00$0.000.00% R101-41000-34107 Assessment Search Fees$100.00$20.00$0.00$80.0020.00% R101-41000-34109Water Usage$200.00$0.00$0.00$200.000.00% R101-41000-34201 Impound Fees$0.00$0.00$0.00$0.000.00% R101-41000-34202 FireProtection Services$31,493.00$31,493.00$0.00$0.00100.00% R101-41000-34301 Damage Repairs$0.00$0.00$0.00$0.000.00% R101-41000-34303 DustControl$2,400.00$3,180.46$3,180.46-$780.46132.52% R101-41000-34304 Reimbursement forServices$3,600.00$1,800.00$900.00$1,800.0050.00% R101-41000-34305 OtherStreet Services$0.00$0.00$0.00$0.000.00% R101-41000-34730AdRevenue$2,100.00$1,400.00$150.00$700.0066.67% R101-41000-34740 Coffee Sales$0.00$0.00$0.00$0.000.00% R101-41000-34750 Facilities Rental$5,000.00$6,011.80$552.00-$1,011.80120.24% R101-41000-34760 Cleaning Fees$200.00$0.00$0.00$200.000.00% R101-41000-34790Recreation Programs$1,000.00$1,465.00$65.00-$465.00146.50% R101-41000-34950 Solar Subscription$0.00$0.00$0.00$0.000.00% R101-41000-35101 Fines & Forfeitures$7,000.00$3,294.67$558.29$3,705.3347.07% R101-41000-35201 Forfeited Land Sales$0.00$0.00$0.00$0.000.00% R101-41000-36210 Interest Income$15,900.00$4,913.86$989.14$10,986.1430.90% R101-41000-36230 Donations$1,500.00$2,841.35$0.00-$1,341.35189.42% R101-41000-36240 Insurance Dividend$2,000.00$0.00$0.00$2,000.000.00% R101-41000-36250 Misc. Refund$2,500.00$149.85$0.00$2,350.155.99% Total General Fund Revenue$1,911,393.00$1,063,698.00$945,780.64$847,695.0055.65% MiscellaneousR 101-49000-39203 Transfer fromOther Funds$0.00$25,000.00$0.00-$25,000.00 R101-49000-39204 Money Market Transfer$0.00$470,000.00$200,000.00-$470,000.00 495,000.00$200,000.00-$495,000.00 CITY OF SCANDIA Revenue - Expenditure Summary June 2022 Description2022 BudgetYTD AmountJune AmountBudget Balance% of BudgetComments GENERAL FUND ExpenditureE 101-41000-101 Regular Wages & Salaries$162,600.00$70,483.75$11,698.81$92,116.2543.35% E101-41000-121PERA Coord. Employer Contribu.$12,000.00$5,275.78$877.42$6,724.2243.96% E101-41000-122FICAEmployer Contribution$10,100.00$3,328.35$702.59$6,771.6532.95% E101-41000-126MEDICARE Employer Contribution$2,400.00$1,092.28$164.31$1,307.7245.51% E101-41000-131Employer PaidHealth$23,600.00$13,501.13$3,113.24$10,098.8757.21% E101-41000-132Dental Insurance$2,900.00$483.66$80.61$2,416.3416.68% E101-41000-134Employer PaidLife$600.00$240.00$40.00$360.0040.00% E101-41000-135Employer PaidDisability$1,200.00$251.34$41.89$948.6620.95% E101-41000-151 Worker sComp Insurance Prem$1,200.00$1,728.55$0.00-$528.55144.05% E101-41000-200Office Supplies$1,000.00$597.02$330.64$402.9859.70% E101-41000-203Printed Forms & Papers$1,800.00$973.07$0.00$826.9354.06% E101-41000-210Operating Supplies$900.00$665.83$164.00$234.1773.98% E101-41000-300Assessor$0.00$0.00$0.00$0.000.00% E101-41000-301Auditing andAcctgServices$20,800.00$17,200.00$0.00$3,600.0082.69% E101-41000-303Engineering Fees$0.00$180.00$180.00-$180.000.00% E101-41000-304Legal Services$40,000.00$18,506.90$3,381.50$21,493.1046.27% E101-41000-306Personal Testing & Recruit$0.00$0.00$0.00$0.000.00% E101-41000-308Other Professional Services$1,000.00$1,403.95$0.00-$403.95140.40% E101-41000-309Software Support & Maintenance$12,000.00$12,154.38$693.58-$154.38101.29% E101-41000-313Committee & Commission Reimbur$0.00$0.00$0.00$0.000.00% E101-41000-314Animal Control$0.00$464.99$314.99-$464.990.00% E101-41000-316Conferences & Seminars$800.00$1,049.00$0.00-$249.00131.13% E101-41000-317Employee Training$500.00$0.00$0.00$500.000.00% E101-41000-319Other Services$1,300.00$74.00$35.00$1,226.005.69% E101-41000-321Telephone$4,500.00$2,434.49$457.58$2,065.5154.10% E101-41000-322Postage$2,300.00$1,065.66$123.35$1,234.3446.33% E101-41000-323 $0.00$0.00$0.00$0.000.00% E101-41000-331Travel Expenses$2,500.00$453.31$184.69$2,046.6918.13% E101-41000-351Legal Notices Publishing$2,000.00$894.15$25.50$1,105.8544.71% E101-41000-361Liability/Property Ins$4,100.00$4,568.15$0.00-$468.15111.42% E101-41000-365 Insurance Claims$0.00$0.00$0.00$0.000.00% E101-41000-381Utilities-Electric & Gas$12,000.00$2,781.33$841.97$9,218.6723.18% E101-41000-413Equipment Rental$2,800.00$860.18$345.96$1,939.8230.72% E101-41000-430 Recycling$27,800.00$13,923.00$2,320.50$13,877.0050.08% E101-41000-433Dues andSubscriptions$5,900.00$289.62$185.62$5,610.384.91% E101-41000-434Youth Service Bureau$5,500.00$5,500.00$5,500.00$0.00100.00% E101-41000-435 Misc Expense$0.00$0.00$0.00$0.000.00% E101-41000-437CableTVFranchise$0.00$0.00$0.00$0.000.00% E101-41000-438Misc. Contractual$3,600.00$3,562.00$0.00$38.0098.94% E101-41000-439Refunds Issued$0.00$0.00$0.00$0.000.00% E101-41000-560Furniture andFixtures$0.00$0.00$0.00$0.000.00% E101-41000-570Office Equipment$4,000.00$2,603.23$0.00$1,396.7765.08% 373,700.00$188,589.10$31,803.75$185,110.9050.47% City CouncilE 101-41110-101Regular Wages & Salaries$18,100.00$4,486.39$0.00$13,613.6124.79% E101-41110-122FICAEmployer Contribution$1,100.00$106.30$0.00$993.709.66% E101-41110-126MEDICARE Employer Contribution$300.00$12.97$0.00$287.034.32% E101-41110-127PERA Defined$600.00$138.58$0.00$461.4223.10% E101-41110-151 Worker sComp Insurance Prem$100.00$0.00$0.00$100.000.00% E101-41110-316Conferences & Seminars$1,000.00$398.00$0.00$602.0039.80% E101-41110-331Travel Expenses$1,800.00$0.00$0.00$1,800.000.00% 23,000.00$5,142.24$0.00$17,857.7622.36% ElectionsE 101-41410-199Election Judge$4,800.00$0.00$0.00$4,800.000.00% E101-41410-200Office Supplies$100.00$0.00$0.00$100.000.00% E101-41410-203Printed Forms & Papers$0.00$0.00$0.00$0.000.00% E101-41410-210Operating Supplies$1,000.00$0.00$0.00$1,000.000.00% E101-41410-351Legal Notices Publishing$200.00$0.00$0.00$200.000.00% E101-41410-413Equipment Rental$1,500.00$1,515.00$0.00-$15.00101.00% 7,600.00$1,515.00$0.00$6,085.0019.93% Planning & BuildingE 101-41910-101Regular Wages & Salaries$49,800.00$24,345.35$3,872.66$25,454.6548.89% E101-41910-121PERA Coord. Employer Contribu.$3,600.00$1,824.88$290.46$1,775.1250.69% E101-41910-122FICAEmployer Contribution$3,100.00$1,409.47$225.04$1,690.5345.47% E101-41910-126MEDICARE Employer Contribution$700.00$342.45$52.62$357.5548.92% E101-41910-131Employer PaidHealth$11,400.00$6,753.57$1,688.84$4,646.4359.24% E101-41910-132Dental Insurance$1,900.00$250.14$41.69$1,649.8613.17% E101-41910-134Employer PaidLife$200.00$86.40$14.40$113.6043.20% E101-41910-135Employer PaidDisability$400.00$201.18$33.53$198.8250.30% E101-41910-203Printed Forms & Papers$20.00$253.55$0.00-$233.551267.75% E101-41910-311 Contract Permit Inspections$55,000.00$26,956.68$7,728.39$28,043.3249.01% E101-41910-312Planning Services$28,000.00$6,170.56$2,627.08$21,829.4422.04% E101-41910-313Committee & Commission Reimbur$5,000.00$2,600.00$1,300.00$2,400.0052.00% E101-41910-316Conferences & Seminars$0.00$0.00$0.00$0.000.00% E101-41910-319Other Services$0.00$0.00$0.00$0.000.00% E101-41910-361Liability/Property Ins$1,800.00$2,005.53$0.00-$205.53111.42% E101-41910-438Misc. Contractual$11,000.00$2,342.32$0.00$8,657.6821.29% E101-41910-439Refunds Issued$0.00-$572.80$0.00$572.800.00% 171,920.00$74,969.28$17,874.71$96,950.7243.61% CITY OF SCANDIA Revenue - Expenditure Summary June 2022 Description2022 BudgetYTD AmountJune AmountBudget Balance% of BudgetComments GENERAL FUND CONT. AssessorE 101-41960-300 Assessor$21,600.00$10,878.19$1,878.19$10,721.8150.36% Police E101-42100-318Police Contract$150,400.00$0.00$0.00$150,400.000.00% E101-42100-319Other Services$500.00$309.36$0.00$190.6461.87% 150,900.00$309.36$0.00$150,590.640.21% FireDept E101-42200-101Regular Wages & Salaries$95,000.00$54,812.18$13,002.90$40,187.8257.70% E101-42200-121PERA Coord. Employer Contribu.$9,700.00$0.00$0.00$9,700.000.00% E101-42200-122FICAEmployer Contribution$5,900.00$2,873.26$658.23$3,026.7448.70% E101-42200-124Police & FirePERA$0.00$4,257.97$725.62-$4,257.970.00% E101-42200-126MEDICARE Employer Contribution$1,400.00$474.40$190.00$925.6033.89% E101-42200-134Employer PaidLife$200.00$96.00$16.00$104.0048.00% E101-42200-135Employer PaidDisability$700.00$0.00$0.00$700.000.00% E101-42200-141Unemployment Compensation$0.00$0.00$0.00$0.000.00% E101-42200-151 Worker sComp Insurance Prem$9,550.00$12,640.48$0.00-$3,090.48132.36% E101-42200-200Office Supplies$400.00$0.00$0.00$400.000.00% E101-42200-203Printed Forms & Papers$150.00$0.00$0.00$150.000.00% E101-42200-209Medical Supplies$2,500.00$2,222.86$70.25$277.1488.91% E101-42200-210Operating Supplies$8,000.00$834.31$148.48$7,165.6910.43% E101-42200-211Cleaning Supplies$100.00$17.88$0.00$82.1217.88% E101-42200-212Fuel$2,500.00$1,730.68$556.22$769.3269.23% E101-42200-217Uniforms & SafetyEquipment$10,000.00$0.00$0.00$10,000.000.00% E101-42200-221Equipment Parts$3,000.00$204.50$0.00$2,795.506.82% E101-42200-222Tires$0.00$1,540.36$0.00-$1,540.360.00% E101-42200-223Structure Repair & Supplies$5,300.00$12.84$0.00$5,287.160.24% E101-42200-240Small Tools andMinor Equip$8,500.00$8,709.65$767.21-$209.65102.47% E101-42200-305 Medical Services$4,500.00$5,635.00$165.00-$1,135.00125.22% E101-42200-306Personal Testing & Recruit$1,500.00$903.00$903.00$597.0060.20% E101-42200-309Software Support & Maintenance$17,000.00$5,689.56$777.00$11,310.4433.47% E101-42200-310Medical Training$11,000.00$0.00$0.00$11,000.000.00% E101-42200-316Conferences & Seminars$300.00$0.00$0.00$300.000.00% E101-42200-317Employee Training$8,000.00-$5,930.00$1,570.00$13,930.00-74.13% E101-42200-319Other Services$500.00$70.00$0.00$430.0014.00% E101-42200-321Telephone$6,400.00$3,299.01$853.73$3,100.9951.55% E101-42200-322Postage$0.00$0.00$0.00$0.000.00% E101-42200-324State ofMN-FireRelief$35,300.00$0.00$0.00$35,300.000.00% E101-42200-325City Match-FireRelief$0.00$0.00$0.00$0.000.00% E101-42200-331Travel Expenses$2,000.00$0.00$0.00$2,000.000.00% E101-42200-334Licenses & Permits$200.00$0.00$0.00$200.000.00% E101-42200-340Advertising$0.00$0.00$0.00$0.000.00% E101-42200-361Liability/Property Ins$6,000.00$6,685.09$0.00-$685.09111.42% E101-42200-381Utilities-Electric & Gas$4,000.00$5,995.29$316.23-$1,995.29149.88% E101-42200-384Refuse/Garbage Disposal$850.00$507.64$97.89$342.3659.72% E101-42200-385Sewer Pumping & Maintenance$700.00$300.00$0.00$400.0042.86% E101-42200-401Building Maintenance/Repairs$2,500.00$1,302.46$150.00$1,197.5452.10% E101-42200-403Improvements OtherThan Bldgs$0.00$0.00$0.00$0.000.00% E101-42200-404Repair Machinery/Equipment$8,000.00$2,981.00$776.41$5,019.0037.26% E101-42200-407Well Repair & Maintenance$140.00$0.00$0.00$140.000.00% E101-42200-433Dues andSubscriptions$2,100.00$2,349.58$1,254.58-$249.58111.88% E101-42200-438Misc. Contractual$4,100.00$1,605.00$0.00$2,495.0039.15% E101-42200-440Events$800.00$0.00$0.00$800.000.00% E101-42200-520Capital Improvements toBldgs$0.00$0.00$0.00$0.000.00% E101-42200-530Capital Impr OtherThan Bldgs$0.00$1,178.00$0.00-$1,178.000.00% E101-42200-540 HeavyMachinery Capital$0.00$0.00$0.00$0.000.00% E101-42200-560Furniture andFixtures$500.00$0.00$0.00$500.000.00% E101-42200-570Office Equipment$900.00$0.00$0.00$900.000.00% 280,190.00$122,998.00$22,998.75$157,192.0043.90% Animal ControlE 101-42700-314 Animal Control$4,000.00$1,235.04$310.00$2,764.9630.88% CITY OF SCANDIA Revenue - Expenditure Summary June 2022 Description2022 BudgetYTD AmountJune AmountBudget Balance% of BudgetComments GENERAL FUND CONT. Public WorksE 101-43000-101 Regular Wages & Salaries$220,300.00$99,298.94$17,067.35$121,001.0645.07% E101-43000-102OTRegular Wages$4,900.00$7,024.23$300.77-$2,124.23143.35% E101-43000-104Temporary Employee Wages$3,700.00$2,721.07$0.00$978.9373.54% E101-43000-121PERA Coord. Employer Contribu.$16,900.00$7,958.04$1,302.62$8,941.9647.09% E101-43000-122FICAEmployer Contribution$14,000.00$6,989.84$1,019.36$7,010.1649.93% E101-43000-126MEDICARE Employer Contribution$3,300.00$1,657.45$238.41$1,642.5550.23% E101-43000-131Employer PaidHealth$53,600.00$32,303.79$6,274.72$21,296.2160.27% E101-43000-132Dental Insurance$2,000.00$498.84$83.14$1,501.1624.94% E101-43000-134Employer PaidLife$700.00$373.88$68.84$326.1253.41% E101-43000-135Employer PaidDisability$1,700.00$868.74$144.79$831.2651.10% E101-43000-141Unemployment Compensation$1,500.00$0.00$0.00$1,500.000.00% E101-43000-151 Worker sComp Insurance Prem$16,890.00$22,366.65$0.00-$5,476.65132.43% E101-43000-200Office Supplies$600.00$0.00$0.00$600.000.00% E101-43000-210Operating Supplies$8,000.00$4,702.18$879.29$3,297.8258.78% E101-43000-212Fuel$18,000.00$10,039.01$1,999.28$7,960.9955.77% E101-43000-217Uniforms & SafetyEquipment$2,000.00$343.81$0.00$1,656.1917.19% E101-43000-221Equipment Parts$12,100.00$6,501.34$137.48$5,598.6653.73% E101-43000-222Tires$6,500.00$0.00$0.00$6,500.000.00% E101-43000-223Structure Repair & Supplies$2,000.00$0.00$0.00$2,000.000.00% E101-43000-224 Materials forRoad Maintenance$15,000.00$4,818.69$1,359.48$10,181.3132.12% E101-43000-226SignReplacement andRepair$2,000.00$570.95$495.95$1,429.0528.55% E101-43000-228Gravel$9,900.00$696.65$696.65$9,203.357.04% E101-43000-229Salt$19,000.00$15,652.75$0.00$3,347.2582.38% E101-43000-240Small Tools andMinor Equip$5,000.00$32.09$0.00$4,967.910.64% E101-43000-302Surveying$0.00$0.00$0.00$0.000.00% E101-43000-303Engineering Fees$9,400.00$3,079.00$0.00$6,321.0032.76% E101-43000-304Legal Services$0.00$0.00$0.00$0.000.00% E101-43000-305 Medical Services$1,200.00$457.65$49.95$742.3538.14% E101-43000-309Software Support & Maintenance$1,900.00$0.00$0.00$1,900.000.00% E101-43000-317Employee Training$1,700.00$0.00$0.00$1,700.000.00% E101-43000-319Other Services$13,200.00$1,162.21$22.95$12,037.798.80% E101-43000-321Telephone$4,800.00$2,205.74$396.91$2,594.2645.95% E101-43000-331Travel Expenses$500.00$0.00$0.00$500.000.00% E101-43000-334Licenses & Permits$500.00$173.25$0.00$326.7534.65% E101-43000-361Liability/Property Ins$9,300.00$10,361.91$0.00-$1,061.91111.42% E101-43000-365 Insurance Claims$0.00$0.00$0.00$0.000.00% E101-43000-381Utilities-Electric & Gas$3,200.00$4,141.91$236.13-$941.91129.43% E101-43000-384Refuse/Garbage Disposal$900.00$645.83$65.26$254.1771.76% E101-43000-385Sewer Pumping & Maintenance$800.00$755.80$0.00$44.2094.48% E101-43000-387Street Light Utilities$4,000.00$2,246.97$356.39$1,753.0356.17% E101-43000-401Building Maintenance/Repairs$5,500.00$1,225.87$203.40$4,274.1322.29% E101-43000-403Improvements OtherThan Bldgs$0.00$0.00$0.00$0.000.00% E101-43000-404Repair Machinery/Equipment$14,000.00$378.25$0.00$13,621.752.70% E101-43000-405Contractual Road Maint/Repair$150,000.00$32,145.61$32,145.61$117,854.3921.43% E101-43000-407Well Repair & Maintenance$0.00$0.00$0.00$0.000.00% E101-43000-413Equipment Rental$3,500.00$1,304.35$1,259.25$2,195.6537.27% E101-43000-417Uniform Rental$1,000.00$399.22$76.76$600.7839.92% E101-43000-433Dues andSubscriptions$200.00$0.00$0.00$200.000.00% E101-43000-438Misc. Contractual$15,000.00$931.00$931.00$14,069.006.21% E101-43000-439Refunds Issued$0.00$0.00$0.00$0.000.00% E101-43000-530Capital Impr OtherThan Bldgs$0.00$1,178.00$0.00-$1,178.000.00% E101-43000-550Motor Vehicles Capital$0.00$0.00$0.00$0.000.00% E101-43000-560Furniture andFixtures$0.00$0.00$0.00$0.000.00% E101-43000-570Office Equipment$3,300.00$589.49$0.00$2,710.5117.86% 683,490.00$288,801.00$67,811.74$394,689.0042.25% CITY OF SCANDIA Revenue - Expenditure Summary June 2022 Description2022 BudgetYTD AmountJune AmountBudget Balance% of BudgetComments GENERAL FUND CONT. ParksE 101-45000-101 Regular Wages & Salaries$9,800.00$3,795.06$734.38$6,004.9438.73% E101-45000-104Temporary Employee Wages$29,100.00$9,184.13$1,550.00$19,915.8731.56% E101-45000-121PERA Coord. Employer Contribu.$700.00$283.18$55.08$416.8240.45% E101-45000-122FICAEmployer Contribution$2,600.00$777.98$139.21$1,822.0229.92% E101-45000-126MEDICARE Employer Contribution$600.00$198.91$32.54$401.0933.15% E101-45000-131Employer PaidHealth$2,100.00$1,539.30$236.33$560.7073.30% E101-45000-132Dental Insurance$100.00$18.12$3.02$81.8818.12% E101-45000-134Employer PaidLife$0.00$72.02$12.26-$72.020.00% E101-45000-135Employer PaidDisability$1,000.00$186.30$31.05$813.7018.63% E101-45000-141Unemployment Compensation$0.00$0.00$0.00$0.000.00% E101-45000-151 Worker sComp Insurance Prem$1,450.00$1,914.86$0.00-$464.86132.06% E101-45000-200Office Supplies$300.00$0.00$0.00$300.000.00% E101-45000-203Printed Forms & Papers$900.00$77.60$77.60$822.408.62% E101-45000-210Operating Supplies$900.00$258.92$39.59$641.0828.77% E101-45000-212Fuel$1,500.00$450.77$0.00$1,049.2330.05% E101-45000-221Equipment Parts$2,000.00$232.72$70.94$1,767.2811.64% E101-45000-223Structure Repair & Supplies$500.00$0.00$0.00$500.000.00% E101-45000-240Small Tools andMinor Equip$0.00$359.90$0.00-$359.900.00% E101-45000-312Planning Services$0.00$0.00$0.00$0.000.00% E101-45000-313Committee & Commission Reimbur$1,200.00$540.00$300.00$660.0045.00% E101-45000-319Other Services$0.00$121.60$0.00-$121.600.00% E101-45000-322Postage$0.00$0.00$0.00$0.000.00% E101-45000-340Advertising$0.00$180.00$0.00-$180.000.00% E101-45000-353Sales& UseTax$0.00$0.00$0.00$0.000.00% E101-45000-361Liability/Property Ins$7,100.00$7,910.69$0.00-$810.69111.42% E101-45000-381Utilities-Electric & Gas$4,000.00$4,449.83$942.55-$449.83111.25% E101-45000-384Refuse/Garbage Disposal$1,900.00$2,141.84$808.71-$241.84112.73% E101-45000-385Sewer Pumping & Maintenance$500.00$142.97$0.00$357.0328.59% E101-45000-401Building Maintenance/Repairs$6,000.00$437.98$150.00$5,562.027.30% E101-45000-403Improvements OtherThan Bldgs$0.00$1,486.49$0.00-$1,486.490.00% E101-45000-404Repair Machinery/Equipment$700.00$100.00$0.00$600.0014.29% E101-45000-406Grounds Care$4,000.00$0.00$0.00$4,000.000.00% E101-45000-438Misc. Contractual$3,000.00$0.00$0.00$3,000.000.00% E101-45000-439Refunds Issued$0.00$0.00$0.00$0.000.00% E101-45000-440Events$3,000.00$6,492.69$0.00-$3,492.69216.42% E101-45000-490Financial Assistance$0.00$0.00$0.00$0.000.00% E101-45000-530Capital Impr OtherThan Bldgs$10,000.00$0.00$0.00$10,000.000.00% 94,950.00$43,353.86$5,183.26$51,596.1445.66% Community CenterE 101-45180-101Regular Wages & Salaries$14,400.00$6,668.09$1,071.34$7,731.9146.31% E101-45180-104Temporary Employee Wages$0.00$0.00$0.00$0.000.00% E101-45180-121PERA Coord. Employer Contribu.$1,100.00$481.07$80.31$618.9343.73% E101-45180-122FICAEmployer Contribution$900.00$385.76$62.78$514.2442.86% E101-45180-126MEDICARE Employer Contribution$200.00$99.39$14.70$100.6149.70% E101-45180-131Employer PaidHealth$3,100.00$1,498.37$242.10$1,601.6348.33% E101-45180-134Employer PaidLife$0.00$23.70$4.50-$23.700.00% E101-45180-135Employer PaidDisability$100.00$68.64$11.44$31.3668.64% E101-45180-151 Worker sComp Insurance Prem$0.00$0.00$0.00$0.000.00% E101-45180-210Operating Supplies$2,800.00$628.24$91.70$2,171.7622.44% E101-45180-223Structure Repair & Supplies$6,500.00$8.77$0.00$6,491.230.13% E101-45180-334Licenses & Permits$900.00$777.00$40.00$123.0086.33% E101-45180-361Liability/Property Ins$2,300.00$2,562.62$0.00-$262.62111.42% E101-45180-381Utilities-Electric & Gas$10,600.00$6,039.02$695.19$4,560.9856.97% E101-45180-384Refuse/Garbage Disposal$1,800.00$804.18$153.42$995.8244.68% E101-45180-385Sewer Pumping & Maintenance$3,500.00$1,575.81$0.00$1,924.1945.02% E101-45180-401Building Maintenance/Repairs$13,000.00$7,244.61$570.08$5,755.3955.73% E101-45180-404Repair Machinery/Equipment$3,000.00$0.00$0.00$3,000.000.00% E101-45180-406Grounds Care$650.00$0.00$0.00$650.000.00% E101-45180-407Well Repair & Maintenance$600.00$13,675.00$13,330.00-$13,075.002279.17% E101-45180-438Misc. Contractual$2,500.00$0.00$0.00$2,500.000.00% E101-45180-439Refunds Issued$0.00$0.00$0.00$0.000.00% E101-45180-520Capital Improvements toBldgs$6,000.00$1,999.00$0.00$4,001.0033.32% 73,950.00$44,539.27$16,367.56$29,410.7360.23% TransfersE 101-49000-720 Operating Transfers$0.00$495,000.00$200,000.00-$495,000.00 TOTALGENERAL FUND EXPENDITURES$1,885,300.00$782,330.34$164,227.96$1,102,969.6641.50% CITY OF SCANDIA Revenue - Expenditure Summary June 2022 Description2022 BudgetYTD AmountJune AmountBudget Balance% of BudgetComments COVID RELIEF FUND RevenueR 203-46200-33150 Federal Grant$0.00$0.00$0.00$0.000.00% ExpenditureE 203-49000-720 Operating Transfers$0.00$0.00$0.00$0.000.00% EDAFUND RevenueR 225-46500-31000 Washington Cty. Tax Settlement$8,000.00$4,000.00$4,000.00$4,000.0050.00% R225-46500-33640 Other Grants$0.00$0.00$0.00$0.000.00% R225-46500-36210 Interest Income$200.00$0.00$0.00$200.000.00% Total EDAFund Revenue$8,200.00$4,000.00$4,000.00$4,200.0048.78% ExpenditureE 225-46500-210 Operating Supplies$0.00$0.00$0.00$0.000.00% E225-46500-303Engineering Fees$5,000.00$0.00$0.00$5,000.000.00% E225-46500-304Legal Services$0.00$0.00$0.00$0.000.00% E225-46500-308Other Professional Services$125.00$0.00$0.00$125.000.00% E225-46500-340Advertising$2,000.00$75.00$0.00$1,925.003.75% E225-46500-433Dues andSubscriptions$2,650.00$1,653.00$0.00$997.0062.38% E225-46500-440Events$400.00$590.85$304.85-$190.85147.71% Total EDAFund Expenditures$10,175.00$2,318.85$304.85$7,856.1522.79% CABLE TVFUND RevenueR 226-41950-36210 Interest Income$0.00$0.00$0.00$0.000.00% R226-41950-38050 Cable TVFranchise Rebates$15,400.00$7,814.83$1,588.11$7,585.1750.75% R226-41950-38051 PEGFees$3,500.00$2,118.24$429.32$1,381.7660.52% Total Cable TVFund Revenue$18,900.00$9,933.07$2,017.43$8,966.9352.56% ExpenditureE 226-41950-240 Small Tools and Minor Equip$0.00$498.00$0.00-$498.000.00% E226-41950-309Software Support & Maintenance$3,500.00$2,018.84$120.31$1,481.1657.68% E226-41950-438Misc. Contractual$8,000.00$2,300.00$1,610.00$5,700.0028.75% E226-41950-570Office Equipment$250.00$0.00$0.00$250.000.00% Total Cable TVFund Expenditures$11,750.00$4,816.84$1,730.31$6,933.1640.99% GATEWAY TRAILFUND RevenueR 230-45000-36230 Donations$0.00$3,400.00$0.00-$3,400.000.00% ExpenditureE 230-45000-308 Other Professional Services$0.00$0.00$0.00$0.000.00% BLACKTOP PROJECCT 2007 RevenueR 307-47000-31952 SAPenalties & Interest$0.00$6,698.52$234.87-$6,698.520.00% 2013 EQUIPMENT CERTIFICATES RevenueR 313-47000-31000 Washington Cty. Tax Settlement$67,000.00$33,500.00$33,500.00$33,500.0050.00% ExpenditureE 313-47000-601 LongTerm Debt Principal$60,000.00$60,000.00$60,000.00$0.00100.00% E313-47000-611Long TermDebt Interest$2,790.00$1,860.00$1,860.00$930.0066.67% E313-47000-620Fiscal Agent sFees$495.00$495.00$495.00$0.00100.00% 63,285.00$62,355.00$62,355.00$930.0098.53% 2017 EQUIPMENT CERTIFICATES RevenueR 317-47000-31000 Washington Cty. Tax Settlement$34,524.00$17,262.00$17,262.00$17,262.0050.00% ExpenditureE 317-47000-601 LongTerm Debt Principal$32,000.00$0.00$0.00$32,000.000.00% E317-47000-611Long TermDebt Interest$880.00$440.00$0.00$440.0050.00% E317-47000-620Fiscal Agent sFees$495.00$0.00$0.00$495.000.00% 33,375.00$440.00$0.00$32,935.001.32% 2018 STREET RECONSTRUCTION RevenueR 318-47000-31000 Washington Cty. Tax Settlement$344,531.00$172,265.50$172,265.50$172,265.5050.00% ExpenditureE 318-47000-601 LongTerm Debt Principal$230,000.00$0.00$0.00$230,000.000.00% E318-47000-611Long TermDebt Interest$98,125.00$49,062.51$0.00$49,062.4950.00% E318-47000-620Fiscal Agent sFees$495.00$495.00$0.00$0.00100.00% 328,620.00$49,557.51$0.00$279,062.4915.08% CITY OF SCANDIA Revenue - Expenditure Summary June 2022 Description2022 BudgetYTD AmountJune AmountBudget Balance% of BudgetComments CAPITAL IMPROVEMENTS RevenueR 401-48000-31000 Washington Cty. Tax Settlement$217,336.00$0.00$0.00$217,336.000.00% R401-48000-33422 Other State Grants & Aids$240,625.00$0.00$0.00$240,625.000.00% R401-48000-36100 Special Assessments$510.00$0.00$0.00$510.000.00% R401-48000-36210 Interest Income$4,500.00$0.00$0.00$4,500.000.00% R401-48000-39200Interfund Operating Transfer$200,000.00$0.00$0.00$200,000.000.00% TotalCapital Improvement Fund Revenue$662,971.00$0.00$0.00$662,971.000.00% ExpenditureE 401-41000-312 Planning Services$0.00$5,771.25$3,045.00-$5,771.250.00% E401-41000-520Capital Improvements toBldgs$0.00$12,750.00$0.00-$12,750.000.00% E401-41000-530Capital Impr OtherThan Bldgs$319,280.00$4,950.00$0.00$314,330.001.55% E401-45180-520Capital Improvements toBldgs$52,000.00$16,609.43$0.00$35,390.5731.94% E401-48000-438Misc. Contractual$286,000.00$0.00$0.00$286,000.000.00% TotalCapital Improvement Fund Expenditures$657,280.00$40,080.68$3,045.00$617,199.326.10% PARK DEVELOPMENT RevenueR 404-48000-31000 Washington Cty. Tax Settlement$20,000.00$10,000.00$10,000.00$10,000.0050.00% R404-48000-33422 Other State Grants & Aids$104,000.00$0.00$0.00$104,000.000.00% R404-48000-33640 Other Grants$0.00$0.00$0.00$0.000.00% R404-48000-34780Park Dedication Fees$3,000.00$0.00$0.00$3,000.000.00% R404-48000-36210 Interest Income$1,200.00$0.00$0.00$1,200.000.00% R404-48000-36230 Donations$0.00$1,400.00$1,400.00-$1,400.000.00% Total ParkDevelopment Fund Revenue$128,200.00$11,400.00$11,400.00$116,800.008.89% ExpenditureE 404-48000-312 Planning Services$15,600.00$0.00$0.00$15,600.000.00% E404-48000-530Capital Impr OtherThan Bldgs$219,008.00$3,125.00$125.00$215,883.001.43% E404-48000-720Operating Transfers$1,440.00$0.00$0.00$1,440.000.00% Total ParkDevelopment Fund Expenditures$236,048.00$3,125.00$125.00$232,923.001.32% EQUIPMENT REPLACEMENT FUND RevenueR 406-48500-31000 Washington Cty. Tax Settlement$87,800.00$43,900.00$43,900.00$43,900.0050.00% R406-48500-36210 Interest Income$1,015.00$0.00$0.00$1,015.000.00% R406-48500-36260 SaleofEquipment$0.00$0.00$0.00$0.000.00% Total Equipment Replacement FundRevenue$88,815.00$43,900.00$43,900.00$44,915.0049.43% Expenditure E406-48500-540 HeavyMachinery Capital$198,500.00$204,505.68($7,667.18)-$6,005.68103.03% E406-48500-550Motor Vehicles Capital$0.00$0.00$0.00$0.000.00% Total Equipment Replacement Fund Expenditures$198,500.00$204,505.68-$7,667.18-$6,005.68103.03% LOCAL ROAD IMPROVEMENT FUND RevenueR 408-43100-31000 Washington Cty. Tax Settlement$216,860.00$108,430.00$108,430.00$108,430.0050.00% R408-43100-33422 Other State Grants & Aids$0.00$11,290.00$3,845.00-$11,290.000.00% R408-43100-36210 Interest Income$19,613.00$0.00$0.00$19,613.000.00% R408-43100-39203 Transfer from Other Funds$0.00$0.00$0.00$0.000.00% Total LRIFRevenue$236,473.00$119,720.00$112,275.00$116,753.0050.63% ExpenditureE 408-43100-303 Engineering Fees$0.00$42,851.50$3,796.00-$42,851.500.00% E408-43100-530Capital Impr OtherThan Bldgs$707,200.00$321.86$0.00$706,878.140.05% Total LRIFExpenditures$707,200.00$43,173.36$3,796.00$664,026.646.10% CITY OF SCANDIA Revenue - Expenditure Summary June 2022 Description2022 BudgetYTD AmountJune AmountBudget Balance% of BudgetComments BIGMARINE SEWER RevneueR 602-43210-34401 Sewer User Fees$109,592.00$37,745.28$10,849.75$71,846.720.00% R602-43210-34402 SEWER HOOKUP FEE$0.00$8,000.00$8,000.00-$8,000.000.00% R602-43210-36100 Special Assessments$300.00$0.00$0.00$300.000.00% R602-43210-36102 Penalties andInterest$0.00$16.83$16.83-$16.8334.44% R602-43210-36210 Interest Income$49.00$0.00$0.00$49.000.00% TotalBigMarine Sewer Revenue$109,941.00$45,762.11$18,866.58$64,178.8941.62% ExpenditureE 602-43210-101 Regular Wages & Salaries$21,600.00$9,942.69$1,669.30$11,657.3146.03% E602-43210-120 Pension Expense$0.00$0.00$0.00$0.000.00% E602-43210-121PERA Coord. Employer Contribu.$1,600.00$744.74$125.22$855.2646.55% E602-43210-122FICAEmployer Contribution$1,300.00$575.72$98.19$724.2844.29% E602-43210-126MEDICARE Employer Contribution$300.00$147.51$22.95$152.4949.17% E602-43210-151 Worker sComp Insurance Prem$900.00$1,180.37$0.00-$280.37131.15% E602-43210-200Office Supplies$200.00$85.00$0.00$115.0042.50% E602-43210-210Operating Supplies$2,400.00$122.94$38.46$2,277.065.12% E602-43210-240Small Tools andMinor Equip$550.00$0.00$0.00$550.000.00% E602-43210-303Engineering Fees$10,400.00$8,080.50$3,012.00$2,319.5077.70% E602-43210-304Legal Services$0.00$4,800.00$1,200.00-$4,800.000.00% E602-43210-308Other Professional Services$2,200.00$2,397.00$213.00-$197.00108.95% E602-43210-309Software Support & Maintenance$1,200.00$0.00$0.00$1,200.000.00% E602-43210-317Employee Training$1,400.00$572.84$0.00$827.1640.92% E602-43210-321Telephone$2,100.00$1,082.31$198.33$1,017.6951.54% E602-43210-322Postage$550.00$200.00$0.00$350.0036.36% E602-43210-331Travel Expenses$200.00$157.95$0.00$42.0578.98% E602-43210-334Licenses & Permits$1,600.00$767.97$45.97$832.0348.00% E602-43210-361Liability/Property Ins$900.00$1,002.76$0.00-$102.76111.42% E602-43210-381Utilities-Electric & Gas$2,500.00$1,042.76$187.98$1,457.2441.71% E602-43210-385Sewer Pumping & Maintenance$11,000.00$710.00$710.00$10,290.006.45% E602-43210-386Operation & Maintenance$5,000.00$712.25$0.00$4,287.7514.25% E602-43210-404Repair Machinery/Equipment$16,000.00$565.09$565.09$15,434.913.53% E602-43210-413Equipment Rental$350.00$0.00$0.00$350.000.00% E602-43210-420 Depreciation Expense$52,200.00$0.00$0.00$52,200.000.00% E602-43210-438Misc. Contractual$9,000.00$1,123.00$0.00$7,877.0012.48% E602-43210-530Capital Impr OtherThan Bldgs$79,612.00$45,830.00$0.00$33,782.0057.57% TotalBigMarine Sewer Expenditures$225,062.00$81,843.40$8,086.49$143,218.6036.36% UPTOWN SEWER RevenueR 612-43210-34401 Sewer User Fees$19,500.00$2,033.41$0.00$17,466.5910.43% R612-43210-36210 Interest Income$92.00$0.00$0.00$92.000.00% Total Uptown Sewer Revenue$19,592.00$2,033.41$0.00$17,558.5910.38% ExpenditureE 612-43210-101 Regular Wages & Salaries$9,300.00$4,322.24$696.46$4,977.7646.48% E612-43210-120 Pension Expense$0.00$0.00$0.00$0.000.00% E612-43210-121PERA Coord. Employer Contribu.$700.00$323.84$52.24$376.1646.26% E612-43210-122FICAEmployer Contribution$600.00$251.69$40.88$348.3141.95% E612-43210-126MEDICARE Employer Contribution$100.00$62.77$9.56$37.2362.77% E612-43210-151 Worker sComp Insurance Prem$0.00$295.09$0.00-$295.090.00% E612-43210-200Office Supplies$100.00$0.00$0.00$100.000.00% E612-43210-210Operating Supplies$200.00$0.00$0.00$200.000.00% E612-43210-221Equipment Parts$200.00$0.00$0.00$200.000.00% E612-43210-303Engineering Fees$300.00$0.00$0.00$300.000.00% E612-43210-308Other Professional Services$400.00$162.00$0.00$238.0040.50% E612-43210-309Software Support & Maintenance$0.00$0.00$0.00$0.000.00% E612-43210-317Employee Training$350.00$0.00$0.00$350.000.00% E612-43210-334Licenses & Permits$400.00$217.00$0.00$183.0054.25% E612-43210-361Liability/Property Ins$300.00$334.25$0.00-$34.25111.42% E612-43210-381Utilities-Electric & Gas$1,700.00$218.46$72.89$1,481.5412.85% E612-43210-385Sewer Pumping & Maintenance$1,200.00$327.17$327.17$872.8327.26% E612-43210-386Operation & Maintenance$600.00$0.00$0.00$600.000.00% E612-43210-404Repair Machinery/Equipment$1,500.00$0.00$0.00$1,500.000.00% E612-43210-420 Depreciation Expense$55,100.00$0.00$0.00$55,100.000.00% E612-43210-438Misc. Contractual$1,200.00$448.00$0.00$752.0037.33% E612-43210-530Capital Impr OtherThan Bldgs$2,600.00$0.00$0.00$2,600.000.00% Total Uptown Sewer Expenditures$76,850.00$6,962.51$1,199.20$69,887.499.06%