Budget template (Excel) by month and cost centre

Set the annual budget by month and cost centre, load actuals as each month closes and keep a 24-month forecast on the same rows, so you always see the full-year outturn against budget. This budget template is one Excel workbook for a company budget, with a review sheet and a summary by cost centre.

Finance teams
$12
In the pack
Budget and rolling forecast
Files
3, Excel and Word
Buy the pack · $12
US library · 52 packs

Get this pack and 51 more for $79

Budget and forecast · this packBookkeeping and advisory lettersAudit and AUP lettersBook-to-tax reconciliationCompilation and review lettersIndependent contractorsCPA verification letters1040 checklistsIRS notices+ 43 more
$79$69889% off
Buy the US library · $79

Want every pack, for every region? Global library, 110 packs, $99

What the workbook looks like

Budget template template
What the workbook coversSheet or column in the workbook
Company, currency and financial year
✓
SettingsThe first month of the year, months of actuals loaded and the two variance thresholds
Your cost centres
✓
SettingsUp to 15, from Sales and Marketing to Leadership, offered as a drop-down on every row
The approved budget by month
✓
BudgetOne row per cost centre and line, 12 months and a full-year total
Lines grouped by type
✓
Budget: TypeRevenue, Cost of sales or Overheads, so the summaries add up to gross profit and operating profit
A starter chart of accounts
✓
Budget: LineNearly 30 lines, from product and subscription revenue to salaries, software, rent, insurance and recruitment
Actual results
✓
ActualsFrom the ledger month by month, on the same rows as the budget. Months not yet closed are grey
A forecast that rolls
✓
Forecast24 months from the start of the year, with the next 12 months worked out from the months already closed
Year to date and full year
✓
ReviewBudget, actual and variance year to date, budget against forecast for the full year, and the next 12 months for every line
Lines over threshold
✓
Review: CheckAdd commentary on any line over both the amount and the percentage, year to date or full year
Profit and loss summary
✓
SummaryRevenue, cost of sales, gross margin, overheads and operating margin against budget
Costs by cost centre
✓
SummaryYear to date and full year, budget against forecast
Month by month
✓
SummaryBudget against the latest view, which uses actuals for closed months and the forecast for the rest, with a check that it agrees to the full-year forecast

When you need it

A budget is the financial plan for the year that the board approves and holds the business to. Built by month and cost centre, it shows each budget holder what they can spend and when, and gives every month's actuals something to be measured against. Use this workbook when:

  • You are setting next year's budget and want it by month, not as one annual figure
  • Budget holders need their own cost centre lines to fill in
  • The board wants to see where the year will end, not just the year to date
  • The budget and the forecast sit in separate spreadsheets that never quite agree

How to use the budget template

  1. Fill in Settings. Company name, currency, the first month of the financial year, your cost centres and the two variance thresholds.
  2. Set up the lines. Replace the line names on the Budget sheet with your chart of accounts. Give each row a cost centre and a type.
  3. Enter the approved budget. Twelve months for each line, with costs as positive numbers. Copy months 1 to 12 into the Forecast sheet as the first forecast, then add months 13 to 24.
  4. Load actuals each month. Paste the month's actuals into the Actuals sheet on the same rows and add 1 to Months of actuals loaded. The Review and the next 12 months move on by a month.
  5. Revise the forecast and clear the checks. Budget holders change the forecast for the remaining months and add a new 12th month. Every line marked Add commentary gets a comment before the figures go out.

Questions

How do you create a budget in Excel?

List your cost centres and your chart of accounts, then set one row for each cost centre and line, with a column for each month. Mark each row as revenue, cost of sales or overheads so the totals add up to gross profit and operating profit. This template has that layout ready, with actuals and a forecast on matching rows.

What is the difference between a budget and a forecast?

The budget is fixed for the year once the board approves it. It is the target. The forecast is the best current view of what will happen, and it changes every month as actuals arrive.

What is a rolling forecast?

A forecast that always looks the same distance ahead. Each time a month closes, actuals replace it and a new month is added at the end, so the forecast keeps covering the next 12 months. The Forecast sheet runs for 24 months so there is always room for the next 12.

What does the full-year outturn show?

Actuals for the months already closed plus the forecast for the months still to come. Comparing it with the full-year budget shows where the year will end, which the year-to-date figures alone don't.

Is a positive variance good or bad?

In this workbook a positive variance is always good for profit: revenue above budget or costs below it. A negative variance is bad for profit. Costs go in as positive numbers and the line's type sets the sign.

Also in the budget and rolling forecast

See the whole pack →

Who it's for

Finance teams, FP&A and financial controllers in small and mid-sized companies that budget in Excel.

Last checked

Checked in November 2026.