Power BI Finance app KPIs and measures

APPLIES TO: Generally available in Business Central 2024 release wave 2 (version 25.1).

This page provides a list of all Key Performance Indicators (KPIs) included in the semantic model for the Power BI Finance report.

Explore the list of KPIs below to learn more about how they can help you achieve your business goals.

Each KPI and measure is described, including how it is calculated and what data was used in the calculations.

Tip

Tip:
You can easily track the KPIs that the Power BI reports display against your business objectives. To learn more, go to Track your business KPIs with Power BI metrics.

Activity KPIs

% Change in Operating Profit - EBIT

Formula
( Operating Profit - EBIT (Balance at Date) - Operating Profit - EBIT (Beginning Balance) ) / Operating Profit - EBIT (Beginning Balance)

Data Sources

  • G/L Entry
  • G/L Account Category

% Change in Revenue

Formula
( Revenue (Balance at Date) - Revenue (Beginning Balance) ) / Revenue (Beginning Balance)

Data Sources

  • G/L Entry
  • G/L Account Category

Asset Turnover Ratio

Formula
Revenue / Assets

Data Sources

  • G/L Entry
  • G/L Account Category

Average Collection Period (Days)

Formula
( No. of Days * Accounts Receivable (Average) ) / Revenue

Data Sources

  • Date
  • G/L Entry
  • G/L Account Category

Cash Conversion Cycle - CCC

Formula
Days Sales Of Inventory - DSI + Days Sales Outstanding - DSO - Days Payable Outstanding - DPO

Data Sources

  • G/L Entry
  • G/L Account Category

Days Payable Outstanding - DPO

Formula
( Accounts Payable / Cost of Goods Sold ) * No. of Days

Data Sources

  • Date
  • G/L Entry
  • G/L Account Category

Days Sales Of Inventory - DSI

Formula
( Inventory / Cost of Goods Sold ) * No. of Days

Data Sources

  • Date
  • G/L Entry
  • G/L Account Category

Days Sales Outstanding - DSO

Formula
( Accounts Receivable / Revenue ) * No. of Days

Data Sources

  • Date
  • G/L Entry
  • G/L Account Category

Degree Of Operating Leverage - DOL

Formula
% Change in Operating Profit - EBIT / % Change in Revenue

Data Sources

  • G/L Entry
  • G/L Account Category

Inventory Turnover

Formula
Cost of Goods Sold / Inventory (Average)

Data Sources

  • G/L Entry
  • G/L Account Category

No. of Days

Formula

The No. of Days measure calculates the total number of days within a selected period by counting the rows between the earliest (MIN) and latest (MAX) dates in the Date table. This measure provides a count of days for the specified date range in the context.

Date Sources

  • Date

Balance Sheet Measures

Accounts Payable

Formula
The Accounts Payable measure calculates the Balance at Date for general ledger accounts categorized as Accounts Payable on the G/L Account Category page and where this category is mapped to the Accounts Payable (Level 3 Category) on the Power BI Account Categories page. It then multiplies the result by -1 to display the balance as a positive value.

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Accounts Payable (Neg)

Formula
The Accounts Payable measure calculates the Balance at Date for general ledger accounts categorized as Accounts Payable on the G/L Account Category page and where this category is mapped to the Accounts Payable (Level 3 Category) on the Power BI Account Categories page.

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Accounts Receivable

Formula
The Accounts Receivable measure calculates the Balance at Date for general ledger accounts categorized as Accounts Receivable on the G/L Account Category page and where this category is mapped to the Accounts Receivable (Level 3 Category) on the Power BI Account Categories page.

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Accounts Receivable (Average)

Formula
( Accounts Receivable (Beginning Balance) + Accounts Receivable ) / 2

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Accounts Receivable (Beginning Balance)

Formula
The Accounts Receivable (Beginning Balance) measure calculates the Balance at Date for accounts receivable up to the earliest date in the selected period. The measure calculates the beginning balance by identifying the earliest date in the selected period, removing any existing date filters to consider all historical dates, and then limiting results to transactions on or before this earliest date. This approach yields the balance as of the start of the selected period.

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Assets

