Spending concentration is the share of your money that goes to your single biggest merchant, and the number only means something once you say what it is a share of. Thirty-five per cent of your flexible spending on one delivery app is a decision you can change; thirty-five per cent of total spending at a grocery store is just where your groceries come from.
Two denominators, two answers
There are two sensible bases. The first is total spending, which is easy but includes rent and EMIs that never change. The second is flexible spending, meaning total minus fixed commitments, which shows only the part you could shift next month.
| Base | Formula | Best for |
|---|---|---|
| Share of total | Merchant total ÷ all spending | Spotting dependence on one name |
| Share of flexible spend | Merchant total ÷ (all spending - fixed commitments) | Finding what you can change |
A worked month
Say a household spends ₹60,000 in a month. Fixed commitments are rent ₹22,000, an EMI ₹8,000 and bills ₹4,000, which is ₹34,000. That leaves 60,000 - 34,000 = ₹26,000 of flexible spending.
One person's biggest flexible merchant is a food delivery app at ₹9,100. As a share of flexible spending that is 9,100 ÷ 26,000 = 35%. Another household has no big delivery habit but pays one grocery store ₹21,000 out of a total of ₹60,000, which is also 35%, this time of total spending.
| Case | Merchant | Amount | Base | Share | What it asks |
|---|---|---|---|---|---|
| Delivery app | Food delivery app | ₹9,100 | ₹26,000 flexible | 35% | Is each order a choice? What does it cost per order? |
| Grocery store | Neighbourhood store | ₹21,000 | ₹60,000 total | 35% | Is the price fair, and is a second shop worth the trip? |
Same percentage, different decision. The delivery share invites a limit or a plan; the grocery share invites a price check once or twice a year.
How do you calculate it in a sheet?
With amounts in C, merchants in B and a fixed-commitment flag in D (Yes or No), the total flexible spending is =SUMIFS($C$2:$C$500,$D$2:$D$500,"No"). A merchant's share of that is =SUMIFS($C$2:$C$500,$B$2:$B$500,"Food delivery app",$D$2:$D$500,"No")/SUMIFS($C$2:$C$500,$D$2:$D$500,"No"). Replace the merchant name with a cell reference to run it down a list.
What counts as concentrated?
There is no official line, and a number that looks high is not wrong. A useful working rule: look at your top three merchants' combined share of flexible spending. If it is more than half, a small change in one habit moves your month; if it is spread thin, no single fix will.
What if one app is hard to leave?
- Check whether the share has risen over the last three months.
- Look at cost per order, not just the total.
- Note what you would use if it were unavailable.
- Choose a limit by number of orders, not by a vague intention.
Why one month can mislead
A single large purchase from a marketplace can make it your top merchant for one month without any change in habits. Look at three months and compare the share month by month. If the top name changes every month, you are not concentrated at all. If the same name leads each month, the number is stable enough to act on, and the question becomes whether you would be comfortable if the price or service changed.
Tracking it without a spreadsheet
In SpendixAI you can group by merchant in the Report builder and read each merchant's total beside overall spending; mark fixed commitments by category so you can set them aside. Merchant aliases help when one platform shows up under two descriptors.
Next step
Compute your top merchant's share of flexible spending for last month, then ask the question in the table beside it. Repeat in three months to see whether it moved.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

