# Bulk Upload (Accounting Tool)

You can access this section from the left menu [**Accounting >> Bulk Upload**](https://app.zonwizard.com/transactions/massive-upload/).

In this section, you can upload via Excel file information regarding:

* **Product VAT rates**
* **External sales**
* **Invoices**
* **Product values**

## Bulk upload product vat rates <a href="#kmlpx7hyavkd" id="kmlpx7hyavkd"></a>

You can access this section from the left menu [**Accounting >> Bulk Upload >> Product VAT rates**](https://app.zonwizard.com/transactions/massive-upload/).

In this section you can assign **VAT rates** to your products in bulk.

<figure><img src="/files/DUbSVpE7BDtxf4d5gEM5" alt="" width="563"><figcaption><p>Bulk upload VAT rates</p></figcaption></figure>

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**](https://app.zonwizard.com/customnotifications/unread/).

## Bulk upload external sales <a href="#h2nddgitteda" id="h2nddgitteda"></a>

You can access this section from the left menu [**Accounting >> Bulk Upload >> External Sales**](https://app.zonwizard.com/transactions/massive-upload/).

In this section you can upload in bulk **sales, refunds and invoices** from channels that are not currently integrated with ZonWizard.

<figure><img src="/files/4DCmqLQrNy0WZJoVJrUy" alt="" width="563"><figcaption><p>Bulk upload external sales</p></figcaption></figure>

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:
  * 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

<table data-header-hidden><thead><tr><th width="191"></th><th width="132"></th><th width="128"></th><th width="111"></th><th width="158"></th><th width="184"></th><th></th><th width="160"></th><th width="149"></th><th width="149"></th><th></th><th width="130"></th><th width="163"></th></tr></thead><tbody><tr><td><strong>Payment date</strong></td><td><strong>Order ID</strong></td><td><strong>Product ID</strong></td><td><strong>Quantity</strong></td><td><strong>Product price (incl. VAT)</strong></td><td><strong>Shipping price (incl. VAT)</strong></td><td><strong>Currency</strong></td><td><strong>Shipping country code</strong></td><td><strong>Arrival country code</strong></td><td><strong>Marketplace</strong></td><td><strong>Invoice number</strong></td><td><strong>B2C or B2B (0 or 1)</strong></td><td><strong>VIES invalid or valid (0 or 1)</strong></td></tr><tr><td>2023-12-01</td><td>123.456.789</td><td>SKU1</td><td>1</td><td>20.30</td><td>4.55</td><td>EUR</td><td>IT</td><td>DE</td><td>Shopify</td><td>INV-2023-011</td><td>1</td><td>1</td></tr><tr><td>2023-12-02</td><td>123.456.790</td><td>SKU2</td><td>1</td><td>-35.30</td><td>0.00</td><td>EUR</td><td>IT</td><td>FR</td><td>Shopify</td><td>CN-2023-002</td><td>1</td><td>1</td></tr><tr><td>2023-12-03</td><td>123.456.791</td><td>SKU3</td><td>1</td><td>22.55</td><td>7.40</td><td>EUR</td><td>IT</td><td>FR</td><td>Shopify</td><td></td><td></td><td></td></tr><tr><td>2023-12-04</td><td>123.456.792</td><td>SKU4</td><td>1</td><td>11.23</td><td>4.55</td><td>EUR</td><td>IT</td><td>ES</td><td>Shopify</td><td>INV-2023-012</td><td>1</td><td>1</td></tr><tr><td>2023-12-05</td><td>123.456.793</td><td>SKU1</td><td>1</td><td>56.30</td><td>5.30</td><td>EUR</td><td>IT</td><td>DE</td><td>WooCommerce</td><td></td><td></td><td></td></tr><tr><td>2023-12-06</td><td>123.456.794</td><td>SKU2</td><td>2</td><td>-34.20</td><td>7.40</td><td>EUR</td><td>IT</td><td>FR</td><td>WooCommerce</td><td></td><td></td><td></td></tr><tr><td>2023-12-07</td><td>123.456.795</td><td>SKU3</td><td>1</td><td>12.50</td><td>4.55</td><td>EUR</td><td>IT</td><td>FR</td><td>WooCommerce</td><td>INV-2023-013</td><td>1</td><td>0</td></tr><tr><td>2023-12-05</td><td>123.456.793</td><td>SKU4</td><td>1</td><td>120.00</td><td>5.30</td><td>EUR</td><td>IT</td><td>ES</td><td>WooCommerce</td><td></td><td></td><td></td></tr></tbody></table>

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**](https://app.zonwizard.com/customnotifications/unread/)**.**

{% hint style="warning" %}
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**](/accounting/reduced-vat-rates.md) section.
{% endhint %}

## Bulk upload product values <a href="#h2nddgitteda" id="h2nddgitteda"></a>

You can access this section from the left menu [**Accounting >> Bulk Upload >> Value of Products Transferred**](https://app.zonwizard.com/transactions/massive-upload/)**.**

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.

{% hint style="warning" %}
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.
{% endhint %}

### Assign Product Value as Percentage <a href="#z87tg9yma5za" id="z87tg9yma5za"></a>

For an approximate assignment of product value, you can indicate the value as a percentage of the selling price.

<figure><img src="/files/6Vm3Ki0de2NC8ZXnsJz4" alt="" width="563"><figcaption></figcaption></figure>

To do this, enter a percentage in the input field and click the "Assign to all products" button.

### Assign Product Value from Profit Tool <a href="#mcquytrfx93u" id="mcquytrfx93u"></a>

If you have already assigned the cost of products within the Profit tool, you can retrieve the value of the products based on this.

<figure><img src="/files/Kx5ILbEQ2PYy1r60ePUT" alt="" width="563"><figcaption></figcaption></figure>

To do this, simply click the "Update from profit tool" button.

### Assign Product Value from Excel <a href="#mcquytrfx93u" id="mcquytrfx93u"></a>

You can download various templates for data upload:

<figure><img src="/files/VpzhKVXu5bBiGNaxHLe8" alt="" width="563"><figcaption></figcaption></figure>

* **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**](https://app.zonwizard.com/customnotifications/unread/).

### Add invoices in bulk <a href="#oaoe2lqlis9x" id="oaoe2lqlis9x"></a>

You can access this section from [**Accounting >> Massive Upload**](https://app.zonwizard.com/transactions/massive-upload/) or from the invoices section [**Accounting >> Invoices >> + >> Add via Excel File**](https://app.zonwizard.com/transactions/massive-upload/).

In this section, you can upload invoices in bulk by uploading an Excel file.

<figure><img src="/files/SYNd3ogYCmxuUm7NTcSz" alt=""><figcaption><p>Add invoices massively</p></figcaption></figure>

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
* **invoice date** : (OPTIONAL)

The following table shows an example of how to fill it in:

<table data-header-hidden><thead><tr><th width="163"></th><th width="147"></th><th width="170"></th><th width="176"></th><th width="194"></th></tr></thead><tbody><tr><td>Invoice N. *</td><td>Order N. *</td><td>Customer VAT id</td><td><p>private or business</p><p>(0 or 1)</p></td><td>invoice or credit note (0 or 1)</td></tr><tr><td>INV-10-2024</td><td>123-12455-12</td><td></td><td>0</td><td>0</td></tr><tr><td>CN-02-2024</td><td>135-12445-12</td><td></td><td>0</td><td>1</td></tr><tr><td>INV-11-2024</td><td>144-12455-12</td><td>IT1254545666</td><td>1</td><td>0</td></tr></tbody></table>

Once you have filled in the file, save it and upload it in the **"Choose File"** field.

Check the import result in the [**notification center**](https://app.zonwizard.com/customnotifications/unread/).


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.zonwizard.com/accounting/bulk-upload-accounting-tool.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.