The URL can be used to link to this page

Home My WebLink About5A, Claims and Payroll ,i`RQEENHILLS 5A Request for Council Action Prepared By: Ashley Bertrand, Sue Iverson Council Meeting Date: November 26,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#24 $74,652.62 Total Payroll $ 74,652.62 Accounts Payable Claims Through 11-23-2012 Paid Claims (Check No. 0 US Bank EFT) $ 2,087.16 Paid Claims (Check No. 40975 thru Check No. 41009) $ 123,711.51 Paid Claims (Check No. 41010 thru Check No. 410 10) $ 470.69 VOID (Check No. 41011 thru Check No. 41014) $ 0.00 Paid Claims (Check No. 41015 thru Check No. 4105 1) $ 46,988.10 Paid Claims (Check No. 41052 thru Check No. 41057) $ 586,104.66 Total Claims $ 759,362.12 CITY OF ARDEN HILLS PAYROLL#24 CHECKS DATED: 11/23/12 Biweekly: 11/03/12 TO 11/16/12 C1YIPL .VVE:OEI)UCTI?fliNS AMT:;;!; CITY FIT 7,329.70 >,>;' > '...... >> »<:EFT ... .. .:......................... SIT 2,931.62 '< <>><>>%»> > ><> EFT FICA Oasdi 2,462.52 3,635.52 EFT FICA Medicare 920.52 920.52 EFT TOTAL TAXES 13,644.36 4,556.04 Health Premium 1,312.56 A/P Check* Dental Premium A/P Check* FSA Health Care Reimb. 225.00 >> A/P Check* FSA Dependent Care Reimb. 526.28 ? A/P Check* TOTAL FLEXIBLE SPENDING 2,063.84 1 050 HSA Health S ving 205.16 0.00 11TOTAL HEALTH SAVINGS 205.16 0.00 PERA 3,745.03 4,344.24 EFT ICMA 2,183.50 327.76 A/P Check* Central Pension Fund-Union 614.40 A/P Check* TOTAL RETIREMENT 6,542.93 4,672.00 IUOE 49 Dues Union 130.00 » A/P Check* LTD/STD Insurance 0.00 A/P Check* PERA Life Insurance 40.00 A/P Check* Life/Addl/Dep Life 105.70 0.00 A/P Check* Mn Child Sup ort 323.02 A/P Check* 11TOTAL VOLUNTARY 598.72 1 0.00 Total Employee Deductions 23;QSS:OT: PR Check# 17354-17357 Net Payroll 2,323.44 EFT Direct Deposit 40,046.13 Gross Payroll Tie-Out 65,424.58 STD/LTD Gross-Up 0.00 Plus City Paid Benefit 9;228:04: °4tli >.::::Benat Held> ><>< i>> >" > ;;; > « .............. TOTAL PAYROLL COST 74,652.62 Gross Payroll ::::::65:,424.5:8.j Less Total FSA 2;063::8:4 Plus Employer Match ICMA Q:QO Plus ICMA Benefit Held Q:00 Net P/R Subject to FICA FICA Oasdi 6.20% a:s4fr2:5:2: FICA Medicare A 1.45% :::920:52: 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: 11/21/2012- 1:35PM Check Number Check Date Amount 0602-US BANK Line Item Account 0 11/09/2012 Inv Arvidson Line Item Date Line Item Description Line Item Account 09/13/2012 Uniform Allowance-Arvidson 727-49700-42111 52.96 09/15/2012 Day In Park Supplies 101-45200-42010 11.98 09/25/2012 Snowplow Training 727-49700-44325 75.00 09/25/2012 Snowplow Training 727-49700-44325 75.00 09/25/2012 CTAP Training 727-49700-44325 25.00 10/09/2012 PW Supplies 727-49700-42270 24.30 Inv Arvidson Total 264.24 Inv Freyberger Line Item Date Line Item Description Line Item Account 09/13/2012 PW Tools 727-49700-42400 331.18 Inv Freyberger Total 331.18 Inv Grant Line Item Date Line Item Description Line Item Account 09/12/2012 Celebrating AH Supplies 101-45400-42170 38.52 09/15/2012 Celebrating AH Supplies-Caricaturist 101-45400-42170 85.50 09/15/2012 Celebrating AH Supplies-Caricaturist 101-45400-42170 100.00 09/15/2012 Celebrating AH Supplies 101-45400-42170 23.56 09/26/2012 Creepy Crafts-Supplies 101-45120-42170 9.64 09/26/2012 Creepy Crafts-Supplies 101-45120-42170 5.36 09/26/2012 Creepy Crafts-Supplies 101-45120-42170 65.41 09/26/2012 Creepy Crafts-Supplies 101-45120-42170 49.75 09/26/2012 Creepy Crafts-Supplies 101-45120-42170 31.63 09/11/2012 Recreation Supplies 101-45120-42010 107.11 Inv Grant Total 516.48 Inv Holmes Line Item Date Line Item Description Line Item Account 09/26/2012 Holmes-conference registration refund 101-41100-44325 -360.00 Inv Holmes Total -360.00 Inv Hutmacher Line Item Date Line Item Description Line Item Account 09/26/2012 Leadership Luncheon 101-41910-44325 50.00 09/26/2012 Economic Development after Natural Disaster 101-41910-44325 30.00 AP-Check Detail(11/21/2012- 1:35 PM) Page 1 Check Number Check Date Amount Inv Hutmacher Total 80.00 Inv Iverson Line Item Date Line Item Description Line Item Account 09/19/2012 Hotel for Conference 101-41500-44325 230.86 09/21/2012 HR Training Materials 101-41500-44325 99.00 09/21/2012 Hotel for Conference 101-41500-44325 173.13 10/08/2012 Beginning Government Training Class 101-41500-44325 100.00 10/08/2012 Intermediate Government Training Class 101-41500-44325 100.00 10/08/2012 Advanced Government Training Class 101-41500-44325 100.00 10/08/2012 GFOA Training 101-41500-44325 135.00 10/08/2012 Tabs for Copier 101-41500-42030 107.39 10/09/2012 You Send It-License 728-49900-44330 14.99 09/26/2012 Credit on Card 101-41500-44390 -197.00 Inv Iverson Total 863.37 Inv Olson Line Item Date Line Item Description Line Item Account 09/14/2012 CAH Supplies 101-45400-42170 31.92 09/18/2012 Conference Lodging 101-45120-44325 127.18 09/18/2012 Conference Lodging 101-45200-44325 127.18 10/08/2012 City Tree Registry Fee 101-45200-44050 25.50 10/09/2012 Adult softball plaque Mailing 101-45120-42172 5.30 09/14/2012 CAH Supplies 101-45400-42170 12.85 Inv Olson Total 329.93 Inv Saxe Line Item Date Line Item Description Line Item Account 09/11/2012 Uniform Allowance-Saxe 727-49700-42111 52.97 Inv Saxe Total 52.97 Inv Schifsky Line Item Date Line Item Description Line Item Account 10/08/2012 Uniform Allowance-Schifsky 727-49700-42111 8.99 Inv Schifsky Total 8.99 0 Total: 2,087.16 0602-US BANK Total: 2,087.16 Total: 2,087.16 AP-Check Detail(11/21/2012- 1:35 PM) Page 2 Accounts Payable Check Detail User: ashley.bertrand Printed: 11/21/2012- 1:33PM Check Number Check Date Amount 1223-Adam's Pest Control,Inc.Line Item Account 40975 11/15/2012 Inv 757278 Line Item Date Line Item Description Line Item Account 09/28/2012 September 2012 Pest Control Services 101-41940-44010 66.84 Inv 757278 Total 66.84 40975 Total: 66.84 1223-Adam's Pest Control,Inc.Total: 66.84 0282-Allied Waste Services#899 Line Item Account 40976 11/15/2012 Inv 0899-002160509 Line Item Date Line Item Description Line Item Account 10/25/2012 November 2012 Trash Service 101-41940-43840 232.83 10/25/2012 November 2012 Trash Service 101-45200-43840 416.02 Inv 0899-002160509 Total 648.85 40976 Total: 648.85 0282-Allied Waste Services#899 Total: 648.85 8635-Asphalt Surface Technologies(ASTECH)Line Item Account 40977 11/15/2012 Inv 10292012 Line Item Date Line Item Description Line Item Account 10/29/2012 2011 PMP Payment#4(Final Payment) 411-48510-45900 46,150.96 10/29/2012 2011 PMP Payment#4(Final Payment) 604-48510-45900 4,956.74 10/29/2012 2011 PMP Payment#4(Final Payment) 601-48510-45900 11,181.93 10/29/2012 2011 PMP Payment#4(Final Payment) 602-48510-45900 2,362.17 Inv 10292012 Total 64,651.80 40977 Total: 64,651.80 8635-Asphalt Surface Technologies(ASTECH)Total: 64,651.80 AP-Check Detail(11/21/2012- 1:33 PM) Page 1 Check Number Check Date Amount 6060-Batteries Plus Line Item Account 40978 11/15/2012 Inv 028-373198 Line Item Date Line Item Description Line Item Account 10/15/2012 PW Supplies 727-49700-42210 225.51 Inv 028-373198 Total 225.51 Inv 028-373295 Line Item Date Line Item Description Line Item Account 10/16/2012 PW Supplies 727-49700-42210 24.53 Inv 028-373295 Total 24.53 40978 Total: 250.04 6060-Batteries Plus Total: 250.04 1183-Bauer Built Inc.Line Item Account 40979 11/15/2012 Inv 180084800 Line Item Date Line Item Description Line Item Account 10/19/2012 PW Supplies 727-49700-42210 660.83 Inv 180084800 Total 660.83 40979 Total: 660.83 1183-Bauer Built Inc.Total: 660.83 0131-Beisswenger's How-To Store Line Item Account 40980 11/15/2012 Inv 229598 Line Item Date Line Item Description Line Item Account 10/16/2012 PW Supplies 727-49700-42210 62.18 Inv 229598 Total 62.18 Inv 230022 Line Item Date Line Item Description Line Item Account 10/17/2012 PW Supplies 727-49700-42210 9.65 Inv 230022 Total 9.65 Inv 230136 Line Item Date Line Item Description Line Item Account 10/17/2012 PW Supplies 727-49700-42210 3.20 AP-Check Detail(11/21/2012- 1:33 PM) Page 2 Check Number Check Date Amount Inv 230136 Total 3.20 Inv 232945 Line Item Date Line Item Description Line Item Account 10/24/2012 PW Supplies 727-49700-42210 203.78 Inv 232945 Total 203.78 Inv 233101 Line Item Date Line Item Description Line Item Account 10/24/2012 PW Supplies 727-49700-42210 21.67 Inv 233101 Total 21.67 Inv 233135 Line Item Date Line Item Description Line Item Account 10/24/2012 PW Supplies 727-49700-42210 26.16 Inv 233135 Total 26.16 Inv 233712 Line Item Date Line Item Description Line Item Account 10/26/2012 PW Supplies 727-49700-42210 58.91 Inv 233712 Total 58.91 Inv 234082 Line Item Date Line Item Description Line Item Account 10/27/2012 PW Supplies 727-49700-42210 13.46 Inv 234082 Total 13.46 Inv 235442 Line Item Date Line Item Description Line Item Account 10/30/2012 PW Supplies 727-49700-42210 27.23 Inv 235442 Total 27.23 Inv 235667 Line Item Date Line Item Description Line Item Account 10/30/2012 PW Supplies 727-49700-42210 19.97 Inv 235667 Total 19.97 40980 Total: 446.21 0131-Beisswenger's How-To Store Total: 446.21 1125-Bolton&Menk,Inc.Line Item Account 40981 11/15/2012 AP-Check Detail(11/21/2012- 1:33 PM) Page 3 Check Number Check Date Amount Inv 0151329 Line Item Date Line Item Description Line Item Account 10/15/2012 132 District Improvements September 2012 411-48311-43030 507.50 Inv 0151329 Total 507.50 40981 Total: 507.50 1125-Bolton&Menk,Inc.Total: 507.50 4458-BTS Construction LLC Line Item Account 40982 11/15/2012 Inv 11092012 Line Item Date Line Item Description Line Item Account 11/09/2012 Escrow Release-50% 101-00000-22000 15,842.00 Inv 11092012 Total 15,842.00 40982 Total: 15,842.00 4458-BTS Construction LLC Total: 15,842.00 CANO-Canon Business Solutions Line Item Account 40983 11/15/2012 Inv 4008005247 Line Item Date Line Item Description Line Item Account 10/28/2012 Aug-Oct 2012 Copier Supplies 101-41500-42010 473.81 Inv 4008005247 Total 473.81 40983 Total: 473.81 CANO-Canon Business Solutions Total: 473.81 CANON-Canon Business Solutions,Inc Line Item Account 40984 11/15/2012 Inv 12251514 Line Item Date Line Item Description Line Item Account 11/01/2012 November 2012 Contract Charge 101-41500-44150 879.37 11/01/2012 November 2012 Contract Charge 228-41960-44150 155.18 Inv 12251514 Total 1,034.55 40984 Total: 1,034.55 CANON-Canon Business Solutions,Inc Total: 1,034.55 AP-Check Detail(11/21/2012- 1:33 PM) Page 4 Check Number Check Date Amount 0706-Certified Laboratories Line Item Account 40985 11/15/2012 Inv 895343 Line Item Date Line Item Description Line Item Account 10/25/2012 PW Supplies 727-49700-42245 145.72 Inv 895343 Total 145.72 Inv 896640 Line Item Date Line Item Description Line Item Account 10/25/2012 PW Supplies 727-49700-42150 638.42 Inv 896640 Total 638.42 40985 Total: 784.14 0706-Certified Laboratories Total: 784.14 1032-Commercial Asphalt Co.Line Item Account 40986 11/15/2012 Inv AR180-102012 Line Item Date Line Item Description Line Item Account 10/31/2012 Street Maintenance Materials 101-43100-42245 348.42 Inv AR 180-102012 Total 348.42 40986 Total: 348.42 1032-Commercial Asphalt Co.Total: 348.42 0155-Dept.of Administration Line Item Account 40987 11/15/2012 Inv W12090680 Line Item Date Line Item Description Line Item Account 10/17/2012 September 2012 Phone Services 728-49900-43210 702.45 Inv W 12090680 Total 702.45 40987 Total: 702.45 0155-Dept.of Administration Total: 702.45 1297-Diversified Inspections/Ind.Testing Labs,Inc.Line Item Account 40988 11/15/2012 Inv 217069-DIITL Line Item Date Line Item Description Line Item Account AP-Check Detail(11/21/2012- 1:33 PM) Page 5 Check Number Check Date Amount 10/19/2012 2012 Vehicle Lift Inspection 101-42300-44010 765.00 Inv 217069-DIITL Total 765.00 40988 Total: 765.00 1297-Diversified Inspections/Ind.Testing Labs,Inc.Total: 765.00 0841-Ehlers&Associates,Inc.Line Item Account 40989 11/15/2012 Inv 345427 Line Item Date Line Item Description Line Item Account 10/16/2012 TIF Policy Charges 251-47300-43090 292.50 Inv 345427 Total 292.50 40989 Total: 292.50 0841-Ehlers&Associates,Inc.Total: 292.50 2129-Elfering&Associates Line Item Account 40990 11/15/2012 Inv 1722 Line Item Date Line Item Description Line Item Account 10/01/2012 2011 PMP Engineering Services September 2012 411-48510-43030 1,495.00 Inv 1722 Total 1,495.00 Inv 1723 Line Item Date Line Item Description Line Item Account 10/01/2012 Fox Ridge Escrow Engineering Services September 2012 101-00000-22000 2,600.00 Inv 1723 Total 2,600.00 Inv 1724 Line Item Date Line Item Description Line Item Account 10/01/2012 Pres Homes Escrow Engineering Services September 2012 101-00000-22000 487.50 Inv 1724 Total 487.50 Inv 1725 Line Item Date Line Item Description Line Item Account 10/01/2012 Valentine Park Engineering Services September 2012 604-48315-43030 2,405.50 Inv 1725 Total 2,405.50 Inv 1726 Line Item Date Line Item Description Line Item Account 10/01/2012 Lift Stations 1&12 Engineering Services September 2012 602-48402-43030 3,545.00 AP-Check Detail(11/21/2012- 1:33 PM) Page 6 Check Number Check Date Amount Inv 1726 Total 3,545.00 40990 Total: 10,533.00 2129-Elfering&Associates Total: 10,533.00 ENGE-Engebretson,Dan Line Item Account 40991 11/15/2012 Inv 11072012 Line Item Date Line Item Description Line Item Account 11/07/2012 2012 Wrestling League Contractor Fee 101-45120-43070 577.60 Inv 11072012 Total 577.60 40991 Total: 577.60 ENGE-Engebretson,Dan Total: 577.60 FAST-Fastenal Line Item Account 40992 11/15/2012 Inv MNSPR75282 Line Item Date Line Item Description Line Item Account 10/11/2012 PW Supplies 602-49490-42245 78.58 Inv MNSPR75282 Total 78.58 Inv MNSPR75401 Line Item Date Line Item Description Line Item Account 10/16/2012 PW Supplies 602-49490-42245 36.94 Inv MNSPR75401 Total 36.94 40992 Total: 115.52 FAST-Fastenal Total: 115.52 FPTC-Flexible Pipe Tool Company Line Item Account 40993 11/15/2012 Inv 15740 Line Item Date Line Item Description Line Item Account 10/17/2012 PW Supplies 727-49700-42210 482.96 Inv 15740 Total 482.96 40993 Total: 482.96 AP-Check Detail(11/21/2012- 1:33 PM) Page 7 Check Number Check Date Amount FPTC-Flexible Pipe Tool Company Total: 482.96 0176-Frattallone's Hardware,Inc.Line Item Account 40994 11/15/2012 Inv 050974-A Line Item Date Line Item Description Line Item Account 10/17/2012 PW Supplies 727-49700-42210 6.94 Inv 050974-A Total 6.94 40994 Total: 6.94 0176-Frattallone's Hardware,Inc.Total: 6.94 0192-Grainger,Inc Line Item Account 40995 11/15/2012 Inv 9958190747 Line Item Date Line Item Description Line Item Account 10/23/2012 PW Supplies 727-49700-42210 147.94 Inv 9958190747 Total 147.94 40995 Total: 147.94 0192-Grainger,Inc Total: 147.94 0447-LU.O.E Local 49 Benefit Fund-Insurance Line Item Account 101-00000-21732 40996 11/15/2012 Inv 11.15.2012 Line Item Date Line Item Description Line Item Account 11/15/2012 December 2012 PW Benefits 101-00000-21732 1,067.00 Inv 11.15.2012 Total 1,067.00 Inv 11152012 Line Item Date Line Item Description Line Item Account 11/15/2012 December 2012 PW Benefits 101-00000-21732 7,536.00 Inv 11152012 Total 7,536.00 40996 Total: 8,603.00 0447-I.U.O.E Local 49 Benefit Fund-Insurance Total: 8,603.00 8081-Kimley-Horn and Associates,Inc Line Item Account 40997 11/15/2012 AP-Check Detail(11/21/2012- 1:33 PM) Page 8 Check Number Check Date Amount Inv 4950133 Line Item Date Line Item Description Line Item Account 09/30/2012 Snelling Project Engineering Services(Bridge Design) 411-48507-43030 1,120.53 Inv 4950133 Total 1,120.53 40997 Total: 1,120.53 8081-Kimley-Horn and Associates,Inc Total: 1,120.53 0222-League of Minnesota Cities Line Item Account 40998 11/15/2012 Inv 170616 Line Item Date Line Item Description Line Item Account 09/01/2012 MN Cities Coalition Contribution 604-49550-44330 620.00 Inv 170616 Total 620.00 40998 Total: 620.00 0222-League of Minnesota Cities Total: 620.00 7056-Master Electric Co.Inc.Line Item Account 40999 11/15/2012 Inv SD2179 Line Item Date Line Item Description Line Item Account 10/18/2012 City Hall Electrical Services 101-41940-44010 177.50 Inv SD2179 Total 177.50 40999 Total: 177.50 7056-Master Electric Co.Inc.Total: 177.50 1058-MIDC Enterprises Line Item Account 41000 11/15/2012 Inv I0031338 Line Item Date Line Item Description Line Item Account 10/09/2012 PW Supplies 727-49700-42150 54.34 Inv 10031338 Total 54.34 Inv I0031339 Line Item Date Line Item Description Line Item Account 10/09/2012 PW Supplies 727-49700-42210 15.55 Inv I0031339 Total 15.55 AP-Check Detail(11/21/2012- 1:33 PM) Page 9 Check Number Check Date Amount 41000 Total: 69.89 1058-MIDC Enterprises Total: 69.89 0731-MIDWAY FORD Line Item Account 41001 11/15/2012 Inv 349629 Line Item Date Line Item Description Line Item Account 10/08/2012 PW#302 Vehicle Repair 727-49700-44040 3,877.31 Inv 349629 Total 3,877.31 41001 Total: 3,877.31 0731-MIDWAY FORD Total: 3,877.31 0147-Moundsview Public Schools Line Item Account 41002 11/15/2012 Inv 4770 Line Item Date Line Item Description Line Item Account 11/06/2012 Facility Rental-Sept-Oct 2012 101-45120-44125 188.88 Inv 4770 Total 188.88 41002 Total: 188.88 0147-Moundsview Public Schools Total: 188.88 4445-Pioneer Rim and Wheel Co.Line Item Account 41003 11/15/2012 Inv 1-176414 Line Item Date Line Item Description Line Item Account 10/18/2012 PW Supplies Vehicle#305 727-49700-42210 239.46 Inv 1-176414 Total 239.46 Inv 1-176415 Line Item Date Line Item Description Line Item Account 10/18/2012 PW Supplies Vehicle#305 727-49700-42210 3.34 Inv I-176415 Total 3.34 41003 Total: 242.80 4445-Pioneer Rim and Wheel Co.Total: 242.80 AP-Check Detail(11/21/2012- 1:33 PM) Page 10 Check Number Check Date Amount 0310-Ramsey Co.League Local Gov't Line Item Account 41004 11/15/2012 Inv 1153186-4958514 Line Item Date Line Item Description Line Item Account 11/08/2012 2012 Annual Meeting&Program 101-41100-44330 20.00 Inv 1153186-4958514 Total 20.00 41004 Total: 20.00 0310-Ramsey Co.League Local Gov't Total: 20.00 1453-Springbrook National User Group Line Item Account 41005 11/15/2012 Inv 484 Line Item Date Line Item Description Line Item Account 10/24/2012 2013 Membership Renewal 101-41500-44330 25.00 10/24/2012 2013 Membership Renewal 601-49440-44330 25.00 10/24/2012 2013 Membership Renewal 602-49490-44330 25.00 10/24/2012 2013 Membership Renewal 604-49550-44330 25.00 Inv 484 Total 100.00 41005 Total: 100.00 1453-Springbrook National User Group Total: 100.00 5180-Tessman Seed Co.Line Item Account 41006 11/15/2012 Inv 5167324-IN Line Item Date Line Item Description Line Item Account 10/15/2012 Park Supplies 101-45200-42245 1,096.54 Inv S 167324-IN Total 1,096.54 41006 Total: 1,096.54 5180-Tessman Seed Co.Total: 1,096.54 0208-UniSelect USA Line Item Account 41007 11/15/2012 Inv 039110512 Line Item Date Line Item Description Line Item Account 10/15/2012 PW Parts 727-49700-42210 11.56 Inv 039110512 Total 11.56 AP-Check Detail(11/21/2012- 1:33 PM) Page 11 Check Number Check Date Amount 41007 Total: 11.56 0208-UniSelect USA Total: 11.56 0285-Xcel Energy Line Item Account 41008 11/15/2012 Inv 344105930 Line Item Date Line Item Description Line Item Account 10/18/2012 October 2012 Utility Bill 602-49490-43815 55.73 Inv 344105930 Total 55.73 Inv 344168344 Line Item Date Line Item Description Line Item Account 10/18/2012 October 2012 Utility Bill 101-41940-43810 2,467.02 Inv 344168344 Total 2,467.02 Inv 345371808 Line Item Date Line Item Description Line Item Account 10/29/2012 October 2012 Utility Bill 101-42300-43810 21.06 10/29/2012 October 2012 Utility Bill 101-43100-43811 2,085.13 10/29/2012 October 2012 Utility Bill 101-45200-43810 644.60 10/29/2012 October 2012 Utility Bill 601-49440-43810 991.94 10/29/2012 October 2012 Utility Bill 602-49490-43815 1,468.98 Inv 345371808 Total 5,211.71 41008 Total: 7,734.46 0285-Xcel Energy Total: 7,734.46 6009-Ziegler,Inc.Line Item Account 41009 11/15/2012 Inv SW050189531 Line Item Date Line Item Description Line Item Account 10/06/2012 City Hall Generator Repair 602-49490-44040 510.14 Inv SW050189531 Total 510.14 41009 Total: 510.14 6009-Ziegler,Inc.Total: 510.14 Total: 123,711.51 AP-Check Detail(11/21/2012- 1:33 PM) Page 12 Accounts Payable Check Detail User: ashley.bertrand Printed: 11/21/2012- 1:31PM Check Number Check Date Amount 8059-Iverson,Sue Line Item Account 41010 11/16/2012 Inv 11162012 Line Item Date Line Item Description Line Item Account 11/16/2012 Training Reimbursement 725-49800-44325 149.01 11/16/2012 April-November 2012 Mileage Reimbursement 101-41500-43310 231.99 11/16/2012 April-November 2012 Mileage Reimbursement 725-49800-43310 89.69 Inv 11162012 Total 470.69 41010 Total: 470.69 8059-Iverson,Sue Total: 470.69 Total: 470.69 AP-Check Detail(11/21/2012- 1:31 PM) Page 1 Accounts Payable Check Detail User: ashley.bertrand Printed: 11/21/2012- 1:29PM Check Number Check Date Amount 2597-AARP Line Item Account 41015 11/21/2012 Inv 1000 Line Item Date Line Item Description Line Item Account 11/15/2012 November 2012 AARP Class 101-45120-42170 62.00 Inv 1000 Total 62.00 41015 Total: 62.00 2597-AARP Total: 62.00 ARAM-Aramark Uniform Service Line Item Account 41016 11/21/2012 Inv 629-7606826 Line Item Date Line Item Description Line Item Account 10/23/2012 November 2012 Mat Service 101-41940-43840 263.01 Inv 629-7606826 Total 263.01 41016 Total: 263.01 ARAM-Aramark Uniform Service Total: 263.01 1135-Becker Arena Products,Inc.Line Item Account 41017 11/21/2012 Inv 00091485 Line Item Date Line Item Description Line Item Account 10/31/2012 Perry Park Warming House Floors 101-45200-42210 1,496.25 Inv 00091485 Total 1,496.25 41017 Total: 1,496.25 1135-Becker Arena Products,Inc.Total: 1,496.25 1125-Bolton&Menk,Inc.Line Item Account 41018 11/21/2012 AP-Check Detail(11/21/2012- 1:29 PM) Page 1 Check Number Check Date Amount Inv 0151826 Line Item Date Line Item Description Line Item Account 10/30/2012 LS 5,8,13 Engineering Services 602-48401-43030 375.00 Inv 0151826 Total 375.00 41018 Total: 375.00 1125-Bolton&Menk,Inc.Total: 375.00 0755-Boyer Trucks,Inc.Line Item Account 41019 11/21/2012 Inv 683230 Line Item Date Line Item Description Line Item Account 10/22/2012 PW Parts 727-49700-42210 53.12 Inv 683230 Total 53.12 41019 Total: 53.12 0755-Boyer Trucks,Inc.Total: 53.12 0654-Brake&Equipment Warehouse,Inc.Line Item Account 41020 11/21/2012 Inv 1-176561 Line Item Date Line Item Description Line Item Account 10/29/2012 PW Parts 727-49700-42400 373.89 Inv 1-176561 Total 373.89 Inv 1-177070 Line Item Date Line Item Description Line Item Account 10/31/2012 PW Parts 727-49700-42400 154.75 Inv 1-177070 Total 154.75 Inv 1-177306 Line Item Date Line Item Description Line Item Account 10/31/2012 PW Parts Return 727-49700-42400 -128.25 Inv 1-177306 Total -128.25 41020 Total: 400.39 0654-Brake&Equipment Warehouse,Inc.Total: 400.39 4447-Braun Intertec Corporation Line Item Account AP-Check Detail(11/21/2012- 1:29 PM) Page 2 Check Number Check Date Amount 41021 11/21/2012 Inv 600851 Line Item Date Line Item Description Line Item Account 10/18/2012 2013 PMP 411-48511-43030 960.00 Inv 600851 Total 960.00 41021 Total: 960.00 4447-Braun Intertec Corporation Total: 960.00 0154-Cemstone Products Co.Line Item Account 41022 11/21/2012 Inv 1235973 Line Item Date Line Item Description Line Item Account 10/23/2012 Storm Sewer Repair 604-49550-44040 640.32 Inv 1235973 Total 640.32 Inv 1235974 Line Item Date Line Item Description Line Item Account 10/23/2012 Storm Sewer Repair 604-49550-44040 459.94 Inv 1235974 Total 459.94 41022 Total: 1,100.26 0154-Cemstone Products Co.Total: 1,100.26 1032-Commercial Asphalt Co.Line Item Account 41023 11/21/2012 Inv AR180-112012 Line Item Date Line Item Description Line Item Account 11/15/2012 Street Maintenance Materials 101-43100-42245 916.16 Inv AR180-112012 Total 916.16 41023 Total: 916.16 1032-Commercial Asphalt Co.Total: 916.16 4889-Community Footworks Line Item Account 41024 11/21/2012 Inv 1016 Line Item Date Line Item Description Line Item Account 11/07/2012 November 2012 Foot Clinic 101-45120-43070 299.20 Inv 1016 Total 299.20 AP-Check Detail(11/21/2012- 1:29 PM) Page 3 Check Number Check Date Amount 41024 Total: 299.20 4889-Community Footworks Total: 299.20 9632-Duke's Root Control,Inc Line Item Account 41025 11/21/2012 Inv 8664 Line Item Date Line Item Description Line Item Account 10/26/2012 Sewer Repair 602-49490-44040 4,712.76 Inv 8664 Total 4,712.76 41025 Total: 4,712.76 9632-Duke's Root Control,Inc Total: 4,712.76 8047-ECM Publishers,Inc Line Item Account 41026 11/21/2012 Inv 1406608 Line Item Date Line Item Description Line Item Account 10/26/2012 TCN Resource Guide 2012 250-47300-44390 245.00 Inv 1406608 Total 245.00 41026 Total: 245.00 8047-ECM Publishers,Inc Total: 245.00 0887-Force America,Inc.Line Item Account 41027 11/21/2012 Inv 01393857 Line Item Date Line Item Description Line Item Account 10/24/2012 PW Supplies 101-43100-44040 37.45 Inv 01393857 Total 37.45 41027 Total: 37.45 0887-Force America,Inc.Total: 37.45 0192-Grainger,Inc Line Item Account 41028 11/21/2012 Inv 9963233417 Line Item Date Line Item Description Line Item Account 10/29/2012 PW Supplies 727-49700-42210 68.41 AP-Check Detail(11/21/2012- 1:29 PM) Page 4 Check Number Check Date Amount Inv 9963233417 Total 68.41 41028 Total: 68.41 0192-Grainger,Inc Total: 68.41 4456-Hennepin County Treasurer Line Item Account 41029 11/21/2012 Inv 11192012 Line Item Date Line Item Description Line Item Account 11/19/2012 HR Training 2012 101-41500-44325 15.00 Inv 11192012 Total 15.00 41029 Total: 15.00 4456-Hennepin County Treasurer Total: 15.00 0382-ICMA Retirement Trust-106944 Line Item Account 101-00000-21740 41030 11/21/2012 Inv 11202012-PK Line Item Date Line Item Description Line Item Account 11/20/2012 PR#24 Contributions 101-00000-21740 610.31 Inv 11202012-PK Total 610.31 41030 Total: 610.31 0382-ICMA Retirement Trust-106944 Total: 610.31 0387-ICMA Retirement Trust-#302482 Line Item Account 101-00000-21742 41031 11/21/2012 Inv 11202012-CS Line Item Date Line Item Description Line Item Account 11/20/2012 PR#24 Contributions 101-00000-21742 1,900.95 Inv 11202012-CS Total 1,900.95 41031 Total: 1,900.95 0387-ICMA Retirement Trust-#302482 Total: 1,900.95 8306-International League of Cities Line Item Account 41032 11/21/2012 AP-Check Detail(11/21/2012- 1:29 PM) Page 5 Check Number Check Date Amount Inv 11022012 Line Item Date Line Item Description Line Item Account 11/02/2012 2013 Annual Membership 101-41500-44330 750.00 Inv 11022012 Total 750.00 41032 Total: 750.00 8306-International League of Cities Total: 750.00 0916-Lakes Country Service Coop Line Item Account 41033 11/21/2012 Inv CI073HA9-122012 Line Item Date Line Item Description Line Item Account 10/29/2012 December 2012 Health Insurance 101-00000-21730 5,754.00 Inv CI073HA9-122012 Total 5,754.00 Inv CI0731-1137-122012 Line Item Date Line Item Description Line Item Account 10/29/2012 December 2012 Health Insurance 101-00000-21730 881.50 Inv CI0731-1137-122012 Total 881.50 Inv CI073WO0-122012 Line Item Date Line Item Description Line Item Account 10/29/2012 December 2012 Health Insurance 101-00000-21730 945.00 Inv C1073WO0-122012 Total 945.00 41033 Total: 7,580.50 0916-Lakes Country Service Coop Total: 7,580.50 0225-Lillie Suburban Newspapers Line Item Account 41034 11/21/2012 Inv 10312012 Line Item Date Line Item Description Line Item Account 10/31/2012 Ord 2012-007/Fox Ridge Escrow Charges 101-00000-22000 21.00 10/31/2012 Ord 2012-007/Fox Ridge Escrow Charges 101-41910-43510 12.00 Inv 10312012 Total 33.00 Inv 10312012-2 Line Item Date Line Item Description Line Item Account 10/31/2012 CAH Thank Yous 101-45200-42030 325.00 Inv 10312012-2 Total 325.00 AP-Check Detail(11/21/2012- 1:29 PM) Page 6 Check Number Check Date Amount 41034 Total: 358.00 0225-Lillie Suburban Newspapers Total: 358.00 0214-LTG Power Equipment Line Item Account 41035 11/21/2012 Inv 160576 Line Item Date Line Item Description Line Item Account 11/01/2012 PW Supplies 727-49700-42400 70.47 Inv 160576 Total 70.47 Inv 160584 Line Item Date Line Item Description Line Item Account 11/01/2012 PW Supplies 727-49700-42400 71.65 Inv 160584 Total 71.65 41035 Total: 142.12 0214-LTG Power Equipment Total: 142.12 5443-Metro Products,Inc.Line Item Account 41036 11/21/2012 Inv 88324 Line Item Date Line Item Description Line Item Account 10/31/2012 PW Supplies 727-49700-42210 223.98 Inv 88324 Total 223.98 41036 Total: 223.98 5443-Metro Products,Inc.Total: 223.98 0731-MIDWAY FORD Line Item Account 41037 11/21/2012 Inv 150199 Line Item Date Line Item Description Line Item Account 10/22/2012 PW Vehicle Parts 727-49700-42400 49.44 Inv 150199 Total 49'44 Inv 350741 Line Item Date Line Item Description Line Item Account 10/23/2012 PW Vehicle Repair 727-49700-44040 282.84 Inv 350741 Total 282.84 AP-Check Detail(11/21/2012- 1:29 PM) Page 7 Check Number Check Date Amount 41037 Total: 332.28 0731-MIDWAY FORD Total: 332.28 0022-Mikacevich,Thomas Line Item Account 41038 11/21/2012 Inv 310017129165 Line Item Date Line Item Description Line Item Account 10/21/2012 Uniform Expense Reimbursement 727-49700-42111 160.02 Inv 310017129165 Total 160.02 41038 Total: 160.02 0022-Mikacevich,Thomas Total: 160.02 MNCS-Minnesota Child Support Payment Center Line Item Account 101-00000-21780 41039 11/21/2012 Inv 11202012-MNCS Line Item Date Line Item Description Line Item Account 11/20/2012 PR 24 Deductions 101-00000-21780 323.02 Inv 11202012-MNCS Total 323.02 41039 Total: 323.02 MNCS-Minnesota Child Support Payment Center Total: 323.02 6349-Nosek,Mary Line Item Account 41040 11/21/2012 Inv 11162012 Line Item Date Line Item Description Line Item Account 11/16/2012 November 2012 AH Notes 101-41100-43540 180.00 Inv 11162012 Total 180.00 41040 Total: 180.00 6349-Nosek,Mary Total: 180.00 0292-Oxygen Service Company,Inc.Line Item Account 41041 11/21/2012 Inv 07624797 Line Item Date Line Item Description Line Item Account 10/12/2012 PW Supplies 727-49700-42150 73.07 AP-Check Detail(11/21/2012- 1:29 PM) Page 8 Check Number Check Date Amount Inv 07624797 Total 73.07 41041 Total: 73.07 0292-Oxygen Service Company,Inc.Total: 73.07 1074-Precision Landscape&Tree Line Item Account 41042 11/21/2012 Inv 21821 Line Item Date Line Item Description Line Item Account 10/30/2012 1146&1147 Waldon Place Tree Removal 101-45200-44050 2,342.53 Inv 21821 Total 2,342.53 41042 Total: 2,342.53 1074-Precision Landscape&Tree Total: 2,342.53 1208-Premium Waters,Inc Line Item Account 41043 11/21/2012 Inv 610207-10-12 Line Item Date Line Item Description Line Item Account 10/31/2012 CH Supplies 101-41940-42010 46.93 Inv 610207-10-12 Total 46.93 Inv 613317-09-30-2 Line Item Date Line Item Description Line Item Account 09/30/2012 CH Supplies 101-41940-42010 13.47 Inv 613317-09-30-2 Total 13.47 Inv 613317-10-12 Line Item Date Line Item Description Line Item Account 10/31/2012 CH Supplies 101-41940-42010 86.03 Inv 613317-10-12 Total 86.03 41043 Total: 146.43 1208-Premium Waters,Inc Total: 146.43 0811-Ramsey County Line Item Account 41044 11/21/2012 Inv EMCOM-002163 Line Item Date Line Item Description Line Item Account AP-Check Detail(11/21/2012- 1:29 PM) Page 9 Check Number Check Date Amount 10/22/2012 October 2012 911 Dispatch 101-42150-43121 4,101.62 Inv EMCOM-002163 Total 4,101.62 Inv EMCOM-002173 Line Item Date Line Item Description Line Item Account 10/22/2012 October 2012 Fleet Support Fee 101-42300-44330 24.96 Inv EMCOM-002173 Total 24.96 Inv PUBW-012225 Line Item Date Line Item Description Line Item Account 10/08/2012 September 2012 Vehicle Fuels 727-49700-42120 3,438.12 Inv PUBW-012225 Total 3,438.12 Inv PUBW-012256 Line Item Date Line Item Description Line Item Account 10/23/2012 2012 Road Striping 101-43100-42240 5,281.92 Inv PUBW-012256 Total 5,281.92 41044 Total: 12,846.62 0811-Ramsey County Total: 12,846.62 8043-Ranallo,Brian Line Item Account 41045 11/21/2012 Inv 11162012 Line Item Date Line Item Description Line Item Account 11/16/2012 Escrow Release Permit#2010-01656 101-00000-22000 3,000.00 Inv 11162012 Total 3,000.00 41045 Total: 3,000.00 8043-Ranallo,Brian Total: 3,000.00 0327-Staples Business Advantage Line Item Account 41046 11/21/2012 Inv 3184152750 Line Item Date Line Item Description Line Item Account 10/16/2012 Office Supplies 101-41500-42010 394.25 Inv 3184152750 Total 394.25 Inv 3184655768 Line Item Date Line Item Description Line Item Account 10/26/2012 Office Supplies 101-41500-42010 83.26 AP-Check Detail(11/21/2012- 1:29 PM) Page 10 Check Number Check Date Amount Inv 3184655768 Total 83.26 41046 Total: 477.51 0327-Staples Business Advantage Total: 477.51 0925-T-Mobile Line Item Account 41047 11/21/2012 Inv 11222012 Line Item Date Line Item Description Line Item Account 11/22/2012 November 2012 Cell Phone Charges 727-49700-43210 -367.92 11/22/2012 November 2012 Cell Phone Charges 727-49700-43210 1,067.44 Inv 11222012 Total 699.52 41047 Total: 699.52 0925-T-Mobile Total: 699.52 3099-Tri-State Bobcat,Inc.-Little Canada Line Item Account 41048 11/21/2012 Inv E13878 Line Item Date Line Item Description Line Item Account 11/06/2012 Parks Rental 101-45200-44150 292.19 Inv E13878 Total 292.19 41048 Total: 292.19 3099-Tri-State Bobcat,Inc.-Little Canada Total: 292.19 8524-Twin City Hams,LLC Line Item Account 41049 11/21/2012 Inv 18492.22 Line Item Date Line Item Description Line Item Account 10/29/2012 10.29.12 CC Meeting 101-41100-44325 136.88 Inv 18492.22 Total 136.88 41049 Total: 136.88 8524-Twin City Hams,LLC Total: 136.88 0208-UniSelect USA Line Item Account 41050 11/21/2012 AP-Check Detail(11/21/2012- 1:29 PM) Page I Check Number Check Date Amount Inv 039114256 Line Item Date Line Item Description Line Item Account 11/01/2012 PW Supplies 727-49700-42150 379.52 Inv 039114256 Total 379.52 Inv 039114531 Line Item Date Line Item Description Line Item Account 11/03/2012 PW Supplies 727-49700-42400 143.01 Inv 039114531 Total 143.01 41050 Total: 522.53 0208-UniSelect USA Total: 522.53 1339-Vacker Inc.Line Item Account 41051 11/21/2012 Inv 899 Line Item Date Line Item Description Line Item Account 10/24/2012 Trail Signage Repairs 411-48309-44030 2,885.63 Inv 899 Total 2,885.63 41051 Total: 2,885.63 1339-Vacker Inc.Total: 2,885.63 Total: 46,988.10 AP-Check Detail(11/21/2012- 1:29 PM) Page 12 Accounts Payable Check Detail User: ashley.bertrand Printed: 11/21/2012- 1:28PM Check Number Check Date Amount 0319-City of Roseville Line Item Account 41052 11/21/2012 Inv 0216702 Line Item Date Line Item Description Line Item Account 11/09/2012 Q3 2012 Water bill 601-49440-43820 406,264.12 Inv 0216702 Total 406,264.12 41052 Total: 406,264.12 0319-City of Roseville Total: 406,264.12 2129-Elfering&Associates Line Item Account 41053 11/21/2012 Inv 1727 Line Item Date Line Item Description Line Item Account 10/01/2012 2013 PMP Engineering Services 411-48511-43030 12,612.31 Inv 1727 Total 12,612.31 41053 Total: 12,612.31 2129-Elfering&Associates Total: 12,612.31 4446-Lanoux Electric Line Item Account 41054 11/21/2012 Inv 627 Line Item Date Line Item Description Line Item Account 10/18/2012 Lift Station Panel Replacement 602-49490-44040 22,500.00 Inv 627 Total 22,500.00 41054 Total: 22,500.00 4446-Lanoux Electric Total: 22,500.00 0222-League of Minnesota Cities Line Item Account 41055 11/21/2012 AP-Check Detail(I1/21/2012- 1:28 PM) Page 1 Check Number Check Date Amount Inv 168228 Line Item Date Line Item Description Line Item Account 09/01/2012 2012 Membership Dues 101-41300-44330 7,940.00 Inv 168228 Total 7,940.00 41055 Total: 7,940.00 0222-League of Minnesota Cities Total: 7,940.00 0243-Met Council Environ.Service-Waste Water Line Item Account 41056 11/21/2012 Inv 0001002458 Line Item Date Line Item Description Line Item Account 11/05/2012 Wastewater Service Charges December 2012 602-49490-43850 55,483.62 Inv 0001002458 Total 55,483.62 41056 Total: 55,483.62 0243-Met Council Environ.Service-Waste Water Total: 55,483.62 0811-Ramsey County Line Item Account 41057 11/21/2012 Inv SHRFL-001173 Line Item Date Line Item Description Line Item Account 11/01/2012 November 2012 RC Sheriff 101-42100-43120 81,304.61 Inv SHRFL-001173 Total 81,304.61 41057 Total: 81,304.61 0811-Ramsey County Total: 81,304.61 Total: 586,104.66 AP-Check Detail(11/21/2012- 1:28 PM) Page 2