i need help with this assignment

• Once you open the workbook in Excel, be sure to maximize both the Excel program AND the workbook so you can see the various sheet tabs in the lower left corner of your screen. Click on each sheet tab to find the instructions and forms to complete.

CHAPTER 10 ACTIVITY This optional assignment is worth 10 points extra credit. Instructions; 1- Enter the above transactions in the general journal. 2- Post the entries from the journal to the general ledger and subsidiary ledgers provided. 3- Prepare a schedule of accounts receivable as of March 31, 20--. Bernice Ruel operates Leather Unlimited, a leather shop that sells luggage, handbags, business cases, and other leather goods. During the month of March, the following transactions occurred. The applicable sales tax rate is 6%. Date Transaction Mar. 2 Sold merchandise on account to Emma Sommers, $250.00, plus sales tax. 9 Sold merchandise on account to Shelly Feinstein, $470.00, plus sales tax. 12 Emma Sommers returned $40.00 worth of merchandise purchased on March 2 for credit. (Don't forget to credit sales tax too.) Sold merchandise on account to Maureen Hodge, $110.00, plus sales tax. 18 19 Sold merchandise on account to Frank MacDonald, $165.00, plus sales tax. 22 Received payment from Emma Sommers on account. Customer received a 2% discount and paid the balance of her account in full. (Hint: Payment rec'd was $218.40) 26 Maureen Hodge was given an allowance of $30.00 when she reported damage in the merchandise purchased on March 18. 28 Sold merchandise on account to Emma Sommers, $500.00, plus sales tax. 29 Sold merchandise on account to Shelly Feinstein, $230.00, plus sales tax. 31 Received payment from Maureen Hodge on account, $84.80 31 31 Cash sales for the month were $2,600, plus sales tax. Credit card sales for the month were $1,000, plus sales tax. Credit card fees were 3%. JOURNAL DATE 1 20xx Mar DESCRIPTION PAGE POST. REF. DEBIT 1 CREDIT 1 2 2 3 3 4 4 5 5 6 6 7 7 8 8 9 9 10 10 11 11 12 12 13 13 14 14 15 15 16 16 17 17 18 18 19 19 20 20 21 21 22 22 23 23 24 24 25 25 26 26 27 27 28 28 29 29 30 30 31 31 32 32 33 33 34 34 35 35 36 36 37 37 38 38 39 39 40 40 JOURNAL DATE 1 20xx Mar DESCRIPTION PAGE POST. REF. DEBIT 2 CREDIT 1 2 2 3 3 4 4 5 5 6 6 7 7 8 8 9 9 10 10 11 11 12 12 13 13 14 14 15 15 16 16 17 17 18 18 19 19 20 20 21 21 22 22 23 23 24 24 25 25 26 26 27 27 28 28 29 29 30 30 31 31 32 32 33 33 34 34 35 35 36 36 37 37 38 38 39 39 40 40 GENERAL LEDGER ACCOUNT: DATE Cash ITEM 101 ACCOUNT NO.: POST. REF. BALANCE DEBIT CREDIT DEBIT CREDIT 20xx Mar ACCOUNT: DATE Accounts Receivable ITEM 122 ACCOUNT NO.: POST. REF. BALANCE DEBIT CREDIT DEBIT CREDIT 20xx Mar ACCOUNT: DATE Sales Tax Payable ITEM 231 ACCOUNT NO.: POST. REF. BALANCE DEBIT CREDIT DEBIT CREDIT 20xx Mar ACCOUNT: DATE 20xx Mar Sales ITEM 401 ACCOUNT NO.: POST. REF. BALANCE DEBIT CREDIT DEBIT CREDIT GENERAL LEDGER ACCOUNT: DATE Sales Returns and Allowances ITEM ACCOUNT NO.: POST. REF. 401.1 BALANCE DEBIT CREDIT DEBIT CREDIT 20xx Mar ACCOUNT: DATE Sales Discounts ITEM ACCOUNT NO.: POST. REF. 401.2 BALANCE DEBIT CREDIT DEBIT CREDIT 20xx Mar ACCOUNT: DATE 20xx Mar Bank Credit Card Expense ITEM 513 ACCOUNT NO.: POST. REF. BALANCE DEBIT CREDIT DEBIT CREDIT ACCOUNTS RECEIVABLE LEDGERS ACCOUNT: DATE Shelly Feinstein ITEM POST. REF. DEBIT CREDIT BALANCE POST. REF. DEBIT CREDIT BALANCE POST. REF. DEBIT CREDIT BALANCE POST. REF. DEBIT CREDIT BALANCE 20xx Mar ACCOUNT: DATE Maureen Hodge ITEM 20xx Mar ACCOUNT: DATE Frank MacDonald ITEM 20xx Mar ACCOUNT: DATE 20xx Mar Emma Sommers ITEM Leather Unlimited Schedule of Accounts Receivable March 31, 20-- Shelly Feinstein Frank MacDonald Emma Sommers Total