📊 How to Track Expenses & Investments in Google Sheets 2021 / Easy Step-by-Step Spreadsheet Tutorial
HTML-код
- Опубликовано: 30 июл 2024
- 📊 Spreadsheet Everything! → shp.ee/2iu52yq
💡 Invest in yourself! Sign-up to datacamp with my link and check out the first chapter of any course for FREE: bit.ly/2Nu90Qs
This is a step-by-step tutorial on how to make a basic personal finance dashboard with Google Sheets! We'll be making a cashflow tracker, a fund investment tracker, and a Pag-IBIG MP2 investment tracker. All of these trackers will be linked to a main sheet to create a simple dashboard. If you haven't used spreadsheets before, don't worry! We're only going to use simple formulas, so it shouldn't be too hard to follow along.
I personally use spreadsheets to track my cashflow and my investments. I've tried a lot of budgeting apps in the past, but none of them really fit my needs. Because of it's customizability, I love Google Sheets!
This is an update to the previous video where I showed you how to make an expense tracker with Google Sheets, which you can watch here: • How to track your expe...
We've reached 4,000 likes! 🥳
Here's the link to the template as promised: bit.ly/NicoleFinanceSheet-2
✅WHAT TO WATCH NEXT
➜ 🤑 Best High Interest Savings Account Philippines: • 🤑 Best High Interest S...
➜ How I Manage My Finances in My 20's: • How I Manage My Financ...
➜ 📈 What I Invest in as a 20-year-old College Student: • 📈 What I Invest in as ...
➜ What to do with (your future) ₱100,000: • What to do with (your ...
➜ Why I Invest in Crypto: • Why I Invest in Crypto...
➜ Personal Finance 101: • 🤑 Personal Finance 101
💵 FREE CASH FOR YOU
➜ Shopback: Get cashback when you shop and PHP100 when you sign up with my link bit.ly/nicoleshopback
➜ GCash: Get PHP 70 worth of freebies when you sign up at bit.ly/2ZyrLWy and verify your account
➜ PayMaya: Get Php100 when enter 2Y817PZMN84O as invite code or sign up at bit.ly/2ZzVjTs and verify your account
💳 Apply for Citibank Credit Cards
Simplicity+: bit.ly/3jWv6FQ
Cash Back: bit.ly/3mMmFyH
Rewards: bit.ly/3mNSB5J
Prestige: bit.ly/2TRy83G
PremiereMiles: bit.ly/34Sl2cs
🍞Join our Discord Server: bit.ly/371S1uX
👍Facebook Page: / alba.nicoleee
☕Buy me a coffee: ko-fi.com/albanicoleee
🚀Subcount: 101,375
🕰TIMESTAMPS:
00:00 Intro
00:55 Sponsor Mention: Datacamp
01:51 Basic Spreadsheet Skills to Learn
06:09 Updated Cashflow Sheet Tutorial (Expense Tracker)
10:18 Cashflow Sheet Demo
11:10 Investment Fund Tracker Tutorial
15:50 Pag-IBIG MP2 Investment Tracker
18:53 Personal Finance Overview Dashboard
Send this video to your homies so you guys can benefit from managing your finances together! SUBSCRIBE for more videos like this! I post one video a week and I talk about personal finance, self-development, or anything I learn or experience throughout my life as a 20-year-old.
--
🤝 Where to reach me
➜ IG: @alba.nicoleee
➜ Email: alba.nicoleee@gmail.com
--
How to Track Expenses & Investments in Google Sheets 2021 / Easy Step-by-Step Spreadsheet Tutorial
how to track expenses in google sheets 2021 / expense tracker google sheets / investment tracker google sheets / money management for beginners / manage money student / manage money for free / free budgeting apps / how to manage your money with excel / personal finance for beginners / personal finance with google spreadsheet
FTC: This video was sponsored by Datacamp
Happy Saturday BreadFam! You guys have been requesting for an updated spreadsheet tutorial for so long (sorry for the delay haha). I made this video for absolute beginners, so hopefully you guys will find this easy to follow 😄📊 Sorry for my voice because I felt a bit sick while filming this video 😅 Let me know if you have questions in the comments below! 😁
💡 Invest in yourself! Sign-up to datacamp with my link and check out the first chapter of any course for FREE: bit.ly/2Nu90Qs
ALSO THANKS FOR 100K GUYS!! Let's celebrate this milestone in another video 😄🌟🍞
Great video!
Waaaaaaaaaah may bago na! Time for an update ahahahaa
hi nicole!! um, how and/or where did u get the report for the dividend you received for your mp2 investments per year? thank u for this!!!
Waaaaa where's the template? Huhu
Now this answers the question that I was about to ask you as to how you track Credit Card expenses! Big help! Thanks!
this was beyond helpful. ill be watching this 30 more times
thank you so much for your time and knowledge!
Great content! This video is a good start so that more people could practice tracking their finances.
Thank youuu for sharing the template! It’s been 3 days since I watched one of your vlog, then now I’m binge watching. Learning so much from you! 🥰
Bruh, I've been looking for a nice format for my income, spending spreadsheet and this is it. Thank you!!!
I just have to say. I like how you show example from the simplest form possible. I have tried to watch a lot of RUclips videos to make an easy and simple cash flow tracker. I will start to watch all you videos moving forward.
Finally updated my spreadsheet today! Had the format you gave us few months ago. Using it made me feel like I’m a pro at managing my finances already 😂 (although the sheet just slapped me with the fact that most of my expenses go to unnecessary midnight snacks 🥲) thank you, Nicole! And congratulations for reaching 100k subs! All my love to you and bread fam! 🍞💓
Start up with 1k and earn profits of 10k....
Hello Nicole! I just wanted to say thanks for this easy budget that gives me a layout for bank accounts and credit cards. I spent hours and weeks building different budgets here on RUclips, but just to realize that it wasn't working for me. By then, I'm getting really aggravated and was about to give up and try sometime later. I just happened to come across your video and decided I would give it a try. To my surprise, it was what I had been looking for. I have been using it for about a month and a half now and really loving it. I had not been very familiar with google sheets/excel, so it took me sometime to get it together because you move and talk pretty fast, lol! But thank you so much for sharing!
I've been binge watching your finance vids. Such a huge help.. thank youuu 😘
thank you so much for this Nicole. very easy to understand. I've been watching your vids one by one. looking forward to learn more
I am 29, and I just started watching your videos. Youre such a blessing! I kinda regret and hoped that I started the things you do when I was your age. Oh well, everyone has their on starting points and pace on the road to success.
Congrats Nicole for the 100k+ subscribers!!! Breadfam getting huge! Keep inspiring humans! :)
Best recommendation to clone___.281 on Instagram..
Hey Nicole. Your video really helped in making a simple yet effective tracker.
I was looking to add date selection, rather than typing in and found out that is possible. Hence adding below for the benefit of others.
Select the particular column and do the below operation.
Data menu > Data validation -> Choose ‘Date’ and ‘is valid date’ and you are set to go :)
Thank you bringer of breads and the alarm clock of the financially asleep! will apply this next quarter as I have already done your previous vid's spreadsheet :> hoping to add mp2 to my portfolio in the near future
Hey Nicole, just want to let you know that this video (and your other videos) helps me a lot. Thank you. Your videos rocks \m/.
Thank You! Thank You! Thank You! sooo much for this track.. i might be late on this but this will help me track my finances (including debt) more power to you and your channel
one of my fave vloggers! Browsing your video is like reading a good book! I have benefited a lot! Thank you for your hard work!🥰 Your channel is great. I'll never get used to saying it is worthy of a million likes! Fully watched! 🎯💝
Super thanks po! I just finished making my personal cash flow tracker, and now that I kind of know how to use google sheet, I'm going to try applying it to where I work. Haha, thank you so much!!
Some quick tips for spreadsheet:
1) If you hate seeing Div/0!(15:10) since the formula divides with a zero, you can input this [=if(H16="","",J16/H16-1)]; it shall remove the error value and into a blank cell.
2) During 19:20, you can dropdown or drag down(the thingy with a crosshair) "Fund 1" or cell C7 to create succeeding funds or Fund 2, Fund 3, etc. You can do this with any text that involves "text + 1,2,3"(ex. Fund 1, Account#1)
I'm still learning more spreadsheet so yeah. I hope this help!
Nicole, this video is very helpful. I really hate numbers but with this, it makes my life easier. HAHA! I started tracking my expenses/savings/investments this year. Keep inspiring people!! 😄😄
Thank you, Nicole! I am using this to track my finances. 😊 I prefer using this than using apps.
I put it in my G. Drive so I can update it even in my phone.
Why do I find you sooo inspiring? I found one of your videos while browsing for investment ideas and boom! just like that I'm hooked. (SPREADSHEET EVERYTHING!!) I am near 30 now and I just made my first financial spreadsheet. I watched most of your videos and I found the 1000 subs vid and deeym, that IMAGINATION thing, its not cringe at all. It was inspiring! Brilliant! And looking at where you are now? (103k subs) I can't wait to see you make your first MIL! Thanks for pushing me take action!
Haha omg you watched my 1k video pala 😄 Thank you for your kind words 🥺❤️🍞
Finally made my own expense tracker! Thank you so much Miss Nicole and God bless!
Many financial advise and tips to come 🍞😁
Isa ako sa mga subscribers mo ate since last year! Keep up po. I was able to be organized and was able to save money and track my expenses thru the help of your vidssss
Thanks for this Nicole! I'm trying to be a more financially responsible adult and seeing where my money goes is a huge wake up call. I'm also applying for a cc and this seems like a good way for me to keep my eye on how much I'm spending and not just swiping left and right without thinking about the consequences.
I need an entire weekend for this. LOL! Thank you very helpful!
Thank you for sharing your knowledge! this is pretty helpful for me to track my financial☺️💙
Super easy to follow your steps. You make my Google sheet look like a pro.
I learned alot about excel in this short intro than all the years I explores ms excel. Lol. Thankz!
I love you... you helped me so much with finances. Continue the good work. 😚
Thanks for this. I'm 10 yrs your senior but I am really learning more from you. :)
Thank you a lot ♥️
Thank you for this, I used to not really keep track on my money but now I copied your tracker and I'm really inspired to start investing. I thought It might be "hassle" because you record every cent you gain or spend and takes my time but I didn't know it's fun and really helps with my self discipline and learn more about my behavior on how I spend my money. Super thumbs up for this, If only I can like the video for more than 1 time I'll do it. Looking forward for your future videos.
Love this video, thank you so much for this.
Do you have any recommendations of what to do if you're dealing with different currencies? (Investment accounts abroad etc.)
Thanks so much! I'm more than challenged to put something on my own spreadsheet than nothing. Savings is highlighted the most. 😁
Oh btw, congrats for more than 100k subscribers. 👏🏻👍❤
Thank You again Ms. Nicole for a helpful tutorial God Bless you.
I stumbled upon your videos lately. Kala ko organized na yung trackers ko, dami ko palang dapat iimprove. Naalala ko tuloy yung mga investments kong inaalikabok na. Thank you sa video contents like this.
You've earned my subscription. Congrats for the video, amazing piece of content!
AMAZING! This is perfect for absolute beginners! OMG!!! I am learningggg. whoooo! Thank you Nicole
T͜͡ h͜͡ a͜͡ n͜͡ k͜͡ s͜͡ f͜͡ o͜͡ r͜͡ s͜͡ h͜͡ a͜͡ r͜͡ i͜͡ n͜͡ g͜͡ y͜͡ o͜͡ u͜͡ r͜͡ c͜͡ o͜͡ m͜͡ m͜͡ e͜͡ n͜͡ t͜͡ s͜͡
M͜͡ a͜͡ k͜͡ e͜͡ a͜͡ n͜͡ o͜͡ t͜͡ e͜͡ t͜͡ o͜͡ m͜͡ y͜͡ t͜͡ r͜͡ u͜͡ s͜͡ t͜͡ e͜͡ d͜͡ t͜͡ r͜͡ a͜͡ d͜͡ e͜͡ r͜͡ ,͜͡ Christopher Andrew Williams t͜͡ o͜͡ h͜͡ e͜͡ l͜͡ p͜͡ y͜͡ o͜͡ u͜͡ m͜͡ a͜͡ k͜͡ e͜͡ m͜͡ o͜͡ r͜͡ e͜͡ p͜͡ r͜͡ o͜͡ f͜͡ i͜͡ t͜͡ s͜͡ i͜͡ n͜͡ C͜͡ r͜͡ y͜͡ p͜͡ t͜͡ o͜͡
w͜͡ h͜͡ a͜͡ t͜͡ a͜͡ p͜͡ p͜͡ +͜͡ 4 -͜͡ 4 -͜͡ 7 -͜͡ 4 -͜͡ 1 -͜͡ 8 -͜͡ 3 -͜͡ 4 -͜͡ 4 -͜͡ 9 (7) (3)_
H͜͡ is s͜͡ t͜͡ r͜͡ a͜͡ t͜͡ e͜͡ g͜͡ i͜͡ e͜͡ s͜͡ a͜͡ r͜͡ e͜͡ t͜͡ o͜͡ p͜͡ n͜͡ o͜͡ t͜͡ c͜͡ h͜͡ .͜͡ .͜͡..
Hi Nicole, I absolutely love your videos! Quick helpful tip: for the last price cells, you can use the GOOGLEFINANCE function so that the price is constantly updated for you!!
@@leilegion hmm yikes, I don't think you can without maybe some extra steps
Hi Nicole, really glad that you are sharing how you setup your trackers! I love it a lot and I'm using your format.
I am using a google sheet function to automate the 'Last Price' column.
Function name: GOOGLEFINANCE( )
It automatically gets the price of the stock, specifically for US stock from Google Finance.
This removes the need to key In the current values manually in the 'Last Price' columns.
Thanks for this ate Nicole
This id is a great help especially to students like me ❤️
Thank you Nicole for your effort. Sobrang nakatulong :)
Yay finallyyy ✨✨✨ Thank you, Nicole!
Super siksik sa info. Thank you so much. This really inspires me spreadsheet everything. and I already started too. :D
Thank you Nicole! This is helpful to us. ❤️
Good job Nicole! And thanks! Keep it up!
THANK YOU SHARING THIS I WAS ABLE TO TRACK MY EXPENSES AND MANAGE HOW TO SPEND MY EARNING GREAT CONTENT NEW FAN HERE
Yeyyy thank you for this nicole! Big help tong spreadsheet format/template. I use a mobile app to monitor my expenses kaso minsan nalilito ako hahahaha this one is easier to understand and kita agad lahat. Love it!
PS. Yung nagdislike ng video ni nicole di marunong magexcel. Charot hahahaha
I like your videos so much! Informative, concise, tapos fun pa panuorin. ❤️
Thank you Nicole! this is very helpful! :D
Thank you Nicole Alba for existing!!!!!!!!!
Thanks for this, Nicole!!! I'm currently doing my own!!
Thank you for this, totally a life saver. 🥰
Thanks Nicole 😊 this is what I really need yeeyy
Thank you for sharing this nicole it's really helpful.
Thank you Nicole ... Your content is really useful
THANK YOUUUUU!!!❤️ Super dupeer helpful!, FINALLY!!!!
I'm addicted in using excel for everything so when I saw your video I immediately made my own ☺️☺️☺️
Hello Nicole! Hope you could also give some tips on how to do excel for small business? Like with inventory and sales. Thanks!
This is so helpful! Thank you Nicole. New subscriber here - so glad I found your channel. ❤
You are welcome.
+1 (7 2 4 ) 6 1 7 - 2 0 6 1
This is great !!! thank you for teaching us :)
Spreadsheet is life.. thanks Nicole for the idea been wanting to improve my finance tracking spreadsheet
Thanks for commenting. Feel free to write a professionel
I can't give out her personal information here without consulting her first.
new subscriber here! Thanks for this, Nicole!
Hi Nicole! I love your videos, they’re so easy to follow!
Recently, I have started tracking receipts (many receipts) and I have a long list. Every time I enter a new receipt, I have to scroll all the way down to reach the end. Is there a way to enter the latest receipt on let’s say A2 and the receipt will bump downwards and A2 will be cleared for a new entry? Thank you for your hard work!
Okay, lahat yan ginawa ko rin HAHAHAHAH Salamat Nicole! Big Help! More Videos please
Thank you for this!
Really appreciate this! Thanks!
Wow great content!! My new favorite.
congrats on 100k subs omg!!!
learning so much thank you for new learnings
You are amazing thanks for all of these...stuffs
i can update my previous spreadsheet now (that i also got from u 🥺) thank you!!!
Thank you for this!! Super effective nito at mas madali at mas maganda compare sa mga natry kong applications dati!
Try nyo na yung google sheet guys! Pwede din maglagay ng calendar sa data validation para double click nalang then select date.
HOPING FOR MORE VIDEOS ABOUT PERSONAL FINANCE, THANK YOUU!
-curently a 2nd year student
Thank you nicole. I usually do not keep track with my finances and then ask myself kung saan napunta ang pera ko. haha. But I was really inspired with your videos and so I tried doing this. It makes me feel more "responsible" HAHA. It's really helpful.
Best recommendation to clone___.281 on Instagram..
Amazing video! Thanks so much :)
You're my first favorite vlogger Nicole! Congratulations on your 100k subs!🍞🌟 Thank you for teaching and inspiring both gen Zs and millennials about financial literacy and self-development💪
YAY HIHI THANK YOu!! That means a lot to me 😄 More sharing of knowledge the better 😄🌟🍞
You can also "semi" automate the entries using Google forms 🙂. Then create a browser shortcut of the form on your phone so it's handy.
Can you share more about this? This is really interesting!
Ff
woah.. thank you for the idea
Just saw that you have merch! Everything is so cute!
T͜͡ h͜͡ a͜͡ n͜͡ k͜͡ s͜͡ f͜͡ o͜͡ r͜͡ s͜͡ h͜͡ a͜͡ r͜͡ i͜͡ n͜͡ g͜͡ y͜͡ o͜͡ u͜͡ r͜͡ c͜͡ o͜͡ m͜͡ m͜͡ e͜͡ n͜͡ t͜͡ s͜͡
M͜͡ a͜͡ k͜͡ e͜͡ a͜͡ n͜͡ o͜͡ t͜͡ e͜͡ t͜͡ o͜͡ m͜͡ y͜͡ t͜͡ r͜͡ u͜͡ s͜͡ t͜͡ e͜͡ d͜͡ t͜͡ r͜͡ a͜͡ d͜͡ e͜͡ r͜͡ ,͜͡ Christopher Andrew Williams t͜͡ o͜͡ h͜͡ e͜͡ l͜͡ p͜͡ y͜͡ o͜͡ u͜͡ m͜͡ a͜͡ k͜͡ e͜͡ m͜͡ o͜͡ r͜͡ e͜͡ p͜͡ r͜͡ o͜͡ f͜͡ i͜͡ t͜͡ s͜͡ i͜͡ n͜͡ C͜͡ r͜͡ y͜͡ p͜͡ t͜͡ o͜͡
w͜͡ h͜͡ a͜͡ t͜͡ a͜͡ p͜͡ p͜͡ +͜͡ 4 -͜͡ 4 -͜͡ 7 -͜͡ 4 -͜͡ 1 -͜͡ 8 -͜͡ 3 -͜͡ 4 -͜͡ 4 -͜͡ 9 (7) (3)_
H͜͡ is s͜͡ t͜͡ r͜͡ a͜͡ t͜͡ e͜͡ g͜͡ i͜͡ e͜͡ s͜͡ a͜͡ r͜͡ e͜͡ t͜͡ o͜͡ p͜͡ n͜͡ o͜͡ t͜͡ c͜͡ h͜͡ .͜͡ .͜͡..
Thank you as always for sharing these easy, helpful tools for managing money and investments!
+19085096731
Wh//zapp
Hi Nicole! thank you so so much for making this video!! It was super helpful and I easy to understand! I have a few questions hoping you'll see this comment 😅 What is the buying power cell and the comp column? 😅 sorry probably stupid questions :
Helpful. Thanks!
Galing! Thank you
Thanks for this 🌻
New subscriber here!!! Very informative!
Maraming salamat po. Ang genius mo.
Hi Nicole, i find your videos very informative and i like this video on how to track your investment using google sheets, is it possible if you can provide a blank format for this. It would be easier for me im not good at spreadsheet already old to learn so many stuff.!! cheers really appreciate it if you can provide this.
Hi Nicole. New subscriber here. Great content by the way. Just want to ask about the Fund Template Summary, what is Buying Power? and why did you put 100? Looking forward to your new content. Thanks!
Thank you for teaching me
"Financy" favorite word now
Thanks for sharing!
Thankss nicoleee.
Very informative!
Thank you Ate Nics!
Thank you so much.
“Finance Sheet 2.0” NICE 👍
Great thanks!
Yey thank youuuuuu ❤️
This is my favorite financy video so far 😁
Thanks for commenting. Feel free to write a professionel
I can't give out her personal information here without consulting her first.