To help employers when liaising with scheme members, please find attached a ready reckoner for calculating pension tax charges.
The ready reckoner requires some basic active member data - like salary, service, additional voluntary contributions (AVCs) paid - input in cells (highlighted in yellow).
It automatically calculates an estimate of the level of pension savings and tax charges for members, and any carry forward of unused annual allowance from the previous 3 years.
The carry forward can make quite a difference to the outcome. The non-highlighted cells are locked to avoid corruption or altering of the coding that's been developed.
Please note the ready reckoner provides an estimate for illustration purposes only, although it is relatively sophisticated in its output. Pension benefits and tax calculations are complex. We claim no liability for damages arising from any decision taken based on the figures quoted.
The ready reckoner is password protected to ensure only registered employers in the Derbyshire fund have access. If you have trouble with the password please contact the pensions technical team email: email@example.com
We have also provided a useful guide to the changes on the taxation of pension benefits attached to this page.