The steps performed in completing an end of period spreadsheet work sheet
The steps performed in completing an end-of-period spreadsheet (work sheet) are listed below in random order. Indicate the correct order in which these steps are performed when preparing and completing a spreadsheet (work sheet).
a. Add the Debit and Credit columns of the Unadjusted Trial Balance columns of the spreadsheet (work sheet) to verify that the totals are equal.
b. Add the Debit and Credit columns of the Balance Sheet and Income Statement columns of the spreadsheet (work sheet) to verify that the totals are equal.
c. Add or deduct adjusting entry data to trial balance amounts and extend amounts to the Adjusted Trial Balance columns.
d. Add the Debit and Credit columns of the Adjustments columns of the spreadsheet (work sheet) to verify that the totals are equal.
e. Add the Debit and Credit columns of the Balance Sheet and Income Statement columns of the spreadsheet (work sheet) to determine the amount of net income or net loss for the period.
f. Add the Debit and Credit columns of the Adjusted Trial Balance columns of the spreadsheet (work sheet) to verify that the totals are equal.
g. Enter the adjusting entries into the spreadsheet (work sheet), based on the adjust ment data.
h. Enter the amount of net income or net loss for the period in the proper Income Statement column and Balance Sheet column.
i. Enter the unadjusted account balances from the general ledger into the Unadjusted Trial Balance columns of the spreadsheet (work sheet).
j. Extend the adjusted trial balance amounts to the Income Statement columns and the Balance Sheet columns.
Membership TRY NOW
  • Access to 800,000+ Textbook Solutions
  • Ask any question from 24/7 available
    Tutors
  • Live Video Consultation with Tutors
  • 50,000+ Answers by Tutors
OR
Relevant Tutors available to help