VAT total

This page explains the calculation types, dimensions and filters available to you for the key figure VAT total. This page is for reference purposes only and assumes that you already have basic knowledge about the plentyBI tool.

PlentyONE calculates the VAT total by subtracting the net prices of the order items from the gross prices of the order items. The results are then summed up:
(Gross price - net price) = VAT amount
∑ VAT amount = VAT total
In addition, select a dimension to determine how the result is grouped. Set filters to specify the criteria for the calculation of the VAT total.

1. plentyBI edition

How many and which key figures and corresponding dimensions you can create depends on the edition you have booked.

2. Dimension

2.1. Item category, creation date

The VAT total is displayed grouped by item category and creation date. This way, you can see at a glance how high the VAT amount is broken down by item category. A further differentiation is made according to the creation date of the orders.

2.2. Order referrer plugin, creation date

The VAT total is displayed grouped by order referrer (further grouped by plugin) and creation date. This way, you can see at a glance how high the VAT amount is broken down by plugins that create orders in your PlentyONE system. A further differentiation is made according to the creation date of the orders.

2.3. Order referrer, creation date

The VAT total is displayed grouped by order referrer and creation date. This way, you can see at a glance how high the VAT amount is broken down by order referrer. A further differentiation is made according to the creation date of the orders.

2.4. Order referrer, completion date

The VAT total is displayed grouped by order referrer and date of outgoing items. This way, you can see at a glance how high the VAT amount is broken down by order referrer. A further differentiation is made according to the date on which outgoing items were booked for the orders.

2.5. Order referrer, payment date

The VAT total is displayed grouped by order referrer and payment date. This way, you can see at a glance how high the VAT amount is broken down by order referrer. A further differentiation is made according to the date on which a payment was assigned to the order.

2.6. Creation date

The VAT total is displayed grouped by creation date. This means that the date on which the orders were created is considered in the calculation.

2.7. Manufacturer, creation date

The VAT total is displayed grouped by manufacturer and creation date. This way, you can see at a glance how high the VAT amount is broken down by manufacturer. A further differentiation is made according to the creation date of the orders.

2.8. Contact, creation date

The VAT total is displayed grouped by contact and creation date. This way, you can see at a glance how high the VAT amount is broken down by contact. A further differentiation is made according to the creation date of the orders.

2.9. Warehouse, creation date

The VAT total is displayed grouped by warehouse and creation date. This way, you can see at a glance how high the VAT amount is broken down by warehouse. A further differentiation is made according to the creation date of the orders.

2.10. Warehouse, completion date

The VAT total is displayed grouped by warehouse and date of outgoing items. This way, you can see at a glance how high the VAT amount is broken down by warehouse. A further differentiation is made according to the date on which outgoing items were booked for the orders.

2.11. Warehouse, payment date

The VAT total is displayed grouped by warehouse and payment date. This way, you can see at a glance how high the VAT amount is broken down by warehouse. A further differentiation is made according to the date on which a payment was assigned to the order.

2.12. Delivery country, creation date

The VAT total is displayed grouped by delivery country and creation date. This way, you can see at a glance how high the VAT amount is broken down by country of delivery. A further differentiation is made according to the creation date of the orders.

2.13. Client, creation date

The VAT total is displayed grouped by client and creation date. This way, you can see at a glance how high the VAT amount is broken down by client. A further differentiation is made according to the creation date of the orders.

2.14. Client, completion date

The VAT total is displayed grouped by client and date of outgoing items. This way, you can see at a glance how high the VAT amount is broken down by client. A further differentiation is made according to the date on which outgoing items were booked for the orders.

2.15. Client, payment date

The VAT total is displayed grouped by client and payment date. This way, you can see at a glance how high the VAT amount is broken down by client. A further differentiation is made according to the date on which a payment was assigned to the order.

2.16. Invoice country, creation date

The VAT total is displayed grouped by invoice country and creation date. This way, you can see at a glance how high the VAT amount is broken down by invoice country. A further differentiation is made according to the creation date of the orders.

2.17. Return reason, creation date

The VAT total is displayed grouped by return reason and creation date. This way, you can see at a glance how high the VAT amount is broken down by return reasons. A further differentiation is made according to the creation date of the orders.

2.18. Date of outgoing items

The VAT total is displayed grouped by date of outgoing items. This means that the date on which outgoing items were booked for the orders is considered in the calculation.

2.19. Payment method, creation date

The VAT total is displayed grouped by payment method and creation date. This way, you can see at a glance how high the VAT amount is broken down by payment method. A further differentiation is made according to the creation date of the orders.

2.20. Payment date

The VAT total is displayed grouped by payment date. This means that the date on which a payment was assigned to the orders is considered in the calculation.

3. Filters

Filters allow you to narrow down the data calculated by the key figure. The following chapters contain an overview of all available filters.

Important: Different filters are available depending on the dimension you have selected for the key figure.

3.1. Amazon account

Filters the selected key figure and dimension additionally by one or several amazon accounts. For this filter you can select the amazon accounts that are saved in your system. Select a comparison operators on the left and then the desired accounts (check_box).

