How to track your expenses in Google Sheets 2020 | Money Management Guide for Beginners and Students

In this video, we'll go over how to track your expenses in google sheets! This is an easy money management guide for both beginners and students. If you guys have been watching my videos, you'll know by now how much I emphasize the importance of tracking your expenses. It doesn't matter what apps or systems you use as long as you go and get started!
With all the budgeting apps out there, you might be wondering which of them would be best to start using. If you're looking for a no-fuss free budgeting app, I recommend that you look no further than the glorious Google Spreadsheet app! I personally use spreadsheets to track my cashflow and my investments. I've tried a lot of budgeting apps, but for some reason, none of them really fit my needs. I've been using this setup for about two years now, and it hasn't failed me. I love Google Sheets!
I'll teach you how to recreate my own spreadsheet setup that I showed in a previous video. Start managing your money for free my dudes! Create your own spreadsheet today.
ALSO, I'll share the link to the template if this video reaches 150 LIKES. So... like away my dudes!! 😉 Here's the link to the template 😉 bit.ly/3ewqgMI
➜ Enjoy your free money 💰⬇️
🏦 Banks & E-Wallets
- Unionbank PlayEveryday: Use “UBNOW-NA0920016” to get 300 PlayPoints
- Tonik: Get ₱60 with “T42BHJL” when you sign-up, verify, and top-up
- GCash: Get ₱50 bit.ly/2ZyrLWy - sign-up, verify, and cash-in to
- PayMaya: Get Php100 when you use “2Y817PZMN84O” or sign up and verify at bit.ly/2ZzVjTs
🚀 Crypto Platforms
- Crypto.com: Get $25 in CRO when you sign-up at crypto.com/app/nicolealba or use my code "nicolealba" 😁
- BlockFi: Get $10 in Bitcoin when you sign-up at bit.ly/3jWct5a and deposit at least $100
- Celsius: Get $50 in Bitcoin when you sign-up at bit.ly/30luMcO or use code “119827e588” and deposit at least $400
- Binance: Sign-up and get 10% discount on fees bit.ly/Nicole-Binance or use code "YBY3MNM9"
- PDAX: Use “nicole” to get ₱30 when you deposit a minimum of ₱1,000
💵 More Cash
- GoTrade: Use invite code “157655” to Invest in US Stocks and ETFs for as low as $1
- ShopBack: Get ₱100 at bit.ly/nicoleshopback
[ The links above are affiliate codes/links and I may get a reward at no additional cost to you if you use them. Thanks in advance because it helps support the channel 💙 ]
✅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
💳 Apply for Citibank Credit Cards
- Rewards bit.ly/3upS68U
- Simplicity+ bit.ly/3Gq9Ao7
- Cash Back - bit.ly/3uxoGpk
🍞Join our Discord Server: / discord
🍞 Get BreadFam Merch: bit.ly/shopbreadfam
👍 Facebook Page: / alba.nicoleee
☕ Buy me a coffee: ko-fi.com/albanicoleee
🚀Subcount: 947
🕰TIMESTAMPS:
00:00 Intro, Featured Comments
01:21 Overview and Spreadsheet Demo
03:26 Setting up the Cashflow Sheet
09:58 Setting up the Overview Sheet (Net Worth Tracker)
11:49 Outro
--
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.
🍞 BreadFam
--
🤝Business Inquiries and Collaborations
➜ IG: @alba.nicoleee
➜ Email: [e-mail]
⏫HIT ME UP ⏫
➜ My Blog: Wow I Made This wowimadethis.com/
--
#personalfinancetips #expensetracker #googlesheets #beginnersguide #personalfinanceforstudents

[@phlev1998]

Im a CPA already but Im not this organized in tracking my personal finances. I started doing the google sheets and really felt immediately conscious afterwards, as I saw all my personal income, expenses, assets, liabilities stacked nicely. Thanks Nicoleeee!!! 🍞

[@annamargaritacarreon3239]

Under adulting essentials. This is what we should be learning in high school! 😅 Thank you for making this video. 🙏🏾

[@antonmursid3505]

Antonmursid🇮🇩🙏🙏🙏

