HomeMy WebLinkAbout24327 RESOLUTION NO. 24327
A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF
PALM SPRINGS, CALIFORNIA, APPROVING PAYMENT
OF PAYROLL WARRANTS FOR THE PERIOD ENDED 10-
07-2017 BY WARRANTS NUMBERED 420091 THROUGH
420104 TOTALING $23,724.36 LIABILITY CHECKS
NUMBERED 1095041 THROUGH 1095060 TOTALING
$79,717.11, FIVE WIRE TRANSFERS FOR $64,954.50,
AND THREE ELECTRONIC ACH DEBITS OF
$1,353,292.33 IN THE AGGREGATE AMOUNT OF
$1,521,688.30, 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 420091 through 420104, liability checks
numbered 1095041 through 1095060, 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 15T" DAY OF NOVEMBER, 2017.
David H. Ready, Esq., P .
City Manager
ATTEST:
tid
hony J MC
City Clerk
Resolution No. 24327
Page 2
CERTIFICATION
STATE OF CALIFORNIA )
COUNTY OF RIVERSIDE ) ss.
CITY OF PALM SPRINGS )
I, ANTHONY J. MEJIA, City Clerk of the City of Palm Springs, hereby certify that
Resolution No. 24327 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 15th day of
November, 2017, by the following vote:
AYES: Councilmembers Kors, Mills, Roberts, Mayor Pro Tern Foat, and
Mayor Moon
NOES: None
ABSENT: None
ABSTAIN: None
IN WITNESS WHEREOF, I have hereunto set my hand and affixed the official
seal of the City of Palm Springs, California, this 2 + day of
2cit
1 --
v
Anthony J. p ,
City Clerk
�p
Print Check fist
Execution #xxx 098
Function:RPCH
Ruh By-SHARONR
Run Start Date:Oct 12,201710:16.49 AM
Payroll Bank Aceaunt;xxxxx 661,xxxxxx 2000
From Pay issue Date:Oct 13,2017
To Pay Issue Date:Oct 13,201?
Included Printed:Yes
Include ilnjprinted:Yes
Inululle Yo dcd:Yes
include Cleared:
Include titan in0:Yes
Include ReconulIed:
Include V Id Checks Only:
Sort By:Check Number
User COPIn ent:
x�ciitkin#p(098 run by SNAF,ONR using RPH.ippc- Qraparez!by ePersnaiity 5U W Q5.
Run:Oct 12,2017 1016;49 AAA Print Check List Page 2 of 2
Sorted 8y:Check Number from:Oct 13,?017 To.`0013,2017
Bank o01
f AMe!tk Trans#1 XXXXX6s1 AG�ount XXxXXX 2000 �`not yea printed)
Check# AD= Check Date Person Gode Ran Check Tj: C taus
420091 1,417.63 Od 13,2017 15839 And Jose Computer Check Outstanding
420092 1,470.42 Oct 13 2017 15905 Castillo,Jorge Computer Check 1JtltstatLdinO
420093 1,092.98 0013,1611 16099 Garcia,John Computer Check t staniiing
420094 1.909.73 Oct 13,2017 15784 Richards,Tabifha Computer Cho* Ou�tand ng
426095 31,374.43 Oct 13,2017 16100 Pendleton,Marla Computer Check Outstanding
420096 1,378.04 Oct 13.2017 10993 Huskey,Zachary 6 CornputBi Cho r (tag
420097 1,329.74 Oct 13,2017 15222 Hernandez,Francisco ComputerCheck a3ut$tat�ding
*0098 1,414.A5 Oct 13,2017 04WS Leon,Amulfo H Computer Check OuteAapd.lng
420099 2,014 00 Oct 13,2017 10263 Mercarta,Gilbert R Computer Check Oundn�
d24140 1,919:95 Oct 13,2017 1.5166 Manley,Charles A Computer Check C ?end g
424141 2,632.87 Oct 13,2017 16098 Sandoval,Kristin Computer Check OutstaWing
420102 1,762.61 Oct 13,2017 15833 WaU Noel Computer Ch
42 eek Outs#an"di►ig
0103 643.37 Oct 13,2017 16089 Halm,Mikael Computer Check Outst�tndDng
420104 956:14 Oct 13,2017 16097 Galloway,Patin Computer Chook, Outa"aft,
Total#Cheeks Reported:14
Total Check Amount Reported.$2$,724.36
£Xecwtion#XX 098 run by SHARONR using RPCH.46ox P,nepared ty5 ei?ersana 4 ra0 OD},S}5 „..
SUNGARD PENTAMATION - FUND ACCOUNTING MANAGER PAGE NUMBER: 1
DATE: 10/12/17 CITY OF PALM SPRINGS ACCTPA21
TIME: 09:41:42 CHECK REGISTER INCLUDING SYSTEM VOIDS ACCOUNTING PERIOD: 4/18
SELECTION CRITERIA: chkSLat.rundate='10/13/2017'
DISTRIBUTION FUND: 001
CHECK NUMBER ISSUE DATE VENDOR STATUS TOTAL DESCRIPTION
1095041 10/13/2017 AMERICAN FIDELITY ASSURAN R 581.57 ACCOUNTS PAYABLE CHECK
1095042 10/13/2017 EMPLOYMENT DEVELOPMENT DE R 93.10 ACCOUNTS PAYABLE CHECK
1095043 10/13/2017 KANSAS PAYMENT CENTER R 284.50 ACCOUNTS PAYABLE CHECK
1095044 10/13/2017 GARNISHMENT R 1008.46 ACCOUNTS PAYABLE CHECK
1095045 10/13/2017 AFLAC R 120.45 ACCOUNTS PAYABLE CHECK
1095046 10/13/2017 DAVEY ADMIN GROUP R 10149.64 ACCOUNTS PAYABLE CHECK
1095047 10/13/2017 FIRE MANAGEMENT ASSOCIATI R 472.50 ACCOUNTS PAYABLE CHECK
1095048 10/13/2017 FRANCHISE TAX BOARD R 100.00 ACCOUNTS PAYABLE CHECK
1095049 10/13/2017 LIBERTY MUTUAL INSURANCE R 1244.49 ACCOUNTS PAYABLE CHECK
1095050 10/13/2017 MANAGEMENT ASSN OF PALM S R 1016.25 ACCOUNTS PAYABLE CHECK
1095051 10/13/2017 PALM SPRINGS FIREMENS ASS R 1808,40 ACCOUNTS PAYABLE CHECK
1095052 10/13/2017 POLICE OFFICERS' ASSOCIAT R 8230.7E ACCOUNTS PAYABLE CHECK
1095053 10/13/2017 RIVERSIDE COUNTY SHERIFF R 75.00 ACCOUNTS PAYABLE CHECK
1095054 10/13/2017 SEIU LOCAL 721 CTW AND C R 2571.00 ACCOUNTS PAYABLE CHECK
1095055 10/13/2017 SUN COMMUNITY R 47233.33 ACCOUNTS PAYABLE CHECK
1095056 10/13/2017 UNITED WAY OF THE DESERT R 169.00 ACCOUNTS PAYABLE CHECK
1095057 10/13/2017 GARNISHMENT R 152.00 ACCOUNTS PAYABLE CHECK
1095058 10/13/2017 PS FIRE SAFETY UNIT R 2030.15 ACCOUNTS PAYABLE CHECK
1095059 10/13/2017 GARNISHMENT R 620.50 ACCOUNTS PAYABLE CHECK
1095060 10/13/2017 TRANSAMERICA WORKSITE MAR R 1756.01 ACCOUNTS PAYABLE CHECK
TOTAL FUND 79717.11
TOTAL REPORT 79717.11
Previous Day Wire Report
Company:Palm Springs CA City of Wi nkofAmed+ea' RIF
Requestor:Ariana Muniz Merrill lymch
Run Date:11106/201713:59:01 CST
As of:1 OM 312 01 7
Bank of America,Southern California IXXXX 661
XXXX 20001 City of Palm Springs General Accl I USD I As of.1 011 31201 7
Detail Debits
Outgoing Money Transfer Debit(495) / 27,506.03 00370026585 0000000000
Outgoing'Money Transfer Debit{495) ✓ 21:,440,66 00370026579 0000000000
Outgoing Money Transfer Debit(495) ✓ 8,900.00 00370026581 0000000000
Wpin Money Transfer Deb-it it(495) ✓ 684.10 �00370026577 00o00,00000 ,
Individual Auto Transfer DR(501) 100,000.00 00680002052 1713083015
peb�t Totals 156 b30 79
.:.i..i��........W.a.___'
Totals
Bank Totals
10/1312017
xxxx
Total Credits 0 0.00
Total Debits 5 158,530.79
Report Totals
10/1312017
Total Credits 0 0.00
Total Debits 5 158,530.79
ka
Page 1
Previous Day ACH Report +
Company:Palm Springs CA City of Ranka'�At�et7Ca
Requestor:Ariana Muniz Merritt Lynch
Run Date: 11106/2017 14:17:51 CST
As of:10/1612017
Bank of America,Southern California I XXXX 661
XXXX 2000 1 City of Palm Springs General Acct USD i As of:10/16/2017
Detail Credits
Preauthorized ACH Credit(165) 553,772.66 553,772.66 0.00 0.00 86006730115 0000000000
Preauthorized ACH Credit(165) 9,829.00 9,829.00' G 0.00 0.00 169009501 00000000601
Preauthorized ACH Credit(165) 6,746.00 6,746.00 0.00 0.00 89008116907 0000000000
Preauthor ied ACH Credit(165), 5,020.00 5,920.01 0,00. 0.00 89008155369. 0000000000
Preauthorized ACH Credit(165) 2,84B.33 2,848.33 0.00 0.00 86007365550 0000000000
Preauthor(zed ACH Credit(165) 2,207,00 " 2,207.W 0.00 0.00 89009133405 0000000000
Preauthorized ACH Credit(165) 1,316.00 1,316.00 0.00 0.00 89008116906 0000000000
Preauthorized ACH Credit(165) 931.00 931.00 0.00 0.00 69003541$9$ 0000,00,0000
Preauthorized ACH Credit(165) 419.00 419.00 0.00 0.00 89007302671 0000000000
Preauthorized ACH Credit(165) 269.00 269'00 0.00 0.00 89 00809161 9 0000000D00'+
Preauthorized ACH Credit(165) 41 40.00 0.00 0.00 89007302672 0000000000
Preauthorized ACH Credit(165); W25 16.25. 0,00 0.00 89008091811 O000000000.i
Credlt7otals •- 584,314.24 584,314 24, 0 Q0 0:00 ti
i,.... i'
Detail Debits
Preauthorized ACH Debit(455) 6,423.71 86010295224 0000000000
Debit Totals i ` 6,423 77 a
7r ri
Totals
Bank Totals
1011612017
XXXX 31101,111
Total Credits 12 584,314.24
Total Debits 1 6,423.71
Report Totals
10/16/2017
Total Credits 12 684,314.24
Total Debits 1 6,423.71
Page 1
Previous Day ACH Report
Company:Palm Springs CA City of Son0o Amedea
Requestor:Ariana Muniz Lynch
.
Run Date:1110612017 1 3:56:12 CST @I"t`�ll -
As of:IOM312017
Bank of America,Southern California I XXXX 661
XXXX 20001 City of Palm Springs General Acct i USD As of:10/13/2017
Detail Credits
Preauthorized ACH Credit(165) 24,234.49 24,234.49 0.00 0.00 86004016607 0000000000
Preauthorized ACH Credit(165) 6,155 00 6,155,00: O.W. 0.00 86004016609 000000'0000
Preauthorized ACH Credit(165) 1,507.00 1.507.00 0.00 0.00 86004016608 0000000000
Preauthorized ACH Credit(165) 1 111.,13TO0 1,137.00; O.DO 0,00 ,85011784851 0000000000
Preauthorized ACH Credit(165) 952.90 952.90 0.00 0.00 85010057423 0000000000
Preauthorized ACH Credit(16$) 385.U0 385:00 0:00 O;DO, $6003991567 ! 000 000000
Preauthorized ACH Credit(165) 185.00 185.00 0.00 0.00 86003991471 0000000000
Preauthorized ACH Credit(155) 33 85 33.85 0.00 _0.00 86003991666 OOODODOODO
Credit Totals 34 590.24 34,590 24' DOD
Detail Debits
Preauthorized ACH Debit(455) 251,996.57/86003275828 0000000000
Preauthorized ACH Debit(455)' Ff,933.77 '✓86003365207 DOOOODOD00
ACH Settlement Debit(466) 1,033,597.94 ✓86003784140 0000000000
ACH Settlement Debit(466) 17500 ✓. 8600913.5398 00000D0000
Debit Togls ,352 7D38
Totals
Bank Totals
1011312017
XX
ICI li� !
Total Credits 8 34,590.24
Total Debits 4 1,352,70328
Report Totals
10f1312017
Total Credits 8 34,590.24
Total Debits 4 1,352,703.28
Page 1
Ariana Muniz
From: Thomas Hays
Sent: Thursday,October 12, 2017 2:06 PM
To: Sharon Riddle; Dolores Olvera;Ariana Muniz; Rita Gustafson
Subject: Payroll 101317 Federal and State Tax Payments
Federal:
EnteredPayment Information Data
T"Payer M jN=0767
Tax Form 941 Employers Federal Tax
Tax Type .,Federal Tax Deposit
Tax Period f20i7
PAyrrlent lunount 99fi.�a7
Settlement Date 1011312U1T
Sulaeategpries:
'2 ihedlc�r� ;�5,88�0;75
3 fax ft.' holding S205,892.62
State:
Confirmation Number: 1787734
Payment Status:Scheduled
Payment Submission Date and Time(PST) : 10/12/2017 01:54:05 PM
EDD Employer Identification Number :80098221
Deposit Schedule: Next bank Day
Pay Date :10/13/17
SDI Amount :$0.00
PIT Amount:$66,933.77
Total Amount:$66,933.77
Bank Debit Date: 10/13/2017
Regards,
THOMAS HAYS
Deputy City Treasurer
3200 E.Tahquitz Canyon Way
Palm Springs,CA 92263
(760)323-8223 direct
thomas.hays@palmspdngsca.gov
i
Ariana Muniz
From: Thomas Hays
Sent: Monday, November 06, 2017 11:49 AM
To: Sharon Riddle; Dolores Olvera;Ariana Muniz; Rita Gustafson
Cc: Marla Pendleton
Subject: RE: Payroll 101317 Federal and State Tax Payments
Importance: High
Good morning,
An error was made in the calculation of the taxes paid to the State for the 10/13/17 pay date.The amount paid was
$66,933.77, as indicated in my 10/12/2017 email.
Instead, $67,522.82 should have been paid to the State. Resultantly,the tax was underpaid by$589.05.The correcting
payment was submitted to the State today, as indicated below:
-------------------
Confirmation Number: 1872076
Payment Status:Scheduled
Payment Submission Date and Time [PST) : 11/6/2017 11:19:21 AM
EDD Employer Identification Number:80098221
Deposit Schedule: Next bank Day
Pay Date :10/13/17
SDI Amount:$0.00
PIT Amount :$589.05
Total Amount:$589.05
Bank Debit Date : 11/7/2017
-------------------
Additionally,a Journal Entry has been prepared to correct the GL and is dated for 11/1/17. Please let me know if there
are any questions or concerns.
Respectfully,
THOMAS HAYS
Deputy City Treasurer
3200 E.Tahquitz Canyon Way
Palm Springs, CA 92263
(760)323-8223 direct
thomas.haysAoalmsprincisca.gov
From:Thomas Hays
Sent:Thursday, October 12, 2017 2:06 PM
To:Sharon Riddle<Sharon.Riddle@palmspringsca.gov>; Dolores Olvera<Dolores.Olvera@oalmspringsca.gov>;Ariana
Muniz<Ariana.Muniz@ pal mspringsca.gov>; Rita Gustafson<Rita.Gustafson@Palmspringsca.gov>
Subject: Payroll 101317 Federal and State Tax Payments
Federal:
i y
EnteredPayment Intormation Data
Tav*Yer 6IN =W0757
Tax Form 944 Emp[ayers Federal Tax
Tax Type Federal Tax0epoi3ft
Tax period OW017
payment Amoun( 1S�.;xJ9C,5�
Settlement gate 10t93t2O17
Subcateg�rios:
f SopalSeCPtjr:` 320'
7 tdtadicpre45,880.7$
Tax Wrtlr6otdttt2t#539 tt2
State:
Confirmation Number: 1787734
Payment Status:Scheduled
Payment Submission Date and Time(PST) : 10/12/2017 01:54:05 PM
EDD Employer Identification Number:80098221
Deposit Schedule : Next bank Day
Pay Date : 10/13/17
SDI Amount :$0.00
PIT Amount :$66,933.77
Total Amount:$66,933.77
Bank Debit Date: 10/13/2017
Regards,
THOMAS HAYS
Deputy City Treasurer
3200 E.Tahquitz Canyon Way
Palm Springs,CA 92263
(760)323-8223 direct
thomas.hays(dwalmspringsca.00v
2 - -