Skip to main content
All CollectionsBillsImport
Importing your purchase corrections
Importing your purchase corrections

Centralise all the history of your purchase invoice corrective invoices

Camilla avatar
Written by Camilla
Updated over a month ago

First of all:

  1. Open the Menu at the top right

  2. Click on Import

  3. In the Expenses section, select Corrective Purchases

Import Purchase Invoices for corrective purchase 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

  1. Open the import modal as explained above.

  2. Download the CSV/Excel template to view the import format

  3. 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 purchase amendment or invoice will change status to Holded.

Description

Additional information on the invoice

Name of contact person*

Include the supplier issuing the invoice

VAT NUMBER*.

It is important to include this field in order to relate the invoice to the contact person

Address

Add the contact's billing address

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

With this field, Holded will be able to relate invoices to products that are already registered on the platform.

Unit price

Enter the price per product, not including tax.

Units* Add the number of units

Add the number of units so that Holded can perform the calculation.

Discount %

Add the discount for each product per line

VAT %* ADD THE VAT % FOR THE CORRESPONDING ACCOUNTING ADJUSTMENT.

Add the VAT % for the corresponding accounting adjustment. You need to include the tax key which you will find in Configuration > Invoicing > Taxes. Example: If you need to include a 21% VAT you will have to indicate the following key: p_iva_21

Withholding %

In the case that the invoice contains an additional withholding tax

Inv. Subject. Liability (1/0)

Add a 1 if the invoice includes a reverse charge. Enter 0 otherwise

Transaction

Type of invoice (intra-Community, general...)

Amount charged

Add this amount including taxes to detail the status of the invoice.

Date of collection

Time at which the payment is issued

Payment account

Accounting account where the customer's payment was made

Tags separated by -

Tags to organise your documents. Use a hyphen(-) to separate them.

Expense account name

Customised name where your invoices from the same account will be grouped.

Expense account number

Add the expense account to keep a correct accounting. You can find the numbering corresponding to the expense or purchase account from Configuration > Invoicing > Sales and Purchases.

Currency

Specify the currency of the invoice

Currency exchange

Include it if you want to keep the exchange rate of the document.

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

  1. From Import, go again to Expenses

  2. Click on Corrective Purchases

  3. Click the Upload file button

  4. Select the spreadsheet with the completed fields that you have previously saved

  5. Confirm the action

Did this answer your question?