Xero for Ecommerce FAQ

Xero works for ecommerce, but not on its own. Out of the box it is a general accounting system, and marketplace selling produces data shapes it was never designed to receive: settlement deposits that net a dozen fee types against gross sales, refunds that arrive weeks after the order, inventory that lives in someone else’s warehouse. The questions below are the ones sellers actually ask before and after they move onto Xero.

Can Xero handle Amazon and Shopify sales directly?

Not without help. Xero can receive the transactions, but something has to translate marketplace activity into journal entries first. Left alone, a Shopify payout or an Amazon settlement lands in your bank feed as a single net number. Categorizing that number as revenue is the most common ecommerce bookkeeping error there is, because it silently omits every fee, refund and reserve adjustment that was netted out of it.

The fix is an integration layer between the marketplace and Xero. Options range from summarized settlement journals to per-SKU detail, and the choice determines what questions your books can answer later.

Which Xero plan do I need?

Xero’s US lineup is Early, Growing and Established. Early is capped on invoices and bills and is generally too restrictive for an active seller. Growing removes those caps. Established adds inventory tracking, multiple currencies and project tracking.

Most marketplace sellers end up on Growing or Established. Whether you need Established depends on whether you want Xero itself holding inventory quantities, or whether an upstream tool handles inventory and posts the COGS entry into Xero. Both patterns are common. Check the current plan features and pricing on Xero’s own pricing page, since plan contents and promotional pricing both change.

Should I post summary journals or per-order detail?

This is the real decision, and it is worth thinking about before you pick a tool.

Summary journals post one entry per settlement period: gross sales, refunds, each fee category, and the net deposit. Your bank reconciliation is trivial because the journal ties exactly to the deposit. Your Xero file stays small and fast. What you give up is product-level visibility inside Xero.

Per-order or per-SKU detail gives you product-level revenue and COGS inside the accounting system, so you can run a profit and loss by product without leaving Xero. The cost is volume. A seller doing 8,000 orders a month who posts every order individually will have a slow file and a reconciliation that is harder to eyeball.

A reasonable rule: if you make product decisions from your accounting system, take the detail. If you make product decisions from an operational dashboard and Xero exists to produce financial statements and a tax return, take the summary.

How does Xero handle inventory for a marketplace seller?

Xero’s inventory on the Established plan is a tracked item system with a weighted average cost. It works well for a business holding inventory in one place with straightforward purchasing.

It is less comfortable with the shape of marketplace inventory: units split across your own warehouse, an Amazon fulfillment center and a third-party logistics provider, plus units in transit from a supplier, plus landed costs that need allocating across a shipment after the fact. Sellers with that profile usually keep inventory in a dedicated system and let Xero hold the resulting balance and COGS entry.

Whichever way you go, the requirement from a tax perspective is the same. As the IRS explains in Publication 538, a taxpayer who keeps inventories generally uses an accrual method for purchases and sales, and it lists the permitted valuation methods including FIFO, LIFO and specific identification.

What about sales tax?

Xero tracks sales tax on transactions but does not determine your obligations or file your returns. Marketplace facilitator laws mean the marketplaces themselves collect and remit on most of your marketplace sales in most states, so the tax you owe directly is usually driven by your own storefront. Establishing which is which is a question for your state’s department of revenue and a tax professional, not for your accounting software.

If you need calculation and filing, that is a separate product sitting alongside Xero rather than a Xero feature.

Why does my Xero revenue not match my Amazon dashboard?

Because they are measuring different things over different periods, and both can be correct.

Seller Central reports on order date. Settlements report on a two-week cycle that does not align to your month. Refunds are recorded when processed, not when the original sale happened. Reserves hold back funds that were earned. And advertising has its own billing cycle entirely: Amazon’s advertising help documentation is explicit that if you pay for ads through your seller account, your settlement period may not match your advertising billing cycle, and a single invoice can cover multiple settlement periods.

Expect a gap. What you should not accept is an unexplained gap. A monthly reconciliation from gross marketplace sales down to the deposits that hit your Xero bank account is the control that catches real errors, and it takes under an hour once the mapping is set up.

Can I use Xero across multiple marketplaces and one set of books?

Yes, and this is where Xero holds up well. One chart of accounts, tracking categories for channel, and an integration per marketplace posting into the same file. You get a consolidated profit and loss with channel-level detail underneath.

The constraint is upstream. Every channel has to be translated correctly before it reaches Xero, and channels differ in how they report fees, taxes and payouts. Products built for this include A2X, Link My Books and ConnectBooks, which sync Amazon, Shopify, Walmart, eBay and TikTok Shop activity into Xero with settlement reconciliation and COGS attached.

Xero or QuickBooks for an ecommerce seller?

Both are fine, and the integration you choose matters more than the ledger you sit it on. Xero is often preferred for its bank reconciliation workflow and multi-currency handling on the Established plan. QuickBooks has deeper penetration among US accountants, which is a real consideration if you want to hire locally, and QuickBooks Desktop Enterprise remains the answer for sellers with heavy inventory requirements that neither cloud product covers.

Pick based on who is going to do the work and what they already know. Migrating ledgers later is possible but tedious, and it is not the kind of project you want landing in the middle of a busy fourth quarter.

What should I set up first?

Chart of accounts before anything else, with separate accounts for each significant marketplace fee type rather than one bucket called “Amazon fees”. Then the integration. Then a reconciliation routine you run monthly and do not skip. Everything else can be improved later. Those three are hard to retrofit once twelve months of data is sitting on top of them.