Import a waybill
In Holded you can import your waybills, both current and from previous dates, following these steps:
Go to Menu > Import
In the Inventory category, click "Delivery Notes":
✨ Alternative path: Inventory > Delivery Notes > Three-dot menu ( ⋮ ) > Import
Click "Download a sample XSLX file":
Open the downloaded document
Fill in the fields and save the document in CSV or Excel format
✨ If you left any field blank when importing, you can always report it later from the platform
Go back to Menu > Import , and, in Inventory, press "Delivery Note"
Click the "Upload file" button or drag the document on the dotted line:
Confirm the action
💎 Activate the Inventory gem to use Delivery Notes and for comprehensive management of your products
Export a packing slip
Click on the "Export" icon, at the top of the list, and choose whether to export the waybills in Excel, PDF or by items:
💡 The Export Items option allows you to export waybills broken down by product
✨ The filters and dates selected in the list will be saved in the download file
Fill in the fields of the import template
Below you will see the fields contained in the Excel import template. Those required have been marked with an asterisk (*):
Document *: include on each line. We recommend following the sample content
Numbering format : Follow the suggested format
Date dd/mm/yyyy* : Enter in dd/mm/yyyy format
Expiration date dd/mm/yyyy* : after this date the sales waybill will change its status to Holded
Description : additional information about the packing slip
Contact name* : include the customer to whom the waybill is addressed
NIF* : it is important to include this field to link the waybill with the contact
Address : add the contact's billing address
Population : location of contact address
Postal code : add the code of the contact address
Province : region where this address is located
Country : country to which the address belongs
Concept *: include product names (one per line)
Product description : additional product information entered
SKU *: with this Holded field you can associate the waybills with products that are already registered on the platform
Unit price *: enter the price per product, excluding tax
Units *: add the number of units so that Holded can perform the calculation
Units received : include the number of units received
Discount % : add the discount of each product per line
VAT % *: add the VAT % for the corresponding accounting adjustment. You must include the tax key that you will find in Settings > Billing > Taxes Example: If you need to include a 21% VAT, you must indicate the following key: p_iva_21
Withholding % : in the event that the waybill contains an additional withholding. You must include the withholding type key that you will find in Settings > Billing > Taxes
Rec. of eq. %: indicates the equivalency surcharge , according to the VAT of the item
Operation : in the Excel document column you will have to specify the regime with one of the following values: intra (intra-community), 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 : 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 > Ways to payment , and click on the corresponding payment method. In the popup window, copy the API code that you will find at the bottom next to the plug symbol:
Tags separated by - : tags or tags used to organize your documents. Use a hyphen (-) to separate them
Sales channel name : personalized name where your waybills from the same accounting account will be grouped
Sales channel account : Add the sales account to keep correct accounting. You can find the numbering corresponding to the sales account from Configuration > Billing > Preferences > Sales and Purchases..
Currency : specify the currency of the waybill
Change of currency : include it if you want to keep the change of the waybill
Once you have filled in the template fields, save the spreadsheet in Excel or csv format to be able to import the information correctly.
💡 To ensure the import works correctly, remember not to leave empty cells between the packing slip numbers. Also don't merge cells in the spreadsheet