The QuickBooks Online Amazon Connector: What It Does and What It Misses

By Jay Amni, founder of Vtory · Updated October 2026 · 8-minute read

Short answer: QuickBooks Online's built-in Amazon Connector is free and records each Amazon sale and refund as its own transaction, then a deposit for each payout. That works for a low-volume US seller who wants order detail in QuickBooks. As volume grows, it means thousands of transactions to review and product matching to maintain. Most growing sellers record one summarized journal per Amazon settlement instead.

How the QuickBooks Amazon Connector works

Based on Intuit's help article (updated October 2026), the connector is an app inside QuickBooks Online:

1. Go to Integrations, open the Amazon Connector app, and sign in with your Seller Central login.
2. Choose your Amazon marketplace and approve access.
3. QuickBooks imports three kinds of transactions into an Integration transactions tab:
   • Payment received: each sale, with fees, shipping, discounts, taxes and products.
   • Refund: each refund, with taxes and products.
   • Payout: each settlement deposit (usually every 14 days).
4. You review them in For review, Categorised and Excluded tabs. Confirming a sale creates a sales receipt plus fee expenses. Confirming a payout creates a deposit into your bank account.
5. When the money arrives, you match the bank feed deposit to that QuickBooks deposit.

What it does well

• It's free with your QuickBooks Online subscription.
• You see every order in QuickBooks, with its date, products and fees.
• Month-end is accurate by default. Each sale is dated on its own day, so a payout that crosses month-end doesn't need splitting.
• Bank matching works. The payout deposit matches your bank feed, as long as you use Match and not Add.

For a seller with a few hundred orders a month, one US marketplace and no COGS reporting needs, that can be enough.

Where it falls short

1. Thousands of transactions

Every order becomes a sales receipt plus expenses. At 1,000 orders a month, that's well over 12,000 sales receipts a year, each with fee lines. Your books get heavy, reports load slower, and finding one wrong number means searching through thousands of transactions.

A settlement journal records the same totals in about 26 entries a year per marketplace.

2. You still review everything

The connector only adds high-confidence transactions automatically, and it doesn't exclude anything for you. Anything it isn't sure about waits in For review. Imports arrive in batches that can take from 10 minutes to 3 hours.

3. Products have to match

Each order carries products. If automatic product creation is off, unmatched items go to a generic product that you have to map. If you track inventory in QuickBooks and sell through FBA or more than one channel, the quantities need ongoing maintenance.

4. Not every line is an order

A settlement isn't only orders. It also contains storage fees, the monthly subscription, advertising charged against your balance, FBA reimbursements, reserves held and released, and carried balances. Intuit's article describes payouts as the net amount after "fees and adjustments," but it doesn't explain how each of these lands in your accounts. Before you rely on it, take one payout and check that every line in the settlement report appears in the right account and that the total equals the deposit.

5. Check your marketplace

Earlier versions of QuickBooks' Amazon integration supported only the US marketplace. If you sell on Amazon.ca, Amazon.com.mx or in Europe, check which marketplaces and currencies the connector supports for your QuickBooks region before you set it up.

Per-order vs per-settlement: side by side

Which should you use?

Use the QuickBooks Amazon Connector if:

• You sell in one supported marketplace with a few hundred orders a month or fewer.
• You want each order visible in QuickBooks.
• You're happy to review imports and keep products matched.

Use settlement journals if:

• You have more than a few hundred orders a month, or expect to.
• You sell in more than one marketplace or currency.
• You want clean books your accountant can review quickly: income, fees, refunds, ads and COGS in their own accounts, one entry per payout.

You can do settlement journals by hand. This step-by-step guide shows a full example that balances to the cent. Or automate them.

Switching from the connector to settlement journals

1. Pick the first settlement you'll record as a journal. Everything before it stays as the connector recorded it.
2. Disconnect the Amazon Connector in QuickBooks Online so new orders stop importing.
3. Exclude anything left in For review that falls on or after your cutover settlement.
4. Record the cutover settlement as a journal (manually or with Vtory) and match the bank deposit to it.

Automate settlement journals with Vtory

Vtory connects Amazon Seller Central to QuickBooks Online and posts one journal per settlement:

• Every Amazon line mapped to your accounts: sales, refunds, selling fees, FBA fees, ads, reimbursements, tax and reserves.
• The journal total equals the bank deposit, so you just match it.
• A separate COGS journal from your product costs.
• An optional month-end split, multiple marketplaces and currencies, and automatic posting when you're ready.
• The original Amazon settlement file is kept with each report, so you can always check the source.

One plan: $195 per year. No order limits. Start free with a few recent settlements, no credit card. 14-day money-back guarantee.

Start free

Not sure which approach fits your store? Tell me your order volume and marketplaces, and I'll give you a straight answer, even if it's "use the free connector." Book a setup call

Frequently asked questions

Based on Intuit's public help article for the Amazon Connector (October 2026). Features may change; check Intuit's current documentation.