How to Track Monthly Expenses: 5 Simple Methods That Work
How to track monthly expenses in India using bank and UPI statements, a spreadsheet or an app. Includes a 30-day method, category template and a worked example.

In this article
The easiest way to track monthly expenses is to use your bank, credit card and UPI statements as the master record, tag every transaction into 8-12 categories once a week or once a month, and compare the totals with your budget. A simple spreadsheet is enough; apps can speed it up. Most people discover 10-15% of spending they cannot explain in the first month, and that is where the savings come from.
Why tracking matters before budgeting
A budget is a plan; tracking tells you whether the plan is real. Without knowing where money actually goes, it is hard to set limits in a salary budget or apply a framework like the 50-30-20 rule. Tracking also reveals:
- Small, frequent spends such as food delivery and quick-commerce orders
- Forgotten subscriptions and auto-debits
- Annual costs you did not plan for
- Fraudulent or unknown debits that should be reported to your bank immediately
Five methods to track expenses
| Method | Effort | Accuracy | Best for |
|---|---|---|---|
| Monthly statement review | Low (30-45 min/month) | High for digital spends | Most salaried people |
| Spreadsheet (Google Sheets / Excel) | Medium | High | People who like control |
| Expense tracker app | Low to medium | High if accounts are linked | Busy people, couples |
| Daily notes on phone | Medium | Medium | Cash-heavy households |
| Envelope / fixed allowance | Low | Medium | Controlling wants and cash |
1. Monthly statement review
Download last month's statements for every bank account and credit card. Because UPI payments from PhonePe, Google Pay, Paytm or BHIM are all debited from a linked bank account, the bank statement captures them in one place. Go line by line and tag each one.
2. Spreadsheet
Create columns: Date, Description, Amount, Category, Need/Want, Payment mode. Most banks let you download statements as Excel or CSV, so you can paste them in and add only the category. A pivot table or SUMIF gives totals by category in seconds.
3. Expense tracker apps
Many apps read transaction SMS or link to bank accounts to auto-categorise spending. Some use the RBI-regulated Account Aggregator framework, where you share statements through an NBFC-AA only after explicit consent. Before installing:
- Prefer apps from established companies or your own bank.
- Check permissions; an expense app should not need contacts or photos.
- Never share OTPs, UPI PINs or passwords. If you suspect fraud, report it on cybercrime.gov.in or call 1930.
4. Daily notes
If much of your spending is in cash, note each spend in a phone note or a small notebook the same day. It is tedious, but two to three months of notes are usually enough to understand your pattern.
5. Envelope or fixed allowance
Decide a fixed amount for a category, for example ₹1,500 a week for eating out, and stop when it is gone. You can do this digitally by moving the amount to a separate account or a prepaid wallet.
Choosing your categories
Keep it to 8-12 categories. A starting template:
| Category | Type | Examples |
|---|---|---|
| Housing | Need | Rent, maintenance, home loan EMI |
| Groceries and household | Need | Kirana, supermarket, quick-commerce essentials, house help |
| Utilities | Need | Electricity, gas, water, mobile, broadband |
| Transport | Need | Fuel, metro, cabs, vehicle service |
| Loans and EMIs | Need | Personal loan, car loan, credit card EMIs |
| Insurance and health | Need | Premiums, medicines, doctor visits |
| Education and children | Need | Fees, tuition, books |
| Eating out and delivery | Want | Restaurants, food apps |
| Shopping and lifestyle | Want | Clothes, gadgets, personal care |
| Entertainment and subscriptions | Want | OTT, gaming, events |
| Travel and gifts | Want | Trips, festivals, weddings |
| Savings and investments | Saving | SIPs, RDs, PPF, emergency fund |
A 30-day starter plan
- Day 1: Download the last 1-3 months of statements for all accounts and cards.
- Day 2: Set up your spreadsheet or app with the categories above.
- Days 3-4: Tag last month's transactions. Mark anything you cannot identify.
- Day 5: Investigate unknown debits. Report unauthorised ones to your bank at once; under RBI rules, prompt reporting limits your liability for unauthorised electronic transactions.
- Weekly: Spend 10 minutes tagging the new week's spends.
- Day 30: Total each category, compare with your plan, and pick one or two changes.
Worked example: finding the leaks
Neha earns ₹65,000 in hand in Hyderabad. She thought she spent about ₹40,000 a month. Her first tracked month showed:
| Category | Amount (₹) |
|---|---|
| Rent | 15,000 |
| Groceries and household | 7,500 |
| Utilities | 2,800 |
| Transport (cabs, metro) | 4,200 |
| Personal loan EMI | 5,500 |
| Eating out and food delivery | 6,800 |
| Shopping | 4,500 |
| Subscriptions (5 OTT/music/apps) | 1,700 |
| Unexplained small UPI spends | 3,000 |
| Total spending | 51,000 |
| Left for savings | 14,000 |
She was spending ₹11,000 more than she believed. Her changes:
- Cut food delivery from ₹6,800 to ₹4,000: saves ₹2,800
- Cancel three unused subscriptions: saves ₹900
- Set a ₹1,500 weekly cash/UPI allowance for small spends, bringing them down by about ₹1,300
Total freed up: ₹2,800 + ₹900 + ₹1,300 = ₹5,000 a month. Invested through an SIP for 10 years at an illustrative 10% a year (not guaranteed), ₹5,000 a month would grow to roughly ₹10.3 lakh on ₹6 lakh invested. Try your own numbers on the SIP calculator.
Tips to keep the habit going
- Fix a day. For example, every Sunday evening or the 1st of each month.
- Use one primary account and one credit card for daily spends, so there are fewer statements to check.
- Do not chase every rupee. Round off and lump small cash spends; consistency matters more than precision.
- Track as a couple. A shared sheet or app avoids surprises and duplicate spending.
- Track debt too. Note outstanding balances and interest rates on loans and cards. If EMIs feel heavy, check options with the EMI calculator and read about paying off debt vs investing.
What to do with the data
After two or three months of tracking, you will know your real average spend. Use it to:
- Set a realistic budget with category limits.
- Calculate your emergency fund target from actual essential expenses.
- Plan annual expenses by dividing yearly costs into monthly set-asides.
- Raise SIPs or goal savings with the money you free up.
Key takeaways
- Use bank and card statements as your master record; they capture all UPI payments from every app.
- Keep 8-12 categories and tag spends weekly or monthly.
- A spreadsheet is enough; apps help, but check permissions and never share OTPs or PINs.
- Expect to find 10-15% of spending you did not know about in the first month.
- Turn what you find into one or two specific changes and redirect the savings automatically.
Frequently asked questions
What is the easiest way to track monthly expenses?
For most people, the easiest method is a monthly review of bank, credit card and UPI statements, tagging each transaction into 8 to 12 categories in a spreadsheet. It takes about 30 to 45 minutes a month once set up.
How do I track UPI expenses across multiple apps?
UPI payments from any app are debited from your linked bank account, so your bank statement captures all of them in one place. Use the statement, not each app's history, as your master record, and add notes for unclear merchant names.
Are expense tracker apps safe to use?
Use apps from reputed developers, check what permissions they ask for, and avoid giving SMS or account access to unknown apps. Never share OTPs, UPI PINs or net banking passwords with any app or caller.
How many expense categories should I use?
Between 8 and 12 categories is enough for most households. Too few hides leaks, and too many makes tracking tedious, which is the main reason people give up.
How should I track cash spending?
Record cash withdrawals as a single line and either note large cash purchases on your phone the same day, or set a fixed weekly cash allowance and treat it as one category.
This article is for general education and is not personalised financial, tax or legal advice. Rates and rules are as of 19 Oct 2026; confirm current terms with your lender, AMC or a qualified adviser.


