Quite a while ago I made a pretty simple Excel spreadsheet to help me manage my finances and its proved very useful. During the past two years I have spent time living on my own where I had to sort out my utilities bills, food, insurances and so on so this really helped me keep track of how much money I was spending and when I was spending too much! I think this might be useful to other people so here it is, attached to this post with example data, if you think it'll help please feel free to download and make a comment 

Instructions

I'm sure there'll be a lot of similar things out there but I think the one I've made is very simple to understand. In the "Bank Balance (Detail)" worksheet you simply paste in a downloaded version of your bank statement. Most banks let you export the last 3 months of data in CSV format but you might need to organise the columns first. Col F is what's going OUT of your account while Col G is what's paid IN and H is the final balance.

The Graph will automatically populate for the area I've selected but you can change this by right clicking the graph and choosing "Source Data" then selecting a larger/smaller area under Series - Values. If you use this spreadsheet for a long time like I do then it'll be helpful to make a new graph per year.

The first worksheet is where you type in the information from your payslip and your regular outgoings then it will tell you if you're spending too much or too little. If you're just playing around with the income then I recommend taking a look at the Salary Calculator which gives a good approximation of how much tax and national insurance you'll pay at any given income.

Public Demo.xls (49.50 kb)