1. Home
  2. QuickBooks integration
  3. Amazon and QuickBooks

Amazon and QuickBooks: sales come in by settlement, purchases by a separate app

Two tools share the name, and they do different jobs. A seller posts each Amazon payout, called a settlement, to QuickBooks Online. The data comes from Amazon's settlement report or its Finances API. A buyer on Amazon Business uses the Amazon Business Purchases app instead, which brings what they bought into QuickBooks.

Checked 18 November 2026

Two different jobs share the name

One tool moves sales in. The other moves purchases in.

Scroll the table sideways to see every column.

You are What moves into QuickBooks Online Tool
A seller on Amazon Sales, Amazon fees and refunds, one settlement at a time An app or a custom build on Amazon’s Selling Partner API
A buyer on Amazon Business Things your company bought on Amazon Business The Amazon Business Purchases app, found in the Amazon Business App Center

Intuit announced this tie-in on September 28, 2020, as a new integration for QuickBooks with Amazon Business. Its press release said all Amazon Business buys would flow into QuickBooks, refreshed several times a day. It said each item could be categorized on its own and matched with bank transactions, and that returned items would import for review too. The release said imported purchases would appear under Banking, in an App transactions tab. Intuit’s current help page on connecting Amazon Business gave our fetcher no response on 18 November 2026, so we could not check today’s steps. Treat the 2020 details as history and check the current app. The rest of this page covers the seller side.

Amazon’s settlement report is the seller’s source of truth

Amazon pays sellers in settlements. Each settlement report carries a deposit date and a total amount. Amazon’s Flat File V2 settlement report lists what is behind it, and its columns also include the settlement ID and the start and end dates. So each settlement maps to one QuickBooks deposit.

Amazon sets the timing. Its docs say an app can’t ask for a settlement report or schedule one. The app looks for new ones with the getReports call and reads each one as it shows up.

Fees are easier to read in Flat File V2. Every amount sits in one amount column. Beside it, the amount-type and amount-description columns say what each charge or fee is. Amazon says this holds even when it adds new fees. So a sync maps each amount-description to a QuickBooks account once. A new fee name goes to a person to check, and the import keeps running.

Sellers outside the US have one more parsing trap. Amazon says amounts appear in local currency formats, such as a comma as the decimal mark in EU reports. Parse each marketplace’s report with its own number format.

The old settlement reports reached their removal date

Amazon’s SP-API changelog of March 9, 2026 set November 11, 2026 as the date the XML and the old flat file settlement reports are removed for sellers. That date has passed. Amazon says the change applies to all marketplaces, and no XML replacement exists. Any connector still reading the old formats needs to move to Flat File V2. Ask your vendor which report their connector reads.

Older tools have hit this before. Amazon’s June 2023 newsletter said that after August 31, 2023, private app developers would lose access to MWS data for Orders and Reports. MWS was Amazon’s previous seller API.

The Finances API shows money before the settlement closes

Amazon’s Finances API, version 2024-06-19, returns financial events for an order or a date range without waiting for a statement period to close. That suits a daily view of sales and fees. Three limits from its reference shape the design:

  • Recent orders. Financial events might not include orders from the last 48 hours.
  • Window size. If the start and end dates are more than 180 days apart, the response is empty. A first import of a year’s history runs in chunks.
  • Deferred money. Amazon keeps a deferred balance: sales revenue withheld for a set period before it moves to the available balance. Transactions carry a DEFERRED status while that lasts.

The deferred balance matters for the books. Sales you have earned but Amazon has not released sit outside your bank. Your accountant decides whether they post as a receivable from Amazon until the settlement lands.

How a settlement should land in QuickBooks Online

Post each settlement as one entry that ties to the deposit. A settlement covers every order in its period. So one line per amount-type fits better than one line per order.

Intuit’s limits page caps a QuickBooks transaction at 10,000 lines, journal entries aside. It gives no figure for journal entries, so test your largest settlement in a sandbox company before you pick the record type. Intuit lets a developer hold up to 10 sandbox companies, each kept for two years. Keep the settlement ID on the entry. Then a second run can see it was posted.

Sales tax: Amazon’s report says who collected it

