Variables references for CFO dashboards

CFO dashboards are variable-driven dashboards. These are the references where these variables are used for CFO Dashboards:

• FSM_ALL_KPI_SUMMARY_ACCT_CHART - assign the Chart of Account Structure to be used for CFO Dashboards

  Used in All CFO Dashboards KPIs and reports

• FSM_ALL_KPI_SUMMARY_ACCT_REVENUE - assign the revenue summary account from chart assigned in FSM_ALL_KPI_SUMMARY_ACCT_CHART variable

  Used in these KPIs:

  • Revenue
  • Revenue Target (Budget)
  • Revenue Per FTE
  • Gross Margin
  • EBIT Margin
  • Net Profit Margin Report: Revenue Trend
• FSM_ALL_KPI_SUMMARY_ACCT_NET_PROFIT - assign the Net profit summary account from chart assigned in FSM_ALL_KPI_SUMMARY_ACCT_CHART variable

  Used in these KPIs:

  • Net Profit
  • Net Profit Target (Budget)
  • EBIT
  • EBIT Target (Budget)
  • EBIT %
  • EBIT % Target (Budget)
  • Net Profit Margin
• FSM_ALL_KPI_SUMMARY_ACCT_TAXES - assign the Taxes summary account from chart assigned in FSM_ALL_KPI_SUMMARY_ACCT_CHART variable

  Used in these KPIs:

  • EBIT
  • EBIT Target(Budget)
  • EBIT %
  • EBIT % Target (Budget)
  • EBIT Margin
• FSM_ALL_KPI_SUMMARY_ACCT_INTEREST_EXP - assign the Interest Expense summary account from chart assigned in FSM_ALL_KPI_SUMMARY_ACCT_CHART variable

  Used in these KPIs:

  • EBIT
  • EBIT Target(Budget)
  • EBIT %
  • EBIT % Target (Budget)
  • EBIT Margin
• FSM_ALL_KPI_SUMMARY_ACCT_OPER_EXP - assign the Operating Expense summary account from chart assigned in FSM_ALL_KPI_SUMMARY_ACCT_CHART variable

  Used in these KPIs:

  • Operating Expenses
  • Operating Expenses Target (Budget)
  • Operating Ration Report: Operating Expenses Breakdown
• FSM_ALL_KPI_SUMMARY_ACCT_GROSS_PROFIT - assign the Gross Profit summary account from chart assigned in FSM_ALL_KPI_SUMMARY_ACCT_CHART variable

  Used in these KPIs:

  • Gross Profit
  • Gross Profit Target (Budget)
  • Profit Per FTE
  • EBIT Margin
• FSM_ALL_KPI_SUMMARY_ACCT_SALARIES - assign the Salaries summary account from chart assigned in FSM_ALL_KPI_SUMMARY_ACCT_CHART variable

  Used in the Salaries KPI

• FSM_ALL_KPI_SUMMARY_ACCT_HIRING_COSTS - assign the Hiring Cost summary account from chart assigned in FSM_ALL_KPI_SUMMARY_ACCT_CHART variable

  Used the Cost Per Hire KPI

• FSM_ALL_KPI_SUMMARY_ACCT_CURRENT_ASSETS - assign the Current Assets summary account from chart assigned in FSM_ALL_KPI_SUMMARY_ACCT_CHART variable

  Used in the Working Capital Ration KPI

• FSM_ALL_KPI_SUMMARY_ACCT_CURRENT_LIABILITIES - assign the Current Liabilities summary account from chart assigned in FSM_ALL_KPI_SUMMARY_ACCT_CHART variable

  Used in the Working Capital Ration KPI

• FSM_ALL_KPI_SUMMARY_ACCT_COGS - assign the Cost of Goods Sold summary account from chart assigned in FSM_ALL_KPI_SUMMARY_ACCT_CHART variable

  Used in these KPIs:

  • Gross Profit Margin
  • Operating Ratio