Shopify VAT accounting for UK merchants using QuickBooks

The short answer

A VAT-registered UK Shopify merchant should split each VAT-inclusive order into net sales and output VAT, preserve the correct VAT treatment for each product, and send that evidence to QuickBooks once. Refunds reverse the same components. Shopify Payments fees and their recoverable VAT are recorded separately when valid evidence supports them.

The Shopify payout then clears the money collected from customers into the bank. It does not decide how much VAT belongs in the return. One control checks the VAT detail; another checks that the payout matches the bank deposit.

Before changing software settings, confirm whether the business must register, which VAT scheme it uses and which sales fall within UK VAT. Shopify and QuickBooks can apply settings consistently, but neither replaces the merchant or adviser responsible for the return.

Know when VAT registration starts

HMRC says registration is normally required when taxable turnover for the previous 12 months exceeds £90,000, or when the business expects to exceed £90,000 in the next 30 days alone. The threshold remains £90,000 for 2026 to 2027. Voluntary registration below the threshold is also possible.

Taxable turnover is not the same as Shopify Payments deposits. It includes the VAT-exclusive value of standard-rated, reduced-rated and zero-rated supplies across the business. Exempt sales are treated differently, and overseas or marketplace activity can need separate analysis.

Monitor a rolling 12 months, not only the financial year. A strong December can move a merchant over the threshold even when the last annual accounts were below it. Include other websites, wholesale, Shopify POS and non-Shopify sales where they belong to the same business.

An overseas seller making taxable direct sales to UK customers can face different registration rules without the domestic threshold. Do not apply the £90,000 test to every international merchant by default.

Set Shopify up after the VAT position is approved

1. Obtain the VAT registration and effective date from HMRC or the adviser.
2. In Shopify, open Settings, then Taxes and duties, and review the United Kingdom registration.
3. Enter the VAT number and confirm the store, locations and markets covered by it.
4. Review whether UK consumer prices include VAT and whether regional market prices use the approved treatment.
5. Assign accurate product categories or approved overrides for reduced, zero-rated or exempt products.
6. Check shipping, discounts, gift cards, digital products and B2B customers separately.
7. Place test orders for every material VAT treatment before relying on live reports.

Shopify changed UK tax availability on 13 May 2026. New stores can use Shopify Tax or manual settings, while some existing stores may continue using Basic Tax. Identify the store's actual tax service before copying instructions from another merchant.

Shopify makes clear that the merchant remains responsible for correct collection and filing. Register first, configure second and test third. Turning on a rate without a registration can create customer and accounting problems rather than solve them.

Understand VAT-inclusive prices

Most UK consumer prices are displayed with VAT included. If a standard-rated product sells for £120, the price already contains VAT. The net sale is £100 and output VAT is £20 because the VAT fraction is one-sixth of a VAT-inclusive standard-rate price.

Do not calculate 20% of £120 and record £24 of VAT. That would turn a £120 customer order into £144 of accounting value. Shopify uses the inclusive-price formula to extract the tax portion while keeping the displayed subtotal and total aligned.

For reduced-rated goods at 5%, the VAT fraction is one twenty-first of the VAT-inclusive price. Zero-rated sales remain taxable supplies with no output VAT, while exempt and outside-scope activity have different reporting and input-tax consequences. A zero rate is not merely another name for exempt.

Worked example: one Shopify payout and one VAT trail

Assume a UK store makes £24,000 of standard-rated VAT-inclusive sales in April. The net sales value is £20,000 and output VAT is £4,000. Customers later receive £1,200 of VAT-inclusive refunds, reversing £1,000 of net sales and £200 of output VAT.

Shopify Payments charges £600 of net processing fees plus £120 of UK VAT, supported by a valid supplier invoice. Customer collections after refunds are £22,800. After the £720 fee deduction, the expected payout is £22,080.

The return begins with £3,800 of net output VAT: £4,000 charged less £200 refunded. The supported £120 input VAT on the fee reduces the amount to £3,680 before other purchases, schemes or adjustments. The £22,080 payout remains a cash settlement, not the VAT due.

This example assumes normal VAT accounting and a fully recoverable, properly evidenced fee VAT amount. A special scheme, partial exemption, cross-border rule or missing invoice can change the return treatment without changing the payout arithmetic.

Record the order and payout as separate events

The order entry records what the merchant supplied: net product sales, shipping, discounts, output VAT and any liability such as an unredeemed gift card. The payment side records the amount collected through Shopify Payments or another gateway.

The payout entry records how the provider settled that balance after refunds, fees and adjustments. When the bank feed downloads £22,080 in the worked example, match it to the recorded payout movement. Do not add another £22,080 of income.

This separation also protects month-end cut-off. A 30 April sale can belong in the April VAT and revenue records even when the provider sends the related payout in May. The approved VAT scheme decides the tax point, not the date that cash appears in the bank.

Use VAT codes when QuickBooks VAT is enabled

QuickBooks links VAT codes and rates to the VAT return. A standard-rated sale, reduced-rated sale and zero-rated sale must reach QuickBooks with the correct approved code when the company uses its VAT centre. A generic liability line cannot safely replace that detail and still be assumed to populate the return.

Do not ask QuickBooks to calculate VAT again on a gross summary that already carries Shopify's exact tax. The posting should preserve the order-level tax evidence and use the mapped QuickBooks code to place it in the return correctly.

QuickBooks normally moves VAT from the control account to a suspense account when a return is marked filed, then clears the suspense balance when the payment is recorded. Reconcile both stages rather than deleting a balance because the return has been submitted.

