Discretionary share is the part of your total spending that you could change this month without breaking a commitment, divided by total spending. On a made-up ₹55,000 month with ₹16,500 in discretionary categories, the share is exactly 30%. The figure depends heavily on which categories you place in each bucket, so decide your buckets once and keep them.
What is the formula?
Discretionary share = discretionary categories ÷ total spend × 100. Both numbers must cover the same period and the same set of accounts. In a sheet where column B says Discretionary or Essential beside each category and column C holds the monthly amount, use =SUMIFS($C$2:$C$30, $B$2:$B$30, "Discretionary")/SUM($C$2:$C$30) and format the cell as a percentage.
How do you sort categories into the two buckets?
Ask whether the money is a commitment or a choice this month. Essential means you would still pay it if money were tight: housing, groceries, bills, loan EMIs, transport to work, medicines and insurance. Discretionary means you could pause it without a penalty: eating out, entertainment, shopping, hobbies, weekend trips, gifts.
| Bucket | Category | Monthly amount |
|---|---|---|
| Essential | Rent | ₹15,000 |
| Essential | Loan EMI | ₹6,000 |
| Essential | Groceries | ₹8,000 |
| Essential | Utilities and recharges | ₹3,200 |
| Essential | Transport | ₹3,800 |
| Essential | Medicines and insurance | ₹2,500 |
| Discretionary | Eating out | ₹5,000 |
| Discretionary | Shopping | ₹4,500 |
| Discretionary | Subscriptions and entertainment | ₹2,500 |
| Discretionary | Outings and travel | ₹3,000 |
| Discretionary | Personal care and gifts | ₹1,500 |
Essential adds to ₹38,500 and discretionary to ₹16,500, so the total is ₹55,000. Discretionary share: ₹16,500 ÷ ₹55,000 = 30%.
What happens when you move a category?
Say you decide that haircuts and basic grooming are really essential, and you move the ₹1,500 personal care and gifts line across. Discretionary falls to ₹15,000 and the share becomes ₹15,000 ÷ ₹55,000, about 27.3%. Nothing changed in your life, yet the figure moved by 2.7 points. Now suppose you also notice that ₹1,200 of the grocery line is snacks and drinks, and you shift that amount into discretionary: ₹16,200 ÷ ₹55,000 is about 29.5%.
A single trip can move the figure as much as a rule change. If outings and travel jumped from ₹3,000 to ₹9,000 in one month, discretionary would be ₹22,500 and the total ₹61,000, so the share would be ₹22,500 ÷ ₹61,000, about 36.9%, nearly seven points higher for one weekend away. That is why a three-month average says more than one month.
The lesson is that the percentage is a label you control, so changes in the figure only mean something when the rules stayed the same. If you change a rule, recalculate the earlier months with the new rule too.
How should you read the number?
- Compare it with your own past months, not with a stranger's rule of thumb. There is no official right level.
- A rising share during months with no festival or trip may show spending creeping into choices.
- A very low share is not automatically good. It can mean you are under-spending on things that matter, or that your essentials are too heavy.
- When income drops, the discretionary share shows how much room you have to cut quickly.
- Also try it against income. If take-home is ₹80,000, the ₹16,500 is about 21% of income (₹16,500 ÷ ₹80,000), which separates a high share caused by high spending from one caused by modest pay.
What to do this month
- Write the bucket next to each of your categories and leave it fixed for the year.
- Compute the share for the last three months.
- Pick the one discretionary line that gives you least value and set a ceiling for it.
In SpendixAI you can create custom categories and sub-categories with their own colours, which makes it easy to keep essential and discretionary lines separate in reports.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

