How to import an eBay Transaction Report into QuickBooks Online

Why a bank-import CSV doesn't work for an eBay Transaction Report

QuickBooks Online's bank-import tool expects a flat list of Date, Description, Amount rows — fine for a PayPal or Shopify payout, where money mostly just moves in or out. An eBay Transaction Report is different: it bundles many different things - order revenue, Final Value Fees (split into a fixed and a variable component), international fees, performance-penalty fees, shipping labels, store subscription and Promoted Listings charges, refunds, and several separate payouts to your bank - and treating a payout line as one "Sales income" entry hides every fee as if it never happened. Getting this right means a balanced double-entry journal entry that splits the report back into its real pieces, not a transaction list.

Option 1: Build the journal entry by hand

Free, but easy to get wrong — and QBO won't tell you if it's wrong.

1. In Seller Hub, go to Payments → Reports, choose Transaction report, pick your date range, then Generate CSV and Download once it's ready.
2. Every row carries a Type (Order, Refund, Shipping label, Other fee, Charge, Payout) plus a Net amount column - the Type tells you which account the line belongs to, and Net amount is the row's overall signed effect on what eBay is holding for you. Every row also carries the Payout ID and Payout date of the payout it ended up in.
3. Make one journal entry per payout, not one for the whole report. Group the rows by Payout ID and date each entry on its payout date. That way each entry's bank line equals exactly one deposit in your QuickBooks bank feed, so you can match it. One lump entry for the period can't be matched to the separate deposits your bank actually received.
4. Group by payout, not by order: eBay sometimes takes a fee (a Promoted Listings fee, say) out of a different payout than the sale it belongs to. Following the Payout ID keeps every entry equal to the real deposit.
5. For Order rows, eBay gives you an itemized breakdown on the same line: credit Sales Income: eBay Sales for Item subtotal plus Shipping and handling, then separately debit eBay Selling Fees: Final Value Fees for the fixed and variable Final Value Fee columns. Sales tax eBay collected is shown on the row but isn't yours - leave it out.
6. Debit eBay Selling Fees: International Fees for any International fee column, and eBay Selling Fees: Other Selling Fees for performance-penalty and regulatory fee columns.
7. Debit Shipping Expenses: eBay Shipping Labels for "Shipping label" rows (a voided label comes back as a positive amount - credit it), and eBay Selling Fees: Store & Ad Fees for "Other fee" rows such as Promoted Listings and store subscriptions.
8. For Refund rows, reverse the sale at its gross amount (debit Sales Income by the Gross transaction amount) and credit each refunded fee back to its own fee account - on a cancelled order eBay returns the Final Value Fees as positive numbers in the same fee columns. Booking the refund's net amount against Sales instead leaves the refunded fees stuck in your income.
9. A Charge row is eBay billing your card on file, usually to cover a negative balance after a refund. It isn't income: credit your credit card account, then match that line when it shows up on your card statement rather than entering it again as an expense.
10. For Payout rows, debit Cash - Business Checking Account - that's money actually leaving eBay for your real bank, not a sale or a fee.
11. If a payout's rows are all in this report, its entry balances by itself. Rows whose payout lands after the report's end date (or hasn't happened yet) go in one extra entry against a clearing account ("eBay Managed Payments Clearing Account") representing what eBay is still holding; the payout's entry in the next period's report clears it.
12. Before saving, add up every debit and every credit column separately. If they don't match to the penny, the entry is wrong — QuickBooks will let you save an unbalanced journal entry without warning you.
13. In QuickBooks Online, go to + New → Journal Entry (or bulk-import via Settings → Import Data → Journal Entries on Advanced) and enter the lines above.

Option 2: Skip the manual math

Changed your mind? How to undo an import

Our apps never touch your QuickBooks file, and your original export is never changed. This export converts into journal entries, which become real entries in your books once you import them. To take them back out of QuickBooks Online:

1. Find the journal entries the import created: open the Journal report for the dates you imported, or search for journal entries in that date range.
2. Open each entry and choose More → Delete at the bottom of the screen.
3. If you work in QuickBooks Online Accountant, you can remove many entries at once with its batch delete/void tool instead.
4. Fix whatever needed fixing, convert your original export again, and re-import.

Tip: run the Journal report again afterward to confirm nothing from that batch is left.

Frequently asked questions

Can I import an eBay Transaction Report the same way as a bank export?
Not accurately. A bank import is a flat transaction list; an eBay Transaction Report bundles order revenue, itemized fees, and payouts into one export that needs a balanced double-entry journal entry to book correctly, which a bank-import CSV can't represent.

Which QuickBooks Online plan can bulk-import journal entries from a CSV?
Only QuickBooks Online Advanced has a native journal-entry CSV importer. Other tiers need manual entry or a third-party importer like Transaction Pro or SaasAnt.

What accounts does an eBay Transaction Report journal entry debit and credit?
Order revenue is credited as Sales Income; Final Value Fees, international fees, and performance penalties are debited as eBay Selling Fees; shipping labels and store/ad charges post to their own expense accounts; payouts post straight to your real bank account. Refunds reverse the sale and credit the refunded fees back.

Why one journal entry per payout instead of one for the whole report?
Because your bank feed shows each eBay payout as its own deposit. An entry per payout, dated the payout date, gives each deposit exactly one matching entry in QuickBooks. A single entry for the whole period can't be matched, and tends to get the income counted twice.

How is this different from Etsy's statement?
Etsy lists each fee as its own separate row. eBay instead itemizes an Order row's fees as columns on that same row, so it needs to be split into a revenue line plus one line per fee type rather than matched by a single Type value.

Convert other exports

• PayPal → QuickBooks
• Shopify Payouts → QuickBooks
• Stripe → QuickBooks
• Square Transactions → QuickBooks
• Gusto Payroll → QuickBooks
• Amazon Settlement → QuickBooks
• Etsy Payments → QuickBooks