eBay transaction report to Excel

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 Excel, Google Sheets or LibreOffice

Opened in Excel, the report starts with ten lines of notes, uses "--" for every empty cell, and spreads each multi-item order over several lines, so summing a column counts some money twice and misses the fees.

Excel and Google Sheets open a CSV directly, but only if it is a simple table. A bank statement file has to be turned into one first.

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 Excel, Google Sheets or LibreOffice requires

• One row per transaction: Date, Value date, Amount, Currency, Debit/Credit, Counterparty, Counterparty account, Description, Reference, Balance.
• Comma style: commas between columns and 1234.56 amounts. Semicolon style: semicolons and 1234,56 amounts.
• Dates are written as YYYY-MM-DD unless you choose another format.
• Text that starts with = + - or @ gets an apostrophe in front so a spreadsheet does not run it as a formula.

2. Before and after

--,--,--,--,--,--,--,--,--,--,--,--,--
"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"

3. Import the converted file into Excel, Google Sheets or LibreOffice

1. Open the downloaded file in Excel, Google Sheets or LibreOffice.
2. If every value lands in one column, use the semicolon style (for European Excel) or import it with Data > From Text/CSV.

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.

Why does everything land in one column in Excel?

Excel uses the list separator of your computer's region. In much of Europe that is a semicolon and the decimal mark is a comma. Choose the semicolon style and download again, or open the file through Data > From Text/CSV and pick the separator there.

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.

Are accents and umlauts kept?

Yes. The file is UTF-8 and starts with the marker Excel looks for, so names such as Müller or Société open correctly.

Other ways to convert eBay transaction report

• eBay transaction report to a QuickBooks journal entry
• eBay transaction report to Xero
• eBay transaction report to a QuickBooks Online bank CSV

Other exports to Excel (CSV)

• Amazon settlement report to Excel
• Convert an MT940 file to Excel
• Convert a camt.053 file to Excel