Categorizing bank transactions turns a long list of payments into a useful picture of your spending. You do not need complicated finance software: a clean CSV file and a spreadsheet are enough to begin.
Download the transaction categorization CSV template to start with the recommended columns and three example rows.
Prepare the Transaction Data
Start with columns for date, description, amount, and balance. If your bank only provides a PDF, use Statementsify to convert the statement to CSV before importing it into Excel or Google Sheets.
Preserve the original transaction description. Add new columns instead of overwriting source data:
- Category
- Account
- Essential or optional
- Notes
- Reviewed
Choose Categories You Will Actually Use
Begin with eight to twelve broad categories. Housing, groceries, transportation, health, debt, savings, subscriptions, dining, and entertainment cover most household spending.
Categories should answer a decision-making question. If separating coffee from restaurants will not change a decision, one dining category is enough.
Use a Consistent Naming Rule
Merchant descriptions are often inconsistent. One store may appear under several shortened names. Create a small mapping table with a merchant pattern and its usual category. Use spreadsheet filters to find similar descriptions and categorize them together.
Avoid relying entirely on automatic rules. A marketplace, pharmacy, or large retailer can contain purchases from several categories, so review ambiguous transactions manually.
Speed Up Repeated Categorization
Create a second sheet named Rules with one column for a merchant pattern and
another for its default category. For example, a known electricity provider can
map to Utilities. Apply rules only to merchants whose purpose is predictable.
In a small workbook, a lookup formula can suggest a category while leaving the
final decision visible for review. Keep a separate Reviewed column so a
suggestion is never confused with a confirmed classification.
When descriptions contain extra transaction IDs, search for a stable part of the merchant name instead of requiring an exact match. Review rule changes on a copy of the data before applying them across prior months.
Summarize Spending With a Pivot Table
Once every row has a category, create a pivot table:
- Put category in the rows
- Put amount in the values
- Summarize the amount by sum
- Add month as a filter or column
If expenses are stored as negative numbers, display their absolute values in a summary column or keep the sign and interpret totals consistently.
Example Category Summary
Suppose the categorized month contains $1,450 for Housing, $520 for Groceries, $190 for Transportation, $145 for Subscriptions, and $360 for Dining and Entertainment. The pivot table immediately shows that housing is the largest fixed cost and that the two most flexible categories total $505.
That does not automatically mean $505 is excessive. It identifies where a person can investigate first. Open the underlying rows, separate unusual events from recurring habits, and then choose a realistic target.
Prevent Duplicate and Missing Transactions
When combining statements, add an Account column before copying rows into the master sheet. Check that every statement period is included once. Sort by date and compare opening and closing balances when available.
Transfers need a dedicated category. A transfer leaving checking and entering savings should not be counted as both spending and income. Credit card payments also require consistent treatment: categorize either the purchases or the payment, not both.
Add a Monthly Review Habit
Categorization becomes useful when repeated. Review new transactions weekly or monthly, correct uncertain merchants, and compare each category with your budget.
Our guides to building a budget from statements and completing a monthly money review show what to do with the categorized totals.
Protect Financial Data
Store spreadsheets in an account protected by a strong unique password and multi-factor authentication. Limit sharing permissions and remove files from shared devices when finished. Avoid adding full account numbers or credentials to the spreadsheet.
Ready to organize a PDF statement? Use the Statementsify converter to create a spreadsheet-ready CSV file.