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.

The MSE Forum Team would like to wish you all a Merry Christmas. However, we know this time of year can be difficult for some. If you're struggling during the festive period, here's a list of organisations that might be able to help
📨 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!
Has MSE helped you to save or reclaim money this year? Share your 2025 MoneySaving success stories!

Yearly Personal Budget

2»

Comments

  • Hi everyone,
    These all sound great and exactly what i need! I find the month to month trackers online aren;t great at capturing those non monthly costs. I wonder if any of you would be willing to share a template of yourfor others to use? i find Martin's budget tool useful but it isn't the ongoing tracker I need, it's more of a review of the spending in one moment..correct me if i am wrong.
    thanks

  • I use a single spreadsheet, in Google Sheets, with separate sheets for
    • annual budget
    • Jan
    • Feb
    • Mar etc.
    I reconcile transactions to bank accounts each month and apply categories in the monthly sheets. This data is processed and shows up on the annual budget sheet.

    I can see the whole year's income and expenditure by category on one sheet, broken down by months. And I can drill down into individual transactions on the monthly sheets.

    I based it on the YNAB approach which really worked well for me but became expensive.
    3 bed det. built 2021. 2 occupants at home all day. Worcester Bosch Greenstar 30i combi boiler heating to 19-20C from 6am to midnight, setback to 17.5C overnight, connected in EMS mode to Tado smart modulating thermostat. Annual gas usage 6000kWh; electricity 2000kWh.
  • Keedie
    Keedie Posts: 2,979 Forumite
    Ninth Anniversary 1,000 Posts Photogenic Combo Breaker
    Did you create that google sheets yourself @InvertedVee or is it something that can be found online? I also need to get a realistic understanding of where I stand on an annual basis.
    Debt Free Diary:- The Mental Debt Struggle
    (Original Debt on 15/07/2016 was £33,056.76) 🙈 but Debt Free on 09/02/2025 🎉
    2025 SAVINGS: Emergency Fund (£604.30/£5,000) 12.09% saved
    2025 CHALLENGES: #16 Sealed Pot Challenge ~ 18 || #9 50 Envelope Challenge 22/50
  • Keedie said:
    Did you create that google sheets yourself @InvertedVee or is it something that can be found online? I also need to get a realistic understanding of where I stand on an annual basis.
    I did it myself. Took me ages!
    3 bed det. built 2021. 2 occupants at home all day. Worcester Bosch Greenstar 30i combi boiler heating to 19-20C from 6am to midnight, setback to 17.5C overnight, connected in EMS mode to Tado smart modulating thermostat. Annual gas usage 6000kWh; electricity 2000kWh.
  • Keedie
    Keedie Posts: 2,979 Forumite
    Ninth Anniversary 1,000 Posts Photogenic Combo Breaker
    I'll have to watch some YouTube videos and teach myself how to do this better @InvertedVee as a good spreadsheet can make such a difference.

    Debt Free Diary:- The Mental Debt Struggle
    (Original Debt on 15/07/2016 was £33,056.76) 🙈 but Debt Free on 09/02/2025 🎉
    2025 SAVINGS: Emergency Fund (£604.30/£5,000) 12.09% saved
    2025 CHALLENGES: #16 Sealed Pot Challenge ~ 18 || #9 50 Envelope Challenge 22/50
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
  • 352.9K Banking & Borrowing
  • 253.9K Reduce Debt & Boost Income
  • 454.7K Spending & Discounts
  • 246K Work, Benefits & Business
  • 602.1K Mortgages, Homes & Bills
  • 177.8K Life & Family
  • 259.9K 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.