A budget is not a prediction — it is a decision made in advance about where money should go, so that twelve months of small choices don't quietly decide it for you. Small businesses skip budgeting because it sounds corporate; then June's surprise GST demand, September's festival stock and January's slow weeks each become crises. One honest spreadsheet, built month by month, retires that whole class of surprises. Here is how to build and actually use it.
Build the revenue line from evidence
Start with last year's actual monthly sales — not the annual total divided by twelve, because Indian business years have shapes: festival peaks, wedding seasons, monsoon dips, March-end pushes. Overlay the specific changes you are planning ('new outlet from August adds X', 'price rise of 4% from July') as separate line items, so hope stays distinguishable from history. If you lack a full year's history, build bottom-up: capacity × realistic utilisation × price, month by month, erring low.
Layer the costs in three bands
- Fixed and contracted: rent (with escalation month marked), salaries (with increment month), EMIs, insurance, subscriptions — these are facts, enter them precisely
- Variable: raw materials, packaging, commissions, freight — as percentages of that month's budgeted sales, using last year's true ratios
- Discretionary and lumpy: marketing, repairs, festivals bonuses, licence renewals, advance tax instalments — placed in their actual months, which is where budgeting earns its keep
List every non-monthly outflow with its date: insurance premium, FSSAI/licence renewals, advance tax (June, September, December, March), Diwali bonuses, school-season salary advances, AMC renewals. Spread across the sheet, these stop being emergencies and become line items.
Read profit and cash as different rows
Below the monthly profit line, add a simple cash view: opening bank balance, plus collections (sales adjusted for your real credit cycle), minus payments (costs adjusted for supplier credit), minus EMIs' principal, GST/TDS payments and any capex — giving closing cash by month. This row is where budgets save businesses: a year that is profitable overall can contain an October where stock purchases and advance tax collide into a negative cash week. Seeing it in April means financing it calmly; meeting it in October means borrowing badly.
The monthly variance ritual
By the 7th of each month, put actuals beside budget and explain every line off by more than 10% — in one sentence each: 'Sales -12%: rains; recovered mid-month.' 'Materials +3 points: oil price, supplier renegotiation booked for the 20th.' The explanations matter more than the numbers, because they force diagnosis and next steps while both are cheap. Twenty minutes with your accountant, standing agenda, no exceptions — this ritual alone puts you ahead of most competitors.
Revise consciously, never silently
When reality diverges for two consecutive months, re-forecast the remaining year — but keep the original budget column visible beside the revision. The gap between them is your learning record, and it calibrates next year's realism. What kills budgeting is silent drift: numbers ignored by August, sheet abandoned by October. A budget revised openly in July is a management tool; one quietly forgotten is last April's mood.
How Aidwish helps
Aidwish builds the budget model with clients as part of annual planning — seasonality-aware revenue lines, the lumpy-cost calendar, the cash row — and then sits in the monthly variance review through its retainers, because the sheet only works when the ritual does.