Skip to content
SkillReady to runFinance

Expense Categorization

Written in-house · editorially graded

Every SkillsBank offering is written in-house — never scraped or crowd-sourced — and graded against a fixed editorial rubric in a separate grading step.

Dry-run test passed · Jun 15, 2026

Trigger check passed

Editorially graded · Jun 15, 2026

Transforms a raw transaction file (CSV or XLSX) into a professionally formatted Excel workbook with GL/budget categories, confidence tiers, review flags, and a category summary sheet. Use when a finance, accounting, or bookkeeping professional needs to categorize a batch of transactions against a chart of accounts or standard expense taxonomy — at month-end close, before a bookkeeper handoff, ahead of an ERP import, or during audit prep.

What you get

An installable SKILL.md file for your AI assistant. Produces an Excel workbook (.xlsx).

Works in
Claude Code · Cursor
Native — drops into .claude/skills/
Copilot · Codex · Gemini CLI
Native — reads .agents/skills/
claude.ai — web & desktop
Upload the .zip in Customize → Skills
ChatGPT
Via a Project — paste into its instructions

See it in action

A real input → output sample

Sample input
Here are my March credit card transactions. Please categorize them for my bookkeeper. I don't have a chart of accounts or anything fancy — just the standard stuff.
Date,Description,Amount
2024-03-01,SQ *AMAZON WEB SERVICES ALEXANDRIA,47.23
2024-03-02,DOORDASH #9876 SAN FRANCISCO,32.50
2024-03-03,MARRIOTT BONVOY BILLING,0.00
2024-03-04,VERIZON WIRELESS 5551234567,185.00
2024-03-05,ACH CREDIT ORIG CO NAME:STRIPE PAYOUTS,1250.00
2024-03-06,HOME DEPOT #0412,156.78
2024-03-07,THE UPS STORE #3345,22.40
2024-03-08,ADP TOTALSOURCE /,5842.00
2024-03-09,UBER EATS *EAT STREET,18.99
2024-03-10,COSTCO WHOLESALE #123,210.50
Sample output
Sample Excel output produced by the Expense Categorization skill
Produced by an AI assistant following this skill on the sample input above.
View the full output as text
Example Output
Transactions processed: 10
High confidence: 3 | Medium: 4 | Low: 3 | Flagged for review: 7
Estimated accuracy on unflagged rows: 85–95% (industry benchmark for automated categorization).
--- Categorization Summary ---
Category Summary (% is share of expense outflows; the Stripe ACH credit is an inflow, excluded from the expense total):
| Category | Transaction Count | Total Amount | % of Expense Outflows | Flagged for Review |
|---|---|---|---|---|
| Payroll | 1 | $5,842.00 | 89.7% | 0 |
| Office Supplies | 1 | $210.50 | 3.2% | 1 |
| Utilities | 1 | $185.00 | 2.8% | 0 |
| Equipment | 1 | $156.78 | 2.4% | 1 |
| Meals & Entertainment | 2 | $51.49 | 0.8% | 1 |
| Software & Subscriptions | 1 | $47.23 | 0.7% | 1 |
| Office Supplies (Shipping) | 1 | $22.40 | 0.3% | 1 |
| Other/Uncategorized | 1 | $0.00 | 0.0% | 1 |
| **Total expense outflows** | **9** | **$6,515.40** | **100.0%** | **6** |
| Transfer / Non-Expense (Stripe payout) | 1 | $1,250.00 | — (inflow) | 1 |
| **Grand total (all rows)** | **10** | **$7,765.40** | — | **7** |

Honest note: the Marriott $0.00 line looks like an authorization hold, not a completed charge; the Stripe ACH credit is an inflow, not an expense, and is excluded from the expense total. Flagged rows need owner confirmation before filing.

Related