Opting out of the standard chart of accounts in connection with the creation of a new company
If you want to use your own chart of accounts in Uniconta when creating a new account in Uniconta, simply uncheck the
Chart of Accounts field when you select
Company/Maintenance/Create new account and choose to copy the setup from one of our standard accounts or one of your own companies already created in Uniconta.
Copy your own chart of accounts
The chart of accounts you want to use instead can be a chart of accounts exported from another financial system, or a chart of accounts you have created in Excel.
If the values in the chart of accounts contain the same values as Uniconta uses, then the chart of accounts can be copied into the chart of accounts screen in Uniconta using Copy/paste.
If the chart of accounts does not contain values like in Uniconta, see the section below that describes how you can import a chart of accounts instead.
- If so, simply open your excel file with your chart of accounts, and make sure to add a line at the top of the excel sheet, and in this line, specify the field names in Uniconta, as shown below in line 1. If you already have such a line, you can simply customize the texts to match the field names in Uniconta.
- Select the data in your worksheet, from A1 to Ex, where X is the last row you have data in, and choose Ctrl+C to copy the data
- Select General Ledge/Chart of Accounts in Uniconta
- Select the Edit All tab and the Edit All button (the button changes its name to Leave Edit All after you select it)
- Select the small icon with the two sheets in the upper right corner and select Paste from Excel
- The chart of accounts is copied into the screen and you can select the Save button to save the loaded chart of accounts.
Import of own chart of accounts
The chart of accounts you want to use instead can be a chart of accounts exported from another financial system, or a chart of accounts you have created in Excel.
The file should contain at least one account number, but should contain the following information and be in *. CSV format or Excel format:
- Account number
- Account name
- Account type
- Calculation expression/Total calculation
- Moms
Example chart of accounts exported from C5:
To get the chart of accounts into Uniconta, you need to do some Excel manipulation.
We need columns B, C, D, K and L. The rest of the columns can be deleted.
Now we have the following columns:
Column A contains Account number
Column B contains Account name
Column C contains Account type
Column D contains Calculation expression/Sum calculation
Column E contains Mom type
Columns C, D and E must be edited before you can import the chart of accounts into Uniconta.
Column C
Here, numbers should be changed to the following
| 0 |
Drift |
| 1 |
Status |
| 2 |
Headline |
| 5 |
Sum |
Possibly using a formula:
=IF(C1=0;"Operation";IF(C1=1;"Status";IF(C1=2;"Header";IF(C1=5;"Sum"))))
Column D
In C5, the calculation expression appears as the account number to be calculated from.
In Uniconta, type a calculation expression like one from account.. to one account (1005..1799)
Possibly by means of a formula
=IF(LEN(D1)>0; CONCAT(D1,".."; A1);"")
Column E
Set up column E to match Uniconta's VAT code.
After that, your *. CSV file look like this:
Import chart of accounts in Uniconta
Open Uniconta and go to
Tools / Load data.
Select the
GLAccountClient (Chart of accounts) table.
Click
Import.
Enter 1, 2, 3, 4, and 5 in the following fields and click Browse to find the *. CSV file containing the new chart of accounts.
Click
Import File.
The file is loaded and you get an overview of how your chart of accounts will look.
If the chart of accounts looks as expected, you can check if the data is in order. To do this, click the
Check button.
If the control is in order, you can either choose to
Create,
Update or
Create or Update.
The difference is that by 'Create', you create the rows that appear on the screen. 'Update' updates the rows already in Uniconta based on the existing account number. 'Create or update', creates the account numbers that do not exist and updates those that already exist in Uniconta.
Click on the function that you want for the current data.
It takes a few moments, and then you can see your chart of accounts under
General Ledger / Chart of accounts.