Guides

Xero for Ecommerce Sellers: Setup, Plans, and Settlement Accounting

A practical guide to Xero for ecommerce sellers: multi-currency strengths, plan tiers, clearing accounts, summarized settlement journals, and Xero vs QBO.

Marcus Brandt, Head of Seller Accounting at BeanHawk

By Marcus Brandt · Head of Seller Accounting

Updated July 30, 2026

An Amazon deposit lands in your bank feed, say $18,742.16. Behind that single number sit hundreds of orders, referral fees, FBA fulfillment fees, refunds, a reserve adjustment, and sales tax Amazon collected on your behalf. If you let a Xero bank rule code that deposit straight to a Sales account, your revenue is understated, your fees are invisible, and your gross margin is fiction.

Xero is a genuinely good general ledger for ecommerce sellers, arguably the best choice for anyone selling outside the US or in multiple currencies. But like every general ledger, it knows nothing about marketplace settlements until you teach it. This guide covers what Xero does well, which plan to pick, and the specific setup that keeps seller books clean and audit-ready.

What Xero Is and Where It Shines

Xero is cloud accounting software built around three things: live bank feeds, a clean double-entry ledger, and a large app ecosystem. It started in New Zealand and grew up serving the UK, Australia, and New Zealand, which shows in its strengths: VAT and GST handling are first-class, and accountant adoption in those markets is deep. If your accountant is in the UK or Australia, odds are good they live in Xero all day.

For ecommerce specifically, three strengths matter most. First, multi-currency: Xero revalues foreign balances and tracks realized and unrealized FX gains, which is essential if you sell on Amazon UK or EU marketplaces and get paid in GBP or EUR while reporting in USD. Second, bank feeds and bank rules are fast and reliable, so reconciliation is quick once your structure is right. Third, most plans don't meter you per user, so you, a bookkeeper, and an accountant can all work in the file without a pricing fight.

What Xero is not: an ecommerce system. It has no native concept of an Amazon settlement, a Shopify payout, SKU-level inventory at scale, or marketplace facilitator tax. Those gaps are exactly what the seller-specific setup below fixes.

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

Xero Plans: What Sellers Actually Need

Xero has renamed and repriced its tiers several times, and pricing varies by country, so treat any numbers you see in blog posts (including approximate figures like 'entry plans around $20-$25 per month, top plans around $70-$90') as illustrative only. Check Xero's current pricing page for your region before you commit. Read Xero accounting software reviews with a filter as well, because most of them are written by service businesses, and the things that make Xero pleasant for an agency (quoting, projects, simple invoicing) have almost nothing to do with what makes it work for a seller.

What matters more than the price is which features sit on which tier. Two things trip up sellers. First, multi-currency has historically been reserved for Xero's higher tiers. If you sell internationally, verify your plan includes it before subscribing, because migrating up later mid-year is annoying. Second, entry-level plans typically cap the number of invoices and bills you can enter per month. If you post a handful of summarized settlement journals instead of thousands of individual orders (more on that below), even tight caps are workable, but confirm the current limits.

Rule of thumb: single-currency sellers can usually start on a mid-tier plan; anyone with Amazon UK/EU/CA income or supplier bills in foreign currency should budget for the tier that includes multi-currency from day one.

Why Marketplace Payouts Break a Default Xero Setup

Marketplaces pay you net. Amazon referral fees alone typically run 8-15% of the sale price depending on category, and that's before FBA fulfillment fees, storage, advertising deductions, refunds, and reserves. The deposit that hits your bank is gross sales minus all of that.

Worked example (illustrative numbers): suppose a two-week settlement shows $24,000 in product sales, $1,900 in shipping and gift wrap income, $3,100 in referral fees, $2,800 in FBA fees, $760 in refunds, $480 in ad spend deducted from the payout, and a $700 increase in Amazon's rolling reserve. The deposit is $18,160. Code that deposit to Sales and you've understated revenue by roughly $7,700 and recorded zero selling costs. Your P&L now shows a fantasy margin, your sales tax and income tax workpapers don't tie to anything, and your accountant bills you extra hours to untangle it at year-end.

Advertising deserves its own note, because PPC for ecommerce reaches your books through two different doors. Amazon deducts sponsored-ads spend inside the settlement, so it arrives through the journal, while Google and Meta bill your card and land in the bank feed. Post both to one Advertising account and you get a true total; use tracking categories if you want spend by channel, since Xero's home screen is a cash and bank view rather than an ecommerce dashboard and won't split it for you.

The deposit is not income. It's the settlement of a receivable. Once you internalize that one sentence, the correct Xero structure follows naturally.

The Clean Xero Seller Setup: Clearing Accounts and Settlement Journals

