Sales targets and bonuses: keep the real calculation out of a separate spreadsheet

Many companies keep targets inside the ERP and the real bonus calculation outside it.

That usually happens because compensation rules are too specific for a standard report.

Targets can be different by person

One salesperson does not necessarily have the same goal as another. Turning progress into a percentage makes results comparable without losing the individual target.

Not every sale has to count the same way

The company may decide certain product lines or groups should form separate indicators. Metrify can trace a KPI down to the item, identify line and group, and decide which indicator it participates in.

The bonus is another rule

Suppose 100% activates a base bonus and the amount continues growing proportionally above that point. The formula is not universal. What matters is that the system can represent the rule the company has already decided to use.

When that happens, the dashboard becomes part of the commercial process instead of a visualization after the fact. A result visible during the month can still change behavior; a result delivered after close only explains the past.