featured article

FAQ: Xero for Ecommerce Sellers

Colleen Quattlebaum

August 2, 2026

Is Xero built for ecommerce?

No, and neither is any general ledger. Xero is a well built double entry accounting system with strong bank reconciliation and clean reporting. It has no concept of a marketplace settlement, a referral fee, a reserve balance, or a fulfillment center. Those things reach Xero through an integration or through a person doing data entry. Every question below follows from that.

Which Xero plan does a product seller need?

Xero's US lineup runs Early, Growing, and Established. The Early plan caps you at 20 invoices and 5 bills per month, per Xero's published plan details, which a seller with a supplier ledger will exhaust in days. Growing removes those caps. Established adds multiple currencies, project time and cost tracking, and expense claims.

The practical rule: Growing is the floor for a domestic single currency seller. Established is required the moment you hold a balance in a currency other than your base currency, because multi currency is not available below it.

Can Xero track inventory for an Amazon and Shopify seller?

Partly. Xero has tracked inventory items, and its own inventory page states you can manage up to 4,000 items. Xero values those items on an average cost basis and posts a cost of goods sold entry when you invoice the item.

What Xero does not do is the part multichannel sellers actually need. It does not hold stock by warehouse. It does not assemble kits, bundles, or multipacks. It does not track a container as in transit until you receive it. It does not allocate freight and duty across a mixed shipment to produce a real landed cost per unit. Xero's own inventory FAQ says reorder point automation comes from connected inventory apps rather than from Xero.

Those functions sit in the layer above the ledger. On ConnectBooks, warehouse level stock tracking, FIFO valuation, bundles and assemblies, in transit transfers, and landed cost allocation live on the inventory side of the product, with the resulting journal entries flowing into Xero.

Does Xero calculate cost of goods sold automatically?

For tracked items sold through a Xero invoice, yes, on an average cost basis. For a seller whose orders arrive through Amazon, Shopify, Walmart, eBay, and TikTok Shop and never touch a Xero invoice, no.

Here is why that matters, with numbers. Say you bought a SKU three times:

  • March: 800 units at 6.10 landed, total 4,880
  • June: 1,200 units at 8.45 landed, total 10,140
  • September: 600 units at 7.20 landed, total 4,320

Weighted average across all 2,600 units is 7.44. You sell 900 units in October.

  • Average cost method: 900 times 7.44 equals 6,696 of cost of goods sold.
  • FIFO: the first 800 units at 6.10 equals 4,880, plus 100 units at 8.45 equals 845, for 5,725.

A 971 difference on one SKU in one month, which is a 14.5 percent swing in reported cost for that item. Multiply across a catalog and the gross margin you report stops being the gross margin you earned. FIFO by SKU is what ConnectBooks produces, and it is the reason the cost figure in the ledger can be trusted.

How should marketplace fees be recorded in Xero?

Gross, in their own accounts, above or below the gross profit line depending on whether they scale with units.

Referral or commission fees and fulfillment fees scale with units and belong in direct costs. Storage, long term storage, and account subscription fees are closer to overhead. Advertising should always sit alone, never inside a general "marketplace fees" bucket, because it is the cost you tune weekly.

The error to avoid is netting. If a settlement contains 128,400 of gross sales and 50,272 of fees, and you record only the 78,128 that reached your bank, you have removed both the revenue and the cost from your books in one stroke.

Can Xero report profit by sales channel?

Yes, through tracking categories, and with a real constraint. Xero allows two active tracking categories per organization, with up to 100 options in each, according to Xero's tracking documentation.

Use one for Sales Channel. Use the second for Brand, Product Line, or Warehouse, depending on which question you ask more often. Once channel lives in a tracking category, Xero's profit and loss report produces a column per channel from a single set of revenue and cost accounts. That is the report worth building the chart of accounts around.

Does Xero handle sales tax for marketplace sellers?

Xero records sales tax. It does not determine your obligations.

In states with marketplace facilitator laws, the marketplace calculates, collects, and remits on your behalf. In your books, the tax collected and the tax withheld offset, and the net effect on your liability account is zero. Where a marketplace does not collect for you, and for direct to consumer sales through your own store, the liability is real and it is yours.

Nexus, registration, and filing are decisions for a CPA or your state's department of revenue. Do not read a balance in Xero and treat it as a compliance answer.

How many people can use Xero?

Xero's US pricing pages state that all plans include unlimited users at no additional cost. That is a genuine difference from seat priced ledgers, and it matters for sellers who want warehouse staff, an operations manager, and an outside accountant all looking at the same data.

Can Xero handle multiple currencies?

On the Established plan. If you sell in CAD, GBP, or EUR and bank in USD, budget for that tier from the start. Retrofitting multi currency onto a year of single currency transactions is slow and error prone.

What breaks first when a seller scales on Xero?

Three things, in roughly this order.

Cost of goods sold accuracy. The average cost model and the absence of landed cost allocation start producing margins that do not match reality, usually around the time a seller adds a second supplier or starts importing.

The item ceiling. Four thousand items sounds generous until you count variants, bundles, and multipacks as separate items, which they are.

Dimension count. Two tracking categories cover channel and one other thing. Sellers who want channel, brand, and warehouse simultaneously run out of room.

None of these are reasons to leave Xero. They are reasons to stop asking Xero to be an inventory system.

Does Xero replace a bookkeeper?

No. It changes what the bookkeeper spends time on. A well configured Xero file with clean marketplace data removes the transcription work and leaves the judgment work: cutoff at period end, reserve and in transit balances, inventory adjustments, accruals, and anything that looks wrong.

What about AI tools for ecommerce accounting?

The category is moving fast and most of what is marketed as AI accounting today is automated categorization with a chat interface on top. The harder problem is data quality, because a model reading a ledger with blended average costs and netted marketplace deposits will produce confident answers built on bad inputs.

ConnectBooks has announced Crunch, an AI CFO, and is running a waitlist ahead of release. The Crunch page describes what it will do when it opens up. Until then, the work that pays off is the unglamorous kind: gross recording of marketplace activity, FIFO costing by SKU, and clearing accounts that return to zero.

Where to start

Get the chart of accounts and tracking categories right before you connect anything, then automate the marketplace side so nothing is transcribed by hand. The Xero integration overview shows how the channels connect, the integrations directory lists the supported combinations, and pricing covers plan fit by order volume and channel count.

Take Control of Your E-Commerce Business with ConnectBooks

Running an e-commerce business comes with plenty of challenges, but ConnectBooks is here to make your life easier. With real-time insights, seamless integrations, and detailed tracking of your profitability and inventory, you can stay ahead of the game. Whether you’re selling on Amazon, Shopify, Walmart, TikTok or eBay, ConnectBooks helps you manage your finances with 100% accuracy and confidence, so you can focus on growing your business.

Ready to level up? Start making smarter, data-driven decisions every step of the way. Try ConnectBooks Free Today or Schedule a Demo