What a budget vs actual report is for
A budget is a plan; a budget vs actual report tells you how far reality has moved from the plan and where. Done every month, it turns the budget from a once-a-year exercise into a management tool: you see a cost creeping up or a revenue line slipping while there is still time to act.
Favourable and adverse
A variance is favourable when it improves profit — income above budget or expenses below budget — and adverse when it reduces profit. The template knows whether each line is income or expense, so it labels the variance correctly without you flipping signs. It shows both the amount and the percentage, because a ₹50,000 overspend means something very different on a ₹1 lakh line than on a ₹50 lakh line.
Month and year-to-date
Monthly figures are noisy — a bill booked in the wrong month swings the variance one way and back again the next. Year-to-date figures smooth that out and show the real trend. The report gives both side by side for the month you pick, so you can tell a timing difference from a genuine overrun.
Materiality: comment on what matters
Not every variance deserves a paragraph. Set a materiality percentage and the template highlights only the lines that cross it, so the monthly review focuses on the few items that need an explanation and an action — not on rounding differences in stationery.
Why profit and cash are different
A business can be on budget for profit and still run short of cash: customers pay late, stock builds up, a loan instalment falls due, GST and TDS have to be paid on fixed dates. That is why a cash flow forecast sits alongside the budget. The Pro edition builds a 12-month forecast from your budget, using collection timing (same month, next month or the month after), supplier credit, opening debtors and creditors, capital spending, loan repayments and statutory payments.
Set a minimum cash balance and the forecast flags any month where closing cash falls below it, with the lowest balance and the month it occurs. Knowing that three months ahead gives you time to arrange a limit, chase collections or defer spending.
Tips for a useful budget
Build the budget at the level you will actually review — a dozen to thirty lines is plenty for most small businesses. Phase it by month based on seasonality rather than dividing the annual figure by twelve. And revisit it at the half-year: a reforecast is better than explaining the same variance six months running.
Written by Prakash Bagchi, finance professional and founder of PB Lab. Last reviewed .