This simple free excel sheet Small Business Budget Template for Indian MSMEs helps you Planning, Tracking, and Controlling Your Business Expenses specialy made for Indian MSMEs
As a business owner you track your sales. But when it comes to planning your monthly expenses, most Small & Medium Business (SMBs) business owners either skip it or do it  on assumptions.
Unplanned expenses are one of the top reasons MSMEs still face profitability  problems.
Most budgeting tools are designed by finance experts for large corporate teams. They are filled with jargon, complex formulas, expense planning with revenue forecasting and financial ratio analysis, making them complicated
This template keeps things focused: it is primarily an expense planning and tracking tool  .
If you are familiar with the budgeting excise you can go straightaway to the bottom of the page and click download  button  and start using the sheet , if you want to understand the sheet before using, then the below guide helps you
What Is Business Budgeting , In Simple Terms?
Budgeting is a simple exercise, writing down, how much money you are planning to spend every month for your business.
The Government of India tables a Union Budget every year before Parliament. Large companies do annual operating budgets before their financial year begins. Both are doing the same thing , planning future expenses so they can be monitored, compared, and controlled.
 Small and Medium Businesses should follow  the same discipline to become large organizations.
Inside the Excel Template:
The Excel file contains four worksheets. Here is a summary of each:
| Sheet | Purpose | Who Updates It |
| Sheet 1: Business Expense BUDGET | Enter planned monthly expenses before the financial year begins | Business Owner / Management |
| Sheet 2: Business Expense ACTUAL | Enter actual amounts spent at end of each month | Accountant / Finance Executive |
| Sheet 3: Business Expense VARIANCES | Auto-calculates gap between budget and actual | Auto-populated , no input needed |
| Sheet 4: Business Expense ANALYSIS | Visual dashboard with charts and category-level summary | Auto-populated , no input needed |
Sheet 1: Business Expense BUDGET , Your Monthly Expense Plan
This is where you begin. Before the beginning of your financial year, you fill in how much you expect to spend under each category. The sheet covers 12 months from April to March, aligned with the Indian financial year. A yearly total column is automatically calculated on the right.
Expense categories covered in this sheet:
| Expense Category | What It Covers |
| Employment (Permanent) | Salaries, wages, bonus pay, advances, benefits, ESI/PF, insurance |
| Employment (Casual) | Contractual staff, daily wages, freelancer payments |
| General / Admin | Office supplies, software, subscriptions, professional fees |
| Operations | Equipment maintenance, utilities, logistics, transport |
| Marketing / Promotions | Advertising, events, digital marketing, branding costs |
| Materials Purchase | Raw materials, packaging, inventory replenishment |
| Occupancy | Rent, building maintenance, property taxes |
| Automotive | Fuel, vehicle servicing, driver costs |
| Additional Expenses | Any business costs that do not fit other categories |
Each category has multiple sub-rows. Rows labelled 'Other' can be renamed to match your specific expense items. Nothing is locked , just click and type.
Sheet 2: Business Expense ACTUAL , What You Actually Spent
At the end of each month, your accountant or finance executive fills in the actual amounts spent under each line item. The structure mirrors Sheet 1 exactly, making comparison easy. Once updated, Sheets 3 and 4 automatically recalculate , no additional action required.
Sheet 3: Business Expense Variances , Auto-Calculated Gap Analysis
This sheet does all the maths for you. For every line item and every month, it calculates: Budget Amount minus Actual Amount. A positive number means you spent less than planned (favourable). A negative number means you overspent (unfavourable).
Example: How the Variance Sheet Works
| Item | Amount (Rs.) |
| Budgeted Salary , April | 50,000 |
| Actual Salary , April | 54,000 |
| Variance (Budget minus Actual) | -4,000 (Unfavourable , overspent) |
You now know exactly where to investigate and correct course. There is nothing to fill in here , every figure is auto-populated.
Sheet 4: Business Expense ANALYSIS , Your Visual Dashboard
This is the most powerful sheet in the template. It summarises all your expense categories in one place:
| Column | What It Shows |
| Total Budgeted Amount | Full-year planned spend per expense category |
| Total Actual Amount | Full-year actual spend per expense category |
| Variance Amount | Difference between budgeted and actual |
| Percentage of Variance | How far off the budget you were, as a percentage |
| Charts | Visual plot of budget vs actuals across all categories |
This dashboard is built to be reviewed in a monthly management meeting or shared with your CA or banker , it updates itself as data is entered, with no preparation needed.
How to Download and Use This Template in 5 Simple Steps
- Download the Excel file and save it in your company name and financial year (e.g., ABC Company Budget FY2026-27.xlsx).
- Open Sheet 1 (Business Expense BUDGET) and fill in your projected monthly expenses for each category. Start with the categories you are most certain about , payroll, rent, utilities.
- Rename any 'Other' rows to match your specific expense items. Add new rows if needed by inserting them within the existing category blocks.
- At the end of each month, ask your accountant to update Sheet 2 (Business Expense ACTUAL) with real figures from your books.
- Review Sheet 4 (Expense Analysis Dashboard) at your monthly review meeting. Discuss any categories with significant variances and decide on corrective action.
That is the entire workflow. Most business owners find they can complete the initial setup in under two hours. Now you can go and download the sheet and start using it.
In case you want to know the benefits of doing a budgeting exercise to discuss with your team, here are the 5 top benefits we have seen in GreatWorks Consulting.
The Biggest Benefit of Budgeting for MSMEs
The  benefit of budgeting is clarity. When you compare planned expenses with actual expenses, you immediately know whether spending is under control, whether the business is overspending, and which departments are consuming more resources.
Match this data  with net sales performance, this gives the business owner a much clearer picture of the overall financial health of the company so you can take  better decisions and control over the business.
If you are doing budgeting for the first time, it may feel slightly difficult , that is completely normal. But once you spend some time filling the template, you will start seeing expense patterns, spending discipline,.
Many business owners say they feel relieved once they start using a structured budgeting system.
Tips for Getting the Most Out of budgeting exercise
| Tip | Why It Matters |
| Review every month without fail | A budget updated quarterly loses its value. Monthly reviews create real control. |
| Do not try to be perfect on Day 1 | Your first budget will have gaps and guesses. It gets better every month as you understand your own patterns. |
| Involve your accountant early | If your CA or accounting team understands how this sheet works, they can feed data into it as part of their monthly close process. |
| Use the dashboard in management meetings | Spend 15 minutes every month reviewing the charts with your team. That discipline alone will change how your business manages money. |
| Compare year-on-year | Once you have 12 months of data, your second-year budget will be far more accurate , based on real history, not estimates. |
Download the Free Business Budget Template Now
This template is available as a free download , the same file we use in our consulting assignments with MSME clients across India.
No email subscription required.  Just a practical tool made  for the benefit of all Small & Medium business in Tamil Nadu and India .
Just in case if you need help using this  the template , or if you have questions about how to use it, reach out to us through the Contact Us page. Our team will be happy to assist you.
