Every closed-won deal tagged to a partner now calculates its own commission by tier, rolls into a branded monthly PDF statement and posts a payout record to accounting. Partners track earnings on a live dashboard, and payouts run in two days.
Typical results
1
Commission dispute last quarter
1 hr
Finance time per cycle
60
Partners paid on time
Figures reflect typical results for this kind of automation.
The challenge
Commissions for 60 referral partners lived in a spreadsheet only one finance person understood. Each cycle took three weeks of cross-checking deals, tiers and clawbacks — and still produced eight disputes a quarter. Partners saw their numbers only at payout, so every statement arrived as a surprise, rarely a good one.
Before and after
Payout cycle
−90%Finance time per cycle
−94%Commission disputes per quarter
−88%The automation
We encoded the commission plan — tiers, bonuses, clawbacks — into a Make flow that fires whenever a closed-won deal carries a partner tag. Commissions calculate instantly, accrue to a live dashboard each partner can check anytime, and compile on the first of the month into branded PDF statements. Payout records sync straight into the accounting system, so finance reviews a reconciled batch for an hour instead of rebuilding a spreadsheet for weeks.
How it works
- 01
Deal closes
A closed-won deal tagged to a partner triggers the commission flow.
- 02
Commission calculated
Tier rates, bonuses and clawback rules apply automatically — no spreadsheet, no formulas.
- 03
Statement generated
Each partner receives a branded PDF statement on the first of the month.
- 04
Books stay synced
Payout records post straight to the accounting system, ready for the payment run.
- 05
Dashboard, not surprises
Partners watch commissions accrue live instead of waiting for quarter-end.
Starts from
- Closed-won deals
- Partner tiers & rates
Delivers
- Branded PDF statements
- Payout records to accounting
- Live partner dashboard
The impact
The payout cycle shrank from three weeks to two days, and finance now spends about an hour per cycle instead of sixteen. Disputes fell from eight a quarter to one, and partners — finally able to watch commissions accrue in real time — started referring noticeably more deals.
Questions about this automation
Which commission rules can the flow handle?
The plan is encoded as rules: tier rates by partner level, volume bonuses, separate rates for new deals and renewals, and clawbacks when a customer cancels within a set window. When finance changes the plan, the rates are updated in one settings table instead of in spreadsheet formulas, and the next closed-won deal uses the new terms.
How do payouts reach the accounting system?
On the first of the month, the flow totals each partner's accrued commissions, generates a branded PDF statement and posts a payout record to the accounting system with the matching deal references. Finance reviews one reconciled batch and approves the payment run, so nothing is retyped between the CRM and the books.
What can partners see before the statement arrives?
Each partner has a dashboard showing every tagged deal, its stage, the commission accrued and any clawback applied. Figures update as deals close, so payouts hold no surprises, and each statement line carries a deal reference that points finance straight to the source record. It is a multi-step build, usually rolled out in stages, starting with the commission calculation.