Formula
The Assets measure calculates the Balance at Date for general ledger accounts categorized as Assets on the G/L Account Category page and where this category is mapped to the Assets (Level 1 Category) on the Power BI Account Categories page.

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Current Assets

Formula
The Current Assets measure calculates the Balance at Date for general ledger accounts categorized as Current Assets on the G/L Account Category page and where this category is mapped to the Current Assets (Level 2 Category) on the Power BI Account Categories page.

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Fixed Assets

Formula
The Fixed Assets measure calculates the Balance at Date for general ledger accounts categorized as Fixed Assets on the G/L Account Category page and where this category is mapped to the Fixed Assets (Level 2 Category) on the Power BI Account Categories page.

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Inventory

Formula
The Inventory measure calculates the Balance at Date for general ledger accounts categorized as Inventory on the G/L Account Category page and where this category is mapped to the Inventory (Level 3 Category) on the Power BI Account Categories page.

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Inventory (Average)

Formula
( Inventory (Beginning Balance) + Inventory ) / 2

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Inventory (Beginning Balance)

Formula
The Inventory (Beginning Balance) measure calculates the Balance at Date for Inventory up to the earliest date in the selected period. The measure calculates the beginning balance by identifying the earliest date in the selected period, removing any existing date filters to consider all historical dates, and then limiting results to transactions on or before this earliest date. This approach yields the balance as of the start of the selected period.

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Liquid Assets

Formula
The Liquid Assets measure calculates the Balance at Date for general ledger accounts categorized as Cash on the G/L Account Category page and where this category is mapped to the Liquid Assets (Level 3 Category) on the Power BI Account Categories page.

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Capital Employed

Formula
Assets - Current Liabilities

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Equity

Formula
The Equity measure calculates the Balance at Date for general ledger accounts categorized as Equity on the G/L Account Category page and where this category is mapped to the Equity (Level 1 Category) on the Power BI Account Categories page.

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Current Liabilities

Formula
The Current Liabilities measure calculates the Balance at Date for general ledger accounts categorized as Current Liabilities on the G/L Account Category page and where this category is mapped to the Current Liabilities (Level 2 Category) on the Power BI Account Categories page. It then multiplies the result by -1 to display the balance as a positive value.

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Liabilities

Formula
The Liabilities measure calculates the Balance at Date for general ledger accounts categorized as Liabilities on the G/L Account Category page and where this category is mapped to the Liabilities (Level 1 Category) on the Power BI Account Categories page. It then multiplies the result by -1 to display the balance as a positive value.

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Liabilities (Neg)

Formula
The Liabilities measure calculates the Balance at Date for general ledger accounts categorized as Liabilities on the G/L Account Category page and where this category is mapped to the Liabilities (Level 1 Category) on the Power BI Account Categories page.

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Liabilities & Equity

Formula
Liabilities + Equity

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Longterm Liabilities

Formula
The Longterm Liabilities measure calculates the Balance at Date for general ledger accounts categorized as Longterm Liabilities on the G/L Account Category page and where this category is mapped to the Longterm Liabilities (Level 2 Category) on the Power BI Account Categories page. It then multiplies the result by -1 to display the balance as a positive value.

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Payroll Liabilities

Formula
The Payroll Liabilities measure calculates the Balance at Date for general ledger accounts categorized as Payroll Liabilities on the G/L Account Category page and where this category is mapped to the Payroll Liabilities (Level 2 Category) on the Power BI Account Categories page. It then multiplies the result by -1 to display the balance as a positive value.

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Purchase Prepayments

Formula
The Purchase Prepayments measure calculates the Balance at Date for general ledger accounts categorized as Purchase Prepayments on the G/L Account Category page and where this category is mapped to the Purchase Prepayments (Level 3 Category) on the Power BI Account Categories page.

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Shareholders Equity

Formula
The Shareholders Equity measure calculates the Balance at Date for general ledger accounts categorized as Common Stock on the G/L Account Category page and where this category is mapped to the Shareholder's Equity (Level 2 Category) on the Power BI Account Categories page.

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Working Capital