The standard professional pattern is one clearing account per sales channel plus one summarized journal per settlement or payout period. The clearing account (a current-asset account in your chart of accounts, e.g. 'Amazon Clearing') represents money the marketplace owes you. Each settlement, you post a journal that records gross sales, fees, refunds, and tax at summary level, with the net amount debited to the clearing account. When the deposit arrives in the bank feed, you reconcile it against the clearing account, not against revenue.

Done right, the clearing account hovers near zero after each reconciliation (timing differences and reserves keep a small balance), and any drift is an immediate signal that a settlement was missed or a payout was short. This is also the structure every competent ecommerce accountant expects to see, whether the journals are posted by hand or by a connector.

Clean Xero setup for marketplace sellers
  1. 1

    Build the chart of accounts

    Add one clearing account per channel (Amazon, Shopify, eBay, Walmart) plus income accounts for product sales, shipping income, and refunds, and expense accounts for referral fees, fulfillment fees, storage, and advertising.

  2. 2

    Create a facilitator tax liability account

    Add a liability account for marketplace-collected tax so it never lands in your income or your own sales tax payable.

  3. 3

    Post one journal per settlement

    For each Amazon settlement or Shopify payout period, post a summarized journal: credit gross sales and shipping income, debit fees, refunds, and ad deductions, and debit the net to the channel's clearing account.

  4. 4

    Reconcile deposits to clearing

    Match each bank-feed deposit to the clearing account, never to a revenue account. Kill any old bank rules that coded deposits to Sales.

  5. 5

    Handle reserves and timing

    Reserve increases stay in the clearing account as a receivable; they're your money, just delayed. Expect a small rolling balance, not zero.

  6. 6

    Review clearing monthly

    At month-end, tie the clearing balance to the marketplace's open settlement and reserve reports. Unexplained drift means a missed journal or a short payout.

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.

Marketplace Facilitator Tax in Xero

In most US states, marketplace facilitator laws make Amazon, Walmart, and eBay responsible for collecting and remitting sales tax on your marketplace orders. The tax shows up in your settlement data, but it was never your money and never your liability to remit.

