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.

Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
ChapterMB: Model-building Problems
Section: Chapter Questions
Problem 1M: The general ledger of Jay Consulting shows the following balances at July 31: Jay has asked you to...
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
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Quickbooks Online Accounting
Quickbooks Online Accounting
Accounting
ISBN:
9780357391693
Author:
Owen
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
College Accounting, Chapters 1-27
College Accounting, Chapters 1-27
Accounting
ISBN:
9781337794756
Author:
HEINTZ, James A.
Publisher:
Cengage Learning,