Trees

Note

To view the legacy version, please select Legacy User Guide.

How to view Trees

Viewing Trees

As per Generic Navigation options, either from left-hand navigation panel, expand Settings and select Trees from the GL folder or enter Trees in the Search option.

This will then show the Trees on the system where normal customisation of Sets can be used.

Tip

To modify the columns displayed, select option on the right of the column display, then tick/untick the information you want to hide or display.

  • Only users with access to the ‘COA Tree Admin’ User role will be able to add or edit the trees.

  • A ‘Tree’ overlays an enquiry. In the case of Chart of Accounts this is the Trial Balance, Profit & Loss or Balance Sheet. iplicit has an ‘author based’ Standard for each of these based on the Chart of Accounts Group & Account codes.

  • As an alternative to the Standard enquiries additional tree layouts can be created providing the means to see the accounts in various displays.

Creating a New Account Tree

Note

There are technical settings required to create an accounts tree from scratch, therefore, to simplify this for the end user the approach used should be to copy an existing Standard tree where the technical settings are completed. The display can be amended without the need to understand the technical aspect. This is the approach taken for this help file.

  1. Highlight an existing Author based Standard tree that is the nearest in design to the requirements. From the options, select Copy.

  2. The option to Copy the Tree either As query (this should only be selected by a MS Sequel programmer) or As user defined tree.

    Select As user defined.

  3. Enter a new Description for the tree.

  4. The Tree tab displays two panels, the left-hand side shows the structure of the tree, by default the right-hand side lists any Chart of Accounts not included on the tree.

    Tip

    Toggle between Show all/Hide used to alter the display of the right hand panel.

    Any highlighted Chart of Account can be Removed if not required.

    Note

    If you Remove a Group the codes below it will also be removed.

    To bring codes into the tree from the right hand panel, drag them across to the heading the code will be included in.

  5. Lines can simply be dragged around for display purposes either within the same group or to another group. The hierarchy positions are an important factor when moving lines, drag the line being moved to the correct hierarchy position before releasing it.

    Tip

    Sometimes it can be quicker to remove the code then add it back into the correct position.

  6. For display purposes lines or spaces can be entered above the currently highlighted row.

  7. Groups can be created to provide additional display & sub-totals to those on the Standard Chart of Accounts.

    Note

    Groups automatically are sub-totalled. However, this will be an optional feature on later versions. Once operational, where required with the Group highlighted the Sub-totals icon works as a Toggle to Add/Remove the sub-totals for the Group.

    Tip

    The + symbol is also a means of adding a Group but with the position at the lower level, therefore it is not as efficient as using the Group icon.

  8. Reverse sign.

  9. Once the design is complete select Create.

Using the Tree

  1. Select one of the standard Balance Sheet, Profit & Loss or Trial Balance enquiries from the finders or search option.

  2. By default this will open with the Standard layout.

  3. Select the option on the right-hand side displays the options available for the enquiry.

    Note

    If the My settings is set to Remember user layout changes the next time you run the enquiry it will display using the last tree selected.


Updated September 2026