All templates
Power BI Budget vs Actual Dashboard Template
Explore the interactive budget dashboard example to compare monthly budgets with actuals by cost center, trace variances to transactions, and reconcile source totals.
Sample data
Budget vs actual
Monthly financial performance by account and cost center.
Source reconciliation
All imported rows before date and cost-center filters.
| Source | Source total | Included | Excluded | Unreadable amounts |
|---|---|---|---|---|
| budget | $628,450 | $628,450 | $0 | 0 |
| actual | $635,475 | $635,475 | $0 | 0 |
Coverage for the current filters
Review one-sided comparisons and open account classifications.
- Actuals without a budget
- 1
- Budgets without actuals
- 1
- Explicit zero budgets
- 1
- Unclassified accounts
- 0
Import findings
3 findings across both source files.
| Source | Row | Finding |
|---|---|---|
| actual | — | 2026-04 · Sales · Events has a budget but no matching actuals. |
| budget | — | 2026-04 · Product · Tools has a zero budget. A variance percentage is unavailable. |
| budget | — | 2026-04 · Operations · Freight has actuals but no matching budget. |
Prepare your files
Upload two CSV or Excel files. For Excel, the first worksheet supplies the table and the first populated row supplies the column names.
- Budget fields include month, department, account and amount.
- Actual fields include posting date, department, account and amount. Add a transaction ID to trace individual entries.
- Add an account type for the P&L view. Use one currency and enter revenue and expenses as positive amounts, with credits as reversals.
Use the starter in Power BI Desktop
The free download includes sample CSVs, Power Query files, DAX measures, and steps for assembling the report in Windows Power BI Desktop.
Download the ZIP