Budget vs actual dashboard template — variance

Budget vs actual

Variance by month, department and account.

The monthly variance review usually means a finance analyst exporting the ledger, pasting it next to the budget workbook and sending a different file to every department head. This template replaces that file. Actuals come from your accounting system or ERP, the budget and any re-forecast come from a spreadsheet, and the page lines them up by month, department and account — so the review starts from the same numbers for everyone. The budget vs actual glossary entry defines the terms; the budget vs actual guide walks through building one from scratch.

Department heads open the same dashboard and see only their own cost centres, because a row-level rule by department applies to the page, downloads and every scheduled report. Finance sees the whole company, with a variance table that sorts the biggest overspends to the top and a drill-down from department to account to the transactions behind a number.

In the review, Klayara AI, on Growth and Enterprise, answers "why is marketing over budget this quarter?" with a real chart, and Summarize this dashboard writes a short plain-language note on the month that finance can edit before sending. The formula assistant writes variance measures such as "actual minus budget as a percent of budget" from a sentence. The pack can go to each department head by email on the third working day.

Finance teams that run a monthly variance review with every department head.
Department heads who want their own budget lines without waiting for a spreadsheet.
Boards and owners who want year-to-date variance and the full-year forecast on one page.

The metrics

What a budget vs actual dashboard should show.

Each figure below is on the template from the first minute — rename, redefine or remove any of them.

Revenue vs budget

Actual revenue against budget for the month and year to date, in money and percent.

Operating costs vs budget

Total operating costs against budget, with favourable and unfavourable variances coloured consistently.

Gross margin vs budget

Actual gross margin percent against the budgeted margin, so price and cost pressure show early.

Year-to-date variance

Cumulative variance to budget across the financial year, the number boards ask for first.

Full-year forecast vs budget

Actuals to date plus the latest forecast for the remaining months, against the original full-year budget.

Largest variances

The departments and accounts furthest from budget this month, ranked by money, not percent.

Unbudgeted spend

Spend posted to accounts or cost centres with no budget line, which usually signals a coding problem or a decision nobody planned for.

The panels

The charts on the page, and the decision each one supports.

Monthly actual vs budget

Bars for actual, a line for budget and a dashed line for forecast across the financial year.

Budget-to-actual bridge

A waterfall from budgeted profit to actual profit, one step per department, so the size of each contribution is clear.

Department variance table

Every department with actual, budget, variance and variance percent, sorted with the biggest overspend first.

Account drill-down

Click a department to see its accounts, then the transactions behind any figure.

Commentary

A text box for finance's notes on the month, kept beside the numbers it explains.

Where the numbers come from

Connect the systems you already run.

The template expects data like this. Connect it live or import it, relate the tables once, and every panel fills in.

See all 150+ connectors

XeXeroQuQuickBooksNeNetSuiteSASAPMiMicrosoft DynamicsOdOdooGoGoogle SheetsMiMicrosoft Excel

Built for

Popular in

Also try

Related templates

All templates

Finance snapshot

Cash, costs and margins, always current.

Cash flow

Cash in bank, weekly flows and the 13-week forecast.

Executive overview

The whole business on one page, for Monday.

FAQ

Budget vs actual template questions.

Something else on your mind? Ask us directly — a person answers.

What is a budget vs actual dashboard?

A budget vs actual dashboard compares actual revenue and costs with the budget, and usually the latest forecast, by month, department and account. It shows each variance in money and percent, so a team can see where it is over or under plan and why.

Where does the budget come from?

Usually a spreadsheet. Connect the budget workbook or Google Sheet as a table next to the ledger; when finance updates the sheet, the dashboard follows. A re-forecast can sit in the same sheet as a second version.

Can each department head see only their own budget?

Yes. A row-level rule by department or cost centre limits each head to their own lines on the dashboard, in downloads and in scheduled reports, while finance sees the whole company.

Should variance be shown in money or percent?

Both, but rank by money. A 40% overspend on a small account matters less than a 3% overspend on payroll. The template sorts by the money variance and shows the percent beside it.

Can Klayara AI write the monthly variance commentary?

It drafts it. Click "Summarize this dashboard" and Klayara AI writes a short plain-language note on the biggest variances, which finance edits before it goes out; "Why did this change?" explains a single movement. Klayara AI is on the Growth plan (150 AI credits a month for the workspace) and Enterprise, and runs only when someone clicks.

Actual against budget, line by line, month by month.