Financial model review
Cash flow checks for financial models
Check a financial model's cash flow with a worked example. Reconcile opening and closing cash, review payment timing and separate profit from cash receipts.

To check cash flow in a financial model, reconcile opening cash to closing cash, trace the movements to their supporting schedules and test when money actually changes hands. A forecast can show a profit and still run out of cash. A positive month-end balance can also conceal a shortfall earlier in that month.
Start with a separate review copy and one period you can calculate independently. These invented exercises are not recommended assumptions or a complete financial-statement presentation.
Establish what the cash balance includes
Identify the accounts, currency and dates covered by the cash row. Does it represent one bank account, several accounts or a wider defined balance? Restricted funds and different currencies need explicit treatment. Do not assume that two rows both labelled Cash contain the same accounts.
The IFRS Foundation's IAS 7 overview describes operating, investing and financing cash flows and the reconciliation of cash amounts to the statement of financial position. A planning workbook may use a simpler layout, but its balance definition still needs to be clear.
Compare opening cash with the approved prior-period closing amount. A financial forecast starting with the wrong opening balance can remain internally consistent throughout. Record the source and date rather than accepting the opening cell because every later column links to it.
Recalculate one opening-to-closing bridge
Assume a simplified monthly forecast uses positive inputs for both receipts and payments:
- Opening cash: EUR 30,000.
- Customer receipts: EUR 80,000.
- Supplier payments: EUR 35,000.
- Payroll payments: EUR 30,000.
- Equipment purchase paid in cash: EUR 12,000.
- New borrowing received: EUR 10,000.
- Loan principal repaid: EUR 4,000.
There are no other movements in this example. The expected result is:
Closing cash = 30,000 + 80,000 - 35,000 - 30,000
- 12,000 + 10,000 - 4,000
= EUR 39,000
Net movement = EUR 9,000
Compare EUR 39,000 with closing cash and the next month's opening balance. Add a check subtracting opening cash and all signed movements from closing cash. The expected residual is zero here.
Do not manufacture agreement by typing an unexplained balancing movement. If the model shows EUR 51,000, the EUR 12,000 difference may indicate that the equipment payment was excluded. Trace the difference before deciding which formula needs correction.
Check that a subtotal is not counted twice
A common spreadsheet problem is adding detailed payments and their subtotal together. Another is including borrowing in operating receipts and then adding the financing receipt again below.
Trace each bridge line to its source. Identify whether it contains an individual movement, a subtotal or a balance. In the example, EUR 10,000 is new cash received from borrowing. It is neither sales revenue nor the closing loan balance. The debt-schedule checklist explains how to connect that movement to the borrowing schedule.
Use consistent signs. If a source schedule already stores the equipment payment as -12000, add that signed movement instead of subtracting it again. See the units, signs and periods guide for a separate sign-testing exercise.
Keep profit and cash adjustments separate
Revenue can be recorded before a customer pays. A supplier cost may be recognized before settlement. Depreciation can reduce profit without being a current-period cash payment. The SEC's financial statements guide explains why an income statement and a cash flow statement answer different questions.
Identify whether the model starts with actual forecast receipts and payments or adjusts an accounting profit measure. If receipts already reflect customer collection timing, do not subtract the receivables increase again without understanding the model's structure. That can count the same timing effect twice.
Use the working-capital review to check receivables, inventory and payables. Keep capital expenditure, borrowing and repayments visible so that an operating profit subtotal cannot silently become the cash movement.
Test the timing inside the period
A month-end total does not prove that every payment can be made when due. In a second simplified example, opening cash is EUR 4,000, a EUR 7,000 payment is due early in the month and EUR 10,000 arrives at month-end. Closing cash is EUR 7,000, but cash would fall to minus EUR 3,000 before the receipt, absent financing or other arrangements.
Where payment timing matters, inspect weekly or daily movements and the minimum balance. Check actual dates rather than spreading all receipts evenly by convenience. A coarse monthly model may need a separate short-term cash schedule; that is a modeling limitation, not an Excel formula error.
In a copy of the first example, increase supplier payments by EUR 1,000 and hold everything else fixed. Expected closing cash becomes EUR 38,000. Move a receipt to the next month and verify both affected months. Restore the original assumptions after testing.
Know what the saved-file checker adds
FinModelCheck does not reconcile cash flows, verify account balances, test payment timing or recalculate Excel. It can inspect supported saved Excel errors, broken references, external workbook links, embedded numeric coefficients, broken defined names and a saved manual-calculation setting. An external dependency or coefficient may be intentional.
Saved formula results can be older than the assumptions currently visible. Microsoft's SpreadsheetML formula documentation explains how formula text and cached results are stored separately. Missing cached evidence is not proof of a zero or a successful calculation.
Use the checker as a supplementary review and view the example report. Online results show the provisional score and counts by Finding type; the complete PDF is free in the current valid owning browser session without registration. Neither result certifies the cash forecast.
Frequently asked questions
Does positive closing cash mean the forecast is safe?
No. The opening amount, omitted payments, timing and assumptions still need review. A month-end surplus can coexist with an earlier shortfall.
Should every cash check equal exactly zero?
The exact bridge above should. Real workbooks may require a documented rounding tolerance and adjustments for their defined scope. Investigate unexplained residuals before accepting them as rounding.
Can a high checker score confirm a cash flow model?
No. The score summarizes supported saved-file evidence. Financial relationships, payment timing and business assumptions require the separate checks described here.


