What is the easiest way to track sales commissions for internal and external agents?

Most of current sales systems for homebuilders include the ability to track the information needed for calculating simple % or $ based commissions. That being said, we often have very complex commissions’ formulas for our internal sales team. Such things as draws, cancellations of sales, etc. all come into play. In that case, it is best to feed the data out to a standard Excel, perhaps using Excel Pivot. You could also use an export directly into your payroll system if it is set up to handle draws, etc. And, don’t forget about Power BI. The most important thing would be to build an export file to feed into your external calculation tool. We don’t want any duplicate entry.