QBOConverter

Amazon settlement report to QuickBooks — summarized to match your bank deposit

Drop in the Flat File V2 settlement report (.txt) from Seller Central — get back a QuickBooks-ready .QBO (Web Connect) file.

Drag & drop your settlement report (.txt) here

or

Your report is parsed in memory and immediately discarded — never stored, never logged.

How it works

1

Download the report

Seller Central → Payments → Reports Repository (or Date Range Reports) → pick the settlement period → Download Flat File V2. You get a tab-separated .txt file — upload it as downloaded, without opening it in Excel first.

2

Check the match

Each settlement shows one summary line: Sales, Refunds, Fees, Other and Net. The green ✓ means the net equals the deposit Amazon sent to your bank — to the cent.

3

Export & import

Download QBO, CSV, or XLSX and import into QuickBooks in a couple of clicks. Summary lines are dated on the deposit date, so they land right on your bank feed.

What goes into each line

One settlement (usually 14 days of activity) becomes 3–5 booked lines:

The four buckets

Sales — item price, tax and shipping charged to the buyer. Refunds — refund lines, net of the commission Amazon hands back. Fees — referral fees, FBA pick/pack and weight-based fees, promotions, storage and subscription fees (including the account-level rows that carry no order ID). Other — reserve movements and FBA inventory reimbursements, which are balance-sheet transfers, not P&L. Sales − refunds − fees ± other always equals the deposit.

Frequently asked questions

Which Amazon file exactly does this page take?

The Settlement Report Flat File V2 — the tab-separated .txt you get from Seller Central → Payments → Reports Repository (or Date Range Reports / All Statements) → "Download Flat File V2". One file can contain several settlements; each settlement-id becomes its own summary.

Why summaries instead of one line per order?

Because Amazon pays you one net deposit per settlement — not one payment per order. Importing thousands of order rows leaves you matching a single $1,204.18 bank deposit against a haystack of $24.99 charges, and reconciliation never closes. A2X-style settlement summaries book the same revenue and fees with 3–5 lines whose total is the deposit.

The ✓ next to a settlement didn't appear — now what?

The summary net is compared against the settlement's own total-amount column. If they differ, the file is usually truncated or was re-saved by a spreadsheet — download it again. Unknown charge types are never dropped silently: they land in "Other" with a warning listed above the preview.

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 settlements for 7 days — no subscription, nothing to cancel.

Does this work for European marketplaces (Amazon.de, .fr, …)?

European Flat Files use comma decimals (95,00) — the parser detects and reads them correctly. Note the tool is USD-focused for now: non-USD amounts are parsed as-is and flagged with a warning, so review before importing if you sell in multiple currencies.

Is my settlement 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.