The URL can be used to link to this page

Home My WebLink About2017-03-20-J01A 03202017_bill list_payrollCity of Waukee Bill Presentation Recap March 20, 2017 Total Unpaid Bills Presented for Approval : $712,476.98 Total Checks Issued Prior to Council Approval: Regular Checks: A) Prior to Last Council Meeting $149,703.66 B) After Last Council Meeting $37,215.08 C) Payroll Taxes & Reimbursements $194,429.02 D) Utility Refunds $277.56 Payroll Checks Issued: E) 02128/2017 $170,966.59 W Grand Total: $1,265,068-89 � � � �� -7 FY 2017 Fund Recap: Expenditures Revenues Budgeted Year To Date Budgeted Year To Date 010 General Fund $ 9,736,705 $ 6,872,009 $ 9,520,350 $ 6,992,302 060 Road Use Tax Fund $ 2,145,066 $ 1,493,815 $ 1,822,167 $ 1,484,566 075 Waukee Foundation $ - $ 24 $ - $ 60,900 085 Asset Forfeitures $ - $ - $ - $ 172.00 091 Hickman West Indust Park TIF $ 421,355 $ - $ 576,400 $ 296,759 092 Enterprise Business Park TIF Fund $ 232,550 $ - $ 600 $ 686 093 Waukee Urban Renewal Area TIF Fund $ 2,988,360 $ 28,547 $ 2,780,500 $ 1,672,064 094 Gateway Urban Renewal $ - $ 8,093 $ - $ - 095 Autumn Ridge Urban Renewal $ - $ 521 $ - $ - 110 Debt Service Fund $ 6,951,481 $ 2,467,273 $ 6,999,755 $ 3,303,331 111 Special Assessments Fund $ 45,698 $ 43,739 $ 42,200 $ 28,462 210 Employee Benefits Fund $ 1,500,285 $ - $ 1,504,285 $ 835,068 327 Capital Projects $ 11,653,500 $ 4,433,005 $ 11,653,500 $ 1,249,046 330 City Wide SA Sidewalk Project $ - $ - $ - $ 5,025 510 Water Utility Fund $ 3,910,801 $ 2,370,051 $ 3,671,507 $ 3,185,636 520 Sewer Utility Fund $ 7,003,697 $ 5,102,396 $ 3,714,066 $ 3,545,651 521 University Ave Trunk Sewer Project $ - $ - $ - $ 5,462 522 Waste Water Treatment PI $ - $ - $ - $ 75 523 E Area Pump Sta Treatment $ - $ - $ - $ 264 540 Gas Utility Fund $ 5,590,810 $ 3,206,789 $ 5,491,100 $ 4,067,007 560 Storm Sewer Utility Fund $ 1,148,970 $ 342,368 $ 891,150 $ 579,449 570 Utility Bill Fund $ 264,790 $ 165,972 $ 264,750 $ 180,750 590 Solid Waste Collect & Rcycl Fund $ 1,081,760 $ 500,704 $ 1,101,160 $ 780,812 750 Goif Course Fund $ 507,595 $ 362,105 $ 592,300 $ 332,741 810 Equipment Revolving Fund $ - $ - $ 30,000 $ 288 Total: $ 55,183,423 $ 27,397,412 $ 50,655,790 $ 28,606,518 City of Waukee FY2017 Department Report - General Fund As of March 20th, 2017 Expended YTD Budgeted $ Remaining General Fund: Police Department Personnel Services $ 1,514,996 Supplies & Services $ 212,811 Capital Outlay $ 139,526 $ 1,867,332 $ 2,661,080 $ 793,748 Warning Sirens Personnel Services Supplies & Services $ (979) Capital Outlay $ (979) $ 2,000 $ 2,979 Westcom Dispatch Personnel Services Supplies & Services $ 347,319 Capital Outlay $ 347,319 $ 430,500 $ 83,181 Fire Department Personnel Services $ 483,766 Supplies & Services $ 57,520 Capital Outlay $ - $ 541,286 $ 830,720 $ 289,434 EMS Personnel Services $ 472,064 Supplies & Services $ 63,007 Capital Outlay $ - $ 535,071 $ 762,600 $ 227,529 Building Inspection Personnel Services $ 209,009 Supplies & Services $ 15,814 Capital Outlay $ 33,639 $ 258,462 $ 398,830 $ 140,368 Animal Control Personnel Services Supplies & Services $ 4,620 Capital Outlay $ 4,620 $ 1,000 $ (3,620) Library Services Personnel Services $ 380,003 Supplies & Services $ 131,635 Capital Outlay $ - $ 511,638 $ 852,275 $ 340,637 Mosquito Control Personnel Services $ Supplies & Services $ Capital Outlay $ - $ - $ 6,500 $ 6,500 Parks Personnel Services $ 168,241 Supplies & Services $ 109,376 Capital Outlay $ 69,648 $ 347,264 $ 480,297 $ 133,033 Recreation Personnel Services $ 232,734 Supplies & Services $ 121,784 Capital Outlay $ - $ 354,518 $ 523,662 $ 169,144 Community Center Personnel Services $ 2,350 Supplies & Services $ 10,033 Capital Outlay $ - $ 12,384 $ 24,320 $ 11,936 Public Works Personnel Services $ 39,023 Supplies & Services $ (10,988) Capital Outlay $ $ 28,035 $ 73,644 $ 45,609 Public Works Building Personnel Services $ - Supplies & Services $ 103,772 Capital Outlay $ 10,500 $ 114,272 $ - $ (114,272) Public Works Mechanic Personnel Services $ 117.755 Supplies & Services $ 120,606 Capital Outlay $ - $ 238,360 $ 171,750 $ (66,610) Median and Bldg Grounds Personnel Services Supplies & Services $ 6,924 Capital Outlay $ 6,924 $ 14,000 $ 7,076 Mayor & Council Personnel Services $ 23,003 Supplies & Services $ 6,782 Capital Outlay $ - $ 29,786 $ 72,840 $ 43,054 Elections Personnel Services $ Supplies & Services $ Capital Outlay $ - $ - $ 8,000 $ 8,000 Communications Personnel Services $ 37,046 Supplies & Services $ 2,058 Capital Outlay $ - $ 39,104 $ 114,808 $ 75,704 Administration Personnel Services $ 117,951 Supplies & Services $ 105,627 Capital Outlay $ 321,206 $ 544,784 $ 348,250 $ (196,534) City Hall Personnel Services $ - Supplies & Services $ 37,803 Capital Outlay $ 1,003 $ 38,806 $ 79,000 $ 40,194 Human Resources Personnel Services $ 39,042 Supplies & Services $ 6,134 Capital Outlay $ - $ 45,176 $ 80,138 $ 34,962 Financial Administration Personnel Services $ 74,293 Supplies & Services $ 16,640 Capital Outlay $ - $ 90,933 $ 198,922 $ 107,989 Community Development Personnel Services $ 149,223 Supplies & Services $ 84,707 Capital Outlay $ - $ 233,930 $ 324,240 $ 90,310 City Attorney Personnel Services $ - Supplies & Services $ 119,198 Capital Outlay $ - $ 119,198 $ 100,000 $ (19,198) Development Services Personnel Services $ 207,075 Supplies & Services $ 36,348 Capital Outlay $ - $ 243,423 $ 524,535 $ 281,112 Information Technology Personnel Services $ - Supplies & Services Capital Outlay $ 5,272 $ 5,272 $ - $ (5,272) Engineering Personnel Services $ 240,095 GIS Supplies & Services Capital Outlay Personnel Services Supplies & Services Capital Outlay Transfers to GO Debt Service $ 40,624 $ 12,924 $ 15,030 $ (6,506) $ 12,924 Total General Fund: Personnel Services $ 4,522,700 Supplies & Services $ 1,742,670 Capital Outlay $ 606,639.60 293,643 $ 625,139 $ 331,496 21,448 $ 27,655 $ 6,207 $ 6,872,009 $ 9,736,705 $ 2,864,696 $ 6,872,009 Expense Approval Register 06 City of Waukee, IA �t: APPKT00529 - MARCH 21ST COUNCIL PACKET lVflukee Vendor Name Payable Number Post Date Description (Item) Account Number Amount TREASURER STATE OF IOWA INV0002548 02/28/2017 FEB'17 WATER SALES TAXES 510-2030500 13,529.61 TREASURER STATE OF IOWA INV0002549 02/28/2017 FEB'17 SEWER SALES TAXES 520-2030500 2,269.18 TREASURER STATE OF IOWA INV0002550 02/28/2017 FEB'17 GAS SALES TAXES 540-2030500 6,106.83 TREASURER STATE OF IOWA INV0002551 02/28/2017 FEB'17 STORM WATER SALE 560-2030500 1,201.73 TREASURER STATE OF IOWA INV0002552 02/28/2017 FEB'17 GOLF SALES TAXES 7SO-2030500 636.78 23,744.13 Department: 1100 - POLICE OPERATIONS KELTEK INCORPORATED 14541 02/27/2017 INSTALL COMPUTER SYSTEM 010-10,1100.410100 1,748.08 INTERSTATE ALL BATTERY CE 1924603019497 03/10/2017 STORM SIREN BATTERIES 010-10.1100.410100 882.30 CARPENTER UNIFORM CO 434463 02/23/2017 EMBLEMS - LONG 010-10.1100.120000 26.00 CARPENTER UNIFORM CO 434670 02/27/2017 SHIRT/TROUSERS - GITZEN 010-10.1100.120000 142.98 THE WALDINGER CORP 5747507-1 02/22/2017 REPLACE BELT IN EXHAUST F 010-10.1100.400000 356.65 ELECTRONIC ENGINEERING C 80012473 03/O1/2017 MICRON RADIO SERVICES - 2 010-10.1100.410200 45.00 SAM'S CLUB 999999 03/08/2017 MARCH'17 STATEMENT (ME 010-10.1100.280000 45.00 CONSOLIDATED COMMUNIC INV0002567 03/08/2017 MARCH'17 STATEMENT - CI 010-10.1100.450000 49.22 CONSOLIDATED COMMUNIC INV0002567 03/08/2017 MARCH'17 STATEMENT - CI 010-10.1100.450000 48.71 AMERITAS LIFE INSURANCE INV0002587 03/01/2017 MAR'17 VISION INSURANCE 010-10.1100.100000 466.72 EMPLOYEE BENEFIT SYSTEM INV0002588 03/14/2017 APR'17 HEALTH INSURANCE 010-10.1100.100000 28,425.42 ACCESS SYSTEMS INV502571 02/23/2017 FEBRUARY'17 SERVICE FEE 010-10.1100.270100 465.20 ACCESS SYSTEMS INV502938 02/27/2017 DESKTOP COMPUTER 010-10.1100.540000 1,294.82 TASER INTERNATIONAL 511471153 02/20/2017 TASER 010-10.1100.540000 1,066.00 Department 1100 - POLICE OPERATIONS Total: 35,062.10 Department: 1400 - FIRE PROTECTION UNITED PARCEL SERVICE OOOOAW7647097 03/04/2017 SHIPPING 010-10.1400.360000 47.33 FIRE SERVICE TRAINING BUR 000779 02/28/2017 FF2-THAYER 010-10.1400.470000 50.00 GALL'SINC 007015033 02/17/2017 PANTS-NICELYGREEN 030-30.1400.120000 25.62 GALL'S INC 007032654 02/21/2017 SHIRT-ROBINSON 010-10.1400.120000 22.38 GALL'S INC 007032655 02/21/2017 SHIRT -KEN LARSON 010-10.1400.120000 22.64 CUMMINS CENTRAL POWER 020-82040 11/01/2016 FUELLEAK 010-10.1400.410000 49.07 MIDWEST BREATHING AIR, L 21060 03/06/2017 AIR TEST/MOISTURE KIT/FILT 010-10.1400.410100 632.89 KUM & GO 48869772 02/28/2017 FEBRUARY'17 STATEMENT 010-10.1400.570000 411.45 THE WALDINGER CORP 5746064-1 02/28/2017 REPLACE WATER HEATER 010-10.1400.400000 690.66 LIBERTY READY MIX 83077 03/01/2017 CONCRETE/WINTER HEAT 010-10.1400.400000 1,434.38 LIBERTY READY MIX 83109 03/02/2017 CONCRETE/WINTER HEAT 010-10.1400.400000 1,434.38 MIDWEST AUTOMATIC FIRE 89534 02/28/2017 BACKFLOW PROGRAM/INSP 010-10.1400.400000 109.01 NAPA AUTO PARTS STORE 918766 03/09/2017 AIR BRAKE DRYER REPAIR KIT 010-10.1400.410000 100.14 NAPA AUTO PARTS STORE 918934 03/09/2017 RETURN CORE DEPOSIT 010-10.1400.410000 -37.00 CAPITAL SANITARY SUPPLY C228798 03/02/2017 BLEACH/FABRIC SOFTENER 010-10.1400.590000 114.91 TOYNEINC IN0004356 12/28/2016 AIR COMPRESSOR/VALVE RE 010-10,1400.410000 903.51 WAUKEE HARDWARE & VARI INV0002556 02/28/2017 FEBRUARY'17 STATEMENT- 010-10.1400.410100 70.79 WAUKEE HARDWARE & VARI INV0002557 01/31/2017 JANUARY'17 STATEMENT- F 010-10.1400.410100 2.29 CONSOLIDATED COMMUNIC INV0002567 03/08/2017 MARCH'17 STATEMENT - CI 010-10.1400.450000 45.63 CONSOLIDATED COMMUNIC INV0002567 03/08/2017 MARCH'17 STATEMENT - CI 010-10.1400.450000 49.22 AMERITAS LIFE INSURANCE INV0002587 03/O1/2017 MAR'17 VISION INSURANCE 010-10.1400.100000 100.68 EMPLOYEE BENEFIT SYSTEM INV0002588 03/14/2017 APR'17 HEALTH INSURANCE 010-10.1400.100000 5,249.50 ACCESS SYSTEMS INV502571 02/23/2017 FEBRUARY'17 SERVICE FEE 010-10.1400.270100 175.02 Department 1400 - FIRE PROTECTION Total: 11,704.60 Department: 1500 - EMS UNITED PARCEL SERVICE OOOOAW7647097 03/04/2017 SHIPPING 010-10.1500.360000 47.34 GALL'S INC 007015033 02/17/2017 PANTS-NICELYGREEN 010-10.1500.120000 25.62 GALL'S INC 007032654 02/21/2017 SHIRTROBINSON010-10.1500.120000 22.39 GALL'S INC 007032655 02/21/2017 SHIRT -KEN LARSON 010-10.1500.120000 22.63 FRUSA EMS 10601 03/10/2017 FEBRUARY'17 AMBULANCE 010-10.1500.231800 1,568.06 3/15/2017 10:36:32 AM Page 1 of 12 Expense Approval Register Packet: APPKT00529 - MARCH 21ST COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount INTERSTATE ALL BATTERY CE 1924603019497 03/10/2017 STORM SIREN BATTERIES 010-10.1500.410100 882.30 KUM&GO 48869772 02/28/2017 FEBRUARY'17 STATEMENT 010-10.1500.570000 411.44 THE WALDINGER CORP 5746064-1 02/28/2017 REPLACE WATER HEATER 010-10.1500.400000 690.66 U-SELECT-IT 58872931 03/06/2017 ANNUAL RENEWAL MONITO 010-10.1500.270000 1,200.00 LIBERTY READY MIX 83077 03/01/2017 CONCRETE/WINTER HEAT 010-10.1500.400000 1,434.38 LIBERTY READY MIX 83109 03/02/2017 CONCRETE/WINTER HEAT 010-10.1500.400000 1,434.38 MIDWEST AUTOMATIC FIRE 89534 02/28/2017 BACKFLOW PROGRAM/INSP 010-10.1500.400000 109.01 CONSOLIDATED COMMUNIC INV0002567 03/08/2017 MARCH'17 STATEMENT -CI 010-10.1500.450000 45.63 CONSOLIDATED COMMUNIC INV0002567 03/08/2017 MARCH'17 STATEMENT -CI 010-10.1500.450000 49.22 IOWA MEDICAID INV0002578 03/21/2017 REFUND INCIDENT 15-1231 010-10.1500.3529900 158.94 MERCY WEST PHARMACY INV0002584 03/01/2017 EMS MEDICATIONS 010-10.1500.590050 341.96 AMERITAS LIFE INSURANCE INV0002587 03/01/2017 MAR'17 VISION INSURANCE 010-10.1500.100000 100.67 EMPLOYEE BENEFITSYSTEM INV0002588 03/14/2017 APR'17 HEALTH INSURANCE 010-10.1500.100000 5,249.59 ACCESS SYSTEMS INV502571 02/23/2017 FEBRUARY'17 SERVICE FEE 010-10.1500.270100 144.93 Department 1500 - EMS Total: 13,939.15 Department: 1600 - STREET LIGHTING MIDAMERICAN ENERGY 300210217 02/22/2017 FEBRUARY'17 STATEMENT 060-30.1600.480000 4.16 MID AMERICAN ENERGY FEB171600SUMBILL 02/24/2017 FEBRUARY'17 STATEMENT 060-30.1600.480000 15,352.16 Department 1600 - STREET LIGHTING Total: 15,356.32 Department: 1601- TRAFFIC SIGNALS SNYDER & ASSOCIATES INC 116.0901.01-5 02/24/2017 US H WY 6 & W ESTGATE DR 1 327-90.1601.235030 4,440.00 MID AMERICAN ENERGY FEB171601SUMBILL 02/24/2017 FEBRUARY'17 STATEMENT 060-30.1601.480000 346.62 Department 1601 - TRAFFIC SIGNALS Total: 4,786.62 Department: 1900 - BUILDING INSPECTION INTERNATIONAL CODE COU 3134291 02/28/2017 MEMBER DUES - BRAD DEFT 010-10.1900.280000 135.00 OFFICE DEPOT 909594267001 03/02/2017 ENVELOPES/CALCULATOR/M 010-10.1900.580000 82.82 HEARTLAND CO-OP INV0002559 02/28/2017 FEBRUARY'17 STATEMENT- 010-10.1900.570000 169.61 HEARTLAND CO-OP INV0002560 01/31/2017 JANUARY'17 STATEMENT-B 010-10.1900.570000 189.66 IOWA DEPT OF TRANSPORTA INV0002562 01/12/2017 SOILS TECHNICIAN RECERTIFI 010-10.1900.470000 75.00 AMERITAS LIFE INSURANCE INV0002587 03/O1/2017 MAR'17 VISION INSURANCE 010-10.1900.100000 75.84 EMPLOYEE BENEFITSYSTEM INV0002588 03/14/2017 APR'17 HEALTH INSURANCE 010-10.1900.100000 3,954.30 ACCESS SYSTEMS INV502571 02/23/2017 FEBRUARY'17 SERVICE FEE 010-10.1900.270100 66.98 Department 1900 - BUILDING INSPECTION Total: 4,749.21 Department: 2130 - ALICES ROAD PROJECT GATEHOUSE MEDIA IOWA H 0000176554 02/26/2017 FEBRUARY'17 PUBLICATION 327-90.2130.840490 24.75 CIVIL ENGINEERING CONSUL 0021788-IN 01/31/2017 ESKER RIDGE DRIVE PROJECT 327-90.2130.230051 6,671.00 CIVIL ENGINEERING CONSUL 0021858-IN 02/28/2017 ESKER RIDGE DRIVE PROJECT 327-90.2130.230051 850.00 IOWA PLAINS SIGNING INC 33888 02/23/2017 PCMS-1500LP MATRIX CMS/ 327-90.2130.840490 35,134.00 FOTH INFRASTRUCTURE & E 51403 02/22/2017 PHASE 1 MAINLINE CONSTR 327-90.2130.230020 2,024.72 FOTH INFRASTRUCTURE & E 51404 02/22/2017 PHASE 3 ALICES RD TRAFFIC 327-90.2130.840470 576.00 FOTH INFRASTRUCTURE&E 51408 02/22/2017 ALICES RD STREET LIGHTING 327-90.2130.230020 158.00 KIRKHAM MICHAEL & ASSOC 86222 02/28/2017 ALICES RD INTRCHNG/IJR/FN 327-90.2130.230000 5,330.88 Department 2130 - ALICES ROAD PROJECT Total: 50,769.35 Department: 2131- ESKER RIDGE - RISE PROJECT FOTH INFRASTRUCTURE & E 51409 02/22/2017 SE ESKER RIDGE DRIE RISE PR 327-90.2131.230051 1,117.24 Department 2131- ESKER RIDGE - RISE PROJECT Total: 1,117.24 Department: 2150 - PARK & REC COMPLEX CONFLUENCE 13890 02/28/2017 PLANNING ADDENDUM S 327-90.2150.980110 2,680.18 BISHOP ENGINEERING 21717 02/28/2017 WAUKEE HIGH SCHOOL 2 327-90.2150.980110 28,535.65 FOTH INFRASTRUCTURE & E 51407 02/22/2017 HIGH SCHOOL NO.2/CITY RE 327-90.2150.980110 1,678.00 Department 2150 - PARK & REC COMPLEX Total: 32,893.83 Department: 3100 - LIBRARY SERVICES OCLC, INC 0000518910 02/28/2017 CATALOGING & METADATA 010-40.3100.590000 147.38 FAREWAY STORES, INC. 00046624 03/08/2017 AIAX/POPCORN 010-40.3100.460300 3.80 BAKER MECHANICAL, INC. 130375 02/28/2017 REPAIR HUMIDIFIER HOSE 010-40.3100.400000 448.00 ORKIN PEST CONTROL 154542072 03/20/2017 PEST CONTROLSERVICES -U 010-40.3100.400000 65.97 WASH -ECLAIR 186072 03/06/2017 WASH LIBRARY WINDOWS 010-40.3100.400100 38.00 RANKIN COMMUNICATION S 226560 01/26/2017 RELOCATE LIBRARY PHONE 010-40.3100.400000 107.15 3/15/2017 10:36:32 AM Page 2 of 12 Expense Approval Register Packet: APPKT00529 - MARCH 21ST COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount MID AMERICAN ENERGY S20160217 02/17/2017 FEBRUARY'17 STATEMENT 010-40.3100.480000 2,643.59 PLASTEK CARDS INC 59739 03/07/2017 RESIDENT/KIDS/EDUCATORS 010-40.3100.590000 1,273.05 OFFICE DEPOT 908425702001 02/24/2017 SIGN/TISSUE/PAPER/LABLES 010-40.3100.580000 353.96 CONSOLIDATED COMMUNIC INV0002567 03/08/2017 MARCH'17 STATEMENT -CI 010-40.3100.450000 49.22 CONSOLIDATED COMMUNIC INV0002567 03/08/2017 MARCH'17 STATEMENT -CI 010-40.3100.450000 157.76 AMERITAS LIFE INSURANCE INV0002587 03/O1/2017 MAR'17 VISION INSURANCE 010-40.3100.100000 126.96 EMPLOYEE BENEFIT SYSTEM INV0002588 03/14/2017 APR'17 HEALTH INSURANCE 010-40.3100.100000 7,383.71 ACCESS SYSTEMS INV502571 02/23/2017 FEBRUARY'17 SERVICE FEE 010-40.3100.270100 172.09 DISCOUNT SCHOOL SUPPLY P35394990101 02/28/2017 CLOROX/PIPE CLEARNERS/ST 010-40.3100.460300 125.26 BILL RHINER'S PLUMBING RHIN-039708 02/21/2017 CLEANED/REASSEMBLE FAU 010-40.3100.400000 156.50 Department 3100 - LIBRARY SERVICES Total: 13,252.40 Department: 4100 - PARKS GATEHOUSE MEDIA IOWA H 0000176554 02/26/2017 FEBRUARY'17 PUBLICATION 010-40.4100.210000 60.00 CONFLUENCE 13917 03/02/2017 DOG PARK/TRAIL 327-90.4100.880070 799.47 IOWA ASSOCIATION OF MU 14572 03/01/2017 CIASSO MARCH'17- MAY'1 010-40.4100.470000 342.27 G&LCLOTHING 2-178626 03/03/2017 PANTS-PIZINGER 010-40.4100.120000 199.08 BDI SIGNS BUSINESS DESIGN 31676 02/13/2017 MAX METAL CUT PRINTED G 010-40.4100.410300 260.00 MULCH MART 38111 03/06/2017 PLAY MATCERTIFIED 010-40.4100.410300 496.00 MENARDS 71584 02/21/2017 P-HANDLE 600LB CAPACITY 010-40.4100.410300 29.99 MENARDS 71585 02/21/2017 OPEN S-HOOK/STRAIGHT LIN 010-40.4100.410300 35.15 MENARDS 72205 02/28/2017 LINEN SHELF KIT/PARTS 010-40.4100.410300 35.59 FULLER PETROLEUM SERVIC 99323 03/03/2017 FUEL 010-40.4100.570000 351.95 SAM'S CLUB 999999 03/08/2017 MARCH'17 STATEMENT (ME 010-40.4100.280000 45.00 MID AMERICAN ENERGY FEB174100SUMBILL 02/24/2017 FEBRUARY'17 STATEMENT 010-40.4100.480000 303.36 FASTENAL COMPANY IAGRM86047 03/O1/2017 PARTS 010-40.4100.540000 6.00 CONSOLIDATED COMMUNIC INV0002567 03/08/2017 MARCH'17 STATEMENT - CI 010-40.4100.450000 14.64 HEARTLAND CO-OP INV0002580 02/28/2017 FEBRUARY'17 STATEMENT- 010-40.4100.570000 388.56 WAUKEE HARDWARE & VARI INV0002583 02/28/2017 FEBRUARY'17 STATEMENT- 010-40.4100.410300 19.44 AMERITAS LIFE INSURANCE INV0002587 03/O1/2017 MAR'17 VISION INSURANCE 010-40.4100.100000 27.24 AMERITAS LIFE INSURANCE INV0002587 03/O1/2017 MAR'17 VISION INSURANCE 010-40.4100.100000 2.14 AMERITAS LIFE INSURANCE INV0002587 03/O1/2017 MAR'17 VISION INSURANCE 010-40.4100.100000 10.68 EMPLOYEE BENEFIT SYSTEM INV0002588 03/14/2017 APR'17 HEALTH INSURANCE 010-40.4100.100000 1,420.34 EMPLOYEE BENEFIT SYSTEM INV0002588 03/14/2017 APR'17 HEALTH INSURANCE 010-40.4100.100000 284.07 EMPLOYEE BENEFIT SYSTEM INV0002588 03/14/2017 APR'17 HEALTH INSURANCE 010-40.4100.100000 556.81 ACCESS SYSTEMS INV502571 02/23/2017 FEBRUARY'17 SERVICE FEE 010-40.4100.270100 121.29 Department 4100 - PARKS Total: 5,809.07 Department: 4200 - RECREATION FAREWAY STORES, INC. 00223906 03/03/2017 MARCH SOCIAL SUPPLIES 010-40.4200.460500 56.13 STUDIO BEA DANCE 1548 02/18/2017 2 TO MOVE 010-40,4200.460550 448,00 JM IMPRESSIONS 2017-02 02/28/2017 PARKS &REC SPRING/SUMM 010-40.4200.350100 1,200.00 CHRISTIAN PRINTERS INC 35917 02/24/2017 PARKS & REC SPRING/SUMM 010-40.4200.350100 5,174.22 SAM'S CLUB 999999 03/08/2017 MARCH'17 STATEMENT (ME 010-40.4200.280000 90.00 GEORGIA SYSOUCHANH INV0002541 02/10/2017 LITTLE NINJAS REFUND 010-40.4200.460550 30.00 LAURIE SENN INV0002542 02/10/2017 REFUND ENGINEERING PRO 010-40.4200.460550 45.00 KYLIE BARNETT INV0002543 02/23/2017 KARATE REFUND 010-40.4200.460550 35.00 HEARTLAND CO-OP INV0002581 02/28/2017 FEBRUARY'17 STATEMENT- 010-40.4200.570000 37.73 BREANNA ELAM LLC INV0002582 03/02/2017 B-BAL SESSION JAN-MARCH' 010-40.4200.460550 326.40 AMERITAS LIFE INSURANCE INV0002587 03/O1/2017 MAR'17 VISION INSURANCE 010-40.4200.100000 65.16 EMPLOYEE BENEFIT SYSTEM INV0002588 03/14/2017 APR'17 HEALTH INSURANCE 010-40.4200.100000 3,397.49 ACCESS SYSTEMS INV502571 02/23/2017 FEBRUARY'17 SERVICE FEE 010-40.4200.270100 106.28 Department 4200 - RECREATION Total: 11,011.41 Department: 5300-STORM WATER FOTH INFRASTRUCTURE & E 51399 02/22/2017 CENTENNIAL PARK STREAM 560-80.5300.880015 688.00 FOTH INFRASTRUCTURE&E 51405 02/22/2017 CENTENNIAL PARK STREAM 560-80.5300.880015 3,238.00 HEARTLAND CO-OP INV0002564 02/28/2017 FEBRUARY'17 STATEMENT- 560-80.5300.570000 112.89 AMERITAS LIFE INSURANCE INV0002587 03/O1/2017 MAR'17 VISION INSURANCE 560-80.5300.100000 7.82 AMERITAS LIFE INSURANCE INV0002587 03/O1/2017 MAR'17 VISION INSURANCE 560-80.5300.100000 47.84 EMPLOYEE BENEFIT SYSTEM INV0002588 03/14/2017 APR'17 HEALTH INSURANCE 560-80.5300.100000 2,749.08 EMPLOYEE BENEFIT SYSTEM INV0002588 03/14/2017 APR'17 HEALTH INSURANCE 560-80.5300.100000 494.29 3/15/2017 10:36:32 AM Page 3 of 12 Expense Approval Register Packet: APPKT00529 - MARCH 21ST COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount ACCESS SYSTEMS INV502571 02/23/2017 FEBRUARY'17 SERVICE FEE 560-80.5300.270100 153.72 Department 5300 - STORM WATER Total: 7,491.64 Department: 6000-PUBLIC WORKS SAM'S CLUB 999999 03/08/2017 MARCH'17 STATEMENT (ME 010-20.6000.280000 90.00 WAUKEE HARDWARE & VARI INV0002570 02/28/2017 FEBRUARY'17 STATEMENT- 010-20.6000.590000 6.99 HEARTLAND CO-OP INV0002572 02/28/2017 FEBRUARY'17 STATEMENT- 010-20.6000.570000 176.42 AMERITAS LIFE INSURANCE INV0002587 03/01/2017 MAR'17 VISION INSURANCE 010-20.6000.100000 102.32 EMPLOYEE BENEFIT SYSTEM INV0002588 03/14/2017 APR'17 HEALTH INSURANCE 010-20.6000.100000 5,589.76 ACCESS SYSTEMS INV502571 02/23/2017 FEBRUARY'17 SERVICE FEE 010-20.6000.270100 13.61 Department 6000 - PUBLIC WORKS Total: 5,979.10 Department: 6010 - PUBLIC WORKS BUILDING ORKIN PEST CONTROL 154541896 03/20/2017 PEST CONTROL SERVICES -P 010-20.6010.400000 84.99 DESIGN ALLIANCE INC 204863 03/02/2017 WAUKEE PUB. WORKS - CAT 010-20.6010.230000 892.85 FIRST CHOICE COFFEE SERVI 292932 03/02/2017 COFFEE 010-20.6010.580000 60.28 MMIT BUSINESS SOLUTIONS 301785 03/03/2017 KIP-3000 010-20.6010.580000 278.30 INGERSOLL RAND 30582221 02/15/2017 AIRCARE ADVANTAGE FEB'1 010-20.6010.400000 602.09 CINTAS CORPORATION 5007291727 02/24/2017 FIRST AID SUPPLIES 010-20.6010.400000 230.62 SCHNEIDER ELECTRIC 5046280 02/17/2017 FEB'17 - OCT'17 WXSENTRY 010-20.6010.400000 337.90 41MPRINT, INC. 5268061 03/07/2017 MISSING ON INV 13451283 010-20.6010.590000 45.00 HILLYARD INC 602427535 02/17/2017 TOILET PAPER/TOWELS 010-20.6010.410100 185.84 HILLYARD INC 602437371 02/27/2017 SOAP 010-20.6010.400000 62.28 OFFICE DEPOT 902582516001 02/13/2017 FOLDERS/DUSTERS 010-20.6010.580000 77.03 OFFICE DEPOT 906161137001 02/14/2017 RETURN DUSTER 010-20.6010.580000 -14.44 OFFICE DEPOT 906447250001 02/16/2017 BINDER/PAPER/TAPE/BINDE 010-20.6010.580000 159.02 FASTENALCOMPANY IAGRM85560 02/14/2017 GLOVES/EYE WEAR/VESTS 010-20.6010.590000 430.11 CONSOLIDATED COMMUNIC INV0002567 03/08/2017 MARCH'17 STATEMENT - CI 010-20.6010.450000 142.18 CONSOLIDATED COMMUNIC INV0002567 03/08/2017 MARCH'17 STATEMENT - CI 010-20.6010.450000 442.99 CONSOLIDATED COMMUNIC INV0002569 03/01/2017 MARCH'17 STATEMENT 010-20.6010.450000 133.55 HEARTLAND CO-OP INV0002572 02/28/2017 FEBRUARY'17 STATEMENT- 010-20.6010.590000 40.00 Department 6010 - PUBLIC WORKS BUILDING Total: 4,190.59 Department: 6150 - PUBLIC WORKS MECHANIC CFA SOFTWARE, INC 13423 03/01/2017 CFAWIN8 SUPPORT/MAINTE 010-20.6150.270100 2,995.00 G & LCLOTHING 2-178361 02/18/2017 JEANS - BAKER 010-20.6150.120000 134.91 MIDWEST UNDERGROUND S CD02149 12/29/2016 JOYSTICK 010-20.6150.570130 -922.09 MIDWEST UNDERGROUND S IM20857 12/27/2016 JOYSTICK+CO 010-20.6150.570130 935.96 MIDWEST UNDERGROUND S INTEREST 03/01/2017 INTERESTCHARGES 010-20,6150.570130 7.86 HEARTLAND CO-OP INV0002573 02/28/2017 FEBRUARY'17 STATEMENT- 010-20.6150.570000 139.50 AMERITAS LIFE INSURANCE INV0002587 03/01/2017 MAR'17 VISION INSURANCE 010-20.6150.100000 37.92 EMPLOYEE BENEFIT SYSTEM INV0002588 03/14/2017 APR'17 HEALTH INSURANCE 010-20.6150.100000 1,977.15 LOGAN CONTRACTORS SUPP L81716 02/07/2017 26" CUT 010-20.6150.570130 -227.68 LOGAN CONTRACTORS SUPP L92844 02/15/2017 V-BELT/FRONT SUPPORT/RU 010-20.6150.570130 207.72 Department 6150 - PUBLIC WORKS MECHANIC Total: 5,286.25 Department: 6510 - WATER UTILITY CONSTRUCTION&AGGREGA 0292388-IN 02/24/2017 CHAIN -GRAB HOOKS 510-30.6510.590000 81.50 MUNICIPAL SUPPLY, INC. 0649594-IN 02/27/2017 C2 OMNI COMP MTR/PARTS 510-30.6510.592000 2,727.60 IOWA ASSOCIATION OF MU 14572 03/01/2017 CIASSO MARCH'17-MAY'1 510-30.6510.470000 342.27 IOWA ONE CALL 189238 03/08/2017 FEBRUARY'17 STATEMENT 510-30.6510.340000 130.55 PLUMB SUPPLY COMPANY 4385782 02/20/2017 2"GALV. 45 ELL 510-30.6510.590000 15.62 PLUMB SUPPLY COMPANY 4386218 02/20/2017 2" BLACK REGULAR PLUG 510-30.6510.590000 3.15 FULLER PETROLEUM SERVIC 99323 03/03/2017 FUEL 510-30.6510.570000 351.94 MID AMERICAN ENERGY FEB176510SUMBILL 02/24/2017 FEBRUARY'17 STATEMENT 510-30.6510.480000 497.59 DES MOINES WATER WORKS INV0002534 02/22/2017 4TH QTR 2016 WSS O&M 510-30.6510.650010 19,393.64 DES MOINES WATERWORKS INV0002535 02/27/2017 FEBRUARY'17 STATEMENT 510-30.6510.650000 53,988.46 DES MOIN ES WATER WORKS INV0002536 02/27/2017 FEBRUARY'17 STATEMENT 510-30.6510.650000 7,112.65 HEARTLAND CO-OP INV0002575 02/28/2017 FEBRUARY'17 STATEMENT- 510-30.6510.570000 454.60 AMERITAS LIFE INSURANCE INV0002587 03/01/2017 MAR'17 VISION INSURANCE 510-30.6510.100000 13.62 AMERITAS LIFE INSURANCE INV0002587 03/01/2017 MAR'17 VISION INSURANCE 510-20.6510.100000 34.60 AMERITAS LIFE INSURANCE INV0002587 03/01/2017 MAR'17 VISION INSURANCE 510-30.6510.100000 7.82 AMERITAS LIFE INSURANCE INV0002587 03/01/2017 MAR'17 VISION INSURANCE 510-30.6510.100000 20.60 3/15/2017 10:36:32 AM Page 4 of 12 Expense Approval Register Packet: APPKT00529. MARCH 21ST COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount EMPLOYEE BENEFIT SYSTEM INV0002588 03/14/2017 APR'17 HEALTH INSURANCE 510-30.6510.100000 1,420.34 EMPLOYEE BENEFIT SYSTEM INV0002588 03/14/2017 APR'17 HEALTH INSURANCE 510-30.6510,100000 710.17 EMPLOYEE BENEFIT SYSTEM INV0002588 03/14/2017 APR'17 HEALTH INSURANCE 510-30.6510,100000 494.29 EMPLOYEE BENEFIT SYSTEM INV0002588 03/14/2017 APR'17 HEALTH INSURANCE 510-30.6510.100000 1,931.35 DES MOINES WATER WORKS INV0002589 03/10/2017 LAB ANALYSIS FEES 510-30.6510.250000 300.00 ACCESS SYSTEMS INV502571 02/23/2017 FEBRUARY'17 SERVICE FEE 510-30.6510.270100 821.79 Department 6510 - WATER UTILITY Total: 90,854.15 Department: 6520 - SANITARY SEWERS & TREATMENT GATEHOUSE MEDIA IOWA H 0000176554 02/26/2017 FEBRUARY'17 PUBLICATION 520-30.6520.883060 32.71 GATEHOUSE MEDIA IOWA H 0000176554 02/26/2017 FEBRUARY'17 PUBLICATION 520-30.6520.883080 30.50 GATEHOUSE MEDIA IOWA H 0000176554 02/26/2017 FEBRUARY'17 PUBLICATION 520-30.6520.883091 32.71 ELECTRIC PUMP &TOOL INC 0872676-IN 02/17/2017 MECHANICAL SEAL/GASKET/ 520-30.6520.411100 1,399.51 ELECTRIC PUMP &TOOL INC 0872774-IN 02/15/2017 MEMBRANE 520-30.6520.411100 282.74 WINCAN LLC 1137 02/27/2017 ANNUAL SERVICE SUPPORT 520-30.6520.280000 1,500.00 IOWA ASSOCIATION OF MU 14572 03/01/2017 CIASSO MARCH'17-MAY'1 520-30.6520,470000 342.27 USA BLUE BOOK 181526 02/14/2017 PRESSURE GAUGE 520-30.6520.411300 127.53 MIDWEST ENVIRONMENTAL 20170168 02/26/2017 WASTEWATER SAMPLE ANA 520-30.6520.250000 1,184.00 MID-IOWA SOLID WASTE EQ 43499 02/28/2017 SEWER TOOLS/BLADES/SAW 520-30.6520,410400 653.66 ELECTRICAL ENGINEERING E 4935827-00 12/29/2016 GEL 520-30.6520.590000 148.80 ELECTRICAL ENGINEERING E 4980979-00 02/15/2017 GEL 520-30.6520.590000 99.72 MENARDS 72123 02/27/2017 OSB PANEL 520-30.6520.590000 38.43 AHLERS & COONEY PC 725406 02/28/2017 FOX CREEKTRUNK SEWER- 520-30.6520.883080 1,800.00 AHLERS & COONEY PC 725408 02/28/2017 LITTLE WALNUT CREEK ERGI 520-30.6520.883060 1,800.00 FULLER PETROLEUM SERVIC 99323 03/03/2017 FUEL 520-30.6520.570000 351.94 MID AMERICAN ENERGY FEB176520SUMBILL 02/24/2017 FEBRUARY'17 STATEMENT 520-30.6520.480000 7,461.16 CONSOLIDATED COMMUNIC INV0002567 03/08/2017 MARCH'17STATEMENT- CI 520-30.6520.450000 145.12 WAUKEE HARDWARE & VARI INV0002570 02/28/2017 FEBRUARY'17 STATEMENT- 520-30.6520.590000 49.05 WAUKEE HARDWARE & VARI INV0002570 02/28/2017 FEBRUARY'17 STATEMENT- 520-30.6520.590000 44.97 HEARTLAND CO-OP INV0002574 02/28/2017 FEBRUARY'17 STATEMENT- 520-30.6520.570000 369.68 AMERITAS LIFE INSURANCE INV0002587 03/01/2017 MAR'17 VISION INSURANCE 520-30.6520.100000 13.62 AMERITAS LIFE INSURANCE INV0002587 03/01/2017 MAR'17 VISION INSURANCE 520-30.6520.100000 7.82 AMERITAS LIFE INSURANCE INV0002587 03/01/2017 MAR'17 VISION INSURANCE 520-30.6520.100000 41.20 AMERITAS LIFE INSURANCE INV0002587 03/01/2017 MAR'17 VISION INSURANCE 520-30.6520.100000 34.60 EMPLOYEE BENEFIT SYSTEM INV0002588 03/14/2017 APR'17 HEALTH INSURANCE 520-30.6520.100000 2,657.48 EMPLOYEE BENEFIT SYSTEM INV0002588 03/14/2017 APR'17 HEALTH INSURANCE 520-30.6520.100000 1,931.35 EMPLOYEE BENEFIT SYSTEM INV0002588 03/14/2017 APR'17 HEALTH INSURANCE 520-30.6520.100000 494.29 EMPLOYEE BENEFIT SYSTEM INV0002588 03/14/2017 APR'17 HEALTH INSURANCE 520-30.6520.100000 710.17 ACCESS SYSTEMS INV502571 02/23/2017 FEBRUARY'17 SERVICE FEE 520-30.6520.270100 675.79 Department 6520 - SANITARY SEWERS & TREATMENT Total: 24,459.82 Department: 6540 - GAS UTILITY IOWA ASSOCIATION OF MU 14572 03/01/2017 CIASSO MARCH'17- MAY'1 540-30.6540.470000 342.27 IOWA ONE CALL 189238 03/08/2017 FEBRUARY'17 STATEMENT 540-30.6540.340000 130.55 INFRASOURCE CONSTRUCTI 3015936 02/25/2017 WELDER/WELDING RING 540-30.6540.880100 591.55 PLUMB SUPPLY COMPANY 4381156 02/16/2017 IP BALL VALVE FULL PORT 540-30.6540.590000 18.87 GRAINGER PARTS 9375964773 03/02/2017 MEASURING WHEEL 540-30.6540.590000 80.82 INDUSTRIALSALES COMPAN 972480-000 02/16/2017 TAPE NON-DETECTYEL 3" 540-30.6540.590200 242.00 CLAYTON ENERGY CORPORA 9799 03/13/2017 FEBRUARY'17 COMMODITY 540-30.6540.650000 167,733.80 FULLER PETROLEUM SERVIC 99323 03/03/2017 FUEL 540-30.6540.570000 351.94 MID AMERICAN ENERGY FE8176540SUMBILL 02/24/2017 FEBRUARY'17 STATEMENT 540-30.6540.480000 131.65 UTILITY SAFETY AND DESIGN IN20170459 02/28/2017 FEBRUARY'17 RETANER FEE 540-30.6540.230000 175.00 MIDWEST UNDERGROUND 5 INTEREST 03/01/2017 INTEREST CHARGES 540-30.6540.410100 7.86 CONSOLIDATED COMMUNIC INV0002567 03/08/2017 MARCH'17 STATEMENT -CI 540-30.6540.450000 72.56 WAUKEE HARDWARE &VAR[ INV0002570 02/28/2017 FEBRUARY'17 STATEMENT- 540-30.6540.590000 9.99 HEARTLAND CO-OP INV0002576 02/28/2017 FEBRUARY'17 STATEMENT- 540-30.6540.570000 456.53 AMERITAS LIFE INSURANCE INV0002587 03/01/2017 MAR'17 VISION INSURANCE 540-30,6540.100000 108.96 AMERITAS LIFE INSURANCE INV0002587 03/01/2017 MAR'17 VISION INSURANCE 540-30.6540.100000 7.82 AMERITAS LIFE INSURANCE INV0002587 03/01/2017 MAR'17 VISION INSURANCE 540-30.6540.100000 13.62 EMPLOYEE BENEFIT SYSTEM INV0002588 03/14/2017 APR'17 HEALTH INSURANCE 540-30.6540.100000 5,681.36 EMPLOYEE BENEFITSYSTEM INV0002588 03/14/2017 APR'17 HEALTH INSURANCE 540-30.6540.100000 494.29 EMPLOYEE BENEFIT SYSTEM INV0002588 03/14/2017 APR'17 HEALTH INSURANCE 540-30.6540.100000 710.16 3/15/2017 10:36:32 AM Page 5 of 12 Expense Approval Register Packet: APPKT00529 - MARCH 215T COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount ACCESS SYSTEMS INV502571 02/23/2017 FEBRUARY'17 SERVICE FEE 540-30.6540.270100 1,052.83 M I DWEST UN DERG ROU NO S RD15722 12/19/2016 BELT/PARTS 540-30.6540.410100 549.10 DITCH WITCH-IOWA INC 503918 03/02/2017 OILER ASSEMBLY 540-30.6540.410200 283.10 Department 6540 - GAS UTILITY Total: 179,246.63 Department: 6550 - UTILITY BILLING PITNEY BOWES 1003519604 03/11/2017 LETTER OPENER MAITENANC 570-30.6550.410100 126.00 UNIVERSAL PRINTING SERVI 47571 03/13/2017 AUTOPAY STATEMENTS 570-30.6550.350100 513.91 OFFICE DEPOT 909594267001 03/02/2017 ENVELOPES/CALCULATOR/M 570-30.6550.580000 37.99 AMERITAS LIFE INSURANCE INV0002587 03/01/2017 MAR'17 VISION INSURANCE 570-30,6550.100000 37.92 EMPLOYEE BENEFIT SYSTEM INV0002588 03/14/2017 APR'17 HEALTH INSURANCE 570-30.6550.100000 1,977.15 ACCESS SYSTEMS INV502571 02/23/2017 FEBRUARY'17 SERVICE FEE 570-30.6550.270100 59.62 Department 6550 - UTILITY BILLING Total: 2,752.59 Department: 7100-STREETS GRIMES ASPHALT & PAVING 11948 02/17/2017 COLD MIX 060-30.7100.590400 830.74 IOWA ASSOCIATION OF MU 14572 03/O1/2017 CIASSO MARCH'17-MAY'1 060-30.7100.470000 342.27 IOWA SIGNAL INC 3500 02/24/2017 INSTALL LED LUMINAIRES 060-30.7100.410300 1,371.66 IOWA DEPT OF TRANSPORTA 39200 02/22/2017 SIGN TUBING/ANCHOR 060-30.7100.590600 1,424.50 FULLER PETROLEUM SERVIC 99323 03/03/2017 FUEL 060-30.7100.570000 351.95 WAUKEE HARDWARE & VARI INV0002570 02/28/2017 FEBRUARY'17 STATEMENT- 060-30.7100.590000 26.77 HEARTLAND CO-OP INV0002571 02/28/2017 FEBRUARY'17STATEMENT - 060-30.7100.570000 945.08 AMERITAS LIFE INSURANCE INV0002587 03/O1/2017 MAR'17 VISION INSURANCE 060-30.7100.100000 13.62 AMERITAS LIFE INSURANCE INV0002587 03/O1/2017 MAR'17 VISION INSURANCE 060-30.7100.100000 1.07 AMERITAS LIFE INSURANCE INV0002587 03/01/2017 MAR'17 VISION INSURANCE 060-30.7100.100000 92.40 EMPLOYEE BENEFIT SYSTEM INV0002588 03/14/2017 APR'17 HEALTH INSURANCE 060-30.7100.100000 142.03 EMPLOYEE BENEFIT SYSTEM INV0002588 03/14/2017 APR'17 HEALTH INSURANCE 060-30.7100.100000 4,817.83 EMPLOYEE BENEFIT SYSTEM INV0002588 03/14/2017 APR'17 HEALTH INSURANCE 060-30.7100.100000 710.17 ACCESS SYSTEMS INV502571 02/23/2017 FEBRUARY'17 SERVICE FEE 060-30.7100.270100 356.66 LOGAN CONTRACTORS SUPP L85240 02/28/2017 PLACER/BUTTON CLIP/KNEE 060-30.7100.590000 1,448.34 Department 7100 - STREETS Total: 12,875.09 Department: 7730 - SE WESTO W N PKWY CONSTRUCTION FOTH INFRASTRUCTURE & E 51406 02/22/2017 WESTOWN PKWY/SE PARKVI 327-90.7730.230000 18,570.95 AHLERS & COONEY PC 725405 02/28/2017 SE WESTOWN PKWY EXTNSN 327-90.7730.230000 1,800.00 Department 7730 - SE W ESTOWN PKWY CONSTRUCTION Total: 20,370.95 Department: 78SO - TIF DEBT SERVICE AHLERS & COONEY PC 725189 02/28/2017 KC KETTLESTONE, LLC DA 094-30.7850.230000 97.50 Department 7850 - TIF DEBT SERVICE Total: 97.50 Department: 8030 - DEVELOPER REIMBURSEMENT PROJECTS FOTH INFRASTRUCTURE & E 51472 02/28/2017 SE ALICES RD/SE UNIV. AVE/ 327-90.8030.230000 35,701.78 Department 8030 - DEVELOPER REIMBURSEMENT PROJECTS Total: 35,701.78 Department: 8200 - COMMUNICATIONS LIVING MAGAZINES 366047 02/O1/2017 WAUKEE NEWSLETTER 010-60.8200.210000 730.00 LIVING MAGAZINES 368003 02/O1/2017 ALICE'S RD AD 010-60.8200.210000 289.00 AMERITAS LIFE INSURANCE INV0002587 03/01/2017 MAR'17 VISION INSURANCE 010-60.8200.100000 27.24 EMPLOYEE BENEFIT SYSTEM INV0002588 03/14/2017 APR'17 HEALTH INSURANCE 010-60.8200.100000 1,420.34 FLYNN WRIGHT INV-95240 02/28/2017 KETTLESTONE WEB HOSTING 010-60.8200.230010 50.00 Department 8200 - COMMUNICATIONS Total: 2,516.58 Department: 8300 - ADMINISTRATION GATEHOUSE MEDIA IOWA H 0000176554 02/26/2017 FEBRUARY'17 PUBLICATION 010-60.8300.210000 658.67 UNITED PARCEL SERVICE OOOOAW7647097 03/04/2017 SHIPPING 010-60.8300.360000 67.46 OFFICE DEPOT 906624952001 02/17/2017 CERTIFICATES 010-60,8300.590000 35.96 OFFICE DEPOT 906625118001 02/16/2017 FOLDERS/SEALS/CUPS/PAPE 010-60.8300.580000 104.19 OFFICE DEPOT 909594267001 03/02/2017 ENVELOPES/CALCULATOR/M 010-60.8300.580000 52.35 OFFICE DEPOT 909594267001 03/02/2017 ENVELOPES/CALCULATOR/M 010-60.8300.580000 37.70 SECRETARY OF STATE INV0002538 03/02/2017 NOTARY RENEWAL-SCHUET 010-60.8300.280000 30.00 MEDIACOM INV0002540 02/28/2017 FEBRUARY'17 STATEMENT 010-60.8300.270000 139.95 DALLAS COUNTY RECORDER INV0002561 02/28/2017 FEBRUARY'17 RECORDING F 010-60.8300.230000 3,135.00 AMERITAS LIFE INSURANCE INV0002587 03/01/2017 MAR'17 VISION INSURANCE 010-60.8300.100000 47.84 EMPLOYEE BENEFITSYSTEM INV0002588 03/14/2017 APR'17 HEALTH INSURANCE 010-60.8300.100000 2,749.08 3/15/2017 10:36:32 AM Page 6 of 12 Expense Approval Register Packet: APPKT00529 - MARCH 21ST COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount ACCESS SYSTEMS INV502571 02/23/2017 FEBRUARY'17 SERVICE FEE 010-60.8300.270100 2,411.10 IMAGETEK INC KJF3801243 02/28/2017 RADIX SUBSCRIPTION/STOR 010-60.8300.270000 576.00 Department 8300 - ADMINISTRATION Total: 10,045.30 Department: 8310 - CITY HALL G&KSERVICES INC 1183676898 03/08/2017 MAT SERVICES - CITY HALL 010-60.8310.400000 36.00 AAA AWARDS & EMBROIDER 8748 03/02/2017 ENGRAVED NAME PLATE -B 010-60.8310.590000 7.00 OFFICE DEPOT 906625118001 02/16/2017 FOLDERS/SEALS/CUPS/PAPS O10-60.8310.590000 5.38 OFFICE DEPOT 908571526001 02/23/2017 CREAMER/PENS 010-60.8310.590000 16.89 OFFICE DEPOT 909594267001 03/02/2017 ENVELOPES/CALCULATOR/M 010-60.8310.590000 10.41 MID AMERICAN ENERGY FEB178310SU M BILL 02/24/2017 FEBRUARY'17 STATEMENT 010-60.8310.480000 391.95 ALLIANCE CONNECT INVO002537 03/O1/2017 MARCH'17 STATEMENT 010-60.8310.450000 49.00 CONSOLIDATED COMMUNIC INV0002567 03/08/2017 MARCH'17 STATEMENT -CI 010-60.8310.450000 216.58 CONSOLIDATED COMMUNIC INV0002567 03/08/2017 MARCH'17 STATEMENT -CI 010-60.8310.450000 344.56 Department 8310 - CITY HALL Total: 1,077.77 Department: 8350 - HUMAN RESOURCES AMERITAS LIFE INSURANCE INV0002587 03/01/2017 MAR'17 VISION INSURANCE 010-60.8350.100000 10.68 EMPLOYEE BENEFIT SYSTEM INV0002588 03/14/2017 APR'17 HEALTH INSURANCE 010-60.8350.100000 556.81 ACCESS SYSTEMS INV502571 02/23/2017 FEBRUARY'17 SERVICE FEE 010-60.8350.270100 12.82 Department 8350 - HUMAN RESOURCES Total: 580.31 Department: 8400 - FINANCIAL ADMINISTRATION GATEHOUSE MEDIA IOWA H 0000176554 02/26/2017 FEBRUARY'17 PUBLICATION 010-60.8400.210000 117.14 REGISTER MEDIA 0010150311 02/26/2017 FEBRUARY'17 STATEMENT 030-60.8400.210000 127.14 SAM'S CLUB 999999 03/08/2017 MARCH'17 STATEMENT (ME 010-60.8400.280000 45.00 AMERITAS LIFE INSURANCE INV0002587 03/O1/2017 MAR'17 VISION INSURANCE 010-60.8400.100000 58.52 EMPLOYEE BENEFITSYSTEM INV0002588 03/14/2017 APR'17 HEALTH INSURANCE 010-60.8400.100000 3,305.89 ASSOCIATION OF GOVERNM INV0002590 03/15/2017 '17 SPRING SEMINAR-BRUNS 010-60.8400.470000 120.00 ACCESS SYSTEMS INV502571 02/23/2017 FEBRUARY'17 SERVICE FEE 010-60.8400.270100 32.15 Department 8400 - FINANCIAL ADMINISTRATION Total: 3,805.84 Department: 8500. COMMUNITY DEVELOPMENT AHLERS & COONEY PC 725186 02/28/2017 PROJECT DEVELOPMENT AG 010-50.8500.230000 5,259.00 AMERITAS LIFE INSURANCE INV0002587 03/O1/2017 MAR'17 VISION INSURANCE 010-50.8500.100000 37.92 EMPLOYEE BENEFITSYSTEM INV0002588 03/14/2017 APR'17 HEALTH INSURANCE 010-50.8500.100000 2,613.78 ACCESS SYSTEMS INV502571 02/23/2017 FEBRUARY'17 SERVICE FEE 010-50.8500.270100 49.30 Department 8500 - COMMUNITY DEVELOPMENT Total: 7,960.00 Department: 8600 - CITY ATTORNEY BRICK GENTRY BOWERS SW 225326 02/25/2017 FEBRUARY'17 STATEMENT 010-60.8600.230000 13,686.78 Department 8600 - CITY ATTORNEY Total: 13,686.78 Department: 8700 - DEVELOPMENT SERVICES HOISINGTON KOEGLER GRO O16-056-4 03/11/2017 WAUKEE COMPREHENSIVE P O10-50.8700.230000 15,236.74 AMERICAN PLANNING ASSO 137680-1711 01/27/2017 APA/AICP MEMBERSHIP & 1 010-50.8700.280000 474.00 NELSEN APPRAISAL ASSOCIA 201702-06 03/08/2017 PROPERTY APPRAISAL 010-50.8700.230000 2,000.00 OFFICE DEPOT 908571526001 02/23/2017 CREAMER/PENS 010-50.8700.580000 36.70 AMERITAS LIFE INSURANCE INV0002587 03/01/2017 MAR'17 VISION INSURANCE 010-50.8700.100000 65.16 EMPLOYEE BENEFITSYSTEM INV0002588 03/14/2017 APR'17 HEALTH INSURANCE 010-50.8700.100000 3,397.49 ACCESS SYSTEMS INV502571 02/23/2017 FEBRUARY'17 SERVICE FEE 010-50.8700.270100 86.43 Department 8700 - DEVELOPMENT SERVICES Total: 21,296.52 Department: 8750 - SUGAR CREEK MUNICIPAL GOLF COURSE SUPERINTEND 00197 02/15/2017 MEMBERSHIP RENEWAL - EL 750-80.8750.280000 125.00 BOLTON & MENK, INC 0200281 02/24/2017 GOLF COURSE BRIDGE 750-80.8750.880070 4,214.00 INTERSTATE BATTERY SYSTE 10148236 03/03/2017 BATTERY 750-80.8750.410360 177.90 ZIMCO SUPPLY CO 105382 02/27/2017 CHEMICALS 750-80.8750.590100 180.00 ZIMCO SUPPLY CO 105384 02/27/2017 COTTON TEE TOWELS/ROPE 750-80.8750,410300 307.70 CORELL CONTRACTOR INC 21936 02/15/2017 ASPHALT 750-80.8750,590200 442.69 CORELL CONTRACTOR INC 21948 02/28/2017 ASPHALT 750-80.8750.590200 438.88 CHEMSEARCH 2605755 02/02/2017 ELECTRA COAT AEROSOL/DU 750-80.8750.400000 434.24 DIRECTV 30796421498 03/O1/2017 MARCH'17 STATEMENT GOL 750-80.8750.400000 21.14 BDI SIGNS BUSINESS DESIGN 31610 02/13/2017 GOLF CART STICKERS 750-80.8750.410360 187.50 PRESTIGE FLAG 426807 01/05/2017 TOURNAMENT POLES 750-80.8750.590000 142.10 3/15/2017 10:36:32 AM Page 7 of 12 Expense Approval Register Packet: APPKT00529 - MARCH 21ST COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount PRESTIGE FLAG 426903 01/05/2017 RANGE FLAGS/CART FLAGS/ 750-80.8750.590000 141.80 DAVE'S FIREWOOD & DISTRI 714001 03/12/2017 POND WORK -AN 30-MARC 750-80.8750.880000 21,191.53 MENARDS 72298 03/01/2017 PAINT/BELT/BRUSH/GLOSS/ 750-80.8750.590000 93.20 MENARDS 72337 03/01/2017 BOLT/SEALANT/FIR 750-80.8750.410300 84.18 MENARDS 72521 03/03/2017 ABRASIVE BLASTING CRYSTA 750-80.8750.410300 23.97 OFFICE DEPOT 908073508001 02/22/2017 ENVELOPES/INK/STAPLES/TA 750-80.8750.580000 216.85 NAPA AUTO PARTS STORE 916271 02/27/2017 AIR FILTER/OIL FILTER 750-80.8750.570100 66.04 NAPA AUTO PARTS STORE 916275 02/27/2017 NAPA 30W30 QT 750-80.8750.570100 50.75 NAPA AUTO PARTS STORE 918842 03/09/2017 CREDIT ON TAX CHARGED IN 750-80.8750.570100 -3.74 NAPA AUTO PARTS STORE 918844 03/09/2017 CREDIT ON TAX CHARGED IN 750-80.8750.570100 -2.87 R & R PRODUCTS INC CD2095653 02/24/2017 BLADE 750-80.8750.410100 634.68 R & R PRODUCTS INC CD2096037 02/27/2017 ROLLER 750-80.8750.410100 151.13 MID AMERICAN ENERGY FEB178750SUMBILL 02/24/2017 FEBRUARY'17 STATEMENT 750-80.8750.480000 272.58 HEARTLAND CO-OP INV0002579 02/28/2017 FEBRUARY'17 STATEMENT- 750-80.8750.410100 54.20 WAUKEE HARDWARE & VARI INV0002583 02/28/2017 FEBRUARY'17 STATEMENT- 750-80.8750.400000 91.55 AMERITAS LIFE INSURANCE INV0002587 03/O1/2017 MAR'17 VISION INSURANCE 750-80A750.100000 7.48 EMPLOYEE BENEFIT SYSTEM INV0002588 03/14/2017 APR'17 HEALTH INSURANCE 750-80.8750.100000 994.24 ACCESS SYSTEMS INV502571 02/23/2017 FEBRUARY'17 SERVICE FEE 750-80.8750.270100 149.89 DAVIS EQUIPMENTCORPOR J116897 02/28/2017 OIL FILTER/ROLLER/22"ALU 750-80.8750.410100 466.29 DAVIS EQUIPMENTCORPOR JI36897 02/28/2017 OIL FILTER/ROLLER/22"ALU 750-80.8750.570100 11.57 DAVIS EQUIPMENT CORPOR WC00672 02/09/2017 RAINBIRD PROJECT 750-80.8750.880000 -1,500.00 DAVIS EQUIPMENTCORPOR WE01918 11/21/2016 RAINBIRD PROJECT 750-80.8750.880000 2,050.23 DAVIS EQUIPMENT CORPOR W110380 03/06/2017 O'RING 750-80.8750.410350 397.12 DAVIS EQUIPMENT CORPOR W110385 03/06/2017 ADAPTERS 750-80.8750.410350 21.00 Department 8750 - SUGAR CREEK MUNICIPAL Total: 32,334.82 Department: 8900 - ENGINEERING HEARTLAND CO-OP INV0002565 02/28/2017 FEBRUARY'17 STATEMENT- 010-20.8900.570000 529.37 IOWA DEPT OF TRANSPORTA INV0002566 01/10/2017 PCC LEVEL II CERTIFICATION 010-20.8900.470000 400.00 AMERITAS LIFE INSURANCE INV0002587 03/01/2017 MAR'17 VISION INSURANCE 010-20.8900.100000 75.84 EMPLOYEE BENEFIT SYSTEM INV0002588 03/14/2017 APR'17 HEALTH INSURANCE 010-20.8900.100000 3,954.30 ACCESS SYSTEMS INV502571 02/23/2017 FEBRUARY'17 SERVICE FEE 010-20.8900.270100 100.54 Department 8900 - ENGINEERING Total: 5,060.05 Department: 8950 - GIS HEARTLAND CO-OP INV0002563 02/28/2017 FEBRUARY'17 STATEMENT- 010-20.8950.570000 38.76 AMERITAS LIFE INSURANCE INV0002587 03/01/2017 MAR'17 VISION INSURANCE 010-20.8950.100000 10.68 EMPLOYEE BENEFIT SYSTEM INV0002588 03/14/2017 APR'17 HEALTH INSURANCE 010-20.8950.100000 556.81 ACCESS SYSTEMS INV502571 02/23/2017 FEBRUARY'17 SERVICE FEE 010-20.8950.270100 5.24 Department 8950 - GIS Total: 611.49 Grand Total: 712,476.98 3/15/2017 10:36:32 AM Page 8 of 12 Expense Approval Register Packet: APPKT00S29 - MARCH 21ST COUNCIL PACKET Fund Summary Fund O10-GENERAL FUND 060-ROAD USE TAX FUND 094-GATEWAY URBAN RENEWAL 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 750-GOLF COURSE FUND Account Number 010-10.1100.100000 010-10.1100.120000 010-10.1100.270100 010-10.1100.280000 010-10.1100.400000 010-10.1100.410100 010-10.1100.410200 010-10.1100.450000 010-10.1100.540000 010-10.1400.100000 010-10.1400.120000 010-10.1400.270100 010-10.1400.360000 010-10.1400.400000 010-10.1400.410000 010-10.1400.410100 010-10.1400.450000 010-10.1400.470000 010-10.1400.570000 010-10.1400.590000 010-10.1500.100000 010-10.1500.120000 010-10.1500.231800 010-10.1500.270000 010-10.1500.270100 010-10.1500.3529900 010-10.1500.360000 010-10.1500.400000 010-10.1500.410100 010-10.1500.450000 010-10.1500.570000 010-10.1500.590050 010-10.1900.100000 010-10.1900.270100 010-10.1900.280000 010-10.1900,470000 010-10.1900.570000 010-10.1900.580000 010-20.6000.100000 010-20.6000.270100 010-20.6000.280000 010-20.6000.570000 010-20.6000.590000 010-20.6010.230000 010-20.6010.400000 Grand Total: Account Summary Account Name HEALTH & LIFE INSURAN UNIFORMS COMPUTER SUPPORT DUES, MEMBERSHIPS & REPAIR/MAINTENANCE REPAIR/MAINTENANCE REPAIR/MAINTENANCE TELEPHONE MINOR EQUIPMENT HEALTH & LIFE INSURAN UNIFORMS COMPUTER SUPPORT POSTAGE & SHIPPING REPAIR/MAINTENANCE REPAIR OF VEHICLES REPAIR/MAINTENANCE TELEPHONE TRAINING/TRAVEL EXPE FUEL OPERATING SUPPLIES & HEALTH & LIFE INSURAN UNIFORMS AMBULANCE BILLING FE DATA PROCESSING COMPUTER SUPPORT AMBULANCE TRANSPOR POSTAGE & SHIPPING REPAIR/MAINTENANCE REPAIR/MAINTENANCE TELEPHONE FUEL MEDICAL SUPPLIES HEALTH & LIFE INSURAN COMPUTER SUPPORT DUES, MEMBERSHIPS & TRAINING/TRAVEL EXPE FUEL OFFICE SUPPLIES HEALTH & LIFE INSURAN COMPUTER SUPPORT DUES, MEMBERSHIPS & FUEL OPERATING SUPPLIES & CONSULTANT & PROFES REPAIR/MAINTENANCE Expense Amount 176,825.05 28,578.03 97.50 146,092.62 104,383.76 26,729.00 185,353.46 8,693.37 2,752.59 32,971.60 712,476.98 Expense Amount 28,892.14 168.99 465.20 45.00 356.65 2,630.38 45.00 97.93 2,360.82 5,350.28 70.64 175.02 47.33 3,668.43 11015.72 705.97 94.85 50.00 411.45 114.91 5,350.26 70.64 1,568.06 1,200.00 144.93 158.94 47.34 3,668.43 882.30 94.85 411.44 341.96 4,030.14 66.98 135.00 75.00 359.27 82.82 5,692.08 13.61 90.00 176.42 6.99 892.85 1,317.88 3/15/2017 10:36:32 AM Page 9 of 12 Expense Approval Register Packet: APPKT00529 - MARCH 21ST COUNCIL PACKET Account Summary Account Number Account Name Expense Amount 010-20.6010.410100 REPAIR/MAINTENANCE 185.84 010-20.6010.450000 TELEPHONE 718.72 010-20.6010.580000 OFFICE SUPPLIES 560.19 010-20.6010.590000 OPERATING SUPPLIES & 515.11 010-20.6150.100000 HEALTH & LIFE INSURAN 2,015.07 010-20.6150.120000 UNIFORMS 134.91 010-20.6150.270100 COMPUTERSUPPORT 2,995.00 010-20.6150.570000 FUEL 139.50 010-20.6150.570130 COGS - PARTS 1.77 010-20.8900.100000 HEALTH & LIFE INSURAN 4,030.14 010-20.8900.270100 COMPUTER SUPPORT 100.54 010-20.8900.470000 TRAINING/TRAVEL EXPE 400.00 010-20.8900.570000 FUEL 529.37 010-20.8950.100000 HEALTH & LIFE INSURAN 567.49 010-20.8950.270100 COMPUTER SUPPORT 5.24 010-20.8950.570000 FUEL 38.76 010-40.3100.100000 HEALTH & LIFE INSURAN 7,510.67 010-40.3100.270100 COMPUTER SUPPORT 172.09 010-40.3100.400000 REPAIR/MAINTENANCE 777.62 010-40.3100.400100 CUSTODIAL SERVICES 38.00 010-40.3100.450000 TELEPHONE 206.98 010-40.3100.460300 PROGRAMS 129.06 010-40.3100.480000 UTILITY SERVICES 2,643.59 010-40.3100.580000 OFFICE SUPPLIES 353.96 010-40.3100.590000 OPERATING SUPPLIES & 1,420.43 010-40.4100.100000 HEALTH & LIFE INSURAN 2,301.28 010-40.4100.120000 UNIFORMS 199.08 010-40.4100.210000 PUBLIC NOTIFICATION/A 60.00 010-40.4100.270100 COMPUTER SUPPORT 121.29 010-40.4100.280000 DUES, MEMBERSHIPS & 45.00 010-40.4100.410300 REPAIR/MAINTENANCE 876.17 010-40.4100.450000 TELEPHONE 14.64 010-40.4100.470000 TRAINING/TRAVEL EXPE 342.27 010-40.4100.480000 UTILITY SERVICES 303.36 010-40.4100.540000 MINOR EQUIPMENT 6.00 010-40.4100.570000 FUEL 740.51 010-40.4200.100000 HEALTH & LIFE INSURAN 3,462.65 010-40.4200.270100 COMPUTERSUPPORT 106.28 010-40.4200.280000 DUES, MEMBERSHIPS& 90.00 010-40.4200.350100 PRINTING 6,374.22 010-40.4200.460500 SUMMER RECREATION P 56.13 010-40.4200.460550 WINTER RECREATION PR 884.40 010-40.4200.570000 FUEL 37.73 010-50.8500.100000 HEALTH & LIFE INSURAN 2,651.70 010-50.8500.230000 CONSULTANT & PROFES 5,259.00 010-50.8500.270100 COMPUTERSUPPORT 49.30 010-50.8700.100000 HEALTH & LIFE INSURAN 3,462.65 010-50.8700.230000 CONSULTANT&PROFES 17,236.74 010-50.8700.270100 COMPUTER SUPPORT 86.43 010-50.8700.280000 DUES, MEMBERSHIPS& 474.00 010-50.8700.580000 OFFICE SUPPLIES 36.70 O10-60.8200.100000 HEALTH & LIFE INSURAN 1,447.58 010-60.8200.210000 PUBLIC NOTIFICATION/A 1,019.00 010-60.8200.230010 WEBSITE DEVELOPMENT 50.00 010-60.8300.100000 HEALTH & LIFE INSURAN 2,796.92 010-60.9300.210000 PUBLIC NOTIFICATION/A 658.67 010-60.8300.230000 CONSULTANT &PROFES 31135.00 010-60.8300.270000 DATA PROCESSING 715.95 3/15/2017 10:36:32 AM Page 10 of 12 Expense Approval Register Packet: APPKT00529 - MARCH 21ST COUNCIL PACKET Account Summary Account Number Account Name Expense Amount 010-60.8300.270100 COMPUTER SUPPORT 2,411.10 010-60.8300.280000 DUES, MEMBERSHIPS & 30.00 010-60.8300.360000 POSTAGE & SHIPPING 67.46 010-60.8300.580000 OFFICE SUPPLIES 194.24 010-60.8300.590000 OPERATING SUPPLIES & 35.96 010-60.8310.400000 REPAIR/MAINTENANCE 36.00 010-60.8310.450000 TELEPHONE 610.14 010-60.8310.480000 UTILITY SERVICES 391.95 010-60.8310.590000 OPERATING SUPPLIES & 39.68 010-60.8350.100000 HEALTH & LIFE INSURAN 567.49 010-60.8350.270100 COMPUTER SUPPORT 12.82 010-60.8400.100000 HEALTH & LIFE INSURAN 3,364.41 010-60.8400.210000 PUBLIC NOTIFICATION/A 244.28 010-60.8400.270100 COMPUTER SUPPORT 32.15 010-60.8400.280000 DUES, MEMBERSHIPS& 45.00 O10-60.8400.470000 TRAINING/TRAVEL EXPE 120.00 010-60.8600.230000 CONSULTANT&PROFES 13,686.78 060-30.1600.480000 UTILITY SERVICES 15,356.32 060-30.1601.480000 UTILITY SERVICES 346.62 060-30.7100.100000 HEALTH & LIFE INSURAN 5,777.12 060-30.7100.270100 COMPUTER SUPPORT 356.66 060-30.7100.410300 REPAIR/MAINTENANCE 1,371.66 060-30.7100.470000 TRAINING/TRAVEL EXPE 342.27 060-30.7100.570000 FUEL 1,297.03 060-30.7100.590000 OPERATING SUPPLIES & 1,475.11 060-30.7100.590400 ROAD REPAIR -PATCH 830.74 060-30.7100.590600 STREET SIGNS 1,424.50 094-30.7850.230000 CONSULTANT/PROFESSI 97.50 327-90.1601.235030 HICKMAN & WESTGATE 4,440.00 327-90.2130.230000 CONSULTANT & PROFES 5,330.88 327-90.2130.230020 CONSULTING-ASHWORT 2182.72 327-90.2130.230051 CONSULTING - ESKER RD 7:521.00 327-90.2130.840470 ALICES RD-ENHANCE AS 576.00 327-90.2130.840490 ALICES RD -UNIV TO OL 35,158.75 327-90.2131.230051 CONSULTING -ESKER RID 11117.24 327-90.2150.980110 HS REC COMPLEX - CON 32,893.83 327-90.4100.880070 DOG PARK - CONSULTIN 799.47 327-90.7730.230000 CONSULTANT & PROFES 20,370.95 327-90.8030.230000 DEVELOPER LANE ADDIT 35,701.78 510-2030500 SALES TAX COLLECTED P 13,529,61 510-30.6510.100000 HEALTH & LIFE INSURAN 4,632.79 510-30.6510.250000 TESTING FEES 300.00 510-30.6510.270100 COMPUTER SUPPORT 821.79 510-30.6510.340000 MISCELLANEOUS CONTR 130.55 510-30.6510.470000 TRAINING/TRAVEL EXPE 342.27 510-30.6510.480000 UTILITY SERVICES 497.59 510-30.6510.570000 FUEL 806.54 510-30.6530.590000 OPERATING SUPPLIES & 100.27 510-30.6510.592000 METER PURCHASE 2,727.60 510-30.6510.650000 COST OF GOODS SOLD 61,101.11 510-30.6510.650010 DSMWW OPERATING & 19,393.64 520-2030500 SALES TAX COLLECTED P 2,269.18 520-30.6520.100000 HEALTH & LIFE INSURAN 5,890.53 520-30.6520.250000 TESTING FEES 1,184.00 520-30.6520.270100 COMPUTER SUPPORT 675.79 520-30,6520.280000 DUES, MEMBERSHIPS& 1,500.00 520-30.6520.410400 REPAIR/MAINT OF DELIV 653.66 520-30.6520.411100 REPAIR/MAINTENANCE 1,682.25 3/15/2017 10:36:32 AM Page 11 of 12 Expense Approval Register Packet: APPKT00529 - MARCH 215T COUNCIL PACKET Account Summary Account Number Account Name Expense Amount 520-30.6520.411300 TREATMENT PLANT PRO 127.53 520-30.6520.450000 TELEPHONE 145.12 520-30.6520.470000 TRAINING/TRAVEL EXPE 342.27 520-30.6520.480000 UTILITY SERVICES 7,461,16 520-30.6520.570000 FUEL 721.62 520-30.6520.590000 OPERATING SUPPLIES & 379.97 520-30.6520.883060 LITTLE WALNUT CREEK S 1,832.71 520-30.6520.883080 FOX CREEK SEWER 1,830.50 520-30.6520.883091 NW AREA TRUNK SEWE 32.71 540-2030500 SALES TAX COLLECTED P 6,106.83 540-30.6540A00000 HEALTH & LIFE INSURAN 7,016.21 540-30.6540.230000 CONSULTANT&PROFES 175.00 540-30.6540.270100 COMPUTER SUPPORT 1,052.83 540-30.6540.340000 MISCELLANEOUS CONTR 130.55 540-30.6540.410100 REPAIR/MAINTENANCE 556.96 540-30.6540.410200 REPAIR/MAINTENANCE 283.10 540-30.6540.450000 TELEPHONE 72.56 540-30.6540.470000 TRAINING/TRAVEL EXPE 342.27 540-30.6540.480000 UTILITY SERVICES 131.65 540-30.6540.570000 FUEL 808.47 540-30.6540.590000 OPERATING SUPPLIES& 109.68 540-30.6540.590200 INSTALLATION MATERIA 242.00 540-30.6540.650000 COST OF GOODS SOLD 167,733.80 540-30.6540.880100 DISTRIBUTION SYSTEM 1 591.55 560-2030500 SALES TAX COLLECTED P 1,201.73 560-80.5300.100000 HEALTH & LIFE INSURAN 3,299.03 560-80.5300.270100 COMPUTER SUPPORT 153.72 560-80.5300.570000 FUEL 112.89 560-80.5300.880015 CENTENNIAL PARK STRE 3,926.00 570-30.6550.100000 HEALTH & LIFE INSURAN 2,015.07 570-30.6550.270100 COMPUTER SUPPORT 59.62 570-30.6550.350100 PRINTING 513.91 570-30.6550.410300 REPAIR/MAINTENANCE 126.00 570-30.6550.580000 OFFICE SUPPLIES 37.99 750-2030500 SALES TAX COLLECTED P 636.78 750-80.8750.100000 HEALTH & LIFE INSURAN 1,001.72 750-80.8750.270100 COMPUTER SUPPORT 149.89 750-80.8750.280000 DUES, MEMBERSHIPS & 125.00 750-80.8750.400000 REPAIR/MAINTENANCE 546.93 750-80,8750.410100 REPAIR/MAINTENANCE 1,306.30 750-80.8750.410300 REPAIR/MAINTENANCE 415.85 750-80.8750.410350 REPAIR/MAINTENANCE I 418.12 750-80.8750.410360 REPAIR/MAINTENANCE 365.40 750-80,8750.480000 UTILITY SERVICES 272.58 750-80.8750.570100 OIL/FILTERS/LURE 121.75 750-80.8750.580000 OFFICE SUPPLIES 216.85 750-80.8750.590000 OPERATING SUPPLIES & 377.10 750-80.8750.590100 CHEMICAL/FERTILIZER 180.00 750-80.8750.590200 SAND AND MILLINGS 881.57 750-80.8750.880000 FACILITIES 21,741.76 750-80.8750.880070 GOLF COURSE BRIDGE P 4,214.00 Grand Total: 712,476.98 Project Account Summary Project Account Key Expense Amount **None** 712,476.98 Grand Total: 712,476.98 3/15/2017 10:36:32 AM Page 12 of 12 11 City of Waukee, IA Vendor Number Vendor Name Bank Code: AP-WAUKEE STATE 103450 JETHRO'S BBO Payable# Payable Type Account Number INV0002528 Invoice 010-20,6000,470000 010-20,8900.470000 060-30.7100,470000 510-30.6510.470000 520-30.6520.470000 540-30.6540.470000 560-80.5300.470000 Payment Date Payment Type 03/02/2017 Regular Payable Date Payable Description Account Name Item Description 03/02/2017 SAFETY DAY LUNCH TRAINING/TRAVEL EXPEN SAFETY DAY LUNCH TRAINING/TRAVEL EXPEN SAFETY DAY LUNCH TRAINING/TRAVEL EXPEN SAFETY DAY LUNCH TRAINING/1-RAVEL EXPEN SAFETY DAY LUNCH TRAINING/TRAVEL EXPEN SAFETY DAY LUNCH TRAINING/TRAVEL EXPEN SAFETY DAY LUNCH TRAINING/TRAVEL EXPEN SAFETY DAY LUNCH My Check Report By Check Number Date Range: 03/02/2017 - 03/06/2017 Discount Amount PaymentAmount Number 0.00 215.66 127959 DiscountAmount Payable Amount Distribution Amount 0.00 215.66 30.80 30.81 30.81 30.81 30.81 30.81 30.81 047095 OLE FOUR WAY, LC �03/02/2017 Regular 0.00 13,781.00 127960 Payable # Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0002530 Invoice 02/27/2017 PURCHASE AG REEMENT 0.00 13,780.00 327-90.2130.840490 ALICES RD -UNIV TO OLS PURCHASE AGREEMENT 13,780.00 INV000253,1 Invoice 02/27/2017 CONSTRUCTION EASEMENT 0.00 1.00 327-90.2130.840490 ALICES RD-UNIV TO OLS CONSTRUCTION EASEMENT 1.00 237750 WILLIAMS POINTE COMMERCIAL I, LC 03/02/2017 Regular 0.00 58,426.00 127961 Payable# Payable Type Payable Date Payable Description DiscountAmount Payable Amount Account Number Account Name Item Description Distribution Amount INV0002465 Invoice 02/24/2017 PURCHASE AGREEMENT PARCEL 13 0.00 53,632.00 327-90.2130.840490 ALICES RD -UNIV TO OLS PURCHASE AGREEMENT PARCEL 53,632.00 INV0002466 Invoice 02/24/2017 UTILITY EASEMENT 0.00 4,793.00 327-90.2130.840490 ALICES RD- UNIVTO OLS UTILITY EASEMENT 4,793.00 INV0002467 Invoice 02/24/2017 CONSTRUCTION EASEMENT 0.00 1.00 327-90.2130.840490 ALICES RD -UNIV TO OLS CONSTRUCTION EASEMENT 1.00 237755 WILLIAMS POINTE COMMERCIAL II, LC 03/02/2017 Regular 0.00 76,281.00 127962 Payable# Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0002468 Invoice 02/24/2017 PURCHASE AGREEMENT PARCEL 14 0.00 76,280.00 327-90.2130.840490 ALICES RD -UNIV TO OLS PURCHASE AGREEMENT PARCEL 76,280.00 INV0002470 Invoice 02/24/2017 TEMP CONSTRUCTION EASEMENT 0.00 1.00 327-90.2130.840490 ALICES RD -UNIV TO OILS TEMP CONSTRUCTION EASEME 1.00 232728 WAUKEE COMMUNITY SCHOOL 03/06/2017 Regular 0.00 500.00 127964 Payable# Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0002532 Invoice 03/06/2017 WAUKEE ELEMENTARY SCHOOL KIDS CHA 0.00 500.00 010-40.4200.460900 FALL FESTIVAL WAUKEE ELEMENTARY SCHOOL 500.00 232728 WAUKEE COMMUNITY SCHOOL 03/06/2017 Regular 0.00 500.00 127965 3/15/2017 11:11:43 AM Page 1 of 3 My Check Report 41 Date Range: 03/02/2017 - 03/06/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 INV0002533 Invoice 03/06/2017 MAPLE GROVE ELEMENTARY KIDS CHALLE 0.00 500.00 010-40.4200.460900 FALL FESTIVAL MAPLE GROVE ELEMENTARY KI 500.00 Bank Code AP Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 10 6 0.00 149,703.66 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 10 6 0.00 149,703.66 3/15/2017 11:11:43 AM Page 2 of 3 My Check Report Date Range: 03/02/2017 - 03106/2017 Fund Summary Fund Name Period Amount 999 POOLED CASH 3/2017 149,703.66 149,703.66 3/15/2017 11:11:43 AM Page 3 of 3 3 My Check Report ` City Of Waukee, IA By Check Number .i r Date Range: 03/08/2017 - 03/15/2017 Waukee Vendor Number Vendor Name Payment Date Payment Type DiscountAmount Payment Amount Number Bank Code: AP-WAUKEE STATE 086725 BEN LIN AND HELEN STINSON HOM 03/08/2017 Regular 0.00 31,713.00 128092 Payable # Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0002379 Invoice 02/07/2017 SANITARY SEWER EASEMENT 0.00 29,400.00 520-30.6520.883000 OUTFALL CONNECTION F SANITARY SEWER EASEMENT 29,400.00 INV0002380 Invoice 520-30.6520.883000 02/07/2017 CONSTRUCTION EASEMENT 0.00 2,313.00 OUTFALL CONNECTION F CONSTRUCTION EASEMENT 2,313.00 169875 PURCHASE POWER, INC. 03/09/2017 Regular 0.00 3,187.01 128097 Payable# Payable Type Payable Date Payable Description DiscountAmount Payable Amount Account Number Account Name Item Description Distribution Amount INV0002568 Invoice 02/23/2017 FEBRUARY'17 STATEMENT 0.00 3,187.01 570-30.6550.360000 POSTAGE & SHIPPING PERMIT OVERAGES 28.40 570-30.6550,360000 POSTAGE & SHIPPING FINANCE CHARGES 68.70 570-30.6550,360000 POSTAGE & SHIPPING JAN'17 ACH BILLS 889.24 570-30.6550,360000 POSTAGE & SHIPPING JAN'17 LATE NOTICES 367.38 570-30.6550,360000 POSTAGE & SHIPPING JAN'17 BILLS 1,833.29 041675 DALLAS COUNTY RECORDER 03/14/2017 Regular 0.00 148.80 128104 Payable# Payable Type Payable Date Payable Description DiscountAmount Payable Amount Account Number Account Name Item Description Distribution Amount INV0002585 Invoice 03/14/2017 WARRANTY DEED-WILLIAMS POINTE CO 0.00 50.40 327-90.2130.840490 ALICES RD -UNIV TO OLS WARRANTY DEED-WILLIAMS PO 50.40 INV0002586 Invoice 03/14/2017 WARRANTY DEED-WILLIAMS POINTE CO 0.00 98.40 327-90.2130.940490 ALICES RD -UNIV TO OLS WARRANTY DEED-WILLIAMS PO 98.40 165800 PITNEY BOWES 03/14/2017 EFT 0.00 2,166.27 250701 Payable# Payable Type Payable Date Payable Description DiscountAmount Payable Amount Account Number Account Name Item Description Distribution Amount 3302949236 Invoice 03/01/2017 QRTRLY METER/STUFFER MAITENANCE 0.00 2,166.27 010-60.8400.390000 RENTAL/LEASE OF EQUIP QRTRLY METER/STUFFER MAITE 454.92 570-30.6550.390000 RENTAL/LEASE OF EQUIP QRTRLY METER/STUFFER MAITE 1,711.35 Bank Code AP Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 5 3 0.00 35,048.81 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 1 1 0.00 2,166.27 6 4 0.00 37,215.08 3/15/2017 11:13:12 AM Page 1 of 2 My Check Report Date Range: 03/08/2017 3 03/15/2017 Fund Summary Fund Name Period Amount 999 POOLED CASH 3/2017 37,215.08 37,215.08 3/15/2017 11: 13:12 AM Page 2 of 2 Council Payroll Reimbursements 00) Waukee City of Waukee, IA Vendor Number Vendor Name Bank Code: AP-WAUKEE STATE By Check Number Date Range: 02/28/2017 - 03/15/2017 Payment Date Payment Type DiscountAmount PaymentAmount Number 034875 CITY OF WAUKEE 02/28/2017 Regular 0.00 5,296.68 127942 Payable # Payable Type Payable Date Payable Description DiscountAmount Payable Amount Account Number Account Name Item Description Distribution Amount INV0002510 Invoice 02/28/2017 CELL PHONE REIMBURSEMENT 0.00 222.50 010-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 147.48 060-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 9.38 510-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 11.38 520-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 26.24 540-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 26.32 560-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 1.70 INV0002511 Invoice 02/28/2017 GOLF APARTMENT RENT 0.00 600.00 010-2030000 PAYROLL PAYABLES GOLF APARTMENT RENT 600.00 INV0002516 Invoice 02/28/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.45 510-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 28.98 520-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 28.83 540-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 42.94 560-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 27.65 570-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 34.75 INV0002517 Invoice 02/28/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.94 520-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 42.27 540-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 23.86 560-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 33.22 INV0002520 Invoice 02/28/2017 HEALTH INSURANCE DEDUCTION 0.00 2,975.00 010-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 2,175.87 060-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 153.01 510-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 117.48 520-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 159.29 540-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 202.20 560-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 94.90 570-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 42.50 750-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 29.75 INV0002521 Invoice 02/28/2017 HEALTH INSURANCE DEDUCTION 0.00 330.00 010-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 255.00 060-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 15.00 510-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 18.92 520-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 18.74 540-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 3.92 560-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 3.42 570-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 15.00 036350 IOWA DEPT OF HUMAN SERVICES 02/28/2017 Regular 0.00 1,740.58 127943 Payable# Payable Type Payable Date Payable Description DiscountAmount Payable Amount Account Number Account Name Item Description Distribution Amount INV0002504 Invoice 02/28/2017 CHILDSUPPORT 0.00 1,740.58 010-2011300 CHILD SUPPORT PAYABLE CHILD SUPPORT 1,616.70 060-2011300 CHILD SUPPORT PAYABLE CHILDSUPPORT 123.88 3/15/2017 10:14:04 AM Page 1 of 6 Council Payroll Reimbursements coil Date Range: 02/28/2017 - 03115/2017 Vendor Number Vendor Name Payment Date Payment Type Discount Amount Payment Amount Number 036740 COMMUNICATIONS WORKERS OF AMERICA 02/28/2017 Regular 0.00 888.78 127944 Payable # Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0002507 Invoice 02/28/2017 CWA LOCAL 7102 UNION DUES 0.00 888.78 010-2014100 CREDIT UNION DEDUCTI CWA LOCAL 7102 UNION DUES 420.99 060-2014100 CREDIT UNION DEDUCTI CWA LOCAL 7102 UNION DUES 83.11 510-2014100 CREDIT UNION DEDUCTI CWA LOCAL 7102 UNION DUES 66.04 520-2014100 CREDIT UNION DEDUCTI CWA LOCAL 7102 UNION DUES 96.49 540-2014100 CREDIT UNION DEDUCTI CWA LOCAL 7102 UNION DUES 131.18 560-2014100 CREDIT UNION DEDUCTI CWA LOCAL 7102 UNION DUES 65.69 570-2014100 CREDIT UNION DEDUCTI CWA LOCAL 7102 UNION DUES 25.28 099999 EFTPS 02/28/2017 Regular 0.00 66,946.33 127945 Payable # Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0002525 Invoice 02/28/2017 FICA TAX WITHHOLDING 0.00 31,399.20 010-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 24,856.24 060-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 1,316.82 510-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 1,023.18 520-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 1,306.86 540-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 1,424.96 560-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 606.50 570-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 442.88 750-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 421.76 INV0002526 Invoice 02/28/2017 FEDERAL WITHHOLDING TAXES 0.00 28,203.75 010-2010200 FEDERAL TAX WITHHOLD] FEDERAL WITHHOLDING TAXES 22,349.25 060-2010200 FEDERAL TAX WITHHOLD] FEDERAL WITHHOLDING TAXES 1,176.52 510-2010200 FEDERAL TAX WITHHOLD] FEDERAL WITHHOLDING TAXES 891.14 520-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 1,348.57 540-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 1,137.90 560-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 554.70 570-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 531.24 750-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITH HOLDING TAXES 214.43 INV0002527 Invoice 02/28/2017 MEDICARETAX WITHHOLDING 0.00 7,343.38 010-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 5,813.18 060-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 307.98 510-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 239.34 520-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 305.66 540-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 333.18 560-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 141.82 570-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 103.58 750-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 98.64 133560 MEALS FROM THE HEARTLAND 02/28/2017 Regular 0.00 124.20 127946 Payable # Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0002513 Invoice 02/28/2017 MEALS FROM HEARTLAND DEDUCTION 0.00 124.20 010-2030000 PAYROLL PAYABLES MEALS FROM HEARTLAND DED 103.64 510-2030000 PAYROLL PAYABLES MEALS FROM HEARTLAND DED 3.56 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 02/28/2017 Regular 0.00 4,464.09 127947 3/15/2017 10:14:04 AM Page 2 of 6 Council Payroll Reimbursements Date Range: 02/28/2017 - 03/15/2017 Vendor Number Vendor Name Payment Date Payment Type DiscountAmount PaymentAmount Number Payable# Payable Type Payable Date Payable Description DiscountAmount Payable Amount Account Number Account Name Item Description Distribution Amount INV0002518 Invoice 02/28/2017 SECTION 125 MEDICAL DEDUCTIONS 0.00 2,613.28 010-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 1,896.77 060-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 10.41 510-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 115.86 520-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCT[ 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 INV0002519 Invoice 02/28/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 02/28/2017 Regular 0.00 193.30 127948 Payable # Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0002509 Invoice 02/28/2017 UNITED WAY DEDUCTION 0.00 193.30 010-2030000 PAYROLL PAYABLES UNITED WAY DEDUCTION 164.15 510-2030000 PAYROLL PAYABLES UNITED WAY DEDUCTION 6.91 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 02/28/2017 Regular 0.00 36.66 127949 Payable # Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0002514 Invoice 02/28/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 099999 EFTPS 03/07/2017 Regular 0.00 50.88 128088 Payable # Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0002546 Invoice 03/07/2017 FICA TAX WITHHOLDING 0.00 41.24 540-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 41.24 INV0002547 Invoice 03/07/2017 MEDICARE TAX WITHHOLDING 0.00 9.64 540-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 9.64 091000. ICMA RETIREMENT TRUST 457 03/08/2017 Regular 0.00 5,701.98 128093 Payable # Payable Type Payable Date Payable Description DiscountAmount Payable Amount Account Number Account Name Item Description Distribution Amount INV0002436 Invoice 02/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 INV0002437 Invoice 02/15/2017 ICMA 0.00 879.90 010-2011200 IPERS WITHHOLDING PAY ICMA 818.06 510-2011200 IPERS WITHHOLDING PAY ICMA 15.46 520-2011200 IPERS WITHHOLDING PAY ICMA 15.46 540-2011200 IPERS WITHHOLDING PAY ICMA 15.46 560-2011200 IPERS WITHHOLDING PAY ICMA 15.46 INV0002505 Invoice 02/28/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 3/15/2017 10:14:04 AM Page 3 of 6 L Council Payroll Reimbursements Date Range: 02128/2017 - 03/15/2017 Vendor Number Vendor Name Payment Date Payment Type DiscountAmount PaymentAmount Number 540-2011200 IPERS WITHHOLDING PAY ICMA RETIREMENT 120.00 570-2011200 IPERS WITHHOLDING PAY ICMA RETIREMENT 50.00 INV0002506 Invoice 02/28/2017 ICMA 0.00 864.50 010-2011200 IPERS WITHHOLDING PAY ICMA 798.67 510-2011200 IPERS WITHHOLDING PAY ICMA 17.02 520-2011200 IPERS WITHHOLDING PAY ICMA 16.46 540-2011200 IPERS WITHHOLDING PAY ICMA 17.03 560-2011200 IPERS WITHHOLDING PAY ICMA 15.32 098900 IPERS 03/08/2017 Regular 0.00 82,883.30 128094 Payable # Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount CM0000019 Credit Memo 02/28/2017 FEBRUARY 2017 ROUNDING ADJUSTMEN 0.00 -0.21 010-60.8400.080000 IPERS CONTRIBUTION FEBRUARY 2017 ROUNDING AD -0.21 INV0002452 Invoice 02/15/2017 IPERS DEDUCTIONS 0.00 28,029.85 010-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 18,876.95 060-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 1,720.76 510-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 1,448.62 520-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 1,861.16 540-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 2,117.03 560-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 950.50 570-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 671.93 750-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 382.90 INV0002453 Invoice 02/15/2017 IPERS DEDUCTIONS 0.00 14,984.41 010-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 14,984.41 INV0002454 Invoice 02/15/2017 IPERS ELECTED OFFICIAL DEDUCT 0.00 212.04 010-2011200 IPERS WITHHOLDING PAY IPERS ELECTED OFFICIAL DEDUC 212.04 INV0002522 Invoice 02/28/2017 IPERS DEDUCTIONS 0.00 25,306.43 010-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 17,192.68 060-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 1,606.41 510-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 1,264.98 520-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 1,611.08 540-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 1,766.42 560-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 787.02 570-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 558.61 750-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 519.23 INV0002523 Invoice 02/28/2017 IPERS DEDUCTIONS 0.00 14,350.78 010-2011200 IPERS WITHHOLDING PAY IPERS DEDUCTIONS 14,350.78 208650 TREASURER STATE OF IOWA 03/08/2017 Regular 0.00 24,451.24 128095 Payable N Payable Type Payable Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0002455 Invoice 02/15/2017 STATE WITHHOLDING TAXES 0.00 12,848.60 010-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 10,110.85 060-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 520.52 510-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 430.56 520-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 553.11 540-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 654.84 560-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 270.66 570-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 219.06 750-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 89.00 INV0002524 Invoice 02/28/2017 STATE WITHHOLDING TAXES 0.00 11,598.19 010-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 9,294.95 060-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 476.37 510-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 360.10 520-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 460.83 540-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 510.81 560-2011100 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 209.77 3/15/2017 10:14:04 AM Page 4 of 6 Council Payroll Reimbursements Vendor Number Vendor Name 570-2011100 750-2011100 INV0002545 Invoice 540-2011100 256601 Payable # INV0002439 INV0002442 INV0002508 INV0002512 C, Date Range: 02/28/2017 - 03/IS/2017 Payment Date Payment Type Discount Amount PaymentAmount Number STATE TAX WITH HOLDIN STATE WITHHOLDING TAXES 175.50 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 109.86 03/07/2017 STATE WITHHOLDING TAXES 0.00 4.45 STATE TAX WITHHOLDIN STATE WITHHOLDING TAXES 4.45 YMCA OF GREATER DES MOINES 03/08/2017 Regular 0.00 1,651.00 128096 Payable Type Payable Date Payable Description DiscountAmount PayableAmount Account Number Account Name Item Description Distribution Amount Invoice 02/15/2017 YMCA FAMILY MEMBERSHIP DEDUCTION 0.00 636.50 010-2030000 PAYROLL PAYABLES YMCA FAMILY MEMBERSHIP DE 529.50 510-2030000 PAYROLL PAYABLES YMCA FAMILY MEMBERSHIP DE 2.51 520-2030000 PAYROLL PAYABLES YMCA FAMILY MEMBERSHIP DE 2.49 540-2030000 PAYROLL PAYABLES YMCA FAMILY MEMBERSHIP DE 68.00 560-2030000 PAYROLL PAYABLES YMCA FAMILY MEMBERSHIP DE 34.00 Invoice 02/15/2017 YMCA SINGLE MEMBERSHIP DEDUCTION 0.00 240.00 010-2030000 PAYROLL PAYABLES YMCA SINGLE MEMBERSHIP DE 240.00 Invoice 02/28/2017 YMCA FAMILY MEMBERSHIP DEDUCTION 0.00 534.50 010-2030000 PAYROLL PAYABLES YMCA FAMILY MEMBERSHIP DE 427.50 510-2030000 PAYROLL PAYABLES YMCA FAMILY MEMBERSHIP DE 2.51 520-2030000 PAYROLL PAYABLES YMCA FAMILY MEMBERSHIP DE 2.49 540-2030000 PAYROLL PAYABLES YMCA FAMILY MEMBERSHIP DE 68.00 560-2030000 PAYROLL PAYABLES YMCA FAMILY MEMBERSHIP DE 34.00 Invoice 02/28/2017 YMCA SINGLE MEMBERSHIP DEDUCTION 0.00 240.00 010-2030000 PAYROLL PAYABLES YMCA SINGLE MEMBERSHIP DE 240.00 Bank Code AP Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 35 13 0.00 194,429.02 Manual Checks 0 0 0.00 0.00 Voided Checks 0 0 0.00 0.00 Bank Drafts 0 0 0.00 0.00 EFT's 0 0 0.00 0.00 35 13 0.00 194,429.02 3/15/2017 10:14:04 AM Page 5 of 6 Council Payroll Reimbursements Date Range: 02/28/2017 C� 03/15/2017 Fund 999 999 Fund Summary Name Period Amount POOLED CASH 2/2017 79,690.62 POOLED CASH 3/2017 114,738.40 194,429.02 3/15/2017 10: 14:04 AM Page 6 of 03-15-2017 10:24 AM MONTHLY TRANSACTION REPORT PAGE: 1 PERIOD: 3/01/2017 THRU 3/15/2017 ZONE: * - All Zones REVENUE CODE: All ADJUSTMENT CODES: All ACCOUNT NO# NAME DATE TYPE AMOUNT REFERENCE PACKET RECEIPT ADJ 16-00150-00 ROCK EQUITY HOLDINGS, LLC 3/13/2017 RF-CK 19.64 REFUND CK: 128098 20034 83-01202-06 WILKINS, SYDNEY 3/13/2017 RF-CK 129.13 REFUND CK: 128099 20034 83-01209-05 CROWSON, RALEY 3/13/2017 RF-CK 2.99 REFUND CK: 128100 20034 84-99999-05 EDWARDS, PATTY D 3/13/2017 RF-CK 35.62 REFUND CK: 128101 20034 85-00129-04 SHEPHERD, KEN N 3/13/2017 RF-CK 34.05 REFUND CK: 128102 20034 85-00919-01 NICHOLS, BROOKE 3/13/2017 RP-CK 60.35 REFUND CK: 128103 20034 03-15-2017 10:24 AM MONTHLY TRANSACTION REPORT PAGE: 2 PERIOD: 3/01/2017 THRU 3/15/2017 ZONE: + - All Zones REVENUE CODE: All ADJUSTMENT CODES: All D A I L Y D I S T R I B U T I O N DAY REVENUE CODE TYPE COUNT AMOUNT TYPE COUNT AMOUNT TYPE COUNT AMOUNT 13 999 - REFUND RF-CK 6 299.56 GRAND TOTAL FOR PERIOD 277.56 DEPOSIT TOTAL FOR PERIOD 0.00 03-15-2017 10:24 AM MONTHLY TRANSACTION REPORT PERIOD: 3/01/2017 THRU 3/15/2017 ZONE: * - All Zones REVENUE CODE: All ADJUSTMENT CODES: All PAGE: 3 1 1 R E V E N U E C 0 D E T 0 T A L S E Y T Y P E_____________-----___________________ REVENUE CODE TYPE COUNT AMOUNT TYPE COUNT AMOUNT TYPE COUNT AMOUNT 999 - REFUND RP-CK 6 277.56 REVENUE TOTAL 277.56 GRAND TOTAL FOR PERIOD 277.56 ______-------------- _______________—_= T O T A L S H Y T R A N S A C T I O N T Y P E TYPE COUNT AMOUNT ------------------------------------------- REFUND CHECK 6 277.56 TOTAL FOR PERIOD 6 277.56 %fo Vbukee Employee Name ABBOTT, BRENT ADKINS, COREY ALDRICH, SHAWN APPLE, WILLIAM ARIAS, HECTOR ARMSTRONG, BRETT BAKER, RANDY BAUMAN, LISA BERG, BROOKE BOHARDT, HAZEL BRUNS, RACHEL BURKHART, LINDA BUSH, COURTNEY CAMPBELL, JUDY CAMPBELL, SCOTT CICHOSKI, KELLI CLEMEN, ANTHONY COLE, JACOB CORKREAN, JENNIFER CRAVEN,GAYLA CUNNINGHAM, DEANA CUNNINGHAM, SCOTT DANIEL, COLE DAVIS, BRIAN DEBOER, MELISSA DEETS, BRADLY DEZEEUW, DAVID DODGE, JUSTIN DUNBAR, DIANA DUTCHER, DAN EDWARDS, DANAE ELDRIDGE, MALLORY ELLIOTT, STEVE EVANS, SUMMER EVERMAN, MASON FLUGGE-SMITH, JAMIE FREDERICK, JUSTIN FROEHLICH, WILLIAM GIBSON, JOHN GITZEN, ROBERT GODWIN, EDWARD GROVE, BRIAN HANSON,ANTHONY HANSON, LAURA HARDIN, THOMAS HASKINS, STACEY HEIMANN, RONALD HENTGES, ERIC HERR, JENNA HERRICK, ROBERT HILGENBERG, ADAM HOLDEN, PATRICIA HOPTON, SIMONE HUSTED, TROY HUTTON, JOSHUA IRWIN, BRENT JENSEN, CHAD City of Waukee, IA Publication Report By Employee Name Payroll Set: OS - City of Waukee For Date Range 02/16/2017-02/28/2017 Salary $1,220.43 $969.26 $1,527.43 $229.55 $2,336.20 $1,751.25 $1,437.18 $994.05 $159.31 $246.70 $1,416.17 $2,807.18 $912.77 $456.76 $1,639.68 $1,338.47 $907.49 $377.72 $1,358.94 $112.86 $441.39 $2,138.99 $1,146.79 $269.59 $1,436.12 $3,027.64 $1,840.92 $1,430.86 $820.68 $3,001.86 $1,084.14 $558.00 $1,729.29 $1,984.71 $145.98 $1,568.36 $1,416.98 $368.10 $3,303.08 $1,874.40 $113.86 $28.77 $1,709.76 $1,349.60 $391.74 $1,009.24 $1,738.86 $376.61 $1,159.13 $1,521.27 $1,396.86 $2,767.20 $68.60 $1,303.56 $1,343.16 $112.85 $552.40 Employee Name Salary JERMIER, MATTHEW $2,597.77 KASS, ANDREW $1,700.87 KASZINSKI, BRETT $638.86 KELLER, CHRISTOPHER $1,330.73 KERR, JACOB $1,285.34 KESSLER, MATTHEW $1,459.91 KIES, SUSAN $1,406.62 KOESTER, EVAN $1,803.61 KOESTER, RUDY $2,477.55 KOPPES, BROOKE $60.49 LARSON, KENNETH $332.71 LARSON, KRISTINE $2,561.95 LAUGHRIDGE, DANIEL $1,360.28 LEMKE, NEIL $1,060.45 LONG, JEREMY $2,045.19 LYNCH, SHANNON $1,259.99 MANNING, JOSHUA $1,433.10 MANNING, TAYLOR $67.73 MAPES, TROY $2,601.77 MCCLINTIC, JAMES $1,356.63 MEDDERS, BRETT $1,278.58 MELLENCAMP, JEFFREY $2,259.17 MINIKUS, JOSHUA $1,919.46 MOERMAN, TIMOTHY $3,857.98 MURRA, BRIAN $1,763.13 NICELY -GREEN, CODY $306.47 NITZEL, NICOLE $47407 OAKLEY, JON $1,469.51 OLSEN, KART $1,307.68 OSTRING, KATHLEEN $1,132.23 PARISH, TONJA $1,125.98 PERDRIAU, MARIE $203.88 PETERSON, KATIE $984.67 PETERSON, OREN $1,773.12 PETTIT, BRANDON $1,546.92 PIERSON, DAMON $810.26 PINEGAR, TOMMIE $1,086.64 PIZINGER, JAMES $201.26 POSADAS, OSCAR $338.74 PUDENZ, DANIELLE $117.23 PURVIS, KATHRYN $974.45 QUINN, JOHN $2 719 27 RASH, RONALD $1,348.48 RICHARDSON, ELIZABETH $1,328.21 ROBINSON, CLINT $3,107.40 ROYER, TIMOTHY $2,701.18 ROYSTER, JACOB $1,288.69 SCHAUFENBUEL, KARI $661.14 SCHETTLER, RODNEY $1,605.71 SCHUETT, REBECCA $1,699.06 SEDDON, JOSH $280.25 SHARON, JEREMIAH $867.41 SKELLENGER, AMANDA $4374 SNELSON, NATHANIEL $195.29 SOFEN, NATASHA $34.56 SPOSETO, MACKENZIE $1,659.61 SPRAGUE, MATTHEW $1,459.95 STEINKE, KURT $441.22 STEPHENS, CLINT $271.64 STEWARD, ERIC $1,721.06 STOTZ, MELISSA $516.38 THAYER, CHANDLER $330.29 TIBBLES, STEVEN $1,211.14 TUEL, JASON $280.87 Employee Name Salary TYSDAL, THOMAS $2,273.32 VANDE KAMP, JOSHUA $1,565.16 VOEGTLE, TIMOTHY $1,186.84 VOKES, LARRY $1,455.21 WALLACE, ERIC $1,695.28 WASKE, CHARLES $1,454.48 WAYCASTER, SAVANNAH $149.22 WERTS, DANIEL $1,899.87 WESTON STOLL, KERI $1,499.03 WHITE, JASON $1,415.57 WHITE, LEAH $1,003.00 WIGGINS, MATHEW $1,505.50 W ILSON, JODY $954.97 WINTERS, TROY $1,586.77 WISE, NATHAN $1,968.53 WOOD, DANIEL $685.46 YATES, CASSANDRA $393.10