Summary
Spreadsheet research has consistently found errors in most real-world models: field audits since 1997 found errors in about 91% of the spreadsheets examined, and roughly 1% to 5% of formula cells tend to be wrong. A single reviewer typically catches only about half of errors, while team inspection catches around 80%. This checklist covers the structure, formula, integrity, assumption and output checks every financial model should pass, how to organize reviews and how to tie history back to CRA filings. It includes a scorecard that estimates your model's error risk.
Every financial model contains decisions: how revenue grows, when costs rise, how much cash is needed. When a formula is wrong, those decisions are wrong too. A broken link can understate a loan requirement, a sign error can turn a loss into a profit, and an outdated tax rate can shift a valuation by thousands of dollars.
The problem is rarely carelessness. Large spreadsheets have thousands of formulas, and even careful builders make small mistakes at a predictable rate. What separates reliable models from risky ones is a disciplined quality assurance process that catches errors before a lender, investor or board does.
Ledgerive's financial modeling services build QA into every model we deliver, and we review models built by others. This checklist sets out the checks we use, so you can apply them to your own model before it leaves your hands.
Sending a model to a lender or investor soon?
Book a free 30-minute call and we'll tell you what an independent review would check before anyone else finds the errors.
1. What the Research Says About Model Errors
Simple typing errors are easy to spot. Logic errors and omissions, such as a missing cost or the wrong formula approach, are much harder, and they tend to cause the largest misstatements.
2. The Three Types of Model Errors
| Type | Examples | Best way to catch it |
|---|---|---|
| Mechanical | Wrong cell reference, typo in a number, range that misses a row | Formula consistency checks, trace precedents |
| Logic | Wrong formula approach, interest on the wrong balance, double-counting | Independent review of methodology |
| Omission | Missing tax, owner pay, loan payments or HST timing | Checklist review against a complete model structure |
3. Structure and Layout Checks
- Separate inputs, calculations and outputs on different sheets or clearly marked sections.
- Colour-code cells: one colour for inputs, another for formulas and another for links from other sheets.
- Consistent timeline: the same columns represent the same periods on every sheet.
- One row, one formula: each row uses the same formula across all periods.
- Clear labels and units for every row, such as dollars, thousands, percentages or units sold.
- No hidden rows or sheets containing calculations that reviewers can't see.
4. Formula and Calculation Checks
- No hard-coded numbers inside formulas, such as "=B5*1.13"; tax rates and growth rates belong in input cells.
- Check references after inserting rows or columns, especially SUM ranges.
- Keep formulas short; split long nested formulas into steps.
- Avoid or flag circular references, such as interest calculated on average cash, with a switch to break them.
- Check signs: costs and outflows are treated consistently as positive or negative.
- Check units: don't add thousands to dollars or monthly to annual figures.
- Search for errors: scan for #REF!, #DIV/0!, #N/A and #VALUE! results.
5. Integrity Checks Every Model Needs
| Check | What it confirms |
|---|---|
| Balance sheet balances | Assets equal liabilities plus equity in every period |
| Cash ties | Ending cash on the cash flow statement equals cash on the balance sheet |
| Retained earnings roll-forward | Opening plus net income less dividends equals closing |
| Debt schedule ties | Loan balances match the balance sheet; payments match the cash flow |
| Subtotals agree | Revenue by product sums to total revenue, and so on |
| Master check | One cell on the front sheet showing whether every check passes |
6. Assumption and Output Checks
- Every assumption has a source: history, quotes, contracts or market data. Our financial model data collection checklist covers what to gather.
- History matches the books: historical periods agree with reconciled financial statements. Mixed personal spending distorts this; see how to separate personal and business expenses.
- Current rates: tax and interest assumptions reflect today's rules, such as Ontario's 2.2% small business rate from July 1, 2026; see the Ontario corporate tax rate guide.
- Sanity-check ratios: margins, growth, debt service coverage and working capital days compared with history and benchmarks.
- Stress test: set sales to zero or double costs to confirm the model behaves logically.
- Scenario switches work: base, downside and upside cases change the outputs as expected.
- Outputs match the documents: figures in the business plan or pitch deck match the model exactly.
Lenders and investors test these points. See our business plan checklist for founders applying for a loan and our guide to getting fintech companies investor-ready.
A 10-minute check before you hit send
- Master check shows all clear in every scenario.
- No error values such as #REF! or #DIV/0! anywhere in the file.
- The scenario switch is set to base case and the date and version on the cover are current.
- Key outputs match the figures quoted in your email, plan or deck.
- BN registration and tax settings reflect the business as it stands today.
7. Interactive Model Error Risk Scorecard
Estimate how many errors your model may contain, based on its size and published error rates, and how many are likely to remain after review. Then tick the QA practices you already use. Results are illustrative estimates based on research averages, not a measure of your specific model.
QA practices in place
8. Organizing the Review
| Level | Who | When it fits |
|---|---|---|
| Self-review | The model builder, using a checklist | Every model, before sharing |
| Peer review | A colleague who didn't build it | Internal budgets and planning models |
| Independent review | An outside modeler or advisor | Loan applications, investor raises, major decisions |
| Formal model audit | A specialist audit team | Large project finance and transactions |
- Review with fresh eyes: builders tend to see what they intended, not what they wrote.
- Log every issue with its location, severity and fix.
- Re-run all checks after fixes, since corrections can introduce new errors.
- Follow a recognized standard, such as the ICAEW Financial Modelling Code or the FAST Standard, to make reviews faster.
9. Documentation, Version Control and CRA Tie-Outs
- Cover sheet: purpose, author, date, version and a summary of key assumptions.
- Version control: clear file names and a change log; never overwrite the last approved version.
- Lock and protect formula cells in versions shared outside the team.
- Tie history to CRA filings: historical revenue, HST and payroll should agree with returns filed under your nine-digit CRA business number.
- Check BN registration status: start-up models should reflect BN registration timing, including when HST and payroll accounts under your business number begin.
- Reconcile actuals monthly: our bookkeeping services produce the clean actuals that keep a forecast honest.
Common QA mistakes
- Checking only the outputs, not the formulas that produce them.
- Ignoring a check cell that shows a small difference "due to rounding."
- Letting the builder be the only reviewer.
- Updating the deck or plan without updating the model, or the other way around; our business plan services keep both in sync.
10. Frequently Asked Questions
What is a financial model review?
A financial model review is a structured check of a spreadsheet model to confirm that its formulas calculate correctly, its assumptions are reasonable and documented, its statements are properly linked and its outputs make sense. Reviews range from a self-check by the builder to an independent review or formal model audit, which is often required for large financings or transactions.
How do you check a financial model for errors?
Start with built-in integrity checks: the balance sheet should balance, cash on the balance sheet should match the cash flow statement, and subtotals should agree. Then review formulas for consistency across rows, look for hard-coded numbers inside formulas, trace key outputs back to inputs, test extreme scenarios and compare results with historical figures and industry benchmarks.
What are the most common errors in financial models?
Common errors include hard-coded numbers inside formulas, inconsistent formulas across a row, incorrect cell references after inserting rows, sign errors, mixing units such as thousands and dollars, omitted costs like taxes or loan payments, circular references, and outdated assumptions such as old tax or interest rates.
How often should a financial model be reviewed?
A model should be reviewed whenever it is built or significantly changed, before it is shared with lenders or investors, and when key assumptions such as tax rates, interest rates or pricing change. Models used for ongoing budgeting are often refreshed monthly or quarterly against actual results.
What is the ICAEW Financial Modelling Code?
The ICAEW Financial Modelling Code is a set of good-practice principles published by the Institute of Chartered Accountants in England and Wales. It covers model design, structure, formulas, checks and documentation, with the aim of making models easier to use, understand and review. Other common standards include the FAST Standard.
Summary
Research shows that most spreadsheets contain errors and that a single reviewer catches only about half of them. Good QA combines clear structure, consistent formulas, built-in integrity checks, documented assumptions, stress tests and an independent review. Tie historical figures to filings under your CRA business number, control versions carefully and use the scorecard to judge how much review your model needs before it reaches a lender or investor.
Get your model independently reviewed
Ledgerive reviews, repairs and rebuilds financial models for businesses across Canada, so the numbers you share with lenders and investors hold up. Book a free 30-minute call or reach us directly.
Sources: Panko, Spreadsheet Errors: What We Know. What We Think We Can Do; ICAEW, Financial Modelling Code; Ontario Ministry of Finance, Corporate income tax; CRA, Business number and program accounts.