How to Audit Your Financial Model Before Sharing It With Investors
A financial model that has not been audited before it goes to investors is a liability. Errors, inconsistencies, and broken links that you did not catch will be caught in diligence --- at the worst possible time. A pre-share audit takes two to three hours and eliminates the most common model credibility killers: circular references, non-reconciling cash balances, hard-coded assumptions, and internal inconsistencies across tabs.
Author: Yanni Papoutsi · Fractional VP of Finance and Strategy for early-stage startups · Author, *Raise Ready*
Published: 2025-03-08 · Last updated: 2025-03-08
Reading time: \~7 min
Why Auditing Your Own Model Matters
Founders who share unaudited models make a specific kind of mistake. The model goes to a diligence analyst who finds a formula error on the revenue tab, a cash balance that does not reconcile to the P&L, or an assumption that is inconsistent across two different tabs. The technical error may be minor. The signal it sends is not.
A model error tells an investor one or more of the following: the founder has not reviewed this themselves, the numbers should not be trusted at face value, there may be other errors not found yet. None of these are the signal you want to send when someone is deciding whether to write a check.
Audit checklist summary:
Structural | Circular references, broken links, error 20 min integrity | values
Mathematical | P&L to cash flow reconciliation, balance 30 min consistency | sheet balance
Assumption | All key inputs in one place, no | 30 min centralisation | hard-coding
Internal | Headcount plan matches costs, revenue | 30 min consistency | builds match summary
Logic review | Growth rates credible, margins trend | 30 min correctly, no sign errors
Step 1: Structural Integrity Check
Before reviewing any numbers, verify the model's structural health. Circular references: A circular reference occurs when a formula refers back to its own cell, directly or through a chain of references. Excel will flag these with a warning. They should be eliminated or, if intentional (e.g. in an interest model), explicitly documented. Circular references in unintended places are a sign the model has not been reviewed.
Broken links: If the model references external files, check whether those links are live. Broken external links return errors that cascade through dependent formulas.
Error values: Scan every tab for #REF!, #VALUE!, #DIV/0!, and #NAME? errors. These indicate broken formulas. Address each one before the model leaves the building.
Tool: Excel's Formulas > Error Checking function surfaces all errors in the active sheet. Run it on every tab.
Step 2: Mathematical Consistency
The most important mathematical check is the three-statement reconciliation: the P&L, the cash flow statement, and the balance sheet must tie together.
The cash reconciliation test: The ending cash balance in the cash flow statement must match the cash line on the balance sheet for every period. If they diverge, there is an error somewhere in the model structure.
The retained earnings test: The cumulative net income from the P&L must match the change in retained earnings on the balance sheet. If they do not reconcile, equity movements have not been captured correctly. The P&L to operating cash flow bridge: Starting from net income, the bridge to operating cash flow must account for all non-cash items (depreciation, SBC) and working capital movements. The bridge should reconcile exactly.
Key insight: A model that passes the three-statement reconciliation test has almost certainly been built correctly in structure, even if individual assumptions are wrong. A model that fails it has a structural error that will be found in diligence.
Step 3: Assumption Centralisation
Every key assumption in the model should live in exactly one place: the assumptions tab. When reviewing the model before sharing, the test is straightforward: open the assumptions tab, find the CAC assumption, and trace the formula chain from that assumption cell through to the revenue model.
If the formula chain breaks --- if you find the CAC value hard-coded somewhere else in the model, or if the number in the model differs from the assumptions tab --- you have found a centralisation failure. These failures mean that changing an assumption in one place does not change it everywhere, which produces inconsistencies that analysts find during diligence.
What to look for:
Any numeric constants in formula cells that should be references to
the assumptions tab
Assumptions that appear in multiple places with slightly different
values
Key inputs that are not in the assumptions tab at all
Step 4: Internal Consistency
Internal consistency means the model tells one coherent story across all tabs. Inconsistencies --- where the headcount plan does not support the revenue assumptions, or the gross margin calculation uses different COGS than the P&L --- are often more damaging than simple formula errors because they suggest the model was assembled rather than designed. Key consistency checks:
Headcount to revenue: If revenue grows 3x, does headcount grow enough to support that? If the model shows headcount flat while revenue triples, either the model assumes the product scales with no marginal operational support (which needs explicit justification) or the headcount plan has not been connected to the revenue model. COGS consistency: Does the COGS build on the gross margin tab match the COGS line on the P&L? These should be the same formula, not separate calculations.
Revenue bridge: Does the revenue from the detailed revenue build match the revenue line on the P&L? This sounds obvious but is frequently wrong in models assembled from multiple sources.
Step 5: Logic Review
The final audit step is a logic review --- reading the model as an investor would and asking whether each assumption and output is credible.
Growth rate credibility: Is the growth rate in year one consistent with current traction? Is the growth rate in year five credible given the market size and the competitive environment? Investors who see hockey-stick models with no explanation of what changes in year two will ask.
Margin trajectory: Does gross margin improve over time, and is the mechanism explained? Does operating leverage appear in the model (OpEx growing slower than revenue at scale)?
Sign checks: Revenue should be positive. Costs should be negative (or shown as positive in a cost-only view, consistently). Mixed sign conventions are a common source of confusion and errors.
Runway check: Does the cash runway calculation use the cash flow statement or the P&L? It must use cash flow. A runway number derived from the P&L is wrong for any business with working capital.
The 90-Minute Audit in Practice
The full audit described above takes two to three hours for a complex model. For a standard early-stage model, a focused 90-minute audit covers the most important ground:
1. Run error checking on every tab (20 min)
2. Verify cash reconciliation (15 min)
3. Test assumptions centralisation on five key inputs (20 min) 4. Check headcount-to-revenue and COGS-to-P&L consistency (20 min) 5. Read the model as an investor: does the story make sense? (15 min) This is the minimum before the model goes to any serious investor.
Frequently Asked Questions
Should someone else audit the model or is self-auditing sufficient?
Self-auditing catches most structural and formula errors. A second review by someone who did not build the model catches logic errors and internal inconsistency that the original builder is too close to see. If possible, have a trusted advisor or financial professional review the model before it goes to a lead investor.
How do you handle intentional circular references?
Document them explicitly in the assumptions tab or a notes cell adjacent to the reference. Describe why the circular reference exists and what it is calculating. This prevents analysts from treating it as an error and gives them context for the design decision.
What is the most common error found in startup financial models?
Hard-coded assumptions that diverge from the assumptions tab after the model is updated. This happens when the model is revised in response to investor feedback but some cells are updated manually rather than through the central assumptions. The fix is centralisation from the start.
Summary
Auditing a financial model before sharing it is not optional. It is the final step between building a model and using it as an instrument for raising capital. The five checks --- structural integrity, mathematical consistency, assumption centralisation, internal consistency, and logic review --- take less than three hours and eliminate the most common model credibility killers. A model that passes this audit does not guarantee a successful raise. But a model that fails it in diligence can stop one.
Get the complete guide with all 16 chapters, exercises, and model templates.
Get Raise Ready - $9.99