In this article you will find a guide on how to create an Excel import file that can be uploaded via the web interface.
Using the import, you can add new information or bulk-edit existing records.
To get started, we recommend reading the article on Excel imports in the web interface first.
__________________________________________________________________
Bank Accounts
The web interface allows you to import a list of bank accounts. This import makes work easier for companies that manage multiple accounts.
Below, we will look at the columns that are defined by default (visible) or required.
Column | Description |
Abbreviation | A text field indicating the record abbreviation. Required field |
Name | A text field where you can enter, for example, the name of the bank |
Bank account number | Contains the account number without the bank code. Required field |
Bank code | The code of the respective bank. Required field |
IBAN | Fill in if the account is foreign or if international payments are sent from it |
Currency | The currency abbreviation in which the bank account is maintained |
In the web interface, you can of course add more columns via the settings in the bottom right corner. The easiest way to determine the format of individual fields is to use Export to Excel in the format suitable for import into Flexi.
__________________________________________________________________
Importing New Records
We will now look at importing a file of new records. (If you want to modify an existing record, we recommend adding a column with the ID to make the import more precise.)
The Excel file will be formatted as follows (sample available for download):
Using the additional options menu (three dots), select the Excel import option. Once the file is uploaded, a preview and column mapping screen will appear:
By clicking the Test import button, Flexi will display how many records will be created — allowing you to review before confirming. Once confirmed, the records will be uploaded into Flexi:
