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 2023
CityofScandiaaug Treasurer’sReport 8/31/2023 FUNDACCOUNTING BeginningCashBalance $ 3,773,222.378/1/2023 BeginningCheckingBalance$ 578,398.76 CheckingReceipts 48,388.20TransferstoChecking 230,000.00 TotalDeposits 278,388.20 Expenditures$ (191,136.94) Payroll$ (64,467.08) Transfer toEDAinTransit TotalPayments 255,604.02) EndingCheckingBalance 601,182.94 BeginngingMoneyMarketBalance 1,594,855.76 MoneyMarketReceipts 1,559.26 TransfertoChecking TransferfromChecking 230,000.00) 0 EndingMoneyMarket Balance 1,366,415.02 BeginningInvestmentsBalance 2,071,824.23 InvestmentsReceipts EndingInvestmentsBalance$ 2,071,824.23 BeginningEDABalance$ 33,356.07EDAReceipts EDAExpenditures EDADe;positinTransit EDATransfersfromChecking EndingEDABalance$ 33,356.07 OutstandingChecks 507,215.35) 8/31/2023EndingCashBalance $ 3,565,562.91 CHECKING, MONEYMARKET & INVESTMENTCD's Checking *102$ 578,398.76BegBal Credits$ 278,388.20 Debits$ (255,604.02) TransferinTransit 601,182.94EndBal MoneyMarket *105 - Rate1.25%$ 1,594,855.76BegBal ratechangefrom .25% Credits 1,559.26 Debits 230,000.00) EndBal$ 1,366,415.02 Investments CD *4422 - Rate4.00% 12mo., 3/25/2024 **NEWRATE$ 321,022.05 CD *4424 - Rate4.50% 12mo., 7/27/2024 **NEWRATE$ 452,464.63 CD *4425 - Rate2.875% 12mo., 9/28/2023 $ 750,221.77 CD *4426 - Rate3.50%% 12mo., 1/29/2024 548,115.78 TotalInvestments$ 2,071,824.23 TotalBank & InvestmentAccounts 4,039,422.19 507,215.35) ChecksinTransit *3102 TransfertoEDAinTransit Depositintransitmoneymarket 3,532,206.84TotalAdjustedUndesignatedFunds ScandiaEDA *6301 $ 33,356.07Receipts Expenditures ChecksinTransit DepositinTransit TotalDesignatedEDAFunds$ 33,356.07 TotalFunds$ 3,565,562.91 Submittedby: ColleenFirkus, Treasurer 2023 CASH BALANCES END OFMONTH FUNDJANUARYFEBRUARYMARCHAPRILMAYJUNEJULYAUGUST 101GENERAL$1,365,932$1,204,052$1,078,538$925,847$839,539$1,564,703$1,423,907539,283.54 203COVID-19RELIEF$456,363$456,363$456,363$456,363$456,363$456,363456,362.62$ 456,362.62 226CABLETV$11,271$12,786$9,481$11,524$13,529$12,551$14,34614,106.51 230GATEWAY TRAIL$0$0$0$0$0$0$0$0 307BLACKTOPPROJECT 2007$6,731$0$0$0$0$0$0$0 313EQUIPMENT CERTIFICATES$28,825$28,873$28,873$28,873($32,057)$ (32,056.76) ($57)($57) 315EQUIPMENT CERTIFICATES$15,951$0$0$0$0$0$0$0 317EQUIPMENT CERTIFICATES$2,187$0$0$0$0$0$0$0 318BLACKTOPPROJECT$20,270$45,284$45,284($823)($823)$ (823.23) $170,445$170,445 401CAPITAL IMPR$749,162$749,497$745,297$668,380$665,980$ 663,579.71$861,809$848,700 404PARKCAPIMPR$148,177$148,797$148,797$144,297$144,297$ 145,898.33$158,898$151,178 406EQUIPMENTREPLACEMENT$199,727$200,548$200,548$200,548$200,548$ 200,548.37$200,548$200,548 408LOCALROADIMPROVEMENT$916,080$910,085$901,556$895,518$893,593$ 744,491.50$187,297$145,243 602BIGMARINESEWER$80,462$74,771$75,858$58,322$49,682$ 60,689.30$68,166$57,261 612UPTOWNSEWER$10,330$15,160$13,957$12,136$15,967$ 15,833.56$15,646$16,190 801ESCROW$21,817$32,240$24,131$35,421$37,650$ 32,645.90$43,496$48,082 SUBTOTAL$4,033,286$3,878,456$3,728,684$3,436,405$3,284,269$2,840,559$3,739,866$3,532,207 225EDA$33,356$33,356$33,356$33,356$33,356$ 33,356.07$ 33,356.07$33,356 TOTAL$4,066,642$3,911,812$3,762,040$3,469,761$3,317,625$2,873,915$3,773,222$3,565,563 CITYOFSCANDIA Revenue - ExpenditureSummary August2023 2023YTD August Budget Description2023 BudgetAmountAmountBalance% ofBudgetComments GENERALFUND RevenueR101-41000-31000 Washington Cty. TaxSettlement$1,865,918$989,521$0$876,39753.03% R101-41000-31040 FiscalDisparities$0$86,949$0($86,949) R101-41000-31701 GravelTaxes$20,000$3,329$0$16,67116.65% R101-41000-31830 SolarEnergyProduction Tax$6,000$5,874$0$12697.89% R101-41000-31900 Penalties & Interest DelTax$400$52$0$34812.99% R101-41000-32150 ROWUtilityPermit$3,000$4,050$1,500($1,050)135.00% R101-41000-32180 Tobacco & LiquorLicenses$10,000$100$25$9,9001.00% R101-41000-32190 OtherCityPermits$3,000$1,545$250$1,45551.50% R101-41000-32210 BuildingPermits$145,000$108,189$14,086$36,81174.61% R101-41000-32260 Gambling Permits$100$45$15$5545.00% R101-41000-33401 LGA/MVHC/AG/PERAAid$7,000$0$0$7,0000.00% R101-41000-33420 FireReliefStatePERA$37,000$0$0$37,0000.00% R101-41000-33422 OtherStateGrants & Aids$11,000$9,053$0$1,94882.30%FireTraining grants R101-41000-33428 PILOT$6,000$3,108$0$2,89251.81% R101-41000-33620 Recycling Grant$10,500$8,165$0$2,33577.76% R101-41000-33630 LocalGovtGrants & Aids$0$0$0$0 R101-41000-33640 OtherGrants$1,200$0$0$1,2000.00% R101-41000-34103 ZoningandPlanning$6,700$6,946$750($246)103.67% R101-41000-34106 EngineeringFees$500$0$0$5000.00% R101-41000-34107 AssessmentSearchFees$0$5$0($5) R101-41000-34109 WaterUsage$100$0$0$1000.00% R101-41000-34201 Impound Fees$0$0$0$0 R101-41000-34202 FireProtection Services$32,300$32,300$0$0100.00% R101-41000-34301 DamageRepairs$0$0$0$0 R101-41000-34303 DustControl$2,700$3,524$0($824)130.54% R101-41000-34304 Reimbursement forServices$3,000$900$0$2,10030.00% R101-41000-34305 OtherStreetServices$0$0$0$0 R101-41000-34730 AdRevenue$0$900$0($900)0.00% R101-41000-34750 Facilities Rental$5,500$5,371$1,461$12997.65% R101-41000-34760 Cleaning Fees$100$0$0$1000.00% R101-41000-34790 RecreationPrograms$2,100$1,628$140$47277.54% R101-41000-35101 Fines & Forfeitures$7,400$4,543$618$2,85761.39% distributed amongfundsatEOYR101-41000-36210 Interest Income$12,100$40,960$1,564($28,860)338.51% Veterans Memorial Upkeep $1,090; Lions: VinterfestR101-41000-36230 Donations$2,000$5,792$1,601($3,792)289.62% Fireworks $2,000; SisterCity $250 R101-41000-36240 Insurance Dividend$4,100$0$0$4,1000.00% R101-41000-36250 Misc. Refund$3,800$4$0$3,7960.11% TotalGeneralFundRevenue$2,208,518$1,322,854$22,011$885,66459.90% OperatingTransfersR 101-41000-39200 Interfund OperatingTransfer$0$3,049$3,049($3,049)JEtomoveparkbenchdonation receipt R101-49000-39203 TransferfromOtherFunds$0$2,173,000$0($2,173,000) R101-49000-39204 Money MarketTransfer$0$585,000$230,000($585,000) TotalOperatingTransfers$2,761,049$233,049($2,761,049) CITYOFSCANDIA Revenue - ExpenditureSummary August2023 2023YTD August Budget Description2023 BudgetAmountAmountBalance% ofBudgetComments GENERALFUND ExpenditureADMINISTRATION & FINANCE E101-41000-101 RegularWages & Salaries$192,700$80,688$20,180$112,01241.87% E101-41000-121 PERACoord. EmployerContribu.$13,400$3,449$1,513$9,95125.74% E101-41000-122 FICAEmployer Contribution$11,900$4,169$1,220$7,73135.03% E101-41000-126 MEDICAREEmployer Contribution$2,700$1,836$285$86468.02% E101-41000-131 Employer PaidHealth$47,300$24,190$3,198$23,11051.14% E101-41000-132 DentalInsurance$3,400$859$128$2,54125.26% E101-41000-134 Employer PaidLife$600$362$50$23860.32% E101-41000-135 Employer PaidDisability$900$629$72$27169.89% E101-41000-151 WorkersCompInsurancePrem$1,300$1,651$0($351)127.00% E101-41000-200 OfficeSupplies$1,100$165$0$93514.99% E101-41000-203 PrintedForms & Papers$1,900$1,530$0$37080.53% Awardframes; March10meetingsuppliesE101-41000-210 Operating Supplies$800$549$0$25168.65% E101-41000-300 Assessor$0$0$0$0 E101-41000-301 Auditing andAcctgServices$23,500$28,500$0($5,000)121.28% E101-41000-303 Engineering Fees$0$0$0$0 E101-41000-304 LegalServices$55,000$37,716$6,573$17,28468.58% E101-41000-306 PersonalTesting & Recruit$0$0$0$0 InterminCityAdminSalaryE101-41000-308 OtherProfessional Services$1,000$50,299$0($49,299)5029.92% E101-41000-309 SoftwareSupport & Maintenance$18,200$6,501$433$11,69935.72% E101-41000-314 Animal Control$0$0$0$0 E101-41000-316 Conferences & Seminars$700$30$0$6704.29% E101-41000-317 Employee Training$200$0$0$2000.00% E101-41000-319 OtherServices$46,700$586$0$46,1141.25% E101-41000-321 Telephone$3,700$3,332$422$36890.07% E101-41000-322 Postage$2,200$1,428$324$77264.90% E101-41000-331 TravelExpenses$600$1,033$0($433)172.23%reimburse cityadminapplicant E101-41000-351 LegalNotices Publishing$1,200$1,088$45$11290.69% E101-41000-361 Liability/Property Ins$7,100$10,967$0($3,867)154.47% E101-41000-365 InsuranceClaims$0$1,000$0($1,000) budgetforalldeptsinFund101E101-41000-381 Utilities-Electric & Gas$13,000$6,294$0$6,70648.42% E101-41000-413 Equipment Rental$1,900$1,388$295$51273.06% E101-41000-430 Recycling$30,100$0$0$30,1000.00% E101-41000-433 DuesandSubscriptions$6,100$157$0$5,9432.57% E101-41000-434 YouthService Bureau$5,500$5,500$0$0100.00% E101-41000-435 MiscExpense$500$0$0$5000.00% WebsiteHost; ABDOaccounting assistanceE101-41000-438 Misc. Contractual$4,000$3,236$0$76480.89% E101-41000-439 RefundsIssued$0$0$0$0 E101-41000-560 Furniture andFixtures$0$0$0$0 E101-41000-570 OfficeEquipment$5,500$1,873$287$3,62734.05% Total Admin & Finance Dept. Expenditures67.21% 284,000$190,864$11,826$93,136 CITYOFSCANDIA Revenue - ExpenditureSummary August2023 2023YTD August Budget Description2023 BudgetAmountAmountBalance% ofBudgetComments GENERALFUNDCONT.CITYCOUNCIL ExpendituresE 101-41110-101 RegularWages & Salaries$18,100$10,386$0$7,71457.38% E101-41110-122 FICAEmployer Contribution$1,100$176$0$92416.02% E101-41110-126 MEDICAREEmployer Contribution$300$99$0$20132.85% E101-41110-127 PERADefined$600$377$0$22362.86% E101-41110-151 WorkersCompInsurancePrem$100$95$0$595.00% E101-41110-308 OtherProfessional Services$0$0$0$0 E101-41110-316 Conferences & Seminars$700$350$0$35050.00% E101-41110-331 TravelExpenses$0$562$0($562) E101-41110-439 RefundsIssued$0$0$0$0 E101-41110-560 Furniture andFixtures$0$0$0$0 E101-41110-570 OfficeEquipment$0$0$0$0 TotalCityCouncilDept. Expenditures$20,900$12,045$0$8,85557.63% ELECTIONS ExpendituresE 101-41410-199 ElectionJudge$0$0$0$0 E101-41410-200 OfficeSupplies$0$0$0$0 E101-41410-203 PrintedForms & Papers$0$0$0$0 E101-41410-210 Operating Supplies$200$0$0$2000.00% E101-41410-351 LegalNotices Publishing$0$0$0$0 E101-41410-413 Equipment Rental$850$1,515$0($665)178.24%Wash. Cty. Equip. Maintenance Fee TotalElectionsDept. Expenditures$1,050$1,515$0($465)144.29% PLANNING & BUILDING ExpendituresE 101-41910-101 RegularWages & Salaries$59,600$38,763$6,392$20,83754.31% E101-41910-121 PERACoord. EmployerContribu.$4,200$2,273$479$1,92742.71% E101-41910-122 FICAEmployer Contribution$3,700$2,293$383$1,40751.64% E101-41910-126 MEDICAREEmployer Contribution$900$559$90$34152.14% E101-41910-131 Employer PaidHealth$20,000$10,530$1,367$9,47045.81% E101-41910-132 DentalInsurance$1,500$420$55$1,08024.36% E101-41910-134 Employer PaidLife$200$102$14$9844.00% E101-41910-135 Employer PaidDisability$500$268$35$50046.69% E101-41910-203 PrintedForms & Papers$600$0$0($44,322)0.00% E101-41910-311 ContractPermitInspections$50,000$44,922$4,522$10,16380.80% E101-41910-312 PlanningServices$50,000$39,837$5,867$48,15067.94% E101-41910-313 Committee & Commission Reimbur$5,000$1,850$0$5,00037.00% E101-41910-316 Conferences & Seminars$50$0$0($73)0.00% E101-41910-319 OtherServices$0$123$0($5,401)0.00% E101-41910-361 Liability/Property Ins$4,900$5,401$0$2,239110.22% E101-41910-438 Misc. Contractual$5,000$2,661$0$5,00053.22% E101-41910-439 RefundsIssued$200$0$0$2000.00% E101-41910-720 OperatingTransfers$0$0$0$00.00% TotalPlanning & BuildingDept. Expenditures$206,350$150,002$19,203$56,61672.69% ASSESSOR ExpendituresE 101-41960-300 Assessor$21,600$14,759$1,800$6,84168.33% POLICE ExpendituresE 101-42100-318 PoliceContract$168,499$84,250$0$84,24950.00% E101-42100-319 OtherServices$500$309$0$19161.87%2023CodeRedSystem TotalGFPoliceDept. Expenditures$168,999$84,559$0$84,44050.04% CITYOFSCANDIA Revenue - ExpenditureSummary August2023 2023YTD August Budget Description2023 BudgetAmountAmountBalance% ofBudgetComments GENERALFUNDCONT.FIRE ExpendituresE 101-42200-101 RegularWages & Salaries$147,200$102,469$24,911$44,73170% E101-42200-121 PERACoord. EmployerContribu.$0$0$0$0 E101-42200-122 FICAEmployer Contribution$9,100$5,920$1,351$3,18065% E101-42200-124 Police & FirePERA$3,600$6,187$1,158($2,587)172% E101-42200-126 MEDICAREEmployer Contribution$2,100$1,259$364$84160% E101-42200-134 Employer PaidLife$200$128$16$7264% E101-42200-135 Employer PaidDisability$700$0$0$7000% E101-42200-141 Unemployment Compensation$0$0$0$0 E101-42200-151 WorkersCompInsurancePrem$9,100$11,617$0($2,517)128% E101-42200-200 OfficeSupplies$400$174$0$22644% E101-42200-203 PrintedForms & Papers$150$0$0$1500% E101-42200-209 MedicalSupplies$3,000$3,804$582($804)127% Pagers $2,730; FireSuppression supplies $686; Cintas; E101-42200-210 Operating Supplies$8,000$6,458$2,267$1,54281% Dinners E101-42200-211 CleaningSupplies$100$0$0$1000% E101-42200-212 Fuel$3,500$3,153$357$34790% E101-42200-217 Uniforms & SafetyEquipment$10,000$4,524$90$5,47645% E101-42200-221 Equipment Parts$3,000$272$0$2,7289% E101-42200-222 Tires$0$0$0$0 E101-42200-223 Structure Repair & Supplies$2,000$400$31$1,60020% E101-42200-240 SmallToolsandMinorEquip$9,000$884$135$8,11610% SCBAUserExams + AnnualFitTestE101-42200-305 MedicalServices$3,500$4,610$0($1,110)132% E101-42200-306 PersonalTesting & Recruit$1,300$1,391$0($91)107% E101-42200-309 SoftwareSupport & Maintenance$17,000$8,979$558$8,02153% E101-42200-310 MedicalTraining$2,000$0$0$2,0000% E101-42200-316 Conferences & Seminars$250$0$0$2500% E101-42200-317 Employee Training$15,000$4,814$390$10,18632% E101-42200-319 OtherServices$500$0$0$5000% E101-42200-321 Telephone$6,800$3,934$530$2,86658% E101-42200-322 Postage$0$0$0$0 E101-42200-324 StateofMN-FireRelief$35,300$0$0$35,3000% E101-42200-325 CityMatch-FireRelief$0$0$0$0 E101-42200-331 TravelExpenses$1,500$1,693$0($193)113% E101-42200-334 Licenses & Permits$200$300$0($100)150% MNBoard ofFirefighter Training & Education License E101-42200-340 Advertising$0$0$0$0 E101-42200-361 Liability/Property Ins$6,500$6,989$0($489)108% E101-42200-381 Utilities-Electric & Gas$8,000$4,846($26)$3,15461% E101-42200-384 Refuse/Garbage Disposal$1,100$570$0$53052% E101-42200-385 SewerPumping & Maintenance$700$0$0$7000% E101-42200-401 BuildingMaintenance/Repairs$2,500$2,119$228$38185%Cleaning, PestControl, Glassdoorrepair E101-42200-403 Improvements OtherThanBldgs$0$0$0$0 E101-42200-404 RepairMachinery/Equipment$8,000$5,636$781$2,36470% E101-42200-407 WellRepair & Maintenance$0$0$0$0 E101-42200-433 DuesandSubscriptions$2,400$3,215$0($815)134%Truckinspectionrenewal $1,685 E101-42200-438 Misc. Contractual$4,100$2,685$1,605$1,41565% E101-42200-440 Events$800$107$107$69313% E101-42200-520 CapitalImprovements toBldgs$0$0$0$0 E101-42200-530 CapitalImprOtherThanBldgs$0$0$0$0 E101-42200-540 HeavyMachineryCapital$0$0$0$0 E101-42200-560 Furniture andFixtures$500$236$0$26447% E101-42200-570 OfficeEquipment$900$180$0$72020% TotalFireDeptExpenditures$330,000$199,553$35,435$130,44760.47% ANIMAL CONTROL ExpendituresE 101-42700-314 Animal Control$5,000$3,551$491$1,44971.02% CITYOFSCANDIA Revenue - ExpenditureSummary August2023 2023YTD August Budget Description2023 BudgetAmountAmountBalance% ofBudgetComments GENERALFUNDCONT.PUBLICWORKS ExpendituresE 101-43000-101 RegularWages & Salaries$229,700$144,009$24,143$85,69163% E101-43000-102 OTRegularWages$5,000$4,915$304$8598% E101-43000-104 Temporary Employee Wages$2,300$4,163$0($1,863)181%snowplowing E101-43000-121 PERACoord. EmployerContribu.$17,600$11,139$1,833$6,46163% E101-43000-122 FICAEmployer Contribution$14,600$8,787$1,454$5,81360% E101-43000-126 MEDICAREEmployer Contribution$3,400$2,253$340$1,14766% E101-43000-131 Employer PaidHealth$70,900$42,077$4,860$28,82359% E101-43000-132 DentalInsurance$2,300$793$88$1,50734% E101-43000-134 Employer PaidLife$700$460$46$24066% E101-43000-135 Employer PaidDisability$1,700$1,218$128$48272% E101-43000-141 Unemployment Compensation$0$0$0$0 E101-43000-151 WorkersCompInsurancePrem$19,800$25,977$0($6,177)131% E101-43000-200 OfficeSupplies$600$54$0$5469% E101-43000-210 Operating Supplies$8,400$6,944$2,041$1,45683% E101-43000-212 Fuel$20,000$18,389$1,481$1,61192% E101-43000-217 Uniforms & SafetyEquipment$2,200$1,014$0$1,18646% plowrepairpartsE101-43000-221 Equipment Parts$14,000$13,218$1,758$78294% E101-43000-222 Tires$7,500$0$0$7,5000% E101-43000-223 Structure Repair & Supplies$2,200$56$56$2,1443% E101-43000-224 MaterialsforRoadMaintenance$16,500$2,738$0$13,76217% E101-43000-226 SignReplacement andRepair$0$174$0($174) E101-43000-228 Gravel$10,000$6,863$0$3,13769% snow, snow & snowE101-43000-229 Salt$20,000$18,093$0$1,90790% E101-43000-240 SmallToolsandMinorEquip$8,000$3,851$80$4,14948% E101-43000-302 Surveying$0$0$0$0 E101-43000-303 Engineering Fees$10,000$12,294$2,495($2,294)123%Gen. Eng. & Crackfilling & sealcoatfees E101-43000-304 LegalServices$0$0$0$0 E101-43000-305 MedicalServices$1,200$272$172$92823% IWORQsubscription; GISmapupdatesE101-43000-309 SoftwareSupport & Maintenance$2,000$7,784$0($5,784)389% E101-43000-317 Employee Training$1,700$1,010$0$69059% E101-43000-319 OtherServices$13,600$3,943$12$9,65729% E101-43000-321 Telephone$3,000$2,686$351$31490% E101-43000-331 TravelExpenses$500$0$0$5000% E101-43000-334 Licenses & Permits$500$10$10$4902% E101-43000-361 Liability/Property Ins$9,000$8,348$0$65293% E101-43000-365 InsuranceClaims$0$0$0$0 E101-43000-381 Utilities-Electric & Gas$4,000$3,449$15$55186% E101-43000-384 Refuse/Garbage Disposal$1,000$440$0$56044% E101-43000-385 SewerPumping & Maintenance$1,600$0$0$1,6000% E101-43000-387 StreetLightUtilities$4,200$2,700$220$1,50064% E101-43000-401 BuildingMaintenance/Repairs$8,000$2,230$296$5,77028% E101-43000-403 Improvements OtherThanBldgs$0$0$0$0 plowtruckrepairsE101-43000-404 RepairMachinery/Equipment$15,500$15,643$0($143)101% Streetlightrepair $3,422; Patching $10,488, DustControlE101-43000-405 Contractual RoadMaint/Repair$157,500$106,305$15,240$51,19567% 21,900; CrackFill & SealCoat $150,824movedtoLRIF E101-43000-407 WellRepair & Maintenance$0$0$0$0 E101-43000-413 Equipment Rental$4,000$0$0$4,0000% E101-43000-417 UniformRental$1,100$615$103$48556% E101-43000-433 DuesandSubscriptions$200$0$0$2000% E101-43000-438 Misc. Contractual$15,750$1,800$0$13,95011% E101-43000-439 RefundsIssued$0$0$0$0 E101-43000-530 CapitalImprOtherThanBldgs$0$0$0$0 E101-43000-550 MotorVehicles Capital$0$0$0$0 E101-43000-560 Furniture andFixtures$0$0$0$0 E101-43000-570 OfficeEquipment$1,000$407$0$59341% E101-43000-720 OperatingTransfers$0$0$0$0 TotalPublicWorksDept. Expenditures$732,750$487,119$57,527$245,63166.48% CITYOFSCANDIA Revenue - ExpenditureSummary August2023 2023YTD August Budget Description2023 BudgetAmountAmountBalance% ofBudgetComments GENERALFUNDCONT.PARKS & RECREATION ExpendituresE 101-45000-101 RegularWages & Salaries$10,200$5,072$1,023$5,12849.72% E101-45000-104 Temporary Employee Wages$40,200$19,368$5,381$20,83248.18% E101-45000-121 PERACoord. EmployerContribu.$800$377$77$42347.16% E101-45000-122 FICAEmployer Contribution$3,300$1,476$394$1,82444.72% E101-45000-126 MEDICAREEmployer Contribution$800$373$92$42746.57% E101-45000-131 Employer PaidHealth$2,700$1,446$185$1,25453.57% E101-45000-132 DentalInsurance$100$29$3$7128.80% E101-45000-134 Employer PaidLife$0$18$2($18) E101-45000-135 Employer PaidDisability$1,000$41$5$9594.13% E101-45000-141 Unemployment Compensation$0$0$0$0 E101-45000-151 WorkersCompInsurancePrem$1,900$2,615$0($715)137.61% E101-45000-200 OfficeSupplies$310$0$0$3100.00% E101-45000-203 PrintedForms & Papers$930$0$0$9300.00% E101-45000-210 Operating Supplies$930$613$34$31765.95% E101-45000-212 Fuel$1,650$230$0$1,42013.93% E101-45000-221 Equipment Parts$2,100$865$575$1,23541.21% E101-45000-223 Structure Repair & Supplies$2,100$1,092$0$1,00951.98% E101-45000-240 SmallToolsandMinorEquip$400$0$0$4000.00% E101-45000-312 PlanningServices$0$0$0$0 E101-45000-313 Committee & Commission Reimbur$1,200$540$0$66045.00% E101-45000-319 OtherServices$0$284$0($284) E101-45000-322 Postage$0$0$0$0 SCVRTA 2023AdE101-45000-340 Advertising$200$250$0($50)125.00% E101-45000-353 Sales& UseTax$0$0$0$0 E101-45000-361 Liability/Property Ins$3,300$3,323$0($23)100.70% E101-45000-381 Utilities-Electric & Gas$4,500$3,606$593$89480.13% E101-45000-384 Refuse/Garbage Disposal$2,500$2,499$499$199.96% E101-45000-385 SewerPumping & Maintenance$700$712$0($12)101.78%WarmingHouse icemeltproductE101-45000-401 BuildingMaintenance/Repairs$4,800$3,583$150$1,21774.64% E101-45000-403 Improvements OtherThanBldgs$0$421$250($421) E101-45000-404 RepairMachinery/Equipment$750$281$0$46937.41% E101-45000-406 GroundsCare$4,000$2,144$0$1,85653.61% E101-45000-438 Misc. Contractual$3,300$1,780$340$1,52053.94% E101-45000-439 RefundsIssued$0$565$0($565) VinterfestE101-45000-440 Events$7,000$2,394$0$4,60634.20% E101-45000-490 Financial Assistance$0$0$0$0 E101-45000-530 CapitalImprOtherThanBldgs$10,000$0$0$10,0000.00% E101-45000-720 OperatingTransfers$0$0$0$0 TotalParks & RecDept. Expenditures$111,670$55,997$9,605$55,67350.14% CITYOFSCANDIA Revenue - ExpenditureSummary August2023 2023YTD August Budget Description2023 BudgetAmountAmountBalance% ofBudgetComments GENERALFUNDCONT.COMMUNITY CENTER ExpendituresE 101-45180-101 RegularWages & Salaries$15,000$9,089$1,386$5,91160.60% E101-45180-104 Temporary Employee Wages$0$0$0$0 E101-45180-121 PERACoord. EmployerContribu.$1,100$670$104$43060.94% E101-45180-122 FICAEmployer Contribution$900$529$82$37158.77% E101-45180-126 MEDICAREEmployer Contribution$200$133$19$6766.61% E101-45180-131 Employer PaidHealth$3,700$1,861$256$1,83950.29% E101-45180-134 Employer PaidLife$0$26$2($26) E101-45180-135 Employer PaidDisability$200$81$10$11940.74% E101-45180-151 WorkersCompInsurancePrem$0$0$0$0 E101-45180-210 Operating Supplies$2,900$1,876$138$1,02464.68% E101-45180-223 Structure Repair & Supplies$6,500$147$73$6,3532.26% E101-45180-334 Licenses & Permits$1,000$792$0$20879.20% E101-45180-361 Liability/Property Ins$800$796$0$499.45% E101-45180-381 Utilities-Electric & Gas$11,200$6,480$465$4,72057.85% E101-45180-384 Refuse/Garbage Disposal$1,900$1,502$180$39879.04% E101-45180-385 SewerPumping & Maintenance$3,700$2,378$0$1,32264.27% RemoveicefromCommCtrroofE101-45180-401 BuildingMaintenance/Repairs$15,000$11,217$975$3,78374.78% E101-45180-404 RepairMachinery/Equipment$5,000$2,260$1,111$2,74045.20% E101-45180-406 GroundsCare$690$0$0$6900.00% E101-45180-407 WellRepair & Maintenance$1,000$0$0$1,0000.00% Helke'swinterlightingworkE101-45180-438 Misc. Contractual$2,700$1,500$0$1,20055.56% E101-45180-439 RefundsIssued$0$450$0($450) CouncilChambersremodelE101-45180-520 CapitalImprovements toBldgs$6,000$7,476$0($1,476)124.59% E101-45180-530 CapitalImprOtherThanBldgs$0$0$0$0 E101-45180-570 OfficeEquipment$0$0$0$0 E101-45180-720 OperatingTransfers$0$0$0$0 TotalCommunity CenterDept. Expenditures$64,490$36,808$3,492$27,68257.08% TOTALGENERALFUNDEXPENDITURES$2,182,509$1,339,417$163,886$843,09261.37% OperatingTransfersE 101-49000-720 OperatingTransfers TOTALGENERAL FUNDEXPENDITURES W/TRANSFERS$2,182,809$4,097,417$393,886($1,914,908) CITYOFSCANDIA Revenue - ExpenditureSummary August2023 2023YTD August Budget Description2023 BudgetAmountAmountBalance% ofBudgetComments COVIDRELIEFFUND RevenueR 203-46200-33150 FederalGrant$0$0$0$00.00% ExpendituresE 203-49000-720Operating Transfers$0$0$0$0 EDAFUND RevenueR225-46500-31000 Washington Cty. TaxSettlement$5,300$2,650$2,650$2,65050.00% R225-46500-33640 OtherGrants$0$0$0$00.00% R225-46500-34750 Facilities Rental$0$0$0$00.00% R225-46500-36210 Interest Income$200$0$0$2000.00% R225-46500-36230 Donations$0$0$0$00.00% R225-46500-39203 TransferfromOtherFunds$0$3,525$0($3,525)0.00% transfer ofproperty taxsettlement from checking TotalEDAFundRevenue$5,500$6,175$2,650($675)112.27% ExpenditureE 225-46500-210 Operating Supplies$500$3,525$0($3,025)704.99% E225-46500-303 Engineering Fees$0$0$0$0 E225-46500-304 LegalServices$0$0$0$0 E225-46500-308 OtherProfessional Services$300$0$0$3000.00% E225-46500-340 Advertising$2,000$645$0$1,35532.25% EDAMMembership; SisterCityDuesE225-46500-433 DuesandSubscriptions$1,700$1,168$0$53268.71% E225-46500-440 Events$800$580$0$22072.50% E225-46500-720 OperatingTransfers$0$0$0$0 TotalEDAFundExpenditures$5,300$2,393$0($618)45.15% CABLETVFUND RevenueR 226-41950-36210 Interest Income$100$0$0$1000.00% R226-41950-36260 SaleofEquipment$0$300$0($300) R226-41950-38050 CableTVFranchiseRebates$16,200$11,787$1,707$4,41372.76% R226-41950-38051 PEGFees$4,200$3,158$458$1,04275.20% TotalCableTVFundRevenue$20,500$15,246$2,164$5,25474.37% ExpenditureE 226-41950-240 Small ToolsandMinorEquip$300$604$11($304)201.42% E226-41950-309 SoftwareSupport & Maintenance$3,500$2,556$358$94473.03% E226-41950-438 Misc. Contractual$5,300$4,989$0$31194.13% E226-41950-570 OfficeEquipment$0$4,129$0($4,129) TotalCableTVFundExpenditures$9,100$12,278$369($3,178)134.93% GATEWAYTRAILFUND RevenueR230-45000-36230 Donations$0$0$0$00.00% ExpenditureE 230-45000-308 Other Professional Services$0$0$0$00.00% 2013EQUIPMENT CERTIFICATES RevenueR313-47000-31000 Washington Cty. TaxSettlement$64,000$32,000$32,000$32,0000.00% ExpenditureE 313-47000-601 LongTermDebtPrincipal$60,000$60,000$0$0100.00% E313-47000-611 LongTermDebtInterest$3,047$930$0$2,11730.52% E313-47000-620 FiscalAgentsFees$500$0$0$5000.00% Total2013FundExpenditures$63,547$60,930$0$2,61795.88% 2018STREETRECONSTRUCTION RevenueR318-47000-31000 Washington Cty. TaxSettlement$342,546$171,268$171,268$171,27850.00% ExpenditureE 318-47000-601 LongTermDebtPrincipal$250,000$0$0$250,0000.00% E318-47000-611 LongTermDebtInterest$91,225$45,613$0$45,61250.00% E318-47000-620 FiscalAgentsFees$500$495$0$599.00% Total2018StreetReconstruction FundExpenditures$341,725$46,108$0$295,61713.49% CITYOFSCANDIA Revenue - ExpenditureSummary August2023 2023YTD August Budget Description2023 BudgetAmountAmountBalance% ofBudgetComments CAPITALIMPROVEMENTS RevenueR401-48000-31000 Washington Cty. TaxSettlement$293,791$146,895$0$146,89650.00% R401-48000-33422 OtherStateGrants & Aids$0$56,232$0($56,232) R401-48000-36210 Interest Income$2,300$0$0$2,3000.00% TotalCapitalImprovement FundRevenue$296,091$203,127$0$92,96468.60% ExpenditureE 401-41000-312 Planning Services$0$0$0$0 E401-41000-520 CapitalImprovements toBldgs$0$0$0$0 E401-41000-530 CapitalImprOtherThanBldgs$169,500$0$0$169,5000.00% E401-42200-520 CapitalImprovements toBldgs$65,000$90,034$16,259($25,034)138.51%Generator E401-48000-303 Engineering Fees$0$8,130$3,090($8,130)GatewayTrailEngineering E401-48000-308 OtherProfessional Services$0$19,200$2,400($19,200)GatewayTrailLobbying E401-48000-312 PlanningServices$0$0$0$0 E401-48000-435 MiscExpense$0$0$0$0 E401-48000-438 Misc. Contractual$0$0$0$0 E401-48000-520 CapitalImprovements toBldgs$0$0$0$0 E401-48000-530 CapitalImprOtherThanBldgs$100,000$0$0$100,0000.00% 334,500$117,364$21,749$217,13635.09% PARKDEVELOPMENT RevenueR404-48000-31000 Washington Cty. TaxSettlement$20,000$10,000$0$10,00050.00% R404-48000-33422 OtherStateGrants & Aids$0$0$0$0 R404-48000-34780 ParkDedication Fees$21,000$3,000$0$18,00014.29% R404-48000-36210 Interest Income$66$0$0$660.00% LionsPlayground donation; BenchdonationmovedR404-48000-36230 Donations$0$10,000($1,601)($10,000) toGenFund TotalParkDevelopment FundRevenue$41,066$23,000($1,601)$18,06656.01% ExpenditureE 404-48000-312 Planning Services$0$4,500$0($4,500) E404-48000-520 CapitalImprovements toBldgs$17,306$0$0$17,3060.00% E404-48000-530 CapitalImprOtherThanBldgs$0$70$70($70) E404-48000-720 OperatingTransfers$0$3,048$3,048($3,048)loanrepayment toGenCapitalFund401 TotalParkDevelopment FundExpenditures$17,306$7,618$3,118$9,68844.02% EQUIPMENT REPLACEMENT RevenueR406-48500-31000 Washington Cty. TaxSettlement$0$0$0$0 R406-48500-36210 Interest Income$1,030$0$0$1,0300.00% R406-48500-36260 SaleofEquipment$35,000$0$0$35,0000.00% R406-48500-39350 Certificate ofIndebtedness$819,500$0$0$819,5000.00% TotalEquipment Replacement FundRevenue$855,530$0$0$855,5300.00% ExpenditureE 406-48500-540 Heavy Machinery Capital$325,000$0$0$325,0000.00% E406-48500-550 MotorVehicles Capital$189,500$0$0$189,5000.00% TotalEquipment Replacement FundExpenditures$514,500$0$0$514,5000.00% LOCALROADIMPROVEMENT FUND RevenueR408-43100-31000 Washington Cty. TaxSettlement$212,012$106,006$0$106,00650.00% R408-43100-33422 OtherStateGrants & Aids$0$0$0$0 R408-43100-36210 Interest Income$12,115$0$0$12,1150.00% R408-43100-39310 Proceeds-GenObligation Bond$0$0$0$0 TotalLRIFRevenue$224,127$106,006$0$118,12147.30% ExpenditureE 408-43100-303 Engineering Fees$20,000$62,542$28,458($42,542)312.71% E408-43100-530 CapitalImprOtherThanBldgs$973,000$808,556$13,596$164,44483.10% TotalLRIFExpenditures$993,000$871,098$42,054$121,90287.72% CITYOFSCANDIA Revenue - ExpenditureSummary August2023 2023YTD August Budget Description2023 BudgetAmountAmountBalance% ofBudgetComments BIGMARINESEWER RevenueR 602-43210-31951 SpecialAssessments Principal$0$2,066$0($2,066) R602-43210-31952 SAPenalties & Interest$0$258$0($258) R602-43210-33422 OtherStateGrants & Aids$0$0$0$0 R602-43210-34401 SewerUserFees$140,700$61,234$1,236$79,46643.52% R602-43210-34402 SewerConnection Fee$0$8,000$0($8,000) R602-43210-36100 SpecialAssessments$600$0$0$6000.00% R602-43210-36102 Penalties andInterest$0$50$20($50) R602-43210-36210 Interest Income$400$0$0$4000.00% TotalBigMarine SewerRevenue$141,700$71,608$1,256$70,09250.53% ExpenditureE 602-43210-101 RegularWages & Salaries$22,500$13,853$2,167$8,64761.57% E602-43210-102 OTRegularWages$0$0$0$0 E602-43210-120 PensionExpense$0$0$0$0 E602-43210-121 PERACoord. EmployerContribu.$17,000$1,037$163$15,9636.10% E602-43210-122 FICAEmployer Contribution$1,400$807$130$59357.61% E602-43210-126 MEDICAREEmployer Contribution$300$203$30$9767.71% E602-43210-131 Employer PaidHealth$0$0$0$0 E602-43210-151 WorkersCompInsurancePrem$700$736$0($36)105.20% E602-43210-200 OfficeSupplies$200$0$0$2000.00% E602-43210-210 Operating Supplies$2,500$770$713$1,73030.79% E602-43210-240 SmallToolsandMinorEquip$600$0$0$6000.00% BlissCollectorPermitRenewalE602-43210-303 Engineering Fees$10,500$50,202$7,840($39,702)478.11% E602-43210-304 LegalServices$0$18$0($18) E602-43210-308 OtherProfessional Services$2,500$3,378$887($878)135.12%PaceAnalytical monthlytesting E602-43210-309 SoftwareSupport & Maintenance$1,300$0$0$1,3000.00% E602-43210-317 Employee Training$1,400$0$0$1,4000.00% E602-43210-321 Telephone$2,400$1,891$241$50978.78% E602-43210-322 Postage$600$0$0$6000.00% E602-43210-331 TravelExpenses$200$633$0($433)316.28% E602-43210-334 Licenses & Permits$1,600$729$0$87145.56% E602-43210-361 Liability/Property Ins$3,000$3,449$0($449)114.97% E602-43210-381 Utilities-Electric & Gas$2,500$253$237$2,24710.11%Connexus & Excel E602-43210-385 SewerPumping & Maintenance$15,000$0$0$15,0000.00% E602-43210-386 Operation & Maintenance$5,000$2,139$0$2,86142.78% E602-43210-404 RepairMachinery/Equipment$16,000$12,101$0$3,89975.63%LiftStation #2pumpreplacement E602-43210-413 Equipment Rental$400$0$0$4000.00% E602-43210-420 Depreciation Expense$54,300$0$0$54,3000.00% E602-43210-438 Misc. Contractual$10,000$0$0$10,0000.00% E602-43210-439 RefundsIssued$0$0$0$0 E602-43210-530 CapitalImprOtherThanBldgs$9,800$0$0$9,8000.00% TotalBigMarineSewerExpenditures$181,700$92,197$12,408$89,50350.74% CITYOFSCANDIA Revenue - ExpenditureSummary August2023 2023YTD August Budget Description2023 BudgetAmountAmountBalance% ofBudgetComments UPTOWN SEWER RevenueR 612-43210-34401 SewerUserFees$22,300$10,409$4,217$11,89146.68% R612-43210-36210 Interest Income$200$0$0$2000.00% TotalUptownSewerRevenue$22,500$10,409$4,217$12,09146.26% ExpenditureE 612-43210-101 RegularWages & Salaries$9,700$5,857$879$3,84360.38% E612-43210-102 OTRegularWages$0$0$0$0 E612-43210-120 PensionExpense$0$0$0$0 E612-43210-121 PERACoord. EmployerContribu.$700$438$66$26262.64% E612-43210-122 FICAEmployer Contribution$600$341$53$25956.83% E612-43210-126 MEDICAREEmployer Contribution$100$86$12$1485.76% E612-43210-131 Employer PaidHealth$0$0$0$0 E612-43210-151 WorkersCompInsurancePrem$200$316$0($116)157.80% E612-43210-200 OfficeSupplies$100$0$0$1000.00% E612-43210-210 Operating Supplies$300$0$0$3000.00% E612-43210-221 Equipment Parts$300$0$0$3000.00% E612-43210-303 Engineering Fees$1,000$0$0$1,0000.00% E612-43210-304 LegalServices$0$0$0$0 E612-43210-308 OtherProfessional Services$500$733$0($233)146.60%58% increaseintestingcosts E612-43210-309 SoftwareSupport & Maintenance$0$0$0$0 E612-43210-317 Employee Training$350$0$0$3500.00% E612-43210-319 OtherServices$0$0$0$0 E612-43210-322 Postage$0$0$0$0 E612-43210-334 Licenses & Permits$400$224$0$17656.00% E612-43210-361 Liability/Property Ins$400$478$0($78)119.46% E612-43210-381 Utilities-Electric & Gas$1,700$566$24$1,13433.30% E612-43210-385 SewerPumping & Maintenance$1,500$0$0$1,5000.00% E612-43210-386 Operation & Maintenance$700$0$0$7000.00% E612-43210-404 RepairMachinery/Equipment$2,000$0$0$2,0000.00% E612-43210-420 Depreciation Expense$5,100$0$0$5,1000.00% E612-43210-438 Misc. Contractual$1,300$0$0$1,3000.00% E612-43210-530 CapitalImprOtherThanBldgs$4,500$0$0$4,5000.00% TotalUptownSewerExpenditures$31,450$9,038$1,034$22,41228.74%