[@elvisfresco2310]

Hey your doing Great work here, learning from a 20yo about financials is an eye opener for a 40yo, that starting young is the way to go, Hope to have my 20yo daughter have the same mindset. Kudos!

[@NicoleAlbaYT]

Hi Elvis 👋😄 Glad you're finding value from my videos! Starting young means that time is on your side. Hopefully your daughter will enjoy my videos as well 😁🍞

[@shek.the.armesin]

I've been doing a spreadsheet of my finances since I started working at the age of 20, but the main problem was that I'm having a hard time tracking my expenses. Thank God! Finally found stuff like this, and I'm currently using this concept of yours to track my everyday expenses and income. Such a great video! More content like this! Kudos to you!

[@BrendanEvan]

Spreadsheets feel like cuddling up on the couch with a pillow and blanket...but with numbers.

[@NicoleAlbaYT]

Best feeling fam HAHAHA 😄👌

[@heyheyheyitsvyl]

this analogy tho 👏🏻😂

[@antonmursid3505]

Antonmursid🇮🇩🙏🙏🙏

[@sherkaye26]

I just finished making my own spreadsheet using MS Excel 2016. Thank you so much for this, Nichole Alba. This will be my new year's resolution. I will do my best to be consistent and manage my finances. Thank you for the inspiration!

[@faithcasana8502]

I have downloaded a million of budgeting/cashflow tracking sheets. I then bump into this video today and tried to search for any ready-made file at your social platforms because I was a bit lazy to start it. I couldn't find one, so I continued with your video and along the way, I got interested to do as you instruct. This, by far, is the best tutorial I have ever encountered. Learning to organize my finances the easy way, direct to the point, and at the same time, learning few more spreadsheet basics. Amazing! Thank you!

[@rosaliecalpito765]

Thank you for this tutorial. I spent the whole afternoon working on my own financial portfolio on google sheets. I tried listing down all my expenses and savings before, but I stopped because I don't want to be OC on my financial matters. I wanted to spend, save, and enjoy my money. Seize the day, right! But then, when I watched your videos, I realized that we really have to make our tracking of our finances easily so we won't be surprised of our expenses. (because I admit I also buy unnecessary things on impulse.) Yes, I have to spreadsheet everything because I don't want to be surprised anymore every time I received my earnings from my investments and savings. I am not good in numbers and accounting concepts, but with your step by step instruction for the automated finance system, I diligently followed your instructions and I appreciated how my finances are easily documented and monitored through this spreadsheet. Keep it up!

[@naldogomez]

The fact that you were excited to have 1000 subscribers in this video (2020) to where you are now is incredibly inspiring. I was just trying to learn how to get my life together and seeing you how you were a couple of years back to now just...damn lol thank you im inspired to keep working towards my dreams!

[@margiedinaguit7266]

I spent half a day revamping my spreadsheet, to make it look as comprehensive as yours, I was into tracking my cash flows and investments but no portfolio to see everything in one place.. nice one.. thank you girl

[@ItsEndyy]

I've been tracking my expenses just because of this video alone way back in 2022 and I gotta say its really one of the best decisions I've made. The effect of being able to know where your daily expenses come can give you that subtle shift of mindset that you should hinder from spending way too much if you're a massive spender and it'll give you a shock at the end of the month of how much you've spent, And also with tracking your incomes which can give you motivation. Thank you Nicole for creating this it really helped me a lot! 😊

[@user-dq3rd8fz2v]

This was a game-changer. I've been using spreadsheets but I've never organized it the way you did. Yours was much more organized and efficient. Thank you and keep creating!

[@edwardmejia5773]

2021 new goals ! Keeping track of my finances let’s go ! Thank you so much

[@ITSH4WK]

Seeing this almost a year after its release. The part at the beginning where she's excited about almost reaching 1,000 subs and seeing where she is now at 236k just blows my mind. Insane growth, congrats!

[@georgeanneesdrelon1210]

I want to say thank you for creating this video. I'm currently studying google spreadsheet on tracking my money and expenses. Thank you because I was able to make my sheet presentable and non-basic.

[@undonido9193]

