Question

Hello, I need help making an accounting "worksheet" with these entries. If you'd like to update the journal entries it's fine. But, please help me on finishing the worksheet? Thank you.
ACC 111 Project 1B The adjustment data as of September 30, 2016, the end of the fiscal year, for Diaz Company were as follows: a. Merchandise Inventory taken on September 30 was $65,800. b. The depreciation on the Delivery Truck for the month amounted to $700. C. The depreciation on the Forklift for the month amounted to $850. d. A physical count shows that Office Supplies used totaled $1,300. e. Insurance on hand at the end of September was $1,500. f. Accrued salaries on September 30 amounted to $1,940. g. Unearned Sales Revenue earned at the end of September was $12,600. h. Accrued interest on notes receivable, $360. i. Accrued interest on notes payable, $165. j. Unexpired office rent amounted to $6,270.

Answer 1

	Opening Balances		Unadjustments		Adjusted Trial balance		Profit and loss		Balance Sheet
Openining Balance of Accounts	Debit	Credit	Debit	Credit	Debit	Credit	Debit	Credit	Debit	Credit
Cash A/c	8600				8600				8600
Notes Receivable	160000				160000				160000
Accounts Receivable	16200				16200				16200
Interest Receivable	3000				3000				3000
Merchandise Inventory Opening	55800				55800		55800
Prepaid insurance	3800			2300	1500				1500
Prepaid office rent	17400			11130	6270				6270
Office Supplies	3000			1300	1700				1700
Land	90000				90000				90000
Forklift	27500				27500				27500
Accumulated Depreciation, Forklift		2400		850		3250				3250
Delivery Truck	40000				40000				40000
Accumulated Depreciation, Delivery truck		5000		700		5700				5700
Accounts Payable		13000				13000				13000
Salaries Payable		1400				1400				1400
Unearned Sales Revenue		23000	10400			12600				12600
Notes Payable (Due 2040)		132500				132500				132500
C Diaz Capital		164400				164400				164400
C Diaz Drawings	9750				9750				9750
Sales Revenue		172300		10400		182700		182700
Sales Revenue & Allowances	2250				2250		2250
Sales Discounts	1700				1700		1700
Purchases	48500				48500		48500
Purchase returns and allowances		4200				4200		4200
Purchases Discounts		1500				1500		1500
Frieght-in	5900				5900		5900
Salaries expense	19200		1940		21140		21140
Office rent expense	6600		11130		17730		17730
Utilities expense	4800				4800		4800
Interest expense	3500		165		3665		3665
Interest Revenue		7800		360		8160		8160
Insurance Expense					2300		2300
Office Supplies expense	0		1300		1300		1300
Depreciation Expense (Truck+ Forklifit)	0		1550		1550		1550
Accrued salaries				1940		1940				1940
Merchandise Inventory Closing	0		0		0			65800	65800
Accrued Interest receivable A/c			360		360				360
Accrued Interest payable A/c				165		165				165
Total	527500	527500	26845	29145	531515	531515	166635	262360	430680	334955
							Profit	95725		95725
								Total	430680	430680