How to Sync Amazon Sales to QuickBooks Online (Step-by-Step)

Connecting Amazon Seller Central to QuickBooks Online with SyncTools eliminates manual CSV exports and reconciles every sale, FBA fee, refund, and bi-weekly settlement automatically — so your books stay accurate without touching a spreadsheet.

TL;DR: Amazon’s bi-weekly settlement reports bundle dozens of fee types into a single net figure. SyncTools splits every transaction — FBA fees, referral fees, refunds, advertising credits — into separate QuickBooks line items and matches each settlement to your bank deposit automatically. Setup takes under 15 minutes; reconciliation drops from hours to one click.

Why Manual Amazon-to-QuickBooks Sync Breaks Down

Most Amazon sellers start the same way: download the settlement report, paste it into a spreadsheet, manually enter totals into QuickBooks. It works for the first few hundred orders. Then it doesn’t.

The problems are structural, not personal:

• Amazon settlement reports are summaries, not line items. A single CSV hides dozens of fee types — referral fees, FBA storage, returns, advertising credits — all collapsed into one net figure.
• Payout timing creates phantom gaps. Amazon pays every two weeks. QuickBooks records revenue when the sale happens. The two-week lag makes your bank reconciliation permanently out of sync.
• Refunds hit a different cycle. A return processed on day 8 might not appear in your settlement until day 22. Manual tracking means you’re always chasing it.
• Multi-marketplace complexity multiplies. If you sell on Amazon US, UK, and Canada, you’re tripling the manual work — plus managing currency conversion.

The result is hours of reconciliation work each month, a high error rate, and financial statements your accountant has to re-check every quarter.

What You Need Before You Start

Before connecting Amazon to QuickBooks Online via SyncTools, confirm you have:

• An active Amazon Seller Central account (Individual or Professional plan — both work)
• A QuickBooks Online account (Essentials, Plus, or Advanced)
• A SyncTools account — start a free trial if you don’t have one
• Admin access to both platforms — SyncTools uses OAuth, so no API keys required

You do not need to be a developer. The entire setup is point-and-click.

Step-by-Step: Connect Amazon to QuickBooks Online

Step 1 — Connect Amazon Seller Central

Log into SyncTools and navigate to Integrations → Add Source. Select Amazon Seller Central.

SyncTools opens an Amazon authorization page. Sign in with your Seller Central credentials and click Authorize. SyncTools receives read access to your orders, settlements, and fee reports — it never writes to or modifies your Amazon account.

For multi-marketplace sellers, you can authorize multiple Amazon regions (NA, EU, FE) from the same SyncTools account.

Step 2 — Connect QuickBooks Online

Back in SyncTools, go to Integrations → Add Accounting System and select QuickBooks Online.

Click Connect and complete the QuickBooks OAuth flow. SyncTools requests read/write access to transactions, chart of accounts, and bank feeds. Authorization takes about 30 seconds.

Step 3 — Map Amazon Categories to QuickBooks Accounts

This step is where most integrations fail, and where SyncTools earns its keep.

Amazon generates dozens of transaction types in a single settlement period. SyncTools surfaces each one and lets you map it to the right QuickBooks account:

Amazon Transaction Type	Suggested QuickBooks Account
Product sales	Sales / Revenue
FBA fulfilment fees	Cost of Goods Sold or FBA Fees (expense)
Referral fees	Selling Expenses
Storage fees	Inventory or Storage Costs (expense)
Advertising credits	Marketing / Advertising (expense)
Refunds	Returns & Allowances
Amazon settlement payout	Checking / Operating Account

SyncTools pre-populates sensible defaults based on your QuickBooks chart of accounts. Review each mapping and adjust to match your accounting method (accrual vs. cash).

Step 4 — Configure Sync Settings

Choose how you want SyncTools to push data:

• Sync frequency: Real-time (within minutes of each transaction) or daily batch. Most sellers choose daily for cleaner QuickBooks entries.
• Transaction grouping: Sync each order individually, or group by day/settlement period. Grouping reduces QuickBooks clutter; individual sync gives maximum audit trail detail.
• FBA fee line items: Enable this to see each fee type as a separate QuickBooks line item rather than a net figure.
• Settlement matching: SyncTools can automatically match each Amazon bank deposit to the corresponding QuickBooks bank feed entry.

Step 5 — Run Your First Sync and Verify

