Financial model review

Financial model handover checklist

Use a practical checklist to hand over an Excel financial model: document assumptions, dependencies, input tests, review limits and the exact file version.

A financial workbook beside an organized handover checklist

A financial model is ready to hand over when another person can understand its purpose, change its intended inputs and explain its important outputs. A polished dashboard alone cannot provide that assurance. The recipient also needs to know which file is current, where assumptions came from and which checks remain unfinished.

Use the checklist below for a forecast, budget or other financial workbook. Scale the review to the decision it supports. A quick management estimate and a financing submission may need very different levels of independent review.

Identify the exact file and its purpose

Keep the original unchanged and work on a clearly named review copy. Record the version, preparation date, reporting currency, units and forecast period. State whether the workbook is for internal budgeting, a funding discussion or another specific use.

Explain what it does not cover. A revenue forecast with no financing schedule should not be described as a complete cash runway model. A calculation in thousands of euros should say so at the inputs and outputs, not only in a note several sheets away.

Write a short opening instruction for the next person: where to begin, which cells are intended inputs and which sheet contains the principal outputs. Do not rely on color alone; add labels so that someone can understand the workbook without knowing your formatting convention.

Make important assumptions traceable

For significant inputs, identify the description, units, applicable period, source and date. Distinguish approved assumptions from placeholders that still need confirmation. A typed rate that looks precise is not necessarily supported by evidence.

For example, if monthly revenue depends on unit sales and price, identify both inputs and explain whether prices include any taxes or discounts relevant to the model. Do not silently mix gross and net figures. Repeated assumptions should have a clear maintenance location rather than require the recipient to hunt through formulas.

The embedded-assumption guide explains how to review numbers inside formulas. If the workbook uses named inputs, apply the named-range review before assuming that a readable name points to the correct cell.

List the files and features it depends on

Document any required source workbooks, data connections, add-ins or other software. Explain how the recipient obtains approved inputs and who maintains them. Do not include passwords or private credentials in a handover note.

Review external workbook links before removing them. Excel's link-management commands can change a source or replace linked formulas with values, which may remove logic that the recipient needs. Microsoft's workbook-link guide describes these operations. Keep a separate original before making that decision.

Also inspect hidden worksheets and columns relevant to the model. Hiding a sheet is a presentation choice, not removal of its data. Confirm that the recipient is authorized to receive the workbook's contents; a financial checker is not a confidential-information removal tool.

Check the saved version as well as the open workbook

Excel calculation settings affect when formulas update. In Excel for Windows, review File > Options > Formulas and confirm the intended calculation mode before doing controlled tests. Microsoft documents the available modes in its calculation guide. Other versions may use different menus.

If you recalculate or refresh approved inputs, save a separate reviewed version and record what changed. Do not refresh unknown external connections merely to remove a warning. Reopen the delivered copy in the intended environment and compare its key outputs with your review record.

An XLSX can store formula text and a previously calculated value separately. Microsoft's SpreadsheetML explanation describes this distinction. A static inspection of a saved file cannot establish what every formula would calculate now, and an absent saved result is not proof of a zero or an error.

Give the recipient one reproducible test

Suppose an invented model sells 200 units at EUR 25, with variable costs of EUR 15 per unit and fixed costs of EUR 1,000. Revenue is EUR 5,000 and simplified operating profit is EUR 1,000.

In a working copy, changing units to 220 should make revenue EUR 5,500 and profit EUR 1,200, with the other assumptions held fixed. Write down the original input, changed input, expected outputs and observed outputs. Restore 200 units before saving the approved base case.

The test does not certify the whole model. It gives the next person a known relationship they can reproduce, and helps distinguish a disconnected assumption from a misunderstanding. Add a few tests for the model's most important drivers rather than hundreds of unexplained screenshots.

Separate completed review from open questions

Keep a compact handover note with the file version, reviewed areas, corrections made and unresolved questions. If financial statements are present, name the reconciliations that were checked and those still awaiting review. Do not describe a balance sheet as balanced unless the relevant amounts, dates and sign conventions were actually compared.

For each unresolved question, identify the relevant sheet or assumption, the next action and the person responsible. Avoid a blanket statement such as All formulas checked when only a few rows were sampled. A limited review described accurately is more useful than an unsupported assurance.

A final delivery checklist

  1. Deliver the intended version with its purpose, dates, currency and units.
  2. Explain the inputs, outputs and significant assumption sources.
  3. List external dependencies and required Excel features.
  4. Preserve an unchanged original and a record of deliberate corrections.
  5. Include a reproducible input-change test and restore the base case.
  6. State review limitations and remaining actions clearly.

FinModelCheck provides a supplementary inspection of supported saved Excel errors, broken references, external workbook links and embedded numeric coefficients. It does not recalculate Excel, reconcile financial statements or certify readiness for an investment, loan or other decision.

Run the supported inspection through the checker, compare the example report and download the free complete PDF in the current valid owning browser session without registration. Save that report with your handover materials before session access expires. Use it alongside your manual review, rather than as a substitute for understanding the financial model.

Keep reviewing

Continue with a related guide.

Browse all guides