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.
| What it counts | SUM(totalTax) across orders in the window. Embedded VAT for inclusive stores or add-on tax for exclusive stores. |
| VAT / tax treatment | This is the metric. UK / EU stores: VAT extracted from gross. US stores: sales tax added on top. |
| Shipping | Tax-on-shipping included if Shopify tax engine charges shipping VAT. UK / EU yes; US varies by state. |
| Discounts | Tax computed post-discount in most jurisdictions. |
| Refunds | NOT subtracted. Refund-tax recovery requires separate calculation. |
| Cancelled / voided orders | Included if Shopify indexed them; voided orders typically have £0 tax already. |
| Currency | Multi-currency arithmetic without FX. |
| Channels / sources | All channels. POS contributes till-time tax. B2B with VAT-exempt customers contribute zero. |
| Time window | 30D (default 30D rolling) |
| Alert trigger | None directly; pair with VAT-return cycle for compliance alerts. |
| Roles | owner |
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.| Period component | Amount |
|---|---|
| Total revenue (gross, VAT-inclusive) | £258,400 |
Total tax collected (totalTax) | £43,067 |
| Effective tax rate | 16.67% |
- 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:| Card | Why pair it with Total Tax |
|---|---|
| Tax Over Time | The trend version; shows shape and consistency. |
| Total Revenue | Aggregate context; tax should be stable percentage of revenue. |
| Revenue Breakdown | The tax slice of total revenue. |
| Customer Countries | Tax varies by destination; cross-reference. |
| Customer Segments | B2B-exempt customers lower effective rate. |
| Refund Value | Refunds unwind tax; net liability requires this for accuracy. |
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.
| Reason | Direction | Why |
|---|---|---|
| Tax-engine differences | Either | If using Avalara or TaxJar instead of Shopify Tax, calculation may differ during cutover. |
| Refund treatment | Theirs may be net | Shopify’s report can show net of refunds; we show gross. |
| Time zone | Boundary | UTC vs store time zone. |
| Multi-currency | Aggregate distortion | We don’t FX-normalise. |
| Sync lag | Ours lower for “today” | Most-recent 5-15 min may not be in. |
| Card | Expected relationship | What causes legitimate divergence |
|---|---|---|
| Accounting tax balance (Xero, QuickBooks) | Should match within rounding | Bookkeeping reconciliation; persistent gaps indicate sync error. |
| HMRC / IRS submitted return | Net liability (collected minus reclaimable) | This card is gross collected; submitted return is net. Both should match the gross side within rounding. |
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.