With Smart Excel Accounting material table you can import accounting vouchers to Netvisor. This form is meant to be used in situations which require e.g importing vouchers that include taxcodes, or dimensions. The table also includes a tool for transforming account numbers if the existing account list doesn't mach with the one in Netvisor. The basic principle of the form is that first you either copy or fill voucher infromation to the table, then you check the data, import the data, and double check it on Netvisor (Financials - Bookkeeping - Voucher listing). Before you begin the usage of our Smart Excel Accounting material import table, please read carefully the general instructions of Smart Excel Tables and do the instructed preparations. Accounting smart excel table requires that the accounting.nv integration resoursce is enabled on Netvisor. You can manage these rights from Rights of the interface resources -page. You can find the needed integration by typing "Netvisor Kirjanpitotietojen Excel -tuonti" to the finished integrations search bar.

Basic functions of the form

Accounting smart excel table consists of two parts: Vocuher basic information ("Tositteen perustiedot", section 1) and Voucher line information ("Tositerivin tiedot", section 2). The mandatory fields have been marked with a red star. The change of the voucher has been color coded into the form, to make it easier to read.

This voucher change is done when one or many of the voucher basic informations is changed (Voucher -date, -number, -class, or taxcode). The vouchers basic information can be inserted either> to the first line of the voucher or on every line separately. In this case however, the basic information needs to be identical on every line. You can find the finnish translations and the "voucher basic information" descritptions.

FieldTranslationAdditional InformationExample
TositenumeroVoucher numberNot a mandatory information. Netvisor will generate automatically next free voucher number if not given. Max. lenght 9 numbers.12345
Tositteen päiväysVoucher DateNot a mandatory information. Current date is used, if not given.1.2.2016
TositelajiVoucher ClassNot a mandatory information. If not given, the voucher will receive a deafult value "salesinvoice". This information can be either inserted as an acronym or by the full name.
Netvisor has the following vouchertypes as a deafult.

- Myyntilasku (ML)
- Myyntisuoritus (MS)
- Pankki (PT)
- Kassa (KT)
- Tuodut tapahtumat (PUMP)
- Automaattiset tilinpäätöskirjaukset (T)
- Järjestelmän muodostamat (AT)
- Muut (MU)
- Ostolasku (OL)
- Ostosuoritus (OS)
- Jaksotukset (JK)

HOX! User can also generate new voucher classes in Netvisor, but these can not be given as an acronym
ML tai

ALV-peruste (netto/brutto)VAT base (gross/net)Not a mandatory information. Default value is "net"brutto

If the wanted outcome is that VAT- bookings are generated automatically during the import, the voucher needs to have VAT base as "gross".

The following values are mandatory on the voucher line information fields: Account number (Tilinumero), Line sum (Rivisumma), and VAT-percentage (ALV-prosentti).

From the table below, you can find the finnish translation and the "voucher line information" descriptions.

FieldTranslationAdditional InformationExample
TilinumeroAccount numberMandatory information. Account number (must exist in Netvisor)3000
RivisummaLine sumMandatory information. Line sum without currency sign. Debet as a positive entry, kredit as a negative.-50,25
ALV-tunnusVAT-codeNot a mandatory information. VAT-code must exist in Netvisor if value is given. If the value is not given, this information is fetched behind the account numbers tax handling type. VAT-code must be alligned with the VAT- percentage. Allowed VAT-codes can be found from the table below.KOMY
ALV-prosenttiVAT-percentageMandatory information. ALV-percentage must exist in Netvisor.24
SeliteDescriptionNot a mandatory information. Free description for the voucher line. Max char. 200Free text description
Kohdeotsikko 1-5Dimension 1-5Not a mandatory information. When dimensions are imported the dimension name is given at the first row of the column. Dimension items are then given per voucher line. If the dimension is not found in Netvisor, it will be automatically generated.Project 123
SeurantakohdeAccount dimensionNot a mandatory information. Account dimension must exist in Netvisor.Tilikauden lisäykset

Allowed VAT-classes:

No VAT processingNONE0
Domestic salesKOMY0, 10, 14, 24
EU salesEUMY0
Sales outside the EUEUUM0
Domestic purchaseKOOS0, 10, 14, 24
EU purchaseEUOS0, 10, 14, 24
EU service purchase EUPO0, 10, 14, 24
Non - EU purchasesEUUO0, 10, 14, 24
100% deductible tax1000
312 EU service salesEUPM3120
309 EU service salesEUPM3090
Other turnover excluding VAT (310)MUUL0, 10, 14, 24
Purchases of goods from other EU countries, non-deductibleEVTO0, 10, 14, 24
Purchases of services from other EU countries, non-deductibleEVPO0, 10, 14, 24
 Sale of construction servicesRAMY0
Purchase of construction serviceRAOS0, 10, 14, 24
Non-deductible purchase of construction serviceEVRO0, 10, 14, 24

After all the voucher information have been filled, you can import the data by clicking "Lähetä tositteet" -button. If the account numbers in the import material do not match with the ones in Netvisor these numbers must be changed. See seperate instructions below.

The excel table will show successful and failed transfers after the import. Successfully transferred vouchers are shown in green and the lines locked in order to prevent duplicates. Failed transfers are shown in red and the field "Lähetyksen tila" (transfer status) shows the error code. You can edit these voucher lines and retry the import. These errors are normally related to missing of mandatory information, or account numbers from Netvisor. One possible reason is also invalid data type.

After import the successfully transferred voucher can also be removed from the table by clicking "Tyhjennä OK siirrot"-button. You can also remove the failed transfers by clicking "Tyhjennä virheelliset siirrot" button.

Account number transformation tool

You can find the account number transformation tool from the "Korvaa tilinumeroita -asetukset" -tab. First you add the account numbers from the external system to the "Korvattava tilinumero" -field and the corresponding account number from Netvisor to the "Korvaava tilinumero" - field. After the values have been added to both columns, you can press "Muunna tilinumerot" -button. Before the import, you should check the data once more.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.