Loading...
HomeMy WebLinkAbout24309 RESOLUTION NO. 24309 A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF PALM SPRINGS, CALIFORNIA, APPROVING PAYMENT OF PAYROLL WARRANTS FOR THE PERIOD ENDED 07-29-2017 BY WARRANTS NUMBERED 420018, 420020 THROUGH 420035 TOTALING $30,105.94 LIABILITY CHECKS NUMBERED 1093767 THROUGH 1093786 TOTALING $80,196.09, FIVE WIRE TRANSFERS FOR $61,551.87, AND THREE ELECTRONIC ACH DEBITS OF $1,437,054.91 IN THE AGGREGATE AMOUNT OF $1,608,908.81, 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 420018, 420020 through 420035, liability checks numbered 1093767 through 1093786, 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 26T" DAY OF S BER, 2017. David H. Ready, City Manager ATTEST: athleen 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. 24309 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 26th day of September, 2017, by the following vote: AYES: Councilmembers Kors, Roberts, Mayor Pro Tern Foat, and Mayor Moon NOES: None ABSENT: Councilmember Mills ABSTAIN: None RECUSED: None Kathleen D. Hart, MMC Interim City Clerk 0(p}'0 Pr nt:Cherck List Execution xxx gas Function:"RP�H Run By:00LORESt3 Run StartDMO:Aug 7,2017'6:19:68 PM Payroll Bank,Accountxxxxx 661,xxxxxx 2000 From Ray Issue totes"Jul 26,2017 To'Pay Usuo bake:.lui..25, 017 Inclu#ted fdoted:Yes Include Uitprlet8d:Yes IncloOe'yoi #d:Yes Inclgde Geared:Yes Includ#0otstnNdin ;Yes Include°116corkclled:Yes Inclu YoltlChteks:Only,N+o rtby;Check.Number user Comment: . Prea P1 AExecnxx 240 nm"hy OOLtR6S0 w 5tzt0 i5 Rum Aug 7,2017 5:19:58 PM Print CheckList ` Pa#a 2 of 2 Sorted By:Check dumber From:Jul 26,2011 To Jul 25,2017 Bank of America Transit:XXXXXM Account:XXXXXX 2M C not yet prinW8 Check AMOurd Check Data .E=gn Code Check�ype Cock 420018 1,466.36 Jul 25,2017 16064 Karban,Jane Computer Checlk OutatandJng Total#Checkt Reported:l Total Chekck Amount Reparted.51,486.38. Total#Chocks Cleared.,() Total Check Amount Cleared:$0.00 acec4+tion#XX 24B run by©[)LORESQ.using RPClt.doac XXXi1008 Prep9red lly Ol�arso€tality $il,Ctl r Print Check List Execution#xmi79' function:RPCH Run By:0MQRE$O Run Start Date:Aug 14.2017 2:51:20,PM Payroll BankAccount:xxxxx 661;XXXXXX 2000 From Pay issue"Date:.Aug 4,2017 ?a Pay"Issue tom:Aug 4,2017 1noluded Printed:Yes Inclu to tinprlhted:Yes lnoiutie Vold+ad:Yes inuiudsrod:Yes Inc lutl+aCuta»lifig:Yas i+ udo Fttsconc6i.Yes include Void Chec#is"< nly-No Stiff Py:Check Number User CommBrrt: Ex®tubQn#.XX Vi run by DQLOREWuemg RPCH.dccxXXX 9C108: Prepared l yaPereona - «QO.US Run:Aug 14,2Q17 ,6120 PM Print Chuck List Noe 2 of 2 Sorted By:Check Number from;Aug 4,2017 Ta:Aug 4,2017 Onnk of"rka TransitXXXXX 801 Account;XXXXXX 2000 (*not yet printed) Check AMqU Check Date Ppmon Code Mw Check MM Check IWO 420020 2 Ou ,098.41 Aug 4,2017 15839 Andrade,Jana ComputarChedt tstanding 420021 1,228.18 Aug 4,2017 15M Caspllo,Jorge Computr Check Outetand Ng 420022 1,855.22 Aug 4,2017 15784 Richards,Tabba Computer Check Outstendit g 420022 1,378 04 Aug 4,2017 109913 Huskey,?achary B Computer Check..; - Ouf tanding 420024 1,329.74 Aug 4,2017 15222 Hemandaz,Francisco Computer Check Outsianeing 420025 1,432,56 Aug 4,2017 04905 Lean,Amulic H Computer Check Ou jrlg 420026 1,990:83 Aug 4,2017 10253 Mercado,Gilbert R Compufertheck Outslan ling 420027 1,173.60 Aug 4,2017 16088 Majims,Marie A Computer,check Oliistar>d n9 42W28 .1,389 6$ Aug#,2017 16968 Chavez,Axis 0 Computer Check Out nidirill 420029 1,919 65 Aug 4,2617 15156 Manley,Charles A Computer Check in 420030 4,492.02 Aug 4,2017 10489 Rivera,Sylvla 1) Computer Check OutstaOdir 420031 4,622z18 Aug 4,2017 15375 don tut Alberto A Compuker:Chock f}ut8tar #zip 420032 2,556 55 Aug 4,2017 1WW Lopez,Alfredo Computer-Chadr O ndirit 420033 2,25071 Aug A,2017 46087 Lawrence,Troy S ComputarCheck Ou#ta+ lii19 420034 1001 Aug 4.2017 16833 Wafts,Noel ComputerChedc t3utsiatiding 420035 4702 Aug4,2017 16089 Haim;'Mikael Computes-Chadc Outatanding Total#Checks Reported:96 Total Check Amount Reportod:$28,639.6$ Total#:Checks Cleared:0 Total Check Amount Cleared:. 0.00 l)(6adion#XX 271.run by DOLOR ESO using RPCH.dPax XXX,1006 Pre Parscinali lr pared,by4 4 tl 00{l5 SUNGARD PENTAMATION - FUND ACCOUNTING MANAGER PAGE NUMBER: 1 DATE: 08/03/17 CITY OF PALM SPRINGS ACCTPA21 TIME: 11:41:48 CHECK REGISTER INCLUDING SYSTEM VOIDS ACCOUNTING PERIOD: 2/18 SELECTION CRITERIA: chkstat.rundate='08/04/2017' DISTRIBUTION FUND: 001 CHECK NUMBER ISSUE DATE VENDOR STATUS TOTAL DESCRIPTION 1093767 08/04/2017 AMERICAN FIDELITY ASSURAN R 615.92 ACCOUNTS PAYABLE CHECK 1093768 08/04/2017 EMPLOYMENT DEVELOPMENT DE R 93.10 ACCOUNTS PAYABLE CHECK 1093769 08/04/2017 KANSAS PAYMENT CENTER R 284.50 ACCOUNTS PAYABLE CHECK 1093770 08/04/2017 GARNISHMENT R 1008.46 ACCOUNTS PAYABLE CHECK 1093771 08/04/2017 AFLAC R 120.45 ACCOUNTS PAYABLE CHECK 1093772 08/04/2017 DAVEY ADMIN GROUP R 9893.27 ACCOUNTS PAYABLE CHECK 1093773 08/04/2017 FIRE MANAGEMENT ASSOCIATI R 472.50 ACCOUNTS PAYABLE CHECK 1093774 08/04/2017 FRANCHISE TAX BOARD R 561.12 ACCOUNTS PAYABLE CHECK 1093775 08/04/2017 LIBERTY MUTUAL INSURANCE R 1230.53 ACCOUNTS PAYABLE CHECK 1093776 08/04/2017 MANAGEMENT ASSN OF PALM S R 1031.25 ACCOUNTS PAYABLE CHECK 1093777 08/04/2017 PALM SPRINGS FIREMENS ASS R 1742.64 ACCOUNTS PAYABLE CHECK 1093778 08/04/2017 POLICE OFFICERS' ASSOCIAT R 7663.16 ACCOUNTS PAYABLE CHECK 1093779 08/04/2017 RIVERSIDE COUNTY SHERIFF R 75.00 ACCOUNTS PAYABLE CHECK 1093780 08/04/2017 SEIU LOCAL 721 CTW AND C R 2492.00 ACCOUNTS PAYABLE CHECK 1093781 08/04/2017 SUN COMMUNITY R 48044.57 ACCOUNTS PAYABLE CHECK 1093782 08/04/2017 UNITED WAY OF THE DESERT R 169.00 ACCOUNTS PAYABLE CHECK 1093783 08/04/2017 GARNISHMENT R 152.00 ACCOUNTS PAYABLE CHECK 1093784 08/04/2017 PS FIRE SAFETY UNIT R 2090.90 ACCOUNTS PAYABLE CHECK 1093785 08/04/2017 GARNISHMENT R 620.50 ACCOUNTS PAYABLE CHECK 1093786 08/04/2017 TRANSAMERICA WORKSITE MAR R 1835.22 ACCOUNTS PAYABLE CHECK TOTAL FUND 80196.09 TOTAL REPORT 80196.09 y�J s G Previous Day ACH Report Company:Palm Springs CA City of Bankof America Requestor:Ariana Muniz Merrill Lynch Run Date:08/2812017 21:31:17 CDT As of:08104/2017 Bank of America,Southern California JXXXX-661 XXXX 20001 City of Palm Springs General Acct I USD As of:0810412017 Detail Credits Preauthorized ACH Credit(165) 96.859.87 96,859.87 0.00 0.00 14015337594 0000000000 PreauthorizedACH.Credit'(166 0 502 00-:1: 60 79:1 3 Preauthorized ACH Credit(165) 3,351.00 3,351.00 0.00 0.00 16001502381 0000000000 Preauthorized ACH Cr##4(165) 122M0 1,221.5Q :0.00 .:.':0,00:1. 18O01502380 s 000.0.0.0,0000 Preauthorized ACH Credit(165) 830.00 830.00 0.00 0.00 15019370283 0000000000 Preauthorized AC14 Cr6d IQ!66). 82 7.UO 827.90 .00.1-: 0.00 150171D37 6 000b000000 Preauthorized ACH Credit(165) 7.00 7.00 0.00 0.00 16001477232 0000000000 Credit P� Totals ' 10,067 -v� "0,00 Detail Debits Preauthorized ACH Debit(455) hf 274,749.67 16000498568 0000000000 PreauthorizedI ACH EDebit(455) o/'�� 75,319.94 :-160009592531 .00000.60600" Preauthorized ACH Debit(455) ✓ 4,599.83 15019135945 0000000000 ACH Settlement Debit(405):: ✓1,066"55;3,0.::t::J.0 0000000000: ACH Settlement Debit(466) 175.00 16007117815 0000000000 DebitToials 1,,40;4Q9j4-' As of:0810312017 Bank of America,Southern California IXXXX,661 XXXX 2000 1 City of Palm Springs General Aw I USD I As of.08/0312017 Detail Credits Preauthorized ACH Credit(165) 374,334.76 374,334.76 0.00 0.00 13019548964 0000000000 .�:.Preauthorized'ACH.ct.e.d.it'(165) M020,84 20,020.84. 0.00 0.00 14015265081 0000000000 Preauthorized ACH Credit(165) 5,829.45 5.829.45 0.00 0.00 15009846267 0000000000' A5()09846269t::: �db.00660000 Preauthorized �1,4jpt. j 4,1349.00!,�- 0.0V 0.00 Preauthorized ACH Credit(165) 1,491.78 1,491.78 0.00 0.00 14015265083 0000000000 Preauthorized .00 D.00 1 15009,8.46268 466000*00 A 00 Preauthorized ACH Credit(165) 661.00 661.00 0.00 0.00 14017358656 0000000000 P it 0 Preauthorized 4.4.00 0.00, 0.00 :15009821316 E t i i OOOOQOQQOO 790, 0) ............. Preauthorized ACH Credit(165) 29.55 29.55 0.00 0.00 15009821315 0000000000 %C ;:,U0 "15009821100:- t.,OQ,.O 00. Preauthorize reditIl65F:;!:i�� �1'9 'w 9 dACK 61 0 .:0 ilkV& A niT V 713 �A.00 W Detail Debits Page 1 Previous Day Wire Report ij3' Company:Palm Springs CA City of Bank of America Requestor:Ariana Muniz Merrill lynch Run Date:08129/2017 12:51:49 CDT As of:0 810 412 01 7 Bank of America,Southern California JXXXX 661 XXXX 2000 i City of Palm Springs General Acct i USD i As of:0810412017 Detail Credits Incoming Money Transfer Credit 10,586.50 10,586.50 0,00 0.00' 00370290455 0000000000 (195) �rednTotals 10,560 10,5$650 x `i Qfiz 0_ Detail Debits d YI V Outgoing Money Transfer Debit(495) 27,196.03 00370381527 0000000000 Outgoing Money TYg0sf6r Debit(495) ✓,^ 20,465.66 0037038152$ b000000000 Outgoing Money Transfer Debit(495) ✓' 8,606.25 00370381518 0000000000 Outgoing Money Transfer Debit(495) J.' 684.10 00370381519 0000000000 Debit Totals ;56,952;04� x t't��' Totals Bank Totals 08104/2017 XXXX Total Credits 1 10,586.50 Total Debits 4 56,952.04 Report Totals 08/04/2017 li,ll l ' Total Credits 1 10,586.50 Total Debits 4 56,952.04 Pagel Previous Day ACH Report �� Company:Palm Springs CA City of Bankof America ijW Requestor:Ariana Muniz Merrill Lynch Run Date:08/29/2017 12:40:37 CDT As of:07/26/2017 Bank of America,Southern California IXXXX 661 XXXX 2000 1 City of Palm Springs General Acct i USD As of:07/26/2017 Detail Credits Ill. ICI �� Preauthorized A6H Credit(165) 5,505.48 5,505.48 0.00 0.00 07002484158 0000000000 Preauthorized ACH Credit(165) 4,869_,00- = 4,869.00 0.00 D,00 07002484159 OQQ4440000 Preauthorized ACH Credit(165) 3,981,00 3,981.00 0.00 0.00 07002484160 0000000000 Preauthorized ACH Credk(185) 1,088:00 1,088.00 0.00 0.00 06010929158, 0000000000 Preauthorized ACH Credit(165) 209,00 209.00 0.00 0.00 06009154499 0000000000 Preauthorized ACH Credit(165} 183.00 183.00 0.00 0.00 07002469659 000000D000 Preauthorized ACH Credit(165) 90.40 90.40 0.00 0.00 07002459875 0000000000 PreauthorizedACH;Credit(165) 88A0 88A0 0.00 0_fl0 06009154500 0000000000; Preauthorized ACH Credit(165) 75.00 75.00 0.00 0.00 07002459876 0000000000 Credit Totals 16 08'8 88 16,988.88 0.00 0.00 J Detail Debits f I I I �I i II I li I II Preauthorized ACH Debit(466) 276.30 07001958959 0000000000 PreauthtHzed ACH Debit(455) 58.67 07002048536 0000000000 Debtals 3$497 rt7a s �,. . Totals Bank Totals 07/26/2017 X. Total Credits 9 16,088.88 Total Debits 2 334.97 Report Totals 0 7/2 612 0 1 7 Total Credits 9 16,088.88 Total Debits 2 334.97 Pagel Ci Ariana Muniz From: Thomas Hays Sent: Thursday,August 03, 2017 12:56 PM To: Sharon Riddle, Rita Gustafson; Dolores Olvera;Ariana Muniz Subject: Payroll 08042017 Federal and State Tax Payments Federal: Payment Information Entered Data T yg E! z Q= Ell t' a,. „a. Tax Form 941 Employers Federal Tax �dEfa. r � {t`i' T x Type � Tax Period Q3/2017 Settlement Date 08/04/2017 7uf'✓Zv�-'4'a -t h h dx�- c h Y 4 n,d' -�F i4' F .. c 3�TaxrkAlthhold�np p �'°�`` � e State: Payment Submission Date and Time(PST) : 8/04/2017 Time: 12:56:04 PM EDD Employer Identification Number : 80098221 Deposit Schedule : Next bank Day Pay Date : 08/04/2017 SDI Amount : $0.00 PIT Amount : $75,319.94 Total Amount : $75,319.94 Bank Debit Date : 08/04/2017 Confirmation Number : 1552627 Regards, THOMAS HAYS Deputy City Treasurer 3200 E.Tahquitz Canyon Way Palm Springs, CA 92263 (760)323-8223 direct thomas.hays0yalmsaringsca.aov 1 G Ariana Muniz From: Thomas Hays Sent: Tuesday,July 25, 2017 2:05 PM To: Sharon Riddle; Rita Gustafson; Dolores Olvera;Ariana Muniz Subject: Payroll 07252017 Federal and State Tax Payments • Federal: Payment Information Entered Data �T xpay �'`"�^'""` "�x����� £�"�£��...3.% eF v �' � 4* �• y-_ fis .r.i5f ?..ice Tax Form 941 Employers Federal Tax Tax'Cmm 110 a �1s= ederal Tatt�eosit Tax Period Q3/2017 - n Settlement Date 07/26/2017 Supcategones � 3 , } '� State: Payment Submission Date and Time (PST) : 7/25/2017 Time: 2:04:44 PM EDD Employer Identification Number: 80098221 Deposit Schedule : Next bank Day Pay Date : 07/25/2017 SDI Amount : $0.00 PIT Amount : $58.67 Total Amount :$58.67 Bank Debit Date : 07/26/2017 Confirmation Number: 1517239 Regards, THOMAS HAYS Deputy City Treasurer 3200 E.Tahquitz Canyon Way Palm Springs,CA 92263 (760)323 8223 direct thomas.hays ..oalmsDdngsca.cLov 1 Thomas Hays From: Thomas Hays Sent: Tuesday,August 22,2017 8:40 AM To: Sharon Riddle; Rita Gustafson;Dolores Olvera;Ariana Muniz Subject RE:Payroll 08042017 Federal and State Tax Payments Importance: High Good morning, , There are two errors related to the payroll taxes paid on 8/04/17. 1. The tax withholding was reported incorrectly, by me, in the first email.The actual amount paid was$226,437.59. 2. Medicare was underpaid by$119.93.An additional payment was made today to reconcile the shortage: 'Payment Information Entered Data Taxpayer EIN xxxxx0757 Tax Form 941 Employers Federal Tax Tax Type Federal Tax Deposit Tax Period Q3/2017 Payment Amount $119.93 Settlement Date 08/23/2017 Subcategories: 2 Medicare $119.93 Sorry for the inconvenience.Please let me know if you have any questions or concerns. Regards, THOMAS HAYS Deputy City Treasurer 3200 E.Tahquitz Canyon Way Palm Springs,CA 92263 (760)323-8223 direct thomas.hays a)..Dalmsorinosca.gov 1 Ariana Muniz From: Thomas Hays Sent: Tuesday,August 29, 2017 7:05 PM To: Ariana Muniz Subject: Federal Tax$0.10 Difference Ariana, ' The Medicare portion of the federal taxes paid on 7/26/17 was underpaid by$0.10.The amount paid should have been $54.16, but$54.06 was paid instead by error: Payment Information -. Data MINOR X h, IF Q"^'�l,".-ra Tax Form 941 Employers Federal Tax TaxypeAw����5� � •ss uY. t{i er I�,.ax�De<�rk�� � a �' a , Tax Period 03/2017 -A. ;I -,+ ` c yx .c�.4 F' n «rL+�ir ' a `{w,w- a Sat-Yam` + +• -. Settlement Date 07/26/2017 u'.fd To reconcile the difference,the Medicare portion of the federal taxes paid on 8/18/17 was overpaid by$0.10.The amount required was$45,078.96, but$45,079.06 was paid instead: Payment Information Entered Data �Imlfix't K aIS Tax Form 941 Employers Federal Tax Tax Period Q3/2017 Settlement Date 08/19/2017 a r Please let me know if you have any questions or concerns. Regards, 1 THOMAS HAYS Deputy City Treasurer 3200 E.Tahquitz Canyon Way Palm Springs,CA 92263 (760)323-8223 direct thomas.hays(@Palmspdngsca.gov z