Why your marketplace payouts never match your sales report

Almost every business selling through a marketplace has a version of this problem. The platform says it paid one figure, your own records say you sold another, and closing the gap is a monthly job someone does by hand and nobody enjoys.

It is worth doing properly, because this is one of the few reconciliation exercises that regularly finds money. Not through anyone's fault — through structure.

Payouts are periods, sales are events

A sale happens on one date. A payout covers a window and arrives later, often well after the service date. Any comparison that lines up a month of sales against a month of payouts is comparing two different sets.

Reconciliation has to work at the level of individual transactions, matched by reference, and then roll up. Comparing totals only tells you that there is a difference, not where it is.

Fees and adjustments are deducted before you see it

Commission, payment fees, and currency conversion all sit between the customer's price and your bank. So does anything the platform has adjusted: a partial refund, a chargeback, a promotional contribution, a correction to an earlier period.

Adjustments relating to an earlier period are the single most common reason a careful reconciliation still fails. The payout you are checking may contain items that have nothing to do with the window you are checking.

Cancellations move in both directions

A cancellation after a payout has been made comes back as a deduction later. If your sales report excludes cancellations but your payout reflects them as negatives, the two will never agree — and the shape of the disagreement changes every month.

Worth noting too: a cancelled sale is not always a neutral event. Where you have already committed a supplier cost, the net effect can be worse than simply not having made the sale, and reports that exclude cancellations hide that entirely.

The same sale can appear more than once

Where inventory is resold, a single customer transaction can show up as more than one record — your sale and the supplier side of it. Counting both inflates revenue and makes margin look better than it is.

Any reconciliation needs an explicit rule for which record is the sale and which is the cost, rather than treating every row as income.

Build it to surface differences, not absorb them

The useful output is not a single reconciled total. It is a list: matched transactions, unmatched payout lines, unmatched sales, and anything where the amount differs by more than a tolerance you have chosen deliberately.

Then the monthly job becomes reviewing a short exception list rather than rebuilding the comparison from scratch. That is also how you find the items worth chasing — a sale paid at the wrong rate, a refund deducted twice, a booking that was cancelled but still charged.

Put the supplier cost in the same place

Reconciling revenue against payouts tells you what you received. It does not tell you whether the business is profitable, because that needs the cost of delivering each sale next to it.

Getting bookings, payouts, fees, and supplier invoices into one view is more work than checking a payout, and it is usually the piece that changes decisions. It is common for it to show that a channel or a product is doing considerably better or worse than assumed.