Connect Amazon Seller Central to QuickBooks: A Guide

Last verified: May 2026

If you've ever stared at an Amazon payout and tried to work out why it doesn't match anything in your QuickBooks, you're not alone. Amazon settles every two weeks, netting out referral fees, FBA fulfilment fees, storage, advertising, refunds, and a rolling reserve — all before it wires you a single number. Your accounting software sees one bank deposit. The actual story is dozens of line items buried in a settlement report most sellers have never opened.

Getting this right matters more than it used to. As your operation scales — maybe you're building toward the kind of stack described in our 7-figure DTC operations stack — messy books become a real liability. Inaccurate COGS, understated fees, and reconciliation gaps make tax season painful and make it nearly impossible to know your real per-unit margin.

This guide covers three concrete methods to connect Amazon Seller Central to QuickBooks Online, from the free native connector through to fully managed reconciliation. We'll also walk through the settlement report structure you need to understand before any sync is useful, and the errors you'll almost certainly hit along the way.

Before you start

• An active Amazon Seller Central account
• A QuickBooks Online subscription
• Permissions in Amazon Seller Central to install third-party applications
• Access to your QuickBooks chart of accounts (you'll want to map Amazon fee types — referral, FBA, storage, advertising — to specific expense accounts before any data flows in)

Understanding your Amazon settlement reports before you sync

Before you touch any connector, spend ten minutes inside a real settlement report. In Seller Central, go to Reports → Payments → All Statements and download a flat file for your most recent settlement period. You'll see entries for product sales, shipping credits, promotions, refunds, referral fees, FBA fulfilment fees, storage fees, sponsored product charges, and a reserve amount carried forward to the next period.

That reserve is why your QuickBooks deposit never matches your gross sales. Amazon holds back a portion of each settlement to cover potential refunds — it's not a fee, it releases in a future settlement, but it throws off reconciliation if your sync doesn't account for it.

One practical decision to make now: individual orders or daily summaries? Pushing every order as a separate QuickBooks transaction creates clutter fast. If you process 500 orders a week, that's 2,000 individual entries a month — and QuickBooks slows down noticeably under that kind of volume. The cleaner approach is consolidated daily summaries that cover sales, refunds, and fees for each day. You get accurate accrual-based figures without the noise. Whichever method you choose below, configure it to summarise rather than itemise unless you have a specific audit reason to do otherwise.

Methods at a glance

Method 1: Native QuickBooks Amazon Connector app

Intuit offers a free Amazon Connector by QuickBooks that pulls sales and payout data directly from Seller Central. Setup is straightforward, and for sellers doing a few hundred orders a month, it gets the job done at zero additional cost. But — and this is worth knowing before you commit — the connector imports transactions without matching them to your bank deposits. You'll still reconcile payouts manually at the end of each settlement period.

1. Open the QuickBooks App Store. Log into QuickBooks Online, click Apps in the left nav, and search for "Amazon Connector by QuickBooks". Confirm you're on the official Intuit-published listing. Expected result: the app page shows a "Get app now" button and confirms it's free.
2. Click "Get app now" and follow the OAuth prompts. QuickBooks will ask for permission to connect to your Amazon account. You'll be redirected to Amazon's login. Expected result: you authenticate with your Seller Central credentials and Amazon grants QuickBooks read access to your transaction data.
3. Select your Amazon marketplace. If you sell on multiple Amazon marketplaces (amazon.co.uk, amazon.de, etc.), choose the primary one first. You can add others later, but each marketplace syncs as a separate connection. Expected result: the connector shows your marketplace confirmed and begins an initial data pull.
4. Configure your account mappings. The connector will prompt you to map Amazon income and fee categories to QuickBooks accounts. Map product sales to a revenue account, and map fees to appropriate expense accounts — referral fees and FBA fees should ideally sit in separate expense lines so your P&L is readable. Expected result: mappings saved; the connector shows a summary of what it will import.
5. Review the first sync. Check Sales → All Sales in QuickBooks after the first import completes (usually within a few minutes). Compare the gross sales figure against your most recent Seller Central payment summary. Expected result: figures align at the gross level; you'll then need to manually reconcile the net deposit in your bank feed against the fees and reserves reflected in QuickBooks.

For a broader view of how this fits into your Amazon operations, our guide on syncing Shopify inventory to Amazon FBA covers the inventory side of the same stack.

Method 2: Third-party connector tool

The native connector is a starting point, not a complete solution. Once you're past £10,000 in monthly revenue — or running FBA with meaningful storage and advertising costs — you need a tool that actually parses the settlement flat file and maps every fee type to the right account without you touching it. Several tools in the Amazon Seller Central app store do exactly this, typically on a paid subscription scaled to order volume.

The setup process is broadly similar across tools in this category. We're describing the general workflow rather than endorsing a specific product.

1. Install the tool from either the Amazon App Store or the provider's website. Grant the tool MWS or SP-API access when prompted — this is what allows it to pull your raw settlement files, not just summary data. Expected result: the tool confirms API access and shows your Seller Central account linked.
2. Connect your QuickBooks Online account. Authenticate via QuickBooks OAuth. Expected result: the tool displays your QuickBooks chart of accounts and prompts you to map categories.
3. Configure fee mappings. This is where the value sits. Map each Amazon fee type — FBA fulfilment, storage, referral, sponsored products, reimbursements, refunds — to specific QuickBooks expense or income accounts. A common structure: Sales → Revenue; Referral fees → Cost of sales (or a dedicated Amazon fees account); FBA fees → Fulfilment expense; Storage → Warehousing expense; Refunds → Returns and allowances. Expected result: a mapping table saved in the tool, reviewable before any data syncs.
4. Set sync frequency and granularity. Choose daily summary mode rather than per-order. Expected result: each day's Amazon activity hits QuickBooks as a single journal entry covering gross sales, fee categories, and net amount — clean, auditable, and fast to reconcile.
5. Run a test sync against a known settlement period. Pick a closed settlement period from two months ago where you know the exact payout amount. Run the sync and check whether the net figure in QuickBooks matches the Amazon deposit. Expected result: net figures match within rounding; any variance should be explained by reserve movements the tool flags separately.
6. Enable bank matching. Most tools in this category will create a QuickBooks bank rule or matching record so that when Amazon's deposit hits your bank feed, QuickBooks auto-matches it to the synced settlement data. Expected result: Amazon deposits clear automatically in your bank reconciliation with no manual matching required.

Method 3: Manual export and import

This is the no-software option — and honestly, it doesn't scale. But it's worth knowing for one-time historical imports or for very low-volume sellers who don't want another monthly subscription.

1. Open Seller Central and navigate to Reports → Payments → All Statements. Download the flat file (.txt) for the settlement period you want to import. Expected result: a tab-delimited file containing every transaction in that settlement period — sales, refunds, fees, reserves, and adjustments.
2. Open the flat file in a spreadsheet tool. Filter and group by transaction type — sales, refunds, and fees each need to become separate line items in your QuickBooks import. Sum each category. If you want to go deeper on working with Amazon data in spreadsheets, our guide to connecting Amazon Seller Central to Google Sheets covers the data structure in detail. Expected result: a clean summary showing gross sales, total refunds, total fees by type, and net payout for the period.
3. Create a journal entry in QuickBooks. Go to + New → Journal Entry. Debit your Amazon receivable or bank account for the net payout; credit revenue for gross sales; debit your fee expense accounts for each fee category; debit your refunds account for total returns. Expected result: a balanced journal entry that reflects the full settlement economics, not just the bank deposit.
4. Match the journal entry to your bank feed. When Amazon's deposit appears in your QuickBooks bank feed, match it to the journal entry you just created. Expected result: the transaction clears, your bank reconciliation stays clean, and the P&L shows the correct expense breakdown.

Doing this every two weeks for a single marketplace is manageable. Doing it across Amazon, Shopify, eBay, and Walmart is genuinely not — which is where a more automated approach pays for itself quickly. See also our notes on automating e-commerce purchase order workflows for related operational context.

Method 4: Ceendesis Accounting

Ceendesis Accounting is a managed reconciliation service built for multi-channel e-commerce brands. It connects Amazon, Shopify, Walmart, and eBay payouts to QuickBooks Online (and Xero), parsing Amazon SP-API settlement flat files and tracking COGS and fees per channel — so you get per-marketplace P&L without building the plumbing yourself. One honest caveat upfront: Ceendesis Accounting works with Xero and QuickBooks only. There's no Sage support yet, so if you're on Sage, this isn't your method.

1. Book an onboarding call with the Ceendesis team. During this call, you'll confirm your marketplace connections (Amazon EU, Amazon US, etc.), your QuickBooks account structure, and which fee categories you want tracked separately. Expected result: a configuration document agreed before any data moves.
2. Grant API access to Amazon and QuickBooks. Ceendesis will provide an OAuth link for each platform. Grant read access to Amazon SP-API settlement data and read/write access to QuickBooks. Expected result: Ceendesis confirms both connections are live and settlement data is pulling correctly.
3. Review your initial chart of accounts mapping. The team will propose mappings for your specific fee mix — FBA, referral, storage, ads, reimbursements — and you approve or adjust. Expected result: a mapping table that matches your existing QuickBooks account structure, so nothing lands in a catch-all "other income" bucket.
4. Validate the first settlement reconciliation. Ceendesis will reconcile your most recent closed settlement period and share a summary showing gross sales, fee breakdown, reserve movement, and net payout — and confirm it ties to your bank deposit. Expected result: figures reconcile to zero variance, or variances are explained and documented.
5. Set your ongoing reporting cadence. Settlements post automatically each cycle; you receive a reconciliation summary per channel per period. Expected result: each Amazon deposit clears in QuickBooks automatically, with the full fee and COGS breakdown already posted.

If you're running a multi-channel operation and thinking about EU expansion, per-channel financial clarity becomes especially important — our piece on the e-commerce operations stack for EU expansion gets into why.

Common errors and how to fix them

Amazon payout doesn't match the sum of invoices in QuickBooks

This is almost always a reserve issue. Amazon holds back a rolling reserve from each settlement — it's not a fee, it's a liability that releases in future periods. If your sync doesn't model this separately, every settlement will show a gap. Fix: ensure your tool or journal entry includes an "Amazon reserve" liability account. The reserve released from the previous period should credit this account; the new reserve held should debit it. Over time it nets to zero, but you need it in your books to reconcile each cycle cleanly.

Missing transaction batches after a sync

The native connector occasionally misses batches — a known limitation rather than a configuration error. If you notice a day's sales missing, check the connector's sync log (usually under Apps → Connected Apps → Amazon Connector → Activity). If the batch shows as "failed", disconnect and reconnect the app. For recurring gaps, the native connector's reliability isn't production-grade for high-volume sellers; a third-party tool with SP-API access is more robust.

Fee categories landing in the wrong QuickBooks account

This happens when you accept default mappings without reviewing them. Amazon's settlement file uses non-obvious labels — "FBAPerUnitFulfillmentFee" and "Commission" are two you'll see frequently. Map these explicitly: Commission → Referral fees (expense); FBAPerUnitFulfillmentFee → FBA fulfilment (expense); FBAStorageFee → Storage (expense). Spending 20 minutes on this mapping upfront saves hours of reclassification later.

Duplicate entries in QuickBooks

Usually caused by running both the native connector and a third-party tool simultaneously, or by re-syncing a period that's already been imported. Before enabling any new sync tool, disable or disconnect the previous one first. If duplicates have already posted, identify them by date and amount and void them individually — don't delete, or your audit trail breaks.

Reconciliation errors from individual order syncing

If your tool syncs individual orders and you're doing meaningful volume, QuickBooks performance degrades and reconciliation becomes unwieldy. Switch to daily summary mode in your connector settings. If you've already imported months of individual orders, you'll need to either reverse and re-import in summary format or accept the current state and switch forward from a clean date.

Frequently asked questions

How do I connect my Amazon seller account to QuickBooks Online?

The quickest route is the official Amazon Connector by QuickBooks, available free from the QuickBooks App Store. Log into QuickBooks Online, navigate to Apps, search for "Amazon Connector", and follow the OAuth prompts to authenticate with your Seller Central account. For more detailed fee-level reconciliation, a third-party SP-API connector gives you more control over how settlement data maps to your chart of accounts.

Can Amazon Seller Central sync automatically with QuickBooks?

Yes — both the native connector and third-party tools support automated syncing on a daily or per-settlement basis. The native connector runs automatically once connected, though it won't reconcile payouts to bank deposits on its own. Third-party tools that access SP-API can automate the full cycle including bank matching, so Amazon deposits clear in your bank feed without manual intervention.

How do I record Amazon sales and fees in QuickBooks?

The cleanest method is a daily summary journal entry: credit your revenue account for gross sales, debit separate expense accounts for each fee type (referral, FBA, storage, advertising), debit your returns account for refunds, and debit/credit your Amazon reserve liability for the reserve movement. The net of these entries should equal the Amazon payout for that settlement. Mapping each fee to its own QuickBooks account — rather than lumping everything into a single "Amazon fees" line — gives you the per-category visibility you need for meaningful P&L analysis.

What is the best QuickBooks integration for Amazon sellers?

It depends on your volume and how much manual work you're willing to accept. The free native connector works for low-volume sellers who don't mind reconciling payouts by hand. Third-party SP-API tools add automated settlement parsing and fee mapping, which pays off once you're moving meaningful volume or running FBA with multiple fee types. If you're selling across multiple marketplaces and want reconciliation fully managed, a service like Ceendesis Accounting handles the plumbing so your finance team isn't doing it by hand each cycle.

Which method should you pick?

Just starting out, or doing low volume on a single marketplace? The native connector gets you live in under half an hour at no extra cost. Accept that you'll still manually reconcile the settlement deposit, and move on. Once you're generating enough revenue that a misposted FBA fee actually distorts your P&L, a third-party connector with SP-API access is worth the subscription. The fee mapping alone will save your accountant hours every month.

And if you're running Amazon alongside Shopify, eBay, or Walmart — and you want per-channel COGS tracked properly without building the accounting infrastructure yourself — a managed approach is the honest choice. Either way, don't leave this unresolved. Unclear Amazon books make every decision downstream — pricing, inventory investment, expansion — harder than it needs to be. For more on building a coherent operations stack, our guide to multi-channel operations for growing brands is a practical next read.