To build custom KPI formulas in Calxa Premier, you will need to name and group accounts so you can use them in your formulas. Account groups are a named selection of accounts used to simplify the creation of KPI formulas. There are several default account groups provided for you in Calxa. You can use and edit these groups as well as create your own custom account groups.
Navigate to Reports -> KPIs -> KPI Account Groups.
Select your organisation from the Selected Organisation dropdown
To view the properties of an Account Group, select the group from the Account Groups list at left (1, shown below).
Each Account Group has the following properties:
Name: The name will be used to identify this Account Group in KPI formulas, this will need to be unique.
Account Group type: The group type determines how the value of a group will be calculated.
Period Movement - Calculated as the sum of the movement in each account in the group for the reported period.
Annual Movement - Calculated as the sum of the movement in each account for the 12 month period ending at the end of the reporting period.
Closing Balance - Total of the closing balances on all selected accounts, at the end of the reporting period.
Description: A description of the group of accounts. For custom KPIs you can type your own description in the box.
Account Selection: The selection of accounts included in the Account Group calculation.
Note: The default Account Groups' Name, Account Group type and Description cannot be edited.
The Account Selection can be edited for the following account groups: Fixed Costs, Wages, Current Assets, Current Liabilities, Default Bank, Inventory and Owner's Equity.
Edit Account Selection
This option is only available for your custom account groups and the Fixed Costs, Wages, Current Assets, Current Liabilities, Default Bank, Inventory and Owner's Equity Account Groups.
To edit the accounts included in an Account Group, select the group from the Account Groups list.
Select the account checkboxes of the accounts you wish to include in the Account Group. Deselect the account checkboxes of the accounts you wish to remove.
Click the Save Changes button when you are happy with your selection.
Note you can revert back to the Calxa default selection of accounts for the Fixed Costs, Wages, Current Assets, Current Liabilities, Default Bank, Inventory and Owner's Equity Account Groups at any time.
To do this, click the Bulk Actions drop-down and select Use defaults. Click Save Changes.
Create Custom Account Groups
There are several default Account Groups provided for you, however there may be times when the default groups don't quite fit your needs for a particular KPI formula you want to build. In these situations you can create your own custom Account Group.
Click the New account group button that sits above the list of Account Groups.
The Add New Account Group box will open. Select the calculation method from the Group type drop-down (i.e. Period movement, Closing balance, Annual movement).
Enter the name you'd like to use in the Group name field, then click Add New Group.
Note: Remember the Account Group type determines how the value of an Account Group will be calculated.
You can change a custom Account Group's type by selecting the group from the list of Account Groups at left, then choosing the type from the drop-down shown below, then clicking Save Changes.
You can enter a description of what your Account Group represents, if you like (this is optional). Click into the area below the group name to add your description, then click Save Changes.
To use one of your custom account trees to select the accounts in your account group, select the tree from the Account Tree drop-down, or, if preferred, use the Default Account Tree (your accounting system's chart of accounts).
Use the checkboxes to select/deselect the desired accounts for your new account group. Click Save Changes when done.
Note you can also search for account(s) using the Search bar (1 shown below).
There are Bulk Actions you can access (2 shown below), which work with the entire chart of accounts when you haven't used the search bar, or the accounts brought up from a search when you have used it.
Copy, Delete, and Search for Account Groups
Copy an Account Group
You might choose to copy an Account Group to give yourself a jump-start with creating a new group.
To copy a group, select the group from the Account Groups list, then click the Copy button.
The new group will be called Copy 'Original Group Name'.
Rename the new group by selecting it from the Accounts Group list, then clicking into the Name field and typing in a new name. Click Save Changes.
Delete an Account Group
You can delete custom Account Groups you have created, however you cannot delete any of Calxa's default Account Groups. Calxa default groups have a grey padlock next to the Copy button button indicating they can't be deleted.
To delete a group, select the group from the Account Groups list, then click the Delete button.
A confirmation box will pop up. Click Delete Account Group to confirm deletion, note that any existing KPIs using this group will now fail and this is NOT recoverable.
Search for Account Groups
There is an option to use the search bar to look for particular Account Groups, for users with lengthy group lists.
Click into the Search account groups bar at the top of the Account Groups list.
Type in the name, or part of the name, of the Account Group you are looking for (1 below). A list of possible matches will display below that. Click on the group you want to work with, and it will be opened to the right (2 below).