What should my input file look like?
The application requires a CSV (Comma Separated Value) file. To run a report there are certain columns that are required.
Mandatory Columns
• First Registered Date – Date Format (yyyymmdd – e.g. 20171101)
• Agreement Start Date- Date Format (yyyymmdd – e.g. 20171101)
• Agreement Start Mileage
• Agreement End Date- Date Format (yyyymmdd – e.g. 20171101)
• Agreement Estimated Total Mileage
• CapCode, Cap ID, VRM or VIN
• VehicleType – (Car, Bike, LCV, HGV). This is mandatory when identifying the vehicle by CapCode or Cap Id)
Optional Columns
• CapCode (either CapCode, Cap ID, VRM or VIN is mandatory)
• Cap ID (either CapCode, Cap ID, VRM or VIN is mandatory)
• VRM (either CapCode, Cap ID, VRM or VIN is mandatory) *
• VIN (either CapCode, Cap ID, VRM or VIN is mandatory) *
• Current Mileage
• Sold Price
• Sold Mileage
• Sold Date – Date Format (yyyymmdd – e.g. 20171101)
• User Residual Value
• Excess Mileage Charge
The optional “Current Mileage” column will allow the user to specify the mileage of the vehicle as it is today. If this is missing, we estimate the mileage based on the “Agreement Start Date”, “Agreement End Date”, “Agreement Start Mileage” and “Agreement Estimated Total Mileage”.
*VRM and VIN look-ups are only available for cars and LCVs if you subscribe to the appropriate additional elements.
Once you have a file in the format as above, you will be able to add data and submit it to create a report.
Please see the Report Template document for required columns for other reports.