In this article, you will find instructions on how to create an Excel import file for other receivables that can be uploaded to the ABRA Flexi web environment.
Compared to the desktop application, importing in the web environment offers several advantages:
you can import documents and their line items in a single file,
the process is faster and more straightforward,
format adjustments are applied directly during the import.
Before you begin, we recommend reading the general article on Excel imports in the web interface, which covers general requirements and explains how to work with basic imports.
Below, we will show you how to prepare a file for importing other receivables including document line items.
__________________________________________________________________
Importing other receivables
After selecting "Import from Excel", you need to choose the correct file type:
Basic import – invoices without line items,
Extended import – invoices including their line items.
Flexi will then display an overview where:
the left column shows the column names from Excel,
the right column shows the corresponding fields in Flexi.
Verify that the column mapping is correct and, if necessary, fill in any missing information via Advanced options.
Required and recommended columns for other receivables
The following are the standard columns for importing other receivables:
Internal number – required field (unique document identifier).
Company name – abbreviation or full name of the company/person.
Issue date – in the format
DD.MM.YYYY.Due date – in the format
DD.MM.YYYY.Days overdue – does not need to be filled in; Flexi calculates this automatically.
Total amount – the total value of the invoice.
Total VAT – the VAT amount.
Cost centre – cost centre abbreviation.
In the web interface, you can also add additional columns — their settings can be found in the bottom-right corner of the window.
The easiest way to find the correct field format is to use Export to Excel in a format suitable for import, or you can refer to the properties.
Importing receivables including line items (practical example)
To import documents including line items:
Select Extended import.
Prepare the Excel file in the correct format (Flexi distinguishes between what is a document and what is a line item).
A sample file can be downloaded.
Recommendation: if you want to modify existing documents, also add an ID column to the file.
Import procedure:
First, a test import will run to verify the accuracy of the data.
If everything is correct, click "Import" in the bottom-right corner.
A confirmation window will appear indicating whether the import was successful.
This way, you can quickly and easily upload other receivables to the ABRA Flexi web environment, both with and without line items.
Tip for documents without line items:
If you are importing a document without line items, add the following to your Excel file:
a column named No line items,
with the value TRUE.
This tells Flexi that the document has no line items.