Import customers and suppliers in bulk
Here you bring in the third-party list of another tool or a paper register.
How to
- In Customers or Suppliers, « More actions », then « Import from a file or a document ».
- Drop the file (or « Download the template » to start from the template).
- If a column is not recognised, set it, then « Apply and check ».
- Review: to create, already there, with errors. Fix a row, then « Check again ».
- Click « Create N third parties », then download the report of rows not taken.
Learn more
The import reads an Excel or a CSV, or a list read by the AI (PDF, scan, up to 12 photos). Columns are recognised by their name; those you set by hand are kept for the next file. Nothing is created before you click.
How duplicates are found
First the same tax ID, then the same code, then the same name (case, accents, punctuation and legal form such as SARL or SA ignored), in the book then in the rows above in the file. Two companies can share a name: tick « Same name, another one: create anyway » on the row. That choice is kept in the audit log.
Customer or supplier, and control account
The Type column says Customer, Supplier or Both. With no type, the control account decides (41 customer, 40 supplier), else the page you import from. The control account is written in the book's account length (411 becomes 41100000 in 8 digits). The default control account is set in Book settings > Bulk imports.
Frequently asked questions
No. Set the column once; the name is kept. You can also add it in Book settings > Bulk imports, for this book or for all the organization's books.