How to reconcile Amazon and Shopify payouts in Xero with A2X

A marketplace payout is a net figure. Between the customer paying and the money reaching your account, the platform takes referral fees, fulfilment and storage charges, advertising, subscription costs, shipping it collected on your behalf, and the refunds it has already handed back. Some of those lines carry VAT, some do not, and some are charged from outside the UK, which changes how they belong in your return entirely.

If you treat the deposit as a sale, your turnover is understated by every fee the platform took, your input VAT is understated by every fee you could have reclaimed on, and your gross margin is a number with no meaning. We see this most often where a seller has grown past the point where the old method held up, and the bank feed is being coded to one sales account by whoever has the afternoon free.

The other common version is the opposite: every single order imported into Xero as its own invoice, tens of thousands of lines a year, and a bank deposit that still does not tie to anything. Volume is not accuracy.

A2X sits between the channel and your ledger. It takes the settlement report behind each payout, groups everything in it by type, and posts one summarised document into Xero for that payout period. Sales grouped by tax treatment, fees grouped by kind, refunds shown as refunds, and the total of the document equal to the money that arrived.

That is the part people describe as automation. The part that matters is the grouping. A2X can only group sales the way the channel reports them, so the quality of what lands in Xero depends on whether your channel settings tell the truth about where your goods are and where your customers are. A UK seller shipping from a UK warehouse to Germany is in a different position from one holding stock in Europe, and the settlement will carry that information if the account is set up for it.

Where a payout straddles a month end, the summary is split so each side falls in the right period. That alone makes management accounts worth reading, because sales and the fees that produced them finally sit in the same month.

Mapping is the hour that decides the next three years. Every line type A2X finds in a settlement needs an account in your Xero chart and a tax rate against it. The default templates get you moving, and they are written for a general seller rather than for yours.

The decisions we take most care over:

• UK sales against overseas sales, kept in separate accounts so the split is visible without anyone digging. One client selling watches had around 70 per cent of her sales going overseas and nobody had ever looked at the split, which is also how she ended up on the wrong VAT scheme.
• Platform fees charged from abroad, which belong under the reverse charge rather than as a plain cost.
• Refunds and returns posted as reversals in the right period, not netted quietly into sales.
• Shipping income, gift cards and promotional discounts, which are three different things and are routinely coded as one.

Get those right and the VAT return builds itself out of the ledger. Get them wrong and you are correcting quarters later, from a position where nobody remembers what the original figures meant. The detail on fees and overseas treatment is in our guide to import VAT and the reverse charge.

Amazon gives you one settlement and one deposit. Shopify gives you Shopify Payments on its own schedule, plus PayPal, plus Klarna or Clearpay, plus whatever else you switched on last Black Friday, and each of those pays you separately with its own fee deduction and its own timing.

So the connection has to cover every gateway, otherwise a chunk of your income arrives in the bank with nothing to match against and gets coded by hand, which is where the errors creep back in. We also look hard at three Shopify specifics: gift cards, which are not income until they are redeemed; marketplace facilitator rules on some channels, where the platform has already accounted for the VAT and you must not account for it again; and manual refunds issued outside the normal flow.

One more thing on Shopify. Chargebacks and payment holds move money in a direction nobody expects, and they will sit unreconciled for weeks if the person doing the bookkeeping has not been shown what they look like. We set clients up and then show them what to look for, because the point is that you can run it yourself most months.

Before we let a connection run unattended, we post one payout and take it apart. The settlement total has to equal the bank receipt to the penny, with no rounding account quietly absorbing the difference. Then we read the tax rates line by line against what the channel reported, because a sale coded as standard rated when it was zero rated looks completely normal on a profit and loss.

After that, three habits keep it honest:

1. Every month, check that no A2X document is sitting unreconciled. One stuck payout usually means a gateway nobody connected.
2. Every quarter, before the VAT return, look at the refunds account on its own and ask whether the figure is plausible for the volume you sold.
3. Every year end, compare the sales in Xero against the channel’s own annual reports. If they differ by more than the timing of the last payout, something in the mapping has drifted.

Seller bookkeeping that is checked quarterly is cheap to run. Seller bookkeeping that is checked once, at the year end, is an expensive archaeology project, and you only find out what the mapping cost you after the VAT has already been paid.