If you need to add existing mileage in bulk or require changes to several existing mileage records, we recommend using the import tool.
Note: Before completing an existing mileage import, please download and read the full Existing Mileage Import Specification. You can also download an Existing Mileage Import Template CSV file if required.
Prerequisites
Ensure users who require existing mileage adding are set up as users.
General rules
The file format must be in .csv.
Column headers are required for data fields that need to be populated. Header names are space and case insensitive.
If the file does not contain the required data fields, the whole CSV file will be rejected.
If the file contains any extra headers not recognised, the whole CSV file will be rejected.
If existing mileage is found for a user with the same name and tax year, the existing mileage is updated.
If any data field on a record has an error, the record is skipped, and processing moves onto the next record.
The maximum number of records is 10,000 per CSV file import.
How to import existing mileage
To import your existing mileage, follow the steps below:
1. Click the Account Name > Admin.
2. In the Advanced section, click the Existing Mileage subheading.
3. Click the Add button and select Import Existing Mileage from the drop-down.
4. In the pop-up window, click Browse and select the CSV file containing the existing mileage data from your device.
5. Click Import.
Note: Always use Test Mode to ensure you're importing the data correctly. After your file has been tested, click the View Full Details in the File Processing Complete banner to view the Imported File Details results.
New records - number of new existing mileage records created.
Updated records - number of existing mileage records changed.
Skipped records - number of existing mileage records ignored from the file, use the feedback given for each skipped record to make corrections to the existing mileage records before importing the file again.
If an unexpected error occurs, please contact support@expensein.com for help.
6. Check the processed file email notification sent to you matches the import record totals.
7. Once you have successfully tested your existing mileage import, import your existing mileage with Test Mode disabled.
8. When your CSV file is imported, you'll receive a confirmation message on the page; your existing mileage records will now be added or updated.