Loading...
HomeMy WebLinkAbout24327 RESOLUTION NO. 24327 A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF PALM SPRINGS, CALIFORNIA, APPROVING PAYMENT OF PAYROLL WARRANTS FOR THE PERIOD ENDED 10- 07-2017 BY WARRANTS NUMBERED 420091 THROUGH 420104 TOTALING $23,724.36 LIABILITY CHECKS NUMBERED 1095041 THROUGH 1095060 TOTALING $79,717.11, FIVE WIRE TRANSFERS FOR $64,954.50, AND THREE ELECTRONIC ACH DEBITS OF $1,353,292.33 IN THE AGGREGATE AMOUNT OF $1,521,688.30, 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 420091 through 420104, liability checks numbered 1095041 through 1095060, 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 15T" DAY OF NOVEMBER, 2017. David H. Ready, Esq., P . City Manager ATTEST: tid hony J MC City Clerk Resolution No. 24327 Page 2 CERTIFICATION STATE OF CALIFORNIA ) COUNTY OF RIVERSIDE ) ss. CITY OF PALM SPRINGS ) I, ANTHONY J. MEJIA, City Clerk of the City of Palm Springs, hereby certify that Resolution No. 24327 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 15th day of November, 2017, by the following vote: AYES: Councilmembers Kors, Mills, Roberts, Mayor Pro Tern Foat, and Mayor Moon NOES: None ABSENT: None ABSTAIN: None IN WITNESS WHEREOF, I have hereunto set my hand and affixed the official seal of the City of Palm Springs, California, this 2 + day of 2cit 1 -- v Anthony J. p , City Clerk �p Print Check fist Execution #xxx 098 Function:RPCH Ruh By-SHARONR Run Start Date:Oct 12,201710:16.49 AM Payroll Bank Aceaunt;xxxxx 661,xxxxxx 2000 From Pay issue Date:Oct 13,2017 To Pay Issue Date:Oct 13,201? Included Printed:Yes Include ilnjprinted:Yes Inululle Yo dcd:Yes include Cleared: Include titan in0:Yes Include ReconulIed: Include V Id Checks Only: Sort By:Check Number User COPIn ent: x�ciitkin#p(098 run by SNAF,ONR using RPH.ippc- Qraparez!by ePersnaiity 5U W Q5. Run:Oct 12,2017 1016;49 AAA Print Check List Page 2 of 2 Sorted 8y:Check Number from:Oct 13,?017 To.`0013,2017 Bank o01 f AMe!tk Trans#1 XXXXX6s1 AG�ount XXxXXX 2000 �`not yea printed) Check# AD= Check Date Person Gode Ran Check Tj: C taus 420091 1,417.63 Od 13,2017 15839 And Jose Computer Check Outstanding 420092 1,470.42 Oct 13 2017 15905 Castillo,Jorge Computer Check 1JtltstatLdinO 420093 1,092.98 0013,1611 16099 Garcia,John Computer Check t staniiing 420094 1.909.73 Oct 13,2017 15784 Richards,Tabifha Computer Cho* Ou�tand ng 426095 31,374.43 Oct 13,2017 16100 Pendleton,Marla Computer Check Outstanding 420096 1,378.04 Oct 13.2017 10993 Huskey,Zachary 6 CornputBi Cho r (tag 420097 1,329.74 Oct 13,2017 15222 Hernandez,Francisco ComputerCheck a3ut$tat�ding *0098 1,414.A5 Oct 13,2017 04WS Leon,Amulfo H Computer Check OuteAapd.lng 420099 2,014 00 Oct 13,2017 10263 Mercarta,Gilbert R Computer Check Oundn� d24140 1,919:95 Oct 13,2017 1.5166 Manley,Charles A Computer Check C ?end g 424141 2,632.87 Oct 13,2017 16098 Sandoval,Kristin Computer Check OutstaWing 420102 1,762.61 Oct 13,2017 15833 WaU Noel Computer Ch 42 eek Outs#an"di►ig 0103 643.37 Oct 13,2017 16089 Halm,Mikael Computer Check Outst�tndDng 420104 956:14 Oct 13,2017 16097 Galloway,Patin Computer Chook, Outa"aft, Total#Cheeks Reported:14 Total Check Amount Reported.$2$,724.36 £Xecwtion#XX 098 run by SHARONR using RPCH.46ox P,nepared ty5 ei?ersana 4 ra0 OD},S}5 „.. SUNGARD PENTAMATION - FUND ACCOUNTING MANAGER PAGE NUMBER: 1 DATE: 10/12/17 CITY OF PALM SPRINGS ACCTPA21 TIME: 09:41:42 CHECK REGISTER INCLUDING SYSTEM VOIDS ACCOUNTING PERIOD: 4/18 SELECTION CRITERIA: chkSLat.rundate='10/13/2017' DISTRIBUTION FUND: 001 CHECK NUMBER ISSUE DATE VENDOR STATUS TOTAL DESCRIPTION 1095041 10/13/2017 AMERICAN FIDELITY ASSURAN R 581.57 ACCOUNTS PAYABLE CHECK 1095042 10/13/2017 EMPLOYMENT DEVELOPMENT DE R 93.10 ACCOUNTS PAYABLE CHECK 1095043 10/13/2017 KANSAS PAYMENT CENTER R 284.50 ACCOUNTS PAYABLE CHECK 1095044 10/13/2017 GARNISHMENT R 1008.46 ACCOUNTS PAYABLE CHECK 1095045 10/13/2017 AFLAC R 120.45 ACCOUNTS PAYABLE CHECK 1095046 10/13/2017 DAVEY ADMIN GROUP R 10149.64 ACCOUNTS PAYABLE CHECK 1095047 10/13/2017 FIRE MANAGEMENT ASSOCIATI R 472.50 ACCOUNTS PAYABLE CHECK 1095048 10/13/2017 FRANCHISE TAX BOARD R 100.00 ACCOUNTS PAYABLE CHECK 1095049 10/13/2017 LIBERTY MUTUAL INSURANCE R 1244.49 ACCOUNTS PAYABLE CHECK 1095050 10/13/2017 MANAGEMENT ASSN OF PALM S R 1016.25 ACCOUNTS PAYABLE CHECK 1095051 10/13/2017 PALM SPRINGS FIREMENS ASS R 1808,40 ACCOUNTS PAYABLE CHECK 1095052 10/13/2017 POLICE OFFICERS' ASSOCIAT R 8230.7E ACCOUNTS PAYABLE CHECK 1095053 10/13/2017 RIVERSIDE COUNTY SHERIFF R 75.00 ACCOUNTS PAYABLE CHECK 1095054 10/13/2017 SEIU LOCAL 721 CTW AND C R 2571.00 ACCOUNTS PAYABLE CHECK 1095055 10/13/2017 SUN COMMUNITY R 47233.33 ACCOUNTS PAYABLE CHECK 1095056 10/13/2017 UNITED WAY OF THE DESERT R 169.00 ACCOUNTS PAYABLE CHECK 1095057 10/13/2017 GARNISHMENT R 152.00 ACCOUNTS PAYABLE CHECK 1095058 10/13/2017 PS FIRE SAFETY UNIT R 2030.15 ACCOUNTS PAYABLE CHECK 1095059 10/13/2017 GARNISHMENT R 620.50 ACCOUNTS PAYABLE CHECK 1095060 10/13/2017 TRANSAMERICA WORKSITE MAR R 1756.01 ACCOUNTS PAYABLE CHECK TOTAL FUND 79717.11 TOTAL REPORT 79717.11 Previous Day Wire Report Company:Palm Springs CA City of Wi nkofAmed+ea' RIF Requestor:Ariana Muniz Merrill lymch Run Date:11106/201713:59:01 CST As of:1 OM 312 01 7 Bank of America,Southern California IXXXX 661 XXXX 20001 City of Palm Springs General Accl I USD I As of.1 011 31201 7 Detail Debits Outgoing Money Transfer Debit(495) / 27,506.03 00370026585 0000000000 Outgoing'Money Transfer Debit{495) ✓ 21:,440,66 00370026579 0000000000 Outgoing Money Transfer Debit(495) ✓ 8,900.00 00370026581 0000000000 Wpin Money Transfer Deb-it it(495) ✓ 684.10 �00370026577 00o00,00000 , Individual Auto Transfer DR(501) 100,000.00 00680002052 1713083015 peb�t Totals 156 b30 79 .:.i..i��........W.a.___' Totals Bank Totals 10/1312017 xxxx Total Credits 0 0.00 Total Debits 5 158,530.79 Report Totals 10/1312017 Total Credits 0 0.00 Total Debits 5 158,530.79 ka Page 1 Previous Day ACH Report + Company:Palm Springs CA City of Ranka'�At�et7Ca Requestor:Ariana Muniz Merritt Lynch Run Date: 11106/2017 14:17:51 CST As of:10/1612017 Bank of America,Southern California I XXXX 661 XXXX 2000 1 City of Palm Springs General Acct USD i As of:10/16/2017 Detail Credits Preauthorized ACH Credit(165) 553,772.66 553,772.66 0.00 0.00 86006730115 0000000000 Preauthorized ACH Credit(165) 9,829.00 9,829.00' G 0.00 0.00 169009501 00000000601 Preauthorized ACH Credit(165) 6,746.00 6,746.00 0.00 0.00 89008116907 0000000000 Preauthor ied ACH Credit(165), 5,020.00 5,920.01 0,00. 0.00 89008155369. 0000000000 Preauthorized ACH Credit(165) 2,84B.33 2,848.33 0.00 0.00 86007365550 0000000000 Preauthor(zed ACH Credit(165) 2,207,00 " 2,207.W 0.00 0.00 89009133405 0000000000 Preauthorized ACH Credit(165) 1,316.00 1,316.00 0.00 0.00 89008116906 0000000000 Preauthorized ACH Credit(165) 931.00 931.00 0.00 0.00 69003541$9$ 0000,00,0000 Preauthorized ACH Credit(165) 419.00 419.00 0.00 0.00 89007302671 0000000000 Preauthorized ACH Credit(165) 269.00 269'00 0.00 0.00 89 00809161 9 0000000D00'+ Preauthorized ACH Credit(165) 41 40.00 0.00 0.00 89007302672 0000000000 Preauthorized ACH Credit(165); W25 16.25. 0,00 0.00 89008091811 O000000000.i Credlt7otals •- 584,314.24 584,314 24, 0 Q0 0:00 ti i,.... i' Detail Debits Preauthorized ACH Debit(455) 6,423.71 86010295224 0000000000 Debit Totals i ` 6,423 77 a 7r ri Totals Bank Totals 1011612017 XXXX 31101,111 Total Credits 12 584,314.24 Total Debits 1 6,423.71 Report Totals 10/16/2017 Total Credits 12 684,314.24 Total Debits 1 6,423.71 Page 1 Previous Day ACH Report Company:Palm Springs CA City of Son0o Amedea Requestor:Ariana Muniz Lynch . Run Date:1110612017 1 3:56:12 CST @I"t`�ll - As of:IOM312017 Bank of America,Southern California I XXXX 661 XXXX 20001 City of Palm Springs General Acct i USD As of:10/13/2017 Detail Credits Preauthorized ACH Credit(165) 24,234.49 24,234.49 0.00 0.00 86004016607 0000000000 Preauthorized ACH Credit(165) 6,155 00 6,155,00: O.W. 0.00 86004016609 000000'0000 Preauthorized ACH Credit(165) 1,507.00 1.507.00 0.00 0.00 86004016608 0000000000 Preauthorized ACH Credit(165) 1 111.,13TO0 1,137.00; O.DO 0,00 ,85011784851 0000000000 Preauthorized ACH Credit(165) 952.90 952.90 0.00 0.00 85010057423 0000000000 Preauthorized ACH Credit(16$) 385.U0 385:00 0:00 O;DO, $6003991567 ! 000 000000 Preauthorized ACH Credit(165) 185.00 185.00 0.00 0.00 86003991471 0000000000 Preauthorized ACH Credit(155) 33 85 33.85 0.00 _0.00 86003991666 OOODODOODO Credit Totals 34 590.24 34,590 24' DOD Detail Debits Preauthorized ACH Debit(455) 251,996.57/86003275828 0000000000 Preauthorized ACH Debit(455)' Ff,933.77 '✓86003365207 DOOOODOD00 ACH Settlement Debit(466) 1,033,597.94 ✓86003784140 0000000000 ACH Settlement Debit(466) 17500 ✓. 8600913.5398 00000D0000 Debit Togls ,352 7D38 Totals Bank Totals 1011312017 XX ICI li� ! Total Credits 8 34,590.24 Total Debits 4 1,352,70328 Report Totals 10f1312017 Total Credits 8 34,590.24 Total Debits 4 1,352,703.28 Page 1 Ariana Muniz From: Thomas Hays Sent: Thursday,October 12, 2017 2:06 PM To: Sharon Riddle; Dolores Olvera;Ariana Muniz; Rita Gustafson Subject: Payroll 101317 Federal and State Tax Payments Federal: EnteredPayment Information Data T"Payer M jN=0767 Tax Form 941 Employers Federal Tax Tax Type .,Federal Tax Deposit Tax Period f20i7 PAyrrlent lunount 99fi.�a7 Settlement Date 1011312U1T Sulaeategpries: '2 ihedlc�r� ;�5,88�0;75 3 fax ft.' holding S205,892.62 State: Confirmation Number: 1787734 Payment Status:Scheduled Payment Submission Date and Time(PST) : 10/12/2017 01:54:05 PM EDD Employer Identification Number :80098221 Deposit Schedule: Next bank Day Pay Date :10/13/17 SDI Amount :$0.00 PIT Amount:$66,933.77 Total Amount:$66,933.77 Bank Debit Date: 10/13/2017 Regards, THOMAS HAYS Deputy City Treasurer 3200 E.Tahquitz Canyon Way Palm Springs,CA 92263 (760)323-8223 direct thomas.hays@palmspdngsca.gov i Ariana Muniz From: Thomas Hays Sent: Monday, November 06, 2017 11:49 AM To: Sharon Riddle; Dolores Olvera;Ariana Muniz; Rita Gustafson Cc: Marla Pendleton Subject: RE: Payroll 101317 Federal and State Tax Payments Importance: High Good morning, An error was made in the calculation of the taxes paid to the State for the 10/13/17 pay date.The amount paid was $66,933.77, as indicated in my 10/12/2017 email. Instead, $67,522.82 should have been paid to the State. Resultantly,the tax was underpaid by$589.05.The correcting payment was submitted to the State today, as indicated below: ------------------- Confirmation Number: 1872076 Payment Status:Scheduled Payment Submission Date and Time [PST) : 11/6/2017 11:19:21 AM EDD Employer Identification Number:80098221 Deposit Schedule: Next bank Day Pay Date :10/13/17 SDI Amount:$0.00 PIT Amount :$589.05 Total Amount:$589.05 Bank Debit Date : 11/7/2017 ------------------- Additionally,a Journal Entry has been prepared to correct the GL and is dated for 11/1/17. Please let me know if there are any questions or concerns. Respectfully, THOMAS HAYS Deputy City Treasurer 3200 E.Tahquitz Canyon Way Palm Springs, CA 92263 (760)323-8223 direct thomas.haysAoalmsprincisca.gov From:Thomas Hays Sent:Thursday, October 12, 2017 2:06 PM To:Sharon Riddle<Sharon.Riddle@palmspringsca.gov>; Dolores Olvera<Dolores.Olvera@oalmspringsca.gov>;Ariana Muniz<Ariana.Muniz@ pal mspringsca.gov>; Rita Gustafson<Rita.Gustafson@Palmspringsca.gov> Subject: Payroll 101317 Federal and State Tax Payments Federal: i y EnteredPayment Intormation Data Tav*Yer 6IN =W0757 Tax Form 944 Emp[ayers Federal Tax Tax Type Federal Tax0epoi3ft Tax period OW017 payment Amoun( 1S�.;xJ9C,5� Settlement gate 10t93t2O17 Subcateg�rios: f SopalSeCPtjr:` 320' 7 tdtadicpre45,880.7$ Tax Wrtlr6otdttt2t#539 tt2 State: Confirmation Number: 1787734 Payment Status:Scheduled Payment Submission Date and Time(PST) : 10/12/2017 01:54:05 PM EDD Employer Identification Number:80098221 Deposit Schedule : Next bank Day Pay Date : 10/13/17 SDI Amount :$0.00 PIT Amount :$66,933.77 Total Amount:$66,933.77 Bank Debit Date: 10/13/2017 Regards, THOMAS HAYS Deputy City Treasurer 3200 E.Tahquitz Canyon Way Palm Springs,CA 92263 (760)323-8223 direct thomas.hays(dwalmspringsca.00v 2 - -