Budget vs Actual (Dashboard)
Overview
- Search box and five filters for Department, Cost Center, Expense Category, Quarter, and Over or Under, reachable from an icon rail as well as the dropdown row
- Four headline tiles – budget utilized, departments tracked, total forecast, and variance this month – the first three carrying their own sparkline
- A Spend Trend chart plotting actual spend as a filled area against the budget line on the same scale, with monthly and quarterly views and an over-budget status badge
- A Variance Health gauge showing what share of the book is running under budget, with the net variance called out underneath it
- A Top Owner card naming whoever holds the most budget lines in the current view, split into records, over, and under
- Category Breakdown as a stacked bar of spend share with a ranked list of category totals beneath it, alongside a recent entries feed and a plain-English budget alert
- A sortable fifteen-column records table with variance and variance percentage colored red or green, and everything on the page recalculating together when a filter changes
Benefits
- Replaces the monthly budget-versus-actual export and the chart refresh that goes with it
- Shows overspend while the quarter is still open instead of after the close
- Puts budget and actual on one shared scale, which is what keeps a finance audience trusting the page
- Gives every cost center owner their own filtered view without a separate report
- Turns a list the finance team already maintains into reporting, with no new system to buy or roll out
- Serves the CFO and the department manager from the same page, because the filters change who the page is for
- Opens in any browser and can be embedded directly into a SharePoint page
Details
- Build Method: Copilot Dashboard
- Chart Types: KPI card, Sparkline, Gauge chart, Stacked bar chart, Bar chart, Table
Common Questions About the Budget vs Actual Dashboard
What is this budget dashboard built with?
It is built on a standard SharePoint list of budget and actual figures by cost center, with Microsoft 365 Copilot generating the dashboard page from that list. There is no third-party reporting tool and nothing to license beyond Microsoft 365. The charts, filters, and records table all live on one page that can be embedded in a SharePoint site – the kind of clean, maintainable reporting Greg Zelfond builds for finance teams.
What is included on the budget dashboard?
Four tiles covering budget utilized, departments tracked, total forecast, and variance this month. Below them sit a spend trend plotting actual against budget, a variance health gauge, a top owner card, a category breakdown with a ranked list, a recent entries feed, a budget alert line, and a sortable records table. Filters cover department, cost center, category, quarter, and over or under.
Where does the dashboard data come from?
A single SharePoint list with fifteen columns – record ID, fiscal year, month, quarter, cost center, department, owner, expense category, budget amount, actual amount, variance, variance percentage, over or under, forecast amount, and notes. Most finance teams already keep a version of this list.
Does the dashboard refresh automatically from the SharePoint list?
This example carries its data with it, so it opens instantly and works offline, and it is refreshed by regenerating the page from the current list. When a live-refreshing view is the requirement instead, the same numbers can be charted with the Quick Chart web part directly on a SharePoint page, or with Power BI when scheduled refresh is needed.
Should we use Copilot, the Quick Chart web part, or Power BI?
It depends on how much you need. The Quick Chart web part is the lightest option – one chart, pointed at a list, no setup. A Copilot-generated dashboard suits a full page with filters and several linked charts that move together. Power BI earns its place when data volumes are large, sources need joining, or row-level security and scheduled refresh matter.
Can Greg build this dashboard for our organization?
Yes – this is exactly the kind of work Greg Zelfond does. As an independent SharePoint consultant and Microsoft MVP, he sets up the underlying list, shapes the columns so the charts are worth drawing, and builds the dashboard around the questions your leadership actually asks rather than the ones the data happens to answer. Reach out through the contact page.
