Loading...
HomeMy WebLinkAbout2017-05-15-J01A 05152017_bill list_payrollCity of Waukee Bill Presentation Recap May 15, 2017 Total Unpaid Bills Presented for Approval : $7,934,045.87 Total Checks Issued Prior to Council Approval: Regular Checks: A) Prior to Last Council Meeting $157,455.33 B) After Last Council Meeting $5,979.24 C) Payroll Taxes & Reimbursements $204,584.23 D) Utility Refunds $1,088.06 Payroll Checks Issued: E) 04/30/2017 $188,786.35 Grand Total: $8,491,939.08 �} " ? 5 -ro -ao�? FY 2017 Fund Recap: Expenditures Revenues Budgeted Year To Date Budgeted Year To Date 010 General Fund $ 9,736,705 $ 8,490,603 $ 9,520,350 $ 9,938,651 060 Road Use Tax Fund $ 2,145,066 $ 1,844,541 $ 1,822,167 $ 1,799,756 075 Waukee Foundation $ - $ 24 $ - $ 60,900 085 Asset Forfeitures $ - $ - $ 421 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 $ - $ 14,411 $ - $ - 095 Autumn Ridge Urban Renewal $ - $ 521 $ - $ - 110 Debt Service Fund $ 6,951,481 $ 8,643,467 $ 6,999,755 $ 4,461,940 111 Special Assessments Fund $ 45,698 $ 45,698 $ 42,200 $ 32,533 210 Employee Benefits Fund $ 1,500,285 $ - $ 1,504,285 $ 1,450,108 327 Capital Projects $ 11,653,500 $ 5,300,396 $ 11,653,500 $ 1,283,744 330 City Wide SA Sidewalk Project $ - $ - $ - $ 5,025 510 Water Utility Fund $ 3,910,801 $ 2,682,811 $ 3,671,507 $ 3,812,942 520 Sewer Utility Fund $ 7,003,697 $ 6,824,244 $ 3,714,066 $ 4,284,133 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,628,193 $ 5,491,100 $ 5,076,424 560 Storm Sewer Utility Fund $ 1,148,970 $ 686,974 $ 891,150 $ 831,503 570 Utility Bill Fund $ 264,790 $ 193,583 $ 264,750 $ 192,151 590 Solid Waste Collect & Rcycl Fund $ 1,081,760 $ 1,009,035 $ 1,101,160 $ 980,121 750 Golf Course Fund $ 507,595 $ 466,654 $ 592,300 $ 405,914 810 Equipment Revolving Fund $ - $ - $ 30,000 $ 427 Total: $ 55,183.423 $ 39,859,701 $ 50,655,790 $ 37,959,081 City of Waukee FY2017 Department Report - General Fund As of MAY 15, 2017 Expended YTD Budgeted $ Remaining General Fund: Police Department Personnel Services $ 1,837,370 Supplies & Services $ 255,587 Capital Outlay $ 139,526 $ 2,232,482 $ 2,661,080 $ 428,598 Warning Sirens Personnel Services $ 989 Supplies & Services $ - CapitalOutlay $ $ 989 $ 2,000 $ 1,011 Westcom Dispatch Personnel Services $ - Supplies & Services $ 414,845 Capital Outlay $ - $ 414,845 $ 430,500 $ 15,655 Fire Department Personnel Services $ 573,001 Supplies & Services $ 74,542 Capital Outlay $ - $ 647,544 $ 830,720 $ 183,177 EMS Personnel Services $ 564,874 Supplies & Services $ 76,065 Capital Outlay $ - $ 640,939 $ 762,600 $ 121,661 Building Inspection Personnel Services $ 257,906 Supplies & Services $ 18,043 Capital Outlay $ 33,639 $ 309,587 $ 398,830 $ 89,243 Animal Control Personnel Services Supplies & Services $ 5,700 Capital Outlay $ 5,700 $ 1,000 $ (4,700) Library Services Personnel Services $ 467,768 Supplies & Services $ 170,150 Capital Outlay $ - $ 637,918 $ 852,275 $ 214,357 Mosquito Control Personnel Services $ Supplies & Services $ Capital Outlay $ - $ - $ 6,500 $ 6,500 Parks Personnel Services $ 208,281 Supplies & Services $ 127,946 Capital Outlay $ 69,648 $ 405.874 $ 480,297 $ 74,423 Recreation Personnel Services $ 283,374 Supplies & Services $ 160,311 Capital Outlay $ - $ 443,685 $ 523,662 $ 79,977 Community Center Personnel Services $ 2,977 Supplies & Services $ 12,427 Capital Outlay $ - $ 15,404 $ 24,320 $ 8,916 Public Works Personnel Services $ 109,745 Supplies & Services $ (7,127) Capital Outlay $ $ 102,618 $ 73,644 $ (28,974) Public Works Building Personnel Services $ - Supplies & Services $ 146,216 Capital Outlay $ 10,500 $ 156,716 $ - $ (156,716) Public Works Mechanic Personnel Services $ 144,954 Supplies & Services $ 138,496 Capital Outlay $ - $ 283,450 $ 171,750 $ (111,700) Median and Bldg Grounds Personnel Services Supplies & Services $ 6,924 Capital Outlay $ 6,924 $ 14,000 $ 7,076 Mayor & Council Personnel Services $ 28,894 Supplies & Services $ 23,405 Capital Outlay $ - $ 52,299 $ 72,840 $ 20,541 Elections Personnel Services $ Supplies & Services $ Capital Outlay $ - $ - $ 8,000 $ 8,000 Communications Personnel Services $ 53,302 Supplies & Services $ 9,199 Capital Outlay $ - $ 62,501 $ 114,808 $ 52,307 Administration Personnel Services $ 169,091 Supplies & Services $ 139,650 Capital Outlay $ 330,436 $ 639,177 $ 348,250 $ (290,927) City Hall Personnel Services $ - Supplies & Services $ 48,556 Capital Outlay $ - $ 48,556 $ 79,000 $ 30,444 Human Resources Personnel Services $ 63,916 Supplies & Services $ 7,307 Capital Outlay $ - $ 71,223 $ 80,138 $ 8,915 Financial Administration Personnel Services $ 124,869 Supplies & Services $ 27,950 Capital Outlay $ - $ 152,819 $ 198,922 $ 46,103 Community Development Personnel Services $ 182,774 Supplies & Services $ 95,385 Capital Outlay $ - $ 278,158 $ 324,240 $ 46,082 City Attorney Personnel Services $ - Supplies & Services $ 155,069 Capital Outlay $ - $ 155,069 $ 100,000 $ (55,069) Development Services Personnel Services $ 256,551 Supplies & Services $ 54,701 Capital Outlay $ - $ 311,252 $ 524,535 $ 213,283 Information Technology Personnel Services $ - Supplies & Services Capital Outlay $ 5,272 $ 5,272 $ - $ (5,272) Engineering Personnel Services $ 305,819 Supplies & Services $ 52,807 Capital Outlay $ 12,924 $ 371,550 $ 625,139 $ 253,589 GIS Personnel Services $ 29,082 Supplies & Services $ (3,954) Capital Outlay $ 12,924 $ 38,052 $ 27,655 $ (10,397) Transfers to GO Debt Service Total General Fund: Personnel Services Supplies & Services Capital Outlay $ 8,490,603 $ 9,736,705 $ 1,246,102 $ 5,665,535 $ 2,210,201 $ 614,866.61 $ 8,490,603 Expense Approval Register �¢ City of Waukee, IA Waukee -ket: APPKT00593 - MAY 16TH COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount TREASURER STATE OF IOWA INV0002859 04/30/2017 APR'17 WATER SALES TAXES 510-2030500 14,143.39 TREASURER STATE OF IOWA INV0002863 04/30/2017 APR'17 SEWER SALES TAXES 520-2030500 1,938.93 TREASURER STATE OF IOWA INV0002865 04/30/2017 APR'17 GAS SALES TAXES 540-2030500 2,327.58 TREASURER STATE OF IOWA INV0002866 04/30/2017 APR'17 STORM WATER SALE 560-2030500 1,212.09 TREASURER STATE OF IOWA INV0002867 04/30/2017 APR'17 GOLF COURSE SALES 750-2030500 1,223.74 TREASURER STATE OF IOWA INV0002868 04/30/2017 APR'17 PARK &REC SALES 010-2030500 138.00 BANKERS TRUST COMPANY INV0002877 05/16/2017 2016C SINKING FUND XFER 520-1080100 36,500.00 CHARLES FLICKINGER INV0002879 05/16/2017 REFUND -DEVELOPER DEPO 010-2035000 4,500.00 IOWA FINANCE AUTHORITY INV0002883 05/01/2017 98A-PRIN/INT 520-2066000 31,000.00 IOWA FINANCE AUTHORITY INV0002884 05/01/2017 98B-PRIN/INT 520-2066100 66,000.00 IOWA FINANCE AUTHORITY INV0002885 05/01/2017 98C- PRIN/INT 520-2066200 79,000.00 BANKERS TRUST COMPANY INV0002899 04/11/2017 12C-PRIN/INT 510-2321300 105,000.00 BANKERS TRUST COMPANY INV0002900 04/11/2017 15B-PRIN/INT 510-2321400 110,000.00 BANKERS TRUST COMPANY INV0002902 04/11/2017 13A-PRIN/INT 520-2320900 100,000.00 BANKERS TRUST COMPANY INV0002903 04/11/2017 15A-PRIN/INT 540-2321400 358,000.00 910,983.73 Department: 1100 - POLICE OPERATIONS DAVID OVERTON #104 2013 04/26/2017 PRE -EMPLOYMENT POLYGR 010-10.1100.230000 200.00 KIESLER'S POLICE SUPPLY, IN 0824520 04/24/2017 STREAMLIGHT REMOTE 010-10.1100.540000 239.00 ELECTRONIC ENGINEERING C 112001244-1 04/18/2017 BATT/KENWOOD/LITH/2000 010-10.1100.540000 387.00 HEARTLAND TIRE &AUTO 122090 05/02/2017 TIRE REPAIR 010-10.1100.560000 20.00 ORKIN PEST CONTROL 155946313 05/15/2017 PEST CONTROL -P.D. 010-10.1100.400000 103.72 STIVERS FORD 180510 05/05/2017 REPAIR BUMPER/FENDER/M 010-10.1100.410000 3,631.43 CARPENTER UNIFORM CO 438585 04/21/2017 SLACKS-CICHOSKI 010-10.1100.120000 86.99 CARPENTER UNIFORM CO 438739 04/25/2017 SERGEANT COLLAR PINS -CU 010-10.1100.120000 11.98 NATIONWIDE OFFICE CLEAN 60904 04/15/2017 CLEANING SERVICES APIRL'1 010-10.1100.400100 554.24 NATIONWIDE OFFICE CLEAN 61274 04/28/2017 WINDOW CLEANING - P.D. 010-10.1100.400100 360.00 MUTUALOF OMAHA 631098347 05/01/2017 MAY'17 LIFE & DISABILITY P 010-10.1100.100000 330.05 MUTUAL OF OMAHA 631098347 05/01/2017 MAY'17 LIFE & DISABILITY P 010-10.1100.100100 485.32 OFFICE DEPOT 920881775001 04/12/2017 CALENDARS/PAPER/CUPS/PL 010-10.1100.580000 127.96 OFFICE DEPOT 920881775001 04/12/2017 CALENDARS/PAPER/CUPS/PL 010-10.1100.590000 82.55 OFFICE DEPOT 920881914001 04/13/2017 25FT HANDSET CORD 010-10.1100.590000 5.69 VERIZON WIRELESS 9783884521 04/13/2017 APRIL'17 STATEMENT 010-10.1100.450000 22.74 CITY OF WAUKEE APR17110140150 04/30/2017 APRIL'17 STATEMENT 010-10.1100.480000 253.02 AMERITAS LIFE INSURANCE INV0002838 05/01/2017 MAY'17 VISION INSURANCE 010-10.1100.100000 466.72 CONSOLIDATED COMMUNIC INV0002908 05/08/2017 MAY'17 STATEMENT 010-10.1100.450000 48.73 CONSOLIDATED COMMUNIC INV0002908 05/08/2017 MAY'17 STATEMENT 010-10.1100.450000 49.25 STANARD & ASSOCIATES INC SA000034127 04/27/2017 TESTING FORMS 010-10.1100.590000 372.50 Department 1100 - POLICE OPERATIONS Total: 7,838.89 Department: 1300- WESTCOM DISPATCH CITY OF WEST DES MOINES FN-2017-00000213 05/02/2017 MAY'17 WESTCOM 010-10.1300.230010 33,763.09 Department 1300 - WESTCOM DISPATCH Total: 33,763.09 Department: 1400 - FIRE PROTECTION EARL MAY SEED &NURSERY 00117618 05/03/2017 PEAT 010-10.1400.590000 59.94 FIRE SERVICE TRAINING BUR 001289 04/15/2017 93RD ANN. STATE FIRE SCHO 010-10.1400.470000 185.00 FIRE SERVICE TRAINING BUR 001391 04/17/2017 CERTIFICATION FEES- MCCLI 010-10.1400.470000 25.00 FAREWAY STORES, INC. 00179667 04/25/2017 POP/CUPS 010-10.1400.590000 6.04 ADEL AUTO PARTS 356980 05/02/2017 OIL FILTER/SYNTHETIC OIL 010-10.1400.410000 15.40 KUM & GO 49597327 04/30/2017 APRIL'17 STATEMENT 010-10.1400.570000 392.05 THE WALDINGER CORP 5771921-1 04/27/2017 REPLACE SENSOR 010-10.1400.400000 573.92 MUTUAL OF OMAHA 631098347 05/01/2017 MAY'17 LIFE & DISABILITY P 010-10.1400.100000 127.10 MUTUAL OF OMAHA 631098347 05/01/2017 MAY'17 LIFE & DISABILITY P 010-10.1400.100100 92.23 NAPA AUTO PARTS STORE 931777 05/02/2017 BLUE DEF 2.5 GAL 010-10.1400.410000 38.97 5/10/2017 1:59:35 PM Page 1 of 20 Expense Approval Register Packet: APPKT0O593 - MAY 16TH COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount FIRE SAFETY USA, INC. 99820 04/17/2017 E-ONE BUMPET STOP FOR T 010-10.1400.410000 126.00 CITY OF WAUKEE APR17110140150 04/30/2017 APRIL'17 STATEMENT 010-10.1400.480000 167.69 AMERITAS LIFE INSURANCE INV0002838 05/O1/2017 MAY'17 VISION INSURANCE 010-10.1400.100000 100.68 BOB PLATZ INV0002839 05/16/2017 WED ASSESSMENT CENTER 010-10.1400.470000 69.55 WAUKEE HARDWARE & VARI INV0002848 04/30/2017 APRIL'17 STATEMENT- FIRE 010-10.1400.590000 24.66 CONSOLIDATED COMMUNIC INV0002908 05/08/2017 MAY'17 STATEMENT 010-10.1400.450000 45.65 CONSOLIDATED COMMUNIC INV0002908 05/08/2017 MAY'17 STATEMENT 010-10.1400.450000 49.25 ALERT -ALL CORPORATION W15079 04/27/2017 JR FIREFIGHTERS STICK-ON-B 010-10.1400.460100 55.00 Department 1400 - FIRE PROTECTION Total: 2,154.13 Department: 1500 - EMS FIRE SERVICE TRAINING BUR 001391 04/17/2017 CERTIFICATION FEES -MCCLI 010-10.1500.470000 25.00 FAREWAY STORES, INC. 00179667 04/25/2017 POP/CUPS 010-10.1500.590000 6.05 ADEL AUTO PARTS 356980 05/02/2017 OIL FILTER/SYNTHETIC OIL 010-10.1500.410000 15.39 KUM&GO 49597327 04/30/2017 APRIL'17 STATEMENT 010-10.1500.570000 392.05 THE WALDINGER CORP 5771921-1 04/27/2017 REPLACE SENSOR 010-10.1500.400000 573.92 MUTUAL OF OMAHA 631098347 05/O1/2017 MAY'17 LIFE & DISABILITY P 010-10.1500.100000 10.40 MUTUAL OF OMAHA 631098347 05/01/2017 MAY'17 LIFE & DISABILITY P 010-10.1500.100100 39.29 BOUND TREE MEDICAL 82478927 04/27/2017 MEDICALSUPPLIES 010-10.1500.590050 121.03 BOUND TREE MEDICAL 82480439 04/30/2017 MEDICALSUPPLIES 010-10.1500.590050 76.76 BOUND TREE MEDICAL 82480440 04/30/2017 MEDICALSUPPLIES 010-10.1500.540000 1,247.50 BOUND TREE MEDICAL 82480441 04/30/2017 MEDICALSUPPLIES 010-10.1500.540000 320.88 BOUND TREE MEDICAL 82481515 05/01/2017 MEDICALSUPPLIES 010-10.1500.590050 34.04 NAPA AUTO PARTS STORE 929003 04/20/2017 AIR BREAK HOSE/FITTING 010-10.1500.410000 25.96 NAPA AUTO PARTS STORE 929201 04/21/2017 FITTING 010-10.1500.410000 8.69 NAPA AUTO PARTS STORE 929238 04/21/2017 REFUND FITTING CHARGES 010-10.1500.410000 -23.98 NAPA AUTO PARTS STORE 929252 04/21/2017 AIR LEAK REPAIR 010-10.1500.410000 2.30 NAPA AUTO PARTS STORE 931777 05/02/2017 BLUE DEF 2.5 GAL 010-10.1500.410000 38.97 CITY OF WAUKEE APR17110140150 04/30/2017 APRIL'17 STATEMENT 010-10.1500.480000 167.70 AMERITAS LIFE INSURANCE INV0002838 05/O1/2017 MAY'17 VISION INSURANCE 010-10.1500.100000 100.67 BOB PLATZ INV0002839 05/16/2017 WFDASSESSMENT CENTER 010-10.1500.470000 69.55 WAUKEE HARDWARE & VARI INV0002848 04/30/2017 APRIL'17 STATEMENT - FIRE 010-10.1500.590000 24.65 CONSOLIDATED COMMUNIC INV0002908 05/08/2017 MAY'17 STATEMENT 010-10.1500.450000 49.25 CONSOLIDATED COMMUNIC INV0002908 05/08/2017 MAY'17 STATEMENT 010-10.1500.450000 45.65 ALERT -ALL CORPORATION W15079 04/27/2017 JR FIREFIGHTERS STICK-ON-B 010-10.1500.460100 55.00 Department 1500 - EMS Total: 3,426.72 Department: 1600 -STREET LIGHTING MID AMERICAN ENERGY 300210417 04/21/2017 APRIL'17 STATEMENT 060-30.1600.480000 4.18 IOWA SIGNAL INC 3542 04/26/2017 INSTALLLED 060-30.1600.430300 710.83 IOWA SIGNAL INC 3557 04/26/2017 INSTALLLED 060-30.1600.410300 710.83 MID AMERICAN ENERGY APR171600SUMBILL 04/25/2017 APRIL'17 STATEMENT 060-30.1600.480000 14,999.14 Department 1600 - STREET LIGHTING Total: 16,424.98 Department: 1601 -TRAFFIC SIGNALS SNYDER & ASSOCIATES INC 116.0901.01-6 04/27/2017 US HWY 6 & W ESTGATE DR 1 327-90.1601.235030 1,850.00 MID AMERICAN ENERGY APR171601SU M BILL 04/25/2017 APRIL'17 STATEMENT 060-30.1601.480000 317.33 Department 1601- TRAFFIC SIGNALS Total: 2,167.33 Department: 1900 - BUILDING INSPECTION MUTUAL OF OMAHA 631098347 05/O1/2017 MAY'17 LIFE & DISABILITY P 010-10.1900.100000 42.00 MUTUAL OF OMAHA 631098347 05/O1/2017 MAY'17 LIFE & DISABILITY P 010-10.1900.100100 95.09 AMERITAS LIFE INSURANCE INV0002838 05/01/2017 MAY'17 VISION INSURANCE 010-10.1900.100000 75.84 ACCESS SYSTEMS INV516140 04/26/2017 BLACK TONER 010-10.1900.270110 129.55 LANDS END BUSINESS OUTFI SIN4903932 04/21/2017 SHIRTS-PARISH/OSTRING/EV 010-10.1900.120000 44.95 Department 1900 - BUILDING INSPECTION Total: 387.43 Department: 2130 - ALICES ROAD PROJECT FASTSIGNS 42-92676 03/31/2017 PROJECTSIGNS 327-90.2130.840490 445.00 FOTH INFRASTRUCTURE & E 52109 04/21/2017 HY-VEE TRAFFIC MODEL REV 327-90.2130.840491 91.00 FOTH INFRASTRUCTURE & E 52118 04/21/2017 SE ALICE'S RD/SE OLSON DR/ 327-90.2130.840491 185,956.71 FOTH INFRASTRUCTURE & E 52137 04/25/2017 GPP & ESKER RIDGE TRAFFIC 327-90.2130.230051 3,226.00 Department 2130 - ALICES ROAD PROJECT Total: 189,718.71 5/10/2017 1:59:35 PM Page 2 of 20 Expense Approval Register Packet: APPKT00593 - MAY 16TH COUNCIL PACKET Vendor Name Payable Number Post Date Description )Item) Account Number Amount Department: 2131- ESKER RIDGE - RISE PROJECT WITH INFRASTRUCTURE & E 52111 04/21/2017 SE ESKER RIDGE DRIVE RISE 327-90.2131.230051 3,291.89 Department 2131- ESKER RIDGE - RISE PROJECT Total: 3,291.89 Department: 2132 - ASH WORTH ROAD IMPROVEMENTS FOTH INFRASTRUCTURE & E 52109 04/21/2017 ESTIMATING SE ASHWORTH 327-90.2132.230000 158.00 Department 2132 - ASH WORTH ROAD IMPROVEMENTS Total: 158.00 Department: 2150 - PARK & REC COMPLEX FOTH INFRASTRUCTURE & E 52136 04/25/2017 WAUKEE HIGH SCHOOL NO. 327-90.2150.980110 4,467.32 Department 2150 - PARK & REC COMPLEX Total: 4,467.32 Department: 2200 - CAPITAL PROJECTS MOODY'S INVESTORS SERVIC P0237855 04/28/2017 2017A-CREDIT RATING FEES 327-90.2200.930300 18,500.00 Department 2200 - CAPITAL PROJECTS Total: 18,500.00 Department: 2400-ANIMAL CONTROL BRODERICK ANIMAL CLINIC 149436 04/26/2017 FELINE/CANINE BOARDING 010-10.2400.340000 540.00 Department 2400 -ANIMAL CONTROL Total: 540.00 Department: 3100 - LIBRARY SERVICES ORKIN PEST CONTROL 155945340 05/15/2017 PEST CONTROL - LIBRARY 010-40.3100.400000 65.97 WASH -ECLAIR 188365 05/O1/2017 WASH WINDOWS - LIBRARY 010-40.3100.400100 38.00 METHODIST OCCUPATIONAL 223367 04/28/2017 PRE -EMPLOYMENT SCREENS 010-40.3100.470000 192.00 MOVIE LICENSING USA 2334242 05/O1/2017 COPYRIGHT COMPLIANCE U 010-40.3100.460300 351.00 FASTSIGNS 42-93136 04/28/2017 LIBRARY HOURS SIGN 010-40.3100.580000 90.42 MERRITT COMPANY INC 50318 04/24/2017 CARPET CLEANING 010-40.3100.400100 350.00 DEMCO INC. 6119403 04/26/2017 NAME BADGES 010-40.3100.580000 128.96 MUTUAL OF OMAHA 631098347 05/O1/2017 MAY'17 LIFE & DISABILITY P 010-40.3100.100000 56.20 MUTUAL OF OMAHA 631098347 05/O1/2017 MAY'17 LIFE & DISABILITY P 010-40.3100.100100 59.72 CINTAS CORPORATION 762507694 03/03/2017 SCRAPER/TRAFFIC MATS 010-40.3100.400000 75.45 CINTAS CORPORATION 762513365 03/31/2017 SCRAPER/TRAFFIC MATS 010-40,3100.400000 38.51 CINTAS CORPORATION 762519031 04/28/2017 SCRAPER/TRAFFIC MATS 010-40.3100.400000 38.51 HOOTSUITE MEDIA INC. 832462326 04/29/2017 HOOTSUITE PRO - ANNUAL 010-40.3100.270000 119.88 OFFICE DEPOT 919941368001 04/14/2017 PAPER/TAPE/CLOROX 010-40.3100.580000 60.34 OFFICE DEPOT 920151609001 04/17/2017 TOILET PAPER/MOP/TOWEL 010-40.3100.580000 310.74 INGRAM LIBRARY SERVICES 97914957 03/31/2017 BOOKS 010-40.3100.590000 3.24 INGRAM LIBRARY SERVICES 97914957 03/31/2017 BOOKS 010-40.3100.640000 9.59 INGRAM LIBRARY SERVICES 97914958 03/31/2017 BOOKS 010-40.3100.590000 1.19 INGRAM LIBRARY SERVICES 97914958 03/31/2017 BOOKS 010-40,3100.640000 9.19 INGRAM LIBRARY SERVICES 97928255 04/02/2017 BOOKS 010-40.3100.590000 2.90 INGRAM LIBRARY SERVICES 97928255 04/02/2017 BOOKS 010-40.3100.640000 74.97 INGRAM LIBRARY SERVICES 97928256 04/02/2017 BOOKS 010-40.3100.590000 1.80 INGRAM LIBRARY SERVICES 97928256 04/02/2017 BOOKS 010-40.3100.640000 43.48 INGRAM LIBRARY SERVICES 97928257 04/02/2017 BOOKS 010-40.3100.590000 1.80 INGRAM LIBRARY SERVICES 97928257 04/02/2017 BOOKS 010-40.3100.640000 49.48 INGRAM LIBRARY SERVICES 97928258 04/02/2017 BOOKS 010-40.3100.590000 1.19 INGRAM LIBRARY SERVICES 97928258 04/02/2017 BOOKS 010-40.3100.640000 9.77 INGRAM LIBRARY SERVICES 97928259 04/02/2017 BOOKS 010-40.3100.590000 49.98 INGRAM LIBRARY SERVICES 97928259 04/02/2017 BOOKS 010-40.3100.640000 423.45 INGRAM LIBRARY SERVICES 97928260 04/02/2017 BOOKS 010-40.3100.590000 29.22 INGRAM LIBRARY SERVICES 97928260 04/02/2017 BOOKS 010-40.3100.640000 99.45 INGRAM LIBRARY SERVICES 97929261 04/02/2017 BOOKS 010-40.3100.590000 5.42 INGRAM LIBRARY SERVICES 97929261 04/02/2017 BOOKS 010-40.3100.640000 34.11 INGRAM LIBRARY SERVICES 97928262 04/02/2017 BOOKS 010-40.3100.590000 15.77 INGRAM LIBRARY SERVICES 97928262 04/02/2017 BOOKS 010-40.3100.640000 135.55 INGRAM LIBRARY SERVICES 97928263 04/02/2017 BOOKS 010-40.3100.590000 10.49 INGRAM LIBRARY SERVICES 97928263 04/02/2017 BOOKS 010-40.3100.640000 307.54 INGRAM LIBRARY SERVICES 97928264 04/02/2017 BOOKS 010-40.3100.590000 1.19 INGRAM LIBRARY SERVICES 97928264 04/02/2017 BOOKS 010-40.3100.640000 16.14 INGRAM LIBRARY SERVICES 97928265 04/02/2017 BOOKS 010-40.3100.590000 1.19 INGRAM LIBRARY SERVICES 97928265 04/02/2017 BOOKS 010-40.3100.640000 14.92 INGRAM LIBRARY SERVICES 97928266 04/02/2017 BOOKS 010-40.3100.590000 1.19 INGRAM LIBRARY SERVICES 97928266 04/02/2017 BOOKS 010-40.3100.640000 16.09 5/10/2017 1:59:35 PM Page 3 of 20 Expense Approval Register Packet: APPKT00593 - MAY 16TH COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount INGRAM LIBRARY SERVICES 97928267 04/02/2017 BOOKS 010-40.3100.590000 26.44 INGRAM LIBRARY SERVICES 97928267 04/02/2017 BOOKS 010-40.3100.640000 195.08 INGRAM LIBRARY SERVICES 97928268 04/02/2017 BOOKS 010-40.3100.590000 19.17 INGRAM LIBRARY SERVICES 97928268 04/02/2017 BOOKS 010-40.3100.640000 122.96 INGRAM LIBRARY SERVICES 97928269 04/02/2017 BOOKS 010-40.3100.590000 2.49 INGRAM LIBRARY SERVICES 97928269 04/02/2017 BOOKS 010-40.3100.640000 94.31 INGRAM LIBRARY SERVICES 97928270 04/02/2017 BOOKS 010-40.3100.590000 56.30 INGRAM LIBRARY SERVICES 97928270 04/02/2017 BOOKS 010-40.3100.640000 283.60 INGRAM LIBRARY SERVICES 97965224 04/04/2017 BOOKS 010-40.3100.590000 2.38 INGRAM LIBRARY SERVICES 97965224 04/04/2017 BOOKS 010-40.3100.640000 14.94 INGRAM LIBRARY SERVICES 97965225 04/04/2017 BOOKS 010-40.3100.590000 4.99 INGRAM LIBRARY SERVICES 97965225 04/04/2017 BOOKS 010-40.3100.640000 21.99 INGRAM LIBRARY SERVICES 97965226 04/04/2017 BOOKS 010-40.3100.590000 2.38 INGRAM LIBRARY SERVICES 97965226 04/04/2017 BOOKS 010-40.3100.640000 18.38 INGRAM LIBRARY SERVICES 97965227 04/04/2017 BOOKS 010-40.3100.590000 1.19 INGRAM LIBRARY SERVICES 97965227 04/04/2017 BOOKS 010-40.3100.640000 17.22 INGRAM LIBRARY SERVICES 97965228 04/04/2017 BOOKS 010-40.3100.590000 1.19 INGRAM LIBRARY SERVICES 97965228 04/04/2017 BOOKS 010-40.3100.640000 9.77 INGRAM LIBRARY SERVICES 97965229 04/04/2017 BOOKS 010-40.3100.590000 2.38 INGRAM LIBRARY SERVICES 97965229 04/04/2017 BOOKS 010-40.3100.640000 31.63 INGRAM LIBRARY SERVICES 97965230 04/04/2017 BOOKS 010-40.3100.590000 1.73 INGRAM LIBRARY SERVICES 97965230 04/04/2017 BOOKS 010-40.3100.640000 11.48 INGRAM LIBRARY SERVICES 97965231 04/04/2017 BOOKS 010-40.3100.590000 7.94 INGRAM LIBRARY SERVICES 97965231 04/04/2017 BOOKS 010-40.3100.640000 60.79 INGRAM LIBRARY SERVICES 97983133 04/05/2017 BOOKS 010-40.3100.590000 1.39 INGRAM LIBRARY SERVICES 97983133 04/05/2017 BOOKS 010-40.3100.640000 9.19 INGRAM LIBRARY SERVICES 97983134 04/05/2017 BOOKS 010-40.3100.590000 1.39 INGRAM LIBRARY SERVICES 97983134 04/05/2017 BOOKS 010-40.3100.640000 10.34 INGRAM LIBRARY SERVICES 97983135 04/05/2017 BOOKS 010-40.3100.590000 5.00 INGRAM LIBRARY SERVICES 97983135 04/05/2017 BOOKS 010-40.3100.640000 14.39 INGRAM LIBRARY SERVICES 97983136 04/05/2017 BOOKS 010-40.3100.590000 3.97 INGRAM LIBRARY SERVICES 97983136 04/05/2017 BOOKS 010-40,3100.640000 28.73 INGRAM LIBRARY SERVICES 97983137 04/05/2017 BOOKS 010-40.3100.590000 1.19 INGRAM LIBRARY SERVICES 97983137 04/05/2017 BOOKS 010-40.3100.640000 7.79 INGRAM LIBRARY SERVICES 97983138 04/05/2017 BOOKS 010-40.3100.590000 1.19 INGRAM LIBRARY SERVICES 97983138 04/05/2017 BOOKS 010-40.3100.640000 16.10 INGRAM LIBRARY SERVICES 97983139 04/05/2017 BOOKS 010-40.3100.590000 1.19 INGRAM LIBRARY SERVICES 97983139 04/05/2017 BOOKS 010-40.3100.640000 16.09 INGRAM LIBRARY SERVICES 97983140 04/05/2017 BOOKS 010-40.3100.590000 1.19 INGRAM LIBRARY SERVICES 97983140 04/05/2017 BOOKS 010-40.3100.640000 10.34 INGRAM LIBRARY SERVICES 97983141 04/05/2017 BOOKS 010-40.3100.590000 1.19 INGRAM LIBRARY SERVICES 97983141 04/05/2017 BOOKS 010-40.3100.640000 16.10 INGRAM LIBRARY SERVICES 97983142 04/05/2017 BOOKS 010-40.3100.590000 0.50 INGRAM LIBRARY SERVICES 97983142 04/05/2017 BOOKS 010-40.3100.640000 29.99 INGRAM LIBRARY SERVICES 97983143 04/05/2017 BOOKS 010-40.3100.590000 3.04 INGRAM LIBRARY SERVICES 97983143 04/05/2017 BOOKS 010-40.3100.640000 4.19 INGRAM LIBRARY SERVICES 98015975 04/07/2017 BOOKS 010-40.3100.590000 0.90 INGRAM LIBRARY SERVICES 98015975 04/07/2017 BOOKS 010-40.3100.640000 18.74 INGRAM LIBRARY SERVICES 98015976 04/07/2017 BOOKS 010-40.3100.590000 0.50 INGRAM LIBRARY SERVICES 98015976 04/07/2017 BOOKS 010-40.3100.640000 44.98 INGRAM LIBRARY SERVICES 98015977 04/07/2017 BOOKS 010-40.3100.590000 0.54 INGRAM LIBRARY SERVICES 98015977 04/07/2017 BOOKS 010-40.3100.640000 9.75 INGRAM LIBRARY SERVICES 98015978 04/07/2017 BOOKS 010-40.3100.590000 0.25 INGRAM LIBRARY SERVICES 98015978 04/07/2017 BOOKS 010-40.3100.640000 22.49 INGRAM LIBRARY SERVICES 98028176 04/09/2017 BOOKS 010-40.3100.590000 1.64 INGRAM LIBRARY SERVICES 98028176 04/09/2017 BOOKS 010-40.3100.640000 16.68 INGRAM LIBRARY SERVICES 98028177 04/09/2017 BOOKS 010-40.3100.590000 1.73 INGRAM LIBRARY SERVICES 98028177 04/09/2017 BOOKS 010-40.3100.640000 20.11 INGRAM LIBRARY SERVICES 98028178 04/09/2017 BOOKS 010-40.3100.590000 1.85 INGRAM LIBRARY SERVICES 98028178 04/09/2017 BOOKS 010-40.3100.640000 9.60 5/10/2017 1:59:35 PM Page 4 of 20 Expense Approval Register Packet: APPKT00593 - MAY 16TH COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount INGRAM LIBRARY SERVICES 98028179 04/09/2017 BOOKS 010-40.3100.590000 4.05 INGRAM LIBRARY SERVICES 98028179 04/09/2017 BOOKS 010-40.3100.640000 48.83 INGRAM LIBRARY SERVICES 98081343 04/12/2017 BOOKS 010-40,3100.590000 1.19 INGRAM LIBRARY SERVICES 98081343 04/12/2017 BOOKS 010-40,3100.640000 9.19 INGRAM LIBRARY SERVICES 98081344 04/12/2017 BOOKS 010-40.3100.590000 6.18 INGRAM LIBRARY SERVICES 98081344 04/12/2017 BOOKS 010-40.3100.640000 37.52 INGRAM LIBRARY SERVICES 98081345 04/12/2017 BOOKS 010-40.3100.590000 1.19 INGRAM LIBRARY SERVICES 98081345 04/12/2017 BOOKS 010-40.3100.640000 10.34 INGRAM LIBRARY SERVICES 98081346 04/12/2017 BOOKS 010-40.3100.590000 150.72 INGRAM LIBRARY SERVICES 98081346 04/12/2017 BOOKS 010-40.3100.640000 1,267.30 INGRAM LIBRARY SERVICES 98081347 04/12/2017 BOOKS 010-40.3100.590000 1.19 INGRAM LIBRARY SERVICES 98081347 04/12/2017 BOOKS 010-40.3100.640000 16.10 INGRAM LIBRARY SERVICES 98081348 04/12/2017 BOOKS 010-40.3100.590000 2.38 INGRAM LIBRARY SERVICES 98081348 04/12/2017 BOOKS 010-40.3100.640000 21.26 INGRAM LIBRARY SERVICES 98081349 04/12/2017 BOOKS 010-40.3100.590000 4.65 INGRAM LIBRARY SERVICES 98081349 04/12/2017 BOOKS 010-40.3100.640000 49.41 INGRAM LIBRARY SERVICES 98081350 04/12/2017 BOOKS 010-40.3100.590000 1.19 INGRAM LIBRARY SERVICES 98081350 04/12/2017 BOOKS 010-40.3100.640000 9.19 INGRAM LIBRARY SERVICES 98081351 04/12/2017 BOOKS 010-40.3100.590000 3.04 INGRAM LIBRARY SERVICES 98081351 04/12/2017 BOOKS 010-40.3100.640000 7.79 INGRAM LIBRARY SERVICES 98081352 04/12/2017 BOOKS 010-40.3100.590000 7.74 INGRAM LIBRARY SERVICES 98081352 04/12/2017 BOOKS 010-40.3100.640000 29.44 INGRAM LIBRARY SERVICES 98081353 04/12/2017 BOOKS 010-40.3100.590000 1.50 INGRAM LIBRARY SERVICES 98081353 04/12/2017 BOOKS 010-40.3100.640000 25.51 INGRAM LIBRARY SERVICES 98099346 04/13/2017 BOOKS 010-40.3100.590000 1.44 INGRAM LIBRARY SERVICES 98099346 04/13/2017 BOOKS 010-40.3100.640000 13.74 INGRAM LIBRARY SERVICES 98099347 04/13/2017 BOOKS 010-40.3100.590000 3.38 INGRAM LIBRARY SERVICES 98099347 04/13/2017 BOOKS 010-40.3100.640000 18.37 INGRAM LIBRARY SERVICES 98151941 04/18/2017 BOOKS 010-40.3100.590000 3.04 INGRAM LIBRARY SERVICES 98151941 04/18/2017 BOOKS 010-40.3100.640000 5.99 INGRAM LIBRARY SERVICES 98151942 04/18/2017 BOOKS 010-40.3100.590000 4.40 INGRAM LIBRARY SERVICES 98151942 04/18/2017 BOOKS 010-40.3100.640000 29.99 INGRAM LIBRARY SERVICES 98151943 04/18/2017 BOOKS 010-40.3100.590000 4.76 INGRAM LIBRARY SERVICES 98151943 04/18/2017 BOOKS 010-40.3100.640000 40.22 INGRAM LIBRARY SERVICES 98151944 04/18/2017 BOOKS 010-40.3100.590000 12.05 INGRAM LIBRARY SERVICES 98151944 04/18/2017 BOOKS 010-40.3100.640000 97.31 INGRAM LIBRARY SERVICES 98151945 04/18/2017 BOOKS 010-40.3100.590000 17.65 INGRAM LIBRARY SERVICES 98151945 04/18/2017 BOOKS 010-40.3100.640000 68.72 INGRAM LIBRARY SERVICES 98151946 04/18/2017 BOOKS 010-40.3100.590000 1.19 INGRAM LIBRARY SERVICES 98151946 04/18/2017 BOOKS 010-40.3100.640000 16.68 INGRAM LIBRARY SERVICES 98151947 04/18/2017 BOOKS 010-40.3100.590000 1.19 INGRAM LIBRARY SERVICES 98151947 04/18/2017 BOOKS 010-40.3100.640000 21.00 INGRAM LIBRARY SERVICES 98151948 04/18/2017 BOOKS O10-40.3100.590000 1.73 INGRAM LIBRARY SERVICES 98151948 04/18/2017 BOOKS 010-40.3100.640000 20.68 INGRAM LIBRARY SERVICES 98151949 04/18/2017 BOOKS 010-40.3100,590000 1.08 INGRAM LIBRARY SERVICES 98151949 04/18/2017 BOOKS 010-40.3100.640000 45.99 INGRAM LIBRARY SERVICES 98151950 04/18/2017 BOOKS 010-40.3100.590000 1.85 INGRAM LIBRARY SERVICES 98151950 04/18/2017 BOOKS 010-40.3100.640000 4.79 INGRAM LIBRARY SERVICES 98151951 04/18/2017 BOOKS 010-40.3100.590000 0.25 INGRAM LIBRARY SERVICES 98151951 04/18/2017 BOOKS 010-40.3100.640000 23.24 INGRAM LIBRARY SERVICES 98169531 04/19/2017 BOOKS 030-40.3300.590000 2.38 INGRAM LIBRARY SERVICES 98169531 04/19/2017 BOOKS 010-40.3100.640000 13.74 INGRAM LIBRARY SERVICES 98169532 04/19/2017 BOOKS 010-40.3100.590000 0.65 INGRAM LIBRARY SERVICES 98169532 04/19/2017 BOOKS 010-40.3100.640000 16.09 INGRAM LIBRARY SERVICES 98169533 04/19/2017 BOOKS 010-40.3100.590000 5.74 INGRAM LIBRARY SERVICES 98169533 04/19/2017 BOOKS 010-40.3100.640000 22.49 INGRAM LIBRARY SERVICES 98169534 04/19/2017 BOOKS 010-40.3100.640000 15.20 INGRAM LIBRARY SERVICES 98169535 04/19/2017 BOOKS 010-40.3100.590000 1.85 INGRAM LIBRARY SERVICES 98169535 04/19/2017 BOOKS 010-40.3100.640000 9.60 INGRAM LIBRARY SERVICES 98169536 04/19/2017 BOOKS 010-40.3100.590000 2.74 5/10/2017 1:59:35 PM Page 5 of 20 Expense Approval Register Packet: APPKT00593 - MAY 16TH COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount INGRAM LIBRARY SERVICES 98169536 04/19/2017 BOOKS 010-40.3100.640000 48.73 INGRAM LIBRARY SERVICES 98169537 04/19/2017 BOOKS 010-40.3100.590000 3.57 INGRAM LIBRARY SERVICES 98169537 04/19/2017 BOOKS 010-40.3100.640000 24.71 INGRAM LIBRARY SERVICES 98169538 04/19/2017 BOOKS 010-40.3100.590000 3.04 INGRAM LIBRARY SERVICES 98169538 04/19/2017 BOOKS 010-40.3100.640000 2.99 INGRAM LIBRARY SERVICES 98199976 04/21/2017 BOOKS 010-40.3100.590000 5.19 INGRAM LIBRARY SERVICES 98199976 04/21/2017 BOOKS 010-40.3100.640000 21.99 INGRAM LIBRARY SERVICES 98199977 04/21/2017 BOOKS 010-40.3100.590000 1.19 INGRAM LIBRARY SERVICES 98199977 04/21/2017 BOOKS 010-40.3100.640000 16.09 INGRAM LIBRARY SERVICES 98199978 04/21/2017 BOOKS 010-40.3100.590000 1.19 INGRAM LIBRARY SERVICES 98199978 04/21/2017 BOOKS 010-40.3100.640000 10.92 INGRAM LIBRARY SERVICES 98199979 04/21/2017 BOOKS 010-40.3100.590000 2.38 INGRAM LIBRARY SERVICES 98199979 04/21/2017 BOOKS 010-40.3100.640000 20.11 INGRAM LIBRARY SERVICES 98199980 04/21/2017 BOOKS 010-40.3100.590000 0.65 INGRAM LIBRARY SERVICES 98199980 04/21/2017 BOOKS 010-40.3100.640000 14.37 INGRAM LIBRARY SERVICES 98199981 04/21/2017 BOOKS 010-40.3100.590000 3.57 INGRAM LIBRARY SERVICES 98199981 04/21/2017 BOOKS 010-40.3100.640000 29.99 INGRAM LIBRARY SERVICES 98199982 04/21/2017 BOOKS 010-40.3100.590000 1.19 INGRAM LIBRARY SERVICES 98199982 04/21/2017 BOOKS 010-40.3100.640000 16.10 INGRAM LIBRARY SERVICES 98211930 04/23/2017 BOOKS 010-40.3100.590000 5.44 INGRAM LIBRARY SERVICES 98211930 04/23/2017 BOOKS 010-40.3100.640000 19.24 INGRAM LIBRARY SERVICES 98211931 04/23/2017 BOOKS 010-40.3100.590000 1.39 INGRAM LIBRARY SERVICES 98211931 04/23/2017 BOOKS 010-40.3100.640000 16.68 INGRAM LIBRARY SERVICES 98211932 04/23/2017 BOOKS 010-40.3100.590000 1.19 INGRAM LIBRARY SERVICES 98211932 04/23/2017 BOOKS 010-40.3100.640000 16.68 INGRAM LIBRARY SERVICES 98211933 04/23/2017 BOOKS 010-40.3100.590000 4.76 INGRAM LIBRARY SERVICES 98211933 04/23/2017 BOOKS 010-40.3100.640000 61.47 INGRAM LIBRARY SERVICES 98211934 04/23/2017 BOOKS 010-40.3100.590000 14.36 INGRAM LIBRARY SERVICES 98211934 04/23/2017 BOOKS 010-40.3100.640000 50.17 INGRAM LIBRARY SERVICES 98211935 04/23/2017 BOOKS 010-40.3100.590000 24.98 INGRAM LIBRARY SERVICES 98211935 04/23/2017 BOOKS 010-40.3100.640000 122.06 INGRAM LIBRARY SERVICES 98245630 04/25/2017 BOOKS 010-40.3100.590000 1.19 INGRAM LIBRARY SERVICES 98245630 04/25/2017 BOOKS 010-40.3100.640000 9.77 INGRAM LIBRARY SERVICES 98245633 04/25/2017 BOOKS 010-40.3100.590000 5.42 INGRAM LIBRARY SERVICES 98245631 04/25/2017 BOOKS 010-40.3100.640000 41.82 INGRAM LIBRARY SERVICES 98245632 04/25/2017 BOOKS 010-40.3100.590000 5.86 INGRAM LIBRARY SERVICES 98245632 04/25/2017 BOOKS 010-40.3100.640000 31.84 INGRAM LIBRARY SERVICES 98245633 04/25/2017 BOOKS 010-40.3100.590000 0.54 INGRAM LIBRARY SERVICES 98245633 04/25/2017 BOOKS 010-40.3100.640000 41.94 INGRAM LIBRARY SERVICES 98245634 04/25/2017 BOOKS 010-40.3100.590000 1.39 INGRAM LIBRARY SERVICES 98245634 04/25/2017 BOOKS 010-40.3100.640000 10.34 INGRAM LIBRARY SERVICES 98245635 04/25/2017 BOOKS 010-40.3100.590000 1.19 INGRAM LIBRARY SERVICES 98245635 04/25/2017 BOOKS 010-40.3100.640000 16.67 INGRAM LIBRARY SERVICES 98245636 04/25/2017 BOOKS 010-40.3100.590000 5.89 INGRAM LIBRARY SERVICES 98245636 04/25/2017 BOOKS 010-40.3100.640000 34.78 INGRAM LIBRARY SERVICES 98245637 04/25/2017 BOOKS 010-40.3100.590000 1.55 INGRAM LIBRARY SERVICES 98245637 04/25/2017 BOOKS 010-40.3100.640000 44.98 INGRAM LIBRARY SERVICES 98245638 04/25/2017 BOOKS 010-40.3100.590000 1.95 INGRAM LIBRARY SERVICES 98245638 04/25/2017 BOOKS 010-40.3100.640000 32.16 INGRAM LIBRARY SERVICES 98245639 04/25/2017 BOOKS 010-40.3100.590000 0.54 INGRAM LIBRARY SERVICES 98245639 04/25/2017 BOOKS 010-40.3100.640000 3.59 INGRAM LIBRARY SERVICES 98245640 04/25/2017 BOOKS O10-40,3100.640000 9.77 INGRAM LIBRARY SERVICES 98264188 04/26/2017 BOOKS 010-40.3100.590000 4.76 INGRAM LIBRARY SERVICES 98264188 04/26/2017 BOOKS 010-40.3100.640000 40.22 INGRAM LIBRARY SERVICES 98264189 04/26/2017 BOOKS 010-40.3100.590000 4.99 INGRAM LIBRARY SERVICES 98264189 04/26/2017 BOOKS 010-40.3100.640000 22.00 INGRAM LIBRARY SERVICES 98264190 04/26/2017 BOOKS 010-40.3100.640000 9.19 INGRAM LIBRARY SERVICES 98264191 04/26/2017 BOOKS 010-40.3100.590000 1.19 INGRAM LIBRARY SERVICES 98264191 04/26/2017 BOOKS 010-40.3100.640000 5.74 INGRAM LIBRARY SERVICES 98264192 04/26/2017 BOOKS 010-40.3100.590000 52.99 5/10/2017 1:59:35 PM Page 6 of 20 Expense Approval Register Packet: APPKT00593 - MAY 16TH COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount INGRAM LIBRARY SERVICES 98264192 04/26/2017 BOOKS 010-40.3100.640000 203.21 CITY OF WAUKEE APR17310 04/30/2017 APRIL'17 STATEMENT 010-40.3100.480000 375.65 AMERITAS LIFE INSURANCE INV0002838 05/01/2017 MAY'17 VISION INSURANCE 010-40.3100.100000 126.96 SCHOOL LIBRARY JOURNAL INV0002904 05/16/2017 SUBSCRIPTION 010-40.3100.280000 54.99 ENTERTAINMENT INV0002905 05/16/2017 SUBSCRIPTION 010-40.3100.640000 20.00 CONSOLIDATED COMMUNIC INV0002908 05/08/2017 MAY'17 STATEMENT 010-40.3100.450000 49.25 CONSOLIDATED COMMUNIC INV0002908 05/08/2017 MAY'17 STATEMENT 010-40.3100.450000 157.85 ONESOURCE PLUS4380-20170430 04/30/2017 BACKGROUND CHECKS 010-40.3100.470000 72.35 FORMAN FORD R14303 04/26/2017 REPAIR HANDICAP DOOR 010-40.3100.400000 349.00 Department 3300 - LIBRARY SERVICES Total: 9,379.00 Department: 4100 - PARKS DOG WASTE DEPOT 152952 04/21/2017 DOG WASTE ROLL BAGS 010-40.4100.590000 117.00 RJ LAWN SERVICE INC 19062 04/24/2017 SPRING CLEANUP - TRAILHE 010-40.4100.410300 803.22 RJ LAWN SERVICE INC 19064 04/24/2017 SPRING CLEANUP - CENTENN 010-40,4100.410300 291.25 RI LAWN SERVICE INC 19353 05/08/2017 WEED CONTROL -SOUTHFO 010-40.4100.590100 241.00 RI LAWN SERVICE INC 19361 05/08/2017 WEED CONTROL - RIDGEPOI 010-40.4100.590100 1,610.00 ALLEY AUTO SALES 20 05/O1/2017 TUBES 010-40.4100.410100 45.00 PLUMB SUPPLY COMPANY 4494581 04/18/2017 RETRO KIT 010-40.4100.410300 298.77 MID AMERICAN ENERGY 520160417 04/18/2017 APRIL'17 STATEMENT 010-40.4100.480000 2,173.70 JIMSIOHNS 58314 04/25/2017 PORTABLE UNITS 010-40.4100.480000 69.90 MUTUAL OF OMAHA 631098347 05/O1/2017 MAY'17 LIFE & DISABILITY P 010-40.4100.100000 2.60 MUTUAL OF OMAHA 631098347 05/O1/2017 MAY'17 LIFE & DISABILITY P 010-40.4100.100000 2.60 MUTUAL OF OMAHA 631098347 05/O1/2017 MAY'17 LIFE & DISABILITY P 010-40.4100.100000 0.52 MUTUAL OF OMAHA 631098347 05/O1/2017 MAY'17 LIFE & DISABILITY P 010-40.4100.100100 27.72 MUTUAL OF OMAHA 631098347 05/01/2017 MAY'17 LIFE & DISABILITY P 010-40.4100.100100 10.80 MUTUAL OF OMAHA 631098347 05/O1/2017 MAY'17 LIFE & DISABILITY P 010-40.4100.100100 1.81 CITY OF WAUKEE APR17410 04/30/2017 APRIL'17 STATEMENT 010-40.4100.480000 311.98 CITY OF WAUKEE APR17410 04/30/2017 APRIL'17 STATEMENT 010-40.4100.480100 682.10 MID AMERICAN ENERGY APR174100SUMBILL 04/25/2017 APRIL'17 STATEMENT 010-40.4100.480000 194.67 BARCO PRODUCTS COMPAN BP00056695 04/28/2017 PET WASTE STATION 010-40.4100.540000 854.79 AMERITAS LIFE INSURANCE INV0002838 05/O1/2017 MAY'17 VISION INSURANCE 010-40A100.300000 10.68 AMERITAS LIFE INSURANCE INV0002838 05/O1/2017 MAY'17 VISION INSURANCE 010-40A100.100000 2.14 AMERITAS LIFE INSURANCE INV0002838 05/O1/2017 MAY'17 VISION INSURANCE 010-40A100.100000 27.24 WAUKEE HARDWARE & VARI INV0002849 04/30/2017 APRIL'17 STATEMENT- P & 010-40.4100.410300 354.73 HEARTLAND CO-OP INV0002856 04/30/2017 APRIL'17 STATEMENT- GOL 010-40A100.570000 1,517.25 CONSOLIDATED COMMUNIC INV0002908 05/08/2017 MAY'17 STATEMENT 010-40.4100.450000 14.65 Department 4100 - PARKS Total: 9,666.12 Department: 4200 - RECREATION KIDS IN HARMONY, LLC 0001574 04/21/2017 APRIL CLASSES 010-40.4200.460500 224.00 FAREWAY STORES, INC. 00295132 05/05/2017 MAY SENIOR SOCIAL SUPPLI 010-40.4200.460500 63.80 TJ PARTY RENTALS LLC 1202799 01/11/2017 INFLATABLE DEPOSIT 010-40.4200.460800 1,000.00 STUDIO BEA DANCE 1829 04/29/2017 APRIL'17 SESSION 010-40.4200.460500 160.00 METHODIST OCCUPATIONAL 223367 04/28/2017 PRE -EMPLOYMENT SCREENS 010-40.4200.470000 192.00 FASTSIGNS 42-92977 04/07/2017 COY BANNER 010-40.4200.460800 54.00 FASTSIGNS 42-93261 05/02/2017 JULY 4TH PATCHES 010-40.4200.460800 34.42 MUTUAL OF OMAHA 631098347 05/01/2017 MAY'17 LIFE & DISABILITY P 010-40.4200.100000 51.50 MUTUALOF OMAHA 631098347 05/01/2017 MAY'17 LIFE & DISABILITY P 010-40.4200.100100 63.00 AMERITAS LIFE INSURANCE INV0002838 05/01/2017 MAY'17 VISION INSURANCE 010-40.4200.100000 65.16 HEARTLAND CO-OP INV0002855 04/30/2017 APRIL'17 STATEMENT- REC 010-40.4200.570000 78.19 VILLAGES OF VAN BUREN IN INV0002870 04/25/2017 VAN BUREN TRIP DEPOSIT 010-40.4200.460500 570.00 PHIL DICKEY INV0002872 05/02/2017 TKD NINJAS SESSION H5 APRI 010-40.4200.460500 1,540.00 ARROW STAGE LINES P/719059 05/01/2017 VAN BUREN CO. TRIP 010-40.4200.460500 800.00 Department 4200 - RECREATION Total: 4,896.07 Department: 4300 - COMMUNITY CENTER RI LAWN SERVICE INC 19218 05/O1/2017 SPRING CLEANUP -COMMC 010-40.4300.410300 751.75 NATIONWIDE OFFICE CLEAN 61413 05/04/2017 WINDOW CLEANING -COM 010-40.4300.400100 126.00 CITY OF WAUKEE APR17430 04/30/2017 APRIL'17 STATEMENT 010-40.4300.480000 52.71 Department 4300 - COMMUNITY CENTER Total: 930.46 5/10/2017 1:59:35 PM Page 7 of 20 Expense Approval Register Packet: APPKT00593 - MAY 16TH COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount Department: 5000 - BIKE TRAIL OLD RAILROAD RDG PLANNING & DESIGN 42124 02/28/2017 RAILROAD PERGOLA 327-90.5000.881130 970.00 Department 5000 - BIKE TRAIL OLD RAILROAD Total: 970.00 Department: 5300 - STORM WATER LOGGED APPAREL&PROMO 15908 05/02/2017 BLOUSES - BAUMAN/RICHAR 560-80.5300.120000 28.06 LOGGED APPAREL&PROMO 15909 05/02/2017 POLOS/JACKET -J. CORKREA 560-80.5300.120000 273.88 MUTUAL OF OMAHA 631098347 05/O1/2017 MAY'17 LIFE & DISABILITY P 560-80.5300.100000 56.30 MUTUAL OF OMAHA 631098347 05/O1/2017 MAY'17 LIFE & DISABILITY P 560-80.5300.100000 1.30 MUTUALOFOMAHA 631098347 05/O1/2017 MAY'17 LIFE & DISABILITY P 560-80.5300.100100 3.97 MUTUALOF OMAHA 631098347 05/O1/2017 MAY'17 LIFE & DISABILITY P 560-80.5300.100100 72.67 HD SUPPLY WATERWORKS H016805 04/19/2017 24"NYLO 9/24"NYLO7 560-80.5300.410300 3,949.30 AMERITAS LIFE INSURANCE INV0002838 05/O1/2017 MAY'17 VISION INSURANCE 560-80.5300.100000 47.84 AMERITAS LIFE INSURANCE INV0002838 05/01/2017 MAY'17 VISION INSURANCE 560-80.5300.100000 7.82 PETTY CASH - PW/PARKS INV0002841 05/16/2017 PETTY CASH RECEIPTS 560-80.5300.360000 7.99 MIKE KIESZKOWSKI INV0002844 05/16/2017 RAIN BARREL REBATE 560-80.5300.685400 50.00 HEARTLAND CO-OP INV0002853 04/30/2017 APRIL'17 STATEMENT -STO 560-80.5300.570000 142.51 ONE SOURCE PLUS4390-20170430 04/30/2017 BACKGROUND CHECKS 560-80.5300.470000 35.00 Department 5300 - STORM WATER Total: 4,676.64 Department: 5400-SOLID WASTE COLLECTION & DISPOSAL ANKENY SANITATION INC. 389099 05/O1/2017 MAY'17 STATEMENT 590-30.5400.231300 86,187.75 UNIVERSAL PRINTING SERVI 47960 03/30/2017 CITY WIDE CLEAN UP INSERT 590-30.5400.245500 676.60 Department 5400 - SOLID WASTE COLLECTION & DISPOSAL Total: 86,864.35 Department: 6000 - PUBLIC WORKS CLASSIC FLORAL &GIFTS 125390 04/12/2017 FLOWERS -WINTERS 010-20.6000.590000 65.00 BRELSFORD PROPERTIES LLC 1408 04/10/2017 WASH CARD 010-20.6000.590000 10.00 LOGGED APPAREL & PROMO 15890 04/24/2017 SHIRTS - L.BAUMAN 010-20.6000.120000 93.74 LOGGED APPAREL &PROMO 15908 05/02/2017 BLOUSES - BAUMAN/RICHAR 010-20.6000.120000 28.06 LOGGED APPAREL&PROMO 15908 05/02/2017 BLOUSES - BAUMAN/RICHAR 010-20.6000.120000 34.05 CHRISTIAN PRINTERS INC 37015 04/27/2017 BUSINESS CARDS -ROYER 010-20.6000.580000 31.00 MUTUAL OF OMAHA 631098347 05/01/2017 MAY'17 LIFE & DISABILITY P 010-20.6000.100000 181.00 MUTUALOF OMAHA 631098347 05/O1/2017 MAY'17 LIFE & DISABILITY P 010-20.6000.100100 106.60 AMERITAS LIFE INSURANCE INV0002838 05/01/2017 MAY'17 VISION INSURANCE 010-20.6000.100000 102.32 PETTY CASH -PW/PARKS INV0002841 05/16/2017 PETTY CASH RECEIPTS 010-20.6000.470000 6.24 HEARTLAND CO-OP INV0002857 04/30/2017 APRIL'17 STATEMENT- PW 010-20.6000.570000 122.60 HEARTLAND CO-OP INV0002857 04/30/2017 APRIL'17 STATEMENT-PW 010-20.6000.590000 512.50 DALLAS COUNTY NEWS -SU INV0002873 05/16/2017 SUBSCRIPTION -PW 010-20.6000.280000 46.00 Department 6000 - PUBLIC WORKS Total: 1,339.11 Department: 6010 - PUBLIC WORKS BUILDING HOTSY CLEANING SYSTEMS, I 0172691-IN 04/25/2017 COIL GAS I8"/ZONE AJIM/IN 010-20.6010.410100 1,695.72 ZIMCO SUPPLY CO 107457 04/20/2017 CHEMICALS 010-20.6010.400000 1,480.00 ORKIN PEST CONTROL 155945150 05/15/2017 PEST CONTROL -PW 010-20.6010.400000 84.99 FIRST CHOICE COFFEE SERVI 301782 04/27/2017 COFFEE 010-20.6010.580000 33.49 MMIT BUSINESS SOLUTIONS 307946 04/26/2017 KIP-3000 010-20.6010.580000 278.30 WES JARNAGIN, INC. 40187 04/28/2017 SANDBLAST/PRIME/PAINT 010-20.6010.400000 7,150.00 HILLYARD INC 602516306 04/28/2017 TOILET PAPER/LINERS 010-20.6010.590000 195.86 SHERWIN WILLIAMS CO 6083-2 04/18/2017 PAINT 010-20.6010.400000 115.87 NATIONWIDE OFFICE CLEAN 61213 04/25/2017 INSIDE & OUTSIDE WINDOW 010-20.6010.400100 399.00 CONTROL INSTALLATIONS O 63885 04/27/2017 REPAIR BADGE PRINTER 010-20.6010.400000 444.68 MENARDS 78153 04/25/2017 TRASH CAN 010-20.6010,400000 179.82 SHERWIN WILLIAMS CO 8777-7 04/18/2017 PAINT/TRAYS/ANGLE SASH 010-20.6010.400000 118.36 SHERWIN WILLIAMS CO 8877-5 04/20/2017 PLASTIC TRAY LINERS 010-20.6010.400000 34.79 SHERWIN WILLIAMS CO 8920-3 04/21/2017 XYLENE-GAL-SW 010-20.6010.400000 39.34 CINTAS CORPORATION 9013568379 04/06/2017 BANDAGES/DISINFECTANT 010-20.6010.400000 152.78 OFFICE DEPOT 922378052001 04/21/2017 SURGE PROTECTOR STRIPS/ 010-20.6010.580000 182.75 SHERWIN WILLIAMS CO 9607-6 04/18/2017 FRAME/FOAM BRUSH/MASK 010-20.6010.400000 19.34 CITY OF WAUKEE APR17601 04/30/2017 APRIL'17 STATEMENT 010-20.6010.480000 696.37 FASTENALCOMPANY IAGRM86932 04/21/2017 GLOVES/EYEWEAR/EAR PLU 010-20.6010.590000 244.47 PETTY CASH -PW/PARKS INV0002841 05/16/2017 PETTY CASH RECEIPTS 010-20.6010.400000 1.16 PETTY CASH - PW/PARKS INV0002841 05/16/2017 PETTY CASH RECEIPTS 010-20.6010.580000 15.87 5/10/2017 1:59:35 PM Page 8 of 20 Expense Approval Register Packet: APPKT00593 - MAY 16TH COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount PETTY CASH -PW/PARKS INV0002841 05/16/2017 PETTY CASH RECEIPTS 010-20.6010.580000 52.98 PETTY CASH -PW/PARKS INV0002841 05/16/2017 PETTY CASH RECEIPTS 010-20.6010.580000 35.99 PETTY CASH - PW/PARKS INVO002841 05/16/2017 PETTY CASH RECEIPTS 010-20.6010.590000 10.59 WAUKEE HARDWARE & VARI INV0002850 04/30/2017 APRIL'17 STATEMENT- PW 010-20.6010.590000 40.81 HEARTLAND CO-OP INV0002857 04/30/2017 APRIL'17 STATEMENT-PW 010-20.6010.590000 10.25 CONSOLIDATED COMMUNIC INV0002908 05/08/2017 MAY'17 STATEMENT 010-20.6010.450000 142.25 CONSOLIDATED COMMUNIC INV0002908 05/08/2017 MAY'17 STATEMENT 010-20.6010.450000 443.23 FASTENAL COMPANY MN019132137 04/21/2017 FAST PROGRAM FEE 010-20.6010.590000 300.00 VAN METER INDUSTRIAL INC 59730314.001 04/10/2017 LOW -TEMP SENSOR 010-20.6010.400000 365.37 Department 6010 - PUBLIC WORKS BUILDING Total: 14,964.43 Department: 6150 - PUBLIC WORKS MECHANIC MARK STUCHEL INC. 04281747625 04/28/2017 3PC TRIM PAD TOOL SET/SC 010-20.6150.590000 251.99 HAWKEYE TRUCK EQUIPMEN 125916 04/13/2017 HEILEMBLEM 010-20.6150.570130 57.78 MIKES ADEL POWER EQUIP 16232 04/28/2017 FILTER-FUEL/FUEL LINE 010-20.6150.570130 6.49 INTERSTATE ALL BATTERY CE 1924601033052 04/17/2017 COMMERCIAL BATTERY 010-20.6150.570130 188.20 INTERSTATE ALL BATTERY CE 1924601033263 04/28/2017 BATTERIES 010-20.6150.570130 261.35 INTERSTATE ALL BATTERY CE 1924601033263 04/28/2017 BATTERIES 010-20.6150.590000 91.80 ARNOLD MOTOR SUPPLY 21-711362 04/06/2017 RETURN 5G NORSOLV 010-20.6150.590000 -149.97 ARNOLD MOTOR SUPPLY 21-711405 04/07/2017 HAND PADS 010-20.6150.590000 40.85 ARNOLD MOTOR SUPPLY 21-712570 04/25/2017 SPRAY 010-20.6150.590000 5.52 ARNOLD MOTOR SUPPLY 21-712600 04/25/2017 SPRAY 010-20.6150.590000 33.12 ARNOLD MOTOR SUPPLY 21-712973 05/01/2017 25 DISCS/BOX 010-20.6150.590000 41.25 ARNOLD MOTOR SUPPLY 21-712975 05/01/2017 ROLOC DISC 010-20.6150.590000 26.69 ARNOLD MOTOR SUPPLY 21-713003 05/02/2017 ROLOC DISC 010-20.6150.590000 26.69 ARNOLD MOTOR SUPPLY 21-713004 05/02/2017 25 DISCS/BOX 010-20.6150.590000 82.50 TRUCK EQUIPMENT INC 280890 02/27/2017 LUVERNE XX BAR GRIP BOAR 010-20.6150.570130 404.20 MID-IOWA SOLID WASTE EQ 43806 04/10/2017 VAC -CON PARTS 010-20.6150.570130 512.40 MATHESON TRI-GAS INC 51170543 04/30/2017 CYLINDERS 010-20.6150.590000 109.80 MUTUAL OF OMAHA 631098347 05/O1/2017 MAY'17 LIFE & DISABILITY P 010-20.6150.100000 5.20 MUTUAL OF OMAHA 631098347 05/O1/2017 MAY'17 LIFE & DISABILITY P 010-20.6150.100100 72.81 STIVERS FORD 847663 04/25/2017 LATCH 010-20.6150.570130 109.81 STIVERS FORD 847798 05/01/2017 SWITCH 010-20.6150.570130 35.51 LAWSON PRODUCTS INC 9304967139 04/14/2017 FUSION WRAP/DRILL BITS/P 010-20.6150.570130 40.70 LAWSON PRODUCTS INC 9304967139 04/14/2017 FUSION WRAP/DRILL BITS/P 010-20.6150.590000 312.06 AMERITAS LIFE INSURANCE INV0002838 05/O1/2017 MAY'17 VISION INSURANCE 010-20.6150.100000 37.92 PETTY CASH -PW/PARKS INV0002841 05/16/2017 PETTY CASH RECEIPTS 010-20.6150.570130 14.78 PETTY CASH -PW/PARKS INV0002841 05/16/2017 PETTY CASH RECEIPTS 010-20.6150.590000 4.23 WAUKEE HARDWARE &VAR[ INV0002850 04/30/2017 APRIL'17 STATEMENT-PW 010-20.6150.590000 31.82 HEARTLAND CO-OP INV0002858 04/30/2017 APRIL'17 STATEMENT- MEC 010-20.6150.570000 146.45 Department 6150 - PUBLIC WORKS MECHANIC Total: 2,801.95 Department: 6510 - WATER UTILITY FAREWAY STORES, INC. 00238064 05/05/2017 WATER/DIP 510-30.6510.470000 9.93 STANLEY CONSULTANTS INC. 0195522 05/01/2017 WATER TOWER RENO - ANTE 510-30.6510.881200 140.54 METHODIST OCCUPATIONAL 223367 04/28/2017 PRE -EMPLOYMENT SCREENS 510-30.6510.470000 71.00 ABL LABORATORIES 2430 04/11/2017 CALIBRATION TEST GAUGE 510-30.6510.410100 94.00 BANKERS TRUST COMPANY 38264 05/16/2017 12C FEES 510-30.6510.930100 250.00 BANKERS TRUST COMPANY 38265 05/16/2017 15B-FEES 510-30.6510.930100 250.00 MID-IOWA SOLID WASTE EQ 43905 04/21/2017 REPAIRS TO VAC -CON 510-30.6510.410000 435.91 MUTUALOF OMAHA 631098347 05/O1/2017 MAY'17 LIFE & DISABILITY P 510-30.6510.100000 19.40 MUTUALOF OMAHA 631098347 05/01/2017 MAY'17 LIFE & DISABILITY P 510-30.6510.100000 25.20 MUTUALOF OMAHA 631098347 05/O1/2017 MAY'17 LIFE & DISABILITY P 510-30.6510.100000 2.60 MUTUALOFOMAHA 631098347 05/O1/2017 MAY'17 LIFE & DISABILITY P 510-30.6510.100000 1.30 MUTUALOF OMAHA 631098347 05/O1/2017 MAY'17 LIFE & DISABILITY P 510-30.6510.100100 48.73 MUTUAL OF OMAHA 631098347 05/01/2017 MAY'17 LIFE & DISABILITY P 510-30.6510.100100 3.86 MUTUAL OF OMAHA 631098347 05/O1/2017 MAY'17 LIFE & DISABILITY P 510-30.6510.100100 58.24 MUTUAL OF OMAHA 631098347 05/01/2017 MAY'17 LIFE & DISABILITY P 510-30.6510,100100 45.84 MID AMERICAN ENERGY APR176510SUMBILL 04/25/2017 APRIL'17 STATEMENT 510-30.6510.480000 600.62 CITY OF WAUKEE APR17651 04/30/2017 APRIL'17 STATEMENT 510-30.6510.480000 223.06 AMERITAS LIFE INSURANCE INV0002838 05/O1/2017 MAY'17 VISION INSURANCE 510-30.6510.100000 7.82 AMERITAS LIFE INSURANCE INV0002838 05/O1/2017 MAY'17 VISION INSURANCE 510-30.6510.100000 13.62 5/10/2017 1:59:35 PM Page 9 of 20 Expense Approval Register Packet: APPKT00593 - MAY 16TH COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount AMERITAS LIFE INSURANCE INV0002838 05/01/2017 MAY'17 VISION INSURANCE 510-30.6510.100000 20.60 AMERITAS LIFE INSURANCE INV0002838 05/O1/2017 MAY'17 VISION INSURANCE 510-30.6510.100000 34.60 PETTY CASH -PW/PARKS INV0002841 05/16/2017 PETTY CASH RECEIPTS 510-30.6510.470000 24.46 IOWA DEPT OF NATURAL RE INV0002842 04/24/2017 DRINKING WATER OPERATO 510-30.6510.470000 20.00 WAUKEE HARDWARE&VARI INV0002850 04/30/2017 APRIL'17 STATEMENT -PW 510-30.6510.590000 13.56 HEARTLAND CO-OP INV0002862 04/30/2017 APRIL'17 STATEMENT -WAT 510-30.6510.570000 488.88 DES MOINES WATER WORKS INV0002874 04/26/2017 APRIL'17 STATEMENT 510-30.6510.650000 6,302.52 DES MOINES WATER WORKS INV0002875 04/26/2017 APRIL'17 STATEMENT 510-30.6510.650000 59,959.16 BANKERS TRUST COMPANY INV0002899 04/11/2017 12C-PRIN/INT 510-30.6510.921260 34,497.50 BANKERS TRUST COMPANY INV0002900 04/11/2017 15B-PRIN/INT 510-30.6510.921270 20,100.00 LOGAN CONTRACTORS SUPP M00762 05/O1/2017 SGALGASCAN 510-30.6510.590000 150.78 ONE SOURCE PLUS4380-20170430 04/30/2017 BACKGROUND CHECKS 510-30.6510.470000 45.50 IOWA ASSOCIATION OF MU YM200003892 02/21/2017 ADVANCE H2O WORKSHOPS 510-30.6510.470000 85.00 Department 6510 - WATER UTILITY Total: 123,944.23 Department: 6520 - SANITARY SEWERS & TREATMENT EVER GREENE SODDING & L 14001 04/28/2017 GOLF COURSE SOD 520-30.6520.883091 66,457.50 TEAM SERVICES INC 1789240-0 04/11/2017 CONSTRUCTION TESTING FE 520-30.6520.883080 400.56 MIDWEST ENVIRONMENTAL 20170349 04/22/2017 WASTEWATER SAMPLE ANA 520-30.6520.250000 1,434.00 METHODIST OCCUPATIONAL 223367 04/28/2017 PRE -EMPLOYMENT SCREENS 520-30.6520.470000 71.00 BANKERS TRUST COMPANY 38235 05/16/2017 16C FEES 520-30.6520.930100 250.00 BANKERS TRUST COMPANY 38261 05/16/2017 13A FEES 520-30.6520.930100 250.00 MID-IOWA SOLID WASTE EO 43894 04/20/2017 SEWER CLEANING TOOLS 520-30.6520.590000 83.16 MID-IOWA SOLID WASTE EO 43905 04/21/2017 REPAIRS TO VAC -CON 520-30.6520.410000 435.91 MUTUAL OF OMAHA 631098347 05/01/2017 MAY'17 LIFE & DISABILITY P 520-30.6520.100000 5.20 MUTUAL OF OMAHA 631098347 05/O1/2017 MAY'17 LIFE & DISABILITY P 520-30.6520.100000 1.30 MUTUAL OF OMAHA 631098347 05/01/2017 MAY'17 LIFE & DISABILITY P 520-30.6520.100000 1.30 MUTUAL OF OMAHA 631098347 05/01/2017 MAY'17 LIFE & DISABILITY P 520-30.6520.100000 5.20 MUTUAL OF OMAHA 631098347 05/O1/2017 MAY'17 LIFE & DISABILITY P 520-30.6520.100100 71.62 MUTUAL OF OMAHA 631098347 05/O1/2017 MAY'17 LIFE & DISABILITY P 520-30.6520.100100 15.42 MUTUALOF OMAHA 631098347 05/O1/2017 MAY'17 LIFE & DISABILITY P 520-30.6520.100100 3.97 MUTUALOF OMAHA 631098347 05/01/2017 MAY'17 LIFE & DISABILITY P 520-30.6520.100100 3.86 MENARDS 77394 04/18/2017 SWIFFER DUSTER REFILLS/LO 520-30.6520.590000 98.47 MID AMERICAN ENERGY APR176520SUMBILL 04/25/2017 APRIL'17 STATEMENT 520-30.6520.480000 7,455.41 CITY OF WAUKEE APR17652 04/30/2017 APRIL'17 STATEMENT 520-30.6520.480000 1,381.72 AMERITAS LIFE INSURANCE INV0002838 05/O1/2017 MAY'17 VISION INSURANCE 520-30.6520.100000 13.62 AMERITAS LIFE INSURANCE INV0002838 05/O1/2017 MAY'17 VISION INSURANCE 520-30.6520.100000 7.82 AMERITAS LIFE INSURANCE INV0002838 05/01/2017 MAY'17 VISION INSURANCE 520-30.6520.100000 41.20 AMERITAS LIFE INSURANCE INV0002838 05/O1/2017 MAY'17 VISION INSURANCE 520-30.6520.100000 34.60 PETTY CASH -PW/PARKS INV0002841 05/16/2017 PETTY CASH RECEIPTS 520-30.6520.470000 5.98 PETTY CASH -PW/PARKS INV0002841 05/16/2017 PETTY CASH RECEIPTS 520-30.6520.470000 7.28 WAUKEE HARDWARE&VARI INV0002850 04/30/2017 APRIL'17 STATEMENT -PW 520-30.6520.590000 53.01 WAUKEE HARDWARE & VARI INV0002850 04/30/2017 APRIL'17 STATEMENT -PW 520-30.6520.590000 25.39 HEARTLAND CO-OP INV0002861 04/30/2017 APRIL'17 STATEMENT - SEW 520-30.6520.570000 336.68 IOWA FINANCE AUTHORITY INV0002883 05/01/2017 98A-PRIN/INT 520-30.6520.920800 560.00 IOWA FINANCE AUTHORITY INV0002883 05/01/2017 98A-PRIN/INT 520-30.6520.930100 32.00 IOWA FINANCE AUTHORITY INV0002884 05/O1/2017 98B-PRIN/INT 520-30.6520.920900 1,172.50 IOWA FINANCE AUTHORITY INV0002884 05/O1/2017 98B-PRIN/INT 520-30.6520.930100 67.00 IOWA FINANCE AUTHORITY INV0002885 05/O1/2017 98C-PRIN/INT 520-30.6520.921000 1,408.75 IOWA FINANCE AUTHORITY INV0002885 05/01/2017 98C-PRIN/INT 520-30.6520.930100 80.50 BANKERS TRUST COMPANY INV0002901 04/12/2017 16CINTEREST 520-30.6520.921110 36,250.18 BANKERS TRUST COMPANY INV0002902 04/11/2017 13A-PRIN/INT 520-30.6520.921100 9,371.88 CONSOLIDATED COMMUNIC INV0002908 05/08/2017 MAY'17 STATEMENT 520-30.6520.450000 145.20 ONE SOURCE PLUS4380-20170430 04/30/2017 BACKGROUND CHECKS 520-30.6520.470000 45.50 Department 6520 - SANITARY SEWERS & TREATMENT Total: 128,084.69 Department: 6540 - GAS UTILITY SENSIT TECHNOLOGIES 0239848-IN 04/17/2017 REPAIR SENSIT GOLD/CERTIF 540-30.6540.410200 186.52 REGAL UNDERGROUND CON 1049 04/26/2017 DIRECTIONAL BORE GAS 540-30.6540.880100 180.00 REGAL UNDERGROUND CON 1050 04/26/2017 DIRECTIONAL BORE GAS 540-30.6540.880100 360.00 REGAL UNDERGROUND CON 1051 04/26/2017 DIRECTIONAL BORE GAS 540-30.6540.880300 360.00 G&LCLOTHING 2-738875-02 02/07/2017 HOODIE - DODGE 540-30.6540.120000 260.50 5/10/2017 1:59:35. PM Page 10 of 20 Expense Approval Register Packet: APPKT00593 - MAY 16TH COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount BANKERS TRUST COMPANY 38263 05/16/2017 15A-FEES 540-30.6540.930100 250.00 ENERGY ECONOMICS 41242 04/27/2017 LM TC COUNTER/ROOTS ME 540-30.6540.592000 1,635.64 PLUMB SUPPLY COMPANY 4494875 04/19/2017 STEELTRAYS 540-30.6540.590000 50.00 UNIVERSAL PRINTING SERVI 48219 04/12/2017 GASBROCHURE 540-30,6540.350100 191.67 MUTUAL OF OMAHA 631098347 05/01/2017 MAY'17 LIFE & DISABILITY P 540-30.6540.100000 92.30 MUTUAL OF OMAHA 631098347 05/O1/2017 MAY'17 LIFE & DISABILITY P 540-30.6540.100000 1.30 MUTUAL OF OMAHA 631098347 05/01/2017 MAY'17 LIFE & DISABILITY P 540-30.6540.100000 1.30 MUTUAL OF OMAHA 631098347 05/01/2017 MAY'17 LIFE & DISABILITY P 540-30.6540.100100 3.86 MUTUALOF OMAHA 631098347 05/01/2017 MAY'17 LIFE & DISABILITY P 540-30.6540.100100 3.97 MUTUAL OF OMAHA 631098347 05/01/2017 MAY'17 LIFE & DISABILITY P 540-30.6540.100100 69.50 MENARDS 77526 04/19/2017 TOOL CHEST/28QT CLEAR 540-30.6540.590000 231.26 INDUSTRIALSALES COMPAN 976995-000 04/19/2017 ALCOHOL WIPES 540-30.6540.590000 46.46 CLAYTON ENERGY CORPORA 9909 05/O1/2017 APRIL 2017 RESERVATION N 540-30.6540.650000 11,108.85 MID AMERICAN ENERGY APR176540SUMBILL 04/25/2017 APRIL'17 STATEMENT 540-30.6540.480000 79.21 UTILITY SAFETY AND DESIGN IN20171321 04/28/2017 APRIL'17 RETAINER FEES 540-30.6540.230000 175.00 AMERITAS LIFE INSURANCE INV0002838 05/01/2017 MAY'17 VISION INSURANCE 540-30.6540.100000 7.82 AMERITAS LIFE INSURANCE INV0002838 05/O1/2017 MAY'17 VISION INSURANCE 540-30.6540.100000 13.62 AMERITAS LIFE INSURANCE INV0002838 05/01/2017 MAY'17 VISION INSURANCE 540-30.6540.100000 108.96 WAUKEE HARDWARE & VARI INV0002850 04/30/2017 APRIL'17 STATEMENT -PW 540-30.6540.590000 24.48 HEARTLAND CO-OP INV0002864 04/30/2017 APRIL'17 STATEMENT - GAS 540-30.6540.570000 484.28 BANKERS TRUST COMPANY INV0002903 04/11/2017 15A-PRIN/INT 540-30.6540.920010 31,023.00 CONSOLIDATED COMMUNIC INV0002908 05/08/2017 MAY'17 STATEMENT 540-30.6540,450000 72.60 ONE SOURCE PLUS4380-20170430 04/30/2017 BACKGROUND CHECKS 540-30.6540.470000 55.00 Department 6540 -GAS UTILITYTotal: 47,077.10 Department: 6550 - UTILITY BILLING MUTUAL OF OMAHA 631098347 05/O1/2017 MAY'17 LIFE & DISABILITY P 570-30.6550.100000 74.70 MUTUAL OF OMAHA 631098347 05/01/2017 MAY'17 LIFE & DISABILITY P 570-30.6550.100100 15.78 AMERITAS LIFE INSURANCE INV0002838 05/01/2017 MAY'17 VISION INSURANCE 570-30.6550.100000 37.92 LANDS END BUSINESS OUTFI SIN4903932 04/21/2017 SHIRTS-PARISH/OSTRING/EV 570-30.6550.120000 165.95 Department 6550 - UTILITY BILLING Total: 294.35 Department: 7100 - STREETS GRIMES ASPHALT&PAVING 12269 04/28/2017 COLD MIX 060-30.7100.590400 2,001.66 MARTIN MARIETTA AGGREG 20081769 04/17/2017 ROADSTONE 060-30.7100.590300 714.93 MARTIN MARIETTAAGGREG 20126121 04/20/2017 ROAD STONE 060-30.7100.590300 802.28 MARTIN MARIETTA AGGREG 20160892 04/24/2017 ROAD STONE 060-30.7100.590300 130.70 METHODIST OCCUPATIONAL 223367 04/28/2017 PRE -EMPLOYMENT SCREENS 060-30.7100.470000 192.00 DALE EDWARDS TRUCKING 1 2936 04/30/2017 HAULING 060-30.7100.590300 407.00 IOWASIGNALINC 3559 04/27/2017 INSTALLSTREET LIGHT 060-30.7100.410300 3,519.00 BAX SALES, INC 36198 04/21/2017 GOLD COWGRAIN FLEXHAN 060-30.7100.590000 59.40 DETROIT INDUSTRIAL TOOL 549227 04/21/2017 DIAMONDTEE 060-30.7100.590000 399.44 MUTUAL OF OMAHA 631098347 05/O1/2017 MAY'17 LIFE & DISABILITY P 060-30.7100.100000 7.30 MUTUALOF OMAHA 631098347 05/O1/2017 MAY'17 LIFE & DISABILITY P 060-30.7100.100000 47.80 MUTUAL OF OMAHA 631098347 05/O1/2017 MAY'17 LIFE & DISABILITY P 060-30.7100.100000 0.26 MUTUAL OF OMAHA 631098347 05/01/2017 MAY'17 LIFE & DISABILITY P 060-30.7100.100100 17.34 MUTUAL OF OMAHA 631098347 05/01/2017 MAY'17 LIFE & DISABILITY P 060-30.7100.100100 0.90 MUTUAL OF OMAHA 631098347 05/O1/2017 MAY'17 LIFE & DISABILITY P 060-30.7100.100100 118.37 LIBERTY READY MIX 84765 04/17/2017 CONCRETE 060-30.7100.590400 1,359.88 LIBERTY READY MIX 84827 04/18/2017 CONCRETE 060-30.7100.590400 2,277.00 LIBERTY READY MIX 84866 04/19/2017 CONCRETE 060-30.7100.590400 1,201.75 LIBERTY READY MIX 84958 04/20/2017 CONCRETE 060-30.7100.590400 1,676.13 LIBERTY READY MIX 85041 04/21/2017 CONCRETE 060-30.7100.590400 429.50 IOWA PRISON INDUSTRIES 943634 04/19/2017 STREET SIGNS 060-30.7100.590600 835.80 AMERITAS LIFE INSURANCE INV0002838 05/01/2017 MAY'17 VISION INSURANCE 060-30.7100.100000 1.07 AMERITAS LIFE INSURANCE INV0002838 05/01/2017 MAY'17 VISION INSURANCE 060-30.7100.100000 13.62 AMERITAS LIFE INSURANCE INV0002838 05/O1/2017 MAY'17 VISION INSURANCE 060-30.7100.100000 92.40 WAUKEE HARDWARE & VARI INV0002850 04/30/2017 APRIL'17 STATEMENT -PW 060-30.7100.590000 34.52 HEARTLAND CO-OP INV0002860 04/30/2017 APRIL'17 STATEMENT -STRE 060-30.7100.570000 682.46 ONE SOURCE PLUS4380-20170430 04/30/2017 BACKGROUND CHECKS 060-30,7100.470000 37.65 Department 7100 - STREETS Total: 17,060.16 5/10/2017 1:59:35 PM Page 11 of 20 Expense Approval Register Packet: APPKT00593. MAY 16TH COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount Department: 7730-SE WESTOWN PKWY CONSTRUCTION TEAM SERVICES INC 1789238-0 04/11/2017 CONSTRUCTION TESTING SE 327-90.7730.235000 834.46 FASTSIGNS 42-92676 03/31/2017 PROJECT SIGNS 327-90.7730.230000 445.00 FOTH INFRASTRUCTURE & E 52117 04/21/2017 WESTOWN PKWY-SE PARKV 327-90.7730.230000 7,074.00 Department 7730 -SE WESTOWN PKWY CONSTRUCTION Total: 8,353.46 Department: 7740-DOUGLAS PARKWAY FOTH INFRASTRUCTURE & E 52116 04/21/2017 DOUGLAS PKWY WEST OF AL 327-90.7740.230000 158.00 Department 7740 - DOUGLAS PARKWAY Total: 158.00 Department: 7800 - GO DEBT SERVICE BANKERS TRUST COMPANY 38250 05/16/2017 12A FEES 110-30.7800.930100 250.00 BANKERS TRUST COMPANY 38251 05/16/2017 10A FEES 110-30.7800.930100 250.00 BANKERS TRUST COMPANY 38252 05/16/2017 10B FEES 110-30.7800.930100 250.00 BANKERS TRUST COMPANY 38253 05/16/2017 09A FEES 110-30.7800.930100 250.00 BANKERS TRUST COMPANY 38254 05/16/2017 15C-FEES 110-30.7800.930100 250.00 BANKERS TRUST COMPANY 38255 05/16/2017 13B FEES 110-30.7800.930100 250.00 BANKERS TRUST COMPANY 38256 05/16/2017 12B FEES 110-30.7800.930100 250.00 BANKERS TRUST COMPANY INV0002886 04/12/2017 16B-PRIN/INT 110-30.7800.914622 280,000.00 BANKERS TRUST COMPANY INV0002886 04/12/2017 16B-PRIN/INT 110-30.7800.924622 12,462.86 BANKERS TRUST COMPANY INV0002887 04/11/2017 15C PRIN/INT 110-30.7800.914621 1,010,000.00 BANKERS TRUST COMPANY INV0002887 04/11/2017 15C PRIN/INT 110-30.7800.924621 96,375.00 BANKERS TRUST COMPANY INV0002891 04/11/2017 13B-PRIN/INT 110-30.7800.914620 330,000.00 BANKERS TRUST COMPANY INV0002891 04/11/2017 13B-PRIN/INT 110-30.7800.924620 26,237.50 BANKERS TRUST COMPANY INV0002893 04/11/2017 12B-PRIN/INT 110-30,7800.914610 630,000.00 BANKERS TRUST COMPANY INV0002893 04/11/2017 12B-PRIN/INT 110-30.7800.924610 38,425.00 BANKERS TRUST COMPANY INV0002894 04/11/2017 12A PRIN/INT 110-30.7800.914600 450,000.00 BANKERS TRUST COMPANY INV0002894 04/11/2017 12A PRIN/INT 110-30.7800.924600 8,550.00 BANKERS TRUST COMPANY INV0002896 04/11/2017 10B-PRIN/INT 110-30.7800.914570 160,000.00 BANKERS TRUST COMPANY INV0002896 04/11/2017 10B-PRIN/INT 110-30.7800.924570 13,825.00 BANKERS TRUST COMPANY INV0002897 04/11/2017 10A-PRIN/INT 110-30.7800.914560 120,000.00 BANKERS TRUST COMPANY INV0002897 04/11/2017 30A-PRIN/INT 110-30.7800.924560 12,468.76 BANKERS TRUST COMPANY INV0002898 04/11/2017 09A-PRIN/INT 110-30.7800.914540 130,000.00 BANKERS TRUST COMPANY INV0002898 04/11/2017 09A-PRIN/INT 110-30.7800,924540 2,275.00 Department 7800 - GO DEBT SERVICE Total: 3,322,369.12 Department: 7850 - TIF DEBT SERVICE BANKERS TRUST COMPANY 38234 05/16/2017 16B-FEES 110-30.7850.930100 250.00 BANKERS TRUST COMPANY 38257 05/16/2017 14A-FEES 110-30.7850.930100 250.00 BANKERS TRUST COMPANY 38258 05/16/2017 13D FEES 110-30.7850.930100 250.00 BANKERS TRUST COMPANY 38259 05/16/2017 13C FEES 110-30.7850.930100 250.00 BANKERS TRUST COMPANY 38260 05/16/2017 12D FEES 110-30.7850.930100 250.00 BANKERS TRUST COMPANY 38262 05/16/2017 10C FEES 110-30.7850.930100 250.00 AHLERS & COONEY PC 728139 04/25/2017 ASHWORTH PROPERTIES DE 094-30.7850.230000 4,674.00 BANKERS TRUST COMPANY INV0002888 04/11/2017 14A-PRIN/INT 110-30.7850.918420 500,000.00 BANKERS TRUST COMPANY INV0002888 04/11/2017 14A-PRIN/INT 110-30.7850.928420 288,598.13 BANKERS TRUST COMPANY INV0002889 05/01/2017 13D-PRIN/INT 110-30.7850.918410 850,000.00 BANKERS TRUST COMPANY INV0002889 05/O1/2017 13D-PAIN/INT 110-30.7850.928410 125,540.63 BANKERS TRUST COMPANY INV0002890 04/11/2017 13C-PRIN/INT 110-30.7850.918400 485,000.00 BANKERS TRUST COMPANY INV0002890 04/11/2017 13C-PRIN/INT 110-30,7850.928400 7,308.75 BANKERS TRUST COMPANY INV0002892 04/11/2017 12D-PRIN/INT 110-30.7850.918390 415,000.00 BANKERS TRUST COMPANY INV0002892 04/11/2017 12D-PRIN/INT 110-30.7850.928390 21,400.00 BANKERS TRUST COMPANY INV0002895 04/11/2017 10C-PRIN/INT 110-30.7850.918380 145,000.00 BANKERS TRUST COMPANY INV0002895 04/11/2017 10C-PRIN/INT 110-30.7850.928380 14,477.50 Department 7850 - TIF DEBT SERVICE Total: 2,858,499.01 Department: 7900 - SPECIAL ASSESSMENT DEBT SERVICE KESTRELINC INV0002878 05/16/2017 09C SPECIAL ASSESS - INTERE 111-30.7900.929010 1,959.50 Department 7900 - SPECIAL ASSESSMENT DEBT SERVICE Total: 1,959.50 Department: 8030 - DEVELOPER REIMBURSEMENT PROJECTS FOTH INFRASTRUCTURE & E 52108 04/21/2017 SE ALICE'S RD/SE UNIVERSIT 327-90.8030.230000 43,696.80 Department 8030 - DEVELOPER REIMBURSEMENT PROJECTS Total: 43,696.80 5/10/2017 1:59:35 PM Page 12 of 20 Expense Approval Register Packet: APPKT00593 - MAY 16TH COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount Department: 8100 - MAYOR & COUNCIL CLASSIC FLORAL &GIFTS 631085 04/24/2017 FLOWERS -BATES 010-60.8100.580000 65.00 Department 8100 - MAYOR & COUNCILTotal: 65.00 Department: 8200 - COMMUNICATIONS BUSINESS PUBLICATIONS 47156 04/28/2017 LAND IN WAUKEE PRINTAD 010-60.8200.210000 1,817.00 MUTUALOF OMAHA 631098347 05/O1/2017 MAY'17 LIFE & DISABILITY P 010-60.8200.100000 7.80 MUTUALOF OMAHA 631098347 05/01/2017 MAY'17 LIFE & DISABILITY P 010-60.8200.100100 33.60 AMERITAS LIFE INSURANCE INV0002838 05/O1/2017 MAY'17 VISION INSURANCE 010-60.8200.100000 27.24 ACCESS SYSTEMS INV517888 05/03/2017 HP OFFICECONNECT 14205 010-60.8200.540000 49.05 FLYNN WRIGHT INV95709 03/31/2017 MARCH'17 KETTLESTONE W 010-60.8200.230010 50.00 FLYNN WRIGHT INV96101 04/30/2017 APRIL 17 KETTLESTONE WEB 010-60.8200.230010 50.00 LANDS END BUSINESS OUTFI SIN4903932 04/21/2017 SHIRTS-PARISH/OSTRING/EV 010-60.8200.120000 57.70 Department 8200 - COMMUNICATIONS Total: 2,092.39 Department: 8300 - ADMINISTRATION MCFARLAND CLINIC PC 1855038 05/02/2017 DRUG TESTS 010-60.8300.470000 43.00 METHODIST OCCUPATIONAL 223367 04/28/2017 PRE -EMPLOYMENT SCREENS 010-60.8300.470000 48.00 TRIPLETT OFFICE ESSENTIAL 299603-0 04/25/2017 CITY HALL OFFICE FURNITUR 010-60.8300.720000 9,229.76 CLASSIC FLORAL &GIFTS 631086 04/24/2017 FLOWERS - BATES 010-60.8300.590000 60.00 MUTUALOF OMAHA 631098347 05/O1/2017 MAY'17 LIFE & DISABILITY P 010-60.8300.100000 54.80 MUTUALOF OMAHA 631098347 05/O1/2017 MAY'17 LIFE & DISABILITY P 010-60.8300.100100 28.66 CITY OF WAUKEE APR17830NV 04/30/2017 APRIL'17 STATEMENT 010-60.8300.390400 103.86 AMERITAS LIFE INSURANCE INV0002838 05/O1/2017 MAY'17 VISION INSURANCE 010-60.8300.100000 47.84 MEDIACOM INV0002845 04/28/2017 APRIL'17 STATEMENT 010-60.8300.270000 139.95 ICMA MEMBER SERVICES INV0002869 05/09/2017 FY18 MOERMAN ANNUAL D 010-60.8300.280000 1,321.98 BRAVO GREATER DES MOINE INV0002880 04/27/2017 28E AGREEMENT CONTRIBU 010-60.8300.459000 1,000.00 CONSOLIDATED COMMUNIC INV0002907 05/01/2017 MAY'17 STATEMENT 010-60.8300.450000 793.00 IMAGETEK INC KJF3801445 03/31/2017 RADIX SUBSCRIPTION & STO 010-60.8300.270000 786.00 IMAGETEK INC KJF3801636 04/30/2017 RADIX SUBSCRIPTION/STOR 010-60.8300.270000 786.00 ONE SOURCE PLUS4380-20170430 04/30/2017 BACKGROUND CHECKS 010-60.8300.470000 55.00 Department 8300 - ADMINISTRATION Total: 14,497.85 Department: 8310 - CITY HALL OFFICE DEPOT 922011665001 04/20/2017 CALCULATOR TAPE/PICTURE O10-60.8310.590000 9.75 CITY OF WAUKEE APR17831 04/30/2017 APRIL'17 STATEMENT 010-60.8310.480000 167.53 MID AMERICAN ENERGY APR178310SUMBILL 04/25/2017 APRIL'17 STATEMENT 010-60.8310.480000 391.71 CITY OF WAUKEE APR17831CAM 04/30/2017 APRIL'17 STATEMENT 010-60.8310.390600 254.25 ALLIANCE CONNECT INV0002840 05/01/2017 MAY'17 STATEMENT 010-60.8310.450000 49.00 CONSOLIDATED COMMUNIC INV0002908 05/08/2017 MAY'17 STATEMENT 010-60.8310.450000 216.70 CONSOLIDATED COMMUNIC INV0002908 05/08/2017 MAY'17 STATEMENT 010-60.8310.450000 344.74 Department 8310 - CITY HALL Total: 1,433.68 Department: 8350 - HUMAN RESOURCES CHRISTIAN PRINTERS INC 36944 04/25/2017 TONI COUGHLIN BUSINESS C 010-60.8350.350100 18.00 MUTUALOF OMAHA 631098347 05/01/2017 MAY'17 LIFE & DISABILITY P 010-60.8350.100000 2.60 MUTUAL OF OMAHA 631098347 05/01/2017 MAY'17 LIFE & DISABILITY P 010-60.8350.100100 74.24 AMERITAS LIFE INSURANCE INV0002838 05/O1/2017 MAY'17 VISION INSURANCE 010-60.8350.100000 10.68 Department 8350 - HUMAN RESOURCES Total: 105.52 Department: 8400 - FINANCIAL ADMINISTRATION MUTUAL OF OMAHA 631098347 05/01/2017 MAY'17 LIFE & DISABILITY P 010-60.8400.100000 13.80 MUTUAL OF OMAHA 631098347 05/01/2017 MAY'17 LIFE & DISABILITY P 010-60.8400.100100 77.45 OFFICE DEPOT 922011665001 04/20/2017 CALCULATOR TAPE/PICTURE 010-60.8400.580000 4.54 AMERITAS LIFE INSURANCE INV0002838 05/01/2017 MAY'17 VISION INSURANCE 010-60.8400.100000 58.52 GOVERNMENT FINANCE OFF INV0002881 04/24/2017 MEMBERSHIP-BURKHART 010-60.8400.280000 170.00 LANDS END BUSINESS OUTFI SIN4903932 04/21/2017 SHIRTS-PARISH/OSTRING/EV 010-60.8400.120000 278.80 Department 8400 - FINANCIAL ADMINISTRATION Total: 603.11 Department: 8500 - COMMUNITY DEVELOPMENT FOTH INFRASTRUCTURE & E 52012 04/12/2017 MAPLE GROVE PLACE 010-50.8500.230000 4,597.00 FOTH INFRASTRUCTURE & E 52109 04/21/2017 MAPLE GROVE PLACE LLCSIT 010-50.8500.230000 485.24 MUTUALOF OMAHA 631098347 05/O1/2017 MAY'17 LIFE & DISABILITY P 010-50.8500.100000 5.20 MUTUALOF OMAHA 631098347 05/01/2017 MAY'17 LIFE & DISABILITY P 010-50.8500.100100 23.68 5/10/2017 1:59:35 PM Page 13 of 20 Expense Approval Register Packet: APPKT00593 - MAY 16TH COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount AMERITAS LIFE INSURANCE INV0002838 05/01/2017 MAY'17 VISION INSURANCE 010-50.8500.100000 37.92 Department 8500 - COMMUNITY DEVELOPMENT Total: 5,149.04 Department: 8600 - CITY ATTORNEY BRICK GENTRY BOWERS SW 229122 04/25/2017 APRIL'17 STATEMENT 010-60,8600.230000 22,012.50 Department 8600 - CITY ATTORNEY Total: 22,012.50 Department: 8700- DEVELOPMENT SERVICES FEDEX OFFICE 046800021638 04/06/2017 COMP PLAN SIGNAGE & CAR 010-50.8700.350100 181.85 MUTUAL OF OMAHA 631098347 05/01/2017 MAY'17 LIFE & DISABILITY P 010-50.8700.100000 57.40 MUTUALOF OMAHA 631098347 05/01/2017 MAY'17 LIFE & DISABILITY P 010-50.8700.100100 51.27 AMERITAS LIFE INSURANCE INV0002838 05/01/2017 MAY'17 VISION INSURANCE 010-50.8700.100000 65.16 LANDS END BUSINESS OUTFI SIN4903932 04/21/2017 SHIRTS-PARISH/OSTRING/EV 010-50.8700.120000 84.95 Department 8700 - DEVELOPMENT SERVICES Total: 440.63 Department: 8750 - SUGAR CREEK MUNICIPAL BEST PORTABLE TOILETS, IN 13341 04/28/2017 TOILETS 750-80.8750.480000 182.50 EVER GREENE SODDING &L 14002 04/28/2017 INSTALLSOD 750-80.8750.410300 1,095.00 MCFARLAND CLINIC PC 1855038 05/02/2017 DRUG TESTS 750-80.8750.470000 86.00 METHODIST OCCUPATIONAL 223367 04/28/2017 PRE -EMPLOYMENT SCREENS 750-80.8750.470000 288.00 DIRECTV 31293765358 05/01/2017 MAY'17 STATEMENT -GOLF 750-80.8750.400000 20.13 PLUMB SUPPLY COMPANY 4517847 05/01/2017 PVC PIPE 750-80.8750.410350 9.16 MUTUALOF OMAHA 631098347 05/01/2017 MAY'17 LIFE & DISABILITY P 750-80.8750.100000 1.82 MUTUAL OF OMAHA 631098347 05/01/2017 MAY'17 LIFE & DISABILITY P 750-80.8750.100100 6.32 PEPSI 66590774A 03/23/2017 WATER 750-80.8750.650150 23.80 MENARDS 78245 04/26/2017 TRASH CAN/27G TOUGH BO 750-80.8750.590000 37.37 BEELNER SERVICE INC 80159 04/27/2017 REPAIR PUMP STATION 750-80.8750.410350 330.00 OFFICE DEPOT 924090488001 04/28/2017 LETTER POUCH/LABELS 750-80.8750.580000 54.30 NAPA AUTO PARTS STORE 928760 04/20/2017 SIPPUMP 750-80.8750.410360 8.58 NAPA AUTO PARTS STORE 928878 04/20/2017 FUELPUMP 750-80.8750.410360 70.27 MID AMERICAN ENERGY APR178750SUMBILL 04/25/2017 APRIL'17 STATEMENT 750-80.8750.480000 421.76 CITY OF WAUKEE APR17875 04/30/2017 APRIL'17 STATEMENT 750-80.8750.480000 246.59 ACCESS SYSTEMS CW9868 04/19/2017 CISCO FIREWALL WORK 750-80.8750.270100 550.00 AMERITAS LIFE INSURANCE INV0002838 05/01/2017 MAY'17 VISION INSURANCE 750-80.8750.100000 7.48 WAUKEE HARDWARE&VARI INV0002849 04/30/2017 APRIL'17 STATEMENT-P& 750-80.8750.400000 5.37 ONE SOURCE PLUS4380-20170430 04/30/2017 BACKGROUND CHECKS 750-80.8750.470000 55.00 Department 8750 - SUGAR CREEK MUNICIPAL Total: 3,499.45 Department: 8900 - ENGINEERING FOTH INFRASTRUCTURE & E 52109 04/21/2017 DATA COLLECTION 010-20.8900.230000 982.85 MUTUAL OF OMAHA 631098347 05/01/2017 MAY'17 LIFE & DISABILITY P 010-20.8900.100000 55.80 MUTUALOF OMAHA 631098347 05/01/2017 MAY'17 LIFE & DISABILITY P 010-20.8900.100100 109.70 AMERITAS LIFE INSURANCE INV0002838 05/01/2017 MAY'17 VISION INSURANCE 010-20.8900.100000 75.84 PETTY CASH -PW/PARKS INV0002841 05/16/2017 PETTY CASH RECEIPTS 010-20.8900.470000 14.00 HEARTLAND CO-OP INV0002854 04/30/2017 APRIL'17 STATEMENT- ENGI 010-20.8900.570000 654.52 Department 8900 - ENGINEERING Total: 1,892.71 Department: 8950 - GIS IOWATRANSIT 31116 05/03/2017 REPAIR BATTERY CHARGE 010-20.8950.410100 357.35 MUTUALOF OMAHA 631098347 05/01/2017 MAY'17 LIFE & DISABILITY P 010-20.8950.100000 5.00 MUTUAL OF OMAHA 631098347 05/01/2017 MAY'17 LIFE & DISABILITY P 010-20.8950.100100 9.86 AMERITAS LIFE INSURANCE INV0002838 05/01/2017 MAY'17 VISION INSURANCE 010-20.8950.100000 10.68 HEARTLAND CO-OP INV0002852 04/30/2017 APRIL'17 STATEMENT-GIS 010-20.8950.570000 29.33 ONE SOURCE PLUS4380-20170430 04/30/2017 BACKGROUND CHECKS 010-20.8950.470000 35.00 Department 8950 - GIS Total: 447.22 Grand Total: 7,934,045.87 5/10/2017 1:59:35 PM Page 14 of 20 Expense Approval Register Packet: APPKT00593 - MAY 16TH COUNCIL PACKET Fund Summary Fund O10-GENERAL FUND 060 - ROAD USE TAX FUND 094-GATEWAY URBAN RENEWAL 110 - DEBT SERVICE FUND 111- SPECIAL ASSESSMENTS 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.100100 010-10.1100.120000 010-10.1100.230000 010-10.1100.400000 010-10.1100.400100 010-10.1100.410000 010-10.1100.450000 010-10.1100.480000 010-10.1100.540000 010-10.1100.560000 010-10.1100.580000 010-10.1100.590000 010-10.1300.230010 010-10.1400.100000 010-10.1400.100100 010-10.1400.400000 010-10.1400.410000 010-10.1400.450000 010-10.1400.460100 010-10.1400.470000 010-10.1400.480000 010-10.1400.570000 010-10.1400.590000 010-10.1500.100000 010-10.1500.100100 010-10.1500.400000 010-10.1500.410000 010-10.1500,450000 010-10.1500.460100 010-10.1500.470000 010-10.1500.480000 010-10.1500.540000 010-10.1500.570000 010-10.1500.590000 010-10.1500.590050 010-10.1900.100000 010-10.1900.100100 010-10.1900.120000 010-10.1900.270110 010-10.2400.340000 010-20.6000.100000 Grand Total: Account Summary Account Name HEALTH & LIFE INSURAN LONG TERM DISABILITY UNIFORMS CONSULTANT & PROFES REPAIR/MAINTENANCE CUSTODIAL REPAIR OF VEHICLES TELEPHONE UTILITY SERVICES MINOR EQUIPMENT MOTOR VEHICLE MAINT OFFICE SUPPLIES OPERATING SUPPLIES & WESTCOM DISPATCH SE HEALTH & LIFE INSURAN LONG TERM DISABILITY REPAIR/MAINTENANCE REPAIR OF VEHICLES TELEPHONE SERVICE TO CHILDREN TRAINING/TRAVEL EXPE UTILITY SERVICES FUEL OPERATING SUPPLIES & HEALTH & LIFE INSURAN LONG TERM DISABILITY REPAIR/MAINTENANCE REPAIR OF VEHICLES TELEPHONE SERVICE TO CHILDREN TRAINING/TRAVEL EXPE UTILITY SERVICES MINOR EQUIPMENT FUEL OPERATING SUPPLIES & MEDICALSUPPLIES HEALTH & LIFE INSURAN LONG TERM DISABILITY UNIFORMS COPIER / PRINTER LEASE MISCELLANEOUS CONTR HEALTH & LIFE INSURAN Expense Amount 145,465.05 33,802.47 4,674.00 6,176,194.13 1,959.50 271,164.18 353,087.62 442,523.62 407,404.68 5,888.73 294.35 86,864.35 4,723.19 7,934,045.87 Expense Amount 796.77 485.32 98.97 200.00 103.72 914.24 3,631.43 120.72 253.02 626.00 20.00 127.96 460.74 33,763.09 227.78 92.23 573.92 180.37 94.90 55.00 279.55 167.69 392.05 90.64 111.07 39.29 573.92 67.33 94.90 55.00 94.55 167.70 1,568.38 392.05 30.70 231.83 117.84 95.09 44.95 129.55 540.00 283.32 5/10/2017 1:59:35 PM Page 15 of 20 Expense Approval Register Packet: APPKT00593 - MAY 16TH COUNCIL PACKET Account Summary Account Number Account Name Expense Amount O10-20.6000.100100 LONG TERM DISABILITY 106.60 010-20.6000.120000 UNIFORMS 155.85 010-20.6000.280000 DUES, MEMBERSHIPS& 46.00 010-20.6000.470000 TRAINING/TRAVEL EXPE 6.24 010-20.6000.570000 FUEL 122.60 010-20.6000.580000 OFFICE SUPPLIES 31.00 010-20.6000.590000 OPERATING SUPPLIES & 587.50 010-20.6010.400000 REPAIR/MAINTENANCE 10,186.50 010-20.6010.400100 CUSTODIAL SERVICES 399.00 010-20.6010.410100 REPAIR/MAINTENANCE 1,695.72 010-20.6010.450000 TELEPHONE 585.48 010-20.6010.480000 UTILITY SERVICES 696.37 010-20.6010.580000 OFFICE SUPPLIES 599.38 010-20.6010.590000 OPERATING SUPPLIES & 801.98 010-20.6150.100000 HEALTH & LIFE INSURAN 43.12 010-20.6150.100100 LONG TERM DISABILITY 72.81 010-20.6150.570000 FUEL 146.45 010-20.6150.570130 COGS - PARTS 1,631.22 010-20.6150.590000 OPERATING SUPPLIES & 908.35 010-20,8900.100000 HEALTH & LIFE INSURAN 131.64 010-20.8900.100100 LONG TERM DISABILITY 109.70 010-20.8900.230000 CONSULTANT&PROFES 982.85 010-20.8900.470000 TRAINING/TRAVEL EXPE 14.00 010-20.8900.570000 FUEL 654.52 010-20.8950.100000 HEALTH & LIFE INSURAN 15.68 010-20.8950.100100 LONG TERM DISABILITY 9.86 010-20.8950.410100 REPAIR/MAINTENANCE 357.35 010-20.8950.470000 TRAINING/TRAVEL EXPE 35.00 010-20.8950.570000 FUEL 29.33 010-2030500 SALES TAX COLLECTED P 138.00 010-2035000 DEVELOPER DEPOSIT PA 4,500.00 010-40.3100.100000 HEALTH & LIFE INSURAN 183.16 010-40.3100.100100 LONG TERM DISABILITY 59.72 010-40.3100.270000 DATA PROCESSING 119.88 010-40,3100.280000 DUES, MEMBERSHIPS & 54.99 010-40,3100.400000 REPAIR/MAINTENANCE 567.44 010-40.3100.400100 CUSTODIAL SERVICES 388.00 010-40.3100.450000 TELEPHONE 207.10 010-40.3100A60300 PROGRAMS 351.00 010-40.3100.470000 TRAINING/TRAVEL EXPE 264.35 010-40.3100.480000 UTILITY SERVICES 375.65 010-40.3100.580000 OFFICE SUPPLIES 590.46 010-40.3100,590000 OPERATING SUPPLIES& 699.73 010-40.3100.640000 LIBRARY BOOKS/FILMS/ 5,517.52 010-40.4100.100000 HEALTH & LIFE INSURAN 45.78 010-40.4100.100100 LONG TERM DISABILITY 40.33 010-40.4100.410100 REPAIR/MAINTENANCE 45.00 010-40.4100.410300 REPAIR/MAINTENANCE 1,747.97 010-40.4100.450000 TELEPHONE 14.65 010-40.4100.480000 UTILITY SERVICES 2,750.25 010-40.4100.480100 UTILITIES -PARK IRRIGATI 682.10 010-40.4100.540000 MINOR EQUIPMENT 854.79 010-40.4100.570000 FUEL 1,517.25 010-40.4100.590000 OPERATING SUPPLIES & 117.00 010-40.4100.590100 CHEMICAL/FERTILIZER 1,851.00 010-40.4200.100000 HEALTH & LIFE INSURAN 116.66 010-40.4200.100100 LONG TERM DISABILITY 63.00 010-40.4200.460500 SUMMER RECREATION P 3,357.80 5/10/2017 1:59:35 PM Page 16 of 20 Expense Approval Register Packet: APPKTOGS93 - MAY 26TH COUNCIL PACKET Account Summary Account Number Account Name Expense Amount 010-40.4200.460800 JULY 4TH CELEBRATION 1,088.42 010-40.4200.470000 TRAINING/TRAVEL EXPE 192.00 010-40.4200.570000 FUEL 78.19 010-40.4300.400100 CUSTODIAL SERVICES 126.00 010-40.4300.410300 REPAIR/MAINTENANCE 751.75 010-40.4300.480000 UTI LITY SERVICES 52.71 010-50.8500.100000 HEALTH & LIFE INSURAN 43.12 010-50.8500.100100 LONGTERM DISABILITY 23.68 010-50.8500.230000 CONSULTANT & PROFES 5,082.24 010-50.8700.100000 HEALTH & LIFE INSURAN 122.56 010-50.8700.100100 LONGTERM DISABILITY 51.27 010-50.8700.120000 UNIFORMS 84.95 010-50.8700.350100 PRINTING 181.85 010-60.8100.580000 OFFICE SUPPLIES 65.00 010-60.8200.100000 HEALTH & LIFE INSURAN 35.04 010-60.8200.100100 LONGTERM DISABILITY 33.60 010-60.8200.120000 UNIFORMS 57.70 010-60.8200.210000 PUBLIC NOTIFICATION/A 1,817.00 010-60.8200.230010 WEBSITE DEVELOPMENT 100.00 010-60.8200.540000 MINOR EQUIPMENT 49.05 010-60.8300.100000 HEALTH & LIFE INSURAN 102.64 010-60.8300.100100 LONGTERM DISABILITY 28.66 010-60.8300.270000 DATA PROCESSING 1,711.95 010-60.8300.280000 DUES, MEMBERSHIPS & 1,321.98 010-60.8300.390400 NORTHVIEW RENTAL PR 103.86 010-60.8300.450000 TELEPHONE 793.00 010-60.8300.459000 CONTRIBUTIONS 1,000.00 010-60.8300,470000 TRAINING/TRAVEL EXPE 146.00 010-60.8300.590000 OPERATING SUPPLIES& 60.00 010-60.8300.720000 FURNITURE & FIXTURES 9,229.76 010-60.8310.390600 PROF PLAZA CAM EXPEN 254.25 010-60.8310.450000 TELEPHONE 610.44 010-60.8310.480000 UTILITY SERVICES 559.24 010-60.8310.590000 OPERATING SUPPLIES& 9.75 010-60.8350.100000 HEALTH & LIFE INSURAN 13.28 010-60.8350.100100 LONGTERM DISABILITY 74.24 010-60.8350.350100 PRINTING 18.00 010-60.8400.100000 HEALTH & LIFE INSURAN 72.32 010-60.8400.100100 LONGTERM DISABILITY 77.45 010-60.8400.120000 UNIFORMS 278.80 010-60.8400.280000 DUES, MEMBERSHIPS& 170.00 010-60.8400.580000 OFFICE SUPPLIES 4.54 010-60.8600.230000 CONSULTANT&PROFES 22,012.50 060-30.1600.410300 REPAIR/MAINTENANCE 1,421.66 060-30.1600.480000 UTILITY SERVICES 15,003.32 060-30.1601.480000 UTILITY SERVICES 317.33 060-30.7100.100000 HEALTH & LIFE INSURAN 162.45 060-30.7100.100100 LONG TERM DISABILITY 136.61 060-30.7100.410300 REPAIR/MAINTENANCE 3,519.00 060-30.7100.470000 TRAINING/TRAVEL EXPE 229.65 060-30.7100.570000 FUEL 682.46 060-30.7100.590000 OPERATING SUPPLIES& 493.36 060-30.7100.590300 ROAD STONE 2,054.91 060-30.7100.590400 ROAD REPAIR -PATCH 8,945.92 060-30.7100.590600 STREETSIGNS 835.80 094-30.7850.230000 CONSULTANT/PROFESSI 4,674.00 110-30.7800.914540 GO 09A-6TH/NORTHVIE 130,000.00 110-30.7800.914560 GO 10A CORP PURPOSE 120,000.00 5/10/2017 1:59:35 PM Page 17 of 20 Expense Approval Register Packet: APPKT00593 - MAY 16TH COUNCIL PACKET Account Summary Account Number Account Name Expense Amount 110-30.7800.914570 GO 10B PW BLDG PRINC 160,000.00 110-30.7800.914600 GO 12A REFUNDING - P 450,000.00 110-30.7800.914610 GO 12B REFUNDING - PR 630,000.00 110-30.7800.914620 GO 138 CORP PURP - PRI 330,000.00 110-30.7800.914621 GO 15C CORP PURP - PRI 1,010,000.00 110-30.7800.914622 GO 168 REFUNDING - PR 280,000.00 110-30.7800.924540 GO 09A-6TH/NORTHVIE 2,275.00 110-30.7800.924560 GO 10A CORP PURPOSE 12,468.76 110-30.7800.924570 GO 10B PW BLDG INTER 13,825.00 110-30.7800.924600 GO 12A REFUNDING - IN 8,550.00 110-30.7800.924610 GO 12B REFUNDING - IN 38,425.00 110-30.7800.924620 GO 13B CORP PURP - IN 26,237.50 110-30.7800.924621 GO 15C CORP PURP - IN 96,375.00 110-30.7800.924622 GO I6B REFUNDING - IN 12,462.86 110-30.7800.930100 REGISTRAR/SERVICE FEE 1,750.00 110-30.7850.918380 TIF REV 10C PW BLDG P 145,000.00 110-30.7850.918390 TIF 12D URB RENEWAL P 415,000.00 110-30.7850.918400 TIF 13C REFUNDING - PR 485,000.00 110-30.7850.918410 TIF I3D ALICES RD -PRI 850,000.00 110-30.7850.918420 TIF 14A 1801NTERCHG P 500,000.00 110-30.7850.928380 TIF REV 10C PW BLDG IN 14,477.50 110-30.7850.928390 TIF 12D URBAN RENEW I 21,400.00 110-30.7850.928400 TIF 13C REFUNDING- IN 7,308.75 110-30.7850.928410 TIF 13D ALICES RD- INTE 125,540.63 110-30.7850.928420 TIF 14A 1801NTERCHG IN 288,598.13 110-30.7850.930100 REGISTRAR/SERVICE FEE 1,500.00 111-30.7900.929010 09CSOUTHFORK SEWER 1,959.50 327-90.1601.235030 HICKMAN & W ESTGATE 1,850.00 327-90.2130.230051 CONSULTING - ESKER RD 3,226.00 327-90.2130.840490 ALICES RD- UNIVTO OL 445.00 327-90.2130.840491 ALICES ROAD- OLSON T 186,047.71 327-90.2131.230051 CONSULTING -ESKER RID 3,291.89 327-90.2132.230000 CONSULTING -GPP INTE 158.00 327-90.2150.980110 HIS REC COMPLEX -CON 4,467.32 327-90.2200.930300 GO DEBT ISSUANCE FEES 18,500.00 327-90.5000.881130 RRVTTRAILHEAD ART I 970.00 327-90.7730.230000 CONSULTANT&PROFES 7,519.00 327-90.7730.235000 CONSTRUCTION CONTR 834.46 327-90.7740.230000 CONSULTANT&PROFES 158.00 327-90.8030.230000 DEVELOPER LANE ADDIT 43,696.80 510-2030500 SALES TAX COLLECTED P 14,143.39 510-2321300 12C BOND PAYABLE 105,000.00 510-2321400 15B BOND PAYABLE 110,000.00 510-30.6510.100000 HEALTH & LIFE INSURAN 125.14 510-30.6510.100100 LONGTERM DISABILITY 156.67 510-30.6510.410000 REPAIR OFVEHICLES435.91 510-30.6510.410100 REPAIR/MAINTENANCE 94.00 510-30.6510.470000 TRAINING/TRAVEL EXPE 255.89 510-30.6510.480000 UTILITY SERVICES 823.68 510-30.6510.570000 FUEL 488.88 510-30.6510.590000 OPERATING SUPPLIES & 164.34 510-30.6510.650000 COST OF GOODS SOLD 66,161.68 510-30,6510.881200 WATER TOWER REHAB 140.54 510-30.6510.921260 12C BOND INTEREST EXP 34,497.50 510-30.6510.921270 15B BOND INTEREST EX 20,100.00 510-30.6510.930100 REGISTRAR/SERVICE FEE 500.00 520-1080100 MONEY MARKET-BANKE 36,500.00 520-2030500 SALES TAX COLLECTED P 1,938.93 5/10/2017 1:59:35 PM Page 18 of 20 Expense Approval Register Packet: APPKT00593 - MAY 16TH COUNCIL PACKET Account Summary Account Number Account Name Expense Amount 520-2066000 SEWER REV BOND PAYA 31,000.00 520-2066100 SEWER REV BOND PAYA 66,000.00 520-2066200 SEWER REV BOND PAYA 79,000.00 520-2320900 13A REVENUE BOND PA 100,000.00 520-30.6520.100000 HEALTH & LIFE INSURAN 110.24 520-30.6520.100100 LONGTERM DISABILITY 94.87 520-30.6520.250000 TESTING FEES 1,434.00 520-30.6520.410000 REPAIR OF VEHICLES 435.91 520-30.6520.450000 TELEPHONE 145.20 520-30.6520.470000 TRAINING/TRAVEL EXPE 129.76 520-30.6520.480000 UTILITY SERVICES 8,837.13 520-30.6520.570000 FUEL 336.68 520-30.6520.590000 OPERATING SUPPLIES & 260.03 520-30.6520.883080 FOX CREEK SEWER 400.56 520-30.6520.883091 NW AREA TRUNK SEWE 66,457.50 520-30.6520.920800 SRF SEWER LOAN A 10/9 560.00 520-30.6520.920900 SRF SEWER LOAN B I0/9 1,172.50 520-30.6520.921000 SRF SEWER LOAN C I0/9 1,408.75 520-30.6520.921100 13A INTEREST PAYABLE 9,371.88 520-30.6520.921110 16C INTEREST PAYABLE 36,250.18 520-30.6520.930100 REGISTRAR/SERVICE FEE 679.50 540-2030500 SALES TAX COLLECTED P 2,327.58 540-2321400 15 GAS REVENUE BOND 358,000.00 540-30.6540.100000 HEALTH & LIFE INSURAN 225.30 540-30.6540.100100 LONG TERM DISABILITY 77.33 540-30.6540.120000 UNIFORMS 260.50 540-30.6540.230000 CONSULTANT&PROFES 175.00 540-30.6540.350100 PRINTING 191.67 540-30.6540.410200 REPAIR/MAINTENANCE 186.52 540-30.6540.450000 TELEPHONE 72.60 540-30.6540.470000 TRAINING/TRAVEL EXPE 55.00 540-30.6540.480000 UTILITY SERVICES 79.21 540-30.6540.570000 FUEL 484.28 540-30.6540.590000 OPERATING SUPPLIES& 352.20 540-30.6540.592000 METER PURCHASE 1,635.64 540-30.6540.650000 COST OF GOODS SOLD 11,108.85 540-30.6540.880100 DISTRIBUTION SYSTEM 1 900.00 540-30.6540.920010 15 GAS REVENUE BOND 31,023.00 540-30.6540.930100 REGISTRAR/SERVICE FEE 250.00 560-2030500 SALES TAX COLLECTED P 1,212.09 560-80.5300.100000 HEALTH & LIFE INSURAN 113.26 560-80.5300.100100 LONG TERM DISABILITY 76.64 560-80.5300.120000 UNIFORMS 301.94 560-80.5300.360000 POSTAGE & SHIPPING 7.99 560-80.5300.410300 REPAIR/MAINTENANCE 3,949.30 560-80.5300.470000 TRAINING/TRAVEL EXPE 35.00 560-80.5300.570000 FUEL 142.51 560-80.5300.685400 RAIN BARREL REBATES 50.00 570-30.6550.100000 HEALTH & LIFE INSURAN 112.62 570-30.6550.100100 LONGTERM DISABILITY 15.78 570-30.6550.120000 UNIFORMS 165.95 590-30.5400.231300 RESIDENTIAL SOLID WAS 86,187.75 590-30.5400.245500 SPRING CLEANUP 676.60 750-2030500 SALES TAX COLLECTED P 1,223.74 750-80.8750.100000 HEALTH & LIFE INSURAN 9.30 750-80.8750.100100 LONG TERM DISABILITY 6.32 750-80.8750.270100 COMPUTER SUPPORT 550.00 750-80.8750.400000 REPAIR/MAINTENANCE 25.50 5/10/2017 1:59:35 PM Page 19 of 20 Expense Approval Register Packet: APPKT00593 - MAY 16TH COUNCIL PACKET Account Summary Account Number Account Name Expense Amount 750-80.8750.410300 REPAIR/MAINTENANCE 1,095.00 750-80.8750.410350 REPAIR/MAINTENANCE 1 339.16 750-80.9750.410360 REPAIR/MAINTENANCE 78.85 750-80.8750.470000 TRAINING/TRAVEL EXPE 429.00 750-80.8750.480000 UTILITY SERVICES 850.85 750-80.8750.580000 OFFICE SUPPLIES 54.30 750-80.8750.590000 OPERATING SUPPLIES & 37.37 750-80.8750.650150 COGS-POP/WATER 23.80 Grand Total: 7,934,045.87 Project Account Summary Project Account Key Expense Amount **None** 7,934,045.87 Grand Total: 7,934,045.87 5/10/2017 1:59:35 PM Page 20 of 20 ki IWWI City of Waukee, IA Vendor Number Vendor Name Bank Code: AP-WAUKEE STATE 061100 FAMOUS DAVE'S Payable # Payable Type Account Number INV0002808 Invoice 010-20.6000.470000 Payment Date Payment Type My Check Report By Check Number Date Range: 04/26/2017-05/O1/2017 Discount Amount PaymentAmount Number 04/26/2017 Regular 0.00 1,608.84 128624 Payable Date Payable Description DiscountAmount Payable Amount Account Name Item Description Distribution Amount 04/26/2017 APWA OPEN HOUSE LUNCH 0.00 1,608.84 TRAINING/TRAVELEXPEN APWA OPEN HOUSE LUNCH 1,608.84 061100 FAMOUS DAVE'S 04/26/2017 Regular 0.00-1,608.84 128624 061100 FAMOUS DAVE'S 04/26/2017 Regular 0.00 992.55 128625 Payable # Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0002809 Invoice 04/26/2017 APWA OPEN HOUSE LUNCH 0.00 992.55 010-20.6000.470000 TRAINING/TRAVEL EXPEN APWA OPEN HOUSE LUNCH 992.55 035130 CLAYTON ENERGY CORPORATION 04/27/2017 Regular 0.00 137,632.08 128626 Payable # Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount 9872 Invoice 04/13/2017 MARCH 2017 COMMODITY 0.00 137,632.08 540-30.6540.650000 COST OF GOODS SOLD MARCH 2017 COMMODITY 137,632.08 047290 DOLL DISTRIBUTING, LLC 04/28/2017 Regular 0.00 1,230.70 128627 Payable # Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0002811 Invoice 04/28/2017 BEER DELIVERY 0.00 1,230.70 750-80.8750.650100 COGS-BEER/ALCOHOL BEER DELIVERY 1,230.70 233120 PETTY CASH -PW/PARKS 04/28/2017 Regular 0.00 100.00 128628 Payable # Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0002810 Invoice 04/28/2017 TIRE DROP OFF MONEY 0.00 100.00 590-30,5400.245500 SPRING CLEANUP TIRE DROP OFF MONEY 100.00 077600 GREATER DES MOINES PARTNERSHIP 04/28/2017 Regular 0.00 17,500.00 128629 Payable # Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount 428174 Invoice 04/28/2017 DC TRIP -MOERMAN/DUTCHER/PEARD/L 0.00 17,500.00 010-50.8500.470000 TRAINING/TRAVEL EXPEN DC TRIP - MOERMAN/DUTCHER 2,250.00 010-60.8100.470000 TRAINING/TRAVEL EXPEN DC TRIP - MOERMAN/DUTCHER 13,000.00 010-60.8300.470000 TRAINING/TRAVEL EXPEN DC TRIP - MOERMAN/DUTCHER 2,250.00 Bank Code AP Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 6 6 0.00 159,064.17 Manual Checks 0 0 0.00 0.00 Voided Checks 0 1 0.00 -1,608.84 Bank Drafts 0 0 0.00 0.00 EFT's 0 0 0.00 0.00 6 7 0.00 157,455.33 5/10/2017 2:03:37 PM Page 1 of 2 My Check Report 0 Date Range: 04/26/2017 - 05/01/2017 Fund Summary Fund Name Period Amount 999 POOLED CASH 4/2017 157,455.33 157,455.33 5/10/2017 2:03:37 PM Page 2 of 2 ;,`(` City of Waukee, IA Waukee My Check Report By Check Number Date Range: 05/03/2017 - 05/10/2017 Vendor Number Vendor Name Payment Date Payment Type DiscountAmount PaymentAmount Number Bank Code: AP-WAUKEE STATE 011475 ACCESS SYSTEMS LEASING 05/04/2017 Regular 0.00 145.83 128791 Payable # Payable Type Payable Date Payable Description DiscountAmount Payable Amount Account Number Account Name Item Description Distribution Amount 20562569 Invoice 04/26/2017 COPIER/PRINTER LEASE 0.00 145.83 010-60.8350,270110 COPIER/PRINTER LEASE COPIER/PRINTER LEASE 145.83 046560 DIRECTV 05/04/2017 Regular 0.00 196.23 128792 Payable# Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount 31218045025 Invoice 04/21/2017 APRIL'17 STATEMENT 0.00 196.23 010-20.6010,480000 UTILITY SERVICES APRIL'17 STATEMENT 196.23 169875 PURCHASE POWER, INC. 05/04/2017 Regular 0.00 3,108.75 128793 Payable# Payable Type Payable Date Payable Description DiscountAmount Payable Amount Account Number Account Name Item Description Distribution Amount INV0002843 Invoice 04/23/2017 APRIL'17 STATEMENT 0.00 3,108.75 570-30,6550.360000 POSTAGE & SHIPPING MARCH'17 BILLS 1,801.13 570-30,6550.360000 POSTAGE&SHIPPING PERMIT OVERAGE FEE 28.35 570-30.6550.360000 POSTAGE & SHIPPING MARCH'17 LATE NOTICES 439.41 570-30.6550.360000 POSTAGE & SHIPPING MARCH'17 ACH 839.86 216700 US CELLULAR 05/04/2017 Regular 0.00 571.33 128794 Payable # Payable Type Payable Date Payable Description DiscountAmount Payable Amount Account Number Account Name Item Description Distribution Amount 0187566322 Invoice 04/14/2017 APRIL'17 STATEMENT 0.00 571.33 060-30.7100.450000 TELEPHONE APRIL'17 STATEMENT 571.33 094675 IOWA BEVERAGE SYSTEMS INC 05/08/2017 Regular 0.00 1,215.10 128810 Payable # Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0002846 Invoice 05/08/2017 BEER DELIVERY 0.00 1,215.10 750-80.8750,650100 COGS-BEER/ALCOHOL BEER DELIVERY 1,215.10 199023 SUGAR CREEK GOLF COURSE 05/09/2017 Regular 0.00 238.00 128811 Payable# Payable Type Payable Date Payable Description DiscountAmount Payable Amount Account Number Account Name Item Description Distribution Amount INV0002851 Invoice 05/09/2017 LEAGUE PRIZES 0.00 238.00 750-80.8750.653000 LEAGUE PRIZES/EXPENSE LEAGUE PRIZES 238.00 041875 DALLAS COUNTYTREASURER 05/09/2017 Regular 0.00 504.00 128812 5/10/2017 2:08:50 PM Page 1 of 3 My Check Report Date Range: 05/03/2017-05/10/2017 Vendor Number Vendor Name Payment Date Payment Type Discount Amount Payment Amount Number Payable# Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0002876 Invoice 05/01/2017 FY'17 MCCARTHY PROPERTY TAXES 0.00 504.00 010-60.8300.390300 CITY PROPERTY TAXES FY'17 MCCARTHY PROPERTY TA 504.00 Bank Code AP Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 7 7 0.00 5,979.24 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 7 7 0.00 S,979.24 5/10/2017 2:08:50 PM Page 2 of 3 My Check Report Date Range: 05/03/2017 - 05/10/2027 Fund Summary Fund Name Period Amount 999 POOLED CASH 5/2017 5,979.24 5,979.24 5/10/2017 2:08:50 PM Page 3 of 3 C Council Payroll Reimbursements ,11/ `ilbUkee City of Waukee, IA Vendor Number Vendor Name Payment Date Payment Type Bank Code: AP-WAUKEE STATE 034875 CITY OF WAU KEE 04/30/2017 Regular Payable# Payable Type Payable Date Payable Description Account Number Account Name Item Description INV0002813 Invoice 04/30/2017 MISC DEDUCTIONS 010-2030000 PAYROLL PAYABLES MISC DEDUCTIONS By Check Number Date Range: 04/30/2017 -05/10/2017 DiscountAmount PaymentAmount Number 0.00 5,379.18 128642 Discount Amount Payable Amount Distribution Amount 0.00 75.00 75.00 INV0002819 Invoice 04/30/2017 CELL PHONE REIMBURSEMENT 0.00 230.00 010-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 155.00 060-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 9.37 510-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 11.32 520-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 26.23 540-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 26.32 560-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 1.76 INV0002820 Invoice 04/30/2017 GOLF APARTMENT RENT 0.00 600.00 010-2030000 PAYROLL PAYABLES GOLF APARTMENT RENT 600.00 INV0002825 Invoice 04/30/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.91 520-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 28.85 540-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 42.84 560-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 27.79 570-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 34.75 INV0002826 Invoice 04/30/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.77 520-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 42.28 540-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 23.69 560-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 33.55 INV0002829 Invoice 04/30/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 153.01 510-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 116.97 520-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 159.31 540-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 201.85 560-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 95.61 570-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 42.50 750-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 29.75 INV0002830 Invoice 04/30/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 OEDUCTIO 18.86 520-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 18.74 540-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 3.85 560-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 3.55 570-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 15.00 036350 IOWA DEPT OF HUMAN SERVICES 04/30/2017 Regular 0.00 1,740.58 128643 5/10/2017 9:50:00 AM Page 1 of 6 1-0 Council Payroll Reimbursements Date Range: 04/30/2017 - 05/10/2017 Vendor Number Vendor Name Payment Date Payment Type DiscountAmount Payment Amount Number Payable p Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0002812 Invoice 04/30/2017 CHILD SUPPORT 0.00 1,740.58 010-2011300 CHILD SUPPORT PAYABLE CHILDSUPPORT 1,616.70 060-2011300 CHILD SUPPORT PAYABLE CHILD SUPPORT 123.88 036740 COMMUNICATIONS WORKERS OF AMERICA 04/30/2017 Regular 0.00 888.78 128644 Payable # Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0002816 Invoice 04/30/2017 CWA LOCAL 7102 UNION DUES 0.00 888.78 010-2014100 CREDIT UNION DEDUCT] CWA LOCAL 7102 UNION DUES 420.99 060-2014100 CREDIT UNION DEDUCT] CWA LOCAL 7102 UNION DUES 83.11 510-2014100 CREDIT UNION DEDUCTI CWA LOCAL 7102 UNION DUES 65.93 520-20141GO CREDIT UNION DEDUCTI CWA LOCAL 7102 UNION DUES 96.50 540-2014100 CREDIT UNION DEDUCTI CWA LOCAL 7102 UNION DUES 131.08 560-2014100 CREDIT UNION DEDUCTI CWA LOCAL 7102 UNION DUES 65.89 570-2014100 CREDIT UNION DEDUCTI CWA LOCAL 7102 UNION DUES 25.28 099999 EFTPS 04/30/2017 Regular 0.00 74,079.40 128645 Payable M Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0002834 Invoice 04/30/2017 FICA TAX WITH HOLDING 0.00 34,582.14 010-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 26,617.20 060-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 1,463.32 510-2010300 FICA TAX WITH HOLDING FICA TAX WITHHOLDING 1,116.20 520-2010300 FICA TAX WITH HOLDING FICA TAX WITHHOLDING 1,467.04 540-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 1,685.88 560-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 676.88 570-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 478.92 750-2010300 FICA TAX WITHHOLDING FICA TAX WITH HOLDING 1,076.70 INV0002835 Invoice 04/30/2017 FEDERAL WITH HOLDING TAXES 0.00 31,409.40 010-2010200 FEDERAL TAX WITHHOLD[ FEDERAL WITHHOLDING TAXES 24,485.65 060-2010200 FEDERAL TAX WITHHOLD[ FEDERAL WITHHOLDING TAXES 1,257.49 510-2010200 FEDERAL TAX WITHHOLD[ FEDERAL WITHHOLDING TAXES 969.98 520-2010200 FEDERAL TAX WITH HOLDI FEDERAL WITHHOLDING TAXES 1,554.07 540-2010200 FEDERAL TAX WITH HOLDI FEDERAL WITHHOLDING TAXES 1,451.19 560-2010200 FEDERAL TAX WITH HOLDI FEDERAL WITH HOLDING TAXES 661.51 570-2010200 FEDERAL TAX WITH HOLDI FEDERAL WITH HOLDING TAXES 589.89 750-2010200 FEDERAL TAX WITH HOLDI FEDERAL WITH HOLDING TAXES 439.62 INV0002836 Invoice 04/30/2017 MEDICARE TAX WITHHOLDING 0.00 8,087.86 010-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 6,225.10 060-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 342.26 510-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 261.14 520-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 343.10 540-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 394.18 560-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 158.26 570-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 112.00 750-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 251.82 133560 MEALS FROM THE HEARTLAND 04/30/2017 Regular 0.00 114.20 128646 Payable It Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0002822 Invoice 04/30/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 206800 TOTAL ADMINISTRATIVE SERVICES CORP 04/30/2017 Regular 0.00 4,464.09 128647 5/10/2017 9:50:00 AM Page 2 of 6 Council Payroll Reimbursements C/ Date Range: 04/30/2017 - 05/10/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 INV0002827 Invoice 04/30/2017 SECTION 125 MEDICAL DEDUCTIONS 0.00 2,613.28 010-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 1,897.00 060-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 10.41 510-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 115.63 520-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 111.77 540-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 183.33 560-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 97.23 570-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 125.00 750-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 72.91 INV0002828 Invoice 04/30/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 04/30/2017 Regular 0.00 193.30 128648 Payable # Payable Type Payable Date Payable Description DiscountAmount Payable Amount Account Number Account Name Item Description Distribution Amount INV0002818 Invoice 04/30/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 04/30/2017 Regular 0.00 36.66 128649 Payable # Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0002823 Invoice 04/30/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 091000 ICMA RETIREMENT TRUST 457 05/03/2017 Regular 0.00 5,713.29 128787 Payable Payable Type Payable Date Payable Description DiscountAmount Payable Amount Account Number Account Name Item Description Distribution Amount INV0002763 Invoice 04/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 INV0002764 Invoice 04/15/2017 ICMA 0.00 859.93 010-2011200 IPERS WITHHOLDING PAY ICMA 799.52 510-2011200 IPERS WITHHOLDING PAY ICMA 15.10 520-2011200 IPERS WITHHOLDING PAY ICMA 15.10 540-2011200 IPERS WITHHOLDING PAY ICMA 15.10 560-2011200 IPERS WITHHOLDING PAY ICMA 15.11 INV0002814 Invoice 04/30/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 INV0002815 Invoice 04/30/2017 ICMA 0.00 895.78 010-2011200 IPERS WITHHOLDING PAY ICMA 833.94 510-2011200 IPERS WITHHOLDING PAY ICMA 15.47 520-2011200 IPERS WITHHOLDING PAY ICMA 15.47 540-2011200 IPERS WITHHOLDING PAY ICMA 15.47 5/10/2017 9:50:00 AM Page 3 of 6 Council Payroll Reimbursements Vendor Number Vendor Name 560-2011200 Payment Date Payment Type IPERS WITHHOLDING PAY ICMA Date Range: 04/30/2017 - 05/10 17 DiscountAmount Payment Amount Number 15.43 098900 IPERS 05/03/2017 Regular 0.00 85,393.75 128788 Payable It Payable Type Payable Date Payable Description DiscountAmount Payable Amount Account Number Account Name Item Description Distribution Amount CM0000023 Credit Memo 04/30/2017 APRIL'17 ROUNDING ADJUSTMENT 0.00 -0.16 010-60.8400.080000 IPERS CONTRIBUTION APRIL'17 ROUNDING ADJUSTM -0.16 INV0002779 Invoice 04/15/2017 IPERS DEDUCTIONS 0.00 27,734.29 010-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 18,553.09 060-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 1,520.39 510-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 1,356.41 520-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 1,715.04 540-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 2,133.95 560-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 875.39 570-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 606.09 750-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 973.93 INV0002780 Invoice 04/15/2017 IPERS DEDUCTIONS 0.00 14,601.53 010-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 14,601.53 INV0002781 Invoice 04/15/2017 IPERS ELECTED OFFICIAL DEDUCT 0.00 212.04 010-2011200 IPERS WITHHOLDING PAY IPERS ELECTED OFFICIAL DEDUC 212.04 INV0002831 Invoice 04/30/2017 IPERS DEDUCTIONS 0.00 28,162.29 010-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 18,786.78 060-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 1,632.84 510-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 1,298.43 520-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 1,725.17 540-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 2,079.47 560-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 871.63 570-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 601.86 750-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 1,166.11 INV0002832 Invoice 04/30/2017 IPERS DEDUCTIONS 0.00 14,683.76 010-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 14,683.76 208650 Payable s INV0002782 INV0002833 256601 TREASURER STATE OF IOWA 05/03/2017 Regular 0.00 25,137.00 128789 Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount Invoice 04/15/2017 STATE WITHHOLDING TAXES 0.00 12,462.35 010-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 9,855.61 060-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 443.55 510-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 392.77 520-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 497.81 540-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 629.52 560-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 242.36 570-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 191.45 750-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 209.27 Invoice 04/30/2017 STATE WITHHOLDING TAXES 0.00 12,674,65 010-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 10,006.93 060-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 500.30 510-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 372.49 520-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 502.76 540-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 612.76 560-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 240.45 570-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 190.10 750-2011100 STATE TAX WITH HOLDIN STATE WITHHOLDING TAXES 248.86 YMCA OF GREATER DES MOINES 05/03/2017 Regular 0.00 1,444.00 128790 5/10/2017 9:50:00 AM Page 4 of 6 Council Payroll Reimbursements Date Range: 04/30/2017 - 05/1 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 INV0002766 Invoice 04/15/2017 YMCA FAMILY MEMBERSHIP DEDUCTION 0.00 544.00 010-2030000 PAYROLL PAYABLES YMCA FAMILY MEMBERSHIP DE 408.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 PAYABLE$ YMCA FAMILY MEMBERSHIP DE 34.00 INV0002769 Invoice 04/15/2017 YMCA SINGLE MEMBERSHIP DEDUCTION 0.00 144.00 010-2030000 PAYROLL PAYABLES YMCA SINGLE MEMBERSHIP DE 144.00 0 17 INV0002917 Invoice 04/30/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.07 520-2030000 PAYROLL PAYABLES YMCA FAMILY MEMBERSHIP DE 16.93 540-2030000 PAYROLL PAYABLES YMCA FAMILY MEMBERSHIP DE 68.00 560-2030000 PAYROLL PAYABLES YMCA FAMILY MEMBERSHIP DE 34.00 INV0002821 Invoice 04/30/2017 YMCA SINGLE MEMBERSHIP DEDUCTION 0.00 144.00 010-2030000 PAYROLL PAYABLES YMCA SINGLE MEMBERSHIP DE 144.00 Bank Code AP Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 33 12 0.00 204,584.23 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 33 12 0.00 204,584.23 5/10/2017 9:50:00 AM Page 5 of 6 Council Payroll Reimbursements Date Range: 04/30/2017 - 05/10/2017 Fund 999 999 Fund Summary Name Period Amount POOLED CASH 4/2017 86,896.19 POOLED CASH 5/2017 117,688.04 204,584.23 5/10/2017 9:50:00 AM Page 6 of 6 05-10-2017 09:53 AM PERIOD: 4/27/2017 THRU 5/10/2017 ZONE: • - All Zones REVENUE CODE: All ADJUSTMENT CODES: All ACCOUNT NOS{ NAME MONTHLY TRANSACTION REPORT DATE TYPE AMOUNT REFERENCE PACKET PAGE: 1 RECEIPT ADJ 01-40302-11 RAMSEY, DANIEL E 5/08/2017 RF-CK 76.77 REFUND CK: 12B795 20360 O1-B2903-07 HOWE, CHASE 5/08/2017 RF-CK 59.49 REFUND CK: 128796 20360 07-91100-03 CLARK, KAY 5/OS/2017 RF-CK 20.15 REFUND CK: 128797 20360 83-00568-12 MOHON, SHAUN T 5/08/2017 RF-CK 145.64 REFUND CK: 128798 20360 83-00868-09 WILLEMS, JANET 5/08/2017 RF-CK 110.26 REFUND CK: 128799 20360 83-01237-12 STOCKER, MYREON 5/08/2017 RV-CK 73.66 REFUND CK: 128800 20360 83-01240-12 CASTRO, LUCIANO E 5/08/2017 RF-CK 25.19 REFUND CK: 128801 20360 83-01254-06 VILLOTTI, BOBBIE 5/08/2017 RF-CK 125.58 REFUND CK: 128802 20360 83-01319-21 STANLEY, GARY L 5/08/2017 RF-CK 9.01 REFUND CK: 128803 20360 84-00124-10 HOWE, ROBBIE L 5/08/2017 RF-CK 56.50 REFUND CK: 128804 20360 84-01285-08 KALVIG, TIMOTHY 5/08/2017 RF-CK 87.50 REFUND CK: 128805 20360 84-02044-04 BLANCHARD, MARVIN S 5/08/2017 RF-CK 51.85 REFUND CK: 128806 20360 85-00071-01 KIRK, ALLISON 5/08/2017 RF-CK 58.34 REFUND CK: 128807 20360 85-00901-01 DETERMANN, TARA A 5/08/2017 RF-CK 56.64 REFUND CK: 128808 20360 85-01070-02 CROWELL, TRACY L 5/08/2017 RP-CK 131.48 REFUND CK: 128809 20360 MONTHLY TRANSACTION REPORT PAGE: 2 05-10-2019 09,53 AM PERIOD: 4/27/2017 THRU 5/10/2017 ZONE: * - All Zones REVENUE CODE: All ADJUSTMENT CODES: All M O N T H L Y D I S T R I B U T I O N 7 MONTH REVENUE CODE TYPE COUNT AMOUNT TYPE COUNT AMOUNT TYPE COUNT AMOUNT 05/2017 999 - REFUND RF-CK 15 1,088.06 GRAND TOTAL FOR PERIOD 1,088.06 DEPOSIT TOTAL FOR PERIOD 0.00 05-10-2017 09:53 AM MONTHLY TRANSACTION REPORT PAGE: 3 PERIOD: 4/27/2017 THRU 5/10/2017 ZONE: * - All REVENUE CODE: All All ADJUSTMENT CODES: All __--_____________________________ R E V E N U E C 0 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,088.06 GRAND TOTAL FOR PERIOD 1,088.06 _______________________________________ 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,088.06 TOTAL FOR PERIOD 15 1,088.06 6 0 Vbukee Employee Name ABBOTT, BRENT ADKINS, COREY ALDRICH, SHAWN ALLEN, JASON APPLE, WILLIAM ARIAS, HECTOR ARMSTRONG, BRETT BAKER, RANDY BARTLING, DARREL BAUMAN, LISA BELL, RYAN BERG, BROOKE BOHARDT, HAZEL BRUNS, RACHEL BURKHART, LINDA CAMPBELL, JUDY CAMPBELL, SCOTT CASEY, MARK CICHOSKI, KELLI CLEMEN, ANTHONY COLE, JACOB CORKREAN, JENNIFER COUCHMAN, KENNETH COUGHLIN, TONI CRAVEN,GAYLA CUNNINGHAM, DEANA CUNNINGHAM, SCOTT DANIEL, COLE DAVIS, BRIAN DEBOER, MELISSA DEETS, BRADLY DEZEEUW, DAVID DODGE, JUSTIN DUNBAR, DIANA DUNHAM, BRYCE DUTCHER, DAN EASTMAN, DAVID EDWARDS, DANAE ELDRIDGE, MALLORY ELLIOTT, STEVE EVANS, SUMMER EVERMAN, MASON FLUGGE-SMITH, JAMIE FORRET, DENNIS FREDERICK, JUSTIN FROEHLICH, WILLIAM GEADELMANN, WILLIAM GIBSON, JOHN GITZEN, ROBERT GODWIN, EDWARD GROVE, BRIAN GROVO,ANDREW HANSON,ANTHONY HANSON, LAURA HARDIN, THOMAS HASKINS, STACEY HEIMANN, RONALD City of Waukee, IA Publication Report By Employee Name Payroll Set: 01 - City of Waukee For Date Range 04/16/2017-04/30/2017 Salary $1,196.12 $1,163.46 $1,530.55 $318.26 $714.16 $1,608.24 $1,428.40 $1,690.16 $188.77 $1,114.25 $102.17 $159.31 $377.22 $1,528.05 $2,818.13 $440.00 $2,113.94 $231.44 $1,359.50 $627.80 $358.82 $1,517.55 $75.88 $1,380.15 $69.64 $532.57 $2,138.99 $1,107.65 $544.09 $1,482.79 $3,088.63 $1,955.05 $1,608.41 $909.86 $969.45 $3,001.86 $631.17 $915.08 $704.27 $1,729.29 $2,085.33 $150.51 $1,448.16 $260.35 $1,494.85 $285.88 $70.62 $3,295.08 $2,164.21 $565.95 $261.07 $221.19 $2,027.24 $1,349.60 $589.56 $1,105.45 $1,921.43 l� Employee Name Salary HENTGES, ERIC $760.83 HERR, JENNA $1,290.77 HERRICK, ROBERT $1787.84 HILGENBERG, ADAM $1,331.90 HOCHSTETLER, DENNIS $774.90 HOLDEN, PATRICIA $2,707.17 HOPTON, SIMONE $117.03 HUSTED, TROY $1,425.74 HUTTON, JOSHUA $597.83 IRWIN, BRENT $204.39 JENSEN, CHAD $215.52 JERMIER, MATTHEW $2,597.77 JONES, KACIE $51.08 KASS, ANDREW $1,884.32 KASZINSKI, BRETT $594.38 KELLER, CHRISTOPHER $1,558.12 KERR, JACOB $1,630.91 KESSLER, MATTHEW $1,884.87 KIES, SUSAN $1,719.83 KOESTER, EVAN $1,803.61 KOESTER, RUDY $2,482.37 KOPPES, BROOKE $60.49 LARSON, KENNETH $670.67 LARSON, KRISTINE $2,406.06 LAUGHRIDGE, DANIEL $1,444.56 LEMKE, NEIL $99824 LOFTSGARD, MARA $78.61 LONG, JEREMY $2,252.50 LOVE, WILLIAM $47.96 LYNCH, JEREMY $724.58 LYNCH, SHANNON $1,341.09 MANNING, JOSHUA $1,789.07 MAPES, TROY $2,601.77 MCCLINTIC, JAMES $956.94 MCKERN, DOUGLAS $593.96 MEANS, KEATON $88.24 MEDDERS, BRETT $1,412.80 MELLENCAMP, JEFFREY $2,325.70 MINIKUS, JOSHUA $1,600.66 MOERMAN, TIMOTHY $3,857.98 MORFORD, PAIGE $288.17 MURRA, BRIAN $1,664.66 NICELY -GREEN, CODY $306.47 NITZEL, NICOLE $647.29 NORTON, PATRICK $221.83 OAKLEY, JON $1,995.11 OLSEN, KART $1,303.28 OSTRING, KATHLEEN $1,236.75 PARISH, TONJA $1,199.41 PARKER, SUSAN $160.22 PELLETTERI, SALVATORE $79.85 PERDRIAU, MARIE $225.93 PETERSON, KATIE $1,037.95 PETERSON, OREN $1,696.63 PETTIT, BRANDON $1,605.41 PIERSON, DAMON $1,115.32 PINEGAR, TOMMIE $429.06 PIZINGER, JAMES $1,043.39 POSADAS, OSCAR $225.21 PUDENZ, DANIELLE $115.10 PURVIS, KATHRYN $1,085.60 QUINN, JOHN $2 719.27 RASH, RONALD $1,513.26 RICHARDSON, ELIZABETH $1,571.28 I& Employee Name Salary RICHTER, ALICIA $117.74 RIPPERGER, TRACY $70.21 ROBINSON, CLINT $3,107.40 ROYER, TIMOTHY $2,701.18 ROYSTER, JACOB $1,226.68 SANDQUIST, BENJAMIN $94.65 SCHAUFENBUEL, KARI $836.99 SCHETTLER, RODNEY $1,620.81 SCHUETT, REBECCA $1,759.67 SEDDON, JOSH $250.64 SHARON, JEREMIAH $1,315.99 SNELSON, NATHANIEL $374.34 SOFEN,NATASHA $34.56 SPOSETO, MACKENZIE $2,333.03 SPRAGUE, MATTHEW $1,681.01 STEINKE, KURT $292.55 STEPHENS, CLINT $218.06 STEWARD, ERIC $1,620.02 STOTZ, MELISSA $885.78 SUETSUGU, SEAN $213.71 TETMEYER, CARL $395.34 THAYER, CHANDLER $507.04 THOMAS, JULIE $162.11 TIBBLES, STEVEN $1,346.35 TUEL, JASON $280.87 TYSDAL, THOMAS $2,278.68 VANDE KAMP, JOSHUA $1,565.16 VOEGTLE, TIMOTHY $1,315.34 VOKES, LARRY $1,503.68 WALLACE, ERIC $1,406.85 WASKE, CHARLES $1,587.34 WAUGH, DOUGLAS $670.82 WAYCASTER, SAVANNAH $149.22 WERTS, DANIEL $1,835.45 W ESTON STOLL, KERI $1,499.03 WHITE, JASON $1,379.46 WHITE, LEAH $1,151.48 W IGGINS, MATHEW $1,661.55 W ILSON, JODY $968.88 WINTERS, TROY $1,619.74 WISE, NATHAN $1,935.31 WOOD, DANIEL $856.51 WRIGHT, PAUL $787.13 YATES, CASSANDRA $280.87