Construction Industry Sales Commission


Overview

QCommission allows you to efficiently compute commission, draw, and bonuses. It also enables you to verify the results and share this information with your account executives, recruiters, consultants, and managers. By presenting commission details clearly, your staff will have a thorough understanding of their payments and the reasons behind them. Relying on Excel and manual calculations can introduce numerous errors, leading to a loss of trust from your staff. QCommission can prevent such issues by consistently and accurately calculating all commissions.

Calculate Accurately with Flexible Rules
QCommission provides a lot of flexibility to set up commission plans that are unique to your company and your payees.

  • Pay commission by various types of services such as closed projects, gutter sales, contracts, and project consulting, etc.
  • Calculate commissions-based job profitability, closed jobs and track the commission due.
  • Pay commissions at time of invoicing, at time of payment or when job is complete.
  • Pay commissions on one-time payments or on multiple payments for a payment plan.
  • Pay different commission rates for different services.
  • Pay different commission rates by payments plan.
  • Pay different commission rates for sales reps.
  • Split commission rates between sales reps.
  • Pay overrides to managers and principals.
  • Deduct service fees prior to calculating commissions.
  • Pay referral commissions.
  • Pay commissions as a portion of results, flat amounts, tier rate with thresholds, etc.
  • Calculate incentives weekly, bi-weekly, monthly, and other Chargeback commissions for cancelled contracts.
  • Handle negative payouts.
  • Pay draws or guaranteed payouts.


Import/Export 
QCommission is designed to integrate with Salesforce.com, Sage Peachtree, Sage Intacct, MS Dynamics GP, MS Dynamics Axapta, QuickBooks®, SugarCRM, Xero, NetSuite, and many others.  QCommission can also accept Excel, fixed file and delimited format files. QCommission can also process some PDF format files. QCommission can also operate stand-alone.

  • Import data from accounting system including Invoices, Expenses, Payees, Customers and Products.
  • Import from from Excel, PDF and fixed or text-delimited files.
  • Restrict Transaction import using a date range.
  • Export Commissions payouts for accounts payable and payroll.
  • Export data to Excel, and fixed or text-delimited file formats.
  • Eliminate shipping, tax charges from calculations.

Reporting
QCommission stores all data entered and all payout calculations.

  • Produce detailed commission statements by payee.
  • Reproduce commission statements for prior periods.
  • Report on split credits and uncredited transactions.
  • Analyze historical transaction and payment information.
  • Email commission statements to payees.
  • View commission statements through the web.
Case Study

QCommission Software Helps Pearl Design Group in Automating Their Sales Commissions 

Customer Profile
Pearl Design Group is an innovative kitchen and bath design company. Their designers have many years decades of experience, creating affordable and stylish kitchens and/or bath solutions for the many different customers segments. With their 54 years of knowledge and experience in the building industry, they enjoy the challenges of designing - from fully functional gourmet kitchens, entertainment areas, home offices, bars, and even the simplest of powder rooms.

Pearl Design Group provides a wide range of services including consultation, planning, selection assistance, estimating, field measuring, product management, and commercial customization. Their manufacturing division and partnership with the top product distributors gives customers the ability to choose the right products for their projects including cabinets, counter tops, plumbing, appliances, and hardware. They are a unique resource, unlike any in the Chicago area.

The Problem
Pearl Design Group has a unique job profitability requirement. Sales commissions are calculated based on job profit when the income and expense transactions are paid. And they need to tie the payroll expenses given for the person when calculating final commissions. 

Customer Profile
Pearl Design Group is an innovative kitchen and bath design company. Their designers have many years decades of experience, creating affordable and stylish kitchens and/or bath solutions for the many different customers segments. With their 54 years of knowledge and experience in the building industry, they enjoy the challenges of designing - from fully functional gourmet kitchens, entertainment areas, home offices, bars, and even the simplest of powder rooms.

Pearl Design Group provides a wide range of services including consultation, planning, selection assistance, estimating, field measuring, product management, and commercial customization. Their manufacturing division and partnership with the top product distributors gives customers the ability to choose the right products for their projects including cabinets, counter tops, plumbing, appliances, and hardware. They are a unique resource, unlike any in the Chicago area.

The Problem
Pearl Design Group has a unique job profitability requirement. Sales commissions are calculated based on job profit when the income and expense transactions are paid. And they need to tie the payroll expenses given for the person when calculating final commissions.
Prior to QCommission, they were doing everything manually by exporting invoice data and cost data via job profitability reports for specific time periods, exporting payroll reports, combining, and sorting all data, and formulating gross profit against actual pay. A separate spreadsheet is kept and updated as each time period is completed, allowing an account format to determine commission +- value.  For Pearl Design Group; The mechanics of this process have been a burden and time-consuming issue for many years. Always trying to be more efficient they have also tried many independent software programs with very minimal success.

Bob Carlson, General Manager at Pearl Design Group constantly researched for a solution when he found QCommission. Making an inquiry. He had a good feeling that the QCommission program was different, and immediately he chose QCommission for their business in August of 2013.

The Project
The QCommission Implementation Technicians (the team) kicked off the project by conducting an in-depth discovery meeting. The primary objective of connecting to QuickBooks® to bring in fully paid invoices, bills, credit memos, customers, customer jobs, and other related data were easily done using the standard integration function present in QCommission. The team then configured necessary sales compensation plans to automate all aspects of the sales commission process.

To calculate the job profit, QCommission options were set to pick up costs as well from QuickBooks® by matching the customer job number. In addition, the team also handled the payroll expense transaction associated with payees. The team configured plans and validated the output for a pay period to ensure that QCommission was calculating commissions accurately. An additional requirement was for the software to configure the commission statement template to show the current period commissions and accrued commission totals.

The Implementation team then trained Bob to use the software effectively.  Bob was able to use the solution with little support after the go-live.  QCommission has been used by Pearl Design Group since December of 2013. They have been a client for more than 2 years now.

Bob Carlson, Pearl Design Group’s General Manager, noted QCommission as “A huge leap forward”. He further added, “Our Company uses a higher breed version of QuickBooks®. And though the makers of QuickBooks® (Intuit) have created a formidable all-around business software, they have not been able to create a commission add-on to their package. This has been an issue for many years, and we have tried many independent software programs with very minimal success. A few years back our accountant mentioned a program called QCommission by CellarStone. I did a little research, made an inquiry, and I had a good feeling that this program was different, and I immediately felt a very professional relation with their support team. QCommission was the answer to our problems, and it continues to be a seamless and outstanding third-party software to QuickBooks®. The very best part is when I have a question, request, or need the support team is always ready to assist, and always fulfil my needs! I completely trust this company and their products, and I highly recommend them.”

Quote

“Just what we needed.”

“Our company uses a high breed version of QuickBooks®. And though the makers of QuickBooks® (Intuit) have created a formidable all-around business software, they have not been able to create a commission add-on to their package. This has been an issue for many years, and we have tried many independent software programs with very minimal success. A few years back our accountant mentioned a program called QCommission by CellarStone. I did a little research, made an inquiry, and I had a good feeling that this program was different, and I immediately felt a very professional relation with their support team. QCommission was the answer to our problems, and it continues to be a seamless and outstanding third-party software to QuickBooks®. The very best part is when I have a question, request, or need the support team is always ready to assist, and always fulfil my needs! I completely trust this company and their products, and I highly recommend them.” 

Bob Carlson, General Manager, Pearl Design Group.