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.
All data is required, so please take care to complete all of the columns. 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 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.
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.
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.
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.
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….
|3||Intangible fixed assets||Balance sheet|
|4||Tangible assets||Balance sheet|
|5||Financial assets||Balance sheet|
|10||Raw materials||Balance sheet|
|11||Work in process||Balance sheet|
|12||Finished goods and merchandise||Balance sheet|
|13||Trade debtors||Balance sheet|
|14||Receivables from subsidiaries||Balance sheet|
|15||Other receivables||Balance sheet|
|9||Bank and cash balances||Balance sheet|
|60||Private contribution / drawing||Balance sheet|
|21||Retained earnings||Balance sheet|
|70||Financial liabilities||Balance sheet|
|24||Mortgage debt||Balance sheet|
|25||Bank loans||Balance sheet|
|26||Leasing obligation||Balance sheet|
|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|
|33||Staff related debt||Balance sheet|
|34||Other debts||Balance sheet|
|Profit and loss|
|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|
|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|
|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|
|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.