HomeMy WebLinkAbout24132 RESOLUTION NO. 24132
A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF PALM
SPRINGS, CALIFORNIA, APPROVING PAYMENT OF PAYROLL
WARRANTS FOR THE PERIOD ENDED 10-22-2016 BY WARRANTS
NUMBERED 419705 THROUGH 419716 TOTALING $20,212.96
LIABILITY CHECKS NUMBERED 1088460 THROUGH 1088479
TOTALING $85,651.06, FIVE WIRE TRANSFERS FOR $58,361.16, AND
THREE ELECTRONIC ACH DEBITS OF $1,372,791.61 IN THE
AGGREGATE AMOUNT OF $1,537,016.79, 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.
Geoffrdy`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 419705 through 419716, liability checks numbered 1088460
through 1088479, 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 16T" DAY OF NOVEMBER, 2016.
ATTEST: David H. Ready, City M
ames Thompson, City Clerk
CERTIFICATION
STATE OF CALIFORNIA )
COUNTY OF RIVERSIDE ) ss.
CITY OF PALM SPRINGS )
I, JAMES THOMPSON, City Clerk of the City of Palm Springs, hereby certify that
Resolution No. 24132 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 16th day of November, 2016, by
the following vote:
AYES: Councilmember Foat, Councilmember Kors, Councilmember Roberts, and
Mayor Moon.
NOES: None.
ABSENT: Mayor Pro Tern Mills.
ABSTAIN: None.
es Thompson, City Clerk
City of Palm Springs, California f
SUNGARD PENTAMATION - FUND ACCOUNTING MANAGER PAGE NUMBER: 1
DATE: 10/27/16 CITY OF PALM SPRINGS ACCTPA21
TIME: 11:21:52 CHECK REGISTER INCLUDING SYSTEM VOIDS ACCOUNTING PERIOD: . 4/17
SELECTION CRITERIA: chkstat.rundate='10/26/2016'
DISTRIBUTION FUND: 001
CHECK NUMBER ISSUE DATE VENDOR. STATUS TOTAL DESCRIPTION
1068460 10/28/2016 AMERICAN GENERAL R 429.09 ACCOUNTS PAYABLE CHECK
1088461 10/28/201G EMPLOYMENT DEVELOPMENT DE R 93.10 ACCOUNTS PAYABLE CHECK
1086462 10/28/2016 GARNISHMENT R 1221.69 ACCOUNTS PAYABLE CHECK
1088463 10/28/2016 GARNISHMENT R 300.00 ACCOUNTS PAYABLE CHECK
1OBB464 10/28/2016 AFLAC R 120.45 ACCOUNTS PAYABLE CHECK
10884GS 10/28/2016 DAVEY ADMIN GROUP R 6944.22 ACCOUNTS PAYABLE CHECK
1088466 10/28/2016 FIRE MANAGEMENT ASSOCIATI R 405.00 ACCOUNTS PAYABLE CHECK
1088467 10/28/2016 FRANCHISE TAX BOARD R 617.82 ACCOUNTS PAYABLE CHECK
1088468 10/28/2016 LIBERTY MUTUAL INSURANCE R 1258.34 ACCOUNTS PAYABLE CHECK
1088469 20/28/201G MANAGEMENT ASSN OF PALM S R 941.25 ACCOUNTS PAYABLE CHECK
1088470- 10/28/2016 PALM SPRINGS FIREMENS ASS R 1208.74 ACCOUNTS PAYABLE CHECK
1OBB471 10/28/20IG POLICE OFFICERS' ASSOCIAT R 9629.43 ACCOUNTS PAYABLE CHECK
1088472 10/28/2016 RIVERSIDE COUNTY SHERIFF R 1905.67 ACCOUNTS PAYABLE CHECK '
1088473 10/28/2016 SEIU LOCAL 721 CTW AND C R 2492.00 ACCOUNTS PAYABLE CHECK
l OBB474 10/28/2016 SUN COMMUNITY R 53354.11 ACCOUNTS PAYABLE CHECK
1088475 10/28/2016 UNITED WAY OF THE DESERT R 166.00 ACCOUNTS PAYABLE CHECK
1OB-B476 10/28/201G :GARNISHMENT R 152.00 ACCOUNTS PAYABLE CHECK
1088477 10/28/2016 PS FIRE SAFETY UNIT R 2197.40 ACCOUNTS .PAYABLE CHECK
108847E 10/28/2016 GARNISHMENT R 620.50 ACCOUNTS PAYABLE CHECK
1088479 10/28/2016 TRANSAMERICA WORKSITE MAR R 1594.25 ACCOUNTS PAYABLE CHECK
TOTAL FUND' 85651.06
TOTAL REPORT85651.06
t VAL
C <�
w
' C'�lrnFH�p
Print Check List
Execution # 108657
Function:RPCH
Run By:SHARONR
Run Start Date:Oct 26, 2016 4:00:35 PM
Payroll Bank Account: 122000661, 1431 BD82000
From Pay Issue Date:Oct 28, 2016
To Pay Issue Date:Oct 28, 2016
Included Printed:Yes
Include Unprinted:Yes
Include Voided:Yes
Include Cleared:
Include Outstanding:Yes
Include Reconciled:
Include Void Checks Only:
Sort By:Check Number
User Comment:
Execution#108657 run by SHARONR using RPCH.docx-20141008 Prepared by ePersonality 4.50.00.05
Run: Oct 26,20164:00:35 PM - Print Check List Page 2 of 2
Sorted By: Check Number From Oct 28,2016 To:Oct 28 2016
Bank of America Transit: 122000661 Account: 14311iD82000 (*not yet printed)
Check# ' Amount Check Date Person Code Name _ Check Type Check.Status
419705 1,159.31 Oct 28,2016 15839 Andrade,Jose Computer Check Outstanding
419706 1,395.07 Oct 28,2016 15905 Castillo,Jorge Computer Check Outstanding
419707 873.02 Oct 28,2016 15976 DeGarmo, Daniel F. Computer Check Outstanding
419708 1,698.75 Oct 28, 2016 15960 Gonzalez,Vianney Computer Check Outstanding
419709 1,409.07 Oct 28,201.6 10993 Huskey,Zachary B Computer Check Outstanding
419710 1,483.20 Oct 28,2016 15222 Hernandez,Francisco Computer Check Outstanding
419711 1,311.11. Oct 28,2016 04905 Leon,Amulfo H Computer Check Outstanding
419712 1,953.11 Oct 28,2016 10253 Mercado, Gilbert R Computer Check - Outstanding
419713 1,399.69 Oct 28, 2016 15968 Chavez,Aris O Computer Check Outstanding
419714 2,258.50 Oct 28,2016 15156 Menley, Charles A Computer Check Outstanding
419715 4,450.74 Oct 28,2016 15897 Doherty,Alexander Computer Check Outstanding
419716 821.39 Oct 28,2016 15833 Waits, Noel Computer Check Outstanding
Total#Checks Reported:12
Total Check Amount Reported:$20,212.96
Execution#108657 run by SHARONR using RPCH.docx-20141008 Prepared by ePersonality 4.50.00.05
CR01220 DIRECT BANK OF AMERICA, N.A. PAGE 1
SITE: TX ACH SERVICES DATE/TIME: 10/26/16 18:49:00
BATCH CONTROL AND REJECTED ITEMS RECAP *• CONFIDENTZAL '•
RTN: 122000030 ACCT #i XXX MXXXXX 2000
POINT: CIPSPRINI ORIGIN ID: 1956000752 ORIGIN NAME: CITY OF PALM SPRINGS FILE ID MOD- A
APPL: CIPSPRINI CO ID: 1956000757 CO NAME: CITY OF PALM SIR ENTRY DESC: PAYROLL SEC: PPD EFF DATE: 10/28/16
TYPE: FILE #: 16300004318 HATCH M: 0000001 CO DISC DATA:
REJECTED ITEMS
____________________________________________________________________________________________________________________________________
TRACE NUMBER TC HIS ACCOUNT NUMBER AMOUNT INDIVIDUAL IO INDIVIDUAL NAME
------------------------------------------------------------------------------------------------------------------------------------
REJECT REASON
------------------------------------------------------------------------------------------------------------------------------------
THERE ARE NO REJECTED ITEMS FOR THIS BATCH
BATCH TOTALS ________________DEBITS__________________ _________________CREDITS_________________
SETTLEMENT DATE # ITEMS k ADDENDA AMOUNT ITEMS N ADDENDA AMOUNT
10/28/16 0 0. .00 492 0 1,043,030.64
TOTAL 0 0 .00 492 0 1,D43,030.84
TOTAL SUBMITTED 0 0 .OD 492 0 1,043,030.B4
TOTAL REJECTED 0 0 .00 0 0 .00
TOTAL PROCESSED 0 0 ,00 492 0 1,043,030.04
"• END OF REPORT '•'
CRO1110 ➢IRECT BANK OF AMERICA, N.A. PAGE 1
SITE;.TX ACH SERVICES ➢ATE/TIME: 10/26/16 19:41:C0
ACKNOWLEDGMENT OF FILE RECEIPT - CONFIDENTIAL **
BIN! 122000020 ACCT 4: XXX%XXXXXXXXX2000
FILE STATUS
POINT: CIPSPRINI
DATE: 10/26/16
TIME: 17:35
STATUS: FILE RECEIVED
FILE INFORMATION
ORIGIN I➢: 1956000750
ORIGIN NAME: CITY OF PALM SPRINGS
FILE ID MOD: A -
DATE CREATE➢: 10/26/16
TIME CREATED: 03:10
FILE TOTALS:
TOTAL DEBIT AMOUNT: $0.00
TOTAL CREDIT AMOUNT: $1,043,030.84
TOTAL ITEM/A➢DENDA RECORDS: 492
TOTAL NUMBER OF REJECTS: 0
TOTAL REJECTED DEBIT AMOUNT: $O.00
TOTAL RES£CTEO CREDIT AMOUNT: $0.00
IF QUESTIONS, PLEASE CALL ACH SERVICES AT 1.800.424.2172
��� END OF REPORT **
Previous Day ACH Report
Company:Palm Springs GA City,of Bankof America
Requestor i Adana Muniz Merrill Lynch
Run Data:11/07/2016 19:48:31 CST
As of:10/28/2016
Bank of America,Southern California 1122000661
'I XXXX 2000 1 City of Palm Springs General Aoat"USD)As of: 1 012 812 01 6
Detail Credits
Preauthorized ACH Credit(165) 46,330.22 46,330.22 0.00 0.00 02062370730 - 0000000000
Preauthopized ACH Crediti(165) '4,150 00' 4,15QA0 0,00 ',D.00 ,'Q 2370732 ,00D0000000,
Preauthorized ACH Credit(165) 1,040.00 1,040.00 0.00 0.00 01020671609 00000D0000
Preauthorized ACH re 165) 5155851r5.68' 000 ,02002370731 OOOOQ000001
Preauthorized ACH Credit(165) 381.10 381.10 0.00 0.00 01019309863 0000000000
PrflauthOrized ACH Credif(165) 131 rQp 131.00 '0 00 .DAO 02002346972 t)000000000
Preauthorized ACH Credit(M) 22.00 22.00 0.00 0.00 02002347201 0000000000
Y k
Detail Debits
' pil I�Illli i, Illlp, Ijp II I�)"1�9�" II6, II I)�' �Iplli'p,ti���`I� IQ (,1�Ills I II�'71 )M iql ll�l I^ 'IN � � I �1141. .
Iry II I I II I �� il�u I l i I III I'�MY6 I I I II
Preauthorized ACH Debit(455) 2,085.26 01017883817 0000000000
PreauthorizeH ACH Debit(d55} 8d,b0 �01019191022I 00000000, s
ACH Settlement Debit(466) 1,042,855.84 02002262602 0000000000
ACH Sottlernenf Debit(466) 475.00 02007177062I OOOb000000
4. r E ; e7
Dekd Totals r ' 10d520010° 4 ' S` i , .}: aa3
Totals
I
Bank Totals
1012MO16
Total Credits 7 52,570.00
Total Debits 4 - 1,045,200.10
Report Totals
1012812016
Total Credits 7' 52,570.00
Total Debits 4 1,045,200.10
Page 1
Ariana Muniz
From: Sheila Thomas
Sent: Thursday, October 27, 2016 11:59 AM
To: Dolores Olvera; Sharon Riddle; Rita Gustafson;Ariana Muniz
Subject: Payroll Taxes PR 10/28/16
FEDERAL PAYROLL TAXES
Payment Information Entered Data
Taxpayer EIN xxxxx0757
Tax Form 941 Employers Federal Tax
Tax Type Federal Tax Deposit
Tax Period Q4/2016
Payment Amount $2S7,864.87
Settlement Date 10/31/2016
Subcategories:
1 Social Security $ 178.56
2 Medicare $ 45,693.83
3 Tax Withholding $ 211,992.48
STATE PAYMENTS
State Disability Insurance(SDI)Tax and California Personal Income Tax(PIT)
7 R
o ai E
Deposit Schedule Pay Date SDI Amount PIT Amount Total Amount Bank Debit Date Confirmation Number
Next bank Day 10/28/16 $0.00 $71,895.90 $71,895.90 10/31/16 499610
1