skills.rest
anthropics
anthropicsOFFICIAL
Explore all skills by this author →
WebsiteGitHub

audit-xls

Audit spreadsheet formulas and financial model integrity across ranges, sheets, or workbooks.

34.1k|5.1k|Updated Feb 23, 2026
Search Tags:#debugging#cash flow#balance sheet#financial model#spreadsheet audit#formula checking#excel qa
One-click install
npx skills add https://github.com/anthropics/financial-services-plugins --skill audit-xls
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: audit-xls
Source: https://github.com/anthropics/financial-services-plugins/tree/main/financial-analysis/skills/audit-xls
Command: npx skills add https://github.com/anthropics/financial-services-plugins --skill audit-xls

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill automates the process of auditing spreadsheets, identifying formula errors, inconsistencies, and potential model integrity issues, ensuring accuracy and reliability in financial models.

Core Features & Use Cases

  • Formula Auditing: Detects common formula errors like #REF!, #VALUE!, and hardcoded values.
  • Model Integrity Checks: Performs deep dives into financial models (DCF, LBO, 3-statement) for balance sheet accuracy, cash flow tie-outs, and logical consistency.
  • Scope Flexibility: Can audit a selected range, an entire sheet, or the whole workbook.
  • Use Case: Before submitting a critical LBO model to an Investment Committee, use this Skill to perform a full model integrity check to catch any balance sheet imbalances or cash flow tie-out errors.

Quick Start

Audit the entire active sheet for formula errors and model integrity.

Frequently Asked Questions about audit-xls

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I check my financial model for balance sheet balancing and cash flow errors?▼

Auditing spreadsheet model integrity detects balance sheet imbalances, cash flow tie-out errors, and logic inconsistencies in DCF, LBO, and 3-statement models to ensure financial accuracy and reliability.

Can I scan a spreadsheet for hardcoded values and inconsistent formulas?▼

Yes, spreadsheet formula auditing detects hardcoded values, inconsistent formulas, off-by-one ranges, circular references, unit mismatches, hidden rows, and errors like #REF! and #VALUE!.

What is the best way to audit only a selected range of a financial spreadsheet?▼

Spreadsheet auditing offers scope flexibility, allowing you to target a selected range, a single sheet, or the entire workbook to validate formula accuracy and model integrity.

How do I find hidden rows and tabs in an Excel financial model?▼

Running a full spreadsheet audit validates formula integrity and detects hidden rows, hidden tabs, unit mismatches, and hardcoded values to ensure complete model accuracy.

Does spreadsheet formula checking work for LBO and DCF models?▼

Yes, spreadsheet formula checking performs deep model integrity checks specifically for DCF, LBO, and 3-statement models, validating logical consistency, balance sheet accuracy, and cash flow tie-outs.

Why does my balance sheet not balance after updating formulas?▼

Your balance sheet may not balance due to formula errors, hardcoded values, circular references, or off-by-one ranges; auditing the spreadsheet detects these issues and validates model integrity.

Related Skills

Explore More Finance & Accounting Skills→
davpatel605-beepdavpatel605-beep

3-statement-model

Build integrated three-statement financial models with linked Excel formulas and validation checks.

Community
Advanced
anthropicsanthropics
34.1k

Investment Committee Memo

Generate structured Investment Committee memos for private equity deal approval.

Official
Advanced
InverterNetworkInverterNetwork

excel-author

Generate auditable financial workbooks with openpyxl and strict modeling conventions.

Official
Advanced
cwstedctwcwstedctw

3-statement-model

Link income statement, balance sheet, and cash flow with Excel formulas.

Community
Advanced