Loading...
HomeMy WebLinkAbout5A, Claims and Payroll ,f`iREN�HILLS Request for Council Action 5A Prepared By: Ashley Bertrand,Sue Iverson Council Meeting Date: November 13,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#23 $101,572.88 Total Payroll $ 101,572.88 Accounts Payable Claims Through 11-9-2012 Paid Claims (Check No. 40941 thru Check No. 40952) $ 65,479.95 Paid Claims (Check No. 40953 thru Check No. 40974) $ 32,502.37 Total Claims $96,982.32 CITY OF ARDEN HILLS PAYROLL#23 CHECKS DATED: 11/09/12 Biweekly: 10/20/12 TO 11/02/12 FIT 8,290.83 ........ ..... EFT SIT EFT .............. FICA Oasdi 2,994.78 4,420.84 EFT FICA Medicare 1,036.65 1,036.65 EFT ITOTAL TAXES 15,788.221 5,457.49 Health Premium 1,312.56 13,558.39 A/P Check* xxx Dental Premium 887.77 A/P Check* ..................... ........................... ........ ........ ... A/P Check* FSA Health Care Reimb. 225.00'..9*"9.:.�: .:.:..:.: 9.......................... ................ FSA Dependent Care Reimb. 526.28 Check* ................ 9.............................. ,ITOTAL FLEXIBLE SPENDING 2,063.841 14,446.16 IHSA Health Saving 205.161 3,390.54 ITOTAL HEALTH SAVINGS 205.161 3,390.54 PERA 3,810.351 4,420.00 EFT lCMA 2,218.621 327.76 A/P Check* ................. ............................. Central Pension Fund-Union A/P Check* ITOTAL RETIREMENT 6,643.371 4,747.76 ..................... lU0E 49 Dues (Union) 130.00:*.*.*:ii��:�����i��������� ii;j�:�I..... A/P Check* .......... A/P Check* LTD/STD Insurance 1,189.04 ........ ...... ................ ............... ... PERA Life Insurance 40.00 ...... A/P Check* ........ .... Life/Addl/Dep Life 105.70 96.20 A/P Check* ...................... Mn Child Support 323.02.:::..*.:::>':'':> A/P Check* ............... . ..................... 11TOTAL VOLUNTARY 1,787.76 96.20 Total Employee Deductions ::: 26A8:3.,5: PR Check#17349-17353 Net Payroll 2,719.70 EFT Direct Deposit 44,226.68 Gross Payroll Tie-Out 73,434.73 STD/LTD Gross-Up 0.00 Plus City Paid Benefit 28,f 3:8.45: ........... XXXXX: 0MA:80n.eh:W ....... TOTAL PAYROLL COST 101,572.99-] FICA �0�.0 I...... . .......... Gross Payroll :::::::73,434:71 Less Total FSA Plus Employer Match lCMA Plus lCMA Benefit Held Net P/R Subject to FICA IFICA Oasdi(a)6.20% 11FICA Medicare(&, 1.45% 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/08/2012- 4:06PM Check Number Check Date Amount 4669-American Liberty Construction,Inc.Line Item Account 40941 11/02/2012 Inv 10292012 Line Item Date Line Item Description Line Item Account 10/29/2012 ELA Project Payment#8(Final Payment) 227-48208-45900 24,136.15 Inv 10292012 Total 24,136.15 Inv 10292012-2 Line Item Date Line Item Description Line Item Account 10/29/2012 ELA Project Settlement Agreement 227-48208-45900 2,000.00 Inv 10292012-2 Total 2,000.00 40941 Total: 26,136.15 4669-American Liberty Construction,Inc.Total: 26,136.15 ANDEJ-Anderson,John Line Item Account 0 11/02/2012 Inv 10292012-JA Line Item Date Line Item Description Line Item Account 10/29/2012 October 2012 Mileage Reimbursement 727-49700-43310 97.68 Inv 10292012-JA Total 97.68 0 Total: 97.68 ANDEJ-Anderson,John Total: 97.68 0131-Beisswenger's How-To Store Line Item Account 40942 11/02/2012 Inv 224556 Line Item Date Line Item Description Line Item Account 10/04/2012 PW Supplies 727-49700-42400 75.17 Inv 224556 Total 75.17 40942 Total: 75.17 AP-Check Detail(11/8/2012- 4:06 PM) Pagel Check Number Check Date Amount 0131-Beisswenger's How-To Store Total: 75.17 0319-City of Roseville Line Item Account 40943 11/02/2012 Inv 0216520 Line Item Date Line Item Description Line Item Account 10/02/2012 October 2012 IT Services 728-49900-43081 2,294.16 Inv 0216520 Total 2,294.16 Inv 0216555 Line Item Date Line Item Description Line Item Account 10/02/2012 October 2012 Phone Services 728-49900-43210 472.50 Inv 0216555 Total 472.50 40943 Total: 2,766.66 0319-City of Roseville Total: 2,766.66 HYMT-Dakota Supply Group,Inc.Line Item Account 40944 11/02/2012 Inv 7537730 Line Item Date Line Item Description Line Item Account 10/08/2012 2012 Water Meter Replacement 601-48517-45600 893.35 Inv 7537730 Total 893.35 Inv 7545795 Line Item Date Line Item Description Line Item Account 10/02/2012 2012 Water Meter Replacement 601-48517-45600 306.97 Inv 7545795 Total 306.97 40944 Total: 1,200.32 HYMT-Dakota Supply Group,Inc.Total: 1,200.32 4444-Exteriors Landscaping Line Item Account 40945 11/02/2012 Inv 09302012 Line Item Date Line Item DescriQtion Line Item Account 09/30/2012 2011 PMP,Watermain Re-sod,and LS!Landscaping Costs 604-48510-42250 1,000.00 09/30/2012 2011 PMP,Watermain Re-sod,and LS!Landscaping Costs 601-49440-42250 500.00 09/30/2012 2011 PMP,Watermain Re-sod,and LS!Landscaping Costs 602-49490-42250 2,440.00 Inv 09302012 Total 3,940.00 AP-Check Detail(11/8/2012- 4:06 PM) Page 2 Check Number Check Date Amount 40945 Total: 3,940.00 4444-Exteriors Landscaping Total: 3,940.00 0192-Grainger,Inc Line Item Account 40946 11/02/2012 Inv 9942946584 Line Item Date Line Item Description Line Item Account 10/04/2012 PW Supplies 727-49700-42150 147.36 Inv 9942946584 Total 147.36 Inv 9943896343 Line Item Date Line Item Description Line Item Account 10/04/2012 PW Supplies 727-49700-42150 171.73 Inv 9943896343 Total 171.73 40946 Total: 319.09 0192-Grainger,Inc Total: 319.09 3389-Hoffer,Lucas Line Item Account 40947 11/02/2012 Inv 10152012 Line Item Date Line Item Description Line Item Account 10/15/2012 Tree Escrow Reimbursement 101-00000-22000 775.84 Inv 10152012 Total 775.84 40947 Total: 775.84 3389-Hoffer,Lucas Total: 775.84 KEGC-Kennedy&Graven Line Item Account 40948 11/02/2012 Inv 110803 Line Item Date Line Item Description Line Item Account 09/30/2012 September 2012 TCAAP Legal Fees 161-41600-43040 2,432.43 Inv 110803 Total 2,432.43 40948 Total: 2,432.43 KEGC-Kennedy&Graven Total: 2,432.43 AP-Check Detail(11/8/2012- 4:06 PM) Page 3 Check Number Check Date Amount 7048-Magney Construction,Inc Line Item Account 40949 11/02/2012 Inv 10292012-MCI Line Item Date Line Item Description Line Item Account 10/29/2012 LS I &12 Improvements Payment#4 602-48402-45900 24,519.60 Inv 10292012-MCI Total 24,519.60 40949 Total: 24,519.60 7048-Magney Construction,Inc Total: 24,519.60 2249-Maurer,Terry Line Item Account 0 11/02/2012 Inv 11012012 Line Item Date Line Item Description Line Item Account 11/01/2012 August-September 2012 Mileage Reimbursement 727-49700-43310 84.92 Inv 11012012 Total 84.92 Inv 11012012-2 Line Item Date Line Item Description Line Item Account 11/01/2012 September-October 2012 Mileage Reimbursement 727-49700-43310 193.69 Inv 11012012-2 Total 193.69 0 Total: 278.61 2249-Maurer,Terry Total: 278.61 MNLI-Minnesota Native Landscapes,Inc Line Item Account 40950 11/02/2012 Inv 8483 Line Item Date Line Item Description Line Item Account 10/03/2012 Herbicide Application August-September 2012 101-41940-44010 430.00 Inv 8483 Total 430.00 40950 Total: 430.00 MNLI-Minnesota Native Landscapes,Inc Total: 430.00 2151-Ramsey Conservation District Line Item Account 40951 11/02/2012 Inv 101012AE Line Item Date Line Item Description Line Item Account AP-Check Detail(11/8/2012- 4:06 PM) Page 4 Check Number Check Date Amount 10/10/2012 Fox Ridge PC 11-009 101-00000-22000 431.47 10/10/2012 4046 Valentine Ct 101-00000-22000 35.96 10/10/2012 Pres Homes 2011-01294 101-00000-22000 467.42 10/10/2012 Arden Plaza PC 11-016 101-00000-22000 170.79 10/10/2012 Walgreens2012-00093 101-00000-22000 170.79 10/10/2012 2026 Thom Drive 2012-00647 101-00000-22000 143.82 10/10/2012 1958 Thom Drive 2012-00870 101-00000-22000 35.96 10/10/2012 Land O Lakes 101-00000-22000 215.73 10/10/2012 Valentine Park 227-48315-43101 395.51 Inv 101012AE Total 2,067.45 40951 Total: 2,067.45 2151-Ramsey Conservation District Total: 2,067.45 0751-Short Elliott Hendrickson,Inc.Line Item Account 40952 11/02/2012 Inv 261328 Line Item Date Line Item Description Line Item Account 10/10/2012 AT&T Cummings Park Escrow 101-00000-22000 440.95 Inv 261328 Total 440.95 40952 Total: 440.95 0751-Short Elliott Hendrickson,Inc.Total: 440.95 Total: 65,479.95 AP-Check Detail(11/8/2012- 4:06 PM) Page 5 Accounts Payable Check Detail User: ashley.bertrand Printed: 11/08/2012- 4:04PM Check Number Check Date Amount 0600-315800-NCPERS Minnesota Line Item Account 101-00000-21734 40953 11/08/2012 Inv 31582221 Line Item Date Line Item Description Line Item Account 10/23/2012 October 2012 Payroll Deductions 101-00000-21734 64.00 Inv 31582221 Total 64.00 40953 Total: 64.00 0600-315800-NCPERS Minnesota Total: 64.00 ALPI-Allegra Print&Imaging Line Item Account 40954 11/08/2012 Inv 133511 Line Item Date Line Item Description Line Item Account 10/03/2012 October 2012 Newsletter 101-41 100-43540 1,701.00 Inv 133511 Total 1,701.00 40954 Total: 1,701.00 ALPI-Allegra Print&Imaging Total: 1,701.00 6896-APA Minnesota Line Item Account 40955 11/08/2012 Inv 182264-1285 Line Item Date Line Item Description Line Item Account 10/15/2012 2013 Beekman Membership Renewal 101-41910-44330 420.00 Inv 182264-1285 Total 420.00 40955 Total: 420.00 6896-APA Minnesota Total: 420.00 CPF1-Central Pension Fund Line Item Account 101-00000-21772 40956 11/08/2012 AP-Check Detail(11/8/2012- 4:04 PM) Page 1 Check Number Check Date Amount Inv 10312012 Line Item Date Line Item Description Line Item Account 10/31/2012 October 2012 Contributions 101-00000-21772 1,228.80 Inv 10312012 Total 1,228.80 40956 Total: 1,228.80 CPF1-Central Pension Fund Total: 1,228.80 1033-Comcast Line Item Account 40957 11/08/2012 Inv 44271-102012 Line Item Date Line Item Description Line Item Account 10/11/2012 October 2012 TV Services 228-41960-43100 6.76 Inv 44271-102012 Total 6.76 40957 Total: 6.76 1033-Comcast Total: 6.76 1372-Hillcrest Animal Hospital Line Item Account 40958 11/08/2012 Inv 1116-102012 Line Item Date Line Item Description Line Item Account 11/01/2012 Sept-Oct 2012 Animal Control Services 101-42100-43150 1,646.85 Inv 1116-102012 Total 1,646.85 40958 Total: 1,646.85 1372-Hillcrest Animal Hospital Total: 1,646.85 0497-ICMA Membership Renewals Line Item Account 40959 11/08/2012 Inv 140650 Line Item Date Line Item Description Line Item Account 11/07/2012 2013 Membership Renewal 101-41300-44330 940.41 Inv 140650 Total 940.41 40959 Total: 940.41 0497-ICMA Membership Renewals Total: 940.41 AP-Check Detail(11/8/2012- 4:04 PM) Page 2 Check Number Check Date Amount 0382-ICMA Retirement Trust-106944 Line Item Account 101-00000-21740 40960 11/08/2012 Inv 11072012-PK Line Item Date Line Item Description Line Item Account 11/07/2012 PR#23 Contributions 101-00000-21740 610.31 Inv 11072012-PK Total 610.31 40960 Total: 610.31 0382-ICMA Retirement Trust-106944 Total: 610.31 0387-ICMA Retirement Trust-#302482 Line Item Account 101-00000-21742 40961 11/08/2012 Inv 11072012-CS Line Item Date Line Item Description Line Item Account 11/07/2012 PR#23 Contributions 101-00000-21742 1,936.07 Inv 11072012-CS Total 1,936.07 40961 Total: 1,936.07 0387-ICMA Retirement Trust-#302482 Total: 1,936.07 7501-Kelly&Lemmons,P.A.Line Item Account 40962 11/08/2012 Inv 11897-092012 Line Item Date Line Item Description Line Item Account 09/30/2012 September 2012 Legal Fees-Admin Legal 101-41300-43040 417.00 09/30/2012 September 2012 Legal Fees-P&Z Legal 101-41910-43040 165.00 09/30/2012 September 2012 Legal Fees-P&Z Legal 101-41910-43040 96.00 09/30/2012 September 2012 Legal Fees-PC 12-015 101-00000-22000 132.00 09/30/2012 September 2012 Legal Fees-2006 PMP 411-48501-43040 154.00 09/30/2012 September 2012 Legal Fees-SS Easement 101-42400-43040 228.00 09/30/2012 September 2012 Legal Fees-AT&T Escrow 101-00000-22000 36.00 09/30/2012 September 2012 Legal Fees-P&Z Legal 101-41910-43040 96.00 09/30/2012 September 2012 Legal Fees-ELA Trail 227-48208-43040 180.00 09/30/2012 September 2012 Legal Fees-Prosecution 101-41300-43045 3,866.03 Inv 11897-092012 Total 5,370.03 40962 Total: 5,370.03 7501-Kelly&Lemmons,P.A.Total: 5,370.03 8532-Landscape Structures,Inc Line Item Account 40963 11/08/2012 AP-Check Detail(11/8/2012- 4:04 PM) Page 3 Check Number Check Date Amount Inv C17485 Line Item Date Line Item Description Line Item Account 10/12/2012 Hazelnut Playground Repair Parts 101-45200-42230 1,426.78 Inv CI7485 Total 1,426.78 40963 Total: 1,426.78 8532-Landscape Structures,Inc Total: 1,426.78 MNCS-Minnesota Child Support Payment Center Line Item Account 101-00000-21780 40964 11/08/2012 Inv 11072012-MNCS Line Item Date Line Item Description Line Item Account 11/07/2012 Frid PR#23 Deductions 101-00000-21780 323.02 Inv 11072012-MNCS Total 323.02 40964 Total: 323.02 MNCS-Minnesota Child Support Payment Center Total: 323.02 0922-North Suburban Access Corporation Line Item Account 40965 11/08/2012 Inv 12-362 Line Item Date Line Item Description Line Item Account 10/18/2012 Q3 2012 Web Streaming 228-41960-43100 501.42 Inv 12-362 Total 501.42 40965 Total: 501.42 0922-North Suburban Access Corporation Total: 501.42 0330-Pioneer Press Line Item Account 40966 11/08/2012 Inv 1503734-2013 Line Item Date Line Item Description Line Item Account 10/05/2012 Pioneer Press 2013 Renewal 101-41300-44330 191.25 Inv 1503734-2013 Total 191.25 40966 Total: 191.25 0330-Pioneer Press Total: 191.25 AP-Check Detail(11/8/2012- 4:04 PM) Page 4 Check Number Check Date Amount 1110-Pitney Bowes Line Item Account 40967 11/08/2012 Inv 2012297 Line Item Date Line Item Description Line Item Account 10/23/2012 October 2012 Postage 101-41100-43220 526.22 10/23/2012 October 2012 Postage 101-41500-43220 83.61 Inv 2012297 Total 609.83 40967 Total: 609.83 1110-Pitney Bowes Total: 609.83 0298-Pitney Bowes-Meter Service Line Item Account 40968 11/08/2012 Inv 7349674-OT12 Line Item Date Line Item Description Line Item Account 10/13/2012 August-October 2012 Postage Rental 101-41500-44150 1,526.60 Inv 7349674-OT12 Total 1,526.60 40968 Total: 1,526.60 0298-Pitney Bowes-Meter Service Total: 1,526.60 0811-Ramsey County Line Item Account 40969 11/08/2012 Inv PUBW=012245 Line Item Date Line Item Description Line Item Account 10/11/2012 October 2012 PW Parts 727-49700-42210 79.31 Inv PUBW=012245 Total 79.31 40969 Total: 79.31 0811-Ramsey County Total: 79.31 0335-Scherer Bros.Lumber Co.Line Item Account 40970 11/08/2012 Inv 41060874 Line Item Date Line Item Description Line Item Account 10/09/2012 Park Materials 101-45200-42150 557.45 Inv 41060874 Total 557.45 40970 Total: 557.45 AP-Check Detail(11/8/2012- 4:04 PM) Page 5 Check Number Check Date Amount 0335-Scherer Bros.Lumber Co.Total: 557.45 STII-Strategic Insights,Inc Line Item Account 40971 11/08/2012 Inv 154 Line Item Date Line Item Description Line Item Account 10/30/2012 2013 License Renewal 101-41500-43080 270.53 10/30/2012 2013 License Renewal 601-49440-43080 270.53 10/30/2012 2013 License Renewal 602-49490-43080 270.53 10/30/2012 2013 License Renewal 604-49550-43080 270.52 Inv 154 Total 1,082.11 40971 Total: 1,082.11 STII-Strategic Insights,Inc Total: 1,082.11 0576-TimeSaver Off Site Secretarial Line Item Account 40972 11/08/2012 Inv M19363 Line Item Date Line Item Description Line Item Account 10/12/2012 Planning Commission Meeting 10.03.2012 101-41910-43110 183.43 Inv M 19363 Total 183.43 40972 Total: 183.43 0576-TimeSaver Off Site Secretarial Total: 183.43 1175-TNT Cleaning and Consulting,INC Line Item Account 40973 11/08/2012 Inv 262633 Line Item Date Line Item Description Line Item Account 10/10/2012 October 2012 Cleaning 101-41940-43840 903.09 Inv 262633 Total 903.09 40973 Total: 903.09 1175-TNT Cleaning and Consulting,INC Total: 903.09 6009-Ziegler,Inc.Line Item Account 40974 11/08/2012 Inv E8215301 Line Item Date Line Item Description Line Item Account 10/11/2012 City Hall Generator Conversion 602-49490-44040 11,193.85 AP-Check Detail(11/8/2012- 4:04 PM) Page 6 Check Number Check Date Amount Inv E8215301 Total 11,193.85 40974 Total: 11,193.85 6009-Ziegler,Inc.Total: 11,193.85 Total: 32,502.37 AP-Check Detail(11/8/2012- 4:04 PM) Page 7