Formula
Current Assets + Current Liabilities

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Income Statement Measures

Cost of Goods Sold

Formula
The Cost of Goods Sold measure calculates the Net Change for general ledger accounts categorized as Cost of Goods Sold on the G/L Account Category page and where this category is mapped to the Cost of Goods Sold (Level 1 Category) on the Power BI Account Categories page.

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Depreciation and Amortization

Formula
The Depreciation and Amortization measure calculates the Net Change for general ledger accounts categorized as Depreciation and Amortization on the G/L Account Category page and where this category is mapped to the Depreciation and Amortization Expense (Level 2 Category) on the Power BI Account Categories page.

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Expense

Formula
The Expense measure calculates the Net Change for general ledger accounts categorized as Expense on the G/L Account Category page and where this category is mapped to the Expense (Level 1 Category) on the Power BI Account Categories page.

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Expense (Balance at Date)

Formula
The Expense measure calculates the Balance at Date for general ledger accounts categorized as Expense on the G/L Account Category page and where this category is mapped to the Expense (Level 1 Category) on the Power BI Account Categories page.

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Expense (Beginning Balance)

Formula
The Expense (Beginning Balance) measure calculates the Balance at Date for Expense up to the earliest date in the selected period. The measure calculates the beginning balance by identifying the earliest date in the selected period, removing any existing date filters to consider all historical dates, and then limiting results to transactions on or before this earliest date. This approach yields the balance as of the start of the selected period.

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Extraordinary Expense

Formula
The Extraordinary Expense measure calculates the Net Change for general ledger accounts categorized as Extraordinary Expense on the G/L Account Category page and where this category is mapped to the Extraordinary Expense (Level 2 Category) on the Power BI Account Categories page.

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Extraordinary Expense (Balance at Date)

Formula
The Extraordinary Expense (Balance at Date) measure calculates the Balance at Date for general ledger accounts categorized as Extraordinary Expense on the G/L Account Category page and where this category is mapped to the Extraordinary Expense (Level 2 Category) on the Power BI Account Categories page.

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Extraordinary Expense (Beginning Balance)

Formula
The Extraordinary Expense (Beginning Balance) measure calculates the Balance at Date for Extraordinary Expense up to the earliest date in the selected period. The measure calculates the beginning balance by identifying the earliest date in the selected period, removing any existing date filters to consider all historical dates, and then limiting results to transactions on or before this earliest date. This approach yields the balance as of the start of the selected period.

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Extraordinary Revenue

Formula
The Extraordinary Revenue measure calculates the Net Change for general ledger accounts categorized as Extraordinary Revenue on the G/L Account Category page and where this category is mapped to the Extraordinary Revenue (Level 2 Category) on the Power BI Account Categories page. It then multiplies the result by -1 to display the balance as a positive value.

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Extraordinary Revenue (Balance at Date)

Formula
The Extraordinary Revenue (Balance at Date) measure calculates the Balance at Date for general ledger accounts categorized as Extraordinary Revenue on the G/L Account Category page and where this category is mapped to the Extraordinary Revenue (Level 2 Category) on the Power BI Account Categories page. It then multiplies the result by -1 to display the balance as a positive value.

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Extraordinary Revenue (Beginning Balance)

Formula
The Extraordinary Revenue (Beginning Balance) measure calculates the Balance at Date for Extraordinary Revenue up to the earliest date in the selected period. The measure calculates the beginning balance by identifying the earliest date in the selected period, removing any existing date filters to consider all historical dates, and then limiting results to transactions on or before this earliest date. This approach yields the balance as of the start of the selected period. It then multiplies the result by -1 to display the balance as a positive value.

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

FX Gains Revenue

Formula
The FX Gains Revenue measure calculates the Net Change for general ledger accounts categorized as FX Gains Revenue on the G/L Account Category page and where this category is mapped to the FX Gains Revenue (Level 2 Category) on the Power BI Account Categories page.

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

FX Gains Revenue (Balance at Date)

Formula
The FX Gains Revenue measure calculates the Balance at Date for general ledger accounts categorized as FX Gains Revenue on the G/L Account Category page and where this category is mapped to the FX Gains Revenue (Level 2 Category) on the Power BI Account Categories page.

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

