Budgeting

Top ten merchants report: what to do with it

A top merchants spending report shows where your money goes by payee. Read share, frequency and category mismatch on a sample top ten, then act on one.

Editorial illustration for Top ten merchants report: what to do with it

A top ten merchants report ranks the places you paid by how much you paid them, and it is useful only if you read each row for three things: its share of total spend, how often you paid, and whether it sits in the right category. After that, pick one merchant to act on and leave the rest.

A sample top ten

Here is a made-up three-month list for a household that spent ₹1,80,000 in total. Rent and a neighbourhood grocery store lead, as you would expect.

RankMerchantThree-month totalShare of totalPayments
1Landlord (rent)₹54,00030.0%3
2Neighbourhood grocery store₹21,60012.0%26
3Food delivery app₹14,4008.0%21
4Online shopping marketplace₹11,7006.5%9
5Fuel station₹9,0005.0%12
6Electricity distributor₹6,3003.5%3
7Pharmacy₹5,4003.0%8
8Cab app₹4,5002.5%15
9Gym₹3,6002.0%3
10Streaming service₹2,7001.5%3

The ten rows add up to ₹1,33,200, which is 74.0% of ₹1,80,000. The remaining 26% is a long tail of smaller payees.

What should you read in each row?

  • Share of total: how much of your spending sits with one name. Ten rows making up three quarters of spending tells you that a few decisions drive most of the result.
  • Frequency: 3 payments is a bill, 26 is a habit. A habit can be changed on a calendar; a bill needs a different kind of decision.
  • Category mismatch: a pharmacy that also sells groceries, or a marketplace where you buy both gifts and household items, can sit under the wrong category and distort category reports.

Which merchant should you act on?

Ignore rent. It is the largest row and the one you are least likely to change this quarter. Look at what is left: the discretionary rows are the grocery store, delivery app, marketplace, cab app and streaming service.

Take the food delivery app. ₹14,400 over 21 orders is about ₹686 an order. Without rent, spending is ₹1,26,000 and the app is 14,400 ÷ 1,26,000, or about 11.4% of it. Nothing else on that list combines a high share, a high frequency and a purely optional purchase. One action there, such as capping orders per week, will move the total more than polishing three small lines.

Does the top ten match where you think you spend?

Often it does not. Many people expect a big shopping platform near the top and are surprised by a fuel station or a tea stall at fifteen payments a month. If the list surprises you, check the category first; a wrong category is easier to fix than a habit.

Cleaning the list before you trust it

The same shop can appear under several names: a UPI handle, a card descriptor and a shortened version. Combine them before you rank, or the real number one will look smaller than it is. In SpendixAI you can add merchant aliases so that the variants roll up under one name, and then use the Report builder to group by merchant and sort.

  • Merge duplicate names for the same shop.
  • Separate shops that share a descriptor, such as a mall's payment terminal.
  • Check refunds, because they reduce a merchant's net total.
  • Run the report on at least three months so one festival does not decide the order.

One more check helps: compare this quarter's list with the previous one. A merchant that moved from tenth to fourth is more interesting than one that has led for a year, because something changed, and you can usually name what.

What to do this week

  1. Run the report for the last three months.
  2. Mark the rows that are fixed commitments.
  3. Compare share and payment count on the rest and pick one merchant.
  4. Write the action next to it, for example a limit per week, and the date you will re-run the report.
SPENDIXAI JOURNAL

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

Explore your reports