Monthly budget and actual spending by department and expense category, with the variance that shows who is over or under budget.
See who is over or under budget at a glance. The template builds six KPI numbers, four charts, a monthly spending table and two filters from 200 rows of budget data.
The sample tracks five departments and four expense categories from January to October 2026. Actual spending came to $5,703,749 against a budget of $5,571,060, which leaves the company $132,689 over budget.
Variance is budget minus actual, so a negative number means a department spent more than planned. Sales has the largest overspend at $77,641, followed by Marketing and Engineering, while Finance and Admin came in $27,006 under budget. Payroll makes up about three quarters of all spending.
The first row of KPIs covers the whole year to date and the second row covers the latest month, so October spending of $581,818 sits right next to its $567,015 budget. The Department and Expense Category filters narrow every widget.
What's included
Every widget on the budget vs actual dashboard
The numbers below are what each widget shows for the sample data. Replace the rows with your own and they update to match.
The Department and Expense Category filters sit in the dashboard header. Picking a value narrows every KPI, chart and table on the page.
Data table and notes
The Monthly Spending table lists every row of the sample sheet, and a text widget explains what the dashboard shows and how to use the filters.
Sample data
Sample data for the budget vs actual dashboard
The template loads 200 rows into a sheet named Department Spending. Keep the same columns, replace the rows with your own data, and the whole dashboard updates.
Month
Date
Used in Budget This Month, Spending This Month, Variance This Month, Monthly Actual Spending
Department
Text
Used in Budget Variance by Department, Actual Spending by Department, Filter: Department
Expense Category
Text
Used in Spending by Expense Category, Actual Spending by Department, Filter: Expense Category
Budget
Currency
Used in Total Budget, Budget This Month
Actual
Currency
Used in Actual Spending, Spending This Month, Monthly Actual Spending, Spending by Expense Category, Actual Spending by Department
Variance
Currency
Used in Budget Variance, Variance This Month, Budget Variance by Department
The first 10 rows of sample data for the Budget vs Actual Dashboard template
Month
Department
Expense Category
Budget
Actual
Variance
2026-01-01
Engineering
Payroll
$168,000
$174,074.61
-$6,074.61
2026-01-01
Engineering
Software
$21,000
$23,869.15
-$2,869.15
2026-01-01
Engineering
Travel
$4,000
$3,845.60
$154.40
2026-01-01
Engineering
Facilities
$12,000
$12,293.37
-$293.37
2026-01-01
Sales
Payroll
$96,000
$98,987.95
-$2,987.95
2026-01-01
Sales
Software
$9,000
$10,007.69
-$1,007.69
2026-01-01
Sales
Travel
$14,000
$13,704.62
$295.38
2026-01-01
Sales
Facilities
$7,000
$6,961.38
$38.62
2026-01-01
Marketing
Payroll
$52,000
$54,039.24
-$2,039.24
2026-01-01
Marketing
Software
$11,000
$11,618.54
-$618.54
Showing the first 10 of 200 rows.
How to use it
How to build the budget vs actual dashboard
1
Click Use this Template
Log in, or create a free InstaCharts account with your email or Google account.
2
Get the finished dashboard
InstaCharts adds the sample sheet to your workspace and builds every KPI, chart, table and filter in the Financial Light theme.
3
Swap in your data
Switch to Sheets to paste in your own rows or update the sheet from a CSV or Excel file with the same columns.
4
Make it yours
Pick another theme in Dashboard Settings, move or resize widgets, and add more charts, KPIs or text.
Tips for adapting the budget vs actual dashboard
Export budget and actual amounts from your accounting system or planning spreadsheet with one row per month, department and expense category.
Work out Variance as budget minus actual in your spreadsheet before you import it, so a negative value always means overspending.
Keep the amounts as currency values so the KPIs abbreviate large totals, such as $5.57M.
Add new months as new rows, and the This Month KPIs move to the latest month in your data.
A budget vs actual dashboard compares planned spending with real spending, usually by month and by department. The variance between the two shows where spending ran over or under the plan.
Can I use this template for revenue as well as expenses?
Yes. Replace the expense rows with revenue lines and their targets. The KPIs, variance chart and filters work the same way for a revenue plan.
Is this dashboard template free?
Yes. Click Use this Template and sign up for a free InstaCharts account, or log in. The budget vs actual dashboard is built in your workspace with its sample sheet, widgets and filters. Inside the app, the template is also under New, New Dashboard, Start from a Template.
How do I replace the sample data with my own?
Switch to Sheets in the dashboard toolbar to open the sample sheet. Paste in your own rows or update the sheet from a CSV or Excel file with the same columns, and every chart, KPI and data table on the dashboard updates to match.
Can I change the theme and layout?
Yes. Open Dashboard Settings to pick another theme or customize the header, page and chart colors. Widgets can be moved, resized, duplicated or deleted, and you can add more charts, KPIs, tables and text.
We use cookies to analyze website traffic and optimize your experience. By accepting our use of cookies, your data will be aggregated with all other user data.