Grouping and Sorting
When reporting on the activities of a business you may wish to see high level summary reports with further detail level reports depending upon your requirement. Accordingly it's often useful to collapse a number of accounts into one group level and sort these depending upon need.
Although the various accounting products have header and sub-accounts or may have account levels you often need to decide on the level of granularity at the time the chart of accounts is defined.
Bi4Cloud we provide functionality to read existing report account levels and then allow you
- Define you own Report Levels
- Group accounts and levels into these Report Levels
- Determine and control the sorting position on the Report
with all of these feature implemented with a drag and drop user interface.
This allows the definition of up to 4 levels and arrangement of accounts and sub-levels with a completely flexible mix and match of groups and levels. Way cool stuff
This grouping and sorting feature is available from menu option GL Group and Sort from Cool Stuff button on the admin page.
The first time this is run the existing chart of accounts is read and analysed for any account levels and hierarchy that already exists. As a default the program will put accounts into groups based upon assets type
- 1 Assets
- 2 Liabilities
- 3 Equity
- 4 Income
- 5 Cost of Sales
- 6 Expenses
- 8 Other income
- 9 Other Expense
and it will display something like this depending upon your accounting software. More Details
Clicking on an arrow expands the level
Right clicking on a group displays an Option Box to allow you to create a Group at either a Top Level or a Child of the current item
The newly added group will appear at the end of the list and in our example we added a group General Expenses
The newly created group element can be moved to either change the sort position it appears in, or drop it into another group. You can select the element by left click of your mouse and drag the element. The highlighted box that follows the mouse pointer will show an icon graphic of a plus sign or an insertion icon to indicate the proposed action if you release the mouse button.
The following screen shows the icon graphic plus sign that adds the element to the group.
To see more details about any displayed Group or Account you can left click on the item and a blue dialog displays name, source and level information. The sample below shows information about an account.
and this screen show the message for a User Defined group.
The following screens show how to create a Child Group Travel under 6 - Expenses and then dragging Travel - International and Travel - National accounts into it.
First create the Child Group Travel by selecting Add Child Group
The child group Travel is created as a Level 2 Group
and the two Travel accounts are then dragged, one at a time, into the Travel group
WARNING - Currently this group and sort feature is a Beta release so to minimise your frustration PLEASE press Save button after every few actions to save your work
What does this look like in reports ?
Below is the output of the Bi4 Profit and Loss report with the Analyse By dimension set to GL Report Level 1 and highlighted in orange is the new General Expense group that was defined as Level 1.
In our second example we change the Analyse By to GL Report Level 2 and this shows the combined Travel group in orange that was defined as a Level 2 group with other Level 2 Accounts / Groups.
The above examples have been kept simple for clarity to show the created groups however any of the defined Report Levels can participate in reports as analyse dimension of any of 3 sub-total dimension.
As with all Bi4Cloud reports these can be saved as favourites for later recall, shared with other users or automatically emailed at user defined period providing more automation, better consistency and repeatability that spreadsheet methods.