This article provides a guide on how to create an Excel import file for cash vouchers that can be uploaded through the Flexi web interface.
The import allows you to:
add new documents as well as bulk-edit existing records,
import a document along with its line items in a single file,
simplify and speed up work compared to the desktop version.
We recommend first reading the general article on Excel imports in the web interface, which covers the basic requirements and settings.
Cash Vouchers – Basic Import
After selecting "Import from Excel", it is important to distinguish which type of import should be used:
Basic import – documents without line items only
Extended import – documents including line items
After uploading the file, Flexi displays an overview where the left side shows the columns from Excel and the right side shows the corresponding fields in Flexi. You need to:
verify that the column mapping is correct,
if any columns are missing, add them using "Advanced Options".
Standard and Recommended Columns for Cash Vouchers
Below are the basic columns that are commonly visible and used for importing cash vouchers:
Column Name | Description |
Document Type | Abbreviation of the selected cash voucher type. |
Cash Register | Abbreviation of the cash register the document belongs to. |
Document – Internal Number | Internal number of the cash voucher. |
Movement Type | Specifies whether the transaction is an expense or income (e.g. |
Issue Date | Date the document was issued, in |
Name | General document name or description. |
Total Amount | Total amount of the document (including all line items). |
Additional columns can be added through the settings (bottom-right corner).
You can find the correct column format by using Export to Excel in a format suitable for import.
Tip: All properties of the cash voucher and line item records can be explored in the public demo environment:
Practical Example – Importing Cash Vouchers Including Line Items
Step-by-step process:
In the Cash Vouchers agenda, click "Import from Excel".
Select the file or drag and drop it from your computer (e.g.
pokladni-pohyb.xlsx).
Flexi will automatically recognize the columns and determine what is a document and what is a line item — verify that the mapping is correct.
An import test will run to verify that the data has been entered correctly.
If everything looks correct, click "Import".
Flexi will notify you of newly created records, changes, or any errors.
Confirm the import a second time and the data will be transferred into the system.
The result will be cash vouchers including their line items.
If you need to import a document without line items, simply add a column called "No line items" to the Excel file and set the value to TRUE. Flexi will then recognize that it is a plain document without line items.