Loading...
HomeMy WebLinkAbout24270 RESOLUTION NO. 24270 A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF PALM SPRINGS, CALIFORNIA, APPROVING PAYMENT OF PAYROLL WARRANTS FOR THE PERIOD ENDED 06-17-2017 BY WARRANTS NUMBERED 419968 THROUGH 419984 TOTALING $24,042.23 LIABILITY CHECKS NUMBERED 1092955 THROUGH 1092974 TOTALING $80,389.12, FIVE WIRE TRANSFERS FOR $59,187.88, AND THREE ELECTRONIC ACH DEBITS OF $1,323,320.42 IN THE AGGREGATE AMOUNT OF $1,486,939.65, 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. Geoff r6f 9IKiehl Director of Finance and Treasurer NOW, THEREFORE BE IT RESOLVED by the City Council of the City of Palm Springs that payroll warrants numbered 419968 through 419984, liability checks numbered 1092955 through 1092974, 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 JULY, 2017. David H. Ready, Esq., City Manager ATTEST: lL4az Kathleen D. Hart, MMC, Interim City Clerk STATE OF CALIFORNIA ) CERTIFICATION 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. 24270 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 W�a Kathleen D. Hart, MMC Interim City Clerk _Ct Yd�kH:dA A W a Print Check List Execution#xxx 434 Function:RPCH Run By:SHAR4NR Run Start Date:Jun 20,2017 3:45:53 PM Payroll Bank Account:XXXxx 661,xxxxxx 2000 From Pay Issue Date:Jun 21,2017 To Pay Issue Date:Jun 21,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: Execution#XX 434 run ay SHARONR using RPCH.docx. Prepared by ePersonality 4.60,00.05 Run;Jun 20,2017 3:45;53 PM Print Check List Page 2 of 2 Sorted By:Check Number From;Jun 21,2017 To:Jun 21,2017 Bank of America Transit:XXXX 661 Account:XXXXXX2000 { not yet printed) Check# Amount Check Hate Person Code HIM -;heck Tvne 41996E 1,928.39 Jun 21,2017 16049 Jipp,Brian Computer Check Outstanding 419969 2,012.06 Jun 21,2017 16049 Jipp,Brian Computer Check Outstanding Total#Checks Reported:2 Total Check Amount Reported:$3,940.45 Execution#XX 434 run by SHRRONR using RPCH.docx Prepared by ePersonality 4.60 00.05 �+ rat,y sp a w . tit , Print Check List Execution#XxX 646 Function:RPCH Run By:SHARONR Run Start Date:dun 21,2017 5:43:20 PM Payroll Bank Account:XXXXX 661,XXXXXX 2000 From Pay issue Date:Jun 23,2017 To Pay Issue gate:Jun 23,2017 Included Printed:Yes Include Unprinted:Yes Include Voided:Yes Include Cleared: Include Outstanding:Yes Include Reconciled: Include Vold Checks Only: Soft By:Check Number User Gomment: Execution#XX 546 run by SHARONR using RPGH.dooxXXXXX Prepared by ePersonatity 4.W.00.05 Run;Jun 21,2017 5143:20 psi Print Check List Page 2 of 2 Sorted 8y,Check Number Fram:Jun 23,2017 To:Jun 23,2017 Bank of America TransitXXXX 681 Account:XXXXXX2000 ("not yet printed) Check# Amoun Check Date Person Code Name Check Tvoe Ch9sk Status 419970 1,887.09 Jun-23,2017 15839 Andrade,Jose Computer Check Outstanding 419971 1,430.29 Jun 23,2017 15905 Castillo,Jorge Computer Check Outstanding 419972 798,02 Jun 23,2017 15784 Richards,Tabitha Computer Check Outstanding 419973 11924 Jun 23,2017 15M Gagnon,Susan Computer Check Outstanding 419974 1,350.94 Jun 23,2017 10993 Huskey,Zachary B Computer Check Outstanding 419975 1,123.50 Jun 23,2017 15603 Navarro,Yrene Computer Check Outstanding 419976 1,299.50 Jun 23,2017 15222 Hernandez,Francisco Computer Check Outstanding 419977 1,341„40 Jun 23,2017 04905 Leon,Amutfo H Computer Check Outstanding 419978 1,966.14 Jun 23,2017 10253 Mercado,Gilbert R Computer Check Outstanding 419979 1,365,29 Jun 23,2017 15968 Chavez,Aris O Computer Check Outstanding 419980 1,885.85 Jun 23,2017 15156 Menley,Charles A Computer Check Outstanding 419981 3,259.93 Jun 23,2017 15897 Doherty,Alexander Computer Check Outstanding 419982 153.64 Jun 23,2017 15365 Weems,Cassie L Computer Check Outstanding 419983 1,322.77 Jun 23,2017 15833 Waits, Noel Computer Check Outstanding 419984 809.18 Jun 23,2017 16075 Williams,David M Computer Check Outstanding Total#Checks Reported:15 Total Check Amount Reported:$20,101.78 Execution#XX 546 run by$HARONR using RPCH.docx Prepared by ePersonality 4.50.00,05 SUNGARD PENTAMATION - FUND ACCOUNTING MANAGER PAGE NUMBER: 1 DATE: 06/22/17 CITY OF PALM SPRINGS ACCTPA21 TIME: 11:55:19 CHECK REGISTER INCLUDING SYSTEM VOIDS ACCOUNTING PERIOD: 12/17 SELECTION CRITERIA: chkstat.rundate='06/23/2017' DISTRIBUTION FUND: 001 CHECK NUMBER ISSUE DATE VENDOR STATUS TOTAL DESCRIPTION 109295S 06/23/2017 AMERICAN FIDELITY ASSUR-AN R 579.32 ACCOUNTS PAYABLE CHECK 109295G 06/23/2017 EMPLOYMENT DEVELOPMENT DE R 93.10 ACCOUNTS PAYABLE CHECK 1092957 06/23/2017 KANSAS PAYMENT CENTER R 284.50 ACCOUNTS PAYABLE CHECK 1092958 06/23/2017 GARNISHMENT R 1008.46 ACCOUNTS PAYABLE CHECK 1092959 06/23/2017 AFLAC R 120.45 ACCOUNTS PAYABLE CHECK 1092960 06/23/2017 DAVEY ADMIN GROUP R 9519.18 ACCOUNTS PAYABLE CHECK 1092961 06/23/2017 FIRE MANAGEMENT ASSOCIATI R 472.50 ACCOUNTS PAYABLE CHECK 1092962 06/23/2017 FRANCHISE TAX BOARD R 2418.4G ACCOUNTS PAYABLE CHECK 1092963 06/23/2017 LIBERTY MUTUAL INSURANCE R 1261.31 ACCOUNTS PAYABLE CHECK 1092964 06/23/2017. MANAGEMENT ASSN OF PALM S R 986.25 ACCOUNTS PAYABLE CHECK 1092965 06/23/2017 PALM SPRINGS FIREMENS ASS R 1775.52 ACCOUNTS PAYABLE CHECK 1092966 06/23/2017 POLICE OFFICERS' ASSOCIAT R 7285.96 ACCOUNTS PAYABLE CHECK 1092967 06/23/2017 RIVERSIDE COUNTY SHERIFF R 436.74 ACCOUNTS PAYABLE CHECK 1092968 06/23/2017 SEIU LOCAL 721 CTW AND C R 2465.00 ACCOUNTS PAYABLE CHECK 1092969 06/23/2017 SUN COMMUNITY R 47042.70 ACCOUNTS PAYABLE CHECK 1092970 06/23/2017 UNITED WAY OF THE DESERT R 169.00 ACCOUNTS PAYABLE CHECK 1092971- 06/23/2017 GARNISHMENT R 152.00 ACCOUNTS PAYABLE CHECK 1092972 06/23/2017 PS FIRE SAFETY UNIT R 1908.65 ACCOUNTS PAYABLE CHECK 1092973 06/23/2017 GARNISHMENT R 620.50 ACCOUNTS PAYABLE CHECK 1092974 06/23/2017 TRANSAMERICA WORKSITE MAR R 1789.52 ACCOUNTS PAYABLE CHECK TOTAL FUND 80389.12 TOTAL REPORT 80389.12 Ariana Muniz From: Thomas Hays Sent: Wednesday,June 21, 2017 10:22 AM To: Sharon Riddle; Rita Gustafson; Dolores Olvera;Ariana Muniz Subject: Payroll 062117 Federal and State Tax Payments Federal: EnteredPayment Information Data TaxpayerEIN xxxxx0757 Tax Form 941 Employers Federal Tax Tax Type Federal Tax Deposit Tax Period Q2/2017 Payment Amount $1,103.00 Settlement Date 06/22/2017 Subcategories: 2 Medicare $162.32 3 Tax Withholding $940.68 State: Payment Submission Date and Time (PST) : 6/21/2017 Time: 10:17:44 AM EDD Employer Identification Number : 80098221 Deposit Schedule : Next bank Day Pay Date : 06/21/17 SDI Amount : $0.00 PIT Amount : $286.65 Total Amount : $286.65 Bank Debit Date : 06/22/2017 Confirmation Number : 1392205 Regards, THOMAS HAYS Deputy City Treasurer 3200 E.Tahquitz Canyon Way Palm Springs, CA 92263 (760)323-8223 direct thomas.hays(a palmspringsca gov 1 Ariana Muniz From: Thomas Hays Sent: Thursday,June 22,2017 12:38 PM To: Sharon Riddle; Rita Gustafson; Dolores Olvera;Ariana Muniz Subject: Payroll 062317 Federal and State Tax Payments Federal: 'Paymentata Taxpayer;EIN xxxxx0757 Tax Form 941 Employers Federal Tax Tax Type Federal Tax Deposit Tax Period Q2/2017 Payment Amount $245,632,24 Settlement Date 06/23/2017 Subcategories: -1 Social Security $111.60 2 Medicare $44,538.22 3 Tax Withholding $200,982.42- State: Payment Submission Date and Time (PST) : 6/22/2017 Time: 12:37:49 PM EDD Employer Identification Number: 80098221 Deposit Schedule : Next bank Day Pay Date : 06/23/17 SDI Amount : $0.00 PIT Amount : $66,879.48 Total Amount: $66,879.48 Bank Debit Date : 06/23/2017 Confirmation Number: 1396664 Regards, THOMAS HAYS Deputy City Treasurer 3200 E.Tahquitz Canyon Way Palm Springs,CA 92263 (760)323-8223 direct thomas.ha s a palmsaringscaoov Previous Day ACH Report BankofAmerical� Company:Palm Springs CA City of Requestor:Ariana Muniz Merrill Lynch Run Date:07/11/2017 13:23:45 CDT Y As of:0 6/2 212 0 1 7 Bank of America,Southern California I XXXX 661 XXXX.2000 I City of Palm Springs General Acct I USD I As of.06/22/2017 Detail Credits pp i 4 ��ii!!E ( � '�ii I /iQ !, 1lI�J!I��r4illii�C Preauthorized ACH Credit(165) 12,657.04 12,657.04 0.00 0.00 73004889973 0000000000 Preauthorized ACH Credit(165) 10,287.97 10,287.97 0.00 0.00 71018398076 OOOOD00000 Preauthorized ACH Credit(165) 3.666.00 3,666.00 0,00 0.00 73004889975 0000000D00 Preauthorized ACH Credit(165) 1.364.00 1,364.00 D.00 0.00 73004889974 0000000000 Preauthorized ACH Credit(165) 675.00 675.00 0.00 D.00 72011717604 0000000000 Preauthorized ACH Credit(165) 658.00 658.00 0.00 0.00 72013385522 0000000000 r Preauthorized ACH Credit(165) 50.00 50.00 0.00 0.00 73004865090 0000000000 Preauthorized ACH Credit(165) 6.00 6.00 0.00 0.00 73004865306 0000000000 Credit Totals 29,364.01 29,364.01 0.00 0.00 Detail Debits M 1 6Ir ., i 'i tii, i �!4 Ebl 4�c yt Preauthorized ACH Debit(455) ✓ 1,103.00 73004231972 0000000000 Preauthorized ACH Debit(455) ✓ 286.65 73004371432 0000000000 Debit Totals 1,389.65 Totals —_- Bank Totals 0612212017 XXXX Total Credits 8 29,364,01 Total Debits 2 1.389.65 Report Totals 06/22/2017 Total Credits 8 29.364,01 Total Debits 2 1,389.65 Page 1 Previous Day ACH Report �10 Company:Palm Springs CA City of Bankof America'I Requestor:Arian Muniz Merrill Lynch Run Date:07/11/2017 13:25:06 CDT As of:0612312017 Bank of America,Southern California 1XXXX 661 XXXX 20001 City of Palm Springs General Acct(USD As of:06/23/2017 Detail Credits gMEMEM Preauthorized ACH Credit(165) 1,403,965.17 1,403,965.17 0.00 0.00 72010789454 0000000000 Preauthorized ACH Credit(165) 1,358 00772 1,358,007.72 0.00 0.00 72010789453 0000000000: Preauthorized ACH Credit(165) 10,814.90 10,814.90 0.00 0.00 74005088529 0000000000 Preauthorized ACH Credit(165) 3,294.00 3,294.00 0.00 0.00 74005088531 0000000000 Preauthorized ACH Credit(165) 3,116.00 3,116.DO 0.00 0.00 74005088530 0000000000 Preauthorized ACH Credit(165) 996.00 996,00 0.00 0.00 73013732709 0000000000 Preauthorized ACH Credit(165) 180.00 180.00 0.00 0.00 73011713739 0000000000 Preauthorized ACH Credit(165) 74,94 74,94 0.00 0.00 74005063563 0000600000 Preauthorized ACH Credit(165) 46.00 46.00 MO 0.00 74005063341 0000000000 Credit Totals 2,780,494.73 2,780,494.73 0.00 0.00 Detail Debits Preauthorized ACH Debit(455) ✓ 245,632.24 74004337410 0000000000 Preauthorized ACH Debit(455) / 66,879.48 74004530238 0000000000 ACH Settlement Debit(466) ✓ 1,009,244.05 74004891465 0000000000 ACH Settlement Debit(466) ✓ 175.00 74010446662 0000000000 Debit Totals 1,321,930.77 Totals Bank Totals 0 612 31211 7 XX fePpZ}b f} [f Yg@ i Total Credits 9 2,780,494,73 Total Debits 4 1,321,930.77 Report Totals 06/2312017 Total Credits 9 2,780,494.73 Total Debits 4 1,321,930.77 Pagel Previous Day ACH Report Company:Palm Springs CA City of Bankof America Requestor:Ariana Muniz Merrill Lynch Run Date:07/11/2017 13:26:20 CDT Y As of:0 612 612 01 7 Bank of America,Southern California JXXXX 661 XXXX 2000 1 City of Palm Springs General Acct I USD As of:06/26/2017 Detail Credits '�'4�Y�u�srl41 s�(ifi iSj'li�t!# ler,Ft i� S It;�e tliYypi� YYYY�p�o It �{� I41!f) ,��t� 'a6'�I��I� � II ll',u�i i�,�i � l Corporate Trade Payment Credit 58,880.00 58.880.00 0.00 0.00 77006672106 0000000000 (164) Preauthorized ACH Credit(165) 6,184,00 6,184.00 0.00 0.00 77608602514 0000000000 Preauthorized ACH Credit(165) 5,658.00 5.658.00 0.00 0.00 77007437374 0000000000 Preauthorized ACH Credit(165) 3.341.00 3,341.00 0,00 0.00 77007475650 0000000000 Preauthorized ACH Credit(165) 2,387.50 2,387.50 0.00 0.00 77007437373 0000000000 Preauthorized ACH Credit(165) 1,943.00 1,943.00 0.00 0.00 77008113446 0000000000 Preauthorized ACH Credit(165) 1,686.00 1,686.00 0.00 0.00 77003752592 0000000000 Preauthorized ACH Credit(165) 413.00 413.00 0.00 0.00 77006966542 0000000000 Preauthorized ACH Credit(165) 54.65 54.65 0.00 0,00 77007412577 0000000000 Preauthorized ACH Credit(165) 32.05 32.05 0.00 0.00 77007455170 0000000000 Credit Totals 80,579.20 80,579.20 0.00 0.00 Detail Debits �i (� � IG' Sl i •, y i' ryvt p+mt yr+jig xt;$1lf�'!yi V Y ,. ., 7 i"�'!' Preauthorized ACH Debit(455) 4,775.83 74011415317 0000000000 Debit Totals 4,775.83 Totals Bank Totals 06/26/2017 XXXX Total Credits 10 80,579.20 Total Debits 1 4,775.83 Report Totals 06/26/2017 Total Credits 10 80,579.20 Total Debits 1 4,775.83 Pagel Previous Day Wire Report BankofAmerica' Company:Palm Springs CA City of Requestor:Ariana Muniz Merrill Lynch Run Date:07/1112017 13:35:00 CDT As of:06/23/2017 Bank of America,Southern California J XXXX 661 XXXX 2000 1 City of Palm Springs General Acct USD As of:06/23/2017 Detail Debits y g 9 � �tM )P i ?.''S 4',��I 1 W� "�,r P et t ,r�� �P�t!I$; I Jt l,�J� � 4� M i(•�.,, 4 u�4 e iM s '16Pu6�'( )' 9,,�1'i�tP,�. Outgoing Money Transfer Debit(495) ✓ 25,814.37 00370417928 0000000000 Outgoing Money Transfer Debit(495) ✓ 19,619 83 00370417929 0000000000. Outgoing Money Transfer Debit(495) ✓ 8,293.75 00370417926 0000000000 Outgoing Money Transfer Debit(495) 684.10 00370417930 0000000000 Debit Totals K412.05 Totals Bank Totals 06123/2017 XXXXIM SEEM Total Credits 0 0.00 Total Debits 4 54,412.05 Report Totals 0612312017 Total Credits 0 0.00 Total Debits 4 54,412.05 Pagel