How to import an eBay Transaction Report into QuickBooks Online

eBay's Transaction Report can't be dropped into QBO like a bank feed. Here's why it needs a balanced journal entry instead of a transaction list, how to build one by hand, and the one-click shortcut if you'd rather skip it.

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, Non-sale charge, Transfer) 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.
  3. 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.
  4. Debit eBay Selling Fees: International Fees for any International fee column, and eBay Selling Fees: Other Selling Fees for performance-penalty columns (below-standard-performance fee, "item not as described" fee).
  5. Debit Shipping Expenses: eBay Shipping Labels for "Shipping label" rows, and eBay Selling Fees: Store & Ad Fees for "Non-sale charge" rows (store subscription, Promoted Listings).
  6. Credit or debit Sales Income: eBay Sales for "Refund" rows using that row's Net amount directly - fees generally aren't reversed one-for-one on a refund, so don't try to split those out.
  7. For "Transfer" (payout) rows, post straight to Cash - Business Checking Account rather than a fee or revenue account - that's money actually leaving eBay for your real bank, not a sale or a fee.
  8. Every line above should also hit a clearing account (call it "eBay Managed Payments Clearing Account") on the opposite side - that's what makes the entry balance and represents what eBay is holding for you pending payout.
  9. A single Transaction Report can contain multiple Transfer rows in one period, since eBay pays out more than once per reporting window - date the journal entry to the end of the period, not a single settlement date.
  10. 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.
  11. 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

Web App

eBay to QuickBooks

Drop in your eBay Transaction Report export, get back a QuickBooks-ready journal entry CSV — order revenue, Final Value Fees, international fees, shipping labels, store/ad charges, and payouts split into their real accounts and balanced automatically. Refuses to output an entry that doesn't balance.

From $19
Try it

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. Every line balances against a clearing account.

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

← Back to DigitalBuilds.org