← All prebuilt solutions
Tax & Company

Pension Contribution Calculator

The real cost of paying into your pension

£20

Secure checkout. Your download link is sent as soon as payment clears.

Pension Contribution Calculator

Overview

Paying into a pension is one of the most tax-efficient things you can do, but it's hard to see what a contribution actually costs you. Depending on your income and how you pay, £1 in your pension can cost anywhere from about 40p to 80p – and in the '60% band' between £100,000 and £125,140, or when it cuts a Child Benefit charge, it can be even cheaper. This calculator compares your position with and without an extra contribution, shows the real net cost and the cost per £1 that goes in, and checks the total against your annual allowance including carry forward from the last three years.

Price
£20
Who it’s for
Tax & Company
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

Annual Allowance

How much can go into your pensions this year without a tax charge, and your headroom. What you do: nothing to enter – it uses the Calculator inputs.

Annual Allowance
Calculations

Step 2

Calculations

The full calculation: one row without the contribution, one row with it, and a row for every £2,000 step used by the chart. What you do: nothing to enter – useful if you want to follow the workings.

Step 3

Step 4

Who it is for

Made for people like you

  • Example – text
  • Employees – Personal contributions with relief at source, or salary sacrifice with income tax AND National Insurance savings.
  • Self-employed sole traders – Personal contributions with basic rate relief added by the provider and higher rate relief through your tax return.
  • Company directors – Company (employer) contributions with the corporation tax saving, or salary sacrifice / personal contributions for comparison.
  • Higher earners – The effect on the 60% band (personal allowance taper), the High Income Child Benefit Charge and the tapered annual allowance.

Quick start

Up and running in minutes

  1. Example – text
  1. You – On the Calculator sheet, choose the tax year and whether you're an employee, self-employed or a company director, then enter your salary or profit, other income, whether you're a Scottish taxpayer and how many children you claim Child Benefit for. Directors also enter the company's profit.
  2. The contribution – Enter the extra amount you want to go into the pension (gross) and choose how it's paid. For salary sacrifice, say whether your employer adds its NI saving.
  3. Existing contributions – Enter the personal and employer contributions already being made this year, so the annual allowance check is complete.
  4. Carry forward – Enter any unused annual allowance from each of the last three tax years.
  5. Read the answer – See how much goes in, the net cost to you, the cost per £1, and your allowance headroom. The table and the ✔ notes below explain where the savings come from.
  6. Try other amounts and routes – Change the amount or the 'How it's paid' option and watch the results – the chart shows where each extra £1 is cheapest.

Key features

  • Employees, the self-employed and company directors – relief at source, salary sacrifice or company contributions.
  • Shows tax relief, NI savings, corporation tax savings and the true net cost per £1 invested.
  • Recovers the personal allowance in the 60% band and reduces the High Income Child Benefit Charge.
  • Annual allowance check with taper, MPAA and three years' carry forward.

What’s included

  • Calculator – Inputs, the answer and chart
  • Annual Allowance – How much can go in
  • Calculations – The workings behind every result
  • Tax Rates – Rates and allowances
  • Guide – How to use this workbook

How buying works

Your file is only released 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 download link arrives as soon as payment clears.

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