1. Your eBay report
The Transaction report CSV from Seller Hub (Payments > Reports > Downloads). The few lines above the header are skipped. More than one payout per file is fine.
Choose a file or paste the text, then click Read, check and build journals.
Result
Deposit check
| Payout | Payout date | eBay states | Journals clear | Agrees |
|---|
Journals
| Journal | Date | Account | Debit | Credit | Memo |
|---|
Download
The accounts must already exist in your software under these names or codes. Post the journals, then match each bank deposit to eBay clearing.
The model, and what it leaves out
- Rows: each row is one money movement with a Type (Order, Shipping label, Refund, Other fee, Claim, Hold, Payout), a Net amount, and for orders the item subtotal, shipping, seller-collected tax and each fee column. Rows are grouped by Payout ID. Dates like "Sep 28, 2026" and amounts like 1,234.56 or 1.234,56 are read. "--" means nothing.
- Payout check: the signed nets of a payout's rows must add up exactly to the Payout row. If the file has none (a report cut by date), type the deposit from your bank into the optional box. If they do not agree, the page says by how much, and you should not post the journal. An order whose subtotal, shipping, tax and fees do not add to its net is flagged too.
- Categories: an order is split into item sales, shipping income, sales tax you collected and fees; shipping-label rows to labels; refunds to refunds; Promoted Listings to advertising; insertion, upgrade and store fees to listing fees; claims and disputes to disputes; holds, reserves and adjustments to adjustments. A row no rule recognises goes to an uncategorised account and is listed.
- Month split: rows are grouped by Transaction creation date. A journal is dated the month end, or the payout date for the last month. Each balances to eBay clearing, so the clearing account holds exactly the part of the payout that belongs to that month.
- Not checked: that the report agrees with your Seller Hub dashboard or your books, tax treatment anywhere (tax eBay collects for the marketplace is not in your net and is left out), currency conversion between sale and payout, and that the accounts exist in your software.
Common questions
How do I turn an eBay payout into a journal entry?
Download the Transaction report from Seller Hub (Payments > Reports > Downloads), paste it here and press Read, check and build journals. The page adds up every row of each payout, checks the total against the Payout row, groups the rows into item sales, shipping income, sales tax, final value fees, Promoted Listings, insertion and store fees, shipping labels and refunds, and writes a journal that balances to an eBay clearing account.
Why book gross sales and fees instead of the bank deposit?
An eBay payout is net of final value fees, ads, shipping labels and refunds. Booking only the deposit as income understates revenue and hides what eBay costs you, and a payout that spans two months pushes one month's sales into the next. This page books each category separately, in the month it happened, and the bank deposit clears the eBay clearing account.
What is the eBay clearing account?
A holding account. Each journal debits or credits it with that period's net, and the bank deposit, when it arrives, is matched against it. When every payout is journalled and deposited, the clearing account returns to zero, which is the cheap proof that nothing was missed.
Which accounting software can I import to?
Xero (manual journal CSV), QuickBooks Online (journal entry CSV), QuickBooks Desktop (IIF general journal) and a plain CSV for anything else. You can rename the accounts for each category before downloading so they match your chart of accounts.
What does the page do with rows it does not recognise?
It never drops them. They are journalled to an uncategorised account so the journal still equals the payout, and listed so you can review them.
Is it safe to paste an eBay report into a web page?
The page runs in your browser, the report is read locally and nothing is uploaded; a test in the code asserts there are no network calls. The report carries buyer usernames and ship-to cities; remove those columns if you would rather not have them on screen, because the page only needs the dates, types, amounts, descriptions and payout IDs.
What does this not check?
Whether the report matches your Seller Hub dashboard or your books, tax treatment in any jurisdiction (tax collected by eBay for the marketplace is not paid to you and is left out; tax you collect is booked to a payable account, not filed), currencies converted between sale and payout, and account names or codes that must already exist in your accounting software.