Process financial documents and generate a comprehensive, beautiful HTML report with subscription audits, expense categorization, bookkeeper cross-referencing, and actionable insights.
When to Use This Skill
- End of year financial review
- Monthly bookkeeping catch-up
- Subscription audit (find what to cancel)
- Preparing documents for your accountant
- Cross-referencing bookkeeper work against raw statements
- Understanding where your money is going
- Flagging personal expenses on business cards
What This Skill Produces
A single, self-contained HTML report with:
- Executive Dashboard — KPI cards with revenue, expenses, profit, cash position
- Monthly Spending Trend — Visual bar chart of monthly spend
- Expense Categories — Horizontal bar breakdown by category
- Subscription Audit — Every recurring charge with monthly/annual cost and keep/review/cancel verdict
- Contractor Summary — Who got paid what, when, and for what
- Revenue Sources — Where income comes from with concentration risk flags
- Bookkeeper Categorization Audit — Flags miscategorized expenses (if bookkeeper data provided)
- Personal Expense Flags — Items on business card that should be personal draws
- Cash Dividend / Owner Draw Tracker — Monthly visualization
- Tax Position — Outstanding items, refunds owed, payables
- Year-over-Year Comparison — If prior year data available
How to Use
Step 1: Gather Your Documents
Create a folder with your financial documents. The skill works with:
Bank Statements (PDF or CSV)
- Checking/chequing account statements
- Credit card statements
- Multi-currency accounts (Wise, PayPal, etc.)
Invoices (PDF)
- Contractor invoices
- Vendor receipts
- Payment confirmations
Bookkeeper Files (optional but powerful)
- Profit & Loss statement (PDF)
- Balance Sheet (PDF)
- General Ledger (XLSX/CSV)
- Trial Balance (PDF)
Step 2: Tell Claude Where to Find Them
/accounting
My financial docs are in ~/Documents/Accounting/2025/
- Bank statements in /Statements/
- Credit card statements in /Credit Card/
- Invoices in /Invoices/
- Bookkeeper package: ~/Downloads/financials.pdf
- General ledger: ~/Downloads/general-ledger.xlsx
Or for a quick subscription audit:
/accounting
Just audit my subscriptions from these credit card statements:
~/Documents/CC-Statements/
Step 3: Get Your Report
The skill generates a single HTML file you can open in any browser. No dependencies, no server needed.
Instructions
When the user triggers this skill, follow this workflow:
Phase 0: First-Time Setup
Check if ~/.claude/skills/accounting/config.json exists.
If it exists: Load settings and proceed to Phase 1.
If it does NOT exist:
-
Greet the user:
Welcome to /accounting! Let's do a quick setup. This takes 30 seconds and only happens once. -
Ask for:
- Business name (for the report header)
- Business entity type (Corporation, Sole Prop, LLC, etc.)
- Primary currency (USD, CAD, EUR, GBP, etc.)
- Fiscal year end (Dec 31, Mar 31, etc.)
-
Save to
~/.claude/skills/accounting/config.json:{ "businessName": "Acme Corp", "entityType": "Corporation", "currency": "USD", "fiscalYearEnd": "Dec 31", "setupComplete": true, "setupDate": "2026-04-01" } -
Confirm and proceed:
Setup complete! Running /accounting now...
Phase 1: Discovery
- Locate all financial documents in the folder(s) the user specified
- Identify document types — bank statements, credit card statements, invoices, bookkeeper files
- Report what you found before processing:
Found: - 12 bank statements (PDF, Jan-Dec) - 12 credit card statements (PDF, Jan-Dec) - 28 invoices across 9 months - 1 bookkeeper P&L (PDF) - 1 general ledger (XLSX, 2100+ rows) Processing all of these. This will take a few minutes.
Phase 2: Data Extraction
Process all documents in parallel where possible using Agent subagents:
Bank Statements
- Read every page of every PDF
- Extract: date, description, withdrawal, deposit, balance
- Handle multiple account types on same statement
- Handle French/English bank formats (Desjardins, TD, RBC, BMO, Chase, BofA, Wells Fargo, etc.)
- Handle CSV exports from online banking
Credit Card Statements
- Read every page — statements are often 3+ pages
- Extract: transaction date, posting date, vendor name, amount
- Handle multiple cards on same statement
- Identify credits/refunds (marked CR or negative)
- Capture statement-level totals for cross-checking
Invoices
- Read page 1 of each PDF
- Extract: date, invoice number, vendor, line items, subtotal, tax, total, currency
- Handle various invoice formats (formal invoices, transfer confirmations, receipts)
Bookkeeper Data (if provided)
- Parse P&L for official revenue, expense categories, and profit
- Parse Balance Sheet for cash position, liabilities, equity
- Parse General Ledger (XLSX) for transaction-level detail:
- Extract all account categories (the "Split" or "Account" column)
- Sum by category
- Identify what's in each category for the audit
Phase 3: Analysis
Transaction Categorization
Assign every credit card transaction to a category based on vendor name patterns:
| Pattern | Category |
|---|---|
| HIGHLEVEL, GOHIGHLEVEL | CRM |
| SLACK, ZOOM, GSUITE, GOOGLE*WORKSPACE, TEAMS | SaaS - Communication |
| STRIPE, PAYPAL, SQUARE | Payment Processing |
| FACEBOOK, FACEBK, INSTAGRAM, META, GOOGLE*ADS | Advertising |
| OPENAI, CLAUDE.AI, ANTHROPIC, MIDJOURNEY | AI Tools |
| SPOTIFY, NETFLIX, YOUTUBE PREMIUM, APPLE.COM/BILL | Personal - Entertainment |
| GYM, ATHLETIC, FITNESS, PELOTON | Personal - Fitness |
| UBER, LYFT, AIRBNB, AIRLINE, HOTEL | Travel |
| AMAZON | Review Individually |
| GODADDY, NAMECHEAP, CLOUDFLARE | Domains / Hosting |
| CANVA, ADOBE, FIGMA | Design Tools |
| ZAPIER, MAKE.COM | Automation |
| QUICKBOOKS, XERO, FRESHBOOKS | Accounting Software |
| MAILCHIMP, CONVERTKIT, ACTIVECAMPAIGN | Email Marketing |
| SHOPIFY, WOOCOMMERCE | E-Commerce |
| AWS, GOOGLE CLOUD, AZURE, HEROKU, VERCEL | Cloud / Infrastructure |
Build a vendor mapping as you go — learn from the data. When you encounter a vendor not in this table, categorize it based on context clues in the description.
Subscription Detection
A charge is a subscription if:
- Same vendor appears 3+ months
- Amount is within 20% of average (allows for FX fluctuation)
- Not a one-time purchase
For each subscription, calculate:
- Average monthly cost
- Annual total
- Number of months active out of 12
- Trend (increasing, decreasing, stable)
Subscription Verdicts
Assign each subscription a verdict:
- Keep — Core business tool, actively used, no overlap
- Review — Expensive (>$100/mo), overlapping with another tool, or unclear value
- Cancel — Redundant (e.g., Zapier AND Make.com), barely used, or clearly not needed
- New — Started in last 3 months, too early to judge
Rules for verdicts:
- If two tools overlap in function, flag the less-used or more expensive one as Cancel
- If a tool costs >$100/mo, default to Review unless it's clearly core (CRM, email, main platform)
- Gym, entertainment, personal items should be flagged as personal, recommend moving to personal card
- AI tools that overlap — review which ones are actually being used vs. forgotten
Bookkeeper Cross-Reference (if GL provided)
This is the most valuable part. Compare the bookkeeper's categorization against what the raw data actually shows:
- For each expense category in the P&L, pull the underlying transactions from the GL
- Check if vendors are in the right category:
- Is a SaaS platform categorized as "Training"?
- Are contractor payments categorized as "Travel"?
- Are personal expenses mixed into business categories?
- Are recurring subscriptions categorized as one-time expenses?
- Flag any category where >20% of the amount seems miscategorized
- Calculate the corrected P&L if miscategorizations were fixed
- Explain the tax risk of each miscategorization (inflated deductions, audit flags, etc.)
Personal Expense Detection
Flag transactions that appear personal on a business card:
- Gym/fitness memberships
- Entertainment subscriptions (Spotify, Netflix, etc.)
- Clothing stores
- Medical expenses
- Personal travel (hotels, airlines without business context)
- Food delivery / restaurants (unless clearly client meetings)
- Personal grooming / dry cleaning
Revenue Analysis (if data available)
- Identify revenue sources from bank deposits, Wise/PayPal incoming, etc.
- Calculate concentration (what % comes from top source)
- Flag if >50% from single source (concentration risk)
- Show revenue trend by month
- Compare to prior year if available
Phase 4: Report Generation
Generate a single self-contained HTML file with these design requirements:
Design Standards
- Dark theme (bg: #0a0e17, cards: #111827)
- Font: Clash Display (headings) + JetBrains Mono (numbers)
- Load from Google Fonts via
<link>tag - Accent color: cyan (#22d3ee) with warm amber (#f59e0b) and green (#10b981)
- No purple gradients on white backgrounds
- Atmospheric backgrounds with subtle gradients
- CSS-only animations (staggered card reveals)
- Fully responsive (mobile-friendly grid)
- Self-contained — no external JS dependencies
Report Sections (in order)
- Header — Business name, date range, entity info
- KPI Cards — 4-8 cards with key metrics (revenue, profit, expenses, subscriptions, cash, dividends, tax position)
- Monthly Spending Trend — Bar chart (pure CSS/HTML, no JS library needed)
- Expense Category Breakdown — Horizontal bar chart with amounts
- Subscription Audit Table — Full table with service, category, monthly cost, annual cost, months active, verdict badge (Keep/Review/Cancel/New)
- Subscription Savings Summary — Two boxes: "Recommended Cancellations" (with total savings) and "Worth Reviewing" (with potential savings)
- Contractor/Invoice Summary — Table of vendors, services, invoice counts, totals, active periods
- Revenue Sources — If data available, horizontal bar chart of income sources with concentration risk flag
- Official P&L + Year-over-Year — If bookkeeper data provided, show official P&L with YoY comparison
- Bookkeeper Categorization Audit — If bookkeeper data provided, flag miscategorized expenses with corrected amounts
- Contractor Deep Dive — Full breakdown of contractor payments with amounts, payment counts, active periods
- Personal Expense Flags — Table of items that should be reclassified as personal draws
- Cash Dividend/Owner Draw Tracker — Monthly grid visualization with total and average
- Tax Position — Cards for outstanding tax items (refunds owed, payables, GST/HST position)
- Key Insights & Recommendations — 4-6 insight/alert cards with actionable advice
- Footer — Generation date, sources used, disclaimer
Styling Details
Status badges for subscription verdicts:
- Keep: green background (#10b981), green text
- Review: amber background (#f59e0b), amber text
- Cancel: red background (#ef4444), red text
- New: purple background (#a78bfa), purple text
Category pills with colored backgrounds matching the category.
Amount formatting:
- Green for positive/income
- Red for large expenses or losses
- Amber for medium concern
- Cyan for neutral highlights
Use font-family: 'JetBrains Mono', monospace for all numbers and amounts.
Tables should have:
- Hover effect on rows
- Alternating subtle backgrounds
- Sticky headers on long tables
- Sort-friendly column alignment
Phase 5: Delivery
- Save the HTML report to the user's specified folder or
~/Documents/Accounting/[year]-annual-report.html - Open it in the browser with
open(macOS) orxdg-open(Linux) command - Provide a concise summary of key findings:
- Total revenue and profit (if available)
- Number of subscriptions found and total annual cost
- Potential savings from recommended cancellations
- Number of bookkeeper issues flagged (if applicable)
- Personal expenses that need reclassification
- Any critical alerts (concentration risk, tax issues, etc.)
Multi-Currency Handling
- Track transactions in their original currency
- Note currency for each amount in the report
- Don't convert currencies — the user's accountant handles that
- If statements have multiple currencies, show each separately
- Note exchange gain/loss if visible in the data
Statement Format Support
The skill handles these common formats:
Canadian Banks (often French)
- Desjardins (Caisse) — "RELEVE DE COMPTE", "CARTE AFFAIRES VISA"
- TD Canada Trust
- RBC Royal Bank
- BMO Bank of Montreal
- Scotiabank
- CIBC
US Banks
- Chase
- Bank of America
- Wells Fargo
- Citi
- Capital One
UK/EU Banks
- Barclays
- HSBC
- Revolut
- N26
International / Fintech
- Wise (TransferWise) statements
- PayPal statements
- Stripe payouts
- Mercury
- Relay
CSV/Excel
- Any CSV with date, description, amount columns
- QuickBooks exports
- Xero exports
- Wave exports
- FreshBooks exports
Error Handling
- If a PDF can't be read, note it in the summary and continue with others
- If a transaction can't be categorized, put it in "Uncategorized" and flag for manual review
- If the bookkeeper GL has unexpected columns, try to detect the right ones by looking for date, description, and amount patterns
- Always show what was processed vs skipped in the final summary
- If no statements are found in the specified folder, ask the user to confirm the path
Examples
Example 1: Full Year-End Review
/accounting
Process my 2025 financials:
- Bank statements: ~/Accounting/2025/Bank/
- Credit card: ~/Accounting/2025/CC/
- Invoices: ~/Accounting/2025/Invoices/
- Bookkeeper P&L: ~/Downloads/2025-PnL.pdf
- General Ledger: ~/Downloads/general-ledger.xlsx
Example 2: Quick Subscription Audit
/accounting
Just find all my subscriptions and tell me what to cancel.
Credit card statements are in ~/Downloads/CC-2025/
Example 3: Bookkeeper Verification
/accounting
My bookkeeper sent me the year-end package. I want to cross-reference
their categorization against my raw bank statements to make sure
everything is categorized correctly.
Bookkeeper files: ~/Downloads/2025-financials.pdf
Raw statements: ~/Accounting/2025/
Example 4: Monthly Check-In
/accounting
Process just March 2025:
- Bank statement: ~/Downloads/march-2025.pdf
- Credit card: ~/Downloads/cc-march-2025.pdf
Example 5: Multi-Currency Business
/accounting
I receive payments in USD via Wise and spend in CAD and EUR.
- Wise statements: ~/Accounting/Wise/
- Canadian bank: ~/Accounting/TD/
- Credit card: ~/Accounting/Visa/
- Invoices: ~/Accounting/Invoices/
Tips for Best Results
- PDF statements work better than screenshots — text extraction is more reliable
- CSV exports are fastest — if your bank offers CSV downloads, use those
- Organize by type — separate bank statements, CC statements, and invoices into different folders
- Include the bookkeeper package — the cross-reference audit is the most valuable feature
- Run it quarterly — don't wait until year-end to catch issues
- Keep the HTML report — it's a useful reference for tax meetings with your accountant
- Name your files consistently —
YYYY-MMformat helps the skill process them in order
What This Skill Does NOT Do
- File your taxes
- Replace a CPA or bookkeeper
- Connect to your bank directly (no Plaid/API integration)
- Guarantee categorization accuracy (always review with your accountant)
- Handle payroll calculations
- Generate T4s, W2s, 1099s, or tax forms
- Provide tax advice (consult a professional)
Built by @tenfoldmarc. Follow for daily AI automation builds — real systems, not theory.