Reporting
How to build an annual budget for a small business
A budget built from drivers rather than last year plus ten per cent, phased by month, tied to cash — and reviewed every month so it is actually used.
On this page
Most small businesses either don’t budget at all, or budget once — a spreadsheet built in a hurry in March, filed, and never opened again. Both miss the point. A budget is not a prediction you are graded on. It is the plan you measure each month against, so that when the numbers move you can tell whether it was price, volume, cost or luck, and do something about it.
Why most budgets get ignored
- They are built as last year plus a percentage. When the year turns out differently, nobody can say why, because the budget never said how its numbers were reached.
- They are annual totals. A yearly number can’t be compared with a month, so it isn’t.
- Nobody owns the lines. Revenue is “the business’s” number, so nobody is accountable for it.
- Nobody compares them with actuals. Without a monthly budget-versus-actual, the budget has no job to do.
Start from last year, by month
Start with last year’s actual results, month by month, not as a single total. That gives you your real seasonality — the festive peak, the slow monsoon months, the March rush — and a base to build from. Strip out one-offs first: an unusual order, a write-off, a one-time expense. You are budgeting the business’s normal shape, not last year’s accidents.
Build revenue from drivers
Revenue is not one number. It is the product of things you can reason about: how many units or customers, at what price, in what mix. Budget each segment that behaves differently from its drivers:
| Segment | Driver | April | From October |
|---|---|---|---|
| Product line A | 1,200 units × ₹1,500 | ₹18.0 lakh | ₹18.9 lakh (price up 5%) |
| Product line B | 40 customers × ₹25,000 | ₹10.0 lakh | ₹11.0 lakh (4 new customers) |
| Service line C | 8 projects × ₹50,000 | ₹4.0 lakh | ₹4.0 lakh |
Now every assumption is visible and can be tested. When line A comes in under budget in November, you can see whether it was fewer units or the price increase that didn’t stick — two problems with very different fixes. Put each change in the month it will actually happen: a price increase from October, a new customer from their first order, not spread evenly across the year.
Direct costs and overheads
Direct costs — materials, direct labour, freight, commissions — are best budgeted from each segment’s gross margin rather than as a percentage of total revenue. Segments rarely carry the same margin, so a mix shift towards a lower-margin line should show up in the budget, not come as a surprise. Our gross margin analysis guide explains how to get the segment margins right first.
Overheads are budgeted line by line, in three kinds:
- Fixed — rent, software, insurance. Known amounts, in known months.
- Step-fixed — mostly people. Build a hiring plan by month: who joins when, at what cost, including employer PF. Annual increments go in the month they take effect.
- Discretionary — marketing, travel, events. Decide the amount, phase it deliberately, and give each line an owner.
Below that go depreciation and interest, then capital spending and financing, which don’t sit in the P&L but matter a great deal for cash.
Phase it by month
Spread every line across the twelve months in the pattern it will actually follow. Revenue follows last year’s seasonality, adjusted for your drivers. Salaries follow the hiring plan. Annual costs such as insurance fall in the month they are paid or, for the P&L, spread across the year they cover. The test is simple: could you put this month’s actuals next to this month’s budget and have the comparison mean something?
It is also worth checking the budget against your break-even point. If the slow months fall below it, you know in advance which months the business will need to be carried through, and by how much.
Turn it into a cash budget
A profitable budget can still run out of cash, for all the reasons in why profit and cash differ. So convert it:
- Shift revenue into collections using your real debtor days, customer by customer for the large ones.
- Shift purchases and expenses into payments using your creditor days and payment calendar.
- Add GST and TDS on their due dates, capital spending when it is paid, loan repayments and drawings.
- Compare the monthly closing balance with your working capital limit and a minimum buffer.
If a month breaches the buffer, it is far easier to arrange finance or re-time spending in March than in the week it happens. For the near term, a 13-week cash flow forecast gives you the same view week by week.
Use it every month
The budget earns its keep in the monthly MIS. Each month, put actual next to budget, line by line, for the month and the year to date, and explain every material variance: was it price, volume, mix or cost? Our free MIS report template has the actual, budget and variance columns built in, signed so that positive is always favourable.
Keep the budget fixed for the year so it remains a fair yardstick, and use a quarterly reforecast for where the year is actually heading. The budget tells you how you are doing against the plan; the forecast tells you what to do next.
Mistakes to avoid
- Top-down targets with no drivers. “We’ll grow 25%” is an ambition, not a budget, until it says where the growth comes from.
- Even phasing. Dividing the annual number by twelve guarantees meaningless monthly variances.
- Forgetting the people plan. Salaries are usually the largest overhead; budget them person by person, month by month.
- No cash budget. A budget that shows a profit and a cash shortfall at the same time is telling you something important. Only one of those will show up in a P&L-only budget.
- Changing the budget mid-year. Update the forecast instead, or you lose the yardstick.
Building the annual budget, and running the budget-versus-actual every month after it, is core virtual CFO work. If you would rather not build it alone, that is what a short call is for.
Written by
Soham T. Savdavkar, Director at Outsourced Finance Solutions — an outsourced finance company providing accounting, MIS reporting, GST and TDS compliance and virtual CFO (VCFO) support to growing businesses across India, from an office in Kanjurmarg, Mumbai.
OFS is not a firm of chartered accountants and performs no CA-reserved work. This article is general information, not advice for your specific situation.