To bulk edit transaction categories safely, filter the list to one merchant or keyword, check that every row in the filter really belongs together, move the whole group to the new category in one action, and then confirm the grand total did not change. Finish by creating a rule so next month's rows land in the right place by themselves.
Why bulk editing beats row by row
An imported statement can put a hundred rows in the wrong category: coffee as Shopping, ride-share as Other, a streaming service as Entertainment on some rows and Utilities on others. Fixing them one by one takes an hour and is easy to abandon halfway. Group edits take minutes, and the work compounds if the app learns from them.
The safe sequence
- Note the grand total and the total for the two categories involved.
- Filter by merchant name or a keyword in the description.
- Scan the filtered rows. If one does not belong, exclude it.
- Select all and set the new category.
- Recheck totals. The grand total must be identical; only the split between categories moves.
- Create a rule, if the tool supports one, for that merchant.
A worked example in dollars
The numbers are hypothetical. Say eighteen coffee-shop rows totalling $99.00 sit in Shopping, and you move them to Dining.
| Category | Before | Rows moved | After |
|---|---|---|---|
| Shopping | $412.40 | -$99.00 | $313.40 |
| Dining | $286.00 | +$99.00 | $385.00 |
| Both together | $698.40 | $0.00 | $698.40 |
Check: 412.40 + 286.00 = 698.40, and 313.40 + 385.00 = 698.40. The combined total did not move, which is how you know the edit changed labels only. If the combined number differs, a row was deleted or duplicated, so undo and retry.
Can you do it in a spreadsheet?
Yes. Add a helper column that proposes the new category, for example in D2:
=IF(ISNUMBER(SEARCH("coffee", B2)), "Dining", C2)
B holds the description and C the current category. SEARCH ignores case and returns a position when it finds the word, and ISNUMBER turns that into true or false. Fill down, review the changes, then copy column D and paste as values over column C. Keep the original column in another tab until you have checked the totals.
What should a rule remember?
- Match on a normalised merchant name, not on the full description with its store number and date.
- Decide whether the amount matters: a ride-share and a delivery fee from the same company may belong in different places.
- Allow exceptions, so one odd row does not drag the rule.
Think about the order in which rules apply. If a rule says anything containing a retailer's name is Shopping, and another says a pharmacy counter at the same retailer is Health, the more specific one must win. When you write rules, start with the specific ones and keep the broad ones for last. Review the rule list every quarter; merchants merge, rename and change what they sell.
Finally, keep a short log of what you changed and why. A line like 'moved coffee shops to Dining, 18 rows, $99.00' is enough to retrace a bulk edit months later.
A note on where SpendixAI fits
SpendixAI is built around India and INR, so this article does not claim it is available or priced for other countries. Where it applies, its categorisation starts with your own rules, then your history and similar merchants, and corrections become history, which is the same idea as a rule. Check the product pages for what it supports before relying on it.
A last pass
After a bulk edit, glance at the five largest categories and the Uncategorised or Other bucket. If Other is still large, repeat the sequence for the next biggest merchant.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

