Getting started

How do I categorise my expenses properly? Rent, EMI and groceries sorted

A forum-style answer on how to categorise personal expenses in India: seven groups, five steps and a worked salary example so rent, EMI and groceries stop blurring.

Editorial illustration for How do I categorise my expenses properly? Rent, EMI and groceries sorted

Categorising expenses so that salary, rent, EMI and groceries stop looking like one confusing list: how is it done? Short answer: do not invent thirty categories. Use six or seven broad groups, put each transaction in exactly one, and keep income and savings out of the spending list. Here is the way we would set it up, step by step.

Step by step, as we would do it

  1. Pull last month's bank and card statements into one list. A CSV or spreadsheet export from your bank is fine.
  2. Strike out the rows that are not spending: salary coming in, transfers between your own accounts and the payment you make to clear a credit card. Otherwise the same rupees get counted twice.
  3. Create seven groups: Housing, Loans, Food, Transport and phone, Family, Savings, and Everything else.
  4. Go through the rows and give each one a group. Recurring ones first, since they are the easiest.
  5. Total each group, and divide by your income so you can see its share.

What does that look like with real numbers?

Say a salary of ₹62,000 lands on the 1st. These figures are invented, so use your own.

GroupWhat went inAmount
HousingRent 18,000, maintenance 1,500, electricity 1,850₹21,350
LoansTwo-wheeler EMI₹4,200
FoodGroceries 7,200, eating out 3,400₹10,600
Transport and phoneFuel 2,100, recharge and broadband 1,150₹3,250
FamilyParents₹5,000
SavingsTransfer to a savings account₹8,000
Everything elseShopping, medicine, outings₹9,600
TotalEvery group together₹62,000

Add them up: 21,350 plus 4,200 plus 10,600 plus 3,250 plus 5,000 plus 8,000 plus 9,600 equals 62,000, so every rupee of the salary has a home. Housing is about a third of the salary, since 21,350 divided by 62,000 is a little over 34 percent.

Where does EMI go?

Put it in Loans, not in the category of whatever you bought. A phone EMI is a loan repayment; the phone itself is not a monthly grocery-style expense. Keeping EMIs in one group means you can see your fixed obligations at a glance. If you have a home loan, split it only if you want to: one line for the instalment, kept together.

What about UPI payments to people?

These are the ones that confuse most. A payment to a friend can be your share of dinner, rent to a flatmate or a loan. The statement shows only a name, so open the row and decide by what you remember. If you cannot tell, tag it Everything else and add a note. A habit of adding the note at the time saves a lot of guessing later.

Can software do this?

Yes, to a point. SpendixAI has default categories and a two-level category tree, so you can have Food with Groceries and Eating out inside it, and you review rows before saving an import. It is not magic, and some rows will need your decision, particularly the person-to-person UPI ones. A spreadsheet works fine to start.

How many categories are too many?

If you cannot remember them without looking, you have too many. Seven groups is a good start. Once a group such as Food gets large enough to hide detail, split it in two, Groceries and Eating out, and stop there. Resist adding a category for every unusual month. A rare item can go in Everything else with a note, and you can look at it again if it keeps coming back.

What we would do next

  • Do this for one month before changing anything.
  • Look at the biggest group and ask if it surprises you.
  • Do it again next month with the same groups, so the months can be compared.
  • Add a subcategory only when one group grows too big to read.
SPENDIXAI JOURNAL

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

Explore your reports