NICS Pension Schemes - Employer Calculators

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 compensation in lieu of notice (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 the 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.

Joiner tool

The New Entrant Pension Questionnaires can be found in the Employer Section.

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.

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 three 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 regarded as '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 'Enabling Editing' button
if the password prompt opens, click 'Read only' to continue
to ensure full functionality you must Enable Macros