Amazon Seller Central exports settlement reports as tab-delimited text and CSV, plus a date-range summary. None of them is a .QBO file, and the free Intuit connector only posts into QuickBooks Online. Upload your Amazon settlement report here and get a real Web Connect QBO that both versions of QuickBooks import. Start free, no credit card.
Last updated July 2026
Upload your bank statement
Drop file here or click to upload
PDF, JPG, PNG, BMP, HEIC, TIFF, MT940
Uploading...
Upload the Amazon settlement report, date-range transaction report, or summary PDF to BankXLSX and choose QBO as the download format. Amazon has no QBO export of its own: every report it produces is a tab-delimited text file, a CSV, or a PDF summary. The converted QBO imports into your Amazon clearing account in QuickBooks exactly like a bank download, for any settlement period, including the older ones the connector will not rebuild.
Amazon records every fee it charges, then hands the detail over in formats QuickBooks will not take as a bank feed.
The settlement report exports as a tab-delimited V2 flat file, and the date-range report exports as CSV. The summary is a PDF. Web Connect is not offered anywhere in Seller Central, so there is no .QBO to hand your accountant.
The Amazon Marketplace Connector by Intuit syncs a basic sales figure into QuickBooks Online, but it does not break out referral fees, FBA fees, refunds, or reimbursements, and it does not reconcile to the disbursement. Serious sellers move to a paid connector or a converted file.
The Intuit connector and the common paid apps, A2X and Link My Books among them, post into QuickBooks Online. QuickBooks Desktop has no native Amazon bridge at all, which leaves Desktop sellers importing a file by hand.
Amazon deducts referral fees, FBA fees, advertising, storage, and refunds before it pays you, so the deposit in your bank is a net figure that never equals gross sales. Book the disbursement as revenue and you understate both income and expenses at once.
One deposit covers a two-week settlement period of thousands of order and fee lines. Without the settlement detail behind it, nobody can tell which orders that deposit represents, which is exactly where reconciliation stalls.
FBA reimbursements add to the payout and advertising charges subtract from it, both buried inside the same net number. Split out only at the disbursement level, they never land on the right income or expense line.
Upload the settlement report and get a valid Web Connect file, for any period, with each fee kept as its own line.
You get an actual .qbo with the structure QuickBooks expects, the only format QuickBooks Desktop Web Connect takes and the cleanest one for a QuickBooks Online upload.
A settlement report carries no sync window with it. Convert a period from two years ago, or rebuild a marketplace you have since closed, without a connector deciding how far back you are allowed to go.
Referral fees, FBA fees, advertising, and storage each stay their own line rather than disappearing into the disbursement, so revenue books at gross and every cost books where it belongs.
Refunds, chargebacks, and FBA reimbursements come across with the right sign, so the Amazon balance in QuickBooks tracks what Seller Central actually shows.
Each disbursement stays intact as its own transaction, which is what lets you match an Amazon payout to the deposit sitting on your bank feed.
256-bit encryption in transit, and you can delete your uploaded files whenever you want.
No software to install and no credit card to start.
In Seller Central open Payments, then Reports Repository for the settlement flat file, or Date Range Reports for a CSV or PDF over the period you need. A report a client forwarded works too. Drag the file into the box above.
Tip: The V2 flat file carries every order and fee line.
Once the transactions are read, pick QBO as the download format. QFX, OFX, CSV, and Excel sit next to it.
Tip: Pick QFX if the target is Quicken.
QuickBooks Online: Transactions, Bank transactions, Upload from file. Desktop: File, Utilities, Import, Web Connect Files. Select the Amazon clearing account, which most books set up as a bank account.
Tip: One account per file.
Amazon sits between the buyer and the bank and keeps its cut on the way through. The gross sale, the referral fee, the FBA fee, the advertising, the storage, the refund, and which orders made up each disbursement all live inside the settlement report. The bank sees a series of net deposits arriving every two weeks with no explanation.
The client sends the settlement report, not the Seller Central login. Convert the period you were handed and post it properly, without waiting on access you may never get.
You want the deposit in the bank to tie back to the orders behind it, so revenue is right and the FBA fees are visible on the profit and loss.
The connector will not rebuild the year you are catching up on. Converted settlement reports will, period by period, as far back as your reports go.
There is no Amazon accounting app for Desktop. Web Connect is the supported route in, and a converted settlement report is a proper Web Connect file.
Yes, and there are three real routes. The free Amazon Marketplace Connector by Intuit posts a basic sales sync into QuickBooks Online. A paid connector such as A2X or Link My Books rebuilds each settlement into a journal entry, also for QuickBooks Online. And a converted settlement report produces a Web Connect .QBO that both QuickBooks Online and QuickBooks Desktop import, for any period. The route you pick decides how much history you get, whether the fees survive as their own lines, and whether Desktop is even an option.
| Path | File or method | History reach | Works with QuickBooks Desktop? |
|---|---|---|---|
| Amazon Marketplace Connector by Intuit | Free live sync | Recent activity forward, little backfill | No, QuickBooks Online only |
| Paid connector (A2X, Link My Books) | Settlement journal entry | From the plan start, some history on higher tiers | No, QuickBooks Online focus |
| Amazon settlement or date-range report | Tab-delimited flat file or CSV | Any period Seller Central retains | Not as a bank feed |
| Converted Amazon statement | A real .QBO Web Connect file | Any period | Yes |
The pattern repeats across ecommerce accounting: the live connection owns the current period, and everything behind it has to arrive as a file. Amazon makes it sharper than most, because the one file format QuickBooks treats as a bank feed is the one format Amazon does not produce.
No. Amazon Seller Central exports settlement data as a tab-delimited V2 flat file and date-range reports as CSV, plus a summary PDF. There is no Web Connect option in the reports menu, and there never has been. This matters because QuickBooks Desktop imports bank activity through Web Connect files and QuickBooks Online treats a QBO upload as the cleanest file it accepts. Amazon produces neither, so converting the settlement report is not a shortcut around an export. It is the only way to get the file at all.
Because Amazon nets everything out before it pays. A disbursement is gross sales, minus referral fees, minus FBA fees, minus advertising and storage, minus refunds issued in the window, plus any reimbursements. So a two-week period with 20,000 dollars of orders might deposit around 13,000. Book the deposit as revenue and you understate income by every fee and never record the cost at all. Import the settlement detail instead, and the sale, each fee, and each refund land on their own line.
Yes, set it up as a clearing account of the bank type. Sales and fees post into it, disbursements leave it, and the disbursement then matches the deposit on your real bank feed as a transfer between two accounts. That structure is what makes the Amazon balance meaningful: money buyers have paid but Amazon has not yet released sits in the clearing account, exactly where it belongs, instead of being invisible until it lands.
Duplicates appear when a live sync and a converted file overlap. Open the Amazon clearing account register, find the oldest transaction the connector brought in, and end your converted file the day before it. Load history behind the sync, never on top of it. If you are rebuilding a busy year, check how many transactions QuickBooks accepts at once first, because a QuickBooks Online upload caps at 1,000 lines and a year of Amazon orders clears that without trying.
The same upload produces more than a QuickBooks file. Take XLSX or CSV instead with the Amazon Seller statement to Excel converter when you want to sort and total a year for a tax return. The step-by-step version of this page is how to import Amazon Seller transactions into QuickBooks, and if the deposit that does not match your sales is what sent you here, why ecommerce sales never match the bank deposit works through the arithmetic. The sibling marketplace and processor pages are eBay statement to QBO, Shopify statement to QBO, Stripe statement to QBO, and PayPal statement to QBO, and the general case is the bank statement to QBO converter.
If you already pulled the Amazon settlement CSV and simply need it in Web Connect form, a dedicated CSV to QBO converter does that one job. When statements from several channels and banks are all heading into the same QuickBooks file, a purpose-built bank statement to QuickBooks converter runs the PDF to QBO workflow across all of them.
Yes. The free Amazon Marketplace Connector by Intuit and paid apps like A2X sync into QuickBooks Online. For older periods, or for QuickBooks Desktop, convert the Amazon settlement report to a QBO Web Connect file and import it into your Amazon clearing account like a bank download.
No. Amazon Seller Central exports settlement data as a tab-delimited flat file and date-range reports as CSV, plus a summary PDF. Web Connect is not offered anywhere in Seller Central, so the only way to get a .QBO from Amazon data is to convert the report.
Not natively. Every Amazon connector, free or paid, targets QuickBooks Online. QuickBooks Desktop has no native Amazon bridge, so Desktop sellers import a Web Connect QBO file converted from the settlement report instead.
Amazon deducts referral fees, FBA fees, advertising, storage, and refunds before releasing each disbursement, so the bank deposit is always less than gross sales. Booking the deposit as revenue understates income and hides every fee. Import the settlement detail so each piece lands on its own line.
Yes, as a clearing account of the bank type. Sales and fees post into it and disbursements leave it, which lets you match each Amazon payout against the deposit on your real bank feed as a transfer rather than double counting the revenue.
Book the sale at gross and each Amazon fee, referral, FBA, advertising, and storage, as its own expense. Recording only the net that landed understates revenue and leaves the fees off the profit and loss. A converted settlement report keeps every line separate.
The same settlement report as XLSX or CSV instead.
The marketplace whose payout is net of final value fees.
The store platform whose sync stops at one year.
Convert any bank statement to a QBO file.
Every QuickBooks import path, and the limits on each.
Z tej samej rodziny narzędzi
Get started converting bank statements to spreadsheets.
USD
per month
billed as
$288 yearly
Choose speed vs accuracy when extracting
| Base AI Faster | 2,500 pages |
| Pro AI Best accuracy | 500 pages |
Scale statement conversion across your team with automation.
USD
per month
billed as
$888 yearly
Choose speed vs accuracy when extracting
| Base AI Faster | 10,000 pages |
| Pro AI Best accuracy | 2,000 pages |
Enterprise-grade bank statement conversion and controls.
USD
per month
billed as
$ yearly
Choose speed vs accuracy when extracting
| Base AI Faster | pages |
| Pro AI Best accuracy | pages |
