Import List
Table of Contents
After completing/selecting a mass import under Add Expenses, you can view the Import List, which displays all previous imports:
Key columns include:
- File Name;
- Import ID: Crucial for filtering invoices in the Managed Expenses table;
- Import Date;
- Company Name;
- User who performed import;
- Import Result: Indicates whether the import was successful or if there were any errors.
Understanding Import Results
You can see how many expenses were imported and how many CSV rows were found. The number of imported vs. identified expenses can vary because a single expense might span multiple CSV rows if you choose the "Multiple Lines" import option and have expense line items in your CSV file.
The "CSV rows" column shows the number of imported rows compared to the total identified rows in the CSV file (this applies to imports done after 07/06/2024).
If some rows are skipped, reasons for skipping will be provided. For example:
- Missing country information;
- Dates that are too far in the past;
- Technical errors.
Handling Skipped Rows
If your import skips any rows, you can download a report that contains only those rows, along with reasons for skipping.
Common reasons include:
- Companies not mapped in the system;
- Missing settings in VAT registrations;
- Countries outside of our service scope, etc.
Retry Failed Documents
If some documents fail to import, you can opt to Retry Failed Documents. This allows the system to reassess and attempt to locate the documents again without needing to redo the entire import process.
Viewing Imported Invoices
To view invoices associated with a specific import, you can:
- Find the right import → More;
- Click on View Imported Invoices to access the Managed Expenses table pre-filtered for that import.
- Alternatively, use the Import ID to search for invoices directly in the Managed Expenses section.
Reverting an Import
If you need to undo an import, the Revert Import function allows you to remove all imported expenses from the import table.
Please keep in mind that when an import reverts - all expenses related to import will be deleted.