Key Performance Indicators (KPIs) are a performance measurement tool commonly used to evaluate the success of your organisation or business units' goals and targets.
With Calxa Premier you can create custom KPI formulas and edit the KPI number format for default KPIs. Steps for running KPI reports and charts are outlined in the KPI Reporting help note.
Add a New KPI
Navigate to Reports -> KPIs -> KPI Builder.
Click Add new KPI.
Enter KPI name, Target Type and click ADD NEW KPI.
Tip: 💡Target type is used to calculate variances as unfavourable or negative.
Edit KPI Formula
A KPI Formula contains the following components and operators.
Account Groups: a named selection of accounts from your accounting data.
Metrics: additional values entered directly in Calxa.
Constants: True, False & Null can be used for conditional calculations.
Functions: conditional and mathematical formulas.
KPIs: use other KPIs as part of this KPI calculation.
Operators: mathematical operators to build your formula.
To build your formula start typing in the Formula definition area and use the auto-complete suggestion to insert the Account Groups, Metrics or Other KPIs.
You can optionally also use the COMPONENTS and/or OPERATORS menus to search and insert build your formula.
When your formula is complete click SAVE CHANGES.
Format KPI Numbers
Set formatting properties and click SAVE CHANGES
KPI type: display results as a currency, decimal or percentage.
Decimal places: choose how many decimal places to display.
Display format: choose a format for negatives and thousand separators.
Target type: defines how unfavourable or negative variances to budget will be calculated.
Categorise and Order KPIs
The order in which you see KPIs in this menu is also the order in which they will be displayed. Categorising KPIs helps to group them in a logical containers that can be sorted at a high level and then you can apply a custom sort order within each category.
Add New Category
Click Add new Category.
Enter Category name, Position and click ADD NEW CATEGORY.
Change the Category in the KPI properties.
Click settings cog next to one of the category names and select Reorder.
Use drag and drop to reorder the categories.
Click SAVE ORDER.
Use drag and drop to reorder KPIs within categories.