Tracking Rep Commissions that Differ By Customer in QuickBooks

How to Track Sales Rep Commissions by Customer in QuickBooks

A reader wrote to ask how to manage monthly rep commissions that differ by customer. The best way to do this is to create a custom field in QuickBooks for each customer for the commission rate, and also use the Rep field in every customer transaction. Any QuickBooks report that lists the customer total sales, the custom field, and the rep name can be exported to Excel in order to calculate the commissions.

Be Sociable, Share!

Comments are closed.