How to treat RA contributions which are not allowed as a deduction

Can the excess amount of retirement contributions which are carried forward to tax years be offset against tax payable on lump sum pension payments?

Yes, you would deduct these portions from the lumpsum received before working out the tax amount.