4 of 11

Write now Article Tools

Like many people, I have a personal finance spreadsheet. I use it not only to keep track of my current financial position but also as a way of seeing how my finances are progressing towards the targets that I have set myself. Indeed, I think the key role that a personal finance spreadsheet can play is to get you into the discipline of setting short and long-term financial targets and checking to see how you are performing against these targets. In effect, it helps you to take control of your finances.

It's worth starting by saying that there are a range of financial money management tools out there, such as Microsoft Money, that can be used. However, my preference is to stick to my spreadsheet as it's free and I can tailor it precisely to what I would to record and measure. Leading on from this, it figures that you can decide what tabs you want to set up within your spreadsheet. However, I've listed some of the main categories that will typically be worth monitoring.

1. Your bank account balances:

It is useful to track the balances of the various bank accounts that you hold. It is also useful to split out the accounts that form your Assets (savings accounts and current accounts) from the accounts that form your Liabilities (Mortgage, Loans, credit cards).

Whilst it's useful just to track the current balances, there can be other bits of analysis that we can do on these accounts. For example, I am allowed to put up to 3,600 pounds into my ISA tax-free savings account every year, so I like to keep track of how much more I can pay in during the tax year.

2. Share Portfolio:

For those who have shares, it can be useful to keep track of which companies or funds you have, how many shares you have with each company, what price you bought the shares at and what price the shares are now. I then use the Motley Fool website to get updates on the share prices of the companies that I hold and I enter the figures into my spreadsheet. Having done this, I can see whether my investment has made me money or lost me money, in paper terms at any rate.

The one word of caution that I would flag up is the danger of micro managing your share portfolio. Often, when we buy shares, we are buying into the long-term performance of a company. Constantly looking at short term price fluctuations can cause us to lose site of our investment objectives and may lead to a decision to trade on the share too early. This is particularly true, I think, during periods of great economic instability when share

• 1
• 2
• next page >>

Add your voice

Know something about How to set up a personal finance worksheet?
We want to hear your view. Write now!