How to export the collected amounts by VAT rate?
You can export the products, that are under one specific VAT rate, that have been purchased during a specific period, by using the "Products" report :
You have to use the "Product" report :
- Select the “Product” report
- A period (as for example 07/01/2014 to 07/31/2014)
- In the product filtering part, select a first VAT rate (like 20%).
- You will get a report that will show you all the products, that are under the 20% VAT rate, and that have been purchased during january 2014. At the bottom of this report, you will see all the different total sums collected for this specific VAT rate.
- Then, close this report and select an other VAT rate, like 10%. You will get the same type of report but for products under the 10% VAT rate.
You can also watch the following video which explains you all of this in detail, but this is in french...
Note: some column labels have changed since this video was recorded, but the principle remains the same.
For details of the columns in the "Products" report, and all the calculations, click here.
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?
- 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?