/
Importing expense entries

Importing expense entries

After entries are made manually or loaded via template they need to be imported in order to view the expense report.

Importing options

  • Import All - Importing all records that are new and never imported.

  • Import By Batch - A batch ID will need to be entered. The batch ID would have been entered either on the manual entry or in the template.

    1. In the Expense Import screen select Action → Import From File

    2. Browse to the location of the file and select for import:

    3. Press Continue

    4. Once the confirmation pops up that the file is imported successfully

    5. Make sure the Load Status “New” is selected. Here you will be able to see the newly imported lines with the corresponding batch IDs

    6. From this screen select all of the line items you would like to add to the same expense report by checking the checkboxes on the left of each corresponding line

    7. Press Actions and from the drop down menu of options select “Import by Batch”

    8. In the pop- up window key in the batch ID associated with the lines then press Continue

    9. The lines will be imported to the same report

    10. Return to the New batches screen and continue with the same steps for the remaining line items, by selecting the corresponding line items to import into the same report and indicating the corresponding Batch ID until you have imported all lines.

  • Import By Line - All lines that are checked from the list will be imported.

  • Import By Line & Batch - Imports the lines selected or by batch ID. If you are chose to only import those by line, a batch ID is still needed. You can put any value to by pass the required field.

Once the records are imported, a pop up window will show with messages related to successful import, warnings, or errors. Review the warning and errors and make any updates necessary. Upon successful import, the entries will be viewable on the expense report.

Related content

2025 DATABASICS, Inc