This article is also available in:

Importing incoming invoices

For the import of the incoming invoices, the tabs 'incominginvoices' and 'incominginvoiceslines' are used. The connection is made on the basis of the 'NR' column. This has to be the same on both tabs so the lines are linked to the right incoming invoice.

Make sure you also read the general information about data import in Robaws.

Incoming invoices

Column titles

Column title	Field in Robaws
NR	Number of the incoming invoice
DATE	Date
EXPIREDATE	Due date
SUPPLIERNR	Supplier number, has to be the same as the 'NR' column on the suppliers tab
SUPPLIERNAME	Supplier name, has to be the same as the 'NAME' column on the suppliers tab
STATUS	Status
TYPE	If it is a credit note, you fill in 'CREDIT' here
INVOICENR	Original invoice number

The 'NR' column on 'incominginvoices' has to contain a unique value, otherwise the import is stopped.

Incoming invoice lines

The 'NR' column is always mandatory because it is what makes the link with the incoming invoice.

Column titles

Column title	Field in Robaws
NR	Number of the incoming invoice, has to be the same as the 'NR' column on the incominginvoices tab
AMOUNT	Quantity
UNITTYPE	Unit
LINE_TYPE	Line type - You have to enter a specific value for this (see below).
PRICE	Price
COSTPRICE	Cost price
BTWTYPE	VAT tariff
DESCRIPTION	Description
EXTRADESCRIPTION	Extra description
CHAPTER	Post number
ACTIVITY	Activity
PROJECTNR	Project number, has to be the same as the 'NR' column on the projects tab
ARTICLENR	Item number, has to be the same as the 'NR' column on the articles tab
AGREEMENTTYPE	Type (SOG, FH, ... )

Line type

Line: P
Title: H
Total: T
Quantity: A
Check: C
Variant: V
Text: Tx
Chapters: H1, H2, H3, H4, ...

Updated on: 09/09/2026

Was this article helpful?

Thank you!