Actual vs budget Power BI content

This topic 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