We're aware that some users are experiencing technical issues which the team are working to resolve. See the Community Noticeboard for more info. Thank you for your patience.
📨 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!

Yearly Personal Budget

Options
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,847 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,847 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
  • 351K Banking & Borrowing
  • 253.1K Reduce Debt & Boost Income
  • 453.6K Spending & Discounts
  • 244K Work, Benefits & Business
  • 598.9K Mortgages, Homes & Bills
  • 176.9K Life & Family
  • 257.3K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.1K Discuss & Feedback
  • 37.6K 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.