Beginner Friendly DIY Net Worth Tracker | Google Sheets

[@hammockmonk]

I've been tracking net worth annually since 2009. I don't need the monthly breakdown but your video was still helpful for me; I've created a new version of my balance sheet/net worth and now I'll turn to our personal income statement and cashflow reports. Thanks!

[@gilthebarber99]

Youve helped me change the way i manage my barbering business dramatically. Im able to keep track of all my numbers and it just makes sense and gives me peace of mind. Thank you for sharing your knowledge. I hope to keep learning more ways to improve my finances.

[@PersonalFinancewithLeila]

That's awesome!! ❤️ Thanks Gil!

[@HeatherCorinneCrochets]

Enjoyed this video! I have been wanting to simplify my net worth tracker for a while now, and this was perfect. I found the chart particularly helpful to visualize the growth. Thank you!

[@Ten_Broeck]

Thank you I am 17 and decided I would start tracking my finances in a more organized way this year... very simple and very clean layout. i no longer have to pay for websites that give me access to spreadsheets and I can now create and customize my own.

[@kat-oe7gb]

Great job. I guess since I started in Excel, I prefer it over Google Sheets. What I love about G-Sheets is that it saves as it goes.

[@denorrisd]

Thanks, so much. When changing the net worth numbers when creating the chart you can select (Example (=D2) just the first one you want, then copy down and for the second to the end, and then you can just change the Row or Column character in the formula bar

[@OmarEwert]

So helpful! I love seeing how other people format things, I'm also very picky & change things around all the time lolz. Sheets added a merge button that says merge vertically. Try it for times when you want to merge the months like you did, but all at once

[@PersonalFinancewithLeila]

Good to know, thanks Omar!

[@Ilovetosmile2023]

Ms. Leila, you’re a great instructor. I was able to create mine and it blew my mind! I thought I am saving, but in reality I am not. I am thankful for this video. Kudos to you! 👏

[@jaelasam]

Thanks so much for this Leila. This was very helpful. I have been using your template that u show in your monthly budgets, but I've wanted to adjust certain aspects and didn't know how to. I love that u give us the option to either buy or build 💕

[@QuesttoFIRE]

Very helpful! Google sheets is the best! Love accessing it from my phone, anywhere!

[@carine9122]

Thank you Leila, this was simple and helpful

[@brigitterolens]

OMG! this is SO helpful, thank you so much!!!

[@samvandillen]

Great video, with a great and calm tutorial and great value! Thank you!

[@PersonalFinancewithLeila]

Thank you!!

[@venkatkasireddy884]

Not sure if anyone has suggested using the pivot table feature. It will automatically create tables & graphs, from the data tables where you input the numbers for each month. Totals row also is not needed. BTW, I like the video as the ideas help me in keeping it simple & useful. Saves lot of time.

[@catgodfrey6451]

Thank you so much for sharing. This is awesome learning for me. I’m definitely a visual learner 😊❤

[@AmeliaIsOn]

Cool, but could you add a little more analysis and visualizations to this sheet. That would be nice

[@tonimario2012]

Thank you so much Leila,remain blessed❤

[@AydenReeks]

Thank you!!

[@Katlife246]

Thank you so much for this tutorial, super helpful!!

[@lisagarbercoaching1356]

Very helpful. Thank you.

[@indrakumarrs4475]

Thank you

[@JevonMusicGroup]

Do you enter data on the first day of each month? Last day?

[@PersonalFinancewithLeila]

Last day!

[@JevonMusicGroup]

@@PersonalFinancewithLeila Cool. Thanks!

[@Sam-bb2jl]

Does it require me enter information myself?

[@PersonalFinancewithLeila]

Yes of course

[@jonnyd95]

I'm sure u have an beautiful smile 😊

[@Jb-sv5mw]

The assets under 2023 is driving me crazy why didn’t you space that out

[@rnt45t1]

Good rule of "net worth" is that personal residence is not an investment, it's a liability. Same goes with vehicles. Depressing, sure, especially for all those people that FOMO'd into the overpriced real estate market or want to try and justify $1,000 car payments.

[@susanhoover1820]

Nope. Anything owned that has value is included in New Worth. So personal residence is an Asset and its mortgage is a Liability. Granted, it is difficult to accurately assign a value to real property. Some people use Zillow to find estimated value. For many people who own their own home, it is their largest asset AND liability. If you pay a mortgage every month, that’s paying down your debt and automatically increasing your net worth. Of course, it’s your choice what to include in your personal net worth calculation.

[@rnt45t1]

@@susanhoover1820 I just tend not to include it because when I tell people I paid cash for my house, and far less than $100,000, they lose their minds. I also drive a $1,400 car and a $3,500 truck.

[@HamTheBulldog]

I think you are mixing up the meanings of the words "asset" and "investment." A personal residence is an asset, but not always a good investment (as you point out), and has a lot of expenses and debt that can be associated with it. But if you own your residence you should absolutely include it when calculating your net worth.

[@HearMeLearn]

this is wrong. It's not an investment, but it's not a liability either. They're assets. Liabilities are things you owe, a credit card balance, a loan, a mortgage. Whether they depreciate or not, a car is an asset because it increases your net worth.

[@kamrankhan-qm6hb]

Thank you