Keeping track of interest rates on multiple accounts

littlemoney

If you have multiple accounts, how do you keep track of all the changes and know when to ditch and move on. Rate changes have been happening so quickly I can't seem to sort out what to keep and what to ditch/switch. Thanks

VKE

I keep track using excel document I've put together it includes:
Provider
Interest rate %
£ value in the account 
Account details: sort code & account number 
£ of projected Interest 
Linked bank name
Date account opened/closed/switch info
Then each month I copy, amend, update info 
I also password protect the document

Sarahspangles

I use a spreadsheet, Provider - Account Name - Interest Rate - Date of Interest/Maturity - Forecast Interest.  The Interest goes into a column for the year it is payable so I can keep an eye on whether I will be exceeding the PSA.  I split out the tax-free accounts.

This started out as a way to track the investments but with interest rates rising I jazzed it up a bit - just in time to spot that if I didn’t move some cash into an ISA not only was I going to pay tax on the interest, but it was going to take me into the higher rate tax band.

wmb194

MS Money and so it's easy to see in the account list I include the interest rate in the name of the account.

Stargunner

wmb194 said:

MS Money and so it's easy to see in the account list I include the interest rate in the name of the account.

Does it still work on the later operating systems, or are you running it on an old pc, because MS stopped supplying it around 15 years ago. I remember using it back in the 90s.

Linton

Stargunner said:

wmb194 said:

MS Money and so it's easy to see in the account list I include the interest rate in the name of the account.

Does it still work on the later operating systems, or are you running it on an old pc, because MS stopped supplying it around 15 years ago. I remember using it back in the 90s.

Yes, I am currently using it on a new PC running the latest Windows 11 with no problems.

wmb194

Stargunner said:

wmb194 said:

MS Money and so it's easy to see in the account list I include the interest rate in the name of the account.

Does it still work on the later operating systems, or are you running it on an old pc, because MS stopped supplying it around 15 years ago. I remember using it back in the 90s.

No, it still works. I'm using Windows 10 but I don't see why it won't work on 11 (we actually have a W11 computer so I could test it).

NanookOfTheNorth

I'm using MS Money on Windows 10 without any problems.  Its worked perfectly well on all the versions of Windows I've had for many years.  My PC isnt suitable for Windows 11, but I doubt it would have a problem on there either.

dgpur

littlemoney said:

If you have multiple accounts, how do you keep track of all the changes and know when to ditch and move on. Rate changes have been happening so quickly I can't seem to sort out what to keep and what to ditch/switch. Thanks

Not much help I know, but I started a spreadsheet, to track my accounts, expenses, regular bills, tax level etc., years ago. It’s grown and expanded organically in reaction to events and an increasing number of things to track. Start your own, and let it grow. Plus, of course, the relevant threads on here are the best ways of tracking new/changed accounts/rates.

Stubod

+ another for a spreadsheet, easy to adapt as and when things change...

ChilliBob

To all those using an Excel spreadsheet, like myself, do you implement any kind of version control, archiving etc?

So often a spreadsheet can grow organically and you spot an error, and oh, of you could go back  three iterations ago it can be useful. 

I'm the corporate world this was always easy with say shadow copies, or some other fancy system.. Home user wise I'm less sure besides saving a copy when you make significant changes.

Spreadsheets are also helpful for the conditional formatting, validation etc that you can have to cross check etc