QCommission Integration with ADP

Overview
Sales commission programs are possibly the most variable programs conducted by a firm. These programs tend to vary significantly from industry to industry, and many times within companies in an industry. Sales commission programs tend to be different by employees even within a single firm. Because of the highly variable nature of commission calculations, solutions attempting to solve the problem must be highly sophisticated. At the same time, they should not burden the user with additional complexity in their operations. One key area of complexity is allowing data interchange between the customer's existing accounting systems and the commissions system. A commission system that can understand the structure of the accounting system data and seamlessly bring in the appropriate data necessary for calculating commissions can be a huge benefit in reducing the inherent complexity in that process.

QCommission is a powerful, flexible sales commission software tool. It calculates sales people's compensation accurately, quickly and professionally. QCommission is integrated with QuickBooks® but can also be operated stand- alone.

ADP is a comprehensive global provider of cloud-based human capital management (HCM) solutions that unite payroll, HR, talent, time, tax and benefits, and a leader in business outsourcing services and analytics. ADP offers industry-leading online payroll software & HR services and solutions tailored to you no matter what your business size. Using ADP payroll software, our experts integrate your payroll and HR information into a single unified platform, saving you time to focus on your business.

Technology
ADP WorkforceNow, supplies API services, a pool of API calls for building applications and integrating with ADP WorkforceNow objects. This set of APIs allows you to create and retrieve data from Workers, Worker Demographics, Timesheets, Locations, Departments etc. The platform also ensures that the third-party product is properly authenticated prior to getting access to the ADP WorkforceNow data.  All access to ADP WorkforceNow is through the API requests. There are two authentication mechanisms available in the ADP WorkforceNow API and both are supported in our DAP.
  • Direct Client ID and Client Secret Authentication.
  • Consent Based Authentication. 

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

Importing Data
ADP WorkforceNow can be defined as source data and the various objects can be accessed. Field level data from the objects can be extracted and mapped to destination objects and fields in different data formats. Data from multiple objects can be extracted. Multiple profiles can be set up to extract data from various objects. Source data can also be filtered using various expressions. Prior to executing extract, the source data can be viewed to make sure the right records are getting selected.

For QCommission the commission calculation requires the Worker and their corresponding TimeEntries data. ADP WorkforceNow is enabled to pull data from both Worker and TimeEntries data which is used for commission calculation in QCommission.

Exporting Data
QCommission is now enabled to push the payroll data to the ADP WorkforceNow. This is achieved using the ADP WorkforceNow PayDataInput API. Using this the calculated commission data can be pushed to ADP WorkforceNow as Payroll Data.

Conclusion
QCommission does a tremendous job, understanding the intricacies of the ADP as well as the complications inherent in the data integration process.  With this ability it integrates the two systems in such a manner that the complexity to the customer is reduced to a minimal level.

Print   Email