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.
|Tositenumero||Voucher number||Not a mandatory information. Netvisor will generate automatically next free voucher number if not given. Max. lenght 9 numbers.||12345|
|Tositteen päiväys||Voucher Date||Not a mandatory information. Current date is used, if not given.||1.2.2016|
|Tositelaji||Voucher Class||Not 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.|
|VAT base (gross/net)|
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.
|Tilinumero||Account number||Mandatory information. Account number (must exist in Netvisor)|
|Rivisumma||Line sum||Mandatory information. Line sum without currency sign. Debet as a positive entry, kredit as a negative.||-50,25|
|Dimension 1-5||Not 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.|
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?Send feedback