General > Import data > Import balance code tables

The following fields can be allocated:

1.Table no. *

2.Code *

3.Description *

4.Type (H, S, B) *

5.From Acc. positive

6.Until Acc. positive

7.From Acc. negative

8.Until Acc. negative

9.Level

10.Lux debit/this year

11.Lux credit/ prev year

12.XBRL Label 2022 Coc NL

13.XBRL Label 2023 CoC NL

14.Sequence number

* Required

With this import function new balance code tables can be created
At existing tables new codes can be added.

Only lines with status OK are processed.

See also the help topic Maintenance > Balance codes.

Table no.

Enter the number of the balance code table in which you would like to import. If this is an existing table, the imported data will be added to the current data in the table.

If the table does not exist, it will be created.

Note: If the table already exists, there is a risk of an overlap within the ranges of general ledger accounts

Tables can be created and maintained via Maintenance > Financial > Balance codes.

Type (H, S, B)

Define each entry as a header (H), a subheader (S) or a balance code (B).

Only Balance codes can be linked to a range of general ledger accounts.

General ledger ranges entered at Type H and S will be ignored.

Level

This field allows for subheaders to be subdivided in a treelike manner (parent-child relations). Enter the level numbers (1-9).

XBRL Label 2022 CoC NL - XBRL Label 2023 CoC NL

Only the entry fields for the current and previous bookyear of the bookkeeping are available for import.
The XBRL labels are not checked for valid codes.

Sequence number

The sequence number is used to determine the presentation order of items in the table.

When the field is not linked the line numbers of the import file will be used for the sequence numbers.
If the field is linked, it must be filled.

When adding new lines to a table enter the sequence number in the import file.