During the import of a chart of accounts, only one "abstract" description of the chart of accounts is accepted. During the import of account balances, balance lists with specific account balances from an operational system are accepted, so that with that data account balances of balance positions can be calculated.
Similar to the chart of account import, that functionality supports the CSV data type.
Advanced configuration
The CSV file, which shall be imported, is selected by pressing the button “choose files”. Subsequently a number of advanced settings for the CSV format can be made. To make advanced settings visible, press the "Advanced Settings" button.
The settings may be different, depending on the source system used.
- First row contains column header: specifies whether the first row of the CSV file contains column information. The data of this line are ignored during import.
- Column separator: separator for the individual properties of an account
- Decimal separator: separator for the decimal places of numeric values
- Thousands separator: separator for the thousands digits (analog million etc.) of numerical values
- Encoding: character set of the import file
- Complete account number with leading zeros: If account numbers exist with a different length, the accounts with a smaller number of digits than the maximum number of digits are left supplemented with zeros, so that after the import all account numbers have the same length.
With the details of the fields "Valuation" and "Client" it is set during data import, for which clients shall data be imported and whether it is commercial, legal or tax balances.
With the "Preview" button, the file to be imported are loaded and displayed. After displaying the preview of each column of the import file the following properties can be assigned:
- Account number
- Description
- Periods
- Position key (credit or debit key)
- Client (optional)
- Five custom information for the account (for example, account group keys, debit / property, profit and loss account etc.)
If a balance list shall be imported for one client only, then this client in the selection list "client" can be selected. If the balances Import shall be executed for multiple (any) clients, then a column of the CSV file can containing the client key. The client key must match with the client identifiers of the project configuration, so that balances of the clients can be assigned correctly.
Depending on whether one or more periods have been configured in the project, one or more columns of the import file can be assigned to these periods.
For the data import at least the properties of "account number", "client" and one period of each column must be assigned. The account number must be a clear criterion in the import file - there may be only one line for an account number.
Saving an import profil
From Version 1.11 it is possible to save the import settings as a custom profile. To save a custom profile, you first customize advanced settings and arrange the columns after the preview. Then click on the "Save Profile" button. In the next dialog, enter the name of the custom profile.
By pressing the "OK" button, the import profile is stored. If you want to set it as a default for the current project, place a hook in the "Project default" checkbox.
By defining this as a project standard, the appropriate profile is selected when you open the account balances import.
To delete a custom profile, first click on the Profile selection list. Then click the delete icon to delete the profile.
Add Comment