Visma eEkonomi Smart
Importing or exporting article records
You can update your article record in an efficient and easy way by using the export and import functionality in Visma eEkonomi Smart. To be able to import the article record 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 eEkonomi Smart, 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 eEkonomi Smart. Please see the field explanations below for more information. An easy way to create a file with correct headings and format is to export an article record to use as a template for an import. Read more about how to export and import a correctly formatted CSV file below.
If you want to see how to do it inside the program, click on Guida mig in the program's menu bar and select the guide Import av artikelgregister.
Add or change existing articles
In order to update your article record, you export a CSV (Excel) file, update the article record and then import the record into the program again. Please note that if a value is unique (for example an article number), the value will not change in the program even if it has changed in the CSV file. If you make changes to a unique value, the program will add a new article when you import the file, and leave the original article unchanged.
Delete articles
It is not possible to delete articles from a record by exporting and importing. Rows that are deleted from an exported file and that later is imported into Visma eEkonomi Smart again will still be shown in Visma eEkonomi Smart. If you want to delete an article you do this in Visma eEkonomi Smart.
Default value
There are fields that are not mandatory but still have a value by default, for example Unit. If you add rows to a CSV file but do not add values before you import the file into Visma eEkonomi Smart, the program will add the default value for you.
UsesOss and HouseWorkType
These columns are only shown in the CSV file if the boxes Apply rules for One Stop Shop (OSS) and Housework to private individuals, ROT/RUT rules apply is activated in Company Settings. If you want to import a file with these columns included, make sure you have activated the use of the functions in Visma eEkonomi Smart before you import the file.
Create a correctly formatted CSV file
To obtain a correctly formatted CSV file that you can use, proceed as follows:
- Create a new article in Visma eEkonomi Smart. Read more about this in the topic Create article.
- Choose to export the article record. Read more about this in the topic Import or export records (CSV file).
A comma-separated CSV file with the exported article is then created.
- Delete the article in the program. Read more about this in the topic Remove article.
The file can now be used for importing records.
- When you create the file, you give it a name and decide where it should be saved on your computer.
- You can now start pasting in the article information that you want to import to Visma eEkonomi Smart into the different fields of the CSV file.
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 eEkonomi Smart.
CSV imports and exports when using the stock extension
Making a CSV export of your article register is an efficient way to update the Purchase price and Freight costs for the articles. When you import the file again the purchase price and freight cost will be updated on the individual articles.
Please note that you cannot make changes to the Stock balance by importing a CSV file.
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 eEkonomi Smart.
| Field name in file | Field name in Visma eEkonomi Smart | Value in the file | Comment |
|---|---|---|---|
| IsActive | Is active or not | True for active False for inactive |
|
| SendToWebshop |
Is active or not |
True for active False for inactive |
|
| Number | Article no | Mandatory and unique | |
| Name | Article name | Mandatory | |
| Name English | Article name in English | ||
| Notes | Notes | ||
| Barcode | Barcode | Is included in the file only when the stock extension is activated | |
| StockReference | Stock reference | Is included in the file only when the stock extension is activated | |
| ArticleAccountCoding | Sales VAT and ledger settings |
Requires code |
|
| Unit | Unit | Requires code | |
| NetPrice | Sales price excl. VAT | ||
| PurchasePrice | Purchase price, excl. VAT | ||
| FreightCosts | Freight cost excl. VAT | Is included in the file only when the stock extension is activated | |
| HouseworkType | ROT/RUT rules applies -only shown if activated | Requires code | |
| UsesOss | Oss rules applies - only shown if activated | ||
| StockArticle | Stock article | True for active False for inactive |
Is included in the file only when the stock extension is activated |
| StockBalance | Stock balance |
|
Codes for units
The following codes must be used for the program to be able to import different units.
| Unit | Code in CSV file |
|---|---|
| Bundle | BE |
| Can | CA |
| Centigram | CGM |
| Centilitre | CLT |
| Centimetre | CMT |
| Day | DAY |
| Decigram | DG |
| Decilitre | DLT |
| Decimetre | DMT |
| Bottle | BO |
| Package | PKT |
| Gram | GRM |
| Hectare | HA |
| Hectogram | HGM |
| Shelf package | SP |
| Kilo | KGM |
| Kilometre | KTM |
| Bale | BL |
| Tin | TN |
| Cubic metre | MTQ |
| Square metre | MTK |
| Litre | LTR |
| Box | BX |
| Linear metre | LM |
| Metre | MTR |
| Milligram | MGM |
| Millilitre | MLT |
| Millimetre | MMT |
| Packet | PA |
| Pallet | PF |
| Pair | PR |
| Shipment | SE |
| Roll | RO |
| Tube | TU |
| Page | ZP |
| Piece | PCE |
| Sack | SA |
| Hours | HUR |
| Tonne | TNE |
| Inch | INH |
| Drum | DR |
| Overtime hour | OT |
Codes for sales categories
The following codes must be used for the program to be able to import different sales category templates.
| Sales VAT and ledger settings |
Code in CSV file |
|---|---|
| Service charge 6% VAT | 10 |
| Service charge 12% VAT | 20 |
| Service charge 25% VAT | 30 |
| Services 0% VAT | 40 |
| Services 6% VAT | 50 |
| Services 12% VAT | 60 |
| Services 25% VAT | 70 |
| Goods 0% VAT | 80 |
| Goods 6% VAT | 90 |
| Goods 12% VAT | 100 |
| Goods 25% VAT | 110 |
Codes for Domestic services (ROT/RUT)
The following codes must be used for the program to be able to import different types of housework services.
| Type of housework | Code in CSV file |
|---|---|
| Not eligible for Rot/Rut tax reduction | 0 |
| Construction work | 1 |
| Electrical work | 2 |
| Glass/Sheet metal work | 3 |
| Ground work/Drainage | 4 |
| Brick work including tiling and floor tiles | 5 |
| Painting and decorating work | 6 |
| Plumbing work | 7 |
| Cleaning services | 9 |
| Care of clothing and home textiles | 10 |
| Snow removal | 12 |
| Gardening work | 13 |
| Babysitting | 14 |
| Other care and supervision than babysitting | 15 |
| Moving services | 18 |
| IT services | 19 |
| Air source heat pump 30% | 20 |
| Water source heat pump 35% | 21 |
| Repair of home appliances | 22 |
| Solar heating system 30% | 23 |
| Wood boiler 28% | 24 |
| Gas boiler, oil boiler or pellet boiler 24% | 25 |
| Laundry at laundry facility | 26 |
| Furnishing | 27 |
| Transport of household goods for reuse | 28 |
| Home check-up | 29 |
Related topics
|
Import or export records (CSV file) |
|
|
Importing or exporting customer records |
|
|
Work smarter
This is how you can work most effectively
Video tutorials
Searchword: Bulk update