Back

Import Journal Entries from an Excel File

 

You can import journal entries from a ready Excel or CSV file, such as entries prepared by an external accountant or data moved from another accounting system. This guide explains how to prepare the file, the import steps, field mapping, how the system groups lines into entries, and the error messages and how to fix them.

🛈

Note: You need the Accounting app enabled and one of the journal permissions (all journals, own journals, or draft journals). Set them from Manage Employee Roles.

Prepare the journal entries file

Each line in the file is a transaction (a debit or credit side), and the lines that share the same entry code make up one journal entry. You can download the sample file from the import page (Download Sample) and build on it.

Column in the sample file Description Required
Journal Code A number or code that groups the lines of one entry (such as JRN001). Yes
Journal Date The entry date (such as 29/10/2024). Yes
Currency The currency code (such as SAR or USD). If left empty, the account currency is used. No
Journal Description A description of the whole entry. No
Account Name The code or name of the sub-account as it appears in the chart of accounts. Yes
Transaction Description A description for the line. No
Tags One or more tags separated by commas (when tags are enabled for journals). No
Cost Center The cost center code or name (when cost centers are enabled for journals). No
Tax The tax name as set in tax settings (when taxes are enabled for journals). No
Debit / Credit The line amount on one side (a positive number). One of them

Example of a two-line entry:

Journal Code Journal Date Account Name Debit Credit
JRN001 01/03/2025 Main Treasury 1000
JRN001 01/03/2025 Other Revenue 1000

🛈

Important: Total debit must equal total credit for each entry code. Check this in the sample file itself before using it, as some of its entries are for illustration only.

Import steps

Step 1: Import Options

  1. From the main menu, open Accounting, then Journal Entries.
  2. Click the Import button.
  3. In CSV / Excel File, choose the file (CSV, XLS, or XLSX).
  4. In Delimiters (for CSV files only), choose the separator used in the file: Comma Separated ( , ), Semicolon Separated ( ; ), or Tab Delimited.
  5. Enable Import First Row only if the file has no header row.
  6. Choose the Journal Status: Issued (affects balances immediately) or Draft (to review, then issue).
  7. Enable Auto-generate Journal Numbers if you want the system to number the entries in its own sequence instead of using the codes in the file.
  8. Click Next Step.

🛈

Note: The Draft option appears for users with the draft journals permission, and Issued for users with the journal management permission.

Step 2: Fields Mapping

  1. Next to each field under System Field, choose the matching column under Corresponding Field in File. The system automatically matches the columns whose header matches the field name in Arabic or English.
  2. Enable Ignore errors while importing if you want to import the valid entries and skip the ones with errors.
  3. Click Import.

🛈

Tip: Review the mapping of every field before clicking Import, especially Debit (Transaction Currency) and Credit, and correct any field that was matched to the wrong column.

Field mapping

  • Account: matched by account code or name. It must be a sub-account; main accounts aren’t accepted in journal entries.
  • Cost center: matched by code or name.
  • Tax: matched by name.
  • Currency: the currency code; the exchange rate is calculated automatically (there’s no exchange rate column).
  • The branch (the current branch is used), attachments, and custom fields can’t be imported.

🛈

Tip: To avoid mapping errors, use the account codes from the Chart of Accounts instead of the names.

How are lines grouped into entries?

  • All rows with the same Journal Code make up one entry, and each row is a transaction in it.
  • The entry date, currency, and entry description must be identical in all lines of the same code.
  • The Journal Code is required for grouping, even when Auto-generate Journal Numbers is enabled.
  • A line with no debit or credit amount is ignored.

Track the import and its results

  • After you click Import, the Importing Journals page opens, and each entry is processed separately in the background.
  • The page shows the number of Successful and Failed entries. Each successful entry has a link to the created entry, and each failed entry shows the error reason and row number, such as Error Adding Journal #JRN001: ….
  • When the import finishes, the message Importing was completed successfully appears, even if some entries failed, so check the Failed count. If the import stops, a button appears so you can resume it.
  • Each entry is accepted or rejected as a whole, and a failed entry doesn’t affect the other entries.
  • Imported entries appear in Journal Entries as manual entries, and the Activity Log of each entry shows that it was imported, not added manually.

Error messages and solutions

Message Cause Solution
Invalid Data, Missing required field or does not exist Account Name at row #… A required field (Journal Code, Journal Date, or Account) is empty in the mentioned row. Complete the field in the mentioned row.
Invalid Data, Wrong Relation Account Name at row #… The account in the mentioned row doesn’t exist in the chart of accounts. Use the code or name of an existing sub-account.
The Journal Date should be the same for all journal items that have the same journal code, at row #… The date (or the currency or description) differs between rows of the same Journal Code. Use the same value in all rows of the code.
Invalid Data, Data must be in the correct date format in ‘Journal Date’ field at row #… The date format is incorrect. Use a valid date format, such as 01/03/2025.
Invalid Data, The selected currency code is not available. at row #… The currency code doesn’t exist in the system. Correct the currency code.
The Journal could not be saved. The total debit must be equal to the total credit The entry is unbalanced. Review the debit and credit amounts of the entry.
You can’t add an empty journal All rows of the entry have no debit or credit amounts. Review the entry rows.
A message that the transaction date is within a closed period. The entry date falls within a closed period. Change the date, or open the period temporarily.
Sorry, it is not allowed to import one column file, make sure you have selected a file with the correct format The selected delimiter doesn’t match the file. Choose the correct delimiter (usually comma or semicolon).
CSV columns count is not the same through all file rows Some rows have extra or missing columns. Review the file (for example, a comma inside a description).
The uploaded file could not be processed. Please ensure it is a valid XLS, XLSX, or CSV file and try again. The file is damaged or in an unsupported format. Save the file as CSV or XLSX and try again.

🛈

Note: The last three messages appear when you click Next Step, before the import starts. If Ignore errors while importing isn’t enabled, the import stops at the first data validation error and no entries are imported, so correct the file and upload it again.

Limits and notes

  • The maximum is 10,000 lines per file and 500 transactions per entry.
  • Entries are added to the current branch.
  • Entries imported as drafts don’t affect balances until they’re issued, and you can issue them from the journal entries list.
  • To delete entries imported by mistake, select them in the journal entries list and choose Delete from the bulk actions (based on your permissions).

FAQs

How do I know the lines will be grouped into one entry?

Use the same Journal Code in all its rows, with the same date, currency, and description.

Why is the entry unbalanced even though the amounts look equal?

Check that each amount is in the correct Debit or Credit column, that the Debit and Credit fields are mapped to the right columns, and that all rows of the entry use the same Journal Code.

Can I import entries as drafts to review them?

Yes. Choose Draft in the Journal Status, then issue the entries after reviewing them.

Are the entry numbers in the file kept?

Yes, unless you enable Auto-generate Journal Numbers.

How do I identify imported entries?

From the Activity Log of each entry, which shows that it was imported.