Balance Sheet Analysis dashboard
To access the Balance Sheet Analysis dashboard, go to the dashboards homepage. Select the folder icon or the .
This dashboard is based on Global Ledger subject areas.
These are the dashboard filters:
- Calendar
- Finance Enterprise Group
- Fiscal Month
- Fiscal Year
- HR Organization for Finance Enterprise Group
These are the KPIs on the dashboard:
- Return On Assets
- Working Capital Ratio
- Return On Equity
- Debt to Equity Ratio
The dashboard contains these reports:
| Report name | Description | Chart style |
|---|---|---|
| Return on Asset Trend | Shows the return on asset value for calendar period level 03 for rolling 12 months based on selected year and period on the dashboard | Column |
| Working Capital Ratio Trend: | Shows the working capital ratio for calendar period level 03 for rolling 12 months based on selected year and period on the dashboard | Line |
| Return on Equity | Shows the return on equity for calendar period level 3 for rolling 12 months based on selected year and period on the dashboard | Column |
| Debt to Equity Trend | Shows the debt to equity ratio for calendar period level 03 for rolling 12 months based on selected year and period on the dashboard | Area |
| Balance Sheet |
Shows the YTD Actual Functional amount for the balance sheet account levels. The account levels are taken from the chart defined in the FSM_ALL_KPI_SUMMARY_ACCT_CHART variable |
Designer |
Return on Asset Trend report
To access the Return on Asset Trend report, go to Visualizer. Select .
These are the report elements and their sources or expressions:
- Return On Asset - shows the Return on asset
value based on FEG, Calendar, fiscal year, fiscal month and other filters selected on the
dashboard.
The Asset and Income Statement Accounts taken for calculating this value is taken from chart structure defined in FSM_ALL_KPI_SUMMARY_ACCT_CHART.
The formula for Calculating Return on Asset is [YTD Actual Functional Amount for Income Statement Accounts for Year and Fiscal Month(value selected in dashboard filters) + YTD Actual Functional Amount for Previous Year where Fiscal Month is Greater than Equals to the value selected in Fiscal Month Dashboard Filter] / [(YTD Actual Functional Amount for Asset Type of Accounts for Year and Fiscal Month selected in dashboard + Actual Functional Amount for Previous Year, Fiscal Month(from the dashboard)/2].
Example:Year = 2021 Fiscal Month = 06 is selected in dashboard.
The formula is [Actual Functional Amount for Income Statement Accounts for Year = 2021 and Fiscal Month <= 06 + Actual Functional Amount for Previous Year 2020, Fiscal Month > 06 i.e 07,08,09,10,11,12] / [YTD Actual Functional Amount for Asset Type of Accounts for 2021, Fiscal Month <=06 + Actual Functional Amount for Year = 2020, Fiscal Month <= 06)/2].
- Calendar Period Level 03 - shows the Calendar Period Level 03 value
- Month Sequence Range - filters the Fiscal Months Sequence for 12 Rolling Periods based on the Year, Year/Month filter options selected in dashboard
Working Capital Ratio Trend report
To access the Working Capital Ratio Trend report, go to Visualizer. Select .
These are the report elements and their sources or expressions:
- Working Capital Ratio - shows the Working
Capital Ratio value based on FEG, Calendar, fiscal year, fiscal month and other filters
selected on the dashboard.
Summary Current Assets Account must be defined in the FSM_ALL_KPI_SUMMARY_ACCT_CURRENT_ASSETS variable and Summary Current Liabilities Account must be defined in the FSM_ALL_KPI_SUMMARY_ACCT_CURRENT_LIABILITIES variable.
Both of these summary accounts must be from the Chart Structure defined in the FSM_ALL_KPI_SUMMARY_ACCT_CHART variable.
The formula is [YTD Actual Functional amount of Summary Current Assets Account ] / [ (Actual Functional amount of Summary Current Liabilities].
- Calendar Period Level 03 - shows the Calendar Period Level 03 value for the calendar selected on the dashboard
- Month Sequence Range - filters the Fiscal Months Sequence for 12 Rolling Periods based on the Year, Year/Month filter options selected on the dashboard
Return On Equity report
To access the Return On Equity report, go to Visualizer. Select .
These are the report elements and their sources or expressions:
- Return On Equity - shows the Return on Equity
value based on FEG, Calendar, fiscal year, fiscal month and other filters selected on the
dashboard.
The Equity & Income Statement Accounts taken for calculating this value is taken from chart structure defined in FSM_ALL_KPI_SUMMARY_ACCT_CHART.
The formula for Calculating Return on Asset is [YTD Actual Functional Amount for Income Statement Accounts for Year and Fiscal Month(value selected in dashboard filters) + YTD Actual Functional Amount for Previous Year where Fiscal Month is Greater than Equals to the value selected in Fiscal Month Dashboard Filter] / [(YTD Actual Functional Amount for Equity Type of Accounts for Year & Fiscal Month selected in dashboard + Actual Functional Amount for Previous Year, Fiscal Month(from the dashboard)].
Example:Year = 2021 Fiscal Month = 06 is selected in dashboard.
The formula is [Actual Functional Amount for Income Statement Accounts for Year = 2021 and Fiscal Month <= 06 + Actual Functional Amount for Previous Year 2020, Fiscal Month > 06 i.e 07,08,09,10,11,12] / [YTD Actual Functional Amount for Equity Type of Accounts for 2021, Fiscal Month <=06 + Actual Functional Amount for Year = 2020, Fiscal Month <= 06)/2].
- Calendar Period Level 03 - shows the Calendar period level 03 value
- Month Sequence Range - filters the Fiscal Months Sequence for 12 Rolling Periods based on the Year, Year/Month filter options selected in dashboard
Debt to Equity Trend report
To access the Debt to Equity Trend report, go to Visualizer. Select .
These are the report elements and their sources or expressions:
- Debt to Equity - shows the Debit to Equity
value based on FEG, Calendar, fiscal year, fiscal month and other filters selected on the
dashboard.
The Equity & Liabilities Accounts taken for calculating this value will be taken from chart structure defined FSM_ALL_KPI_SUMMARY_ACCT_CHART.
The formula is [YTD Actual Functional amount of Summary Liabilities Type of Accounts ] / [ (Actual Functional amount of Equity Type of Accounts].
- Calendar Period Level 03 - shows the Calendar period level 03 value
- Month Sequence Range - filters the Fiscal Months Sequence for 12 Rolling Periods based on the Year, Year/Month filter options selected in dashboard
Balance Sheet report
To access the Balance Sheet report, go to Designer. Select .
These are the report elements and their sources or expressions:
- Account Level 02 Description - shows the Account Level 02 Description
- Account Level 03 Description - shows the Account Level 03 Description
- Account Level 04 Description - shows the Account Level 04 Description
- Level 02 Total - shows YTD Actual Functional Amount
- Level 03 Total - shows YTD Actual Functional Amount
- Level 04 Total_1 - shows YTD Actual Functional Amount
- Report Filter - filters the Report to show data only for Balance Sheet Chart Section Accounts. Balance Sheet Accounts is filtered only for the chart structure assigned in FSM_ALL_KPI_SUMMARY_ACCT_CHART variable
KPI expressions
- ROA - shows the Return on asset value based
on FEG, Calendar, fiscal year, fiscal month and other filters selected on the dashboard.
The Asset & Income Statement Accounts taken for calculating this value is taken from chart structure defined in FSM_ALL_KPI_SUMMARY_ACCT_CHART.
The formula for Calculating Return on Asset is [YTD Actual Functional Amount for Income Statement Accounts for Year and Fiscal Month(value selected in dashboard filters) + YTD Actual Functional Amount for Previous Year where Fiscal Month is Greater than Equals to the value selected in Fiscal Month Dashboard Filter] / [(YTD Actual Functional Amount for Asset Type of Accounts for Year & Fiscal Month selected in dashboard + Actual Functional Amount for Previous Year, Fiscal Month(from the dashboard)/2].
Example:Year = 2021 Fiscal Month = 06 is selected in dashboard.
The formula is:[Actual Functional Amount for Income Statement Accounts for Year = 2021 and Fiscal Month <= 06 + Actual Functional Amount for Previous Year 2020, Fiscal Month > 06 i.e 07,08,09,10,11,12] / [YTD Actual Functional Amount for Asset Type of Accounts for 2021, Fiscal Month <=06 + Actual Functional Amount for Year = 2020, Fiscal Month <= 06)/2].
- Working Capital Ration - shows the Working
Capital Ratio value based on FEG, Calendar, fiscal year, fiscal month and other filters
selected on the dashboard.
Summary Current Assets Account must be defined in the FSM_ALL_KPI_SUMMARY_ACCT_CURRENT_ASSETS variable and Summary Current Liabilitys Account must be defined in the FSM_ALL_KPI_SUMMARY_ACCT_CURRENT_LIABILITIES variable.
Both of these summary accounts must be from the Chart Structure defined in the FSM_ALL_KPI_SUMMARY_ACCT_CHART variable.
The formula is [YTD Actual Functional amount of Summary Current Assets Account ] / [ (Actual Functional amount of Summary Current Liabilities].
- Return on Equity - shows the Return on Equity
value based on FEG, Calendar, fiscal year, fiscal month and other filters selected on the
dashboard.
The Equity & Income Statement Accounts taken for calculating this value is taken from chart structure defined in FSM_ALL_KPI_SUMMARY_ACCT_CHART.
The formula for Calculating Return on Asset is [YTD Actual Functional Amount for Income Statement Accounts for Year and Fiscal Month(value selected in dashboard filters) + YTD Actual Functional Amount for Previous Year where Fiscal Month is Greater than Equals to the value selected in Fiscal Month Dashboard Filter] / [(YTD Actual Functional Amount for Equity Type of Accounts for Year & Fiscal Month selected in dashboard + Actual Functional Amount for Previous Year, Fiscal Month(from the dashboard)].
Example:Year = 2021 Fiscal Month = 06 is selected in dashboard.
The formula is [Actual Functional Amount for Income Statement Accounts for Year = 2021 and Fiscal Month <= 06 + Actual Functional Amount for Previous Year 2020, Fiscal Month > 06 i.e 07,08,09,10,11,12] / [YTD Actual Functional Amount for Equity Type of Accounts for 2021, Fiscal Month <=06 + Actual Functional Amount for Year = 2020, Fiscal Month <= 06)/2].
- Debt to Equity Ratio - shows the Debit to
Equity value based on FEG, Calendar, fiscal year, fiscal month and other filters selected
on the dashboard.
The Equity & Liabilities Accounts taken for calculating this value is taken from chart structure defined in FSM_ALL_KPI_SUMMARY_ACCT_CHART. The formula is [YTD Actual Functional amount of Summary Liabilities Type of Accounts ] / [ (Actual Functional amount of Equity Type of Accounts].