Free Pension Pot Tracker
Most of us collect a new pension with every job, and it is easy to lose track. This free pension pot tracker keeps all your pensions in one place, adds up your total pot and shows what it could grow to by retirement.
Free Excel file. Works in Excel, Google Sheets and Numbers. On a phone you may need the free Excel, Numbers or Google Sheets app.
What’s in the Pension Pot Tracker
🗂️ All your pots
Provider, type, value, yearly charge and contributions for up to 15 pensions, with your total pot.
💸 Charges
See what your pension charges cost you in pounds each year, not just as a percentage.
🔮 Projection
Enter your age, retirement age and your own growth assumption to project your pot and 25% tax free cash.
Find Your Lost Pensions
If you think you have a pension from an old job, the government’s free Pension Tracing Service can give you the contact details. It is also worth checking your State Pension forecast.
Keep your pension pot tracker private, and never give your details to anyone who contacts you out of the blue offering to unlock or move your pension.
Ready to get started?
Download it free, fill in your own figures and let the spreadsheet do the maths.
New to pensions? Read our simple guide to what a pension is and work out how much you need to retire. You can also try our retirement calculator.
This spreadsheet is general information only and is not financial or tax advice. Tax rules can change and depend on your circumstances, so check GOV.UK or speak to an accountant before relying on it. Correct for the 2026/27 tax year, updated October 2026.