Using Vehicle Stock Monitor

If you have any queries regarding any of the points listed on this page, please contact your Experian account manager for clarification.

Creating the input file

Uploading the input file

Processing the input file

Creating the input file

Ensure that your spreadsheet for upload has the correct information. Displayed to the side is an example with all possible entry data, but it is unlikely you will need to enter all this information. If in doubt, consult your Experian account manager.

Sample Excel Input With Header
  • VRM. This does not necessarily have to be supplied if the VIN is present in Column B for this vehicle look-up.
  • VIN. This does not necessarily have to be supplied if the VRM is present in Column A for this vehicle look-up.
  • Mileage. If mileage data is required, then this must be entered in order to comply with due diligence. Input mileage can be used to provide more accurate valuation data, the system may be able to automatically adjust valuations based on the data supplied.
  • Process. This defines whether the particular vehicle should be processed. Any data in this column will automatically enable this feature so if you want to process all vehicles then ensure either all entries in the column are blank, or every vehicle has yes in this field.
  • Input Value. This is used as a reference field in conjunction with Vehicle Value Audit being enabled. If you have not been told to use this field then simply ignore it and don't place anything in this column.
  • Location. This is used as a reference field in conjunction with Vehicle Value Audit being enabled. If you have not been told to use this field then simply ignore it and don't place anything in this column.

There are two different ways to create the spreadsheet:

Sample Excel Input With No Header
  • Header row present. If you wish to include a header row in your input file, please ensure that cell A1 contains only the word VRM. This is how the system determines you are not attempting to request this row as a vehicle.
  • Header row not present. The first row will simply be a normal vehicle request (as shown in the screenshot to the side).
When saving the spreadsheet, ensure it is in an Excel 97 compatible format and that the data is present in the first worksheet. Also check that your data starts in Column A and at Row 1 or 2 (see above for where to start) to ensure that it is processed correctly. If creating the spreadsheet on a PDA, please ensure it is not in Pocket Excel format as this will be rejected by the system.
Uploading the input file
File upload dialog - note that the appearance of this popup may vary depending on your operating system

Click the Browse button on the main screen to bring up a window to select the file for processing. Either double-click the filename to select it, or click the filename once then select Open. Click Upload file to add this file to the pending list for your account held on the server.

upload Restrictions

Before processing this file, take a moment to look at the left hand side of the window (just below the Logout option) and you should see that there are two values listed. These are the minimum and maximum vehicles that can be accepted in a single file on your account.

If the file uploaded contains more, or less, vehicles than the values indicated on the left hand side your file will be rejected and will not be processed by the system.

If this happens, the file will return in the Uploaded Files list at the top of your main screen. If you need to process (for example) 8,000 vehicles then the easiest way to do this would be to break the file into two even sized uploads of 4,000 vehicles. Upload the first, let it process, then return later to pick up the first output file and begin processing the second.

It's worth noting that the processing does not stop if you log out of the system and return later, it will continue regardless. You may however only process one file at a time on your account.
Processing the input file

After uploading, your file will now be present in the list at the top of the window. If this particular file was uploaded in error, then simply select Delete to remove it. If you don't need to process this file immediately it may be left there indefinitely.

upload Process

There are three stages to the process. The first is to take the Excel file and ensure it's valid and ready to pass to the mainframe for input. The first check performed is to whether this contains a valid selection of input data (see previous sections regarding creating a valid input file) otherwise it will be rejected before processing takes place.

upload Process

After the initial input validation and parsing is complete, each VRM is processed sequentially (you will see an indication of progress next to the file name as it is being processed). Depending on the number of vehicles in your file, processing could take a little time. You do not need to stay logged in - the file will continue processing until complete and will then appear in your "available for download" list.

upload Process

Select Download to receive this file, or Delete if you no longer require this output. Please remember that selecting Delete is a permanent action and your file cannot be retrieved once this has been selected!

The filename generated is comprised of the original filename and also the datestamp of when processing was completed. In the example above our original file input name was test.xls and it was processed on 9th August 2007 at 15:58. The file can be left on the download list indefinitely and it is not automatically deleted after a period of time. This allows you to access it from multiple locations if required.

upload Process