Shopify Specialism

Shopify Accountants

Shopify accounting goes wrong most often at the Shopify-Payments-to-bookkeeping reconciliation — the famous "Shopify payouts don't match Xero" problem. The other recurring traps are Shopify Capital loan repayments being mis-categorised, multi-currency stores creating realised FX gain/loss the books never capture, and OSS / IOSS handling on EU consumer sales. We match you with accountants who handle Shopify daily.

WHAT THIS COVERS

What Shopify Accounting Actually Involves

Shopify Payments deposits are net of: Shopify transaction fees (currently 1.5%-2% depending on plan), payment processing fees (typically 1.7% + 30p for Visa/Mastercard, higher for Amex), refunds applied during the payout period, chargebacks, and Shopify Capital repayments where applicable. The deposit also nets out Shopify-collected sales tax / VAT under marketplace facilitator rules in jurisdictions where Shopify Tax handles collection. Generalist accountants typically import the deposit into Xero or QuickBooks as a single revenue line, which conflates revenue with fees, refunds, and pass-through tax. Specialist accountants build a per-payout journal that splits each component into the correct chart-of-accounts line.

Xero / QuickBooks integrations to Shopify (whether via the official Shopify-by-Xero integration, A2X, Webgility, or others) bring in transactional detail but the reconciliation against actual bank deposits is where the work happens. The bank deposit lands as a single sum; the integration brings in dozens or hundreds of individual transactions. Specialist accountants set up a clearing account where the integration posts the gross sale and the bank deposit closes against it via journal — the difference being fees, refunds, and pass-through tax. Generalist accountants either skip the clearing account (so payments and revenue float separately) or use it incorrectly (so the balance grows month over month).

Shopify Capital is loan finance offered to qualifying merchants based on Shopify-side sales history. Repayments are deducted automatically from each Shopify Payments payout as a percentage of revenue until the loan plus the fixed fee are paid. The repayment hits the bank as a smaller deposit; the merchant's books need to record the loan-relationship interest as a finance cost (split from the principal repayment) and the repayment itself as a balance-sheet movement. Specialist accountants split these correctly; generalists frequently book the entire deduction as a Shopify fee, which understates revenue and overstates fees.

Multi-currency Shopify stores (presenting prices in USD, EUR, etc., while paying out in GBP via Shopify Payments) create realised FX gain or loss on every payout. The underlying transactions sit in customer currency; Shopify converts at its own daily rate; the GBP deposit reflects that conversion. The FX line on the P&L should capture this separately so the operational margin and the currency-movement effect are both visible. Without that separation, the seller can't tell whether margin moved or the pound moved.

OSS / IOSS for EU consumer sales applies to UK Shopify stores shipping into the EU. Under OSS, the seller registers in one EU member state and reports all distance sales across the EU through that single return. Under IOSS, the seller handles under-€150 imports being shipped into the EU. Shopify Tax can be configured to collect the right VAT rate per destination but the periodic OSS / IOSS return still has to be filed by the seller (or their accountant). Specialist accountants handle the registration and the periodic filing; generalists frequently miss the registration entirely and the seller accumulates compliance debt across the EU.

EDGE CASES

Where Shopify Accounting Catches Sellers Out

Subscription and recurring-billing complexity — Shopify stores using subscription apps (Recharge, Bold Subscriptions, Shopify Subscriptions) have revenue recognition that differs from one-time sales. A 6-month subscription paid up front is deferred revenue, recognised over the service period. Generalist accountants book the up-front payment as immediate revenue, which inflates the current-period turnover and creates a comparable dip the following period. Specialist accountants set up the deferred revenue journals correctly.

Pre-orders and back-orders — orders accepted but not yet fulfilled aren't revenue under FRS 102 / FRS 105 until the goods are delivered (or substantially complete in transit, depending on Incoterms and the specifics of the customer contract). Stores running pre-order campaigns sometimes book the cash receipt as immediate revenue, which is incorrect. Specialist accountants set up an Unfulfilled Orders liability line and clear it on shipment.

Wholesale alongside DTC — Shopify Plus stores running both wholesale (B2B) and direct-to-consumer (DTC) channels need separate margin reporting because the gross margins differ materially and the VAT handling differs (wholesale to VAT-registered businesses may be reverse-charge for construction, may be straight UK VAT, depends on the supply). Specialist accountants set up channel-level margin reporting; generalists treat the two streams identically.

Returns and refunds timing — refunds are processed through the same Shopify Payments rails and net out of the next payout. The accounting entry needs to reverse the original revenue and reverse the cost of sale. Generalist accountants frequently book the refund as a separate negative-revenue entry without unwinding the cost-of-sale, which distorts margin reporting. Returns also affect inventory if the goods come back into stock — that movement needs explicit handling.

Gift cards and store credit — gift card sales aren't revenue at the point of sale; they're a liability (you owe goods or service). Revenue is recognised when the gift card is redeemed. Shopify's gift card system tracks issuance and redemption but the seller's books need to reflect the liability. Generalist accountants frequently book gift card sales as immediate revenue, which inflates turnover and creates breakage liability mismatches.

HOW IT PLAYS OUT

How Shopify Accounting Plays Out

Payout-to-Xero reconciliation rebuild, mid-tier DTC store

UK Shopify Plus DTC store turning over £1.4M/year had a Xero-Shopify integration running but the clearing account had drifted to £14,200 over 18 months — every payout was leaving small differences uncleared and they accumulated. We rebuilt the integration mapping, cleared the historic differences against the appropriate accounts (refunds and chargebacks misposted as fees, pass-through tax double-counted on a few periods), and set up monthly variance review with a £50 materiality threshold. The clearing account now closes to zero each month and any drift gets investigated within 24 hours.

OSS registration retrospective, UK seller into EU

UK Shopify store shipping ~£180k/year into EU consumers had been operating without OSS registration for 14 months. We registered with the Irish OSS scheme as the most accessible for a UK seller, filed retrospective OSS returns covering the unreported quarters with the appropriate VAT rates per destination country, and negotiated late-registration acceptance with the Irish Revenue. Penalty exposure of ~£12k was reduced to ~£2.4k through the unprompted-disclosure framework and reasonable-excuse arguments.

Multi-currency P&L restructure, USD-presenting Shopify store

UK-Ltd Shopify store presenting prices in USD to a primarily-US customer base, with Shopify Payments paying out in GBP. The previous accountant was booking each GBP payout as the revenue figure, with the implicit FX baked into revenue and no FX gain/loss line. Restructured to per-order USD revenue capture with daily FX revaluation against month-end rates, and separately-disclosed FX gain/loss on payout settlement. The corporation tax computation became defensible against HMRC review, and the management accounts started showing real operational margin separate from currency movement (a meaningful difference in a year where GBP/USD moved 8%).

WHERE WE MATCH

Cities we cover

Shopify-store density is high in UK cities with strong DTC and creator economies. The local mix shifts what kind of accounting work shows up:

COMMON QUESTIONS

Common questions about shopify.