The mistake to avoid: booking facilitator-collected tax as income (overstates revenue) or as your own sales tax payable (creates a liability you'll never remit, which sits on the balance sheet forever). The clean treatment is to include the tax collected and the matching tax withheld in the settlement journal so they net to zero through a facilitator tax liability account. Your P&L shows none of it; your balance sheet carries no phantom payable.

Direct-channel sales are different. On Shopify, you are usually the merchant of record, so tax you collect there is a real liability you owe to states where you're registered. Keep facilitator tax and direct-channel tax in separate accounts so the two never blur.

Sales tax is one piece of taxes for Amazon sellers, not the whole picture. Income tax treatment of inventory, reconciling the 1099-K to gross sales, and VAT or GST registration if you sell on foreign marketplaces are separate workstreams. Your ledger structure should make each of them easy to answer rather than try to solve them.

Facilitator rules, registration thresholds, and nexus standards vary by state and change over time, so treat this section as bookkeeping mechanics, not tax advice; confirm your registration and filing obligations with a sales tax professional or CPA.

Inventory and COGS: Where Xero Needs Help

Xero's tracked inventory works fine for a small catalog with steady costs, but ecommerce sellers hit its walls quickly. It caps the number of tracked items, values everything on a single average-cost method, and has no concept of landed cost, so freight, duties, and inbound shipping never make it into your per-unit numbers. For a seller restocking from overseas suppliers, that gap alone can overstate margin by several points without anyone noticing.

The pattern that scales is the same one settlements use: keep the detail outside, post summaries in. Run perpetual SKU-level inventory in a dedicated system that tracks purchase orders and landed cost, then post a monthly journal to Xero moving the sold units' cost from the inventory asset account into COGS. Your balance sheet carries an inventory figure you can defend, your P&L shows real gross margin by month, and Xero never chokes on ten thousand SKUs it was never designed to hold.

There's a point where this stops being an add-on question. Multiple warehouses, light manufacturing, or serious purchasing workflows push you toward ecommerce ERP software (NetSuite, Brightpearl, and the like), which folds inventory, purchasing, and accounting into one system, and at that point you replace Xero rather than extend it. That's a decision with a real implementation cost and a consultant attached, so most sellers are better served by dedicated ecommerce inventory management feeding summarized journals to Xero until the complexity genuinely demands more.

If you'd rather not build that muscle by hand, this is a core piece of what BeanHawk does alongside its settlement posting: perpetual SKU inventory valuation with a PO and landed-cost engine, feeding summarized COGS journals into Xero or QuickBooks Online, with flat all-channel pricing from $19/mo.

Choosing an Amazon Xero Integration

Nobody should hand-post settlement journals for long. The connector layer exists precisely because parsing a settlement report into a balanced journal is tedious, error-prone work that software does better, and the amazon xero integration you pick determines whether the clean structure above maintains itself or quietly rots.

Compare candidates on five points. Summarized journals, never per-order invoices. Automatic splitting of settlements that span a month-end, so revenue lands in the right period. Multi-channel coverage in one subscription, because adding an ebay xero integration and Shopify support later shouldn't mean two more tools with two more logics. Currency handling that posts each marketplace's settlement in its own currency so Xero's FX engine does the revaluation. And pricing that doesn't climb every time your order count does. A2X and Link My Books are the established names in this category, and any tool you shortlist should survive a line-by-line comparison of one month's journals against the raw settlement reports.

Xero vs QuickBooks Online for Sellers, Briefly

Both ledgers can carry an ecommerce business well, and the clearing-plus-journal pattern is identical in each. The honest split: QuickBooks Online has deeper US payroll and sales tax tooling and is what most US accountants default to; Xero is stronger for multi-currency, generally friendlier on user limits, and dominant with UK, EU, and Australian accountants. If your accountant has a strong preference, that preference is usually worth more than any feature difference.

Two related questions come up. QuickBooks Desktop vs Xero isn't really a live comparison for a new seller, since Desktop is locally installed software Intuit has been winding down for new US customers and the settlement connectors don't support it; you'd be weighing a maintained cloud ledger against a legacy one. And if you're already on one platform and want the other, a Xero to QuickBooks conversion (or the reverse) is a service, not a button. Specialist providers move your history for a fee, and the usual rule applies: convert at a year-end, then tie the opening balance sheet to the penny before you trust the new file.

Practical tiebreaker: selling primarily in the US with US advisors, pick QBO. Selling into or out of the UK/EU/AU, or paying suppliers in foreign currency, pick Xero. And since good connectors post to both ledgers, the choice of ledger doesn't lock in your automation stack.

Monthly Close Checklist for a Xero Seller File

A clean setup decays without a routine. Fifteen minutes of month-end discipline keeps the file trustworthy and makes tax season boring, which is the goal.

  • Confirm every settlement and payout period in the month has a posted journal; gaps show up as a clearing balance that won't tie out.
  • Tie each channel's clearing account to the marketplace's open-settlement and reserve reports.
  • Verify facilitator tax liability accounts net to zero for marketplace channels.
  • Reconcile direct-channel sales tax payable against your actual state filings.
  • Run the FX revaluation if you hold foreign-currency balances, and sanity-check realized gains/losses.
  • Compare gross sales per Xero to the marketplace's own sales reports; they should match at summary level before you trust the P&L.

Frequently asked questions

Does Xero integrate with Amazon directly?

Not natively. Xero has no built-in Amazon settlement importer, so sellers either post summarized settlement journals by hand or use a connector app that reads Amazon settlement reports and posts the journals automatically. Either way, the underlying structure (clearing account plus summary journal) is the same.

Is Xero good for Amazon sellers?

Yes, with the right setup. Xero for amazon sellers works best when a connector posts summarized settlement journals against a clearing account, and it's the stronger choice over QBO if you sell on Amazon UK, EU, or CA marketplaces, since multi-currency and VAT handling are Xero's home turf. Its weak spots are native inventory and US sales tax tooling, both solvable with add-ons.

Should I post every Amazon order into Xero as an invoice?

No. Order-level posting bloats the ledger, slows Xero down, can blow through plan invoice limits, and adds no accounting value since the settlement report already aggregates everything. One summarized journal per settlement gives you accurate revenue, fees, and tax with a fraction of the volume.

Which Xero plan do I need as an ecommerce seller?

It depends on currency. If all your income and bills are in one currency, a mid-tier plan is usually enough. If you sell on foreign marketplaces or pay suppliers in another currency, you need the tier that includes multi-currency, historically Xero's higher tiers. Prices and limits change, so check Xero's current pricing page for your country.

How do I handle Amazon reserves in Xero?

Treat reserve changes as part of the clearing account balance. When Amazon holds back funds, the clearing account simply carries a larger receivable; when the reserve releases in a later settlement, the deposit clears it. Don't expense reserves: they're delayed cash, not a cost.

Does Xero work for Shopify sellers too?

Yes, and the pattern is identical: one clearing account for Shopify payouts, one summarized journal per payout period. The main difference is tax, since on Shopify you're usually the merchant of record and the sales tax you collect is a real liability. When comparing shopify accounting software or connectors, prefer one tool that covers Shopify and your marketplaces together so every channel follows the same logic.

Is marketplace facilitator tax my responsibility in Xero?

For marketplace orders in states with facilitator laws, the marketplace collects and remits the tax, so it should net to zero in your books through a dedicated liability account, never hitting income or your own sales tax payable. Tax you collect on direct channels like Shopify, where you're the merchant of record, remains your real liability.

Put this on autopilot

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