Guides

Amazon Accounting in QuickBooks & Xero: Setup That Actually Reconciles

How to connect Amazon to QuickBooks Online or Xero the right way: summarized settlement journals, the chart of accounts to use, marketplace facilitator tax, multi-currency, and the mistakes to avoid.

Marcus Brandt, Head of Seller Accounting at BeanHawk

By Marcus Brandt · Head of Seller Accounting

Updated June 12, 2026

QuickBooks Online and Xero are both excellent general ledgers — and both are blind to how Amazon actually pays you. The integration layer between Amazon and your ledger is what determines whether your books reconcile in five seconds or fall apart at tax time. Here's the setup that professional ecommerce accountants use.

See it in BeanHawk

Every settlement becomes one clean journal

BeanHawk parses each marketplace payout line by line and posts a single summarized journal to QuickBooks or Xero — sales, fees, refunds, facilitator tax, and reimbursements mapped to the right accounts, balanced to the penny.

  • Debits equal credits or it won't post — no more deposits booked as revenue
  • Marketplace facilitator tax routed to a liability account, out of your income
  • The net deposit lands in a clearing account that matches your bank feed exactly
See the QuickBooks & Xero sync →
app.beanhawk.com/books/settlementsBeanHawkDashboardReimbursementsBooksInventoryChannelsJRJordan R.Owner · Pro planSettlement → journalSettlement #90417Amazon · 14-day payout1,204 orders3,918 fee lines212 refunds1 net deposit$6,853.70 depositedOne deposit hidesa dozen line items.autoJournal entryPostedACCOUNTDRCRProduct sales12,480.00Referral fees1,872.00FBA fulfilment fees2,104.50Refunds640.00Facilitator tax (liability)1,014.20Reimbursements218.40Bank — net deposit6,853.70Balanced15,630.5015,630.50→ QuickBooks→ Xero

The architecture: settle, summarize, reconcile

One settlement = one journal entry. Each Amazon payout becomes a single summarized journal with totals per account, and its net lands in an 'Amazon Clearing' account that matches the bank deposit exactly. Sales tax that Amazon collects and remits as marketplace facilitator goes to a liability (or is excluded) — it is not your income. Multi-currency marketplaces (amazon.co.uk, .de, .ca) post in their own currency and let your ledger handle FX.

See what Amazon owes you — free

Connect your seller account and get a free reimbursement audit. No credit card, keep 100% of what you recover.

Common mistakes that wreck seller books

  • Recording deposits as sales (understates revenue AND expenses).
  • Syncing every order as an invoice (ledger bloat; reconciliation gets harder, not easier).
  • Booking marketplace-facilitator tax as income (overstates revenue, creates phantom liability).
  • Ignoring reserves (this period's held funds make deposits mismatch sales periods).
  • Letting unknown fee types fall into a catch-all account silently (margin analysis dies quietly).

Set it up in minutes

BeanHawk connects to Amazon (all marketplaces, multiple seller accounts), QuickBooks Online, and Xero. It seeds the chart-of-accounts mapping with professional defaults, lets you or your accountant adjust everything, blocks posting until the journal balances to the penny, and flags any new Amazon transaction type for review instead of guessing. Accountants can save a mapping template once and apply it to every client.

Frequently asked questions

Does QuickBooks integrate with Amazon directly?

QuickBooks' native commerce features don't produce settlement-accurate seller books. You need a settlement-level connector that posts summarized journals reconciling to deposits.

Xero or QuickBooks for Amazon sellers?

Both work well. US sellers usually pick QuickBooks Online; UK/EU/AU sellers often pick Xero. BeanHawk supports both with identical features.

How is marketplace facilitator tax handled?

Tax Amazon collects and remits should never be booked as your income — map it to a liability or exclude it. BeanHawk's default mappings handle this.

Put this on autopilot

BeanHawk recovers what Amazon owes you and keeps your books penny-accurate — every channel included, from $19/mo.