What it does

This skill turns messy bank or card transactions into clean, categorised business expenses with a usable summary. Paste raw statement lines, a CSV export, or a typed list, and it codes every transaction into a sensible business expense category, flags personal spending, capital purchases and anything that needs review, and returns both a clear table and a live, formula-driven Excel workbook. Built for freelancers, sole traders and small companies anywhere in the world.

Why use this skill

Sorting a bank statement by hand is slow and error-prone, and a generic AI prompt will happily invent confident but wrong categories. This skill works to a structured, country-neutral chart of accounts with merchant and keyword hints, and—crucially—flags uncertain lines for review instead of guessing. It keeps transfers, tax payments and incoming money out of your expense totals so the numbers actually mean something, then builds a tidy workbook that recalculates itself when you correct a row.

Supported features

• Smart Categorisation: Assigns each transaction to a clear business expense category using merchant and context cues, not just single-keyword matching.
• Honest Flagging: Separates business vs. personal, marks capital purchases, and flags duplicates, missing receipts and anything it can't confidently place.
• Clean Totals: Keeps transfers, tax payments and income out of expense totals so your figures are trustworthy.
• Live Excel Workbook: Three linked tabs—Transactions (with correction dropdowns), Summary by Category, and Monthly Summary—all formula-driven.
• Works Anywhere: Country-neutral and macro-free; opens in Excel, Google Sheets, Apple Numbers and LibreOffice.

This is a categorising tool, not tax advice or bookkeeping. For Ireland-specific VAT, RCT and Revenue coding, see the Irish Expense Categoriser.