FX Gains Revenue (Beginning Balance)

Formula
The FX Gains Revenue (Beginning Balance) measure calculates the Balance at Date for FX Gains Revenue up to the earliest date in the selected period. The measure calculates the beginning balance by identifying the earliest date in the selected period, removing any existing date filters to consider all historical dates, and then limiting results to transactions on or before this earliest date. This approach yields the balance as of the start of the selected period.

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

FX Losses Expense

Formula
The FX Losses Expense measure calculates the Net Change for general ledger accounts categorized as FX Losses Expense on the G/L Account Category page and where this category is mapped to the FX Losses (Level 2 Category) on the Power BI Account Categories page.

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

FX Losses Expense (Balance at Date)

Formula
The FX Losses Expense measure calculates the Balance at Date for general ledger accounts categorized as FX Losses Expense on the G/L Account Category page and where this category is mapped to the FX Losses Expense (Level 2 Category) on the Power BI Account Categories page.

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

FX Losses Expense (Beginning Balance)

Formula
The FX Losses Expense (Beginning Balance) measure calculates the Balance at Date for FX Losses Expense up to the earliest date in the selected period. The measure calculates the beginning balance by identifying the earliest date in the selected period, removing any existing date filters to consider all historical dates, and then limiting results to transactions on or before this earliest date. This approach yields the balance as of the start of the selected period.

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Interest Expense

Formula
The Interest Expense measure calculates the Net Change for general ledger accounts categorized as Interest Expense on the G/L Account Category page and where this category is mapped to the Interest Expense (Level 2 Category) on the Power BI Account Categories page.

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Interest Expense (Balance at Date)

Formula
The Interest Expense measure calculates the Balance at Date for general ledger accounts categorized as Interest Expense on the G/L Account Category page and where this category is mapped to the Interest Expense (Level 2 Category) on the Power BI Account Categories page.

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Interest Expense (Beginning Balance)

Formula
The Interest Expense (Beginning Balance) measure calculates the Balance at Date for Interest Expense up to the earliest date in the selected period. The measure calculates the beginning balance by identifying the earliest date in the selected period, removing any existing date filters to consider all historical dates, and then limiting results to transactions on or before this earliest date. This approach yields the balance as of the start of the selected period.

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Interest Revenue

Formula
The Interest Revenue measure calculates the Net Change for general ledger accounts categorized as Income, Interest on the G/L Account Category page and where this category is mapped to the Interest Revenue (Level 2 Category) on the Power BI Account Categories page.

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Interest Revenue (Balance at Date)

Formula
The Interest Revenue measure calculates the Balance at Date for general ledger accounts categorized as Income, Interest on the G/L Account Category page and where this category is mapped to the Interest Revenue (Level 2 Category) on the Power BI Account Categories page.

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Interest Revenue (Beginning Balance)

Formula
The Interest Revenue (Beginning Balance) measure calculates the Balance at Date for Interest Revenue up to the earliest date in the selected period. The measure calculates the beginning balance by identifying the earliest date in the selected period, removing any existing date filters to consider all historical dates, and then limiting results to transactions on or before this earliest date. This approach yields the balance as of the start of the selected period.

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Operating Expense - OPEX

Formula
Expense - Interest Expense - FX Losses Expense - Tax Expense - Extraordinary Expense

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Operating Expense - OPEX (Balance at Date)

Formula
Expense (Balance at Date) - Interest Expense (Balance at Date) - FX Losses Expense (Balance at Date) - Tax Expense (Balance at Date) - Extraordinary Expense (Balance at Date)

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Operating Expense - OPEX (Beginning Balance)

Formula
Expense (Beginning Balance) - Interest Expense (Beginning Balance) - FX Losses Expense (Beginning Balance) - Tax Expense (Beginning Balance) - Extraordinary Expense (Beginning Balance)

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Operating Revenue

Formula
Revenue - Interest Revenue - FX Gains Revenue - Extraordinary Revenue

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Operating Revenue (Balance at Date)

