Loading...
HomeMy WebLinkAbout24129 RESOLUTION NO. 24129 A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF PALM SPRINGS, CALIFORNIA, APPROVING PAYMENT OF PAYROLL WARRANTS FOR THE PERIOD ENDED 10-08-2016 BY WARRANTS NUMBERED 419693 THROUGH 419704 TOTALING $23,279.89 LIABILITY CHECKS NUMBERED 1088260 THROUGH 1088278 TOTALING $84,533.63, FIVE WIRE TRANSFERS FOR $66,940.91 , AND THREE ELECTRONIC ACH DEBITS OF $1,416,317.82 IN THE AGGREGATE AMOUNT OF $1,591,072.25, 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 419693 through 419704, liability checks numbered 1088260 through 1088278, 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 16TH DAY OF NOVEMBER, 2016. r ATTEST: David H. Ready, City M ames Thompson, City Clerk CERTIFICATION STATE OF CALIFORNIA ) COUNTY OF RIVERSIDE ) ss. CITY OF PALM SPRINGS ) I, JAMES THOMPSON, City Clerk of the City of Palm Springs, hereby certify that Resolution No. 24129 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 16th day of November, 2016, by the following vote: AYES: Councilmember Foat, Councilmember Kors, Councilmember Roberts, and Mayor Moon. NOES: None. ABSENT: Mayor Pro Tern Mills. ABSTAIN: None. es Thompson, City Clerk !Z 1 f 2 b City of Palm Springs, California ml ml SUNGARD PENTAMATION - FUND ACCOUNTING MANAGER PAGE NUMBER: 1 DATE: 10/13/16 CITY OF PALM SPRINGS ACCTPA21 TIME: 12:10:11 - CHECK�REGISTER INCLUDING SYSTEM VOIDS ACCOUNTING PERIOD: 4/17 SELECTION CRITERIA: chkstat.rundate='10/14/2016' ➢ISTRIBUTION FUND;- 001 CHECK NUMBER ISSUE DATE VENDOR STATUS TOTAL DESCRIPTION 1088260 10/14/2016 AMERICAN GENERAL R 429.09 ACCOUNTS PAYABLE CHECK 1088261 10/14/201G EMPLOYMENT DEVELOPMENT DE R 93.10 ACCOUNTS PAYABLE CHECK 1088262 10/14/2016 GARNISHMENT R 1221.69 ACCOUNTS PAYABLE CHECK 1088263 10/14/2016 GARNISHMENT R 300.00 ACCOUNTS PAYABLE CHECK 1088264 10/14/2016 AFLAC R 120.45 ACCOUNTS. PAYABLE CHECK 108826S 10/14/2016 DAVEY ADMIN GROUP R 7027.55 ACCOUNTS PAYABLE CHECK 1088266 10/14/2016 FIRE MANAGEMENT ASSOCIATI R 405.00 ACCOUNTS PAYABLE CHECK 1088267 10/14/2016 FRANCHISE TAX BOARD R 617.82 ACCOUNTS PAYABLE CHECK 1088268 10/14/2016 LIBERTY MUTUAL INSURANCE R 1318.22 ACCOUNTS PAYABLE CHECK 1088269 10/14/2016 MANAGEMENT ASSN OF PALM S R 971.25 ACCOUNTS PAYABLE CHECK 1088270 10/14/2016 PALM SPRINGS FIREMENS ASS R 2G45.99 ACCOUNTS PAYABLE CHECK 1088271 10/14/2016 POLICE OFFICERS' ASSOCIAT R 9814.43 ACCOUNTS PAYABLE CHECK 1088272 10/14/201G RIVERSIDE COUNTY SHERIFF R 1230.18 ACCOUNTS PAYABLE CHECK 1088273 10/14/2016 SEIU LOCAL 721 CTW AND C R 2492.00 ACCOUNTS PAYABLE CHECK 1088274 10/14/2016 SUN COMMUNITY R 53309.11 ACCOUNTS PAYABLE C14ECK 1088275 10/14/2016 UNITED WAY OF THE DESERT R 171.00 ACCOUNTS PAYABLE CHECK 1098276 10/14/2016 GARNISHMENT - R 152.00 ACCOUNTS PAYABLE CHECK 1088277 10/14/2016 GARNISHMENT R 620.50 ACCOUNTS PAYABLE CHECK 1088278 10/14/2016 TRANSAMERICA WORKSITE MAR R 1594.25 ACCOUNTS PAYABLE CHECK TOTAL FUND 84533.63 TOTAL REPORT 84533.63 C� 'MAIy Jp w �'n U V CAt'ltiFK�� Print Check List Execution # 108524 Function:RPCH Run By:SHARONR Run Start Date:Oct 12, 2016 4:41:32 PM Payroll Bank Account:122000661, 14318D82000 From Pay Issue Date:Oct 14, 2016 To Pay Issue Date:Oct 14,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#108524 run by SHARONR using RPCH.docx-20141008 Prepared by ePersonality 4.50.00.05 Run:Oct 12,2016 4:41:32 PM Print Check List Page 2 of Sorted By:Check Number From:Oct 14, 2016 To: Oct 14, 2016 Bank of America Transit:122000661 Account: 14318DB2000 ('not yet printed) Check# Amount Check Date Person Code Name Check Type Check Status 419693 1,540.96 Oct 14,2016 15839 Andrade,Jose Computer Check Outstanding 419694 1,469.50 Oct 14,2016 15905 Castillo, Jorge Computer Check Outstanding 419695 3,383.29 Oct 14,2016 15915 Chavez Jr, Mark Computer Check Outstanding 419696 1,409.05 Oct 14,2016 10993 Huskey,Zachary B Computer Check Outstanding 419697 1,633.66 Oct 14,2016 15222 Hernandez, Francisco Computer Check Outstanding 419698 1,309.36 Oct 14,2016 04905 Leon,Arnulfo H Computer Check Outstanding 419699 2,125.91 Oct 14,2016 10253 Mercado, Gilbert R Computer Check Outstanding 419700 1,399.70 Oct 14,2016 15968 Chavez,Aris O Computer Check Outstanding 419701 2,613.76 Oct 14, 2016 16031 Peeters, Henricus Computer Check Outstanding 419702 1,916.01 Oct 14, 2016 15156 Menley, Charles A Computer Check Outstanding 419703 3,369.76 Oct 14, 2016 15897 Doherty,Alexander Computer Check Outstanding 419704 1,108.93 Oct 14, 2016 15833 Waits, Noel Computer Check Outstanding Total#Checks Reported:12 Total Check Amount Reported:$23,279.89 Execution#108524 run by SHARONR using RPCH.docx-20141008 Prepared by ePersonality 4.50.00.05 CRO1220 DIRECT BANA OF AMERICA, N.A. PAGE 1 SITE: TX ACH SERVICES DATE/TIME: 10/12/16 16:52:00 BATCH CONTROL AND REJECTED ITEMS RECAP *x CONFIDENTIAL Fx RTN: 122000030 ACCT #: XXXMX%%%XXXXX2000 POINT: CIPEPRIN1 ORIGIN ID: 1956000757 ORIGIN NAME: CITY OF PALM SPRINGS FILE ID MOD: A APPL: CIPEPRINI CO ID: 1956000757 CO NAME: CITY OF PALM SPR ENTRY ➢ESC: PAYROLL SEC: PRO EFF DATE: 10/14/16 TYPE: FILE #: 1628GOD4526 BATCH #: 0000001 - CO DISC DATA: - REJECTED ITEMS ____________________________________________________________________________________________________________________________________ TRACE NUMBER TC RTN ACCOUNT NUMBER AMOUNT INDIVIDUAL ID INDIVIDUAL NAME ------------------------------------------------------------------------------------------------------------------------------------ REJECT REASON ____________________________________________________________________________________________________________________________________ THERE ARE NO REJECTED ITEMS FOR THIS BATCH HATCH TOTALS ----------------DEBITS------------------ _________________CREDITS_________________ SETTLEMENT DATE # ITEMS # ADDENDA AMOUNT # ITEMS # ADDENDA AMOUNT 10/14/16 0 0 .00 497 0 1,053,084.86 TOTAL 0 0 .00 494 0 1,053,034.89 TOTAL SUBMZTTE➢ 0 0 .00 497 0 1,053,004.86 TOTAL REJECTED 0 0 .00 0 0 .00 TOTAL PROCESSED 0 0 .00 497 0 1,053,064.06 "' END OF REPORT xxx CR01110 DIRECT HANK OF AMERICA, N.A. PAGE 1 SITE: IN - ACH SERVICES ➢ATE/TIME: 10/12/16 IB:41:00 ACKNOWLEDGMENT OF FILE RECEIPT x CONFIDENTIAL •x RIM: 122000030 ACCT #: XKKXXXXXXK M2000 FILE STATUS POINT: CIPSPRINI DATE: 10/12/19 TIME: 10:33 STATUS: FILE RECEIVED FILE INFORMATION ORIGIN ID; 1956000757 ORIGIN NAME: CITY OF PALM SPRINGS FILE ID MOO: A DATE CREATED: 10/12/16 TIME CREATED: 04-10 FILE TOTALS: TOTAL DEBIT AMOUNT: $0.00 TOTAL CREDIT AMOUNT: $1,053,094.BG TOTAL ITEM/ADDENDA RECOR➢S: 497 TOTAL NUMBER OF REJECTS: 0 TOTAL REJECTED DEBIT AMOUNT: $0.00 TOTAL REJECTED CREDIT AMOUNT: $0.00 IF QUESTIONS, PLEASE CALL ACH SERVICES AT 1.B00,424.2192 •x• END OF REPORT x*• Previous Day ACH Report i10 Company:Palm Sprigs CA City of - - Bankof America Reguestor:Adana Muniz Merrill Lynch Run Data: 1110712016 1 9:27:07 CST j As of:1 011 412 01 6 Bank of America,Southern California(122000661 XXXX 2000 i City of Palm Springs General Acct USD i As of..t 0/14/2016 Detail Credits Preauthorized ACH Credit(165) 13,775.20 13,775.20 - 0.00 0.00 88008572693 0000000000 Preauthorizatl pCFl Credit(16$j 10639:64' 10639.64- " p;00 `Q.QO , SSb07661796 OQOOOODQ00 Preauthorized ACH Credit(165) 8,333.33 8,333.33 0.00 D.00 86012509576 0000000000 2�7 A.00 5 0000000QOQPreauth 4 Preauthorized ACH Credit(165) 948.00 948.OD 0.00 0.00 88008549002 0000000000 PCeauthgrized�ACH Credit j165) 912.00 912.00 0.00 , D.00 8701665271P OOD00000D0 !. Preauthorized ACH Credit(165) 828.00 828.00 0.00 0.00 87014858366 0000000000 Preauthorized ACH.Credit(165) 824,59 824 59 0 00 i0 0O 87012162657 0000000000 Preauthorized ACH Credit(165) 354.00 354.00 0.00 0.00 88008548777 0000000000 P eauthgrizetl:ACH CCedit;(165). 26390 ; 263:00 0.00 •0.00 88008572694 0000000000 .Preauthorized ACH Credit(165) 186.00 186.00 0.00 0.00 87014858367 0000000000 t Preauthorized ACH Credit j165) '2000 26.00 ,0,00 ::Q.00 , '87014058368 0000000000 Preauthorized ACH Credit(165) 7.50 7.50 0.00 0.00 88008549001 0000000000 re�ItdO a15 %+r"iev.% kr # ? i. ...- Detail Debits Y Preauthorized ACH Debit(455) 2,085.26 87016444924 0000000000 ACH Settlement Debii(461) 1,052900.86 58008452704 OOOOOOOOOD ACH Settlement Debit(466) 175.00 88014550515 0000000000 - - 7]ebJtTotals S 4 1055$76i2 , w a i s 4 � Totals Bank Totals 1011412016 Total Credits 13 39,569.26 Total Debits 3 1,055,170.12 Report Totals 10N4/2016 Total Credits - 13 39,569.26 _ Page 1 Total Debits 3 1,055,170.12 Page 2 ._. . ... . . ... ... . . Ariana Muniz From: Sheila Thomas Sent: Thursday, October 13, 2016 10:36 AM To: Sharon Riddle; Rita Gustafson; Dolores Olvera;Ariana Muniz Subject: Payroll Taxes for Pay Date 10/14/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 $283,362.91 Settlement Date 10/17/2016 Subcategories: 1 Social Security $ 223.20 2 Medicare $ 45,658.62 3 Tax Withholding $ 237,481.09 STATE PAYMENTS State Disability Insurance(SDI)Tax and California Personal Income Tax(PIT) w e li. Ill e a - �u,i I Deposit Schedule Pay Date SDI Amount PIT Amount Total Amount Bank Debit Date Confirmation Number Next bank Day 10/14/16 $0.00 $79,870.05 $79,870.05 10/17/16 439455 1