Question

The trial balance columns of the worksheet for Crane Company at June 30, 2020, are as follows

Crane Company Worksheet For the Month Ended June 30, 2020
		Trial Balance
Account Titles		Dr.		Cr.
Cash		2,500
Accounts Receivable		2,200
Supplies		1,900
Accounts Payable				1,000
Unearned Service Revenue				380
Owner’s Capital				2,710
Service Revenue				3,100
Salaries and Wages Expense		490
Miscellaneous Expense		100
Total		7,190		7,190

Other data:

1.		A physical count reveals $600 of supplies on hand.
2.		$170 of the unearned revenue is still unearned at month-end.
3.		Accrued salaries are $130.

please help me do an accurate worksheet.

I partiallyy did mine. but isn't adding up but it won't allow me to add because it says its too long.

Answer 1

Crane Company
Worksheet
June 30, 2020
Particulars	Trial balance		Adjustments				Adjusted trial balance		Income Statement		Balance Sheet
	Debit	Credit		Debit		Credit	Debit	Credit	Debit	Credit	Debit	Credit
Cash	$ 2,500						$ 2,500				$ 2,500
Accounts receivable	$ 2,200						$ 2,200				$ 2,200
Supplies	$ 1,900					$ 1,300	$     600				$      600
Accounts Payable		$ 1,000						$ 1,000				$ 1,000
Unearned service revenue		$     380		$     210				$     170				$      170
Owner’s Capital		$ 2,710						$ 2,710				$ 2,710
Service revenue		$ 3,100				$     210		$ 3,310		$ 3,310
Salaries and wages expense	$     490			$     130			$     620		$      620
Misc. expenses	$     100						$     100		$      100
Supplies expense				$ 1,300			$ 1,300		$ 1,300
Salaries and wages payable						$     130		$     130				$      130
Totals	$ 7,190	$ 7,190		$ 1,640	$ -	$ 1,640	$ 7,320	$ 7,320	$ 2,020	$ 3,310	$ 5,300	$ 4,010
Net income									$   1,290			$   1,290
Totals									$   3,310	$   3,310	$   5,300	$   5,300

You can reach me over comment box, if you have any doubts. Please rate this answer