HomeMy WebLinkAbout24151 RESOLUTION NO. 24151
A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF PALM
SPRINGS, CALIFORNIA, APPROVING PAYMENT OF PAYROLL
WARRANTS FOR THE PERIOD ENDED 11-19-2016 BY WARRANTS
NUMBERED 419730 THROUGH 419749 TOTALING $40,384.99
LIABILITY CHECKS NUMBERED 1088995 THROUGH 1089017
TOTALING $88,170.43, FIVE WIRE TRANSFERS FOR $58,575.66, AND
THREE ELECTRONIC ACH DEBITS OF $1,282,955.97 IN THE
AGGREGATE AMOUNT OF $1,470,087.05, 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 419730 through 419749, liability checks numbered 1088995
through 1089017, 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 18T" DAY OF JANUARY, 2017.
ATTEST: David H. Ready, Esq., P
City Manager
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. 24151 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 18th day of January, 2017, by the
following vote:
AYES: Councilmembers Kors, Mills, Roberts, Mayor Pro Tern Foat, and Mayor Moon
NOES: None
ABSENT: None L"n
ABSTAIN: None p-t-e
Kathleen D. Hart, MMC
Interim City Clerk
Run: Nov 22.2016 4:02:40 PM Print Check List Page 2 of 2
Sorted By: Check Number From: Nov 25, 2016 To: Nov 25,2016
Bank of America Transit: 122000661 Account: 14318DO2000 (' not yet printed)
Check# Amount Check Date Person Code Name Check Type Check Status
419731 1.601.70 Nov 25,2016 15839 Andrade, Jose Computer Check Outstanding
419732 1,686.44 Nov 25, 2016 15905 Castillo,Jorge Computer Check Outstanding
419733 1,595.51 Nov 25,2016 16039 Rodriguez,Annie Computer Check Outstanding
419734 1.996.63 Nov 25,2016 16036 Alvarez, Joshua Computer Check Outstanding
419735 1,823.06 Nov 2E5, 2016 16038 Grucza, Timothy A Computer Check Outstanding
419736 3,025.57 Nov 25. 2016 15121 Lyle, Gregory S Computer Check Outstanding
419737 5,304.94 Nov 26,2016 15980 Nalder, John K Computer Check Outstanding
419738 1,6B1.22 Nov 25,2016 16D37 Youngberg,William A Computer Check Outstanding
419739 1,587.60 Nov 215, 2016 10993 Huskey,Zachary B Computer Check Outstanding
419740 2,023.78 Nov 25. 2016 15222 Hernandez, Francisco Computer Check Outstanding
419741 1,787.21 Nov 215,2016 04905 Leon,Arnulfo H Computer Check Outstanding
419742 2.982.60 Nov 25,2016 10253 Mercado, Gilbert R Computer Check Outstanding
419743 1.12 Nov 25,2016 15515 De La Rosa, Jaime Computer Check Outstanding
419744 1,753,54 Nov 25,2016 15968 Chavez,Aris 0 Computer Check Outstanding
419745 2,224.70 Nov 25,2016 15156 Menley. Charles A Computer Check Outstanding
419746 2,831,99 Nov 25, 2016 15697 Doherty Alexander Computer Check Outstanding
419747 788.99 Nov 25, 2016 15833 Waits, Noe! Computer Check Outstanding
419748 1,06.77 Nov 25, 2016 16041 Chavez, Daisy Computer Check Outstanding
419749 376.01 Nov 25, 2016 16040 Grajeda, Crystal Computer Check Outstanding
Total#Checks Reported: 19
Total Check Amount Reported:$36,659.38
i
i
it
I
I
i
Run: Nov 10, 2016 9'.13-34 AM Print Check List Page 2 of 2
Soiled By: Check Number From: Nov 10, 2016 To: Nov 10, 2016
Bank of America Transit: 122000661 Account 14318D82000 _ (' not yet printed) _
Check# Amount Check Date Person Code Name Check Tyne Check Status
419730' 3,825.61 Nov 10,2016 16007 Thomas, Sheila Y Computer Check Outstanding
Total#Checks Reported:1
Total Check Amount Reported:$3,825.61
SUNGARD PENTAMATION - FOND ACCOUNTING MANAGER PAGE NUMBER: 1
DATE: 11/23/16 CITY OF PALM SPRINGS ACCTPA21
TIME: 11:23:07 CHECK REGISTER INCLUDING SYSTEM VOIDS ACCOUNTING PERIOD: 5/17
'SELECTION CRITERIA: chkstat.[ ndate='11/25/2016'
DISTRIBUTION FUND: 001
CHECK NUMBER ISSUE DATE VENDOR STATUS TOTAL DESCRIPTION
1088995 11/25/2016 AMERICAN GENERAL R 429.09 ACCOUNTS PAYABLE CHECK
1088996 11/25/2016 EMPLOYMENT DEVELOPMENT DE R 93.10 ACCOUNTS PAYABLE CHECK
1088997 11/25/2016 KANSAS PAYMENT CENTER R 284.50 ACCOUNTS PAYABLE CHECK
1088998 11/25/2016 GARNISHMENT R 1221.69 ACCOUNTS PAYABLE CHECK
1088999 11/25/2016 GARNISHMENT R 300.00 ACCOUNTS PAYABLE CHECK
1089000 11/25/2016 AFLAC R 120.45 ACCOUNTS PAYABLE CHECK
1089001 11/25/2016 DAVEY ADMIN GROUP R 6944.22 ACCOUNTS PAYABLE CHECK
1089002 11/25/2016 FIRE MANAGEMENT ASSOCIATI R 405.00 ACCOUNTS PAYABLE CHECKi,
1089003 11/25/2016 FRANCHISE TAX BOARD R 884.69 ACCOUNTS PAYABLE CHECK
1OB9004 11/25/2016 LIBERTY MUTUAL INSURANCE R 1258.86 ACCOUNTS PAYABLE CHECK
1089005 11/25/2016 MANAGEMENT ASSN OF PALM S R 956.25 ACCOUNTS PAYABLE CHECK
1089006 11/25/2016 PALM SPRINGS FIREMENS ASS R 1208.74 ACCOUNTS PAYABLE CHECK
1089007 11/25/2016 POLICE OFFICERS' ASSOCIAT R 9534.23 ACCOUNTS PAYABLE CHECK
1089008 11/25/2016 RIVERSIDE COUNTY SHERIFF R 577.97 ACCOUNTS PAYABLE CHECK
1089009 11/25/2016 SEIU LOCAL 721 CTW AND C R 2492.00 ACCOUNTS PAYABLE CHECK
1089010 11/25/2026 STATE DISBURSEMENT UNIT R 2198.77 ACCOUNTS PAYABLE CHECK
1089011 11/25/2016 SUN COMMUNITY R 54409.51 ACCOUNTS PAYABLE CHECK
1089012 11/25/2016 UNITED WAY OF THE DESERT R 166.00 ACCOUNTS PAYABLE CHECK
1089013 11/25/2016 GARNISHMENT R 152.00 ACCOUNTS PAYABLE CHECK
1089014 11/25/2016 PS FIRE SAFETY UNIT R 21"-40 ACCOUNTS PAYABLE CHECK
1089015 11/25/2016 GARNISHMENT R 620.50 ACCOUNTS PAYABLE CHECK
1089016 11/25/2016 STATE OF CA FRANCHISE TAX R 121.21 ACCOUNTS PAYABLE CHECK
1OB9017 11/25/201G TRANSAMERICA WORKSITE MAR R 1594.25 ACCOUNTS PAYABLE CHECK
TOTAL FUND 88170.43
TOTAL REPORT 88170.43
Previous Day Wire Report 70 Company:Palm Springs CA City of Bank of America-10-pl
Requestor:Adana Muniz
Run Date:01/10/2017 17:24:32 CST Merrill Lynch
As of.,11/25/2016
Bank of America,Southern California 1122000661
xxxxxx 2000 1 City of Palm Springs General Acct I USD As of. 1112512016
Detail Credits
Incoming Money Transfer Credit 16,531.25 16,531.25 0.00 0.00 00370484014 0000000000
(195)
-,N
Detail Debits
Outgoing Money Transfer Debit(495) 28,089.96 00370296959 0000000000
Outgoing Money Transfer Debit(495) 17,969.83 00370296962 0000000000
Outgoing Money Transfer Debit(495) 7,431.25 00370296961 0000000000
Outgoing Money Transfer Debit(495) 2,859.86 00370296960 0000000000
A
Totals. 1 llebli
�'-'�'56;350.90
Totals
Bank Totals
11125/2016
Total Credits 1 16,531.25
Total Debits 4 56,350.90
Report Totals
11/2512016
Total Credits 1 16,531.25
Total Debits 4 56,350.90
Page I
CRO1220 DIRECT BANK OF AMERICA, N.A. PAGE 1
SITE: TX ACH SERVICES DATE/TIME: 11/22/16 18:56:00
BATCH CONTROL AND REJECTED ITEMS RECAP - CONFIDENTIAL �•
RTN: 122000030 ACCT #: 00000001431882000
POINT: CIPSPRINI ORIGIN I➢: 19560D0757 ORIGIN NAME: CITY OF PALM SPRINGS FILE ID MOD: A
APPL: CIPSPRINI CO ID: 1956DO0757 CO NAME: CITY OF PALM SPR ENTRY DESC: PAYROLL SEC: PPD EFF DATE: 11/25/16
TYPE: FILE #: 1632?004486 BATCH #: 0000001 CO DISC DATA:
REJECTED ITEMS
------------------------------------------------------------------------------------------------------------------------------------
TRACE NUMBER TC RUN ACCOUNT NUMBER AMOUNT INDIVIDUAL ID INDIVIDUAL NAME
------------------------------------------------------------------------------------------------------------------------------------
REJECT REASON
____________________________________________________________________________________________________________________________________
THERE ARE NO REJECTED ITEMS FOR THIS BATCH
BATCH TOTALS ________________DEBITS__________________ _________________CREDITS_________________
SETTLEMENT DATE # ITEMS # ADDENDA AMOUNT # ITEMS # ADDENDA AMOUNT
11/25/16 0 0 .00 499 0 972,305.76
TOTAL 0 0 .00 497 0 972,505.75
TOTAL SUBMITTED 0 0 .00 497 0 972,505.76
TOTAL REJECTED D 0 .00 0 0 .00
TOTAL PROCESSED 0 0 .00 499 0 972,505.76
��� END OF REPORT ���
Previous Day ACH Report Comp Bank of America'w�Company:ny:Palm Springs CA City of
Requestor:Adana Muniz Merrill Lynch
Run Date:01110/2017 15:55:25 CST Y
As of:1112 512 01 6
Bank of America,Southern California 1122000661
XWCM2000 I City of Palm Spdngs General Acct I USD I As of: 11/2512016
Detail Credits
Preauthorized ACH Credit(165) 16,934.45 16,934.45 0.00 0.00 30010132038 0000000000
Preauthorized ACH Credit(165) 2,446.00 2,446.00 0.00 0.00 30010132040 0000000000
Preauthorized ACH Credit(165) 1,267.00 1,267.00 0.00 0.00 30010532503 0000000000
Preauthorized ACH Credit(165) 907.00 907.00 0.00 0.00 30010132039 0000000000
Preauthorized ACH Credit(165) 708.00 708.00 0.00 0.00 30009628921 0000000000
Preauthorized ACH Credit(165) 706.00 706.00 0.00 0.00 30007704781 0000000000
Preauthorized ACH Credit(165) 504.90 504.90 0.00 0.00 27011518756 0000000000
Preauthorized ACH Credit(165) 141.00 141.00 0.00 000 30010108535 0000000000
Preauthorized ACH Credit(165) 15.50 15.50 0.00 0.00 30010108746 0000000000
redd Totals' , 236$�.)35 I "5z43;629.85 0.00
Detail Debits
� ' I fill I III I III, �I�I II I�i
Preauthorized ACH Debit(455) 5,974.061 28008862268 0000000000
Preauthorized ACH Debit(455) 1,878.64 30007796663 0000000000
ACH Settlement Debit(466) 972,330.76 30010466414 0000000000
ACH Settlement Debit(466) 175.00 J 30014637462 0000000000
1 777,-
`Debit Totals 980,358 48'+;
Totals
Bank Totals
1112 512 01 6
Total Credits 9 23,629.85
Total Debits 4 980,358.46
Report Totals
1112MO16
Total Credits 9 23,629.85
Total Debits 4 980,358.46II
Page 1
Previous Day ACH Report BBnkOfAmerlca���Company:Palm Springs CA City of
Requestor:Ariana Muniz Merrill Lynch
Run Data:01/1 012017 1 7:05:54 CST y
As of:11/2812016
Bank of America,Southern California(122000661
xxxxzx 2000 1 City of Palm Springs General Aoot I USD As of: 11/28/2016
Detail Credits
--
Corporate Trade Payment Credit 405,303.48 405,303.48 0.00 0.00 30009412978 0000000000
(164) _
Preauthorized ACH Credit(166) 19,832,00. 19,832.00 0.00 0.00 33011832506 0000000000
Preauthorized ACH Credit(165) 18.118.00 18,118.00 0.00 0.00 33011582926 0000000000
Preauthorized ACH Credit(165) 7,000.00 7,000.00 0.00 0.00 33011551716 0000000000
Preauthorized ACH Credit(165) 3,936.00 3,936.00 0.00 0.00 33010548943 0000000000
Preauthorized ACH Credit(165) 589.00 589.00 0.00 0.00 33011535547 0000000000
Preauthorized ACH Credit(165) 328.00 328.00 0.00 0.00 30015391785 0000000000
Preauthorized ACH Credit(165) 20.00 20.00 0.00 0.00 33009622980 0000000000
Preauthorized ACH Credit(165) 9.00 9.00 0.00 0.00 33011565567 0000000000
77
Credit Totals' : = 45�13A6 455135.48 . �r 0,00 :I 0.06
Detail Debits
Preauthorized ACH Debit(455) r/ 241.891.13 30012985864 0000000000
Preauthorized ACH Debit(455) �/ 67,924.33 33007494065 OOOOOOOODO
Preauthorized ACH Debit(455) 2,224.76 30012208845 0000000000
-a)abitTotals ? g 312'040.22
Totals
Bank Totals
1112 812 01 6
Total Credits 9 455,135.48
Total Debits 3 312,040.22
Report Totals
11/28/2016 -
Total Credits 9 455,135.48
Total Debits 3 312,040,22
Page 1 -
Fed:
Payment Information Entered Data
Taxpayer EIN xxxxx0757
Tax Form 941 Employers Federal Tax
Tax Type Federal Tax Deposit
Tax Period W016
Payment Amount $241.891.13
Settlement Data 1112WO16
Subcategories:
1 Social Security 1$245.52
2 MMlure $43.814.57
3 To lMthkolding $197.831.04
ST
Stab Disability lnsuranee(SD4 Tax and California Personal Income Tax(PIT)
EDD Employer Identification Number:80098221
Bank Account: — 000
Bank Debit
Deposit Schedule Pay Date SDI Amount PIT Amount TotalAmonat Date Confirmation Numb" �
Nwb.kDW 1125)16 50.00 $67.924.33 $67,924.33 1128/16 594027
Robert BurkMlder,Accountant,CCMT I fieparmicnt of Finance S,Treasury
City of Palm Springs 132aa E.Tahauita canyon Way,Palm Springs,CA 92262
Office:760.323.e223 I Fax:760.322.e320 I Email:RoberteurkhdderOpalmmiji aso am
416ase tots City?falf is open 911onAy-4lwrSday 8am-6pm-Cferudon THWays at this time
PkasemnadertheemrbmmrntbeforepriMkgtaisemaN A
Fed:
Payment Information Entered Data
Taxpayer EIN xxxxx0757
Tax Form 941 Employees Federal Tax
Tax Type Federal Tax Deposit
Tax Period Q42016
Paymat Amount S5,974.06
Settlement Date 11252016
Subcategories:
2 Medicare S526.80
3 Tax Withholding S5,447.26
ST..
State Disability Insurance(SDI)Tax and California Personal Income Tax(PIT)
EDD Employer Identification Number:
80098221
Bank Account:
— 2000
Bank Debit
Deposit Schedule Pry Date SDI Amount PTCAmount TohlAmount Date Confirmation Number
NmbaokDry 11,13/16 $0.00 S1,878.64 $1.878.64 1125/16 592599
Robert Burkholder,Atmunlant,CCMT I Daartmer t of Finance&Treasury
City of Palm Springs 13208 E.TahquitE Canyon Way,Palm Springs,CA 92262
Office:760.323.8223 I Fax 760.322.8320 I Emil:Robert BuDholderOoalmspnnosa.pw
4T=e note City 7dalffs open Monday-4hltrsrday Sam-6pm-Cdose6on rptflays at this time
Picric mmider the emtronmem before printing thls em.1186
Fed:
xv"eWrEYR 'XJOOX0757�' ._
Tax Farm 941 Employers Federal Tax
Tax7ype' Fetkisl Tax Deposit j
Frax padaa 0 616
'paymelltAmWnl 547446
ISemement Date 11n42016
�.Subykdeep`�iba-
4 a�edlpan; *30.72
�J Ta%lyBhhWdkrp= ' .5943.74
EDD Employer Identification Number: 8009B221
Bank Aeeount: --2000
BaukDebit
Deposit Schedule Pay Date SDI Amount Prr Amount TotalAmount Date Confirmation Number
Nmbak Dry 11/10/16 $0.00 516029 $160.29 11/14/16 552947
Robert Burkholder,Accountant,CCMT I Departmimt of Finance&Treasury
City of Palm Springs 13200E.Tah0uitz Canyon Way,Palm Spring;CA 92262
Offioe:760323.e223 I Fax:760.322.8320 l Email:RobertiturkholderOoalrmpdnosa.uw
Tiease oats City 7faff is open 611ond4y-'minraday 8am-6pm-C6sedon 4'tidays at this time
Pkase amseler the emr...t before Prhrtina this EMAI 3