In this chapter, we will walk through a specific example of importing from Excel into the Internal Document Line Items register. Internal documents are used to create accounting and closing entries, as well as exchange rate and residual differences that are not related to matching. For more information about internal documents, please refer to our documentation.
This guide, however, does not cover importing internal documents themselves, but rather their line items. Line items can only be created once an internal document exists to import them into.
If your license includes imports for issued invoices, they will be available in the Tools module (Tools -> Import -> Import from Excel -> Internal Document Line Items).
Now let's move on to importing a specific statement. We will be importing the following sample file: polozky_internich_dokladu.xls
Since the Excel file contains column headers, check the "Ignore first row (column names)" option when selecting columns.
Note: The order of the columns selected for import must exactly match the order of the columns in the Excel file.
The table below explains what value each column should contain.
Column | Description |
Internal Document | Enter the code (internal number) of the internal document into which the line items should be imported. |
Credit Account (Base) | Credit account for the base amount |
Copy Credit Base Account | Should the credit base account be copied from the internal document header? Boolean value - TRUE / FALSE. |
Debit Account (Base) | Debit account for the base amount |
Copy Debit Base Account | Should the debit base account be copied from the internal document header? Boolean value - TRUE / FALSE. |
Unit Price | Price per unit of measure for the line item. For internal documents, this will most likely match the total line item price. |
Total [CZK] | Total amount for the line item. |
VAT Rate Type | Possible values:
|
We would like to remind you that if you want to import internal document line items, you must first create an internal document into which you will import the line items.
It is possible to import significantly more information into internal document line items. However, the fields mentioned above are sufficient for demonstration purposes.
All register attribute properties can be found at:
https://demo.flexibee.eu/c/demo/interni-doklad-polozka/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. The import will notify you of the internal document update. The "To be updated" column will show the number of line items being imported.
If you want to update existing line items, the import confirmation screen will look the same. In that case, always reference the ID column.
If the import fails and the Excel file needs to be corrected, a window with specific errors should appear, along with the option to send an error report to Flexi support.
If the import completes successfully, the newly created line items will appear in the register within the respective internal documents.