Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
6.b Treasurer's Monthly Report 2022
City of Scandiaaug Treasurer’sReport 4/30/2022 FUND ACCOUNTING Beginning Cash Balance $ 4,008,938.164/1/2022 Beginning Checking Balance$ 311,645.86 Checking Receipts 55,206.05 Transfers to Checking 10,000.00 Total Deposits 65,206.05 Expenditures$ (322,839.14) Payroll$ (36,552.81) Total Payments 359,391.95) Ending Checking Balance 17,459.96 Beginnging Money Market Balance 1,646,380.09 Money Market Receipts 349.30 Tranfers to Checking 10,000.00) Ending Money Market Balance 1,636,729.39 Beginning Investments Balance 2,028,655.03 Investments Receipts 720.44 Ending Investments Balance$ 2,029,375.47 Beginning EDA Balance$ 27,702.55 EDA Receipts EDA Expenditures 358.00) EDA Transfers from Checking - in transit Ending EDA Balance$ 27,344.55 Outstanding Checks 13,924.80) 4/30/2022EndingCashBalance $ 3,696,984.57 CHECKING, MONEY MARKET & INVESTMENT CD's Checking *102$ 311,645.86BegBal Credits$ 65,206.05 Debits$ (359,391.95) 17,459.96EndBal Money Market *105 - Rate .25%$ 1,646,380.09BegBal rate change from 1.25% Credits 349.30 Debits 10,000.00) End Bal$ 1,636,729.39 Investments CD *4422 - Rate .45% 12 mo., 3/25/2023$ 317,215.61 CD *4424 - Rate .30% 12 mo., 7/25/2022$ 441,025.35 CD *4425 - Rate .30% 12 mo., 9/28/2022$ 733,528.95 CD *4426 - Rate .30% 12 mo., 1/29/2023 537,605.56 Total Investments$ 2,029,375.47 Total Bank & Investment Accounts 3,683,564.82 13,924.80) Checks in Transit *3102 Deposit in transit checking Deposit in transit money market 3,669,640.02TotalAdjustedUndesignatedFunds Scandia EDA *6301 $ 27,702.55 Receipts Expenditures Checks in Transit$ (358.00) Deposit in Transit Total Designated EDA Funds$ 27,344.55 Total Funds$ 3,696,984.57 Submitted by: Colleen Firkus, Treasurer CASH BALANCES 2022END OF MONTH FUNDJANUARYFEBRUARYMARCHAPRIL 101 GENERAL$1,375,256$1,243,314$1,124,142$1,012,874 203 COVID-19RELIEF$228,181$228,181$228,181$228,181 226 CABLE TV$39,431$41,288$42,941$43,837 230 RESTRICTED DONATIONS$175$175$925$2,525 307 BLACKTOP PROJECT 2007$0$0$6,464$6,464 313 EQUIPMENT CERTIFICATES$24,314$24,314$24,314$25,110 315 EQUIPMENT CERTIFICATES$15,452$15,452$15,452$15,951 317 EQUIPMENT CERTIFICATES($298)($298)($298)$103 318 BLACKTOP PROJECT$603$603$603$4,359 401 CAPITAL IMPR$818,050$811,650$719,740$716,800 404 PARK CAP IMPR$144,888$144,888$153,888$154,216 406 EQUIPMENT REPLACEMENT$316,105$316,105$316,105$104,260 408 LOCAL ROAD IMPROVEMENT$1,258,340$1,248,056$1,220,766$1,226,717 602 BIGMARINE SEWER$96,113$91,196$78,022$79,321 612 UPTOWN SEWER$14,094$16,430$15,021$15,051 801 ESCROW$33,341$38,526$34,870$33,870 SUBTOTAL$4,364,046$4,219,882$3,981,137$3,669,640 225 EDA$28,904$28,904$27,703$27,345 TOTAL$4,392,949$4,248,785$4,008,839$3,696,985 April MTD 2022 YTD % of 2022 BudgetYTD AmountAmountBalanceBudget GENERAL FUND - REVENUE R101-41000-31000 Washington Cty. Tax Settlement$1,583,000.00$0.00$0.00$1,583,000.000.00% R101-41000-31040 Fiscal Disparities$0.00$0.00$0.00$0.000.00% R101-41000-31701 Gravel Taxes$20,000.00$0.00$0.00$20,000.000.00% R101-41000-31830 Solar Energy Production Tax$5,000.00$0.00$0.00$5,000.000.00% R101-41000-31900 Penalties & Interest DelTax$400.00$0.00$0.00$400.000.00% R101-41000-32150 Utility Permits$3,000.00$2,100.00$0.00$900.0070.00% R101-41000-32180 Tobacco & Liquor Licenses$8,500.00$397.00$0.00$8,103.004.67% R101-41000-32190 Other City Permits$3,000.00$1,090.00$95.00$1,910.0036.33% R101-41000-32210 Building Permits$135,000.00$42,030.62$21,469.24$92,969.3831.13% R101-41000-32260 Gambling Permits$0.00$115.00$0.00($115.00)0.00% R101-41000-33401 LGA/MVHC/AG/PERA Aid$13,200.00$0.00$0.00$13,200.000.00% R101-41000-33420 Fire Relief State PERA$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-33428 PILOT$6,000.00$0.00$0.00$6,000.000.00% R101-41000-33620 Recycling Grant$9,000.00$0.00$0.00$9,000.000.00% 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-34103 Zoning and Planning$4,300.00$600.00$350.00$3,700.0013.95% R101-41000-34107 Assessment Search Fees$100.00$20.00$0.00$80.0020.00% R101-41000-34109 Water Usage$200.00$0.00$0.00$200.000.00% R101-41000-34202 Fire Protection Services$32,300.00$0.00$0.00$32,300.000.00% R101-41000-34301 Damage Repairs$0.00$0.00$0.00$0.000.00% R101-41000-34303 Dust Control$2,400.00$0.00$0.00$2,400.000.00% R101-41000-34304 Reimbursement for Services$3,600.00$900.00$0.00$2,700.0025.00% R101-41000-34305 Other Street Services$0.00$0.00$0.00$0.000.00% R101-41000-34730 Ad Revenue$2,100.00$1,100.00$1,100.00$1,000.0052.38% R101-41000-34750 Facilities Rental$5,000.00$4,484.80$2,663.80$515.2089.70% R101-41000-34760 Cleaning Fees$200.00$0.00$0.00$200.000.00% R101-41000-34790 Recreation Programs$1,000.00$1,400.00$0.00($400.00)140.00% R101-41000-35101 Fines & Forfeitures$7,000.00$2,158.11$1,299.89$4,841.8930.83% R101-41000-36210 Interest Income$15,900.00$3,617.90$1,071.89$12,282.1022.75% R101-41000-36230 Donations$1,500.00$3,771.35$930.00($2,271.35)251.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$99.90$49.95$2,400.104.00% 1,912,200.00$63,884.68$29,029.77$1,848,315.323.34% April MTD 2022 YTD % of 2022 BudgetYTD AmountAmountBalanceBudget GENERAL FUND - EXPENDITURES Administration E101-41000-101 Regular Wages & Salaries$162,600.00$46,796.00$11,246.21$115,804.0028.78% E101-41000-121 PERA Coord. Employer Contribu.$12,000.00$3,499.17$843.48$8,500.8329.16% E101-41000-122 FICA Employer Contribution$10,100.00$1,905.18$674.53$8,194.8218.86% E101-41000-126 MEDICARE Employer Contribution$2,400.00$759.45$157.74$1,640.5531.64% E101-41000-131 Employer Paid Health$23,600.00$8,639.65$1,748.24$14,960.3536.61% E101-41000-132 Dental Insurance$2,900.00$322.44$80.61$2,577.5611.12% E101-41000-134 Employer Paid Life$600.00$160.00$40.00$440.0026.67% E101-41000-135 Employer Paid Disability$1,200.00$167.56$41.89$1,032.4413.96% E101-41000-151 Worker sComp Insurance Prem$1,200.00$1,728.55$0.00($528.55)144.05% E101-41000-200 Office Supplies$1,000.00$244.50$0.00$755.5024.45% E101-41000-203 Printed Forms & Papers$1,800.00$973.07$973.07$826.9354.06% E101-41000-210 Operating Supplies$900.00$355.99$29.33$544.0139.55% E101-41000-301 Auditing and Acct gServices$20,800.00$0.00$0.00$20,800.000.00% E101-41000-304 Legal Services$40,000.00$9,893.50$4,417.50$30,106.5024.73% E101-41000-306Personal Testing & Recruit$0.00$0.00$0.00$0.000.00% E101-41000-308 Other Professional Services$1,000.00$1,403.95$864.95($403.95)140.40% E101-41000-309 Software Support & Maintenance$12,000.00$2,970.70$1,257.69$9,029.3024.76% E101-41000-313Committee & Commission Reimbur$0.00$0.00$0.00$0.000.00% E101-41000-314 Animal Control$0.00$150.00$0.00($150.00)0.00% E101-41000-316Conferences & Seminars$800.00$650.00$575.00$150.0081.25% E101-41000-317 Employee Training$500.00$0.00$0.00$500.000.00% E101-41000-319 Other Services$1,300.00$39.00$4.00$1,261.003.00% E101-41000-321 Telephone$4,500.00$1,608.73$457.62$2,891.2735.75% E101-41000-322 Postage$2,300.00$572.36$304.40$1,727.6424.89% E101-41000-331 Travel Expenses$2,500.00$268.62$268.62$2,231.3810.74% E101-41000-351 Legal Notices Publishing$2,000.00$227.23$48.88$1,772.7711.36% E101-41000-361 Liability/Property Ins$4,100.00$0.00$0.00$4,100.000.00% E101-41000-365 Insurance Claims$0.00$0.00$0.00$0.000.00% E101-41000-381 Utilities-Electric & Gas$12,000.00$1,027.39$685.72$10,972.618.56% E101-41000-413 Equipment Rental$2,800.00$427.51$67.26$2,372.4915.27% E101-41000-430 Recycling$27,800.00$9,282.00$2,320.50$18,518.0033.39% E101-41000-433 Dues and Subscriptions$5,900.00$104.00$29.00$5,796.001.76% E101-41000-434 Youth Service Bureau$5,500.00$0.00$0.00$5,500.000.00% E101-41000-435 Misc Expense$0.00$0.00$0.00$0.000.00% E101-41000-438 Misc. Contractual$3,600.00$3,480.00$3,300.00$120.0096.67% E101-41000-439 Refunds Issued$0.00$0.00$0.00$0.000.00% E101-41000-560 Furniture and Fixtures$0.00$0.00$0.00$0.000.00% E101-41000-570 Office Equipment$4,000.00$2,603.23$2,603.23$1,396.7765.08% City Council E101-41110-101 Regular Wages & Salaries$18,100.00$4,486.39$4,486.38$13,613.6124.79% E101-41110-122 FICA Employer Contribution$1,100.00$106.30$53.15$993.709.66% E101-41110-126 MEDICARE Employer Contribution$300.00$12.97$65.05$287.034.32% April MTD 2022 YTD % of 2022 BudgetYTD AmountAmountBalanceBudget E101-41110-127 PERA Defined$600.00$138.58$181.45$461.4223.10% E101-41110-151 Worker sComp Insurance Prem$100.00$0.00$0.00$100.000.00% E101-41110-308 Other Professional Services$0.00$0.00$0.00$0.000.00% E101-41110-316Conferences & Seminars$1,000.00$0.00$0.00$1,000.000.00% E101-41110-331 Travel Expenses$1,800.00$0.00$0.00$1,800.000.00% Elections E101-41410-199 Election Judge$4,800.00$0.00$0.00$4,800.000.00% E101-41410-200 Office Supplies$100.00$0.00$0.00$100.000.00% E101-41410-203 Printed Forms & Papers$0.00$0.00$0.00$0.000.00% E101-41410-210 Operating Supplies$1,000.00$0.00$0.00$1,000.000.00% E101-41410-351 Legal Notices Publishing$200.00$0.00$0.00$200.000.00% E101-41410-413 Equipment Rental$1,500.00$1,515.00$0.00($15.00)101.00% Planning & Building E101-41910-101 Regular Wages & Salaries$49,800.00$16,600.03$3,872.66$33,199.9733.33% E101-41910-121 PERA Coord. Employer Contribu.$3,600.00$1,243.96$290.46$2,356.0434.55% E101-41910-122 FICA Employer Contribution$3,100.00$959.39$225.04$2,140.6130.95% E101-41910-126 MEDICARE Employer Contribution$700.00$237.21$52.62$462.7933.89% E101-41910-131 Employer Paid Health$11,400.00$4,206.89$857.84$7,193.1136.90% E101-41910-132 Dental Insurance$1,900.00$166.76$41.69$1,733.248.78% E101-41910-134 Employer Paid Life$200.00$57.60$14.40$142.4028.80% E101-41910-135 Employer Paid Disability$400.00$134.12$33.53$265.8833.53% E101-41910-203 Printed Forms & Papers$20.00$253.55$253.55($233.55)1267.75% E101-41910-311 Contract Permit Inspections$55,000.00$12,277.79$3,490.24$42,722.2122.32% E101-41910-312 Planning Services$28,000.00$3,543.48$1,458.40$24,456.5212.66% E101-41910-313Committee & Commission Reimbur$5,000.00$1,300.00$0.00$3,700.0026.00% E101-41910-316Conferences & Seminars$0.00$0.00$0.00$0.000.00% E101-41910-319 Other Services$0.00$0.00$0.00$0.000.00% E101-41910-361 Liability/Property Ins$1,800.00$0.00$0.00$1,800.000.00% E101-41910-438 Misc. Contractual$11,000.00$115.00$115.00$10,885.001.05% E101-41910-439 Refunds Issued$0.00$0.00$0.00$0.000.00% Assessor E101-41960-300 Assessor$21,600.00$7,200.00$1,800.00$14,400.0033.33% Police E101-42100-318 Police Contract$150,400.00$0.00$0.00$150,400.000.00% E101-42100-319 Other Services$500.00$309.36$0.00$190.6461.87% Fire E101-42200-101 Regular Wages & Salaries$95,000.00$31,254.09$8,953.68$63,745.9132.90% E101-42200-121 PERA Coord. Employer Contribu.$9,700.00$0.00$0.00$9,700.000.00% E101-42200-122 FICA Employer Contribution$5,900.00$1,679.55$467.16$4,220.4528.47% E101-42200-124 Police & Fire PERA$0.00$2,889.60$554.35($2,889.60)0.00% E101-42200-126 MEDICARE Employer Contribution$1,400.00$129.87$131.28$1,270.139.28% E101-42200-134 Employer Paid Life$200.00$64.00$16.00$136.0032.00% E101-42200-135 Employer Paid Disability$700.00$0.00$0.00$700.000.00% E101-42200-141 Unemployment Compensation$0.00$0.00$0.00$0.000.00% April MTD 2022 YTD % of 2022 BudgetYTD AmountAmountBalanceBudget E101-42200-151 Worker sComp Insurance Prem$9,550.00$12,640.48$0.00($3,090.48)132.36% E101-42200-200 Office Supplies$400.00$0.00$0.00$400.000.00% E101-42200-203 Printed Forms & Papers$150.00$0.00$0.00$150.000.00% E101-42200-209 Medical Supplies$2,500.00$2,152.61$0.00$347.3986.10% E101-42200-210 Operating Supplies$8,000.00$274.80$128.19$7,725.203.44% E101-42200-211 Cleaning Supplies$100.00$17.88$0.00$82.1217.88% E101-42200-212Fuel$2,500.00$700.14$216.89$1,799.8628.01% E101-42200-217 Uniforms & Safety Equipment$10,000.00$0.00$0.00$10,000.000.00% E101-42200-221 Equipment Parts$3,000.00$0.00$0.00$3,000.000.00% E101-42200-222 Tires$0.00$1,540.36$0.00($1,540.36)0.00% E101-42200-223 Structure Repair & Supplies$5,300.00$0.00$0.00$5,300.000.00% E101-42200-240 Small Tools and Minor Equip$8,500.00$7,916.46$0.00$583.5493.13% E101-42200-305 Medical Services$4,500.00$4,875.00$0.00($375.00)108.33% E101-42200-306Personal Testing & Recruit$1,500.00$0.00$0.00$1,500.000.00% E101-42200-309 Software Support & Maintenance$17,000.00$4,384.56$3,328.56$12,615.4425.79% E101-42200-310 Medical 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-317 Employee Training$8,000.00($7,500.00)$0.00$15,500.00-93.75% E101-42200-319 Other Services$500.00$0.00$0.00$500.000.00% E101-42200-321 Telephone$6,400.00$2,226.56$1,262.69$4,173.4434.79% E101-42200-322 Postage$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-325 City Match-Fire Relief$0.00$0.00$0.00$0.000.00% E101-42200-331 Travel Expenses$2,000.00$0.00$0.00$2,000.000.00% E101-42200-334 Licenses & Permits$200.00$0.00$0.00$200.000.00% E101-42200-340Advertising$0.00$0.00$0.00$0.000.00% E101-42200-361 Liability/Property Ins$6,000.00$0.00$0.00$6,000.000.00% E101-42200-381 Utilities-Electric & Gas$4,000.00$5,099.15$2,242.39($1,099.15)127.48% E101-42200-384 Refuse/Garbage Disposal$850.00$311.86$116.08$538.1436.69% E101-42200-385 Sewer Pumping & Maintenance$700.00$0.00$0.00$700.000.00% E101-42200-401 Building Maintenance/Repairs$2,500.00$1,002.46$626.23$1,497.5440.10% E101-42200-403 Improvements Other Than Bldgs$0.00$0.00$0.00$0.000.00% E101-42200-404 Repair Machinery/Equipment$8,000.00$2,092.77$2,092.77$5,907.2326.16% E101-42200-407 Well Repair & Maintenance$140.00$0.00$0.00$140.000.00% E101-42200-433 Dues and Subscriptions$2,100.00$1,095.00$0.00$1,005.0052.14% E101-42200-438 Misc. Contractual$4,100.00$0.00$0.00$4,100.000.00% E101-42200-440Events$800.00$0.00$0.00$800.000.00% E101-42200-520 Capital Improvements toBldgs$0.00$0.00$0.00$0.000.00% E101-42200-530 Capital Impr Other Than Bldgs$0.00$1,178.00$1,178.00($1,178.00)0.00% E101-42200-540Heavy Machinery Capital$0.00$0.00$0.00$0.000.00% E101-42200-560 Furniture and Fixtures$500.00$0.00$0.00$500.000.00% E101-42200-570 Office Equipment$900.00$0.00$0.00$900.000.00% Animal Control E101-42700-314 Animal Control$4,000.00$775.04$397.39$3,224.9619.38% April MTD 2022 YTD % of 2022 BudgetYTD AmountAmountBalanceBudget Public Works E101-43000-101 Regular Wages & Salaries$220,300.00$65,374.23$17,387.34$154,925.7729.68% E101-43000-102 OTRegular Wages$4,900.00$6,632.75$635.03($1,732.75)135.36% E101-43000-104Temporary Employee Wages$3,700.00$2,721.07$0.00$978.9373.54% E101-43000-121 PERA Coord. Employer Contribu.$16,900.00$5,384.30$1,351.69$11,515.7031.86% E101-43000-122 FICA Employer Contribution$14,000.00$4,976.92$1,059.54$9,023.0835.55% E101-43000-126 MEDICARE Employer Contribution$3,300.00$1,186.67$247.81$2,113.3335.96% E101-43000-131 Employer Paid Health$53,600.00$21,722.95$4,306.12$31,877.0540.53% E101-43000-132 Dental Insurance$2,000.00$332.56$83.14$1,667.4416.63% E101-43000-134 Employer Paid Life$700.00$246.88$61.72$453.1235.27% E101-43000-135 Employer Paid Disability$1,700.00$579.16$144.79$1,120.8434.07% E101-43000-141 Unemployment 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.65)132.43% E101-43000-200 Office Supplies$600.00$0.00$0.00$600.000.00% E101-43000-210 Operating Supplies$8,000.00$3,464.51$935.32$4,535.4943.31% E101-43000-212Fuel$18,000.00$6,799.25$2,127.24$11,200.7537.77% E101-43000-217 Uniforms & Safety Equipment$2,000.00$343.81$53.81$1,656.1917.19% E101-43000-221 Equipment Parts$12,100.00$6,044.36$611.05$6,055.6449.95% E101-43000-222 Tires$6,500.00$0.00$0.00$6,500.000.00% E101-43000-223 Structure Repair & Supplies$2,000.00$0.00$0.00$2,000.000.00% E101-43000-224Materials for Road Maintenance$15,000.00$3,006.12$2,473.83$11,993.8820.04% E101-43000-226 Sign Replacement and Repair$2,000.00$75.00$75.00$1,925.003.75% E101-43000-228 Gravel$9,900.00$0.00$0.00$9,900.000.00% E101-43000-229 Salt$19,000.00$371.75$371.75$18,628.251.96% E101-43000-240 Small Tools and Minor Equip$5,000.00$32.09$32.09$4,967.910.64% E101-43000-302 Surveying$0.00$0.00$0.00$0.000.00% E101-43000-303 Engineering Fees$9,400.00$1,949.00$1,559.00$7,451.0020.73% E101-43000-304 Legal Services$0.00$0.00$0.00$0.000.00% E101-43000-305 Medical Services$1,200.00$357.75$49.95$842.2529.81% E101-43000-309 Software Support & Maintenance$1,900.00$0.00$0.00$1,900.000.00% E101-43000-317 Employee Training$1,700.00$0.00$0.00$1,700.000.00% E101-43000-319 Other Services$13,200.00$1,131.16$1,079.81$12,068.848.57% E101-43000-321 Telephone$4,800.00$1,411.92$397.11$3,388.0829.42% E101-43000-331 Travel Expenses$500.00$0.00$0.00$500.000.00% E101-43000-334 Licenses & Permits$500.00$173.25$0.00$326.7534.65% E101-43000-361 Liability/Property Ins$9,300.00$0.00$0.00$9,300.000.00% E101-43000-365 Insurance Claims$0.00$0.00$0.00$0.000.00% E101-43000-381 Utilities-Electric & Gas$3,200.00$3,493.83$1,528.98($293.83)109.18% E101-43000-384 Refuse/Garbage Disposal$900.00$515.31$77.39$384.6957.26% E101-43000-385 Sewer Pumping & Maintenance$800.00$555.80$0.00$244.2069.48% E101-43000-387 Street Light Utilities$4,000.00$1,545.88$421.47$2,454.1238.65% E101-43000-401 Building Maintenance/Repairs$5,500.00$797.03$272.97$4,702.9714.49% E101-43000-403 Improvements Other Than Bldgs$0.00$0.00$0.00$0.000.00% E101-43000-404 Repair Machinery/Equipment$14,000.00$313.25$0.00$13,686.752.24% April MTD 2022 YTD % of 2022 BudgetYTD AmountAmountBalanceBudget E101-43000-405 Contractual Road Maint/Repair$150,000.00$0.00$0.00$150,000.000.00% E101-43000-407 Well Repair & Maintenance$0.00$0.00$0.00$0.000.00% E101-43000-413 Equipment Rental$3,500.00$45.10$0.00$3,454.901.29% E101-43000-417 Uniform Rental$1,000.00$246.10$92.58$753.9024.61% E101-43000-433 Dues and Subscriptions$200.00$0.00$0.00$200.000.00% E101-43000-438 Misc. Contractual$15,000.00$0.00$0.00$15,000.000.00% E101-43000-439 Refunds Issued$0.00$0.00$0.00$0.000.00% E101-43000-530 Capital Impr Other Than Bldgs$0.00$1,178.00$1,178.00($1,178.00)0.00% E101-43000-550Motor Vehicles Capital$0.00$0.00$0.00$0.000.00% E101-43000-560 Furniture and Fixtures$0.00$0.00$0.00$0.000.00% E101-43000-570 Office Equipment$3,300.00$0.00$0.00$3,300.000.00% Parks E101-45000-101 Regular Wages & Salaries$9,800.00$2,326.30$734.38$7,473.7023.74% E101-45000-104Temporary Employee Wages$29,100.00$6,766.13$0.00$22,333.8723.25% E101-45000-121 PERA Coord. Employer Contribu.$700.00$173.02$55.08$526.9824.72% E101-45000-122 FICA Employer Contribution$2,600.00$541.88$43.17$2,058.1220.84% E101-45000-126 MEDICARE Employer Contribution$600.00$143.72$10.09$456.2823.95% E101-45000-131 Employer Paid Health$2,100.00$1,042.04$260.93$1,057.9649.62% E101-45000-132 Dental Insurance$100.00$12.08$3.02$87.9212.08% E101-45000-134 Employer Paid Life$0.00$47.92$11.98($47.92)0.00% E101-45000-135 Employer Paid Disability$1,000.00$124.20$31.05$875.8012.42% E101-45000-141 Unemployment 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.86)132.06% E101-45000-200 Office Supplies$300.00$0.00$0.00$300.000.00% E101-45000-203 Printed Forms & Papers$900.00$0.00$0.00$900.000.00% E101-45000-210 Operating Supplies$900.00$219.33$155.00$680.6724.37% E101-45000-212Fuel$1,500.00$450.77$0.00$1,049.2330.05% E101-45000-221 Equipment Parts$2,000.00$0.00$0.00$2,000.000.00% E101-45000-223 Structure Repair & Supplies$500.00$0.00$0.00$500.000.00% E101-45000-240 Small Tools and Minor Equip$0.00$359.90$0.00($359.90)0.00% E101-45000-312 Planning Services$0.00$0.00$0.00$0.000.00% E101-45000-313Committee & Commission Reimbur$1,200.00$240.00$0.00$960.0020.00% E101-45000-319 Other Services$0.00$121.60$121.60($121.60)0.00% E101-45000-322 Postage$0.00$0.00$0.00$0.000.00% E101-45000-340Advertising$0.00$180.00$0.00($180.00)0.00% E101-45000-353 Sales& Use Tax$0.00$0.00$0.00$0.000.00% E101-45000-361 Liability/Property Ins$7,100.00$0.00$0.00$7,100.000.00% E101-45000-381 Utilities-Electric & Gas$4,000.00$2,581.86$1,109.51$1,418.1464.55% E101-45000-384 Refuse/Garbage Disposal$1,900.00$755.00$115.00$1,145.0039.74% E101-45000-385 Sewer Pumping & Maintenance$500.00$142.97$142.97$357.0328.59% E101-45000-401 Building Maintenance/Repairs$6,000.00$287.98$0.00$5,712.024.80% E101-45000-403 Improvements Other Than Bldgs$0.00$1,486.49$0.00($1,486.49)0.00% E101-45000-404 Repair Machinery/Equipment$700.00$100.00$0.00$600.0014.29% E101-45000-406 Grounds Care$4,000.00$0.00$0.00$4,000.000.00% April MTD 2022 YTD % of 2022 BudgetYTD AmountAmountBalanceBudget E101-45000-438 Misc. Contractual$3,000.00$0.00$0.00$3,000.000.00% E101-45000-439 Refunds Issued$0.00$0.00$0.00$0.000.00% E101-45000-440Events$3,000.00$5,942.65$0.00($2,942.65)198.09% E101-45000-490 Financial Assistance$0.00$0.00$0.00$0.000.00% E101-45000-530 Capital Impr Other Than Bldgs$10,000.00$0.00$0.00$10,000.000.00% Community Center E101-45180-101 Regular Wages & Salaries$14,400.00$4,405.42$1,191.35$9,994.5830.59% E101-45180-104Temporary Employee Wages$0.00$0.00$0.00$0.000.00% E101-45180-121 PERA Coord. Employer Contribu.$1,100.00$320.46$80.31$779.5429.13% E101-45180-122 FICA Employer Contribution$900.00$252.87$70.36$647.1328.10% E101-45180-126 MEDICARE Employer Contribution$200.00$68.27$16.46$131.7334.14% E101-45180-131 Employer Paid Health$3,100.00$1,014.17$242.10$2,085.8332.72% E101-45180-134 Employer Paid Life$0.00$15.60$3.90($15.60)0.00% E101-45180-135 Employer Paid Disability$100.00$45.76$11.44$54.2445.76% E101-45180-151 Worker sComp Insurance Prem$0.00$0.00$0.00$0.000.00% E101-45180-210 Operating Supplies$2,800.00$319.75$27.16$2,480.2511.42% E101-45180-223 Structure Repair & Supplies$6,500.00$8.77$0.00$6,491.230.13% E101-45180-334 Licenses & Permits$900.00$737.00$0.00$163.0081.89% E101-45180-361 Liability/Property Ins$2,300.00$0.00$0.00$2,300.000.00% E101-45180-381 Utilities-Electric & Gas$10,600.00$4,679.13$1,231.33$5,920.8744.14% E101-45180-384 Refuse/Garbage Disposal$1,800.00$497.34$153.42$1,302.6627.63% E101-45180-385 Sewer Pumping & Maintenance$3,500.00$1,575.81$410.18$1,924.1945.02% E101-45180-401 Building Maintenance/Repairs$13,000.00$2,855.23$668.83$10,144.7721.96% E101-45180-404 Repair Machinery/Equipment$3,000.00$0.00$0.00$3,000.000.00% E101-45180-406 Grounds Care$650.00$0.00$0.00$650.000.00% E101-45180-407 Well Repair & Maintenance$600.00$345.00$0.00$255.0057.50% E101-45180-438 Misc. Contractual$2,500.00$0.00$0.00$2,500.000.00% E101-45180-439 Refunds Issued$0.00$0.00$0.00$0.000.00% E101-45180-520 Capital Improvements toBldgs$6,000.00$1,999.00$0.00$4,001.0033.32% E101-45180-530 Capital Impr Other Than Bldgs$0.00$0.00$0.00$0.000.00% E101-45180-570 Office Equipment$0.00$0.00$0.00$0.000.00% General Fund Expenditure Totals$1,885,300.00$442,399.09$117,557.74$1,442,900.9123.47% Operating Transfers E101-49000-720Operating Transfers$0.00$10,000.00$10,000.00($10,000.00) 05/10/22 3:11PMCITYOFSCANDIA Page 1MonthlyRevenue - Expense Report 2022April2022 Account DescrBudget2022 AmtYTD Amt Fund 602 BIG MARINE SEWER Dept 43210 Sewer E 602-43210-101 Regular Wages & Salaries$21,600.00$1,634.49$6,638.90 E 602-43210-102 OT Regular Wages$0.00$0.00$0.00 E 602-43210-120 Pension Expense$0.00$0.00$0.00 E 602-43210-121 PERA Coord. Employer Contribu.$1,600.00$122.61$496.91 E602-43210-122 FICA Employer Contribution$1,300.00$96.13$381.57 E602-43210-126 MEDICARE Employer Contribution$300.00$22.48$102.12 E 602-43210-131 Employer Paid Health$0.00$0.00$0.00 E 602-43210-151 Worker sComp Insurance Prem$900.00$0.00$1,180.37 E 602-43210-200 Office Supplies$200.00$85.00$85.00 E 602-43210-210 Operating Supplies$2,400.00$77.00$78.99 E 602-43210-240 Small Tools and Minor Equip$550.00$0.00$0.00 E 602-43210-303 Engineering Fees$10,400.00$2,469.50$2,889.50 E 602-43210-304 Legal Services$0.00$2,400.00$2,400.00 E 602-43210-308 Other Professional Services$2,200.00$0.00$766.00 E 602-43210-309 Software Support & Maintenance$1,200.00$0.00$0.00 E 602-43210-311 Contract Permit Inspections$0.00$0.00$0.00 E 602-43210-317 Employee Training$1,400.00$572.84$572.84 E 602-43210-321 Telephone$2,100.00$191.39$681.38 E 602-43210-322 Postage$550.00$0.00$200.00 E 602-43210-331 Travel Expenses$200.00$157.95$157.95 E 602-43210-334 Licenses & Permits$1,600.00$505.00$722.00 E602-43210-351 Legal Notices Publishing$0.00$0.00$0.00 E 602-43210-353 Sales& Use Tax$0.00$0.00$0.00 E 602-43210-361 Liability/Property Ins$900.00$0.00$0.00 E 602-43210-381 Utilities-Electric & Gas$2,500.00$220.31$637.64 E 602-43210-385 Sewer Pumping & Maintenance$11,000.00$0.00$0.00 E 602-43210-386 Operation & Maintenance$5,000.00$0.00$0.00 E 602-43210-404 Repair Machinery/Equipment$16,000.00$0.00$0.00 E 602-43210-413 Equipment Rental$350.00$0.00$0.00 E 602-43210-420 Depreciation Expense$52,200.00$0.00$0.00 E 602-43210-438 Misc. Contractual$9,000.00$0.00$0.00 E 602-43210-439 Refunds Issued$0.00$0.00$0.00 E 602-43210-530 Capital Impr Other Than Bldgs$79,612.00$3,278.00$21,578.00 E 602-43210-570 Office Equipment$0.00$0.00$0.00 E 602-43210-720 Operating Transfers$0.00$0.00$0.00 Dept 43210 Sewer$225,062.00$11,832.70$39,569.17 Fund 602 BIG MARINE SEWER$225,062.00$11,832.70$39,569.17 Fund 612 UPTOWN SEWER Dept 43210 Sewer E 612-43210-101 Regular Wages & Salaries$9,300.00$708.07$2,929.32 E 612-43210-102 OT Regular Wages$0.00$0.00$0.00 E 612-43210-120 Pension Expense$0.00$0.00$0.00 E612-43210-121 PERA Coord. Employer Contribu.$700.00$53.11$219.36 E612-43210-122 FICA Employer Contribution$600.00$41.67$169.96 E612-43210-126 MEDICARE Employer Contribution$100.00$9.75$43.66 E 612-43210-131 Employer Paid Health$0.00$0.00$0.00 E612-43210-151 Worker sComp Insurance Prem$0.00$0.00$295.09 05/10/22 3:11PMCITYOFSCANDIA Page 2 Monthly Revenue - Expense Report 2022April2022 Account DescrBudget2022 AmtYTD Amt E 612-43210-200 Office Supplies$100.00$0.00$0.00 E 612-43210-210 Operating Supplies$200.00$0.00$0.00 E 612-43210-221 Equipment Parts$200.00$0.00$0.00 E 612-43210-240 Small Tools and Minor Equip$0.00$0.00$0.00 E 612-43210-303 Engineering Fees$300.00$0.00$0.00 E 612-43210-304 Legal Services$0.00$0.00$0.00 E 612-43210-308 Other Professional Services$400.00$162.00$162.00 E 612-43210-309 Software Support & Maintenance$0.00$0.00$0.00 E 612-43210-311 Contract Permit Inspections$0.00$0.00$0.00 E 612-43210-317 Employee Training$350.00$0.00$0.00 E 612-43210-319 Other Services$0.00$0.00$0.00 E 612-43210-322 Postage$0.00$0.00$0.00 E 612-43210-334 Licenses & Permits$400.00$0.00$217.00 E 612-43210-351 Legal Notices Publishing$0.00$0.00$0.00 E 612-43210-353 Sales& Use Tax$0.00$0.00$0.00 E 612-43210-361 Liability/Property Ins$300.00$0.00$0.00 E 612-43210-381 Utilities-Electric & Gas$1,700.00$80.33$75.54 E 612-43210-385 Sewer Pumping & Maintenance$1,200.00$0.00$0.00 E 612-43210-386 Operation & Maintenance$600.00$0.00$0.00 E 612-43210-404 Repair Machinery/Equipment$1,500.00$0.00$0.00 E 612-43210-420 Depreciation Expense$55,100.00$0.00$0.00 E 612-43210-438 Misc. Contractual$1,200.00$0.00$0.00 E 612-43210-530 Capital Impr Other Than Bldgs$2,600.00$0.00$0.00 E 612-43210-570 Office Equipment$0.00$0.00$0.00 E 612-43210-603 Short-Term Debt Principal$0.00$0.00$0.00 E 612-43210-720 Operating Transfers$0.00$0.00$0.00 Dept 43210 Sewer$76,850.00$1,054.93$4,111.93 Fund 612 UPTOWN SEWER$76,850.00$1,054.93$4,111.93 301,912.00$12,887.63$43,681.10 ActType\]="E"))) AND (\[Fund\] In ("602","612"))