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.

Budgeted spend$60,250For the selected period
Actual spend$61,275From actual transactions
Spend variance+$1,025+1.7% vs budget

Spend over time

Choose a month to inspect its results.

BudgetActual

Actuals by cost center

Select a team to filter the report.

Variance by account

Variance = actual minus budget.

AccountPeriodBudgetActualVarianceStatusDrill down
Service revenueSalesApr$110,000$115,300+$5,300+4.8%Favorable
CampaignsMarketingApr$10,000$12,000+$2,000+20%Unfavorable
Direct costsOperationsApr$21,000$19,900-$1,100-5.2%Favorable
FreightOperationsApr—$950—N/ANo budget
ToolsProductApr$0$325+$325N/AZero budget
PayrollProductApr$28,000$28,100+$100+0.4%Unfavorable
EventsSalesApr$1,250——N/ANo 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.
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