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.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
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
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education