Paying commissions

A number of years ago I used to do QuickBooks training for a computer firm,

A former client called me with a question that I don't know the answer to.

He is using the Premier Manufacturing & Wholesale edition.

He has commissioned sales people who receive a percentage of the gross profit for each invoice. He would like to setup Qkbks so that he can create a report that will show the gross profit and cost of goods sold per invoice, and also show the commission that should be paid.

Is it possible to do that, and if so how?

In perusing other message boards I saw a suggestion to use Excel to calculate the commission. If Qkbks does not have this feature is that the best alternative?

BG

Reply to
Brian Gotjunk
Loading thread data ...

Don't have a specific answer for you. I do know QB can't do this itself. There are add on programs that purport to calculate commissions. I'm still looking for one myself that will do this, including backing out sales tax and shipping and handling income and keep track if we have been paid as the commission isn't due until we have been paid in full. It's a pile of work to do this in Excel, but it can be done.

The documentation I see for most of these add-ons is so woeful that I can't tell what they do and don't do. It's a pity that the developers of these add-ons don't understand that potential customers have very specific requirements and need to know exactly what is possible before they plunk down their money. In other words, put the god damn user manual documentation online!

Reply to
Golden California Girls

We have a Commission Calculator QB helper. The basic version will calculate commissions on sales or invoice payments, but computes commissions on the entire amount. We do, however, have a modified version that will calculate commissions based on gross profit. And it could be easily modified, if need be, to allow you to exclude certain items. Just tell us what you need, and we'll provide you with a custom application that will fill your needs. See more at

formatting link

Larry St>

Reply to
Larry Stinson

Hi Brian,

QB by itself will not do that. That's why we developed Commission Calculator, an integrated Quickbooks application that retrieves the data from Quickbooks and calculates commissions based on the criteria you provide. Our standard version computes commissions on the entire amount of sales or invoice payments, but we have a modified version that computes commissions on a gross profit basis and is available for only US$200.

Contact us if you are interested or want more information. References are available upon request.

Larry Stinson Stinson Solutions Inc.

formatting link

Reply to
Larry Stinson

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.