1. Home
  2. All You Can Do with Reviso
  3. Importing Data
  4. How Can I Import the Chart of Accounts?

How Can I Import the Chart of Accounts?

Reviso provides you with the chart of accounts by default. You can also import your own chart of accounts. This article will provide you with information on how to import your own chart of accounts.

How to import chart of accounts to Reviso

When importing your own chart of accounts, you must prepare your list of accounts with a specific format in an Excel file.

You can download a template providing you with the necessary format. Go to Settings > All Settings > Finance > Chart of accounts and click on Other options > Import chart of accounts

import chart of accounts

A window requesting you to upload your chart of accounts will show up, but you can click on Click here for a preview of how to lay out the file to access the template.

access template of chart of accounts

The template provides you with information necessary for creating a chart of accounts. It may serve as a template for your chart of accounts, where you just edit the numbers you need for your own business. 

Once your file with information for the chart of accounts is ready, save the Excel file in CSV format and upload it to Reviso by clicking on Choose File. Once the file is uploaded, click on OK and the data will be imported. Once the process is finished, you will be presented with a summary of data that were imported. 

Once the process is finished, you will be presented with a summary of the data that has been imported.

Now you can see the chart of accounts and all the data you have imported.

Importing Data

The file you want to import must have the same structure as the sample file, which you can download as indicated above.

All data is required, so please take care to complete all of the columns. Read more information about all the data below:

Account Number

This column includes account numbers that you want to use in your accounting system. In Reviso you shall use a minimum of 4 and maximum of 9 digits.

Name

Name that you want to give to our accounts. This data can be edited later if necessary.

Account type

You must define whether it is a balance sheet (accounts of groups 1 to 5), or profit and loss (group 6).

When the account type is a balance sheet, you will enter the number “2”. In the case of a profit and loss, you will put the number “1”. This applies to all the accounts with 4 or more digits.

Total From

This column adds from one code down to the line of your total. For example, if you want the total to run from the beginning enter the first code on your list.

VAT code

If you’ve already created your VAT codes in Reviso, you could link them to your income and expense accounts by entering the name of the VAT code as registered in Reviso.

Debit / Credit

You can define the nature of the account. When you select the code when processing a supplier invoice or journal the vat code you have linked to this code will appear however, you can change this should you wish to. 

Contra account

If you often need for your entries a contra account, you can define a column as a contra account, which will save you a lot of time later on. An example of this would be if you were creating a journal for depreciation and selected the main depreciation account in the balance sheet the corresponding account code in the profit & loss would appear as your contra account.  

Transfer opening to

When you close your accounting year and want the balance to be transferred as an opening balance to a different account, you can define the account of your preference.

This field is only valid for balance sheet entries so the the account Type would be Balance sheet.

Departments

If you have activated the department/dimension module and created your list of departments, you can link your accounts to those departments.

For example, whenever you use an account for suppliers (2100), that expense is associated with that department.

Key Figure Code

The list of key figure code is explained in this article. This field is not required, but in order to access the key figure report, you will have to fill in the column with a corresponding number depending on the type of account.

Please see this article if you are interested in the key figure report.

Code 1 and Code 2

Codes 1 & 2 are no longer used but still present in the file

Mandatory Department

In case you want all your accounts to require an associated department.

Account Categories

These give you the ability to create additional reports. You can allocate account categories to all nominal codes within your chart of accounts and and then run consolidated reports based on these. An account category needs to be present for all codes. Below is the list of Account Categories, the ID number need to be entered in the import file Account Category column relating to the code and description…..for example, code 1200 bank account would have the ID 9 ‘Bank and cash balances’ entered….

ID Account category Type
Assets
Fixed assets
3 Intangible fixed assets Balance sheet
4 Tangible assets Balance sheet
5 Financial assets Balance sheet
61 Depreciation Balance sheet
Inventories
10 Raw materials Balance sheet
11 Work in process Balance sheet
12 Finished goods and merchandise Balance sheet
62 Stock Balance sheet
Receivables
13 Trade debtors Balance sheet
14 Receivables from subsidiaries Balance sheet
15 Other receivables Balance sheet
16 Prepayments Balance sheet
8 Securities Balance sheet
9 Bank and cash balances Balance sheet
Liabilities
Equity
19 Capital Balance sheet
20 Reserves Balance sheet
60 Private contribution / drawing Balance sheet
21 Retained earnings Balance sheet
22 Provisions Balance sheet
70 Financial liabilities Balance sheet
Long-term liabilities
24 Mortgage debt Balance sheet
25 Bank loans Balance sheet
26 Leasing obligation Balance sheet
Short-term liabilities
28 Current portion of long-term debt Balance sheet
69 Bank debts Balance sheet
29 Trade creditors Balance sheet
30 Payables to subsidiaries Balance sheet
31 Corporation tax Balance sheet
32 VAT Balance sheet
33 Staff related debt Balance sheet
34 Other debts Balance sheet
63 Accruals Balance sheet
Profit and loss
Turnover
48 Sales of products Profit and loss
49 Sales of services Profit and loss
Cost of sales
46 Costs for raw materials and consumables Profit and loss
47 Direct labour costs Profit and loss
64 Change in inventories and work in progress Profit and loss
Capacity costs
52 Sales promotion and advertising Profit and loss
50 Cost of office and workshop space Profit and loss
51 Administration costs Profit and loss
59 Costs of operating funds Profit and loss
65 Utilities Profit and loss
66 Vehicle expenses Profit and loss
67 Travel and entertainment Profit and loss
68 Professional fees Profit and loss
Staff costs
53 Wages and salaries Profit and loss
54 Pension Profit and loss
55 Social security costs Profit and loss
56 Other staff costs Profit and loss
Depreciation
57 Intangible fixed assets Profit and loss
58 Tangible assets Profit and loss
41 Secondary income Profit and loss
42 Secondary costs Profit and loss
43 Financial income Profit and loss
44 Financial expenses Profit and loss
45 Tax Profit and loss

Contact us if you have any questions further questions. We will be happy to help you.

Updated on April 9, 2019

Was this article helpful?

Related Articles