Error when importing accounting data from CSV files into eGECKO

Problem:
When importing accounting data from a CSV file, an error message appears that the format is not recognized.

Cause:
This problem often occurs when the CSV format does not exactly meet eGECKO's requirements, such as incorrect separators, missing mandatory fields, or incompatible character encoding.

solution:

1. Check CSV format:

   • Make sure that the separator in the file matches the separator set in eGECKO (e.g. semicolon or comma).
   • Check that all mandatory fields (e.g. posting date, account, amount) are available and correctly formatted.
   • Use UTF-8 as a character encoding to correctly represent special characters.

2. Use a sample file:
   Use the sample template provided by eGECKO for the CSV import to avoid format discrepancies.

3. Check import settings:

   • Open the import dialog in eGECKO and check the settings for separator, decimal point and text qualifier.
   • If necessary, adapt it to the CSV file.

4. Perform a test import: First,
   try importing a small test file with a few bookings to identify errors more quickly.

More help:
If you're still having problems, please send a sample CSV file to our support team for detailed analysis.