How to Make a Monthly Budget in India

PERSONAL FINANCE · PRACTICAL GUIDE

Your salary can look sufficient on payday and still feel tight by month-end. A practical budget helps you understand what is coming in, where your money is going, and how much you are setting aside for your future.

This guide explains how to make a monthly budget in India, track UPI and card expenses, plan EMIs and SIPs, and build a simple budgeting system using Excel.

How to Make a Monthly Budget in India

Creating a monthly budget does not need complicated formulas or hours of financial planning. Start with your take-home income, divide your money into practical categories, and compare your planned spending with your actual expenses.

1. Start with your monthly take-home salary.
2. List fixed bills, daily expenses, EMIs and savings goals.
3. Set a realistic budget for each category.
4. Track purchases made through UPI, cash and cards.
5. Review your actual spending every week.

The objective is not to predict every rupee perfectly. It is to understand your money well enough to make better decisions.

Why Monthly Budgets Often Stop Working

Most budgets do not fail because the arithmetic is difficult. They fail because people stop recording expenses or create a plan that does not reflect their everyday lives.

1. Small UPI payments add up

Tea, snacks, food delivery, shopping and cab rides can seem inexpensive individually. When combined over a month, these purchases can take up a significant part of your spending money.

2. Recurring bills get forgotten

Rent, subscriptions, loan EMIs, insurance and investments may be paid on different dates. Keeping track of their amounts and due dates helps you plan for upcoming payments.

3. Irregular expenses disrupt the plan

Festivals, travel, repairs, gifts and annual bills can create unexpected pressure if you plan only for routine monthly expenses.

4. Your bank balance does not explain everything

Your bank balance tells you how much money remains. Categorised expense records help you understand where it went and which spending habits you may want to change.

Step 1: Calculate Your Actual Monthly Income

Start with your take-home salary, which is the amount you receive after applicable deductions. Do not create your monthly budget using your full CTC if you receive a smaller amount in your bank account.

If you earn bonuses, commissions or freelance income, use a conservative estimate instead of assuming every month will be equally profitable.

Step 2: Organise Your Expenses into Categories

Choose categories that reflect your actual lifestyle. You can always add more detail as your budgeting habits improve.

Needs and essential bills

Rent, groceries, electricity, mobile bills, internet, transport, healthcare and insurance.

Debt and fixed commitments

Home, vehicle and personal-loan EMIs, along with other repayment obligations.

Wants and lifestyle

Eating out, Zomato or Swiggy orders, shopping, entertainment, subscriptions and hobbies.

Savings and investments

Emergency savings, SIPs, PPF, recurring deposits and money set aside for financial goals. Choose investments according to your circumstances and risk tolerance.

Irregular expenses

Travel, festivals, gifts, home repairs and other expenses that do not happen every month.

Step 3: Create a Monthly Budget Using a ₹50,000 Salary

Suppose your monthly take-home salary is ₹50,000. Here is an illustrative budget showing how you could assign a purpose to your income.

These figures are examples, not a universal recommendation. Your actual budget will depend on your city, rent, family responsibilities, debts and other commitments.

You may have heard of the 50/30/20 budgeting rule: 50% for needs, 30% for wants and 20% for savings. It can be a useful starting point, but it will not fit every household. Adjust the percentages to suit your real expenses.

Step 4: Compare Your Planned Budget with Actual Spending

A budget becomes useful when you compare your plan with what actually happened. Create a table with your categories, planned amounts, actual spending and remaining budget.

In Excel, if your planned amount is in cell B2 and actual spending is in cell C2, enter this formula in the remaining column:

A positive result means you are below budget. A negative result means you have exceeded the planned amount. Use this information to decide whether to adjust the category or change your spending.

Step 5: Track UPI, Cash and Credit-Card Expenses Correctly

Record your purchases consistently, either when you make them or during a scheduled weekly review.

Count each purchase only once

If you purchase groceries using UPI, record the grocery expense once. Do not record it again when you see the same payment in your bank statement.

Separate transfers from actual expenses

Moving money between your own accounts is not a new expense by itself. Record the actual purchase when the money is spent.

Avoid credit-card double-counting

Record a credit-card purchase in the relevant category when you make it. Treat the later card-bill payment as settlement of the card balance, not as another purchase expense.

Step 6: Plan Recurring and One-Off Transactions

Recurring payments such as rent, subscriptions, EMIs and scheduled investments should be included in your regular planning. Record their expected amounts and due dates so that you can prepare for upcoming commitments.

One-off expenses include unexpected repairs, occasional shopping and medical costs. Record them in the appropriate categories and note whether they were planned or unexpected.

You can also prepare for expenses that occur only once or twice a year. For example, if you expect a ₹12,000 expense in twelve months, setting aside ₹1,000 each month could help you prepare for it, provided that amount fits your budget.

Step 7: Review EMIs, Investments and Net Worth

A complete budgeting system should help you understand more than your daily purchases.

• Debt tracking: Review EMI amounts, payment dates and outstanding balances.
• Savings tracking: Check whether you have set aside the money you planned for your financial goals.
• Net worth: Compare what you own, such as cash and investments, with what you owe.
• Annual summaries: Review patterns across several months instead of looking only at the latest bank balance.

Keep your financial records private. Never enter banking passwords, PINs or OTPs into a budgeting spreadsheet.

Step 8: Build a Simple Weekly Budgeting Routine

Every week

• Record any missing transactions.
• Review upcoming bills and EMIs.
• Check which categories are moving faster than expected.
• Choose one realistic adjustment for the next week.

At the end of each month

• Compare planned and actual spending.
• Review your savings progress.
• Identify expenses you forgot to plan for.
• Use what you learned to prepare next month's budget.

A simple system that you maintain for twelve months is more useful than a complicated tracker that you abandon after two weeks.

Frequently Asked Questions

How do I make a monthly budget with a ₹30,000 salary?

Start with your take-home income, list essential bills and EMIs, and allocate realistic amounts for everyday spending, savings and irregular expenses. If essential costs leave little room, make gradual adjustments rather than forcing a fixed percentage split.

Is the 50/30/20 rule suitable for everyone in India?

No. It is a starting framework, not a strict rule. Housing costs, family responsibilities, income stability and debt vary between households, so adapt the percentages to your circumstances.

How often should I update my expense tracker?

You can record expenses daily or update the tracker during a weekly review. Choose a routine you can maintain consistently.

Should I count my credit-card bill as an expense?

Record each purchase under its relevant spending category. Treat the later bill payment as settlement of the credit-card balance to avoid counting the same purchase twice.

Can an Excel budget tracker guarantee that I will save more?

No. A tracker can make spending and progress more visible, but your results depend on your income, expenses, decisions and consistency.

Final Thoughts

A good monthly budget is not about saying no to everything. It is about deciding where your money should go before it disappears into bills, small payments and forgotten commitments.

Start with a few categories, track actual spending, and review your plan regularly. Small, consistent improvements can help you understand your finances and make more informed decisions over time.

Disclaimer: This article is for general educational purposes only and is not personalised financial, tax or investment advice. Consider your circumstances and seek qualified advice where needed.

Further reading: SEBI Investor — Management of Income and Expenses