To see your top merchants for a month, download the month's card and checking transactions, tidy the merchant names so each shop appears under one name, total the spend per merchant and sort from largest to smallest. About ten minutes with a pivot table is enough, and the top ten list usually teaches you more than a category chart does.
Why do merchants tell you more than categories?
A category called Dining at $412 hides what is inside it. If $238 of that is one delivery app at about $17 a time, the problem is a habit with a name on it, and you can act on a habit. A merchant ranking also exposes recurring charges you stopped noticing, because they sit quietly in the middle of the list month after month.
Step by step with a pivot table
- Export the month from every checking and card account as CSV and paste them into one sheet, adding a column that says which account each row came from.
- Add a Clean merchant column. Statement text often carries store numbers and city codes, so one shop can appear in four forms. Fix the first month by hand and keep a small lookup list with the raw text in column H and the clean name in column I.
- In the Clean merchant column use =IFERROR(VLOOKUP(B2,$H$2:$I$100,2,FALSE),B2), which returns the clean name if the raw text is in your list and leaves it unchanged if not.
- Select your data and insert a PivotTable. Put Clean merchant in Rows and Amount in Values as a Sum.
- Add Amount to Values a second time and change it to Count, then sort the Sum column from largest to smallest.
A worked month with made-up numbers
Say your spending for the month, with rent left out, came to $2,400. These are invented figures to show the arithmetic, not typical prices.
| Merchant | Visits | Total | Average visit | Share of $2,400 |
|---|---|---|---|---|
| Grocery chain | 9 | $486 | $54.00 | 20.3% |
| Online retailer | 8 | $312 | $39.00 | 13.0% |
| Gas station | 6 | $270 | $45.00 | 11.3% |
| Food delivery app | 14 | $238 | $17.00 | 9.9% |
| Coffee shop | 16 | $88 | $5.50 | 3.7% |
The five together come to $486 + $312 + $270 + $238 + $88 = $1,394, which is 58.1% of the month. Each share is the merchant's total divided by $2,400.
What should you look for in the ranking?
- Visits against average visit. The coffee shop is only 3.7% of spending, yet sixteen visits make it the most frequent habit on the list.
- Movement since last month. A merchant that jumped three places deserves a look even if it is not at the top.
- Names you do not recognise. Check the date and amount against your email or receipts before assuming it is an error.
- Small recurring charges near the bottom. Add them up; several at $9 or $12 can match one large merchant.
Do you have to track every merchant?
No. Keep the top ten as named rows and put everything else into one line called Other. If Other grows past a third of the month, your clean-up list needs more entries rather than your habits needing a rethink.
How do you spot a merchant that is quietly growing?
Keep three months of rankings in one sheet, one column per month. A merchant whose total rises each month while its visit count stays flat is charging you more per visit, for example through a higher delivery fee or a price change on a plan. A merchant whose visits rise while the average falls is a habit forming. Reading across a row is quicker than reading down a statement, and one glance is enough to decide whether to look closer.
If a name in the middle of the list is a subscription, check the date it is charged. Many people find one or two they meant to cancel, and cancelling is a better use of the ranking than any other action it suggests.
Before you close the sheet
- Save the clean-up lookup list so next month starts from it.
- Write down the top three merchants and one fact about each, such as visits or average.
- Pick one merchant to look at again next month and note today's figure beside it.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

