Your Cart
Loading

Premium Bonds Tracker Spreadsheet UK, Prize Tracker vs Prize Fund Rate, Luck Ratio, Multi-Year, Whole Household, Excel Google Sheets

On Sale
£4.99
£4.99
Added to cart

Are your Premium Bonds paying what they should? This spreadsheet tracks every Bond and every prize for your household and compares what you actually won with what NS&I's prize fund rate says an average holder would expect, draw by draw.


It works in Excel and free Google Sheets. NS&I's prize fund rates and odds since 2008 are already filled in, with the source.


WHAT'S INCLUDED

• Premium_Bonds_Prize_Tracker_UK.xlsx: the tracker with a few pink EXAMPLE rows (made-up holders and prizes) so you can see it working

• Premium_Bonds_Prize_Tracker_UK_BLANK.xlsx: the same tracker, empty

• Buyer Guide PDF (3 pages): how to open it, set it up and read the numbers


WHAT IT SHOWS

• Dashboard: Bonds held now, total prizes, expected prizes, your luck ratio, number of prizes, your actual rate, biggest prize

• Year by year: average Bonds in the draws, expected vs actual prizes, luck ratio, your actual rate, plus an optional comparison with any savings rate you type

• Last 24 draws: expected vs actual chart and running totals

• Monthly Draws: Bonds in each draw, the rate and odds for that month, expected and actual prizes


BUILT AROUND HOW PREMIUM BONDS WORK

✔ New Bonds counted from the right draw (NS&I: held one full calendar month first)

✔ Reinvested prizes added to your Bonds from the next draw automatically

✔ Up to 6 holders, or the whole household together

✔ Checks for the £25 minimum, the £50,000 maximum, and cashing in more than you hold

✔ Add new NS&I rates in one place when they change

✔ No macros. Works in Excel 2016 or later, Google Sheets and LibreOffice


PLEASE NOTE

• This is a digital download. Nothing will be posted.

• You need Excel, Google Sheets or another spreadsheet app. A computer is easiest for setup.

• Rates and odds checked on nsandi.com on 12 Nov 2026. They're variable, so add new ones as NS&I announces them.

• This is a record-keeping tool. It is not tax or financial advice, and it doesn't tell you whether to buy, keep or cash in Bonds.

• Not affiliated with, or endorsed by, NS&I. "Premium Bonds" is used only to describe what the tracker is for.

• If the file is faulty or doesn't open, message me and I'll fix it or refund you.

• Designed by me with help from AI tools; every page checked by hand.

• For personal use only. Please don't share or resell the file.

You will get a ZIP (166KB) file