Cash flow statement from trial balance: an account-level method

A cash flow statement from trial balance exports needs opening and closing adjusted balances, period net income and schedules that distinguish cash from noncash movements. One closing export cannot tell you which balances changed during the period or why.

The indirect method begins with net income, adjusts for noncash items and operating balance changes, then adds investing and financing cash flows. The SEC's financial statement guide describes that link between profit and operating cash.

Gather the balances and the supporting evidence

Export one row per account for the same entity, reporting currency and reporting basis at both dates. Keep account codes as text so leading zeros survive. Bring the account descriptions, debit or credit balances, cash flow mapping and the period's P&L.

Also bring fixed-asset additions and disposals, depreciation, debt movements and owner distributions. Add other schedules when the business has acquisitions, leases, foreign operations or restricted cash. An account movement does not by itself establish its cash component.

The trial balance definition explains the underlying debit-and-credit check. The cash flow statement template gives the summarized statement layout; the work here sits underneath it at account level.

Normalize signs before mapping movements

Use a consistent convention. In the worksheet below, debits are positive and credits are negative. For an export with opening debits in B, opening credits in C, closing debits in D and closing credits in E, calculate:

F2 = B2-C2
G2 = D2-E2
H2 = G2-F2

Match opening and closing rows by account code before filling down. Investigate a missing account rather than silently treating an unmatched row as zero. A genuinely new account can have a confirmed zero opening balance.

For a ten-account export in rows 2:11, both of these checks must equal zero:

=SUM(F2:F11)
=SUM(G2:G11)

These prove arithmetic balance, not correct accounting or cash classification.

Compare two complete trial balances

Consider an illustrative US distributor's August 31 and September 30, 2026, post-closing trial balances. It has no acquisitions, disposals, leases, foreign-currency balances or restricted cash. All figures are whole USD, with no rounding.

Opening debits and credits each total $1,050,000; closing debits and credits each total $1,200,000. Cash increased by $35,000, which is the final cash flow target.

The signed debt movement is negative because a credit balance increased. Expressing the liability in ordinary positive balance sheet amounts, debt rose from $300,000 to $360,000. Do not confuse the worksheet sign with a cash outflow.

Obtain net income without counting it twice

These trial balances are post-closing, so revenue and expense accounts have already closed into equity. The supplied P&L is:

The distribution schedule shows $15,000 of dividends declared and paid, with no other retained earnings entries. Retained earnings therefore reconcile as $220,000 + $50,000 - $15,000 = $255,000. The $35,000 retained earnings increase is not the period's net income.

This distinction is one reason a trial balance alone is insufficient. Obtain the actual period P&L and the equity movement support, rather than inferring profit from one closing equity caption.

Map operating adjustments

For the example's operating accounts, an increase in receivables consumes cash relative to recognized revenue. A decrease in inventory releases cash relative to cost of goods sold. Increases in operating payables and accruals preserve cash relative to the expenses recognized.

With debit-positive signed balances in F and G, the same formula works for these particular operating asset and liability adjustment rows:

=F2-G2

Apply it to the mapped receivable, inventory, payable and accrual rows, not to cash, debt, equity or every asset indiscriminately. It works here because the example has no noncash changes within those operating balances. Other cases require schedule-based adjustments before using the movement.

Split additions and debt into cash and noncash parts

The asset and debt schedules contain these transactions:

Debt checks as $300,000 + $80,000 - $50,000 + $30,000 = $360,000. Equipment checks as $500,000 + $70,000 + $30,000 = $600,000. Depreciation separately increases accumulated depreciation by $30,000.

Do not report the directly financed $30,000 as both cash borrowing and a cash equipment purchase. FASB's original cash flow standard, paragraph 32, explains the separate reporting of noncash investing and financing activity. Use the controller's approved current ASC 230 policy for formal reporting classifications.

Prove closing cash independently

If opening cash and the three flow totals occupy B2:B5, use =SUM(B2:B5) for expected closing cash. Subtract it from the trial balance cash total; the difference must be zero.

There is an independent operating check under the stated assumptions. Collections are $400,000 - $25,000 = $375,000; purchases are $250,000 - $10,000 = $240,000; supplier payments are $240,000 - $20,000 = $220,000; other expense payments are $70,000 - $5,000 = $65,000. Therefore $375,000 - $220,000 - $65,000 = $90,000 of operating cash.

Where it goes wrong

• Using one closing export. Opening balances or equivalent transaction history are essential.
• Equating debt growth with cash borrowing. Roll forward proceeds, repayments and noncash additions separately.
• Using net equipment movement as capital spending. Depreciation, disposals and financed additions can all change the balance.
• Accepting a closing cash tie as full proof. Offset errors can misstate operating and financing totals while leaving cash unchanged. Review each category's support.

Use the cash mismatch diagnostic if closing cash fails to tie. A group with several entities also needs the scope and elimination work discussed in the consolidated cash flow statement guide.

Work from your own trial balances in Covirage

Upload the two trial balances, period P&L and supporting movement schedules to Covirage. Covirage maps the columns, its tools compute and check the supplied movements, and the external AI model explains the result with every figure traced to its rows. Create a free Covirage account and bring a sample of your own exports.

See financial planning and reporting for the reporting context.