First of all:
To carry out this process correctly, you have at your disposal a CSV/Excel template that you simply need to 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 (^).
Enter the number of your budget
Numbering format ^
You can define this numbering from Configuration>Invoicing>Documents.
You must include it in dd/mm/yyyy (day/month/year) format .
Sets the date on which the budget will change its status to Holded.
Add a short private description of your budget concept
Include the name of the customer to whom the quote is addressed
It is important to include this field so that the quotation can be correctly linked to the contact person
Enter the contact's billing address
Refers to the location of the contact's address
The postal code of the contact's address
Region where the contact is located
The country where the contact is fiscally resident
Include product names, one per product line
Add additional public information about the product
Add the SKU of the product
Includes price per item, excluding tax
Add the number of units of the item
Enter the percentage of the discount if there is one
Enter the VAT %. It is necessary to include the key of the tax that you will find in Configuration > Invoicing > Taxes
Add the additional withholding tax
Rec. of eq.
Fill in this field if the invoice contains the additional withholding tax.
Write the type of quotation
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 in the tab, just next to the plug icon.
Include tags to categorise your quotes. They must be separated with a "-".
Sales channel name
Customise the name where the budgets of the same account will be grouped.
Sales channel account^
Add the sales account where your budget belongs. 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.
Include the budget currency
Fill in this field in case you want 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 Budgets, access the three-dot menu (⋮) again.
Click on Import
Click the Upload file button
Select the spreadsheet with the completed fields that you have previously saved.
Confirm the action
I would like to receive personalised help
If you would prefer our Import team to give you a hand with the preparation of your files, at Holded we have a team of experts who can advise you and carry out the import for you.
Our team will assist you with the preparation of your journal, sales and purchase invoices, contacts, accounts and products. They will also help you to detect errors, correct them and organise each of your files.
This will ensure that all your business information is transferred correctly and give you peace of mind that the import will be successful.
To find out more about the service and pricing, please contact us at [email protected].