The following data tables are supplied and filled by a CSV import from your financial accounting system:
Suppliers
Terms of payment
G/L accounts
Cost centres
Tax key
Suppliers
The Suppliers table provides the following data fields:
Financial accounting account, is automatically filled in the form
Client
Name, is automatically filled in the form
VAT ID, this is used to read out the supplier
IBAN, this is used to read out the supplier
BIC
Payment terms, the ID of the payment term required for this vendor from the iq_zahlungsbedingung table must be entered here. The net or cash discount due date is then calculated
Information on the location of the supplier
Release limit, this is used as such
Standard - sales tax
Standard - G/L account
Standard - Cost centre
Terms of payment
The terms of payment table is supplier-dependent and contains the following data fields:
Client
name
Terms of payment
Net days
Discount days
Discount percentages
G/L accounts
The G/L accounts look-up table consists of the following data fields:
Client
G/L account
Designation
Description
Cost centres
The cost centre look-up table consists of the following data fields:
Client
Cost centre
Designation
Cost centre description
Tax key
The tax key look-up table consists of the following data fields:
Client
Tax key
Designation
Tax rate
Sub-tables
We supply an account assignment table for the individual invoice items as a sub-table. This contains the following data fields:
G/L account
G/L account name
Cost centre no.
Cost centre name
Gross amount
Gross amount
Tax key
Tax rate
Tax amount
Posting text
This sub-table fills the "Invoice items" area in the invoice form and can be extended as required.
Extended SmartIndexing rules
Specially designed SmartIndexing rules are supplied for processing incoming invoices. These can also recognise and process ZUGFeRD and X invoices. In the first step, SmartIndexing checks which format the incoming invoice is in:
PDF format (conventional invoice)
PDF with readable attachments (ZUGFeRD)
XML file without visualisation (X-invoice)
All invoice formats mentioned can be read and processed in the next step.
An XML file in the valid X-invoice format is automatically processed when uploaded to the inbox or to a process. A preview PDF is created for the XML file.