Commission/finder's fee--how to track?

We have a vendor who has asked us to provide products for a customer, bill the customer directly, and add 10% to our prices as payment for the vendor for their services installing the products. My question is, how do we set this up to track it properly? I can add the vendor as a salesman, but do I link the vendor to the salesman number in Salesman Maintenance? If so, how do I track it in GL, and what effect does this have? I had done a test and linked the vendor with a Subcontracting Expense GL, but there wasn't anything listed in that GL account after updating. My theory is that there won't be anything there until we actually write a check to the vendor, but are not sure that we've got it set up correctly. We want to ensure that the 10% doesn't show up as our profit, but are at a loss as to how to track it properly.

We are using Sage 100 2016.

  • 0
    Have you looked at checking the box for Updating Commissions To Other Modules in AR Setup Options? In a test company you should look at this feature. You can link the salesperson you created to this vendor.
  • 0 in reply to BigLouie
    BigLouie, we do have that checked. I just wanted to be sure that it will track correctly. When I look at the Gross Profit Journal, the entire amount over cost is listed as gross profit; will that change after the check for commission is written to the vendor? We are hoping to be able to use Sage reports as a more accurate profit tracking tool (as that is supposed to be one of its uses, after all) but I know that it has to be set up correctly for the numbers to be meaningful.