Every month the same question lands on the finance team: are we over budget or under budget, and where? The Budget vs Actual Dashboard in Google Sheets answers it on one screen. It is a budget variance dashboard that puts budget next to actual spend for every department, GL account and month, then shows the variance in dollars, which lines went over budget and who owns those budgets.
🌍 Join 10,000+ customers in 180+ countries using NextGenTemplates to replace paid SaaS tools with one-time-purchase Excel, Google Sheets, Power BI and HTML templates.
✅ Instant download · One-time payment · No subscription · No per-user fees · Lifetime access
Watch the Budget vs Actual Dashboard in Google Sheets walkthrough
Good to know: this is a reporting dashboard, not accounting software. You type or paste budget and actual amounts into the Data tab. All sample departments, accounts and figures are fictional.
🔑 Key Features of the Budget vs Actual Dashboard
📌 A budget vs actual template for Google Sheets. Budget, actual spend, variance and budget used % for every department, GL account and month.
📌 Four KPI cards. Total Budget, Actual Spend, Variance (Budget – Actual) and Budget Used % lead every page, with a win-or-loss sparkline for each month.
📌 Native slicers. Month, Department, Account Category, Expense Type, Budget Owner, Quarter, GL Account and Status filter the charts and Top 5 panels with one click.
📌 Department budget tracking. See which departments are over or under budget, with overspend and underspend ranked.
📌 GL account analysis. Budget vs actual by account category and the Top 5 GL accounts by spend and by overspend.
📌 Budget owner view. Variance by budget owner shows who is under budget and who carries the largest overrun.
📌 Record-level Search page. Type any Entry ID and the full budget line appears.
📌 No add-ons. Built with formulas, pivot tables and native slicers. No add-on, no script, no macro.
📌 Room for 1,000 budget lines. Paste your own lines over the sample rows and the pages update on their own.
📦 What is Inside the Budget vs Actual Dashboard
Four dashboard pages (Overview, Departments, Accounts, Variance), a Search page, an Instructions page and a Data tab. Your download is a PDF guide with the link to open the dashboard and make your own editable copy.
Overview Page
The Overview page answers the first question of every month: are we over or under budget? Total Budget, Actual Spend, Variance (Budget – Actual) and Budget Used % sit in four KPI cards, and a sparkline under the variance card marks every month as a win or a loss. Charts show Budget vs Actual by Month, Actual Spend by Account Category, Variance by Month and Variance by Department, and a Top 5 Departments by Actual Spend panel with a share bar finishes the page. Month, Department, Account Category and Expense Type slicers filter every card and chart together.
Departments Page
Shows which departments are over or under their budget and who owns them. Budget vs Actual by Department puts both bars side by side, Budget Lines by Status splits lines into on budget, under budget and over budget, and Actual Spend by Quarter, Underspend by Department and Overspend by Department sit beside a Top 5 Departments by Overspend panel. Department, Budget Owner, Quarter and Status slicers filter the page.
Accounts Page
Follows your chart of accounts. Budget vs Actual by Account Category compares budget and actual for every category, Actual Spend by Department and Category shows how each department spends, and Variance by Account Category shows which categories ran under or over. A Top 5 GL Accounts by Actual Spend panel finishes the page, with Account Category, GL Account and Quarter slicers.
Variance Page
Where the overspend comes from. Budget vs Actual by Quarter, Overspend by Month, Overspend by Account Category, Budget Lines by Month and Status, Variance by Budget Owner and Underspend by Month sit beside a Top 5 GL Accounts by Overspend panel. Month, Department, Status and Expense Type slicers filter the page.
Search Page
Type any Entry ID in the teal input box and the full budget line appears: period, department, account category, GL account, budget owner, expense type, quarter, budget, actual, variance, variance %, status, month, overspend and underspend.
Instructions Page
Explains that each Data row is one budget line (department, GL account and month), which columns you fill in and which ones calculate themselves, how variance (budget minus actual), status and Budget Used % are calculated, how the slicers in the left rail work, and how to replace the sample rows with up to 1,000 of your own budget lines.
📊 Budget vs Actual Dashboard vs. a Budget Spreadsheet vs. Budgeting Software: Where This Fits
| Feature | This Google Sheets dashboard | Plain budget spreadsheet | Budgeting and FP&A software |
|---|---|---|---|
| Cost | $9.99 one-time ✅ | Free, but you build it | Monthly subscription, often per user |
| Budget vs actual by department, account and month | Charts and cards ✅ | Manual formulas | Yes ✅ |
| Over and under budget lines by owner | Yes ✅ | Build it yourself | Varies |
| Slicers for month, department and status | Yes ✅ | No | Varies |
| Forecasting, consolidation and approvals | No | No | Often included |
| Add-ons or scripts required | No | No | Not applicable |
If you already keep budget and actual amounts in a sheet and want a variance analysis dashboard without another subscription, this fits. If you need forecasting, consolidation or approval workflows, you need other software as well.
👥 Who This Template Is For, and Who It Is Not For
✅ This template is built for:
- Finance managers and controllers who report budget variance every month
- Accountants who need budget vs actual by GL account
- Department heads and budget owners who track their own spend
- Small business owners who want budget reporting without paying for software
❌ This template is NOT for:
- Teams that need forecasting, consolidation or approval workflows, because it only reports on the lines you add
- Anyone looking for accounting, tax or compliance functions, which it does not provide
- Teams that need a live feed from an accounting system, because amounts are typed or pasted into the Data tab
⚙️ How to Use the Budget vs Actual Dashboard
- Open the PDF guide in your download and click the link to open the dashboard.
- Choose File, then Make a copy and save it to your own Google Drive.
- Go to the Data tab and type or paste your own budget lines over the sample rows. Fill in the columns from Entry ID to Actual and leave the calculated columns alone.
- Use the slicers on each page to filter the charts and Top 5 panels.
- Move through Overview, Departments, Accounts and Variance from the navigation rail.
💼 Real-World Use Cases
The month-end review. A controller filters the Overview to the latest month and sees at once whether actual spend finished above budget.
The department conversation. A finance manager opens Departments, ranks overspend and underspend, and sits down with the budget owner of the biggest overrun.
The account question. An accountant opens Accounts and sees which GL accounts drove the variance.
❓ Frequently Asked Questions
What does the Budget vs Actual Dashboard in Google Sheets show?
It puts the budget next to the actual spend for every department, GL account and month, and shows the variance in dollars, the variance percent, which lines went over budget and who owns each budget.
How do I get my own copy?
Open the PDF guide in your download, click the link and choose File, then Make a copy. The copy lands in your Google Drive and is fully editable.
Do I need add-ons, scripts or macros?
No. It is built with formulas, pivot tables and native slicers. There is no add-on, no Apps Script and no macro to authorise.
How many budget lines can it hold?
The Data tab has room for 1,000 rows. Each row is one budget line: a department, a GL account and a month with its budget and actual amount.
How is variance calculated?
Variance is Budget minus Actual, so a positive figure means under budget and a negative figure is an overrun. Budget Used % is Actual divided by Budget. A line counts as over or under budget when it is more than 5% away from its budget, and you can change that threshold on the Instructions page.
Is the sample data real?
No. The departments, GL accounts, budget owners and every figure are fictional sample data. Replace them with your own budget lines.
Is this accounting software?
No. It is a reporting dashboard. You type or paste budget and actual amounts into the Data tab and the pages report on them. It does not post to a ledger, forecast or replace your accounting system.
👤 About the Author
Built by PK, Microsoft Certified Professional with 15+ years of Excel, Google Sheets and Power BI experience. Founder of NextGenTemplates. Every template is hand-built and tested before release.
🔗 Explore Related Templates
- Budget vs Actual Dashboard in Excel: the Excel edition of this dashboard.
- Budget vs Actual Dashboard in Power BI: the Power BI edition.
- Finance Summary Dashboard in Google Sheets: revenue, expenses and net income in one view.
- Zero-Based Budget Template in Excel and Google Sheets: plan budgets before you report against them.
Browse all Google Sheets dashboards.
🎥 Visit our YouTube channel for step-by-step video tutorials
👉 YouTube.com/@NextGenTemplates
📅 Last updated: November 2026
Compatibility and Requirements
- Works in Google Sheets. You need a free Google account and a web browser.
- Every chart reads a native Google Sheets pivot table. Google explains how to build charts in Add and edit a chart or graph.
Reviews
There are no reviews yet.