The Saturday-afternoon spreadsheet that stops being a quarterly panic

Shopify takes the daily summary. Amazon, eBay, TikTok Shop, Etsy, four marketplaces, three payouts in different currencies - I’m at the kitchen table on Saturday afternoons with eight tabs open and a hopeful spreadsheet, and one Saturday a quarter is an actual panic.

A2X or Link My Books gives you the daily Shopify-to-Xero summary journal cleanly. Everything else - Amazon’s per-channel fees, eBay’s promoted-listing margin, TikTok Shop’s marketplace-facilitator VAT split, the Etsy payout in dollars, the cellar-door tasting paid at the door, the wholesale order from the pub on WhatsApp, the IOSS / OSS line for EU B2C above €10k, the EPR PackUK packaging-tonnage annual draft, the commercial-fit-out invoice where labour reverse-charges and materials don’t, the funeral disbursement reconciliation across clergy + organist + doctor + florist + paper notice + crematorium + doves + charity collection, the locksmith doorstep with the card terminal and the cash, the equine yard’s monthly bill split by share across four syndicate owners on the same four-year-old - these all land as hand-spreadsheeted reconciliations on the bookkeeper’s Saturday. One Saturday a quarter is the panic; three Saturdays of the rest are just the slow steady cost of doing business across more than one channel.

This is the build that consolidates the bookkeeping - multi-channel payment ingestion, per-channel fee reconciliation, per-line CIS reverse-charge wording, per-product EPR / IOSS / OSS / marketplace-facilitator VAT, doorstep card-and-cash reconciliation, multi-entity rollup for diversified estates, and per-share split for syndicate or partial-ownership ledgers - into Xero (or QuickBooks / FreeAgent / Sage) on a daily cadence rather than a Q1 panic. The shape is sealed against mendmyi, the founder’s own UK device-repair shop, where Shopify + counter card terminal + marketplace listings + service-revenue + buyback all consolidate to the same Xero ledger on a daily cadence and the Q1 VAT return is a ten-minute sign-off rather than a Saturday-afternoon reconstruction.

What gets lost between the sale and the books

Every business that takes payment across more than one channel loses the same thing in a slightly different costume. A few moments - pick the ones that sound like your quarter:

• E-commerce shops with marketplace mixShopify 12, Amazon 10, eBay 15, TikTok Shop 8 - same SKU, four channels, three different fee structures, two different marketplace-facilitator-VAT treatments, one VAT return; the £90k UK threshold creeping up on you without a sixty-day-ahead view.
• EU-B2C cross-borderthe IOSS / OSS line that kicked in the moment the year’s EU sales went over €10k, the per-country threshold logic, the OSS quarterly return; pre-build, “we’ll work it out at year-end” was the unspoken policy.
• EPR PackUKthe per-product packaging tonnage that has to be tagged at product-creation, not reconstructed at submission; the £200k turnover-threshold producer obligation that became active in 2024 and is still catching small shops out.
• Craft food and drinkD2C orders through Shopify, marketplace orders (Master of Malt, Honest Brew, Yumbles, The Cheese Geek), wholesale-account orders from pubs and farm shops on WhatsApp, cellar-door card-and-cash; for alcohol producers the Small Producer Relief Excise duty layer; for beekeepers the Defra Honey Regs labelling-and-record; AWRS where it applies.
• Holiday lets after the April-2025 FHL changeOTA payouts (Sykes / Airbnb / Booking.com / Vrbo) splitting against the new mortgage-interest-as-credit reality, Form-17 split awareness on jointly-owned property, the £90k VAT threshold tracked sixty days ahead because the busy season is when you hit it without noticing.
• Funeral directorsthe 8-invoice disbursement reconciliation. One funeral invoice on the family’s side, eight or nine pass-through line items on the bookkeeping side (clergy, organist, doctor’s certificate, florist, paper notice, crematorium, doves, charity collection, sometimes more). Pass-through items are VAT-neutral; service items aren’t. The reconciliation is hand-typed for every funeral until it isn’t.
• Commercial trades on CIScommercial-fit-out builders, commercial sparks, commercial plumbers, commercial-contract decorators, construction GCs. CIS reverse-charge wording at the line level - labour reverse-charges, materials don’t - with the statutory wording HMRC and the QS both recognise. Monthly CIS300 returns assembled with subbie UTRs and verification status, supplier-statement reconciliation across Travis Perkins / Selco / Howdens / Jewson / City Electrical Factors / Edmundson.
• Locksmiths and doorstep tradelocksmiths on a midnight callout, SumUp / Zettle / Stripe Tap-to-Pay / cash, the customer paid £180 at the doorstep across three taps and a note; reconciling that to the job + the invoice + the VAT-return is a kitchen-table exercise on a Sunday because the trade-app’s not built for the locksmith’s payment mix.
• Hospitality multi-site multi-POSpubs, restaurants, wedding venues running Square + Zettle + Dojo + EPOS Now + Lightspeed + Tevalis across the front-of-house, with the 2024 Allocation of Tips Act tronc calculation now sitting on top of every shift’s takings.
• Agriculture diversified estateagriculture with the farm Ltd, the venue Ltd, the holiday-let sole-trader, the grain-store LLP; supplier statements from feed merchants, ag-chem suppliers, fuel cards, contractor invoices; the per-entity P&L allocation that’s only correct if the source data was right.
• Equine yards on syndicate ownershipequine yards with the monthly livery + vet + farrier + physio + race-entry bill split per share across four owners on the four-year-old, three on the three-year-old, the absolute owner on the broodmare; the “can you send me my share of last month again” request from each owner on a different day of the month.

