Define the pool before dividing it
To split a sales commission pool between two people, multiply the monetary pool by each person's agreed share. If the pool is C and the first share is q as a fraction, the first allocation is Cq and the second is C(1 − q). Their amounts should reconcile to the original pool. The shares describe a division of that identified money, not automatically percentages of the original sales revenue.
Begin with the agreement that defines what is being shared and which shares apply. This guide uses hypothetical allocations to explain arithmetic; it does not prescribe a fair, customary or legally required split. A lead source, closer, agency or partner can have different compensation terms. Without a defined pool and share rule, two people's contribution to a sale is not enough information to calculate an agreed payout.
Work a complete original two-person allocation
Assume eligible sales of 75,000 generate one flat commission pool at 5%. The pool is 75,000 × 0.05 = 3,750. If the stated split is 65% to the first participant and 35% to the second, their allocations are 3,750 × 0.65 = 2,437.50 and 3,750 × 0.35 = 1,312.50. Adding them returns 3,750, confirming that the full pool was allocated once.
The first person's amount is 3.25% of eligible sales, because 5% × 65% = 3.25%. The second person's amount is 1.75% of sales. Those derived percentages sum to the original 5% pool rate, not 100% of revenue. Entering 65 as a sales commission rate would calculate a much larger amount and answer the wrong question. Keep the pool rate and payout share in differently named fields or worksheet columns.
Validate shares before calculating money
For a complete two-person division of one nonnegative pool, shares should each lie between zero and 100% and sum to 100%. A 60% and 30% entry leaves 10% unallocated. That may be deliberate if a third retained amount is defined, but it is not a complete two-person allocation. A 70% and 40% entry allocates 110% and requires more money than the stated pool. Do not silently normalize either case without authorization.
Shares can instead be stated as a ratio, such as 2:1. Convert it by dividing each weight by the total weight of 3, giving two-thirds and one-third of the pool. Retain that exact ratio until monetary rounding rather than approximating it too early as 67% and 33%. If the agreement specifies fixed amounts or a priority payment before the remainder is split, model that sequence explicitly instead of assuming one complementary percentage pair covers everything.
Distinguish sales attribution from a commission payment
A revenue-credit split can assign portions of a deal to team members for reporting or quota purposes. That does not by itself establish how cash commission is divided. Salesforce's documented opportunity splits distinguish revenue credit from overlay credit, which can exceed a total of 100%. These records need interpretation through the actual compensation plan before they become payout calculations. A percentage shown in a sales system is not automatically a share of an existing money pool.
If both people use the same flat 5% rate, allocating the 75,000 sales base 65/35 and calculating each commission reproduces the pool split. If their rates differ, or either has personal tiers or caps, the operations may no longer be equivalent. Splitting one computed pool and computing separate earnings from credited sales answer different questions. Select the model that the agreement actually defines instead of assuming the two workflows can always be interchanged.
Apply deductions only in the stated order
Suppose the scenario first retains a defined 10% of the 3,750 pool before allocating the remainder. The retained amount is 375 and the distributable pool is 3,375. A 65/35 division then gives 2,193.75 and 1,181.25. Those two allocations plus the retained 375 reconcile to 3,750. Calling the first participant's original 65% a share of the final remainder should be explicit, because the underlying base has changed.
A charge assigned only to one participant would produce a different result from a charge removed before both shares. Do not decide that treatment from the fee's name alone. Taxes, deductions, chargebacks and dispute procedures require their actual rules and supporting records. The examples explain arithmetic on stipulated amounts and sequence; they do not determine whether a deduction is permitted, when commission is earned or when either person must be paid.
| Pool scenario | First allocation | Second allocation |
|---|---|---|
| 3,750; no prior retention | 2,437.50 | 1,312.50 |
| 3,375 after 375 retained | 2,193.75 | 1,181.25 |
The first row sums to 3,750. The second row plus retained 375 also sums to 3,750. Shares and retention are hypothetical terms.
Choose a rounding rule that conserves the pool
A pool of 100.01 split equally gives theoretical allocations of 50.005 each. Rounding each independently upward to cents would produce 100.02, a cent more than the pool. One explicit allocation convention is to round the first person's amount to 50.01 and assign the residual 50.00 to the second. The total then remains 100.01. That convention is illustrative and should not replace a different stated contractual or payroll policy.
Record which participant receives any rounding residual and why. Alternating or transaction-specific methods might be defined by an actual process; do not invent one silently. In a spreadsheet, an example residual formula is second amount = pool − rounded first amount. Keep the unrounded shares for audit purposes. A one-cent difference is a reconciliation issue, not evidence that the underlying percentage agreement changed, provided the documented rounding convention explains it.
Use the current calculator for the pool calculation
The Commission Calculator can compute the original pool from sales and a rate, including its supported base and tier scenarios. It has no dedicated two-person payout splitter. For the original example, use flat mode with sales 75,000 and rate 5 to obtain 3,750, then apply the 65/35 shares separately. Base salary is not part of that commission pool unless the stated arrangement explicitly says it is to be shared.
As a cross-check under the same uniform-rate assumption only, credited sales 48,750 at 5% give 2,437.50, while 26,250 at 5% give 1,312.50. This check works because the same flat rate applies to both portions. Do not apply it unchanged to individual marginal tiers or differing participant rates. Currency labels change display only, and the tool does not determine contribution shares, eligibility or actual payment obligations.
Save a reconciliation with names, bases and amounts
A reviewable split record names the relevant sale or period, eligible base, pool calculation, any prior retention, participant shares, rounding convention and final amounts. For the simple example, retain 75,000 × 5% = 3,750, then 65% = 2,437.50 and 35% = 1,312.50. Check that shares and money totals reconcile separately. One can balance while the other remains attached to the wrong base.
Use the reverse-rate guide to audit the pool's rate and the spreadsheet guide to implement repeated rows. Keep sales credit, commission entitlement and cash paid in separately labelled records when timing or adjustments differ. A transparent allocation makes a discussion about assumptions easier because the arithmetic is visible. It does not resolve a disagreement about which compensation terms apply; that requires the agreement and relevant records rather than a preferred percentage example.