First of all:
Open the Menu at the top right
Click on Import
In the Expenses section, select Tickets
Import expense tickets
You can import tickets 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 (*).
Invoice no.*. | Include on each line. We recommend you follow the sample content. |
Date dd/mm/yyyy* | Enter in dd/mm/yyyy format. |
Expiry date dd/mm/yyyy*. | After this date the ticket will change status to Holded. |
Description | Additional information about the ticket |
Name of contact person* | Include the supplier issuing the ticket |
VAT NUMBER*. | It is important to include this field to relate the ticket to the contact |
Address | Add the billing address of the contact |
Town | Location of the contact's address |
Zip/Postal code | Add the postcode of the contact address |
Province | Region where this address is located |
Country | Country to which the address belongs |
Item | Include the names of the products (one per line) |
Product description | Additional information of the product entered |
SKU | Add the SKU of the products |
Unit price | Enter the price per product, excluding tax |
Units* Add the number of units | Add the number of units so that Holded can perform the calculation |
Discount % off | Add the discount for each product per line |
Tags separated by - | Tags to organise your documents. Use a hyphen(-) to separate them. |
Payment account | Accounting account where the customer's payment has been made. |
Expense account name | Customised name where your tickets from the same account will be grouped. |
Expense account number | Add the expense account for a correct accounting. You can find the numbering corresponding to the expense or purchase account from Configuration > Invoicing > Preferences. |
Currency | Specify the currency of the ticket |
Change currency | Include it if you want to keep the change of the document. |
In case you leave blank lines, the template will not be imported. It is important to add the data without leaving space and in a correlative way, as different lines cannot be combined.
3. Upload the template information
From Import, go to Expenses> tickets again.
Click on Import
Click the Upload file button
Select the spreadsheet with the completed fields that you have previously saved.
Confirm the action