In: Accounting
Friend's Tire Shop (V17.0) | |||
Worksheet Page 1 (D4) | |||
For the Month Ended December 31, 20XX | |||
Account Titles | Trial Balance | ||
Dr. | Cr. | ||
1 | Cash | 5,318.96 | |
2 | Accounts Receivable | 8,182.30 | |
3 | Merchandise Inventory | 36,615.60 | |
4 | Prepaid Insurance | 5,423.95 | |
5 | Office Supplies | 423.20 | |
6 | Shop Supplies | 2,361.75 | |
7 | Delivery Van | 17,250.00 | |
8 | Accum. Depr. - Delivery Van | 16,962.50 | |
9 | Shop Equipment | 27,699.81 | |
10 | Accum. Depr. - Shop Equiq | 14,260.29 | |
11 | Notes Payable | 4,505.88 | |
12 | Accounts Payable | 15,357.30 | |
13 | Salaries and Wages Payable | ||
14 | Interest Payable | 627.42 | |
15 | Notes Payable - Long Term | 6,573.30 | |
16 | Robert Friend, Capital | 45,439.03 | |
17 | Robert Friend, Drawing | 7,900.00 | |
18 | |||
19 | |||
20 | |||
21 | |||
22 | |||
23 | |||
24 | |||
25 | Totals | 111,175.57 | 103,725.72 |
Friend's Tire Shop (V17.0) | |||
Worksheet Page 2 (D5) | |||
For the Month Ended December 31, 20XX | |||
Account Titles | Trial Balance | ||
Dr. | Cr. | ||
Total Forward | 111,175.57 | 103,725.72 | |
1 | Sales | 37,187.17 | |
2 | Sales Returns and Allow. | 778.20 | |
3 | Sales Discounts | 539.46 | |
4 | Repair Service Revenue | 3,613.43 | |
5 | Cost of Goods Sold | 18,229.78 | |
6 | Advertising Expense | 661.88 | |
7 | Bank Charges | 25.00 | |
8 | Depr. Expense - Del. Van | ||
9 | Depr. Expense - Shop Eq | ||
10 | Insurance Expense | ||
11 | Office Salaries Expense | 3,025.00 | |
12 | Office Supplies Expense | ||
13 | Rent Expense | 1,200.00 | |
14 | Repair & Maint. Delivery Van | 488.27 | |
15 | Shop Salaries Expense | 7,450.00 | |
16 | Shop Supplies Expense | ||
17 | Utilities Expense | 949.93 | |
18 | Telephone Expense | 68.23 | |
19 | Accounting/Legal Expense | 225.00 | |
20 | Rental Revenue | 290.00 | |
21 | Interest Expense | ||
22 | Total | 144,816.32 | 144,816.32 |
23 | Net Income or Loss | ||
24 | Total |
Adjusting entries:
A | Depr. Exp - Company Van | $287.50 | ||
Accum. Depreciation - Company Van | $287.50 | |||
B | Depr. Exp - Shop Equipment | $425.00 | ||
Accum. Depreciation - Shop Equipment | $425.00 | |||
C | Insurance Expense | $495.63 | ||
Prepaid Insurance | $495.63 | |||
D | Office Supplies Expense | $208.20 | ||
Office Supplies | $208.20 | |||
E | Shop Supplies Expense | $361.75 | ||
Shop Supplies | $361.75 | |||
F | Office Salaries Expense | $150.00 | ||
Shop Salaries Expense | $350.00 | |||
Salaries and Wages Payable | $500.00 | |||
G | Interest Expense | $104.36 | ||
Interest Payable | $104.36 | |||
H | Cost of Goods Sold | $283.38 | ||
Merchandise Inventory | $283.38 |
I need help doing closing entries for the above accounts
Closing entries:
Date | Account Titles and Explanation | Debit | Credit |
Dec. 31, 20XX | Sales | 37187.17 | |
Repair service revenue | 3613.43 | ||
Rental revenue | 290.00 | ||
Income Summary | 41090.60 | ||
(To close revenue accounts) | |||
Dec. 31, 20XX | Income Summary | 36306.57 | |
Sales return & allowances | 778.20 | ||
Sales discount | 539.46 | ||
Cost of goods sold ($18229.78 + $283.38) | 18513.16 | ||
Advertising expense | 661.88 | ||
Bank charges | 25.00 | ||
Depr. Expense - Del. Van | 287.50 | ||
Depr. Expense - Shop Eq | 425.00 | ||
Insurance expense | 495.63 | ||
Office salaries expense ($3025 + $150) | 3175.00 | ||
Office supplies expense | 208.20 | ||
Rent expense | 1200.00 | ||
Repair & Maint. Delivery van | 488.27 | ||
Shop salaries expense ($7450 + $350) | 7800.00 | ||
Shop supplies expense | 361.75 | ||
Utilities expense | 949.93 | ||
Telephone expense | 68.23 | ||
Accounting/legal expense | 225.00 | ||
Interest expense | 104.36 | ||
(To close contra-revenue and expense accounts) | |||
Dec. 31, 20XX | Income Summary ($41090.60 - $36306.57) | 4784.03 | |
Robert Friend, Capital | 4784.03 | ||
(To close Income Summary to capital) | |||
Dec. 31, 20XX | Robert Friend, Capital | 7900.00 | |
Robert Friend, Drawing | 7900.00 | ||
(To close drawings to capital) |