Actual vs budget Power BI content

This article describes the Actual vs budget Microsoft Power BI content. It explains how to access the Power BI reports, and provides information about the data model and entities that were used to build the content.

Overview

The Actual vs budget Power BI content was created for individuals who are responsible for monitoring actual versus budget performance in their organization. The Actual vs budget Power BI content provides visibility into your budget variances. You can analyze budget for the current year by account category, budget code, main account, main account descriptions, or fiscal period to get a better understanding of the cause of any variances.

Accessing the Power BI content

Reports from the Actual vs budget Power BI content are shown in the Ledger budget and forecasts and CFO workspaces.

Reports that are included in the Power BI content

The following table provides details about the metrics that are found on each report page in the Actual vs budget Power BI content.

Report	Metrics
Expenses - Actual vs budget	Total expenses this year Budget total expenses this year
Revenue - Actual vs budget	Total revenue this year Budget total revenue this year
Expense	Total expenses this year Goal for expenses based on budget
Revenue	Total revenue this year Goal for revenue based on budget
Net income	Net income this year Goal for net income based on budget

Understanding the data model and entities

Entity	Contents
General Ledger Activities	Transaction amounts for the general ledger
Budget Activities	Transaction amounts for the budget register
Main Accounts	Main accounts to filter reports by
Fiscal Calendars	Fiscal calendars to filter reports by
Ledgers	Ledgers that can be used to filter the report to the current ledger
Budget Codes	Budget codes to filter reports by
Legal Entities	Legal entities that can be used to filter the report to the current legal entity