The URL can be used to link to this page

Home My WebLink About5G, Motion to Approve Consent Agenda Item - Claims and Payroll� �RI`EN�HILLS Request for Council Action Prepared By: Ashley Berirand, Sue Iverson Council Meeting Date: July 30, 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 SuAporting Documents: 2012 Payroll #15 $ 84,830.35 :Payroll Total Payroll $ 84,830.35 Accounts Pavable Claims Throu�h 07-27-2012 Paid Claims (Check No 0 US Bank EFT) $ 2,739.34 Paid Claims (Check No. 40425 thru Check No: 40464) $ 45,054.18 Paid Claims ( Check No. 40465 thru Check No. 40502) $ 57,725.78 Paid Claims ( Check No. 40503 thru Check No. 40503) $ 450.00 Paid Claims ( Check No. 40504 thru Check No. 40540) $ 157,501.25 Paid Claims (Check No. 40541 thru Check No. 40547) $ 763,402.03 Total Claims $1,026, 872.58 CITY OF ARDEN HILLS PAYROLL # 15 CHECKS DATED: 07/20/12 Biweekly: 06/30/12 TO 07/13/12 <: ;;;��Vi:.E�QYE�:DEDU�TTQNS:::::: ::;:::iA1Vt'C:;:;:::; ::::CIT'1C:�ENE�`I�'::: ::::::::: FIT 7,824.83 :::::::>i::>::::>::>::::::::>:[::::::>::::>::::::><::::::>::> EFT SIT 3>214.59 :>>;:�:s>:!::>::::::>::::::>:::::«::'s;:::<:>::::::>::::>:: EFT FICA Oasdi 3,017.02 4,453.72 EFT FICA Medicaze 1,041.58 1,041.58 EFT TOTAL TAXES 15,098.02 5,495.30 �1 Premium Health Caze Reimb. Denendent Care Rei � 0.00 A/P Check* 0.00 A/P Check" ::::>::: A/P Check" :::<:;:: A/P Check* AL FLEXIBL� SPENll1NC: � 2�06:i.2S4 Health Saving 20516 AL HEALTH SAVINGS 205.16 � 2,140.10 Pension Fund-Union 614.40 339.34 EFT 31535 A/P Check" ::>:::::: A/P Check` ,654.69 :::::::;: A/P Check' :;:;':p:pp::::A/P Check* <:::::>: A/P Check* �0.00 A/P Check` >:>>> A/P Check" 0.00 PR Check #: 17274-17289 EFT Note: Federal and State Payroll Tax obligations aze 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. IUOE 49 Dues Union l:il1.UU ;: LTD/STD Insurance 0.00 :: PERA Life Insurance 32.00 :: Life/Addl/De Life 105.70 Mn Child Su ort 323.02 ;; TOTAL VOLUNTARY 590.72 Accounts Payable Check Detail User: ashley.bernand Printed: 07/27/2012 - 8:36AM ,�.��_ � � Check Number C;heck Date Amount 0602 - US BANK Line Item Account 0 07/09/2012 Inv Arvidson Line Item Date Line Item Descrintion Line Item Account 06/04/2012 Uniform Allowance - Arvidson 101-43100-42111 21.41 OS/22/2012 Uniform Allowance - Arvidson 101-43100-42111 39.94 06/08/2012 Publicwark Supplies 727-49700-42400 64.10 06/08/2012 Publicwork Supplies 727-49700-42400 32.13 Inv Arvidson Total Inv Freyberger Line Item Date OS/29/2012 Line ltem Description Uniform Allowance - Freyberger Inv Freyberger Total Inv Grant Line Item Date 06/01/2012 OS/14/2012 OS/18/2012 OS/18/2012 Line Item Descrintion Program Supplies Program Supplies Program Supplies - Movie Rental Program Supplies Inv Grant Total Inv Huhnacher Line Item Date 06/04/2012 Line Item DescripHon Credit Card Fraud Charge - Reported 6/19/2012 Inv Hutmacher Total Inv Iverson Line Item Date OS/15/2012 OS/30/2012 06/04/2012 06/OS/2012 06/06/2012 O6/07/2012 06/07/2012 06/08/2012 06/11/2012 Line Item Description MNGFOA Training GFOA Blue Books Summer Breakfast - Wellness Summer Breakfast - Wellness Suvey Monkey Software Pictures for Break Room Pictures for Break Room You Send It Charge GFOA Financial Policies Line Item Account 1 0 1-43 1 00-42 1 1 1 Line Item Account 101-45120-42170 101-45120-42170 101-45120-42170 101-45120-42170 Line Item Account 101-41910-44390 Line Item Account 101-41500-44325 101-41500-44350 725-49800-43706 725-49800-43706 728-49900-44330 725-49800-43706 725-49800-43706 101-41300-44390 101-41500-44350 157.58 59.97 59.97 8.98 64.21 1.29 92.34 166.82 260.71 260.71 15.00 477.00 95.36 14.86 199.00 256.72 175.67 14.99 33.75 AP-Check Detail (7/27/2012 - 8:3G AM) Page 1 Check Number Check Date Amount Inv Iverson Total 1,28235 Inv Mooney Line Item Date 06/06/2012 OS/17/2012 Inv Moouey Total Line Item Descrintion HP 120W AC Adapter Metal Detector Line Item Description Wellness Summer Breakfast Line Item Account 728-49900-45600 727-49700-42400 20.86 758.51 779.37 Inv Olson Line Item Date 06/OS/2012 Inv Oison Total 0 Total: 0602 - US BANK Total: Total: Line Item Account 725-49800-43706 32.54 32.54 2,73934 2,739.34 2,739.34 AP-Check Detail (7/27/2012 - 8:36 AM) Page 2 Accounts Payable Check Detail User: ashley.bertrand Printed: 07/27/2012 - 8:35AM ..,.� _ � � Check Number Check Date Amount 1323 - AICPA Line Item Account 40425 07/12/2012 Inv 10458030 Line Item Date Line Item Descrintion Line Item Account 06/03/2012 2012 Subscription Renewal 101-41500-44330 69.00 Inv 10458030 Total 69.00 40425 Total: 1323 - AICPA Total: 8092 - Aker poors Line Item Account 40426 07/12/2012 Inv 16520 Line Item Date Line Item Descrintion 06/27/2012 CH Counter poor Repair Inv 16520 Total 40426 Total: 8092 - Aker poors Total: ALPI - Allegra Print & Imaging Line Item Account 40427 07/12/2012 Inv 132000 Line Item Date Line Item Descrintion 06/22/2012 July 2012 Newsletter Inv 132000 Total 40427 Total: Line Item Account 101-41940-44010 69.00 69.00 327.25 327.25 327.25 327.25 Line Item Account 101-41100-43540 1,668.94 1,668.94 1,668.94 ALPI - Allegra Print & Imaging Total: 1,668.94 0131- Beisswenger's How-To Store Line Item Account 40428 07/12/2012 AP-Check Detail (7/27/2012 - 8:35 AM) Page 1 Check Number Check Date Amount Inv 175423 Line Item Date Line Item Description Line Item Account 06/22/2012 PW Supplies 101-45200-42210 11.19 Inv 175423 Total 11.19 Inv 177197 Line Item Date Line Item Descrintion Line Item Account 06/25/2012 PW Supplies 727-49700-42210 25.93 Inv 177197 Total 25.93 Inv 177727 Line Item Date Line Item Descrintion Line Item Account 06/20/2012 PW Repair 727-49700-42210 70.33 Inv 177727 Total 7033 Inv 178594 Line Item Date Line Item Description Line Item Account 06/28/2012 PW Supplies 727-49700-42210 3338 lnv 178594 Total 3338 40428 Total: 0131 - Beisswenger's How-To Store Total: 2112 - Bertrand, Ashley Line Item Account 0 07/12/2012 Inv 06222012 Line Item Date Line Item Descrintion 07/11/2012 �xpense Reimbursement May 2012 Inv 06222012 Total 0 Total: 140.83 140.83 Line Item Account 101-41500-42030 14.99 14.99 14.99 2112 - Bertrand, Ashley Total: 14.99 CANON - Canon Business Solutions, Inc Line Item Account 40429 07/12/2012 Inv 11969737 Line Item Date Line Item Descrintion Line Item Account 07/01/2012 July 2012 Contract Charge 101-41500-44150 879.37 07/O1/2012 July 2012 Contract Charge 228-41960-44150 155.18 Inv 119G9737 Total 1;034.55 AP-Check Detail (7/27/2012 - 8:35 AM) Page 2 Check Number Check Date Amount 40429 Total: CANON - Canon Business Solutions, Inc Total: 0651 - CDW Government, Inc. Line Item Account 40430 07/12/2012 Inv M208179 Line Item Date Line Item Description 06/22/2012 Misc Computer Supplie: Inv M208179 Total 40430 Total: 0651 - CDW Government, Inc. Total: CPFl - Central Pension Fund Line Item Account 101-00000-21772 40431 07/12/2012 Inv 06302012-CPF Line Item Date Line Item Descrintion 06/30/2012 June 2012 Contributions Inv 06302012-CPF Total 40431 Total: CPFl - Central Pension Fund Tota►: 8247 - Century Manufacturing Corporation Line Item Account 40432 07/12/2012 Inv 511034 Line Item Date Line Item Descrintion 07/06/2012 PW Supplies Inv 511034 Total 40432 TotaL• Line Item Account 408-48100-45700 Line Item Account 101-00000-21772 Line Item Account 602-49490-42210 1,034.55 1,034.55 22.60 22.60 22.60 22.60 1,228.80 1,228.80 1,228.80 1,228.80 998.00 998.00 998.00 8247 - Century Manufacturing Corporation TotaL• 998.00 0296 - City of Arden Hills Line Item Account 40433 07/12/2012 Inv 07102012 Line Item Date Line Item Description Line Item Account 07/10/2012 June 2012 Petty Cash 101-41300-42010 11.99 07/10/2012 June 2012 Petty Cash 101-41300-42010 40.19 AP-Check Detail (7/27/2012 - 8:35 AM) Page 3 Check Number Check Date Amount 07/10/2012 June 2012 Petty Cash 101-41500-43220 25.10 07/10/2012 June 2012 Petty Cash 101-41300-44330 20.00 Inv 07102012 Total 9�•Zg 40433 Total: 0296 - City of Arden Hills Total: 0319 - City of Roseville Line Item Account 40434 07/12/2012 Inv 0216198 Line Item Date Line Item Descrintion 06/29/2012 July 2012 IT Services Inv 0216198 Total Inv 0216235 Line Item Date Line Item Description 06/29/2012 July 2012 Phone Bill Inv 0216235 Total 40434 Total: 0319 - City of Roseville TotaL• HYMT - Dakota Supply Group, Inc. Line Item Account 40435 07/12/2012 Inv 7422497 Line Item Date Line Item Descrivtion 07/03/2012 2012 Water Meter Replacement Inv 7422497 Total 40435 Total: HYMT - Dakota Supply Group, Inc. Total: 0170 - Etectro Watchman, Inc. Line Item Account 40436 07/12/2012 Inv 181734 Line Item Date Line Item Description 07/OS/2012 Lift Station Battery Replacement Inv 181�34 Total Line Item Account 728-49900-43081 Line Item Account 728-49900-43210 Line Item Account 601-48517-45600 Line Item Account 602-49490-44010 97.28 97.28 2,294.16 2,294.16 472.50 472.50 2,766.66 2,766.66 3,096.17 3,096.17 3,096.17 3,096.17 31.87 31.87 AP-Check Detail (7/27/2012 - 8;35 AM) Page 4 Check Number Check Date Amount 40436 Total: 31.87 0170 - Electro Watchman, Inc. Total: 31.87 0375 - First Student, Inc. Line Item Account 40437 07/12/2012 Inv 99223372 Line Item Date Line Item Descrintion 06/25/2012 PTRC Park Tour Inv 99223372 Total 40437 Total: 0375 - First Student, Inc. Total: 5025 - Grant, Sara Line Item Account 0 07/12/2012 Inv 07022012 Line Item Date Line Item Descrintion 07/02/2012 June 2012 Expense Reimbursement 07/02/2012 June 2012 Expense Reimbursement Inv 07022012 Total 0 Total: 5025 - Grant, Sara Total: HEPC - Iiewlett Packard Company Line Item Account 40438 07/12/2012 Inv 32016248-001 Line Item Date Line Item Description 06/21/2012 Finance Supplies Inv 32016248-001 Total 40438 Total: Line Item Account 101-45200-44901 Line Item Account 101-41100-43310 101-45120-42170 Line Item Account 101-41500-42010 176.75 176.75 176.75 176.75 114.89 44.75 159.64 159.64 159.64 149.63 149.63 149.63 HEPC - Hewlett Packard Company TotaL• 149.63 HOLDB - Holden, Brenda Line Item Account 40439 07/12/2012 Inv 06252012 Line Item Date Line Item Descrintion Line Item Account 06/25/2012 Expense Reimbursement June 2012 101-41100-44325 5.00 AP-Check Detail (7/27/2012 - 8:35 AM) Page 5 Check Number Check Date Amount Inv 06252012 Total 5.00 40439 TotaL• HOLDB - Holden, Brenda TotaL• 1111 - Holmes, Fran Line Item Account 40440 07/12/2012 Inv 06252012-FH Line Item Date Line Item Description 06/25/2012 Expense Reimbursement June 2012 Inv 06252012-FH Total 40440 Total: 1111 - Holmes, Fran Total: 3117 - Hutmacher, Jill Line Item Account 0 07/12/2012 Inv 071012 Line Item Date Line Item Descrintion 07/10/2012 April-June 2012 Expense Reimbwsement 07/10/2012 April-June 2012 Expense Reimbursement Inv 071012 Total 0 Total: 3117 - Hutmacher, Jill Total: 0447 - I.U.O.E Local 49 Benefit Fund-Insurance Line Item Account 101-00000-21732 40441 07/12/2012 Inv 07.15.2012 Line Item Date Line Item Description 07/02/2012 August 2012 PW Benefits Inv 07.15.2012 Total Inv 07152012 Line Item Date Line Item Descriution 07/02/2012 August 2012 PW Benefits Inv 07152012 Total Line Item Account 101-41100-44325 Line Item Account 101-41910-43310 101-41910-44325 Line Item Account 101-00000-21732 Line Item Account 101-00000-21732 5.00 5.00 5.00 5.00 5.00 5.00 27.75 6.00 33.75 33.75 33.75 1,067.00 1,067.00 7,536.00 7,536.00 40441 Total: 8,603.00 AP-Check Detail (7/27/2012 - 8:35 AM) Page 6 Check Number Check Date Amount 0447 - I.U.O.E Loca149 Benefft Fund-Insurance Total: 1DAI - Ideal Advertising, Inc Line Item Account 40442 07/12/2012 Inv 34684 Line Item Date Line Item Description 06/27/2012 Tennis T-shirts Inv 34G84 Total 40442 TotaL• IDAI - Ideal Advertising, Inc Total: 0916 - Lakes Country Service Coop Line Item Account 40443 07/12/2012 Inv C1073-HA7-82012 Line Item Date Line Item Description 06/27/2012 August 2012 Health Insurance Inv C1073-HA7-82012 Total Inv C1073-HA9-82012 Line Item Date Line Item Descrintion 06/27/2012 August 2012 Health Insurance Inv C1073-HA9-82012 Total Inv C1073-WOO-82012 Line Item Date Line Item Descrintion 06/27/2012 August 2012 Health Insurance Inv C1073-WOO-82012 Total 40443 Total: 0916 - Lakes Country Service Coop Total: 0214 - LTG Power Equipment Line Item Account 40444 07/12/2012 Inv 156101 Line Item Date Line Ifem Descrintion 06/20/2012 PW Supplies Inv 156101 Total Line Item Account 101-45120-42172 Line Item Account 101-00000-21730 Line Item Account 101-00000-21730 Line Item Account 101-00000-21730 Line Item Account 101-45200-42210 8,603.00 132.00 132.00 132.00 132.00 881.50 881.50 6,576.00 6,576.00 945.00 945.00 8,402.50 8,402.50 73.47 73,47 AP-Check Detail (7/27/2012 - 835 AM) Page 7 Check Number Check Date Amount Inv 156194 Line Item Date Line Item Description Line Item Account 06/22/2012 PW Supplies 101-45200-42210 99.39 Inv 156194 Total 99.39 40444 Total: 0214 - LTG Power Equipment Total: 0242 - Met Council Environ. Service-SAC Line Item Account 40445 07/12/2012 Inv 07052012 Line Item Date Line Item Descriution 07/OS/2012 SAC Charges June 2012 Inv 07052012 Total 40445 Total: 0242 - Met Council Environ. Service-SAC Total: 0556 - Minnesota Clty/County Mgmt. Assoc. Line Item Account 40446 07/12/2012 Inv 05012012 Line Item Date Line Item Description OS/01/2012 2012 Membership Dues Inv 05012012 Total 40446 Total: 0556 - Mlnnesota City/County Mgmt. Assoc. Total: 0261- Minnesota GFOA Line Item Account 40447 07/12/2012 Inv 00059 Line Item Date Line Item Descrintion 07/11/2012 2012 Annual Conference Registration-Iverson Inv 00059 Total Line Item Account 602-49490-43851 Line Item Account 101-41300-44330 Line Item Account 101-41500-44325 172.86 172.86 4,682.70 4,682.70 4,682.70 4,682.70 135.71 135.71 135.71 135.71 225.00 225.00 Inv 00060 Line Item Date Line Item Descrintion Line Item Account 07/11/2012 2012 Annual Conference Registration-Bertrand 101-41500-44325 225.00 Inv 00060 Total 225.00 AP-Check Detail (7/27/2012 - 8:35 AM) Page 8 Check Number Check Date Amount 40447 TotaL• 0261- Minnesota GFOA Total: MNLI - Minnesota Native Landscapes, Inc Line Item Account 40448 07/12/2012 Inv 8053 Line Item Date Line Item Descrintion 07/OS/2012 Herbicide Application City Hall July 2012 Inv 8053 Total 40448 Total: MNLI - Minnesota Native Landscapes, Inc TotaL• MREJ - Minnesota Real Estate Journal Line Item Account 40449 07/12/2012 Inv 07022012 Line Item Date Line Item Description 07/02/2012 2012 Subscription Renewal Inv 07022012 Total 40449 Total: MREJ - Minnesota Real Estate Journal TotaL• 0147 - Moundsview Public Schools Line Item Account 40450 07/12/2012 Inv 4661 Line Item Date Line Item Descrintion 07/02/2012 April-May 2012 School Rental Fees Inv 4661 Total Inv 4662 Line Item Date Line Item DescriUtion 07/02/2012 June 2012 School Rental Fees Inv 4662 Total 40450 Total: Line Item Accotmt 101-41940-44010 Line Item Account 101-41910-44330 I.ine Item Account 101-45120-44125 Line Item Account 101-45120-44125 450.00 450.00 215.00 215.00 215.00 215.00 85.00 85.00 85.00 85.00 69.75 69.75 48.83 48.83 118.58 0147 - Moundsview Public Schools Total: 118.58 AP-Check Detail (7/27/2012 - 8:35 AM) Page 9 Check Number Check Date Amount 8091 - Munsterman, Brian Line Item Account 40451 07/12/2012 Inv 733 Line Item Date Line Item Description OS/31/2012 Escrow Refund PC11-019 Inv 733 Total 40451 Total: 8091 - Munsterman, Brian Total: 6252 - Office Depot Llne Item Account 40452 07/12/2012 Inv 1478355901 Line Item Date Line Item Description 06/18/2012 CAFR Books Inv 1478355901 Total Inv 1480960540 Line Item Date Line Item Description 06/28/2012 Office Supplies Inv 1480960540 Total Inv 1480960542 Line Item Date Line Item Description 06/28/2012 PAFR Copies 06/28/2012 PAFR Copies 06/28/2012 PAFR Copies 06/28/2012 PAFR Copies 06/28/2012 PAFR Copies Inv 1480960542 Total 40452 Total: 6252 - Office Depot Total: 7025 - On Site Sanitation Line Item Account 40453 07/12/2012 Inv A-460308 Line Item Date Line Item Descriution 06/23/2012 Floral Park July 2012 Restroom Rental Inv A-460308 Total Line Item Account 101-00000-22000 Line Item Account 101-41500-42030 Line Item Account 101-41500-42010 Line Item Account 101-41500-42030 601-49440-42030 602-49490-42030 603-49520-42030 604-49550-42030 Line Item Account 101-45120-43840 2,000.00 2,000.00 2,000.00 2,000.00 23.73 23.73 126.50 126.50 1.63 1.63 1.63 I .63 1.62 8.14 15837 15837 59.85 59.85 AP-Check Detail (7/27/2012 - 8:35 AM) Page 10 Check Number Checic Date Amount Inv A-460309 Line Item Date Line Item Descrintion Line Item Account 06/23/2012 Hazelnut Park July 2012 Restroom Rental 101-45120-43840 59.85 Inv A-460309 Total 59.85 Inv A-460310 Line Item Date Line Item Description Line Item Account 06/23/2012 Perry Park July 2012 Restroom Rental 101-45120-43840 i53.90 Inv A-460310 Total 153.90 Inv A-460311 Line Item Date Line Item Descrintion Line Item Account 06/23/2012 Royal Hills Park July 2012 Restroom Rental 101-45120-43840 59.85 Inv A-460311 Total 59.85 Inv A-460519 Line Item Date Line Item Description Line Item Account 06/23/2012 Cummings Park July 2012 Restroom Rental 101-45120-43840 59.85 Inv A-460519 Total 59.85 Inv A-461028 Line Item Date Line Item Description Line Item Account 06/23/2012 Ingerson Park July 2012 Restroom Rental 101-45200-43840 59.85 Inv A-461028 Total 59.85 40453 Total: 7025 - On Site Sanitation Total: 0292 - Oxygen Service Company, Inc. Line Item Account 40454 07/12/2012 Inv 03198478 Line ltem Date Line Item Description 06/30/2012 PW Supplies Inv 03198478 Total 40454 Total: 453.15 453.15 Line Item Account 727-49700-42210 7.70 7.70 7.70 0292 - Oxygen Service Company, Inc. Total: �'�� 1110 - Pitney Bowes Line Item Account 40455 07/12/2012 AP-Check Detail (7/27/2012 - 8:35 AM) Page I1 Check Number Check Date Amount Inv 06222012 I ine Item Date Line Item Description Line Item Account 06/22/2012 July 2012 Postage 101-41100-43220 484.22 06/22/2012 July 2012 Postage 101-41500-43220 19.99 Inv 06222012 Total 504.21 40455 Total: 1110 - Pitney Bowes Total: 7526 - Risch, Therace Line Item Account 40456 07/12/2012 Inv 723 Line Item Date Line Item Descrintion OS/31/2012 Escrow Reimbursement Permit#2010-01457 Inv 723 Total 40456 Total: 7526 - Risch, Therace Total: 1054 - SHI International Corp. Line Item Account 40457 07/12/2012 Inv B00655882 Line Item Date Line Item Description 06/11/2012 Bernand Monitor Inv B00655882 Total 40457 TotaL• 1054 - SHI International Corp. Total: LACI - Sports Unlimited Line Item Account 40458 07/12/2012 Inv 06292012 Line Item Date Line Item Description 06/29/2012 2012 Lacrosse Camp Inv 06292012 Total 40458 Total: Line Item Account 101-00000-22000 Line Item Account 728-49900-42010 Line Item Account 101-45120-43070 504.21 504.21 500.00 500.00 500.00 500.00 193.08 193.08 193.08 193.08 483.00 483.00 483.00 LACI - Sports Unlimited Total: 483.00 AP-Check Detail (7/27/2012 - 8:35 AM) Page 12 Check Number Check Date Amount 1001 - Sprint/Nextel IntCrd Line Item Account 40459 07/12/2012 Inv 525888811-055 Line Item Date Line Item Descrintion 06/18/2012 June 2012 Council Wireless Cards Inv 525888811-055 Total 40459 Total: 1001- Sprint/Nextel IntCrd TotaL• 1565 - St. Croix Recreation LIne Item Account 40460 07/12/2012 Inv 17360 Line Item Date Line Item Descrintion 06/25/2012 Valentine Park Improvement Project-Picnic Tables Inv 17360 Total 40460 Total: 1565 - St. Croix Recreation Total: J 0327 - Staples Line Item Account 40461 07/12/2012 Inv 3176988610 Line Item Date Line Item Description 06/23/2012 Office Supplies Inv 3176988610 Total Inv 3176988611 Line Item Date Line Item Descriprion 06/23/2012 Office Supplies Inv 3176988611 Total 40461 Total: Line Item Account 101-41100-43210 Line Item Account 227-48315-45300 Line Item Account 101-41500-42010 Line Item Account 101-41500-42010 104.00 104.00 104.00 104.00 3,632.90 3,632.90 3,632.90 3,632.90 261.10 261.10 59.95 59.95 321.05 0327 - Staples TotaL• 321.05 0576 - TimeSaver Off Site Secretarial Line Item Account 40463 07/12/2012 Inv M19117 Line Item Date Line Item Descrintion Line Item Account AP-Check Detail (7/27/2012 - 8:35 AM) Page 13 Check Number Check Date Amount 06/14/2012 CC Mtg 5.29 Planning Commission Mtg 6.6 101-41100-43110 241.58 06/14/2012 CC Mtg 5.29 Planning Commission Mtg 6.6 101-41910-43110 139.65 Inv M19117 Total 381.23 40463 Total: 0576 - TimeSaver Off Site Secretarial Total: 0925 - T-Mobile Line Item Account 40462 07/12/2012 Inv 841463567-0712 Line Item Date Line Item Descrintion 07/11/2012 June 2012 Cell Phone Charges 07/11/2012 June 2012 Cell Phone Charges Inv 841463567-0712 Total 40462 Total: 0925 - T-Mobile Total: 7592 - Werner, Ed Line Item Account 40464 07/12/2012 Inv 06252012 Line Item Date Line Item Description 06/25/2012 June 2012 Expense Reimbursement 06/25/2012 June 2012 Expense Reimbursement Inv 06252012 Total 40464 Total: 7592 - Werner, Ed Total: Total: Line Item Account 728-49900-43210 728-49900-43210 Line Item Account 101-41100-44325 101-41100-43310 381.23 381.23 1,087.71 -110.70 977.01 977.01 977.01 151.25 163.17 314.42 314.42 314.42 45,054.18 AP-Check Detail (7/27/2012 - 8:35 AM) Page 14 Accounts Payable Check Detail User: ashley.bertrand Printed: 07/27/2012 - 8:34AM ..�., a � a,�....�..,�„� � � Check Number Check Date Amount 2597 - AARP Line Item Account 40465 07/20/2012 Inv 600 Line Item Date Line Item Descriution Line Item Account 07/10/2012 July 2012 AARP Class 101-45120-42170 378.00 Inv 600 Total 378.00 40465 Total: 2597 - AARP Total: ALPI - Allegra Print & Imaging Line Item Account 40466 07/20/2012 Inv 132273 Line Item Date Line Item Descrintion 07/16/2012 Prints for CC Mtg Trail Signage Project Inv 132273 Total 40466 Total: ALPI - Allegra Print & Imaging Total: ARAM - Aramark Uniform Service Line Item Account 40467 07/20/2012 Inv 629-7530317 Line Item Date Line Item Descrintion 07/03/2012 July 2012 Mat Service Inv 629-7530317 Total 40467 Total: 378.00 378.00 40.61 40.61 40.61 40.61 263.01 263.01 263.01 ARAM - Aramark Uniform Service Total: 263.01 BOND - Bond Trust Services Corp Line Item Account 40468 07/20/2012 AP-Check Detail (7/27/2012 - 8:34 AM) Page 1 Line Item Account 101-41300-42030 Line Item Account 101-41940-43840 Check Number Check Date Amount Inv 16815 Line Item Date Line Item Description Line Item Account 06/12/2012 Go Tax Increment Bonds, Interest 325-47010-46110 13,647.50 Inv 16815 Total 13,647.50 40468 Total: BOND - Bond TYust Services Corp Total: CIIRM - Chresand, Margaret Line Item Account 40469 07/20/2012 Inv 07092012 Line Item Date Line Item Description 07/09/2012 PreschoolSoccer Refund Inv 07092012 Total 40469 Total: CHRM - Chresand, Margaret Total: 0317 - City of Roseville-Parks & Recreation Line Item Account 40470 07/20/2012 Inv 061512-2 Line Item Date Line Item Description 07/09/2012 Field Trip Reimbursement Inv 061512-2 Total 40470 Total: 0317 - City of Roseville-Parks & Recreation TotaL• 1032 - Commercial Asphall Co. Line Item Account 40471 07/20/2012 Inv NP12588 Line Item Date Line Item Descrintion 07/I S/2012 Street Maintenance Material Inv NP12588 Total Line Item Account 101-45120-34782 Line Item Account 101-45120-42170 Line Item Account 101-43100-42245 13,647.50 13,647.50 36.00 36.00 36.00 36.00 67.32 67.32 6732 67.32 1,387.64 1,387.64 Inv NP12657 Line Item Date Line Item Descrintion Line Item Account 07/15/2012 Street Maintenance Material 101-43100-42245 2,469.87 Inv NP12657 Total 2,469.87 AP-Check Detail (7/27/2012 - 8:34 AM) Page 2 Check Number Check Date Amount Inv NP13731 Line Item Date Line Item Descrintion 07/15/2012 Street Maintenance Material Inv NP13731 Total Iuv NP1393Q Line Item Date Line Item Descrintion 07/15/2012 Street Maintenance Material Inv NP13930 Total 40471 TotaL• 1032 - Commercial Asphalt Co. Total: 0453 - Continental Research Corp. Line Item Account 40472 07/20/2012 Inv 372221-CRG1 Line Item Date Line Item Descrintion 07/13/2012 PW Supplies Inv 372221-CRC-1 Total Inv 372396-CRC-1 Line Item Date Line Item Descrivtion 07/13/2012 PW Supplies Inv 372396-CRC-I Total Line Item Account 101-43100-42245 Line Item Accoimt 101-43100-42245 Line Item Account 727-49700-42245 Line Item Account 727-49700-42245 36432 364.32 125.01 125.01 4,346.84 4,346.84 873.07 873.07 199.72 199.72 40472 Total: 1,072,79 0453 - Continental Research Corp. Total: 1,072.79 HYMT - Dakota Supply Group, Inc. Line Item Account 40473 07/20/2012 Inv 7395224 Line Item Date Line Item Descrintion Line Item Account 07/09/2012 2012 Water Meter Replacement 601-48517-45600 298.18 Inv 7395224 Total 298.18 Inv 7430602 Line Item Date Line Item Descrintion Line Item Account 07/11/2012 2012 Water Meter Replacement 601-48517-45600 1,179.90 Inv 7430602 Total 1,179.90 AP-Check Detail (7/27/2012 - 8:34 AM) Page 3 Check Number Check Date Amount Inv 7431491 Line Item Date Line Item Description Line Item Account 07/11/2012 2012 Water Meter Replacement 601-48517-45600 1,769.85 Inv 7431491 Total 1,769.85 40473 Total: HYMT - Dakota Supply Group, Inc. Total: EATI - Emergency Automotive Tech, Inc Line Item Account 40474 07/20/2012 Inv AW051812-10 Line Item Date Line Item Descrintion OS/18/2012 PW Supplies Inv AW051812-10 Total 40474 Total: EATI - Emergency Automotive Tech, Inc TotaL• 561ESCH - ESCH Construction Supply, Inc Line Item Account 40475 07/20/2012 Inv 470505 Line Item Date Line Item Descrintion OS/23/2012 PW Supplies Inv 470505 Total 40475 TotaL• 561ESCH - ESCA Construction Supply, Inc TotaL• 1195 - Eureka Recycling Line Item Account 40476 07/20/2012 Inv 10455 Line Item Date Line Item Description 07/12/2012 June 2012 Recycling 07/12/2012 June 2012 Recycling Inv 10455 Total 40476 Total: Line Item Accoimt 727-49700-42150 Line Item Account 727-49700-42150 Line Item Account 603-49520-43860 603-49520-36276 3,247.93 3,247.93 61.92 61.92 61.92 61.92 351.62 351.62 351.62 351.62 7,820.80 -1,407.46 6,413.34 6,413.34 1195 - Eureka Recycling Total: 6,413.34 AP-Check Detail (7/27/2012 - 8:34 AM) Page 4 Check Number Check Date Amount 6694 - Gopher Sport Line Item Account 40477 07/20/2012 Inv 8508834 Line Item Date Line Item Descrintion 07/17/2012 Rec Supplies-Dodgeballs Inv 8508834 Total 40477 Total: 6694 - Gopher Sport TotaL• GFOA - Government Finance Officers Association Line Item Account 40478 07/20/2012 Inv 0188635S TM Line Item Date Line Item Descriution 06/21/2012 Treasury Management Newsletter 9.12-8.13 Inv 01886355 TM Total 40478 Total: GFOA - Government Finance Officers Association Total: 0192 - Grainger, Inc Line Item Account 40479 07/20/2012 lnv 9874555601 Line Item Date Line Item Descrintion 07/12/2012 PW Supplies Inv 9874555601 Total 40479 Total: 0192 - Grainger, Inc Total: 4999 - Hirshfield's Paint Mfg., Inc. Line Item Account 40480 07/20/2012 Inv 094797 Line Item Date Line Item Description 07/06/2012 Paint For Athletic rields Inv 094797 Total Line Item Account 101-45120-42170 Line Item Account 101-41500-44330 Line Item Account 727-49700-42210 Line Item Account 101-45200-42230 426.53 426.53 426.53 426.53 55.00 55.00 55.00 55.00 210.59 210.59 210.59 210.59 1,349.30 1,349.30 40480 Total: 1,34930 AP-Check Detail (7/27/2012 - 8:34 AM) Page 5 Check Number Check Date Amount 4999 - Hirshfield's Paint Mfg., Inc. TotaL• 1,349.30 0382 - ICMA Retirement Trust -106944 Line Item Account 101-00000-21740 404H1 07/20/2012 Inv 07182012-PK Line Item Date Line Item Description Line Item Account 07/18/2012 KlaersICMAPR#15 101-00000-21740 587.20 Inv 07182012-PK Total 587.20 40481 TotaL• 0382 - ICMA Retirement Trust -106944 Total: 0387 - ICMA Retirement Trust- #302482 Line Item Account 101-00000-21742 40482 07/20/2012 Inv. 07182012-CS Line Item Date Line Item Descrintion 07/18/2012 IMCAPR#15 Contributions Inv 07182012-CS Total 40482 Total: 0387 - ICMA Retirement'IYust- #302482 Total: 1197 - McFarland Hanson Inc. Line Item Account 40483 07/20/2012 Inv 229320 Line Item Date Line Item Descrintion 06/07/2012 City Hall Supplies Inv 229320 Total Inv 229375 L,ine Item Date Line Item Description 06/19/2012 City Hall Supplies Inv 229375 Total 40483 Total: Line Item Account 101-00000-21742 Line Item Account 101-41940-42010 Line Item Account 101-41940-42010 587.20 587.20 1,868.25 1,868.25 1,868.25 1,868.25 154.39 15439 227.26 227.26 381.65 1197 - McFarland Hanson Inc. Total: 381.65 MNCS - Minnesota Child Support Payment Center Line Item Account 101-00000-21780 40484 07/20/2012 AP-Check Detail (7/27/2012 - 8:34 AM) Page 6 Check Number Check Date Amount Inv 07192012-MNCS Line Item Date I,ine Item Description Line Item Account 07/19/2012 Frid PR#IS Deduction 101-00000-21780 323.02 Inv 07192012-MNCS Total 323.02 40484 Total: MNCS - Minnesota Child Support Payment Center Total: 0257 - Minnesota Dept. of Health Line Item Account 40485 07/20/2012 Inv 06302012 Line Item Date Line Item Description 06/30/2012 Q2 2012 Water Connection Service Fee Inv 06302012 Total 40485 Total: 0257 - Minnesota Dept. of Health Total: 0685 - NATIONAL LEAGUE OF CITIES Line Item Account 40486 07/20/2012 Inv 83702 Line Item Date Line Item Description 06/04/2012 Membership Renewal 2012-2013 Inv 83702 Total 40486 TotaL• 0685 - NATIONAL LEAGUE OF CITIES Total: ORCR - Orchard, Robin Line Item Account 40487 07/20/2012 Inv 07132012 Line Item Date Line Item Descrintion 07/13/2012 Picnic Pavillion Rental Refund 07/13/2012 Picnic Pavillion Rental Refund Inv 07132012 Total 40487 TotaL• Line Item Account 601-49440-43821 Line Item Account 101-41500-44330 Line Item Account 101-45200-34300 101-00000-20100 323.02 323.02 4,097.00 4,097.00 4,097.00 4,097.00 1,117.00 1,117.00 1,117.00 1,117.00 50.00 3.56 53.56 53.56 ORCR - Orchard, Robin Total: 53.56 AP-Check Detail (7/27/2012 - 8:34 AM) Page 7 Check Number Check Date Amount 0316 - Oriental TYading Co., Inc. Line Item Account 40488 07/20/2012 Inv 652017072-01 Line Item Date Line Item Description Line Item Account 07/12/2012 Penny Carnival Supplies 101-45120-42175 509.00 Inv 652017072-01 Total 509.00 40488 Totai: 0316 - Oriental'lYading Co., Inc. Total: 8032 - Pace Analyttcal Field Svc Line Item Account 40489 07/20/2012 Inv 121207005 Line Item Date Line Item Description 07/09/2012 June 2012 Water Testing Fees Inv 121207005 Total 40489 Total: 8032 - Pace Analytical Field Svc Total: 3071 - Peoples Etectric Company Line Item Account 40490 07/20/2012 Inv 41658.00 Line Item Date Line Item Descriution 07/13/2012 Alarm Repair in Lift Station #6 Inv 41658.00 Total 40490 Total: 3071 - Peoples Electric Company TotaL• PAILR - Phlllips, Rick & Melissa Line Item Account 40491 07/20/2012 Inv 07162012 Line Item Date Line Item Description 07/16/2012 GE Permit 2011-01581 Escrow Refund Inv 07162012 Total Line Item Account 601-49440-43821 Line Item Account 602-49490-44010 Line Item Account 101-00000-22000 509.00 509.00 664.50 664.50 664.50 6G4.50 342.20 342.20 342.20 342.20 3,000.00 3,000.00 40491 Total: 3,000.00 AP-Check Detail (7/27/2012 - 8:34 AM) Page 8 Check Number Check Date Amount PHILR - Philli s Rick & Melissa Total• 3,000.00 P� • 1074 - Preeision Landscape & TYee Line Item Account 40492 07/20/2012 Inv 21672 Line Item Date Line Item Descrintion 07/12/2012 Wood Chips Inv 21672 Total 40492 Total: 1074 - Precision Landscape & Tree Total: 0811 - Ramsey County Line Item Account 40493 07/20/2012 Inv P[1BW-012019 Line Item Date Line Item Descrintion 07/10/2012 June 2012 Motor Fuels Inv PUBW-012019 Total 40493 Total: 0811 - Ramsey County Total: 1193 - SelectAccount Line Item Account 40494 07/20/2012 Inv 891872 Line Item Date Line Item Descrintion 07/04/2012 July 2012 Participant Fee Inv 891872 Total 40494 Total: 1193 - SelectAccount TotaL• SFBB - Spencer Fane Britt & Browne LLP Line Item Account 40495 07/20/2012 Inv 433320 Line Item Date Line Item Descrintion 07/09/2012 Audit Doc Research on TCAAP Inv 433320 Total Line Item Account 101-45200-42245 Line Item Account 727-49700-42120 Line Item Account 101-41300-44371 Line Item Account 101-41600-43041 1,175.63 1,175.63 1,175.63 1,175.63 4,952.55 4,952.55 4,952.55 4,952.55 25.62 25.62 25.62 25.62 167.50 167.50 AP-Check Detail (7/27/2012 - 8:34 AM) Page 9 Check Number Check Date Amount 40495 Total: 167.50 SFBB - Spencer Fane Britt & Browne LLP Total: LACI - Sports Unlimited Line Item Account 40496 07/20/2012 Inv 07132012 Line Item Date Line Item Description 07/13/2012 Sand Volleyball Camp Inv 07132012 Total 40496 TotaL• LACI - Sports Unlimited TotaL• 5180 - Tessman Seed Co. Line Item Account 40497 07/20/2012 Inv S162859-IN Line Item Date Line Item Descrintion 07/12/2012 Park Supplies Inv S 162859-IN Total 40497 Total: 5180 - Tessman Seed Co. Total: 1175 - TNT Cleaning and Consulting, INC Line Item Account 40498 07/20/2012 Inv 261684 Line Item Date Line Item Description 07/10/2012 July 2012 Cleaning Inv 261684 Total 40498 TotaL• Line Item Account 101-45120-43070 Line Item Account 101-45200-42245 Line Item Account 101-41940-43840 167.50 138.00 138.00 138.00 138.00 1,581.72 1,581.72 1,581.72 1,581.72 903.09 903.09 903.09 1175 - TNT Cleaning and Consulting, INC Total: 903.09 TOII - Tokle Inspections, Inc Line Item Account 40499 07/20/2012 Inv 07012012 Line Item Date Line Item Descrintion Line Item Account 07/O1/2012 June 2012 Inspections 101-42400-43102 3,208.81 AP-Check Detail (7/27/2012 - 8:34 AM) Page 10 Check Number Check Date Amount Inv 07012012 Total 3,208.81 40499 TotaL• TOII - Tokle Inspections, Inc TotaL• 6084 - Tiirfwerks Line Item Account 40500 07/20/2012 Inv MI02263 Line Item Date Line Item Descrintion 07/11/2012 Parks Repair Parts Inv MI02263 Total 40500 Total: 6084 - Turfwerks TotaL• 0789 - United Rentals Northwest, Inc. Line Item Account 40501 07/20/2012 Inv 103769226-001 Line Item Date Line Item Descrintion 07/OS/2012 PW Rental Inv 103769226-001 Total 40501 Total: 0789 - United Rentals Northwest, Inc. Total: 1339 - Vacker Inc. Line Item Account 40502 07/20/2012 Inv 867 Line Item Date Line Item Descrintion 07/09/2012 Valentine Park Paneling Inv 867 Total 40502 Total: 1339 - Vacker Inc. Total: Line Item Account 101-45200-42210 Line Item Account 727-49700-44150 Line Item Account 227-48315-45300 3,208.81 3,208.81 71.24 71.24 71.24 71.24 397.56 397.56 397.56 397.56 192.38 19238 19238 192.38 Total: 57,725.78 AP-Check Detail (7/27/2012 - 834 AM) Page 11 Accounts Payable Check Detail User: ashley.bertrand Printed: 07/27/2012 - 8:33AM .�� Check Number Check Date Amount BOND - Bond TYust Services Corp Line Item Account 40503 07/24/2012 Inv 7567 Line Item Date Line Item Description 06/12/2012 Agent Services Fee 2012 Inv 7567 Total 40503 Total: BOND - Bond Trust Services Corp Total: Total: Line Item Account 325-47010-46200 450.00 450.00 450.00 450.00 450.00 AP-Check Detail (7/27/2012 - 8:33 AM) Page 1 Accounts Payable Check Detail User: ashley.bertrand Printed: 07/27/2012 - 10:12AM ..,., _ � � � Check Number Check Date Amount 8324 - Alexander Hamilton Institute Line Item Account 40504 07/27/2012 Inv REN1R04 Line Item Date Line Item Descrintion Line Item Account 07/06/2012 2012 Payroll Legal Alert Renewal 101-41500-44330 147.00 Inv REN 1 R04 Total 147.00 40504 Total: 8324 - Alexander Hamilton Institute TotaL• 1125 - Bolton & Menk, Inc. Line Item Account 40505 07/27/2012 Inv 0149019 Line Item Date Line Item Descrintion 07/11/2012 B2 District lmprovement July 2012 Inv 0149019 Total 40505 TotaL• 1125 - Bolton & Menk, Inc. TotaL• CANO - Canon Business Solutions Line Item Account 40506 07/27/2012 Inv 143048891 Line Item Date Line Item Descrintion 07/13/2012 Office Supplies Inv 143048891 Total 40506 'fotal: 147.00 147.00 Line Item Account 411-48311-43030 Line Item Account 101-41500-42010 7,476.36 7,47636 7,476.36 7,47636 291.24 291.24 291.24 CANO - Canon Bustness Solutions TotaL• 291.24 0706 - CeMitied Laboratories Line Item Account 40507 07/27/2012 AP-Check Detail (7/27/2012 - 10:12 AM) Page 1 Check Number Check Date Amount Inv 794323 Line Item Date Line Item Descrintion Line Item Account 07/19/2012 PW Supplies 727-49700-42150 114.14 Inv 794323 Total 114.14 Inv 795022 Line Item Date 07/19/2012 Inv 795022 Total Line Item Description PW Supplies Line [tem Account 727-49700-42150 209.61 209.61 40507 Total: 0706 - Certified Laboratories TotaL• 0319 - City of Roseville Line Item Account 40508 07/27/2012 Inv 0216262 Line Item Date Line Item Descrintion 07/12/2012 Domain Name Registration Inv 0216262 Total 40508 Total: 0319 - City of Roseville Total: 1033 - Comcast Line Item Account 40509 07/27/2012 Inv 44271-072012 Line Item Date Line Item Descrintion 07/11/2012 July 2012 TV Services Inv 44271-072012 Total 40509 Total: Line Item Account 228-41960-45701 Line Item Account 228-41960-44040 323.75 323.75 229,90 229.90 229.90 229.90 6.76 6.76 6.76 1033 - Comcast Total: 6.76 HYMT - Dakota Supply Group, Inc. Line Item Account 40510 07/27/2012 Inv 7398979 Line Item Date Line Item Descrintion Line Item Account 07/17/2012 2012 Water Meter Replacement 601-48517-45600 1,131.22 Inv 7398979 Total 1,131.22 AP-Check Detail (7/27/2012 - 10:12 AM) Page 2 Check Number Check Date Amount Inv 7437873 Line Item Date Line Item Descrintion 07/17/2012 2012 Water Meter Replacement Inv 7437873 Total Line Item Account 601-48517-45600 636.98 636.98 40510 Total: HYMT - Dakota Supply Group, Inc. TotaL• DEED - Dept of Employment & Econ Dev Line Item Acwunt 40511 07/27/2012 Inv 106-002 Line Item Date L,ine Item Descrintion 07/10/2012 Q2 2012 Unemployment Benefits Paid 07/10/2012 Q2 2012 Unemployment Bene£ts Paid 07/10/2012 Q2 2012 Unemployment Benefits Paid 07/10/2012 Q2 2012 Unemployment Benefits Paid 07/10/2012 Q2 2012 Unemployment Benefits Paid Inv 106-002 Total 40511 TotaL• DEED - Dept of Employment & Econ Dev Total: 1785 - EcoEnvelopes Line Item Account 40512 07/27/2012 Inv 1191 Line Item Date Line Item Descrintion 07/16/2012 UB Envelopes Inv 1191 Total Inv 1192 Line Item Date Line Item Descriution 07/16/2012 AH Envelopes Inv 1192 Total 40512 Total: Line Item Account 101-41300-41410 228-41960-41410 601-49440-41410 602-49490-41410 604-49550-41410 Line Item Account 101-41500-42010 Line Item Account 101-41500-42010 1,768.20 1,768.20 2,371.20 395.20 395.20 395.20 395.20 3,952.00 3,952.00 3,952.00 832.68 832.68 384.47 384.47 1,217.15 1785 - EcoEnvelopes Total: 1,217.15 0841 - Ehlers & Associates, Inc. Line Item Account 40513 07/27/2012 AP-Check Detail (7/27/2012 - 10:12 AM) Page 3 Check Number Check Date Amount Inv 344770 Line Item Date Line Item Description Line Item Account 07/10/2012 Annual TIF Reports 704-47307-44371 316.88 07/10/2012 Annual TIF Reports 705-47305-44371 316.87 Inv 344770 Total 633.75 40513 Total: 0841- Ehlers & Associates, Inc. TotaL• 2129 - Elfering & Associates Line Item Account 40514 07/27/2012 Inv 1666 Line Item Date Line Item Description 06/29/2012 2011 PMP Engineering Services 7une 2012 Inv 1666 Total Inv 1667 Line Item Date Line Item Descrintion 06/29/2012 PC 11-009 Fox Ridge Engineering Services June 2012 Inv 1667 Total Inv 1669 Line Item Date Line Item Descrintion 06/29/2012 Lift Stations 1& 12 Engineering Services June 2012 Inv 1669 Total Inv 1670 Line Item Date Line Item Description 06/29/2012 Close out of 2006 RCWD Permit Inv 1670 Total 40514 TotaL• Line Item Account 411-48510-43030 Line Item Account 101-00000-22000 Line Item Account 602-48402-43030 Line Item Account 604-49550-43030 633.75 633.75 357.50 357.50 195.00 195.00 7,095.00 7,095.00 1,237.50 1,237.50 8,885.00 2129 - Elfering & Associates TotaL• 8,885.00 EMSI - Embedded Systems, Inc Line Item Account 40515 07/27/2012 Inv 33019 Line Item Date Line Item Descrintion Line Item Account 07/19/2012 Troubleshoot & Repair Tornado Siren #2 101-42300-44010 100.00 Inv 33019 Total 100.00 AP-Check Detail (7/27/2012 - 10:12 AM) Page 4 Checic Number Check Date Amount 40515 Total: 100.00 EMSI - Embedded Systems, Inc Total: 7024 - Emergency Preparedness Resource Group, LLC Line Item Account 40516 07/27/2012 Inv 3912 Line Item Date Line Item Descrintion 06/12/2012 2012 �mergency Management Project Expenses Inv 3912 Total 40516 Total: 7024 - Emergency Preparedness Resource Group, LLC Total: 6129 - Fast Signs Line Item Account 40517 07/27/2012 Inv 204-33819 Line Item Date Line Item Descrintion 07/09/2012 City Hall Window Lettering Inv 204-33819 Total 40517 Total: 6129 - Fast Signs Total: 0339 - Ferguson Waterworks Line Item Account 40518 07/27/2012 Inv 501374553.001 Line Item Date Line Item Descrintion 07/02/2012 PW Supplies Inv S013�4553.001 Total 40518 Total: 0339 - Ferguson Waterworks Total: 0192 - Grainger, Inc Line Item Account 40519 07/27/2012 Inv 9880837746 Line Item Account 101-42300-43100 Line Item Account 101-41940-44010 Line Item Account 601-49440-42210 100.00 4,625.00 4,625.00 4,625.00 4,625.00 234.01 234.01 234.O1 234.01 101.53 101.53 101.53 101.53 Line Item Date Line Item Descriution Line Item Account 07/19/2012 PW Supplies 727-49700-42150 49.79 AP-Check Detail (7/27/2012 - 10:12 AM) Page 5 Check Number Check Date Amount Inv 9880837'746 Total 49.79 40519 Total: 0192 - Grainger, Inc Total: 5055 - Green Mill Line Item Account 40520 07/27/2012 Inv 552 � Line Item Date Line Item Description 07/16/2012 07.16.2012 CC Work Session Inv 552 Total 40520 Total: 5055 - Green Mill Total: 0320 - Health Partners Line Item Account 40521 07/27/2012 Inv 40832995 Line Item Date Line Item Descriotion 07/06/2012 August 2012 Dental Insurance Inv 40832995 Total 40521 TotaL• 0320 - Health Partners Total: 0381- ICMA Retirement Corporation Line Item Account 40522 07/27/2012 Inv 10942 Line Item bate Line Item Descrintion 07/06/2012 Q3 2012 Annual Plan Fee Inv 10y42 Total 40522 Total: Line Item Account 101-41100-44325 Line Item Account 101-00000-21738 Line Item Account 101-41300-41130 49.79 49.79 123.67 123.67 123.67 123.67 9G5.39 965.39 965.39 965.39 250.00 250.00 250.00 0381- ICMA Retirement Corporation Total: 250.00 7341 - Interstate Pavement Maintenance Line Item Account 40523 07/27/2012 Inv 06112012 Line Item Date Line Item Descriation Line Item Account AP-Check Detail (7/27/2012 - 10:12 AM) Page 6 Check Number Check Date Amount 06/11/2012 Valentine Park Improvements-Payment #1 604-48315-45900 64,072.82 06/11/2012 Valentine Park Improvements-Payment #I 602-48315-45900 6,159.80 Inv 06112012 Total 70,232.62 40523 Total: 7341 - Interstate Pavement Maintenance Total: 0495 - Lake Johanna Fire Department Inc. Line Item Account 40524 07/27/2012 Inv 404 Line Item Date Line Item Descrintion 07/10/2012 Technical Rescue Equipment Inv 404 Total 40524 Total: 0495 - Lake Johanna Fire Department Inc. TotaL• 8634 - Lee Sports Surfacing, LLC Line Item Account 40525 07/27/2012 Inv 1674 Line Item Date Line Item Description 06/18/2012 CIP Tennis Court Resurface Floral Park Inv 1674 Total 40525 TotaL 8634 - Lee Sports Surfacing, LLC TotaL• 6148 - M& H Supply Line Item Account 40526 07/27/2012 Inv 127� Line Item Date Line Item Descrintioii 07/24/2012 PW Supplies Inv 1277 Total 40526 Total: Line Item Account 412-48120-45800 Line Item Account 101-45200-44033 Line Item Account 727-49700-42210 70,232.62 70,232.62 672.50 672.50 672.50 672.50 10,450.00 10,450.00 10,450.00 10,450.00 940.50 940.50 940.50 6145 - M& H Supply Total: 940.50 5443 - Metro Products, Inc. Line Item Account AP-Check Detail (7/27/2012 - 10:12 AM) Page 7 Check Number Check Date Amount 40527 07/27/2012 Inv 86281 Line Item Date Line Item Description Line Item Account 07/18/2012 PW Supplies 727-49700-42150 191.31 Inv 86281 Total 191.31 40527 Total: 5443 - Metro Products, Inc. Total: 0121 - Midwest Government Advisors Line Item Account 40528 07/27/2012 Inv 07-175 Line Item Date Line Item Descrintion 06/18/2012 2012 Consulting & Recruiting Fees 06/18/2012 2012 Consulting & Recruiting Fees Inv 07-175 Total 40528 Total: 0121 - Midwest Government Advisors Total: 0220 - Minnesota Dept. of Labor & Industry Line Item Account 40529 07/27/2012 Inv 03312012 Line Item Date Line Item Descrintion 03/31/2012 Q1 & Q2 2012 Building Pennit Surcharges Inv 03312012 Total Inv 06302012 Line Item Date 06/30/2012 Inv 06302012 Total Line Item Descrintion Q1 & Q2 2012 Building Permit Surcharges 40529 Total: Line Item Account 101-41300-43050 101-41300-43100 Line Item Account 101-42400-44380 Line Item Account 101-42400-44380 fL'I�cil 191.31 690.00 632.50 1,322.50 1,322.50 1,322.50 5,731.08 5,731.08 4,560.75 4,560.75 10,291.83 0220 - Minnesota Dept. of Labor & Industry TotaL• 10,291.83 8029 - MMKR & Co, PA Line Item Account 40530 07/27/2012 Inv 31561 Line Item Date Line Item Description Line [tem Account 06/30/2012 Final Billing for 2011 Audit & Financial Statements 101-41500-43010 2,680.00 06/30/2012 Final Billing for 2011 Audit & Financial Statements 601-49440-43010 2,680.00 AP-Check Detail (7/27/2012 - 10:12 AM) Page 8 Checic Number Check Date Amount 06/30/2012 Final Billing for 2011 Audit & Financial Statements 602-49490-43010 2,680.00 06/30/2012 Final Billing for 2011 Audit & Fu�ancial Statements 603-49520-43010 2,680.00 06/30/2012 Final Billing for 2011 Audit & Financial Statements 604-49550-43010 2,680.00 Inv 31561 Total 13,400.00 40530 Total: 8029 - MMKR & Co, PA TotaL• 6349 - Nosek, Mary Line Item Account 40531 07/27/2012 Inv 07092012-MN Line Item Date Line Item Description 07/09/2012 July 2012 AH Notes Inv 07092012-MN Total 40531 Total: 6349 - Nosek, Mary Total: 0530 - Olson, Michelle Line Item Account 0 07/27/2012 Inv 07232012-1 Line Item Date Line Item Descriutiou 07/23/2012 March-May 2012 Mileage Reimbursement 07/23/2012 March-May 2012 Mileage Reimbursement Inv 07232012-1 Total Inv 07232012-2 Line Item Date Line Item Descrintion 07/23/2012 May 2012 Mileage Reimbursement Inv 07232012-2 Total Inv 07232012-3 Line Item Date Line Item Description 07/23/2012 May-June 2012 Mileage Reimbursement Inv 07232012-3 Total Inv 07232012-4 Line Item Date Line Item Descrintion 07/23/2012 June-July 2012 Mileage Reimbwsement Inv 07232012-4 Total Line Item Account 101-41100-43540 Line Item Account 101-45120-43310 101-45200-44325 Line Item Account 101-45120-43310 Line Item Account 101-45120-43310 Line Item Account 101-45120-43310 13,400.00 13,400.00 140.00 140.00 140.00 140.00 48.29 8.00 56.29 43.01 43.01 58.83 58.83 44.68 44.68 AP-Check Detail (7/27/2012 - 10:12 AM) Page 9 Check Number Check Date Amount Inv 07232012-5 Line Item Date Line Item Description Line Item Account 07/23/2012 July 2012 Mileage Reimbursement 101-45120-43310 64.38 Inv 07232012-5 Total 0 Total: 0530 - Olson, Michelle TotaL• 0509 - Peterson, Fram & Bergman Line Item Account 40532 07/27/2012 Inv 10450-052012 Line Item Date Line Item Descrintion OS/31/2012 May 2012 Legal Expenses-SS Easement OS/31/2012 May 2012 Legal Expenses-StenbergAbatement OS/31/2012 May 2012 Legal Expenses-Nuisance Abatement 1203 Cty Rd E OS/31/2012 May 2012 Legal Expenses-Admin Legal OS/31/2012 May 2012 Legal Expenses-Valentine Park Legal OS/31/2012 May 2012 Legal Expenses-PC 12-002 Holiday Inn 05/31/2012 May 2012 Legal Expenses-Prosecution Inv 10450-052012 Total 40532 Total: 0509 - Peterson, Fram & Bergman Total: 0298 - Pitney Bowes-Meter Service Line Item Account 40533 07/27/2012 Inv 7349674-JY12 Line Item Date Line Item Description 07/13/2012 April-July 2012 Postage Rental Inv 7349674-JY12 Tota1 40533 Total: 0298 - Pitney Bowes-Meter Service Total: 1208 - Premium Waters, Inc Line Item Account 40534 07/27/2012 Inv 610207-06-12 Line Item Date Line Item Description 06/30/2012 CH Supplies Inv 610207-06-12 Total Line Item Account 101-42400-43040 ]01-42400-43040 101-42400-43040 101-41300-43040 409-48315-43040 101-00000-22000 101-41300-43045 Line Item Account 101-41500-44150 Line Item Account 101-41940-42010 64.38 267.19 2G7.19 168.00 180.00 208.00 636.00 84.00 228.00 2,140.91 3,644.91 3,644.91 3,64491 1,525.00 I ,525.00 1,525.00 1,525.00 115.82 115.82 AP-Check Detail (7/27/2012 - 10:12 AM) Page 10 Check Number Check Date Amount Inv 613317-06-12 Line Item Date Line Item Descriqtion Line Item Account 06/30/2012 CH Supplies 101-41940-42010 174.23 Inv 613317-06-12 Total 174.23 40534 Total: 1208 - Premium Waters, Inc Total: 0811 - Ramsey County Line Item Account 40535 07/27/2012 Inv EMCOM-001995 Line Item Date Line Item Descrintion 07/20/2012 July 2012 911 Dispatch Inv EMCOM-001995 Total Inv EMCOM-002005 Line Item Date Line Item Description 07/20/2012 July 2012 Fleet Support Fee Inv EMCOM-002005 Total Inv P�V-000520 Line Item Date Line Item Description 07/18/2012 2012 Special Assessment Billing Inv PRRRV-000520 Total Inv PRRRV-000542 Line Item Date Line Item Descrinrion 07/18/2012 2012 Recycling Fee Inv PRRRV-000542 Total 40535 Total: 0811 - Ramsey County Total: 1001 - Sprint/Nextel IntCrd Line Item Account 40536 07/27/2012 Inv 525888811-056 Line Item Date Line Item Descrintion 07/18/2012 July 2012 Council Wireless Cards Inv 525888811-056 Total Line Item Account 101-42150-43121 Line Item Account 101-42300-44330 Line Item Account 411-48501-44390 Line Item Account 603-49520-44371 Line Item Account 101-41100-43210 `�z�x��y 290.05 4,101.62 4,101.62 24.96 24.96 1,282.50 1,282.50 1,259.50 1,259.50 6,668.58 6,668.58 104.00 104,00 AP-Check Detail (7/27/2012 - 10:12 AM) Page 11 Check Number Check Date Amount 40536 Total: 1001 - Sprint/Nextel IntCrd Total; 1387 - Standard Insurance Company Line Item Account 40537 07/27/2012 Inv 741490-082012 Line Item Date Line Item Description 07/17/2012 August 2012 STD/LTD/Life Insurance Inv 741490-082012 Total 40537 Total: 1387 - Standard Insurance Company Total: 0327 - Staples Line Item Account 40538 07/27/2012 Inv 3178057470 Line Item Date Line Item Descrintion 07/12/2012 Office Supplies Inv 3178057470 Total Inv 3178086474 Line Item Date 07/13/2012 Inv 3178086474 Total Inv 3178359074 Line Item Date 07/18/2012 Inv 3178359074 Total Line Item Description Office Supplies Line Item Descrintion Office Supplies Return 40538 Total: Line Item Account 101-00000-21733 Line Item Account 101-41500-42010 Line Item Account 101-41500-42010 Line Item Account 101-41500-42010 104.00 104.00 1,555.50 1,555.50 1,555.50 1,555.50 710.21 710.21 71.50 71.50 -112.11 -112.11 669.60 0327 - Staples Total: 669.60 1669 - SurveyMonkey.com, LLC, C/O $ank of America Lockbox Services Line Item Account 40539 07/27/2012 Inv 19835705 Line Item Date Line Item Description Line Item Account OG/22/2012 Survey Monkey 2012 Renewal 101-45120-44330 100.00 OG/22/2012 Survey Monkey 2012 Renewal 101-45200-44330 100.00 Inv 19835705 Total 200.00 AP-Check Detail (7/27/2012 - 10:12 AM) Page 12 Checic Number Check Date Amount 40539 Total: 1669 - SurveyMonkey.com, LLC, C/O Bank ofAmerica Lockbox Services Total: 7023 - Weekes Forest Products, Inc Llne Item Account 40540 07/27/2012 Inv 00040005-001 Line Item Date Line Item Descrintion OS/23/2012 Hazelnut Park Hockey Rink Inv 00040005-001 Total 40540 Total: 7023 - Weekes Forest Products, Inc Total: Total: Line Item Account 101-45200-42150 200.00 200.00 3,554.66 3,554.66 3,554.66 3,554.66 157,501.25 AP-Check Detail (7/27/2012 - 10:12 AM) Page 13 Accounts Payable Check Detail User: ashley.bertrand Printed: 07/27/2012 - 10:16AM Check Number Check Date Amount 0319 - City of Roseville Line Item Account 40541 07/27/2012 Inv 0216179 Line Item Date 06/12/2012 06/12/2012 06/12/2012 06/12/2012 06/12/2012 06/12/2012 06/12/2012 06/12/2012 06/12/2012 06/12/2012 06/12/2012 06/12/2012 06/12/2012 06/12/2012 06/12/2012 06/12/2012 06/12/2012 Inv 0216179 Total Inv 0216291 Line Item Date 07/19/2012 Inv 0216291 Total 40541 Total: Line Item Description Q2 2012 Engineering-I&I Q2 2012 Engineering-2006 PMP Q2 2012 Engineering-10/96 Q2 2012 Engineering-CP Rail Q2 2012 Engineering-2010 PMP Q2 2012 Engineering-694/51 Q2 2012 Engineering-ELA Trail Q2 2012 Engineering-Lex Ave Trail Improvements Q2 2012 Engineering-Storm Pond Maintenance Project Q2 2012 Engineering-Storm Pond Maintenance Project Q2 2012 Engineering-PC 10-012 Pres Homes Redevelopment Q2 2012 Engineering-Surface Water Management Plan Q2 2012 Engineering-Storm Sewer Q2 2012 Engineering-Admin Q2 2012 Engineering-Water Q2 2012 Engineering-Sewer Q2 2012 Engineering-Admin Line Item Description Q2 2012 Water Bill 0319 - City of Roseville TotaL• HYMT - Dakota Supply Group, Inc. Line Item Account 40542 07/27/2012 luv 7308667 Line Item Date Line Item Description 07/02/2012 2012 Water Meter Replacement-Network Starter Kit Inv 73086G7 Total _ � �� Line Item Account 602-48504-43030 411-48501-43030 411-48400-43030 227-48300-43030 411-48508-43030 411-48319-43030 227-48208-43030 227-48306-43030 604-48518-43030 411-48510-43030 101-00000-22000 604-48521-43030 604-49550-43030 101-41300-43030 601-49440-43030 602-49490-43030 411-48511-43030 Line Item Account 601-49440-43820 Line Item Account 601-48517-45600 460.27 318.65 106.22 141.62 35.41 106.22 2,260.65 106.22 35.41 1,905.41 53.11 346.75 1,042.12 13,195.21 60.10 2,674.45 6,192.89 29,040.71 269,910.10 269,910.10 298,950.81 298,950.81 29,951.72 29,951.72 AP-Check Detail (7/27/2012 - 10:16 AM) Page 1 Check Number Check Date Amount Inv 7433902 Line Item Date Line Item Description Line Item Account 07/13/2012 2012 Water Meter Replacement 601-48517-45600 10,631.39 Inv 7433902 Total 10,631.39 Inv 7441363 Line Item Date 07/18/2012 Inv 7441363 Total Line ltem Description 2012 Water Meter Replacement Line Item Account 601-48517-45600 18,303.04 18,303.04 40542 Total: HYMT - Dakota Supply Group, Inc. Total: 2129 - Elfering & Associates Line Item Account 40543 07/27/2012 Inv 1668 Line Item Date Line Item Descrintion 06/29/2012 Valentine Pazk Engineering Services June 2012 Inv 1668 Total 40543 Total: 2129 - Elfering & Associates Total: 0495 - Lake Johanna Fire Department Inc. Line Item Account 40544 07/27/2012 Inv 399 Line Item Date L,ine Item Descrintion 06/26/2012 Payment #2 2012 Contract Inv 399 Total 40544 Total: Line Item Account 604-48315-43030 Line Item Account 101-42100-43130 58,886.15 58,886.15 9,655.00 9,655.00 9,655.00 9,655.00 196,434.49 196,434.49 196,434.49 0495 - Lake Johanna Fire Department Inc. Total: 196,434.49 0243 - Met Councll Environ. Service-Waste Water Line Item Account 40545 07/27/2012 Inv 0000993017 Line Item Date Line Item Descriqtion Line Item Account 07/03/2012 Wastewater Service Charges August 2012 602-49490-43850 55,483.62 Inv 0000993017 Total 55,483.62 AP-Check Detail (7/27/2012 - 10:16 AM) Page 2 Check Number Check Date Amount 40545 Total: 0243 - Met Council Environ. Servlce-Waste Water Total: 0811 - Ramsey County Line Item Account 40546 07/27/2012 Inv SHRFL-001145 Line Item Date Line Item Description 07/O1/2012 July 2012 RC Sheriff Inv SHRFL-001145 Total 40546 Total: 0811 - Ramsey County Total: 7319 - Rum River Contracting Line Item Account 40547 07/27/2012 Inv 5012 Line Item Date Line Item Descrintion 07/20/2012 2012 CIP Seal Coating Inv 5012 Total 40547 Total: 7319 - Rum River Contracting TotaL• Total Line Item Account 101-42100-43120 Line Item Account 411-48501-45900 55,483.62 55,483.62 81,304.61 81,304.61 81,304,61 81,304.61 62,68735 G2,68735 62,687.35 62,68735 763,402.03 AP-Check Detail (7/27/2012 - 10:16 AM) Page 3