IntegrationHTTP-methodResourceDTDSchemaExample
Get accounting dataGETaccountingledger.nv  Download 
Import accounting dataPOSTaccounting.nvDownload Download
Edit accounting dataPOSTaccountingedit.nv
Download
Invalidate accounting dataPOSTinvalidatevouchers.nv
DownloadDownload
Deleted vouchersGETdeletedvouchers.nv



Get whole account listGETaccountlist.nv  Download
Get accounting periodsGETaccountingperiodlist.nv  Download 
Get voucher typeGETvouchertypelist.nv

Download

Get accounting data

Resource: accountingledger.nv

Parameter nameOccursDescriptionExample
startdate1Finds vouchers that are added after given date (inclusive)
2012-10-23
enddate1Finds vouchers that are added before given date(inclusive)
2013-10-24
accountnumberstart0...1Finds vouchers which account number is equal or greater than given value
3000
accountnumberend0...1Finds vouchers which account number is equal or less than given value
3500
changedsince0...1Finds vouchers that are modified or added after given date
2013-01-01
lastmodifiedstart0...1Finds vouchers that are modified after given date
2012-10-23
lastmodifiedend0...1Finds vouchers that are modified before given date
2013-10-24
showgenerator0...1Returns the creator of the voucher (eg. user or system)1
voucherstatus0...1Finds all, only valid or invalidated and deleted vouchers. Status -attribute shows which status voucher is: "valid", "invalidated" or "deleted"1 = All
2 = Valid
3 = Invalidated and deleted

Response:

LevelElement nameType and lengthOccursDescriptionExample
rootrootAggr.1  
1vouchersAggr.1  
2voucherAggr.0...n  
Attr.statusText0...1Status of the Voucher
valid, invalidated or deleted
netvisorkeyNumeric1Netvisor key of the Voucher
15
voucherdateDate 1Date of the Voucher
31.12.2023
vouchernumberNumeric 1Voucher's reference number
515144
voucherdescriptionText 1Free description text 
voucherclassText 1Class of voucher
Myyntilasku
linkedsourcenetvisorkeyNumeric1Netvisor key of the sales- or purchaseinvoice
123
Attr. typeText 1"purchaseinvoice" or "salesinvoice"purchaseinvoice
vouchernetvisoruriText 1URI to the voucher in Netvisor 
voucherlineAggr.0...n  
4netvisorkeyNumeric1Voucher lines Netvisor key6
4linesumNumeric 1Sum of the voucher line
150,22
descriptionText 1Free description text 
accountnumberNumeric 1Account number
1701 
vatpercentNumeric 1VAT percent
24 
vatcodeTextVAT code  
4accountdimensionText0...1 Seurantakohde 1 
Attr.typeNumeric1 netvisorkey
dimensionAggr.0...1  
5dimensionnameText 1Dimension name 
dimensionitemText 1Dimension 

Import accounting data

Resource: accounting.nv

Note! A transaction payment for web invoice will be charged for each voucher attachment imported to Netvisor via interface.

Vouchers, voucher lines, the lines' dimensions and attachments can be imported into accounting materials. The request must be directed to Accounting.nv resource without parameters. One request can only carry one voucher. If voucher's id is not given, the system automatically assigns a new id for it.

Allowed types of vouchers are (Finnish names must be used in voucherclass field when importing data):

  • Sales invoice (myyntilasku)
  • Sales payment (myyntisuoritus)
  • Bank (pankki)
  • Treasury (kassa)
  • Imported events (tuodut tapahtumat)
  • Automatic financial statements (automaattiset tilinpäätöskirjaukset)
  • Vouchers formed by the system (Järjestelmän muodostamat)
  • Purchase invoice (ostolasku)
  • Purchase payment (ostosuoritus)
  • Others (muut)
  • Accruals (jaksotukset)
  • Salaries (Palkka, PA)

Voucher line's sum's type, net or gross, is chosen for each voucher. If the type is net, the system will not automatically calculate VAT lines and rounding difference lines, and the voucher will be exactly as the imported material. When type is gross, VAT and rounding difference lines will be automatically calculated by the system.

