Loading...
HomeMy WebLinkAbout5A, Claims and Payroll --AR`EN HILLS Request for Council Action 5A Prepared By: Ashley Bertrand, Sue Iverson Council Meeting Date: October 08,2012 Motion to Approve Consent Agenda Item—Claims and Payroll Budgeted Amount: Actual Amount: Funding Source: NA NA NA Recommendation: 1. Motion to Approve Consent Agenda Item—Claims and Payroll Supporting Documents: Payroll 2012 Payroll#20 $ 77,667.79 Total Payroll $ 77,667.79 Accounts Payable Claims Through 10-05-2012 Paid Claims (Check No. 40771 thru Check No. 40807) $ 38,104.44 Paid Claims (Check No. 40808 thru Check No. 40808) $ 26,000.00 Paid Claims (Check No. 40809 thru Check No. 40839) $ 53,210.79 Paid Claims (Check No. 40840 thru Check No. 40844) $ 149,920.33 Total Claims $267,235.56 CITY OF ARDEN HILLS PAYROLL#20 CHECKS DATED: 09/28/12 Biweekly: 09/08/12 TO 09/21/12 :M;PLOVEE AEDUCTIO��S :CITY; ENEFI7 . ..................................... FIT EFT SIT 3,031.44 > >>> >« > »>':' : EFT FICA Oasdi 1 2,770.511 4,089.83 EFT FICA Medicare 1 956.491 956.49 EFT TOTAL TAXES 14,177.17 5,046.32 Health Premium 1,312.56 0.00 A/P Check* Dental Premium 0.00 A/P Check* FSA Health Care Reimb. 225.00 <>>:':>:<.»»>:::<»>»3 A/P Check* FSA Dependent Care Reimb. 526.28 ;;;<;;;; ;;< A/P Check* TOTAL FLEXIBLE SPENDING 2,063.84 0.00 HSA Health Sav ng 1 205.161 0.00 11TOTAL HEALTH SAVINGS 1 205.161 0.00 PERA 1 3,782.761 4,388.01 EFT ICMA 1 2,191.151 315.35 A/P Check* Central Pension Fund-Union 614.40 .A/P Check* TOTAL RETIREMENT 1 6,588.311 4,703.36 IUOE 49 Dues Union 130.00 :A/P Check* LTD/STD Insurance 0.001 A/P Check* PERA Life Insurance 3 2.00 A/P Check* Life/Addl/Dep Life 105.70 0.00 A/P Check* Mn Child Support 323.02: A/P Check* TOTAL VOLUNTARY 590.72 0.00 Total Employee Deductions :::23;62520: PR Check#: 17331-17337 Net Payroll 4,179.83 EFT Direct Deposit 40,113.08 Gross Payroll Tie-Out 67,918.11 STD/LTD Gross-Up 0.00 Plus ity Paid Benefit 9;749;6$ ICMA:Beriet:£1eld :>:::>:»;:>;::<:::<:<<>>< TOTAL PAYROLL COST 77,667.79 Gross Payroll 67;91:8;1:,1; Less Total FSA 2;1163:$4 Plus Employer Match ICMA Plus ICMA Benefit Held 0:00 Net P/R Subject to FICA FICA Oasdi g 6.20% FICA Medicare @ 1.45% 956:49 Note:Federal and State Payroll Tax obligations are satisfied by means of utilizing the °Taxtel" Electronic Tax Deposit Service.Trans- fers are typically made two business days after the payroll date. *A/P Checks can be found on the ACCOUNTS PAYABLE Check Approval report. Checks may be paid this week or the following week. Accounts Payable Check Detail User: ashley.bertrand Printed: 10/05/2012- 2:20PM f--- EN HjILLS Check Number Check Date Amount 2597-AARP Line Item Account 40771 09/28/2012 Inv 800 Line Item Date Line Item Description Line Item Account 09/13/2012 September 2012 AARP Class 101-45120-42170 218.00 Inv 800 Total 218.00 40771 Total: 218.00 2597-AARP Total: 218.00 1223-Adam's Pest Control,Inc.Line Item Account 40772 09/28/2012 Inv 740776 Line Item Date Line Item Description Line Item Account 08/29/2012 August 2012 Pest Control 101-41940-44010 66.84 Inv 740776 Total 66.84 40772 Total: 66.84 1223-Adam's Pest Control,Inc.Total: 66.84 0282-Allied Waste Services#899 Line Item Account 40773 09/28/2012 Inv 0899-002123855 Line Item Date Line Item Description Line Item Account 08/25/2012 September 2012 Trash Services 101-45200-43840 1,025.81 08/25/2012 September 2012 Trash Services 101-41940-43840 213.18 Inv 0899-002123855 Total 1,238.99 40773 Total: 1,238.99 0282-Allied Waste Services#899 Total: 1,238.99 1125-Bolton&Menk,Inc.Line Item Account 40774 09/28/2012 AP-Check Detail(10/5/2012- 2:20 PM) Page I Check Number Check Date Amount Inv 0150340 Line Item Date Line Item Description Line Item Account 08/31/2012 Lift Station 5,8,13 August 2012 Engineering Services 602-48401-43030 1,063.41 Inv 0150340 Total 1,063.41 40774 Total 1,063.41 1125-Bolton&Menk,Inc.Total: 1,063.41 0277-City of New Brighton Line Item Account 40775 09/28/2012 Inv 09042012 Line Item Date Line Item Description Line Item Account 09/04/2012 Q3 2012 Cable Services 228-41960-43100 1,426.00 Inv 09042012 Total 1,426.00 40775 Total: 1,426.00 0277-City of New Brighton Total: 1,426.00 0319-City of Roseville Line Item Account 40776 09/28/2012 Inv 0216411 Line Item Date Line Item Description Line Item Account 08/31/2012 September 2012 IT Tech Support 728-49900-43081 2,294.16 Inv 0216411 Total 2,294.16 Inv 0216450 Line Item Date Line Item Description Line Item Account 08/31/2012 September 2012 Phone Bill 728-49900-43210 472.50 Inv 0216450 Total 472.50 40776 Total.: 2,766.66 0319-City of Roseville Total: 2,766.66 0342-City of Shoreview Line Item Account 40777 09/28/2012 Inv 0004996 Line Item Date Line Item Description Line Item Account 08/06/2012 August 2012 Field Trip 101-45120-42170 162.00 Inv 0004996 Total 162.00 AP-Check Detail(10/5/2012- 2:20 PM) Page 2 Check Number Check Date Amount 40777 Total: 162.00 0342-City of Shoreview Total: 162.00 1032-Commercial Asphalt Co.Line Item Account 40778 09/28/2012 Inv AR180-092012 Line Item Date Line Item Description Line Item Account 09/15/2012 Street Repairs After Water Valve Replacement 601-49440-44040 1,872.20 Inv AR180-092012 Total 1,872.20 40778 Total: 1,872.20 1032-Commercial Asphalt Co.Total: 1,872.20 HYMT-Dakota Supply Group,Inc.Line Item Account 40779 09/28/2012 Inv 7499409 Line Item Date Line Item Description Line Item Account 08/29/2012 2012 Water Meter Replacement 601-48517-45600 182.25 Inv 7499409 Total 182.25 40779 Total: 182.25 HYMT-Dakota Supply Group,Inc.Total: 182.25 UB*00055-Dobratz,David Line Item Account 40780 09/28/2012 Inv Line Item Date Line Item Description Line Item Account 09/27/2012 Refund Check 601-00000-20200 87.18 Inv Total 87.18 40780 Total: 87.18 UB*00055-Dobratz,David Total: 87.18 0339-Ferguson Waterworks Line Item Account 40781 09/28/2012 Inv S01385316.001 Line Item Date Line Item Description Line Item Account 08/31/2012 PW Supplies 601-49440-42210 395.44 AP-Check Detail(10/5/2012- 2:20 PM) Page 3 Check Number Check Date Amount Inv S01385316.001 Total 395.44 Inv 501385659.001 Line Item Date Line Item Description Line Item Account 08/30/2012 PW Supplies 601-49440-42210 1,186.21 Inv 501385659.001 Total 1,186.21 Inv 501388001.001 Line Item Date Line Item Description Line Item Account 08/29/2012 PW Supplies 601-49440-42210 129.29 Inv S01388001.001 Total 129.29 Inv 501388487.001 Line Item Date Line Item Description Line Item Account 08/30/2012 PW Supplies 601-49440-42210 128.36 Inv 501388487.001 Total 128.36 Inv S01390830.001 Line Item Date Line Item Description Line Item Account 09/11/2012 PW Supplies Return 601-49440-42210 -260.51 Inv S01390830.001 Total -260.51 40781 Total: 1,578.79 0339-Ferguson Waterworks Total: 1,578.79 FPTC-Flexible Pipe Tool Company Line Item Account 40782 09/28/2012 Inv 15573 Line Item Date Line Item Description Line Item Account 08/29/2012 PW Parts 727-49700-42210 2,747.15 Inv 15573 Total 2,747.15 40782 Total: 2,747.15 FPTC-Flexible Pipe Tool Company Total: 2,747.15 0189-Gopher State One-Call,Inc.Line Item Account 40783 09/28/2012 Inv 46901 Line Item Date Line Item Description Line Item Account 09/04/2012 August 2012 Locates 601-49440-44397 216.20 09/04/2012 August 2012 Locates 602-49490-44397 216.20 AP-Check Detail(10/5/2012- 2:20 PM) Page 4 Check Number Check Date Amount Inv 46901 Total 432.40 432.40 40783 Total: 0189-Gopher State One-Call,Inc.Total: 432.40 0192-Grainger,Inc Line Item Account 40784 09/28/2012 Inv 9914905279 Line Item Date Line Item Description Line Item Account 08/30/2012 PW Supplies 727-49700-42210 30.27 Inv 9914905279 Total 30.27 40784 Total: 30.27 0192-Grainger,Inc Total: 30.27 5055-Green Mill Line Item Account 40785 09/28/2012 Inv 648 Line Item Date Line Item Description Line Item Account 09/04/2012 09.04.2012 CC Work Session 101-41100-44325 127.61 Inv 648 Total 127.61 40785 Total: 127.61 5055-Green Mill Total: 127.61 0320-Health Partners Line Item Account 40786 09/28/2012 Inv 41319291 Line Item Date Line Item Description Line Item Account 09/07/2012 October 2012 Dental insurance 101-00000-21738 887.77 Inv 41319291 Total 887.77 887.77 40786 Total: 0320-Health Partners Total: 887.77 0382-ICMA Retirement Trust-106944 Line Item Account 101-00000-21740 40787 09/28/2012 AP-Check Detail(10/5/2012- 2:20 PM) Page 5 Check Number Check Date Amount Inv 09262012-PK Line Item Date Line Item Description Line Item Account 09/26/2012 Klaers PR#20 Contributions 101-00000-21740 587.20 Inv 09262012-PK Total 587.20 40787 Total: 587.20 0382-ICMA Retirement Trust-106944 Total: 587.20 0387-ICMA Retirement Trust-#302482 Line Item Account 101-00000-21742 40788 09/28/2012 Inv 09262012-CS Line Item Date Line Item Description Line Item Account 09/26/2012 City Staff PR#20 Contributions 101-00000-21742 1,919.30 Inv 09262012-CS Total 1,919.30 40788 Total: 1,919.30 0387-ICMA Retirement Trust-#302482 Total: 1,919.30 0210-Kath Fuel Oil Service Line Item Account 40789 09/28/2012 Inv 371315 Line Item Date Line Item Description Line Item Account 06/01/2012 PW Supplies 727-49700-42400 207.21 Inv 371315 Total 207.21 Inv 371315-C Line Item Date Line Item Description Line Item Account 06/01/2012 PW Supplies 101-43100-42210 -23.28 06/01/2012 PW Supplies 601-49440-42210 -23.28 06/01/2012 PW Supplies 602-49490-42210 -23.28 06/01/2012 PW Supplies 604-49550-42210 -10.34 06/01/2012 PW Supplies 101-45200-42210 -23.28 Inv 371315-C Total -103.46 103.75 40789 Total: 0210-Kath Fuel Oil Service Total: 103.75 8080-Klingberg,Sonja Line Item Account 40790 09/28/2012 Inv 09202012 Line Item Date Line Item Description Line Item Account AP-Check Detail(10/5/2012- 2:20 PM) Page 6 Check Number Check Date Amount 09/20/2012 September 2012 Mileage Reimbursement 101-41300-43310 26.09 Inv 09202012 Total 26.09 40790 Total: 26.09 8080-Klingberg,Sonja Total: 26.09 0557-Leiser,David Line Item Account 40791 09/28/2012 Inv 1201 Line Item Date Line Item Description Line Item Account 09/25/2012 2012 Basketball Camps Kindergarren-Grade 5 101-45120-43070 2,572.80 Inv 1201 Total 2,572.80 Inv 1202 Line Item Date Line Item Description Line Item Account 09/25/2012 2012 Basketball Camps Grade 6-Grade 9 101-45120-43070 3,520.80 Inv 1202 Total 3,520.80 40791 Total: 6,093.60 0557-Leiser,David Total: 6,093.60 U13*00056-Lund,Nancy-Dell Line Item Account 40792 09/28/2012 Inv Line Item Date Line Item Description Line Item Account 09/27/2012 Refund Check 601-00000-20200 168.02 Inv Total 168.02 40792 Total: 168.02 UB*00056-Lund,Nancy-Dell Total: 168.02 UB*00057-Mason,Greta Line Item Account 40793 09/28/2012 Inv Line Item Date Line Item Description Line Item Account 09/27/2012 Refund Check 601-00000-20200 21.70 Inv Total 21.70 40793 Total: 21.70 AP-Check Detail(10/5/2012- 2:20 PM) Page 7 Check Number Check Date Amount 21.70 UB*00057-Mason,Greta Total: 7704-Metro Gun Club Line Item Account 40794 09/28/2012 Inv 09252012 Line Item Date Line Item Descrintion Line Item Account 09/25/2012 2012 Firearm Safety 101-45120-42170 45.00 Inv 09252012 Total 45.00 40794 Total: 45.00 7704-Metro Gun Club Total: 45.00 MDPR-Midway Party Rental Line Item Account 40795 09/28/2012 Inv 23067 Line Item Date Line Item Description Line Item Account 09/19/2012 Canopies/Tents-CAH 101-45400-42170 1,123.26 Inv 23067 Total 1,123.26 40795 Total: 1,123.26 MDPR-Midway Party Rental Total: 1,123.26 MNCS-Minnesota Child Support Payment Center Line Item Account 101-00000-21780 40796 09/28/2012 Inv 09262012-MNCS Line Item Date Line Item Description Line Item Account 09/26/2012 Frid PR#20 Deductions 101-00000-21780 323.02 Inv 09262012-MNCS Total 323.02 323.02 40796 Total: MNCS-Minnesota Child Support Payment Center Total: 323.02 7025-On Site Sanitation Line Item Account 40797 09/28/2012 Inv A-470669 Line Item Date Line Item Descrintion Line Item Account 09/15/2012 Floral Park Restroom Rental 101-45200-43840 59.85 Inv A-470669 Total 59.85 AP-Check Detail(10/5/2012- 2:20 PM) Page 8 Check,Number Check Date Amount Inv A-471060 Line Item Date Line Item Description Line Item Account 09/04/2012 Ingerson Park Restroom Rental Credit 101-45200-43840 -29.92 Inv A-471060 Total -29.92 Inv A-471088 Line Item Date Line Item Description Line Item Account 09/05/2012 Royal Hills Park Restroom Rental 101-45200-43840 -29.92 Inv A-471088 Total -29.92 Inv A-471670 Line Item Date Line Item Description Line Item Account 09/15/2012 Hazelnut Park Restroom Rental 101-45120-43840 59.85 Inv A-471670 Total 59.85 Inv A-471671 Line Item Date Line Item Description Line Item Account 09/15/2012 Perry Park Restroom Rental 101-45200-43840 153.90 Inv A-471671 Total 153.90 Inv A-471874 Line Item Date Line Item Description Line Item Account 09/15/2012 Cummings Park Restroom Rental 101-45120-43840 59.85 Inv A-471874 Total 59.85 Inv A-473695 Line Item Date Line Item Description Line Item Account 09/21/2012 Valentine Park Restroom Rental 101-45200-43840 59.85 Inv A-473695 Total 59.85 40797 Total: 333.46 7025-On Site Sanitation Total: 333.46 1208-Premium Waters,Inc Line Item Account 40798 09/28/2012 Inv 610207-08-31 Line Item Date Line Item Description Line Item Account 08/31/2012 CH Supplies 101-41940-42010 131.58 Inv 610207-08-31 Total 131.58 Inv 613317-08-31 Line Item Date Line Item Description Line Item Account AP-Check Detail(10/5/2012- 2:20 PM) Page 9 Check Number Check Date Amount 08/31/2012 CH Supplies 101-41940-42010 145.05 Inv 613317-08-31 Total 145.05 40798 Total: 276.63 1208-Premium Waters,Inc Total: 276.63 1062-Score American Soccer Company,Inc.Line Item Account 40799 09/28/2012 Inv 6184933 Line Item Date Line Item Description Line Item Account 08/31/2012 Soccer Balls 101-45120-42172 578.85 Inv 6184933 Total 578.85 40799 Total: 578.85 1062-Score American Soccer Company,Inc.Total: 578.85 UB*00058-Selleck,Scott&Heather Line Item Account 40800 09/28/2012 Inv Line Item Date Line Item Description Line Item Account 09/27/2012 Refund Check 601-00000-20200 1.73 Inv Total 1.73 40800 Total: 1.73 UB*00058-Selleck,Scott&Heather Total: 1.73 7703-SourceOne Graphics,Inc.Line Item Account 40801 09/28/2012 Inv 62419 Line Item Date Line Item Description Line Item Account 09/04/2012 Signs of CAH 101-45400-42170 423.85 Inv 62419 Total 423.85 40801 Total: 423.85 7703-SourceOne Graphics,Inc.Total: 423.85 0716-Springbrook Software Line Item Account 40802 09/28/2012 AP-Check Detail(10/5/2012- 2:20 PM) Page 10 Check Number Check Date Amount Inv 0023194 Line Item Date Line Item Description Line Item Account 08/31/2012 Human Resource Module 101-41500-43080 441.67 08/31/2012 Human Resource Module 601-49440-43080 441.67 08/31/2012 Human Resource Module 602-49490-43080 441.67 08/31/2012 Human Resource Module 604-49550-43080 441.66 Inv 0023194 Total 1,766.67 40802 Total: 1,766.67 0716-Springbrook Software Total: 1,766.67 1387-Standard Insurance Company Line Item Account 40803 09/28/2012 Inv 147490-102012 Line Item Date Line Item Description Line Item Account 09/17/2012 October 2012 STD/LTD/Life Insurance 101-00000-21733 1,507.64 Inv 147490-102012 Total 1,507.64 40803 Total: 1,507.64 1387-Standard Insurance Company Total: 1,507.64 0327-Staples Business Advantage Line Item Account 40804 09/28/2012 Inv 3181810074 Line Item Date Line Item Description Line Item Account 09/13/2012 Office Supplies 101-41500-42010 116.97 Inv 3181810074 Total 116.97 40804 Total: 116.97 0327-Staples Business Advantage Total: 116.97 2657-Superior Golf Cars Line Item Account 40805 09/28/2012 Inv 5042916 Line Item Date Line Item Descrintion Line Item Account 09/14/2012 CAH Equipment 101-45400-42170 347.19 Inv 5042916 Total 347.19 40805 Total: 347.19 AP-Check Detail(10/5/2012- 2:20 PM) Page I I Check Number Check Date Amount 2657-Superior Golf Cars Total: 347.19 UOFM-University of Minnesota Line Item Account 40806 09/28/2012 Inv 09272012-TM Line Item Date Line Item Description Line Item Account 09/27/2012 APWA MN Fall Conferece 2012 727-49700-44325 235.00 Inv 09272012-TM Total 235.00 40806 Total: 235.00 UOFM-University of Minnesota Total: 235.00 1161-Valley-Rich Co.,Inc.Line Item Account 40807 09/28/2012 Inv 18071 Line Item Date Line Item Description Line Item Account 08/09/2012 Watermain Break Repair 601-49440-44010 7,217.99 Inv 18071 Total 7,217.99 40807 Total: 7,217.99 1161-Valley-Rich Co.,Inc.Total: 7,217.99 Total: 38,104.44 AP-Check Detail(10/5/2012- 2:20 PM) Page 12 Accounts Payable Check Detail User: ashley.bertrand Printed: 10/05/2012- 2:16PM EN HIILLS Check Number Check Date Amount 7524-Wellington Management,Inc.Line Item Account 40808 10/03/2012 Inv 10032012 Line Item Date Line Item Description Line Item Account 10/03/2012 Escrow Reimbursement 101-00000-22000 26,000.00 Inv 10032012 Total 26,000.00 40808 Total: 26,000.00 7524-Wellington Management,Inc.Total: 26,000.00 Total: 26,000.00 AP-Check Detail(10/5/2012- 2:16 PM) Page 1 Accounts Payable Check Detail User: ashley.bertrand Printed: 10/05/2012- 2:36PM EN HIILLS Check Number Check Date Amount 1355-Asset Recovery Corp.Line Item Account 40809 10/05/2012 Inv 6530599-IN Line Item Date Line Item Description Line Item Account 09/07/2012 2012 Water Meter Replacement 601-48517-45600 191.52 Inv 6530599-IN Total 191.52 40809 Total: 191.52 1355-Asset Recovery Corp.Total: 191.52 1108-Beekman,Meagan Line Item Account 0 10/05/2012 Inv 10012012 Line Item Date Line Item Description Line Item Account 10/01/2012 2012 MN APA Conference 101-41910-44325 317.43 Inv 10012012 Total 317.43 0 Total: 317.43 1108-Beekman,Meagan Total: 317.43 0342-City of Shoreview Line Item Account 40810 10/05/2012 Inv 00005015 Line Item Date Line Item Description Line Item Account 09/11/2012 Summer 2012 Field Trip-Bus Cost 101-45120-42170 211.20 Inv 00005015 Total 211.20 40810 Total: 211.20 0342-City of Shoreview Total: 211.20 1033-Comcast Line Item Account 40811 10/05/2012 AP-Check Detail(10/5/2012- 2:36 PM) Page 1 Check Number Check Date Amount Inv 44271-092012 Line Item Date Line Item Descrintion Line Item Account 09/11/2012 September 2012 TV Services 228-41960-43100 6.76 Inv 44271-092012 Total 6.76 40811 Total: 6.76 1033-Comcast Total: 6.76 0841-Ehlers&Associates,Inc.Line Item Account 40812 10/05/2012 Inv 63324 Line Item Date Line Item Description Line Item Account 09/17/2012 TIF Policy August 2012 Charges 251-47300-43090 1,608.75 Inv 63324 Total 1,608.75 40812 Total: 1,608.75 0841-Ehlers&Associates,Inc.Total: 1,608.75 2129-Elfering&Associates Line Item Account 40813 10/05/2012 Inv 1701 Line Item Date Line Item Description Line Item Account 09/17/2012 Pres Homes August 2012 101-00000-22000 195.00 Inv 1701 Total 195.00 40813 Total: 195.00 2129-Elfering&Associates Total: 195.00 1195-Eureka Recycling Line Item Account 40814 10/05/2012 Inv 10911 Line Item Date Line Item Description Line Item Account 09/18/2012 August 2012 Recycling 603-49520-36276 -897.46 09/18/2012 August 2012 Recycling 603-49520-43860 7,820.80 Inv 10911 Total 6,923.34 40814 Total: 6,923.34 1195-Eureka Recycling Total: 6,923.34 AP-Check Detail(10/5/2012- 2:36 PM) Page 2 Check Number Check Date Amount 0176-Frattallone's Hardware,Inc.Line Item Account 40815 10/05/2012 Inv 050446-A Line Item Date Line Item Description Line Item Account 09/14/2012 PW Supplies 727-49700-42210 38.35 Inv 050446-A Total 38.35 Inv 050593-A Line Item Date Line Item Description Line Item Account 09/24/2012 PW Supplies 727-49700-42210 33.64 Inv 050593-A Total 33.64 Inv 050612-A Line Item Date Line Item Description Line Item Account 09/25/2012 PW Supplies 727-49700-42210 25.71 Inv 050612-A Total 25.71 40815 Total: 97.70 0176-Frattallone's Hardware,Inc.Total: 97.70 1119-Gertens Line Item Account 40816 10/05/2012 Inv 266983 Line Item Date Line Item Description Line Item Account 09/19/2012 Valentine Park Rain Garden 227-48315-42250 6,826.37 Inv 266983 Total 6,826.37 Inv 266996 Line Item Date Line Item Description Line Item Account 09/19/2012 2011 PMP Rain Garden Replants 604-48510-42250 284.29 Inv 266996 Total 284.29 40816 Total: 7,110.66 1119-Gertens Total: 7,110.66 7036-Gopher State Sealcoat,Inc Line Item Account 40817 10/05/2012 Inv 13671 Line Item Date Line Item Description Line Item Account 09/20/2012 2012 Trail Maintenance 227-48205-44033 2,169.00 AP-Check Detail(10/5/2012- 2:36 PM) Page 3 Check Number Check Date Amount Inv 13671 Total 2,169.00 40817 Total: 2,169.00 7036-Gopher State Sealcoat,Inc Total: 2,169.00 0192-Grainger,Inc Line Item Account 40818 10/05/2012 Inv 9919090788 Line Item Date Line Item Description Line Item Account 09/05/2012 PW Parts 727-49700-42400 126.14 Inv 9919090788 Total 126.14 Inv 9921565421 Line Item Date Line Item Description Line Item Account 09/07/2012 PW Parts 727-49700-42210 77.72 Inv 9921565421 Total 77.72 40818 Total: 203.86 0192-Grainger,Inc Total: 203.86 1372-Hillcrest Animal Hospital Line Item Account 40819 10/05/2012 Inv 11116-082012 Line Item Date Line Item Description Line Item Account 09/06/2012 Animal Control Services August 2012 101-42100-43150 374.22 Inv 1 1116-082012 Total 374.22 40819 Total: 374.22 1372-Hillcrest Animal Hospital Total: 374.22 1040-Hoisington Koegler Group Inc.Line Item Account 40820 10/05/2012 Inv 012-041-1 Line Item Date Line Item Description Line Item Account 09/08/2012 Gateway Sign Expenses 411-48509-43100 280.00 Inv 012-041-1 Total 280.00 40820 Total: 280.00 AP-Check Detail(10/5/2012- 2:36 PM) Page 4 Check Number Check Date Amount 1040-Hoisington Koegler Group Inc.Total: 280.00 JOHC-Johnson Controls Line Item Account 40821 10/05/2012 Inv 1-5785227645 Line Item Date Line Item Description Line Item Account 09/14/2012 City Hall Repair 101-41940-44010 284.32 Inv 1-5785227645 Total 284.32 Inv 1-5847901585 Line Item Date Line Item Descrintion Line Item Account 09/27/2012 City Hall Repair 101-41940-44010 555.60 Inv 1-5847901585 Total 555.60 40821 Total: 839.92 JOHC-Johnson Controls Total: 839.92 7501-Kelly&Lemmons,P.A.Line Item Account 40822 10/05/2012 Inv 11897-082012 Line Item Date Line Item Descrintion Line Item Account 08/30/2012 August 2012 Legal Fees-Admin 101-41300-43040 167.00 08/30/2012 August 2012 Legal Fees-P&Z 101-41940-43040 407.00 08/30/2012 August 2012 Legal Fees-Inspections 101-42400-43040 181.50 08/30/2012 August 2012 Legal Fees-AT&T Escrow 101-00000-22000 432.00 08/30/2012 August 2012 Legal Fees-2006 PMP 411-48501-43040 328.00 08/30/2012 August 2012 Legal Fees-SS Easement 101-42400-43040 72.00 08/30/2012 August 2012 Legal Fees-AT&T Escrow 101-00000-22000 120.00 08/30/2012 August 2012 Legal Fees-P&Z 101-41910-43040 180.00 08/30/2012 August 2012 Legal Fees-P&Z 101-41910-43040 636.00 08/30/2012 August 2012 Legal Fees-ELA Trail/Safe Routes 227-48208-43040 70.00 08/30/2012 August 2012 Legal Fees-Prosecution 101-41300-43045 4,179.38 Inv 11897-082012 Total 6,772.88 40822 Total: 6,772.88 7501-Kelly&Lemmons,P.A.Total: 6,772.88 KEGC-Kennedy&Graven Line Item Account 40823 10/05/2012 Inv 110380 Line Item Date Line Item Descrintion Line Item Account 09/26/2012 August 2012 Legal Fees 101-41600-43040 3,602.07 Inv 110380 Total 3,602.07 AP-Check Detail(10/5/2012- 2:36 PM) Page 5 Check Number Check Date Amount 40823 Total: 3,602.07 KEGC-Kennedy&Graven Total: 3,602.07 8081-Kimley-Horn and Associates,Inc Line Item Account 40824 10/05/2012 Inv 4920779 Line Item Date Line Item Description Line Item Account 08/31/2012 Snelling Engineering Services August 2012 411-48507-43030 3,034.71 Inv 4920779 Total 3,034.71 40824 Total: 3,034.71 8081-Kimley-Horn and Associates,Inc Total: 3,034.71 7500-Kollmer Consultants,Inc.Line Item Account 40825 10/05/2012 Inv 1611 Line Item Date Line Item Description Line Item Account 08/31/2012 Water Tower Maintenance 411-48514-44030 3,218.00 Inv 1611 Total 3,218.00 Inv 1612 Line Item Date Line Item Description Line Item Account 08/31/2012 Water Tower Maintenance 411-48514-44030 2,800.00 Inv 1612 Total 2,800.00 40825 Total: 6,018.00 7500-Kollmer Consultants,Inc.Total: 6,018.00 5443-Metro Products,Inc.Line Item Account 40826 10/05/2012 Inv 87370 Line Item Date Line Item Description Line Item Account 09/11/2012 PW Supplies 727-49700-42210 413.63 Inv 87370 Total 413.63 40826 Total: 413.63 5443-Metro Products,Inc.Total: 413.63 AP-Check Detail(10/5/2012- 2:36 PM) Page 6 Check Number Check Date Amount 1058-MIDC Enterprises Line Item Account 40827 10/05/2012 Inv 10031062 Line Item Date Line Item Description Line Item Account 09/10/2012 PW Supplies 727-49700-42150 34.29 Inv I0031062 Total 34.29 34.29 40827 Total: 1058-MIDC Enterprises Total: 34.29 3371-Midwest Testing LLC Line Item Account 40828 10/05/2012 Inv 2554 Line Item Date Line Item Description Line Item Account 09/11/2012 2012 Water Meter Replacement 601-48517-45600 5,648.00 Inv 2554 Total 5,648.00 40828 Total: 5,648.00 3371-Midwest Testing LLC Total: 5,648.00 6713-Miller,Deanna Line Item Account 40829 10/05/2012 Inv 201 Line Item Date Line Item Description Line Item Account 10/04/2012 October 2012 Crocheting Class 101-45120-43070 28.80 Inv 201 Total 28.80 28.80 40829 Total: 6713-Miller,Deanna Total: 28.80 8374-Natural Shore Technologies Line Item Account 40830 10/05/2012 Inv 2530 Line Item Date Line Item Description Line Item Account 09/10/2012 Indian Oaks Pond Maintenance 2012 604-49550-42250 90.00 90.00 Inv 2530 Total 90.00 40830 Total: AP-Check Detail(10/5/2012- 2:36 PM) Page 7 Check Number Check Date Amount 8374-Natural Shore Technologies Total: 90.00 6252-Office Depot Line Item Account 40831 10/05/2012 Inv 1505373051 Line Item Date Line Item Description Line Item Account 09/07/2012 CAH Supplies 101-45400-42170 60.94 Inv 1505373051 Total 60.94 40831 Total: 60.94 6252-Office Depot Total: 60.94 0530-Olson,Michelle Line Item Account 0 10/05/2012 Inv 10012012-1 Line Item Date Line Item Description Line Item Account 10/01/2012 July-August 2012 Mileage Reimbursement 101-45200-43310 54.67 Inv 10012012-1 Total 54.67 Inv 10012012-2 Line Item Date Line Item Description Line Item Account 10/01/2012 August-September 2012 Mileage Reimbursement 101-45200-43310 58.28 Inv 10012012-2 Total 58.28 Inv 10012012-3 Line Item Date Line Item Description Line Item Account 10/01/2012 September 2012 Mileage Reimbursement 101-45200-43310 191.75 Inv 10012012-3 Total 191.75 0 Total: 304.70 0530-Olson,Michelle Total: 304.70 7084-OmniSite Line Item Account 40832 10/05/2012 Inv 34346 Line Item Date Line Item Description Line Item Account 09/11/2012 Lift Station Security Sept-Dec 2012 601-49440-44010 42.35 09/11/2012 Lift Station Security Sept-Dec 2012 602-49490-44010 42.34 Inv 34346 Total 84.69 AP-Check Detail(10/5/2012- 2:36 PM) Page 8 Check Number Check Date Amount 84.69 40832 Total: 7084-OmniSite Total: 84.69 0316-Oriental Trading Co.,Inc.Line Item Account 40833 10/05/2012 Inv 652822778-01 Line Item Date Line Item Description Line Item Account 09/07/2012 CAH Prizes 101-45400-42170 137.49 Inv 652822778-01 Total 137.49 40833 Total: 137.49 0316-Oriental Trading Co.,Inc.Total: 137.49 1074-Precision Landscape&Tree Line Item Account 40834 10/05/2012 Inv 21742 Line Item Date Line Item Description Line Item Account 09/05/2012 Fox Ridge Tree Removal 101-00000-22000 425.00 Inv 21742 Total 425.00 40834 Total: 425.00 1074-Precision Landscape&Tree Total: 425.00 0811-Ramsey County Line Item Account 40835 10/05/2012 Inv PUBW-012130 Line Item Date Line Item Description Line Item Account 09/10/2012 August 2012 Fuel Purchase 727-49700-42120 4,009.08 Inv PUBW-012130 Total 4,009.08 40835 Total: 4,009.08 0811-Ramsey County Total: 4,009.08 7064-Rotary Club of Arden Hills/Shoreview Line Item Account 40836 10/05/2012 Inv 1041 Line Item Date Line Item Description Line Item Account 09/21/2012 Q4 2012 Dues 250-47300-44330 190.60 AP-Check Detail(10/5/2012- 2:36 PM) Page 9 Check Number Check Date Amount 190.60 Inv 1041 Total 190.60 40836 Total: 7064-Rotary Club of Arden Hills/Shoreview Total: 190.60 1054-SHI International Corp.Line Item Account 40837 10/05/2012 Inv B00758390 Line Item Date Line Item Description Line Item Account 09/07/2012 City Hall IT Room 101-41940-44010 554.82 Inv B00758390 Total 554.82 Inv B00760724 Line Item Date Line Item Description Line Item Account 09/11/2012 IT Room Switch 101-41940-44010 211.14 Inv B00760724 Total 211.14 765.96 40837 Total: 1054-SHI International Corp.Total: 765.96 0576-TimeSaver Off Site Secretarial Line Item Account 40838 10/05/2012 Inv M19293 Line Item Date Line Item Description Line Item Account 09/12/2012 09.05.12 Planning Commission Meeting 101-41910-43110 157.50 Inv M19293 Total 157.50 157.50 40838 Total: 0576-TimeSaver Off Site Secretarial Total: 157.50 1175-TNT Cleaning and Consulting,INC Line Item Account 40839 10/05/2012 Inv 262320 Line Item Date Line Item Description Line Item Account 09/10/2012 September 2012 Cleaning 101-41940-43840 903.09 Inv 262320 Total 903.09 903.09 40839 Total: AP-Check Detail(10/5/2012- 2:36 PM) Page 10 Check Number Check Date Amount 1175-TNT Cleaning and Consulting,INC Total: 903.09 53,210.79 Total: AP-Check Detail(10/5/2012- 2:36 PM) Page 11 Accounts Payable Check Detail User: ashley.bertrand Printed: 10/05/2012- 2:46PM N H] ILLS Check Number Check Date Amount 8741-CW Houle,Inc.Line Item Account 40840 10/05/2012 Inv 9814 Line Item Date Line Item Description Line Item Account 09/19/2012 Water Emergency Valve Repairs 601-49440-44020 25,500.00 25,500.00 Inv 9814 Total 25,500.00 40840 Total: 25,500.00 8741-CW Houle,Inc.Total: 7036-Gopher State Sealcoat,Inc Line Item Account 40841 10/05/2012 Inv 13672 Line Item Date Line Item Description Line Item Account 09/20/2012 2012 Seal Coat 101-43100-42240 29,070.50 29,070.50 Inv 13672 Total 29,070.50 40841 Total: 29,070.50 7036-Gopher State Sealcoat,Inc Total: 0495-Lake Johanna Fire Department Inc.Line Item Account 40842 10/05/2012 Inv 407 Line Item Date Line Item Description Line Item Account 09/07/2012 2012 Capital Reimbursement 412-48120-45800 5,763.96 5,763.96 Inv 407 Total 5,763.96 40842 Total: 5,763.96 0495-Lake Johanna Fire Department Inc.Total: 0811-Ramsey County Line Item Account 40843 10/05/2012 Page 1 AP-Check Detail(10/5/2012- 2:46 PM) Check Number Check Date Amount Inv SHRFL-001159 Line Item Date Line Item Description Line Item Account 09/01/2012 September 2012 RC Sheriff 101-42100-43120 81,304.61 Inv SHRFL-001159 Total 81,304.61 81,304.61 40843 Total: 81,304.61 0811-Ramsey County Total: 1155-Tierny Brothers Line Item Account 40844 10/05/2012 Inv 514-1 Line Item Date Line Item Description Line Item Account 09/14/2012 Council Chambers Mixer Upgrade 228-41960-44010 8,281.26 8,281.26 Inv 514-1 Total 8,281.26 40844 Total: 8,281.26 1155-Tierny Brothers Total: 149,920.33 Total: AP-Check Detail(10/5/2012- 2:46 PM) Page 2