Knowledge Base Getting Started Frequently Asked Questions

How to bulk import mileage claims

This article explains how to upload a group of mileage claims into FreeAgent.

If you don’t want to create each individual mileage claim manually, you can bulk upload several mileage claims at once.

Navigate to 'My Money' and select 'Expenses'

Select 'My Money' and navigate to 'Expenses'.

KB-Ex-GS-BIM-01-Final.png

Next, select the 'Import Expenses' button at the top right of the screen.

KB-Ex-GS-BIM-02-Final.png

Select the 'Mileage' tab, and you'll now be prompted to download our 'Mileage template'.

KB-Ex-GS-BIM-03-Final.png

How to fill in our mileage template

The table below shows you how to fill in the template.

Column Name What to enter Example Required?
claimant_name The full name of the FreeAgent user the mileage claim is for. This is case sensitive and must match exactly with the user's name in FreeAgent. Nathan Barley Yes
DD/MM/YYYY

The date of the mileage claim.

This must be in DD/MM/YYYY format, regardless of the date format in your FreeAgent account.

25/08/2019 Yes
description A description of the mileage being claimed. Travel to a client's office Yes
mileage The number of miles travelled. 83 Yes
vehicle_type Enter the type of vehicle you travelled in. This can be one of "Car", "Motorcycle" or "Bicycle". Car Yes
engine_type If the vehicle you travelled in was a car, enter the engine type. This can be one of "Petrol", "Diesel", "LPG" or "Electric". Petrol This is required if vehicle_type is Car.
engine_size

If the vehicle you travelled in was a car, you need to supply the engine size.

If you selected "Petrol" or "LPG" for engine type above, enter one of "Up to 1400cc", "1401-2000cc" or "Over 2000cc".

If you selected "Diesel" for engine type above, enter one of "Up to 1600cc", "1601-2000cc" or "Over 2000cc".

If you selected "Electric" above, enter the value "All".

1401-2000cc This is required if vehicle_type is Car.
reclaim_mileage If you wish to reclaim this mileage at the Approved Mileage Allowance Payments (AMAP) rate, enter 1. If you do not wish to reclaim this mileage, enter 0. 1 If blank, this will not be reclaimed.
project_client The name of the FreeAgent contact this mileage claim is for. This is case sensitive and must match exactly with the contact's name in FreeAgent. Fez Consulting Ltd

If blank, no project will be assigned to the mileage claim.

If you want to link this mileage claim to a project, you must enter both project_client and project_name.

project_name The name of the project this mileage claim is for. This is case sensitive and must match exactly with the project's name in FreeAgent. Business Strategy

If blank, no project will be assigned to the mileage claim.

If you want to link this mileage claim to a project, you must enter both project_client and project_name.

rebill_to_project If you want to rebill this mileage claim to your contact, enter "True". If you don't want to rebill this mileage claim, leave this blank. True

To rebill a mileage claim, project_client and project_name must be entered above.

If blank, this mileage claim won't be rebilled.

rebill_mileage_
rate
If you're rebilling this mileage claim to your contact, enter the value per mile (plus VAT) that you wish to rebill.

 30

This is required if you've opted to rebill_to_project above.
have_vat_
receipt
If you wish to reclaim VAT on this mileage claim and you have a VAT receipt, enter "True". If you don't, leave this blank.  True If blank, we will not reclaim VAT.

Upload the template

Select the CSV file you want to import and then select ‘Upload’.

KB-Ex-GS-BIM-04-Final.png

Review the imported mileage claims

Once the upload is complete, you'll be prompted to review your newly added mileage claims. If you realise that you've made an error, or want to remove the most recent mileage, just select the 'Undo Last Import' button. 

KB-Ex-GS-BIM-05-Final.png

That's it!

Did you find this article useful?