Skip to main content
Try for free

How To Batch Import Journal Entries

Use Import Ledger Entries to post many journal entries to the general ledger from one spreadsheet.

Updated Nov 9 2026

How To Batch Import Journal Entries

Allow external media cookies to watch this video.

Before you start

  • Import is under Accounting > Chart/Ledger and needs the Accounting role (or Accounting Admin or Admin). Without it Cetec sends you to the home page with "No Accounting Access For This Login - Please Ask The Administrator To Add The 'Accounting' Role To Your Profile".
  • The file must be .csv, .txt or .xlsx, with the column names in the first row. Password-protected files are not supported.
  • The GL account numbers in the file must belong to active accounts, and cost centers must be active cost centers, matched by name.
  1. Prepare the file

    Each row is one split: one account and either a debit or a credit. Give each row the columns you need:

    ColumnWhat to put in it
    External IdRequired. The same value on every split of one entry, and a value no earlier ledger entry has used.
    NameRequired. The entry name, the same on every split of the entry.
    DateRequired. The entry date, for example 2023-11-16 (YYYY-MM-DD), the same on every split.
    Account NumberRequired. The GL account number for this split.
    Debit Amount / Credit AmountThe split's amount, as a positive number, in one of the two columns only.
    Description, Location, Cost Center, Notes, Currency, Tags, External SourceOptional. Location matches a location code or name; Cost Center matches the name; Currency matches the currency code; Tags are comma-separated.
    • Each entry needs at least two splits, and its debits and credits must be equal (also within each cost center).
    • A simple way to keep External Ids unique is to build them from the date: the first entry on 16 November 2023 is 2023-11-16-01, the next 2023-11-16-02, and so on.
  2. Upload the file

    1. Go to Accounting > Chart/Ledger > Import. The screen is headed Import Ledger.
    2. Click Use New Version under the heading. The screen is headed Import Ledger Entries.
    3. If your company posts from other ledgers, pick the External Source under Import Options. The box only appears when an external source is set up.
    4. Click Choose File and pick your file. For a .csv file a CSV Delimiter box appears; leave it empty for commas. Click Import File.
    5. Leave Update Related Data under Import Options unticked; it changes entries that are already on the ledger.

    The Available Import Columns panel lists the columns under Required Columns, Suggested Columns and Optional Columns, and Download Template gives you a blank file.

  3. Map the columns and validate

    1. In Import Preview, each column has a dropdown above it that starts at (identify column), even when your column names match. Choose what each column holds (External Id, Name, Date, Account Number, Debit Amount, Credit Amount, and so on).
    2. In the Use? column, untick any row you don't want imported. The first row (your column names) starts unticked.
    3. Scroll down and click Validate. Cetec checks every ticked row and shows Validation completed successfully. or lists the problems under Validation/Import Results (Message, Column, Row, Data), for example:
      • external_id "…" does not balance: debits …, credits … – the entry's debits and credits differ. A second line, … cost center "blank cost center" does not balance …, follows when the file has no cost centers.
      • debit_amount or credit_amount is required or only one of debit_amount or credit_amount may be provided – fix that row's amounts.
      • name is required or date must be a valid date. Fix the file, click Start Over, and upload it again.
  4. Post the entries

    1. On Import Ledger Entries, after a clean Validate, click Import (it stays greyed out until Validate passes).
    2. Cetec posts one ledger entry per External Id, shows Import completed successfully., and the button reads Imported. Validation/Import Results shows Rows imported: n. Rows updated: n. Existing rows but not updated: n (counted in rows, so two two-split entries are Rows imported: 4) and Post-import row count is correct.; Download Import Summary gives you the results as a file. The entries are on the general ledger straight away.
    3. A row whose External Id is already on the ledger is not imported again; it is counted under Existing rows but not updated. Give a new entry a new External Id.