Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2017-04-17-J01A 04172017_bill list_payroll
City of Waukee Sill Presentation Recap April 17, 2017 Total Unpaid Bills Presented for Approval : $1,459,562.37 Total Checks Issued Prior to Council Approval: Regular Checks: A) Prior to Last Council Meeting $15,513.11 B) After Last Council Meeting $136,792.67 C) Payroll Taxes & Reimbursements $216,115.57 D) Utility Refunds $1,826.25 Payroll Checks Issued: E) 03/31/2017 $196,315.25 Grand Total: $2,026,125.22 FY 2017 Fund Recap: Expenditures Revenues Budgeted Year To Date Budgeted Year To Date 010 General Fund $ 9,736,705 $ 7,726,701 $ 9,520,350 $ 9,543,696 060 Road Use Tax Fund $ 2,145,066 $ 1,777,322 $ 1,822,167 $ 1,661,429 075 Waukee Foundation $ - $ 24 $ - $ 60,900 085 Asset Forfeitures $ - $ - $ 420.77 091 Hickman West Indust Park TIF $ 421,355 $ - $ 576,400 $ 571,702 092 Enterprise Business Park TIF Fund $ 232,550 $ - $ 600 $ 1,018 093 Waukee Urban Renewal Area TIF Fund $ 2,988,360 $ 28,547 $ 2,780,500 $ 2,763,209 094 Gateway Urban Renewal $ - $ 9,737 $ - $ - 095 Autumn Ridge Urban Renewal $ - $ 521 $ - $ - 110 Debt Service Fund $ 6,951,481 $ 2,467,273 $ 6,999,755 $ 4,458,249 111 Special Assessments Fund $ 45,698 $ 43,739 $ 42,200 $ 32,533 210 Employee Benefits Fund $ 1,500,285 $ - $ 1,504,285 $ 1,450,108 327 Capital Projects $ 11,653,500 $ 4,690,395 $ 11,653,500 $ 1,283,744 330 City Wide SA Sidewalk Project $ - $ - $ - $ 5,025 510 Water Utility Fund $ 3,910,801 $ 2,521,640 $ 3,671,507 $ 3,497,806 520 Sewer Utility Fund $ 7,003,697 $ 5,759,150 $ 3,714,066 $ 3,897,960 521 University Ave Trunk Sewer Project $ - $ - $ - $ 5,956 522 Waste Water Treatment PI $ - $ - $ - $ 112 523 E Area Pump Sta Treatment $ - $ - $ - $ 392 540 Gas Utility Fund $ 5,590,810 $ 3,385,149 $ 5,491,100 $ 4,735,105 560 Storm Sewer Utility Fund $ 1,148,970 $ 686,241 $ 891,150 $ 859,252 570 Utility Bill Fund $ 264,790 $ 186,296 $ 264,750 $ 186,528 590 Solid Waste Collect & Rcycl Fund $ 1,081,760 $ 922,070 $ 1,101,160 $ 880,068 750 Golf Course Fund $ 507,595 $ 394,979 $ 592,300 $ 364,409 810 Equipment Revolving Fund $ - $ - $ 30,000 $ 427 Total: $ 55,183,423 $ 30,599,784 $ 50,655,790 $ 36,260,047 City of Waukee FY2017 Department Report - General Fund As of April 17, 2017 Expended YTD Budgeted $ Remaining General Fund: Police Department Personnel Services $ 1,691,195 Supplies & Services $ 234,548 Capital Outlay $ 139,526 $ 2,065,268 $ 2,661,080 $ 595,812 Warning Sirens Personnel Services $ 107 Supplies & Services $ (979) Capital Outlay $ (872) $ 2,000 $ 2,872 Westcom Dispatch Personnel Services Supplies & Services $ 381,082 Capital Outlay $ 381,082 $ 430,500 $ 49,418 Fire Department Personnel Services $ 531,418 Supplies & Services $ 71,391 Capital Outlay $ - $ 602,810 $ 830,720 $ 227,910 EMS Personnel Services $ 521,406 Supplies & Services $ 71,398 Capital Outlay $ - $ 592,804 $ 762,600 $ 169,796 Building Inspection Personnel Services $ 237,533 Supplies & Services $ 16,927 Capital Outlay $ 33,639 $ 288,099 $ 398,830 $ 110,731 Animal Control Personnel Services Supplies & Services $ 5,160 Capital Outlay $ 5,160 $ 1,000 $ (4,160) Library Services Personnel Services $ 428,301 Supplies & Services $ 151,261 Capital Outlay $ - $ 579,562 $ 852,275 $ 272,713 Mosquito Control Personnel Services $ Supplies & Services $ Capital Outlay $ - $ - $ 6,500 $ 6,500 Parks Personnel Services $ 189,315 Supplies & Services $ 116,439 Capital Outlay $ 69,648 $ 375,402 $ 480,297 $ 104,895 Recreation Personnel Services $ 259,135 Supplies & Services $ 153,308 Capital Outlay $ - $ 412,442 $ 523,662 $ 111,220 Community Center Personnel Services $ 2,695 Supplies & Services $ 11,064 Capital Outlay $ - $ 13,759 $ 24,320 $ 10,561 Public Works Personnel Services $ 77,834 Supplies & Services $ (9,094) Capital Outlay $ $ 68,740 $ 73,644 $ 4,904 Public Works Building Personnel Services $ - Supplies & Services $ 125,892 Capital Outlay $ 10,500 $ 136,392 $ - $ (136,392) Public Works Mechanic Personnel Services $ 133,326 Supplies & Services $ 135,138 Capital Outlay $ - $ 268,464 $ 171,750 $ (96,714) Median and Bldg Grounds Personnel Services Supplies & Services $ 6,924 Capital Outlay $ 6,924 $ 14,000 $ 7,076 Mayor & Council Personnel Services $ 25,949 Supplies & Services $ 9,847 Capital Outlay $ - $ 35,796 $ 72,840 $ 37,044 Elections Personnel Services $ Supplies & Services $ Capital Outlay $ - $ - $ 8,000 $ 8,000 Communications Personnel Services $ 45,855 Supplies & Services $ 6,264 Capital Outlay $ - $ 52,119 $ 114,808 $ 62,689 Administration Personnel Services $ 145,524 Supplies & Services $ 121,096 Capital Outlay $ 321,206 $ 587,826 $ 348,250 $ (239,576) City Hall Personnel Services $ - Supplies & Services $ 43,551 Capital Outlay $ 1,003 $ 44,554 $ 79,000 $ 34,446 Human Resources Personnel Services $ 50,788 Supplies & Services $ 7,404 Capital Outlay $ - $ 58,192 $ 80,138 $ 21,946 Financial Administration Personnel Services $ 101,780 Supplies & Services $ 18,593 Capital Outlay $ - $ 120,373 $ 198,922 $ 78,549 Community Development Personnel Services $ 167,650 Supplies & Services $ 87,836 Capital Outlay $ - $ 255,486 $ 324,240 $ 68,754 City Attorney Personnel Services $ - Supplies & Services $ 133,056 Capital Outlay $ - $ 133,056 $ 100,000 $ (33,056) Development Services Personnel Services $ 234,505 Supplies & Services $ 38,178 Capital Outlay $ - $ 272,683 $ 524,535 $ 251,852 Information Technology Personnel Services $ - Supplies & Services Capital Outlay $ 5,272 $ 5,272 $ - $ (5,272) Engineering Personnel Services $ 274,584 GIS Supplies & Services $ 47,016 Capital Outlay $ 12,924 $ 334,524 $ 625,139 $ Personnel Services $ 22,320 Supplies & Services $ (4,458) Capital Outlay $ 12,924 $ 30,786 $ 27,655 $ Transfers to GO Debt Service Total General Fund: Personnel Services Supplies & Services Capital Outlay 290,615 (3,131) $ 7,726,701 $ 9,736,705 $ 2,010,004 $ 5,141,220 $ 1,978,842 $ 606,639.60 $ 7,726,701 Expense Approval Register 410 City of Waukee, IA t: APPKT00559 - MARCH 18TH COUNCIL PACKET Waukee Vendor Name Payable Number Post Date Description (Item( Account Number Amount BANKERS TRUST COMPANY INV0002725 04/18/2017 APRIL'17 SINKING FUND TR 110-1080100 569,450.00 BANKERS TRUST COMPANY INV0002725 04/18/2017 APRIL'17 SINKING FUND TR 510-1080100 27,050.00 BANKERS TRUST COMPANY INV0002725 04/18/2017 APRIL'17 SINKING FUND TR 520-1080100 9,950.00 BANKERS TRUST COMPANY INV0002725 04/18/2017 APRIL'17 SINKING FUND TR 540-1080100 35,050.00 TREASURER STATE OF IOWA INV0002727 03/31/2017 MAR'17 WATER SALES TAXE 510-2030500 15,315.07 TREASURER STATE OF IOWA INV0002728 03/31/2017 MAR'17 SEWER SALES TAXE 520-2030500 2,388.89 TREASURER STATE OF IOWA INV0002729 03/31/2017 MAR'17 GAS SALES TAXES 540-2030500 4,817.85 TREASURER STATE OF IOWA INV0002730 03/31/2017 MAR'17 STORM WATER SAL 560-2030500 1,212.09 TREASURER STATE OF IOWA INV0002731 03/31/2017 MAR'17 PARK & REC SALES 010-2030500 62.40 TREASURER STATE OF IOWA INV0002740 03/31/2017 MAR'17 GOLF COURSE SALE 750-2030500 1,176.95 666,473.25 Department: 1100 - POLICE OPERATIONS GALL'S INC 007110579 03/06/2017 SHIRT- NICELYGREEN 010-10.1100.120000 12.25 GALL'S INC 007120283 03/07/2017 PANTS/SHIRT - SNELSON 010-10.1100.120000 108.81 GALL'S INC 007145610 03/10/2017 CAP - SNELSON 010-10.1100.120000 12.67 MOBILEVISION 0253624-IN 03/16/2017 ACCESS POINT OUTDOOR 010-10.1100.540000 245.00 THE WALDINGER CORP 110802-20 03/20/2017 HVAC PREVENTATIVE MATTE 010-10.1100.400000 1,120.50 HEARTLAND TIRE &AUTO 121448 03/23/2017 TIRE REPAIR 010-10.1100.410000 20.00 ORKIN PEST CONTROL 155074346 04/17/2017 PEST CONTORL-PD 010-10.1100.400000 103.72 LAW ENFORCEMENT SYSTE 197611 03/17/2017 ABANDONED VEHICLE LABEL 010-10.1100.590000 82.00 CARPENTER UNIFORM CO 436420 03/29/2017 STRYKE PANT- MAPES 010-10.1100.120000 74.99 CARPENTER UNIFORM CO 436441 03/29/2017 SLACKS -KIES 010-10.1100.120000 173.98 CARPENTER UNIFORM CO 436656 04/03/2017 PAGER/GLOVE POUCH/BELT 010-10.1100.590000 66.97 CARPENTER UNIFORM CO 436805 04/04/2017 SERGANT CHEVON- CUNNIN 010-10.1100.120000 25.00 WAUKEE ROTARY CLUB 5107 04/10/2017 MEMBER DUES -QUINN 010-10.1100.280000 225.00 NATIONWIDE OFFICE CLEAN 60272 03/29/2017 CAN LINERS/TOWELS -PD 010-10.1100.590000 55.31 MUTUAL OF OMAHA 624443078 04/01/2017 APR'17 LIFE & DISABILITY PR 010-10.1100.100000 330.05 MUTUAL OF OMAHA 624443078 04/01/2017 APR'17 LIFE & DISABILITY PR 010-10.1100.100100 485.32 ADECCO EMPLOYMENT SER 68487728 03/27/2017 CONTRACT LABOR- FLORES 010-10.1100.230000 363.40 ADECCO EMPLOYMENT SER 68495957 04/03/2017 CONTRACT LABOR- FLORES 010-10.1100.230000 363.40 ROCK RIVER ARMS, INC. 769696 03/22/2017 TACTICAL CARBINE 10.5" 010-10.1100.540000 1,040.00 OFFICE DEPOT 913449150001 03/17/2017 TRASH CAN 010-10.1100.590000 53.99 EMPLOYEE BENEFIT SYSTEM 9793 04/11/2017 MAY'17 HEALTH INSURANC 010-10.1100.100000 26,881.56 CONSOLIDATED COMMUNIC INV0002734 04/08/2017 APRIL'17 STATEMENT 010-10.1100.450000 48.73 CONSOLIDATED COMMUNIC INV0002734 04/08/2017 APRIL'17 STATEMENT 010-10.1100.450000 49.25 AMERITAS LIFE INSURANCE INV0002739 04/01/2017 APR'17 VISION INSURANCE 010-10.1100.100000 466.72 ACCESS SYSTEMS INV496462 01/27/2017 MONITORING COMP & PHO 010-10.1100.270100 173.21 ACCESS SYSTEMS INV508311 03/21/2017 MARCH'17 SERVICE FEE 010-10.1100.270100 465.20 ACCESS SYSTEMS INV508947 03/24/2017 IN -WALL HIGH SPEED HDMI 010-10.1100.410200 40.03 CITY OF WAUKEE MAR17110140150 03/31/2017 MARCH'17 STATEMENT 010-10.1100.480000 561.12 Department 1100 - POLICE OPERATIONS Total: 33,648.18 Department: 1300- WESTCOM DISPATCH CITY OF WEST DES MOINES FN-2017-00000199 04/05/2017 APRIL'17 WESTCOM 010-10.1300.230010 33,763.09 Department 1300- WESTCOM DISPATCH Total: 33,763.09 Department: 1400 - FIRE PROTECTION GALLS INC 007224493 03/23/2017 SHIRTS-TYSDAL 010-10.1400.120000 172.82 ED M FELD EQUIPMENT CO 0309607-IN 03/30/2017 USED VALVE 010-10.1400.410100 50.00 MULCH MART 38468 04/06/2017 RIVER ROCK 010-10.1400.590000 43.15 KUM&GO 49226290 03/31/2017 MARCH'17 STATEMENT 010-10.1400.570000 463.31 MUTUAL OF OMAHA 624443078 04/01/2017 APR'17 LIFE & DISABILITY PR 010-10.1400.100000 127.10 MUTUAL OF OMAHA 624443078 04/01/2017 APR'17 LIFE & DISABILITY PR 010-10.1400.100100 92.23 THE WALDINGER CORP 9006458-1 03/24/2017 REPLACE FAILED CAPACITOR 010-10.1400.400000 344.00 EMPLOYEE BENEFIT SYSTEM 9793 04/11/2017 MAY'17 HEALTH INSURANC 010-10.1400.100000 5,249.60 4/12/2017 2:36:08 PM Page 1 of 17 Expense Approval Register Packet: APPKT00559 - MARCH 18TH COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount FIRE SAFETY USA, INC. 98776 03/17/2017 REPAIR KIT/GASKET 010-10.1400.410000 113.00 CAPITALSANITARY SUPPLY C227859 02/16/2017 LAUNDRY DETERGENT 010-10.1400.590000 80.92 WAUKEE HARDWARE & VARI INV0002718 03/31/2017 MARCH'17 STATEMENT -FIR 010-10.1400.590000 7.78 CONSOLIDATED COMMUNIC INV0002734 04/08/2017 APRIL'17 STATEMENT 010-10.1400.450000 45.65 CONSOLIDATED COMMUNIC INV0002734 04/08/2017 APRIL'17 STATEMENT 010-10.1400.450000 49.25 AMERITAS LIFE INSURANCE INV0002739 04/01/2017 APR'17 VISION INSURANCE 010-10.1400.100000 100.68 POLK COUNTY FIRE CHIEFS A INV0002747 O1/01/2017 2017 DUES 010-10.1400.280000 12.50 ACCESS SYSTEMS INV496462 01/27/2017 MONITORING COMP & PHO 010-10,1400.270100 65.17 ACCESS SYSTEMS INV508311 03/21/2017 MARCH'17 SERVICE FEE 010-10,1400.270100 175.02 CITY OF WAUKEE MAR17110140150 03/31/2017 MARCH'17 STATEMENT 010-10.1400.480000 371.91 Department 1400 - FIRE PROTECTION Total: 7,564.09 Department: 2500 - EMS MERCY COLLEGE OF HEALTH 03282017 03/28/2017 ACLS & PALS PROVIDER ECA 010-10.1500.470000 180.00 INTERSTATE ALL BATTERY CE 1924601032733 03/29/2017 BATTERY 010-10.1500.590000 230.85 HAMMER MEDICAL SUPPLY- 2328387 03/22/2017 COMPRESSED OXYGEN 010-10.1500.590050 240.20 KUM&G0 49226290 03/31/2017 MARCH'17 STATEMENT 010-10.1500.570000 463.31 MUTUALOF OMAHA 624443078 04/01/2017 APR'17 LIFE & DISABILITY PR 010-10.1500.100000 10.40 MUTUALOF OMAHA 624443078 04/01/2017 APR'17 LIFE & DISABILITY PR 010-10.1500.100100 39.29 BOUND TREE MEDICAL 82439718 03/17/2017 CHILD TRANSPORT 010-10.1500.590000 282.53 BOUNDTREE MEDICAL 82448094 03/27/2017 MEDICALSUPPLIES 010-10.1500.590050 222.36 BOUNDTREE MEDICAL 82452202 03/30/2017 CHILD TRANSPORT 010-10.1500.590000 282.53 BOUND TREE MEDICAL 82452203 03/30/2017 MEDICALSUPPLIES 010-10.1500.590050 178.81 NAPA AUTO PARTS STORE 923243 03/28/2017 MARKER LIGHT REPAIR 010-10.1500.410000 14.32 EMPLOYEE BENEFIT SYSTEM 9793 04/11/2017 MAY'17 HEALTH INSURANC 010-10.1500.100000 5,249.59 CONSOLIDATED COMMUNIC INV0002734 04/08/2017 APRIL'17 STATEMENT 010-10.1500.450000 49.25 CONSOLIDATED COMMUNIC INV0002734 04/08/2017 APRIL'17 STATEMENT 010-10.1500.450000 45.65 AMERITAS LIFE INSURANCE INV0002739 04/O1/2017 APR'17 VISION INSURANCE 010-10.1500.100000 100.67 POLK COUNTY FIRE CHIEFS A INV0002747 01/O1/2017 2017 DUES 010-10.1500.280000 12.50 MERCY WEST PHARMACY INV0002748 04/03/2017 EMS MEDICATIONS 010-10.1500.590050 279.44 ACCESS SYSTEMS INV496462 01/27/2017 MONITORING COMP & PHO 010-10.1500.270100 53.96 ACCESS SYSTEMS INV508311 03/21/2017 MARCH'17 SERVICE FEE 010-10.1500.270100 144.93 CITY OF WAUKEE MAR17110140150 03/31/2017 MARCH'17 STATEMENT 010-10.1500.480000 371.90 Department 1500 - EMS Total: 8,452.49 Department: 1600 - STREET LIGHTING IOWA SIGNAL INC 3523 03/22/2017 INSTALLLED 060-30.1600.410300 710.83 MID AMERICAN ENERGY MARCH171600SUMBILL 03/27/2017 MARCH'17 STATEMENT 060-30.1600.480000 15,043.76 Department 1600 - STREET LIGHTING Total: 15,754.59 Department: 1601- TRAFFIC SIGNALS SNYDER & ASSOCIATES INC 114.0475.01-15 03/30/2017 HICKMAN RD & DARTMOOR 327-90.1601.235020 430.50 SNYDER&ASSOCIATES INC 116.0645.01-6 03/30/2017 MISC TRAFFIC ENGINEERING 060-30.1601.230000 1,496.00 MID AMERICAN ENERGY MARCH171601SUMBILL 03/27/2017 MARCH'17 STATEMENT 060-30.1601.480000 344.50 Department 1601 - TRAFFIC SIGNALS Total: 2,271.00 Department: 1900 - BUILDING INSPECTION MUTUAL OF OMAHA 624443078 04/01/2017 APR'17 LIFE & DISABILITY PR 010-10.1900.100000 42.00 MUTUAL OF OMAHA 624443078 04/01/2017 APR'17 LIFE & DISABILITY PR 010-10.1900.100100 95.09 EMPLOYEE BENEFIT SYSTEM 9793 04/11/2017 MAY'17 HEALTH INSURANC 010-10.1900.100000 3,954.30 AMERITAS LIFE INSURANCE INV0002739 04/O1/2017 APR'17 VISION INSURANCE 010-10.1900.100000 75.84 ACCESS SYSTEMS INV496462 01/27/2017 MONITORING COMP & PHO 010-10.1900.270100 24.94 ACCESS SYSTEMS INV508311 03/21/2017 MARCH'17 SERVICE FEE 010-10.1900.270100 66.98 Department 1900 - BUILDING INSPECTION Total: 4,259.15 Department: 2130 - ALICES ROAD PROJECT AHLERS & COONEY PC 726920 03/30/2017 SE ALICES RD PHASE 4 327-90.2130.840490 1,800.00 Department 2130 - ALICES ROAD PROJECT Total: 1,800.00 Department: 2400-ANIMAL CONTROL BRODERICK ANIMAL CLINIC 147456 03/27/2017 CANINE/FELINE BOARDING 010-10.2400.340000 540.00 Department 2400 - ANIMAL CONTROL Total: 540.00 Department: 3100 - LIBRARY SERVICES ABSOLUTE SCIENCE 06092017 04/03/2017 SCIENCE PROGRAM 010-40.3100.460400 350.00 4/12/2017 2:36:08 PM Page 2 of 17 Expense Approval Register Packet: APPKT00559 - MARCH 18TH COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount CONE, INC 06162017 04/03/2017 MAGIC PERFORMANCE 010-40.3100.460400 350.00 BLANK PARK ZOO 06232017 04/03/2017 WORLD FOR WILDLIFE PRESE 010-40.3100.460400 90.00 HAPPY FACES ENTERTAINME 06302017 04/03/2017 BLUEPRINT THEATER PERFO 010-40.3100.460400 350.00 CAROLE STEPHENS 07072017 04/03/2017 FAMILY MUSIC CONCERT 010-40.3100.460400 450.00 JESTER PUPPETS 07142017 04/03/2017 CHILDREN'S PERFORMANCE 010-40.3100,460400 300.00 JONATHAN MAY 07282017 04/03/2017 FAMILY MAGIC SHOW 010-40.3100.460400 300.00 SCIENCE CENTER OF IOWA 1144209 04/18/2017 BUILDING BLUNDERS SUMM 010-40.3100.460400 200.00 ORKIN PEST CONTROL 155073202 04/17/2017 PEST CONTROL - LIBRARY 010-40.3100.400000 65.97 GALE/CENGAGE LEARNING 60366280 03/23/2017 GVRL HOSTING FEE 5I+EBO 010-40.3100.270000 300.00 MUTUAL OF OMAHA 624443078 04/01/2017 APR'17 LIFE & DISABILITY PR 010-40.3100.100000 56.20 MUTUAL OF OMAHA 624443078 04/01/2017 APR'17 LIFE & DISABILITY PR 010-40.3100.100100 59.72 SIMPLEXGRINNELL LP 83515777 03/22/2017 REPLACE 6V5AH BATTERY IN 010-40.3100.400000 45.00 OFFICE DEPOT 914891889001 03/21/2017 TAPE/LABELS/WATER 010-40.3100.580000 66.18 INGRAM LIBRARY SERVICES 97783665 03/22/2017 BOOKS 010-40.3100.590000 1.19 INGRAM LIBRARYSERVICES 97783665 03/22/2017 BOOKS 010-40.3100.640000 10.92 INGRAM LIBRARY SERVICES 97783666 03/22/2017 BOOKS 010-40.3100.590000 1.19 INGRAM LIBRARY SERVICES 97783666 03/22/2017 BOOKS 010-40.3100.640000 16.10 INGRAM LIBRARY SERVICES 97783667 03/22/2017 BOOKS 010-40.3100.590000 1.19 INGRAM LIBRARY SERVICES 97783667 03/22/2017 BOOKS 010-40.3100.640000 15.52 INGRAM LIBRARY SERVICES 97783668 03/22/2017 BOOKS 010-40.3100.590000 2.89 INGRAM LIBRARYSERVICES 97783668 03/22/2017 BOOKS 010-40.3100.640000 22.49 INGRAM LIBRARYSERVICES 97783669 03/22/2017 BOOKS 010-40.3100.590000 0.54 INGRAM LIBRARYSERVICES 97783669 03/22/2017 BOOKS 010-40.3100.640000 16.10 INGRAM LIBRARY SERVICES 97783670 03/22/2017 BOOKS 010-40.3100.590000 2.49 INGRAM LIBRARY SERVICES 97783670 03/22/2017 BOOKS 010-40.3100.640000 19.48 INGRAM LIBRARY SERVICES 97783671 03/22/2017 BOOKS 010-40.3100.590000 0.25 INGRAM LIBRARYSERVICES 97783671 03/22/2017 BOOKS 010-40.3100.640000 22.49 INGRAM LIBRARY SERVICES 97783672 03/22/2017 BOOKS 010-40.3100.590000 1.85 INGRAM LIBRARY SERVICES 97783672 03/22/2017 BOOKS 010-40.3100.640000 4.79 INGRAM LIBRARYSERVICES 97803423 03/23/2017 BOOKS 010-40.3100.590000 1.39 INGRAM LIBRARY SERVICES 97803423 03/23/2017 BOOKS 010-40,3100.640000 10.34 INGRAM LIBRARY SERVICES 97803424 03/23/2017 BOOKS 010-40.3100.590000 5.44 INGRAM LIBRARY SERVICES 97803424 03/23/2017 BOOKS 010-40,3100.640000 19.25 INGRAM LIBRARY SERVICES 97803425 03/23/2017 BOOKS 010-40.3100.590000 2.45 INGRAM LIBRARYSERVICES 97803425 03/23/2017 BOOKS 010-40.3100.640000 67.47 INGRAM LIBRARY SERVICES 97803426 03/23/2017 BOOKS 010-40.3100.590000 77.48 INGRAM LIBRARY SERVICES 97803426 03/23/2017 BOOKS 010-40.3100.640000 633.03 INGRAM LIBRARY SERVICES 97803427 03/23/2017 BOOKS 010-40.3100.590000 16.61 INGRAM LIBRARY SERVICES 97803427 03/23/2017 BOOKS 010-40.3100.640000 129.15 INGRAM LIBRARY SERVICES 97803428 03/23/2017 BOOKS 010-40.3100.590000 1.85 INGRAM LIBRARYSERVICES 97803428 03/23/2017 BOOKS 010-40.3100.640000 49.07 INGRAM LIBRARY SERVICES 97815099 03/24/2017 BOOKS 010-40.3100,590000 1.80 INGRAM LIBRARYSERVICES 97815099 03/24/2017 BOOKS 010-40.3100.640000 37.48 INGRAM LIBRARY SERVICES 97815100 03/24/2017 BOOKS 010-40.3100.590000 0.90 INGRAM LIBRARYSERVICES 97815100 03/24/2017 BOOKS 010-40.3100.640000 4.89 INGRAM LIBRARY SERVICES 97815101 03/24/2017 BOOKS 010-40.3100.590000 1.73 INGRAM LIBRARY SERVICES 97815101 03/24/2017 BOOKS 010-40.3100.640000 19.54 INGRAM LIBRARY SERVICES 97815102 03/24/2017 BOOKS 010-40.3100.590000 1.19 INGRAM LIBRARY SERVICES 97815102 03/24/2017 BOOKS 010-40.3100.640000 9.77 INGRAM LIBRARY SERVICES 97815103 03/24/2017 BOOKS 010-40.3100.590000 1.19 INGRAM LIBRARY SERVICES 97815103 03/24/2017 BOOKS 010-40.3100.640000 8.62 INGRAM LIBRARY SERVICES 97829429 03/26/2017 BOOKS 010-40.3100.590000 0.54 INGRAM LIBRARYSERVICES 97829429 03/26/2017 BOOKS 010-40.3100.640000 25.99 INGRAM LIBRARY SERVICES 97829430 03/26/2017 BOOKS 010-40.3100,590000 1.85 INGRAM LIBRARY SERVICES 97829430 03/26/2017 BOOKS 010-40.3100.640000 9.60 INGRAM LIBRARY SERVICES 97829431 03/26/2017 BOOKS 010-40.3100.640000 15.53 INGRAM LIBRARY SERVICES 97829432 03/26/2017 BOOKS 010-40.3100.590000 1.19 INGRAM LIBRARY SERVICES 97829432 03/26/2017 BOOKS 010-40.3100.640000 20.90 INGRAM LIBRARY SERVICES 97829433 03/26/2017 BOOKS 010-40.3100.640000 10.34 INGRAM LIBRARY SERVICES 97863855 03/28/2017 BOOKS 010-40.3100.590000 5.95 4/12/2017 2:36:08 PM Page 3 of 17 Expense Approval Register Packet: APPKT00559 - MARCH 18TH COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount INGRAM LIBRARY SERVICES 97863855 03/28/2017 BOOKS 010-40.3100.640000 43.66 INGRAM LIBRARY SERVICES 97863856 03/28/2017 BOOKS 010-40.3100.590000 1.08 INGRAM LIBRARY SERVICES 97863856 03/28/2017 BOOKS 010-40.3100.640000 32.19 INGRAM LIBRARY SERVICES 97883158 03/29/2017 BOOKS 010-40.3100.590000 1.19 INGRAM LIBRARY SERVICES 97883158 03/29/2017 BOOKS 010-40.3100.640000 10.34 EMPLOYEE BENEFIT SYSTEM 9793 04/11/2017 MAY'17 HEALTH INSURANC 010-40.3100.100000 7,383.71 CONSOLIDATED COMMUNIC INV0002734 04/08/2017 APRIL'17 STATEMENT 010-40.3100.450000 49.25 CONSOLIDATED COMMUNIC INV0002734 04/08/2017 APRIL'17 STATEMENT 010-40.3100.450000 157.85 AMERITAS LIFE INSURANCE INV0002739 04/01/2017 APR'17 VISION INSURANCE 010-40.3100.100000 126.96 ACCESS SYSTEMS INV496462 01/27/2017 MONITORING COMP &PHO 010-40.3100.270100 64.08 ACCESS SYSTEMS INV508311 03/21/2017 MARCH'17 SERVICE FEE 010-40.3100.270100 172.09 CITY OF WAUKEE MARCH17310 03/31/2017 MARCH'17 STATEMENT 010-40.3100.480000 723.39 Department 3100 - LIBRARY SERVICES Total: 13,080.87 Department: 4100 - PARKS ZIMCO SUPPLY CO 106061 03/28/2017 BALL DIAMONDS 010-40.4100.590100 390.00 DOG WASTE DEPOT 149766 03/31/2017 DOG WASTE BAGS 010-40.4100.590000 78.00 ARNOLD MOTOR SUPPLY 21-710367 03/22/2017 12V LAWN MOWER BATTER 010-40.4100.410100 49.00 PLUMB SUPPLY COMPANY 4447758 03/24/2017 SAND CLOTH/BALL VALVES 010-40.4100A10300 21.99 MUTUAL OF OMAHA 624443078 04/O1/2017 APR'17 LIFE & DISABILITY PR 010-40.4100.100000 2.60 MUTUAL OF OMAHA 624443078 04/O1/2017 APR'17 LIFE & DISABILITY PR 010-40.4100.100000 0.52 MUTUAL OF OMAHA 624443078 04/O1/2017 APR'17 LIFE & DISABILITY PR 010-40.4100.100000 2.60 MUTUAL OF OMAHA 624443078 04/O1/2017 APR'17 LIFE & DISABILITY PR 010-40.4100.100100 1.81 MUTUAL OF OMAHA 624443078 04/01/2017 APR'17 LIFE & DISABILITY PR 010-40.4100.100100 27.72 MUTUAL OF OMAHA 624443078 04/01/2017 APR'17 LIFE & DISABILITY PR 010-40.4100.100100 10.80 MENARDS 75096 03/27/2017 TITANIUM DRILL/BEVELD IE 010-40.4100.410300 66.90 MENARDS 75182 03/28/2017 EXT DECK LOBE/BEVELD IE 010-40.4100.410300 69.92 OFFICE DEPOT 914892130001 03/21/2017 ADHESIVE SHAPES 010-40.4100.580000 9.98 EMPLOYEE BENEFIT SYSTEM 9793 04/11/2017 MAY'17 HEALTH INSURANC 010-40.4100.100000 284.07 EMPLOYEE BENEFIT SYSTEM 9793 04/11/2017 MAY'17 HEALTH INSURANC 010-40.4100.100000 1,420.34 EMPLOYEE BENEFIT SYSTEM 9793 04/11/2017 MAY'17 HEALTH INSURANC 010-40.4100.100000 556.81 R & R PRODUCTS INC CD2106390 03/30/2017 MOWER BLADES 010-40.4100.540000 520.82 HEARTLAND CO-OP INV0002710 03/31/2017 MARCH'17 STATEMENT - PA 010-40.4100.570000 423.12 WAUKEE HARDWARE & VARI INV0002719 03/31/2017 MARCH'17 STATEMENT - PA 010-40.4100.410300 248.89 CONSOLIDATED COMMUNIC INV0002734 04/08/2017 APRIL'17 STATEMENT 010-40.4100.450000 14.65 AMERITAS LIFE INSURANCE INV0002739 04/O1/2017 APR'17 VISION INSURANCE 010-40.4100.100000 27.24 AMERITAS LIFE INSURANCE INV0002739 04/O1/2017 APR'17 VISION INSURANCE 010-40.4100.100000 10.68 AMERITAS LIFE INSURANCE INV0002739 04/O1/2017 APR'17 VISION INSURANCE 010-40.4100.100000 2.14 ACCESS SYSTEMS INV496462 01/27/2017 MONITORING COMP & PHO 010-40.4100.270100 45.16 ACCESS SYSTEMS INV508311 03/21/2017 MARCH'17 SERVICE FEE 010-40.4100.270100 121.29 CITY OF WAUKEE MAR17410 03/31/2017 MARCH'17 STATEMENT 010-40.4100.480000 23.72 CITY OF WAUKEE MAR17410 03/31/2017 MARCH'17 STATEMENT 010-40.4100.480000 180.11 CITY OF WAUKEE MAR17410 03/31/2017 MARCH'17 STATEMENT 010-40.4100.480000 24.39 CITY OF WAUKEE MAR17410 03/31/2017 MARCH'17 STATEMENT 010-40.4100.480100 34.94 MID AMERICAN ENERGY MARCH 174100SUMBI LL 03/27/2017 MARCH'17 STATEMENT 010-40.4100.480000 177.51 PLAYCORE WISCONSIN INC PJI-0056802 03/15/2017 CENTENNIAL PLAYGROUND 010-40.4100.410300 468.22 Department 4100 - PARKS Total: 5,325.94 Department: 4200 - RECREATION FAREWAY STORES, INC. 00333212 04/06/2017 SLOWCOOKER LINERS 010-40.4200.460520 8.96 RESULTS BODYIAB 113 03/31/2017 MARCH-APRILCLASSES 010-40.4200.460500 1,456.00 BOWEN DESIGN LLC 13480 03/30/2017 SPRING'17 GIRLS REC SB SHI 010-40.4200.460510 3,682.50 ATLANTIC BOTTLING CO 146707 04/05/2017 CONCESSION STAND POP 010-40.4200.460520 771.70 FARNER-BOCKEN COMPANY 5607747 04/06/2017 GIRLS SOFTBALL CONSESSIO 010-40.4200.460520 1,772.67 MUTUAL OF OMAHA 624443078 04/01/2017 APR'17 LIFE & DISABILITY PR 010-40.4200.100000 51.50 MUTUAL OF OMAHA 624443078 04/O1/2017 APR'17 LIFE & DISABILITY PR 010-40.4200.100100 63.00 DES MOINES BICYCLE COLLIE 802-KB 03/30/2017 BIKE MONTH SPONSORSHIP 010-40.4200.460000 500.00 EMPLOYEE BENEFIT SYSTEM 9793 04/11/2017 MAY'17 HEALTH INSURANC 010-40.4200.100000 3,397.49 BSN SPORTS 98858012 03/20/2017 GIRLS SB EQUIPMENT 010-40.4200.460510 1,402.64 HEARTLAND CO-OP INV0002711 03/31/2017 MARCH'17 STATEMENT - RE 010-40.4200.570000 63.85 CENTRAL IOWA OFFICIALS INV0002724 04/04/2017 2017 SPRING WAUKEE MEN' 010-40.4200.460050 540.00 J & M DISPLAYS INC INV0002733 04/07/2017 FIREWORKS DISPLAY 7/4/20 010-40.4200.460700 12,000.00 4/12/2017 2:36:08 PM Page 4 of 17 Expense Approval Register Packet: APPKT00559 - MARCH 18TH COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount AMERITAS LIFE INSURANCE INV0002739 04/O1/2017 APR'17 VISION INSURANCE 010-40.4200.100000 65.16 SAM'S CLUB INV0002750 04/08/2017 EASTER EGG HUNT CANDY 010-40.4200.461600 2,424.64 ACCESS SYSTEMS INV496462 01/27/2017 MONITORING COMP & PHO 010-40.4200.270100 39.57 ACCESS SYSTEMS INV508311 03/21/2017 MARCH'17 SERVICE FEE 010-40.4200.270100 106.28 Department 4200 - RECREATION Total: 28,345.96 Department: 4300 - COMMUNITY CENTER SAM'S CLUB INV0002750 04/08/2017 SENIOR SUPPLIES 010-40.4300.590000 103.89 CITY OF WAUKEE MAR17430 03/31/2017 MARCH'17 STATEMENT 010-40.4300.480000 110.11 Department 4300 - COMMUNITY CENTER Total: 214.00 Department: 5000 - BIKE TRAIL OLD RAILROAD AHLERS & COONEY PC 726922 03/30/2017 NORTH LOTH TRAILHEAD PA 327-90,5000.881130 1,800.00 Department 5000 - BIKE TRAIL OLD RAILROAD Total: 1,800.00 Department: 5300-STORM WATER G&LCLOTHING 2-179255 03/30/2017 BOOTS-TIBBLES 560-80.5300.120000 150.00 MUTUAL OF OMAHA 624443078 04/O1/2017 APR'17 LIFE & DISABILITY PR 560-80.5300.100000 1.30 MUTUAL OF OMAHA 624443078 04/O1/2017 APR'17 LIFE & DISABILITY PR 560-80.5300.100000 56.30 MUTUAL OF OMAHA 624443078 04/O1/2017 APR'17 LIFE & DISABILITY PR 560-80.5300.100100 72.67 MUTUAL OF OMAHA 624443078 04/01/2017 APR'17 LIFE & DISABILITY PR 560-80.5300.100100 3.97 EMPLOYEE BENEFIT SYSTEM 9793 04/11/2017 MAY'17 HEALTH INSURANC 560-80.5300.100000 494.29 EMPLOYEE BENEFIT SYSTEM 9793 04/11/2017 MAY'17 HEALTH INSURANC 560-80.5300.100000 2,749.08 TRANS IOWA EQUIPMENTT E00065 03/23/2017 SERIAL tf MV41030 560-80.5300.790000 173,820.00 HEARTLAND CO-OP INV0002709 03/31/2017 MARCH'17 STATEMENT-ST 560-80.5300.570000 123.65 MINNESOTA EROSION CONT INV0002722 04/18/2017 2017 - M54 PERMIT WORKS 560-80.5300.470000 85.00 AMERITAS LIFE INSURANCE INV0002739 04/O1/2017 APR'17 VISION INSURANCE 560-80.5300.100000 47.84 AMERITAS LIFE INSURANCE INV0002739 04/O1/2017 APR'17 VISION INSURANCE 560-80.5300.100000 7.82 ACCESS SYSTEMS INV496462 01/27/2017 MONITORING COMP & PHO 560-80.5300.270100 57.24 ACCESS SYSTEMS INV508311 03/21/2017 MARCH'17 SERVICE FEE 560-80.5300.270100 153.72 Department 5300 - STORM WATER Total: 177,822.88 Department: 5400-SOLID WASTE COLLECTION & DISPOSAL BDI SIGNS BUSINESS DESIGN 29984 07/31/2016 TIRE & APPLIACE DROP OFF 590-30.5400.231100 412.50 ANKENY SANITATION INC. 379034 04/O1/2017 APRIL'17 STATEMENT 590-30.5400.231300 85,023.00 Department 5400 - SOLID WASTE COLLECTION & DISPOSAL Total: 85,435.50 Department: 6000 - PUBLIC WORKS MUTUAL OF OMAHA 624443078 04/O1/2017 APR'17 LIFE & DISABILITY PR 010-20.6000.100000 181.00 MUTUAL OF OMAHA 624443078 04/O1/2017 APR'17 LIFE & DISABILITY PR 010-20.6000.100100 106.60 EMPLOYEE BENEFIT SYSTEM 9793 04/11/2017 MAY'17 HEALTH INSURANC 010-20.6000.100000 5,589.76 HEARTLAND CO-OP INV0002717 03/31/2017 MARCH'17 STATEMENT-PU 010-20.6000.570000 290.14 AMERITAS LIFE INSURANCE INV0002739 04/O1/2017 APR'17 VISION INSURANCE 010-20.6000.100000 102.32 ACCESS SYSTEMS INV496462 01/27/2017 MONITORING COMP & PHO 010-20.6000.270100 5.07 ACCESS SYSTEMS INV508311 03/21/2017 MARCH'17 SERVICE FEE 010-20.6000.270100 13.61 Department 6000 - PUBLIC WORKS Total: 6,288.50 Department: 6010 - PUBLIC WORKS BUILDING CONSTRUCTION & AGGREGA 0293449-IN 03/29/2017 MILL HOSE 010-20.6010.400000 339.48 G & KSERVICES INC 1183690379 04/05/2017 MAT SERVICES -PW 010-20.6010.400000 137.77 ORKIN PEST CONTROL 155073001 04/17/2017 PEST CONTROL -PW 010-20.6010.400000 84.99 DESIGN ALLIANCE INC 204904 04/04/2017 WAUKEE PUB. WORKS DATA 010-20.6010.230000 913.75 ARNOLD MOTORSUPPLY 21-710453 03/23/2017 AUTO/FLEET 010-20.6010.400000 181.60 HEARTLAND CO-OP 25-383671 04/04/2017 CYLINDER 010-20.6010.590000 20.00 IOWA FIRE EQUIPMENT CO 293736 03/27/2017 ANNUAL FIRE EXTINGUISHER 010-20.6010.400000 483.95 FIRST CHOICE COFFEE SERVI 297276 03/30/2017 COFFEE 010-20.6010.580000 88.24 MMIT BUSINESS SOLUTIONS 304569 03/28/2017 KIP-3000 010-20.6010.580000 278.30 DIRECTV 30975487885 03/21/2017 MARCH'17 STATEMENT 010-20.6010.480000 95.99 CHRISTIAN PRINTERS INC 36306 03/20/2017 REQUEST LEAVE FORM 010-20.6010.590000 379.00 ANKENY SANITATION INC. 372953 03/22/2017 20YD FLAT EMPTY/RETURN 010-20.6010.510100 252.35 HILLYARD INC 602466491 03/21/2017 JANITORIAL SUPPLIES 010-20.6010.400000 73.46 CONTROL INSTALLATIONS O 63493 03/30/2017 REPAIR CARD READER 010-20.6010.400000 317.31 OVERHEAD DOOR COMPANY 71418 03/23/2017 TIMER BOARD/AMP BREAKE 010-20.6010.400000 202.75 OVERHEAD DOOR COMPANY 71537 03/30/2017 1-FX-4 REMOTE TRANSMITT 010-20.6010.400000 139.00 4/12/2017 2:36:08 PM Page 5 of 17 Expense Approval Register Packet: APPKT00559 - MARCH 18TH COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount MENARDS 75064 03/27/2017 26QT WHEEL 5-DAY COOLER 010-20.6010,580000 212.94 STROH CORP H17011283 03/27/2017 TROUBLE SHOOT CO SENSOR 010-20.6010.400000 1,086.42 FASTENAL COMPANY IAGRM86547 03/30/2017 10" CIA RUBBER HT WHL 010-20.6010.590000 40.13 HEARTLAND CO-OP INV0002717 03/31/2017 MARCH'17 STATEMENT -PU 010-20.6010.590000 92.80 CONSOLIDATED COMMUNIC INV0002721 04/O1/2017 APRIL'17 STATEMENT 010-20.6010.450000 210.27 CONSOLIDATED COMMUNIC INV0002734 04/08/2017 APRIL'17 STATEMENT 010-20.6010.450000 443.23 CONSOLIDATED COMMUNIC INVO002734 04/08/2017 APRIL'17 STATEMENT 010-20.6010.450000 142.25 SAM'S CLUB INV0002750 04/08/2017 CLOROX WIPES 010-20.6010.580000 10.68 CITY OF WAUKEE MAR17601 03/31/2017 MARCH'17 STATEMENT 010-20.6010.480000 1,146.23 AT&T MOBILITY X04082017 04/08/2017 APRIL'17 STATEMENT 010-20.6010.450000 58.13 Department 6010 - PUBLIC WORKS BUILDING Total: 7,431.02 Department: 6150 - PUBLIC WORKS MECHANIC HOTSY CLEANING SYSTEMS, I 0172157-IN 03/28/2017 REEL 360 PIVOT/BRACKET 010-20.6150.570130 387.88 MARK STUCHEL INC. 03241746472 03/24/2017 6PT 5/16"DP SKT 010-20.6150.590000 44.40 MARK STUCHEL INC. 03311746705 03/31/2017 12PT 10MM SHL SKT 010-20,6150.590000 15.80 MARK STUCHEL INC. 04071746947 04/07/2017 MULTI -PROBE ULTRA 010-20.6150.590000 289.95 HAWKEYE TRUCK EQUIPMEN 125616 03/20/2017 SPINNER HUB/BOLT/NUT/LO 010-20.6150.570130 57.70 HAWKEYETRUCK EQUIPMEN 125707 03/28/2017 BOLT/NUT/WASHER/HYDRA 010-20.6150.570130 301.70 MATHESON TRI-GAS INC 15220709 04/03/2017 CYLINDERS 010-20.6150.590000 47.29 INTERSTATE ALL BATTERY CE 1924601032707 03/27/2017 MARINE/RV BATTERY 010-20.6150.570130 238.70 ARNOLD MOTOR SUPPLY 21-708151 02/15/2017 RETURN AUTO RESIN 010-20.6150.570130 -26.17 ARNOLD MOTOR SUPPLY 21-710417 03/23/2017 PARTS 010-20.6150.570130 19.17 ARNOLD MOTOR SUPPLY 21-710659 03/28/2017 RUB TIP BLO-GU/PLUG 010-20.6150.590000 38.85 ARNOLD MOTOR SUPPLY 21-711063 04/03/2017 GAL VIED REDUCE 010-20.6150.570130 33.85 ARNOLD MOTOR SUPPLY 21-711194 04/05/2017 5G NORSOLV/GAL MAEA/W 010-20.6150.570130 733.81 ARNOLD MOTOR SUPPLY 21-711205 04/05/2017 DAP1690 SELF-E 010-20.6150.570130 17.78 ARNOLD MOTOR SUPPLY 21-711215 04/05/2017 5SANDING BLOCK 010-20.6150.570130 4.99 ARNOLD MOTOR SUPPLY 21-711245 04/05/2017 440MM GR MASK/DAP1690 010-20.6150.570130 25.58 ARNOLD MOTOR SUPPLY 21-711314 04/06/2017 PARTS 010-20.6150.570130 64.08 ARNOLD MOTOR SUPPLY 21-711380 04/07/2017 DISP MIX-CUPS/1G WAX GRE 010-20.6150.570130 28.86 ADEL AUTO PARTS 354669 03/22/2017 BRAKE FLUID DOT 3-GAL 010-20,6150.570130 19.99 ADEL AUTO PARTS 354670 03/22/2017 OIL FILTER 010-20,6150.570110 8.94 ADEL AUTO PARTS 354793 03/24/2017 BOLT 010-20.6150.570130 0.74 ADEL AUTO PARTS 354874 03/27/2017 SPARK PLUG 010-20.6150.570130 6.63 ADEL AUTO PARTS 354888 03/27/2017 YEL WING TIP PLOW LIGHT 010-20.6150.570130 540.54 ADEL AUTO PARTS 354944 03/28/2017 AIR FILTER 010-20.6150.570110 21.20 ADEL AUTO PARTS 355272 04/04/2017 ADAPTER/AIRCHUCK/GAUGE O10-20.6150.590000 50.63 ADEL AUTO PARTS 355324 04/04/2017 OIL FILTERS 010-20.6150.570110 115.73 ADEL AUTO PARTS 355473 04/06/2017 AIR FILTER/FUEL FILTER 010-20.6150.570110 25.84 ADEL AUTO PARTS 355474 04/06/2017 OIL FILTER 010-20.6150.570110 15.28 ADEL AUTO PARTS 355508 04/07/2017 AIR FILTER 010-20.6150.570110 22.94 ADEL AUTO PARTS 355530 04/07/2017 OIL FILTER 010-20.6150.570110 10.86 ADEL AUTO PARTS 355534 04/07/2017 ADAPTER 010-20.6150.590000 4.66 TOMPKINS INDUSTRIES 403483709 03/28/2017 PARTS 010-20.6150.570130 7.20 MATHESON TRI-GAS INC 51158888 03/31/2017 CYLINDERS 010-20.6150.590000 103.26 MUTUAL OF OMAHA G24443078 04/01/2017 APR'17 LIFE & DISABILITY PR 010-20.6150.100000 5.20 MUTUAL OF OMAHA 624443078 04/O1/2017 APR'17 LIFE & DISABILITY PR 010-20.6150.100100 72.81 RCWELDING 667 03/10/2017 1.25X1.25X34 GA SQTUBE 010-20.6150.570130 51.36 MENARDS 75180 03/28/2017 CAST UTILITY PUMP/DUSTER 010-20.6150.570130 120.25 MENARDS 75577 03/31/2017 GRILLCOVER 010-20.6150.590000 34.99 LAWSON PRODUCTS INC 9304788443 03/14/2017 HARDFLEX BAND SAW BLAD 010-20.6150.590000 87.73 LAWSON PRODUCTS INC 9304837345 04/03/2017 THIN HEAT SHRINK TUBE/W 010-20.6150.590000 560.37 EMPLOYEE BENEFITSYSTEM 9793 04/11/2017 MAY'17 HEALTH INSURANC 010-20.6150.100000 1,977.15 TERMINAL SUPPLY CO. 98524-00 03/28/2017 RIGID LIGHT 010-20.6150.570130 337.44 C2G CORPORATION CG4995 03/30/2017 REDTHUNDER/CARB CLEAN 010-20.6150.590000 176.46 C2G CORPORATION CG5037 04/05/2017 PATCH 010-20.6150.570130 48.55 MIDWEST UNDERGROUND S ID25214 03/23/2017 HOUSINGAIR 010-20.6150.570130 525.25 MIDWEST UNDERGROUND S ID25221 03/21/2017 FUEL FILTER 010-20.6150.570110 30.15 WAUKEE HARDWARE & VARI INV0002707 03/31/2017 MARCH'17 STATEMENT PW 010-20.6150.590000 18.07 WAUKEE HARDWARE & VARI INV0002707 03/31/2017 MARCH'17 STATEMENT PW 010-20.6150.590000 33.32 4/12/2017 2:36:08 PM Page 6 of 17 Expense Approval Register Packet: APPKTOO559 - MARCH 18TH COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount HEARTLAND CO-OP INV0002716 03/31/2017 MARCH'17 STATEMENT -M 010-20.6150.570000 140.50 AMERITAS LIFE INSURANCE INV0002739 04/O1/2017 APR'17 VISION INSURANCE 010-20.6150.100000 37.92 O'HALLORAN INTERNATION X100261280:01 03/27/2017 UNLOADER KIT 010-20.6150.570130 15.19 O'HALLORAN INTERNATION X100261305:01 03/27/2017 HOSE 010-20.6150.570130 59.97 O'HALLORAN INTERNATION X100261428:01 03/28/2017 SWITCH PRESSURE/GOV ASS 010-20.6150.570130 73.28 O'HALLORAN INTERNATION X100261839:01 03/31/2017 COMPRESSOR 010-20.6150.570130 826.71 O'HALLORAN INTERNATION X100261969:01 04/03/2017 COMPRESSOR 010-20.6150.570130 -404.40 O'HALLORAN INTERNATION X100262315:01 04/05/2017 TUBE OIL LEVELGAUGE/CLA 010-20.6150.570130 59.26 Department 6150 - PUBLIC W ORKS MECHANIC Total: 8,166.19 Department: 6510- WATER UTILITY MUNICIPAL SUPPLY, INC. 0652008-IN 03/28/2017 8"MACRO COUPLING 510-30.6510.410100 576.00 BLUE OCEANS SATELLITE SYS 10546 11/21/2016 CHAMELEON CTM - 200 MO 510-30.6510,340000 3,304.15 BLUE OCEANS SATELLITE SYS 10723 12/16/2016 GPS TRACKING UNIT/PASST 510-30.6510,340000 183.02 IOWA ONE CALL 189714 04/07/2017 MARCH'17 STATEMENT 510-30.6510.340000 265.60 OLSOWS BODY &PAINT, INC 3437 03/20/2017 REPLACE WINDSHIELD 510-30.6510.410000 218.13 PLUMB SUPPLY COMPANY 4443796 03/22/2017 ZOELLER SUMP PUMP 510-30.6510.590000 255.80 MUTUAL OF OMAHA 624443078 04/O1/2017 APR'17 LIFE & DISABILITY PR 510-30.6510.100000 2.60 MUTUAL OF OMAHA 624443078 04/01/2017 APR'17 LIFE & DISABILITY PR 510-30.6510.100000 25.20 MUTUAL OF OMAHA 624443078 04/01/2017 APR'17 LIFE & DISABILITY PR 510-30.6510.100000 1.30 MUTUAL OF OMAHA 624443078 04/01/2017 APR'17 LIFE & DISABILITY PR 510-30.6510.100000 19.40 MUTUAL OF OMAHA 624443078 04/01/2017 APR'17 LIFE & DISABILITY PR 510-30.6510.100100 58.24 MUTUAL OF OMAHA 624443078 04/01/2017 APR'17 LIFE & DISABILITY PR 510-30.6510.100100 3.86 MUTUAL OF OMAHA 624443078 04/01/2017 APR'17 LIFE & DISABILITY PR 510-30.6510.100100 48.73 MUTUAL OF OMAHA 624443078 04/01/2017 APR'17 LIFE & DISABILITY PR 510-30.6510.100100 45.84 EMPLOYEE BENEFIT SYSTEM 9793 04/11/2017 MAY'17 HEALTH INSURANC 510-30.6510.100000 494.29 EMPLOYEE BENEFIT SYSTEM 9793 04/11/2017 MAY'17 HEALTH INSURANC 510-30.6510.100000 710.17 EMPLOYEE BENEFIT SYSTEM 9793 04/11/2017 MAY'17 HEALTH INSURANC 510-30.6510.100000 1,931.35 EMPLOYEE BENEFIT SYSTEM 9793 04/11/2017 MAY'17 HEALTH INSURANC 510-30.6510.100000 1,420.34 DES MOINES WATERWORKS INV0002698 03/27/2017 MARCH'17 STATEMENT 510-30.6510.650000 47,076.48 DES MOINES WATERWORKS INV0002699 03/27/2017 MARCH'17 STATEMENT 510-30.6510.650000 5,353.24 WAUKEE HARDWARE & VARI INV0002707 03/31/2017 MARCH'17 STATEMENT PW 510-30.6510.590000 31.92 HEARTLAND CO-OP INV0002713 03/31/2017 MARCH'17 STATEMENT -W 510-30.6510.570000 674.16 WEST DES MOINES WATER INV0002726 04/18/2017 APRIL'17 WATER TOWER RE 510-30.6510.390300 364.50 IOWA DEPT OF NATURAL RE INV0002735 04/05/2017 EXAM-ALDRICH 510-30,6510.470000 30.00 IOWA DEPT OF NATURAL RE INV0002736 04/05/2017 EXAM-WASKE 510-30.6510.470000 30.00 IOWA DEPT OF NATURAL RE INV0002737 04/05/2017 EXAM - ROVER 510-30.6510.470000 30.00 AMERITAS LIFE INSURANCE INV0002739 04/O1/2017 APR'17 VISION INSURANCE 510-30.6510.100000 13.62 AMERITAS LIFE INSURANCE INV0002739 04/O1/2017 APR'17 VISION INSURANCE 510-30.6510.100000 34.60 AMERITAS LIFE INSURANCE INV0002739 04/O1/2017 APR'17 VISION INSURANCE 510-30.6510.100000 7.82 AMERITAS LIFE INSURANCE INV0002739 04/01/2017 APR'17 VISION INSURANCE 510-30.6510.100000 20.60 ACCESS SYSTEMS INV496462 01/27/2017 MONITORING COMP & PHO 510-30.6510.270100 305.99 ACCESS SYSTEMS INV508311 03/21/2017 MARCH'17 SERVICE FEE 510-30.6510.270100 821.79 CITY OF WAUKEE MAR17651 03/31/2017 MARCH'17 STATEMENT 510-30.6510.480000 143.81 MID AMERICAN ENERGY MARCH 176510SUMBILL 03/27/2017 MARCH'17 STATEMENT 510-30.6510.480000 764.68 Department 6510 - WATER UTILITY Total: 65,267.23 Department: 6520 - SANITARY SEWERS & TREATMENT BLUE OCEANS SATELLITE SYS 10546 11/21/2016 CHAMELEON CTM-200 MO 520-30.6520.340000 3,304.15 BLUE OCEANS SATELLITE SYS 10723 12/16/2016 GPS TRACKING UNIT/PASST 520-30.6520.340000 183.01 EMERGENCY MEDICAL PROD 1897637 03/31/2017 GLOVES 520-30.6520.590000 246.10 MIDWEST ENVIRONMENTAL 20170247 03/25/2017 WASTEWATER SAMPLE ANA 520-30.6520.250000 1,895.00 UNITYPOINT CLINIC-OCCUPA 203250 04/04/2017 DRUG TESTING - ELLIOT&H 520-30.6520.470000 37.00 USA BLUE BOOK 217462 03/28/2017 BUFFER POUCHES/PD-XD LU 520-30.6520.411300 944.52 OLSON'S BODY & PAINT, INC 3437 03/20/2017 REPLACE WINDSHIELD 520-30.6520.410000 218.12 MID-IOWA SOLID WASTE EQ 43709 03/28/2017 LEADER HOSE 520-30.6520.410400 176.71 MUTUALOF OMAHA 624443078 04/01/2017 APR'17 LIFE & DISABILITY PR 520-30.6520.100000 5.20 MUTUALOF OMAHA 624443078 04/O1/2017 APR'17 LIFE & DISABILITY PR 520-30.6520.100000 1.30 MUTUALOF OMAHA 624443078 04/01/2017 APR'17 LIFE & DISABILITY PR 520-30.6520.100000 1.30 MUTUAL OF OMAHA 624443078 04/01/2017 APR'17 LIFE & DISABILITY PR 520-30.6520.100000 5.20 MUTUAL OF OMAHA 624443078 04/O1/2017 APR'17 LIFE & DISABILITY PR 520-30.6520.100100 3.97 MUTUAL OF OMAHA 624443078 04/O1/2017 APR'17 LIFE & DISABILITY PR 520-30.6520.100100 15.42 4/12/2017 2:36:08 PM Page 7 of 17 Expense Approval Register Packet: APPKT00559 - MARCH 18TH COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount MUTUAL OF OMAHA 624443078 04/O1/2017 APR'17 LIFE & DISABILITY PR 520-30.6520.100100 71.62 MUTUAL OF OMAHA 624443078 04/O1/2017 APR'17 LIFE & DISABILITY PR 520-30.6520.100100 3.86 AHLERS & COONEY PC 723263 01/04/2017 2016C FEES 520-30.6520.930300 13,656.97 AHLERS & COONEY PC 726919 03/30/2017 NW AREA TRUNK SEWER EX 520-30.6520.883091 1,800.00 MENARDS 75304 03/29/2017 SWIFFER DUSTER REFILL/05 520-30.6520.590000 59.17 ENVIRONMENTAL RESOURC 824054 03/28/2017 SETTLEABLE SOLIDS/PH WAT 520-30.6520.250000 314.24 EMPLOYEE BENEFITSYSTEM 9793 04/11/2017 MAY'17 HEALTH INSURANC 520-30.6520.100000 1,931.35 EMPLOYEE BENEFITSYSTEM 9793 04/11/2017 MAY'17 HEALTH INSURANC 520-30.6520.100000 2,657.48 EMPLOYEE BENEFITSYSTEM 9793 04/11/2017 MAY'17 HEALTH INSURANC 520-30.6520.100000 494.29 EMPLOYEE BENEFITSYSTEM 9793 04/11/2017 MAY'17 HEALTH INSURANC 520-30.6520.100000 710.17 WAUKEE HARDWARE & VARI INV0002707 03/31/2017 MARCH'17 STATEMENT PW 520-30.6520.590000 35.86 WAUKEE HARDWARE & VARI INV0002707 03/31/2017 MARCH'17 STATEMENT PW 520-30.6520.590000 14.97 HEARTLAND CO-OP INV0002714 03/31/2017 MARCH'17 STATEMENT - SE 520-30.6520.570000 374.31 CONSOLIDATED COMMUNIC INV0002734 04/08/2017 APRIL'17 STATEMENT 520-30.6520.450000 145.20 AMERITAS LIFE INSURANCE INV0002739 04/O1/2017 APR'17 VISION INSURANCE 520-30.6520.100000 13.62 AMERITAS LIFE INSURANCE INV0002739 04/O1/2017 APR'17 VISION INSURANCE 520-30.6520.100000 34.60 AMERITAS LIFE INSURANCE INV0002739 04/O1/2017 APR'17 VISION INSURANCE 520-30.6520.100000 41.20 AMERITAS LIFE INSURANCE INV0002739 04/O1/2017 APR'17 VISION INSURANCE 520-30.6520,100000 7.82 ACCESS SYSTEMS INV496462 01/27/2017 MONITORING COMP & PHO 520-30.6520.270100 251.63 ACCESS SYSTEMS INV508311 03/21/2017 MARCH'17 SERVICE FEE 520-30.6520.270100 675.79 CITY OF WAUKEE MAR17652 03/31/2017 MARCH'17 STATEMENT 520-30.6520.480000 1,145.22 CITY OF WAUKEE MAR17652 03/31/2017 MARCH'17 STATEMENT 520-30.6520.480000 17.24 CITY OF WAUKEE MAR17652 03/31/2017 MARCH'17 STATEMENT 520-30.6520.480000 45.83 MID AMERICAN ENERGY MARCH 176520SUMBI ILL 03/27/2017 MARCH'17 STATEMENT 520-30.6520.480000 7,539.56 Department 6520 - SANITARY SE W ERS & TREATMENT Total: 39,079.00 Department: 6540 - GAS UTILITY BLUE OCEANS SATELLITE SYS 10546 11/21/2016 CHAMELEON CTM-200 MO 540-30.6540.340000 3,304.15 BLUE OCEANS SATELLITE SYS 10723 12/16/2016 GPS TRACKING UNIT/PASST 540-30.6540.340000 183.02 SUBSURFACE SOLUTIONS LL 11403 03/24/2017 TX DIRECT CONNECTION LEA 540-30.6540.410200 156.15 IOWA ONE CALL 189714 04/07/2017 MARCH'17 STATEMENT 540-30.6540.340000 265.60 JOHNSTONE SUPPLY 3111434 04/04/2017 GAS PRESS TEST KIT 540-30.6540.590000 142.62 MUTUALOF OMAHA 624443078 04/01/2017 APR'17 LIFE & DISABILITY PR 540-30.6540.100000 92.30 MUTUALOF OMAHA 624443078 04/01/2017 APR'17 LIFE & DISABILITY PR 540-30.6540.100000 1.30 MUTUAL OF OMAHA 624443078 04/01/2017 APR'17 LIFE & DISABILITY PR 540-30.6540.100000 1.30 MUTUAL OF OMAHA 624443078 04/01/2017 APR'17 LIFE & DISABILITY PR 540-30.6540.100100 3.97 MUTUAL OF OMAHA 624443078 04/01/2017 APR'17 LIFE & DISABILITY PR 540-30.6540.100100 3.86 MUTUAL OF OMAHA 624443078 04/01/2017 APR'17 LIFE & DISABILITY PR 540-30.6540.100100 69.50 MENARDS 75359 03/29/2017 DISCHARGE HOSE ASSEMBLY 540-30.6540.590000 29.99 INDUSTRIAL SALES COMPAN 974659-000 03/21/2017 WIRE TRACER 540-30.6540.590200 1,400.17 EMPLOYEE BENEFITSYSTEM 9793 04/11/2017 MAY'17 HEALTH INSURANC 540-30.6540.100000 494.29 EMPLOYEE BENEFITSYSTEM 9793 04/11/2017 MAY'17 HEALTH INSURANC 540-30.6540.100000 5,681.36 EMPLOYEE BENEFITSYSTEM 9793 04/11/2017 MAY'17 HEALTH INSURANC 540-30.6540.100000 710.16 CLAYTON ENERGY CORPORA 9834 04/03/2017 MARCH'17 RESERVATION 540-30.6540.650000 104,584.30 FASTENALCOMPANY IAGRM86514 03/29/2017 1/4-20X1-3/4 SHCS 540-30.6540.590000 0.88 UTILITY SAFETY AND DESIGN M20170895 03/29/2017 MARCH'17 RETAINER FEES 540-30.6540.230000 175.00 WAUKEE HARDWARE & VARI INV0002707 03/31/2017 MARCH'17 STATEMENT PW 540-30.6540,590000 17.11 HEARTLAND CO-OP INV0002712 03/31/2017 MARCH'17 STATEMENT - GA 540-30.6540.570000 487.50 PETER ROLWES INV0002720 04/18/2017 FURNACE REBATE 540-30.6540.685400 75.00 WEST DES MOINES WATER INV0002726 04/18/2017 APRIL'17 WATER TOWER RE 540-30.6540.390300 364.50 CONSOLIDATED COMMUNIC INV0002734 04/08/2017 APRIL'17 STATEMENT 540-30.6540.450000 72.60 AMERITAS LIFE INSURANCE INV0002739 04/O1/2017 APR'17 VISION INSURANCE 540-30.6540.100000 7.82 AMERITAS LIFE INSURANCE INV0002739 04/O1/2017 APR'17 VISION INSURANCE 540-30.6540,100000 13.62 AMERITAS LIFE INSURANCE INV0002739 04/01/2017 APR'17 VISION INSURANCE 540-30.6540.100000 109.96 BLACK HILLS ENERGY INV0002743 03/20/2017 MONTHLY FEE'17 540-30.6540.650000 2,891.25 BLACK HILLS ENERGY INV0002743 03/20/2017 MONTHLY FEE DEC'16 540-30.6540.650000 2,891.25 BLACK HILLS ENERGY INV0002743 03/20/2017 MONTHLY FEE JAN'17 540-30.6540.650000 2,891.25 KAY MURPHY INV0002744 04/18/2017 FURNACE REBATE 540-30.6540.685400 75.00 CHUCK &JENNY DENOUDEN INV0002745 04/18/2017 FURNACE REBATE 540-30.6540.685400 75.00 DAN REINDERS INV0002746 04/18/2017 FURNACE& THERMOSTAT R 540-30.6540.685400 180.00 ACCESS SYSTEMS INV496462 01/27/2017 MONITORING COMP & PHO 540-30.6540.270100 392.01 4/12/2017 2:36:08 PM Page 8 of 17 Expense Approval Register Packet: APPKT00559 - MARCH 18TH COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount ACCESS SYSTEMS INV508311 03/21/2017 MARCH'17 SERVICE FEE 540-30.6540.270100 1,052.83 MID AMERICAN ENERGY MARCH 176540SUMBILL 03/27/2017 MARCH'17 STATEMENT 540-30.6540.480000 83.21 MIDWEST UNDERGROUND S RD16040 03/29/2017 BOLTS/NUT/PARTS 540-30.6540.410100 706.33 Department 6540 - GAS UTILITY Total: 129,685.16 Department: 6550- UTILITY BILLING MUTUAL OF OMAHA 624443078 04/01/2017 APR'17 LIFE & DISABILITY PR 570-30.6550.100000 74.70 MUTUAL DF OMAHA 624443078 04/O1/2017 APR'17 LIFE & DISABILITY PR 570-30.6550.100100 15.78 OFFICE DEPOT 916391021001 03/29/2017 ENVELOPES/WRITE ON TABS 570-30.6550.580000 56.14 EMPLOYEE BENEFITSYSTEM 9793 04/11/2017 MAY'17 HEALTH INSURANC 570-30.6550.100000 1,977.15 AMERITAS LIFE INSURANCE INV0002739 04/01/2017 APR'17 VISION INSURANCE 570-30.6550.100000 37.92 ACCESS SYSTEMS INV496462 01/27/2017 MONITORING COMP & PHO 570-30.6550.270100 22.20 ACCESS SYSTEMS INV508311 03/21/2017 MARCH'17 SERVICE FEE 570-30.6550.270100 59.62 Department 6550 - UTILITY BILLING Total: 2,243.51 Department: 7100 - STREETS US CELLULAR 0182793212 03/14/2017 MARCH'17 STATEMENT 060-30.7100.450000 503.94 BOLTON & MENK, INC 0201188 03/21/2017 LITTLE WALNUT CREEK DRIV 060-30.7100.230000 6,257.00 BLUE OCEANS SATELLITE SYS 10546 11/21/2016 CHAMELEON CTM-200 MO 060-30.7100.340000 9,912.44 BLUE OCEANS SATELLITE SYS 10723 12/16/2016 GPS TRACKING UNIT/PASST 060-30.7100.340000 549.05 GRIMES ASPHALT & PAVING 12021 03/27/2017 COLD MIX 060-30.7100.590400 1,043.90 MARTIN MARIETTAAGGREG 19931617 03/23/2017 ROADSTONE 060-30.7100.590300 197.43 DALE EDWARDS TRUCKING 1 2925 04/03/2017 HAULING 060-30.7100.590300 101.30 IOWA SIGNAL INC 3527 03/29/2017 INSTLALLED 060-30.7100.410300 761.95 BAX SALES, INC 35856 03/24/2017 WORKMAN PERSONAL FALL 060-30.7100.590000 359.53 BAX SALES, INC 35937 03/30/2017 WEATHER PACK/BOOTS/WIR 060-30.7100.590000 253.70 MULCH MART 38317 03/27/2017 ROCK SALT 060-30.7100.591200 649.61 PLUMB SUPPLY COMPANY 4455499 03/29/2017 SAW BLADE/UTILITY KNIFE 060-30.7100.590000 15.99 CLIVE POWER EQUIPMENT 597171 03/28/2017 HAND HELD BLOWER 060-30.7100.590000 199.96 MUTUAL OF OMAHA 624443078 04/01/2017 APR'17 LIFE & DISABILITY PR 060-30.7100.100000 7.30 MUTUAL OF OMAHA 624443078 04/O1/2017 APR'17 LIFE & DISABILITY PR 060-30.7100.100000 0.26 MUTUAL OF OMAHA 624443078 04/01/2017 APR'17 LIFE & DISABILITY PR 060-30.7100.100000 47.80 MUTUAL OF OMAHA 624443078 04/01/2017 APR'17 LIFE & DISABILITY PR 060-30.7100.100100 118.37 MUTUAL OF OMAHA 624443078 04/01/2017 APR'17 LIFE & DISABILITY PR 060-30.7100.100100 17.34 MUTUAL OF OMAHA 624443078 04/01/2017 APR'17 LIFE & DISABILITY PR 060-30.7100.100100 0.90 MENARDS 75180 03/28/2017 CAST UTILITY PUMP/DUSTER 060-30.7100.590000 127.16 MENARDS 75181 03/28/2017 MORTAR MIX/RUBBER FLOA 060-30.7100.590000 29.68 IOWA PRISON INDUSTRIES 943291 03/22/2017 SIGNS 060-30.7100.590600 1,577.35 IOWA PRISON INDUSTRIES 943456 03/31/2017 SIGNS 060-30.7100.590600 108.80 EMPLOYEE BENEFITSYSTEM 9793 04/11/2017 MAY'17 HEALTH INSURANC 060-30.7100.100000 142.03 EMPLOYEE BENEFITSYSTEM 9793 04/11/2017 MAY'17 HEALTH INSURANC 060-30.7100.100000 710.17 EMPLOYEE BENEFITSYSTEM 9793 04/11/2017 MAY'17 HEALTH INSURANC 060-30.7100.100000 4,817.83 WAUKEE HARDWARE & VAR] INV0002707 03/31/2017 MARCH'17 STATEMENT PW 060-30.7100.590000 25.72 HEARTLAND CO-OP INV0002715 03/31/2017 MARCH'17 STATEMENT -ST 060-30.7100.570000 772.37 AMERITAS LIFE INSURANCE INV0002739 04/O1/2017 APR'17 VISION INSURANCE 060-30.7100.100000 1.07 AMERITAS LIFE INSURANCE INV0002739 04/O1/2017 APR'17 VISION INSURANCE 060-30.7100.100000 13.62 AMERITAS LIFE INSURANCE INV0002739 04/01/2017 APR'17 VISION INSURANCE 060-30.7100.100000 92.40 ACCESS SYSTEMS INV496462 01/27/2017 MONITORING COMP & PHO 060-30.7100.270100 132.80 ACCESS SYSTEMS INV508311 03/21/2017 MARCH'17 SERVICE FEE 060-30.7100.270100 356.66 Department 7100 - STREETS Total: 29,905.43 Department: 7730 - SE WESTOWN PKWY CONSTRUCTION SHIVE HATTERY INC. 4151850-16 04/05/2017 WESTOWN PARKWAY/R221 327-90.7730.235100 1,177.37 Department 7730 -SE WESTOWN PKWY CONSTRUCTION Total: 1,177.37 Department: 7850 -TIF DEBT SERVICE AHLERS & COONEY PC 726716 03/27/2017 GATEWAY 094-30.7850.230000 1,644.00 Department 7850 - TIF DEBT SERVICE Total: 1,644.00 Department: 8030 - DEVELOPER REIMBURSEMENT PROJECTS FOTH INFRASTRUCTURE & E 51745 03/24/2017 SE ALICES RD/SE UNIV AVE/S 327-90.8030.230000 20,985.30 Department 8030 - DEVELOPER REIMBURSEMENT PROJECTS Total: 20,985.30 4/12/2017 2:36:08 PM Page 9 of 17 Expense Approval Register Packet: APPKT00559 - MARCH 18TH COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount Department: 8100 - MAYOR & COUNCIL AAA AWARDS & EMBROIDER 8768 03/29/2017 PLAQUE FOR MAYOR 010-60.8100.580000 6.80 Department 8100 - MAYOR & COUNCIL Total: 6.80 Department: 8200 - COMMUNICATIONS 3CMA 3CMA-2017 03/23/2017 AWARD PRINTING FOR P&R 010-60.8200.470000 93.00 MUTUALOF OMAHA 624443078 04/O1/2017 APR'17 LIFE & DISABILITY PR 010-60.8200.100000 7.80 MUTUALOF OMAHA 624443078 04/01/2017 - APR'17 LIFE & DISABILITY PR 010-60.8200.100100 33.60 EMPLOYEE BENEFIT SYSTEM 9793 04/11/2017 MAY'17 HEALTH INSURANC 010-60.8200.100000 1,420.34 AMERITAS LIFE INSURANCE INV0002739 04/O1/2017 APR'17 VISION INSURANCE 010-60.8200.100000 27.24 Department 8200 - COMMUNICATIONS Total: 1,581.98 Department: 8300 - ADMINISTRATION UNITED PARCEL SERVICE OOOOAW7647127 03/25/2017 SHIPPING 010-60.8300.360000 70.37 DES MOINES STAMP MFG C 1093155 04/04/2017 NOTARY STAMP - SCHUETT 010-60.8300.580000 31.80 WAUKEE ROTARY CLUB 5103 04/10/2017 MEMBER DUES - MOERMAN 010-60.8300.280000 225.00 MUTUAL OF OMAHA 624443078 04/O1/2017 APR'17 LIFE & DISABILITY PR 010-60.8300.100000 54.80 MUTUAL OF OMAHA 624443078 04/O1/2017 APR'17 LIFE & DISABILITY PR 010-60.8300.100100 28.66 OFFICE DEPOT 914157232001 03/20/2017 PAPER/CREAMER 010-60.8300.580000 75.40 OFFICE DEPOT 916391021001 03/29/2017 ENVELOPES/WRITE ON TABS 010-60.8300.580000 9.49 EMPLOYEE BENEFIT SYSTEM 9793 04/11/2017 MAY'17 HEALTH INSURANC 010-60.8300.100000 2,749.08 IOWA COUNCIL OF FOUNDA INV0002723 04/04/2017 BOOT CAMP - DON BLUM 010-60.8300.470000 250.00 MEDIACOM INV0002738 03/28/2017 MARCH'17 STATEMENT 010-60.8300.270000 139.95 AMERITAS LIFE INSURANCE INV0002739 04/O1/2017 APR'17 VISION INSURANCE 010-60.8300.100000 47.84 WAUKEE LEADERSHIP INSTIT INV0002741 04/10/2017 FY2017 CONTRIBUTION 010-60.8300.459000 4,000.00 CARNEY&APPLEBY, P.L.C. INV0002749 04/11/2017 LOBBYING 010-60.8300.230000 5,000.00 ACCESS SYSTEMS INV496462 01/27/2017 MONITORING COMP & PHO 010-60.8300.270100 897.74 ACCESS SYSTEMS INV508311 03/21/2017 MARCH'17 SERVICE FEE 010-60.8300.270100 2,411.10 CITY OF WAUKEE MAR17830NV 03/31/2017 MARCH'17 STATEMENT 010-60.8300.390400 64.11 CITY OF WAUKEE MAR17830NV 03/31/2017 MARCH'17 STATEMENT 010-60.8300.390400 56.79 Department 8300 -ADMINISTRATION Total: 16,112.13 Department: 8310 - CITY HALL G & K SERVICES INC 1183690382 04/05/2017 MAT SERVICES - CITY HALL 010-60.8310.400000 36.00 OFFICE DEPOT 914157232001 03/20/2017 PAPER/CREAMER 010-60.8310.590000 13.14 OFFICE DEPOT 915985518001 03/24/2017 COFFEE/PLATES 010-60.8310.590000 47.60 ALLIANCE CONNECT INV0002696 04/01/2017 APRIL'17 STATEMENT 010-60.8310.450000 49.00 CONSOLIDATED COMMUNIC INV0002734 04/08/2017 APRIL'17 STATEMENT 010-60.8310,450000 216.70 CONSOLIDATED COMMUNIC INV0002734 04/08/2017 APRIL'17 STATEMENT 010-60.8310.450000 344.74 CITY OF WAUKEE MAR17831 03/31/2017 MARCH'17 STATEMENT 010-60.8310.480000 62.08 CITY OF WAUKEE MAR17831 03/31/2017 MARCH'17 STATEMENT 010-60.8310.480000 257.06 CITY OF WAUKEE MAR17831CAM 03/31/2017 MARCH'17 STATEMENT 010-60.8310.390600 238.80 CITY OF WAUKEE MAR17831CAM 03/31/2017 MARCH'17 STATEMENT 010-60.8310.390600 62.97 MID AMERICAN ENERGY MARCH178310SUMBILL 03/27/2017 MARCH'17 STATEMENT 010-60.8310.480000 411.83 Department 8310 - CITY HALL Total: 1,739.92 Department: 8350 - HUMAN RESOURCES ACCESS SYSTEMS LEASING 20392376 03/27/2017 COPIER/PRINTER LEASE 010-60.8350.270110 420.56 CHRISTIAN PRINTERS INC 35981 02/20/2017 HR#10 ENVELOPE 010-60.8350.350100 129.00 MUTUAL OF OMAHA 624443078 04/O1/2017 APR'17 LIFE & DISABILITY PR 010-60.8350.100000 2.60 MUTUAL OF OMAHA 624443078 04/O1/2017 APR'17 LIFE & DISABILITY PR 010-60.8350.100100 74.24 EMPLOYEE BENEFIT SYSTEM 9793 04/11/2017 MAY'17 HEALTH INSURANC 010-60.8350.100000 556.81 AMERITAS LIFE INSURANCE INV0002739 04/O1/2017 APR'17 VISION INSURANCE 010-60.8350.100000 10.68 ACCESS SYSTEMS INV496462 01/27/2017 MONITORING COMP & PHO 010-60.8350.270100 4.77 ACCESS SYSTEMS INV508311 03/21/2017 MARCH'17 SERVICE FEE 010-60.8350.270100 12.82 Department 83SO - HUMAN RESOURCES Total: 1,221.48 Department: 8400 - FINANCIAL ADMINISTRATION MUTUAL OF OMAHA 624443078 04/01/2017 APR'17 LIFE & DISABILITY PR 010-60.8400.100000 13.80 MUTUAL OF OMAHA 624443078 04/O1/2017 APR'17 LIFE & DISABILITY PR 010-60.8400.100100 77.45 EMPLOYEE BENEFIT SYSTEM 9793 04/11/2017 MAY'17 HEALTH INSURANC 010-60.8400.100000 3,305.89 AMERITAS LIFE INSURANCE INV0002739 04/O1/2017 APR'17 VISION INSURANCE 010-60.8400.100000 58.52 ACCESS SYSTEMS INV496462 01/27/2017 MONITORING COMP & PHO 010-60.8400.270100 11.97 ACCESS SYSTEMS INV508311 03/21/2017 MARCH'17 SERVICE FEE 010-60.8400.270100 32.15 4/12/201/ 2:36:08 PM Page 10 of 17 Expense Approval Register Packet: APPKT00559 - MARCH 18TH COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount STOREY-KENWORTHY COMP PINV468299 03/06/2017 PAPER 19HOLE 010-60.8400.580000 122.28 Department 8400 - FINANCIAL ADMINISTRATION Total: 3,622.06 Department: 8500 - COMMUNITY DEVELOPMENT WAUKEE ROTARY CLUB 5084 04/10/2017 MEMBER DUES - DUTCHER 010-50.8500.280000 225.00 MUTUAL OF OMAHA 624443078 04/O1/2017 APR'17 LIFE & DISABILITY PR 010-50.8500.100000 5.20 MUTUAL OF OMAHA 624443078 04/O1/2017 APR'17 LIFE & DISABILITY PR 010-50.8500.100100 23.68 EMPLOYEE BENEFITSYSTEM 9793 04/11/2017 MAY'17 HEALTH INSURANC 010-50.8500.100000 2,613.78 UNIVERSITY OF IOWA, VENT INVO002706 04/07/2017 VENTURE SCHOOL PROGRA 010-50.8500.210100 500.00 AMERITAS LIFE INSURANCE INVO002739 04/01/2017 APR'17 VISION INSURANCE 010-50.8500.100000 37.92 ACCESS SYSTEMS INV496462 01/27/2017 MONITORING COMP &PHO 010-50.8500.270100 18.36 ACCESS SYSTEMS INV508311 03/21/2017 MARCH'17 SERVICE FEE 010-50.8500.270100 49.30 Department 8500 - COMMUNITY DEVELOPMENT Total: 3,473.24 Department: 8600 - CITY ATTORNEY BRICK GENTRY BOWERS SW 227356 03/25/2017 MARCH'17 STATEMENT 010-60.8600.230000 13,057.32 AHLERS & COONEY PC 726713 03/27/2017 PROJECT 28E AGREEMENT 010-60.8600.230000 801.00 Department 8600 - CITY ATTORNEY Total: 13,858.32 Department: 8700 - DEVELOPMENT SERVICES MUTUALOF OMAHA 624443078 04/O1/2017 APR'17 LIFE & DISABILITY PR 010-50.8700.100000 57.40 MUTUALOF OMAHA 624443078 04/O1/2017 APR'17 LIFE & DISABILITY PR 010-50.8700.100100 51.27 EMPLOYEE BENEFIT SYSTEM 9793 04/11/2017 MAY'17 HEALTH INSURANC 010-50.8700.100000 3,397.49 AMERITAS LIFE INSURANCE INV0002739 04/01/2017 APR'17 VISION INSURANCE 010-50.8700.100000 65.16 ACCESS SYSTEMS INV496462 01/27/2017 MONITORING COMP & PHO 010-50.8700.270100 32.18 ACCESS SYSTEMS INV508311 03/21/2017 MARCH'17 SERVICE FEE 010-50.8700.270100 86.43 MOLLY OLSON M2010 03/O1/2017 COMP PLAN LOGO DESIGN 010-50.8700.230000 152.00 Department 8700 - DEVELOPMENT SERVICES Total: 3,841.93 Department: 8750 - SUGAR CREEK MUNICIPAL BOLTON & MENK, INC 0201189 03/21/2017 GOLF COURSE BRIDGE 750-80.8750.880070 3,301.00 UNITYPOINT CLINIC-OCCUPA 203250 04/04/2017 DRUG TESTING - ELLIOT&H 750-80.9750.470000 37.00 DIRECTV 31050844698 03/31/2017 ANNUAL SUBSCRIPTION 750-80.8750.400000 1,698.91 MUTUAL OF OMAHA 624443078 04/O1/2017 APR'17 LIFE & DISABILITY PR 750-80.8750.100000 1.82 MUTUAL OF OMAHA 624443078 04/O1/2017 APR'17 LIFE & DISABILITY PR 750-80.8750.100100 6.32 AHLERS & COONEY PC 726921 03/30/2017 SUGAR CREEK GOLF COURSE 750-80.8750.880070 1,800.00 LAWSON PRODUCTS INC 9304798182 03/17/2017 CARTRIDGE ORGANIC VAPID 750-80.8750.590000 101.04 LAWSON PRODUCTS INC 9304801602 03/20/2017 SPF40 TOWELETTES 750-80.8750.590000 60.00 EMPLOYEE BENEFIT SYSTEM 9793 04/11/2017 MAY'17 HEALTH INSURANC 750-80.8750.100000 994.24 WAUKEE HARDWARE & VARI INV0002719 03/31/2017 MARCH'17 STATEMENT - PA 750-80.8750.400000 147.66 AMERITAS LIFE INSURANCE INV0002739 04/O1/2017 APR'17 VISION INSURANCE 750-80.8750,100000 7.48 BOB NEWSUM INV0002742 04/18/2017 SEASON PASS REFUND 750-80.8750.4600200 440.96 SAM'S CLUB INV0002750 04/08/2017 CANDY 750-80.8750.650200 339.77 ACCESS SYSTEMS INV496462 01/27/2017 MONITORING COMP & PHO 750-80.8750.270100 55.81 ACCESS SYSTEMS INV508311 03/21/2017 MARCH'17 SERVICE FEE 750-80.8750.270100 149.89 CITY OF WAUKEE MAR17875 03/31/2017 MARCH'17 STATEMENT 750-80.8750.480000 306.00 MID AMERICAN ENERGY MARCH178750SUMBILL 03/27/2017 MARCH'17 STATEMENT 750-80.8750.480000 290.11 DAVIS EQUIPMENT CORPOR WI10437 03/23/2017 1/2 CIRCLE HEADS SOD GREE 750-80.8750.410350 253.98 DAVIS EQUIPMENT CORPOR W110452 03/28/2017 RIB CS ACME 750-80.8750.410350 352.58 Department 8750 - SUGAR CREEK MUNICIPAL Total: 10,344.57 Department: 8900 - ENGINEERING MUTUAL OF OMAHA 624443078 04/01/2017 APR'17 LIFE & DISABILITY PR 010-20.8900.100000 55.80 MUTUAL OF OMAHA 624443078 04/O1/2017 APR'17 LIFE & DISABILITY PR 010-20.8900.100100 109.70 EMPLOYEE BENEFIT SYSTEM 9793 04/11/2017 MAY'17 HEALTH INSURANC 010-20.8900.100000 3,954.30 HEARTLAND CO-OP INV0002708 03/31/2017 MARCH'17 STATEMENT -EN 010-20.8900.570000 433.08 AMERITAS LIFE INSURANCE INV0002739 04/O1/2017 APR'17 VISION INSURANCE 010-20.8900.100000 75.84 ACCESS SYSTEMS INV496462 01/27/2017 MONITORING COMP & PHO 010-20.8900.270100 37.44 ACCESS SYSTEMS INV508311 03/21/2017 MARCH'17 SERVICE FEE 010-20.8900.270100 100.54 Department 8900 - ENGINEERING Total: 4,766.70 Department: 8950 - ISIS MUTUAL OF OMAHA 624443078 04/01/2017 APR'17 LIFE & DISABILITY PR 010-20.8950.100000 5.00 MUTUAL OF OMAHA 624443078 04/O1/2017 APR'17 LIFE & DISABILITY PR 010-20.8950.100100 9.86 4/12/2017 2:36:08 PM Page 11 of 17 Expense Approval Register Packet: APPKT00559 - MARCH 18TH COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount EMPLOYEE BENEFITSYSTEM 9793 04/11/2017 MAY'17 HEALTH INSURANC 010-20.8950.100000 556.81 AMERITAS LIFE INSURANCE INV0002739 04/O1/2017 APR'17 VISION INSURANCE 010-20.8950.100000 10.68 ACCESS SYSTEMS INV496462 01/27/2017 MONITORING COMP & PHO 010-20.8950.270100 1.95 ACCESS SYSTEMS INV508311 03/21/2017 MARCH'17 SERVICE FEE 010-20.8950.270100 5.24 Department 8950 - GIS Total: 589.54 Grand Total: 1,459,562.37 4/12/2017 2:36:08 PM Page 12 of 17 Expense Approval Register Packet: APPKT00559 - MARCH 18TH COUNCIL PACKET Fund Summary Fund Expense Amount O10 - G ENERAL FU NO 207,935.98 060 - ROAD USE TAX FUND 47,500.52 094 - GATEWAY URBAN RENEWAL 1,644.00 110- DEBT SERVICE FUND 569,450.00 327 - CAPITAL PROJECTS 26,193.17 510- WATER UTILITY FUND 107,632.30 520- WASTE WATER UTILITY FUND 51,417.89 540 - GAS UTILITY FUND 169,553.01 560-STORM WATER UTILITY FUND 179,034.97 570- UTILITY BILL FUND 2,243.51 590 - SOLID WASTE COLLECT & RCY 85,435.50 750 - GOLF COURSE FUND 11,521.52 Grand Total: 1,459,562.37 Account Summary Account Number Account Name Expense Amount 010-10.1100.100000 HEALTH & LIFE INSURAN 27,678.33 010-10.1100.100100 LONGTERM DISABILITY 485.32 010-10.1100.120000 UNIFORMS 407.70 010-10.1100.230000 CONSULTANT & PROFES 726.80 010-10.1100.270100 COMPUTERSUPPORT 638.41 010-10.1100.280000 DUES, MEMBERSHIPS & 225.00 010-10.1100.400000 REPAIR/MAINTENANCE 1,224.22 010-10.1100.410000 REPAIR OF VEHICLES 20.00 010-10.1100.410200 REPAIR/MAINTENANCE 40.03 010-10.1100.450000 TELEPHONE 97.98 010-10.1100.480000 UTILITY SERVICES 561.12 010-10.1100.540000 MINOR EQUIPMENT 1,285.00 010-10.1100.590000 OPERATING SUPPLIES & 258.27 010-10.1300.230010 WESTCOM DISPATCH SE 33,763.09 010-10.1400.100000 HEALTH & LIFE INSURAN 5,477.38 010-10.1400.100100 LONGTERM DISABILITY 92.23 010-10.1400.120000 UNIFORMS 172.82 010-10.1400.270100 COMPUTER SUPPORT 240.19 010-10.1400.280000 DUES, MEMBERSHIPS& 12.50 010-10.1400.400000 REPAIR/MAINTENANCE 344.00 010-10.1400.410000 REPAIR OF VEHICLES 113.00 010-10.1400.410100 REPAIR/MAINTENANCE 50.00 010-10.1400.450000 TELEPHONE 94.90 010-10.1400.480000 UTILITY SERVICES 371.91 010-10.1400.570000 FUEL 463.31 010-10.1400.590000 OPERATING SUPPLIES & 131.85 010-10.1500.100000 HEALTH & LIFE INSURAN 5,360.66 010-10.1500.100100 LONGTERM DISABILITY 39.29 010-10.1500.270100 COMPUTER SUPPORT 198.89 010-10,1500.280000 DUES, MEMBERSHIPS& 12.50 010-10.1500.410000 REPAIR OF VEHICLES 14.32 010-10.1500.450000 TELEPHONE 94.90 010-10.1500.470000 TRAINING/TRAVEL EXPE 180.00 010-10.1500.480000 UTILITY SERVICES 371.90 010-10.1500.570000 FUEL 463.31 010-10.1500.590000 OPERATING SUPPLIES& 795.91 010-10.1500.590050 MEDICAL SUPPLIES 920.81 010-10.1900.100000 HEALTH & LIFE INSURAN 4,072.14 010-10.1900.100100 LONGTERM DISABILITY 95.09 010-10.1900.270100 COMPUTER SUPPORT 91.92 010-10.2400.340000 MISCELLANEOUS CONTR 540.00 010-20.6000.100000 HEALTH & LIFE INSURAN 5,873.08 010-20.6000.100100 LONG TERM DISABILITY 106.60 4/12/2017 2:36:08 PM Page 13 of 17 Expense Approval Register Packet: APPKT00559 - MARCH 18TH COUNCIL PACKET Account Summary Account Number Account Name Expense Amount 010-20.6000.270100 COMPUTER SU PPORT 18.68 010-20,6000.570000 FUEL 290.14 010-20,6010.230000 CONSULTANT&PROFES 913.75 010-20.6010.400000 REPAIR/MAINTENANCE 3,046.73 010-20.6010.450000 TELEPHONE 853.88 010-20.6010.480000 UTI LITY SERVICES 1,242.22 010-20.6010.510100 GARBAGE PICK UP 252.35 010-20.6010.580000 OFFICE SUPPLIES 590.16 010-20.6010.590000 OPERATING SUPPLIES& 531.93 010-20.6150.100000 HEALTH & LIFE INSURAN 2,020.27 010-20.6150.100100 LONG TERM DISABILITY 72.81 010-20.6150.570000 FUEL 140.50 010-20.6150.570110 COGS - FILTERS 250.94 010-20.6150.570130 COGS - PARTS 4,175.89 010-20.6150.590000 OPERATING SUPPLIES & 1,505.78 010-20.8900.100000 HEALTH & LIFE INSURAN 4,085.94 010-20.8900.100100 LONGTERM DISABILITY 109.70 010-20,8900.270100 COMPUTER SUPPORT 137.98 010-20,8900.570000 FUEL 433.08 010-20.8950.100000 HEALTH & LIFE INSURAN 572.49 010-20.8950.100100 LONG TERM DISABILITY 9.86 010-20.8950.270100 COMPUTER SUPPORT 7.19 010-2030500 SALES TAX COLLECTED P 62.40 010-40.3100.100000 HEALTH & LIFE INSURAN 7,566.87 010-40.3100.100100 LONG TERM DISABILITY 59.72 010-40.3100.270000 DATA PROCESSING 300.00 010-40.3100.270100 COMPUTER SUPPORT 236.17 010-40.3100.400000 REPAIR/MAINTENANCE 110.97 010-40,3100.450000 TELEPHONE 207.10 010-40,3100.460400 SUMMER READING CLU 2,390.00 010-40.3100.480000 UTILITY SERVICES 723.39 010-40.3100.580000 OFFICE SUPPLIES 66.18 010-40.3100.590000 OPERATING SUPPLIES& 135.42 010-40.3100.640000 LIBRARY BOOKS/FILMS/ 1,285.05 010-40.4100.100000 HEALTH & LIFE INSURAN 2,307.00 010-40.4100.100100 LONG TERM DISABILITY 40.33 010-40.4100.270100 COMPUTER SUPPORT 166.45 010-40.4100.410100 REPAIR/MAINTENANCE 49.00 010-40.4100.410300 REPAIR/MAINTENANCE 875.92 010-40.4100.450000 TELEPHONE 14.65 010-40.4100.480000 UTILITY SERVICES 405.73 010-40.4100.480100 UTILITIES -PARK IRRIGATI 34.94 010-40.4100.540000 MINOR EQUIPMENT 520.82 010-40.4100.570000 FUEL 423.12 010-40.4100.580000 OFFICE SUPPLIES 9.98 010-40.4100.590000 OPERATING SUPPLIES& 78.00 010-40.4100.590100 CHEMICAL/FERTILIZER 390.00 010-40.4200.100000 HEALTH & LIFE INSURAN 3,514.15 010-40.4200.100100 LONGTERM DISABILITY 63.00 010-40.4200.270100 COMPUTER SUPPORT 145.85 010-40.4200.460000 COMMUNITY SERVICES 500.00 010-40.4200.460050 OFFICIALS 540.00 010-40.4200.460500 SUMMER RECREATION P 1,456.00 010-40.4200.460510 YOUTH SPORTS LEAGUE 5,085.14 010-40.4200.460520 CONCESSION STAND 2,553.33 010-40.4200.460700 FIREWORKS 12,000.00 010-40.4200.461600 EASTER EGG HUNT 2,424.64 010-40.4200,570000 FUEL 63.85 4/12/2017 2:36:08 PM Page 14 of 17 Expense Approval Register Packet: APPKT00559 - MARCH 18TH COUNCIL PACKET Account Summary Account Number Account Name Expense Amount 010-40.4300.480000 UTILITY SERVICES 110.11 010-40.4300.590000 OPERATING SUPPLIES & 103.89 010-50.8500.100000 HEALTH & LIFE INSURAN 2,656.90 010-50.8500.100100 LONGTERM DISABILITY 23.68 010-50.8500.210100 PROMOTION 500.00 010-50.8500.270100 COMPUTER SUPPORT 67.66 010-50.8500.280000 DUES, MEMBERSHIPS& 225.00 010-50.8700.100000 HEALTH & LIFE INSURAN 3,520.05 010-50.8700.100100 LONG TERM DISABILITY 51.27 010-50.8700.230000 CONSULTANT & PROFES 152.00 010-50.8700.270100 COMPUTER SUPPORT 118.61 010-60.8100.580000 OFFICE SUPPLIES 6.80 010-60.8200.100000 HEALTH & LIFE INSURAN 1,455.38 010-60.8200.100100 LONGTERM DISABILITY 33.60 010-60.8200.470000 TRAINING/TRAVEL EXPE 93.00 010-60.8300.100000 HEALTH & LIFE INSURAN 2,851.72 010-60.8300.100100 LONGTERM DISABILITY 28.66 010-60.8300.230000 CONSULTANT & PROFES 5,000.00 010-60.8300.270000 DATA PROCESSING 139.95 010-60.8300.270100 COMPUTER SUPPORT 3,308.84 010-60.8300.280000 DUES, MEMBERSHIPS & 225.00 010-60.8300.360000 POSTAGE & SHIPPING 70.37 010-60.8300.390400 NORTHVIEW RENTAL PR 120.90 010-60.8300.459000 CONTRIBUTIONS 4,000.00 010-60.8300.470000 TRAINING/TRAVEL EXPE 250.00 010-60.8300.580000 OFFICE SUPPLIES 116.69 010-60.8310.390600 PROF PLAZA CAM EXPEN 301.77 010-60.8310.400000 REPAIR/MAINTENANCE 36.00 010-60.8310.450000 TELEPHONE 610.44 010-60.8310.480000 UTILITY SERVICES 730.97 010-60,8310.590000 OPERATING SUPPLIES & 60.74 010-60.8350,100000 HEALTH & LIFE INSURAN 570.09 010-60.8350.100100 LONGTERM DISABILITY 74.24 010-60.8350.270100 COMPUTER SUPPORT 17.59 010-60.8350.270110 COPIER / PRINTER LEASE 420.56 010-60.8350.350100 PRINTING 129.00 010-60.8400.100000 HEALTH & LIFE INSURAN 3,378.21 010-60.8400.100100 LONG TERM DISABILITY 77.45 010-60.8400.270100 COMPUTER SUPPORT 44.12 010-60.8400.580000 OFFICE SUPPLIES 122.28 010-60.8600.230000 CONSULTANT & PROFES 13,858.32 060-30.1600.410300 REPAIR/MAINTENANCE 710.83 060-30.1600.480000 UTILITY SERVICES 15,043.76 060-30.1601.230000 CONSULTANT & PROFES 1,496.00 060-30.1601.480000 UTILITY SERVICES 344.50 060-30.7100.100000 HEALTH & LIFE INSURAN 5,832.48 060-30.7100.100100 LONG TERM DISABILITY 136.61 060-30.7100.230000 CONSULTANT & PROFES 6,257.00 060-30.7100.270100 COMPUTER SUPPORT 489.46 060-30.7100.340000 MISCELLANEOUS CONTR 10,461.49 060-30.7100.410300 REPAIR/MAINTENANCE 761.95 060-30.7100.450000 TELEPHONE 503.94 060-30.7100.570000 FUEL 772.37 060-30.7100.590000 OPERATING SUPPLIES & 1,011.74 060-30.7100.590300 ROADSTONE 298.73 060-30.7100.590400 ROAD REPAIR -PATCH 1,043.90 060-30.7100.590600 STREET SIGNS 1,686.15 060-30.7100.591200 ROAD SALT 649.61 4/12/2017 2:36:08 PM Page 15 of 17 Expense Approval Register Packet: APPKT00559 - MARCH 18TH COUNCIL PACKET Account Summary Account Number Account Name Expense Amount 094-30.7850.230000 CONSULTANT/PROFESS] 1,644.00 110-1080100 MONEY MARKET-BANKE 569,450.00 327-90.1601.235020 H ICKMAN/DARTMOOR T 430.50 327-90.2130.840490 ALICES RD -UNIV TO OL 1,800.00 327-90.5000.881130 RRVT TRAILHEAD ART I 1,800.00 327-90.7730.235100 SE WESTOWN/13221NTE 1,177.37 327-90.8030,230000 DEVELOPER LANE ADDIT 20,985.30 510-1080100 MONEY MARKET-BANKE 27,050.00 510-2030500 SALES TAX COLLECTED P 15,315.07 510-30.6510.100000 HEALTH & LIFE INSURAN 4,681.29 510-30.6510.100100 LONG TERM DISABILITY 156.67 510-30.6510.270100 COMPUTER SUPPORT 1,127.78 510-30.6510.340000 MISCELLANEOUS CONTR 3,752.77 510-30.6510.390300 TOWER RENT 364.50 510-30.6510.410000 REPAIR OF VEHICLES 218.13 510-30.6510.410100 REPAIR/MAINTENANCE 576.00 510-30.6510.470000 TRAINING/TRAVEL EXPE 90.00 510-30.6510.480000 UTILITY SERVICES 908.49 510-30.6510.570000 FUEL 674.16 510-30.6510.590000 OPERATING SUPPLIES & 287.72 510-30.6510.650000 COST OF GOODS SOLD 52,429.72 520-1080100 MONEY MARKET-BANKE 9,950.00 520-2030500 SALES TAX COLLECTED P 2,398.89 520-30.6520.100000 HEALTH & LIFE INSURAN 5,903.53 520-30.6520.100100 LONGTERM DISABILITY 94.87 520-30.6520.250000 TESTING FEES 2,209.24 520-30.6520.270100 COMPUTER SUPPORT 927.42 520-30.6520.340000 MISCELLANEOUS CONTR 3,487.16 520-30.6520.410000 REPAIR OF VEHICLES 218.12 520-30.6520.410400 REPAIR/MAINTOF DELIV 176.71 520-30.6520.411300 TREATMENT PLANT PRO 944.52 520-30.6520.450000 TELEPHONE 145.20 520-30.6520.470000 TRAINING/TRAVEL EXPE 37.00 520-30.6520.480000 UTILITY SERVICES 8,747.85 520-30.6520.570000 FUEL 374.31 520-30,6520.590000 OPERATING SUPPLIES & 356.10 520-30.6520,883091 NW AREA TRUNK SEWE 1,800.00 520-30.6520.930300 DEBT ISSUANCE 13,656.97 540-1080100 MONEY MARKET - BANK 35,050.00 540-2030500 SALES TAX COLLECTED P 4,817.85 540-30.6540.100000 HEALTH & LIFE INSURAN 7,111.11 540-30.6540,100100 LONG TERM DISABILITY 77.33 540-30.6540.230000 CONSULTANT&PROFES 175.00 540-30.6540.270100 COMPUTER SUPPORT 1,444.84 540-30.6540.340000 MISCELLANEOUS CONTR 3,752.77 540-30.6540.390300 TOWER RENT 364.50 540-30.6540.410100 REPAIR/MAINTENANCE 706.33 540-30.6540.410200 REPAIR/MAINTENANCE 156.15 540-30.6540.450000 TELEPHONE 72.60 540-30.6540.480000 UTILITY SERVICES 83.21 540-30.6540.570000 FUEL 487.50 540-30.6540.590000 OPERATING SUPPLIES & 190.60 540-30.6540.590200 INSTALLATION MATERIA 1,400.17 540-30.6540.650000 COSTOF GOODS SOLD 113,258.05 540-30.6540.685400 GAS REBATE 405.00 560-2030500 SALES TAX COLLECTED P 1,212.09 560-80.5300.100000 HEALTH & LIFE INSURAN 3,356.63 560-80.5300.100100 LONGTERM DISABILITY 76.64 4/12/2017 2:36:08 PM Page 16 of 17 Expense Approval Register Packet: APPKT00559 - MARCH 18TH COUNCIL PACKET Account Summary Account Number Account Name Expense Amount 560-80.5300.120000 UNIFORMS 150.00 560-80.5300.270100 COMPUTER SUPPORT 210.96 560-80.5300.470000 TRAINING/TRAVEL EXPE 85.00 560-80.5300.570000 FUEL 123.65 560-80.5300.790000 VEHICLE OR EQUIPMEN 173,820.00 570-30.6550.100000 HEALTH & LIFE INSURAN 2,089.77 570-30.6550.100100 LONG TERM DISABILITY 15.78 570-30.6550.270100 COMPUTERSUPPORT 81.82 570-30.6550.580000 OFFICE SUPPLIES 56.14 590-30.5400.231100 SPECIAL COLLECTION 412.50 590-30.5400.231300 RESIDENTIAL SOLID WAS 85,023.00 750-2030500 SALES TAX COLLECTED P 1,176.95 750-80.8750.100000 HEALTH & LIFE INSURAN 1,003.54 750-80.8750.100100 LONG TERM DISABILITY 6.32 750-80.8750.270100 COMPUTER SUPPORT 205.70 750-80.8750.400000 REPAIR/MAINTENANCE 1,846.57 750-80.8750.410350 REPAIR/MAINTENANCE I 606.56 750-80.8750.4600200 SEASON PASSES 440.96 750-80.8750.470000 TRAININGITRAVEL EXPE 37.00 750-80.8750.480000 UTILITY SERVICES 596.11 75D-80.8750.590000 OPERATING SUPPLIES& 161.04 750-80.8750.650200 COGS-SNACKS/CANDY 339.77 750-80.8750.880070 GOLF COURSE BRIDGE P 5,101.00 Grand Total: 1,459,562.37 Project Account Summary Project Account Key Expense Amount **None** 1,459,562.37 Grand Total: 1,459,562.37 4/12/2017 2:36:08 PM Page 17 of 17 00 \kbukee City of Waukee, IA Vendor Number Vendor Name Bank Code: AP-WAUKEE STATE 169875 PURCHASE POWER, INC. Payable# Payable Type Account Number INV0002670 Invoice 540-30.6540.360000 570-30.6550.360000 570-30.6550,360000 021100 BANK OF AMERICA Payment Date Payment Type 04/03/2017 Regular Payable Date Payable Description Account Name Item Description 03/23/2017 MARCH'17 STATEMENT POSTAGE & SHIPPING GAS SAFETY BROCHURE POSTAGE & SHIPPING FEB'17 BILLS POSTAGE & SHIPPING PERMIT OVERAGE FEE POSTAGE & SHIPPING FEB'17 LATE NOTICES POSTAGE & SHIPPING FEB'17 ACH BILLS 03/31/2017 Regular My Check Report By Check Number Date Range: 03/30/2017 - 04/03/2017 DiscountAmount PaymentAmount Number 0.00 4,621.71 128261 Discount Amount Payable Amount Distribution Amount 0.00 4,621.71 1,410.58 1,830.12 43.30 443.03 894.68 0.00 10,891.40 128424 4/12/2017 2:38:46 PM Page 1 of 5 Qs My Check Report Date Range: 03/30/2017 - 04/03/2017 Vendor Number Vendor Name Payment Date Payment Type DiscountAmount PaymentAmount Number Payable M Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0002702 Invoice 02/18/2017 FEBRUARY'17 STATEMENT 0.00 10,891.40 010-10.1100.460200 PD COMMUNITY POLICIN PIZZA 123.21 010-10,1100.460200 PD COMMUNITY POLICIN KUM &GO SAVINGS -0.23 010-10.1100.460200 PD COMMUNITY POLICIN CITIZEN'S ACADEMY POP & ICE 22.65 010-10.1100.470000 TRAINING/TRAVEL EXPEN PEANUT BUTTER 4.59 010-10.1100,470000 TRAINING/TRAVEL EXPEN 2/2/17 LUNCH -QUINN METRO 162.50 010-10,1100,470000 TRAINING/TRAVEL EXPEN KUM&GO SAVINGS -0.05 010-10.1100.470000 TRAINING/TRAVEL EXPEN 2/2/17 LUNCH - SHANNON 11.40 010-10.1100,470000 TRAINING/TRAVEL EXPEN KUM & GO SAVINGS -0.11 010-10.1100.470000 TRAINING/TRAVEL EXPEN KUM & GO SAVINGS -0.11 010-10.1100,470000 TRAINING/TRAVEL EXPEN PIZZA 226.18 010-10.1100.470000 TRAINING/TRAVEL EXPEN ICE 10.98 010-10.1100.470000 TRAINING/TRAVEL EXPEN KUM &GO SAVINGS -0.05 010-10.1100.470000 TRAINING/TRAVEL EXPEN LEADERSHIP TRAINING POP 36.07 010-10.1100.470000 TRAINING/TRAVEL EXPEN ICE 5.49 010-10,1100.470000 TRAINING/TRAVEL EXPEN LEADERSHIP TRAINING PIZZA 201.18 010-10.1100,470000 TRAINING/TRAVEL EXPEN LEADERSHIP TRAINING ICE 10.98 010-10.1100.470000 TRAINING/TRAVEL EXPEN 1/31/17 LUNCH - SHANNON 10.06 010-10.1100.470000 TRAINING/TRAVEL EXPEN 2-3-17 LUNCH -KELLI 9.83 010-10.1100.470000 TRAINING/TRAVEL EXPEN CPS CERTIFICATE 50.00 010-10.1100.470000 TRAINING/TRAVEL EXPEN 2-3-17 BERAKFAST- KELLI 4.82 010-10.1100.470000 TRAINING/TRAVEL EXPEN 2/1/17 LUNCH - SHANNON 12.71 010-10.1100.470000 TRAINING/TRAVEL EXPEN 2-2-17 BREAKFAST- KELLI 10.11 010-10.1100.470000 TRAINING/TRAVEL EXPEN 2-2-17 LUNCH -KELLI 10.43 010-10.1100.470000 TRAINING/TRAVEL EXPEN STREETCOP SPANISH 225.00 010-10,1100.540000 MINOR EQUIPMENT SILENCER-GITZEN 511.00 010-10.1100,590000 OPERATING SUPPLIES & BROOMS & DUST PANS 92.19 010-10.1100.590000 OPERATING SUPPLIES& OFFICER OF THE YEAR PLAQUE 66.38 010-10.1400.120000 UNIFORMS UNIFORM HASH MARKS 9.00 010-10.1400.400000 REPAIR/MAINTENANCE0 PARTS/TITEBOND/BISCUIT 381.13 010-10,1400.410100 REPAIR/MAINTENANCE 0 DRIVE BOARD (ELEPTICAL REPAI 759.74 010-10,1400.470000 TRAINING/TRAVEL EXPEN CAR RENTAL 33.51 010-10.1500.120000 UNIFORMS UNIFORM HAS MARKS 9.00 010-10,1500.400000 REPAIR/MAINTENANCE 0 PARTS/TITEBOND/BISCUIT 381.13 010-10,1500.470000 TRAINING/TRAVEL EXPEN REGULATORY PROGRAM -CLIN 25.00 010-10.1500.470000 TRAINING/TRAVEL EXPEN CAR RENTAL 33.52 010-10,1500.470000 TRAINING/TRAVEL EXPEN MEMORY CARD & WIRELESS PR 42.47 010-10.1500.470000 TRAINING/TRAVEL EXPEN IDPH REGULATORY PROGRAM- 25.00 010-10.1500.590000 OPERATING SUPPLIES & CAR RENTAL INSURANCE 36.00 010-10.1900.120000 UNIFORMS BOOTS - WIGGINS 119.95 010-10,1900.470000 TRAINING/TRAVEL EXPEN ELECTRICAL INSPECTOR EXAM - 199.00 010-20.6000,470000 TRAINING/TRAVEL EXPEN 1-20-17 LUNCH - MEALS FROM 200.15 010-20.6000.590000 OPERATING SUPPLIES& CHARGER FORJOHN GIBSON 11.99 010-20.6010.400000 REPAIR/MAINTENANCES URINAL REPLACEMENT KIT 128.00 010-20.6150.570130 COGS - PARTS SEAT BELTS 192.75 010-40.3100.210100 PROMOTION BOOKS 48.48 010-40.3100.210100 PROMOTION FACEBOOKADS 16.18 010-40.3100.210100 PROMOTION FACEBOOKADS 33.32 010-40.3100.280000 DUES, MEMBERSHIPS & 5 GRANTSTATION 1 YEAR MEMBE 99.00 010-40.3100.360000 POSTAGE & SHIPPING SHIPPING 17.88 010-40.3100.360000 POSTAGE & SHIPPING SHIPPING 24.24 010-40.3100.460300 PROGRAMS BOOKS/DICE/CLEANER/TEMPT 52.27 010-40.3100.460300 PROGRAMS FAMILY WINTER READING PRIZE 99.00 010-40.3100.470000 TRAINING/TRAVEL EXPEN COOKIES- METRO LIBRARY MEE 18.50 010-40.3100.540000 MINOR EQUIPMENT MONITOR 109.44 010-40.3100.540000 MINOR EQUIPMENT CHROMEBOX/ADAPTER CABLE 187.97 010-40.3100.540000 MINOR EQUIPMENT TOASTER/MAGNETIC COMPACT 53.01 010-40.3100.580000 OFFICE SUPPLIES WEDGECYCLE BLUE BOTTLE/CA 113.06 010-40.3100.580000 OFFICE SUPPLIES SURFACE MOUNTED LATCH 27.56 4/12/2017 2:38:46 PM Page 2 of 5 My Check Report Date Range: 03/30/2017 - 04/03/2017 Vendor Number Vendor Name Payment Date Payment Type DiscountAmount PaymentAmount Number 010-40.3100.580000 OFFICE SUPPLIES DINING SET 160.96 010-40.3100.640000 LIBRARY BOOKS/FILMS/R BOOK 14.77 010-40.4100.210000 PUBLIC NOTIFICATION/A SOFTBALL AD 14.98 010-40.4100,210000 PUBLIC NOTIFICATION/A SOFTBALL AD 10.02 010-40.4200.460800 JULY 4TH CELEBRATION TATTOOS/MAGNETS 666.74 010-40.4200.580000 OFFICE SUPPLIES STOP WATCH 6.35 010-50.8500A70000 TRAINING/TRAVEL EXPEN PLANE TICKET -DAN DUTCHET 172.80 010-50.8500,470000 TRAINING/TRAVEL EXPEN PLANE TICKET -DAN DUTCHER 172.80 010-50.8500.470000 TRAINING/TRAVEL EXPEN BOOKING FEE 8.00 010-50.8500,470000 TRAINING/TRAVEL EXPEN PARKING FEES 4.00 010-50.8500,470000 TRAINING/TRAVEL EXPEN PARKING FEES 2.00 010-50.8500.470000 TRAINING/TRAVEL EXPEN 1-27-17 LUNCH - DAN/BRAD/M 40.43 010-50.8500.470000 TRAINING/TRAVEL EXPEN PARKING FEES 4.00 010-50.8500.470000 TRAINING/TRAVEL EXPEN REGISTRATION FEE - FEB. START 30.00 010-50.8500.470000 TRAINING/TRAVEL EXPEN PARKING FEES 5.25 010-50.8500.470000 TRAINING/TRAVEL EXPEN CHAMBER DINNER REGISTRATI 130.00 010-50.8700.470000 TRAINING/TRAVEL EXPEN 2017 NATIONAL PLANNING CO 735.00 010-50.8700.470000 TRAINING/TRAVEL EXPEN COFFEE 14.83 010-50.8700.470000 TRAINING/TRAVEL EXPEN COMP PLAN MEETING CINNAM 36.00 010-50.8700.470000 TRAINING/TRAVEL EXPEN CHAMBER DINNER REGISTRATI 65.00 010-60.8100.470000 TRAINING/TRAVEL EXPEN 2017 LEGISLATIVE DAY -MOER 15.00 010-60.8100.470000 TRAINING/TRAVEL EXPEN WAUKEE CHAMBER ANNUAL DI 130.00 010-60.8100.470000 TRAINING/TRAVEL EXPEN WAUKEE CHAMBER ANNUAL DI 220.00 010-60.8100.470000 TRAINING/TRAVEL EXPEN 1/23/17 COUNCIL WORK SESSIO 272.90 010-60.8100.470000 TRAINING/TRAVEL EXPEN 2/13/17 COUNCIL WORK SESSIO 171.57 010-60.8200.210000 PUBLIC NOTIFICATION/A COY AD 4.12 010-60.8200,210000 PUBLIC NOTIFICATION/A FAMILY FEST AD 15.00 010-60.8200,270100 COMPUTER SUPPORT CREATIVE CLOUD RENEWAL 49.99 010-60.8200.280000 DUES, MEMBERSHIPS & S 3CM ANNUAL DUES - SUMMER 400.00 010-60.8200.280000 DUES, MEMBERSHIPS & S ANNUAL AAF DUES - SUMMER 150.00 010-60,8200.470000 TRAINING/TRAVEL EXPEN CHAMBER DINNER REGISTRATI 65.00 010-60,8200.470000 TRAINING/TRAVEL EXPEN AMERICAN MARKETING LUNCH 30.00 010-60.8200,540000 MINOR EQUIPMENT BACKDROP FOR PHOTOS 64.60 010-60.8300.470000 TRAINING/TRAVEL EXPEN 1/27/17 TIM COFFEE W/LOBBYI 1.90 010-60.8300.470000 TRAINING/TRAVEL EXPEN UNIV. OF IA CTR FOR CONFERE 420.00 010-60.8300.470000 TRAINING/TRAVEL EXPEN PLANE TICKET -TIM M. 172.80 010-60.8300.470000 TRAINING/TRAVEL EXPEN PLANE TICKET -TIM M. 172.80 010-60.8300.470000 TRAINING/TRAVEL EXPEN 1118/17 FOUNDATION MEETIN 18.00 010-60.8300.470000 TRAINING/TRAVEL EXPEN WAUKEE CHAMBER ANNUAL DI 55.00 010-60.8300.470000 TRAINING/TRAVEL EXPEN 1/24/17 TIM EMPLOYEE LUNCH 100.07 010-60.8300.470000 TRAINING/TRAVEL EXPEN 1122/17 COFFEE TIM W/MAYOR 2.22 010-60.8300,470000 TRAINING/TRAVEL EXPEN 1/23/17 COFFEE -TIM W/HOME 2.22 010-60.8300.470000 TRAINING/TRAVEL EXPEN 2/15/17 LUNCH- BECKY (GCMG 10.37 010-60.8300.470000 TRAINING/TRAVEL EXPEN 2017 LEGISLATIVE DAY -MOER 15.00 010-60.8300.470000 TRAINING/TRAVEL EXPEN 2/7117 DESSERTTIM W/MAYOR 10.06 010-60.8300.470000 TRAINING/TRAVEL EXPEN 2/10/17 COFFEE TIM W/MAYOR 2.22 010-60.8300.470000 TRAINING/TRAVEL EXPEN 2/7/17 TIM LUNCH W/MAYOR 10.43 010-60.8300.470000 TRAINING/TRAVEL EXPEN 1/26/17 COFFEE TIM/UNITED W 1.75 010-60.8300,470000 TRAINING/TRAVEL EXPEN 2/2/17 LUNCH -TIM W/ECON D 36.61 010-60.8350.210000 PUBLIC NOTIFICATION/A PARKS & REC/PW SEASONAL HI 15.00 010-60.8350.210000 PUBLIC NOTIFICATION/A SEASONAL STAFF AD 2.49 010-60.8350.210000 PUBLIC NOTIFICATION/A SEASONALSTAFF AD 20.88 010-60,8350.470000 TRAINING/TRAVEL EXPEN 2/2/17 LUNCH - PATTY 12.00 010-60.8350.470000 TRAINING/TRAVEL EXPEN TRAINING WEBINAR - PATTY 89.00 010-60.8350.580000 OFFICE SUPPLIES EMPLOYEE HISTORY FOLDERS 104.96 0_10-60.8400,470000 TRAINING/TRAVEL EXPEN 1-27-17 LUNCH - LINDA(METRO 21.05 010-60.8400.470000 TRAINING/TRAVEL EXPEN 2-16-17 LUNCH - LINDA(METRO 18.57 510-30.6510.470000 TRAINING/TRAVEL EXPEN 42ND ANNUAL CONF. REGISTRA 325.00 560-80.5300.270000 DATA PROCESSING STORMWATER COSESCO APP 22.00 750-80.8750.280000 DUES, MEMBERSHIPS & S TRI-TEC SYSTEMS SUPPORT 30.00 4/12/2017 2:38:46 PM Page 3 of 5 My Check Report Date Range: 03/30/2017 - 04/0312017 Vendor Number Vendor Name Payment Date Payment Type DiscountAmount Payment Amount Number 750-80.8750.470000 TRAINING/TRAVEL EXPEN 1-19-17 BREAKFAST -STEVE 12.43 Bank Code AP Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 2 2 0.00 15,513.11 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 2 2 0.00 15,513.11 4/12/2017 2:38:46 PM Page 4 of 5 My Check Report Date Range: 03/30/2017 - 04/03/2017 Fund Summary Fund Name Period Amount 999 POOLED CASH 3/2017 10,891.40 999 POOLED CASH 4/2017 4,621.71 15,513.11 4/12/2017 2:38:46 PM Page 5 of 5 6,0 City of Waukee, IA Waukee Vendor Number Vendor Name Payment Date Payment Type Bank Code: AP-WAUKEE STATE 094675 IOWA BEVERAGE SYSTEMS INC 04/05/2017 Regular Payable # Payable Type Payable Date Payable Description Account Number Account Name Item Description INV0002701 Invoice 04/05/2017 BEER DELIVERY 750-80.8750.650100 COGS-BEER/ALCOHOL BEER DELIVERY 100375 Payable # INV0002704 164475 Payable # INV0002703 182975 Payable # INV000270S 182975 198840 Payable # 04071746949 204150 Payable # 04071746949 233120 My Check Report By Check Number Date Range: 04/05/2017- 04/12/2017 DiscountAmount PaymentAmount Number 0.00 464.60 128423 DiscountAmount Payable Amount Distribution Amount 0.00 464.60 464.60 J & K CONTRACTING, LLC 04/06/2017 Regular 0.00 27,075.00 128425 Payable Type Payable Date Payable Description DiscountAmount Payable Amount Account Number Account Name Item Description Distribution Amount Invoice 04/06/2017 PAY EST HI/FINAL - SW OUTFALL TREE FEL 0.00 27,075.00 520-30.6520.883000 OUTFALL CONNECTION F PAY EST #1/FINAL-SW OUTFAL 27,075.00 PHILLIPS-HAMILTON, INC. 04/06/2017 Regular 0.00 108,534.23 128426 Payable Type Payable Date Payable Description DiscountAmount Payable Amount Account Number Account Name Item Description Distribution Amount Invoice 04/06/2017 EASEMENTS -NW AREA & COPELAND TRU 0.00 108,534.23 520-30.6520.883091 NW AREA TRUNK SEWER EASEMENTS -NW AREA &COPEL 108,534.23 RDG DAHLQUIST ART STUDIO 04/06/2017 Regular 0.00 1,116,098.26 128427 Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount Invoice 04/06/2017 PAY EST #2- RRVT TRAILHEAD ART PROJE 0.00 1,116,098.26 327-90.5000.881130 RRVT TRAILHEAD ART IM PAY EST #2-RRVT TRAILHEADA 1,116,098.26 RDG DAHLQUIST ART STUDIO 04/06/2017 Regular 0.00-1,116,098.26 128427 MARK STUCHEL INC. 04/11/2017 Regular 0.00 568.00 128429 Payable Type Payable Date Payable Description DiscountAmount Payable Amount Account Number Account Name Item Description Distribution Amount Invoice 04/07/2017 DIAGNOSTIC CLASSES -OREN PETERSON 0.00 568.00 010-20.6150.470000 TRAINING/TRAVEL E%PEN DIAGNOSTIC CLASSES-OREN PE 568.00 TRENTTHOMPSON 04/11/2017 Regular 0.00 100.00 128430 Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount Invoice 04/07/2017 DIAGNOSTIC CLASS - OREN PETERSON 0.00 100.00 010-20.6150.470000 TRAINING/TRAVEL E%PEN DIAGNOSTIC CLASS -OREN PET 100.00 PETTY CASH - PW/PARKS 04/11/2017 Regular 0.00 50.84 128431 4/12/2017 2:40:16 PM Page 1 of 3 My Check Report Date Range: 04/05/2017 - 04/12/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 INV0002732 Invoice 04/11/2017 PETTY CASH RECEIPTS 0.00 50.84 O10-40.4100.410100 REPAIR/MAINTENANCE 0 ECCENTRIC LOCKING COLLAR - 12.84 010-40.4200.460500 SUMMER RECREATION P OLDER IOWAN DAY - DANAE 38.00 Bank Code AP Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 7 7 0.00 1,252,890.93 Manual Checks 0 0 0.00 0.00 Voided Checks 0 1 0.00 -1,116,098.26 Bank Drafts 0 0 0.00 0.00 EFT's 0 0 0.00 0.00 7 8 0.00 136,792.67 4/12/2017 2:40:16 PM Page 2 of 3 My Check Report Date Range: 04/05/2017-04 12/2017 Fund Summary Fund Name Period Amount 999 POOLED CASH 4/2017 136,792.67 136,792.67 4/12/2017 2:40:16 PM Page 3 of 3 City of Waukee, IA Vendor Number Vendor Name Bank Code: AP-WAUKEE STATE 034875 CITY OF WAUKEE Payable # Payable Type Account Number INV0002674 Invoice 010-2030000 V Council Payroll Reimbursements By Check Number Date Range: 03/31/2017 - 04/12/2017 Payment Date Payment Type 03/31/2017 Regular Payable Date Payable Description Account Name Item Description 03/31/2017 UNIFORM DEDUCTIONS PAYROLL PAYABLES UNIFORM DEDUCTIONS DiscountAmount PaymentAmount Number 0.00 5,346.66 128268 DiscountAmount Payable Amount Distribution Amount 0.00 49.98 49.98 INV0002678 Invoice 03/31/2017 CELL PHONE REIMBURSEMENT 0.00 222.50 010-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 147.50 060-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 9.38 510-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 11.28 520-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 26.24 540-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 26.26 560-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 1.84 INV0002679 Invoice 03/31/2017 GOLF APARTMENT RENT 0.00 600.00 - 010-2030000 PAYROLL PAYABLES GOLF APARTMENT RENT 600.00 INV0002684 Invoice 03/31/2017 LIFE INSURANCE PREMIUM 0.00 599.72 010-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 417.12 060-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 19.46 510-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 28.96 520-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 28.87 540-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 42.91 560-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 27.65 570-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 34.75 INV0002685 Invoice 03/31/2017 STD INSURANCE PREMIUM 0.00 569.46 010-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 389.50 060-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 44.66 510-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 35.81 520-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 42.29 540-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 23.76 560-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 33.44 INV0002688 Invoice 03/31/2017 HEALTH INSURANCE DEDUCTION 0.00 2,975.00 010-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 2,176.00 060-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 152.99 510-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 117.29 520-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 159.30 540-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 202.25 560-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 94.92 570-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 42.50 750-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 29.75 INV0002689 Invoice 03/31/2017 HEALTH INSURANCE DEDUCTION 0.00 330.00 010-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 255.00 060-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 15.00 510-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 18.81 520-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 18.75 540-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 3.79 560-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 3.65 570-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 15.00 036350 IOWA DEPT OF HUMAN SERVICES 03/31/2017 Regular 0.00 1,740.58 128269 4/12/2017 9:18:06 AM Page 1 of 7 Council Payroll Reimbursements Date Range: 03/31/2017 - 04/12/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 INV0002671 Invoice 03/31/2017 CHILD SUPPORT 0.00 1,740.58 010-2011300 CHILD SUPPORT PAYABLE CHILD SUPPORT 1,616.70 060-2011300 CHILD SUPPORT PAYABLE CHILD SUPPORT 123.88 036740 Payable # INV0002675 099999 Payable # INV0002693 INV0002694 INV0002695 133560 Payable # INV0002681 206800 COMMUNICATIONS WORKERS OF AMERICA 03/31/2017 Regular 0.00 888.78 128270 Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount Invoice 03/31/2017 CWA LOCAL 7102 UNION DUES 0.00 888.78 010-2014100 CREDIT UNION DEDUCTI CWA LOCAL 7102 UNION DUES 420.99 060-2014100 CREDIT UNION DEDUCTI CWA LOCAL 7102 UNION DUES 83.11 510-2014100 CREDIT UNION DEDUCTI CWA LOCAL 7102 UNION DUES 65.82 520-2014100 CREDIT UNION DEDUCTI CWA LOCAL 7102 UNION DUES 96.51 540-2014100 CREDIT UNION DEDUCTI CWA LOCAL 7102 UNION DUES 130.98 560-2014100 CREDIT UNION DEDUCTI CWA LOCAL 7102 UNION DUES 66.09 570-2014100 CREDIT UNION DEDUCTI CWA LOCAL 7102 UNION DUES 25.28 EFTPS 03/31/2017 Regular 0.00 79,522.08 128271 Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount Invoice 03/31/2017 FICA TAX WITHHOLDING 0.00 36,323.76 010-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 27,749.18 060-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 1,509.26 510-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 1,306.64 520-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 1,695.32 540-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 1,965.88 560-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 814.58 570-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 587.48 750-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 695.42 Invoice 03/31/2017 FEDERAL WITHHOLDING TAXES 0.00 34,703.10 010-2010200 FEDERALTAX WITHHOLDI FEDERAL WITHHOLDING TAXES 26,191.43 060-2010200 FEDERALTAX WITHHOLDI FEDERAL WITHHOLDING TAXES 1,457.24 510-2010200 FEDERALTAX WITHHOLDI FEDERAL WITHHOLDING TAXES 1,298.17 520-2010200 FEDERALTAX WITHHOLDI FEDERAL WITHHOLDING TAXES 2,002.40 540-2010200 FEDERALTAX WITHHOLDI FEDERAL WITHHOLDING TAXES 1,800.89 560-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 879.76 570-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 795.70 750-20102GO FEDERALTAX WITHHOLDI FEDERAL WITHHOLDING TAXES 277.51 Invoice 03/31/2017 MEDICARE TAX WITHHOLDING 0.00 8,495.22 010-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 6,489.84 060-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 353.00 510-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 305.66 520-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 396.48 540-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 459.74 560-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 190.44 570-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 137.40 750-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 162.66 MEALS FROM THE HEARTLAND 03/31/2017 Regular 0.00 114.20 128272 Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount Invoice 03/31/2017 MEALS FROM HEARTLAND DEDUCTION 0.00 114.20 010-2030000 PAYROLL PAYABLES MEALS FROM HEARTLAND DED 93.66 510-2030000 PAYROLL PAYABLES MEALS FROM HEARTLAND DED 3.54 520-2030000 PAYROLL PAYABLES MEALS FROM HEARTLAND DED 2.50 560-2030000 PAYROLL PAYABLES MEALS FROM HEARTLAND DED 14.50 TOTAL ADMINISTRATIVE SERVICES CORP 03/31/2017 Regular 0.00 4,464.09 128273 4/12/2017 9:18:06 AM Page 2 of 7 Council Payroll Reimbursements Date Range: 03/31/2017 - 04/12/2017 Vendor Number Payable # INV0002686 INV0002687 213250 Payable # INV0002677 233050 Payable # INV0002682 091000 Payable # INV0002593 Vendor Name Payment Date Payment Type Discount Amount Payment Amount Number Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount Invoice 03/31/2017 SECTION 125 MEDICAL DEDUCTIONS 0.00 2,613.28 010-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 1,897.00 060-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 10.41 510-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 115.63 520-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 111.77 540-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 183.33 560-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 97.23 570-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 125.00 750-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCT] 72.91 Invoice 03/31/2017 SECTION 125 DAYCARE DEDUCTIONS 0.00 1,850.81 010-2030000 PAYROLL PAYABLES SECTION 125 DAYCARE DEDUCT 1,642.48 560-2030000 PAYROLL PAYABLES SECTION 125 DAYCARE DEDUCT 208.33 UNITED WAY CENTRAL IOWA 03/31/2017 Regular 0.00 193.30 128274 Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount Invoice 03/31/2017 UNITED WAY DEDUCTION 0.00 193.30 010-2030000 PAYROLL PAYABLES UNITED WAY DEDUCTION 164.17 510-2030000 PAYROLL PAYABLES UNITED WAY DEDUCTION 6.89 520-2030000 PAYROLL PAYABLES UNITED WAY DEDUCTION 4.99 540-2030000 PAYROLL PAYABLES UNITED WAY DEDUCTION 10.00 560-2030000 PAYROLL PAYABLES UNITED WAY DEDUCTION 7.25 WAUKEE PUBLIC LIBRARY FRIENDS FOUNDATIC 03/31/2017 Regular 0.00 36.66 128275 Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount Invoice 03/31/2017 LIBRARY FRIENDS FOUNDATION PAYROLL 0.00 36.66 010-2030000 PAYROLL PAYABLES LIBRARY FRIENDS FOUNDATION 29.12 510-2030000 PAYROLL PAYABLES LIBRARY FRIENDS FOUNDATION 3.54 520-2030000 PAYROLL PAYABLES LIBRARY FRIENDS FOUNDATION 2.50 560-2030000 PAYROLL PAYABLES LIBRARY FRIENDS FOUNDATION 1.50 ICMA RETIREMENTTRUST 457 04/04/2017 Regular 0.00 5,842.52 128418 Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount Invoice 03/15/2017 ICMA RETIREMENT 0.00 1,978.79 010-2011200 IPERS WITHHOLDING PAY ICMA RETIREMENT 1,783.79 060-2011200 IPERS WITHHOLDING PAY ICMA RETIREMENT 25.00 540-2011200 IPERS WITHHOLDING PAY ICMA RETIREMENT 120.00 570-2011200 IPERS WITHHOLDING PAY ICMA RETIREMENT 50.00 INV0002594 Invoice 03/15/2017 ICMA 0.00 943.96 010-2011200 IPERS WITHHOLDING PAY ICMA 878.13 510-2011200 IPERS WITHHOLDING PAY ICMA 16.46 520-2011200 IPERS WITHHOLDING PAY ICMA 16.46 540-2011200 IPERS WITHHOLDING PAY ICMA 16.46 560-2011200 IPERS WITHHOLDING PAY ICMA 16.45 INV0002672 Invoice 03/31/2017 ICMA RETIREMENT 0.00 1,978.79 010-2011200 IPERS WITHHOLDING PAY ICMA RETIREMENT 1,783.79 060-2011200 IPERS WITHHOLDING PAY ICMA RETIREMENT 25.00 540-2011200 IPERS WITHHOLDING PAY ICMA RETIREMENT 120.00 570-2011200 IPERS WITHHOLDING PAY ICMA RETIREMENT 50.00 INV0002673 Invoice 03/31/2017 ICMA 0.00 940.98 010-2011200 IPERS WITHHOLDING PAY ICMA 868.56 510-2011200 IPERS WITHHOLDING PAY ICMA 18.72 520-2011200 IPERS WITHHOLDING PAY ICMA 18.12 540-2011200 IPERS WITHHOLDING PAY ICMA 18.71 4/12/2017 9: 18:06 AM Page 3 of 7 C/ Council Payroll Reimbursements Date Range: 03/31/2017 - 04/12/2017 Vendor Number Vendor Name Payment Date Payment Type Discount Amount PaymentAmount Number 560-2011200 IPERS WITHHOLDING PAY ICMA 16.87 098900 IPERS 04/04/2017 Regular 0.00 89,251.49 128419 Payable p Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount CM0000020 Credit Memo 03/31/2017 MARCH'17 ROUNDING ADJUSTMENT 0.00 -0.17 010-60.8350.080000 IPERS CONTRIBUTION MARCH'17 ROUNDING ADJUST -0.17 INV0002544 Invoice 03/07/2017 IPERS DEDUCTIONS 0.00 49.50 540-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 49.50 INV0002609 Invoice 03/15/2017 IPERS DEDUCTIONS 0.00 28,219.61 010-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 19,026.29 060-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 1,696.24 510-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 1,489.43 520-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 1,890.13 540-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 2,137.57 560-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 950.53 570-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 664.87 750-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 364.55 INV0002610 Invoice 03/15/2017 IPERS DEDUCTIONS 0.00 14,822.15 010-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 14,822.15 INV0002611 Invoice 03/15/2017 IPERS ELECTED OFFICIAL DEDUCT 0.00 212.04 010-2011200 IPERS WITHHOLDING PAY IPERS ELECTED OFFICIAL DEDUC 212.04 INV0002619 Invoice 03/15/2017 IPERS DEDUCTIONS 0.00 373.02 010-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 74.60 060-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 37.31 750-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 261.11 INV0002690 Invoice 03/31/2017 IPERS DEDUCTIONS 0.00 30,463.05 010-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 19,970.93 060-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 1,837.38 510-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 1,605.04 520-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 2,077.14 540-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 2,415.49 560-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 1,036.88 570-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 732.12 750-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 788.07 INV0002691 Invoice 03/31/2017 IPERS DEDUCTIONS 0.00 15,112.29 010-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 15,112.29 208650 TREASURER STATE OF IOWA 04/04/2017 Regular 0.00 26,764.17 128420 Payable # Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0002612 Invoice 03/15/2017 STATE WITHHOLDING TAXES 0.00 12,840.37 010-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 10,124.25 060-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 513.39 510-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 444.73 520-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 563.32 540-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 663.99 560-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 270.55 570-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 210.41 750-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 49.73 INV0002620 Invoice 03/15/2017 STATE WITHHOLDING TAXES 0.00 103.86 010-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 20.77 060-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 10.39 750-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 72.70 INV0002692 Invoice 03/31/2017 STATE WITHHOLDING TAXES 0.00 13,819.94 010-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 10,677.56 060-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 565.95 510-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 490.55 4/12/2017 9:18:06 AM Page 4 of 7 rel Council Payroll Reimbursements Vendor Number Vendor Name 520-2011100 540-2011100 560-2011100 570-2011100 750-2011100 Payment Date STATE TAX WITHHOLDIN STATE TAX WITHHOLDIN STATE TAX WITHHOLDIN STATE TAX WITHHOLDIN STATE TAX WITHHOLDIN Payment Type STATE WITHHOLDING TAXES STATE WITHHOLDING TAXES STATE WITHHOLDING TAXES STATE WITHHOLDING TAXES STATE WITHHOLDING TAXES Date Range: 03/31/2017 - 04/12/2017 Discount Amount Payment Amount Number 634.30 752.09 305.45 234.45 159.59 232780 WAUKEE FIREFIGHTER'S ASSOCIATION 04/04/2017 Regular 0.00 271.04 128421 Payable # Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0002256 Invoice O1/15/2017 FIREFIGHTER'S ASSOCIATION PAYROLL CO 0.00 51.84 010-2030000 PAYROLL PAYABLES FIREFIGHTER'S ASSOCIATION PA 28.30 060-2030000 PAYROLL PAYABLES FIREFIGHTER'S ASSOCIATION PA 12.50 510-2030000 PAYROLL PAYABLES FIREFIGHTER'S ASSOCIATION PA 6.05 520-2030000 PAYROLL PAYABLES FIREFIGHTER'S ASSOCIATION PA 4.99 INV0002348 Invoice O1/31/2017 FIREFIGHTER'S ASSOCIATION PAYROLL CO 0.00 61.84 010-2030000 PAYROLL PAYABLES FIREFIGHTER'S ASSOCIATION PA 38.30 060-2030000 PAYROLL PAYABLES FIREFIGHTER'S ASSOCIATION PA 12.50 510-2030000 PAYROLL PAYABLES FIREFIGHTER'S ASSOCIATION PA 6.06 520-2030000 PAYROLL PAYABLES FIREFIGHTER'S ASSOCIATION PA 4.98 INV0002445 Invoice 02/15/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 INV0002515 Invoice 02/28/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 INV0002602 Invoice 03/15/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 INV0002683 Invoice 03/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 04/04/2017 Regular 0.00 1,680.00 128422 Payable# Payable Type Payable Date Payable Description DiscountAmount Payable Amount Account Number Account Name Item Description Distribution Amount INV0002596 Invoice 03/15/2017 YMCA FAMILY MEMBERSHIP DEDUCTION 0.00 612.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 68.00 560-2030000 PAYROLL PAYABLES YMCA FAMILY MEMBERSHIP DE 34.00 INV0002599 Invoice 03/15/2017 YMCA SINGLE MEMBERSHIP DEDUCTION 0.00 240.00 010-2030000 PAYROLL PAYABLES YMCA SINGLE MEMBERSHIP DE 240.00 INV0002676 Invoice 03/31/2017 YMCA FAMILY MEMBERSHIP DEDUCTION 0.00 612.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 68.00 560-2030000 PAYROLL PAYABLES YMCA FAMILY MEMBERSHIP DE 34.00 INV0002680 Invoice 03/31/2017 YMCA SINGLE MEMBERSHIP DEDUCTION 0.00 216.00 4/12/2017 9:18:06 AM Page 5 of 7 Council Payroll Reimbursements Date Range: 03/31/2017 - 04/22/2017 Vendor Number Vendor Name Payment Date Payment Type DiscountAmount PaymentAmount Number 010-2030000 PAYROLL PAYABLES YMCA SINGLE MEMBERSHIP DE 216.00 Bank Code AP Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 42 13 0.00 216,115.57 Manual Checks 0 0 0.00 0.00 Voided Checks 0 0 0.00 0.00 Bank Drafts 0 0 0.00 0.00 EFT's 0 0 0.00 0.00 42 13 0.00 216,115.57 4/12/2017 9: 18:06 AM Page 6 of 7 Council Payroll Reimbursements C Date Range: 03/31/2017 - 04/1212017 Fund 999 999 Fund Summary Name Period Amount POOLED CASH 3/2017 92,306.35 POOLED CASH 4/2017 123,809.22 216,215.57 4/12/2017 9:18:06 AM Page 7 of 7 04-12-2010 09:26 AM PERIOD: 3/29/2017 THRU 4/12/2017 ZONE: s - All Zones REVENUE CODE: All ADJUSTMENT CODES: All ACCOUNT NO# NAME 01-04568-05 GERLACH, MICHAEL A MONTHLY TRANSACTION REPORT DATE TYPE 4/03/2017 RF-CK AMOUNT 691.28 REFERENCE REFUND CK: 128246 PAGE: 1 PACKET RECEIPT ADJ 20160 01-25009-10 BRITTON, ROBERT 4/03/2017 RF-CK 26.99 REFUND CK: 128249 20160 01-83805-04 MARTINEZ, EVELYN N 4/03/2017 RP-CK 42.94 REFUND CK: 128248 20160 01-84600-01 HOWE, BETTY 4/03/2017 RP-CK 45.37 REFUND CK: 128249 20160 16-00056-00 ORTON HOMES LLC 4/03/2017 RF-CK 104.43 REFUND CK: 128250 20160 16-00694-00 EDEN CUSTOM HOMES, LLC. 4/03/2017 RF-CK 142.32 REFUND CK: 128251 20160 84-00051-11 CRIVARO, STEFANI 4/03/2017 RF-.CK 200.00 REFUND CK: 128252 20160 84-00568-00 JCORP, INC 4/03/2017 RF-CK 160.28 REFUND CK: 128253 20160 84-01622-02 BEEBE, JASON R 4/03/2017 RF-CK 16.59 REFUND CK: 128254 20160 84-02282-03 YINGLING, FAITH 4/03/2017 RF-CK 16.59 REFUND CK: 128255 20160 84-02698-02 TRI STATE VENTURES INC 4/03/2017 RF-CK 2.60 REFUND CK: 128256 20160 84-02952-02" GREGAN, MICHAEL L 4/03/2017 RF-CK 199.51 REFUND CK: 12825/ 20160 85-00108-05 BLISS, KAITLIN E 4/03/2017 RF-CK 43.56 REFUND CK: 128258 20160 85-00137-02 CRITELLI, DIEGO 4/03/2017 RF-CK 48.09 REFUND CK: 128259 20160 85-00812-00 ORTON HOMES LLC 4/03/2017 RF-CK 105.54 REFUND CK: 128260 20160 04-12-2019 09:26 AM MONTHLY TRANSACTION REPORT PAGE: 2 PERIOD: 3/29/2017 THRU 4/12/2017 ZONE: * - All Zones REVENGE CODE: All ADJUSTMENT CODES: All ------------------- _____________------- _____ M O N T H L Y D I S T R I B U T I O N ======== -------- REVENUE CODE TYPE COUNT AMOUNT TYPE COUNT AMOUNT TYPE COUNT AMOUNT 04/2017 999 - REFUND RF-CK 15 1,826.25 GRAND TOTAL FOR PERIOD 1,826.25 DEPOSIT TOTAL FOR PERIOD 0.00 04-12-2017 09:26 AM MONTHLY TRANSACTION REPORT PAGE: 3 PERIOD: 3/29/2017 THRU 4/12/2017 ZONE: • - All Zones REVENUE CODE: All AD,TUSTMENT CODES: All ____ __________--_- R E V E N U E C O D E T O T A L S B Y T Y P E------ ____------- ________---__________ REVENUE CODE TYPE COUNT AMOUNT TYPE COUNT AMOUNT TYPE COUNT AMOUNT 999 - REFUND RF-CK 15 1,826.25 GRAND TOTAL FOR PERIOD 1,826.25 ___------------------- ------------------------- --- -----= T O T A L S E Y T R A N S A C T I O N T Y P E TYPE COUNT AMOUNT ___________________________________________ REFUND CHECK 15 1,826.25 TOTAL FOR PERIOD 15 1,826.25 l� 0 VlloLJf(ee Employee Name ABBOTT, BRENT ADKINS, COREY ALDRICH, SHAWN ALLEN, JASON APPLE, WILLIAM ARIAS, HECTOR ARMSTRONG, BRETT BAKER, RANDY SARTLING, DARREL BAUMAN, LISA BERG, BROOKE BOHARDT, HAZEL BRUNS, RACHEL BURKHART, LINDA CAMPBELL, JUDY CAMPBELL, SCOTT CICHOSKI, KELLI CLEMEN, ANTHONY COLE, JACOB CORKREAN, JENNIFER COUGHLIN, TONI CRAVEN, GAYLA CUNNINGHAM, DEANA CUNNINGHAM, SCOTT DANIEL, COLE DAVIS, BRIAN DEBOER, MELISSA DEETS, BRADLY DEZEEUW, DAVID DODGE, JUSTIN DUNBAR, DIANA DUTCHER,DAN EASTMAN, DAVID EDWARDS, DANAE ELDRIDGE, MALLORY ELLIOTT, STEVE EVANS, SUMMER EVERMAN, MASON FLUGGE-SMITH, JAMIE FORRET, DENNIS FREDERICK, JUSTIN FROEHLICH, WILLIAM GIBSON, JOHN GITZEN, ROBERT GODW IN, EDWARD GROVE, BRIAN GROVO,ANDREW HANSON,ANTHONY HANSON, LAURA HARDIN, THOMAS HASKINS, STACEY HEIMANN, RONALD HENTGES, ERIC HERR,JENNA HERRICK, ROBERT HILGENBERG, ADAM HOLDEN, PATRICIA City of Waukee, IA Publication Report By Employee Name Payroll Set: 01 - City of Waukee For Date Range 03/16/2017-03/31/2017 Salary $1,345.24 $1,320.99 $1,769.59 $153.18 $522.78 $2,019.97 $1,560.75 $2,188.34 $60.47 $1,331.61 $159.31 $408.51 $1,823.04 $2,779.55 $609.52 $1,944.22 $1,702.47 $365.07 $476.34 $1,834.78 $250.03 $112.86 $586.02 $2,138.99 $1,355.16 $513.50 $1,844.10 $3,080.61 $2,351.42 $1,917.81 $1,077.27 $3,001.86 $703.45 $915.08 $839.91 $1,729.29 $2,058.39 $51.19 $1,896.88 $236.56 $1,776.55 $423.76 $3,287.08 $1,485.60 $239.66 $261.07 $207.71 $2,116.99 $1,349.60 $413.90 $1,307.52 $2,283.89 $499.32 $1,552.65 $1,983.94 $1,395.45 $2,708.67 l� Employee Name Salary HUSTED, TROY $1,672.64 HUTTON, JOSHUA $966.75 IRWIN, BRENT $141.60 JENSEN, CHAD $215.52 JERMIER, MATTHEW $2,597.77 KASS, ANDREW $2,144.17 KASZINSKI, BRETT $672.33 KELLER, CHRISTOPHER $1,754.21 KERR, JACOB $1,527.21 KESSLER, MATTHEW $1,723.88 KIES, SUSAN $1,719.83 KOESTER, EVAN $1,958.23 KOESTER, RUDY $2 482 37 LARSON, KENNETH $700.09 LARSON, KRISTINE $2,406.06 LAUGHRIDGE, DANIEL $1,644.86 LEMKE, NEIL $1,247.06 LONG, JEREMY $2,403.48 LYNCH, JEREMY $681.24 LYNCH, SHANNON $1,697.39 MANNING, JOSHUA $1,930.47 MAPES, TROY $2,601.77 MCCLINTIC, LAMES $1,256.81 MCKERN, DOUGLAS $486.45 MEDDERS, BRETT $1,355.62 MELLENCAMP, JEFFREY $2,222.89 MINIKUS, JOSHUA $1,699.14 MOERMAN, TIMOTHY $3,991.73 MURRA, BRIAN $1,870.54 NICELY -GREEN, CODY $313.49 NITZEL, NICOLE $667.84 NORTON, PATRICK $257.60 OAKLEY, JON $1,620.88 OLSEN, KART $1,582.13 OSTRING, KATHLEEN $1,508.95 PARISH, TONJA $1,433.30 PARKER, SUSAN $132.36 PELLETTERI, SALVATORE $31.97 PERDRIAU, MARIE $269.83 PETERSON, KATIE $1,251.68 PETERSON, OREN $2,034.23 PETTIT, BRANDON $1,690.95 PIERSON, DAMON $1,337.59 PINEGAR, TOMMIE $1,401.73 PIZINGER, JAMES $1,207.15 POSADAS, OSCAR $338.74 PUDENZ, DANIELLE $14.52 PURVIS, KATHRYN $1,431.66 QUINN, JOHN $2,719.27 RASH, RONALD $2,081.38 RICHARDSON, ELIZABETH $1,802.47 ROBINSON, CLINT $3,107.40 ROYER, TIMOTHY $2,701.18 ROYSTER, JACOB $1,502.67 SCHAUFENBUEL, KARI $98437 SCHETTLER, RODNEY $2,222.11 SCHUETT, REBECCA $2 277 77 SEDDON, JOSH $127.89 SHARON, JEREMIAH $1,258.96 SNELSON, NATHANIEL $296.46 SOFEN, NATASHA $34.56 SPOSETO, MACKENZIE $1,932.27 SPRAGUE, MATTHEW $1,681.01 STEPHENS, CLINT $271.64 Employee Name Salary STEWARD, ERIC $1,913.95 STOTZ, MELISSA $1,050.68 TETMEYER, CARL $98.36 THAYER, CHANDLER $388.45 THOMAS, JULIE $53.40 TIBBLES, STEVEN $1,613.89 TUEL, JASON $156.07 TYSDAL, THOMAS $2,278.68 VANDE KAMP, JOSHUA $1,565.16 VOEGTLE, TIMOTHY $1,536.95 VOKES, LARRY $1772 47 WALLACE, ERIC $1,774.30 WASKE, CHARLES $1,990.50 WAYCASTER, SAVANNAH $172 78 WERTS, DANIEL $2,063.12 WESTON STOLL, KERI $1,499.03 WHITE, JASON $1,469.37 WHITE, LEAH $1,309.33 WIGGINS, MATHEW $1,973.61 WILSON, JODY $864.52 WINTERS, TROY $1,944.38 WISE, NATHAN $1,835.67 WOOD, DANIEL $856.51 YATES, CASSANDRA $504.48