What are divisions?
Divisions are a way of separating reporting for different divisions within an entity's file. This can be done on any basis required, for example different business locations, different entities in a consolidation or even different salesperson reporting. The benefit of divisions is flexibility.
A simple division example report layout is as follows:
This style of report is generated automatically when creating the report by allocating an account to a division. There are three steps in this process:
- Creating a division (see below)
- Allocating an account to a division classification (see below)
- Producing a report with divisional report settings (see the knowledge article: Reporting - Creating a Report).
You can also use Trading Accounts in a similar way, for a comparison between the two, refer to the table below:
|Filter Report Columns
|Seperate Profit and Loss Pages
1. Creating a division
To create a new division, navigate to the Divisions section from the File Settings menu from any screen within the client file.
You will be directed to a screen where all available divisions are listed. To create a new division, select +New Division.
You will need to give the division both a Code and a Name. You can then select the Profit and Loss Location. There are three options; Income, Other Income or None. This will determine where the summary will appear on the Profit and Loss. You can also choose to select an alternative Page Title for the division report. By default if the field is left blank the Page Title will just be the name of the division.
If you have tracking categories already set up in the client accounting file you can choose to link these to this file. This has the added benefit of not having to manually select the accounts to allocate to the tracking category. Clicking on the Link to Source Division button will bring up the option to select the relevant source and associated divisions available for that source. Once selected click the Add button to link the division. Multiple divisions can be chosen from multiple sources.
Once completed click the Add Division button to create the division. You will now see it appear in the list.
2. Allocating an account to a division
If you have chosen to link to a source division as described above, you are only required to select any additional accounts you wish to report within that division.
To allocate an account to a division, navigate to the Accounts screen and edit an account by selecting the edit icon to the right of the relevant account.
On the account edit screen, select the required division from the drop-down list.
Note: There are two options, you can either select the default behaviour of the whole Active Ledger account or select the behaviour of a single source account. This is useful for sub-accounts or linked accounts that may have different properties.
Note: An account can be added to both a division and a trading account (for more information on trading accounts, see the knowledge article: Accounts - Trading Accounts). This allows you the most flexibility when reporting.
After editing the account select the Save Account button. The account has now been allocated to that division for the purpose of reporting.
Divisional and trading account view
To allocate multiple accounts to divisions quickly you can use the 'Divisional and Trading Accounts' view in the Accounts screen. From here you can select the relevant division from the dropdown menu.
In this view you can also allocate underlying source accounts to divisions easily by ticking the Show Source Accounts checkbox. This allows you to select different divisions for different source accounts within the one Active Ledger & Reporting (formerly Reportance) account.
Note: Any new source account that is linked to an account with an exisiting default division, will be automatically allocated to that default division. To override this, simply edit the new account.
TIP: A single journal entry can also be allocated to a division without allocating the whole account. This is particularly useful for allocating specific amounts to a division without creating duplicate accounts.
Next article: Accounts - Trading Accounts