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