Kayabyte

eBay transaction report to Excel or QuickBooks

By Kayabyte · Last updated 29 October 2026

eBay pays you after taking fees, so your bank deposits do not match your sales. The Transaction report in Seller Hub shows each order, its fees and the payout it belongs to. This guide covers downloading it and getting it into a spreadsheet or QuickBooks. Menu names change, so treat them as a guide.

1. Download the Transaction report

  1. In Seller Hub open the Payments tab, then Reports.
  2. Choose Transactions, set the date range and download the CSV.
  3. eBay limits the range of a single file. Check the limit in your account and download more than one file for a long period.

The file lists the transaction date, order number, buyer, fees, net amount and payout date. Orders, refunds and fees appear as separate row types.

2. Use it in Excel

Open the CSV and add a Category column. Sales and shipping charged are income. Final value fees, fixed fees, and per-order fees are marketplace fees. Promoted listings are advertising. Shipping labels bought through eBay are shipping. Refunds reduce sales. Payouts to your bank are not income. Sum by category with a pivot table, then compare the net with the sum of your payouts.

3. Get it into QuickBooks

The usual approach is a journal entry that moves sales, fees and the payout between accounts, with a clearing account for the eBay balance. QuickBooks Online imports journal entries from CSV in some plans and regions; check the import options under Settings. The structure is: a credit to sales, debits to fee accounts, and a debit to the bank on payout days, with the clearing account balancing the two.

4. Where Balanced helps

Balanced reads the eBay Transaction report CSV on your Mac and gives each row a category by fixed rules: sales, shipping charged, refunds, marketplace fees, advertising, shipping labels, adjustments, payouts. It checks each row’s net against gross minus fees where the file has those figures. Export a categorised CSV or Excel with a summary sheet, a QuickBooks Online journal entries CSV (with a clearing account you name), a Xero manual journal, Beancount or Ledger. Change a category once and it is remembered for that row type.

Honest limits: report layouts change, so check the preview and the category totals; Balanced does not log in to your account or fetch anything, you download the file yourself; the Schedule C worksheet is a suggested grouping, not tax advice, so check it with your tax professional or accountant.

Download Balanced and try it free: the free version reads and checks everything and exports the first 10 lines per file, so you can test your own report before paying. Pro is USD 59 per year or USD 7.99 per month, for up to 3 Macs. See pricing and the help page. macOS 14 or later.