The Top Regular Savers Discussion Thread

1243244246248249

Comments

  • dingling68
    dingling68 Posts: 302 Forumite
    Part of the Furniture 100 Posts Name Dropper
    First Direct Regular Saver 

    Just logged on and although the money isn’t yet showing in my saver account, the “your account is maturing” message was no longer showing and I was able to open a new regular saver  :)
    First Direct Regular Saver

    Money was in the savings account some point between this post yesterday and this morning. Transfer is dated yesterday 😊
    Save £12k in 2022 #54 reporting for duty 
  • clairec666
    clairec666 Posts: 60 Forumite
    10 Posts
    mhoc said:
    s71hj 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.
    What is missing from this chart is the actual account number - I seem to think HMRC list your savings interest with the account number ... although Ive not seen a HMRC interest list ...
    Not "missing" but "removed for security reasons"!
    You can add whatever columns you want to the spreadsheet, I just stripped it down as an example people could copy if they liked.
  • rallycurve
    rallycurve Posts: 187 Forumite
    Fifth Anniversary 100 Posts Name Dropper
    I'm very impressed on how quick Principality is reacting now.
    I remember when rates were going up, it took them about a month or so to decide the increase on the variable rate accounts...
Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 349.9K Banking & Borrowing
  • 252.7K Reduce Debt & Boost Income
  • 453K Spending & Discounts
  • 242.9K Work, Benefits & Business
  • 619.7K Mortgages, Homes & Bills
  • 176.4K Life & Family
  • 255.8K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.1K Discuss & Feedback
  • 15.1K Coronavirus Support Boards

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.