Formula
Revenue (Balance at Date) - Interest Revenue (Balance at Date) - FX Gains Revenue (Balance at Date) - Extraordinary Revenue (Balance at Date)

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Operating Revenue (Beginning Balance)

Formula
Revenue (Beginning Balance) - Interest Revenue (Beginning Balance) - FX Gains Revenue (Beginning Balance) - Extraordinary Revenue (Beginning Balance)

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Purchases

Formula
The Purchases measure calculates the Net Change for general ledger accounts categorized as Purchases on the G/L Account Category page and where this category is mapped to the Purchases (Level 3 Category) on the Power BI Account Categories page.

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Revenue

Formula
The Revenue measure calculates the Net Change for general ledger accounts categorized as Income on the G/L Account Category page and where this category is mapped to the Revenue (Level 1 Category) on the Power BI Account Categories page.

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Revenue (Balance at Date)

Formula
The Revenue measure calculates the Balance at Date for general ledger accounts categorized as Income on the G/L Account Category page and where this category is mapped to the Revenue (Level 1 Category) on the Power BI Account Categories page.

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Revenue (Beginning Balance)

Formula
The Revenue (Beginning Balance) measure calculates the Balance at Date for Revenue up to the earliest date in the selected period. The measure calculates the beginning balance by identifying the earliest date in the selected period, removing any existing date filters to consider all historical dates, and then limiting results to transactions on or before this earliest date. This approach yields the balance as of the start of the selected period.

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Tax Expense

Formula
The Tax Expense measure calculates the Net Change for general ledger accounts categorized as Tax Expense on the G/L Account Category page and where this category is mapped to the Tax Expense (Level 2 Category) on the Power BI Account Categories page.

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Tax Expense (Balance at Date)

Formula
The Tax Expense measure calculates the Balance at Date for general ledger accounts categorized as Tax Expense on the G/L Account Category page and where this category is mapped to the Tax Expense (Level 2 Category) on the Power BI Account Categories page.

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Tax Expense (Beginning Balance)

Formula
The Tax Expense (Beginning Balance) measure calculates the Balance at Date for Tax Expense up to the earliest date in the selected period. The measure calculates the beginning balance by identifying the earliest date in the selected period, removing any existing date filters to consider all historical dates, and then limiting results to transactions on or before this earliest date. This approach yields the balance as of the start of the selected period.

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Liquidity KPIs

Cash Ratio

Formula
Liquid Assets / Current Liabilities

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Current Ratio

Formula
Current Assets / Current Liabilities

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Quick Ratio

Formula
( Current Assets - Inventory - Purchase Prepayments ) / Current Liabilities

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Profitability KPIs

Debt Ratio

Formula
Liabilities / Assets

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Debt/Equity Ratio

Formula
Liabilities / Shareholder's Equity

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

EBITDA

Formula
Operating Profit - EBIT + Depreciation and Amortization

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Gross Profit

Formula
Revenue - Cost of Goods Sold

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Gross Profit Margin

Formula
Gross Profit / Revenue

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Net Profit

Formula
Revenue - Cost of Goods Sold - Expense

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Net Profit Margin

Formula
Net Profit / Revenue

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Operating Profit - EBIT

Formula
Operating Revenue - Operating Expense - OPEX

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Operating Profit - EBIT (Balance at Date)

Formula
Operating Revenue (Balance at Date) - Operating Expense - OPEX (Balance at Date)

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Operating Profit - EBIT (Beginning Balance)

Formula
Operating Revenue (Beginning Balance) - Operating Expense - OPEX (Beginning Balance)

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Operating Profit Margin

Formula
Operating Profit - EBIT / Operating Revenue

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Return On Assets - ROA

Formula
Net Profit / Assets

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Return On Capital Employed - ROCE

Formula
Operating Profit - EBIT / Capital Employed

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Return On Equity - ROE

Formula
Net Profit / Shareholder's Equity

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Return On Net Assets - RONA

Formula
Net Profit / ( Fixed Assets + Working Capital )

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Shareholder Equity Ratio

Formula
Shareholder's Equity / Assets

