How I Manage My Money: My Financial Mastersheet for Income, Expenses, Net Worth, and Budgeting

Поділитися
Вставка
  • Опубліковано 14 чер 2024
  • I share my Master Financial Spreadsheet that helps me track my Net Worth, Investments, Income, Expenses, Bank Accounts & More. Free resource for download as well in this video description.
    ▶️ THE MASTER FINANCIAL Spreadsheet: beacons.ai/humphreytalks/free...
    All you have to do is hit "File" then "Make a Copy" and copy it to your own Google Drive. It's the same as is in the video, change things up for yourself. If you want it as an excel file instead, hit "File" and then "Download - Microsoft Excel".
    🖌 Links:
    ▶️ Stock Portfolio + Tracker ➭ / humphreytalks
    🐪 Hump Days Newsletter ➭ humpdays.substack.com
    🗞 Follow My Twitter ➭ / humphreytalks
    👾 Personal Finance Discord ➭ / discord
    🖌 Free Stocks:
    ► WeBull (Get 7-12 Free Stocks worth up to $30,600 when you deposit at least $0.01) ➭ a.webull.com/i/HumphreyYang
    ► Public ($10 Free Stock) Investing App ➭ pblc.co/humphrey
    ► Robinhood (Free Stock Valued Up To $250) ➭ robinhood.c3me6x.net/qPyKY
    Timestamps:
    0:00 - Start Here
    1:34 - The Summary Snapshot
    3:18 - Income (Salaried)
    4:00 - Expenses
    7:38 - Fixed Expenses
    8:39 - Assets & Net Worth
    10:07 - What a Filled Out Sheet Looks Like
    10:40 - The Funnest Graphs
    📲 FOLLOW ME & FRIENDS:
    Follow Rickie (Editor): / coldgamerick
    Instagram: / humphreytalks
    Tik Tok: / humphreytalks
    📧 GET IN TOUCH: I'd love to hear from you! If you have a longer question, or if you have a business related inquiry, please then send me an email at humphreytalks@gmail.com. I try my best to reply to all e-mail but sometimes I do not have enough time to respond to everyone.
    PS: I am not a Financial Advisor, any investment commentary are my opinions only. Some of the links in this description are affiliate links that I do receive a commission for & they help support the channel

