audit-xls
Audit a spreadsheet for formula accuracy, errors, and common mistakes. Scopes to a selected range, a single sheet, or the entire model (including financial-model integrity checks like BS balance, cash tie-out, and logic sanity). Triggers on "audit this sheet", "check my formulas", "find formula errors", "QA this spreadsheet", "sanity check this", "debug model", "model check", "model won't balance", "something's off in my model", "model review".
Best for Financial model auditorsWorks with GitHubHigh risk
⌘source
- author
@anthropics- language
- Python
★11kstars
1.5kforks
May 5, 2026
✦overview.md
Key Features
- ·Scoped auditing (selection/sheet/model)
- ·Formula error detection
- ·Hardcode flagging inside formulas
- ·Inconsistent formula checks across ranges
- ·Full financial-model integrity checks (BS, cash tie-out)
Use Cases
- →Audit a selected range for formula errors and hardcoded values
- →Check an entire sheet for inconsistent formulas and common mistakes
- →Run a full model integrity audit before sending to a client
- →Diagnose why a model won't balance with BS and cash tie-out checks
Best for
- ✓Financial model auditors
- ✓Spreadsheet QA
- ✓Investment banking teams
Not ideal for
- !Simple single-use spreadsheets
- !Non-formula based audits
FAQs
name
audit-xls
description
Audit a spreadsheet for formula accuracy, errors, and common mistakes. Scopes to a selected range, a single sheet, or the entire model (including financial-model integrity checks like BS balance, cash tie-out, and logic sanity). Triggers on "audit this sheet", "check my formulas", "find formula errors", "QA this spreadsheet", "sanity check this", "debug model", "model check", "model won't balance", "something's off in my model", "model review".
Audit Spreadsheet
Audit formulas and data for accuracy and mistakes. Scope determines depth — from quick formula checks on a selection up to full financial-model integrity audits.
Step 1: Determine scope
If the user already gave a scope, use it. Otherwise ask them:
What scope do you want me to audit?
- selection — just the currently selected range
- sheet — the current active sheet only
- model — the whole workbook, including financial-model integrity checks (BS balance, cash tie-out, roll-forwards, logic sanity)
The model scope is the deepest — use it for DCF, LBO, 3-statement, merger, comps, or any integrated financial model before sending to a client or IC.
Step 2: Formula-level checks (ALL scopes)
Run these regardless of scope:
| Check | What to look for |
|---|---|
| Formula errors | #REF!, #VALUE!, #N/A, #DIV/0!, #NAME? |
| Hardcodes inside formulas | =A1*1.05 — the 1.05 should be a cell reference |
| Inconsistent formulas | A formula that breaks the pattern of its neighbors in a row/column |
| Off-by-one ranges | SUM/AVERAGE that misses the first or last row |
$install
1-click copynpx skills add anthropics/financial-services --skill audit-xlsSafety assessment
★
Clarity score
How clear and easy to understand the SKILL.md instructions are, rated from 1 to 5.
4/ 5
very goodClear and well structured, with only minor parts that might need a second read.
◎
Actionability score
How directly an agent can act on the SKILL.md instructions, rated from 1 to 5.
4/ 5
highMostly actionable with clear steps; only a few small gaps remain.