Creating the NSR03 File for Scottish Public Pensions Agency (SPPA)

Article ID

11885

Article Name

Created Date

6th April 2018

Product

IRIS GP Payroll

Problem

This KB article will cover the steps to follow to create an NSR03 CSV file and email that to the SPPA.

Resolution

Superannuation Number (SB)

All employees must have an SB number before the NSR03 can be produced. If you don’t know the SB number, you should contact SPPA. If you can’t obtain the SB number in time, you could use the temporary one of ‘0000000’.

To enter the SB number, from the main payroll screen, click ‘Change Employee Details’ button, select the employee from the dropdown field and click the ‘Pension Details’ button.

Create NSR03 file:

From the main payroll screen, click ‘End of Year’ button. On the End-of-Year Facilities screen, select ‘Step 4 – Produce End-of-Year Pension statements’ and then click ‘OK’. Next on the End of year options – Scottish Pension Agency screen, select ‘Prepare an End of Year NSR03 file for transmission to the SPPA in CSV format’.

NSR03 Wizard

There will be a wizard that guides you through the process of creating the CSV file.

On the first wizard screen, click ‘Next‘
On the Employee – “Type of Employment” screen, click ‘Next‘

Employee type of employment NSR03 wizard

On the next Employee “Type of Employment” screen, you need to manually set the Group Type Number for any Practice Nurses to ‘6’. Then click ‘Next’

resizedimage275176 GP EOY NSR03 1 | Creating the NSR03 File for Scottish Public Pensions Agency (SPPA)

The folder (or directory) in which this file will be created field will default to your payroll folder, for example C:\payroll. You can choose to save the file in a different location by clicking ‘Browse to change’ button. Click ‘Next’ to create the file.