Marketplace payout reconciliation for online sellers

Key takeaways

Marketplace payout reconciliation matches each payout from Amazon, eBay, Etsy, Shopify Payments, Stripe or PayPal to the orders, fees, refunds and adjustments behind it, and to the amount that reached the bank. Payouts are net figures, so without this routine sales, fees and refunds are misstated. A weekly routine keeps it manageable.

• Payouts are net: sales minus fees, refunds and holds.
• Reconcile each payout to its settlement report weekly.
• Record gross sales and fees separately.
• Investigate unexplained differences within the week.

Why are marketplace payouts hard to reconcile?

Each payout bundles many orders with fees, refunds, reserves, advertising charges and adjustments, and each platform reports them differently. The bank shows one figure. Posting that figure as sales understates revenue and hides fees, which distorts margins and VAT records. Your accountant should confirm how platform fees and VAT are treated.

• How UK SMEs can use outsourcing to handle repetitive tasks
• Bank reconciliation outsourcing: daily, not month-end

What does the weekly routine involve?

Download each platform's settlement or payout report, split it into gross sales, fees, refunds and other adjustments, post those to the right accounts, and match the net payout to the bank. Check refunds against your returns log and investigate any line you cannot explain.

• Download settlement reports for each platform.
• Split gross sales, fees, refunds and adjustments.
• Match the net payout to the bank receipt.
• Check refunds against returns received.
• Log and query unexplained lines.

• Refund processing: fast, fair and correctly recorded
• Returns processing cost: what each return really costs you

What does it take in time?

In an illustrative example, a seller with four channels and 1,500 orders a month spends about 6 to 8 hours a month reconciling, more when refunds or disputes spike. These are example figures. The time grows with channels and exceptions rather than orders, which is why sellers adding a new marketplace often fall behind.

• Chargeback disputes: gather evidence and respond on time
• Marketplace listing management: Amazon, eBay and Etsy

When should you not outsource it?

Keep it in-house, or with your accountant, while the treatment of fees, VAT and multi-currency payouts is still unsettled. A team can run the routine well once the posting rules are written. Very small sellers on one platform may find their accounting software's integration enough.

• Doing your own bookkeeping: what it really costs

What does this look like in practice?

A pattern we see: a seller's accounts show strong sales and thin margins nobody can explain, because platform fees were netted off sales. Splitting fees out each week shows which channel actually makes money.

• See client work
• BPO Solutions for UK businesses

Payout reconciliation checklist

Set up the routine with these points.

• Posting rules agreed with your accountant.
• One reconciliation per payout, every week.
• Fees recorded by type and channel.
• Refunds matched to the returns log.
• Unexplained differences cleared within the week.

• Making Tax Digital records: the weekly routine that helps

Next step

Tell us which platforms you sell on and how payouts are recorded today. We will say plainly what a weekly reconciliation would involve and what to agree with your accountant first.