HomeMy WebLinkAbout24270 RESOLUTION NO. 24270
A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF PALM SPRINGS,
CALIFORNIA, APPROVING PAYMENT OF PAYROLL WARRANTS FOR THE
PERIOD ENDED 06-17-2017 BY WARRANTS NUMBERED 419968 THROUGH
419984 TOTALING $24,042.23 LIABILITY CHECKS NUMBERED 1092955
THROUGH 1092974 TOTALING $80,389.12, FIVE WIRE TRANSFERS FOR
$59,187.88, AND THREE ELECTRONIC ACH DEBITS OF $1,323,320.42 IN
THE AGGREGATE AMOUNT OF $1,486,939.65, 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.
Geoff r6f 9IKiehl
Director of Finance and Treasurer
NOW, THEREFORE BE IT RESOLVED by the City Council of the City of Palm Springs that
payroll warrants numbered 419968 through 419984, liability checks numbered 1092955 through
1092974, 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 JULY, 2017.
David H. Ready, Esq.,
City Manager
ATTEST:
lL4az
Kathleen D. Hart, MMC,
Interim City Clerk
STATE OF CALIFORNIA ) CERTIFICATION
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. 24270 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 W�a
Kathleen D. Hart, MMC
Interim City Clerk
_Ct Yd�kH:dA
A W
a
Print Check List
Execution#xxx 434
Function:RPCH
Run By:SHAR4NR
Run Start Date:Jun 20,2017 3:45:53 PM
Payroll Bank Account:XXXxx 661,xxxxxx 2000
From Pay Issue Date:Jun 21,2017
To Pay Issue Date:Jun 21,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:
Execution#XX 434 run ay SHARONR using RPCH.docx. Prepared by ePersonality 4.60,00.05
Run;Jun 20,2017 3:45;53 PM Print Check List Page 2 of 2
Sorted By:Check Number From;Jun 21,2017 To:Jun 21,2017
Bank of America Transit:XXXX 661 Account:XXXXXX2000 { not yet printed)
Check# Amount Check Hate Person Code HIM -;heck Tvne
41996E 1,928.39 Jun 21,2017 16049 Jipp,Brian Computer Check Outstanding
419969 2,012.06 Jun 21,2017 16049 Jipp,Brian Computer Check Outstanding
Total#Checks Reported:2
Total Check Amount Reported:$3,940.45
Execution#XX 434 run by SHRRONR using RPCH.docx Prepared by ePersonality 4.60 00.05
�+ rat,y sp
a
w
. tit ,
Print Check List
Execution#XxX 646
Function:RPCH
Run By:SHARONR
Run Start Date:dun 21,2017 5:43:20 PM
Payroll Bank Account:XXXXX 661,XXXXXX 2000
From Pay issue Date:Jun 23,2017
To Pay Issue gate:Jun 23,2017
Included Printed:Yes
Include Unprinted:Yes
Include Voided:Yes
Include Cleared:
Include Outstanding:Yes
Include Reconciled:
Include Vold Checks Only:
Soft By:Check Number
User Gomment:
Execution#XX 546 run by SHARONR using RPGH.dooxXXXXX Prepared by ePersonatity 4.W.00.05
Run;Jun 21,2017 5143:20 psi Print Check List Page 2 of 2
Sorted 8y,Check Number Fram:Jun 23,2017 To:Jun 23,2017
Bank of America TransitXXXX 681 Account:XXXXXX2000 ("not yet printed)
Check# Amoun Check Date Person Code Name Check Tvoe Ch9sk Status
419970 1,887.09 Jun-23,2017 15839 Andrade,Jose Computer Check Outstanding
419971 1,430.29 Jun 23,2017 15905 Castillo,Jorge Computer Check Outstanding
419972 798,02 Jun 23,2017 15784 Richards,Tabitha Computer Check Outstanding
419973 11924 Jun 23,2017 15M Gagnon,Susan Computer Check Outstanding
419974 1,350.94 Jun 23,2017 10993 Huskey,Zachary B Computer Check Outstanding
419975 1,123.50 Jun 23,2017 15603 Navarro,Yrene Computer Check Outstanding
419976 1,299.50 Jun 23,2017 15222 Hernandez,Francisco Computer Check Outstanding
419977 1,341„40 Jun 23,2017 04905 Leon,Amutfo H Computer Check Outstanding
419978 1,966.14 Jun 23,2017 10253 Mercado,Gilbert R Computer Check Outstanding
419979 1,365,29 Jun 23,2017 15968 Chavez,Aris O Computer Check Outstanding
419980 1,885.85 Jun 23,2017 15156 Menley,Charles A Computer Check Outstanding
419981 3,259.93 Jun 23,2017 15897 Doherty,Alexander Computer Check Outstanding
419982 153.64 Jun 23,2017 15365 Weems,Cassie L Computer Check Outstanding
419983 1,322.77 Jun 23,2017 15833 Waits, Noel Computer Check Outstanding
419984 809.18 Jun 23,2017 16075 Williams,David M Computer Check Outstanding
Total#Checks Reported:15
Total Check Amount Reported:$20,101.78
Execution#XX 546 run by$HARONR using RPCH.docx Prepared by ePersonality 4.50.00,05
SUNGARD PENTAMATION - FUND ACCOUNTING MANAGER PAGE NUMBER: 1
DATE: 06/22/17 CITY OF PALM SPRINGS ACCTPA21
TIME: 11:55:19 CHECK REGISTER INCLUDING SYSTEM VOIDS ACCOUNTING PERIOD: 12/17
SELECTION CRITERIA: chkstat.rundate='06/23/2017'
DISTRIBUTION FUND: 001
CHECK NUMBER ISSUE DATE VENDOR STATUS TOTAL DESCRIPTION
109295S 06/23/2017 AMERICAN FIDELITY ASSUR-AN R 579.32 ACCOUNTS PAYABLE CHECK
109295G 06/23/2017 EMPLOYMENT DEVELOPMENT DE R 93.10 ACCOUNTS PAYABLE CHECK
1092957 06/23/2017 KANSAS PAYMENT CENTER R 284.50 ACCOUNTS PAYABLE CHECK
1092958 06/23/2017 GARNISHMENT R 1008.46 ACCOUNTS PAYABLE CHECK
1092959 06/23/2017 AFLAC R 120.45 ACCOUNTS PAYABLE CHECK
1092960 06/23/2017 DAVEY ADMIN GROUP R 9519.18 ACCOUNTS PAYABLE CHECK
1092961 06/23/2017 FIRE MANAGEMENT ASSOCIATI R 472.50 ACCOUNTS PAYABLE CHECK
1092962 06/23/2017 FRANCHISE TAX BOARD R 2418.4G ACCOUNTS PAYABLE CHECK
1092963 06/23/2017 LIBERTY MUTUAL INSURANCE R 1261.31 ACCOUNTS PAYABLE CHECK
1092964 06/23/2017. MANAGEMENT ASSN OF PALM S R 986.25 ACCOUNTS PAYABLE CHECK
1092965 06/23/2017 PALM SPRINGS FIREMENS ASS R 1775.52 ACCOUNTS PAYABLE CHECK
1092966 06/23/2017 POLICE OFFICERS' ASSOCIAT R 7285.96 ACCOUNTS PAYABLE CHECK
1092967 06/23/2017 RIVERSIDE COUNTY SHERIFF R 436.74 ACCOUNTS PAYABLE CHECK
1092968 06/23/2017 SEIU LOCAL 721 CTW AND C R 2465.00 ACCOUNTS PAYABLE CHECK
1092969 06/23/2017 SUN COMMUNITY R 47042.70 ACCOUNTS PAYABLE CHECK
1092970 06/23/2017 UNITED WAY OF THE DESERT R 169.00 ACCOUNTS PAYABLE CHECK
1092971- 06/23/2017 GARNISHMENT R 152.00 ACCOUNTS PAYABLE CHECK
1092972 06/23/2017 PS FIRE SAFETY UNIT R 1908.65 ACCOUNTS PAYABLE CHECK
1092973 06/23/2017 GARNISHMENT R 620.50 ACCOUNTS PAYABLE CHECK
1092974 06/23/2017 TRANSAMERICA WORKSITE MAR R 1789.52 ACCOUNTS PAYABLE CHECK
TOTAL FUND 80389.12
TOTAL REPORT 80389.12
Ariana Muniz
From: Thomas Hays
Sent: Wednesday,June 21, 2017 10:22 AM
To: Sharon Riddle; Rita Gustafson; Dolores Olvera;Ariana Muniz
Subject: Payroll 062117 Federal and State Tax Payments
Federal:
EnteredPayment Information Data
TaxpayerEIN xxxxx0757
Tax Form 941 Employers Federal Tax
Tax Type Federal Tax Deposit
Tax Period Q2/2017
Payment Amount $1,103.00
Settlement Date 06/22/2017
Subcategories:
2 Medicare $162.32
3 Tax Withholding $940.68
State:
Payment Submission Date and Time (PST) : 6/21/2017 Time: 10:17:44 AM
EDD Employer Identification Number : 80098221
Deposit Schedule : Next bank Day
Pay Date : 06/21/17
SDI Amount : $0.00
PIT Amount : $286.65
Total Amount : $286.65
Bank Debit Date : 06/22/2017
Confirmation Number : 1392205
Regards,
THOMAS HAYS
Deputy City Treasurer
3200 E.Tahquitz Canyon Way
Palm Springs, CA 92263
(760)323-8223 direct
thomas.hays(a palmspringsca gov
1
Ariana Muniz
From: Thomas Hays
Sent: Thursday,June 22,2017 12:38 PM
To: Sharon Riddle; Rita Gustafson; Dolores Olvera;Ariana Muniz
Subject: Payroll 062317 Federal and State Tax Payments
Federal:
'Paymentata
Taxpayer;EIN xxxxx0757
Tax Form 941 Employers Federal Tax
Tax Type Federal Tax Deposit
Tax Period Q2/2017
Payment Amount $245,632,24
Settlement Date 06/23/2017
Subcategories:
-1 Social Security $111.60
2 Medicare $44,538.22
3 Tax Withholding $200,982.42-
State:
Payment Submission Date and Time (PST) : 6/22/2017 Time: 12:37:49 PM
EDD Employer Identification Number: 80098221
Deposit Schedule : Next bank Day
Pay Date : 06/23/17
SDI Amount : $0.00
PIT Amount : $66,879.48
Total Amount: $66,879.48
Bank Debit Date : 06/23/2017
Confirmation Number: 1396664
Regards,
THOMAS HAYS
Deputy City Treasurer
3200 E.Tahquitz Canyon Way
Palm Springs,CA 92263
(760)323-8223 direct
thomas.ha s a palmsaringscaoov
Previous Day ACH Report BankofAmerical�
Company:Palm Springs CA City of
Requestor:Ariana Muniz Merrill Lynch
Run Date:07/11/2017 13:23:45 CDT Y
As of:0 6/2 212 0 1 7
Bank of America,Southern California I XXXX 661
XXXX.2000 I City of Palm Springs General Acct I USD I As of.06/22/2017
Detail Credits pp
i 4 ��ii!!E ( � '�ii I /iQ
!, 1lI�J!I��r4illii�C
Preauthorized ACH Credit(165) 12,657.04 12,657.04 0.00 0.00 73004889973 0000000000
Preauthorized ACH Credit(165) 10,287.97 10,287.97 0.00 0.00 71018398076 OOOOD00000
Preauthorized ACH Credit(165) 3.666.00 3,666.00 0,00 0.00 73004889975 0000000D00
Preauthorized ACH Credit(165) 1.364.00 1,364.00 D.00 0.00 73004889974 0000000000
Preauthorized ACH Credit(165) 675.00 675.00 0.00 D.00 72011717604 0000000000
Preauthorized ACH Credit(165) 658.00 658.00 0.00 0.00 72013385522 0000000000 r
Preauthorized ACH Credit(165) 50.00 50.00 0.00 0.00 73004865090 0000000000
Preauthorized ACH Credit(165) 6.00 6.00 0.00 0.00 73004865306 0000000000
Credit Totals 29,364.01 29,364.01 0.00 0.00
Detail Debits
M 1 6Ir ., i 'i tii, i �!4 Ebl 4�c yt
Preauthorized ACH Debit(455) ✓ 1,103.00 73004231972 0000000000
Preauthorized ACH Debit(455) ✓ 286.65 73004371432 0000000000
Debit Totals 1,389.65
Totals —_-
Bank Totals
0612212017
XXXX
Total Credits 8 29,364,01
Total Debits 2 1.389.65
Report Totals
06/22/2017
Total Credits 8 29.364,01
Total Debits 2 1,389.65
Page 1
Previous Day ACH Report �10
Company:Palm Springs CA City of Bankof America'I
Requestor:Arian Muniz Merrill Lynch
Run Date:07/11/2017 13:25:06 CDT
As of:0612312017
Bank of America,Southern California 1XXXX 661
XXXX 20001 City of Palm Springs General Acct(USD As of:06/23/2017
Detail Credits gMEMEM
Preauthorized ACH Credit(165) 1,403,965.17 1,403,965.17 0.00 0.00 72010789454 0000000000
Preauthorized ACH Credit(165) 1,358 00772 1,358,007.72 0.00 0.00 72010789453 0000000000:
Preauthorized ACH Credit(165) 10,814.90 10,814.90 0.00 0.00 74005088529 0000000000
Preauthorized ACH Credit(165) 3,294.00 3,294.00 0.00 0.00 74005088531 0000000000
Preauthorized ACH Credit(165) 3,116.00 3,116.DO 0.00 0.00 74005088530 0000000000
Preauthorized ACH Credit(165) 996.00 996,00 0.00 0.00 73013732709 0000000000
Preauthorized ACH Credit(165) 180.00 180.00 0.00 0.00 73011713739 0000000000
Preauthorized ACH Credit(165) 74,94 74,94 0.00 0.00 74005063563 0000600000
Preauthorized ACH Credit(165) 46.00 46.00 MO 0.00 74005063341 0000000000
Credit Totals 2,780,494.73 2,780,494.73 0.00 0.00
Detail Debits
Preauthorized ACH Debit(455) ✓ 245,632.24 74004337410 0000000000
Preauthorized ACH Debit(455) / 66,879.48 74004530238 0000000000
ACH Settlement Debit(466) ✓ 1,009,244.05 74004891465 0000000000
ACH Settlement Debit(466) ✓ 175.00 74010446662 0000000000
Debit Totals 1,321,930.77
Totals
Bank Totals
0 612 31211 7
XX
fePpZ}b f} [f Yg@ i
Total Credits 9 2,780,494,73
Total Debits 4 1,321,930.77
Report Totals
06/2312017
Total Credits 9 2,780,494.73
Total Debits 4 1,321,930.77
Pagel
Previous Day ACH Report
Company:Palm Springs CA City of Bankof America
Requestor:Ariana Muniz Merrill Lynch
Run Date:07/11/2017 13:26:20 CDT Y
As of:0 612 612 01 7
Bank of America,Southern California JXXXX 661
XXXX 2000 1 City of Palm Springs General Acct I USD As of:06/26/2017
Detail Credits
'�'4�Y�u�srl41 s�(ifi iSj'li�t!# ler,Ft
i� S It;�e tliYypi� YYYY�p�o It �{�
I41!f) ,��t� 'a6'�I��I� � II ll',u�i i�,�i �
l
Corporate Trade Payment Credit 58,880.00 58.880.00 0.00 0.00 77006672106 0000000000
(164)
Preauthorized ACH Credit(165) 6,184,00 6,184.00 0.00 0.00 77608602514 0000000000
Preauthorized ACH Credit(165) 5,658.00 5.658.00 0.00 0.00 77007437374 0000000000
Preauthorized ACH Credit(165) 3.341.00 3,341.00 0,00 0.00 77007475650 0000000000
Preauthorized ACH Credit(165) 2,387.50 2,387.50 0.00 0.00 77007437373 0000000000
Preauthorized ACH Credit(165) 1,943.00 1,943.00 0.00 0.00 77008113446 0000000000
Preauthorized ACH Credit(165) 1,686.00 1,686.00 0.00 0.00 77003752592 0000000000
Preauthorized ACH Credit(165) 413.00 413.00 0.00 0.00 77006966542 0000000000
Preauthorized ACH Credit(165) 54.65 54.65 0.00 0,00 77007412577 0000000000
Preauthorized ACH Credit(165) 32.05 32.05 0.00 0.00 77007455170 0000000000
Credit Totals 80,579.20 80,579.20 0.00 0.00
Detail Debits
�i (� � IG' Sl i •, y i' ryvt p+mt yr+jig xt;$1lf�'!yi V Y ,. ., 7 i"�'!'
Preauthorized ACH Debit(455) 4,775.83 74011415317 0000000000
Debit Totals 4,775.83
Totals
Bank Totals
06/26/2017
XXXX
Total Credits 10 80,579.20
Total Debits 1 4,775.83
Report Totals
06/26/2017
Total Credits 10 80,579.20
Total Debits 1 4,775.83
Pagel
Previous Day Wire Report BankofAmerica'
Company:Palm Springs CA City of
Requestor:Ariana Muniz Merrill Lynch
Run Date:07/1112017 13:35:00 CDT
As of:06/23/2017
Bank of America,Southern California J XXXX 661
XXXX 2000 1 City of Palm Springs General Acct USD As of:06/23/2017
Detail Debits y g
9 � �tM )P i ?.''S 4',��I 1 W� "�,r P et t ,r�� �P�t!I$; I Jt l,�J� � 4� M i(•�.,, 4 u�4 e iM s '16Pu6�'( )' 9,,�1'i�tP,�.
Outgoing Money Transfer Debit(495) ✓ 25,814.37 00370417928 0000000000
Outgoing Money Transfer Debit(495) ✓ 19,619 83 00370417929 0000000000.
Outgoing Money Transfer Debit(495) ✓ 8,293.75 00370417926 0000000000
Outgoing Money Transfer Debit(495) 684.10 00370417930 0000000000
Debit Totals K412.05
Totals
Bank Totals
06123/2017
XXXXIM SEEM
Total Credits 0 0.00
Total Debits 4 54,412.05
Report Totals
0612312017
Total Credits 0 0.00
Total Debits 4 54,412.05
Pagel