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.

Not all data are required, so fill in only those that are useful to you. 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 the code.

VAT code

If you 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.

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.  

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-type accounts.

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.

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

Updated on October 17, 2017

Was this article helpful?

Related Articles