How to Connect Amazon to QuickBooks or Xero (Accounting)

Why manual bookkeeping fails for Amazon

Amazon doesn't deposit your sales revenue neatly. Every two weeks, you get a single lump-sum deposit that combines product sales, refunds, FBA fees, referral fees, storage fees, advertising charges, reimbursements, and adjustments. Trying to manually reconcile this with your accounting software is a recipe for inaccurate books.

The problem compounds with volume. At 100 orders per month, manual reconciliation is tedious. At 1,000+ orders, it's impossible. And inaccurate books don't just make tax season stressful; they prevent you from knowing which products are actually profitable. Many sellers discover that their "best-selling" product is actually losing money once all fees are properly allocated.

What data needs to sync

A proper Amazon-to-accounting integration should disaggregate every settlement into these categories:

• Product sales revenue — by SKU, so you can track profitability per product
• Referral fees — typically 15% of sale price, varies by category
• FBA fulfillment fees — per-unit pick, pack, and ship charges
• Storage fees — monthly and long-term, allocated by product
• Advertising costs — PPC spend allocated by campaign and product
• Refunds and returns — with fee clawbacks properly accounted
• Reimbursements — Amazon payments for lost/damaged inventory
• Other adjustments — promotions, coupons, Subscribe & Save discounts

Each of these needs to map to the correct account in your chart of accounts. Revenue goes to income, fees go to expenses, and COGS needs to be matched to the period the inventory was sold.

Integration options compared

You have three main approaches for connecting Amazon to your accounting software:

Manual entry: Download settlement reports, manually categorize in QuickBooks/Xero. Free but time-consuming (2-4 hours per settlement) and error-prone. Only viable below $50K/year.

Dedicated connectors (A2X, Link My Books): Automated disaggregation with direct posting to QuickBooks or Xero. $19-69/month depending on volume. The right choice for most sellers.

Jarvio financial summaries: AI-generated breakdowns pushed to Google Sheets or formatted for import. Best for sellers who want SKU-level profitability analysis alongside their accounting sync.

A2X: the gold standard

A2X has been the go-to Amazon accounting connector for years. It automatically fetches your settlement data, disaggregates every transaction, maps to your chart of accounts, and posts journal entries to QuickBooks Online, QuickBooks Desktop, or Xero. It handles multi-currency for international sellers and supports Amazon, Shopify, eBay, Walmart, and Etsy.

Pricing starts at $19/month for up to 200 orders. Most sellers at scale use the $69/month plan. The setup takes 30-60 minutes with their guided onboarding, and once configured, it runs automatically with each new settlement.

Link My Books

Link My Books is a newer alternative that offers similar functionality at a slightly lower price point. It connects to QuickBooks and Xero, disaggregates settlements, and handles multi-marketplace data. The UI is more modern and some sellers find the setup simpler. Pricing starts at £14.99/month ($19).

The main difference: A2X has broader marketplace support and more accounting software integrations. Link My Books focuses on simplicity and covers the core Amazon-to-QuickBooks/Xero use case well.

The Jarvio approach

While A2X and Link My Books handle the accounting software integration, Jarvio provides something complementary: operational financial intelligence. Jarvio pulls your Amazon data and generates structured summaries that break down revenue, fees, and profitability at the SKU level.

The difference: accounting connectors tell your bookkeeper what happened. Jarvio tells you what to do about it. Which SKUs are losing money? Where is your PPC spend inefficient? Which products have rising return rates eating into margins? Build a complete profit & loss statement with the data Jarvio provides.

Common accounting mistakes

Recording deposits as revenue: Amazon's deposit is not your revenue. It's revenue minus fees minus refunds plus reimbursements. Recording the deposit as revenue inflates your income and understates your expenses.

Ignoring COGS timing: Your cost of goods should be recorded when the product sells, not when you purchase inventory. This affects your profit calculations and tax obligations significantly.

Missing sales tax obligations: If you're using FBA, Amazon stores your inventory in multiple states, potentially creating nexus and sales tax obligations. While Amazon collects and remits marketplace facilitator tax in most states, you may still have filing obligations. Consult your accountant.

Not reconciling reimbursements: Amazon reimbursements are income. They need to be tracked and categorized properly. If you're also using Jarvio to scan for FBA reimbursements, make sure those claims flow through to your books once paid.