First of all:
Open the Menu at the top right
Click on Import
In the Sales section, select Corrective invoices
Import corrective sales invoices
You can import invoices issued in the current year or in other years. To carry out this process correctly, you have at your disposal a CSV/Excel template that you simply download, fill in and upload again to the platform.
1. Download the import template
Open the import modal as explained above.
Download the CSV/Excel template to view the import format
Open the downloaded document to be able to work on it.
2. Fill in the template
Fill in the fields below. Those that are essential are marked with an asterisk (*), while those that require prior configuration in Holded are marked with a circumflex accent (^).
Document number* | Enter the number of your amendment sale. |
Date | Accepted format is dd/mm/yyyy (day/month/year) |
Due date* | Sets the date when the invoice will change status to Holded |
Internal description | Adds a short private description of the concept of your amendment |
Contact name | Include the name of the customer the invoice is addressed to |
VAT NUMBER*. | It is important to include this field so that the invoice relates correctly to the contact person |
Address | Enter the billing address of the contact |
Town | Refers to the contact's address location |
Postcode | The postal code of the contact's address |
Province | Region where the contact is located |
Country | The country where the contact is fiscally resident |
Concept | Include product names, one per product line |
Description | Add additional public information about the product |
SKU | Add the SKU of the product |
Unit price* | Includes price per item, excluding tax |
Unit price* | Add the number of units of the item |
Discount | Include the discount percentage if there is one |
VAT%*^ | Enter the VAT %. It is necessary to include the key of the tax that you will find in Configuration > Invoicing > Taxes |
Withholding tax | Add the additional withholding tax |
Rec. of eq. | Fill in this field if the invoice contains the additional withholding tax. |
Transaction | Write the type of invoice, e.g. if it is an intra-community invoice or a general invoice. |
Form of payment^ | Add the API Key of the payment method. First you will have to generate it in Configuration>Developers and then, to finish the process, you will have to go to Configuration>Invoicing>Payment methods, add a payment method and copy the number in blue that appears on the tab, next to the plug icon. |
Amount charged | Fill in this field with the amount of money (including taxes) already collected for this invoice. |
Date of collection | The date on which the collection has been received. |
Payment account | Add the accounting account where the payment has been made to the customer. |
Tags | Include tags to categorise your invoices. They must be separated by a "-". |
Sales channel name | Customise the name where invoices from the same account will be grouped. |
Sales channel account^ | Add the sales accounting account of your invoice. If you leave this column blank, the system will automatically assign the last account of each group. For example, if you have generated 11 accounting accounts for Sales and Revenue, 700000011 will appear. |
Currency | Includes the currency of the sales amendment. |
Currency exchange | Fill in this field if you need to keep the currency exchange rate. |
In case you leave blank lines between invoices, the template will not be imported. It is important to add the data without leaving space and in a correlative way, as it is not possible to combine lines from different invoices.
3. Upload the template information
From Import, go back to Sales
Click on Corrective invoices
Click the Upload file button
Select the spreadsheet with the completed fields that you have previously saved
Confirm the action