We’d like to remind Forumites to please avoid political debate on the Forum.

This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.

📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!

Moving on

1233234235236238

Comments

  • badmemory
    badmemory Posts: 10,208 Forumite
    Ninth Anniversary 10,000 Posts Name Dropper
    I'm not going to be any help!  What you have on your spreadsheet depends on what you yourself want to know.  I have 3, one of which is housekeeping which is because DS used to pay his share, he no longer does because it seems pointless me accumulating money when it is all going to him anyway, but it becomes an item on my 3rd sheet.  Another which gives all my savings & when interest is due & where it is going to come from when I suddenly decide to spend £11k on solar!!
    The 3rd is my bank account, well the estimate of it.  All the way to 31st December 2026.  It means those nasty repeating items don't get forgotten.  Being a bit anal I also track every penny of my credit card cashback.
    I made the mistake of comparing housekeeping over the last few years.  10% a year is the polite version.
  • Generally I just have a dashboard format where I have two boxes. One for costs (sum of outgoings) one for remainder which is income minus costs. 
  • Cherryfudge
    Cherryfudge Posts: 14,281 Forumite
    Part of the Furniture 10,000 Posts Name Dropper
    They do short courses on Excel, a friend of mine is doing one next week. I can do the basics, simple sums and formulas. I'm happy to show you my spreadsheet if that helps? I have dds/bills in columns for each of my 3 bank accounts, another column for food/fuel etc, then those totalled and subtracted from my incoming wage to show how much I should have left for overpayments.
    That would be very useful thanks @Rhyddid2026. I'm not sure my simple layout is the best, even though I've reduced the categories. I've had a look at the Excel courses, and can get a certain way through but I think I need a person to teach me. I got a place on a local course but they withdrew the date I could do, so it never happened.

    badmemory said:
    I'm not going to be any help!  What you have on your spreadsheet depends on what you yourself want to know.  I have 3, one of which is housekeeping which is because DS used to pay his share, he no longer does because it seems pointless me accumulating money when it is all going to him anyway, but it becomes an item on my 3rd sheet.  Another which gives all my savings & when interest is due & where it is going to come from when I suddenly decide to spend £11k on solar!!
    The 3rd is my bank account, well the estimate of it.  All the way to 31st December 2026.  It means those nasty repeating items don't get forgotten.  Being a bit anal I also track every penny of my credit card cashback.
    I made the mistake of comparing housekeeping over the last few years.  10% a year is the polite version.
    Eek to the 10% - price increases are hair-raising, aren't they? Especially if you go back a few years and think that it's all compounded each year since.

    You're right that I need to work out what I want. I'm struggling with that but I think at a basic level I want to know if we are spending unreasonably or money is leaking out where it didn't orta.

    Years ago, we put everything we could onto automated payments, so there are lots of DDs and SOs which keep going out steadily, mostly against DH's income, which is steady. Mine isn't, so I have to keep an eye on that account so there's enough for the outgoings there. There are also some savings accounts that aren't currently being added to so at some point I need to get DH to set something up. The trouble is that he likes to see money in the current account (well, don't we all - but not just accumulating if it's not earning interest). I have to catch him at the right moment and have the data ready for his new account.

    Generally I just have a dashboard format where I have two boxes. One for costs (sum of outgoings) one for remainder which is income minus costs. 
    I think this is roughly where I need to be, but the examples of dashboard courses look very fancy for my level of knowledge. I suppose if I work on the one I've got, I could experiment with background colours and bits like that to make it less of a wall of data. Not very financially helpful, but perhaps more approachable.

    A lot of the template ones seem to be American - I'd have a lot of wading through to change terminology, delete things that aren't applicable etc. I've downloaded the MSE one but it's needing all the data to get started, which is a faff as banking apps time out while I'm finding details and the laptop has decided not to talk to the printer, which is sitting quietly waiting for instructions. It does this sometimes - I have to uninstall and reinstall.

    I had a look at the Natwest app, as it has a basic budgeting facility but not a spreadsheet and, as far as I can tell, quite a bit of guesswork. It thinks we've spent X amount on food, but actually that's probably based on where we shop and if we bought clothes in the supermarket, it wouldn't know they aren't food.

    Never mind, at least I'm trying to engage with it so perhaps I'll make some progress somehow.
    I think a bit of sunshine is good for frugal living. (Cranky40)
    The sun's been out and I think I’m solar powered (Onebrokelady)

    Fashion on the Ration 2025: Fabric 2, men's socks 3, Duvet 7.5, 2 t-shirts 10, men's socks 3, uniform top 0, hat 0, shoes 5 = 30.5/68
    2024: Trainers 5, dress 7, slippers 5, 2 prs socks (gift) 2, 3 prs white socks 3, t-shirts x 2 10, 6 prs socks: mostly gifts 6, duvet set 7.5 = 45.5/68 coupons
    20.5 coupons used in 2020. 62.5 used in 2021. 94.5 remaining as of 21/3/22
  • Rhyddid2026
    Rhyddid2026 Posts: 892 Forumite
    Part of the Furniture 500 Posts Photogenic Name Dropper
    Drop me a message Cherry and we'll figure out if/how I can be helpful.
    Debts                04/01/25         02/01/26  
    Natwest2           £6,509.97       £5,500 
    NatWest CC      £7,612.74       £6,605
    Lloyds CC          £6,112.60      £4,450
    1st Direct CC     £176.03         £39.26
    CC total             £20,411.34    £16,594.26
    TSB OD             £500              £0
    1st Direct OD     £600              £0
    Car loan             £4,000           £4,000
    1st Direct Loan  £10,684.44    £7.880
    Total                  £36,195.78    £28,474.26
    EF £701.52
    HF  £3.04
  • WelshmansDaughter
    WelshmansDaughter Posts: 1,887 Forumite
    1,000 Posts Third Anniversary Name Dropper
    They do also have pre made templates in excel where you can drop your figures in. Or something like notion where you can pick a template
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
  • 353.1K Banking & Borrowing
  • 254K Reduce Debt & Boost Income
  • 454.8K Spending & Discounts
  • 246.2K Work, Benefits & Business
  • 602.3K Mortgages, Homes & Bills
  • 177.9K Life & Family
  • 260.1K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16K Discuss & Feedback
  • 37.7K Read-Only 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.