How do I import chart of accounts data?

Requirements

Make sure to comply with all requirements for the data import in metasfresh. Here you can find a format example for importing chart of accounts data.

Note: For importing chart of accounts data, you require an import format that is configured with the database table Import Account.

Steps

1. Open “Data Import” from the menu.
2. Open a suitable data import entry or add a new one.

Upload and import the file

1. Upload your import file containing the chart of accounts data.
2. Start the action “Import attachment”. An overlay window opens up.
3. In the field Attachment, select the uploaded import file.
4. Click “Start” to import the chart of accounts data and close the overlay window.

Review Chart of Accounts Data

1. Open “Import Kontenrahmen” (Import Charts of Accounts) from the menu. Here you will find all imported accounts.
2. Open the entry of the account whose data you want to review and correct, if necessary.
   • If all data were transferred properly and without errors, this account entry will be read-only and you can find the imported data under “Account Elements” in the menu in the respective chart of accounts entry. All further changes can be made there.
   • In case data were transferred incorrectly or are missing after the import, you can review and edit each account entry under “Import Kontenrahmen” (Import Charts of Accounts). After having rectified all inaccuracies, you can now manually import the accounts. To do so, please proceed as follows:

Manual Chart of Accounts Data Import

1. Start the action “Import Accounts”. An overlay window opens up.
2. Click “Start” to import the accounts and close the overlay window.
3. You will find the imported accounts under “Business Partner” in the menu in the respective chart of accounts entry.