To import your products, a template is required. You can import new charts of accounts or update existing ones. The actual importing of charts of accounts usually takes only few seconds.
Overview
How does importing work?
There are two different ways to import your chart of accounts, depending on whether the Accounting Setup Wizard has already been completed or not. Below is a video guide in Swiss German!
1. The Accounting wizard
If you are a new customer, you can start the wizard under «Accounting» / «Set up accounting».
If you have already dismissed it or you can no longer see it, you can find it under «Accounting» → «Financial Statements» → «Transferring Balance Sheet and Income Statement».
In step three of eight, you can define your chart of accounts.
At the bottom you will see the expert function. To the right of it, you can import your Excel template.
2. Financial accounting chart of accounts
If the Accounting Setup Wizard has already been completed, the Chart of Accounts can also be edited in the Preferences. Under the path "Settings" → "All Settings" → "Accounting" → "Chart of Accounts Financial Accounting", you will see two icons in the upper right corner. Use the right button to download the current chart of accounts as Excel. With the left button you can import the chart of accounts.
After clicking on the "Import Button" the following warning message appears - Please pay attention to it.
Video instructions in Swiss German
Structure of the Excel
The Excel spreadsheet is structured in seven columns.
- Account number
- Account name
- Account group
- Account type
- System account
- Linked account
- VAT type
Account number |
With the account number, you determine the number to be assigned to the account. |
Account name |
With the account names, you can define the names of your accounts. |
Account Group |
Here you can link the account groups. Here it is important that there is a logical structure, i.e. the linked account group must also exist. |
Account type |
The account type determines the group of the balance sheet and income statement. For example, account 2000 has the asset account type. The asset account with the account number 2 has the account type Group because it is linked to an account group. |
System Account |
System accounts must not be modified, or the import will not work. |
Linked account |
Linked accounts are only for bank accounts; the linked accounts are not imported. |
VAT type |
The VAT rate is entered here. It is recommended that you enter the records after the import is done, as this is controlled by commands. |
The mandatory fields
The mandatory fields are:
- Account number
- Account name
- Account group
- Account type
System accounts must not be modified, or the import will not work. However, for example, the name of system account as well as the number can be adjusted. For system account groups (e.g. 1 Assets, modifying the number has no effect)
Linked accounts are only for bank accounts, the linked accounts are not imported.
Which accounts can be imported?
All accounts, so long as they meet the validation criteria.
The validation criteria used in the user interface and during import must be identical (e.g. max. x characters for the name, etc.).
Accounts that cannot be imported
Incorrect references (e.g. group not present). Incorrectly named system accounts. If system accounts and system account groups do not exist.
Importing errors
Usually when validation rules are violated. Sometimes the errors are difficult to understand, sometimes trivial. So please perform the import only if you are sure.