Amazon’s Sales Tax Report for US sellers has a Tax_Collection_Responsible_Party column. It also has a Total_Tax_Collected_By_Amazon column. Together they show your accountant which tax Amazon handled and which may still be yours. An app can’t pull this report on demand. Amazon says the seller makes it in the Tax Document Library in Seller Central, and the app then finds it with getReports. The app also needs Amazon’s restricted Tax Remittance role.

We tried to read Amazon’s Seller Central help page on marketplace tax collection on 18 November 2026. It returned a sign-up page to our fetcher, so we quote none of it here.

Order calls are slow, so a sync should not poll

A settlement-based sync rarely needs the Orders API. It comes in only if you want order detail between settlements. Amazon rate-limits its API with a token bucket, and most limits apply per seller and app pair. In Orders API v2026-01-01, Amazon’s rate limit page gives searchOrders 0.0056 requests a second with a burst of 20. That is about one call every three minutes once the burst is spent.

Amazon has advice for an app that keeps getting throttled. Call less often, and rely on push notifications instead of polling. Its ORDER_CHANGE notice fires on big order changes, such as a new status or a cancel request from the buyer. A 429 response, the code for too many requests, can be retried. Amazon also says all sandbox operations share the same rate, so its sandbox can’t prove the live limits.

A new fee name is where an AI agent helps

Flat File V2 keeps working when Amazon adds a fee. But the new fee name still has no QuickBooks account. A custom agent can spot it and suggest an account from the fees mapped before. It holds that settlement’s entry as a draft until a person signs off. See QuickBooks AI agents and AI integration services.

Our QuickBooks work, and the move beyond it

Our team has run four kinds of work in QuickBooks: bookkeeping, invoicing, inventory sync and order sync.

When a business outgrows QuickBooks, our team has moved companies off it, and off Xero or Sage, into a full ERP. Our QuickBooks integration page lists the other ways to connect QuickBooks.

Questions

Can I connect Amazon Seller Central to QuickBooks Online?

Yes, through an app or a custom build on Amazon's Selling Partner API. The Amazon Business Purchases app is a different tool. Amazon's page describes it as a way to bring in your purchases from Amazon Business. For sales, start from Amazon's settlement report. Each one lists the orders and fees behind a deposit, with the deposit date and the total.

How often does Amazon send settlement data?

On Amazon's schedule, not yours. Amazon's docs say an app can't ask for a settlement report or set its timing. Amazon schedules each one itself, and the app finds it with the getReports call. For figures sooner, the Finances API returns money events for an order or a date range before the period closes. It may miss orders from the last 48 hours.

Does Amazon collect the sales tax for us?

We could not confirm that from Amazon's help pages. Its help page on tax collection sent our tool a sign-up page instead. Amazon's Sales Tax Report shows it order by order, though. The report for US sellers has a column for who was responsible for collecting the tax, and one for the tax Amazon collected. Your accountant uses those two to see which tax is yours to pay.

Does QuickBooks Online support multiple companies?

Each QuickBooks Online company has its own ID in Intuit's API. Intuit's sign-in tokens are tied to one company, so an integration connects to each company on its own. A seller with two brands in two companies sets up two connections. For groups, Intuit's release notes mention multi-entity sandboxes for Intuit Enterprise Suite apps.

Why are people leaving QuickBooks?

Settlement size is the pressure point Intuit's docs show for a big seller, though we have no survey of reasons. A QuickBooks transaction other than a journal entry holds at most 10,000 lines. The API allows 500 requests a minute for each company. A large Amazon account plans its posting around both, which is why summaries per fee type beat one line per order.

Do you need our Seller Central password?

No. A custom build for your business alone is what Amazon calls a private seller app. Amazon says those are self-authorized, and need a professional selling account, since individual accounts are not eligible. Public apps are authorized by sellers using OAuth, a standard way to grant access without a password. We sign your NDA before you share any data, if you ask.

Sources

Every source behind a figure or a vendor fact on this page, with the day we read it.

Book Amazon settlements in QuickBooks

Have one recent settlement report and your list of Amazon marketplaces ready. The first call is free.

Discuss Amazon settlements