CII R04 Pension Annual Allowance Calculations: A Working Sheet

Table of Contents

• • 2026/27 edition update
• • Use this calculation order
• • Worked tapered-allowance example
• • Threshold income and adjusted income are not interchangeable
• • Carry forward: build a three-row table
• • The MPAA needs a separate branch
• • Common R04 calculation traps
• • Limits of this working sheet

Annual-allowance questions become manageable when you separate four issues: the current year’s allowance, the current pension input amount, unused allowance from earlier years and any restriction caused by flexible access. Do not total contributions and carry forward before checking the taper.

The official CII R04 unit page identifies pension taxation and retirement benefits as core parts of the unit. CII states that its 2026/27 R04 edition applies to exams from 1 September 2026 to 31 August 2027. If your exam is before that window, use the edition assigned to your sitting even where a figure happens to be unchanged. The current statutory reference is the GOV.UK pension schemes rates page. Always match the figures to the tax year examined by your syllabus.

2026/27 edition update

This workbench now follows the final CII 2026/27 tax table and examination guide. Worked examples apply the current year first and then the oldest available unused annual allowance, keep the £60,000 annual allowance separate from the £10,000 money purchase annual allowance, and distinguish relevant-earnings relief from employer pension input. Superseded prior-edition figures and the out-of-scope April 2027 pension-IHT reform are deliberately excluded.

Use this calculation order

1. Identify the tax year and pension input period.
2. Check whether the money purchase annual allowance has been triggered.
3. Establish threshold income and adjusted income.
4. Calculate the standard or tapered annual allowance.
5. Determine the pension input amount for each arrangement.
6. Use the current year’s allowance first.
7. Test unused allowance from the previous three tax years, oldest first.
8. State any remaining excess; do not assume that an excess automatically equals the final tax charge.

For 2026/27, the standard annual allowance is £60,000. The taper applies only when both of these conditions are met:

• threshold income is above £200,000; and
• adjusted income is above £260,000.

Where both apply:

taper reduction = (adjusted income − £260,000) ÷ 2

Deduct that reduction from £60,000, but do not reduce the tapered annual allowance below £10,000. The minimum is reached when adjusted income is £360,000 or more, provided the threshold-income condition is also met.

Worked tapered-allowance example

Assume the facts for 2026/27 are:

• threshold income: £230,000;
• adjusted income: £300,000;
• pension input amount: £52,000; and
• valid unused allowance from the three earlier years: £15,000 in total.

Both taper gates are passed.

1. Excess adjusted income: £300,000 − £260,000 = £40,000
2. Taper reduction: £40,000 ÷ 2 = £20,000
3. Current annual allowance: £60,000 − £20,000 = £40,000
4. Current-year excess before carry forward: £52,000 − £40,000 = £12,000
5. Use £12,000 of valid unused allowance.
6. Remaining unused carry forward: £15,000 − £12,000 = £3,000

On those limited facts, no input remains above the available annual allowance after carry forward. In an exam question, the earlier years must be checked individually; do not accept a stated total unless the question allows it.

Use the working sheet after calculating the result manually. Enter the current-year income and pension-input facts, then add earlier unused allowances only after confirming they are valid. If the money purchase annual allowance applies, treat the tool’s simplified result as a prompt to revisit the separate MPAA and alternative-allowance rules.

Threshold income and adjusted income are not interchangeable

The two figures answer different parts of the taper test. In broad terms, threshold income starts from taxable income and allows for specified deductions and additions. Adjusted income also brings in relevant employer pension input. The exact statutory definitions and anti-avoidance rules matter.

An exam question may supply both figures directly. If it supplies underlying salary, sacrifice or contribution facts, follow the method in the applicable study text. Do not add every employer contribution to threshold income or deduct every personal contribution without checking how it was paid.

Carry forward: build a three-row table

For each of the previous three tax years, record:

Tax year	Actual annual allowance available	Pension input amount	Unused amount
Earliest year	allowance for that year	input for that year	allowance minus input, minimum zero
Middle year	allowance for that year	input for that year	allowance minus input, minimum zero
Latest year	allowance for that year	input for that year	allowance minus input, minimum zero

Use the current year’s allowance before carry forward and then use earlier unused allowance on a first-in, first-out basis. The person must have been a member of a registered pension scheme in the relevant earlier year. Also remember that tax relief on a member’s personal contribution has its own limits; available annual allowance does not by itself create enough relevant UK earnings.

The MPAA needs a separate branch

For 2026/27, the money purchase annual allowance is £10,000. It can be triggered by specified forms of flexible access to money-purchase benefits. Once triggered, carry forward cannot increase that £10,000 money-purchase limit.

Do not assume that taking any pension benefit triggers the MPAA. A pension commencement lump sum with no flexible taxable income, a lifetime annuity that is not flexible, and certain small-pot payments are examples that require different treatment. Apply the trigger rules given in the syllabus rather than guessing from the word “withdrawal.”

Common R04 calculation traps

• Testing only adjusted income: both taper conditions must be satisfied.
• Taking the full excess over £260,000: the reduction is one pound for every two pounds.
• Reducing below £10,000: the tapered allowance has a minimum.
• Using £60,000 for every prior year: calculate the actual allowance available in each year.
• Using carry forward before the current allowance: current-year allowance is used first.
• Treating contributions as DB input: defined-benefit arrangements require a statutory valuation of benefit growth.
• Equating excess with tax: the annual-allowance tax charge depends on the individual’s tax position and requires a further calculation.

For a full revision structure covering scheme types, benefit options and retirement advice, use the CII R04 Pensions and Retirement Planning study plan.

Limits of this working sheet

This calculator is an educational aid, not pension, tax or financial advice. It does not perform a full threshold-income or adjusted-income computation, calculate a defined-benefit input amount, apply every MPAA and alternative-allowance interaction, test tax-relief limits or calculate an annual-allowance charge. Use official current rules and professional support for real pension decisions.