The account chosen for the voucher must be found from the system, otherwise an INVALID_DATA error with further information is returned. VAT code is retrieved from the chosen account if it has not been specified. If the user enters a VAT code that conflicts with the VAT rate entered for the line, an error is returned with further information.

There must be always debit and credit sides when importing a voucher. Positive sum is recorded as debit and negative sum as credit. If the debit and credit entries do not match, the difference is automatically recorded in rounding differences.

One voucher line can relate to several dimensions. If the "Dimension Name" or "Dimension Item" values are not found in the system, it will create new ones.

While importing a voucher, several attachments can be included. The attachments need to be base64 encoded and included in the XML message. API doesn't check the size of the attachments, but the maximum size of attachments is 2GB.

Request:

LevelElement nameType and lengthOccursDescriptionExample
RootrootAggr.1  
1voucherAggr.1  
2calculationmodeText1net (vat lines are not calculated automatically) or gross (vat lines are calculated automatically)net
2voucherdateDate 1Date of the voucher
2013-10-20
Attr.formatText 1Date format, always ansi
ansi
numberNumeric 0...1Number of voucher. If not given, system automatically picks next number
42
descriptionText, max. 2550...1Description of the voucher 
voucherclassText1Myyntilasku, Myyntisuoritus, Pankki, Kassa, Tuodut tapahtumat, Automaattiset tilinpäätöskirjaukset, Järjestelmän muodostamat, Ostolasku, Ostosuoritus or Muut
Myyntilasku
2checkedText0...1Defines whether imported voucher rises to unchecked postings view. True or false. False by default.false
voucherlineAggr.0...n  
3linesumNumeric1Negative value is recorded to credit side and positive value on debit side. Two decimal maximum.
-100,00
Attr.typeText 0...1net or gross
net
 3descriptionText, max. 255 0...1Description text 
accountnumberNumeric1Accounting account number, must be found or an error is returned
1701
vatpercentNumeric1Must not be in conflict with vatcode attribute
24
Attr.vatcodeText0...1If not given, value behind account number is used. Check valid values from the table below.
KOMY
3accountdimensionText0...1Voucher's follow-up object.Seurantakohde 1
Attr.typeText1name or netvisorkey (shown only in Netvisor)name
dimensionAggr.0...n  
4dimensionnameText1Dimension name. If dimension is not found from system, it is created
Project 1
 4dimensionitemText1Dimension. If item in dimension is not found from system, it is created
Payroll
voucherattachmentsAggr.0...1  
3voucherattachmentAggr.1...n  
4mimetypeText1MIME-type of the attachment
application/pdf
attachmentdescriptionText, max 100 characters1Description text for the attachment
Example attachment
filenameText, max 255 character1File name of the attachment
Attachment.pdf
documentdataBase641Data of the attachment as base64 encoded string 

Allowed VAT-classes:

VAT-classVAT-codeVAT-percent
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
Non-deductible reverse tax-liability
EVKV0, 10, 14, 24
Reverse tax-liabilityKAVE0
Sale of construction servicesRAMY0
Purchase of construction serviceRAOS0, 10, 14, 24
Non-deductible purchase of construction serviceEVRO0, 10, 14, 24
Outside EU import tax
MAAL0, 10, 14, 124
Outside EU import tax non-deductibleEVMA0, 10, 14, 24
KOMY 0%KOMY00


Edit accounting data

Resource: accountingedit.nv

Accounting edit can be used for editing existing voucher, voucher lines, voucher line dimensions and voucher attachments. The request doesn't have parameters. One request can include only one voucher. Accounting edit can be used for editing voucher's basic info and voucher lines. Basic info is not compulsory if only voucher lines are being edited. Accounting edit invalidates existing voucher lines and imports requests voucher lines as new voucher lines. If voucher lines are not imported in the request, no changes are made to the existing vouher lines.

The data to be imported must be included in the request as an XML with the following structure:

LevelElement nameType and lengthOccursDescriptionExample
RootrootAggr.1  
1voucherAggr.1

