The Top Regular Savers Discussion Thread

clairec666

I'm glad I'm not the only one who keeps a spreadsheet of regular savers! I'm a bit of an Excel geek, so I loved making mine. I've got a nice little colour scale thing to highlight the best interest rates so I can fund those first, and different colours for the ones with standing orders, then each month I make manual deposits after pay day (my pay varies a lot so some months I can pump a lot more into my regular savers) and un-highlight the ones I've paid.

s71hj

clairec666 said:

I'm glad I'm not the only one who keeps a spreadsheet of regular savers! I'm a bit of an Excel geek, so I loved making mine. I've got a nice little colour scale thing to highlight the best interest rates so I can fund those first, and different colours for the ones with standing orders, then each month I make manual deposits after pay day (my pay varies a lot so some months I can pump a lot more into my regular savers) and un-highlight the ones I've paid.

Anyone fancy sharing a link to a blank spreadsheet! I'm a bit daunted and sort of don't know where to start!

clairec666

s71hj said:

clairec666 said:

I'm glad I'm not the only one who keeps a spreadsheet of regular savers! I'm a bit of an Excel geek, so I loved making mine. I've got a nice little colour scale thing to highlight the best interest rates so I can fund those first, and different colours for the ones with standing orders, then each month I make manual deposits after pay day (my pay varies a lot so some months I can pump a lot more into my regular savers) and un-highlight the ones I've paid.

Anyone fancy sharing a link to a blank spreadsheet! I'm a bit daunted and sort of don't know where to start!

This is roughly what I've got:
https://docs.google.com/spreadsheets/d/1qAg4gDqIIuX9YO7JG7uHY5nggL90aUQMqrhUtn3JHPo/edit?usp=sharing
Obviously I've removed any personal information and have edited the amounts too. Mine is a little more complicated and has linked sheets from separate years.

Natwest and RBS behave a little differently, in that the interest is paid in monthly and compounded. So the formulas in their rows are different. To extend to the next month, highlight the 3 columns for this month and drag across to the next month to auto-fill. At the moment the "min/max deposits" and "maturity date" columns don't do anything in regards to cell formulas, you'll have to work out each month which accounts are maturing.

Note that if you're adding up the "total interest" column for tax purposes, you would have to take into account which year the interest was paid in; monthly totals for last year are missing, so your "total" for each account will usually be higher than the row total.

s71hj

clairec666 said:

s71hj said:

clairec666 said:

I'm glad I'm not the only one who keeps a spreadsheet of regular savers! I'm a bit of an Excel geek, so I loved making mine. I've got a nice little colour scale thing to highlight the best interest rates so I can fund those first, and different colours for the ones with standing orders, then each month I make manual deposits after pay day (my pay varies a lot so some months I can pump a lot more into my regular savers) and un-highlight the ones I've paid.

Anyone fancy sharing a link to a blank spreadsheet! I'm a bit daunted and sort of don't know where to start!

This is roughly what I've got:
https://docs.google.com/spreadsheets/d/1qAg4gDqIIuX9YO7JG7uHY5nggL90aUQMqrhUtn3JHPo/edit?usp=sharing
Obviously I've removed any personal information and have edited the amounts too. Mine is a little more complicated and has linked sheets from separate years.

Natwest and RBS behave a little differently, in that the interest is paid in monthly and compounded. So the formulas in their rows are different. To extend to the next month, highlight the 3 columns for this month and drag across to the next month to auto-fill. At the moment the "min/max deposits" and "maturity date" columns don't do anything in regards to cell formulas, you'll have to work out each month which accounts are maturing.

Note that if you're adding up the "total interest" column for tax purposes, you would have to take into account which year the interest was paid in; monthly totals for last year are missing, so your "total" for each account will usually be higher than the row total.

Brilliant thank you!

Slinky

clairec666 said:

s71hj said:

clairec666 said:

I'm glad I'm not the only one who keeps a spreadsheet of regular savers! I'm a bit of an Excel geek, so I loved making mine. I've got a nice little colour scale thing to highlight the best interest rates so I can fund those first, and different colours for the ones with standing orders, then each month I make manual deposits after pay day (my pay varies a lot so some months I can pump a lot more into my regular savers) and un-highlight the ones I've paid.

