Bulk Upload (Accounting Tool)
Last updated
Last updated
You can access this section from the left menu Accounting >> Bulk Upload.
In this section, you can upload via Excel file information regarding:
product VAT rates
external sales
product values
You can access this section from the left menu Accounting >> Bulk Upload >> Product VAT rates.
In this section you can assign VAT rates to your products in bulk.
You can download various templates for data upload:
Empty VAT rates Template: contains only headers and is to be filled in line by line by the user.
Current VAT rates Template: in addition to the headers, this template already contains all the VAT rates currently associated to the products
Then you will need to fill in the template with the following information for each product:
product: ASIN or SKU code of the product
country code: ISO code of the country (e.g., IT, DE, FR...)
rate: 10% or 0.1
Product ASIN | Country | VAT Rate |
ASIN__12345 | ES | 10% |
ASIN__12346 | IT | 10% |
ASIN__12347 | DE | 7% |
Once you have filled out the file, save it and upload it in the "Select File" field.
Check the import result in the notification center.
You can access this section from the left menu Accounting >> Bulk Upload >> External Sales.
In this section you can upload in bulk sales, refunds and invoices from channels that are not currently integrated with ZonWizard.
First, download the template by clicking on the download icon.
Then, you'll need to fill out the template with the following information for each sale:
Payment date: in Excel date format
Order ID: order identification code
Product ID: unique product code
Quantity: number of items sold
Product price: total price of products including VAT
Shipping price: shipping price including VAT
Currency: ISO currency code (e.g., EUR, GBP, USD).
Shipping country code: ISO code of the departure country of shipment (e.g., DE, FR, ES)
Arrival country code: ISO code of the destination country of the shipment (e.g., DE, FR, ES)
Marketplace: name of the marketplace, only one of the following supported values can be entered:
Shopify
ManoMano
Etsy
WooCommerce
Zalando
Leroymerlin
Decathlon
Prestashop
Other
If there's an invoice associated with the sale, also fill in the following optional fields:
Invoice number: invoice identification number
B2C or B2B: 0 for private customers or 1 for business customers
VIES invalid or valid: 0 for customers with VAT numbers not registered with VIES or 1 for VAT-registered customers
The following table provides an example of compilation
Payment date | Order ID | Product ID | Quantity | Product price (incl. VAT) | Shipping price (incl. VAT) | Currency | Shipping country code | Arrival country code | Marketplace | Invoice number | B2C or B2B (0 or 1) | VIES invalid or valid (0 or 1) |
2023-12-01 | 123.456.789 | SKU1 | 1 | 20.30 | 4.55 | EUR | IT | DE | Shopify | INV-2023-011 | 1 | 1 |
2023-12-02 | 123.456.790 | SKU2 | 1 | -35.30 | 0.00 | EUR | IT | FR | Shopify | CN-2023-002 | 1 | 1 |
2023-12-03 | 123.456.791 | SKU3 | 1 | 22.55 | 7.40 | EUR | IT | FR | Shopify | |||
2023-12-04 | 123.456.792 | SKU4 | 1 | 11.23 | 4.55 | EUR | IT | ES | Shopify | INV-2023-012 | 1 | 1 |
2023-12-05 | 123.456.793 | SKU1 | 1 | 56.30 | 5.30 | EUR | IT | DE | WooCommerce | |||
2023-12-06 | 123.456.794 | SKU2 | 2 | -34.20 | 7.40 | EUR | IT | FR | WooCommerce | |||
2023-12-07 | 123.456.795 | SKU3 | 1 | 12.50 | 4.55 | EUR | IT | FR | WooCommerce | INV-2023-013 | 1 | 0 |
2023-12-05 | 123.456.793 | SKU4 | 1 | 120.00 | 5.30 | EUR | IT | ES | WooCommerce |
Once you've filled out the file, save it and upload it in the "Select File" field.
Check the import result in the notification center.
If the external sales you inserted have a reduced rate (e.g., for food or pharmaceutical products), you can set the product rate in the Reduced Rates section.
You can access this section from the left menu Accounting >> Bulk Upload >> Value of Products Transferred.
Here you can assign a value to your products in bulk. This value will be used to calculate the monetary value of goods transferred between Amazon warehouses.
If you have already configured the purchase cost of the products in the Profit Tool, the value of the products will be automatically assigned based on that.
For an approximate assignment of product value, you can indicate the value as a percentage of the selling price.
To do this, enter a percentage in the input field and click the "Assign to all products" button.
If you have already assigned the cost of products within the Profit tool, you can retrieve the value of the products based on this.
To do this, simply click the "Update from profit tool" button.
You can download various templates for data upload:
Current Product Value Template: in addition to the headers, this template already contains all the VAT rates currently associated to the products
To Be Configured Product Value Template: in addition to the headers, this template already contains only the SKUs to which a value has not yet been assigned.
Then you will need to fill in the template with the following information for each product:
product: ASIN or SKU code of the product
Product Value: the value in EUR to be assigned to the product
Product [sku or asin]* | Product Value [EUR] |
SKU_12049 | € 5.84 |
SKU_14081 | € 3.18 |
SKU_1567 | € 5.29 |
SKU_18301 | € 10.00 |
SKU_20721 | € 12.78 |
Check the import result in the notification center.