Blog · Data quality and reconciliation · Finance and FP&A teams
A cash flow statement must reconcile to the same cash population on the balance sheet. Follow a worked reconciliation through restricted cash, opening balances, noncash purchases and exchange effects.
When a cash flow statement does not match the balance sheet, compare the same cash population before changing a calculation. Then rebuild closing cash from opening cash and the period's movements, and assign each remaining difference to a specific account or schedule.
A zero difference proves the cash rollforward ties. It does not prove that every receipt and payment sits in the right category.
The SEC's guide to financial statements distinguishes balance sheet amounts at a date from cash flows over a period. Your reconciliation needs both opening and closing balances for exactly that period.
Expected closing cash population = Opening cash population + Operating cash flow + Investing cash flow + Financing cash flow + Effect of exchange rate changes
Unexplained difference = Balance sheet cash population - Expected closing cash population
Keep cash definitions consistent at both ends. Under US GAAP, amounts generally described as restricted cash or restricted cash equivalents belong in this reconciliation. FASB's restricted cash update also illustrates how amounts across several balance sheet lines reconcile to the cash flow total and presents exchange effects separately.
Do not assume every short-term investment qualifies as a cash equivalent. Use the company's approved accounting policy and account mapping. The related cash balance sheet guide addresses the balance presentation; this check concerns whether the two reports use the same population.
Bring the opening and closing balance sheets, the cash flow report, the cash account listing and supporting fixed-asset and debt schedules. Record the reporting period, entity scope, currency, units and export version beside each file.
The account listing should retain account code, description, balance sheet caption, opening balance, closing balance and inclusion in the cash population. Keep excluded accounts visible with a reason. This makes an omission easier to distinguish from a policy choice.
Check that an October report begins with the final September close. A late September journal can leave an earlier export behind even when both reports carry plausible dates. Apply the spreadsheet total checks before diagnosing an accounting difference caused by a filtered row or text-formatted amount.
Consider an illustrative US distributor reporting for September 2026. Its approved cash mapping includes these balances. Every amount is in whole USD; parentheses in later tables indicate negative amounts.
| Balance sheet component | August 31 (USD) | September 30 (USD) | Change (USD) |
|---|---|---|---|
| Cash and cash equivalents | 400,000 | 510,000 | 110,000 |
| Restricted cash in current assets | 30,000 | 40,000 | 10,000 |
| Restricted cash in noncurrent assets | 20,000 | 25,000 | 5,000 |
| Cash population for the cash flow reconciliation | 450,000 | 575,000 | 125,000 |
The closing target is $575,000. A correctly prepared cash flow report showing that amount would appear $65,000 above the unrestricted balance sheet line: $575,000 - $510,000. That is a definition difference, fully explained by $40,000 + $25,000 of restricted cash.
For a spreadsheet with opening balances in B2:B4 and closing balances in C2:C4, enter:
B5 = SUM(B2:B4)
C5 = SUM(C2:C4)
D2 = C2-B2
D5 = C5-B5
Fill D2 down through D4. The component changes must sum to D5.
The distributor's draft cash flow report actually ends at $530,000. Comparing that with the correct $575,000 population leaves $45,000 unexplained.
Review finds three documented errors. Opening cash omitted the noncurrent restricted account. Equipment additions included a purchase financed directly by the seller. The report also omitted the supplied exchange effect on foreign-currency cash balances.
| Cash flow row | Draft (USD) | Correction (USD) | Corrected (USD) |
|---|---|---|---|
| Opening cash population | 430,000 | 20,000 | 450,000 |
| Operating cash flow | 180,000 | 0 | 180,000 |
| Investing cash flow | (130,000) | 30,000 | (100,000) |
| Financing cash flow | 50,000 | 0 | 50,000 |
| Exchange effect | 0 | (5,000) | (5,000) |
| Expected closing cash population | 530,000 | 45,000 | 575,000 |
The fixed-asset schedule shows $130,000 of equipment additions: $100,000 paid in cash and $30,000 acquired through a direct seller-financing obligation. The latter belongs in the noncash supporting disclosure, rather than cash purchases or cash borrowing proceeds. FASB's original cash flow standard, paragraph 32, explains this separation of cash and noncash portions; current reporting should follow the controller's approved ASC 230 policy.
Financing cash flow of $50,000 is separately supported by actual cash receipts. It contains no proceeds for the seller-financed equipment. Correcting only investing cash flow therefore removes a genuine false outflow.
With draft amounts in B2:B6 and corrections in C2:C6, calculate:
D2 = B2+C2
B7 = SUM(B2:B6)
C7 = SUM(C2:C6)
D7 = SUM(D2:D6)
Fill D2 through D6. If F2 contains the balance sheet target of 575000, the final check is:
=F2-D7
The result is zero: $450,000 + $180,000 - $100,000 + $50,000 - $5,000 = $575,000. The correction bridge also closes: $20,000 + $30,000 - $5,000 = $45,000.
Once the rollforward ties, review classifications independently. Equal and opposite operating and investing errors can leave closing cash unchanged while misleading management about operating cash generation.
Keep the corrected report, account population and evidence together. The cash flow statement template provides the broader layout; the trial balance method explains how to build the account-level movements that support it.
Upload your opening and closing cash balances, cash flow export and supporting schedules to Covirage. Covirage maps the columns, its tools compute and check the reconciliation, and the external AI model explains the differences with every figure traced to its rows. Create a free Covirage account and bring a sample of your own reports.
See Covirage for finance teams for the reporting context.
It should equal the corresponding cash population, which can span several balance sheet lines. Under US GAAP, the cash flow reconciliation includes restricted cash and restricted cash equivalents, so comparing only the unrestricted cash line can create an apparent difference.
No. A balance sheet can balance while a cash flow statement misclassifies receipts, omits payments or includes noncash movements. Check the cash rollforward and the separate operating, investing and financing classifications against the underlying schedules.
Depreciation affects profit without using cash in that period. An indirect cash flow statement adds the expense back to net income. Missing that adjustment can cause a difference, but adding it twice creates another error.
The preparer should identify the accounts and schedules behind the difference. Treasury confirms the cash account population, while the controller reviews accounting classifications and adjustments. Keep the difference visible until the evidence supports a correction.