Return to BIK Module User Guides
This guide shows how to add several vans to your vehicle register at once by uploading a CSV file. To add a single van on screen, see Setting Up a Vehicle Record (Manual) (Van). For cars, see Setting Up Vehicle Records (Data Imports) (Car).
Before you start
- Cars and vans use the same template. For vans, only Vehicle Type, Registration, Make, Model and Fuel Type are mandatory. Van benefits are a flat amount set by HMRC, so details such as list price and CO2 emissions don’t affect the calculation.
- Optional columns can be left blank. If you do fill them in, the usual validations still apply.
- Each registration can only be added once. Van vehicles can be assigned to multiple employees at once (Shared Vans).
Interactive demo
Finding the demo a bit small? Open it in full screen for a closer look.
Downloading the template
- Go to BIK > Administration > Data Imports.
- Select Vehicle Record Upload as the upload type.
- Select Download CSV Template and open it in Excel.
We recommend downloading a fresh template each time, rather than reusing a saved copy. That way, you’ll always have the latest version, including any changes to the columns or rules.
Completing the template
The template has 15 columns, A to O, with one row per vehicle. For vans, only Vehicle Type, Registration, Make, Model and Fuel Type are mandatory. The other columns can be left blank, or completed if you’d like, in which case the usual validations apply.
| Column | Field | Mandatory for vans? | What to enter |
|---|---|---|---|
| A | Vehicle Type | Yes | Van. |
| B | Inactive | No | No for vans in use, or Yes if no longer in use. Y, N, true and false are also accepted. |
| C | Vehicle Registration Number | Yes | 4 to 7 capital letters and numbers, with no spaces or special characters. Each registration can only appear once in the file, and can’t already exist in your register. |
| D | Vehicle Make | Yes | The manufacturer, such as Ford. Letters, numbers and spaces only, with no special characters. |
| E | Vehicle Model | Yes | The model name, such as Transit Custom. Letters, numbers and spaces only, with no special characters. |
| F | Date First Registered | No | If entered, as DD/MM/YYYY. Can’t be a future date. |
| G and H | List Price and Accessories Price | No | If entered, a positive number with up to two decimal places, and no £ signs, commas or spaces. |
| I and J | Engine Capacity and Co2 Emissions | No | If entered, a positive whole number. |
| K | Fuel Type | Yes | Petrol, Diesel, Hybrid or Electric. This matters for vans, as zero-emission vans are treated differently for tax. |
| L | Euro Status | No | Leave blank for vans. It only applies to diesel cars. |
| M | Electric Range | No | If entered, a positive whole number. Leave blank for petrol and diesel vans. |
| N and O | Vehicle Colour and Notes | No | Any details that help identify the van, such as its colour or leasing provider. |
When you’ve finished, save the file as a CSV. Saving it as an Excel workbook (.xlsx) will cause the upload to fail.
Uploading the file
- Go back to BIK > Administration > Data Imports and select Vehicle Record Upload as the upload type.
- Select Choose File and pick your saved CSV file.
- Under If Validation Errors Occur, choose how the upload should behave if any rows fail:
- Cancel Upload: if even one row has an error, nothing is uploaded.
- Continue with Upload: all valid rows are uploaded, and only the rows with errors are skipped.
- Select Upload. The button changes to Uploading... while your file is processed. This is normal, so there’s no need to select it again or refresh the page.
Checking the results
Once your file has been processed, the results appear in a grid at the bottom of the page, showing each row from your file.
- Successful rows have been added to your vehicle register.
- Failed rows show a message explaining exactly what’s wrong. See the appendix for every message and how to fix it.
Correcting errors
Correct the failed rows in your CSV file and upload it again. Which rows to include depends on the option you chose:
| If you chose | When you upload again |
|---|---|
| Cancel Upload | Include every row, as nothing was uploaded. |
| Continue with Upload | Include only the failed rows. Rows that already loaded will fail if uploaded again, as those registrations now exist. |
We recommend exporting the results to Excel (XLSX) or CSV before leaving the page, as they won’t stay on screen. This is especially useful if you need to fix errors manually, or if you’re working through a large fleet.
If an error message isn’t clear, contact the Payroll Bureau (if you use the BIK service) or the Support team.
Viewing your imported vans
Go to BIK > Administration > Vehicle Management. Your imported vans now appear in the register, with Van shown as their type, ready to be assigned to employee van benefits.
Deleting a van record
Imported vans are deleted on screen, in the same way as any other vehicle.
A van can only be deleted if it hasn’t been assigned or processed through payroll on a van benefit.
- Go to BIK > Administration > Vehicle Management.
- Select the van, then select Delete.
- In the pop-up, select OK to delete the van, or Cancel to keep it.
Appendix: Vehicle import error messages
If a row fails to upload, the results grid shows one of the messages below. Find the message, correct the row in your CSV file and upload it again. Messages marked “Cars” don’t apply to vans.
| Error message | What it means | Applies to |
|---|---|---|
| Duplicates | ||
| Only 1 record with the same Vehicle Registration Number is allowed. | The same registration appears more than once in your file. Remove the duplicate rows. | Cars and vans |
| Vehicle Registration Number already exists. | A vehicle with this registration is already in your register. Remove the row, or edit the existing vehicle on screen instead. | Cars and vans |
| Vehicle Type and Inactive | ||
| Vehicle Type is required. | Column A is empty. | Cars and vans |
| Vehicle Type must be Car or Van. | Column A contains something other than Car or Van. | Cars and vans |
| InActive must be Yes, No, Y, N, true, or false. | Column B contains a value that isn’t accepted. Use Yes or No. | Cars and vans |
| Registration, make and model | ||
| Vehicle Registration Number is required. | Column C is empty. | Cars and vans |
| Vehicle Registration Number must be between 4 and 7 characters. | The registration is too short or too long. | Cars and vans |
| Vehicle Registration Number must be uppercase alphanumeric characters only, with no spaces or special characters. | The registration has lowercase letters, spaces or symbols. For example, use TE26VN1, not te26 vn1. | Cars and vans |
| Vehicle Make is required. | Column D is empty. | Cars and vans |
| Vehicle Model is required. | Column E is empty. | Cars and vans |
| Vehicle Model must be alphanumeric characters only, spaces allowed but no special characters. | The make or model contains symbols, such as a hyphen or slash. Letters, numbers and spaces are fine. | Cars and vans |
| Prices and dates | ||
| List Price is required. | Column G is empty for a car. | Cars |
| List Price must be a positive number. | The list price is negative. | Cars and vans |
| List Price must be limited to 2 decimal places. | The list price has more than two decimal places. | Cars and vans |
| Accessories Price must be a positive number. | The accessories price is negative. | Cars and vans |
| Accessories Price must be limited to 2 decimal places. | The accessories price has more than two decimal places. | Cars and vans |
| Date First Registered is required. | Column F is empty for a car. | Cars |
| Date First Registered cannot be a future date. | The date is after today. | Cars and vans |
| Fuel and emissions | ||
| Fuel Type is required | Column K is empty. | Cars and vans |
| Fuel Type must be Petrol, Diesel, Hybrid or Electric. | Column K contains another value. | Cars and vans |
| Engine Capacity is required when Vehicle Type is Car and Fuel Type is not Electric. | Column I is empty for a petrol, diesel or hybrid car. | Cars |
| Engine Capacity must be a positive whole number. | The engine capacity is negative. | Cars and vans |
| CO2 Emissions is required when Vehicle Type is Car and Fuel Type is not Electric. | Column J is empty for a petrol, diesel or hybrid car. | Cars |
| CO2 Emissions must be a positive whole number. | The CO2 figure is negative. | Cars and vans |
| Euro Status is required when Vehicle Type is Car and Fuel Type is Diesel. | Column L is empty for a diesel car. | Diesel cars |
| Euro Status must be Yes, No, Y, N, true, or false. | Column L contains a value that isn’t accepted. Use Yes or No. | Diesel cars |
| Euro Status should be empty unless Vehicle Type is Car and Fuel Type is Diesel. | Column L has a value, but the vehicle isn’t a diesel car, including any van. Leave it blank. | Cars and vans |
| Electric Range is required when Fuel Type is Hybrid or Electric. | Column M is empty for a hybrid or electric car. | Hybrid and electric cars |
| Electric Range must be a positive whole number. | The electric range is negative. | Cars and vans |
| Electric Range should be empty unless Fuel Type is Electric/Hybrid and Vehicle Type is Car. | Column M has a value for a petrol or diesel vehicle. Leave it blank. | Cars and vans |
Related guides
- Vehicle Management (overview)
- Setting Up a Vehicle Record (Manual) (Van)
- Setting Up Vehicle Records (Data Imports) (Car)
- Company Vans & Van Fuel
- Benefit Statutory Information
Return to BIK Module User Guides
The information provided herein is for informational purposes only. It does not constitute legal, tax, accounting, or other professional advice. It describes functionality and configuration options available within Fourth’s solutions and services. The appropriate settings for your organisation will depend on your specific circumstances and requirements, and Customers remain solely responsible for all decisions relating to the configuration and usage of Fourth’s solutions and services. The information reflects Fourth’s understanding of applicable laws and regulations at the time of publication and may not reflect subsequent changes. Customers should seek independent professional advice regarding their specific compliance requirements.
Comments
Please sign in to leave a comment.