How to track your personal expenses
To track your expenses, record each payment, sort it into a few categories and total each category at month end. A notebook, envelopes, a spreadsheet or an app all work. Pick the one you will keep using, then compare each month's totals with what you planned.
In this guide
Key takeaways
- A notebook, envelopes, a spreadsheet and an app all track spending. The one you keep up is the right one.
- Rohan's month shows how small spends add up: 14 UPI food orders at ₹380 each come to ₹5,320.
- Four subscriptions of ₹119, ₹130, ₹499 and ₹399 come to ₹1,147 a month, or ₹13,764 a year.
- Your bank must warn you at least 24 hours before a card or UPI auto-debit, and you can cancel the mandate.
- Before using an expense app, ask what it reads, whether it can move money, what it costs and whether you can delete your data.
To track your expenses, write down every rupee that goes out, sort it into a few categories, and total each category at the end of the month. Then you can set what you spent against what you planned. A notebook, labelled envelopes, a spreadsheet and an app all do this job. The method matters less than whether you will still be using it in March.
Why track your expenses?
You cannot change spending you cannot see.
Two kinds of spending are easy to miss: small UPI payments and subscriptions that renew every month.
Take Rohan, a 28-year-old in Gurugram. He tracks one month in a spreadsheet. Two lines surprise him. Fourteen food orders on UPI, averaging ₹380 each, come to ₹5,320. Four subscriptions come to ₹1,147 a month, or ₹13,764 a year: ₹119 for music, ₹130 for cloud storage, ₹499 for video streaming and ₹399 for a fitness app. Neither figure is wrong or wasteful in itself. Rohan simply had never added them up.
Track income too, including side income. The gap between what comes in and what goes out is the part you can plan with.
What are the ways to track expenses?
Here are four ways, from a notebook to an app. Each trades effort against convenience.
| Method | How it works | Suits | Effort | Watch out for |
|---|---|---|---|---|
| Notebook or diary | You write each spend by hand, ideally the same day | People who like pen and paper and spend through a few channels | Daily, but each entry is a few seconds | Totals are by hand, and a missed week leaves a gap |
| Envelope method | You split spending money into labelled envelopes (or app "pots") and spend each category only from its own | Cash-heavy spending, or anyone who wants a hard limit per category | Low once the envelopes are filled | An empty envelope shows a limit, but not what you bought |
| Spreadsheet (Excel or Google Sheets) | One row per spend, with formulas that total each category | People who want their own categories and a monthly summary | Entering rows, ideally every day or two | Falls behind if you leave a fortnight of entries |
| App | Software that records your spends, sometimes by reading messages or linking accounts | People who want less typing | Lowest for entry, but you must review what it records | What it can read and where your data goes (see below) |
The envelope method works partly through what is called mental accounting: treating money differently depending on where it came from or which "pot" it sits in. Money in the "groceries" envelope feels like groceries money and nothing else.
You can also mix them, for example envelopes for cash and a spreadsheet for everything else.
What categories should you track?
Use a short list that matches how money leaves your account. Here is a starting list with Indian spending in mind:
- Rent, or the home loan EMI (the fixed amount paid each month that covers interest and part of the loan)
- Groceries
- Utilities and phone
- Commute and fuel
- Eating out and food delivery
- Shopping
- Health
- Money sent home
- Subscriptions
- Loan and credit card repayments
- Savings and investments
- Yearly costs you set aside for, such as insurance premiums or festival travel
Fixed costs are the same every month, such as rent or an EMI. Variable costs change with what you do, such as food delivery or shopping. Seeing the two apart shows how much of your month is already committed before you spend anything.
A budget is a plan for what you will spend and what you will keep aside each month. Tracking tells you what really happened, and the budget is what you compare it with.
How do you set up an expense tracker in a spreadsheet?
Make one sheet with one row per spend, and a second sheet that totals each category for the month. That is the whole design.
The first sheet needs five columns:
- Date: the day you paid.
- Amount: in rupees, as a number with no ₹ symbol typed into the cell, so the sheet can add it up.
- Category: picked from your list above, spelled the same way every time.
- Paid by: UPI, card or cash.
- Note: a few words, such as "dinner with friends" or "auto to office".
On the second sheet, list your categories down one column. Next to each, use a formula that adds up every amount in the first sheet whose category matches. In both Excel and Google Sheets this is the SUMIF formula, which adds only the rows that meet a condition. Add a row for income and one for the difference.
Rohan's ₹5,320 on food orders showed up this way, as a category total next to groceries and rent.
Fill in the sheet every day or every second day, so the small spends do not slip past. Your bank statement and UPI app history can fill gaps, and the "paid by" column tells you which one to check.
What should you check before using an expense-tracking app?
Check what the app reads, whether it can move money, what it costs, and whether you can delete your data. Questions worth asking before you install:
- Does it read your SMS? Look at the permission it asks for on your phone, and ask why it needs it.
- Can it move money, or only read data? An app that only reads your records is a different thing from one that can start a payment.
- Does it ask for your bank login or card details? Ask why it needs them.
- What does it cost? Look for a paid tier, and for a plan that renews on its own. A card or UPI renewal runs on a mandate, covered in the subscriptions section below.
- Can you delete your data, and how? Look for a delete-account option, and what the app says it does with your records afterwards.
- Who is behind it? Look for a company name, a privacy policy and a way to reach support.
If you are unsure, you do not need an app. A notebook or a spreadsheet works without giving anyone access to your messages or accounts. Our guide on how to protect yourself from online and banking fraud covers the habits that keep an account safe, whichever tool you use.
How do you find subscriptions you have forgotten?
Look for recurring debits on your card and bank statements, and in your UPI app's list of mandates. A mandate is your standing approval for a company to take a payment on a schedule.
Every card or UPI subscription runs on a mandate you approved once. An e-mandate is that approval given electronically. It is registered only after an extra check on your identity, called additional factor of authentication. Your bank or card issuer must warn you at least 24 hours before each debit. You can opt out of a particular payment or the whole mandate. You can also change how long it runs or withdraw it at any point.
For UPI, the system is called UPI Autopay. Under NPCI's circular of 7 October 2025, UPI payer apps must show all your active mandates in one list, alongside existing options such as revoke, pause and modify. Any such change you make needs your UPI PIN.
So the routine is short:
- Open your UPI app and look at the list of active mandates.
- Go through recent card and bank statements for repeating amounts.
- For each one, decide whether you still use it, and keep or cancel it.
India's Central Consumer Protection Authority issued guidelines on 30 November 2023 listing 13 dark patterns in e-commerce. "Subscription trap" and "drip pricing" are both on the list, and the guidelines treat dark patterns as unfair trade practices. To complain about a company, the National Consumer Helpline takes complaints on the toll-free number 1915, through its app and at consumerhelpline.gov.in.
What do you do with a month of tracking?
Compare it with a plan and decide what to change. One full month shows a pattern. Do not judge it by one week.
Look at your fixed costs, your variable costs and the small repeating ones like Rohan's. Then pick a way to plan the next month:
- Zero-based budgeting gives every rupee of income a job before the month starts.
- The 50-30-20 rule is a rule of thumb that splits take-home pay (what reaches your account after deductions) into needs, wants and saving.
- Ways to save money from your salary shows how to start saving the day the salary lands.
- If tracking shows spending you did not plan, how to stop impulse buying covers ways to stop it.
- Loud budgeting has an article of its own. For the wider picture, read how to manage your money.