Build or Buy: Syncing Closed Deals to Your Commission Engine

A commission calculation needs the closed-won timestamp, the final deal amount, the product or plan sold, any discount applied, and how credit splits between reps if more than one touched the deal. Each of those has to arrive in the commission engine in a form it can actually use, which usually means normalized field names and consistent formatting, not whatever your CRM happens to export.

Get the order wrong and you get a race condition: the commission engine calculates a payout before a late-arriving discount approval updates the final deal amount, and now the number is wrong before anyone's even reviewed it.

A single-rep, full-price deal is easy to calculate by hand. Two edge cases break spreadsheets fastest: split credit between an AE and an SDR (or across territories on a co-sold deal), and clawbacks when a customer downgrades or churns inside the commission recovery window. Both require the calculation to reference data that changes after the original close date, which a static spreadsheet formula doesn't handle well without someone manually catching every update.

Building a sync (usually a webhook or Zapier-style automation pulling from a CRM like Pipedrive or Close into a spreadsheet or internal tool) looks cheap upfront but accumulates maintenance cost every time a CRM field changes or a new comp plan variant gets added. Buying a dedicated commission platform costs more upfront but absorbs that maintenance, plus gives reps self-serve visibility into their own number.

The deciding factor is usually plan complexity: a flat commission rate on one product line is fine to build and maintain yourself. Multiple plans, tiers, and split rules across a growing team push the balance toward buying.

There's a middle option worth naming: a mid-market commission tool that connects to your CRM out of the box, without a fully custom build or a full enterprise platform's implementation timeline. For a team past the single-plan stage but not yet running a dozen plan variants, that middle tier often matches the actual complexity better than either extreme.

Run these checks before commission runs off the new sync:

• Reopen a closed-lost deal by mistake and confirm it doesn't generate a payout.
• Verify that split percentages on a multi-rep deal actually sum to 100, not more or less.
• Confirm currency and timezone alignment so a deal closed at 11pm on the last day of the month lands in the right period.
• Test a discount approved after the deal closed and make sure it updates the payout, not just the CRM record.

Reps can check their own projected commission without pinging finance. Commission runs don't require someone manually pulling and reconciling a CRM export against last month's numbers. And when a deal changes after close, whether through a discount, a split correction, or a downgrade, the payout updates automatically instead of requiring someone to remember to adjust it by hand.

An enterprise deal closes with an AE and an SDR both touching it: the SDR sourced the meeting, the AE ran the deal to close. Under a manual process, finance has to go find both people, confirm the agreed split from a Slack message or an email thread, calculate each person's share by hand, and enter it into the payout spreadsheet before the commission run. If either rep disputes the split after the fact, the whole thing gets reopened.

With the split percentage captured as a required field on the opportunity itself at the time the deal is created, rather than negotiated after the fact, the sync pulls it directly and the commission engine calculates both shares automatically. The dispute risk doesn't disappear, but it moves earlier, to when the split is agreed and documented, rather than showing up as a surprise during the commission run.