How to Categorize Bank Transactions for Budgeting (5 Steps)
To categorize bank transactions for budgeting, download one to three months of transactions as a CSV file and add a Category column. Label every line with one of 10 to 15 categories that match how you actually spend. Then total each category and compare it with your income: the totals show you, in dollars, which two or three areas are worth cutting.
The first pass takes the longest. Expect 30 to 60 minutes for a month of around 150 transactions. After that, most merchants repeat, and a monthly update takes about 10 minutes. Below are the categories that work, the export, the five-step method and how to handle the transactions that don't fit anywhere.
Which budget categories should you use?
Too few categories hide problems. A single "Shopping" line at $900 tells you nothing. Too many and you spend more time deciding than budgeting. Somewhere between 10 and 15 is the range most people stick with. Split them into fixed costs, which barely move from month to month, and flexible ones you control.
| Category | Type | Typical transactions |
|---|---|---|
| Housing | Fixed | Rent, mortgage, HOA fees, renter's insurance |
| Utilities | Fixed | Electric, gas, water, internet, phone |
| Transportation | Mixed | Gas, car payment, car insurance, transit pass, parking |
| Groceries | Flexible | Supermarket, warehouse club, farmers market |
| Dining out | Flexible | Restaurants, takeout, delivery apps, coffee shops |
| Subscriptions | Flexible | Streaming, apps, gym, software, memberships |
| Shopping | Flexible | Clothes, online orders, household items |
| Health | Mixed | Pharmacy, copays, dental |
| Kids and pets | Mixed | Daycare, school fees, vet, pet food |
| Fun and travel | Flexible | Movies, concerts, hotels, flights |
| Gifts and giving | Flexible | Presents, donations |
| Debt payments | Fixed | Student loan, personal loan |
| Savings | Goal | Transfers to savings, retirement or brokerage accounts |
| Transfers (exclude) | None | Credit card payments, moves between your own accounts |
Two rules make these categories useful. First, keep groceries and dining out apart. That is the line where most budgets leak, and lumping them together as "Food" hides it. Second, keep a Transfers category that you leave out of your totals, so moving $500 from checking to your credit card doesn't look like $500 of spending.
How do you export your bank transactions as a CSV?
Almost every bank and card issuer lets you download your activity from its website. The option usually sits on the account activity or statements page, behind a button labeled Download, Export or a small arrow icon. Pick CSV, sometimes called "Comma delimited" or "Spreadsheet". If you only see QFX, OFX or QBO, those formats are meant for Quicken and QuickBooks. Look through the menu again or ask your bank's support team, since most also offer CSV. The mobile app often lacks the option, so do this on a computer.
- Export every account you spend from. Checking, each credit card and PayPal if you use it. Skip one and you only see part of the picture.
- Choose full calendar months. Three months gives a more honest average than one, because annual bills and holidays skew any single month.
- Keep the original file untouched. Save a copy and work on that.
Open the file in Excel, Google Sheets or Numbers. You will usually see a date, a description and an amount. Some banks put debits and credits in separate columns. Others use one column with negative numbers for spending. Note which convention each file uses before you total anything.
How do you categorize transactions step by step?
Paste all your accounts into one sheet, add a column saying which account each row came from, then follow these five steps.
- Clean the columns. Keep Date, Description, Amount and Account. Delete the rest. If your card shows spending as positive and your checking account shows it as negative, flip one so all spending has the same sign.
- Add a Category column and sort by Description. Sorting groups the same merchant together, so 14 lines from the same coffee shop can be labeled Dining out in one go. Type the category once, then drag the fill handle down.
- Label the obvious rows first. Rent, payroll, utilities, streaming and the supermarket cover most of the sheet. Use the filter's "text contains" option (for example SHELL or CHEVRON) to grab every gas station at once. Leave anything unclear blank for now.
- Deal with the leftovers. The last 10 to 20 rows are the hard ones: online orders, payment apps, ATM withdrawals, refunds. Look them up in your order history or payment app, then apply the rules in the next section.
- Total each category. On a summary tab, list your categories and use a formula such as =SUMIF(Transactions!E:E,"Groceries",Transactions!C:C) for each one. Or insert a pivot table with Category as rows and Amount as values. Leave Transfers out of the grand total.
As you go, keep a small Rules tab with each merchant name and its category. Next month you check new descriptions against it instead of deciding again. By the third month, almost every row matches a merchant you have already labeled.
Banks print merchant names in odd forms, like "AMZN Mktp US*2K4", "TST* JOES DINER" or "PAYPAL *SPOTIFY". The part after the asterisk is usually the real merchant or the order reference. The part before it is often the payment processor.
Can an app categorize your bank transactions automatically?
Yes. If the spreadsheet feels like a chore you will abandon by March, an app is the better route. Many budgeting apps sort transactions by merchant for you. You still need to check the result, because automatic sorting guesses wrong on mixed stores like Target or Costco, where one receipt can be food, cleaning supplies and a gift.
One way to do it is to import the same CSV export into ScanTicket (on iPhone and Android). Each line of your bank file becomes an entry, the AI assigns a category based on the merchant, and a triage screen lets you fix a wrong label in two taps. You can set your own custom categories, see totals by month, and export everything back to CSV if you still want to work in Excel. If you also scan your paper receipts, the AI cross-references them with your bank transactions and suggests where you could save each month. Treat those suggestions as a starting point: they depend entirely on your own spending.
Whatever tool you use, keep the same category list from month to month. Renaming or merging categories halfway through the year makes comparisons meaningless.
What do you do with transactions that don't fit a category?
These rows are what makes categorizing slow. Decide a rule once and apply it every month.
- Amazon, Walmart, Target, Costco. One charge can mix groceries, a phone charger and a birthday present. If one category makes up most of the order, use it. For a large mixed order, say $186 with $120 of food, split the row into two lines: $120 Groceries and $66 Shopping.
- Credit card payments. If you imported the card's own transactions, the payment from checking is a Transfer. Counting both doubles your spending.
- Venmo, Zelle, PayPal, Cash App. The bank line just says the app name. Check the app's history for what it was for. $40 to a friend for pizza is Dining out. $800 to your landlord is Housing.
- ATM withdrawals. If the cash went to one thing, like a babysitter or the farmers market, use that category. Otherwise a Cash category is fine; just watch its total.
- Refunds and returns. Put the refund in the same category as the original purchase, as a negative number. It reduces that category instead of looking like income.
- Annual charges. A yearly membership or a $600 insurance premium distorts the month it lands in. Note it, and when you plan, divide it by 12 and set that amount aside every month.
- Work expenses you get reimbursed for. Tag them "Work, reimbursable" and exclude both the expense and the reimbursement from your totals.
How do you find where to cut back each month?
Once you have totals, sort the categories from largest to smallest and look only at the flexible ones. Your rent won't shrink this month. Your dining out can.
Here is what a month might look like for a two-person household: Groceries $612, Dining out $384 across 23 transactions, Subscriptions $94 across 9 services, Shopping $410. Three questions find the cuts:
- Which totals surprised you? If you guessed $150 for dining out and it came to $384, that gap is where to start.
- Where are many small charges? Eighteen coffees at $6.50 is $117 a month. Count transactions per category, not just totals.
- What renews without you noticing? Filter Subscriptions and read every line. Cancel anything you haven't opened in the past month.
Pick one or two categories and set a realistic target. Bringing dining out from $384 down to $250 frees $134 a month, about $1,600 a year. Trying to fix every category at once usually ends with fixing none.
Measure against your three-month average, not your best month. If groceries ran $540, $612 and $575, a baseline of about $575 is more honest than $540. Repeat the categorization at the start of each month, check your targets and adjust them. The second month takes a fraction of the time, and by the third you will know your numbers before you open the file.
Frequently asked questions
How many budget categories should I have?
Most people do well with 10 to 15. Fewer hides where money goes, and more makes every transaction a decision. Keep groceries and dining out separate, plus a Transfers category you exclude from totals.
How often should I categorize my bank transactions?
Once a month is enough for most budgets and takes about 10 minutes once your merchant rules are set. If money is tight, a quick weekly pass helps you catch overspending before the month ends.
Do transfers to savings count as spending?
No. Track them in a Savings category so you can see progress toward your goal, but keep them out of your spending total. Moves between your own accounts, like credit card payments, should be excluded entirely.
What is the fastest way to categorize transactions in Excel or Google Sheets?
Sort by the Description column so identical merchants sit together, fill the category down in one drag, and use the filter's text contains option for groups like gas stations. Then total with SUMIF or a pivot table.
Is it safe to upload a bank CSV file to a budgeting app?
A CSV export contains your transaction history but not your bank login. Before uploading, read the app's privacy policy to see where the data is processed and whether it is ever shared or sold.

