Calculating and tracking commissions in QuickBooks can be time-consuming and prone to errors. Automating the process saves time and assures reps that they are getting paid the right commission promptly.

We have clients whose rules for calculating commissions vary widely from simple to complex. This is a typical one that was done for a client who needed a commission report by sales rep based on current active jobs and their estimates. Additional rules for calculating the commission are as follows:

1.     Commission rate varies by job type
2.     Two reps can split the commission
3.     If the estimate margin is < 20%, they get 5% less commission.
4.     If the estimate margin is > 30%, they get 5% more commission.

"Small" job reps are paid on invoice, while "large" job reps are paid on payment. The report has separate running totals of invoices, payments, and both estimated and actual margins. The report also needed to track past commission payments and calculate payments due.

Our client can now create the report with one button and has confidence that the numbers are correct.

Click here to see samples of Commissions and Bonus Calculations.