EXCEL FORMAT PLEASE

5 6 DATE TRANSACTIONS 7 20X1 8 Feb. 9 1 Sold crystal goods to Lovely Kitchens, a wholesale customer. The list price is $4,400, with a 30 percent trade discount. This sale is not subject to sales tax. Issued Invoice 5950 with terms of n/15 10 15 Recorded cash sales for the period from February 1 to February 15 of $8,900 plus sales tax of $712. 11 15 Recorded sales for the period from February 1 to February 15 to customers using bank credit cards of $12,400 plus sales tax of $992. (Record the 2 percent credit card expense at this time.) 12 16 Received a check from Lovely Kitchens in payment of Invoice 5950 dated February 1. 16 Sold merchandise to customers using American Express for $8,400 plus sales tax of $672. 14 17 Sold a set of Roman statues to Beautiful Bedrooms, a wholesale customer. The list price is $8,400, with a 20 percent trade discount. This sale is not subject to sales tax. Issued Invoice 5951 with 15 27 Received a check from Beautiful Bedrooms in payment of Invoice 5951 dated February 17. 16 28 Recorded cash sales for the period from February 16 to February 28 of $7,450 plus sales tax of $596. 28 Recorded sales for the period from February 16 to February 28 to customers using bank credit cards of $15,000 plus sales tax of $1,200. (Record the 2 percent credit card expense at this time.) 18 28 Sold merchandise to customers using American Express for $9,600 plus sales tax of $768. 19 20 13 17 21 22 23 Required: 24 2. Record the transactions in a general journal. 25 3. Post the entries from the general journal to the appropriate accounts in the general ledger and the accounts receivable subsidiary ledger