Employer calculators

To help you identify the correct pension choices for your staff we have provided a pensions questionnaire and joiner tools.

We have also provided a CILON calculator – this is for you to work out the cost of compensation in lieu of notice.

Employers should refer to the Employer Pension Guide, Section 6 for further guidance on Civil Service Compensation Scheme (CSCS).

Pensions questionnaire and joiner tool

This tool will tell you the correct pension scheme to enrol your staff into, and ensure they receive the appropriate starter pack and information.

New entrants starting after 1 April 2015 will usually have a choice of joining either alpha or partnership. The options available for rejoiners, and people joining from other public service schemes are not that straightforward

CILON Calculator

The compensation in lieu of notice (CILON) calculator will ask you for the amount of salary, allowances and bonus to which the individual would have been entitled to had they remained in service during the notice period, and will calculate the loss of pension for the same period giving a total of CILON to be paid through the payroll. National insurance and tax should be deducted in the normal way.

Employers should refer to the Employer Pension Guide, Section 6 for further guidance on Civil Service Compensation Scheme (CSCS).

The calculator you should use for a particular individual depends on which scheme they were an active member of on their last day of service - even if they would have moved to alpha during their notice period. For example, a member of the PCSPS who has Tapered Protection and whose tapered alpha enrolment date was 1 June 2015 left service on 1 May 2015 and was due CILON for 3 months’ notice, would have their CILON calculated using the new PCSPS CILON calculator, notwithstanding the fact that they would have transferred into alpha if they had actually worked their notice period.

If the notice period goes over the scheme year end (31 March) you should run the calculator separately for the two periods using the appropriate salary and contribution rate for each period.

 

If you are having trouble using these calculators please read the information below.

What are the system or software requirements to use these tools?

  • Tools are required to be run on Windows versions of MS Excel 2007 (V14) and above.
  • Although the tools originate from the internet, they are uploaded and hosted by the Civil Service Pensions websites and should be considered ‘safe’.
  • The tools use Macros (VBA) for clearing cells and creating PDFs if required, therefore macros should be enabled to ensure full functionality.

How do I open the tools?

  • When a tool is first opened click the 'Enable Editing' button.

Enable editing

  • If the password prompt opens, click ‘Read Only’ to continue.

Read only

  • To ensure full functionality you must Enable Macros.

Enable macros