The Final Columns on the Spreadsheet & Financial Independence

My partner in travelling reached 66 years of age recently. He is fortunate to get his state pension at this age, along with his workplace pensions and his bus pass! This birthday was a huge milestone for us on our journey from being economically inactive to becoming pensioners.

When we both stopped working the nine to five in 2017 we had little income to speak of. What we did have was a spreadsheet [of course] with nine columns, one for each year until 2025. The spreadsheet forecast how much of our savings we would need to spend every year so that we could pay the bills and live our lives. We reviewed it regularly in the light of the actual amount we had spent and how much I had managed to earn as a travel writer. Every year on the 31 December I cheerfully deleted the column for the year that had ended. As our pensions have crept closer the trusty spreadsheet has diminished.

I met an old friend I hadn’t seen for a few years recently and she asked me, ‘Did the spreadsheet work?’ Her question made me smile; feel grateful that she had remembered all those conversations about early retirement we had; and also stop and think before I answered her. I realised, yes, the spreadsheet had worked and so much better than I might have hoped.

The spreadsheet started life in 2011 and until 2017 was used to track how much more money we needed to save until we could afford to retire. As the pennies became pounds the amount we needed before we could stop work got smaller.

From 2017 the spreadsheet’s use changed and a new section was added for cashflow, so that we never tied up any money long-term that we needed as our ‘income’ in the short-term. In constant use, the spreadsheet keeps us on track month by month as the details of our spending [mostly in our control and predictable] and income [unpredictable until my small NHS pension arrived in 2020] were updated. This enabled us to see at almost a glance what fiscal flexibility we had every year. Without this information, making financial decisions that were outside our budget would have been more difficult. In particular, the spreadsheet informed our decision to move house in 2019 [something we hadn’t planned for in 2017]. The spreadsheet has been our companion on our journey, growing and evolving as our life has changed, always helpful, sometimes accommodating and never draconian.

It has held my hand for so long, I have realised I will miss this spreadsheet when all the columns have been deleted in two years time. In 2026 all our pensions will have matured, I will also have a bus pass and we will have two fairly predictable incomes once again. Although we won’t be part of the workforce it will feel like we have gone back in time to the days of straightforward fixed incomes. Making sure our expenditure stays within budget will be managed by a different [and even older] spreadsheet!

I never guessed I was the sort of person who would become sentimental about a spreadsheet. Maybe it isn’t surprising when I consider how much it is a symbol of the big step we made in giving up our jobs in 2017. I think maybe my old friend would understand my emotions and I hope you readers do too.

Unknown's avatar

Author: Back on the Road Again Blog

I write two blogs, one about my travels in our campervan and living well and frugally and the second about the stories behind the people commemorated in memorial benches.

6 thoughts on “The Final Columns on the Spreadsheet & Financial Independence”

  1. What a journey though! It’s kept you on track and able to plan, afford and enjoy your travels. In 2026 your spreadsheet will have served its purpose.

    I have a similar one, albeit expenditure is in a different spreadsheet. I’m lucky enough to be in receipt of a military pension, which we live (and travel on). We have a set budget each month, but still manage to save into an emergency fund.

    Our state pension dates are July 2030 and May 2031. Hopefully our 20 year old car will last until then!

    Thanks for sharing.

    Paul

    Liked by 1 person

    1. Thank you Paul. Your car is doing well and fingers crossed it stays that way.
      2030 and 2031 must still feel in the distant future but it will be here eventually. Whether we will be able to save again when we have all our pensions is something I am unsure about at the moment but it may be possible. It would be nice to give those savings a bit of a boost again.

      Like

  2. That’s such a good idea, I have something similar going , and it’s a great comfort to see all is ok, and it helps with the impulsive spends,
    Keep up the blog, and best wishes from Ireland .

    Liked by 1 person

    1. Thank you for reading and your kind comments. I have written about dealing with impulsive spending before and I try and follow the put it on a list and think about it for a while advice that I give 🙂 If I can see we’ve had an expensive month that does curb any desire to buy anything!

      Like

  3. I think it’s a great idea to track your finances in retirement. It can help you stay on track with your budget and make sure you’re not spending more than you can afford. A spreadsheet is a simple and effective way to do this, but there are also many other budgeting tools available.

    Liked by 1 person

Leave a comment