General Ledger Income Statement

This section lists the Key Performance Indicators (KPI) for the General Ledger Income Statement domain and the calculation used to determine their results.


KPI name	KPI calculation
Gross Profit	`Net Amount/Revenue, minus Cost of Goods Sold ([fiscalDate: Sum: glaccounts_peramt] WHERE [GLAccounts.Level 1 Report Code]='Inc_Gros_Prof')`
Revenue	`Gross Amount/Revenue minusDiscounts ([fiscalDate: Sum: glaccounts_peramt] WHERE [GLAccounts.Level 3 Report Code]='Inc_revenue')*-1`
Operating Expenses	`[fiscalDate: Sum: glaccounts_peramt] WHERE [GLAccounts.Level 1 Report Code]='Inc_Operating_Exp'`
Salaries	`([fiscalDate: Sum: glaccounts_peramt] WHERE [GLAccounts.Level 2 Report Code]='Inc_Sal')`
EBITDA	Profit/loss before tax, plus Depreciation, plus Interest, Depreciation, and Amortization SavedExpression('Inc EBIT') - SavedExpression('Inc Depreciation Amortization') EBITDA Expression is combination of following expressions: Inc EBIT = (SavedExpression('Inc Gross Profit') - SavedExpression('Inc Operating Expenses')) + SavedExpression('Inc NonOperating Income') Inc Operating Expenses = [fiscalDate: Sum: glaccounts_peramt] WHERE [GLAccounts.Level 1 Report Code]='Inc_Operating_Exp’ Inc NonOperating Income - [fiscalDate: Sum: glaccounts_peramt] WHERE [GLAccounts.Level 1 Report Code]='Inc_Non-Oper_Exp' Inc Depreciation Amortization = [fiscalDate: Sum: glaccounts_peramt] WHERE [GLAccounts.Level 2 Report Code]='Inc_Depreciation')
EBITDA Margin	`EBITDA divided by Revenues SavedExpression('INC EBITDA') / SavedExpression('Inc Invoices')`
Operating Expense Ratio	`Operating Expenses divided by Revenues ([fiscalDate: Sum: glaccounts_peramt] WHERE [GLAccounts.Level 1 Report Code]='Inc_Operating_Exp')/([fiscalDate: Sum: glaccounts_peramt] WHERE [GLAccounts.Level 3 Report Code]='Inc_revenue')`