These aren’t problems for a single-channel ledger. They’re the bit between the sale lands and the books are right, which is where the quarterly panic actually lives.

What solved looks like

1. Every channel ingests into one ledger, on a daily cadence

The “different days, different formats” moment: Shopify drops a clean daily summary through A2X. Amazon’s monthly statement lands in a CSV the bookkeeper unpacks by hand. eBay’s promoted-listing line is buried in the per-transaction export. TikTok Shop’s payout net of marketplace-facilitator VAT comes through with a structure that doesn’t match what the others did. Etsy lands in dollars. Master of Malt sends a quarterly summary. By the time the books are right, the quarter’s over.

Solved looks like: every channel ingests on a daily cadence. Shopify and Amazon FBA through A2X / Link My Books where that’s the right tool (we wire alongside, not over the top); the channels A2X doesn’t cover - Amazon Seller Central per-channel fees, eBay promoted-listing margin, TikTok Shop marketplace-facilitator VAT, Etsy USD-to-GBP, Master of Malt / Honest Brew / Yumbles / The Cheese Geek marketplace payouts, OTA payouts (Sykes, Airbnb, Booking.com, Vrbo), Stripe / GoCardless / SumUp / Zettle / Square / Dojo / EPOS Now / Lightspeed feeds - get the same daily journal-entry treatment, structured to your chart of accounts, against the SKU and the customer and the order. The books are right on the morning of, not on Saturday afternoon.

2. Per-channel fee reconciliation, captured against the order not the bank line

The “the bank line is one number” moment: Amazon paid in £4,238 on Wednesday. That’s the net of commission, FBA fees, advertising fees, returns-deductions, marketplace-facilitator VAT, currency conversion, and the £1,200 of orders held in reserve until next pay-cycle. Your bank line just shows £4,238 and the bookkeeper reconstructs the rest from the statement on Saturday.

Solved looks like: the daily ingest captures each fee element against the order it relates to. Amazon’s per-channel commission tags to the order; the FBA fee tags to the order; the advertising fee tags to the campaign or the SKU; the marketplace-facilitator VAT tags to the order; the currency-conversion margin tags to the payout; the reserve hold sits as a reconciling item until released. The bank line ties out automatically; the “where did the £4,238 come from” reconstruction stops being a job.

3. CIS at the line level, with the statutory wording HMRC and the QS both recognise

The “labour reverse-charges, materials don’t” moment: the commercial-fit-out invoice goes to the main contractor; the labour line has to reverse-charge under the 2021 domestic-reverse-charge regulations, the materials line doesn’t, the statutory wording has to match HMRC’s guidance, and the contractor’s bookkeeper has a strong view about which paragraph from HMRC’s guidance she expects on the invoice. You get it wrong by one wording-choice and the payment gets queried by the QS.

Solved looks like: CIS reverse-charge wording renders at the invoice-line level - labour-and-services lines carry the reverse-charge note, materials-supplied lines don’t. The statutory wording follows HMRC’s reverse-charge guidance for construction; the contractor’s bookkeeper recognises it because it matches her own internal template. Monthly CIS300 returns assemble automatically with the subbie UTRs and verification status pre-populated; new subbies get queued through the Gateway verification before they’re paid. Supplier-statement reconciliation across Travis Perkins, Selco, Howdens, Jewson, City Electrical Factors, Edmundson runs alongside, so the inputs and the outputs both tie out.

4. VAT thresholds and EPR / IOSS / OSS tracked sixty days ahead, not at year-end

The “I think we just went over £90k” moment: the busy season’s been good and the last sixty days have been better than expected. Your bookkeeper does the look-back at year-end and tells you you went over £90k in August. The HMRC registration window’s already short; the back-VAT exposure on the months you were over and weren’t charging is sitting on the books as an unwelcome surprise.

