Smart Excel tables - Accounting material import

General
Basic functions of the table
Voucher basic information
Voucher line information
Sending the vouchers
Account number transformation tool

General

With Accounting material Smart Excel table you can import accounting vouchers to Netvisor. This table 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 match with the one in Netvisor. The basic principle is that first you either copy or fill voucher information to the table, then you check the data, import the data, and double check it on Netvisor (Financials - Bookkeeping - Voucher listing). Before you begin using Smart Excel Accounting material import table, please read carefully the general instructions of Smart Excel Tables and do the instructed preparations. Accounting material Smart Excel table requires that the accounting.nv integration resource is enabled in 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 table

Accounting material 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.

Voucher basic information

Voucher change is done when one or many of the voucher basic informations has 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" descriptions in the table below.

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

Voucher line information

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.

Allowed VAT-classes:

Sending the vouchers

After all the voucher information has 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 are 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 the import the successfully transferred vouchers 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 number 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