Thank you so much! Seriously guys, don't get lazy to start from scratch on doing this. I personally don't have any knowledge of google sheets, but this one was really easy to follow!

[@MaryJoyCAmbat]

Accidentally saw your videos last night and since then i can't stop watching until now(watching while typing some important information from you) first time watching this kind of videos. Thank you. Looking forward for more interesting videos. God bless!

[@sizzy6410]

I just discovered this video November 2021, and I'm so happy that you now have 330k+ subs. This is so helpful. Thank you!

[@kuyaryan9255]

this whole quarantine period got me watching random videos!!!! I love your content ate it inspires me to track my expenses in systematic way ✨

[@ej16dags]

I can't believe I only encountered you days ago. 🥲 I've already gone over 2 Excel Templates the past 3 years to track my Expenses and yours has been the Life Saver! 💕

[@brokerfaith8112]

Saw your video randomly in my feed and shared it with my 19 yr old son. He told me that he learned a lot from your videos. We usually bond while discussing about your videos so I am happy about it. Thank you very much and Keep it up!

[@mzslk]

Starting out with expense tracking and budgeting, I really like what you shared because it's easy to monitor and update, I just set up my own spreadsheet using this format. Thank you!

[@darrenreich]

Looking forward for the next videos of this series. It's really impressive to learn something on someone younger than me. Thank you very much!

[@bunnycube6829]

This is the simplest cashflow spreadsheet that I’ve watched so far. It’s well organized and easy to follow. Thanks for sharing this. I’ve been trying cashflow spreadsheet system for quiet sometime now. And, I think this one will work best for me.

[@happyme4047]

So thankful for stumbling upon your channel. :) I'm almost 40 but as we say, it is never too late! May you continue to inspire more and more people!

[@NicoleAlbaYT]

Definitely never too late! Glad you found value from my videos. Thanks for watching 😁❤

[@withemily3266]

Not only I learn something in this video about spreadsheet but you grabbed my attention like you're really entertaining so thankful

[@keekzter]

Ive been doing spreadsheets since i started working but after watching your video, it made my system more organized

[@ross6799]

This is the best money tracker I have ever seen. I've been creating my own money tracker many times but It's not working for long term, Thank you for this!!

[@maelyenkaye]

I actually opened my first savings account after watching your videos about the battle of digital banks and you made me realize the value of money. And i want to thank you for that

[@cmllcncpcn]

Wow this is soooooo helpful! I've been trying to use Excel to track my expenses last year but I couldn't commit because it's a little hassle (I don't have any clue about the formulas) so I put everything manually. But thank you so much, Nicole! This is really really helpful and your videos are very interesting, fun, and full of learnings. I'm sure many people enjoys watching your vids!

[@steffanygracealiguyon5852]

I've been using spreadsheets to track my spending and my budget but I can't seem to create something that's more efficient I ended up having multiple spreadsheets. Thank you, Nicole, for sharing these tips. Congratulations on your 200k+ subscribers.

[@kuyajapes]

Thank you for the easy and not-boring tutorial. Usually when someone teaches spreadsheets, it's very boring. Keep on sharing! Happy New Year!

[@arjaytigerace]

Good thing I saw this a few months ago. Now I can use this finally for 2021. THANK YOU SO MUCH!!!!

[@maryclairedevera6475]

Been looking for this kind of video!!! Just so perfect for my new year’s resolution! Thank you, Nicole!!!

[@julianaalienigena2299]

Thank you so much for this tutorial! All apps I've tried were way too complex and time-consuming, but this method is really simple and concise. I'm looking forward to using it!! Thanks again, Nicole!

[@francisquan224]

I was finally able to find this video again. I saw it in 2021, still a 2nd year student. It helped me have a temporary savings, but I didn't use those money. And now, 2024, I am about to graduate from college. It helped me on my way to finding the answer to the question I always thought: what will I use that savings for. Manage finances well to find ways to escape the cycle of working and living day to day. Thank you very much. *I use Google translate. Sorry if the grammar is wrong.

[@sj11sathya]

Randomly found your video and fell in love in the first 3 seconds itself. Love your personality !

[@Ms.Emerald]

