Budgeting

Merchant frequency vs merchant total: two rankings to compare

Rank merchants by number of transactions and by total spend, then compare the two lists. A merchant paid 40 times and one paid twice need different decisions.

Editorial illustration for Merchant frequency vs merchant total: two rankings to compare

Two merchants can cost you the same ₹6,000 and still call for opposite decisions: one paid 40 times is a habit, one paid twice is a purchase. Ranking merchants by number of transactions and by total spend, and comparing the two lists, shows you which is which.

The same ₹6,000, two different stories

MeasureMerchant AMerchant B
Total paid₹6,000₹6,000
Number of payments402
Average payment₹150₹3,000
What it looks likeDaily tea and snacks, small top-upsA repair and an annual fee
The question to askIs each visit a choice, and can I plan them?Was the price fair and was it needed?
Where the saving isFewer or planned visitsComparing prices before the next one

Merchant A will never look expensive in a single payment, which is why it is easy to ignore. Merchant B looks big every time and has nothing to repeat. The frequency ranking finds A; the total ranking finds B.

How do you build the two rankings?

  1. Take three to six months of transactions and group them by merchant.
  2. For each merchant compute the count of payments, the total, and the average (total divided by count).
  3. Sort once by count, highest first, and take the top ten. Sort again by total and take the top ten.
  4. Put the two lists side by side and mark any merchant that appears in only one.

In Excel or Google Sheets, a pivot table does this: merchant in rows, count of amount and sum of amount in values. With a plain list of merchants in column F, the count is =COUNTIF($B$2:$B$1000,F2), the total is =SUMIF($B$2:$B$1000,F2,$C$2:$C$1000), and the average is =IFERROR(H2/G2,0) if G is count and H is total.

What does each quadrant tell you?

Total spendFew paymentsMany payments
LowIgnoreSmall habit: check the sum over a year
HighBig purchase or bill: compare and planCore spending: review price, quantity and substitutes

Most useful decisions sit in the top-right and in the bottom-left corners. The bottom-left cell can hold a fee you forgot you pay or a single large purchase; the top-right is your grocery store.

What should you do with a high-frequency, low-total merchant?

Multiply it up. Say the tea and snack stall costs ₹6,000 a quarter over 40 payments. In a year that is 4 × 6,000 = ₹24,000. If you cut 10 of the 40 visits, you save 10 × 150 = ₹1,500 a quarter, or ₹6,000 a year. Whether that is worth it is your call, but a number like that makes the choice real.

Small payments also hide in plain sight because UPI makes each one frictionless. Look at the day of week and time: if they cluster on workdays at four in the afternoon, you may be solving a different problem, such as lunch that did not fill you.

What should you do with a low-frequency, high-total merchant?

Check the two payments individually. Was the ₹3,000 a one-off repair, or an annual fee that will return? If it recurs, add it to next year's plan as a line. If it was a purchase, compare the price against another seller before the next time.

Keep a running note of the three merchants you decided to watch and what you decided. When you run the rankings again, read that note first, so each review starts from the last decision rather than from zero.

A quick routine

Once a month, take ten minutes: sort by count, sort by total, put a star on any merchant in one list only, and write a one-line decision next to each starred row. In SpendixAI you can use the Report builder to group transactions by merchant and then switch the sort, which is the same two-list approach without a pivot table.

SPENDIXAI JOURNAL

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

Explore your reports