← All prebuilt solutions
Personal Finance

Pension Annual Allowance & Carry Forward Calculator

How much you can pay into pensions this year – tapering, the MPAA and three years of carry forward worked out for you

£20

Secure checkout. Your file is ready in your client portal as soon as payment clears.

Pension Annual Allowance & Carry Forward Calculator

Overview

The annual allowance is the most that can go into your pensions each tax year with tax relief before a charge applies. Unused allowance from the previous three years can be carried forward, which is how many people make large one-off contributions – for example from a bonus or business sale.

Price
£20
Who it’s for
Personal Finance
Works with
Microsoft Excel for Windows and Mac
Buy now

See how it works

A walk through the main sheets

The sheets you will use most, in the order you will use them – shown with the sample data every workbook comes with.

Step 1

Years

Contributions and income for this year and the last three. What you do: enter each year.

Years
Settings

Step 2

Settings

Your situation and any MPAA trigger. What you do: fill in once.

Step 3

Rates

Allowances and taper thresholds used. What you do: update each April.

Rates

Step 4

Who it is for

Made for people like you

  • Example – text
  • Higher earners – Use carry forward without triggering a tax charge.
  • Company directors – Plan large employer contributions safely.
  • Financial planners and accountants – Check the allowance before advising.

Quick start

Up and running in minutes

  1. Example – text
  1. Settings – Your name, the tax year you are planning for, your earnings and your top rate of tax.
  2. Years – For each of the eight years, whether you were in a pension scheme and what went in. Only fill in threshold and adjusted income if you earn over £200,000.
  3. Dashboard – Allowance, carry forward, room left and any charge for this year.

Key features

  • Works out your annual allowance for this tax year, including the taper for high earners and the money purchase annual allowance (MPAA).
  • Brings forward unused allowance from the three previous tax years in the right order – this year first, then the earliest year – and keeps track of what is left.
  • Shows how much more you can pay in without a charge, estimates any annual allowance charge and checks your contributions against your earnings.

What’s included

  • Dashboard – This year at a glance
  • Settings – Tax year, earnings and tax rate
  • Years – Contributions and carry forward by year
  • Rates – Allowances by tax year
  • Guide – How to use this workbook

How buying works

Your file is only released to your client portal once payment has cleared.

1

Click Buy now

You are taken to our secure checkout.

2

Pay securely

Checkout takes a minute and you get a receipt by email.

3

Download your file

Your file is ready in your client portal as soon as payment clears, and we email you your invoice with a link to the portal.

Explore the range

Need it tailored to your business?

We can adapt any prebuilt solution or build something bespoke, with a lifetime bug-free guarantee.

Part of AML Finance Group

Need an accountant too?

Our sister firm, AML Accountancy Solutions, is an award-winning accountancy practice helping businesses and individuals across the UK with their accounts, tax, bookkeeping and payroll.

Visit AML Accountancy Solutions