In this chapter, we will look at a specific example of importing other liabilities from Excel. For general principles of Excel imports, we recommend reading the first chapter - Introduction. Excel imports are available from the Business edition and above.
Provided your license includes the import of received invoices, the import will be available at Tools -> Import -> Import from Excel -> Other Liabilities.
Line items of other liabilities cannot be imported from Excel. They must therefore either be created manually or by converting the Excel file to XML. If you are interested in this option, please contact our support team.
Tip: If you already have existing liabilities in Flexi that are similar to the ones you intend to import, the exported Excel file of those existing liabilities can be used as a template.
We will now proceed to importing a specific received invoice. We will be importing the following file: ost_zavazky.xlsx
Since the Excel file contains column names, check the option "Ignore first row (column names)" when selecting columns.
Warning: The order of the columns selected for import must exactly match the order of the columns in the Excel file.
Internal number | Code/abbreviation of the other liability (unique identifier); required field |
Document type | Type of other liability; required field |
Issue date | Date of issue |
Due date | Payment due date |
Company code | Code/abbreviation of the business partner; enter the code/abbreviation from the address book |
Company name or person's name | Company name; does not need to be filled in if the company code references an existing record in the address book |
Posting template | Type of accounting operation (pre-posting); enter the template code |
Exempt, VAT-free [CZK] | Amount exempt from VAT; more information about importing amounts here |
Item-free doc. | If the document has no line items, the column must be set to "TRUE" or "1"; if the document contains line items, the column does not need to be included; boolean value |
Received number | Incoming number of the other liability; required field |
All properties of the received invoices register can be found at: https://demo.flexibee.eu/c/demo/faktura-prijata/properties
After selecting the relevant columns, click the "OK" button and a table will appear showing the data types of the selected columns and their properties.
After clicking the "OK" button, select the file to import and confirm your consent to import the records.
If the import fails and the Excel file needs to be corrected, a window should appear displaying the specific errors, and optionally an option to send an error report to Flexi support.
If the import completes successfully, the newly created liability will appear in the other liabilities register.