A small business budget template turns a vague annual goal into a month-by-month plan for revenue, costs, investment and cash. Many Indian MSMEs operate without a written budget, relying on the owner's sense of the business. That works until the business grows past the point where one person can see everything. A budget makes trade-offs explicit, gives managers spending limits, and creates a baseline to measure performance against. This guide gives you a ready template structure, a full worked example, how to phase it across the year, how to analyse variances properly and the mistakes that make budgets useless.
What a Complete Small Business Budget Includes
A complete budget has five linked parts:
- Revenue budget: volume and price by product line, customer group or branch, by month.
- Cost of sales budget: material, direct labour and production overheads linked to the revenue plan.
- Operating expense budget: salaries, rent, marketing, admin, IT, travel, by department or cost centre.
- Capital expenditure budget: machines, vehicles, fit-outs and software, with timing and funding source.
- Cash budget: converts the above into cash timing, including credit terms, GST, loan repayments and tax.
The first three give a budgeted profit and loss. The fourth and fifth show whether you can fund the plan.
Small Business Budget Template: Annual P&L
Here is a worked template for a hypothetical corrugated box manufacturer in Vapi planning ₹6 crore of revenue:
| Line item | Annual budget (₹ lakh) | % of revenue | Basis of estimate |
|---|---|---|---|
| Revenue | 600 | 100.0% | Customer-wise volume x price |
| Raw material (kraft paper, adhesives) | (330) | 55.0% | Bill of materials x volume, current paper prices plus 3% |
| Direct labour | (48) | 8.0% | Headcount plan x wage rates |
| Power and fuel | (24) | 4.0% | Units per tonne x tariff |
| Gross profit | 198 | 33.0% | |
| Staff salaries (non-production) | (54) | 9.0% | Named headcount plus increments |
| Rent | (18) | 3.0% | Lease agreement |
| Sales and marketing | (15) | 2.5% | Planned activities |
| Freight outward | (21) | 3.5% | Per tonne rate x volume |
| Admin, IT and professional fees | (12) | 2.0% | Contracts and estimates |
| Repairs and maintenance | (6) | 1.0% | History plus planned overhauls |
| EBITDA | 72 | 12.0% | |
| Depreciation | (15) | 2.5% | Asset register plus new capex |
| Interest | (12) | 2.0% | Loan schedules and expected limit usage |
| Profit before tax | 45 | 7.5% |
The "basis of estimate" column is the most important part of the template. A number without a basis is a guess; a number with a basis can be challenged, improved and tracked.
Step-by-Step: Building the Budget
- Start with last year's actuals by month, cleaned of one-offs such as a large insurance claim or a one-time bad debt.
- Build revenue bottom-up. List your top 20 customers with expected volumes and prices, then estimate the rest as a group. Add new customers only with a named pipeline.
- Link variable costs to volume. Material, power, freight and commissions should flow from the revenue plan using per-unit rates, not as last year plus 10%.
- Build fixed costs line by line. Use the headcount plan with names or positions, rent agreements with escalation dates, annual maintenance contracts and planned increments.
- Add capex with timing. A ₹40 lakh printing machine in October adds depreciation from October and needs funding before then.
- Convert to cash. Apply customer credit terms, supplier terms, GST payment timing, EMI schedules and advance tax dates. See our 13-week cash flow forecast for the short-term view.
- Review and challenge. Does the plan meet the owner's profit target? If not, decide which levers to pull: price, mix, cost or growth.
- Agree and assign owners. Each line has someone responsible for it.
Phasing the Budget by Quarter and Month
An annual figure divided by 12 is not a budget. Seasonality, price changes, hiring dates and capex timing must be reflected. For the box manufacturer, demand rises before the festive season:
| Quarter | Share of annual revenue | Revenue (₹ lakh) | Notes |
|---|---|---|---|
| Q1 (Apr to Jun) | 20% | 120 | Slow season, annual maintenance shutdown |
| Q2 (Jul to Sep) | 25% | 150 | Festive pre-orders begin |
| Q3 (Oct to Dec) | 30% | 180 | Peak demand; new machine live |
| Q4 (Jan to Mar) | 25% | 150 | Year-end push |
| Total | 100% | 600 |
Fixed costs such as rent and salaries stay roughly flat each month, so profit is weaker in Q1 and stronger in Q3. Without phasing, the owner would panic in June and overspend in November.
Variance Analysis: Using a Flexible Budget
Comparing actuals with a fixed budget can mislead when volume differs from plan. A flexible budget restates variable costs at actual volume, separating volume effects from efficiency or price effects.
In Q1, the box manufacturer achieves ₹112 lakh of revenue against a budget of ₹120 lakh. Raw material cost is ₹64.4 lakh against a budget of ₹66 lakh.
| Item (₹ lakh) | Fixed budget | Flexible budget at actual revenue | Actual | Variance vs flexible |
|---|---|---|---|---|
| Revenue | 120.0 | 112.0 | 112.0 | None |
| Raw material (55%) | 66.0 | 61.6 | 64.4 | 2.8 adverse |
| Staff salaries (fixed) | 13.5 | 13.5 | 14.2 | 0.7 adverse |
Against the fixed budget, material looks ₹1.6 lakh favourable. Against the flexible budget, it is ₹2.8 lakh adverse: material consumed 57.5% of revenue instead of 55%. The real story is a paper price increase or higher wastage, plus a revenue shortfall of ₹8 lakh. The owner now knows to investigate both, rather than celebrating lower material spend.
Variance reporting rules of thumb
- Report variances monthly, within 10 days of month end
- Investigate any line with variance above 5% or a set rupee threshold
- Ask the line owner for a one-line explanation and an action
- Separate timing variances (spend moved to next month) from permanent ones
Incremental vs Zero-Based Budgeting
Incremental budgeting takes last year's figures and adjusts them. It is quick but carries forward waste. Zero-based budgeting requires every expense to be justified from scratch. It uncovers waste but is time-consuming. A practical middle path for MSMEs: use incremental budgeting for most lines, and apply zero-based review to two or three discretionary categories each year, such as marketing, travel or software subscriptions.
Rolling Forecasts
A budget is set once a year; reality changes monthly. Many businesses keep the annual budget as the target but maintain a rolling forecast, updated quarterly, showing the expected full-year outcome. If the rolling forecast falls short of budget by June, there is still time to act. Combine it with the KPIs in our guide to financial KPIs for small business.
Common Budgeting Mistakes
- Top-down revenue wishes such as "grow 30%" without customer-level support
- Dividing annual numbers by 12 and ignoring seasonality
- No cash budget, so a profitable plan runs out of money in the peak season
- Budgets nobody owns, prepared by the accountant alone
- Never comparing actuals, so the budget is filed and forgotten
- Ignoring known cost escalations such as rent increases, minimum wage revisions and salary increments
- Treating the budget as permission to spend even when revenue falls short
Budget Preparation Checklist
- Last 12 months actuals by month, cleaned of one-offs
- Customer-wise revenue plan with volumes and prices
- Per-unit variable cost rates updated for current input prices
- Headcount plan with joining dates and increments
- Rent, AMC and contract schedules
- Capex list with timing and funding
- Monthly phasing reflecting seasonality
- Cash budget including GST, TDS, EMIs and advance tax
- Owners assigned per line, monthly variance review scheduled
Budgeting for a Service Business: Short Example
Service businesses budget around people and utilisation rather than materials. A hypothetical 12-person IT services firm in Kochi might build its revenue budget like this: 10 billable consultants x 140 available hours a month x 70% target utilisation x ₹1,600 average billing rate = ₹15.68 lakh a month, or about ₹1.88 crore a year. Costs are dominated by salaries (often well over half of revenue), followed by rent, software and travel. The key budget assumptions to stress-test are utilisation and the timing of new hires: hiring two consultants in April for projects that start in July costs three months of salary with no billing.
| Assumption | Base | If it falls to | Annual revenue impact |
|---|---|---|---|
| Utilisation | 70% | 60% | About ₹26.9 lakh lower |
| Average rate | ₹1,600 | ₹1,500 | About ₹11.8 lakh lower |
At 60% utilisation, monthly revenue becomes 10 x 140 x 0.60 x 1,600 = ₹13.44 lakh, ₹2.24 lakh a month or about ₹26.9 lakh a year below budget. At ₹1,500 per hour, monthly revenue becomes ₹14.70 lakh, about ₹11.8 lakh a year lower. Utilisation is the bigger risk, so it deserves the closest monthly tracking.
Running a Monthly Budget Review Meeting
- Timing: within 10 days of month end, once books are closed
- Duration: 45 to 60 minutes; longer meetings drift into detail
- Attendees: owner, finance head and the owners of the largest revenue and cost lines
- Agenda: headline P&L versus budget and flexible budget, top five variances with explanations, cash position and forecast, decisions and actions with owners and dates
- Output: a one-page note of decisions, reviewed at the start of the next meeting
The meeting is where a budget earns its keep. Without it, the budget is a document; with it, the budget becomes a management system.
Running Budgets in Your Accounting System
Budgets work best when loaded into the same system as your actuals, so variance reports are automatic. Fininvo ERP's accounting module supports budgets and cost centres, and comparative financial reports can be scheduled and exported to Excel. See pricing. This guide is general information, not financial advice.
Frequently Asked Questions
When should a small business prepare its budget?
Ideally in January and February for an April to March financial year, so it is approved before the year starts and aligned with bank renewal discussions.
How detailed should a small business budget be?
Detailed enough that each line has an owner and a basis. For most MSMEs, 20 to 40 expense lines grouped into cost centres is sufficient.
What is the difference between a budget and a forecast?
A budget is the agreed target for the year. A forecast is the current best estimate of what will actually happen, updated as the year progresses.
Should I include GST in the budget?
The P&L budget should exclude GST. The cash budget must include GST collections and payments because they affect cash timing.
Share this article
Ready to automate your business?
Start your 14-day free trial and experience the power of unified ERP, HR, and Payroll.
Start Free Trial