GuideMarch 11, 2026·7 min read

How to Categorize Bank Transactions (3 Methods, Fastest First)

Categorizing bank transactions gives you a clear picture of where your money goes each month — and it's required for tax prep, budgeting, and understanding your spending patterns. There are three main ways to do it. Here's each method explained, starting with the fastest.

In this guide

Method 1: AI automatic categorization (30 seconds)
Method 2: Manual in Excel (1–3 hours)
Method 3: QuickBooks or Xero (ongoing)
Standard bank transaction category list
How to categorize for taxes
FAQ

AI automatic categorization

Fastest

Time: ~30 seconds

Download your bank statement as PDF from your bank's website or app
Upload the PDF to mybankstatementanalysis.com
AI reads every transaction, identifies merchants, and assigns categories
Review your categorized spending dashboard and export CSV

Pros

✓Zero manual work

✓Works with any bank worldwide

✓Detects subscriptions automatically

✓Free for first 3 pages

Cons

✗Requires PDF download

✗Not a live connection (snapshot only)

Manual categorization in Excel

Most flexible

Time: 1–3 hours

Log into your bank and export transactions as CSV or download statement
Open in Excel or Google Sheets
Add a "Category" column next to the description column
Manually type or select the category for each transaction row
Create a pivot table to sum totals by category

Pros

✓Full control over category names

✓No third-party tools needed

✓Customizable for any use case

Cons

✗Very time-consuming (100 transactions = 100 manual entries)

✗Error-prone

✗No subscription detection

✗Must be repeated every month

Categorization in QuickBooks or Xero

Best for ongoing use

Time: Setup: 30 min + ongoing review

Open QuickBooks Online or Xero and go to Banking / Bank Feeds
Connect your bank account via Open Banking (requires your bank to support this)
Transactions import automatically on a daily basis
Go to "For Review" tab and confirm or correct the suggested category for each transaction
QuickBooks/Xero learns your preferences and improves over time

Pros

✓Automatic daily imports

✓Integrates with accounting workflows

✓Tax-ready reports

✓Improves over time

Cons

✗Requires live bank account connection

✗Not all banks supported

✗Costs $30–$100/month

✗Still requires manual review for many transactions

Standard bank transaction category list

Here are the most common categories used by AI tools and accounting software, with examples and tax notes:

CategoryExamplesTax note

Housing & RentMortgage payment, rent, HOA fees, property taxDeductible if home office (Schedule C)

GroceriesWhole Foods, Trader Joe's, Kroger, Aldi, CostcoGenerally not deductible

Dining OutRestaurants, Uber Eats, DoorDash, Starbucks, fast food50% deductible if business meal

TransportGas stations, Uber, Lyft, parking, tolls, car paymentsDeductible if business use (keep mileage log)

ShoppingAmazon, Target, Walmart, clothing storesDeductible if business supplies

UtilitiesElectric, gas, water, internet, phone billPartial deduction for home office

SubscriptionsNetflix, Spotify, Adobe, SaaS tools, gymDeductible if business subscriptions

HealthcarePharmacy, doctor visits, dental, insurance copaysDeductible above 7.5% of AGI

IncomePayroll, freelance payments, transfers in, refundsTaxable income

Fees & ChargesBank fees, overdraft, wire transfer, ATM feesDeductible if business account

How to categorize transactions for taxes

If you're self-employed or running a business, your transaction categories need to map to IRS expense types on Schedule C:

Advertising — marketing, design, ads
Car & Truck — gas, parking, Uber if for business (keep mileage log)
Meals — 50% deductible for business meals with clients
Office Expenses — supplies, software subscriptions, SaaS tools
Rent — office rent (not home rent unless home office deduction)
Utilities — partial deduction if home office
Professional Fees — accountant, lawyer, consultant
Insurance — business insurance premiums

Tip: Export your categorized transactions as CSV from mybankstatementanalysis, then filter by business categories in Excel. This gives you a clean expense report for your accountant — or for filling out Schedule C yourself.

Skip the manual work — categorize automatically

Upload your bank statement PDF and AI categorizes every transaction in 30 seconds. Free for the first 3 pages.

Categorize My Transactions Free →

FAQ

What are the standard bank transaction categories?+−

The most common categories are: Housing & Rent, Groceries, Dining Out, Transport, Shopping, Utilities, Subscriptions, Healthcare, Entertainment, Travel, Insurance, Education, Personal Care, Income, and Transfers. Some tools use more granular categories (19 or more), others group everything into 5–10 buckets.

How do I categorize bank transactions in Excel?+−

Export your transactions as CSV from your bank, open in Excel, add a "Category" column, and manually type the category for each row. You can speed this up with VLOOKUP or IF formulas that match merchant names to categories — but it still requires significant setup and manual review.

How do I categorize bank transactions in QuickBooks?+−

Connect your bank account in QuickBooks via Open Banking. Transactions import automatically and QuickBooks attempts to categorize them using its rules engine. You review and confirm each category in the "For Review" tab. QuickBooks learns your preferences over time but still requires manual review.

Can AI automatically categorize bank transactions?+−

Yes. AI tools like mybankstatementanalysis read your bank statement PDF and automatically categorize every transaction with 95%+ accuracy — no manual review needed for the vast majority of transactions. It takes about 30 seconds for a full month's statement.

How do banks categorize transactions?+−

Banks use Merchant Category Codes (MCC) — a 4-digit code assigned to every business that accepts card payments. MCCs broadly classify transactions (5411 = grocery stores, 5812 = restaurants, etc.). Banks display these as simplified labels like "Groceries" or "Dining." The problem is MCCs are often inaccurate or too broad, which is why third-party AI categorization tools are more accurate.

What is the best way to categorize transactions for taxes?+−

For tax purposes, use categories that match IRS Schedule C expense types if self-employed: Advertising, Car & Truck, Meals, Office Expenses, Rent, Utilities, Insurance, Professional Fees, Supplies. Export your categorized transactions as CSV, then group totals by category. Keep all receipts for amounts over $75.

Guide6 min read

How to Paste CSV Into Excel (and Open CSV Files Properly)

Every method for getting CSV data into Excel correctly — paste with Text to Columns, open files without losing formatting, and fix common import problems.

Guide7 min read

What Does YTD Mean on a Paycheck? Every Field Explained

YTD stands for Year-to-Date. Here's what every YTD field on your pay stub means — gross pay, net pay, taxes, and deductions — with a real sample paycheck.

Guide12 min read

How to Do Bank Statement Analysis: The Complete Guide (2026)

Step-by-step: from manual Excel methods to AI-powered tools that categorize everything in 30 seconds.