Travel Expense Import
In this view, travel expenses can be imported using the CSV file format or Onexma API with the import type of expenses or account statement entries.
The travel expenses can be imported as account statement entries with the type of payment or direct expense, or as expenses with the type of taxable expense.
The import can be switched between the two workflows.
Once the travel expenses have been imported, the entries can be processed and recorded automatically or manually.
Assign and Check
This button executes the functions for assigning and checking (validating). The imported travel expenses are checked and validated by executing the function. Errors are displayed in a log.
Automatic reference assignment is only performed for the validation status gray and red.
When saving a record in the view, the validation function is also executed for that record. Validation does not prevent saving in this view but sets the validation status.
Validation Status
You can filter by individual statuses using this drop-down list. The following validation statuses are available:
- Validation status = gray, after import, if no validation has been performed.
- Validation status = green, the imported data is all valid and can be accepted or is excluded from acceptance.
- Validation status = red, when validating, one or more values may be incorrect or missing. Travel expense import entries with a red validation status must be manually reworked before they can be accepted.
The validation statuses of the travel expense import entries are displayed in the first column of the object list.
Import Status
You can filter by individual import statuses using this drop-down list. The following import statuses are available:
- Not imported
- Imported
Accept
This button accepts all marked travel expense entries with valid data for further processing as expenses or account statement entries.
In detail, travel expense import entries that are not yet valid can be manually reworked.
The values in the areas Imported and Booking Data Imported are taken from the imported file and cannot be edited in the view.
The value in the "Set Type" area can be changed via the expense checkbox to alter the import type.
- For import type expense, the fields File, Employee/Location, Service Type, Tax Situation, and Booking Text can be edited,
- For import type payment, the fields File, Employee/Location, Tax Situation, and Booking Text can be edited.
When all required fields of the travel expense import entries are filled, these travel expense import entries also receive the green validation status and can be accepted.
The values from the detail are also displayed in the columns of the object list.
New Travel Expense Import Settings
In this view, you can configure settings for the travel expense import. Settings for travel expenses with the import formats CSV file and Onexma for import type expenses or account statement entries can be configured.
Additionally, file changes can be transferred to Onexma from this view.
Related to