Importing a Chart of Accounts

During the Tenant setup phase a chart of accounts is loaded. This can be changed by loading another chart of accounts, including analytic accounts. Accounts can be added using the Import File Loader and Import Account functionalities.

Import File Loader

To import a file you need to open the Import File Loader window, located in the System Admin -> Data -> Data Import menu:

• File - select the file containing the chart of accounts. You can navigate to any folder available on the workstation. The file format is CSV;

• Import Format - select from the list "Accounting - Accounts";

• Sample - after the file and the import format are selected, the Sample field will display the data to be imported and additional details.

• Process - used to start loading the records. When this process is complete, a notification is displayed with the number of rows loaded. The next step is to import the loaded accounts.

To import the previously loaded accounts, open the Import Account window, located in the System Admin>Data> Data Import menu.

Import Account

The Import Account window, located in the System Admin>Data> Data Import menu, is used to review the records loaded via Import File Loader and amend them as necessary.

Click the Import Accounts button to start the import process:

• Element - select the chart of accounts to be loaded or updated;

• Update default account - select this option if you wish to update the chart of accounts that was loaded initially. Warning: this option will update all accounts and will affect all subsequent journal entries.

• Create new combination - this is selected only for the first chart of accounts loaded, in order to automatically create the accounting combinations indicated in the accounting schema;

• Only Validate Data - when selected, the chart of accounts will not be loaded. The process will only check if the chart of account is valid and ready to be loaded;

• Import only if No Errors - if selected, when a single record is not valid the chart of account will not be loaded;

• Delete old imported record - select this option if you have previously imported accounts and you wish to delete them

Click Start to import the accounts. In the Log section, the import process will display details about the number of errors, updates, record inserts and record deletes.

To view the chart of accounts that resulted from the import, open the Account Element located in the Performance Analysis -> Accounting Rules menu. You can use this window to view and navigate the chart of accounts. Details in Accounting.