← All case studies
E-commerce & consumer brands · E-commerce · UK & Ireland

From Excel to automated Xero bookkeeping

We moved BrainGain off spreadsheets and onto Xero, and connected Amazon and Shopify so every sale arrives with its fees, VAT and cost of goods already split out.

A woman adjusting BrainGain adjustable dumbbells on their stand
Photo: BrainGain
3 months → monthlyManagement accounts used to arrive three months late. Now they land every month.
2 Xero filesUK and Ireland, with Amazon and Shopify posting automatically.
3 VAT returnsGermany, the Netherlands and EU OSS, prepared from automated reports.
Every 2 weeksCash flow reviewed with the founders in Float.
The challenge
  • Every transaction keyed into Excel by hand from Amazon and Shopify reports
  • Payouts net of fees that rarely matched recorded sales
  • Cost of goods estimated separately, so margin by channel was unclear
  • Marketplace VAT hard to track; month-end figures late
What we did
  • Moved the books to Xero with a chart of accounts built for e-commerce
  • Connected Amazon and Shopify through Link My Books
  • Loaded product costs so cost of goods posts with each sale
  • Set up automated VAT reporting for Germany, the Netherlands and EU OSS
  • Connected every bank, Wise card spend and American Express to Xero
  • Receipts captured in Hubdoc and payroll run in Xero
  • Brought the UK and Irish Xero files together in Google Sheets for the management pack and cash forecast
The result
  • Revenue and margin visible by sales channel, every month
  • Each payout matched to the bank in one click
  • Cash planned ahead: draft stock bills and a supplier payment plan
  • Costs tracked against KPIs and challenged early

We used to get management accounts three months late, as one consolidated P&L with no insight. Now we see margin by country and channel every month, and we have a weekly cash flow. It's changed how we run the business.

Kareem Raslan, BrainGain

How the numbers flow now

aAmazonMarketplace
SShopifyOnline store
£Bank feedsMultiple banks
WWiseCard spend
AxAmerican ExpressCredit card
LMLink My BooksSales to Xero
HHubdocReceipts
PyPayrollRun in Xero
XXero UKUK company
XXero IrelandIrish company
GSGoogle SheetsReporting
Management packMargin by channel and country
Cash forecastReviewed every 2 weeks

Sales, bank lines, card spend, receipts and payroll land in the right Xero file, UK or Ireland, and Google Sheets brings both into one management pack and cash forecast.

Before and after

AreaBeforeNow
Sales recordingTyped in from channel reportsPosted automatically, settlement by settlement
Cost of goods soldEstimated separatelyPosted with every sale
Payout reconciliationSlow and often unmatchedOne-click match to the bank
Fees and VATHard to separateSplit out and coded correctly
PayrollSeparate payments set up in the bankOne batch payment from Xero
ReportingLate and limitedP&L and gross margin by channel, every month

Apps we run it on

XXeroAccounting
SShopifyOnline store
aAmazonMarketplace
LMLink My BooksSales to Xero
HHubdocReceipts
£Bank feedsMultiple banks
WWiseCard spend
AxAmerican ExpressCredit card
PyPayrollRun in Xero
GSGoogle SheetsReporting
FFloatCash flow