# Excel model audit checklist

> A free Excel model audit and financial model review checklist: 34 checks in 8 groups, each with how to check it in Excel. Print it or get the PDF.

Page: https://formulaudit.com/resources/excel-model-audit-checklist

34 checks for a financial model review, in 8 groups. Each check says how to do it with plain Excel, and where Formula Audit XL does it for you. Formula Audit XL automates 22 of the 34 checks in full or in part.

A printable A4 version: [printable page](https://formulaudit.com/resources/excel-model-audit-checklist/print), or the [PDF](https://formulaudit.com/resources/excel-model-audit-checklist.pdf).

## 1. Structure

- **01. A cover sheet states the purpose, owner, version and key assumptions.** How to check in Excel: Open the first tab. If it does not tell a new reader what the model is for, add one before the review starts. Formula Audit XL: Manual check. Formula Audit XL does not automate this one.
- **02. Inputs, calculations and outputs sit on separate, clearly named sheets or blocks.** How to check in Excel: Walk the sheet tabs and the top of each sheet. Each one should say what it holds. Formula Audit XL: [Quick Navigation (Ctrl+Shift+N) lists every sheet in one panel. Cell Map (Ctrl+Shift+M) shows where inputs and formulas sit.](https://formulaudit.com/features/quick-navigation)
- **03. The calculation flows one way: from inputs to outputs, left to right, top to bottom.** How to check in Excel: Select sample cells and use Formulas > Trace Precedents. Arrows that point down or right back into a block are a warning sign. Formula Audit XL: [Explore Precedents (Ctrl+Q) and Explore Dependents (Ctrl+Shift+Q) show the full chain as a tree, across sheets.](https://formulaudit.com/features/explore-precedents-dependents)
- **04. No hidden or very hidden sheet without a stated reason.** How to check in Excel: Right-click a sheet tab > Unhide lists hidden sheets. Very hidden sheets show only in the VBA editor (Alt+F11), in the sheet Visible property. Formula Audit XL: [Model Check (Ctrl+Shift+R) counts and names hidden and very hidden sheets. Quick Navigation marks them [H] and [VH] and can make them visible again.](https://formulaudit.com/features/model-check)
- **05. No hidden rows or columns that hold live numbers.** How to check in Excel: Look for gaps in the row numbers and column letters, then use Home > Format > Hide & Unhide. Formula Audit XL: Utilities > Unhide makes every hidden row and column visible on the active sheet or the whole workbook.

## 2. Inputs and hardcodes

- **06. Every assumption is entered once, in a labelled input cell.** How to check in Excel: Press F5 > Special > Constants > Numbers on each calculation sheet. Typed numbers outside the input area light up. Formula Audit XL: [Cell Map (Ctrl+Shift+M) gives typed numbers, unique formulas and formulas without references their own colours on the whole sheet.](https://formulaudit.com/features/cell-map)
- **07. No numbers typed inside formulas, such as =B4*1.2 or =C10/12.** How to check in Excel: Press Ctrl+` to show formulas and read each row. There is no reliable Find pattern for this. Formula Audit XL: [Hardcoded Numbers (Ctrl+Shift+H) lists every numeric constant inside a formula. Constant Formulas (Ctrl+Shift+K) lists formulas with no cell reference at all.](https://formulaudit.com/features/audit-checks)
- **08. No typed value overwrites a formula inside a calculated row.** How to check in Excel: Use F5 > Special > Constants inside a block of formulas. One constant in a row of formulas is an overtype. Formula Audit XL: [Cell Map (Ctrl+Shift+M) gives a typed number its own colour, so it stands out in a row of copied formulas.](https://formulaudit.com/features/cell-map)
- **09. Inputs look different from formulas, for example blue font for inputs.** How to check in Excel: Scan the input sheets. A reader must see at a glance which cells they may change. Formula Audit XL: [AutoColor (Ctrl+Shift+A for the sheet, Ctrl+Shift+U for a selection) applies finance-standard font colours by content.](https://formulaudit.com/features/cell-map)
- **10. Input cells show their units and use data validation where a range is known.** How to check in Excel: Use Data > Data Validation > Circle Invalid Data to find inputs outside their allowed range. Formula Audit XL: Manual check. Formula Audit XL does not automate this one.

## 3. Formula consistency

- **11. Each row (or column) uses one formula, copied across.** How to check in Excel: Press Ctrl+` and compare neighbouring cells. Excel’s green triangles flag only some breaks. Formula Audit XL: [Inconsistent Formulas (Ctrl+Shift+I) compares formulas in R1C1 form and lists every cell that breaks its row or column pattern.](https://formulaudit.com/features/inconsistent-formulas)
- **12. No formula is too long to read in one pass.** How to check in Excel: Click through the formula bar on key rows. Split long formulas into helper rows. Formula Audit XL: [Model Check (Ctrl+Shift+R) counts formulas longer than 200 characters on each sheet.](https://formulaudit.com/features/model-check)
- **13. Nesting stays shallow: no more than five levels of brackets.** How to check in Excel: Read the nested IF and LOOKUP chains in the formula bar. Replace deep IFs with a lookup table. Formula Audit XL: [Model Check counts formulas nested more than five bracket levels deep on each sheet.](https://formulaudit.com/features/model-check)
- **14. Absolute and relative references are anchored correctly before formulas are copied.** How to check in Excel: Press F4 to cycle a reference. Check that copied formulas still point at the right input row. Formula Audit XL: [Utilities > Make References Absolute or Relative rewrites the selected formulas. Inconsistent Formulas catches the result of a wrong anchor.](https://formulaudit.com/features/inconsistent-formulas)
- **15. No formula points at an empty cell.** How to check in Excel: Trace Precedents on key outputs and open each source cell. Formula Audit XL: [Explore Precedents (Ctrl+Q) lists every source cell of a formula as a tree, so an empty source is easy to spot.](https://formulaudit.com/features/explore-precedents-dependents)
- **16. Signs follow one convention, for example costs always negative.** How to check in Excel: Check that subtotals add, not subtract, the lines above them, and that each total has the sign you expect. Formula Audit XL: Manual check. Formula Audit XL does not automate this one. Utilities > Switch Signs flips a selection of formulas when you fix one.

## 4. Links and references

- **17. Every link to another workbook is listed and intended.** How to check in Excel: Use Data > Workbook Links (Data > Edit Links in older Excel). Formula Audit XL: [External Links (Ctrl+Shift+L) lists every external reference and can break one link or all of them.](https://formulaudit.com/features/audit-checks)
- **18. No external link is broken.** How to check in Excel: In Data > Edit Links, select each source and click Check Status. Formula Audit XL: Manual check. Formula Audit XL does not automate this one. External Links lists each source file path, so you know which ones to check.
- **19. Every defined name is valid and used.** How to check in Excel: Open Formulas > Name Manager and sort by Value to find #REF! names. Unused names need a search of every formula. Formula Audit XL: [Named Ranges (Ctrl+Shift+J) flags broken, error and unused names and deletes them in the panel. The free Named Range Checker lists them in your browser.](https://formulaudit.com/features/named-ranges)
- **20. Cross-sheet references point at the right sheet and row.** How to check in Excel: Trace Precedents shows a dashed arrow to a sheet icon. Double-click it to open the list of sources. Formula Audit XL: [Explore Precedents follows references across sheets and named ranges. Cell Map marks cross-sheet and cross-workbook references.](https://formulaudit.com/features/explore-precedents-dependents)
- **21. Every calculation feeds something: no dead cells.** How to check in Excel: Use Trace Dependents on suspect cells. Excel says when a cell has no dependents. Formula Audit XL: [Dead Cells (Ctrl+Shift+D) lists the cells on the active sheet that nothing references.](https://formulaudit.com/features/audit-checks)

## 5. Errors

- **22. No error values (#REF!, #DIV/0!, #N/A, #VALUE!) anywhere in the workbook.** How to check in Excel: Use F5 > Special > Formulas > Errors on every sheet, one sheet at a time. Formula Audit XL: [Error Checker (Ctrl+Shift+E) lists every error value across all sheets. Model Check counts them.](https://formulaudit.com/features/audit-checks)
- **23. IFERROR and IFNA do not hide real errors.** How to check in Excel: Use Ctrl+F, Within: Workbook, Look in: Formulas, and search for IFERROR. Check what each one replaces. Formula Audit XL: Manual check. Formula Audit XL does not automate this one.
- **24. Check rows return zero: the balance sheet balances and cash ties.** How to check in Excel: Build one check row per statement and give it a conditional format that turns red when it is not zero. Formula Audit XL: Manual check. Formula Audit XL does not automate this one.

## 6. Circularity

- **25. No unintended circular reference.** How to check in Excel: Use Formulas > Error Checking > Circular References. Excel shows one circular cell at a time. Formula Audit XL: [In the Excel task pane, Circular References shows a circular path of cells for each sheet that has one. The free Circular Reference Finder lists them in your browser.](https://formulaudit.com/features/audit-checks)
- **26. Iterative calculation is off, unless the model needs it and says so.** How to check in Excel: Open File > Options > Formulas and look at Enable iterative calculation. When it is on, Excel stops warning about circular references. Formula Audit XL: Manual check. Formula Audit XL does not automate this one.
- **27. An intended circularity, such as interest on average cash, has a switch that breaks the loop.** How to check in Excel: Look for an input that sets the loop to zero, and test that the model still calculates with it off. Formula Audit XL: [In the Excel task pane, Circular References shows the cells of the loop, so you can confirm the switch is part of it.](https://formulaudit.com/features/audit-checks)

## 7. Outputs and presentation

- **28. Outputs link to calculations. No output is typed.** How to check in Excel: Click through the output and summary sheets and read the formula bar. Formula Audit XL: [Cell Map shows hardcoded numbers on output sheets at a glance.](https://formulaudit.com/features/cell-map)
- **29. Key outputs reconcile to a source: actuals, the prior version or the data room.** How to check in Excel: Tie three or four headline numbers to their source and note the result. Formula Audit XL: Manual check. Formula Audit XL does not automate this one.
- **30. Number formats are consistent: thousands, decimals, negatives in brackets, percentages.** How to check in Excel: Scan each output table at 100% zoom. Formula Audit XL: Manual check. Formula Audit XL does not automate this one. Utilities > Number Cycle and More / Fewer Decimals apply a consistent format when you fix one.
- **31. Charts and summary tables read the current ranges.** How to check in Excel: Click each chart series and check the range in its =SERIES formula covers every period. Formula Audit XL: Manual check. Formula Audit XL does not automate this one.

## 8. Version control

- **32. The file name carries a version number and a date, and only one file is current.** How to check in Excel: Check the folder. Archive older versions where nobody will edit them by mistake. Formula Audit XL: Manual check. Formula Audit XL does not automate this one.
- **33. A change log records what changed, who changed it and when.** How to check in Excel: Keep a log sheet or a note next to the file and update it with every version. Formula Audit XL: Manual check. Formula Audit XL does not automate this one.
- **34. The new version is compared with the last reviewed one before sign-off.** How to check in Excel: Use Spreadsheet Compare or Inquire (in some Microsoft 365 and Office Professional Plus editions), or compare key outputs by hand. Formula Audit XL: [Model Check writes a _ModelCheck sheet you can keep with each version, so you can compare the counts between versions.](https://formulaudit.com/features/model-check)

## FAQ

### Who is this checklist for?

Analysts, model reviewers, FP&A teams and auditors who check a financial model in Excel before it is used for a decision. It works for a review of your own model and for a review of a model someone else built.

### How long does a review with this checklist take?

On a mid-size model, plan half a day for the manual checks. The checks marked with a Formula Audit XL feature take minutes, because the add-in scans the cells for you.

### Do I need Formula Audit XL to use it?

No. Every check has a "how to check in Excel" step that uses built-in Excel commands only. Formula Audit XL makes 22 of the 34 checks faster or automatic.

### What is the difference between a model audit and a model review?

People use the terms loosely. A review usually means a colleague checks the logic and the numbers before sign-off. An audit is usually more formal and independent. The checklist covers the mechanical checks that both need.

### What happens to my email address?

We use it to send you the PDF once. We add you to the newsletter only when you tick the box and then confirm with the link in that email, and every newsletter has a one-click unsubscribe link. The privacy policy has the details.