I’ve been budgeting since elementary but only at 20 I started to do it in a digital way. It’s more efficient! There’s a free spreadsheet on Google which I’m currently using however I realized I wanted to learn how to do it on my own. I would search the specific stuff then watch it on yt one by one but you explained most of the things I was looking for in just ONE VIDEO.. THANK YOU SO MUCHH❤️❤️❤️

[@vincentluna4858]

I like her cheerful attitude at the beginning makes you wanna stay and continue watching.

[@rhahavyb]

I’m trying to become more diligent with my finances and this was such a life saver!! I love the way you set up your spread sheet

[@arianesales8315]

this is not the first time that im going to watch your video, ive been watching you since a week ago and i think 2 days ago ive subscribed already, and honestly, ive watch you because i like your topics but when i watch you, i think i'm being hypnotize on how the way you talk!am i the only one who experience it?don't get me wrong, it;s a compliment.hehe, to the point that i call my eldest daughter which is only 7yrs old to watch you because i want her to talk like you and maybe deep down in my heart, i wish my daughter to be so simple and yet so funny, smart and have the courage to explore what's in there. Just like what you said, Take an action, its not enough that your just keep on watching and watching.Grab the opportunity. sending my praise and appreciation to you.

[@jessicawilona9594]

Budgeting and tracking expenses were never as easy as this! Thank you so much, I'm so glad I found this video, so thankful! Keep making videos!

[@agjenn5772]

OMG!! Thank you Nicloe. I'm learning to track my money and your video was so helpful. I paused it and took the time as I was watching to make my spreadsheet.

[@haroldm.6780]

I'm very happy that i find this channel. I love all of your videos! Thank you for this tips and now i will start to track my financial flow.

[@yennylim8989]

I've been using spreadsheet since I started saving money but I never knew how to organize it the way you did. Thank you for showing an organized and clean sample. I can now fix my messy spreadsheet. Kudos to this great video of yours.

[@NicoleAlbaYT]

Haha yehey! Spreadsheet is life 😄❤🍞

[@akositatot]

Bruh I didn't realise this premiered June 30 when I first found this channel with 900+ subs and now I come back to see Nicole having 80.9k subscribers!!!! I FEEL PROUD FOR SOME REASON

[@ivannairis]

I had to slow down the speed to fully understand the instructions LMAO. It's been so fun to hear you talk about different life aspects so far! Searched in YT how to invest (right after being guilty of too much impulse buying yesterday) and now I just finished my first spreadsheet! Thank you for this! Planning to invest my scholarship savings ;) I'm looking forward to more of your content and improvements!

[@maica72513]

Currently binge watching your videos and I am currently setting up my spread sheet. Yay!! Thank you very much :)

[@CloveriCat]

Thank you so very much! I followed you step by step. I was a total ignorant in managing my finances and didn't even knew how spreadsheets worked! I set it up and hopefully I will begin to keep track of my money and bring order to my life. Thank you again.

[@NicoleAlbaYT]

Super glad you found this useful Ana! Awesome that you're taking steps in getting your finances in order 💯 Thanks for watching 😄❤🍞

[@VirtualResidence]

WOW inspiring to see only like two years ago you were at less than 1000 subs, now YOUR ALMOST AT 400,000! congrats

[@foodrevph2236]

I've been binge watching your videos this week.after I finished watching everything.I'll schedule my day and time watching your vids only by Wednesday.🙂

[@ladyotacon6827]

Thank you! I've been looking for a minimalistic tracker and the one you've taught is the most helpful one among the bunch!

[@collectiveclean]

I started to get dizzy around 7:20 but after a couple hundred replays I got it. Thank you so much !

[@domingocriziamarie]

I'm so happy to find your videos. I really want to organize my finances and now mas nalinawan na ko. Thank you so much!

[@HannaMayAbalos]

Hey! I stumbled on one of your videos 2 weeks ago and now I subscribed to your channel. This is cool! I already have my google spreadsheet for my monthly budget but I will integrate this idea to my existing spreadsheet to make it a daily tracker. Thanks a lot!

[@jhaekee]

