What it is
This workbook links the four primary statements, so net income flows into the equity statement and the cash flow statement, and the closing cash and equity are checked against the balance sheet. You enter the two year-end balance sheets, the income statement, and a few inputs the statements cannot supply, such as capital expenditures and dividends.
Working capital, debt and investment changes in the cash flow statement (indirect method) are computed from the two balance sheet columns. A Checks tab lists every tie-out. When a tie-out fails, the difference points to a missing item such as a noncash transaction, a disposal or an unrecorded equity entry.
When to use it
- Building a full set of statements from a trial balance for a private company.
- Preparing statements for a compilation or review and checking that they agree internally.
- Teaching how the statements fit together.
What’s inside
- Instructions tab with the order of entry and sign conventions
- Classified balance sheet with two year-ends and a balance check
- Income statement with net income feeding the equity and cash flow statements
- Equity rollforward by component, agreed to the balance sheet
- Indirect cash flow statement with computed changes, and a Checks tab
Standard cited
This template follows ASC 205 / ASC 210 / ASC 220 / ASC 230 / ASC 505. 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 does my cash flow statement not agree to the balance sheet?
The difference shows an item the shell does not capture. Common causes are a disposal with a gain or loss, a noncash acquisition, goodwill, an equity entry not on the equity tab, or a balance sheet change not matched to a cash flow line. Work down the lines until the difference is explained.
Does it include notes and comparatives for the income statement?
No. The income statement is the current year only, and the notes are a separate template. Add comparative columns if your framework needs them.
Is this a US GAAP disclosure-complete set?
No. It builds the primary statements and the tie-outs. Disclosures, segment data, earnings per share and other requirements need a disclosure checklist.
Related templates
- Cash Flow Statement Template, Indirect Method (ASC 230)
- Trial Balance Template with Mapping (Excel)
- Lead Schedule Template (Excel)
Last updated 11/05/2026. All free templates.