Keeping Track of Your Money: An Illustrated Guide

Keeping Track of Your Money

Unclaimed Financial Assets in The UK

According to the Unclaimed Assets Register (UAR), there is an estimated £15-20 billion sitting in unclaimed financial assets (unclaimed money) in the UK. Assets can be separated from their owner in multiple circumstances (eg. death, failure to notify a company of a change of address).

Keeping track, notifying your family/partner of your assets and keeping all that information in one place is important. 

What’s more, The ‘Dormant Bank and Building Society Accounts Act 2008’ grants banks and building societies the ability to transfer money held in dormant accounts to a central reclaim fund. A ‘dormant account’ is classified as such when no customer-initiated activity occurs for more than 15 years. Whilst dormant money can be reclaimed at any time by the owner, a large proportion of these assets will likely never be reclaimed. 

Unclaimed Assets in UK Facts

The central reclaim fund is responsible for managing dormant assets, granting reclaims and passing on any surplus to the Big Lottery Fund. According to the central reclaim fund, as of the 31st of December 2017, £1,098,700,000 (thats just under £1.1 billion) of dormant account money has been transferred from participating banks and building societies. £65,740,000 (that’s just under £66 million) has been reclaimed by owners.

That is a reclaim rate of just under 6% (up until the 31st of December 2017). Around £362 million of surplus has been transferred from the central reclaim fund to the Big Lottery Fund. 

Keeping track of your savings and investments, keeping a record of everything in one place for simplicity, can help stave off the chance of this happening to you. 

Track Your Savings and Investments

I have been tracking my savings and investments, on a monthly basis, since I was around 19 years old. I started for two major reasons. Firstly, I wanted to track my net worth and secondly, I wanted to see if tracking it would encourage me to save more. It was a simple idea but it had a surprisingly powerful effect.

Seeing a dip on a graph which tracks your savings will make you stop and think. Even if you don’t actively alter your behaviour, it will probably change anyway. And that is a good thing. I was convinced, from month one, that this was a good idea. 

How to Keep Track of Assets Pinterest Pin

How To Use A Spreadsheet To Track Your Assets?

I am aware that there are apps designed to do this for you but, to me, a spreadsheet is still the best tool (see a zoomed out example below). You can see everything on one page, you can add in useful data and forget any data that you don’t really care about. 

When I started out, the spreadsheet was really simple. I would look up my account balances and then write them down in a table. Over time I started tracking interest payments separately, investments, I added in a section for ‘Profit/Loss’ (monthly) and ‘Year-To-Date’ information.

Honestly, at one point I got a bit carried away. I had so many sections that the task of inputing all the data at the end of the month was quite daunting. I have learned from that and scaled it back since then. I use some methods to speed up the process and it now takes about 15 minutes maximum to fill it all in. 

Investment Spreadsheet Example: Keeping Track of Your Finances

For the rest of this article I talk about how I use Apple Numbers (because I am an Apple nerd) but you can do this with any spreadsheet tool (Eg. Excel). 

Do A Monthly Net Worth Update

I update the spreadsheet on the last day of every month to keep things simple. I could have picked any day but the important thing is to pick a day and stick to it. The data should represent how your account balances change month-to-month so the time period between each update needs to remain constant. If you were to update sporadically, you wouldn’t get an accurate display of this change over time since the period you are measuring in which you earn/spend money  would change. 

I complete one spreadsheet every UK tax year from the last day of April to the last day of March. 

A Spreadsheet To Track Your Money

Track Savings In Bank Accounts

In this section, I record the balance of each bank account under the appropriate month. I have setup the spreadsheet so it automatically updates the ‘Totals’ section underneath. I also have a note of the account interest rates on the right hand side. 

I used to manually login to online accounts to view my account balances. But now most of my account balances can be accessed via a mobile banking app. This is, by far, the quickest way to find out and fill in this information.

The graphs underneath automatically update as well. The bar chart on the left is interactive (an Apple numbers feature). I can move through each month to see a display of the account balances and how they change each month. The line chart is just another display of the same information. The dotted line is the total. 

Bank Accounts - Spreadsheet: Keeping Track of Your Finances

Track Investments In Investment Accounts

This is similar to the table above. I input the investment name on the left and the current value (eg. share price x number of shares). The ‘Totals’ section, interactive bar chart and line graph also automatically update. 

Investments Spreadsheet - Example: Keeping Track of Your Finances

Keep Track Of Total Assets

I do not have to manually input data to this section. Instead, I have setup the spreadsheet so it carries over the totals from the ‘Bank Account’ and ‘Investment’ sections. The table automatically calculates the monthly profit/loss for my bank accounts and investments to let me know if my balances are increasing or decreasing. 

Profit/Loss (P/L) is determined by taking the total from one month (eg. June) and subtracting the total from the previous month. If the difference is positive, the assets have increased in value (profit). If it is negative, the assets have decreased in value (loss). The ‘Total P/L’ takes into account the P/L from my bank accounts and investments combined. 

The Year to Date (YTD) profit/loss rows display how my bank account and investment balances have changed since the start of the year (April). It subtracts the April total from the current monthly total (eg. July Total P/L YTD: £7597 - £4780 = £2817). 

There is a line graph underneath this table which visualises this information. You can see it on the larger, zoomed out spreadsheet above.

Total Table Example: Keeping Track of Your Finances

Profit/Loss Bar Chart

These charts, like the others, will automatically update based on the data you input in the first two tables (Bank Accounts and Investments). One chart displays the profit/loss month-to-month and the other displays profit/loss from the start of the year (YTD). There is a bar for bank account P/L, a bar for investment P/L and a line for total P/L.

I like to visualise the information in a few different ways in order to reinforce saving. For example, if I save money one month, the profit/loss chart will be in the green. An actual, real representation of ‘being in the red’ can have a surprisingly powerful effect on your money saving behaviour. 

Profit Loss Monthly Table Example: Keeping Track Of Your Finances


Tracking your finances in some way is important. You need to know what you have and you need to know where it is. Additionally, just knowing how your financial situation changes month-to-month and having a visual representation of that can help you develop a savings mentality.

If you liked this post, hit the like button down below. If you want to contribute to the discussion, you can do so in the comments section down below. 


Unclaimed Assets Register - Unclaimed Asset Figures

2014 UK Government review of the 'Dormant Bank and Building Society Accounts Act 2008'

Central Reclaim Fund - Financial information