Budgeting

Discretionary spending share: formula with hypothetical numbers

Discretionary share is discretionary spending divided by total spend. Worked on ₹55,000 a month, plus how the figure shifts when you move a category.

Editorial illustration for Discretionary spending share: formula with hypothetical numbers

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.

BucketCategoryMonthly amount
EssentialRent₹15,000
EssentialLoan EMI₹6,000
EssentialGroceries₹8,000
EssentialUtilities and recharges₹3,200
EssentialTransport₹3,800
EssentialMedicines and insurance₹2,500
DiscretionaryEating out₹5,000
DiscretionaryShopping₹4,500
DiscretionarySubscriptions and entertainment₹2,500
DiscretionaryOutings and travel₹3,000
DiscretionaryPersonal 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

  1. Write the bucket next to each of your categories and leave it fixed for the year.
  2. Compute the share for the last three months.
  3. 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.

SPENDIXAI JOURNAL

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

Explore your reports