An end-of-period spreadsheet, such as a worksheet, includes columns for which of the following?

• A. Only the adjusted trial balance and income statement
• B. Adjustments and statement of retained earnings only
• C. Unadjusted trial balance and cash flow statement only
• D. Unadjusted trial balance, adjustments, adjusted trial balance, income statement, and balance sheet

Answer: (D)

Verified step by step guidance

1. Understand the purpose of an end-of-period spreadsheet: It is used to organize and summarize financial data for the preparation of financial statements.
2. Identify the key components of the spreadsheet: These typically include the unadjusted trial balance, adjustments, adjusted trial balance, income statement, and balance sheet.
3. Explain the role of the unadjusted trial balance: This column lists all account balances before any adjustments are made.
4. Describe the adjustments column: This column records any necessary changes to account balances, such as accruals or deferrals, to ensure compliance with the accrual basis of accounting.
5. Clarify the adjusted trial balance, income statement, and balance sheet columns: The adjusted trial balance reflects updated account balances after adjustments, while the income statement and balance sheet columns are used to prepare the respective financial statements.