Import a chart of accounts

The import lets you bring over the chart of accounts provided by your accountant in minutes, or update part of it. It is based on a file template you fill in, then checks every line before importing anything.

1. 1

   Download the template

   Get an Excel workbook pre-filled with the right columns, examples and an instructions sheet, in French or English.

2. 2

   Upload and preview

   Drop your file: every line is analyzed and you see the planned action (create, update, error), without any data being written yet.

3. 3

   Confirm

   Confirm: valid lines are imported, lines in error are skipped. A summary shows how many accounts were created, updated and skipped.

• Number (required)

  The account number. Enter it as text to keep leading zeros.

• Label (required)

  The account's name.

• Description

  A free, optional description.

• Bank account

  The IBAN (recommended) or the exact label of an existing treasury account, to attach the account. Optional.

• Currency

  A 3-letter ISO code. Leave empty for all currencies. Optional.

• Deduplication by number: an existing number updates the matching account; a new number creates one.
• Two modes: “create and update” (default) or “create only”, which skips updates.
• Bank matching: the treasury account is found by IBAN first, otherwise by exact label. A reference that is missing or ambiguous puts the line in error.
• Lines in error: a missing required field, a too-long value, an invalid currency or a duplicate number within the file are flagged and the line is skipped.