# Excel model review checklist for financial models

> An Excel model review checklist in five stages: scope, structure, inputs, outputs and formulas, with the Excel method for each check and a sign-off record.

Page: https://formulaudit.com/blog/excel-model-review-checklist

Published 2026-11-16 · updated 2026-11-19

Tags: Model review, Checklist

A model review usually goes wrong in one of two ways. The reviewer checks everything at the same depth and runs out of time. Or the reviewer checks what looks interesting and misses the cell that matters. An Excel model review checklist fixes both, if it stays short and puts the effort where the risk is.

This checklist follows the five review stages in the ICAEW guide on [how to review a spreadsheet](https://www.icaew.com/technical/technology/excel-community/how-to-review-a-spreadsheet). Each item gives the Excel method to check it. Use it as a financial model review checklist for budgets, forecasts and deal models. Print this page, or copy the one-page list at the end into your review file.

If the model is new to you, start with how to [review a financial model you didn't build](https://formulaudit.com/blog/review-financial-model-you-didnt-build/). For the mechanical checks in full detail, see the [financial model audit guide](https://formulaudit.com/guides/audit-financial-model-excel/).

## Size the financial model review checklist to the risk

The ICAEW Excel Community is direct about long lists. Kyle Chaning-Pearce writes in [part 14 of its modelling series](https://www.icaew.com/technical/technology/excel-community/excel-community-articles/2021/intro-to-financial-modelling-part-14): "Exhaustive checklists are helpful but will probably be ignored".

The ICAEW review guide makes the same point. Testing every cell of a large model takes too long. So "it is helpful to target the most critical areas and outputs".

So decide the depth first. The three levels below are our suggestion, not an ICAEW rule. Sort the model by what depends on its output:

| Impact | Example | What to run |
|---|---|---|
| High | Lender model, deal model, board pack, regulatory return | All five stages, with every formula behind the key outputs |
| Medium | Annual budget, internal business case | Stages 1 to 4, and stage 5 for key outputs only |
| Low | A one-off analysis for your own team | Stages 1 and 4 |

Then write down the two or three outputs that matter most: the valuation, the covenant headroom, the closing cash. Every stage below comes back to them.

## Stage 1: initial review

The aim is a first view of the state of the file, before you read a single formula.

- [ ] You know the purpose of the model, the decision it supports and its key outputs.
- [ ] You work on a copy and keep the original as your reference.
- [ ] The calculation mode is Automatic. Check **Formulas → Calculation Options**. If the status bar shows **Calculate**, the results may be stale.
- [ ] Every link to another workbook is known. Open **Data → Queries and Connections → Workbook Links**, or **Data → Edit Links** in older versions.
- [ ] Hidden and very hidden sheets are listed, and each one has a reason. The steps are in [how to find hidden sheets in Excel](https://formulaudit.com/blog/find-hidden-sheets-in-excel/).
- [ ] Each circular reference is intentional, with [iterative calculation](https://formulaudit.com/guides/enable-iterative-calculation-excel/) turned on.

The links item needs more than one dialog. Microsoft's page on [managing workbook links](https://support.microsoft.com/en-us/office/find-links-external-references-in-a-workbook-fcbf4576-3aab-4029-ba25-54313a532ff1) says there is no automatic way to find all of them.

So also press `Ctrl` + `F` and click **Options**. Search for `.xl` with **Within** set to **Workbook** and **Look in** set to **Formulas**. Then click **Find All**. Links can also sit in defined names, chart series, chart titles and shapes. The [external links guide](https://formulaudit.com/guides/break-external-links-excel/) covers each place.

The questions in this stage are the same for every model. That makes it a good place for a tool.

Model Check in Formula Audit XL (`Ctrl` + `Shift` + `R`) writes a `_ModelCheck` sheet. It counts errors, circular references, broken external links, hardcoded numbers, and hidden and very hidden sheets. A detail table follows for each sheet. The counts tell you how deep the later stages need to go.

## Stage 2: structural review

ICAEW describes this stage as checking that the spreadsheet "is well laid out and includes appropriate checks".

- [ ] Inputs, calculations and outputs sit in separate, labelled areas.
- [ ] Each sheet flows in one direction, usually left to right and top to bottom.
- [ ] Time periods use the same columns on every calculation sheet.
- [ ] Units and signs are stated, for example "USD thousands" and "costs shown as negative".
- [ ] The model has integrity checks. The balance sheet balances, cash agrees between statements, and subtotals add up.
- [ ] One master check cell sums all the checks and shows zero.
- [ ] Defined names are valid. In the Name Manager (`Ctrl` + `F3`), use **Filter → Names with Errors**.

If the model has no integrity checks, record that as a finding. A balance check costs one row. It catches a whole class of errors on every future change.

## Stage 3: data review

A model with correct formulas still gives wrong answers from wrong inputs. This stage checks "the validity of the input data", in ICAEW's words.

- [ ] Every input has a source: a file, a date or a person.
- [ ] Historical figures agree with the audited accounts or with the ledger they came from.
- [ ] Growth, margins, rates and other key assumptions sit in labelled input cells, not inside formulas.
- [ ] Input values are in a plausible range. A growth rate typed as 5 where 0.05 was meant is easy to miss on screen.
- [ ] Inputs follow the colour convention of the model, if it has one.

Numbers typed inside formulas are the hardest item here, because they look like normal results. Our article on how to [find hardcoded numbers in Excel](https://formulaudit.com/blog/find-hardcoded-numbers-excel/) gives five ways to find them. It also lists the numbers you can leave alone.

## Stage 4: analytical review

In ICAEW's words, this stage checks "if the spreadsheet's output looks reasonable at a holistic level". You read the results as a business reader, not as a formula reader.

- [ ] Key outputs agree with history, the budget, or a quick estimate on paper.
- [ ] Ratios make sense: margins, growth, leverage and cash conversion.
- [ ] Simple tests give the expected result. Set growth to zero and revenue stays flat. Double the volume and variable costs double, while fixed costs stay the same.
- [ ] An extreme value in one input breaks nothing you cannot explain.
- [ ] Each scenario and sensitivity moves the outputs in the expected direction.

Before you start the tests, add the key outputs to **Formulas → Watch Window**. You then see them change while you edit inputs on another sheet.

## Stage 5: detailed review

This is the formula-level check. In a high-impact model, follow every formula on the path to the key outputs. In a medium-impact model, trace the key outputs only.

- [ ] Each key output traces back to the right inputs. Press `Alt` + `M`, `P` for the precedent arrows. Use **Formulas → Evaluate Formula** to step through a long formula. The [trace precedents guide](https://formulaudit.com/guides/trace-precedents-excel/) covers the arrows across sheets.
- [ ] Formulas are consistent along each row and down each column.
- [ ] No error values remain. No `IFERROR` hides an error that needs a fix. To find hidden breaks, follow [how to find #REF errors in Excel](https://formulaudit.com/blog/find-ref-errors-in-excel/).
- [ ] Each `SUM` and lookup covers the full range it should, including the first and last rows.
- [ ] The changes since the last version are known and explained.

The consistency item matters most. An overtyped cell in a row of copied formulas gives a plausible number and no warning. The [inconsistent formulas guide](https://formulaudit.com/guides/inconsistent-formulas-excel/) covers Excel's green triangles and their limits. Formula Audit XL has an [Inconsistent Formulas](https://formulaudit.com/features/inconsistent-formulas/) check (`Ctrl` + `Shift` + `I`). It lists each cell on the active sheet that breaks the pattern of its row or column.

For the version item, Excel has Spreadsheet Compare. Microsoft's page on how to [compare two versions of a workbook](https://support.microsoft.com/en-us/office/compare-two-versions-of-a-workbook-by-using-spreadsheet-compare-0e1627fd-ce14-4c33-9ab1-8ea82c6a5a7e) opens it from **Inquire → Compare Files**. If the Inquire tab is missing, turn on the Inquire add-in first.

Spreadsheet Compare is available only in Excel for Windows with Microsoft 365 Apps for enterprise plans and equivalent editions. Without it, ask the builder for a change log. Then compare the key outputs of both versions side by side.

## Close the review: findings and sign-off

For ICAEW, a review ends when the findings are "documented, communicated to the appropriate people, and changes have been implemented".

- [ ] Each finding is in an issue log: sheet, cell, severity and a question for the builder.
- [ ] Each high-severity finding is fixed and checked again in the new version, not only answered.
- [ ] The reviewed version has a clear name, and the sign-off is recorded.

A short sign-off record is enough:

| Field | Example |
|---|---|
| Model and version | Budget_2027_v4.xlsx |
| Review depth | Medium impact: stages 1 to 4, stage 5 for the key outputs |
| Reviewer and date | The name of the reviewer and the date of sign-off |
| Open findings | Two medium findings, accepted by the model owner |
| Decision | Approved for the budget submission |

The record turns the review into evidence. The next reviewer starts from your notes, not from zero.

## The Excel model review checklist on one page

Copy this list into your review file. Mark each line done, not applicable, or open with a reference to the issue log.

1. Purpose, decision and key outputs written down.
2. Copy opened, calculation mode Automatic, workbook links listed.
3. Hidden sheets and circular references explained.
4. Inputs, calculations and outputs separated. Integrity checks present and at zero.
5. Defined names valid.
6. Every input has a source. Historical figures agree with the accounts.
7. No assumptions typed inside formulas.
8. Outputs reasonable against history and a paper estimate.
9. Zero-growth, double-volume and extreme-value tests passed.
10. Key outputs traced back to their inputs.
11. Rows and columns consistent. No error values left.
12. Changes since the last version explained.
13. Findings logged, fixed and checked again.
14. Version named and sign-off recorded.

The judgement items need a person. The mechanical items (links, hidden sheets, circular references, hardcoded numbers and error values) do not. To run those in one step on your next model, [download Formula Audit XL and start the 7-day free trial](https://formulaudit.com/download/).

## FAQ

### What should an Excel model review checklist include?

A useful checklist follows five stages. First, the purpose, key outputs and state of the file. Second, the layout and built-in checks. Third, the source and range of every input. Fourth, whether the outputs are reasonable and react correctly to simple tests. Fifth, the formulas on the path to the key outputs. It ends with an issue log and a recorded sign-off.

### How is a model review different from a model audit?

A model audit usually means the mechanical checks: circular references, error values, external links, hardcoded numbers and inconsistent formulas. A model review includes those checks. It also asks if the model answers the right question, the inputs are correct, and the outputs make sense. The audit is one part of the review.

### Do you need to check every formula in a model review?

Not in most models. Testing every cell of a large model takes too long, so size the review to the risk. In a high-impact model, such as a lender model, check every formula on the path to the key outputs. In a medium-impact model, trace the key outputs only. A low-impact model needs the initial and analytical checks.

### Who should sign off a financial model review?

The reviewer signs that the agreed checks were done, and the model owner accepts any finding that stays open. The record names the file and version, the review depth, the reviewer, the date, the open findings and the decision. Someone other than the builder should do the review, because the builder tends to repeat the same blind spots.

## Related reading

- [How to audit a financial model in Excel](https://formulaudit.com/guides/audit-financial-model-excel/)
- [Review a financial model you didn't build](https://formulaudit.com/blog/review-financial-model-you-didnt-build/)
- [Inconsistent formulas in Excel: find and fix](https://formulaudit.com/guides/inconsistent-formulas-excel/)
- [Spreadsheet risk and model governance](https://formulaudit.com/blog/spreadsheet-risk-model-governance/)