Solved looks like: the £90k UK VAT threshold is a sixty-day forward-projection on the dashboard. The €10k EU-B2C IOSS / OSS threshold is the same. EPR PackUK tonnage is tagged at product-creation (not reconstructed at submission); the annual draft assembles in the EPR-expected format ready for your sign-off. The marketplace-facilitator VAT positions (Amazon, eBay, Etsy, TikTok Shop) reconcile inside the accounting system rather than as a side-spreadsheet. The threshold conversation happens sixty days before, not at year-end.

5. Doorstep card-and-cash reconciliation at the kitchen table is the bookkeeping

The “three taps and a note” moment: the locksmith got to the doorstep at midnight. Customer paid £180 across two taps on SumUp (the first one failed), a tap on Stripe Tap-to-Pay (because SumUp wouldn’t reconnect), and a £20 note. The job, the invoice, the customer record, and three different payment-provider feeds all need to tie together by Sunday evening. Currently, that’s a kitchen-table exercise with the iPad and a beer.

Solved looks like: the doorstep payment is the bookkeeping. The tap on whichever provider (SumUp / Zettle / Stripe Tap-to-Pay / Square Reader / Tyl) writes to the job record with the amount, the provider, the timestamp, the customer; the cash tagged in the same screen; the invoice generates with the right payment-method line(s); the daily payout reconciles to the job’s payments without re-keying. The locksmith’s Sunday-evening reconcile is the moment she presses send on the week’s payouts, not the moment she opens a spreadsheet.

6. Multi-entity, multi-site, per-share rollup where the business shape demands it

The “farm + venue + holiday-let + grain-store” moment: the diversified estate has four legal entities. Each has its own books, its own VAT registration, its own bank line. The owner wants a consolidated P&L view for the family. The accountant wants the individual entity books spotless for filing. The supplier statements arrive monthly with line items that span all four entities. The reconciliation is a Sunday at the kitchen table with four sets of papers and four mugs of tea.

Solved looks like: the diversified-estate rollup keeps the per-entity books correct while consolidating at P&L level for the operator view. Supplier statements (feed merchants, ag-chem, fuel cards, contractor invoices) reconcile across entities with the right line-allocation rule baked in. For funeral directors, the 8-invoice disbursement reconciliation lands as one family-facing invoice with the pass-through items VAT-neutral and the service items VAT-charged at the right rate. For equine yards, the monthly per-horse bill splits across syndicate shares - four owners on the four-year-old, three on the three-year-old, the absolute owner on the broodmare - with the per-share invoice landing on each owner’s Customer & Third Party Portal view alongside the operational record. For hospitality multi-site, the per-POS multi-site rollup pulls Square + Zettle + Dojo + EPOS Now + Lightspeed + Tevalis across the locations with the 2024 Allocation of Tips Act tronc calculation sitting on top.

How the daily reconciliation cadence runs, by default

The default multi-channel-shop cadence runs:

• End of day (per channel)Shopify’s daily summary lands; A2X / Link My Books processes the Shopify-to-accounting journal. The channels A2X doesn’t model (Amazon Seller Central per-channel fees, eBay promoted-listing margin, TikTok Shop marketplace-facilitator VAT, Etsy currency conversion, marketplace payouts, OTA payouts, card-terminal feeds) ingest into the same accounting system on the same cadence, structured the same way.
• Order momentper-order tags land at the moment the order is placed - SKU, channel, fee structure, currency, VAT treatment, EPR packaging tonnage, marketplace-facilitator-VAT split (where applicable), customer record. The reconciliation is prospective, not retrospective.
• Payment momentevery payment ingest (Stripe / GoCardless / SumUp / Zettle / Square / Dojo / EPOS Now / Lightspeed / Tevalis / cash) writes the per-payment line against the invoice and the job and the customer. The bank line ties out automatically.
• Dailythe consolidated daily journal lands in your accounting system. The bookkeeper signs off in fifteen minutes rather than reconstructing eight tabs on Saturday.
• Monthly (where applicable)CIS300 return assembles with subbie verification status; supplier-statement reconciliation runs across the merchant accounts; the marketplace-facilitator-VAT positions reconcile; the EPR PackUK monthly stub updates against the per-product tonnage feed.
• Sixty days ahead of thresholdthe £90k UK VAT threshold and the €10k EU-B2C IOSS / OSS threshold and the £200k EPR producer-obligation threshold show on the dashboard with the projected crossing date, not at year-end.
• Quarterlythe VAT return assembles in your accounting system in the format HMRC expects; the OSS return assembles for the EU side where it applies; you sign off and file.

