Import accounting entries

Import accounting entries

Cheel allows you to import accounting entries from an Excel (.xlsx) or CSV (.csv) file, as part of a migration or integration from a third-party tool.
To prepare your file, see Journal Entry Import File Structure . To understand the import rules and limitations, see Journal Entry Import Rules and Behaviors .

Access the import function

Two methods are available from the list of Scriptures :

  1. Via the "…" button
    1. In the list of Scriptures , click the … button.
    2. Click on Import entries :


  2. Via drag and drop
    1. Drag your .csv or .xlsx file directly from Windows Explorer onto the Write list.
    2. The import window opens with the file pre-loaded.

Import steps

In the Accounting Entries Import window:
  1. Select the file to import (.csv or .xlsx) using the … button.
    If the file is in Excel format (.xlsx), the data to be imported must be located in the first sheet of the file. The other sheets are not taken into account.
  2. Check the information detected after the file has been loaded:
    1. the recognized format,
    2. the number of entries to import.

Example: "Format: Application (Accounting Entries) — xx entry(ies) to import":

If the file is in .csv format, check the Encoding field. The Automatic value is suitable in most cases. If accented characters are displayed incorrectly in the next step, manually select UTF-8 or Windows-1252.
  1. Check "First line is a header" if the file contains a heading line that should not be imported.
  2. Click Next .
  3. Check the preview of detected entries in the file:



  4. Click Next to start the import.
  5. A summary is displayed at the end of the process:
    1. Number of imported entries.
    2. Number of anomalies (rejected lines).
    3. Number of accounts created automatically.
The anomalies can be viewed in the detailed grid:



Delete an import

The imported entries are grouped into a batch . To cancel an import:
  1. Select an entry from the relevant batch.
  2. Delete the batch:
    1. Right-click and then Delete batch
    2. or click the … button and then Delete Batch .
  3. The deletion is permanent and removes all entries from the batch.