Appendix 1Completing an end-of-period spreadsheet List (A) through (J) in the order they would be performed in preparingand completing an end-of-period spreadsheet. A. Add the Debit and Credit columns of the Unadjusted Trial Balancecolumns of the spreadsheet to verify that the totals are equal. B. Add the Debit and Credit columns of the Balance Sheet and IncomeStatement columns of the spreadsheet to verify that the totals are equal.C. Add or deduct adjusting entry data to trial balance amounts, andextend amounts to the Adjusted Trial Balance columns. D. Add the Debit and Credit columns of the Adjustments columns of thespreadsheet 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 to determine the amount of netincome or net loss for the period.F. Add the Debit and Credit columns of the Adjusted Trial Balancecolumns of the spreadsheet to verify that the totals are equal. G. Enter the adjusting entries into the spreadsheet, based on theadjustment data H. Enter the amount of net income or net loss for the period in theproper Income Statement column and Balance Sheet column.I. Enter the unadjusted account balances from the general ledger intohe Unadjusted Trial Balance columns of the spreadsheet. J. Extend the adjusted trial balance amounts to the Income Statement columns and the Balance Sheet columns.

Century 21 Accounting General Journal
11th Edition
ISBN:9781337680059
Author:Gilbertson
Publisher:Gilbertson
Chapter6: Work Sheet And Adjusting Entries For A Service Business
Section: Chapter Questions
Problem 3AP
icon
Related questions
icon
Concept explainers
Question

Appendix 1
Completing an end-of-period spreadsheet

List (A) through (J) in the order they would be performed in preparing
and completing an end-of-period spreadsheet.

A. Add the Debit and Credit columns of the Unadjusted Trial Balance
columns of the spreadsheet 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 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 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 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 to verify that the totals are equal.

G. Enter the adjusting entries into the spreadsheet, based on the
adjustment 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
he Unadjusted Trial Balance columns of the spreadsheet.

J. Extend the adjusted trial balance amounts to the Income Statement columns and the Balance Sheet columns.

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Completing the Accounting Cycle
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Century 21 Accounting General Journal
Century 21 Accounting General Journal
Accounting
ISBN:
9781337680059
Author:
Gilbertson
Publisher:
Cengage
Century 21 Accounting Multicolumn Journal
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:
9781337679503
Author:
Gilbertson
Publisher:
Cengage
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Financial Accounting: The Impact on Decision Make…
Financial Accounting: The Impact on Decision Make…
Accounting
ISBN:
9781305654174
Author:
Gary A. Porter, Curtis L. Norton
Publisher:
Cengage Learning