Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2017-06-19-J01A 06192017_bill list_payroll
City of Waukee Bill Presentation Recap June 19, 2017 Total Unpaid Bills Presented for Approval : Total Checks Issued Prior to Council Approval: Regular Checks: A) Prior to Last Council Meeting B) After Last Council Meeting C) Payroll Taxes & Reimbursements D) Utility Refunds Payroll Checks Issued: E) 05/3112017 FY 2017 Fund Recap: 010 General Fund 060 Road Use Tax Fund 075 Waukee 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 110 Debt Service Fund 111 Special Assessments Fund 210 Employee Benefits 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 $682,616.19 $1,651.60 $2,144.04 $238, 936.39 $2,084.52 $229,673.21 Grand Total: $1,157,105.95 � y ao►� Expenditures Budgeted Year To Date 9,736,705 $ 2,145,066 $ 421,355 232,550 2,988,360 6,951,481 45,698 1,500,285 11,653,500 3,910,801 7,003,697 5,590,810 1,148,970 264,790 1,081,760 507,595 9,695,760 1,948,574 4,749 382,686 15,580 521 8,676,557 45,698 6,856,428 2,855,258 8,118,800 3,903,746 730,774 222,412 1,100,827 546,091 Revenues Budgeted Year To Date $ 9,520,350 $ 1,822,167 $ 576,400 $ 600 $ 2,780,500 $ 6,999,755 $ 42,200 $ 1,504,285 $ 11,653,500 $ 3,671,507 $ 3,714,066 $ 5,491,100 $ 891,150 $ 264,750 $ 1,101,160 $ 592,300 $ 30,000 $ 10,387,159 $ 1,940,862 $ 60,950 $ 421 $ 593,737 $ 1,797 $ 2,824,394 $ 4,555,251 $ 34,352 $ 1,503,829 $ 1,507,816 $ 11,741 $ 4,196,439 $ 4,729,716 $ 7,349 $ 197 $ 691 $ 5,391,481 $ 909,321 $ 196,988 $ 1,081,901 $ 507,759 $ 755 Total: $ 55,183,423 $ 45,104,459 $ 50,655,790 $ 40,444,905 City of Waukee FY2017 Department Report - General Fund As of June 19th , 2017 Expended YTD Budgeted $ Remaining General Fund: Police Department Personnel Services $ 2,046,656 Supplies & Services $ 289,973 Capital Outlay $ 139,526 $ 2,476,155 $ 2,661,080 $ 184,925 Warning Sirens Personnel Services $ 989 Supplies & Services $ - CapitalOutlay $ $ 989 $ 2,000 $ 1,011 Westcom Dispatch Personnel Services $ - Supplies & Services $ 448,608 Capital Outlay $ - $ 448,608 $ 430,500 $ (18,108) Fire Department Personnel Services $ 630,870 Supplies & Services $ 80,893 Capital Outlay $ - $ 711,763 $ 830,720 $ 118,957 EMS Personnel Services $ 624,616 Supplies & Services $ 84,942 Capital Outlay $ - $ 709,557 $ 762,600 $ 53,043 Building Inspection Personnel Services $ 290,220 Supplies & Services $ 18,981 Capital Outlay $ 33,639 $ 342,840 $ 398,830 $ 55,990 Animal Control Personnel Services Supplies & Services $ 6,180 Capital Outlay $ 6,180 $ 1,000 $ (5,180) Library Services Personnel Services $ 526,690 Supplies & Services $ 183,319 Capital Outlay $ - $ 710,009 $ 852,275 $ 142,266 Mosquito Control Personnel Services $ Supplies & Services $ Capital Outlay $ - $ - $ 6,500 $ 6,500 Parks Personnel Services $ 236,099 Supplies & Services $ 147,647 Capital Outlay $ 96,639 $ 480,384 $ 480,297 $ (87) Recreation Personnel Services $ 319,578 Supplies & Services $ 173,799 Capital Outlay $ - $ 493,377 $ 523,662 $ 30,285 Community Center Personnel Services $ 3,823 Supplies & Services $ 13,314 Capital Outlay $ - $ 17,137 $ 24,320 $ 7,183 Public Works Personnel Services $ 154,861 Supplies & Services $ (4,553) Capital Outlay $ $ 150,308 $ 73,644 $ (76,664) Public Works Building Personnel Services $ - Supplies & Services $ 157,678 Capital Outlay $ 10,500 $ 168,178 $ - $ (168,178) Public Works Mechanic Personnel Services $ 161,921 Supplies & Services $ 151,506 Capital Outlay $ - $ 313,427 $ 171,750 $ (141,677) Median and Bldg Grounds Personnel Services Supplies & Services $ 11,322 Capital Outlay $ 11,322 $ 14,000 $ 2,678 Mayor & Council Personnel Services $ 31,967 Supplies & Services $ 23,465 Capital Outlay $ - $ 55,433 $ 72,840 $ 17,407 Elections Personnel Services $ Supplies & Services $ Capital Outlay $ - $ - $ 8,000 $ 8,000 Communications Personnel Services $ 63,698 Supplies & Services $ 14,049 Capital Outlay $ - $ 77,747 $ 114,808 $ 37,061 Administration Personnel Services $ 202,045 Supplies & Services $ 145,387 Capital Outlay $ 513,204 $ 860,636 $ 348,250 $ (512,386) City Hall Personnel Services $ - Supplies & Services $ 55,397 Capital Outlay $ - $ 55,397 $ 79,000 $ 23,603 Human Resources Personnel Services $ 79,069 Supplies & Services $ 8,407 Capital Outlay $ - $ 87,476 $ 80,138 $ (7,338) Financial Administration Personnel Services $ 155,850 Supplies & Services $ 32,843 Capital Outlay $ - $ 188,692 $ 198,922 $ 10,230 Community Development Personnel Services $ 204,015 Supplies & Services $ 104,409 Capital Outlay $ - $ 308,424 $ 324,240 $ 15,816 City Attorney Personnel Services $ - Supplies & Services $ 176,474 Capital Outlay $ - $ 176,474 $ 100,000 $ (76,474) Development Services Personnel Services $ 287,994 Supplies & Services $ 73,124 Capital Outlay $ - $ 361,117 $ 524,535 $ 163,418 Information Technology Personnel Services $ 1,521 Supplies & Services Capital Outlay $ 5,272 $ 6,793 $ - $ (6,793) Engineering Personnel Services $ 350,102 GIS Supplies & Services Capital Outlay Personnel Services Supplies & Services Capital Outlay Transfers to GO Debt Service Total General Fund: $ 66,090 $ 12,924 $ 39,103 $ (3,805) $ 12,924 Personnel Services $ 6,411,685 Supplies & Services $ 2,459,449 Capital Outlay $ 824,626.11 429,115 $ 625,139 $ 196,024 48,221 $ 27,655 $ (20,566) $ 9,695,760 $ 9,736,705 $ 40,945 $ 9,695,760 Expense Approval Register City of Waukee, IA 0M \mice - :ket: APPKT00637 - JUNE 20TH COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount TREASURER STATE OF IOWA INV0003059 05/31/2017 MAY'17 WATER SALES TAXE 510-2030500 18,629.42 TREASURER STATE OF IOWA INV0003060 05/31/2017 MAY'17 SEWER SALES TAXE 520-2030500 2,173.01 TREASURER STATE OF IOWA INV0003061 05/31/2017 MAY'17 GAS SALES TAXES 540-2030500 1,948.16 TREASURER STATE OF IOWA INV0003062 05/31/2017 MAY'17 STORM WATER SAL 560-2030500 1,202.08 TREASURER STATE OF IOWA INV0003063 05/31/2017 MAY'17 GOLF COURSE SALE 750-2030500 2,678.02 TREASURER STATE OF IOWA INV0003064 05/31/2017 MAY'17 PARK &REC SALES 010-2030500 430.20 27,060.89 Department: 1100 - POLICE OPERATIONS SIRCHIE FINGER PRINT LAB 0303216-IN 06/01/2017 FLAWLESS REPLACEMENT PA 010-10.1100.590000 149.20 EMPLOYEE BENEFIT SYSTEM 10693 06/13/2017 JUL'17 HEALTH INSURANCE 010-10.1100.100000 28,478.31 HEARTLAND TIRE &AUTO 122638 06/02/2017 TIRE 010-10.1100.560000 247.11 HEARTLAND TIRE &AUTO 122728 06/07/2017 TIRES 010-10.1100.560000 242.99 ORKIN PEST CONTROL 158152135 06/19/2017 PEST CONTROL -P.D. 010-10.1100.400000 105.28 RI LAWN SERVICE INC 20037 06/05/2017 WEED CONTROL -PUBLIC SA 010-10.1100.400000 109.64 CITY OF WAUKEE - AR 201704137174 02/28/2017 PARTS 010-10.1100.410050 92.75 CITY OF WAUKEE - AR 201704137174 02/28/2017 LABOR 010-10.1100.410050 90.00 CITY OF WAUKEE - AR 201704137187 03/31/2017 LABOR 010-10.1100.410050 135.00 CITY OF WAUKEE - AR 201704137187 03/31/2017 PARTS 010-10.1100.410050 152.99 IOWA DEPT OF PUBLIC SAFE 2017-3 06/08/2017 2017 IOWA SOR SYMPOSIU 010-10.1100.470000 45.00 CITY OF URBANDALE 2017-40000293 05/31/2017 SERT REIMBURSEMENT 010-10.1100.470000 500.00 KENNY&GYL COMPANY 41799 05/16/2017 GERBER REPAIRS TO POLICE 010-10.1100.410050 285.00 CARPENTER UNIFORM CO 441035 05/26/2017 POLO-CICHOSKI 010-10.1100.120000 49.29 CARPENTER UNIFORM CO 441055 05/26/2017 NAMETAG- TERLOUW 010-10.1100.120000 34.98 CARPENTER UNIFORM CO 441111 05/26/2017 SHIRT -KERR 010-10.1100.120000 58.99 CARPENTER UNIFORM CO 441121 05/26/2017 SHIRT- MINIKUS 010-10.1100.120000 176.97 CARPENTER UNIFORM CO 441441 06/01/2017 SHIRT-ARMSTRONG 010-10.1100.120000 58.99 CARPENTER UNIFORM CO 441934 06/08/2017 KEY CLIP HANDCUFF KEY - A 010-10.1100.120000 14.99 CARPENTER UNIFORM CO 441937 06/08/2017 PARACORD LACES 010-10.1100.120000 6.99 CARPENTER UNIFORM CO 442078 06/09/2017 HANDCUFF STRAP -MURRA 010-10.1100.120000 36.97 CARPENTER UNIFORM CO 442089 06/09/2017 PANTS-CICHOSKI 010-10.1100.120000 74.99 BROKEN ARROW WEAR 604407 05/16/2017 T-SHIRTS 010-10.1100.460200 2,398.17 NATIONWIDE OFFICE CLEAN 62247 05/30/2017 WINDOW CLEANING -P.D. 010-10.1100.400100 360.00 ADECCO EMPLOYMENT SER 68580942 06/05/2017 CONTRACT LABOR - RHEA 010-10.1100.230000 509.99 PRORIDER, INC. 72035 06/01/2017 HELMETS 010-10.1100.460200 53.60 BOUND TREE MEDICAL 82499055 05/17/2017 CPR POCKET MASK 010-10.1100.540000 35.92 OFFICE DEPOT 926990525001 05/11/2017 COFFEE/CUPS/TISSUE/ENVEL 010-10.1100.580000 112.48 OFFICE DEPOT 926990754001 05/12/2017 COFFEE 010-10.1100.590000 41.97 OFFICE DEPOT 927651570001 05/15/2017 BINDERS/WASTE BIN/CREA 010-10.1100.580000 88.73 OFFICE DEPOT 927651570001 05/15/2017 BINDERS/WASTE BIN/CREA 010-10.1100.590000 13.98 PRIMEPOINT POLYGRAPH I-CWPD001 05/07/2017 PRE -EMPLOYMENT POLYGR 010-10.1100.470000 350.00 PRIMEPOINT POLYGRAPH I-CWPDO02 05/07/2017 PRE -EMPLOYMENT POLYGR 010-10.1100.470000 350.00 WAUKEE HARDWARE & VARI INV0003102 05/31/2017 MAY'17 STATEMENT-POLIC 010-10.1100.460200 125.61 IOWA COMMUNITIES ASSUR INV0003105 06/01/2017 PD SETTLEMENT-RENZE010-10.1100.230000 2,000.00 CONSOLIDATED COMMUNIC INV0003110 06/08/2017 JUNE'17 STATEMENT-POLI010-10.1100.450000 355.26 CONSOLIDATED COMMUNIC INV0003111 06/08/2017 JUNE'17 STATEMENT 010-10.1100.450000 83.11 CONSOLIDATED COMMUNIC INV0003111 06/08/2017 JUNE'17 STATEMENT 010-10.1100.450000 49.27 AMERITAS LIFE INSURANCE JUN17 06/01/2017 JUN'17 VISION INSURANCE 010-10.1100.100000 422.92 CITY OF WAUKEE MAY17110140150 05/31/2017 MAY'17 STATEMENT 010-10,1100.480000 255.99 MAS MODERN MARKETING MM1121934 05/26/2017 CUSTOM STICKERS 010-10.1100.460200 162.68 Department 1100 - POLICE OPERATIONS Total: 38,916.21 Department: 1300- WESTCOM DISPATCH CITY OF WEST DES MOINES FN-2017-00000221 06/02/2017 JUNE'17 WESTCOM 010-10.1300.230010 33,763.09 Department 1300 - WESTCOM DISPATCH Total: 33,763.09 6/14/2017 2:19:45 PM Page 1 of 16 Expense Approval Register Packet: APPKTOO637 - JUNE 20TH COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount Department: 1400 - FIRE PROTECTION UNITED PARCEL SERVICE OOOOAW7647217 05/27/2017 SHIPPING 010-10.1400.360000 16.15 GOODWIN TUCKER GROUP 0019912 06/07/2017 ICE MACHINE POWER SWITC 010-10.1400.400000 8.17 ED M FELD EQUIPMENT CO 0312797-IN 06/02/2017 GASKET PARTS 010-10.1400.410100 53.00 EMPLOYEE BENEFIT SYSTEM 10693 06/13/2017 JUL'17 HEALTH INSURANCE 010-10.1400.100000 7,095.21 KELTEK INCORPORATED 15648 05/24/2017 NEW AMBULANCE COMPUT 010-10.1400.270000 100.61 RI LAWN SERVICE INC 20037 06/05/2017 WEED CONTROL -PUBLIC SA 010-10.1400.400000 72.68 WESTSIDE PARTS & SERVICE 276824 05/26/2017 DRYER REPAIR 010-10.1400.410100 93.44 VIED COMPASS 31541 05/25/2017 HAZMAT PHYSICAL/QUANTI 010-10.1400.110100 1,099.00 ADEL AUTO PARTS 358420 05/26/2017 RELAY 010-10.1400.410000 25.98 ASPEN EQUIPMENT COMPA 40031300 05/22/2017 HYDRAULIC LEAKS REPAIR 010-10.1400.410000 1,190.00 KUM&GO 49970465 05/31/2017 JUNE'17 STATEMENT 010-10.1400.570000 475.00 THE WALDI NGER CORP 5774269-1 05/11/2017 REPAIRS TO EXHAUST FAN 010-10.1400.400000 39.75 CROSS DILLON TIRE, INC. 7344350 05/30/2017 FLAT REPAIR/SHOP SUPPLIES 010-10.1400.410000 130.50 MENARDS 81218 05/23/2017 STRAPS 010-10.1400.540000 31.89 NAPA AUTO PARTS STORE 939612 06/04/2017 BRAKE CALIPER/CORE DEPOS 010-10.1400.410000 163.04 NAPA AUTO PARTS STORE 939613 06/04/2017 BFLUID DOT 3-32OZ 010-10.1400.410000 3.49 NAPA AUTO PARTS STORE 939616 06/04/2017 BRAKE ROTOR 010-10.1400.410000 63.99 NAPA AUTO PARTS STORE 939621 06/04/2017 CORE DEPOSIT 010-10.1400.410000 -70.18 NAPA AUTO PARTS STORE 939632 06/04/2017 BRAKE MASTER CYLINDER 010-10.1400.410000 72.39 TOYNEINC INOOOSO06 05/23/2017 VPS POWER SHIFTAND CON 010-10.1400.410000 51.15 TOYNEINC in0005037 05/30/2017 GEARSHAFT REPLACEMENT 010-10.1400.410000 946.00 WAUKEE HARDWARE & VARI INV0003101 05/31/2017 MAY'17 STATEMENT- FIRE 010-10.1400.410100 48.93 CONSOLIDATED COMMUNIC INV0003111 06/08/2017 JUNE'17 STATEMENT 010-10.1400.450000 49.27 CONSOLIDATED COMMUNIC INV0003111 06/08/2017 JUNE'17 STATEMENT 010-10.1400.450000 45.67 AMERITAS LIFE INSURANCE JUN17 06/01/2017 JUN'17 VISION INSURANCE 010-10.1400.100000 100.68 CITY OF WAUKEE MAY17110140150 05/31/2017 MAY'17 STATEMENT 010-10.1400.480000 169.67 UNPLUGGED WIRELESS SPRININS0490 05/25/2017 PAGER BELT CLIPS 010-10.1400.120000 29.98 Department 1400 - FIRE PROTECTION Total: 12,105.46 Department: 1500 - EMS GOODWIN TUCKER GROUP 0019912 06/07/2017 ICE MACHINE POWER SWITC 010-10.1500.400000 8.16 KLOCKE'S EMERGENCY VEHI 005951 06/06/2017 STAIR CHAIR STRAP 010-10.1500.410000 53.07 FRUSA EMS 10629 04/07/2017 MARCH 17 AMBULANCE BILL 010-10.1500.231800 1,093.59 EMPLOYEE BENEFIT SYSTEM 10693 06/13/2017 JUL'17 HEALTH INSURANCE 010-10.1500.100000 7,095.20 FRUSA EMS 10721 06/07/2017 MAY'17 AMBULANCE BILLIN 010-10.1500.231800 1,823.16 KELTEK INCORPORATED 15648 05/24/2017 NEW AMBULANCE COMPUT 010-10.1500.270000 100.61 RJ LAWN SERVICE INC 20037 06/05/2017 WEED CONTROL -PUBLIC SA 010-10.1500.400000 72.68 WESTSIDE PARTS&SERVICE 276824 05/26/2017 DRYER REPAIR 010-10.1500.410100 93.44 MED COMPASS 31541 05/25/2017 HAZMAT PHYSICAL/QUANTI 010-10.1500.110100 1,099.00 KUM&GO 49970465 05/31/2017 JUNE'17 STATEMENT 010-10.1500.570000 474.99 THE WALDINGER CORP 5774269-1 05/11/2017 REPAIRS TO EXHAUST FAN 010-10.1500.400000 39.75 BOUND TREE MEDICAL 82505044 05/23/2017 MEDICAL SUPPLIES 010-10.1500.590050 229.88 BOUND TREE MEDICAL 82517633 06/05/2017 MEDICAL SUPPLIES 010-10.1500.590050 611.96 UNITYPOINT HEALTH 9020IN2339 06/01/2017 BIOCHEMICALS WORK ORDE 010-10.1500.590000 62.50 NAPA AUTO PARTS STORE 939612 06/04/2017 BRAKE CALIPER/CORE DEPOS 010-10.1500.410000 163.03 NAPA AUTO PARTS STORE 939613 06/04/2017 BFLUID DOT 3-320Z 010-10.1500.410000 3.50 NAPA AUTO PARTS STORE 939616 06/04/2017 BRAKE ROTOR 010-10.1500.410000 63.99 NAPA AUTO PARTS STORE 939621 06/04/2017 CORE DEPOSIT 010-10.1500.410000 -70.18 NAPA AUTO PARTS STORE 939632 06/04/2017 BRAKE MASTER CYLINDER 010-10.1500.410000 72.39 MERCY COLLEGE OF HEALTH INV0003053 06/04/2017 PROGRAM -AIRWAY/RESPIR 010-10.1500.590050 10.00 WAUKEE HARDWARE & VARI INV0003101 05/31/2017 MAY'17 STATEMENT - FIRE 010-10.1500.410100 48.93 CONSOLIDATED COMMUNIC INV0003111 06/08/2017 JUNE'17 STATEMENT 010-10.1500.450000 45.67 CONSOLIDATED COMMUNIC INV0003111 06/08/2017 JUNE'17 STATEMENT 010-10.1500.450000 49.26 AMERITAS LIFE INSURANCE JUN17 06/01/2017 JUN'17 VISION INSURANCE 010-10.1500.100000 100.67 CITY OF WAUKEE MAY17110140150 05/31/2017 MAY'17 STATEMENT 010-10.1500.480000 169.66 UNPLUGGED WIRELESS SPRININS0490 05/25/2017 PAGER BELT CLIPS 010-10.1500.120000 29.98 Department 1500 - EMS Total: 13,544.89 Department: 1600 - STREET LIGHTING IOWA SIGNAL INC 3581 05/31/2017 HICKMAN RD & WARRIOR LA 060-30.1600.410300 265.00 6/14/2017 2:19:45 PM Page 2 of 16 Expense Approval Register Packet: APPK700637 - JUNE 20TH COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount MID AMERICAN ENERGY MAY171600SUMBILL 05/24/2017 MAY'17 STATEMENT 060-30.1600.480000 16,859.57 Department 1600 - STREET LIGHTING Total: 17,124.57 Department: 1601- TRAFFIC SIGNALS SNYDER & ASSOCIATES INC 114.0475.01-17 05/30/2017 HICKMAN RD & DARTMOOR 327-90.1601.235020 430.50 AHLERS & COONEY PC 729865 05/30/2017 US HWY 6/HICKMAN RD/WE 327-90.1601.235030 1,800.00 MID AMERICAN ENERGY MAY171601SUM BILL 05/24/2017 MAY'17 STATEMENT 060-30.1601.480000 526.32 Department 1601- TRAFFIC SIGNALS Total: 2,756.82 Department: 1900 - BUILDING INSPECTION EMPLOYEE BENEFIT SYSTEM 10693 06/13/2017 JUL'17 HEALTH INSURANCE 010-10.1900.100000 4,234.44 AMERITAS LIFE INSURANCE JUN17 06/O1/2017 JUN'17 VISION INSURANCE 010-10.1900.100000 75.84 Department 1900 - BUILDING INSPECTION Total: 4,310.28 Department: 2130 - ALICES ROAD PROJECT SNYDER & ASSOCIATES INC 117.0234DIC-2 05/30/2017 ALICES ROAD PHASE 4 327-90.2130,840490 4,370.80 CITY OF WAUKEE - AR 201705117244 03/31/2017 ALICE'S RD PHASE 5 327-90.2130.840491 675.00 CITY OF WAUKEE - AR 201705117245 03/31/2017 ALICE'S RD PHASE 4 327-90.2130.840490 112.50 Department 2130 -ALICES ROAD PROJECTTotal: 5,158.30 Department: 2131 - ESKER RIDGE - RISE PROJECT AHLERS & COONEY PC 729864 05/30/2017 SE ESKER RIDGE DRIVE & GP 327-90.2131.230051 1,800.00 Department 2131- ESKER RIDGE - RISE PROJECT Total: 1,800.00 Department: 2150 - PARK & REC COMPLEX CONFLUENCE 14214 05/31/2017 WAUKEE SCHOOLS - CITY SIT 327-90.2150.980110 1,012.50 FOTH INFRASTRUCTURE & E 50842 01/06/2017 HIGH SCHOOL NO. 2/ CITY R 327-90.2150.980110 3,202.00 Department 2150 - PARK & REC COMPLEX Total: 4,214.50 Department: 2400 - ANIMAL CONTROL BRODERICK ANI MAL CLI NIC 151528 05/26/2017 CANINE/FELINE BOARDING 010-10.2400.340000 480.00 Department 2400 - ANIMAL CONTROL Total: 480.00 Department: 3100 - LIBRARY SERVICES FAREWAY STORES, INC. 00246015 06/07/2017 POPCORN 010-40.3100.460300 1.69 EMPLOYEE BENEFIT SYSTEM 10693 06/13/2017 JUL'17 HEALTH INSURANCE 010-40.3100.100000 7,924.82 BAKER MECHANICAL, INC. 134936 05/30/2017 REPAIR AIR CONDITIONER 010-40.3100.400000 1,000.32 BUDGET LIBRARY SUPPLIES 15579 06/01/2017 VOYAGERSCANNER 010-40.3100.540000 378.00 ORKIN PEST CONTROL 158151023 06/19/2017 PEST CONTROL - LIBRARY 010-40.3100.400000 68.61 WASH -ECLAIR 189485 05/29/2017 WINDOW CLEANING-LIBRA 010-40.3100.400100 485.00 DEMCO INC. 7120249 05/23/2017 LABEL PROTECTORS/CDS/HE 010-40.3100.590000 249.14 CINTAS CORPORATION 762510606 03/17/2017 BATHROOM CLEANING - LIB 010-40.3100.400100 166.00 CINTAS CORPORATION 762524714 05/26/2017 TRAFFIC AND SCRAPER MAT 010-40.3100.400100 38.51 OFFICE DEPOT 927795801001 05/17/2017 HDMI 010-40.3100.580000 40.38 OFFICE DEPOT 927796020001 05/15/2017 TAPE/SANITIZING SPRAY/PO 010-40.3100.580000 45.18 OFFICE DEPOT 929162421001 05/19/2017 PAPER/COFFEE/WIPES/TISSU 010-40.3100.580000 119.30 INGRAM LIBRARY SERVICES 98592404 05/21/2017 BOOKS 010-40.3100.590000 1.19 INGRAM LIBRARY SERVICES 98592404 05/21/2017 BOOKS 010-40.3100.640000 14.95 INGRAM LIBRARY SERVICES 98623278 05/23/2017 BOOKS 010-40.3100.590000 1.39 INGRAM LIBRARY SERVICES 98623278 05/23/2017 BOOKS 010-40.3100.640000 13.22 INGRAM LIBRARY SERVICES 98623279 05/23/2017 BOOKS 010-40.3100.590000 3.24 INGRAM LIBRARY SERVICES 98623279 05/23/2017 BOOKS 010-40.3100.640000 8.99 INGRAM LIBRARY SERVICES 98623280 05/23/2017 BOOKS 010-40.3100.590000 1.39 INGRAM LIBRARY SERVICES 98623280 05/23/2017 BOOKS 010-40.3100.640000 20.13 INGRAM LIBRARY SERVICES 98623281 05/23/2017 BOOKS 010-40.3100.590000 2.20 INGRAM LIBRARY SERVICES 98623283 05/23/2017 BOOKS 010-40.3100.640000 30.17 INGRAM LIBRARY SERVICES 98623282 05/23/2017 BOOKS 010-40.3100.590000 40.44 INGRAM LIBRARY SERVICES 98623282 05/23/2017 BOOKS 010-40.3100.640000 157.88 INGRAM LIBRARY SERVICES 98623283 05/23/2017 BOOKS 010-40.3100.590000 48.35 INGRAM LIBRARY SERVICES 98623283 05/23/2017 BOOKS O10-40.3100.640000 219.64 INGRAM LIBRARY SERVICES 98623284 05/23/2017 BOOKS 010-40.3100.590000 1.85 INGRAM LIBRARY SERVICES 98623284 05/23/2017 BOOKS 010-40.3100.640000 4.79 INGRAM LIBRARY SERVICES 98623285 05/23/2017 BOOKS 010-40.3100.590000 2.24 INGRAM LIBRARY SERVICES 98623285 05/23/2017 BOOKS 010-40.3100.640000 22.49 INGRAM LIBRARY SERVICES 98623286 05/23/2017 BOOKS 010-40.3100.590000 1.19 6/14/2017 2:19:45 PM Page 3 of 16 Expense Approval Register Packet: APPKT00637 -DUNE 20TH COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount INGRAM LIBRARY SERVICES 98623286 05/23/2017 BOOKS 010-40.3100.640000 16.09 INGRAM LIBRARY SERVICES 98623287 05/23/2017 BOOKS 010-40.3100.590000 2.38 INGRAM LIBRARY SERVICES 98623287 05/23/2017 BOOKS 010-40.3100.640000 32.78 INGRAM LIBRARY SERVICES 98642410 05/24/2017 BOOKS 010-40.3100.590000 1.85 INGRAM LIBRARY SERVICES 98642410 05/24/2017 BOOKS 010-40.3100.640000 4.19 INGRAM LIBRARY SERVICES 98642412 05/24/2017 BOOKS 010-40.3100.590000 5.54 INGRAM LIBRARY SERVICES 98642412 05/24/2017 BOOKS 010-40.3100.640000 8.38 INGRAM LIBRARY SERVICES 98642413 05/24/2017 BOOKS 010-40,3100.590000 2.50 INGRAM LIBRARY SERVICES 98642413 05/24/2017 BOOKS 010-40.3100.640000 9.59 INGRAM LIBRARY SERVICES 98642414 05/24/2017 BOOKS 010-40.3100.590000 0.65 INGRAM LIBRARY SERVICES 98642414 05/24/2017 BOOKS 010-40.3100.640000 15.52 INGRAM LIBRARY SERVICES 98661868 05/25/2017 BOOKS 010-40.3100.590000 1.39 INGRAM LIBRARY SERVICES 98661868 05/25/2017 BOOKS 010-40.3100.640000 10.34 INGRAM LIBRARY SERVICES 98661869 05/25/2017 BOOKS 010-40.3100.590000 3.24 INGRAM LIBRARY SERVICES 98661869 05/25/2017 BOOKS 010-40.3100.640000 4.79 INGRAM LIBRARY SERVICES 98661870 05/25/2017 BOOKS 010-40.3100.590000 6.48 INGRAM LIBRARY SERVICES 98661870 05/25/2017 BOOKS 010-40.3100.640000 19.76 INGRAM LIBRARY SERVICES 9866187 05/25/2017 BOOKS 010-40.3100.590000 3.80 INGRAM LIBRARY SERVICES 9866187 05/25/2017 BOOKS 010-40.3100.640000 21.99 INGRAM LIBRARY SERVICES 98661871 05/25/2017 BOOKS 010-40.3100.590000 8.89 INGRAM LIBRARY SERVICES 98661871 05/25/2017 BOOKS 010-40.3100.640000 31.62 INGRAM LIBRARY SERVICES 98661872 05/25/2017 BOOKS 010-40.3100.640000 27.35 INGRAM LIBRARY SERVICES 98661873 05/25/2017 BOOKS 010-40.3100.590000 1.59 INGRAM LIBRARY SERVICES 98661873 05/25/2017 BOOKS 010-40.3100.640000 15.53 INGRAM LIBRARY SERVICES 98661874 05/25/2017 BOOKS 010-40.3100.590000 2.70 INGRAM LIBRARY SERVICES 98661874 05/25/2017 BOOKS 010-40.3100.640000 6.59 INGRAM LIBRARY SERVICES 98661875 05/25/2017 BOOKS 010-40.3100.590000 2.20 INGRAM LIBRARY SERVICES 98661875 05/25/2017 BOOKS 010-40.3100.640000 59.98 INGRAM LIBRARY SERVICES 98661876 05/25/2017 BOOKS 010-40.3100.590000 1.10 INGRAM LIBRARY SERVICES 98661876 05/25/2017 BOOKS 010-40.3100.640000 22.49 INGRAM LIBRARY SERVICES 98661878 05/25/2017 BOOKS 010-40.3100.640000 22.49 INGRAM LIBRARY SERVICES 98661879 05/25/2017 BOOKS 010-40.3100.640000 44.98 INGRAM LIBRARY SERVICES 98673552 05/26/2017 BOOKS 010-40.3100.590000 1.19 INGRAM LIBRARY SERVICES 98673552 05/26/2017 BOOKS 010-40.3100.640000 14.95 INGRAM LIBRARY SERVICES 98685738 05/28/2017 BOOKS 010-40.3100.590000 3.18 INGRAM LIBRARY SERVICES 98685738 05/28/2017 BOOKS 010-40.3100.640000 28.17 INGRAM LIBRARY SERVICES 98685739 05/28/2017 BOOKS 010-40.3100.590000 1.39 INGRAM LIBRARY SERVICES 98685739 05/28/2017 BOOKS 010-40.3100.640000 10.34 INGRAM LIBRARY SERVICES 98685740 05/28/2017 BOOKS 010-40.3100.590000 1.39 INGRAM LIBRARY SERVICES 98685740 05/28/2017 BOOKS 010-40.3100.640000 8.04 INGRAM LIBRARY SERVICES 98685741 05/28/2017 BOOKS 010-40.3100.590000 20.76 INGRAM LIBRARY SERVICES 98685741 05/28/2017 BOOKS 010-40.3100.640000 87.50 INGRAM LIBRARY SERVICES 98685742 05/28/2017 BOOKS 010-40.3100.590000 2.78 INGRAM LIBRARY SERVICES 98685742 05/28/2017 BOOKS 010-40.3100.640000 23.03 INGRAM LIBRARY SERVICES 98685743 05/28/2017 BOOKS 010-40.3100.590000 4.17 INGRAM LIBRARY SERVICES 98685743 05/28/2017 BOOKS 010-40.3100.640000 41.34 INGRAM LIBRARY SERVICES 98685744 05/28/2017 BOOKS 010-40.3100.590000 25.10 INGRAM LIBRARY SERVICES 98685744 05/28/2017 BOOKS 010-40.3100.640000 181.14 INGRAM LIBRARY SERVICES 98685745 05/28/2017 BOOKS 010-40.3100.590000 13.50 INGRAM LIBRARY SERVICES 98685745 05/28/2017 BOOKS 010-40.3100.640000 41.90 INGRAM LIBRARY SERVICES 98685746 05/28/2017 BOOKS 010-40.3100.590000 8.55 INGRAM LIBRARY SERVICES 98685746 05/28/2017 BOOKS 010-40.3100.640000 28.78 INGRAM LIBRARY SERVICES 98685747 05/28/2017 BOOKS 010-40.3100.590000 1.39 INGRAM LIBRARY SERVICES 98685747 05/28/2017 BOOKS 010-40.3100.640000 11.49 INGRAM LIBRARY SERVICES 98685748 05/28/2017 BOOKS 010-40.3100.590000 4.63 INGRAM LIBRARY SERVICES 98685748 05/28/2017 BOOKS 010-40.3100.640000 12.86 INGRAM LIBRARY SERVICES 98685749 05/28/2017 BOOKS 010-40.3100.590000 5.62 INGRAM LIBRARY SERVICES 98685749 05/28/2017 BOOKS 010-40.3100.640000 46.30 INGRAM LIBRARY SERVICES 98685750 05/28/2017 BOOKS 010-40.3100.590000 0.65 INGRAM LIBRARY SERVICES 98685750 05/28/2017 BOOKS 010-40.3100.640000 43.64 6/14/2017 2:19:45 PM Page 4 of 16 Expense Approval Register Packet: APPKT00637 - JUNE 20TH COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount INGRAM LIBRARY SERVICES 98685753 05/28/2017 BOOKS 010-40.3100.590000 1.85 INGRAM LIBRARY SERVICES 98685753 05/28/2017 BOOKS 010-40.3100.640000 5.99 INGRAM LIBRARY SERVICES 98685752 05/28/2017 BOOKS 010-40.3100.590000 3.70 INGRAM LIBRARY SERVICES 98685752 05/28/2017 BOOKS 010-40.3100.640000 20.38 INGRAM LIBRARY SERVICES 98685753 05/28/2017 BOOKS 010-40.3100.590000 3.57 INGRAM LIBRARY SERVICES 98685753 05/28/2017 BOOKS 010-40.3100.640000 49.40 INGRAM LIBRARY SERVICES 98732264 - 06/O1/2017 BOOKS 010-40.3100.640000 90.90 CONSOLIDATED COMMU NIC INV0003111 06/08/2017 JUNE'17 STATEMENT 010-40.3100.450000 157.90 CONSOLIDATED COMMUNIC INV0003111 06/08/2017 JUNE'17 STATEMENT 010-40.3100.450000 49.27 AMERITAS LIFE INSURANCE JUN17 06/O1/2017 JUN'17 VISION INSURANCE 010-40.3100.100000 126.96 CITY OF WAUKEE MAY17310 05/31/2017 MAY 17 STATEMENT 010-40.3100.480000 326.05 Department 3100 - LIBRARY SERVICES Total: 13,041.21 Department: 4100 - PARKS CLASSIC FLORAL & GIFTS 030750 05/07/2017 6 POTS SUGAR CREEK GOLF 010-40.4100.410300 453.60 EMPLOYEE BENEFIT SYSTEM 10693 06/13/2017 JUL'17 HEALTH INSURANCE 010-40.4100.100000 596.62 EMPLOYEE BENEFIT SYSTEM 10693 06/13/2017 JUL'17 HEALTH INSURANCE 010-40.4100.100000 1,520.60 EMPLOYEE BENEFIT SYSTEM 10693 06/13/2017 JUL'17 HEALTH INSURANCE 010-40.4100.100000 304.12 ZIMCO SUPPLY CO 109112 05/24/2017 CHEMICALS 010-40.4100.590100 705,00 CLASSIC FLORAL &GIFTS 132007 05/21/2017 12 POTS DOWNTOWN STREE 010-40A100.410300 1,350.83 CLASSIC FLORAL &GIFTS 132008 05/28/2017 BIKE TRAIL PLANTINGS 010-40,4100.410300 365.10 CONFLUENCE 14219 05/31/2017 DOG PARK 327-90.4100.880070 775.00 MIKES ADEL POWER EQUIP 17067 05/23/2017 22" PP TORO BRIGGS 010-40.4100.540000 379.95 CITY OF WAUKEE - AR 201704137175 02/28/2017 LABOR 010-40.4100.410050 292.50 CITY OF WAUKEE - AR 201704137175 02/28/2017 PARTS 010-40.4100.410050 68.74 CITY OF WAUKEE - AR 201704137188 03/31/2017 LABOR 010-40.4100.410050 490.50 CITY OF WAUKEE - AR 201704137188 03/31/2017 PARTS 010-40.4100.410050 576.14 SUPPLYWORKS 401248364 05/19/2017 BATH TISSUE/TOWELS 010-40.4100.590000 221.06 VAN -WALL EQUIPMENT INC 528970 03/28/2017 SEAT 010-40.4100.410100 202.76 VAN -WALL EQUIPMENT INC 543081 04/12/2017 IDLER 010-40.4100.410100 52.06 VAN -WALL EQUIPMENT INC 558703 04/25/2017 REPAIRS TO MOWER 010-40.4100.410100 482.13 VAN -WALL EQUIPMENT INC 573263 05/08/2017 LIFT LINK/CHAIN LINK 010-40.4100.410100 38.72 VAN -WALL EQUIPMENT INC 573311 05/08/2017 SOLENOID 010-40.4100.410100 136.77 VAN -WALL EQUIPMENT INC 585673 05/18/2017 REPAIRS TO JOHN DEERE 16 010-40.4100.410100 2,507.42 CLIVE POWER EQUIPMENT 602000 05/17/2017 NOTCHED BLADE/SCREWS 010-40,4100.540000 75.57 TRUGREEN 63143209 05/29/2017 WARRIORTRAIL 010-40.4100.590100 456.75 MENARDS 81057 05/22/2017 HEAVY DUTY RESIDENTALSL 010-40,4100.590000 64.97 HEARTLAND CO-OP INV0003076 05/31/2017 MAY'17 STATEMENT - PARK 010-40.4100.570000 615.50 WAUKEE HARDWARE & VARI INV0003107 05/31/2017 MAY'17 STATEMENT- PARK 010-40.4100.410300 332.75 HEARTLAND CO-OP INV0003108 05/31/2017 MAY'17 STATEMENT - PUB. 010-40.4100.590100 493.50 CONSOLIDATED COMMUNIC INV0003111 06/08/2017 JUNE'17 STATEMENT 010-40.4100.450000 14.65 AMERITAS LIFE INSURANCE JUN17 06/O1/2017 JUN'17 VISION INSURANCE 010-40.4100.100000 27,24 AMERITAS LIFE INSURANCE JUN17 06/O1/2017 JUN'17 VISION INSURANCE 010-40.4100.100000 10.68 AMERITAS LIFE INSURANCE JUN17 06/01/2017 JUN'17 VISION INSURANCE 010-40.4100.100000 2.14 CITY OF WAUKEE MAY17410 05/31/2017 MAY'17 STATEMENT 010-40.4100.480000 489.23 CITY OF WAUKEE MAY17410 05/31/2017 MAY'17 STATEMENT 010-40.4100.480100 1,267.58 MID AMERICAN ENERGY MAY174100SUMBILL 05/24/2017 MAY'17 STATEMENT 010-40.4100.480000 346.65 LA CROSSE SEED SINP-17-12811 05/25/2017 RYEGRASS 010-40.4100.590000 120.00 Department 4100 - PARKS Total: 15,836.83 Department: 4200 - RECREATION FAREWAY STORES, INC. 00243293 05/25/2017 SLOW COOKER LINERS 010-40.4200.460520 3.38 FAREWAY STORES, INC. 00245729 06/06/2017 SUPER SNACKERS 010-40.4200.460500 11.83 FAREWAY STORES, INC. 00301367 06/20/2017 JUNE SOCIAL FOOD 010-40.4200.460500 51.24 EMPLOYEE BENEFIT SYSTEM 10693 06/13/2017 JUL'17 HEALTH INSURANCE 010-40.4200.100000 3,637.82 WAUKEE COMMUNITY SCHO 172.2 05/24/2017 GIRLS SB PICTURE DAY FACIL 010-40.4200.460510 175.00 ATLANTIC BOTTLING CO 186916 06/02/2017 WATER 010-40.4200.460520 30.80 ROUNDED MINDS 2017001 06/06/2017 MAY SOCCER SESSIONS 010-40.4200.460500 448.00 CITY OF WAUKEE - AR 201704137189 03/31/2017 PARTS 010-40.4200.410050 27.76 CITY OF WAUKEE - Aft 201704137189 03/31/2017 LABOR 010-40.4200.410050 45.00 SWANK MOTION PICTURES, 1 2342822 05/23/2017 STORK MOVIE 010-40.4200.460500 578.00 CHRISTIAN PRINTERS INC 37638 05/31/2017 WAUKEE PARK PLAY POSTCA 010-40A200.460500 119.00 6/14/2017 2:19:45 PIA Page 5 of 16 Expense Approval Register Packet: APPKT00637 -JUNE 20TH COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount WAUKEE ICE CREAM SHOPP 6-2-2017.1 06/09/2017 WARRIOR PARK PLAY ICE CR 010-40.4200.460500 60.00 BSN SPORTS 900041287 05/16/2017 BASEBALL/VOLLEYBALL 010-40.4200.540000 191.21 HEARTLAND CO-OP INV0003075 05/31/2017 MAY'17 STATEMENT -RECR 010-40.4200.570000 114.96 MICHELLE GOODMAN INV0003085 05/25/2017 MAY-JUNE TAI CHI SESSION 010-40.4200.460500 384.00 CENTRAL IOWA OFFICIALS INV0003086 05/30/2017 2017 SPRING GIRLS REC SOF 010-40.4200.460050 40.00 INBOUNDIOWA, LLC INV0003087 05/31/2017 MYSTERY TRIP 2017 010-40.4200.460500 738.00 WAUKEE HARDWARE & VAR] INV0003107 05/31/2017 MAY'17 STATEMENT - PARK 010-40.4200.590000 6.78 WAUKEE HARDWARE & VAR] INV0003107 05/31/2017 MAY'17 STATEMENT - PARK 010-40.4200.590000 20.96 AMERITAS LIFE INSURANCE JUN17 06/01/2017 JUN'17 VISION INSURANCE 010-40.4200.100000 65.16 WD DESIGNS MINISLUGGERS 05/28/2017 MINI SLUGGERS SHORTS 010-40.4200.460510 1,875.35 WD DESIGNS PARK PLAY 06/07/2017 SAFETY SHIRTS - PARK PLAY 010-40.4200.460500 1,148.00 Department 4200 - RECREATION Total: 9,772.25 Department: 4300 - COMMUNITY CENTER WAUKEE HARDWARE & VARI INV0003107 05/31/2017 MAY'17 STATEMENT - PARK 010-40.4300.400000 21.01 CITY OF WAUKEE MAY17430 05/31/2017 MAY'17 STATEMENT 010-40.4300.480000 66.88 Department 4300 - COMMUNITY CENTER Total: 87.89 Department: 5000 - BIKE TRAIL OLD RAILROAD ALLENDER BUTZKE ENGINEE 175039C1 05/22/2017 CONCRETE TESTING & OBSE 327-90.5000.881130 737.46 ALLENDER BUTZKE ENGINEE 175039C2 05/30/2017 CONCRETE TESTING &OBSE 327-90.5000.881130 648.96 ALLENDER BUTZKE ENGINEE 175039C3 06/05/2017 CONCRETE TESTING & OBSE 327-90.5000.881130 359.48 ALLENDER BUTZKE ENGINEE 175039SP2 05/24/2017 SPECIAL INSPECTIONS 327-90.5000.881130 835.62 ALLENDER BUTZKE ENGINEE 175039SP3 05/31/2017 SPECIAL INSPECTIONS 327-90.5000.881130 328.04 Department 5000 - BIKE TRAIL OLD RAILROAD Total: 2,909.S6 Department: 5300-STORM WATER EMPLOYEE BENEFITSYSTEM 10693 06/13/2017 JUL'17 HEALTH INSURANCE 560-80,5300.100000 3,821.02 EMPLOYEE BENEFITSYSTEM 10693 06/13/2017 JUL'17 HEALTH INSURANCE 560-80.5300.100000 529.31 FOTH INFRASTRUCTURE&E 52694 06/06/2017 CENTENNIAL PARK STREAM 560-80.5300.880015 909.38 MENARDS 82433 05/23/2017 STUD/#2&BTR SPF 560-80.5300.410300 94.80 BUSINESS FURNITURE WARE 8485 05/23/2017 OFFICE FURNITURE 560-80.5300.540000 175.75 BUSINESS FURNITURE WARE 8485 05/23/2017 OFFICE FURNITURE 560-80.5300.590000 175.75 LIBERTY READY MIX 86663 05/24/2017 CONCRETE 560-80.5300.410300 309.00 LIBERTY READY MIX 86664 05/24/2017 CONCRETE 560-80.5300.410300 679.88 LIBERTY READY MIX 86781 05/25/2017 CONCRETE 560-80.5300.410300 777.00 HD SUPPLY WATERWORKS H223273 05/23/2017 STANDARD GRATE 560-80.5300.410300 506.62 HEARTLAND CO-OP INV0003074 05/31/2017 MAY'17 STATEMENT- STOR 560-80.5300.570000 278.57 ACCESS SYSTEMS INV522598 05/25/2017 HP PRODESK 4004G 560-80.5300.540000 2,851.55 AMERITAS LIFE INSURANCE JUN17 06/01/2017 JUN'17 VISION INSURANCE 560-80.5300.100000 7.82 AMERITAS LIFE INSURANCE JUN17 06/01/2017 JUN'17 VISION INSURANCE 560-80.5300.100000 54.48 Department 5300 - STORM WATER Total: 11,170.93 Department: 5400 - SOLID WASTE COLLECTION & DISPOSAL ANKENY SANITATION INC. 399945 06/01/2017 JUNE'17 STATEMENT 590-30.5400.231300 91,772.16 Department 5400 - SOLID WASTE COLLECTION & DISPOSAL Total: 91,772.16 Department: 5750 - LITTLE WALNUT CREEK CITY OF WAUKEE - AR 201705117247 03/31/2017 LITTLE WALNUT CREEK DRIV 327-90.5750.230000 37.50 CITY OF WAUKEE - AR 201705117248 03/31/2017 LITTLE WALNUT CREEK LIFTS 327-90.5750.881410 337.50 Department 5750 - LITTLE WALNUT CREEK Total: 375.00 Department: 6000 - PUBLIC WORKS EMPLOYEE BENEFITSYSTEM 10693 06/13/2017 JUL'17 HEALTH INSURANCE 010-20.6000.100000 5,990.80 WAUKEE HARDWARE & VARI INV0003103 05/31/2017 MAY'17 STATEMENT- PUBLI 010-20.6000.590000 14.99 HEARTLAND CO-OP INV0003108 05/31/2017 MAY'17 STATEMENT - PUB. 010-20.6000.570000 252.84 AMERITAS LIFE INSURANCE JUN17 06/01/2017 JUN'17 VISION INSURANCE 010-20.6000.100000 102.32 Department 6000 - PUBLIC WORKS Total: 6,360.95 Department: 6020 - PUBLIC WORKS BUILDING HOTSY CLEANING SYSTEMS, I 0173138-IN 05/19/2017 PIVOT REEL 010-20.6010.400000 40.88 ORKIN PEST CONTROL 158150830 06/19/2017 PEST CONTROL -PUBLIC WO 010-20.6010.400000 86.26 RANKIN COMMUNICATION S 227077 06/01/2017 INSTALL AND CONFIGURE PH 010-20.6010.400000 1,088.08 INGERSOLL RAND 30602306 05/23/2017 AIRCARE ADVANTAGE MAY'1 010-20.6010.400000 617.14 ANKENY SANITATION INC. 401709 06/08/2017 20YD FLAT EMPTY/RETURN 010-20.6010.510100 260.50 6/14/2017 2:19:45 PM Page 6 of 16 Expense Approval Register Packet: APPKT00637 -TUNE 20TH COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount CONTROL INSTALLATIONS O 64282 06/01/2017 RESTRICTOR/COUP 010-20.6010.400000 60.06 OFFICE DEPOT 928869112001 05/18/2017 WIRED TAG/SCISSORS/STAPL 010-20.6010.580000 118.74 FASTENALCOMPANY IAGRM87325 05/15/2017 GLOVES/EYEWEAR/VESTS 010-20.6010.590000 182.64 FASTENALCOMPANY IAGRM87370 05/17/2017 GLOVES/EYEWEAR/VESTS 010-20.6010.590000 176.32 HEARTLAND CO-OP INV0003108 05/31/2017 MAY'17 STATEMENT - PUB. 010-20.6010,590000 76.04 CONSOLIDATED COMMUNIC INV0003109 06/O1/2017 JUNE'17 STATEMENT -PUBL 010-20.6010.450000 157.76 CONSOLIDATED COMMUNIC INV0003111 06/08/2017 JUNE'17 STATEMENT 010-20.6010.450000 443.38 CONSOLIDATED COMMUNIC INV0003111 06/08/2017 JUNE'17 STATEMENT 010-20.6010.450000 142.57 CITY OF WAUKEE MAY17601 05/31/2017 MAY'17 STATEMENT 010-20.6010.480000 949.13 AT&T MOBILITY X06082017 06/08/2017 JUNE'17 STATEMENT 010-20.6010.450000 58.12 Department 6010 -. PUBLIC WORKS BUILDING Total: 4,457.62 Department: 6150 - PUBLIC WORKS MECHANIC MARK STUCHEL INC. 05261748510 05/26/2017 PLIER 010-20.6150.590000 24.35 EMPLOYEE BENEFIT SYSTEM 10693 06/13/2017 JUL'17 HEALTH INSURANCE 010-20.6150.100000 2,117.22 ELECTRONIC ENGINEERING C 120002576-1 05/23/2017 INSTALL RADIOS 010-20.6150.570130 276.84 ARNOLD MOTOR SUPPLY 21-714953 05/31/2017 INLINE BLOW GUN 010-20.6150.590000 39.98 ARNOLD MOTOR SUPPLY 21-714956 05/31/2017 2" BALL & PINT/HITCH PIN 010-20.6150.570130 169.42 ARNOLD MOTOR SUPPLY 21-715374 06/05/2017 7" PLATE 010-20.6150.570130 70.72 ARNOLD MOTOR SUPPLY 21-715402 06/05/2017 AUTO/FLEET 010-20.6150.570130 83.28 SHOTTENKIRK CHEVROLET-P 314131 06/05/2017 LUBE/OIL/FILTER 010-20.6150.570130 72.66 ADEL AUTO PARTS 358325 05/24/2017 OIL FILTERS 010-20.6150.570110 222.45 ADEL AUTO PARTS 358364 05/25/2017 OIL FILTER 010-20.6150.570110 44.19 ADEL AUTO PARTS 358638 05/31/2017 STARTER/CORE DEPOSIT 010-20.6150.570130 148.56 ADEL AUTO PARTS 358770 06/02/2017 AIR FILTERS 010-20.6150.570110 192.08 ADEL AUTO PARTS 358878 06/05/2017 INDICATOR LAMP 010-20.6150.570130 14.76 BAX SALES, INC 36647 06/O1/2017 MAGNET/COUPLER 010-20.6150.590000 57.90 SHOTTENKIRK CHEVROLET-P 39356 05/30/2017 ADAPTER 010-20.6150.570130 21.76 MID-IOWA SOLID WASTE EQ 44220 05/30/2017 VAC -CON PARTS 010-20.6150.570130 46.65 ACME TOOLS 4994519 06/05/2017 CORDLESS POWER TOOLS 010-20.6150.570130 198.00 MATHESON TRI-GAS INC 51182142 05/31/2017 CYLINDERS 010-20.6150.590000 113.46 VAN -WALL EQUIPMENT INC 599881 06/02/2017 HY-GARD/OIL FILTERS/FUEL 010-20.6150.570110 89.03 VAN -WALL EQUIPMENT INC 599881 06/02/2017 HY-GARD/OIL FILTERS/FUEL 010-20.6150.570130 49.14 CAPITALCITY EQUIPMENT C 76747D 05/25/2017 BEARING/CLIP 010-20.6150.570130 5.55 CAPITALCITY EQUIPMENT C 76807D 05/26/2017 DAMPER 010-20.6150.570130 134.80 MIDWEST WHEEL COMPANI 812032-00 05/24/2017 GREASE/SPRING ADJUSTER 010-20.6150.570130 9.74 LAWSON PRODUCTS INC 9304956481 05/16/2017 GLOW MINI FUSE/SEALBUTT 010-20.6150.590000 354.33 C2G CORPORATION CG5420 05/31/2017 BROOM/BLUE BLAZES/BRAK 010-20.6150.570130 137.97 HEARTLAND CO-OP INV0003083 05/31/2017 MAY'17 STATEMENT- MEC 010-20.6150.570000 168.50 WAUKEE HARDWARE & VARI INV0003103 05/31/2017 MAY'17 STATEMENT- PUBLI 010-20.6150.590000 10.58 AMERITAS LIFE INSURANCE JUN17 06/O1/2017 JUN'17 VISION INSURANCE 010-20.6150.100000 37.92 MACQUEEN EQUIPMENT P06491 05/19/2017 CABLE RETERMINATION KIT 010-20.6150.570130 1,410.79 TRANS-IOWA EQUIPMENT IN W00353 05/24/2017 ELGIN WIRLWIND/ADD MIRR 010-20.6150.570130 487.23 O'HALLORAN INTERNATION X100257579:01 02/23/2017 NOZZLE 010-20.6150.570130 35.18 O'HALLORAN INTERNATION X100266622:01 05/24/2017 SWITCH TURN SIGNAL WIPE 010-20.6150.570130 113.92 Department 6150 - PUBLIC WORKS MECHANIC Total: 6,958.96 Department: 6510- WATER UTILITY STANLEY CONSULTANTS INC. 0196214 05/31/2017 WATER TOWER RENOVATIO 510-30.6510.881200 119.00 MUNICIPAL SUPPLY, INC. 0658192-IN 05/30/2017 METER/PARTS 510-30.6510.592000 2,050.40 EMPLOYEE BENEFIT SYSTEM 10693 06/13/2017 JUL'17 HEALTH INSURANCE 510-30.6510.100000 2,071.42 EMPLOYEE BENEFIT SYSTEM 10693 06/13/2017 JUL'17 HEALTH INSURANCE 510-30.6510.100000 529.31 EMPLOYEE BENEFIT SYSTEM 10693 06/13/2017 JUL'17 HEALTH INSURANCE 510-30.6510.100000 760.30 EMPLOYEE BENEFIT SYSTEM 10693 06/13/2017 JUL'17 HEALTH INSURANCE 510-30.6510.100000 1,520.60 IOWA ASSOCIATION OF M U 15054 06/01/2017 CIASSOJUNE-AUG. 510-30.6510.470000 427.84 IOWA ONE CALL 191184 06/07/2017 MAY'17 STATEMENT 510-30.6510.340000 373.20 G&LCLOTHING 2-180384 05/25/2017 BOOTS-ALDRICH 510-30.6510.120000 148.75 HD SUPPLY WATERWORKS H242111 05/24/2017 PARTS 510-30.6510.410400 108.84 DES MOINES WATERWORKS INV0003048 05/26/2017 MAY'17 STATEMENT 510-30.6510.650000 9,485.47 DES MOINES WATERWORKS INV0003049 05/26/2017 MAY'17 STATEMENT 510-30.6510.650000 72,729.36 DES MOINES WATER WORKS INV0003050 05/23/2017 1ST QRTR'17 WSS O&M 510-30.6510.650010 22,552.65 HEARTLAND CO-OP INV0003080 05/31/2017 MAY'17 STATEMENT -WATE 510-30.6510.570000 701.50 6/14/2017 2:19:45 PM Page 7 of 16 Expense Approval Register Packet: APPKTOO637 - JUNE 20TH COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount IOWA DEPT OF NATURAL RE INV0003089 05/09/2017 DRINKING WATER CERT. REN 510-30.6510.470000 60.00 IOWA DEPT OF NATURAL RE INV0003090 05/09/2017 DRINKING WATER CERT. -AL 510-30.6510.470000 60.00 IOWA DEPT OF NATURAL RE INV0003092 05/09/2017 DRINKING WATER CERT. - HE 510-30.6510.470000 60.00 IOWA DEPT OF NATURAL RE INV0003094 05/10/2017 DRINKING WATER CERT. -C. 510-30.6510.470000 60.00 IOWA DEPT OF NATURAL RE INV0003097 05/09/2017 DRINKING WATER CERT. - W 510-30.6510.470000 60.00 WAUKEE HARDWARE &VARI INV0003103 05/31/2017 MAY'17 STATEMENT- PUBLI 510-30.6510.590000 203.00 AMERITAS LIFE INSURANCE JUN17 06/01/2017 JUN'17 VISION INSURANCE 510-30.6510.100000 13.62 AMERITAS LIFE INSURANCE JUN17 06/O1/2017 JUN'17 VISION INSURANCE 510-30.6510.100000 34.60 AMERITAS LIFE INSURANCE JUN17 06/O1/2017 JUN'17 VISION INSURANCE 510-30.6510.100000 7.82 AMERITAS LIFE INSURANCE JUN17 06/O1/2017 JUN'17 VISION INSURANCE 510-30.6510.100000 20.60 MID AMERICAN ENERGY MAY176510SUM BILL 05/24/2017 MAY'17STATEMENT 510-30.6510.480000 757.60 CITY OF WAUKEE MAY17651 05/31/2017 MAY'17 STATEMENT 510-30.6510.480000 448.61 Department 6510 - WATER UTILITY Total: 115,364.49 Department: 6520 - SANITARY SEWERS & TREATMENT EMPLOYEE BENEFIT SYSTEM 10693 06/13/2017 JUL'17 HEALTH INSURANCE 520-30.6520.100000 760.30 EMPLOYEE BENEFIT SYSTEM 10693 06/13/2017 JUL'17 HEALTH INSURANCE 520-30.6520.100000 529.31 EMPLOYEE BENEFIT SYSTEM 10693 06/13/2017 JUL'17 HEALTH INSURANCE 520-30.6520.100000 2,858.00 EMPLOYEE BENEFIT SYSTEM 10693 06/13/2017 JUL'17 HEALTH INSURANCE 520-30.6520.100000 2,071.42 IOWA ASSOCIATION OF MU 15054 06/01/2017 CIASSO JUNE-AUG. 520-30.6520.470000 427.84 CITY OF WAUKEE - AR 201704207206 03/31/2017 NW AREATRUNK SEWER EX 520-30.6520.883091 1,293.75 CITY OF WAUKEE - AR 201704207208 03/31/2017 SW AREA TRUNK SEWER 520-30.6520.883092 656.25 CITY OF WAUKEE - AR 201704207209 03/31/2017 SOUTH OUTFALL SEWER 520-30.6520.883092 937.50 CITY OF WAUKEE - AR 201704207210 03/31/2017 SW AREA TRUNK SEWER 520-30.6520.883092 6,262.50 MIDWEST ENVIRONMENTAL 20170480 05/29/2017 WATEWATER SAMPLE ANAL 520-30.6520.250000 2,091.00 CITY OF WAUKEE - AR 201705117246 03/31/2017 FOX CREEK SEWER EXTNSN P 520-30.6520.883080 225.00 CITY OF WAUKEE - AR 201705117249 03/31/2017 NW AREA TRUNK SEWER EX 520-30.6520.883091 1,425.00 CITY OF WAUKEE - AR 201705117250 03/31/2017 ORIGINAL SANITARY SEWER 520-30.6520.230000 4,256.25 CITY OF WAUKEE - AR 201705117252 03/31/2017 SOUTH OUTFALL TREE FELL] 520-30.6520.883092 1,912.50 CITY OF WAUKEE - AR 201705117253 03/31/2017 SW AREA TRUNK SEWER 520-30.6520.883092 6,543.75 HEARTLAND CO-OP INV0003081 05/31/2017 MAY'17 STATEMENT- SEWE 520-30.6520.570000 763.83 IOWA DEPTOF NATURAL RE INV0003088 05/09/2017 WW OPERATOR CERT RENE 520-30.6520.470000 60.00 IOWA DEPT OF NATURAL RE INV0003091 05/09/2017 WASTE WATER CERT- HERRI 520-30.6520.470000 60.00 IOWA DEPT OF NATURAL RE INV0003093 05/09/2017 WASTE WATER CERT. -VOKE 520-30.6520.470000 60.00 IOWA DEPT OF NATURAL RE INV0003095 05/10/2017 WASTE WATER CERT. -C. DA 520-30.6520.470000 60.00 IOWA DEPT OF NATURAL RE INV0003096 05/09/2017 WASTE WATER CERT. -VOEG 520-30.6520.470000 60.00 IOWA DEPT OF NATURAL RE INV0003098 05/09/2017 WASTE WATER CERT. - WAS 520-30.6520.470000 60.00 WAUKEE HARDWARE Be VARI INV0003103 05/31/2017 MAY'17 STATEMENT- PUBLI 520-30.6520.590000 109.29 WAUKEE HARDWARE & VARI INV0003103 05/31/2017 MAY'17 STATEMENT- PUBLI 520-30.6520.590000 22.34 CONSOLIDATED COMMUNIC INV0003111 06/08/2017 JUNE'17 STATEMENT 520-30.6520.450000 145.25 AMERITAS LIFE INSURANCE JUN17 06/01/2017 JUN'17VISION INSURANCE 520-30.6520.100000 41.20 AMERITAS LIFE INSURANCE JUN17 06/01/2017 JUN'17VISION INSURANCE 520-30.6520.100000 34.60 AMERITAS LIFE INSURANCE JUN17 06/01/2017 JUN'17 VISION INSURANCE 520-30.6520.100000 13.62 AMERITAS LIFE INSURANCE JUN17 06/01/2017 JUN'17 VISION INSURANCE 520-30.6520.100000 7.82 MID AMERICAN ENERGY MAY176520SUMBILL 05/24/2017 MAY'17 STATEMENT 520-30.6520.480000 7,191.16 CITY OF WAUKEE MAY17652 05/31/2017 MAY'17 STATEMENT 520-30.6520.480000 1,146.50 Department 6520 - SANITARY SEWERS & TREATMENT Total: 42,085.98 Department: 6540 - GAS UTILITY CLAYTON ENERGY CORPORA 10023 06/13/2017 MAY'17 COMMODITY 540-30.6540,650000 56,934.24 EMPLOYEE BENEFIT SYSTEM 10693 06/13/2017 JUL'17 HEALTH INSURANCE 540-30.6540.100000 529.31 EMPLOYEE BENEFIT SYSTEM 10693 06/13/2017 JUL'17 HEALTH INSURANCE 540-30.6540.100000 6,082.40 EMPLOYEE BENEFIT SYSTEM 10693 06/13/2017 JUL'17 HEALTH INSURANCE 540-30.6540.100000 760.29 IOWA ASSOCIATION OF MU 15054 06/O1/2017 CIASSOJUNE-AUG. 540-30.6540.470000 427.83 IOWA ONE CALL 191184 06/07/2017 MAY'17 STATEMENT 540-30.6540.340000 373.20 US DEPT OF TRANSPORTATI 20178-050364 06/05/2017 NATURAL GAS PIPELINE 2ND 540-30.6540.280000 159.62 INFRASOURCE CONSTRUCTI 3017096 05/27/2017 KUM & GO/TALLGRASS/ELM 540-30.6540.880100 14,784.51 GROEBNER & ASSOCIATES IN 339071 05/23/2017 COPPER REINFORCED 540-30.6540.590200 310.54 GROEBNER & ASSOCIATES IN 339341 05/30/2017 PVC ROCKSHIELD 540-30.6540.410400 215.15 UNIVERSAL PRINTING SERVI 49320 06/07/2017 GAS BROCHURE 540-30.6540.350100 321.99 BORDER STATES ELECTRIC S 913093438 05/19/2017 20LT METER GASKET/SPUD/ 540-30.6540.592000 383.78 INDUSTRIAL SALES COMPAN 979679-000 05/24/2017 1/2" CTS EF CAPS 540-30.6540.590200 204.16 6/14/2017 2: 19:45 PIA Page 8 OF 16 Expense Approval Register Packet: APPKT00637 -JUNE 20TH COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount INDUSTRIAL SALES COMPAN 979968-000 05/25/2017 DRISCO 65001PS 540-30.6540.590100 11,910.60 INDUSTRIAL SALES COMPAN 980890-000 05/31/2017 POLYBALL4"BALL VALVE 540-30.6540,590100 561.72 CLAYTON ENERGY CORPORA 9989 06/01/2017 MAY'17 RESERVATION NOTI 540-30.6540.650000 10,542.37 SUSANNA KESTERSON INV0003054 06/20/2017 FURNACE REBATE 540-30.6540.685400 75.00 HEARTLAND CO-OP INV0003078 05/31/2017 MAY'17 STATEMENT - PUB. 540-30.6540.590000 41.50 HEARTLAND CO-OP INV0003079 05/31/2017 MAY'17 STATEMENT - GAS 540-30.6540.570000 554.25 DAVID VETSCH INV0003099 06/20/2017 GAS FURNACE/WATER HEAT 540-30.6540.685400 125.00 TODD THORSON INV0003100 06/20/2017 FURNACE REBATE 540-30.6540.685400 150.00 WAUKEE HARDWARE & VARI INV0003103 05/31/2017 MAY'17 STATEMENT- PUBLI 540-30.6540.590000 128.20 CONSOLIDATED COMMUNIC INV0003111 06/08/2017 JUNE'17 STATEMENT 540-30.6540.450000 72.63 AMERITAS LIFE INSURANCE JUN17 06/O1/2017 JUN'17 VISION INSURANCE 540-30.6540.100000 99.04 AMERITAS LIFE INSURANCE JUN17 06/O1/2017 JUN'17 VISION INSURANCE 540-30.6540.100000 13.62 AMERITAS LIFE INSURANCE JUN17 06/01/2017 JUN'17 VISION INSURANCE 540-30.6540.100000 7.82 MID AMERICAN ENERGY MAY176540SU M BILL 05/24/2017 MAY'17 STATEMENT 540-30.6540.480000 87.11 Department 6540 - GAS UTILITY Total: 105,855.88 Department: 6550 - UTILITY BILLING EMPLOYEE BENEFIT SYSTEM 10693 06/13/2017 JUL'17 HEALTH INSURANCE 570-30.6550.100000 1,842.42 PITNEY BOWES 3303638630 06/01/2017 QRTRLY METER/STUFFER M 570-30.6550.390000 1,573.68 AMERITAS LIFE INSURANCE JUN17 06/01/2017 JUN'17 VISION INSURANCE 570-30.6550.100000 31.28 Department 6550 - UTILITY BILLING Total: 3,447.38 Department: 7100 - STREETS SHERWIN WILLIAMS CO 0434-3 05/25/2017 5-GALSTRAINER 060-30.7100.590700 10.52 EMPLOYEE BENEFIT SYSTEM 10693 06/13/2017 JUL'17 HEALTH INSURANCE 060-30.7100.100000 760.30 EMPLOYEE BENEFIT SYSTEM 10693 06/13/2017 JUL'17 HEALTH INSURANCE 060-30.7100.100000 152.06 EMPLOYEE BENEFIT SYSTEM 10693 06/13/2017 JUL'17 HEALTH INSURANCE 060-30.7100.100000 5,755.04 SNYDER&ASSOCIATES INC 116.0645.01-8 05/30/2017 MISCTRAFFIC ENGINEERING 060-30.7100.230000 2,274.66 SHERWIN WILLIAMS CO 1499-7 05/25/2017 PAINT 060-30.7100.590000 105.30 IOWA ASSOCIATION OF MU 15054 06/01/2017 CIASSO JUNE-AUG. 060-30.7100.470000 427.84 SHERWIN WILLIAMS CO 1526-7 05/26/2017 PAINT 060-30.7100.590000 105.30 MARTIN MARIETTAAGGREG 20359339 05/18/2017 ROAD STONE 060-30.7100.590300 556.03 MARTIN MARIETTAAGGREG 20395288 05/22/2017 ROADSTONE 060-30.7100.590300 211.34 CORELL CONTRACTOR INC 22165 05/16/2017 ASPHALT 060-30.7100.590300 285.67 IOWA PLAINS SIGNING INC 34306 05/18/2017 DGO ALUMINUM 060-30.7100.590600 391.00 SHERWIN WILLIAMS CO 8152-3 05/26/2017 PAINT 060-30.7100.590000 105.30 MENARDS 81625 05/26/2017 GEAR DRIVE POP-UP/SCREW 060-30.7100.590000 16.30 LIBERTY READY MIX 86298 05/16/2017 CONCRETE 060-30.7100.590400 1,356.00 LIBERTY READY MIX 86326 05/17/2017 CONCRETE 060-30.7100.590400 373.75 LIBERTY READY MIX 86412 05/18/2017 CONCRETE 060-30.7100.590400 438.50 LIBERTY READY MIX 86580 05/23/2017 CONCRETE 060-30.7100.590400 1,036.00 LIBERTY READY MIX 86782 05/25/2017 CONCRETE O60-30.7100.590400 1,295.00 HEARTLAND CO-OP INV0003082 05/31/2017 MAY'17 STATEMENT -STREE 060-30.7100.570000 1,046.23 WAUKEE HARDWARE & VARI INV0003103 05/31/2017 MAY'17 STATEMENT- PUBLI 060-30.7100.590000 65.24 JIM & CATHERINE WITTE INV0003104 06/02/2017 CURB & GUTTER REPAIR REI 060-30.7100.590400 500.00 AMERITAS LIFE INSURANCE JUN17 06/O1/2017 JUN'17 VISION INSURANCE 060-30.7100.100000 92.40 AMERITAS LIFE INSURANCE JUN17 06/O1/2017 JUN'17 VISION INSURANCE 060-30.7100.100000 13.62 AMERITAS LIFE INSURANCE JUN17 06/01/2017 JUN'17 VISION INSURANCE 060-30.7100.100000 1.07 LOGAN CONTRACTORS SUPP M07803 05/23/2017 #4X30' 60GR STR EC 060-30.7100.590000 106.88 Department 7100 - STREETS Total: 17,481.35 Department: 7730 - SE W ESTO WN PKWY CONSTRUCTION CITY OF WAUKEE - AR 201705117251 03/31/2017 SE WESTOWN PARKWAY EXT 327-90.7730.235000 150.00 CITY OF WAUKEE - AR 201705117254 03/31/2017 WESTOWN PARKWAY/R221 327-90.7730.235100 1,087.50 Department 7730 - SE W ESTOW N PKWY CONSTRUCTION Total: 1,237.50 Department: 7850 -TIF DEBT SERVICE AHLERS & COONEY PC 729651 05/25/2017 ASHWORTH PROPERTIES DE 094-30.7850.230000 1,168.50 Department 7850 - TIF DEBT SERVICE Total: 1,268.50 Department: 8100 - MAYOR & COUNCIL LANDS END BUSINESS OUTFI SIN5029023 05/23/2017 SHIRTS- MAYOR/SCHUETT/J 010-60.8100.120000 127.67 Department 8100 - MAYOR & COUNCIL Total: 127.67 6/14/2017 2:19:45 PM Page 9 of 16 Expense Approval Register Packet: APPKT00637 - JUNE 20TH COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount Department: 8200 - COMMUNICATIONS CAMERON STOTZ, IT/PHOTO 1044 06/08/2017 ALICE'S RD ARIAL FOOTAGE 010-60.8200.350110 100.00 EMPLOYEE BENEFIT SYSTEM 10693 06/13/2017 JUL'17 HEALTH INSURANCE 010-60.8200.100000 1,520.60 LIVING MAGAZINES 366050 05/O1/2017 CITY NEWSLETTER PAGE MA 010-60.8200.461200 730.00 BUSINESS PUBLICATIONS 47569 05/26/2017 LAND IN WAUKEE PRINT AD 010-60.8200.210000 1,817.00 AMERITAS LIFE INSURANCE JUN17 06/O1/2017 JUN'17 VISION INSURANCE 010-60.8200.100000 27.24 LANDS END BUSINESS OUTFI SIN5029023 05/23/2017 SHIRTS - MAYOR/SCHUETT/J 010-60.8200.120000 65.82 Department 8200 - COMMUNICATIONS Total: 4,260.66 Department: 8300 - ADMINISTRATION UNITED PARCEL SERVICE OOOOAW7647217 05/27/2017 SHIPPING 010-60.8300.360000 28.69 EMPLOYEE BENEFIT SYSTEM 10693 06/13/2017 JUL'17 HEALTH INSURANCE 010-60.8300.100000 2,949.60 MEDIACOM INV0003051 05/28/2017 MAY'17 STATEMENT O10-60.8300.270000 139.95 EFTPS INV0003112 06/14/2017 2017 PCORI FEE 010-60.8300.100000 182.28 AMERITAS LIFE INSURANCE JUN17 06/01/2017 JUN'17 VISION INSURANCE 010-60.8300.100000 47.84 CITY OF WAUKEE MAY17830NV 05/31/2017 MAY'17 STATEMENT 010-60.8300.390400 102.87 LANDS END BUSINESS OUTFI SIN5029023 05/23/2017 SHIRTS - MAYOR/SCHUETT/J 010-60.8300.120000 47.81 Department 8300 - ADMINISTRATION Total: 3,499.04 Department: 8310 - CITY HALL ORKIN PEST CONTROL 158151518 06/19/2017 PEST CONTROL - CITY HALL 010-60.8310.400000 19.03 Rl LAWN SERVICE INC 19788 05/29/2017 FERTILIZER/BED MAINTENA 010-60.8310.390600 83.53 NATIONWIDE OFFICE CLEAN 62258 05/31/2017 HARD ROLL TOWELS 010-60.8310.590000 113.00 OFFICE DEPOT 930972960001 05/25/2017 INK/PENS 010-60.8310.590000 3.51 OFFICE DEPOT 932482601001 06/O1/2017 COFFEE CREAMER O10-60.8310.590000 22.83 COMMUNICATIONS ENGINE BILL230421 05/25/2017 VOTING MACHINE SOFTWAR O10-60.8310.410100 1,534.14 ALLIANCE CONNECT INV0003052 06/O1/2017 JUNE'17 STATEMENT 010-60.8310.450000 49.00 CONSOLIDATED COMMUNIC INV0003111 06/08/2017 JUNE'17 STATEMENT 010-60.8310.450000 344.85 CONSOLIDATED COMMUNIC INV0003111 06/08/2017 JUNE'17 STATEMENT 010-60.8310.450000 216.92 CITY OF WAUKEE MAY17831 05/31/2017 MAY'17 STATEMENT 010-60.8310.480000 152.70 MID AMERICAN ENERGY MAY178310SUMBILL 05/24/2017 MAY'17 STATEMENT 010-60.8310.480000 460.34 CITY OF WAUKEE MAY17831CAM 05/31/2017 MAY'17 STATEMENT 010-60.8310.390600 228.19 Department 8310 - CITY HALL Total: 3,228.04 Department: 8350 - HUMAN RESOURCES EMPLOYEE BENEFIT SYSTEM 10693 06/13/2017 JUL'17 HEALTH INSURANCE 010-60.8350.100000 596.62 AMERITAS LIFE INSURANCE JUN17 06/01/2017 JUN'17 VISION INSURANCE 010-60.8350.100000 10.68 Department 8350 - HUMAN RESOURCES Total: 607.30 Department: 8400 - FINANCIAL ADMINISTRATION EMPLOYEE BENEFIT SYSTEM 10693 06/13/2017 JUL'17 HEALTH INSURANCE 010-60.8400.100000 3,546.22 PITNEY BOWES 3303638630 06/01/2017 QRTRLY METER/STUFFERM 010-60.8400.390000 592.59 OFFICE DEPOT 930972960001 05/25/2017 INK/PENS 010-60.8400.580000 29.98 AMERITAS LIFE INSURANCE JUN17 06/01/2017 JUN'17 VISION INSURANCE O10-60.8400.100000 58.52 LANDS END BUSINESS OUTFI SIN5072879 06/07/2017 SHIRT- BURKHART 010-60.8400.120000 34.45 Department 8400 - FINANCIAL ADMINISTRATION Total: 4,261.76 Department: 8500 - COMMUNITY DEVELOPMENT EMPLOYEE BENEFIT SYSTEM 10693 06/13/2017 JUL'17 HEALTH INSURANCE 010-50.8500.100000 2,814.30 CITY OF URBANDALE 2017-00000086 05/30/2017 TRUST BELTCONFERENCE SP 010-50.8500.210100 1,858.00 AMERITAS LIFE INSURANCE JUN17 06/01/2017 JUN'17 VISION INSURANCE 010-50.8500.100000 37.92 Department 8500 - COMMUNITY DEVELOPMENT Total: 4,710.22 Department: 8600 - CITY ATTORNEY BRICK GENTRY BOWERS SW 230287 05/25/2017 MAY'17 STATEMENT 010-60.8600.230000 21,405.00 Department 8600 - CITY ATTORNEY Total: 21,405.00 Department: 8700 - DEVELOPMENT SERVICES EMPLOYEE BENEFIT SYSTEM 10693 06/13/2017 JUL'17 HEALTH INSURANCE 010-50.8700.100000 3,637.82 AMERITAS LIFE INSURANCE JUN17 06/O1/2017 JUN'17 VISION INSURANCE 010-50.8700.100000 65.16 Department 8700 - DEVELOPMENT SERVICES Total: 3,702.98 Department: 8750 - SUGAR CREEK MUNICIPAL HARRIS GOLF CARS O1-181884 05/23/2017 KEYS 750-80.8750.410360 38.12 HARRIS GOLF CARS 01-182065 05/24/2017 LEVER LOCK 750-80.8750.410360 14.24 EMPLOYEE BENEFIT SYSTEM 10693 06/13/2017 JUL'17 HEALTH INSURANCE 750-80.8750.100000 1,064,42 6/14/2017 2:19:45 PM Page 10 cf 16 Expense Approval Register Packet: APPKT00637 -TUNE 20TH COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount BEST PORTABLE TOILETS, IN 13503 05/30/2017 TOILETS 750-80.8750.400000 365.00 PING 13752437 05/19/2017 IRONS SETS 750-80.8750.651100 468.60 ATLANTIC BOTTLING CO 186328 06/02/2017 POP 750-80.8750.650150 619.80 CHAD PROEHL 2017-001A 06/09/2017 JUNIOR GOLF CAMP#1 750-80.8750.465400 1,161.00 CHAD PROEHL 2017-002 06/12/2017 JUNIOR GOLF CAMP#2 750-80.8750.465400 4,752.00 CITY OF WAUKEE - AR 201704137197 03/31/2017 LABOR 750-80.8750.410050 135.00 CITY OF WAUKEE - AR 201704137197 03/31/2017 PARTS 750-80.8750.410050 17.25 DIRECTV 31535116228 05/31/2017 MAY'17 STATEMENT -GOLF 750-80.8750.480000 22.25 SRIXON 5140950SO 05/15/2017 SUPERSLEEVE BALLS 750-80.8750.651000 288.36 FARNER-BOCKEN COMPANY 5706484 05/18/2017 FROZEN FOOD 750-80.8750.650200 537.09 PEPSI 85341456 05/15/2017 WATER/POP 750-80.8750.650150 662.48 TITLEIST 903991504 04/13/2017 WOMEN'S SHORTS 750-80.8750.651100 224.72 CALLAWAY GOLF 927738553 04/20/2017 MEN'S APPAREL 750-80.8750.651000 220.18 CALLAWAY GOLF 927817808 05/09/2017 CHROME SOFT 750-80.8750.651000 195.18 NIKE USA INC 9902911846 04/13/2017 NIKE A FLEX 750-80.8750.651100 73.63 NIKE USA INC 9902919446 04/13/2017 DRY POLOS/PANTS/SHORTS 750-80.8750.651100 263.01 NIKE USA INC 9902953676 04/13/2017 DRY SHORTS 750-80.8750.651100 74.45 NIKE USA INC 9903079361 04/17/2017 DRY SHORTS 750-80.8750.651100 78.90 NIKE USA INC 9903249336 04/21/2017 DRY POLO 750-80.8750.651100 36.66 NIKE USA INC 9903495223 04/27/2017 DRY PANTS 750-80.8750.651100 54.16 NIKE USA INC 9903560256 04/28/2017 DRY SHORT 750-80.8750.651100 81.66 NIKE USA INC 9904428580 05/19/2017 DRY POLO AND SHORTS 750-80.8750.651100 71.66 NIKE USA INC 9904428581 05/19/2017 DRY PANTS AND SHORTS 750-80.8750.651100 132.17 BERMUDA SANDS, LLC B0028812 04/18/2017 WOMEN'S APPAREL 750-80.8750.651100 169.54 R & R PRODUCTS INC CD2124198 05/17/2017 FLEXSTAKE 750-80.8750.590000 35.58 U S KIDS GOLF IN1208107 05/31/2017 CLUB STAND SET 750-80.8750.651000 170.75 HEARTLAND CO-OP INVO003077 05/31/2017 MAY'17 STATEMENT -GOLF 750-80.8750.570000 1,973.68 ANDERSON SERVICE CO. INV0003084 05/09/2017 TROUBLESHOOT/CLEAN ICE 750-80.8750.400050 296.00 ANDERSON SERVICE CO. INV0003106 06/06/2017 ICE MACHINE MAITENANCE 750-80.8750.400000 305.00 WAUKEE HARDWARE & VARI INV0003107 05/31/2017 MAY'17 STATEMENT- PARK 750-80.8750.400000 135.66 AMERITAS LIFE INSURANCE JUN17 06/O1/2017 JUN'17 VISION INSURANCE 750-80.8750.100000 7.48 MID AMERICAN ENERGY MAY178750SUMBILL 05/24/2017 MAY'17 STATEMENT 750-80.8750.480000 489.39 CITY OF WAUKEE MAY17875 05/31/2017 MAY'17 STATEMENT 750-80.8750.480000 365.63 DAVIS EQUIPMENT CORPOR WI10712 05/25/2017 PARTS 750-80.8750.410350 179.29 Department 8750 - SUGAR CREEK MUNICIPAL Total: 15,779.99 Department: 8800 - INFORMATION TECHNOLOGY EMPLOYEE BENEFIT SYSTEM 10693 06/13/2017 JUL'17 HEALTH INSURANCE 010-60.8800.100000 1,520.60 Department 8800 - INFORMATION TECHNOLOGY Total: 1,520.60 Department: 8900 - ENGINEERING EMPLOYEE BENEFIT SYSTEM 10693 06/13/2017 JUL'17 HEALTH INSURANCE 010-20.8900.100000 4,234.44 BUSINESS FURNITURE WARE 8485 05/23/2017 OFFICE FURNITURE 010-20.8900.540000 175.75 BUSINESS FURNITURE WARE 8485 05/23/2017 OFFICE FURNITURE 010-20.8900.590000 175.75 HEARTLAND CO-OP INV0003072 05/31/2017 MAY'17 STATEMENT-ENGI010-20.8900.570000 706.85 ACCESS SYSTEMS INV522598 05/25/2017 HP PRODESK 4004G 010-20.8900.540000 2,851.54 AMERITAS LIFE INSURANCE JUN17 06/O1/2017 JUN'17 VISION INSURANCE 010-20.8900.100000 75.84 Department 8900 - ENGINEERING Total: 8,220.17 Department: 8950 - GIS EMPLOYEE BENEFIT SYSTEM 10693 06/13/2017 JUL'17 HEALTH INSURANCE 010-20.8950.100000 596.62 HEARTLAND CO-OP INV0003073 05/31/2017 MAY'17 STATEMENT -GIS 010-20.8950.570000 66.11 AMERITAS LIFE INSURANCE JUN17 06/01/2017 JUN'17VISION INSURANCE 010-20.8950.100000 10.68 Department 8950 - GIS Total: 673.41 Grand Total: 682,616.19 6/14/2017 2:19:45 PM Page 11 of 16 Expense Approval Register Packet: APPKT00637 - JUNE 20TH COUNCIL PACKET Fund Summary Fund 010-GENERAL FUND 060-ROAD USE TAX FUND 094-GATEWAY URBAN RENEWAL 327 - CAPITAL PROJECTS 510- WATER UTILITY FUND 520- WASTE WATER UTILITY FUND 540 - GAS UTILITY FUND 560-STORM WATER UTILITY FUND 570 - UTILITY BILL FUND 590 - SOLID WASTE COLLECT & RCY 750-GOLF COURSE FUND Account Number 010-10.1100.100000 010-10.1100.120000 010-10.1100.230000 010-10.1100.400000 010-10.1100.400100 010-10.1100.410050 010-10.1100.450000 010-10.1100.460200 010-10.1100.470000 010-10.1100.480000 010-10,1100.540000 010-10.1100.560000 010-10.1100.580000 010-10.1100.590000 010-10.1300.230010 010-10.1400.100000 010-10.1400.110100 010-10.1400.120000 010-10.1400.270000 010-10.1400.360000 010-10.1400.400000 010-10.1400.410000 010-10.1400.410100 010-10.1400.450000 010-10.1400.480000 010-10.1400.540000 010-10.1400.570000 010-10.1500.100000 010-10.1500.110100 010-10.1500.120000 010-10.1500.231800 010-10.1500.270000 010-10.1500.400000 010-10.1500.410000 010-10.1500.410100 010-10.1500.450000 010-10.1500.480000 010-10.1500.570000 010-10.1500.590000 010-10.1500.590050 010-10.1900.100000 010-10.2400.340000 010-20.6000.100000 010-20.6000.570000 Grand Total: Account Summary Account Name HEALTH & LIFE INSURAN UNIFORMS CONSULTANT & PROFES REPAIR/MAINTENANCE CUSTODIAL REPAIR/MAINT- WAUKE TELEPHONE PD COMMUNITY POLICI TRAINING/TRAVEL EXPE UTILITY SERV ICES MINOR EQUIPMENT MOTOR VEHICLE MAINT OFFICE SUPPLIES OPERATING SUPPLIES & WESTCOM DISPATCH SE HEALTH & LIFE INSURAN EMPLOYEE PHYSICALS UNIFORMS DATA PROCESSING POSTAGE & SHIPPING REPAIR/MAINTENANCE REPAIR OF VEHICLES REPAIR/MAINTENANCE TELEPHONE UTILITY SERVICES MINOR EQUIPMENT FUEL HEALTH & LIFE INSURAN EMPLOYEE PHYSICALS UNIFORMS AMBULANCE BILLING FE DATA PROCESSING REPAIR/MAINTENANCE REPAIR OF VEHICLES REPAIR/MAINTENANCE TELEPHONE UTILITY SERVICES FUEL OPERATING SUPPLIES & MEDICAL SUPPLIES HEALTH & LIFE INSURAN MISCELLANEOUS CONTR HEALTH & LIFE INSURAN FUEL Expense Amount 215,507.59 35,132.24 1,168.50 18,700.36 133,993.91 44,258.99 107,804.04 12,373.01 3,447.38 91,772.16 18,458.01 682,616.19 Expense Amount 28,901.23 513.16 2,509.99 214.92 360.00 755.74 487.64 2,740.06 1,245.00 255.99 35.92 490.10 201.21 205.15 33,763.09 7,195.89 1,099.00 29.98 100.61 16.15 120.60 2,576.36 195.37 94.94 169.67 31.89 475.00 7,195.87 1,099.00 29.98 2,916.75 100.61 120.59 285.80 142.37 94.93 169.66 474.99 62.50 851.84 4,310.28 480.00 6,093.12 252.84 6/14/2017 2:19:45 PM Page 12 of 16 Expense Approval Register Packet: APPKT00637 -DUNE 20TH COUNCIL PACKET Account Summary Account Number Account Name Expense Amount 010-20.6000.590000 OPERATING SUPPLIES & 14.99 010-20.6010.400000 REPAIR/MAINTENANCE 1,892.42 010-20.6010,450000 TELEPHONE 801.83 010-20.6010.480000 UTILITY SERVICES 949.13 010-20.6010.510100 GARBAGE PICKUP 260.50 010-20.6010.580000 OFFICE SUPPLIES 118.74 010-20.6010.590000 OPERATING SUPPLIES & 435.00 010-20,6150.100000 HEALTH & LIFE INSURAN 2,155,14 010-20.6150.570000 FUEL 168.50 010-20,6150.570110 COGS -FILTERS 547.75 010-20.6150.570130 COGS - PARTS 3,486.97 010-20.6150.590000 OPERATING SUPPLIES & 600.60 010-20.8900.100000 HEALTH & LIFE INSURAN 4,310.28 010-20.8900,540000 MINOR EQUIPMENT 3,027.29 010-20.8900.570000 FUEL 706.85 010-20.8900.590000 OPERATING SUPPLIES & 175.75 010-20.8950.100000 HEALTH & LIFE INSURAN 607.30 010-20.8950.570000 FUEL 66.11 010-2030500 SALES TAX COLLECTED P 430.20 010-40.3100.100000 HEALTH & LIFE INSURAN 8,051.78 010-40.3100.400000 REPAIR/MAINTENANCE 1,068.93 010-40.3100.400100 CUSTODIAL SERVICES 689.51 010-40.3100.450000 TELEPHONE 207.17 010-40.3100.460300 PROGRAMS 1.69 010-40.3100.480000 UTILITY SERVICES 326.05 010-40.3100.540000 MINOR EQUIPMENT 378.00 010-40.3100.580000 OFFICE SUPPLIES 204.86 010-40.3100.590000 OPERATING SUPPLIES & 500.35 010-40.3100.640000 LIBRARY BOOKS/FILMS/ 1,612.87 010-40.4100.100000 HEALTH & LIFE INSURAN 2,461.40 010-40.4100.410050 REPAIR/MAINT-WAUKE 1,427.88 010-40.4100.410100 REPAIR/MAINTENANCE 3,419.86 010-40.4100.410300 REPAIR/MAINTENANCE 2,502.28 010-40.4100.450000 TELEPHONE 14.65 010-40.4100.480000 UTILITY SERVICES 835.88 010-40.4100.480100 UTILITIES -PARK IRRIGATI 1,267.58 010-40.4100.540000 MINOR EQUIPMENT 455.52 010-40.4100.570000 FUEL 615.50 010-40.4100.590000 OPERATING SUPPLIES & 406.03 010-40.4100.590100 CHEMICAL/FERTILIZER 1,655.25 010-40.4200.100000 HEALTH & LIFE INSURAN 3,702.98 010-40.4200.410050 REPAIR/MAINTENANCE 72.76 010-40.4200.460050 OFFICIALS 40.00 010-40.4200.460500 SUMMER RECREATION P 3,538.07 010-40.4200.460510 YOUTH SPORTS LEAGUE 2,050.35 010-40.4200.460520 CONCESSION STAND 34.18 010-40.4200.540000 MINOR EQUIPMENT 191.21 010-40.4200.570000 FUEL 114.96 010-40.4200.590000 OPERATING SUPPLIES& 27.74 010-40.4300.400000 REPAIR/MAINTENANCE 21.01 010-40.4300.480000 UTILITY SERVICES 66.88 010-50.8500.100000 HEALTH & LIFE INSURAN 2,852.22 010-50.8500.210100 PROMOTION 1,858.00 010-50.8700.100000 HEALTH & LIFE INSURAN 3,702.98 010-60.8100.120000 UNIFORMS 127.67 010-60.8200.100000 HEALTH & LIFE INSURAN 1,547.84 010-60.8200.120000 UNIFORMS 65.82 010-60.8200.210000 PUBLIC NOTIFICATION/A 1,817.00 6/14/2017 2:19:45 PM Page 13 of 16 Expense Approval Register Packet: APPKT00637 - JUNE 20TH COUNCIL PACKET Account Summary Account Number Account Name Expense Amount 010-60.8200.350110 PHOTOGRAPHY & VIDEO 300.00 010-60.8200.461200 NEWSLETTER 730.00 010-60.8300.100000 HEALTH & LIFE INSURAN 3,179.72 010-60.8300.120000 UNIFORMS 47.81 010-60.8300.270000 DATA PROCESSING 139.95 O10-60.8300.360000 POSTAGE & SHIPPING 28.69 010-60.8300.390400 NORTHVIEW RENTAL PR 102.87 010-60.8310.390600 PROF PLAZA CAM EXPEN 311.72 010-60.8310.400000 REPAIR/MAINTENANCE 19.03 010-60.8310.410100 REPAIR/MAINTENANCE 1,534.14 010-60.8310.450000 TELEPHONE 610.77 010-60.8310.480000 UTILITY SERVICES 613.04 010-60.8310.590000 OPERATING SUPPLIES & 139.34 010-60.8350.100000 HEALTH & LIFE INSURAN 607.30 010-60.8400.100000 HEALTH & LIFE INSURAN 3,604.74 010-60.8400.120000 UNIFORMS 34.45 010-60.8400.390000 RENTAL/LEASE OF EgUI 592.59 010-60.8400.580000 OFFICE SUPPLIES 29.98 010-60.8600.230000 CONSULTANT&PROFES 21,405.00 010-60.8800.100000 HEALTH & LIFE INSURAN 1,520.60 060-30.1600.410300 REPAIR/MAINTENANCE 265.00 060-30.1600.480000 UTILITY SERVICES 16,859.57 060-30.1601.480000 UTILITY SERVICES 526.32 060-30.7100.100000 HEALTH & LIFE INSURAN 6,774.49 060-30.7100.230000 CONSULTANT&PROFES 2,274.66 060-30.7100.470000 TRAINING/TRAVEL EXPE 427.84 060-30.7100.570000 FUEL 1,046.23 060-30.7100.590000 OPERATING SUPPLIES & 504.32 060-30.7100.590300 ROADSTONE 1,053.04 060-30.7100.590400 ROAD REPAIR -PATCH 4,999.25 060-30.7100.590600 STREET SIGNS 391.00 060-30.7100.590700 STREET MARKING 10.52 094-30.7850.230000 CONSULTANT/PROFESSI 1,168.50 327-90.1601.235020 HICKMAN/DARTMOORT 430.50 327-90.1601.235030 HICKMAN & WESTGATE 1,800.00 327-90.2130.840490 ALICES RD -UNIV TO OL 4,483.30 327-90.2130.840491 ALICES ROAD - OLSONT 675.00 327-90,2131.230051 CONSULTING -ESKER RID 1,800.00 327-90.2150.980110 HS REC COMPLEX -CON 4,214.50 327-90.4100.880070 DOG PARK - CONSULTIN 775.00 327-90.5000.881130 RRVT TRAILHEAD ART I 2,909.56 327-90.5750.230000 CONSULTING & PROFES 37.50 327-90.5750.881410 LITTLE WALNUT CREEK- 337.50 327-90.7730.235000 CONSTRUCTION CONTR 150.00 327-90.7730.235100 SE WESTOWN/11221NTE 1,087.50 510-2030500 SALES TAX COLLECTED P 18,629.42 510-30.6510.100000 HEALTH & LIFE INSURAN 4,958.27 510-30.6510.120000 UNIFORMS 148.75 510-30.6510.340000 MISCELLANEOUS CONTR 373.20 510-30.6510.410400 REPAIR/MAINT OF DELIV 108.84 510-30.6510.470000 TRAINING/TRAVEL EXPE 727.84 510-30.6510.480000 UTILITY SERVICES 1,206.21 510-30.6510.570000 FUEL 701.50 510-30.6510.590000 OPERATING SUPPLIES& 203.00 510-30.6510.592000 METER PURCHASE 2,050.40 510-30.6510.650000 COSTOF GOODS SOLD 82,214.83 510-30.6510,650010 DSMWW OPERATING& 22,552.65 510-30.6510.881200 WATER TOWER REHAB 119.00 6/14/2017 2:19:45 PM Page 14 of 16 Expense Approval Register Packet: APPKT00637 - JUNE 20TH COUNCIL PACKET Account Summary Account Number Account Name Expense Amount 520-2030500 SALES TAX COLLECTED P 2,173.01 520-30.6520.100000 HEALTH & LIFE INSURAN 6,316.27 520-30.6520.230000 CONSULTANT & PROFES 4,256.25 520-30.6520.250000 TESTING FEES 2,091.00 520-30.6520.450000 TELEPHONE 145.25 520-30,6520.470000 TRAINING/TRAVEL EXPE 787.84 520-30.6520.480000 UTILITY SERVICES 8,337.66 520-30.6520.570000 FUEL 763.83 520-30.6520.590000 OPERATING SUPPLIES & 131.63 520-30.6520.883080 FOX CREEK SEWER 225.00 520-30.6520.883091 NW AREA TRUNK SEWE 2,718.75 520-30.6520.883092 SW TRUNK SEWER 16,312.50 540-2030500 SALES TAX COLLECTED P 1,948.16 540-30.6540.100000 HEALTH & LIFE INSURAN 7,492.48 540-30.6540,280000 DUES, MEMBERSHIPS & 159.62 540-30.6540.340000 MISCELLANEOUS CONTR 373.20 540-30.6540.350100 PRINTING 321.99 540-30.6540.410400 REPAIR/MAINT OF DELIV 215.15 540-30.6540.450000 TELEPHONE 72.63 540-30.6540.470000 TRAINING/TRAVEL EXPE 427.83 540-30.6540.480000 UTILITY SERVICES 87.11 540-30.6540.570000 FUEL 554.25 540-30.6540.590000 OPERATING SUPPLIES & 169.70 540-30.6540.590100 DEVELOPER MATERIALS 12,472.32 540-30.6540.590200 INSTALLATION MATERIA 514.70 540-30.6540.592000 METER PURCHASE 383.78 540-30.6540.650000 COSTOF GOODS SOLD 67,476.61 540-30.6540.685400 GAS REBATE 350.00 540-30.6540.880100 DISTRIBUTION SYSTEM I 14,784.51 560-2030500 SALES TAX COLLECTED P 1,202.08 560-80.5300.100000 HEALTH & LIFE INSURAN 4,412.63 560-80.5300.410300 REPAIR/MAINTENANCE 2,367.30 560-80.5300.540000 MINOR EQUIPMENT 3,027.30 560-80.5300.570000 FUEL 278.57 560-80.5300.590000 OPERATING SUPPLIES& 175.75 560-80.5300.880015 CENTENNIAL PARK STRE 909.38 570-30.6550.100000 HEALTH & LIFE INSURAN 1,873.70 570-30.6550.390000 RENTAL/LEASE OF EQUI 1,573.68 590-30.5400.231300 RESIDENTIAL SOLID WAS 91,772.16 750-2030500 SALES TAX COLLECTED P 2,678.02 750-80.8750.100000 HEALTH & LIFE INSURAN 1,071.90 750-80.8750.400000 REPAIR/MAINTENANCE 805.66 750-80.8750.400050 REPAIR/MAINTENANCE 296.00 750-80.8750.410050 REPAIR/MAINT-WAUKEE 152.25 750-80.8750.410350 REPAIR/MAINTENANCE I 179.29 750-80.8750.410360 REPAIR/MAINTENANCE 52.36 750-80.8750.465400 JUNIOR GOLF EXPENDIT 5,913.00 750-80.8750.480000 UTILITY SERVICES 877.27 750-80.8750.570000 FUEL 1,973.68 750-80.8750.590000 OPERATING SUPPLIES & 35.58 750-80.8750.650150 COGS-POP/WATER 1,282.28 750-80.8750.650200 COGS-SNACKS/CANDY 537.09 750-80.8750.651000 PRO SHOP MERCHANDIS 874.47 750-80.8750.651100 PRO SHOP SPECIAL ORD 1,729.16 Grand Total: 682,616.19 6/14/2017 2:19:45 PM Page 15 of 16 Expense Approval Register Packet: APPKT00637 -TUNE 20TH COUNCIL PACKET Project Account Summary Project Account Key Expense Amount **None** 682,616.19 Grand Total: 682,616.19 6/14/2017 2:19:45 PM Page 16 of 16 F` 6A Waukee City of Waukee, IA Vendor Number Vendor Name Bank Code: AP-WAUKEE STATE 047290 DOLL DISTRIBUTING, LLC Payable # Payable Type Account Number INV0003018 Invoice 750-80.8750.650100 Payment Date Payment Type 06/01/2017 Regular Payable Date Payable Description Account Name Item Description 06/01/2017 BEER DELIVERY COGS-BEER/ALCOHOL BEER DELIVERY My Check Report By Check Number Date Range: 06/01/2017 - 06/05/2017 DiscountAmount PaymentAmount Number 0.00 861.55 129025 Discount Amount Payable Amount Distribution Amount 0.00 861.55 861.55 094675 IOWA BEVERAGE SYSTEMS INC 06/05/2017 Regular 0.00 537.05 129045 Payable # Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0003047 Invoice 06/05/2017 BEER DELIVERY 0.00 537.05 750-80.8750.650100 COGS-BEER/ALCOHOL BEER DELIVERY 537.05 199023 SUGAR CREEK GOLF COURSE 06/05/2017 Regular 0.00 253.00 129046 Payable # Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0003046 Invoice 06/05/2017 LEAGUE PRIZES 0.00 253.00 750-80.8750.653000 LEAGUE PRIZES/EXPENSE LEAGUE PRIZES 253.00 Bank Code AP Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 3 3 0.00 1,651.60 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 3 3 0.00 1,651.60 6/14/2017 2:21:29 PM Page 1 of 2 My Check Report Date Range: 06/01/2017 - 06/05/2017 Fund Summary Fund Name Period Amount 999 POOLED CASH 6/2017 1,651.60 1,651.60 6/14/2017 2:21:29 PM Page 2 of 2 0 City of Waukee, IA Vloukee My Check Repo t By Check Number Date Range: 06/07/2017-06/14/2017 Vendor Number Vendor Name Payment Date Payment Type DiscountAmount PaymentAmount Number Bank Code: AP-WAUKEE STATE 011475 ACCESS SYSTEMS LEASING 06/08/2017 Regular 0.00 152.54 129236 Payable# Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount 20729457 Invoice 05/29/2017 COPIER/PRINTER LEASE 0.00 152.54 010-60.8350,270110 COPIER / PRINTER LEASE COPIER/PRINTER LEASE 152.54 103950 JIMMYJOHN'S 06/08/2017 Regular 0.00 104.00 129237 Payable# Payable Type Payable Date Payable Description DiscountAmount Payable Amount Account Number Account Name Item Description Distribution Amount INV0003066 Invoice 06/08/2017 MIX TEAM FOOD 0.00 104.00 750-80.8750.650250 COGS-FOOD/GRILL MIX TEAM FOOD 104.00 199023 SUGAR CREEK GOLF COURSE 06/08/2017 Regular 0.00 240.00 129238 Payable # Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0003067 Invoice 06/08/2017 MIX TEAM PRIZES 0.00 240.00 750-80.8750.653000 LEAGUE PRIZES/EXPENSE MIX TEAM PRIZES 240.00 203200 THE KEE 06/08/2017 Regular 0.00 729.00 129239 Payable # Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0003065 Invoice 06/08/2017 MIX TEAM CATERI NG 0.00 729.00 750-80.8750.650250 COGS-FOOD/GRILL MIX TEAM CATERING 729.00 095555 IOWA DEPT OF NATURAL RESOURCES 06/09/2017 Regular 0.00 100.00 129240 Payable # Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0003068 Invoice 06/09/2017 PERMIT- ORIGINAL SANITARY SEWER RE 0.00 100.00 520-30.6520.230000 CONSULTANT&PROFESS PERMIT- ORIGINAL SANITARY S 100.00 094675 IOWA BEVERAGE SYSTEMS INC 06/12/2017 Regular 0.00 450.50 129262 Payable Payable Type Payable Date Payable Description DiscountAmount Payable Amount Account Number Account Name Item Description Distribution Amount INV0003071 Invoice 06/12/2017 BEER DELIVERY 0.00 450.50 750-80.8750.650100 COGS-BEER/ALCOHOL BEER DELIVERY 450.50 199023 SUGAR CREEK GOLF COURSE 06/12/2017 Regular 0.00 233.00 129263 Payable # Payable Type Payable Date Payable Description DiscountAmount Payable Amount Account Number Account Name Item Description Distribution Amount INV0003070 Invoice 06/12/2017 LEAUGE PRIZES 0.00 233.00 750-80.8750.653000 LEAGUE PRIZES/EXPENSE LEAUGE PRIZES 233.00 203200 THE KEE 06/12/2017 Regular 0.00 135.00 129264 6/14/2017 2:24:26 PIA Page 1 of 3 My Check Report Vendor Number Payable # INV0003069 Vendor Name Payable Type Account Number Invoice 750-80.8750.650250 Payment Date Payment Type Payable Date Payable Description Account Name Item Description O6/12/2017 COUPLES NIGHT FOOD COGS-FOOD/GRILL COUPLES NIGHT FOOD Date Range: 06/07/2017-06/14 2017 DiscountAmount PaymentAmount Number Discount Amount Payable Amount Distribution Amount 0.00 135.00 135.00 Bank Code AP Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 8 8 0.00 2,144.04 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 8 8 0.00 2,144.04 6/14/2017 2:24:26 PM Page 2 of 3 My Check Report Date Range: 06/07/2017 - 06/14/2027 Fund Summary Fund Name Period Amount 999 POOLED CASH 6/2017 2,144.04 2,144.04 6/14/2017 2:24:26 PM Page 3 of 3 Council Payroll Reimbursements 0City of Waukee, IA By Check Number 1 / Date Range: 05/31/2017 - 06/13/2017 \kbukee Vendor Number Vendor Name Payment Date Payment Type DlscountAmount PaymentAmount Number Bank Code: AP-WAUKEE STATE 034875 CITY OF WAUKEE 05/31/2017 Regular 0.00 5,291.29 129037 Payable # Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0003023 Invoice 05/31/2017 UNIFORM DEDUCTIONS 0.00 38.27 010-2030000 PAYROLL PAYABLES UNIFORM DEDUCTIONS 15.74 060-2030000 PAYROLL PAYABLES UNIFORM DEDUCTIONS 22.53 INV0003027 Invoice 05/31/2017 CELL PHONE REIMBURSEMENT 0.00 230.00 010-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 155.00 060-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 9.38 510-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 11.31 520-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 26.24 540-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 26.26 560-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 1.81 INV0003028 Invoice 05/31/2017 GOLF APARTMENT RENT 0.00 600.00 010-2030000 PAYROLL PAYABLES GOLF APARTMENT RENT 600.00 INV0003033 Invoice 05/31/2017 LIFE INSURANCE PREMIUM 0.00 598.07 010-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 417.12 060-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 19.46 510-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 28.91 520-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 28.83 540-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 41.18 560-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 27.82 570-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 34.75 INV0003034 Invoice 05/31/2017 STD INSURANCE PREMIUM 0.00 562.45 010-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 382.49 060-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 44.67 510-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 35.73 520-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 42.27 540-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 23.64 560-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 33.65 INV0003037 Invoice 05/31/2017 HEALTH INSURANCE DEDUCTION 0.00 2,932.50 010-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 2,133.50 060-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 153.01 510-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 116.96 520-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 159.32 540-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 201.85 560-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 95.61 570-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 42.50 750-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 29.75 INV0003038 Invoice 05/31/2017 HEALTH INSURANCE DEDUCTION 0.00 330.00 010-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 255.00 060-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 15.00 510-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 18.82 520-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 18.74 540-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 3.81 560-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 3.63 570-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 15.00 036350 IOWA DEPT OF HUMAN SERVICES 05/31/2017 Regular 0.00 2,195.56 129038 6/13/2017 3:42:23 PIA Page 1 of 6 C/ Council Payroll Reimbursements Date Range: 05/31/2017 - 06/13/2017 Vendor Number Vendor Name Payment Date Payment Type DlscountAmount PaymentAmount Number Payable # Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0003019 Invoice 05/31/2017 CHILD SUPPORT 0.00 2,195.56 010-2011300 CHILD SUPPORT PAYABLE CHILDSUPPORT 1,616.70 060-2011300 CHILD SUPPORT PAYABLE CHILDSUPPORT 123.88 510-2011300 CHILD SUPPORT PAYABLE CHILDSUPPORT 227.49 520-2011300 CHILD SUPPORT PAYABLE CHILD SUPPORT 227.49 036740 COMMUNICATIONS WORKERS OF AMERICA 05/31/2017 Regular 0.00 888.78 129039 Payable # Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0003024 Invoice 05/31/2017 CWA LOCAL 7102 UNION DUES 0.00 888.78 010-2014100 CREDIT UNION DEDUCT] CWA LOCAL 7102 UNION DUES 420.99 060-2014100 CREDIT UNION DEDUCTI CWA LOCAL 7102 UNION DUES 83.11 510-2014100 CREDIT UNION DEDUCTI CWA LOCAL 7102 UNION DUES 65.87 520-2014100 CREDIT UNION DEDUCTI CWA LOCAL 7102 UNION DUES 96.49 540-2014100 CREDIT UNION DEDUCTI CWA LOCAL 7102 UNION DUES 131.02 560-2014100 CREDIT UNION DEDUCTI CWA LOCAL 7102 UNION DUES 66.02 570-2014100 CREDIT UNION DEDUCT] CWA LOCAL 7102 UNION DUES 25.28 099999 EFTPS 05/31/2017 Regular 0.00 91,645.40 129040 Payable # Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0003042 Invoice 05/31/2017 FICA TAX WITH HOLDING 0.00 42,142.78 010-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 30,644.02 060-2010300 FICA TAX WITH HOLDING FICA TAX WITHHOLDING 2,208.68 510-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 1,729.44 520-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 2,094.56 540-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 2,278.84 560-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 1,099.38 570-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 603.92 750-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 1,483.94 INV0003043 Invoice 05/31/2017 FEDERAL WITHHOLDING TAXES 0.00 39,646.56 010-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 29,353.91 060-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 2,045.90 510-2010200 FEDERAL TAX WITHHOLD] FEDERAL WITHHOLDING TAXES 1,502.32 520-2010200 FEDERAL TAX WITHHOLD] FEDERAL WITHHOLDING TAXES 2,159.28 540-2010200 FEDERAL TAX WITHHOLD] FEDERAL WITHHOLDING TAXES 2,174.25 560-2010200 FEDERAL TAX WITHHOLD] FEDERAL WITHHOLDING TAXES 991.83 570-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 826.90 750-2010200 FEDERAL TAX WITHHOLD] FEDERAL WITHHOLDING TAXES 592.17 INV0003044 Invoice 05/31/2017 MEDICARE TAX WITHHOLDING 0.00 9,856.06 010-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 7,166.84 060-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 516.60 510-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 404.60 520-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 489.84 540-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 532.84 560-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 257.10 570-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 141.24 750-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 347.00 133560 MEALS FROM THE HEARTLAND 05/31/2017 Regular 0.00 114.20 129041 Payable# Payable Type Payable Date Payable Description DiscountAmount Payable Amount Account Number Account Name Item Description Distribution Amount INV0003030 Invoice 05/31/2017 MEALS FROM HEARTLAND DEDUCTION 0.00 114.20 010-2030000 PAYROLL PAYABLES MEALS FROM HEARTLAND DED 93.66 510-2030000 PAYROLL PAYABLES MEALS FROM HEARTLAND DED 3.55 520-2030000 PAYROLL PAYABLES MEALS FROM HEARTLAND DED 2.49 560-2030000 PAYROLL PAYABLES MEALS FROM HEARTLAND DED 14.50 6/13/2017 3:42:23 PM Page 2 of 6 Council Payroll Reimbursements Date Range: 05/31/2017 - 06/13/2017 Vendor Number Vendor Name Payment Date Payment Type DiscountAmount Payment Amount Number 206800 TOTAL ADMINISTRATIVE SERVICES CORP 05/31/2017 Regular 0.00 4,464.09 129042 Payable p Payable Type Payable Date Payable Description DiscountAmount Payable Amount Account Number Account Name Item Description Distribution Amount INV0003035 Invoice 05/31/2017 SECTION 125 MEDICAL DEDUCTIONS 0.00 2,613.28 010-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 1,897.00 060-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 10.41 510-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 115.63 520-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 111.77 540-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 183.33 560-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 97.23 570-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 125.00 750-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 72.91 INV0003036 Invoice 05/31/2017 SECTION 125 DAYCARE DEDUCTIONS 0.00 1,850.81 010-2030000 PAYROLL PAYABLES SECTION 125 DAYCARE DEDUCT 1,642.48 560-2030000 PAYROLL PAYABLES SECTION 125 DAYCARE DEDUCT 208.33 213250 UN ITED WAY CENTRAL IOWA 05/31/2017 Regular 0.00 193.30 129043 Payable If Payable Type Payable Date Payable Description DiscountAmount Payable Amount Account Number Account Name Item Description Distribution Amount INV0003026 Invoice 05/31/2017 UNITED WAY DEDUCTION 0.00 193.30 010-2030000 PAYROLL PAYABLES UNITED WAY DEDUCTION 164.17 510-2030000 PAYROLL PAYABLES UNITED WAY DEDUCTION 6.90 520-2030000 PAYROLL PAYABLES UNITED WAY DEDUCTION 4.99 540-2030000 PAYROLL PAYABLES UNITED WAY DEDUCTION 10.00 560-2030000 PAYROLL PAYABLES UNITED WAY DEDUCTION 7.25 233050 WAUKEE PUBLIC LIBRARY FRIENDS FOUNDATIC 05/31/2017 Regular 0.00 36.66 129044 Payable N Payable Type Payable Date Payable Description DiscountAmount Payable Amount Account Number Account Name Item Description Distribution Amount INV0003031 Invoice 05/31/2017 LIBRARY FRIENDS FOUNDATION PAYROLL 0.00 36.66 010-2030000 PAYROLL PAYABLES LIBRARY FRIENDS FOUNDATION 29.12 510-2030000 PAYROLL PAYABLES LIBRARY FRIENDS FOUNDATION 3.55 520-2030000 PAYROLL PAYABLES LIBRARY FRIENDS FOUNDATION 2.49 560-2030000 PAYROLL PAYABLES LIBRARY FRIENDS FOUNDATION 1.50 091000 ICMA RETIREMENT TRUST 457 06/07/2017 Regular 0.00 8,679.62 129232 Payable N Payable Type Payable Date Payable Description DiscountAmount Payable Amount Account Number Account Name Item Description Distribution Amount INV0002926 Invoice 05/15/2017 ICMA ROTH CONTRIBUTION 0.00 1,432.16 010-2011200 IPERS WITHHOLDING PAY ICMA ROTH CONTRIBUTION 1,212.16 060-2011200 IPERS WITHHOLDING PAY ICMA ROTH CONTRIBUTION 50.00 540-2011200 IPERS WITHHOLDING PAY ICMA ROTH CONTRIBUTION 170.00 INV0002927 Invoice 05/15/2017 ICMA RETIREMENT 0.00 1,868.79 O10-2011200 IPERS WITHHOLDING PAY ICMA RETIREMENT 1,743.79 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 INV0002928 Invoice 05/15/2017 ICMA 0.00 994.16 010-2011200 IPERS WITHHOLDING PAY ICMA 922.61 510-2011200 IPERS WITHHOLDING PAY ICMA 18.60 520-2011200 IPERS WITHHOLDING PAY ICMA 17.90 540-2011200 IPERS WITHHOLDING PAY ICMA 18.59 560-2011200 IPERS WITHHOLDING PAY ICMA 16.46 INV0003020 Invoice 05/31/2017 ICMA ROTH CONTRIBUTION 0.00 1,432.16 010-2011200 IPERS WITHHOLDING PAY ICMA ROTH CONTRIBUTION 1,212.16 060-2011200 IPERS WITHHOLDING PAY ICMA ROTH CONTRIBUTION 50.00 540-2011200 IPERS WITHHOLDING PAY ICMA ROTH CONTRIBUTION 170.00 INV0003021 Invoice 05/31/2017 ICMA RETIREMENT 0.00 1,868.79 010-2011200 IPERS WITHHOLDING PAY ICMA RETIREMENT 1,743.79 6/13/2017 3:42:23 PM Page 3 of 6 Council Payroll Reimbursements Vendor Number Vendor Name 060-2011200 540-2011200 570-2011200 INV0003022 Invoice 010-2011200 510-2011200 520-2011200 540-2011200 560-2011200 098900 Payable # CM0000024 INV0002944 IPERS Payable Type Account Number Credit Memo 010-60.8400.080000 Invoice 010-2011200 060-2011200 510-2011200 520-2011200 540-2011200 560-2011200 570-2011200 750-2011200 INV0002945 Invoice 010-2011200 INV0002946 Invoice 010-2011200 INV0002951 INV0003039 INV0003040 208650 Payable # INV0002947 INV0002952 INV0003041 Invoice 750-2011200 Invoice 010-2011200 060-2011200 510-2011200 520-2011200 540-2011200 560-2011200 570-2011200 750-2011200 Invoice 010-2011200 Date Range: 05/31/2027 - 06/13/2017 Payment Date Payment Type Discount Amount Payment Amount Number IPERS WITHHOLDING PAY ICMA RETIREMENT 25.00 IPERS WITHHOLDING PAY ICMA RETIREMENT 50.00 IPERS WITHHOLDING PAY ICMA RETIREMENT 50.00 05/31/2017 ICMA 0.00 1,083.56 IPERS WITHHOLDING PAY ICMA 1,011.63 IPERS WITHHOLDING PAY ICMA 17.99 IPERS WITHHOLDING PAY ICMA 17.99 IPERS WITHHOLDING PAY ICMA 17.99 IPERS WITHHOLDING PAY ICMA 17.96 06/07/2017 Regular 0.00 95,063.18 129233 Payable Date Payable Description DlscountAmount PayableAmount Account Name Item Description Distribution Amount 05/31/2017 MAY'17 ROUNDING ADJUSTMENT 0.00 -0.12 IPERS CONTRIBUTION MAY'17 ROUNDING ADIUSTME -0.12 05/15/2017 IPERS DEDUCTIONS 0.00 30,538.06 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 20,000.75 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 1,905.31 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 1,417.89 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 1,821.12 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 2,366.82 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 950.50 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 697.32 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 1,378.35 05/15/2017 IPERS DEDUCTIONS 0.00 14,597.72 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 14,597.72 05/15/2017 IPERS ELECTED OFFICIAL DEDUCT 0.00 212.04 IPERS WITHHOLDING PAY IPERS ELECTED OFFICIAL DEDUC 212.04 05/15/2017 IPERS DEDUCTIONS 0.00 40.79 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 40.79 05/31/2017 IPERS DEDUCTIONS 0.00 33,073.07 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 21,060.38 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 2,110.86 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 1,770.40 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 2,214.38 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 2,610.55 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 1,038.35 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 751.86 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 1,516.29 05/31/2017 IPERS DEDUCTIONS 0.00 16,601.62 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 16,601.62 TREASURER STATE OF IOWA 06/07/2017 Regular 0.00 28,880.31 129234 Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount Invoice 05/15/2017 STATE WITHHOLDING TAXES 0.00 13,491.79 010-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 10,364.48 060-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 568.90 510-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 447.82 520-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 567.93 540-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 751.31 560-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 271.93 570-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 221.91 750-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 297.51 Invoice 05/15/2017 STATE WITHHOLDING TAXES 0.00 2.15 750-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 2.15 Invoice 05/31/2017 STATE WITHHOLDING TAXES 0.00 15,386.37 010-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 11,579.74 6/13/2017 3:42:23 PM Page 4 of 6 Council Payroll Reimbursements Vendor Number Vendor Name 060-2011100 510-2011100 520-2011100 540-2011100 560-2011100 570-2011100 750-2011100 256601 Payable n INV0002931 INV0002934 INV0003025 INV0003029 Payment Date STATE TAX W ITHHOLDIN STATE TAX W ITHHOLDIN STATE TAX W ITHHOLDIN STATE TAX W ITHHOLDIN STATE TAX WITHHOLDIN STATE TAX WITHHOLDIN STATE TAX WITHHOLDIN Payment Type STATE WITHHOLDING TAXES STATE WITHHOLDING TAXES STATE WITHHOLDING TAXES STATE WITHHOLDING TAXES STATE WITHHOLDING TAXES STATE WITHHOLDING TAXES STATE WITHHOLDING TAXES Date Range: 05/31/2017 - 06/13/2027 DiscountAmount PaymentAmount Number 752.61 566.76 699.75 883.83 348.75 241.87 313.06 YMCA OF GREATER DES MOINES 06/07/2017 Regular 0.00 1,484.00 129235 Payable Type Payable Date Payable Description DiscountAmount Payable Amount Account Number Account Name Item Description Distribution Amount Invoice 05/15/2017 YMCA FAMILY MEMBERSHIP DEDUCTION 0.00 646.00 010-2030000 PAYROLL PAYABLES YMCA FAMILY MEMBERSHIP DE 510.00 510-2030000 PAYROLL PAYABLES YMCA FAMILY MEMBERSHIP DE 17.09 520-2030000 PAYROLL PAYABLES YMCA FAMILY MEMBERSHIP DE 16.91 540-2030000 PAYROLL PAYABLES YMCA FAMILY MEMBERSHIP DE 68.00 560-2030000 PAYROLL PAYABLES YMCA FAMILY MEMBERSHIP DE 34.00 Invoice 05/15/2017 YMCA SINGLE MEMBERSHIP DEDUCTION 0.00 96.00 010-2030000 PAYROLL PAYABLES YMCA SINGLE MEMBERSHIP DE 96.00 Invoice 05/31/2017 YMCA FAMILY MEMBERSHIP DEDUCTION 0.00 646.00 010-2030000 PAYROLL PAYABLES YMCA FAMILY MEMBERSHIP DE 510.00 510-2030000 PAYROLL PAYABLES YMCA FAMILY MEMBERSHIP DE 17.05 520-2030000 PAYROLL PAYABLES YMCA FAMILY MEMBERSHIP DE 16.95 540-2030000 PAYROLL PAYABLES YMCA FAMILY MEMBERSHIP DE 68.00 560-2030000 PAYROLL PAYABLES YMCA FAMILY MEMBERSHIP DE 34.00 Invoice 05/31/2017 YMCA SINGLE MEMBERSHIP DEDUCTION 0.00 96.00 010-2030000 PAYROLL PAYABLES YMCA SINGLE MEMBERSHIP DE 96.00 Bank Code AP Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 37 12 0.00 238,936.39 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 37 12 0.00 238,936.39 6/13/2017 3:42:23 PM Page 5 of 6 Council Payroll Reimbursements U Date Range: 05131/2017 - 06/13/2017 Fund 999 999 Fund Summary Name Period Amount POOLED CASH 5/2017 104,829.28 POOLED CASH 6/2017 134,107.11 238,936.39 6/13/2017 3:42:23 PM Page 6 of 6 06-13-2017 03:45 PM PERIOD: 5/30/2017 THRU 6/13/2017 ZONE: * - All Zones REVENUE CODE: All ADJUSTMENT CODES: All ACCOUNT NO$ NAME MONTHLY TRANSACTION REPORT DATE TYPE AMOUNT REFERENCE PACKET PAGE: 1 RECEIPT ADJ 01-49501-02 HENDERSON, CORY & JANET 6/08/2017 RF-CK 218.96 REFUND CK: 129241 20530 16-00160-00 ROCK EQUITY HOLDINGS, LLC 6/08/2017 RF-CK 17.64 REFUND CK: 129242 20530 16-00309-00 ROCK EQUITY HOLDINGS, LLC 6/08/2017 RF-CK 17.64 REFUND CK: 129243 20530 83-01230-14 STILSON, BRUCE 6/08/2017 RF-CK 2.92 REFUND CK: 129244 20530 83-01235-15 CALL, CODY C 6/08/2017 RF-CK 87.50 REFUND CK: 129245 20530 84-00538-00 HUBBELL 6/08/2017 RF-CK 331.73. REFUND CK: 129246 20530 84-00569-00 HENKEL CONSTRUCTION 6/08/2017 RF-CK 288.41 REFUND CK: 129247 20530 84-01635-05 CREAGH, ROLANDO E 6/08/2017 RF-CK 55.16 REFUND CK: 129248 20530 84-02582-04 MCCARTHY, SEAN 6/08/2017 RF-CK 153.32 REFUND CK: 129249 20530 84-02830-09 BRIDGES, DAWN/ JARON 6/08/2017 RF-CK 24.13 REFUND CK: 129250 20530 84-03155-02 HAGEMAN, BAILEY 6/08/2017 RF-CK 52.25 REFUND CK: 129251 20530 84-03448-01 THE SOCIAL CANVAS 6/08/2017 RF-CK 60.48 REFUND CK: 129252 20530 85-00066-02 FENTON, TAYLER A 6/08/2017 RF-CK 46.71 REFUND CK: 129253 20530 85-00171-04 MEARDON, SARAN 6/08/2017 RF-CK 53.83 REFUND CK: 129254 20530 85-01014-03 STUHR, AMELIA J 6/08/2017 RF-CK 97.56 REFUND CK: 129255 20530 85-01177-02 VELIE, SUZANNE 6/08/2017 RF-CK 40.15 REFUND CK: 129256 20530 85-01262-00 RUSSELL HOMES LC 6/08/2017 RF-CK 136.72 REFUND CK: 129257 20530 65-01273-00 HUBBELL HOMES LC 6/08/2017 RF-CK 253.66 REFUND CK: 129258 20530 85-01292-01 BALDOCEDA, JOSE 6/08/2017 RF-CK 88.26 REFUND CK: 129259 20530 85-01400-00 ELEMENT 119 LLC 6/08/2017 RF-CK 57.49 REFUND CK: 129260 20530 06-13-2019 03:45 PM MONTHLY TRANSACTION REPORT PAGE: 2 PERIOD: 5/30/2017 THRU 6/13/2017 ZONE: * - All Zones REVENUE CODE: All ADJUSTMENT CODES: All -------------------- - -------------______=== M O N T H L Y D I S T R I B U T I O N=________________-----________________------- MONTH REVENUE CODE TYPE COUNT AMOUNT TYPE COUNT AMOUNT TYPE COUNT AMOUNT 06/2017 999 - REFUND RF-CR 20 2,084.52 MONTH TOTAL 2.0S4.52 GRAND TOTAL FOR PERIOD 2,084.52 DEPOSIT TOTAL FOR PERIOD 0.00 06-13-2019 03:45 PM MONTHLY TRANSACTION REPORT PAGE: 3 PERIOD: 5/30/2017 THRU 6/13/2017 c\// ZONE: * - All Zones REVENUE CODE: All ADOOSTMENT CODES: All ---------------- ______--- ________= R E V E N U E C 0 D E T 0 T A L S E Y T Y P E____---_______________________________ REVENUE CODE TYPE COUNT AMOUNT TYPE COUNT AMOUNT TYPE COUNT AMOUNT 999 - REFUND RF-CK 20 2,084.52 GRAND TOTAL FOR PERIOD 2,084.52 _____--- _---------- _________----- ______ T 0 T A L S E Y T R A N S A C T I O N T Y P E TYPE COUNT AMOUNT ------------------------------------------- REFUND CHECK 20 2,084.52 TOTAL FOR PERIOD 20 2,084.52 t Council Payroll Publication Report City of Waukee, 1A By Employee Name ,'r� Payroll Set: OS - City of Waukee For Date Range 05/16/2017-05/31/2017 Employee Name Salary ABBOTT, BRENT $1,396.63 ADKINS, COREY $1,320.99 ALDRICH, SHAWN $1,656.80 ALLEN, JASON $288.91 APPLE, WILLIAM $888.72 ARIAS, HECTOR $2,293.14 ARMSTRONG, BRETT $2,015.62 BAKER, RANDY $1,751.41 BARTUNG, DARREL $192.98 BAUMAN, LISA $1,281.61 BELL, RYAN $136.53 BERG, BROOKE $423.23 BEST, BRITTANY $127.01 BEST, KELSEY $102.17 WORK, ASHLEY $349.04 BOHARDT, HAZEL $337.15 BRUNS, RACHEL $1,823.04 BURKHART, LINDA $2,851.58 CAMPBELL, JUDY $601.30 CAMPBELL, SCOTT $2,103.25 CASEY, MARK $27627 CATALDO, RUDOLPH $166.99 CICHOSKI, KELLI $1,875.33 CLAYTON, KRISTIN $183.58 CLEMEN, ANTHONY $678.27 COLE, JACOB $572.29 CORKREAN, JENNIFER $1,834.78 COUCHMAN, KENNETH $186.36 COUGHLIN, TON] $1,412.97 CRAVEN, GAYLA $353.21 CUNNINGHAM, DEANA $583.96 CUNNINGHAM, SCOTT $2,138.99 DANIEL, COLE $1,315.67 DAVIS, BRIAN $482.57 DAVIS, LYRIC $24.21 DEBOER, MELISSA $1,870.06 DEETS, BRADLY $3,110.56 DEZEEUW, DAVID $2,469.70 DODGE, JUSTIN $2,110.01 DRAKE, ALISHA $799.73 DUNBAR, DIANA $1,077.27 DUNHAM, BRYCE $1,065.49 DUTCHER, DAN $3,001.86 DYKSTRA, PAYTON $33.25 EASTMAN, DAVID $719.50 EDDIE, CHASE $926.14 EDWARDS, DANAE $915.08 ELLIOTT, RYAN $949.66 ELLIOTT, STEVE $1729.29 EVANS, SUMMER $1,984.71 FLUGGE-SMITH, JAMIE $1,710.08 FORRET, DENNIS $262.72 FREDERICK, JUSTIN $1,966.84 FREEMAN, PARKER $924.32 FROEHLICH, WILLIAM $296.48 GEADELMANN, WILLIAM $90.99 GIBSON, JOHN $3,287.08 l� Employee Name Salary GITZEN, ROBERT $2,928.17 GODW IN, BRYCE $141.86 GODWIN, EDWARD $625.20 GRACE, ANDREW $821.18 GRANT, ABIGAIL $1,056.48 GROVE, BRIAN $261.07 GROVO, ANDREW $218.94 GUESS, CHRISTOPHER $533.59 HANSON, ANTHONY $2,486.46 HANSON, LAURA $1,349.60 HARDIN, THOMAS $103.60 HASKINS, STACEY $1,297.52 HEIMANN, RONALD $2,283.89 HENTGES, ERIC $667.31 HERR, JENNA $1,552.65 HERRICK, ROBERT $1,864.96 HILGENBERG, ADAM $1,818.69 HILLYER, COLDEN $751.11 HOCHSTETLER, DENNIS $842.60 HOLDEN, PATRICIA $2,864.57 HOPTON, SIMONE $100.90 HULSING, TAYLOR $532.74 HUSTED, TROY $1,678.30 HUTTON, JOSHUA $543.04 IRWIN, BRENT $244.68 JENSEN, CHAD $336.34 JENSEN,SHELBY $460.99 JERMIER, MATTHEW $2,539.84 JOHNSON, GABLE $330.15 JONES, KACIE $184.27 KASS, ANDREW $2,333.92 KASZINSKI, BRETT $618.36 KELLER, CHRISTOPHER $1,967.69 KERR, JACOB $1,513.37 KIES, SUSAN $1,678.50 KOESTER, EVAN $1,574,61 KOESTER, RUDY $2,248.39 KOPPES, BROOKE $159.69 LARSON, KENNETH $159.29 LARSON, KRISTINE $2,406.06 LAUGHRIDGE, DANIEL $1,655.78 LEMKE, NEIL $1,247.06 LEON, NATHAN $900.62 LOFTSGARD, MARA $395.50 LONG, JEREMY $2,319.60 LOVE, WILLIAM $131.88 LYNCH, JEREMY $840.10 LYNCH, SHANNON $1,611.82 MANNING, JOSHUA $2,018.24 MANNING, TAYLOR $77.37 MAPES, TROY $2,601.77 MARTIN, MEGAN $202.24 MCCLINTIC, LAMES $1,206.89 MCKERN, DOUGLAS $661.64 MEANS, KEATON $102.17 MEDDERS, BRETT $1,290.06 MELLENCAMP, JEFFREY $2,438.97 MICKELSON, EMILY $406.88 MINIKUS, JOSHUA $2 268.80 MOERMAN, TIMOTHY $3,857.98 MORFORD, PAIGE $739.89 MURRA, BRIAN $1,843.69 NITZEL, NICOLE $676.06 NOGA, SARAH $24.21 Employee Name Salary OAKLEY, JON $1,620.88 OLSEN, KARI $1,602.59 OSTRING, KATHLEEN $1,585.02 PARISH, TONJA $1,433.30 PARKER, SUSAN $254.05 PAYNE, THOMAS $575.60 PELLETTERI, SALVATORE $119.63 PERDRIAU, MARIE $262.64 PETERSON, KATIE $1,268.98 PETERSON, OREN $2,034.23 PETTIT, BRANDON $1,737.59 PIERSON, DAMON $1,337.59 PINEGAR, TOMMIE $1,284.49 PIZINGER, JAMES $1,287.48 POSADAS, OSCAR $656.29 PROHASKA, JOSHUA $1,056.48 PUDENZ, COLE $527.45 PUDENZ, DANIELLE $38.71 PURVIS, KATHRYN $1,304.10 QUINN, JOHN $2,719.27 RALEY, MORGAN $45.71 RASH, RONALD $1,902.02 REESE, JAMES $650.65 RICHARDSON, ELIZABETH $1,802.47 RICHTER, ALICIA $28.16 RIPPERGER, TRACY $192.13 ROBINSON, CLINT $3,238.99 ROOSE, NICHOLAS $875.29 ROYER, TIMOTHY $2,701.18 ROYSTER, JACOB $1,393.22 SANDQUIST, BENJAMIN $318.76 SCHAUFENBUEL, KARI $953.12 SCHETTLER, RODNEY $2,008.38 SCHMEINK, AMANDA $192.08 SCHUETT, REBECCA $2,391.89 SEDDON, JOSH $134.57 SEESE, KATELYN $62.33 SHARON, JEREMIAH $1,430.07 SKELLENGER, AMANDA $72.00 SNELSON, NATHANIEL $133.81 SNYDER, ALLISON $465.09 SPOSETO, MACKENZIE $2,241.51 SPRAGUE, MATTHEW $1,998.81 STEFFES, HANNAH $135.20 STEINKE, KURT $312.50 STEPHENS, CLINT $271.64 STEWARD, ERIC $1,913.95 STOTZ, MELISSA - $605.65 SUETSUGU, SEAN $120.37 TERLOUW, KYLE $2,009.45 TETMEYER, CARL $509.22 THAYER, CHANDLER $728.87 THOMAS, JULIE $238.63 TIBBLES, STEVEN $1,620.16 TUEL, JASON $280.87 TYSDAL, THOMAS $2,273.32 VANDE KAMP, JOSHUA $1,540.16 VANROEKEL, DREW $916.31 VOEGTLE, TIMOTHY $1,602.13 VOKES, LARRY $1,772.47 WALLACE, ERIC $1,522.89 WARD, WILLIAM $529.12 WASKE, CHARLES $1,880.53 WAUGH, DOUGLAS $813.00 l� Employee Name Salary WAYCASTER, SAVANNAH $151.18 WEBSTER, JACKSON $882.30 WERTS, DANIEL $2,013.12 WESTON STOLL, KERI $1,499.03 WHITE, JASON $1,458.67 WHITE, LEAH $1,208.30 W IEDNER, TYLER $946.16 WIGGINS, MATHEW $1,973.61 W ILSON, JODY $1,239.54 WINTERS, TROY $1,944.38 WISE, NATHAN $2,463.72 WOOD, DANIEL $1,229.67 WRIGHT, PAUL $821.18 YATES, CASSANDRA $638.55 YOUNG, BRIANNA $741.57