Bulk Salary Sacrifice Calculator

For financial advisers and employers only

Please use the link below to access Aegon’s bulk salary sacrifice calculator for the 2022/23 tax year.

Bulk Salary Sacrifice calculator (XLS - 12.8mb)(Opens new window)

Bulk salary sacrifice calculator user guide

This calculator can be used to produce bulk quotes to help financial advisers and employers calculate the benefits that can be achieved through an agreed salary sacrifice between an employer and employee. Salary sacrifice isn’t suitable for all employees especially those who earn at or around the personal tax allowance. The information required to generate a quote will not be used for any other purpose other than to illustrate the effect a salary sacrifice will have on an employee. You must have consent from an employee to use their information in the calculator and have a legal reason for processing the information used.

If you are looking to produce calculations for only one employee, please refer to our Individual Salary Sacrifice Calculator. Please note the layout and format of the individual calculator is different to that used for the bulk calculator. 

Once the calculator has been fully opened, you'll be presented with a spreadsheet where you can enter information in rows for each quote you need to do. Descriptions for each column are detailed below:

  1. The scheme nameclient nameclient referencesex, DOB and address columns are all optional. These details will pull through to the quote if entered, but won't prevent a quote from being produced if they're left blank.
  2. The N/A column can be left blank as this is no longer used.
  3. The only option in the contract column is PP (personal pension) so this should be chosen.
  4. The salary column should be completed with the employee’s gross annual salary before salary sacrifice.
  5. The tax allowance column should be completed with either ‘standard’ or ‘other’. If left as ‘standard’, this will assume the standard personal allowance for the current tax year. If the employee has a personal allowance different to this, ‘other’ should be selected and the amount entered in the other amount column (for example, where an employee has a tax code of 630L, this should be entered as £6,300). A negative personal allowance can be entered if a K tax code applies.
  6. The SALTYPE column should be completed with ‘1’ if the quote is to be based on the pension contribution being kept constant (which allows the employee to maintain their current pension contribution and increase their take-home pay by sacrificing some of their salary) or ‘2’ if the quote is to be based on the net income being kept constant (which allows the employee to maintain the same take-home pay and increase their pension contribution by sacrificing some of their salary). Quote option 1 is the same as the ‘To pay’ option on Aegon’s individual salary sacrifice calculator. Quote option 2 is the same as the ‘To pension’ option on Aegon’s individual salary sacrifice calculator.
  7. As the employer won’t pay employer’s National Insurance (NI) on the salary being sacrificed, some or all of this saving can be passed on to the employee. The for 100% employer NI saving… column should be completed with the proportion of the NI saving that's to be contributed (for example, if all the saving is to be contributed then 1 should be input, if half of the saving is to be contributed then 0.5 should be input or 0 (zero) can be input if none of the employer NI saving is to be included).
  8. The employer contribution column should be completed with either ‘Y’ if employer contributions are being paid, or ‘N’ if they aren't. If they are being paid, the employer contribution frequency column should be completed with either ‘Y’ ( yearly), or ‘M’ (monthly) and the amount should be completed in the employer contribution amount column.
  9. The amount of current employee contribution should be completed in the employee contribution amount column, and the employee contribution frequency column should be completed with either ‘Y’ (yearly) or ‘M’ (monthly).
  10. The commencement date column should be completed with the assumed start date to be used in the quote. The calculator will only produce a quote for the current tax year so the commencement date should be left as the current date as it appears or you can use a future date in the current tax year.
  11. The is the employee an apprentice under age 25 field should only be ticked if the quote is for an apprentice under age 25 so that the employer NI is calculated correctly. Otherwise, don't tick this field.
  12. The Scottish taxpayer field should be set to Y if the employee is a Scottish taxpayer. Otherwise, it should be set to N.

Once the data for each employee has been entered, you can proceed by clicking one of the following buttons located at the top of the spreadsheet:

  1. Save entered data will prompt you to save the data you have entered on this screen. This allows you to easily use it again for future quotes.
  2. Import data will allow you to retrieve data previously saved to use in further quotes without having to input details individually.
  3. Generate quotes will give you the following options:     
  • Print illustration will print the quote only to your default printer.
  • Print illustration along with letter will print the quote to your default printer, along with the employee covering letter.
  • Save illustration will prompt you to save the file to a location of your choosing, with the file saved in the format of your spreadsheet software.
  • Save illustration along with letter will prompt you to save the file to a location of your choosing, along with the employee cover letter.
  • Re-enter the bulk data will let you change any of the information you’ve entered.

Finally, choosing exit will close the application.

Once you've produced the quotes you need, make sure the figures for each quote look accurate and relevant to the quote type you've requested.