# Shopify net revenue tracked slightly too low

### <span class="mw-headline" id="bkmrk-warum-dein-getrackte-1">Why your tracked revenue may differ slightly from your actual net revenue</span>

**When is this relevant for you?**

Only if you use Shopify and sell products with different VAT rates — for example, groceries (7%) together with cooking accessories (19%), or books (7%) together with stationery (19%).

In this case, there may be a deviation of approximately ±0.5–2% from the actual net value, because we have to calculate using an average tax rate.

For everyone else: exactly zero deviation.

---

The problem: Shopify withholds the tax from us

Shopify provides us with certain data fields in the tracking pixel. According to the official Shopify documentation, the `subtotalPrice` field should contain the goods value before taxes and before shipping — exactly what we need. In practice, for many shops, it still includes the VAT. This is a known, open gap in Shopify — with no fix date.

What Shopify additionally doesn't give us: the tax broken down by products or separately for shipping costs. We only receive a single number — the total tax on everything combined.

---

Our solution

We calculate the net value ourselves — as accurately as possible with the available data:

```
Tax rate      = Total tax ÷ (Total revenue − Total tax)
Shipping tax  = Shipping costs × Tax rate
Product tax   = Total tax − Shipping tax
Net revenue   = Total revenue − Shipping costs − Product tax
```


Calculation example (shop with mixed tax rates):

A customer buys:

- 1x olive oil (7% VAT) — €9.99 gross
- 1x frying pan (19% VAT) — €49.99 gross
- Shipping — €4.90 gross

What Shopify gives us:

<table class="wikitable" id="bkmrk-%C2%A0-%C2%A0-gesamtumsatz-%28br"><tbody><tr><th> </th><th> </th></tr><tr><td>Total revenue (gross incl. shipping)</td><td>€64.88</td></tr><tr><td>Shipping costs (gross)</td><td>€4.90</td></tr><tr><td>Total tax (black box — everything combined)</td><td>€9.41</td></tr></tbody></table>

What we calculate from this:

<table class="wikitable" id="bkmrk-%C2%A0-%C2%A0-steuersatz-%28durc"><tbody><tr><th> </th><th> </th></tr><tr><td>Tax rate (average)</td><td>9.41 ÷ (64.88 − 9.41) = 16.97%</td></tr><tr><td>Shipping tax</td><td>4.90 × 16.97% = €0.83</td></tr><tr><td>Product tax</td><td>9.41 − 0.83 = €8.58</td></tr><tr><td>Net revenue (tracked)</td><td>64.88 − 4.90 − 8.58 = €51.40</td></tr></tbody></table>

For comparison — the actual net value:

<table class="wikitable" id="bkmrk-%C2%A0-%C2%A0-oliven%C3%B6l-netto-9"><tbody><tr><th> </th><th> </th></tr><tr><td>Olive oil net</td><td>9.99 ÷ 1.07 = €9.34</td></tr><tr><td>Frying pan net</td><td>49.99 ÷ 1.19 = €42.01</td></tr><tr><td>Actual net revenue</td><td>€51.35</td></tr><tr><td>Deviation</td><td>€0.05 = ~0.1%</td></tr></tbody></table>

In this example, the deviation is minimal. The more extreme the ratio between 7% and 19% products, the greater it becomes — but it always stays below 2%.