Loading...
HomeMy WebLinkAbout24246 RESOLUTION NO. 24246 A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF PALM SPRINGS, CALIFORNIA, APPROVING PAYMENT OF PAYROLL WARRANTS FOR THE PERIOD ENDED 05-20-2017 BY WARRANTS NUMBERED 419942 THROUGH 419955 TOTALING $28,508.70 LIABILITY CHECKS NUMBERED 1092447 THROUGH 1092467 TOTALING $82,397.60, FIVE WIRE TRANSFERS FOR $58,196.58, AND THREE ELECTRONIC ACH DEBITS OF $1,331,743.19 IN THE AGGREGATE AMOUNT OF $1,500,846.07, 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 419942 through 419955, liability checks numbered 1092447 through 1092467, 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 21 ST DAY OF JUNE, 2017. David H. Ready, Esq., Ph.D. City Manager ATTEST: 1L � - n Kathleen D. Hart, MM , 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. 24246 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 June 21, 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 4607 Kathleen D. Hart, MMC Interim City Clerk c Print Check List Execution#XXX 764 Function:RPCH Run By:SHARONR Run Start Data:May24,2017 5:56:21 PM Payroll Bank Account:XXXXX 661;XXXXXX 2000 From Pay Issue Date:May 26.2017 To Pay Issue Date:May 28,2017 Included Printed:Yes Include Unprinted:Yes Include Voided:Yes include Geared: Include Outstanding:Yes Include Reconciled: Include Vold Checks Only: Sort By:Check Number User Comment• Execution#XX 754 run by SHARONR using RPCH.docx• Prepared by ePersorWity 4.50.00.05 Rum May 24,2017 5:56:21 PM Print Cheek List Page 2 of z Sorted By:Check Number From:May 26,2017 To May 26,2017 Sank of America Tradsk:XXXXXBSI Account:XXXXXX2000 i"not yet prkdedt Check# Amuurtt Check Date Person Code Ott Check Tune Check Status 419942 2,275.10 May 26,2017 15839 Andrade,Jose Computer Check Outstanding 419M 1,430.28 May 26,2017 15905 Castillo,Jorge Computer Check Outstanding 4199" 4,918.09 May26,2017 16073 Kotkin,Edward Computer Check Outstanding 419945 210.16 May 26,M17 15784 Richards,Tabitha Computer Check Outstanding 419M 5,037.23 May 26,2017 15946 Dennehy,Thomas Computer Check Outstanding 419947 1,350.94 May 26,2017 10993 Huskey,Zachary 8 Computer Check Outstanding 419948 758.24 May 26,2017 15429 Vega,Krystle Computer Check Outstanding 419949 1,366.78 May 26,2017 16222 Hernandez,Francisco Computer Check Outstanding 419950 1,689.23 May 26,2017 04905 Leon,Arnulto H Computer Check Outstanding 419951 2,033.05 May 26.2017 10253 Mercado,Gilbert R Computer Check Outstanding 419952 1,365.28 May 26,2017 15968 Chavez,Aris 0 Computer Check Outstanding 419953 2,112.33 May 26,2017 15156 Menley,Charles A Computer Check Outstanding 419954 2,594,82 May 26,2017 15897 Doherty,Alexander Computer Check Outstanding 419955 1,368.17 May 26,2017 15833 Waits,Noel Computer Check Outstanding Total#Checks Reported:14 Total Check Amount Reported:328AN.70 Execution#XX 754 run by SHARONR using RPOH.docx, Prepared by*Personakty 4.50.00.05 SUNGARD PENTAMATION - FUND ACCOUNTING MANAGER PAGE NUMBER: 1 DATE: 05/25/17 CITY OF PALM SPRINGS ACCTPA21 TIME: 10:08:33 CHECK REGISTER INCLUDING SYSTEM VOI➢S ACCOUNTING PERIOD: 11/17 SELECTION CRITERIA: chkstat.rundate='05/26/2017' DISTRIBUTION FUND: 001 CHECK NUMBER ISSUE DATE VENDOR STATUS TOTAL DESCRIPTION 1092447 05/26/2017 AMERICAN GENERAL R 471.79 ACCOUNTS PAYABLE CHECK 1092448 05/26/2017 EMPLOYMENT DEVELOPMENT DE R 93.10 ACCOUNTS PAYABLE CHECK 1092449 05/26/2017 KANSAS PAYMENT CENTER R 284.50 ACCOUNTS PAYABLE CHECK 1092450 05/26/2017 GARNISHMENT R 1221.69 ACCOUNTS PAYABLE CHECK 1092451 05/26/2017 GARNISHMENT R 300.00 ACCOUNTS PAYABLE CHECK 1092452 05/26/2017 AFLAC R 120.45 ACCOUNTS PAYABLE CHECK 1092453 05/26/2017 DAVEY ADMIN GROUP R 9740.56 ACCOUNTS PAYABLE CHECK 1092454 05/26/2017 FIRE MANAGEMENT ASSOCIATI R 472.50 ACCOUNTS PAYABLE CHECK 1092455 05/26/2017 FRANCHISE TAX BOARD R 1360.68 ACCOUNTS PAYABLE CHECK 1092456 05/26/2017 LIBERTY MUTUAL INSURANCE R 1293.95 ACCOUNTS PAYABLE CHECK 1092457 05/26/2017 MANAGEMENT ASSN OF PALM S R 986.25 ACCOUNTS PAYABLE CHECK 1092458 05/26/2017 PALM SPRINGS FIREMENS ASS R 1775.52 ACCOUNTS PAYABLE CHECK 1092459 05/26/2017 POLICE OFFICERS' ASSOCIAT R 7380.26 ACCOUNTS PAYABLE CHECK 1092460 05/26/2017 RIVERSI➢E COUNTY SHERIFF R 75.00 ACCOUNTS PAYABLE CHECK 1092461 05/26/2017 SEIU LOCAL 721 CTW AND C R 2451.50 ACCOUNTS PAYABLE CHECK 1092462 05/26/2017 SUN COMMUNITY R 49755.90 ACCOUNTS PAYABLE CHECK 1092463 05/26/2017 UNITED WAY OF THE DESERT R 164.00 ACCOUNTS PAYABLE CHECK 1092464 05/26/2017 :GARNISHMENT R 152.00 ACCOUNTS PAYABLE CHECK 1092465 05/26/2017 PS FIRE SAFETY UNIT R 1908.65 ACCOUNTS PAYABLE CHECK 1092466 05/26/2017 GARNISHMENT R 620.50 ACCOUNTS PAYABLE CHECK 1092467 05/26/2017 TRANSAMERICA WORKSITE MAR R 1768.80 ACCOUNTS PAYABLE CHECK TOTAL FUND 82397.60 TOTAL REPORT 82397.60 Previous Day Wire Report Company:Palm Springs CA City of Bank of America Requestor:Ariana Muniz Merrill Lynch Run Date:06/14/2017 13:12:19 CDT J As of:05/26/2017 Bank of America,Southern California I XXXX 661 XXXX 2000 1 City of Palm Springs General Acct I USD I As of:05/26/2017 Detail Credits Incoming Money Transfer Credit 501,875.00 501,875.00 0.00 0.00 00370263546 0000000000 (195) Incoming Money Transfer Credit 7,577>78 7,577.78 0,00 0.00 00370321238 0000000000? r(195) Credit Totals 509,452.78 509,02.78 0.00 0.00 Detail Debits I'i 10 I II I pl I II I I I I I,I I I I ICI II� 4jj1'i III I III III III � (Ilfl(II`I dif i,11 lIIV 1�I It I'I IIII I� I I � I I I t�l yyI'���i I �jj id I� II III II I i i�111�I s�l I I'i III u�.f I Outgoing Money Transfer Debit(495) 1211635.21 00370050876 0000000000 Outgoing Money Transfer Debit(495) 60,559.38 00370050489 0000000000 Outgoing Money Transfer Debit(495) ✓ 25,449.37 00370035951 0000000000 Outgoing Money Transfer Debit(495) ✓ 19,219.83 00370035952 0000000000 Outgoing Money Transfer Debit(495) ✓ 8,243,75 00370035950 0000000000 Outgoing Money Transfer Debit(495) ✓ r 684.10 00370035949 0000000000 Debit Totals 225,791.64 Totals Bank Totals 05/26/2017 d (Ir��ll�l'II�I��IT�VY�r'�`f14'I Total Credits 2 509,452.78 Total Debits 6 225,791.64 Report Totals 05126/2017 RI 'Il 1 Total Credits 2 509,452.78 Total Debits 6 225,791.64 Pagel Previous Day ACH Report Company:Palm Springs CA City of Bankof America Requestor:Ariana Muniz Merrill Lynch Run Date:06/14/2017 12:23:31 CDT As of:05/26/2017 Bank of America,Southern California JXXXX 661 XXXX 2000 1 City of Palm Springs General Acd I USD I As of:0 512 612 01 7 Detail Credits ill Preauthorized ACH Credit(165) 10,945.48 10,945.48 0.00 0.00 46007808571 0000000000 Preauthorized ACH Credit(165) 5,006:00 5,006.00 0.00 0.00 46007808573 DOOOOOOQOQ Preauthorized ACH Credit(165) 2,606.00 2,606.00 0.00 0.00 46007808572 0000000000 Preauthorized ACH Credit(165) 1,250,00 1,250.00 0,00 0.00 45016029240 0000000000 Preauthorized ACH Credit(165) 706.00 706.00 0.00 0,00 45014432904 0000000000 Preauthorized ACH Credit(165) 71.00 71.00 0.00 0.00 46007783616 0600006000 Preauthorized ACH Credit(165) 23.00 23.00 0.00 0.00 46007783615 0000000000 Credit Totals 20,607.48 20,607A8 0.00 0.00 Detail Debits . I��iIInIlili�ll'Il�Yr��� llI I II Iili iPl�III� ��' ��� ��I ,�I�'l'i III��ll�II�I�, '�'illlP�i�' i��' PII �llllpi��ll Preauthorized ACH Debit(455) r/ 248,394.41 46006881869 0000000000 Preauthorized ACH Debit(455) ✓ 67,420.03 46007226481 0000000000 ACH Settlement Debit(466) v/ 1,015,753.75 46007587633 0000000000 ACH Settlement Debft(466) is 175.00 46013117337 6000000000 Debit Totals ' 1,331,743.19 Totals Bank Totals 05/26/2017 XXXX Total Credits 7 20,607.48 Total Debits 4 1,331,743.19 Report Totals 0 512 612 01 7 I Total Credits 7 20,607.4E Total Debits 4 1,331,743.19 10 Page 1 Previous Day ACH Report 10 Company:Palm Springs CA City of Merrill of America-1I Requestor:ArianaMunir Merrill Lynch Run Date:06/14/2017 13:16:23 CDT Y As of:05130/2017 Bank of America,Southern California I XXXX 661 XXXX 2000 1 City of Palm Springs General Acct i USD As of:05/30/2017 Detail Credits Corporate Trade Payment Credit 262,080.61 262.080.61 0.00 0.00 45014997084 0000000000 (164) _ Preauthorized ACH Credit(165) 39AW58 39 808.58 0.00 0.00 50013521268 0000000000 Preauthorized ACH Credit(165) 9,622.00 9,622.00 0.00 0.00 50015882348 0000000000 Preauthorized ACH Credit(165) 4,497.00 4,497.00 0.00 0.00 50014125742 ` 0000000000 Preauthorized ACH Credit(165) 4,082.00 4,082.00 0.00 0.00 50014163295 0000000000 Preauthorized ACH Credit(165) 3,83100 3,831.00 0.00 0:00 50014192261 ; D000000000 Preauthorized ACH Credit(165) 1,838.57 1,838.57 0.00 0.00 50014125741 0000000000 Preauthorized ACH Credit(165) 1.554.00 1,554.00 0.00 0.00 50010050686 0000000000 Preauthorized ACH Credit(165) 1,142.00 1,142.00 0.00 0.00 50009028316 0000000000 Preauthorized ACH Credit(165) 589,60 589.60 0.00 0.00 50013258917 0000000000 Preauthorized ACH Credit(165) 413.00 413,00 0.00 0.00 50015293255 0000000000 Preauthorized ACH Credit(165) 23.00 23.00 0.00 0.00 50014143223 0000000000 Preauthorized ACH Credit(165) 14.00 14.00 0.00 0.00 50014143342 0000000000 Credit Totals 329,495.36 329,495.36 0.00 0.00 Detail Debits Preauthorized ACH Debit(455) ✓ 4,599.53 46014810381 0000000000 De bltTotals 4,599,.53 Totals Bank Totals 05/30/2017 XXX r Total Credits 13 329,495.36 Total Debits 1 4,599.53 Report Totals 05/3012017 MAIN;!I III Total Credits 13 329,495.36 Total Debits 1 4,599.53 Page 1 Ariana Muniz From: Thomas Hays Sent: Thursday, May 25, 2017 1:47 PM To: Sharon Riddle; Rita Gustafson; Dolores Olvera; Ariana Muniz Cc: Nancy Klukan Subject: Payroll 052617 Federal and State Tax Payments Federal: EnteredPayment Information Data TaxpayerEIN xxxxx0757 Tax Form 941 Employers Federal Tax Tax Type`. FederalTaxDeposit Tax Period Q2/2017 Payment Amount $248,394:41 Settlement Date 05/26/2017 Subcategories: 1 Social Security $223.20 2 Medicare $45,155.08 3 TazlNithholding $203,01213 State: Payment Submission Date and Time(PST): 5/25/2017 Time: 1:44:24 PM EDD Employer Identification Number : 80098221 Deposit Schedule : Next bank Day Pay Date : 05/26/17 SDI Amount : $0.00 PIT Amount: $67,420.03 Total Amount : $67,420.03 Bank Debit Date : 05/26/17 Confirmation Number : 1294966 Thank you, THOMAS HAYS Deputy City Treasurer 3200 E.Tahquitz Canyon Way Palm Springs, CA 92263 (760)323-8223 direct thomas.hays@palmspringsca.my 1