2netvisorkeyNumeric1Netvisor key of the voucher being edited. Netvisor key can be retreived with the resource accountingledger.nv123
2calculationmodeString0...1Calculation mode for the voucher. Net (vat lines are not calculated automatically) or gross (vat lines are calculated automatically).gross
2voucherdateDate0...1Voucher date2009-1-1
Attr.formatString1Date format, always ansiandi
2numberNumeric, max. 90...1Voucher number. If not given, the system automatically picks next number from the chosen voucher class1
2descriptionString, max. 2550...1Voucher descriptionDescription
2voucherclassString0...1Voucher class. See possible voucher classes above. It is also possible to create own voucher classes.Myyntilasku
2voucherlineAggr.0...n

3linesumNumeric1Line sum. Negative value is recorded to credit side and positive value on debet side. Two decimal maximum.
-100,00
Attr.typeString0...1net or grossnet
3descriptionString, max. 2550...1Voucher line descriptionDescription
3accountnumberNumeric1Accounting account number, must be found or an error is returned.3000
3vatpercentNumeric1Vat percent. Must not be in conflict with vatcode attribute.
24
Attr.vatcodeString0...1VAT code. If not given, value behind account number is used. Valid values are: NONE, KOOS, EUOS, EUUO, EUPO, 100, KOMY, EUMY, EUUM, EUPM312, EUPM309, MUUL, EVTO, EVPO, RAMY, RAOS, EVRO, EVKV
KOMY
3accountdimensionString0...1Voucher line's follow-up object.Seurantakohde 1
Attr.typeString1name or netvisorkey (shown only in Netvisor)name
3dimensionAggr.0...1

4dimensionnameString, max. 501Dimension name. If dimension is not found from system, it is created.Project
4dimensionitemString, max. 2001Dimension item. If item in dimension is not found from system, it is created.Project x
2voucherattachmentsAggr.0...1

3voucherattachmentAggr.1...n

4mimetypeString1MIME-type of the attachmentapplication/pdf
4attachmentdescriptionString1Description text for the attachmentExample attachment
4filenameString1File name of the attachmentAttachment.pdf
4documentdataString1Data of the attachment as base64 encoded string

Invalidate accounting data

Resource: invalitadevouchers.nv

This resource is used to invalidate vouchers in Netvisor by utilizing Netvisorkey. The Netvisorkey of the voucher can be retrieved using resource accountingledger.nv. It is possible to add comment with the request, which is shown in processing history in Netvisor. Note that a maximum of 100 vouchers can be invalidated with a single request.

The data to be imported must be included in the request as an XML with the following structure:

Level
Element nameType and lengthOccursDescriptionExample
1rootAggr.1

2invalidatevouchersAggr.1

Attr.identifierString1Linkin data type, always 'netvisorkey'netvisorkey
3commentString max 2550...1Free text, comment is seen in voucher's processing history in Netvisor
The reason of the invalidation is...
3invalidatevoucherNumeric1...100Netvisorkey of the voucher to be invalidated123

Deleted vouchers

Resource: deletedvouchers.nv

Retrieves vouchers that have been deleted since the given date. Vouchers can be retrieved up to 7 days from the given date.

Querystring parameters:

ParameterOccursDescriptionExample
deletedsince1Mandatory parameter. Retrieves events that have been deleted since the given date. Events can be retrieved up to 7 days from the given date.
2022-06-08

Response:

Level
ElementTypeOccursDescriptionExample
rootrootAggr.1  
1
DeletedVouchersAggr.1

2
DeletedVoucherAggr.0...n


3
NetvisorKeyNumeric1Netvisor ID of voucher5
3
DeleteDateDate
1Delete date2022-06-08 15:14
Attr.
formatString1Date format, always ansiansi

Get whole account list

Resource: accountlist.nv

Used for fetching whole account list and default accounts used in default accounting.
Response:

