Skip to content

Amazon and QuickBooks

Amazon Seller Connector by QuickBooks: what it does, its limits, and when you need more

What Intuit's Amazon Seller Connector brings into QuickBooks, what it leaves out (SKU detail, inventory, Desktop, multiple marketplaces), and the options when a summary per settlement is not enough.

· 5 min read

If you sell on Amazon and keep your books in QuickBooks, you have probably seen Intuit's own connector offered inside QuickBooks Online. It is free, it is official, and for a lot of sellers it is enough. This guide explains what it actually does, where it stops, and what the options are past that point, so you can decide without installing three apps to find out.

What the connector does

Amazon does not pay you per order. It accumulates sales, refunds and fees and pays out a settlement (typically every two weeks), with a report listing what made up that deposit. The connector connects to your Seller Central account, reads those settlements, and creates entries in QuickBooks Online that summarise each one: sales income, refunds, Amazon's fees, and the net deposit that should match your bank feed.

That is genuinely useful. It means your Profit & Loss shows Amazon revenue and Amazon fees as separate lines, and your bank reconciliation has a matching entry for every Amazon deposit, without anyone keying settlement totals by hand.

What a settlement contains

Settlement componentWhere it should land in QuickBooks
Product sales (principal)Sales income
Shipping and gift-wrap creditsShipping income (or sales)
Promotional rebates, couponsContra-income or a discounts account
RefundsSales returns
Referral fees, FBA fulfilment fees, storage feesAmazon fees expense (ideally split)
Advertising charges (if deducted)Advertising expense
Reimbursements (lost or damaged inventory)Other income
Sales tax collected and remitted by AmazonUsually excluded from income: Amazon remits it
Reserve held back for the next settlementA clearing account, not income

Any tool, including the connector, is making choices about these mappings. The first thing to check after installing one is whether its default accounts match how your accountant wants the P&L to read.

Where the connector stops

  • No SKU-level detail. Entries are summaries per settlement. You cannot see sales or margin by product in QuickBooks, because the product was never sent.
  • No inventory. It does not create or adjust items, so FBA stock levels and cost of goods sold are not touched. If you track inventory in QuickBooks, Amazon sales do not reduce it.
  • QuickBooks Online only. There is no version for QuickBooks Desktop or Enterprise.
  • Marketplace coverage. Support has centred on the US marketplace; sellers in several marketplaces or currencies should check what the current listing covers before relying on it.
  • Fixed shape. The account mapping is adjustable within limits, but you cannot change how a settlement is broken down, add customer records, or post anything per order.
  • Amazon only. If you also sell on Shopify, eBay or Walmart, each needs its own connection and the methods will not match.

When a summary per settlement is enough

If you want accurate revenue and fees on the P&L, clean bank reconciliation and nothing else, the connector is the right tool: free, official and low-maintenance. Sellers with one marketplace, no inventory tracking in QuickBooks, and an accountant who is happy with totals are its sweet spot.

When you need more

The signs that you have outgrown it: someone asks for margin by product; QuickBooks inventory does not match FBA; you sell in more than one marketplace; you are on QuickBooks Desktop; or your accountant wants fees split out in a way the connector does not offer. At that point there are two routes.

A third-party accounting app

Tools such as A2X, Synder and Webgility sit between Amazon and QuickBooks and offer more: finer fee breakdowns, multi-marketplace and multi-currency, and in some cases SKU-level entries and inventory updates. They are subscription products, priced by order volume, and each has its own fixed way of doing things, which fits most sellers and not all.

A custom integration

When the fixed ways do not fit, a custom Amazon ↔ QuickBooks integration is built around your chart of accounts and your inventory. Typical reasons: QuickBooks Desktop or Enterprise, per-order or per-SKU posting with cost of goods sold, inventory kept in sync with FBA, several marketplaces consolidated with your own rules, or Amazon as one of several channels that all need to post the same way. It costs more up front than an app subscription and nothing per order after that, and it does exactly what you specify.

A quick decision table

You needIntuit connectorThird-party appCustom integration
Revenue and fees on the P&L, bank reconciliationYesYesYes
Fees split in detailPartlyYesYes
Sales or margin by SKUNoSomeYes
Inventory and COGS in QuickBooksNoSomeYes
QuickBooks Desktop / EnterpriseNoSomeYes
Several marketplaces, one methodLimitedYesYes
Your own posting rulesNoNoYes
CostFreeMonthly, by volumeProject, then yours

Questions people ask

Something not covered here? Ask us directly.

Is the Amazon Seller Connector free?

Intuit has offered it at no extra charge to QuickBooks Online subscribers. Check the current listing in the QuickBooks app store, as availability and terms change.

Does it work with QuickBooks Desktop?

No. It is a QuickBooks Online app. Desktop and Enterprise sellers need a third-party app that supports Desktop or a custom integration.

Will it track my FBA inventory in QuickBooks?

No. It posts settlement summaries, not items, so inventory quantities and cost of goods sold are not updated. That needs a tool that posts at SKU level.

Can I use it alongside a custom integration?

Not for the same data; you would double-post. The usual path is to start with the connector and replace it when the limits bite, keeping the same accounts so the history stays consistent.

Need a hand?

Tell us what you are trying to get out of QuickBooks

Describe the report, the system or the workflow, and we will tell you whether a product, a sync or a custom integration is the right fit, and what it would take.