Return to BIK Module User Guides
This guide shows how to create several company benefits at once by uploading a CSV file. To create a single benefit on screen, see Setting Up a Company Benefit (Manual).
Before you start
- Check the guide for each benefit type in Supported Benefit Types & Event Types, as some benefit types have mandatory settings. You can also copy the exact HMRC Benefit Type and Event Type names from that guide into your file, to avoid spelling errors.
- HMRC Benefit Type and Event Type can’t be changed once a benefit has been processed through payroll.
- The Default Stop Date for Leavers can be changed, but the new setting only applies to employees who leave after the change.
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 Company Benefit 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 nine columns, A to I, with one row per company benefit. Every row is checked when you upload, and any that fail show a message explaining why. See the appendix for every message and what it means.
| Column | Field | Mandatory? | What to enter | Validation |
|---|---|---|---|---|
| A | Company Name | Yes | The company the benefit is for. | The company must already exist, and be spelt exactly as it appears in the portal. |
| B | HMRC Benefit Type | Yes | The HMRC Benefit Type. | Must be spelt exactly as it appears in the system. |
| C | Event Type | Yes | The Event Type. | Must be spelt exactly as it appears in the system, and be valid for the HMRC Benefit Type in column B. |
| D | Benefit Name | Yes | Your company’s name for the benefit, such as “Health Plan”. | Must be unique within the company, both in your file and in the portal. The same name can be used in different companies. |
| E | Set Default Amount | Yes | Yes to set a default amount, or No if not. | Yes, No, Y, N, true, false, 1 or 0. Must be a No value (No, N, false or 0) for Company Car & Car Fuel and Van & Van Fuel. |
| F | Default Amount | If E is Yes | The default value, such as 600.00. | A number with up to two decimal places. Must be left blank for Company Car & Car Fuel and Van & Van Fuel. |
| G | Default Stop Date For Leavers | No | One of the three leaver options below. | Must match one option exactly, or use its number. If blank, defaults to Never Retain Benefit. |
| H | Days | If G is option 3 | How many days the benefit continues after an employee leaves. | A whole number of 0 or more. Must be left blank for the other leaver options. |
| I | Notes | No | Any extra information about the benefit. | None. Free text. |
Using a default amount (columns E and F)
If you set a default amount, it’s filled in automatically whenever the benefit is added to an employee’s record, saving time when many employees receive the same benefit. It can still be changed on an individual employee’s record.
Leaver options (column G)
Enter the option exactly as shown, or its number. Note that the wording differs slightly from the labels on screen.
| Enter exactly | Or | What happens when an employee leaves |
|---|---|---|
| Never Retain Benefit | 1 | The benefit ends on their leaving date. |
| Retain the benefit to the end of the tax year | 2 | The benefit continues until 5 April, whatever their leaving date. |
| Retain the benefit X Number of Days after | 3 | The benefit continues for the number of days in column H, up to the end of the tax year. |
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 Company Benefit 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 created, and now appear in the company’s benefits list.
- Failed rows show a message explaining exactly what’s wrong, such as a misspelt company name or benefit type. 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 their benefit names 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 in the module, or if you’re working through a large file with several errors.
If an error message isn’t clear, contact the Payroll Bureau (if you use the BIK service) or the Support team.
Viewing your imported benefits
Go to BIK > Administration > Company Benefits and select the company. Your imported benefits now appear in the list, ready to apply to employees.
Deleting a company benefit
Benefits created by import are deleted on screen, in the same way as any other benefit.
A company benefit can only be deleted if it hasn’t been processed through payroll.
- Go to BIK > Administration > Company Benefits and select the company.
- Select the benefit, then select Delete.
- In the pop-up, select OK to delete the benefit, or Cancel to keep it.
Appendix: Company benefit 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.
| Error message | What it means | Column |
|---|---|---|
| Duplicates | ||
| Only 1 record with the same Company Name and Benefit Name is allowed. | The same company and benefit name appear together more than once in your file. Remove the duplicate rows. | A and D |
| Benefit Name already exists for this company. | The company already has a benefit with this name. Choose a different name, or remove the row. | D |
| Company, benefit type and event type | ||
| Company Name is required. | Column A is empty. | A |
| Company Name does not Exist. | The company wasn’t found. Check it’s spelt exactly as it appears in the portal. | A |
| HMRC Benefit Type is required. | Column B is empty. | B |
| HMRC Benefit Type does not exist. | The benefit type wasn’t recognised. Copy it exactly from the Supported Benefit Types & Event Types guide. | B |
| Event Type is required. | Column C is empty. | C |
| Event Type does not exist. | The event type wasn’t recognised, or isn’t valid for the benefit type in column B. | C |
| Benefit Name is required. | Column D is empty. | D |
| Default amount | ||
| Set Default Amount is required and must be Yes, No, Y, N, true, false, 1, or 0. | Column E is empty. | E |
| Set Default Amount must be Yes, No, Y, N, true, false, 1, or 0. | Column E contains a value that isn’t accepted. Use Yes or No. | E |
| When Set Default Amount is Yes, Default Amount is required. | Column E is Yes, but column F is empty. | F |
| Default Amount must be limited to 2 decimal places. | The default amount has more than two decimal places. | F |
| Set Default Amount is required and must be No, N, false, or 0 for Car and Van Benefit Types. | Column E is empty for a Company Car & Car Fuel or Van & Van Fuel benefit. Enter No. | E |
| Set Default Amount must be no, n, false or 0 for Company Car & Car Fuel or Van & Van Fuel benefits. | Column E isn’t No for a car or van benefit. Their values come from the vehicle record, so enter No. | E |
| Default Amount must be blank for Company Car & Car Fuel or Van & Van Fuel benefits. | Column F has a value for a car or van benefit. Leave it blank. | F |
| Leavers | ||
| Default Stop Date For Leavers must be one of the following values: Never Retain Benefit, 1, Retain the benefit to the end of the tax year, 2, Retain the benefit X Number of Days after, 3 | Column G doesn’t match one of the accepted options. Use the exact wording or the number. | G |
| Stop Delay Days is required when Default Stop Date For Leavers is ‘Retain the benefit X Number of Days after’. | Column G is option 3, but column H is empty. | H |
| Stop Delay Days must be greater than or equal to zero. | The number of days in column H is negative. | H |
| Stop Delay Days should be blank unless Default Stop Date For Leavers is ‘Retain the benefit X Number of Days after’. | Column H has a value, but column G isn’t option 3. Leave it blank. | H |
Related guides
- Configuring Company Benefits (overview)
- Setting Up a Company Benefit (Manual)
- Configuring Benefit Groups
- Supported Benefit Types & Event Types
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.