General Ledger
This section provides details about Oracle Fusion ERP Analytics General Ledger subject area metrics.
Financials - GL Account Analysis
These metrics will be used in the Ledger Currency (LC) fact folder and Document Currency (DC) fact folder in subject areas. Metrics in these folders will show amounts in their respective currencies.
| Metric | Metric Definition |
|---|---|
| Credit Amount (Accounted) | Shows the subledger credit amount for transactions with subledger details and for other journals it shows the journal credit amount. |
| Debit Amount (Accounted) | Shows the subledger debit amount for transactions with subledger details and for other journals it shows the journal debit amount. |
| Journal Credit Amount (Accounted) | Shows the sum of credit journal entries amount for specified accounts. |
| Journal Debit Amount (Accounted) | Shows the sum of debit journal entries amount for specified accounts. |
| Journal Net Amount (Accounted) | Shows the activity amount of the specified accounts. Where activity amount = sum of Journal debit amount (accounted) - sum of Journal credit amount (accounted). |
| Net Amount (Accounted) | Shows the activity amount of the specified accounts. Where activity amount = sum of debit amount (accounted) - sum of credit amount (accounted). |
Financials - GL Balance Sheet
These metrics are used in the Analytics Currency (AC) fact folder and Ledger Currency (LC) fact folder in subject areas. In addition to Analytic currency and Ledger Currency, Document Currency (DC) is available for metrics in GL Balance - Entered fact folder. Analytics currency and exchange rate type are configured during product implementation. Exchange rate date basis is Period End Date to convert to analytics currency. Metrics in these folders show amounts in their respective currencies.
Use this spreadsheet to view a list of prebuilt Financial Categories used in GL Metrics and business metrics.
| Metric | Metric Definition |
|---|---|
| Absolute Activity Amount - Entered | Shows the entered currency absolute activity amount of the specified accounts, where activity amount is sum of debit amount - sum of credit amount. This metric can be analyzed in Document currency, Ledger Currency and Analytic currency for Actuals and Encumbrance. For Budgets, this is available only in Document currency. |
| Absolute Balance Amount - Entered | Shows the entered currency absolute balance amount of the specified accounts. This metric can be analyzed in Document currency, Ledger Currency and Analytic currency for Actuals and Encumbrance. For Budgets, this is available only in Document currency. |
| Activity (STAT) | Shows the activity amount of the specified accounts in STAT currency. Where activity (STAT) = sum of debit (STAT) - sum of credit (STAT). |
| Activity Amount - Entered | Shows the entered currency activity amount of the specified accounts, where activity amount is sum of debit amount - sum of credit amount. This metric can be analyzed in Document currency, Ledger Currency and Analytic currency for Actuals and Encumbrance. For Budgets, this is available only in Document currency. |
| Asset Turnover Ratios. AP turnover | This metric is computed as follows : daily purchases for the period * 365 / AP amount. Where: daily purchases for the period = purchases / number for days for the selected period. |
| Asset Turnover Ratios. AR turnover | This metric is computed as follows : daily revenue for the period * 365 / AR amount. Where: daily revenue for the period = revenue / number for days for the selected period. |
| Asset Turnover Ratios. Avg Inventory Days | This metric is computed as follows : inventories / daily cost of revenue. Where: daily cost of revenue = cost of revenue / number for days from beginning day to till date of the fiscal year. |
| Asset Turnover Ratios. Cash Cycle | This metric is computed as follows : days sales outstanding - YTD revenue (+) avg inventory days (-) days payables outstanding - YTD purchase. Where: days sales outstanding - YTD revenue = AR amount / daily revenue. Days payables outstanding - YTD purchase = AP amount / daily purchases. |
| Asset Turnover Ratios. Days Payable Outstanding | This metric is computed as follows: accounts payable / daily cost of revenue. Where: daily cost of revenue = cost of revenue YTD/ cumulative number of days. |
| Asset Turnover Ratios. Days Sales outstanding | This metric is computed as follows : accounts receivable / daily revenue. Where: daily revenue = revenue YTD /number of cumulative elapsed days. . |
| Asset Turnover Ratios. Fixed Assets Turnover | This metric is computed as follows : daily revenue * 365 / net PPE. Where: daily revenue = revenue / number for days from beginning day to till date of the fiscal year. . |
| Asset Turnover Ratios. Inventory Turnover | This metric is computed as follows : daily cost of revenue * 365 / inventories. Where: daily cost of revenue = cost of revenue / number for days from beginning day to till date of the fiscal year. |
| Asset Turnover Ratios. LT Assets Turnover | This metric is computed as follows : daily revenue * 365 / long term assets. Where: daily revenue = revenue / number for days from beginning day to till date of the fiscal year. |
| Asset Turnover Ratios. Operating Cycle | This metric is computed as follows : days sales outstanding + avg inventory days. |
| Asset Turnover Ratios. Total Assets Turnover | This metric is computed as follows : daily revenue * 365 / total assets. |
| Asset Turnover Ratios. Working Capital Turnover | This metric is computed as follows : daily revenue * 365 / (current assets - current liabilities). |
| Balance Amount - Entered | Shows the entered currency balance of the specified accounts. This metric can be analyzed in Document currency, Ledger Currency and Analytic currency for Actuals and Encumbrance. For Budgets, this is available only in Document currency. |
| Balance Sheet Ratios. CAPEX | Activities for a period range for financial category for property, plant, and equipment (PPE). |
| Balance Sheet Ratios. Capex Ratio | This metric is computed as follows : operating cash Flow / CAPEX. Where: operating cash Flow = net income + depreciation expenses - inventories - accounts receivable + accounts payable + accrued liabilities + other current liabilities - prepaid expenses - other current assets. |
| Balance Sheet Ratios. Current Ratio | This metric is computed as follows : current assets / current liabilities. |
| Balance Sheet Ratios. Days Cash in Hand | This metric is computed as follows : cash / (daily total operating expenses - daily depreciation expenses). Where: daily total operating expenses = total operating expenses / number for days from beginning day to till date of the fiscal year. daily depreciation expenses = depreciation expenses / number for days from beginning day to till date of the fiscal year. |
| Balance Sheet Ratios. Debt To Equity | This metric is computed as follows : total liabilities / total shareholders funds Where: total liabilities = current liabilities + long term liabilities. |
| Balance Sheet Ratios. EBIT YTD | This metric is computed as follows: revenue YTD - cost of revenue YTD - sales & marketing expenses YTD - other operating expenses YTD - R&D expenses YTD - depreciation expenses YTD. |
| Balance Sheet Ratios. Interest Expense YTD | Activities for year-to-date for the INT EXP financial category. |
| Balance Sheet Ratios. NWC to Assets | This metric is computed as follows : (current assets - current liabilities) / total assets. |
| Balance Sheet Ratios. Quick Ratio | This metric is computed as follows : (cash + AR amount + prepaid expenses + deferred cost of goods sold+ other current assets) / current liabilities. |
| Balance Sheet Ratios. Times interest Earned | This metric is computed as follows : EBIT YTD / interest expense. |
| Balance Sheet Statement. Accounts Payable | Shows the accounts payable balance for a particular time period for the AP financial category. |
| Balance Sheet Statement. Accounts Receivable | Shows the accounts receivable balance for a particular time period for the AR financial category. |
| Balance Sheet Statement. Accrued Liabilities | Shows the accrued liabilities for a particular time period for the ACC LIAB financial category. |
| Balance Sheet Statement. Accumulated Depreciation | Shows the accumulated depreciation for a particular time period for the ACC DEPCN financial category. |
| Balance Sheet Statement. Cash | Shows the cash balance for a particular time period for the CASH financial category. |
| Balance Sheet Statement. Common Stock | Shows the common stock for a particular time period for the CMMN STOCK financial category. |
| Balance Sheet Statement. Current Assets | This metric is computed as follows : cash + inventories + prepaid expenses + other current assets + accounts receivable + deferred cost of goods sold. |
| Balance Sheet Statement. Current Liabilities | This metric is computed as follows : accrued liabilities + short term borrowing + other current liabilities + accounts payable + deferred revenue +tax liabilities. |
| Balance Sheet Statement. Deferred Cost of Goods Sold | Shows the deferred cost of goods sold balance for a particular time period for the DEFERRED COGS financial category. |
| Balance Sheet Statement. Deferred Revenue | Shows the deferred revenue for a particular time period for the DEFERRED REVENUE financial category. |
| Balance Sheet Statement. Finished Goods inventory | Shows the finished goods inventory balance for a particular time period for the FG INV financial category. |
| Balance Sheet Statement. Goodwill | Shows the goodwill for a particular time period for the GOODWILL financial category. |
| Balance Sheet Statement. Inventories | The metric is computed as follows: raw material inventory + work in process inventory + finished goods inventory. |
| Balance Sheet Statement. Long Term Assets | This metric is computed as follows : net PPE + goodwill + other asset. |
| Balance Sheet Statement. Long term Debt | Shows the long term debt for a particular time period for the LT DEBT financial category. |
| Balance Sheet Statement. Long Term Liabilities | This metric is computed as follows : long term debt + other liabilities. |
| Balance Sheet Statement. Net PPE | This metric is computed as follows : PPE - accumulated depreciation. |
| Balance Sheet Statement. Net Working Capital | This metric is computed as follows : current assets - current liabilities. |
| Balance Sheet Statement. Other Assets | Shows the other assets for a particular time period for the OTHER ASSET financial category. |
| Balance Sheet Statement. Other Current Assets | Shows the other current assets balance for a particular time period for the OTHER CA financial category. |
| Balance Sheet Statement. Other Current Liabilities | Shows the other current liabilities during a particular time period for the OTHER CL financial category. |
| Balance Sheet Statement. Other Equity | Shows the other equity balance for a particular time period for the OTHER EQUITY financial category. |
| Balance Sheet Statement. Other Liabilities | Shows the other liabilities for a particular time period for the OTHER LIAB financial category. |
| Balance Sheet Statement. PPE | Shows the property, plant, and equipment (PPE) for a particular time period for the PPE financial category. |
| Balance Sheet Statement. Preferred Stock | Shows the preferred stock for a particular time period for the PREF STOCK financial category. |
| Balance Sheet Statement. Prepaid Expenses | Shows the prepaid expenses balance for a particular time period for the PPAID EXP financial category. |
| Balance Sheet Statement. Raw Material Inventory | Shows the raw material inventory balance for a particular time period for the RM INV financial category. |
| Balance Sheet Statement. Retained Earnings | Shows the retained earnings balance for a particular time period for the RET EARNING financial category. |
| Balance Sheet Statement. Short Term Borrowing | Shows the short term borrowing for a particular time period for the ST BORR financial category. |
| Balance Sheet Statement. Tax Liabilities | Shows the tax liabilities for a particular time period for the TAX LIAB financial category. |
| Balance Sheet Statement. Total Assets | This metric is computed as follows : long term assets + current assets. |
| Balance Sheet Statement. Total Liabilities | This metric is computed as follows : current liabilities + long term liabilities. |
| Balance Sheet Statement. Total Liabilities Shareholders Funds | This metric is computed as follows : total liabilities + total shareholders funds. |
| Balance Sheet Statement. Total Shareholders Funds | This metric is computed as follows: preferred stock + common stock + retained earnings + other equity. |
| Balance Sheet Statement. Work in Process inventory | Shows the work in process inventory balance for a particular time period for the WIP INV financial category. |
| Closing (STAT) | Shows the closing balance of the specified accounts in STAT currency. |
| Closing Amount - Entered | Shows the entered currency Closing amount of the specified accounts. The closing amount will show zero if the balance amount is null, this is the only difference between the balance amount and closing amount. This metric can be analyzed in Document currency, Ledger Currency and Analytic currency for Actuals and Encumbrance.For Budgets, this is available only in Document currency. |
| Credit (STAT) | Shows the sum of credit entries amount for specified accounts in STAT currency. |
| Credit Amount - Entered | Shows the entered currency credit amount of the specified accounts. This metric can be analyzed in Document currency, Ledger Currency and Analytic currency for Actuals and Encumbrance. For Budgets, this is available only in Document currency. |
| Debit (STAT) | Shows the sum of debit entries amount for the specified accounts in STAT currency. |
| Debit Amount - Entered | Shows the entered currency debit amount of the specified accounts. This metric can be analyzed in Document currency, Ledger Currency and Analytic currency for Actuals and Encumbrance. For Budgets, this is available only in Document currency. |
| GL Balance. Absolute Activity Amount | Shows the absolute activity amount of the specified accounts. activity amount = sum of debit amount - sum of credit amount. |
| GL Balance. Absolute Balance Amount | Shows the absolute balance amount of the specified accounts. |
| GL Balance. Activity Amount | Shows the activity amount of the specified accounts. Where activity amount = sum of debit amount - sum of credit amount. |
| GL Balance. Balance Amount | Shows the balance of the specified accounts. |
| GL Balance. Closing Amount | Shows the closing balance of the specified accounts. The closing amount will show zero if the balance amount is null, this is the only difference between the balance amount and closing amount. |
| GL Balance. Credit Amount | Shows the sum of credit entries amount for specified accounts. |
| GL Balance. Debit Amount | Shows the sum of debit entries amount for the specified accounts. |
| GL Balance. Opening Amount | Shows the opening balance of the specified accounts. This metric is computed as follows : balance amount - activity amount. |
| Opening (STAT) | Shows the opening balance of the specified accounts in STAT currency. |
| Opening Amount - Entered | Shows the entered currency opening amount of the specified accounts, where opening amount is balance amount - activity amount. This metric can be analyzed in Document currency, Ledger Currency and Analytic currency for Actuals and Encumbrance. For Budgets, this is available only in Document currency. |
Financials - GL Budgets
These metrics will be used in the Analytics Currency (AC) fact folder and Ledger Currency (LC) fact folder in Subject Areas. Analytics Currency and exchange rate type will be configured during product implementation. Exchange rate date basis will be Creation Date to convert to Analytics currency. Metrics in these folders will show amounts in their respective currencies.
| Metric | Metric Definition |
|---|---|
| Budget Absolute Activity Amount | Shows the absolute activity amount of the specified accounts. activity amount=sum of debit amount-sum of credit amount. |
| Budget Activity (STAT) | Shows the activity amount of the specified accounts in STAT currency. Where budget activity (STAT) = sum of debit (STAT) - sum of credit (STAT). |
| Budget Activity Amount | Shows the activity amount of the specified accounts. activity amount = sum of debit amount - sum of credit amount. |
| Budget Credit (STAT) | Shows the sum of credit entries amount for specified accounts in STAT currency. |
| Budget Credit Amount | Shows sum of credit entries amount for specified accounts. |
| Budget Debit (STAT) | Shows the sum of debit entries amount for the specified accounts in STAT currency. |
| Budget Debit Amount | Shows the sum of debit entries amount for the specified accounts. |
Financials - GL Detail Transactions
These metrics will be used in the Analytics Currency (AC) fact folder, Ledger Currency (LC) fact folder and Document Currency (DC) fact folder in Subject Areas. Analytics Currency and exchange rate type will be configured during product implementation. Exchange rate date basis will be Currency Conversion Date and if not available Accounting date will be used to convert to Analytics currency. Metrics in these folders will show amounts in their respective currencies. Currently only only posted journal details are supported.
| Metric | Metric Definition |
|---|---|
| Credit (STAT) | Shows the sum of credit entries amount for specified accounts in STAT currency. |
| Debit (STAT) | Shows the sum of debit entries amount for the specified accounts in STAT currency. |
| GL Detail Transactions. Credit Amount | Shows the sum of credit entries amount for specified accounts. |
| GL Detail Transactions. Debit Amount | Shows the sum of debit entries amount for specified accounts. |
| GL Detail Transactions. Net Amount | Shows the net amount of the specified accounts. Where net amount = sum of debit amount - sum of credit amount. |
| Total (STAT) | Shows the activity amount of the specified accounts in STAT currency. Where total (STAT) = sum of debit (STAT) - sum of credit (STAT). |
| Journal Batches Count | Shows the distinct count of Journal Batches. |
| Journal Headers Count | Shows the distinct count of Journal Headers. |
| Journal Lines Count | Shows the distinct count of Journal Lines. |
| Unposted Journal Batches Count | Shows the distinct count of Unposted Journal Batches. |
| Unposted Journal Headers Count | Shows the distinct count of Unposted Journal Headers. |
| Unposted Journal Lines Count | Shows the distinct count of Unposted Journal Lines. |
| Unposted Net Amount | Shows the net unposted amount of the specified accounts. |
| Unposted (STAT) | Shows the Unposted activity in STAT currency of the specified accounts. |
Financials - GL Profitability
These metrics are used in the Analytics Currency (AC) fact folder and Ledger Currency (LC) fact folder in subject areas. In addition to Analytic currency and Ledger Currency, Document Currency (DC) is available for metrics in GL Balance - Entered fact folder. Analytics currency and exchange rate type are configured during product implementation. Exchange rate date basis is Period End Date to convert to analytics currency. Metrics in these folders show amounts in their respective currencies.
Use this spreadsheet to view a list of prebuilt Financial Categories used in GL Metrics and business metrics.
| Metric | Metric Definition |
|---|---|
| Absolute Activity Amount - Entered | Shows the entered currency absolute activity amount of the specified accounts, where activity amount is sum of debit amount - sum of credit amount. This metric can be analyzed in Document currency, Ledger Currency and Analytic currency for Actuals and Encumbrance. For Budgets, this is available only in Document currency. |
| Absolute Balance Amount - Entered | Shows the entered currency absolute balance amount of the specified accounts. This metric can be analyzed in Document currency, Ledger Currency and Analytic currency for Actuals and Encumbrance. For Budgets, this is available only in Document currency. |
| Activity (STAT) | Shows the activity amount of the specified accounts in STAT currency. Where activity (STAT) = sum of debit (STAT) - sum of credit (STAT). |
| Activity Amount - Entered | Shows the entered currency activity amount of the specified accounts, where activity amount is sum of debit amount - sum of credit amount. This metric can be analyzed in Document currency, Ledger Currency and Analytic currency for Actuals and Encumbrance. For Budgets, this is available only in Document currency. |
| Balance Amount - Entered | Shows the entered currency balance of the specified accounts. This metric can be analyzed in Document currency, Ledger Currency and Analytic currency for Actuals and Encumbrance. For Budgets, this is available only in Document currency. |
| Closing (STAT) | Shows the closing balance of the specified accounts in STAT currency. |
| Closing Amount - Entered | Shows the entered currency Closing amount of the specified accounts. The closing amount will show zero if the balance amount is null, this is the only difference between the balance amount and closing amount. This metric can be analyzed in Document currency, Ledger Currency and Analytic currency for Actuals and Encumbrance. For Budgets, this is available only in Document currency. |
| Cost Details. Cost Ratios. Cost of revenue to Revenue % | This metric is computed as follows : (cost of revenue / revenue) * 100. |
| Cost Details. Cost Ratios. Interest Expenses to Revenue % | This metric is computed as follows : (interest expense / revenue) * 100. |
| Cost Details. Cost Ratios. Other Operating Expenses to Revenue % | This metric is computed as follows : (other operating expenses / revenue) * 100. |
| Cost Details. Cost Ratios. R&D Expenses to Revenue % | This metric is computed as follows : (R&D expenses / revenue) * 100. |
| Cost Details. Cost Ratios. Sales & Marketing Expenses to Revenue % | This metric is computed as follows : (sales & marketing expense / revenue) * 100. |
| Cost Details. Cost Ratios. Total Operating Expenses to Revenue % | This metric is computed as follows : (total operating expenses / revenue) * 100. |
| Cost Details. Other Operating Expenses. Contracting Expenses | Activities for a period range for the CONT EXP financial category. |
| Cost Details. Other Operating Expenses. Employee Benefits Related Expenses | Employee Benefits Related expenses metric is the activities for a period range for the financial category EMP BENFT. |
| Cost Details. Other Operating Expenses. Employee Overtime Expenses | Activities for a period range for the EMP OVERTIME financial category. |
| Cost Details. Other Operating Expenses. Employee Support Expenses | Activities for a period range for the EMP SUPP financial category. |
| Cost Details. Other Operating Expenses. General Admin and Other Payroll | Activities for a period range for the GEN PAYROLL financial category. |
| Cost Details. Other Operating Expenses. Miscellaneous Operating Expenses | Activities for a period range for the MISC OPER EXP financial category. |
| Cost Details. Other Operating Expenses. Other Operating Expenses (Financial Category) | Activities for a period range for the OTHER OPER EXP financial category. |
| Cost Details. Other Operating Expenses. Product Variance Expenses | Activities for a period range for the VARIANCE EXP financial category. |
| Cost Details. R&D Expenses. Other R&D Expenses | Activities for a period range for the OTHER R&D EXP financial category. |
| Cost Details. R&D Expenses. R&D Expenses | Activities for a period range for sum of financial categories with these values OTHER R&D EXP, and R&D PAYROLL. |
| Cost Details. R&D Expenses. R&D Payroll Expenses | Activities for a period range for the R&D PAYROLL financial category. |
| Cost Details. Sales and Marketing Expenses. Freight Expenses | Activities for a period range for the FREIGHT financial category. |
| Cost Details. Sales and Marketing Expenses. Marketing Payroll Expenses | Activities for a period range for the MKTG PAYROLL financial category. |
| Cost Details. Sales and Marketing Expenses. Other Marketing Expenses | Activities for a period range for the OTHER MKTG EXP financial category. |
| Cost Details. Sales and Marketing Expenses. Other Sales Expenses | Activities for a period range for the OTHER SLS EXP financial category. |
| Cost Details. Sales and Marketing Expenses. Sales & Marketing Expenses | Activities for a period range for sum of financial categories with these values: MKTG PAYROLL, SLS PAYROLL, OTHER MKTG EXP, FREIGHT, OTHER SLS EXP, and TRAVEL & ENT EXP. |
| Cost Details. Sales and Marketing Expenses. Sales Payroll Expenses | Activities for a period range for the SLS PAYROLL financial category. |
| Cost Details. Sales and Marketing Expenses. Travel & Entertainment Expenses | Activities for a period range for the TRAVEL & ENT EXP financial category. |
| Credit (STAT) | Shows the sum of credit entries amount for specified accounts in STAT currency. |
| Credit Amount - Entered | Shows the entered currency credit amount of the specified accounts. This metric can be analyzed in Document currency, Ledger Currency and Analytic currency for Actuals and Encumbrance. For Budgets, this is available only in Document currency. |
| Debit (STAT) | Shows the sum of debit entries amount for the specified accounts in STAT currency. |
| Debit Amount - Entered | Shows the entered currency debit amount of the specified accounts. This metric can be analyzed in Document currency, Ledger Currency and Analytic currency for Actuals and Encumbrance. For Budgets, this is available only in Document currency. |
| GL Balance. Absolute Activity Amount | Shows the absolute activities amount of the specified accounts. Where activity amount = sum of debit amount - sum of credit amount. |
| GL Balance. Absolute Balance Amount | Shows the absolute balance amount of the specified accounts. |
| GL Balance. Activity Amount | Shows the activity amount of the specified accounts. Where activity amount = sum of debit amount - sum of credit amount. |
| GL Balance. Balance Amount | Shows the balance of the specified accounts. |
| GL Balance. Closing Amount | Shows the closing balance of the specified accounts. The closing amount will show zero if the balance amount is null, this is the only difference between the balance amount and closing amount. |
| GL Balance. Credit Amount | Shows the sum of credit entries amount for specified accounts. |
| GL Balance. Debit Amount | Shows the sum of debit entries amount for specified accounts. |
| GL Balance. Opening Amount | Shows the opening balance of the specified accounts. This metric is computed as follows : balance amount - activity amount. |
| Opening (STAT) | Shows the opening balance of the specified accounts in STAT currency. |
| Opening Amount - Entered | Shows the entered currency opening amount of the specified accounts, where opening amount is balance amount - activity amount. This metric can be analyzed in Document currency, Ledger Currency and Analytic currency for Actuals and Encumbrance. For Budgets, this is available only in Document currency. |
| Profit and Loss. Cost of Revenue | Activities for a period range for the COGS, PURCH, and RM CONS financial category. |
| Profit and Loss. Depreciation Expenses | Activities for a period range for the DEPCN financial category. |
| Profit and Loss. EBIT | This metric is computed as follows : revenue - cost of revenue - sales & marketing expenses - other operating expenses - R&D expenses - depreciation expenses. |
| Profit and Loss. EBITDA | This metric is computed as follows : revenue - cost of revenue - sales & marketing expenses - other operating expenses - R&D expenses. |
| Profit and Loss. EBITDA Margin % | This metric is computed as follows : (EBITDA / revenue) * 100. |
| Profit and Loss. EBIT Margin % | This metric is computed as follows : (EBIT / revenue) * 100. |
| Profit and Loss. EBT | This metric is computed as follows : revenue - cost of revenue - sales & marketing expenses - other operating expenses - R&D expenses - interest expense - depreciation expenses. |
| Profit and Loss. EBT Margin % | This metric is computed as follows : (EBT / revenue) * 100. |
| Profit and Loss. Gross Margin % | This metric is computed as follows : (Gross profit / revenue) * 100. |
| Profit and Loss. Gross Profit | This metric is computed as follows : revenue - cost of revenue. |
| Profit and Loss. Income Tax Expense | Income tax expense metric is the activities for a period range for the INC TAX financial category. |
| Profit and Loss. Interest Expense | Activities for a period range for the INT EXP financial category. |
| Profit and Loss. Net Income | This metric is computed as follows : revenue + other income - cost of revenue - sales & marketing expenses - other operating expenses - R&D expenses - interest expense - income tax expense - depreciation expenses. |
| Profit and Loss. Net Income Margin % | This metric is computed as follows : (net income / revenue) * 100. |
| Profit and Loss. Operating Margin % | This metric is computed as follows : (operating profit / revenue) * 100. |
| Profit and Loss. Operating Profit | This metric is computed as follows : revenue - cost of revenue - total operating expenses. |
| Profit and Loss. Other Income | Activities for a period range for the OTHER INC financial category. |
| Profit and Loss. Other Operating Expenses | Activities for a period range for sum of financial categories with these values: EMP BENFT, GEN PAYROLL, EMP SUPP, CONT EXP, EMP OVERTIME, VARIANCE EXP, MISC OPER EXP and OTHER OPER EXP. |
| Profit and Loss. Payroll Cost | Activities for a period range for sum of financial categories with these values: MKTG PAYROLL, SLS PAYROLL, R&D PAYROLL, and GEN PAYROLL. |
| Profit and Loss. R&D Expenses | Activities for a period range for sum of financial categories with these values: OTHER R&D EXP and R&D PAYROLL. |
| Profit and Loss. Revenue | Activities for a period range for the REVENUE financial category. |
| Profit and Loss. Sales & Marketing Expenses | Activities for a period range for sum of financial categories with these values: MKTG PAYROLL, SLS PAYROLL, OTHER MKTG EXP, FREIGHT, OTHER SLS EXP, and TRAVEL & ENT EXP. |
| Profit and Loss. Total Operating Expenses | This metric is computed as follows : R&D expenses + sales & marketing expenses + other operating expenses. |
| Profit and Loss YTD. Cost of Revenue YTD | YTD activities for a period range for the COGS, PURCH, and RM CONS financial category. |
| Profit and Loss YTD. Depreciation Expenses YTD | Depreciation expenses metric is the YTD activities for a period range for the DEPCN financial category. |
| Profit and Loss YTD. EBITDA Margin YTD % | This metric is computed as follows : (EBITDA YTD / revenue YTD) * 100. |
| Profit and Loss YTD. EBITDA YTD | This metric is computed as follows : revenue YTD - cost of revenue YTD - sales & marketing expenses YTD - other operating expenses YTD - R&D expenses YTD. |
| Profit and Loss YTD. EBIT Margin YTD % | This metric is computed as follows : (EBIT YTD / revenue YTD )* 100. |
| Profit and Loss YTD. EBIT YTD | This metric is computed as follows: revenue YTD - cost of revenue YTD - sales & marketing expenses YTD - other operating expenses YTD - R&D expenses YTD - depreciation expenses YTD. |
| Profit and Loss YTD. EBT Margin YTD % | This metric is computed as follows : (EBT YTD / revenue YTD) * 100. |
| Profit and Loss YTD. EBT YTD | This metric is computed as follows : revenue YTD - cost of revenue YTD - sales & marketing expenses YTD - other operating expenses YTD - R&D expenses YTD - interest expense YTD - depreciation expenses YTD. |
| Profit and Loss YTD. Gross Margin YTD % | This metric is computed as follows : (Gross profit YTD / revenue YTD) * 100. |
| Profit and Loss YTD. Gross Profit YTD | This metric is computed as follows : revenue YTD - cost of revenue YTD. |
| Profit and Loss YTD. Income Tax Expense YTD | Income tax expense metric is the YTD activities for a period range for the INC TAX financial category. |
| Profit and Loss YTD. Interest Expense YTD | Interest expense metric is the YTD activities for a period range for the INT EXP financial category. |
| Profit and Loss YTD. Net Income Margin YTD % | This metric is computed as follows : (net income YTD / revenue YTD) * 100. |
| Profit and Loss YTD. Net Income YTD | This metric is computed as follows : revenue YTD + other income YTD - cost of revenue YTD - sales & marketing expenses YTD - other operating expenses YTD - R&D expenses YTD - interest expense YTD - income tax expense YTD. |
| Profit and Loss YTD. Operating Margin YTD % | This metric is computed as follows : (operating profit YTD / revenue YTD) * 100. |
| Profit and Loss YTD. Operating Profit YTD | This metric is computed as follows : revenue YTD - cost of revenue YTD - total operating expenses YTD. |
| Profit and Loss YTD. Other Income YTD | Other income metric is the YTD activities for a period range for the OTHER INC financial category. |
| Profit and Loss YTD. Other Operating Expenses YTD | Other operating expenses metric is the YTD activities for a period range for sum of financial categories with these values: EMP BENFT, GEN PAYROLL, EMP SUPP, CONT EXP, EMP OVERTIME, VARIANCE EXP, MISC OPER EXP and OTHER OPER EXP. |
| Profit and Loss YTD. Payroll Cost YTD | YTD Activities for a period range for sum of financial categories with these values: MKTG PAYROLL, SLS PAYROLL, R&D PAYROLL, and GEN PAYROLL. |
| Profit and Loss YTD. R&D Expenses YTD | This metric is computed as follows : R&D payroll expenses YTD + other R&D expenses YTD. |
| Profit and Loss YTD. Revenue YTD | YTD activities for a period range for the REVENUE financial category. |
| Profit and Loss YTD. Sales & Marketing Expenses YTD | This metric is computed as follows : marketing payroll expense YTD + other marketing expenses YTD + sales payroll expenses YTD + Freight expenses YTD + other sales expenses YTD + travel & Entertainment expenses YTD. |
| Profit and Loss YTD. Total Operating Expenses YTD | This metric is computed as follows : sales & marketing expense YTD + R&D expense YTD + other operating expense YTD. |
| Return on Investment. Current Assets | This metric is computed as follows : cash + inventories + prepaid expenses + other current assets + accounts receivable + deferred cost of goods sold. |
| Return on Investment. Current Liabilities | This metric is computed as follows : accrued liabilities + short term borrowing + other current liabilities + accounts payable + deferred revenue +tax liabilities. |
| Return on Investment. Retained Earnings | Shows the retained earnings balance for a particular time period for the RET EARNING financial category. |
| Return on Investment. ROA | This metric is computed as follows : (daily net income * 365 / total assets) * 100. |
| Return on Investment. ROA (Pre-Interest) | This metric is computed as follows : (((daily net income + daily interest expense) * 365) / total assets) * 100. |
| Return on Investment. ROCE (EBIT Basis) | This metric is computed as follows : (daily net income + daily interest expense + daily income tax expense) * 365 / (common stock + long term debt + retained earnings + preferred stock + other equity + other liabilities) * 100. |
| Return on Investment. ROCE (Pre-Interest) | This metric is computed as follows : (daily net income + daily interest expense) * 365 / (common stock + long term debt + retained earnings + preferred stock + other equity + other liabilities) * 100. |
| Return on Investment. ROE | This metric is computed as follows : daily net income * 365 / (common stock + retained earnings + other equity) * 100. |
| Return on Investment. ROE (Pre-Interest) | This metric is computed as follows : (((daily net income + interest expense ) * 365) / (common stock + retained earning + other equity)) * 100. Where: common stock = ending balance for the CMMN STOCK financial category. retained earning = ending balance for the RET EARNING financial category. other equity = ending balance for the OTHER EQUITY financial category. |
| Return on Investment. Total Assets | This metric is computed as follows : long term assets + current assets. |
| Return on Investment. Total Liabilities | This metric is computed as follows : current liabilities + long term liabilities. |
| Return on Investment. Total Shareholders Funds | This metric is computed as follows : preferred stock + common stock + retained earnings + other equity. |