Prepare a ten-column worksheet after making the indicated adjustments in the following Trial Balance:Adjustments:

1. The physical inventory shows $90,500. 2. The supplies expenses for the year are $10,200 3. The expired insurance is $1,140 4. Provide depreciation to delivery equipment, store equipment, and office equipment at 10% under the straight line method.

fill out this form

10 Column Worksheet
		Trial Balance		Adjustments		Adjusted Trial Balance		Income Statement		Balance Sheet
Acc. No.	Account Name	Debit	Credit	Debit	Credit	Debit	Credit	Debit	Credit	Debit	Credit
101	Cash in Bank
115	Accounts Receivable
125	Merchandise Inventory
130	Supplies
135	Prepaid Insurance
140	Delivery Equipment
142	Accumulated Depreciation - Delivery Equipment
145	Office Equipment
147	Accumulated Depreciation - Office Equipment
150	Store Equipment
152	Accumulated Depreciation - Store Equipment
201	Accounts Payable
204	Federal Corporation IT Payable
205	Employee Federal IT Payable
211	Employee State Income Tax Payable
212	Social Security Tax Payable
213	Medicare Tax Payable
214	Federal Unemployment Tax Payable
215	Stae Unemployment Tax Payable
216	Hospital Insurance Payable
220	Sales Tax Payable
301	Capital Stock
305	Retained Earnings
310	Income Summary
401	Sales
405	Sales Discounts
410	Sales Return and Allowance
501	Purchases
505	Transportation, Inc.
510	Purchases Discount
515	Purchases Return and Allowance
601	Advertising Expense
605	Bank Card Fee Expenses
607	Depreciation Expense - Delivery Equipment
609	Depreciation Expense - Office Equipment
610	Depreciation Expense - Stores Equipment
630	Federal Corporation IT Expense
635	Insurance Expense
650	Maintenance Expense
655	Miscellaneous Expense
657	Payroll Tax Expense
660	Rent Expense
665	Salaries Expense
670	Supplies Expense
680	Utilities Expense