At a glance
Total tax collected from customers in the 30-day window. The single-number, current-period view of pass-through tax liability owed to authorities.
Calculation
Worked example
A UK skincare DTC brand on Shopify, VAT-registered (20% standard), VAT-inclusive pricing. 30D window 12 Apr 26 to 12 May 26.
The 16.67% figure is the embedded VAT extracted from the customer-paid total. For a 20% VAT-inclusive price model: £100 gross = £83.33 net + £16.67 VAT.
Six things to notice:
- The 16.67% is the canonical UK VAT-inclusive rate. A drift below 16% would suggest VAT-exempt customer mix shifting (e.g. EU B2B with valid VAT numbers). A drift above suggests reduced-rate items reclassified.
- HMRC quarterly forecast. £43k/30D × 3 = £129k/quarter. Match against your VAT-return forecast; the working draft should align within rounding.
- Net VAT liability differs. This card shows gross collected. Net = collected minus reclaimable input VAT (VAT on supplier purchases). The net is what you actually pay HMRC; this card is one input.
- Refund treatment. A refund unwinds tax: when you refund a £100 VAT-inclusive order, the £16.67 of VAT becomes reclaimable. This card doesn’t subtract that; HMRC return does.
- Shopify Tax engine accuracy. Reconcile this card against your accounting record monthly; persistent gaps (>2% of total) indicate misconfiguration.
- Multi-currency caveat. A UK + EU stores would show blended tax-effective-rate that’s nonsensical without FX normalisation. Filter to single currency (or single market).
Sibling cards merchants should reference together
Total Tax is the £-aggregate. Companions:Reconciling against the vendor’s own dashboard
Where to look in Shopify Admin:Shopify Admin → Analytics → Reports → “Taxes” (under Finance)The most direct equivalent. Aggregate by period and rate; should match this card to within sync-lag tolerance. Other Shopify Admin views:
- Reports → Sales by billing location: tax by region, useful for US sales-tax compliance.
- Settings → Taxes and duties: tax-engine configuration.
- Apps: Avalara, TaxJar, Quaderno produce their own reports.
Cross-connector reconciliation:
Known limitations / merchant FAQs
Why does my effective rate vary month-to-month? Three usual causes:- Customer-mix shift: B2B-exempt customers reduce effective rate; international shifts change blend.
- Product-mix shift: reduced-rate categories (children’s clothing, books in some jurisdictions) reduce effective rate.
- Tax-engine misconfiguration: a new product type added without proper VAT classification.
- Monthly compliance reconciliation: total here vs accounting closing balance. Match within rounding.
- Effective-rate trend monitoring: stable rate is healthy; sudden shifts deserve investigation.
- VAT-registration threshold: small UK stores approaching £85k threshold need this card to confirm correct configuration once registered.
- Tax-engine audit: spot-check by manually summing order-level totalTax for a single day; should match this card’s daily aggregate.
- Quarterly VAT-return preparation: 90D total here = 1 quarter of gross VAT. Subtract refund-tax to estimate net liability.