Broker Commission Split Module
How a yacht brokerage automated broker commission splits in Zoho CRM, with Broker Sales records created directly from closed deals and split logic applied without manual calculation.
Client details generalized to protect confidentiality.
Brokerages where a sale is shared between brokers and commission is calculated by hand after the fact.
The Challenge
Sales were frequently shared between a listing broker and a selling broker, split by agreement. Commission was calculated after closing from the deal value, applied by hand, and communicated by email. Because the split was not recorded on the deal, reconstructing who was owed what on a sale from three months earlier meant finding the email. Disputes were resolved by memory, which is a poor basis for a payment conversation.
The Solution
Broker Sales Module
Commission lives in its own module with a record per participating broker rather than as fields on the deal.
- Custom Broker Sales module
- One record per broker per sale
- Split percentage per record
- Linked to the originating deal
Automated Record Creation
Closing a deal creates the commission records, so nothing depends on someone remembering to calculate them.
- Records created on deal close
- Split logic applied from the deal
- Participants resolved from deal roles
- Duplicate guard against re-firing
Split Logic
The applicable split is applied automatically, with the arrangement recorded on the sale.
- Standard split applied by default
- Non-standard splits set on the deal
- Percentages validated to total correctly
- Arrangement visible on each record
Commission Reporting
Brokers and management see commission by broker, sale, and period rather than reconstructing it.
- Commission by broker and period
- Sale-level breakdown
- Paid versus pending status
- Historical arrangement retained
Apps in This Solution
Zoho CRM
Zoho Analytics
Under the Hood Technical detail
- Record Per Participant
- One commission record per broker per sale, rather than split fields on the deal. Fields on the deal cannot express three participants and make per-broker reporting impossible, which is why the previous email trail existed at all.
- Split Validation
- Percentages are validated to total correctly before records are created, since a split that does not add up is discovered at payment time otherwise. Validation at creation is the cheapest place to catch it.
- Standard With Exceptions
- A standard split applies by default and non-standard arrangements are set explicitly on the deal. Requiring the split to be entered on every sale invites errors on the majority case that follows the standard.
- Arrangement Retention
- The arrangement is recorded on the commission records rather than referenced from a policy, so a change to standard splits does not retroactively alter historical sales.
- Notable Constraint
- Deals occasionally fall through after commission records exist. Reversals post as adjustment records against the original rather than deleting, so commission reporting reflects what happened and a broker can see why a figure changed.
The Results
- Commission records are created at close rather than calculated afterward.
- Each broker’s share is recorded on the sale instead of in an email.
- Historical arrangements survive changes to standard split policy.
Splitting Commission by Email?
We have built commission split logic and reporting in Zoho CRM for brokerages. Tell us how your sales are shared.