Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2020-11-02-J01A 11022020_bill list_payroll
City of Waukee Bill Presentation Recap November 2, 2020 Total Unpaid Bills Presented for Approval : $ 521,796.88 Total Checks Issued Prior to Council Approval: (A) Prior to Last Council Meeting $ 431.70 (B) After Last Council Meeting $ 199,190.16 (C) Payroll Taxes & Reimbursements $ 298,505.85 (D) Utility Refunds $ 1,662.13 Payroll Checks Issued (E) 10/15/2020 ** Credit Card Detail also included in "F" FY 2021 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 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 $ 282,508.44 $ 9,746.57 Grand Total: Expenditures Budgeted Year To Date $ 17,557,944 $ 3,942,282 $ 1,313,841.73 Revenues Budgeted Year To Date $ 16,886,337 $ 5,442,649 $ - $ 2,638 $ - $ 817 $ 2,671,322 $ 666,486 $ 445,822 $ 555,314 $ 1,742,506 $ - $ 823,245 $ 421,985 $ 2,048,762 $ - $ 3,731,276 $ 1,575,824 $ 869,532 $ 43,260 $ 1,327,728 $ 307,420 $ 374,581 $ - $ 711,471 $ 115 $ - $ 488 $ - $ - $ - $ 26,288 $ 71,049 $ 26,946 $ - $ - $ 154,346 $ - $ 9,518,084 $ 600 $ 10,975,755 $ 2,129,111 $ - $ - $ - $ 8,406 $ 2,475,000 $ - $ 2,501,444 $ 1,144,471 $ 523,620 $ - $ 2,923,900 $ 530,196 $ 2,000,000 $ - $ 2,000,000 $ 836 $ 26,109,000 $ 6,953,823 $ 23,432,370 $ (1,122,201) $ - $ - $ - $ 1,759 $ 688,232 $ 1,496,790 $ 5,791,584 $ 3,426,316 $ 3,269,446 $ 4,243,367 $ 1,721,061 $ 2,924,875 $ - $ - $ - $ 26,018 $ - $ - $ - $ 22 $ - $ - $ - $ 76 $ 7,172,989 $ 1,395,694 $ 8,638,750 $ 1,072,154 $ 1,980,128 $ 1,376,942 $ 1,140,833 $ 422,296 $ 394,960 $ 111,258 $ 395,196 $ 161,717 $ 1,428,400 $ 594,222 $ 1,425,900 $ 485,564 $ 594,288 $ 218,154 $ 608,500 $ 331,507 $ - $ - $ 15,000 $ 94 Total: $ 81,418,794 $ 21,072,292 $ 85,721,567 $ 19,874,285 City of Waukee FY2021 Department Report - General Fund As of NOVEMBER 2ND 2020 Expended YTD Budgeted $ Remaining General Fund: Police Department Personnel Services $ 994,845 $ 3,593,600 Supplies & Services $ 144,078 $ 467,470 Capital Outlay $ - $ 100,200 $ 1,138,923 $ 4,161,270 $ 3,022,347 Warning Sirens Personnel Services $ - Supplies & Services $ 1,082 $ 4,700 Capital Outlay $ - $ - $ 1,082 $ 4,700 $ 3,618 Emergency Management Supplies & Services $ 2,217 $ 2,217 $ 2,217 $ - $ (2,217) Westcom Dispatch Personnel Services $ - $ - Supplies & Services $ - $ 650,000 Capital Outlay $ - $ - $ - $ 650,000 $ 650,000 Fire Department Personnel Services $ 245,923 $ 755,115 Supplies & Services $ 51,974 $ 195,430 Capital Outlay $ 223 $ 5,500 $ 298,120 $ 956,045 $ 657,925 EMS Personnel Services $ 500,820 $ 1,727,395 Supplies & Services $ 67,297 $ 169,240 Capital Outlay $ 72,972 $ 99,500 $ 641,089 $ 1,996,135 $ 1,355,046 Building Inspection Personnel Services $ 165,427 $ 548,400 Supplies & Services $ 9,554 $ 32,000 Capital Outlay $ - $ - $ 174,981 $ 580,400 $ 405,419 Animal Control Personnel Services $ - $ - Supplies & Services $ 2,089 $ 10,437 Capital Outlay $ - $ - $ 2,089 $ 10,437 $ 8,348 Library Services Personnel Services $ 210,939 $ 882,990 Supplies & Services $ 113,139 $ 294,100 Capital Outlay $ 4,975 $ 50,500 $ 329,053 $ 1,227,590 $ 898,537 Mosquito Control Personnel Services $ - Supplies & Services $ - $ 2,000 Capital Outlay $ - $ - $ 2,000 $ 2,000 Parks Personnel Services $ 105,792 $ 386,950 Supplies & Services $ 92,537 $ 236,750 Capital Outlay $ 13,826 $ 152,500 $ 212,154 $ 776,200 $ 564,046 Recreation Personnel Services $ 163,486 $ 572,650 Supplies & Services $ 53,164 $ 221,060 Capital Outlay $ 13,826 $ 40,000 $ 230,476 $ 833,710 $ 603,234 Community Center Personnel Services $ 1,416 $ 11,800 Supplies & Services $ 4,229 $ 23,000 Capital Outlay $ - $ - $ 5,646 $ 34,800 $ 29,154 Public Works Personnel Services $ (55,588) $ 68,310 Supplies & Services $ (12,117) $ 2,725 Capital Outlay $ - $ - $ (67,706) $ 71,035 $ 138,741 Public Works Building Personnel Services $ Supplies & Services $ 83,766 $ Capital Outlay $ - $ - $ 83,766 $ - $ (83,766) Public Works Mechanic Personnel Services $ 53,776 $ 196,250 Supplies & Services $ 54,877 $ (3,800) Capital Outlay $ - $ - $ 108,652 $ 192,450 $ 83,798 Median and Bldg Grounds Personnel Services $ - $ - Supplies & Services $ 22,164 $ 42,000 Capital Outlay $ - $ - $ 22,164 $ 42,000 $ 19,836 Mayor & Council Personnel Services $ 19,983 $ 63,900 Supplies & Services $ 11,458 $ 32,250 Capital Outlay $ - $ - $ 31,441 $ 96,150 $ 64,709 Elections Personnel Services $ - $ - Supplies & Services $ - $ Capital Outlay $ - $ - Communications Personnel Services $ 24,833 $ 119,615 Supplies & Services $ 5,713 $ 47,190 Capital Outlay $ - $ - $ 30,546 $ 166,805 $ 136,259 Administration Personnel Services $ 45,651 $ 238,704 Supplies & Services $ 60,549 $ 155,000 Capital Outlay $ - $ 2,581,500 $ 106,200 $ 2,975,204 $ 2,869,004 City Hall Personnel Services $ - $ - Supplies & Services $ 72,871 $ 147,000 Capital Outlay $ - $ - $ 72,871 $ 147,000 $ 74,129 Human Resources Personnel Services $ 19,983 $ 146,120 Supplies & Services $ (6,564) $ 31,830 Capital Outlay $ - $ - $ 13,418 $ 177,950 $ 164,532 Financial Administration Personnel Services $ (13,459) $ 216,250 Supplies & Services $ 5,666 $ 30,200 Capital Outlay $ - $ 15,000 Other Financing $ - $ (7,794) $ 261,450 $ 269,244 Community Development Personnel Services $ 23,844 $ 177,410 Supplies & Services $ 33,270 $ 121,850 Capital Outlay $ - $ - $ 57,114 $ 299,260 $ 242,146 City Attorney Personnel Services $ - Supplies & Services $ 41,104 $ 150,000 Capital Outlay $ - $ 41,104 $ 150,000 $ 108,897 Development Services Personnel Services $ 125,759 $ 416,900 Supplies & Services $ 2,876 $ 78,400 Capital Outlay $ - $ - $ 128,636 $ 495,300 $ 366,664 Information Technology Personnel Services $ 49,313 $ 204,685 Supplies & Services $ 34,236 $ 101,460 Capital Outlay $ 16,309 $ 107,100 $ 99,858 $ 413,245 $ 313,387 Engineering Personnel Services $ 131,662 $ 468,120 Supplies & Services $ 17,756 $ 269,335 Capital Outlay $ 30,641 $ 31,000 $ 180,059 $ 768,455 $ 588,396 GIS Personnel Services $ (10,099) $ 27,690 Supplies & Services $ 16,220 $ (6,300) Capital Outlay $ - $ 2,400 $ 6,121 $ 23,790 $ 17,669 Transfers to GO Debt Service $ 3,942,281 $17,513,381 $ 13,571,100 Total General Fund: Personnel Services $ 2,804,304 Supplies & Services $ 985,206 Capital Outlay $ 152,771.49 Other $ - $ 3,942,281 Expense Approval Register City of Waukee, IA �PPKT02061 - NOVEMBER 3RD COUNCIL PACKET Wa'ikee Vendor Name Payable Number Post Date Description (Item) Account Number Amount Department: 1100 - POLICE OPERATIONS ALSMITH 1 09/17/2020 SPEAKER PRESENTATION 010-10.1100.470000 250.00 ELECTRONIC ENGINEERING C 120010261-1 10/14/2020 LIGHTBAR TROUBLESHOOTI 010-10.1100.410000 110.00 GORILLA GRAFFITI, INC 13307 10/22/2020 SPECIAL POLICE/BREAST CAN 010-10.1100.460200 818.40 SIOUX SALES COMPANY 189824 10/02/2020 MAG POUCH 010-10.1100.120000 309.70 SIOUX SALES COMPANY 189825 10/02/2020 HOLSTERS 010-10.1100.120000 540.00 AMAZON.COM 1CG6-HXFN-YLTQ 10/13/2020 LENSE CLEANING WIPES 010-10.1100.590000 35.38 AMAZON.COM 1PP6-71Y6-CWJ6 10/18/2020 ARMOR ALL CAR INTERIOR 010-10.1100.590000 43.69 RAY O'HERRON CO., INC. 2057003-IN 10/09/2020 VEST- SCHETTLER 010-10.1100.120000 232.27 SIMPLEXGRINNELL LP 21905031 10/01/2020 FIRE ALARM TEST & INSPECT 010-10.1100.400000 908.38 IOWA LAW ENFORCEMENT A 315848 10/05/2020 PRECISION DRIVING - KINNE 010-10.1100.470000 625.00 DELTA DENTAL 33075000200202011 11/01/2020 NOV '20 DENTAL INSURANCE 010-10.1100.100000 2,387.36 MID AMERICAN ENERGY 505037532 10/15/2020 OCTOBER 2020 STATEMENT 010-10.1100.480000 723.00 HOLMES MURPHY 563350 11/01/2020 NOV '20 HMA MONTHLY CO 010-10.1100.100000 1,050.39 STIVERS FORD 607183 10/06/2020 PUMP REPAIRS 010-10.1100.410000 1,376.62 STIVERS FORD 607404 10/08/2020 PUMP REPAIRS 010-10.1100.410000 1,370.14 STIVERS FORD 607546 10/09/2020 VEHICLE REPAIRS - ENGINE 010-10.1100.410000 840.53 STAPLES BUSINESS CREDIT 7307394336-0-6 09/29/2020 DISINFECTANT WIPES 010-10.1100.590000 21.89 STAPLES BUSINESS CREDIT 7312076804-0-1 10/20/2020 PAPER TOWELS/TOILET PAPE 010-10.1100.590000 96.78 STAPLES BUSINESS CREDIT 7312495004-0-1 08/24/2020 DISINFECTING WIPES 010-10.1100.590000 101.38 STAPLES BUSINESS CREDIT 7312861896-0-1 08/28/2020 PROTECTIVE SHEETS/MARKE 010-10.1100.580000 156.23 STAPLES BUSINESS CREDIT 7312861896-0-2 08/28/2020 PENS 010-10.1100.580000 7.99 STAPLES BUSINESS CREDIT 7312861896-1-1 09/03/2020 CREDIT- SHARPIE 010-10.1100.580000 -1.00 STAPLES BUSINESS CREDIT 7313007284-0-1 08/31/2020 CLEANING SUPPLIES 010-10.1100.590000 17.38 STAPLES BUSINESS CREDIT 7313007284-0-2 08/31/2020 FORKS 010-10.1100.590000 61.99 STAPLES BUSINESS CREDIT 7313727735-0-1 09/11/2020 HANGING FOLDERS 010-10.1100.580000 49.71 STAPLES BUSINESS CREDIT 7313878186-0-1 09/14/2020 HAND SANITIZER DISPENSER 010-10.1100.540000 129.99 STAPLES BUSINESS CREDIT 7313978331-0-1 09/15/2020 BATTERIES 010-10.1100.590000 21.49 STAPLES BUSINESS CREDIT 7314107266-0-1 09/25/2020 PAPER TOWELS 010-10.1100.590000 35.99 STAPLES BUSINESS CREDIT 7315198241-0-1 10/02/2020 DESK ORGANIZER/BINDERS/ 010-10.1100.580000 91.96 STAPLES BUSINESS CREDIT 7315198241-1-1 10/08/2020 CREDIT - SHARPIE 010-10.1100.580000 -1.02 NIGHT & DAY WINDOW CLEA 991 10/13/2020 WINDOW CLEANING SERVIC 010-10.1100.400100 210.00 SHI INTERNATIONAL CORP B12274249 09/11/2020 MONITORS/DOCKING STATIO 010-10.1100.540000 1,339.00 SHI INTERNATIONAL CORP B12286609 09/15/2020 LENOVOTHINKCENTRES 010-10.1100.540000 2,605.00 KIESLER'S POLICE SUPPLY, IN IN147783 10/05/2020 HOLSTER 010-10.1100.120000 55.85 CITY OFJEFFERSON INVO010178 11/03/2020 CONTRACT BUYOUT - JACKS 010-10.1100.470000 15,172.79 CITY OF CLIVE INVO010182 10/13/2020 FY21 ANNUAL SERT CONTRIB 010-10.1100.230350 900.00 IOWA DEPT OF PUBLIC SAFE INVO010183 10/19/2020 JULY 20 - SEPT 20 ONLINE W 010-10.1100.450000 1,173.00 Department 1100 - POLICE OPERATIONS Total: 33,867.26 Department: 1400 - FIRE PROTECTION EARL MAY SEED & NURSERY 001-00022970 07/01/2020 PEAT 010-10.1400.590000 12.09 EARL MAY SEED & NURSERY 001-00029328 07/01/2020 PEAT 010-10.1400.590000 24.18 EARL MAY SEED & NURSERY 001-00037647 10/02/2020 PEAT 010-10.1400.590000 23.74 EARL MAY SEED & NURSERY 002-00019613 09/01/2020 PEAT 010-10.1400.590000 26.38 ED M FELD EQUIPMENT CO 0374673-IN 10/02/2020 COMPRESSOR/DRYER AIR CO 010-10.1400.410000 102.85 AMAZON.COM 164V-4F9R-QDRX 10/19/2020 BATTERY STICK/CHARGE COR 010-10.1400.540000 14.02 AMAZON.COM 1MYW-JJRD-T3C9 10/19/2020 TV MOUNT/STICKY TABS 010-10.1400.580000 6.62 AMAZON.COM 1MYW-JJRD-T3C9 10/19/2020 TV MOUNT/STICKY TABS 010-10.1400.880000 70.19 AMAZON.COM 1XK4-GT4Y-VL4W 10/12/2020 MAGNETIC LABEL HOLDERS/ 010-10.1400.880000 43.43 SIMPLEXGRINNELL LP 21905031 10/01/2020 FIRE ALARM TEST & INSPECT 010-10.1400.400000 939.21 DELTA DENTAL 33075000200202011 11/01/2020 NOV '20 DENTAL INSURANCE 010-10.1400.100000 582.07 MID AMERICAN ENERGY 505037532 10/15/2020 OCTOBER 2020 STATEMENT 010-10.1400.480000 594.21 HOLMES MURPHY 563350 11/01/2020 NOV '20 HMA MONTHLY CO 010-10.1400.100000 210.70 THE WALDINGER CORP 9039145-1 10/07/2020 REPLACED DEFECTIVE CASSE 010-10.1400.400000 470.69 Expense Approval Register Packet: APPKT02061- NOVEMBER 3RD COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount SHI INTERNATIONAL CORP B12268158 09/10/2020 MONITORS 010-10.1400.540000 130.02 SHI INTERNATIONAL CORP B12288175 09/16/2020 LENOVOTHINKCENTRES 010-10.1400.540000 458.48 SHI INTERNATIONAL CORP B12381056 10/O1/2020 MONITORS 010-10.1400.540000 189.20 Department 1400 - FIRE PROTECTION Total: 3,898.08 Department: 1500 - EMS EARL MAY SEED & NURSERY G01-00022970 07/O1/2020 PEAT 010-10.1500.590000 42.86 EARL MAY SEED & NURSERY 001-00029328 07/O1/2020 PEAT 010-10.1500.590000 85.72 EARL MAY SEED & NURSERY 001-00037647 10/02/2020 PEAT 010-10.1500.590000 84.17 EARL MAY SEED & NURSERY 002-00019613 09/O1/2020 PEAT 010-10.1500.590000 93.52 FRUSA EMS 13167 10/07/2020 OCTOBER 2020 STATEMENT 010-10.1500.231800 1,724.53 AMAZON.COM 164V-4F9R-QDRX 10/19/2020 BATTERY STICK/CHARGE COR 010-10.1500.540000 49.73 AMAZON.COM 1MYW-JJRD-T3C9 10/19/2020 TV MOUNT/STICKY TABS 010-10.1500.580000 1.87 AMAZON.COM 1MYW-JJRD-T3C9 10/19/2020 TV MOUNT/STICKY TABS 010-10.1500.880000 19.80 AMAZON.COM IXK4-GT4Y-VL4W 10/12/2020 MAGNETIC LABEL HOLDERS/ 010-10.1500.880000 153.98 SIMPLEXGRINNELL LP 21905031 10/01/2020 FIRE ALARM TEST & INSPECT 010-10.1500.400000 264.91 DELTA DENTAL 33075000200202011 11/01/2020 NOV '20 DENTAL INSURANCE 010-10.1500.100000 973.29 MID AMERICAN ENERGY 505037532 10/15/2020 OCTOBER 2020 STATEMENT 010-10.1500.480000 364.19 HOLMES MURPHY 563350 11/01/2020 NOV '20 HMA MONTHLY CO 010-10.1500.100000 371.60 BOUND TREE MEDICAL 83794347 10/O1/2020 MEDICAL SUPPLIES 010-10.1500.590050 700.67 THE WALDINGER CORP 9039145-1 10/07/2020 REPLACED DEFECTIVE CASSE 010-10.1500.400000 1,668.81 SH I INTERNATIONAL CORP B12268158 09/10/2020 MONITORS 010-10.1500.540000 460.98 SHI INTERNATIONAL CORP B12288175 09/16/2020 LENOVO THINKCENTRES 010-10.1500.540000 1,625.52 SHI INTERNATIONAL CORP B12381056 10/01/2020 MONITORS 010-10.1500.540000 670.80 ALYSON BECHTUM INV0010180 10/26/2020 AMBULANCE TAX OFFSET RE 010-10.1500.3529900 761.00 Department 1500 - EMS Total: 10,117.95 Department: 1601 - TRAFFIC SIGNALS INTERSTATE ALL BATTERY CE 192460204980 10/07/2020 BATTERIES 060-30.1601.410300 1,999.92 MID AMERICAN ENERGY 505002721 10/15/2020 OCTOBER 2020 STATEMENT 060-30.1601.480000 10.18 MID AMERICAN ENERGY 505004340 10/15/2020 OCTOBER 2020 STATEMENT 060-30.1601.480000 10.18 MID AMERICAN ENERGY 505004662 10/15/2020 OCTOBER 2020 STATEMENT 060-30.1601.480000 339.78 MID AMERICAN ENERGY 505007612 10/15/2020 OCTOBER 2020 STATEMENT 060-30.1601.480000 29.69 MID AMERICAN ENERGY 505011551 10/15/2020 OCTOBER 2020 STATEMENT 060-30.1601.480000 87.90 MID AMERICAN ENERGY 505019578 10/15/2020 OCTOBER 2020 STATEMENT 060-30.1601.480000 27.18 MID AMERICAN ENERGY 505020462 10/15/2020 OCTOBER 2020 STATEMENT 060-30.1601.480000 59.54 MID AMERICAN ENERGY 505021268 10/15/2020 OCTOBER 2020 STATEMENT 060-30.1601.480000 33.13 MID AMERICAN ENERGY 505022794 10/15/2020 OCTOBER 2020 STATEMENT 060-30.1601.480000 41.02 MID AMERICAN ENERGY 505024970 10/15/2020 OCTOBER 2020 STATEMENT 060-30.1601.480000 139.32 MID AMERICAN ENERGY 505030259 10/15/2020 OCTOBER 2020 STATEMENT 060-30.1601.480000 23.25 MID AMERICAN ENERGY 505041887 10/15/2020 OCTOBER 2020 STATEMENT 060-30.1601.480000 57.99 MID AMERICAN ENERGY 505056365 10/15/2020 OCTOBER 2020 STATEMENT 060-30.1601.480000 33.93 Department 1601- TRAFFIC SIGNALS Total: 2,893.01 Department: 1900 - BUILDING INSPECTION IOWA ASSOCIATION OF PLU 202010-1504626 11/03/2020 MEMBER DUES - KEITH RASH 010-10.1900.280000 200.00 DELTA DENTAL 33075000200202011 11/O1/2020 NOV '20 DENTAL INSURANCE 010-10.1900.100000 486.68 HOLMES MURPHY 563350 11/O1/2020 NOV '20 HMA MONTHLY CO 010-10.1900.100000 191.07 STAPLES BUSINESS CREDIT 7309056459-0-1 07/O1/2020 TONER/POST ITS/BINDER CLI 010-10.1900.580000 210.89 STAPLES BUSINESS CREDIT 7312593850-0-1 08/25/2020 MARKERS/SHARPIE PENS 010-10.1900.580000 90.68 STAPLES BUSINESS CREDIT 7312593850-2-1 09/03/2020 CREDIT- MARKER 010-10.1900.580000 -12.48 STAPLES BUSINESS CREDIT 7312705306-0-1 08/26/2020 MARKERS 010-10.1900.580000 28.50 STAPLES BUSINESS CREDIT 7312705306-1-1 09/03/2020 CREDIT- MARKERS 010-10.1900.580000 -12.78 STAPLES BUSINESS CREDIT 7314838456-0-1 09/28/2020 BATTERIES 010-10.1900.590000 39.18 STAPLES BUSINESS CREDIT 7314838456-1-1 10/08/2020 CREDIT- BATTERIES 010-10.1900.580000 -3.86 Department 1900 - BUILDING INSPECTION Total: 1,217.98 Department: 2130 - ALICES ROAD PROJECT TEAM SERVICES INC 1803954-0 09/25/2020 ALICES ROAD ENHANCEMEN 327-90.2130.840492 976.67 IOWA SIGNAL INC 4676 10/10/2020 ALICES ROAD MEDIAN RECEP 327-90.2130.840492 23,260.00 Department 2130 - ALICES ROAD PROJECT Total: 24,236.67 Department: 3100 - LIBRARY SERVICES OVERDRIVE INC 06497CO20349576 10/16/2020 BOOKS 010-40.3100.640000 531.94 10/28/2020 2:24:25 PM Page 2 of 13 Expense Approval Register Packet: APPKT02061- NOVEMBER 3RD COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount OCLC, INC 1000042598 07/O1/2020 CATALOGING AND METADAT 010-40.3100.590000 164.19 ULINE 124608096 09/22/2020 STAND/MASKS 010-40.3100.540000 72.66 ULINE 124608096 09/22/2020 STAND/MASKS 010-40.3100.590000 77.65 OFFICE DEPOT 127059545001 10/O1/2020 BATTERIES/POST ITS/PAPER/ 010-40.3100.580000 70.91 OFFICE DEPOT 127059545001 10/O1/2020 BATTERIES/POST ITS/PAPER/ 010-40.3100.590000 141.92 OFFICE DEPOT 127139763001 10/O1/2020 SWIFFER REFILLS 010-40.3100.590000 11.99 OFFICE DEPOT 128312983001 10/05/2020 MONITOR STAND/POST ITS 010-40.3100.540000 36.97 OFFICE DEPOT 128312983001 10/05/2020 MONITOR STAND/POST ITS 010-40.3100.580000 20.46 BAKER MECHANICAL, INC. 186339 10/09/2020 MAINTENANCE AGREEMENT 010-40.3100.400000 3,011.75 KONICA MINOLTA BUSINESS 268537644 09/28/2020 PRINTER 010-40.3100.880000 4,975.00 DELTA DENTAL 33075000200202011 11/01/2020 NOV'20 DENTAL INSURANCE 010-40.3100.100000 484.58 INGRAM LIBRARY SERVICES 48663598 10/O1/2020 BOOKS 010-40.3100.590000 1.39 INGRAM LIBRARY SERVICES 48663598 10/O1/2020 BOOKS 010-40.3100.640000 31.17 INGRAM LIBRARY SERVICES 48681964 10/02/2020 BOOKS 010-40.3100.460300 64.15 INGRAM LIBRARY SERVICES 48683955 10/02/2020 BOOKS 010-40.3100.590000 10.34 INGRAM LIBRARY SERVICES 48683955 10/02/2020 BOOKS 010-40.3100.640000 118.09 INGRAM LIBRARY SERVICES 48736349 10/06/2020 BOOKS 010-40.3100.590000 26.84 INGRAM LIBRARY SERVICES 48736349 10/06/2020 BOOKS 010-40.3100.640000 306.45 INGRAM LIBRARY SERVICES 48736350 10/06/2020 BOOKS 010-40.3100.590000 20.98 INGRAM LIBRARY SERVICES 48736350 10/06/2020 BOOKS 010-40.3100.640000 171.56 INGRAM LIBRARY SERVICES 48758093 10/07/2020 BOOKS 010-40.3100.590000 4.51 INGRAM LIBRARY SERVICES 48758093 10/07/2020 BOOKS 010-40.3100.640000 60.80 INGRAM LIBRARY SERVICES 48758094 10/07/2020 BOOKS 010-40.3100.590000 8.66 INGRAM LIBRARY SERVICES 48758094 10/07/2020 BOOKS 010-40.3100.640000 58.11 INGRAM LIBRARY SERVICES 48766858 10/08/2020 BOOKS 010-40.3100.460300 59.15 INGRAM LIBRARY SERVICES 48780793 10/08/2020 BOOKS 010-40.3100.590000 5.54 INGRAM LIBRARY SERVICES 48780793 10/08/2020 BOOKS 010-40.3100.640000 46.41 INGRAM LIBRARY SERVICES 48780794 10/08/2020 BOOKS 010-40.3100.590000 19.34 INGRAM LIBRARY SERVICES 48780794 10/08/2020 BOOKS 010-40.3100.640000 141.68 INGRAM LIBRARY SERVICES 48811603 10/11/2020 BOOKS 010-40.3100.590000 17.87 INGRAM LIBRARY SERVICES 48811603 10/11/2020 BOOKS 010-40.3100.640000 241.10 INGRAM LIBRARY SERVICES 48854120 10/13/2020 BOOKS 010-40.3100.590000 2.24 INGRAM LIBRARY SERVICES 48854120 10/13/2020 BOOKS 010-40.3100.640000 13.97 INGRAM LIBRARY SERVICES 48854121 10/13/2020 BOOKS 010-40.3100.590000 4.96 INGRAM LIBRARY SERVICES 48854121 10/13/2020 BOOKS 010-40.3100.640000 80.83 INGRAM LIBRARY SERVICES 48854122 10/13/2020 BOOKS 010-40.3100.590000 13.78 INGRAM LIBRARY SERVICES 48854122 10/13/2020 BOOKS 010-40.3100.640000 97.09 MID AMERICAN ENERGY 505035783 10/15/2020 OCTOBER 2020 STATEMENT 010-40.3100.480000 1,300.08 HOLMES MURPHY 563350 11/O1/2020 NOV'20 HMA MONTHLY CO 010-40.3100.100000 225.45 MERRITT COMPANY INC 58656 10/20/2020 CLEANING SERVICES - LIBRAR 010-40.3100.400100 520.00 THE LIBRARY CORPORATION 65313 10/15/2020 2020 TLCU VIRTUAL CONFER 010-40.3100.470000 299.00 DEMCO INC. 6858462 10/14/2020 LABEL PROTECTORS/BOOKM 010-40.3100.590000 146.18 AUDIOVISUAL INC 88702317 10/15/2020 REPLACEMENT LAMP 010-40.3100.400000 905.38 SHI INTERNATIONAL CORP B12286597 09/15/2020 LENOVOTHINKCENTRES 010-40.3100.540000 5,731.00 SHI INTERNATIONAL CORP 812296211 09/17/2020 LENOVOTHINKCENTRES 010-40.3100.540000 2,167.00 SHI INTERNATIONAL CORP B12331225 09/24/2020 LIBRARY PATRON NETWORK 010-40.3100.270000 135.00 SHI INTERNATIONAL CORP B12331225 09/24/2020 LIBRARY PATRON NETWORK 010-40.3100.540000 281.00 AMAZON CREDIT PLAN INV0010186 10/10/2020 GLUE/PAINT 010-40.3100.460300 72.86 AMAZON CREDIT PLAN INV0010186 10/10/2020 HOLE PUNCHER 010-40.3100.460300 9.99 AMAZON CREDIT PLAN INV0010186 10/10/2020 PAINT BRUSHES/CRAFT LEAV 010-40.3100.460300 41.57 AMAZON CREDIT PLAN INV0010186 10/10/2020 BUILDING BLOCKS/MAGNETI 010-40.3100.460300 262.62 AMAZON CREDIT PLAN INV0010186 10/10/2020 JUICE 010-40.3100.460300 39.47 AMAZON CREDIT PLAN INV0010186 10/10/2020 WHITEBOARDS 010-40.3100.540000 157.60 AMAZON CREDIT PLAN INV0010186 10/10/2020 COVID CROWD CONTROL 010-40.3100.540000 101.66 AMAZON CREDIT PLAN INV0010186 10/10/2020 END PANEL SIGNS 010-40.3100.540000 416.01 AMAZON CREDIT PLAN INV0010186 10/10/2020 USE; CABLE 010-40.3100.540000 58.88 AMAZON CREDIT PLAN INV0010186 10/10/2020 SANITIZING STAND 010-40.3100.540000 392.28 AMAZON CREDIT PLAN INV0010186 10/10/2020 CUTTING MAT/VINYL 010-40.3100.540000 399.00 AMAZON CREDIT PLAN INV0010186 10/10/2020 COVID SUPPLIES 010-40.3100.590000 175.14 AMAZON CREDIT PLAN INV0010186 10/10/2020 MOUNTING TAPE 010-40.3100.590000 206.70 10/28/2020 2:24:25 PM - �,��a�. Expense Approval Register Packet: APPKT02061 - NOVEMBER 3RD COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount AMAZON CREDIT PLAN INVO010186 10/10/2020 SWIFFER DUSTER 010-40.3100.590000 33.52 AMAZON CREDIT PLAN INVO010186 10/10/2020 COVID SUPPLIES 010-40.3100.590000 49.05 AMAZON CREDIT PLAN INVO010186 10/10/2020 MOUNTING TAPE 010-40.3100.590000 106.65 AMAZON CREDIT PLAN INVO010186 10/10/2020 COVID SUPPLIES 010-40.3100.590000 40.90 AMAZON CREDIT PLAN INV0010186 10/10/2020 COVID SIGN 010-40.3100.590000 80.61 AMAZON CREDIT PLAN INVO010186 10/10/2020 CUTTING MAT/VINYL 010-40.3100.590000 80.98 Department 3100 - LIBRARY SERVICES Total: 25,662.61 Department: 4100 - PARKS D & K PRODUCTS INC. 0518265-IN 10/09/2020 DOG PARK TURF REPAIR 010-40.4100.410310 235.00 VAN -WALL EQUIPMENT INC 10262719 10/16/2020 JOHN DEERE 1600 MOWER 010-40.4100.410100 247.11 IOWA NATIVE TREES AND SH 1128 09/30/2020 WAUKEE CANOPY 010-40.4100.460101 11,896.00 TRUGREEN 129916102 09/30/2020 TRIANGLE PARK 010-40.4100.590100 37.85 GENUS LANDSCAPE ARCHITE 19074-9 10/09/2020 GLYNN VILLAGE PARK 327-90.4100.880078 7,639.00 A & W ELECTRIC INC 32276 10/08/2020 BALL FIELD LIGHTS 010-40.4100.410300 363.45 A & W ELECTRIC INC 32277 10/08/2020 CENTENNIAL PARK ELECTRIC 010-40.4100.410300 271.67 DELTA DENTAL 33075000200202011 11/01/2020 NOV'20 DENTAL INSURANCE 010-40.4100.100000 159.04 DELTA DENTAL 33075000200202011 11/01/2020 NOV'20 DENTAL INSURANCE 010-40.4100.100000 32.78 DELTA DENTAL 33075000200202011 11/O1/2020 NOV'20 DENTAL INSURANCE 010-40.4100.100000 25.25 DOG WASTE DEPOT 370578 10/12/2020 DOG PARK WASTE BAGS & C 010-40.4100.590010 174.22 BDI SIGNS BUSINESS DESIGN 41444 10/10/2020 TRIUMPH DECALS 010-40.4100.590000 25.00 MID AMERICAN ENERGY 504632242 10/05/2020 OCTOBER 2020 STATEMENT 010-40.4100.480000 28.35 MID AMERICAN ENERGY 505005352 10/15/2020 OCTOBER 2020 STATEMENT 010-40.4100.480000 12.56 MID AMERICAN ENERGY 505010735 10/15/2020 OCTOBER 2020 STATEMENT 010-40.4100.480000 320.56 MID AMERICAN ENERGY 505015953 10/15/2020 OCTOBER 2020 STATEMENT 010-40.4100.480000 78.51 MID AMERICAN ENERGY 505054939 10/15/2020 OCTOBER 2020 STATEMENT 010-40.4100.480010 28.34 MID AMERICAN ENERGY 505174270 10/20/2020 OCTOBER 2020 STATEMENT 010-40.4100.480000 5.26 HOLMES MURPHY 563350 11/01/2020 NOV'20 HMA MONTHLY CO 010-40.4100.100000 17.19 HOLMES MURPHY 563350 11/01/2020 NOV'20 HMA MONTHLY CO 010-40.4100.100000 60.66 HOLMES MURPHY 563350 11/01/2020 NOV'20 HMA MONTHLY CO 010-40.4100.100000 8.69 HILLYARD INC 604092716 10/13/2020 SOAP 010-40.4100.590000 111.82 MULCH MART 61645 10/08/2020 MULCH 010-40.4100,590011 102.68 PLUMB SUPPLY COMPANY 6915611 10/07/2020 TOILET REPAIR 010-40.4100.410300 336.25 MENARDS 94579 10/15/2020 PT 2X GLOSS BLACK 010-40.4300.590000 3.96 DAVIS EQUIPMENT CORPOR WI15033 10/05/2020 BALL FIELD IRRIGATION 010-40.4100.410300 231.02 Department 4100 - PARKS Total: 22,452.22 Department: 4200 - RECREATION FAREWAY STORES, INC. 00096333 09/25/2020 PAINT A PUMPKIN 010-40.4200.461400 119.70 DELTA DENTAL 33075000200202011 11/01/2020 NOV'20 DENTAL INSURANCE 010-40.4200.100000 318.08 HOLMES MURPHY 563350 11/01/2020 NOV'20 HMA MONTHLY CO 010-40.4200.100000 121.32 SHI INTERNATIONAL CORP B12286623 09/15/2020 LENOVOTHINKCENTRE 010-40.4200.540000 521.00 DINNER DELIGHTS INVO010184 10/11/2020 FREEZER MEAL WORKSHOP 010-40.4200.460550 1,144.00 Department 4200 - RECREATION Total: 2,224.10 Department: 4300 - COMMUNITY CENTER ORKIN PEST CONTROL 203161276 10/19/2020 PEST CONTROL -COMMUNIT 010-40.4300.400000 59.02 MEDIACOM 83849302700901181020 10/07/2020 OCTOBER 2020 STATEMENT 010-40.4300.450000 123.08 Department 4300 - COMMUNITY CENTER Total: 182.10 Department: 5300 - STORM WATER DELTA DENTAL 33075000200202011 11/01/2020 NOV'20 DENTAL INSURANCE 560-80.5300.100000 16.39 DELTA DENTAL 33075000200202011 11/01/2020 NOV'20 DENTAL INSURANCE 560-80.5300.100000 159.04 KENNY & GYL COMPANY 53342 10/02/2020 DOOR SHEILDS 560-80.5300.790000 175.00 HOLMES MURPHY 563350 11/01/2020 NOV'20 HMA MONTHLY CO 560-80.5300.100000 8.60 HOLMES MURPHY 563350 11/01/2020 NOV'20 HMA MONTHLY CO 560-80.5300.100000 60.66 PAT GENEREUX INVO010192 11/03/2020 RAIN BARREL REIMBURSEME 560-80.5300.685400 50.00 BEN GALLOPS INVO010194 11/03/2020 RAIN GARDEN REIMBURSEM 560-80.5300.685410 254.88 GREG JENSEN INV0010195 11/03/2020 SOIL QUALITY REIMBURSEM 560-80.5300.685410 1,000.00 PRAMOD REDDY NARAMRED INVO010198 11/03/2020 STORMWATER QUALITY REI 560-80.5300.685410 2,205.95 SHIVON PUSHPAN INVO010202 11/03/2020 SOIL QUALITY REIMBURSEM 560-80.5300.685410 236.75 TRANS-IOWA EQUIPMENT P11474 10/13/2020 RAMBO NOZZ/PARTS 560-80.5300.540000 1,002.95 Department 5300 - STORM WATER Total: 5,170.22 Page 4 of 13 10/28/2020 2:24:25 PM Expense Approval Register Packet: APPKT02061- NOVEMBER 3RD COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount Department: 6000 - PUBLIC WORKS DELTA DENTAL 33075000200202011 11/01/2020 NOV'20 DENTAL INSURANCE 010-20.6000.100000 512.50 HOLMES MURPHY 563350 11/01/2020 NOV'20 HMA MONTHLY CO 010-20.6000.100000 217.35 Department 6000 - PUBLIC WORKS Total: 729.85 Department: 6010 - PUBLIC WORKS BUILDING MID AMERICAN ENERGY 505001413 10/15/2020 OCTOBER 2020 STATEMENT 010-20.6010.480000 1,379.21 DTN, LLC 5828154 10/02/2020 WEATHER CENTER FEES 010-20.6010.400000 4,200.00 HILLYARD INC 604092717 10/13/2020 SOAP 010-20.6010.590000 115.09 STAPLES BUSINESS CREDIT 7309591874-0-1 07/06/2020 COPY PAPER 010-20.6010.580000 84.98 STAPLES BUSINESS CREDIT 7309637403-1-1 07/16/2020 CREDIT- PENS 010-20.6010.580000 -2.01 STAPLES BUSINESS CREDIT 7312885791-0-2 08/31/2020 LAMINATING POUCHES 010-20.6010.580000 62.09 STAPLES BUSINESS CREDIT 7312887205-0-1 08/28/2020 REINFORCEMENTS 010-20.6010.590000 4.03 STAPLES BUSINESS CREDIT 7313446492-0-1 09/08/2020 TAPE/PENS/WRIST WREST 010-20.6010.580000 71.01 STAPLES BUSINESS CREDIT 7321885791-0-1 08/28/2020 PAPE R/CALCU LATOR/CALEN 010-20.6010.580000 54.13 ANKENY SANITATION INC. 879757 09/30/2020 30 YD ROLL OFF 010-20.6010.510100 270.40 CINTAS CORPORATION 9104584150 10/01/2020 WATER COOLER AGREEMENT 010-20.6010.400000 50.00 HEARTLAND CO-OP INVO010213 09/30/2020 SEPTEMBER 2020 STATEMEN 010-20.6010.590000 20.09 AT&T MOBILITY X10082020 09/30/2020 OCTOBER 2020 STATEMENT 010-20.6010.450000 113.66 Department 6010 - PUBLIC WORKS BUILDING Total: 6,422.68 Department: 6150 - PUBLIC WORKS MECHANIC MARK STUCHEL INC. 10092086654 10/09/2020 HAND TOOLS 010-20.6150.590000 215.00 MARK STUCHEL INC. 10162086904 10/16/2020 TRACK CODE 010-20.6150.590000 0.01 HAWKEYE TRUCK EQUIPMEN 143986 10/08/2020 150 AMP CIRCUT BREAKER/S 010-20.6150.570130 121.00 AMAZON.COM iL7L-R6KN-7GXP 10/17/2020 OIL DRAIN VALVE 010-20.6150.570130 68.19 AMAZON.COM 1NKN-D69N-YN9Y 10/03/2020 OIL DRAIN VALVE 010-20.6150.570130 144.90 ARNOLD MOTOR SUPPLY 21NVO46565 10/06/2020 GLUE 010-20.6150.590000 7.19 ARNOLD MOTOR SUPPLY 21NVO46578 10/06/2020 GRINDING DISKS 010-20.6150.590000 64.75 ARNOLD MOTOR SUPPLY 21NVO46612 10/06/2020 GLUE 010-20.6150.590000 7.19 ARNOLD MOTOR SUPPLY 21NVO46614 10/06/2020 ROLOC SURF COND DISC 010-20.6150.590000 64.75 ARNOLD MOTOR SUPPLY 21NVO46786 10/02/2020 MASKING TAPE 010-20.6150.590000 30.96 MATHESON TRI-GAS INC 22443932 10/12/2020 CYLINDERS 010-20.6150.590000 250.81 O'HALLORAN INTERNATIONA 31P89765 10/03/2020 OIL PAN/FLANGE 010-20.6150.570130 792.60 O'HALLORAN INTERNATIONA 31P90227 10/07/2020 FILTERS 010-20.6150.570110 206.80 O'HALLORAN INTERNATIONA 311390229 10/07/2020 FILTERS 010-20.6150.570110 206.80 DELTA DENTAL 33075000200202011 11/01/2020 NOV'20 DENTAL INSURANCE 010-20.6150.100000 193.12 ADEL AUTO PARTS 418968 10/01/2020 HALOGEN SEALED BEAMS 010-20.6150.570130 37.47 ADEL AUTO PARTS 419042 10/02/2020 KWIK WELD 010-20.6150.590000 6.99 ADEL AUTO PARTS 419187 10/06/2020 BATTERY 010-20.6150.570130 79.38 ADEL AUTO PARTS 419211 10/07/2020 BATTERY 010-20,6150.570130 70.50 ADEL AUTO PARTS 419416 10/12/2020 LED LICENSE KIT 010-20.6150.570130 8.37 ADEL AUTO PARTS 419524 10/14/2020 OIL FILTERS 010-20.6150.570110 229.31 ADEL AUTO PARTS 419554 10/14/2020 GREASE GUN/FLOOR DRY 010-20.6150.570130 22.49 ADEL AUTO PARTS 419554 10/14/2020 GREASE GUN/FLOOR DRY 010-20.6150.590000 52.26 HOLMES MURPHY 563350 11/01/2020 NOV'20 HMA MONTHLY CO 010-20.6150.100000 86.94 BAX SALES, INC 59163 10/07/2020 PERMATEX DIELECTRIC TUNE 010-20.6150.590000 35.12 BAX SALES, INC 59260 10/14/2020 FLAT WASHERS 010-20.6150.590000 5.82 ELECTRICAL ENGINEERING E 6887323-00 09/24/2020 LAMPS/BALLAST 010-20.6150.570130 517.72 TERMINAL SUPPLY CO. 73828-00 09/30/2020 WORKLAMPS/TUBING 010-20.6150.570130 461.72 TERMINAL SUPPLY CO. 73828-00 09/30/2020 WORKLAMPS/TUBING 010-20.6150.590000 122.80 TERMINAL SUPPLY CO. 75407-00 10/07/2020 SWITCH ES/WORKLAM PS 010-20.6150.570130 524.13 TERMINAL SUPPLY CO. 75407-00 10/07/2020 SWITCH ES/WORKLAM PS 010-20.6150.590000 57.03 GRAINGER PARTS 9659276191 09/21/2020 E-STOP PUSH BUTTON 010-20.6150.570130 44.98 WAUKEE HARDWARE & VARI INVO010216 09/30/2020 SEPTEMBER 2020 STATEMEN 010-20.6150.590000 23.47 Department 6150 - PUBLIC WORKS MECHANIC Total: 4,760.57 Department: 6500 - MEDIAN & BLDG GROUNDS # 1 LAWN CARE AND LANDS 1001111 10/20/2020 MEDIAN MAINTENANCE 010-50.6500.340000 6,400.00 MID AMERICAN ENERGY 505010164 10/15/2020 OCTOBER 2020 STATEMENT 010-50.6500.480050 614.85 Department 6500 - MEDIAN & BLDG GROUNDS Total: 7,014.85 10/28/2020 2:24:25 PM Expense Approval Register Packet: APPKT02061 - NOVEMBER 3RD COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount Department: 6510 - WATER UTILITY MUNICIPAL SUPPLY INC. 0777906-IN 10/09/2020 METERS 510-30.6510.592000 1,506.04 UNIVERSITY OF IOWA HYGIE 196579 09/30/2020 SEPTEMBER 2020 STATEMEN 510-30.6510.250000 260.00 IOWA ONE CALL 225644 10/16/2020 SEPTEMBER 2020 STATEMEN 510-30.6510.340000 493.60 DELTA DENTAL 33075000200202011 11/O1/2020 NOV'20 DENTAL INSURANCE 510-30.6510.100000 63.13 DELTA DENTAL 33075000200202011 11/O1/2020 NOV'20 DENTAL INSURANCE 510-30.6510.100000 242.29 DELTA DENTAL 33075000200202011 11/01/2020 NOV'20 DENTAL INSURANCE 510-30.6510.100000 66.86 DELTA DENTAL 33075000200202011 11/O1/2020 NOV'20 DENTAL INSURANCE 510-30.6510.100000 16.39 MID AMERICAN ENERGY 505006137 10/15/2020 OCTOBER 2020 STATEMENT 510-30.6510.480000 5.22 MID AMERICAN ENERGY 505073049 10/16/2020 OCTOBER 2020 STATEMENT 510-30.6510.480000 13.73 HOLMES MURPHY 563350 11/O1/2020 NOV'20 HMA MONTHLY CO 510-30.6510.100000 112.73 HOLMES MURPHY 563350 11/O1/2020 NOV'20 HMA MONTHLY CO 510-30.6510.100000 43.47 HOLMES MURPHY 563350 11/O1/2020 NOV'20 HMA MONTHLY CO 510-30.6510.100000 21.73 HOLMES MURPHY 563350 11/O1/2020 NOV'20 HMA MONTHLY CO 510-30.6510.100000 8.60 SH I INTERNATIONAL CORP B12272348 09/11/2020 LENOVOTHINKCENTRES/MO 510-30.6510.540000 717.93 WEST DES MOINES WATER INV0010181 11/03/2020 NOVEMBER 2020 WATER TO 510-30.6510.390300 419.18 WAUKEE HARDWARE & VARI INV0010216 09/30/2020 SEPTEMBER 2020 STATEMEN 510-30.6510.590000 159.48 CORE & MAIN LP N080764 10/06/2020 1OX24 METER PIT EXT 510-30.6510.592000 372.91 Department 6510 - WATER UTILITY Total: 4,523.29 Department: 6520 - SANITARY SEWERS & TREATMENT WASTEWATER RECLAMATIO 117062 11/03/2020 NOVEMBER 2020 FEES 520-30.6520.650010 46,078.80 WASTEWATER RECLAMATIO 117062 11/03/2020 NOVEMBER 2020 FEES 520-30.6520.882700 74,829.40 DELTA DENTAL 33075000200202011 11/O1/2020 NOV'20 DENTAL INSURANCE 520-30.6520.100000 16.39 DELTA DENTAL 33075000200202011 11/O1/2020 NOV'20 DENTAL INSURANCE 520-30.6520.100000 63.13 DELTA DENTAL 33075000200202011 11/O1/2020 NOV'20 DENTAL INSURANCE 520-30.6520.100000 242.29 MID AMERICAN ENERGY 505026664 10/15/2020 OCTOBER 2020 STATEMENT 520-30.6520.480000 31.41 MID AMERICAN ENERGY 505033416 10/15/2020 OCTOBER 2020 STATEMENT 520-30.6520.480000 213.63 KENNY & GYL COMPANY 53342 10/02/2020 DOOR SHEILDS 520-30.6520.790000 175.00 HOLMES MURPHY 563350 11/O1/2020 NOV'20 HMA MONTHLY CO 520-30.6520.100000 21.73 HOLMES MURPHY 563350 11/01/2020 NOV'20 HMA MONTHLY CO 520-30.6520.100000 112.73 HOLMES MURPHY 563350 11/O1/2020 NOV'20 HMA MONTHLY CO 520-30.6520.100000 8.59 MID AMERICAN ENERGY 62300-04049 10/16/2020 OCTOBER 2020 STATEMENT 520-30.6520.480000 440.15 HEARTLAND CO-OP INV0010214 09/30/2020 SEPTEMBER 2020 STATEMEN 520-30.6520.570000 136.72 WAUKEE HARDWARE & VARI INV0010216 09/30/2020 SEPTEMBER 2020 STATEMEN 520-30.6520.590000 27.40 WAUKEE HARDWARE & VARI INV0010216 09/30/2020 SEPTEMBER 2020 STATEMEN 520-30.6520.590000 51.16 TRANS-IOWA EQUIPMENT P11474 10/13/2020 RAMBO NOZZ/PARTS 520-30.6520.540000 1,002.95 Department 6520 - SANITARY SEWERS & TREATMENT Total: 123,451.48 Department: 6540 - GAS UTILITY TT TECHNOLOGIES, INC 0217205 10/08/2020 OIL 540-30.6540.590000 196.05 INDUSTRIAL SALES COMPAN 1079029-000 10/06/2020 DRISCO 6500 IPS 540-30.6540.590100 9,471.54 INDUSTRIAL SALES COMPAN 1079030-000 10/08/2020 DRISCO 6500 IPS/CTS 540-30.6540.590100 12,189.55 REGAL UNDERGROUND CON 1493 10/09/2020 DIRECTIONAL BORE GAS 540-30.6540.880100 2,370.00 IOWA ONE CALL 225644 10/16/2020 SEPTEMBER 2020 STATEMEN 540-30.6540.340000 493.60 INFRASOURCE CONSTRUCTI 3059959 10/12/2020 NW LOTH ST NEW SCHOOL/K 540-30.6540.880100 22,410.95 DELTA DENTAL 33075000200202011 11/O1/2020 NOV'20 DENTAL INSURANCE 540-30.6540.100000 453.90 DELTA DENTAL 33075000200202011 11/O1/2020 NOV'20 DENTAL INSURANCE 540-30.6540.100000 16.39 DELTA DENTAL 33075000200202011 11/O1/2020 NOV'20 DENTAL INSURANCE 540-30.6540.100000 63.13 NORTHERN TOOL & EQUIPM 46096966 10/O1/2020 PORTABLE GENERATOR 540-30.6540.540000 1,999.99 MID AMERICAN ENERGY 505006137 10/15/2020 OCTOBER 2020 STATEMENT 540-30.6540.480000 5.21 MID AMERICAN ENERGY 505073049 10/16/2020 OCTOBER 2020 STATEMENT 540-30.6540.480000 13.73 HOLMES MURPHY 563350 11/O1/2020 NOV'20 HMA MONTHLY CO 540-30.6540.100000 173.88 HOLMES MURPHY 563350 11/O1/2020 NOV'20 HMA MONTHLY CO 540-30.6540.100000 21.73 HOLMES MURPHY 563350 11/O1/2020 NOV'20 HMA MONTHLY CO 540-30.6540.100000 8.59 GROEBNER & ASSOCIATES IN 600448-01 10/07/2020 METERS 540-30.6540.592000 92,752.10 MUELLER CO. LLC 65010765 07/O1/2020 RUBBER STOPPER 540-30.6540.880100 106.53 MUELLER CO. LLC 65036197 07/O1/2020 8" LINE STOPPER FITTING 540-30.6540.880100 6,854.81 SHI INTERNATIONAL CORP B12272348 09/11/2020 LENOVOTHINKCENTRES/MO 540-30.6540.540000 717.93 UTILITY SAFETY AND DESIGN IN20203331 08/31/2020 DESIGN SERVICES/METER PA 540-30.6540.230000 6,535.00 UTILITY SAFETY AND DESIGN IN20203331 08/31/2020 DESIGN SERVICES/METER PA 540-30.6540.592000 3,463.32 WEST DES MOINES WATER INV0010181 11/03/2020 NOVEMBER 2020 WATER TO 540-30.6540.390300 419.17 Expense Approval Register Packet: APPKT02061- NOVEMBER 3RD COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount KENTANDERSON INV0010187 11/03/2020 FURNACE REBATE 540-30.6540.685400 75.00 KEVIN AND SHARI BUTLER INV0010188 11/03/2020 FURNACE REBATE 540-30.6540.685400 150.00 ANNIE CARSTENS INV0010189 11/03/2020 FURNACE REBATE 540-30.6540.685400 75.00 JOSHUACONLEY INV0010190 11/03/2020 THERMOSTAT REBATE 540-30.6540.685400 30.00 CARRIE EMBREE INV0010191 11/03/2020 FURNACE & THERMOSTAT RE 540-30.6540.685400 180.00 DWIGHTGAINES INV0010193 11/03/2020 WATER HEATER REBATE 540-30.6540.685400 50.00 KAMAL MACHAREKA INV0010196 11/03/2020 FURNACE REBATE 540-30.6540.685400 150.00 JUSTIN MCKEEVER INV0010197 11/03/2020 FURNACE REBATE 540-30.6540.685400 75.00 GREGORY PACKNETT INV0010199 11/03/2020 FURNACE REBATE 540-30.6540.685400 150.00 ARLEN PENCE INV0010200 11/03/2020 FURNACE REBATE 540-30.6540.685400 75.00 STEVE PETERSON INV0010201 11/03/2020 FURNACE REBATE 540-30.6540.685400 150.00 SCHAAL PLUMBING, HEATIN INV0010203 11/03/2020 635 7TH ST WAUKEE 540-30.6540.685400 150.00 SCHAAL PLUMBING, HEATIN INV0010204 11/03/2020 655 SE PRAIRIE PARK LANE 540-30.6540.685400 105.00 SCHAAL PLUMBING, HEATIN INV0010205 11/03/2020 855 SE MAPLELEAFE LANE 540-30.6540.685400 150.00 HARLAN THOMPSON INV0010206 11/03/2020 FURNACE & THERMOSTAT RE 540-30.6540.685400 105.00 BLACK HILLS ENERGY INV0010207 10/06/2020 OCTOBER 2020 STATEMENT 540-30.6540.650000 2,891.25 WAUKEE HARDWARE & VARI INV0010216 09/30/2020 SEPTEMBER 2020 STATEMEN 540-30.6540.590000 167.44 STUART C IRBY CO 5012009686.003 10/02/2020 RISER 540-30.6540.590200 1,787.50 Department 6540 - GAS UTILITY Total: 167,253.29 Department: 6550 - UTILITY BILLING TYLER TECHNOLOGIES INC 025-310903 10/O1/2020 CIS/CRM ANNUAL FEES 570-30.6550.270000 3,573.59 TYLER TECHNOLOGIES INC 025-313144 11/O1/2020 CIS/CRM FEES 570-30.6550.270000 175.00 DELTA DENTAL 33075000200202011 11/O1/2020 NOV'20 DENTAL INSURANCE 570-30.6550.100000 99.64 HOLMES MURPHY 563350 11/01/2020 NOV'20 HMA MONTHLY CO 570-30.6550.100000 60.66 STAPLES BUSINESS CREDIT 7313774307-0-1 09/14/2020 FILE FOLDERS 570-30.6550.580000 104.97 STAPLES BUSINESS CREDIT 7314070035-0-1 09/16/2020 SHOULDER REST/PAPER PLAT 570-30.6550.580000 8.99 LANDS END BUSINESS OUTFI SIN8679597 10/07/2020 AUTUMN SHIRTS - CITY HALL 570-30.6550.120000 132.73 Department 6550 - UTILITY BILLING Total: 4,155.58 Department: 7100 - STREETS ARDICK EQUIPMENT CO., IN 1431 10/08/2020 CURVE ROAD SIGNS 060-30.7100.590600 124.00 LIBERTY READY MIX 159695 10/O1/2020 CONCRETE 060-30.7100.590400 1,541.00 LIBERTY READY MIX 159889 10/05/2020 CONCRETE 060-30.7100.590400 1,407.00 LIBERTY READY MIX 159981 10/06/2020 CONCRETE 060-30.7100.590400 2,071.00 LIBERTY READY MIX 160086 10/07/2020 CONCRETE 060-30.7100.590400 1,407.00 LIBERTY READY MIX 160174 10/08/2020 CONCRETE 060-30.7100.590400 871.00 MARTIN MARIETTA AGGREG 30054138 09/30/2020 ROAD STONE 060-30.7100.590300 886.41 MARTIN MARIETTA AGGREG 30081090 10/05/2020 ROAD STONE 060-30.7100.590300 290.87 DELTA DENTAL 33075000200202011 11/O1/2020 NOV'20 DENTAL INSURANCE 060-30.7100.100000 453.90 DELTA DENTAL 33075000200202011 11/O1/2020 NOV'20 DENTAL INSURANCE 060-30.7100.100000 63.13 DELTA DENTAL 33075000200202011 11/O1/2020 NOV'20 DENTAL INSURANCE 060-30.7100.100000 12.63 HOLMES MURPHY 563350 11/01/2020 NOV'20 HMA MONTHLY CO 060-30.7100.100000 173.88 HOLMES MURPHY 563350 11/O1/2020 NOV'20 HMA MONTHLY CO 060-30.7100.100000 21.74 HOLMES MURPHY 563350 11/O1/2020 NOV'20 HMA MONTHLY CO 060-30.7100.100000 4.35 IOWA DEPT OF TRANSPORTA 64114 10/06/2020 BLADE GRADER 060-30.7100.590000 1,890.30 SHI INTERNATIONAL CORP 812272348 09/11/2020 LENOVOTHINKCENTRES/MO 060-30.7100.540000 718.14 H EARTLAN D CO-OP INV0010215 09/30/2020 SEPTEMBER 2020 STATEMEN 060-30.7100.570000 11.63 HEARTLAND CO-OP INV0010215 09/30/2020 SEPTEMBER 2020 STATEMEN 060-30.7100.590000 145.50 WAUKEE HARDWARE & VARI INV0010216 09/30/2020 SEPTEMBER 2020 STATEMEN 060-30.7100.590000 25.49 LOGAN CONTRACTORS SUPP P89744 10/08/2020 SEALANT 060-30.7100.590400 2,157.82 Department 7100 - STREETS Total: 14,276.79 Department: 7200 - NORTH HIGH SCHOOL ROAD SYSTEM FOTH INFRASTRUCTURE & E 69332 10/15/2020 NW SUNRISE DRIVE & RACC 327-90.7200.235010 280.00 Department 7200 - NORTH HIGH SCHOOL ROAD SYSTEM Total: 280.00 Department: 8100 - MAYOR & COUNCIL WAUKEE LEADERSHIP INSTIT INV0010177 09/O1/2020 2020 CLASS ENROLLMENT FE 010-60.8100.470000 350.00 LANDS END BUSINESS OUTFI SIN8679597 10/07/2020 AUTUMN SHIRTS- CITY HALL 010-60.8100.120000 171.75 Department 8100 - MAYOR & COUNCIL Total: 521.75 Department: 8200 - COMMUNICATIONS CIVIC PLUS 204170 11/O1/2020 ANNUAL WEBSITE FEES 010-60.8200.230010 6,036.91 10/28/2020 2:24:25 PM I '; I J Expense Approval Register Packet: APPKT02061- NOVEMBER 3RD COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount DELTA DENTAL 33075000200202011 11/O1/2020 NOV'20 DENTAL INSURANCE 010-60.8200.100000 159.04 LIVING MAGAZINES 396268 09/O1/2020 SEPTEMBER 2020 WAUKEE LI 010-60.8200.461200 1,521.00 HOLMES MURPHY 563350 11/01/2020 NOV'20 HMA MONTHLY CO 010-60.8200.100000 60.66 LANDS END BUSINESS OUTFI SIN8679597 10/07/2020 AUTUMN SHIRTS - CITY HALL 010-60.8200.120000 41.91 Department 8200 - COMMUNICATIONS Total: 7,819.52 Department: 8300 - ADMINISTRATION REGISTER MEDIA 0003529218 09/30/2020 SEPTEMBER 2020 PUBLICATI 010-60.8300.210000 146.69 DELTA DENTAL 33075000200202011 11/O1/2020 NOV'20 DENTAL INSURANCE 010-60.8300.100000 193.12 CARNEY & APPLEBY, P.L.C. 36510 10/12/2020 2020 LEGISLATIVE/LOBBYING 010-60.8300.230000 5,500.00 MID AMERICAN ENERGY 505023378 10/15/2020 OCTOBER 2020 STATEMENT 010-60.8300.390400 9.06 MID AMERICAN ENERGY 505035096 10/15/2020 OCTOBER 2020 STATEMENT 010-60.8300.390400 9.97 MID AMERICAN ENERGY 505035200 10/15/2020 OCTOBER 2020 STATEMENT 010-60.8300.390400 78.29 MID AMERICAN ENERGY 505035333 10/15/2020 OCTOBER 2020 STATEMENT 010-60.8300.390400 12.48 HOLMES MURPHY 563350 11/O1/2020 NOV'20 HMA MONTHLY CO 010-60.8300.100000 86.94 STAPLES BUSINESS CREDIT 7312715652-0-1 08/26/2020 PAPER 010-60.8300.580000 59.75 STAPLES BUSINESS CREDIT 7313596802-0-1 10/20/2020 ENVELOPES 010-60.8300.580000 85.08 STAPLES BUSINESS CREDIT 7314070035-0-1 09/16/2020 SHOULDER REST/PAPER PLAT 010-60.8300.580000 24.60 STAPLES BUSINESS CREDIT 7315013251-0-1 09/30/2020 COPY PAPER 010-60.8300.580000 61.79 MEDIACOM 83849302700901181020 10/07/2020 OCTOBER 2020 STATEMENT 010-60.8300.270000 13.67 MENARDS 94166 10/09/2020 1130 S WARRIOR LANE 010-60.8300.390400 336.24 MENARDS 94167 10/09/2020 1130 S WARRIOR LANE 010-60.8300.390400 32.20 DALLAS COUNTY LOCAL HOU CE-2021-00010026 09/17/2020 FY21 CONTRIBUTION 010-60.8300.459000 4,747.68 IMAGETEK INC EW3809517 08/31/2020 RADIX SUBSCRIPTION/STORA 010-60.8300.270000 499.00 IMAGETEK INC EW3809651 09/30/2020 RADIX SUBSCRIPTION/STORA 010-60.8300.270000 499.00 CONSOLIDATED COMMUNIC INV0010108 10/01/2020 SEPTEMBER 2020 STATEMEN 010-60.8300.450000 823.57 CONSOLIDATED COMMUNIC INV0010120 09/O1/2020 SEPTEMBER 2020 STATEMEN 010-60.8300.450000 808.00 STAPLES BUSINESS CREDIT INV0010211 08/25/2020 LATE FEE 010-60.8300.280000 20.00 STAPLES BUSINESS CREDIT INV0010212 09/25/2020 LATE FEE 010-60.8300.280000 10.00 LANDS END BUSINESS OUTFI SIN8679597 10/07/2020 AUTUMN SHIRTS - CITY HALL 010-60.8300.120000 38.41 Department 8300 - ADMINISTRATION Total: 14,095.54 Department: 8310 - CITY HALL NATIONWIDE OFFICE CLEAN 105676 10/13/2020 FACIALTISSUE 010-60.8310.590000 136.10 NATIONWIDE OFFICE CLEAN 106020 10/15/2020 CLEANING SERVICES - ANNEX 010-60.8310.400100 649.50 NATIONWIDE OFFICE CLEAN 106021 10/15/2020 CLEANING SERVICES - CITY H 010-60.8310.400100 900.64 MID AMERICAN ENERGY 505022291 10/15/2020 OCTOBER 2020 STATEMENT 010-60.8310.480000 138.51 MID AMERICAN ENERGY 505029155 10/15/2020 OCTOBER 2020 STATEMENT 010-60.8310.390600 65.13 MID AMERICAN ENERGY 505056912 10/15/2020 OCTOBER 2020 STATEMENT 010-60.8310.480000 124.33 STAPLES BUSINESS CREDIT 7310149642-0-1 07/16/2020 FEBREZE 010-60.8310.590000 17.44 STAPLES BUSINESS CREDIT 7313774307-0-2 09/11/2020 CREAM/K-CUPS 010-60.8310.590000 27.98 STAPLES BUSINESS CREDIT 7314070035-0-1 09/16/2020 SHOULDER REST/PAPER PLAT 010-60.8310.590000 23.75 WALSH DOOR & SECURITY 758027 10/13/2020 CITY HALL DOOR REPAIRS 010-60.8310.400000 2,177.38 Department 8310 - CITY HALL Total: 4,260.76 Department: 8350 - HUMAN RESOURCES DELTA DENTAL 33075000200202011 11/O1/2020 NOV'20 DENTAL INSURANCE 010-60.8350.100000 252.52 HOLMES MURPHY 563350 11/O1/2020 NOV'20 HMA MONTHLY CO 010-60.8350.100000 86.94 STAPLES BUSINESS CREDIT 7315078797-0-1 10/01/2020 LEGAL/LETTER PADS 010-60.8350.580000 53.44 STAPLES BUSINESS CREDIT 7315078797-1-1 10/08/2020 CREDIT- LEGAL PAD 010-60.8350.580000 -8.05 LANDS END BUSINESS OUTFI SIN8679597 10/07/2020 AUTUMN SHIRTS - CITY HALL 010-60.8350.120000 104.82 Department 8350 - HUMAN RESOURCES Total: 489.67 Department: 8400 - FINANCIAL ADMINISTRATION GOVERNMENT FINANCE OFF 2027176 10/01/2020 MEMBERSHIP - BRUNS 11/2 010-60.8400.280000 150.00 DELTA DENTAL 33075000200202011 11/O1/2020 NOV'20 DENTAL INSURANCE 010-60.8400.100000 174.76 HOLMES MURPHY 563350 11/O1/2020 NOV'20 HMA MONTHLY CO 010-60.8400.100000 104.13 LANDS END BUSINESS OUTFI SIN8679597 10/07/2020 AUTUMN SHIRTS - CITY HALL 010-60.8400.120000 118.73 Department 8400 - FINANCIAL ADMINISTRATION Total: 547.62 Department: 8500 - COMMUNITY DEVELOPMENT COSTAR REALTY INFORMATI 112508942-1 10/04/2020 COSTAR SUITE 010-50.8500.280000 395.00 Department 8500 - COMMUNITY DEVELOPMENT Total: 395.00 10/28/2020 2:24:25 PM 8gt- !! Expense Approval Register Vendor Name Payable Number Department: 8700 - DEVELOPMENT SERVICES DELTA DENTAL 33075000200202011 HOLMES MURPHY 563350 Department: 8750 - SUGAR CREEK MUNICIPAL ORKIN PEST CONTROL 203161578 DELTA DENTAL 33075000200202011 CINTAS CORPORATION 4063741000 BUSINESS NETWORK LONG D 42253284 RDG PLANNING & DESIGN 47827 HOLMES MURPHY 563350 STAPLES BUSINESS CREDIT 7312634863-0-1 STAPLES BUSINESS CREDIT 7312634863-0-1 STAPLES BUSINESS CREDIT 7312634863-1-1 TITLEIST 909657379 CALLAWAY GOLF 932145887 IOWA DEPT OF NATURAL RES INVO010185 AHEAD LLC INV0451820 AHEAD LLC INV0453317 EPOCH EYEWEAR SO-120989 Department: 8800 - INFORMATION TECHNOLOGY AMAZON.COM 1RT4-GCP9-14H3 DELTA DENTAL 33075000200202011 HOLMES MURPHY 563350 KONICA MINOLTA BUSINESS 9007170331 KONICA MINOLTA BUSINESS 9007170332 SH I INTERNATIONAL CORP B12387072 IMAGETEK INC EW3809746 LANDS END BUSINESS OUTFI SIN8679597 Department: 8900 - ENGINEERING TRUCK EQUIPMENT INC 298120 DELTA DENTAL 33075000200202011 HOLMES MURPHY 563350 Packet: APPKT02061- NOVEMBER 3RD COUNCIL PACKET Post Date Description (Item) Account Number Amount 11/01/2020 NOV'20 DENTAL INSURANCE 010-50.8700.100000 285.30 11/01/2020 NOV'20 HMA MONTHLY CO 010-50.8700.100000 104.13 Department 8700 - DEVELOPMENT SERVICES Total: 389.43 10/19/2020 PEST CONTROL - GOLF COUR 750-80.8750.400000 81.24 11/01/2020 NOV'20 DENTAL INSURANCE 750-80.8750.100000 88.38 10/07/2020 SOAP/PAPER PRODUCTS/AIR 750-80.8750.590000 178.87 10/14/2020 OCTOBER 2020 STATEMENT 750-80.8750.450000 17.76 09/30/2020 SUGAR CREEK WATERSHED S 327-90.8750.880000 6,095.42 11/O1/2020 NOV'20 HMA MONTHLY CO 750-80.8750.100000 30.43 O8/25/2020 GARBAGE BAGS/INK/CARD S 750-80.8750.580000 135.37 08/25/2020 GARBAGE BAGS/INK/CARDS 750-80.8750.590000 147.21 09/03/2020 CREDIT - SHARPIES 750-80.8750.580000 -6.66 10/05/2020 SPECIAL ORDER SKORT AND 750-80.8750.651100 93.04 10/15/2020 PRO -SHOP MERCHANDISE 750-80.8750.651000 232.98 11/03/2020 ANNUAL WATER USE FEE 750-80.8750.280000 95.00 07/17/2020 PRO -SHOP CLOTHING 750-80.8750.651000 915.39 07/31/2020 PRO -SHOP CLOTHING 750-80.8750.651000 982.89 09/03/2020 EYE W EAR 750-80.8750.651000 103.50 Department 8750 - SUGAR CREEK MUNICIPAL Total: 9,190.82 10/15/2020 TV MOUNTS/PHONE RESTS 010-60.8800.590000 252.44 11/01/2020 NOV'20 DENTAL INSURANCE 010-60.8800.100000 191.82 11/01/2020 NOV'20 HMA MONTHLY CO 010-60.8800.100000 77.85 09/30/2020 PRINTER MAINTENANCE 010-60.8800.270110 491.11 09/30/2020 PRINTING OVERAGES 010-60.8800.270110 298.44 10/02/2020 AV EQUIPMENT UPGRADES 010-60.8800.540000 10,352.30 10/27/2020 RADIX MIGRATION 010-60.8800.740230 4,205.00 10/07/2020 AUTUMN SHIRTS - CITY HALL 010-60.8800.120000 39.11 Department 8800 - INFORMATION TECHNOLOGY Total: 15,908.07 10/08/2020 ACCESSORIES FOR 2021 CHE 010-20.8900.710000 2,958.25 11/O1/2020 NOV'20 DENTAL INSURANCE 010-20.8900.100000 258.68 11/01/2020 NOV'20 HMA MONTHLY CO 010-20.8900.100000 121.32 Department 8900 - ENGINEERING Total: 3,338.25 Department: 8950 - GIS DELTA DENTAL 33075000200202011 11/01/2020 HOLMES MURPHY 563350 11/O1/2020 NOV'20 DENTAL INSURANCE 010-20.8950.100000 32.78 NOV'20 HMA MONTHLY CO 010-20.8950.100000 17.19 Department 8950 - GIS Total: 49.97 Grand Total: 521,796.88 10/28/2020 2:24:25 PM Expense Approval Register Packet: APPKT02061- NOVEMBER 3RD COUNCIL PACKET Fund Summary Fund Expense Amount O10 - GENERAL FUND 158,726.73 060 - ROAD USE TAX FUND 17,169.80 327 - CAPITAL PROJECTS 38,251.09 510 - WATER UTILITY FUND 4,523.29 520 - WASTE WATER UTILITY FUND 123,451.48 540 - GAS UTILITY FUND 167,253.29 560 - STORM WATER UTILITY FUND 5,170.22 570 - UTILITY BILL FUND 4,155.58 750 - GOLF COURSE FUND 3,095.40 Grand Total: 521,796.88 Account Summary Account Number Account Name Expense Amount 010-10.1100.100000 HEALTH & LIFE INSURAN 3,437.75 010-10.1100.120000 UNIFORMS 1,137.82 010-10.1100.230350 SERT SHARED SERVICES 900.00 010-10.1100.400000 REPAIR/MAINTENANCE 908.38 010-10.1100.400100 CUSTODIAL 210.00 010-10.1100.410000 REPAIR OF VEHICLES 3,697.29 010-10.1100.450000 TELEPHONE 1,173.00 010-10.1100.460200 PD COMMUNITY POLICI 818.40 010-10.1100.470000 TRAINING/TRAVEL EXPE 16,047.79 010-10.1100.480000 UTILITY SERVICES 723.00 010-10.1100.540000 MINOR EQUIPMENT 4,073.99 O10-10.1100.580000 OFFICE SUPPLIES 303.87 010-10.1100.590000 OPERATING SUPPLIES & 435.97 010-10.1400.100000 HEALTH & LIFE INSURAN 792.77 010-10.1400.400000 REPAIR/MAINTENANCE 1,409.90 010-10,1400.410000 REPAIR OF VEHICLES 102.85 010-10.1400.480000 UTILITY SERVICES 594.21 010-10.1400.540000 MINOR EQUIPMENT 791.72 010-10.1400.580000 OFFICE SUPPLIES 6.62 010-10.1400.590000 OPERATING SUPPLIES & 86.39 010-10.1400.880000 FACILITIES 113.62 010-10.1500.100000 HEALTH & LIFE INSURAN 1,344.89 010-10.1500.231800 AMBULANCE BILLING FE 1,724.53 010-10.1500.3529900 AMBULANCE TRANSPOR 761.00 010-10.1500.400000 REPAIR/MAINTENANCE 1,933.72 010-10.1500.480000 UTILITY SERVICES 364.19 010-10.1500.540000 MINOR EQUIPMENT 2,807.03 010-10.1500.580000 OFFICE SUPPLIES 1.87 010-10.1500.590000 OPERATING SUPPLIES & 306.27 010-10.1500.590050 MEDICAL SUPPLIES 700.67 010-10.1500.880000 FACILITIES 173.78 010-10.1900.100000 HEALTH & LIFE INSURAN 677.75 010-10.1900.280000 DUES, MEMBERSHIPS & 200.00 010-10.1900.580000 OFFICE SUPPLIES 300.95 010-10.1900.590000 OPERATING SUPPLIES & 39.18 010-20.6000.100000 HEALTH & LIFE INSURAN 729.85 010-20.6010.400000 REPAIR/MAINTENANCE 4,250.00 010-20.6010.450000 TELEPHONE 113.66 010-20.6010.480000 UTILITY SERVICES 1,379.21 010-20.6010.510100 GARBAGE PICK UP 270.40 010-20.6010.580000 OFFICE SUPPLIES 270.20 010-20.6010.590000 OPERATING SUPPLIES & 139.21 010-20.6150.100000 HEALTH & LIFE INSURAN 280.06 010-20.6150.570110 COGS - FILTERS 642.91 010-20.6150.570130 COGS - PARTS 2,893.45 010-20.6150.590000 OPERATING SUPPLIES & 944.15 10/28/2020 2:24:25 PM Page 10 of 13 Expense Approval Register Packet: APPKT02061 - NOVEMBER 3RD COUNCIL PACKET Account Summary Account Number Account Name Expense Amount O10-20.8900.100000 HEALTH & LIFE INSURAN 380.00 010-20.8900.710000 AUTOMOTIVE EQUIPME 2,958.25 010-20.8950.100000 HEALTH & LIFE INSURAN 49.97 010-40.3100.100000 HEALTH & LIFE INSURAN 710.03 010-40.3100.270000 DATA PROCESSING 135.00 010-40.3100.400000 REPAIR/MAINTENANCE 3,917.13 010-40.3100.400100 CUSTODIAL SERVICES 520.00 010-40.3100.460300 PROGRAMS 549.81 010-40.3100.470000 TRAINING/TRAVEL EXPE 299.00 010-40.3100.480000 UTILITY SERVICES 1,300.08 010-40.3100.540000 MINOR EQUIPMENT 9,814.06 010-40.3100.580000 OFFICE SUPPLIES 91.37 010-40.3100.590000 OPERATING SUPPLIES & 1,451.93 010-40.3100.640000 LIBRARY BOOKS/FILMS/ 1,899.20 010-40.3100.880000 FACILITIES 4,975.00 010-40.4100.100000 HEALTH & LIFE INSURAN 303.61 010-40.4100.410100 REPAIR/MAINTENANCE 247.11 010-40.4100.410300 REPAIR/MAINTENANCE 1,202.39 010-40.4100.410310 REPAIR/MAINTENANCE- 235.00 010-40.4100.460101 PLANT SOME SHADE 11,896.00 010-40.4100.480000 UTILITY SERVICES 445.24 010-40.4100.480010 UTILITIES -DOG PARK 28.34 010-40.4100.590000 OPERATING SUPPLIES & 140.78 010-40.4100.590010 OPERATING SUPPLIES-D 174.22 010-40.4100.590011 OPERATING SUPPLIES-F 102.68 010-40.4100.590100 CHEMICAL/FERTILIZER 37.85 010-40.4200.100000 HEALTH & LIFE INSURAN 439.40 010-40.4200.460550 WINTER RECREATION PR 1,144.00 010-40.4200.461400 WAUKTOBER FEST 119.70 010-40.4200,540000 MINOR EQUIPMENT 521.00 010-40.4300.400000 REPAIR/MAINTENANCE 59.02 010-40.4300.450000 TELEPHONE 123.08 010-50.6500.340000 MISCELLANEOUS CONTR 6,400.00 010-50.6500.480050 UTILITIES -TRAILS 614.85 010-50.8500.280000 DUES, MEMBERSHIPS & 395.00 010-50.8700.100000 HEALTH & LIFE INSURAN 389.43 010-60.8100.120000 UNIFORMS 171.75 010-60.8100.470000 TRAINING/TRAVEL EXPE 350.00 010-60.8200.100000 HEALTH & LIFE INSURAN 219.70 010-60.8200.120000 UNIFORMS 41.91 010-60.8200.230010 WEBSITE DEVELOPMENT 6,036.91 010-60.8200.461200 NEWSLETTER/PUBLICATI 1,521.00 010-60.8300.100000 HEALTH & LIFE INSURAN 280.06 010-60.8300.120000 UNIFORMS 38.41 010-60.8300.210000 PUBLIC NOTIFICATION/A 146.69 010-60.8300.230000 CONSULTANT & PROFES 5,500.00 010-60.8300.270000 DATA PROCESSING 1,011.67 010-60.8300.280000 DUES, MEMBERSHIPS & 30.00 010-60.8300.390400 NORTHVIEW RENTAL PR 478.24 010-60.8300.450000 TELEPHONE 1,631.57 010-60.8300.459000 CONTRIBUTIONS 4,747.68 010-60.8300.580000 OFFICE SUPPLIES 231.22 010-60.8310.390600 PROF PLAZA CAM EXPEN 65.13 010-60.8310.400000 REPAIR/MAINTENANCE 2,177.38 010-60.8310.400100 CUSTODIAL SERVICES 1,550.14 010-60.8310.480000 UTILITY SERVICES 262.84 010-60.8310.590000 OPERATING SUPPLIES & 205.27 010-60.8350.100000 HEALTH & LIFE INSURAN 339.46 10/28/2020 2:24:25 PM Page 11 of 13 Expense Approval Register Packet: APPKT02061- NOVEMBER 3RD COUNCIL PACKET Account Summary Account Number Account Name Expense Amount 010-60.8350.120000 UNIFORMS 104.82 010-60.8350.580000 OFFICE SUPPLIES 45.39 010-60.8400.100000 HEALTH & LIFE INSURAN 278.89 010-60.8400.120000 UNIFORMS 118.73 010-60.8400.280000 DUES, MEMBERSHIPS & 150.00 010-60.8800.100000 HEALTH & LIFE INSURAN 269.67 010-60.8800.120000 UNIFORMS 39.11 010-60.8800.270110 COPIER / PRINTER LEASE 789.55 010-60.8800.540000 MINOR EQUIPMENT 10,352.30 010-60.8800.590000 OPERATING SUPPLIES & 252.44 010-60.8800.740230 NETWORK SOFTWARE 4,205.00 060-30.1601.410300 REPAIR/MAINTENANCE F 1,999.92 060-30.1601.480000 UTILITY SERVICES 893.09 060-30.7100.100000 HEALTH & LIFE INSURAN 729.63 060-30.7100.540000 MINOR EQUIPMENT 718.14 060-30.7100.570000 FUEL 11.63 060-30.7100.590000 OPERATING SUPPLIES & 2,061.29 060-30.7100.590300 ROAD STONE 1,177.28 060-30.7100.590400 ROAD REPAIR -PATCH 9,454.82 060-30.7100.590600 STREET SIGNS 124.00 327-90.2130.840492 ALICES LANDSCAPING & 24,236.67 327-90.4100.880078 GLYNN VILLAGE PARK - C 7,639.00 327-90.7200.235010 SUNRISE DRIVE - PHASE 280.00 327-90.8750.880000 IRRIGATION WATER SOU 6,095.42 510-30.6510.100000 HEALTH & LIFE INSURAN 575.20 510-30.6510.250000 TESTING FEES 260.00 510-30.6510.340000 MISCELLANEOUS CONTR 493.60 510-30.6510.390300 TOWER RENT 419.18 510-30.6510.480000 UTILITY SERVICES 18.95 510-30.6510.540000 MINOR EQUIPMENT 717.93 510-30.6510.590000 OPERATING SUPPLIES & 159.48 510-30.6510.592000 METER PURCHASE 1,878.95 520-30.6520.100000 HEALTH & LIFE INSURAN 464.86 520-30.6520.480000 UTILITY SERVICES 685.19 520-30.6520.540000 MINOR EQUIPMENT 1,002.95 520-30.6520.570000 FUEL 136.72 520-30.6520.590000 OPERATING SUPPLIES & 78.56 520-30.6520.650010 WRA OPERATING & MAI 46,078.80 520-30.6520.790000 VEHICLE OR EQUIPMENT 175.00 520-30.6520.882700 WRA FEES 74,829.40 540-30.6540.100000 HEALTH & LIFE INSURAN 737.62 540-30.6540.230000 CONSULTANT & PROFES 6,535.00 540-30.6540.340000 MISCELLANEOUS CONTR 493.60 540-30.6540.390300 TOWER RENT 419.17 540-30.6540.480000 UTILITY SERVICES 18.94 540-30.6540.540000 MINOR EQUIPMENT 2,717.92 540-30.6540.590000 OPERATING SUPPLIES & 363.49 540-30.6540.590100 DEVELOPER MATERIALS 21,661.09 540-30.6540.590200 INSTALLATION MATERIA 1,787.50 540-30.6540.592000 METER PURCHASE 96,215.42 540-30.6540.650000 COST OF GOODS SOLD 2,891.25 540-30.6540.685400 GAS REBATE 1,670.00 540-30.6540.880100 DISTRIBUTION SYSTEM I 31,742.29 560-80.5300.100000 HEALTH & LIFE INSURAN 244.69 560-80.5300.540000 MINOR EQUIPMENT 1,002.95 560-80.5300.685400 RAIN BARREL REBATES 50.00 560-80.5300.685410 RAIN GARDEN REBATES 3,697.58 560-80.5300.790000 VEHICLE OR EQUIPMENT 175.00 10/28/2020 2:24:25 PM Page 12 of 13 Expense Approval Register Packet: APPKT02061- NOVEMBER 3RD COUNCIL PACKET Account Summary Account Number Account Name Expense Amount 570-30.6550.100000 HEALTH & LIFE INSURAN 160.30 570-30.6550.120000 UNIFORMS 132.73 570-30.6550.270000 DATA PROCESSING 3,748.59 570-30.6550.580000 OFFICE SUPPLIES 113.96 750-80.8750.100000 HEALTH & LIFE INSURAN 118.81 750-80.8750.280000 DUES, MEMBERSHIPS & 95.00 750-80.8750.400000 REPAIR/MAINTENANCE 81.24 750-80.8750.450000 TELEPHONE 17.76 750-80.8750.580000 OFFICE SUPPLIES 128.71 750-80.8750.590000 OPERATING SUPPLIES & 326.08 750-80.8750.651000 PRO SHOP MERCHANDIS 2,234.76 750-80.8750.651100 PRO SHOP SPECIAL ORD 93.04 Grand Total: 521,796.88 Project Account Summary Project Account Key **None** CONSULTING ALICES RD MEDIANS CONSU LTI NG-G LYNN VILLAGE PARK CONSULTING -NW SUNRISE/RRVT SIGNAL Expense Amount 489,641.21 24,236.67 7,639.00 280.00 Grand Total: 521,796.88 10/28/2020 2:24:25 PM Page 13 of 13 301< My Check Report IED City of Waukee, IA By Check Number \MxA(BE Date Range: 10/15/2020 - 10/19/2020 Vendor Number Vendor Name Payment Date Payment Type Discount Amount Payment Amount Number Bank Code: AP-WAUKEE STATE 047290 DOLL DISTRIBUTING, LLC 10/16/2020 Regular 0.00 431.70 144364 Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INVO010127 Invoice 10/16/2020 BEER DELIVERY 0.00 431.70 750-80.8750.650100 COGS-BEER/ALCOHOL BEER DELIVERY 431.70 Bank Code AP Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 1 1 0.00 431.70 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 1 1 0.00 431.70 10/28/2020 3:10:47 PM Page 1 of 2 My Check Report Date Range: 10/15/2020 - 10/19/2020 All Bank Codes Check Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 1 1 0.00 431.70 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 1 1 0.00 431.70 Fund Summary Fund Name Period Amount 999 POOLED CASH 10/2020 431.70 431.70 IU/28/2020 3:10:47 PM Page 2 of 2 0 City of Waukee, IA Waukee 4�7 My Check Report By Check Number Date Range: 10/21/2020 - 10/28/2020 Vendor Number Vendor Name Payment Date Payment Type Discount Amount Payment Amount Number Bank Code: AP-WAUKEE STATE 016255 PREMIER GLOBAL SERVICES 10/21/2020 Regular 0.00 2.91 144573 Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount ?b1335 Invoice 09/30/2020 SEPTEMBER 2020 STATEMENT 0.00 2.91 010-60.8300.450000 TELEPHONE BID OPENING & UNKNOWN CAL 2.91 045525 DES MOINES REGISTER 10/21/2020 Regular 0.00 69.00 144574 Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0010170 Invoice 10/21/2020 MON. - SAT. SUBSCRIPTION CITY HALL 0.00 69.00 010-60.8300.280000 DUES, MEMBERSHIPS & S MON. - SAT. SUBSCRIPTION CITY 69.00 045525 DES MOINES REGISTER 10/21/2020 Regular 0.00 32.00 144575 Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0010169 Invoice 09/30/2020 MON. - SAT. SUBSCRIPTION CITY HALL 0.00 32.00 010-60.8300.280000 DUES, MEMBERSHIPS & S MON. - SAT. SUBSCRIPTION CITY 32.00 055625 EMPLOYEE BENEFIT SYSTEMS 10/21/2020 Regular 0.00 164,587.52 144576 10/28/2020 3:11:31 PM Page 1 of 4 My Check Report w W Date Range: 10/21/2020 - 10/28/2020 Vendor Number Vendor Name Payable # Payable Type Account Number INVO010156 Invoice 010-10.1100.100000 010-10.1400.100000 010-10.1500.100000 010-10.1900.100000 010-20.6000.100000 010-20.6150.100000 010-20.8900.100000 010-20.8950.100000 010-40.3100.100000 010-40.4100.100000 010-40.4100.100000 010-40.4100.100000 010-40.4200.100000 010-50.8700.100000 010-60.8200.100000 010-60.8300.100000 010-60.8350.100000 010-60.8400.100000 010-60.8800.100000 060-30.7100.100000 060-30.7100.100000 060-30.7100.100000 510-30.6510.100000 510-30.6510.100000 510-30.6510.100000 510-30.6510.100000 520-30.6520.100000 520-30.6520.100000 520-30.6520.100000 540-30.6540.100000 540-30.6540.100000 540-30.6540.100000 560-80.5300.100000 560-80.5300.100000 570-30.6550.100000 750-80.8750.100000 089600 Payable # INVO010174 INV0010175 179250 Payable # INV0010172 INV0010173 195855 Payment Date Payment Type Discount Amount Payment Amount Number Post Date Payable Description Discount Amount Payable Amount Account Name Item Description Distribution Amount 10/20/2020 NOV'20 HEALTH INSURANCE MONTHLY P 0.00 164,587.52 HEALTH & LIFE INSURANC NOV'20 HEALTH INSURANCE M 41,812.71 HEALTH & LIFE INSURANC NOV'20 HEALTH INSURANCE M 8,527.28 HEALTH & LIFE INSURANC NOV'20 HEALTH INSURANCE M 14,965.65 HEALTH & LIFE INSURANC NOV'20 HEALTH INSURANCE M 7,630.54 HEALTH & LIFE INSURANC NOV'20 HEALTH INSURANCE M 8,747.45 HEALTH & LIFE INSURANC NOV'20 HEALTH INSURANCE M 3,444.02 HEALTH & LIFE INSURANC NOV'20 HEALTH INSURANCE M 4,833.22 HEALTH & LIFE INSURANC NOV'20 HEALTH INSURANCE M 694.60 HEALTH & LIFE INSURANC NOV'20 HEALTH INSURANCE M 8,971.84 HEALTH & LIFE INSURANC NOV'20 HEALTH INSURANCE M 353.56 HEALTH & LIFE INSURANC NOV'20 HEALTH INSURANCE M 2,462.41 HEALTH & LIFE INSURANC NOV'20 HEALTH INSURANCE M 694.60 HEALTH & LIFE INSURANC NOV'20 HEALTH INSURANCE M 4,924.82 HEALTH & LIFE INSURANC NOV'20 HEALTH INSURANCE M 4,230.22 HEALTH & LIFE INSURANC NOV'20 HEALTH INSURANCE M 2,462.41 HEALTH & LIFE INSURANC NOV'20 HEALTH INSURANCE M 3,444.02 HEALTH & LIFE INSURANC NOV'20 HEALTH INSURANCE M 3,535.62 HEALTH & LIFE INSURANC NOV'20 HEALTH INSURANCE M 4,003.32 HEALTH & LIFE INSURANC NOV'20 HEALTH INSURANCE M 3,157.01 HEALTH & LIFE INSURANC NOV'20 HEALTH INSURANCE M 176.78 HEALTH & LIFE INSURANC NOV'20 HEALTH INSURANCE M 883.91 HEALTH & LIFE INSURANC NOV'20 HEALTH INSURANCE M 6,935.94 HEALTH & LIFE INSURANC NOV'20 HEALTH INSURANCE M 4,485.92 HEALTH & LIFE INSURANC NOV'20 HEALTH INSURANCE M 347.30 HEALTH & LIFE INSURANC NOV'20 HEALTH INSURANCE M 883.90 HEALTH & LIFE INSURANC NOV'20 HEALTH INSURANCE M 1,676.21 HEALTH & LIFE INSURANC NOV'20 HEALTH INSURANCE M 883.90 HEALTH & LIFE INSURANC NOV'20 HEALTH INSURANCE M 347.30 HEALTH & LIFE INSURANC NOV'20 HEALTH INSURANCE M 4,485.92 HEALTH & LIFE INSURANC NOV'20 HEALTH INSURANCE M 883.91 HEALTH & LIFE INSURANC NOV'20 HEALTH INSURANCE M 347.30 HEALTH & LIFE INSURANC NOV'20 HEALTH INSURANCE M 6,935.94 HEALTH & LIFE INSURANC NOV'20 HEALTH INSURANCE M 2,462.41 HEALTH & LIFE INSURANC NOV'20 HEALTH INSURANCE M 347.30 HEALTH & LIFE INSURANC NOV'20 HEALTH INSURANCE M 2,370.81 HEALTH & LIFE INSURANC NOV'20 HEALTH INSURANCE M 1,237.47 HY-VEE 10/21/2020 Regular 0.00 682.85 144577 Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount Invoice 09/10/2020 SEPTEMBER 2020 STATEMENT 0.00 382.85 010-10.1100.590000 OPERATING SUPPLIES & POLICE CAR WASHES 365.00 010-20.6000.590000 OPERATING SUPPLIES & WATER/SPICES 17.85 Invoice 10/12/2020 OCTOBER 2020 STATEMENT 0.00 300.00 010-10.1100.590000 OPERATING SUPPLIES & POLICE CAR WASHES 300.00 CENTURYLINK 10/21/2020 Regular 0.00 289.07 144578 Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount Invoice 10/10/2020 OCTOBER 2020 STATEMENT 0.00 233.10 750-80.8750.450000 TELEPHONE OCTOBER 2020 STATEMENT 233.10 Invoice 520-30.6520.450000 SPLAW PROPERTIES, LLC 10/10/2020 OCTOBER 2020 STATEMENT 0.00 55.97 TELEPHONE OCTOBER 2020 STATEMENT 55.97 10/21/2020 Regular 0.00 4,504.83 144579 10/28/2020 3:11:31 PM Page 2 of 4 �J My Check Report Date Range: 10/21/2020 - 10/28/2020 Vendor Number Vendor Name Payment Date Payment Type DiscountAmount PaymentAmount Number Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0010171 Invoice 10/21/2020 NOVEMBER 2020 RENT & INSURANCE 0.00 4,504.83 010-60.8310.290000 CITY HALL ANNEX INSURA NOVEMBER 2020 RENT & INSUR 107.50 010-60.8310.390100 CITY HALL ANNEX LEASE NOVEMBER 2020 RENT & INSUR 4,397.33 223787 BOBBIE VAUGHT 10/21/2020 Regular 0.00 193.67 144580 Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0010168 Invoice 10/21/2020 REIMBURSEMENT FOR SERVICE CALL DUE 0.00 193.67 540-30.6540.590000 OPERATING SUPPLIES & REIMBURSEMENT FOR SERVICE 193.67 190825 SAM'S CLUB 10/27/2020 Regular 0.00 942.13 144585 Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0010209 Invoice 10/08/2020 OCTOBER 2020 STATEMENT 0.00 942.13 010-20.6010.590000 OPERATING SUPPLIES & ICE 6.47 010-40.4100.540000 MINOR EQUIPMENT TABLES FOR VINEYARD BUILDIN 609.78 010-40.4200.460520 CONCESSION STAND BUBBLEGUM/TAFFY/GUMMIES 35.99 010-40.4200.461400 WAUKTOBER FEST PAINT A PUMPKIN SUPPLIES 208.50 010-40.4200.461400 WAUKTOBER FEST PORTION CONTROL CUPS 24.17 010-60.8350.689200 WELLNESS PROGRAM/ IN HEALTHIEST STATE WALK 57.22 199525 SUSAN G KOMEN OF GREATER IOWA 10/27/2020 Regular 0.00 234.60 144586 Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0010210 Invoice 10/27/2020 PROCEEDS FROM SHIRT DRIVE 0.00 234.60 010-10.1100.460200 PD COMMUNITY POLICIN PROCEEDS FROM SHIRT DRIVE 234.60 193713 SHOTTENKIRKCHEVROLET - VEHICLES 10/28/2020 Regular 0.00 27,651.58 144587 Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount NV0010217 Invoice 10/28/2020 2021 CHEVY TRAVERSE 8325 0.00 27,651.58 010-40.4100.710000 AUTOMOTIVE EQUIPMEN 2021 CHEVY TRAVERSE 1GNRVF 13,825.79 010-40.4200.710000 AUTOMOTIVE EQUIPMEN 2021 CHEVY TRAVERSE 1GNRVF 13,825.79 Bank Code AP Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 13 11 0.00 199,190.16 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 13 11 0.00 199,190.16 10/28/2020 3:11:31 PM Page 3 of 4 My Check Report Date Range: 10/21/2020 - 10/28/2020 All Bank Codes Check Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 13 11 0.00 199,190.16 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 13 11 0.00 199,190.16 Fund Summary Fund Name Period Amount 999 POOLED CASH 10/2020 199,190.16 199,190.16 10/28/2020 3:11:31 PM Page 4 of 4 610 City of Waukee, IA \4bL lee V Council Payroll Reimbursements By Check Number Date Range: 10/15/2020 - 10/28/2020 Vendor Number Vendor Name Payment Date Payment Type Discount Amount Payment Amount Number Bank Code: AP-WAUKEE STATE 034875 CITY OF WAUKEE 10/16/2020 Regular 0.00 9,369.80 144371 Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0010136 Invoice 10/20/2020 CELL PHONE REIMBURSEMENT 0.00 177.50 010-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 119.00 060-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 10.13 510-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 13.14 520-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 13.12 540-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 16.86 750-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 5.25 INV0010141 Invoice 10/20/2020 LIFE INSURANCE PREMIUM 0.00 690.74 010-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 578.69 060-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 20.18 510-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 6.98 520-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 7.03 540-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 36.56 560-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 21.05 570-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 20.25 INV0010142 Invoice 10/20/2020 STD INSURANCE PREMIUM 0.00 741.56 010-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 576.01 060-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 56.76 510-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 48.73 520-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 24.26 540-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 3.06 560-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 20.07 570-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 12.67 INV0010146 Invoice 10/20/2020 HEALTH INSURANCE DEDUCTION 0.00 160.00 060-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 160.00 INV0010147 Invoice 10/20/2020 HEALTH INSURANCE DEDUCTION 0.00 6,480.00 010-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 5,136.00 060-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 288.02 510-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 280.11 520-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 199.93 540-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 359.94 560-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 80.00 570-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 80.00 750-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 56.00 INV0010148 Invoice 10/20/2020 HEALTH INSURANCE DEDUCTION 0.00 1,120.00 010-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 875.00 510-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 70.21 520-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 69.81 540-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 17.51 560-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 52.47 570-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 35.00 036350 IOWA DEPT OF HUMAN SERVICES 10/16/2020 Regular 0.00 925.00 144372 Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0010128 Invoice 10/20/2020 CHILD SUPPORT 0.00 925.00 010-2011300 CHILD SUPPORT PAYABLE CHILD SUPPORT 925.00 036740 COMMUNICATIONS WORKERS OF AMERICA 10/16/2020 Regular 0.00 1,179.83 144373 10/27/2020 12:50:36 PM Page 1 or G Council Payroll Reimbursements Vendor Number Vendor Name Payable # Payable Type Account Number INVO010134 Invoice 010-2014100 060-2014100 510-2014100 520-2014100 540-2014100 560-2014100 570-2014100 V Date Range: 10/15/2020 - 20/28/2020 Payment Date Payment Type Discount Amount Payment Amount Number Post Date Payable Description Discount Amount Payable Amount Account Name Item Description Distribution Amount 10/20/2020 CWA LOCAL 7102 UNION DUES 0.00 1,179.83 CREDIT UNION DEDUCT] CWA LOCAL 7102 UNION DUES 775.58 CREDIT UNION DEDUCTI CWA LOCAL 7102 UNION DUES 67.25 CREDIT UNION DEDUCTI CWA LOCAL 7102 UNION DUES 83.30 CREDIT UNION DEDUCT] CWA LOCAL 7102 UNION DUES 49.30 CREDIT UNION DEDUCTI CWA LOCAL 7102 UNION DUES 140.12 CREDIT UNION DEDUCT] CWA LOCAL 7102 UNION DUES 36.36 CREDIT UNION DEDUCTI CWA LOCAL 7102 UNION DUES 27.92 091000 ICMA RETIREMENT TRUST 457 10/16/2020 Regular 0.00 10,078.46 144374 Payable tl Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INVO010129 Invoice 10/20/2020 ICMA 457 ROTH CONTRIBUTION 0.00 25.00 010-2011200 IPERS WITHHOLDING PAY ICMA 457 ROTH CONTRIBUTION 25.00 INVO010130 Invoice 10/20/2020 ICMA 401A 0.00 2,518.34 010-2011200 IPERS WITHHOLDING PAY ICMA 401A 2,518.34 INVO010131 Invoice 10/20/2020 ICMA ROTH CONTRIBUTION 0.00 1,768.16 010-2011200 IPERS WITHHOLDING PAY ICMA ROTH CONTRIBUTION 1,298.16 060-2011200 IPERS WITHHOLDING PAY ICMA ROTH CONTRIBUTION 50.00 510-2011200 IPERS WITHHOLDING PAY ICMA ROTH CONTRIBUTION 62.51 520-2011200 IPERS WITHHOLDING PAY ICMA ROTH CONTRIBUTION 62.51 540-2011200 IPERS WITHHOLDING PAY ICMA ROTH CONTRIBUTION 232.51 560-2011200 IPERS WITHHOLDING PAY ICMA ROTH CONTRIBUTION 62.47 INVO010132 Invoice 10/20/2020 ICMA RETIREMENT 0.00 4,118.19 010-2011200 IPERS WITHHOLDING PAY ICMA RETIREMENT 3,993.19 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 50.00 INVO010133 Invoice 10/20/2020 ICMA 0.00 1,648.77 010-2011200 IPERS WITHHOLDING PAY ICMA 1,358.54 510-2011200 IPERS WITHHOLDING PAY ICMA 35.85 520-2011200 IPERS WITHHOLDING PAY ICMA 36.46 560-2011200 IPERS WITHHOLDING PAY ICMA 217.92 099999 EFTPS 10/16/2020 Regular 0.00 103,249.96 144375 Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INVO010153 Invoice 10/20/2020 FICA TAX WITHHOLDING 0.00 49,394.70 010-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 39,966.96 060-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 1,771.92 510-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 1,769.34 520-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 1,418.22 540-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 1,837.16 560-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 784.90 570-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 903.22 750-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 942.98 INVO010154 Invoice 10/20/2020 FEDERAL WITHHOLDING TAXES 0.00 41,979.86 010-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 34,715.27 060-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 1,224.45 510-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 1,456.50 520-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 1,215.32 540-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 1,442.56 560-2010200 FEDERAL TAX WITHHOLD[ FEDERAL WITHHOLDING TAXES 671.48 570-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 877.52 750-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 376.76 INVO010155 Invoice 10/20/2020 MEDICARE TAX WITHHOLDING 0.00 11,875.40 010-2010400 MEDICARE TAX WITH HOL MEDICARE TAX WITHHOLDING 9,670.44 10/27/2020 12:50:36 PM Page 2 0i 6 Council Payroll Reimbursements Vendor Number Vendor Name 060-2010400 510-2010400 520-2010400 540-2010400 560-2010400 570-2010400 750-2010400 Payment Date MEDICARE TAX WITHHOL MEDICARE TAX WITHHOL MEDICARE TAX WITHHOL MEDICARE TAX WITHHOL MEDICARE TAX WITHHOL MEDICARE TAX WITHHOL MEDICARE TAX WITHHOL V Date Range: 10/15/2020 - 10/28/2020 Payment Type Discount Amount Payment Amount Number MEDICARE TAX WITHHOLDING 414.44 MEDICARE TAX WITHHOLDING 413.86 MEDICARE TAX WITHHOLDING 331.68 MEDICARE TAX WITHHOLDING 429.62 MEDICARE TAX WITHHOLDING 183.56 MEDICARE TAX WITHHOLDING 211.24 MEDICARE TAX WITHHOLDING 220.56 133560 MEALS FROM THE HEARTLAND 10/16/2020 Regular 0.00 49.58 144376 Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0010139 Invoice 10/20/2020 MEALS FROM HEARTLAND DEDUCTION 0.00 49.58 010-2030000 PAYROLL PAYABLES MEALS FROM HEARTLAND DED 44.58 510-2030000 PAYROLL PAYABLES MEALS FROM HEARTLAND DED 2.50 520-2030000 PAYROLL PAYABLES MEALS FROM HEARTLAND DED 2.50 206800 TOTAL ADMINISTRATIVE SERVICES CORP 10/16/2020 Regular 0.00 5,711.23 144377 Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0010143 Invoice 10/20/2020 LIMITED PURPOSE FLEX MEDICAL DEDUC 0.00 64.39 010-2030000 PAYROLL PAYABLES LIMITED PURPOSE FLEX MEDICA 64.39 INV0010144 Invoice 10/20/2020 SECTION 125 MEDICAL DEDUCTIONS 0.00 3,044.24 010-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 2,325.76 060-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 60.97 510-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 94.96 520-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 15.46 540-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 252.09 560-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 75.00 570-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 147.08 750-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 72.92 INV0010145 Invoice 10/20/2020 SECTION 125 DAYCARE DEDUCTIONS 0.00 2,602.60 010-2030000 PAYROLL PAYABLES SECTION 125 DAYCARE DEDUCTI 2,244.26 060-2030000 PAYROLL PAYABLES SECTION 125 DAYCARE DEDUCTI 150.00 560-2030000 PAYROLL PAYABLES SECTION 125 DAYCARE DEDUCTI 208.34 213250 UNITED WAY CENTRAL IOWA 10/16/2020 Regular 0.00 48.33 144378 Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0010135 Invoice 10/20/2020 UNITED WAY DEDUCTION 0.00 48.33 010-2030000 PAYROLL PAYABLES UNITED WAY DEDUCTION 43.33 510-2030000 PAYROLL PAYABLES UNITED WAY DEDUCTION 2.50 520-2030000 PAYROLL PAYABLES UNITED WAY DEDUCTION 2.50 232611 WAUKEE AREA CHRISTIAN SERVICES 1O/16/2020 Regular 0.00 61.75 144379 Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0010137 Invoice 10/20/2020 WAUKEE AREA CHRISTIAN SERVICES DED 0.00 61.75 010-2030000 PAYROLL PAYABLES WAUKEE AREA CHRISTIAN SERVI 58.75 570-2030000 PAYROLL PAYABLES WAUKEE AREA CHRISTIAN SERVI 3.00 232624 WAUKEE BETTERMENT FOUNDATION 10/16/2020 Regular 0.00 104.16 144380 Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0010138 Invoice 10/20/2020 WAUKEE BETTERMENT FOUNDATION DED 0.00 104.16 010-2030000 PAYROLL PAYABLES WAUKEE BETTERMENT FOUNDA 104.16 233050 WAUKEE PUBLIC LIBRARY FRIENDS FOUNDATIC 10/16/2020 Regular 0.00 25.41 144381 10/27/2020 12:50:36 PM Page 3 of 6 Council Payroll Reimbursements Vendor Number Vendor Name Payable # Payable Type INVO010140 098900 Payable # INVO010069 INVO010070 INVO010149 INVO010150 INVO010151 INVO010179 208650 Payable # INVO010071 Account Number Invoice 010-2030000 510-2030000 IPERS Payable Type Account Number 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 560-2011200 570-2011200 750-2011200 Invoice 010-2011200 Invoice 010-2011200 Invoice 010-60,8400.080000 U Date Range: 10/15/2020 - 10/28/2020 Payment Date Payment Type Discount Amount Payment Amount Number Post Date Payable Description Discount Amount Payable Amount Account Name Item Description Distribution Amount 10/20/2020 LIBRARY FRIENDS FOUNDATION PAYROLL 0.00 25.41 PAYROLL PAYABLES LIBRARY FRIENDS FOUNDATION 20.41 PAYROLL PAYABLES LIBRARY FRIENDS FOUNDATION 5.00 10/26/2020 Regular Post Date Payable Description Account Name Item Description 10/05/2020 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 10/05/2020 IPERS DEDUCTIONS IPERS WITHHOLDING PAY IPERS DEDUCTIONS 10/20/2020 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 10/20/2020 IPERS DEDUCTIONS IPERS WITHHOLDING PAY IPERS DEDUCTIONS 0.00 131, 765.97 144581 Discount Amount Payable Amount Distribution Amount 0.00 40,465.86 27,634.77 2,571.45 2,381.26 1,907.41 2,422.09 1,078.66 1,171.72 1,298.50 0.00 25,381.99 25,381.99 0.00 39,711.79 27,478.68 2,351.07 2,316.13 1,842.25 2,429.60 1,061.22 1,183.71 1,049.13 0.00 25,708.02 25,708.02 10/20/2020 IPERS ELECTED OFFICIAL DEDUCT 0.00 498.29 IPERS WITHHOLDING PAY IPERS ELECTED OFFICIAL DEDUC 498.29 10/26/2020 OCT'20 ROUNDING ADJUSTMENT 0.00 0.02 IPERS CONTRIBUTION OCT'20 ROUNDING ADJUSTME 0.02 TREASURER STATE OF IOWA 10/26/2020 Regular Payable Type Post Date Payable Description Account Number Account Name Item Description Invoice 10/05/2020 STATE WITHHOLDING TAXES 010-2011100 STATE TAX WITHHOLDING STATE WITHHOLDING T 060-2011100 STATE TAX WITHHOLDING STATE WITHHOLDING T 510-2011100 STATE TAX WITHHOLDING STATE WITHHOLDING T 520-2011100 STATE TAX WITHHOLDING STATE WITHHOLDING T 540-2011100 STATE TAX WITHHOLDING STATE WITHHOLDING T 560-2011100 STATE TAX WITHHOLDING STATE WITHHOLDING T 570-2011100 STATE TAX WITHHOLDING STATE WITHHOLDING T 750-2011100 STATE TAX WITHHOLDING STATE WITHHOLDING T 0.00 35,936.37 144582 Discount Amount Payable Amount Distribution Amount 0.00 17,917.67 AXES 14,603.87 AXES 622.38 AXES 633.44 AXES 504.30 AXES 667.01 AXES 252.80 AXES 314.86 AXES 319.01 INVO010152 Invoice 10/20/2020 STATE WITHHOLDING TAXES 010-2011100 STATE TAX WITHHOLDING STATE WITHHOLDING TAXES 060-2011100 STATE TAX WITHHOLDING STATE WITHHOLDING TAXES 510-2011100 STATE TAX WITHHOLDING STATE WITHHOLDING TAXES 520-2011100 STATE TAX WITHHOLDING STATE WITHHOLDING TAXES 540-2011100 STATE TAX WITHHOLDING STATE WITHHOLDING TAXES 560-2011100 STATE TAX WITHHOLDING STATE WITHHOLDING TAXES 570-2011100 STATE TAX WITHHOLDING STATE WITHHOLDING TAXES 0.00 18,018.70 14,863.60 581.91 612.53 483.37 670.95 246.81 318.42 10/27/2020 12:50:36 PM Page 4 of 6 Council Payroll Reimbursements Date Range: 10/15/2020 - 10/28/2020 Vendor Number Vendor Name Payment Date Payment Type Discount Amount Payment Amount Number 750-2011100 STATE TAX WITHHOLDING STATE WITHHOLDING TAXES 241.11 Bank Code AP Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 32 13 0.00 298,505.85 Manual Checks 0 0 0.00 0.00 Voided Checks 0 0 0.00 0.00 Bank Drafts 0 0 0.00 0.00 E FT's 0 0 0.00 0.00 32 13 0.00 298,505.85 10/27/2020 12:50:36 PM Page 5 of 6 Council Payroll Reimbursements V Date Range: 10/15/2020 - 10/28/2020 All Bank Codes Check Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 32 13 0.00 298,505.85 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 32 13 0.00 298,505.85 Fund Summary Fund Name Period Amount 999 POOLED CASH 10/2020 298,505.85 298,505.85 10/27/2020 12:50:36 PM Page 6 of 6 Utility Refund Check Report City of Waukee, IA Date Range: 10/15/2020 - 10/28/2020 Adj Account Number Name Date Type Amount Reference Packet Receipt Type 16-00212-02 Beck, Pam R 10/21/2020 Refund 29.81 Check M 144557 UBPKTO4661 Revenue Code Current Plus 1 Plus 2 Plus 3 Plus 4 Balance 996 29.81 0.00 0.00 0.00 0.00 29.81 Aging Total: 29.81 0.00 0.00 0.00 0.00 29.81 17-00405-01 Bos, Ali J 10/21/2020 Refund 91.49 Check M 144563 UBPKT04661 Revenue Code Current Plus 1 Plus 2 Plus 3 Plus 4 Balance 996 91.49 0.00 0.00 0.00 0.00 91.49 Aging Total: 91.49 0.00 0.00 0.00 0.00 91.49 16-00569-02 Day, Olivia 1 10/21/2020 Refund 5.92 Check #: 144560 UBPKT04661 Revenue Code Current Plus 1 Plus 2 Plus 3 Plus 4 Balance 996 -94.08 0.00 100.00 0.00 0.00 5.92 Aging Total: -94.08 0.00 100.00 0.00 0.00 5.92 19-01182-00 Element 119 LLC 10/21/2020 Refund 370.01 Check M 144568 UBPKT04661 Revenue Code Current Plus 1 Plus 2 Plus 3 Plus 4 Balance 996 370.01 0.00 0.00 0.00 0.00 370.01 Aging Total: 370.01 0.00 0.00 0.00 0.00 370.01 19-00289-00 Genesis Homes 10/21/2020 Refund 243.01 Check M 144564 UBPKT04661 Revenue Code Current Plus 1 Plus 2 Plus 3 Plus 4 Balance 996 243.01 0.00 0.00 0.00 0.00 243.01 Aging Total: 243.01 0.00 0.00 0.00 0.00 243.01 84-00056-05 Goodwin, Nicholas 10/21/2020 Refund 38.67 Check M 144570 UBPKT04661 Revenue Code Current Plus 1 Plus 2 Plus 3 Plus 4 Balance 996 38.67 0.00 0.00 0.00 0.00 38.67 Aging Total: 38.67 0.00 0.00 0.00 0.00 38.67 16-00413-03 Guthrie, Marissa 10/21/2020 Refund 37.28 Check M 144558 UBPKT04661 Revenue Code Current Plus 1 Plus 2 Plus 3 Plus 4 Balance 996 37.28 0.00 0.00 0.00 0.00 37.28 Aging Total: 37.28 0.00 0.00 0.00 0.00 37.28 19-00565-00 Jerrys Homes 10/21/2020 Refund 9.50 Check #: 144566 UBPKT04661 Revenue Code Current Plus 1 Plus 2 Plus 3 Plus 4 Balance 996 9.50 0.00 0.00 0.00 0.00 9.50 Aging Total: 9.50 0.00 0.00 0.00 0.00 9.50 16-00768-03 Kopp, Erin R 10/21/2020 Refund 47.31 Check M 144562 UBPKT04661 Revenue Code Current Plus 1 Plus 2 Plus 3 Plus 4 Balance 996 47.31 0.00 0.00 0.00 0.00 47.31 Aging Total: 47.31 0.00 0.00 0.00 0.00 47.31 1 10/27/2020 12:51:05 PM Utility Refund Check Report I(�� Account Number Name 16-00530-04 Patterson, Jennifer L 83-00655-07 Reyes, Elder 17-00081-02 Simmons, Hunter T 19-00348-01 Steen, Kelsey M 85-01406-05 Sternquist, Zoey I 19-00600-00 Synergy Homes Date Type Amount Reference 10/21/2020 Refund 16.89 Check #:144559 Revenue Code Current 996 16.89 Aging Total: 16.89 10/21/2020 Refund 68.12 Check M 144569 Revenue Code Current 996 68.12 Aging Total: 68.12 10/21/2020 Refund 162.12 Check #:144562 Revenue Code Current 996 162.12 Aging Total: 162.12 10/21/2020 Refund 44.31 Check M 144565 Revenue Code Current 996 44.31 Aging Total: 44.31 10/21/2020 Refund 104.74 Check M 144571 Revenue Code Current 996 104.74 Aging Total: 104.74 10/21/2020 Refund 392.95 Check M 144567 Revenue Code Current 996 392.95 Aging Total: 392.95 Transaction Grand Total for Period: 1,662.13 Totals by Transaction Type Transaction Type Count Refund 15 Total for Period: 15 Totals by Transaction Type and Revenue Code Transaction Type Revenue Code Couni Refund 996 - Unapplied Credits 17 Refund Total Total for Period: 17 Adj Packet Receipt Type UBPKTO4661 Plus 1 Plus 2 Plus 3 Plus 4 Balance 0.00 0.00 0.00 0.00 16.89 0.00 0.00 0.00 0.00 16.89 UBPKTO4661 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 UBPKTO4661 Plus 1 Plus 2 Plus 3 Plus 4 Balance 0.00 0.00 0.00 0.00 162.12 0.00 0.00 0.00 0.00 162.12 UBPKTO4661 Plus 1 Plus 2 Plus 3 Plus 4 Balance 0.00 0.00 0.00 0.00 44.31 0.00 0.00 0.00 0.00 44.31 UBPKTO4661 Plus 1 Plus 2 Plus 3 Plus 4 Balance 0.00 0.00 0.00 0.00 104.74 0.00 0.00 0.00 0.00 104.74 UBPKTO4661 Plus 1 Plus 2 Plus 3 Plus 4 Balance 0.00 0.00 0.00 0.00 392.95 0.00 0.00 0.00 0.00 392.95 Amount 1,662.13 1662.13 Amount 1,662.13 1662.13 1662.13 10/27/2020 12:51:05 PM Utility Refund Check Report Totals by Revenue Code Revenue Code Count Amount 996 - Unapplied Credits 17 1,662.13 Total for Period: 17 1662.13 10/27/2020 12:51:05 PM Utility Refund Check Report Page 3 of 3 Cal - Waukee Employee Name ABRAMOWITZ, LEVI ADKINS, COREY AHRENS, ELIZA ALDRICH, SHAWN ANDERSON,SARA ARIAS, HECTOR ARMSTRONG, BRETT BAKER, RANDY BARTLING, DARREL BAUMAN, LISA BERGMAN, ANNASTASIA BOTTENBERG, RICHARD BROWN, ANGALEA BROWN, LINDSAY BROWN, NATHAN BRUENING, BENJAMIN BRUNS,RACHEL BURKHART, LINDA CAMPBELL, SCOTT CARPENTER,PAUL CARROLL,JOSEPH CHRISTENSEN, ABAGAIL CICHOSKI, KELLI CLARKE, COURTNEY CLAYTON, EMMA CLEMEN, ANTHONY COGGESHELL, LEE CORKREAN, JENNIFER COSE, RYAN COUCHMAN, KENNETH COUGHLIN, TONI CRAVEN, GAYLA CRONE, CHRISTINE CROSS, JONATHAN CUNNINGHAM, SCOTT DANIEL, COLE DEBOER, MELISSA DEETS, BRADLY DETRICK, GRANT DEZEEUW, DAVID DODGE, JUSTIN DOYLE, DEVIN EASTCOTT, JOSHUA EDWARDS, DANAE ELLIS, NICOLE EVANS, SUMMER FIFE, JASON FLUGGE-SMITH, JAMIE FORRET, DENNIS FREDERICK, JUSTIN FREDERICKSEN, BROCK FROEHLICH, WILLIAM FURRY, ALISSA FYFE, JUSTIN GIBBS, AUSTIN GIBSON IV, WILLIAM GILCHRIST, NICHOLAS City of Waukee, IA Payroll Publication Report By Employee Name Payroll Set: 01 - City of Waukee For Date Range 10012020-10152020 Salary 1,598.08 1,418.80 1,432.57 1,847.29 1,567.88 2,580.10 1,641.26 1,784.20 263.59 1,381.36 611.82 615.98 1,430.33 138.80 2,262.99 379.85 2,165.09 3,135.63 2,338.56 1,816.24 2,235.24 1,453.13 1,951.53 1,071.01 58.41 2,774.22 1,632.43 1,852.14 95.58 86.01 1,601.09 92.46 589.38 876.65 3,050.90 1,469.61 2,452.16 3,657.67 73.35 2,354.57 2,130.35 114.29 2,333.94 2,093.66 681.54 2,850.81 1,826.41 1,774.68 221.52 2,205.21 1,416.80 808.04 851.89 1,049.93 1,688.40 1,980.59 1,635.91 Employee Name Salary GITZEN, ROBERT 1,962.24 GROVE, BRIAN 58.30 GUESS, CHRISTOPHER 1,819.41 GUESS, KATHRYN 2,255.90 HANSON, LAURA 1,761.47 HARDIN, THOMAS 187.59 HAUCK, BRETT 632.42 HEIMANN, RONALD 2,321.67 HENKENIUS, JODY 1,561.23 HENTGES, ERIC 2,284.70 HERRICK, ROBERT 1,925.57 HILGENBERG, ADAM 2,718.58 HOPKINS, JERI 185.24 HUSTED, TROY 1,946.53 HUTTON, JOSHUA 2,451.16 JACKSON, COLE 1,584.17 JERMIER, MATTHEW 3,326.56 JONES, BRIAN 141.69 KAPPOS, SARA 2,830.72 KASS, ANDREW 2,468.01 KASZINSKI, BRETT 545.64 KELLER, CHRISTOPHER 1,914.92 KELLY, KEYSTO 20.33 KICKBUSH, CHRISTOPHER 1,698.37 KING, JANA 197.85 KINNEY, SCOTT 1,976.36 KLEINWOLTERINK, COLE 1,635.64 KLEPINGER, KRISTIN 320.02 KLEVER, JUDY 1,117.59 KOESTER, RUDY 3,276.83 KRECH, JULIE 51.96 KURTH, TIMOTHY 2,234.77 LARSON, KENNETH 731.67 LARSON, KRISTINE 3,065.00 LAUGHRIDGE, DANIEL 2,023.54 LE, SON 2,869.73 LEITCH,JEFFREY 690.10 LEMKE, NEIL 1,725.66 LEVSEN, BRYAN 1,736.72 LINDSAY, MICHELLE 2,794.99 LOFTSGARD, MARA 517.16 LONG, JEREMY 3,083.80 LYNCH, JEREMY 1,333.46 LYON, LARRY 612.49 MANNING, JOSHUA 2,075.35 MAREAN, JOSHUA 1,456.61 MAREK, JAMES 814.41 MCCAY, BRENDA 283.86 MCCOY, CARA 447.31 MCKERN, DOUGLAS 220.35 MELLENCAMP, JEFFREY 2,890.37 MILBURN, HALEY 989.99 MINAR, VANESSA 806.64 MINIKUS, JOSHUA 1,883.21 MOERMAN, TIMOTHY 4,808.77 MORRIS, ASHLEY 1,465.94 MURRA, BRIAN 2,773.11 NELSON, DAVID 1,386.01 NICHOLS, ANDREW 1,807.95 OAKLEY, JON 1,917.73 OLBERDING, MCKENNA 1,529.63 OLDHAM, JAMES 605.80 OLSASKY, JOHN 573.85 OLSON, WILLIAM 174.22 t4f Employee Name Salary OSBORN, RYAN 597.64 OSBORN, SARAH 2,663.14 OSTRING, KATHLEEN 1,813.43 OWENS, TANNER 697.73 PARISH, TONJA 1,562.26 PATTERSON, KEVIN 1,620.84 PERDRIAU, MARIE 766.05 PERKINS, JACOB 1,841.26 PETERSON, KATIE 1,685.02 PETTIT, BRANDON 2,536.89 PIZINGER, JAMES 1,488.09 POARCH, ANDREW 815.56 PORTER, NICKOLAS 426.25 PUDENZ, DANIELLE 37.92 PURVIS, KATHRYN 1,461.75 QUINN, JOHN 3,693.23 RASH, RONALD 2,585.96 RICHARDSON, DACE 1,937.07 RICHARDSON, ELIZABETH 1,864.95 ROBBINS, CORBY 1,676.00 ROBINSON, CLINT 3,713.06 ROYER, TIMOTHY 3,103.82 SAENGKIO, DONNY 2,113.49 SAGER, AARON 359.54 SCHAUFENBUEL, KARI 688.53 SCHETTLER, RODNEY 2,318.07 SCHUETT, REBECCA 3,408.28 SCHULTZ, EMILY 2,229.96 SEDDON, JOSH 2,065.18 SHAFFER, CHET 369.99 SHARON, JEREMIAH 1,337.18 SINCLAIR, BENJAMIN 612.49 SMITH, BLAKE 1,476.97 SNOW, SUSAN 180.15 SOFEN, NATASHA 34.42 SOUKUP, JESSICA 98.66 SPOSETO, MACKENZIE 2,611.57 STEINKE, KURT 30.11 STEWARD, ERIC 2,003.34 STIFEL, DALTON 2,051.35 STOTZ, MELISSA 768.20 STRAIN, TIMOTHY 96.31 TAYLOR, CHRISTINA 50.81 TAYLOR, RILEY 66.03 THAYER, CHANDLER 2,080.13 THIES, ROBERT 152.39 TOBIS, SYDNEY 363.18 TYSDAL, THOMAS 3,102.54 VANDE KAMP, JOSHUA 2,232.26 VOEGTLE, TIMOTHY 1,673.02 WASKE, CHARLES 2,031.31 WAUGH, DOUGLAS 917.73 WEISS, OWEN 85.14 WERNIMONT, THOMAS 358.09 WERTS, DANIEL 2,048.36 WESTON STOLL, KERI 1,863.68 WHITE, JASON 1,541.73 WHITE, LEAH 1,595.79 WICKHAM, JOHN 1,513.93 WIGGINS, MATHEW 2,319.11 WILLIAMS, SUSAN 1,955.74 WINTERS, TROY 2,014.53 WISE, NATHAN 2,859.49 WOOD, DANIEL 1,100.35 4-) Employee Name Salary WRIGHT, PAUL 662.71 YOUSO, ANTHONY 1,467.88 *TOTALS* 282,508.44 My Check Report City of Waukee, IA By Check Number �-h Date Range: 08/31/2020 - 08/31/2020 Waukee i0/28/2020 3:12:47 PM Page 1 of 4 My Check Report Date Range: 08/31/2020 - 08/31/2020 Vendor Number Vendor Name Payment Date Payment Type Discount Amount Payment Amount Number Bank Code: AP-WAUKEE STATE 021100 BANK OF AMERICA 08/31/2020 Regular 0.00 9,746.57 144572 Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INVO010176 Invoice 07/18/2020 JULY 2020 STATEMENT 0.00 9,746.57 010-10.1100.280000 DUES, MEMBERSHIPS & S NASRO MEMBER DUES - GILCRH 40.00 010-10.1100.360000 POSTAGE & SHIPPING SHIPPING OF MMPI TO ACADE 15.82 010-10.1100.460200 PD COMMUNITY POLICIN KUM & GO REBATE -0.07 010-10.1100.460200 PD COMMUNITY POLICIN WATER 7.00 010-10.1100.470000 TRAINING/TRAVEL EXPEN CAKE - CICHOSKI PROMOTION 120.00 010-10.1100.470000 TRAINING/TRAVEL EXPEN TRAINING MATERIALS FOR CRI 13.52 010-10.1100.470000 TRAINING/TRAVEL EXPEN 6/29/2020 LUNCH - MINKUS FIR 16.71 010-10.1100.470000 TRAINING/TRAVEL EXPEN FARI & IMPARTIAL POLICING - S 145.00 010-10.1100.470000 TRAINING/TRAVEL EXPEN IMPLICIT BIAS SEMINAR - SPOSE 99.00 010-10.1100.540000 MINOR EQUIPMENT FILE CABINET 5.89 010-10.1100.590000 OPERATING SUPPLIES & EVIDENCE STORAGE 206.48 010-10.1100.590000 OPERATING SUPPLIES & FINGERPRINT INK PADS 65.99 010-10.1100.590000 OPERATING SUPPLIES & EVIDENCE STORAGE 47.04 010-10.1100.590000 OPERATING SUPPLIES & EVIDENCE SUPPLIES 75.81 010-10.1100.590000 OPERATING SUPPLIES & EVIDENCE SUPPLIES 73.40 010-10.1130.460220 COVID19 EMERGENCY EX FACE MASKS 74.88 010-10.1400.280000 DUES, MEMBERSHIPS & S NFPA MEMBER DUES - CLINT 87.50 010-10.1400,470000 TRAINING/TRAVEL EXPEN EFFECTIVE SOCIAL MEDIA POLIC 25.00 010-10.1400.470000 TRAINING/TRAVEL EXPEN TOP 5 CLIFTON STRENGTHS 63.57 010-10.1400.470000 TRAINING/TRAVEL EXPEN 7/13/2020INTERVIEW FOOD 15.26 010-10.1400.540000 MINOR EQUIPMENT FLOATING BLACKBOARD 217.66 010-10.1400.590000 OPERATING SUPPLIES & PEANUT BUTTER 2.50 010-10.1400.590000 OPERATING SUPPLIES & PEANUT BUTTER 8.88 010-10.1500.280000 DUES, MEMBERSHIPS & S NFPA MEMBER DUES - CLINT 87.50 010-10.1500.470000 TRAINING/TRAVEL EXPEN EFFECTIVE SOCIAL MEDIA POLIC 25.00 010-10.1500.470000 TRAINING/TRAVEL EXPEN PALS PROVIDER MANUAL 56.90 010-10.1500.470000 TRAINING/TRAVEL EXPEN TOP 5 CLIFTON STRENGTHS 63.57 010-10.1500.470000 TRAINING/TRAVEL EXPEN 7/13/2020 INTERVIEW FOOD 54.09 010-10.1500.470000 TRAINING/TRAVEL EXPEN PALS PROVIDER E-CARDS 380.00 010-10.1500.540000 MINOR EQUIPMENT IPAD AIR 194.73 010-10.1500.540000 MINOR EQUIPMENT FLOATING BLACKBOARD 771.71 010-10.1900.280000 DUES, MEMBERSHIPS & S MONTHLY SUBSCRIPTION ACCES 201.80 010-20.6010.400000 REPAIR/MAINTENANCE B APPLIANCE REPAIRS - MISSING 106.95 010-40.3100.210100 PROMOTION FACEBOOK ADVERTS 9.18 010-40.3100.270000 DATA PROCESSING 1YR SUBSCRIPTION SCANNER 19.80 010-40.3100.270000 DATA PROCESSING HOTSPOT SERVICE 120.00 010-40.3100.360000 POSTAGE & SHIPPING SHIPPING 15.48 010-40.3100.360000 POSTAGE & SHIPPING SHIPPING 49.77 010-40.3100.360000 POSTAGE & SHIPPING SHIPPING 26.81 010-40.3100.460300 PROGRAMS APPLE MUSIC SUBSCRIPTION 16.04 010-40.3100.470000 TRAINING/TRAVEL EXPEN ALA WEBINAR REGISTRATION - 59.00 010-40.3100.590000 OPERATING SUPPLIES & CONTAINERS 36.63 010-40.4100.360000 POSTAGE & SHIPPING SHIPPING 4.10 010-40.4200.460500 SUMMER RECREATION PR SUPER SNACKERS FOOD & SUPP 186.21 010-40.4200.460500 SUMMER RECREATION PR SUPER SNACKERS FOOD & SUPP 129.04 010-40.4200.460500 SUMMER RECREATION PR SUPER SNACKERS FOOD & SUPP 3.22 010-40.4200.460500 SUMMER RECREATION PR SUPER SNACKERS FOOD & SUPP 22.37 010-40.4200.460500 SUMMER RECREATION PR BABYSITTER TRAINING SETS 305.10 010-40.4200.540000 MINOR EQUIPMENT ICE RINK LINER 391.25 010-50.8700.470000 TRAINING/TRAVEL EXPEN APA CONFERENCE - KASS -820.00 010-50.8700.470000 TRAINING/TRAVEL EXPEN APA CONFERENCE - DEETS -825.00 010-60.8200.270100 COMPUTER SUPPORT MONTHLY ADOBE SUBSCRIPTIO 52.99 010-60.8200.270100 COMPUTER SUPPORT MONTHLY ADOBE SUBSCRIPTIO 52.99 010-60.8200.280000 DUES, MEMBERSHIPS & S DES MOINES REGISTER DIGITAL 73.83 010-60.8300.470000 TRAINING/TRAVEL EXPEN 7/13/20 COUNCIL WORK SESSIO 158.19 010-60.8300.470000 TRAINING/TRAVEL EXPEN SALES TAX REFUND -9.98 10/28/2020 3:12:47 PM aqe - .,' -• 4 My Check Report Date Range: 08/31/2020 - 08/31/2020 Vendor Number Vendor Name Payment Date Payment Type Discount Amount Payment Amount Number 010-60.8300.470000 TRAINING/TRAVEL EXPEN 6/18/20 COUNCIL WORK SESSIO 152.54 010-60.8310.540000 MINOR EQUIPMENT CITY HALL LOBBY BROCHURE RA 254.66 010-60.8350.689200 WELLNESS PROGRAM/ IN INTERNATIONAL TRANSACTION 12.60 010-60.8350.689200 WELLNESS PROGRAM/ IN SUPPLIES & WATER FOR BIOME 18.51 010-60.8350.689200 WELLNESS PROGRAM/ IN INTERNATIONAL TRANSACTION 12.60 010-60.8350.689200 WELLNESS PROGRAM/ IN SHIPPING FOR HYDRATION REM 33.12 010-60.8350.689200 WELLNESS PROGRAM/ IN HYDRATION REMINDERS - WATE 420.00 010-60.8350.689200 WELLNESS PROGRAM/ IN HYDRATION REMINDERS - WATE 420.00 010-60.8350.689200 WELLNESS PROGRAM/ IN HAND SANITIZER PENS 620.32 010-60.8800.270000 DATA PROCESSING INTERNATIONAL TRANSACTION 25.58 010-60.8800.270000 DATA PROCESSING INTERNATIONAL TRANSACTION 6.30 010-60.8800.270000 DATA PROCESSING PROJECT MANAGEMENT SOFTW 852.41 010-60.8800.270000 DATA PROCESSING IT ADMIN SOFTWARE 48.05 010-60.8800.270000 DATA PROCESSING LICENSE & SUPPORT FOR EXCHA 1,259.00 010-60.8800.270000 DATA PROCESSING IT ADMIN SOFTWARE -2.72 010-60.8800.270000 DATA PROCESSING INTERNATIONAL TRANSACTION 37.77 010-60.8800.270100 COMPUTER SUPPORT LICENSE & SUPPORT FOR EXCHA 210.00 010-60.8800.470000 TRAINING/TRAVEL EXPEN 6/22/20 ITADMINS WELCOM L 33.10 010-60.8800.540000 MINOR EQUIPMENT PAYPAL REFUND -258.70 010-60.8800.540000 MINOR EQUIPMENT NETWORK CABLES EQUIPMENT 191.80 010-60.8800.540000 MINOR EQUIPMENT CAMERA POWER ADAPTERS 378.22 010-60.8800.540000 MINOR EQUIPMENT PAYPAL TRANSACTION - REFUND 258.70 510-30.6510.280000 DUES, MEMBERSHIPS & S AWWA MEMBER DUES - RUDY 245.00 510-30.6510.470000 TRAINING/TRAVEL EXPEN 7/4/20-7/6/20 HOTEL ROOM LI 349.04 510-30.6510.470000 TRAINING/TRAVEL EXPEN 7/4/20-7/5/20 HOTEL ROOM LI 523.56 560-80.5300.270100 COMPUTER SUPPORT STORMWATER INSPECTION APP 114.00 750-80.8750.590000 OPERATING SUPPLIES & HOLE IN ONE ENGRAVING 85.00 Bank Code AP Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 1 1 0.00 9,746.57 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 1 1 0.00 9,746.57 10/28/2020 3:12:47 PM Page 3 of 4 My Check Report 4Q Date Range: 08/31/2020 - 08/31/2020 All Bank Codes Check Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 1 1 0.00 9,746.57 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 1 1 0.00 9,746.57 Fund Summary Fund Name Period Amount 999 POOLED CASH 8/2020 9,746.57 9,746.57 10/28/2020 3:12:47 PM Page 4 of 4