Bulk Upload (Accounting Tool)
Last updated
Last updated
You can access this section from the left menu .
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 .
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.
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.
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
In this section, you can upload invoices in bulk by uploading an Excel file.
First, download the template by clicking on the download icon.
Then you will need to fill in the template with the following information for each invoice:
Invoice N: Invoice number (mandatory parameter)
Order N: Order number (mandatory parameter)
Customer VAT id: Customer's tax code
private or business: 0 for private customer, 1 for business customer.
invoice or credit note: 0 for invoice, 1 for credit note
The following table shows an example of how to fill it in:
Invoice N. *
Order N. *
Customer VAT id
private or business
(0 or 1)
invoice or credit note (0 or 1)
INV-10-2024
123-12455-12
0
0
CN-02-2024
135-12445-12
0
1
INV-11-2024
144-12455-12
IT1254545666
1
0
Once you have filled in the file, save it and upload it in the "Choose File" field.
Check the import result in the .
You can access this section from the left menu .
Check the import result in the .
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 section.
You can access this section from the left menu .
Check the import result in the .
You can access this section from or from the invoices section .
Check the import result in the .
