Multiple Regular Savers - maintenance

clairec666

For each account, I have a column for:

interest rate (plus whether it's fixed / variable)

minimum/maximum monthly deposit, and whether you can skip months

allowed withdrawals

maturity date

and a column for each month so I can tick off when I have made a deposit each month

There's some extra information on my spreadsheet, but those are the main things for you to get started with

Dugal

I also have columns giving a look ahead of future funding requirements and total future balance in all RS accounts , if fully funded. Useful if you have limited funds to put into your RS accounts.

Pickledonionlover

This is a the top of the tab for May for me.

Colour coded (green for easy instant access) and ordered by closest maturity date.

Currently has just less than 100 rows and I've been running with it for close to 20 years with a tab for each month.

I record individual (and total) interest (and account number) for all RS and non RS on a separate spreadsheet. A tab for each tax year and a column for each month for accounts which pay per month and a total column. Then a grand total row.

Good luck - it's addictive

surreysaver

I list mine in order of maturity, with ongoing ones such as RBS/NatWest at the bottom.

The first column is the maturity date, then organisation name/account name and min/max amounts. I also record a history of the percentage rate with dates for variable accounts in this column.

Then is the rate fixed with a simple Y or N in the column.

Then does it allow withdrawals with a Y or N or L for limitations on withdrawals with a description. I also colour code the Y/N/L with green/red/yellow to make them easily distinguishable.

Then % rate.

Then account details.

The particularly wide second column I just shrink, as the information doesn't need to be readily readable every time I open the spreadsheet.

It's just occured to me I may need to add a column indicating whether the account has to be operated in person or online, as I tend to travel the country opening branch only accounts

nottsphil

Then, is the rate fixed with a simple Y or N in the column.

Or a less complicated F or V...

surreysaver

https://forums.moneysavingexpert.com/discussion/comment/81994616#Comment_81994616

Now that you mention it, that is what I have done 👍