To see where your euros really go, rank merchants by total spend, then look at how many visits and what average each visit cost. Two merchants with the same total can mean very different things: one big monthly shop or thirty small ones. The ranking works with any list of a month's card payments.
Total, frequency and ticket size
Every merchant has three numbers: the total, the number of visits and the average per visit, which is the total divided by visits. A ranking by total alone hides the other two, so keep all three side by side. The one that changes behaviour is usually frequency, because it is easier to skip a visit than to shrink a bill.
A worked month in euros
Say you spent €1,620 on cards across the month, excluding rent. The numbers below are invented for the example.
| Merchant | Visits | Total | Average visit |
|---|---|---|---|
| Supermarket | 8 | €304 | €38.00 |
| Bakery near the office | 21 | €63 | €3.00 |
| Weekend market stall | 4 | €92 | €23.00 |
| Fuel | 3 | €156 | €52.00 |
| Pharmacy | 2 | €41 | €20.50 |
Add the five totals: €304 + €63 + €92 + €156 + €41 = €656, which is about 40.5% of €1,620. The bakery looks trivial at €63, but twenty-one visits mean it is the habit most likely to repeat every working day.
What is hiding in the long tail?
After the top five, there is usually a long list of merchants with one or two payments each. Do not read them one by one. Total everything outside your top ten and call it the long tail. In the example, the remaining €1,620 - €656 = €964 is spread over smaller names. If the long tail is more than half the month, either your merchant names are not clean enough or you are making many small purchases, and each of those needs its own look.
How do you build the ranking quickly?
- Export or copy the month's card payments into a sheet with columns for date, merchant text and amount.
- Add a clean-name column and make each shop appear under one name only.
- Create a pivot table or a SUMIF table with the name in the first column and the total in the second.
- Add a COUNTIF column for visits and divide total by visits for the average.
- Sort by total, mark the top ten and sum the rest as the long tail.
Questions the ranking should answer
- Which merchant has the most visits, and does that match what I thought?
- Which merchant's average visit has crept up over three months?
- Which names appear in the list that we cannot place?
- Which fixed charges are quietly sitting in the ranking as if they were choices?
Which merchants deserve a second look?
Pick two kinds. First, the high-visit, low-ticket names such as the bakery, because their total is easy to cut by changing a routine and hard to cut by willpower in the moment. Second, any large merchant where the average per visit has risen over three months, because that suggests a price or basket change you did not choose. For each, write one sentence about what you would do differently, and leave the rest of the list alone. A ranking that triggers two decisions is doing its job.
A short habit to keep
Do the ranking on the same day each month, such as the first Sunday, and keep the sheet from last month beside it. A single page with this month's top five against last month's is enough. Any spreadsheet can do all of this; SpendixAI is built around India and INR, though each expense there can carry its own currency with totals in a base currency, so it suits Indian households more than a euro one.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


