Tracking Broker Commissions and Splits Without Spreadsheets
Commission disputes are rarely about money owed. They are about nobody being able to show the math. Put splits on the deal and the arguments mostly go away.
It is the second business day of the month and the office manager has four spreadsheets open. One from the funder showing commissions paid, one tracking which broker owns which deal, one with the split percentages that changed in March, and last month's version of this month's statement. A broker is standing at the door asking why his number is lower than he expected.
Most funding shops run commissions this way for longer than they should. It works while the floor is small and the deals are simple. Then come ISO partners with their own splits, house deals, renewals with different rates, a clawback from a merchant who defaulted early, and a manager override. At that point the spreadsheet is not wrong, exactly. It is just impossible to check.
Pre-flight summary
- Document every real commission arrangement, including the unwritten exceptions.
- Record splits on the deal at funding so payouts calculate from one source.
- Set and document a clawback policy before you need it.
- Give brokers statements and access detailed enough to verify their own pay.
- Close periods on a schedule and keep a trail of every split change.
Leg 01Map every way money flows before you build anything
Start by writing down every commission arrangement the shop actually has. Not the policy document, the reality. Which brokers are on which split, which ISOs send deals and what they are owed, whether managers get an override, how renewals are paid, and what happens when two brokers touch the same file.
You will almost certainly find exceptions that live in one person's memory. Capture them now, because a system can only apply rules it knows about.
- Commission received from the funder, as a percentage or flat amount per deal
- Broker split by tier, tenure or deal type
- ISO or referral partner splits on deals they send
- Manager or team-lead overrides
- Different rates for new deals and renewals
- Clawback terms from funders and how they pass down to brokers
Leg 02Attach the split to the deal, not to a spreadsheet row
The single change that removes most disputes is recording the commission arrangement on the deal itself at the time it funds: who gets paid, what percentage, and on what basis. When the funder's commission arrives, the payout calculation runs from that record, not from someone's memory of what was agreed.
Here is a hypothetical. A deal funds for $60,000 and the funder pays the shop a commission of $6,000. The deal came in through an ISO partner on a 40 percent split, and was worked by a broker on a 50 percent split of the house share. The ISO receives $2,400. The remaining $3,600 is the house share, of which the broker receives $1,800. The numbers are only illustrative; the point is that every party's share is computable from the deal record, by anyone who checks.
FundPilot keeps syndication, payoffs and broker payouts on one ledger, so commission records live with the deal they came from rather than in a separate file that has to be kept in sync.
When every split lives on the deal it came from, a commission dispute becomes a lookup instead of an argument.
Leg 03Handle clawbacks before they happen
Some funder agreements allow them to reclaim commission if a merchant defaults or pays off within a short window after funding. When that happens, the shop has already paid its brokers. Without a clear policy, the shop either absorbs the loss or tries to recover it from a broker who has already spent it, and neither feels fair.
Decide the policy in advance and write it into broker agreements: whether clawbacks pass through, in what proportion, and how they are recovered, for example as a deduction from future commissions rather than a demand for repayment. Then record each clawback against the original deal so the statement shows exactly why a deduction appeared.
Commission and clawback terms can raise employment and contract questions that differ by jurisdiction. Have broker agreements reviewed by qualified counsel; this is general information, not legal advice.
Leg 04Statements brokers can check themselves
A commission statement should let a broker verify their pay without asking anyone. That means showing each deal, the funded amount, the commission received by the shop, the split applied, the resulting amount, and any adjustments with their reasons.
When brokers can see their own deals and payouts at any time, the first-of-the-month queue at the office door disappears. Role-based access matters here: brokers should see their own commissions, partners should see deals they referred, and only owners and authorized managers should see everything.
- List every deal funded in the period for the broker.
- Show the shop's commission received on each deal.
- Apply the split recorded on the deal and show the result.
- List adjustments separately, each linked to the deal and reason.
- Total the period and show any balance carried forward.
- Make the statement available to the broker before payday, not on it.
Leg 05Close the period on a fixed schedule
Commission errors tend to compound when periods stay open. A payment arrives late, a deal is reassigned, a split is corrected, and none of it is reflected in the statement that already went out. Pick a cut-off, reconcile commissions received against deals funded, publish statements, and treat anything after the cut-off as an adjustment in the next period.
Reconcile in both directions. Check that every funded deal produced the commission you expected from the funder, and that every commission received maps to a deal. Missing funder payments are common and easy to miss when the only record is a bank deposit.
Leg 06Keep a trail of every change
Splits change. A broker is promoted to a higher tier, a deal is reassigned after the original broker leaves, a manager agrees to share a commission between two people. Each of those changes should be recorded with who made it, when and why.
That trail is what lets you answer the hardest commission question: why was this deal paid this way? FundPilot keeps a full audit trail of changes, so a split edited after funding shows up with its history rather than silently replacing the old value.
Questions from the floor
How should a shop handle commission splits when two brokers work one deal?
Agree a default rule in advance, such as an even split or a split weighted toward the broker who originated the lead, and record it in broker agreements. When a deal is shared, record both names and the split on the deal before it funds. Exceptions should be approved by a manager and logged with a reason so that, months later, anyone can see why the payout was divided as it was.
What is a commission clawback?
A clawback is when a funder reclaims commission it already paid, typically because the merchant defaulted or paid off within a window set in the funder's agreement. Shops then decide, under their own broker agreements, whether and how to pass that recovery on to brokers. Clear written terms and a record tied to the original deal keep clawbacks from turning into disputes.
Should brokers be able to see other brokers' commissions?
Usually not. Commission data is sensitive, and most shops limit each broker to their own deals and payouts, with managers seeing their teams and owners seeing everything. Role-based access lets you enforce that consistently. Openness about how splits are calculated is valuable; access to individual colleagues' earnings is generally not necessary for anyone to do their job.
General information only — not legal, tax or financial advice. Rules for telemarketing, texting, recording, disclosures and data retention vary and change; confirm current requirements with qualified counsel.
Connecting flights