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-03-J01A 04032017_bill list_payroll
City of Waukee Bill Presentation Recap April 3, 2017 Total Unpaid Bills Presented for Approval : $1,128,365.47 Total Checks Issued Prior to Council Approval: Regular Checks: A) Prior to Last Council Meeting $1,031.50 B) After Last Council Meeting $900.00 C) Payroll Taxes & Reimbursements $87,141,02 Payroll Checks Issued: D) 03115/2017 $190,034.23 Grand Total: $1,407,47222 Q. FY 2017 Fund Recap: Expenditures Revenues Budgeted Year To Date Budgeted Year To Date 010 General Fund $ 9,736,705 $ 7,242,438 $ 9,520,350 060 Road Use Tax Fund $ 2,145,066 $ 1,715,751 $ 1,822,167 075 Waukee Foundation $ - $ 24 $ - 085 Asset Forfeitures $ - $ - $ - 091 Hickman West Indust Park TIF $ 421,355 $ - $ 576,400 092 Enterprise Business Park TIF Fund $ 232,550 $ - $ 600 093 Waukee Urban Renewal Area TIF Fund $ 2,988,360 $ 28,547 $ 2,780,500 094 Gateway Urban Renewal $ - $ 8,093 $ - 095 Autumn Ridge Urban Renewal $ - $ 521 $ - 110 Debt Service Fund $ 6,951,481 $ 2,467,273 $ 6,999,755 111 Special Assessments Fund $ 45,698 $ 43,739 $ 42,200 210 Employee Benefits Fund $ 1,500,285 $ - $ 1,504,285 327 Capital Projects $ 11,653,500 $ 4,548,103 $ 11,653,500 330 City Wide SA Sidewalk Project $ - $ - $ - 510 Water Utility Fund $ 3,910,801 $ 2,443,827 $ 3,671,507 520 Sewer Utility Fund $ 7,003,697 $ 5,568,334 $ 3,714,066 521 University Ave Trunk Sewer Project $ - $ - $ - 522 Waste Water Treatment PI $ - $ - $ - 523 E Area Pump Sta Treatment $ - $ - $ - 540 Gas Utility Fund $ 5,590,810 $ 3,235,372 $ 5,491,100 560 Storm Sewer Utility Fund $ 1,148,970 $ 500,435 $ 891,150 570 Utility Bill Fund $ 264,790 $ 175,983 $ 264,750 590 Solid Waste Collect& Rcycl Fund $ 1,081,760 $ 836,635 $ 1,101,160 750 Golf Course Fund $ 507,595 $ 377,986 $ 592,300 810 Equipment Revolving Fund $ - $ - $ 30,000 $ 7,075,922 $ 1,661,429 $ 60,900 $ 420.77 $ 298,385 $ 1,018 $ 1,672, 395 $ 3,303,331 $ 28,552 $ 835,689 $ 1,283,744 $ 5,025 $ 3,215,966 $ 3,573,652 $ 5,956 $ 112 $ 392 $ 4,071,429 $ 688,853 $ 182,255 $ 780,966 $ 340,577 $ 427 Total: $ 55,183,423 $ 29,193,061 $ 50,655,790 $ 29,087,396 City of Waukee FY2017 Department Report - General Fund As of April 3, 2017 Expended YTD Budgeted $ Remaining General Fund: Police Department Personnel Services $ 1,588,944 Supplies & Services $ 227,661 Capital Outlay $ 139,526 $ 1,956,131 $ 2,661,080 $ 704,949 Warning Sirens Personnel Services $ 107 Supplies & Services $ (979) Capital Outlay $ (872) $ 2,000 $ 2,872 Westcom Dispatch Personnel Services Supplies & Services $ 347,319 Capital Outlay $ 347,319 $ 430,500 $ 83,181 Fire Department Personnel Services $ 504,932 Supplies & Services $ 68,395 Capital Outlay $ - $ 573,327 $ 830,720 $ 257,393 EMS Personnel Services $ 494,492 Supplies & Services $ 67,802 Capital Outlay $ - $ 562,294 $ 762,600 $ 200,306 Building Inspection Personnel Services $ 220,767 Supplies & Services $ 16,608 Capital Outlay $ 33,639 $ 271,014 $ 398,830 $ 127,816 Animal Control Personnel Services Supplies & Services $ 4,620 Capital Outlay $ 4,620 $ 1,000 $ (3,620) Library Services Personnel Services $ 400,283 Supplies & Services $ 144,771 Capital Outlay $ - $ 545,054 $ 852,275 $ 307,221 Mosquito Control Personnel Services $ Supplies & Services $ Capital Outlay $ - $ - $ 6,500 $ 6,500 Parks Personnel Services $ 177,292 Supplies & Services $ 113,418 Capital Outlay $ 69,648 $ 360,358 $ 480,297 $ 119,939 Recreation Personnel Services $ 244,229 Supplies & Services $ 127,843 Capital Outlay $ - $ 372,072 $ 523,662 $ 151,590 Community Center Personnel Services $ 2,538 Supplies & Services $ 10,850 Capital Outlay $ - $ 13,388 $ 24,320 $ 10,932 Public Works Personnel Services $ 55,495 Supplies & Services $ (9,600) Capital Outlay $ $ 45,895 $ 73,644 $ 27,749 Public Works Building Personnel Services $ - Supplies & Services $ 118,333 Capital Outlay $ 10,500 $ 128,833 $ - $ (128,833) Public Works Mechanic Personnel Services $ 124,017 Supplies & Services $ 128,607 Capital Outlay $ - $ 252,624 $ 171,750 $ (80,874) 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,015 Capital Outlay $ - $ 34,964 $ 72,840 $ 37,876 Elections Personnel Services $ Supplies & Services $ Capital Outlay $ - $ - $ 8,000 $ 8,000 Communications Personnel Services $ 40,788 Supplies & Services $ 5,312 Capital Outlay $ - $ 46,100 $ 114,808 $ 68,708 Administration Personnel Services $ 130,185 Supplies & Services $ 106,887 Capital Outlay $ 321,206 $ 558,278 $ 348,250 $ (210,028) City Hall Personnel Services $ - Supplies & Services $ 41,811 Capital Outlay $ 1,003 $ 42,814 $ 79,000 $ 36,186 Human Resources Personnel Services $ 45,211 Supplies & Services $ 6,577 Capital Outlay $ - $ 51,788 $ 80,138 $ 28,350 Financial Administration Personnel Services $ 86,248 Supplies & Services $ 18,314 Capital Outlay $ - $ 104,562 $ 198,922 $ 94,360 Community Development Personnel Services $ 157,094 Supplies & Services $ 86,482 Capital Outlay $ - $ 243,576 $ 324,240 $ 80,664 City Attorney Personnel Services $ - Supplies & Services $ 119,198 Capital Outlay $ - $ 119,198 $ 100,000 $ (19,198) Development Services Personnel Services $ 218,906 Supplies & Services $ 36,838 Capital Outlay $ - $ 255,743 $ 524,535 $ 268,792 Information Technology Personnel Services $ - Supplies & Services Capital Outlay $ 5,272 $ 5,272 $ - $ (5,272) Engineering Personnel Services $ 255,067 GIS Supplies & Services Capital Outlay Personnel Services Supplies & Services Capital Outlay Transfers to GO Debt Service Total General Fund: $ 46,460 $ 12,924 $ 18,408 $ (4,619) $ 12,924 Personnel Services $ 4,790,952 Supplies & Services $ 1,844,846 Capital Outlay $ 606,639.60 314,451 $ 625,139 $ 310,688 26,713 $ 27,655 $ 942 $ 7,242,438 $ 9,736,705 $ 2,494,267 $ 7,242,438 Expense Approval Register t1/ City of Waukee, 1A APPKT00542 - APRIL 4TH 2O17 COUNCIL PACKET Waukee Vendor Name Payable Number Post Date Description (Item) Account Number Amount Department: 1100- POLICE OPERATIONS MID AMERICAN ENERGY 0000010317 03/21/2017 MARCH'17 STATEMENT 010-10.1100.480000 654.81 TYLER TECHNOLOGIES INC 025-184167 04/01/2017 CONTENT/DOCUMENT MG 010-10.1100.270000 59.68 FEDEX OFFICE 046800021599 03/14/2017 SAFETY CITY SHIPPING 010-10.1100.460200 288.75 ELECTRONIC ENGINEERING C 121000624-1 03/20/2017 RADIO PROGRAMMING 010-10.1100.410000 35.00 ELECTRONIC ENGINEERING C 136000177-2 03/15/2017 GENETECSOFTWARE 010-10,1100.270100 62.50 ACCESS SYSTEMS LEASING 20348328 03/17/2017 MARCH'17 COPIER/PRINTER 010-10.1100.270110 3,141.62 METHODIST OCCUPATIONAL 221067 02/28/2017 PRE EMPLOYMENT SCREENS 010-10.1100.470000 348.00 RANKIN COMMUNICATION S 226747 03/14/2017 PROGRAMMING 010-10.1100.540000 389.95 HOLMES MURPHY 403576 04/01/2017 APR'17 HMA MONTHLY CO 010-10.1100.100000 945.78 CARPENTER UNIFORM CO 435502 03/13/2017 DETECTIVE BREAST BADGE- 010-10.1100.120000 255.56 CARPENTER UNIFORM CO 435732 03/17/2017 SHIRT-ARMSTRONG 010-10.1100.120000 58.99 CARPENTER UNIFORM CO 435865 03/20/2017 BADGE EMBLEMS-CHEIF/LIE 010-10.1100.120000 615.00 NATIONWIDE OFFICE CLEAN 59912 03/15/2017 CLEANING SERVICES -POLIC 010-10.1100.400100 554.24 DELTA DENTAL 609039 04/01/2017 APR'17 DENTAL INSURANCE 010-10.1100.100000 1,848.49 ADECCO EMPLOYMENT SER 68467113 03/13/2017 CONTRACT LABOR FLORES 010-10.1100.230000 436.08 ADECCO EMPLOYMENT SER 68475439 03/20/2017 CONTRACT LABOR- FLORES 010-10.1100.230000 526.93 OFFICE DEPOT 909060377001 02/27/2017 55GALCONTAINER 010-10.1100.580000 70.81 OFFICE DEPOT 909060701001 02/28/2017 COFFEE 010-10.1100.590000 41.97 VERIZON WIRELESS 9782070622 03/13/2017 MARCH'17 STATEMENT 010-10.1100.450000 902.14 VERIZON WIRELESS 9782070623 03/13/2017 MARCH'17 STATEMENT 010-10.1100.450000 22.62 CONSOLIDATED COMMUNIC INV0002626 03/08/2017 MARCH'17 STATEMENT -PO 010-10.1100.450000 346.97 HY-VEE INV0002655 03/10/2017 MARCH'17 FUEL - POLICE 010-10.1100.570000 2,522.50 ACCESS SYSTEMS INV504919 03/06/2017 DISPLAY PORTTO VGA VIDE 010-10.1100.540000 28.66 INTERSTATE POWER SYSTEM R012054463:01 03/03/2017 REPAIR ALTERNATOR 010-10.1100.400000 453.89 Department 1100 - POLICE OPERATIONS Total: 14,610.94 Department: 1400 - FIRE PROTECTION MIDAMERICAN ENERGY 0000010317 03/21/2017 MARCH'17 STATEMENT 010-10.1400.480000 434.00 CUMMINS CENTRAL POWER 020-92790 03/10/2017 REPLACE FAILED ACTUATOR 010-10.1400.410000 100.00 TYLER TECHNOLOGIES INC 025-184167 04/01/2017 CONTENT/DOCUMENT MG 010-10.1400.270000 59.68 ED M FELD EQUIPMENT CO 0309163-IN 03/21/2017 FUNCTION TEST/REPAIRS 010-10.1400.410100 1,876.12 THE WALDINGER CORP 110803-22 03/17/2017 HVAC PREVENTATIVE MAINT 010-10.1400.400000 490.75 INTERSTATE ALL BATTERY CE 1924602023406 03/12/2017 BATTERIES 010-10.1400.410100 73.45 ACCESS SYSTEMS LEASING 20348328 03/17/2017 MARCH'17 COPIER/PRINTER 010-10.1400.270110 111.87 METHODIST OCCUPATIONAL 221067 02/28/2017 PRE EMPLOYMENT SCREENS 010-10,1400.470000 77.00 HOLMES MURPHY 403576 04/01/2017 APR'17 HMA MONTHLY CO 010-10.1400.100000 168.24 DELTA DENTAL 609039 04/01/2017 APR'17 DENTAL INSURANCE 010-10.1400.100000 432.03 LIBERTY READY MIX 83202 03/06/2017 CONCRETE 010-10.1400.400000 204.56 LIBERTY READY MIX 83241 03/07/2017 CONCRETE 010-10.1400.400000 894.38 LIBERTY READY MIX 83290 03/08/2017 CONCRETE 010-10.1400.400000 675.00 OFFICE DEPOT 913367724001 03/15/2017 PAPER 010-10.1400.590000 79.00 VERIZON WIRELESS 9782070622 03/13/2017 MARCH'17 STATEMENT 010-10.1400.450000 172.45 CAPITAL SANITARY SUPPLY C227997A 03/15/2017 FLO-THRU BRUSH W/FLAGG 010-10.1400.590000 78.12 CAPITAL SANITARY SUPPLY C228142A 03/20/2017 HANDLE TAPERED I2CS 010-10.1400.590000 10.95 CAPITAL SANITARY SUPPLY C230072 03/24/2017 CLEANER/SUPPLIES 010-10.1400.590000 243.96 Department 1400 - FIRE PROTECTION Total: 6,181.56 Department: 1500 - EMS MID AMERICAN ENERGY 0000010317 03/21/2017 MARCH'17 STATEMENT 010-10.1500.480000 434.00 TYLER TECHNOLOGIES INC 025-184167 04/01/2017 CONTENT/DOCUMENT MG 010-10.1500.270000 59.68 THE WALDINGER CORP 110803-22 03/17/2017 HVAC PREVENTATIVE MAINT 010-10.1500.400000 490.75 HOLMES MURPHY 403576 04/01/2017 APR'17 HMA MONTHLY CO 010-10.1500.100000 168.23 DELTA DENTAL 609039 04/01/2017 APR'17 DENTAL INSURANCE 010-10.1500.100000 432.03 BOUND TREE MEDICAL 82431633 03/09/2017 MEDICALSUPPLIES 010-10.1500.590050 348.86 LIBERTY READY MIX 83202 03/06/2017 CONCRETE 010-10.1500.400000 204.57 3/29/2017 12:11:32 PM Page 1 of 17 Expense Approval Register Vendor Name Payable Number LIBERTY READY MIX 83241 LIBERTY READY MIX 83290 VERIZON WIRELESS 9782070622 Department: 1600 - STREET LIGHTING MID AMERICAN ENERGY 160080317 MID AMERICAN ENERGY 200080317 MID AMERICAN ENERGY 300210317 MID AMERICAN ENERGY 400350317 MID AMERICAN ENERGY 720060317 MID AMERICAN ENERGY 860480317 MID AMERICAN ENERGY INV0002649 MID AMERICAN ENERGY INV0002650 Department: 1601- TRAFFIC SIGNALS MID AMERICAN ENERGY 060280317 MID AMERICAN ENERGY 160060317 MID AMERICAN ENERGY 180800317 MIDAMERICAN ENERGY 240090317 MIDAMERICAN ENERGY 350760317 MID AMERICAN ENERGY 520110317 MID AMERICAN ENERGY 530030317 MID AMERICAN ENERGY 570220317 MID AMERICAN ENERGY 641750317 MID AMERICAN ENERGY 740030317 Department: 1900 - BUILDING INSPECTION Packet: APPKT00542 - APRIL 4TH 2O17 COUNCIL PACKET Post Date Description (Item) Account Number Amount 03/07/2017 CONCRETE 010-10.1500,400000 894.38 03/08/2017 CONCRETE 010-10.1500.400000 675.00 03/13/2017 MARCH'17 STATEMENT 010-10.1500.450000 172.45 Department 1500 - EMS Total: 3,879.95 03/21/2017 MARCH'17 STATEMENT 060-30.1600.480000 553.70 03/21/2017 MARCH'17 STATEMENT 060-30.1600.480000 501.14 03/23/2017 MARCH'17 STATEMENT 060-30.1600.480000 4.17 03/21/2017 MARCH'17 STATEMENT 060-30.1600.480000 526.44 03/21/2017 MARCH'17 STATEMENT 060-30.1600.480000 421.54 03/21/2017 MARCH'17 STATEMENT 060-30.1600.480000 16.51 03/24/2017 SOUTHFORK STREET LIGHTS 060-30.1600.760000 169,048.87 03/24/2017 HPS TO LED CONVERSION 060-30.1600.410300 20,500.00 Department 1600 - STREET LIGHTING Total: 191,572.37 03/21/2017 MARCH'17 STATEMENT 060-30.1601.480000 24.03 03/21/2017 MARCH'17 STATEMENT 060-30.1601.480000 27.18 03/21/2017 MARCH'17 STATEMENT 060-30.1601.480000 19.04 03/21/2017 MARCH'17 STATEMENT 060-30,1601.480000 17.61 03/21/2017 MARCH'17 STATEMENT 060-30.1601.480000 39.90 03/21/2017 MARCH'17 STATEMENT 060-30.1601.480000 10.00 03/21/2017 MARCH'17 STATEMENT 060-30.1601.480000 24.95 03/10/2017 MARCH'17 STATEMENT 060-30.1601.480000 14.73 03/21/2017 MARCH'17 STATEMENT 060-30.1601.480000 14.35 03/21/2017 MARCH'17 STATEMENT 060-30.1601.480000 43.46 Department 1601- TRAFFIC SIGNALS Total: 235.25 TYLER TECHNOLOGIES INC 025-184167 04/01/2017 CONTENT/DOCUMENT MG 010-10.1900.270000 59.68 ACCESS SYSTEMS LEASING 20348328 03/17/2017 MARCH'17 COPIER/PRINTER 010-10.1900.270110 111.87 METHODIST OCCUPATIONAL 221067 02/28/2017 PRE EMPLOYMENT SCREENS 010-10.1900.470000 87.00 HOLMES MURPHY 403576 04/01/2017 APR'17 HMA MONTHLY CO 010-10.1900.100000 127.32 DELTA DENTAL 609039 04/01/2017 APR'17 DENTAL INSURANCE 010-10,1900.100000 299.86 VERIZON WIRELESS 9782070622 03/13/2017 MARCH'17 STATEMENT 010-10.1900.450000 276.03 Department 1900 - BUILDING INSPECTION Total: 961.76 Department: 2130 - ALICES ROAD PROJECT SNYDER&ASSOCIATES INC 116.0732.01-4 03/14/2017 HICKMAN & ALICES IMPRVM 327-90.2130.230040 855.00 FOTH INFRASTRUCTURE & E 51565 03/09/2017 GPP & ESKER RIDGE TRAFFIC 327-90.2130.230051 8,282.50 FOTH INFRASTRUCTURE & E 51638 03/15/2017 PHASE 3 ALICES RDTRAFFIC 327-90.2130.840470 150.00 FOTH INFRASTRUCTURE & E 51643 03/15/2017 SE ALICES RD/SE OLSON DR/ 327-90.2130.840491 55,526.24 Department 2130 -ALICES ROAD PROJECT Total: 64,813.74 Department: 2131- ESKER RIDGE - RISE PROJECT FOTH INFRASTRUCTURE & E 51637 03/15/2017 SE ESKER RIDGE DRIVE RISE 327-90.2131.230051 790.00 Department 2131- ESKER RIDGE - RISE PROJECT Total: 790.00 Department: 2132 - ASH WORTH ROAD IMPROVEMENTS FOTH INFRASTRUCTURE&E 516585 03/20/2017 ESTIMATING SE ASHWORTH 327-90.2132.230000 1,106.00 Department 2132 -ASHWORTH ROAD IMPROVEMENTS Total: 1,106.00 Department: 2133 -10TH STREET IMPROVEMENTS FOTH INFRASTRUCTURE & E 516585 03/20/2017 NW 10TH STREET- HICKMA 327-90.2133.230000 32,358.00 Department 2133 - 10TH STREET IMPROVEMENTS Total: 32,358.00 Department: 3100 - LIBRARY SERVICES FAREWAY STORES, INC. 00226824 03/17/2017 PLASTIC BAGS 010-40.3100.460300 21.53 TYLER TECHNOLOGIES INC 025-184167 04/01/2017 CONTENT/DOCUMENT MG 010-40.3100.270000 59.68 TEI LANDMARK AUDIO 11849576 02/16/2017 AUDIO BOOKS 010-40.3100,640000 71.12 CENTER POINT PUBLISHING 1453396 03/01/2017 BOOKS 010-40.3100.640000 135.42 SCHOLASTIC, INC 14764215 03/16/2017 BOOKS 010-40.3100.460400 583.75 ACCESS SYSTEMS LEASING 20348328 03/17/2017 MARCH'17 COPIER/PRINTER 010-40.3100.270110 223.73 HOLMES MURPHY 403576 04/01/2017 APR'17 HMA MONTHLY CO 010-40.3100.100000 245.54 MERRITT COMPANY INC 50116 03/21/2017 MARCH'17 CLEANING SERVI 010-40,3100.400100 610.00 3/29/2017 12:11:32 PM Page 2 of 17 Expense Approval Register Packet: APPKT00542 - APRIL 4TH 2O17 COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount MID AMERICAN ENERGY 520160317 03/21/2017 MARCH'17 STATEMENT 010-40.3100.480000 2,586.37 DEMCO INC. 6089507 03/16/2017 BUBBLES/BLOCKS/SHIRTS 010-40.3100.460400 410.42 DELTA DENTAL 609039 04/01/2017 APR'17 DENTAL INSURANCE 010-40.3100.100000 458.04 DEMCO INC. 6092552 03/20/2017 BOOK TAPE/LABELS/LABELP 010-40.3100.590000 731.54 OFFICE DEPOT 908425817001 02/24/2017 SIGN 010-40.3100.580000 108.99 OFFICE DEPOT 912193709001 03/10/2017 LABELS/PAPER/WIPES 010-40.3100.580000 59.77 OFFICE DEPOT 912194083001 03/13/2017 GROCERY BAGS 010-40.3100.580000 16.39 INGRAM LIBRARY SERVICES 97337455 02/17/2017 BOOKS 010-40.3100.590000 1.10 INGRAM LIBRARY SERVICES 97337455 02/17/2017 BOOKS 010-40.3100.640000 52.49 INGRAM LIBRARY SERVICES 97337456 02/17/2017 BOOKS 010-40.3100.590000 1.80 INGRAM LIBRARY SERVICES 97337456 02/17/2017 BOOKS 010-40,3100.640000 46.47 INGRAM LIBRARY SERVICES 97337457 02/17/2017 BOOKS 010-40.3100.590000 2.05 INGRAM LIBRARY SERVICES 97337457 02/17/2017 BOOKS 010-40.3100.640000 37.97 INGRAM LIBRARY SERVICES 97337458 02/17/2017 BOOKS 010-40.3100.590000 0.54 INGRAM LIBRARY SERVICES 97337458 02/17/2017 BOOKS 010-40.3100.640000 14.95 INGRAM LIBRARY SERVICES 97337459 02/17/2017 BOOKS 010-40.3100.590000 1.29 INGRAM LIBRARY SERVICES 97337459 02/17/2017 BOOKS 010-40.3100.640000 14.95 INGRAM LIBRARY SERVICES 97380691 02/21/2017 BOOKS 010-40.3100.590000 0.54 INGRAM LIBRARY SERVICES 97380691 02/21/2017 BOOKS 010-40.3100.640000 10.34 INGRAM LIBRARY SERVICES 97380692 02/21/2017 BOOKS 010-40.3100.590000 2.39 INGRAM LIBRARY SERVICES 97380692 02/21/2017 BOOKS 010-40.3100.640000 4.79 INGRAM LIBRARY SERVICES 97380693 02/21/2017 BOOKS 010-40.3100.590000 1.85 INGRAM LIBRARY SERVICES 97380693 02/21/2017 BOOKS 010-40.3100.640000 25.11 INGRAM LIBRARY SERVICES 97380694 02/21/2017 BOOKS 010-40.3100.590000 3.24 INGRAM LIBRARY SERVICES 97380694 02/21/2017 BOOKS 010-40.3100.640000 5.99 INGRAM LIBRARY SERVICES 97380695 02/21/2017 BOOKS 010-40.3100.640000 23.57 INGRAM LIBRARY SERVICES 97380696 02/21/2017 RAISED BED REVOLUTION 010-40.3100.460300 34.50 INGRAM LIBRARY SERVICES 97380697 02/21/2017 BOOKS 010-40.3100.590000 7.40 INGRAM LIBRARY SERVICES 97380697 02/21/2017 BOOKS 010-40.3100.640000 23.96 INGRAM LIBRARY SERVICES 97417249 02/23/2017 BOOKS 010-40.3100.590000 1.19 INGRAM LIBRARY SERVICES 97417249 02/23/2017 BOOKS 010-40.3100.640000 10.34 INGRAM LIBRARY SERVICES 974172SI 02/23/2017 BOOKS 010-40.3100.590000 1.39 INGRAM LIBRARY SERVICES 97417251 02/23/2017 BOOKS 010-40.3100.640000 16.09 INGRAM LIBRARY SERVICES 97429274 02/24/2017 BOOKS 010-40.3100.590000 0.90 INGRAM LIBRARY SERVICES 97429274 02/24/2017 BOOKS 010-40.3100.640000 9.74 INGRAM LIBRARY SERVICES 97429275 02/24/2017 BOOKS 010-40.3100.590000 0.25 INGRAM LIBRARY SERVICES 97429275 02/24/2017 BOOKS 010-40.3100.640000 22.46 INGRAM LIBRARY SERVICES 97429277 02/24/2017 BOOKS 010-40.3100.590000 1.85 INGRAM LIBRARY SERVICES 97429277 02/24/2017 BOOKS 010-40.3100.640000 10.17 INGRAM LIBRARY SERVICES 97429278 02/24/2017 BOOKS 010-40.3100.590000 0.25 INGRAM LIBRARY SERVICES 97429278 02/24/2017 BOOKS 010-40.3100.640000 22.46 INGRAM LIBRARY SERVICES 97429279 02/24/2017 BOOKS 010-40.3100,590000 0.90 INGRAM LIBRARY SERVICES 97429279 02/24/2017 BOOKS 010-40.3100.640000 8.44 INGRAM LIBRARY SERVICES 97429280 02/24/2017 BOOKS 010-40.3100.590000 0.25 INGRAM LIBRARY SERVICES 97429280 02/24/2017 BOOKS 010-40.3100.640000 22.46 INGRAM LIBRARY SERVICES 97429281 02/24/2017 BOOKS 010-40.3100.590000 0.25 INGRAM LIBRARY SERVICES 97429281 02/24/2017 BOOKS 010-40.3100.640000 20.24 INGRAM LIBRARY SERVICES 97429282 02/24/2017 BOOKS 010-40.3100.590000 32.89 INGRAM LIBRARY SERVICES 97429282 02/24/2017 BOOKS 010-40.3100.640000 283.37 INGRAM LIBRARY SERVICES 97429283 02/24/2017 BOOKS 010-40.3100.590000 10.09 INGRAM LIBRARY SERVICES 97429283 02/24/2017 BOOKS 010-40.3100.640000 34.10 INGRAM LIBRARY SERVICES 97429284 02/24/2017 BOOKS 010-40.3100.590000 2.25 INGRAM LIBRARY SERVICES 97429284 02/24/2017 BOOKS 010-40.3100.640000 13.99 INGRAM LIBRARY SERVICES 97496874 03/01/2017 BOOKS 010-40.3100.590000 1.19 INGRAM LIBRARY SERVICES 97496874 03/O1/2017 BOOKS 010-40.3100.640000 10.34 INGRAM LIBRARY SERVICES 97496875 03/O1/2017 BOOKS 010-40.3100.590000 29.48 INGRAM LIBRARY SERVICES 97496875 03/O1/2017 BOOKS 010-40.3100.640000 159.71 INGRAM LIBRARY SERVICES 97496876 03/O1/2017 BOOKS 010-40.3100.590000 22.68 INGRAM LIBRARY SERVICES 97496876 03/01/2017 BOOKS 010-40.3100.640000 252.04 INGRAM LIBRARY SERVICES 97496877 03/01/2017 BOOKS 010-40.3100.640000 10.34 3/29/2017 12:11:32 PM Page 3 of 17 Expense Approval Register Packet: APPKT00542 - APRIL 4TH 2O17 COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount INGRAM LIBRARY SERVICES 97496878 03/O1/2017 BOOKS 010-40.3100.590000 0.25 INGRAM LIBRARY SERVICES 97496878 03/O1/2017 BOOKS 010-40.3100,640000 4.54 INGRAM LIBRARY SERVICES 97496879 03/01/2017 BOOKS 010-40.3100.590000 0.50 INGRAM LIBRARY SERVICES 97496879 03/01/2017 BOOKS 010-40.3100.640000 44.98 INGRAM LIBRARY SERVICES 97516312 03/02/2017 BOOKS 010-40.3100.590000 2.78 INGRAM LIBRARY SERVICES 97516312 03/02/2017 BOOKS 010-40.3100.640000 21.83 INGRAM LIBRARY SERVICES 97516313 03/02/2017 BOOKS 010-40.3100.590000 17.83 INGRAM LIBRARY SERVICES 97516313 03/02/2017 BOOKS 010-40.3100.540000 87.98 INGRAM LIBRARY SERVICES 97516314 03/02/2017 BOOKS 010-40.3100.590000 3.70 INGRAM LIBRARY SERVICES 97516314 03/02/2017 BOOKS 010-40.3100.640000 10.78 INGRAM LIBRARY SERVICES 97516315 03/02/2017 BOOKS 010-40.3100.590000 0.25 INGRAM LIBRARY SERVICES 97516315 03/02/2017 BOOKS 010-40.3100.640000 59.95 INGRAM LIBRARY SERVICES 97528140 03/03/2017 BOOKS 010-40.3100.590000 1.19 INGRAM LIBRARY SERVICES 97528140 03/03/2017 BOOKS 010-40.3100.640000 10.34 INGRAM LIBRARY SERVICES 97528141 03/03/2017 BOOKS 010-40.3100.590000 5.95 INGRAM LIBRARY SERVICES 97528141 03/03/2017 BOOKS 010-40.3100.640000 44.50 INGRAM LIBRARY SERVICES 97528142 03/03/2017 BOOKS 010-40.3100.590000 63.15 INGRAM LIBRARY SERVICES 97528142 03/03/2017 BOOKS 010-40.3100.640000 256.68 INGRAM LIBRARY SERVICES 97528143 03/03/2017 BOOKS 010-40.3100.590000 1.19 INGRAM LIBRARY SERVICES 97528143 03/03/2017 BOOKS 010-40.3100.640000 9.77 INGRAM LIBRARY SERVICES 97577088 03/07/2017 BOOKS 030-40.3100.590000 1.19 INGRAM LIBRARY SERVICES 97577088 03/07/2017 BOOKS 010-40.3100.640000 9.77 INGRAM LIBRARY SERVICES 97577089 03/07/2017 BOOKS 010-40.3100.590000 4.99 INGRAM LIBRARY SERVICES 97577089 03/07/2017 BOOKS 010-40.3100.640000 19.24 INGRAM LIBRARY SERVICES 97577090 03/07/2017 BOOKS 010-40.3100.640000 10.92 INGRAM LIBRARY SERVICES 97577091 03/07/2017 BOOKS 010-40.3100.590000 1.19 INGRAM LIBRARY SERVICES 97577091 03/07/2017 BOOKS 010-40.3100.640000 10.34 INGRAM LIBRARY SERVICES 97577092 03/07/2017 BOOKS 010-40.3100.590000 0.54 INGRAM LIBRARY SERVICES 97577092 03/07/2017 BOOKS 010-40.3100.640000 16.09 INGRAM LIBRARY SERVICES 97577093 03/07/2017 BOOKS 010-40.3100.590000 0.54 INGRAM LIBRARY SERVICES 97577093 03/07/2017 BOOKS 010-40.3100.640000 7.47 INGRAM LIBRARY SERVICES 97604248 03/09/2017 BOOKS 010-40.3100.640000 9.58 INGRAM LIBRARY SERVICES 97615737 03/09/2017 BOOKS 010-40.3100.590000 3.68 INGRAM LIBRARY SERVICES 97615737 03/09/2017 BOOKS 010-40.3100.640000 18.38 INGRAM LIBRARY SERVICES 97615738 03/09/2017 BOOKS 010-40.3100.590000 1.84 INGRAM LIBRARY SERVICES 97615738 03/09/2017 BOOKS 010-40,3100.640000 9.77 INGRAM LIBRARY SERVICES 97615739 03/09/2017 BOOKS 010-40.3100.590000 1.84 INGRAM LIBRARY SERVICES 97615739 03/09/2017 BOOKS 010-40.3100.640000 8.62 INGRAM LIBRARY SERVICES 97615740 03/09/2017 BOOKS 010-40.3100.590000 82.43 INGRAM LIBRARY SERVICES 97615740 03/09/2017 BOOKS 010-40.3100.640000 310.51 INGRAM LIBRARY SERVICES 97615741 03/09/2017 BOOKS 010-40.3100.590000 5.55 INGRAM LIBRARY SERVICES 97615741 03/09/2017 BOOKS 010-40.3100.640000 65.80 INGRAM LIBRARY SERVICES 97615742 03/09/2017 BOOKS 010-40.3100.590000 1.85 INGRAM LIBRARY SERVICES 97615742 03/09/2017 BOOKS 010-40,3100.640000 50.21 INGRAM LIBRARY SERVICES 97615743 03/09/2017 BOOKS 010-40.3100.590000 9.75 INGRAM LIBRARY SERVICES 97615743 03/09/2017 BOOKS 010-40.3100.640000 92.55 INGRAM LIBRARY SERVICES 97615744 03/09/2017 BOOKS 010-40.3100.590000 1.10 INGRAM LIBRARY SERVICES 97615744 03/09/2017 BOOKS 010-40.3100.640000 22.49 INGRAM LIBRARY SERVICES 97615745 03/09/2017 BOOKS 010-40.3100.590000 1.39 INGRAM LIBRARY SERVICES 97615745 03/09/2017 BOOKS 030-40.3100.640000 15.53 INGRAM LIBRARY SERVICES 97615746 03/09/2017 BOOKS 010-40.3100.590000 1.39 INGRAM LIBRARY SERVICES 97615746 03/09/2017 BOOKS 010-40.3100.640000 16.09 INGRAM LIBRARY SERVICES 97615749 03/09/2017 BOOKS 010-40.3100.590000 1.19 INGRAM LIBRARY SERVICES 97615749 03/09/2017 BOOKS 010-40.3100.640000 9.77 INGRAM LIBRARY SERVICES 97615750 03/09/2017 BOOKS 010-40.3100.590000 0.65 INGRAM LIBRARY SERVICES 97615750 03/09/2017 BOOKS 010-40.3100.640000 47.50 INGRAM LIBRARY SERVICES 97615751 03/09/2017 BOOKS 010-40.3100.590000 1.19 INGRAM LIBRARY SERVICES 97615751 03/09/2017 BOOKS 010-40.3100.640000 9.77 INGRAM LIBRARY SERVICES 97670018 03/14/2017 BOOKS 010-40.3100.590000 3.77 INGRAM LIBRARY SERVICES 97670018 03/14/2017 BOOKS 010-40.3100,640000 50.50 3/29/2017 12:11:32 PM Page 4 of 17 Expense Approval Register Packet: APPKT00542 -APRIL 4TH 2O17 COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount INGRAM LIBRARY SERVICES 97670020 03/14/2017 BOOKS 010-40.3100.590000 3.95 INGRAM LIBRARY SERVICES 97670020 03/14/2017 BOOKS 010-40.3100.640000 62.14 INGRAM LIBRARY SERVICES 97670021 03/14/2017 BOOKS 010-40.3100.590000 1.39 INGRAM LIBRARY SERVICES 97670021 03/14/2017 BOOKS 010-40.3100.640000 9.19 INGRAM LIBRARY SERVICES 97670022 03/14/2017 BOOKS 010-40.3100.590000 1.39 INGRAM LIBRARY SERVICES 97670022 03/14/2017 BOOKS 010-40.3100.640000 16.67 INGRAM LIBRARY SERVICES 97670023 03/14/2017 BOOKS 010-40.3100.590000 7.28 INGRAM LIBRARY SERVICES 97670023 03/14/2017 BOOKS 010-40.3100.640000 34.11 INGRAM LIBRARY SERVICES 97670024 03/14/2017 BOOKS 010-40.3100.640000 15.53 INGRAM LIBRARY SERVICES 97688983 03/15/2017 BOOKS 010-40.3100.590000 1.39 INGRAM LIBRARY SERVICES 97688983 03/15/2017 BOOKS 010-40.3100.640000 15.53 INGRAM LIBRARY SERVICES 97688984 03/15/2017 BOOKS 010-40,3100.590000 1.19 INGRAM LIBRARY SERVICES 97688984 03/15/2017 BOOKS 010-40.3100.640000 5.74 INGRAM LIBRARY SERVICES 97688985 03/15/2017 BOOKS 010-40.3100.590000 2.50 INGRAM LIBRARY SERVICES 97688985 03/15/2017 BOOKS 010-40.3100.640000 3.59 INGRAM LIBRARY SERVICES 97719361 03/17/2017 BOOKS 010-40.3100.590000 7.04 INGRAM LIBRARY SERVICES 97719361 03/17/2017 BOOKS 010-40.3100.640000 14.99 INGRAM LIBRARY SERVICES 97719362 03/17/2017 BOOKS 010-40.3100.590000 1.84 INGRAM LIBRARY SERVICES 97719362 03/17/2017 BOOKS 010-40.3100.640000 15.53 INGRAM LIBRARY SERVICES 97719364 03/17/2017 BOOKS 010-40.3100.590000 4.88 INGRAM LIBRARY SERVICES 97719364 03/17/2017 BOOKS 010-40.3100.640000 39.46 INGRAM LIBRARY SERVICES 97719365 03/17/2017 BOOKS 010-40.3100.590000 6.68 INGRAM LIBRARY SERVICES 97719365 03/17/2017 BOOKS 010-40.3100.640000 39.37 INGRAM LIBRARY SERVICES 97719366 03/17/2017 BOOKS 010-40.3100.640000 11.50 INGRAM LIBRARY SERVICES 97719367 03/17/2017 BOOKS 010-40.3100.590000 4.05 INGRAM LIBRARY SERVICES 97719367 03/17/2017 BOOKS 010-40.3100.640000 16.49 INGRAM LIBRARY SERVICES 97719368 03/17/2017 BOOKS 010-40.3100.640000 22.49 INGRAM LIBRARY SERVICES 97719369 03/17/2017 BOOKS 010-40.3100.590000 3.68 INGRAM LIBRARY SERVICES 97719369 03/17/2017 BOOKS 010-40.3100.640000 31.63 INGRAM LIBRARY SERVICES 97719371 03/17/2017 BOOKS 010-40.3100.590000 0.85 INGRAM LIBRARY SERVICES 97719371 03/17/2017 BOOKS 010-40.3100.640000 21.74 INGRAM LIBRARY SERVICES 97719372 03/17/2017 BOOKS 010-40.3100.590000 18.30 INGRAM LIBRARY SERVICES 97719372 03/17/2017 BOOKS 010-40.3100.640000 34.74 INGRAM LIBRARY SERVICES 97719373 03/17/2017 BOOKS 010-40.3100.590000 13.05 INGRAM LIBRARY SERVICES 97719373 03/17/2017 BOOKS 010-40.3100.640000 119.55 INGRAM LIBRARY SERVICES 97719374 03/17/2017 BOOKS 010-40.3100.590000 0.54 INGRAM LIBRARY SERVICES 97719374 03/17/2017 BOOKS 010-40.3100.640000 9.77 INGRAM LIBRARY SERVICES 97733116 03/19/2017 BOOKS 010-40.3100.590000 1.39 INGRAM LIBRARY SERVICES 97733116 03/19/2017 BOOKS 010-40.3100.640000 15.52 INGRAM LIBRARY SERVICES 97733117 03/19/2017 BOOKS 010-40.3100.590000 1.85 INGRAM LIBRARY SERVICES 97733117 03/19/2017 BOOKS 010-40.3100.640000 8.99 INGRAM LIBRARY SERVICES 97733118 03/19/2017 BOOKS 010-40.3100.590000 4.65 INGRAM LIBRARY SERVICES 97733118 03/19/2017 BOOKS 010-40.3100.640000 28.50 INGRAM LIBRARY SERVICES 97733119 03/19/2017 BOOKS 010-40.3100.590000 2.30 INGRAM LIBRARY SERVICES 97733119 03/19/2017 BOOKS 010-40.3100.640000 4.79 VERIZON WIRELESS 9782070622 03/13/2017 MARCH'17 STATEMENT 010-40.3100.450000 52.00 INGRAM LIBRARY SERVICES INV0002656 02/24/2017 BOOKS 010-40.3100.590000 0.50 INGRAM LIBRARY SERVICES INV0002656 02/24/2017 BOOKS 010-40.3100.640000 14.92 MARTHA STEWART LIVING INV0002662 02/11/2017 SUBSCRIPTION 010-40.3100.640000 25.00 HGTV MAGAZINE INV0002663 04/04/2017 SUBSCRIPTION 010-40.3100.640000 12.00 Department 3100 - LIBRARY SERVICES Total: 10,028.96 Department: 4100 - PARKS TYLER TECHNOLOGIES INC 025-184167 04/01/2017 CONTENT/DOCUMENT MG 010-40.4100.270000 59.68 FULLER PETROLEUM SERVIC 104760 03/14/2017 FUEL 010-40.4100.570000 209.55 GRAHAM TIRE OF DES MOIN 1100090132 03/07/2017 TIRES 010-40.4100.410100 160.90 ANKENY AMERICAN LEGION 131-DBP-17 03/10/2017 FLAGS 010-40.4100.590000 1,303.84 MID AMERICAN ENERGY 140570317 03/21/2017 MARCH'17 STATEMENT 010-40.4100.480000 15.16 METHODIST OCCUPATIONAL 221067 02/28/2017 PRE EMPLOYMENT SCREENS 010-40.4100.470000 87.00 MID AMERICAN ENERGY 311090317 03/21/2017 MARCH'17 STATEMENT 010-40.4100.480000 14.98 HOLMES MURPHY 403576 04/01/2017 APR'17 HMA MONTHLY CO 010-40.4100.100000 45.47 3/29/2017 12:11:32 PM Page 5 of 17 Expense Approval Register Packet: APPKT00542 - APRIL 4TH 2O17 COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount HOLMES MURPHY 403576 04/01/2017 APR'17 HMA MONTHLY CO 010-40.4100.100000 18.19 HOLMES MURPHY 403576 04/01/2017 APR'17 HMA MONTHLY CO 010-40.4100.100000 9.09 MID AMERICAN ENERGY 480250317 03/21/2017 MARCH'17 STATEMENT 010-40.4100.480000 10.00 DELTA DENTAL 609039 04/01/2017 APR'17 DENTAL INSURANCE 010-40.4100.100000 119.02 DELTA DENTAL 609039 04/01/2017 APR'17 DENTAL INSURANCE 010-40.4100.100000 23.80 DELTA DENTAL 609039 04/01/2017 APR'17 DENTAL INSURANCE 010-40.4100,100000 30.91 MID AMERICAN ENERGY 690070317 03/21/2017 MARCH'17 STATEMENT 010-40.4100.480000 15.79 MENARDS 72924 03/07/2017 #3 STANDARD 010-40.4100.410300 44.54 MENARDS 73052 03/08/2017 SELECT BOARD/VALUE SHELF 010-40.4100.410300 9.77 MENARDS 73846 03/16/2017 AC2 GREEN TREATED 010-40.4100.410300 195.16 VERIZON WIRELESS 9782070622 03/13/2017 MARCH'17 STATEMENT 010-40.4100.450000 97.93 Department 4100 - PARKS Total: 2,470.78 Department: 4200 - RECREATION GIFTS GALORE 0021466 12/06/2016 EASTER EGGS 010-40.4200.461600 480.00 TYLER TECHNOLOGIES INC 025-184167 04/01/2017 CONTENT/DOCUMENT MG 010-40A200.270000 59.68 ACCESS SYSTEMS LEASING 20348328 03/17/2017 MARCH'17 COPIER/PRINTER 010-40.4200.270110 111.86 HOLMES MURPHY 403576 04/01/2017 APR'17 HMA MONTHLY CO 010-40.4200.100000 109.13 HY-VEE 5833467439 02/16/2017 CANDY 010-40.4200.580000 14.28 DELTA DENTAL 609039 04/01/2017 APR'17 DENTAL INSURANCE 010-40.4200.100000 268.95 VERIZON WIRELESS 9782070622 03/13/2017 MARCH'17 STATEMENT 010-40.4200.450000 198.94 CARRIE EBY INV0002657 03/26/2017 PITCHING CLINIC 010-40.4200.460510 765.00 CENTRAL IOWA OFFICIALS INV0002658 04/04/2017 REC GIRLS SOFTBALL UMPIR 010-40.4200.460050 2,200.00 PHIL DICKEY INV0002659 03/24/2017 LITTLE NINIAS/TAEKWONDO 010-40.4200.460550 1,440.00 Department 4200 - RECREATION Total: 5,647.84 Department: 4300 - COMMUNITY CENTER HY-VEE 5842413702 03/03/2017 SENIOR ROOM SUPPLIES 010-40.4300.590000 14.86 NATIONWIDE OFFICE CLEAN 59911 03/15/2017 CLEANING SERVICES -COM 010-40.4300.400100 298.77 MEDIACOM INV0002632 03/07/2017 MARCH'17 STATEMENT 010-40.4300.480000 84.20 MARY ANN SCHULTZ INV0002654 04/04/2017 COMMUNITY CENTER RENTA 010-40.4300.4531000 155.00 Department 4300 - COMMUNITY CENTER Total: 552.83 Department: 5000 - BIKE TRAIL OLD RAILROAD FOTH INFRASTRUCTURE & E 51634 03/15/2017 TRAILHEAD ART PROJECT CO 327-90.5000.881130 514.00 VEENSTRA & KIMM INC INV0002652 02/27/2017 NORTH 10TH TRAIL HEAD PA 327-90.5000.881130 6,397.40 Department 5000 - BIKE TRAIL OLD RAILROAD Total: 6,911.40 Department: 5300-STORM WATER TYLER TECHNOLOGIES INC 025-184167 04/01/2017 CONTENT/DOCUMENT MG 560-80.5300.270000 59.68 HOLMES MURPHY 403576 04/01/2017 APR'17 HMA MONTHLY CO 560-80.5300.100000 90.94 HOLMES MURPHY 403576 04/01/2017 APR'17 HMA MONTHLY CO 560-80.5300.100000 15.92 FOTH INFRASTRUCTURE & E 51639 03/15/2017 CENTENNIAL PARK STREAM 560-80.5300.880015 1,143.00 DELTA DENTAL 609039 04/01/2017 APR'17 DENTAL INSURANCE 560-80.5300.100000 182.05 DELTA DENTAL 609039 04/01/2017 APR'17 DENTAL INSURANCE 560-80.5300.100000 37.48 VERIZON WIRELESS 9782070622 03/13/2017 MARCH'17 STATEMENT 560-80.5300.450000 204.03 O'HALLORAN INTERNATION DE-00982 03/16/2017 2017 INTERNATIONAL 4300 560-80.5300.760000 83,216.00 TRANS IOWA EQUIPMENTT E00082 03/08/2017 WN ROVVER X 300/ENVIROS 560-80.5300.760000 64,519.00 VEENSTRA & KIMM INC INV0002652 02/27/2017 SOUTHFORK DAM OUTLET 560-80.5300.230000 537.00 Department 5300 - STORM WATER Total: 150,005.10 Department: 5400 - SOLID WASTE COLLECTION & DISPOSAL TYLER TECHNOLOGIES INC 025-184167 04/01/2017 CONTENT/DOCUMENT MG 590-30.5400.270000 59.67 ANKENY SANITATION INC. 372883 12/01/2016 DECEMBER'16 STATEMENT 590-30.5400.231300 83,415.00 ANKENY SANITATION INC. 372890 01/01/2017 JANUARY'17 STATEMENT 590-30.5400.231300 83,867.25 ANKENY SANITATION INC. 372893 02/01/2017 FEBRUARY'17 STATEMENT 590-30.5400.231300 84,118.50 ANKENY SANITATION INC. 372894 03/01/2017 MARCH'17 STATEMENT 590-30.5400.231300 84,470.25 Department 5400 - SOLID WASTE COLLECTION & DISPOSAL Total: 335,930.67 Department: 6000- PUBLIC WORKS TILER TECHNOLOGIES INC 025-184167 04/01/2017 CONTENT/DOCUMENT MG 010-20.6000.270000 59.68 HOLMES MURPHY 403576 04/01/2017 APR'17 HMA MONTHLY CO 010-20.6000.100000 181.88 DELTA DENTAL 609039 04/01/2017 APR'17 DENTAL INSURANCE 010-20.6000.100000 420.09 VERIZON WIRELESS 9782070622 03/13/2017 MARCH'17 STATEMENT 010-20.6000.450000 209.92 3/29/2017 12:11:32 PIA Page 6 of 17 Expense Approval Register Packet: APPKTOOS42 - APRIL 4TH 2O17 COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount WAUKEE CHAMBER OF COM INV0002591 03/15/2017 NETWORKING LUNCHEON - 010-20.6000.470000 20.00 APWA IOWA CHAPTER INV0002634 03/09/2017 MEMBER DUES - GIBSON 010-20.6000.280000 190.00 Department 6000 - PUBLIC WORKS Total: 1,081.57 Department: 6010 - PUBLIC WORKS BUILDING STORAGE & DESIGN GROUP 11382 02/03/2017 STEELSHELVING 010-20.6010.400000 1,865.00 STORAGE & DESIGN GROUP 11385 02/06/2017 INSTALLATION OF STEELSHE 010-20.6010.400000 372.00 STORAGE & DESIGN GROUP 11434 03/06/2017 GIANT STACK CONTAINER 010-20.6010.400000 860.96 G & KSERVICES INC 1183676895 03/08/2017 MAT SERVICES -PW 010-20.6010.400000 137.77 G & KSERVICES INC 1183683662 03/22/2017 MAT SERVICES -PW 010-20.6010.400000 137.77 ACCESS SYSTEMS LEASING 20348328 03/17/2017 MARCH'17 COPIER/PRINTER 010-20.6010.270110 559.33 MID AMERICAN ENERGY 240000317 03/21/2017 MARCH'17 STATEMENT 010-20.6010.480000 1,427.27 MIDWEST ALARM SERVICES 272972 03/O9/2017 FIRE ALARM PW 010-20.6010.400000 477.48 STROH CORP 29205 03/16/2017 TROUBLESHOOT & REPAIR S 010-20.6010.400000 555.04 IOWA FIRE EQUIPMENTCO 293287 03/10/2017 FIRE SPRINKLER/WET PIPE 010-20.6010.400000 943.66 FASTSIGNS 42-91576 01/24/2017 HANDICAP BANNER 010-20.6010.400000 63.10 CONTINENTAL RESEARCH CO 447208-CRC-1 03/20/2017 HANDY DANDY 010-20.6010.580000 192.03 CINTAS CORPORATION 5007445050 03/24/2017 FIRST AID KIT SUPPLIES 010-20.6010.400000 189.31 NATIONWIDE OFFICE CLEAN 59740 03/15/2017 CLEANING SERVICES -PUBLI 010-20.6010.400100 1,247.04 MENARDS 71792 02/23/2017 OSB PANEL 010-20.6010.410100 14.98 MENARDS 72566 03/03/2017 CF MICRO 1100W BLK 010-20.6010.400000 129.00 OFFICE DEPOT 909184890001 03/01/2017 MOUSEPAD/HIGHLIGHTER/P 010-20,6010.580000 111.91 OFFICE DEPOT 909185032001 03/01/2017 8GB CRUZER GLIDE USB 010-20,6010.580000 36.92 OFFICE DEPOT 911508755001 03/08/2017 FORKS/SPOONS/KNIVES/PAP 010-20.6010.580000 224.08 OFFICE DEPOT 913853001001 03/17/2017 PENS/HIGHLIGHTERS 010-20.6010.580000 121.62 C2G CORPORATION CG4827 02/28/2017 RED THUNDER/SQUEEGEES/ 010-20.6010.590000 55.00 FASTENAL COMPANY IAGRM86192 03/15/2017 EYEWEAR/VEST/GLOVES 010-20.6010.590000 108.43 AT&TMOBILITY X03082017 03/08/2017 MARCH'175TATEMENT 010-20.6010.450000 58.13 Department 6010 - PUBLIC WORKS BUILDING Total: 9,887.83 Department: 6150 - PUBLIC WORKS MECHANIC TYLER TECHNOLOGIES INC 025-184167 04/O1/2017 CONTENT/DOCUMENT MG 010-20.6150.270000 59.68 MARK STUCHEL INC. 03031745759 03/03/2017 DIGITAL LCD CIRCUIT TESTER 010-20.6150.540000 123.49 MARK STUCHEL INC. 03101745994 03/10/2017 LAIR IMPACT I/21N PREMIU 010-20.6150.540000 482.94 NORTHERN TOOL &EQUIPM 0792072049 02/21/2017 TOOLS 010-20.6150.590000 37.46 SPRAYER SPECIALTIES INC 0983854-IN 03/O1/2017 BRAIDED VINYL TUBING 010-20.6150.570130 24.00 HAWKEYE TRUCK EQUIPMEN 125331 02/27/2017 SENSOR HARNESS 010-20.6150.570130 166.00 HAWKEYE TRUCK EQUIPMEN 125459 03/09/2017 SENSOR 010-20.6150.570130 424.00 HAWKEYE TRUCK EQUIPMEN 125621 03/21/2017 OVAL LED STROBE 010-20.6150.570130 65.00 MATHESON TRI-GAS INC 15086123 03/15/2017 FASTIP 010-20.6150.590000 40.28 MATHESON TRI-GAS INC 15110606 03/21/2017 CYLINDERS 010-20.6150.570130 61.60 INTERSTATE ALL BATTERY CE 1924601032341 03/01/2017 BATTERIES 010-20.6150.570130 74.40 INTERSTATE ALL BATTERY CE 1924601032341 03/01/2017 BATTERIES 010-20.6150.590000 106.50 INTERSTATE ALL BATTERY CE 1924601032485 03/10/2017 BATTERY 010-20.6150.570130 232.00 INTERSTATE ALL BATTERY CE 1924601032491 03/10/2017 RETURN BATTERY 010-20.6150.570130 -136.15 INTERSTATE ALL BATTERY CE 1924601032492 03/10/2017 BATTERY 010-20.6150.570130 133.55 ARNOLD MOTOR SUPPLY 21-709848 03/14/2017 PURPLE POWER 010-20.6150.570130 25.74 ARNOLD MOTOR SUPPLY 21-710099 03/17/2017 40# OIL DRI 010-20.6150.590000 47.70 METHODIST OCCUPATIONAL 221067 - 02/28/2017 PRE EMPLOYMENT SCREENS 010-20.6150.470000 87.00 TRUCK EQUIPMENT INC 280939 02/27/2017 BOTTOM RETAINER RING 010-20.6150.570130 4.04 TRUCK EQUIPMENT INC 280987 03/08/2017 GRIP STEP BOARDS/BRACKE 010-20.6150.570130 171.14 TRUCK EQUIPMENT INC 281052 03/10/2017 CONVERTERTAIL LIGHT 3-2 010-20.6150.570130 16.95 TRUCK EQUIPMENT INC 281151 03/20/2017 CORNER LED/ROCKER SWITC 010-20.6150.570130 353.91 OTTSEN OIL CO, INC 287560 03/03/2017 OIL 010-20.6150.570100 980.64 IOWA FIRE EQUIPMENT CO 293384 03/14/2017 2.5 SAABC 100 WITH V/B 010-20.6150.570130 191.75 ADELAUTO PARTS 353122 02/22/2017 HOSEEND 010-20.6150.570130 4.14 ADEL AUTO PARTS 353124 02/22/2017 HOSEEND 010-20.6150.570130 1.59 ADEL AUTO PARTS 353278 02/24/2017 AIR FILTERS 010-20,6150.570110 60.54 ADEL AUTO PARTS 353285 02/24/2017 OIL FILTER 010-20.6150.570110 21.38 ADEL AUTO PARTS 353314 02/24/2017 AIR FILTERS 010-20.6150.570110 -60.54 ADELAUTO PARTS 353611 03/02/2017 LOOM -SPLIT POLY 010-20.6150,570130 16.50 ADEL AUTO PARTS 353887 03/08/2017 WINDOW REGULATOR 010-20.6150.570130 92.62 3/29/2017 12:11:32 PM Page 7 of 17 Expense Approval Register Packet: APPKT00542 - APRIL 4TH 2O17 COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount ADEL AUTO PARTS 353923 03/08/2017 CUBE FUEL PUMP 010-20.6150.570130 96.95 ADEL AUTO PARTS 353937 03/08/2017 OIL FILTERS 010-20.6150.570110 32.47 ADEL AUTO PARTS 353989 03/09/2017 BATTERY CHARGER 010-20.6150.570130 131.97 ADEL AUTO PARTS 354050 03/10/2017 AIR &OIL FILTERS 010-20.6150.570110 26.09 ADEL AUTO PARTS 354051 03/10/2017 AIR FILTER 010-20.6150.570110 20.30 ADEL AUTO PARTS 354182 03/14/2017 DRB PAN 010-20.6150.590000 13.27 ADEL AUTO PARTS 354491 03/20/2017 OIL FILTER/RTU EXT LIFE GAL 010-20.6150.570110 4.79 ADEL AUTO PARTS 354491 03/20/2017 OIL FILTER/RTU EXT LIFE GAL 010-20.6150.570130 45.96 ADEL AUTO PARTS 354538 03/20/2017 OIL FILTER 010-20.6150.570110 29.92 ADEL AUTO PARTS 354583 03/21/2017 OIL FILTER 010-20.6150.570130 13.41 BAX SALES, INC 35541 02/23/2017 SHARPEN DRILL 010-20.6150.590000 5.56 BAX SALES, INC 35651 03/07/2017 CRIMPING TOOL 010-20.6150.590000 107.98 BAX SALES, INC 35658 03/07/2017 STORM INLET COVER/COUPL 010-20.6150.570130 88.12 BAX SALES, INC 35730 03/14/2017 CRIMPING TOOL/WIRE STRIP 010-20.6150.590000 136.73 BAX SALES, INC 35768 03/16/2017 WIRE STRIPPER 010-20.6150.570130 28.75 TOMPKINS INDUSTRIES 403472272 03/14/2017 PARTS 010-20.6150.570130 28.18 HOLMES MURPHY 403576 04/01/2017 APR'17 HMA MONTHLY CO 010-20,6150.100000 63.66 CERTIFIED POWER INC CO 40468345 02/21/2017 REPAIR ELECTSPREADER CO 010-20.6150.570130 142.79 CERTIFIED POWER INC CO 40468440 02/24/2017 SENSOR 010-20.6150.570130 224.94 CERTIFIED POWER INC CO 40468441 02/24/2017 REPAIR ELEC SPREADER CON 010-20.6150.570130 79.00 MID-IOWA SOLID WASTE EQ 43599 03/13/2017 FILTER ASSEMBLY 010-20.6150.570130 460.00 MID-IOWA SOLID WASTE EQ 43611 03/14/2017 FUEL FILTER/WATER SEPARA 010-20.6150.570130 489.02 MATHESON TRI-GAS INC 51147210 02/28/2017 CYLINDERS 010-20.6150.590000 88.20 VAN -WALL EQUIPMENT INC 518943 03/13/2017 SOLENOID 010-20.6150.570130 136.77 DELTA DENTAL 609039 04/01/2017 APR'17 DENTAL INSURANCE 010-20.6150.100000 149.93 MENARDS 73229 03/10/2017 12GAL5.5HP POLY VAC/FILT 010-20.6150.590000 126.39 CAPITAL CITY EQUIPMENT C 73577D 02/22/2017 LENS/LIGHT 010-20.6150.570130 -13.37 MENARDS 73604 03/14/2017 GARDEN HOSE/SLEDGE HAM 010-20.6150.570130 24.79 MENARDS 73698 03/15/2017 FLEXILLA CORD/DISTILLEDW 010-20.6150.570130 87.36 CAPITAL CITY EQUIPMENT C 74025D 03/09/2017 OIL FILTER 010-20.6150.570110 27.98 PRAXAIR DISTRIBUTION N44 76424392 02/28/2017 CYLINDER 010-20.6150.590000 67.43 STIVERS FORD 846530 03/08/2017 PIN 010-20.6150,570130 4.32 TERMINALSUPPLY CO. 88762-00 02/20/2017 SIGNAL BAR/ECCO HIDE -A -LE 010-20.6150.570130 496.15 NAPA AUTO PARTS STORE 920408 03/16/2017 ACCESSORY 010-20.6150.570130 4.56 LAW5ON PRODUCTS INC 9304746021 02/24/2017 CABLE TIES/CLAMPS/HEX NU 010-20.6150.570130 62.44 LAWSON PRODUCTS INC 9304746021 02/24/2017 CABLE TIES/CLAMPS/HEX NU 010-20.6150.590000 326.15 VERIZON WIRELESS 9782070622 03/13/2017 MARCH'17 STATEMENT 010-20.6150.450000 69.36 C2G CORPORATION CG4827 02/28/2017 RED THUNDER/SQUEEGEES/ 010-20.6150.590000 314.41 Department 6150 - PUBLIC WORKS MECHANIC Total: 8,151.58 Department: 6510 - WATER UTILITY STANLEY CONSULTANTS INC. 0194458 03/20/2017 WATER TOWER RENO - ANTE 510-30.6510.881200 234.00 TYLER TECHNOLOGIES INC 025-184167 04/01/2017 CONTENT/DOCUMENT MG 510-30.6510.270000 59.68 MUNICIPAL SUPPLY, INC. 0650294-IN 03/08/2017 METERS 510-30.6510.592000 53,155.80 MUNICIPAL SUPPLY, INC. 0650295-IN 03/08/2017 11/2" NIL FLIP X 11/2" BRZ 510-30.6510.592000 390.40 MUNICIPAL SUPPLY, INC. 0650704-IN 03/13/2017 OMNI COMP MTR 510-30.6510.592000 1,445.40 FULLER PETROLEUM SERVIC 104760 03/14/2017 FUEL 510-30.6510.570000 209.55 MID AMERICAN ENERGY 110090317 03/20/2017 MARCH'17 STATEMENT 510-30,6510.480000 13.29 METHODIST OCCUPATIONAL 221067 02/28/2017 PRE EMPLOYMENT SCREENS 510-30.6510A70000 43.50 HOLMES MURPHY 403576 04/01/2017 APR'17 HMA MONTHLY CO 510-30.6510.100000 22.73 HOLMES MURPHY 403576 04/01/2017 APR'17 HMA MONTHLY CO 510-30.6510.100000 63.66 HOLMES MURPHY 403576 04/O1/2017 APR'17 HMA MONTHLY CO 510-30.6510.100000 45.47 HOLMES MURPHY 403576 04/O1/2017 APR'17 HMA MONTHLY CO 510-30.6510.100000 15.92 PLUMB SUPPLY COMPANY 4419845 03/09/2017 SAW BLADE LENOX 510-30.6510.590000 11.80 HY-VEE 5833986921 02/17/2017 TRAINING MEETING FOOD 510-30.6510.470000 63.91 DELTA DENTAL 609039 04/01/2017 APR'17 DENTAL INSURANCE 510-30,6510.100000 63.03 DELTA DENTAL 609039 04/01/2017 APR'17 DENTAL INSURANCE 510-30.6510.100000 121.94 DELTA DENTAL 609039 04/01/2017 APR'17 DENTAL INSURANCE 510-30.6510.100000 37.48 DELTA DENTAL 609039 04/01/2017 APR'17 DENTAL INSURANCE 510-30.6510.100000 59.51 VERIZON WIRELESS 9782070622 03/13/2017 MARCH'17 STATEMENT 510-30.6510.450000 439.53 HD SUPPLY WATERWORKS G916291 03/16/2017 YELLOW GREEN DYE TABLET 510-30,6510.590000 60.87 3/29/2017 12:11:32 PM Page 8 of 17 Expense Approval Register Packet: APPKT00542 - APRIL 4TH 2O17 COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount DES MOINES AREA COMMU INV0002651 03/07/2017 30-HR WATER DIST. COURSE 510-30.6510.470000 1,350.00 VEENSTRA & KIMM INC INV0002652 02/27/2017 MOBILE HOME PARK FLOW 510-30.6510.230000 1,000.00 VEENSTRA & KIMM INC INV0002652 02/27/2017 WATER MODEL UPDATE 510-30.6510.230000 1,005.50 Department 6510 - WATER UTILITY Total: 59,912.97 Department: 6520 - SANITARY SEWERS & TREATMENT THE UPS STORE 00000007115 12/16/2016 - SHIPPING SERVICES 520-30.6520.590000 70.00 TYLER TECHNOLOGIES INC 025-184167 04/01/2017 CONTENT/DOCUMENT MG 520-30.6520.270000 59.68 ELECTRIC PUMP & TOOL INC 0872917-IN 03/03/2017 REPAIR PUMP 520-30.6520.411100 165.46 ELECTRIC PUMP &TOOL INC 0873020-IN 03/15/2017 FLUSH VALVE/MEMBRANE 520-30.6520.411100 1,750.77 FULLER PETROLEUM SERVIC 104760 03/14/2017 FUEL 520-30.6520.570000 209.55 SUBSURFACE SOLUTIONS LL 11380 03/20/2017 PROTOTEK FV-2-SNAKEABLE 520-30.6520.540000 640.00 METHODIST OCCUPATIONAL 221067 02/28/2017 PRE EMPLOYMENT SCREENS 520-30.6520.470000 43.50 WASTEWATER RECLAMATIO 23440 04/04/2017 APRIL'17 FEES 520-30.6520.882700 108,076.50 MID AMERICAN ENERGY 320010317 03/21/2017 MARCH'17 STATEMENT 520-30.6520.480000 95.42 HOLMES MURPHY 403576 04/O1/2017 APR'17 HMA MONTHLY CO 520-30.6520.100000 63.66 HOLMES MURPHY 403576 04/01/2017 APR'17 HMA MONTHLY CO 520-30.6520.100000 90.94 HOLMES MURPHY 403576 04/O1/2017 APR'17 HMA MONTHLY CO 520-30.6520.100000 22.73 HOLMES MURPHY 403576 04/01/2017 APR'17 HMA MONTHLY CO 520-30.6520.100000 15.92 PLUMB SUPPLY COMPANY 4427780 03/14/2017 ADAPTER/PRIMER 520-30.6520.590000 38.77 DELTA DENTAL 609039 04/01/2017 APR'17 DENTAL INSURANCE 520-30.6520.100000 126.06 DELTA DENTAL 609039 04/01/2017 APR'17 DENTAL INSURANCE 520-30.6520.100000 121.94 DELTA DENTAL 609039 04/01/2017 APR'17 DENTAL INSURANCE 520-30.6520.100000 59.51 DELTA DENTAL 609039 04/O1/2017 APR'17 DENTAL INSURANCE 520-30.6520.100000 37.48 MID AMERICAN ENERGY 640850317 03/21/2017 MARCH'17 STATEMENT 520-30.6520.480000 57.77 TRUCK EQUIPMENT INC 71065 03/20/2017 BUILD SHOVEL BASKET 520-30.6520.410000 1,100.00 VERIZON WIRELESS 9782070622 03/13/2017 MARCH'17 STATEMENT 520-30.6520.450000 274.60 FASTENAL COMPANY IAGRM86049 03/O1/2017 IGLOO 520-30.6520.590000 106.94 FASTENAL COMPANY IAGRM86141 03/08/2017 WRENCH/DRILLING HAMME 520-30.6520.590000 25.31 CENTURYLINK INV0002624 03/10/2017 MARCH'17 STATEMENT -LIF 520-30.6520.450000 48.09 VEENSTRA & KIMM INC INV0002652 02/27/2017 ORIG. SANITARY SEWER COL 520-30.6520.230000 428.90 VEENSTRA & KIMM INC INV0002652 02/27/2017 2016 BIOSOUDS ANNUAL RE 520-30.6520.230000 203.00 VEENSTRA & KIMM INC INV0002652 02/27/2017 2017 CONNECITON FEE MAP 520-30.6520.230000 1,008.89 VEENSTRA & KIMM INC INV0002652 02/27/2017 PAINTED WOODS WEST -SA 520-30.6520.230000 162.00 VEENSTRA & KIMM INC INV0002652 02/27/2017 SWAREATRUNK SEWER EXT 520-30.6520.883000 1,892.21 VEENSTRA & KIMM INC INV0002652 02/27/2017 SOUTH OUTFALL SEWER - DE 520-30.6520.883000 27,632.87 VEENSTRA & KIMM INC INV0002652 02/27/2017 LITTLE WALNUT CREEK REGI 520-30.6520.883060 6,371.11 VEENSTRA & KIMM INC INV0002652 02/27/2017 FOX CREEK SEWER PHS 3- D 520-30.6520.883080 5,297.92 VEENSTRA &KIMM INC INV0002652 02/27/2017 FOX CREEK SEWER PHASE 3- 520-30.6520.883080 520.00 VEENSTRA & KIMM INC INV0002652 02/27/2017 FOX CREEK SEWER PHASE 3- 520-30.6520.883080 1,505.10 VEENSTRA & KIMM INC INV0002652 02/27/2017 NW AREA TRUNKSEWER EX 520-30.6520.883091 1,020.00 VEENSTRA & KIMM INC INV0002652 02/27/2017 NW AREATRUNK SEWER EX 520-30.6520.883091 194.24 VEENSTRA & KIMM INC INV0002652 02/27/2017 2016 SPONSORED PROJECT 520-30.6520.883091 1,089.22 VEENSTRA & KIMM INC INV0002652 02/27/2017 NW AREA TRUNK SEWER EX 520-30.6520.883091 5,409.39 DAVIS EQUIPMENT CORPOR WI10379 03/03/2017 SWING JOINT 520-30.6520.883091 691.20 DAVIS EQUIPMENT CORPOR WI10387 03/07/2017 SWINGJOINT 520-30.6520.883091 108.39 Department 6520 -SANITARY SEWERS & TREATMENT Total: 166,83504 Department: 6540 - GAS UTILITY TYLER TECHNOLOGIES INC 025-184167 04/01/2017 CONTENT/DOCUMENT MG 540-30.6540.270000 59.68 REGAL UNDERGROUND CON 1038 03/15/2017 DIRECTIONAL BORE GAS SER 540-30.6540.880100 720.00 REGAL UNDERGROUND CON 1039 03/15/2017 DIRECTIONAL BORE GAS SER 540-30.6540.880100 540.00 REGAL UNDERGROUND CON 1040 03/15/2017 DIRECTIONAL BORE GAS SER 540-30.6540.880100 360.00 REGAL UNDERGROUND CON 1041 03/15/2017 DIRECTIONAL BORE GAS SER 540-30.6540.880100 540.00 FULLER PETROLEUM SERVIC 104760 03/14/2017 FUEL 540-30.6540.570000 209.56 MID AMERICAN ENERGY 110090317 03/20/2017 MARCH'17 STATEMENT 540-30.6540.480000 13.28 IOWA ASSOCIATION OF MU 14782 03/16/2017 EMERGENCY TRAINING -DEZ 540-30.6540.470000 762.00 US DEPT OF TRANSPORTATI 20178-030364 03/17/2017 FY'17 PIPELINE SAFETY USE 540-30.6540.280000 2,153.62 HOLMES MURPHY 403576 04/O1/2017 APR'17 HMA MONTHLY CO 540-30.6540.100000 22.73 HOLMES MURPHY 403576 04/01/2017 APR'17 HMA MONTHLY CO 540-30.6540.100000 15.92 HOLMES MURPHY 403576 04/01/2017 APR'17 HMA MONTHLY CO 540-30.6540.100000 181.88 PLUMB SUPPLY COMPANY 4403763 03/O1/2017 COUPLING/LABEL/PRIMER 540-30.6540.590000 25.16 3/29/2017 12:11:32 PM Page 9 of 17 Expense Approval Register Packet: APPKT00542 - APRIL 4TH 2O17 COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount PLUMB SUPPLY COMPANY 4403795 03/01/2017 DRILL 540-30.6540.590000 5.20 UNIVERSAL PRINTING SERVI 47640 03/13/2017 GASBROCHURE 540-30.6540.350100 150.83 UNIVERSAL PRINTING SERVI 47640 03/13/2017 GASBROCHURE 540-30.6540.360000 580.38 DELTA DENTAL 609039 04/01/2017 APR'17 DENTAL INSURANCE 540-30.6540.100000 476.08 DELTA DENTAL 609039 04/01/2017 APR'17 DENTAL INSURANCE 540-30.6540.100000 37.48 DELTA DENTAL 609039 04/01/2017 APR'17 DENTAL INSURANCE 540-30.6540.100000 59.51 RED WING SHOE STORE 72097 03/01/2017 BOOTS-DEZEEUW 540-30.6540.120000 212.49 VERIZON WIRELESS 9782070622 03/13/2017 MARCH'17 STATEMENT 540-30.6540.450000 259.51 UTILITY SAFETY AND DESIGN IN20170638 02/28/2017 ALICES RD GAS MAIN RELOC 540-30.6540.230000 1,474.30 CHUCK & LISA WASKE INV0002636 03/13/2017 FURNANCE & THERMOSTAT 540-30,6540.685400 105.00 JAMES OSTBY INV0002637 03/13/2017 FURNACE REBATE 540-30.6540.685400 150.00 MICHAELTORODE INV0002638 03/10/2017 FURNACE REBATE 540-30.6540,685400 75.00 DOUG HILGENBERG INV0002640 03/13/2017 FURNACE/AIR REBATE 540-30.6540.685400 150.00 ANN CLINTON INV0002647 03/13/2017 FURANCE & THERMOSTAT R 540-30.6540,685400 105.00 CHAD & LAUREN LITTLE INV0002648 04/04/2017 FURNACE REBATE 540-30.6540,685400 75.00 BRADFORD COX INV0002660 04/04/2017 THERMOSTAT REBATE 540-30.6540.685400 30.00 ROSE MARY ERUSHA INV0002661 04/04/2017 FURNACE REBATE 540-30.6540.685400 150.00 Department 6540 - GAS UTILITY Total: 9,699.61 Department: 6550 - UTILITY BILLING TYLER TECHNOLOGIES INC 025-184167 04/01/2017 CONTENT/DOCUMENT MG 570-30.6550.270000 59.67 TYLER TECHNOLOGIES INC 025-184671 04/01/2017 UTILITY ONLINE BILLING APR 570-30.6550.450200 175.00 ACCESS SYSTEMS LEASING 20348328 03/17/2017 MARCH'17 COPIER/PRINTER 570-30.6550.270110 111.87 METHODIST OCCUPATIONAL 221067 02/28/2017 PRE EMPLOYMENT SCREENS 570-30.6550.470000 576.00 HOLMES MURPHY 403576 04/01/2017 APR'17 HMA MONTHLY CO 570-30.6550.100000 63.66 DELTA DENTAL 609039 04/01/2017 APR'17 DENTAL INSURANCE 570-30.6550.100000 149.93 Department 6550 - UTILITY BILLING Total: 1,136.13 Department: 7100 - STREETS TYLER TECHNOLOGIES INC 025-184167 04/01/2017 CONTENT/DOCUMENT MG 060-30.7100.270000 59.68 CONSTRUCTION & AGGREGA 0292745-IN 03/09/2017 PARTS 060-30.7100.590000 160.00 FULLER PETROLEUM SERVIC 104760 03/14/2017 FUEL 060-30.7100.570000 209.55 SNYDER & ASSOCIATES INC 116.0645.01-5 02/28/2017 MISC. TRAFFIC ENGINEERIN 060-30.7100.230000 1,368.20 MARTIN MARIETTA AGGREG 19780877 02/28/2017 1" PIPE BEDDING 060-30.7100.590300 246.76 MARTIN MARIETTA AGGREG 19826958 03/09/2017 ROADSTONE 060-30.7100.590300 520.27 G&LCLOTHING 2-178667 03/23/2017 BOOTS-FLUGGESMITH 060-30.7100.120000 150.00 DALE EDWARDS TRUCKING 1 2924 03/22/2017 HAULING 060-30.7100.590300 286.96 IOWA PLAINS SIGNING INC 33958 03/10/2017 CHANNELIZER BASE 060-30.7100.590600 160.00 IOWASIGNALINC 3504 03/07/2017 REMOVED HPS/INSTALL LED 060-30.7100.410300 710.83 BAX SALES, INC 35658 03/07/2017 STORM INLET COVER/COUPL 060-30.7100.590000 189.92 BAX SALES, INC 35729 03/14/2017 WORK LIGHT 060-30.7100.590000 122.34 BAX SALES, INC 35767 03/16/2017 USS FLAT WASHER 060-30.7100.590000 34.62 IOWA DEPT OF TRANSPORTA 39520 03/07/2017 ROCK SALT 060-30.7100.591200 421.74 HOLMES MURPHY 403576 04/01/2017 APR'17 HMA MONTHLY CO 060-30.7100.100000 154.60 HOLMES MURPHY 403576 04/01/2017 APR'17 HMA MONTHLY CO 060-30.7100.100000 4.55 HOLMES MURPHY 403576 04/01/2017 APR'17 HMA MONTHLY CO 060-30.7100.100000 22.74 FOTH INFRASTRUCTURE & E 516585 03/20/2017 FLORENCE/ROSENKRANZTR 060-30.7100.230000 334.00 HY-VEE 5842481165 03/03/2017 COOKIES/FRUIT 060-30.7100.470000 40.37 DELTA DENTAL 609039 04/01/2017 APR'17 DENTAL INSURANCE 060-30,7100.100000 11,90 DELTA DENTAL 609039 04/01/2017 APR'17 DENTAL INSURANCE 060-30.7100.100000 387.97 DELTA DENTAL 609039 04/01/2017 APR'17 DENTAL INSURANCE 060-30.7100.100000 59.51 MENARDS 73604 03/14/2017 GARDEN HOSE/SLEDGE HAM 060-30.7100.590000 64.47 MENARDS 73675 03/15/2017 GENTRY POST MOUNT COM 060-30.7100.590000 54.99 MENARDS 73676 03/15/2017 GENTRY POST MOUNT COM 060-30.7100.590000 54.99 IOWA PRISON INDUSTRIES 943148 03/08/2017 SIGNS 060-30.7100.590600 1,603.40 VERIZON WIRELESS 9782070622 03/13/2017 MARCH'17 STATEMENT 060-30.7100.450000 231.36 AMERICAN PUBLIC WORKS A INV0002641 03/14/2017 2017 SNOW CONFERENCE-R 060-30,7100.470000 40.00 AMERICAN PUBLIC WORKS A INV0002642 03/14/2017 2017 SNOW CONFERENCE- 060-30.7100.470000 520.00 AMERICAN PUBLIC WORKS A INV0002643 03/14/2017 2017 SNOW CONFERENCE- 060-30.7100.470000 40.00 AMERICAN PUBLIC WORKS A INV0002644 03/14/2017 2017 SNOW CONFERENCE-S 060-30.7100.470000 40.00 AMERICAN PUBLIC WORKS A INV0002645 03/14/2017 2017 SNOW CONFERENCE-F 060-30.7100.470000 40.00 AMERICAN PUBLIC WORKS A INV0002646 03/14/2017 2017 SNOW CONFERENCE -A 060-30.7100.470000 40.00 3/29/2017 12:11:32 PM Page 10 of 17 Expense Approval Register Packet: APPKTOOS42 - APRIL 4TH 2O17 COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount VEENSTRA & KIMM INC INV0002652 02/27/2017 2016 MAITENANCE BOND ST 060-30.7100.230000 600.00 VEENSTRA & KIMM INC INV0002652 02/27/2017 2017 ASPHALT OVERLAY PR 060-30.7100.230000 1,129.70 LOGAN CONTRACTORS SUPP L86473 03/07/2017 MAG BULL FLT/TILT BRKT/W 060-30,7100.590000 315.55 LOGAN CONTRACTORS SUPP R62392 03/03/2017 POWER SAW RENTAL 060-30.7100.390000 48.84 Department 7100 - STREETS Total: 10,479.81 Department: 7730 - SE W ESTOW N PKWY CONSTRUCTION FOTH INFRASTRUCTURE & E 51640 03/15/2017 WESTOWN PKWY/SE PARKVI 327-90.7730.230000 9,069.18 Department 7730 - SE W ESTOWN PKWY CONSTRUCTION Total: 9,069.18 Department: 8200 - COMMUNICATIONS TYLER TECHNOLOGIES INC 025-184167 04/O1/2017 CONTENT/DOCUMENTMG 010-60.8200.270000 59.68 MYTOWN MAGAZINES 1397 03/19/2017 MARCH/APRIL MY WAUKEE 010-60.8200.210000 1,200.00 HOLMES MURPHY 403576 04/O1/2017 APR'17 HMA MONTHLY CO 010-60.8200.100000 45.47 BUSINESS PUBLICATIONS 46518 03/10/2017 BUSINESS RECORD PRINT AD 010-60.8200.210000 1,817.00 DELTA DENTAL 609039 04/01/2017 APR'17 DENTAL INSURANCE 010-60.8200.100000 119.02 Department 8200 - COMMUNICATIONS Total: 3,241.17 Department: 8300 -ADMINISTRATION TYLER TECHNOLOGIES INC 025-184167 04/O1/2017 CONTENT/DOCUMENT MG 010-60,8300.270000 59.68 ACCESS SYSTEMS LEASING 20348328 03/17/2017 MARCH'17 COPIER/PRINTER 010-60.8300.270110 111.86 HOLMES MURPHY 403576 04/O1/2017 APR'17 HMA MONTHLY CO 010-60.8300.100000 90.94 SESAC, INC 4387993_CNV 03/17/2017 LATE FEE 010-60.8300.280000 5.96 MID AMERICAN ENERGY 480550317 03/21/2017 28178 U AVE (FRAM HOUSE 010-60.8300.390400 16.03 MID AMERICAN ENERGY 490530317 03/21/2017 MARCH'17 STATEMENT 010-60.8300.390400 10.74 DELTA DENTAL 609039 04/01/2017 APR'17 DENTAL INSURANCE 010-60.8300.100000 182.05 OFFICE DEPOT 911918063001 03/09/2017 FOLDERS/HIGHLIGHTERS/PE O10-60.8300.580000 3.29 VERIZON WIRELESS 9782070622 03/13/2017 MARCH'17 STATEMENT O10-60.8300.450000 52.00 CONSOLIDATED COMMUNIC INV0002627 03/01/2017 MARCH'17 STATEMENT 010-60.8300.450000 851.72 MEDIACOM INV0002628 03/05/2017 MARCH'17 STATEMENT 010-60.8300.270000 13.29 DES MOINES REGISTER INV0002668 04/04/2017 MON.- SAT. SUBSCRIPTION 010-60.8300.280000 25.00 Department 8300 - ADMINISTRATION Total: 1,422.56 Department: 8310 - CITY HALL MID AMERICAN ENERGY 030890317 03/21/2017 MARCH'17 STATEMENT 010-60.8310.390600 136.25 THE WALDINGER CORP 110800-19 03/20/2017 HVAC PREVENTATIVE MAITE 010-60.8310.400000 630.50 G&KSERVICES INC 1183683665 03/22/2017 MAT SERVICES - CITY HALL 010-60.8310.400000 36.00 ACCESS SYSTEMS LEASING 20348328 03/17/2017 MARCH'17 COPIER/PRINTER 010-60.8310.270110 223.73 NATIONWIDE OFFICE CLEAN 59910 03/15/2017 CLEANING SERVICES -CITYH 010-60.8310.400100 597.54 CRYSTAL CLEAR BOTTLED W 890707 03/21/2017 WATER 010-60.8310.590000 22.50 Department 8330 - CITY HALL Total: 1,646.52 Department: 8350 - HUMAN RESOURCES FAREWAY STORES, INC. 00330644 03/28/2017 CANDY 010-60.8350.689100 11.17 TYLER TECHNOLOGIES INC 025-184167 04/O1/2017 CONTENT/DOCUMENTMG 010-60,8350.270000 59.68 ACCESS SYSTEMS LEASING 20348328 03/17/2017 MARCH'17 COPIER/PRINTER 010-60.8350.270110 111.86 HOLMES MURPHY 403576 04/01/2017 APR'17 HMA MONTHLY CO 010-60.8350.100000 18.19 DELTA DENTAL 609039 04/01/2017 APR'17 DENTAL INSURANCE 010-60.8350.100000 30.91 ADECCO EMPLOYMENT SER 68459034 03/06/2017 CONTRACT LABOR - SELLERS 010-60.8350.230000 58.55 VERIZON WIRELESS 9782070622 03/13/2017 MARCH'17 STATEMENT 010-60.8350.450000 52.00 Department 8350 - HUMAN RESOURCES Total: 342.36 Department: 8400 - FINANCIAL ADMINISTRATION TYLER TECHNOLOGIES INC 025-184167 04/O1/2017 CONTENT/DOCUMENT MG 010-60.8400.270000 59.68 ACCESS SYSTEMS LEASING 20348328 03/17/2017 MARCH'17 COPIER/PRINTER 010-60.8400.270110 456.98 TRIPLETT OFFICE ESSENTIAL 296415-0 03/24/2017 HON 103E CODED KEY 010-60.8400.580000 12.50 HOLMES MURPHY 403576 04/01/2017 APR'17 HMA MONTHLY CO 010-60.8400.100000 109.13 DELTA DENTAL 609039 04/01/2017 APR'17 DENTAL INSURANCE 010-60.8400,100000 212.96 OFFICE DEPOT 911918063001 03/09/2017 FOLDERS/HIGHLIGHTERS/PE 010-60.8400.580000 75.60 VERIZON WIRELESS 9782070622 03/13/2017 MARCH'17 STATEMENT 010-60.8400.450000 92.01 Department 8400 - FINANCIAL ADMINISTRATION Total: 1,018.86 Department: 8500 - COMMUNITY DEVELOPMENT TYLER TECHNOLOGIES INC 025-184167 04/01/2017 CONTENT/DOCUMENT MG 010-50.8500.270000 59.68 ACCESS SYSTEMS LEASING 20348328 03/17/2017 MARCH'17 COPIER/PRINTER 010-50.8500.270110 132.37 3/29/2017 12: 11:32 PM Page 11 of 17 Expense Approval Register Packet: APPKT00542 - APRIL 4TH 2O17 COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount HOLMES MURPHY 403576 04/O1/2017 APR'17 HMA MONTHLY CO 010-50.8500.100000 90.94 FOTH INFRASTRUCTURE & E 516585 03/20/2017 MAPLE GROVE PLACE, LLC SI 010-50.8500.230000 948.00 DELTA DENTAL 609039 04/01/2017 APR'17 DENTAL INSURANCE 010-50.8500.100000 133.85 VERIZON WIRELESS 9782070622 03/13/2017 MARCH'17 STATEMENT 010-50.8500.450000 52.00 Department 8500 - COMMUNITY DEVELOPMENT Total: 1,416.84 Department: 8700 - DEVELOPMENT SERVICES TYLER TECHNOLOGIES INC 025-184167 04/01/2017 CONTENT/DOCUMENT MG 010-50.8700.270000 59.68 ACCESS SYSTEMS LEASING 20348328 03/17/2017 MARCH'17 COPIER/PRINTER 010-50.8700.270110 186.35 HOLMES MURPHY 403576 04/O1/2017 APR'17 HMA MONTHLY CO 010-50.8700.100000 109.13 DELTA DENTAL 609039 04/O1/2017 APR'17 DENTAL INSURANCE 010-50.8700.100000 268.95 VERIZON WIRELESS 9782070622 03/13/2017 MARCH'17 STATEMENT 010-50.8700.450000 104.00 Department 8700 - DEVELOPMENT SERVICES Total: 728.11 Department: 8750 - SUGAR CREEK MUNICIPAL TYLER TECHNOLOGIES INC 025-184167 04/O1/2017 CONTENT/DOCUMENT MG 750-80.8750.270000 59.67 ZIMCO SUPPLY CO 105470 03/07/2017 CHEMICALS 750-80.8750.590100 1,159.00 ZIMCO SUPPLY CO 105500 03/07/2017 ROPE/SOIL/HOLE CUTTER 750-80.8750.590000 369.00 DALE EDWARDS TRUCKING 1 2923 03/22/2017 HAULING 750-80.8750.590200 315.43 HOLMES MURPHY 40357G 04/01/2017 APR'17 HMA MONTHLY CO 750-80.8750.100000 31.83 PLUMB SUPPLY COMPANY 4426222 03/13/2017 PVC PIPE/COUPLING 750-80.8750.410350 16.40 DELTA DENTAL 609039 04/01/2017 APR'17 DENTAL INSURANCE 750-80.8750.100000 83.31 LAWSON PRODUCTS INC 9304788442 03/14/2017 HAND CLEANER/GLOVES 750-80.8750.590000 111.23 VERIZON WIRELESS 978207OG22 03/13/2017 MARCH'17 STATEMENT 750-80.8750.450000 40.01 CENTURYLINK INV0002625 03/10/2017 MARCH'17 STATEMENT 750-80.8750.450000 333.57 LA CROSSE SEED SINP-17-04341 03/07/2017 EC PROSPORTS 50# 750-80.8750.590150 3,300.00 DAVIS EQUIPMENT CORPOR WI10403 03/09/2017 SPRINKLER WIRE REPAIR 750-80.8750.410350 705.16 Department 8750 - SUGAR CREEK MUNICIPAL Total: 6,524.61 Department: 8900 - ENGINEERING TYLER TECHNOLOGIES INC 025-184167 04/O1/2017 CONTENT/DOCUMENT MG 010-20.8900.270000 59.68 ACCESS SYSTEMS LEASING 20348328 03/17/2017 MARCH'17 COPIER/PRINTER 010-20.8900.270110 269.52 METHODIST OCCUPATIONAL 221067 02/28/2017 PRE EMPLOYMENT SCREENS 010-20.8900.470000 87.00 HOLMES MURPHY 403576 04/O1/2017 APR'17 HMA MONTHLY CO 010-20.8900.100000 127.32 DELTA DENTAL 609039 04/O1/2017 APR'17 DENTAL INSURANCE 010-20.8900.100000 299.86 VERIZON WIRELESS 9782070622 03/13/2017 MARCH'17 STATEMENT 010-20.8900.450000 335.02 IOWA DEPT OF TRANSPORTA INV0002633 01/12/2017 SOILS TECH. RECERT. -HANS 010-20.8900.470000 75.00 VEENSTRA & KIMM INC INV0002652 02/27/2017 CITY OF WAUKEE ALLEY VAC 010-20.8900.230000 800.00 VEENSTRA & KIMM INC INV0002652 02/27/2017 DEVELOPER FEES 010-20.8900.231200 3,879.79 Department 8900 - ENGINEERING Total: 5,933.19 Department: 8950 - GIS TYLER TECHNOLOGIES INC 025-184167 04/O1/2017 CONTENT/DOCUMENT MG 010-20.8950.270000 59.68 IOWA TRANSIT 31047 03/23/2017 REPAIR GPS 010-20.8950.410100 1,594.58 HOLMES MURPHY 403576 04/O1/2017 APR'17 HMA MONTHLY CO 010-20.8950.100000 18.19 DELTA DENTAL 609039 04/O1/2017 APR'17 DENTAL INSURANCE 010-20.8950.100000 30.91 VERIZON WIRELESS 9782070622 03/13/2017 MARCH'17 STATEMENT 010-20.8950.450000 77.02 Department 8950 - GIS Total: 1,780.38 Grand Total: 1,128,365.47 3/29/2017 12:11:32 PM Page 12 of 17 Expense Approval Register Packet: APPKT00542 - APRIL 4TH 2O17 COUNCIL PACKET Fund Summary Fund 010-GENERAL FUND 060-ROAD USE TAX FUND 327 - CAPITAL PROJECTS 510- WATER UTILITY FUND 520- WASTE WATER UTILITY FUND 540 - GAS UTILITY FUND 560 - STORM WATER UTILITY FUND 570 - UTILITY BILL FUND 590 - SOLID WASTE COLLECT & RCY 750-GOLF COURSE FUND Account Number 010-10.1100.100000 010-10.1100.120000 010-10.1100,230000 010-10.1100.270000 010-10.1100.270100 010-10.1100.270110 010-10.1100.400000 010-10.1100.400100 010-10.1100.410000 010-10,1100.450000 010-10.1100.460200 010-10.1100.470000 010-10.1100.480000 010-10.1100.540000 010-10.1100.570000 010-10.1100.580000 010-10.1100.590000 010-10.1400,100000 010-10.1400.270000 010-10.1400.270110 010-10.1400.400000 010-10.1400.410000 010-10.1400.410100 010-10.1400.450000 010-10.1400.470000 010-10.1400.480000 010-10.1400.590000 010-10.1500.100000 010-10.1500.270000 010-10.1500.400000 010-10.1500.450000 010-10.1500.480000 010-10.1500.590050 010-10.1900.100000 010-10.1900.270000 010-10.1900.270110 010-10.1900.450000 010-10.1900.470000 010-20.6000.100000 010-20,6000.270000 010-20.6000.280000 010-20.6000.450000 010-20.6000.470000 010-20.6010.270110 010-20.6010.400000 Grand Total: Account Summary Account Name HEALTH & LIFE INSURAN UNIFORMS CONSULTANT & PROFES DATA PROCESSING COMPUTER SUPPORT COPIER / PRINTER LEASE REPAIR/MAINTENANCE CUSTODIAL REPAIR OF VEHICLES TELEPHONE PD COMMUNITY POLICI TRAINING/TRAVEL EXPE UTILITY SERVICES MINOR EQUIPMENT FUEL OFFICE SUPPLIES OPERATING SUPPLIES & HEALTH & LIFE INSURAN DATA PROCESSING COPIER/ PRINTER LEASE REPAIR/MAINTENANCE REPAIR OF VEHICLES REPAIR/MAINTENANCE TELEPHONE TRAINING/TRAVEL EXPE UTILITY SERVICES OPERATING SUPPLIES & HEALTH & LIFE INSURAN DATA PROCESSING REPAIR/MAINTENANCE TELEPHONE UTILITY SERVICES MEDICAL SUPPLIES HEALTH & LIFE INSURAN DATA PROCESSING COPIER/ PRINTER LEASE TELEPHONE TRAINING/TRAVEL EXPE HEALTH & LIFE INSURAN DATA PROCESSING DUES, MEMBERSHIPS & TELEPHONE TRAINING/TRAVEL EXPE COPIER/ PRINTER LEASE REPAIR/MAINTENANCE Expense Amount 80,985.59 202,287.43 115,048.32 59,912.97 166,835.04 9,699.61 150,005.10 1,136.13 335,930.67 6,524.61 1,128,365.47 Expense Amount 2,794.27 929.55 963.01 59.68 62.50 31141.62 453.89 554.24 35.00 1,271.73 288.75 348.00 654.81 418.61 2,522.50 70.81 41.97 600.27 59.68 111.87 2,264.69 100.00 1,949.57 172.45 77.00 434.00 412.03 600.26 59.68 2,264.70 172.45 434.00 348.86 427.18 59.68 111.87 276.03 87.00 601.97 59.68 190.00 209.92 20.00 559.33 5,731.09 3/29/2017 12:11:32 PIA Page 13 of 17 Expense Approval Register Packet: APPK700542 - APRIL 4TH 2O17 COUNCIL PACKET Account Number 010-20.6010.400100 010-20.6010.410100 010-20.6010.450000 010-20,6010.480000 010-20.6010.580000 010-20.6010.590000 010-20.6150.100000 010-20.6150,270000 010-20.6150.450000 010-20.6150.470000 010-20.6150.540000 010-20.6150.570100 010-20.6150.570110 010-20.6150.570130 010-20.6150.590000 010-20.8900.100000 010-20.8900.230000 010-20.8900.231200 010-20.8900,270000 010-20.8900.270110 010-20.8900.450000 010-20.8900.470000 010-20.8950.100000 010-20.8950.270000 010-20.8950.410100 010-20.8950.450000 010-40.3100.100000 010-40.3100.270000 010-40.3100.270110 010-40.3100.400100 010-40,3100.450000 010-40.3100.460300 010-40.3100.460400 010-40.3100.480000 010-40.3100.580000 010-40.3100.590000 010-40.3100.640000 010-40.4100.100000 010-40.4100.270000 010-40.4100.410100 010-40.4100.410300 010-40.4100.450000 010-40.4100.470000 010-40.4100.480000 010-40.4100.570000 010-40.4100,590000 010-40.4200.100000 010-40.4200.270000 010-40.4200.270110 010-40.4200.450000 010-40.4200.460050 010-40.4200.460510 010-40.4200.460550 010-40.4200.461600 010-40.4200,580000 010-40.4300.400100 010-40.4300.4531000 010-40.4300.480000 Account Summary Account Name CUSTODIAL SERVICES REPAIR/MAINTENANCE TELEPHONE UTILITY SERVICES OFFICE SUPPLIES OPERATING SUPPLIES & HEALTH & LIFE INSURAN DATA PROCESSING TELEPHONE TRAINING/TRAVEL EXPE MINOR EQUIPMENT COGS - OIL COGS - FILTERS COGS - PARTS OPERATING SUPPLIES & HEALTH & LIFE INSURAN CONSULTANT& PROFES DEVELOPERS ENGINEERI DATA PROCESSING COPIER/ PRINTER LEASE TELEPHONE TRAINING/TRAVEL EXPE HEALTH & LIFE INSURAN DATA PROCESSING REPAIR/MAINTENANCE TELEPHONE HEALTH & LIFE INSURAN DATA PROCESSING COPIER/ PRINTER LEASE CUSTODIAL SERVICES TELEPHONE PROGRAMS SUMMER READING CLU UTILITY SERVICES OFFICE SUPPLIES OPERATING SUPPLIES & LIBRARY BOOKS/FILMS/ HEALTH & LIFE INSURAN DATA PROCESSING REPAIR/MAINTENANCE REPAIR/MAINTENANCE TELEPHONE TRAINING/TRAVEL EXPE UTILITY SERVICES FUEL OPERATING SUPPLIES & HEALTH & LIFE INSURAN DATA PROCESSING. COPIER/ PRINTER LEASE TELEPHONE OFFICIALS YOUTH SPORTS LEAGUE WINTER RECREATION PR EASTER EGG HUNT OFFICE SUPPLIES CUSTODIAL SERVICES COMMUNITY CENTER R UTILITY SERVICES Expense Amount 1,247.04 14.98 58.13 1,427.27 686.56 163.43 213.59 59.68 69.36 87.00 606.43 980.64 176.34 4,540.48 1,418,06 427.18 800.00 3,879.79 59.68 269.52 335.02 162.00 49.10 59.68 1,594.58 77.02 703.58 59.68 223.73 610.00 52.00 56.03 994.17 2,586.37 185.15 1,173.10 3,385.15 246.48 59.68 160.90 249.47 97.93 87.00 55.93 209.55 1,303.84 378.08 59.68 111.86 198.94 2,200.00 765.00 1,440.00 480.00 14.28 298.77 155.00 84.20 3/29/2017 12:11:32 PM Page 14 of 17 Expense Approval Register Packet: APPKT00542 - APRIL 4TH 2O17 COUNCIL PACKET Account Summary Account Number Account Name Expense Amount 010-40.4300.590000 OPERATING SUPPLIES & 14.86 010-50.8500.100000 HEALTH & LIFE INSURAN 224.79 010-50.8500.230000 CONSULTANT & PROFES 948.00 010-50.8500.270000 DATA PROCESSING 59.68 010-50.8500.270110 COPIER/ PRINTER LEASE 132.37 010-50.8500.450000 TELEPHONE 52.00 010-50.8700.100000 HEALTH & LIFE INSURAN 378.08 010-50.8700.270000 DATA PROCESSING 59.68 010-50.8700.270110 COPIER/PRINTER LEASE 186.35 010-50.8700.450000 TELEPHONE 104.00 010-60.8200.100000 HEALTH & LIFE INSURAN 164.49 010-60.8200.210000 PUBLIC NOTIFICATION/A 3,017.00 010-60.8200.270000 DATA PROCESSING 59.68 010-60.8300.100000 HEALTH & LIFE INSURAN 272.99 010-60.8300.270000 DATA PROCESSING 72.97 010-60,8300.270110 COPIER/ PRINTER LEASE 111.86 010-60.8300.280000 DUES, MEMBERSHIPS & 30.96 010-60.8300.390400 NORTHVIEW RENTAL PR 26.77 010-60.8300.450000 TELEPHONE 903.72 010-60.8300.580000 OFFICE SUPPLIES 3.29 010-60.8310.270110 COPIER/ PRINTER LEASE 223.73 010-60.8310.390600 PROF PLAZA CAM EXPEN 136.25 010-60.8310.400000 REPAIR/MAINTENANCE 666.50 010-60.8310.400100 CUSTODIAL SERVICES 597.54 010-60.8310.590000 OPERATING SUPPLIES & 22.50 010-60.8350.100000 HEALTH & LIFE INSURAN 49.10 010-60.8350.230000 CONSULTANT &PROFES 58.55 010-60.8350.270000 DATA PROCESSING 59.68 010-60.8350.270110 COPIER/ PRINTER LEASE 111.86 010-60.8350.450000 TELEPHONE 52.00 010-50.8350.689100 SAFETY PROGRAM/INCE 11.17 010-60.8400.100000 HEALTH & LIFE INSURAN 322.09 010-60.8400.270000 DATA PROCESSING 59.68 010-60.8400.270110 COPIER/PRINTER LEASE 456.98 010-60.8400.450000 TELEPHONE 92.01 010-60.8400.580000 OFFICE SUPPLIES 88.10 060-30.1600.410300 REPAIR/MAINTENANCE 20,500.00 060-30.1600.480000 UTILITY SERVICES 2,023.50 060-30.1600.760000 OTHER CAPITAL EQUIPM 169,048.87 060-30.1601.480000 UTILITY SERVICES 235.25 060-30.7100.100000 HEALTH & LIFE INSURAN 641.27 060-30.7100.120000 UNIFORMS 150.00 060-30.7100.230000 CONSULTANT & PROFES 3,431.90 060-30.7100.270000 DATA PROCESSING 59.68 060-30.7100.390000 RENTAL/LEASE OF EQUI 48.84 060-30.7100.410300 REPAIR/MAINTENANCE 710.83 060-30.7100.450000 TELEPHONE 231.36 060-30.7100.470000 TRAINING/TRAVEL EXPE 760.37 060-30.7100.570000 FUEL 209.55 060-30.7100.590000 OPERATING SUPPLIES & 996.88 060-30,7100.590300 ROADSTONE 1,053.99 060-30.7100.590600 STREETSIGNS 1,763.40 060-30.7100.591200 ROAD SALT 421.74 327-90.2130.230040 CONSULTING -UNIV TO 855.00 327-90.2130.230051 CONSULTING - ESKER RD 81282.50 327-90.2130.840470 ALICES RD-ENHANCE AS 150.00 327-90.2130,840491 ALICES ROAD - OLSONT 55,526.24 327-90.2131.230051 CONSULTING -ESKER RID 790.00 3/29/2017 12:11:32 PIA Page 15 of 17 Expense Approval Register Packet: APPKT00542 - APRIL 4TH 2O17 COUNCIL PACKET Account Summary Account Number Account Name Expense Amount 327-90.2132.230000 CONSULTING -GPP INTE 1,106.00 327-90.2133.230000 CONSULTING - 10TH STR 32,358.00 327-90.5000.881130 RRVTTRAILHEADART I 6,911.40 327-90.7730.230000 CONSULTANT &PROFES 9,069.18 510-30.6510.100000 HEALTH & LIFE INSURAN 429.74 510-30.6510.230000 CONSULTANT & PROFES 2,005.50 510-30.6510.270000 DATA PROCESSING 59.68 510-30.6510.450000 TELEPHONE 439.53 510-30.6510.470000 TRAINING/TRAVEL EXPE 1,457.41 510-30.6510.480000 UTILITY SERVICES 13.29 510-30.6510.570000 FUEL 209.55 510-30.6510.590000 OPERATING SUPPLIES& 72.67 510-30.6510.592000 METER PURCHASE 54,991.60 510-30.6510.881200 WATER TOWER REHAB 234.00 520-30.6520.100000 HEALTH & LIFE INSURAN 538.24 520-30.6520.230000 CONSULTANT&PROFES 1,802.79 520-30,6520.270000 DATA PROCESSING 59.68 520-30.6520.410000 REPAIR OF VEHICLES 1,100.00 520-30.6520.411100 REPAIR/MAINTENANCE 1,916.23 520-30.6520.450000 TELEPHONE 322.69 520-30.6520.470000 TRAINING/TRAVEL EXPE 43.50 520-30.6520.480000 UTILITY SERVICES 153.19 520-30.6520.540000 MINOR EQUIPMENT 640.00 520-30.6520.570000 FUEL 209.55 520-30.652&590000 OPERATING SUPPLIES & 241.02 520-30.6520.882700 WRA FEES 108,076.50 520-30.6520.883000 OUTFALL CONNECTION 29,525.08 520-30.6520.883060 LITTLE WALNUT CREEK S 6,371.11 520-30.6520.883080 FOX CREEK SEWER 7,323.02 520-30.6520.883091 NW AREA TRUNK SEWE 8,512.44 540-30.6540.100000 HEALTH & LIFE INSURAN 793.60 540-30.6540.120000 UNIFORMS 212.49 540-30.6540.230000 CONSULTANT & PROFES 1,474.30 540-30.6540.270000 DATA PROCESSING 59.68 540-30.6540.280000 DUES, MEMBERSHIPS& 2,153.62 540-30.6540.350100 PRINTING 150.83 540-30.6540.360000 POSTAGE & SHIPPING 580.38 540-30.6540.450000 TELEPHONE 259.51 540-30.6540.470000 TRAINING/TRAVEL EXPE 762.00 540-30.6540.480000 UTILITY SERVICES 13.28 540-30.6540.570000 FUEL 209.56 540-30.6540.590000 OPERATING SUPPLIES & 30.36 540-30.6540.685400 GAS REBATE 840.00 540-30.6540.880100 DISTRIBUTION SYSTEM I 2,160.00 560-80.5300.100000 HEALTH & LIFE INSURAN 326.39 560-80.5300.230000 CONSULTANT & PROFES 537.00 560-80.5300.270000 DATA PROCESSING 59.68 560-80.5300.450000 TELEPHONE 204.03 560-80.5300.760000 OTHER CAPITAL EQUIPM 147,735.00 560-80.5300.880015 CENTENNIAL PARK STRE 1,143.00 570-30.6550.100000 HEALTH & LIFE INSURAN 213.59 570-30.6550.270000 DATA PROCESSING 59.67 570-30.6550.270110 COPIER / PRINTER LEASE 111.87 570-30.6550.450200 CREDIT CARD FEES 175.00 570-30.6550.470000 TRAINING/TRAVEL EXPE 576.00 590-30.5400.231300 RESIDENTIAL SOLID WAS 335,871.00 590-30.5400.270000 DATA PROCESSING 59.67 750-80.8750.100000 HEALTH & LIFE INSURAN 115.14 3/29/2017 12:11:32 PM Page 16of 17 Expense Approval Register Packet: APPKT00542 - APRIL 4TH 2O17 COUNCIL PACKET Account Summary Account Number Account Name Expense Amount 750-80.8750.270000 DATA PROCESSING 59.67 750-80.8750.410350 REPAIR/MAINTENANCE 1 721.56 750-80.8750.450000 TELEPHONE 373.58 750-80.8750.590000 OPERATING SUPPLIES & 480.23 750-80.8750.590100 CHEMICAL/FERTILIZER 1,159.00 750-80.8750.590150 GRASS SEED 3,300.00 750-80.8750.590200 SAND AND MILLINGS 315.43 Grand Total: 1,128,365.47 Project Account Summary Project Account Key Expense Amount **None** 1,128,365.47 Grand Total: 1,128,365.47 3/29/2017 12:11:32 PM Page 17 of 17 I 0 1 City of Waukee, IA Vendor Number Vendor Name Payment Date Payment Type Bank Code: AP-WAUKEE STATE 094950 IOWA COMMUNITIES ASSURANCE POOL 03/20/2017 Regular Payable # Payable Type Payable Date Payable Description Account Number Account Name Item Description 28503 Invoice 03/20/2017 GOLF LIQUOR LIABILITY 750-80,8750.290000 GENERAL LIABILITY INSUR GOLF LIQUOR LIABILITY My Check Report By Check Number Date Range: 03/16/2017 - 03/20/2017 DiscountAmount PaymentAmount Number 0.00 917.00 128120 DiscountAmount Payable Amount Distribution Amount 0.00 917.00 917.00 095485 IOWA DEPT OF INSPECTIONS & APPEALS 03/20/2017 Regular 0.00 114.50 128121 Payable It Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0002616 Invoice 03/17/2017 FOOD SERVICE LICENSE - GOLF COURSE 0.00 114.50 750-80,8750.280000 DUES, MEMBERSHIPS&S FOOD SERVICE LICENSE - GOLF 114.50 Bank Code AP Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 2 2 0.00 1,031.50 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 1,031.50 3/29/2017 12:29:13 PM Page 1 of 2 My Check Report W Date Range: 03/16/2017 - 03/20/2017 Fund Summary Fund Name Period Amount 999 POOLED CASH 3/2017 1,031.50 1,031.50 3/29/2017 12:29: 13 PM Page 2 of 2 OPCity of Waukee, IA Waukee Vendor Number Vendor Name Payment Date Payment Type Bank Code: AP-WAUKEE STATE 019200 AUDITOR OF STATE 03/24/2017 Regular Payable # Payable Type Payable Date Payable Description Account Number Account Name Item Description INV0002653 Invoice 03/24/2017 FILING FEE 010-60.8400.230100 AUDIT FILING FEE 135778 MIDAMERICAN ENERGY COMPANY 03/28/2017 Regular Payable # Payable Type Payable Date Payable Description Account Number Account Name Item Description INV0002664 Invoice 03/28/2017 APPLICATION FEE 327-90.5000.891130 RRVTTRAILHEADART IM APPLICATION FEE Bank Code AP Summary Payable Payment Payment Type Count Count Discount Regular Checks 2 2 0.00 Manual Checks 0 0 0.00 Voided Checks 0 0 0.00 Bank Drafts 0 0 0.00 EFT's 0 0 0.00 2 2 0.00 i�) My Check Report By Check Number Date Range: 03/22/2017 - 03/29/2017 DiscountAmount PaymentAmount Number 0.00 850.00 128244 Discount Amount Payable Amount Distribution Amount 0.00 850.00 850.00 0.00 50.00 128245 Discount Amount Payable Amount Distribution Amount 0.00 50.00 50.00 Payment 900.00 0.00 0.00 0.00 0.00 900.00 3/29/2017 12:38:47 PM Page 1 of 2 My Check Report 3 Date Range: 03/22/2017 - 03/29/2017 Fund Summary Fund Name Period Amount 999 POOLED CASH 3/2017 900.00 900.00 3/29/2017 12:38:47 PM Page 2 of 2 C/ Council Payroll Reimbursements c 4110 WQUkee City of Waukee, IA Vendor Number Vendor Name Bank Code: AP-WAUKEE STATE By Check Number Date Range: 03/15/2017 - 03/29/2017 Payment Date Payment Type DiscountAmount PaymentAmount Number 034875 CITYOFWAUKEE 03/16/2017 Regular 0.00 4,654.18 128112 Payable # Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0002598 Invoice 03/15/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.29 520-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 26.25 540-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 26.26 560-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 1.82 INV0002603 Invoice 03/15/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.88 520-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 28.86 540-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 42.83 560-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 27.82 570-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 34.75 INV0002604 Invoice 03/15/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.67 510-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 35.71 520-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 42.28 540-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 23.63 560-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 33.67 INV0002607 Invoice 03/15/2017 HEALTH INSURANCE DEDUCTION 0.00 2,932.50 010-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 2,167.50 060-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 148.76 510-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 116.94 520-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 159.32 540-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 201.84 560-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 95.64 570-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 42.50 INV0002608 Invoice 03/15/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.76 540-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 3.81 560-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 3.62 570-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 15.00 036350 IOWA DEPT OF HUMAN SERVICES 03/16/2017 Regular 0.00 1,740.58 128113 Payable # Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0002592 Invoice 03/15/2017 CHILDSUPPORT 0.00 1,740.58 010-2011300 CHILD SUPPORT PAYABLE CHI LD SUPPORT 1,616.70 060-2011300 CHILD SUPPORT PAYABLE CHILD SUPPORT 123.88 036740 COMMUNICATIONS WORKERS OF AMERICA 03/16/2017 Regular 0.00 888.78 128114 3/29/2017 9:23:49 AM Page 1 of 5 Council Payroll Reimbursements Date Range: 03/15/2017 - 03/29/2017 Vendor Number Vendor Name Payment Date Payment Type DiscountAmount PaymentAmount Number Payable# Payable Type Payable Date Payable Description DiscountAmount Payable Amount Account Number Account Name Item Description Distribution Amount INV0002595 Invoice 03/15/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.86 520-2014100 CREDIT UNION DEDUCTI CWA LOCAL 7102 UNION DUES 96.51 540-2014100 CREDIT UNION DEDUCTI CWA LOCAL 7102 UNION DUES 131.01 560-2014100 CREDIT UNION DEDUCTI CWA LOCAL 7102 UNION DUES 66.02 570-2014100 CREDIT UNION DEDUCTI CWA LOCAL 7102 UNION DUES 25.28 099999 EFTPS 03/16/2017 Regular 0.00 74,415.90 128115 Payable# Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0002613 Invoice 03/15/2017 FICA TAX WITHHOLDING 0.00 34,333.58 010-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 26,850.52 060-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 1,393.24 510-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 1,210.34 520-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 1,539.48 540-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 1,734.32 560-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 742.54 570-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 531.42 750-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 331.72 INV0002614 Invoice 03/15/2017 FEDERAL WITHHOLDING TAXES 0.00 32,011.42 010-2010200 FEDERALTAX WITHHOLDI FEDERAL WITHHOLDING TAXES 24,696.16 060-2010200 FEDERAL TAX WITHHOLD] FEDERAL WITHHOLDING TAXES 1,331.29 510-2010200 FEDERALTAX WITHHOLDI FEDERAL WITHHOLDING TAXES 1,175.59 520-2010200 FEDERALTAX WITHHOLD] FEDERAL WITHHOLDING TAXES 1,740.98 540-2010200 FEDERALTAX WITHHOLDI FEDERAL WITHHOLDING TAXES 1,544.77 560-2010200 FEDERALTAX WITHHOLDI FEDERAL WITHHOLDING TAXES 765.43 570-2010200 FEDERALTAX WITHHOLDI FEDERAL WITHHOLDING TAXES 689.45 750-2010200 FEDERALTAX WITHHOLDI FEDERAL WITHHOLDING TAXES 67.75 INV0002615 Invoice 03/15/2017 MEDICARE TAX WITHHOLDING 0.00 8,070.90 010-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 6,320.86 060-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 325.84 510-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 283.06 520-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 360.04 540-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 405.62 560-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 173.62 570-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 124.28 750-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 77.58 133560 MEALS FROM THE HEARTLAND 03/16/2017 Regular 0.00 124.20 128116 Payable# Payable Type Payable Date Payable Description DiscountAmount Payable Amount Account Number Account Name Item Description Distribution Amount INV0002600 Invoice 03/15/2017 MEALS FROM HEARTLAND DEDUCTION 0.00 124.20 010-2030000 PAYROLL PAYABLES MEALS FROM HEARTLAND DED 103.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 206800 TOTAL ADMINISTRATIVE SERVICES CORP 03/16/2017 Regular 0.00 4,359.93 128117 3/29/2017 9:23:49 AM Page 2 of 5 NIA Council Payroll Reimbursements Date Range: 03/15/2017 - 03/29/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 [NV0002605 Invoice 03/15/2017 SECTION 125 MEDICAL DEDUCTIONS 0.00 2,509.12 010-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCT] 1,876.16 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 INV0002606 Invoice 03/15/2017 SECTION 125 DAYCARE DEDUCTIONS 0.00 1,850.81 010-2030000 PAYROLL PAYABLES SECTION 125 DAYCARE DEDUCT 1,642.48 560-2030000 PAYROLL PAYABLES SECTION 125 DAYCARE DEDUCT 208.33 213250 UNITED WAY CENTRAL IOWA 03/16/2017 Regular 0.00 193.30 128118 Payable # Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0002597 Invoice 03/15/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 233050- WAUKEE PUBLIC LIBRARY FRIENDS FOUNDATIC 03/16/2017 Regular 0.00 36.66 128119 Payable It Payable Type Payable Date Payable Description DiscountAmount Payable Amount Account Number Account Name Item Description Distribution Amount INV0002601 Invoice 03/15/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 034875 CITY OF WAUKEE 03/20/2017 Regular 0.00 42.50 128122 Payable# Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0002618 Invoice 03/15/2017 HEALTH INSURANCE DEDUCTION 0.00 42.50 010-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 8.50 060-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 4.25 750-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 29.75 099999 EFTPS 03/20/2017 Regular 0.00 580.83 128123 Payable# Payable Type Payable Date Payable Description DiscountAmount Payable Amount Account Number Account Name Item Description Distribution Amount INV0002621 Invoice 03/15/2017 FICA TAX WITHHOLDING 0.00 295.24 010-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 59.04 060-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 29.52 750-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 206.68 INV0002622 Invoice 03/15/2017 FEDERAL WITHHOLDING TAXES 0.00 216.55 010-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 43.31 060-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 21.66 750-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 151.58 INV0002623 Invoice 03/15/2017 MEDICARE TAX WITHHOLDING 0.00 69.04 010-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 13.80 060-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 6.90 750-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 48.34 206800 TOTAL ADMINISTRATIVE SERVICES CORP 03/20/2017 Regular 0.00 104.16 128124 3/29/2017 9:23:49 AM Page 3 of 5 U Council Payroll Reimbursements Date Range: 03/15/2017 - 03/29/2017 Vendor Number Vendor Name Payment Date Payment Type Discount Amount PaymentAmount Number Payable# Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0002617 Invoice 03/15/2017 SECTION 125 MEDICAL DEDUCTIONS 0.00 104.16 010-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 20.84 060-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 10.41 750-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 72.91 Bank Code AP Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 20 11 0.00 87,141.02 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 20 31 0.00 87,141.02 3/29/2017 9:23:49 AM Page 4 of 5 Council Payroll Reimbursements Date Range: 03/15/2017 - 03/29/2017 Fund 999 Fund Summary Name Period Amount POOLED CASH 3/2017 87,141.02 87,141.02 3/29/2017 9:23:49 AM Page 5 of 5 a WmAcee Employee Name ABBOTT, BRENT ADKINS, COREY ALDRICH, SHAWN APPLE, WILLIAM ARIAS, HECTOR ARMSTRONG, BRETT BAKER, RANDY BAUMAN, LISA BERG, BROOKE BERGMAN, ANNASTASIA BOHARDT, HAZEL BOTTENBERG, RICHARD BRUNS,RACHEL BURKHART, LINDA BUSH, COURTNEY CAMPBELL, JUDY CAMPBELL, SCOTT CICHOSKI, KELLI CLEMEN, ANTHONY COLE, JACOB CORKREAN, JENNIFER 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 GODWIN, EDWARD GROVE, BRIAN GROVO,ANDREW HANSON,ANTHONY HANSON, LAURA HARDIN, THOMAS HARRISON, BRIAN HASKINS, STACEY HEIMANN, RONALD HENTGES, ERIC HERR, JENNA HERRICK, ROBERT HILGENBERG, ADAM City of Waukee, IA Publication Report By Employee Name Payroll Set: OS - City of Waukee For Date Range 03/01/2017-03/15/2017 Salary $1,223.91 $1,203.77 $1,527.43 $251.42 $1,793.66 $1,428.40 $1,626.37 $1,227.18 $84.24 $474.89 $339.89 $392.49 $1,675.54 $2,725.32 $886.70 $580.74 $1,923.33 $1,436.30 $755.83 $467.47 $1,676.16 $133.40 $639.47 $2,138.99 $1,244.05 $344.76 $1,700.75 $2,900.31 $2,137.39 $1,922.88 $993.90 $3,437.35 $1,172.06 $1,515.08 $737.91 $1,729.29 $1,984.71 $74.18 $1,662.85 $272.24 $1,714.49 $240.84 $3,287.08 $1,601.50 $132.71 $146.42 $207.71 $1,847.01 $1,349.60 $369.57 $392.49 $1,206.48 $2,103.66 $927.60 $1,422.39 $1,697.52 $1,593.34 Employee Name Salary HOLDEN, PATRICIA $2,686.20 HOPTON, SIMONE $88.79 HUGHES, RACHELLE $391.27 HUSTED, TROY $1,546.47 HUTTON, JOSHUA $676.71 IRWIN, BRENT $96.36 JENSEN, CHAD $364.70 JERMIER, MATTHEW $2,597.77 KASS, ANDREW $1,933.98 KASZINSKI, BRETT $774.22 KELLER, CHRISTOPHER $1,613.20 KERR, JACOB $1,541.04 KESSLER, MATTHEW $1,401,87 KIES, SUSAN $1,507.75 KOESTER, EVAN $1,803.61 KOESTER, RUDY $2,477.55 LARSON, KENNETH $497.16 LARSON, KRISTINE $2,534.92 LAUGHRIDGE, DANIEL $1,533.79 LEMKE, NEIL $1,169.29 LONG, JEREMY $2,565.63 LYNCH, SHANNON $1,519.90 LYON, LARRY $393.55 MANNING, JOSHUA $2,145.18 MANNING, TAYLOR $41.13 MAPES, TROY $2,601.77 MCCUNTIC, JAMES $956.94 MCKERN, DOUGLAS $257.96 MEDDERS, BRETT $1,224.30 MELLENCAMP, JEFFREY $2,034.75 MINIKUS, JOSHUA $1,667.80 MOERMAN, TIMOTHY $3,857.98 MURRA, BRIAN $1,767.61 NICELY -GREEN, CODY $313.49 NITZEL, NICOLE $602.06 NORTON, PATRICK $287.38 OAKLEY, JON $1,839.54 OLSEN, KART $1,443.40 OSTRING, KATHLEEN $1,354.23 PARISH, TONJA $1,327.91 PARKER, SUSAN $78.94 PEARD, WILLIAM $492.68 PERDRIAU, MARIE $247.99 PETERSON, KATIE $1,144.82 PETERSON, OREN $1,936.66 PETTIT, BRANDON $1,554.87 PIERSON, DAMON $1,226.45 PINEGAR, TOMMIE $1,401.73 PIZINGER, JAMES $1,175.05 POSADAS, OSCAR $338.74 PUDENZ, DANIELLE $12.10 PURVIS, KATHRYN $1,224.41 QUINN, JOHN $2,719.27 RASH, RONALD $1,919.04 RICHARDSON, ELIZABETH $1,669.48 ROBINSON, CLINT $3,107.40 ROYER, TIMOTHY $2,701.18 ROYSTER, JACOB $1,476.90 SCHAUFENBUEL, KARI $957.59 SCHETTLER, RODNEY $1,837.36 SCHUETT, REBECCA $1,999.23 SEDDON, JOSH $295.89 SHARON, JEREMIAH $1,140.81 SKELLENGER, AMANDA $66.88 N Employee Name Salary SNELSON, NATHANIEL $311.25 SOFEN, NATASHA $34.56 SPOSETO, MACKENZIE $2,117.67 SPRAGUE, MATTHEW $1,390.86 STEINKE, KURT $179.52 STEPHENS, CLINT $245.01 STEWARD, ERIC $1,766.99 STOTZ, MELISSA $698.13 TETMEYER, CARL $220.73 THAYER, CHANDLER $302.53 TIBBLES, STEVEN $1,480.49 TUEL, JASON $159.07 TYSDAL, THOMAS $2,273.32 VANDE KAMP, JOSHUA $1,565.16 VOEGTLE, TIMOTHY $1,421.06 VOKES, LARRY $1,631.47 WALLACE, ERIC $1,806.64 WASKE, CHARLES $1,988.19 WAYCASTER, SAVANNAH $149.22 WERNIMONT, THOMAS $357.47 WERTS, DANIEL $2,053.34 WESTON STOLL, KERI $1,499.03 WHITE, JASON $1,354.18 WHITE, LEAH $1,208.30 WIGGINS, MATHEW $1,817.57 WILSON, JODY $701.45 WINTERS, TROY $1,782.07 WISE, NATHAN $1,885.49 WOOD, DANIEL $525.04 YATES, CASSANDRA $260.77