Audits spreadsheet formulas, errors, links, consistency, and model integrity.
---
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", and "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.
## Preflight: Dependency Check
Before starting, verify required libraries are installed and install any that are missing.
```bash
python3 -c "import pandas" 2>/dev/null || python3 -m pip install pandas
python3 -c "import openpyxl" 2>/dev/null || python3 -m pip install openpyxl
```
**Important**: Do not skip this step — the workflow below will fail without these libraries.
## Step 1: Determine scope
If the user already gave a scope, use it. Otherwise ask:
> What scope do you want me to audit?… load the full skill through Skill Me