Questions? We have answers.

Ratios dashboard: Overview (GL)

  • Updated

Summary

The Ratios dashboard displays ratios that have been enabled by your App Admin. Ratios are grouped by categories and are defined by the library the engagement is using. You can create and edit new ratios from this dashboard.

Choose which ratios are shown on this dashboard in the Engagement settings.


Go to the Ratios tab

  1. Select the logo in the MindBridge sidebar
    You will go to the Organizations page.
  2. Select View in line with the desired organization, or click anywhere in the organization row. 
    You will go to the Engagements page.
  3. Select View in line with the desired engagement, or click anywhere in the engagement row. 
    You will go to the Data page.
  4. Select View Analysis in line with the desired analysis. 
    You will go to the Analyze page.
  5. Select the Ratios tab.

Tip: If you are already in an analysis, simply use the sidebar to open the Analyze menu, then select the name of the analysis you want to see and go to the Ratios tab.


Overview

Financial ratios can be used to summarize financial statements and the health of a company or enterprise. On the Ratios dashboard in MindBridge, you can:

  1. Search for ratios.
  2. Filter for ratios based on categories.
  3. View ratios as they relate to various periods of time.
  4. Create new ratios, export multiple ratios, and view and edit ratio settings.
  5. Collapse and expand ratio categories.
  6. View each ratio's name.
  7. View details about a specific ratio.
  8. Add annotations and comments to a specific ratio.
  9. Export, duplicate, or edit a specific ratio.
  10. Learn more about your clients with detailed graphs
  11. Toggle legend elements on and off, such as the time period or the expected range.

Ratio dashboard overview.png


Search

  1. Enter the ratio name in full or in part into the Search field.
  2. Press enter/return on your keyboard, or select the magnifying glass icon ( Search icon.svg ).
    The dashboard displays ratios that match your search criteria.


Filter ratios

Filtering ratios allows you to find relevant statistics quickly.

Tip: The filters you apply to this dashboard will persist when navigating to other tabs, including the Data table, Risk overview, and Audit assertion risk.

There are 3 ways to filter for ratios:

Filter by account

  1. Open the Account filter menu.
  2. Expand groups with the chevron icon ( Expand chevron.svg ) to the left of the checkbox. 
  3. Use the checkboxes to select:
    • An account group: When selecting an account between levels 1 to 4, all lower-level accounts will also be selected.
    • An individual account: These are the accounts at the most granular level (level 5).
  4. Expand groups with the chevron icon ( Expand chevron.svg ) to the left of the checkbox. 
  5. When you are satisfied, Apply your selection(s).
    MindBridge filters on all selected accounts.

Learn about the MindBridge Account Classification system.

Filter by analysis period

  1. Open the Analysis period filter menu.
  2. Use the checkboxes to select the analysis period(s) you want to see.
  3. When you are satisfied, Apply your selection(s).
    MindBridge filters on all selected analysis periods.
Note: This filter only appears when prior periods have been added to the analysis.

Filter by ratio

  1. Open the Ratio filter menu.
  2. Expand groups with the chevron icon ( Expand chevron.svg )to the left of the checkbox. 
  3. Use the checkboxes to select:
    • Ratio category: When selecting a ratio category, all ratios within the category will also be selected.
    • Individual ratio(s): Within each category, you can select one or several ratios to filter for.
  4. Apply your selection(s).
    MindBridge filters for your selected ratios.


View ratios on the dashboard

View by time period

Open the View menu near the top of the page and select whether you want to view ratios:

  • By month
  • By period
  • By quarter

The ratios on the dashboard will update based on your selection.

View by category

Select the expand icon ( Expand chevron.svg ) next to a category name to expand the section. You will see the category's ratios and corresponding graphs.

Show adjustments

If you have imported adjustments, reclassifications, or eliminations into your analysis, select the Adjustments toggle to view ratios with the adjusted values.


Use ratio graphs

Data points

Hover over data points on the graph to view additional details and gain more context.

Legend toggles

Ratio graphs use a distinct line for each time period included within the analysis. Select components in a graph's legend to toggle components on and off, such as a specific period of time, or the expected range.

Additional details

Select the info icon ( Information icon.svg ) to see the ratio formula that makes up the graph. 

Expected current period range

If the analysis contains 4 prior periods, you will see an expected range for each data point in the current period. This expected range is a prediction of current period values based on the trends present in prior periods. Points that fall outside of this expected range are highlighted in red.

Ratio graph useage example.gif


Create ratios

You can create a new ratio on the Ratios dashboard, from the engagement settings, or from the library settings.

  1. Open the Actions menu near the top of the page.
  2. Select Create ratio.
    A pop-up window will appear.
  3. Enter a Name for the ratio.
  4. Select a Category from the menu, or enter a new category with your keyboard.
  5. Enter Additional details in the text box.
  6. Add conditions (accounts, numerators and denominators) to your ratio as needed.
    Learn how to use the ratio builder.
  7. When you are satisfied, select Create Ratio.*
    The ratio you created adds a new graph on the Ratios dashboard, with the title you gave your ratio. 
