HomeMy WebLinkAbout24246 RESOLUTION NO. 24246
A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF PALM SPRINGS,
CALIFORNIA, APPROVING PAYMENT OF PAYROLL WARRANTS FOR THE
PERIOD ENDED 05-20-2017 BY WARRANTS NUMBERED 419942 THROUGH
419955 TOTALING $28,508.70 LIABILITY CHECKS NUMBERED 1092447
THROUGH 1092467 TOTALING $82,397.60, FIVE WIRE TRANSFERS FOR
$58,196.58, AND THREE ELECTRONIC ACH DEBITS OF $1,331,743.19 IN
THE AGGREGATE AMOUNT OF $1,500,846.07, 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 419942 through 419955, liability checks numbered 1092447 through
1092467, 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 21 ST DAY OF JUNE, 2017.
David H. Ready, Esq., Ph.D.
City Manager
ATTEST:
1L � - n
Kathleen D. Hart, MM ,
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. 24246 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 June 21, 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 4607
Kathleen D. Hart, MMC
Interim City Clerk
c
Print Check List
Execution#XXX 764
Function:RPCH
Run By:SHARONR
Run Start Data:May24,2017 5:56:21 PM
Payroll Bank Account:XXXXX 661;XXXXXX 2000
From Pay Issue Date:May 26.2017
To Pay Issue Date:May 28,2017
Included Printed:Yes
Include Unprinted:Yes
Include Voided:Yes
include Geared:
Include Outstanding:Yes
Include Reconciled:
Include Vold Checks Only:
Sort By:Check Number
User Comment•
Execution#XX 754 run by SHARONR using RPCH.docx• Prepared by ePersorWity 4.50.00.05
Rum May 24,2017 5:56:21 PM Print Cheek List Page 2 of z
Sorted By:Check Number From:May 26,2017 To May 26,2017
Sank of America Tradsk:XXXXXBSI Account:XXXXXX2000 i"not yet prkdedt
Check# Amuurtt Check Date Person Code Ott Check Tune Check Status
419942 2,275.10 May 26,2017 15839 Andrade,Jose Computer Check Outstanding
419M 1,430.28 May 26,2017 15905 Castillo,Jorge Computer Check Outstanding
4199" 4,918.09 May26,2017 16073 Kotkin,Edward Computer Check Outstanding
419945 210.16 May 26,M17 15784 Richards,Tabitha Computer Check Outstanding
419M 5,037.23 May 26,2017 15946 Dennehy,Thomas Computer Check Outstanding
419947 1,350.94 May 26,2017 10993 Huskey,Zachary 8 Computer Check Outstanding
419948 758.24 May 26,2017 15429 Vega,Krystle Computer Check Outstanding
419949 1,366.78 May 26,2017 16222 Hernandez,Francisco Computer Check Outstanding
419950 1,689.23 May 26,2017 04905 Leon,Arnulto H Computer Check Outstanding
419951 2,033.05 May 26.2017 10253 Mercado,Gilbert R Computer Check Outstanding
419952 1,365.28 May 26,2017 15968 Chavez,Aris 0 Computer Check Outstanding
419953 2,112.33 May 26,2017 15156 Menley,Charles A Computer Check Outstanding
419954 2,594,82 May 26,2017 15897 Doherty,Alexander Computer Check Outstanding
419955 1,368.17 May 26,2017 15833 Waits,Noel Computer Check Outstanding
Total#Checks Reported:14
Total Check Amount Reported:328AN.70
Execution#XX 754 run by SHARONR using RPOH.docx, Prepared by*Personakty 4.50.00.05
SUNGARD PENTAMATION - FUND ACCOUNTING MANAGER PAGE NUMBER: 1
DATE: 05/25/17 CITY OF PALM SPRINGS ACCTPA21
TIME: 10:08:33 CHECK REGISTER INCLUDING SYSTEM VOI➢S ACCOUNTING PERIOD: 11/17
SELECTION CRITERIA: chkstat.rundate='05/26/2017'
DISTRIBUTION FUND: 001
CHECK NUMBER ISSUE DATE VENDOR STATUS TOTAL DESCRIPTION
1092447 05/26/2017 AMERICAN GENERAL R 471.79 ACCOUNTS PAYABLE CHECK
1092448 05/26/2017 EMPLOYMENT DEVELOPMENT DE R 93.10 ACCOUNTS PAYABLE CHECK
1092449 05/26/2017 KANSAS PAYMENT CENTER R 284.50 ACCOUNTS PAYABLE CHECK
1092450 05/26/2017 GARNISHMENT R 1221.69 ACCOUNTS PAYABLE CHECK
1092451 05/26/2017 GARNISHMENT R 300.00 ACCOUNTS PAYABLE CHECK
1092452 05/26/2017 AFLAC R 120.45 ACCOUNTS PAYABLE CHECK
1092453 05/26/2017 DAVEY ADMIN GROUP R 9740.56 ACCOUNTS PAYABLE CHECK
1092454 05/26/2017 FIRE MANAGEMENT ASSOCIATI R 472.50 ACCOUNTS PAYABLE CHECK
1092455 05/26/2017 FRANCHISE TAX BOARD R 1360.68 ACCOUNTS PAYABLE CHECK
1092456 05/26/2017 LIBERTY MUTUAL INSURANCE R 1293.95 ACCOUNTS PAYABLE CHECK
1092457 05/26/2017 MANAGEMENT ASSN OF PALM S R 986.25 ACCOUNTS PAYABLE CHECK
1092458 05/26/2017 PALM SPRINGS FIREMENS ASS R 1775.52 ACCOUNTS PAYABLE CHECK
1092459 05/26/2017 POLICE OFFICERS' ASSOCIAT R 7380.26 ACCOUNTS PAYABLE CHECK
1092460 05/26/2017 RIVERSI➢E COUNTY SHERIFF R 75.00 ACCOUNTS PAYABLE CHECK
1092461 05/26/2017 SEIU LOCAL 721 CTW AND C R 2451.50 ACCOUNTS PAYABLE CHECK
1092462 05/26/2017 SUN COMMUNITY R 49755.90 ACCOUNTS PAYABLE CHECK
1092463 05/26/2017 UNITED WAY OF THE DESERT R 164.00 ACCOUNTS PAYABLE CHECK
1092464 05/26/2017 :GARNISHMENT R 152.00 ACCOUNTS PAYABLE CHECK
1092465 05/26/2017 PS FIRE SAFETY UNIT R 1908.65 ACCOUNTS PAYABLE CHECK
1092466 05/26/2017 GARNISHMENT R 620.50 ACCOUNTS PAYABLE CHECK
1092467 05/26/2017 TRANSAMERICA WORKSITE MAR R 1768.80 ACCOUNTS PAYABLE CHECK
TOTAL FUND 82397.60
TOTAL REPORT 82397.60
Previous Day Wire Report
Company:Palm Springs CA City of Bank of America
Requestor:Ariana Muniz Merrill Lynch
Run Date:06/14/2017 13:12:19 CDT J
As of:05/26/2017
Bank of America,Southern California I XXXX 661
XXXX 2000 1 City of Palm Springs General Acct I USD I As of:05/26/2017
Detail Credits
Incoming Money Transfer Credit 501,875.00 501,875.00 0.00 0.00 00370263546 0000000000
(195)
Incoming Money Transfer Credit 7,577>78 7,577.78 0,00 0.00 00370321238 0000000000?
r(195)
Credit Totals 509,452.78 509,02.78 0.00 0.00
Detail Debits
I'i 10 I II I pl I II I I I I I,I I I I
ICI II� 4jj1'i III I III III III � (Ilfl(II`I dif i,11 lIIV 1�I It I'I IIII I� I I � I I I t�l yyI'���i I �jj id I�
II III II I i i�111�I s�l I I'i III u�.f I
Outgoing Money Transfer Debit(495) 1211635.21 00370050876 0000000000
Outgoing Money Transfer Debit(495) 60,559.38 00370050489 0000000000
Outgoing Money Transfer Debit(495) ✓ 25,449.37 00370035951 0000000000
Outgoing Money Transfer Debit(495) ✓ 19,219.83 00370035952 0000000000
Outgoing Money Transfer Debit(495) ✓ 8,243,75 00370035950 0000000000
Outgoing Money Transfer Debit(495) ✓ r 684.10 00370035949 0000000000
Debit Totals 225,791.64
Totals
Bank Totals
05/26/2017
d (Ir��ll�l'II�I��IT�VY�r'�`f14'I
Total Credits 2 509,452.78
Total Debits 6 225,791.64
Report Totals
05126/2017
RI 'Il
1
Total Credits 2 509,452.78
Total Debits 6 225,791.64
Pagel
Previous Day ACH Report
Company:Palm Springs CA City of Bankof America
Requestor:Ariana Muniz Merrill Lynch
Run Date:06/14/2017 12:23:31 CDT
As of:05/26/2017
Bank of America,Southern California JXXXX 661
XXXX 2000 1 City of Palm Springs General Acd I USD I As of:0 512 612 01 7
Detail Credits
ill
Preauthorized ACH Credit(165) 10,945.48 10,945.48 0.00 0.00 46007808571 0000000000
Preauthorized ACH Credit(165) 5,006:00 5,006.00 0.00 0.00 46007808573 DOOOOOOQOQ
Preauthorized ACH Credit(165) 2,606.00 2,606.00 0.00 0.00 46007808572 0000000000
Preauthorized ACH Credit(165) 1,250,00 1,250.00 0,00 0.00 45016029240 0000000000
Preauthorized ACH Credit(165) 706.00 706.00 0.00 0,00 45014432904 0000000000
Preauthorized ACH Credit(165) 71.00 71.00 0.00 0.00 46007783616 0600006000
Preauthorized ACH Credit(165) 23.00 23.00 0.00 0.00 46007783615 0000000000
Credit Totals 20,607.48 20,607A8 0.00 0.00
Detail Debits
. I��iIInIlili�ll'Il�Yr��� llI I II Iili iPl�III� ��' ��� ��I ,�I�'l'i III��ll�II�I�, '�'illlP�i�' i��' PII �llllpi��ll
Preauthorized ACH Debit(455) r/ 248,394.41 46006881869 0000000000
Preauthorized ACH Debit(455) ✓ 67,420.03 46007226481 0000000000
ACH Settlement Debit(466) v/ 1,015,753.75 46007587633 0000000000
ACH Settlement Debft(466) is 175.00 46013117337 6000000000
Debit Totals ' 1,331,743.19
Totals
Bank Totals
05/26/2017
XXXX
Total Credits 7 20,607.48
Total Debits 4 1,331,743.19
Report Totals
0 512 612 01 7
I
Total Credits 7 20,607.4E
Total Debits 4 1,331,743.19
10
Page 1
Previous Day ACH Report 10
Company:Palm Springs CA City of Merrill
of America-1I
Requestor:ArianaMunir Merrill Lynch
Run Date:06/14/2017 13:16:23 CDT Y
As of:05130/2017
Bank of America,Southern California I XXXX 661
XXXX 2000 1 City of Palm Springs General Acct i USD As of:05/30/2017
Detail Credits
Corporate Trade Payment Credit 262,080.61 262.080.61 0.00 0.00 45014997084 0000000000
(164) _
Preauthorized ACH Credit(165) 39AW58 39 808.58 0.00 0.00 50013521268 0000000000
Preauthorized ACH Credit(165) 9,622.00 9,622.00 0.00 0.00 50015882348 0000000000
Preauthorized ACH Credit(165) 4,497.00 4,497.00 0.00 0.00 50014125742 ` 0000000000
Preauthorized ACH Credit(165) 4,082.00 4,082.00 0.00 0.00 50014163295 0000000000
Preauthorized ACH Credit(165) 3,83100 3,831.00 0.00 0:00 50014192261 ; D000000000
Preauthorized ACH Credit(165) 1,838.57 1,838.57 0.00 0.00 50014125741 0000000000
Preauthorized ACH Credit(165) 1.554.00 1,554.00 0.00 0.00 50010050686 0000000000
Preauthorized ACH Credit(165) 1,142.00 1,142.00 0.00 0.00 50009028316 0000000000
Preauthorized ACH Credit(165) 589,60 589.60 0.00 0.00 50013258917 0000000000
Preauthorized ACH Credit(165) 413.00 413,00 0.00 0.00 50015293255 0000000000
Preauthorized ACH Credit(165) 23.00 23.00 0.00 0.00 50014143223 0000000000
Preauthorized ACH Credit(165) 14.00 14.00 0.00 0.00 50014143342 0000000000
Credit Totals 329,495.36 329,495.36 0.00 0.00
Detail Debits
Preauthorized ACH Debit(455) ✓ 4,599.53 46014810381 0000000000
De bltTotals 4,599,.53
Totals
Bank Totals
05/30/2017
XXX
r
Total Credits 13 329,495.36
Total Debits 1 4,599.53
Report Totals
05/3012017
MAIN;!I III
Total Credits 13 329,495.36
Total Debits 1 4,599.53
Page 1
Ariana Muniz
From: Thomas Hays
Sent: Thursday, May 25, 2017 1:47 PM
To: Sharon Riddle; Rita Gustafson; Dolores Olvera; Ariana Muniz
Cc: Nancy Klukan
Subject: Payroll 052617 Federal and State Tax Payments
Federal:
EnteredPayment Information Data
TaxpayerEIN xxxxx0757
Tax Form 941 Employers Federal Tax
Tax Type`. FederalTaxDeposit
Tax Period Q2/2017
Payment Amount $248,394:41
Settlement Date 05/26/2017
Subcategories:
1 Social Security $223.20
2 Medicare $45,155.08
3 TazlNithholding $203,01213
State:
Payment Submission Date and Time(PST): 5/25/2017 Time: 1:44:24 PM
EDD Employer Identification Number : 80098221
Deposit Schedule : Next bank Day
Pay Date : 05/26/17
SDI Amount : $0.00
PIT Amount: $67,420.03
Total Amount : $67,420.03
Bank Debit Date : 05/26/17
Confirmation Number : 1294966
Thank you,
THOMAS HAYS
Deputy City Treasurer
3200 E.Tahquitz Canyon Way
Palm Springs, CA 92263
(760)323-8223 direct
thomas.hays@palmspringsca.my
1