What it is
Building statements from a trial balance starts with a map from each ledger account to a statement line. This workbook holds the map once, so next year’s trial balance flows through the same lines. It then builds a balance sheet and an income statement and checks them.
Paste debits and credits on the TB tab. The statement line appears beside each account, or Unmapped when the account is missing. The Statements tab applies the normal sign for each line, carries net income into equity and runs four checks: trial balance in balance, no unmapped accounts, mapped total equals the trial balance, and assets equal liabilities plus equity.
When to use it
- At year end, when preparing financial statements from the general ledger.
- For recurring compilation, review and audit engagements that reuse the same account map.
- When a client changes its chart of accounts and the statements need remapping.
What’s inside
- Fixed list of 22 balance sheet and income statement lines
- Map for 100 accounts with a drop-down of statement lines
- Trial balance import for 100 accounts with the mapped line
- Balance sheet, income statement and retained earnings roll
- Four checks with OK or Check cells
Standard cited
This template follows US GAAP financial statement preparation. It is written in our own words, except for phrases the standard requires the document to contain, with [bracketed placeholders] for client details, amounts in USD and dates as MM/DD/YYYY. Check it against the current standard and your firm’s methodology before use.
Questions
Why must account numbers match exactly?
The lookup matches text. An account 1010 and 01010 are different. Enter account numbers as text in both the Map and the TB tab.
How does the statement treat sign?
Assets and expenses show debits as positive. Liabilities, equity and revenue show credits as positive. Contra accounts net into the line they are mapped to.
Where does opening retained earnings come from?
From accounts mapped to Retained earnings (opening). Map the pre-closing equity accounts there. Current-year net income comes from the income statement and joins equity on the balance sheet.
Can I add statement lines?
The line list is fixed so the statements and checks stay intact. Adapt captions and splits, such as current and noncurrent debt, in the issued statements.
Related templates
- Trial Balance Template with Mapping (Excel)
- Lead Schedule Template (Excel)
- Financial Statement Shell: Balance Sheet, Income, Equity and Cash Flows
- Classified Balance Sheet Template (US GAAP)
Last updated 11/05/2026. All free templates.