Reps keep shadow spreadsheets for one reason: they can't verify the official number. Commish gives every rep their own statement — gross, clawbacks, net, and the deals behind each — so trust stops being a feeling and starts being a login.

Each rep sees their own earnings and nothing else — enforced in the database, not just the interface. Every statement lists the deals on it, the component that paid each one, and downloads as a PDF for the filing cabinet (or the mortgage broker). Clawbacks appear with their reason attached, because a deduction without an explanation is how trust dies.
When a number looks wrong, the rep raises it against the exact deal that produced it — not as a Friday-afternoon argument about a workbook. Whoever answers can see the same line, the same components, and the same clawback reason the rep is looking at, so the conversation starts from shared arithmetic instead of two spreadsheets.
Run a cycle and every rep gets their statement, with the math attached.
Screenshots show a demo organisation with illustrative data.