Loading...
HomeMy WebLinkAbout05(A) - Approval of Claims Listing Report City of Prior Lake | 4646 Dakota Street SE | Prior Lake MN 55372 CITY COUNCIL AGENDA REPORT ITEM: 5A MEETING DATE: March 21, 2022 PREPARED BY: Janet Ringberg, Accounting Specialist PRESENTED BY: Cathy Ericksonson, Finance Director AGENDA ITEM: Approval of Claims Listing GOAL AREA OBJECTIVE: High-Value City Services 1. Establish financial stability for all funds. RECOMMENDED ACTION: Adopt claims listing as presented. BACKGROUND: The current claims listing is a check register which includes a chronological listing of payments issued (check, EFT, ACH, and wires) with the associated vendor and description of the claim paid. The option to include a general ledger account number is not available with this report. At the request of the Council and City Manager we have included the payroll paid, by department, for the previous month. We are providing the information in the same format as the quarterly expenditure financial reporting and will provide it on a monthly basis. As a reminder, the city pays wages two weeks in arrears and some pay is seasonal and overtime. ALTERNATIVES: 1. Motion and second as part of the consent agenda to adopt the claims list as presented. 2. Remove the claims list from the consent agenda for additional discussion. ATTACHMENTS: 1. Claims Listing 03 21 2022 2. February 2022 Payroll Claims Date Checks ACH EFT Total 2/28/2022 1,767.50 1,767.50 3/1/2022 18,187.38 18,187.38 3/2/2022 13.30 13.30 3/3/2022 46.00 46.00 3/4/2022 105,976.87 198,645.72 38,854.02 343,476.61 3/7/2022 1,477.44 1,477.44 3/8/2022 25,000.00 2,054.45 27,054.45 3/9/2022 595.51 595.51 3/11/2022 202,835.62 29,114.31 231,949.93 333,812.49 227,760.03 62,995.60 624,568.12 Payments Issued 2/26/2022 - 3/11/2022 CHECK REGISTER FOR CITY OF PRIOR LAKE 1/4Page: 03/14/2022 08:28 AM User: Janet DB: Prior Lake CHECK DATE FROM 02/26/2022 - 03/11/2022 AmountDescriptionVendor NameVendorCheckBankCheck Date Bank 1 General Bank 2,400.00 Feb 2022 Animal Control4 PAWS ANIMAL CONTROL LLC000067988280(A)103/04/2022 4.00 ParkingANDY STEPHES000271898281(A)103/04/2022 526.44 541 Tires BAUER BUILT INC000021458282(A)103/04/2022 782.86 Feb 2022 Misc SuppliesCARLSON HARDWARE COMPANY000031258283(A)103/04/2022 58.00 9201N Squad suppliesEMERGENCY AUTOMOTIVE TECH INC000054808284(A)103/04/2022 84.00 Duggan - Uniform PantsGALLS LLC000070758285(A)103/04/2022 12.58 Shredder BagsINNOVATIVE OFFICE SOLUTIONS LLC000271498286(A)103/04/2022 11.33 Bengtson - Name Tag 11.33 Young - Name Tag 183.11 Misc Office Supplies 218.35 11,716.40 Feb 2022 Diesel KELLEY FUELS INC000112198287(A)103/04/2022 11,193.60 Feb 2022 Unleaded 22,910.00 23.74 Urinal GasketKULLY SUPPLY INC000119408288(A)103/04/2022 684.95 2022 Annual Inspection - PDMETRO ALARM CONTRACTORS INC000133548289(A)103/04/2022 204.95 2022 Annual Inspection - FS#1 264.95 2022 Annual Inspection - MC 324.95 2022 Annual Inspection - WTF 234.95 2022 Annual Inspection - FS#2 444.95 2022 Annual Inspection - CH 384.95 2022 Annual Inspection - Lib 2,544.65 152,056.76 Mar 2022 Waste Water ServiceMETROPOLITAN COUNCIL000134008290(A)103/04/2022 120.00 Sand - Polar PlungePENTAGON MATERIALS INC000274268291(A)103/04/2022 555.80 Jan 2022 Data & SoftwarePRECISE MOBILE RESOURCE MGMT000165488292(A)103/04/2022 520.74 Feb 2022 Misc SuppliesPRIOR LAKE HARDWARE000166588293(A)103/04/2022 150.00 Safety Boots 2022STEVE KORBEL000274788294(A)103/04/2022 54.69 521 Dummy plugs TERMINAL SUPPLY COMPANY000202708295(A)103/04/2022 639.78 Leak LocatesWATER CONSERVATION SVCS INC000232008296(A)103/04/2022 6,094.44 TRN20-000001 Fish Pt Road Eng SvcsWSB & ASSOCIATES INC000237808297(A)103/04/2022 43.00 Timbercrest Tr Wetland Permitting 103.00 Pavement Management Program 43.00 Revere Place 5,908.50 General Engineering Support 212.00 2021-2022 Municipal State Aid Street Sys 2,424.50 Jeffers Pond - Outlot C - First Addition 14,828.44 29.10 City Hall First Aid SuppliesZEE MEDICAL SERVICE000263508298(A)103/04/2022 65.50 Maint Ctr Medical Supplies 94.60 72.87 Fire station 2 generator repair ZIEGLER INC000265008299(A)103/04/2022 18,187.38 Feb 2022 Natural Gas BillsCENTERPOINT ENERGY000135708300(E)103/01/2022 13.30 Feb 2022 Merchant FeesAUTHORIZE.NET000268218301(E)103/02/2022 352.00 Feb 2022 HSA Admin FeesALERUS000013758302(E)102/28/2022 1,415.50 2022 Dental ClaimsDELTA DENTAL000272138303(E)102/28/2022 CHECK REGISTER FOR CITY OF PRIOR LAKE 2/4Page: 03/14/2022 08:28 AM User: Janet DB: Prior Lake CHECK DATE FROM 02/26/2022 - 03/11/2022 AmountDescriptionVendor NameVendorCheckBankCheck Date 46.00 Filing Fee - Res 21-174SCOTT COUNTY000192128304(E)103/03/2022 7,586.75 Feb 2022 General MattersCAMPBELL KNUTSON PA000280438305(A)103/11/2022 1,080.00 Feb 2022 AT&T at Cedarwood 8,666.75 6,998.00 Mar 2022 CleaningCOVERALL000275718306(A)103/11/2022 141.31 BatteryFACTORY MOTOR PARTS COMPANY000060208307(A)103/11/2022 129.90 Nitrogen CylinderFLEXIBLE PIPE TOOL CO000066608308(A)103/11/2022 82.95 Duggan - Uniform PantsGALLS LLC000070758309(A)103/11/2022 28.01 Dean - Initial Uniform 91.25 Baker - Initial Uniform 202.21 155.25 Feb 2022 LocatesGOPHER STATE ONE-CALL INC000075258310(A)103/11/2022 6,591.46 Water Treatment ChemicalsHAWKINS INC000083128311(A)103/11/2022 901.37 Feb 2022 UniformsHUEBSCH000275368312(A)103/11/2022 23.75 Misc Office SuppliesINNOVATIVE OFFICE SOLUTIONS LLC000271498313(A)103/11/2022 110.00 Bldg Official Lic & App FeeJEFFREY KES000279128314(A)103/11/2022 650.00 7 Quantitative Fit TestsMED-COMPASS INC000133068315(A)103/11/2022 815.00 23 Quantitative Fit Tests 1,465.00 400.00 Feb 2022 ROWay AppPERRILL000065028316(A)103/11/2022 723.00 Special Assmt Input/Delete & Setup FeesSCOTT COUNTY000192128317(A)103/11/2022 120.00 ServiceTRI COUNTY WATER METRO SOUTH000052478318(A)103/11/2022 252.00 E Coli TestingUC LABORATORY000212358319(A)103/11/2022 467.00 Primary FluidVESSCO INC000224688320(A)103/11/2022 396.80 PartsVIKING ELECTRIC SUPPLY000226308321(A)103/11/2022 216.52 Parts 108.26 Parts 721.58 43.00 Vallez Property WCA ReviewWSB & ASSOCIATES INC000237808322(A)103/11/2022 419.00 2022 WCA LGU Support 462.00 5.16 Generator keysZIEGLER INC000265008323(A)103/11/2022 326.29 Generator City Hall no start 252.28 Generator Franklin Trail coolant leak 583.73 38,854.02 Mar 2022 Electric BillsXCEL ENERGY000147208324(E)103/04/2022 1,151.26 2022 Dental ClaimsDELTA DENTAL000272138325(E)103/07/2022 326.18 Mar 2022 Vision PremiumsEYEMED000279178326(E)103/07/2022 2,054.45 Feb 2022 Merchant FeesINVOICE CLOUD000280918327(E)103/08/2022 595.51 Feb 2022 Merchant Card FeesTRANSFIRST000206938328(E)103/09/2022 430.00 Remote ServiceANCOM TECHNICAL CENTER00001655109758103/04/2022 326.00 Radio Repair 756.00 108.00 Feb 2022 Yoga InstructorASHLEY BITZAN00028004109759103/04/2022 CHECK REGISTER FOR CITY OF PRIOR LAKE 3/4Page: 03/14/2022 08:28 AM User: Janet DB: Prior Lake CHECK DATE FROM 02/26/2022 - 03/11/2022 AmountDescriptionVendor NameVendorCheckBankCheck Date 6,600.00 AV SupportAVI SYSTEMS INC00001982109760103/04/2022 300.00 2022 Sr Luncheon SponsorCHAMBER OF COMMERCE00003370109761103/04/2022 105.00 Feb 2022 Tai Chi InstructorCHRISTINE T MORGAN00027316109762103/04/2022 84.01 Feb 2022 Bottled WaterCULLIGAN BOTTLED WATER00003958109763103/04/2022 625.00 PL Winter PhotosDAVID GREGOIRE00028089109764103/04/2022 14.25 Tabs - #7136 2018 Ford #120220DEPUTY REGISTRAR #16000004400109765103/04/2022 2,675.00 PartsEARL F ANDERSEN INC00005175109766103/04/2022 1,358.50 Water MetersFERGUSON WATERWORKS #251600006231109767103/04/2022 1,962.48 Water Meters 1,303.66 Water Meters 4,624.64 295.00 O'Donnell - FTO Basic TrainingFIELD TRAINING SOLUTIONS 00027778109768103/04/2022 180.00 Feb 2022 Yoga InstructorGWENDOLYN SCHMID00027984109769103/04/2022 3,800.00 Humidifier Repair - LibKLAMM MECHANICAL CONTRACTORS INC00026904109770103/04/2022 25.00 Wedel - Meeting Luncheon METROPOLITAN AREA MGMT ASSN00013397109771103/04/2022 31,981.95 Feb 2022 SAC ChargesMETROPOLITAN COUNCIL-SAC00013406109772103/04/2022 22,863.00 1st Qtr 2022 State SurchargeMN DEPT OF HEALTH00013618109773103/04/2022 125.00 Seasonal Job PostingMN RECREATION & PARK ASSN00013670109774103/04/2022 129.95 Ticket Writer Paper RollsPAPER ROLL PRODUCTS00027205109775103/04/2022 5,000.00 22-0161 5470 Fairlawn Shores Trail SEPEBBLE CREEK CUSTOM HOMESMISC-CD109776103/04/2022 10,987.80 Training AmmunitionSUNSET LAW ENFORCEMENT00027867109777103/04/2022 6,777.51 507 Tractor RepairTRUEMAN WELTERS INC00020867109778103/04/2022 482.48 Arts & Culture Committee ConsultantURBANE DRK CONSULTING00027976109779103/04/2022 4,918.28 Mar 2022 Cell Phone BillVERIZON WIRELESS00001315109780103/04/2022 2,519.00 Turbo K, Sound SuppressorYANKEE HILL MACHINE CO INC00028126109781103/04/2022 25,000.00 3800 Green Hghts Tr - Sewer Backup ClaimSCOTT THIELENREFUND-MSC109782103/08/2022 275.00 Ringberg - 2022 Membership DuesAMERICAN PAYROLL ASSN00026988109783103/11/2022 21.44 Natural Gas - 4528 Colorado St SECENTERPOINT ENERGY00013570109784103/11/2022 57.18 Water - 4528 Colorado Street SECITY OF PRIOR LAKE00016810109785103/11/2022 13,513.20 2022 Road SaltCOMPASS MINERALS AMERICA INC00027923109786103/11/2022 1,780.73 Mar 2022 RefuseDICK'S SANITATION INC00027918109787103/11/2022 21.75 Title - 2003 Kia Rio #144053DRIVER & VEHICLE SERVICES00004610109788103/11/2022 21.75 Title - 2008 Toyota SiennaDRIVER & VEHICLE SERVICES00004610109789103/11/2022 178.60 PartsEARL F ANDERSEN INC00005175109790103/11/2022 4,100.00 Water MetersFERGUSON WATERWORKS #251600006231109791103/11/2022 4,100.00 Water Meters 8,200.00 890.21 Replace Security Lights - Well #3 & BoosHAYES ELECTRIC INC00008315109792103/11/2022 4,648.05 Feb 2022 Misc SuppliesHOME DEPOT CREDIT SERVICES00008865109793103/11/2022 72.94 Olson - ShirtJACK'S UNIFORMS & EQUIPMENT00027636109794103/11/2022 24.00 Mar 2022 Go To Meeting LicenseLOGMEIN INC00026895109795103/11/2022 19.98 PartsMENARDS LUMBER CO00013318109796103/11/2022 23.00 Mesenbrink - Water Operator Renewal AppMN DEPT OF HEALTH00013618109797103/11/2022 275.00 Doerr - Water & Wastewater Tech ConfMN RURAL WATER ASSOC00013674109798103/11/2022 80.00 Deck ScrewsMONNENS SUPPLY INC00013909109799103/11/2022 31.20 Supplies 111.20 380.00 Skluzacek & Team - Member DuesMPSTMA00013949109800103/11/2022 3,577.50 Street BannersNORTHERN LIGHTS DISPLAY00027264109801103/11/2022 16,820.52 Fire Station #1 RemodelOERTEL ARCHITECTS00015155109802103/11/2022 141,773.52 2022 Pond MaintenancePETERSON COMPANIES INC00027860109803103/11/2022 4,680.00 2022 Spring/Summer Program GuideRIGHTLINE DESIGN00028130109804103/11/2022 CHECK REGISTER FOR CITY OF PRIOR LAKE 4/4Page: 03/14/2022 08:28 AM User: Janet DB: Prior Lake CHECK DATE FROM 02/26/2022 - 03/11/2022 AmountDescriptionVendor NameVendorCheckBankCheck Date 75.00 2008 Toyota Sienna #215831SCOTT COUNTY ATTORNEY00019232109805103/11/2022 150.00 2003 Cadillac #161001 225.00 381.98 PaintSHERWIN-WILLIAMS CO00019456109806103/11/2022 (0.42)Paint 381.56 80.86 Feb 2022 Legal NoticesSOUTHWEST NEWS MEDIA00019676109807103/11/2022 399.00 Employment Ads 479.86 242.00 Feb 2022 Portable ToiletsSPECIALIZED SANITATION00019703109808103/11/2022 2,635.00 WTF Chemical Room Floor PaintingSWEDEBRO INC00027991109809103/11/2022 56.87 Feb 2022 Misc SuppliesTRACTOR SUPPLY CREDIT PLAN00020663109810103/11/2022 55.00 Mar 2022 Shredding ServiceVETERAN SHREDDING LLC00027643109811103/11/2022 224.76 Feb 2022 Clear Law Enforcement PlusWEST PAYMENT CENTER00023420109812103/11/2022 1,170.00 Wilds Booster Pump MaintenanceWW GOETSCH ASSOCIATES INC00023795109813103/11/2022 1 TOTALS: 624,568.12 Total of 105 Disbursements: 0.00 Less 0 Void Checks: 624,568.12 Total of 105 Checks: City of Prior Lake Expenditures- Payroll and BenefitsAs of 2/28/2022 (Preliminary & Unaudited)Activity for Activity for Variance from VariancePrevious Month Month 2022 2022 2022 Amended Budget ‐ % BDGTActual YTDfrom 20211/31/2022 2/28/2022 Budget Amended Actual YTD Positive (Negative) USED2/28/2021 Positive (Negative)GENERAL FUNDFunction: General Government41110.00 MAYOR & COUNCIL 4,450                          4,680                          68,728                 68,728                 9,129                   59,599                               13% 10,130                     1,000                                     41320.00 ADMINISTRATION 8,829                          20,853                        276,235               276,235               29,683                 246,552                            11% 25,187                     (4,495)                                    41330.00 BOARDS & COMMISSIONS‐                                    ‐                                   10,765                 10,765                  ‐                            10,765                               0% 615                           615                                         41400.00 CITY CLERK FUNCTIONS 5,237                          9,779                          128,447               128,447               15,016                 113,431                            12% 14,690                     (326)                                       41410.00 ELECTIONS‐                                   77                                57,690                 57,690                 77                         57,613                               0%‐                                (77)                                          41520.00 FINANCE 27,079                        32,970                        570,810               570,810               60,049                 510,761                            11% 67,235                     7,185                                     41820.00 HUMAN RESOURCES 11,846                        22,372                        287,689               287,689               34,217                 253,472                            12% 33,658                     (559)                                       41830.00 COMMUNICATIONS 5,564                          7,568                          142,261               142,261               13,132                 129,129                            9% 14,164                     1,031                                     41910.00 COMMUNITY DEVELOPMENT 7,071                          19,055                        335,822               335,822               26,126                 309,696                            8% 35,887                     9,761                                     41920.00 INFORMATION TECHNOLOGY 10,035                        18,231                        239,241               239,241               28,266                 210,975                            12% 27,622                     (645)                                       41940.00 FACILITIES ‐ CITY HALL 4,960                          7,494                          88,220                 88,220                 12,454                 75,766                               14% 1,081                       (11,374)                                  Total ‐ Function General Government 85,071                        143,080                      2,205,908            2,205,908            228,151               1,977,757                         10% 230,268                   2,118                                     Function: Public Safety42100.00 POLICE 228,798                      420,225                      5,445,654            5,445,654            649,023               4,796,631                         12% 603,054                   (45,969)                                  42200.00 FIRE 13,392                        58,659                        900,773               900,773               72,051                 828,722                            8% 59,492                     (12,559)                                  42400.00 BUILDING INSPECTION 30,293                        55,073                        784,947               784,947               85,367                 699,580                            11% 83,157                     (2,209)                                    Total ‐ Function Public Safety 272,483                      533,957                      7,131,374            7,131,374            806,441               6,324,933                         11% 745,704                   (60,737)                                  Function: Public Works43050.00 ENGINEERING 11,031                        27,170                        359,793               359,793               38,201                 321,592                            11% 38,136                     (65)                                          43100.00 STREET 23,056                        40,840                        537,643               537,643               63,896                 473,747                            12% 65,029                     1,133                                     43400.00 CENTRAL GARAGE 11,569                        20,313                        262,456               262,456               31,882                 230,574                            12% 30,143                     (1,739)                                    Total ‐ Function Public Works 45,656                        88,323                        1,159,892            1,159,892            133,979               1,025,913                         12% 133,308                   (671)                                       Function: Culture and Recreation45100.00 RECREATION 10,835                        23,025                        377,023               377,023               33,860                 343,163                            9% 33,405                     (455)                                       45200.00 PARKS 47,113                        84,934                        1,162,215            1,162,215            132,047               1,030,168                         11% 109,856                   (22,192)                                  Total ‐ Function Culture and Recreation 57,948                        107,959                      1,539,238            1,539,238            165,907               1,373,331                         11% 143,260                   (22,647)                                  General Fund Payroll Only Expenditures Total 461,159                      873,319                      12,036,412         12,036,412         1,334,478            10,701,934                       11% 1,252,541                (81,937)                                  COMPARATIVEAnnual City of Prior Lake Expenditures- Payroll and BenefitsAs of 2/28/2022 (Preliminary & Unaudited)Activity for Activity for Variance from VariancePrevious Month Month 2022 2022 2022 Amended Budget ‐ % BDGTActual YTDfrom 20211/31/2022 2/28/2022 Budget Amended Actual YTD Positive (Negative) USED2/28/2021 Positive (Negative)COMPARATIVEAnnualEDA FUNDFunction:  Economic Development   46500.00 ECONOMIC DEVELOPMENT 7,318                          8,941                          143,239               143,239               16,259                 126,980                            11% 20,772                     4,512                                     EDA Fund Payroll Only Expenditures Total 7,318                          8,941                          143,239               143,239               16,259                 126,980                            11% 20,772                     4,512                                     WATER FUNDFunction: Water41520.00 Finance 3,477                          6,235                          84,371                 84,371                 9,711                   74,660                               12% 9,530                       (181)                                       49400.00 Water 35,210                        68,874                        794,320               794,320               104,084               690,236                            13% 90,514                     (13,570)                                  Water Fund Payroll Only Expenditures Total 38,686                        75,109                        878,691               878,691               113,795               764,896                            13% 100,044                   (13,751)                                  SEWER FUNDFunction: Sewer41520.00 Finance 3,476                          6,234                          84,371                 84,371                 9,710                   74,661                               12% 9,529                       (181)                                       49450.00 Sewer 48,848                        52,144                        786,039               786,039               100,993               685,046                            13% 106,552                   5,559                                     Sewer Fund Payroll Only Expenditures Total 52,324                        58,378                        870,410               870,410               110,702               759,708                            13% 116,080                   5,378                                     STORM WATER FUNDFunction: Storm Water49420.00 Water Quality 20,286                        27,235                        356,875               356,875               47,521                 309,354                            13% 44,776                     (2,745)                                    Storm Water Fund Payroll Only Expenditures Total 20,286                        27,235                        356,875               356,875               47,521                 309,354                            13% 44,776                     (2,745)                                    City‐Wide Total Payroll Expenditures 579,773                     1,042,982                  14,285,627         14,285,627         1,622,755           12,662,872                      11% 1,534,213               (88,542)