Convert a eBay transaction report to QuickBooks or Xero

Including multi-year catch-up - with the footing check that proves the conversion is right.

Why eBay settlements resist clean bookkeeping

eBay's managed payments transaction report is five fee schedules wearing a trench coat: final value fees, promoted-listing ad fees, shipping label fees, international fees, and dispute adjustments, all in one Type column whose sign conventions have changed between report versions. Sellers reconciling manually hit the same wall every month - order reports say one number, the payout says another, and the difference is distributed across fee types nobody itemized.

How the eBay file maps to your books

Multi-year catch-up on eBay

eBay transaction reports export per date range, so backfills convert period by period. Because sign conventions have drifted across eBay's report versions, the converter's footing check matters more here than anywhere: if an old file's signs don't reconcile, the payout is flagged rather than shipped wrong.

Importing into QuickBooks Online

1. In QBO, go to Banking → Upload transactions and choose the FootingKit QuickBooks CSV.
2. Select the 3-column layout (Date, Description, Amount) - the file is already in that layout.
3. Map each summarized line to your accounts: Sales to income, Platform fees to merchant fees expense, Refunds against income.
4. Match each payout's lines against the corresponding bank deposit. Because every payout foots to the cent, the match is exact - no plug entries.

QuickBooks bank feeds want one line per money movement against a deposit, so FootingKit summarizes each payout into category lines dated to the deposit date; order-level detail stays in the reconciliation report, out of your register.

Importing into Xero

1. In Xero, open the bank account, choose Import a statement, and upload the FootingKit Xero CSV.
2. The file uses Xero's statement layout (*Date, *Amount, Payee, Description, Reference) - no column mapping needed.
3. Create bank rules once for the Payee names and Xero codes recurring lines automatically from then on.
4. Reconcile each payout group against the real deposit; the Reference column carries the payout id so groups filter cleanly.

Xero statement imports work best when each payout arrives as a small set of coded lines, so FootingKit groups by payout and carries the payout id in the Reference field - bank rules handle the recurring coding from the second month on.

Which eBay report do I download?

Seller Hub -> Payments -> Reports -> Transaction report. The converter reads that CSV directly with no reformatting.

Are ad fees separated from selling fees?

Yes - promoted-listing fees map to their own line so ad spend doesn't disappear into cost of sales.

Convert your Ebay file - done-for-you from $149

FootingKit converts marketplace settlement reports into QuickBooks- and Xero-ready books, footed to the penny.