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 👍

QQQQQQQQ_Y

Spreadsheets are useful because you can add/modify/delete/hide columns and rows as you go along. So beyond your initial thoughts about what is important they can be adapted and changed as needed.

Probably the biggest one to watch out for is filtering and sorting. If you have gaps between rows - for example you have one set of rows for ISAs and another set of rows for Regular Savers you won't be able to readily filter on these (because of the gap).

The alternative design would be to have all ISAs and Regular Savers in one table but with a column for account type which has the value ISA or RS in it (depending on account type) you can then just filter as needed.

The same applies to sheets - if you have one large master table you can filter (or reference to another sheet as needed), but if you have separate sheets based on a set of values then comparison becomes more challenging. It's a design preference you may want to play around with to suit your own style.