A cash flow statement from a trial balance starts with two year-end trial balances side by side. Subtract one from the other to get each account's change, tag every change as operating, investing, financing or cash, and start from net income. When the three sections add up to the change in the cash accounts, the statement is proved.
The example is a fictional S corporation, Marigold Print Works Inc., moving from December 31, 2025 to December 31, 2026. The company, its accounts and every figure are examples. The arithmetic is exact: both trial balances net to zero, and the finished statement explains the $17,800 increase in cash to the dollar.
What a cash flow statement from a trial balance needs before you start
A cash flow statement from a trial balance needs four inputs: the prior year-end trial balance, the current year-end trial balance, the current year's net income, and a few lines of ledger detail for fixed assets, loans and owner distributions. The two trial balances give the changes. The detail splits the changes that are really two movements netted together.
Both trial balances must be final. A prior-year trial balance pulled before the year-end adjustments were posted will not agree with last year's statements, and every change built on it will be off by those adjustments. Use the trial balance that matches the balance sheet the firm issued or the return it filed. If the client's books and last year's final figures disagree, resolve that first; the post on why retained earnings does not match the prior year traces the usual causes.
Net income comes from the current-year revenue and expense accounts. If the current trial balance was pulled before closing, those accounts still carry balances and their total is net income. The post on where current-year net income goes on an Excel balance sheet explains how that total sits in equity before the books are closed.
The ledger detail is short. For Marigold it is four facts, each read from the general ledger:
- Equipment bought during 2026: $50,000, paid in cash.
- Equipment sold: a press that cost $15,000, with $12,000 of accumulated depreciation, sold for $5,000 in cash.
- Term loan: $40,000 of new borrowing and $25,000 of principal repaid.
- Distributions to shareholders: $30,000.
Depreciation expense of $22,000 comes from the income statement accounts. Depreciation is usually booked as a year-end adjusting entry, and the post on which adjusting journal entries come up every year end covers checking that it was posted before the trial balance was pulled.
Classifying trial balance accounts as operating, investing or financing cash flow
Classifying trial balance accounts for a cash flow statement means giving each balance sheet account one of four tags. Cash accounts are the cash itself. Receivables, inventory, prepaids, payables and accruals are operating. Fixed assets and their accumulated depreciation are investing. Loans, owner contributions and distributions are financing. Net income gets its own tag.
Here is Marigold's worksheet. Balances are signed, debits positive and credits negative. Column D is =C2-B2, the current balance less the prior one.
| A: Account | B: Dec 31, 2025 | C: Dec 31, 2026 | D: Change | E: Class |
|---|---|---|---|---|
| Cash, operating XXXX-4821 | 30,000 | 47,800 | 17,800 | Cash |
| Accounts receivable | 52,000 | 61,000 | 9,000 | Operating |
| Inventory | 40,000 | 36,000 | -4,000 | Operating |
| Prepaid expenses | 5,000 | 6,000 | 1,000 | Operating |
| Equipment | 180,000 | 215,000 | 35,000 | Investing |
| Accumulated depreciation | -90,000 | -100,000 | -10,000 | Investing |
| Accounts payable | -28,000 | -31,000 | -3,000 | Operating |
| Accrued liabilities | -7,000 | -9,500 | -2,500 | Operating |
| Term loan | -80,000 | -95,000 | -15,000 | Financing |
| Common stock | -20,000 | -20,000 | 0 | Financing |
| Retained earnings, beginning | -82,000 | -82,000 | 0 | Financing |
| Distributions | 0 | 30,000 | 30,000 | Financing |
| Revenue and expense accounts, net | 0 | -58,300 | -58,300 | Net income |
| Total | 0 | 0 | 0 |
The prior column is a closed trial balance, so its revenue and expense accounts are zero and retained earnings already includes 2025. The current column was pulled before closing, so the revenue and expense accounts appear as one net row of -58,300: net income of $58,300 as a credit. Beginning retained earnings is the same in both columns, which is what a correct rollover looks like.
The classification uses the same mapping tab idea as the balance sheet. The post on building a reusable trial balance mapping table sets up the account-to-line table; for cash flow, add one more column with these five tags. Once it exists, it carries forward to next year with the rest of the trial balance mapping.
How do you get operating cash flow from trial balance changes?
Operating cash flow from trial balance changes uses the indirect method: start with net income, add back expenses that used no cash such as depreciation, take out gains that brought in no operating cash, then adjust for each change in working capital accounts. An asset that grew used cash; a liability that grew kept cash in the business.
The sign rule follows from the signed change column. For any account other than cash, the cash effect is the change multiplied by -1. Receivables rose by 9,000, a positive change, so the cash effect is -9,000: the company booked sales it has not yet collected. Payables moved by -3,000, a larger credit, so the cash effect is +3,000: the company bought on credit and has not yet paid.
Marigold's operating section:
| Line | Amount |
|---|---|
| Net income | 58,300 |
| Depreciation | 22,000 |
| Gain on sale of equipment | (2,000) |
| Increase in accounts receivable | (9,000) |
| Decrease in inventory | 4,000 |
| Increase in prepaid expenses | (1,000) |
| Increase in accounts payable | 3,000 |
| Increase in accrued liabilities | 2,500 |
| Net cash from operating activities | 77,800 |
The working capital lines can come straight from the worksheet with one formula:
=-SUMIFS($D:$D, $E:$E, "Operating")
For Marigold it returns -500: the five working capital lines above net to -9,000 + 4,000 - 1,000 + 3,000 + 2,500 = -500. If the formula and the sum of the printed lines disagree, an operating account is tagged wrong or left off the statement. Microsoft's SUMIFS function reference explains the sum range and criteria arguments. Show each account on its own line on the statement, but keep the one-cell total as a check.
Depreciation is added back because it reduced net income without any cash leaving. The gain is subtracted because the $5,000 the press sold for is cash from investing, not operations, and the $2,000 gain inside net income would otherwise count part of it twice.
Fixed asset and loan activity hidden in net trial balance changes
Fixed asset and loan activity is hidden in net trial balance changes because the change column shows one number per account for the whole year. Equipment rising by $35,000 could be one purchase of $35,000, or purchases of $50,000 less a disposal of $15,000. A loan balance can hide borrowing and repayments the same way. The ledger detail separates them.
For Marigold, the equipment account moved by +35,000 and accumulated depreciation by -10,000. The ledger detail explains both:
| Account | Movement | Amount |
|---|---|---|
| Equipment | Purchases | 50,000 |
| Equipment | Cost of press sold | (15,000) |
| Equipment | Net change | 35,000 |
| Accumulated depreciation | 2026 depreciation | (22,000) |
| Accumulated depreciation | Removed on press sold | 12,000 |
| Accumulated depreciation | Net change | (10,000) |
The investing section shows the gross cash movements, not the net change: purchases of equipment (50,000) and proceeds from the sale of equipment 5,000, for net cash used in investing of (45,000). As a cross-check, the investing-tagged changes on the worksheet total 35,000 - 10,000 = 25,000, a cash effect of -25,000. That equals investing cash of -45,000 plus the depreciation add-back of 22,000 less the 2,000 gain. When that cross-check fails, a fixed asset movement is missing from the detail.
The loan works the same way. The term loan's change of -15,000 is a cash effect of +15,000, and the ledger shows it as $40,000 borrowed less $25,000 repaid. The financing section shows both lines:
| Line | Amount |
|---|---|
| Proceeds from term loan | 40,000 |
| Repayments of term loan | (25,000) |
| Distributions to shareholders | (30,000) |
| Net cash used in financing activities | (15,000) |
Showing gross amounts matters to a reader. A business that borrowed $40,000 and repaid $25,000 tells a different story from one that borrowed a net $15,000, even though the year-end balance is the same. The loan statements give both figures when the ledger is unclear; the post on what fields a loan statement carries into Excel lists where principal paid appears.
Does the cash flow statement prove to the change in cash on the trial balance?
The cash flow statement proves when operating, investing and financing cash flows add up to the change in the cash accounts between the two trial balances. A proof cell compares the two. A difference of zero means every balance sheet change was explained once. Any other figure means a change was missed, counted twice or tagged to the wrong section.
Marigold's summary:
| Line | Amount |
|---|---|
| Net cash from operating activities | 77,800 |
| Net cash used in investing activities | (45,000) |
| Net cash used in financing activities | (15,000) |
| Net increase in cash | 17,800 |
| Cash, December 31, 2025 | 30,000 |
| Cash, December 31, 2026 | 47,800 |
The proof cell reads the cash-tagged change straight from the worksheet:
=IF(ROUND(C40-SUMIFS(D:D, E:E, "Cash"), 2)=0, "Ties to cash", "Off by " & ROUND(C40-SUMIFS(D:D, E:E, "Cash"), 2))
Here C40 holds the net increase in cash from the statement. Microsoft's ROUND and IF pages cover the two functions. For Marigold, 17,800 less 17,800 is zero, and the cell reads "Ties to cash".
The size of a difference is a clue. A difference equal to a single account's change usually means that account has no tag, or a tag the statement does not read. A difference equal to twice a figure usually means it was entered once from the worksheet and once from the ledger detail. A difference near the depreciation figure often means the investing section was taken from the worksheet's net fixed asset changes, which already contain depreciation, instead of from the ledger's purchases and proceeds.
Check the equity side at the same time. Beginning retained earnings of 82,000, plus net income of 58,300, less distributions of 30,000, gives ending retained earnings of 110,300. If that rollforward does not hold, the cash flow statement can still prove while the balance sheet is wrong; the post on rolling retained earnings forward from the prior year works through it.
Cash flow statement edge cases: noncash financing, owner distributions and gains on sale
Cash flow statement edge cases are transactions that change balance sheet accounts without moving cash, or that move cash in a section other than the one the account suggests. Equipment bought directly with a loan, owner distributions and gains on sold assets are the three that come up most in small company work.
Equipment bought with a loan
When a lender pays an equipment dealer directly, the company's equipment and loan accounts both rise, and no cash passes through its bank account. Suppose Marigold had also bought a $25,000 folder that way. The equipment change would be 25,000 larger and the loan change 25,000 larger, and both would cancel on the worksheet. Leave the folder out of both investing and financing, because no cash moved, and describe it in a note below the statement. Putting it in both sections would not change the proof cell, but it would overstate purchases and borrowing alike.
Owner distributions
Distributions to shareholders, and draws in a partnership or sole proprietorship, are financing outflows. They are cash paid to owners, not an operating cost. A common error is a client posting owner withdrawals to an expense account. That lowers net income, puts the cash in the operating section, and leaves financing too small. Reclassify the amount on the worksheet, not by guessing on the statement.
Gains and losses on sale
A gain on sale is subtracted from net income in the operating section and the full sale proceeds appear in investing. A loss is added back in operating, for the same reason in reverse. Marigold's press shows the pattern: a $3,000 book value ($15,000 cost less $12,000 depreciation), $5,000 of proceeds, and a $2,000 gain. Proceeds of 5,000 equal book value of 3,000 plus the gain of 2,000.
Lenders often want a cash flow statement alongside the owner's own figures. The post on preparing a personal financial statement in Excel covers the personal side of the same loan file.
Building these worksheets starts with getting two years of trial balances and the ledger detail out of whatever the client sends. Schema CPA reads trial balances, general ledgers and loan statements from a client's uploads and exports the figures to Excel or CSV; it does not prepare the cash flow statement itself. The workflow overview on the homepage shows the steps from upload to export.