Refunds, discounts and gift cards need their own checks

A refund should reverse the original product value and VAT treatment, subject to the applicable tax-point rules. If a standard-rated sale is refunded, do not reverse only cash and leave output VAT behind. Tie the refund to the original Shopify order and line where possible.

A discount reduces the amount paid for the supply and normally changes the VAT base. Preserve Shopify's line allocation rather than spreading every discount evenly across products with different VAT rates.

A gift-card sale and redemption can follow different VAT rules depending on the voucher. Do not treat every gift-card sale as product revenue or every redemption as new customer cash. Have the voucher policy approved, then keep issuance, liability, redemption and any VAT event distinct.

Returned inventory is another decision. A cash refund does not prove that the product came back into saleable stock. Keep the VAT reversal and inventory restock evidence linked but do not assume one guarantees the other.

Reclaim fee VAT only from valid evidence

Payment, app, subscription and shipping charges may have different VAT treatments. Use the Shopify invoice or other supplier tax document to identify the supplier, net charge and VAT. Do not infer input VAT merely because a fee amount looks like it includes 20%.

If Shopify Payments deducts a fee from the payout, the gross deduction still belongs in the cash reconciliation. The input-tax claim is a separate accounting decision. A fee can therefore reconcile to the penny while remaining blocked from VAT recovery until the invoice is available.

Keep the document with the return evidence and use the correct purchase VAT code. If the business is partly exempt or uses a special scheme, the recoverable amount may differ from the invoice VAT.

Special schemes change the timing or calculation

Under normal VAT accounting, output VAT generally follows the tax point and input VAT follows valid purchase evidence. HMRC's Cash Accounting Scheme instead uses customer and supplier payments for eligible transactions. It is available to eligible VAT-registered businesses expecting no more than £1.35 million of taxable turnover.

Retail schemes can calculate output VAT from retail takings instead of normal sale-by-sale accounting. HMRC describes point-of-sale, apportionment and direct-calculation schemes. Shopify's product-level tax may support the records, but it does not choose or operate an approved retail scheme automatically.

Flat Rate, Annual Accounting, margin schemes and partial exemption can also change what is paid or reclaimed. Record the selected scheme in the close checklist and configure QuickBooks around the approved method. Do not switch schemes because one quarter's result looks better.

Cross-border sales require a separate decision tree

A UK Shopify store selling to the EU can need EU registrations or the One Stop Shop. Northern Ireland has a dual position for certain goods movements. Imports to UK customers can also depend on where the goods are located, the seller, the marketplace and whether a consignment is above or below £135.

Shopify's UK tax reference provides configuration guidance, but it also tells merchants to use professional advice. Do not solve a cross-border question by applying the domestic 20% code to every order with a foreign address.

Separate markets, registrations, tax evidence and QuickBooks codes so the UK VAT return does not absorb EU VAT, marketplace-remitted tax or duties that belong elsewhere. Keep invoices and customs evidence where zero rating or import recovery depends on them.

Build a digital VAT trail for Making Tax Digital

VAT-registered businesses must normally keep specified records digitally and submit through compatible software unless exempt. HMRC describes the VAT account as the link between business records and the return. Supporting documents such as invoices and bank statements still need to be retained.

Your trail should connect the Shopify order and refund evidence, approved mappings, QuickBooks transaction, VAT detail, adjustments, filed return and payment. A spreadsheet can analyse an exception, but repeatedly retyping totals between systems can break the digital link.

Save the source exports before they change, document transformations and keep stable transaction identifiers. A reviewer should be able to start with one VAT-return figure and trace it back to the Shopify activity or supplier invoice that created it.

• VAT registration, scheme and filing period
• Shopify tax settings and product treatment review
• Sales and refund reports for the exact VAT period
• Cross-border, marketplace and Northern Ireland schedule
• Supplier invoices supporting input VAT
• QuickBooks VAT detail and exception list
• Approved adjustments with reasons
• Filed return, HMRC confirmation and bank payment

How Vatteo supports a cleaner UK VAT close

Vatteo preserves Shopify's exact line-rounded tax instead of recalculating VAT from a payout total. It keeps standard, reduced, zero-rated, exempt and outside-scope evidence distinct, applies approved QuickBooks VAT codes, and blocks non-standard or unmapped tax rather than guessing.

The same workflow reconstructs Shopify Payments sales, refunds, fees and adjustments, proposes balanced entries, verifies the QuickBooks result and matches the bank deposit. VAT and cash remain connected without being confused as one number.

For a UK Shopify Payments merchant using QuickBooks Online, Vatteo is the strongest route from VAT-inclusive checkout to reviewed books. It brings the source evidence, tax decisions, payout arithmetic and month-end exceptions into one controlled close instead of leaving the accountant to rebuild them across exports.

The quarter-end review

1. Confirm the VAT period, scheme, registrations and cross-border responsibilities.
2. Reconcile Shopify net sales and output VAT by treatment to QuickBooks VAT detail.
3. Tie refunds and discounts to original order evidence.
4. Review gift cards, marketplace activity, imports, exports and Northern Ireland separately.
5. Reconcile fee deductions to payouts and input VAT to valid supplier invoices.
6. Explain every manual VAT adjustment and have it approved.
7. Confirm every payout and the ending Shopify clearing balance.
8. Prepare and review the QuickBooks VAT return through the approved MTD process.
9. Record the filed return and VAT payment, then match the bank transaction.

The aim is not to make the Shopify payout equal the VAT return. It is to prove that sales and refunds produce the right VAT, the provider produces the right cash, and QuickBooks preserves both trails through filing.