3.2. Item ID

Filters the selected key figure and dimension additionally by one or several item IDs. Select a comparison operator on the left and enter the desired item IDs into the text field separated by comma.

3.3. Order referrer

Filters the selected key figure and dimension additionally by one or several order referrers. For this filter you can select the order referrers that are available in your system. Select a comparison operator on the left and then the desired order referrers (check_box).

3.4. Order item type

Filters the selected key figure and dimension additionally by one or several order item types. The available selection of order item types depends on the selected key figure and dimension. Select a comparison operator on the left and then the desired order item types (check_box).

3.5. Order status

Filters the selected key figure and dimension additionally by one or several order statuses. For this filter you can select the order statuses that have been setup in your system. Select a comparison operator on the left and then the desired order statuses (check_box).

3.6. Order type

Filters the selected key figure and dimension additionally by one or several order types. The available selection of order types depends on the selected key figure and dimension. Select a comparison operator on the left and then the desired order types (check_box).

Note that the VAT amounts of order items in credit notes and returns are subtracted from the total VAT amount if you select these order types in this filter.

3.7. Paid at

Filters the selected key figure and dimension additionally by the date of receipt of payment. Select a comparison operator on the left. Then determine the desired date or time period on the right.

3.8. eBay account

Filters the selected key figure and dimension additionally by one or several eBay accounts. For this filter you can select the eBay accounts that are saved in your system. Select a comparison operator on the left and then the desired accounts (check_box).

3.9. Revenue account

Filters the desired key figure and dimension additionally by revenue accounts. For this filter you can select the revenue accounts that have been set up in your system. Select a comparison operator on the left and then enter the desired revenue account.

3.10. Created at

Filters the selected key figure and dimension additionally by the creation date of the orders. Select a comparison operator on the left. Then determine the desired date or time period on the right.

3.11. Manufacturer

Filters the selected key figure and dimension additionally by one or several manufacturers. For this filter you can select the manufacturer data records that have been set up in your system. Select a comparison operator on the left and then the desired manufacturer data records (check_box).

3.12. Contact ID

Filters the selected key figure and dimension additionally by one or several contact IDs that are linked with the messages. For this filter you can select the contact IDs that are available in your system. Select a comparison operator on the left and enter the desired contact IDs into the text field separated by comma.

3.13. Warehouse

Filters the selected key figure and dimension additionally by one or several warehouses. For this filter you can select the warehouses that have been set up in your system. Select a comparison operator on the left and then the desired warehouses (check_box).

3.14. Delivery country

Filters the selected key figure and dimension additionally by one or several countries of delivery. For this filter you can select the countries of delivery that have been set up in your system. Select a comparison operator on the left and then the desired countries of delivery (check_box).

3.15. Client

Filters the selected key figure and dimension additionally by one or several clients. For this filter you can select the clients that have been set up in your system. Select a comparison operator on the left and then the desired clients (check_box).

3.16. Invoice country

Filters the selected key figure and dimension additionally by one or several invoice countries. For this filter you can select the countries that are available in your system. Select a comparison operator on the left and then the desired invoice countries (check_box).

3.17. Return reason

Filters the selected key figure and dimension additionally by one or several return reasons. For this filter you can select the return reasons that have been set up in your system. Select a comparison operator on the left and then the desired return reasons (check_box).

3.18. Order property type

Filters the selected key figure and dimension additionally by order property types. Select a comparison operator on the left and then the desired order property type (check_box). If you want to narrow down the selected type even further, use the filter Order property value. By additionally setting this filter, you can define your own values, which are then applied to the type.

3.19. Variation ID

Filters the selected key figure and dimension additionally by one or several variation IDs. Select a comparison operator on the left and enter the desired variation IDs into the text field separated by comma.

3.20. Shipping provider

Filters the selected key figure and dimension additionally by one or several shipping service providers. For this filter you can select the Shipping service providers that have been set up in your system. Select a comparison operator on the left and then the desired shipping service providers (check_box).

3.21. Shipping profile

Filters the selected key figure and dimension additionally by one or several shipping profiles. For this filter you can select the shipping profiles that have been set up in your system. Select a comparison operator on the left and then the desired shipping profiles (check_box).

3.22. Outgoing items booked

Filters the selected key figures and dimensions additionally by whether outgoing items have been booked. Select a comparison operator on the left.

3.23. Date of outgoing items

Filters the selected key figures and dimensions additionally by the date at which outgoing items have been booked. Select a comparison operator on the left. Then determine the desired date or time period on the right.

3.24. Order property value

Is used in combination with the filter Order property type. This combination filters the selected key figure and dimension additionally by order property values that you defined yourself. Select a comparison operator on the left and enter the corresponding values for whichever order property type you selected. Use commas to separate multiple values.

3.25. Payment method

Filters the selected key figure and dimension additionally by one or several payment methods. For this filter you can select the payment methods that have been set up in your system. Select a comparison operator on the left and then the desired payment methods (check_box).

3.26. Payment status

Filters the desired key figure and dimension additionally by the payment status. Select a comparison operator on the left and then the desired status.