Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2016-07-05-J01A 07052016_bill list_payroll
City of Waukee Bill Presentation Recap July 5, 2 o 16 Total Unpaid Bills Presented for Approval : $1,076,782.37 Total Checks Issued Prior to Council Approval: Regular Checks: A) Prior to Last Council Meeting $5,724.05 B) After Last Council Meeting $137,655.06 C) Payroll Taxes & Reimbursements $85,833.48 Payroll Checks Issued: D) 06/15/2016 $202,836.73 �J Grand Total: $1,508,831.69 p- FY 2016 Fund Recap: Expenditures Revenues Budgeted Year To Date Budgeted Year To Date 010 General Fund $ 8,715,014 $ 8,674,795 $ 8,800,923 $ 7,553,418 060 Road Use Tax Fund $ 2,324,144 $ 2,070,941 $ 1,924,000 $ 1,760,279 075 Waukee Foundation $ - $ 1,622 $ - $ 137,434 091 Hickman West Indust Park TIF $ 422,542 $ - $ 561,972 $ 553,436 092 Enterprise Business Park TIF Fund $ 221,858 $ - $ 228,523 $ 228,827 093 Waukee Urban Renewal Area TIF Fund $ 4,498,378 $ 494,258 $ 2,604,135 $ 2,559,709 094 Gateway Urban Renewal $ - $ 6,689 $ - $ - 095 Autumn Ridge Urban Renewal $ - $ 4,024 $ - $ - 110 Debt Service Fund $ 6,124,643 $ 7,915,000 $ 6,738,241 $ 3,170,087 111 Special Assessments Fund $ 45,160 $ 45,160 $ 42,200 $ 29,738 210 Employee Benefits Fund $ 1,343,400 $ - $ 1,385,441 $ 1,382,652 327 Capital Projects $ 24,545,000 $ 8,981,767 $ 4,545,000 $ 10,390,326 330 City Wide SA Sidewalk Project $ - $ - $ - $ 8,506 510 Water Utility Fund $ 4,175,932 $ 4,872,104 $ 3,850,180 $ 3,600,258 520 Sewer Utility Fund $ 3,063,609 $ 2,824,818 $ 3,441,853 $ 4,046,389 521 University Ave Trunk Sewer Project $ - $ - $ - $ 4,758 522 Waste Water Treatment PI $ - $ - $ - $ 24 523 E Area Pump Sta. Treatment $ - $ - $ - $ 84 540 Gas Utility Fund $ 4,937,135 $ 4,329,563 $ 5,649,140 $ 4,939,049 560 Storm Sewer Utility Fund $ 637,120 $ 650,211 $ 521,150 $ 530,134 570 Utility Bill Fund $ 254,500 $ 234,997 $ 234,400 $ 204,701 590 Solid Waste Collect & Rcycl Fund $ 986,950 $ 1,011,419 $ 981,200 $ 973,513 750 Golf Course Fund $ 659,917 $ 516,811 $ 629,300 $ 675,807 810 Equipment Revolving Fund $ - $ - $ 20,000 $ 79 Total: $ 62,955,302 $ 42,634,178 $ 42,157,658 $ 42,749,207 City of Waukee FY2016 Department Report - General Fund As of June 6th, 2016 Packets Expended YTD Budgeted $ Remaining General Fund: Police Department Personnel Services $ 1,951,959 Supplies & Services $ 261,099 Capital Outlay $ 117,013 $ 2,330,071 $ 2,368,500 $ 38,429 Warning Sirens Personnel Services $ - Supplies & Services $ 4,027 Capital Outlay $ - $ 4,027 $ 1,500 $ (2,527) Westcom Dispatch Personnel Services $ - Supplies & Services $ 354,185 Capital Outlay $ - $ 354,185 $ 320,000 $ (34,185) Fire Department Personnel Services $ 675,412 Supplies & Services $ 99,569 Capital Outlay $ 17,447 $ 792,428 $ 812,450 $ 20,022 EMS Personnel Services $ 566,953 Supplies & Services $ 85,641 Capital Outlay $ 17,447 $ 670,041 $ 659,100 $ (10,941) Building Inspection Personnel Services $ 217,351 Supplies & Services $ 22,820 Capital Outlay $ 17,156 $ 257,327 $ 266,280 $ 8,953 Animal Control Personnel Services $ - Supplies & Services $ 2,869 Capital Outlay $ - $ 2,869 $ 1,000 $ (1,869) Street Lighting Personnel Services Supplies & Services $ Capital Outlay $ - Traffic Signals Personnel Services $ - Supplies & Services $ (33) Capital Outlay $ - $ (33) $ - $ 33 Public Works Personnel Services $ 68,641 Supplies & Services $ (16,047) Capital Outlay $ 26,374 $ 78,969 $ 59,558 $ (19,411) Public Works Building Personnel Services Supplies & Services $ 153,572 Capital Outlay $ - $ 153,572 $ 10,000 $ (143,572) Public Works Mechanic Personnel Services $ 175,334 Supplies & Services $ 127,303 Capital Outlay $ 8,812 $ 311,448 $ 194,550 $ (116,898) Engineering Personnel Services $ 302,696 Supplies & Services $ 63,248 Capital Outlay $ 33,415 $ 399,360 $ 644,916 $ 245,556 GIS Personnel Services $ 26,595 Supplies & Services $ (5,953) Capital Outlay $ - $ 20,642 $ 22,851 $ 2,209 Mosquito Control Personnel Services $ - Supplies & Services $ 4,500 Capital Outlay $ - $ 4,500 $ 4,000 $ (500) Library Services Personnel Services $ 521,134 Supplies & Services $ 170,640 Capital Outlay $ - $ 691,774 $ 762.090 $ 70,316 Parks Personnel Services $ 250,634 Supplies & Services $ 182,059 Capital Outlay $ 24,324 $ 457,017 $ 445,634 $ (11,383) Recreation Personnel Services $ 319,642 Supplies & Services $ 159,881 Capital Outlay $ - $ 479,522 $ 484,809 $ 5,287 Community Center Personnel Services $ 3,259 Supplies & Services $ 25,378 Capital Outlay $ - $ 28,637 $ 22,820 $ (5,817) Median & Bldg Grounds Personnel Services Supplies & Services $ 10,919 Capital Outlay $ - $ 10,919 $ 14,000 $ 3,081 Community Development Personnel Services $ 203,934 Supplies & Services $ 120,200 Capital Outlay $ 324,134 $ 299,270 $ (24,864) Development Services Personnel Services $ 304,686 Supplies & Services $ 50,253 Capital Outlay $ - $ 354,939 $ 378.785 $ 23,846 Mayor & Council Personnel Services $ 35,335 Supplies & Services $ 22,312 Capital Outlay $ - $ 57,647 $ 71,920 $ 14,273 Elections Personnel Services $ - Supplies & Services $ 8,101 Capital Outlay $ - $ 8,101 $ 8,000 $ (101) Communications Personnel Services $ 52,703 Supplies & Services $ 31,898 Capital Outlay $ - $ 84,602 $ 96,362 $ 11,760 Administration Personnel Services $ 172,213 Supplies & Services $ 125,348 Capital Outlay $ 44,064 $ 341,625 $ 328,580 $ (13,045) City Hall Personnel Services Supplies & Services $ 63,134 Capital Outlay $ 3,590 $ 66,724 $ 75,000 $ 8,276 Human Resources Personnel Services $ 67,890 Supplies & Services $ 19,106 Capital Outlay $ - $ 86,995 $ 59,745 $ (27,250) Finance Personnel Services $ 86,222 Supplies & Services $ 62,531 Capital Outlay $ 29,346 $ 178,098 $ 147,724 $ (30,374) City Attorney Personnel Services $ - Supplies & Services $ 124,653 Capital Outlay $ - Transfers to GO Debt Service $ 124,653 $ 100,000 $ (24,653) $ 55,570 $ 55,570 $ 8,674,795 $ 8,715,014 $ 40,219 Total General Fund: Personnel Services $ 6,002,593 Supplies & Services $ 2,333,213 Capital Outlay $ 338,989 $ 8,674,795 Expense Approval Register City of Waukee, IA APPKT00239 -JULY 6TH 2O16 COUNCIL PACKET WoLJkee Vendor Name Payable Number Post Date Description (Item) Account Number Amount BANKERS TRUST COMPANY INV0001113 07/06/2016 JULY'16 SINKING FUND TRA 110-1080100 569,450.00 BANKERS TRUST COMPANY INV0001113 07/06/2016 JULY'16 SINKING FUND TRA 510-1080100 27,050.00 BANKERS TRUST COMPANY INV0001113 07/06/2016 JULY'16 SINKING FUND TRA 520-1080100 9,950.00 BANKERS TRUST COMPANY INV0001113 07/06/2016 JULY'16 SINKING FUND TRA 540-1080100 35,050.00 DES MOINES WATERWORKS INV0001118 06/29/2016 JULY 2016 WATER REV BON 510-2321200 26,987.49 668,487.49 Department: 0000 - GENERAL REVENUES ALL AMERICAN TURF BEAUT INV0001077 06/16/2016 PEDDLERS PERMIT BOND RE 010-00.0000.3230100 100.00 Department 0000 - GENERAL REVENUES Total: 100.00 Department: 1100 - POLICE OPERATIONS MID AMERICAN ENERGY 000010616 06/20/2016 JUNE'16 STATEMENT 010-10.1100.480000 1,126.36 KIESLER'S POLICE SUPPLY, IN 00001241 06/13/2016 HOLSTERS 010-10.1100.120000 1,578.75 KIESLER'S POLICE SUPPLY, IN 00001245 06/21/2016 OPTIC 010-10.1100.540000 404.00 HEARTLAND FINISHES, INC 00917 06/22/2016 LOCKER ROOM RENOVATIO 010-10.1100.400000 1,849.00 TYLER TECHNOLOGIES INC 025-159696 07/01/2016 FY17 SOFTWARE MAINTENA 010-10.1100.270000 785.41 KIESLER'S POLICE SUPPLY, IN 0795798 06/14/2016 LIGHT/HOLSTER/POUCH 010-10.1100.120000 603.38 BRODERICK ANIMALCLINIC 130117 06/16/2016 CANINE/FELINE BOARDING 010-10.1100.460000 500.00 RI LAWN SERVICE INC 13655 06/23/2016 FERTILIZER/SPOT SPRAY POU 010-10.1100.400000 SS.00 SIMPLEXGRINNELL LP 143007 05/30/2016 ALARM MONITORING 07/20 010-10.1100,400000 400.80 STIVERS FORD 149021 06/15/2016 REPAIRS ON VEHICLE 010-10.1100.410000 114.00 STIVERS FORD 149156 06/16/2016 REPAIRS ON VEHICLE 010-10.1100.410000 114.00 STIVERS FORD 149407 06/20/2016 INSTALLSEATS 010-10.1100.410000 38.00 MIDWEST RADAR &EQUIPM 159521 06/24/2016 RADAR MAI NT 010-10.1100.410200 400.00 IDEAL FLOORS, INC 16985 06/14/2016 FLOORING PUBLIC SAFETY 010-10.1100.830100 4,500.00 ACCESS SYSTEMS LEASING 18926270 06/16/2016 JUNE'16 PRINTER/COPIER LE 010-10.1100.270110 1,190.79 ELECTRONIC ENGINEERING C 221000078-1 06/13/2016 REPAIR TO PRINTER 010-10.1100.410100 135.00 HOLMES MURPHY 370590 07/01/2016 HMA MONTHLY CONSULTIN 010-10.1100.100000 691.16 CARPENTER UNIFORM CO 416553 06/17/2016 UNIFORMS -POLICE 010-10.1100.120000 208.97 CARPENTER UNIFORM CO 416554 06/17/2016 UNIFORMS -POLICE 010-10.1100.120000 123.98 CARPENTER UNIFORM CO 416556 06/17/2016 UNIFORMS -POLICE 010-10.1100,120000 208.97 CARPENTER UNIFORM CO 416557 06/17/2016 UNIFORMS -POLICE 010-10.1100.120000 123.98 CARPENTER UNIFORM CO 416558 06/17/2016 UNIFORMS -POLICE 010-10.1100.120000 208.97 CARPENTER UNIFORM CO 416669 06/20/2016 PANTS-KIES 010-10.1100.120000 75.99 CARPENTER UNIFORM CO 416692 06/20/2016 UNIFORMS -POLICE 010-10.1100.120000 719.84 CARPENTER UNIFORM CO 416820 06/22/2016 SHIRTS 010-10.1100.120000 49.99 CARPENTER UNIFORM CO 417036 06/24/2016 EMBLEM 010-10.1100.120000 12.00 NATIONWIDE OFFICE CLEAN 51613 06/15/2016 JUNE'16 CLEANING -POLICE 010-10.1100.400100 554.24 DELTA DENTAL 568890 07/01/2016 DELTA DENTAL 010-10.1100.100000 1,570.08 BROKEN ARROW WEAR 593380 06/15/2016 SAFETY CITY SHIRTS 010-10A100.460200 27.25 ROCK RIVER ARMS, INC. 747196 06/16/2016 RIFLE/MOUNT/MAGAZINE 010-10.1100.540000 1,065.00 OFFICE DEPOT 844156894001 06/08/2016 USB/CD HOLDERS 010-10.1100.580000 10.98 OFFICE DEPOT 844156894001 06/08/2016 USB/CD HOLDERS 010-10.1100.590000 119.94 OFFICE DEPOT 844157284001 06/08/2016 LABELSITEA 010-10.1100.580000 21.93 OFFICE DEPOT 844157284001 06/08/2016 LABELSITEA 010-10,1100.590000 4.67 OFFICE DEPOT 844157285001 06/08/2016 LEXAR MULTI -CARD READER 010-10.1100,590000 33.59 OFFICE DEPOT 844676842001 06/10/2016 CONTAINER/SNACKS 010-10.1100.460200 88.33 OFFICE DEPOT 844676842001 06/10/2016 CONTAINER/SNACKS 010-10.1100.590000 70.81 RAIN KING LLC 861938 05/03/2016 REPAIRED LEAKS/REPLACED 010-10.1100.690000 268.98 STRAUSS SAFE AND LOCK CO 961978-000 06/15/2016 SAFE LOCK 010-10.1100.590000 450.00 VERIZON WIRELESS 9767024196 06/13/2016 JUNE'16 STATEMENT 010-10.1100.450000 948.29 VERIZON WIRELESS 9767024197 06/13/2016 JUNE'16 STATEMENT 010-10.1100.450000 22.64 HY-VEE INV0001079 06/20/2016 JUNE'16 FUELSTATEMENT-P 010-10.1100.570000 4,723.71 ACCESS SYSTEMS INV436362 06/17/2016 INSTALL DRIVES -POLICE 010-10.1100.410200 152.16 ACCESS SYSTEMS INV436403 06/17/2016 EXTERNAL HARD DRIVE 010-10.1100.410200 979.02 6/29/2016 3:53:29 PIA Page 1 of 19 Expense Approval Register Packet: APPKT00239 -DULY 6TH 2O16 COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount ACCESS SYSTEMS INV436790 06/20/2016 JUNE'16 SERVICE FEE 010-10.1100.270100 459.12 ACCESS SYSTEMS INV438223 06/23/2016 WIRELESS ACCESS POINT 010-10.1100.540000 609.00 WAUKEE LEADERSHIP INSTIT WLI GRADUATION 06/21/2016 WLI GRADUATION DINNER C 010-10.1100.470000 75.00 Department 1100 - POLICE OPERATIONS Total: 28,473.08 Department: 1400 - FIRE PROTECTION MID AMERICAN ENERGY 000010616 06/20/2016 JULY'16 STATEMENT 010-10.1400,480000 746.55 UNITED PARCEL SERVICE OOOOAW7647246 06/11/2016 LATE FEE ON INV OOOOAW76 010-10.1400.360000 8.28 FIRE SERVICE TRAINING BUR 002297 06/13/2016 REG FEE -WISE 010-10.1400.470000 25.00 TYLER TECHNOLOGIES INC 025-159696 07/01/2016 FYI7 SOFTWARE MAINTENA 010-10.1400.270000 785.41 ED M FELD EQUIPMENTCO 0297167-IN 06/14/2016 VALVE REPAIR 010-10.1400.400000 770.00 ED M FELD EQUIPMENTCO 0297172-IN 06/14/2016 BATTERY 010-10.1400.410000 60.00 ED M FELD EQUIPMENTCO 0297182-IN 06/14/2016 GEAR REPAIR 010-10.1400.540000 132.00 XEROX GOVERNMENT SYSTE 1274083 06/08/2016 FH COULD ANNUAL CONTRA 010-10.1400.540000 1,340.50 RJ LAWN SERVICE INC 13655 06/23/2016 FERTILIZER/SPOT SPRAY POU 010-10.1400.400000 27.50 SIMPLEXGRINNELL LP 143007 05/30/2016 ALARM MONITORING 07/20 010-10.1400.400000 200.40 ACCESS SYSTEMS LEASING 18926220 06/16/2016 JUNE'16 PRINTER/COPIER LE 010-10.1400.270110 127.98 HOLMES MURPHY 370590 07/01/2016 HMA MONTHLY CONSULTIN 010-10.1400.100000 177.33 MENARDS 43995 05/15/2016 STARTER 010-10.1400.590000 59.50 DUO SAFETY LADDER CORPO 456227-00 06/16/2016 HEAT SENSOR LABEL 010-10.1400.590000 37.32 MENARDS 47015 06/15/2016 BATTERY 010-10.1400.590000 5.00 MENARDS 47083 06/16/2016 TOWER FAN/FLY RIBBONS 010-10.1400.580000 13.41 DELTA DENTAL 568890 07/01/2016 DELTA DENTAL 010-10.1400.100000 446.89 MIDWEST AUTOMATIC FIRE 85865 06/08/2016 BUILDING SPRINKLER REPAIR 010-10.1400.400000 552.71 VERIZON WIRELESS 9767024196 06/13/2016 JUNE'16 STATEMENT 010-10.1400.450000 172.58 FASTENAL COMPANY IAGRM80876 06/01/2016 SHOP SUPPLIES 010-10.1400.590000 1.62 ALTOONA FIRE DEPARTMEN INV0001111 06/16/2016 ECG/CAPNOGRAPHY/STETH 010-10.1400.470000 50.00 UNITYPOINT HEALTH INV0001112 06/16/2016 INJECTIONS/IMMUNIZATION 010-10.1400.590000 160.50 UNITYPOINT HEALTH INV0001112 06/16/2016 INJECTIONS/IMMUNIZATION 010-10.1400.590000 160.50 ACCESS SYSTEMS INV436790 06/20/2016 JUNE'16 SERVICE FEE 010-10.1400.270100 172.74 ALERT -ALL CORPORATION W11903 06/08/2016 BIKE BOTTLES/BADGES 010-10.1400.460100 420.00 Department 1400 - FIRE PROTECTION Total: 6,653.72 Department: 1500 - EMS MID AMERICAN ENERGY 000010616 06/20/2016 JULY'16 STATEMENT 010-10.1500.480000 746.55 FIRE SERVICE TRAINING BUR 002297 06/13/2016 REG FEE -WISE 010-10.1500.470000 25.00 TYLER TECHNOLOGIES INC 025-159696 07/01/2016 FYI7 SOFTWARE MAINTENA 010-10.1500.270000 785.41 XEROX GOVERNMENTSYSTE 1274083 06/08/2016 FH COULDANNUAL CONTRA 010-10.1500.540000 1,340.50 RJ LAWN SERVICE INC 13655 06/23/2016 FERTILIZER/SPOT SPRAY POLI 010-10.1500.400000 27.50 SIMPLEXGRINNELL LP 143007 05/30/2016 ALARM MONITORING 07/20 010-10.1500.400000 200.40 MERCY SCHOOL OF EMERGE 22746 06/15/2016 PALS RENEWAL COURSE FEE 010-10.1500.470000 100.00 HOLMES MURPHY 370590 07/01/2016 HMA MONTHLY CONSULTIN 010-10.1500.100000 177.34 MENARDS 43995 05/15/2016 STARTER 010-10.1500.590000 59.50 MENARDS 47015 06/15/2016 BATTERY 010-10.1500.590000 4.99 MENARDS 47083 06/16/2016 TOWER FAN/FLY RIBBONS 010-10,1500.580000 13.42 DELTA DENTAL 568890 07/01/2016 DELTA DENTAL 010-10.1500,100000 446.90 BOUND TREE MEDICAL 82183203 06/16/2016 MEDICAL SUPPLIES 010-10.1500.590050 494.76 VERIZON WIRELESS 9767024196 06/13/2016 JUNE'16 STATEMENT 010-10.1500.450000 172.58 ALTOONA FIRE DEPARTMEN INVO001111 06/16/2016 ECG/CAPNOGRAPHY/STETH 010-10.1500.470000 50.00 ACCESS SYSTEMS INV436790 06/20/2016 JUNE'16 SERVICE FEE 010-10.1500.270100 143.03 Department 1500 - EMS Total: 4,787.88 Department: 1600 - STREET LIGHTING MID AMERICAN ENERGY 160080616 06/20/2016 JUNE'16 STATEMENT 060-30,1600.480000 509.57 MID AMERICAN ENERGY 200080616 06/20/2016 JUNE'16 STATEMENT 060-30,1600.480000 650.21 MID AMERICAN ENERGY 300210616 06/22/2016 JUNE'16 STATEMENT 060-30.1600.480000 3.86 MID AMERICAN ENERGY 720060616 06/20/2016 JUNE'16 STATEMENT 060-30,1600.480000 521.06 MID AMERICAN ENERGY 860480616 06/20/2016 JUNE'16 STATEMENT 060-30A600.480000 16.53 Department 1600 - STREET LIGHTING Total: 1,701.23 Department: 1601- TRAFFIC SIGNALS MID AMERICAN ENERGY 060280616 06/20/2016 JUNE'16 STATEMENT 060-30.1601.480000 21.82 SNYDER & ASSOCIATES INC 115.0204.01-13 05/31/2016 CITY CONSTRUCTION INSPEC 327-90.1601.235020 899.52 6/29/2016 3:53:29 PM Page 2 of 19 Expense Approval Register Packet: APPK700239 -JULY 6TH 2O16 COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount SNYDER & ASSOCIATES INC 115.0204.01-13 05/31/2016 CITY CONSTRUCTION INSPEC 327-90.1601.235020 1,157.76 MID AMERICAN ENERGY 160060616 06/20/2016 JUNE'16 STATEMENT 060-30.1601.480000 24.98 MID AMERICAN ENERGY 240090616 06/20/2016 JUNE'16 STATEMENT 060-30.1601.480000 16.72 MID AMERICAN ENERGY 350760616 06/20/2016 JUNE'16 STATEMENT 060-30.1601.480000 28.84 MID AMERICAN ENERGY 520110616 06/20/2016 JUNE'16 STATEMENT 060-30,1601.480000 10.00 MID AMERICAN ENERGY 530030616 06/20/2016 JUNE'16 STATEMENT 060-30.1601.480000 23.06 MID AMERICAN ENERGY 641750616 06/20/2016 JUNE'16 STATEMENT 060-30.1601.480000 14.50 MID AMERICAN ENERGY 740030616 06/20/2016 JUNE'16 STATEMENT 060-30.1601.480000 36.79 Department 1601 - TRAFFIC SIGNALS Total: 2,233.99 Department: 1900 - BUILDING INSPECTION TYLER TECHNOLOGIES INC 025-159696 07/O1/2016 FY17 SOFTWARE MAINTENA 010-10.1900.270000 785.41 ACCESS SYSTEMS LEASING 18926220 06/16/2016 JUNE'16 PRINTER/COPIER LE 010-10.1900.270110 111.87 G&LCLOTHING 2-171757 06/11/2016 UNIFORMS 010-10.1900.120000 106.25 HOLMES MURPHY 370590 07/O1/2016 HMA MONTHLY CONSULTIN O10-10.1900,100000 109.13 DELTA DENTAL SG8890 07/01/2016 DELTA DENTAL 010-10.1900.100000 268.95 DUAX SNOW REMOVAL &LA 7600 06/03/2016 MOWING -2180 SE LEEANN 010-10.1900.230200 40.00 WD DESIGNS 94973 06/28/2016 SHIRTS 010-10.1900.120000 26.45 WD DESIGNS 94973 06/28/2016 SHIRTS 010-10.1900.120000 26.45 WD DESIGNS 94973 06/28/2016 SHIRTS 010-10.1900.120000 37.47 WD DESIGNS 94973 06/28/2016 SHIRTS 010-10.1900.120000 122.46 VERIZON WIRELESS 9767024196 06/13/2016 JUNE'16 STATEMENT 010-10.1900.450000 175.80 HEARTLAND CO-OP INV0001116 05/31/2016 MAY'16 STATEMENT-BLDG010-10.1900.570000 177.07 ACCESS SYSTEMS INV436790 06/20/2016 JUNE'16 SERVICE FEE 010-10.1900.270100 66.11 Department 1900 - BUILDING INSPECTION Total: 2,053.42 Department: 2130 - ALICES ROAD PROJECT SNYDER & ASSOCIATES INC 115.0204,01-13 05/31/2016 CITY CONSTRUCTION INSPEC 327-90.2130.230052 487.50 SNYDER & ASSOCIATES INC 115.0204,01-13 05/31/2016 CITY CONSTRUCTION INSPEC 327-90.2130.840420 75.00 SNYDER & ASSOCIATES INC 115.0204,01-13 05/31/2016 CITY CONSTRUCTION INSPEC 327-90.2130.840470 75.00 CONFLUENCE 13009 06/23/2016 PLANNING CONTRACT - PHA 327-90.2130.840470 24,754.50 CONFLUENCE 13010 06/23/2016 KETTLESTONE STREETSCAPE 327-90.2130.840470 10,903.50 KIRKHAM MICHAEL & ASSOC 85310 06/22/2016 ALICES RD INTERCHG/IJR/FN 327-90.2130.230000 11,737.82 Department 2130 - ALICES ROAD PROJECT Total: 48,033.32 Department: 3100 - LIBRARY SERVICES TYLER TECHNOLOGIES INC 025-159696 07/01/2016 FYI7 SOFTWARE MAINTENA 010-40.3100.270000 785.41 JONES LIBRARY SALES INC 0616-006 06/21/2016 MULTIMEDIA SHELF 010-40.3100.410100 1,650.00 BUDGET LIBRARY SUPPLIES 14232 06/10/2016 SCANNER/PAPER 010-40.3100.580000 457.50 MCFARLAND CLINIC PC 1562230 06/07/2016 PRE -EMPLOYMENT DRUG SC 010-40.3100.470000 43.00 ACCESS SYSTEMS LEASING 18926220 06/16/2016 JUNE'16 PRINTER/COPIER LE 010-40.3100.270110 274.78 HOLMES MURPHY 370590 07/01/2016 HMA MONTHLY CONSULTIN 010-40.3100.100000 218.26 TRUGREEN 48192896 06/23/2016 LAWN SERVICE 010-40.3100.400000 240.00 MERRITT COMPANY INC 48304 06/21/2016 JUNE 2016 CLEANING 010-40.3100.400100 530.00 DELTA DENTAL 568890 07/01/2016 DELTA DENTAL 010-40.3100.100000 400.84 OFFICE DEPOT 8362935377001 04/22/2016 SUPPLIES 010-40.3100.580000 117.59 OFFICE DEPOT 836295484001 04/22/2016 KOLD INSTANT ICE COMPRES 010-40.3100.580000 3.39 OFFICE DEPOT 840215410001 05/17/2016 SUPPLIES 010-40.3100.580000 337.65 OFFICE DEPOT 840216382001 05/17/2016 CORDLESS WATER KETTLE 010-40.3100.580000 30.69 OFFICE DEPOT 844044151001 06/08/2016 PORTFOLIO/WATER/PAPER 010-40,3100.580000 98.79 OFFICE DEPOT 844384424001 06/09/2016 TABLE/18GAL BIN 010-40.3100.580000 84.91 OFFICE DEPOT 844410698001 06/09/2016 MONITOR 010-40.3100.540000 168.32 INGRAM LIBRARY SERVICES 93392523 06/09/2016 BOOKS 010-40.3100.590000 1.19 INGRAM LIBRARY SERVICES 93392523 06/09/2016 BOOKS 010-40.3100.640000 24.37 INGRAM LIBRARY SERVICES 93404169 06/10/2016 BOOKS 010-40.3100.590000 3.04 INGRAM LIBRARY SERVICES 93404169 06/10/2016 BOOKS 010-40.3100.640000 6.59 INGRAM LIBRARY SERVICES 93404170 06/10/2016 BOOKS 010-40.3100.590000 1.19 INGRAM LIBRARY SERVICES 93404170 06/10/2016 BOOKS 010-40.3100.640000 2.87 INGRAM LIBRARY SERVICES 93404171 06/10/2016 BOOKS 010-40.3100.590000 5.78 INGRAM LIBRARY SERVICES 93404171 06/10/2016 BOOKS 010-40.3100.640000 36.48 INGRAM LIBRARY SERVICES 93404172 06/10/2016 BOOKS 010-40,3100,590000 130.30 INGRAM LIBRARY SERVICES 93404172 06/10/2016 BOOKS 010-40.3100.640000 385.17 6/29/2016 3:53:29 PM Page 3 of 19 Expense Approval Register Packet: APPKT00239 -DULY 6TH 2O16 COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount INGRAM LIBRARY SERVICES 93404173 06/10/2016 BOOKS 010-40.3100.640000 94.50 INGRAM LIBRARY SERVICES 93411953 06/12/2016 BOOKS 010-40,3100.590000 0.90 INGRAM LIBRARY SERVICES 93411953 06/12/2016 BOOKS 010-40.3100,640000 22.49 INGRAM LIBRARY SERVICES 93411954 06/12/2016 BOOKS 010-40.3100.590000 0.25 INGRAM LIBRARY SERVICES 93411954 06/12/2016 BOOKS 010-40.3100.640000 9.74 INGRAM LIBRARY SERVICES 93411955 06/12/2016 BOOKS 010-40.3100.590000 0.54 INGRAM LIBRARY SERVICES 934119SS 06/12/2016 BOOKS 010-40.3100.640000 10.34 INGRAM LIBRARY SERVICES 93411956 06/12/2016 BOOKS 010-40.3100.640000 18.08 INGRAM LIBRARY SERVICES 93442041 06/14/2016 BOOKS 010-40.3100.590000 2.50 INGRAM LIBRARY SERVICES 93442041 06/14/2016 BOOKS 010-40.3100.640000 5.99 INGRAM LIBRARY SERVICES 93457548 06/15/2016 BOOKS 010-40.3100.590000 2.89 INGRAM LIBRARY SERVICES 93457548 06/15/2016 BOOKS 010-40.3100.640000 9.74 INGRAM LIBRARY SERVICES 93478922 06/16/2016 BOOKS 010-40.3100.590000 3.04 INGRAM LIBRARY SERVICES 93478922 06/16/2016 BOOKS 010-40.3300.640000 6.59 INGRAM LIBRARY SERVICES 93478923 06/16/2016 BOOKS 010-40,3100,590000 23.68 INGRAM LIBRARY SERVICES 93478923 06/16/2016 BOOKS 010-40.3100.640000 222.02 INGRAM LIBRARY SERVICES 93484354 06/17/2016 BOOKS 010-40.3100.590000 2.38 INGRAM LIBRARY SERVICES 93484354 06/17/2016 BOOKS 010-40.3100.640000 28.72 INGRAM LIBRARY SERVICES 93484355 06/17/2016 BOOKS 010-40.3100.590000 19.52 INGRAM LIBRARY SERVICES 93484355 06/17/2016 BOOKS 010-40.3100.640000 167.78 INGRAM LIBRARY SERVICES 93484356 06/17/2016 BOOKS 010-40.3100.590000 1.19 INGRAM LIBRARY SERVICES 93484356 06/17/2016 BOOKS 010-40.3100.640000 16.10 INGRAM LIBRARY SERVICES 93497406 06/19/2016 BOOKS 010-40.3100.590000 221.45 INGRAM LIBRARY SERVICES 93497406 06/19/2016 BOOKS 010-40.3100.640000 777.90 INGRAM LIBRARY SERVICES 93497407 06/19/2016 BOOKS 010-40.3100.590000 83.41 INGRAM LIBRARY SERVICES 93497407 06/19/2016 BOOKS 010-40.3100.640000 480.02 INGRAM LIBRARY SERVICES 93497408 06/19/2016 BOOKS 010-40.3100.590000 109.62 INGRAM LIBRARY SERVICES 93497408 06/19/2016 BOOKS 010-40.3100.640000 385.11 INGRAM LIBRARY SERVICES 93497409 06/19/2016 BOOKS 010-40.3100.590000 3.58 INGRAM LIBRARY SERVICES 93497409 06/19/2016 BOOKS 010-40.3100.640000 22.55 INGRAM LIBRARY SERVICES 93525064 06/21/2016 BOOKS 010-40.3100.590000 1.19 INGRAM LIBRARY SERVICES 93525064 06/21/2016 BOOKS 010-40.3100.640000 9.77 INGRAM LIBRARY SERVICES 93543914 06/22/2016 BOOKS 010-40.3100.590000 1.99 INGRAM LIBRARY SERVICES 93543914 06/22/2016 BOOKS 010-40.3100.640000 22.49 INGRAM LIBRARY SERVICES 93543915 06/22/2016 BOOKS 010-40.3100.590000 2.50 INGRAM LIBRARY SERVICES 93543915 06/22/2016 BOOKS 010-40.3100.640000 8.50 INGRAM LIBRARY SERVICES 93543916 06/22/2016 BOOKS 010-40.3100.590000 2.50 INGRAM LIBRARY SERVICES 93543916 06/22/2016 BOOKS 010-40.3100.640000 4.79 INGRAM LIBRARY SERVICES 93543917 06/22/2016 BOOKS 010-40.3100.590000 2.50 INGRAM LIBRARY SERVICES 93543917 06/22/2016 BOOKS 010-40.3100.640000 8.99 INGRAM LIBRARY SERVICES 93543918 06/22/2016 BOOKS 010-40.3100.590000 1.19 INGRAM LIBRARY SERVICES 93543918 06/22/2016 BOOKS 010-40.3100.640000 15.53 VERIZON WIRELESS 9767024196 06/13/2016 JUNE'16 STATEMENT 010-40.3100.450000 52.08 ACCESS SYSTEMS INV436385 06/17/2016 PRODESK 400 G3/GRAPHICC 010-40.3100.540000 1,380.89 ACCESS SYSTEMS INV436790 06/20/2016 JUNE'16SERVICE FEE 010-40.3100.270100 169.85 ACCESS SYSTEMS INV436834 06/20/2016 GRAPHIC CARD 010-40.3100.540000 39.12 Department 3100 - LIBRARY SERVICES Total: 10,514.61 Department: 3600. MOSQUITO CONTROL WILSON BROTHERS PEST CO 060316 06/08/2016 MOSQUITO CONTROL 010-30.3600.230800 600.00 Department 3600 - MOSQUITO CONTROL Total: 600.00 Department: 4100 - PARKS FAREWAY STORES, INC. 00225235 06/15/2016 PARK BOARD PARK TOUR FO 010-40.4100.590000 89.49 TYLER TECHNOLOGIES INC 025-159696 07/01/2016 FY17 SOFTWARE MAINTENA 010-40.4100.270000 785.41 MINGO PRODUCTS, INC. 1096 07/01/2016 PLANTERS 010-40.4100.410300 2,400.00 MID AMERICAN ENERGY 140570616 06/20/2016 JUNE'16 STATEMENT 010-40.4100.480000 16.29 GENUS LANDSCAPE ARCHITE 15036-5 06/16/2016 FOX CREEK PHASE 1 327-90.4100.880050 1,250.00 WASH -ECLAIR 176580 06/13/2016 WASH WINDOWS 010-40.4100.410100 38.00 G & LCLOTHING 2-735794 06/03/2016 UNIFORM-KENT 010-40.4100.120000 85.00 G & L CLOTHING 2-735795 06/03/2016 UNIFORMS-KLIMESH 010-40A100.120000 80.00 G&LCLOTHING 2-735796 06/03/2016 PANTS/PRINTING-WRIGHT 010-40.4100.120000 80.00 6/29/2016 3:53:29 PM Page 4 of 19 Expense Approval Register Packet: APPKT00239 - JULY 6TH 2O16 COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount ALLENDAN SEED COMPANY 27612 06/16/2016 SEED FOX CREEK PARK 327-90.4100.880060 1,500.00 MID AMERICAN ENERGY 311090616 06/20/2016 JUNE'16 STATEMENT 010-40.4100.480000 21.61 SUPPLYWORKS 368426326 06/O1/2016 SUPPLIES 010-40.4100,590000 266.94 SUPPLYWORKS 369119235 06/08/2016 DOG POO BAGS 010-40.4100.590000 126.40 HOLMES MURPHY 370590 07/O1/2016 HMA MONTHLY CONSULTIN 010-40.4100.100000 45.47 HOLMES MURPHY 370590 07/O1/2016 HMA MONTHLY CONSULTIN 010-40.4100.100000 18.19 HOLMES MURPHY 370590 07/O1/2016 HMA MONTHLY CONSULTIN 010-40.4100.100000 9.09 PLUMB SUPPLY COMPANY 3933980 06/20/2016 PARTS 010-40.4100.410300 11.48 MENARDS 46777 06/13/2016 PARTS 010-40.4100.480100 84.23 MENARDS 47082 06/16/2016 PARTS 010-40.4100.480100 29.26 MENARDS 47201 06/17/2016 TIE/ADAPTER 010-40,4100.480100 11.99 MID AMERICAN ENERGY 4802SO616 06/20/2016 JUNE'16 STATEMENT 010-40.4100.480000 23.80 CLASSIC FLORAL &GIFTS 508034 06/17/2016 PLANTING DOWNTOWN TRI 010-40.4100.410300 1,312.50 DELTA DENTAL 568890 07/01/2016 DELTA DENTAL 010-40.4100.100000 119.02 DELTA DENTAL 568890 07/01/2016 DELTA DENTAL 010-40.4100.100000 23.80 DELTA DENTAL 568890 07/01/2016 DELTA DENTAL 010-40.4100.100000 30.91 DEMCO INC. 5894419 06/10/2016 FRAME/NAME BADGES 010-40.4100.580000 179.81 MID AMERICAN ENERGY 690070616 06/20/2016 JUNE'16 STATEMENT 010-40.4100.480000 21.01 VERIZON WIRELESS 9767024196 06/13/2016 JUNE'16 STATEMENT 010-40.4100.450000 99.44 ACCESS SYSTEMS INV436790 06/20/2016 JUNE'16 SERVICE FEE 010-40.4100.270100 119.70 Department 4100 - PARKS Total: 8,878.84 Department: 4200 - RECREATION FAREWAY STORES, INC. 00253163 06/13/2016 SUPPER SNACKERS 010-40.4200.460500 210.02 FAREWAY STORES, INC. 00254249 06/16/2016 SALT SUPER SNACKERS 010-40.4200.460500 1.69 TYLER TECHNOLOGIES INC 025-159696 07/01/2016 FYI7 SOFTWARE MAI NTENA 010-40.4200.270000 785.41 FEDEX OFFICE 0468800020970 05/13/2016 CELEBRATE WAUKEE'16 FLY 010-40.4200.460900 142.20 IHEART MEDIA 1024328472 06/05/2016 CELEBRATE WAUKEE COMM 010-40.4200,460900 999.00 RESULTS BODYLAB 108 06/21/2016 RESULTS BOOT CAMP MAY -A 010-40.4200.460500 2,394.00 BOWEN DESIGN LLC 12973 06/15/2016 CAMPING PARKING YARD SI 010-40.4200.460650 100.00 ACCESS SYSTEMS LEASING 18926220 06/16/2016 JUNE'16 PRINTER/COPIER LE 010-40.4200.270110 111.87 MCKINLEY, INC. 190305 06/24/2016 MEDALS FOR MINI SLUGGER 010-40.4200.460510 743.60 CHRISTIAN PRINTERS INC 31476 06/11/2016 BUSINESS CARDS-EDWARDS 010-40.4200.580000 21.00 WEB GRAPHICS INC 34415 05/31/2016 DESIGN KID'S CHALLENGE 20 010-40.4200.460900 125.00 HOLMES MURPHY 370590 07/01/2016 HMA MONTHLY CONSULTIN 010-40.4200.100000 109.13 FASTSIGNS 42-87668 06/03/2016 MAGNETIC SIGN 010-40.4200.460800 40.70 FASTSIGNS 42-87823 06/23/2016 MOVIES IN THE PARK VINYL 010-40.4200.460500 110.31 FASTSIGNS 42-87826 06/15/2016 BACOON VINYL STICKER 010-40.4200.460650 55.66 MENARDS 46244 06/07/2016 1X2-12'SELECT BOARD 010-40.4200.460500 2.76 DELTA DENTAL 568890 07/01/2016 DELTA DENTAL 010-40.4200.100000 268.95 CLASSIC EVENTS & PARTIES 65720 06/03/2016 TABLE/STAGE/CHAIR RENTA 010-40.4200.460900 2,115.30 OFFICE DEPOT 841294813001 05/23/2016 SUPPLIES 010-40.4200.580000 91.00 VERIZON WIRELESS 9767024196 06/13/2016 JUNE'16 STATEMENT 010-40.4200.450000 199.27 CENTRAL IOWA OFFICIALS INV0001114 06/21/2016 2016 SUMMER COED SB MA 010-40.4200.460050 52.00 ACCESS SYSTEMS INV436790 06/20/2016 JUNE'16 SERVICE FEE 010-40.4200.270100 104.89 Department 4200 - RECREATION Total: 8,783.76 Department: 4300 - COMMUNITY CENTER RJ LAWN SERVICE INC 13550 06/22/2016 FERTILIZER/SPOT SPRAY CM 010-40.4300.410300 50.00 NATIONWIDE OFFICE CLEAN 51612 06/15/2016 JUNE'16STMT-CMMTYCNT 010-40.4300.400100 298.77 MEDIACOM INV0001072 06/07/2016 JUNE'16STATEMENT-COM 010-40.4300.480000 158.11 Department 4300 - COMMUNITY CENTER Total: 506.88 Department: 5300-STORM WATER TYLER TECHNOLOGIES INC 025-159696 07/01/2016 FYI7 SOFTWARE MAINTENA 560-80.5300.270000 785.40 CAPITAL CITY EQUIPMENT C 11600D 05/23/2016 LOADER ATTACHMENTS-BRO 560-80.5300.880000 2,775.00 URBAN TURF FARMS LLC 1789 06/06/2016 SOD 560-80.5300.880000 1,670.00 HOLMES MURPHY 370590 07/O1/2016 HMA MONTHLY CONSULTIN 560-80.5300.100000 63.66 DELTA DENTAL 568890 07/01/2016 DELTA DENTAL 560-80.5300.100000 149.93 AHLERS & COONEY PC 713940 06/23/2016 2016STORM WATER REV LO 560-80.5300.930300 8,146.62 VERIZON WIRELESS 9767024196 06/13/2016 JUNE'16 STATEMENT 560-80.5300.450000 257.53 VEENSTRA & KIMM INC INV0001096 05/23/2016 MAY'16 STATEMENT 560-80.5300.230000 3,722.00 6/29/2016 3:53:29 PM Page 5 of 19 Expense Approval Register Packet: APPKT00239 - JULY 67H 2O16 COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount VEENSTRA & KIMM INC INV0001096 05/23/2016 MAY'16 STATEMENT 560-80.5300.230000 1,387.20 GATEHOUSE MEDIA IOWA H INV0001108 05/29/2016 MAY'16 STATEMENT 560-80.5300.210000 82.21 ACCESS SYSTEMS INV436790 06/20/2016 JUNE'16 SERVICE FEE 560-80.5300.270100 151.71 STOREY-KENWORTHY COMP PINV394169 05/31/2016 PW OFFICE SUPPLIES (SW) 560-80.5300.580000 74.80 LANDS END BUSINESS OUTFI SCR480223 05/25/2016 SHIRT RETURN 560-80.5300.120000 -48.75 LOUNSBURY LANDSCAPING T536 05/31/2016 TOPSOIL 560-80.5300.880000 1,040.59 Department 5300 - STORM WATER Total: 20,257.90 Department: 5400 - SOLID WASTE COLLECTION & DISPOSAL TYLER TECHNOLOGIES INC 025-159696 07/O1/2016 FYI7 SOFTWARE MAINTENA 590-30.5400.270000 785.40 Department 5400 - SOLID WASTE COLLECTION & DISPOSAL Total: 785.40 Department: 6000. PUBLIC WORKS TYLER TECHNOLOGIES INC 025-159696 07/01/2016 FYI7 SOFTWARE MAINTENA 010-20.6000.270000 785.41 HOLMES MURPHY 370590 07/O1/2016 HMA MONTHLY CONSULTIN 010-20.6000.100000 181.88 DELTA DENTAL 568890 07/01/2016 DELTA DENTAL 010-20.6000.100000 420.09 AUDIOVISUAL INC 88426432 06/14/2016 SERVICE ON NEC PROJECTOR 010-20.6000.400000 240.00 VERIZON WIRELESS 9767024196 06/13/2016 JUNE'16 STATEMENT 010-20.6000.450000 210.13 HEARTLAND CO-OP INV0001084 05/31/2016 MAY 2016STATEMENT- PW O10-20.6000.570000 493.08 ACCESS SYSTEMS INV436790 06/20/2016 JUNE'16 SERVICE FEE 010-20.6000.270100 13.43 WD DESIGNS PO-1639-2 06/14/2016 SHIRT/EMBROIDERY 010-20.6000.120000 102.70 LANDS END BUSINESS OUTFI SIN3934096 06/14/2016 SHIRTS 010-20.6000.120000 297.00 Department 6000 - PUBLIC WORKS Total: 2,743.72 Department: 6010. PUBLIC WORKS BUILDING G&KSERVICES INC 1183551947 06/17/2016 MAT SERVICES JUNE'16 PW 010-20.6010.400000 133.87 ACCESS SYSTEMS LEASING 18926220 06/16/2016 JUNE'16 PRINTER/COPIER LE 010-20.6010.270110 610.21 STROH CORP 218139 06/15/2016 CUSTOMIZED PROFESSIONA 010-20.6010.400000 5,444.54 MID AMERICAN ENERGY 240000616 06/20/2016 JUNE'16 STATEMENT 010-20.6010.480000 1,932.11 FIRST CHOICE COFFEE SERVI 255793 06/14/2016 COFFEE/SUPPLIES 010-20.6010.590000 267.76 IMAGING TECHNOLOGIES 273822 06/20/2016 BASE RATE CHARGE-KIP-3 010-20.6010.580000 253.00 NATIONWIDE OFFICE CLEAN 51461 06/15/2016 JUNE'16 STATEMENT-PW 010-20.6010.400100 1,247.04 HILLYARD INC 602112249 06/13/2016 TOWELS 010-20.6010.590000 94.26 OVERHEAD DOOR COMPANY 66432 06/08/2016 LABOR ON PHOTO CELLS 010-20.6010.400000 97.00 OVERHEAD DOOR COMPANY 66518 06/14/2016 PHOTOCELLS 010-20.6010.400000 59.00 OFFICE DEPOT 842996722001 06/03/2016 HOOK SET 010-20.6010.580000 42.59 OFFICE DEPOT 842996993001 06/02/2016 SUPPLIES 010-20.6010.580000 60.70 OFFICE DEPOT 842996994001 06/02/2016 CUSHION 010-20.6010.580000 4.69 FASTENAL COMPANY IAGRM81022 06/08/2016 IC WB WHITE 17OZ 010-20.6010.590000 5.15 AT&T MOBILITY X06082016 05/31/2016 MAY'16 STATEMENT 010-20.6010.450000 57.98 Department 6010 - PUBLIC WORKS BUILDING Total: 10,309.90 Department: 6150- PUBLIC WORKS MECHANIC TYLER TECHNOLOGIES INC 025-159696 07/O1/2016 FYI7 SOFTWARE MAINTENA 010-20.6150.270000 785.41 NORTHERN TOOL &EQUIPM 073018024 06/15/2016 WILTON S"MULTI PURPOSE 010-20.6150.540000 179.99 CFA SOFTWARE, INC 13219 06/13/2016 FUEL SYSTEM INTEGRATION 010-20.6150.270100 3,000.00 MATHESON TRI-GAS INC 13531839 06/10/2016 CYLINDERS 010-20.6150.590000 185.41 CFI SALES INC 219255 06/09/2016 BEAD LUBRICANT/METAL VA 010-20.6150.590000 39.98 TRUCK EQUIPMENT INC 277776 06/09/2016 NERF BARS 010-20.6150.570130 165.65 TRUCK EQUIPMENT INC 277810 06/17/2016 FLOOR MATS 010-20.6150.570130 108.72 BAK SALES, INC 32565 06/20/2016 BATTERY 010-20.6150.590000 112.00 VAN -WALL EQUIPMENT INC 331703 06/15/2016 PINS/RETAINER/HYD. QUICK 010-20.6150.570130 226.99 ADELAUTO PARTS 338459 06/14/2016 OIL/FILTER 010-20.6150.570110 16.44 ADELAUTO PARTS 338459 06/14/2016 OIL/FILTER 010-20.6150.570120 17.54 ADELAUTO PARTS 338587 06/16/2016 OIL FILTER 010-20.6150.570110 8.84 ADELAUTO PARTS 338847 06/21/2016 HYD FILTER 010-20.6150.570110 6.93 HOLMES MURPHY 370590 07/O1/2016 HMA MONTHLY CONSULTIN 010-20.6150.100000 63.66 MID-IOWA SOLID WASTE EQ 41700 05/31/2016 FUSE PANEL REROFIT KIT 010-20.6150.570130 239.04 MID-IOWA SOLID WASTE EQ 41728 06/07/2016 SWEEPER PARTS 010-20.6150.570130 673.38 MID-IOWASOLID WASTE EQ 41820 06/17/2016 SWEEPER PARTS 010-20.6150.570130 412.24 DELTA DENTAL 568890 07/01/2016 DELTA DENTAL 010-20.6150.100000 149.93 CAPITAL CITY EQUIPMENT C 65039D 06/09/2016 PARTS 010-20.6150.570130 237.08 CAPITAL CITY EQUIPMENT C 65137D 06/13/2016 COUPLER 010-20.6150.570130 71.88 6/29/2016 3:53:29 PM Page 6 of 19 Expense Approval Register Packet: APPKT00239 -DULY 6TH 2O16 COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount CAPITAL CITY EQUIPMENT C 65349D 06/17/2016 KIT 010-20.6150.570130 132.00 CAPITAL CITY EQUIPMENT C 65418D 06/21/2016 FILTERS 010-20,6150.570110 103.59 PRA%AIR DISTRIBUTION #44 73351181 05/31/2016 ACETYLENE 010-20.6150.590000 64.13 STIVERS FORD 839791 06/13/2016 PARTS 010-20.6150.570130 140.32 STIVERS FORD 839793 06/13/2016 PARTS 010-20.6150.570130 6.83 STIVERS FORD 839809 06/14/2016 PARTS 010-20.6150.570130 29.83 STIVERS FORD 839814 06/14/2016 PARTS 010-20.6150,570130 21.39 LAWSON PRODUCTS INC 9304151524 06/08/2016 SUPPLIES 010-20.6150.590000 278.25 VERIZON WIRELESS 9767024196 06/13/2016 JUNE'16 STATEMENT 010-20.6150.450000 69.48 PEAK SOFTWARE SYSTEMS I CG3200 06/10/2016 SUPPLIES/PARTS 010-20.6150.590000 315.92 FASTENAL COMPANY IAGRM81045 06/08/2016 5/8-11 BOTTOM TAP 010-20.6150.590000 17.53 MIDWEST UNDERGROUND S ID23951 06/20/2016 PARTS/JOYSTICK B215 010-20.6150.570130 636.16 LOGAN CONTRACTORS SUPP L09393 06/02/2016 CLEANER/FOAM 010-20.6150.570130 70.50 LOGAN CONTRACTORS SUPP L09394 06/02/2016 CARBURETOR KIT/GASKET 010-20.6150.570130 84.74 LOGAN CONTRACTORS SUPP L10311 06/06/2016 G%160/STOP SWITCH 010-20.6150.570130 16.67 CAPITAL CITY EQUIPMENT C R65202D 06/14/2016 BELT/ALTERNATOR 010-20.6150.570130 227.23 CAPITAL CITY EQUIPMENT C R65209D 06/14/2016 GASKETITHERMOSTAT 010-20.6150.570130 40.50 CFI SALES INC S219255 06/08/2016 LUBRICANT/VALVE 010-20.6150.590000 39.98 Department 6150 - PUBLIC WORKS MECHANIC Total: 8,996.16 Department: 6510- WATER UTILITY TYLER TECHNOLOGIES INC 025-159696 07/01/2016 FYI7 SOFTWARE MAINTENA 510-30.6510.270000 785.41 MID AMERICAN ENERGY 110090616 06/20/2016 JUNE'16 STATEMENT 510-30.6510.480000 18.48 CFI SALES INC 219035 06/06/2016 SERVICE CALL & SUPPLIES 530-30.6510.410300 33.19 G & LCLOTHING 2-735832-01 06/03/2016 SHIRTS -BAKER 510-30.6510.120000 80.00 G & LCLOTHING 2-735933-01 06/03/2016 SHIRTS -VAN RAEKEL 510-30.6510.120000 80.00 G & LCLOTHING 2-735834-01 06/03/2016 SHIRTS -EDDY 510-30.6510.120000 80.00 HOLMES MURPHY 370590 07/01/2016 HMA MONTHLY CONSULTIN 510-30.6510.100000 45.47 HOLMES MURPHY 370590 07/O1/2016 HMA MONTHLY CONSULTIN 510-30.6510.100000 22.73 HOLMES MURPHY 370590 07/O1/2016 HMA MONTHLY CONSULTIN 510-30.6510.100000 23.87 HOLMES MURPHY 370590 07/O1/2016 HMA MONTHLY CONSULTIN 510-30.6510.100000 54.57 UNIVERSAL PRINTING SERVI 43052 06/23/2016 CUSTOMER CONFIDENCE INS 510-30,6510.210000 452.58 DELTA DENTAL 568890 07/01/2016 DELTA DENTAL 510-30.6510.100000 119.02 DELTA DENTAL 568890 07/01/2016 DELTA DENTAL 510-30.6510.100000 82.38 DELTA DENTAL 568890 07/01/2016 DELTA DENTAL 510-30.6510.100000 59.51 DELTA DENTAL 568890 07/01/2016 DELTA DENTAL 510-30.6510.100000 56.22 UNIVERSITY OF IOWA HYGIE 83512 05/31/2016 TESTING FEES 510-30.6510.250000 687.50 VERIZON WIRELESS 9767024196 06/13/2016 JUNE'16 STATEMENT 510-30.6510.450000 348.00 PEAK SOFTWARE SYSTEMS I CG3200 06/10/2016 SUPPLIES/PARTS 510-30.6510.590000 87.30 FASTENAL COMPANY IAGRM80911 06/02/2016 EARMUFF 510-30.6510.590000 23.91 AMERICAN WATER WORKS A INV0001089 07/O1/2016 FY17 DUES 510-30.6510,280000 360.00 VEENSTRA & KIMM INC INV0001096 05/23/2016 MAY'16 STATEMENT 510-30.6510.230000 808.14 WEST DES MOINES WATER INV0001117 06/29/2016 JULY 2016 WATERTOWER R 510-30.6510.390300 364.50 DES MOINES WATERWORKS INV0001118 06/29/2016 JULY 2016 WATER REV BON 510-30.6510.3610000 -122.53 DES MOINES WATER WORKS INV0001118 06/29/2016 JULY 2016 WATER REV BON 510-30,6510.921250 809.63 ACCESS SYSTEMS INV436790 06/20/2016 JUNE'16 SERVICE FEE 510-30.6510.270100 811.05 LARSON DATA COMMUNICA LD-IV-16178 06/21/2016 WATER TOWER ANTENNA SY 510-30.6510.881200 8,367.00 Department 6510- WATER UTILITY Total: 14,537.93 Department: 6520 - SANITARY SEWERS & TREATMENT TYLER TECHNOLOGIES INC 025-159696 07/01/2016 FYI7 SOFTWARE MAINTENA 520-30.6520.270000 785.41 ELECTRIC PUMP &TOOL INC 0869083-IN 06/08/2016 12V BATTERIES 520-30.6520.411100 76.97 MC21NC 10198 06/07/2016 SCREEN BRUSH 520-30.6520.411300 3,683.23 MCCLURE ENGINEERING CO 12686 05/31/2016 BLUESTEM LIFT STATION #15 520-30.6520.883070 4,975.00 EMERGENCY MEDICAL PROD 1829231 06/06/2016 NITRILE GLOVES 520-30.6520.411100 246.10 CFI SALES INC 219035 06/06/2016 SERVICE CALL & SUPPLIES 520-30.6520.410100 33.19 G & LCLOTHING 2-735835-01 06/03/2016 SHIRTS- DANIEL 520-30.6520.120000 80.00 G&LCLOTHING 2-735836-01 06/03/2016 SHIRTS- GANZOW 520-30.6520.120000 80.00 MID AMERICAN ENERGY 320010616 06/20/2016 JUNE'16 STATEMENT 520-30.6520.480000 76.40 HOLMES MURPHY 370590 07/O1/2016 HMA MONTHLY CONSULTIN 520-30.6520.100000 54.57 HOLMES MURPHY 370590 07/O1/2016 HMA MONTHLY CONSULTIN 520-30.6520.100000 90.94 HOLMES MURPHY 370590 07/O1/2016 HMA MONTHLY CONSULTIN 520-30.6520.100000 22.73 6/29/2016 3:53: 29 PM Page 7 of 19 Expense Approval Register Packet: APPKTOO239-JULY 6TH 2O16 COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount HOLMES MURPHY 370590 07/01/2016 HMA MONTHLY CONSULTIN 520-30.6520.100000 15.92 MID-IOWA SOLID WASTE EQ 41799 06/16/2016 REPAIR VAC -CON 520-30.6520.410100 4,528.70 ACME TOOLS 4218599 06/09/2016 18V XRP CORDLESS POWER 520-30.6520.590000 198.00 MENARDS 46265 06/07/2016 FAN/STEALTH RAT/RATCHET 520-30.6520.590000 150.84 DELTA DENTAL 568890 07/01/2016 DELTA DENTAL 520-30.6520.100000 82.38 DELTA DENTAL 568890 07/01/2016 DELTA DENTAL 520-30.6520.100000 59.51 DELTA DENTAL 568890 07/01/2016 DELTA DENTAL 520-30.6520,100000 126.06 DELTA DENTAL 568890 07/01/2016 DELTA DENTAL 520-30.6520.100000 37.48 AMERICAN ABSTRACT 709247 05/17/2016 TITLE CERT, NW AREA TRUN 520-30.6520.883091 325.00 AMERICAN ABSTRACT 709248 05/19/2016 TITLE CERT. NW AREA TRUN 520-30.6520.883091 325.00 AMERICAN ABSTRACT 709249 05/19/2016 TITLE CERT, NW AREATRUN 520-30.6520.883091 325.00 AMERICAN ABSTRACT 709250 05/19/2016 TITLE CERT. NW AREA TRUN 520-30.6520.883091 325.00 AMERICAN ABSTRACT 709251 05/23/2016 TITLE CERT. NW AREA TRUN 520-30.6520.883091 325.00 AMERICAN ABSTRACT 709252 06/02/2016 TITLE CERT. NW AREATRUN 520-30.6520.883091 325.00 AMERICAN ABSTRACT 709253 06/13/2016 TITLE CERT. NW AREATRUN 520-30.6520.883091 325.00 AMERICAN ABSTRACT 709254 06/13/2016 TITLE CERT. NW AREATRUN 520-30.6520.883091 325.00 AMERICAN ABSTRACT 709255 06/02/2016 TITLE CERT, NW AREATRUN 520-30.6520.883091 325.00 AMERICAN ABSTRACT 709256 06/02/2016 TITLE CERT. NW AREA TRU N 520-30.6520.883091 325.00 AMERICAN ABSTRACT 709257 05/25/2016 TITLE CERT. NW AREA TRUN 520-30.6520.883091 325.00 AMERICAN ABSTRACT 709258 05/25/2016 TITLE CERT. NW AREA TRUN 520-30.6520.883091 325.00 AMERICAN ABSTRACT 709259 05/25/2016 TITLE CERT. NW AREA TRUN 520-30.6520.883091 325.00 AMERICAN ABSTRACT 709260 05/25/2016 TITLE CERT. NW AREA TRUN 520-30.6520.883091 325.00 AMERICAN ABSTRACT 709261 05/23/2016 TITLE CERT. NW AREATRUN 520-30.6520.883091 325.00 AMERICAN ABSTRACT 709262 06/13/2016 TITLE CERT. NW AREATRUN 520-30.6520.883091 325.00 AMERICAN ABSTRACT 709263 06/02/2016 TITLE CERT. NW AREATRUN 520-30.6520.883091 325.00 AMERICAN ABSTRACT 709264 06/02/2016 TITLE CERT. NW AREA TRUN 520-30.6520.883091 325.00 AMERICAN ABSTRACT 709265 06/02/2016 TITLE CERT, NW AREA TRUN 520-30.6520.883091 325.00 AMERICAN ABSTRACT 709266 06/02/2016 TITLE CERT. NW AREA TRUN 520-30.6520.883091 325.00 AMERICAN ABSTRACT 709340 06/02/2016 TITLE CERT. NW AREA TRUN 520-30.6520.883091 325.00 AMERICAN ABSTRACT 709384 06/02/2016 TITLE CERT. NW AREA TRUN 520-30.6520.883091 325.00 AMERICAN ABSTRACT 709443 06/14/2016 TITLE CERT. NW AREATRUN 520-30.6520.883091 325.00 VERIZON WIRELESS 9767024196 06/13/2016 JUNE'16 STATEMENT 520-30.6520.450000 266.00 FASTENALCOMPANY IAGRM81057 06/09/2016 BALL HEX KEY 520-30.6520.590000 38.90 CENTURYLINK INV0001076 06/10/2016 MAY& JUNE'16 STATEMENT 520-30.6520,450000 95.36 VEENSTRA & KIMM INC INV0001096 05/23/2016 MAY'16 STATEMENT 520-30.6520.230000 168.00 VEENSTRA & KIMM INC INV0001096 05/23/2016 MAY'16 STATEMENT 520-30.6520.230000 2,732.50 VEENSTRA & KIMM INC INV0001096 05/23/2016 MAY'16 STATEMENT 520-30.6520.230000 588.00 VEENSTRA & KIMM INC INV0001096 05/23/2016 MAY'16 STATEMENT 520-30.6520.883000 6,498.16 VEENSTRA & KIMM INC INV0001096 05/23/2016 MAY'16 STATEMENT 520-30.6520,883000 13,733.11 VEENSTRA & KIMM INC INV0001096 05/23/2016 MAY'16 STATEMENT 520-30.6520.883060 2,395.00 GATEHOUSE MEDIA IOWA H INV0001108 05/29/2016 MAY'16 STATEMENT 520-30.6520.882900 107,85 ACCESS SYSTEMS INV436790 06/20/2016 JUNE'16 SERVICE FEE 520-30.6520.270100 666.96 Department 6520 - SANITARY SEWERS & TREATMENT Total: 50,268.27 Department: 6540 - GAS UTILITY UNITED PARCEL SERVICE OOOOAW7647256 06/18/2016 SHIPPING 540-30.6540.360000 87.30 TYLER TECHNOLOGIES INC 025-159696 07/01/2016 FY17 SOFTWARE MAINTENA 540-30.6540.270000 785.41 MID AMERICAN ENERGY 110090616 06/20/2016 JULY'16 STATEMENT 540-30.6540.480000 18.49 IOWA ASSOCIATION OF MU 13689 06/22/2016 OQ TEST GRADING/RECORD 540-30.6540.470000 255.00 CFI SALES INC 219035 06/06/2016 SERVICE CALL & SUPPLIES 540-30.6540.410100 33.18 G & LCLOTHING 2-735677-01 06/03/2016 SHIRTS -LYNCH 540-30.6540,120000 80.00 G & LCLOTHING 2-735678-01 06/03/2016 SHIRTS-CHUMBLEY 540-30.6540.120000 80.00 G & LCLOTHING 2-735907-01 06/03/2016 SHIRTS-KELLER 540-30.6540.120000 32.00 G & LCLOTHING 2-735908-01 06/03/2016 SHIRTS -DODGE 540-30.6540.120000 32.00 G & LCLOTHING 2-735910-01 06/03/2016 SHIRTS- MANNING 540-30.6540.120000 32.00 G & LCLOTHING 2-735911-01 06/03/2016 SHIRTS- DEZEEUW 540-30.6540.120000 48.00 HOLMES MURPHY 370590 07/01/2016 HMA MONTHLY CONSULTIN 540-30.6540.100000 23.87 HOLMES MURPHY 370590 07/01/2016 HMA MONTHLY CONSULTIN 540-30.6540.100000 22.74 HOLMES MURPHY 370590 07/01/2016 HMA MONTHLY CONSULTIN 540-30.6540.100000 181.88 PLUMB SUPPLY COMPANY 3927477 06/15/2016 DUALGAS KIT 540-30.6540.590000 86.25 ADVANCE ENGINEERING CO 46042 06/03/2016 PREFABRICATED INLET 540-30.6540.592000 17,561.79 6/29/2016 3:53:29 PM Page 8 of 19 Expense Approval Register Packet: APPKT00239 -JULY 6TH 2O16 COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount DELTA DENTAL 568890 07/01/2016 DELTA DENTAL 540-30,6540.100000 59.51 DELTA DENTAL 568890 07/01/2016 DELTA DENTAL 540-30.6540.100000 476.08 DELTA DENTAL 568890 07/01/2016 DELTA DENTAL 540-30.6540.100000 56.22 GRAINGER PARTS 9138670337 06/13/2016 GAS PRESSURE TEST KIT 540-30.6540.590000 86.99 INDUSTRIALSALES COMPAN 951482-000 05/31/2016 TAP TEE/WIRE/NICOTAP KIT 540-30.6540.590200 2,192.80 INDUSTRIALSALES COMPAN 952991-000 06/10/2016 ALCOHOLWIPES 540-30.6540.590000 45.61 VERIZON WIRELESS 9767024196 06/13/2016 JUNE'16 STATEMENT 540-30.6540.450000 221.99 UTILITY SAFETY AND DESIGN IN20161601 05/26/2016 MAY'16 RETAINER FEES 540-30.6540.230000 175.00 UTILITY SAFETY AND DESIGN IN20161793 05/31/2016 VALVE REMOVAL 540-30.6540.230000 376.00 PATRICIA VRIEZE INV0001080 06/10/2016 FURNACE REBATE 540-30.6540.685400 200.00 BRANDON MARTIN INV0001081 06/08/2016 FURNACE REBATE 540-30.6540.685400 30.00 FRANKSODA INV0001107 06/20/2016 FURNACE REBATE 540-30,6540.685400 150.00 WEST DES MOINES WATER INV0001117 06/29/2016 JULY 2016 WATER TOWER R 540-30.6540.390300 364.50 ACCESS SYSTEMS INV436790 06/20/2016 JUNE'16 SERVICE FEE 540-30.6540.270100 1,039.07 UTILITY SAFETY AND DESIGN 0120160034 05/31/2016 MASK/ENZYMES 540-30.6540.410400 171.04 Department 6540 - GAS UTILITY Total: 25,004.72 Department: 6550 - UTILITY BILLING TYLER TECHNOLOGIES INC 025-159696 07/01/2016 FYI7 SOFTWARE MAINTENA 570-30.6550.270000 785.40 TYLER TECHNOLOGIES INC 025-160197 07/O1/2016 UTILITY BILLING ONLINE JUL 570-30.6550.450200 175.00 ACCESS SYSTEMS LEASING 18926220 06/16/2016 JUNE'16 PRINTER/COPIER LE 570-30.6550.270110 111.87 PITNEY BOWES 3300726002 06/04/2016 QUARTERLY METER/STUFFE 570-30.6550.390000 1,711.35 HOLMES MURPHY 370590 07/O1/2016 HMA MONTHLY CONSULTIN 570-30.6550.100000 63.66 DELTA DENTAL 568890 07/01/2016 DELTA DENTAL 570-30.6550.100000 149.93 ACCESS SYSTEMS INV436790 06/20/2016 JUNE'16 SERVICE FEE 570-30.6550.270100 58.84 Department 6550 - UTILITY BILLING Total: 3,056.05 Department: 7100 - STREETS TYLER TECHNOLOGIES INC 025-159696 07/01/2016 FY17 SOFTWARE MAINTENA 060-30.7100.270000 785.41 HALLETT MATERIALS 1332210 06/11/2016 STONE 060-30.7100.590300 170.29 MARTIN MARIETTA AGGREG 17772344 05/26/2016 ROADSTONE 060-30.7100.590300 1,429.20 CFI SALES INC 219035 06/06/2016 SERVICE CALL & SUPPLIES 060-30.7100.410100 33.19 DES MOINES AREA METRO P 258 07/O1/2016 FY 2017 ASSESSMENTS 060-30.7100.280000 13,790.00 BAX SALES, INC 32005 06/10/2016 GATORADE 060-30.7100.590000 107.69 BAX SALES, INC 32531 06/15/2016 CONCRETE SUPPLIES 060-30.7100.590000 112.00 BAX SALES, INC 32564 06/20/2016 CONCRETE SUPPLIES 060-30.7100.590000 84.02 BAX SALES, INC 32566 06/20/2016 CONCRETE SUPPLIES 060-30.7100.590000 112.00 IOWA SIGNAL INC 3291 06/08/2016 TERMINATIONS SM ST/ FAN 060-30.7100.410300 291.24 HOLMES MURPHY 370590 07/01/2016 HMA MONTHLY CONSULTIN 060-30.7100.100000 4.55 HOLMES MURPHY 370590 07/01/2016 HMA MONTHLY CONSULTIN 060-30.7100.100000 127.32 HOLMES MURPHY 370590 07/01/2016 HMA MONTHLY CONSULTIN 060-30.7100.100000 22.73 CONTINENTAL RESEARCH CO 436450-CRC-1 06/14/2016 SUPPLIES 060-30.7100.590000 175.37 MENARDS 46141 06/06/2016 SUPPLIES 060-30.7100.590000 202.57 MENARDS 46565 06/10/2016 GEAR DRIVE 060-30.7100.590000 10.99 MENARDS 46730 06/13/2016 CAULK/STUD/SUPPLIES O60-30.7100.590000 225.60 DELTA DENTAL 568890 07/01/2016 DELTA DENTAL 060-30.7100.100000 59.51 DELTA DENTAL 568890 07/01/2016 DELTA DENTAL 060-30.7100.100000 11.90 DELTA DENTAL 568890 07/01/2016 DELTA DENTAL 060-30.7100.100000 299.86 AHLERS & COONEY PC 713612 06/22/2016 2016 ASPHALT OVERLAY 060-30.7100.840000 1,800.00 LIBERTY READY MIX 72057 05/24/2016 CONCRETE 060-30.7100.590400 1,237.50 LIBERTY READY MIX 72097 05/25/2016 CONCRETE 060-30,7100.590400 1,443.75 LIBERTY READY MIX 72154 05/26/2016 CONCRETE 060-30.7100.590400 1,031,25 LIBERTY READY MIX 72317 06/O1/2016 CONCRETE 060-30.7100.590400 2,235.00 LIBERTY READY MIX 72396 06/02/2016 CONCRETE 060-30.7100.590400 2,062.50 LIBERTY READY MIX 72397 06/02/2016 CONCRETE 060-30.7100.590400 756.25 LIBERTY READY MIX 72576 06/03/2016 CONCRETE 060-30.7100.590400 618.75 LIBERTY READY MIX 72763 06/07/2016 CONCRETE 060-30.7100.590400 598.63 LIBERTY READY MIX 72839 06/08/2016 CONCRETE 060-30.7100.590400 885.50 LIBERTY READY MIX 72840 06/08/2016 CONCRETE 060-30.7100.590400 2,277.00 LIBERTY READY MIX 72905 06/09/2016 CONCRETE 060-30.7100.590400 2,024.00 LIBERTY READY MIX 72906 06/09/2016 CONCRETE 060-30.7100.590400 759.00 LIBERTY READY MIX 72983 06/10/2016 CONCRETE 060-30.7100.590400 429.50 6/29/2016 3:53:29 PM Page 9 of 19 Expense Approval Register Vendor Name Payable Number LIBERTY READY MIX 73076 LIBERTY READY MIX 73077 LIBERTY READY MIX 73152 LIBERTY READY MIX 73220 LIBERTY READY MIX 73221 LIBERTY READY MIX 73312 VERIZON WIRELESS 9767024196 FASTENALCOMPANY IAGRM80975 FASTENAL COMPANY IAGRM81065 VEENSTRA & KIMM INC INV0001096 VEENSTRA & KIMM INC INV0001096 GATEHOUSE MEDIA IOWA H INV0001108 ACCESS SYSTEMS INV436790 LOGAN CONTRACTORS SUPP L08446 LOGAN CONTRACTORS SUPP L11936 Department: 7730-SE WESTOWN PKWY CONSTRUCTION TEAM SERVICES INC 1786192-0 AMERICAN ABSTRACT 709405 Department: 7740 - DOUGLAS PARKWAY SNYDER & ASSOCIATES INC 115.0204.01-13 Department: 7850 - TIF DEBT SERVICE AHLERS & COONEY PC 713740 Department: 8030 - DEVELOPER LANE ADDITIONS SNYDER & ASSOCIATES INC 115.0204.01-13 Department: 8100 - MAYOR & COUNCIL WAUKEE LEADERSHIP INSTIT WLI GRADUATION Department: 8200 - COMMUNICATIONS TYLER TECHNOLOGIES INC 025-159696 CIVIC PLUS 159469 CIVIC PLUS 159691 LIVING MAGAZINES 357179 LIVING MAGAZINES 361295 HOLMES MURPHY 370590 DELTA DENTAL 568890 OFFICE DEPOT 841787608001 FLYNN WRIGHT INV-90514 WAUKEE LEADERSHIP INSTIT WLI GRADUATION Department: 8300 - ADMINISTRATION TYLER TECHNOLOGIES INC 025-159696 IOWA LEAGUE OF CITIES 070670 ACCESS SYSTEMS LEASING 18926220 HOLMES MURPHY 370590 MID AMERICAN ENERGY 490530616 DELTA DENTAL 568890 BAKER ELECTRIC INC 81945-01 OFFICE DEPOT 844337559001 OFFICE DEPOT 844337559001 AAA AWARDS & EMBROIDER 8590 DALLAS COUNTY RECORDER 9295 VERIZON WIRELESS 9767024196 DES MOINES REGISTER INV0001049 Packet: APPKT00239 - JULY 6TH 2O16 COUNCIL PACKET Post Date Description (item) Account Number Amount 06/13/2016 CONCRETE 060-30.7100.590300 1,201.75 06/13/2016 CONCRETE 060-30.7100.590300 506.00 06/14/2016 CONCRETE 060-30.7100.590300 1,265.00 06/15/2016 CONCRETE 060-30.7100.590300 266.00 06/15/2016 CONCRETE 060-30.7100.590300 632,50 06/16/2016 CONCRETE 060-30.7100.590300 859.00 06/13/2016 JUNE'16 STATEMENT 060-30.7100.450000 233.86 06/06/2016 ZINCHEX LAG 060-30.7100.590000 1.16 06/09/2016 SUPPLIES 060-30.7100.590000 1.47 O5/23/2016 MAY'16 STATEMENT 060-30.7100.230000 234.50 05/23/2016 MAY'16 STATEMENT 060-30.7100.590400 4,107.75 05/29/2016 MAY'16 STATEMENT 060-30.7100.590420 145.42 06/20/2016 JUNE'16 SERVICE FEE 060-30.7100.270100 352.00 05/31/2016 ROD TIES 060-30.7100.590400 103.93 06/09/2016 3/4 X 18X3 - 12CD ST TECTYL 060-30.7100.590400 2,324.87 Department 7100 - STREETS Total: 48,449.27 06/09/2016 WESTOWN PRKWY IMPRVM 327-90.7730.230000 943.51 06/13/2016 TITLE CERTIFICATE WESTOW 327-90.7730.235000 125.00 Department 7730 - SE WESTOWN PKWY CONSTRUCTION Total: 1,068.51 05/31/2016 CITY CONSTRUCTION INSPEC 327-90.7740.230000 3,614.10 Department 7740 - DOUGLAS PARKWAY Total: 3,614.10 06/22/2016 KETTLESTONE DEVELOPMEN 094-30,7850.230000 3,901.00 Department 7850 - TIF DEBT SERVICE Total: 3,901.00 05/31/2016 CITY CONSTRUCTION INSPEC 327-90.8030.230000 112.50 Department 8030 - DEVELOPER LANE ADDITIONS Total: 112.50 06/21/2016 WU GRADUATION DINNER C 010-60.8100.470000 25.00 Department 8100 - MAYOR & COUNCIL Total: 25.00 07/01/2016 FY17 SOFTWARE MAINTENA 010-60.8200.270000 785.40 06/03/2016 E-PAYMENT ROLLOVER 010-60.8200.230010 148.05 06/15/2016 ADDITION OF HOMEPAGE B 010-60.8200.230010 400.00 05/31/2016 MAY'16 NEWSLETTER 010-60.8200.461200 695.00 O5/31/2016 CELEBRATE WAUKEE AD 010-60.8200.461200 524.00 07/O1/2016 HMA MONTHLY CONSULTIN 010-60.8200.100000 45.47 07/01/2016 DELTA DENTAL 010-60.8200.100000 119.02 O5/25/2016 DESK ORGANIZER 010-60,8200.580000 36.49 05/31/2016 KETTLESTONE WEBSITE MAI 010-60.8200.230010 50.00 06/21/2016 WLI GRADUATION DINNER C 010-60.8200.470000 25.00 Department 8200 - COMMUNICATIONS Total: 2,828.43 07/O1/2016 FY17 SOFTWARE MAINTENA 010-60.8300.270000 785.41 07/O1/2016 FY17 DUES 010-60.8300.280000 4,923.00 06/16/2016 JUNE'16 PRINTER/COPIER LE 010-60.8300.270110 111.87 07/01/2016 HMA MONTHLY CONSULTIN 010-60.8300.100000 90.94 06/20/2016 JUNE'16 STATEMENT 010-60,8300.390400 9.42 07/01/2016 DELTA DENTAL 010-60.8300.100000 182.05 06/10/2016 INSTALL 83 DATA CABLES 010-60.8300.740050 27,200.00 06/09/2016 SUPPLIES 010-60.8300.580000 19.11 06/09/2016 SUPPLIES 010-60.8300.590000 21.54 06/28/2016 COY GOLD BRASS PLATE 010-60.8300.461500 16.20 06/10/2016 SURVEY-HYLER/BISHOP ENG 010-60.8300.230000 12.00 O6/13/2016 JUNE'16 STATEMENT 010-60.8300.450000 52.08 06/16/2016 SUBSCRIPTION -CITY HALL 010-60.8300.280000 50.00 6/29/2016 3:53:29 PM Page 10 of 19 Expense Approval Register Packet: APPKT00239 -DULY 6TH 2O16 COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount DAVIS BROWN KOEHN SHOR INV0001087 06/20/2016 LOBBYING SERVICES MAY 20 010-60.8300.230000 2,000.00 DES MOINES REGISTER INV0001088 06/22/2016 SUBSCRIPTION CITY HALL 010-60.8300.280000 40.67 GATEHOUSE MEDIA IOWA H INV0001108 05/29/2016 MAY'16 STATEMENT 010-60.8300,210000 1,208.87 ICMA MEMBER SERVICES INV0001109 07/01/2016 FY37 ANNUAL DUES FOR TI O10-60.8300.280000 1,241.30 IOWA CITY/COUNTY MANAG INV0001110 07/01/2016 FY17 ANNUAL DUES FOR TI 010-60.8300.280000 250.00 ACCESS SYSTEMS INV422709 04/30/2016 SP SRV VIRTUAL 5.X-1 LIC PA 010-60.8300.740050 426.86 ACCESS SYSTEMS INV433540 06/08/2016 SWITCH -24 PORTS 010-60.8300.740050 1,084.06 ACCESS SYSTEMS INV436790 06/20/2016 JUNE'16 SERVICE FEE 010-60.8300.270100 2,379.61 ACCESS SYSTEMS INV438236 06/23/2016 SWITCH UPGRADE PROJECT 010-60.8300.740050 7,702.20 WAUKEE LEADERSHIP INSTIT WLI GRADUATION 06/21/2016 WLI GRADUATION DINNER C 010-60.8300.470000 25.00 Department 8300 - ADMINISTRATION Total: 49,832.19 Department: 8310. CITY HALL RANKIN COMMUNICATION S 001664 05/19/2016 PHONE SYSTEM MAINT7/16 010-60.8310.410100 2,150.00 MID AMERICAN ENERGY 030890616 06/20/2016 JUNE'16 STATEMENT 010-60.8310.390600 219.98 G & K SERVICES INC 1183551944 06/17/2016 MAT SERVICES CITY HALL 010-60.8310.400000 36.00 RI LAWN SERVICE INC 13728 06/27/2016 FERTILIZER/SPOT SPRAY CITY 010-60.8310.390600 110.04 ACCESS SYSTEMS LEASING 18926220 06/16/2016 JUNE'16 PRINTER/COPIER LE 010-60.8310.270110 328.23 CINTAS CORPORATION 5005354391 06/21/2016 FIRST AID KIT SUPPLIES -CITY 010-60.8310.590000 103.75 NATIONWIDE OFFICE CLEAN 51611 06/15/2016 CLEANING -CITY HALL 010-60.8310.400100 597.54 NATIONWIDE OFFICE CLEAN 51741 06/13/2016 SUPPLIES 010-60.8310.590000 298.30 OFFICE DEPOT 844337559001 06/09/2016 SUPPLIES 010-60.8310.590000 13.14 WAUKEE HARDWARE & VARI INVO001115 05/31/2016 MAY'16 STATEMENT -CITY H 010-60.8310.400000 17.28 ACCESS SYSTEMS INV437523 06/21/2016 NETWORK CABLE/PATCH CO 010-60.8310.590000 16.00 Department 8310 - CITY HALL Total: 3,890.26 Department: 8350 - HUMAN RESOURCES UNITED PARCEL SERVICE OOOOAW7647256 06/18/2016 SHIPPING 010-60.8350.360000 37.94 TYLER TECHNOLOG IES I NC 025-159696 07/01/2016 FYI7 SOFTWARE MAINTENA 010-60.8350.270000 785.41 ACCESS SYSTEMS LEASING 18926220 06/16/2016 JUNE'16 PRINTER/COPIER LE 010-60.8350.270110 111.87 HOLMES MURPHY 370590 07/01/2016 HMA MONTHLY CONSULTIN 010-60,8350.100000 18.19 DELTA DENTAL 568890 07/01/2016 DELTA DENTAL 010-60.8350.100000 30.91 WD DESIGNS 94973 06/28/2016 SHIRTS 010-60.8350.120000 34.45 WD DESIGNS 94973 06/28/2016 SHIRTS 010-60.8350.120000 34.45 VERIZON WIRELESS 9767024196 06/13/2016 JUNE'16 STATEMENT 010-60.8350.450000 52.08 ACCESS SYSTEMS INV436790 06/20/2016 JUNE'16 SERVICE FEE 010-60.8350.270100 12.66 Department 8350 - HUMAN RESOURCES Total: 1,117.96 Department: 8400 - FINANCIAL ADMINISTRATION TYLER TECHNOLOGIES INC 025-159696 07/O1/2016 FY37 SOFTWARE MAINTENA 010-60.8400.270000 785.41 ACCESS SYSTEMS LEASING 18926220 06/16/2016 JUNE'16 PRINTER/COPIER LE 010-60.8400.270110 643.98 PITNEY BOWES 3300726002 06/04/2016 QUARTERLY METER/STUFFE 010-60.8400.390000 454.92 HOLMES MURPHY 370590 07/O1/2016 HMA MONTHLY CONSULTIN 010-60.8400.100000 109.13 DELTA DENTAL 568890 07/01/2016 DELTA DENTAL 010-60.8400.100000 159.13 VERIZON WIRELESS 9767024196 06/13/2016 JUNE'16 STATEMENT 010-60.8400.450000 92.09 ACCESS SYSTEMS CM26946 06/24/2016 ASTQ10678-LB COMPUTER 010-60.8400.540000 -26.77 ACCESS SYSTEMS INV436790 06/20/2016 JUNE'16 SERVICE FEE 010-60.8400.270100 31.73 ACCESS SYSTEMS INV438051 06/23/2016 ASTQ10678-LB COMPUTER 010-60.8400.540000 1,987.79 Department 8400 - FINANCIAL ADMINISTRATION Total: 4,237.40 Department: 8500 - COMMUNITY DEVELOPMENT TYLER TECHNOLOGIES INC 025-159696 07/O1/2016 FYI7 SOFTWARE MAINTENA 010-50.8500.270000 785.41 ACCESS SYSTEMS LEASING 18926220 06/16/2016 JUNE'16 PRINTER/COPIER LE 010-50.8500.270110 128.61 HOLMES MURPHY 370590 07/01/2016 HMA MONTHLY CONSULTIN 010-50.8500.100000 90.94 FOTH INFRASTRUCTURE & E 47846 04/28/2016 KETTLESTONE ENVIRONMEN 010-50.8500.230000 906.30 FOTH INFRASTRUCTURE & E 48222 06/05/2016 KETTLESTONE ENVIROMENT 010-50.8500.230000 1,390.50 DELTA DENTAL 568890 07/01/2016 DELTA DENTAL 010-50.8500.100000 133.85 VERIZON WIRELESS 9767024196 06/13/2016 JUNE'16 STATEMENT 010-50.8500.450000 104.16 VEENSTRA & KIMM INC INV0001096 05/23/2016 MAY'16 STATEMENT 010-50.8500.230000 603.00 ACCESS SYSTEMS INV436790 06/20/2016 JUNE'16 SERVICE FEE 010-50.8500.270100 48.65 Department 8500 - COMMUNITY DEVELOPMENT Total: 4,191.42 6/29/2016 3:53:29 PM Page 11 of 19 Expense Approval Register Packet: APPKT00239- JULY 6TH 2016 COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount Department: 8600 - CITY ATTORNEY AHLERS & COONEY PC 711841 05/31/2016 LAND AQUISITION-SCHOOL 010-60.8600.230000 598.50 Department 8600 - CITY ATTORNEY Total: 598.50 Department: 8700 - DEVELOPMENT SERVICES TYLER TECHNOLOGIES INC 025-159696 07/O1/2016 FY17 SOFTWARE MAI NTENA 010-50.8700.270000 785.41 ACCESS SYSTEMS LEASING 18926220 06/16/2016 JUNE'16 PRINTER/COPIER LE 010-50.8700.270110 111,87 NELSEN APPRAISAL ASSOCIA 201508-20A 11/01/2015 APPRAISAL ACRES SOUTH OF 010-50.8700.230000 2,000.00 HOLMES MURPHY 370590 07/O1/2016 HMA MONTHLY CONSULTIN 010-50.8700.100000 109.13 DELTA DENTAL 568890 07/01/2016 DELTA DENTAL 010-50.8700.100000 268.95 WD DESIGNS 94973 06/28/2016 SHIRTS 010-50.8700.120000 58.45 WD DESIGNS 94973 06/28/2016 SHIRTS 010-50.8700.120000 48.46 WD DESIGNS 94973 06/28/2016 SHIRTS 010-50.8700.120000 42.45 WD DESIGNS 94973 06/28/2016 SHIRTS 010-50.8700.120000 26.45 WD DESIGNS 94973 06/28/2016 SHIRTS 010-50.8700.120000 32.45 WD DESIGNS 94973 06/28/2016 SHIRTS 010-50.8700.120000 26.45 VERIZON WIRELESS 9767024196 06/13/2016 JUNE'16 STATEMENT 010-50.8700.450000 156.24 ACCESS SYSTEMS INV436790 06/20/2016 JUNE'16 SERVICE FEE 010-50.8700.270100 85.30 WAUKEE LEADERSHIP INSTIT WLI GRADUATION 06/21/2016 WLI GRADUATION DINNER 010-50.8700.470000 25.00 Department 8700 - DEVELOPMENT SERVICES Total: 3,776.61 Department: 8750 - SUGAR CREEK MUNICIPAL IOWA SECTION PGA #614 06/06/2016 GOLF HANDICAP NETWORK 750-90.8750.280000 238.50 FAREWAY STORES, INC. 00038000 06/27/2016 ICE 750-80.8750.590000 39.92 FAREWAY STORES, INC. 00172188 06/17/2016 ICE 750-80.8750.590000 29.94 FAREWAY STORES, INC. 00172221 06/17/2016 ICE 750-80.8750.590000 39.92 FAREWAY STORES, INC. 00227306 06/23/2016 ICE 750-80.8750.590000 79.84 FAREWAY STORES, INC. 00256858 06/24/2016 KITCHEN SUPPLIES 750-80.8750.650300 16.46 TYLER TECHNOLOGIES INC 025-159696 07/O1/2016 FY17 SOFTWARE MAINTENA 750-80.8750.270000 785.40 D & K PRODUCTS INC. 0445751-IN 06/13/2016 CHEMICALS 750-80.8750.590100 3,570.00 MID AM TEXTILES INC 060216 06/02/2016 CENTER PULL NATURAL DRC 750-80.8750.590000 90.00 INTERSTATE BATTERY SYSTE 10145542 06/21/2016 BATTERY 750-80.8750.410360 82.95 G & K SERVICES INC 1183551943 06/17/2016 MAT SERVICES GOLF 750-80.8750.400000 58.02 CORELL CONTRACTOR INC 21119 06/15/2016 ASPHALT 750-80.8750.590200 460.68 WOLIN ELECTRIC, LC 21606305 06/10/2016 REPAIR CABLE IN SHOP 750-80.8750.270100 350.00 PEPSI 24776662 06/24/2016 POP 750-80.8750.650150 525.92 PEPSI 26640061 06/06/2016 POP 750-80.8750.650150 1,175.56 IOWA FIRE EQUIPMENT CO 286823 06/06/2016 ANNUAL FIRE EXTINGUISHER 750-80.8750.590000 57.85 TAYLOR MADE GOLF COMPA 31755041 06/01/2016 PRO SHOP MERCH 750-80.8750.651100 304.13 HANDICOMP 3181 06/02/2016 LEAGUES ADDED TO GOLF LE 750-80.8750.280000 120.00 MULCH MART 34489 06/13/2016 MULCH 750-80.8750.590000 101.40 MULCH MART 34650 06/17/2016 MULCH 750-80.8750.590000 101.40 HOLMES MURPHY 370590 07/01/2016 HMA MONTHLY CONSULTIN 750-80.8750.100000 31.83 SERVICE SOLUTIONS GROUP 51114328 06/07/2016 REPAIR COOLER 750-80.8750.410100 747.52 DELTA DENTAL 568890 07/01/2016 DELTA DENTAL 750-80.8750.100000 83.31 BLACK CLOVER ENTERPRISES 58645-1 06/21/2016 HAT RACK 750-80.8750.651000 18.17 OFFICE DEPOT 841294813001 05/23/2016 SUPPLIES 750-80.8750,580000 42.50 NAPA AUTO PARTS STORE 854622 06/16/2016 FILTERS 750-80.8750.570100 114.02 TITLEIST 902577000 05/19/2016 PRO SHOP MERCH 750-80.8750.651100 71.20 TITLEIST 902682552 06/09/2016 PRO SHOP MERCH 750-80.8750.651000 990.14 TITLEIST 902682553 06/09/2016 PRO SHOP MERCH 750-80.8750.651100 86.19 TITLEIST 902710107 06/15/2016 PRO SHOP MERCH 750-80.8750.651100 53.14 NIKE USA INC 988212082 06/07/2016 PRO SHOP MERCH 750-80.8750.651100 97.63 NIKE USA INC 988280938 06/08/2016 PRO SHOP MERCHANDISE 750-80.8750.651100 335.51 NIKE USA INC 988459299 06/14/2016 PRO SHOP MERCH 750-80.8750.651000 472.50 R & R PRODUCTS INC CD2024438 06/06/2016 BALL REPAIR TOOL KIT 750-80.8750.651000 250.67 CENTURYLINK INV0001075 06/10/2016 JUNE'16 STATEMENT -GOLF 750-80.8750.450000 672.00 P & W GOLF SUPPLY LLC INV10339 05/25/2016 CLUB CLEANER 750-80.8750.590000 320.69 P & W GOLF SUPPLY LLC INV10508 05/27/2016 COOLERS 750-80.8750.590000 131.84 P & W GOLF SUPPLY LLC INV11296 06/14/2016 3' DRUM SECTION, TOKENS 750-80.8750.590000 1,025.41 ACCESS SYSTEMS INV436790 06/20/2016 JUNE'16 SERVICE FEE 750-80.8750.270100 147.93 P & W GOLF SUPPLY LLC INV9080 05/04/2016 GRIPS 750-80.8750.590000 68.38 6/29/2016 3:53:29 PM Page 12 of 19 Expense Approval Register Vendor Name Payable Number DAVIS EQUIPMENT CORPOR J110608 DAVIS EQUIPMENT CORPOR J110787 SUPREME INTERNATIONAL L V1329445 DAVIS EQUIPMENT CORPOR W109587 Department: 8900 - ENGINEERING TYLER TECHNOLOGIES INC 025-159696 ACCESS SYSTEMS LEASING 18926220 HOLMES MURPHY 370590 DELTA DENTAL 568890 VERIZON WIRELESS 9767024196 VEENSTRA & KIMM INC INV0001096 VEENSTRA & KIMM INC INV0001096 ACCESS SYSTEMS INV436790 Department: 8950 - GIS Packet: APPKT00239 - JULY 6TH 2O16 COUNCIL PACKET Post Date Description (Item) Account Number Amount 06/17/2016 SUPPLIES 750-80.8750.410100 06/24/2016 TURF 750-80.8750.410100 06/15/2016 UNIFORMS 750-80.8750.120000 06/20/2016 SUPPLIES 750-80.8750.410350 Department 8750 - SUGAR CREEK MUNICIPAL Total: 07/01/2016 FY17 SOFTWARE MAINTENA 010-20.8900.270000 O6/16/2016 JUNE'16 PRINTER/COPIER LE 010-20.8900.270110 07/O1/2016 HMA MONTHLY CONSULTIN 010-20.8900.100000 07/01/2016 DELTA DENTAL 010-20.8900.100000 06/13/2016 JUNE'16 STATEMENT 010-20.8900.450000 05/23/2016 MAY'16 STATEMENT 010-20.8900.231200 05/23/2016 MAY'16STATEMENT 010-20,8900.231200 06/20/2016 JUNE'16 SERVICE FEE 010-20.8900,270100 Department 8900 - ENGINEERING Total: 723.92 87.40 510.44 428.84 15,739.07 785.41 241.35 109.13 268.95 350.91 2,682.18 223.50 99.23 4,760.66 TYLER TECHNOLOGIES INC 025-159696 07/01/2016 FY17 SOFTWARE MAINTENA 010-20.8950.270000 785.41 HOLMES MURPHY 370590 07/01/2016 HMA MONTHLY CONSULTIN 010-20.8950.100000 18.19 DELTA DENTAL 568890 07/01/2016 DELTA DENTAL 010-20.8950.100000 30.91 VERIZON WIRELESS 9767024196 06/13/2016 JUNE'16 STATEMENT 010-20.8950.450000 131.54 ACCESS SYSTEMS INV436790 06/20/2016 JUNE'16 SERVICE FEE 010-20.8950.270100 5.17 Department 8950 - GIS Total: 971.22 Grand Total: 1,076,782.37 6/29/2016 3:53:29 PM Page 13 of 19 Expense Approval Register Packet: APPKT00239 - JULY 6TH 2O16 COUNCIL PACKET Fund Summary Fund O10-GENERAL FUND 060- ROAD USE TAX FUND 094 -GATEWAY URBAN RENEWAL 110-DEBT SERVICE FUND 327 - CAPITAL PROJECTS 510- WATER UTILITY FUND 520- WASTE WATER UTILITY FUND 540 -GAS UTILITY FUND 560-STORM WATER UTILITY FUND 570- UTILITY BILL FUND 590 - SOLID WASTE COLLECT & RCY 750-GOLF COURSE FUND Account Number 010-00,0000.3230100 010-10.1100.100000 010-10.1100.120000 010-10.1100.270000 010-10.1100.270100 010-10.1100.270110 010-10.1100.400000 010-10.1100.400100 010-10.1100.410000 010-10.1100.410100 010-10,1100.410200 010-10.1100.450000 010-10.1100.460000 010-10.1100.460200 010-10.1100.470000 010-10.1100.480000 010-10.1100.540000 010-10.1100.570000 010-10.1100.580000 010-10.1100.590000 010-10.1100.690000 010-10.1100.830100 010-10.1400.100000 010-10.1400.270000 010-10.1400.270100 010-10.1400.270110 010-10.1400.360000 010-10.1400,400000 010-10.1400.410000 010-10.1400.450000 010-10.1400.460100 010-10.1400.470000 010-10.1400.480000 010-10.1400.540000 010-10.1400.580000 010-10.1400.590000 010-10.1500,100000 010-10.1500.270000 010-10.1500.270100 010-10.1500.400000 010-10.1500,450000 010-10.1500.470000 010-10.1500.480000 Grand Total: Account Summary Account Name PEDDLERS LICENSES HEALTH & LIFE INSURAN UNIFORMS DATA PROCESSING COMPUTER SUPPORT COPIER / PRINTER LEASE REPAIR/MAINTENANCE CUSTODIAL REPAIR OF VEHICLES REPAIR/MAINTENANCE REPAIR/MAINTENANCE TELEPHONE COMMUNITY SERVICES PD COMMUNITY POLICI TRAINING/TRAVEL EXPE UTILITY SERVICES MINOR EQUIPMENT FUEL OFFICE SUPPLIES OPERATING SUPPLIES & MISCELLANEOUS/CONTI LEASEHOLD IMPROVEM HEALTH & LIFE INSURAN DATA PROCESSING COMPUTERSUPPORT COPIER/ PRINTER LEASE POSTAGE & SHIPPING REPAIR/MAINTENANCE REPAIR OF VEHICLES TELEPHONE SERVICE TO CHILDREN TRAINING/TRAVEL EXPE UTILITY SERVICES MINOR EQUIPMENT OFFICE SUPPLIES OPERATING SUPPLIES & HEALTH & LIFE INSURAN DATA PROCESSING COMPUTER SUPPORT REPAIR/MAINTENANCE TELEPHONE TRAINING/TRAVEL EXPE UTILITY SERVICES Expense Amount 166,881.62 50,327.21 3,901.00 569,450.00 57,635.71 68,575.42 60,118.27 60,054.72 20,257.90 3,056.05 785.40 15,739.07 1,076,782.37 Expense Amount 100.00 2,261.24 3,914.82 785.41 459.12 1,190.79 2,304.80 554.24 266.00 135.00 1,531.18 970.93 500.00 115.58 75.00 1,126.36 2,078.00 4,723.71 32.91 679.01 268.98 4,500.00 624.22 785.41 172.74 127.98 8.28 1,550.61 60.00 172.59 420.00 75.00 746.55 1,472.50 13.41 424.44 624.24 785.41 143.03 227.90 172.58 175.00 746.55 6/29/2016 3:53:29 PM Page 14 of 19 Expense Approval Register Packet: APPKT00239-JULY 6TH 2O16 COUNCIL PACKET Account Summary Account Number Account Name Expense Amount 010-10.1500.540000 MINOR EQUIPMENT 1,340.50 010-10.1500.580000 OFFICE SUPPLIES 13.42 010-10.1500.590000 OPERATING SUPPLIES& 64.49 010-10.1500.590050 MEDICAL SUPPLIES 494.76 010-10.1900.100000 HEALTH & LIFE INSURAN 378.08 010-10.1900.120000 UNIFORMS 319.08 010-10.1900.230200 NUISANCES - MOWING 40.00 010-10.1900.270000 DATA PROCESSING 785.41 010-10.1900.270100 COMPUTER SUPPORT 66.11 010-10.1900.270110 COPIER / PRINTER LEASE 111.87 010-10.1900.450000 TELEPHONE 175.80 010-10.1900.570000 FUEL 177.07 010-20.6000.100000 HEALTH & LIFE INSURAN 601.97 010-20.6000.120000 UNIFORMS 399.70 010-20.6000.270000 DATA PROCESSING 785.41 010-20.6000.270100 COMPUTER SUPPORT 13.43 010-20.6000.400000 REPAIR/MAINTENANCE 240.00 010-20.6000.450000 TELEPHONE 210.13 010-20.6000.570000 FUEL 493.08 010-20.6010.270110 COPIER/ PRINTER LEASE 610.21 010-20.6010.400000 REPAIR/MAINTENANCE 5,734.41 010-20.6010.400100 CUSTODIAL SERVICES 1,247.04 010-20.6010.450000 TELEPHONE 57.98 010-20.6010.480000 UTILITY SERVICES 1,932.11 010-20.6010.580000 OFFICE SUPPLIES 360.98 010-20.6010.590000 OPERATING SUPPLIES& 367.17 010-20.6150.100000 HEALTH & LIFE INSURAN 213.59 010-20.6150.270000 DATA PROCESSING 785.41 010-20.6150.270100 COMPUTER SUPPORT 3,000.00 010-20.6150.450000 TELEPHONE 69.48 010-20.6150.540000 MINOR EQUIPMENT 179.99 010-20.6150.570110 COGS -FILTERS 135.80 010-20.6150.570120 COGS-LUBE 17.54 010-20.6150.570130 COGS - PARTS 3,541.15 010-20.6150.590000 OPERATING SUPPLIES & 1,053.20 010-20.8900.100000 HEALTH & LIFE INSURAN 378.08 010-20.8900.231200 DEVELOPERS ENGINEER[ 2,905.68 010-20.8900.270000 DATA PROCESSING 785.41 010-20.8900.270100 COMPUTER SUPPORT 99.23 010-20.8900.270110 COPIER/PRINTER LEASE 241.35 010-20.8900.450000 TELEPHONE 350.91 010-20.8950.100000 HEALTH & LIFE INSURAN 49.10 010-20.8950.270000 DATA PROCESSING 785.41 010-20.8950.270100 COMPUTER SUPPORT 5.17 010-20.8950.450000 TELEPHONE 131.54 010-30.3600.230800 MOSQUITO SPRAYING 600.00 010-40.3100.100000 HEALTH & LIFE INSURAN 619.10 010-40.3100.270000 DATA PROCESSING 785.41 010-40.3100.270100 COMPUTER SUPPORT 169.85 010-40.3100.270110 COPIER/ PRINTER LEASE 274.78 010-40.3100.400000 REPAIR/MAINTENANCE 240.00 010-40.3100.400100 CUSTODIAL SERVICES 530.00 010-40.3100.410100 REPAIR/MAINTENANCE 1,650,00 010-40.3100.450000 TELEPHONE 52.08 010-40.3100.470000 TRAINING/TRAVEL EXPE 43.00 010-40.3100.540000 MINOR EQUIPMENT 1,588.33 010-40.3100.580000 OFFICE SUPPLIES 1,130.52 010-40.3100.590000 OPERATING SUPPLIES & 628.32 6/29/2016 3:53:29 PM Page 15 of 19 Expense Approval Register Packet: APPKT00239 - JULY 6TH 2O16 COUNCIL PACKET Account Summary Account Number Account Name Expense Amount 010-40.3100.640000 LIBRARY BOOKS/FILMS/ 2,803.22 010-40.4100.100000 HEALTH & LIFE INSURAN 246.48 010-40.4100.120000 UNIFORMS 245.00 010-40,4100.270000 DATA PROCESSING 785.41 010-40,4100.270100 COMPUTERSUPPORT 119.70 010-40,4100.410100 REPAIR/MAINTENANCE 38.00 010-40,4100.410300 REPAIR/MAINTENANCE 3,723.98 010-40,4100.450000 TELEPHONE 99.44 010-40.4100.480000 UTILITY SERVICES 82.71 010-40.4100.480100 UTILITIES -PARK IRRIGATI 125A8 010-40.4100.580000 OFFICE SUPPLIES 179.81 010-40.4100,590000 OPERATING SUPPLIES& 482.83 010-40.4200.100000 HEALTH & LIFE INSURAN 378.08 010-40.4200.270000 DATA PROCESSING 785.41 010-40.4200.270100 COMPUTER SUPPORT 104.89 010-40.4200.270110 COPIER/PRINTER LEASE 111.87 010-40.4200.450000 TELEPHONE 199.27 010-40.4200.460050 OFFICIALS 52.00 010-40.4200.460500 SUMMER RECREATION P 2,718.78 010-40.4200.460510 YOUTH SPORTS LEAGUE 743.60 010-40.4200.460650 BIKE FEST EXPENSES 155.66 010-40.4200.460800 JULY 4TH CELEBRATION 40.70 010-40.4200.460900 FALL FESTIVAL 3,381.50 010-40.4200.580000 OFFICE SUPPLIES 112.00 010-40.4300.400100 CUSTODIAL SERVICES 298.77 010-40.4300.410300 REPAIR/MAINTENANCE 50.00 010-40.4300.480000 UTILITY SERVICES 158.11 010-50.8500.100000 HEALTH & LIFE INSURAN 224.79 010-50.8500.230000 CONSULTANT&PROFES 2,899.80 010-50.8500.270000 DATA PROCESSING 785.41 010-50.8500.270100 COMPUTER SUPPORT 48.65 010-50.8500.270110 COPIER / PRINTER LEASE 128.61 010-50.8500.450000 TELEPHONE 104.16 010-50.8700.100000 HEALTH & LIFE INSURAN 378.08 010-50.8700.120000 UNIFORMS 234.71 010-50.8700.230000 CONSULTANT & PROFES 2,000.00 010-50.8700.270000 DATA PROCESSING 785.41 010-50,8700.270100 COMPUTER SUPPORT 85.30 010-50.8700.270130 COPIER / PRINTER LEASE 111.87 010-50.8700.450000 TELEPHONE 156.24 010-50.8700.470000 TRAINING/TRAVEL EXPE 25.00 010-60.8100.470000 TRAINING/TRAVEL EXPE 25.00 010-60.8200.100000 HEALTH & LIFE INSURAN 164.49 010-60.8200.230010 WEBSITE DEVELOPMENT 598.05 010-60.8200.270000 DATA PROCESSING 785.40 010-60,8200.461200 NEWSLETTER 1,219.00 010-60,8200.470000 TRAINING/TRAVEL EXPE 25.00 010-60.8200.580000 OFFICE SUPPLIES 36.49 010-60.8300.100000 HEALTH & LIFE INSURAN 272.99 010-60.8300.210000 PUBLIC NOTIFICATION/A 1,208.87 010-60.8300.230000 CONSULTANT & PROFES 2,012.00 010-60.8300.270000 DATA PROCESSING 785.41 010-60.8300.270100 COMPUTER SUPPORT 2,379.61 010-60.8300.270110 COPIER/PRINTER LEASE 111.87 010-60.8300.280000 DUES, MEMBERSHIPS& 6,504.97 010-60.8300.390400 NORTHVIEW RENTAL PR 9.42 010-60.8300.450000 TELEPHONE 52.08 010-60.8300.461500 CITIZEN OF THE YEAR RE 16.20 6/29/2016 3:53:29 PM Page 16 of 19 Expense Approval Register Packet: APPKT00239 - JULY 6TH 2O16 COUNCIL PACKET Account Summary Account Number Account Name Expense Amount 010-60.8300.470000 TRAINING/TRAVEL EXPE 25.00 010-60.8300.580000 OFFICE SUPPLIES 19.11 010-60.8300.590000 OPERATING SUPPLIES & 21.54 010-60.8300.740050 COMPUTER/SERVER EQ 36,413.12 010-60.8310.270110 COPIER/ PRINTER LEASE 328.23 010-60.8310.390600 PROF PLAZA CAM EXPEN 330.02 010-60.8310.400000 REPAIR/MAINTENANCE 53.28 010-60.8310.400100 CUSTODIAL SERVICES 597.54 010-60.8310.410100 REPAIR/MAINTENANCE 2,150.00 010-60.8310.590000 OPERATING SUPPLIES & 431.19 010-60.8350,100000 HEALTH & LIFE INSURAN 49.10 010-60.8350.120000 UNIFORMS 68.90 010-60,8350.270000 DATA PROCESSING 785.41 010-60,8350.270100 COMPUTER SUPPORT 12.66 010-60.8350.270110 COPIER / PRINTER LEASE 111,87 010-60.8350.360000 POSTAGE & SHIPPING 37.94 010-60.8350.450000 TELEPHONE 52.08 010-60.8400.100000 HEALTH & LIFE INSURAN 268.26 010-60.8400.270000 DATA PROCESSING 785.41 010-60.8400,270100 COMPUTER SUPPORT 31.73 010-60,8400.270110 COPIER / PRINTER LEASE 643.98 010-60.8400.390000 RENTAL/LEASE OF EQUI 454.92 010-60.8400.450000 TELEPHONE 92.09 010-60.8400.540000 MINOR EQUIPMENT 1,961.01 010-60.8600.230000 CONSULTANT&PROFES 598.50 060-30.1600.480000 UTILITY SERVICES 1,701.23 060-30,1601.480000 UTILITY SERVICES 176.71 060-30.7100.100000 HEALTH & LIFE INSURAN 525.87 060-30.7100.230000 CONSULTANT & PROFES 234.50 060-30.7100.270000 DATA PROCESSING 785.41 060-30.7100.270100 COMPUTER SUPPORT 352.00 060-30.7100.280000 DUES, MEMBERSHIPS & 13,790.00 060-30.7100.410100 REPAIR/MAINTENANCE 33.19 060-30.7100.410300 REPAIR/MAINTENANCE 291.24 060-30.7100.450000 TELEPHONE 233.86 060-30.7100.590000 OPERATING SUPPLIES & 1,032.87 060-30.7100.590300 ROADSTONE 6,329.73 060-30.7100.590400 ROAD REPAIR -PATCH 22,895.18 060-30.7100.590420 ROAD REPAIRS - ASPHAL 145.42 060-30.7100.840000 STREETS IMPROVEMENT 1,800.00 094-30.7850.230000 CONSULTANT/PROFESSI 3,901.00 110-1080100 MONEY MARKET-BANKE 569,450.00 327-90.1601.235020 HICKMAN/DARTMOORT 2,057.28 327-90.2130.230000 CONSULTANT&PROFES 11,737.82 327-90.2130.230052 CONSULTING-I80/ASHW 487.50 327-90.2130,840420 ALICES ROAD - ASHWOR 75.00 327-90.2130.840470 ALICES RD-ENHANCE AS 35,733.00 327-90.4100.880050 FOX CREEK PARK -CONS 1,250.00 327-90.4100.880060 FOX CREEK PARK -CONS 1,500.00 327-90.7730.230000 CONSULTANT&PROFES 943.51 327-90.7730.235000 CONSTRUCTION CONTR 125.00 327-90.7740.230000 CONSULTANT&PROFES 3,614.10 327-90.8030.230000 CONSULTANT&PROFES 112,50 510-1080100 MONEY MARKET-BANKE 27,050.00 510-2321200 06 DMWW REVENUE BO 26,987.49 510-30.6510.100000 HEALTH & LIFE INSURAN 463.77 510-30.6510.120000 UNIFORMS 240.00 510-30.6510.210000 PUBLIC NOTIFICATION/A 452.58 6/29/2016 3:53:29 PM Page 17 of 19 Expense Approval Register Packet: APPKT00239 - JULY 6TH 2O16 COUNCIL PACKET Account Summary Account Number Account Name Expense Amount 510-30.6510.230000 CONSULTANT&PROFES 808.14 510-30.6510.250000 TESTING FEES 687.50 510-30.6510.270000 DATA PROCESSING 785.41 510-30.6510.270100 COMPUTER SUPPORT 811.05 510-30.6510.280000 DUES, MEMBERSHIPS& 360.00 510-30.6510.3610000 INTEREST ON DEPOSITS -122.53 510-30.6510.390300 TOWER RENT 364.50 510-30.6510.410100 REPAIR/MAINTENANCE 33.19 510-30.6510.450000 TELEPHONE 348.00 510-30.6510.480000 UTILITY SERVICES 18.48 510-30.6510.590000 OPERATING SUPPLIES& 111.21 510-30.6510.881200 WATER TOWER REHAB 8,367.00 510-30.6510.921250 06 DMWW REVENUE BO 809.63 520-1080100 MONEY MARKET-BANKE 9,950.00 520-30.6520.100000 HEALTH & LIFE INSURAN 489.59 520-30.6520.120000 UNIFORMS 160.00 520-30.6520.230000 CONSULTANT & PROFES 3,488.50 520-30.6520.270000 DATA PROCESSING 785.41 520-30.6520.270100 COMPUTER SUPPORT 666.96 520-30.6520.410100 REPAIR/MAINTENANCE 4,561.89 520-30.6520,411100 REPAIR/MAINTENANCE 323.07 520-30.6520.411300 TREATMENT PLANT PRO 3,683.23 520-30.6520.450000 TELEPHONE 361.36 520-30.6520.480000 UTILITY SERVICES 76.40 520-30.6520.590000 OPERATING SUPPLIES & 387.74 520-30.6520.882900 SOUTH AREA PUMP/TR 107.85 520-30.6520.883000 OUTFALL CONNECTION 20,231.27 520-30.6520.883060 LITTLE WALNUT CREEK S 2,395.00 520-30.6520.883070 BLUESTEM LIFT STATION 4,975.00 520-30.6520.883091 NW AREA TRUNK SEWE 7,475.00 540-1080100 MONEY MARKET- BANK 35,050.00 540-30.6540.100000 HEALTH & LIFE INSURAN 820.30 540-30.6540.120000 UNIFORMS 304.00 540-30.6540.230000 CONSULTANT&PROFES 551.00 540-30.6540.270000 DATA PROCESSING 785.41 540-30.6540.270100 COMPUTER SUPPORT 1,039.07 540-30.6540.360000 POSTAGE & SHIPPING 87.30 540-30.6540.390300 TOWER RENT 364.50 540-30.6540.410100 REPAIR/MAINTENANCE 33.18 540-30.6540.410400 REPAIR/MAINT OF DELIV 171.04 540-30.6540.450000 TELEPHONE 221.99 540-30.6540.470000 TRAINING/TRAVEL EXPE 255.00 540-30.6540.480000 UTILITY SERVICES 18.49 540-30.6540.590000 OPERATING SUPPLIES & 218.95 540-30.6540.590200 INSTALLATION MATERIA 2,192.80 540-30.6540,592000 METER PURCHASE 17,561.79 540-30.6540.685400 GAS REBATE 380.00 560-80.5300A00000 HEALTH & LIFE INSURAN 213.59 560-80.5300.120000 UNIFORMS -48.75 560-80.5300.210000 PUBLIC NOTIFICATION/A 82.21 560-80.5300.230000 CONSULTANT&PROFES 5,109,20 560-80.5300.270000 DATA PROCESSING 785.40 560-80.5300.270100 COMPUTER SUPPORT 151.71 560-80.5300.450000 TELEPHONE 257.53 560-80.5300.580000 OFFICE SUPPLIES 74.80 560-80.5300.880000 FACILITIES 5,485.59 560-80.5300,930300 DEBT ISSUANCE COSTS 8,146.62 570-30.6550,100000 HEALTH & LIFE INSURAN 213.59 6/29/2016 3:53:29 PM Page 18 of 19 Expense Approval Register Packet: APPKT00239 - JULY 6TH 2O16 COUNCIL PACKET Account Summary Account Number Account Name Expense Amount 570-30.6550.270000 DATA PROCESSING 785.40 570-30.6550.270100 COMPUTER SUPPORT 58.84 570-30.6550.270110 COPIER/PRINTER LEASE 111.87 570-30.6550.390000 RENTAL/LEASE OF EQUI 1,711.35 570-30.6550.450200 CREDIT CARD FEES 175.00 590-30.5400.270000 DATA PROCESSING 785.40 750-80.8750.100000 HEALTH & LIFE INSURAN 115.14 750-80.8750.120000 UNIFORMS 510.44 750-80.8750.270000 DATA PROCESSING 785.40 750-80.8750.270100 COMPUTER SUPPORT 497.93 750-80.8750.280000 DUES, MEMBERSHIPS & 358.50 750-80.8750.400000 REPAIR/MAINTENANCE 58.02 750-80.8750.410100 REPAIR/MAINTENANCE 1,558.84 750-80.8750.410350 REPAIR/MAINTENANCE 1 428.84 750-80.8750.410360 REPAIR/MAINTENANCE 82.95 750-80.8750.450000 TELEPHONE 672.00 750-80.8750.570100 OIL/FILTERS/LURE 114.02 750-80.8750.580000 OFFICE SUPPLIES 42.50 750-80.8750.590000 OPERATING SUPPLIES & 2,086.59 750-80.8750.590100 CHEMICAL/FERTILIZER 3,570.00 750-80.8750.590200 SAND AND MILLINGS 460.68 750-80.8750.650150 COGS-POP/WATER 1,701.48 750-80.8750.650300 COGS -CATERING 16.46 750-80.8750.651000 PRO SHOP MERCHANDIS 1,731.48 750-80.8750.651100 PRO SHOP SPECIAL ORD 947.80 Grand Total: 1,076,782.37 Project Account Summary Project Account Key Expense Amount "None" 1,076,782.37 Grand Total: 2,076,782.37 6/29/2016 3:53:29 PM Page 19 of 19 M Check Report City of Waukee, IA By Check Number }t Date Range: 06/16/2016 - 06/20/2016 Waukee Vendor Number Vendor Name Payment Date Payment Type Discount Amount PaymentAmount Number Bank Code: AP-WAUKEE STATE 034995 CIVIL DESIGN ADVANTAGE, LLC 06/16/2016 Regular 0.00 4,000.00 124531 Payable# Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount 18899A Invoice 05/06/2016 KETTLESTONE BIKE TRAIL 0.00 4,000.00 010-50.8700.230000 CONSULTANT & PROFESS KETTLESTONE BIKE TRAIL 4,000.00 047290 DOLL DISTRIBUTING, LLC 06/17/2016 Regular 0.00 617.05 124558 Payable# Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0001074 Invoice 06/17/2016 BEER DELIVERY 0.00 617.05 750-80.8750.650100 COGS-BEEP/ALCOHOL BEER DELIVERY 617.05 130350 ROBERT HORNER 06/17/2016 Regular 0.00 3,200.00 124559 Payable# Payable Type Payable Date Payable Description DiscountAmount Payable Amount Account Number Account Name Item Description Distribution Amount INV0001073 Invoice 06/17/2016 BACOON'16 BAND 0.00 3,200.00 010-40.4200.460650 BIKE FEST EXPENSES BACOON'16 BAND 3,200.00 130350 ROBERT HORNER 06/17/2016 Regular 0.00-3,200.00 124559 094675 IOWA BEVERAGE SYSTEMS INC 06/20/2016 Regular 0.00 917.00 124560 Payable# Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0001083 Invoice 06/20/2016 BEER DELIVERY 0.00 917.00 750-80.8750.650100 COGS-BEER/ALCOHOL BEER DELIVERY 917.00 199023 SUGAR CREEK GOLF COURSE 06/20/2016 Regular 0.00 190.00 124562 Payable# Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0001082 Invoice 06/20/2016 LEAGUE PRIZES 0.00 190.00 750-80.8750.653000 LEAGUE PRIZES/EXPENSE LEAGUE PRIZES 190.00 Bank Code AP Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 5 5 0.00 8,924.05 Manual Checks 0 0 0.00 0.00 Voided Checks 0 1 0.00 -3,200.00 Bank Drafts 0 0 0.00 0.00 EFT's 0 0 0.00 0.00 5 6 0.00 5,724.05 6/29/2016 4:13:54 PM Page 1 of 2 Check Report 19 Date Range: 06/16/2016 - 06/20/2016 Fund Summary Fund Name Period Amount 999 POOLED CASH 6/2016 5,724.05 5,724.05 6/29/2016 4:13:54 PM Page 2 of 2 00 Waukee City of Waukee, IA Vendor Number Vendor Name Bank Code: AP-WAUKEE STATE 000450 3CMA Payable# Payable Type Account Number INV0001086 Invoice 010-60,8200.470000 Payment Date Payment Type Check Report By Check Number Date Range: 06/22/2016 - 06/29/2016 DiscountAmount PaymentAmount Number 06/22/2016 Regular 0.00 595.00 124697 Payable Date Payable Description DiscountAmount Payable Amount Account Name Item Description Distribution Amount 06/01/2016 3CMA CONFERENCE REG. FEE 0.00 595.00 TRAINING/TRAVELEXPEN 3CMA CONFERENCE REG. FEE 595.00 034900 CITY OF WEST DES MOINES 06/22/2016 Regular 0.00 29,515.45 124698 Payable # Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount FN-01816-A Invoice 06/01/2016 JUNE'16 WESTCOM 0.00 29,515.45 010-10.1300.230010 WESTCOM DISPATCH SER JUNE'16 WESTCOM 29,515.45 055625 EMPLOYEE BENEFIT SYSTEMS 06/22/2016 Regular 0.00 100,967.95 124699 Payable# Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount 3209 Invoice 06/22/2016 EBS JULY'16 MONTHLY PREMIUM 0.00 100,867.95 010-10.1100.100000 HEALTH & LIFE INSURANC EBS MONTHLY PREMIUM 21,993.12 010-10.1400.100000 HEALTH & LIFE INSURANC EBS MONTHLY PREMIUM 5,514.30 010-10.1500.100000 HEALTH & LIFE INSURANC EBS MONTHLY PREMIUM 5,514.29 010-10.1900.100000 HEALTH & LIFE INSURANC EBS MONTHLY PREMIUM 3,397.49 010-20.6000,100000 HEALTH & LIFE INSURANC EBS MONTHLY PREMIUM 5,589.76 010-20.6150.100000 HEALTH & LIFE INSURANC EBS MONTHLY PREMIUM 1,977.15 010-20.8900.100000 HEALTH & LIFE INSURANC EBS MONTHLY PREMIUM 3,397.49 010-20.8950.100000 HEALTH & LIFE INSURANC EBS MONTHLY PREMIUM 556.81 010-40.3100.100000 HEALTH & LIFE INSURANC EBS MONTHLY PREMIUM 6,520.18 010-40.4100.100000 HEALTH & LIFE INSURANC EBS MONTHLY PREMIUM 1,420.34 010-40.4100.100000 HEALTH & LIFE INSURANC EBS MONTHLY PREMIUM 556.81 010-40.4100.100000 HEALTH & LIFE INSURANC EBS MONTHLY PREMIUM 284.07 010-40.4200.100000 HEALTH & LIFE INSURANC EBS MONTHLY PREMIUM 3,397.49 010-50.8500.100000 HEALTH & LIFE INSURANC EBS MONTHLY PREMIUM 2,613.78 010-50.8700.100000 HEALTH & LIFE INSURANC EBS MONTHLY PREMIUM 3,397.49 010-60.8200.100000 HEALTH & LIFE INSURANC EBS MONTHLY PREMIUM 1,420.34 010-60.8300,100000 HEALTH & LIFE INSURANC EBS MONTHLY PREMIUM 2,749.08 010-60.8350.100000 HEALTH & LIFE INSURANC EBS MONTHLY PREMIUM 556.81 010-60.8400.100000 HEALTH & LIFE INSURANC EBS MONTHLY PREMIUM 3,218.67 060-30.7100.100000 HEALTH & LIFE INSURANC EBS MONTHLY PREMIUM 710.17 060-30.7100,100000 HEALTH & LIFE INSURANC EBS MONTHLY PREMIUM 142.03 060-30.7100.100000 HEALTH & LIFE INSURANC EBS MONTHLY PREMIUM 3,954.30 510-30.6510.100000 HEALTH & LIFE INSURANC EBS MONTHLY PREMIUM 741.43 510-30.6510.100000 HEALTH & LIFE INSURANC EBS MONTHLY PREMIUM 1,585.30 510-30.6510,100000 HEALTH & LIFE INSURANC EBS MONTHLY PREMIUM 1,420.34 510-30.6510.100000 HEALTH & LIFE INSURANC EBS MONTHLY PREMIUM 710.17 520-30.6520.100000 HEALTH & LIFE INSURANC EBS MONTHLY PREMIUM 1,585.30 520-30,6520.100000 HEALTH & LIFE INSURANC EBS MONTHLY PREMIUM 2,657.48 520-30.6520,100000 HEALTH & LIFE INSURANC EBS MONTHLY PREMIUM 494.29 520-30.6520.100000 HEALTH & LIFE INSURANC EBS MONTHLY PREMIUM 710.17 540-30.6540.100000 HEALTH & LIFE INSURANC EBS MONTHLY PREMIUM 5,681.36 540-30.6540.100000 HEALTH & LIFE INSURANC EBS MONTHLY PREMIUM 741.43 540-30.6540.100000 HEALTH & LIFE INSURANC EBS MONTHLY PREMIUM 710.17 560-80.5300.100000 HEALTH & LIFE INSURANC EBS MONTHLY PREMIUM 1,977.15 570-30.6550.100000 HEALTH & LIFE INSURANC EBS MONTHLY PREMIUM 1,977.15 750-80.8750,100000 HEALTH & LIFE INSURANC EBS MONTHLY PREMIUM 994.24 047290 DOLL DISTRIBUTING, LLC 06/24/2016 Regular 0.00 551.35 124704 6/29/2016 4:16:58 PM Page 1 of 5 Check Report Vendor Number Payable # INV0001099 103950 Payable # INV0001101 199023 Payable # INV0001102 203200 Payable» INV0001100 Vendor Name Payment Date Payment Type Payable Type Payable Date Payable Description Account Number Account Name Item Description Invoice 06/24/2016 BEER DELIVERY 750-80.8750.650100 COGS-BEER/ALCOHOL BEER DELIVERY JIMMYIOHN'S 06/24/2016 Regular Payable Type Payable Date Payable Description Account Number Account Name Item Description Invoice 06/24/2016 MIX TEAM CATERING 750-80.8750.650250 COGS-FOOD/GRILL MIX TEAM CATERING SUGAR CREEK GOLF COURSE 06/24/2016 Regular Payable Type Payable Date Payable Description Account Number Account Name Item Description Invoice 06/24/2016 MIX TEAM PRIZES 750-80.8750.653000 LEAGUE PRIZES/EXPENSE MIX TEAM PRIZES THE KEE 06/24/2016 Regular Payable Type Payable Date Payable Description Account Number Account Name Item Description Invoice 06/24/2016 MIX TEAM CATERING 750-80.8750.650250 COGS-FOOD/GRILL MIX TEAM CATERING Date Range: 06/22/2016 - 06/29/2016 DiscountAmount PaymentAmount Number DiscountAmount Payable Amount Distribution Amount 0.00 551.35 551.35 0.00 110.00 124705 DiscountAmount Payable Amount Distribution Amount 0.00 110.00 110.00 0.00 240.00 124706 DiscountAmount Payable Amount Distribution Amount 0.00 240,00 240.00 0.00 625.00 124707 DiscountAmount Payable Amount Distribution Amount 0.00 625.00 625.00 035125 CLASSIC FLORAL & GIFTS 06/24/2016 Regular 0.00 670.05 124708 Payable# Payable Type Payable Date Payable Description DiscountAmount Payable Amount Account Number Account Name Item Description Distribution Amount 508017 Invoice 05/25/2016 GOLF COURSE PLANTING 0.00 345.00 750-90.8750,410300 REPAIR/MAINTENANCE F GOLF COURSE PLANTING 345.00 508018 Invoice 05/27/2016 BIKE TRAIL PLANTING 0.00 325.05 010-40.4100.410300 REPAIR/MAINTENANCE0 BIKE TRAIL PLANTING 325.05 130350 Payable N INV0001073 094675 Payable k INV0001104 199023 Payable a INV0001103 139895 ROBERT HORNER 06/27/2016 Regular Payable Type Payable Date Payable Description Account Number Account Name Item Description Invoice 06/17/2016 BACOON'16 BAND 010-40.4200.460650 BIKE FEST EXPENSES BACOON'16 BAND IOWA BEVERAGE SYSTEMS INC 06/27/2016 Regular Payable Type Payable Date Payable Description Account Number Account Name Item Description Invoice 06/27/2016 BEER DELIVERY 750-80.8750.650100 COGS-BEER/ALCOHOL BEER DELIVERY SUGAR CREEK GOLF COURSE 06/27/2016 Regular Payable Type Payable Date Payable Description Account Number Account Name Item Description Invoice 06/27/2016 LEAGUE PRIZES 750-80.8750.653000 LEAGUE PRIZES/EXPENSE LEAGUE PRIZES MUTUAL OF OMAHA 06/28/2016 Regular 0.00 3,200.00 124709 DiscountAmount Payable Amount Distribution Amount 0.00 3,200.00 3,200.00 0.00 15.20 124710 DiscountAmount Payable Amount Distribution Amount 0.00 15.20 15.20 0.00 309.00 124711 DiscountAmount Payable Amount Distribution Amount 0.00 309.00 309.00 0.00 956.06 124712 6/29/2016 4: 16:58 PIA Page 2 of 5 Check Report Date Range: 06/22/2016 - 06/29/2016 Vendor Number Vendor Name Payment Date Payment Type DiscountAmount PaymentAmount Number Payable# Payable Type Payable Date Payable Description DiscountAmount Payable Amount Account Number Account Name Item Description Distribution Amount 7438783 Invoice 06/28/2016 JULY'16 LIFE & DISABILITY PREMIUM 0.00 956.06 010-10.1100.100000 HEALTH & LIFE INSURANC LIFE & DISABILITY PREMIUM 52.00 010-10.1100.100100 LONG TERM DISABILITY LIFE & DISABILITY PREMIUM 172.96 010-10.1400.100000 HEALTH & LIFE INSURANC LIFE & DISABILITY PREMIUM 9.10 010-10.1400.100100 LONG TERM DISABILITY LIFE & DISABILITY PREMIUM 32.60 010-10.1500.100000 HEALTH & LIFE INSURANC LIFE & DISABILITY PREMIUM 9.10 010-10.1500.100100 LONGTERM DISABILITY LIFE & DISABILITY PREMIUM 32.59 010-10.1900.100000 HEALTH & LIFE INSURANC LIFE & DISABILITY PREMIUM 7.80 010-10.1900.100100 LONGTERM DISABILITY LIFE & DISABILITY PREMIUM 22.85 010-20.6000.100000 HEALTH & LIFE INSURANC LIFE & DISABILITY PREMIUM 10.40 010-20,6000.100100 LONGTERM DISABILITY LIFE & DISABILITY PREMIUM 46.24 010-20.6150.100000 HEALTH & LIFE INSURANC LIFE & DISABILITY PREMIUM 5.20 010-20.6150A00100 LONGTERM DISABILITY LIFE & DISABILITY PREMIUM 15.76 010-20.8900.100000 HEALTH & LIFE INSURANC LIFE & DISABILITY PREMIUM 7.80 010-20.8900.100100 LONGTERM DISABILITY LIFE & DISABILITY PREMIUM 26.52 010-20.8950.100000 HEALTH & LIFE INSURANC LIFE & DISABILITY PREMIUM 2.60 010-20.8950.100100 LONGTERM DISABILITY LIFE & DISABILITY PREMIUM 9.01 010-40,3100.100000 HEALTH & LIFE INSURANC LIFE & DISABILITY PREMIUM 10.40 010-40.3100.100100 LONGTERM DISABILITY LIFE& DISABILITY PREMIUM 28.83 010-40.4100.100000 HEALTH & LIFE INSURANC LIFE & DISABILITY PREMIUM 2.60 010-40.4100.100000 HEALTH & LIFE INSURANC LIFE & DISABILITY PREMIUM 0.52 010-40.4100.100000 HEALTH & LIFE INSURANC LIFE & DISABILITY PREMIUM 2.60 010-40.4100.100100 LONGTERM DISABILITY LIFE& DISABILITY PREMIUM 1.66 010-40.4100.100100 LONGTERM DISABILITY LIFE & DISABILITY PREMIUM 6.70 010-40.4100.100100 LONG TERM DISABILITY LIFE & DISABILITY PREMIUM 9.98 010-40.4200,100000 HEALTH & LIFE INSURANC LIFE & DISABILITY PREMIUM 7.80 010-40.4200,100100 LONG TERM DISABILITY LIFE & DISABILITY PREMIUM 27.87 010-50.8500.100000 HEALTH & LIFE INSURANC LIFE & DISABILITY PREMIUM 5.20 010-50.8500.100100 LONG TERM DISABILITY LIFE & DISABILITY PREMIUM 21.11 010-50.8700.100000 HEALTH & LIFE INSURANC LIFE & DISABILITY PREMIUM 7.80 010-50.8700.100100 LONGTERM DISABILITY LIFE & DISABILITY PREMIUM 30.80 010-60.8200.100000 HEALTH & LIFE INSURANC LIFE & DISABILITY PREMIUM 2.60 010-60,8200.100100 LONG TERM DISABILITY LIFE & DISABILITY PREMIUM 10.51 010-60.8300.100000 HEALTH & LIFE INSURANC LIFE & DISABILITY PREMIUM 5.20 010-60.8300.100100 LONG TERM DISABILITY LIFE & DISABILITY PREMIUM 27.79 010-60.8350.100000 HEALTH & LIFE INSURANC LIFE & DISABILITY PREMIUM 2.60 010-60,8350.100100 LONG TERM DISABILITY LIFE & DISABILITY PREMIUM 12.57 010-60.8400.100000 HEALTH & LIFE INSURANC LIFE & DISABILITY PREMIUM 5.20 010-60.84.00.100100 LONG TERM DISABILITY LIFE & DISABILITY PREMIUM 21.31 060-30,7100.100000 HEALTH & LIFE INSURANC LIFE & DISABILITY PREMIUM 10.40 060-30.7100,100000 HEALTH & LIFE INSURANC LIFE & DISABILITY PREMIUM 0.26 060-30.7100.100000 HEALTH & LIFE INSURANC LIFE & DISABILITY PREMIUM 1.30 060-30.7100.100100 LONG TERM DISABILITY LIFE & DISABILITY PREMIUM 0.83 060-30.7100. 100100 LONG TERM DISABILITY LIFE & DISABILITY PREMIUM 3.68 060-30.7100.100100 LONG TERM DISABILITY LIFE & DISABILITY PREMIUM 31.35 510-30.6510.100000 HEALTH & LIFE INSURANC LIFE & DISABILITY PREMIUM 1.95 510-30.6510.100000 HEALTH & LIFE INSURANC LIFE & DISABILITY PREMIUM 1.30 510-30.6510.100000 HEALTH &LIFE INSURANC LIFE& DISABILITY PREMIUM 3.90 510-30.6510.100000 HEALTH & LIFE INSURANC LIFE & DISABILITY PREMIUM 2.60 510-30.6510.100100 LONGTERM DISABILITY LIFE & DISABILITY PREMIUM 8.52 510-30.6510.100100 LONG TERM DISABILITY LIFE & DISABILITY PREMIUM 5.31 510-30.6510.100100 LONG TERM DISABILITY LIFE & DISABILITY PREMIUM 3.68 510-30.6510.100100 LONG TERM DISABILITY LIFE & DISABILITY PREMIUM 11.74 520-30.6520.100000 HEALTH & LIFE INSURANC LIFE & DISABILITY PREMIUM 3.90 520-30.6520.100000 HEALTH & LIFE INSURANC LIFE & DISABILITY PREMIUM 1.30 520-30.6520.100000 HEALTH & LIFE INSURANC LIFE & DISABILITY PREMIUM 1.30 520-30.6520.100000 HEALTH & LIFE INSURANC LIFE & DISABILITY PREMIUM 5.20 520-30.6520.100100 LONGTERM DISABILITY LIFE & DISABILITY PREMIUM 3.69 520-30.6520.100100 LONG TERM DISABILITY LIFE & DISABILITY PREMIUM 3.55 6/29/2016 4:16:58 PM Page 3 of 5 Check Report Vendor Number Vendor Name Payment Date 520-30.6520.100100 LONG TERM DISABILITY 520-30.6520.100100 LONG TERM DISABILITY 540-30.6540.100000 HEALTH & LIFE INSURANC 540-30.6540.100000 HEALTH & LIFE INSURANC 540-30.6540.100000 HEALTH & LIFE INSURANC 540.-30.6540.100100 LONG TERM DISABILITY 540-30.6540.100100 LONG TERM DISABILITY 540-30.6540.100100 LONG TERM DISABILITY 560-80.5300.100000 HEALTH & LIFE INSURANC 560-80.5300.100100 LONG TERM DISABILITY 570-30.6550.100000 HEALTH & LIFE INSURANC 570-30.6550.100100 LONG TERM DISABILITY 750-80.8750.100000 HEALTH & LIFE INSURANC 750-80.8750.100100 LONGTERM DISABILITY Date Range: 06/22/2016 - 06/29/2016 Payment Type Discount Amount PaymentAmount Number LIFE & DISABILITY PREMIUM 11.73 LIFE & DISABILITY PREMIUM 17.58 LIFE & DISABILITY PREMIUM 10.40 LIFE & DISABILITY PREMIUM 1.94 LIFE & DISABILITY PREMIUM 1.29 LIFE & DISABILITY PREMIUM 35.21 LIFE & DISABILITY PREMIUM 5.30 LIFE & DISABILITY PREMIUM 3.68 LIFE & DISABILITY PREMIUM 5.20 LIFE & DISABILITY PREMIUM 17.45 LIFE & DISABILITY PREMIUM 5.20 LIFE & DISABILITY PREMIUM 13.52 LIFE & DI5ABILITY PREMIUM 1.82 LIFE & DISABILITY PREMIUM 5.80 Bank Code AP Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 13 12 0.00 137,655.06 Manual Checks 0 0 0.00 0.00 Voided Checks 0 0 0.00 0.00 Bank Drafts 0 0 0.00 0.00 EFT's 0 0 0.00 0.00 13 12 0.00 137,655.06 6/29/2016 4:16:58 PIA Page 4 of 5 Check Report Date Range: 06/22/2016 - 06/29/2016 Fund Summary Fund Name Period Amount 999 POOLED CASH 6/2016 137,655.06 137,655.06 6/29/2016 4:16:58 PM Page 5 of 5 G a WbLhfee City of Waukee, IA Vendor Number Vendor Name Bank Code: AP-WAUKEE STATE 034875 CITY OF WAUKEE Payable# Payable Type Account Number INV0001055 Invoice 010-2030000 060-2030000 510-2030000 520-2030000 540-2030000 INV0001059 Invoice 010-2030000 060-2030000 510-2030000 520-2030000 540-2030000 570-2030000 INV0001060 Invoice 010-2030000 060-2030000 510-2030000 520-2030000 540-2030000 560-2030000 570-2030000 INV0001063 Invoice 010-2030000 060-2030000 510-2030000 520-2030000 540-2030000 560-2030000 570-2030000 750-2030000 INV0001064 Invoice 010-2030000 060-2030000 510-2030000 520-2030000 540-2030000 560-2030000 570-2030000 036350 Payable # INV0001050 036740 Council Payroll Reimbursements By Check Number Date Range: 06/15/2016-06/28/2016 Payment Date Payment Type Discount Amount PaymentAmount Number 06/15/2016 Regular 0.00 3,380.56 124550 Payable Date Payable Description Discount Amount Payable Amount Account Name Item Description Distribution Amount 06/15/2016 CELL PHONE REIMBURSEMENT 0.00 247.50 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 147.50 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 9.37 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 31.23 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 32.20 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 27.20 O6/15/2016 LIFE INSURANCE PREMIUM PAYROLL PAYABLES LIFE INSURANCE PREMIUM PAYROLL PAYABLES LIFE INSURANCE PREMIUM PAYROLL PAYABLES LIFE INSURANCE PREMIUM PAYROLL PAYABLES LIFE INSURANCE PREMIUM PAYROLL PAYABLES LIFE INSURANCE PREMIUM PAYROLL PAYABLES LIFE INSURANCE PREMIUM 06/15/2016 STD INSURANCE PREMIUM PAYROLL PAYABLES STD INSURANCE PREMIUM PAYROLL PAYABLES STD INSURANCE PREMIUM PAYROLL PAYABLES STD INSURANCE PREMIUM PAYROLL PAYABLES STD INSURANCE PREMIUM PAYROLL PAYABLES STD INSURANCE PREMIUM PAYROLL PAYABLES STD INSURANCE PREMIUM PAYROLL PAYABLES STD INSURANCE PREMIUM 06/15/2016 HEALTH INSURANCE DEDUCTION PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 06/15/2016 HEALTH INSURANCE DEDUCTION PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO IOWA DEPT OF HUMAN SERVICES 06/15/2016 Regular Payable Type Payable Date Payable Description Account Number Account Name Item Description Invoice 06/15/2016 CHILD SUPPORT 010-2011300 CHILD SUPPORT PAYABLE CHILD SUPPORT 510-2011300 CHILD SUPPORT PAYABLE CHILD SUPPORT 520-2011300 CHILD SUPPORT PAYABLE CHILD SUPPORT COMMUNICATIONS WORKERS OF AMERICA 06/15/2016 Regular 0.00 r rs 0.00 r rs 442.70 313.85 7.80 22.85 22.17 41.28 34.75 710.36 458.02 27.00 71.98 95.45 13.93 21.87 22.11 1,860.00 1,356.00 100.50 84.70 99.05 138.75 30.00 30.00 21.00 120.00 90.00 10.00 4.39 3.74 1.87 5.00 5.00 0.00 1,890.70 124551 Discount Amount Payable Amount Distribution Amount 0.00 1,890.70 1,616.70 136.10 137.90 0.00 942.40 124552 6/29/2016 8:03:19 AM Page 1 of 4 Cx Council Payroll Reimbursements Date Range: 06/1512016 - 06/28/2016 Vendor Number Vendor Name Payment Date Payment Type DiscountAmount PaymentAmount Number Payable # Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0001053 Invoice 06/15/2016 CWA LOCAL 7102 UNION DUES 0.00 942.40 010-2014100 CREDIT UNION DEDUCTI CWA LOCAL 7102 UNION DUES 478.88 060-2014100 CREDIT UNION DEDUCTI CWA LOCAL 7102 UNION DUES 103.61 510-2014100 CREDIT UNION DEDUCTI CWA LOCAL 7102 UNION DUES 71.46 520-2014100 CREDIT UNION DEDUCTI CWA LOCAL 7102 UNION DUES 84.45 540-2014100 CREDIT UNION DEDUCTI CWA LOCAL 7102 UNION DUES 126.71 560-2014100 CREDIT UNION DEDUCTI CWA LOCAL 7102 UNION DUES 32.62 570-2014100 CREDIT UNION DEDUCTI CWA LOCAL 7102 U NION DUES 44.67 099999 EFTPS 06/15/2016 Regular 0.00 75,357.02 124553 Payable # Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0001069 Invoice 06/15/2016 FICA TAX WITHHOLDING 0.00 35,575.32 . 010-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 25,955.06 060-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 2,370.28 510-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 1,380.14 520-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 1,519.18 540-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 1,908.16 560-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 608.02 570-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 466.06 750-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 1,368.42 INV0001070 Invoice 06/15/2016 FEDERAL WITHHOLDING TAXES 0.00 31,407.98 010-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 23,345.71 060-2010200 FEDERAL TAX WITHHOLD[ FEDERAL WITHHOLDING TAXES 1,930.78 510-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 1,252.71 520-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 1,574.85 540-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 1,540.41 560-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 730.71 570-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 489.06 750-2010200 FEDERAL TAX WITH HOLDI FEDERAL WITHHOLDING TAXES 543.75 INV0001071 Invoice 06/15/2016 MEDICARE TAX WITHHOLDING 0.00 8,373.72 010-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 6,123.82 060-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 554.36 510-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 322.80 520-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 355.30 540-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 446.22 560-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 142.20 570-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 108.98 750-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 320.04 133560 MEALS FROM THE HEARTLAND O6/15/2016 Regular 0.00 100.08 124554 Payable # Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0001056 Invoice 06/15/2016 MEALS FROM HEARTLAND DEDUCTION 0.00 100.08 010-2030000 PAYROLL PAYABLES MEALS FROM HEARTLAND DED 82.29 510-2030000 PAYROLL PAYABLES MEALS FROM HEARTLAND DED 1.04 520-2030000 PAYROLL PAYABLES MEALS FROM HEARTLAND DED 2.50 540-2030000 PAYROLL PAYABLES MEALS FROM HEARTLAND DED 10.00 560-2030000 PAYROLL PAYABLES MEALS FROM HEARTLAND DED 4.25 206800 TOTAL ADMINISTRATIVE SERVICES CORP 06/15/2016 Regular 0.00 3,760.83 124555 6/29/2016 8:03:19 AM Page 2 of 4 Council Payroll Reimbursements Date Range: 06/15/2016 - 06/28/2016 Vendor Number Vendor Name Payment Date Payment Type DiscountAmount PaymentAmount Number Payable # Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0001061 Invoice 06/15/2016 SECTION 125 MEDICAL DEDUCTIONS 0.00 2,032.74 010-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 1,378.58 060-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 8.33 510-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 100.00 520-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 104.17 540-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 208.33 560-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 37.50 570-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 137.50 750-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 58.33 INV0001062 Invoice 06/15/2016 SECTION 125 DAYCARE DEDUCTIONS 0.00 1,728.09 010-2030000 PAYROLL PAYABLES SECTION 125 DAYCARE DEDUCT 1,519.76 560-2030000 PAYROLL PAYABLES SECTION 125 DAYCARE DEDUCT 208.33 213250 UNITED WAY CENTRAL IOWA 06/15/2016 Regular 0.00 205.88 124556 Payable # Payable Type Payable Date Payable Description DiscountAmount Payable Amount Account Number Account Name Item Description Distribution Amount INV0001054 Invoice 06/15/2016 UNITED WAY DEDUCTION 0.00 205.88 010-2030000 PAYROLL PAYABLES UNITED WAY DEDUCTION 179.29 510-2030000 PAYROLL PAYABLES UNITED WAY DEDUCTION 10.39 520-2030000 PAYROLL PAYABLES UNITED WAY DEDUCTION 8.99 560-2030000 PAYROLL PAYABLES UNITED WAY DEDUCTION 7.21 233050 WAUKEE PUBLIC LIBRARY FRIENDS FOUNDATIC 06/15/2016 Regular 0.00 29.61 124557 Payable # Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0001057 Invoice 06/15/2016 LIBRARY FRIENDS FOUNDATION PAYROLL 0.00 29.61 010-2030000 PAYROLL PAYABLES LIBRARY FRIENDS FOUNDATION 25.03 510-2030000 PAYROLL PAYABLES LIBRARY FRIENDS FOUNDATION 1.04 520-2030000 PAYROLL PAYABLES LIBRARY FRIENDS FOUNDATION 2.50 560-2030000 PAYROLL PAYABLES LIBRARY FRIENDS FOUNDATION 1.04 099999 EFTPS 06/20/2016 Regular 0.00 166.40 124561 Payable# Payable Type Payable Date Payable Description DiscountAmount Payable Amount Account Number Account Name Item Description Distribution Amount INV0001078 Invoice 06/20/2016 2016 PCORI FEE 0.00 166.40 010-60.8300.100000 HEALTH & LIFE INSURANC 2016 PCORI FEE 166.40 Bank Code AP Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 16 9 0.00 85,833.48 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 16 9 0.00 85,833.48 6/29/2016 8:03:19 AM Page 3 of 4 Council Payroll Reimbursements IVA Date Range: 06/15/2016 - 06/28/2016 Fund 999 Fund Summary Name Period Amount POOLED CASH 6/2016 85,833.48 85,833.48 6/29/2016 8:03:19 AM Page 4 of 4 Council Payroll Publication Report City of Waukee, IA By Employee Name 4% Payroll Set: OS - City of Waukee ulbJee For Date Range 06/01/2016-06/15/2016 Employee Name Salary ADKINS, COREY $1,216.75 ALDRICH, SHAW N $1,515.65 APPLE, WILLIAM $786.51 ARIAS, HECTOR $2,015.09 ARMSTRONG, BRETT $1,545.99 BAKER, RANDY $1,818.30 BAKER, RUSSELL $768.03 BARTLING, DARREL $170.29 BAUMAN, LISA $1,070.87 BAUMAN, MAXWELL $761.89 BAZAN, MADELINE $89.52 BEHRENS, SARAH $309.19 BEITELSPACHER, DANIEL $1,015.95 BERG, BROOKE $571.75 WORK, ASHLEY $851.48 BOHARDT, HAZEL $180.09 BRUNS, RACHEL $1,639.29 BURKHART, LINDA $2,596.25 BUSH, COURTNEY $984.64 CAMPBELL, JUDY $549.02 CAMPBELL, SCOTT $2,545.42 CASEY, MARK $293.94 CHUMBLEY, JESSE $807.36 CICHOSKI, KELLI $1,481.09 CLAYTON, KRISTIN $593.17 COFFIN, MATHEW $755.99 COLE, JACOB $231.60 CORKREAN, JENNIFER $1,584.98 COUCHMAN, KENNETH $83.03 CRAVEN, GAYLA $92.04 CUNNINGHAM, DEANA $496.17 CUNNINGHAM, SCOTT $1,981.84 DANIEL, COLE $837.03 DAVIS, BRIAN $587.54 DEBOER, MELISSA $1,528.11 DEETS, BRADLY $2 737 84 DEZEEUW, DAVID $1,969.92 DODGE, JUSTIN $1,667.76 DUNBAR, DEANA $945.69 DUTCHER,DAN $3,202.06 EASTMAN, DAVID $723.46 EASTRIDGE, GARY $252.66 EDDIE, CHASE $768.03 EDWARDS, DANAE $1,419.91 ELDRIDGE, MALLORY $655.64 ELLIOTT, STEVE $1,642.31 EVANS, SUMMER $1,897.06 FLUGGE-SMITH, JAMIE $1,899.55 FORRET, DENNIS $557.90 FREDERICK, JUSTIN $1,913.84 FROEHLICH, WILLIAM $711.35 GIBSON, JOHN $3,199.41 GITZEN, ROBERT $1,298.45 GODWIN, BRYCE $41.56 GODWIN, EDWARD $42522 GRACE, ANDREW $797.90 GRANZOW, ERIC $265.96 0 Employee Name Salary GROVE, BRIAN $153.33 GUESS, CHRISTOPHER $620.60 HANSON, ANTHONY $2,965.24 HANSON, LAURA $1,328.40 HARRISON, BRIAN $392.49 HEIMANN, RONALD $2,072.37 HENTGES, ERIC $507.86 HERR, JENNA $1,340.92 HERRICK, ROBERT $1,595.87 HILGENBERG, ADAM $1,737.69 HOLDEN, PATRICIA $2,544.12 HOPTON, SIMONE $177.25 HUGHES, RACHELLE $391.27 HULSING, TAYLOR $117.71 HUSTED, TROY $1,550.97 HUTTON, JOSHUA $127.03 IRW IN, BRENT $72.53 JENSEN, CHAD $418.69 JERMIER, MATTHEW $2,452.36 KASS, ANDREW $1,833.00 KASZINSKI, BRETT $792.07 KELLER, CHRISTOPHER $1,549.12 KENT, ANDREW $742.60 KERR, JACOB $1,361.08 KIES, SUSAN $1,576.70 KLIMESH, LANDON $742.60 KOESTER, EVAN $1,731.12 LARSON, KRISTINE $2,346.30 LAUGHRIDGE, DANIEL $1,570.71 LAWS, MICHAEL $1,107.11 LEMKE, NEIL $1,099.16 LILLIE, SCOTT $1,383.26 LONG, JEREMY $2,165.45 LOVE, WILLIAM $41.56 LYNCH, JEREMY $950.40 LYNCH, SHANNON $1,442.34 LYON, LARRY $393.55 MANNING, JOSHUA $1,732.74 MAPES, TROY $2,475.72 MCCLINTIC, JAMES $1,122.05 MCKERN, DOUGLAS $708.64 MEANS, KEATON $334.13 MELLENCAMP, JEFFREY $2,629.45 MESCHER, MATTHEW $269.33 MICKELSON, EMILY $719.29 MILLER, LINDSAY $172.12 MINIKUS, JOSHUA $1,566.79 MOERMAN, TIMOTHY $3,621.10 MURRA, BRIAN $1,884.70 NICELY -GREEN, CODY $547.12 NORTON, PATRICK $136.36 OAKLEY, JON $1,678.51 OLSEN, KARI $1,419.29 OSTRING, KATHLEEN $1,176.55 PARISH, TONJA $1,229.55 PARKER, SUSAN $634.08 PEARD, WILLIAM $492.27 PELLETTERI, SALVATORE $268.45 PENTICO, ANDREA $332.49 PETERSON, KATIE $1,196.50 PETERSON, OREN $1,864.24 PETERSON, RICK $393.55 PETTIT, BRANDON $1,520.62 PINEGAR, TOMMIE $1,325.36 Employee Name Salary PIZINGER, JAMES $578.39 POSADAS, OSCAR $256.95 PUDENZ, COLE $673.60 PURVIS, KATHRYN $1,128.51 QUINN, JOHN $2,710.25 RASH, RONALD $1,703.62 RICHARDSON, ELIZABETH $1,614.88 RIPPERGER, TRACY $237.85 ROBINSON, CLINT $2,994.51 ROOSE, NOAH $566.02 ROSS, JOH N $358.85 ROTHMEYER, KYLE $202.27 ROYER, TIMOTHY $2,600.43 ROYSTER, JACOB $1,326.48 SAPPENFIELD, DAVID $243.72 SCHAUFENBUEL, KARI $898.39 SCHETTLER, RODNEY $1,805.88 SCHUETT, REBECCA $1,994.09 SEDDON, JOSH $26.17 SHARON, JEREMIAH $1,065.49 SHORT, MCKENZIE $62.91 SKELLENGER, AMANDA $474.97 SMITH, ALEXANDER $531.94 SN,ELSON, NATHANIEL $126.12 SOFEN, NATASHA $34.56 SOUKUP, JESSICA $709.06 SPOSETO, MACKENZIE $1,840.42 SPRAGUE, JEREMY $651.25 SPRAGUE, MATTHEW $1,881.60 STAROSELSKY, GALENA $890.07 STEINKE, KURT $600.21 STEPHENS, CLINT $278.35 STEWARD, ERIC $1,743.12 STOTZ, MELISSA $649.47 SUMMY, KENNETH $841.74 TETMEYER, CARL $170.29 THOMAS, JULIE $347.43 TUEL, JASON $251.85 TYSDAL, THOMAS $2,162.94 VAN ERDEWYK, RACHEL $527.95 VAN PELT, ROBERT $199.57 VANDE KAMP, JOSHUA $1,474.27 VANROEKEL, DREW $768.03 VOEGTLE, TIMOTHY $1,324.06 VOKES, LARRY $1,640.86 WALLACE, ERIC $1,646.14 WAMBUU, PETERSON $1,136.32 WASKE, CHARLES $1,661.56 WAUGH, DOUGLAS $878.12 WAYCASTER, SAVANNAH $230.30 WERNIMONT, THOMAS $357.47 WERTS, DANIEL $1,906.39 WESTON STOLL, KERI $1,469.15 WHITE, JASON $1,310.02 WHITE, LEAH $1,202.96 WIGGINS, MATHEW $1,682.15 WILSON, JODY $1,087.41 WINTERS, TROY $1,647.22 WISE, NATHAN $2,345.25 WOOD, DANIEL $1,311.63 WRIGHT, PAUL $784.73 WYZGOWSKI, JASMINE $453.33 YATES, CASSANDRA $274.78 YOUNG, ERIN $97.25