To split spending into needs and wants, decide which of your existing categories are needs, tag the rest as wants, and add up each group for the month. The calculation is easy; the real work is deciding where the grey areas go, and then keeping that decision the same every month so the comparison means something.
How do you decide what is a need?
Use a plain test: if you stopped it for a month, would you lose your home, your income, your health or someone's safety? Rent, groceries, utilities, transport to work, school fees and loan EMIs pass. Eating out, subscriptions and shopping usually do not. Your own answer is the right one, because a car is a want for one family and a need for another.
What about the grey areas?
- Mobile data: a need up to a basic plan, a want above it. Pick one label and stay with it.
- Groceries: split staples from snacks and treats if the difference matters to you.
- Gym or sports: health, but also a want; decide once.
- Gifts and festival spending: label as wants, but plan them in advance.
A worked example with made-up numbers
Say your month looks like this.
| Category | Type | Amount |
|---|---|---|
| Rent | Need | ₹12,000 |
| Groceries | Need | ₹7,000 |
| Utilities | Need | ₹2,500 |
| Transport | Need | ₹3,500 |
| Loan EMI | Need | ₹4,000 |
| Eating out | Want | ₹3,200 |
| Shopping | Want | ₹2,800 |
| Streaming | Want | ₹649 |
| Weekend trip | Want | ₹1,351 |
Needs: 12,000 + 7,000 + 2,500 + 3,500 + 4,000 = ₹29,000. Wants: 3,200 + 2,800 + 649 + 1,351 = ₹8,000. Total spending is ₹37,000. Needs take 29,000 / 37,000, about 78%, and wants take about 22%.
How do you calculate it in a spreadsheet?
Keep a small lookup table of category and type in columns H and I, then add a Type column to the transactions using a lookup, with categories in column B and amounts in column C.
- Type for each row: =VLOOKUP(B2,$H$2:$I$40,2,FALSE)
- Needs total: =SUMIF($D$2:$D$500,"Need",$C$2:$C$500)
- Wants total: =SUMIF($D$2:$D$500,"Want",$C$2:$C$500)
- Needs share, if the Needs total is in F2 and the Wants total in F3: =F2/(F2+F3)
Here column D holds the Type formula. Fill it down for every row.
How can an app help?
If your categories are right, category totals do most of the work. SpendixAI lets you create your own categories and sub-categories, with colours, so you can name them to suit the split, such as a Wants parent with Dining and Shopping inside it. Reports and the Report builder can then filter and group by category, and a CSV download lets you finish the split in a sheet if you prefer.
How do you handle a want that is also a need?
Split the amount where you can. A phone bill of ₹599 might be ₹399 of need and ₹200 of extra data you would drop if money were tight. Splitting every item is overkill, so only split the ones above a rupee amount you choose, say ₹500, and label the rest by their main purpose. The aim is a number you trust enough to act on, not an audit.
Check your split once a quarter. Items drift: a streaming service you started as a treat can become part of the household routine, and a need like transport can include taxis you could replace.
What should you do with the result?
- Write the split for three months in a row.
- Look for needs that crept up, like transport.
- Decide a wants amount you are happy with, and plan it before the month starts.
- Move any leftover to savings on the day it is clear.
Does it change for freelancers, students, couples or NRIs?
Freelancers should put work costs in a third group, since they are neither. Students may have a small needs total and a larger share of wants, which is fine. Couples can agree on one list so the split is the same for both. NRIs sending money home can label that as a need or a family item, whichever they use consistently.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

