How to Track Your Finances in 2024 | Automated Google Sheets Template

This finance tracker is the perfect tool to manage your income and expenses. Automate your progress and see your spending across all categories in just a few easy steps. See how the full sheet is made and take control of your financial situation.
To download a full template of this spreadsheet follow this link:
docs.google.co...
(Need to first make a copy in order to edit)
#googlesheets #excel #finance

[@wooloopy8999]

hi! how do i change the currency and date without having to redo the whole thing by myself? it breaks whenever i change it to euro and day/month/year

[@avdb683]

LMAOOOO I was working with you step by step through the whole thing, making my own as you go along) only to hear at the end you have a template 😭😭😂 thank you for all the work in putting this together though, it’s great!

[@4on4off]

This has been so helpful and easy to follow. Thank you very much!

[@NadiaBro-v7g]

Thank you so much Brian, this is very helpful. I do have the same question about the "sort" option for the date.

[@EMH9823]

I like the setup. How can I add all my bills with due dates? I want to add another tab for that.

[@kushagrachoudhary9190]

=SUMIFS(Journal!C:C,Journal!B:B,C3,Journal!A:A,">="&S6,Journal!A:A,"

[@pedrugomez1]

thanks Brian great job ! i initially tried using the template but as i have more transactions' and columns the formula was not working effectively . anyhow i finally went step by step and completed the sheet . regarding the journal as i have almost 70 transactions monthly on average are we able to create another duplicate journal on the side that will pull the data across , as the single journal sheet over the year will be very lengthy and have more than a thousand transactions .. not sure what i'm asking makes sense, keen to know if you are able to guide . yours is the best spreadsheet i've seen so far , been searching for ages.

[@EKClegacy]

Thank you Brian - great sheet. I love learning about how to create the formulas.

[@brianturgeon]

Thank you so much!

[@sabrina_greene]

Hey, Brian! thank you for this template! The SUMIFS formula in the Net Income sheet doesn't work, it says "this argument need to be a range". Does anybody else have the same problem?

[@DevinSoetjipto]

What a lifesaver. So gonna use this to manage my personal finances in 2025. You rock!

[@johnnunez1086]

Will the template also work in Microsoft Excel if I copy and pasted or would I have to build it in Microsoft Excel seperately from Google Sheets?

[@charmlazaro6356]

Okay. So I just saw this after watching the other video you have for 2023 and copying the link you shared for it. 😄

[@taniascott104]

I used your 2023 version for my work. Question is, how can I figure out how much I made from each person?

[@sp3mistr]

this was simple and easy to follow! if you wanted to have a method for tracking savings and investments, how would you recommend going about this?

[@sarag5814]

How do I purchase a template? NVM I found it. Thank you!

[@loriCollins-c6f]

Love the videos, why when i add an expense on my journal for one month does it show up as the following months of the year ?

[@luiv9264]

how do I make all the revenues throughout the month add eachother by its self

[@picklepete112]

LETS FUCKING GOOOOOO

[@camioneur]

I've been using your first spreadsheet on this topic for a year or so now which is great and this one looks even better, cheers Brian

[@brianturgeon]

@@camioneur Glad to hear! Hope this one works for you too

[@sheisatabbym6014]

This is fantastic, exactly what I needed. Thanks so much.

[@brianturgeon]

Thank you!

[@adamthemulch]

hey how would i go about adding another column in the formula for like investments coloumn

[@jessperrett4663]

Brian, your teaching is so easy to follow and very helpful! This has helped me understand sheets and formulas so much better! Thank you!

[@willrogers9932]

Thanks so much for this. I prefer this over software. I hope to see a new one next year!

[@bboyExia]

Love it, instead of doing additional criteria checking for the dates and months. I just created a column that pulls the month name out. And ran the criteria check against that

[@anonymousanonymous7770]

How would I go about adding a date I forgot to the earlier dates? Is there some sort of “sort” function to filter the dates out if I just want to see one date?

[@alpicoo]

2:25 16:45

[@barbeque701]

if i were to reuse this template for 2025, do i just change the dates?

[@ThomasBohan]

Brian, thank you very very helpful

[@hanan4882]

New subscriber. thanks for this

[@sunalogy]

This is what I was looking for

[@dev-akeel]

I ❤ it, and I need even more advanced an updated.

[@raspotdigs]

thank you so much!

[@sunalogy]

Amazing one...

[@brianturgeon]

Thank you!

[@flavialima5815]

Thank you!