Anyone fancy sharing a link to a blank spreadsheet! I'm a bit daunted and sort of don't know where to start!

This is roughly what I've got:
https://docs.google.com/spreadsheets/d/1qAg4gDqIIuX9YO7JG7uHY5nggL90aUQMqrhUtn3JHPo/edit?usp=sharing
Obviously I've removed any personal information and have edited the amounts too. Mine is a little more complicated and has linked sheets from separate years.

Natwest and RBS behave a little differently, in that the interest is paid in monthly and compounded. So the formulas in their rows are different. To extend to the next month, highlight the 3 columns for this month and drag across to the next month to auto-fill. At the moment the "min/max deposits" and "maturity date" columns don't do anything in regards to cell formulas, you'll have to work out each month which accounts are maturing.

Note that if you're adding up the "total interest" column for tax purposes, you would have to take into account which year the interest was paid in; monthly totals for last year are missing, so your "total" for each account will usually be higher than the row total.

Interesting (groan, pun not intended!).  Presumably the monthly interest figures are a little approximate since you are dividing the annual interest rate by 12 and not taking account of the number of days in the month.

Bigwheels1111

My FD reg saver matures on the 10/05/25.

I kept the old account it merged into last year as was told it would make the process quicker.

Any bets on how many days it take to payout, Plus let me open a new one ?.

Middle_of_the_Road

Bigwheels1111 said:

My FD reg saver matures on the 10/05/25.

I kept the old account it merged into last year as was told it would make the process quicker.

Any bets on how many days it take to payout, Plus let me open a new one ?.

I would hope same day, and next day.

clairec666

Slinky said:

clairec666 said:

s71hj said:

clairec666 said:

I'm glad I'm not the only one who keeps a spreadsheet of regular savers! I'm a bit of an Excel geek, so I loved making mine. I've got a nice little colour scale thing to highlight the best interest rates so I can fund those first, and different colours for the ones with standing orders, then each month I make manual deposits after pay day (my pay varies a lot so some months I can pump a lot more into my regular savers) and un-highlight the ones I've paid.

Anyone fancy sharing a link to a blank spreadsheet! I'm a bit daunted and sort of don't know where to start!

This is roughly what I've got:
https://docs.google.com/spreadsheets/d/1qAg4gDqIIuX9YO7JG7uHY5nggL90aUQMqrhUtn3JHPo/edit?usp=sharing
Obviously I've removed any personal information and have edited the amounts too. Mine is a little more complicated and has linked sheets from separate years.

Natwest and RBS behave a little differently, in that the interest is paid in monthly and compounded. So the formulas in their rows are different. To extend to the next month, highlight the 3 columns for this month and drag across to the next month to auto-fill. At the moment the "min/max deposits" and "maturity date" columns don't do anything in regards to cell formulas, you'll have to work out each month which accounts are maturing.

Note that if you're adding up the "total interest" column for tax purposes, you would have to take into account which year the interest was paid in; monthly totals for last year are missing, so your "total" for each account will usually be higher than the row total.

Interesting (groan, pun not intended!).  Presumably the monthly interest figures are a little approximate since you are dividing the annual interest rate by 12 and not taking account of the number of days in the month.

Yes, exactly. It also doesn't take into account which day you paid in.

dingling68

Middle_of_the_Road said:

Bigwheels1111 said:

My FD reg saver matures on the 10/05/25.

I kept the old account it merged into last year as was told it would make the process quicker.

Any bets on how many days it take to payout, Plus let me open a new one ?.

I would hope same day, and next day.

First Direct Regular Saver

 Mine matured today. It disappeared from my balances yesterday and as yet has not been credited to the savings account left open from last year.

dingling68

I would like to give a shout out to Principality. My first 6 month regular saver matured today. £200 transferred to a new issue 3 and the balance to my nominated account in accordance with my maturity instructions all by mid morning 

First Direct should ask them how they do it