Skip to content
finreportKit
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.

Profit & loss

Uses classified amounts for the current period and cost center.

Line itemBudgetActualVariance
Revenue$110,000$115,300+$5,300
Cost of sales$21,000$19,900-$1,100
Gross profit$89,000$95,400+$6,400
Operating expenses$39,250$41,375+$2,125
Operating profit$49,750$54,025+$4,275

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.
Read the guide to matching both tables

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