In: Accounting
The Elegant Table sells china, glassware, and other gift items that are subject to an 8 percent sales tax. The transactions shown below took place during November 2019. DATE TRANSACTIONS Nov 1 Sold china to Pauline Judge; issued Sales Slip 1001 for $1,625 plus $130 sales tax. 5 Sold a brass serving tray to Janet Hutchison; issued Sales Slip 1002 for $2,225 plus $178 sales tax. 6 Sold a vase to Charles Brown; issued Sales Slip 1003 for $825 plus $66 sales tax. 10 Sold a punch bowl and glasses to Lisa Morgan; issued Sales Slip 1004 for $1,825 plus $146 sales tax. 14 Sold a set of serving bowls to Dorothy Watts; issued Sales Slip 1005 for $675 plus $54 sales tax. 17 Gave Lisa Morgan an allowance because of a broken glass discovered when unpacking the punch bowl and glasses sold on November 10, Sales Slip 1004; issued Credit Memorandum 102 for $156, which includes sales tax of $12. 21 Sold a coffee table to Teresa Yu; issued Sales Slip 1006 for $3,325 plus $266 sales tax. 24 Sold sterling silver teaspoons to Henry Okafor; issued Sales Slip 1007 for $725 plus $58 sales tax. 25 Gave Teresa Yu an allowance for scratches on her coffee table sold on November 21, Sales Slip 1006; issued Credit Memorandum 103 for $372, which includes $28 in sales tax. 30 Sold a clock to Elaine Brock; issued Sales Slip 1008 for $3,925 plus $314 sales tax. Required: Record the transactions for November in the proper journal. Post to the accounts receivable ledger. Post the amounts from the general journal daily. Post the sales journal amount as a total at the end of the month. Prepare a schedule of accounts receivable. Compare the balance of the Accounts Receivable control account with the total of the schedule. Analyze: Which customer has the highest balance owed at November 30, 2019?
| Please hit LIKE button if this helped. For any further explanation, please put your query in comment, will get back to you. | |||||
| Sales Journal: | |||||
| Date | Slip | Customer Name | Accounts Receivable Debit | Sales Tax Payable Credit | Sales Credit |
| Nov 1 | 1001 | Pauline Judge | $ 1,755 | $ 130 | $ 1,625 |
| Nov 5 | 1002 | Janet Hutchison | $ 2,403 | $ 178 | $ 2,225 |
| Nov 6 | 1003 | Charles Brown | $ 891 | $ 66 | $ 825 |
| Nov 10 | 1004 | Lisa Morgan | $ 1,971 | $ 146 | $ 1,825 |
| Nov 14 | 1005 | Dorothy Watts | $ 729 | $ 54 | $ 675 |
| Nov 21 | 1006 | Taresa You | $ 3,591 | $ 266 | $ 3,325 |
| Nov 24 | 1007 | Henry Okafor | $ 783 | $ 58 | $ 725 |
| Nov 30 | 1008 | Elaine Brock | $ 4,239 | $ 314 | $ 3,925 |
| Nov 30 | Totals | $ 16,362 | $ 1,212 | $ 15,150 | |
| General Journal: | |||||
| No | Transaction | General Journal | Debit | Credit | |
| 102 | Nov 17 | Sales Return and Allowance | $ 144 | ||
| Sales Tax Payable | $ 12 | ||||
| Accounts Receivable | $ 156 | ||||
| 103 | Nov 25 | Sales Return and Allowance | $ 344 | ||
| Sales Tax Payable | $ 28 | ||||
| Accounts Receivable | $ 372 | ||||
| Ledger | |||||
| Accounts Receivable | |||||
| Debit | Credit | ||||
| Nov 30 | $ 16,362 | Nov 17 | $ 156 | ||
| Nov 25 | $ 372 | ||||
| Ending Balance | $ 15,834 | ||||
| Sales Tax Payable | |||||
| Debit | Credit | ||||
| Nov 17 | $ 12 | Nov 30 | $ 1,212 | ||
| Nov 25 | $ 28 | ||||
| Ending Balance | $ 1,172 | ||||
| Sales | |||||
| Debit | Credit | ||||
| Nov 30 | $ 15,150 | ||||
| Ending Balance | $ 15,150 | ||||
| Sales Return and Allowance | |||||
| Debit | Credit | ||||
| Nov 17 | $ 144 | ||||
| Nov 25 | $ 344 | ||||
| Ending Balance | $ 488 | ||||
| Accounts Receivable Subsidiary Ledger | |||||
| Elain Brock | |||||
| Date | Debit | Credit | Balance | ||
| Nov 30 | $ 4,239 | $ 4,239 | |||
| charles Brown | |||||
| Date | Debit | Credit | Balance | ||
| Nov 6 | $ 891 | $ 891 | |||
| Janet Hutchison | |||||
| Date | Debit | Credit | Balance | ||
| Nov 5 | $ 2,403 | $ 2,403 | |||
| Pauline Judge | |||||
| Date | Debit | Credit | Balance | ||
| Nov1 | $ 1,755 | $ 1,755 | |||
| Lisa Morgan | |||||
| Date | Debit | Credit | Balance | ||
| Nov 10 | $ 1,971 | $ 1,971 | |||
| Nov 17 | $ 156 | $ 1,815 | |||
| Henry Okafor | |||||
| Date | Debit | Credit | Balance | ||
| Nov 24 | $ 783 | $ 783 | |||
| Dorothy Watts | |||||
| Date | Debit | Credit | Balance | ||
| Nov 14 | $ 729 | $ 729 | |||
| Taresa Yu | |||||
| Date | Debit | Credit | Balance | ||
| Nov 21 | $ 3,591 | $ 3,591 | |||
| Nov 17 | $ 372 | $ 3,219 | |||
| Schedule of Accounts Receivable: | |||||
| Elain Brock | $ 4,239 | ||||
| charles Brown | $ 891 | ||||
| Janet Hutchison | $ 2,403 | ||||
| Pauline Judge | $ 1,755 | ||||
| Lisa Morgan | $ 1,815 | ||||
| Henry Okafor | $ 783 | ||||
| Dorothy Watts | $ 729 | ||||
| Taresa Yu | $ 3,219 | ||||
| Total | $ 15,834 | ||||
| Highest Balance Owed | Elain Brock | $ 4,239 | |||