Setting up a Penfold Pension in Sage 50 Payroll
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:
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
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
Contribution - enter the minimum Percentage rate that the company contributes to the scheme
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?
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.
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.