Import Benefits

Matt Jennings Updated by Matt Jennings

Support has been added to be able to import certain benefit types against employees. A prerequisite to be able to do this is that the benefit type has already been created. The benefit types that are supported are Cars and car fuel, vans and van fuel and Private medical treatment or insurance.

Once all the relevant benefit types have been created, you are now ready to import the individual benefits against employees.

This can be done by selecting in the desktop system - System>Import functions>Import employee benefits

From here you will select the file to be imported, which benefit type you are importing, and which tax year it is for. There are also checkboxes to add the values in for each pay period, or delete existing benefits for all employees when importing in.

The format for Private medical benefits imports is as follows:

PayRef, Description, Start date, End date, Override (Y N), 1st std value, 2nd std value, Date of change, Amount made good, Benefit t/d, Employee payment t/d, Benefit for class 1A t/d, Amount taxed t/d
01000047, Medical Insurance, 01/04/2025, , N, , , , , , , , 
01000053, Bupa Medical Insurance, 01/04/2025, , Y, 2000, 2300, 15/08/2025, , , , , 
01000057, Medical Ins., 01/04/2025, , N, , , , 500, , , , 
01000063, Medical Insurance, 01/04/2025, , N, , , , 1000.50, 200, 300, 200, 200

There are two formats for cars or vans benefits imports. One simply has 5 columns and can be used for entering a simple car benefit:

PayRef, Description, Start date, End date, Registration number
01000047, Car Benefit, 06/04/2026, , AA123ABC
01000053, Car Benefit, 06/04/2026, , AB234ABC
01000057, Car Benefit, 06/04/2026, , AD345ABC
01000063, Car Benefit, 06/04/2026, , AE456ABC

The second contains more data if a more complex entry is required whereby you can import against any field within the benefit type:

PayRef, Description, Start date, End date, Registration number, Fuel supplied (Y N), Fuel paid in full (Y N), Fuel start date, Fuel end date, Fuel reinstated (Y N), Sharing reduction, Days unavailable, Days fuel unavailable, Capital contribution, Payment for private use, Override salary sacrifice (Y N), Salary sacrifice, P46(Car) start sent (Y N), P46(Car) end sent (Y N), Benefit t/d, Capital contributions t/d, Payments for private use t/d, Value for class 1A t/d, Value taxed t/d
01000047, Car Benefit, 06/04/2026, , AA123CAR, N, N, , , N, , , , , , N, , Y, N, , , , ,

Was this article useful?

Copy Companies

Adding a New Pay Element

Contact