Including custom account groups within a Report (Card)

Written by Matthew Cawthra

About

FUTRLI allows you to create Custom Groups within an Account Group, making it easy to keep all Account Lines in order. This can be particularly helpful when creating Cards, meaning you do not have to search for multiple Account Lines you wish to show on the Card. In the following guide, we will run through the process of creating a Custom Group and then referencing it on the Card.

Locating the Chart of Accounts

To create a Custom Group, navigate to the Organisation section of FUTRLI, then click Settings adjacent to the Organisation in question:

Screen Shot 2017-02-08 at 17.35.39

Creating a Custom Group

Once in the Organisation’s Chart of Accounts, the five main Account Groups are shown, with individual Accounts listed below:

Screen Shot 2017-02-08 at 17.40.45

Adjacent to the Account Group in which the Custom Group will be built, click Create Group then name the group accordingly:

Screen Shot 2017-02-09 at 10.35.42

Once the Custom Group has been created, you will need to select the Accounts that will appear in it. To do this, click Re-order accounts to place the Chart of Accounts into editing mode:

Screen Shot 2017-02-09 at 10.38.56

Once in editing mode, you are able to click and drag the required Accounts into the Custom Group:

Screen Shot 2017-02-09 at 10.46.06

Once happy, click Save new order:

Screen Shot 2017-02-09 at 10.43.05

Reference the Group within the Formula Builder

Once your Custom Group is complete and saved, it is ready to be referenced in a Card. Select a Card, then click Report. To reference the Custom Group, you will need to use the Formula Builder. To access the Formula Builder, first click Add Formula:

Screen Shot 2017-02-09 at 11.21.05

In the top right of the resulting window, click Formula Builder:

Screen Shot 2017-02-09 at 11.22.23

Once in the Formula Builder, you need to name the Formula accordingly and then use the search box to search for the newly created Custom Group. Once you have found and added the Custom Group, you are able to select the format the data is shown as (Currency, Percentage or Margin) as well as the number of decimal places it will be shown in:

Screen Shot 2017-02-09 at 11.24.39

By default, the Card will automatically have Income selected. If you only wished to show the Custom Group, simply delete Income by clicking on the cross adjacent. Once happy, click Done in the top right of the box and your Card will be ready to view.