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.
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:
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 |