What do the columns in the "Sales by country" report correspond to?
Columns in the Sales by country report.
Rows can represent multiple orders from the same country; the total adds the selected rows. For a country total, select one billing country. See the procedure.
Shop name
Name of the shop where the order was placed.
Country
Country in the order’s billing address, even when the delivery country differs. This is not a determination of tax destination.
Order total incl. VAT (Total paid)
Total amount of the order, including VAT.
Product total excl. VAT (Total products no tax)
Sum of the prices of the products included in the order, excluding VAT. If a specific price is applied, it is taken into account. The eco-tax (eco-participation) on the products concerned is also taken into account in this sum, excluding VAT.
Total VAT on products (Total product tax)
Sum of VAT collected on products. VAT is calculated on the specific price of the product if a specific price rule was in effect at the time the order was placed. VAT on eco-tax (eco-participation) is also added to this sum for the products concerned.
Ecotax total excl. VAT (Ecotax no tax)
Sum of the amounts corresponding to the eco-tax, for the products concerned, excluding VAT. As a reminder, this sum is already included in Total products excl. VAT. This column is useful for your eco-tax declaration forms.
Total VAT on ecotax (Ecotax tax amount)
Sum of VAT collected on eco-tax amounts, for the products concerned. As a reminder, this total VAT on eco-taxes is already included in the Total VAT on products. This column is useful for your VAT and eco-tax declaration forms.
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.
Wrapping cost total excl. VAT (Total wrapping no tax)
If you have activated the function enabling you to offer gift wrapping to your customers, this column shows the total amount of the wrapping costs, excluding VAT.
Total VAT on wrapping costs (Wrapping tax amount)
Total VAT collected on wrapping costs.
Shipping cost total excl. VAT (Total shipping)
Total amount of shipping costs, excluding VAT.
Total VAT on shipping costs (Total shipping tax)
Total VAT collected on shipping costs.
Total VAT (Total tax)
Sum of all VATs.
Please note: as the VAT on eco-taxes is already included in the Total VAT on products, the amount in the "Total VAT on eco-taxes" column is not added:
Total VAT = Total VAT on products + Total VAT on shipping costs + Total VAT on wrapping costs - |Total VAT on discounts|
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?
- What do the columns in the "VAT on products" report correspond to?
- 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?
- 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?