Paying commissions

[brian gotjunk]

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 per invoice, and also show the commission that should be paid.

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

In perusing some 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

[shady]

I have done what you asked in this manner. For each item i sell, i created 2 new fields. #1 is cost (gross) and #2 is commission. On sales orders, I have this field shown but not printed. When i create a sales order, these fields are populated automatically. These fields are then carried over to invoices once an order is shipped. I do not have this printed on invoices but it is kept in the invoice history once posted. I have a custom commission report that will list sales by rep. I then export to excel and set up a column, multiplying the extended sale price * commission. This gives me commissions and costs in a spreadsheet which I use to pay commissions to reps and have a gross profit total as well for the time period I use (monthly). Might be cumbersome, but it works well.
Always looking for a better way as well.

[brian gotjunk]

Shady,

Would you mind e-mailing me a copy of the excel file that you use, so that I can see the setup?

Brian