Why Your Marketplace Payouts Never Match Your Sales Report

Your sales report says one number. Your bank says another. The difference is large, it changes every period, and nobody can explain it in a sentence.

This is the single most common reconciliation problem in e-commerce finance, and it’s rarely written about properly — most search results are forum threads where someone asks and nobody quite answers. So here is the full explanation: everything that sits between a marketplace sale and the money arriving, and how to reconcile it without doing it by hand every month.

The gap, quantified

Take a simple case. In a given settlement period you sold £10,000 gross on a marketplace. Here is roughly what arrives:

Gross sales	£10,000
Referral / commission fees	−£1,200
Fulfilment fees	−£900
Refunds issued	−£450
Refund fee retention	−£25
Advertising charges	−£600
Storage fees	−£140
Reserve held	−£800
Net deposit	£5,885

Roughly 59% of gross. The exact figures vary enormously by category, marketplace, and fulfilment model — these are illustrative, and you should pull your own from a real settlement report rather than trusting any published average, including this one.

But the shape holds. The deposit is typically somewhere between 55% and 75% of gross sales, and the variance between periods is what makes it feel unpredictable.

Every deduction, itemised

Referral or commission fees. A percentage of the sale price, varying by product category. This is usually the largest single deduction and the most predictable. Worth checking annually — category rates change, and a product recategorised by the marketplace moves to a different rate without announcement.

Fulfilment fees. If the marketplace fulfils, you pay per unit based on size and weight bands. Products near a band boundary are worth watching: packaging that grows by a few millimetres can push a unit into the next band and change its economics.

Refunds. The refunded sale value comes back out. Straightforward in principle, awkward in practice because the refund frequently lands in a different settlement period from the original sale.

Refund administration fees. Many marketplaces retain a portion of the original referral fee when an order is refunded. Small per instance, meaningful at volume, and almost always missed in manual reconciliation.

Chargebacks. Disputed transactions, usually with a fee attached on top of the reversed amount. These arrive weeks or months after the original sale.

Advertising. Sponsored placements are commonly deducted from settlements rather than billed separately. This is a frequent source of confusion — advertising spend appears as a reduction in your sales deposit rather than as an expense you paid.

Storage fees. Monthly, based on volume held. Long-term storage surcharges on slow-moving stock can be substantially higher and appear irregularly.

Reserves. The marketplace holds back a portion of your funds against future returns and disputes. Reserves are released later, which means money you earned this period arrives in a subsequent one, and the reserve balance itself moves independently of your sales.

Currency conversion. Selling across borders adds a conversion spread, applied at the marketplace’s rate, on the marketplace’s timing.

Adjustments. A catch-all line for corrections, goodwill credits, and lost-inventory reimbursements. Small, frequent, and rarely categorised properly.

Why timing makes it worse

Even if you understood every deduction perfectly, the timing would still break simple reconciliation.

Settlement periods don’t align with calendar months. A fortnightly settlement cycle straddles month ends. Part of your March sales settle in April, and your March deposit includes February sales.

Refunds lag sales. A refund in April against a March sale reduces April’s deposit for revenue recognised in March.

Reserves move independently. A rising reserve balance reduces deposits without any change in sales. A falling one inflates them. Neither reflects trading performance.

Advertising has its own rhythm. Campaign charges accumulate continuously and are deducted at settlement, so a heavy promotional week shows up as a smaller deposit in a period that may not be the one where the sales landed.

The combined effect is that comparing this month’s deposit to this month’s sales is comparing two things that describe different time windows. They will never match, and no amount of care makes them match — the fix is to reconcile at the transaction level, not the period level.

Why manual matching fails at volume

The structural problem is that settlements are many-to-one. One deposit covers hundreds or thousands of orders, each with its own fees, and the marketplace gives you a settlement report rather than a per-order breakdown of the deposit.

Matching by hand means taking the settlement report, exploding it into components, and tying each back to an order. For fifty orders that’s an afternoon. For five thousand it isn’t a task, it’s a role — and the version people actually do is to book the net deposit as revenue and move on.

That shortcut has a specific cost. Revenue is understated by the fee amount, fees never appear as expenses, and channel profitability becomes uncomputable, because you no longer know what any individual sale actually earned.

What good reconciliation does

The mechanics are the same whether you build it or buy it:

Decompose the settlement. Take the settlement report and split it into its component types — sales, each fee category, refunds, adjustments, reserve movement — as separate lines rather than one net figure.

Match components to orders. Tie each fee and refund back to the order that generated it, so the true net proceeds of every individual sale are known.

Post gross, not net. Revenue recorded at gross sale value, each fee category recorded as its own expense account. Your P&L then shows what you actually sold and what the channel actually cost — two figures that are invisible when you book the deposit net.

Handle the reserve as a balance. A reserve isn’t an expense; it’s your money held elsewhere. It belongs on the balance sheet, and treating it as a deduction from revenue misstates both.

Flag what moved. Fee rates change. Categories get reclassified. A fulfilment fee that rises 4% affects every unit of that product from then on. Detected in the week it happens, it’s a pricing decision; detected at year-end, it’s a loss.

A monthly check

If you do nothing else, compare these three figures every period:

1. Gross sales from your channel reports
2. Total deductions from your settlement reports, by category
3. Net deposits into your bank

Figure 1 minus figure 2 should equal figure 3, allowing for reserve movement and timing at the period boundary. If it doesn’t, the gap is either a missing deduction category or a timing difference — and knowing which is most of the diagnosis.

Then track deductions as a percentage of gross sales, by category, month over month. That single table surfaces fee changes, advertising creep, and rising refund rates earlier than anything else, because each of those shows up as a percentage moving before it shows up as a number that looks wrong.

---

AI Reconciliation decomposes settlements automatically and matches every component back to the orders that produced it. E-Commerce Integration is where the channel data comes from.

Contact us today to talk through how your marketplace payouts actually break down.