12-month business budget template

What this budget does for you

A 12-month budget turns a vague sense of how the year might go into a set of numbers you can manage against. It tells you when cash is likely to be tight, how much headroom you have for investment, and whether a new cost or repayment actually fits. It is the difference between reacting to your bank balance and steering by it.

The structure below is built for a spreadsheet: twelve month columns across the top, and rows grouped into income, costs, profit and cash. Copy the row headings, drop in your numbers, and you have a working model in under an hour.

Set up the grid

Create thirteen columns: one for row labels and twelve for the months of your financial year. Add a final "Total" column that sums each row. Then build four stacked blocks down the page:

1. Income — money coming in.
2. Cost of sales — costs that rise and fall with sales.
3. Overheads — fixed running costs.
4. Cash position — opening balance, net movement, closing balance.

Keep one assumption visible at the top — your expected month-on-month sales growth — so the whole model flexes when you change it.

Income and cost-of-sales rows

Under Income, list a row per revenue stream (for example: product sales, services, recurring contracts), then a Total income row. Be realistic and reflect seasonality — do not smooth a lumpy trade into twelve equal months.

Under Cost of sales, list the direct costs that move with revenue: stock or materials, packaging, delivery, payment fees, and any subcontract labour. Total them, then add a Gross profit row (Total income minus Total cost of sales). Watching gross profit by month tells you whether your margin holds as volume changes — often more revealing than the top line alone.

Overheads and operating profit

List your fixed running costs as separate rows so nothing hides in a lump:

• Rent, rates and utilities
• Salaries and employer costs
• Software and subscriptions
• Insurance and professional fees
• Marketing
• Loan or finance repayments
• A line for the unexpected (3–5% of overheads)

Total these, then add an Operating profit row: gross profit minus total overheads. This is your monthly trading result before tax — the number that shows whether the business model works month to month.

The cash block — the part that bites

Profit and cash are not the same thing, and the cash block is where that gap shows up. Build three rows: Opening cash (last month's closing balance), Net cash movement (cash in minus cash out, including VAT, tax and capital spend that the profit rows miss), and Closing cash.

Any month where closing cash dips low or negative is a warning to act on in advance — bring forward invoicing, delay a purchase, or arrange a buffer. A flexible facility can cover a known seasonal dip; size it with our seasonal cash buffer calculator.

Review it every month

A budget is only useful if you compare it to reality. Each month, add an "actual" figure beside your forecast and look at the variance. Where you were wrong, ask why — a one-off, or a pattern to correct? Update the remaining months with what you have learned. After a few cycles your forecasts tighten, and you gain something valuable: a credible, evidence-backed view of the year that strengthens any conversation with a lender or investor.