When you build a report, you can single out any specific account, category, or any custom account groups into a chart or table.
You can make your selection from either options Choose Data or Create Formula.
After you choose your data, you can also exclude children groups or accounts.
Choose data
From the Builder option > Choose data - the chart of account structure will display.
Click Collapse all to show all the different levels:
You can select:
One or more Categories (Income / Expenses) - in green
One or more Groups (Office costs) - in blue
One or more single Accounts (Rent) - in white
When choosing a parent category, all the children groups, accounts and predictions under will automatically display in the report.
Make sure to select the highest level you want to report on, you can exclude the children accounts later.
How to Exclude groups or accounts:
After you choose your data and save, your selection will appear in the builder section.
Under each data item, click to expand the view and show the "Data includes" option.
By default all children accounts and items are selected.
You can target further your selection and exclude all children groups, accounts or predictions under:
This means you can display:
Categories only - without the groups or children accounts
Categories and groups - without the children accounts
Categories and accounts - without the groups
Groups only - without categories or accounts
Accounts only
etc.
This will show all the items within each category or group.
How to target specific accounts:
To select specific items and exclude others within the same category or group, you need to unselect the higher category and only select the targeted groups or accounts under when choosing your data.
In this example above, we unticked the overall Expenses category, and selected only two of the groups - Payroll and Office costs, but not the General costs.
From the builder section, we can then select to show the groups only and exclude the children accounts and predictions:
We can also customise the display for each added group: In this example, we included the accounts for both, and added the predictions for the Office costs only but not Payroll.
Create Formula
When you create a formula in a report, you can customise as you wish and target any Category, Group, Account or driver among all options. The formula can then be tweaked to exclude anything from the selection.
