Available as Core Payroll add-on for the following plans: HR Essential, HR Engaged, HR Elite
Available for the following users: Admin/Owner, users with Modify Opening balances permissions, users with Modify Employee Opening Balances permissions
Employment Hero allows you to manage UK payroll opening balances and year-to-date values directly from the HR platform. This helps ensure accurate payroll records, supports a smooth transition from previous payroll systems, and enables correct reporting for your UK employees.
This article explains how to:
- Export and import opening balances from file
- View and edit employee opening balances
- View year-to-date values for UK employees
- Further information
Export and import opening balances from file
This section covers how to export and import opening balances for all UK employees in your organisation, making it easier to audit or update records in bulk.
- Go to Settings > Opening Balances.
- If required, set the initial starting financial year for the business-level opening balances.
- To export opening balances, select the option to download the template. A file with all UK opening balance values for all employees will be downloaded. You can choose either CSV or XLSX format to download.
- To import opening balances, Click or Drag the file to the dedicated upload area then select Upload.
- External ID: Relates to an employee ID you may be using that comes from another external platform and is captured from the External Id field in the Employee's Details page.
- National Insurance Number: Captured from the Tax and NI Details option in the employee profile in the National Insurance Number field.
- Payroll Id: The Payroll ID is an identifier that you can give to an employee and you will send through to the HMRC. An employee's payroll ID will follow them between jobs, payroll software and even via their pension provider to identify them. For an employee being migrated over, you can enter the employee identifier from the old system.
- Employee Name: Captured from the employee's Preferred Name, Middle Name, and Surname fields in the employee's Details page.
- Total Hours: Only required if you want to add Total Hours worked in the initial financial year, up to the day before the period start date of the first pay run in this payroll system. Refer to the Earnings tab on the Opening Balances page of the employee's record.
- Gross Earnings: Total gross earnings paid in the initial financial year, up to the day before the first pay run in the EH payroll platform. This is displayed at the bottom of the Earnings tab on the opening balances page of the employee's record. You can just enter a total gross earnings figure in this column if you wish, but if you choose to enter amounts for specific pay categories, do not enter a total here. The platform will calculate the total of all of the Pay Category columns in the spreadsheet once imported and so will automatically calculate the total for this column.
- PAYE: The total PAYE deducted from gross earnings paid in the initial financial year, up to the day before the first pay run in the EH payroll platform. This field is displayed on the Pension and PAYE tab on the Opening Balances page of the employee's record.
- Student Loan: If there is a student loan, it will be in this column.
- Post Grad Loan Amount: If there is a post-grad loan amount, it will be in this column.
- Tax Relief Pension Amount: You would enter the tax relief pension amount in this column.
- Employer Pension Contribution Amount: You will add the employer's pension contribution amount in this column.
- Employee Pension Contribution Amount: You will add the employee pension contribution amount in this column.
The following column numbers will vary for each business and depend on the business setup, but the category orders are the same for everyone. They are as follows:
- Leave Categories: The next group of columns represents all the leave categories set up on your Leave Categories page in the Payroll Settings module. In the template they are labelled as LC; then a number which is the platform-generated ID code for the leave category; then the name of the leave category, example LC262968_Annual Leave. In these fields you will enter the employee's leave balance in the relevant unit type that the leave category has been configured to; for example, if the leave category has been set up with the unit type = days, then the balance entered must be in days. If the employee does not have a leave balance or the leave category is not set to accrue, then leave the figure as 0. You would enter negative leave balances as -12.65.
- Deduction Categories: The next group of columns represents each of the deduction categories set up in your Deduction Categories page in the Payroll Settings module. In the template they are labelled as DC, then a number which is the platform generated ID code for the deduction category, then the name of the deduction category, example DC141225_Member Voluntary Pension.
- Pay Categories: The next group of columns represents each of the pay categories set up in your Pay Categories page in the Payroll Settings module. In the template they are labelled as PC, then a number which is the platform generated ID code for the pay category, then the name of the pay category, for example PC959199_Ordinary Hours. In these fields, you will enter the employee's pay category breakdown as a sterling amount. You only need to enter amounts in these columns if required.
View and edit employee opening balances
This section explains how to view and update opening balances for a specific UK employee, ensuring their payroll records are correct for the first pay run.
- Open the profile of the individual employee whose opening balances you want to manage.
- Go to the Pay & compensation section, then select the Opening balances tab.
- Review the employee’s opening balances, which are grouped by categories such as Earnings, Deductions, PAYE/NI, Pension, and Leave balances.
- Expand each section to view opening balances or click Edit to open the respective opening balances form. Edit the employee’s opening balances as needed.
- Click Save to apply all the changes.
-
Leave balances
When entering leave balances, enter the balance as at the point of transition to this payroll platform (that is, as at the last pay run processed in your previous payroll platform). Partial units are entered as a decimal (e.g.: 6.5 hours) rather than as HH:MM (e.g.: 6:30). -
Earnings
Earnings are the year-to-date gross values for the financial year specified. If you need to change the Initial Financial Year, click the 'Opening Balances Settings' button at the top of the page. Earnings will be allocated to the employee's primary location (set via the employee's Pay Run defaults page) at the time the data has been entered. - Deductions
-
Employer liabilities
If you were previously recording employer liabilities in your previous payroll platform, you will be able to enter those year-to-date figures here. -
RTI/FPS
This tab displays the RTI/FPS Payroll ID, which is the employee identifier used when transmitting data to the ATO. By default, an employee's RTI/FPS Payroll ID is identical to their employee ID (i.e. the platform generated employee ID, as opposed to the External ID). The employee's RTI/FPS Payroll ID can be changed only if it meets the requirements of Scenario 2, Option 2 detailed in this transition article and the BMS ID of the employee's employing entity has changed. If there is no "Change" button in the employee's RTI/FPS Payroll ID field, then the BMS ID has not been changed and therefore there is no ability to change the employee's RTI/FPS Payroll ID. -
Importing opening balances
If you have many employees, you can bulk import their opening balances. To access the template spreadsheet, click on 'Opening Balances Settings' at the top of the page, then click 'Export'. -
Employment termination payments
If you are migrating terminated employees' data across to this payroll platform, you can include P45 data so that you only need to access one platform for reporting and P60 purposes. You are able to select the following P45 payments:- Type R - e.g. genuine redundancy, early retirement scheme, invalidity, compensation
- Type O - Other P45 payments not included in Type R
- Type S - where a Type R P45 was made in a previous financial year and another P45 is made in the financial year of the same termination
The same termination.
Take note of the field 'Generate P45 P60'. The default value is 'No' - if you leave this option as is, the employee's P45 P60 will not be published and so the employee will not have access to it. If you change the value to 'Yes', the employee's P45 P60 will automatically publish and they will be able to access this via their employee platform.
View year-to-date values for UK employees
This section shows you how to access and review year-to-date payroll values for UK employees, including detailed breakdowns for National Insurance and other categories.
- Open the profile of the UK employee whose year-to-date values you want to view.
- Go to the pay details section and select the year-to-date tab. The data shown is for the current tax year.
- Review the breakdowns for gross pay, statutory pay, tax, National Insurance (with separate tables for each NI category), pensions, deductions, and net pay.
- If a year-to-date section is disabled, hover over the tooltip to see the explanation. For example, if opening balances for the current financial year are missing, the tooltip will explain this requirement.