Interior Industry Overview
QCommission enables you to quickly calculate commission, draw and bonuses, verify results and distribute this information to your account executives, recruiters, consultants and managers. Present the commission information in such a way that your staff clearly understands what they are being paid and why they are being paid at a very detailed level. Excel and manual calculations can introduce a lot of errors into your calculations and cause your staff to lose trust in you. QCommission can help avoid that by calculating all commissions systematically and reliably.
Calculate Accurately with Flexible Rules
- Pay commission by various types of services such as legal,audit, etc.
- Calculate commissions-based sales revenue or profit.
- 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 payment 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.
QCommission is designed to integrate with QuickBooks®, Salesforce.com, Sage Peachtree MS Dynamics GP, MS Dynamics Axapta 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 Carrier data 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
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
QCommission Software Helps Pearl Design Group in Automating Their Sales Commissions
Pearl Design Group is an innovative kitchen and bath design company. Their designers have 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.
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 prosess have been a burden and time consuming issue for many years. Always trying to be more efficient they have 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 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 highre breed version of Quick Books. 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 Quick Books. The very best part is when I have a question, request, or need the support team is always ready to assist, and always fulfill my needs! I completely trust this company and their products, and I highly recommend them.”
“Just what we needed.”
“Our company uses a high breed version of Quick Books. And though the makers of Quick Books (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 Quick Books. The very best part is when I have a question, request, or need the support team is always ready to assist, and always fulfill my needs! I completely trust this company and their products, and I highly recommend them.”- "The QCommission implementation team understood the challenges of job profitability based sales commission plans. The team worked closely with me and was always very eager to ensure that I had the best experience during the implementation and while using the software. I am highly satisfied with the solution and would happily recommend it to any company paying commission based on job profitability."