The URL can be used to link to this page

Home My WebLink About2017-08-21-J01A 08212017_bill listCity of Waukee Bill Presentation Recap August 21, 2017 Total Unpaid Bills Presented for Approval : Total Checks Issued Prior to Council Approval: Regular Checks: A) Prior to Last Council Meeting B) After Last Council Meeting C) Payroll Taxes & Reimbursements D) Utility Refunds FY 2017 Fund Recap: Grand Total: Expenditures Budgeted Year To Date $809,436.78 $5,189.90 $386,170.65 $149,196.73 $4,043.52 $1, 354�,037.58 , Revenues Budgeted Year To Date 010 General Fund $ 9,736,705 $ 9,615,149 $ 9,520.350 $ 12,174,773 060 Road Use Tax Fund $ 2,145,066 $ 2,207,433 $ 1,822,167 $ 2,110,475 075 Waukee Foundation $ - $ 180,820 $ - $ 72,310 085 Asset Forfeitures $ - $ - $ - $ 421 091 Hickman West Indust Park TIF $ 421,365 $ 386,166 $ 576,400 $ 599,123 092 Enterprise Business Park TIF Fund $ 232,550 $ 232,550 $ 600 $ 2,765 093 Waukee Urban Renewal Area TIF Fund $ 2,988,360 $ 3,187,928 $ 2,780,500 $ 2,827,977 094 Gateway Urban Renewal $ - $ 34,336 $ - $ - 095 Autumn Ridge Urban Renewal $ - $ 521 $ - $ - 096 Waukee West Urban Renewal $ 36,564 $ - 110 Debt Service Fund $ 6,951,481 $ 8,676,557 $ 6,999,755 $ 8,683,207 111 Special Assessments Fund $ 45,698 $ 45,698 $ 42,200 $ 34,533 210 Employee Benefits Fund $ 1,500,285 $ 1,500,285 $ 1,504,285 $ 1,507,179 327 Capital Projects $ 11,653,500 $ 7,968,805 $ 11,653,500 $ 15,558,368 330 City Wide SA Sidewalk Project $ - $ - $ - $ 11,741 510 Water Utility Fund $ 3,910,801 $ 3,657,918 $ 3,671,507 $ 4,940,841 520 Sewer Utility Fund $ 7,003,697 $ 9,035,061 $ 3,714,066 $ 5,157,585 521 University Ave Trunk Sewer Project $ - $ - $ - $ 8,822 522 Waste Water Treatment PI $ - $ - $ - $ 303 523 E Area Pump Sta Treatment $ - $ - $ - $ 1,064 540 Gas Utility Fund $ 5,590,810 $ 4,483,754 $ 5,491,100 $ 5,600,889 560 Storm Sewer Utility Fund $ 1,148,970 $ 1,019,802 $ 891,150 $ 977,740 570 Utility Bill Fund $ 264,790 $ 251,956 $ 264,750 $ 273,592 590 Solid Waste Collect & Rcycl Fund $ 1,081,760 $ 1,101,220 $ 1,101,160 $ 1,184,668 750 Golf Course Fund $ 507,595 $ 748,588 $ 592,300 $ 606,009 810 Equipment Revolving Fund $ - $ - $ 30,000 $ 22,087 Total: $ 55.183,423 $ 54,371,110 $ 50,655,790 $ 62,356,474 City of Waukee FY2017 Department Report - General Fund As of AUGUST 21ST , 2017 Expended YTD Budgeted $ Remaining General Fund: Police Department Personnel Services $ 2,208,142 Supplies & Services $ 321,082 Capital Outlay $ 138,350 $ 2,667,574 $ 2,661,080 $ (6,494) Warning Sirens Personnel Services $ 989 Supplies & Services $ - Capital Outlay $ $ 989 $ 2,000 $ 1,011 Westcom Dispatch Personnel Services $ - Supplies & Services $ 448,608 Capital Outlay $ - $ 448,608 $ 430,500 $ (18,108) Fire Department Personnel Services $ 674,678 Supplies & Services $ 86,391 Capital Outlay $ - $ 761,069 $ 830,720 $ 69,651 EMS Personnel Services $ 670,229 Supplies & Services $ 92,121 Capital Outlay $ - $ 762,350 $ 762,600 $ 250 Building Inspection Personnel Services $ 317,532 Supplies & Services $ 30,118 Capital Outlay $ 24,195 $ 371,845 $ 398,830 $ 26,985 Animal Control Personnel Services Supplies & Services $ 7,003 Capital Outlay $ 7,003 $ 1,000 $ (6,003) Library Services Personnel Services $ 573,149 Supplies & Services $ 199,819 Capital Outlay $ 45 $ 773,013 $ 852,275 $ 79,262 Mosquito Control Personnel Services $ - Supplies & Services $ Capital Outlay $ - $ - $ 6,500 $ 6,500 Parks Personnel Services $ 261,666 Supplies & Services $ 187,799 Capital Outlay $ 96,639 $ 546,103 $ 480,297 $ (65,806) Recreation Personnel Services $ 358,498 Supplies & Services $ 202,104 Capital Outlay $ - $ 560,602 $ 523,662 $ (36,940) Community Center Personnel Services $ 4,074 Supplies & Services $ 14,974 Capital Outlay $ - $ 19,048 $ 24,320 $ 5,273 Public Works Personnel Services $ 56,724 Supplies & Services $ (449) Capital Outlay $ - $ 56,275 $ 73,644 $ 17,369 Public Works Building Personnel Services $ - Supplies & Services $ (10,311) Capital Outlay $ 10,500 Public Works Mechanic Personnel Services $ 174,192 Supplies & Services $ (86,586) Capital Outlay $ - Median and Bldg Grounds Personnel Services Supplies & Services $ 11,322 Capital Outlay 189 $ - $ 87,607 $ 171,750 $ $ 11,322 $ 14,000 $ Mayor & Council Personnel Services $ 34,852 Supplies & Services $ 25,124 Capital Outlay $ - Elections Personnel Services $ Supplies & Services $ Capital Outlay $ - Communications Personnel Services $ 55,015 Supplies & Services $ 9,862 Capital Outlay $ - Administration Personnel Services $ 185,233 Supplies & Services $ 161,953 Capital Outlay $ 504,098 City Hall Personnel Services $ - Supplies & Services $ 60,015 Capital Outlay $ (1,003) Human Resources Personnel Services $ 60,369 Supplies & Services $ 7,461 Capital Outlay $ - Financial Administration Personnel Services $ 110,198 Supplies & Services $ 22,975 Capital Outlay $ 20,926 Other Financing $ - Community Development Personnel Services $ 221,791 Supplies & Services $ 112,032 Capital Outlay $ - City Attorney Personnel Services $ - Supplies & Services $ 65,199 Capital Outlay $ - Development Services Personnel Services $ 311,328 Supplies & Services $ 95,050 Capital Outlay $ - Information Technology Personnel Services $ 9,367 Supplies & Services $ 1,392 Capital Outlay $ 5,272 Engineering Personnel Services $ 335,553 59,976 $ 72,840 $ - $ 8,000 $ (189) 84,143 2,678 12,864 m 64,877 $ 114,808 $ 49,931 851,285 $ 348,250 $ (503,035) 59,012 $ 79,000 $ 19,988 67,830 $ 80,138 $ 12,308 154,099 $ 198,922 $ 44,823 333,823 $ 324,240 $ (9,583) 65,199 $ 100,000 $ 34,801 406,378 $ 524,535 $ 118,157 16,031 $ - $ (16,031) GIS Supplies & Services Capital Outlay Personnel Services Supplies & Services Capital Outlay Transfers to GO Debt Service $ 89,226 $ 12,924 $ 437,703 $ 625,139 $ 187,436 $ 20,640 $ (8,223) $ 12,924 $ 25,341 $ 27,655 $ 2,314 Total General Fund: Personnel Services $ 6,644,220 Supplies & Services $ 2,146,060 Capital Outlay $824,869.14 Other $ - $ 9,615,149 $ 9,736,705 $ 121,556 $ 9,615,149 Expense Approval Register kill)City of Waukee, IA kill) APPKT00714 - AUGUST 22ND COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount TREASURER STATE OF IOWA INV0003431 07/31/2017 JUL'17 WATER SALES TAXES 510-2030500 35,010.51 TREASURER STATE OF IOWA INV0003432 07/31/2017 JUL'17 SEWER SALES TAXES 520-2030500 2,667.11 TREASURER STATE OF IOWA INV0003433 07/31/2017 JUL'17 GAS SALES TAXES 540-2030500 974.47 TREASURER STATE OF IOWA INV0003434 07/31/2017 JUL'17 STORM WATER SALE 560-2030500 1,216.58 TREASURER STATE OF IOWA INV0003435 07/31/2017 JUL'17 GOLF COURSE SALES 750-2030500 3,234.02 TREASURER STATE OF IOWA INV0003436 07/31/2017 JUL'17 PARK &REC SALES 010-2030500 105.60 43,208.29 Department: 1100 - POLICE OPERATIONS GATEHOUSE MEDIA IOWA H 0000205838 07/30/2017 JULY'17 PUBLICATIONS 010-10.1100.210000 38.20 SIRCHIE FINGER PRINT LAB 0311117-IN 08/01/2017 MARIJUANA ON -SITE FIELDT 010-10.1100.540000 81.18 ORKIN PEST CONTROL 160060374 08/21/2017 PESTCONTROL 010-10.1100.400000 105.28 ULTRAMAX 165097 07/18/2017 AMMUNITION 010-10.1100.470010 1,308.00 STIVERS FORD 188427 07/27/2017 SEAT CUSHION REPAIRS 010-10.1100,410000 434.87 STIVERS FORD 189959 07/28/2017 REPAIRS TO VEHICLE#051 010-10.1100.410000 449.02 STIVERS FORD 190372 08/03/2017 OIL CHANGE/ALIGNMENT/IN 010-10.1100.410000 441.40 STIVERS FORD 190791C 08/14/2017 OIL CHANGE/BREAK INSPECT 010-10.1100.410000 596.53 RJ LAWN SERVICE INC 21110 07/25/2017 SUMMER FERTILIZER/SPOTS 010-10.1100.400000 109.65 RANKIN COMMUNICATION S 227325 08/02/2017 TELEPHONE INSTALL/MOUN 010-10.1100.450000 629.04 ELECTRONIC ENGINEERING C 344002434 07/12/2017 BATTERIES FOR OFFICER RAD 010-10.1100.540000 454.40 ELECTRONIC ENGINEERING C 344002434-1 08/04/2017 RADIO BATTERIES 010-10.1100.410100 454.40 HOLMES MURPHY 419502 08/01/2017 AUG'17 HMA MONTHLY CO 010-10.1100.100000 863.94 CARPENTER UNIFORM CO 445553 07/28/2017 PANTS-CUNNINGHAM 010-10.1100.120000 74.99 CARPENTER UNIFORM CO 445592 07/28/2017 TROUSER - GUESS 010-10.1100.120000 86.99 CARPENTER UNIFORM CO 446048 08/04/2017 SHIRTS/JACKETS-LEMKE 010-10.1100.120000 57.00 CARPENTER UNIFORM CO 446068 08/04/2017 TRI RELEASE BUCKLE -CUNN 010-10.1100.120000 6.99 ADECCO EMPLOYMENT SER 68658458 07/31/2017 CONTRACT LABOR -RHEA 010-10.1100.230000 537.47 ADECCO EMPLOYMENT SER 68667001 08/07/2017 CONTRACT LABOR - RHEA 010-10.1100.230000 545.10 BOUND TREE MEDICAL 82573324 07/26/2017 EVIDENCE SUPPLIES 010-10.1100.590000 38.15 DOC SHIRTS AND APPAREL 873020 07/11/2017 DEBADGED VEHICLES 010-10.1100.560000 200.00 DOC SHIRTS AND APPAREL 873021 07/12/2017 COMMUNITY PROTECTION D 010-10.1100.540000 100.00 BAKER ELECTRIC INC 89511-01 07/27/2017 DATA CABLE INSTALLATION 010-10.1100.410000 350.00 SHI INTERNATIONAL CORP B06908242 08/04/2017 PRINTERS FOR P.D. PATROL 010-10.1100.540000 462.00 ZIEGLER INC E9831803 08/03/2017 BACKUP GENERATOR 010-10.1100.400000 3,246.34 AMERITAS LIFE INSURANCE INV0003437 08/01/2017 AUG'17 VISION INSURANCE 010-10.1100.100000 488.08 CONSOLIDATED COMMUNIC INV0003454 08/08/2017 JULY'17 STATEMENT 010-10.1100.450000 48.76 CONSOLIDATED COMMUNIC INV0003454 08/08/2017 JULY'17 STATEMENT 010-10.1100.450000 49.27 CITY OF WAUKEE JULY17110140150 07/31/2017 JULY'17 STATEMENT 010-10.1100.480000 193.02 Department 1100 - POLICE OPERATIONS Total: 12,450.07 Department: 1400 - FIRE PROTECTION UNITED PARCEL SERVICE OOOOAW7647307 07/29/2017 SHIPPING 010-10.1400.360000 69.54 GALL'S INC 007882980 07/12/2017 PANTS/SHIRTS-CLEMEN 010-10.1400.120000 54.74 CHEMSTATION OF IOWA 010288 08/08/2017 VEHICLE CLEANER 010-10.1400.590000 31.98 CUMMINS CENTRAL POWER 020-4537 07/31/2017 FAN BELTS 010-10.1400.410000 110.19 INTERSTATE INDUSTRIAL SER 200069 04/21/2017 NEW GAS METER 010-10.1400.410100 240.22 INTERSTATE INDUSTRIAL SER 200289 05/10/2017 PRICE CORRECTION INVOICE 010-10.1400.410100 -30.75 INTERSTATE INDUSTRIAL SER 201003 07/18/2017 4-GSA CALIBRATION GAS 010-10.1400.410100 228.00 EAGLE ENGRAVING, INC. 2017-2526 07/25/2017 NAME/LOCKER TAGS -ABRA 010-10.1400.590000 100.25 RI LAWN SERVICE INC 21110 07/25/2017 SUMMER FERTILIZER/SPOTS 010-10.1400.400000 72.68 SHOTTENKIRK CHEVROLET-P 39569 07/14/2017 DOOR PANEL 010-10.1400.410000 175.00 HOLMES MURPHY 419502 08/01/2017 AUG'17 HMA MONTHLY CO 010-10.1400.100000 213.71 NAPA AUTO PARTS STORE 4387-955348 08/06/2017 SPARK PLUG 010-10.1400.410100 12.90 KUM & GO 50708820 07/31/2017 JULY'17 STATEMENT 010-10.1400.570000 480.42 MENARDS 89110 08/02/2017 TURBO FAN 010-10.1400.590000 80.37 MENARDS 90012 08/10/2017 FOAM BRUSH/FRAME 010-10.1400.590000 5.41 8/17/2017 9:24:22 AM Page 1 of 14 Expense Approval Register Packet: APPKT00714 - AUGUST 22ND COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item( Account Number Amount CAPITAL SANITARY SUPPLY C238045 07/26/2017 BLEACH/FABRIC SOFTENER/S 010-10.1400.590000 176.46 CAPITAL SANITARY SUPPLY C239080 08/09/2017 SUPPLIES 010-10.1400.590000 46.03 MUNICIPAL EMERGENCY SER CM105028 11/18/2016 GLOBE ALTERATIONS 010-10.1400.590000 -93.25 MUNICIPAL EMERGENCY SER CM105370 12/09/2016 NAME TAGS 010-10.1400.590000 -34.50 MUNICIPAL EMERGENCY SER IN1133901 05/24/2017 BULLARD HELMETS 010-10.1400.120000 29.45 MUNICIPAL EMERGENCY SER IN1146688 07/17/2017 NAMEPLATE-CATALDO 010-10.1400.120000 6.20 MUNICIPAL EMERGENCY SER IN1149058 07/26/2017 CUSTOM GOLBE COAT/PANT 010-10.1400.540000 2,500.10 MUNICIPAL EMERGENCY SER IN1153150 08/09/2017 CONSTRUCTION HOOD/GLO 010-10.1400.410100 320.61 INTERNATIONAL PUBLIC MA IN-29408-F6R6Q3 06/27/2017 ENTRY FIRE TEST 010-10.1400.470000 379.50 AMERITAS LIFE INSURANCE INV0003437 08/01/2017 AUG'17 VISION INSURANCE 010-10.1400.100000 124.60 CONSOLIDATED COMMUNIC INV0003454 08/08/2017 JULY'17 STATEMENT 010-10.1400.450000 45.68 CONSOLIDATED COMMUNIC INV0003454 08/08/2017 JULY'17 STATEMENT 010-10.1400.450000 49,27 CITY OF WAUKEE JULY17110140150 07/31/2017 JULY'17 STATEMENT 010-10,1400,480000 127.93 ONE SOURCE PLUS4380-20170731 07/31/2017 BACKGROUND CHECKS 010-10.1400.470000 280.00 Department 1400 - FIRE PROTECTION Total: 5,802.74 Department: 1500 - EMS UNITED PARCEL SERVICE OOOOAW7647307 07/29/2017 SHIPPING 010-10.1500.360000 69.54 GALL'S INC 007882980 07/12/2017 PANTS/SHIRTS-CLEMEN 010-10.1500.120000 54.74 CHEMSTATION OF IOWA 010288 08/08/2017 VEHICLE CLEANER 010-10.1500.590000 31.97 FRUSA EMS 10793 08/09/2017 JULY'17 AMBULANCE BILLIN 010-10.1500.231800 1,507.75 RJ LAWN SERVICE INC 21110 07/25/2017 SUMMER FERTILIZER/SPOTS 010-10.1500.400000 72.67 HAMMER MEDICALSUPPLY- 2424418 08/04/2017 COMPRESSED OXYGEN 010-10.1500.590050 206.85 SHOTTENKIRK CHEVROLET-P 39569 07/14/2017 DOOR PANEL 010-10,1500.410000 175.00 HOLMES MURPHY 419502 08/O1/2017 AUG'17 HMA MONTHLY CO 010-10.1500.100000 213.70 KUM&GO 50708820 07/31/2017 JULY'17 STATEMENT 010-10.1500.570000 480.42 CROSS DILLON TIRE, INC. 7348301 07/27/2017 STEERS BALANCE/SWITCHES 010-10.1500.410000 326.25 BOUNDTREE MEDICAL 82568966 07/21/2017 MEDICALSUPPLIES 010-10.1500,540000 174.99 BOUNDTREE MEDICAL 82568966 07/21/2017 MEDICALSUPPLIES 010-10.1500.590050 44.95 BOUNDTREE MEDICAL 82570246 07/24/2017 RESTRAINTSTRAP 010-10.1500.540000 133.99 BOUNDTREE MEDICAL 82573323 07/26/2017 MEDICALSUPPLIES 010-10.1500.590050 309.51 CAPITAL SANITARY SUPPLY C238045 07/26/2017 BLEACH/FABRIC SOFTENER/S 010-10.1500.590000 176.46 CAPITAL SANITARY SUPPLY C239080 08/09/2017 SUPPLIES 010-10.1500.590000 46.03 MUNICIPAL EMERGENCY SER CM105028 11/18/2016 GLOBE ALTERATIONS 010-10.1500.590000 -93.25 MUNICIPAL EMERGENCY SER CM105370 12/09/2016 NAME TAGS 010-10.1500.590000 -34.50 MUNICIPAL EMERGENCY SER IN1133901 05/24/2017 BULLARD HELMET-CATALDO 010-10.1500.120000 29.45 MUNICIPAL EMERGENCY SER IN1146688 07/17/2017 NAMEPLATE-CATALDO 010-10.1500.120000 6.21 INTERNATIONAL PUBLIC MA IN-29408-F6R6Q3 06/27/2017 ENTRY FIRE TEST 010-10.1500.470000 379.50 AMERITAS LIFE INSURANCE INV0003437 O8/01/2017 AUG'17 VISION INSURANCE 010-10.1500.100000 124.59 CONSOLIDATED COMMUNIC INV0003454 08/08/2017 JULY'17 STATEMENT 010-10.1500.450000 45.68 CONSOLIDATED COMMUNIC INV0003454 08/08/2017 JULY'17 STATEMENT 010-10.1500.450000 49.27 MERCY WEST PHARMACY INV0003471 08/01/2017 EMS MEDICATION 010-10.1500.590050 277.56 MERCY COLLEGE OF HEALTH INV0003472 08/05/2017 OB/GYN EMERGENCIES 010-10.1500.590050 10.00 CITY OF WAUKEE JULY17110140150 07/31/2017 JULY'17 STATEMENT 010-10,1500.480000 127.93 Department 1500 - EMS Total: 4,947.26 Department: 1900 - BUILDING INSPECTION HOLMES MURPHY 419502 08/01/2017 AUG'17 HMA MONTHLY CO 010-10.1900.100000 127.32 AMERITAS LIFE INSURANCE INV0003437 08/01/2017 AUG'17 VISION INSURANCE 010-10.1900.100000 75.84 Department 1900 - BUILDING INSPECTION Total: 203.16 Department: 2130 - ALICES ROAD PROJECT SNYDER &ASSOCIATES INC 117.0234.01C-4 07/31/2017 ALICES ROAD PHASE 4 327-90.2130.840490 36,211.84 TEAM SERVICES INC 1790160-0 07/24/2017 SE ESKER RIDGE DRIVE 327-90.2130.230051 889.33 TEAM SERVICES INC 1790238-0 07/27/2017 SE ALICES RD PHASE 4 327-90.2130.840490 3,910.65 Department 2130 - ALICES ROAD PROJECT Total: 41,011.82 Department: 2131- ESKER RIDGE - RISE PROJECT SNYDER & ASSOCIATES INC 117.0234.O1A-2 07/31/2017 SE ESKER RIDGE 327-90.2131.230051 12,639.44 Department 2131- ESKER RIDGE - RISE PROJECT Total: 12,639.44 8/17/2017 9:24:22 AM Page 2 of 14 Expense Approval Register Packet: APPKT00714 - AUGUST 22ND COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount Department: 2400 - ANIMAL CONTROL BRODERICK ANIMAL CLI NIC 156157 08/04/2017 CANINE/FELINE BOARDING 010-10.2400.340000 540.00 Department 2400 -ANIMAL CONTROL Total: 540.00 Department: 3100 - LIBRARY SERVICES OCLC, INC 0000547816 07/31/2017 CATALOG SERVICE 010-40.3100.590000 152.53 BAKER MECHANICAL, INC. 137147 07/31/2017 HVAC MAINTENANCE 010-40.3100.400000 654.00 BUDGET LIBRARY SUPPLIES 15806 08/03/2017 VOYAGERSCANNER 010-40.3100.540000 378.00 ORKIN PEST CONTROL 160059420 08/21/2017 PEST CONTROL - LIBRARY 010-40.3100.400000 68.61 WASH -ECLAIR 191647 07/24/2017 WASH WINDOWS 010-40.3100.400100 38.00 HOLMES MURPHY 419502 08/01/2017 AUG'17 HMA MONTHLY CO 010-40.3100.100000 263.73 CARNEGIE-STOUT PUBLIC LIB 4243002 07/25/2017 LOST BOOK 010-40.3100.590000 24.00 MID AMERICAN ENERGY 520160717 07/18/2017 JULY'17 STATEMENT 010-40.3100.480000 5,150.39 DEMCO INC. 6146109 06/01/2017 TITAN BOOK SUPPORT/TAPE 010-40.3100.590000 847.13 DEMCO INC. 6174798 07/25/2017 OVD ALBUM/EARBUDS/BAR 010-40.3100.590000 205.89 TRUGREEN 69867363 07/26/2017 LAWN SERVICES 010-40.3100.400000 247.20 OFFICE DEPOT 942307229001 07/21/2017 BABY WIPES 010-40.3100.590000 58.99 OFFICE DEPOT 946923369001 07/26/2017 PAPER/COFFEE/REFILLS 010-40.3100.590000 89.96 INGRAM LIBRARY SERVICES 99450676 07/25/2017 BOOKS O10-40.3100.590000 8.94 INGRAM LIBRARY SERVICES 99450676 07/25/2017 BOOKS 010-40.3100.640000 64.90 INGRAM LIBRARY SERVICES 99450677 07/25/2017 BOOKS 010-40.3100.590000 2.50 INGRAM LIBRARY SERVICES 99450677 07/25/2017 BOOKS 010-40.3100.640000 4.79 INGRAM LIBRARY SERVICES 99459055 07/26/2017 BOOKS - 010-40.3100.640000 195.50 INGRAM LIBRARY SERVICES 99489374 07/27/2017 BOOKS 010-40.3100.590000 15.08 INGRAM LIBRARY SERVICES 99489374 07/27/2017 BOOKS 010-40.3100.640000 85.26 INGRAM LIBRARY SERVICES 99489375 07/27/2017 BOOKS 010-40.3100.590000 1.39 INGRAM LIBRARY SERVICES 99489375 07/27/2017 BOOKS 010-40.3100.640000 37.99 INGRAM LIBRARY SERVICES 99489376 07/27/2017 BOOKS 010-40.3100.590000 6.07 INGRAM LIBRARY SERVICES 99489376 07/27/2017 BOOKS 010-40.3100.640000 35.16 INGRAM LIBRARY SERVICES 99502627 07/28/2017 BOOKS 010-40,3100,590000 5.55 INGRAM LIBRARY SERVICES 99502627 07/28/2017 BOOKS 010-40.3100.640000 25.17 INGRAM LIBRARY SERVICES 99502628 07/28/2017 BOOKS 010-40.3100.590000 2.90 INGRAM LIBRARY SERVICES 99502628 07/28/2017 BOOKS 010-40.3100.640000 9.59 INGRAM LIBRARY SERVICES 99553159 08/O1/2017 BOOKS 010-40.3100.590000 22.62 INGRAM LIBRARY SERVICES 99553159 08/O1/2017 BOOKS 010-40,3100.640000 117.27 INGRAM LIBRARY SERVICES 99553160 08/O1/2017 BOOKS 010-40.3100.590000 2.78 INGRAM LIBRARY SERVICES 99553160 08/O1/2017 BOOKS 010-40.3100.640000 31.63 INGRAM LIBRARY SERVICES 99553161 08/O1/2017 BOOKS 010-40.3100.590000 2.24 INGRAM LIBRARY SERVICES 99553161 08/O1/2017 BOOKS 010-40.3100.640000 21.74 INGRAM LIBRARY SERVICES 99553162 08/O1/2017 BOOKS 010-40.3100.590000 1.19 INGRAM LIBRARY SERVICES 99553162 08/O1/2017 BOOKS 010-40.3100.640000 16.10 AMERITAS LIFE INSURANCE INV0003437 08/01/2017 AUG'17 VISION INSURANCE 010-40.3100.100000 137.64 VEENSTRA & KIMM INC INV0003438 07/28/2017 WAUKEE PUB. LIBRARY BIOR 010-40.3100.880000 1,003.61 CONSOLIDATED COMMUNIC INV0003454 08/08/2017 JULY'17 STATEMENT 010-40.3100.450000 157.92 CONSOLIDATED COMMUNIC INV0003454 08/08/2017 JULY'17 STATEMENT 010-40.3100.450000 49.27 EMMA, INC. INV01309198 08/08/2017 NEWSLETTER MANAGEMEN 010-40.3100.270000 961.00 Department 3200 - LIBRARY SERVICES Total: 11,204.23 Department: 4100 - PARKS ZIMCO SUPPLY CO 108576 05/10/2017 MESA 40# BAG 010-40.4100.590100 703.00 UNITYPOINT CLINIC-OCCUPA 207129 08/02/2017 DRUG TESTS 010-40.4100.470000 37.00 G&LCLOTHING 2-181742 08/04/2017 WORK SHORT/KEEN CUSHIO 010-40.4100.120000 49.49 METHODIST OCCUPATIONAL 227507 07/31/2017 DRUG SCREENS 010-40.4100.470000 22.00 BDI SIGNS BUSINESS DESIGN 33218 08/05/2017 METAL SIGNS 010-40.4100.410300 280.00 MULCH MART 41314 07/21/2017 PLAY MATCERTIFIED 010-40.4100.410300 2,092.50 HOLMES MURPHY 419502 08/O1/2017 AUG'17 HMA MONTHLY CO 010-40.4100.100000 - 9.09 HOLMES MURPHY 419502 08/O1/2017 AUG'17 HMA MONTHLY CO 010-40.4100.100000 18.19 HOLMES MURPHY 419502 08/O1/2017 AUG'17 HMA MONTHLY CO 010-40.4100.100000 45.47 TRUGREEN 70177707 07/30/2017 TRIANGLE PARK WALNUT & 010-40.4100.590100 36.75 MENARDS 88237 07/26/2017 PIPE/COUPLING/BARB/HOSE 010-40.4100.410300 36.86 IOWA PRISON INDUSTRIES 944815 07/31/2017 SIGNS 010-40.4100.410300 412.50 FULLER PETROLEUM SERVIC 99651 07/28/2017 FUEL 010-40.4100.570000 188.13 8/17/2017 9:24:22 AM Page 3 of 14 Expense Approval Register Packet: APPKT00714 - AUGUST 22ND COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount FASTENAL COMPANY IAGRMS8696 07/28/2017 RRING 010-40.4100.590000 9.27 FASTENAL COMPANY IAGRM88762 08/02/2017 PARTS 010-40.4100.590000 0.51 AMERITAS LIFE INSURANCE INV0003437 08/01/2017 AUG'17 VISION INSURANCE 010-40.4100.100000 10.68 AMERITAS LIFE INSURANCE INV0003437 08/O1/2017 AUG'17 VISION INSURANCE 010-40.4100.100000 27.24 AMERITAS LIFE INSURANCE INV0003437 08/O1/2017 AUG'17 VISION INSURANCE 010-40.4100.100000 2.14 WAUKEE HARDWARE & VARI INV0003443 07/31/2017 JULY'17 STATEMENT 010-40.4100.410300 154.68 HEARTLAND CO-OP INV0003444 07/31/2017 JULY'17 STATEMENT - PARK 010-40.4100.570000 540.55 CONSOLIDATED COMMUNIC INV0003454 08/08/2017 JULY'17 STATEMENT 010-40.4100.450000 14.65 CITY OF WAUKEE JULY17410 07/31/2017 JULY'17 STATEMENT 010-40.4100.480000 961.51 CITY OF WAUKEE JULY17410 07/31/2017 JULY'17 STATEMENT 010-40.4100.480100 2,658.51 Department 4100 - PARKS Total: 8,320.72 Department: 4200 - RECREATION HILGENBERG'S HAWAIIAN IC 000001 07/31/2017 TROPICALSNOW - PARK PLA 010-40.4200.460500 50.00 STEM EDUCATION & LEARNI 0009 07/28/2017 ENGINEERING FOR KIDS SU 010-40.4200.460500 776.00 FAREWAY STORES, INC. 00315262 08/04/2017 SUPER SNACKERS FOOD 010-40.4200.460500 4.98 FAREWAY STORES, INC. 00365402 08/03/2017 SUPER SNACKERS FOOD 010-40.4200.460500 14.72 ODEYS INC 119360 07/28/2017 BALL FIELD/SOCCER PAINT 010-40.4200.540000 376.60 CHARLES GABUS FORD 121763-1 08/04/2017 RENTAL VAN 010-40.4200.460500 1,274.81 JM IMPRESSIONS 2017-23 08/07/2017 FREELANCE DESIGN/LAYOUT 010-40.4200.350100 110.00 HOLMES MURPHY 419502 08/01/2017 AUG'17 HMA MONTHLY CO 010-40.4200.100000 109.13 JIMSJOHNS 59254 07/18/2017 4TH OFJULY TOILETS 010-40.4200.460800 779.80 AMERITAS LIFE INSURANCE INV0003437 08/01/2017 AUG'17 VISION INSURANCE 010-40,4200.100000 65.16 WAUKEE HARDWARE & VAR] INV0003443 07/31/2017 JULY'17 STATEMENT 010-40.4200,460800 20.36 CENTRAL IOWA OFFICIALS INV0003445 08/03/2017 '17 FALL YOUTH GIRLS 5B LE 010-40.4200.460050 960.00 HEARTLAND CO-OP INV0003446 07/31/2017 JULY'17 STATEMENT -REC 010-40.4200.570000 228.15 Department 4200 - RECREATION Total: 4,769.71 Department: 4300 - COMMUNITY CENTER NATIONWIDE OFFICE CLEAN 64424 08/04/2017 WINDOW CLEANING COMM 010-40.4300.400000 63.00 CITY OF WAUKEE JULY17430 07/31/2017 JULY'17 STATEMENT 030-40.4300.480000 389.69 Department 4300 - COMMUNITY CENTER Total: 452.69 Department: 5000 - BIKE TRAIL OLD RAILROAD VEENSTRA & KIMM INC INV0003438 07/28/2017 NORTH LOTH TRAIL HEAD PA 327-90.5000.881130 1,418.49 Department 5000 - BIKE TRAIL OLD RAILROAD Total: 1,418.49 Department: 5011- WINDFIELD / HIGH SCHOOL TRAIL SNYDER&ASSOCIATES INC 117.0519.01-1 07/19/2017 WINDFIELD/HS TRAIL 327-90.5011.230000 21,360.00 VEENSTRA & KIMM INC INV0003438 07/28/2017 WINDFIELD/HIGH SCHOOL 327-90.5011.230000 46.00 Department 5012 - WINDFIELD / HIGH SCHOOL TRAIL Total: 21,406.00 Department: 5300-STORM WATER METHODIST OCCUPATIONAL 227507 07/31/2017 DRUG SCREENS 560-80.5300.470000 48.00 INFOR PUBLIC SECTOR. INC. 37655-US06A 07/20/2017 INFOR CLOUDSUITE SUBSCRI 560-80.5300.740000 6,388.80 HOLMES MURPHY 419502 08/O1/2017 AUG'17 HMA MONTHLY CO 560-80.5300.100000 15.92 HOLMES MURPHY 419502 08/01/2017 AUG'17 HMA MONTHLY CO 560-80.5300.100000 109.13 VANNGUARD UTILITY PARTN 6336 08/02/2017 WAUKEE LOCATING 560-80.5300.340000 1,207.50 LIBERTY READY MIX 89648 07/20/2017 INTAKE 560-80.5300.410300 272.00 LIBERTY READY MIX 89649 07/20/2017 CONCRETE 560-80.5300.410300 1,036.00 LIBERTY READY MIX 89714 07/21/2017 CONCRETE 560-80.5300.410300 971.25 LIBERTY READY MIX 89802 07/24/2017 CONCRETE 560-80.5300.410300 434.75 LIBERTY READY MIX 89885 07/25/2017 CONCRETE 560-80.5300.410300 538.25 LIBERTY READY MIX 89995 07/27/2017 CONCRETE 560-80.5300.410300 582.75 HD SUPPLY WATERWORKS H508786 07/25/2017 24" ROAD & HWY 560-80.5300.410300 575.00 AMERITAS LIFE INSURANCE INV0003437 08/O1/2017 AUG'17 VISION INSURANCE 560-80.5300.100000 7.82 AMERITAS LIFE INSURANCE INV0003437 08/O1/2017 AUG'17 VISION INSURANCE 560-80.5300.100000 65.16 VEENSTRA & KIMM INC INV0003438 07/28/2017 HAWTHRONE RIDGE TOWN 560-80.5300.230000 319.77 VEENSTRA & KIMM INC INVO003438 07/28/2017 SOUTHFORK DAMN OUTLET 560-80.5300.230000 539.00 HEARTLAND CO-OP INV0003461 07/31/2017 JULY'17 STATEMENT -STOR 560-80.5300.570000 347.51 Department 5300 - STORM WATER Total: 13,458.61 8/17/2017 9:24:22 AM - Page 4 of 14 Expense Approval Register Packet: APPKT00714 - AUGUST 22ND COUNCIL PACKET Vendor Name Payable Number Post Date Description (item) Account Number Amount Department: 5400 - SOLID WASTE COLLECTION & DISPOSAL ANKENY SANITATION INC. 419612 08/O1/2017 AUGUST'17 STATEMENT 590-30.5400.231300 89,551.60 Department 5400 - SOLID WASTE COLLECTION & DISPOSAL Total: 89,551.60 Department: 5750 - LITTLE WALNUT CREEK GATEHOUSE MEDIA IOWA H 0000205838 07/30/2017 JULY'17 PUBLICATIONS 327-90.5750.881420 73.79 Department 5750 - LITTLE WALNUT CREEK Total: 73.79 Department: 6000 - PUBLIC WORKS METHODIST OCCUPATIONAL 227507 07/31/2017 DRUG SCREENS 010-20.6000.470000 48.00 HOLMES MURPHY 419502 08/01/2017 AUG'17 HMA MONTHLY CO 010-20,6000.100000 181.88 L.L. BEAN, INC 9004262135 08/09/2017 SHIRTS- ROYER 010-20.6000.120000 285.35 AMERITAS LIFE INSURANCE INV0003437 08/O1/2017 AUG'17 VISION INSURANCE 010-20.6000.100000 102.32 HEARTLAND CO-OP INV0003469 07/31/2017 JULY'17 STATEMENT - PUB 010-20.6000.570000 176.16 Department 6000 - PUBLIC WORKS Total: 793.71 Department: 6010 - PUBLIC WORKS BUILDING ORKIN PEST CONTROL 160059242 08/21/2017 PEST CONTROL -PUBLIC WO 010-20.6010.400000 86.26 RANKIN COMMUNICATION S 227323 08/02/2017 TELEPHONE PW 010-20.6010.400000 547.38 DOORS INC 244196 07/26/2017 DOOR REPAIRS 010-20.6010.400000 135.00 FIRST CHOICE COFFEE SERVI 318435 08/07/2017 COFFEE 010-20.6010.590000 106.47 SUPPLYWORKS 407786821 07/26/2017 WIPER POP UP 010-20.6010.580000 114.96 PLUMB SUPPLY COMPANY 4690582 08/04/2017 DELTA TRANSFORMER/DELT 010-20.6010.400000 56.03 PLUMB SUPPLY COMPANY 4694185 08/03/2017 PW RESTROOM DRIVER BOA 010-20.6010.400000 215.60 PLUMB SUPPLY COMPANY 4705079 08/04/2017 DELTA TRANSFORMER PW R 010-20.6010.400000 48.24 CINTAS CORPORATION 5008297052 07/17/2017 FIRST AID KIT SUPPLIES - PUB 010-20.6010.590000 284.31 G&KSERVICES INC 6183746087 08/02/2017 MAT SERVICES -PUBLIC WO 010-20.6010.400000 174.32 OVERHEAD DOOR COMPANY 73754 08/07/2017 OIL &ADJUSTED DOOR 010-20.6010A00000 316.00 PRAXAIR DISTRIBUTION#44 78392857 07/31/2017 CYLINDERS 010-20.6010.590000 65.25 CINTAS CORPORATION 9013568365 04/06/2017 FIRST AID SUPPLIES -PUBW 010-20.6010.400000 189.33 OFFICE DEPOT 940579246001 07/03/2017 FOLDERS/LABELS/MARKERS/ 010-20.6010.580000 74.53 OFFICE DEPOT 946468287001 07/25/2017 PAPER/NOTE PADS 010-20.6010.590000 73.67 STROH CORP H17013597 07/28/2017 LEAK IN DUCTWORK 010-20.6010.400000 656.14 FASTENALCOMPANY IAGRM88720 07/31/2017 GLOVES/AIRSOFT CORD/EVE 010-20.6010.590000 105.27 CONSOLIDATED COMMUNIC INV0003454 08/08/2017 JULY'17 STATEMENT 010-20.6010.450000 142.32 CONSOLIDATED COMMUNIC INV0003454 08/08/2017 JULY'17 STATEMENT 010-20,6010.450000 443.44 CONSOLIDATED COMMUNIC INV0003455 08/01/2017 AUGUST'17 STATEMENT 010-20.6010.450000 165.21 HEARTLAND CO-OP INV0003468 07/31/2017 JULY'17 STATEMENT - PUB. 010-20.6010.590000 145.50 HEARTLAND CO-OP INV0003469 07/31/2017 JULY'17 STATEMENT - PUB O10-20.6010.590000 162.00 CITY OF WAUKEE JULY17601 07/31/2017 JULY'17 STATEMENT 010-20.6010.480000 942.33 AT&T MOBILITY X08082017 08/08/2017 AUGUST'17 STATEMENT 010-20.6010.450000 58.12 Department 6010 - PUBLIC WORKS BUILDING Total: 5,307.69 Department: 6150 - PUBLIC WORKS MECHANIC GRAHAM TIRE OF DES MOIN 1100095291 08/03/2017 TIRES 010-20.6150.570130 565.64 ELECTRONIC ENGINEERING C 120003015-1 07/27/2017 ANTENNAS/RADIOS 010-20.6150.570130 296.52 CFI SALES INC 245438 08/07/2017 MOWER PARTS 010-20.6150.570130 598.82 TRUCK EQUIPMENT INC 281924 08/10/2017 BUTTON SPOOL ENDS/SPOO 010-20.6150.570130 108.19 ADEL AUTO PARTS 362012 07/31/2017 BRAKE PADS 010-20.6150.570130 34.23 ADEL AUTO PARTS 362015 07/31/2017 BRAKE CALIPER/CORE DEPOS 010-20.6150.570130 185.12 ADEL AUTO PARTS 362058 08/01/2017 OIL FILTER 010-20.6150.570110 13.36 ADEL AUTO PARTS 362127 08/02/2017 SPARK PLUG 010-20.6150.570130 2.66 ADEL AUTO PARTS 362154 08/02/2017 CORE DEPOSIT CREDITS 010-20.6150.570130 -55.56 ADEL AUTO PARTS 362201 08/03/2017 OIL FILTERS 010-20.6150.570110 35.83 ADEL AUTO PARTS 362269 08/04/2017 BRAKE PADS 010-20.6150.570130 31.83 ADEL AUTO PARTS 362351 08/07/2017 BRAKE MASTER CYLINDER 010-20.6150.570130 57.40 ADEL AUTO PARTS 362356 08/07/2017 BRAKE FLUID 010-20.6150.570130 20.99 TOMPKINS INDUSTRIES 403599711 08/03/2017 DUSTCAP/DUST PLUG 010-20.6150.570130 160.24 HOLMES MURPHY 419502 08/01/2017 AUG'17 HMA MONTHLY CO 010-20.6150.100000 63.66 MATHESON TRI-GAS INC 51205359 07/31/2017 CYLINDERS 010-20,6150.590000 124.31 VAN -WALL EQUIPMENT INC 605575 06/09/2017 PAWL 010-20.6150.570130 21.38 SHOTTENKIRK CHEVROLET-P 61320365 08/09/2017 PARTS 010-20.6150.570130 109.99 VAN -WALL EQUIPMENT INC 647570 08/08/2017 BLADES 010-20.6150.570130 168.36 8/17/2017 9:24:22 AM Page 5 of 14 Expense Approval Register Packet: APPKT00714 - AUGUST 22ND COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount CAPITAL CITY EQUIPMENT C 79129D 08/07/2017 COUPLER/RING 010-20.6150.570130 297.00 CAPITAL CITY EQUIPMENT C 79168D 08/08/2017 RODTIE 010-20.6150.570130 181.37 C2G CORPORATION CG5834 08/09/2017 HAND SCRUB/WASH & WAX 010-20.6150.590000 170.47 AMERITAS LIFE INSURANCE INV0003437 08/O1/2017 AUG'17 VISION INSURANCE 010-20.6150.100000 37.92 HEARTLAND CO-OP INV0003470 07/31/2017 JULY'17 STATEMENT -MECH 010-20.6150.570000 211.71 WAUKEE HARDWARE &VARI INV0003473 07/31/2017 JULY'17 STATEMENT - PUB 010-20.6150.590000 3.98 LOGAN CONTRACTORS SUPP M32940 08/02/2017 SPARK PLUG 010-20.6150.570130 3.65 Department 6150 - PUBLIC WORKS MECHANIC Total: 3,459.07 Department: 6500- MEDIAN & BLDG GROUNDS # 1 LAWN CARE AND LANDS 000949 08/03/2017 MOWING/FERTILIZER/BED 010-50.6500.340000 3,052.00 Department 6500 - MEDIAN & BLDG GROUNDS Total: 3,052.00 Department: 6510- WATER UTILITY STANLEY CONSULTANTS INC. 0197699 07/31/2017 WATER TOWER ANTENNA IN 510-30.6510.881200 971.26 CONSTRUCTION & AGGREGA 0298046-IN O8/07/2017 ADAPTER/COUPLER/PARTS 510-30.6510.590000 411.64 MUNICIPAL SUPPLY, INC. 0662826-IN 07/12/2017 SEAL/RING/PLATE/PORT WIR 510-30.6510.590000 189.65 MUNICIPAL SUPPLY, INC. 0664859-IN 07/31/2017 METERS 510-30.6510.592000 57.95 MUNICIPAL SUPPLY, INC. 0665215-IN 07/31/2017 METERS 510-30.6510.592000 10,044.00 MUNICIPAL SUPPLY, INC. 0665591-IN 08/07/2017 BACKFLO PREVENT/GATE VA 510-30.6510.592000 772.25 MUNICIPAL SUPPLY, INC. 0665592-IN 08/07/2017 METERS 510-30.6510.592000 1,386.00 IOWA SECTION AMERICAN 16 07/27/2017 2017 FALL CONFERENCE - HE 510-30.6510.470000 440.00 METHODIST OCCUPATIONAL 227507 07/31/2017 DRUG SCREENS 510-30.6510.470000 45.00 INFOR PUBLIC SECTOR. INC. 37655-USO6A 07/20/2017 INFOR CLOUDSUITE SUBSCRI 510-30,6510.740000 6,388.80 HOLMES MURPHY 419502 08/01/2017 AUG'17 HMA MONTHLY CO 510-30.6510.100000 45.47 HOLMES MURPHY 419502 08/01/2017 AUG'17 HMA MONTHLY CO 510-30.6510.100000 22.73 HOLMES MURPHY 419502 08/O1/2017 AUG'17 HMA MONTHLY CO 510-30.6510.100000 63.66 HOLMES MURPHY 419502 08/O1/2017 AUG'17 HMA MONTHLY CO 510-30.6510.100000 15.92 PLUMB SUPPLY COMPANY 4679775 07/24/2017 6" GRIPPER TEST PLUG 510-30.6510.410400 24.35 SHERWIN WILLIAMS CO 6114-6 07/18/2017 PAINT 510-30.6510.410500 73.04 VANNGUARD UTILITY PARTN 6336 08/02/2017 WAUKEE LOCATING 510-30.6510.340000 1,207.50 SHERWIN WILLIAMS CO 6965-1 07/31/2017 HYDRANT PAINT 510-30.6510.410500 46.29 MENARDS 89071 08/02/2017 PARTS/TOOLS 510-30.6510.590000 38.13 FULLER PETROLEUM SERVIC 99651 07/28/2017 FUEL 510-30.6510.570000 188.12 C2G CORPORATION CG5834 08/09/2017 HAND SCRUB/WASH & WAX 510-30.6510.590000 170.48 HD SUPPLY WATERWORKS H535886 07/25/2017 FLEX COUPLING 510-30.6510.410400 62.84 HD SUPPLY WATERWORKS H582709 08/02/2017 PLUG 510-30.6510.410400 24.28 FASTENALCOMPANY IAGRM88719 07/31/2017 PARTS 510-30.6510.590000 19.91 AMERITAS LIFE INSURANCE INV0003437 08/01/2017 AUG'17 VISION INSURANCE 510-30.6510.100000 7.82 AMERITAS LIFE INSURANCE INV0003437 08/O1/2017 AUG'17 VISION INSURANCE 510-30.6510.100000 20.60 AMERITAS LIFE INSURANCE INV0003437 08/01/2017 AUG'17 VISION INSURANCE 510-30.6510.100000 13.62 AMERITAS LIFE INSURANCE INV0003437 08/O1/2017 AUG'17 VISION INSURANCE 510-30.6510.100000 34.60 VEENSTRA & KIMM INC INV0003438 07/28/2017 RACCOON RIVER PROPERTY 510-30.6510.230000 12,298.00 VEENSTRA & KIMM INC INV0003438 07/28/2017 WACO PLACE WATER MAIN 510-30.6510.230000 11,197.72 DES MOINES WATER WORKS INV0003450 07/26/2017 JULY'17 STATEMENT 510-30.6510.650000 48,234.46 DES MOINES WATERWORKS INV0003451 07/26/2017 JULY'17 STATEMENT 510-30.6510.650000 99,992.04 HEARTLAND CO-OP INV0003464 07/31/2017 JULY'17 STATEMENT -WATE 510-30.6510.570000 702.03 WAUKEE HARDWARE & VARI INV0003473 07/31/2017 JULY'17 STATEMENT - PUB 510-30.6510.590000 170.96 CITY OF WAUKEE JULY17651 07/31/2017 JULY'17 STATEMENT 510-30.6510.480000 752.65 VAN METER INDUSTRIAL INC 5009820361.002 07/12/2017 THERMOSTATWIRE 510-30.6510.590000 -238.54 VAN METER INDUSTRIAL INC 5009820361.003 07/12/2017 THERMOSTATWIRE 510-30.6510.590000 210.22 VAN METER INDUSTRIAL INC 5009820361.004 07/31/2017 WATER METER 510-30,6510.592000 1,261.26 Department 6510 - WATER UTILITY Total: 197,366.71 Department: 6520 - SANITARY SEWERS & TREATMENT GATEHOUSE MEDIA IOWA H 0000205838 07/30/2017 JULY'17 PUBLICATIONS 520-30.6520.210000 32.57 GATEHOUSE MEDIA IOWA H 0000205838 07/30/2017 JULY'17 PUBLICATIONS 520-30.6520.880050 28.73 ELECTRIC PUMP & TOOL INC 0040314-IN 07/31/2017 LIFT STATION REPAIR PARTS 520-30.6520.411100 2,193.00 TEAM SERVICES INC 1790129-0 07/24/2017 CONSTRUCTION TESTING SE 520-30.6520.883091 990.93 TEAM SERVICES INC 1790130-0 07/24/2017 CONSTRUCTION TESTING SE 520-30.6520.883092 126.86 EMERGENCY MEDICAL PROD 1911195 06/05/2017 GLOVES 520-30.6520.590000 267.50 EMERGENCY MEDICAL PROD 1923610 08/02/2017 GLOVES 520-30.6520.590000 535.00 8/17/2017 9:24:22 AM Page 6of 14 Expense Approval Register Packet: APPKT00714 - AUGUST 22ND COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount METHODIST OCCUPATIONAL 227507 07/31/2017 DRUG SCREENS 520-30.6520.470000 45.00 INFOR PUBLIC SECTOR. INC. 37655-US06A 07/20/2017 INFOR CLOUOSUITE SUBSCRI 520-30.6520.740000 6,388.80 HOLMES MURPHY 419502 08/O1/2017 AUG'17 HMA MONTHLY CO 520-30.6520.100000 90.94 HOLMES MURPHY 419502 08/O1/2017 AUG'17 HMA MONTHLY CO 520-30.6520.100000 63.66 HOLMES MURPHY 419502 08/O1/2017 AUG'17 HMA MONTHLY CO 520-30.6520.100000 15.92 HOLMES MURPHY 419502 08/O1/2017 AUG'17 HMA MONTHLY CO 520-30.6520.100000 22.73 CONTINENTAL RESEARCH CO 452032-CRC-1 07/11/2017 ZONKER BLOCKS CHERRY 520-30.6520.411100 569.94 PLUMB SUPPLY COMPANY 4686691 07/27/2017 LIFT STATION REPAIR PARTS 520-30.6520.411100 112.06 PLUMB SUPPLY COMPANY 4689715 07/31/2017 LIFT STATION REPAIR PARTS 520-30.6520.411100 -56.03 RAIN KING LLC 870887 07/31/2017 LITTLE WALNUT CREEK LIFTS 520-30.6520.883060 1,600.00 MENARDS 89198 08/03/2017 SOLID BLOCK 520-30.6520.590000 14.70 FULLER PETROLEUM SERVIC 99651 07/28/2017 FUEL 520-30.6520.570000 188.12 FASTENALCOMPANY IAGRMS8677 07/28/2017 COMP SPRING 520-30.6520.590000 6.22 AMERITAS LIFE INSURANCE INV0003437 08/O1/2017 AUG'17 VISION INSURANCE 520-30.6520.100000 13.62 AMERITAS LIFE INSURANCE INV0003437 08/O1/2017 AUG'17 VISION INSURANCE 520-30.6520.100000 34.60 AMERITAS LIFE INSURANCE INV0003437 08/O1/2017 AUG'17 VISION INSURANCE 520-30.6520.100000 41.20 AMERITAS LIFE INSURANCE INV0003437 08/O1/2017 AUG'17 VISION INSURANCE 520-30.6520.100000 7.82 VEENSTRA & KIMM INC INV0003438 07/28/2017 FORCE MAIN DISCHARGE M 520-30.6520.230000 407.00 VEENSTRA & KIMM INC INV0003438 07/28/2017 ORIGINAL SANITARY SEWER 520-30.6520.230000 332.50 VEENSTRA & KIMM INC INV0003438 07/28/2017 ORIG. SANITARY SEWER COL 520-30.6520.230000 2,782.00 VEENSTRA & KIMM INC INV0003438 07/28/2017 SOUTH OUTFALL SEWER - DE 520-30,6520.883000 35,636.35 VEENSTRA & KIMM INC INV0003438 07/28/2017 LITTLE WALNUT CREEK LIFT S 520-30.6520.883060 14,438.92 VEENSTRA & KIMM INC INV0003438 07/28/2017 LITTLE WALNUT CREEK REGI 520-30.6520.883060 6,243.48 VEENSTRA & KIMM INC INV0003438 07/28/2017 LITTLE WALNUT CREEK WEST 520-30.6520.883060 1,071.97 VEENSTRA & KIMM INC INV0003438 07/28/2017 FOX CREEK SEWER PHASE 3- 520-30.6520.883080 10,068.28 VEENSTRA & KIMM INC INV0003438 07/28/2017 FOX CREEK SEWER PHASE 3 520-30.6520.883080 3,287.47 VEENSTRA & KIMM INC INV0003438 07/28/2017 NW TRUNK SEWER EXTN. PH 520-30.6520.883091 276.00 VEENSTRA & KIMM INC INV0003438 07/28/2017 NW AREA TRUNK SEWER EX 520-30.6520.883091 3,145.61 VEENSTRA & KIMM INC INV0003438 07/28/2017 SW AREATRUNK SEWER EXT 520-30.6520.883092 138.00 VEENSTRA & KIMM INC INV0003438 07/28/2017 SW AREATRUNKSEWER EXT 520-30,6520.883092 581.31 CONSOLIDATED COMMUNIC INV0003454 08/08/2017 JULY'17 STATEMENT 520-30.6520.450000 145.27 IOWA DEPT OF NATURAL RE INV0003456 08/22/2017 FY'18 NPDES PERMIT FEE #2 520-30.6520.280000 1,275.00 HEARTLAND CO-OP INV0003465 07/31/2017 JULY'17 STATEMENT -SEWE 520-30.6520.570000 675.55 WAUKEE HARDWARE & VARI INV0003473 07/31/2017 JULY'17 STATEMENT- PUB 520-30.6520.590000 27.95 WAUKEE HARDWARE & VARI INV0003473 07/31/2017 JULY'17 STATEMENT- PUB 520-30.6520.590000 127.95 CITY OF WAUKEE JULY17652 07/31/2017 JULY'17 STATEMENT 520-30.6520.480000 1,248.05 Department 6520 - SANITARY SEWERS & TREATMENT Total: 95,242.55 Department: 6540 - GAS UTILITY CLAYTON ENERGY CORPORA 10174 08/11/2017 JULY'17 COMMODITY INVOI 540-30.6540.650000 72,689.75 MID STATES SUPPLY COMPA 1054733-01 07/11/2017 BLIND FLANGE/WELD CAP 540-30.6540.590000 491.83 INFRASOURCE CONSTRUCTI 3018179 07/28/2017 ALICES RD BIKE TUNNEL/MA 540-30.6540.880100 19,326.46 INFRASOURCE CONSTRUCT] 3018328 08/02/2017 NE BADGER LANE/NORTHVIE 540-30.6540.880100 12,457.66 INFRASOURCE CONSTRUCT] 3018499 08/10/2017 ALICES RD/NE BADGER LANE 540-30.6540.880100 6,444.27 INFOR PUBLIC SECTOR. INC. 37655-US06A 07/20/2017 INFOR CLOUDSUITE SUBSCRI 540-30.6540.740000 6,388.80 ENERGY ECONOMICS 41689 08/04/2017 UM TC COUNTER/ROOTS ME 540-30.6540.592000 1,904.81 HOLMES MURPHY 419502 08/O1/2017 AUG'17 HMA MONTHLY CO 540-30.6540.100000 15.92 HOLMES MURPHY 419502 08/O1/2017 AUG'17 HMA MONTHLY CO 540-30.6540.100000 181.88 HOLMES MURPHY 419502 08/O1/2017 AUG'17 HMA MONTHLY CO 540-30.6540.100000 22.73 PLUMB SUPPLY COMPANY 4684041 07/31/2017 PARTS 540-30.6540.590000 222.90 VANNGUARD UTILITY PARTN 6336 08/02/2017 WAUKEE LOCATING 540-30.6540.340000 1,207.50 A-TEC ENERGY 9555 07/31/2017 HOME FITNESS AUDITS 540-30.6540.685400 1,890.00 INDUSTRIALSALES COMPAN 976878-000 07/25/2017 METER BAR 540-30.6540.592000 12,660.00 INDUSTRIAL SALES COMPAN 984967-000 07/10/2017 TRANSITION FITTINGS 540-30.6540.590200 1,094.08 INDUSTRIALSALES COMPAN 986144-000 07/24/2017 PIPE COUPLINGS 540-30.6540.590200 474.61 FULLER PETROLEUM SERVIC 99651 07/28/2017 FUEL 540-30.6540.570000 188.13 UTILITY SAFETY AND DESIGN IN20172574 07/27/2017 JULY'17 RETAINER FEES 540-30.6540.230000 175.00 AMERITAS LIFE INSURANCE INV0003437 08/01/2017 AUG'17 VISION INSURANCE 540-30.6540.100000 13.62 AMERITAS LIFE INSURANCE INV0003437 08/01/2017 AUG'17 VISION INSURANCE 540-30.6540,100000 99.04 AMERITAS LIFE INSURANCE INV0003437 08/O1/2017 AUG'17 VISION INSURANCE 540-30.6540.100000 7.82 CONSOLIDATED COMMUNIC INV0003454 08/O8/2017 JULY'17 STATEMENT 540-30.6540.450000 72.64 8/17/2017 9:24:22 AM Page 7 of 14 Expense Approval Register Packet: APPKT00714 - AUGUST 22ND COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount ANNETTE ZARKOWSKI INV0003457 08/22/2017 FURNACE REBATE 540-30.6540.685400 150.00 HEARTLAND CO-OP INV0003467 07/31/2017 JULY'17 STATEMENT -GAS 540-30.6540.570000 537.75 WAUKEE HARDWARE & VARI INV0003473 07/31/2017 JULY'17 STATEMENT - PUB 540-30.6540.590000 56.11 MARTHA ERDAHL INV0003474 08/22/2017 FURNACE REBATE 540-30.6540.685400 75.00 ROBERTGRAZIANO INV0003475 08/22/2017 FURNACE REBATE 540-30.6540.685400 150.00 WENDI MADSEN INV0003476 08/22/2017 FURNACE REBATE 540-30.6540.685400 150.00 Department 6540 - GAS UTILITY Total: 139,148.31 Department: 6550 - UTILITY BILLING DES MOINES STAMP MFG C 1100597 08/07/2017 UTILITY BILLING STAMPS 570-30.6550.580000 235.30 METHODIST OCCUPATIONAL 227507 07/31/2017 DRUG SCREENS 570-30.6550.470000 48.00 HOLMES MURPHY 419502 08/01/2017 AUG'17 HMA MONTHLY CO 570-30.6550.100000 63.66 UNIVERSAL PRINTING SERVI 50293 08/11/2017 RETURN ENVELOPES - UTILIT 570-30.6550.350100 2,524.86 AMERITAS LIFE INSURANCE INV0003437 08/O1/2017 AUG'17 VISION INSURANCE 570-30.6550.100000 31.28 Department 6550 - UTILITY BILLING Total: 2,903.10 Department: 7100 - STREETS STAR EQUIPMENT LTD 01554441 07/24/2017 500# CLASS BRKER W/SKD L 060-30.7100.390000 1,800.00 STAR EQUIPMENT LTD 01554666 07/27/2017 500# CLASS BRKR W/SKD LO 060-30.7100.540000 4,771.00 MIKES ADEL POWER EQUIP 18912 08/10/2017 CHAIN LOOP 060-30.7100.590000 19.49 UNITYPOINT CLINIC-OCCUPA 207129 08/O2/2017 DRUG TESTS 060-30.7100.470000 37.00 MARTIN MARIETTA AGGREG 20906065 07/24/2017 1" PIPE BEDDING 060-30.7100.590300 713.62 MARTIN MARIETTA AGGREG 20931118 07/27/2017 ROAD STONE 060-30.7100.590300 390.04 MARTIN MARIETTA AGGREG 20966483 07/31/2017 ROAD STONE 060-30.7100.590300 614.14 MARTIN MARIETTA AGGREG 20966516 07/31/2017 ROAD STONE 060-30.7100,590300 986.71 METHODIST OCCUPATIONAL 227507 07/31/2017 DRUG SCREENS 060-30.7100.470000 22.00 BLUE RIDGE SOLUTIONS 234-26-17 07/26/2017 ASPHALT PATCH KIT 060-30.7100.590400 1,014.53 IOWA SIGNAL INC 3625 07/31/2017 LINE FUSE 060-30.7100,410300 96.53 INFOR PUBLIC SECTOR. INC. 37655-US06A 07/20/2017 INFOR CLOUDSUITE SUBSCRI 060-30.7100.740000 6,388.80 HOLMES MURPHY 419502 08/O1/2017 AUG'17 HMA MONTHLY CO 060-30.7100.100000 172.79 HOLMES MURPHY 419502 08/O1/2017 AUG'17 HMA MONTHLY CO 060-30.7100.100000 22.74 HOLMES MURPHY 419502 08/01/2017 AUG'17 HMA MONTHLY CO 060-30.7100.100000 4.55 MENARDS 89803 08/09/2017 NAIL/TIEDOWN/HEADLIGHT 060-30.7100.590000 32.71 LIBERTY READY MIX 89803 07/24/2017 CONCRETE 060-30.7100.590400 1,335.76 LIBERTY READY MIX 89886 07/25/2017 CONCRETE 060-30.7100.590400 550.38 LIBERTY READY MIX 89993 07/27/2017 CONCRETE 060-30.7100.590400 461.00 LIBERTY READY MIX 89994 07/27/2017 CONCRETE 060-30.7100.590400 1,295.00 LIBERTY READY MIX 90153 07/31/2017 CONCRETE 060-30.7100.590400 712.25 LIBERTY READY MIX 90238 08/01/2017 CONCRETE 060-30.7100.590400 461.00 LIBERTY READY MIX 90239 08/O1/2017 CONCRETE 060-30.7100.590400 1,489.25 LIBERTY READY MIX 90305 08/02/2017 CONCRETE 060-30.7100.590400 1,644.00 LIBERTY READY MIX 90348 08/03/2017 CONCRETE 060-30.7100.590400 1,036.00 LIBERTY READY MIX 90424 08/04/2017 CONCRETE 060-30.7100.590400 685.00 LIBERTY READY MIX 90518 08/07/2017 CONCRETE 060-30.7100.590400 1,370.00 LIBERTY READY MIX 90519 08/07/2017 CONCRETE 060-30.7100.590400 616.50 FULLER PETROLEUM SERVIC 99651 07/28/2017 FUEL 060-30,7100.570000 188.12 CAPITAL CITY EQUIPMENT C D19483CM O1/03/2017 CREDIT MEMO 18"BKT/PINS 060-30.7100.410100 -3,262.00 CAPITAL CITY EQUIPMENT C D19483DM O1/03/2017 DEBIT MEMO 18" BKT/PINS/ O60-30.7100.410100 3,262.00 CCP INDUSTRIES, INC. IN01899196 05/26/2017 GLOVES - 060-30.7100.590400 157.68 BARCO MUNICIPAL PRODUC IN-225846 08/08/2017 TRAFFIC CONES/BARRICADE O60-30.7100.590000 1,746.36 AMERITAS LIFE INSURANCE INV0003437 08/01/2017 AUG'17 VISION INSURANCE 060-30.7100.100000 1.07 AMERITAS LIFE INSURANCE INV0003437 08/01/2017 AUG'17 VISION INSURANCE 060-30.7100.100000 13.62 AMERITAS LIFE INSURANCE INV0003437 08/01/2017 AUG'17 VISION INSURANCE 060-30.7100.100000 103.08 VEENSTRA & KIMM INC INV0003438 07/28/2017 2017 ASPHALT OVERLAY PR 060-30.7100.230000 658.50 VEENSTRA & KIMM INC INV0003438 07/28/2017 2017 MAINTENANCE BOND 060-30.7100.230000 462.00 HEARTLAND CO-OP INV0003466 07/31/2017 JULY'17 STATEMENT-STREE O60-30.7100.570000 985.23 WAUKEE HARDWARE & VARI INV0003473 07/31/2017 JULY'17 STATEMENT- PUB 060-30.7100.590000 35.72 LOGAN CONTRACTORS SUPP M33193 08/03/2017 CONCRETE PATCH 060-30.7100.590400 1,804.46 LOGAN CONTRACTORS SUPP M34256 08/07/2017 CHUTE BAG/SNAP HANDLE/ 060-30.7100.590000 441.68 ZIEGLER INC PC501209932 08/04/2017 HOSES/PARTS 060-30.7100.590000 559.23 8/17/2017 9:24:22 AM - Page 8 of 14 Expense Approval Register Packet: APPKT00714 - AUGUST 22ND COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount LOUNSBURY LANDSCAPING T1978 07/31/2017 TOPSOIL 060-30.7100.410300 484.23 Department 7100 - STREETS Total: 36,383.77 Department: 7730 - SE W ESTOW N PKWY CONSTRUCTION SNYDER & ASSOCIATES INC 117.0234.0113-4 07/31/2017 SE WESTOWN PARKWAY EXT 327-90.7730.230000 17,389.29 Department 7730 - SE W ESTOW N PKWY CONSTRUCTION Total: 17,389.29 Department: 8200 - COMMUNICATIONS WAUKEE AERIAL, LLC 1061 08/01/2017 AERIAL VIDEO OF ALICE'S RD 010-60.8200.350110 100.00 LIVING MAGAZINES 366052 07/01/2017 WAUKEE LIVING NEWSLETTE 010-60.8200.461200 730.00 HOLMES MURPHY 419502 08/01/2017 AUG'17 HMA MONTHLY CO 010-60.8200.100000 45.47 AMERITAS LIFE INSURANCE INV0003437 08/01/2017 AUG'17 VISION INSURANCE 010-60.8200.100000 27.24 Department 8200 - COMMUNICATIONS Total: 902.71 Department: 8300 - ADMINISTRATION GATEHOUSE MEDIA IOWA H 0000205838 07/30/2017 JULY'17 PUBLICATIONS 010-60.8300,210000 1,291.54 CLASSIC FLORAL &GIFTS 198771 07/05/2017 FLOWERS -EVANS 010-60.8300.590000 32.00 HOLMES MURPHY 419502 08/01/2017 AUG'17 HMA MONTHLY CO 010-60.8300.100000 90.94 AMERITAS LIFE INSURANCE INV0003437 08/01/2017 AUG'17 VISION INSURANCE 010-60.8300.100000 47.84 CONSOLIDATED COMMUNIC INV0003449 08/01/2017 AUGUST'17 STATEMENT 010-60.8300.450000 793.00 DALLAS COUNTY RECORDER INV0003452 07/31/2017 JULY'17 STATEMENT 010-60.8300.230000 2,406.00 MEDIACOM INV0003453 07/28/2017 JULY'17 STATEMENT 010-60.8300.270000 147.85 CITY OF WAUKEE JULY1783ONV 07/31/2017 JULY'17 STATEMENT 010-60.8300.390400 101.48 IMAGETEK INC KJF3802577 07/31/2017 RADIX SUBSCRIPTION/STOR 010-60.8300.270000 587.00 - Department 8300 - ADMINISTRATION Total: 5,497.65 Department: 8310 - CITY HALL CRYSTAL CLEAR BOTTLED W 155149 08/11/2017 WATER 010-60.8310.590000- 15.50 ORKIN PEST CONTROL 162117363 08/21/2017 PEST CONTROL - CITY HALL 010-60.8310.400000 114.22 G&KSERVICES INC 6183746089 08/02/2017 MAT SERVICES - CITY HALL 010-60.8310.400000 36.00 NATIONWIDE OFFICE CLEAN 64072 07/26/2017 PAPERTOWELS 010-60.8310.590000 53.04 CONSOLIDATED COMMUNIC INV0003454 08/08/2017 JULY'17 STATEMENT 010-60.8310.450000 216.80 CONSOLIDATED COMMUNIC INV0003454 08/08/2017 AUGUST'17 STATEMENT 010-60.8310.450000 344.90 CITY OF WAUKEE JULY17831CAM 07/31/2017 JULY'17 STATEMENT 010-60,8310.390600 296.81 Department 8310 - CITY HALL Total: 1,077.27 Department: 8350 - HUMAN RESOURCES HOLMES MURPHY 419502 08/01/2017 AUG'17 HMA MONTHLY CO 010-60.8350.100000 18.19 AMERITAS LIFE INSURANCE INV0003437 08/01/2017 AUG'17 VISION INSURANCE 010-60.8350.100000 10.68 Department 8350 - HUMAN RESOURCES Total: 28.87 Department: 8400 - FINANCIAL ADMINISTRATION HOLMES MURPHY 419502 08/01/2017 AUG'17 HMA MONTHLY CO 010-60.8400.100000 109.13 AMERITAS LIFE INSURANCE INV0003437 08/01/2017 AUG'17 VISION INSURANCE 010-60.8400.100000 5&52 Department 8400 - FINANCIAL ADMINISTRATION Total: 167.65 Department: 8500- COMMUNITY DEVELOPMENT HOLMES MURPHY 419502 08/01/2017 AUG'17 HMA MONTHLY CO 010-50.8500.100000 90.94 AMERITAS LIFE INSURANCE INV0003437 08/01/2017 AUG'17 VISION INSURANCE 010-50,8500.100000 20.60 VEENSTRA & KIMM INC INV0003438 07/28/2017 HUGHES PROPERTY DEVELO 010-50.8500.230000 924.00 Department 8500- COMMUNITY DEVELOPMENT Total: 1,035.54 Department: 8600 - CITY ATTORNEY BRICK G ENTRY BOWERS SW 262307 07/25/2017 JULY'17 STATEMENT 010-60.8600.230000 16,280.00 Department 8600 - CITY ATTORNEY Total: 16,280.00 Department: 8700 - DEVELOPMENT SERVICES HOLMES MURPHY 419502 08/01/2017 AUG'17 HMA MONTHLY CO 010-50.8700.100000 109.13 AMERITAS LIFE INSURANCE INV0003437 08/01/2017 AUG'17 VISION INSURANCE 010-50.8700.100000 65.16 Department 8700 - DEVELOPMENT SERVICES Total: 174.29 Department: 8750-SUGAR CREEK MUNICIPAL ZIMCO SUPPLY CO 111443 07/19/2017 CHEMICALS 750-80.8750.590100 1,239.00 ZIMCO SUPPLY CO 111773 07/27/2017 FUNGICIDE 750-80.8750.590100 1,230.00 HEARTLAND TIRE &AUTO 123875 08/07/2017 TIRE PLUG/MOUNT 750-80.8750.410100 45.00 UNITYPOINT CLINIC-OCCUPA 207129 08/02/2017 DRUG TESTS 750-80.8750A70000 37.00 EPOCH EYEWEAR 21187 07/28/2017 EYEWEAR 750-80.9750.651000 84.00 8/17/2017 9:24:22 AM Page 9 of 14 Expense Approval Register Packet: APPKT00714 -AUGUST 22ND COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount ATLANTIC BOTTLING CO 218333 08/04/2017 POP 750-80.8750.650150 129.00 METHODIST OCCUPATIONAL 227507 07/31/2017 DRUG SCREENS 750-80.8750.470000 22.00 FOUR POINTS GOLF CARS 302607 07/24/2017 GOLF CART REPAIR 750-80.8750.410360 122.50 DIRECTV 32016519348 08/14/2017 JULU'17 STATEMENT - GOLF 750-80.8750.480000 48.75 PEPSI 32982705 08/07/2017 POP/WATER/GATORADE 750-80.8750.650150 1,190.18 PEPSI 34221860 07/24/2017 WATER/GATORADE 750-80.8750.650150 841.52 HOLMES MURPHY 419502 08/01/2017 AUG'17 HMA MONTHLY CO 750-80.8750.100000 31.83 PRESTIGE FLAG 438282 08/03/2017 REPLACE FLAG POLE 750-80.8750.590000 74.03 PLUMB SUPPLY COMPANY 4693651 07/31/2017 CEMENT/PRIMER/PIPE 750-80.8750.410350 51.28 G & K SERVICES INC 6183746088 08/02/2017 MATSERVICES 750-80.8750.400000 61.05 CINTAS CORPORATION 762537586 07/28/2017 URINAL MAT/SOAP/PAPERT 750-80.8750.400000 126.33 AMERITAS LIFE INSURANCE INV0003437 08/01/2017 AUG'17 VISION INSURANCE 750-80.8750.100000 7.48 WAUKEE HARDWARE & VARI INV0003443 07/31/2017 JULY'17 STATEMENT 750-80.8750.400000 77.97 HEARTLAND CO-OP INV0003447 07/31/2017 JULY'17 STATEMENT - GOLF 750-80.8750.570000 1,739.12 CITY OF WAUKEE JULY178750 07/31/2017 JULY'17 STATEMENT 750-80.8750.480000 308.38 Department 8750 - SUGAR CREEK MUNICIPAL Total: 7,466.32 Department: 8800 - INFORMATION TECHNOLOGY AMAZON.COM LLC 1XWK-1W94-FGM7 08/10/2017 STORAGE CABINET 010-60.8800.540000 80.19 HOLMES MURPHY 419502 08/01/2017 AUG'17 HMA_ MONTHLY CO 010-60.8800.100000 45.47 Department 8800 - INFORMATION TECHNOLOGY Total: 225.66 Department: 8900 - ENGINEERING CHRISTIAN PRINTERS INC 38355 08/02/2017 BUSINE55 CARDS- R. KOESTE 010-20.8900.350100 31.00 HOLMES MURPHY 419502 08/01/2017 AUG'17 HMA MONTHLY CO 010-20.8900.100000 127.32 AMERITAS LIFE INSURANCE INV0003437 08/01/2017 AUG'17 VISION INSURANCE 010-20.8900.100000 75.84 VEENSTRA & KIMM INC INV0003438 07/28/2017 DEVELOPER FEES 010-20.8900.231200 2,977.17 HEARTLAND CO-OP INV0003462 07/31/2017 JULY'17 STATEMENT -ENGI 010-20.8900.570000 874.21 Department 8900- ENGINEERING Total: 4,085.54 Department: 9950 - GIS HOLMES MURPHY 419502 08/01/2017 AUG'17 HMA MONTHLY CO 010-20.8950.100000 18.19 AMERITAS LIFE INSURANCE INV0003437 08/01/2017 AUG'17 VISION INSURANCE 010-20.8950.100000 10.68 H EARTLAND CO-OP INV0003463 07/31/2017 JULY'17 STATEMENT-GIS010-20.8950.570000 71.60 Department 8950 -GIS Total: 100.47 Grand Total: 809,436.78 8/17/2017 9:24:22 AM Page 10 of 14 Expense Approval Register Packet: APPKT00714 - AUGUST 22ND COUNCIL PACKET Fund Summary Fund O10-GENERAL FUND 060 - ROAD USE TAX 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-10.1100.100000 010-10.1100.120000 010-10.1100.210000 010-10.1100.230000 010-10.1100.400000 010-10.1100.410000 010-10.1100.410100 010-10.1100.450000 010-10.1100.470010 010-10.1100.480000 010-10.1100.540000 010-10.1100.560000 010-10.1100.590000 010-10.1400.100000 010-10.1400.120000 010-10.1400.360000 010-10.1400.400000 010-10.1400.410000 010-10.1400.410100 010-10.1400.450000 010-10.1400,470000 010-10.1400.480000 010-10.1400.540000 010-10.1400.570000 010-10.1400.590000 010-10.1500.100000 010-10.1500.120000 010-10.1500.231800 010-10.1500.360000 010-10.1500.400000 010-10.1500.410000 010-10.1500.450000 010-10.1500.470000 010-10.1500.480000 010-10.1500.540000 010-10.1500.570000 010-10.1500.590000 010-10.1500.590050 010-10.1900.100000 010-10.2400.340000 010-20.6000.100000 010-20.6000.120000 010-20.6000.470000 010-20.6000.570000 010-20.6010.400000 Grand Total: Account Summary Account Name HEALTH & LIFE INSURAN UNIFORMS PUBLIC NOTIFICATION/A CONSULTANT & PROFES REPAIR/MAINTENANCE REPAIR OF VEHICLES REPAIR/MAINTENANCE TELEPHONE AMMUNITION UTILITY SERVICES MINOR EQUIPMENT MOTOR VEHICLE MAINT OPERATING SUPPLIES & HEALTH & LIFE INSURAN UNIFORMS POSTAGE & SHIPPING REPAIR/MAINTENANCE REPAIR OF VEHICLES REPAIR/MAINTENANCE TELEPHONE TRAINING/TRAVEL EXPE UTILITY SERVICES MINOR EQUIPMENT FUEL OPERATING SUPPLIES & HEALTH & LIFE INSURAN UNIFORMS AMBULANCE BILLING FIE POSTAGE & SHIPPING REPAIR/MAINTENANCE REPAIR OF VEHICLES TELEPHONE TRAINING/TRAVEL EXPE UTILITY SERVICES MINOR EQUIPMENT FUEL OPERATING SUPPLIES & MEDICAL SUPPLIES HEALTH & LIFE INSURAN MISCELLANEOUS CONTR HEALTH & LIFE INSURAN UNIFORMS TRAINING/TRAVEL EXPE FUEL REPAIR/MAINTENANCE Expense Amount 90,874.29 36,383.77 93,938.83 232,377.22 97,909.66 140,122.78 14,675.19 2,903.10 89,551.60 10,700.34 809,436.78 Expense Amount 1,352.02 225.97 38.20 1,082.57 3,461.27 21271.82 454.40 727.07 1,308.00 193.02 1,097.58 200.00 38.15 338.31 90.39 69.54 72.68 285.19 770.98 94.95 659.50 127.93 2,500.10 480.42 312.75 338.29 90.40 1,507.75 69.54 72.67 501.25 94.95 379.50 127.93 308.98 480.42 126.71 848.87 203.16 540.00 284.20 285.35 48.00 176.16 2,424.30 8/17/2017 9:24:22 AM Page 11 of 14 Expense Approval Register Packet: APPKT00714 -AUGUST 22ND COUNCIL PACKET Account Summary Account Number Account Name Expense Amount 010-20.6010.450000 TELEPHONE 809.09 010-20.6010.480000 UTILITY SERVICES 942.33 010-20.6010.580000 OFFICE SUPPLIES 189,49 010-20.6010.590000 OPERATING SUPPLIES & 942.47 010-20.6150.100000 HEALTH & LIFE INSURAN 101.58 010-20.6150.570000 FUEL 211.71 010-20.6150.570110 COGS - FILTERS 49.19 010-20.6150.570130 COGS - PARTS 2,797.83 010-20.6150.590000 OPERATING SUPPLIES& 298.76 010-20.8900,100000 HEALTH & LIFE INSURAN 203.16 010-20.8900.231200 DEVELOPERS ENGINEERI 2,977.17 010-20.8900.350100 PRINTING 31.00 010-20.8900.570000 FUEL 874.21 010-20.8950.100000 HEALTH & LIFE INSURAN 28.87 010-20.8950.570000 FUEL 71.60 010-2030500 SALES TAX COLLECTED P 105.60 010-40.3100.100000 HEALTH & LIFE INSURAN 401.37 010-40.3100.270000 DATA PROCESSING 961.00 010-40.3100.400000 REPAIR/MAINTENANCE 969.81 010-40.3100.400100 CUSTODIAL SERVICES - 38.00 010-40.3100.450000 TELEPHONE 207.19 010-40.3100.480000 UTILITYSERVICES 5,150.39 010-40.3100.540000 MINOR EQUIPMENT 378.00 010-40.3100.590000 OPERATING SUPPLIES& 1,449.76 010-40.3100.640000 LIBRARY BOOKS/FILMS/ 645.10 010-40.3100.880000 FACILITIES 1,003.61 010-40.4100.100000 HEALTH & LIFE INSURAN 112.81 010-40.4100.120000 UNIFORMS 49.49 010-40.4100.410300 REPAIR/MAINTENANCE 2,976.54 010-40.4100.450000 TELEPHONE 14.65 010-40.4100.470000 TRAINING/TRAVEL EXPE 59.00 010-40.4100.480000 UTILITY SERVICES 961.51 010-40.4100.480100 UTILITIES -PARK IRRIGATI 2,658.51 010-40.4100.570000 FUEL 728.68 010-40.4100.590000 OPERATING SUPPLIES& 9.78 010-40.4100.590100 CHEMICAL/FERTILIZER 739.75 010-40.4200.100000 HEALTH & LIFE INSURAN 174.29 010-40.4200.350100 PRINTING 110.00 010-40.4200.460050 OFFICIALS - 960.00 010-40.4200.460500 SUMMER RECREATION P 2,120.51 010-40.4200.460800 JULY 4TH CELEBRATION 800.16 010-40.4200.540000 MINOR EQUIPMENT 376.60 010-40.4200.570000 FUEL 228.15 010-40.4300.400000 REPAIR/MAINTENANCE 63.00 O10-40.4300A80000 LJTILITYSERVICES 389.69 010-50.6500.340000 MISCELLANEOUS CONTR 3,052.00 010-50.8500.100000 HEALTH & LIFE INSURAN 111.54 010-50.8500.230000 CONSULTANT & PROFES 924.00 010-50.8700.100000 HEALTH & LIFE INSURAN 174.29 010-60.8200.100000 HEALTH & LIFE INSURAN 72.71 010-60.8200.350110 PHOTOGRAPHY & VIDEO 100.00 010-60,8200.461200 NEWSLETTER 730.00 010-60.8300.100000 HEALTH & LIFE INSURAN 138.78 010-60.8300.210000 PUBLIC NOTIFICATION/A 1,291.54 010-60.8300.230000 CONSULTANT & PROFES 2,406.00 010-60.8300.270000 DATA PROCESSING 734.85 010-60.8300.390400 NORTHVIEW RENTAL PR 101.48 010-60.8300.450000 TELEPHONE 793.00 8/17/2017 9:24:22 AM Page 12 of 14 Expense Approval Register Packet: APPKT00724 - AUGUST 22ND COUNCIL PACKET Account Summary Account Number Account Name Expense Amount 010-60.8300.590000 OPERATING SUPPLIES & 32.00 010-60.8310.390600 PROF PLAZA CAM EXPEN 296.81 010-60.8310.400000 REPAIR/MAINTENANCE 150.22 010-60,8310.450000 TELEPHONE 561.70 010-60.8310.590000 OPERATING SUPPLIES & 68.54 010-60.8350.100000 HEALTH & LIFE INSURAN 28.87 010-60.8400.100000 HEALTH & LIFE INSURAN 167.65 010-60.8600.230000 CONSULTANT&PROFES 16,280.00 010-60.8800.100000 HEALTH & LIFE INSURAN 45.47 010-60.8800.540000 MINOR EQUIPMENT 80.19 060-30.7100.100000 HEALTH & LIFE INSURAN 317.85 060-30.7100.230000 CONSULTANT & PROFES 1,120.50 060-30.7100.390000 RENTAL/LEASE OF EQUI 1,800.00 060-30.7100.410100 REPAIR/MAINTENANCE 0.00 060-30.7100.410300 REPAIR/MAINTENANCE 580.76 060-30.7100.470000 TRAINING/TRAVEL EXPE 59.00 060-30.7100.540000 MINOR EQUIPMENT 4,771.00 060-30.7100.570000 FUEL 1,173.35 060-30.7100.590000 - OPERATING SUPPLIES & 2,835.19 060-30.7100.590300 ROADSTONE 2,704.51 060-30.7100.590400 ROAD REPAIR -PATCH 14,632.81 060-30.7100.740000 OFFICE EQUIPMENT 6,388.80 327-90.2130.230051 CONSULTING- ESKER RD 889.33 327-90.2130.840490 ALICES RD -UNIV TO OL 40,122.49 327-90.2131.230051 CONSULTING -ESKER RID 12,639.44 327-90.5000.881130 RRVT TRAILHEAD ART I 1,418.49 327-90.5011.230000 CONSULTANT&PROFES 21,406.00 327-90.5750.881420 LITTLE WALNUT CRK DR 73.79 327-90.7730.230000 CONSULTANT&PROFES 17,389.29 510-2030500 SALES TAX COLLECTED P 35,010.51 510-30.6510.100000 HEALTH & LIFE INSURAN 224.42 510-30.6510.230000 CONSULTANT&PROFES 23,495.72 510-30.6510.340000 MISCELLANEOUS CONTR 1,207.50 510-30.6510.410400 REPAIR/MAINT OF DELIV 111.47 510-30.6510.410500 REPAIR/MAINTENANCE 119.33 510-30.6510.470000 TRAININGITRAVEL EXPE 485.00 510-30.6510.480000 UTILITY SERVICES 752.65 510-30.6510.570000 FUEL 890.15 530-30.6530.590000 OPERATING SUPPLIES & 972.45 510-30.6510.592000 METER PURCHASE 13,521.46 510-30.6510.650000 COST OF GOODS SOLD 148,226.50 510-30.6510.740000 OFFICE EQUIPMENT 6,388.80 510-30.6510.881200 WATERTOWER REHAB 971.26 520-2030500 SALESTAX COLLECTED P 2,667.11 520-30.6520.100000 HEALTH & LIFE INSURAN 290.49 520-30.6520.210000 PUBLIC NOTIFICATION/A 32.57 520-30.6520.230000 CONSULTANT & PROFES 3,521.50 520-30.6520.280000 DUES, MEMBERSHIPS & 1,275.00 520-30.6520.411100 REPAIR/MAINTENANCE 2,818.97 520-30.6520.450000 TELEPHONE 145.27 520-30.6520.470000 TRAINING/TRAVEL EXPE 45.00 520-30.6520.480000 UTILITY SERVICES 1,248.05 520-30.6520.570000 FUEL 863.67 520-30.6520.590000 OPERATING SUPPLIES & 979.32 520-30.6520.740000 OFFICE EQUIPMENT 6,388.80 520-30.6520.880050 I & I PROGRAM 28.73 520-30.6520.883000 OUTFALL CONNECTION 35,636.35 520-30.6520.883060 LITTLE WALNUT CREEK S 23,354.37 8/17/2017 9:24:22 AM Page 13 of 14 Expense Approval Register Packet: APPKT00714 - AUGUST 22ND COUNCIL PACKET Account Summary Account Number Account Name Expense Amount 520-30.6520.883080 FOX CREEK SEWER 13,355.75 520-30.6520.883091 NW AREA TRUNK SEWE 4,412.54 520-30.6520.883092 SW TRUNK SEWER - 846.17 540-2030500 SALES TAX COLLECTED P 974.47 540-30.6540.100000 HEALTH & LIFE INSURAN 341.01 540-30.6540.230000 CONSULTANT&PROFES 175.00 540-30.6540.340000 MISCELLANEOUS CONTR 1,207.50 540-30.6540.450000 TELEPHONE 72.64 540-30.6540.570000 FUEL 725.88 540-30.6540.590000 OPERATING SUPPLIES & 770.84 540-30.6540.590200 INSTALLATION MATERIA 1,568.69 540-30.6540.592000 METER PURCHASE 14,564.81 540-30.6540.650000 COST OF GOODS SOLD 72,689.75 540-30.6540.685400 GAS REBATE 2,415.00 540-30.6540.740000 OFFICE EQUIPMENT 6,388.80 540-30.6540.880100 DISTRIBUTION SYSTEM 1 38,228.39 560-2030500 SALES TAX COLLECTED P 1,216.58 560-80.5300.100000 HEALTH & LIFE INSURAN 198.03 560-80.5300.230000 - CONSULTANTS& PROFES 858.77 560-80.5300.340000 MISCELLANEOUS CONTR 1,207.50 560-80.5300.410300 REPAIR/MAINTENANCE 4,410.00 560-90.5300.470000 TRAINING/TRAVEL EXPE 48.00 560-80.5300.570000 FUEL 347.51 560-80.5300.740000 OFFICE EQUIPMENT 6,388.80 570-30.6550.100000 HEALTH & LIFE INSURAN 94.94 570-30.6550.350100 PRINTING 2,524.86 570-30.6550.470000 TRAINING/TRAVEL EXPE 48.00 570-30.6550.590000 OFFICE SUPPLIES 235.30 590-30.5400.231300 RESIDENTIAL SOLID WAS 89,551.60 750-2030500 SALES TAX COLLECTED P 3,234.02 750-80.8750.100000 HEALTH & LIFE INSURAN 39.31 750-80.8750.400000 REPAIR/MAINTENANCE 265.25 750-80.8750.410100 REPAIR/MAINTENANCE 45.00 750-80.8750.410350 REPAIR/MAINTENANCE1 -51.28 750-80.8750.410360 REPAIR/MAINTENANCE 122.50 750-80.8750.470000 TRAINING/TRAVEL EXPE 59.00 750-80.8750.480000 UTILITY SERVICES 357.13 750-80.8750.570000 FUEL 1,739.12 750-80.8750.590000 OPERATING SUPPLIES & '74.03 750-80.8750.590100 CHEMICAL/FERTILIZER 2,469.00 750-80.8750.650150 COGS-POP/WATER 2,160.70 750-80.8750.651000 PRO SHOP MERCHANDIS 84.00 Grand Total: 809,436.78 Project Account Summary Project Account Key Expense Amount **None** 809,436.78 Grand Total: 809,436.78 8/17/2017 9:24:22 AM Page 14 of 14 s 00 City of Waukee, IA u%oukee My Check Report By Check Number Date Range: 08/03/2017 - 08/07/2017 Vendor Number Vendor Name Payment Date Payment Type Discount Amount PaymentAmount Number Bank Code: AP-WAUKEE STATE 047290 DOLL DISTRIBUTING, LLC 08/04/2017 Regular 0.00 371.80 129932 Payable # Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0003417 Invoice 08/04/2017 BEER DELIVERY 0.00 371.80 750-80.8750.650100 COGS-BEER/ALCOHOL BEER DELIVERY 371.80 103450 JETHRO'S BBQ 08/04/2017 Regular 0.00 558.10 129933 Payable # Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0003416 Invoice 08/04/2017 COUPLE'S LEAGUE CATERING 0.00 558.10 750-80.8750.650300 COGS -CATERING COUPLE'S LEAGUE CATERING 558.10 103950 11MMYJOHN'S 08/04/2017 Regular 0.00 104.00 129934 Payable# Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0003415 Invoice 08/04/2017 COUPLE'S LEAGUE CATERING 0.00 104.00 750-80.8750.650300 COGS -CATERING COUPLE'S LEAGUE CATERING 104.00 199023 SUGAR CREEK GOLF COURSE 08/04/2017 Regular 0.00 240.00 129935 Payable# Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0003414 Invoice 08/04/2017 COUPLE'S LEAGUE PRIZES 0.00 240.00 750-80.8750.653000 LEAGUE PRIZES/EXPENSE COUPLE'S LEAGUE PRIZES 240.00 199023 SUGAR CREEK GOLF COURSE 08/07/2017 Regular 0.00 2,096.00 129938 Payable# Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0003423 Invoice 08/07/2017 LEAGUE PRIZES 0.00 2,096.00 750-80.8750.653000 LEAGUE PRIZES/EXPENSE LEAGUE PRIZES 2,096.00 203200 THE KEE 08/07/2017 Regular 0.00 1,820.00 129939 Payable# Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0003424 Invoice 08/07/2017 END OF YEAR LEAGUE CATERING 0.00 1,820.00 750-80.8750.650300 COGS -CATERING END OF YEAR LEAGUE CATERIN 1,820.00 Bank Code AP Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 6 6 0.00 5,189.90 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 6 6 0.00 5,189.90 8/16/2017 4:35:36 PM Page 1 of 2 My Check Report Date Range: 08/03/2017 - 08/07/2017 Fund Summary Fund Name Period Amount 999 POOLED CASH 8/2017 5,189.90 5,189.90 8/16/2017 4:35:36 PM Page 2 of 2 0 VAX*ee City of Waukee, IA Vendor Number Vendor Name Payment Date Payment Type Bank Code: AP-WAUKEE STATE 047290 DOLL DISTRIBUTING, LLC 08/10/2017 Regular Payable # Payable Type Payable Date Payable Description Account Number Account Name Item Description INVOOD3440 Invoice 08/10/2017 BEER DELIVERY 750-80.8750.650100 COGS-BEER/ALCOHOL BEER DELIVERY 103450 Payable # INV0003441 130440 Payable # INV0003439 199023 Payable # INV0003442 199023 Payable # INV0003448 011475 Payable # 21049870 094675 Payable # INV0003458 199023 Payable # INV0003459 053275 My Check Report By Check Number Date Range:08/09/2017-08/16/2017 DiscountAmount PaymentAmoUnt Number 0.00 556.40 130143 DiscountAmount Payable Amount Distribution Amount 0.00 556.40 556.40 JETHRO'S BBQ 08/10/2017 Regular 0.00 154.25 130144 Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount Invoice 08/10/2017 WAUKEE CITY TOURNAMENT CATERING 0.00 154.25 750-80.8750.650300 COGS -CATERING WAUKEE CITY TOURNAMENT C 154.25 M & R HOLDINGS, LLC 08/10/2017 Regular 0.00 15,000.00 130145 Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount Invoice 08/10/2017 DEP-REFUND BRANDON'S RESERVE 0.00 15,000.00 010-2035000 DEVELOPER DEPOSIT PAY DEP-REFUND BRANDON'S RESE 15,000,00 SUGAR CREEK GOLF COURSE 08/10/2017 Regular 0.00 780.00 130146 Payable Type Payable Date Payable Description DiscountAmount PayableAmount Account Number Account Name Item Description Distribution Amount Invoice 08/10/2017 TEE GIFTS 0.00 780.00 750-80.8750.653200 TOURNAMENT PRIZES/SU GIFT CERTIFICATES/BALLS 780.00 SUGAR CREEK GOLF COURSE 08/14/2017 Regular 0.00 96.00 130147 Payable Type Payable Date Payable Description DiscountAmount PayableAmount Account Number Account Name Item Description Distribution Amount Invoice 08/14/2017 LEAGUE PRIZES 0.00 96.00 750-80.8750.653000 LEAGUE PRIZES/EXPENSE LEAGUE PRIZES 96.00 ACCESS SYSTEMS LEASING 08/15/2017 Regular 0.00 152.54 130148 Payable Type Payable Date Payable Description DiscountAmount Payable Amount Account Number Account Name Item Description Distribution Amount Invoice 07/27/2017 COPIER/PRINTER LEASE 0.00 152.54 010-60.8350.270110 COPIER / PRINTER LEASE COPIER/PRINTER LEASE 152.54 IOWA BEVERAGE SYSTEMS INC 08/15/2017 Regular 0.00 803.85 130149 Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount Invoice 08/15/2017 BEER DELIVERY 0.00 803.85 750-80.8750.650100 COGS-BEER/ALCOHOL BEER DELIVERY 803.85 SUGAR CREEK GOLF COURSE 08/15/2017 Regular 0.00 100.00 130150 Payable Type Payable Date Payable Description DiscountAmount PayableAmount Account Number Account Name Item Description Distribution Amount Invoice 08/15/2017 LEAGUE PRIZES 0.00 100.00 750-80.8750.653000 LEAGUE PRIZES/EXPENSE LEAGUE PRIZES 100.00 ELDER CORPORATION 08/15/2017 Regular 0.00 368,527.61 130151 8/16/2017 4:36:45 PM Page 1 of 3 My Check Report Date Range: 08/09/2017 - 08/16/2017 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 INV0003460 Invoice 08/15/2017 PAY EST#1-KETTLESTONE GREENWAY I M 0.00 368,527.61 327-90.2130.840470 ALICES RD-ENHANCE ASH PAY EST#1-KETTLESTON E GREE 368,527.61 Bank Code AP Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 9 9 0.00 386,170.65 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 9 9 0.00 386,170.65 8/16/2017 4:36:45 PM Page 2 of 3 My Check Report Date Range: 08/09/2017 - 08/16/2017 Fund Summary Fund Name Period Amount 999 POOLED CASH 8/2017 386,170.65 386,170.65 8/16/2017 4'.36:45 PM Page 3 of 3 t/ 0 VaLA(2e City of Waukee, IA Vendor Number Vendor Name Bank Code: AP-WAUKEE STATE Council Payroll Reimbursements By Check Number Date Range: 08/02/2017- 08/15/2017 Payment Date Payment Type DlscountAmount PaymentAmount Number 099999 EFTPS 08/07/2017 Regular 0.00 9.18 129937 Payable # Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0003421 Invoice 08/07/2017 FICA TAX WITH HOLDING 0.00 7.44 750-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 7.44 INV0003422 Invoice 08/07/2017 MEDICARE TAX WITHHOLDING 0.00 1.74 750-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 1.74 091000 ICMA RETIREMENT TRUST 457 08/08/2017 Regular 0.00 14,441.79 130031 Payable# Payable Type Payable Date Payable Description DiscountAmount Payable Amount Account Number Account Name Item Description Distribution Amount INV0003292 Invoice 07/15/2017 ICMA 401A 0.00 2,520.00 010-2011200 IPERS WITHHOLDING PAY ICMA 401A 2,520.00 INV0003293 Invoice 07/15/2017 ICMA ROTH CONTRIBUTION 0.00 1,432.16 010-2011200 IPERS WITHHOLDING PAY ICMA ROTH CONTRIBUTION 1,212.16 060-2011200 IPERS WITHHOLDING PAY ICMA ROTH CONTRIBUTION 50.00 540-2011200 IPERS WITHHOLDING PAY ICMA ROTH CONTRIBUTION 170.00 INV0003294 Invoice 07/15/2017 ICMA RETIREMENT 0.00 2,285.79 010-2011200 IPERS WITHHOLDING PAY ICMA RETIREMENT 2,160.79 060-2011200 IPERS WITHHOLDING PAY ICMA RETIREMENT 25.00 540-2011200 IPERS WITHHOLDING PAY ICMA RETIREMENT 50.00 570-2011200 IPERS WITHHOLDING PAY ICMA RETIREMENT 50.00 INV0003295 Invoice 07/15/2017 ICMA 0.00 920.84 010-2011200 IPERS WITHHOLDING PAY ICMA 860.32 510-2011200 IPERS WITHHOLDING PAY ICMA 15.58 520-2011200 IPERS WITHHOLDING PAY ICMA 15.14 540-2011200 IPERS WITHHOLDING PAY ICMA 15.57 560-2011200 IPERS WITHHOLDING PAY ICMA 14.23 INV0003378 Invoice 07/31/2017 ICMA 401A 0.00 2,520.00 010-2011200 IPERS WITHHOLDING PAY ICMA 401A 2,520.00 INV0003379 Invoice 07/31/2017 ICMA ROTH CONTRIBUTION 0.00 1,432.16 010-2011200 IPERS WITHHOLDING PAY ICMA ROTH CONTRIBUTION 1,212.16 060-2011200 IPERS WITHHOLDING PAY ICMA ROTH CONTRIBUTION 50.00 540-2011200 IPERS WITHHOLDING PAY ICMA ROTH CONTRIBUTION 170.00 INV0003380 Invoice 07/31/2017 ICMA RETIREMENT 0.00 2,285.79 010-2011200 IPERS WITHHOLDING PAY ICMA RETIREMENT 2,160.79 060-2011200 IPERS WITHHOLDING PAY ICMA RETIREMENT 25.00 540-2011200 IPERS WITHHOLDING PAY ICMA RETIREMENT 50.00 570-2011200 IPERS WITHHOLDING PAY ICMA RETIREMENT 50.00 INV0003381 Invoice 07/31/2017 ICMA 0.00 1,045.05 010-2011200 IPERS WITHHOLDING PAY ICMA 978.17 510-2011200 IPERS WITHHOLDING PAY ICMA 16.72 520-2011200 IPERS WITHHOLDING PAY ICMA 16.72 540-2011200 IPERS WITHHOLDING PAY ICMA 16.72 560-2011200 IPERS WITHHOLDING PAY ICMA 16.72 098900 IPERS 08/08/2017 Regular 0.00 101,986.15 130048 8/15/2017 4:28:43 PM Page 1 of 4 Council Payroll Reimbursements Vendor Number Vendor Name Payable# Payable Type Account Number INV0003310 Invoice 010-2011200 060-2011200 510-2011200 520-2011200 540-2011200 560-2011200 570-2011200 750-2011200 INV0003311 INV0003312 INV0003334 INV0003397 INV0003398 INV0003407 208650 Payable # INV0003313 INV0003335 INV0003399 232780 Invoice 010-2011200 Invoice 010-2011200 Invoice 010-2011200 Invoice 010-2011200 060-2011200 510-2011200 520-2011200 540-2011200 560-2011200 570-2011200 750-2011200 Invoice 010-2011200 Invoice 010-60.8400.080000 Payment Date Payment Type Payable Date Payable Description Account Name Item Description 07/15/2017 IPERS DEDUCTIONS IPERS WITHHOLDING PAY IPERS DEDUCTIONS IPERS WITHHOLDING PAY IPERS DEDUCTIONS IPERS WITHHOLDING PAY IPERS DEDUCTIONS IPERS WITHHOLDING PAY IPERS DEDUCTIONS IPERS WITHHOLDING PAY IPERS DEDUCTIONS IPERS WITHHOLDING PAY IPERS DEDUCTIONS IPERS WITHHOLDING PAY IPERS DEDUCTIONS IPERS WITHHOLDING PAY IPERS DEDUCTIONS 07/15/2017 IPERS DEDUCTIONS IPERS WITHHOLDING PAY IPERS DEDUCTIONS Date Range: 08/02/2017 - 08/15/2017 DiscountAmount Payment Amount Number DiscountAmount PayableAmount Distribution Amount 0.00 31,716.17 20,765.21 1,971.91 1,584.84 1,938.82 2,212.14 1,203.03 698.10 1,342.12 07/15/2017 IPERS ELECTED OFFICIAL DEDUCT IPERS WITHHOLDING PAY IPERS ELECTED OFFICIAL DEDUC 07/15/2017 IPERS DEDUCTIONS IPERS WITHHOLDING PAY IPERS DEDUCTIONS 07/31/2017 IPERS DEDUCTIONS IPERS WITHHOLDING PAY IPERS DEDUCTIONS IPERS WITHHOLDING PAY IPERS DEDUCTIONS IPERS WITHHOLDING PAY IPERS DEDUCTIONS IPERS WITHHOLDING PAY IPERS DEDUCTIONS IPERS WITHHOLDING PAY IPERS DEDUCTIONS IPERS WITHHOLDING PAY IPERS DEDUCTIONS IPERS WITHHOLDING PAY IPERS DEDUCTIONS IPERS WITHHOLDING PAY IPERS DEDUCTIONS 07/31/2017 IPERS DEDUCTIONS IPERS WITHHOLDING PAY IPERS DEDUCTIONS 07/31/2017 JUL'17 ROUNDING ADJUSTMENT IPERS CONTRIBUTION JUL'17 ROUNDING ADJUSTMEN 0.00 18,071.38 18,071.38 0.00 212.04 212.04 0.00 38.25 38.25 0.00 33,534.82 21,720.80 2,250.64 1,696.57 2,112.64 2,378.27 1,316.41 703.41 1,356.08 0.00 18,413.48 18,413.48 0.00 0.01 0.01 TREASURER STATE OF IOWA 08/08/2017 Regular 0.00 31,284.93 130119 Payable Type Payable Date Payable Description DiscountAmount Payable Amount Account Number Account Name Item Description Distribution Amount Invoice 07/15/2017 STATE WITHHOLDING TAXES 0.00 15,156.46 010-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 11,848.82 060-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 692.10 510-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 470.93 520-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 576.36 540-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 708.99 560-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 359.14 570-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 222.89 750-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 277.23 Invoice 07/15/2017 STATE WITHHOLDING TAXES 0.00 1.28 010-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 1.28 Invoice 07/31/2017 STATE WITHHOLDING TAXES 0.00 16,127.19 010-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 12,467.94 060-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 808.10 510-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 532.30 520-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 660.87 540-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 744.80 560-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 412.33 570-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 222.91 750-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 277.94 WAUKEE FIREFIGHTER'S ASSOCIATION 08/08/2017 Regular 0.00 78.68 130132 8/15/2017 4:28:43 PM Page 2 of 4 Council Payroll Reimbursements C/ Date Range: 08/02/2017 - 08/15/2017 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 INV0003303 Invoice 07/15/2017 FIREFIGHTER'S ASSOCIATION PAYROLL CO om 39.34 010-2030000 PAYROLL PAYABLES FIREFIGHTER'S ASSOCIATION PA 28.30 510-2030000 PAYROLL PAYABLES FIREFIGHTER'S ASSOCIATION PA 6.05 520-2030000 PAYROLL PAYABLES FIREFIGHTER'S ASSOCIATION PA 4.99 INV0003390 Invoice 07/31/2017 FIREFIGHTER'S ASSOCIATION PAYROLL CO 0.00 39.34 010-2030000 PAYROLL PAYABLES FIREFIGHTER'S ASSOCIATION PA 28.30 510-2030000 PAYROLL PAYABLES FIREFIGHTER'S ASSOCIATION PA 6.05 520-2030000 PAYROLL PAYABLES FIREFIGHTER'S ASSOCIATION PA 4.99 256601 YMCA OF GREATER DES MOINES O8/08/2017 Regular 0.00 1,396.00 130135 Payable# Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0003297 Invoice 07/15/2017 YMCA FAMILY MEMBERSHIP DEDUCTION 0.00 578.00 010-2030000 PAYROLL PAYABLES YMCA FAMILY MEMBERSHIP DE 476.00 510-2030000 PAYROLL PAYABLES YMCA FAMILY MEMBERSHIP DE 17.06 520-2030000 PAYROLL PAYABLES YMCA FAMILY MEMBERSHIP DE 16.94 540-2030000 PAYROLL PAYABLES YMCA FAMILY MEMBERSHIP DE 34.00 560-2030000 PAYROLL PAYABLES YMCA FAMILY MEMBERSHIP DE 34.00 INV0003300 Invoice 07/15/2017 YMCA SINGLE MEMBERSHIP DEDUCTION 0.00 120.00 010-2030000 PAYROLL PAYABLES YMCA SINGLE MEMBERSHIP DE 120.00 INV0003383 Invoice 07/31/2017 YMCA FAMILY MEMBERSHIP DEDUCTION 0.00 578.00 010-2030000 PAYROLL PAYABLES YMCA FAMILY MEMBERSHIP DE 476.00 510-2030000 PAYROLL PAYABLES YMCA FAMILY MEMBERSHIP DE 17.05 520-2030000 PAYROLL PAYABLES YMCA FAMILY MEMBERSHIP DE 16.95 540-2030000 PAYROLL PAYABLES YMCA FAMILY MEMBERSHIP DE 34.00 560-2030000 PAYROLL PAYABLES YMCA FAMILY MEMBERSHIP DE 34.00 INV0003387 Invoice 07/31/2017 YMCA SINGLE MEMBERSHIP DEDUCTION 0.00 120.00 010-2030000 PAYROLL PAYABLES YMCA SINGLE MEMBERSHIP DE 120.00 Bank Code AP Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 26 6 0.00 149,196.73 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 26 6 0.00 149,196.73 8/15/2017 4:28:43 PM Page 3 of 4 Council Payroll Reimbursements cv Date Range: 08/02/2017 - 08/15/2017 Fund 999 Fund Summary Name Period Amount POOLED CASH 8/2017 149,196.73 149,196.73 8/15/2017 4:28:43 PM Page 4 of 4 08-15-2017 04:29 PM PERIOD: 8/02/2017 THRU 8/15/2017 ZONE: • - All Zones REVENUE CODE: All ADJUSTMENT CODES: All ACCOUNT NO# NAME MONTHLY TRANSACTION REPORT DATE TYPE AMOUNT REFERENCE PACKET PAGE: 1 RECEIPT ADJ 01-35200-03 ROSS, JACOB 8/07/2017 RF-CK 35.34 REFUND CK: 129940 20877 O1-75701-01 BOYLE-ZURBRIGEN, BRENDA 8/07/2017 RF-CK 224.77 REFUND CK: 129941 20877 01-77701-05 TERRELL, DALE E 8/07/2017 RF-CK 130.05 REFUND CK: 129942 20877 01-88666-01 MARSH, DUANE 8/07/2017 RF-CK 61,46 REFUND CK: 129943 20877 16-00075-00 HALE DEVELOPMENT CO LLC 8/07/2017 RF-CK 346.20 REFUND CK: 129944 20877 16-00092-01 DONOVAN, RITA T 8/07/2017 RF-CK 26.42 REFUND CK: 129945 20877 16-00522-01 SHARPE, ROBERT 8/07/2017 RF-CK 68.32 REFUND CK: 129946 20877 17-00086-00 GREENLAND HOMES 6/07/2017 RF-CK 61.B8 REFUND CK: 129947 20877 83-01590-07 AMICK, ASHLEY N 8/07/2017 RF-CK 141.88 REFUND CK: 129948 20877 84-00101-03 DECOSTER, BETHANY L 8/07/2017 RF-CK 189.04 REFUND CK: 129949 20877 84-00420-04 ABDO, PAMELA 8/07/2017 RF-CK 98.56 REFUND CK: 129950 20877 84-00544-00 SENECA COMPANIES 8/07/2017 RP-CK 882.93 REFUND CK: 129951 20877 84-00553-00 PRESSURE POINT CLEANERS 8/07/2017 RF-CK 478.44 REFUND CK: 129952 20877 84-01795-04 BARTON, LYNN M 8/07/2017 RF-CK 57.93 REFUND CK: 129953 20877 84-01919-02 PFALTZGRAFF, ALEX 8/07/2017 RF-CK 71.66 REFUND CK: 129954 20877 84-02628-04 TIFFANY, DANA S 8/07/2017 RF-CK 130.97 REFUND CK: 129955 20877 85-00042-03 WITTE, CAYLA 8/07/2017 RF-CK 71.92 REFUND CK: 129956 20877 65-00043-02 ALLEN, CHARLES J 8/07/2017 RF-CK 50.27 REFUND CK: 129957 20877 85-00083-02 SITZ, SAM / JOSEPH 8/07/2017 RF-CK 71.92 REFUND CK: 129958 20877 85-00125-04 FLANNERY-JOHNSO, JILL M 8/07/2017 RF-CK 39.17 REFUND CK: 129959 20877 85-00194-03 WOLF, MICHAEL A 8/07/2017 RP-CK 48.15 REFUND CK: 129960 20877 85-00744-01 FORSYTH, SANDRA K 8/07/2017 RF-CK 49.17 REFUND CK: 129961 20877 85-00822-00 HUBBELL HOMES LC 8/07/2017 RF-CK 17.64 REFUND CK: 129962 20877 85-00828-00 HUBBELL HOMES LC 8/07/2017 RF-CK 27.14 REFUND CK: 129963 20877 85-00983-03 SAMISON, LLC 8/07/2017 RF-CK 68.69 REFUND CK: 129964 20877 08-15-2017 04:29 PM MONTHLY TRANSACTION REPORT PAGE: 2 PERIOD: 8/02/2017 TEND 8/15/2017 ZONE: * - All Zones REVENUE CODE: All ADJUSTMENT CODES: All ACCOUNT NO# NAME DATE TYPE AMOUNT REFERENCE PACKET RECEIPT ADJ 85-01094-01 KINGERY, STEPHANIE L 8/07/2017 RP-CK 24.92 REFUND CK: 129965 20899 85-01095-01 WEIGELT, JOHN J 8/07/2017 RF-CK 56.65 REFUND CK: 129966 20895 85-01082-01 VANHOOREWEGHE, TC 8/07/2017 RF-CK 124.65 REFUND CK: 129969 20879 55-01085-01 HRAL, JAYMES J 8/07/2017 RF-CK 169.40 REFUND CK: 129968 20899 85-01258-00 HUBBELL HOMES LC 8/07/2017 RF-CK 36.86 REFUND CK: 129969 20899 85-01299-00 HUBBELL HOMES LC 8/07/2017 RF-CK 181.12 REFUND CK: 129990 20895 08-15-2019 04:29 PM MONTHLY TRANSACTION REPORT PAGE: 3 PERIOD: 8/D2/2017 THRU 8/15/2017 49 ZONE: * - All Zones REVENUE CODE: All ADJUSTMENT CODES: All -------------------- --------------- ______________------ ____= D A I L Y D I S T R I B U T I 0 N=___________—--------- ___---- DAY REVENUE CODE TYPE COUNT AMOUNT TYPE COUNT AMOUNT TYPE COUNT AMOUNT 09 999 - REFUND RP-CK 31 4,043.52 GRAND TOTAL FOR PERIOD 4,043.52 DEPOSIT TOTAL FOR PERIOD 0.00