In this chapter, we will look at a specific example of importing other receivables from Excel. For general principles of Excel imports, we recommend reading the first chapter - Introduction. Excel imports are available from the Business plan and above.
Provided your license includes the import of received invoices, the import will be available at Tools -> Import -> Import from Excel -> Other Receivables.
Line items of other receivables 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.
Recommendation: If you already have existing receivables in Flexi that are similar to the receivable you intend to import, you can use the exported Excel file of an existing receivable as a template.
We will now proceed to importing a specific received invoice. We will be importing the following file: ost_pohledavky.xlsx
Since the Excel file contains column headers, check the option "Ignore the first row (column headers)" 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 receivable (unique identifier); required field |
Document type | Type of other receivable; 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; not required if referencing an entry in the address book via the company code |
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, this column must be set to "TRUE" or "1"; if the document contains line items, this column is not required; boolean value |
All properties of the issued 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 and properties of the selected columns.
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, if applicable, an option to send an error report to Flexi support.
If the import completes successfully, the newly created receivable will appear in the other receivables register.