Per-vertical tuning lives on top - the funeral-disbursement 8-invoice reconciliation, the equine per-horse share split, the agriculture multi-entity rollup, the hospitality tronc layer under the 2024 Allocation of Tips Act, the craft food and drink Small Producer Relief alcohol-excise layer, the alcohol-producer AWRS where it applies, the post-April-2025 FHL holiday-let mortgage-interest-as-credit treatment, the doorstep card-and-cash trade reconciliation.

Who this is for

The shape repeats across every UK SME that takes payment across more than one channel and ends up with one VAT return at the end of it.

E-commerce and marketplace shops - e-commerce shops running Shopify + Amazon + eBay + Etsy + TikTok Shop with the per-channel fee reconciliation, the EPR PackUK tonnage, the IOSS / OSS EU-B2C threshold, the marketplace-facilitator VAT positions.

Craft food and drink - craft food and drink producers running D2C through Shopify, wholesale through pubs and farm shops on WhatsApp, marketplace through Master of Malt / Honest Brew / Yumbles / The Cheese Geek, cellar-door card-and-cash; with the Small Producer Relief alcohol-excise layer, the AWRS / WOWGR positions where they apply, the Defra Honey Regs labelling-and-record for beekeepers.

Holiday lets after the April-2025 FHL change - holiday-let owners running Sykes / Airbnb / Booking.com / Vrbo payouts through the post-FHL reality (mortgage-interest-as-credit, Form-17 split awareness, £90k VAT threshold tracking sixty days ahead).

Funeral directors - funeral directors with the 8-invoice disbursement reconciliation (clergy / organist / doctor / florist / paper notice / crematorium / doves / charity collection) landing as one family-facing invoice with the pass-through and service items treated correctly.

Commercial trades on CIS - commercial-fit-out builders, commercial sparks, commercial plumbers, commercial-contract decorators, construction GCs, and the builders hub. Reverse-charge wording at the line level, monthly CIS300 returns assembled, supplier-statement reconciliation across the merchant accounts.

Doorstep trades - locksmiths and any trade taking doorstep card-and-cash payment across SumUp / Zettle / Stripe Tap-to-Pay / Square Reader / Tyl with a kitchen-table reconciliation problem.

Hospitality multi-site multi-POS - pubs, restaurants, hotels, wedding venues running Square + Zettle + Dojo + EPOS Now + Lightspeed + Tevalis with the 2024 Allocation of Tips Act tronc layer.

Agriculture and equine - agriculture diversified estates with the multi-entity rollup, equine yards with the per-horse syndicate-share split (the equine-bills-per-horse shape collapses onto this engine - same per-share allocation discipline, equine artifacts).

Same engine; different channel mix; different VAT layer; different reconciliation shape.

The closest thing we’ve already built

mendmyi - the founder’s own UK device-repair business. Shopify storefront for retail of refurbished and pre-owned phones; counter card terminal for in-shop sales and pay-on-collection repair revenue; marketplace listings for the buyback inventory; service revenue for the repair jobs; buyback payouts on the customer side - all consolidating to the same Xero ledger on a daily cadence. The Q1 VAT return is a ten-minute sign-off rather than a Saturday-afternoon reconstruction. The clearest reference for any service + retail + marketplace SME.

pharmaceutical-analytics.com - the consolidation-dashboard shape, with the per-channel and per-entity rollup as the operational data feed and the daily decision-view assembled from underneath. Useful where the diversified-estate or multi-channel operator wants the decision layer on top of the ledger.

HC Electrical - live CIS reverse-charge wording at the line level on the commercial side, monthly CIS300 returns assembled with subbie verification, supplier-statement reconciliation across the merchant accounts. The clearest reference for any trade business doing commercial sub-contracting under the 2021 domestic-reverse-charge regulations. (Named pull-quote + final-£ outcome figures hold behind the permission checklist; see Hc Electrical for the build detail.)

The chase-side of the unpaid invoice across all of these channels feeds the Invoice & Dunning Ladder; the stage-payment retention side on the commercial trades pairs with Stage Payment & Retention Ledger; the per-share third-party portal for equine syndicate owners and diversified-estate stakeholders pairs with Customer & Third Party Portal.

Tell us what’s hand-spreadsheeted

What channels you take payment across, what VAT / CIS / disbursement / per-share reconciliation eats Saturday afternoon, where the quarterly panic actually lives, what your current bookkeeper does on the day they reconcile. Tell us the most-recent reconciliation that took longer than it should have and we’ll come back with a sketch of what we’d build so the next quarter looks different. No demo, no calendar widget. Email reply, scoped sketch, you decide.

FAQ