Question

Complete a worksheet from a trial balance and adjustment data. Enter the adjustments in the adjustments columns of the worksheet. Key adjusting entries by letter. Total the debit and credit columns. Then calculate the adjusted​balances, enter them in the adjusted trial balance columns on the​ worksheet, and​ again, total the debit and credit columns.

J. Trent
Worksheet
Month Ended July 31, 201X
		Trial Balance		Adjustments
	Account Titles	Debit	Credit		Debit		Credit
	Cash	32
	Accounts Receivable	7
	Prepaid Insurance	4
	Store Supplies	6
	Store Equipment	14
	Accumulated Depreciation, Store Equipment		8			a.
	Accounts payable		9
	J. Trent, Capital		17
	J. Trent, Withdrawals	7
	Revenue from Clients		45
	Rent Expense	7
	Wage Expense	2
	Totals	79	79
	Depreciation Expense, Store Equipment			a.	1
	Insurance Expense			b.	3
	Store Supplies Expense			c.
	Wages Payable					d.	3
	Totals

a.	Depreciation​ expense, store​ equipment, $ 1
b.	Insurance​ expired, $ 3
c.	Store supplies on​ hand, $ 1
d.	Wages​ owed, but not paid for​ (they are an expense in the old​ year), $ 3

Answer 1

J. Trent
Worksheet
Month Ended July 31, 201X
	Trial Balance		Adjustments		Adjusted Trial Balance
Account Titles	Debit	Credit	Debit	Credit	Debit	Credit
Cash	$    32.00				$    32.00
Accounts Receivable	$       7.00				$       7.00
Prepaid Insurance	$       4.00			$       3.00	$       1.00
Store Supplies	$       6.00			$       5.00	$       1.00
Store Equipment	$    14.00				$    14.00
Accumulated Depreciation, Store Equipment		$       8.00		$       1.00		$       9.00
Accounts payable		$       9.00				$       9.00
J. Trent, Capital		$    17.00				$    17.00
J. Trent, Withdrawals	$       7.00				$       7.00
Revenue from Clients		$    45.00				$    45.00
Rent Expense	$       7.00				$       7.00
Wage Expense	$       2.00		$       3.00		$       5.00
Totals	$    79.00	$    79.00	$       3.00	$       9.00	$    74.00	$    80.00
Depreciation Expense, Store Equipment			$       1.00		$       1.00
Insurance Expense			$       3.00		$       3.00
Store Supplies Expense			$       5.00		$       5.00
Wages Payable				$       3.00		$       3.00
Total	$    79.00	$    79.00	$    12.00	$    12.00	$    83.00	$    83.00