Excel spreadsheet to track savings?

pamaris

Hi,

I would love to find an excel spreadsheet template in which I can track my savings accounts. It seems I need several accounts in order to get the best rate and I would like to be able to list them with the monthly contributions and interest rates. Does anyone have one they could give me or does anyone know where I can download one? I am cr*p at the calculation formulas so I can't make it myself.

Thanks!

LittleVoice

I've created my own spreadsheet file which has a different sheet for each account and one sheet to which I transfer balance and calculated accrued interest on a monthly basis in order to see how my total funds are growing. I also include a sheet which lists the rates so that I can rank them by moving the rows when a rate changes and this helps decision making.

However, with my system, to keep things up-to-date you do need to understand how the formulae work so that you can make adjustments when rates change and to sort them out if you make an error in copying things. I therefore don't think it would be worth sending you a template if you don't know how to do this.

It may also be more complicated than you need. How many accounts do you have and how much detail do you want to record?

If no one else comes up with something for you which is easier, could I suggest you take this opportunity as an incentive to learn about formulae in spreadsheets and do create your own. This will give you a sense of achievement and may be useful in other situations too. It also means that you can keep the amount of detail that you want rather than what someone else wanted.