Visma Lön Smart
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 Lön Smart. 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.
For a successful import of a CSV file to Visma Lön Smart, it is important that each column has the correct header, is in the correct order, uses the 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 Lön Smart. Please see the field explanations below for more information about the different fields in the file. An easy way to create a file with the correct headers and format is to export a chart of accounts to use as a template for the import. Read more about how to make an export to create 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. The program will instead add a new account when you import the CSV file.
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 Lön Smart again. Accounts in use will always be active in Visma Lön Smart.
Default values
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 Lön Smart, 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 to copy date, proceed as follows:
- Go to Settings - Import and export.
- Select Chart of accounts import and export.
- Select New export.
- Select the financial year you want to export.
- Choose Export.
- Save the file as a CSV file to be able to import the file into Visma Lön Smart again.
Saving data in 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 Lön Smart.
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 Lön Smart.
| Field name in file | Field name in Visma Lön Smart | Value in the file | Comment |
|---|---|---|---|
| IsActive | Active | True for active False for inactive |
|
| AccountNumber | Account no. | 4 figures | Mandatory |
| AccountName | Namn | Letters | Mandatory |
| VatCodeAndPercent | VAT code | VAT code and percentages, e.g. 05-25% | Requires code |
| AllowTransactionText | Use transaction text | True for active False for inactive |
|
| IsBlockedForManualBooking | Do not allow manual registration | True for active False for inactive |
VAT codes
| VAT code | Code in CSV file |
|---|---|
| Output VAT 25% |
10 |
| Output VAT 12% | 11 |
| Output VAT 6% | 12 |
| Purchases of goods from another EU country 25% | 20 |
| Purchases of goods from another EU country 12% | 20 |
| Purchases of goods from another EU country 6% | 20 |
| Purchase of services from another EU country under the main rule 12% | 21 |
| Purchase of services from another EU country under the main rule 25% | 21 |
| Purchase of services from another EU country under the main rule 6% | 21 |
| Purchases of services from a country outside the EU 25% | 22 |
| Purchases of services from a country outside the EU 6% | 22 |
| Purchases of services from a country outside the EU 12% | 22 |
| Purchases of goods in Sweden 25% | 23 |
| Purchases of goods in Sweden 12% | 23 |
| Purchases of goods in Sweden 6% | 23 |
| Other purchases of services 6% | 24 |
| Other purchases of services 12% | 24 |
| Other purchases of services 25% | 24 |
| Output VAT on purchases 25% | 30 |
| Output VAT on purchases 12% | 31 |
| Output VAT on purchases 6% | 32 |
| Sales of goods to another EU country, VAT exempt | 35 |
| Sales of goods outside the EU, VAT exempt | 36 |
| Purchases of goods by an intermediary in triangulation, VAT exempt | 37 |
| Sales of goods by an intermediary in triangulation, VAT exempt | 38 |
| Sale of services to a taxable person (a business owner) in another EU country, in accordance with the principal rule | 39 |
| Other sale of services outside Sweden | 40 |
| Sales in which the purchaser is subject to VAT in Sweden | 41 |
| Other VAT exempt sales etc | 42 |
| Input VAT to deduct | 48 |
| Sales subject to 12% VAT not included in other boxes | 5 |
| Sales subject to 6% VAT not included in other boxes | 5 |
| Sales subject to 25% VAT not included in other boxes | 5 |
| Taxable value in conjunction with an import 6% | 50 |
| Taxable value in conjunction with an import 12% | 50 |
| Taxable value in conjunction with an import 25% | 50 |
| Self-supply subject to 12% VAT | 6 |
| Self-supply subject to 6% VAT | 6 |
| Self-supply subject to 25% VAT | 6 |
| Payable output VAT 25% | 60 |
| Payable output VAT 12% | 61 |
| Payable output VAT 6% | 62 |
| Taxable basis for profit margin taxation 12% | 7 |
| Taxable basis for profit margin taxation 25% | 7 |
| Taxable basis for profit margin taxation 6% | 7 |
| Rental income – voluntary tax liability | 8 |