*Note: Ratios will only be available for use in the engagement in which they were created. To apply a ratio across multiple engagements, select the Add Ratio to Library checkbox before creating the ratio.

Ratios dashboard - How to create a new ratio.gif


View ratio settings

There are 2 ways you can see each ratio's settings, which include:

  • The name of the ratio
  • Additional information to contextualize the ratio
  • The formula in use

From the information icon

Select the info icon ( Information icon.svg ) beside the ratio's name to see read-only details about the ratio.

From the Engagement settings page

  1. Open the Actions menu near the top of the page.
  2. Select Ratio settings.
    You will go to the Ratios tab in the Engagement settings.
  3. Select the expand icon ( Expand chevron.svg ) to reveal read-only details about the ratio.


Edit ratio settings

There are a few ways to edit each ratio's settings.

Note: Ratios will only be available for use in the engagement in which they were created. To apply a ratio across multiple engagements, select the Add Ratio to Library checkbox before finalizing your changes.

From the Ratio dashboard

  1. Open the more actions menu ( More actions menu icon.svg ) in line with the ratio you want to edit.
  2. Select Edit.
    A pop-up window appears.
  3. Adjust the ratio name, category, additional details, and conditions as needed.
  4. When you are satisfied, Save your changes.
    Ratio changes will appear within the engagement.

From the Engagement settings page

Note: When a library-level ratio is edited, MindBridge creates a duplicate of the ratio that can be manipulated as needed. This new ratio can then be added to the library for future use.
  1. Open the Actions menu at the top of the page.
  2. Select Ratio settings.
    You will go to the Ratios tab in the Engagement settings.
  3. Select the edit icon ( Edit icon.svg) in line with the ratio you want to edit.
    A pop-up window appears.
  4. Adjust the ratio name, category, additional details, and conditions as needed.
  5. When you are satisfied, select Update (or Create Ratio) to save your changes.
    Ratio changes will appear within the engagement.

From the Admin section

Note: You must be an App Admin to access ratios at the library-level, as these ratios appear in any engagement using that library.
  1. Open the MindBridge sidebar and select the Admin icon ( Admin icon.svg ).
    You will go to the Admin page.
  2. Select the Libraries tab.
  3. Open the Actions menu in line with the library you want to enter.
  4. Select View library.
    You will go to the Library details tab.
  5. Select the General ledger tab.
  6. Select Ratios from the menu on the left of the page.
  7. Select the edit icon ( Edit icon.svg ) in line with the ratio you want to edit.
  8. Adjust the filter name, category, additional details, or conditions as needed.
  9. When you are satisfied, select Update to save your changes.
    Ratio changes will appear across any engagement using that library.
Note: Annotations made to this ratio prior to editing will be archived.

Duplicate ratios

Duplicate a ratio to manipulate it without impacting the original ratio. 

  1. Open the more actions menu ( More actions menu icon.svg ) in line with the ratio you want to duplicate.
  2. Select Duplicate.
    A copy of the ratio will appear on the Ratio dashboard.

Promote a ratio to a library

Note: You must be an App Admin to perform this action.

Ratios are available for use in the engagement in which they were created. Promoting a ratio to a library allows to you leverage that ratio across multiple engagements.

  1. When creating or editing a ratio, select the Add Ratio to Library checkbox.
  2. Once you are satisfied, select Update to save your changes.


Export ratios

There are a few ways to export ratios on this dashboard. The export is an .XLSX file containing 2 sheets:

  • The ratio(s) displayed in graph format
  • The data that makes up the graph(s)

Export a single ratio

  1. Open the more actions menu ( More actions menu icon.svg ) in line with the ratio you want to edit.
  2. Select Export.

Export multiple ratios

  1. Open the Actions menu near the top of the page.
  2. Select Export.
    A pop-up window appears.

  3. To select all available ratios, use Select all.
  4. To choose ratios to export, open the menu and use the checkboxes to select:
    • Ratio category: When selecting a ratio category, all ratios within the category will also be selected.
    • Individual ratio(s): Within each category, you can select one or several ratios to export.
  5. Select Export to export the ratios you chose.


Delete ratios

  1. Open the more actions menu ( More actions menu icon.svg ) in line with the ratio you want to delete.
  2. Select Delete.
    A confirmation window appears.
  3. Select Delete to permanently delete the ratio.
Note: Engagement ratios can be deleted, but library ratios can only be deleted by an App Admin.

Anything else on your mind? Chat with us or submit a request for further assistance.


Was this article helpful?