TKO Associates has been a cutting edge wholesale supplier of high-end residential and commercial decorative hardware, plumbing fixtures and accessories to the greater DF/W architect, builder and design communities since 1981.
TKO pays commissions monthly based on the gross profit of their sales. TKO uses QuickBooks Enterprise as their accounting system. QuickBooks does not have the ability to produce an invoice or line item level P&L report. The QB profit and loss by job report only works on the total job not on individual invoices that may span several months or years, thus commissions became a manual process of two reports downloaded into Excel and merged, labor intensive and subject to all kinds of errors.
When I became the QB Pro Advisor for TKO, I reviewed the setup and saw the potential for using QCommission to greatly stream line the commission process. I worked with an extremely helpful and knowledgeable programming staff and their responsive customer service team. They were able to customize QCommission to satisfy the requirements for many unique situations.
Many of our custom orders were ordered and paid for in previous periods, even previous years, and applied to current period sales orders and invoices, the team worked with us to configure a field that allowed a "date completed" to be read into QCommission.
Queries were developed that allowed us to run interim commission report to cross reference and be pro-active in looking at not only at the invoice level P&L's but line item P&L's.
Queries were developed that allowed us to "mass hold" items with sales but not cost, thus easy to review and research before commission time.
Best of all they produced a query that allowed us to down load individual sales persons reports so the sales team could monitor the sales during the month. This allowed the sales team to be involved with their reports throughout the month, not just at the commission time. The saving for the company went across the board, labor, accuracy and satisfied and happy sales team members.
I have recommended QCommission to many of my other QuickBooks and Enterprise clients. The cost is very reasonable and the benefits are soaring.
|