FIELD GUIDE 01 · MODEL AUDIT

Audit the model before the model audits you.

A Claude for Excel workflow for tracing formulas, exposing hard-coded overrides, and checking the three statements—without turning the model into a black box.

8audit prompts
6integrity checks
1review pass
Model integrityReview copy · FY26 plan
Balance sheet tiesTIES
Hard-coded values12 FLAGGED
Sign conventions2 EXCEPTIONS
Circular references0
Formula consistencyREVIEW
REVIEWED

What breaks a financial model

A model does not fail loudly. It fails in a hard-coded cell, a flipped sign, or a link that quietly stopped working three versions ago.

The audit workflow makes those assumptions visible. Ask Claude to map the workbook, trace the logic, and stress the drivers. You still make the call; Claude gives you a trail to review.

01

Hard-coded overrides

A growth rate or margin typed into a formula breaks the link between assumptions and outputs.

02

Sign flips

Capex entered as a positive number or costs added instead of subtracted changes the cash flow without an error.

03

Broken roll-forwards

A balance-sheet line stops tying to its schedule, and every downstream check inherits the gap.

Financial model audit prompts

Copy a prompt into Claude in Excel, then replace the cell references with your own workbook. Start with a clean copy and review every flag.

01AUDIT

Audit Formula Consistency

Audit the formulas in the selected range. Flag inconsistent patterns, mixed absolute and relative references, hard-coded overrides, and formulas that do not follow the workbook's established logic. Group issues by severity and suggest a consistent replacement formula.

Find mixed patterns and manual overrides.

02INTEGRITY

Find Hard-Coded Values

Scan the selected model for hard-coded numbers inside formulas. For each one, identify the cell, the formula, and the assumption it should reference. Rank by risk and suggest a linked replacement.

Expose numbers that should be linked to assumptions.

03SIGNS

Check Sign Conventions

Check the selected financial model for sign-convention inconsistencies. Flag costs entered as positive values, cash outflows with the wrong sign, and subtotals that add or subtract the wrong rows. Explain the likely impact on the statements.

Catch flipped costs and cash outflows.

04STATEMENTS

Reconcile the Three Statements

Reconcile the three financial statements in this workbook. Check net income to retained earnings, cash flow to the balance sheet cash line, and debt and interest links. List every break with the cell references and the likely cause.

Trace every break to its cell path.

05LOOPS

Find Circular References

Identify circular references in the workbook, trace the loop step by step, and explain how to resolve it. Prefer a copy-paste-values or iterative-calculation fix only when appropriate, and warn about the trade-offs.

Understand the loop before you fix it.

06ASSUMPTIONS

Stress-Test Key Assumptions

List the five most optimistic assumptions in this model. For each one, show the cell reference, the current value, a conservative alternative, and the impact on revenue, EBITDA, and cash runway. Use a table.

Quantify the optimistic cases.

07BALANCE

Check Balance Sheet Integrity

Audit the balance sheet for integrity. Check assets equal liabilities plus equity, retained earnings roll-forward, debt schedule ties, and working-capital roll-forwards. Report every break and the cell path that causes it.

Verify the balance sheet ties to its schedules.

08ERRORS

Scan for Spreadsheet Errors

Scan the workbook for #REF!, #VALUE!, #DIV/0!, #N/A, and #NAME? errors. For each error, identify the root cause, the affected downstream cells, and a safe fix. Summarize the results by severity.

Catch error values and broken links.

How to audit a financial model with Claude in Excel

A review pass should leave a trail: what was checked, what changed, and what still needs a human decision.

  1. 01

    Map the workbook

    Ask Claude to summarize the tabs, input cells, outputs, and calculation spine. Save the map.

    Deliverable: Workbook map
  2. 02

    Trace the logic

    Run formula consistency and hard-coded value checks. Ask for cell-level citations and severity.

    Deliverable: Exception list
  3. 03

    Stress the drivers

    Change one assumption at a time. Compare revenue, EBITDA, and cash runway.

    Deliverable: Scenario note
  4. 04

    Sign off

    Review changes, document exceptions, and keep a clean copy with a review date.

    Deliverable: Review memo

The pre-flight checklist

Run these checks before the model goes to a board meeting, an investor, or a lender.

Balance sheet ties

Assets equal liabilities plus equity in every period.

No silent overrides

Formula inputs link to the assumption table.

Signs are consistent

Costs and outflows follow one convention.

No circular references

Interest and debt loops are resolved or documented.

Assumptions are documented

Every driver has a source, owner, and date.

Outputs are reviewed

A second person has checked the summary and cash flow.

Financial model audit FAQ

Practical answers before you point Claude at a live model.

Can Claude audit a 40-tab financial model?

Claude can read the workbook and cite cells, but start with a copy and ask for a map first. Very large models take longer; break the audit into tabs or ranges and review every finding.

Does Claude replace a human model audit?

No. It accelerates tracing, flagging, and documentation. It is not recommended for audit-critical calculations or final client deliverables without human review.

Can Claude find hard-coded values?

Yes. Ask it to scan formulas for hard-coded numbers and rank them by risk. Verify each flag before changing the model.

Does Claude work with models that use macros or VBA?

No. Claude for Excel does not support macros/VBA or data tables. Use it for formula-based models and ranges, then review the output.

What should I check first?

Start with balance-sheet ties, hard-coded overrides, and sign conventions. Those three checks catch many of the errors that make a model look finished but produce the wrong answer.

Can Claude make changes to the model?

Yes, with your confirmation. It warns before overwriting data. Keep a clean copy and review every change before saving or sharing.

THE NEXT MOVE

Take the prompts into your workbook.

Start with the six prompts above, then explore the full library for formulas, dashboards, audits, and forecasts. Download the PDF for a printable field guide.