eBay Managed Payments to QuickBooks — one summary per payout
Drop in the Transaction report CSV from Seller Hub — get back a QuickBooks-ready .QBO (Web Connect) file.
- One Sales / Refunds / Fees / Other split per payout — not one row per order
- Each payout's net matches your bank deposit to the cent
- Custom column layouts are fine — the parser reads columns by name
- Processed in memory, never stored — your report never touches a database
Drag & drop your eBay Transaction report (.csv) here
or
Your report is parsed in memory and immediately discarded — never stored, never logged.
Preview
License active ✓| # | Date | Description | Amount (USD) |
|---|
How it works
Download the report
Seller Hub → Payments → Reports → Transaction report → pick a type and date range (up to 90 days) → Create report → download the CSV when eBay notifies you. The default columns work; customized columns are detected by name.
Check the match
Each Payout ID shows one summary line: Sales, Refunds, Fees, Other and Net. The net of a payout is exactly what eBay sent to your bank — that is the number your bank feed shows.
Export & import
Download QBO, CSV, or XLSX and import into QuickBooks in a couple of clicks. Rows still Processing or On hold are left out and listed in the warnings, so nothing is booked twice later.
What goes into each line
One payout becomes 3–5 booked lines:
The four buckets
Sales — gross order amounts before any fees. Refunds — refunds, claims and payment disputes at gross. Fees — final value fees (fixed + variable), international fees, per-order fee givebacks on refunds, shipping labels and eBay store subscription charges. Other — eBay-initiated adjustments and courtesy credits. Fee columns are read by header name (en dashes and all), and every Order/Refund row is cross-checked against Net = Gross + fees.
Frequently asked questions
Which eBay file exactly does this page take?
The Transaction report CSV from Seller Hub → Payments → Reports. Exports cover at most 90 days each — for a full quarter, run two reports and convert them one at a time. The Payout ID column is what the summary groups by, so keep it in the export (it's on by default).
Why summaries instead of one line per order?
eBay deposits one net amount per payout. Per-order imports flood your QuickBooks register with rows that never individually match anything in the bank feed, and reconciliation stalls. One split per payout books identical revenue and fees — and the total is the deposit.
What happens to orders that are still Processing or On hold?
They have no Payout ID yet, so they belong to no payout. They are excluded from every group, counted in the coverage check, and listed in the warnings box — convert the next report and they'll come in with their payout. Nothing is silently dropped or double-booked.
What do I get for free, and what does the license add?
Parsing and the full preview are free, always. Free export covers the first 25 summary rows — enough to prove the match end-to-end. A one-time $1.99 license exports all payouts for 7 days — no subscription, nothing to cancel.
Is my transaction report uploaded anywhere?
Yes — the report text goes over an encrypted connection to the parser, which runs in memory and discards it the moment your result comes back. Nothing is written to disk, a database, or logs. If a parse ever fails, one masked structural digest (every letter and digit replaced — no readable content) may be kept to fix the parser. Details in the Privacy Policy.
I already paid but lost my license key — what do I do?
Your license key is shown on your Gumroad receipt, which was sent to your inbox right after purchase — search for "Gumroad" and open that receipt to copy the key. Then use the "Enter license key" link in the top navigation to reactivate unlimited exports.