Sooooooo so so happy for you!!! Hello 32K subs from nearly 10K when this vid was created. I was thinking how i would definitely track everythiiiiing! i was having a headache then i found this, finally!!! Thank you so much, i am so amazed that younger peeps than me are actually way better in managing their finances. :) kudooooooos! more vids please! Cheeros!

[@konhyerilee]

Love this girl! Very helpful videos! Started making my own financial tracker since subscribing to your channel. No more hassle in tracking my expenses! This video is very recommended especially to students and working pips like me hehe. More power to your channel :)

[@fishstick55]

This was very helpful! I always have had trouble tracking my finances, I tried but the way I setup my spreadsheets were inaccurate so I wasn't motivated to keep up with it, but I setup my spreadsheet like this and it's been super easy to balance my accounts now, thanks so much!

[@reyeencancino2375]

Thank you so much! It was really complicated at first but with the help of your template and listening tou your video step by step, I'm now able to customize per categories. I hope this finance strategy will help me monitor my money. I'll be using it for the first month, and hopefully continues until the end of the year.

[@maika9659]

Binge watching your videos! ❤ I first read the description then watch your video. I guess that works for me. In that way, i feel like I'm advance reading the lecturer's topic of the day haha keep doing this. Your simplified version of discussing financial management helps many people a lot ❤👏

[@almonteadriang.7098]

Thank you nicole, you inspired me to take my finances seriously, and giving me the mindset on saving more money. Hopefully, I can take action soon. God bless 🙂

[@minnieallensunglao8800]

New year, new spreadsheet. Yay! Just made my own based on this spreadsheet of yours. Thanks a bunch!

[@clementine474]

THIS IS SO AWESOME. I will try this too! I am also slightly mortified at my basic cash in, cash out spreadsheet.

[@jeevanjotsinghnarula2453]

Thats cool, you already 300k subscribers which is awesome. For now, saw your video and actually want to manage my personal finance better using google sheet.

[@dorrn7829]

Love your vids! I started watching u yesterday and i got addicted to it hahaha 🧡 Thank u for this! I’m doing it right away 🤗

[@m.g.5073]

Was looking for ideas to revise my budget sheet (also made with Google Sheets) and came across your video, thank you for the good starting point!

[@Loida304]

I been using excel for many years but watching your video I learn additional knowledge great job Nicole

[@klaussecruz7133]

Seeing that the day you posted this vid, you only have 900+ subs but now a year later you have over 300k subs. Kudos to you, love all of your vids btw

[@denisemallari7860]

Learned a lot from this! And spreadsheet everything is now my kind of thing, love it!

[@MultiPriscilla09]

Just found this video (thank you btw) and realized your growth in subscriptions!!! From almost 1k to 350k in less than two years!! Congrats!

[@jenmarbella3544]

I am actually started tracking all my expenses using spreadsheets since 2018. I would also want to track all the assets, liabilities and investments. Thank you for this.

[@sydney8020]

Thank you for this! I think making my own spreadsheet made me more conscious of my money-spending. Keeping track of it like this will really help

[@nicoledminiao5522]

2021 goal it is. Track track track. Very helpful, thank you nicole.

[@kenrock2]

wow... this is really smart design layout.. I have been struggling to keep track manually in my spreadsheet, and your design just makes thing much easier to see... thanks alot

[@dineshkumarramasamy9849]

I was exactly looking for a video like this, Thank yoy Nicole!

[@angellekateconstantino]

The "push" I needed to get started with managing my 💰💸 Thanks Nicole!

[@marissalagman7602]

Yay! Just did this! It took you like less than 12mins, it took me more than an hour! Thank you!

[@leannegd787]

been looking for a proper spreadsheet tutorial im so glad i found your channel!

[@NicoleAlbaYT]

Glad it was helpful! 😄

[@kainunez6847]

Thank you so much!!! I've always wanted to do this but had no idea how to. But I came across this video and voila! I just created my own money spreadsheet. Now I can track my cashflow. Love it! ❤️ Excuse me while I subscribe and stream all your other videos 😁💕

[@ramanapanasa]

Thanks Nicole Alba. This is the best tracking I have ever seen. Thank you so much for sharing.

