Setting up a Penfold Pension in Sage 50 Payroll

👉 Tip: You'll need the 'Provider reference,' a unique code assigned by Penfold to each employer. Typically, it starts with PEN followed by your Company Number, and is also known as EmployerID. You can find it on the dashboard 👇

To create a new pension in Sage 50 Payroll, go to the Company menu and select Pensions. You can select an existing scheme to edit, or click the “New” button to create a new one.

Here are the key pieces of information you need to set up your Penfold Pension:

Details	Description - Penfold Pension Type - Other (select Other, as GPP restricts some functionality you may need) Qualifying Scheme - Yes Qualifying Earnings - Optional - if ticked contributions will be calculated ONLY on earnings between £6,240 and £50,270 Salary Sacrifice Scheme - Optional - only tick if employees have entered into a Salary Sacrifice arrangement for this scheme
Employee	Contribution - enter the minimum Percentage rate that employees contribute to the scheme Deduct before tax - Penfold is a Relief at Source (RAS) scheme, so contributions are deducted AFTER tax and this should be UNTICKED
Employer	Contribution - enter the minimum Percentage rate that the company contributes to the scheme
Provider	Provider's Reference - a unique code assigned by Penfold to the employer. Typically, it starts with PEN followed by your Company Number, and is also known as EmployerID.

This guide picks out the fields that you need to use to set up Penfold correctly. Sage’s own guidance including a full list of all fields and a demo video is available here.

How do I set Sage 50 up to produce the right data?

👉 Tip: Ask Sage to install the AE Report PAPDIS v1 for you. You'll need to use the Sage 50 Auto Enrolment Module to get this report.

Once you are set up, each pay period, simply go to reports, select AE Report PAPDIS v1 and input the pay period you want to export a file for.

👉 Tip: Export the report to XLS format and then save it as a CSV ready for upload. Exporting directly to CSV results in the header row being missed off, which will cause an error when uploading.

If for any reason you can’t use this particular report, don’t worry. Penfold is very flexible and can accept any CSV file that contains recognisable column headers and at least the minimum data required. You may be able to use the same files you have used for other pension providers, such as Nest, for example, and there are templates available in case you’re stuck.