---
title: "Import of accounting entries from an excel file"
canonical: "https://wiki.soft1.eu/space/SS5EN/12060511/Import%20of%20accounting%20entries%20from%20an%20excel%20file"
format: markdown
---
**Comments - Clarifications **

Before running import job, you must activate option <Convert updated items> in the General Accounting Parameters, so that to be able to import finalized general ledger entries.

The following instructions refer only to the import of items from an excel file having the specific lines layout

In order to import massively accounting entries through import from an excel file, use the following procedure:

1. Create an excel file with the following lines layout:


   2. For each entry complete data as follows:

 

|  |  |
| --- | --- |
| ACNEDIT | Unique Registration Number- enter the same unique number in all lines related to the same item entry (it is the criterion for the separation of item entries) |
| SERIES | Series |
| FINCODE | Document number |
| TRNDATE | Entry date |
| SOCURRENCY | Entry currency |
| ACNJRNLNUM | Journal number (if entry does not have a journal number, enter <0> ) |
| COMMENTS | Entry comments |
| CODE | Account code |
| DEBIT | Debit amount |
| CREDIT | Credit amount |

 

The above fields are the minimum data to be completed so as to import correct accounting entries in the system.

 

   3. In folder menu select job General ledger > Entries

   4. In system menu select Tools >import general ledger entries > run >import general ledger entries.

   5. On the screen displayed, deactivate options <Modify existing> and <Check existence in tables>

   6. Define the path at the end of which the excel file is saved and then select <Run> to run the process.