LevelElementTypeOccursDescriptionExample
RootRootAggr.1  
1AccountListAggr.1  
2CompanyDefaultAccountsAggr.1  
3TradePayablesNumeric1  
3PurchaseVATReceivableNumeric1  
3RoundingOffDifferenceNumeric1  
3VATpayableNumeric1  
3TaxAccountNumeric1  
3AdvancePaymentsNumeric1  
3SalesReceivablesNumeric1  
3SalesVATdebtNumeric1  
3InventoryNumeric1  
3SalesDiscountNumeric1  
3SalesExchangeRateDifferecesNumeric1  
3CollectionNumeric1  
3PurchaseDiscountsNumeric1  
3PurchasesExchangeRateDifferencesNumeric1  
3PurchaseInvoiceAccrualNumeric1  
3SalesInvoiceAccrualNumeric1  
3PurchaseDomesticDefaultNumeric1  
3PurchaseEUDefaultNumeric1  
3PurchaseOutsideEuDefaultNumeric1  
3SalesDomesticDefaultNumeric1  
3SalesEUDefaultNumeric1  
3SalesOutsideEUDefaultNumeric1  
3AccountsAggr.1  
4AccountAggr.1...n  
5NetvisorKeyNumeric1 Database ID 
5NumberNumeric1 Account number 
5NameNumeric1  
5ForeignNameText0...3Account in Swedish or in English 
Attr.ISO-3166Text1 fi|en|se 
5AccountTypeText1Type of the account, account or accountgroup 
5FatherNetvisorKeyNumeric1Under which account, account belongs
ie. account 3000 father is group 300
 
5IsActiveNumeric1  
5IsCumulativeNumeric1Is the calculation cumulative. Balance sheet 
5SortNumeric1  
5EndSortNumeric1  
5IsNaturalNegativeNumeric1  

Get accounting periods

Resource: accountingperiodlist.nv

Used for getting accounting periods and possible lockdowns.
Doesn't return which period is active. Lists all possible periods in ascending order.

Querystring parameters:
(No parameters)

Response:

LevelElement nameType and lengthOccursDescriptionExample
RootRootAggr.1  
1AccountingPeriodListAggr.1  
2PeriodLockInformationAggr.1  
3AccountingPeriodLockDateDate1Lock period2014-12-31
Attr.formatText1Date format, always ansiansi
3VatPeriodLockDateDate1VAT-lock date
2014-12-31
Attr.formatText1Date format, always ansiansi
3PurchaseLockDateDate1Accounts payable lock date2014-12-31
Attr.formatText1Date format, always ansiansi
3PeriodAggr.1...n  
4NetvisorKeyNumeric1Period NetvisorID123
4NameText1Name 
4BeginDateDate1Period start date 
Attr.formatText1Date format, always ansiansi
4EndDateDate1Period end date 
Attr.formatText1Date format, always ansiansi

Get voucher types

Resource: vouchertypelist.nv

The resource returns company's voucher types and default voucher types

Response: 

Level
Element nameType and lengthOccursDescription
Example
RootRootAggr.1  
1VoucherTypeListAggr.1  
2DefaultVoucherTypesAggr.1 Default voucher type 
3SalesInvoicesAggr.1

4NetvisorKeyNumeric1Sales invoice -Netvisor key of the delauft voucher type123
3SalesInvoicePaymentsAggr.1

4NetvisorKeyNumeric1Sales invoice payment -Netvisor key of the default voucher type125
3PurchaseInvoicesAggr.1

4NetvisorkeyNumeric1Purchase invoice -Netvisor key of the default voucher type128
3PurchaseInvoicePaymentsAggr.1

4NetvisorKeyNumeric1Purchase invoice payment -Netvisor key of the default voucher type126
3OtherSystemGeneratedVouchersAggr.1

4NetvisorKeyNumeric1Other vouchers generated by the system -Netvisor key of the default voucher type129
3BankStatementViewVouchersAggr.1

4NetvisorkeyNumeric1Vouchers generated from bank statement view -Netvisor key of the default voucher type122
3AccrualsAggr.1

4NetvisorKeyNumeric1Accruals -Netvisor key of the default voucher type127
2VoucherTypesAggr.1Voucher types

3VoucherTypeAggr.1...n

4NetvisorKeyNumeric1Netvisor key of the voucher type121
4AbbreviationText1Abbreviation of the voucher typeML
4NameText1Name of the voucher typeMyyntilasku
4ForeignNameText
0...3Voucher type in Swedish or in English
Attr.ISO-639-1Text
1fi|en|sv




Did you find it helpful? Yes No

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