Getting started

Sorting American Express India charges with simple rules

Sort American Express India card charges into categories using merchant rules, an eight-line worked example and a few honest limits on automatic sorting.

Editorial illustration for Sorting American Express India charges with simple rules

Writing one rule per recurring merchant, running it over the statement and reviewing the leftovers by hand is the fastest route to categorised card charges. A rule is just a match phrase and a category, for example any line containing a particular supermarket name goes to Groceries. After two or three statements, most lines sort themselves.

Why do card descriptions look so unhelpful?

Merchant descriptions on card statements are written for banks, not people. They may be truncated, in capitals, carry a city name or a payment gateway name in place of the shop. A single café can appear under two or three spellings. That is why you match on a stable fragment of the text instead of the whole line.

A worked example with eight made-up lines

Statement text (invented)AmountRule matchCategory
GROCERY MART BENGALURU₹2,850contains MARTGroceries
CAB RIDE 0412₹420contains CABTransport
STREAMING SERVICE₹649contains STREAMINGSubscriptions
PHARMACY CHENNAI₹1,180contains PHARMACYHealth
AIRLINE BOOKING₹9,600contains AIRLINETravel
UNKNOWN GATEWAY 7781₹3,300no matchReview
RESTAURANT MUMBAI₹2,100contains RESTAURANTDining
FUEL STATION₹2,500contains FUELTransport

Seven lines sorted by rule and one held for review. Total spend is 2,850 plus 420 plus 649 plus 1,180 plus 9,600 plus 3,300 plus 2,100 plus 2,500, which is ₹22,599. Transport is ₹2,920, and the unknown gateway line is about 15 percent of the total, so it deserves a closer look.

How do you handle the lines no rule catches?

  1. Open your payment history for that date. A gateway name usually hides a shop you remember.
  2. Check receipts and email confirmations for the amount.
  3. Once identified, create a rule, so next month's line sorts itself.
  4. If you truly cannot identify it, mark it for follow-up and look at it again before the due date, in case it is a charge to dispute with the issuer.

What if a merchant fits two categories?

A large store that sells both groceries and electronics, for instance. Choose the category for the usual purchase and fix the exceptions manually. Over-engineering rules to cover rare cases costs more time than it saves.

Where does an app help?

SpendixAI categorises in stages: your own rules first, then your history and similar merchants, then an AI model only if you have switched AI on, using the normalised merchant name and an amount band rather than your name or account numbers. Anything it cannot place is held for review if AI is off. Your corrections become history, and you can add merchant aliases. It will not be right on every line, so review before saving.

How do you keep rules from going stale?

Merchants rename themselves, payment gateways change and new subscriptions appear. Once a quarter, sort the Review pile and the lowest-confidence rows and ask whether any rule has started catching the wrong lines. A quick test: filter one category and scan for anything that does not belong. If a Groceries rule has quietly started catching a pharmacy, you will see it within seconds.

  • Delete rules for merchants you no longer use.
  • Split a broad rule into two narrower ones when it misfires.
  • Write the reason in a note when a rule is unusual, so future you understands it.

Rules are a tool for saving time, not a goal in themselves. If you spend longer fixing rules than categorising by hand, you have too many.

Monthly routine

  • Import the statement.
  • Sort the largest lines first.
  • Create rules for any merchant you meet twice.
  • Leave a small Review pile and clear it weekly.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports