You can find the chart of accounts under Finance/Chart of accounts.
If you have created your accounts based on one of the standard setups in Uniconta, or if you have converted your accounts from e.g. C5 to Uniconta, your chart of accounts is already created when you select the chart of accounts screen.
If you haven't loaded/ transferred a chart of accounts, you can load a chart of accounts as described in this article: Importing {0} a Chart of accounts
Description of buttons
Below is a description of the buttons on the ribbon in the chart of accounts.
| Button | Description |
| Add GL account | Create a new financial account by selecting Add ledger account/Add, or create a new financial account as a copy of another financial account by selecting Add ledger account/Copy |
| Edit | Edits an already created financial account |
| Refresh | After changing or creating a new account, press Refresh to see the latest accounts or corrections. |
| Filter | Filter the accounts if, for example, you only want to see all accounts with account type 'Operations'. |
| Layout | Add, remove or move fields using the points under Layout. Read more about these functions here. |
| Allocations & periodisations | Set up allocations or accruals directly on the individual account here. Read more about allocations here, and accruals here. |
| Budget | View the budget transactions on the current account. Read more about budgets here. |
| Attachments | Attach notes and/or documents to the current account. Read more about this function here. |
| Account statement | View account statements for the selected account. You can also double-click on the account line to see an account statement for the account you are currently on. |
| Transactions | See all transactions on the selected account. |
| Account totals | Shows balances per month on the individual account |
| VAT by Customer/Vendor | Shows amounts per VAT code per customer and vendor on the current account (profit and loss). |
| All fields | Shows all fields on the current account and the content of these fields. |
The 'Edit all' tab
By selecting the Edit all tab, you can edit all accounts directly in the overview without having to open each individual account card, which increases speed if multiple changes need to be made.
The buttons under Edit all
| Button | Description |
| Edit all | To be able to edit in the overview and activate the subsequent buttons, you must be in editing mode. You do this by selecting the Edit all button. |
| Add GL account | Add a new financial account to the chart of accounts |
| Copy GL account | Add a new financial account as a copy of the financial account you have marked. |
| Delete GL account | Deletes the financial account you have marked |
| Save | Saves the changes you have made while the screen was in "edit-all mode". |
Example: Add GL account
To create a new financial account, select the Add ledger account/Add button, and at a minimum fill in the Account number field, and in addition fill in the other desired fields. The fields are described below in this article.
The buttons under Add GL account
Description of buttons on the ribbon under Add GL account
| Button | Description |
| Save | Save your new financial account when you have filled in the relevant fields |
| Cancel | Cancels the entry and returns to the previous screen |
| Delete | Deletes the current account. A warning will appear before the account is deleted |
| Templates | Templates (are described here.) |
| Layout | Move fields etc. via the Layout button. Read more here. |
Description of fields
Below is a description of the fields that can be seen in the chart of accounts and/or on the account card.
| Field name | Description |
| Description | |
| Account number | The account number must be filled in. The accounts are displayed in alphanumeric order, so it is an advantage to create all accounts with the same number of digits, e.g. 01010, 01011.....20100, 20101 etc. |
| Account name | The name of the account. The name field has a length of 150 characters. |
| Account type | Here you can choose between different account types. You can read more about the account types here. |
| System account | Here you can choose whether the individual account should function as a system account for e.g. exchange rate differences and similar. Read more about system accounts here. |
| Currency code | Used e.g. for bank accounts in other currencies, which can then be reconciled via bank reconciliation.The currency code selected here will automatically be suggested when posting to the account in the general journals.
The Currency code field is only shown on accounts that can be posted to, e.g. accounts with account type = 'Operations'. |
| Lookup id | Here it is possible, for example, to enter B or Bank on the bank account. When you need this bank account in the general journals, you can simply enter your lookup id in the Account or Offset account field, and the account with the entered lookup id will automatically be selected in the journal.
Note, however, that if you have, for example, entered B for bank in the Lookup id field, and in your general journal you, for example, enter a B in the Account field, and a drop-down list is shown with accounts that contain the letter B, then you must press ESC for this drop-down to tell the system that you do not want to select any of them in the list. |
| Remarks | Info can be written here - the remarks column can be inserted in the chart of accounts and is on closing sheet. |
| Account totals | |
| Total | If the account type on the account is 'Total', then in this field you can, for example, specify what should be totalled. Enter e.g. 1001..1098 to make the total account total account 1001 to account 1098. Read more about total accounts here. |
| Calculation expression | In this field, enter the calculation expression to be used to calculate the total you want to be shown on the account.
The Calculation expression field can only be seen on accounts with account type = 'Calculation expression'. Read more about calculation expressions under the description of the account type Calculation expression in this article: account-types-in-the-chart-of-accounts/ |
| Percentage | The Percentage field can only be seen on accounts with account type = 'Calculation expression'. Read more about calculation expressions and percentages here. |
| Save in | The amounts on the individual accounts can be saved with a number, e.g. 1. If you then want to make calculations on another account where the total from this and perhaps other accounts that are also saved with number 1 should be included, you can simply write Sum(1) in the Calculation expression field to retrieve the amounts from all these accounts. Note! The Calculation expression field can only be seen on accounts with account type = 'Calculation expression'. You can see an example of the use of the Save in field under the description of the account type Calculation expression in this article: account-types-in-the-chart-of-accounts/ |
| VAT | |
| VAT | Select a VAT code. Read about setting up VAT code types here. |
| Mandatory VAT |
Choose between the following options:
VAT code types and mandatory VAT have no significance for financial statement accounts. Read more about VAT codes here. |
|
|
|
| Default values |
Here you can set up the following fields to be filled in by default when entering vouchers in the general journals. Read more here: general journals. |
| Offset account type |
Select a default offset account type. |
| Offset account |
Select a default offset account. |
| Dr/cr proposal |
If Dr/cr proposal is selected, it jumps directly to the debit/credit column |
|
|
|
| Project |
These fields are only shown if the project module is activated under Company/Maintenance/configure application functionality |
| Category |
Select a category created under Project/Maintenance/Project category. Read more here. |
| Mandatory category |
Select whether a project category is mandatory during posting. |
|
|
|
| Options |
|
| Opening balance |
Enter the account number if the account total is to be transferred to an opening balance account other than the one specified as the system account. Read more about system accounts here: system accounts |
| Blocked in journal |
If this field is marked, it is not possible to post directly to the account via the general journals. |
| Blocked |
If this field is marked, it is not possible to post to the account at all. |
| New page |
If this field is marked, a new page will be created before this account when printing financial statements. |
| Hide |
If this field is marked, the account will be hidden when printing financial statements if the balance on the account is 0. |
| Consolidation account |
If it should be related to a consolidation account, the group's account number can be entered here. Consolidation account is used to compare account numbers from 2 different accounts. Example: You must do exactly the opposite if it is from company 2 that you want to print a financial statement with figures from both accounts. If the account you want to consolidate to does not exist in the company you are in, then no figures and no account will appear. |
| External number |
Can be used for a different print order in financial statements. |
| External name |
Alternative account name for use together with external number in financial statements. If, for example, you want to print your financial statement with English account names, then this field can be filled in with the account's English name, and when printing the financial statement, mark the External name field, and then the names from this field will be printed on the financial statement printout instead of the account's regular name. |
| Reconciled |
If an account is reconciled on a date, then it is not possible to post to this account on a date that is before the 'Reconciled' date. |
| Standard account | If a country has a standard chart of accounts from the authorities, e.g. Sweden or the Netherlands, then a relationship can be created here between the customer's and the authorities' chart of accounts. The Distributor in the country must have loaded the chart of accounts.
The Danish standard chart of accounts from the Business Authority has been added in all Danish accounts. |
| Dimensions used | When dimensions are set up, you can choose whether they should be 'Active', 'Not active' or 'Mandatory' on the account.
Active: When a dimension is set to 'Active' under the account, it is possible to select the dimension, and the value is shown when a transaction is posted. Not active: When a dimension is set to 'Not active' under the account, it is possible to select the dimension, but the value is not posted. Mandatory: When a dimension is set to 'Mandatory' under the account, it is not possible to post the line without setting the dimension. Read more here. |
| Dimension | Here you can select dimensions that are set up under General ledger/Maintenance/Dimensions. Read more here. |