Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2023-03-20 I01A 03202023_bill list_payroll
City of Waukee Bill Presentation Recap March 20, 2023 Total Unpaid Bills Presented for Approval : $ 979,826.50 Total Checks Issued Prior to Council Approval: (A) Prior to Last Council Meeting $ - (B) After Last Council Meeting $ - (C) Payroll Taxes & Reimbursements $ 178,098.79 (D) Utility Refunds $ 1,443.45 Payroll Checks Issued: (E) 03/17/2023 $ 325,907.31 FY 2023 Fund Recap: 010 General Fund 011 General Fund-Hotel/Motel Tax 060 Road Use Tax Fund 070 Firemen's Association 080 Library Foundation 085 Asset Forfeitures 110 Debt Service Fund 111 Special Assessments Fund 120 North Residential TIF 121 Hickman West Indust Park TIF 123 Waukee Urban Renewal Area TIF Fund 124 Gateway Urban Renewal 125 Autumn Ridge Urban Renewal 126 Waukee West Urban Renewal 127 Southwest Business Park 128 Waukee Central URA 129 Towne Center Commercial TIF 130 Quarter Commercial TIF 131 Kettlestone Residential TIF 132 Kettlestone Commercial TIF 210 Employee Benefits Fund 211 Local Option Sales Tax 212 Public Improvement Fund 327 Capital Projects 330 City Wide SA Sidewalk Project 510 Water Utility Fund 520 Sewer Utility Fund 521 University Ave Trunk Sewer Project 522 Waste Water Treatment PI 523 E Area Pump Sta Treatment 540 Gas Utility Fund 560 Storm Sewer Utility Fund 570 Utility Bill Fund 590 Solid Waste Collect & Rcycl Fund 750 Golf Course Fund 810 Equipment Revolving Fund Grand Total: Expenditures Budaeted Year To Date $ 21,452,300 $ 14,454,995 $ 43,000 $ 47,284 $ 3,714,735 $ 2,287,660 $ - $ - $ 8,334,574 $ 191,250 $ 568,106 $ 45,000 $ 2,801,576 $ 493,672 $ 2,500 $ 93,000 $ 176,800 $ 3,000,000 $ 1,219,219 $ 19,369,941 $ 10,580,756 $ 15,912,426 $ 11,255,880 $ 4,499,690 $ 479,560 $ 1,718,400 $ 670,735 200 1,817,887 403 32,333 275,214 1,809 55,139 3,675 7,009 1,990 852 15, 373,142 4,232,848 7,962,901 8,515,551 1,592,464 310,579 1,334,227 406,991 $ 1,485,276.05 Bud 21,384,085 36,100 3,044,500 10,434, 782 304, 800.00 994,700 1,687,500 3,294,900 727,000 120,400 3,005,365 4,218,000 504,000 15, 500,000 7,725,640 6,668,500 10,635,000 1,436, 500 459,400 1,683,250 692,000 °� -l5 -a►oa3 Revenues 3 :d Year To Date 10,151,017 81,626 1,765,018 518 3,885,750 22,502 148,819 4,126 1,622,874 1,597,298 719,706 58,168 1,738,024 3,256,945 538,222 12,408,127 365 8,567,019 7,848,087 11,445 790 2,770 9,193, 744 1,092,559 367,999 1,096,409 525,987 Total: $ 106,623,120 $ 58,715,153 $ 94,556,422 $ 66,709,168 City of Waukee FY2023 Department Report - General Fund As of March 20, 2023 Expended YTD Budgeted $ Remaining General Fund: Police Department Personnel Services $ 2,770,583 $ 4,398,400 Supplies & Services $ 422,813 $ 563,200 Capital Outlay $ 161,731 $ 353,560 $ 3,355,126 $ 5,315,160 $ 1,960,034 Warning Sirens Personnel Services $ - $ - Supplies & Services $ 17,376 $ 21,950 Capital Outlay $ - $ - $ 17,376 $ 21,950 $ 4,574 Emergency Management Supplies & Services $ - $ - Westcom Dispatch Personnel Services $ - $ - Supplies & Services $ 474,546 $ 732,000 Capital Outlay $ - $ - $ 474,546 $ 732,000 $ 257,454 Fire Department Personnel Services $ 754,349 $ 1,047,800 Supplies & Services $ 140,714 $ 197,500 Capital Outlay $ - $ 20,120 $ 895,062 $ 1,265,420 $ 370,358 EMS Personnel Services $ 1,582,546 $ 2,370,950 Supplies & Services $ 125,479 $ 219,730 Capital Outlay $ - $ 35,880 $ 1,708,025 $ 2,626,560 $ 918,535 Building Inspection Personnel Services $ 542,964 $ 875,250 Supplies & Services $ 73,422 $ 51,100 Capital Outlay $ 29,682 $ 30,000 $ 646,068 $ 956,350 $ 310,282 Animal Control Personnel Services $ - $ - Supplies & Services $ 10,198 $ 31,000 Capital Outlay $ - $ - $ 10,198 $ 31,000 $ 20,802 Library Services Mosquito Control Community Services Personnel Services $ 657,643 Supplies & Services $ 269,806 Capital Outlay $ 20,799 $ 1,002,690 $ 354,750 $ 25,000 $ 948,247 $ 1,382,440 $ Personnel Services $ - $ - Supplies & Services $ - $ 2,000 Capital Outlay $ - Personnel Services $ - Supplies & Services $ 33,750 Capital Outlay $ - 1P L,VVV .p $ 52,000 33,750 $ 52,000 $ 434,193 2,000 18,250 Parks Personnel Services $ 293,825 $ 491,600 Supplies & Services $ 199,792 $ 290,460 Capital Outlay $ - $ 67,500 $ 493,617 $ 849,560 $ 355,943 Recreation Personnel Services $ 437,990 $ 666,800 Supplies & Services $ 195,870 $ 250,640 Capital Outlay $ - $ - $ 633,860 $ 917,440 $ 283,580 Triumph Park Personnel Services $ 214,371 $ 453,200 Supplies & Services $ 189,524 $ 207,700 Capital Outlay $ - $ - $ 403,895 $ 660,900 $ 257,005 Community Center Personnel Services $ 3,121 $ 6,000 Supplies & Services $ 24,523 $ 37,000 $ 27,644 $ 43,000 $ 15,356 Centennial West Property Supplies & Services $ 8,619 $ 11,500 $ 8,619 $ 11,500 $ 2,881 Public Works Personnel Services $ (22,716) $ 76,140 Supplies & Services $ (5,507) $ 5,730 Capital Outlay $ - $ - $ (28,223) $ 81,876 $ 110,093 Public Works Building Personnel Services $ - $ - Supplies & Services $ 171,799 $ Capital Outlay $ 27 $ - $ 171,826 $ - $ (171,826) Public Works Mechanic Personnel Services $ 146,039 $ 221,800 Supplies & Services $ 138,015 $ 66,850 Capital Outlay $ - $ - $ 284,054 $ 288,656 $ 4,596 Median and Bldg Grounds Personnel Services $ - $ - Supplies & Services $ 8,686 $ 20,000 Capital Outlay $ - $ - $ 8,686 $ 20,000 $ 11,314 Mayor & Council Personnel Services $ 41,531 $ 66,600 Supplies & Services $ 24,150 $ 32,500 Capital Outlay $ - $ - $ 65,682 $ 99,100 $ 33,418 Elections Personnel Services $ - $ - Supplies & Services $ - $ 1,600 Capital Outlay $ - $ - $ - $ 1,600 $ 1,600 Communications Personnel Services $ 13,117 $ 141,390 Supplies & Services $ 16,151 $ 55,620 Capital Outlay $ - $ - $ 29,268 $ 197,010 $ 167,742 Administration Personnel Services $ 188,500 $ 351,260 Supplies & Services $ 80,569 $ 126,140 Capital Outlay $ 2,236,151 $ 2,600,000 $ 2,505,220 $ 3,077,400 $ 572,180 City Hall Personnel Services $ - $ - Supplies & Services $ 111,987 $ 148,000 Capital Outlay $ 139,377 $ - $ 251,364 $ 148,000 $ (103,364) Human Resources Personnel Services $ 81,296 $ 139,950 Supplies & Services $ (11,103) $ 25,130 Capital Outlay $ - $ - $ 70,193 $ 165,080 $ 94,887 Financial Administration Personnel Services $ 97,697 $ 244,850 Supplies & Services $ 21,369 $ 39,850 Capital Outlay $ - $ 16,000 Other Financing $ - $ - $ 119,066 $ 300,700 $ 181,634 Economic Development Personnel Services $ 110,757 $ 148,820 Supplies & Services $ 43,471 $ 96,850 Capital Outlay $ - $ - $ 154,229 $ 245,670 $ 91,442 City Attorney Personnel Services $ - $ - Supplies & Services $ 136,255 $ 150,000 Capital Outlay $ - $ - $ 136,255 $ 150,OOF $ 13,745 Community Development Personnel Services $ 274,710 $ 584,320 Supplies & Services $ 11,357 $ 61,800 Capital Outlay $ - $ - $ 286,067 $ 646,120 $ 360,053 Information Technology Personnel Services $ 169,099 $ 277,940 Supplies & Services $ 64,302 $ 129,800 Capital Outlay $ 54,237 $ 17,000 $ 287,638 $ 424,740 $ 137,102 Engineering Personnel Services $ 344,908 $ 557,300 Supplies & Services $ 137,616 $ 124,730 Capital Outlay $ - $ - $ 482,524 $ 682,030 $ 199,506 GIS Personnel Services $ (21,121) $ 49,900 Supplies & Services $ (3,766) $ 4,750 Capital Outlay $ - $ 2,400 $ (24,887) $ 57,050 $ 81,937 Transfers to GO Debt Service $14,454,995 $21,452,300 $ 6,997,305 Total General Fund: Personnel Services $ 8,681,207 Supplies & Services $ 3,131,783 Capital Outlay $ 2,642,005 Other $ - $14,454,995 Expense Approval Register 4% City of Waukee, IA PKT03225 - MARCH 20 2023 COUNCIL MEETING Waukee Vendor Name Payable Number Post Date Description (Item) Account Number Amount TREASURER STATE OF IOWA INVO015128 02/28/2023 FEB'23 WATER EXCISE TAXES 510-2030500 25,365.84 TREASURER STATE OF IOWA INVO015129 02/28/2023 FEB'23 SEWER SALES TAXES 520-2030500 4,363.53 TREASURER STATE OF IOWA INVO015130 02/28/2023 FEB'23 GAS SALES TAXES 540-2030500 45,373.26 TREASURER STATE OF IOWA INVO015131 02/28/2023 FEB'23 STORM WATER SALE 560-2030500 2,490.37 TREASURER STATE OF IOWA INVO015132 02/28/2023 FEB'23 GOLF COURSE SALES 750-2030500 49.56 TREASURER STATE OF IOWA INVO015133 02/28/2023 FEB'23 PARKS & REC SALES T 010-2030500 147.00 77,789.56 Department: 0000 - GENERAL REVENUES BRAVO GREATER DES MOINE INVO015137 03/02/2023 FY23 OCT'22- DEC'22 28E Q 011-40.0000.459001 9,583.04 Department 0000 - GENERAL REVENUES Total: 9,583.04 Department: 1100 - POLICE OPERATIONS GALLS LLC 023474222 02/07/2023 NAME TAG- BEEHLER 010-10.1100.120000 18.20 GALLS LLC 023484653 02/07/2023 PANTS/SHIRT- FERRARA CRE 010-10.1100.120000 -237.49 GALLS LLC 023524071 02/10/2023 PATCHES 010-10.1100.120000 403.49 GALLS LLC 023535614 02/13/2023 PANTS- KICKBUSH 010-10.1100.120000 61.20 GALLS LLC 023563191 02/15/2023 SHIRT- ROBBINS 010-10.1100.120000 63.03 GALLS LLC 023563194 02/15/2023 PANTS- GILCHRIST 010-10.1100.120000 139.38 GALLS LLC 023563195 02/15/2023 SHIRT- FERRARA 010-10.1100.120000 86.42 GALLS LLC 023563197 02/15/2023 PANTS- JACKSON 010-10.1100.120000 139.38 GALLS LLC 023563206 02/15/2023 SHIRTS- SMOLIK 010-10.1100.120000 160.68 GALLS LLC 023563218 02/15/2023 SHIRT- MCCLUSKEY 010-10.1100.120000 77.76 GALLS LLC 023700906 02/28/2023 NAMEPLATE- TALAMANTEZ 010-10.1100.120000 10.50 GALLS LLC 023700910 02/28/2023 BOOTS/PANTS-TOWNSEND 010-10.1100.120000 172.80 GALLS LLC 023727893 03/02/2023 PANTS- HACKETT 010-10.1100.120000 210.87 GALLS LLC 023774018 03/07/2023 SHIRTS- HACKETT 010-10.1100.120000 122.98 GALLS LLC 023786569 03/08/2023 PANTS- FERRARA 010-10.1100.120000 61.20 GALLS LLC 023786581 03/08/2023 SHIRTS- SMOLIK 010-10.1100.120000 137.70 GALLS LLC 023786586 03/08/2023 SHIRTS/PANTS- LONG 010-10.1100.120000 286.55 THE WALDINGER CORP 110802-32 02/16/2023 BI-ANNUAL PREVENTATIVE 010-10.1100.400000 1,637.50 SIDEKICK DEVELOPMENT 1145 08/01/2022 PUBLIC SAFETY PROJECT 327-90.1100.235000 7,500.00 ATLANTIS GLOBAL LLC 11705 02/11/2023 CITATION PAPER 010-10.1100.580000 406.80 SIDEKICK DEVELOPMENT 1220 03/03/2023 PUBLIC SAFETY PROJECT 327-90.1100.235000 7,500.00 FRONTLINE WARNING SYSTE 13866 02/22/2023 ANNUAL PREVENTATIVE MAI 010-10.1100.400000 2,400.00 AMAZON.COM 14FQ-RG3C-W1JM 02/27/2023 DE-ICER 010-10.1100.590000 23.28 AMAZON.COM 1TW6-6JKF-CNTJ 03/04/2023 COFFEE/MAGNETIC HOOKS 010-10.1100.590000 97.67 AMAZON.COM 1VJW-FXGM-W1R6 02/27/2023 PAPER CUPS 010-10.1100.590000 77.29 AMAZON.COM 1WQF-7PNT-1V4F 03/05/2023 BINDER CLIPS/SHEET PROTE 010-10.1100.580000 19.51 AMAZON.COM iWQF-7PNT-JV4F 03/05/2023 BINDER CLIPS/SHEET PROTE 010-10.1100.590000 101.45 RANGEMASTERS TRAINING C 20-693262 01/02/2023 WEAPON LIGHTS 010-10.1100.540000 467.99 IOWA LAW ENFORCEMENT A 322994 02/23/2023 BASIC LEVEL 1 TRAINING- GE 010-10.1100.470000 13,975.00 WAUKEE COMMUNITY SCHO 42 01/31/2023 JANUARY 2023 STATEMENT- 010-10.1100.570000 3,229.19 STAPLES BUSINESS CREDIT 7374039766-0-1 02/22/2023 PAPER PLATES 010-10.1100.590000 51.49 UNIVERSAL PRINTING SERVI 78290 02/09/2023 TUMBLERS 010-10.1100.460200 1,506.71 CITY OF WEST DES MOINES EM-2023-00020008 02/28/2023 FIELD OPS CAD LICENSES 010-10.1100.280000 720.00 RYAN COMPANIES US INC INVO015147 02/28/2023 PUBLIC SAFETY PROJECT 327-90.1100.235000 2,114.56 BUTTERFIELD MANAGEMEN INVO015179 02/24/2023 OFFICER DEBRIEF FOLLOWIN 010-10.1100.230000 170.00 CONSOLIDATED COMMUNIC INVO015181 03/01/2023 MARCH 2O23 STATEMENT- P 010-10.1100.450000 126.50 STANARD & ASSOCIATES INC SA000053321 02/28/2023 POST TESTS 010-10.1100.470000 136.00 STANARD & ASSOCIATES INC SA000053368 02/28/2023 POST TESTS 010-10.1100.470000 80.00 Department 1100 - POLICE OPERATIONS Total: 44,255.59 Department: 1400 - FIRE PROTECTION THE WALDINGER CORP 110803-34 02/16/2023 BI-ANNUAL PREVENTATIVE 010-10.1400.400000 818.75 AMAZON.COM 1JTF-DFFV-GTHT 03/12/2023 KEY RINGS/KEY TAGS 010-10.1400.590000 64.71 3/15/2023 12:22:42 PM Page 1 of 11 Expense Approval Register Packet: APPKT03225 - MARCH 20 2023 COUNCIL MEETING Vendor Name Payable Number Post Date Description (Item) Account Number Amount AMAZON.COM 1NHW-NPKP-WM3L 02/27/2023 PUSH BROOMS 010-10.1400.590000 45.34 AMAZON.COM 1X9G-KNWT-KNP1 02/25/2023 SHOVELS 010-10.1400.590000 92.34 EAGLE ENGRAVING INC. 2022-8462 12/27/2022 ID TAGS/ENGRAVED SIGN 010-10.1400.590000 50.05 MIDWEST BREATHING AIR LL 26561 02/27/2023 QUARTERLY AIR TEST 010-10.1400.410100 840.36 WAUKEE COMMUNITY SCHO 42 01/31/2023 JANUARY 2023 STATEMENT- 010-10.1400.570000 834.92 WILLIS AUTOMOTIVE 662456 03/08/2023 VEHICLE REPAIRS 010-10.1400.410000 4,205.99 THE WALDINGER CORP 6986036-1 03/07/2023 BACKFLOW TESTING 010-10.1400.400000 86.50 VERIZON WIRELESS 9927639363 02/13/2023 FEBRUARY 2023 STATEMENT 010-10.1400.450000 41.53 CAPITAL SANITARY SUPPLY C363874A 03/08/2023 SOAP 010-10.1400.590000 41.00 CONSOLIDATED COMMUNIC INV0015181 03/O1/2023 MARCH 2O23 STATEMENT- P 010-10.1400.450000 27.83 KARL CHEVROLET ZZCS63996 02/16/2023 ADDED POWER SUPPLY FOR 010-10.1400.410000 234.93 Department 1400 - FIRE PROTECTION Total: 7,384.25 Department: 1500 - EMS THE WALDINGER CORP 110803-34 02/16/2023 BI-ANNUAL PREVENTATIVE 010-10.1500.400000 818.75 AMAZON.COM 1JTF-DFFV-GTHT 03/12/2023 KEY RINGS/KEY TAGS 010-10.1500.590000 64.71 WAUKEE COMMUNITY SCHO 42 01/31/2023 JANUARY 2023 STATEMENT- 010-10.1500.570000 834.92 THE WALDINGER CORP 6986036-1 03/07/2023 BACKFLOW TESTING 010-10.1500.400000 86.50 CAPITAL SANITARY SUPPLY C363874A 03/08/2023 SOAP 010-10.1500.590000 41.00 AMERIGROUP (IA MEDICAID) INV0015149 03/21/2023 AMBULANCE OVERPAYMENT 010-10.1500.3529900 1,336.81 MERCY WEST PHARMACY INV0015180 03/O1/2023 EMS MEDICATIONS 010-10.1500.590050 455.00 CONSOLIDATED COMMUNIC INV0015181 03/O1/2023 MARCH 2O23 STATEMENT- P 010-10.1500.450000 98.67 Department 1500 - EMS Total: 3,736.36 Department: 1600 - STREET LIGHTING MID AMERICAN ENERGY FEB231600SUMBILL 02/24/2023 FEBRUARY 2023 STATEMENT 060-30.1600.480000 20,485.36 Department 1600 - STREET LIGHTING Total: 20,485.36 Department: 1601- TRAFFIC SIGNALS MID AMERICAN ENERGY FEB231601SUMBILL 02/24/2023 FEBRUARY 2023 STATEMENT 060-30.1601.480000 1,801.61 Department 1601 - TRAFFIC SIGNALS Total: 1,801.61 Department: 1900 - BUILDING INSPECTION WAUKEE COMMUNITY SCHO 42 01/31/2023 JANUARY 2023 STATEMENT- 010-10.1900.570000 288.12 VERIZON WIRELESS 9927639363 02/13/2023 FEBRUARY 2023 STATEMENT 010-10.1900.450000 40.01 Department 1900 - BUILDING INSPECTION Total: 328.13 Department: 3100 - LIBRARY SERVICES AMAZON.COM 1R34-6XXK-91MX 03/01/2023 STORAGE BASKETS/ADAPTER 010-40.3100.590000 47.99 AMAZON.COM 1YCH-LPMF-JYPL 02/25/2023 CANDY/SNACKS 010-40.3100.460400 65.76 NATIONWIDE OFFICE CLEAN 20364 02/15/2023 CLEANING SERVICES- LIBRAR 010-40.3100.400100 1,810.29 OFFICE DEPOT 293459701001 02/17/2023 PAPER TOWELS/TOILET PAPE 010-40.3100.580000 5.24 OFFICE DEPOT 293459701001 02/17/2023 PAPER TOWELS/TOILET PAPE 010-40.3100.590000 237.62 OFFICE DEPOT 293461496001 02/17/2023 DISHWASHER DETERGENT/U 010-40.3100.590000 29.67 OFFICE DEPOT 293461497001 02/20/2023 ENVELOPES 010-40.3100.580000 27.39 ACCESS SYSTEMS LEASING 33560525 03/O1/2023 PRINTER/COPIER LEASE 010-40.3100.270110 118.45 CITY OF WAUKEE FEB 23 LIBRARY 02/28/2023 FEBRUARY 2023 STATEMENT 010-40.3100.480000 673.26 SHERROLYN KING INV0015178 01/21/2023 LUNAR NEW YEAR WORKSH 010-40.3100.460300 100.00 Department 3100 - LIBRARY SERVICES Total: 3,115.67 Department: 4100 - PARKS GENUS LANDSCAPE ARCHITE 22024-6 03/06/2023 STRATFORD CROSSING PARK 327-90.4100.880091 29,280.00 WAUKEE COMMUNITY SCHO 42 01/31/2023 JANUARY 2023 STATEMENT- 010-40.4100.570000 524.08 BDI SIGNS BUSINESS DESIGN 47816 03/04/2023 DOG PARK SIGN 010-40.4100.590010 13.75 DOG WASTE DEPOT 535296 03/07/2023 DOG WASTE BAGS 010-40.4100.590010 454.87 HILLYARD INC 605051421 03/09/2023 HAND SOAP 010-40.4100.590000 304.88 UNIVERSAL PRINTING SERVI 78539 02/20/2023 FEBRUARY 2023 STATEMENT 010-40.4100.210000 122.71 WAUKEE POWER EQUIPMEN 94435 03/06/2023 ROLLER/SPACER/SCREWS/AN 010-40.4100.410100 231.86 WAUKEE POWER EQUIPMEN 94450 03/06/2023 MOWER MAINTENANCE 010-40.4100.410100 109.15 WAUKEE POWER EQUIPMEN 94466 03/07/2023 V-BELT 010-40.4100.410100 115.49 WAUKEE POWER EQUIPMEN 94491 03/08/2023 TUBE -SPANNER 010-40.4100.410100 22.94 WAUKEE POWER EQUIPMEN 94494 03/08/2023 TRIMMER BLADES/CORDLES 010-40.4100.410100 289.86 MID AMERICAN ENERGY FEB234100SUMBILL 02/24/2023 FEBRUARY 2023 STATEMENT 010-40.4100.480000 551.04 3/15/2023 12:22:42 PM Page 2 of 11 Expense Approval Register Packet: APPKT03225 - MARCH 20 2023 COUNCIL MEETING Vendor Name Payable Number Post Date Description (Item) Account Number Amount PUTTERMAN ATHLETICS INV07527 02/21/2023 FOX CREEK WINDSCREENS 010-40.4100.540000 2,478.47 Department 4100 - PARKS Total: 34,499.10 Department: 4200 - RECREATION CIT SIGNATURE TRANSPORTA 18550 03/21/2023 AMERICAN GOTHIC HOUSE T 010-40.4200.460500 2,075.62 AMAZON.COM 1TGN-YY6F-1JCG 03/09/2023 LAMINATING POUCHES/HIG 010-40.4200.580000 214.38 JM IMPRESSIONS 2023-06 02/21/2023 SPRING/SUMMER 2023 PAR 010-40.4200.350100 1,500.00 WAUKEE COMMUNITY SCHO 42 01/31/2023 JANUARY 2023 STATEMENT- 010-40.4200.570000 28.76 REAL FOOD 4 KIDS 6245 03/06/2023 WINTER 2023 COOKING CLA 010-40.4200.460550 1,948.00 LIFETIME ATHLETIC 732 03/01/2023 2023 WINTER TENNIS SESSIO 010-40.4200.460550 1,892.80 UNIVERSAL PRINTING SERVI 78539 02/20/2023 FEBRUARY 2023 STATEMENT 010-40.4200.210000 122.71 UNIVERSAL PRINTING SERVI 78540 02/16/2023 BUSINESS CARDS- STANISH 010-40.4200.350100 50.00 BACKGROUND INVESTIGATIO INV-21277 03/01/2023 BACKGROUND CHECKS 010-40.4200.460500 101.15 BACKGROUND INVESTIGATIO INV-21277 03/O1/2023 BACKGROUND CHECKS 010-40.4200.460510 14.45 Department 4200 - RECREATION Total: 7,847.87 Department: 4210 - TRIUMPH PARK AMAZON.COM 1TGN-YY6F-1JCG 03/09/2023 LAMINATING POUCHES/HIG 010-40.4210.580000 48.75 AMAZON.COM 1V7W-GNV3-93JJ 03/08/2023 FILE FOLDERS 010-40.4210.580000 16.32 D & K PRODUCT INC. 636851N 02/24/2023 INFIELD CLAY/FIELD MARKIN 010-40.4210.590150 389.20 D & K PRODUCT INC. 636851N 02/24/2023 INFIELD CLAY/FIELD MARKIN 010-40.4210.590200 3,940.00 NAPA AUTO PARTS STORE 6726-065756 03/03/2023 OIL/FILTERS/DISPOSABLE GL 010-40.4210.410100 119.19 Department 4210 - TRIUMPH PARK Total: 4,513.46 Department: 4300 - COMMUNITY CENTER SHERWIN WILLIAMS CO 1286-7 02/15/2023 PAINT 010-40.4300.400000 39.17 NATIONWIDE OFFICE CLEAN 20834 02/28/2023 CLEANING SERVICES- COMM 010-40.4300.400100 310.72 MID AMERICAN ENERGY FEB236510SUMBILL 02/24/2023 FEBRUARY 2023 STATEMENT 010-40.4300.480000 167.48 Department 4300 - COMMUNITY CENTER Total: 517.37 Department: 5020 - HEART OF WARRIOR TRAIL AHLERS & COONEY PC 838661 02/28/2023 HEART OF WARRIOR TRAIL 327-90.5020.881110 1,900.00 Department 5020 - HEART OF WARRIOR TRAIL Total: 1,900.00 Department: 5300 - STORM WATER WAUKEE COMMUNITY SCHO 42 01/31/2023 JANUARY 2023 STATEMENT- 560-80.5300.570000 111.37 VERIZON WIRELESS 9927639363 02/13/2023 FEBRUARY 2023 STATEMENT 560-80.5300.450000 232.34 Department 5300 - STORM WATER Total: 343.71 Department: 5400 - SOLID WASTE COLLECTION & DISPOSAL ANKENY SANITATION INC. 1414875 03/O1/2023 MARCH 2O23 STATEMENT 590-30.5400.231300 150,696.49 Department 5400 - SOLID WASTE COLLECTION & DISPOSAL Total: 150,696.49 Department: 6000 - PUBLIC WORKS ADMINISTRATION VISION CUSTOM SIGNS & GR 2958 03/07/2023 VEHICLE GRAPHIC 010-20.6000.410000 175.00 WAUKEE COMMUNITY SCHO 42 01/31/2023 JANUARY 2023 STATEMENT- 010-20.6000.570000 307.59 VERIZON WIRELESS 9927639363 02/13/2023 FEBRUARY 2023 STATEMENT 010-20.6000.450000 398.14 Department 6000 - PUBLIC WORKS ADMINISTRATION Total: 880.73 Department: 6010 - PUBLIC WORKS BUILDING ANKENY SANITATION INC. 1415198 03/O1/2023 20YD FLAT DUMP/RETURN 010-20.6010.510100 257.00 NATIONWIDE OFFICE CLEAN 20063 02/15/2023 CLEANING SERVICES- PUBLIC 010-20.6010.400100 1,567.11 SKOLD DOOR & FLOOR COM 214273-MAR23-1 03/03/2023 NEW DOOR OPERATOR AND 010-20.6010.400000 2,810.10 OFFICE DEPOT 294498866001 02/28/2023 DRY ERASE MARKERS/ERASE 010-20.6010.580000 79.92 OFFICE DEPOT 294502677001 02/28/2023 MAGNETS 010-20.6010.590000 89.37 CINTAS CORPORATION 4148627390 03/07/2023 MATS & TOWELS 010-20.6010.590000 251.73 EDISON LIGHTING SUPPLY LL 43430 02/13/2023 LIGHT BULBS 010-20.6010.400000 1,455.38 EDISON LIGHTING SUPPLY LL 43562 03/01/2023 LIGHT BULBS 010-20.6010.400000 1,152.12 HILLYARD INC 605051419 03/09/2023 KLEENEX/TRASH BAGS/TOILE 010-20.6010.590000 419.26 CONSOLIDATED COMMUNIC INV0015145 02/22/2023 FEBRUARY 2023 STATEMENT- 010-20.6010.450000 1,104.60 HEARTLAND CO-OP INV0015183 02/28/2023 FEBRUARY 2023 STATEMENT- 010-20.6010.590000 12.43 DIRECTV X230221 02/21/2023 FEBRUARY 2023 STATEMENT- 010-20.6010.480000 122.24 Department 6010 - PUBLIC WORKS BUILDING Total: 9,321.26 Department: 6150 - PUBLIC WORKS MECHANIC MARK STUCHEL INC. 030323249943 03/13/2023 MICROLITHIUM LONG -NECK 010-20.6150.590000 358.00 3/15/2023 12:22:42 PM Page 3 of 11 Expense Approval Register Packet: APPKT03225 - MARCH 20 2023 COUNCIL MEETING Vendor Name Payable Number Post Date Description (Item) Account Number Amount KIMBALL MIDWEST 100826967 03/07/2023 FITTINGS 010-20.6150.570130 1,023.12 RC WELDING 1036 03/03/2023 PLOW TRUCK SIDE WING MA 010-20.6150.410100 1,159.14 ROCKMOUNT RESEARCH & A 1276447 02/13/2023 MTD FLAP WHEELS 010-20.6150.590000 505.58 HAWKEYE TRUCK EQUIPMEN 157282 02/17/2023 GATE VALVES 010-20.6150.570130 65.00 HAWKEYE TRUCK EQUIPMEN 157399 02/27/2023 PINS 010-20.6150.570130 255.29 LOGOED APPAREL& PROMO 19820 12/22/2022 SWEATSHIRTS -DODGE 010-20.6150.120000 761.78 MURPHY TRACTOR & EQUIP 1991521 03/03/2023 GASKET/COOL-GARD/FILTER 010-20.6150.570130 188.32 AMAZON.COM 1QFH-MlGP-63KC 03/03/2023 OIL DRAIN VALVES 010-20.6150.570130 237.00 AMAZON.COM 1R34-4NTF-1LRC 03/01/2023 EXTENSION CORD REEL 010-20.6150.590000 195.90 LOGOED APPAREL & PROMO 20022 02/24/2023 SHIRTS- GIBSON 010-20.6150.120000 138.70 LOGOED APPAREL & PROMO 20023 02/24/2023 SHIRTS- BAKER 010-20.6150.120000 127.00 TERMINAL SUPPLY CO. 21034-00 02/20/2023 FLEXIBLE LED LIGHTS 010-20.6150.570130 458.48 ARNOLD MOTOR SUPPLY 21NV102596 03/01/2023 OIL FILTER 010-20.6150.570110 13.08 ARNOLD MOTOR SUPPLY 21NV102620 03/02/2023 OIL FILTERS 010-20.6150.570110 26.16 TRUCK EQUIPMENT INC 310613 03/06/2023 REPLACEMENT CHAIN ASSY 010-20.6150.570130 53.80 WAUKEE COMMUNITY SCHO 42 01/31/2023 JANUARY 2023 STATEMENT- 010-20.6150.570000 34.18 SHOTTENKIRK CHEVROLET-P 49209 03/09/2023 BRAKE PADS 010-20.6150.570130 657.98 STIVERS FORD 5036397 02/24/2023 CAP ASY- FUEL TANK 010-20.6150.570130 11.43 MATHESON TRI-GAS INC 52136122 02/28/2023 CYLINDERS 010-20.6150.590000 125.34 NAPA AUTO PARTS STORE 6726-065943 03/07/2023 FILTERS/OIL DRY 010-20.6150.570110 14.26 NAPA AUTO PARTS STORE 6726-065943 03/07/2023 FILTERS/OIL DRY 010-20.6150.570130 57.06 TIFCO INDUSTRIES 71846169 03/02/2023 THREAD SEAL TAPE/DISPOSA 010-20.6150.590000 53.44 BAX SALES INC 73746 03/02/2023 BATTERIES/WASHERS/SCRE 010-20.6150.590000 219.91 BAX SALES INC 73918 03/09/2023 DRILL BITS 010-20.6150.590000 62.53 CERTIFIED LABRATORIES 8128018 02/17/2023 DIESEL EXHAUST FLUID 010-20.6150.570130 389.45 VERIZON WIRELESS 9927639363 02/13/2023 FEBRUARY 2023 STATEMENT 010-20.6150.450000 136.30 MARK STUCHEL INC. CEP32369220 03/02/2023 SOCKET 010-20.6150.590000 65.00 MARK STUCHEL INC. CEP32369280 03/02/2023 ADJUSTABLE WRENCH SET 010-20.6150.590000 135.00 MARK STUCHEL INC. CEP32477790 03/09/2023 MICROLITHIUM LONG -NECK 010-20.6150.590000 329.95 PEAK DISTRIBUTING CG18313 03/02/2023 GLASS CLEANER/BRAKE CLEA 010-20.6150.590000 417.89 WAUKEE HARDWARE & VARI INVO015185 02/28/2023 FEBRUARY 2023 STATEMENT- 010-20.6150.590000 20.94 Department 6150 - PUBLIC WORKS MECHANIC Total: 8,297.01 Department: 6510 - WATER UTILITY MUNICIPAL SUPPLY INC. 0862839-IN 02/21/2023 METERS 510-30.6510.592000 4,278.04 MUNICIPAL SUPPLY INC. 0863329-1 N 02/28/2023 M ETE RS 510-30.6510.592000 4,125.00 MUNICIPAL SUPPLY INC. 0863330-I N 02/28/2023 METERS 510-30.6510.592000 8,220.10 MUNICIPAL SUPPLY INC. 0863846- I N 03/08/2023 METERS 510-30.6510.592000 4,048.80 AMAZON.COM 117V-R1YN-7C6W 03/08/2023 MAGNETIC PUSH PINS 510-30.6510.590000 21.98 HACH COMPANY 13472588 02/20/2023 ORP/REDOX STANDARD SOL 510-30.6510.882421 191.43 UPHDM OCCUPATIONAL ME 168455 02/28/2023 EMPLOYEE DRUG SCREENS 510-30.6510.470000 63.37 LOGOED APPAREL & PROMO 20024 02/24/2023 SHIRTS- KNUDSON 510-30.6510.120000 134.95 IOWA ONE CALL 249164 02/24/2023 JANUARY 2023 STATEMENT 510-30.6510.340000 199.20 UNIVERSITY OF IOWA HYGIE 250296 01/31/2023 TESTING FEES 510-30.6510.250000 887.50 WAUKEE COMMUNITY SCHO 42 01/31/2023 JANUARY 2023 STATEMENT- 510-30.6510.570000 1,155.49 MENARDS 50151 02/14/2023 TAPE MEASURE/SOCKET/TIR 510-30.6510.590000 198.89 VERIZON WIRELESS 9927639363 02/13/2023 FEBRUARY 2023 STATEMENT 510-30.6510.450000 311.00 MID AMERICAN ENERGY FEB236510SUMBILL 02/24/2023 FEBRUARY 2023 STATEMENT 510-30.6510.480000 208.97 DES MOINES WATER WORKS INVO015138 02/27/2023 FEBRUARY 2023 STATEMENT 510-30.6510.650000 216,997.92 DES MOINES WATER WORKS INVO015139 02/27/2023 FEBRUARY 2023 STATEMENT 510-30.6510.650000 33,161.80 DES MOINES WATER WORKS INVO015140 02/27/2023 FEBRUARY 2023 STATEMENT 510-30.6510.650000 34,894.04 XENIA RURAL WATER DISTR INVO015141 03/03/2023 MARCH 2O23 STATEMENT 510-30.6510.650000 70.49 XENIA RURAL WATER DISTR INVO015142 03/03/2023 MARCH 2O23 STATEMENT 510-30.6510.650000 84.54 XENIA RURAL WATER DISTR INVO015143 03/03/2023 MARCH 2O23 STATEMENT 510-30.6510.650000 70.49 XENIA RURAL WATER DISTR INVO015144 03/03/2023 MARCH 2O23 STATEMENT 510-30.6510.650000 70.49 DES MOINES WATER WORKS INVO015182 02/27/2023 LEAK DETECTION SERVICE 510-30.6510.410300 225.00 WAUKEE HARDWARE & VARI INVO015185 02/28/2023 FEBRUARY 2023 STATEMENT- 510-30.6510.590000 65.92 VAN METER INDUSTRIAL INC S012579078.001 02/13/2023 DUCT SEAL/FISH TAPE WITH 510-30.6510.590000 188.11 Department 6510 - WATER UTILITY Total: 309,873.52 Department: 6520 - SANITARY SEWERS & TREATMENT WASTEWATER RECLAMATIO 129668 03/03/2023 APRIL 2023 FEES 520-30.6520.650010 49,747.10 Expense Approval Register Packet: APPKT03225 - MARCH 20 2023 COUNCIL MEETING Vendor Name Payable Number Post Date Description (Item) Account Number Amount WASTEWATER RECLAMATIO 129668 03/03/2023 APRIL 2023 FEES 520-30.6520.882700 74,665.50 UPHDM OCCUPATIONAL ME 168455 02/28/2023 EMPLOYEE DRUG SCREENS 520-30.6520.470000 63.38 LOGOED APPAREL& PROMO 20024 02/24/2023 SHIRTS- KNUDSON 520-30.6520.120000 134.95 WAUKEE COMMUNITY SCHO 42 01/31/2023 JANUARY 2023 STATEMENT- 520-30.6520.570000 2,794.83 AHLERS & COONEY PC 838659 02/28/2023 NORTHEAST OUTFALLSEWE 520-30.6520.883000 1,900.00 VERIZON WIRELESS 9927639363 02/13/2023 FEBRUARY 2023 STATEMENT 520-30.6520.450000 110.98 MID AMERICAN ENERGY FE8236520SUMBILL 02/24/2023 FEBRUARY 2023 STATEMENT 520-30.6520.480000 2,348.36 WAUKEE HARDWARE & VARI INVO015185 02/28/2023 FEBRUARY 2023 STATEMENT- 520-30.6520.590000 12.58 Department 6520 - SANITARY SEWERS & TREATMENT Total: 131,777.68 Department: 6540 - GAS UTILITY INDUSTRIAL SALES COMPAN 1138020-001 03/06/2023 PIPING 540-30.6540.590100 2,013.88 INDUSTRIAL SALES COMPAN 1138083-001 02/28/2023 METERS 540-30.6540.592000 1,919.92 REGAL UNDERGROUND CON 2038 03/08/2023 DIRECTIONAL BORE GAS SER 540-30.6540.880100 420.00 IOWA ONE CALL 249164 02/24/2023 JANUARY 2023 STATEMENT 540-30.6540.340000 199.20 INFRASOURCE CONSTRUCTI 3093258 01/19/2023 ASHLEY ACRES/ASHWORTH 540-30.6540.880100 69,865.14 INFRASOURCE CONSTRUCTI 3095471 03/07/2023 PRAIRIE ROSE 5 540-30.6540.880100 8,937.33 INFRASOURCE CONSTRUCTI 3095472 03/07/2023 GRAND PRAIRIE PKWY 540-30.6540.880100 1,659.04 INFRASOURCE CONSTRUCT] 3095473 03/07/2023 DOUGLAS PKWY 540-30.6540.880100 3,973.90 INFRASOURCE CONSTRUCT] 3095474 03/07/2023 1008 CREEKSIDE DR 540-30.6540.880100 871.91 WAUKEE COMMUNITY SCHO 42 01/31/2023 JANUARY 2023 STATEMENT- 540-30.6540.570000 1,956.24 MATHESON TRI-GAS INC 52136122 02/28/2023 CYLINDERS 540-30.6540.590000 44.80 KOONS GAS MEASUREMENT 56037 03/03/2023 METER REPAIR 540-30.6540.592000 1,840.14 UNIVERSAL PRINTING SERVI 78539 02/20/2023 FEBRUARY 2023 STATEMENT 540-30.6540.210000 245.43 VERIZON WIRELESS 9927639363 02/13/2023 FEBRUARY 2023 STATEMENT 540-30.6540.450000 250.00 MID AMERICAN ENERGY FEB236540SUMBILL 02/24/2023 FEBRUARY 2023 STATEMENT 540-30.6540.480000 249.61 UTILITY SAFETY AND DESIGN IN20230631 02/23/2023 FEBRUARY 2023 RETAINER F 540-30.6540.230000 2,275.00 UTILITY SAFETY AND DESIGN IN20230870 02/23/2023 SHRIMP/DIMP TOOL RENEW 540-30.6540.590000 454.25 UTILITY SAFETY AND DESIGN IN20230968 02/24/2023 PURGE PROCEDURES & REC 540-30.6540.230000 805.00 BECKY MCALLISTER INVO015150 02/27/2023 WATER HEATER REBATE 540-30.6540.685400 50.00 ALISSA LILLA INVO015151 02/06/2023 THERMOSTAT REBATE 540-30.6540.685400 30.00 RON & LINDA DICKERSON INVO015152 02/10/2023 FURNACE REBATE 540-30.6540.685400 75.00 ARNOLD ZEDIKER INVO015153 02/16/2023 FURNACE REBATE 540-30.6540.685400 75.00 JOELJELLINGS INVO015154 02/20/2023 FURNACE & THERMOSTAT RE 540-30.6540.685400 180.00 DAVE OLSEN INVO015155 02/23/2023 FURNACE REBATE 540-30.6540.685400 75.00 JAMES WATERS INVO015184 02/16/2023 WATER HEATER REBATE 540-30.6540.685400 50.00 CENTURYLINK P-2729SOMB 02/21/2023 BURIED CABLE DAMAGES 540-30.6540.340000 4,965.94 Department 6540 - GAS UTILITY Total: 103,481.73 Department: 6550 - UTILITY BILLING PITNEY BOWES 3317076465 02/24/2023 QUARTERLY LEASE OF DIGITA 570-30.6550.390000 1,991.61 Department 6550 - UTILITY BILLING Total: 1,991.61 Department: 7100 - STREETS ARNOLD MOTOR SUPPLY 21NV102842 03/06/2023 DEGREASER 060-30.7100.590000 24.97 BLUE RIDGE SOLUTIONS 234-09-23 02/21/2023 ASPHALT PATCH KITS 060-30.7100.590400 1,018.96 GRIMES ASPHALT & PAVING 23592 03/03/2023 COLD MIX 060-30.7100.590400 1,172.80 MARTIN MARIETTA AGGREG 38135458 02/14/2023 ROAD STONE 060-30.7100.590300 3,415.70 WAUKEE COMMUNITY SCHO 42 01/31/2023 JANUARY 2023 STATEMENT- 060-30.7100.570000 5,434.09 MENARDS 51177 03/02/2023 CHAIN/LINKS/BOLTS/HOOKS 060-30.7100.590000 82.75 IOWA PLAINS SIGNING INC 53869 11/02/2022 TRAFFIC CONTROL SIGN 060-30.7100.390000 240.00 IOWA SIGNAL INC 5511 03/10/2023 TEMPORARY SIGNAL MAINT 060-30.7100.410300 1,200.00 IOWA SIGNAL INC 5513 03/10/2023 TEMPORARY TRAFFIC SIGNA 060-30.7100.410300 300.00 BAX SALES INC 73746 03/02/2023 BATTERIES/WASHERS/SCRE 060-30.7100.590000 172.25 AHLERS & COONEY PC 838660 02/28/2023 2023 ASPHALT OVERLY IMP C 060-30.7100.230000 1,900.00 VERIZON WIRELESS 9927639363 02/13/2023 FEBRUARY 2023 STATEMENT 060-30.7100.450000 142.71 IOWA DEPT OF TRANSPORTA CI-0013603 02/01/2023 SIGN TUBING/ANCHORS 060-30.7100.590600 3,180.50 WAUKEE HARDWARE & VARI INVO015185 02/28/2023 FEBRUARY 2023 STATEMENT- 060-30.7100.590000 77.74 CYPRESS SOLUTIONS INC INV-005372 03/01/2023 MARCH 2O23 VUE SUBSCRIP 060-30.7100.280000 475.00 Department 7100 - STREETS Total: 18,837.47 Department: 7850 - TIF DEBT SERVICE AHLERS & COONEY PC 839648 02/27/2023 APPLE DEV AGREEMENT 126-30.7850.230000 561.00 3/15/2023 12:22:42 PM Page 5 of 11 Expense Approval Register Packet: APPKT03225 - MARCH 20 2023 COUNCIL MEETING Vendor Name Payable Number Post Date Description (Item) Account Number Amount AHLERS & COONEY PC 839650 02/27/2023 IOWA YOUTH ATHLETIC FOU 132-30.7850.230000 528.00 AHLERS & COONEY PC 839651 02/27/2023 KETTLESTONE RESIDENTIAL 131-30.7850.230000 703.00 AHLERS & COONEY PC 839652 02/27/2023 KETTLESTONE RESIDENTIAL 131-30.7850.230000 1,287.00 AHLERS & COONEY PC 839653 02/27/2023 KETTLESTONE COMMERCIAL 132-30.7850.230000 323.50 AHLERS & COONEY PC 839654 02/27/2023 QUARTER COMMERCIAL URP 130-30.7850.230000 157.00 AHLERS & COONEY PC 839655 02/27/2023 QUARTER DA- 2022 130-30.7850.230000 79.00 AHLERS & COONEY PC 839656 02/27/2023 AMEND NO. 7 TO CONSOLID 124-30.7850.230000 78.00 AHLERS & COONEY PC 839657 02/27/2023 FIRST AMEND TO THE QUAR 130-30.7850.230000 370.00 Department 7850 - TIF DEBT SERVICE Total: 4,086.50 Department: 8300 - ADMINISTRATION SIMMERING-CORY INC 2023-IC-0061 03/O1/2023 FEBRUARY 2023 SUPPLEMEN 010-60.8300.230000 345.00 MID AMERICAN ENERGY 536583194 02/24/2023 FINAL BILL 010-60.8300.390400 2.10 UNIVERSAL PRINTING SERVI 78539 02/20/2023 FEBRUARY 2023 STATEMENT 010-60.8300.210000 245.43 DALLAS COUNTY LOCAL HOU CE-2023-00010030 12/06/2022 FY23 CONTRIBUTION 010-60.8300.459000 4,000.00 DALLAS COUNTY RECORDER INV0015148 02/28/2023 FEBRUARY 2023 STATEMENT 010-60.8300.230000 786.00 Department 8300 - ADMINISTRATION Total: 5,378.53 Department: 8310 - CITY HALL STAPLES BUSINESS CREDIT 7374530267-0-1 03/02/2023 LANYARDS HOOK 010-60.8310.590000 10.49 MID AMERICAN ENERGY FEB238310SUMBILL 02/24/2023 FEBRUARY 2023 STATEMENT 010-60.8310.480000 882.87 SPLAW PROPERTIES LLC INV0015146 03/21/2023 MARCH 2O23 ANNEX LEASE 010-60.8310.290000 107.50 SPLAW PROPERTIES LLC INV0015146 03/21/2023 MARCH 2O23 ANNEX LEASE 010-60.8310.390100 4,397.33 Department 8310 - CITY HALL Total: 5,398.19 Department: 8350 - HUMAN RESOURCES UNIVERSAL PRINTING SERVI 78539 02/20/2023 FEBRUARY 2023 STATEMENT 010-60.8350.210000 245.43 Department 8350 - HUMAN RESOURCES Total: 245.43 Department: 8400 - FINANCIAL ADMINISTRATION PITNEY BOWES 3317076465 02/24/2023 QUARTERLY LEASE OF DIGITA 010-60.8400.390000 699.00 Department 8400 - FINANCIAL ADMINISTRATION Total: 699.00 Department: 8600 - CITY ATTORNEY AHLERS & COONEY PC 838567 02/21/2023 2023 LEGISLATIVE- BOND IM 010-60.8600.230000 154.00 Department 8600 - CITY ATTORNEY Total: 154.00 Department: 8700 - DEVELOPMENT SERVICES UPHDM OCCUPATIONAL ME 168455 02/28/2023 EMPLOYEE DRUG SCREENS 010-50.8700.470000 51.75 Department 8700 - DEVELOPMENT SERVICES Total: 51.75 Department: 8750 - SUGAR CREEK MUNICIPAL PLASTIC RECYCLING OF IOW 0137270-IN O1/18/2023 TEE BLOCK MATERIAL 750-80.8750.410300 84.96 EASY PICKER GOLF PRODUCT 0187408-IN 02/28/2023 HOLE CUTTER/REPLACEMEN 750-80.8750.410100 286.40 EASY PICKER GOLF PRODUCT 0187519-IN 03/02/2023 GOLF BALL BASKETS 750-80.8750.590000 294.49 ULINE 160586040 03/01/2023 PARKING SIGNS 750-80.8750.410300 521.96 TAYLOR MADE GOLF COMPA 36111654 07/20/2022 GOLF BALLS 750-80.8750.651000 113.58 TAYLOR MADE GOLF COMPA 36117938 09/24/2022 GOLF BALLS 750-80.8750.651000 113.58 PEPSI 51480210 03/10/2023 POP/WATER 750-80.8750.650150 1,359.33 D & K PRODUCT INC. 637771N 03/02/2023 INFIELD MIX 750-80.8750.410300 3,825.00 SRIXON 7309718 SO 02/08/2023 GOLF BALLS 750-80.8750.651000 563.40 SRIXON 7315740 SO 02/13/2023 GOLF BALLS 750-80.8750.651000 480.00 SRIXON 7317235 SO 02/14/2023 GOLF BALLS 750-80.8750.651000 189.60 CALLAWAY GOLF 936044579 02/27/2023 GOLF BALLS 750-80.8750.651000 124.08 MID AMERICAN ENERGY FEB238750SUMBILL 02/24/2023 FEBRUARY 2023 STATEMENT 750-80.8750.480000 186.91 P & W GOLF SUPPLY LLC INV107906 03/08/2023 TOKENS 750-80.8750.590000 248.65 ALL STAR PRO GOLF INV30999 03/07/2023 GOLF TEES 750-80.8750.651000 914.99 ONE SOURCE PLUS4380-20230228 02/28/2023 PRE -EMPLOYMENT BACKGR 750-80.8750.470000 55.00 DIRECTV X230301 03/O1/2023 MARCH 2O23 STATEMENT- S 750-80.8750.480000 21.25 Department 8750 - SUGAR CREEK MUNICIPAL Total: 9,383.18 Department: 8800 - INFORMATION TECHNOLOGY WAUKEE COMMUNITY SCHO 42 01/31/2023 1ANUARY 2023 STATEMENT- I 010-60.8800.570000 35.11 Department 8800 - INFORMATION TECHNOLOGY Total: 35.11 3/15/2023 12:22:42 PM Expense Approval Register Packet: APPKT03225 - MARCH 20 2023 COUNCIL MEETING Vendor Name Payable Number Post Date Description (Item) Account Number Amount Department: 8900 - ENGINEERING WAUKEE COMMUNITY SCHO 42 01/31/2023 1ANUARY 2023 STATEMENT- 010-20.8900.570000 491.89 VERIZON WIRELESS 9927639363 02/13/2023 FEBRUARY 2023 STATEMENT 010-20.8900.450000 306.84 WAUKEE HARDWARE & VARI INVO015185 02/28/2023 FEBRUARY 2023 STATEMENT- 010-20.8900.590000 10.00 US POSTAL SERVICE INVO015187 03/21/2023 ENGINEERING BULK MAILIN 010-20.8900.360000 176.47 Department 8900 - ENGINEERING Total: 985.20 Department: 8950 - GIS VERIZON WIRELESS 9927639363 02/13/2023 FEBRUARY 2023 STATEMENT 010-20.8950.450000 151.03 Department 8950 - GIS Total: 151.03 Grand Total: 979,826.50 3/15/2023 12:22:42 PM Page 7 of it Expense Approval Register Packet: APPKT0322S - MARCH 20 2023 COUNCIL MEETING Fund Summary Fund 010-GENERAL FUND 011- GENERAL FUND - HOTEL / MOTEL TAX 060 - ROAD USE TAX FUND 124 - GATEWAY URBAN RENEWAL 126- WAUKEE WEST URBAN RENEWAL 130 - QUARTER COMMERICAL TIF 131- KETTLESTONE RESIDENTIAL TIF 132 - KETTLESTONE COMMERCIAL TIF 327 - CAPITAL PROJECTS 510 - WATER UTILITY FUND 520 - WASTE WATER UTILITY FUND 540 - GAS UTILITY FUND 560 - STORM WATER UTILITY FUND 570 - UTILITY BILL FUND 590 - SOLID WASTE COLLECT & RCY 750 - GOLF COURSE FUND Account Number 010-10.1100.120000 010-10.1100.230000 010-10.1100.280000 010-10.1100.400000 010-10.1100.450000 010-10.1100.460200 010-10.1100.470000 010-10.1100.540000 010-10.1100.570000 010-10.1100.580000 010-10.1100.590000 010-10.1400.400000 010-10.1400.410000 010-10.1400.410100 010-10.1400.450000 010-10.1400.570000 010-10.1400.590000 010-10.1500.3529900 010-10.1500.400000 010-10.1500.450000 010-10.1500.570000 010-10.1500.590000 010-10.1500.590050 010-10.1900.450000 010-10.1900.570000 010-20.6000.410000 010-20.6000.450000 010-20.6000.570000 010-20.6010.400000 010-20.6010.400100 010-20.6010.450000 010-20.6010.480000 010-20.6010.510100 010-20.6010.580000 010-20.6010.590000 010-20.6150.120000 010-20.6150.410100 010-20.6150.450000 010-20.6150.570000 Grand Total Account Summary Account Name UNIFORMS CONSULTANT & PROFES DUES, MEMBERSHIPS & REPAIR/MAINTENANCE TELEPHONE PD COMMUNITY POLICI TRAINING/TRAVELEXPE MINOR EQUIPMENT FUEL OFFICE SUPPLIES OPERATING SUPPLIES & REPAIR/MAINTENANCE REPAIR OF VEHICLES REPAIR/MAINTENANCE TELEPHONE FUEL OPERATING SUPPLIES & AMBULANCE TRANSPOR REPAIR/MAINTENANCE TELEPHONE FUEL OPERATING SUPPLIES & MEDICAL SUPPLIES TELEPHONE FUEL REPAIR OF VEHICLES TELEPHONE FUEL REPAIR/MAINTENANCE CUSTODIAL SERVICES TELEPHONE UTILITY SERVICES GARBAGE PICK UP OFFICE SUPPLIES OPERATING SUPPLIES & UNIFORMS REPAIR/MAINTENANCE TELEPHONE FUEL Expense Amount 91,547.48 9,583.04 41,124.44 78.00 561.00 606.00 1,990.00 851.50 48,294.56 335,239.36 136,141.21 148,854.99 2,834.08 1,991.61 150,696.49 9,432.74 979,826.50 Expense Amount 1,914.65 170.00 720.00 4,037.50 126.50 1,506.71 14,191.00 467.99 3,229.19 426.31 351.18 905.25 4,440.92 840.36 69.36 834.92 293.44 1,336.81 905.25 98.67 834.92 105.71 455.00 40.01 288.12 175.00 398.14 307.59 5,417.60 1,567.11 1,104.60 122.24 257.00 79.92 772.79 1,027.48 1,159.14 136.30 34.18 3/15/2023 12:22:42 PM Expense Approval Register Packet: APPKT03225 - MARCH 20 2023 COUNCIL MEETING Account Summary Account Number Account Name Expense Amount 010-20.6150.570110 COGS - FILTERS 53.50 010-20.6150.570130 COGS - PARTS 3,396.93 010-20.6150.590000 OPERATING SUPPLIES & 2,489.48 010-20.8900.360000 POSTAGE & SHIPPING 176.47 010-20.8900.450000 TELEPHONE 306.84 010-20.8900.570000 FUEL 491.89 010-20.8900.590000 OPERATING SUPPLIES & 10.00 010-20.8950.450000 TELEPHONE 151.03 010-2030500 SALES TAX COLLECTED P 147.00 010-40.3100.270110 COPIER / PRINTER LEASE 118.45 010-40.3100.400100 CUSTODIAL SERVICES 1,810.29 010-40.3100.460300 PROGRAMS 100.00 010-40.3100.460400 SUMMER READING CLU 65.76 010-40.3100.480000 UTILITY SERVICES 673.26 010-40.3100.580000 OFFICE SUPPLIES 32.63 010-40.3100.590000 OPERATING SUPPLIES & 315.28 010-40.4100.210000 PUBLIC NOTIFICATION/A 122.71 010-40.4100.410100 REPAIR/MAINTENANCE 769.30 010-40.4100.480000 UTILITY SERVICES 551.04 010-40.4100.540000 MINOR EQUIPMENT 2,478.47 010-40.4100.570000 FUEL 524.08 010-40.4100.590000 OPERATING SUPPLIES & 304.88 010-40.4100.590010 OPERATING SUPPLIES-D 468.62 010-40.4200.210000 PUBLIC NOTIFICATION/A 122.71 010-40.4200.350100 PRINTING 1,550.00 010-40.4200.460500 SUMMER RECREATION P 2,176.77 010-40.4200.460510 YOUTH SPORTS LEAGUE 14.45 010-40.4200.460550 WINTER RECREATION PR 3,740.80 010-40.4200.570000 FUEL 28.76 010-40.4200.580000 OFFICE SUPPLIES 214.38 010-40.4210.410100 REAPIR/MAINTENANCE 119.19 010-40.4210.580000 OFFICE SUPPLIES 65.07 010-40.4210.590150 CHAULK & FIELD DRY 389.20 010-40.4210.590200 BALL FIELD MATERIAL 3,940.00 010-40.4300.400000 REPAIR/MAINTENANCE 39.17 010-40.4300.400100 CUSTODIAL SERVICES 310.72 010-40.4300.480000 UTILITY SERVICES 167.48 010-50.8700.470000 TRAINING/TRAVEL EXPE 51.75 010-60.8300.210000 PUBLIC NOTIFICATION/A 245.43 010-60.8300.230000 CONSULTANT & PROFES 1,131.00 010-60.8300.390400 RENTAL PROP EXPENSES 2.10 010-60.8300.459000 CONTRIBUTIONS 4,000.00 010-60.8310.290000 CITY HALL ANNEX INSUR 107.50 010-60.8310.390100 CITY HALL ANNEX LEASE 4,397.33 010-60.8310.480000 UTILITY SERVICES 882.87 010-60.8310.590000 OPERATING SUPPLIES & 10.49 010-60.8350.210000 PUBLIC NOTIFICATION/A 245.43 010-60.8400.390000 RENTAL/LEASE OF EQUIP 699.00 010-60.8600.230000 CONSULTANT & PROFES 154.00 010-60.8800.570000 FUEL 35.11 011-40.0000.459001 BRAVO GREATER DES M 9,583.04 060-30.1600.480000 UTILITY SERVICES 20,485.36 060-30.1601.480000 UTILITY SERVICES 1,801.61 060-30.7100.230000 CONSULTANT & PROFES 1,900.00 060-30.7100.280000 DUES, MEMBERSHIPS & 475.00 060-30.7100.390000 RENTAL/LEASE OF EQUIP 240.00 060-30.7100.410300 REPAIR/MAINTENANCE 1,500.00 060-30.7100.450000 TELEPHONE 142.71 3/15/2023 12:22:42 PM Page 9 of 11 Expense Approval Register Packet: APPKT03225 - MARCH 20 2023 COUNCIL MEETING Account Summary Account Number Account Name Expense Amount 060-30.7100.570000 FUEL 5,434.09 060-30.7100.590000 OPERATING SUPPLIES & 357.71 060-30.7100.590300 ROADSTONE 3,415.70 060-30.7100.590400 ROAD REPAIR -PATCH 2,191.76 060-30.7100.590600 STREET SIGNS 3,180.50 124-30.7850.230000 CONSULTANT/PROFESSI 78.00 126-30.7850.230000 CONSULTANT/PROFESSI 561.00 130-30.7850.230000 CONSULTANT & PROFES 606.00 131-30.7850.230000 CONSULTANT & PROFES 1,990.00 132-30.7850.230000 CONSULTANT & PROFES 851.50 327-90.1100.235000 PUBLIC SAFETY BUILDIN 17,114.56 327-90.4100.880091 STRATFORD CROSSING P 29,280.00 327-90.5020.881110 HEART OF WARRIOR/AS 1,900.00 510-2030500 SALES TAX COLLECTED P 25,365.84 510-30.6510.120000 UNIFORMS 134.95 510-30.6510.250000 TESTING FEES 887.50 510-30.6510.340000 MISCELLANEOUS CONTR 199.20 510-30.6510.410300 REPAIR/MAINTENANCE F 225.00 510-30.6510.450000 TELEPHONE 311.00 510-30.6510.470000 TRAINING/TRAVEL EXPE 63.37 510-30.6510.480000 UTILITY SERVICES 208.97 510-30.6510.570000 FUEL 1,155.49 510-30.6510.590000 OPERATING SUPPLIES & 474.90 510-30.6510.592000 METER PURCHASE 20,671.94 510-30.6510.650000 COST OF GOODS SOLD 285,349.77 510-30.6510.882421 ASR FACILITY 191.43 520-2030500 SALES TAX COLLECTED P 4,363.53 520-30.6520.120000 UNIFORMS 134.9S 520-30.6520.450000 TELEPHONE 110.98 520-30.6520.470000 TRAINING/TRAVEL EXPE 63.38 520-30.6520.480000 UTILITY SERVICES 2,348.36 520-30.6520.570000 FUEL 2,794.83 520-30.6520.590000 OPERATING SUPPLIES & 12.58 520-30.6520.650010 WRA OPERATING & MAI 49,747.10 520-30.6520.882700 WRA FEES 74,665.50 520-30.6520.883000 OUTFALL SEWER 1,900.00 540-2030500 SALES TAX COLLECTED P 45,373.26 540-30.6540.210000 PUBLIC NOTIFICATION/A 245.43 540-30.6540.230000 CONSULTANT & PROFES 3,080.00 540-30.6540.340000 MISCELLANEOUS CONTR 5,165.14 540-30.6540.450000 TELEPHONE 250.00 540-30.6540.480000 UTILITY SERVICES 249.61 540-30.6540.570000 FUEL 1,956.24 540-30.6540.590000 OPERATING SUPPLIES & 499.05 540-30.6540.590100 DEVELOPER MATERIALS 2,013.88 540-30.6540.592000 METER PURCHASE 3,760.06 540-30.6540.685400 GAS REBATE 535.00 540-30.6540.880100 DISTRIBUTION SYSTEM 1 85,727.32 560-2030500 SALES TAX COLLECTED P 2,490.37 560-80.5300.450000 TELEPHONE 232.34 560-80.5300.570000 FUEL 111.37 570-30.6550.390000 RENTAL/LEASE OF EQUIP 1,991.61 590-30.5400.231300 RESIDENTIAL SOLID WAS 150,696.49 750-2030500 SALES TAX COLLECTED P 49.56 750-80.8750.410100 REPAIR/MAINTENANCE 286.40 750-80.8750.410300 REPAIR/MAINTENANCE F 4,431.92 750-80.8750.470000 TRAINING/TRAVEL EXPE 55.00 750-80.8750.480000 UTILITY SERVICES 208.16 Expense Approval Register Packet: APPKT03225 - MARCH 20 2023 COUNCIL MEETING Account Summary Account Number Account Name Expense Amount 750-80.8750.590000 OPERATING SUPPLIES & 543.14 750-80.8750.650150 COGS-POP/WATER 1,359.33 750-80.8750.651000 PRO SHOP MERCHANDIS 2,499.23 Grand Total: 979,826.50 Project Account Summary Project Account Key Expense Amount **None** 929,440.51 ASR PHS 2 CONSULTING- 191.43 HEART OF WARRIOR WEST EXT CONSULTING- 1,900.00 NE OUTFALL SEWER CONSULTING- 1,900.00 PUBLIC SAFETY BUILDING CONSTULTING 17,114.56 STRATFORD CROSSING PARK CONSULTING - 29,280.00 Grand Total: 979,826.50 3/15/2023 12:22:42 PM Page 11 of 11 0 City of Waukee, IA �Ghuicee Check Report By Check Number Date Range: 03/02/2023 - 03/06/2023 3/15/2023 12:24:53 PM Page 1 of 2 Check Report Date Range: 03/02/2023 - 03/06/2023 3/15/2023 12:24:53 PM Page 2 of 2 a 0 Waukee City of Waukee, IA Check Report By Check Number Date Range: 03/08/2023 - 03/15/2023 3/15/2023 12:26:01 PM Page 1 of 2 Check Report w Date Range: 03/08/2023-03/iS/2023 3/15/2023 12:26:01 PM Page 2 of 2 Council Payroll Reimbursements City of Waukee, IA By Check Number 41, Date Range: 03/02/2023 - 03/15/2023 Vendor Number Vendor Name Payment Date Payment Type Discount Amount Payment Amount Number Bank Code: AP-WAUKEE STATE 034875 CITY OF WAUKEE 03/13/2023 Regular 0.00 18,293.82 155296 Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INVO015162 Invoice 03/17/2023 CELL PHONE REIMBURSEMENT 0.00 117.50 010-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 85.00 060-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 15.00 540-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 15.00 750-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 2.50 INVO015163 Invoice 03/17/2023 LIFE INSURANCE PREMIUM 0.00 955.92 010-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 779.75 060-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 48.74 510-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 14.19 520-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 14.11 540-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 42.20 5 0� PAYROLL PAYABLES LIFE INSURANCE PREMIUM 32.68 570-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 21.05 750-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 3.20 INVO015164 Invoice 03/17/2023 STD INSURANCE PREMIUM 0.00 1,150.67 010-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 923.96 060-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 81.10 510-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 45.53 520-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 45.32 540.20330001? PAYROLL PAYABLES STD INSURANCE PREMIUM 20.82 560.2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 24.07 750-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 9.87 INV00151F$ Invoice 03/17/2023 HEALTH INSURANCE DEDUCTION 0.00 10,650.15 010-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 8,206.31 060-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 1,003.25 510-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 231.58 520-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 231.47 540-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 617.40 560-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 154.35 750-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 205.79 INVO015169 Invoice 03/17/2023 HEALTH INSURANCE DEDUCTION 0.00 2,314.65 010-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 2,017.90 510-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 89.09 520-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 89.01 540-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 29.70 560-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 29.60 570-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 59.35 INVO015170 Invoice 03/17/2023 HEALTH INSURANCE DEDUCTION 0.00 2,130.60 010-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 1,562.44 510-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 142.07 520-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 142.01 560-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 142.04 570-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 142.04 INVO015171 Invoice 03/17/2023 HEALTH INSURANCE DEDUCTION 0.00 974.33 010-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 835.14 060-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 139.19 036350 IOWA DEPT OF HUMAN SERVICES 03/13/2023 Regular 0.00 331.03 155297 3/14/2023 9:32:49 AM Page 1 of 4 Council Payroll Reimbursements Date Range: 03/02/2023 - 03/25/2023 Vendor Number Vendor Name Payment Date Payment Type Discount Amount Payment Amount Number Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0015156 Invoice 03/17/2023 CHILD SUPPORT 0.00 331.03 010-2011300 CHILD SUPPORT PAYABLE CHILD SUPPORT 331.03 091000 ICMA RETIREMENT TRUST 457 03/13/2023 Regular 0.00 15,513.23 155298 Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0015157 Invoice 03/17/2023 ICMA 457 ROTH CONTRIBUTION 0.00 1,022.00 010-2011200 IPERS WITHHOLDING PAY ICMA 457 ROTH CONTRIBUTION 997.00 560-2011200 IPERS WITHHOLDING PAY ICMA 457 ROTH CONTRIBUTION 25.00 INV0015158 Invoice 03/17/2023 ICMA 401A 0.00 4,155.00 010-2011200 IPERS WITHHOLDING PAY ICMA 401A 4,155.00 INV0015159 Invoice 03/17/2023 ICMA ROTH CONTRIBUTION 0.00 1,653.92 010-2011200 IPERS WITHHOLDING PAY ICMA ROTH CONTRIBUTION 1,303.92 060-2011200 IPERS WITHHOLDING PAY ICMA ROTH CONTRIBUTION 50.00 510-2011200 IPERS WITHHOLDING PAY ICMA ROTH CONTRIBUTION 62.51 520-2011200 IPERS WITHHOLDING PAY ICMA ROTH CONTRIBUTION 62.51 540-2011200 IPERS WITHHOLDING PAY ICMA ROTH CONTRIBUTION 112.51 560-2011200 IPERS WITHHOLDING PAY ICMA ROTH CONTRIBUTION 62.47 INV0015160 Invoice 03/17/2023 ICMA RETIREMENT 0.00 5,067.00 010-2011200 IPERS WITHHOLDING PAY ICMA RETIREMENT 4,892.00 060-2011200 IPERS WITHHOLDING PAY ICMA RETIREMENT 25.00 540-2011200 IPERS WITHHOLDING PAY ICMA RETIREMENT 50.00 570-2011200 IPERS WITHHOLDING PAY ICMA RETIREMENT 100.00 INVO015161 Invoice 03/17/2023 ICMA 0.00 3,615.31 010-2011200 IPERS WITHHOLDING PAY ICMA 3,615.31 099999 EFTPS 03/13/2023 Regular 0.00 116,624.98 155299 Payable # Payable Type Post Date Payable Description _ Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0015175 Invoice 03/17/2023 FICA TAX WITHHOLDING 0.00 57,877.02 010-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 47,833.52 060-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 2,811.98 510-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 1,460.96 520-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 1,460.54 540-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 2,087.00 560-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 780.30 570-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 930.26 750-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 512.46 INV0015176 Invoice 03/17/2023 FEDERAL WITHHOLDING TAXES 0.00 45,212.10 010-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 37,576.76 060-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 1,874.45 510-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 1,043.55 520-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 1,043.29 540-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 1,895.59 560-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 564.72 570-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 920.10 750-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 293.64 INV0015177 Invoice 03/17/2023 MEDICARE TAX WITHHOLDING 0.00 13,535.86 010-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 11,186.96 060-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 657.62 510-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 341.82 520-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 341.46 540-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 488.08 560-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 182.50 570-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 217.58 750-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 119.84 3/14/2023 9:32:49 AM Page 2 of 4 Council Payroll Reimbursements Date Range: 03/02/2023 - 03/15/2023 Vendor Number Vendor Name Payment Date Payment Type Discount Amount Payment Amount Number 099300 ISOLVED BENEFIT SERVICES INC 03/07/2023 EFT 0.00 614.20 255313 Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount W25725 Invoice 02/28/2023 FEB'23 PEPM FEES 0.00 614.20 010-60.8350.230000 CONSULTANT & PROFESSI FEB'23 PEPM FEES 614.20 099300 ISOLVED BENEFIT SERVICES INC 03/13/2023 EFT 0.00 9,059.34 255315 Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INVO015165 Invoice 03/17/2023 LIMITED PURPOSE FLEX MEDICAL DEDUC 0.00 83.32 010-2030000 PAYROLL PAYABLES LIMITED PURPOSE FLEX MEDICA 62.49 060-2030000 PAYROLL PAYABLES LIMITED PURPOSE FLEX MEDICA 20.83 INVO015166 Invoice 03/17/2023 SECTION 125 MEDICAL DEDUCTIONS 0.00 5,232.22 010-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCT] 4,003.05 060-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 354.54 510-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 121.00 520-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 120.64 540-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 393.73 560-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 102.06 570-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 102.49 750-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 34.71 INVO015167 Invoice 03/17/2023 SECTION 125 DAYCARE DEDUCTIONS 0.00 3,743.80 010-2030000 PAYROLL PAYABLES SECTION 125 DAYCARE DEDUCTI 3,160.47 060-2030000 PAYROLL PAYABLES SECTION 125 DAYCARE DEDUCTI 208.33 510-2030000 PAYROLL PAYABLES SECTION 125 DAYCARE DEDUCTI 52.09 520-2030000 PAYROLL PAYABLES SECTION 125 DAYCARE DEDUCTI 52.08 560-2030000 PAYROLL PAYABLES SECTION 125 DAYCARE DEDUCTI 208.33 750-2030000 PAYROLL PAYABLES SECTION 125 DAYCARE DEDUCTI 62.50 208650 TREASURER STATE OF IOWA 03/13/2023 EFT 0.00 17,662.19 255316 Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INVO015174 Invoice 03/17/2023 STATE WITHHOLDING TAXES 0.00 17,662.19 010-2011100 STATE TAX WITHHOLDING STATE WITHHOLDING TAXES 14,556.58 060-2011100 STATE TAX WITHHOLDING STATE WITHHOLDING TAXES 839.03 510-2011100 STATE TAX WITHHOLDING STATE WITHHOLDING TAXES 447.97 520-2011100 STATE TAX WITHHOLDING STATE WITHHOLDING TAXES 447.74 540-2011100 STATE TAX WITHHOLDING STATE WITHHOLDING TAXES 687.07 560-2011100 STATE TAX WITHHOLDING STATE WITHHOLDING TAXES 236.00 570-2011100 STATE TAX WITHHOLDING STATE WITHHOLDING TAXES 315.27 750-2011100 STATE TAX WITHHOLDING STATE WITHHOLDING TAXES 132.53 Bank Code AP Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 16 4 0.00 150,763.06 Manual Checks 0 0 0.00 0.00 Voided Checks 0 0 0.00 0.00 Bank Drafts 0 0 0.00 0.00 EFT's 5 3 0.00 27,335.73 21 7 0.00 178,098.79 3/14/2023 9:32:49 AM Page 3 of 4 Council Payroll Reimbursements Date Range: 03/02/2023 - 03/25/2023 All Bank Codes Check Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 16 4 0.00 150,763.06 Manual Checks 0 0 0.00 0.00 Voided Checks 0 0 0.00 0.00 Bank Drafts 0 0 0.00 0.00 EFT's 5 3 0.00 27,335.73 21 7 0.00 178,098.79 Fund Summary Fund Name Period Amount 999 POOLED CASH 3/2023 178,098.79 178,098.79 3/14/2023 9:32:49 AM Page 4 of _, Utility Refund Check Report City of Waukee, IA uiEa)kee Account Number Name Date Type 19-00941-01 Barham, Kayla E 3/8/2023 Refund 16-00385-03 Bolling, Catara L 3/8/2023 Refund 19-00911-01 Cone, Morgan M 3/8/2023 Refund 19-00975-01 Crozier, Coleman 1 3/8/2023 Refund 17-00412-03 Davis, Craig A 3/8/2023 Refund 19-00960-01 Diaz, Vianca 3/8/2023 Refund 01-14603-10 Edwards, Joseph W 3/8/2023 Refund 16-00482-06 Emery, Laura C 3/8/2023 Refund 16-00831-07 Garrin, Frederick L 3/8/2023 Refund Date Range: 3/2/2023 - 3/15/2023 Adi Amount Reference Packet Receipt Type 80.32 Check #: 155284 UBPKT12485 Revenue Code Current Plus 1 Plus 2 Plus 3 Plus 4 Balance 996 -35.56 115.88 0.00 0.00 0.00 80.32 Aging Total: -35.56 115.88 0.00 0.00 0.00 80.32 60.19 Check M 155274 UBPKT12485 Revenue Code Current Plus 1 Plus 2 Plus 3 Plus 4 Balance 996 60.19 0.00 0.00 0.00 0.00 60.19 Aging Total: 60.19 0.00 0.00 0.00 0.00 60.19 15.22 Check M 155283 UBPKT12485 Revenue Code Current Plus 1 Plus 2 Plus 3 Plus 4 Balance 996 15.22 0.00 0.00 0.00 0.00 15.22 Aging Total: 15.22 0.00 0.00 0.00 0.00 15.22 66.91 Check #: 155287 UBPKT12485 Revenue Code Current Plus 1 Plus 2 Plus 3 Plus 4 Balance 996 0.00 66.91 0.00 0.00 0.00 66.91 Aging Total: 0.00 66.91 0.00 0.00 0.00 66.91 46.13 Check 155278 UBPKT12485 Revenue Code Current Plus 1 Plus 2 Plus 3 Plus 4 Balance 996 46.13 0.00 0.00 0.00 0.00 46.13 Aging Total: 46.13 0.00 0.00 0.00 0.00 46.13 100.00 Check M 155285 UBPKT12485 Revenue Code Current Plus 1 Plus 2 Plus 3 Plus 4 Balance 996 100.00 0.00 0.00 0.00 0.00 100.00 Aging Total: 100.00 0.00 0.00 0.00 0.00 100.00 75.11 Check #: 155272 UBPKT12485 Revenue Code Current Plus 1 Plus 2 Plus 3 Plus 4 Balance 996 75.11 0.00 0.00 0.00 0.00 75.11 Aging Total: 75.11 0.00 0.00 0.00 0.00 75.11 67.40 Check #: 155275 UBPKT12485 Revenue Code Current Plus 1 Plus 2 Plus 3 Plus 4 Balance 996 0.00 67.40 0.00 0.00 0.00 67.40 Aging Total: 0.00 67.40 0.00 0.00 0.00 67.40 12.34 Check M 155276 UBPKT12485 Revenue Code Current Plus 1 Plus 2 Plus 3 Plus 4 Balance 996 0.00 12.34 0.00 0.00 0.00 12.34 Aging Total: 0.00 12.34 0.00 0.00 0.00 12.34 3/14/2023 9:33:15 AM Utility Refund Check Report I Account Number Name 20-02019-02 Genck, Braden 1 19-00963-01 Lovette, Stephen M 1 18-00110-01 Mannava, Guru Teja 1 01-39706-16 Ocken, David J 1 19-00978-01 Parker, Peyton R 85-00111-05 Savary, Jennifer L 1 19-00752-01 Schmitt, Sarah K 1 21-00213-01 Stewart, Tarra M 17-00198-02 Taylor, Rochelle L 19-00536-05 Wailes, Isabella Adi Date Type Amount Reference Packet Receipt Type 3/8/2023 Refund 332.06 Check #: 155289 UBPKT12485 Revenue Code Current Plus 1 Plus 2 Plus 3 Plus 4 Balance 996 0.00 332.06 0.00 0.00 0.00 332.06 Aging Total: 0.00 332.06 0.00 0.00 0.00 332.06 3/8/2023 Refund 61.00 Check #: 155286 UBPKT12485 Revenue Code Current Plus 1 Plus 2 Plus 3 Plus 4 Balance 996 61.00 0.00 0.00 0.00 0.00 61.00 Aging Total: 61.00 0.00 0.00 0.00 0.00 61.00 3/8/2023 Refund 87.53 Check M 155279 UBPKT12485 Revenue Code Current Plus 1 Plus 2 Plus 3 Plus 4 Balance 996 87.53 0.00 0.00 0.00 0.00 87.53 Aging Total: 87.53 0.00 0.00 0.00 0.00 87.53 3/8/2023 Refund 115.00 Check M 155273 UBPKT12485 Revenue Code Current Plus 1 Plus 2 Plus 3 Plus 4 Balance 996 115.00 0.00 0.00 0.00 0.00 115.00 Aging Total: 115.00 0.00 0.00 0.00 0.00 115.00 3/8/2023 Refund 70.40 Check M 155288 UBPKT12485 Revenue Code Current Plus 1 Plus 2 Plus 3 Plus 4 Balance 996 0.00 70.40 0.00 0.00 0.00 70.40 Aging Total: 0.00 70.40 0.00 0.00 0.00 70.40 3/8/2023 Refund 67.40 Check M 155291 UBPKT12485 Revenue Code Current Plus 1 Plus 2 Plus 3 Plus 4 Balance 996 -32.60 100.00 0.00 0.00 0.00 67.40 Aging Total: -32.60 100.00 0.00 0.00 0.00 67.40 3/8/2023 Refund 20.47 Check #: 155281 UBPKT12485 Revenue Code Current Plus 1 Plus 2 Plus 3 Plus 4 Balance 996 0.00 20.47 0.00 0.00 0.00 20.47 Aging Total: 0.00 20.47 0.00 0.00 0.00 20.47 3/8/2023 Refund 24.17 Check M 155290 UBPKT1248S Revenue Code Current Plus 1 Plus 2 Plus 3 Plus 4 Balance 996 24.17 0.00 0.00 0.00 0.00 24.17 Aging Total: 24.17 0.00 0.00 0.00 0.00 24.17 3/8/2023 Refund 39.06 Check M 155277 UBPKT12485 Revenue Code Current Plus 1 Plus 2 Plus 3 Plus 4 Balance 996 39.06 0.00 0.00 0.00 0.00 39.06 Aging Total: 39.06 0.00 0.00 0.00 0.00 39.06 3/8/2023 Refund 32.34 Check M 155280 UBPKT12485 Revenue Code Current Plus 1 Plus 2 Plus 3 Plus 4 Balance 996 32.34 0.00 0.00 0.00 0.00 32.34 Aging Total: 32.34 0.00 0.00 0.00 0.00 32.34 3/14/2023 9:33:15 AM Utility Refund Check Report Ad] Account Number Name Date Type _ ...... Amount Reference _ Packet Receipt Type 19-00867-01 Wolken, Jon 3/8/2023 Refund 70.40 Check iF.1SSZ82 UBPKT1248S Revenue Code Current Plus 1 Plus 2 Plus 3 Plus 4 Balance 996 0.00 70.40 0.00 0.00 0.00 70.40 Aging Total: 0.00 70.40 0.00 0.00 0.00 70.40 Transaction Grand Total for Period: 1,443.45 Totals by Transaction Type Transaction Type Count Amount Refund 20 1,443.45 Total for Period: 20 1,443.45 Transaction Type Refund Totals by Transaction Type and Revenue Code Revenue Code Count Amount 996 - Unapplied Credits 38 1,443.45 Refund Total: 1,443.45 Total for Period: 38 1,443.45 Totals by Revenue Code Revenue Code Count Amount 996 - Unapplied Credits 38 1,443.45 Total for Period: 38 1,443.45 3/14/2023 9:33:15 AM Utility Refund Check R_F a ,. City of Waukee, IA �tr.rKt��E' Employee Name ABRAMOWITZ, LEVI ADKINS, COREY ADKISSON, JENNIFER AHRENS, ELIZA ANDERSON,SARA ANNIS, JEREMY BAKER, RANDY BAUMAN, LISA BECKER, CHEYANNE BEDFORD,SAMANTHA BEEHLER, EMILY BEHRENS,HEATHER BERG, KRISTINA BEYERS, JENNIFER BLACK, HUNTER BLOMMESTEIN, FREDRIK BOYD, ISAAC BOYLE, GAVIN BROWN, ANGALEA BROWN, JENNIFER BROWN, NATHAN BRUENING, BENJAMIN BRUNS, RACHEL BURKHART, LINDA BURKHART, MARK CAMPBELL, SCOTT CARPENTER,PAUL CARROLL,JOSEPH CHAMBERS, KYLE CHRISTENSEN, AARON CHRISTENSEN, ABAGAIL CICHOSKI, KELLI CLEMEN, ANTHONY COGGESHELL, LEE CORKREAN, JENNIFER COUGHLIN, TONI COX, BENJAMIN CRAVEN, GAYLA CRONE, ERIN CROSS, JONATHAN CUNNINGHAM, SCOTT DANIEL, COLE DANIEL, MELANIE DEBOER, MELISSA DEETS, BRADLY DEZEEUW, DAVID DODGE, JUSTIN EDWARDS, DANAE FLUGGE-SMITH, JAMIE FREDERICK, JUSTIN FREDERICKSEN, BROCK FREEMAN, MATTHEW FROEHLICH, WILLIAM FYFE, JUSTIN GAVIN, HALEY GEHRKE, CHASE GIBBS, AUSTIN Payroll Publication Report By Employee Name Payroll Set: 01 - City of Waukee For Date Range 03172023-03172023 Salary 2,366.30 1,599.10 563.37 7.78 1,603.06 190.65 2,087.73 1,353.13 1,804.86 1,502.38 1,745.97 2,611.16 595.04 422.23 1,713.24 192.26 1,871.45 2,046.42 1,560.19 2,476.37 2,409.92 308.21 2,424.54 3,481.83 22.50 2,244.25 1,879.08 2,315.35 1,900.83 1,771.72 1,508.47 2,172.72 1,794.02 1,701.18 1,760.04 708.01 331.32 115.67 145.22 864.79 2,963.14 2,217.49 986.93 2,658.41 4,792.21 2,273.78 2,248.12 2,165.99 2,186.19 2,112.05 1,635.58 2,162.38 458.88 2,295.27 982.28 1,615.79 1,599.18 Employee Name Salary GIBSON IV, WILLIAM 1,940.99 GILCHRIST, NICHOLAS 1,774.32 GITZEN, ROBERT 3,193.88 GOINS, ANDREA 2,460.97 GUESS, KATHRYN 1,881.91 HACKETT, MICHAEL 1,874.00 HANSON, LAURA 1,793.32 HEIMANN, RONALD 1,998.52 HENTGES, ERIC 2,189.71 HILGENBERG, ADAM 1,781.59 HOGBONOUTO, TOLIDJI 1,475.36 HOLMES, HOLLY 1,649.32 HUSTED, TROY 2,060.79 HUTTON, JOSHUA 2,696.87 JACKSON, COLE 2,097.67 JERMIER, MATTHEW 3,372.53 JOHNSON, WYATT 1,537.18 KAMMERER, EMMILY 374.15 KAPPOS, SARA 2,994.19 KASS, ANDREW 2,871.96 KASZINSKI, BRETT 427.84 KELLER, CHRISTOPHER 2,156.79 KICKBUSH, CHRISTOPHER 2,273.82 KLEINWOLTERINK, COLE 1,848.77 KLEVER, JUDY 1,031.83 KNEPPER, AARON 161.92 KNUDSEN, DYLAN 2,428.70 KNUST, DANIEL 1,783.80 KOESTER, RUDY 3,880.41 KOSTECKI, BROOKE 638.49 KREKLAU, ROBERT 784.69 KUHLES, KAMRYN 190.24 LACKEY, JAMIE 742.67 LANDE, RACHELE 134.07 LARSON, KENNETH 686.62 LARSON, KRISTINE 2,983.58 LAUGHRIDGE, DANIEL 1,927.04 LE, SON 3,397.60 LEMKE, NEIL 2,092.74 LEVSEN, BRYAN 2,384.05 LEWIS, CLINTON 1,328.97 LINDSAY, MICHELLE 1,878.53 LOCKHART, MEGAN 734.48 LONG, JEREMY 3,294.42 LOVETINSKY, TRACY 1,841.43 LYNCH, JEREMY 1,629.46 MANNING, JOSHUA 2,213.87 MAREAN, JOSHUA 1,465.65 MAREK, JAMES 1,862.42 MCCLUSKEY, ERIC 3,504.55 MEEKER, BRYCE 1,767.80 MELLENCAMP, JEFFREY 3,084.71 METTEE, WILLIAM 2,042.13 MINIKUS, JOSHUA 1,731.42 MORAVEC, CODY 1,893.89 MORRIS, ASHLEY 1,779.54 MURRA, BRIAN 2,330.58 MURRAY, JACK 2,546.35 NEWBURY, NICHOLAS 1,873.47 NICHOLS, ANDREW 1,884.90 OHMSTEDE, LUIS 1,499.51 OLDHAM, JAMES 2,303.49 OLSASKY, JOHN 103.44 OSBORN, RYAN 193.99 Employee Name Salary OSBORN, SARAH 1,862.73 OSBORNE, NICHOLAS 2,759.73 OSTRING, KATHLEEN 1,878.93 PARISH, TONJA 1,602.67 PATTERSON, KEVIN 1,677.04 PAYNE, THOMAS 1,998.84 PERALTA CORNEJO, STEVEN 166.58 PERKINS, JACOB 1,939.42 PETTIT, BRANDON 3,154.60 PIZINGER, JAMES 1,527.77 PORTER, NICKOLAS 871.97 PURVIS, KATHRYN 1,501.34 QUAM, BRADLEY 1,665.79 RASH, RONALD 2,269.43 RETTENMEIER, ALEC 156.72 RICHARDSON, DACE 1,505.52 RICHARDSON, ELIZABETH 1,908.31 ROBBINS, CORBY 2,025.99 ROBINSON, CLINT 3,876.02 ROBINSON, NATHANIEL 392.49 ROSENOW, MELANIE 555.40 ROTH, TITO 1,560.93 ROTSCHAFER, CARMEN 1,517.54 ROYER, TIMOTHY 3,140.68 RUSHER, LUCIUS 2,520.23 SCHAUFENBUEL, KARI 1,358.63 SCHUETT, REBECCA 2,701.36 SCHULTZ, JEFFREY 1,871.55 SEDDON, JOSH 2,925.19 SEELY, AUSTEN 131.25 SHAFFER, CHET 1,832.27 SHERIDAN, ISABELLA 217.11 SHIELDS, JOHN 1,765.02 SLYCORD, JASON 2,008.58 SMITH, BLAKE 1,676.52 SMOLIK, MEGAN 1,571.47 SNOW, SUSAN 92.53 SOFEN, NATASHA 34.42 SPOSETO, CADEN 429.43 SPOSETO, MACKENZIE 3,015.20 STANISH, LAURA 1,696.66 STEINKE, KURT 1,467.06 STEPHENS, CLINT 662.68 STEWARD, ERIC 2,242.55 STIFEL, DALTON 1,892.98 STOTZ, MELISSA 900.92 TALAMANTEZ, HALEY 1,902.10 TAYLOR, CHRISTINA 124.32 THAYER, CHANDLER 1,987.01 TOWNSEND, MCKENNA 1,914.12 TRENT, JARED 701.05 TYSDAL, THOMAS 3,206.43 VAN ERDEWYK, RACHEL 1,697.14 VANDEKAMP, JOSHUA 2,400.59 VENTO, NICHOLAS 1,602.92 WEBER, BRIAN 1,274.73 WERTS, DANIEL 2,508.04 WESTON STOLL, KERI 1,955.29 WHITE, JASON 1,880.30 WIGGINS, MATHEW 2,502.55 WILLIAMS, SUSAN 2,035.99 WISE, NATHAN 3,418.06 WOOD, DANIEL 604.98 WRIGHT, MICHAEL 2,086.27 Employee Name Salary YOUNG, DAWN 1,381.99 YOUNG, JOHNATHAN 2,177.39 YOUSO, ANTHONY 1,726.06 *TOTALS* 325,907.31