Loading...
HomeMy WebLinkAbout9/5/2018 - STAFF REPORTS - 1.M.RESOLUTION NO. A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF PALM SPRINGS, CALIFORNIA, APPROVING PAYMENT OF PAYROLL WARRANTS FOR THE PERIOD ENDED 06-02-2018 BY WARRANTS NUMBERED 420331, 420333- 420347, 420349 THROUGH 420350 TOTALING $29,476.88 LIABILITY CHECKS NUMBERED 1099475 THROUGH 1099494 TOTALING $76,706.84, FOUR WIRE TRANSFERS FOR $60,227.24, AND NINE ELECTRONIC ACH DEBITS OF $1,387,992.68 IN THE AGGREGATE AMOUNT OF $1,554,403.64, 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. NOW, THEREFORE BE IT RESOLVED by the City Council of the City of Palm Springs that payroll warrants numbered 420331, 420333 -420347, 420349 through 420350, liability checks numbered 1099475 through 1099494, four wire transfers and nine electronic ACH debits have been audited as required by law and that said warrants are hereby approved for payment. ADOPTED THIS 5TH DAY OF SEPTEMBER, 2018. ATTEST: Anthony J. Mejia, MMC, City Clerk STATE OF CALIFORNIA ) COUNTY OF RIVERSIDE ) ss. CITY OF PALM SPRINGS ) David H. Ready, Esq., Ph.D. City Manager CERTIFICATION I, ANTHONY J. MEJIA, City Clerk of the City of Palm Springs, hereby certify that Resolution No. __ 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 , by the following vote: AYES: NOES: ABSENT: ABSTAIN: IN WITNESS WHEREOF, I have hereunto set my hand and affixed the official seal of the City of Palm Springs, California, this day of _________ _ Anthony J. Mejia, MMC, City ClerkiTEM NO j . M . City of Palm Springs, California • ·---- 2 Print Check List Execution # XXX445 Function : RP CH Run By: OO LORE SO Run Start Date: Jun 25, 20 18 2:10:26 PM Payroll Bank Acc ount: XXXXXX661, XXXXXXX2000 From Pay Issue Date: May 29 , 20 18 To Pay Issue Date: May 29, 20 18 Included Printed: Yes Include Unprinted: Yes Include Voided: Yes Include Cleared : Yes Incl ude Outstanding : Yes Include Reconciled: Yes Include Void Checks Only: No Sort By: Ch eck Numbe r User Comment: Execut1on # XXX445 run by DOLORESO usmg RPCH .docx-XXXX1008 Prepared by ePersonaht y 4 .50.00 05 3 Run Jun 25 . 2018 2 10 26 PM Sorted By· Check Number Print Check List From May 29, 2018 To May 29 2018 Bank of America Transit : XXXXXX661 Account: XXXXXXX2000 (• not yet printed) Check # Amount Check Date Person Code Name 420331 1,052. 70 May 29 . 2018 16130 Limon , Julissa Total# Checks Reported : 1 Total Check Amount Reported : $1,052.70 Total# Checks C leared : 0 Total Check Amo unt Cl eared : $0 .00 Execution #XX~45 run by DOLORESO using RPCH .d ocx-XXXX!008 Page 2 of2 Check Type Check Status Computer Check Outstanding Prepared by ePersonality 4 .50 00 05 4 Print Check List Execution# XXX443 Function : RPCH Run By : DOLORESO Run Start Date: Ju n 2 5, 2018 2 :0 8:10 PM Payroll Bank Account: XXXXXX66 1, XXXXXXX20 00 From Pay Issue Date: Jun 8, 2 018 To Pay Issue Date: Ju n 8 , 2018 Included Printed : Yes Include Unprinted: Yes Include Voided: Yes Include Cleared: Yes Include Outstanding: Yes Include Reconciled : Yes Include Void Checks Only: No Sort By: Check Number User Comment: Execut1on # XXX443 run by DOLORESO using RPCH.docx-XXXX1008 Prepared by ePersonahty 4.50.00 05 5 Ru n Jun 25 2018 2.08.10 PM Sorted By : Check Number Print Check List From Jun 8. 018 T uno 2018 Ban k of A meri ca Transit: XXXXXX 66 1 Account: XXXXXXX2 00 0 (• not yet printed) C he ck# A11J.®nt _!:he~~ . .O.a t e Pers on Co d e ~ 420333 1,964.11 Jun 8, 2018 15839 Andrade, Jose 420334 1,901 .59 Jun 8, 2018 15905 Castillo, Jorge 420335 1,955.41 Jun 8, 201 8 15784 Richards , Tabitha 420336 2 ,763 .00 Ju n 8, 2018 16141 Jaime, Fran cisco 420337 2 ,963.89 Jun 8, 2018 16139 Uyeno , Donn 420338 1,324.16 Jun 8, 2018 16104 Keller, Ray 420339 1,476.37 Jun 8 , 2018 109 93 Huskey, Zachary 8 420340 2,361 .14 Jun 8 , 2018 15222 Hernandez, Francisco 420341 1,450.19 Jun 8, 2018 04905 Leon , Arnulfo H 420342 2 ,32 1.94 Jun 8, 2018 10253 Mercado, G ilbert R 420343 2 ,031 .10 Jun8,20 18 15156 Menley, Charles A 420344 1,605 .38 Jun 8, 20 18 15969 Freeman , Morgan E 420345 306 .99 Jun 8, 2018 15365 Weems, Cass ie L 420346 472 .86 Jun 8, 2018 16140 Devera , Sarah 420347 2 ,177.45 Jun 8, 2018 16135 Gomez, Fern ando Total# Checks Repo rted : 15 Total Ch eck Amo unt Re p orted : $27,075 .58 Tota l # Checks Cleare d: 0 Total Check Amount Cl e ared : $0.00 ExecutiO n # XXX443 run by DO LORESO usmg RPCH .docx-XXXX1008 Page 2 of 2 Chi>.ck il.rul Check Status Computer Check Outstanding Computer Check Outstanding Computer Check Outstanding Computer Check Outstand i ng Computer Check Outstanding Computer Check Outstandi ng Computer Check Outstanding Computer Check Outstanding Computer Check Outstanding Computer Check Outstandi ng Computer Check Outstanding Computer Check Outstanding Computer Check Outstanding Computer Check Outstanding Computer Check Outstand ing Prepared b y ePersonah ty 4 .50 00 05 6 Print Check List Execution # XXX447 Function : RPCH Run By: DOLORESO Run Start Date: Jun 25, 2018 2 :13:08 PM Payroll Bank Account:XXXXXX661, XXXXXXX2000 From Pay Issue Date: Jun 11 , 2018 To Pay Issue Date: Jun 11 , 2018 Included Printed: Yes Include Unprinted: Yes Include Voided: Yes Include Cleared: Yes Include Outstanding: Ye s Include Reconciled : Yes Include Void Checks Only: No Sort By: Check Number User Comment: Execution# XXX447 run by OOLORESO ustng RPCH.docx-XXXX1008 Prepared by ePersonali ty 4 50 00.05 7 Run : Jun 25, 2018 2 13 08 PM Sorted By . Check Number Pr int Check Lis t From Jun1 1 2018 To Jun11 2018 Bank of America Tran s it: XXXXXX661 Acco unt: XXXXXXX2000 (" not yet p r inted) Check# Amount Ch ec k Date Pers o n Co de Nam e 420349 797.78 Jun 11 ,20 18 15238 Castillo , Will ie V To ll iver, Karen 420350 550.82 Ju n11,2018 15530 To tal # Checks Reported : 2 Total Check Amount Reported : $1,348.60 Total # Ch ec ks Clea r ed : 0 Total Chec k Amount Cleared : $0 .00 Execution# XXX447 run by DOLORESO us1ng RPCH .docx -XXXX1008 Check Type Com puter Check Computer Check Pa ge 2 of 2 Check Statu§ Outst anding Outstanding Prepared by ePerso nali ty 4.50.0 0.05 8SUNGARD PENTAMATION -FUND ACCOUNTING MANAGER PAGE NUMBER: 1 DATE: 06/07/18 CITY OF PALM SPRINGS ACCTPA21 TIME: 11:00:53 CHECK REGISTER INCLUDING SYSTEM VOIDS ACCOUNTING PERIOD: 12/18 SELECTION CRITERIA: chkstat.rundate='06/08/2018' DISTRIBUTION FUND: 001 CHECK NUMBER ISSUE DATE VENDOR STATUS TOTAL DESCRIPTION 1099475 06/08/2018 AMERICAN FIDELITY ASSURAN R 516.78 ACCOUNTS PAYABLE CHECK 1099476 06/08/2018 EMPLOYMENT DEVELOPMENT DE R 93.10 ACCOUNTS PAYABLE CHECK 1099477 06/08/2018 KANSAS PAYMENT CENTER R 284.50 ACCOUNTS PAYABLE CHECK 1099478 06/08/2018 GARNISHMENT R 1025.54 ACCOUNTS PAYABLE CHECK 1099479 06/08/2018 AFLAC R 100.95 ACCOUNTS PAYABLE CHECK 1099480 06/08/2018 DAVEY ADMIN GROUP R 9358.57 ACCOUNTS PAYABLE CHECK 1099481 06/08/2018 FIRE MANAGEMENT ASSOCIATI R 112.50 ACCOUNTS PAYABLE CHECK 1099482 06/08/2018 FRANCHISE TAX BOARD R 905.68 ACCOUNTS PAYABLE CHECK 1099483 06/08/2018 LIBERTY MUTUAL INSURANCE R 1146.37 ACCOUNTS PAYABLE CHECK 1099484 06/08/2018 MANAGEMENT ASSN OF PALM S R 1031.25 ACCOUNTS PAYABLE CHECK 1099485 06/08/2018 PALM SPRINGS FIREMENS ASS R 1841.28 ACCOUNTS PAYABLE CHECK 1099486 06/08/2018 POLICE OFFICERS' ASSOCIAT R 8659.30 ACCOUNTS PAYABLE CHECK 1099487 06/08/2018 RIVERSIDE COUNTY SHERIFF R 75.00 ACCOUNTS PAYABLE CHECK 1099488 06/08/2018 SEIU LOCAL 721 CTW AND C R 2616.50 ACCOUNTS PAYABLE CHECK 1099489 06/08/2018 SUN COMMUNITY R 44159.35 ACCOUNTS PAYABLE CHECK 1099490 06/08/2018 UNITED WAY OF THE DESERT R 134.00 ACCOUNTS PAYABLE CHECK 10994 91 06/08/2018 GARNISHMENT R 152.00 ACCOUNTS PAYABLE CHECK 1099492 06/08/2018 PS FIRE SAFETY UNIT R 2230.60 ACCOUNTS PAYABLE CHECK 10994 93 06/08/2018 GARNISHMENT R 620.50 ACCOUNTS PAYABLE CHECK 1099494 06/08/2018 TRANSAMERICA WORKSITE MAR R 1643.07 ACCOUNTS PAYABLE CHECK TOTAL FUND 76706.84 TOTAL REPORT 76706.84 9 Ariana Muniz From: Sent: To: Cc: Subject: Importance: Federal : Th o mas Hays Wednesda y, June 6, 20 18 11:45 A M Do lores O lvera; Sh aro n Riddl e; A riana Muniz Marla Pend leton Pa yro ll Separation Ch ec k 5/29 /20 18 Federal and St ate Tax Pa y ments High EFT ACKNOWLEDGEM ENT NUMBE R: 27(}85 5804609451 PLEASE tJOTE -".n / amounts representee m the su~categones of Soci al Securitf. l.lecicare anc Income Tax •NIIhholding are for informational purposes onl y Payment Information Entered Data Taxpayer EIN Ta x Fo rm Tax Type Tax Peri od Payme nt Amo unt Settleme nt Dat e Subcategories: 2 Medicare 3 Tax \tVit hho ld ing Sta t e: XXXXX0 75 7 941 Emplo yers Federal Tax Fe de ra l Tax Deposit 0.2120 18 5 161 .20 06/07/2018 537.16 S1 2 .f .04 10 Payment Submission Date and Time (PST): 6 f612018 Time: 11 :44:56 AM State Di sability Insurance( SOl} Tax. and California Personal Income Tax (PIT} EDD Employer Identification Number: Bank Account: Deposit SOl 80098221 ~2 000 PIT Total Schedule Pay Date Amount Amount Amount Next bank Day Regards, 05/29 /18 $0.00 S27.29 THOM AS HAY S Deputy City Tr eas ure r 3200 E. Tahquitz Canyon Way Palm Springs , CA 92263 (760) 323-8223 direct thomas .hays@pa lmspringsca .gov 527.29 Bank Debit Date 06 /07/18 2 Confirrnati on Number 2582334 11 Dolores Olvera Fr om: Thomas Hays Se nt: Monday, June 11, 20 18 2:50 PM To: Cc: Sharon Riddle; Dolores Olvera; Ariana Muniz Marla Pendleton S ubject: Payroll 6/11/2018 Federal and State Taxes Importance: High Fede r al : EFT ACKNOWLEDGEME tiT NUMBER: 2708563 34936127 PLEASE tJOTE M y amoun ts represented In the suoca te gones of Social Secunty, l,ledlcare . and Income Tax WithholdinQ are for Informational purposes onl y Paym ent Information Ent ered Data Taxpayer EIN xxxxx0757 Tax Form 941 Employers Federal Tax Tax Type Federal Tax Deposit Tax Period 0212018 Payment Amoun t 586 .13 Settle ment Dat e 06 /1212 018 Subcategories: 2 Medicare 544 .42 3 Tax Withholding 541 .71 St at e: State Disability Insurance{ SOl) Tax and Calif ornia Personal I n come Tax (PIT) EDD Employer Identification Nu mber: Bank A ccount : Deposit Schedule Pay Date Next 06/11/18 bank Day 80098221 SOl PfT Amount A mount $0.00 $8.41 TH OMAS HAY S Depu ty City Treasu rer Total Amount $8.41 3200 E. Tahquitz Canyon Way Palm Springs, CA 92263 Bank Debit Date 06/12118 Confirmati on Nu mber 2594063 1 12 Previous Day ACH Report Company: Palm Springs CA City of Requestor : Aria na Muniz Run Date: 08/22/2018 19:30:08 COT As of: 06/08/2018 Bank of America, Southern California I XXXXXX 661 XXXXXX2000 I City of Pa l m Springs General Acct I USD I As of: 06 /08/2018 Detail Credits [Transaction II Amount ,I 0 Day Preauthorized ACH Credit (165) Preauthorized ACH Credit (165) Preauthorized ACH Cr edit (165) Preauthorized ACH Credit (165) Preauthorized ACH Credit (165) Preauthorized ACH Credit (165) Preauthorized ACH Credit (165) Preauthorized ACH Credit (165) Credit Totals Detail Debits ---- Transaction Preauthorized ACH Deb it (455) Preauthorized ACH Debit (455) Prea utho rized ACH Debit (455) Preauthorized AC H Debit (455) ACH Settle ment Debit (466) ACH Settlement Debit (466) De bit Totals Totals Bank Totals 06/08/201 8 Tota l Credits Total Debit s Report Totals 06/08/2018 USD Totals Tota l Cred its Total Deb its 8 6 8 6 14,402.68 5,163.00 3,950.80 3,457.21 1,200.00 509 .00 95.00 3.00 28,780.69 --~- Amount ./ 219,413.69 ,/ 67,185 .30 4,93 1.98 1,549.00 ./ 1,094 ,639.45 ./ 200.00 1,387,919.42 28,780 .69 1,387,919.42 28,780.69 1 ,387,919.42 h 1 Day Float 14,402.68 0.00 5,163.00 0.00 3,950.80 0.00 3,457.21 0.00 1,200.00 0.00 509 .00 0.00 95.00 0.00 3.00 0.00 28 ,780.69 0.00 Bank Ref 58012381724 59009131863 58012381772 59009131865 59009642449 59014628933 Page 1 ] Bank of America~ Merrill Lynch 2+ Day Float [Bank Ref 0.00 59009887729 0000000000 0.00 59009887731 000000000 0 0.00 59009887730 0000000000 0.00 58008750363 0000000000 0.00 58017558916 000000 0000 0.00 59009861497 0000000000 0.00 59009861284 0000000000 0.00 59009861496 00000000 00 0.00 Cust Ref 0000000000 0000000000 0000000000 0000000000 0000000000 0000000000 13 Previous Day ACH Report Company: Palm Springs CA City of Requestor : Ari an a Muniz Run Date: 08/22/2018 19:4 1:11 CDT As of: 06/07/2018 Bank of America, Southern Ca l ifornia I XXXXX661 XXXXX2000 I City of Pa lm Springs General Acct I USD I As of: 06 /07 /2018 Detail Credits 1 Transaction Preauthorized ACH Cre dit (165) Preauthorized ACH Cre dit (165) Preauthorized ACH Cre dit (165) Preauthorized ACH Credit (165) Preauthorized ACH Credit (165) Preauthorized ACH Cre dit (165) Preauthorized ACH Credit (165) Preauthorized ACH Credit (165) Preauthorized ACH Credit (165) Preauthorized ACH Credit (165) Prea uthorized ACH Cred i t (165) Credit Total s Detail Debits Transaction Preauthorized ACH Debit (455) Preauthorized ACH Debit (455) Preauthorized ACH Debit (455) Debi t Totals Totals Bank Tota ls 06 /07 /2018 Amount 0 Day 36 ,740 .50 36,740 .50 17,388.96 17,388 .96 5,222 .17 5,222.17 4,380 .00 4 ,380.00 4 ,214.00 4 ,214.00 1,107.00 1,107.00 1,093 .00 1,093.00 1,033.00 1,033.00 585.00 585.00 40 .00 40.00 7.25 7 .25 71,810 .88 71,810 .88 Amount Bank Ref 377.560.92 58008 182098 ,/ 161 .2 0 58007916460 ../ 27.29 58008 165279 --- 377 ,749 .41 Bank of America, Southern California 1 XXXXX661 (USD) Totals Total Credits Total Debits Report Tota ls 06/07/2018 USD Totals Total Credits Total Debits 11 3 Count 11 3 Amount 71 ,8 10.88 ---- Amount 377,749.4 1 71 ,810.88 377 ,749 .41 Page 1 1 Day Float 0 .00 0 .00 0 .00 0.00 0 .00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 ~~ BankofAmerica ~ Merrill Lynch 2+ Day Float Bank Ref 0.00 57003260253 0000000000 0 .00 560 18752 183 0000000000 0 .00 58009036545 0000000000 0 .00 58009036546 0000000000 0 .00 58009036547 0000000000 0.00 57015957653 0000000000 0 .00 57 014003966 0000000000 0 .00 57014003965 0000000000 0 .00 58009010278 0000000000 0.00 57014003967 0000000000 0.00 58009010495 0000000000 0.00 Cust Ref 0000000000 0000000000 0000000000 14 Previous Day ACH Report Company: Palm Springs CA City of Requestor : Ariana Muniz Run Date : 08 /22/201 8 19 :42:09 CDT As of: 06/12/2018 B ank of A m eri ca , Southern Ca lifornia I XXXXX661 XXXXX2000 I City of Palm Springs Genera l Acct I USD I As of: 06 /12/2018 Detail Cre-"-di"-ts'------- [ '--T~ra_n_s_ac_t_io_n _______ ~_...ll Amount Jl 0 Day ,l 1 Day Float Pre authorized ACH Credit (165) 13 ,696.64 13 ,696.64 0.00 Preauthorized ACH Credit (165) Preauthorized ACH Credit (165) Preauthorized ACH Credit (165) Pre auth orized ACH Credit (165) Preau thor ized ACH Credit (165) Prea uthorized ACH Cre dit (16 5) Preauthorized ACH Credit (165) Preauthorized ACH Credit (165) Preauthorized ACH Credit (165) Preauthorized ACH Cred it (165) Credit Totals Detail Deb:.:.cit=s __ Transaction Preauthorized ACH Debit (455) Preau thorized ACH Debit (455) Debit Totals Totals Bank Totals 06/12/2018 Totals Total Credi ts Total Debits Report Totals 06/12/2018 uso Totals Total Credits Total Debits Count 11 2 Count 11 2 Amount Amount 6,685.00 6,685.00 0 .00 2,097.00 2,097.00 0.00 1,361.00 1,36 1.00 0.00 701.30 701.30 0.00 367.00 367.00 0 .00 182.00 182.00 0.00 182.00 182.00 0.00 99.70 99 .70 0.00 30.50 30 .50 0.00 9.00 9.00 0.00 25,411.14 25,411.14 0.00 Amount II B ank Ref ./ 86.13 63007018183 / 8.41 63007294873 94 .54 25,411.14 94.54 25,411.14 94 .54 Page 1 Bank of America~ Merrill Lynch Bank Ref ~[ CustRef l 0.00 63008083399 0000000000 0.00 63008083401 0000000000 --- 0 .00 63008083400 0000000000 0.00 62025239750 0000000000 0.00 62023486031 0000000000 0.00 63008059512 0000000000 0.00 62023487801 0000000000 0.00 62023489768 0000000000 0.00 62023489735 0000000000 0.0 0 63008059511 0000000000 0 .00 63008059324 0000000000 0.0 0 Cust Ref 0000000000 00000 00000 15 Previous Day ACH Report Company: Palm Springs CA City of Requestor : Ariana Muniz Run Date: 08/22/2018 19:57:37 COT As of: 06/1 1/2018 Bank of America, Southern California 1 XXXXX661 XXXXX2000 I City of Palm Springs Genera l Acct I USD I As of: 06/11/2018 Detail Credits Transaction Preauthorized ACH Credit (165) Preauthorized ACH Credit (165) Preauthorized ACH Credit (165) Preauthorized ACH Credit (165) Preauthorized ACH Credit (165) Preauthorized ACH Credit (165) Preauthorized ACH Credit (165) Preauthorized ACH Credit (165) Preauthorized ACH Credit (165) --- Preauthorized ACH Credit (165) Preauthorized ACH Credit (165) Preauthorized ACH Credit (165) Credit Total s D etail Debits Transaction Preauthorized ACH Debit (455) Preauthorized ACH Deb it (455) Debit Totals Totals Bank Totals 06/11/2018 Amount I 0 Day 7,4 83.00 5,5 58 .00 5,058.60 4,383.00 2,251.00 1,426.00 691 .00 157.00 65.50 27.50 26.00 2.25 27,128.85 Amount J 6,271 .21 4 ,563 .76 10,834.97 Bank of America, Southern California 1 XXXXX661 (USD ) Total s Total Credits Total Debits Report Total s 06/11 /2018 USD Total s Total Credits Total Debits 12 2 Count 12 2 Amount Amount 27,128.85 10,834.97 27 ,128 .85 10,834 .97 1[1 Day Float 7,483.00 0 .00 5 ,558.00 0.00 5,0 58 .60 0.00 4,383.00 0.00 2,251.00 0.00 1,426.00 0.00 691.00 0.00 157.00 0.00 65.50 0.00 27.50 0.00 26.00 0.00 2.25 0.00 27,128.85 0.00 Bank Ref 59016940845 6201 1466245 Page 1 BankofAmerica~ Merrill Lynch 2+ Day Float Bank Ref 0 .00 620 15945 182 0000000000 0 .00 620 14404459 0000000000 0 .00 620 1436284 1 0000000000 0 .00 6201 4362842 0000000000 0.00 62015511225 0000000000 0.00 62011313927 0000000000 0.00 62014336574 0000000000 0.00 62013849975 0000000000 0.00 62014382764 0000000000 0.00 62015945181 0000000000 0.00 62014404458 0000000000 0.00 62014 336775 0000000000 0.00 Cust Ref 0000000000 0000000000 16 Previous Day Wire Report Company: Palm Springs CA City of Requestor: Ariana Muniz Run Date: 08/22/2018 20:04 :4 0 COT As of: 06/08 /2018 Bank of America, Southern California 1 XXXXXX661 XXXXX2000 I City of Pa lm Springs General Acct 1 USD 1 As of: 06/08/2018 Detail Credits [Transaction Amount I 0 Day I. 1 Day Float ] incom ing Money Transfer Credit (195) Credit Totals 8,500.00 8,500.00 0.00 8,500.00 8 ,500.00 0.00 Detail Debit:=s ___ _ ------- Transaction Outgoi ng Money Transfer Debit (495) Outgoing Money Transfer Debit (495) Outgoing Money Transfer Debit (495) Outgoing Money Transfer Debit (495) Outgoing Money Transfer Debit (495) Outgoing Money Transfer Debit (495) Outgoing Money Trans fer Debit (495) Debit Totals Total s Bank Totals 06/08/2018 Total Credits Total Debits Rep ort Totals 06/08 /2018 USD Totals Total Credi ts Tota l Deb its 7 7 Amount Bank Ref 3,000,000.00 00370413617 117,985 .50 00370413612 28,003.15 ./00370413613 24,750.34 00370413615 22,120.06 ('00370413614 9,406.25 /00370413616 697 .78 /oo3704 13611 3,202,963.08 8,500.00 3,202,963.08 8,500.00 3,202,963.08 Page 1 BankofAmerica~ Merrill Lynch Bank Ref 0.00 00370293740 0 .00 Cust Ref 0000000000 0000000000 0000000000 0000000000 0000000000 0000000000 0000000000 0000000000 17 RESOLUTION NO. A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF PALM SPRINGS, CALIFORNIA, APPROVING PAYMENT OF CLAIMS AND DEMANDS BY WARRANTS NUMBERED 1099495 THROUGH 1099619 IN THE AGGREGATE AMOUNT OF $700,468.40 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 claims and demands shown on the attached list; and WHEREAS, the Director of Finance hereby certifies to the accuracy of said records and to the availability of funds for payment. riaL. Pendl , CPA I terim Director o Finance and Treasurer NOW, THEREFORE BE IT RESOLVED that claims and demands numbered 1099495 through 1099619 have been audited as required by law and that said warrants are hereby approved for payment. ADOPTED THIS 5TH DAY OF SEPTEMBER, 2018. ATTEST: Anthony J. Mejia, MMC, City Clerk STATE OF CALIFORNIA ) COUNTY OF RIVERSIDE ) ss. CITY OF PALM SPRINGS ) David H. Ready, Esq., Ph.D. City Manager CERTIFICATION I, ANTHONY J. MEJIA, City Clerk of the City of Palm Springs, hereby certify that Resolution No. ___ 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 , by the following vote: AYES: NOES: ABSENT: ABSTAIN: IN WITNESS WHEREOF, I have hereunto set my hand and affixed the official seal of the City of Palm Springs, California, this day of _________ _ Anthony J. Mejia, MMC, City Clerk City of Palm Springs, California 18SUNGARD PENTAMATION -FUND ACCOUNTING MANAGER PAGE NUMBER: 1 DATE: 06/07/18 CITY OF PALM SPRINGS ACCTPA21 TIME: 16:20:31 CHECK REGISTER INCLUDING SYSTEM VOIDS ACCOUNTING PERIOD: 12/18 SELECTION CRITERIA: chkstat.rundate='06/07/2018' DISTRIBUTION FUND: 001 CHECK NUMBER ISSUE DATE VENDOR STATUS TOTAL DESCRIPTION 1099495 06/07/2018 ACCESS BEYOND MEASURE R 5800.00 ACCOUNTS PAYABLE CHECK 1099496 06/07/2018 ABRAHAM AGRIAM R 183.00 ACCOUNTS PAYABLE CHECK 1099497 06/07/2018 AIRWAVE COMMUNICATIONS EN R 1027.87 ACCOUNTS PAYABLE CHECK 1099498 06/07/2018 ASTRETECH, LLC R 2600.00 ACCOUNTS PAYABLE CHECK 1099499 06/07/2018 AT & T R 376.51 ACCOUNTS PAYABLE CHECK 1099500 06/07/2018 BACK NINE GREENS INC R 600.00 ACCOUNTS PAYABLE CHECK 1099501 06/07/2018 BAKER AND TAYLOR BOOKS R 62.90 ACCOUNTS PAYABLE CHECK 1099502 06/07/2018 BEST BEST & KRIEGER R 34559.81 ACCOUNTS PAYABLE CHECK 1099503 06/07/2018 BIG LEAGUE DREAMS R 1667.00 ACCOUNTS PAYABLE CHECK 1099504 06/07/2018 BRODART CO R 3779.76 ACCOUNTS PAYABLE CHECK 1099505 06/07/2018 CARL WARREN AND COMPANY R 3425.00 ACCOUNTS PAYABLE CHECK 1099506 06/07/2018 CASC ENGINEERING R 12723.39 ACCOUNTS PAYABLE CHECK 1099507 06/07/2018 CDR DATA CORPORATION R 493.15 ACCOUNTS PAYABLE CHECK 1099508 06/07/2018 CLASSIC AUTO RESTYLING R 195.00 ACCOUNTS PAYABLE CHECK 1099509 06/07/2018 CLEARS INC R 50.00 ACCOUNTS PAYABLE CHECK 1099510 06/07/2018 COLANTUONO HIGHSMITH AND R 280.00 ACCOUNTS PAYABLE CHECK 1099511 06/07/2018 COTA COLE AND HUBER LLP R 23459.18 ACCOUNTS PAYABLE CHECK 1099512 06/07/2018 COUNTY OF RIVERSIDE ENVIR R 1683.00 ACCOUNTS PAYABLE CHECK 1099513 06/07/2018 COUNTY OF RIVERSIDE ENVIR R 1675.00 ACCOUNTS PAYABLE CHECK 1099514 06/07/2018 COUNTY OF RIVERSIDE ENVIR R 1601.00 ACCOUNTS PAYABLE CHECK 1099515 06/07/2018 COUNTY OF RIVERSIDE ENVIR R 827.00 ACCOUNTS PAYABLE CHECK 1099516 06/07/2018 COUNTY OF RIVERSIDE ENVIR R 2342.00 ACCOUNTS PAYABLE CHECK 1099517 06/07/2018 COUNTY OF RIVERSIDE ENVIR R 1085.00 ACCOUNTS PAYABLE CHECK 1099518 06/07/2018 COUNTY OF RIVERSIDE ENVIR R 827.00 ACCOUNTS PAYABLE CHECK 1099519 06/07/2018 COUNTY OF RIVERSIDE ENVIR R 827.00 ACCOUNTS PAYABLE CHECK 1099520 06/07/2018 COUNTY OF RIVERSIDE ENVIR R 827.00 ACCOUNTS PAYABLE CHECK 1099521 06/07/2018 COUNTY OF RIVERSIDE ENVIR R 827.00 ACCOUNTS PAYABLE CHECK 1099522 06/07/2018 COUNTY OF RIVERSIDE ENVIR R 827.00 ACCOUNTS PAYABLE CHECK 1099523 06/07/2018 COUNTY OF RIVERSIDE ENVIR R 827.00 ACCOUNTS PAYABLE CHECK 1099524 06/07/2018 DELL MARKETING LP R 1121.90 ACCOUNTS PAYABLE CHECK 1099525 06/07/2018 DESERT FIRE EXTINGUISHER R 1253.67 ACCOUNTS PAYABLE CHECK 1099526 06/07/2018 DESERT PROMOTIONAL EMBROI R 460.63 ACCOUNTS PAYABLE CHECK 1099527 06/07/2018 DESERT WATER AGENCY R 20411.66 ACCOUNTS PAYABLE CHECK 1099528 06/07/2018 DIAMOND ENVIRONMENTAL SER R 379.11 ACCOUNTS PAYABLE CHECK 1099529 06/07/2018 DIRECT ENERGY BUSINESS MA R 6128.73 ACCOUNTS PAYABLE CHECK 1099530 06/07/2018 DOKKEN ENGINEERING R 3339.49 ACCOUNTS PAYABLE CHECK 1099531 06/07/2018 ESGIL LLC R 45086.10 ACCOUNTS PAYABLE CHECK 1099532 06/07/2018 FEDERAL EXPRESS CORPORATI R 84.56 ACCOUNTS PAYABLE CHECK 1099533 06/07/2018 FRANKLIN TRUCK PARTS INC R 182.60 ACCOUNTS PAYABLE CHECK 1099534 06/07/2018 GRANICUS INC R 1901.45 ACCOUNTS PAYABLE CHECK 1099535 06/07/2018 HARRIS AND ASSOCIATES INC R 5880.00 ACCOUNTS PAYABLE CHECK 1099536 06/07/2018 HIGH LINE CORPORATION R 2700.00 ACCOUNTS PAYABLE CHECK 1099537 06/07/2018 HIRED HANDS GRAPHIC DESIG R 1250.00 ACCOUNTS PAYABLE CHECK 1099538 06/07/2018 HITECH LIGHTS R 1650.00 ACCOUNTS PAYABLE CHECK 1099539 06/07/2018 IMAGE SOURCE R 115.75 ACCOUNTS PAYABLE CHECK 1099540 06/07/2018 IMAGE360 PALM DESERT R 1596.21 ACCOUNTS PAYABLE CHECK 1099541 06/07/2018 INTERWEST CONSULTING GROU v 0.00 VOID: MULTI STUB CHECK 1099542 06/07/2018 INTERWEST CONSULTING GROU v 0.00 VOID: MULTI STUB CHECK 1099543 06/07/2018 INTERWEST CONSULTING GROU R 35930.00 ACCOUNTS PAYABLE CHECK 1099544 06/07/2018 KEENAN AND ASSOCIATES R 65000.00 ACCOUNTS PAYABLE CHECK 1099545 06/07/2018 LIEBERT CASSIDY WHITMORE R 26869.50 ACCOUNTS PAYABLE CHECK 1099546 06/07/2018 LOOPNET INC R 119.00 ACCOUNTS PAYABLE CHECK 1099547 06/07/2018 LYNBERG AND WATKINS APC R 23910.71 ACCOUNTS PAYABLE CHECK 1099548 06/07/2018 MBCA ENTERPRISES DBA MIKE R 3423.96 ACCOUNTS PAYABLE CHECK 19SUNGARD PENTAMATION -FUND ACCOUNTING MANAGER DATE: 06/07/18 CITY OF PALM SPRINGS TIME: 16:20:31 CHECK REGISTER INCLUDING SYSTEM VOIDS SELECTION CRITERIA: chkstat.rundate='OG/07/2018' 1099549 1099550 1099551 1099552 1099553 1099554 1099555 1099556 1099557 1099558 1099559 1099560 1099561 1099562 1099563 1099564 1099565 1099566 1099567 1099568 1099569 1099570 1099571 1099572 1099573 1099574 1099575 1099576 1099577 1099578 1099579 1099580 1099581 1099582 1099583 1099584 1099585 1099586 1099587 1099588 1099589 1099590 1099591 1099592 1099593 1099594 1099595 1099596 1099597 1099598 1099599 1099600 1099601 1099602 1099603 1099604 1099605 1099606 06/07/2018 06/07/2018 06/07/2018 06/07/2018 06/07/2018 06/07/2018 06/07/2018 06/07/2018 06/07/2018 06/07/2018 06/07/2018 06/07/2018 06/07/2018 06/07/2018 06/07/2018 06/07/2018 06/07/2018 06/07/2018 06/07/2018 06/07/2018 06/07/2018 06/07/2018 06/07/2018 06/07/2018 06/07/2018 06/07/2018 06/07/2018 06/07/2018 06/07/2018 06/07/2018 06/07/2018 06/07/2018 06/07/2018 06/07/2018 06/07/2018 06/07/2018 06/07/2018 06/07/2018 06/07/2018 06/07/2018 06/07/2018 06/07/2018 06/07/2018 06/07/2018 06/07/2018 06/07/2018 06/07/2018 06/07/2018 06/07/2018 06/07/2018 06/07/2018 06/07/2018 06/07/2018 06/07/2018 06/07/2018 06/07/2018 06/07/2018 06/07/2018 MIDWEST TAPE INC MOHICA TOWING MOTOWORX GARAGE NALCO COMPANY NEWCOMB ANDERSON MCCORMIC OFFICE DEPOT PALM SPRINGS MOTORS PALM SPRINGS WOMEN IN FIL PARKHOUSE TIRE INC PRAXAIR PROFORMA SOCAL PRUDENTIAL OVERALL SUPPLY RAYNE WATER CONDITIONING REPUBLIC MASTER CHEFS SCAP SHEPPARD MULLIN RICHTER A SO CAL LAND MAINTENANCE I SOUTH COAST AQMD SOUTH COAST AQMD SOUTH COAST EMERGENCY VEH SOUTH WEST TOWING INC SOUTHERN CALIFORNIA EDISO SOUTHERN VALLEY WATERFEAT SOUTHWEST PLUMBING ST. FRANCIS ELECTRIC LLC STATE OF CALIFORNIA STEVE CASAREZ SUPERIOR PAVEMENT MARKING THE LLOYD PEST CONTROL THE SOCO GROUP INC TOPS N BARRICADES INC TRUTH BE TOLD POLYGRAPH L UNIVAR UPRINTING US BANK CORPORATE PAYMENT US BANK CORPORATE PAYMENT US BANK CORPORATE PAYMENT VALLEY LOCK AND SAFE VALLEY POWER SYSTEMS INC VELGEN ENTERPRISES LLC VERIZON WIRELESS VERIZON WIRELESS WESTLITE SUPPLY CO INC WEX BANK WOMEN LEADERS FORUM YOSHI LAWNMOWER SHOP LLC DUSTIN WADE ZUMAR INDUSTRIES PS RESORTS RIVERSIDE COUNTY RECORDER SABRINA KAYE CHRISTOPHER MEYERS JENNIFER HENNING BRAD BOKATH SHAWN ARDEN JULIE WARREN DESERT WATER AGENCY JON CABRERA R R R R R R R R R R R R R R R R R R R R R R R R R R R R R R R R R R v v R R R R v R R R R R R R R R R R R R R R R R 234.05 883.00 2094.30 915.90 17292.25 914.18 85.69 150.00 343.81 265.25 370.31 756.24 494.00 39.00 1500.00 440.00 13355.50 538.58 128.61 1474.62 235.00 4063.37 850.00 704.01 111559.62 115.00 7040.00 5586.00 485.00 879.00 403.03 500.00 1483.07 117.16 0.00 0.00 36111.51 541.58 457.14 600.00 0.00 11144.62 324.90 2334.28 100.00 176.38 33.96 1238.90 68505.00 28.00 16.35 22623.04 91.56 135.02 120.00 19.89 20263.00 236.39 PAGE NUMBER: 2 ACCTPA21 ACCOUNTING PERIOD: 12/18 ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK VOID: MULTI STUB CHECK VOID: MULTI STUB CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK VOID: MULTI STUB CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK 20SUNGARD PENTAMATION -FUND ACCOUNTING MANAGER PAGE NUMBER: 3 DATE: 06/07/18 CITY OF PALM SPRINGS ACCTPA21 TIME: 16:20:31 CHECK REGISTER INCLUDING SYSTEM VOIDS ACCOUNTING PERIOD: 12/18 SELECTION CRITERIA: chkstat.rundate='06/07/2018' 1099607 06/07/2018 JENNIFER RIVERA CALLEROS R 15.00 ACCOUNTS PAYABLE CHECK 1099608 06/07/2018 MELISSA DESMARAIS R 15.00 ACCOUNTS PAYABLE CHECK 1099609 06/07/2018 ISAAC HACKBARTH R 190.69 ACCOUNTS PAYABLE CHECK 1099610 06/07/2018 JENNIFER HILL R 278.41 ACCOUNTS PAYABLE CHECK 1099611 06/07/2018 CZERSALE J HILTON R 15.00 ACCOUNTS PAYABLE CHECK 1099612 06/07/2018 BRYAN REYES R 2209.66 ACCOUNTS PAYABLE CHECK 1099613 06/07/2018 RICHARD SALOMON R 30.00 ACCOUNTS PAYABLE CHECK 1099614 06/07/2018 HEATHER TOPLIFF R 279.00 ACCOUNTS PAYABLE CHECK 1099615 06/07/2018 ANNJOHNETTE COLLINS R 11.99 ACCOUNTS PAYABLE CHECK 1099616 06/07/2018 FLORENCE FLEET SERVICES, R 1225.00 ACCOUNTS PAYABLE CHECK 1099617 06/07/2018 BLANCA GUERRERO R 14.80 ACCOUNTS PAYABLE CHECK 1099618 06/07/2018 THE MUSIC SCHOOL R 468.00 ACCOUNTS PAYABLE CHECK 1099619 06/07/2018 MATHEW ROGERS R 66.18 ACCOUNTS PAYABLE CHECK TOTAL FUND 700468.40 TOTAL REPORT 700468.40 21 RESOLUTION NO. A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF PALM SPRINGS, CALIFORNIA, APPROVING PAYMENT OF CLAIMS AND DEMANDS BY WARRANTS NUMBERED 1099620 THROUGH 1099737 IN THE AGGREGATE AMOUNT OF $2,895,770.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 claims and demands shown on the attached list; and WHEREAS, the Director of Finance hereby certifies to the accuracy of said records and to the availability of funds for payment. NOW, THEREFORE BE IT RESOLVED th t claims and demands numbered 1099620 through 1099737 have been audited as required by law and that said warrants are hereby approved for payment. ADOPTED THIS 5TH DAY OF SEPTEMBER, 2018. ATTEST: Anthony J. Mejia, MMC, City Clerk STATE OF CALIFORNIA ) COUNTY OF RIVERSIDE ) ss. CITY OF PALM SPRINGS ) David H. Ready, Esq., Ph.D. City Manager CERTIFICATION I, ANTHONY J. MEJIA, City Clerk of the City of Palm Springs, hereby certify that Resolution No. ___ 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 , by the following vote: AYES: NOES: ABSENT: ABSTAIN: IN WITNESS WHEREOF, I have hereunto set my hand and affixed the official seal of the City of Palm Springs, California, this day of _________ _ Anthony J. Mejia, MMC, City Clerk City of Palm Springs, California 22SUNGARD PENTAMATION -FUND ACCOUNTING MANAGER PAGE NUMBER: 1 DATE: 06/14/18 CITY OF PALM SPRINGS ACCTPA21 TIME: 16:34:13 CHECK REGISTER INCLUDING SYSTEM VOIDS ACCOUNTING PERIOD: 12/18 SELECTION CRITERIA: chkstat.rundate='06/14/2018' DISTRIBUTION FUND: 001 CHECK NUMBER ISSUE DATE VENDOR STATUS TOTAL DESCRIPTION 1099620 06/14/2018 ACE PARKING MANAGEMENT IN R 55450.92 ACCOUNTS PAYABLE CHECK 1099621 06/14/2018 ADB SAFEGATE AMERICAS R 6242.79 ACCOUNTS PAYABLE CHECK 1099622 06/14/2018 ADMINSURE INC R 19206.00 ACCOUNTS PAYABLE CHECK 1099623 06/14/2018 AETNA R 15837.24 ACCOUNTS PAYABLE CHECK 1099624 06/14/2018 AIRPORT QUICK WASH R 240.00 ACCOUNTS PAYABLE CHECK 1099625 06/14/2018 AIRWAVE COMMUNICATIONS EN R 1307.29 ACCOUNTS PAYABLE CHECK 1099626 06/14/2018 ALTA LANGUAGE SERVICES IN R 122.00 ACCOUNTS PAYABLE CHECK 1099627 06/14/2018 ARMSTRONG GARDEN CENTERS R 6042.93 ACCOUNTS PAYABLE CHECK 1099628 06/14/2018 ATP GENERAL ENGINEERING C R 308279.44 ACCOUNTS PAYABLE CHECK 1099629 06/14/2018 ATWORK PERSONNEL SERVICES R 290.16 ACCOUNTS PAYABLE CHECK 1099630 06/14/2018 AUTOMATIC DOOR SPECIALIST R 2960.38 ACCOUNTS PAYABLE CHECK 1099631 06/14/2018 BLUE SHIELD OF CALIFORNIA R 428514.60 ACCOUNTS PAYABLE CHECK 1099632 06/14/2018 BRODART CO R 1139.29 ACCOUNTS PAYABLE CHECK 1099633 06/14/2018 BRUCE BOWER INVESTIGATION R 4106.35 ACCOUNTS PAYABLE CHECK 1099634 06/14/2018 BRUDVIK INC R 180.60 ACCOUNTS PAYABLE CHECK 1099635 06/14/2018 CALIFA GROUP R 10230.61 ACCOUNTS PAYABLE CHECK 1099636 06/14/2018 CHRISTOPHER CARDONA R 200.00 ACCOUNTS PAYABLE CHECK 1099637 06/14/2018 CENTRAL COMMUNICATIONS R 1200.90 ACCOUNTS PAYABLE CHECK 1099638 06/14/2018 CINTAS R 126.58 ACCOUNTS PAYABLE CHECK 1099639 06/14/2018 COPIER SOURCE INC R 2481.37 ACCOUNTS PAYABLE CHECK 1099640 06/14/2018 COUNTY OF RIVERSIDE ENVIR R 1182.00 ACCOUNTS PAYABLE CHECK 1099641 06/14/2018 cvcc R 9860.40 ACCOUNTS PAYABLE CHECK 1099642 06/14/2018 DATA TICKET INC R 2646.00 ACCOUNTS PAYABLE CHECK 1099643 06/14/2018 DELTA DENTAL HMO R 1924.90 ACCOUNTS PAYABLE CHECK 1099644 06/14/2018 DELTA DENTAL PPO R 22460.56 ACCOUNTS PAYABLE CHECK 1099645 06/14/2018 DEMCO R 404.72 ACCOUNTS PAYABLE CHECK 1099646 06/14/2018 DESERT AIR CONDITIONING I R 2313.00 ACCOUNTS PAYABLE CHECK 1099647 06/14/2018 DESERT ENTERTAINER R 958.46 ACCOUNTS PAYABLE CHECK 1099648 06/14/2018 DESERT FOUNTAIN GAS R 135.18 ACCOUNTS PAYABLE CHECK 1099649 06/14/2018 DESERT PROMOTIONAL EMBROI R 8852.76 ACCOUNTS PAYABLE CHECK 1099650 06/14/2018 DESERT WATER AGENCY R 42793.66 ACCOUNTS PAYABLE CHECK 1099651 06/14/2018 DIIO LLC R 1500.00 ACCOUNTS PAYABLE CHECK 1099652 06/14/2018 DIRECTV R 144.98 ACCOUNTS PAYABLE CHECK 1099653 06/14/2018 DIVERSIFIED RISK INSURANC R 465.87 ACCOUNTS PAYABLE CHECK 1099654 06/14/2018 EISENHOWER OCCUPTIONAL HE R 5057.00 ACCOUNTS PAYABLE CHECK 1099655 06/14/2018 ENTERPRISE RENT A CAR R 1399.34 ACCOUNTS PAYABLE CHECK 1099656 06/14/2018 ESRI R 1275.00 ACCOUNTS PAYABLE CHECK 1099657 06/14/2018 ESSER SERVICES INC R 439.36 ACCOUNTS PAYABLE CHECK 1099658 06/14/2018 FAIR HOUSING COUNCIL OF R 6330.04 ACCOUNTS PAYABLE CHECK 1099659 06/14/2018 FERRAUD INDUSTRIES INC. R 1200.00 ACCOUNTS PAYABLE CHECK 1099660 06/14/2018 FOOTHILLS PSYCHOLOGICAL s R 1050.00 ACCOUNTS PAYABLE CHECK 1099661 06/14/2018 FRESNO FIRST BANK R 46779.63 ACCOUNTS PAYABLE CHECK 1099662 06/14/2018 FRIENDS OF THE PALM SPRIN R 1558.55 ACCOUNTS PAYABLE CHECK 1099663 06/14/2018 HAL HAYS CONSTRUCTION R 255719.67 ACCOUNTS PAYABLE CHECK 1099664 06/14/2018 HIRE RIGHT LLC R 1255.80 ACCOUNTS PAYABLE CHECK 1099665 06/14/2018 HMS HOST R 1365.63 ACCOUNTS PAYABLE CHECK 1099666 06/14/2018 HYATT REGENCY SUITES PALM R 700.00 ACCOUNTS PAYABLE CHECK 1099667 06/14/2018 IMAGE360 PALM DESERT R 112.31 ACCOUNTS PAYABLE CHECK 1099668 06/14/2018 INFINITY ENERGY R 76.47 ACCOUNTS PAYABLE CHECK 1099669 06/14/2018 JOHNSON CONTROLS R 4129.74 ACCOUNTS PAYABLE CHECK 1099670 06/14/2018" KORD FIRE PROTECTION R 3511.19 ACCOUNTS PAYABLE CHECK 1099671 06/14/2018 MANAGED HEALTH NETWORK IN R 1072.80 ACCOUNTS PAYABLE CHECK 1099672 06/14/2018 MOBILE TEXT ALERT R 312.00 ACCOUNTS PAYABLE CHECK 1099673 06/14/2018 OFFICE DEPOT v 0.00 VOID: MULTI STUB CHECK 23SUNGARD PENTAMATION -FUND ACCOUNTING MANAGER DATE: 06/14/18 CITY OF PALM SPRINGS TIME: 16:34:13 CHECK REGISTER INCLUDING SYSTEM VOIDS SELECTION CRITERIA: chkstat.rundate='06/14/2018' 1099674 1099675 1099676 1099677 1099678 1099679 1099680 1099681 1099682 1099683 1099684 1099685 1099686 1099687 1099688 1099689 1099690 1099691 1099692 1099693 1099694 1099695 1099696 1099697 1099698 1099699 1099700 1099701 1099702 1099703 1099704 1099705 1099706 1099707 1099708 1099709 1099710 1099711 1099712 1099713 1099714 1099715 1099716 1099717 1099718 1099719 1099720 1099721 1099722 1099723 1099724 1099725 1099726 1099727 1099728 1099729 1099730 1099731 06/14/2018 06/14/2018 06/14/2018 06/14/2018 06/14/2018 06/14/2018 06/14/2018 06/14/2018 06/14/2018 06/14/2018 06/14/2018 06/14/2018 06/14/2018 06/14/2018 06/14/2018 06/14/2018 06/14/2018 06/14/2018 06/14/2018 06/14/2018 06/14/2018 06/14/2018 06/14/2018 06/14/2018 06/14/2018 06/14/2018 06/14/2018 06/14/2018 06/14/2018 06/14/2018 06/14/2018 06/14/2018 06/14/2018 06/14/2018 06/14/2018 06/14/2018 06/14/2018 06/14/2018 06/14/2018 06/14/2018 06/14/2018 06/14/2018 06/14/2018 06/14/2018 06/14/2018 06/14/2018 06/14/2018 06/14/2018 06/14/2018 06/14/2018 06/14/2018 06/14/2018 06/14/2018 06/14/2018 06/14/2018 06/14/2018 06/14/2018 06/14/2018 OFFICE DEPOT OFFICE DEPOT ONTRAC PACIFIC PRODUCTS AND SERV PALM SPRINGS AUTO WASH PALM SPRINGS DISPOSAL SER PALM SPRINGS WELDING PATTON DOOR AND GATE PLANIT REPROGRAPHICS PLAZA INVESTMENT CO INC PROPER SOLUTIONS INC PROPER SOLUTIONS INC RICK RABUCK RESTROOM ALERT LLC RISELO ENGINEERING SOLUTI SMG SMG SMOKE TREE STABLES SOUTHERN CALIFORNIA EDISO SOUTHERN CALIFORNIA EDISO SOUTHWEST MOBILE STORAGE SOUTHWEST PLUMBING THE STANDARD INSURANCE SYMBLAZE INC TBU THE COMMUNITY FOUNDATION TIME WARNER CABLE TIME WARNER CABLE TOPS N BARRICADES INC U S CUSTOMS SERVICE UNDERWRITERS LABORATORY L UNITED RENTALS US BANK CORPORATE PAYMENT US BANK CORPORATE PAYMENT V AND V MANUFACTURING VALLEY LOCK AND SAFE VANMARC INC VERIZON WIRELESS VERIZON WIRELESS VERIZON WIRELESS W M LYLES CO WAXIE SANITARY SUPPLY WESTERN ENERGY SYSTEMS XEROX FINANCIAL SERVICES YOSHI LAWNMOWER SHOP LLC ZOLL MEDICAL CORPORATION DAVID A NEWELL BENJAMIN PORTERFIELD SOUTHERN CALIFORNIA EDISO DREAM SHAPERS DREAM SHAPERS DREAM SHAPERS REGINA KAYS AUDIO ASSOCIATES OF SAN D DESERT WATER AGENCY BARBARA J JOHNSON MATTHEW WASHBURN DENIZA HRISTOVA v R R R R R R R R R v R R R R R R R v R R R R R R R R R R R R R v R R R R R R R R R R R R R R R R R R R R R R R R R 0.00 6835.25 138.33 1151.3 9 700.00 192.17 80.00 250.00 313.75 900.00 0.00 25538.48 1000.00 300.00 31480.60 61752.46 6584.00 1264.92 0.00 89524.34 520.00 252.52 33637.76 2400.00 174812.23 2500.00 299.99 174.04 6287.62 1424.08 1990.00 1541.14 0.00 42308.95 36.35 3945.37 550.00 1979.55 4580.73 844.08 888813.01 4960.31 4233.64 69571.40 516.08 1275.00 495.00 100.83 5.61 325.00 350.00 350.00 60.50 114715.19 265.16 489.73 2550.00 1700.63 PAGE NUMBER: 2 ACCTPA21 ACCOUNTING PERIOD: 12/18 VOID: MULTI STUB CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK VOID: MULTI STUB CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK VOID: MULTI STUB CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK VOID: MULTI STUB CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK 24SUNGARD PENTAMATION -FUND ACCOUNTING MANAGER PAGE NUMBER: 3 DATE: 06/14/18 CITY OF PALM SPRINGS ACCTPA21 TIME: 16:34:13 CHECK REGISTER INCLUDING SYSTEM VOIDS ACCOUNTING PERIOD: 12/18 SELECTION CRITERIA: chkstat.rundate='06/14/2018' 1099732 06/14/2018 MARIANA DUSPIVA R 1704.00 ACCOUNTS PAYABLE CHECK 1099733 06/14/2018 JANET BURNS PETTY CASH R 289.86 ACCOUNTS PAYABLE CHECK 1099734 06/14/2018 KRYSTALYNN PAQUETTE R 106.15 ACCOUNTS PAYABLE CHECK 1099735 06/14/2018 WILLIAM PELLUM R 23.98 ACCOUNTS PAYABLE CHECK 1099736 06/14/2018 STEVE BECK R 1603.00 ACCOUNTS PAYABLE CHECK 1099737 06/14/2018 HEATHER WHITE R 30.00 ACCOUNTS PAYABLE CHECK TOTAL FUND 2895770.65 TOTAL REPORT 2895770.65 25 RESOLUTION NO. A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF PALM SPRINGS, CALIFORNIA, APPROVING PAYMENT OF PAYROLL WARRANTS FOR THE PERIOD ENDED 06-16-2018 BY WARRANTS NUMBERED 420348, 420351 THROUGH 420367 TOTALING $41,449.49 LIABILITY CHECKS NUMBERED 1099738 THROUGH 1099757 TOTALING $77,400.00, FOUR WIRE TRANSFERS FOR $61 ,052.24, AND SEVEN ELECTRONIC ACH DEBITS OF $1,423,102.65 IN THE AGGREGATE AMOUNT OF $1,603,004.38, 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. , PA Finance and Treasurer NOW, THEREFORE BE IT RESOLVED by the City Council of the City of Palm Springs that payroll warrants numbered 420348, 420351 through 420367, liability checks numbered 1099738 through 1099757, four wire transfers and nine electronic ACH debits have been audited as required by law . and that said warrants are hereby approved for payment. ADOPTED THIS 5TH DAY OF SEPTEMBER, 2018. ATTEST: Anthony J. Mejia, MMC, City Clerk STATE OF CALIFORNIA ) COUNTY OF RIVERSIDE ) ss. CITY OF PALM SPRINGS) David H. Ready, Esq., Ph.D. City Manager CERTIFICATION I, ANTHONY J. MEJIA, City Clerk of the City of Palm Springs, hereby certify that Resolution No. __ 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 , by the following vote: AYES: NOES: ABSENT: ABSTAIN: IN WITNESS WHEREOF, I have hereunto set my hand and affixed the official seal of the City of Palm Springs, California, this day of _________ _ Anthony J. Mejia, MMC, City Clerk City of Palm Springs, California 26 Print Check List Execution # XXX444 Function: RPCH Run By: DOLORESO Run Start Date: Jun 25, 2018 2:08 :49 PM Payroll Bank Account: XXXXXX661 , XXXXXXX2000 From Pay Issue Date: Jun 9 , 2018 To Pay Issue Date: Jun 9, 2018 Included Printed: Yes Include Unprinted: Yes Include Voided: Yes Include Cleared: Yes Include Outstanding: Yes Include Reconciled : Yes Include Void Checks Only: No Sort By: Check Number User Comment: Execution # XXX444 run by DOLORESO usrng RPC H d ocx -XXXX1008 Prepared by ePersonali ty 4 50 .00.05 27 Run Jun 25 , 2018 2 08 49 PM Sorted By Check Number Print Check List From Jun 9 , 2018 To Jun 9. 2018 Bank of America Transit: XXXXXX661 A cco u n t: XXXXXXZOOO (*not yet printed) Chec k # Amount Che c k Date Person ~ 42 0348 11.787 .31 Jun9,2018 1600 2 Se rrano , Mario Tota l #Checks Reported: 1 Tota l Check Amount Reported: $11,787.31 Tota l # Checks Cleared : 0 Total Check Amount C leared : $0.00 Executron # XXX444 run by DOLORESO us1ng RPCH docx-XXXX1008 Page 2 of 2 Check Tvp~ Check Statu li Computer Check Ou tstand ing Prepared by ePerson ali ty 4 50 00 05 28 Print Check List Execution # XXX330 Function : RPCH Run By: SHARONR Run Start Date: Jun 20 , 20 18 2 :45:58 PM Payroll Bank Account: XXXXXX661 , XXXXXXX2000 From Pay Issue Date: Jun 22 , 201 8 To Pay Issue Date: Jun 22 , 201 8 Included Printed: Yes Include Unprinted: Yes Include Voided : Yes Include Cleared : Include Outstanding : Yes Include Reconciled : Include Void Checks Only: Sort By: Check Number User Comment: Execut1on # XXX330 run by SHARONR us1ng RPCH docx-XXXX1 008 Prepared by ePersonahty 4 50.00.05 29 Run: Jun 20, 2018 2 45.58 PM Print Check List Page 2 of 2 Sorted B y Check Number From Jun 22 2018 To Jun 22 , 2018 Bank of America Transit: XXXXXX661 Account: XXXXXX2000 (* not yet printed) !;.b~c k # Amou nt C heck Date .f .e.r_s .o.!!..f ~~ N.em!t Ch.!1_c k Tyge Check Status 420351 1,632.09 Jun 22, 2018 15839 Andrade, Jose Computer Check Outstanding 420352 1,533.41 Jun 22, 2018 15905 Castillo, Jorge Computer Check Outstand ing 420353 1,007.63 Jun 22, 2018 16145 J imenez, Jovann i Computer Check Outstanding 420354 1,955.40 Jun 22, 2018 15784 Richards, Tabitha Compu ter Check Outstanding 420355 6,164.96 Jun 22, 2018 15517 Skyberg, Rona ld Computer Check O utstanding 420356 1,476 .39 Jun 22, 2018 10993 Huskey, Zachary B Compu ter Check Outstanding 420357 1,782 .78 J un 22, 2018 15222 Hernandez, Francisco Computer Check Outstand ing 420358 1,7 91 .21 Jun 22 , 2018 04905 Leon, Arnulfo H Compu ter Check Ou tsta nd ing 420359 2,0 65.04 Jun 22, 2018 10253 Mercado, Gilbert R Compu ter Check Outstanding 420360 717 .50 Jun 22, 2018 16146 Beltran, Robert Compu ter Check Ou tst anding 420361 2,031 .10 J un 22, 2018 15156 Menley, Charles A Computer Check Outstanding 420362 1,2 11 .15 Jun 22 , 2018 16143 Enri quez, Amanda Compu ter Check Outsta nding 420363 1,605.39 Jun 22 , 2018 15969 Freeman, Morgan E Computer Check Outstanding 420364 2,510.86 Jun 22, 2018 16098 Sandoval, Kristin Computer Check Outstanding 420365 726.43 Jun 22, 2018 16144 Valdivia, Jacob Computer C heck Outstanding 420366 1,297 .20 Jun 22, 2018 16142 Kling , David Computer Check Outstanding 420367 153.64 Jun 22 , 2018 15365 Weems, Cass ie L Computer Check Outstanding Tota l # Che cks Re p o rted: 17 Total Check Amo unt Rep o rted : $29,662 .18 Execution# XXX330 run by SHARONR us1ng RPCH docx-XXXX1008 Prepared by ePersonality 4 50 00 05 30SUNGARD PENTAMATION -FUND ACCOUNTING MANAGER PAGE NUMBER: 1 DATE: 06/21/18 CITY OF PALM SPRINGS ACCTPA21 TIME: 09:37:20 CHECK REGISTER INCLUDING SYSTEM VOIDS ACCOUNTING PERIOD: 12/18 SELECTION CRITERIA: chkstat.rundate='06/22/2018' DISTRIBUTION FUND: 001 CHECK NUMBER ISSUE DATE VENDOR STATUS TOTAL DESCRIPTION 1099738 06/22/2018 AMERICAN FIDELITY ASSURAN R 516.78 ACCOUNTS PAYABLE CHECK 1099739 06/22/2018 EMPLOYMENT DEVELOPMENT DE R 93.10 ACCOUNTS PAYABLE CHECK 1099740 06/22/2018 KANSAS PAYMENT CENTER R 284.50 ACCOUNTS PAYABLE CHECK 1099741 06/22/2018 GARNISHMENT R 1025.54 ACCOUNTS PAYABLE CHECK 1099742 06/22/2018 AFLAC R 100.95 ACCOUNTS PAYABLE CHECK 1099743 06/22/2018 DAVEY ADMIN GROUP R 9358.58 ACCOUNTS PAYABLE CHECK 1099744 06/22/2018 FIRE MANAGEMENT ASSOCIATI R 112.50 ACCOUNTS PAYABLE CHECK 1099745 06/22/2018 FRANCHISE TAX BOARD R 905.68 ACCOUNTS PAYABLE CHECK 1099746 06/22/2018 LIBERTY MUTUAL INSURANCE R 1146.37 ACCOUNTS PAYABLE CHECK 1099747 06/22/2018 MANAGEMENT ASSN OF PALM S R 1031.25 ACCOUNTS PAYABLE CHECK 1099748 06/22/2018 PALM SPRINGS FIREMENS ASS R 1841.28 ACCOUNTS PAYABLE CHECK 1099749 06/22/2018 POLICE OFFICERS' ASSOCIAT R 8613.45 ACCOUNTS PAYABLE CHECK 1099750 06/22/2018 RIVERSIDE COUNTY SHERIFF R 75.00 ACCOUNTS PAYABLE CHECK 1099751 06/22/2018 SEIU LOCAL 721 CTW AND C R 2643.50 ACCOUNTS PAYABLE CHECK 1099752 06/22/2018 SUN COMMUNITY R 44871.35 ACCOUNTS PAYABLE CHECK 1099753 06/22/2018 UNITED WAY OF THE DESERT R 134.00 ACCOUNTS PAYABLE CHECK 1099754 06/22/2018 GARNISHMENT R 152.00 ACCOUNTS PAYABLE CHECK 1099755 06/22/2018 PS FIRE SAFETY UNIT R 2230.60 ACCOUNTS PAYABLE CHECK 1099756 06/22/2018 GARNISHMENT R 620.50 ACCOUNTS PAYABLE CHECK 1099757 06/22/2018 TRANSAMERICA WORKSITE MAR R 1643.07 ACCOUNTS PAYABLE CHECK TOTAL FUND 77400.00 TOTAL REPORT 77400.00 31 Payment Submission Date and Time (PST): 6fl/2018 Time : 9:26:34 AM State Disability Insurance{ SOl) Tax and California Personal Income Tax (PIT) EDD Employer Identification Number : 80098221 Bank Account: Deposit Schedule Pay Date Next 06/06/18 bank Da y Regards , SO l PIT Amount Amount $0.00 $1,549.00 THOMAS HAYS Depu ty City Tr easu rer 3200 E. Tahquitz Canyon Way Pa lm Springs , CA 92263 Total Amount $1 ,549.00 (7 60 ) 323-8223 direc t thoma s.hays@pal mspri ng sca .gov Bank Debit Date 06 /08/18 2 Confirmati on Number 2585017 32 Ariana Muniz From: Sent: To : Cc: Subject: Importance: Fe d e r al : Thomas Hays Th ursday, June 21,2018 1:39PM Sharon Riddle; Dolores Olvera ; A riana Muniz Ma rl a Pendleton Pay ro ll 6/22/2018 Federa l and State Taxes High EFT ACKNOWLEDGEMENT NUMBER: 2708573 04611230 PLEASE t l OTE ~.n amounts represe ntsa tn th e su~cat ego n es 0 1 SoCia l Secunr~ l.led1care ana Income Ta" ":ithh0ld ing are fo r in formational purposes only. Payment lnfonnation Entered Data Taxpayer EIN Tax Fo rm Ta x Type Tax Peri od Paymen t Amount Settlement Date Subca t egorie s: 1 Socia l Security 2 Medicare 3 Ta x Withholding St at e: xxxxx0757 941 Employers Federa l Tax Federal Tax Deposit Q2/2018 $219 ,768 .~4 06/22120 18 $1 11 .60 $47 .797.72 $171 ,859 .12 33 Payment Submission Date and Time {PST): 6f21 12018 Time: 1:39:36 PM State Disability Insurance( SOl) Tax and California Personal Income Tax (PIT) EDD Employer Iden tification Number: Bank Account : Deposit Schedule Pay Date 80098221 "-2000 SOl Amount PIT Amount Total Amount Next bank Day 06/22/18 $0 .00 566,802.93 $66 ,802.93 THOMAS HAYS Deputy City Treasurer 3200 E. T ahquitz Canyon Way Palm Springs , CA 92263 (760) 323-8223 direct thomas.hays@pa lmspringsca.gov 2 Bank Debit Date 06/22/18 Confirmati on Number 26:26512 34 Previous Day Wire Report Company: Palm Sp ri ngs CA City of Reque stor : Ariana Muni z Run Date: 08/23/2018 10:08:11 C OT Bank of America~ Merrill Lynch As of: 06/22/2018 Bank of Americ a, Southern California I XXXXXX661 XXXXXX2000 I City of Palm Springs General Acct l USD I As of: 06/22/2018 Detail Credits I Transaction Incoming Money Transfer Credit (19 5) Credit Total s Detail Debit s Transacti on Amount 0 Day 1 Day Float ll 2+ Day Float I Bank Ref 371.58 371.58 0.00 0.00 003 703 11600 371.58 371 .58 0 .00 0.00 Amount Bank Ref Cust Ref 28.353.15 /oo370261501 oooooooooo 22,595.06 ./00370261503 0000000000 00000 00000 Outgoi ng Money Trans fer Debit (495) Outgoing Money Transfer Debit (495) Outgoing Money Transfer Debit (495) Outgoing Money Transfer Debit (495) ------------------------------------ Deb it Totals Totals Bank Totals 06/22/2 01 8 9 ,406.25 /00370261504 0000000000 697.78 /oo370261502 oooooooooo 61,052 .24 Bank of America, Southern California 1 XXXXX661 (USD) Totals Total Credits Total Debits Report Total s 06/22/2018 USD Totals Total Credi ts Total Debits Count 4 4 Amount 371.58 ----- 61 ,052.24 Amount 371 .58 61 .052.24 Page 1 35 Previous Day ACH Report Company: Palm Springs C A City of Requestor : A riana Muniz Run Date: 08/23/2018 09:55:20 CDT As of: 06/22 /2018 B ank of America , Sout hern Ca lifornia I XXXXX661 XXXXXX2000 I City of Palm Springs General Acct I USD I As of: 06/22/2018 Detail Credits Transaction Preauthorized ACH Credit (165) Preauthorized ACH Credit (165) Preauthorized ACH Credit (165) Preauthorized ACH Credit (165) ?reauthorized ACH Credit (165) Preauthorized ACH Credit (165) Preauthorized ACH Credit (165) Preauthorized ACH Credit (165) Preauthorized ACH Credit (165) Credit Totals Detail Debits Transaction Preauthorized ACH Debit (455) ~~Amount !I 0 Day 46,446.09 6,259.24 6,17 9.70 5,104 .00 697.00 281.00 244.00 151.90 40.00 65,402.93 l Amount 7 219 ,768.44 --------~-----/ Preauthorized ACH Debit (455) ACH Settlement Debit (466) ACH Settlement Debit (466) Debit Totals Totals Bank T ot als 06/22 /2018 66,802.93 / 1 '124 ,032.43 ---v 200 .00 1,410,803.80 Bank of America, Southern California I XXXXX661 (USD) Totals Tot a l Credits To tal Debits Report Total s 06/22/20 18 USD Totals Tota l Credi ts Tota l Debits Count I Amount 9 65 ,402 .93 -------------- 4 Count 9 4 1,410 ,803 .80 Amount 65,402.93 ------ 1,4 10,803.80 46,44 6.09 6,259.24 6,179.70 5,1 04 .00 697.00 281.00 244.00 151 .90 40.00 65,402.93 Bank Ref 73007132834 73007275484 73007795669 73013619875 Page 1 1 Day Float 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Bank of America~ Merrill Lynch 2+ Day Float Bank Ref 0.00 710108 1764 1 00000 00 000 0.00 73008037605 000000 0000 0.00 73008037606 0000000000 0.00 73008037607 0000000000 0.00 72015586435 0000000000 0.00 72013820572 0000000000 0.00 73008011581 0000000000 0.00 72013820573 0000000000 0.00 73008011580 0000000000 0.00 Cust Ref 0000000000 0000000000 0000000000 0000000000 36 Previo u s Day ACH Report Company: Palm Springs CA Ci ty of Requestor : Aria na Mu niz Run Date: 08/23/2018 10:09:07 COT As of: 07/09/2018 Bank of Ameri ca , Southern California I XXXXXX661 XXXXXXX2000 1 City of Palm Springs General Acct 1 USD 1 As of: 07/09/2018 Detail Credits Transaction Preauthorized ACH Credit (165) Preauthorized ACH Credit (165) Pr eauthorized ACH Credit (165) Prea uthorized ACH Credit (165) Preauthorized ACH Credit (165) Prea u thorized ACH Cred i t (165) Preauthor ized AC H Credit (165) Preauthor ized AC H Cr edi t (165) Preauthorized ACH Cr edit (165) Preauthorized ACH Credit (165) Preauthorized ACH Credit (165) Prea u thor ized ACH Credit (165) Cre dit Tot al s Det ail Debits Transactio n Preauthor ized ACH Debit (455) Debit Totals To tals Ban k To ta ls 07/09/20 18 ----- I Amo unt _JI 0 Day ~ 75 ,764.94 75 ,764.94 8,1 71.00 8,1 71.00 6,981.00 6,981.00 3,156.00 3,156 .00 3,127.00 3,127 .00 1,972.00 1,972.00 558.00 558.00 150.00 150 .00 41.00 4 1.00 19.50 19.50 11.25 11 .25 9.00 9.00 99,960 .69 99,960.69 Amount t B ank Ref / 5,817 .8 7 87010087225 5,8 17.87 1 Day Float 0.00 0 .00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Bank of America~ Merrill Lynch 2+ Day Float 0.00 87003312052 0000000000 0 .00 90008 70 6817 00000000 00 0.00 90009896880 0000000000 0.00 90008666091 0000000000 0.00 9000 8666090 0000000000 0.00 90009216632 0000000000 0.00 90004 887498 0000000000 0.00 90008685442 0000000000 0.00 90008640502 0000000000 0.00 90008706816 0000000000 0.00 90008685555 0000000000 0.00 90009896879 0000000000 0.00 ---- Cust Ref 0000000000 B ank of America, Southern Californi a 1 XXXXXX661 (USD) ~==~~==~~~==~==~~~==~==~~==~ Totals Total Credi ts Total Debits Repo rt To ta ls 07/09/2018 USD Totals To ta l Credits Total Debits Count Amount 12 99 ,96 0.69 5,817.87 Amount 12 99,960.6 9 5,817.87 Page 1 37 Previous Day ACH Report Company: Pal m Springs CA City of Reque stor : Aria na Muniz Run Date: 08/23/2018 10:20:35 COT As of: 06/08 /2018 Bank of Am erica, Sou t hern Ca liforni a I XXXXX66 1 XXXXXX2000 I City of Palm Springs Gene ral Acct I USD I As of: 06 /08/2018 Detail Credits l Transaction Preauthorized ACH Credit (165) Preauthorized ACH Credit (165) Preauthorized ACH Credit (165) Preauthorized ACH Credit (1 65) Amount 0 Day 14 ,402.68 5 ,163.00 3,950.80 3,457.21 ------------------ Preauthori zed ACH Credit (165) Preauthorized ACH Credit (1 65) Preauthorized ACH Credit (165) Preauthorized ACH Credit (165) Credit Totals Detail Debits Transaction Preauthorized ACH Debit (455) 1,200.00 509.00 95.00 3 .00 28,780 .69 Amount 2 19 ,413 .69 -------- Preauthorized ACH Debit (455) 67,185.30 Preauthorized ACH Debit (455) ./ 4,931 .98 ------------------~ ./ Preauthorized ACH Debit (455) 1,549.00 -------------------------- ACH Settlement Debit (466) 1 ,094 ,639.45 ------------------------ ACH Settlement Debit (466) Debit Total s Totals Bank Totals 06/08/2 018 Tota l Credits 8 ------ Total Debits Report Totals 06/08/2018 USD Totals Total Credits Total Debits 6 Count 8 6 200.00 1 ,387,919.42 28,780.69 1,387,919.42 Amount 28,780.69 1 ,387 ,919 .42 14 ,402.68 5,163.00 3,950.80 3,457.21 1,200.00 509.00 95.00 3.00 28,780 .69 Bank Ref 580 12381724 --- 59009131863 58012381772 59009131865 59009642449 59014628933 Pa ge 1 1 Day Float 0 .00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Bank of America~ Merrill Lynch 2+ Day Float Bank Ref 0.00 59 009887729 0000000000 0 .00 59009887731 0000000000 0.00 59009887730 0000000000 0.00 58008750363 000000000 0 0.00 58017558916 0000000000 0.00 59009861497 0000000000 0.00 59009861284 0000000000 0 .00 59009861496 0000000000 0.00 Cust Ref 0000000000 0000000000 0000000000 0000000000 0000000000 0000000000 38 RESOLUTION NO. A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF PALM SPRINGS, CALIFORNIA, APPROVING PAYMENT OF CLAIMS AND DEMANDS BY WARRANTS NUMBERED 1099758 THROUGH 1099903 IN THE AGGREGATE AMOUNT OF $1,908,533.84 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 claims and demands shown on the attached list; and WHEREAS, the Director of Finance hereby certifies to the accuracy of said records and to the availability of funds for payment. NOW, THEREFORE BE IT RESOLVED that claims and demands numbered 1099758 through 1099903 have been audited as required by law and that said warrants are hereby approved for payment. ADOPTED THIS 5TH DAY OF SEPTEMBER, 2018. ATTEST: Anthony J. Mejia, MMC, City Clerk STATE OF CALIFORNIA ) COUNTY OF RIVERSIDE ) ss. CITY OF PALM SPRINGS ) David H. Ready, Esq., Ph.D. City Manager CERTIFICATION I, ANTHONY J. MEJIA, City Clerk of the City of Palm Springs, hereby certify that Resolution No. ___ 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 , by the following vote: AYES: NOES: ABSENT: ABSTAIN: IN WITNESS WHEREOF, I have hereunto set my hand and affixed the official seal of the City of Palm Springs, California, this day of _________ _ Anthony J. Mejia, MMC, City Clerk City of Palm Springs, California 39SUNGARD PENTAMATION -FUND ACCOUNTING MANAGER PAGE NUMBER: 1 DATE: 06/21/18 CITY OF PALM SPRINGS ACCTPA21 TIME: 15:59:54 CHECK REGISTER INCLUDING SYSTEM VOIDS ACCOUNTING PERIOD: 12/18 SELECTION CRITERIA: chkstat.rundate='06/21/2018' DISTRIBUTION FUND: 001 CHECK NUMBER ISSUE DATE VENDOR STATUS TOTAL DESCRIPTION 1099758 06/21/2018 AEGIS ITS INC R 108075.59 ACCOUNTS PAYABLE CHECK 1099759 06/21/2018 AIR EXCHANGE INC R 5802.56 ACCOUNTS PAYABLE CHECK 1099760 06/21/2018 ALAMEDA HEALTH SYSTEM R 1000.00 ACCOUNTS PAYABLE CHECK 1099761 06/21/2018 ALBERT A WEBB ASSOCIATES R 63606.60 ACCOUNTS PAYABLE CHECK 1099762 06/21/2018 ALL AMERICAN CLASSIC CAR R 1928.53 ACCOUNTS PAYABLE CHECK 1099763 06/21/2018 ALTA VERDE BUILDERS R 1792.62 ACCOUNTS PAYABLE CHECK 1099764 06/21/2018 AMERICAN FORENSIC NURSES R 608.00 ACCOUNTS PAYABLE CHECK 1099765 06/21/2018 AT & T R 291.69 ACCOUNTS PAYABLE CHECK 1099766 06/21/2018 AT&T TELECONFERENCE SERVI R 10.96 ACCOUNTS PAYABLE CHECK 1099767 06/21/2018 AUDIO LEADERS R 4151.50 ACCOUNTS PAYABLE CHECK 1099768 06/21/2018 AUTOMATIC DOOR SPECIALIST R 1030.50 ACCOUNTS PAYABLE CHECK 1099769 06/21/2018 LUIS AZARCOYA R 600.00 ACCOUNTS PAYABLE CHECK 1099770 06/21/2018 B & H PHOTO R 2039.57 ACCOUNTS PAYABLE CHECK 1099771 06/21/2018 BABCOCK LABORATORIES INC R 180.00 ACCOUNTS PAYABLE CHECK 1099772 06/21/2018 BARR DOOR, INC. R 1729.41 ACCOUNTS PAYABLE CHECK 1099773 06/21/2018 BIRCH COMMUNICATIONS INC R 144.80 ACCOUNTS PAYABLE CHECK 1099774 06/21/2018 BLACK DIAMOND SOLUTIONS R 11952.22 ACCOUNTS PAYABLE CHECK 1099775 06/21/2018 BOYS & GIRLS CLUB OF PS A R 28544.01 ACCOUNTS PAYABLE CHECK 1099776 06/21/2018 BRICKLEY ENVIRONMENTAL R 7860.00 ACCOUNTS PAYABLE CHECK 1099777 06/21/2018 BRODART CO R 1774.90 ACCOUNTS PAYABLE CHECK 1099778 06/21/2018 CARL WARREN AND COMPANY R 6850.00 ACCOUNTS PAYABLE CHECK 1099779 06/21/2018 CDR DATA CORPORATION R 492.80 ACCOUNTS PAYABLE CHECK 1099780 06/21/2018 CINTAS R 130.94 ACCOUNTS PAYABLE CHECK 1099781 06/21/2018 COACHELLA VALLEY ASSOCIAT R 11744.06 ACCOUNTS PAYABLE CHECK 1099782 06/21/2018 COACHELLA VALLEY ASSOCIAT R 14699.52 ACCOUNTS PAYABLE CHECK 1099783 06/21/2018 JOHN CONNOR R 82.00 ACCOUNTS PAYABLE CHECK 1099784 06/21/2018 COPIER SOURCE INC R 2329.90 ACCOUNTS PAYABLE CHECK 1099785 06/21/2018 COUNTY OF RIVERSIDE AUDIT R 5697.50 ACCOUNTS PAYABLE CHECK 1099786 06/21/2018 CSG CONSULTANTS INC R 3485.00 ACCOUNTS PAYABLE CHECK 1099787 06/21/2018 CYRUN R 73890.00 ACCOUNTS PAYABLE CHECK 1099788 06/21/2018 DATA TICKET INC R 7953.20 ACCOUNTS PAYABLE CHECK 1099789 06/21/2018 DELL MARKETING LP R 13231.43 ACCOUNTS PAYABLE CHECK 1099790 06/21/2018 DELS FLOORING CONTRACTORS R 1098.00 ACCOUNTS PAYABLE CHECK 1099791 06/21/2018 DEMCO R 117.62 ACCOUNTS PAYABLE CHECK 1099792 06/21/2018 DEPARTMENT OF JUSTICE R 512.00 ACCOUNTS PAYABLE CHECK 1099793 06/21/2018 DESERT AIR CONDITIONING I R 216.52 ACCOUNTS PAYABLE CHECK 1099794 06/21/2018 DESERT PROMOTIONAL EMBROI R 228.00 ACCOUNTS PAYABLE CHECK 1099795 06/21/2018 DESERT SUN PUBLISHING COM R 2627.50 ACCOUNTS PAYABLE CHECK 1099796 06/21/2018 DESERT WATER AGENCY R 594.51 ACCOUNTS PAYABLE CHECK 1099797 06/21/2018 DIRECT ENERGY BUSINESS MA R 4802.74 ACCOUNTS PAYABLE CHECK 1099798 06/21/2018 DIRECT ENERGY BUSINESS MA R 1791.37 ACCOUNTS PAYABLE CHECK 1099799 06/21/2018 DOWNS ENERGY R 25791.57 ACCOUNTS PAYABLE CHECK 1099800 06/21/2018 DS SERVICES OF AMERICA IN R 2.99 ACCOUNTS PAYABLE CHECK 1099801 06/21/2018 FEDERAL EXPRESS CORPORATI R 10.34 ACCOUNTS PAYABLE CHECK 1099802 06/21/2018 FLEX ADVANTAGE R 551.25 ACCOUNTS PAYABLE CHECK 1099803 06/21/2018 FRANKLIN TRUCK PARTS INC R 374.92 ACCOUNTS PAYABLE CHECK 1099804 06/21/2018 FRONTIER COMMUNICATIONS C R 12122.57 ACCOUNTS PAYABLE CHECK 1099805 06/21/2018 G/M BUSINESS INTERIORS R 2904.55 ACCOUNTS PAYABLE CHECK 1099806 06/21/2018 GLOBAL TECHNOLOGY SYSTEMS R 578.00 ACCOUNTS PAYABLE CHECK 1099807 06/21/2018 GRANICUS INC R 1901.45 ACCOUNTS PAYABLE CHECK 1099808 06/21/2018 HORIZON LIGHTING INC R 445.59 ACCOUNTS PAYABLE CHECK 1099809 06/21/2018 ILLINOIS LIBRARY ASSOCIAT R 108.40 ACCOUNTS PAYABLE CHECK 1099810 06/21/2018 INFOSAT COMMUNICATIONS R 733.47 ACCOUNTS PAYABLE CHECK 1099811 06/21/2018 IRON MOUNTAIN R 859.54 ACCOUNTS PAYABLE CHECK 40SUNGARD PENTAMATION -FUND ACCOUNTING MANAGER PAGE NUMBER: 2 DATE: 06/21/18 CITY OF PALM SPRINGS ACCTPA21 TIME: 15:59:54 CHECK REGISTER INCLUDING SYSTEM VOIDS ACCOUNTING PERIOD: 12/18 SELECTION CRITERIA: chkstat.rundate='06/21/2018' 1099812 06/21/2018 KRONOS R 678.55 ACCOUNTS PAYABLE CHECK 1099813 06/21/2018 LANGUAGE LINE SERVICES IN R 56.27 ACCOUNTS PAYABLE CHECK 1099814 06/21/2018 LENCO INDUSTRIES, INC. R 472275.00 ACCOUNTS PAYABLE CHECK 1099815 06/21/2018 MARIPOSA LANDSCAPES, INC. R 195.00 ACCOUNTS PAYABLE CHECK 1099816 06/21/2018 MCLEAN COMPANY RENTALS R 900.00 ACCOUNTS PAYABLE CHECK 1099817 06/21/2018 MEGGITT DEFENSE SYSTEMS C R 1422.06 ACCOUNTS PAYABLE CHECK 1099818 06/21/2018 MISSION SPRINGS WATER DIS R 79.78 ACCOUNTS PAYABLE CHECK 1099819 06/21/2018 NALCO COMPANY R 5278.66 ACCOUNTS PAYABLE CHECK 1099820 06/21/2018 NANCY K BOHL INC R 380.00 ACCOUNTS PAYABLE CHECK 1099821 06/21/2018 NEOPOST USA INC R 249.08 ACCOUNTS PAYABLE CHECK 1099822 06/21/2018 NEWCHRON ASSOCIATES R 1331.67 ACCOUNTS PAYABLE CHECK 1099823 06/21/2018 O'BAYLEY COMMUNICATIONS R 3735.00 ACCOUNTS PAYABLE CHECK 1099824 06/21/2018 OFFICE DEPOT v 0.00 VOID: MULTI STUB CHECK 1099825 06/21/2018 OFFICE DEPOT R 3493.80 ACCOUNTS PAYABLE CHECK 1099826 06/21/2018 OFFICE DEPOT R 4810.21 ACCOUNTS PAYABLE CHECK 1099827 06/21/2018 ONTRAC R 73.14 ACCOUNTS PAYABLE CHECK 1099828 06/21/2018 PALM SPRINGS MIRROR AND G R 1936.94 ACCOUNTS PAYABLE CHECK 1099829 06/21/2018 PARKHOUSE TIRE INC R 1002.76 ACCOUNTS PAYABLE CHECK 1099830 06/21/2018 PATTON DOOR AND GATE R 125.00 ACCOUNTS PAYABLE CHECK 1099831 06/21/2018 PCMG R 2109.21 ACCOUNTS PAYABLE CHECK 1099832 06/21/2018 PORAC HEADQUARTERS R 13.00 ACCOUNTS PAYABLE CHECK 1099833 06/21/2018 PRAXAIR R 956.80 ACCOUNTS PAYABLE CHECK 1099834 06/21/2018 PRECISION TECHNOLOGIES R 5530.98 ACCOUNTS PAYABLE CHECK 1099835 06/21/2018 PROPER SOLUTIONS INC R 12657.72 ACCOUNTS PAYABLE CHECK 1099836 06/21/2018 QUALITY CODE PUBLISHING R 2172.10 ACCOUNTS PAYABLE CHECK 1099837 06/21/2018 RAYNE WATER CONDITIONING R 494.00 ACCOUNTS PAYABLE CHECK 1099838 06/21/2018 REFRIGERATION SUPPLIES DI R 2129.30 ACCOUNTS PAYABLE CHECK 1099839 06/21/2018 REPUBLIC MASTER CHEFS R 39.00 ACCOUNTS PAYABLE CHECK 1099840 06/21/2018 RIOS CLEMENTI HALE STUDIO R 191975.89 ACCOUNTS PAYABLE CHECK 1099841 06/21/2018 RIVERSIDE COUNTY SHERIFFS R 1434.00 ACCOUNTS PAYABLE CHECK 1099842 06/21/2018 ROADLINE PRODUCTS INC R 14231. so ACCOUNTS PAYABLE CHECK 1099843 06/21/2018 ROBERT SNYDER R 180.00 ACCOUNTS PAYABLE CHECK 1099844 06/21/2018 FRANK SBERNO R 345.23 ACCOUNTS PAYABLE CHECK 1099845 06/21/2018 MARK K SMITH R 699.00 ACCOUNTS PAYABLE CHECK 1099846 06/21/2018 SOUTH COAST AQMD R 235.86 ACCOUNTS PAYABLE CHECK 1099847 06/21/2018 SOUTHERN CALIFORNIA ERGON R 2365.01 ACCOUNTS PAYABLE CHECK 1099848 06/21/2018 SOUTHERN CALIFORNIA GAS C R 14329.69 ACCOUNTS PAYABLE CHECK 1099849 06/21/2018 SOUTHWEST PLUMBING R 591.16 ACCOUNTS PAYABLE CHECK 1099850 06/21/2018 SPOK/USA MOBILITY WIRELES R 44.14 ACCOUNTS PAYABLE CHECK 1099851 06/21/2018 STEVEN KEYLON R 325.00 ACCOUNTS PAYABLE CHECK 1099852 06/21/2018 SUNBELT CONTROLS INC R 7675.00 ACCOUNTS PAYABLE CHECK 1099853 06/21/2018 SUPERIOR READY MIX CONCRE R 221.27 ACCOUNTS PAYABLE CHECK 1099854 06/21/2018 TELOS IDENTITY MGMT SOLUT R 2043.50 ACCOUNTS PAYABLE CHECK 1099855 06/21/2018 THE SOCO GROUP INC R 1165.71 ACCOUNTS PAYABLE CHECK 1099856 06/21/2018 TIME WARNER CABLE R 199.99 ACCOUNTS PAYABLE CHECK 1099857 06/21/2018 TIME WARNER CABLE R 204.98 ACCOUNTS PAYABLE CHECK 1099858 06/21/2018 TIME WARNER CABLE R 299.99 ACCOUNTS PAYABLE CHECK 1099859 06/21/2018 TIME WARNER CABLE R 199.99 ACCOUNTS PAYABLE CHECK 1099860 06/21/2018 TIME WARNER CABLE R 89.94 ACCOUNTS PAYABLE CHECK 1099861 06/21/2018 TIME WARNER CABLE R 339.93 ACCOUNTS PAYABLE CHECK 1099862 06/21/2018 TIME WARNER CABLE R 199.99 ACCOUNTS PAYABLE CHECK 1099863 06/21/2018 TIME WARNER CABLE R 234.99 ACCOUNTS PAYABLE CHECK 1099864 06/21/2018 TIME WARNER CABLE R 264.99 ACCOUNTS PAYABLE CHECK 1099865 06/21/2018 TIME WARNER CABLE R 189.94 ACCOUNTS PAYABLE CHECK 1099866 06/21/2018 TIME WARNER CABLE R 99.98 ACCOUNTS PAYABLE CHECK 1099867 06/21/2018 TIME WARNER CABLE R 126.32 ACCOUNTS PAYABLE CHECK 1099868 06/21/2018 TIME WARNER CABLE R 1870.00 ACCOUNTS PAYABLE CHECK 1099869 06/21/2018 TIME WARNER CABLE R 1090.00 ACCOUNTS PAYABLE CHECK 41SUNGARD PENTAMATION -FUND ACCOUNTING MANAGER PAGE NUMBER: 3 DATE: 06/21/18 CITY OF PALM SPRINGS ACCTPA21 TIME: 15:59:54 CHECK REGISTER INCLUDING SYSTEM VOIDS ACCOUNTING PERIOD: 12/18 SELECTION CRITERIA: chkstat.rundate='06/21/2018' 1099870 06/21/2018 TOPS N BARRICADES INC R 11028.51 ACCOUNTS PAYABLE CHECK 1099871 06/21/2018 UNITED RENTALS R 1124.58 ACCOUNTS PAYABLE CHECK 1099872 06/21/2018 URS CORPORATION R 54902.59 ACCOUNTS PAYABLE CHECK 1099873 06/21/2018 US BANK CORPORATE PAYMENT v 0.00 VOID: MULTI STUB CHECK 1099874 06/21/2018 US BANK CORPORATE PAYMENT R 27745.71 ACCOUNTS PAYABLE CHECK 1099875 06/21/2018 US SECURITY ASSOCIATES IN R 8949.11 ACCOUNTS PAYABLE CHECK 1099876 06/21/2018 VALLEY LOCK AND SAFE R 5963.06 ACCOUNTS PAYABLE CHECK 1099877 06/21/2018 VALLEY MAIL DELIVERY R 2729.06 ACCOUNTS PAYABLE CHECK 1099878 06/21/2018 VCA DESERT ANIMAL HOSPITA R 167.24 ACCOUNTS PAYABLE CHECK 1099879 06/21/2018 VISION SERVICE PLAN R 5663.24 ACCOUNTS PAYABLE CHECK 1099880 06/21/2018 WAXIE SANITARY SUPPLY R 4997.73 ACCOUNTS PAYABLE CHECK 1099881 06/21/2018 WESTLITE SUPPLY CO INC R 2011.88 ACCOUNTS PAYABLE CHECK 1099882 06/21/2018 WINNERS SPORTWEAR R 3653.10 ACCOUNTS PAYABLE CHECK 1099883 06/21/2018 X-ANNA INC R 250.00 ACCOUNTS PAYABLE CHECK 1099884 06/21/2018 YUCAIPA BIKE CENTER R 5974.27 ACCOUNTS PAYABLE CHECK 1099885 06/21/2018 COLONY PALMS HOTEL R 196550 .13 ACCOUNTS PAYABLE CHECK 1099886 06/21/2018 RIVERSIDE COUNTY CLERK R 50.00 ACCOUNTS PAYABLE CHECK 1099887 06/21/2018 REGISTRAR OF VOTERS R 119501.05 ACCOUNTS PAYABLE CHECK 1099888 06/21/2018 PALM GROVE GROUP LLC R 117056.23 ACCOUNTS PAYABLE CHECK 1099889 06/21/2018 PALM SPRINGS PROMENADE LL R 124481.91 ACCOUNTS PAYABLE CHECK 1099890 06/21/2018 ROBERT C PEROTTI R 290.00 ACCOUNTS PAYABLE CHECK 1099891 06/21/2018 JOSE ARELLANO R 86.91 ACCOUNTS PAYABLE CHECK 1099892 06/21/2018 MELISSA DESMARAIS R 680.30 ACCOUNTS PAYABLE CHECK 1099893 06/21/2018 WILLIAM HUTCHINSON R 1165.12 ACCOUNTS PAYABLE CHECK 1099894 06/21/2018 GRISELDA LOPEZ R 190.00 ACCOUNTS PAYABLE CHECK 1099895 06/21/2018 BRYAN REYES R 1387.30 ACCOUNTS PAYABLE CHECK 1099896 06/21/2018 RICHARD SALOMON R 150.00 ACCOUNTS PAYABLE CHECK 1099897 06/21/2018 SBCSD R 1159.00 ACCOUNTS PAYABLE CHECK 1099898 06/21/2018 MICHAEL TORRES R 86.91 ACCOUNTS PAYABLE CHECK 1099899 06/21/2018 MIGUEL TORRES R 304.00 ACCOUNTS PAYABLE CHECK 1099900 06/21/2018 JARVIS CRAWFORD R 141.71 ACCOUNTS PAYABLE CHECK 1099901 06/21/2018 RASHAE CRAWFORD R 50.00 ACCOUNTS PAYABLE CHECK 1099902 06/21/2018 MICHAEL MAIDMENT R 415.93 ACCOUNTS PAYABLE CHECK 1099903 06/21/2018 JOSE TORRES R 146.53 ACCOUNTS PAYABLE CHECK TOTAL FUND 1908533.84 TOTAL REPORT 1908533.84 42 Ariana Muniz From: Sent: To : Cc : Subject: Federa l : Thomas Hays Thu rsday, June 7, 2018 9:26AM Do lores O lve ra; Sh ar on Riddle; Ar iana Muniz Ma r la Pendleton Payrol l Sepa r at ion Ch eck 6/6/2018 Fede r al and Sta te Tax Payme nts EFT ACKNOWLEDGEr.1 ENT NUMBER: 270855991843569 PLEASE tJOTE ~.n y amounts represe nted 1n the su b ca tego nes of Socia l Sec urity, Mecl1care . an d Income Tax 1Nith h olcling are for tn fo rrna ti onal pur poses onl y. ' Payment Information Entered Data TaxpayerEJN Tax Form Tax Type Tax Period Payment Amount Settlement Date Subcategories: 2 Medicare 3 Tax Withholding Sta t e : xxxxx07 57 941 Employers Fe deral Tax Federa l Tax Deposit Q2J20 18 $4.93 1.98 06/08/20 18 M60.58 $4,47 1.40 1 43 RESOLUTION NO. A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF PALM SPRINGS, CALIFORNIA, APPROVING PAYMENT OF CLAIMS AND DEMANDS BY WARRANTS NUMBERED 1099904 THROUGH 1100030 IN THE AGGREGATE AMOUNT OF $1,284,027.61 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 claims and demands shown on the attached list; and WHEREAS, the Director of Finance hereby certifies to the accuracy of said records and to the availability of funds for payment. NOW, THEREFORE BE IT RESOLVED that claims and demands numbered 1099904 through 1100030 have been audited as required by law and that said warrants are hereby approved for payment. ADOPTED THIS 5TH DAY OF SEPTEMBER, 2018. ATTEST: Anthony J. Mejia, MMC, City Clerk STATE OF CALIFORNIA ) COUNTY OF RIVERSIDE ) ss. CITY OF PALM SPRINGS ) David H. Ready, Esq., Ph.D. City Manager CERTIFICATION I, ANTHONY J. MEJIA, City Clerk of the City of Palm Springs, hereby certify that Resolution No. ___ 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 , by the following vote: AYES: NOES: ABSENT: ABSTAIN: IN WITNESS WHEREOF, I have hereunto set my hand and affixed the official seal of the City of Palm Springs, California, this day of _________ _ Anthony J. Mejia, MMC, City Clerk City of Palm Springs, California 44SUNGARD PENTAMATION -FUND ACCOUNTING MANAGER PAGE NUMBER: 1 DATE: 06/28/18 CITY OF PALM SPRINGS ACCTPA21 TIME: 16:35:46 CHECK REGISTER INCLUDING SYSTEM VOIDS ACCOUNTING PERIOD: 12/18 SELECTION CRITERIA: chkstat.rundate='06/28/2018' DISTRIBUTION FUND: 001 CHECK NUMBER 1099904 1099905 1099906 1099907 1099908 1099909 1099910 1099911 1099912 1099913 1099914 1099915 1099916 1099917 1099918 1099919 1099920 1099921 1099922 1099923 1099924 1099925 1099926 1099927 1099928 1099929 1099930 1099931 1099932 1099933 1099934 1099935 1099936 1099937 1099938 1099939 1099940 1099941 1099942 1099943 1099944 1099945 1099946 1099947 1099948 1099949 1099950 1099951 1099952 1099953 1099954 1099955 1099956 1099957 ISSUE DATE 06/28/2018 06/28/2018 06/28/2018 06/28/2018 06/28/2018 06/28/2018 06/28/2018 06/28/2018 06/28/2018 06/28/2018 06/28/2018 06/28/2018 06/28/2018 06/28/2018 06/28/2018 06/28/2018 06/28/2018 06/28/2018 06/28/2018 06/28/2018 06/28/2018 06/28/2018 06/28/2018 06/28/2018 06/28/2018 06/28/2018 06/28/2018 06/28/2018 06/28/2018 06/28/2018 06/28/2018 06/28/2018 06/28/2018 06/28/2018 06/28/2018 06/28/2018 06/28/2018 06/28/2018 06/28/2018 06/28/2018 06/28/2018 06/28/2018 06/28/2018 06/28/2018 06/28/2018 06/28/2018 06/28/2018 06/28/2018 06/28/2018 06/28/2018 06/28/2018 06/28/2018 06/28/2018 06/28/2018 VENDOR 4IMPRINT INC ABBE MEYER AIRWAVE COMMUNICATIONS EN AL MILLER AND SONS ROOFIN ALL STAR GLASS ALLSTAR FIRE EQUIPMENT IN ALPHA MEDIA LLC ALTA PLANNING & DESIGN AMERICAN FORENSIC NURSES AMERICAN LIBRARY ASSOCIAT ATWORK PERSONNEL SERVICES BAKER AND TAYLOR BOOKS BEST SIGNS INC BIO TOX LABORATORIES BRODART CO CALIF HIGHWAY PATROL CALIFORNIA BOILER CENTRAL COMMUNICATIONS CHRIS W FOSTER INC CINTAS CORPORATION CLASSIC AUTO RESTYLING CNS ENGINEERS INC COUNTY OF RIVERSIDE CRAFCO INC CV WEEKLY DATA TICKET INC DELL MARKETING LP DEPARTMENT OF INDUSTRIAL DESERT PROMOTIONAL EMBROI DESERT WATER AGENCY DIAMOND ENVIRONMENTAL SER DL CONSULTING EISENHOWER OCCUPTIONAL HE ENVISIONWARE, INC. FBI-LEEDA FEDERAL EXPRESS CORPORATI FED EX FLOWBOX G/M BUSINESS INTERIORS GL THE VERY BEST SERVICES GRANITE CONSTRUCTION COMP GRAPHTEK INTERACTIVE HAINES AND COMPANY INC HARRIS AND ASSOCIATES INC INTERWEST CONSULTING GROU JESSUP AUTO PLAZA COLLISO MAYA KALABIC LA PRENSA HISPANA INC LANCE SOLL AND LUNGHARD L KARLA MNATSAKANYAN MUNISERVICES LLC MWH CONSTRUCTORS INC NALCO COMPANY NANCY K BOHL INC STATUS R R R R R R R R R R R R R R R R R R R R R R R R R R R R R R R R R R R R R R R R R R R R R R R R R R R R R R TOTAL DESCRIPTION 1041.10 3500.00 400.08 14630.00 794.93 4850.70 520.00 3566.00 436.50 9.00 904.34 229.65 489.44 2255.50 29.78 255.00 880.20 1543.86 2100.00 509.59 165.00 177721.18 300.00 4906.94 1800.00 2855.85 756.54 675.00 78.30 65609.47 379.11 7250.00 7464.00 1523.87 2600.00 495.59 10.63 200.00 657.62 1000.00 2505.15 300.00 1599.78 8250.90 33162.05 556.42 1500.00 2500.00 68929.00 20.00 3448.50 16016.00 4217.62 475.00 ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK ACCOUNTS PAYABLE CHECK 45SUNGARD PENTAMATION -FUND ACCOUNTING MANAGER PAGE NUMBER: 2 DATE: 06/28/18 CITY OF PALM SPRINGS ACCTPA21 TIME: 16:35:46 CHECK REGISTER INCLUDING SYSTEM VOIDS ACCOUNTING PERIOD: 12/18 SELECTION CRITERIA: chkstat.rundate='06/28/2018' 1099958 06/28/2018 NATURES IMAGE INC R 50982.37 ACCOUNTS PAYABLE CHECK 1099959 06/28/2018 OFFICE DEPOT R 4764.92 ACCOUNTS PAYABLE CHECK 1099960 06/28/2018 OFFICE DEPOT R 4135.94 ACCOUNTS PAYABLE CHECK 1099961 06/28/2018 ONTRAC R 78.40 ACCOUNTS PAYABLE CHECK 1099962 06/28/2018 OVERDRIVE INC R 1896.84 ACCOUNTS PAYABLE CHECK 1099963 06/28/2018 PACIFIC MEDICAL WASTE R 178.52 ACCOUNTS PAYABLE CHECK 1099964 06/28/2018 PALM SPRINGS MOTORS R 60.78 ACCOUNTS PAYABLE CHECK 1099965 06/28/2018 PARKHOUSE TIRE INC R 192.22 ACCOUNTS PAYABLE CHECK 1099966 06/28/2018 PARKVIEW MOBILE ESTATES R 340.00 ACCOUNTS PAYABLE CHECK 1099967 06/28/2018 PATTON DOOR AND GATE R 125.00 ACCOUNTS PAYABLE CHECK 1099968 06/28/2018 PROPER SOLUTIONS INC v 0.00 VOID: MULTI STUB CHECK 1099969 06/28/2018 PROPER SOLUTIONS INC R 12973.60 ACCOUNTS PAYABLE CHECK 1099970 06/28/2018 PRUDENTIAL OVERALL SUPPLY R 121.60 ACCOUNTS PAYABLE CHECK 1099971 06/28/2018 REGINA M RENE R 650.00 ACCOUNTS PAYABLE CHECK 1099972 06/28/2018 RISELO ENGINEERING SOLUTI R 13387.50 ACCOUNTS PAYABLE CHECK 1099973 06/28/2018 ROYAL CANIN R 407.92 ACCOUNTS PAYABLE CHECK 1099974 06/28/2018 SMG R 56937.91 ACCOUNTS PAYABLE CHECK 1099975 06/28/2018 SOUTH COAST EMERGENCY VEH R 1123.49 ACCOUNTS PAYABLE CHECK 1099976 06/28/2018 SOUTHERN CALIFORNIA EDISO R 23543.34 ACCOUNTS PAYABLE CHECK 1099977 06/28/2018 ST. FRANCIS ELECTRIC LLC R 21405.12 ACCOUNTS PAYABLE CHECK 1099978 06/28/2018 STEVE CASAREZ R 1360.00 ACCOUNTS PAYABLE CHECK 1099979 06/28/2018 STL LANDSCAPE INC R 28132.35 ACCOUNTS PAYABLE CHECK 1099980 06/28/2018 SUPERIOR READY MIX CONCRE R 312.48 ACCOUNTS PAYABLE CHECK 1099981 06/28/2018 SWAGIT PRODUCTIONS LLC R 17850.00 ACCOUNTS PAYABLE CHECK 1099982 06/28/2018 SYMBLAZE INC R 6000.00 ACCOUNTS PAYABLE CHECK 1099983 06/28/2018 TC LIFE SAFETY INC R 1223.03 ACCOUNTS PAYABLE CHECK 1099984 06/28/2018 THE SOCO GROUP INC R 8228.56 ACCOUNTS PAYABLE CHECK 1099985 06/28/2018 TOPS N BARRICADES INC R 207.03 ACCOUNTS PAYABLE CHECK 1099986 06/28/2018 TPX COMMUNICATIONS R 436.32 ACCOUNTS PAYABLE CHECK 1099987 06/28/2018 TRANSUNION RISK AND ALTER R 375.00 ACCOUNTS PAYABLE CHECK 1099988 06/28/2018 TRASHCANS UNLIMITED INC R 14505.36 ACCOUNTS PAYABLE CHECK 1099989 06/28/2018 TSUNAMI WASH R 68.90 ACCOUNTS PAYABLE CHECK 1099990 06/28/2018 UNITED RENTALS R 588.53 ACCOUNTS PAYABLE CHECK 1099991 06/28/2018 UNITED TRANSMISSION EXCHA R 9002.02 ACCOUNTS PAYABLE CHECK 1099992 06/28/2018 UNIVAR R 1948.26 ACCOUNTS PAYABLE CHECK 1099993 06/28/2018 US BANK R 2200.00 ACCOUNTS PAYABLE CHECK 1099994 06/28/2018 US BANK CORPORATE PAYMENT R 12223.77 ACCOUNTS PAYABLE CHECK 1099995 06/28/2018 US SECURITY ASSOCIATES IN R 25673.87 ACCOUNTS PAYABLE CHECK 1099996 06/28/2018 V AND V MANUFACTURING R 36.22 ACCOUNTS PAYABLE CHECK 1099997 06/28/2018 VALLEY LOCK AND SAFE R 3175.65 ACCOUNTS PAYABLE CHECK 1099998 06/28/2018 VARIDESK LLC R 1207.13 ACCOUNTS PAYABLE CHECK 1099999 06/28/2018 VERIZON WIRELESS R 3.06 ACCOUNTS PAYABLE CHECK 1100000 06/28/2018 VERIZON WIRELESS R 1997.11 ACCOUNTS PAYABLE CHECK 1100001 06/28/2018 VERIZON WIRELESS R 99.76 ACCOUNTS PAYABLE CHECK 1100002 06/28/2018 VERIZON WIRELESS R 922.74 ACCOUNTS PAYABLE CHECK 1100003 06/28/2018 WESTERN ENERGY SYSTEMS R 5092.35 ACCOUNTS PAYABLE CHECK 1100004 06/28/2018 WESTERN PUMP INC R 6451.16 ACCOUNTS PAYABLE CHECK 1100005 06/28/2018 YATES GEAR INC R 1873.23 ACCOUNTS PAYABLE CHECK 1100006 06/28/2018 YOSHI LAWNMOWER SHOP LLC R 279.08 ACCOUNTS PAYABLE CHECK 1100007 06/28/2018 WESSMAN DEVELOPMENT CO. R 1433.00 ACCOUNTS PAYABLE CHECK 1100008 06/28/2018 ARIANA MUNIZ R 125.15 ACCOUNTS PAYABLE CHECK 1100009 06/28/2018 SOUTHERN CALIFORNIA ED ISO R 75043.85 ACCOUNTS PAYABLE CHECK 1100010 06/28/2018 PETER KING R 88.67 ACCOUNTS PAYABLE CHECK 1100011 06/28/2018 MARK JUCHT R 131.89 ACCOUNTS PAYABLE CHECK 1100012 06/28/2018 STEVE URIBES R 119.36 ACCOUNTS PAYABLE CHECK 1100013 06/28/2018 DALE COOK R 1075.62 ACCOUNTS PAYABLE CHECK 1100014 06/28/2018 HILTON PALM SPRINGS RESOR R 277135.08 ACCOUNTS PAYABLE CHECK 1100015 06/28/2018 PALM SPRINGS PROMENADE LL R 114074.62 ACCOUNTS PAYABLE CHECK 46SUNGARD PENTAMATION -FUND ACCOUNTING MANAGER PAGE NUMBER: 3 DATE: 06/28/18 CITY OF PALM SPRINGS ACCTPA21 TIME: 16:35:46 CHECK REGISTER INCLUDING SYSTEM VOIDS ACCOUNTING PERIOD: 12/18 SELECTION CRITERIA: chkstat.rundate='06/28/2018' 1100016 06/28/2018 CARMEN A TOSTADO R 50.00 ACCOUNTS PAYABLE CHECK 1100017 06/28/2018 BYRON FARLEY R 4180.00 ACCOUNTS PAYABLE CHECK 1100018 06/28/2018 MARIO SERRANO R 2683.00 ACCOUNTS PAYABLE CHECK 1100019 06/28/2018 ABRAHAM VARGAS R 2683.00 ACCOUNTS PAYABLE CHECK 1100020 06/28/2018 JENNIFER RIVERA CALLEROS R 1.80 ACCOUNTS PAYABLE CHECK 1100021 06/28/2018 LUCIANO COLANTUONO R 8.70 ACCOUNTS PAYABLE CHECK 1100022 06/28/2018 LAUREN DRINKWATER R 582.85 ACCOUNTS PAYABLE CHECK 1100023 06/28/2018 PETER GARCIA R 15.00 ACCOUNTS PAYABLE CHECK 1100024 06/28/2018 MARCUS LITCH R 224.42 ACCOUNTS PAYABLE CHECK 1100025 06/28/2018 KIMBERLY PAIRRETT R 1. 08 ACCOUNTS PAYABLE CHECK 1100026 06/28/2018 MIGUEL TORRES R 20.00 ACCOUNTS PAYABLE CHECK 1100027 06/28/2018 TARA GLASS R 127.00 ACCOUNTS PAYABLE CHECK 1100028 06/28/2018 VERONICA GUTIERREZ R 328.00 ACCOUNTS PAYABLE CHECK 1100029 06/28/2018 RYLEE ROGERS R 80.97 ACCOUNTS PAYABLE CHECK 1100030 06/28/2018 ARIS CHAVEZ R 160.92 ACCOUNTS PAYABLE CHECK TOTAL FUND 1284027.61 TOTAL REPORT 1284027.61 47 RESOLUTION NO. A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF PALM SPRINGS, CALIFORNIA, APPROVING PAYMENT OF PAYROLL WARRANTS FOR THE PERIOD ENDED 06-30-2018 BY WARRANTS NUMBERED 420368-420382, AND 1100153 TOTALING $26,732.93 LIABILITY CHECKS NUMBERED 1100031 -1100043, 1100045 -1100050 AND 1100154 TOTALING $76,894.89, FOUR WIRE TRANSFERS FOR $61,322.24, AND FIVE ELECTRONIC ACH DEBITS OF $1,426,363.21 IN THE AGGREGATE AMOUNT OF $1,591,313.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. NOW, THEREFORE BE IT RESOLVED by the City Council of the City of Palm Springs that payroll warrants numbered 420368 -420382, and 1100153, liability checks numbered 1100031 -1100043, 11 00045 -1100050 AND 11 00154, four wire transfers and five electronic ACH debits have been audited as required by law and that said warrants are hereby approved for payment. ADOPTED THIS 5TH DAY OF SEPTEMBER, 2018. ATTEST: Anthony J. Mejia, MMC, City Clerk STATE OF CALIFORNIA ) COUNTY OF RIVERSIDE ) ss. CITY OF PALM SPRINGS ) David H. Ready, Esq., Ph.D. City Manager CERTIFICATION I, ANTHONY J. MEJIA, City Clerk of the City of Palm Springs, hereby certify that Resolution No. __ 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 , by the following vote: AYES: NOES: ABSENT: ABSTAIN: IN WITNESS WHEREOF, I have hereunto set my hand and affixed the official seal of the City of Palm Springs, California, this day of _________ _ Anthony J. Mejia, MMC, City Clerk City of Palm Springs, California 48 Print Check List Execution # XXX714 Function: RPCH Run By: SHARONR Run Start Date: Jul 3, 2018 5:43:53 PM Payroll Bank Account: XXXXX X661, XXXXXX2000 From Pay Issue Date: Jul 6, 2018 To Pay Issue Date: Jul6, 2018 Included Printed: Yes Include Unprinted: Yes Include Voided : Yes Include Cleared: Include Outstanding: Yes Include Reconciled: Include Void Checks Only: Sort By: Check Number User Comment: Executro n # XXX714 run by SHARONR using RPCH docx-XXXX1008 Prepared by ePersonality 4 50 .00 .05 49 Run . J ul 3, 2018 5 43 53 PM Print Check List Page 2 of 2 Sorted By Check Number From Jul6 2018 To Jul6 2018 Bank of America Transit: XXXXXX661 Acco unt: XXXXXXX2000 (• not yet printed) Check# Amount Check D~ E'e~on Code t:!il.mt Check Type Check Statys 420368 1,630.63 Jul6,2018 15839 Andrade, Jose Computer Check Outstanding 420369 1,533.43 Jul6,2018 15905 Castillo, Jorge Computer Check Outstanding 420370 1,043.62 Jul6,2018 16151 Vela , Marco Computer Check Outstanding 420371 2,026.92 Jul6,2018 15784 Richards, Tabitha Computer Check Outstanding 420372 2,650.16 Jul 6,2018 15851 Arden, Sh awn Comp uter Check Outstanding 420373 1,476.36 Jul6,2018 10993 Hu skey, Za chary B Computer Check Outstanding 420374 2,442.85 Ju l 6,2018 15222 Hernandez, Francisco Computer Check Outstand ing 420375 2,123.39 J ul6,2018 04905 Leon, Arnulfo H Computer Check Outstanding 420376 2,105 .84 Jul6, 2018 10253 Mercado, Gilbert R Computer Check Outstanding 420377 2,031 .08 Jul6, 2018 15156 Menley, Charles A Computer Check Outstanding 420378 2.05 J ul6, 2018 15969 Freeman, Morgan E Computer Check Outstanding 420379 1 '140.88 J ul6, 2018 16149 Cappellano, Christopher Computer Check Outstanding 420380 784 .64 Jul6, 2018 16150 Garcia, Luis Computer Check Outstand ing 420381 2,704 .12 Jul6, 2018 16098 Sandoval , Kristin Computer Check Outstanding 420382 1,659 .74 Jul6, 2018 16144 Valdivia, Jacob Computer Check Outstanding Tota l # Checks Re ported : 15 Total Check Amount Re p o rted . $25,355.71 Execut ion# XXX7 14 run by SHARONR us1ng RPC H docx-XXXX1008 Prepa red by ePersonaht y 4 .50.00.05 50SUNGARD PENTAMATION -FUND ACCOUNTING MANAGER PAGE NUMBER: 1 DATE: 07/05/18 CITY OF PALM SPRINGS ACCTPA21 TIME: 11:25:59 CHECK REGISTER INCLUDING SYSTEM VOIDS ACCOUNTING PERIOD: 13/18 SELECTION CRITERIA: chkstat.rundate='07/06/2018' DISTRIBUTION FUND: 001 CHECK NUMBER ISSUE DATE VENDOR STATUS TOTAL DESCRIPTION 1100031 07/06/2018 AMERICAN FIDELITY ASSURAN R 516.78 ACCOUNTS PAYABLE CHECK 1100032 07/06/2018 EMPLOYMENT DEVELOPMENT DE R 93.10 ACCOUNTS PAYABLE CHECK 1100033 07/06/2018 KANSAS PAYMENT CENTER R 284.50 ACCOUNTS PAYABLE CHECK 1100034 07/06/2018 GARNISHMENT R 1025.54 ACCOUNTS PAYABLE CHECK 1100035 07/06/2018 AFLAC R 100.95 ACCOUNTS PAYABLE CHECK 1100036 07/06/2018 DAVEY ADMIN GROUP R 9366.90 ACCOUNTS PAYABLE CHECK 1100037 07/06/2018 FIRE MANAGEMENT ASSOCIATI R 112.50 ACCOUNTS PAYABLE CHECK 1100038 07/06/2018 FRANCHISE TAX BOARD R 705.75 ACCOUNTS PAYABLE CHECK 1100039 07/06/2018 LIBERTY MUTUAL INSURANCE R 1124.29 ACCOUNTS PAYABLE CHECK 1100040 07/06/2018 MANAGEMENT ASSN OF PALM S R 1031.25 ACCOUNTS PAYABLE CHECK 1100041 07/06/2018 PALM SPRINGS FIREMENS ASS R 1841.28 ACCOUNTS PAYABLE CHECK 1100042 07/06/2018 POLICE OFFICERS' ASSOCIAT R 8613.45 ACCOUNTS PAYABLE CHECK 1100043 07/06/2018 RIVERSIDE COUNTY SHERIFF R 75.00 ACCOUNTS PAYABLE CHECK 1100044 07/06/2018 SEIU LOCAL 721 CTW AND C R VO I::D E:P .. 2577.58 ACCOUNTS PAYABLE CHECK 1100045 07/06/2018 SUN COMMUNITY R 44686.35 ACCOUNTS PAYABLE CHECK 1100046 07/06/2018 UNITED WAY OF THE DESERT R 134.00 ACCOUNTS PAYABLE CHECK 1100047 07/06/2018 GARNISHMENT R 152.00 ACCOUNTS PAYABLE CHECK 1100048 07/06/2018 PS FIRE SAFETY UNIT R 2230.60 ACCOUNTS PAYABLE CHECK 1100049 07/06/2018 GARNISHMENT R 620.50 ACCOUNTS PAYABLE CHECK 1100050 07/06/2018 TRANSAMERICA WORKSITE MAR R 1643.07 ACCOUNTS PAYABLE CHECK TOTAL FUND 76935.39 TOTAL REPORT 76935.39 51SUNGARD PENTAMATION -FUND ACCOUNTING MANAGER PAGE NUMBER: 1 DATE: 07/09/18 CITY OF PALM SPRINGS ACCTPA21 TIME: 17:10:28 CHECK REGISTER INCLUDING SYSTEM VOIDS ACCOUNTING PERIOD: 1/19 SELECTION CRITERIA: chkstat.rundate='07/09/2018' DISTRIBUTION FUND: 001 CHECK NUMBER ISSUE DATE VENDOR STATUS TOTAL DESCRIPTION 1100044 07/09/2018 SEIU LOCAL 721 CTW AND c v -2577.58 VOID MANUAL CHECK * 1100153 07/09/2018 SEIU LOCAL 721 CTW AND c R 2537.08 ACCOUNTS PAYABLE CHECK 1100154 07/09/2018 SHARON RIDDLE R 1377.22 ACCOUNTS PAYABLE CHECK TOTAL FUND 1336.72 TOTAL REPORT 1336.72 52 Pre v i ous Da y ACH Re port Company: Palm Springs CA City of Requestor: A ri ana Muniz Run Date: 08/23/2018 14:47:35 COT As of : 07/06/201 8 Bank of America, Southern Ca lifornia 1 XXXXXX661 XXXXX XX2000 I City of Pa lm Springs Ge neral Acct I USD I As of: 07/06/20 18 Det ai l Cred its Bank of America~ Merrill Lynch Transact ion ____ __jl Amount ,l,_o_Da_Y ___ ....... Jl 1 Day Float Jl 2+ Day Float I Pr ea uthorized AC H Credit (165) 13,95 1 .03 13,951.03 Pr eau thorized ACH Credit (165) Prea uthor ized ACH Credit (165) Pre au thorized ACH Credit (165) Preauthorized ACH Credit (165) Individual ACH Return Item CR (257) Credit To tals 4 ,850.00 4,735.00 577.00 5.25 1,377 .22 25,495.50 Detail Debits ___________ _ Transaction Preau thoriz ed ACH Deb it (455) Preauthorized ACH Debit (455) Pre au thorized ACH De bit (455) ACH Settlemen t Debit (466) ACH Settlement Debit (466) Debit Tot als Tota l s Bank Tota ls 07/06/201 8 Tota l Credi ts Total Debits Report Tot al s 07/06/2018 USD Totals Total Cre dits Total Debits 6 5 6 5 Amount 376 ,861.30 ./ 234 ,036.24 / 72,056.92 ../ 1,1 15,629.40 / 200.00 1 , 798 ,783.86 25.495.50 1 '798.783.86 Amount 25.495.50 1.798. 783.86 4 ,850.00 4,735.00 577.00 5.25 1 ,377 .22 25,495.50 Bank Ref 87002728248 87002292383 87002700211 87003325761 87008 781753 Page 1 0.00 0.00 87003632926 0000000000 0 .00 0.00 87003632927 0000000000 0.00 0.00 87003632928 0000000000 0.00 0.00 86 020581168 0000000000 0.00 0.00 87003608865 0000000000 0.00 0 .00 87003325762 0000000000 0.00 0.00 C ust Ref 0000000000 0000000000 0000000000 t..l ~ 1 1 . '2. t)IY'\ZJUC\~ tn 0000000000 c~\L ~~ ;-G(' 0000000000 w-tt:-1\0D ' l.\ ::. I, 1114 tY52 I \ s 53 Previous Day ACH Report Company: Pal m Springs CA City o f Requ estor : Ari ana Muniz Run Date: 08/23/2018 15:08 :51 COT As of: 07/10/2018 B ank of Am erica, Southe rn Ca l ifo rn ia I XXXXXX66 1 XXXXXXX2000 I Ci ty of Palm Springs General Acct I USD I As of: 07/10/2018 Deta il Cre dits Tran saction ! 0 Day 11 Day F loat Pre authorized AC H Credit (165) Pre author ized ACH Cred it (165) Pre authorized ACH Credit (165) Pre authorized ACH Credit (165) Prea uthoriz ed ACH Cred it (165) Pre auth orized ACH Credit (165) Credit Totals Detail Debits Transaction Preauthorized ACH Debit (455) Debit Totals Tota ls Bank Totals 07/10/2018 14 ,8 0 2.80 14 ,802.80 11 ,397.94 11,397.94 6 ,002.00 6,0 02.00 1 ,166.00 1 '1 6 6.00 55.00 55.00 38.00 38.00 33,461 .74 33,461 .74 Amount B ank Ref J 5,8 17 .87 9002 1043746 5,817.87 Bank of America, Southern California I XXXXXX661 (USD) Totals Total Cred its Total Debits Report Totals 07/10/2018 Total Cred its Total Debits Count 6 Count 6 Amount 33,46 1.74 ---- Amount 5,8 17.87 33.461 .74 5 ,817 .87 Page 1 0 .00 0.00 0 .00 0 .00 0.00 0 .00 0 .00 BankofAmerica~ Merrill Lynch n 2+ Day Float II Bank Ref 0.00 91004 13641 9 000 0000000 0.00 91 0 04136418 0000000000 0.00 91 0 041 364 20 0 000000000 0.00 90021 24 5752 0000000000 0.00 91 00411 2683 0000 000000 0.00 9 100411 24 94 0000000000 0.00 Gus t Ref 00000 00000 54 Previous Day Wire Report Company: Palm Springs CA Ci ty of Req uestor : A rian a Mun iz Run Date: 08/23/2018 14:49:26 COT A s of: 07/06 /2018 B ank of A m erica, Southern Ca liforni a I XXXXXX661 XXXXXX2000 I City of Palm Springs General Acct I US D I As of: 07 /06/2018 Detail Debits Transaction Amount Outgoing Money Transfer Debit (495) J 29,023 .15 ---------------- Outgoing Money Tra nsfer Debit (495) Outgoing Money Transfer Debit (495) Outgoing Money Tra nsfer Deb it (495) Debit Totals Totals Bank Totals 07 /06 /2 018 ./ 22,120.06 ./ 9,481.25 / 697.78 61,322.24 Bank of America, Southern California 1 XXXXX661 (USD) Totals Total Credits Tot a l Debits Report T otals 07/06 /2018 USD Totals Total Credits Total Debits Count 0 4 Co unt 0 4 Amount Amount 0.00 61,32 2.24 0.00 61 ,322.24 Bank Ref 00370041540 003 7004 1541 00370041542 00370041539 Page 1 Bank of America~ Merrill Lynch Cust Ref 0000000000 ------- 0000000000 000000000 0 0000000000