Help center
Third parties, due dates & reminders

Import customers and suppliers in bulk

1 min read Customers or Suppliers > More actions > Import from a file or a document
Download as PDF

Here you bring in the third-party list of another tool or a paper register.

How to

  1. In Customers or Suppliers, « More actions », then « Import from a file or a document ».
  2. Drop the file (or « Download the template » to start from the template).
  3. If a column is not recognised, set it, then « Apply and check ».
  4. Review: to create, already there, with errors. Fix a row, then « Check again ».
  5. 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

My software names its columns differently: must I rename them?

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.

A specific question?

The Comptia team is available Monday to Friday, reply within 4 business hours.

Contact support