Shopify Specialism
Shopify Accountants
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.
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.
An illustrative Shopify reconciliation
A payout with fees and refunds
Illustration only, not a client result. Assume a seller who is not VAT registered has £5,000 in sales, £200 in refunds and £150 in payment fees, with no other adjustments. The bank receives £4,650. Record the components separately and check for reserves or timing differences before treating the balance as an error.
Understand the records behind the numbers
UK-wide remote support
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 about shopify.
Why don't my Shopify payouts match my Xero records?
Almost always because the Shopify Payments deposit is net of fees, refunds, chargebacks, Shopify Capital repayments, and pass-through tax — but the bookkeeping is treating the deposit as a single revenue line. Specialist accountants build a clearing account that posts gross sale value from the Shopify side, then closes it against the bank deposit via a journal that captures each fee category. Once that's set up correctly, the difference between Shopify payouts and the books vanishes — every month closes to zero.
What integration should I use between Shopify and Xero / QuickBooks?
Shopify's native Xero integration is the simplest and the cheapest option but it does the least transaction-level mapping — most users end up needing the A2X, Webgility, or similar add-on for proper fee category split, payout reconciliation, and multi-currency handling. Specialist accountants assess the volume and complexity of the store and recommend the right tool. Higher-volume Plus stores often need A2X or a custom mapping; Basic and Shopify-tier stores can usually run with the native integration plus careful clearing-account management.
How does Shopify Capital interest get accounted for?
Shopify Capital is loan finance with a fixed fee (effectively interest, though Shopify presents it as a "factor rate"). Repayments come out of each payout as a percentage of revenue. The accounting needs to split each repayment into principal repayment (balance sheet, no P&L impact) and finance cost (P&L, deductible for corporation tax under the loan-relationship rules). Specialist accountants build the journal mapping; generalists frequently book the whole deduction as a Shopify fee, which is wrong on both the P&L and the corporation tax computation.
I sell in USD on a UK Shopify store — how should the FX be handled?
Each order is a USD transaction; each payout converts to GBP at Shopify's daily rate. The revenue should be captured at the GBP rate at the time of the sale (functional-currency FRS 102 / FRS 105 rule) and the difference at payout becomes realised FX gain or loss. Without separating the FX, you can't tell whether margin moved or the pound moved. Specialist accountants set up the per-currency P&L; generalists frequently book each payout as the revenue figure and lose the visibility entirely.
Do I need OSS or IOSS for EU sales from my UK Shopify store?
OSS if you're shipping to EU consumers from UK stock — register once (typically in Ireland or another single member state), file periodic OSS returns covering all EU consumer sales. IOSS if you're handling under-€150 imports being shipped into the EU directly from non-EU warehouses. UK-established sellers shipping from UK fulfilment to EU consumers almost always need OSS; IOSS is more for sellers fulfilling direct from non-EU dropshipping or warehouse-in-China arrangements.
How do I handle gift cards on Shopify accounting-wise?
Gift card sale = liability (you owe goods or service), not revenue. Revenue is recognised when the gift card is redeemed. Shopify tracks issuance and redemption in the dashboard, but your books need to reflect the liability separately. Specialist accountants build a gift-card-liability balance, expire stale balances correctly under FRS 102 / FRS 105, and recognise breakage in line with the standard. Generalist accountants frequently book gift card sales as immediate revenue, which is wrong.
My Shopify store has subscriptions — does that change the accounting?
Yes, materially. A subscription paid in advance is deferred revenue, recognised over the service period. A 6-month subscription paid up front recognises one-sixth of the revenue each month; the unrecognised portion sits as a deferred revenue liability. Specialist accountants build the deferred revenue journals correctly. Generalist accountants frequently book the up-front cash as immediate revenue, which inflates the current period and creates a comparable dip the following period.
What about my Shopify wholesale channel — is that the same as DTC?
Different margin profile and different VAT handling. Wholesale (B2B) margins are typically lower than DTC because the wholesale price is below retail. VAT handling depends on the supply: wholesale to VAT-registered UK businesses is straight UK VAT (with reverse charge for certain construction supplies); wholesale to non-VAT-registered businesses follows the consumer rules. Specialist accountants set up channel-level reporting so the two margin profiles are visible separately; generalists treat the two streams identically.

