What do the columns in the "VAT on products" report correspond to?
Columns in the VAT on products report.
The grouping is by product and order, with optional combination detail. See VAT rate analysis.
Shop name
Name of the shop where the order was placed.
Product name
Name from the order line. Enable combination detail to separate combinations; without that detail, do not assume the name is the current default combination’s name.
Product ID
The parent product ID. Combination detail separates rows, but this column does not become a combination ID.
VAT rate (Product tax rate)
VAT rate associated with the product (in percent).
Order ID
Order identifier.
Order status (Order state)
Order status at the time of report generation
Invoice number
Invoice number associated with the order.
Product reference
Reference of the product or product combination (if you decide to display details by combination).
Total quantity sold (Product total quantity)
Quantity of the product in the order identified by this row. Combination detail further splits the grouping by combination; this is not a total independent of the order.
Discount total excl. VAT (negative value) (Total discounts no tax)
Total amount of discounts applied using voucher code(s) (cart rules).
Please note: this column only calculates discounts resulting from voucher codes (cart rules). Discounts due to specific prices are not taken into account here.
Total VAT on discounts (negative value) (Discounts tax amount)
Total VAT associated with the total amount of discounts (cart rules), and which will therefore not be collected and paid to the government.
Product total excl. VAT (Product total no tax)
Total amount of the product (or product combination if you decide to display details by combination), over the selected period, excluding VAT.
If a specific price was applied when the order was placed, it is taken into account. In this sum we also take the eco-tax into account, if the product is concerned, excluding VAT.
Total VAT on products (Total product tax)
Sum of VAT collected on the product or product combination (if you decide to display details by combination):
Note: Total product excl. VAT includes specific prices (see previous section). It also includes the total amount of eco-tax if the product (or the product combination if you decide to display the detail by combination) is concerned, excluding VAT. In other words, the Total VAT on products includes the Total VAT on eco-tax, if any.
Configuration and filters · Choose a report.
Other FAQs in this category
- How to use the "Customers" report?
- How to use the "Products" and "Categories" reports?
- How to use the "VAT", "Profits and margins" and "Credit notes" reports?
- How to export the collected amounts by VAT rate?
- What do the columns in the "VAT" report correspond to?
- What do the columns in the "Profits and margins" report correspond to?
- What do the columns in the "Product credit notes by VAT rate" report correspond to?
- What do the columns in the "Shipping credit notes" report correspond to?
- What do the columns in the "Credit notes" report correspond to?
- What do the columns in the "Customers" report correspond to?
- How to use the "Sales by country" report?
- What do the columns in the "Sales by country" report correspond to?
- How to use the "Brands" and "Suppliers" reports?
- What do the columns in the "Suppliers" report correspond to?
- What do the columns in the "Brands" report correspond to?
- What do the columns in the "Categories" report correspond to?
- What do the columns in the "Products" report correspond to?
- How to use the "Full" and "Basic" reports?
- What do the columns in the "Basic" report correspond to?
- What do the columns in the "Full" report correspond to?