Question: Lab Insight: Apply the same steps as Lab 1-1 to the Alt Lab 1-1 Data.xlsx dataset, with a completed formatted trial balance. Open Excel file

Lab Insight: Apply the same steps as Lab 1-1 to the Alt Lab 1-1 Data.xlsx dataset, with a completed formatted trial balance. Open Excel file Alt Lab 1-1 Data.xlsx. The only exception is you need to order the final trial balance in this way: Reorder the accounts in balance sheet (Cash, Accounts Receivable, Allowance for Doubtful Accounts, Prepaid Insurance, Computer Supplies, Supplies, Equipment, Building, Accumulated Depreciation, Notes Payable, Common Stock) and then the accounts in income statement order (Sales Revenue, Salaries Expense, Travel Expense, Rent Expense, Repairs Expense, Depreciation Expense, Insurance Expense, Misc. Expense, Payroll Tax Expense, Supplies Expense, Training Expense, Utilities Expense and Bad Debt Expense, Postage Expense). To reorder the accounts, you can highlight the whole row, right click and select Cut, move to the row where you would like to insert it, and then select Insert Cut Cells to get the row in the appropriate location.Date JE# Account Name Debit Credit Entered Approved 1/2/2025 1 Cash 50,000 VR AC 1/2/2025 1 Common Stock 50,000 VR AC 1/2/2025 2 Travel Expense 150 VR AC 1/2/2025 2 Cash 150 VR AC 1/2/2025 3 Building 30,000 VR AC 1/2/2025 3 Cash 30,000 VR AC 1/4/2025 4 Utilities Expense 1,500 MW AC 1/4/2025 4 Cash 1,500 MW AC 1/5/2025 5 Equipment 17,200 VR AC 1/5/2025 5 Notes Payable 17,200 VR AC 1/6/2025 6 Salaries Expense 1,300 VR AC 1/6/2025 6 Cash 1,300 VR AC

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!