Combine all the results into one spreadsheet. Send to finance. And that is when it works! If there is some issue in the report or with finance, the process gets into a painful circle of “fix-resend-check-fix-resend-check…” When the team grew past a handful of people, I started using transparency to eliminate 80% of this work and streamline the process. I put all the sales results into a single spreadsheet, with the calculated commissions. I then emailed the entire sheet to the whole team. Everyone could see everyone’s results, and how they personally ranked. Yes, everyone could see on our Salesforce.com dashboards how they ranked in numbers of opportunities or deals, but in the spreadsheet they could rank themselves by total compensation. They could see exactly who was doing the best and thus whom they could model or go to for advice (we had a culture of helping each other succeed). They could see if there were any problems with the report. They felt confident that they would get the right paycheck from finance, which is not true for many organizations—compensation payment issues are all-too common. They could trust in the process and not worry about it, because we were open and transparent with it. Ultimately, switching to this transparent process made comp reporting a snap for me and for them! I never took it to the next level, which would have been to have someone volunteer to be the Comp Lead, to manage the reporting and processing for me. But that would have been an easy next step.