Think Build Implement Repeat
London, UK +44 7367 067226
WhatsApp FOLLOW f in X
  1. Home
  2. Blog
  3. How Do We Reconcile the Commission We Charged Suppliers Against What Was Actually Sold, Refunded and Paid?
Problems We Solve

How Do We Reconcile the Commission We Charged Suppliers Against What Was Actually Sold, Refunded and Paid?

B2B marketplaces struggle to reconcile commission once refunds, credits and fee changes pile up. We build a monthly commission ledger that ties to every order.

Updated 3 min readBy SpiderHunts Technologies

Free estimateNo obligation

Get a free estimate

Tell us what you need. A senior engineer reads every enquiry.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →

Quick answer — TL;DR

Commission reconciliation goes wrong because commission is calculated at order time, but refunds, partial credits, cancelled lines, category rate changes and negotiated supplier rates all change what should have been charged. We build a commission ledger that recalculates each order's commission from its final state and your rate rules, compares it with what was deducted or invoiced, and lists every difference with its cause.

The supplier who says you overcharged

A supplier emails their account manager with a spreadsheet. By their calculation, you took more commission last quarter than their agreement allows. Some of it is refunds: orders were refunded in full, but the commission deducted from their payout was never returned. Some of it is a category they were told would be charged at a lower rate. Some of it is their own mistake. Your finance team has to go through it order by order to find out which.

At the same time, your own management accounts show commission income that does not quite match what the payment provider reports. Nobody is sure why.

Why commission drifts from what it should be

Commission looks simple: a percentage of each sale. In a B2B marketplace it rarely is. Rates vary by category and sometimes by supplier. Some suppliers have negotiated rates or promotional periods. Delivery charges may or may not attract commission. Orders change after they are placed: lines cancelled, quantities reduced, partial refunds, credits for damaged goods.

The commission is usually calculated once, at order or dispatch, and deducted from the supplier payout. Later changes are handled by whoever processes them, in whatever way they think is right.

Event after the orderCommission question
Full refundIs commission returned to the supplier?
Partial creditIs commission adjusted proportionally?
Cancelled line before dispatchShould commission ever have been taken?
Rate change mid-periodWhich rate applies to which orders?
Supplier-specific rateWas it applied, and from when?

What commission drift costs

Overcharging suppliers damages trust and invites disputes that take hours to resolve. Undercharging is income you are entitled to and never collect. Commission income in your accounts that cannot be tied back to orders makes reporting and forecasting unreliable. And when a supplier challenges a statement, answering takes days.

The commercial team loses out as well. Decisions about category rates, supplier deals and promotional periods are made without a clear view of what commission they actually produced after refunds and credits. A rate cut to win a large supplier may look affordable on gross sales and much less so on the final numbers.

The commission ledger we build

  1. Rate rules: commission rates by category, supplier agreement, period and charge type are held as data with effective dates, maintained by your commercial team.
  2. Order final state: each order's final state is built from the platform and payment provider, including cancellations, partial refunds and credits.
  3. Recalculation: expected commission is recalculated per order line from the final state and the rules that applied on the relevant date.
  4. Comparison: expected commission is compared with what was actually deducted from payouts or invoiced to the supplier, through your payment provider, such as Stripe Connect, and your accounts package.
  5. Differences: each difference is listed with its cause, such as refund not reversed or wrong category rate, and corrections are drafted for your finance team to approve as adjustments on the next payout or as credit notes.
  6. Supplier statements: suppliers receive a monthly commission statement by order, so they can check it themselves.

How commission applies to refunds and credits is set by your supplier agreements. The ledger applies whatever those agreements say, consistently.

Month end with the ledger

Finance reviews a list of differences with causes, rather than rebuilding commission from order exports. Supplier queries are answered from the statement. Commission income in the accounts ties back to orders, and the commercial team can see the effect of rate changes and negotiated rates on real sales.

Does commission cause arguments here?

  • Suppliers have challenged commission on their statements.
  • Refunded orders do not always have commission reversed.
  • Supplier-specific rates are applied by hand.
  • Commission income does not match the payment provider's reports.
  • Answering a supplier query takes days of spreadsheet work.

FAQ

Frequently asked questions

The questions readers ask us after this guide.

Still have a question?

Ask us directly — a senior engineer will get back to you.

Ask about your project

Does this replace our payment provider's fee handling?

No. The provider still processes payouts and deductions. The ledger checks them against what your rules say should have happened.

Can it correct past periods?

It can recalculate past periods from order history and list differences. Whether and how to correct them is your decision.

What if our supplier agreements are not consistent?

That is common. Each agreement's terms are recorded as rules, and unclear terms are flagged for your commercial team to decide.

Which platforms and payment providers does this work with?

Any with order and payout data available by API or export, including Stripe Connect and most marketplace platforms.

Keep reading

More on Problems We Solve

Start here

Tell us where money and data get tangled on your marketplace

Describe your marketplace, how buyers pay, how suppliers get paid and the platform and finance tools you use. We will tell you what we would build, what needs your finance team's judgement, and if your platform or payment provider already covers it, we will say so.

  1. You tell us what you needTwo minutes on the form, or a message on WhatsApp.
  2. A senior engineer reviews itAnd comes back with questions, a realistic range and an honest view on fit.
  3. Free 30-minute scoping callWe talk through scope, options and a realistic estimate — with no obligation.
Free estimateNo obligation

Talk to someone who builds this

Send a short brief and we will come back with an honest view and a realistic range.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →