Being nosey... How many Regular Saver accounts do you have?

DRS1

As someone who recently had to ask Google how to subtract cell B from cell A in a spreadsheet can I say "hats off" to @clairec666.

In answer to a question in one of her other posts I fund all my RSs by standing order.  Which makes it easy to forget that I have some.  I just had to look at my Nationwide accounts for a maturing bond and found I had a Flexclusive Saver (paying 1.35% - so my 2.45% RS isn't my worst!).  I took the opportunity to open another Nationwide RS paying a somewhat higher rate. but I did not close the old one just reduced the monthly input.

So I now have 5 RSs monthly contribution £1700.  Lowest interest rate down from 2.45% to 1.35%  Maybe I should move that to a 95 day notice account? 

AndyTh_2

clairec666 said:

Appreciating all your hard work Bobblehat

No need to add this to the spreadsheet, but would be interesting to know who else manually funds all their accounts each month, and who sets up standing orders and just lets everything run itself.
For a mid-table regular saver like myself, doing everything manually each month isn't too strenuous.

I added a neat little bit of code to my banking spreadsheet which kind of "automates" any future transactions (on the spreadsheet only, of course) so I can fast-forward in time and see what my finances will look like in a few months' time. Useful for knowing how to spread my funding around each month.
I can fast forward all the way to August next year, just before my Monmouthshire accounts mature, and it looks like my total regular saver holdings will have jumped to £37000. Natwest and RBS will have dwindled to £0 around April then will start building back up again.

This little system also makes it easy to count how many individual transactions I'll be doing over the next year... and it's rather made me realise how much time I spend on this, and that switching back to standing orders might be a wise idea.

Mind you, I spent 3 hours this morning coding this, and I don't consider that to be time wasted

I've started funding of the bigger limit ones manually, and those like Zopa that don't support standing orders direct to the regular saver (nor open banking's repeat auto-save).

For my spreadsheets I generally put future transactions to the regular saver in when I've opened the account, and also have data points for interest payout days that aggregate interest calculations. Been thinking about properly automating it though as well with a list of regular income/outgoing/transfer. Just it's a bit messy VBA. I wish they brought in a newer language in Excel.

and can't do it in Google Sheets as there are a lot of transactions (I've been keeping transactions since 2010)

Bobblehat

DRS1 said:

As someone who recently had to ask Google how to subtract cell B from cell A in a spreadsheet can I say "hats off" to @clairec666.

In answer to a question in one of her other posts I fund all my RSs by standing order.  Which makes it easy to forget that I have some.  I just had to look at my Nationwide accounts for a maturing bond and found I had a Flexclusive Saver (paying 1.35% - so my 2.45% RS isn't my worst!).  I took the opportunity to open another Nationwide RS paying a somewhat higher rate. but I did not close the old one just reduced the monthly input.

So I now have 5 RSs monthly contribution £1700.  Lowest interest rate down from 2.45% to 1.35%  Maybe I should move that to a 95 day notice account? 

Out of interest(!), which 5 Regular Savers do you have? It would be good to know the exact name of the Bank/BS and account name of each as I'm a little confused by the interest figures you are quoting. The figures in the region of 1.35% to 2.45% sound more like matured accounts that have been converted to some sort of Easy Access accounts!

Regular Saver enthusiasts on here are more used to figures like 7%, 6% and getting down to the lower end, 5%? 

Kim_13

Bobblehat said:

DRS1 said:

As someone who recently had to ask Google how to subtract cell B from cell A in a spreadsheet can I say "hats off" to @clairec666.

In answer to a question in one of her other posts I fund all my RSs by standing order.  Which makes it easy to forget that I have some.  I just had to look at my Nationwide accounts for a maturing bond and found I had a Flexclusive Saver (paying 1.35% - so my 2.45% RS isn't my worst!).  I took the opportunity to open another Nationwide RS paying a somewhat higher rate. but I did not close the old one just reduced the monthly input.

So I now have 5 RSs monthly contribution £1700.  Lowest interest rate down from 2.45% to 1.35%  Maybe I should move that to a 95 day notice account? 

Out of interest(!), which 5 Regular Savers do you have? It would be good to know the exact name of the Bank/BS and account name of each as I'm a little confused by the interest figures you are quoting. The figures in the region of 1.35% to 2.45% sound more like matured accounts that have been converted to some sort of Easy Access accounts!

Regular Saver enthusiasts on here are more used to figures like 7%, 6% and getting down to the lower end, 5%? 

2.45% might well be Ecology. It formerly offered Direct Debit meaning many MSErs had it, and once open many MSErs do not close accounts so that any new offers by that provider can be easily snapped up.

Given the username, I hope they have a NatWest/RBS Digital Regular Saver in there @ 5.5%.

Ch1ll1Phlakes

clairec666 said:

No need to add this to the spreadsheet, but would be interesting to know who else manually funds all their accounts each month, and who sets up standing orders and just lets everything run itself.
For a mid-table regular saver like myself, doing everything manually each month isn't too strenuous.

I always make the first payment manually and then set up standing orders for the next X payments on the 1st of the month. I'm not too worried about lost interest due to non-working days as I always try and open new Regular Savers late in the month (which gives nice bonus interest). Tbh at the rate the number of account I hold is growing I'm very glad I'm not doing manual payments.

dont_use_vistaprint said:

For example, if you had £100,000 sat earning 4.6% in a 95-day access, with the maximum effort and number of regular savers , schedules transactions etc what  would be the  increase you could get in one year 

I totally disagree with those who say the effort is minimal the process of opening and administering all those accounts is huge, and all the extra mail emails text messages cards and pin numbers, it can easily consume hours of your time, that  you could be using to make money

I wouldn't say the rewards are too small for me but I don't have anywhere near £100k. But I'll put it this road my Regular Savers increase my weighted mean interest rate across all my accounts from 3.99% to 4.54%. Might only seem like an increase of half a percent but it works out that I earn 13.5% more total interest than before, that's the equivalent of £1000 becoming £1137.84.

For me that's worth the admin effort. I don't think the admin is overly bad, I set up standing orders and move a lump sum from other savings a day or two in advance every month (takes about five mins). I sporadically check the balances but as long as it's leaving my CA I'm happy. I don't think I get many emails, mail or texts about the accounts only at maturity and usually I've already decided what I will do with the account long before maturity. I do spend quite a bit of time with spreadsheets (as you'll see in my next comment) but this isn't really admin as it's not neccessary it's more that I enjoy the tinkering.

Ch1ll1Phlakes

mhoc said:

How do people set up there Google charts/excel charts?
I feel that I need to do some reorganisation - maybe alphabetical order would be more logical, an extra column, 1st column with bank/building society, 2nd account title ...  but what other columns do people use??

I have multiple tables for different reasons. Though none as intricate as the macro that @clairec666 created. On one sheet of an excel doc I have individual tables predicting the exact interest I will received for each account dependent on interest rate, monthly pay in, length of term and non-banking deposit days. At the top of this sheet is a table most similar to what you describe @mhoc which summaries all my regular savers. My headings are

1) Provider
2) Account Name
3) Current Value (This is updated sporadically and not really that useful except when updating the predicted interest values)
4) Maximum Value (I don't count overpayments)
5) Difference between current and maximum
6) Predicted Interest
7) Total End Value (Max+Interest)
8) Interest Rate
9) V or F (No heading but a column denoting Variable or Fixed Interest)
10) Monthly Pay-in (Good for totalling how much I need to move per month

The other table I'll mention is a very rough prediction table for comparing the total interest earning when filling a Regular Saver from an easy access account. Pretty much a column for each regular saver with name, interest rate, twelve months of balances then the rough interest calculation based an average balance of (month1+ month12) /2. Then the subsequent average balance of the easy access account, it's predicted interest and then the total interest across both accounts. 

If you're curious about any of these let me know and I'll make a dummy one like Claire did for hers.

DRS1

Bobblehat said:

DRS1 said:

As someone who recently had to ask Google how to subtract cell B from cell A in a spreadsheet can I say "hats off" to @clairec666.

In answer to a question in one of her other posts I fund all my RSs by standing order.  Which makes it easy to forget that I have some.  I just had to look at my Nationwide accounts for a maturing bond and found I had a Flexclusive Saver (paying 1.35% - so my 2.45% RS isn't my worst!).  I took the opportunity to open another Nationwide RS paying a somewhat higher rate. but I did not close the old one just reduced the monthly input.

So I now have 5 RSs monthly contribution £1700.  Lowest interest rate down from 2.45% to 1.35%  Maybe I should move that to a 95 day notice account? 

Out of interest(!), which 5 Regular Savers do you have? It would be good to know the exact name of the Bank/BS and account name of each as I'm a little confused by the interest figures you are quoting. The figures in the region of 1.35% to 2.45% sound more like matured accounts that have been converted to some sort of Easy Access accounts!

Regular Saver enthusiasts on here are more used to figures like 7%, 6% and getting down to the lower end, 5%? 

Well as I say the old Nationwide account calls itself a Flexclusive Saver though I used to have it noted as a Flex Regular Saver.  It has probably been going for 4 years or so and don't ask me for a history of interest rates but it must date from the era of low rates.

I now have the Nationwide Flex Regular Saver paying 6.5%

The other new one is the Manchester Regular Saver at 5.5%

Of the old ones the one with a moderately respectable interest rate (5%) is at Santander and survives because it auto renews every year.

The 2.45% one is at YBS (sorry @Kim_13).  It is called Access Saver Plus and again dates back years.  This one probably has changed because all the accounts with that name at YBS seem to be easy access accounts (but don't ask me what it was called before). Anyway it is still getting a standing order each month.  In my defence all I can say is that the money would earn less interest if it just stayed in the current account.  But I should really start redirecting some of those old standing orders.

SH88SH88

Has anyone who does the payments manually ever had problems with payments being blocked by the Fraud dept ? ... some of the banks/BS's Fraud teams/algorithms seem overly keen so I would've thought many manual payments in a short timeframe would attract attention.

RosieRooBear

SH88SH88 said:

Has anyone who does the payments manually ever had problems with payments being blocked by the Fraud dept ? ... some of the banks/BS's Fraud teams/algorithms seem overly keen so I would've thought many manual payments in a short timeframe would attract attention.

I’ve never had any payments blocked and I use both Barclays and Nationwide to fund all my regular savers

francoghezzi

SH88SH88 said:

Has anyone who does the payments manually ever had problems with payments being blocked by the Fraud dept ? ... some of the banks/BS's Fraud teams/algorithms seem overly keen so I would've thought many manual payments in a short timeframe would attract attention.

Stay far, far away from Co op. I had my payments blocked 3 times in 2 months and without a single phone call or message from them. The money sent to Skipton just disappeared from my account and the first time I spent an entire night wondering if I had sent my payment to someone else only to find out the day after that had been blocked. Never ever again with these people. I had to wait 40 minutes to talk to someone and spent almost an hour to repeat again and again that no one was asking me to move my own money. They need a therapist, a good one.