What’s covered in this guide?
Before you begin
Before importing pension data, ensure the following setup has already been completed:
pension providers
company files
payroll memberships
pay groups
employee assignments
pension eligibility setup
⚠️ Important: Incorrect pension setup before importing may result in:
incorrect enrolments
failed contribution submissions
duplicate employee records
employees syncing into the wrong pension scheme
Always confirm your pension configuration before importing memberships in bulk.
Export the pension import template
To download the pension import template:
Navigate to: Payroll > Payroll Settings > Import / Export
Download: Pension Provider Membership
This CSV file is used to create or update pension memberships for employees.
Configure employees manually first
Before importing all employees, we strongly recommend manually configuring a small number of employees first.
Recommended examples include:
one enrolled employee
one opted-out employee
one postponed employee
This helps confirm:
contribution rates
enrolment statuses
opt-out dates
Nest groups
payment sources
employee matching
⚠️ Important: Testing a small number of employees first can help identify formatting or syncing issues before importing all pension memberships.
Complete the pension import template
The Pension Provider Memberships template is used to create or update employee pension memberships in bulk.
The template may include fields such as:
pension provider
member number
pension group
payment source
employee contribution percentage
employer contribution percentage
enrolment status
postponement settings
reassessment dates
enrolment dates
opt-out dates
You may also see fields related to:
employee identifiers
worker classifications
automatic enrolment statuses
reassessment tracking
⚠️ Important: Some exported templates may not automatically populate contribution percentages.
Always confirm:
employee contribution percentages
employer contribution percentages
before uploading the import file.
We also recommend reviewing:
pension groups
payment sources
enrolment statuses
before completing a bulk import.
Import enrolled employees
To import enrolled employees:
Complete the pension template
Set the employee enrolment status correctly
Save the file as CSV
Upload the file through the Import / Export page
⚠️ Important: Employees who are eligible and correctly configured may then sync into the pension provider.
Import opted-out employees
When importing opted-out employees:
ensure the employee status is marked as opted out
include the correct opt-out date where possible
⚠️ Important: If no opt-out date is provided, Workforce may automatically use the import date instead.
Import postponed employees
Postponed employees can also be imported through the pension membership template.
Ensure:
postponement statuses are correct
postponement dates are accurate
employee memberships are assigned correctly
Once postponement ends:
Workforce reassesses employees during the next pay run and may enrol eligible employees at that point
Upload the import file
Once the template has been completed:
Save the file as CSV
Navigate to: Payroll > Import / Export
Upload the completed file
Review any validation errors
We recommend importing a small test group before uploading all employee memberships.
⚠️ Important: Initial pension syncs may take up to 20 minutes depending on the amount of data being processed.
Review imported pension memberships
After importing pension provider memberships, you can review the imported employee data within Workforce.
Go to:
Staff
Select the employee profile
Navigate to: Payroll > Pension
From here, you can review imported pension information including:
pension provider
member number
pension group
payment source
employee contribution percentage
employer contribution percentage
enrolment status
postponement settings
reassessment dates
enrolment dates
opt-out dates
Common import issues
Pension provider not appearing
This may occur if the provider sync has not completed yet.
Wait for the provider sync to finish and retry the import if required.
Contribution percentages missing
Some templates may not automatically populate contribution percentages.
Always enter:
employee contribution percentages
employer contribution percentages
before uploading the CSV file.
Employees are not syncing to Nest
Check:
employee identifiers
company file assignments
pension eligibility
Nest groups
payment schedules
Duplicate employee records
Duplicate records are commonly caused by:
mismatched NI numbers
changed payroll IDs
inconsistent employee names
Before importing, always verify:
employee names
NI numbers
payroll IDs
Import validation errors
Validation errors may occur if:
required fields are missing
enrolment statuses are invalid
contribution values are formatted incorrectly
company assignments are incomplete
Correct the errors in the CSV file before retrying the import.
Best practices for bulk enrolment
To reduce pension syncing and enrolment issues:
configure a small number of employees manually first
test different enrolment scenarios before bulk importing
confirm company file assignments before syncing
verify pension groups and schedules
confirm contribution percentages before upload
use consistent employee identifiers between systems