All templates

Cash Flow Statement Template

Classify historical cash movements and reconcile opening cash to closing cash.

Period and cash balances

Enter the signed exchange effect on cash held.

Direct cash movement schedules

Use label,amount,reference. Cash out is negative. Up to 100 rows.

Use label,amount,reference. Cash out is negative. Up to 100 rows.

Use label,amount,reference. Cash out is negative. Up to 100 rows.

Profit bridge and review notes

Signed adjustment, such as adding back depreciation.

Cash released is positive. Cash absorbed is negative.

Retain amounts and disclosure references here. Excluded from cash totals.

Cash reconciliation

Cash reconciles

The calculated closing cash equals the entered closing cash.

Historical cash only. Classification needs review. Entries stay on this device and clear when you leave.

Statement of cash flows

ItemAmount
Customer receipts$240,000.00
Suppliers-$105,000.00
Employees-$72,000.00
Income tax-$8,000.00
Net operating cash flows$55,000.00
Equipment purchases-$30,000.00
Equipment sale proceeds$5,000.00
Net investing cash flows-$25,000.00
Borrowings received$20,000.00
Loan principal repaid-$12,000.00
Dividends paid-$6,000.00
Net financing cash flows$2,000.00
Opening cash$18,000.00
Net cash movement$32,000.00
Exchange effect on cash$0.00
Calculated closing cash$50,000.00
Entered closing cash$50,000.00
Unexplained difference$0.00

Profit-to-operating-cash bridge

ItemAmount
Profit or loss$45,000.00
Non-cash profit adjustments$15,000.00
Working capital adjustments-$5,000.00
Other profit adjustments$0.00
Operating cash from bridge$55,000.00
Direct less bridge difference$0.00

Understand the Statement of Cash Flows

A cash flow statement records historical movements in cash and cash equivalents. This cash flow statement template groups those movements and compares calculated closing cash with your entered balance.

Operating activity covers the business’s revenue-producing work. Investing activity includes buying and selling long-term assets. Financing activity covers changes in borrowings and contributed equity.

A cash flow report explains a completed period. A cash budget estimates future receipts and payments. Use the cash flow calculator to plan future cash availability.

Profit includes accruals and non-cash expenses. The bridge explains how those items differ from operating cash. A profitable client can still collect less cash than it pays.

Classify and Reconcile the Movements

Enter each schedule as comma-separated rows, without a header. Each row has a description, a signed amount and an optional source reference. Use positive receipts and negative payments. Quote text containing commas.

For example, Equipment purchase,-30000,Asset register records a $30,000 investing payment. Enter amounts without thousands separators, or quote the amount. An empty schedule means no movements in that category.

Keep major receipt and payment classes separate. The three schedules use the direct method. The profit bridge adds your signed adjustments to entered profit and compares that total with operating cash.

Record non-cash finance in Non-cash disclosures, with the amount and disclosure reference. That note never enters the cash totals. An asset acquired wholly under finance creates no cash receipt or payment at inception.

Use one cash definition for both balances. Exclude transfers within that cash pool. Enter exchange effects on cash separately. AASB 107 sets the presentation and disclosure requirements.

Review classifications against the reporting framework. The workpaper preserves your classifications. Interest, dividends and tax need separate lines and appropriate policies. AASB 18-related classification changes affect interest and dividends when those amendments apply.

The profit bridge is explanatory. When AASB 18 applies, its operating profit starting point and required adjustments need a separate presentation review.

Review the Completed Example

The fictional example collects $240,000 and pays suppliers $105,000, employees $72,000 and income tax $8,000. Operating cash is $55,000.

Equipment purchases of $30,000 and sale proceeds of $5,000 produce investing cash of -$25,000.

Borrowings of $20,000, principal repayments of $12,000 and dividends of $6,000 produce financing cash of $2,000. Opening cash of $18,000 plus net cash of $32,000 reconciles to closing cash of $50,000.

The $18,000 equipment acquisition under finance remains a disclosure note. The bridge starts at $45,000 profit, adds $15,000 in non-cash adjustments and subtracts $5,000 absorbed by working capital. It reaches operating cash of $55,000.

Change Closing cash to $50,100. The unexplained difference becomes $100. Trace that residual to bank balances, missing movements or exchange effects. A zero residual establishes arithmetic agreement, while classification errors can still offset each other.

Before approval, compare the cash definition with the statement of financial position. Review source references, the bridge difference and non-cash disclosures. Consider comparatives and any extra framework-specific notes outside this workpaper.

Download Excel XML saves the statement, both reconciliations and your notes in an Excel-compatible workbook. It contains values, with no spreadsheet formulas. Edit and recalculate in this browser tool before downloading another copy.

Entries stay on this device and clear when you leave or restore navigation. Downloaded files remain where you save them. Use Clear workpaper to remove the example before entering your own figures.