<< Click to Display Table of Contents >> Navigation:  General > Import data > Import chart of accounts

The next fields can be allocated:

 

1. Number *

2. Description

3. Code

4. Balance code

5. Balance code negative

6. Account revaluation

7. Account consolidation

8. External number 1

9. External number 2

10. External code / Description

 

* Required

 

Only lines with status OK are processed.

 

With this import new general ledgers can be created and existing general ledgers can be changed.

When the general ledger already exists, fields are only overwritten if they are linked to import fields and if import values have been entered.

 

Number

The number of the general ledger account

If the general ledger account does not appear in the administration, it will be created.
If the general ledger account  already exists, the existing data is overwritten with those from the import.

 

Description

The new description for the account.

 

Code

A free to choose search code. If left empty, the value of the number field will be used.

 

Balance code

The balance code for a positive balance.

When the import value is 0, the field is emptied after import.

 

Balance code negative

The balance code for a negative balance.

When the import value is 0, the field is emptied after import.

 

Account revaluation

The general ledger used for the revaluation of this account.
The option Revaluate at the General ledger is automatically set to active when the Account revaluation is filled.

 

Account consolidation

The number used for this general ledger account in a consolidation. This number does not have to be an existing general ledger account.

 

External Number 1 and 2 and External code / Description

Free fields that can be used for reporting.