To categorise a card statement quickly, start with a short category list, tag repeating merchants once so they stay tagged, and then review only what is left. Do it in that order and a month of transactions takes minutes, not an evening. The method is the same for a Capital One statement or any other; layouts vary, so check your own.
Pick a short category list
Eight to ten categories are enough to begin: Groceries, Eating out, Fuel and transport, Bills and utilities, Shopping, Subscriptions, Health, Travel, Fees and interest, Other. You can split later. Too many categories make you tired and inconsistent.
Tag merchants, not transactions
Merchants repeat. Once you decide that a certain grocer is Groceries, every row from that name should be Groceries. In a sheet you can keep a lookup table with merchant text and category, then use =VLOOKUP(A2, $F$2:$G$100, 2, FALSE) in the category column, where F has merchants and G has categories. In an app, this is a rule.
Review what is left
- Sort by amount, largest first. Large rows move your totals the most.
- Label unclear descriptions by checking your own memory or receipts.
- Mark the ones you cannot place as Other and move on, then return once.
- Check refunds and reversals, which should reduce spending.
A worked example
| Merchant text | Amount | Category |
|---|---|---|
| Supermarket | ₹2,640 | Groceries |
| Cab ride | ₹380 | Fuel and transport |
| Online store | ₹1,899 | Shopping |
| Video plan | ₹199 | Subscriptions |
| Pharmacy | ₹540 | Health |
| Supermarket | ₹1,120 | Groceries |
Groceries are 2,640 plus 1,120, which is ₹3,760. All six rows add to 2,640 plus 380 plus 1,899 plus 199 plus 540 plus 1,120, which is ₹6,778. If your categories add to the same ₹6,778, nothing was dropped.
How does an app do the same?
In SpendixAI, categorisation runs in stages: your own rules first, then your history and similar merchants, and only if AI is switched on, an AI model for what is left, using the cleaned merchant name and an amount band rather than your name or account numbers. You can turn AI off, and unmatched items are then held for review. Your corrections become history for next time.
What do I do with split purchases?
A single receipt can hold more than one category, for example a hypermarket bill with groceries and a kitchen appliance. If the appliance is large, split it. Say the bill is ₹5,400 with ₹3,900 of groceries and ₹1,500 of home items. Record two rows, 3,900 and 1,500, which add back to 5,400. If the split is small, leave it under the main category, because perfect accuracy is not worth losing the habit.
Decide your own rule, for example anything under ₹500 stays in the main category, and stick to it, so your months are comparable.
How long should this take each month?
With rules in place, a first month of around 60 transactions might take 30 minutes; the second, about 10, because the repeating merchants are already tagged. If it keeps taking longer, you probably have too many categories or too few rules. Merge two categories that you never look at separately, and tag the five merchants that appear most often.
- Week one: build the category list
- Week two: tag the top merchants
- Month end: review Other and check totals
Keep the system alive
- Add a rule whenever you correct the same merchant twice
- Review the Other category monthly
- Rename categories only at the start of a month
- Keep a note of why you made an odd choice
Useful ideas start with a clearer picture of your own spending.
Explore your reports

