HomeMy WebLinkAbout24274 RESOLUTION NO. 24274
A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF PALM SPRINGS,
CALIFORNIA, APPROVING PAYMENT OF PAYROLL WARRANTS FOR THE
PERIOD ENDED 07-07-2017 BY WARRANTS NUMBERED 419985 THROUGH
420006 TOTALING $43,288.69 LIABILITY CHECKS NUMBERED 1093269
THROUGH 1093288 TOTALING $81,391.26, FIVE WIRE TRANSFERS FOR
$67,437.29, AND THREE ELECTRONIC ACH DEBITS OF $1,369,291.03 IN
THE AGGREGATE AMOUNT OF $1,561,408.27, 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. Riehl
Director of Finance and Treasurer
NOW, THEREFORE BE IT RESOLVED by the City Council of the City of Palm Springs that
payroll warrants numbered 419985 through 420006, liability checks numbered 1093269 through
1093288, 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 19T" DAY OF JU 7.
David H. Ready, Esq., Ph.D.
City Manager
ATTEST:
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. 24274 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 July 19, 2017, by the following vote:
AYES: Councilmembers Kors, Mills, Roberts, Mayor Pro Tern Foat, and Mayor Moon
NOES: None
ABSENT: None
ABSTAIN: None
RECUSED: None y�
Kathleen D. Hart, MMC
Interim City Clerk
I v a
�p 'fins
Print Check List
Execution #xxx 792
Function:RPCH
Run By:SHARONR
Run Start Date:Jul 6,2017 9:51:16 AM
Payroll Sank Account:XXXXX661,xxxxxx\2000
From Pay Issue Date:Jul 7,2017
To Pay issue Date:Jul 7, 2017
Included Printed:Yes
Include Unprinted:Yes
Include Voided:Yes
Include Cleared:
Include Outstanding:Yes
Include Reconciled:
Include Vold Checks Only:
Sort By:Check Number
User Comment:
FxevAon#XX 792 run by SHARONR using RPCH.docx• Prepafed by s!'ersarfati#y 4,50.00:05
Run:Jul 6.2017 9:51:16 AM Print Check List Page a of 2
Sorted By:Check Number From:Ju17 2017 To:Jul 7,2017
Bank of America Transit:XXXXX 6B1 Account: XXXXX i2OOO V not yet printed)
check# Amount Check Bate p'ersara Grade Name Check Tyne Check has
419987 2,380.60 Jul 7,2017 15839 Andrade,Jose Computer Check Outstanding
419988 1,456.17 Jul 7,2017 15905 Castillo,Jorge Computer Check Outstanding
419989 1,224.07 Jul 7,2017 16084 Goedhart,Veronica Computer Check Outstanding
4199W 1,909.72 Jul 7,2017 15784 Richards,Tabitha Computer Check Outstanding
419991 4,658.58 Jul 7,2017 16077 Virata,Whitlen J Computer Check Outstanding
419992 1,089.97 Jul 7,2017 16080 Brann,Joshua Computer Check Outstanding
419993 1,028.48 Jul 7,2017 16079 1Gsgen,Brandon Computer Check Outstanding
419994 1,056.53 Jul 7,2017 16082 Pornthepsiripong,Punpong Computer Check Outstanding
419995 1,108.39 Jul 7,2017 16081 Valenti,Kelly Computer Check Outstanding
419996 1,190.42 Jul 7,2017 16083 D'Amato, IGrsten Computer Check Outstanding
419997 1,378.05 Jul 7,2017 10993 Huskey,Zachary B Computer Check Outstanding
419998 1,329.74 Jul 7,2017 15222 Hernandez,Francisco Computer Check Outstanding
419999 1,369.44 Jul 7,2017 04905 Leon,Amuifo H Computer Check Outstanding
420M 1,990.63 Jul 7,2017 10253 Mercado,Gilbert R Computer Check Outstanding
420001 1,389.68 Jul 7,2017 15968 Chavez,Aris O Computer Check Outstanding
420002 5,332.04 Jul 7,2017 10660 Reyes,Bryan Computer Check Outstanding
420003 1,919.95 Jul 7,2017 15156 Meniey,Charles A Computer Check Outstanding
420004 1.538.85 Jul 7,2017 15833 Waits,Noel Computer Check Outstanding
420005 1,677.23 Jul 7,2017 16076 Clifford,Patrick Computer Check Outstanding
420W6 1,917A5 Jul7,2017 16078 Torres,Edward Computer Check Outstanding
Total#Checks Reported:20
Total Check Amount Reported:$36,845.79
Execution#XX 792 run by SHARONR using RPCH.docx- )'tapered by el ersonality 4.50.00,O
C� YAIp
V O
Y .qM1
Cn<itnY.>ag4:
Print Check List
Execution#xxx$20
Function:RPCH
Run By:DOLORESO
Run Start Date:Jul 10,2017 1:54:03 PM
Payroll Bank Account:xxxxx 661,xxxxxx 2000
From Pay issue Date:Jul 5,2017
To Pay Issue Date:Jul 5,2017
Included Printed:Yes
Include Unprinted:Yes
Include Voided:Yes
Include Cleared:Yes
Include Outstanding:Yes
Include Reconciled:Yes
Include Vold Checks Only:No
Sort By:Check Number
User Comment:
Execution#XX$20 run by DOLORESO using RPCH.docx Prepared by sPersonaJity 4.60,00.05
Run:Jul 10,2n171:64:0s PM Print Check List eye 2 of 2
Sorted By:Check Number From:Jul 5,2017 To:Jul 5,2017
Sank of Anwdca Transit:XXXXXOGI Account: XXXXX ;2000 (*not yet printed)
Check Amount Check Date P4rson Code HAM check lyoe Check Status
419985 8,983.21 Jul 5,2017 16054 Trovato,Jonathan Computer Check Outstanding
419986 2,459.69 Jul 5,2017 16054 Trovato,Jonathan Computer Check Outstanding
"total#Checks Reported:2
Total Check Amount Reported:$8,447.90
Total#Checks Cleared:0
Total Check Amount Clearer:$0.00
Execution#;XX820 nun by DOLORESO using RPCH.docx- Prepared by ePsrsanality 4.50.00.05
SUNGARD PENTAMATION - FUND ACCOUNTING MANAGER PAGE NUMBER: 1
DATE: 07/06/17 CITY OF PALM SPRINGS ACCTPA21
TIME: 10:57:SG CHECK REGISTER INCLUDING SYSTEM VOIDS ACCOUNTING PERIOD: 1/18
SELECTION CRITERIA: chkstat.rundate='07/07/2017'
DISTRIBUTION FUND: 001
CHECK NUMBER ISSUE DATE VENDOR STATUS TOTAL DESCRIPTION
1093269 07/07/2017 AMERICAN FIDELITY ASSURAN R 579.32 ACCOUNTS PAYABLE CHECK
1093270 07/07/2017 EMPLOYMENT DEVELOPMENT DE R 93.10 ACCOUNTS PAYABLE CHECK
1093271 07/07/2017 KANSAS PAYMENT CENTER R 2B4.50 ACCOUNTS PAYABLE CHECK
1093272 07/07/2017 GARNISHMENT R 1008.46 ACCOUNTS PAYABLE CHECK
1093273 07/07/2017 AFLAC R 120.45 ACCOUNTS PAYABLE CHECK
1093274 07/07/2017 DAVEY ADMIN GROUP R 9881.68 ACCOUNTS PAYABLE CHECK
1093275 07/07/2017 FIRE MANAGEMENT ASSOCIATI R 472.50 ACCOUNTS PAYABLE CHECK
1093276 07/07/2017 FRANCHISE TAX BOARD R 2102.95 ACCOUNTS PAYABLE CHECK
1093277 07/07/2017 LIBERTY MUTUAL INSURANCE R 1270.70 ACCOUNTS PAYABLE CHECK
1093278 07/07/2027 MANAGEMENT ASSN OF PALM S R 1001.25 ACCOUNTS PAYABLE CHECK
1093279 07/07/2017 PALM SPRINGS FIREMENS ASS R 1775.52 ACCOUNTS PAYABLE CHECK
1093280 07/07/2017 POLICE OFFICERS' ASSOCIAT R 7265.96 ACCOUNTS PAYABLE CHECK
1093281 07/07/2017 RIVERSIDE COUNTY SHERIFF R 75.00 ACCOUNTS PAYABLE CHECK
1093282 07/07/2017 SEIU LOCAL 721 CTW AND C R 2478.50 ACCOUNTS PAYABLE CHECK
1093283 07/07/2017 SUN COMMUNITY R 48078.70 ACCOUNTS PAYABLE CHECK
1093284 07/07/2017 UNITED WAY OF THE DESERT R 169.00 ACCOUNTS PAYABLE CHECK
1093285 07/07/2017 GARNISHMENT R 152.00 ACCOUNTS PAYABLE CHECK
1093286 07/07/2017 PS FIRE SAFETY UNIT R 2151,65 ACCOUNTS PAYABLE CHECK
1093287 07/07/2017 GARNISHMENT R 620.50 ACCOUNTS PAYABLE CHECK
1093288 07/07/2017 TRANSAMERICA WORKSITE MAR R 1789.52 ACCOUNTS PAYABLE CHECK
TOTAL FUND 81391,26
TOTAL REPORT 81391.26
Ariana Muniz
From: Thomas Hays
Sent: Thursday, July 06, 2017 10:24 AM
To: Sharon Riddle; Rita Gustafson; Dolores Olvera;Ariana Muniz
Subject: Separation Payroll 070517 Federal and State Tax Payments
Federal:
EnteredPayment Information Data
TaxpayerElN. - A xxxxz0757 -
Tax Form 941 Employers Federal Tax
Tax Type ( Federal Tax Deposit
Tax Period Q3/2017
PaymentAmount i $1,308.65
Settlement Date 07/07/2017
Subcategories:
2 Medicare $248.50
3 Tax Withholding I $1,060.15
State:
Payment Submission Date and Time (PST) : 7/6/2017 Time: 10:18:46 AM
EDD Employer Identification Number : 80098221
Deposit Schedule : Next bank Day
Pay Date : 07/06/17
SDI Amount : $0.00
PIT Amount : $337.91
Total Amount : $337.91
Bank Debit Date : 07/07/17
Confirmation Number : 1440409
Regards,
THOMAS HAYS
Deputy City Treasurer
3200 E.Tahquitz Canyon Way
Palm Springs,CA 92263
(760)323-8223 direct
thomas.hays@oalmsoringsca.gov
1
Ariana Muniz
From: Thomas Hays
Sent: Thursday,July 06, 2017 10:46 AM
To: Sharon Riddle; Rita Gustafson; Dolores Olvera;Ariana Muniz
Subject: Payroll 070717 Federal and State Tax Payments
Federal:
Entered' Payment Information Data
TaxpayerElN xxxzx0757
Tax Form 941 Employers Federal Tax
Tax Type Federal Tax Deposit
Tax Period Q3/2017
Payment Amount;" .$262,543.01
Settlement Date 07/07/2017
Subcategories: "
3 Medicare $46,76352
3 Tax Withholding $215,779.49 "
State:
Payment Submission Date and Time (PST) : 7/6/2017 Time: 10:45:11 AM
EDD Employer Identification Number :80098221
Deposit Schedule : Next bank Day
Pay Date : 07/06/17
SDI Amount : $0.00
PIT Amount: $72,128.91
Total Amount : $72,128.91
Bank Debit Date : 07/07/17
Confirmation Number: 1440635
Regards,
THOMAS HAYS
Deputy City Treasurer
3200 E.Tahquitz Canyon Way
Palm Springs,CA 92263
(760)323-8223 direct
thomas.hays(@Dalmsprin_qsca.gov
1
Previous Day ACH Report Bank of America Company:Palm Springs CA City of
Requestor:Ariana Muniz Merrill Lynch
Run Date:07/11/2017 14:57:44 CDT
As of:07/05/2017
Bank of America,Southern California(XX)(X 661
X)CXX 20001 City of Palm Springs General Acct I USD I As of:0 710 5/2 0 1 7
Detail Credits
I o M pppp
t,�'S��P�,Pf�y�f IPi 4;4��'I�l��i���I li INrile) �1 �
Preauthorized ACH Credit(165) 715,023.00 715,023.00 0.00 0.00 86007715738 0000000000
Preauthorized ACH Credit(165) 16,913.00 15,913.00 0.00 OW 86009137714 0000000000
Preauthorized ACH Credit(165) 3,828.00 3,628.00 0.00 0,00 86009137715 0000000000
Preauthorized ACH Credit(165) 3,105.00 3,105.00 0.00 0.00 8660§520637 OOOOOOOOOD'
Preauthorized ACH Credit(165) 1,353.74 1,353.74 0.00 0.00 86009137713 0000000000
'Preauthorized ACH Credit(165) 660.00 660.00 0.00 0.00 86008790874 ' 0000000000
Preauthorized ACH Credit(165) 495.00 495.00 0.00 0.00 86005371957 0000000000
Preauthorized ACH Credit(165) 44.00 44.00 0.00 0.00 86009116976 0000000000
Preauthorized ACH Credit(165) 39.00 39.00 0,00 0.00 86009117159 0000000000
Preauthorized ACH Credit(165) 36.00 36.00 0.00 0.00 86009117160 0000000000
Credit Totals 740,496.74 740,496.74 0.00 0.00
Detail Debits
iv i f4P I (Pir1 R�74'9'P`R ��'f1 €�)� ��4�411
ill Il �f �
��� �;1���a; � ���',�r��ti � �f����;i���� +�lu,�� 1���,�����!����lll;����1�������r
Preauthorized ACH Debit(455) 606.77 86008837579 0000000000
Debit Totals 606.77
Totals
Bank Totals
0 710 512 01 7
X
Total Credits 10 740.496.74
Total Debits 1 606.77
Report Totals
0 710 512 01 7
IN
Total Credits 10 740,496.74
Total Debits 1 606.77
Page 1
Previous Day ACH Report BankofAmerica-'Company:Palm Springs CA City of
Requestor:Ariana Muniz Merrill Lynch
Run Date:07/11/2017 14:58:57 CDT Y
As of:07/07/2017
Bank of America,Southern California JXXXX 661
XXXX`2000 I City of Palm Springs General Acct I USD As of:07/07/2017
Detail Credits
Preauthorized ACH Credit(165) 12,748,28 12,748.28 0.00 0.00 86021758500 0000000000
Preauthorized ACH Credit(165) 4,063.82 4,093.82 0.06 0.00 88008959239 0000000000'
Preauthorized ACH Credit(165) 3,615.00 3,615.00 0.00 0.00 88008959241 0000000000
Preauthorized ACH Credit(165) 2,049.00 2049.00 0.00 0.00 88008959240 0000000000''
Preauthorized ACH Credit(165) 1,404.00 1,404.00 0.00 0.00 87016672137 0000000000
Preauthorized ACH Credit(165) 451 A0 451.00 0,00 0.00 87014666452 0000000000
— ---- --— — — _ -:...-------
Preauthorized ACH Credit(165) 23.00 23.00 0.00 0.00 88008934267 0000000000
Credit Totals 24,384.10 24,384.10 0.00 0.00
Detail Debits
@�)yr()i��rdtlfniiki���i�'11)rt,fr�: i�
Preauthorized ACH Debit(455) ✓ 262.543.01 88008040063 0000000000
Preauthorized ACH Debit(455) ✓ 72,128.91 '88008235954 0000000000
Preauthorized ACH Debit(455) ✓ 1,308.65 88008040005 0000000000
Preauthorized ACH Debit(455) ✓ 337.91 88008235940 0000000D00
ACH Settlement Debit(466) ✓ 1,032,797.55 88008712109 0000000000
ACH Settlement Debit(466) ✓ 175.06 '88013993100 0000000000
Debit totals 1,369,291.03
Totals
Bank Totals
07/07/2017
XXXX
Total Credits 7 24,384.10
Total Debits 6 1,369,291,03
Report Totals
07107/2017
Total Credits 7 24,384.10
Total Debits 6 1,369,291.03
Pagel
Previous Day ACH Repoli Bank of America-1I Company:Palm Springs CA City of
Requestor:Ariana Muniz Merrill Lynch
Run Date:07/11/2017 15:00:30 CDT J
As of: 07/10/2017
Bank of America,Southern California 1)(X)()( 661
)OOO(2000 i City of Palm Springs General Acct USD I As of:07/1 012 01 7
Detail Credits 9 Y
Preauthorized ACH Credit(165) 4,997.00 4,997.00 0.00 0,00 91013326143 0000000000
Preauthorized ACH Credit(165) 4,335.00 4,335.00 0.00 0.00 91012155584 0000000000
Preauthorized ACH Credit(165) 3,275.00 3,275.00 0.00 0.00 91012116594 0000000000
Preauthorized ACH Credit(165) 2,652.00 2,652.00 MO 0.00 91012116593 0000000000
Preauthorized ACH Credit(165) 1,488.00 1,488.00 0.00 0.00 91012996786 0000000000
Preauthorized ACH Credit(165) 545.00 545.00 0.00 0.00 91008428018 0000000000
Preauthorized ACH Credit(165) 293.00 293.00 0.00 0.00 91010647904 0000000000
Preauthorized ACH Credit(155) 27.04 27.04 0.00 0.00 91012091793 0000000000
Preauthorized ACH Credit(165) 23.00 23.00 O.DO 0.00 91012091678 0000000000
Credit Totals 17,635.04 17,635.04 0.00 0.00
Detail Debits
• tSYi lQ l i
Preauthorized ACH Debit(455) ✓ 4,599,83 88015097803 0000000000
Debit Totals 4,599.63
Totals
Bank Totals
07/10/2017
will
XXX III ii
now
Total Credits 9 17,635.04
Total Debits 1 4,599.83
Report Totals
07/10/2017
Total Credits 9 17,635.04
Total Debits 1 4,599.83
Pagel
Previous Day Wire Report Bank ofAmerica'�I Company:Palm Springs CA City of
Requestor:Ariana Muniz Merrill Lynch
Run Date:0711 11201 7 1 5:02:36 CDT Y
As of'.0710712017
Bank of America,Southern California I XXXX'661
XXXX 20001 City of Palm Springs General Acct I USD As of:0 710 7/2 0 1 7
Detail Credits
Incoming Money Transfer Credit 18,468.50 18,468,50 0.00 0.00 00370327835 0000000000
(195)
CreditTotals 18,468.50 18,468.50 0.00 0.00
Detail Debits
Outgoing Money Transfer Debit(495) / 33,546.03 00370400719 0000000000
Outgoing Money Transfer Debit(495) t/ 19,994.83 00370400721 0000000000
Outgoing Money Transfer Debit(495) 8,612.50 00370400720 0000000000
Outgoing,Money Transfer Debit(495j 684.10 -00370400724 0000000000
Debit Totals 62,837.46
Totals
Bank Totals
07107/2017
P
Total Credits 1 18,468.50
Total Debits 4 62,837,46
Report Totals
0710712017
Total Credits 1 18.468.50
Total Debits 4 62,837.46
Pagel