Building a balance sheet budget: twelve design rules

25 October 2026 · Accura International

Most budgets stop at the P&L. That is why they cannot answer the question owners actually ask.

A P&L budget shows profitability, not cash generation. Investment in expansion, working capital management and gearing decide whether that profit is achievable at all, and none of them appear there. Nor does the overdraft headroom you will need in August, or the cost of a customer who pays late. The balance sheet has to be budgeted too — every month, alongside the P&L.

Twelve rules decide whether it is credible

1. Open from the actual balance sheet.Map the closing trial balance account by account and tie to the reported figures first.
2. Roll every line forward.Opening + additions − settlements = closing, with a check row proving the sheet balances every month, not only at year end.
3. Break each balance into its drivers, plus one balancing line.Name key customers, key suppliers and each facility. “Other” is the difference back to the balance sheet, so the total always tallies.
4. Plan opening balances separately from new business.What you are owed today is a different problem from next year’s trading. Each needs its own collection, payment or repayment schedule; anything with no plan should be flagged.
5. Ring-fence slow-moving stock and overdue debtors.Carry them as separate lines with a stated plan: what gets used, sold or collected, and when. Only what is in that plan may reduce new purchases or count as a collection. The rest stays on the balance sheet, provided where doubtful.
6. Be hardest on the slow stock.This is where budgets flatter themselves most: assuming it will move plans purchases too low and cash too high at once, and it usually does neither. Value it at what it will realistically fetch, decide what is genuinely usable, and plan to buy the rest.
7. Drive balances from the operating plans, not from ratios.Sales plan drives receivables. Production plan and stock policy drive purchases, then inventory, supplier credit and trade finance. “Debtor days at 60” is a result to check, not an assumption to feed in.
8. Fix one timing convention and keep it everywhere.If movements sit at month end, interest runs on opening balances and stock is issued at opening cost. Consistency matters more than precision.
9. Let cash balance the sheet.Surplus to cash, shortfall to overdraft, shown against the limit with the headroom left on each facility. That headroom line is usually the most-read number in the model.
10. Calculate interest on the lender’s terms, not an average rate.Agreed rate, day count and payment date, loan by loan, so interest accrued and paid reconcile.
11. One input, one place, visible where it is used.An assumption entered twice will disagree with itself within a month.
12. Replacing an existing workbook? Reproduce it before improving it.Prove the new model returns the old numbers, then list every correction so each change can be traced.

Get these right and the budget stops being an annual ritual. It tells you when a facility limit gets breached, what a 15-day slip in collections costs, and whether next year’s growth is fundable — before you commit.