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.
Actuals by cost center
Select a team to filter the report.
Variance by account
Variance = actual minus budget.
| Account | Period | Budget | Actual | Variance | Status | Drill down |
|---|---|---|---|---|---|---|
| Service revenueSales | Apr | $110,000 | $115,300 | +$5,300+4.8% | Favorable | |
| CampaignsMarketing | Apr | $10,000 | $12,000 | +$2,000+20% | Unfavorable | |
| Direct costsOperations | Apr | $21,000 | $19,900 | -$1,100-5.2% | Favorable | |
| FreightOperations | Apr | — | $950 | —N/A | No budget | |
| ToolsProduct | Apr | $0 | $325 | +$325N/A | Zero budget | |
| PayrollProduct | Apr | $28,000 | $28,100 | +$100+0.4% | Unfavorable | |
| EventsSales | Apr | $1,250 | — | —N/A | No actuals | — |
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