Data Sources

  • G/L Entry
  • G/L Account Category
  • Account Categories

Customer Ledger Measures

Bucket 1 (Receivables)

Formula
The Bucket 1 (Receivables) measure calculates the Amount Receivable (LCY) due, posted, or documented within the first aging bucket. The measure uses the value of the Aging Bucket Period to determine the length of each aging bucket, and then calculates the starting date for each bucket based on the current date.

Data Sources

  • Customer Ledger Entry
  • Detailed Customer Ledger Entry

Bucket 2 (Receivables)

Formula
The Bucket 2 (Receivables) measure calculates the Amount Receivable (LCY) due, posted, or documented within the second aging bucket. The measure uses the value of the Aging Bucket Period to determine the length of each aging bucket, and then calculates the starting date for each bucket based on the current date.

Data Sources

  • Customer Ledger Entry
  • Detailed Customer Ledger Entry
  • Date

Bucket 3 (Receivables)

Formula
The Bucket 3 (Receivables) measure calculates the Amount Receivable (LCY) due, posted, or documented within the third aging bucket. The measure uses the value of the Aging Bucket Period to determine the length of each aging bucket, and then calculates the starting date for each bucket based on the current date.

Data Sources

  • Customer Ledger Entry
  • Detailed Customer Ledger Entry
  • Date

Bucket 4 (Receivables)

Formula
The Bucket 4 (Receivables) measure calculates the Amount Receivable (LCY) due, posted, or documented within the fourth aging bucket. The measure uses the value of the Aging Bucket Period to determine the length of each aging bucket, and then calculates the starting date for each bucket based on the current date.

Data Sources

  • Customer Ledger Entry
  • Detailed Customer Ledger Entry
  • Date

Current (Receivables)

Formula Current (Receivables) measure calculates the Amount Receivable (LCY) for the given period where the data is on or before the last date in the period.

Data Sources

  • Customer Ledger Entry
  • Detailed Customer Ledger Entry
  • Date

Amount Receivable (LCY)

Formula
The Amount Receivable (LCY) measure calculates the total amount of receivables in the local currency for a given period. The measure sums up the amount (in local currency) of the Customer Ledger Entries table to determine the total amount of receivables.

Data Sources

  • Customer Ledger Entry
  • Detailed Customer Ledger Entry

Balance (Accounts Receivable)

Formula
The Balance (Accounts Receivable) measure calculates the total balance of accounts receivable up to a specific date. The measure uses the Amount Receivable (LCY) measure and applies a filter to only include transactions on or before the selected date.

Data Sources

  • Customer Ledger Entry
  • Detailed Customer Ledger Entry
  • Date

Original Amount (LCY)

Formula
The Original Amount (LCY) measure calculates the total amount of original entries for customers in the local currency. The measure sums up the amount (in local currency) of the Customer Ledger Entries table, but only includes entries with the entry type of "Initial Entry".

Data Sources

  • Customer Ledger Entry
  • Detailed Customer Ledger Entry

Vendor Ledger Measures

Bucket 1 (Payables)

Formula
The Bucket 1 (Payables) measure calculates the Amount Payable (LCY) within the first aging bucket. The first uses the Aging Bucket Period to determine the length of the first aging bucket and calculates the starting date for the bucket based on the current date.

Data Sources

  • Vendor Ledger Entry
  • Detailed Vendor Ledger Entry
  • Date

Bucket 2 (Payables)

Formula
The Bucket 2 (Payables) measure calculates the Amount Payable (LCY) within the second aging bucket. The second uses the Aging Bucket Period to determine the length of the second aging bucket and calculates the starting date for the bucket based on the current date.

Data Sources

  • Vendor Ledger Entry
  • Detailed Vendor Ledger Entry
  • Date

Bucket 3 (Payables)

Formula
The Bucket 3 (Payables) measure calculates the Amount Payable (LCY) within the third aging bucket. The third uses the Aging Bucket Period to determine the length of the third aging bucket and calculates the starting date for the bucket based on the current date.

Data Sources

  • Vendor Ledger Entry
  • Detailed Vendor Ledger Entry
  • Date

