Categorizing Bank Transactions: A Practical Workflow
A practical workflow for how to categorize bank transactions — build a scheme, apply rules, review the gaps, and stay consistent month to month.
Categorize bank transactions for free. Paste or upload transactions, apply keyword rules to sort them into categories, edit, and export a clean CSV.
Sort a list of bank transactions into spending categories without tagging each row by hand. Paste or upload your transactions and the categorizer matches descriptions against keyword rules — so "UBER", "SHELL", and "WHOLE FOODS" land in Transport, Fuel, and Groceries automatically. Review the suggestions, fix anything that looks off, then export a labelled CSV.
A categorized transaction list turns a raw statement into something you can actually read. Use it to build a monthly budget, separate business expenses from personal ones, prepare figures for tax time, or check where the money went last quarter. Because the rules are editable, the categories stay consistent month to month instead of drifting every time you re-sort by hand.
The categorizer works on transactions you already have in text or spreadsheet form. If your statement is still a PDF, run it through the free bank statement converter first to pull out the dates, descriptions, and amounts as clean rows, then bring those rows here to categorize them.
Manual tagging is fine for a handful of rows but gets tedious — and inconsistent — once you have hundreds. Keyword rules apply the same logic to every transaction, so similar merchants always get the same label. You stay in control: nothing is locked in, and you can override any suggestion before exporting.
Want to understand the approach behind the categories first? Read how to categorize bank transactions for a walkthrough of common category structures and keyword strategies. Prefer to stay in a spreadsheet? See categorize bank transactions in Excel for formula-based methods and where they fall short.
A practical workflow for how to categorize bank transactions — build a scheme, apply rules, review the gaps, and stay consistent month to month.
Learn how to categorize bank transactions in Excel using a category list, keyword matching, and VLOOKUP or IF formulas to auto-sort your spending.