Blog · Finance metrics and formulas · Finance and FP&A teams
A consolidated cash flow statement reports the group's external cash movements after intercompany activity is eliminated. Follow a worked parent-and-subsidiary reconciliation, with workbook formulas and checks for category totals and ending cash.
A consolidated cash flow statement reports a parent and its consolidated subsidiaries as one economic entity, eliminating cash movements within the group. Start with consistent entity schedules, remove intercompany activity, and reconcile the resulting sections to group cash. Adding entity net movements can produce the right ending balance while leaving investing and financing activities wrong.
Use the controller's approved consolidation scope, including the dates entities enter or leave the group. Ownership alone is not a complete consolidation assessment; establish which entities are consolidated before combining their schedules. For this example, a US parent and its wholly owned US subsidiary are consolidated for the entire quarter, both report in USD, and there are no acquisitions, disposals or foreign-exchange effects.
The cash definition must agree at both ends. FASB's Topic 230 amendments on restricted cash require the statement to explain changes in cash, cash equivalents and amounts generally described as restricted cash or restricted cash equivalents. The illustration below has no restricted cash.
Bring the entity cash flow schedules, opening and closing balance sheets, cash-ledger details and intercompany transaction register. Include entity, counterparty, date, reference, currency, signed cash amount and cash flow category. Keep the single-company statement template as the starting structure; group scope and eliminations are additional work.
The parent receives customer cash and pays external operating costs, leaving $500,000 of external operating cash flow. The subsidiary's equivalent net amount is $200,000. They also have an internal goods settlement and an internal loan.
| Source movement | Parent (USD) | Subsidiary (USD) | Entity classification |
|---|---|---|---|
| External customer collections | 1,200,000 | 600,000 | Operating |
| External operating payments | -700,000 | -400,000 | Operating |
| Internal goods settlement | 60,000 | -60,000 | Operating for both |
| External equipment purchases | -250,000 | -100,000 | Investing |
| Loan from parent to subsidiary | -150,000 | 150,000 | Parent investing; subsidiary financing |
| External borrowing | 300,000 | 0 | Financing |
| Dividend to parent's external shareholders | -100,000 | 0 | Financing |
| Net cash movement | 360,000 | 190,000 | All sections |
These are settled cash movements, with receipts positive and payments negative. Whole-dollar amounts are exact. The internal loan is a conventional cash loan, with no interest payment during this example period.
If the source is an indirect statement, first reconcile each entity's net income and operating adjustments. Eliminate related intercompany profit and balance-sheet effects consistently with the consolidated statements. The accrual versus cash accounting example explains why a ledger revenue entry alone is not evidence of a cash receipt.
Give each internal settlement a shared reference and match both sides. The SEC's disclosure simplification release identifies elimination of intercompany transactions as a US GAAP requirement and references ASC 810-10-45-1. A transfer inside the consolidation boundary cannot become an external group receipt or payment.
| Reference | Entity and section | Recorded cash flow (USD) | Elimination adjustment (USD) | Group cash flow (USD) |
|---|---|---|---|---|
| TRADE-A | Parent operating | 60,000 | -60,000 | 0 |
| TRADE-A | Subsidiary operating | -60,000 | 60,000 | 0 |
| LOAN-A | Parent investing | -150,000 | 150,000 | 0 |
| LOAN-A | Subsidiary financing | 150,000 | -150,000 | 0 |
| Total | 0 | 0 | 0 |
The goods settlement cancels within operating cash flow. The loan requires an adjustment across sections: add $150,000 to investing and subtract $150,000 from financing. The total elimination is zero, but those category adjustments are essential.
Do not eliminate a payment merely because its counterparty is related. A company outside the consolidated boundary is still outside this group's cash statement. Separately identify external bank fees attached to an internal transfer; those fees do leave the group.
In the elimination register, put the recorded signed cash flow in column C and the adjustment in D. Group cash flow in E2 is:
=C2+D2
Copy the formula through E5. Each of the four internal rows should equal zero, and the overall adjustment should also equal zero:
=SUM(D2:D5)
Next build the summary below in A1:E5. Columns B and C contain the entity totals, D contains the signed elimination by section, and E contains the consolidated result.
| Section | Parent (USD) | Subsidiary (USD) | Elimination (USD) | Group (USD) |
|---|---|---|---|---|
| Operating | 560,000 | 140,000 | 0 | 700,000 |
| Investing | -400,000 | -100,000 | 150,000 | -350,000 |
| Financing | 200,000 | 150,000 | -150,000 | 200,000 |
| Net cash movement | 360,000 | 190,000 | 0 | 550,000 |
Enter this in E2 and fill through E4:
=SUM(B2:D2)
The group net movement in E5 is:
=SUM(E2:E4)
That returns $550,000. Without the loan elimination, investing would show −$500,000 and financing $350,000. Those incorrect sections still sum with operating cash flow to $550,000, demonstrating why a net cash check alone is insufficient.
| Cash reconciliation | Parent (USD) | Subsidiary (USD) | Group (USD) |
|---|---|---|---|
| Opening cash and cash equivalents | 400,000 | 250,000 | 650,000 |
| Net cash movement | 360,000 | 190,000 | 550,000 |
| Closing cash and cash equivalents | 760,000 | 440,000 | 1,200,000 |
Group opening cash is $400,000 + $250,000 = $650,000. Group closing cash is $760,000 + $440,000 = $1,200,000. Their $550,000 difference equals $700,000 − $350,000 + $200,000 from the consolidated sections.
Tie both endpoints to the consolidated balance-sheet cash reconciliation and the supporting entity balances. Maintain a separate schedule for currency effects when relevant; foreign-currency cash flow reporting covers that additional reconciliation. Asset classifications have their own supporting work, including the fixed-assets cash flow schedule.
Bring a sample of your own prepared entity schedules and elimination workbook as a file. Covirage maps the columns; its tools compute and check supplied entity totals, adjustments and group reconciliations, and the external AI model explains the result with every figure traced to its rows. Create a free Covirage account, then set up your business and bring your own workbook.
See Covirage for finance teams for the wider reporting workflow.
Adding them provides a starting schedule, but intercompany cash flows must be eliminated and accounting classifications aligned. The group also needs consistent periods, currencies and cash definitions. An intercompany loan can distort investing and financing totals even when the overall cash change already agrees.
For a subsidiary that is consolidated, include its cash flows in full and apply the relevant consolidation adjustments. Do not multiply every line by the parent's ownership percentage. Payments involving noncontrolling shareholders require separate identification because those shareholders are outside the consolidated group.
Identify both sides and remove internal movements from the group's activity totals. They change where group cash is held without changing group cash overall. Investigate settlement timing differences and cash in transit rather than inserting an unexplained balancing entry.
It proves the net movement agrees with the selected opening and closing balances. It does not prove section classifications or gross disclosures are correct. Check every elimination by entity and cash flow category, and reconcile the finished statement to the consolidated financial statements.