Help Center

How to create a second level of subgroup in ScaleXP reporting ("subgroup level 2")

Subgroup level 2 adds a fourth tier to your P&L and balance sheet reporting, below categories, groups and first-level subgroups, and you set it up in Load Data > Configure P&L, BS.


1. Set up subgroup level 2

For an overview of setting up groups and subgroups, see How to configure your P&L and Balance Sheet in ScaleXP (single company)  or How to configure your P&L and Balance Sheet in ScaleXP (consolidated company). 

  1. Go to Load Data, Configure P&L, BS.
  2. Select the accounts for the Subgroup Level 2.
  3. Move the accounts into the desired Financial Category, Group, and Subgroup.
  4. Click Create Sub Group at the top.
Configure P&L, BS with three accounts inside a group selected and Create Sub Group highlighted
  1. Give the Subgroup Level 2 a name and click Save.
Sub group name field with Cancel and Save highlighted

You will have created a fourth level of reporting financial accounts.

Note: In Move to, the group level can be seen by the number of dashes before the name in the configuration chart. Subgroup Level 2 has three dashes ("---").

Move to menu with the three-dash subgroup level 2 entries Rent, Rates, Software and Cleaning circled

2. Report on subgroup level 2

  1. Once you are happy with these, go to the Reports tab and select the report in which you are looking to have subgroups showing.
  2. Select Edit and then Edit rows.
Report Edit menu with the Edit button and Edit rows highlighted

Then use either option below.

Option 1: Use Show Subgroups Level 2 to automatically display subgroups within a report

  1. Click on the row to reveal the menu for Collapse level.
  2. Select Show Subgroups or Show Subgroups Level 2.
  3. Save the report.
Row expansion dropdown with Collapse, Show Groups, Show Subgroups, Show Subgroups Level 2 and Show Accounts

Option 2: Add each subgroup level 2 into the report as a separate row

  1. Select Click to Start and type in the subgroup name.
Bottom of the report editor with the Click to Start box
  1. Select it.
  2. Ensure you click Done to add the row.
Click to Start search for Commission with a Financial Subgroup result ticked and Done highlighted

Note: You will know you have selected a subgroup as it will say Financial Subgroup above your selection.