eBay Bookkeeping Export for UK Sellers

If you are a UK eBay seller who does their own bookkeeping — or sends records to an accountant — you know the pain of eBay’s default exports. The data is there, but it is not in a format anyone would call “bookkeeping-ready.”

What accountants actually need

When a UK accountant asks for your eBay records, they typically want:

  • One row per transaction — sales, refunds, and credits as separate line items
  • Clear date column — ideally DD/MM/YYYY for UK, or at minimum a sortable YYYY-MM-DD
  • Transaction reference — an order ID or transaction ID they can cross-reference
  • Gross amount, fees, and net — as separate columns, not combined
  • Item description and SKU — for categorisation

Seller Hub exports give you none of this cleanly. You get a jumble of columns with inconsistent formatting that requires manual cleanup before any accountant will touch it.

The bookkeeping template

Our bookkeeping export template is designed to produce exactly what is described above, with zero manual editing:

Bookkeeping template — clean, sortable, one row per transaction.
DateTypeOrder IDItemSKUQtySale AmountFeesNet Amount
25/03/2026SALE12-09876-54321Vintage Penguin Paperback - Orwell 1984BK-ORW-19841£14.50-£2.18£12.32
26/03/2026SALE12-09876-54322Royal Mail Stamps Edward VII CollectionSTMP-EDV-0021£62.00-£8.68£53.32
27/03/2026REFUND12-09876-54310Tea Set, Royal Albert Old Country RosesRA-OCR-0061-£48.00£6.72-£41.28
28/03/2026SALE12-09876-54325Hornby OO Gauge Class 47 LocomotiveHRN-C47-0121£89.99-£12.60£77.39
29/03/2026SALE12-09876-54330Pokémon TCG Charizard Holo PSA 8PKM-CHZ-PSA81£180.00-£25.20£154.80

Key design decisions:

  • YYYY-MM-DD dates for easy sorting in any spreadsheet
  • Only sales, refunds, and credits — internal adjustments and holds are filtered out
  • Net Amount = Sale Amount + Fees (fees are negative, so it is effectively subtraction)
  • SKU and quantity columns for inventory-based sellers

The accountant template (Pro)

For sellers who send data directly to their accountant, the Pro plan includes an Accountant template with:

  • DD/MM/YYYY dates (UK standard)
  • Transaction references for cross-referencing
  • Truncated descriptions (80 characters) for cleaner spreadsheets
  • A VAT Note column (ready for future VAT reporting features)
  • Gross, fees, and net as clearly labelled separate columns

Why this matters for HMRC

If your eBay income exceeds the trading allowance (currently £1,000), you need to declare it. Clean records make self-assessment much easier and reduce the risk of errors. Even if you use an accountant, giving them clean data saves time — and accountant time costs money.

How to get started

  1. Install the eBay Seller Reports Chrome extension (free)
  2. Connect your eBay UK seller account
  3. Select the Bookkeeping template (or Accountant template on Pro)
  4. Choose your date range and export type
  5. Download — the CSV opens cleanly in Excel, Google Sheets, or any spreadsheet tool

The CSV includes a BOM marker for proper UTF-8 handling in Excel, so special characters in item titles display correctly.