---
title: "Tax inclusive prices on Shopify: correct VAT in ERP | Vokzar"
description: "Shopify sells at the final price and the ERP thinks in taxable base. Where the 1 cent difference comes from and how to pass orders without adjustments."
url: "https://vokzar.com/en/blog/shopify-tax-inclusive-prices-vat-erp/"
folder: "/en/blog/"
lang: "en"
dateModified: "2026-11-07"
timestamp: 1794009600
---

[← Back to blog](https://vokzar.com/en/blog/) ERP and integrations · 9 min · 2026-11-07

# Tax inclusive prices on Shopify: how to calculate the right VAT for your ERP

Shopify sells at the final price and the ERP thinks in taxable base. Where the 1 cent difference comes from and how to pass orders without adjustments.

VAT Shopify ERP Primavera Rounding

Summary

## What matters before moving forward.

- In Portugal, Shopify stores almost always sell with VAT included. The price the customer pays is the fixed point; base and VAT must be calculated from it, not the other way round.
- Most Portuguese ERPs were designed the other way round: price without VAT, plus VAT, equals total. Sending the final price as if it were the base produces totals that differ from what the customer paid.
- Shopify rounds VAT per line and there is no option to round on the total. An ERP that rounds per unit or at the end of the invoice will be 1 cent off on part of the orders.
- The golden rule is simple: each line total in the ERP must equal the total paid in Shopify. Base and VAT adjust to that value, not the reverse.
- In the Shopify to Primavera integration we mapped, this inversion was the first decision to make and the one that avoided hundreds of manual adjustments.

## Two systems, two logics

In Shopify, with the option to include tax in prices, the item costs 24.99 euros and that is what the customer pays. VAT is part of that value, calculated for tax purposes. Shopify's API flags this in the order's taxesIncluded field.

In the ERP, the classic logic is the reverse: the item has a price without VAT, the rate is applied and you reach the total. If the integration sends 24.99 as the price without VAT, the ERP charges 30.74. If it sends 24.99 divided by 1.23 and rounded, the ERP recalculates VAT from that base and, depending on price and quantity, the total can end up 1 cent off.

The customer paid 24.99. Any other value on the invoice or in the ERP is an error, however small, and forces adjustments when reconciling payments.

## Where the 1 cent difference comes from

Take 3 units of an item at 24.99 euros with 23% VAT. The line total is 74.97.

If the ERP calculates per unit: 24.99 divided by 1.23 is 20.317, rounded to 20.32. Three units give a base of 60.96. Applying 23% to 60.96 gives 14.02 VAT, and the total becomes 74.98. One cent more than the customer paid.

If it calculates per line: 74.97 divided by 1.23 is 60.951, rounded to 60.95. VAT is the difference, 14.02, and the total stays 74.97. The same as the customer paid.

Shopify, for its part, rounds VAT line by line. Shopify's own team confirmed in the developer community that there is no setting to round on the order total instead. An ERP that rounds at the end of the invoice will therefore differ from Shopify on some multi line orders.

## The rule that fixes it: the line total wins

The most robust way to pass orders to the ERP is to treat the total paid for each line as fixed. The integration calculates the base from that total, rounds it, and VAT is the difference between total and base. The sum of the lines then always equals what the customer paid.

Some ERPs accept documents with VAT inclusive prices and do this calculation themselves. In that case the integration should use that option instead of sending calculated bases. Others only accept prices without VAT, so the integration must send the base calculated per line and, if the ERP insists on recalculating, an explicit adjustment rule.

The worst scenario is letting each system round its own way and fixing differences by hand at month end.

## Shipping, exemptions and mixed rates

Shipping is also sold VAT inclusive in Shopify, on its own shipping line. In the ERP it is usually a service item. Under article 16(5)(b) of the Portuguese VAT Code, shipping is part of the taxable value of the goods shipped and follows their rate. In an order with only 23% items the rule is direct; with mixed rates, the split should be agreed with your accountant.

Orders with different rates, such as books at 6% and accessories at 23%, require each line to carry its own rate. Mapping every item to a single rate in the ERP is a common mistake and hard to spot, because the total matches and only VAT per rate is wrong.

Exempt orders, for example sales to businesses in other EU countries with a valid VAT number, have the taxExempt field in the API and need the correct exemption reason in the ERP.

## How to test before switching on

Pick 20 real orders from last month that include: several units of the same item, several lines, shipping, a discount, a reduced rate and a partial refund.

Run them through the integration in a test environment and compare, line by line, the ERP total with the Shopify total. Any difference, even 1 cent, is a rule error and must be fixed before going live.

Keep these 20 orders as a permanent test. Every time the integration changes, they run again.

## How Vokzar does the mapping

We start by reading how your ERP handles prices with and without VAT and define the per line calculation rule, with the total paid as the fixed value.

We map rates, shipping, exemptions and discounts to your ERP's codes, whether Primavera, PHC, Sage or another, and agree mixed rate cases with your accountant.

We deliver the integration with the set of test orders and a report comparing totals between Shopify and the ERP, so any difference shows up the same day and not at quarter close.

Related next steps

## Next steps.

- ### ERP and warehouse integration

Orders, VAT and discounts mapped into your ERP without manual adjustments.
- ### Discount codes and VAT

How to split a discount by line and by VAT rate.
- ### Shopify and Primavera

The full order mapping into Primavera.

Proof and validation

- The taxesIncluded field and per line values come from Shopify's official Admin API documentation.
- The lack of an option to round VAT on the total was confirmed by a Shopify staff member in the developer community.
- The numerical examples were calculated with 23% VAT and rounding to 2 decimals. The shipping rule summarises article 16 of the Portuguese VAT Code.

Official documentation

## Validated sources.

Technical strategy should be auditable. These sources link directly to the official documentation behind this guide.

- Shopify

### Shopify Admin API: Order object (taxesIncluded, taxExempt)
- Shopify

### Shopify Admin API: LineItem object (taxLines, discountAllocations)
- Shopify Developer Community

### Shopify Developer Community: line item rounding
- Portal das Finanças

### Portuguese VAT Code (PT)

Frequently asked questions

## Common questions about this topic.

[Map my orders into the ERP](https://vokzar.com/en/automations-integrations/erp-warehouse-integration/#pedir) [Read in Portuguese](https://vokzar.com/blog/iva-incluido-shopify-erp/)

## Want to apply this to your site?

Next step Technical audit

[Map my orders into the ERP](https://vokzar.com/en/automations-integrations/erp-warehouse-integration/#pedir)

## Frequently asked questions

**Why does the ERP total differ by 1 cent from Shopify?**

Because the systems round in different places. Shopify rounds VAT per line; if the ERP calculates from the unit price without VAT or rounds on the invoice total, it reaches different values on part of the orders.

**Should I send the ERP prices with or without VAT?**

If the ERP accepts VAT inclusive documents, send the price with VAT and let it calculate. If not, calculate the base per line from the total paid and treat VAT as the difference.

**Can Shopify round VAT on the order total?**

No. According to Shopify's team, there is no setting to switch from per line rounding to rounding on the total.

**How should shipping be handled in the ERP?**

As its own line, VAT inclusive in Shopify. Under article 16 of the Portuguese VAT Code, shipping follows the rate of the goods shipped; for mixed rate orders, agree the split with your accountant.
