Where Knowledge Rules

Home:

Personal Finance

Get a Widget for this title

How to set up a personal finance worksheet

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


Below are the top articles rated and ranked by Helium members on:

How to set up a personal finance worksheet

  • 1 of 11

    by Ray Cook

    Setting up a personal finance worksheet is simple, but can have a powerful effect on your finances.

    I've been using Microsoft

    read more

  • 2 of 11

    by Jerry Curtis

    Setting up your own personal finance worksheet is easy, and you can take advantage of your computer to make one. For example,

    read more

  • 3 of 11

    by Rachelle de Bretagne

    Thinking that the need for a finance worksheet doesn't affect you because you are broke couldn't be further from the truth.

    read more

  • 4 of 11

    by Simon Wright

    Like many people, I have a personal finance spreadsheet. I use it not only to keep track of my current financial position

    read more

  • 5 of 11

    by Diane Palmer

    If you want to feel in control of your finances, then a personal finance worksheet is a great way to start.

    You do not have

    read more

View All Articles on:
How to set up a personal finance worksheet

Add your voice

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

Helium Debate

Cast your vote!

Should the death tax be abolished?

Click for your side.

171200

Featured Partner

Time 4A Change

Time 4A Change (T4AC) is committed to educating citizens about social issues and mobilizing those citizens as partici...more

What is Helium? | Buy Web Content | Contact Us | Privacy | User agreement | DMCA | User Tools | Help | Community | Helium’s Official Blog | Link to Helium

Helium, Inc.
200 Brickstone Square Andover, MA 01810 USA