Bucket 4 (Payables)

Formula
The Bucket 4 (Payables) measure calculates the Amount Payable (LCY) within the fourth aging bucket. The fourth uses the Aging Bucket Period to determine the length of the fourth aging bucket and calculates the starting date for the bucket based on the current date.

Data Sources

  • Vendor Ledger Entry
  • Detailed Vendor Ledger Entry
  • Date

Current (Payables)

Formula Current Payables measures calculates the Amount Payable (LCY) where the Due Date is on or after the last date in period.

Data Sources

  • Vendor Ledger Entry
  • Detailed Vendor Ledger Entry
  • Date

Amount Payable (LCY)

Formula
The Amount Payable (LCY) measure calculates the total amount of payables in the local currency for a given period. The measure sums up the values in the amount (in local currency) column of the Vendor Ledger Entry table to determine the total amount of payables.

Data Sources

  • Vendor Ledger Entry
  • Detailed Vendor Ledger Entry
  • Date

Balance (Accounts Payable)

Formula
The Balance (Accounts Payable) measure calculates the total balance of accounts payable up to a specific date. The measure uses the Amount Payable (LCY) measure and applies a filter to only include transactions on or before the selected date.

Data Sources

  • Vendor Ledger Entry
  • Detailed Vendor Ledger Entry

Original Amount

Formula
The Original Amount measure calculates the total amount of original entries for vendors. The measure uses the Amount Payable (LCY) measure and applies a filter to the Vendor Ledger Entries table to only include entries with the Entry Type equal to "Initial Entry".

Data Sources

  • Vendor Ledger Entry
  • Detailed Vendor Ledger Entry

G/L Entry Measures

Amount

Formula
The Amount measure sums all values in the amount column of the G/L Entry table.

Data Sources

  • G/L Entry

Balance

Formula
The Balance measure calculates the total Amount across all dates, ignoring any filters on the Date table. By removing date-based filtering, this measure provides the full balance from the start to the end of the dataset, regardless of any date selections applied in the report.

Data Sources

  • G/L Entry

Balance at Date

Formula
The Balance at Date measure calculates the cumulative Amount up to the latest date in the current filter context. It removes all date filters, then re-applies a filter to include only dates up to and including the maximum date within the selection. This provides a running balance up to the specified date.

Data Sources

  • G/L Entry

Balance at Date (Neg)

Formula
The Balance at Date (Neg) measure, abbreviated for Balance at Date (Negative), shows the Balance at Date measure as a negative value.

Balance at Date (Neg) = Balance at Date x -1

Data Sources

  • G/L Entry

Net Change

Formula
The Net Change measure is a filtered version of Amount, focusing on non-closing entries to show only the net activity. Net Change filters out entries where Closing Entry is TRUE, excluding closing entries from its calculation.

Data Sources

  • G/L Entry

Net Change (Neg)

Formula
The Net Change (Neg) measure, abbreviated for Net Change (Negative), shows the Net Change measure as a negative value.

Net Change (Neg) = Net Change x -1

Data Sources

  • G/L Entry

Variance to Budget

Formula
The Variance to Budget measure calculates the difference between the actual net change and the budget amount.

Variance to Budget = Net Change - Budget Amount

Data Sources

  • G/L Entry
  • G/L Budget Entry

Variance to Budget %

Formula
Variance to Budget % = Variance to Budget / Net Change

Data Sources

  • G/L Entry
  • G/L Budget Entry

G/L Budget Entry Measures

Budget Amount

Formula
The Budget Amount measure sums up all the budgeted amounts from the G/L Budget Entry table.

Data Sources

  • G/L Budget Entry

Budget Amount at Date

Formula
The Budget Balance at Date measure calculates the budgeted balance at a specific date.

Data Sources

  • G/L Budget Entry

See also

Track your business KPIs with Power BI metrics
Power BI finance app
Ad hoc analysis on finance data
Built-in core finance reports
Built-in fixed assets reports
Built-in accounts receivable reports
Built-in accounts payable reports
Financial analytics overview
Finance overview

Find free e-learning modules for Business Central here