Please answer the question with proper labels and their subparts in Excel format with any required formulas for a great rating. Thank you!

1 E13-7 (Adjusting Entry for sales Tax) During the month of June, Rowling Boutique had cash sales of $233,200 and credit sales of $153,700, both of which include the 6% sales tax that must be remitted to the state by July 15. Instructions Prepare the adjusting entry that should be recorded to fairly present the June 30 financial statements