Fill This Form To Receive Instant Help
Homework answers / question archive / Computerized Accounting Project: Chapter 7 The following trial balance was prepared for Tile, Etc
Computerized Accounting Project: Chapter 7 The following trial balance was prepared for Tile, Etc., Inc., on December 31, 2019, after the closing entries were posted: Account Title Debit Credit Cash $ 195,000 Accounts Receivable 142.000 Allowance for Doubtful Accounts $ 26,500 Merchandise Inventory 459,000 Accounts Payable 112.000 Common Stock 535,000 Retained Earnings 122.500 Totals $ 796,000 $ 796.000 Tile, Etc. had the following transactions in Year 2020: 1. 02/17/2020: Purchased merchandise on account for $865,000. 2. 03/08/2020: Sold merchandise that cost $505,000 for $1,060,000 on account. 3. 04/24/2020: Sold for $330,000 cash merchandise that had cost $194,000 4. 05/20/2020: Sold merchandise for $275,000 to credit card customers. The merchandise had cost $130,000. The credit card company charges a 3 percent fee. 5. 06/01/2020: Loaned $67,000 to K. Parks. The note had an 6 percent interest rate and a one year term to maturity. 6. 06/29/2020: Collected $790,000 cash from accounts receivable. 7. 07/12/2020: Paid $695,000 cash on accounts payable. 8. 08/25/2020: Paid $162,000 cash for selling and administrative expenses. 9. 09/26/2020: Collected cash due from the credit card company (see item 4). 10. 10/19/2020: Wrote off 9.200 of accounts as uncollectible. 11. 12/31/2020: Made the following adjusting entries: a Recorded uncollectible accounts expense estimated at 1 percent of sales on account. b. Recorded accrued interest on the note at December 31, 2020 (see item 5) Required a. Prepare journal entries for these transactions on paper and be sure they are correct. b. Enter the journal entries for these transactions into your QBO Tile Etc. file. c. Use QBO to prepare the following reports. Save each as a PDF and submit as attachments through the assignment area in Canvas: 1. Prepare an income statement for Year 2020. 2. Prepare a balance sheet as of 12/31/2020. 3. Prepare a statement of cash flows for Year 2020.
Date Event General Journal Debit Credit 2/17/20 1 3/8/20 2a 2b 4/24/20 3a 3b 5/20/20 4a 4b 6/1/20 5 6/29/20 6 7/12/20 7 8/25/20 8
9/26/20 9 10/19/20 10 12/31/20 11a 12/31/20 11b
Journal Entry
Date | Event | General Journal | Debit | Credit |
2/17/20 | 1 | Merchandise Inventory | 665000 | |
Account Payable | 665000 | |||
(Inventory Purchased on Account) | ||||
3/08/20 | 2a | Account Receivable | 1060000 | |
Sales Revenue | 1060000 | |||
(Merchandise sold on Account) | ||||
2b | Cost of Good Sold | 505000 | ||
Merchandise Inventory | 505000 | |||
(Merchandise Sold costed 505000) | ||||
04/24/20 | 3a | Cash | 330000 | |
Sales Revenue | 330000 | |||
(Cash Sales recorded) | ||||
3b | Cost of Good Sold | 194000 | ||
Merchandise Inventory | 194000 | |||
(Merchandise Sold Costed 194000) | ||||
05/20/20 | 4a | Account Receivable | 266750 | |
Credit Card Expense | 8250 | |||
Sales Revenue | 275000 | |||
(Merchandise Sold and Payment received Through Credit Card) | ||||
4b | Cost of Good Sold | 130000 | ||
Merchandise Inventory | 130000 | |||
(Merchandise Sold Costed 130000) | ||||
06/01/20 | 5 | Note Receivable | 67000 | |
Cash | 67000 | |||
(Loan given to K Parks) | ||||
06/29/20 | 6 | Cash | 790000 | |
Account Receivable | 790000 | |||
(Cash received from Account Receivable) | ||||
07/12/20 | 7 | Account Payable | 695000 | |
Cash | 695000 | |||
(Cash paid to Account Payable) | ||||
08/25/20 | 8 | Selling & Administrative Expense | 162000 | |
Cash | 162000 | |||
(Selling & admin Expense paid) | ||||
09/26/20 | 9 | Cash | 266750 | |
Account Receivable | 266750 | |||
(Cash received from Credit card Company) | ||||
10/29/20 | 10 | Allowance for Doubtful Account | 9200 | |
Account Receivable | 9200 | |||
(Account for Dobutful wrriten off) | ||||
12/31/20 | 11a | Bad Debt Expense | 10600 | |
Allowance for Doubtfuk Account | 10600 | |||
(Adjustment Entry made for uncollectable account) | ||||
11b | Accured Interest | 2345 | ||
Interest Revenue | 2345 | |||
(Adjustment Entry made for Accured Interest) |
Workings
Credit Card Expense-275000*3%=8250
Bad Debt Expense-1060000*1%=10600
Accured Interest-67000*6%*7/12=2345