If your WooCommerce sales never quite match what lands in your bank, the problem usually isn't your maths. It's that you're trying to reconcile a single bank payout against dozens of individual orders, each carrying its own VAT, gateway fee and refund.
The fix is a properly structured chart of accounts in Xero plus a payment clearing account that sits between your shop and your bank. Get that right and a £29,450 Stripe payout reconciles in seconds instead of an afternoon.
This is a hands-on guide for UK WooCommerce sellers. It covers the exact accounts to create, how a clearing account works, where VAT lands, and the tech-cost question your accountant will ask at year end. We've written it for sole traders and limited companies running a self-hosted WooCommerce shop, which changes more than you might think.
What's different about WooCommerce versus a marketplace?
WooCommerce is self-hosted, so you are the only person accounting for anything. There's no marketplace operator collecting VAT for you, no platform report filed on your behalf, and no deemed-supplier rule. You self-declare every sale, every fee and every VAT figure yourself.
This is the single most important thing to understand before you touch Xero, so it's worth being precise about it.
Why does self-hosting change your bookkeeping?
On Amazon or eBay, the marketplace can be the "deemed supplier". For goods located outside the UK in a consignment of £135 or less, or goods already in the UK sold by an overseas seller, the online marketplace is liable to charge and account for the UK VAT on your sale, not you (gov.uk: VAT and overseas goods sold to customers in the UK using online marketplaces). The platform also reports your seller income to HMRC under the digital platform reporting rules that took effect from 1 January 2024 (gov.uk: Reporting rules for digital platforms).
A self-hosted WooCommerce shop is none of those things. Those reporting rules apply to platforms that connect multiple sellers with customers, not to a business selling through its own website. So nothing is collected, declared or reported for you. Your Xero file is the only record HMRC will ever see, which makes a clean chart of accounts a compliance issue, not just a tidiness one.
Why is WooCommerce VAT plugin-driven, and why does that matter?
WooCommerce calculates VAT through its tax settings and, very often, a third-party tax plugin. That means VAT is only as right as your configuration. A wrong tax class on a product, a rule that applies 20% to a zero-rated item, or a plugin set to "prices include tax" when your accounts assume otherwise will quietly push the wrong number into Xero on every order.
Misconfiguration is a real and common failure mode here. The standard UK VAT rate is 20%, the reduced rate is 5% and the zero rate is 0% (gov.uk: VAT rates). Your plugin needs to apply the right one to each product, and your chart of accounts needs a clean place for the VAT to land so you can check it.
What is a clearing account and why do you need one?
A clearing account is a temporary holding account in Xero that captures the full value of a sale, then nets off the fees and the bank payout so the balance returns to zero. It turns one confusing bank deposit into a tidy, reconciled set of entries.
Here's the problem it solves. A customer pays £60 for an order. Stripe takes its fee and, a few days later, pays you a lump sum covering many orders at once, minus all the fees. Your bank statement shows one figure that matches none of your individual sales. Without a clearing account, you're stuck trying to reverse-engineer the gross sales and fees out of a single net deposit.
With a clearing account, the flow becomes simple:
- The full gross sale is recorded into the clearing account when the order is placed.
- The gateway fee is recorded out of the clearing account to a fees expense account.
- The bank payout is recorded out of the clearing account to your bank.
- The clearing account nets to zero. If it doesn't, something is missing, and that's exactly the signal you want.
You need one clearing account per payment provider: one for Stripe, one for PayPal, one for any other gateway. Mixing them defeats the purpose.
How do you build the WooCommerce chart of accounts in Xero?
A chart of accounts is just the named list of accounts your transactions get coded to. The goal is enough detail to answer real questions (what's my true gateway cost? what VAT do I owe?) without so many accounts that coding becomes a chore.
Below is a practical starting structure for a UK WooCommerce business. Adjust the account codes to fit your existing Xero numbering.
| Account | Type | Typical use |
|---|---|---|
| Sales - WooCommerce | Revenue | Net (ex-VAT) value of standard and reduced-rated sales |
| Sales - Zero-rated | Revenue | Net value of zero-rated goods (so they're easy to check) |
| Shipping income | Revenue | Delivery charged to the customer (follows the VAT liability of the goods) |
| Stripe clearing | Current asset | Holds gross Stripe sales until the payout reconciles |
| PayPal clearing | Current asset | Holds gross PayPal sales until the payout reconciles |
| Payment processing fees | Expense | Stripe, PayPal and other gateway fees |
| Refunds and returns | Revenue (contra) | Refunds, so gross and net sales stay visible |
| VAT (control) | Current liability | Output VAT collected, set by Xero's tax rates |
| Hosting and software | Expense | Recurring hosting, plugin and SaaS subscriptions |
| Website development | Fixed asset / capital | One-off build costs (see the capital question below) |
How should you map WooCommerce tax classes to Xero tax rates?
Each WooCommerce tax class needs to map to the correct Xero tax rate so VAT lands in the VAT control account automatically. Standard-rated products map to Xero's 20% VAT rate, reduced-rated to 5%, and zero-rated goods to the zero-rated rate, all of which mirror the official UK rates (gov.uk: VAT rates).
The discipline that saves you at quarter end: keep zero-rated sales in their own revenue account. When you glance at your profit and loss, you can immediately see whether your zero-rated total looks plausible, rather than discovering a plugin misconfiguration only when HMRC asks.
Worked example: reconciling a month of Stripe sales
Illustrative example. Maya runs a self-hosted WooCommerce shop selling standard-rated homeware. In one month she takes 500 orders worth £30,000 including VAT, all through Stripe. Stripe charges 1.5% plus 20p per transaction. Maya is VAT registered and on standard VAT accounting.
First, split the gross into net sales and output VAT. With the standard rate at 20% (gov.uk: VAT rates):
- Net sales: £30,000 / 1.20 = £25,000
- Output VAT: £30,000 - £25,000 = £5,000
Check: £25,000 x 20% = £5,000, and £25,000 + £5,000 = £30,000. Correct.
Next, the Stripe fees:
- Percentage fee: £30,000 x 1.5% = £450
- Per-transaction fee: 500 x £0.20 = £100
- Total fees: £450 + £100 = £550
So Maya's Stripe payout to her bank is £30,000 - £550 = £29,450.
Here's how that books through the Stripe clearing account:
| Step | Account | Debit | Credit |
|---|---|---|---|
| 1. Record gross sales | Stripe clearing | £30,000 | |
| Net sales | Sales - WooCommerce | £25,000 | |
| Output VAT | VAT (control) | £5,000 | |
| 2. Record gateway fees | Payment processing fees | £550 | |
| Stripe clearing | £550 | ||
| 3. Record bank payout | Bank | £29,450 | |
| Stripe clearing | £29,450 |
Now check the clearing account: £30,000 in, less £550 of fees, less the £29,450 payout, equals £0. It nets to zero, so everything is accounted for. If it had left a stray £40 balance, that's your prompt to find a missing refund or fee, before it becomes a year-end mystery.
A practical note many sellers miss: the £550 of Stripe fees is itself a cost you record gross. You don't only book the net £29,450, because doing so hides £550 of deductible expense and £550 of activity from your records. Booking the full gross sale and the fee separately keeps both your turnover and your costs honest.
Where do these figures go on the VAT return?
For Maya's month, the output VAT of £5,000 feeds into the VAT she owes, and the £25,000 of net sales forms part of her total sales value. Xero builds the return from the VAT control account automatically, which is precisely why the tax-rate mapping has to be right at the WooCommerce end.
VAT-registered businesses must keep records of everything bought and sold and hold them for at least 6 years, and Making Tax Digital for VAT requires those records to be kept digitally and the return filed through compatible software (gov.uk: Keeping VAT records; gov.uk: Making Tax Digital for VAT). A clean Xero chart of accounts is how you meet both requirements without separate spreadsheets. If you're getting close to the £90,000 VAT registration threshold, that's the moment to make sure this is set up properly (gov.uk: VAT registration thresholds).
If you'd rather hand the whole reconciliation off, our ecommerce accounting service is built around exactly this WooCommerce-to-Xero flow.
How do you treat WooCommerce tech costs: capital or revenue?
Your tech stack is a tax question, not just a cost. The recurring running costs are usually revenue expenses you deduct in the year. The one-off cost of building the site itself can be capital. HMRC draws this line clearly.
HMRC's guidance uses a shop-window analogy: "The cost of a web site is analogous to that of a shop window. The cost of constructing the window is capital; the cost of changing the display from time to time is revenue" (gov.uk: BIM35815). In other words, building the shop is capital, running it is revenue.
| Cost | Likely treatment | Why |
|---|---|---|
| Initial WooCommerce site build / bespoke development | Capital | Creating the asset, like constructing the shop window |
| Monthly hosting | Revenue | Ongoing running cost |
| Plugin and theme subscriptions (annual/monthly) | Revenue | Recurring licence to use, not an enduring asset |
| Routine content updates and small tweaks | Revenue | Changing the display |
| A significant rebuild that creates lasting new functionality | Often capital | Enduring benefit to the business |
This is a judgement call at the margins, and HMRC's own software guidance accepts that the treatment of a software cost depends on the role it plays in the business (gov.uk: BIM35810). Where a one-off build is capital, a limited company may be able to claim capital allowances, with the Annual Investment Allowance currently set at £1,000,000 of qualifying plant and machinery (gov.uk: Annual Investment Allowance). The point for your chart of accounts is simple: don't dump a £6,000 bespoke build into the same "software" expense line as your £15 monthly plugin renewals. Split them, and let your accountant decide the treatment.
Key takeaways
- WooCommerce is self-hosted, so you self-declare all VAT and sales. No marketplace collects or reports anything for you.
- Use one clearing account per payment provider. It should always net to zero once sales, fees and the payout are booked.
- Map every WooCommerce tax class to the correct Xero VAT rate, and keep zero-rated sales in their own account so misconfigurations show up fast.
- Book gateway fees gross, not netted off the payout, so your turnover and costs stay accurate.
- Split one-off site build costs (often capital) from recurring hosting and plugin fees (revenue).
Frequently asked questions
Do I need a separate clearing account for Stripe and PayPal?
Yes. Each payment provider pays you on its own schedule and takes its own fees, so a single shared clearing account would never cleanly net to zero. One clearing account per gateway keeps each provider's sales, fees and payouts isolated and easy to reconcile.
Does WooCommerce report my sales to HMRC like Amazon or eBay?
No. The digital platform reporting rules that took effect on 1 January 2024 apply to platforms that connect multiple sellers with customers, not to your own self-hosted shop. You are responsible for declaring all your WooCommerce income to HMRC yourself (gov.uk: Reporting rules for digital platforms).
Should I record WooCommerce sales gross or net of fees?
Record them gross. Book the full sale value into the clearing account, then record the gateway fee as a separate expense. If you only post the net amount that hits your bank, you hide a deductible cost and understate your turnover.
How long do I have to keep my WooCommerce VAT records?
VAT-registered businesses must keep VAT records for at least 6 years, and under Making Tax Digital those records must be kept digitally and the return filed through compatible software (gov.uk: Keeping VAT records). A maintained Xero file meets both requirements.
Is my WooCommerce website build a tax-deductible expense?
It depends on whether it's a one-off build or an ongoing cost. HMRC treats building a site like constructing a shop window (capital) and routine updates like changing the display (revenue) (gov.uk: BIM35815). Recurring hosting and plugin subscriptions are normally revenue expenses you deduct in the year.
Talk to an e-commerce accountant →
Want this set up properly?
If your WooCommerce payouts and Xero never seem to agree, we can build the chart of accounts and clearing setup for you and keep it reconciled every month. Book a free 20-minute call with a Zmartly accountant through our ecommerce accounting service.
