Visma eAccounting Standaard
Importing or exporting chart of accounts
You can update your chart of accounts in an efficient and easy way by using the export and import functionality in Visma eAccounting Standaard. To be able to import the chart of account register to the program, the file must be created as a comma-separated CSV file. You can read more about saving data in CSV format below.
When you import a CSV file to Visma eAccounting Standaard, for the import to be successful it is important that each column has the correct header, is in the correct order, uses correct coding, and has a value in the mandatory fields. The column header represents the fields you find when you create a new account in Visma eAccounting Standaard. Please see the field explanations below for more information. An easy way to create a file with correct headings and format is to export a chart of account to use as a template for an import. Read more about how to export and import a correctly formatted CSV file below.
Add or change existing accounts
In order to update your chart of accounts register, you export a CSV (Excel) file, update the chart of accounts register and then import the register into the program again. Please note that if a value is unique (for example an account number), the value will not change in the program even if it has changed in the CSV file. If you make changes to an unique value, the program will add a new account when you import the file, and leave the original account number unchanged.
Delete ledger accounts
It is not possible to delete ledger accounts from a register by exporting and importing. Ledger accounts that are deleted from an exported file will be set as inactive when the file is imported into Visma eAccounting Standaard again. Accounts in use will always be active in Visma eAccounting Standaard.
Default value
There are fields that are not mandatory but still have a value by default. If you add rows to a CSV file but do not add values before you import the file into Visma eAccounting Standaard, the program will add the default value for you.
Create a correctly formatted CSV file
To obtain a correctly formatted CSV file that you can use, proceed as follows:
- Go to Settings - Import and export.
- Select Chart of accounts import and export.
- Select New export.
- Select what financial year to export.
- Select Export.
- Save the file as a CSV file to be able to import the file into Visma eAccounting Standaard again.
Saving data in the CSV format
For importing to the program to work problem-free, all data must be saved in the correct way in a comma-separated CSV file. In the file, information is separated with semicolons. In Microsoft, the file is called CSV comma separated or CSV comma delimited, depending on which Office package you have installed. In Mac, the same format is called Windows comma delimited (.CSV).
The format in which your exported information is created can vary slightly depending on the program, but you can format them so the information can be imported into Visma eAccounting Standaard.
Field explanations
The field explanations below provide more information about which fields must be included for the program to be able to accept an import and how these must be coded. It is important that you read through these to ensure correct coding.
Field explanations for the exported file
Certain fields in the list are mandatory. These must be included to be able to import to Visma eAccounting Standaard.
| Field name in file | Field name in Visma eAccounting Standaard | Value in the file | Comment |
|---|---|---|---|
| IsActive | Active |
False for inactive |
|
| AccountNumber | Account number | 4 figures | Mandatory |
| AccountName | Name | Letters | Mandatory |
| VatCodeAndPercent | VAT code | VAT code and percentages | Requires code |
| Type | Type | Mandatory and requires code | |
| ReferenceCode | Reference code | Requires code | |
| IsCostCenterAllowed |
Allow cost centres |
False for inactive |
|
| IsProjectAllowed | Allow projects |
False for inactive |
|
| AllowTransactionText | Use transaction texts |
False for inactive |
|
| IsBlockedForManualBooking | Do not allow manual booking |
False for inactive |
Codes for type
The following codes must be used for the program to be able to import different types.
| Type | Code in CSV file |
|---|---|
| Goodwill | 0 |
| BedrijfsgebouwenEnTerreinen | 1 |
| MachinesEnInstallaties | 2 |
| Inventaris | 3 |
| Vervoermiddelen | 4 |
| Deelnemingen | 5 |
| OverigeVorderingen | 6 |
| Ontvangst | 7 |
| Handelsvoorraad | 8 |
| Debiteuren | 9 |
| RekeningCourant | 10 |
| OverigeVorderingenEnOverlopendeActiva | 11 |
| OptiesAandelenObligaties | 12 |
| RekeningCourantBank | 13 |
| GRekening | 14 |
| Kas | 15 |
| Kruisposten | 16 |
| GeplaatstKapitaal | 17 |
| Agioreserve | 18 |
| WettelijkeReserve | 19 |
| OverigeReserve | 20 |
| Pensioenvoorziening | 21 |
| OverigeVoorzieningen | 22 |
| Leningen | 23 |
| HypothecaireLeningen | 24 |
| Financieringen | 25 |
| Crediteuren | 26 |
| BelastingenEnSocialePremies | 27 |
| OverigeSchuldenEnOverlopendePassiva | 28 |
| Omzet | 29 |
| KostprijsVanDeOmzet | 30 |
| OverigeBedrijfsopbrengsten | 31 |
| LonenEnSalarissen | 32 |
| SocialeLastenEnPensioenpremies | 33 |
| OverigePersoneelskosten | 34 |
| Afschrijvingen | 35 |
| Huisvestingskosten | 36 |
| ExploitatieEnMachinekosten | 37 |
| Verkoopkosten | 38 |
| Autokosten | 39 |
| Kantoorkosten | 40 |
| AlgemeneKosten | 41 |
| Rentebaten | 42 |
| Rentelasten | 43 |
| DividendOpbrengstVanEffecten | 44 |
| BelastingenResultaatUitGewoneBedrijfsuitoefening | 45 |
| BuitengewoneBaten | 46 |
| BuitengewoneLasten | 47 |
| KapitaalFirmant | 48 |
| OverigeWaardeveranderingenVasteActiva | 49 |
| ResultaatBoekjaar | 50 |
Codes for reference code
Learn more about reference code at Referentie GrootboekSchema's website.
VAT codes
| VAT code | Code in CSV file |
|---|---|
| Btw verkoop, hoog tarief (21%) | 1-21% |
| Btw verkoop, laag tarief (9%) | 2-9% |
| Btw inkoop, hoog tarief (21%) | 3-21% |
| Btw inkoop, laag tarief (9%) | 4-9% |
| Btw inkoop 0% | 5-0% |
| Btw inkoop, landbouwregeling (5,4%) | 6-5.4% |
| Btw verkoop, overig tarief | 7-0% |
| Btw privégebruik | 8-0% |
| Btw verkoop 0% | 9-0% |
| Btw verkoop, verlegd | A-0% |
| Btw export buiten EU | E-0% |
| Btw inkoop, laag tarief (9%), verlegd | F-9% |
| Btw inkoop, hoog tarief (21%), verlegd | G-21% |
| Btw installatie/afstandsverkopen binnen EU | H-21% |
| Btw import buiten EU, laag tarief (9%) | J-9% |
| Btw import buiten EU, hoog tarief (21%) | K-21% |
| Btw ABC-leveringen binnen EU | L-0% |
| Btw diensten binnen EU | M-0% |
| Btw leveringen binnen EU | N-0% |
| Btw import binnen EU, laag tarief (9%) | V-9% |
| Btw import binnen EU, hoog tarief (21%) | X-21% |
Related topics
|
Import or export records (CSV file) |
|
|
Importing or exporting customer records |
|
|
Importing or exporting supplier records |
|
|
Importing or exporting article records |
Searchword: Bulk update, import chart of accounts, export chart of accounts