Import of invoices, clients and products
Last updated: 2021-03-24
Post view count: 1369
There is a new way of importing data concerning invoices, clients or products.
If you want to, e.g. import products to an invoice, go to: Settings> Import> New Import.
Data can be imported in the following file types: .XLS, .XLSX (Excel), .ODS. (Open Office), .TXT, .CSV, .TSV.
Important: the imported data file must be prepared according to the template available on the website, which means that it must contain the same column names and their order as in the example.
Example of column settings when importing clients below (from a CSV file):
No,ID,Short name,Client name,Tax ID,City,Post code,Street,Country,Delivery address,Company,Email,Website,Telephone,Mobile phone,Fax,Forename,Surname,Bank,Account number,Individual bank account,Additional description
2,29,Client2,Company2,123456789,Manchester,,M14 5SE,England,Brighton BN1 1YB,1,email@example.com,www.company2.com,783057782,543908373,113334455,Jane,Smith,123456789,66244455666,,
Full import instructions can be found here: