how do i connect amazon to quickbooks online

Why Amazon and QuickBooks Don't Talk to Each Other on Their Own

QuickBooks Online was built for businesses that invoice a customer and get paid the invoiced amount. Amazon doesn't work that way. It nets everything, your revenue, its fees, your refunds, any reimbursements, and sometimes a reserve hold, into one deposit that lands in your bank account every one or two weeks. If you just import that bank deposit into QBO and call it income, you're overstating revenue and missing every expense that got netted out along the way.

That mismatch is the whole reason 'connect Amazon to QuickBooks' is even a question. You're not connecting two systems that speak the same language. You're building a translation layer between Amazon's settlement format and QuickBooks' chart of accounts, and that translation has to happen either by hand or through software.

Three Ways to Actually Connect Amazon to QuickBooks Online

There isn't one official button that links the two. Sellers generally pick one of three approaches, and the right one depends on order volume and how much time you want to spend on bookkeeping.

• •Manual CSV import: download settlement reports from Seller Central, categorize each line by hand, and enter journal entries into QBO. Works fine below roughly 50 to 100 orders a month, becomes a slow grind past that.
• •QuickBooks bank feed matching: let the bank deposit flow into QBO automatically and manually match it to a single 'Amazon income' category. Fast to set up, but it destroys the detail you need for gross sales, COGS, and fee reporting.
• •Dedicated Amazon accounting software: an app authenticates with your Seller Central account through Amazon's SP-API, pulls every settlement, breaks it into revenue, fees, refunds, and reimbursements, and pushes a clean journal entry (or invoice/expense pair) into QuickBooks Online automatically.

Step by Step: Connecting Through a Dedicated App

If you're using a purpose-built connector, the setup mechanics are similar across most tools. First you authorize the app to read your Seller Central data, which grants read-only access to orders, settlements, and inventory adjustments, not the ability to change anything in your Amazon account. Then you connect QuickBooks Online through Intuit's own OAuth login screen, so the app never sees your QBO password directly.

After both accounts are linked, you map Amazon's settlement line items to your existing chart of accounts: gross sales to a sales income account, referral fees and FBA fees to separate expense accounts, refunds to a contra-revenue account, and reimbursements to their own line so they don't get buried inside revenue. Most tools let you choose a sync frequency, daily or per settlement period, and a start date for how far back to pull historical data.

Run the first sync as a test batch before you let it run automatically. Check one settlement against the raw Seller Central report line by line. If the numbers match, turn on ongoing sync. This is also the point where Amazon accounting software that syncs to QuickBooks & Xero earns its keep, because it's handling the fee categorization logic you'd otherwise be rebuilding by hand every two weeks.

