The question: "Food delivery payments show up under three or four different names on my statement, so my Swiggy total, my Zomato total and the 'Gold' membership never add up. How do I merge them?" Short answer: pick one clean display name per merchant, and map every ugly variant to it.
Why does one shop appear under several names?
A statement line carries whatever the payment network sends: sometimes the brand, sometimes the company behind it, sometimes a handle with a reference number, and a subscription charge may look different from a meal order. Neither you nor the bank decided to confuse you; the text was never written for humans. Your own tracker has to do the tidying.
How do I merge them? Steps
- Search your statement for the brand name and also for fragments of it. Write down every distinct variant you see, with the amounts.
- Pick the clean name you want to see in reports, for example "Swiggy".
- Map each variant to that name, as an alias or a merge, so future rows land there automatically.
- Decide whether memberships and one-off orders belong under the same merchant. Usually yes, with a different category or a note.
- Repeat for your top five merchants only. Do not try to clean all of them.
- Run the merchant total again and compare it with a manual search of the statement.
What does the arithmetic look like?
Hypothetical variants over one month, all for the same app.
| Variant on the statement | Rows | Amount (₹) |
|---|---|---|
| Short brand name | 9 | 3,150 |
| Longer brand name with suffix | 4 | 1,420 |
| Company-style name | 2 | 640 |
| Membership charge | 1 | 149 |
| After merging into one merchant | 16 | 5,359 |
The rows add up as 9 plus 4 plus 2 plus 1, which is 16, and the amounts as 3,150 plus 1,420 plus 640 plus 149, which is ₹5,359. Before merging, the biggest single line item looked like ₹3,150. After, the honest figure is ₹5,359, about seventy percent higher. That gap is the whole reason to do this.
How does SpendixAI handle it?
SpendixAI lets you add merchant aliases and merge merchants so the same shop appears under one name, and the merchant view totals spend per merchant from the statements you have imported. Your corrections feed its history, so the next import starts cleaner. It works from uploaded PDF, CSV or Excel statements, not a live bank link, so the totals are only as complete as the statements you have uploaded.
What should I verify?
- Did the alias also catch a person whose name contains the same letters? Keep aliases specific.
- Does your merged total equal a manual search of the statement?
- Are refunds from that merchant included as credits, not spend?
- Did a similar-looking but different merchant get merged by mistake?
What is the honest limit?
You cannot always tell from the text whether a charge was a meal or a grocery top-up through the same app. If the split matters, add the category by hand for large amounts and let small ones ride.
How do I find variants I have not noticed yet?
After the first merge, sort your uncategorised or low-count merchants alphabetically. Variants of a big merchant tend to sit next to each other, with a similar start to the name. Look for names that appear once or twice and look like a cousin of something you already merged.
Do this again after each import for the first two months. By the third month new variants are rare, because the aliases catch most of them. Keep a short list of your own tricky merchants, so you can check new imports against it in two minutes.
Do this once
- List variants for your five most-used merchants.
- Map them to clean names.
- Compare against a manual search for one month.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

