The short answer

If the payout was recorded correctly first, Xero reconciliation should usually be a bank-match problem, not a sales problem. Match the net bank receipt to the payout entry, then investigate any difference by checking timing, missing adjustments, duplicated entries, or the wrong bank line.

What this page covers

This page assumes the payout breakdown already exists in Xero. It only covers matching the payout to the bank feed, diagnosing failed matches, and fixing common reconciliation errors.

Before you click reconcile

  • confirm there is one payout record in Xero for the same net amount you expect to hit the bank
  • check the payout reference, date, and net amount in Seller Hub or the payout report
  • make sure fees, refunds, and adjustments were posted before you try to match the bank line
  • use the operational posting step from how to record eBay payouts in Xero if the payout has not been built yet

Why the bank match fails

  • the payout was posted at the wrong net amount
  • a refund, charge, or other adjustment was missed
  • you are looking at the wrong eBay deposit because several receipts landed close together
  • a duplicate manual entry or earlier bank match is still sitting in Xero
  • the payout genuinely differs from gross sales, which is normal and explained in why eBay payouts don't match your sales

How to fix common mismatches

  1. Start with the bank amount, not the sales report.
  2. Find the exact payout in eBay using the reference, date, and net amount.
  3. Compare that payout's net amount with the Xero entry already waiting to be reconciled.
  4. If the net is wrong in Xero, correct the missing fee, refund, or adjustment inside the payout record.
  5. If the net is right in Xero but it still will not match, check for duplicate entries or a prior manual reconciliation against the same bank line.
  6. Only reconcile once the Xero net amount and the bank receipt agree.

Example

The bank feed shows EBAY Commerce UK Ltd P*7348003 for £680.90, but Xero only has £705.90 ready to match. The quickest explanation is usually that something inside the payout is missing from Xero. If a £25 refund was missed, correct the payout entry first, bring the net back to £680.90, then match the bank line.

Where this goes wrong

  • reconciling the bank line straight to Sales instead of to the prepared payout transaction
  • comparing the bank receipt with gross order totals rather than the payout reference
  • forcing a manual adjustment on the bank line when the real problem is a missing payout component
  • posting a second journal instead of correcting the original payout record
  • clearing the difference without leaving a trail your accountant can follow later

Related topics