Loading...
HomeMy WebLinkAbout24274 RESOLUTION NO. 24274 A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF PALM SPRINGS, CALIFORNIA, APPROVING PAYMENT OF PAYROLL WARRANTS FOR THE PERIOD ENDED 07-07-2017 BY WARRANTS NUMBERED 419985 THROUGH 420006 TOTALING $43,288.69 LIABILITY CHECKS NUMBERED 1093269 THROUGH 1093288 TOTALING $81,391.26, FIVE WIRE TRANSFERS FOR $67,437.29, AND THREE ELECTRONIC ACH DEBITS OF $1,369,291.03 IN THE AGGREGATE AMOUNT OF $1,561,408.27, 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. Riehl Director of Finance and Treasurer NOW, THEREFORE BE IT RESOLVED by the City Council of the City of Palm Springs that payroll warrants numbered 419985 through 420006, liability checks numbered 1093269 through 1093288, 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 19T" DAY OF JU 7. David H. Ready, Esq., Ph.D. City Manager ATTEST: 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. 24274 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 July 19, 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 y� Kathleen D. Hart, MMC Interim City Clerk I v a �p 'fins Print Check List Execution #xxx 792 Function:RPCH Run By:SHARONR Run Start Date:Jul 6,2017 9:51:16 AM Payroll Sank Account:XXXXX661,xxxxxx\2000 From Pay Issue Date:Jul 7,2017 To Pay issue Date:Jul 7, 2017 Included Printed:Yes Include Unprinted:Yes Include Voided:Yes Include Cleared: Include Outstanding:Yes Include Reconciled: Include Vold Checks Only: Sort By:Check Number User Comment: FxevAon#XX 792 run by SHARONR using RPCH.docx• Prepafed by s!'ersarfati#y 4,50.00:05 Run:Jul 6.2017 9:51:16 AM Print Check List Page a of 2 Sorted By:Check Number From:Ju17 2017 To:Jul 7,2017 Bank of America Transit:XXXXX 6B1 Account: XXXXX i2OOO V not yet printed) check# Amount Check Bate p'ersara Grade Name Check Tyne Check has 419987 2,380.60 Jul 7,2017 15839 Andrade,Jose Computer Check Outstanding 419988 1,456.17 Jul 7,2017 15905 Castillo,Jorge Computer Check Outstanding 419989 1,224.07 Jul 7,2017 16084 Goedhart,Veronica Computer Check Outstanding 4199W 1,909.72 Jul 7,2017 15784 Richards,Tabitha Computer Check Outstanding 419991 4,658.58 Jul 7,2017 16077 Virata,Whitlen J Computer Check Outstanding 419992 1,089.97 Jul 7,2017 16080 Brann,Joshua Computer Check Outstanding 419993 1,028.48 Jul 7,2017 16079 1Gsgen,Brandon Computer Check Outstanding 419994 1,056.53 Jul 7,2017 16082 Pornthepsiripong,Punpong Computer Check Outstanding 419995 1,108.39 Jul 7,2017 16081 Valenti,Kelly Computer Check Outstanding 419996 1,190.42 Jul 7,2017 16083 D'Amato, IGrsten Computer Check Outstanding 419997 1,378.05 Jul 7,2017 10993 Huskey,Zachary B Computer Check Outstanding 419998 1,329.74 Jul 7,2017 15222 Hernandez,Francisco Computer Check Outstanding 419999 1,369.44 Jul 7,2017 04905 Leon,Amuifo H Computer Check Outstanding 420M 1,990.63 Jul 7,2017 10253 Mercado,Gilbert R Computer Check Outstanding 420001 1,389.68 Jul 7,2017 15968 Chavez,Aris O Computer Check Outstanding 420002 5,332.04 Jul 7,2017 10660 Reyes,Bryan Computer Check Outstanding 420003 1,919.95 Jul 7,2017 15156 Meniey,Charles A Computer Check Outstanding 420004 1.538.85 Jul 7,2017 15833 Waits,Noel Computer Check Outstanding 420005 1,677.23 Jul 7,2017 16076 Clifford,Patrick Computer Check Outstanding 420W6 1,917A5 Jul7,2017 16078 Torres,Edward Computer Check Outstanding Total#Checks Reported:20 Total Check Amount Reported:$36,845.79 Execution#XX 792 run by SHARONR using RPCH.docx- )'tapered by el ersonality 4.50.00,O C� YAIp V O Y .qM1 Cn<itnY.>ag4: Print Check List Execution#xxx$20 Function:RPCH Run By:DOLORESO Run Start Date:Jul 10,2017 1:54:03 PM Payroll Bank Account:xxxxx 661,xxxxxx 2000 From Pay issue Date:Jul 5,2017 To Pay Issue Date:Jul 5,2017 Included Printed:Yes Include Unprinted:Yes Include Voided:Yes Include Cleared:Yes Include Outstanding:Yes Include Reconciled:Yes Include Vold Checks Only:No Sort By:Check Number User Comment: Execution#XX$20 run by DOLORESO using RPCH.docx Prepared by sPersonaJity 4.60,00.05 Run:Jul 10,2n171:64:0s PM Print Check List eye 2 of 2 Sorted By:Check Number From:Jul 5,2017 To:Jul 5,2017 Sank of Anwdca Transit:XXXXXOGI Account: XXXXX ;2000 (*not yet printed) Check Amount Check Date P4rson Code HAM check lyoe Check Status 419985 8,983.21 Jul 5,2017 16054 Trovato,Jonathan Computer Check Outstanding 419986 2,459.69 Jul 5,2017 16054 Trovato,Jonathan Computer Check Outstanding "total#Checks Reported:2 Total Check Amount Reported:$8,447.90 Total#Checks Cleared:0 Total Check Amount Clearer:$0.00 Execution#;XX820 nun by DOLORESO using RPCH.docx- Prepared by ePsrsanality 4.50.00.05 SUNGARD PENTAMATION - FUND ACCOUNTING MANAGER PAGE NUMBER: 1 DATE: 07/06/17 CITY OF PALM SPRINGS ACCTPA21 TIME: 10:57:SG CHECK REGISTER INCLUDING SYSTEM VOIDS ACCOUNTING PERIOD: 1/18 SELECTION CRITERIA: chkstat.rundate='07/07/2017' DISTRIBUTION FUND: 001 CHECK NUMBER ISSUE DATE VENDOR STATUS TOTAL DESCRIPTION 1093269 07/07/2017 AMERICAN FIDELITY ASSURAN R 579.32 ACCOUNTS PAYABLE CHECK 1093270 07/07/2017 EMPLOYMENT DEVELOPMENT DE R 93.10 ACCOUNTS PAYABLE CHECK 1093271 07/07/2017 KANSAS PAYMENT CENTER R 2B4.50 ACCOUNTS PAYABLE CHECK 1093272 07/07/2017 GARNISHMENT R 1008.46 ACCOUNTS PAYABLE CHECK 1093273 07/07/2017 AFLAC R 120.45 ACCOUNTS PAYABLE CHECK 1093274 07/07/2017 DAVEY ADMIN GROUP R 9881.68 ACCOUNTS PAYABLE CHECK 1093275 07/07/2017 FIRE MANAGEMENT ASSOCIATI R 472.50 ACCOUNTS PAYABLE CHECK 1093276 07/07/2017 FRANCHISE TAX BOARD R 2102.95 ACCOUNTS PAYABLE CHECK 1093277 07/07/2017 LIBERTY MUTUAL INSURANCE R 1270.70 ACCOUNTS PAYABLE CHECK 1093278 07/07/2027 MANAGEMENT ASSN OF PALM S R 1001.25 ACCOUNTS PAYABLE CHECK 1093279 07/07/2017 PALM SPRINGS FIREMENS ASS R 1775.52 ACCOUNTS PAYABLE CHECK 1093280 07/07/2017 POLICE OFFICERS' ASSOCIAT R 7265.96 ACCOUNTS PAYABLE CHECK 1093281 07/07/2017 RIVERSIDE COUNTY SHERIFF R 75.00 ACCOUNTS PAYABLE CHECK 1093282 07/07/2017 SEIU LOCAL 721 CTW AND C R 2478.50 ACCOUNTS PAYABLE CHECK 1093283 07/07/2017 SUN COMMUNITY R 48078.70 ACCOUNTS PAYABLE CHECK 1093284 07/07/2017 UNITED WAY OF THE DESERT R 169.00 ACCOUNTS PAYABLE CHECK 1093285 07/07/2017 GARNISHMENT R 152.00 ACCOUNTS PAYABLE CHECK 1093286 07/07/2017 PS FIRE SAFETY UNIT R 2151,65 ACCOUNTS PAYABLE CHECK 1093287 07/07/2017 GARNISHMENT R 620.50 ACCOUNTS PAYABLE CHECK 1093288 07/07/2017 TRANSAMERICA WORKSITE MAR R 1789.52 ACCOUNTS PAYABLE CHECK TOTAL FUND 81391,26 TOTAL REPORT 81391.26 Ariana Muniz From: Thomas Hays Sent: Thursday, July 06, 2017 10:24 AM To: Sharon Riddle; Rita Gustafson; Dolores Olvera;Ariana Muniz Subject: Separation Payroll 070517 Federal and State Tax Payments Federal: EnteredPayment Information Data TaxpayerElN. - A xxxxz0757 - Tax Form 941 Employers Federal Tax Tax Type ( Federal Tax Deposit Tax Period Q3/2017 PaymentAmount i $1,308.65 Settlement Date 07/07/2017 Subcategories: 2 Medicare $248.50 3 Tax Withholding I $1,060.15 State: Payment Submission Date and Time (PST) : 7/6/2017 Time: 10:18:46 AM EDD Employer Identification Number : 80098221 Deposit Schedule : Next bank Day Pay Date : 07/06/17 SDI Amount : $0.00 PIT Amount : $337.91 Total Amount : $337.91 Bank Debit Date : 07/07/17 Confirmation Number : 1440409 Regards, THOMAS HAYS Deputy City Treasurer 3200 E.Tahquitz Canyon Way Palm Springs,CA 92263 (760)323-8223 direct thomas.hays@oalmsoringsca.gov 1 Ariana Muniz From: Thomas Hays Sent: Thursday,July 06, 2017 10:46 AM To: Sharon Riddle; Rita Gustafson; Dolores Olvera;Ariana Muniz Subject: Payroll 070717 Federal and State Tax Payments Federal: Entered' Payment Information Data TaxpayerElN xxxzx0757 Tax Form 941 Employers Federal Tax Tax Type Federal Tax Deposit Tax Period Q3/2017 Payment Amount;" .$262,543.01 Settlement Date 07/07/2017 Subcategories: " 3 Medicare $46,76352 3 Tax Withholding $215,779.49 " State: Payment Submission Date and Time (PST) : 7/6/2017 Time: 10:45:11 AM EDD Employer Identification Number :80098221 Deposit Schedule : Next bank Day Pay Date : 07/06/17 SDI Amount : $0.00 PIT Amount: $72,128.91 Total Amount : $72,128.91 Bank Debit Date : 07/07/17 Confirmation Number: 1440635 Regards, THOMAS HAYS Deputy City Treasurer 3200 E.Tahquitz Canyon Way Palm Springs,CA 92263 (760)323-8223 direct thomas.hays(@Dalmsprin_qsca.gov 1 Previous Day ACH Report Bank of America Company:Palm Springs CA City of Requestor:Ariana Muniz Merrill Lynch Run Date:07/11/2017 14:57:44 CDT As of:07/05/2017 Bank of America,Southern California(XX)(X 661 X)CXX 20001 City of Palm Springs General Acct I USD I As of:0 710 5/2 0 1 7 Detail Credits I o M pppp t,�'S��P�,Pf�y�f IPi 4;4��'I�l��i���I li INrile) �1 � Preauthorized ACH Credit(165) 715,023.00 715,023.00 0.00 0.00 86007715738 0000000000 Preauthorized ACH Credit(165) 16,913.00 15,913.00 0.00 OW 86009137714 0000000000 Preauthorized ACH Credit(165) 3,828.00 3,628.00 0.00 0,00 86009137715 0000000000 Preauthorized ACH Credit(165) 3,105.00 3,105.00 0.00 0.00 8660§520637 OOOOOOOOOD' Preauthorized ACH Credit(165) 1,353.74 1,353.74 0.00 0.00 86009137713 0000000000 'Preauthorized ACH Credit(165) 660.00 660.00 0.00 0.00 86008790874 ' 0000000000 Preauthorized ACH Credit(165) 495.00 495.00 0.00 0.00 86005371957 0000000000 Preauthorized ACH Credit(165) 44.00 44.00 0.00 0.00 86009116976 0000000000 Preauthorized ACH Credit(165) 39.00 39.00 0,00 0.00 86009117159 0000000000 Preauthorized ACH Credit(165) 36.00 36.00 0.00 0.00 86009117160 0000000000 Credit Totals 740,496.74 740,496.74 0.00 0.00 Detail Debits iv i f4P I (Pir1 R�74'9'P`R ��'f1 €�)� ��4�411 ill Il �f � ��� �;1���a; � ���',�r��ti � �f����;i���� +�lu,�� 1���,�����!����lll;����1�������r Preauthorized ACH Debit(455) 606.77 86008837579 0000000000 Debit Totals 606.77 Totals Bank Totals 0 710 512 01 7 X Total Credits 10 740.496.74 Total Debits 1 606.77 Report Totals 0 710 512 01 7 IN Total Credits 10 740,496.74 Total Debits 1 606.77 Page 1 Previous Day ACH Report BankofAmerica-'Company:Palm Springs CA City of Requestor:Ariana Muniz Merrill Lynch Run Date:07/11/2017 14:58:57 CDT Y As of:07/07/2017 Bank of America,Southern California JXXXX 661 XXXX`2000 I City of Palm Springs General Acct I USD As of:07/07/2017 Detail Credits Preauthorized ACH Credit(165) 12,748,28 12,748.28 0.00 0.00 86021758500 0000000000 Preauthorized ACH Credit(165) 4,063.82 4,093.82 0.06 0.00 88008959239 0000000000' Preauthorized ACH Credit(165) 3,615.00 3,615.00 0.00 0.00 88008959241 0000000000 Preauthorized ACH Credit(165) 2,049.00 2049.00 0.00 0.00 88008959240 0000000000'' Preauthorized ACH Credit(165) 1,404.00 1,404.00 0.00 0.00 87016672137 0000000000 Preauthorized ACH Credit(165) 451 A0 451.00 0,00 0.00 87014666452 0000000000 — ---- --— — — _ -:...------- Preauthorized ACH Credit(165) 23.00 23.00 0.00 0.00 88008934267 0000000000 Credit Totals 24,384.10 24,384.10 0.00 0.00 Detail Debits @�)yr()i��rdtlfniiki���i�'11)rt,fr�: i� Preauthorized ACH Debit(455) ✓ 262.543.01 88008040063 0000000000 Preauthorized ACH Debit(455) ✓ 72,128.91 '88008235954 0000000000 Preauthorized ACH Debit(455) ✓ 1,308.65 88008040005 0000000000 Preauthorized ACH Debit(455) ✓ 337.91 88008235940 0000000D00 ACH Settlement Debit(466) ✓ 1,032,797.55 88008712109 0000000000 ACH Settlement Debit(466) ✓ 175.06 '88013993100 0000000000 Debit totals 1,369,291.03 Totals Bank Totals 07/07/2017 XXXX Total Credits 7 24,384.10 Total Debits 6 1,369,291,03 Report Totals 07107/2017 Total Credits 7 24,384.10 Total Debits 6 1,369,291.03 Pagel Previous Day ACH Repoli Bank of America-1I Company:Palm Springs CA City of Requestor:Ariana Muniz Merrill Lynch Run Date:07/11/2017 15:00:30 CDT J As of: 07/10/2017 Bank of America,Southern California 1)(X)()( 661 )OOO(2000 i City of Palm Springs General Acct USD I As of:07/1 012 01 7 Detail Credits 9 Y Preauthorized ACH Credit(165) 4,997.00 4,997.00 0.00 0,00 91013326143 0000000000 Preauthorized ACH Credit(165) 4,335.00 4,335.00 0.00 0.00 91012155584 0000000000 Preauthorized ACH Credit(165) 3,275.00 3,275.00 0.00 0.00 91012116594 0000000000 Preauthorized ACH Credit(165) 2,652.00 2,652.00 MO 0.00 91012116593 0000000000 Preauthorized ACH Credit(165) 1,488.00 1,488.00 0.00 0.00 91012996786 0000000000 Preauthorized ACH Credit(165) 545.00 545.00 0.00 0.00 91008428018 0000000000 Preauthorized ACH Credit(165) 293.00 293.00 0.00 0.00 91010647904 0000000000 Preauthorized ACH Credit(155) 27.04 27.04 0.00 0.00 91012091793 0000000000 Preauthorized ACH Credit(165) 23.00 23.00 O.DO 0.00 91012091678 0000000000 Credit Totals 17,635.04 17,635.04 0.00 0.00 Detail Debits • tSYi lQ l i Preauthorized ACH Debit(455) ✓ 4,599,83 88015097803 0000000000 Debit Totals 4,599.63 Totals Bank Totals 07/10/2017 will XXX III ii now Total Credits 9 17,635.04 Total Debits 1 4,599.83 Report Totals 07/10/2017 Total Credits 9 17,635.04 Total Debits 1 4,599.83 Pagel Previous Day Wire Report Bank ofAmerica'�I Company:Palm Springs CA City of Requestor:Ariana Muniz Merrill Lynch Run Date:0711 11201 7 1 5:02:36 CDT Y As of'.0710712017 Bank of America,Southern California I XXXX'661 XXXX 20001 City of Palm Springs General Acct I USD As of:0 710 7/2 0 1 7 Detail Credits Incoming Money Transfer Credit 18,468.50 18,468,50 0.00 0.00 00370327835 0000000000 (195) CreditTotals 18,468.50 18,468.50 0.00 0.00 Detail Debits Outgoing Money Transfer Debit(495) / 33,546.03 00370400719 0000000000 Outgoing Money Transfer Debit(495) t/ 19,994.83 00370400721 0000000000 Outgoing Money Transfer Debit(495) 8,612.50 00370400720 0000000000 Outgoing,Money Transfer Debit(495j 684.10 -00370400724 0000000000 Debit Totals 62,837.46 Totals Bank Totals 07107/2017 P Total Credits 1 18,468.50 Total Debits 4 62,837,46 Report Totals 0710712017 Total Credits 1 18.468.50 Total Debits 4 62,837.46 Pagel