What Actually Gets Synced (and What Doesn't)

A well-built connection posts the components of a settlement separately, not as one lump number. That typically includes gross product sales, shipping charged to customers, referral fees, FBA fulfillment fees, storage fees, advertising spend, customer refunds, promotional discounts, and any inventory reimbursements Amazon issues for lost or damaged stock.

What most connectors don't handle automatically is cost of goods sold. Amazon doesn't know what you paid your supplier, so COGS still has to come from your own inventory records or a separate inventory management layer. This is one of the more honest trade-offs to flag: even a good sync gets you clean revenue and fee data, but landed cost and COGS matching usually need a manual process or a second tool on top.

Worked Example: One Amazon Settlement Booked Correctly

Say a 14 day settlement period shows gross product sales of $18,400 and customer-paid shipping of $210. Amazon deducted $2,760 in referral fees, $3,100 in FBA fulfillment and storage fees, and $340 in ad spend. Customers were refunded $612 for returns, and Amazon issued a $145 reimbursement for a warehouse-damaged unit. The net deposit that actually hits your bank account is $11,973.

Booked correctly, that becomes: Sales income $18,400, plus shipping income $210, minus referral fees $2,760, minus FBA fees $3,100, minus advertising $340, minus refunds $612, plus reimbursement income $145. Add it up and it nets to $11,943, close enough to the $11,973 deposit that the small gap is a timing difference from a reserve adjustment, which is normal and gets reconciled in the following settlement.

Compare that to the lazy version: one journal entry for $11,973 coded as 'Amazon income.' You'd have no visibility into your real gross margin, no separate ad spend line for tax purposes, and no record that $145 of that deposit wasn't sales at all.

Common Mistakes Sellers Make When Connecting Amazon to QuickBooks

The single biggest mistake is booking net deposits as gross revenue. It inflates your top line, understates your expense ratios, and makes your P&L useless for pricing decisions. A close second is ignoring reimbursements entirely, either missing them as income or, worse, mixing them into sales so they get double counted against inventory that's already been written off.

Sellers also frequently reconcile by calendar month instead of by settlement period, which never lines up since Amazon's pay cycle doesn't respect month-end. And a lot of sellers skip sales tax entirely because Amazon collects and remits it as a marketplace facilitator in most states, so it never touches their bank account, but it still needs to be tracked for filing and nexus purposes in states where you have other obligations.

Sales Tax and 1099-K: What Changes Once You're Connected

Since the Supreme Court's 2018 ruling in South Dakota v. Wayfair, states have been allowed to require out-of-state sellers to collect sales tax based on economic nexus, meaning sales volume or transaction count, rather than physical presence alone. In response, nearly every state with a sales tax has passed a marketplace facilitator law requiring Amazon itself to collect and remit tax on third-party sales. That's a meaningful chunk of commerce: third-party sellers now account for more than half of all physical merchandise sold on Amazon, which is part of why states pushed so hard for platform-level collection.

Practically, this means the sales tax Amazon collects from your buyers shouldn't show up as your income or your liability in QuickBooks, since Amazon is the one remitting it. What you still need to track separately is any 1099-K Amazon issues you for the year. The IRS reporting threshold for platforms like Amazon has been phased in over recent years rather than fixed, so check the current year's threshold rather than assuming the old $20,000 and 200-transaction rule still applies. Your booked gross sales in QuickBooks should reconcile against that 1099-K, and discrepancies are one of the first things to check if a filing gets flagged.

What to check in the first month after you connect

A connection that looks fine on day one can still drift. Give the first few settlement periods a deliberate review before you trust the numbers in a tax filing or a lender package. The checks are quick once you know what to look at, and catching a mapping error in week two is far cheaper than unwinding a year of miscoded journals.

Start with the bank line. Every settlement journal should reconcile to the exact deposit that hit your account, to the penny. If it doesn't, the usual culprits are a fee type that landed in an unmapped account, a reserve movement the connector treated as income, or a refund posted in a different period than the original sale. None of those are exotic, and all of them are easier to fix while you can still remember the month.

Then look at your gross sales figure. It should be noticeably larger than your deposits, because fees come out in between. A seller whose books show revenue roughly equal to what the bank received has almost certainly booked net deposits as income, which understates both revenue and expenses. The profit can still come out right while every ratio above it is wrong, and that's the version of the mistake that survives longest because nothing obviously breaks.

• •Does each settlement journal tie to the bank deposit exactly?
• •Is gross revenue clearly higher than net deposits?
• •Did any transaction type land in a suspense or uncategorized account?
• •Are refunds reducing revenue rather than posting as an expense?
• •Does inventory on the balance sheet move when units actually sell?

What to Do Next

Start by counting your monthly order volume and settlement frequency, since that decides whether manual entry is realistic or whether you need an automated connector. If you're running Amazon alongside Shopify or eBay, look for accounting software for Amazon sellers that also handles multi-channel ecommerce accounting, rather than bolting on a separate tool per channel; the same logic applies whether you're pairing Shopify accounting software or eBay accounting software with QuickBooks or with Xero for Amazon sellers.

Before turning on automatic sync, pull your last three settlement reports and manually verify how each line item should map to your chart of accounts. Backfill at least 90 days of history so your trend reports aren't starting from a blank slate. And build a habit of checking one settlement per month against the raw Seller Central data even after automation is running, because fee categories occasionally shift and you want to catch that before it skews a quarter's numbers.

If FBA reimbursements are part of your bookkeeping, know that Amazon's policy since 2025 values lost or damaged inventory based on your actual manufacturing or sourcing cost rather than retail price, using Amazon's own estimate unless you've submitted your real cost, per Amazon's FBA inventory reimbursement policy. That distinction matters for how much reimbursement income you should expect to see land in your books, and it's worth checking your submitted cost data if reimbursements look low.