TIMESTAMPS 00:00 How I used to track my Personal Finances 00:47 Objective of this Personal Finance Tracker 01:18 Track Your Spending (step-by-step) 05:24 List Top 5 Expense Items 06:28 Track Your Net Worth (step-by-step) 08:44 Summary and Next Steps
Questions: in the column of bank 1, what does “from sms” mean? And can you give me some examples of company where they give stocks as a form of compensation?
@@TK-ml5pv From SMS means I get a text message everytime I spend money. So I can directly input the amount the SMS tells me (i.e. Jeff you have 100 USD left in your account as of August 1st)
@@TK-ml5pv Many many companies offer stocks as part of their comp package, a quick google search can help you there. Off the top of my head companies like Apple and Tesla would depending on the role you get
Back home in the UK and now here in the US, I've seen an unbelievable amount of people -- both youth and adults -- who have no idea, and/or possibly desire, to review their spend and income. Your template is great! Every week, I volunteer 2 hours at local non-profits to help families better understand their finances and how they can monitor their savings potential. I appreciate your efforts on this video as it's a very small learning curve for many and doesn't require heaps of dedication.
Absolutely! Thanks to your advice I have been able to have a lot of interviews with great companies (in Spain that is not easy) and I have landed a full time role as a UX Designer for Accenture (with little previous experience)! Keep helping others Jeff! 🙏 Now I will track my spendings and investments. Thank you!
I totally agree with the content of this financial tracker. Been doing it for almost two years as a 'cashflow' monitoring in excel and ever since I have been very aware of my income and expenses as I am actively informed on my expenditures that I would usually call irrelevant. Got new ideas as well and will definitely update my formula as well. Thank you for sharing and more power to your page! kudos!!!
Hey Jeff! love your organization content and your work, but I was wondering if you use a more in-depth technique or template including the expenses of each month (gas, car, food, fast food, outing etc. ...) to be even more intentional on the expenses that are not "essential" and that we can do without? It would be really sharp considering that your explanations are precise and the templates are pretty fun too! ✌
I hit subscribe before the video even went into 2 mins! Loved how simple and clear you made this aaand it got me excited about making my own spreadsheet Thank you 🙌🏼
Love this Jeff!! You helped with my job search & I stayed for the google hacks. How did you know this is the next thing I needed with my new job & considering relocating to Sf instead of commuting!
@@JeffSu For real though fam: I wish you the best. I think you are a real natural at this videomaking stuff, and your content is also really useful. Enjoy the rise and be well :)
What the hack!! Today I was thinking to start tracking monthly spending's and this video popped up right on top. Google algorithms working fine. Liked the content and you have one more subscriber
Sep. 1: ~feeling financially responsible by starting to track my August spending~ 💲Open my banking apps💲 *GASP* 😵💫 close the spreadsheet, close the app
Hi Jeff! Been a subscriber since last year when I was doing job hunting, now I'm preparing for my undergrad graduation ceremony then first corporate job (fortunate enough to get to choose which to go for, thanks to all your informative and eye-opening videos!), and this template comes in sooo handy as I'm trying to be more (adult-like) mindful with my spending habit, thank you so much! Till now I've been using only Excel spreadsheet like literally just list out all my spending every month and color code based on categories but it takes way too much time compared to this.. Definitely gonna try this out, and I'm interested in how you track your income as well, so super looking forward to that video! Love your dad jokes and your reactions after cracking them hahaha, keep them coming! Hope you're staying safe and sane~
Hey, thanks for sharing your BTS/process of how you organize your Income/Expenses. Really love your process with the Google Sheets, and I am gonna use your template to organize my Finances. I want you to make more content around Personal Finance and productivity around Finance and management! Thanks again Jeff 😃❤️
Since high school, I've created a Google spreadsheet to track all my income and expenses. After this video, I'm wondering if putting down every single spend (like individual purchases) is at all efficient anymore. I do categorize the different types of spend and such, but every end of the month I would have to sit down and put everything in. x__x
Hey Jeff, it's so amazing to see that you've nearly reached 100k subscribers. What a milestone!! I remember you telling me your plans to start a RUclips channel in early June/July 2020 in Ali Abdaal's discord server and was one of the first few hundred subscribers. It's so great to see your channel continue to grow and the high quality videos you produce. Now, it's the road to 500k subscribers!! 😎
Oh man, a OG viewer here! Thank you so much for your kind words Raihan, you have no idea how much that means to me. And I still can't believe you remember me from the discord server! Thank you 😁😁
Thanks, Jeff, for sharing your personal finance tracker. As usual, I got a lot of inspiration from your videos. And yes, I would love to learn how you track your sources of income :)
I do something a bit different: I write down all my Income and spending for the month in a massive excel spreadsheet. Each spending item is given a category and sub-category. Then I run a pivot table and look at the total for each category and add the final number to my NW. Still, I might adopt the final look of your Net Worth calculator :)
@@JeffSu You are always welcome! If you do want, I can share with you the spreadsheet (anonymised) and you can see what I do and how. It does take a bit more time than what you do, but it provides a bit more depth of the analysis.
Hi, thank you Jeff your template is indeed helpful for someone who beginner in financial tracker. I can’t find the way to change the currency in the spreadsheet. Is there any way to change the currency? Thank you!
Nothing quite like seeing for yourself how much you spent on nonessentials in a month 😂 It’s painful yet effective if you wanna curb future discretionary spending, no use in fretting over sunk costs after all And I really appreciate the thought you put into your tracker as well as the accounting principles you’ve applied :D Must be that EY experience coming in handy haha. Anyways, thanks for the video and the tracker! P.S. What’s your most and least favorite thing about the Sony WH-1000 (if that was an actual purchase)? 👀 I’m torn between that one and the Bose QuietComfort so I’m curious about what your thoughts are on it. And yes, I’ve been spending a lot on electronics lately 😂
Hahaha actually I did consulting in EY, I didn't really touch accounting. I actually did terribly in my accounting classes in college! So the joke in the video was the 8th edition of the Sony WH series (it's only up to 4 now), I did purchase the 4 myself but it's honestly the same as the 3, so for the price, I think the 3 is definitely worth it. I've tried my friend's Bose QC ii but I prefer the Sony ones more!
Ah, I forgot for a moment that you did consulting! Maybe it’s because of my major but now whenever I see mentions of the Big Four, I can’t help but only think accounting when in reality firms like EY actually offer multiple lines of service xD My bad my bad Oooh, can’t believe I missed that 😯 Man, I should have realized there was a joke involved when I saw Elon’s name right under it 😂 I’ll probably be ordering both headphones to try out myself but if I do decide on Sony then I’ll definitely go for the 3! Thanks so much for the feedback, Jeff! :D
Hey Jeff, how would you track an amount you transferred from your savings account to your current account for a bigger purchase? You will see this in the expense report but you can't add it to the income column since it's not new income
I was just looking for a nice template to start tracking my expenses for my first in-person university year and this is perfect! (As you also mentioned) I am quite interested in how you track your sources of income. Thank you so much! I love your channel and it has been super helpful!
I've been using the Google sheets templates for monthly and annual budgets, and they're pretty good. I like both ideas of writing down your top 5 spends (ooh err) and using the currency conversion tool (BTC to GBP!?)
Hey Jeff I appreciate you sharing template and the step-by-step tutorial! (and adding the background music too. It's subtle but a nice add) Can you make a video on how you plan out your budget? Incorporating the income tracking sheet would be lovely too
Thank you for doing this! I would love to see more about how to track your income and investments internationally. I have been using an excel sheet myself for a few years too, as it is a lot more customizable to my personal needs. Excited to see you do more of this! 😁
TIMESTAMPS
00:00 How I used to track my Personal Finances
00:47 Objective of this Personal Finance Tracker
01:18 Track Your Spending (step-by-step)
05:24 List Top 5 Expense Items
06:28 Track Your Net Worth (step-by-step)
08:44 Summary and Next Steps
Questions: in the column of bank 1, what does “from sms” mean? And can you give me some examples of company where they give stocks as a form of compensation?
@@TK-ml5pv From SMS means I get a text message everytime I spend money. So I can directly input the amount the SMS tells me (i.e. Jeff you have 100 USD left in your account as of August 1st)
@@JeffSu ah ok, another way to check the account balance. And for the question 2?
@@TK-ml5pv Many many companies offer stocks as part of their comp package, a quick google search can help you there. Off the top of my head companies like Apple and Tesla would depending on the role you get
@@JeffSu thanks, did you make a video about tracking daily personal finances?
I'm a South African living in China and I'm so happy I came across your video. SO HELPFUL and applicable to me. I can't wait to get started. Thank you
No problem my friend 😁
Back home in the UK and now here in the US, I've seen an unbelievable amount of people -- both youth and adults -- who have no idea, and/or possibly desire, to review their spend and income. Your template is great! Every week, I volunteer 2 hours at local non-profits to help families better understand their finances and how they can monitor their savings potential. I appreciate your efforts on this video as it's a very small learning curve for many and doesn't require heaps of dedication.
Wow huge kudos to you! That's amazing to hear!! And thank you for your kind words, I try my best 😁
Just want to note that I was here before the 100k and the 1 million sub 😎
Hahaha thank you for being here Ebrahim!
Yes... @jeffsu you better remember us all when you become the RUclips sensation very soon..
@@ruchapande892 I’ll think about it 😉
Absolutely! Thanks to your advice I have been able to have a lot of interviews with great companies (in Spain that is not easy) and I have landed a full time role as a UX Designer for Accenture (with little previous experience)! Keep helping others Jeff! 🙏 Now I will track my spendings and investments.
Thank you!
I totally agree with the content of this financial tracker. Been doing it for almost two years as a 'cashflow' monitoring in excel and ever since I have been very aware of my income and expenses as I am actively informed on my expenditures that I would usually call irrelevant. Got new ideas as well and will definitely update my formula as well. Thank you for sharing and more power to your page! kudos!!!
That's awesome!! Glad to hear it 😁
That's one of the most simplest way of tracking the expenses and arriving at the next worth. Thank you, Jeff!
Thank you Praveen!! I like it to keep it as simple as possible!
I like how you respect the time of the viewers, great content
Of course! I do this for all of you so you all are the most important group!!!
Hey Jeff! love your organization content and your work, but I was wondering if you use a more in-depth technique or template including the expenses of each month (gas, car, food, fast food, outing etc. ...) to be even more intentional on the expenses that are not "essential" and that we can do without?
It would be really sharp considering that your explanations are precise and the templates are pretty fun too! ✌
Thanks for the idea Marc-Antoine! 😁
I hit subscribe before the video even went into 2 mins! Loved how simple and clear you made this aaand it got me excited about making my own spreadsheet
Thank you 🙌🏼
Glad to hear it Ayeisha!! Thanks for letting me know :)
Dude, this tracker is super helpful ! It's been the one I've stayed consistent with ❤️
Awesome! How many months have you been using it? 😁
Love this Jeff!! You helped with my job search & I stayed for the google hacks. How did you know this is the next thing I needed with my new job & considering relocating to Sf instead of commuting!
Glad to hear it Ann! Congrats on the new role, I hope you like it!!
Oh man I need this so bad... Hero Jeff
You're welcome Tom 😁
Jeff Su, I love you (more than before!)
Thank you 😁 (even more than before!)
@@JeffSu For real though fam: I wish you the best. I think you are a real natural at this videomaking stuff, and your content is also really useful.
Enjoy the rise and be well :)
@@daedra40 😁😁
What the hack!! Today I was thinking to start tracking monthly spending's and this video popped up right on top. Google algorithms working fine. Liked the content and you have one more subscriber
Thank you Rajeev!! And glad you found me today 😁, thanks for being here!
When I go to the link to check the template it shows me 404 error. There is no free template available there.
which link are you using? Can you share?
I dont know if giving my data to Google is much better over Intuit…
An offline solution might be what you're looking for then 😁
just loved the video
getting to know these at the age of 18 so that i can start early is soo much good
Glad to hear it Kanav!! I wish someone taught me this in high school 😅
@@JeffSu yaa I am soo grateful to that.... There is soo much info on internet and mainly on RUclips.
Really happy to find your channel... 🤗😍😍
I'm so old school I still use Microsoft Money 2004. Ties me down to a Windows PC though.
Thanks for sharing Mark! If it ain't broke...! 😁
Laughed out loud when I saw the amount you received back in the payment app, 0 yuan. We all have those friends.
Hahahaha I know right?
U literally are changing my life. thank you
You're very welcome 😁
Sep. 1: ~feeling financially responsible by starting to track my August spending~
💲Open my banking apps💲
*GASP* 😵💫
close the spreadsheet, close the app
That's happened to me the first few times not gonna lie 😛
It's like you read my mind! That's exactly what I need
Maybe I did 😉
HI jeff, loved this video
Pls make a video of top 10 Apps for productivity as well (my suggestion )
Thanks for the idea Mohit! But in my personal opinion the best apps for productivity are the ones that you're already using and works for you :)
Your videos have taught me so much, I cannot say enough how grateful I am!
It's my pleasure 😁
Thanks Jeff! Financial responsibility, with an emphasis on investment and saving, is a great life lesson.
Agreed!!
100k soon bro 😎
yessirrrr 🙌
I see jeff's video i click on the video ❤️
And hopefully watching them 😉
You're nearly at 100k🔥
Yasssssssss 😁
Hi Jeff!
Been a subscriber since last year when I was doing job hunting, now I'm preparing for my undergrad graduation ceremony then first corporate job (fortunate enough to get to choose which to go for, thanks to all your informative and eye-opening videos!), and this template comes in sooo handy as I'm trying to be more (adult-like) mindful with my spending habit, thank you so much! Till now I've been using only Excel spreadsheet like literally just list out all my spending every month and color code based on categories but it takes way too much time compared to this.. Definitely gonna try this out, and I'm interested in how you track your income as well, so super looking forward to that video!
Love your dad jokes and your reactions after cracking them hahaha, keep them coming! Hope you're staying safe and sane~
Glad to hear it, thanks for the kind words Ha! I'll try my best to keep it up 😁
my shortcut king 👑
Woohoo i LOVE that title 😛
Hey, thanks for sharing your BTS/process of how you organize your Income/Expenses.
Really love your process with the Google Sheets, and I am gonna use your template to organize my Finances.
I want you to make more content around Personal Finance and productivity around Finance and management!
Thanks again Jeff 😃❤️
Thanks for letting me know! Will do 😁
Since high school, I've created a Google spreadsheet to track all my income and expenses. After this video, I'm wondering if putting down every single spend (like individual purchases) is at all efficient anymore. I do categorize the different types of spend and such, but every end of the month I would have to sit down and put everything in. x__x
Hahahaha exactly! that's why I focus on the top 5 spending items :)
Your channel is pure gold! Thank you for your content 🙏
You're welcome!! Glad you're enjoying the content 😁
Possible to create a portfolio tracker? Thanks.
Like an investment portfolio tracker?
@@JeffSu exactly!
@@wueyTshuanMike I would recommend the one by Andrei Jikh!
Hey Jeff - love your content man. Wondering if you can offer up more details on your God's Eye View. Cheers!
Anything specific you'd like me to touch on?
Hey Jeff, it's so amazing to see that you've nearly reached 100k subscribers. What a milestone!! I remember you telling me your plans to start a RUclips channel in early June/July 2020 in Ali Abdaal's discord server and was one of the first few hundred subscribers. It's so great to see your channel continue to grow and the high quality videos you produce. Now, it's the road to 500k subscribers!! 😎
Oh man, a OG viewer here! Thank you so much for your kind words Raihan, you have no idea how much that means to me. And I still can't believe you remember me from the discord server! Thank you 😁😁
@@JeffSu No problem - keep up the great work!
DONATION TO ELON MUSK CULT. Love your videos man, keep going!
Glad you caught that Aryan 😂
Hey Brother!! The Document says unable to open this time.
Does it work now? :)
Greetings! Your link to the template is no longer valid! :(
Which link are you using?
Thanks for this ❤️…….Not gonna lie this needs to be a lesson for kids at school!
I wish someone walked me through this in high school for sure 😛
Thank you for sharing the template with us! 👍 Also, I’m looking forward to your silver button unboxing video soon👀 Keep up the great work!!
Haha thank you Daseul, I'm looking forward to that one as well 😁
Good job Jeff! I love it. But my partner is in charge of it lol Happy wife~ Happy life😄 Thanks for sharing anyway!
Hahahaha so Happy Wife Happy Life is true?? 😛
@@JeffSu In a certain extend definitely yes 😁
@@jamiewai618 I’ll take your word for it 😂
I think there's a problem with the file "Sorry, unable to open the file at present."
Have you tried again?
@@JeffSu unfortunately, same response :(
Thanks, Jeff, for sharing your personal finance tracker. As usual, I got a lot of inspiration from your videos. And yes, I would love to learn how you track your sources of income :)
Glad to hear it Yasmine! Yes I might make a video on that down the line as well :)
一口气看了5、6个你的视频 看见中文直接订阅了
哈哈哈谢谢你 Charlie 😁
Nice video
Thanks Tshepo!!
"Donation to the Elon Musk cult" hahahah good one 😂😭😂
Glad you caught that one!
Love this video. Will try it out.
Let me know how it works for you M T!
Imagine. A heart from Jeff
You don't have to imagine anymore 😉
Thanks
The next ali abdaal
Hahaha that's the dream 😉
Great video Jeff, the dad jokes are priceless, keep ‘em coming !
Thank you Tiago, will do 😁
Hi Jeff love your content is this spreadsheet still available?
It is! It's linked in the description 😁
I really like the list of x most expensive items you bought this month
Yes it's a great way to not waste time but still know what you spent the most money on that month!
yes we need your sources of income! great video btw
Thanks for letting me know my friend 😁
Doing the same thing on sheets as well. But in a more simple way since I'm not an excel expert =)
Wait but this was on Google Sheets 😅
Yes sirr! 🙆🏻♀️
😁 thanks Sreekant!
Love the excel. But I am not able to create a copy of it. Am I the only one facing this issue?
I just tested it, it works 😅
@@JeffSu Thanks! I tried it again from my different account, it worked! :)
@@priyankakumbhar8279 Nice!
I do something a bit different:
I write down all my Income and spending for the month in a massive excel spreadsheet.
Each spending item is given a category and sub-category.
Then I run a pivot table and look at the total for each category and add the final number to my NW.
Still, I might adopt the final look of your Net Worth calculator :)
That's actually a GREAT way to go about it! Pivot tables are so useful! Thanks for sharing Simeon!
@@JeffSu You are always welcome!
If you do want, I can share with you the spreadsheet (anonymised) and you can see what I do and how.
It does take a bit more time than what you do, but it provides a bit more depth of the analysis.
Thankyou Jeff , this videos really help me mange my finance
Glad to hear it Toni!!
Did you make that "Instagram Follow Me" graphic yourself? Is there a template for that?
My friend made it! I got inspiration from Vanessa Lau's version though
Learned a lot!
Glad to hear it Tyler!!
ty
You're very welcome 😁
Hi, thank you Jeff your template is indeed helpful for someone who beginner in financial tracker. I can’t find the way to change the currency in the spreadsheet. Is there any way to change the currency? Thank you!
The default currency? You can change it in settings :)
@@JeffSu Okay well, I’ll try that. Thank you Jeff!
Heyy did you find the way to change the currency?? plzz help
Love it! Exactly what I needed it 😁 and, yes please, talk about how do you track your income
Got it, thanks for the input Paula!
Second comment after Jeff 😜
And this is the sub-comment of the second comment after Jeff 😛
@@JeffSu 🤣🤣
Nothing quite like seeing for yourself how much you spent on nonessentials in a month 😂 It’s painful yet effective if you wanna curb future discretionary spending, no use in fretting over sunk costs after all
And I really appreciate the thought you put into your tracker as well as the accounting principles you’ve applied :D Must be that EY experience coming in handy haha. Anyways, thanks for the video and the tracker!
P.S. What’s your most and least favorite thing about the Sony WH-1000 (if that was an actual purchase)? 👀 I’m torn between that one and the Bose QuietComfort so I’m curious about what your thoughts are on it. And yes, I’ve been spending a lot on electronics lately 😂
Hahaha actually I did consulting in EY, I didn't really touch accounting. I actually did terribly in my accounting classes in college!
So the joke in the video was the 8th edition of the Sony WH series (it's only up to 4 now), I did purchase the 4 myself but it's honestly the same as the 3, so for the price, I think the 3 is definitely worth it. I've tried my friend's Bose QC ii but I prefer the Sony ones more!
Ah, I forgot for a moment that you did consulting! Maybe it’s because of my major but now whenever I see mentions of the Big Four, I can’t help but only think accounting when in reality firms like EY actually offer multiple lines of service xD My bad my bad
Oooh, can’t believe I missed that 😯 Man, I should have realized there was a joke involved when I saw Elon’s name right under it 😂 I’ll probably be ordering both headphones to try out myself but if I do decide on Sony then I’ll definitely go for the 3! Thanks so much for the feedback, Jeff! :D
@@Andrea_Dong You're welcome!
Do one sheet for business 👨💼 also
Thanks for the feedback Hisham! 😁
The link doesn't work anymore
Which links?
Hey Jeff, how would you track an amount you transferred from your savings account to your current account for a bigger purchase? You will see this in the expense report but you can't add it to the income column since it's not new income
Oh I don't differentiate between my savings and checking accounts. That gets too complicated too quickly haha
Amazing content as always!
Thank you so much An-Nien!!
Third comment after Jeff.
🌚😂
So...is this comment on the third comment after Jeff? 😁
Great video as always Jeff🙌🙌🙌
@@PedroFernandezRuiz thank you 🙌🙌
I was just looking for a nice template to start tracking my expenses for my first in-person university year and this is perfect! (As you also mentioned) I am quite interested in how you track your sources of income.
Thank you so much! I love your channel and it has been super helpful!
Glad to hear it Esha, and have fun during your in-person university year! (and stay safe!!)
I've been using the Google sheets templates for monthly and annual budgets, and they're pretty good. I like both ideas of writing down your top 5 spends (ooh err) and using the currency conversion tool (BTC to GBP!?)
Thanks Rupert!! Not sure they have BTC yet 😂
Notion Template ;)
For formulas and calculations, I still think Spreadsheet apps like Google Sheets / Excel come out on top vs. Notion though 😅
Amazing video Jeff.
Also, anyone know where I can find the animated background videi he uses?
Hi Kasuto! Which one?
Very informative and useful.
Thank you my friend 🙌🙌
This is great, Jeff! Another amazing and resourceful content!! #roadto100K
woohooo 🙌 thank you Y C!
Hey Jeff I appreciate you sharing template and the step-by-step tutorial! (and adding the background music too. It's subtle but a nice add)
Can you make a video on how you plan out your budget? Incorporating the income tracking sheet would be lovely too
Thanks for the idea Joyce!
一边开车一边听完的。
我今天心情不好,Jeff。
为什么呢~
@@JeffSu 不能出国。 困在家好难受。
Never split the difference ? Is that what I saw sir lol.
Haha yes, have you read it?
Thank you for doing this! I would love to see more about how to track your income and investments internationally. I have been using an excel sheet myself for a few years too, as it is a lot more customizable to my personal needs. Excited to see you do more of this! 😁
Thanks for letting me know Anne! Glad you found value from this!
Good sir how are you
Doing really really well :)
Exellent content👍 thank you
Thank YOU for being here! :)
Donation to the Elon Musk Cult!! haha
Sure, why not 😛
“I’m just a control freak.”
me: *subscribe*
hello fellow control freak 😂
Donation to Elon Musk Cult :')
😉
keeping tracking of expenses doesntt make you a control freak you fool.
I certainly think so! But so few of my friends actually do this...
I like how you respect the time of the viewers, great content
Thank you 😁
Link doesn’t work :(
This one? Just tried it, seems to work fine: www.jeffsu.org/personal-finance-tracker-for-beginners/