How to Import eBay Transactions into QuickBooks

Short answer: eBay does not export a QuickBooks Web Connect (.qbo) file, and its official app connectors sync to QuickBooks Online only, not Desktop. Since eBay Managed Payments took over, every payout arrives net of final value fees, ad fees, and refunds, so the deposit in your bank never equals gross sales. To get eBay into QuickBooks with the fees split out, export the eBay financial statement or transaction report, convert it to a QBO file or a mapped CSV, and import it, then match the payout line to its bank deposit. Here is how.

Can you import eBay transactions into QuickBooks?

Yes, but not with a bank feed the way a checking account connects. eBay is a marketplace, not a bank, so there is no Web Connect file and nothing for QuickBooks to sync to directly. Sellers have three practical paths: a third-party connector app that posts orders and fees into QuickBooks Online, a manual export of the eBay financial statement or transaction report, or converting that export to a QBO file you upload. Whichever you choose, the goal is the same, split each payout into sales, fees, and refunds so the books reconcile.

Does eBay export a QBO file for QuickBooks?

No. eBay gives sellers a transaction report as CSV and a monthly financial statement as a PDF summary, but neither is a QuickBooks Web Connect file, and eBay has no one-click QBO download. The connector apps that post into QuickBooks Online work through eBay's API, not a downloadable file, and they do not serve QuickBooks Desktop. If you run Desktop, or you want a clean fixed-period import, convert the eBay export to a QBO file and upload it like a bank download.

Why does my eBay payout not match my sales?

Because eBay nets its fees before it pays you. Under Managed Payments, eBay subtracts the final value fee, any Promoted Listings ad fees, refunds, and international or regulatory fees from your gross sales, then deposits the remainder. So a week of sales that totals a larger number arrives in your bank as a smaller payout. In QuickBooks you have to record the gross sales, the fees as expenses, and the refunds separately, so the net payout ties out to the deposit that actually hit your account.

How do I reconcile an eBay payout to the bank deposit?

Match the net payout line, not the sales total. Take the eBay transaction report or statement for the payout period, record gross sales as income, record final value fees and ad fees as expenses, and record refunds against sales. The result should equal the single deposit eBay sent to your bank. When you convert the export to a QBO or CSV import, the fee and refund lines come across already separated, so the payout total lines up with the bank deposit and reconciliation is a match rather than a hunt.

Import eBay transactions into QuickBooks, step by step

First, in Seller Hub open Payments, then Reports, and download the transaction report as CSV for the date range, or the monthly financial statement PDF. Second, convert it to a QBO file or a clean mapped CSV with sales, fees, and refunds separated. Third, in QuickBooks Online go to Transactions, Bank transactions, and choose Upload from file; in QuickBooks Desktop use File, Utilities, Import, Web Connect Files. Fourth, review the rows, confirm the net payout matches the bank deposit, and categorize fees to their own expense account. Sellers who want a running read on take-home before the books close often keep an income tracker for online sellers alongside QuickBooks.

The short version

eBay exports no QBO file, its connectors are QuickBooks Online only, and every payout arrives net of fees, so the deposit never matches gross sales. Convert the eBay statement to QBO or a mapped CSV, split sales, fees, and refunds, and match the net payout to the bank deposit. Prefer a spreadsheet to sort and total a year for taxes? The eBay statement to Excel converter writes XLSX and CSV from the same upload. The arithmetic behind the mismatch is in why ecommerce sales never match the bank deposit, and the general import walkthrough is how to convert bank statements to QuickBooks (QBO).