HomeMy WebLinkAbout24142 RESOLUTION NO. 24142
A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF PALM
SPRINGS, CALIFORNIA, APPROVING PAYMENT OF PAYROLL
WARRANTS FOR THE PERIOD ENDED 11-05-2016 BY WARRANTS
NUMBERED 419717 THROUGH 419730 TOTALING $24,142.51
LIABILITY CHECKS NUMBERED 1088684 THROUGH 1088705
TOTALING $85,121.05, FIVE WIRE TRANSFERS FOR $58,675.66, AND
THREE ELECTRONIC ACH DEBITS OF $1,332,021.31 IN THE
AGGREGATE AMOUNT OF $1,499,960.53, 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 419717 through 419730, liability checks numbered 1088684
through 1088705, 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 7TH DAY OF DECEMBER, 2016.
ATTEST: David H. Ready, Esq., P ity 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. 24142 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 7th day of December, 2016, by
the following vote:
AYES: Councilmember Foat, Councilmember Kors, Councilmember Roberts, Mayor Pro
Tern Mills, and Mayor Moon
NOES: None
ABSENT: None
ABSTAIN: None
Kathleen D. Hart, MMC, Interim City Clerk
SUNGARD PENTAMATION - FUND ACCOUNTING MANAGER PAGE NUMBER: 1
DATE: 11/10/26 CITY OF PALM SPRINGS ACCTPA21
TIME: 10:21:20 CHECK REGISTER INCLUDING SYSTEM VOIDS ACCOUNTING PERIOD: 5/17
SELECTION CRITERIA: chkstat.rUndate='11/11/2016'
DISTRIBUTION FUND: 001
CHECK NUMBER ISSUE DATE VENDOR STATUS TOTAL DESCRIPTION
1088684 11/11/2016 AMERICAN GENERAL R 429.09 ACCOUNTS PAYABLE CHECK
1088685 11/11/2016 EMPLOYMENT DEVELOPMENT DE R 93.10 ACCOUNTS PAYABLE CHECK
1088686 11/11/2016 KANSAS PAYMENT CENTER R 284.50 ACCOUNTS PAYABLE CHECK
1088687 11/11/2016 GARNISHMENT R 1221.69 ACCOUNTS PAYABLE CHECK
1088688 11/11/2016 GARNISHMENT R 300.00 ACCOUNTS PAYABLE CHECK
1088689 11/11/2016 AFLAC R 120.45 ACCOUNTS PAYABLE CHECK
1088690 11/11/2016 DAVEY ADMIN GROUP R 6944.22 ACCOUNTS PAYABLE CHECK
1088691 11/11/2016 FIRE MANAGEMENT ASSOCIATI R 405.00 ACCOUNTS PAYABLE CHECK
1088692 11/11/2016 FRANCHISE TAX BOARD R 667.82 ACCOUNTS PAYABLE CHECK
1088693 11/11/2016 LIBERTY MUTUAL INSURANCE R 125B.86 ACCOUNTS PAYABLE CHECK
1088694 11/11/2016 MANAGEMENT ASSN OF PALM S R 941.25 ACCOUNTS PAYABLE CHECK
1088695 11/11/2016 PALM SPRINGS FIREMENS ASS R 1208.74 ACCOUNTS PAYABLE CHECK
1088696 11/11/2016 POLICE OFFICERS' ASSOCIAT R 9629.43 ACCOUNTS PAYABLE CHECK
1088697 11/11/2016 RIVERSIDE COUNTY SHERIFF R 741.99 ACCOUNTS PAYABLE CHECK
1088698 11/11/2016 SEIU LOCAL 721 CTW AND C R 2492.00 ACCOUNTS PAYABLE CHECK
1088699 11/11/2016 SUN COMMUNITY R 53384.51 ACCOUNTS PAYABLE CHECK
1088700 11/11/2016 UNITED WAY OF THE DESERT R 171.00 ACCOUNTS PAYABLE CHECK
1088701 11/11/2016 GARNISHMENT R 152.00 ACCOUNTS PAYABLE CHECK
1088702 11/11/2016 PS FIRE SAFETY UNIT R 2197.40 ACCOUNTS PAYABLE CHECK
1086703 11/11/2016 GARNISHMENT R 620.50 ACCOUNTS PAYABLE CHECK
1088704 11/11/2016 STATE OF CA FRANCHISE TAX R 263.25 ACCOUNTS PAYABLE CHECK
1088705 11/11/2016 TRANSAMERICA WORKSITE MAR R 1594.25 ACCOUNTS PAYABLE CHECK
TOTAL FUND 85121.05
TOTAL REPORT 85121.05
C� YAIy JP
� A.
v
•C��'1 C1FK�p
Print Check List
Execution # 108853
Function:RPCH
Run By:SHARONR
Run Start Date:Nov 9, 2016 5:05:34 PM
Payroll Bank Account:122000661, 14318DB2000
From Pay Issue Date:Nov 11, 2016
To Pay Issue Date:Nov 11, 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# 108853 run by SHARONR using RPCH.docx-20141008 Prepared by ePersonality 4.50.00.05
Run: Nov 9, 2016 5*05:34 PM Print Check List Page 2 of 2
Sorted By:Check Number From: Nov 11,2016 To: Nov 11, 2016
Bank of America Transit: 122000661 Account: 1431BD82000 ('not yet printed)
Check# Amount Check Date Person Code Name Check Type Check Status
419717 1,549.81 Nov 11, 2016 15839 Andrade,Jose Computer Check Outstanding
419718 1,546.58 Nov 11,2016 15905 Castillo, Jorge Computer Check Outstanding
419719 2,179.59 Nov 11,2016 16033 Goolsby, Denise Computer Check Outstanding
419720 1,241.05 Nov 11,2016 10993 Huskey,Zachary B Computer Check Outstanding
419721 1,876.43 Nov 11,2016 15222 Hernandez, Francisco Computer Check Outstanding
419722 1,309.35 Nov 11,2016 04905 Leon,Arnulfc H Computer Check Outstanding
419723 2,302.63 Nov 11,2016 10253 Mercado, Gilbert R Computer Check Outstanding
419724 1,399.70 Nov 11,2016 15968 Chavez,Ads O Computer Check Outstanding
419725 2,157A1 Nov 11,2016 15156 Menley, Charles A Computer Check Outstanding
419726 2,033.66 Nov 11,2016 16034 Canchola,Alvaro Computer Check Outstanding
419727 3,824.21 Nov 11,2016 15897 Doherty,Alexander Computer Check Outstanding
419728 1,896.35 Nov 11,2016 16035 Torres, Michael Computer Check Outstanding
419729 826.04 Nov 11,2016 15833 Waits, Noel Computer Check Outstanding
Total#Checks Reported:13
Total Check Amount Reported:$24,142.61
Execution#108853 run by SHARONR using RPCH.docx-20141008 Prepared by ePersonalry 4.50.00.05
CRO1220 DIRECT BANK OF AMERICA, N.A. PAGE 1
SITE: T% ACH SERVICES DATE/TIME: 11/09/16 21:29:00
BATCH CONTROL AND REJECTED ITEMS RECAP •+ CONFIDENTIAL
FIN; 122000030 ACCT #: 00000001431862000
POINT: CIPSPRINI ORIGIN ID: 1956000757 ORIGIN NAME: CITY OF PALM SPRINGS FILE ID MOD: A
APPL: CIPSPRINI CO ID; 1956000757 CO NAME: CITY OF PALM SPR ENTRY DESC: PAYROLL SEC: PP➢ EFF DATE: 11/11/16
TYPE: FILE #: 16314004355 BATCH #: 0000001 CO DISC DATA:
REJECTED ITEMS
TRACE NUMBER TO ATN ACCOUNT NUMBER AMOUNT INDIVI➢UAL IO 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/30/16 0 0 .00 495 0 995,137.93
TOTAL 0 0 .00 495 0 995,237.93
TOTAL SUBMITTED 0 0 .00 495 0 995,137.93
TOTAL REJECTED 0 0 .OG 0 0 .00
TOTAL PROCESSED 0 0 .00 495 0 995,137.93
"' END OF REPORT +'*
Previous Day ACH Report ij��
Company:Palm Springs CA City of Bank of America
Requestor:Ariana Muniz Merrill Lynch
Run Date:11/28/2016 20:22:52 CST
As of: 1111012016
Bank of America,Southern California 1122000661
xxxxxx 2000 1 City of Palm Springs General Acct I USD I As of:11/10/2016
Detail Credits
II I' II i I, III
Corporate Trade Payment Credit 3,955.75 3,955.75 0.00 0.00 15002860320 0000000000
(164)
Preauthorized ACH Credit(165) 14,675.70 14 67570 0.00 ^0.00 15002660138 0000000000f
Preauthorized ACH Credit(165) 3,506.00 3.506.00 0.00 0.00 15003501761 0000000000
Preauthorizpd ACH Credit(165) 3,043.00 7 3,043 00 0.00 0.00 15003501760 0000000000'.
Preauthorized ACH Credit(165) 2,217.60 2,217.60 0.00 0.00 15003501759 0000000000
Preauthorized ACH Credit(165) 983;00 983.00 0.00 0 00 14011542429 0000000000
Preauthorized ACH Credit(165) 517.00 517.00 0.00 0.00 15003478332 0000000000
Preauthorized ACH Credit(165) 82.60 82,80 0.00 0.00 15003478565 0000000000
Preauthorized ACH Credit(165) 20.00 20.00 0.00 0.00 14006493389 0000000000
:Credit Totals 29,000.85 29,000.115 0.00 0.00
Detail Debits
, III
ACH Settlement Debit(466) 994,962.93 1500340095E 0000000000
ACH Settlement Debit(466) 975.00 15008988396 0000006000
.Debit Totals 995,137.93
Totals
Bank Totals
1111 012 01 6
Total Credits 9 29,000.85
Total Debits 2 995,137.93
Report Totals
1111012016
Total Credits 9 29,000.85
Total Debits 2 995,137.93
Page 1
Ariana Muniz
From: Sheila Thomas
Sent: Thursday, November 10, 2016 9:09 AM
To: Dolores Olvera; Rita Gustafson; Sharon Riddle;Ariana Muniz
Subject: Payroll Taxes for PR 11/11/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 $263,215.32
Settlement Date 11/14/2016
Subcategories:
1 Social Security $ 200.88
2 Medicare $44,936.74
3 Tax Withholding $ 218,077.70
STATE PAYMENTS
State Disability Insurance(SDI)Tax and California Personal Income Tax(PIT)
b`E )o: er,)��ht�fi� titirlNumbe 8�0��221
Bank Acco+nt��*�*»*�20QQ
Deposit Schedule Pay Date SDI Amount PIT Amount Total Amount Bank Debit Date Confirmation Number
Next bank Day 11/11/16 $0.00 $73,668.06 $73,668.06 11/14/16 551476
1