It is possible to import sales invoices into Netvisor in Finvoice XML format using Data import tool. Data import is available for all companies and the user importing invoices has to have editing authorization for "Perustietojen hallinta" and "Perustietojen tuonti" in Accouting function specific rights. Data import can be found in Netvisor UI: Company menu > Data import and export > Data import.

To be able to import sales invoices you need invoice material in Finvoice standard. The oldest supported version of Finvoice is 1.2 but newer versions can also be used.

The Web Service Interface has to be activated in order to import sales invoices. You can activate Web Service Interface in Company menu > Rights of interface resources by typing "Netvisor laskutietojen tuonti (Finvoice)" in the search bar. Select the right integration and enable all resources.

The person importing sales invoices must create API identifiers in Company menu > API and identifiers > click "Create new API identifier".

Importing sales invoices in Finvoice format is included in all service packages.

Finvoice import requires the following resources in order for it to work correctly:

Customer.nvImporting customer details
Customerlist.nvRetreiving customer list
Product.nvImporting product details
Productlist.nvRetreiving product list
Salesinvoice.nvImporting sales invoice / sales order

Finvoice import details

The table below shows fields taken from the Finvoice material and what field is uses in Netvisor. Secondary information is used if primary information is not given in the Finvoice material.

Finvoice field, primaryFinvoice field, secondaryField in NetvisorDescription

SellerOrganisationTaxCodeSellerPartyIdentifierSeller's Business IDSeller's business ID (y-tunnus), must be the same as in the Netvisor's basic data settings.
Delivery date
Invoice number 
Invoice date
EpiRemittanceInfoIdentifierEpiReferenceReference number
Payment term daysPayment term is formed by subtracting InvoiceDate from InvoiceDueDate
Cash discount days for the payment term
Cash discount percent
Delivery method
Delivery term
Free text before invoicelines
Our reference
Your reference
Order numberOrder number is shown in sales invoice Additional information
Seller name
CurrencyCurrency code is taken from the message attribute
Attribute: AmountCurrencyIdentifier

Invoicing information to the invoice

Customer code

InvoiceRecipientOrganisationNameBuyerOrganisationNameCustomer name
Extension for nameThe second occurrence of the element is the extension for name
Customer's Business ID
Customer's Business ID when creating new customer. NOTE! The Business ID should be valid Finnish Business ID. If you wish to use foreign VAT identifier it is not taken from the Finvoice material. Foreign VAT identifiers have to be added manually to customer details
InvoiceRecipientStreetNameBuyerStreetNameCustomer address
InvoiceRecipientPostCodeIdentifierBuyerPostCodeIdentifierCustomer post number
InvoiceRecipientTownNameBuyerTownNameCustomer city
CountryCodeCountryCodeCustomer country code ISO3166 standard
Delivery information to the invoice

Delivery name
Delivery address
Delivery country code
Delivery city
Delivery country code ISO3166 standard

Customere details to the customer card (if not exist)

InvoiceRecipientPhoneNumberIdentifierBuyerPhoneNumberIdentifierPhone number
InvoiceRecipientEmailaddressIdentifierBuyerEmailaddressIdentifierEmail invoicing address
E-invoice address
E-invoice operator
Invoice row

Product codeProduct code when createing a new product or targeting to an existing product
Product name
Product unit priceCalculated on the basis of line sum, delivered quantity and discount
Discount percent
Product quantity
Accounting suggestion
Row free text
Order number

Dimensions of the invoice row's

Dimension header
Dimension item
Product details to the product card (if not exist)

Product code
Product name
Product unit priceCalculated on the basis of line sum, delivered quantity and discount
Attribute: QuantityUnitCode
Comment row

Comment rowElement must be the only element in the InvoiceRow

To be able to import scandinavian letters (å, ä, ö) the material needs to be encoded in ISO/IEC 8859-15 form. 

It is also possible to import dimension headers and dimension items in fields RowDefinitionHeaderText and RowDefinitionValue. 

If customer doesn't exist in Netvisor before import, the e-invoice details and e-mail invoicing address are imported to Netvisor if this information is found in the finvoice file. And if customer is already in Netvisor (i.e. the customer code used in the finvoice is found in Netvisor), the e-invoice details/e-mail invoicing address are not updated from the finvoice file. E-invoice details/email invoicing address should be manually saved to customer details in Netvisor or imported using csv Customer Data import. If you want invoices to be allocated to a customer card in Netvisor in the future, the customer code (InvoiceRecipientPartyIdentifier or BuyerPartyIdentifier) must be same in the finvoice file and in the Netvisor customer card.

One Finvoice file can include multiple invoices. This way there is no need to import invoices one at a time.

Phases of Finvoice import

  1. Open Company menu and choose "Data import"
  2. Choose "Lasku/suoritus XML" (see picture below, step 1) and press "Selaa" (2)
  3. Find the right Finvoice file and press ""Submit data" -button (3). This starts the Finvoice import.

If there are no errors in the import, Netvisor will show a specification of imported data and links to formed material.

Finvoice import establishes customers and products used in the import if customers or products do not exist in Netvisor before import. Please note that customer's e-invoice details or e-mail invoicing addresses are not imported. If customers and products used in the import exist in Netvisor, the imported customers and products are targeted to existing ones.

If the imported material contains errors an error message is shown. The message tells why the material cannot be imported into Netvisor. If the material includes more than one invoice the invoices in right form are imported. There is an editor window below the error message but the material cannot be edited in that window. All changes to the invoice material must be done in the original file. After correcting the material the invoices can be imported again. Please do not edit the imported invoices in Netvisor after the import. 

Finvoice examples

The examples below show the minimum information that the Finvoice material must have in order to import a sales invoice, as well as the maximum information that can be read from the material. In addition to these, the Finvoice material may have other information according to the Finvoice standard, but it is not read into Netvisor.

Finvoice minimum

<?xml version="1.0" encoding="ISO-8859-15"?>
<?xml-stylesheet type="text/xsl" href="Finvoice.xsl"?>
    <InvoiceDate Format="CCYYMMDD">20230124</InvoiceDate>
    <InvoiceDueDate Format="CCYYMMDD">20230207</InvoiceDueDate>
    <DeliveredQuantity QuantityUnitCode="pcs">10,00</DeliveredQuantity>
    <RowAmount AmountCurrencyIdentifier="EUR">100,00</RowAmount>

Finvoice maximum

<?xml version="1.0" encoding="ISO-8859-15"?>
<?xml-stylesheet type="text/xsl" href="Finvoice.xsl"?>
    <InvoiceRecipientOrganisationName>c/o uusi tilitoimisto</InvoiceRecipientOrganisationName>
            <InvoiceRecipientStreetName>Soratie 2</InvoiceRecipientStreetName>
        <DeliveryDate Format="CCYYMMDD">20230223</DeliveryDate>
        <InvoiceDate Format="CCYYMMDD">20230223</InvoiceDate>
        <InvoiceTotalVatIncludedAmount AmountCurrencyIdentifier="USD">0</InvoiceTotalVatIncludedAmount>
        <InvoiceFreeText>Vapaa teksti</InvoiceFreeText>
            <InvoiceDueDate Format="CCYYMMDD">20230309</InvoiceDueDate>
			<RowDefinitionValue>Projekti 15</RowDefinitionValue>


Did you find it helpful? Yes No

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