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.
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.
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.
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:
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 that you want to give to our accounts. This data can be edited later if necessary.
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.
This column adds the 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.
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.
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
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.