Commissions are primarily calculated on Revenue. Revenues are mostly based on invoices added in the accounting system. From the accounting system we can export the data into CSV file then it can be imported into QCommission easily. The various attributes of invoices can be used in the calculation of commissions. In many situations, sales reps are directly associated with invoices. This can be used in properly crediting the invoice to the sales rep prior to calculating commissions. Other data attributes useful in commission calculations include Quantity, Amount, Customer, Product, etc.
A key requirement is the ability to only import transactions for the particular commission period that is being currently processed. The QCommission system automatically understands the date range being processed and only brings in the transactions necessary for proper calculations.
In addition to transactional data, QCommission can import master data such as Customer, Item, Vendor, etc. The data imported can include the hierarchy structure. This becomes very useful in calculating commissions based on these various criteria.
Sales reps are normally people on the payroll of the company. Many companies use the payroll functionality available within their accounting systems to issue the paychecks. In addition to base pay, sales commission payments will need to be processed and provided as paychecks to the employees. QCommission can export the commission information for a specific payee. Sales commission payout information can then be processed as part of the paycheck.
QCommission does a tremendous job, understanding the intricacies of the CSV 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.