Import your own Chart of Accounts into Uniconta
To import your own chart of Accounts into Uniconta:
Go to Company/Create a new company in the navigation panel.
A detail form will appear, as shown in the screenshot below. When setting up a company/set of accounts choose a ‘Standard’ Chart of Accounts but remove the check mark in the ‘Chart of Accounts’ field, as shown below.
Own Chart of Accounts
Charts of Accounts can be exported from C5, e-conomic and other business management systems.
The file should contain at least one account number and the Chart of Accounts should include the following fields:
- Account number
- Account name
- Account type
- Calculation expression/Summing
- VAT type (country specific)
Export a Chart of Accounts from C5 and save it as a Comma Separated Variable (*.CSV) file, not an .XLS or .XLSX file.
Here is an example of what a company Chart of Accounts will look like:
Some Excel-manipulation needs to be done in order to get the Chart of Accounts into Uniconta.
Columns B, C, D, K and L will be used. The remaining columns can be deleted.
We are left with the following columns:
Column A contains the Account number
Column B contains the Account name
Column C contains the Account type
Column D contains the calculation expressions/totals
Column E contains the VAT type
Columns C, D and E need to be edited before the Chart of Accounts can be imported into Uniconta.
Column C
The numbers in this column need to be changed to the following:
| 0 | Income Statement |
| 1 | Balance Sheet |
| 2 | Heading |
| 5 | Total |
This can be done using a formula such as:
=IF(C1=0;”Income Statement”;IF(C1=1;”Balance Sheet”;IF(C1=2;”Heading”;IF(C1=5;”Total”))))
Column D
In C5 a calculation expression is marked as the account number that is to be calculated from.
In Uniconta a calculation expression is written from an account.. to an account (1005..1799)
These changes can be made using a formula such as:
=IF(LEN(D1)>0;CONCAT(D1;”..”;A1);””)
Column E
Set up column E, so that it matches Uniconta’s VAT codes (country specific).
Now your *.CSV file should look like this:
Import Chart of Accounts into Uniconta
The Chart of Accounts is now ready to be imported.
Open Uniconta and go to Tools/ Import data in the navigation panel.
Select the GLAccountClient (Chart of Accounts) table.
Click on ‘Import’ in the toolbar/ribbon.
Type in 1, 2, 3, 4 and 5 into the required fields and click on ‘Browse’ to find the *.CSV file containing the new Chart of Accounts.
Click on ‘Load file’ button in the toolbar/ribbon.
The file is loaded and a preview of the Chart of Accounts appears.
If the Chart of Accounts meets expectations, the data can be checked by clicking on ‘Check Update’ in the toolbar/ribbon as shown in the screenshot above.
If the check is successful, then the next step is to either click on ‘Create’, ‘Update’ or ‘Create or update’ in the toolbar/ribbon.
‘Create’, creates the rows as they appear on the screen. ‘Update’, updates the rows that already exist in Uniconta, based on the existing account numbers. ‘Create or update’, creates the account numbers that do not exist yet and updates those that already exist in Uniconta.
Choose which function best suits. After a few moments, the Chart of Accounts will be available under General Ledger/Chart of Accounts
VAT codes should be set up next (this is country specific).
This can be done under General Ledger/Maintenance/VAT. For more information view https://www.uniconta.com/da/unipedia/koeb-og-salg-uden-momsberegning/
(links coming soon in English)