BooksReady

eBay transaction report to a QuickBooks Online bank CSV

In short: eBay's transaction report is a CSV from Seller Hub with about ten lines of notes above the header, "--" in empty cells, one line per order, refund, fee, label, hold and payout, and a Payout ID on every line that has been paid out. QuickBooks Online imports bank CSV files with exactly 3 columns (Date, Description, Amount) or 4 columns (Date, Description, Credit, Debit), one header row and one date format throughout. Drop the file below. It is converted on your device and never uploaded.

Before you start: Upload this into a separate "eBay" clearing account in QuickBooks, not your checking account: each payout line moves the money out to your bank. We have not imported the result into a real QuickBooks company.

Convert your file

eBay transaction report to QuickBooks Online (CSV)

Transaction report .csv from Seller Hub

Your file stays on this device

It is read and converted by this page, inside your browser. Nothing from the file is uploaded, and the converter keeps working offline once the page has loaded.

One email when it ships. The address is used for nothing else. Details.

1. Export the file from eBay Seller Hub

  1. In Seller Hub open the Payments tab and select Reports in the menu on the left.
  2. Select Transaction report in the download section, choose the transaction type (all types) and the start and end date, then select Create report.
  3. eBay emails you when the report is ready. Download the CSV and upload it here as it is, without opening and re-saving it in a spreadsheet.

Why a raw eBay transaction report export fails in QuickBooks Online

QuickBooks Online cannot read the notes above the header, "--" in empty cells or amounts like "1,076.42", and a multi-item order has its money on one line and its fees on others. Imported into checking, nothing would match the payouts in your bank feed.

QuickBooks Online maps the first row as column names and expects every following row to be a transaction. Extra header lines, balance and total rows, currency symbols, and cells that contain only zero are common reasons an upload fails or imports wrong amounts.

What is unusual about the eBay transaction report file

  • About ten lines of notes come before the column header, and empty cells are written "--". Dates look like May 20, 2026 (eBay.com) or 24 Sept 2026 (eBay.co.uk).
  • An order with several items has one order line with the Net and Gross amounts and one line per item with that item's fees; they are read together so nothing is counted twice.
  • Each payout becomes its named lines (item sales, shipping, refunds, final value fees and each other fee type, promoted listing fees, shipping labels, claims, holds) plus the payout, all dated on the payout date.
  • The lines of each payout are added up and compared with its Payout row. If they differ, you get a warning with the difference; it is never hidden.
  • Rows that are not part of a payout yet (no Payout ID) are left out and counted in a note. eBay collected tax is not in your payouts, so it is not booked.
  • Net amounts are in the payout currency, gross and fees in the sale currency: an order in another currency is booked at its converted Net only, on its own line. One currency per output.
  • The German eBay.de report and the payout report are refused by name: download the English transaction report instead.
  • Bank-style files (.qbo, .qfx, .ofx, QuickBooks Online CSV, Xero CSV) go into a separate eBay clearing account, not your checking account: each payout's last line moves the money to your bank.

What QuickBooks Online requires

  • Columns exactly Date, Description, Amount.
  • Money in is positive, money out is negative; no currency symbols or thousands separators.
  • One date format for the whole file.
  • Up to 1,000 rows and 350 KB per upload (we split bigger files).

2. Before and after

Before: the eBay transaction report CSV as downloaded

--,--,--,--,--,--,--,--,--,--,--,--,--
"Notes"
"Gross transaction amount: The total payment for a transaction before any fees or credits are applied."
"Gross transaction amounts and fees are listed in the transaction currency. Net amounts are listed in the payout currency."
"All fee amounts shown include taxes."
""
"Transaction report"
"This report includes transaction type","order, refund, claim, payment dispute, shipping label, charge, transfer, hold, other fee, adjustment, purc...
"Seller","synthetic_seller"

After: what QuickBooks Online receives

After: ebay-2025-10-10-to-2025-10-17-quickbooks-3col.csv
DateDescriptionAmount
10/10/2025eBay payout 6000000001: Item sales137.76
10/10/2025eBay payout 6000000001: Shipping charged to buyers30.05
10/10/2025eBay payout 6000000001: Refunds to buyers-30.00
10/10/2025eBay payout 6000000001: eBay final value fees-13.88
10/10/2025eBay payout 6000000001: eBay international fee-5.40
10/10/2025eBay payout 6000000001: Shipping labels bought on eBay-8.25

Synthetic sample data that follows the real export layout, not a real account. The "after" output was produced from it by the same converter this page runs.

3. Import the converted file into QuickBooks Online

  1. Go to Transactions > Bank transactions > Link account (or Update) > Upload from file.
  2. Choose this CSV and the account to put it in.
  3. Map the columns: Date to Date, Description to Description, Amount to Amount (one column).
  4. Pick the date format MM/dd/yyyy (or the one you chose here) and confirm that the first row is a header.
  5. Review the transactions under For review.

Questions

Does each journal entry match my eBay payout?
Yes, when the report covers all of the payout. The converter adds the lines that carry each Payout ID and compares them with that payout's own Payout row. The bank line uses eBay's payout amount; if the lines add up to something else, a warning names the difference and the gap goes to the clearing account.
Should I choose 3 columns or 4 columns?
Both import the same transactions. The 3-column file has one signed Amount, negative for money out. The 4-column file splits money in (Credit) and money out (Debit) and leaves the unused side blank, which is what Intuit asks for. Use 3 columns unless your accountant prefers the other; switch "To" in the converter to get the 4-column file.
What happens to sales that have not been paid out yet?
Lines without a Payout ID (on hold or still processing) are left out and counted in a note. Download a later report and they come in with their payout.
Why does QuickBooks reject my file as too large?
Intuit documents a limit of 350 KB and 1,000 lines per manual upload in QuickBooks Online. When your converted file is bigger, the converter also gives you numbered parts that each fit; upload them one after another.

Other ways to convert eBay transaction report

Other exports to QuickBooks Online (CSV)

Common import problems