Use the Import/Export menu to update many employees at once from a file, and to download employee and pension data.
Get the most out of Bob
- Bulk import updated tax codes, pensions, student loans, annual salaries, work patterns, recurring pay items, and company car pay items.
- Download a CSV pension report.
- Export your employee data to a CSV.
Before you begin
- Prepare your file. For imports, you can use an XLSX, XLS, or CSV file. Where it's available, you can also enter data manually instead of uploading a file.
- Include the Employee ID. Employee ID is a mandatory column for tax code, pension, and student loan imports. If the ID in your file doesn't match the ID in UK Payroll, the record may fail to update.
- Use consistent headings. If you use your own column headings, UK Payroll tries to match them to its fields, so choose headings that are similar to the field names.
- Format dates correctly. Where a date is needed, use DD/MM/YYYY or YYYY/MM/DD, with the numbers separated by forward slashes (/).
- Check your HMRC connection. If you've set up automatic HMRC updates, tax codes and new student loans are updated for you. Bulk import is for when you haven't set this up, or need to make changes yourself.
How to open the Import/Export menu
- From the left side bar, click Employees.
- In the top right corner, click Import/Export.
- Select the action you want.
Import actions
Import tax codes: Bulk update tax codes manually or from a file.
Note: Required headings are Employee ID, Tax Code, W1/M1 (non-cumulative). To review tax code updates received from HMRC, go to HMRC Documents in UK Payroll.
Import pensions: Update multiple employee pension records at once. This is useful if you're switching pension providers or changing from one pension type to another.
Note: Required headings are Employee ID, Is this a new enrolment?, Is eligible for tax relief?, Pension provider, Groups, Pension type, Enrolment status, Start date, Leave date, Opt-out date, Deferral date, EE contribution amount, EE contribution unit, ER contribution amount, ER contribution unit, and Skip sending enrolment. If an employee's enrolment status is Opted out, an opt-out date is also required.
- Import student loans: Update multiple student loan records at once. If you've connected UK Payroll with HMRC, new loans for existing employees are updated automatically when the Start Notice (SL1) is received, so you only need this for updates you're making yourself.
Import annual salaries: Bulk update employees' annual salaries, for example after a pay review.
Note: If you're uploading a pre-populated file, it needs these headings: Employee ID, Amount (£), Unit, and Effective date. Once you confirm the import, the updated salaries appear in employee profiles. Make sure the effective date is correct so the new salary is used in the right pay cycle.
For columns that require specific formatting, refer to the manual data entry section. Hover over (i), the information icon in the column headings, to see a list of accepted values. For columns that have multiple options, select the dropdown within a column's cell to see a list of accepted values.- Import work patterns: Bulk update employees' work patterns from a file.
Import recurring pay items: Add recurring pay items, such as private health or loan scheme deductions, for multiple employees at once. Set up the recurring pay item first. A bulk import can only add pay items that already exist in UK Payroll.
Note: Required headings are Employee ID, Type, Title, Pensionable, and Amount.
Bulk update benefits in kind: If you need to update the cash value of existing payrolled Benefits in Kind (BiKs) for multiple employees (for example, annual benefit value changes).
Note: The Starting from date is used to calculate the annual cash value shown on the employee’s Benefits in Kind pay item (based on the number of pay periods remaining in the current tax year). It doesn’t control when the updated value appears in payroll. Additionally, the value only impacts the current draft payroll.
- Import company car pay items: Add company car and fuel benefits for multiple employees at once.
- Import holiday pay schemes
- Import sick pay policies
If you need to process work hours for multiple employees, you can import the hours/units as a XLSX, XLS, or CSV file.
Note: Employee ID is a mandatory column for manual entry and file upload.
- From the left side bar, select Payrolls.
- Select the current payroll draft.
- Click Actions > relevant import function.
- Click Select file to use the file navigator, or drag and drop your file into the screen.
- Select the correct header row.
- Once headers are confirmed, the column headings will begin matching automatically, which you can confirm by clicking Confirm mapping. If you have any columns that are unable to be matched, select the correct option from the dropdown menu.
To quickly validate the data, toggle on Show only rows with errors. You can then validate the data at the row or cell level.
Note: Rows with errors will be ignored.
- If you are ready to submit, click Yes.
Tip: If you choose to use your own headings, UK Payroll will automatically try to match your headings, so try to choose similar or easily identifiable headings.
Download and export actions
- Download pension report: Download a CSV pension report for your employees. To learn more, see Pension duties.
- Export employee data: To download all employee data, mark Export all data. Your employee data downloads as a CSV file.
How to download P45s
- From the left sidebar, select Employees.
- Select the relevant employee.
- Click on Actions in the top right corner.
- To download a terminating employee's P45, select Download P45 (draft). The P45 will include a draft watermark.
- To download a terminated employee's P45, select Download P45.
FAQs
What file types can I upload?
XLSX, XLS, and CSV.
How should I format dates?
Use DD/MM/YYYY or YYYY/MM/DD, with the numbers separated by forward slashes (/).
What happens if my file contains multiple sheets?
You're asked to select the correct sheet before continuing.
Why didn't an employee's record update?
The most common cause is an Employee ID in your file that doesn't match the one in UK Payroll. Check the ID and try again.
Will imported changes apply to the current payroll?
Changes can only affect the current payroll if they're made before it's confirmed. Check effective dates carefully.