1. In the pop-up window, click Download a sample of the XSLX file 
2. Open the downloaded document to see the format and be able to work on it

Fill in the fields indicated below. Those that are mandatory have been marked with an asterisk (*):

You will notice that not all the fields in the template are required. However, we recommend that you report as many as you can so that the information in Holded is as detailed as possible.

If you have left any field blank when importing, you can always report it later from the platform.

Document number *	Include on each line. We recommend you follow the sample content
Num format	Follow the proposed format for numbering
Date dd/mm/yyyy*	Enter in  dd/mm/yyyy format
Due date dd/mm/yyyy*	After that date, the delivery note will change its status in Holded.
Description	Additional information about the order
Contact name*	Include the customer to whom the order is addressed
NIF*	It is important to include this field to relate the order with the contact
Address	Add the contact's billing address
City	Location of contact address
Postal code	Add the contact address code
Province	Region where this address is located
Country	Country to which the address belongs
Concept*	Include the names of the products (one per line)
Product description	Additional information on the introduced product
SKU*	With this field, you can relate the orders with products that are already registered on the platform
Unit price*	Enter the price per product, not including taxes
Units*	Add the number of units for Holded to perform the calculation
Discount %	Add the discount for each product per line
IVA %*	Add the VAT % for the corresponding accounting adjustment. You must include the key of the tax that you will find in Settings > Invoicing > Taxes. Example: If you need to include a 21% VAT, you must indicate the following key: p_iva_21
Retention %	In the event that the order contains an additional retention. You must include the key of the type of retention that you will find in Settings> Invoicing > Taxes
Rec. de eq. %
Operation	In the column of the Excel document you will have to specify the scheme with one of the following values: intra (intracommunity) general (general) impexp (import / export) nosujeto (not subject) exento (exempt) receq (equivalence surcharge) This information will be reflected in Operation in the Accounting section of the contact
Payment Method (ID)	You must  include the API KEY of the payment method. First generate the Key from Settings > Developers > + New API Key. To finish, go to Settings > Billing > Payment Methods and click on the corresponding payment method. In the pop-up window copy the API code that you will find at the bottom next to the plug symbol.
Tags separated by -	Labels or tags used to organize your documents. Use a hyphen (-) to separate them
Sales channel name	Personalized name where your orders from the same accounting account will be grouped
Channel account	Add the sales account to keep a correct accounting. You can find the numbering corresponding to the sales account from Settings > Invoicing > Preferences > Sales and Expenses
Currency	Specify the order currency
Currency exchange	Include it if you want to keep the order change

Once you have completed the template fields, save the spreadsheet in excel or csv format to be able to import the information correctly.

To ensure that the import works correctly, remember not to leave empty cells between the order numbers. Also, do not merge cells in the spreadsheet.

1. From Waybills, go back to the three-dot menu (⋮)
2. Click Import
3. Click the Upload file button 
4. Select the spreadsheet or template that you have previously saved
5. Confirm the action