Import ledger accounts for a ledger set.

You can import the ledger accounts for the ledger set.

In order to import your ledger set, the import file must contain at least the following data:

• Ledger account
• Ledger description
• Account type (assets, liabilities, costs or revenues)

To import ledger accounts for a ledger set:

1. Go to: Financial / Reporting / Configuration / Ledger set.
2. Select the ledger set.
3. Click on the action: Import accounts.
4. Select the import definition.
5. In File type and File options, enter the text file type:
   • ASCII file with fixed lengths: the data in the file is aligned in columns (fixed field length).
   • ASCII file with separators: the data is separated by, for example, commas or semicolons.
   • Separator: In this field, indicate which separator is used in the import file.
   • ASCII Tab-separated: the data is separated by a Tab.
   • String character: Here, indicate which symbol is used to designate text fields; this is usually single or double quotation marks.
   • Decimal sign: For amounts, the decimal symbol can be set here; this is usually a comma or point.
   • Read from line: This is usually starting from line 1, but you may also want to import data starting from a different line. This may occur, for instance, if the field names are given in the first few lines.
   • First line contains fieldnames: Select this check box if the first line in the import file contains the field names of the columns. If you select this check box, the Read from line field is automatically changed to 2.
6. Link the ledger accounts and the corresponding descriptions in the text file to the fields in the ledger set.
7. Click on: Next.
8. Indicate whether you want to use a Visual Basic script to edit the data being imported.
9. Click on: Next.
10. Enter the description.
11. Complete the remaining fields. This specifies the options for saving the import definition.
12. Click on: Next.
13. If applicable, start the check on the validity of the import definition and the import data.
14. Click on: Finish.

    During the import, you see the progress in a progress window. Profit displays a message when the import is complete.

15. Click on: OK.