How to Import Amazon Seller Transactions into QuickBooks

Short answer: The free Amazon Marketplace Connector by Intuit and paid apps like A2X sync into QuickBooks Online, but neither imports into QuickBooks Desktop and neither rebuilds old settlements well. Amazon Seller Central exports settlement data as a tab-delimited flat file and date-range reports as CSV, which QuickBooks will not take as a bank feed. For anything older than the connector reaches, for QuickBooks Desktop, or for a clean fee-by-fee record, convert the settlement report to a QBO Web Connect file and import it into an Amazon clearing account. Here is how each path works.

Can you import Amazon transactions into QuickBooks?

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 file 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.

Does Amazon have a QBO file?

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. That matters because QuickBooks Desktop imports bank activity only through Web Connect files, and QuickBooks Online treats a QBO upload as the cleanest file it accepts. Amazon produces neither, so a QBO for Amazon data can only come from converting the report. Upload the settlement report to the Amazon Seller statement to QBO converter, choose QBO, and you get a real Web Connect file for any period.

How to import an Amazon settlement into QuickBooks step by step

Set up the account structure once, then repeat the import each settlement period.

1. Create an Amazon clearing account. In QuickBooks, add a new account of the Bank type named something like "Amazon Payments Clearing." Sales and fees will post into it, and disbursements will leave it.
2. Add expense accounts for the fees. Set up accounts for referral fees, FBA fees, advertising, and storage so each cost lands where it belongs rather than net against revenue.
3. Download the settlement report. In Seller Central open Payments, then Reports Repository for the settlement flat file, or Date Range Reports for a CSV over the exact period.
4. Convert it to QBO. Drop the file into the converter, pick QBO, and download the Web Connect file.
5. Import it. QuickBooks Online: Transactions, Bank transactions, Upload from file, and pick the Amazon clearing account. Desktop: File, Utilities, Import, Web Connect Files.
6. Match the disbursement. The disbursement leaves the clearing account and matches the deposit on your real bank feed as a transfer between two accounts.

Why does my Amazon disbursement not match my sales?

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. If you book the deposit as revenue, you understate income by every fee and never record the cost at all, which quietly distorts margin all year. Import the settlement detail instead, and the sale, each fee, and each refund land on their own line. The full arithmetic is in why ecommerce sales never match the bank deposit.

Can I connect Amazon to QuickBooks Desktop?

Not natively. Every Amazon connector, free or paid, targets QuickBooks Online. QuickBooks Desktop has no native Amazon bridge, so Desktop sellers bring settlements in as Web Connect QBO files converted from the report. A converted settlement is a proper Web Connect file, which is the only supported way to load bank-style activity into Desktop.

How far back can I import Amazon history?

As far back as your settlement reports go. The connectors are built for the current period and do not rebuild a prior year, which is the usual wall in a catch-up. Because a converted report carries no sync window with it, you can convert a settlement from two years ago, or one from a marketplace you have since closed, and import it the same way as this month. If you are rebuilding a heavy 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 easily.

How do I record Amazon fees in QuickBooks?

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, so the profit and loss shows what you actually sold and what selling on Amazon actually cost. When you are also tracking the receipts behind your cost of goods and supplies, software that reads your receipts and categorizes the spend keeps the expense side as clean as the sales side.

Avoiding duplicate Amazon transactions

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 switch away from the connector entirely, disconnect it first so it stops posting, then load converted settlements forward from that date.

The short version

Amazon will not hand you a QBO, and the free connector will not hand you the fees. For a clean set of books, convert each settlement report to a Web Connect QBO, import it into an Amazon clearing account, and match the disbursement to your bank deposit. You can also take the same report as a spreadsheet with the Amazon Seller statement to Excel converter, and the general case for any institution is the bank statement to QBO converter.