Click Sync Now. SyncTools pulls your last 90 days of Amazon transactions by default (configurable up to 2 years for historical backfill).

Check these three things after your first sync:

1. Revenue total — does the QuickBooks sales figure match your Amazon Seller Central dashboard for the same period?
2. FBA fee total — are fulfilment and referral fees appearing as expenses, not deductions from revenue?
3. Refunds — do returns appear as credit memos, not negative sales?

If anything looks off, SyncTools provides a per-transaction reconciliation report that shows exactly where each Amazon line item landed in QuickBooks.

Reconciliation Tips: FBA Fees, Refunds, and Payout Timing

Getting the connection working is step one. Getting it right takes a few more decisions.

FBA Fees: Separate Them from COGS

Many Amazon sellers lump FBA fees into Cost of Goods Sold. This works, but it hides your true product margin. Consider creating dedicated expense accounts for:

• FBA Fulfilment Fees (per-unit shipping and handling)
• FBA Storage Fees (monthly inventory holding cost)
• Referral Fees (Amazon’s commission, typically 8–15%)

With separate accounts, your P&L shows which cost center is growing — essential when you’re deciding whether to switch products or renegotiate with Amazon.

Refunds: Match Them to the Original Sale

Amazon’s refund process is asynchronous — a refund approved today might not clear until next week. SyncTools captures the refund date from Amazon (not the payout date) and creates a QuickBooks credit memo matched to the original invoice. This keeps your accrual accounting clean.

For cash-basis sellers, SyncTools can be configured to record refunds on the settlement date instead.

Amazon Payout Timing: Eliminate the Two-Week Gap

Amazon disburses every 14 days. If you’re on accrual accounting, this creates a permanent reconciliation gap: sales recorded on day 1, cash received on day 14.

SyncTools handles this with a deferred cash account approach:

1. Sales are recorded to revenue on the transaction date.
2. The gross amount is held in an Amazon Clearing account (a current asset).
3. When the settlement pays out, SyncTools moves the net amount to your bank account and posts fees to expenses — all automatically.

Your bank reconciliation then becomes a one-click match rather than a 2-hour investigation.

Link This Guide to Your Integration Setup

This post covers the accounting side. For the detailed SyncTools setup walkthrough — including screenshots of each configuration screen — see the Amazon QuickBooks Online integration guide.

For pricing and plan details, visit the SyncTools pricing page.

Frequently Asked Questions

Can I sync Amazon FBA fees to QuickBooks automatically?

Yes. SyncTools maps FBA fulfilment fees, storage fees, and referral fees to separate QuickBooks expense accounts automatically, so each cost appears on its own line rather than buried in a net settlement figure.

How does SyncTools handle Amazon refunds in QuickBooks?

Refunds are captured as separate credit memo transactions in QuickBooks, linked to the original sale. This keeps your books balanced without manual adjustments, and works for both accrual and cash-basis accounting.

How long does it take to set up the Amazon QuickBooks integration?

Most sellers complete the initial setup in under 15 minutes. SyncTools uses OAuth for both platforms — no API keys or developer credentials needed.

Does SyncTools work with both Amazon FBA and FBM orders?

Yes. SyncTools syncs both Fulfilled by Amazon (FBA) and Fulfilled by Merchant (FBM) orders, with separate fee handling for each fulfilment type and support for multiple Amazon marketplaces.

What happens when Amazon pays out every two weeks?

SyncTools matches each Amazon settlement report to your QuickBooks bank feed using a clearing account approach. The bi-weekly deposit reconciles in one click rather than hours of manual matching.

Related Guides

• Amazon to QuickBooks Online integration overview — platform features, pricing, and comparison
• TikTok Shop QuickBooks Integration Guide — for multi-channel sellers also selling on TikTok Shop (referral fees, affiliate commissions, sales tax handling)
• How to Sync Shopify to QuickBooks Online — same setup process for Shopify sellers
• How to Sync WooCommerce to QuickBooks Online — for WooCommerce store owners
• Amazon Seller Accounting: The Complete 2026 Guide — accounting fundamentals behind the integration

Start Syncing Amazon to QuickBooks Today

Manual CSV exports and spreadsheet reconciliation cost the average Amazon seller 4–6 hours per month — hours that compound into days by year-end. SyncTools eliminates that work on day one.

Start your free trial — no credit card required. Connect Amazon and QuickBooks in under 15 minutes.