7.05 Import companies

In Vera you can upload your companies via a csv file. Please follow the next steps to import your companies.

1. Go to companies 
2. Navigate to the button “ Import companies” 
   1. Click on the blue button “Import companies”
   2. A new modal will open with instructions
   3. Please download the file to import your companies from inside the modal
   4. Fill in the file
   5. Upload the completed file

Columns:

1. VAT number
   1. Please fill in the VAT number
   2. Vera will automatically format the VAT number without BE, spaces and dots
   3. If a company already exists with the same VAT number it will be overwritten with the new data
2. Company name
   1. Name of the company, free text
3. Email 1
   1. Fill in the first email of the company
4. Email 2
   1. Fill in the second email of the company
5. Phone number
   1. Fill in the phone number using this format: 32 478 11 11 11
6. Mobile phone number 
   1. Fill in the mobile phone number using this format: 3258 78 98 78
7. Language
   1. Dutch, French or English
      1. Values: please fill in the corresponding value
         1. Dutch => 0
         2. French => 2
         3. English => 1
8. Address
   1. Please fill in the address
   2. Example: Nieuwpoortsesteenweg 104
9. City
   1. Please fill in the city 
   2. Example: Gent
10. Postal code
    1. Please fill in the postal code
    2. Example: 9000
11. IBAN
    1. Please fill in a valid IBAN
12. BIC 
    1. Please fill in a valid BIC
13. Payment term 
    1. Please fill in a payment term, this will be used when an invoice has been scanned by the scanner but no due date could be found on the invoice. Vera will look at the payment term filled in on the company and prefill the due date accordingly.