[@lykalibre1187]

THANK YOU SO MUCH FOR YOUR VIDS ATE! they're sooo sosososo helpful. Kudos to all influencers like you who are making significant impact to us youth

[@motohua7855]

I’ve been looking for this kind of video for so long, finally nahanap ko din. Thank you so much

[@izzydubmusic]

Dang! Clean and so efficient. Already finished my spreadsheet after this. Thank you.

[@zellesabado6743]

Ang cute lang na ang saya ni Nicole dito that she is so close na to 1000 subscribers. And now, months later, she has 102k subscribers na!!! Way to go, girl! Thank you for all the gold nuggets! :D

[@lourdessabandal3912]

Nice way to keep my finances in one picture. Easy to check in one glance. Thanks for this. I will do this now. I used to pen and paper in tracking my finances so that in case I am out not using my laptop still tracked my expenses and savings.

[@kcsulit4254]

thank you for doing this! been binge watching your vids!

[@gld7852]

I'm watching your videos like a kdrama series for a month now! Thank you for inspiring me ❤️

[@aubreybondoc]

You should make this Excel thing a series like for this week, you talked about spreadsheet for cashflow, next week will be for other things. I know there's more to this than what was shown on the video. Thanks!

[@NicoleAlbaYT]

Haha thanks for the suggesstion! My excel skills are limited, so I don't know if I can share more valuable things about it 😅 I'll share how I track my investments with excel in the future though! Definitely more to it than what's covered in this video ❤️

[@aronperez6368]

Sana po ate mag make din kayo like for credit cards spending as well hehe hoping for your next vid is this

[@romosssucat2380]

Agree

[@aronperez6368]

ate nicole please give update sa cc expenses tracking

[@marielleison574]

@@NicoleAlbaYT I can't wait for your investment tracking with excel :)

[@user-du2vg1oy5n]

Watched this today and created my own spreadsheet! This video may be a few years old, but it continues to help people everyday!!

[@dollydomingo15]

im now using your ssheet sample.. and i liked it! thank you soo much! yes... lets start taking ACTION!🙏❤️

[@DaraSyy]

Never thought of this. This makes my life easier haha! I am tracking my money and expences by collecting recips write em down to my notebook 🤣 every peso counts. Thank you Nicole for this wonderful idea!

[@mau-rianneayrhabayting-gam7635]

Thanks for your video! It helped me a lot in my budgeting, even made a grocery list which totals my purchases before even reaching the cashier 😅 I could really say that I got addicted to making google sheets bc of this vid

[@dfnica28]

Learned a lot from this gal! I am following your format girl. Very simple and clear! Thanks for sharing this.

[@Mike-kl5yc]

Thank you so much! As a teenager in high school, it's good to know that I can actually track my current savings with this method. Only 1 criticism I have is the pace of the video. It's really fast, but that's all! Great video, here's a sub!

[@annjillian89]

I don't know how I stumbled on this but damn this is super helpful. I've been tracking my finances for years now, too, but my spreadsheet is a total mess. Like its completely useless compared to yours. So now I've upgraded mine based on this! Thanks, Nicole!

[@roro8910]

LOVED THIS VIDEO SOOO MUCH! Thank you for creating this! Your explanation was so simple and this was so relatable. I've been using an APP but things have been getting confusing. I tried an excel template but that did not work because the explanation did not make much sense. However, love that by creating it on my own and with your overview explanation, this makes so much sense to me!

[@nowiburgos]

This is refreshing. And I don't mind taking pointers from someone 14 years younger than I am. Way to go, Nicole!

[@NicoleAlbaYT]

We can all learn something from one another despite the age! Thank you for the support, Nowi 😄🍞❤️

[@joeyylanan7160]

Definitely going to incorporate some of your formats in my spreadsheet!! I finished my budget tracker for 2021 and will proceed to do my financial statement trackers and daily expenses :))

[@chenchen2077]

I applied your spreadsheets to manage my cashflow hehe. thank you so much for this wonderful content!

[@brigetteannduerme9768]

I really love you now! Just wanna say THANKS and you are the true influencer!