QCommission Integration with SugarCRM

The calculation of sales commissions is a very complex problem, yet the majority of companies use highly manual processes to do the work. With QCommission the entire process of automating sales commissions can be accomplished.For sales people, nothing is more important than the sales compensation check they get on a regular basis. Sales people work hard to close their sales and expect to get their sales commissions correctly and on a timely basis. They expect the calculations to be accurate based upon the agreed upon sales compensation plans. They need clear and detailed statements that explain the basis of every calculation.

The majority of sales people would agree they do not get a clear and correct sales commission statement. Sales compensation plans are by their nature complex. The data needed to calculate the plans is not always available, the plans change on a regular basis and there are exceptions to the exceptions. Sales people get their sales commissions typically weeks or months after the period is over. Frequently the crediting and calculations are incorrect. As a result, the sales commission statements are not clear and obvious. They have no idea how they are getting paid, or waste time trying to figure out what they should get paid.

With the advent of Customer Relationship Management (CRM) systems, companies are attempting to automate the sales process and customer interactions. More and more sales people access CRM systems to get their job done. But there have been challenges in CRM adoption as sales people resist the solutions. If salespeople have to access the CRM system to get access to their sales commission statements, they are more likely to use the CRM system for its intended purpose. If a salesperson knows they can help get paid accurately, they will make sure to keep the systems accurate and thus help keep the system up to date.

A sales commission solution that can accurately establish and calculate commissions and can seamlessly provide the sales commission statements for viewing by sales people can be a great advantage to firms. In addition to reducing commission errors, reducing time taken to administer and increasing sales people productivity, the solution can increase SugarCRM adoptions.

QCommission is a powerful, flexible sales commission software tool. It calculates sales people’s compensation, accurately, quickly and professionally. QCommission is integrated with the SugarCRM system as well as accounting systems such as MS Dynamics GP, MS Dynamics AX and QuickBooks.

SugarCRM is a customer relationship management solution, used to manage global sales and marketing lifecycles and enhance the productivity of enterprise sales, marketing and service professionals. It has various editions such as Sugar Professional, Sugar Enterprise, Sugar Ultimate and SugarCRM Community Edition (installable version and open source). SugarCRM also supports 3rd party applications integration.


SugarCRM, supplies Web services, a pool of API calls for building applications and integrating with SugarCRM objects. This set of APIs allows you to create and retrieve data from accounts. The platform also ensures that the third party product is properly authenticated prior to getting access to the SugarCRM data. TheSugarCRM platform allows you to customize standard objects, build custom objects and fields. Use of the web service API calls along with SOAP information makes sure that the integration works well with the SugarCRM. The CRM also ensures that the third party product is properly authenticated prior to getting access to the data. All access to SugarCRM is through the Web service API requests.

QCommission utilizes a technology called QXChange to integrate to other applications including SugarCRM. Specific data access plug-ins (DAP) for different systems can be added to QXChange to integrate with various different data sources. A special DAP for SugarCRM allows QCommission to exchange data with SugarCRM.


QCommission is a fully web-based SaaS application with the ability to be implemented as a public or private cloud application.

The plan designer is used to establish sales compensation plans for the sales force. The responsibility for this function typically lies with sales operations but can also be shared by finance or human resources. Commission plans can be unique by sales people or common across groups of people. Data for commission calculations can come from various sources, but including Opportunities from the corporation’s CRM systems. Sales commissions can be calculated on opportunities, orders, invoices or payments. This is the primary data that is imported into QCommission. Opportunities within SugarCRM can also be imported into QCommission and treated as transactions against which commissions should be calculated.

Various attributes of transactions can be used in the calculation of commissions. In many situations, sales reps are directly associated with transactions. This can be used in properly crediting the transaction to the sales rep prior to calculating commissions including sales credit splits. Other data attributes useful in commission calculations include Territory, Quantity, Profit, Customer, Product, etc.

Calculations are done on a periodic basis. The calculation process produces commission results for each individual sales person in the system. The most effective way of getting the commission results to the sales people is to present the results through a CRM system such as SugarCRM. The presentation module in QCommission essentially presents the commission results directly to the sales force individually via SugarCRM.

Data Objects

The QXChange layer loads data from the SugarCRM to QCommission or vice versa. Any data table in SugarCRM can be used to extract and load data.

Customers: This object shows the customer information of the company.

Products: This object shows which products of the company.

Opportunities: This object shows which source transactions were credited to which sales person.

The data is specific to each sales rep and the sales people can access their data in detail. Queries can be executed and reports can be generated against these data objects.


QCommission does a tremendous job calculating individual commissions for the sales person. With the SugarCRM, it brings the calculated data to the salesperson. With this integration it ties the two systems in such a manner that the complexity is reduced to a minimal level.
Content and Logo © SugarCRM
Customer Testimonials
"I would just like to reiterate how much I appreciate the OUTSTANDING customer service you provide. I emailed you last night at 7:04pm and you were on it immediately! There aren't enough accolades to express my deep appreciation for your spot on resolution to my support needs. All of you on the support team are best customer service driven staff I've had the pleasure to work with!"