Skip to main content

Solution for KPIs calculation on Salesforce

A solution that enables easy bonuses and KPIs calculation captured in Salesforce Reports

Published by admin
18 January 2021

Project description


The Jar House company is a forward-thinking, non-traditional real estate brokerage based in the US. The process of selling real estate involves employees from different departments who carry out their specific tasks. The effectiveness of the entire sales process is composed of the effectiveness of each employee involved in the process. To increase the overall work productivity, the Jar House company implemented a flexible system of material bonuses that are accrued, depending on how well employees cope with their tasks. Employee’s performance has been captured in Salesforce Reports. And bonuses, initially calculated using linear interpolation formulas and a special table in Excel, were manually transferred to an Excel spreadsheet. Linear interpolation formulas in Excel have calculated the final value of material bonuses for each employee.


  • Necessary to create an application for Salesforce that will automatically calculate the number of bonuses that should be accrued to each employee, depending on the results obtained in Salesforce Reports;
  • Avoid human mistakes risks when working with both systems: Salesforce and Excel;
  • Automate the calculation process and decrease the time required for calculations;
  • A transparent system of calculation with easy to set up access rights and permissions.

Project scope

An application has been developed that uses Reporting Snapshot to download employee KPI values ​​from Salesforce Reports. The uploaded value is calculated based on special scales, linear interpolation formulas, calculation formulas, and benchmark formulas. The application allows you to independently enter metrics for which bonuses are awarded. The application allows, if necessary, to manually edit the values ​​of accrued bonuses for employees. The application can calculate bonuses both by pressing a special key and on a predetermined date.


  • Jar House has received a flexible application that allows you to define material bonuses for employees without using third-party applications and services;
  • The process of calculating bonuses has become automated and does not require much time for constant manual work.
Start your project now
  • 2 Salesforce Developers
  • 1 Technical Architect
  • 1 Project Manager
  • 1 QA Engineer
  • APEX
  • Git
  • JIRA
  • Salesforce Data Loader
  • 1 month

We have available resources to start working on your project within 5 business days

1 UX Designer

1 Admin

2 QA engineers

1 Consultant

Related Articles
All articles
How to insert a picture into the background of a block in 8 steps
Salesforce Marketing Cloud Content Builder allows significantly speed up email creation processes within an organization. There is no need to code every email as the standard drag-and-drop functionality provides predefined templates and blocks to create a new email with no code. However, there are some limitations in this standard tool, and in this article, I will be guiding you on how to create an image as a background.
23 February 2022
Service Cloud for beginners. Short guideline by JET BI
Service Cloud is the best product to provide better customer service, give the proper information and support they need. It refers to the module “Service” in Salesforce. So if you sell products, customers will need your support. It can be any type: giving information about the product, solving the problems that they have with the product, or selling related products. Service Cloud is a CRM platform that automates service processes for business needs and it is built on a SaaS model.
20 January 2022
Doing good with Bid4Good is easier than we think
JET BI has created the product for making other lives easier and has two purposes. The first of them is an understanding that donating is a simple process, and the other goal is finding a second life for things. In the Bid4Good app, they act as lots. In the world of overconsumption, we have to be conscious and give our staff a second chance. 
20 January 2022