Insights · 17 November 2026
Margin by channel for Amazon and Shopify sellers: the Xero set-up
How to set up Xero so every Amazon and Shopify sale arrives with its fees, VAT and cost of goods split out, based on J&B Finance's work with BrainGain.
If you sell on Amazon and Shopify, the money that reaches your bank is net of fees, refunds and sometimes VAT. Typed into a spreadsheet from channel reports, it rarely matches recorded sales, and margin by channel becomes guesswork.
This is the set-up we built for BrainGain, which sells home-gym equipment through Amazon, its own Shopify stores and direct sales across the UK and Europe.
The set-up
- A chart of accounts built for e-commerce. Sales, fees, refunds and cost of goods are separated by channel.
- Amazon and Shopify connected through Link My Books. Sales post to Xero automatically, settlement by settlement.
- Product costs loaded. Cost of goods posts with each sale instead of being estimated separately.
- Automated VAT reporting. In BrainGain's case for Germany, the Netherlands and EU OSS.
- Every bank and card connected. Bank accounts, Wise card spend and American Express feed Xero; receipts are captured in Hubdoc.
- One management pack. The UK and Irish Xero files come together in Google Sheets for the management pack and the cash forecast.
What changes
- Each payout matches the bank in one click.
- Revenue and gross margin are visible by sales channel, every month.
- Management accounts that used to arrive three months late now land every month.
- Cash is reviewed every two weeks with the founders.
Read the full story in the BrainGain case study.
