Finance KPIs & Measures
Catalog of the 238 measures shipped with the Finance semantic model, grouped by their display folder. Captions are shown in English and German together with the number format. Use any measure with any dimension to build your own analysis.
Balance Sheet
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| Amount Balance Sheet | Bilanz Betrag | #,##0 | Amount for Balance Sheet |
| Amount Balance Sheet PM | Bilanz Betrag PM | #,##0 | Amount for Balance Sheet Previous Month |
| Amount Balance Sheet PrevPeriod | Bilanz Betrag Vorperiode | #,##0 | Amount for Balance Sheet Previous Period (according slicer) |
| Amount Balance Sheet PY | Bilanz Betrag PY | #,##0 | Amount for Balance Sheet Previous Year |
Balance Sheet Deviations
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| Amount Balance Sheet MoM | Bilanz Betrag MoM | #,##0 | Deviation of Balance Sheet Amount vs previous month |
| Amount Balance Sheet MoM % | Bilanz Betrag MoM % | #,##0 % | Deviation of Balance Sheet Amount vs previous month (in %) |
| Amount Balance Sheet PrevPeriod deviation | Bilanz Betrag Vorperiode Δ | #,##0 | Deviation of Balance Sheet Amount vs previous period (according slicer) |
| Amount Balance Sheet PrevPeriod deviation % | Bilanz Betrag Vorperiode Δ % | #,##0 % | Deviation of Balance Sheet Amount vs previous period in % (according slicer) |
| Amount Balance Sheet YoY | Bilanz Betrag YoY | #,##0 | Deviation of Balance Sheet Amount vs previous year |
| Amount Balance Sheet YoY % | Bilanz Betrag YoY % | #,##0 % | Deviation of Balance Sheet Amount vs previous year (in %) |
Balance Sheet KPIs
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| Accruals | Rückstellungen | #,##0 | Accruals from respective Balance Sheet node |
| Accruals Share | Rückstellungsquote | #,##0 % | Accruals divided by Assets |
| Assets | Vermögenswerte (Aktiva) | #,##0 | |
| Assets PrevPeriod | Vermögenswerte Vorperiode | Assets Previous Period (according slicer) | |
| Cash | Cash | #,##0 | Cash from respective Balance Sheet node |
| Debt | Fremdkapital | #,##0 | Total Liabilities And Shareholder Equity - Equity |
| Debt Equity Ratio | Verschuldungsgrad | #,##0 % | Debt divided by Equity |
| Debt Share | Fremdkapitalquote | #,##0 % | Debt divided by Total Liabilities And Shareholder Equity |
| Equity | Eigenkapital | #,##0 | Equity from respective Balance Sheet node |
| Equity Share | Eigenkapitalquote | #,##0 % | Equity divided by Total Liabilities And Shareholder Equity |
| Liabilities | Verbindlichkeiten | #,##0 | Liabilities from respective Balance Sheet node |
| Receivables | Forderungen | #,##0 | Receivables from respective Balance Sheet node |
| Total Liabilities And Shareholder Equity | Kapital (Passiva) |
Balance Sheet KPIs\CardMeasures
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| Accruals Share (in %) | Rückstellungsquote (in %) | #,##0.0 | Accruals divided by Assets |
| Debt Equity Ratio (in %) | Verschuldungsgrad (in %) | #,##0.0 | Debt divided by Equity |
| Equity Share (in %) | Eigenkapitalquote (in %) | #,##0.0 | Equity divided by Total Liabilities And Shareholder Equity |
Balance Sheet KPIs\TimeIntelligence\PY
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| Accruals Share PY | Accruals Share PY | #,##0 % | |
| Assets PY | Assets PY | #,##0 | |
| Debt Equity Ratio PY | Debt Equity Ratio PY | #,##0 % | |
| Equity Share PY | Equity Share PY | #,##0 % |
Balance Sheet KPIs\TimeIntelligence\YoY
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| Accruals Share YoY | Accruals Share YoY | #,##0.0 | |
| Assets YoY | Assets YoY | #,##0 | |
| Debt Equity Ratio YoY | Debt Equity Ratio YoY | #,##0.0 | |
| Equity Share YoY | Equity Share YoY | #,##0.0 |
Balance Sheet KPIs\TimeIntelligence\YoY %
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| Accruals Share YoY % | Accruals Share YoY % | #,##0.0 % | |
| Assets YoY % | Assets YoY % | #,##0.0 % | |
| Debt Equity Ratio YoY % | Debt Equity Ratio YoY % | #,##0.0 % | |
| Equity Share YoY % | Equity Share YoY % | #,##0.0 % |
Basic
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| Finance Amount | Betrag | #,##0 | Amount from general ledger postings |
| Finance Amount ATD | Betrag ATD | #,##0 | All to date cumulation of the amount |
| Finance Amount Credit | Betrag (Haben) | #,##0 | |
| Finance Amount Debit | Betrag (Soll) | #,##0 | |
| Finance Amount End of Period | Betrag (Periodenende) | #,##0 | |
| Finance Amount Inverted | Betrag (invertiert) | #,##0 | |
| Finance Amount Inverted PY | Betrag (invertiert) PY | #,##0 | |
| Finance Amount Inverted YoY | Betrag (invertiert) YoY | #,##0 | |
| Finance Amount Inverted YoY % | Betrag (invertiert) YoY % | #,##0 % | |
| Finance Amount PY | Betrag PY | #,##0 | |
| Finance Amount Start of Period | Betrag (Periodenbeginn) | #,##0 | |
| Finance Amount YoY | Betrag YoY | #,##0 | |
| Finance Amount YoY % | Betrag YoY % | #,##0 % |
Cash Flow
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| Actual Cash Flow | Cash Flow IST | #,##0 | |
| Cash Flow | Cash Flow | #,##0 | |
| Cash Flow Actual Values CurrentPeriod | Cash Flow Actual Values CurrentPeriod | #,##0 | |
| Cash Flow Period Change MoM | Cash Flow Period Change MoM | #,##0 | |
| DEL_Balance Sheet Before and After | DEL_Balance Sheet Before and After | #,##0 |
Cash Flow KPIs
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| Finance CF | CF (Finanzierung) | #,##0 | |
| Invest CF | CF (Investition) | #,##0 | |
| Operative CF | CF (lfd. Geschäft) | #,##0 |
Cash Flow\TimeIntelligence\PY
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| Cash Flow PY | Cash Flow PY | #,##0 |
Cash Flow\TimeIntelligence\YoY
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| Cash Flow YoY | Cash Flow YoY | #,##0 % |
Cash Flow\TimeIntelligence\YoY %
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| Cash Flow YoY % | Cash Flow YoY % | #,##0 % |
Financial KPIs
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| Return on Equity | Eigenkapitalrentabilität | #,##0 % | Net income divided by Equity |
| Return on Investment | Gesamtkapitalrentabilität | #,##0 % | according to "extended" RoI calculation: (Net income / Revenue) x (Revenue / Assets) |
Income Statement
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| Actual Amount Income Statement | GuV Betrag IST | #,##0 | Actual Amount for Income Statement |
| Actual Amount Income Statement PY | GuV Betrag IST PY | #,##0 | Previous Year Actual Amount for Income Statement |
| Amount Income Statement | GuV Betrag | #,##0 | Amount for Income Statement |
| Budget Amount Income Statement | GuV Betrag Budget | #,##0 | Budget Amount for Income Statement |
Income Statement Deviations
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| Actual Amount Income Statement YoY | GuV Betrag IST YoY | #,##0 | Deviation of Income Statement Actual Amount vs previous year |
| Actual Amount Income Statement YoY % | GuV Betrag IST YoY % | #,##0.0 % | Deviation of Income Statement Actual Amount vs previous year (in %) |
| Actual vs Budget Income Statement | GuV Betrag IST vs Budget | #,##0 | Deviation of Income Statement Actual Amount vs Budget Amount |
| Actual vs Budget Income Statement % | GuV Betrag IST vs Budget % | #,##0.0 % | Deviation of Income Statement Actual Amount vs Budget Amount (in %) |
Income Statement KPIs
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| COGS | Wareneinsatz | #,##0 | Costs of Goods Sold of the respective Income Statement node |
| Depreciations | Abschreibungen | #,##0 | ... of the respective Income Statement node |
| EBIT | EBIT | #,##0 | Earnings before interests and tax |
| EBIT Margin | EBIT Marge | #,##0.0 % | |
| EBITDA | EBITDA | #,##0 | Earnings before interests, taxes, depreciation and amortization |
| EBITDA Margin | EBITDA Marge | #,##0.0 % | |
| EBT | EBT | #,##0 | Earnings before taxes |
| Fix costs | Fixkosten | #,##0 | (Operating costs - COGS) + Interests + Taxes |
| Gross profit | Bruttomarge | #,##0 | |
| Gross profit % | Bruttomarge % | #,##0.0 % | |
| Interests | Zinsen | #,##0 | ... of the respective Income Statement node |
| LaborCosts | Personaleinsatz | #,##0 | ... of the respective Income Statement node |
| Minimum Revenue | Mindest Umsatz | #,##0 | Minimum Revenue (to cover fix costs) |
| Net income | Jahresüberschuss | #,##0 | Net Profit (or Loss) |
| Operating Costs | Operative Kosten | #,##0 | |
| Operating Income | Operative Erlöse | #,##0 | |
| Revenue | Umsatzerlöse | #,##0 | ... of the respective Income Statement node |
| Taxes | Steuern | #,##0 | ... of the respective Income Statement node |
| Trading Margin | Handelsspanne | #,##0.0 % |
Income Statement KPIs\CardMeasures
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| EBIT Margin (in %) | EBIT Marge (in %) | #,##0.0 | |
| EBITDA Margin (in %) | EBITDA Marge (in %) | #,##0.0 | |
| Gross Profit (in %) | Bruttomarge (in %) | #,##0.0 |
Income Statement KPIs\TimeIntelligence\PY
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| EBIT Margin PY | EBIT Margin PY | #,##0.0 % | |
| EBIT PY | EBIT PY | #,##0 | |
| EBITDA Margin PY | EBITDA Margin PY | #,##0.0 % | |
| EBITDA PY | EBITDA PY | #,##0 | |
| Fix costs PY | Fix costs PY | #,##0 | |
| Gross profit % PY | Gross profit % PY | #,##0.0 % | |
| Net income PY | Jahresüberschuss PY | #,##0 | Net Profit (or Loss) of Previous Year |
| Revenue PY | Revenue PY | #,##0 |
Income Statement KPIs\TimeIntelligence\YoY
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| EBIT Margin YoY | EBIT Margin YoY | #,##0.0 | |
| EBIT YoY | EBIT YoY | #,##0 | |
| EBITDA Margin YoY | EBITDA Margin YoY | #,##0.0 | |
| EBITDA YoY | EBITDA YoY | #,##0 | |
| Fix costs YoY | Fix costs YoY | #,##0 | |
| Gross profit % YoY | Gross profit % YoY | #,##0.0 | |
| Net income YoY | Jahresüberschuss YoY | #,##0 | Deviation of Net Profit (or Loss) compared to Previous Year |
| Revenue YoY | Revenue YoY | #,##0 % |
Income Statement KPIs\TimeIntelligence\YoY %
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| EBIT Margin YoY % | EBIT Margin YoY % | #,##0 % | |
| EBIT YoY % | EBIT YoY % | #,##0 % | |
| EBITDA Margin YoY % | EBITDA Margin YoY % | #,##0 % | |
| EBITDA YoY % | EBITDA YoY % | #,##0 % | |
| Fix costs YoY % | Fix costs YoY % | #,##0 % | |
| Gross profit % YoY % | Gross profit % YoY % | #,##0 % | |
| Net income YoY % | Net income YoY % | #,##0 % | Deviation of Net Profit (or Loss) compared to Previous Year |
| Revenue YoY % | Revenue YoY % | #,##0 % |
Tech Measures_BalanceSheet
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| Actual Amount Balance Sheet (Not In Scope) | Bilanz Betrag IST (ausgeblendet) | #,##0 | |
| Amount Balance Sheet (Not In Scope) | Amount Balance Sheet (Not In Scope) | #,##0 | |
| ScopeCurrentLevel_BS | ScopeCurrentLevel_BS | ||
| ScopeInclude_BS | ScopeInclude_BS | ||
| ScopeMaxLevel_BS | ScopeMaxLevel_BS |
Tech Measures_CashFlow
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| Actual Cash Flow (Not In Scope) | Cash Flow IST (ausgeblendet) | #,##0 | |
| Cash Flow (Not In Scope) | Cash Flow (ausgeblendet) | #,##0 | |
| ScopeCurrentLevel_CF | ScopeCurrentLevel_CF | ||
| ScopeInclude_CF | ScopeInclude_CF | ||
| ScopeMaxLevel_CF | ScopeMaxLevel_CF |
Tech Measures_Income Statement
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| Actual Amount Income Statement (Not In Scope) | GuV Betrag IST (ausgeblendet) | #,##0 | |
| Amount Income Statement (Not In Scope) | GuV Betrag (ausgeblendet) | #,##0 | |
| ScopeCurrentLevel_IS | ScopeCurrentLevel_IS | ||
| ScopeInclude_IS | ScopeInclude_IS | ||
| ScopeMaxLevel_IS | ScopeMaxLevel_IS |
General
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| AccountBalancePage Label | AccountBalancePage Label | ||
| AccountMovementPage Label | AccountMovementPage Label | ||
| AccountPage Label | AccountPage Label | ||
| Accounts Page Label | Accounts Page Label | ||
| BackgroundColorFormatting | BackgroundColorFormatting | ||
| Balance by Date Label | Balance by Date Label | ||
| Balance per LedgerAccount Label | Balance per LedgerAccount Label | ||
| BalanceSheetPage Label | BalanceSheetPage Label | ||
| Booking lines Label | Booking lines Label | ||
| Budget Label | Budget Label | ||
| by Customer Page Label | by Customer Page Label | ||
| by Employee Page Label | by Employee Page Label | ||
| by Item Page Label | by Item Page Label | ||
| CashFlowPage Label | CashFlowPage Label | ||
| Client Label | Client Label | ||
| CurPeriod Label | CurPeriod Label | ||
| Customer Documents Label | Customer Documents Label | ||
| DimensionPage Label | DimensionPage Label | ||
| Document Type Label | Document Type Label | ||
| Employee Label | Employee Label | ||
| First Dim1Name | First Dim1Name | ||
| First Dim2Name | First Dim2Name | ||
| IncomeStatementPage Label | IncomeStatementPage Label | ||
| Invoice Customer Label | Invoice Customer Label | ||
| Invoice Label | Invoice Label | ||
| Item Label | Item Label | ||
| ItemPage Label | ItemPage Label | ||
| JournalPage Label | JournalPage Label | ||
| KPI Title | KPI Title | ||
| KPI Value | KPI Value | ||
| Last Refresh Label | Last Refresh Label | ||
| Last x Months Label | Last x Months Label | ||
| Last X Months Value | Last X Months Value | 0 | |
| LedgerAccount Label | LedgerAccount Label | ||
| LedgerTransType Label | LedgerTransType Label | ||
| Map Label | Map Label | ||
| Monthly Label | Monthly Label | ||
| Number of Orders by Dealsize Label | Number of Orders by Dealsize Label | ||
| Order Customer Label | Order Customer Label | ||
| OverviewPage Label | OverviewPage Label | ||
| Period Label | Period Label | ||
| Profit and Sales by Employee Label | Profit and Sales by Employee Label | ||
| Profit by Item Label | Profit by Item Label | ||
| QAPage Label | QAPage Label | ||
| Report Label | Report Label | ||
| Revenue Profit Bridge Label | Revenue Profit Bridge Label | ||
| Sales Amount and development by Location Label | Sales Amount and development by Location Label | ||
| Sales Amount by Document Type Label | Sales Amount by Document Type Label | ||
| Sales Amount vs PY by Item Category Label | Sales Amount vs PY by Item Category Label | ||
| Sales Amount vs PY Label | Sales Amount vs PY Label | ||
| Sales and Profit by Primary Vendor Label | Sales and Profit by Primary Vendor Label | ||
| Sales and Profit development by Employee Label | Sales and Profit development by Employee Label | ||
| Sales Invoices Label | Sales Invoices Label | ||
| Sales Orders Label | Sales Orders Label | ||
| Sales Price development Label | Sales Price development Label | ||
| Sales Shipments Label | Sales Shipments Label | ||
| Sales trend Label | Sales trend Label | ||
| Select_A_KPI Label | Select_A_KPI Label | ||
| Share of Profit Label | Share of Profit Label | ||
| Statistic by Customer Label | Statistic by Customer Label | ||
| Statistic by Employee Label | Statistic by Employee Label | ||
| Statistic by Item Label | Statistic by Item Label | ||
| Statistic by ItemCategory Label | Statistic by ItemCategory Label | ||
| Statistics byItem Label | Statistics byItem Label | ||
| Summary Page Label | Summary Page Label | ||
| SummaryPage Label | SummaryPage Label | ||
| Today Label | Today Label | ||
| Unit Label | Unit Label | ||
| Voucher Label | Voucher Label |
Tech
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| App Version | App Version | ||
| Current User | Current User | ||
| DaysInFilter | Tage gefiltert | #,##0 | |
| DynMeasure | DynMeasure | #,##0 | |
| EffectiveDate | Datum (effective) | ||
| First LedgerAccount | First LedgerAccount | ||
| First LedgerTransType | First LedgerTransType | ||
| First Voucher | First Voucher | ||
| Last Refresh | Letztes Update | ||
| Last Refresh Card | Last Refresh Card | ||
| LedgerRowCount | Buchungszeilen | #,##0 | Number of ledger postings |
| Today Card | Today Card |
Tech\Formatting
| Measure (EN) | Measure (DE) | Format | Description |
|---|---|---|---|
| Accruals Share YoY CF | Accruals Share YoY CF | ||
| Accruals Share YoY Icon | Accruals Share YoY Icon | ||
| Assets YoY CF | Assets YoY CF | ||
| Assets YoY Icon | Assets YoY Icon | ||
| Cash Flow YoY CF | Cash Flow YoY CF | ||
| Cash Flow YoY Icon | Cash Flow YoY Icon | ||
| Debt Equity Ratio YoY CF | Debt Equity Ratio YoY CF | ||
| Debt Equity Ratio YoY Icon | Debt Equity Ratio YoY Icon | ||
| EBIT Margin YoY CF | EBIT Margin YoY CF | ||
| EBIT Margin YoY Icon | EBIT Margin YoY Icon | ||
| EBIT YoY CF | EBIT YoY CF | ||
| EBIT YoY Icon | EBIT YoY Icon | ||
| EBITDA Margin YoY CF | EBITDA Margin YoY CF | ||
| EBITDA Margin YoY Icon | EBITDA Margin YoY Icon | ||
| Equity Share YoY CF | Equity Share YoY CF | ||
| Equity Share YoY Icon | Equity Share YoY Icon | ||
| Fix costs YoY CF | Fix costs YoY CF | ||
| Fix costs YoY Icon | Fix costs YoY Icon | ||
| Gross profit % YoY CF | Gross profit % YoY CF | ||
| Gross profit % YoY Icon | Gross profit % YoY Icon | ||
| Net income YoY CF | Net income YoY CF | ||
| Net income YoY Icon | Net income YoY Icon | ||
| Revenue YoY CF | Revenue YoY CF | ||
| Revenue YoY Icon | Revenue YoY Icon |