All Collections
All settings
Simplified customer import
Simplified customer import

Find out how to import customers with the simplified procedure

Jacqui Sullivan avatar
Written by Jacqui Sullivan
Updated over a week ago

It is possible to import customer data from a file in csv format configured with a simplified structure.

Before importing, you need to make sure that the customer groups and payment terms already exist in Cloud Accounting.

In particular, for the terms of payment it is necessary to indicate the exact description on the management system.

Where to import from

Import can be done in 2 areas:

Import data , accessing from All settings > Company and clicking on the Import button on Customers.

Alternatively, you can go to the Sales tab > customers > click on the import icon > select Import customers and then select Customers

A window appears from which to manage the import of customers.

The operations to be performed are the following:

  • Download and edit the file

  • Enter the configuration data

  • Select the csv file to import the data it contains

How to create the csv file

The first thing to do is to create the csv file.

Click Download a sample file.

  • Once the file has been downloaded, simply open it using Microsoft Excel, Google sheets or other spreadsheets.

  • Enter the customer data in the respective columns, without changing the title of the columns themselves as this would make it impossible for the application to recognize which data to import on each column.

The columns of the file

To identify the required data and enter all the information correctly, you need to download the file containing the guidelines by clicking on " See an example file with guidelines" in which notes are highlighted in each column to follow to enter the data in the import file.

The mandatory data columns are indicated in bold on the example file and the import file are the following:

  • the No .: must be a unique number and can have up to 5 numbers

  • the Name : must be text and can be up to 255 characters long

  • the Customer Group: this is a whole number of up to 9 characters. It is sufficient to indicate the number that identifies the group and must already exist in Cloud Accounting. The customer group is a mandatory data because, not only does it allow customers to be classified, but above all, it serves to determine the balance sheet to be used in the accounting records of invoices and payments.

  • the VAT Zone: 1 Domestic, 2 EU, 3 abroad and 4 domestic no vat.

  • the Currency Code: it's necessary to indicate the currency code of the customer you are importing.

The recommended data are:

  • VAT number: the VAT registration of the customer if known.

  • the Currency: the currency code you will be invoicing the customer in

  • Payment terms : the payment terms must already exist in Cloud Accounting and the exact description must be entered on the file.

  • Payment method : you must indicate the exact description of the payment deadline from Hades in the tabular representation of the electronic invoice. If nothing has been indicated in the file, Bank Transfer will be reported.

  • Address: indicate the address

  • Postal Code: indicate the post code

  • Town/City: indicate the city

  • County: indicate the county

  • Country: enter the name of the country

  • e-mail: indicate the e-mail address

  • Telephone number: if available enter this

  • Other reference: the contact name or office / recipient

  • Finally, among the optional data there are:

  • Discount (%) : indicate the " . " as decimal separator

  • Website: the clients website

  • Access: enter 1 for access

Once all the data to be imported has been entered on the Example file, it is sufficient to save it in csv (UFT-8) format has been set

Configure the import

In the configuration it is possible

  • indicate the default customer group, which will be assigned automatically if it has not been defined on the file

  • Indicate whether not to import existing customers to Cloud Accounting

  • Indicate whether to update existing customers.

  • Within section 3 select your saved csv file and click Import & Save

You will then see confirmation the import is complete and your customers can be viewed within Sales > Customers.

Did this answer your question?