Thank you for your feedback.

Was this useful?

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

Article ID
Article Name
Creating the NSR03 File for Scottish Public Pensions Agency (SPPA)
Created Date
6th April 2018
IRIS GP Payroll

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


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
  • 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.
  • A message confirms the location where the file will be created. If you are happy with the location click ‘OK
  • The screen confirms the CSV file has been created and saved in the specified location. Click ‘Next
  • Finally, you need to upload your CSV file to the SPPA EDM data submission portal.

For further details on the EDM portal please contact the SPPA:

Thank you for your feedback.

Was this useful?