How to Export eBay Payouts to CSV (UK Seller Guide)

If you sell on eBay UK, eBay sends money to your bank in batches called payouts. Each payout bundles dozens of individual transactions — sales, refunds, fees, ad spend, adjustments — into one bank deposit. When you sit down to reconcile your bank statement or file Self Assessment, you need to turn that bundle back into something a spreadsheet can deal with.

This guide explains the two ways to do it: the manual Seller Hub route, and a one-click export using clearpence.

Why eBay payouts are awkward

eBay processes payouts on a schedule — usually daily once your account is established, weekly for newer sellers. Every payout is a net figure: gross sales, minus fees, minus refunds, minus ad spend, plus any adjustments. When £312.84 lands in your business bank account on a Tuesday, the actual breakdown might be £370 of sales, £42 of final value fees, £15 of promoted listings, and £0.16 of regulatory operating fee.

Seller Hub does show this information, but in a layout that mixes every transaction type into one long list. There isn’t a built-in view that gives you one row per payout with the linked transactions underneath. For sellers doing more than a handful of transactions a week, reconciling manually starts taking hours each month.

Method 1 — the manual Seller Hub route

If you only need to do this once or twice a year, you can do it without any extra tools. The steps:

  1. Sign in to Seller Hub and open the Payments tab.
  2. Switch to the Reports section and pick Payouts.
  3. Set your date range — eBay caps these views at 90 days at a time, so for a full tax year you’ll need to run the export four times and concatenate the files.
  4. Click Generate report. The file shows up under the requested reports list after a few minutes.
  5. Download the CSV and open it in Excel or Google Sheets. You’ll usually need to clean up the date format and re-sort by payout date before it’s useful.

This works. The catch: you still have to manually match each payout to the transactions inside it, because the Seller Hub export doesn’t link them. If you want the bank-reference column for reconciliation, you’ll have to look that up separately and paste it in.

Method 2 — one-click CSV with clearpence

clearpence is a Chrome extension built specifically for UK eBay sellers. It uses eBay’s official Finances API, so the data is the same data eBay’s own Seller Hub reports use — just exported in a layout that’s actually useful for bookkeeping.

The steps:

  1. Install clearpence from the Chrome Web Store and click Connect eBay Account in the popup.
  2. eBay’s own OAuth screen opens — you sign in on eBay (clearpence never sees your password) and grant read-only access to your sales data.
  3. Back in the popup, pick a date range (last 30 days, this month, last month, UK tax year, or custom) and click Export Payouts CSV.
  4. The CSV downloads in seconds. One row per payout, with the payout date, total amount, bank reference, status, and a count of the transactions inside.

On the Pro plan, the payout export also includes full reconciliation — for each payout you can drill into the underlying transactions, see the gross/fees/net breakdown, and the tool flags any discrepancy between what eBay said the payout was and what it actually paid into your bank. That’s the bit that catches the rare missing or held transaction.

Which columns you get

The clearpence payout CSV is deliberately narrow — one row per payout, with only the columns you actually need for reconciliation:

  • Payout date — DD/MM/YYYY in the UK accountant template.
  • Payout amount — GBP, what landed in your bank.
  • Bank reference — the exact string eBay sends with the deposit, so you can match it on your statement.
  • Status — paid, in progress, returned, etc.
  • Transactions — how many individual sales/fees/refunds went into the payout.
  • Currency — almost always GBP for UK sellers, but worth keeping in case you’ve had a cross-border sale.

If you want the underlying transactions on a row each, use the transaction history export instead. The two views complement each other: payouts for reconciling your bank, transactions for the deep detail.

Common reasons UK sellers export payouts

  • Self Assessment. HMRC wants your turnover and expenses for the tax year. A clean payout list is the simplest way to show net income, and pairs with the fee export for the expense side. See the Self Assessment guide for what to file and when.
  • Bank reconciliation. Match payouts row-by-row against your business bank statement. Cleaner than Seller Hub, no spreadsheet surgery required.
  • Bookkeeping without Xero/QuickBooks. If you’re running a small operation on spreadsheets, the payout CSV is the missing source-of-truth file. See bookkeeping without an accounting platform.
  • Handing data to an accountant. Most accountants want payouts + fees + transactions, in CSV form, with UK dates. The accountant template gives you exactly that.

FAQs

How far back can I export eBay payouts?

eBay’s Finances API exposes payouts going back roughly three years (around 36 months). The free clearpence tier covers the last 30 days; Pro extends to the full history eBay still holds.

Do the exports include the bank reference?

Yes. Each payout row includes the payout ID and the bank reference eBay sends with the deposit, so you can match a row in your bank statement to a specific eBay payout without manual hunting.

Will this work for eBay UK only?

clearpence is built specifically for the EBAY_GB marketplace. Amounts come back in GBP and the accountant template uses DD/MM/YYYY dates.

Is this safer than scraping Seller Hub?

Yes. clearpence uses eBay’s official OAuth flow and the read-only Sell APIs — eBay sees it as a normal authorised consumer making API calls on your behalf. There’s no scraping, no automation against your seller dashboard, and no risk of being flagged.

clearpence is an independent tool and is not affiliated with eBay Inc. eBay is a registered trademark of its owner.