Key Performance Indicators are crucial to efficiently monitor your business and achieve results faster. They enable you to understand the health of your business, to make the right critical decisions and to achieve your strategic goals.
With Agicap, you can easily create them by navigating from the cashflow plan to the KPI advanced settings in one click. ✨
✅ Create a key performance indicator
Go to the KPI's section at the bottom of your Cashflow plan.
Click on the wheel ⚙ next to the section title Key performance indicators to directly access to the KPI's settings.
Click on the + button next to Custom key performance indicators to create a new one.
Give a name to your new KPI
Select the values option: let Based on a formula or change to Manual input.
Click on Confirm to finalize your KPI's creation
💡 To better track and visualise your KPIs in the cashflow plan, you can easily group them !
🔹 Case n°1 : Manual KPI
It allows you to add manually the data you want into Agicap. You can:
Use it for forecast calculations or KPIs based on formula.
Include it in custom dashboards,
It can be expressed in currencies or any else.
🧐 Examples of manual KPI:
number of customers, number of employees,
unit costs of a product, commission rate for services,
average shopping basket...
Once you have created the KPI as explained above,
7. Go back to the KPI's section in the cashflow plan, where you will find your new indicator.
8. Fill out the value directly by double-clicking on the cells and clicking on Enter. 👍
💡 Manual KPI can have up to 5 decimals (including in import).
🔹 Case n°2 : Key indicator generated by formula
It allows you to set custom indicators adapted to your business stakes. It will help you monitor your business at a glance to take decisions accordingly, without having to export your data to a spreadsheet and create formulas there.
🧐 Examples of KPI generated by a formula:
proportion of salaries or raw materials in the global turnover,
part of a specific client in the overall sales, gross margin rate...
Detailed example :
How to calculate the proportion of your raw materials rate
in your sales for each month?
6. Define which Categories (parent or daughter) or Key indicators you need for your calculation
Example :
You need the category "Raw materials" in outflow category
and the category "Sales" in inflow.
7. Combine it with a key word : the most common one is Value()
8. Define the period you need to set up for the values you have chosen just before.
💡 The period depends on your forecast frequency: so it can represent days, weeks, months.
The current period is defined as 0.
The previous period is -1.
The next period is +1.
Example :
When you are in the current month (period 0),
you sell the raw materials purchased during that month,
but pay them to your suppliers the following month (period 1).
So, to make your key indicator, you should
- take the amount of raw materials in period 1,
- divided by the sales in period 0.
Example : So the formula will be: value(rawmaterial,1)/value(sales,0)x100
Once your formula is created and validated:
9. Go back to the Cashflow Plan
10. Click on 🔄 Refresh computation on the top right, each time you create or modify an indicator generated by formula to actualize the results!
💡 Formula-based indicators are identified thanks to a dedicated icon Fx. If you want to modify your formula-based KPI, you just need to click on the KPI name! 🚀
✅ To go further into formulas...
If you want more information concerning the formula creation, you can refer to this article: Create a calculation formula.
💡 Good to know: Be aware that the formulas you create, will be automatically applied to all your scenarios.
💡💡 Good to know:
If you want to use decimals in your formulas, use a dot "." instead of commas ","
If you want to refer to the KPI inside its own formula, you need to first create the KPI and then edit its formula to insert this KPI.
💡💡💡 Very good to know: By default, Agicap has created three key indicators : cumulative transactions, ignored transactions and net change in cashflow.
If they are not relevant to you, you can hide them:
Go to the KPI's advanced settings
Go to the last section Standard key performance indicators
Click on the dots ▪▪▪ next to the indicator name
Click on Hide indicator.
Feel free to ask us for help on the Chat if you have any doubt!
We'll be happy to help you. 😊