КОМЕНТАРІ • 111

  • @targetram2807
    @targetram2807 Рік тому +59

    Yes, market crashes. Yes it has not bottomed, It has no business at this level in the first place, pumped up by the Fed and central banks around the world. You can still be 100% invested at this level. Good luck! I prefer to sell the bounce and keep 50% cash. I will not get back into the market more than 50% if S&P is not 30% lower from here. I trade and make quick profits. With this inflation and my expectation on the economy, I am ok with 70% cash. I don’t short the market. Just keep selling the bounce!

    • @jeffreymurphy5302
      @jeffreymurphy5302 Рік тому

      describe an unknown factor that hasn't been plastered all over UA-cam headlines already

    • @amiracentenososa3847
      @amiracentenososa3847 Рік тому +1

      I am sitting on cash. I sold my stocks but the best part about this sell-off i have been mostly right, the worst part about it is that i don’t short anymore so I’m not making so much money but at least i will get to buy twice the stock with the same USD amount.

    • @hermandavid6813
      @hermandavid6813 Рік тому +1

      @@amiracentenososa3847 Profit comes for proper trade execution thats why i hired a wealth manager. I have racked up in profits $758,405 from $185k capital in sept 16 last year to be exact on my portfolio.The best time to diversify according to my CFA Mary Freed Lorenz is now and with what is playing out in the markets, she is more defensive while shorting.I watched a news interview on where she featured during an IPO and spoke proficiently, caught only her name and did a search later online.

    • @petronapinanunez8318
      @petronapinanunez8318 Рік тому

      @@hermandavid6813 Make sure to do plenty of due diligence on any online financial advisor who charges a one time fee. Not saying this person isn’t trustworthy and legitimate, but I’ve seen many similar pitches that are scam

  • @shanda5109
    @shanda5109 10 місяців тому +1

    I have always tracked every expense but your spreadsheet is making it all so much easier to read and organize. This thing is gold to me! thank you so much!

  • @henryho2508
    @henryho2508 Рік тому

    Thank you so much Humphrey!! I have learned a great deal from watching many of your videos. Today, I even learned how to copy Excel files on Google drive!!!

  • @jeremydudet
    @jeremydudet 2 роки тому

    Wow! What an accomplishment, Humphrey! I'm so happy for you! I'll apply this. Thank you for the great tip. You deserve all your success

  • @Sup3rman124
    @Sup3rman124 2 роки тому +8

    It's great to see how other people record and analyse their own financial data - I made a spreadsheet myself when Covid 1st hit and it makes planning for the month/year ahead so much easier (Will definitely be adding charts now that I've seen yours in action!).

    • @humphrey
      @humphrey  2 роки тому +2

      That is awesome!

  • @blankn1612
    @blankn1612 2 роки тому

    Absolutely amazing. All this hard work. Thank you for making this.

  • @Msdiroll
    @Msdiroll Рік тому

    this spreadsheet is PHENOMENAL

  • @santumos
    @santumos 2 роки тому +1

    Beast of a channel. Congrats on your well deserved growth

    • @humphrey
      @humphrey  2 роки тому

      Much appreciated, thats an awesome comment

  • @NextofKen_
    @NextofKen_ Рік тому +1

    You’re awesome for this, thank you!

  • @TeachEvans
    @TeachEvans 2 роки тому

    Not overkill, I totally get it

  • @Admani
    @Admani 2 роки тому

    Dude I love this! I think I’m gonna try this out

  • @tech132
    @tech132 Рік тому +1

    I use Personal Capital and it does it automatically for what I need!

  • @Mel_o1234
    @Mel_o1234 2 роки тому

    Thanks for sharing this!

  • @markksantos
    @markksantos 2 роки тому

    Love this!

  • @redgun421
    @redgun421 2 роки тому +1

    great vid and sheet. thanks so much for sharing man!

  • @MaxMaher
    @MaxMaher 2 роки тому +2

    The thumbnail got me!

  • @LalitDevraj
    @LalitDevraj 2 роки тому +1

    Man, the first title was such a good searchable title yet seeing this updated one, it TOTALLY makes sense 🔥💥🔥😁😁

    • @humphrey
      @humphrey  2 роки тому +2

      I'll probably change it to the searchable one in a few days lol

    • @LalitDevraj
      @LalitDevraj 2 роки тому

      @@humphrey lolol, fair enough :)

  • @A__gent___P
    @A__gent___P 2 роки тому +2

    First like and first comment! Thanks Humphrey for making educational and entertaining videos!

  • @Johnefinance
    @Johnefinance 2 роки тому +1

    Awesome Spreadsheet! Don't let Graham see that coffee budget 🤣

  • @MrDaffy-bz7gf
    @MrDaffy-bz7gf 2 роки тому

    Thanks Humphrey!

    • @humphrey
      @humphrey  2 роки тому +1

      you are welcome Mr. Daffy :DDDD

  • @jj-1239
    @jj-1239 2 роки тому

    This is amazing!

  • @SpencerJohnsonOfficial
    @SpencerJohnsonOfficial 2 роки тому +1

    Gotta love excel sheets. This has been my favorite one I’ve seen so far! May have to steal it from ya! Great video as always.

  • @aydavid
    @aydavid 2 роки тому +3

    Can’t wait to watch this, definitely needed this- THANK YOU 🔥

    • @humphrey
      @humphrey  2 роки тому +1

      You're so welcome!

  • @cobrafinancialsolutions1039

    Such a great video!

  • @JonesingFinance
    @JonesingFinance 2 роки тому +2

    Thanks for this!

  • @matthewmaret2048
    @matthewmaret2048 2 роки тому

    Thanks very much for sharing this info. I will have my college aged daughter and recent high school graduate son using this tool. Again, thank you

    • @humphrey
      @humphrey  2 роки тому

      Glad it was helpful Matthew :D

  • @user-qb8ex2pn7c
    @user-qb8ex2pn7c 10 місяців тому

    amazing video

  • @jarey9222
    @jarey9222 2 роки тому

    That would also be great for accounting a business

  • @akshaydevadiga4704
    @akshaydevadiga4704 2 роки тому

    Thanks for sharing excel

  • @ZOT369
    @ZOT369 2 роки тому +1

    Very cool of you!

  • @FinanceMind
    @FinanceMind 2 роки тому +2

    Great video, thanks!! I think tracking to this level of detail is really important for those who have either lower incomes or low savings rates. Its really important to understand which levers you need to pull to get your expenses under control!

  • @DirtyBob154
    @DirtyBob154 2 роки тому +1

    Cool spreadsheet! I assume you already have a dividend spreadsheet as well? Anyways, one thing that I would add is instead of inputting the dollar amounts from your investments, input the amounts that you hold then multiply it with the share price (or coin price). This gives you a more accurate number, and it’s also automatically updating with a live net worth as the markets fluctuate. I set mine up with power query and import the financial data through tradingview. Let me know if you need help with this, I would love to do this for you free of charge!

  • @camerongoularte603
    @camerongoularte603 Рік тому +1

    Thanks so much for the video! Super helpful! What app do you use to track expenses?

  • @digyant9500
    @digyant9500 2 роки тому +1

    I also follow similar routine to keep track of my expenses.

  • @BarbellFinancial
    @BarbellFinancial 2 роки тому +1

    I only started tracking my net worth when I was 28. Wish I started sooner as I would have paid attention more to where I was putting my money.

  • @MasterpieceFinance
    @MasterpieceFinance 2 роки тому +3

    This is unreal! So much great information here Humphrey and congrats on hitting one mil net worth! I'm grinding to be like you one day :) amazing video as always!

  • @adriancheung4824
    @adriancheung4824 2 роки тому

    Thank you for this =)

  • @50LightSabersInAPack
    @50LightSabersInAPack 2 роки тому

    Looking good! Are you using it for financial modelling too or just tracking?

  • @AKMaksat
    @AKMaksat 2 роки тому +1

    I use Mint because it tracks all my bank and investment accounts in real-time. Plus, it allows me to create fine-grained categories and add notes to each transaction (e.g., if it is something from shopping, then I'll add a note telling what that item was). But I like how you used that data to make those charts to give you more insights and just a better understanding of where you are with your finances. I will definitely try to play around with your spreadsheets, thank you! Given that Mint allows exporting all transactions with their metadata (like dates, categories, and notes) I can get the best of the app and your spreadsheets =)

  • @jentam101
    @jentam101 2 роки тому +1

    I front loaded my 401k contribution. Therefore, my take home income for the first 4 months is quite low. On the column for salaried income, do I enter my take home income (minus the 401k contribution)?

  • @anivnayar
    @anivnayar 2 роки тому +10

    Thanks for the sheet Humphrey! I also created my own Net Worth/P&L tracker and I have a couple things I'm doing differently and would love to head your thoughts
    - Shouldn't the net worth section have a liabilities portion as well, for items like balances on home mortgages, student loans or other debts? I think you mentioned you live at home so you may be completely debt free, but for those of us with some sort of debt, that should be subtracted from the total assets to get to your net worth.
    - The way I handle large purchases is a little different. In my budget, I basically amortize the cost of large purchases over an expected period of use time. For example, I put $250/mo. under expenses for 'Vehicle Purchase', as I estimate that I am going to buy a $30K vehicle (net, after trade-in) every 10 years ($30000/120 months). I do the same for cell phones ($1000 every 3 yrs), vacations, home repairs and furnishings. Upside is it reduces the 'lumpiness' of expenses but the downside is that it's not a pure cash view as I think you're doing, which is also useful.
    Anyway thanks again for the video!

    • @humphrey
      @humphrey  2 роки тому +3

      I've considered the amortization method before. I think it works well, I usually just look at my stats on a monthly average anyway, so if I was in April I'd just be totaling up my four months divided by four, June divided by 6 etc, so I think you can do it either way. For the liabilities portion, I don't have debts so it's a bit naive for me. Once I have a mortgage payment I'd probably add the liabilities section, but I'd probably just create a separate line for "Mortgage Expense" under "Fixed Expenses" section and just call it a fixed expense.

  • @bensloneker
    @bensloneker 2 роки тому

    What do you do about pending charges and stuff like that at the point of recording? I always get tripped up when trying something like this about when to record the data. 1) when I actually make the purchase, or 2) when the money leaves (or enters) my account officially

  • @jeffreydelacruz2548
    @jeffreydelacruz2548 2 роки тому

    Hi been following your channel for quite sometime..I do have one question..what happens to all my investment if I pass away?will my heirs get it tax free? Thanks 😊

  • @JohnFrahm0676
    @JohnFrahm0676 День тому

    What spending tracker app wpuld you recpommend for a couple? Wife and I pool our resources and like your spreadsheet for the detail. My missing piece is the spending transaction capture.

  • @annonomys41
    @annonomys41 2 роки тому +1

    This is really cool, thanks for sharing! Do you have a place where you are tracking how/where you are spreading the savings to, or is the $ figure of the savings rate row essentially what you keep in checking?

  • @MrTohmaytoe
    @MrTohmaytoe Рік тому

    Hey Humphrey, what are the rules you're using to turn the cell red, yellow or green? I'm using the spreadsheet but the overall profit/loss column shows red despite me having a profit. I feel like it would make more sense to only turn red if I'm in the negative. Thanks!

    • @humphrey
      @humphrey  Рік тому +1

      I believe its conditional formatting for positive/negative

  • @ousmand742
    @ousmand742 Рік тому

    Can anyone give me some advice on sing this excel sheet. Where do we put our 401k payment. In fixed expenses?

  • @_jackperez_
    @_jackperez_ 2 роки тому

    Anyone know the tracking app he uses? Mentioned it a few times

    • @humphrey
      @humphrey  2 роки тому

      Spending Tracker on iOS

  • @danilocampolo4498
    @danilocampolo4498 2 роки тому

    Hi Humphrey, really interesting, thanks! I can't find the link to your spreadsheet in the comment section...can you point me in the right direction please?

    • @humphrey
      @humphrey  2 роки тому

      Its in the description, but here too: docs.google.com/spreadsheets/d/1qC11pdB_S7ZZZxevoHut_JjdlH28BA__wAzg-SroSj4/edit#gid=815400425

    • @danilocampolo4498
      @danilocampolo4498 2 роки тому

      @@humphrey cheers mate!

  • @Maxschellenberg
    @Maxschellenberg Рік тому

    How do you manage your credit cards?

  • @ryaniskra8754
    @ryaniskra8754 10 місяців тому

    I know this video is older but for those who see this I made a graph that could be useful. Highlight Summary all the way down to December at the top left and without highlighting the Income section highlight the Expenses and Profits/Loss sections. Insert a stacked bar graph or an area graph. Boom now you have a graph that shows you how much your expenses eat at your income. Some problems occur with how the graph looks if you are in a loss so don't do that.

  • @JC-JC20
    @JC-JC20 2 роки тому

    maybe I missed it or cant see it...but where is your electricty/gas bill or mortgage?

  • @StephenBAng
    @StephenBAng 2 роки тому +1

    I can’t use File and go to Excel on an iphone. Any solution?

  • @lIllIlIllIlIlI
    @lIllIlIllIlIlI 2 роки тому

    You said you use a spending tracker on your phone - which one do you use?

    • @humphrey
      @humphrey  2 роки тому

      "Spending Tracker" on iOS

  • @ousmand742
    @ousmand742 Рік тому

    does anyone know if there is a notion version of this anyone open-sourced?

  • @everapple1415
    @everapple1415 2 роки тому

    What’s the spending tracker app you use?

    • @humphrey
      @humphrey  2 роки тому +1

      It’s called “spending tracker” on the App Store

    • @everapple1415
      @everapple1415 2 роки тому

      @@humphrey thanks

  • @jeankapaez-colon4096
    @jeankapaez-colon4096 2 роки тому

    What app does he use to track his spending?

    • @humphrey
      @humphrey  2 роки тому

      "Spending Tracker" on iOS app store

  • @matthewmaret2048
    @matthewmaret2048 2 роки тому +4

    Is there any way that you could send this in a regular excel format.?

    • @Paulcraighill
      @Paulcraighill 2 роки тому +1

      Open as a Google Sheet and hit “share and export” it should give you a bunch of options. One of which will be Excel.

    • @Paulcraighill
      @Paulcraighill 2 роки тому

      He’s actually added that advice in description.

  • @obesia1873
    @obesia1873 10 місяців тому

    Devastated to see he has a Date budget ... he is MINE ladies!

  • @QueenFinSov
    @QueenFinSov 2 роки тому

    ❤️‍🔥

  • @noreenn6976
    @noreenn6976 Рік тому +1

    752k subscribers and you reply to comments 👍

  • @mr.financial
    @mr.financial 2 роки тому +3

    Have you ever used a free version of something similar? Wealthica is what I use 😎 I love automation (And it also tracks crypto with some accounts). I'm in canada so it may not be as effective south of the border...

    • @michaelurbani85
      @michaelurbani85 2 роки тому

      I use mint. It does just enough for me and saves me so much time.

    • @humphrey
      @humphrey  2 роки тому +1

      Nice Ill have to try that...!

  • @oooooo3231
    @oooooo3231 2 роки тому

    wow, does no one else know how to do this?

  • @macrosales4438
    @macrosales4438 2 роки тому

    I don’t know it might be that scrooge inside me but I still drinking just because I got tired of spending too much money at the bar, but honestly I scared up a lot of Isis just so I can save more money.

  • @racistmoneky6946
    @racistmoneky6946 2 роки тому +1

    how to get rich: make youtube channel on investing for broke college students and become an internet idol

  • @brodencoulter4893
    @brodencoulter4893 2 роки тому

    Humphrey, love the spreadsheet! I have a much smaller one than you that tracks my monthly P&L for the year. I have an investing question for you... So I am 23 and have been working for about 9 months since graduation and have a 401(k) through my employer which is the bulk of my retirement accounts. As well as a Roth IRA with a very small amount in it that I don't add to as often because I am trying to build up my savings account a bit. I used Robinhood in college but pulled all of my money out of there after the wall street bets stuff a few years back - I am looking for a reliable investing site where I can do some personal investing that I can pull out fairly quickly and was wondering what your recommendation is? I don't really trust Robinhood anymore because of that stuff so I need a reliable site that I can pull out if needed. Thanks!

  • @miniyoon9108
    @miniyoon9108 Місяць тому

    misc body.

  • @smooshjen
    @smooshjen 2 роки тому

    The high "treating people" percentage... I feel like it's definitely a Chinese thing. LOL. No, but, seriously, it's good karma in moderation. I'm surprised you don't donate to charity. It can contribute a significant tax write off.

  • @danielotoole9610
    @danielotoole9610 2 роки тому +1

    Clickbait title. The sheet did not make you a millionaire, your investments and income streams did.

  • @samanthacurtin7605
    @samanthacurtin7605 2 роки тому

    Hi Humphrey! I lead a team of learning designers and would love to talk to you more. I sent you a message on Instagram but not sure of the best way to reach out to you. Im interested in having you potentially speak to my team! Please let me know the best way to discuss more. Would this be through your patreon? Thanks!