Loading...
HomeMy WebLinkAbout24142 RESOLUTION NO. 24142 A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF PALM SPRINGS, CALIFORNIA, APPROVING PAYMENT OF PAYROLL WARRANTS FOR THE PERIOD ENDED 11-05-2016 BY WARRANTS NUMBERED 419717 THROUGH 419730 TOTALING $24,142.51 LIABILITY CHECKS NUMBERED 1088684 THROUGH 1088705 TOTALING $85,121.05, FIVE WIRE TRANSFERS FOR $58,675.66, AND THREE ELECTRONIC ACH DEBITS OF $1,332,021.31 IN THE AGGREGATE AMOUNT OF $1,499,960.53, DRAWN ON BANK OF AMERICA. WHEREAS, the Director of Finance has, in accordance with Chapter 3.16 of the Palm Springs Municipal Code, audited the payroll records covering the subject warrants; and WHEREAS, the Director of Finance hereby certifies to the accuracy of said records and to the availability of funds for payment. Geoffrey S. Kiehl Director of Finance and Treasurer NOW, THEREFORE BE IT RESOLVED by the City Council of the City of Palm Springs that payroll warrants numbered 419717 through 419730, liability checks numbered 1088684 through 1088705, five wire transfers and three electronic ACH debits have been audited as required by law and that said warrants are hereby approved for payment. ADOPTED THIS 7TH DAY OF DECEMBER, 2016. ATTEST: David H. Ready, Esq., P ity Manager Kathleen D. Hart, MMC, Interim City Clerk CERTIFICATION STATE OF CALIFORNIA ) COUNTY OF RIVERSIDE ) ss. CITY OF PALM SPRINGS ) I, KATHLEEN D. HART, Interim City Clerk of the City of Palm Springs, hereby certify that Resolution No. 24142 is a full, true and correct copy, and was duly adopted at a regular meeting of the City Council of the City of Palm Springs on the 7th day of December, 2016, by the following vote: AYES: Councilmember Foat, Councilmember Kors, Councilmember Roberts, Mayor Pro Tern Mills, and Mayor Moon NOES: None ABSENT: None ABSTAIN: None Kathleen D. Hart, MMC, Interim City Clerk SUNGARD PENTAMATION - FUND ACCOUNTING MANAGER PAGE NUMBER: 1 DATE: 11/10/26 CITY OF PALM SPRINGS ACCTPA21 TIME: 10:21:20 CHECK REGISTER INCLUDING SYSTEM VOIDS ACCOUNTING PERIOD: 5/17 SELECTION CRITERIA: chkstat.rUndate='11/11/2016' DISTRIBUTION FUND: 001 CHECK NUMBER ISSUE DATE VENDOR STATUS TOTAL DESCRIPTION 1088684 11/11/2016 AMERICAN GENERAL R 429.09 ACCOUNTS PAYABLE CHECK 1088685 11/11/2016 EMPLOYMENT DEVELOPMENT DE R 93.10 ACCOUNTS PAYABLE CHECK 1088686 11/11/2016 KANSAS PAYMENT CENTER R 284.50 ACCOUNTS PAYABLE CHECK 1088687 11/11/2016 GARNISHMENT R 1221.69 ACCOUNTS PAYABLE CHECK 1088688 11/11/2016 GARNISHMENT R 300.00 ACCOUNTS PAYABLE CHECK 1088689 11/11/2016 AFLAC R 120.45 ACCOUNTS PAYABLE CHECK 1088690 11/11/2016 DAVEY ADMIN GROUP R 6944.22 ACCOUNTS PAYABLE CHECK 1088691 11/11/2016 FIRE MANAGEMENT ASSOCIATI R 405.00 ACCOUNTS PAYABLE CHECK 1088692 11/11/2016 FRANCHISE TAX BOARD R 667.82 ACCOUNTS PAYABLE CHECK 1088693 11/11/2016 LIBERTY MUTUAL INSURANCE R 125B.86 ACCOUNTS PAYABLE CHECK 1088694 11/11/2016 MANAGEMENT ASSN OF PALM S R 941.25 ACCOUNTS PAYABLE CHECK 1088695 11/11/2016 PALM SPRINGS FIREMENS ASS R 1208.74 ACCOUNTS PAYABLE CHECK 1088696 11/11/2016 POLICE OFFICERS' ASSOCIAT R 9629.43 ACCOUNTS PAYABLE CHECK 1088697 11/11/2016 RIVERSIDE COUNTY SHERIFF R 741.99 ACCOUNTS PAYABLE CHECK 1088698 11/11/2016 SEIU LOCAL 721 CTW AND C R 2492.00 ACCOUNTS PAYABLE CHECK 1088699 11/11/2016 SUN COMMUNITY R 53384.51 ACCOUNTS PAYABLE CHECK 1088700 11/11/2016 UNITED WAY OF THE DESERT R 171.00 ACCOUNTS PAYABLE CHECK 1088701 11/11/2016 GARNISHMENT R 152.00 ACCOUNTS PAYABLE CHECK 1088702 11/11/2016 PS FIRE SAFETY UNIT R 2197.40 ACCOUNTS PAYABLE CHECK 1086703 11/11/2016 GARNISHMENT R 620.50 ACCOUNTS PAYABLE CHECK 1088704 11/11/2016 STATE OF CA FRANCHISE TAX R 263.25 ACCOUNTS PAYABLE CHECK 1088705 11/11/2016 TRANSAMERICA WORKSITE MAR R 1594.25 ACCOUNTS PAYABLE CHECK TOTAL FUND 85121.05 TOTAL REPORT 85121.05 C� YAIy JP � A. v •C��'1 C1FK�p Print Check List Execution # 108853 Function:RPCH Run By:SHARONR Run Start Date:Nov 9, 2016 5:05:34 PM Payroll Bank Account:122000661, 14318DB2000 From Pay Issue Date:Nov 11, 2016 To Pay Issue Date:Nov 11, 2016 Included Printed:Yes Include Unprinted:Yes Include Voided:Yes Include Cleared: Include Outstanding:Yes Include Reconciled: Include Void Checks Only: Sort By:Check Number User Comment: Execution# 108853 run by SHARONR using RPCH.docx-20141008 Prepared by ePersonality 4.50.00.05 Run: Nov 9, 2016 5*05:34 PM Print Check List Page 2 of 2 Sorted By:Check Number From: Nov 11,2016 To: Nov 11, 2016 Bank of America Transit: 122000661 Account: 1431BD82000 ('not yet printed) Check# Amount Check Date Person Code Name Check Type Check Status 419717 1,549.81 Nov 11, 2016 15839 Andrade,Jose Computer Check Outstanding 419718 1,546.58 Nov 11,2016 15905 Castillo, Jorge Computer Check Outstanding 419719 2,179.59 Nov 11,2016 16033 Goolsby, Denise Computer Check Outstanding 419720 1,241.05 Nov 11,2016 10993 Huskey,Zachary B Computer Check Outstanding 419721 1,876.43 Nov 11,2016 15222 Hernandez, Francisco Computer Check Outstanding 419722 1,309.35 Nov 11,2016 04905 Leon,Arnulfc H Computer Check Outstanding 419723 2,302.63 Nov 11,2016 10253 Mercado, Gilbert R Computer Check Outstanding 419724 1,399.70 Nov 11,2016 15968 Chavez,Ads O Computer Check Outstanding 419725 2,157A1 Nov 11,2016 15156 Menley, Charles A Computer Check Outstanding 419726 2,033.66 Nov 11,2016 16034 Canchola,Alvaro Computer Check Outstanding 419727 3,824.21 Nov 11,2016 15897 Doherty,Alexander Computer Check Outstanding 419728 1,896.35 Nov 11,2016 16035 Torres, Michael Computer Check Outstanding 419729 826.04 Nov 11,2016 15833 Waits, Noel Computer Check Outstanding Total#Checks Reported:13 Total Check Amount Reported:$24,142.61 Execution#108853 run by SHARONR using RPCH.docx-20141008 Prepared by ePersonalry 4.50.00.05 CRO1220 DIRECT BANK OF AMERICA, N.A. PAGE 1 SITE: T% ACH SERVICES DATE/TIME: 11/09/16 21:29:00 BATCH CONTROL AND REJECTED ITEMS RECAP •+ CONFIDENTIAL FIN; 122000030 ACCT #: 00000001431862000 POINT: CIPSPRINI ORIGIN ID: 1956000757 ORIGIN NAME: CITY OF PALM SPRINGS FILE ID MOD: A APPL: CIPSPRINI CO ID; 1956000757 CO NAME: CITY OF PALM SPR ENTRY DESC: PAYROLL SEC: PP➢ EFF DATE: 11/11/16 TYPE: FILE #: 16314004355 BATCH #: 0000001 CO DISC DATA: REJECTED ITEMS TRACE NUMBER TO ATN ACCOUNT NUMBER AMOUNT INDIVI➢UAL IO INDIVIDUAL NAME ____________________________________________________________________________________________________________________________________ REJECT REASON ------------------------------------------------------------------------------------------------------------------------------------ THERE ARE NO REJECTED ITEMS FOR THIS BATCH BATCH TOTALS ----------------DEBITS------------------ _________________CREDITS_________________ SETTLEMENT DATE # ITEMS # ADDENDA AMOUNT # ITEMS # ADDENDA AMOUNT 11/30/16 0 0 .00 495 0 995,137.93 TOTAL 0 0 .00 495 0 995,237.93 TOTAL SUBMITTED 0 0 .00 495 0 995,137.93 TOTAL REJECTED 0 0 .OG 0 0 .00 TOTAL PROCESSED 0 0 .00 495 0 995,137.93 "' END OF REPORT +'* Previous Day ACH Report ij�� Company:Palm Springs CA City of Bank of America Requestor:Ariana Muniz Merrill Lynch Run Date:11/28/2016 20:22:52 CST As of: 1111012016 Bank of America,Southern California 1122000661 xxxxxx 2000 1 City of Palm Springs General Acct I USD I As of:11/10/2016 Detail Credits II I' II i I, III Corporate Trade Payment Credit 3,955.75 3,955.75 0.00 0.00 15002860320 0000000000 (164) Preauthorized ACH Credit(165) 14,675.70 14 67570 0.00 ^0.00 15002660138 0000000000f Preauthorized ACH Credit(165) 3,506.00 3.506.00 0.00 0.00 15003501761 0000000000 Preauthorizpd ACH Credit(165) 3,043.00 7 3,043 00 0.00 0.00 15003501760 0000000000'. Preauthorized ACH Credit(165) 2,217.60 2,217.60 0.00 0.00 15003501759 0000000000 Preauthorized ACH Credit(165) 983;00 983.00 0.00 0 00 14011542429 0000000000 Preauthorized ACH Credit(165) 517.00 517.00 0.00 0.00 15003478332 0000000000 Preauthorized ACH Credit(165) 82.60 82,80 0.00 0.00 15003478565 0000000000 Preauthorized ACH Credit(165) 20.00 20.00 0.00 0.00 14006493389 0000000000 :Credit Totals 29,000.85 29,000.115 0.00 0.00 Detail Debits , III ACH Settlement Debit(466) 994,962.93 1500340095E 0000000000 ACH Settlement Debit(466) 975.00 15008988396 0000006000 .Debit Totals 995,137.93 Totals Bank Totals 1111 012 01 6 Total Credits 9 29,000.85 Total Debits 2 995,137.93 Report Totals 1111012016 Total Credits 9 29,000.85 Total Debits 2 995,137.93 Page 1 Ariana Muniz From: Sheila Thomas Sent: Thursday, November 10, 2016 9:09 AM To: Dolores Olvera; Rita Gustafson; Sharon Riddle;Ariana Muniz Subject: Payroll Taxes for PR 11/11/16 FEDERAL PAYROLL TAXES Payment Information Entered Data Taxpayer EIN xxxxx0757 Tax Form 941 Employers Federal Tax Tax Type Federal Tax Deposit Tax Period Q4/2016 Payment Amount $263,215.32 Settlement Date 11/14/2016 Subcategories: 1 Social Security $ 200.88 2 Medicare $44,936.74 3 Tax Withholding $ 218,077.70 STATE PAYMENTS State Disability Insurance(SDI)Tax and California Personal Income Tax(PIT) b`E )o: er,)��ht�fi� titirlNumbe 8�0��221 Bank Acco+nt��*�*»*�20QQ Deposit Schedule Pay Date SDI Amount PIT Amount Total Amount Bank Debit Date Confirmation Number Next bank Day 11/11/16 $0.00 $73,668.06 $73,668.06 11/14/16 551476 1