Skip to main content

Import company car data

Learn how to import your company car data.

J
Written by Jack
Updated over 2 weeks ago

If you need to add vehicles in bulk, we recommend using the import tool.

Note:

Prerequisites

  • Ensure the company car users are set up as users within the Admin area.

  • Set up or review each fuel rate your company cars need to be assigned to.

General rules

  • The file format must be .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 extra headers that are not recognised, the whole CSV file will be rejected.

  • If any data field on a record has an error, the record is skipped and processing moves to the next record.

  • The maximum number of records/vehicles is 10,000 per CSV file import.

  • Character limits include spaces.

How to import company cars

1. Click the Account Name > Admin.

2. In the User Management section, click the Company Cars subheading.

3. Click the Add button and select Import Vehicles from the drop-down.

4. In the pop-up window, click Browse and select the CSV file containing the company car 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 View Full Details in the File Processing Complete banner to view the Imported File Details results.

  • New records - number of new company cars created.

  • Skipped records - number of company cars ignored from the file, use the feedback given for each skipped record to make corrections to the company cars 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 company cars import, import your company cars with Test Mode disabled.

8. When your CSV file is imported, you'll receive a confirmation message on the page; your company cars will now be added.

Related Articles

Did this answer your question?