Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2022-01-03-J01A 01032022_bill list_payroll
City of Waukee Bill Presentation Recap January 3, 2022 Total Unpaid Bills Presented for Approval : $ 341,921.14 Total Checks Issued Prior to Council Approval: (A) Prior to Last Council Meeting $ 2,033.61 (B) After Last Council Meeting $ - (C) Payroll Taxes & Reimbursements $ 343,320.86 (D) Utility Refunds $ 9,982.57 (E) Wells Fargo Credit Card $ 41,076.98 Payroll Checks Issued: (F) 12/23/2021 $ 291,131.82 Grand Total: ** Credit Card Detail also included in 7" FY 2022 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 090 North Residential TIF 091 Hickman West Indust Park TIF 092 Enterprise Business Park TIF Fund 093 Waukee Urban Renewal Area TIF Fund 094 Gateway Urban Renewal 095 Autumn Ridge Urban Renewal 096 Waukee West Urban Renewal 097 Southwest Business Park 098 Waukee Central URA 110 Debt Service Fund 111 Special Assessments Fund 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 $ 1,029,466.98 Expenditures Budgeted Year To Date $ 16,326,795 $ 7,716,148 Revenues Bud eted Year To Date $ 16,767,357 $ 7,256,782 $ 13,800 $ 14,107 $ 48,100 $ 16,841 $ 3,266,914 $ 1,567,261 $ 3,127,850 $ 1,362,088 $ 91,444 $ 326 $ - $ - $ 758,806 $ - $ 819,208 $ 513,088 $ 6,949,333 $ 3,223 $ 4,344,814 $ 2,311,984 $ 1,991,977 $ 803,529 $ 2,610,558 $ 1,030,475 $ 492,992 $ - $ 716,298 $ 357,587 $ 2,500 $ - $ - $ - $ 93,000 $ 26,219 $ 93,182 $ 49,530 $ 176,800 $ 92,428 $ 179,086 $ - $ 14,538,957 $ 1,674,734 $ 16,172,409 $ 2,791,873 $ - $ - $ - $ 17,546 $ 2,600,000 $ - $ 2,651,127 $ 1,366,058 $ 1,097,969 $ - $ 3,176,500 $ 1,030,282 $ - $ - $ - $ 1,616 $ 45,120,941 $ 17,436,530 $ 22,315,000 $ 3,868,256 $ - $ - $ - $ 1,234 $ 8,197,060 $ 3,335,122 $ 6,397,300 $ 6,686,848 $ 7,179,626 $ 4,699,050 $ 6,460,900 $ 4,648,075 $ - $ - $ - $ 297 $ - $ - $ - $ 42 $ - $ - $ - $ 146 $ 9,400,209 $ 3,992,239 $ 8,554,950 $ 3,862,043 $ 1,306,771 $ 307,305 $ 1,192,200 $ 693,088 $ 442,610 $ 177,216 $ 417,600 $ 210,227 $ 1,528,400 $ 806,183 $ 1,527,500 $ 781,006 $ 582,532 $ 246,853 $ 600,000 $ 404,297 $ 30,000 $ - $ - $ 191 Total: $ 122,189,436 $ 42,898,473 $ 98,171,939 $ 39,261,501 City of Waukee FY2022 Department Report - General Fund As of January 3, 2022 Expended YTD Budgeted $ Remaining General Fund: Police Department Personnel Services $ 1,770,192 $ 3,924,300 Supplies & Services $ 276,778 $ 539,210 Capital Outlay $ 161,722 $ 169,200 $ 2,208,692 $ 4,632,710 $ 2,424,018 Warning Sirens Personnel Services $ - $ - Supplies & Services $ 34,078 $ 4,700 Capital Outlay $ - $ 42,000 $ 34,078 $ 46,700 $ 12,622 Emergency Management Supplies & Services $ 281 $ - $ 281 $ - $ (281) Westcom Dispatch Personnel Services $ - $ - Supplies & Services $ 355,541 $ 691,000 Capital Outlay $ - $ - $ 355,541 $ 691,000 $ 335,459 Fire Department Personnel Services $ 427,445 $ 909,675 Supplies & Services $ 95,832 $ 181,360 Capital Outlay $ 2,820 $ - Other Financing $ 1,203 $ 527,300 $ 1,091,035 $ 563,735 EMS Personnel Services $ 900,305 $ 1,850,575 Supplies & Services $ 90,892 $ 224,260 Capital Outlay $ 12,500 $ 78,000 $ 1,003,697 $ 2,152,835 $ 1,149,138 Building Inspection Personnel Services $ 323,895 $ 633,600 Supplies & Services $ 17,524 $ 31,900 Capital Outlay $ 349 $ 60,000 $ 341,767 $ 725,500 $ 383,733 Animal Control Personnel Services $ - $ - Supplies & Services $ 3,417 $ 31,000 Capital Outlay $ - $ - $ 3,417 $ 31,000 $ 27,583 Library Services Personnel Services $ 421,648 $ 979,090 Supplies & Services $ 173,382 $ 315,000 Capital Outlay $ - $ - $ 595,030 $ 1,294,090 $ 699,060 Mosquito Control Personnel Services $ - $ - Supplies & Services $ - $ 2,000 Capital Outlay $ - $ - $ - $ 2,000 $ 2,000 Community Services Personnel Services $ - $ - Supplies & Services $ - $ 49,000 Capital Outlay $ - $ - $ - $ 49,000 $ 49,000 Parks Personnel Services $ 177,363 $ 453,550 Supplies & Services $ 152,771 $ 255,590 Capital Outlay $ 43,263 $ 165,000 $ 373,396 $ 874,140 $ Recreation Personnel Services $ 284,239 $ 574,250 Supplies & Services $ 158,523 $ 250,990 Capital Outlay $ 7,692 $ 8,000 $ 450,454 $ 833,240 $ Triumph Park Personnel Services $ 7,310 $ 109,700 Supplies & Services $ 51 $ 53,775 Capital Outlay $ 14,237 $ 21,598 $ 163,475 $ Community Center Personnel Services $ 2,576 $ 6,000 Supplies & Services $ 14,005 $ 25,000 $ 16,580 $ 31,000 $ Vineyard Supplies & Services $ 5,249 $ 11,000 $ 5,249 $ 11,000 $ Public Works Personnel Services $ 6,545 $ 69,420 Supplies & Services $ (1,699) $ 6,620 Capital Outlay $ 175 $ - $ 5,022 $ 76,040 $ Public Works Building Personnel Services $ - $ - Supplies & Services $ 88,628 $ Capital Outlay $ - $ - $ 88,628 $ - $ Public Works Mechanic Personnel Services $ 93,870 $ 211,850 Supplies & Services $ 73,626 $ (15,990) Capital Outlay $ - $ - $ 167,496 $ 195,860 $ Median and Bldg Grounds Personnel Services $ - $ - Supplies & Services $ 15,140 $ 25,000 Capital Outlay $ - $ - $ 15,140 $ 25,000 $ Mayor & Council Personnel Services $ 30,034 $ 63,900 Supplies & Services $ 18,695 $ 30,750 Capital Outlay $ - $ - $ 48,729 $ 94,650 $ Elections Personnel Services $ - $ - Supplies & Services $ 6,787 $ 10,000 Capital Outlay $ - $ - $ 6,787 $ 10,000 $ Communications Personnel Services $ 54,735 $ 130,440 Supplies & Services $ 27,074 $ 47,960 Capital Outlay $ - $ - $ 81,809 $ 178,400 $ Administration Personnel Services $ 189,792 $ 252,600 Supplies & Services $ 125,357 $ 144,000 500,744 382,786 141,877 14,420 5,751 71,018 (88,628) 28,364 • :.f 45,921 3,213 96,591 Capital Outlay $ 5,000 $ - $ 320,150 $ 396,600 $ 76,450 City Hall Personnel Services $ - $ - Supplies & Services $ 81,053 $ 147,500 Capital Outlay $ - $ - $ 81,053 $ 147,500 $ 66,447 Human Resources Personnel Services $ 49,144 $ 131,750 Supplies & Services $ 53,755 $ 23,830 Capital Outlay $ - $ 102,899 $ 155,580 $ 52,681 Financial Administration Personnel Services $ 48,908 $ 236,500 Supplies & Services $ 9,848 $ 31,250 Capital Outlay $ - Other Financing $ - $ 15,000 $ 58,756 $ 282,750 $ 223,994 Community Development Personnel Services $ 63,811 $ 140,320 Supplies & Services $ 47,425 $ 107,700 Capital Outlay $ 27,360 $ - $ 138,596 $ 248,020 $ 109,424 City Attorney Personnel Services $ - $ - Supplies & Services $ 65,251 $ 150,000 Capital Outlay $ - $ - $ 65,251 $ 150,000 $ 84,749 Development Services Personnel Services $ 136,132 $ 465,510 Supplies & Services $ 27,898 $ 75,350 Capital Outlay $ - $ - $ 164,029 $ 540,860 $ 376,831 Information Technology Personnel Services $ 50,758 $ 247,740 Supplies & Services $ 38,685 $ 120,700 Capital Outlay $ 45,957 $ 43,700 $ 135,400 $ 412,140 $ 276,740 Engineering Personnel Services $ 227,898 $ 528,700 Supplies & Services $ 68,318 $ 212,570 Capital Outlay $ - $ - $ 296,216 $ 741,270 $ 445,054 GIS Personnel Services $ (16,898) $ 38,300 Supplies & Services $ 20,003 $ 2,700 Capital Outlay $ - $ 2,400 $ 3,105 $ 43,400 $ 40,295 Transfers to GO Debt Service $ 7,716,148 $16,326,795 $ 8,610,647 Total General Fund: Personnel Services $ 5,249,984 Supplies & Services $ 2,143,886 Capital Outlay $ 321,075 Other $ 1,203.25 $ 7,716,148 Expense Approval Register 40 City of Waukee, IA PKT02702 - JANUARY 3 2021 COUNCIL MEETING Vendor Name Payable Number Post Date Description (Item) Account Number Amount Department: 1100 - POLICE OPERATIONS GALL'S INC 019827433 11/23/2021 LOCKOUT TOOL KIT/CARRYIN 010-10.1100.540000 105.00 GALL'S INC 019839366 11/24/2021 SHIRT- GUESS 010-10.1100.120000 79.99 GALL'S INC 019839367 11/24/2021 SHIRT/BADGES-SPOSETO 010-10.1100.120000 79.99 GALL'S INC 019850263 11/26/2021 PARKA-JOHNSON 010-10.1100.120000 275.70 GALL'S INC 019850305 11/26/2021 FLEECE- KINNEY 010-10.1100.120000 77.49 GALL'S INC 019850306 11/26/2021 FLEECE- SCHETTLER 010-10.1100.120000 77.49 GALL'S INC 019850312 11/26/2021 ID & BADGE CASE- JOHNSON 010-10.1100.120000 19.99 GALL'S INC 019850349 11/26/2021 SHIRT- BORICH 010-10.1100.120000 74.99 GALL'S INC 019857178 11/29/2021 PEPPER SPRAY- PETTIT 010-10.1100.590000 22.74 DELTA DENTAL 33075000200202201 01/01/2022 JAN '22 DENTAL INSURANCE 010-10.1100.100000 2,554.66 WEBSTER ELECTRIC 43517 11/30/2021 REPAIRED REAR CANOPY LIG 010-10.1100.400000 224.10 MID AMERICAN ENERGY 520539349 12/20/2021 DECEMBER 2021 STATEMEN 010-10.1100.480000 705.54 ROBERT HALF 59050426 12/20/2021 TEMP ADMIN - ROBERTA WA 010-10.1100.230000 136.25 HOLMES MURPHY 627436 01/01/2022 JAN '22 HMA MONTHLY CON 010-10.1100.100000 1,067.58 STIVERS FORD 646603 12/13/2021 CHARGING SYSTEM WARNIN 010-10.1100.410000 1,241.09 STAPLES BUSINESS CREDIT 7339721955-0-1 09/27/2021 TOILET PAPER/PAPER TOWEL 010-10.1100.590000 170.77 STAPLES BUSINESS CREDIT 7341109262-0-1 10/07/2021 DUCT TAPE/PACKING TAPE/B 010-10.1100.580000 53.72 STAPLES BUSINESS CREDIT 7342131811-0-1 10/22/2021 SHARPIES/DRY ERASE MARK 010-10.1100.580000 47.48 STAPLES BUSINESS CREDIT 7342131811-1-1 10/28/2021 DRY ERASE MARKERS CREDIT 010-10.1100.580000 -4.00 STAPLES BUSINESS CREDIT 7342131811-2-1 10/28/2021 PENS CREDIT 010-10.1100.580000 -1.60 STAPLES BUSINESS CREDIT 7343322808-0-1 11/08/2021 PAPER PLATES 010-10.1300.590000 72.68 STAPLES BUSINESS CREDIT 7343369979-0-1 11/08/2021 CLASP ENVELOPES/BANKERS 010-10.1100.580000 92.28 STAPLES BUSINESS CREDIT 7343369979-1-1 11/18/2021 BANKERS BOXES CREDIT 010-10.1100.580000 -25.80 STAPLES BUSINESS CREDIT 7344646170-0-1 11/29/2021 LABELS/PENS 010-10.1100.580000 23.58 STAPLES BUSINESS CREDIT 7344768233-0-1 11/30/2021 PAPER CUPS/PLASTIC SPOON 010-10.1100.590000 171.97 STAPLES BUSINESS CREDIT 7344768233-0-2 11/30/2021 PLASTIC FORKS 010-10.1100.590000 49.09 STAPLES BUSINESS CREDIT 7344768233-1-1 12/09/2021 PLASTIC SPOONS CREDIT 010-10.1100.590000 -29.28 STAPLES BUSINESS CREDIT 7345458522-0-1 12/08/2021 CALENDARS 010-10.1100.580000 201.08 STAPLES BUSINESS CREDIT 7345565834-0-1 12/09/2021 DESKTOP PAPER HOLDER 010-10.1100.580000 13.29 KONICA MINOLTA BUSINESS 9008227267 11/30/2021 COPIER/PRINTER LEASE & M 010-10.1100.270110 15.38 KONICA MINOLTA BUSINESS 9008227267 11/30/2021 COPIER/PRINTER LEASE & M 010-10.1100.270110 15.38 KONICA MINOLTA BUSINESS 9008227267 11/30/2021 COPIER/PRINTER LEASE & M 010-10.1100.270110 34.90 VERIZON WIRELESS 9895006207 12/13/2021 DECEMBER 2021 STATEMEN 010-10.1100.450000 967.11 SHI INTERNATIONAL CORP B14430160 11/30/2021 IPAD CASES 010-10.1100.540000 196.00 SHI INTERNATIONAL CORP B14473898 12/13/2021 IPADS 010-10.1100.540000 879.06 DES MOINES AREA COMMU G-53685 12/08/2021 CONCOURSE RENTAL 010-10.1100.470000 220.00 SECRETARY OF STATE INVO012792 01/04/2022 NOTARY RENEWAL- LEMKE 010-10.1100.280000 30.00 SECRETARY OF STATE INVO012793 01/04/2022 NOTARY APPLICATION- ROBB 010-10.1100.280000 30.00 IOWA MUNICIPALITIES WOR INV81716 01/01/2022 JANUARY 2022 WORK COMP 010-10.1100.110000 1,916.00 IOWA MUNICIPALITIES WOR INV81716 01/01/2022 JANUARY 2022 WORK COMP 010-10.1100.110000 9.00 Department 1100 - POLICE OPERATIONS Total: 11,890.69 Department: 1400 - FIRE PROTECTION AMAZON.COM 14V3-1CC6-YMYT 12/14/2021 SHARPIES/SCISSORS/SEAM R 010-10.1400.580000 16.14 INTERSTATE ALL BATTERY CE 1924602046710 12/13/2021 BATTERIES 010-10.1400.590000 133.33 DELTA DENTAL 33075000200202201 01/01/2022 JAN '22 DENTAL INSURANCE 010-10.1400.100000 578.99 MID AMERICAN ENERGY 520539349 12/20/2021 DECEMBER 2021 STATEMEN 010-10.1400.480000 467.63 HOLMES MURPHY 627436 01/01/2022 JAN '22 HMA MONTHLY CON 010-10.1400.100000 224.04 KONICA MINOLTA BUSINESS 9008227267 11/30/2021 COPIER/PRINTER LEASE & M 010-10.1400.270110 17.45 VERIZON WIRELESS 9895006207 12/13/2021 DECEMBER 2021 STATEMEN 010-10.1400.450000 89.89 SANDRY FIRE SUPPLY LLC INV-018603 10/22/2021 FIRE HOODS 010-10.1400.540000 197.50 SANDRY FIRE SUPPLY LLC INV-019259 12/14/2021 CHEMGUARD DIRECT ATTAC 010-10.1400.590000 164.00 IOWA MUNICIPALITIES WOR INV81716 01/01/2022 JANUARY 2022 WORK COMP 010-10.1400.110000 3,008.00 12/29/2021 10:31:40 AM Page 1 of 15 Expense Approval Register Packet: APPKT02702 -JANUARY 3 2021 COUNCIL MEETING Vendor Name Payable Number Post Date Description (Item) Account Number Amount IOWA MUNICIPALITIES WOR INV81716 01/O1/2022 JANUARY 2022 WORK COMP 010-10.1400.110000 4,228.00 Department 1400 - FIRE PROTECTION Total: 9,124.97 Department: 1500 - EMS UNITED PARCEL SERVICE OOOOAW7647491 12/04/2021 SHIPPING 010-10.1500.360000 33.73 AMAZON.COM 14V3-1CC6-YMYT 12/14/2021 SHARPIES/SCISSORS/SEAM R 010-10.1500.580000 16.15 DELTA DENTAL 33075000200202201 01/O1/2022 JAN'22 DENTAL INSURANCE 010-10.1500.100000 1,017.41 MID AMERICAN ENERGY 520539349 12/20/2021 DECEMBER 2021 STATEMEN 010-10.1500.480000 467.62 HOLMES MURPHY 627436 01/O1/2022 JAN'22 HMA MONTHLY CON 010-10.1500.100000 375.45 KONICA MINOLTA BUSINESS 9008227267 11/30/2021 COPIER/PRINTER LEASE & M 010-10.1500.270100 17.45 VERIZON WIRELESS 9895006207 12/13/2021 DECEMBER 2021 STATEMEN 010-10.1500.450000 318.72 MERCY WEST PHARMACY INV0012737 12/02/2021 EMS MEDICATIONS 010-10.1500.590050 192.14 IOWA MUNICIPALITIES WOR INV81716 01/O1/2022 JANUARY 2022 WORK COMP 010-10.1500.110000 7.00 IOWA MUNICIPALITIES WOR INV81716 01/O1/2022 JANUARY 2022 WORK COMP 010-10.1500.110000 10,663.00 IOWA MUNICIPALITIES WOR INV81716 01/01/2022 JANUARY 2022 WORK COMP 010-10.1500.110000 2.00 Department 1500 - EMS Total: 13,110.67 Department: 1600 - STREET LIGHTING MID AMERICAN ENERGY 520521658 12/20/2021 DECEMBER 2021 STATEMEN 060-30.1600.480000 164.15 MID AMERICAN ENERGY 520545721 12/20/2021 DECEMBER 2021 STATEMEN 060-30.1600.480000 30.41 MID AMERICAN ENERGY 520561086 12/20/2021 DECEMBER 2021 STATEMEN 060-30.1600.480000 96.86 Department 1600 - STREET LIGHTING Total: 291.42 Department: 1601 -TRAFFIC SIGNALS GENERAL TRAFFIC CONTROL 21581 11/03/2021 GPP/UNIVERSITY SIGNAL SW 060-30.1601.410300 2,550.00 MOBOTREX, INC 254490 10/29/2021 POLE: 14',SCH80,ALU,4-8"NP 060-30.1601.760000 2,448.00 IOWA SIGNAL INC 5046A 11/01/2021 ESKER & LA GRANT TRAFFIC 060-30.1601.760000 4,225.00 MID AMERICAN ENERGY 520527741 12/20/2021 DECEMBER 2021 STATEMEN 060-30.1601.480000 56.16 MID AMERICAN ENERGY 520544146 12/20/2021 DECEMBER 2021 STATEMEN 060-30.1601.480000 56.01 MID AMERICAN ENERGY 520550784 12/20/2021 DECEMBER 2021 STATEMEN 060-30.1601.480000 27.90 Department 1601- TRAFFIC SIGNALS Total: 9,363.07 Department: 1900 - BUILDING INSPECTION LOGOED APPAREL & PROMO 18869 12/16/2021 SHIRTS 010-10.1900.120000 821.92 AMAZON.COM 1VKR-L6WL-7D17 12/12/2021 DRY ERASE CALENDAR/PENS 010-10.1900.580000 34.57 IOWA ASSOCIATION OF BUIL 23 12/07/2021 TRAINING/CLASS A & CLASS 010-10.1900.280000 275.06 IOWA ASSOCIATION OF BUIL 23 12/07/2021 TRAINING/CLASS A & CLASS 010-10.1900.470000 941.04 DELTA DENTAL 33075000200202201 01/O1/2022 JAN'22 DENTAL INSURANCE 010-10.1900.100000 519.46 HOLMES MURPHY 627436 01/O1/2022 JAN'22 HMA MONTHLY CON 010-10.1900.100000 251.73 STAPLES BUSINESS CREDIT 7343159931-0-2 11/04/2021 CALENDARS/STAPLES 010-10.1900.580000 29.98 STAPLES BUSINESS CREDIT 7343204102-0-1 11/16/2021 STAMP 010-10.1900.580000 18.99 STAPLES BUSINESS CREDIT 7344804884-0-2 12/06/2021 TONER 010-10.1900.580000 121.14 VERIZON WIRELESS 9895006204 12/13/2021 DECEMBER 2021 STATEMEN 010-10.1900.450000 480.97 SHI INTERNATIONAL CORP B14466566 12/09/2021 LENOVOTHINKPADS 010-10.1900.540000 2,019.14 SHI INTERNATIONAL CORP B14473663 12/13/2021 LENOVOHARDWARE/SERVIC 010-10.1900.540000 63.00 IOWA MUNICIPALITIES WOR INV81716 01/O1/2022 JANUARY 2022 WORK COMP 010-10.1900.110000 4.00 IOWA MUNICIPALITIES WOR INV81716 01/O1/2022 JANUARY 2022 WORK COMP 010-10.1900.110000 132.00 Department 1900 - BUILDING INSPECTION Total: 5,713.00 Department: 21SO - PARK & REC COMPLEX CONFLUENCE 22379 12/17/2021 ATHLETIC COMPLEX/TRIUMP 327-90.2150.980110 13,090.37 Department 2150 - PARK & REC COMPLEX Total: 13,090.37 Department: 3100 - LIBRARY SERVICES OVERDRIVE INC 06497CO21474452 11/30/2021 EBOOKS/AUDIOBOOKS 010-40.3100.640000 752.42 EBSCO PUBLISHING 1000172587-1 12/13/2021 EBSCO PACKAGE 010-40.3100.270000 4,873.00 EBSCO PUBLISHING 1000172587-1 12/13/2021 EBSCO PACKAGE JANUARY 2 010-40.3100.640000 2,338.00 BLANK PARK ZOO 1121290 10/29/2021 ADULT PROGRAM SPEAKER 010-40.3100.460300 35.00 OFFICE DEPOT 207749911001 11/15/2021 FACE MASKS 010-40.3100.590000 59.94 OFFICE DEPOT 207754363001 11/15/2021 DISINFECTING WIPES/PAPER 010-40.3100.580000 41.18 OFFICE DEPOT 207754363001 11/15/2021 DISINFECTING WIPES/PAPER 010-40.3100.590000 167.44 OFFICE DEPOT 210496828001 11/18/2021 PAPER/PLANNER/PENS/TOIL 010-40.3100.580000 58.87 OFFICE DEPOT 210496828001 11/18/2021 PAPER/PLANNER/PENS/TOIL 010-40.3100.590000 205.76 OFFICE DEPOT 213434812001 12/03/2021 PAPER CLIPS/PAPER/COFFEE/ 010-40.3100.580000 33.20 12/29/2021 10:31:40 AM Page 2 of 15 Expense Approval Register Packet: APPKT02702 - JANUARY 3 2021 COUNCIL MEETING Vendor Name Payable Number Post Date Description (Item) Account Number Amount OFFICE DEPOT 213434812001 12/03/2021 PAPER CLIPS/PAPER/COFFEE/ 010-40.3100.590000 69.90 OFFICE DEPOT 213456097001 12/06/2021 PACKING TAPE 010-40.3100.580000 27.01 OFFICE DEPOT 213456099001 12/03/2021 PLASTIC CUPS 010-40.3100.590000 10.48 WASH -ECLAIR 248876 11/09/2021 WINDOW WASHING 010-40.3100.400000 42.00 DELTA DENTAL 33075000200202201 01/01/2022 JAN '22 DENTAL INSURANCE 010-40.3100.100000 517.36 MIDWEST ALARM SERVICES 367399 12/08/2021 FIRE ALARM CONTRACT 010-40.3100.400000 1,196.64 MID AMERICAN ENERGY 520536863 12/20/2021 DECEMBER 2021 STATEMEN 010-40.3100.480000 1,890.77 INGRAM LIBRARY SERVICES 56071755 11/23/2021 BOOKS 010-40.3100.590000 16.78 INGRAM LIBRARY SERVICES 56071755 11/23/2021 BOOKS 010-40.3100.640000 147.89 INGRAM LIBRARY SERVICES 56084520 11/24/2021 SUMMER PROGRAM PRIZE 010-40.3100.460400 10.19 INGRAM LIBRARY SERVICES 56100333 11/24/2021 BOOKS 010-40.3100.590000 12.42 INGRAM LIBRARY SERVICES 56100333 11/24/2021 BOOKS 010-40.3100.640000 154.09 INGRAM LIBRARY SERVICES 56100334 11/24/2021 BOOKS 010-40.3100.590000 3.04 INGRAM LIBRARY SERVICES 56100334 11/24/2021 BOOKS 010-40.3100.640000 22.78 INGRAM LIBRARY SERVICES 56131594 11/26/2021 BOOKS 010-40.3100.590000 25.41 INGRAM LIBRARY SERVICES 56131594 11/26/2021 BOOKS 010-40.3100.640000 244.87 INGRAM LIBRARY SERVICES 56131595 11/26/2021 WINTER PROGRAM PRIZE 010-40.3100.460300 40.37 INGRAM LIBRARY SERVICES 56208952 11/30/2021 BOOKS 010-40.3100.590000 35.36 INGRAM LIBRARY SERVICES 56208952 11/30/2021 BOOKS 010-40.3100.640000 305.33 INGRAM LIBRARY SERVICES 56208953 11/30/2021 BOOKS 010-40.3100.590000 1.39 INGRAM LIBRARY SERVICES 56208953 11/30/2021 BOOKS 010-40.3100.640000 14.39 INGRAM LIBRARY SERVICES 56249821 12/02/2021 SUMMER PROGRAM PRIZE 010-40.3100.460400 66.59 INGRAM LIBRARY SERVICES 56249822 12/02/2021 SUMMER PROGRAM PRIZE 010-40.3100.460400 50.36 INGRAM LIBRARY SERVICES 56266453 12/02/2021 BOOKS 010-40.3100.590000 101.90 INGRAM LIBRARY SERVICES 56266453 12/02/2021 BOOKS 010-40.3100.640000 580.86 INGRAM LIBRARY SERVICES 56266454 12/02/2021 BOOKS 010-40.3100.590000 21.69 INGRAM LIBRARY SERVICES 56266454 12/02/2021 BOOKS 010-40.3100.640000 139.04 INGRAM LIBRARY SERVICES 56280484 12/03/2021 SUMMER PROGRAM PRIZE 010-40.3100.460400 41.96 INGRAM LIBRARY SERVICES 56294228 12/03/2021 BOOKS 010-40.3100.590000 199.07 INGRAM LIBRARY SERVICES 56294228 12/03/2021 BOOKS 010-40.3100.640000 1,214.06 INGRAM LIBRARY SERVICES 56294229 12/03/2021 BOOKS 010-40.3100.590000 29.98 INGRAM LIBRARY SERVICES 56294229 12/03/2021 BOOKS 010-40.3100.640000 185.22 INGRAM LIBRARY SERVICES 56309840 12/05/2021 BOOKS 010-40.3100.590000 33.69 INGRAM LIBRARY SERVICES 56309840 12/05/2021 BOOKS 010-40.3100.640000 164.05 INGRAM LIBRARY SERVICES 56309841 12/05/2021 BOOKS 010-40.3100.590000 16.09 INGRAM LIBRARY SERVICES 56309841 12/05/2021 BOOKS 010-40.3100.640000 157.09 INGRAM LIBRARY SERVICES 56329912 12/06/2021 BOOKS 010-40.3100.590000 11.74 INGRAM LIBRARY SERVICES 56329912 12/06/2021 BOOKS 010-40.3100.640000 85.13 INGRAM LIBRARY SERVICES 56372959 12/07/2021 BOOKS 010-40.3100.590000 12.17 INGRAM LIBRARY SERVICES 56372959 12/07/2021 BOOKS 010-40.3100.640000 52.14 INGRAM LIBRARY SERVICES 56434915 12/09/2021 BOOKS 010-40.3100.590000 12.75 INGRAM LIBRARY SERVICES 56434915 12/09/2021 BOOKS 010-40.3100.640000 56.36 NICHE ACADEMY 5810 11/15/2021 ANNUAL SUBSCRIPTION REN 010-40.3100.640000 1,600.00 HOLMES MURPHY 627436 01/01/2022 JAN '22 HMA MONTHLY CON 010-40.3100.100000 242.64 KONICA MINOLTA BUSINESS 9008227267 11/30/2021 COPIER/PRINTER LEASE & M 010-40.3100.270110 34.89 KONICA MINOLTA BUSINESS 9008227267 11/30/2021 COPIER/PRINTER LEASE & M 010-40.3100.270110 34.89 VERIZON WIRELESS 9895006204 12/13/2021 DECEMBER 2021 STATEMEN 010-40.3100.450000 41.42 AMAZON CREDIT PLAN INVO012785 12/10/2021 DECEMBER 2021 STATEMEN 010-40.3100.460300 715.52 AMAZON CREDIT PLAN INVO012785 12/10/2021 DECEMBER 2021 STATEMEN 010-40.3100.540000 399.00 AMAZON CREDIT PLAN INVO012785 12/10/2021 DECEMBER 2021 STATEMEN 010-40.3100.590000 111.14 AMAZON CREDIT PLAN INVO012785 12/10/2021 DECEMBER 2021 STATEMEN 010-40.3100.640000 44.16 VELYAJANCZ-URBAN INVO012795 11/08/2021 DIY VALENTINE'S SELF -CARE 010-40.3100.460300 180.00 CHACHA'S CONFECTIONS INVO012809 11/05/2021 WINTER COOKIE DECORATIN 010-40.3100.460300 600.00 CANDLE BAR DSM LLC INVO012810 10/14/2021 CANDLE POURING WORKSH 010-40.3100.460300 562.50 VELYA JANCZ-URBAN INVO012811 11/08/2021 MEDICINAL HERB GARDENIN 010-40.3100.460300 180.00 IOWA MUNICIPALITIES WOR INV81716 01/01/2022 JANUARY 2022 WORK COMP 010-40.3100.110000 27.00 CITY OF WAUKEE NOV 21 LIBRARY 11/30/2021 NOVEMBER 2021 STATEMEN 010-40.3100.480000 460.41 YOURMEMBERSHIRCOM, IN R54308522 12/17/2021 JOB POST PROMO LISTING 010-40.3100.590000 449.00 Department 3100 - LIBRARY SERVICES Total: 22,267.79 12/29/2021 10:31:40 AM Page 3 of 15 Expense Approval Register Packet: APPKT02702 -JANUARY 3 2021 COUNCIL MEETING Vendor Name Payable Number Post Date Description (Item) Account Number Amount Department: 4100 - PARKS BOLTON & MENK, INC 0280115 11/22/2021 SUGAR CREEK PARK 327-90.4100.880089 10,885.00 MENARDS 21113 12/06/2021 SNOW REMOVAL MARKERS 010-40.4100.590000 424.80 DELTA DENTAL 33075000200202201 01/01/2022 JAN'22 DENTAL INSURANCE 010-40.4100.100000 42.09 DELTA DENTAL 33075000200202201 01/01/2022 JAN'22 DENTAL INSURANCE 010-40.4100.100000 159.04 DELTA DENTAL 33075000200202201 01/01/2022 JAN'22 DENTAL INSURANCE 010-40.4100.100000 32.78 IOWA FIRE EQUIPMENT COM 332579 12/13/2021 FIRE EXTINGUISHER FOR CO 010-40.4100.540000 76.50 MID AMERICAN ENERGY 520496262 12/20/2021 DECEMBER 2021 STATEMEN 010-40.4100.480000 116.72 MID AMERICAN ENERGY 520503100 12/20/2021 DECEMBER 2021 STATEMEN 010-40.4100.480000 171.27 MID AMERICAN ENERGY 520509781 12/20/2021 DECEMBER 2021 STATEMEN 010-40.4100.480000 56.16 MID AMERICAN ENERGY 520565111 12/20/2021 DECEMBER 2021 STATEMEN 010-40.4100.480010 23.79 HOLMES MURPHY 627436 01/01/2022 JAN'22 HMA MONTHLY CON 010-40.4100.100000 17.19 HOLMES MURPHY 627436 01/01/2022 JAN'22 HMA MONTHLY CON 010-40.4100.100000 60.66 HOLMES MURPHY 627436 01/01/2022 JAN'22 HMA MONTHLY CON 010-40.4100.100000 14.49 WAUKEE POWER EQUIPMEN 78658 12/15/2021 CHAINSAW AND MOWER OIL 010-40.4100.410100 95.36 WAUKEE POWER EQUIPMEN 78678 12/15/2021 CHAINSAW AND SUPPLIES 010-40.4100.540000 778.22 VERIZON WIRELESS 9895006206 12/13/2021 DECEMBER 2021 STATEMEN 010-40.4100.450000 172.59 VERIZON WIRELESS 9895006208 12/13/2021 DECEMBER 2021 STATEMEN 010-40.4100.450000 10.37 IOWA MUNICIPALITIES WOR INV81716 01/01/2022 JANUARY 2022 WORK COMP 010-40.4100.110000 274.00 KING'S MATERIAL INC KM17966187 12/09/2021 MONUMENT SIGN REPAIR 010-40.4100.410300 24.84 Department 4100 - PARKS Total: 13,435.87 Department: 4200 - RECREATION AMAZON.COM 1V6Y-1PM7-GH6K 11/05/2021 SLINGSHOT 010-40.4200.461700 49.99 DELTA DENTAL 33075000200202201 01/01/2022 JAN'22 DENTAL INSURANCE 010-40.4200.100000 318.08 HOLMES MURPHY 627436 01/01/2022 JAN '22 HMA MONTHLY CON 010-40.4200.100000 121.32 KONICA MINOLTA BUSINESS 9008227267 11/30/2021 COPIER/PRINTER LEASE & M 010-40.4200.270110 17.45 VERIZON WIRELESS 9895006206 12/13/2021 DECEMBER 2021 STATEMEN 010-40.4200.450000 243.77 BACKGROUND INVESTIGATIO BIBWA0005-0003 12/10/2021 BACKGROUND CHECK SYSTE 010-40.4200.280000 168.00 IOWA MUNICIPALITIES WOR INV81716 01/01/2022 JANUARY 2022 WORK COMP 010-40.4200.110000 2.00 IOWA MUNICIPALITIES WOR INV81716 01/01/2022 JANUARY 2022 WORK COMP 010-40.4200.110000 408.00 Department 4200 - RECREATION Total: 1,328.61 Department: 4210 - TRIUMPH PARK DELTA DENTAL 33075000200202201 01/01/2022 JAN'22 DENTAL INSURANCE 010-40.4210.100000 42.08 HOLMES MURPHY 627436 01/01/2022 JAN'22 HMA MONTHLY CON 010-40.4210.100000 14.49 VERIZON WIRELESS 9895006206 12/13/2021 DECEMBER 2021 STATEMEN 010-40.4210.450000 17.04 IOWA MUNICIPALITIES WOR INV81716 01/01/2022 JANUARY 2022 WORK COMP 010-40.4210.110000 37.00 Department 4210 - TRIUMPH PARK Total: 110.61 Department: 4310 - VINEYARD PROPERTY MENARDS 21195 12/07/2021 VINEYARD BUILDING LIGHTS 010-40.4310.400000 69.70 Department 4310 - VINEYARD PROPERTY Total: 69.70 Department: 5300 - STORM WATER DELTA DENTAL 33075000200202201 01/01/2022 JAN '22 DENTAL INSURANCE 560-80.5300.100000 159.04 DELTA DENTAL 33075000200202201 01/01/2022 JAN'22 DENTAL INSURANCE 560-80.5300.100000 16.39 HOLMES MURPHY 627436 01/01/2022 JAN'22 HMA MONTHLY CON 560-80.5300.100000 60.66 HOLMES MURPHY 627436 01/01/2022 JAN'22 HMA MONTHLY CON 560-80.5300.100000 8.60 VERIZON WIRELESS 9895006208 12/13/2021 DECEMBER 2021 STATEMEN 560-80.5300.450000 276.66 IOWA MUNICIPALITIES WOR INV81716 01/01/2022 JANUARY 2022 WORK COMP 560-80.5300.110000 141.00 Department 5300 - STORM WATER Total: 662.35 Department: 6000 - PUBLIC WORKS AMAZON.COM 1WKC-HYQK-7HHK 11/30/2021 ADAPTER CONVERTER/SCRE 010-20.6000.590000 35.74 DELTA DENTAL 33075000200202201 01/01/2022 JAN'22 DENTAL INSURANCE 010-20.6000.100000 512.50 HOLMES MURPHY 627436 01/01/2022 JAN'22 HMA MONTHLY CON 010-20.6000.100000 217.35 KONICA MINOLTA BUSINESS 9008227267 11/30/2021 COPIER/PRINTER LEASE & M 010-20.6000.270100 17.45 KONICA MINOLTA BUSINESS 9008227267 11/30/2021 COPIER/PRINTER LEASE & M 010-20.6000.270100 34.90 VERIZON WIRELESS 9895006208 12/13/2021 DECEMBER 2021 STATEMEN 010-20.6000.450000 236.71 IOWA MUNICIPALITIES WOR INV81716 01/01/2022 JANUARY 2022 WORK COMP 010-20.6000.110000 140.00 IOWA MUNICIPALITIES WOR INV81716 01/01/2022 JANUARY 2022 WORK COMP 010-20.6000.110000 7.00 Department 6000 - PUBLIC WORKS Total: 1,201.65 12/29/2021 10:31:40 AM Page 4 of 15 Expense Approval Register Packet: APPKT02702 - JANUARY 3 2021 COUNCIL MEETING Vendor Name Payable Number Post Date Description (Item) Account Number Amount Department: 6010 - PUBLIC WORKS BUILDING CONTROL INSTALLATIONS OF 108972 12/07/2021 CAMERA REPAIR 010-20.6010.400000 238.24 OFFICE DEPOT 214829361001 12/06/2021 PAPER/FOLDER/LEGAL PADS 010-20.6010.580000 94.21 OFFICE DEPOT 214834532001 12/04/2021 LEGAL PAD 010-20.6010.580000 30.49 OFFICE DEPOT 214834533001 12/03/2021 SPACE HEATER 010-20.6010.590000 45.69 NATIONWIDE OFFICE CLEAN 4056 11/26/2021 STRIP AND WAX- PUBLIC WO 010-20.6010.400000 2,250.00 MID AMERICAN ENERGY 520491285 12/20/2021 DECEMBER 2021 STATEMEN 010-20.6010.480000 1,313.22 AMERICAN ALARMS 58634 11/29/2021 SLE-LTEV NAPCO BURG CELL 010-20.6010.400000 600.00 HILLYARD INC 604570808 12/14/2021 TRASH BAGS 010-20.6010.400000 78.34 CINTAS CORPORATION 9156064268 12/O1/2021 WATERBREAK COOLER AGRE 010-20.6010.400000 50.00 FASTENAL COMPANY IAGRM125926 11/30/2021 SAFETY GEAR 010-20.6010.590000 247.20 AT&T MOBILITY X12082021 11/30/2021 NOVEMBER 2021 STATEMEN 010-20.6010.450000 113.66 Department 6010 - PUBLIC WORKS BUILDING Total: 5,061.05 Department: 6150 - PUBLIC WORKS MECHANIC THE FILTER SHOP 168166 11/30/2021 FILTERS 010-20.6150.570110 59.63 DELTA DENTAL 33075000200202201 01/O1/2022 JAN'22 DENTAL INSURANCE 010-20.6150.100000 193.12 ADEL AUTO PARTS 437805 11/29/2021 OIL & OIL FILTER 010-20.6150.570100 149.66 ADEL AUTO PARTS 437805 11/29/2021 OIL/OIL FILTER 010-20.6150.570110 11.24 ADEL AUTO PARTS 437850 11/30/2021 AIR FILTER 010-20.6150.570110 38.50 STIVERS FORD 5018294 11/23/2021 VEHICLE REPAIR 010-20.6150.570130 1,206.86 HOLMES MURPHY 627436 01/O1/2022 JAN '22 HMA MONTHLY CON 010-20.6150.100000 86.94 TERMINAL SUPPLY CO. 91076-00 11/22/2021 REMOVALTOOL 010-20.6150.590000 40.46 VERIZON WIRELESS 9895006208 12/13/2021 DECEMBER 2021 STATEMEN 010-20.6150.450000 105.60 IOWA MUNICIPALITIES WOR INV81716 01/O1/2022 JANUARY 2022 WORK COMP 010-20.6150.110000 92.00 Department 6150 - PUBLIC WORKS MECHANIC Total: 1,984.01 Department: 6500 - MEDIAN & BLDG GROUNDS MID-IOWA ELECTRIC, INC 30655711135 11/24/2021 REPLACE PHOTOCELL ON SIG 010-50.6500.340000 150.00 MID AMERICAN ENERGY 520501355 12/20/2021 DECEMBER 2021 STATEMEN 010-50.6500.480050 44.72 MID AMERICAN ENERGY 520502359 12/20/2021 DECEMBER 2021 STATEMEN 010-50.6500.480050 110.04 Department 6500 - MEDIAN & BLDG GROUNDS Total: 304.76 Department: 6510 - WATER UTILITY MUNICIPAL SUPPLY INC. 0820647-CM 12/08/2021 METER CREDIT 510-30.6510.592000 -4,360.50 MUNICIPAL SUPPLY INC. 0820980-IN 12/09/2021 METERS 510-30.6510.592000 36,174.00 AMAZON.COM 139K-XLQD-OJCI 11/26/2021 HIGH TORQUE IMPACT WRE 510-30.6510.590000 1,120.94 SUBSURFACE SOLUTIONS LLC 18265 11/09/2021 HD-80 SONDE 510-30.6510.590000 300.00 UNIVERSITY OF IOWA HYGIE 221926 11/30/2021 TESTING FEES 510-30.6510.250000 790.00 DELTA DENTAL 33075000200202201 01/O1/2022 JAN '22 DENTAL INSURANCE 510-30.6510.100000 63.13 DELTA DENTAL 33075000200202201 01/O1/2022 JAN'22 DENTAL INSURANCE 510-30.6510.100000 242.29 DELTA DENTAL 33075000200202201 01/O1/2022 JAN'22 DENTAL INSURANCE 510-30.6510.100000 66.86 DELTA DENTAL 33075000200202201 01/O1/2022 JAN'22 DENTAL INSURANCE 510-30.6510.100000 16.39 MID AMERICAN ENERGY 520416413 12/16/2021 DECEMBER 2021 STATEMEN 510-30,6510.480000 11.99 MID AMERICAN ENERGY 520497294 12/20/2021 DECEMBER 2021 STATEMEN 510-30.6510.480000 5.16 HOLMES MURPHY 627436 01/O1/2022 JAN'22 HMA MONTHLY CON 510-30.6510.100000 8.59 HOLMES MURPHY 627436 01/O1/2022 JAN'22 HMA MONTHLY CON 510-30.6510.100000 21.73 HOLMES MURPHY 627436 01/O1/2022 JAN'22 HMA MONTHLY CON 510-30.6510.100000 43.47 HOLMES MURPHY 627436 01/01/2022 JAN'22 HMA MONTHLY CON 510-30.6510.100000 112.73 LIMB BANK NA 908931 12/09/2021 2015B- FEES 510-30.6510.930100 250.00 UMB BANK NA 909062 12/09/2021 20188- FEES 510-30.6510.930100 300.00 CUSTOM AWARDS 94813 12/16/2021 CHERRY FINISH PLAQUE WIT 510-30.6510.590000 48.00 VERIZON WIRELESS 9895006208 12/13/2021 DECEMBER 2021 STATEMEN 510-30.6510.450000 421.21 WEST DES MOINES WATER INV0012733 01/04/2022 JANUARY 2022 WATER TOWE 510-30.6510.390300 419.18 IOWA MUNICIPALITIES WOR INV81716 01/01/2022 JANUARY 2022 WORK COMP 510-30,6510.110000 372.00 CORE & MAIN LP Q002435 11/24/2021 METERS 510-30.6510.592000 1,605.00 CORE & MAIN LP Q018808 11/30/2021 3 COMP FLG CI F/STL IMP 510-30.6510.590000 80.00 CORE & MAIN LP Q046789 12/07/2021 METERS 510-30.6510.592000 1,956.00 Department 6510 - WATER UTILITY Total: 40,068.17 Department: 6520 - SANITARY SEWERS & TREATMENT SUBSURFACE SOLUTIONS LLC 18265 11/09/2021 HD-80 SONDE 520-30.6520.590000 300.00 DELTA DENTAL 33075000200202201 01/O1/2022 JAN'22 DENTAL INSURANCE 520-30.6520.100000 242.29 12/29/2021 10:31:40 AM Page 5 of 15 Expense Approval Register Packet: APPKT02702 - JANUARY 3 2021 COUNCIL MEETING Vendor Name Payable Number Post Date Description (Item) Account Number Amount DELTA DENTAL 33075000200202201 01/O1/2022 JAN'22 DENTAL INSURANCE 520-30.6520.100000 63.13 DELTA DENTAL 33075000200202201 01/01/2022 JAN'22 DENTAL INSURANCE 520-30.6520.100000 16.39 MID AMERICAN ENERGY 520440031 12/16/2021 DECEMBER 2021 STATEMEN 520-30.6520.480000 549.32 MID AMERICAN ENERGY 520523868 12/20/2021 DECEMBER 2021 STATEMEN 520-30.6520.480000 25.94 MID AMERICAN ENERGY 520533322 12/20/2021 DECEMBER 2021 STATEMEN 520-30.6520.480000 286.47 HOLMES MURPHY 627436 01/01/2022 JAN '22 HMA MONTHLY CON 520-30.6520.100000 8.60 HOLMES MURPHY 627436 01/01/2022 JAN'22 HMA MONTHLY CON 520-30.6520.100000 21.73 HOLMES MURPHY 627436 01/01/2022 JAN'22 HMA MONTHLY CON 520-30.6520.100000 112.73 UMB BANK NA 908997 12/09/2021 2016C- FEES 520-30.6520.930100 250.00 UMB BANK NA 909056 12/09/2021 2018C- FEES 520-30.6520.930100 300.00 VERIZON WIRELESS 9895006208 12/13/2021 DECEMBER 2021 STATEMEN 520-30.6520.450000 213.65 CENTURYLINK INV0012789 12/10/2021 DECEMBER 2021 STATEMEN 520-30.6520.450000 56.26 IOWA MUNICIPALITIES WOR INV81716 01/O1/2022 JANUARY 2022 WORK COMP 520-30.6520.110000 105.00 Department 6520 - SANITARY SEWERS & TREATMENT Total: 2,551.51 Department: 6540 - GAS UTILITY UNITED PARCEL SERVICE OOOOAW7647491 12/04/2021 SHIPPING 540-30.6540.360000 114.48 UNITYPOINT CLINIC-OCCUPA 103678 12/O1/2021 QUARTERLY RANDOM DRUG 540-30.6540.470000 294.00 HEATH CONSULTANTS INCOR 1094735 12/O1/2021 ANNUAL CALIBRATION 540-30.6540.410400 438.47 INDUSTRIAL SALES COMPAN 1104984-000 12/14/2021 TAPPING TEES 540-30.6540.590200 1,385.90 INDUSTRIAL SALES COMPAN 1106842-001 12/06/2021 RISERS 540-30.6540.590200 160.74 INDUSTRIAL SALES COMPAN 1107826-001 12/06/2021 HIGHLINE VB CI LID GAS 540-30.6540.590100 512.69 INDUSTRIAL SALES COMPAN 1110802-000 12/06/2021 SLAP -ON JAW CABLES PAIR 540-30.6540.590000 115.30 INDUSTRIAL SALES COMPAN 1110821-000 12/07/2021 COUPLINGS 540-30.6540.590100 1,713.26 INDUSTRIAL SALES COMPAN 1110868-000 11/30/2021 METERS 540-30.6540.592000 7,308.00 INDUSTRIAL SALES COMPAN 1111622-000 12/06/2021 HDPE 4710 BF 90 61N 540-30.6540.590200 95.45 INDUSTRIAL SALES COMPAN 1111637-000 12/06/2021 RISERS/BALL VALVES/TAP TEE 540-30.6540.590200 230.62 INDUSTRIAL SALES COMPAN 1111645-000 12/06/2021 COUPLINGS 540-30.6540.590100 3,268.46 INDUSTRIAL SALES COMPAN 1111647-000 12/06/2021 8300 IPS 6X40 DR11 BLK W/ 540-30.6540.590100 4,954.28 IN DUSTRIAL SALES COM PAN 1111917-000 12/08/2021 COUPLINGS 540-30.6540.590100 563.47 INDUSTRIAL SALES COMPAN 1111948-000 12/08/2021 BLIND FLANGE STEEL 540-30.6540.590000 148.58 INDUSTRIAL SALES COMPAN 1112321-000 12/14/2021 HIGHLINE VB 24TTOP ONLY 540-30.6540.410400 171.09 GROEBNER & ASSOCIATES IN 115856-00 12/10/2021 RISERS 540-30.6540.590200 2,790.15 GROEBNER & ASSOCIATES IN 116010-00 12/09/2021 METERS 540-30.6540.592000 285.03 SUBSURFACE SOLUTIONS LLC 18265 11/09/2021 HD-80 SONDE 540-30.6540.590000 300.00 LOGOED APPAREL & PROMO 18854 12/13/2021 SHIRTS/FLEECE/SWEATSHIRT 540-30.6540.120000 767.86 LOGOED APPAREL & PROMO 18855 12/13/2021 SHIRT/FLEECE/SWEATSHIRTS 540-30.6540.120000 690.87 LOGOED APPAREL & PROMO 18856 12/13/2021 SHIRTS/SWEATSHIRTS- MAN 540-30.6540.120000 594.90 LOGOED APPAREL & PROMO 18857 12/13/2021 SHIRTS/FLEECE- DEZEEUW 540-30.6540.120000 412.34 LOGGED APPAREL & PROMO 18858 12/13/2021 SHIRTS/SWEATSHIRTS/FLEEC 540-30.6540.120000 828.18 LOGOED APPAREL & PROMO 18859 12/13/2021 SWEATSHIRT- VENTO 540-30.6540.120000 186.17 RED WING SHOE STORE 20211210102883 12/10/2021 BOOTS- DEZEEUW 540-30.6540.120000 251.99 GAS PRODUCTS SALES 21112-092 12/09/2021 METERS 540-30.6540.592000 12,890.65 MENARDS 21285 12/08/2021 TRASH CAN 540-30.6540.590000 37.97 IOWA ASSOCIATION OF MUN 24624 12/O1/2021 GAS PERSONNEL TRAINING S 540-30.6540.470000 295.50 INFRASOURCE CONSTRUCT] 3077144 12/08/2021 ASHLEY ACRES 540-30.6540.880100 23,112.21 INFRASOURCE CONSTRUCTI 3077532 12/15/2021 ASHLEY ACRES 540-30.6540.880100 18,701.04 DELTA DENTAL 33075000200202201 01/O1/2022 JAN'22 DENTAL INSURANCE 540-30.6540.100000 505.04 DELTA DENTAL 33075000200202201 01/O1/2022 JAN'22 DENTAL INSURANCE 540-30.6540.100000 63.13 DELTA DENTAL 33075000200202201 01/01/2022 JAN'22 DENTAL INSURANCE 540-30.6540.100000 16.39 ENERGY ECONOMICS 48827 11/30/2021 5 LB HIGH POT MAGNESIUM 540-30.6540.590200 868.68 MID AMERICAN ENERGY 520416413 12/16/2021 DECEMBER 2021 STATEMEN 540-30.6540.480000 11.98 MID AMERICAN ENERGY 520497294 12/20/2021 DECEMBER 2021 STATEMEN 540-30.6540.480000 5.16 HOLMES MURPHY 627436 01/01/2022 JAN'22 HMA MONTHLY CON 540-30.6540.100000 8.59 HOLMES MURPHY 627436 01/O1/2022 JAN'22 HMA MONTHLY CON 540-30.6540.100000 21.73 HOLMES MURPHY 627436 01/O1/2022 JAN'22 HMA MONTHLY CON 540-30.6540.100000 173.88 SWAGELOK 77452 12/15/2021 METERS 540-30.6540.592000 476.98 PLUMB SUPPLY COMPANY 7779809 12/09/2021 COUPLINGS 540-30.6540.590000 167.70 VERIZON WIRELESS 9895006208 12/13/2021 DECEMBER 2021 STATEMEN 540-30.6540.450000 406.94 UTILITY SAFETY AND DESIGN IN20215595 11/30/2021 10" PROJECT 540-30.6540.880100 3,270.00 WEST DES MOINES WATER INV0012733 01/04/2022 JANUARY 2022 WATER TOWE 540-30.6540.390300 419.17 12/29/2021 10:31:40 AM Page 6 of 15 Expense Approval Register Packet: APPKT02702 - JANUARY 3 2021 COUNCIL MEETING Vendor Name Payable Number Post Date Description (Item) Account Number Amount RICHARD & JUDY CORDLE INV0012790 12/13/2021 FURNACE REBATE 540-30.6540.685400 150.00 MICHAEL HOMAN INVO012796 12/02/2021 FURNACE REBATE 540-30.6540.685400 150.00 GREGORY WADDLE INVO012797 11/30/2021 FURNACE REBATE 540-30.6540.685400 75.00 CHARLES GAMBELL INVO012798 12/13/2021 THERMOSTAT REBATE 540-30.6540.685400 30.00 TRAVIS RIPPERGER INVO012799 12/02/2021 FURNACE REBATE 540-30.6540.685400 75.00 CHRISTY DENNIS INVO012800 12/02/2021 FURNACE REBATE 540-30.6540.685400 75.00 PENNY HATT INVO012801 11/23/2021 FURNACE REBATE 540-30.6540.685400 150.00 STEVE REIMAN INVO012802 11/23/2021 FURNACE REBATE 540-30.6540.685400 150.00 WAYNE PETERSON INVO012804 12/02/2021 FURNACE REBATE 540-30.6540.685400 150.00 JERRY DOUGHERTY INVO012805 11/24/2021 FURNACE REBATE 540-30.6540.685400 75.00 LORIE ROSEBROOK INVO012806 12/13/2021 FURNACE REBATE 540-30.6540.685400 150.00 CHUCK HENZE INVO012807 12/14/2021 FURNACE REBATE 540-30.6540.685400 150.00 STEVE DOWNER INVO012808 12/14/2021 FURNACE REBATE 540-30.6540.685400 75.00 ANSHUL BANSAL INVO012812 12/17/2021 THERMOSTAT REBATE 540-30.6540.685400 30.00 BRIAN NGOTHI INVO012813 12/17/2021 FURNACE REBATE 540-30,6540.685400 75.00 TRUSHAR SHUKLA INVO012814 12/20/2021 THERMOSTAT REBATE 540-30.6540.685400 30.00 JENNIFER MOFFATT INVO012815 12/20/2021 FURNACE REBATE 540-30.6540.685400 75.00 BOOT BARN INC INVO0141479 12/08/2021 PANTS- DEZEEUW 540-30.6540.120000 80.98 IOWA MUNICIPALITIES WOR INV81716 01/01/2022 JANUARY 2022 WORK COMP 540-30.6540.110000 323.00 Department 6540 - GAS UTILITY Total: 92,104.00 Department: 6550 - UTILITY BILLING TYLER TECHNOLOGIES INC 025-361742 01/01/2022 JANUARY 2022 ONLINE UTILI 570-30.6550.450200 175.00 DELTA DENTAL 33075000200202201 01/01/2022 JAN '22 DENTAL INSURANCE 570-30.6550.100000 99.64 HOLMES MURPHY 627436 01/01/2022 JAN'22 HMA MONTHLY CON 570-30.6550.100000 60.66 VERIZON WIRELESS 9895006204 12/13/2021 DECEMBER 2021 STATEMEN 570-30.6550.450000 41.42 IOWA MUNICIPALITIES WOR INV81716 01/01/2022 JANUARY 2022 WORK COMP 570-30.6550.110000 10.00 Department 6550 - UTILITY BILLING Total: 386.72 Department: 7100 - STREETS SUBSURFACE SOLUTIONS LLC 18265 11/09/2021 HD-80 SONDE 060-30.7100.590000 300.00 ARDICK EQUIPMENT CO., IN 2154 12/14/2021 STOP SIGNS/NO PARKING SI 060-30.7100.590600 1,955.00 DELTA DENTAL 33075000200202201 01/01/2022 JAN '22 DENTAL INSURANCE 060-30.7100.100000 63.13 DELTA DENTAL 33075000200202201 01/01/2022 JAN '22 DENTAL INSURANCE 060-30.7100.100000 453.90 SMITH FERTILIZER GRAIN 4007295 12/08/2021 BEETS 060-30.7100.591300 2,454.31 HOLMES MURPHY 627436 01/01/2022 JAN '22 HMA MONTHLY CON 060-30.7100.100000 173.88 HOLMES MURPHY 627436 01/01/2022 JAN '22 HMA MONTHLY CON 060-30.7100.100000 21.74 VERIZON WIRELESS 9895006207 12/13/2021 DECEMBER 2021 STATEMEN 060-30.7100.590600 80.02 VERIZON WIRELESS 9895006208 12/13/2021 DECEMBER 2021 STATEMEN 060-30.7100.450000 130.05 LOGAN CONTRACTORS SUPP A24751 12/06/2021 DETACK SURFACE TACK 060-30.7100.590400 565.80 IOWA MUNICIPALITIES WOR INV81716 01/01/2022 JANUARY 2022 WORK COMP 060-30.7100.110000 25.00 IOWA MUNICIPALITIES WOR INV81716 01/01/2022 JANUARY 2022 WORK COMP 060-30.7100.110000 1,014.00 Department 7100 - STREETS Total: 7,236.83 Department: 7800 - GO DEBT SERVICE UMB BANK NA 908767 12/09/2021 201OA- FEES 110-30.7800.930100 250.00 UMB BANK NA 908942 12/09/2021 2015C- FEES 110-30.7800.930100 250.00 UMB BANK NA 908984 12/09/2021 20166- FEES 110-30.7800.930100 250.00 UMB BANK NA 909006 12/09/2021 2017A- FEES 110-30.7800.930100 250.00 UMB BANK NA 909061 12/09/2021 2018A- FEES 110-30.7800.930100 300.00 UMB BANK NA 909102 12/09/2021 20208- FEES 110-30.7800.930100 600.00 Department 7800 - GO DEBT SERVICE Total: 1,900.00 Department: 7850 - TIF DEBT SERVICE AHLERS & COONEY PC 815413 12/21/2021 NORTH WAUKEE RESIDENTIA 090-30.7850.230000 57.00 AHLERS & COONEY PC 815415 12/21/2021 AMENDMENT NO. 5 TO CON 094-30.7850.230000 102.00 AHLERS & COONEY PC 815416 12/21/2021 AMENDMENT NO. 11 TO UNI 093-30.7850.230000 102.00 UMB BANK NA 908906 12/09/2021 2014A- FEES 110-30.7850.930100 250.00 Department 7850 - TIF DEBT SERVICE Total: 511.00 Department: 8100 - MAYOR & COUNCIL IOWA MUNICIPALITIES WOR INV81716 01/01/2022 JANUARY 2022 WORK COMP 010-60.8100.110000 3.00 Department 8100 - MAYOR & COUNCIL Total: 3.00 12/29/2021 10:31:40 AM Page 7 of 15 Expense Approval Register Packet: APPKT02702 - JANUARY 3 2021 COUNCIL MEETING Vendor Name Payable Number Post Date Description (Item) Account Number Amount Department: 8110 - ELECTIONS DALLAS COUNTY AUDITOR INVO012786 12/15/2021 NOVEMBER 2021 ELECTIONS 010-60.8110.231600 6,786.61 Department 8110 - ELECTIONS Total: 6,786.61 Department: 8200 - COMMUNICATIONS FEDEX OFFICE 046800027893 11/17/2021 WINTERFEST POSTERS 010-60.8200.350100 99.80 DELTA DENTAL 33075000200202201 01/01/2022 JAN'22 DENTAL INSURANCE 010-60.8200.100000 159.04 HOLMES MURPHY 627436 01/01/2022 JAN'22 HMA MONTHLY CON 010-60.8200.100000 60.66 STAPLES BUSINESS CREDIT 7339356942-0-2 09/27/2021 STICKY NOTES 010-60.8200.580000 18.29 STAPLES BUSINESS CREDIT 7339356942-0-3 09/23/2021 LETTER BROCHURE HOLDER 010-60.8200.590000 20.99 STAPLES BUSINESS CREDIT 7339356942-1-1 09/23/2021 EASEL CREDIT 010-60.8200.590000 -25.20 STAPLES BUSINESS CREDIT 7339356942-2-1 09/23/2021 SIGN HOLDER CREDIT 010-60.8200.580000 -1.00 VERIZON WIRELESS 9895006204 12/13/2021 DECEMBER 2021 STATEMEN 010-60.8200.450000 41.42 IOWA MUNICIPALITIES WOR INV81716 01/01/2022 JANUARY 2022 WORK COMP 010-60.8200.110000 8.00 Department 8200 - COMMUNICATIONS Total: 382.00 Department: 8300 - ADMINISTRATION SESAC, INC 10533363 01/04/2022 FY22 MUSIC LICENSE 010-60.8300.280000 513.00 SIMMERING-CORY INC 2021-IC-0463 11/24/2021 NOVEMBER 2021 SUPPLEME 010-60.8300.230000 213.00 DELTA DENTAL 33075000200202201 01/01/2022 JAN'22 DENTAL INSURANCE 010-60.8300.100000 319.38 MID AMERICAN ENERGY 520560625 12/20/2021 DECEMBER 2021 STATEMEN 010-60.8300.390400 27.60 HOLMES MURPHY 627436 01/01/2022 JAN'22 HMA MONTHLY CON 010-60.8300.100000 130.41 STAPLES BUSINESS CREDIT 7340475851-0-1 09/29/2021 PAGE MARKERS/GORILLA GL 010-60.8300.580000 7.79 STAPLES BUSINESS CREDIT 7340475851-0-1 09/29/2021 PAGE MARKERS/GORILLA GL 010-60.8300.590000 7.79 STAPLES BUSINESS CREDIT 7341036448-0-1 10/06/2021 PAPE R/COFFEE/H IGH LIG HTE 010-60.8300.580000 55.28 STAPLES BUSINESS CREDIT 7341036448-1-1 10/14/2021 HIGHLIGHTERS 010-60.8300.580000 -1.10 STAPLES BUSINESS CREDIT 7342031216-0-1 10/20/2021 PAPER/PICTURE HANGING ST 010-60.8300.580000 45.99 STAPLES BUSINESS CREDIT 7343159931-0-1 11/05/2021 CALENDAR 010-60.8300.580000 15.49 STAPLES BUSINESS CREDIT 7343159931-0-2 11/04/2021 CALENDARS/STAPLES 010-60.8300.580000 13.98 STAPLES BUSINESS CREDIT 7343159931-0-3 11/09/2021 FRAME BORDER 010-60.8300.590000 33.87 STAPLES BUSINESS CREDIT 7344753969-0-1 11/30/2021 PAPER 010-60.8300.580000 95.98 STAPLES BUSINESS CREDIT 7345545872-0-1 12/09/2021 FOLDERS/PLASTIC FORKS & S 010-60.8300.580000 84.64 PREMIERE GLOBAL SERVICES 871950 11/30/2021 NOVEMBER 2021 STATEMEN 010-60.8300.450000 3.15 KONICA MINOLTA BUSINESS 9008227267 11/30/2021 COPIER/PRINTER LEASE & M 010-60.8300.270110 34.90 VERIZON WIRELESS 9895006204 12/13/2021 DECEMBER 2021 STATEMEN 010-60.8300.450000 41.42 AMERICAN SOCIETY OF COM INVO012788 12/20/2021 FY22 MUSIC LICENSE 010-60.8300.280000 390.00 DES MOINES REGISTER INVO012791 01/04/2022 JANUARY 2022 SUBSCRIPTIO 010-60.8300.280000 37.00 DALLAS COUNTY RECORDER INVO012794 11/30/2021 NOVEMBER 2021 STATEMEN 010-60.8300.230000 958.00 IOWA MUNICIPALITIES WOR INV81716 01/01/2022 JANUARY 2022 WORK COMP 010-60.8300.110000 16.00 Department 8300 - ADMINISTRATION Total: 3,043.57 Department: 8310 - CITY HALL NATIONWIDE OFFICE CLEAN 4731 12/15/2021 CLEANING SERVICES- ANNEX 010-60.8310.400100 675.48 NATIONWIDE OFFICE CLEAN 4732 12/15/2021 CLEANING SERVICES- CITY H 010-60.8310.400100 936.67 MID AMERICAN ENERGY 520518018 12/20/2021 DECEMBER 2021 STATEMEN 010-60.8310.480000 143.75 MID AMERICAN ENERGY 520527447 12/20/2021 DECEMBER 2021 STATEMEN 010-60.8310.390600 71.22 MID AMERICAN ENERGY 520568173 12/20/2021 DECEMBER 2021 STATEMEN 010-60.8310.480000 147.90 STAPLES BUSINESS CREDIT 7341036448-0-1 10/06/2021 PAPER/COFFEE/HIGHLIGHTE 010-60.8310.590000 11.69 STAPLES BUSINESS CREDIT 7342031216-0-1 10/20/2021 PAPER/PICTURE HANGING ST 010-60.8310.590000 8.29 STAPLES BUSINESS CREDIT 7342534283-0-1 10/27/2021 PICTURE HANGING STRIPS/P 010-60.8310.590000 59.27 STAPLES BUSINESS CREDIT 7345545872-0-1 12/09/2021 FOLDERS/PLASTIC FORKS & S 010-60.8310.590000 29.28 Department 8310 - CITY HALL Total: 2,083.55 Department: 8350 - HUMAN RESOURCES DELTA DENTAL 33075000200202201 01/01/2022 JAN'22 DENTAL INSURANCE 010-60.8350.100000 252.52 CITIES DIGITAL, INC 53160 11/17/2021 LASERFICHE SUPPORT/EMPL 010-60.8350.270000 17,920.00 HOLMES MURPHY 627436 01/01/2022 JAN'22 HMA MONTHLY CON 010-60.8350.100000 86.94 STAPLES BUSINESS CREDIT 7340814042-0-1 10/04/2021 CALENDAR 010-60,8350.580000 61.18 KONICA MINOLTA BUSINESS 9008227267 11/30/2021 COPIER/PRINTER LEASE & M 010-60.8350.270110 49.52 VERIZON WIRELESS 9895006204 12/13/2021 DECEMBER 2021 STATEMEN 010-60.8350.450000 92.91 IOWA MUNICIPALITIES WOR INV81716 01/01/2022 JANUARY 2022 WORK COMP 010-60.8350.110000 10.00 Department 8350 - HUMAN RESOURCES Total: 18,473.07 12/29/2021 10:31:40 AM Page 8 of 15 Expense Approval Register Packet: APPKT02702 -JANUARY 3 2021 COUNCIL MEETING Vendor Name Payable Number Post Date Description (Item) Account Number Amount Department: 8400 - FINANCIAL ADMINISTRATION REGISTER MEDIA 0004264946 11/30/2021 NOVEMBER 2021 PUBLICATI 010-60.8400.210000 140.83 TYLER TECHNOLOGIES INC 025-358982 11/17/2021 POSITION BUDGETING 010-60.8400.470000 130.00 DES MOINES STAMP MFG CO 1192331 12/16/2021 PAID STAMP 010-60.8400.580000 68.00 AMAZON.COM 146K-14DP-MRMP 12/15/2021 STAND UP DESK 010-60.8400.540000 316.79 DELTA DENTAL 33075000200202201 01/01/2022 JAN'22 DENTAL INSURANCE 010-60.8400.100000 141.98 HOLMES MURPHY 627436 01/01/2022 JAN'22 HMA MONTHLY CON 010-60.8400.100000 86.94 STAPLES BUSINESS CREDIT 7343159931-0-2 11/04/2021 CALENDARS/STAPLES 010-60.8400.580000 47.58 KONICA MINOLTA BUSINESS 9008227267 11/30/2021 COPIER/PRINTER LEASE & M 010-60.8400.270110 65.99 KONICA MINOLTA BUSINESS 9008227267 11/30/2021 COPIER/PRINTER LEASE & M 010-60.8400.270110 15.38 KONICA MINOLTA BUSINESS 9008227267 11/30/2021 COPIER/PRINTER LEASE & M 010-60.8400.270110 15.38 VERIZON WIRELESS 9895006204 12/13/2021 DECEMBER 2021 STATEMEN 010-60.8400.450000 81.43 STAPLES BUSINESS CREDIT INVO012736 11/25/2021 LATE FEE 010-60.8400.580000 10.00 IOWA MUNICIPALITIES WOR INV81716 01/01/2022 JANUARY 2022 WORK COMP 010-60.9400.110000 20.00 Department 8400 - FINANCIAL ADMINISTRATION Total: 1,140.30 Department: 8500 - COMMUNITY DEVELOPMENT AMAZON.COM 19Y1-CTXX-J1KT 12/02/2021 IPAD PENCILS 010-50.8500.540000 298.63 DELTA DENTAL 33075000200202201 01/01/2022 JAN'22 DENTAL INSURANCE 010-50.8500.100000 126.26 HOLMES MURPHY 627436 01/01/2022 JAN'22 HMA MONTHLY CON 010-50.8S00.100000 43.47 STAPLES BUSINESS CREDIT 73399069OG-1-1 09/30/2021 FOLDER CREDIT 010-50.8500.580000 -54.66 STAPLES BUSINESS CREDIT 7340654186-0-1 10/10/2021 CLIPBOARDS/MESH WALL FIL 010-50.8500.580000 73.26 STAPLES BUSINESS CREDIT 7343159931-0-2 11/04/2021 CALENDARS/STAPLES 010-50.8500.580000 11.59 STAPLES BUSINESS CREDIT 7343199868-0-1 11/05/2021 MANILA FOLDERS/PLASTIC S 010-50.8500.580000 46.98 STAPLES BUSINESS CREDIT 7343199868-0-1 11/05/2021 MANILA FOLDERS/PLASTIC S 030-50.8500.590000 6.99 STAPLES BUSINESS CREDIT 7343204102-0-3 11/05/2021 NOTARY PUBLIC RECORD BO 010-50.8500.580000 15.49 STAPLES BUSINESS CREDIT 7344303899-0-1 11/19/2021 PENS/POSTATS/FOLDER TABS 010-50.8500.580000 71.26 STAPLES BUSINESS CREDIT 7344303899-1-1 11/26/2021 PENS CREDIT 010-50.8500.580000 -4.20 STAPLES BUSINESS CREDIT 7344303899-2-1 11/26/2021 PENS CREDIT 010-50.8500.580000 -5.81 STAPLES BUSINESS CREDIT 7344804884-0-1 11/30/2021 TONER 010-50.8500.580000 169.45 VERIZON WIRELESS 9895006204 12/13/2021 DECEMBER 2021 STATEMEN 010-50.8500.450000 31.42 IOWA MUNICIPALITIES WOR INV81716 01/01/2022 JANUARY 2022 WORK COMP 010-50.8500.110000 117.00 Department 8500 - COMMUNITY DEVELOPMENT Total: 947.13 Department: 8600 - CITY ATTORNEY BRICK GENTRY BOWERS SWA 365292 11/25/2021 NOVEMBER 2021 STATEMEN 010-60.8600.230000 11,160.00 Department 8600 - CITY ATTORNEY Total: 11,160.00 Department: 8700 - DEVELOPMENT SERVICES MCCLURE ENGINEERING CO 137094 11/30/2021 WAUKEE ANNEXATION- HUN 010-50.8700.230000 2,500.00 LOGOED APPAREL & PROMO 18869 12/16/2021 SHIRTS 010-50.8700.120000 121.14 AMAZON.COM 1M6Q-1HTM-HF4K 12/16/2021 DUAL MONITOR DESK MOU 010-50.8700.540000 69.98 CONFLUENCE 21445 08/11/2021 NORTHERN NEIGHBORHOOD 010-50.8700.230000 4,485.00 CONFLUENCE 22333 12/16/2021 BURT PROPERTY MASTER Pl. 010-50.8700.230000 1,621.50 DELTA DENTAL 33075000200202201 01/01/2022 JAN'22 DENTAL INSURANCE 010-50.8700.100000 191.82 HOLMES MURPHY 627436 01/01/2022 JAN'22 HMA MONTHLY CON 010-50.8700.100000 77.85 STAPLES BUSINESS CREDIT 7343204102-0-2 11/16/2021 STAMP 010-50.8700.580000 18.99 KONICA MINOLTA BUSINESS 9008227267 11/30/2021 COPIER/PRINTER LEASE & M 010-50.8700.270110 34.90 VERIZON WIRELESS 9895006204 12/13/2021 DECEMBER 2021 STATEMEN 010-50.8700.450000 92.25 IOWA MUNICIPALITIES WOR INV81716 01/01/2022 JANUARY 2022 WORK COMP 010-50.8700.110000 270.00 Department 8700 - DEVELOPMENT SERVICES Total: 9,483.43 Department: 8750 - SUGAR CREEK MUNICIPAL DELTA DENTAL 33075000200202201 01/01/2022 JAN'22 DENTAL INSURANCE 750-80.8750.100000 42.09 ELITE ROOFING AND EXTERI 3398 11/29/2021 ROOFING PROJECT 750-80.8750.400000 16,610.00 BUSINESS NETWORK LONG D 42852521 12/14/2021 DECEMBER 2021 STATEMEN 750-80.8750.450000 17.09 VAN -WALL EQUIPMENT INC 5413991 12/14/2021 GASKET/OIL FILTER/DRAIN Pl. 750-80.8750.410100 16.48 HOLMES MURPHY 627436 01/01/2022 JAN'22 HMA MONTHLY CON 750-80.8750.100000 14.49 VERIZON WIRELESS 9895006206 12/13/2021 DECEMBER 2021 STATEMEN 750-80.8750.450000 97.06 IOWA MUNICIPALITIES WOR INV81716 01/01/2022 JANUARY 2022 WORK COMP 750-80.8750.110000 85.00 Department 8750 - SUGAR CREEK MUNICIPAL Total: 16,882.21 Department: 8800 - INFORMATION TECHNOLOGY AMAZON.COM 13P3-JNPD-79YV 12/02/2021 ANTENNA EXTENSION CABLI 010-60.8800.540000 34.78 12/29/2021 10:31:40 AM Page 9 of 15 Expense Approval Register Packet: APPKT02702 - JANUARY 3 2021 COUNCIL MEETING Vendor Name Payable Number Post Date Description (Item) Account Number Amount DELTA DENTAL 33075000200202201 01/01/2022 JAN'22 DENTAL INSURANCE 010-60.8800.100000 234.16 CITIES DIGITAL, INC 53160 11/17/2021 LASERFICHE SUPPORT/EMPL 010-60.8800.270000 10,080.00 HOLMES MURPHY 627436 01/01/2022 JAN'22 HMA MONTHLY CON 010-60.8800.100000 104.13 VERIZON WIRELESS 9895006204 12/13/2021 DECEMBER 2021 STATEMEN 010-60.8800.450000 80.02 SHI INTERNATIONAL CORP B14423673 11/30/2021 SECURITY SOFTWARE RENE 010-60.8800.270000 1,040.00 SHI INTERNATIONAL CORP B14444517 12/06/2021 ID BADGES FOR CITY EMPLO 010-60.8800.590000 1,240.00 SHI INTERNATIONAL CORP B14466566 12/09/2021 LENOVOTHINKPADS 010-60.8800.540000 2,019.14 SH I INTERNATIONAL CORP B14473663 12/13/2021 LENOVOHARDWARE/SERVIC 010-60.8800.540000 63.00 IOWA MUNICIPALITIES WOR INV81716 01/01/2022 JANUARY 2022 WORK COMP 010-60.8800.110000 18.00 Department 8800 - INFORMATION TECHNOLOGY Total: 14,913.23 Department: 8900 - ENGINEERING DENT ELIMINATORS 114415 07/28/2021 DETAIL 010-20.8900.410000 150.00 DELTA DENTAL 33075000200202201 01/01/2022 JAN'22 DENTAL INSURANCE 010-20.8900.100000 350.86 HOLMES MURPHY 627436 01/01/2022 JAN'22 HMA MONTHLY CON 010-20.8900.100000 138.51 KONICA MINOLTA BUSINESS 9008227267 11/30/2021 COPIER/PRINTER LEASE & M 010-20.8900.270110 34.90 VERIZON WIRELESS 9895006208 12/13/2021 DECEMBER 2021 STATEMEN 010-20.8900.450000 315.08 DALLAS COUNTY RECORDER INVO012794 11/30/2021 NOVEMBER 2021 STATEMEN 010-20.8900.231200 1,179.00 IOWA MUNICIPALITIES WOR INV81716 01/01/2022 JANUARY 2022 WORK COMP 010-20.8900.110000 145.00 Department 8900 - ENGINEERING Total: 2,313.35 Department: 8950 - GIS DELTA DENTAL 33075000200202201 01/01/2022 JAN'22 DENTAL INSURANCE 010-20.8950.100000 32.78 HOLMES MURPHY 627436 01/01/2022 JAN'22 HMA MONTHLY CON 010-20.8950.100000 17.19 VERIZON WIRELESS 9895006204 12/13/2021 DECEMBER 2021 STATEMEN 010-20.8950.450000 120.23 VERIZON WIRELESS 9895006207 12/13/2021 DECEMBER 2021 STATEMEN 010-20.8950.450000 40.01 VERIZON WIRELESS 9895006208 12/13/2021 DECEMBER 2021 STATEMEN 010-20.8950.450000 258.66 IOWA MUNICIPALITIES WOR INV81716 01/01/2022 JANUARY 2022 WORK COMP 010-20.8950.110000 72.00 Department 8950 - GIS Total: 540.87 Grand Total: 341,921.14 12/29/2021 10:31:40 AM Page 10 of 15 Expense Approval Register Packet: APPKT02702 - JANUARY 3 2021 COUNCIL MEETING Fund Summary Fund 010-GENERAL FUND 060 - ROAD USE TAX FUND 090 - NORTH RESIDENTIAL TIF 093 - WAUKEE URBAN RENEWAL AREA 094 - GATEWAY URBAN RENEWAL 110- DEBT SERVICE FUND 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 750- GOLF COURSE FUND Account Number 010-10.1100.100000 010-10.1100.110000 010-10.1100.120000 010-10.1100.230000 010-10.1100.270110 010-10.1100.280000 010-10.1100.400000 010-10.1100.410000 010-10.1100.450000 010-10.1100.470000 010-10.1100.480000 010-10.1100.540000 010-10.1100.580000 010-10.1100.590000 010-10.1400.100000 010-10.1400.110000 010-10.1400.270110 010-10.1400.450000 010-10.1400.480000 010-10.1400.540000 010-10.1400.580000 010-10.1400.590000 010-10.1500.100000 010-10.1500.110000 010-10.1500.270100 010-10.1500.360000 010-10.1500.450000 010-10.1500.480000 010-10.1500.580000 010-10.1500.590050 010-10.1900.100000 010-10.1900.110000 010-10.1900.120000 010-10.1900.280000 010-10.1900.450000 010-10.1900.470000 010-10.1900.540000 010-10.1900.580000 010-20.6000.100000 010-20.6000.110000 010-20.6000.270100 010-20.6000.450000 Grand Total: Account Summary Account Name HEALTH & LIFE INSURAN WORKERS COMPENSATI UNIFORMS CONSULTANT & PROFES COPIER / PRINTER LEASE DUES, MEMBERSHIPS & REPAIR/MAINTENANCE REPAIR OF VEHICLES TELEPHONE TRAINING/TRAVEL EXPE UTILITY SERVICES MINOR EQUIPMENT OFFICE SUPPLIES OPERATING SUPPLIES & HEALTH & LIFE INSURAN WORKERS COMPENSATI COPIER / PRINTER LEASE TELEPHONE UTILITY SERVICES MINOR EQUIPMENT OFFICE SUPPLIES OPERATING SUPPLIES & HEALTH & LIFE INSURAN WORKERS COMPENSATI COMPUTER SUPPORT POSTAGE & SHIPPING TELEPHONE UTILITY SERVICES OFFICE SUPPLIES MEDICAL SUPPLIES HEALTH & LIFE INSURAN WORKERS COMPENSATI UNIFORMS DUES, MEMBERSHIPS & TELEPHONE TRAINING/TRAVEL EXPE MINOR EQUIPMENT OFFICE SUPPLIES HEALTH & LIFE INSURAN WORKERS COMPENSATI COMPUTER SUPPORT TELEPHONE Expense Amount 145,988.49 16,891.32 57.00 102.00 102.00 2,150.00 23,975.37 40,068.17 2,551.51 92,104.00 662.35 386.72 16,882.21 341,921.14 Expense Amount 3,622.24 1,925.00 685.64 136.25 65.66 60.00 224.10 1,241.09 967.11 220.00 705.54 1,180.06 400.03 457.97 803.03 7,236.00 17.45 89.89 467.63 197.S0 16.14 297.33 1,392.86 10,672.00 17.45 33.73 318.72 467.62 16.15 192.14 771.19 136.00 821.92 275.06 480.97 941.04 2,082.14 204.68 729.85 147.00 52.35 236.71 12/29/2021 10:31:40 AM Page 11 of 15 Expense Approval Register Packet: APPKT02702 - JANUARY 3 2021 COUNCIL MEETING Account Summary Account Number Account Name Expense Amount 010-20.6000.590000 OPERATING SUPPLIES & 35.74 010-20.6010.400000 REPAIR/MAINTENANCE 3,216.58 010-20.6010.450000 TELEPHONE 113.66 010-20.6010.480000 UTILITY SERVICES 1,313.22 010-20.6010.580000 OFFICE SUPPLIES 124.70 010-20.6010.590000 OPERATING SUPPLIES & 292.89 010-20.6150.100000 HEALTH & LIFE INSURAN 280.06 010-20.6150.110000 WORKERS COMPENSATI 92.00 010-20.6150.450000 TELEPHONE 105.60 010-20.6150.570100 COGS - OIL 149.66 010-20.6150.570110 COGS - FILTERS 109.37 010-20.6150.570130 COGS - PARTS 1,206.86 010-20.6150.590000 OPERATING SUPPLIES & 40.46 010-20.8900.100000 HEALTH & LIFE INSURAN 489.37 010-20.8900.110000 WORKERS COMPENSATI 145.00 010-20.8900.231200 DEVELOPERS ENGINEERI 1,179.00 010-20.8900.270110 COPIER / PRINTER LEASE 34.90 010-20.8900.410000 REPAIR OF VEHICLES 150.00 010-20.8900.450000 TELEPHONE 315.08 010-20.8950.100000 HEALTH & LIFE INSURAN 49.97 010-20.8950.110000 WORKERS COMPENSATI 72.00 010-20.8950.450000 TELEPHONE 418.90 010-40.3100.100000 HEALTH & LIFE INSURAN 760.00 010-40.3100.110000 WORKERS COMPENSATI 27.00 010-40.3100.270000 DATA PROCESSING 4,873.00 010-40.3100.270110 COPIER / PRINTER LEASE 69.78 010-40.3100.400000 REPAIR/MAINTENANCE 1,238.64 010-40.3100.450000 TELEPHONE 41.42 010-40.3100.460300 PROGRAMS 2,313.39 010-40.3100.460400 SUMMER READING CLU 169.10 010-40.3100.480000 UTILITY SERVICES 2,351.18 010-40.3100.540000 MINOR EQUIPMENT 399.00 010-40.3100.580000 OFFICE SUPPLIES 160.26 010-40.3100.590000 OPERATING SUPPLIES & 1,607.14 010-40.3100.640000 LIBRARY BOOKS/FILMS/ 8,257.88 010-40.4100.100000 HEALTH & LIFE INSURAN 326.25 010-40.4100.110000 WORKERS COMPENSATI 274.00 010-40.4100.410100 REPAIR/MAINTENANCE 95.36 010-40.4100.410300 REPAIR/MAINTENANCE 24.84 010-40.4100.450000 TELEPHONE 182.96 010-40.4100.480000 UTILITY SERVICES 344.15 010-40.4100.480010 UTILITIES -DOG PARK 23.79 010-40.4100.540000 MINOR EQUIPMENT 854.72 010-40.4100.590000 OPERATING SUPPLIES & 424.80 010-40.4200.100000 HEALTH & LIFE INSURAN 439.40 010-40.4200.110000 WORKERS COMPENSATI 410.00 010-40.4200.270110 COPIER / PRINTER LEASE 17.45 010-40.4200.280000 DUES, MEMBERSHIPS & 168.00 010-40.4200.450000 TELEPHONE 243.77 010-40.4200.461700 WINTER FEST 49.99 010-40.4210.100000 HEALTH & LIFE INSURAN 56.57 010-40.4210.110000 WORKERS COMPENSATI 37.00 010-40.4210.450000 TELEPHONE 17.04 010-40.4310.400000 REPAIR/MAINTENANCE 69.70 010-50.6500.340000 MISCELLANEOUS CONTR 150.00 010-50.6500.480050 UTILITIES -TRAILS 154.76 010-50.8500.100000 HEALTH & LIFE INSURAN 169.73 010-50.8500.110000 WORKERS COMPENSATI 117.00 12/29/2021 10:31:40 AM Page 12 of 15 Expense Approval Register Packet: APPKT02702 - JANUARY 3 2021 COUNCIL MEETING Account Summary Account Number Account Name Expense Amount 010-50.8500.450000 TELEPHONE 31.42 010-50.8500.540000 MINOR EQUIPMENT 298.63 010-50.8500.580000 OFFICE SUPPLIES 323.36 010-50.8500.590000 OPERATING SUPPLIES & 6.99 010-50.8700.100000 HEALTH & LIFE INSURAN 269.67 010-50.8700.110000 WORKERS COMPENSATI 270.00 010-50.8700.120000 UNIFORMS 121.14 010-50.8700.230000 CONSULTANT & PROFES 8,606.50 010-50.8700.270110 COPIER / PRINTER LEASE 34.90 010-50.8700.450000 TELEPHONE 92.25 010-50.8700.540000 MINOR EQUIPMENT 69.98 010-50.8700.580000 OFFICE SUPPLIES 18.99 010-60.8100.110000 WORKERS COMPENSATI 3.00 010-60.8110.231600 ELECTION EXPENSE 6,786.61 010-60.8200.100000 HEALTH & LIFE INSURAN 219.70 010-60.8200.110000 WORKERS COMPENSATI 8.00 010-60.8200.350100 PRINTING SERVICES 99.80 010-60.8200.450000 TELEPHONE 41.42 010-60.8200.580000 OFFICE SUPPLIES 17.29 010-60.8200.590000 OPERATING SUPPLIES & -4.21 010-60.8300.100000 HEALTH & LIFE INSURAN 449.79 010-60.8300.110000 WORKERS COMPENSATI 16.00 010-60.8300.230000 CONSULTANT & PROFES 1,171.00 010-60.8300.270110 COPIER/ PRINTER LEASE 34.90 010-60.8300.280000 DUES, MEMBERSHIPS & 940.00 010-60.8300.390400 NORTHVIEW RENTAL PR 27.60 O10-60.8300.450000 TELEPHONE 44.57 010-60.8300.580000 OFFICE SUPPLIES 318.05 010-60.8300.590000 OPERATING SUPPLIES & 41.66 010-60.8310.390600 PROF PLAZA CAM EXPEN 71.22 010-60.8310.400100 CUSTODIAL SERVICES 1,612.15 010-60.8310.480000 UTILITY SERVICES 291.65 010-60.8310.590000 OPERATING SUPPLIES & 108.53 010-60.8350.100000 HEALTH & LIFE INSURAN 339.46 010-60.8350.110000 WORKERS COMPENSATI 10.00 010-60.8350.270000 DATA PROCESSING 17,920.00 010-60.8350.270110 COPIER / PRINTER LEASE 49.52 010-60.8350.450000 TELEPHONE 92.91 010-60.8350.580000 OFFICE SUPPLIES 61.18 010-60.8400.100000 HEALTH & LIFE INSURAN 228.92 010-60.8400.110000 WORKERS COMPENSATI 20.00 010-60.8400.210000 PUBLIC NOTIFICATION/A 140.83 010-60.8400.270110 COPIER / PRINTER LEASE 96.75 010-60.8400.450000 TELEPHONE 81.43 010-60.8400.470000 TRAINING/TRAVEL EXPE 130.00 010-60.8400.540000 MINOR EQUIPMENT 316.79 010-60.8400.580000 OFFICE SUPPLIES 125.58 010-60.8600.230000 CONSULTANT & PROFES 11,160.00 010-60.8800.100000 HEALTH & LIFE INSURAN 338.29 010-60.8800.110000 WORKERS COMPENSATI 18.00 010-60.8800.270000 DATA PROCESSING 11,120.00 010-60.8800.450000 TELEPHONE 80.02 010-60.8800.540000 MINOR EQUIPMENT 2,116.92 010-60.8800.590000 OPERATING SUPPLIES & 1,240.00 060-30.1600.480000 UTILITY SERVICES 291.42 060-30.1601.410300 REPAIR/MAINTENANCE F 2,550.00 060-30.1601.480000 UTILITY SERVICES 140.07 060-30.1601.760000 OTHER CAPITAL EQUIPM 6,673.00 12/29/2021 10:31:40 AM Page 13 of 15 Expense Approval Register Packet: APPKT02702 - JANUARY 3 2021 COUNCIL MEETING Account Summary Account Number Account Name Expense Amount 060-30.7100.100000 HEALTH & LIFE INSURAN 712.65 060-30.7100.110000 WORKERS COMPENSATI 1,039.00 060-30.7100.450000 TELEPHONE 130.05 060-30.7100.590000 OPERATING SUPPLIES & 300.00 060-30.7100.590400 ROAD REPAIR -PATCH 565.80 060-30.7100.590600 STREET SIGNS 2,035.02 060-30.7100.591300 CALCIUM CHLORIDE 2,454.31 090-30.7850.230000 CONSULTANT & PROFES 57.00 093-30.7850.230000 CONSULTANT/PROFESSI 102.00 094-30.7850.230000 CONSULTANT/PROFESSI 102.00 110-30.7800.930100 REGISTRAR/SERVICE FEE 1,900.00 110-30.7850.930100 REGISTRAR/SERVICE FEE 250.00 327-90.2150.980110 HS REC COMPLEX - CON 13,090.37 327-90.4100.880089 SUGAR CREEK/DAYBREA 10,885.00 510-30.6510.100000 HEALTH & LIFE INSURAN 575.19 510-30.6510.110000 WORKERS COMPENSATI 372.00 510-30.6510.250000 TESTING FEES 790.00 510-30.6510,390300 TOWER RENT 419.18 510-30.6510.450000 TELEPHONE 421.21 510-30.6510.480000 UTILITY SERVICES 17.15 510-30.6510.590000 OPERATING SUPPLIES & 1,548.94 510-30.6510.592000 METER PURCHASE 35,374.50 510-30.6510.930100 REGISTRAR/SERVICE FEE 550.00 520-30.6520.100000 HEALTH & LIFE INSURAN 464.87 520-30.6520.110000 WORKERS COMPENSATI 105.00 520-30.6520.450000 TELEPHONE 269.91 520-30.6520.480000 UTILITY SERVICES 861.73 520-30.6520.590000 OPERATING SUPPLIES & 300.00 520-30.6520.930100 REGISTRAR/SERVICE FEE 550.00 540-30.6540.100000 HEALTH & LIFE INSURAN 788.76 540-30.6540.110000 WORKERS COMPENSATI 323.00 540-30.6540.120000 UNIFORMS 3,813.29 540-30.6540.360000 POSTAGE & SHIPPING 114.48 540-30.6540.390300 TOWER RENT 419.17 540-30.6540.410400 REPAIR/MAINT OF DELIV 609.56 540-30.6540.450000 TELEPHONE 406.94 540-30.6540.470000 TRAINING/TRAVEL EXPE 589.50 540-30.6540.480000 UTILITY SERVICES 17.14 540-30.6540.590000 OPERATING SUPPLIES & 769.55 540-30.6540.590100 DEVELOPER MATERIALS 11,012.16 540-30.6540.590200 INSTALLATION MATERIA 5,531.54 540-30.6540.592000 METER PURCHASE 20,960.66 540-30.6540.685400 GAS REBATE 1,665.00 540-30.6540.880100 DISTRIBUTION SYSTEM 1 45,083.25 560-80.5300.100000 HEALTH & LIFE INSURAN 244.69 560-80.5300.110000 WORKERS COMPENSATI 141.00 560-80.5300.450000 TELEPHONE 276.66 570-30.6550.100000 HEALTH & LIFE INSURAN 160.30 570-30.6550.110000 WORKERS COMPENSATI 10.00 570-30.6550.450000 TELEPHONE 41.42 570-30.6550.450200 CREDIT CARD FEES 175.00 750-80.8750.100000 HEALTH & LIFE INSURAN 56.58 750-80.8750.110000 WORKERS COMPENSATI 85.00 750-80.8750.400000 REPAIR/MAINTENANCE 16,610.00 750-80.8750.410100 REPAIR/MAINTENANCE 16.48 750-80.8750.450000 TELEPHONE 114.15 Grand Total: 341,921.14 12/29/2021 10:31:40 AM Page 14 of 15 Expense Approval Register Packet: APPKT02702 - JANUARY 3 2021 COUNCIL MEETING Project Account Summary Project Account Key Expense Amount **None** 314,675.77 CONSULTING DAYBREAK PARK 10,885.00 CONSULTING-10" GAS MAIN 3,270.00 CONSULTING-HS ATHLETIC COMPLEX 13,090.37 Grand Total: 341,921.14 12/29/2021 10:31:40 AM Page 15 of 15 City of Waukee, IA �rl 1 Ubukee Vendor Number Vendor Name Payment Date Payment Type Bank Code: AP-WAUKEE STATE 038425 COSTAR REALTY INFORMATION INC 12/17/2021 Regular Payable # Payable Type Post Date Payable Description Account Number Account Name Item Description 114392628-1 Invoice 08/05/2021 COSTAR SUITE 010-50.8500.270100 COMPUTER SUPPORT COSTAR SUITE 114645002-1 Invoice 09/04/2021 COSTAR SUITE 010-50.8500.270100 COMPUTER SUPPORT COSTAR SUITE 114824490-1 Invoice 10/05/2021 COSTAR SUITE 010-50.8500.270100 COMPUTER SUPPORT COSTAR SUITE 114886575-1 Invoice 11/03/2021 COSTAR SUITE 010-50.8500.270100 COMPUTER SUPPORT COSTAR SUITE Check Report By Check Number Date Range: 12/15/2021 - 12/20/2021 Discount Amount Payment Amount Number 0.00 1,580.00 149783 Discount Amount Payable Amount Distribution Amount 0.00 395.00 395.00 0.00 395.00 395.00 0.00 395.00 395.00 0.00 395.00 395.00 190825 SAM'S CLUB 12/17/2021 Regular 0.00 453.61 149784 Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0012735 Invoice 12/08/2021 DECEMBER 2021 STATEMENT 0.00 453.61 010-40.4200.461700 WINTER FEST DECEMBER 20215TATEMENT 453.61 Bank Code AP Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 5 2 0.00 2,033.61 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 0 0 0.00 0.00 5 2 0.00 2,033.61 12/29/2021 10:38:14 AM Page 1 of 2 Check Report Date Range: 12/15/2021 - 12/20/2021 Fund 999 All Bank Codes Check Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 5 2 0.00 2,033.61 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 0 0 0.00 0.00 5 2 0.00 2,033.61 Fund Summary Name Period Amount POOLED CASH 12/2021 2,033.61 2,033.61 12/29/2021 10:38:14 AM Page 2 of 2 �J City of Waukee, IA Waukee Check Report By Check Number Date Range: 12/22/2021 - 12/29/2021 12/29/2021 10:39:52 AM Page 1 of 2 Check Report Date Range: 12/22/2021 - 12/29/2021 12/29/2021 10:39:52 AM Page 2 of 2 Council Payroll Reimbursements City Of Waukee, IA By Check Number Date Range: 12/16/2021 - 12/29/2021 Waukee 12/29/2021 10:53:47 AM Page 1 of 7 L Council Payroll Reimbursements Date Range: 22/16/2021 - 12/29/2021 Vendor Number Vendor Name Payment Date Payment Type Discount Amount Payment Amount Number Bank Code: AP-WAUKEE STATE 034875 CITY OF WAUKEE 12/21/2021 Regular 0.00 26,956.10 149790 Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0012746 Invoice 12/23/2021 CELL PHONE REIMBURSEMENT 0.00 162.50 010-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 107.50 060-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 9.35 510-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 13.19 520-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 13.15 540-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 16.81 750-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 2.50 INV0012752 Invoice 12/23/2021 LIFE INSURANCE PREMIUM 0.00 754.99 010-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 623.76 060-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 20.28 510-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 8.84 520-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 8.86 540-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 39.52 560-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 32.68 570-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 21.05 INVO012753 Invoice 12/23/2021 STD INSURANCE PREMIUM 0.00 965.06 010-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 791.50 060-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 52.75 510-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 51.08 520-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 24.15 540-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 22.43 560-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 23.15 INV0012754 Invoice 12/23/2021 LT DISABILITY INSUR PREMIUM 0.00 4,854.58 010-2030000 PAYROLL PAYABLES LT DISABILITY INSUR PREMIUM 4,194.28 060-2030000 PAYROLL PAYABLES LT DISABILITY INSUR PREMIUM 112.62 510-2030000 PAYROLL PAYABLES LT DISABILITY INSUR PREMIUM 131.70 540-2030000 PAYROLL PAYABLES LT DISABILITY INSUR PREMIUM 279.84 560-2030000 PAYROLL PAYABLES LT DISABILITY INSUR PREMIUM 136.14 INV0012755 Invoice 12/23/2021 GIFT CARD TAXABILITY ANNUAL DEDUCTI 0.00 8,800.00 010-2030000 PAYROLL PAYABLES GIFT CARD TAXABILITY ANNUAL 7,304.47 060-2030000 PAYROLL PAYABLES GIFT CARD TAXABILITY ANNUAL 275.63 510-2030000 PAYROLL PAYABLES GIFT CARD TAXABILITY ANNUAL 303.73 520-2030000 PAYROLL PAYABLES GIFT CARD TAXABILITY ANNUAL 247.33 540-2030000 PAYROLL PAYABLES GIFT CARD TAXABILITY ANNUAL 348.88 560-2030000 PAYROLL PAYABLES GIFT CARD TAXABILITY ANNUAL 124.43 570-2030000 PAYROLL PAYABLES GIFT CARD TAXABILITY ANNUAL 150.00 750-2030000 PAYROLL PAYABLES GIFT CARD TAXABILITY ANNUAL 45.53 INV0012759 Invoice 12/23/2021 HEALTH INSURANCE DEDUCTION 0.00 7,083.54 010-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 5,602.81 060-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 421.71 510-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 182.66 520-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 177.29 540-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 539.00 560-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 120.06 750-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 40.01 INV0012760 Invoice 12/23/2021 HEALTH INSURANCE DEDUCTION 0.00 1,615.95 010-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 1,292.76 510-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 94.77 520-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 90.96 540-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 22.57 560-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 68.72 570-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 46.17 INV0012761 Invoice 12/23/2021 HEALTH INSURANCE DEDUCTION 0.00 1,945.98 010-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 1,513.54 12/29/2021 10:53:47 AM Page 2 of 7 Council Payroll Reimbursements Date Range: 12/16/2021- 12/29/2021 Vendor Number Vendor Name Payment Date Payment Type Discount Amount Payment Amount Number 510-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 216.22 520-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 108.11 570-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 108.11 INV0012762 Invoice 12/23/2021 HEALTH INSURANCE DEDUCTION 0.00 773.50 010-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 663.00 060-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 110.50 036350 IOWA DEPT OF HUMAN SERVICES 12/21/2021 Regular 0.00 392.31 149791 Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INVO012739 Invoice 12/23/2021 CHILD SUPPORT 0.00 392.31 010-2011300 CHILD SUPPORT PAYABLE CHILD SUPPORT 392.31 091000 ICMA RETIREMENT TRUST 457 12/21/2021 Regular 0.00 9,973.78 149792 Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0012740 Invoice 12/23/2021 ICMA 457 ROTH CONTRIBUTION 0.00 522.00 010-2011200 IPERS WITHHOLDING PAY ICMA 457 ROTH CONTRIBUTION 522.00 INV0012741 Invoice 12/23/2021 ICMA401A 0.00 2,324.66 010-2011200 IPERS WITHHOLDING PAY ICMA 401A 2,324.66 INV0012742 Invoice 12/23/2021 ICMA ROTH CONTRIBUTION 0.00 1,153.92 010-2011200 IPERS WITHHOLDING PAY ICMA ROTH CONTRIBUTION 1,053.92 060-2011200 IPERS WITHHOLDING PAY ICMA ROTH CONTRIBUTION 50.00 540-2011200 IPERS WITHHOLDING PAY ICMA ROTH CONTRIBUTION 50.00 INV0012743 Invoice 12/23/2021 ICMA RETIREMENT 0.00 4,432.28 010-2011200 IPERS WITHHOLDING PAY ICMA RETIREMENT 4,257.28 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 I N V0012744 Invoice 12/23/2021 ICMA 0.00 1,540.92 010-2011200 IPERS WITHHOLDING PAY ICMA 1,469.59 510-2011200 IPERS WITHHOLDING PAY ICMA 35.38 52,0-2011200 IPERS WITHHOLDING PAY ICMA 35.95 099999 EFTPS 12/21/2021 Regular 0.00 111,165.89 149793 Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0012767 Invoice 12/23/2021 FICA TAX WITHHOLDING 0.00 52,095.20 010-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 42,749.72 060-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 1,608.24 510-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 1,994.22 520-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 1,536.38 540-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 2,359.56 560-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 759.88 570-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 890.98 750-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 196.22 INV0012768 Invoice 12/23/2021 FEDERAL WITHHOLDING TAXES 0.00 46,357.69 010-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 38,520.90 060-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 1,194.99 510-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 1,701.57 520-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 1,361.57 540-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 1,941.96 560-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 594.37 570-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 846.78 750-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 195.55 INV0012769 Invoice 12/23/2021 MEDICARE TAX WITHHOLDING 0.00 12,713.00 010-2010400 MEDICARE TAX WITH HOL MEDICARE TAX WITHHOLDING 10,527.36 060-2010400 MEDICARE TAX WITH HOL MEDICARE TAX WITHHOLDING 376.12 12/29/2021 10:53:47 AM Page 3 of 7 r'J Council Payroll Reimbursements Date Range: 12/16/2021- 12/29/2021 Vendor Number Vendor Name Payment Date Payment Type Discount Amount Payment Amount Number 510-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 466.58 520-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 359.20 540-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 551.84 560-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 177.66 570-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 208.36 750-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 45.88 133560 MEALS FROM THE HEARTLAND 12/21/2021 Regular 0.00 46.00 149794 Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INVO012749 Invoice 12/23/2021 MEALS FROM HEARTLAND DEDUCTION 0.00 46.00 010-2030000 PAYROLL PAYABLES MEALS FROM HEARTLAND DED 46.00 213250 UNITED WAY CENTRAL IOWA 12/21/2021 Regular 0.00 41.67 149795 Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INVO012745 Invoice 12/23/2021 UNITED WAY DEDUCTION 0.00 41.67 010-2030000 PAYROLL PAYABLES UNITED WAY DEDUCTION 41.67 232611 WAUKEE AREA CHRISTIAN SERVICES 12/21/2021 Regular 0.00 62.24 149796 Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INVO012747 Invoice 12/23/2021 WAUKEE AREA CHRISTIAN SERVICES DED 0.00 62.24 010-2030000 PAYROLL PAYABLES WAUKEE AREA CHRISTIAN SERVI 62.24 232624 WAUKEE BETTERMENT FOUNDATION 12/21/2021 Regular 0.00 80.00 149797 Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount NV0012748 Invoice 12/23/2021 WAUKEE BETTERMENT FOUNDATION DED 0.00 80.00 010-2030000 PAYROLL PAYABLES WAUKEE BETTERMENT FOUNDA 80.00 233050 WAUKEE PUBLIC LIBRARY FRIENDS FOUNDATIC 12/21/2021 Regular 0.00 7.91 149798 Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV_00.1.2.7.5.0_ Invoice 12/23/2021 LIBRARY FRIENDS FOUNDATION PAYROLL 0.00 7.91 010-2030000 PAYROLL PAYABLES LIBRARY FRIENDS FOUNDATION 7.91 232780 WAUKEE FIREFIGHTER'S ASSOCIATION 12/29/2021 Regular 0.00 17.46 149935 Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INVO012270 Invoice 10/01/2021 FIREFIGHTER'S ASSOCIATION PAYROLL CO 0.00 2.91 010-2030000 PAYROLL PAYABLES FIREFIGHTER'S ASSOCIATION PA 2.91 INVO012333 Invoice 10/15/2021 FIREFIGHTER'S ASSOCIATION PAYROLL CO 0.00 2.91 010-2030000 PAYROLL PAYABLES FIREFIGHTER'S ASSOCIATION PA 2.91 INVO012505 Invoice 11/12/2021 FIREFIGHTER'S ASSOCIATION PAYROLL CO 0.00 2.91 010-2030000 PAYROLL PAYABLES FIREFIGHTER'S ASSOCIATION PA 2.91 INVO012588 Invoice 11/26/2021 FIREFIGHTER'S ASSOCIATION PAYROLL CO 0.00 2.91 010-2030000 PAYROLL PAYABLES FIREFIGHTER'S ASSOCIATION PA 2.91 INVO012668 Invoice 12/10/2021 FIREFIGHTER'S ASSOCIATION PAYROLL CO 0.00 2.91 010-2030000 PAYROLL PAYABLES FIREFIGHTER'S ASSOCIATION PA 2.91 INVO012751 Invoice 12/23/2021 FIREFIGHTER'S ASSOCIATION PAYROLL CO 0.00 2.91 010-2030000 PAYROLL PAYABLES FIREFIGHTER'S ASSOCIATION PA 2.91 12/29/2021 10:53:47 AM Page 4 of 7 C Council Payroll Reimbursements Date Range: 12/16/2021- 12/29/2021 Vendor Number Vendor Name Payment Date Payment Type Discount Amount Payment Amount Number 099300 ISOLVED BENEFIT SERVICES, INC 12/21/2021 EFT 0.00 8,479.65 254169 Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INVO012756 Invoice 12/23/2021 LIMITED PURPOSE FLEX MEDICAL DEDUC 0.00 22.70 010-2030000 PAYROLL PAYABLES LIMITED PURPOSE FLEX MEDICA 22.70 INVO012757 Invoice 12/23/2021 SECTION 125 MEDICAL DEDUCTIONS 0.00 5,155.35 010-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 3,786.81 060-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 250.33 510-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 232.08 520-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 131.47 540-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 369.90 560-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCT[ 158.81 570-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 188.10 750-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCT] 37.85 INVO012758 Invoice 12/23/2021 SECTION 125 DAYCARE DEDUCTIONS 0.00 3,301.60 010-2030000 PAYROLL PAYABLES SECTION 125 DAYCARE DEDUCTI 2,920.92 060-2030000 PAYROLL PAYABLES SECTION 125 DAYCARE DEDUCT] 172.70 560-2030000 PAYROLL PAYABLES SECTION 125 DAYCARE DEDUCT] 207.98 099300 ISOLVED BENEFIT SERVICES, INC 12/21/2021 EFT 0.00 505.60 254189 Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount W16430 Invoice 11/30/2021 NOV'21 PEPM MEDICAL & DEPENDENT C 0.00 505.60 Q10 60_8350.230000 CONSULTANT & PROFES51 NOV'21 PEPM MEDICAL & DEP 505.60 098900 Payable # INVO012647 INVO012679 INVO012680 INVO012763 IPERS Payable Type Account Number Credit Memo 010-60.8400.080000 Invoice 010-2011200 060-2011200 510-201120Q 520-2011200 540-2011200 560-2011200 570-2011200 750-2011200 Invoice 010-2011200 Invoice 010-2011200 060-2011200 510-2011200 520-2011200 540-2011200 560-2011200 570-2011200 750-2011200 Invoice 010-2011200 Invoice 010-2011200 060-2011200 510-2011200 520-2011200 540-2011200 12/29/2021 EFT 0.00 146,481.40 254211 Post Date Payable Description Discount Amount Payable Amount Account Name Item Description Distribution Amount 12/29/2021 DEC'21 ROUNDING ADJUSTMENT 0.00 -0.32 IPERS CONTRIBUTION DEC'21 ROUNDING ADJUSTME 12/10/2021 IPERS DEDUCTIONS IPERS WITHHOLDING PAY IPERS DEDUCTIONS IPERS WITHHOLDING PAY IPERS DEDUCTIONS IPERS WITHHOLDING PAY IPERS DEDUCTIONS IPERS WITHHOLDING PAY IPERS DEDUCTIONS IPERS WITHHOLDING PAY IPERS DEDUCTIONS IPERS WITHHOLDING PAY IPERS DEDUCTIONS IPERS WITHHOLDING PAY IPERS DEDUCTIONS IPERS WITHHOLDING PAY IPERS DEDUCTIONS 12/10/2021 IPERS DEDUCTIONS IPERS WITHHOLDING PAY IPERS DEDUCTIONS 12/10/2021 IPERS DEDUCTIONS IPERS WITHHOLDING PAY IPERS DEDUCTIONS IPERS WITHHOLDING PAY IPERS DEDUCTIONS IPERS WITHHOLDING PAY IPERS DEDUCTIONS IPERS WITHHOLDING PAY IPERS DEDUCTIONS IPERS WITHHOLDING PAY IPERS DEDUCTIONS IPERS WITHHOLDING PAY IPERS DEDUCTIONS IPERS WITHHOLDING PAY IPERS DEDUCTIONS IPERS WITHHOLDING PAY IPERS DEDUCTIONS 12/10/2021 IPERS DEDUCTIONS IPERS WITHHOLDING PAY IPERS DEDUCTIONS 12/23/2021 IPERS DEDUCTIONS IPERS WITHHOLDING PAY IPERS DEDUCTIONS IPERS WITHHOLDING PAY IPERS DEDUCTIONS IPERS WITHHOLDING PAY IPERS DEDUCTIONS IPERS WITHHOLDING PAY IPERS DEDUCTIONS IPERS WITHHOLDING PAY IPERS DEDUCTIONS 0.00 0.00 0.00 0.00 0.00 -0.32 7,680.27 4,255.03 430.62 769.81 498.44 1,064.73 209.40 436.51 15.73 2,945.02 2,945.02 40,412.37 29,244.09 2,033.67 2,179.83 1,715.89 2,783.76 1,010.68 1,158.76 285.69 27,267.94 27,267.94 41,253.11 29,347.66 2,109.65 2,476.57 1,895.72 3,019.46 12/29/2021 10:53:47 AM Page 5 of 7 Council Payroll Reimbursements Date Range: 12/16/2021 - 12/29/2021 Vendor Number Vendor Name 560-2011200 570-2011200 750-2011200 INVO012764 Invoice 010-2011200 INVO012765 Invoice 010-2011200 Payment Date Payment Type Discount Amount Payment Amount Number IPERS WITHHOLDING PAY IPERS DEDUCTIONS 1,001.47 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 1,149.80 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 252.78 12/23/2021 IPERS DEDUCTIONS 0.00 26,419.49 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 26,419.49 12/23/2021 IPERS ELECTED OFFICIAL DEDUCT 0.00 503.52 IPERS WITHHOLDING PAY IPERS ELECTED OFFICIAL DEDUC 503.52 208650 TREASURER STATE OF IOWA 12/29/2021 EFT 0.00 39,110.85 254212 Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INVO012648 Invoice 12/10/2021 STATE WITHHOLDING TAXES 0.00 1,810.65 010-2011100 STATE TAX WITHHOLDING STATE WITHHOLDING TAXES 1,081.70 060-2011100 STATE TAX WITHHOLDING STATE WITHHOLDING TAXES 60.71 510-2011100 STATE TAX WITHHOLDING STATE WITHHOLDING TAXES 170.47 520-2011100 STATE TAX WITHHOLDING STATE WITHHOLDING TAXES 104.90 540-2011100 STATE TAX WITHHOLDING STATE WITHHOLDING TAXES 240.17 560-2011100 STATE TAX WITHHOLDING STATE WITHHOLDING TAXES 40.52 570-2011100 STATE TAX WITHHOLDING STATE WITHHOLDING TAXES 112.18 INVO012681 Invoice 12/10/2021 STATE WITHHOLDING TAXES 0.00 18,275.96 010-2011100 STATE TAX WITHHOLDING STATE WITHHOLDING TAXES 15,426.15 060-2011100 STATE TAX WITHHOLDING STATE WITHHOLDING TAXES 485.01 510-2011100 STATE TAX WITHHOLDING STATE WITHHOLDING TAXES 558.10 520-2011100 STATE TAX WITHHOLDING STATE WITHHOLDING TAXES 436.91 540-2011100 STATE TAX WITHHOLDING STATE WITHHOLDING TAXES 703.22 560-2011100 STATE TAX WITHHOLDING STATE WITHHOLDING TAXES 241.48 570-2011100 STATE TAX WITHHOLDING STATE WITHHOLDING TAXES 368.76 750-2011100 STATE TAX WITHHOLDING STATE WITHHOLDING TAXES 56.33 INV00127U Invoice 12/23/2021 STATE WITHHOLDING TAXES 0.00 19,024.24 010-2011100 STATE TAX WITHHOLDING STATE WITHHOLDING TAXES 15,799.00 060-2011100 STATE TAX WITHHOLDING STATE WITHHOLDING TAXES 534.97 510-2011100 STATE TAX WITHHOLDING STATE WITHHOLDING TAXES 703.44 520-2011100 STATE TAX WITHHOLDING STATE WITHHOLDING TAXES 528.50 540-2011100 STATE TAX WITHHOLDING STATE WITHHOLDING TAXES 839.20 560-2011100 STATE TAX WITHHOLDING STATE WITHHOLDING TAXES 254.05 570-2011100 STATE TAX WITHHOLDING STATE WITHHOLDING TAXES 315.37 750-2011100 STATE TAX WITHHOLDING STATE WITHHOLDING TAXES 49.71 Bank Code AP Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 29 10 0.00 148,743.36 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 15 4 0.00 194,577.50 44 14 0.00 343,320.86 12/29/2021 10:53:47 AM Page 6 of 7 Council Payroll Reimbursements Date Range: 12/16/2021 - 12/29/2021 Fund 999 All Bank Codes Check Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 29 10 0.00 148,743.36 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 15 4 0.00 194,577.50 44 14 0.00 343,320.86 Fund Summary Name Period Amount POOLED CASH 12/2021 343,320.86 343,320.86 12/29/2021 10:53:47 AM Page 7 of 7 Utility Refund Check Report 'AAUP V/av cee City of Waukee, IA Account Number Name 19-00519-01 Benjamin, Kendall T 19-00394-02 Burns, Joel A 19-00504-01 Crawley, Antoinette N 85-00186-07 Doscher, Mary M 21-00208-00 Genesis Homes 83-00416-11 Gines, Tiara N 84-03086-02 Higgins, Chris D Date Type 12/21/2021 Refund 12/21/2021 Refund 12/21/2021 Refund 12/21/2021 Refund 12/21/2021 Refund 12/21/2021 Refund 12/21/2021 Refund 12-04000-04 Landmark Construction Services- d... 12/21/2021 Refund Amount Reference 59.12 Check #:149925 Revenue Code Current 996 59.12 Aging Total: 59.12 48.37 Check M 149923 Revenue Code Current 996 48.37 Aging Total: 48.37 4.07 Check M 149924 Revenue Code Current 996 4.07 Aging Total: 4.07 68.12 Check M 149931 Revenue Code Current 996 68.12 Aging Total: 68.12 256.24 Check #: 149928 Revenue Code Current 996 256.24 996 127.16 996 305.24 Aging Total: 688.64 250.26 Check M 149929 Revenue Code Current 996 250.26 Aging Total: 250.26 178.60 Check #:149930 Revenue Code Current 996 178.60 Aging Total: 178.60 509.00 Check M 149920 Revenue Code Current 996 509.00 996 3,713.52 Aging Total: 4,222.52 Date Range: 12/16/2021 - 12/29/2021 Adj Packet Receipt Type UBPKTO8653 Plus 1 Plus 2 Plus 3 Plus 4 Balance 0.00 0.00 0.00 0.00 59.12 0.00 0.00 0.00 0.00 59.12 UBPKTO8653 Plus 1 Plus 2 Plus 3 Plus 4 Balance 0.00 0.00 0.00 0.00 48.37 0.00 0.00 0.00 0.00 48.37 UBPKTO8653 Plus 1 Plus 2 Plus 3 Plus 4 Balance 0.00 0.00 0.00 0.00 4.07 0.00 0.00 0.00 0.00 4.07 UBPKTO8653 Plus 1 Plus 2 Plus 3 Plus 4 Balance 0.00 0.00 0.00 0.00 68.12 0.00 0.00 0.00 0.00 68.12 UBPKTO8653 Plus 1 Plus 2 Plus 3 Plus 4 Balance 0.00 0.00 0.00 0.00 256.24 0.00 0.00 0.00 0.00 127.16 0.00 0.00 0.00 0.00 305.24 0.00 0.00 0.00 0.00 688.64 UBPKTO8653 Plus 1 Plus 2 Plus 3 Plus 4 Balance 0.00 0.00 0.00 0.00 250.26 0.00 0.00 0.00 0.00 250.26 UBPKTO8653 Plus 1 Plus 2 Plus 3 Plus 4 Balance 0.00 0.00 0.00 0.00 178.60 0.00 0.00 0.00 0.00 178.60 UBPKTO8653 Plus 1 Plus 2 Plus 3 Plus 4 Balance 0.00 0.00 0.00 0.00 509.00 0.00 0.00 0.00 0.00 3,713.52 0.00 0.00 0.00 0.00 4,222.52 12/29/2021 10:54:35 AM Utility Refund Check Report Page 1 of 2 16 Adi Account Number Name Date Type Amount Reference Packet Receipt Type 12-04000-05 Landmark Development services, Inc 12/27/2021 Refund 509.00 Check #:149933 UBPKTO8689 Revenue Code Current Plus 1 Plus 2 Plus 3 Plus 4 Balance 996 509.00 0.00 0.00 0.00 0.00 509.00 996 3,713.52 0.00 0.00 0.00 0.00 3,713.52 Aging Total: 4,222.52 0.00 0.00 0.00 0.00 4,222.52 01-48003-04 Rinehart, John 12/27/2021 Refund 222.19 Check #:149932 UBPKTO8689 Revenue Code Current Plus 1 Plus 2 Plus 3 Plus 4 Balance 996 222.19 0.00 0.00 0.00 0.00 222.19 Aging Total: 222.19 0.00 0.00 0.00 0.00 222.19 18-00161-04 Telbiz, Maida 12/21/2021 Refund 18.16 Check #: 149922 UBPKTO8653 Revenue Code Current Plus 1 Plus 2 Plus 3 Plus 4 Balance 996 18.16 0.00 0.00 0.00 0.00 18.16 Aging Total: 18.16 0.00 0.00 0.00 0.00 18.16 Transaction Grand Total for Period: 9,982.57 Totals by Transaction Type Transaction Type Count Amount Refund 15 9,982.57 Total for Period: 15 9,982.57 Totals by Transaction Type and Revenue Code Transaction Type Revenue Code Count Amount Refund 996 - Unapplied Credits 15 9,982.57 Refund Total: 9,982.57 Total for Period: 15 9,982.57 Totals by Revenue Code Revenue Code Count Amount 996 - Unapplied Credits 15 9,982.57 Total for Period: 15 9,982.57 12/29/2021 10:54:35 AM Utility Refund Check Report Page 2 of 2 City of Waukee, IA Woukee Check Report By Check Number Date Range: 11/01/2021 - 12/31/2021 12/29/2021 1:49:13 PM Page 1 of 10 -r I. - Check Report Date Range: 11/01/2021- 12/31/2021 Vendor Number Vendor Name Payment Date Payment Type Discount Amount Payment Amount Number Bank Code: AP-WAUKEE STATE 235285 WELLS FARGO COMMERCIAL CARD 12/21/2021 EFT 0.00 11,373.11 254213 Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount 1221 21 Invoice 12/21/2021 WELLS FARGO CREDIT CARD STATEMENT 0.00 11,373.11 010-10.1100.470000 TRAINING/TRAVEL EXPEN JM0942-CALEA CONFERENCE F 1,500.00 010-10.1100.470000 TRAINING/TRAVEL EXPEN KC0892-CENTRAL SQUARE CON 1,498.00 010-10.1100.470000 TRAINING/TRAVEL EXPEN KC0892-TRAVEL TO CHICAGO FO 18.60 010-10.1100.540000 MINOR EQUIPMENT JL0934-SURVEILLANCE EQUIPM 499.98 010-10.1100.590000 OPERATING SUPPLIES & AM0959-ILEA GRADUATION 10.43 010-10.1400.470000 TRAINING/TRAVEL EXPEN CR1197-COLE KLEINWOLTERINK 1,297.00 010-10.1400.470000 TRAINING/TRAVEL EXPEN CR1197-12/6/21 MEAL DURING 20.11 010-10.1400.470000 TRAINING/TRAVEL EXPEN TT1205-BOOK FOR ICS TRAININ 6.63 010-10.1400.470000 TRAINING/TRAVEL EXPEN HG1189-RPG BOOK - PER TOM 6.98 010-10.1400.470000 TRAINING/TRAVEL EXPEN TT1205-AHIMT - PLANNING SEC 139.25 010-10.1400.470000 TRAINING/TRAVEL EXPEN CR1197-IEMSATRANING 250.00 010-10.1400.470000 TRAINING/TRAVEL EXPEN TT1205-AHIMT- PLANNING SEC 3.42 010-10.1400.470000 TRAINING/TRAVEL EXPEN TT1205-AHIMT- PLANNING SEC 2.37 010-10.1400.470000 TRAINING/TRAVEL EXPEN TT1205-AHIMT- PLANNING SEC 3.31 010-10.1400.470000 TRAINING/TRAVEL EXPEN TT1205-AHIMT- PLANNING SEC 4.82 010-10.1400.470000 TRAINING/TRAVEL EXPEN TT1205-AHIMT- PLANNING SEC 2.11 010-10.1400.540000 MINOR EQUIPMENT TT1205-MICLOOPS FOR GEAR 58.40 010-10.1400.580000 OFFICE SUPPLIES TT1205-OFFICE SUPPLIES FOR IC 30.35 010-10.1400.590000 OPERATING SUPPLIES & HG1189-KITCHEN SUPPLIES 21.61 010-10.1400.590000 OPERATING SUPPLIES & HG1189-KITCHEN SUPPLIES 37.76 010-10.1500.470000 TRAINING/TRAVEL EXPEN TT1205-AHIMT- PLANNING SEC 12.10 010-10.1500.470000 TRAINING/TRAVEL EXPEN HG1189-RPG BOOK - PER TOM 24.78 010-10.1500.470000 TRAINING/TRAVEL EXPEN TT1205-AHIMT- PLANNING SEC 11.72 010-10.1500.470000 TRAINING/TRAVEL EXPEN TT1205-BOOK FOR ICS TRAININ 23.53 010-10.1500.470000 TRAINING/TRAVEL EXPEN TT1205-AHIMT- PLANNING SEC 17.08 010-10.1500.470000 TRAINING/TRAVEL EXPEN TT1205-AHIMT- PLANNING SEC 493.67 010-10.1500.470000 TRAINING/TRAVEL EXPEN TT1205-AHIMT- PLANNING SEC 8.37 010-10.1500.470000 TRAINING/TRAVEL EXPEN TT1205-AHIMT - PLANNING SEC 7.46 010-10.1500.580000 OFFICE SUPPLIES TT1205-OFFICE SUPPLIES FOR IC 30.35 010-10.1500.590000 OPERATING SUPPLIES & HG1189-KITCHEN SUPPLIES 21.61 010-10.1500.590000 OPERATING SUPPLIES & HG1189-KITCHEN SUPPLIES 37.76 010-10.1900.590000 OPERATING SUPPLIES & BD1403-CODE BOOKS 1,230.27 010-10.1900.740000 OFFICE EQUIPMENT SL1239-MONITOR ARMS HARD 349.21 010-40.3100.270000 DATA PROCESSING KL1015-SCH E DU LING SOFTWAR 865.25 010-40.3100.280000 DUES, MEMBERSHIPS & S KW1023-MEMBERSHIP KERI FO 135.00 010-40.3100.460300 PROGRAMS KW1023-KIDS PROGRAMS 35.00 010-40.3100.460300 PROGRAMS KW1023-KIDS PROGRAM SUPPL 38.30 010-40.3100.460300 PROGRAMS KL1015-WINTER PROGRAM PRIZ 50.00 010-40.3100.590000 OPERATING SUPPLIES & KL1015-PRINTING 98.59 010-40.3100.590000 OPERATING SUPPLIES & KL1015-ART GALLERY SUPPLIES 109.25 010-40.4200.461700 WINTER FEST DE1056-COSTUME RENTAL DEP -95.00 010-50.8500,470000 TRAINING/TRAVEL EXPEN JB5414-TAXI TO LAS VEGAS AIRP 32.51 010-50.8500.470000 TRAINING/TRAVEL EXPEN JB5414-WEDNESDAY BREAKFAS 11.37 010-50.8500.470000 TRAINING/TRAVEL EXPEN JB5414-ICSC LODGING - DECEM 565.76 010-50.8500.470000 TRAINING/TRAVEL EXPEN JB5414-TUESDAY BREAKFAST - 1 13.57 010-50.8500.470000 TRAINING/TRAVEL EXPEN JB5414-TUESDAY LUNCH - ICSC 32.26 010-50.8500.470000 TRAINING/TRAVEL EXPEN JB5414-TUESDAY DINNER - ICSC 19.74 010-50,8500.470000 TRAINING/TRAVEL EXPEN JB5414-MONDAY LUNCH- ICSC C 19.24 010-50.8500.470000 TRAINING/TRAVEL EXPEN JB5414-MONDAY DINNER - ICSC 38.36 010-50.8500.470000 TRAINING/TRAVEL EXPEN JB5414-MONDAY BREAKFAST - 1 24.68 010-50.8500.470000 TRAINING/TRAVEL EXPEN JB5414- BREAKFAST -TRAVEL TO 18.89 010-50.8500.470000 TRAINING/TRAVEL EXPEN JB5414-SUNDAY DINNER - ICSC 49.92 010-50.8700.470000 TRAINING/TRAVEL EXPEN BD1403-MEETING 12/9/21 13.65 010-60.8200.270000 DATA PROCESSING SE1502-3RD PARTY SOCIAL MED 99.00 010-60.8200.270000 DATA PROCESSING SE1502-MONTHLY ADOBE SOFT 52.99 010-60,8200.540000 MINOR EQUIPMENT SE1502-SHOTGUN MIC FOR VID 42.75 12/29/2021 1:49:13 PM Page 2 of 10 Check Report �j. Date Range: 11/01/2021 - 12/31/2021 Vendor Number Vendor Name Payment Date 010-60.8300:390400 NORTHVIEW RENTAL PRO 010-60.8300.470000 TRAINING/TRAVEL EXPEN 010-60.8300,470000 TRAINING/TRAVEL EXPEN 010-60.8400.470000 TRAINING/TRAVEL EXPEN 060-30.7100.590000 OPERATING SUPPLIES & 510-30.6510.590000 OPERATING SUPPLIES & 510-30.6510.590000 OPERATING SUPPLIES & 520-30.6520.590000 OPERATING SUPPLIES & 520-30.6520.590000 OPERATING SUPPLIES & 540-30.6540.590000 OPERATING SUPPLIES & Payment Type Discount Amount Payment Amount Number BD1403-DRYER REPLACEMENT F 865.00 RS1528-12-13-2021 COUNCIL W 248.65 RS1528-12-14-2021 LUNCH MT 84.13 LB1460-METRO FINANCE LUNC 16.41 ER1569-POST WIND STORM CLE 48.45 ER1569-POST WINDSTORM CLE 48.45 ER1569-CHARLES WASKE RETIR 7.50 ER1569-POST WINDSTORM CLE 48.45 ER1569-CHARLES WASKE RETIR 7.50 ER1569-POST WIND STORM CLE 48.45 235285 WELLS FARGO COMMERCIAL CARD 11/09/2021 EFT 0.00 9,330.64 254214 12/29/2021 1:49:13 PM Page 3 of 10 Check Report Date Range: 12/01/2021-12/31/2021 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 WF11092021 Invoice 11/09/2021 WELLS FARGO CREDIT CARD STATEMENT 0.00 9,330.64 010-10.1100.360000 POSTAGE & SHIPPING AB0991- SHIPPING FOR BWC 21.38 010-10.1100.390000 RENTAL/LEASE OF EQUIP JM0942 - STORAGE UNIT MONT 211.50 010-10.1100.410100 REPAIR/MAINTENANCE 0 NL0926 - HOLSTER EQUIPMENT 93.98 010-10.1100.460200 PD COMMUNITY POLICIN AM0959 - HALLOWEEN TRUNK 49.81 010-10.1100.460200 PD COMMUNITY POLICIN AC0884 - CANDY FOR THE PUBLI 460.77 010-10.1100.460200 PD COMMUNITY POLICIN AC0884 - CAKES, JUICE AND WA 32.58 010-10.1100.460200 PD COMMUNITY POLICIN AM0959 - HALLOWEEN TRUNK 60.90 010-10.1100.460200 PD COMMUNITY POLICIN MS1007 - DECORATIONS FOR H 22.47 010-10.1100.470000 TRAINING/TRAVEL EXPEN JM0942 - LUNCH AFTER TOUR 0 38.99 010-10.1100.470000 TRAINING/TRAVEL EXPEN AC0884 - DONUTS AND COFFEE 18.80 010-10,1100.470000 TRAINING/TRAVEL EXPEN AC0884 - LUNCHES FOR THE CHI 82.25 010-10.1100.470000 TRAINING/TRAVEL EXPEN AC0884 -COOKIES WATER FOR 16.48 010-10.1100.470000 TRAINING/TRAVEL EXPEN MS1007 -SUPPLIES FOR APART 4.49 010-10.1100.470000 TRAINING/TRAVEL EXPEN BL4763 - TRAINING COURSE 199.00 010-10.1100.470000 TRAINING/TRAVEL EXPEN SC0900 - FEMALE ARREST AND 418.95 010-10.1100.470000 TRAINING/TRAVEL EXPEN MS1007 - MEETING SUPPLIES 143.14 010-10.1100.570000 FUEL JM0942 - FUEL AFTER TOUR OF 32.41 010-10.1100.590000 OPERATING SUPPLIES & AH0876 - COMMUNITY OUTREA 367.82 010-10.1100.590000 OPERATING SUPPLIES & JM0942 - WATER FOR WESTCO 10.00 010-10.1100.590000 OPERATING SUPPLIES & AC0884 - CASCADE DISHWASHE 13.32 010-10.1400.140000 UNEMPLOYMENT TAXES CR1197 - FIRE SPLIT 4.70 010-10.1400.150000 EMPLOYEE ASSISTANCE P CR1197 - EMS SPLIT 16.70 010-10.1400.280000 DUES, MEMBERSHIPS & S HG1189 - SUBSCRIPTION FOR A 22.47 010-10.1400.400000 REPAIR/MAINTENANCE 0 AH1171- BRASSO FOR POLE 3.09 010-10.1400.410100 REPAIR/MAINTENANCE O AH1171- TIC BATTERY REBUILD 113.18 010-10.1400.470000 TRAINING/TRAVEL EXPEN TT1205 - LODGING - IMT TRAINI 161.28 010-10.1400.470000 TRAINING/TRAVEL EXPEN TT1205 - MEAL- IMT TRAINING 3.67 010-10.1400.470000 TRAINING/TRAVEL EXPEN CR1197 - FIRE SPLIT 2.44 010-10.1400.470000 TRAINING/TRAVEL EXPEN TT1205 - MEAL- IMT TRAINING 5.65 010-10.1400.470000 TRAINING/TRAVEL EXPEN TT1205 - MEAL- IMT TRAINING 2.67 010-10.1400.470000 TRAINING/TRAVEL EXPEN TT1205 - MEAL- IMTTRAINING 6.42 010-10.1400.470000 TRAINING/TRAVEL EXPEN TT1205 - MEAL- IMTTRAINING 8.25 010-10.1400.470000 TRAINING/TRAVEL EXPEN TT1205 - MEAL- IMTTRAINING 14.76 010-10.1400.590000 OPERATING SUPPLIES & HG1189 - KITCHEN SUPPLIES FO 37.26 010-10.1400.590000 OPERATING SUPPLIES & HG1189 - KITCHEN SUPPLIES FO 37.26 010-10.1500.280000 DUES, MEMBERSHIPS & S HG1189 - SUBSCRIPTION FOR FI 22.48 010-10.1500.470000 TRAINING/TRAVEL EXPEN CR1197 - EMS SPLIT 8.64 010-10.1500.470000 TRAINING/TRAVEL EXPEN TT1205 - LODGING - IMTTRAINI 161.28 010-10.1500.470000 TRAINING/TRAVEL EXPEN TT1205 - MEAL- IMTTRAINING 2.68 010-10.1500.470000 TRAINING/TRAVEL EXPEN TT1205 - MEAL- IMTTRAINING 8.26 010-10.1500.470000 TRAINING/TRAVEL EXPEN TT1205 - MEAL- IMTTRAINING 6.42 010-10.1500.470000 TRAINING/TRAVEL EXPEN TT1205 - MEAL- IMT TRAINING 14.77 010-10.1500.470000 TRAINING/TRAVEL EXPEN TT1205 - MEAL- IMT TRAINING 5.66 010-10.1500.470000 TRAINING/TRAVEL EXPEN TT1205 - MEAL - IMT TRAINING 3.68 010-10.1900.280000 DUES, MEMBERSHIPS & S BD1403 - ONLINE SUBSCRIPTIO 201.80 010-40.3100.270000 DATA PROCESSING KL1015 - HOTSPOT ANNUAL SER 120.00 010-40.3100.270000 DATA PROCESSING KL1015 - SIGNATURE SOFTWARE 15.00 010-40.3100.270000 DATA PROCESSING KL1015 - HOTSPOT ANNUAL SER 120.00 010-40.3100.270000 DATA PROCESSING KL1015 - HOTSPOT ANNUAL SER 120.00 010-40.3100.270000 DATA PROCESSING KL1015 - HOTSPOT ANNUAL SER 120.00 010-40.3100.270000 DATA PROCESSING KL1015 - HOTSPOT ANNUAL SER 120.00 010-40.3100.270000 DATA PROCESSING KL1015 - SCHEDULING SOFTWA 68.00 010-40.3100.460300 PROGRAMS KW1023 - KIDS PROGRAM SUPP 83.91 010-40.3100.470000 TRAINING/TRAVEL EXPEN KW1023 - TRAINING 39.50 010-40.3100.640000 LIBRARY BOOKS/FILMS/R KL1015 - MAGAZINE FOR CHECK 16.05 010-40.3100.640000 LIBRARY BOOKS/FILMS/R KL1015 - REFUND FOR DES MO1 -16.15 010-40.4200.360000 POSTAGE & SHIPPING DE1056 - CARNIVAL CONTRACT 4.33 010-40.4200.460550 WINTER RECREATION PR DE1056 - OCT. BABYSITTER TRAI 120.00 12/29/2021 1:49:13 PM Page 4 of 10 Check Report Vendor Number 235285 Vendor Name Payment Date 010-40.4200.470000 TRAINING/TRAVEL EXPEN 010-50.8500.470000 TRAINING/TRAVEL EXPEN 010-60.8200.210000 PUBLIC NOTIFICATION/AD 010-60.8200.270100 COMPUTER SUPPORT 010-60.8200.360000 POSTAGE & SHIPPING 010-60.8200.540000 MINOR EQUIPMENT 010-60.8300.470000 TRAINING/TRAVEL EXPEN 010-60.8300.470000 TRAINING/TRAVEL EXPEN 010-60.8350.360000 POSTAGE & SHIPPING 010-60.8350.470000 TRAINING/TRAVEL EXPEN 010-60.8350.470000 TRAINING/TRAVEL EXPEN 010-60.8350.470000 TRAINING/TRAVEL EXPEN 010-60.8350.470000 TRAINING/TRAVEL EXPEN 010-60.8350.470000 TRAINING/TRAVEL EXPEN 010-60.8350.580000 OFFICE SUPPLIES 010-60.8400.470000 TRAINING/TRAVEL EXPEN 010-60.8800.270000 DATA PROCESSING 010-60.8800.270000 DATA PROCESSING 010-60.8800.270000 DATA PROCESSING 010-60.8800,270000 DATA PROCESSING 010-60.8800.270000 DATA PROCESSING 010-60.8800.470000 TRAINING/TRAVEL EXPEN 510-30.6510.470000 TRAINING/TRAVEL EXPEN 510-30.6510.470000 TRAINING/TRAVEL EXPEN F/ Date Range: 11/01/2021 - 12/32/2021 Payment Type Discount Amount Payment Amount Number DE1056 - WOMENS LEADERSHIP 10.00 JB5414 - ICSC CONFERENCE AIR 264.40 SE1502 - FACEBOOK ADVERTISI 20.00 SE1502 - MONTHLY ADOBE STO 29.99 SE1502 - SHIPPING CAMERA FO 13.25 SE1502 - CAMERA REPAIR 387.43 TM1510 - LUNCH WITH MAYOR 56.55 RS1528 - 12/8/21 LEGISLATIVE B 70.00 TC1486 - POSTAGE FOR COBRA 7.38 ML1494 - TRAVEL EXPENSES FO 5.13 ML1494 - TRAVEL EXPENSES FO 30.00 ML1494 - TRAVEL EXPENSES FO 48.36 ML1494 - TRAVEL EXPENSES FO 11.00 ML1494 - TRAVEL EXPENSES FO 14.87 TC1486 - EMPLOYEE HISTORY F 162.16 LB1460 - METRO FINANCE LUNC 18.40 SL1239 - SUBSCRIPTION SERVIC 2,550.00 SL1239 - SUBSCRIPTION FOR A 264.00 SL1239 - FOREIGN TRANSACTIO 25.50 SL1239 - SOFTWARE FOR IT AD 148.47 SL1239 - IT SOFTWARE 36.99 SL1239 - ANNUAL IT TRAINING 861.45 TR1557 - TRAVEL & TRANINNG 160.16 ER1569 - COLE DANIEL IOWA D 30.00 WELLS FARGO COMMERCIAL CARD 11/23/2021 EFT 0.00 12,926.85 254215 12/29/2021 1:49:13 PM Page 5 of 10 Check Report Date Range: 11/01/2021- 12/31/2021 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 WF11232021 Invoice 11/23/2021 WELLS FARGO CREDIT CARD STATEMENT 0.00 12,926.85 010-10.1100.410200 REPAIR/MAINTENANCE O BL4763 - DATA STORAGE PURCH 106.98 010-10.1100.460200 PD COMMUNITY POLICIN KC0892 - OPERATION WISH LIST 159.69 010-10.1100.460200 PD COMMUNITY POLICIN JM0942 -THANKSGIVING BASKE 1,085.40 010-10.1100.460200 PD COMMUNITY POLICIN JM0942 - OPERATION WISH LIST 1,171.09 010-10.1100.460200 PD COMMUNITY POLICIN KC0892 - OPERATION WISH LIST 30.01 010-10.1100.460200 PD COMMUNITY POLICIN KC0892 - OPERATION WISH LIST 66.40 010-10.1100.460200 PD COMMUNITY POLICIN JM0942 - OPERATION WISH LIST 531.13 010-10.1100.460200 PD COMMUNITY POLICIN KC0892 - OPERATION WISH LIST 36.46 010-10.1100.460200 PD COMMUNITY POLICIN KC0892 - OPERATION WISH LIST 182.26 010-10.1100.460200 PD COMMUNITY POLICIN KC0892 - OPERATION WISH LIST 138.00 010-10.1100.460200 PD COMMUNITY POLICIN JM0942 - OPERATION WISH LIST 390.81 010-10.1100.470000 TRAINING/TRAVEL EXPEN KC0892 - LUNCH @TRAINING LE 40.86 010-10.1100.470000 TRAINING/TRAVEL EXPEN MS1007 - COOKIES FOR TRAINI 16.47 010-10.1100.470000 TRAINING/TRAVEL EXPEN JM0942 - SPOSETO - WOMEN IN 795.00 010-10.1100.470000 TRAINING/TRAVEL EXPEN MS1007 - BREAKFAST FOR TRAI 14.96 010-10.1100.470000 TRAINING/TRAVEL EXPEN JL0934-TRAINING FOR EVIDEN 600.00 010-10.1100.470000 TRAINING/TRAVEL EXPEN BL4763 - MEAL WHILE AT TRAIN 36.68 010-10.1100.470000 TRAINING/TRAVEL EXPEN BL4763 - HOTEL FOR STAY WHIL 344.08 010-10.1100.470000 TRAINING/TRAVEL EXPEN KC0892 - LODGING WHILE AT TR 267.92 010-10.1100.470000 TRAINING/TRAVEL EXPEN MS1007 - FLIGHT FOR TRAINING 144.00 010-10.1100.470000 TRAINING/TRAVEL EXPEN BL4763 - MEAL WHILE ATTRAIN 57.90 010-10.1100.470000 TRAINING/TRAVEL EXPEN KC0892 - TRAINING DINNER LE 94.61 010-10.1100.470000 TRAINING/TRAVEL EXPEN KC0892- LUNCH WHILE ATTRAI 26.97 010-10.1100.470000 TRAINING/TRAVEL EXPEN KC0892 - DINNER @TRAINING L 55.62 010-10.1100.470000 TRAINING/TRAVEL EXPEN BL4763 - BREAKFAST PURCHASE 60.60 010-10.1100.540000 MINOR EQUIPMENT MS1007- DEPARTMENT AWARD 70.75 010-10.1100.540000 MINOR EQUIPMENT MS1007 - DEPARTMENT AWARD 115.47 010-10.1100.540000 MINOR EQUIPMENT MS1007 - DEPARTMENT AWARD 40.43 010-10.1100.540000 MINOR EQUIPMENT JM0942 - RETURN WEAPON CA 12.16 010-10.1100.570000 FUEL BL4763 - FUEL WHILE AT TRAINI 40.11 010-10.1100.580000 OFFICE SUPPLIES JL0934 - EVIDENCE CLIP BOARD 34.66 010-10.1100.580000 OFFICE SUPPLIES AM0959 - NOTARY STAMPS FOR 134.75 010-10.1100.590000 OPERATING SUPPLIES & MS1007 - THANKSGIVING BASK 32.97 010-10.1400.410000 REPAIR OF VEHICLES AH1171- E911 BATTERIES / VEH 513.28 010-10.1400.470000 TRAINING/TRAVEL EXPEN CR1197 - PARKING 11/11/21 AT 10.00 010-10.1400.470000 TRAINING/TRAVEL EXPEN CR1197 - COVID-19 VACCINCE 129.00 010-10.1400.580000 OFFICE SUPPLIES AH1171- REINSTATEMENT FOR 5.00 010-10.1400.590000 OPERATING SUPPLIES & HG1189 - KITCHEN SUPPLIES 31.97 010-10.1500.590000 OPERATING SUPPLIES & HG1189 - KITCHEN SUPPLIES 31.98 010-40.3100.460300 PROGRAMS KL1015 - ADULT PROGRAM SUP 30.40 010-40.3100.460300 PROGRAMS KL1015 - ADULT PROGRAM SUP 84.50 010-40.3100.470000 TRAINING/TRAVEL EXPEN KW1023 - STAFF TRAINING 26.99 010-40.3100.640000 LIBRARY BOOKS/FILMS/R KL1015 - MAGAZINES 16.05 010-40.3100.640000 LIBRARY BOOKS/FILMS/R KL1015 - MAGAZINES 34.24 010-40.3100.640000 LIBRARY BOOKS/FILMS/R KL1015 - MAGAZINES 23.54 010-40.3100.640000 LIBRARY BOOKS/FILMS/R KL1015 - MAGAZINES 38.52 010-40.3100.640000 LIBRARY BOOKS/FILMS/R KL1015 - MAGAZINES 25.68 010-40.3100.640000 LIBRARY BOOKS/FILMS/R KL1015 - MAGAZINES 21.37 010-40.3100.640000 LIBRARY BOOKS/FILMS/R KL1015 - MAGAZINES 6.42 010-40.3100.640000 LIBRARY BOOKS/FILMS/R KL1015 - MAGAZINES 8.55 010-40.3100.640000 LIBRARY BOOKS/FILMS/R KL1015 - MAGAZINES 10.70 010-40.3100.640000 LIBRARY BOOKS/FILMS/R KL1015 - MAGAZINES 16.03 010-40.3100.640000 LIBRARY BOOKS/FILMS/R KL1015 - MAGAZINES 16.03 010-40.3100.640000 LIBRARY BOOKS/FILMS/R KL1015 - MAGAZINES 16.05 010-40.3100.640000 LIBRARY BOOKS/FILMS/R KL1015 - MAGAZINES 126.54 010-40.3100.640000 LIBRARY BOOKS/FILMS/R KL1015 - MAGAZINES 26.75 010-40.4200.461700 WINTER FEST RC1148 - GRAHAM CRACKERS 28.38 010-40.4200.461700 WINTER FEST RC1148 - TABLE CLOTHS LADLES 24.00 12/29/2021 1:49:13 PM Page 6 of 10 Check Report Vendor Number 235285 Vendor Name Payment Date 010-40.4200.461700 WINTER FEST 010-50.8500.470000 TRAINING/TRAVEL EXPEN 010-50.8500,470000 TRAINING/TRAVEL EXPEN 010-50.8500.470000 TRAINING/TRAVEL EXPEN 010-50.8700.470000 TRAINING/TRAVEL EXPEN 010-60.8200.210000 PUBLIC NOTIFICATION/AD 010-60.8300.470000 TRAINING/TRAVEL EXPEN 010-60.8350.230000 CONSULTANT & PROFESSI 010-60.8350.470000 TRAINING/TRAVEL EXPEN 010-60.8350.470000 TRAINING/TRAVEL EXPEN 010-60.8350.470000 TRAINING/TRAVEL EXPEN 010-60.8350.470000 TRAINING/TRAVEL EXPEN 010-60.8350.470000 TRAINING/TRAVEL EXPEN 010-60.8350.470000 TRAINING/TRAVEL EXPEN 010-60.8350.470000 TRAINING/TRAVEL EXPEN 010-60.8350.470000 TRAINING/TRAVEL EXPEN 010-60.8350.470000 TRAINING/TRAVEL EXPEN 010-60.8400.470000 TRAINING/TRAVEL EXPEN 010-60.8800.270000 DATA PROCESSING 010-60.8800.450000 TELEPHONE 010-60.8800.450000 TELEPHONE 010-60.8800.540000 MINOR EQUIPMENT 010-60.8800.540000 MINOR EQUIPMENT Date Range: 11/01/2021 - 12/31/2021 Payment Type Discount Amount Payment Amount Number RC1148 - TABLE CLOTHS AND FA 32.65 JB5414 - ICSC CONFERENCE HOT 248.30 JB5414 - CREW MEMBERSHIP FE 122.50 JB5414 - CREW MEMBERSHIP A 20.00 BD1403 - MEETING WITH CONS 8.03 SE1502 - FACEBOOK ADVERTISI 50.00 R51528 - 11/08/2021 COUNCIL 189.40 TC1486 - RENEWAL OF CLEARIN 125.00 ML1494 - TRAVEL EXPENSES FO 30.60 ML1494 - TRAVEL EXPENSES FO 8.88 ML1494 - TRAVEL EXPENSES FO 29.94 ML1494 - TRAVEL EXPENSES FO 75.00 ML1494 - TRAVEL EXPENSES FO 30.00 ML1494 - TRAVEL EXPENSES FO 964.84 ML1494 - TRAVEL EXPENSES FO 22.88 ML1494 - TRAVEL EXPENSES FO 9.95 ML1494 - TRAVEL EXPENSES FO 4.98 LB1460 - METRO FINANCE LUNC 15.34 SL1239 - IT SOFTWARE 1,800.00 SL1239 - PURCHASE FROM VOY 200.00 SL1239 - NEW TELEPHONE SERV 100.00 SL1239 - GPS SYNCHRONIZED N 595.44 SL1239 - FEES TRANSACTION FO 5.95 WELLS FARGO COMMERCIAL CARD 12/07/2021 EFT 0.00 7,446.38 254216 12/29/2021 1:49:13 PM Page 7 of 10 Check Report Vendor Number Payable # NJ1`12072C21 Vendor Name Payable Type Account Number Invoice 010-10.1100.360000 010-10.1100.390000 010-10.1100.460200 010-10.1100.460200 010-10.1100.540000 010-10.1100.540000 010-10.1100.540000 010-10.1100.580000 010-10.1100.580000 010-10.1400.470000 010-10.1400.540000 010-10.1400.590000 010-10.1500.470000 010-10.1500.590000 010-20.6000.280000 010-20.6150.570130 010-20.6150.570130 010-40.3100.460300 010-40.3100.460300 010-40.3100.460300 010-40.3100.460300 010-40.3100.460400 010-40.3100.460400 010-40.3100.460400 010-40.3100.460400 010-40.3100.460400 010-40.3100.460400 010-40.3100.460400 010-40.3100.460400 010-40.3100.460400 010-40.3100.460400 010-40.3100.460400 010-40.3100.460400 010-40.3100.460400 010-40.3100.460400 010-40.3100.640000 010-40.4200.460510 010-40.4200.461700 010-40.4200.461700 010-40.4200.461700 010-40.4200.470000 010-50.8700.470000 010-50.8700.470000 010-50.8700.590000 010-60.8200.210000 010-60.8200.270100 010-60.8200.461200 010-60.8200.540000 010-60.8300.470000 010-60.8300.470000 010-60.8300.470000 010-60.8300.590000 010-60.8800.270000 010-60.8800.450000 510-30.6510.470000 750-80.8750.470000 Date Range: 12/01/2021 - 12/31/2021 Payment Date Payment Type Discount Amount Payment Amount Number Post Date Payable Description Discount Amount Payable Amount Account Name Item Description Distribution Amount 12/07/2021 WELLS FARGO CREDIT CARD STATEMENT 0.00 7,446.38 POSTAGE & SHIPPING JM0942 - SHIP BACK WEAPON C 14.89 RENTAL/LEASE OF EQUIP JM0942 - LOCK BOX STORAGE U 212.06 PD COMMUNITY POLICIN KC0892 - OPERATION WISH LIST 45.99 PD COMMUNITY POLICIN MS1007 - Program Supplies 24.61 MINOR EQUIPMENT AC0884 - DRAWERS FOR OFFICE 64.20 MINOR EQUIPMENT AC0884 - OFFICE DRAWER UNIT 171.19 MINOR EQUIPMENT JM0942 - TACTICAL WEAPON LI 591.98 OFFICE SUPPLIES MS1007 - SUPPLIES/GIFTS FOR 21.18 OFFICE SUPPLIES M51007 - SUPPLIES/GIFTS FOR 34.24 TRAINING/TRAVEL EXPEN TT1205 - AHIMT - PLANNING SE 2.21 MINOR EQUIPMENT TT1205 - RADIO STRAP 158.56 OPERATING SUPPLIES & HG1189 - KITCHEN SUPPLIES 18.05 TRAINING/TRAVEL EXPEN TT1205 - AHIMT- PLANNING SE 7.82 OPERATING SUPPLIES & HG1189 - KITCHEN SUPPLIES 18.06 DUES, MEMBERSHIPS & S RK1551- PROFESSIONAL ENGIN 100.00 COGS - PARTS RB1247 - INT'L FEE FOR MICRO 1.33 COGS - PARTS RB1247 - 2 MICRO DETECTORS 133.04 PROGRAMS KW1023 - KIDS PROGRAM SUPP 43.87 PROGRAMS KW1023 - KIDS PROGRAM SUPP 16.04 PROGRAMS KL1015 - ADULT PROGRAM SUP 85.16 PROGRAMS KW1023 - KIDS PROGRAM SUPP 8.49 SUMMER READING CLUB KL1015 - SUMMER PROGRAM P 50.00 SUMMER READING CLUB KW1023 - SUMMER PROGRAM 160.00 SUMMER READING CLUB KL1015 - SUMMER PROGRAM P 51.50 SUMMER READING CLUB KL1015 - SUMMER PROGRAM P 213.99 SUMMER READING CLUB KL1015 - SUMMER PROGRAM P 40.00 SUMMER READING CLUB KL3015 - SUMMER PROGRAM P 192.75 SUMMER READING CLUB KL1015 - SUMMER PROGRAM P 59.20 SUMMER READING CLUB KL1015 - SUMMER PROGRAM P 50.00 SUMMER READING CLUB KL1015 - SUMMER PROGRAM P 77.00 SUMMER READING CLUB KL1015 - SUMMER PROGRAM P 36.06 SUMMER READING CLUB KL1015 - SUMMER PROGRAM P 50.00 SUMMER READING CLUB KL1015 - SUMMER PROGRAM P 50.00 SUMMER READING CLUB KL1015 - SUMMER PROGRAM P 53.48 SUMMER READING CLUB KL1015 - SUMMER PROGRAM P 75.62 LIBRARY BOOKS/FILMS/R KL1015 - MAGAZINE 62.06 YOUTH SPORTS LEAGUES MJ1080 - ACCIDENTAL CHARGE 50.00 WINTER FEST DE1056 - MEGAPHONE 29.99 WINTER FEST DE1056-COSTUME DEPOSIT 95.00 WINTER FEST DE1056 - SANTA AND ELF COST 95.00 TRAINING/TRAVEL EXPEN JV1122 - WINTERFEST STAFF ME 75.28 TRAINING/TRAVEL EXPEN BD1403 - MEETING WITH CONS 2.49 TRAINING/TRAVEL EXPEN BD1403 - ONLINE SUBSCRIPTIO 201.80 OPERATING SUPPLIES & BD1403 - HOLIDAY DECORATION 262.15 PUBLIC NOTIFICATION/AD SE1502 - FACEBOOK ADVERTISI 15.00 COMPUTER SUPPORT SE1502 - MONTHLY ADOBE STO 29.99 NEWSLETTER/PUBLICATI SE1502 - ANNUAL E-NEWSLETTE 782.65 MINOR EQUIPMENT SE1502 - PURCHASE OF DUAL W 246.05 TRAINING/TRAVEL EXPEN RS1528 - LEGISLATIVE BREAKFAS 35.00 TRAINING/TRAVEL EXPEN RS1528 - 01-27-2022 PARTNERS 1,750.00 TRAINING/TRAVEL EXPEN TM1510 - MEETING WITH MAY 11.45 OPERATING SUPPLIES & RS1528 - FUNERAL FLOWERS - B 100.90 DATA PROCESSING SL1239 - SANGOMA SUPPORT 2 395.00 TELEPHONE SL1239- TELEPHONE SERVICE F 200.00 TRAINING/TRAVEL EXPEN RK1551- SHAWN ALDRICH 2DN 30.00 TRAINING/TRAVEL EXPEN AH1171- CPR CARDS FOR GOLF 44.00 12/29/2021 1:49:13 PM Page 8 of 10 Check Report Vendor Number Vendor Name Payment Date Payment Type Bank Code AP Summary Payable Payment Payment Type Count Count Discount Regular Checks 0 0 0.00 Manual Checks 0 0 0.00 Voided Checks 0 0 0.00 Bank Drafts 0 0 0.00 EFT's 4 4 0.00 4 4 0.00 Date Range: 11/01/2021 - 12/31/2021 Discount Amount Payment Amount Number Payment 0.00 0.00 0.00 0.00 41,076.98 12/29/2021 1:49:13 PM Page 9 of 10 Check Report Date Range: 11/01/2021 - 12/31/2021 All Bank Codes Check Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 0 0 0.00 0.00 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 4 4 0.00 41,076.98 4 4 0.00 41,076.98 Fund Summary Fund Name Period Amount 999 POOLED CASH 11/2021 22,257.49 999 POOLED CASH 12/2021 18,819.49 41,076.98 12/29/2021 1:49:13 PM Page 10 of 10 City of Waukee, IA Employee Name ABRAMOWITZ, LEVI ADKINS, COREY ADKISSON, JENNIFER AHRENS, ELIZA ALDRICH, SHAWN ANDERSON, SARA ANNIS, JEREMY ARIAS, HECTOR BAKER, RANDY BASYE,JONATHA BAUMAN, LISA BECKNER, HALEY BEDFORD, SAMANTHA BERG, BROOKE BERGMAN, ANNASTASIA BORICH, CHELSEA BOTTENBERG, RICHARD BOYLE, GAVIN BROOKS, AMBER BROWN, ANGALEA BROWN, JENNIFER BROWN, NATHAN BRUENING, BENJAMIN BRUNS, RACHEL BURKHART, LINDA BURKHART, MARK CAMPBELL, SCOTT CARPENTER, PAUL CARROLL,JOSEPH CHRISTENSEN, ABAGAIL CICHOSKI, KELLI CLARKE, COURTNEY CLAYTON, EMMA CLEMEN, ANTHONY COGGESHELL, LEE CORKREAN, JENNIFER COUGHLIN, TONI COX, BENJAMIN CRAVEN,GAYLA CRONE, CHRISTINE CRONE, ERIN CUNNINGHAM, SCOTT DANIEL, COLE DEBOER, MELISSA DEETS, BRADLY DEZEEUW, DAVID DODGE, JUSTIN EDWARDS, DANAE EVANS, SUMMER FLUGGE-SMITH, JAMIE FREDERICK, JUSTIN FREDERICKSEN, BROCK FROEHLICH, WILLIAM FURRY, ALISSA FYFE, JUSTIN GARLICH, ELIZABETH GAVIN, HALEY Payroll Publication Report By Employee Name Payroll Set: 01 - City of Waukee For Date Range 12232021-12232021 Salary 2,348.94 1,504.78 662.19 1,335.78 1,768.33 1,523.69 363.92 2,522.36 1,700.32 2,432.58 1,335.07 1,481.52 1,380.76 561.17 619.49 1,808.14 622.44 1,641.74 569.87 1,399.15 2,432.46 2,195.73 271.46 2,224.79 2,989.53 1,077.97 2,359.75 1,688.24 2,112.55 1,285.83 1,823.66 1,085.52 56.69 2,852.43 1,568.66 1,581.40 1,002.35 364.86 149.83 533.20 53.31 2,847.77 1,644.76 637.79 3,589.25 2,672.41 2,058.40 2,001.34 2,694.14 1,824.94 2,040.55 1,289.59 408.84 281.37 1,351.98 278.23 1,092.53 C�- Employee Name Salary GIBBS, AUSTIN 1,902.89 GIBSON IV, WILLIAM 1,708.98 GILCHRIST, NICHOLAS 1,799.73 GILMORE, JOANNA 757.06 GITZEN, ROBERT 2,301.23 GOINS, ANDREA 2,321.24 GROVE, BRIAN 359.81 GUESS, CHRISTOPHER 1,432.12 GUESS, KATHRYN 2,241.39 HANSON, LAURA 1,638.06 HEIMANN, RONALD 2,012.28 HENTGES, ERIC 2,291.37 HERRICK, ROBERT 1,953.89 HILGENBERG, ADAM 1,942.80 HUSTED, TROY 1,829.05 H UTTON, JOSHUA 2,159.10 JACKSON, COLE 1,798.58 JERMIER, MATTHEW 3,111.69 JOHNSON, WYATT 1,468.76 KAMMERER, EMMILY 209.97 KAPPOS, SARA 2,727.22 KASS, ANDREW 2,357.56 KASZINSKI, BRETT 389.20 KELLER, CHRISTOPHER 1,949.91 KICKBUSH, CHRISTOPHER 2,095.36 KINNEY, SCOTT 1,548.94 KLEINWOLTERINK, COLE 2,105.22 KLEVER, JUDY 1,451.85 KNEPPER, AARON 111.85 KNUDSEN, DYLAN 1,554.62 KOESTER, RUDY 3,324.98 KREFT, ALEXUS 639.84 LARSON, KENNETH 179.14 LARSON, KRISTINE 3,042.97 LAUGHRIDGE, DANIEL 1,675.21 LE, SON 3,111.69 LEMKE, NEIL 2,131.37 LEVSEN, BRYAN 1,892.04 LINDSAY, MICHELLE 1,854.02 LONG, JEREMY 2,974.14 LOVETINSKY, TRACY 957.11 LYNCH, JEREMY 1,516.77 LYON, LARRY 619.84 MAGNUSSEN, JACK 509.00 MANNING, JOSHUA 2,255.02 MAREAN, JOSHUA 1,513.82 MAREK, JAMES 1,517.34 MCCAY, BRENDA 272.83 MCCOY, CARA 449.89 MEEKER, BRYCE 1,385.91 MELLENCAMP, JEFFREY 2,785.00 METTEE, WILLIAM 1,866.28 MINAR, VANESSA 1,169.98 MINIKUS, JOSHUA 2,203.18 MOERMAN, TIMOTHY 4,438.33 MONA, RACHEL 1,763.60 MORRIS, ASHLEY 1,503.76 MURRA, BRIAN 2,350.00 NELSON, DAVID 1,324.27 NEWBURY, NICHOLAS 1,791.90 NICHOLS, ANDREW 1,677.30 OLDHAM, JAMES 2,441.43 OLSASKY, JOHN 308.72 OSBORN, RYAN 151.90 Y Employee Name Salary OSBORN, SARAH 1,704.89 OSTRING, KATHLEEN 1,697.54 OWENS, TANNER 738.85 PARISH, TONJA 1,521.46 PATTERSON, KEVIN 2,149.23 PAYNE, THOMAS 1,581.10 PERKINS, JACOB 1,777.10 PETTIT, BRANDON 2,655.10 PIZINGER, JAMES 1,382.93 PORTER, NICKOLAS 778.81 PURVIS, KATHRYN 1,467.75 QUAM, BRADLEY 1,524.00 QUINN, JOHN 3,796.59 RASH, RONALD 2,317.15 RICHARDSON, DACE 1,478.54 RICHARDSON, ELIZABETH 1,614.97 ROBBINS, CORBY 2,193.39 ROBINSON, CLINT 3,662.11 ROBINSON, NATHANIEL 298.16 ROTH, TITO 1,455.68 ROTSCHAFER, CARMEN 1,450.07 ROYER, TIMOTHY 2,910.70 SAENGKIO, DONNY 2,041.25 SAGER, AARON 204.05 SCHAUFENBUEL, KARI 1,060.86 SCHETTLER, RODNEY 2,299.78 SCHUETT, REBECCA 2,620.95 SCHULTZ, JEFFREY 1,416.83 SEDDON, JOSH 1,869.85 SEELY, AUSTEN 573.12 SHAFFER, CHET 395.87 SINCLAIR, BENJAMIN 619.84 SMITH, BLAKE 1,440.55 SNOW, SUSAN 169.94 SOFEN, NATASHA 30.59 SPOSETO, MACKENZIE 2,523.92 STEINKE, KURT 597.89 STEPHENS, CLINT 375.94 STEWARD, ERIC 1,837.72 STIFEL, DALTON 2,325.61 STOTZ, MELISSA 900.79 SULLIVAN, RYAN 380.86 TAYLOR, CHRISTINA 182.12 THAYER, CHANDLER 1,646.19 TOWNSEND, MCKENNA 1,563.39 TRUMAN, GRAHAM 162.58 TYSDAL, THOMAS 3,082.77 VANDEKAMP, JOSHUA 2,157.28 VENTO, NICHOLAS 754.58 VOEGTLE, TIMOTHY 1,690.79 WASKE, CHARLES 1,984.86 WERNIMONT, THOMAS 355.09 WERTS, DANIEL 2,063.84 WESTON STOLL, KERI 1,794.09 WHITE, JASON 1,368.38 WHITHAM JOHNSON, JENNIFER 671.62 WIGGINS, MATHEW 2,392.83 WILLIAMS, SUSAN 1,807.43 WINTERS, TROY 2,282.34 WISE, NATHAN 3,777.22 WOOD, DANIEL 1,115.55 YOUNG, JOHNATHAN 1,882.52 YOUSO, ANTHONY 1,417.36 *TOTALS* 291,131.82