Diversification is the secret to optimal performance. This is why I have my interests set on market sectors based on performance and projected growth, such as the EV sector, renewable energy, Tech, and Health. Keep investing regularly and you'll be blown away how much it can change in a few short years. Here's to $1 million and to FIRE
If you don’t understand the markets, stick to an index like the S&P 500. Dollar cost average and hold long term, or better still consider financial advisory to avoid losses
Sometimes I'm surprised most people don't even know they can do that. I've been making at least 200k every year from my investments by working with an FA. When you realise it, it feels like a life hack.
Wow, that's interesting . I've recently been exploring the option of working with an FA too. Any chance you could recommend who you work with? in her area and works for Empower Financial
‘’Aileen Gertrude Tippy’’ is her name. She is regarded as a geniusl Services. By looking her up online, you can quickly verify her level of experience. She is well knowledgeable about financial markets.
Every crash/collapse brings with it an equivalent market chance if you are early informed and equipped, I've seen folks amass up to $1m amid economy crisis, and even pull it off easily in favorable conditions. Unequivocally, the collapse is getting somebody somewhere rich.
I do not disagree, there are strategies that could be put in place for solid gains regardless of economy or market condition, but such execution are usually carried out by investment experts with experience since the 08' crash.
The issue is people have the "I want to do it myself mentality" but not equipped enough for a crash, hence get burnt. Ideally, advisors are reps for investing jobs, and at first-hand encounter, my portfolio has yielded over 300% since 2020 just after the pandemic to date.
NICOLE ANASTASIA PLUMLEE' is her name. She is regarded as a genius in her area and works for Empower Financial Services. She’s quite known in her field, look-her up.
4:37 - Easier to copy the list of descriptions in the category column and paste as values, remove duplicates in the data header and use 'SUMIFS', =SUMIFS(D:D,F:F,$I2). Way easier and less manual work. Or create a pivot table
It is easier to use a pivot table and see the sum of all your expenses than to try and create complicated calculations. Also, you should add subcategories ie. Essential -> Sub-category Food. That way you can pivot your table on the category and then if needed break down everything into a sub-category and see where you over/under spent!
As an lnvesting enthusiast, I often wonder how top level investors are able to become millionaires off investing. . I’ve been sitting on over $545K equity from a home sale and I’m not sure where to go from here, is it a good time to buy into stocks or do I wait for another opportunity?.
If you are thinking of investing in the stock market and you are not well versed, its advisable to work with a financial advisor who is an expert to guide you through the process. this way you could make more profit with less risk
Working with a financial advisor has been a game-changer for me. They provided invaluable insights and tailored strategies that aligned perfectly with my risk tolerance and financial objectives. With their support, I've seen significant growth in my investments and gained confidence in my financial future.
I'd recommend SOPHIE LYNN CARRABUS. She is a genius when it comes to diversifying her holdings. You can verify her identity for yourself by looking her up online. She is well knowledgeable about the financial markets.
My CFA SOPHIE LYNN CARRABUS a renowned figure in her line of work. I recommend researching her credentials further... She has many years of experience and is a valuable resource for anyone looking to navigate the financial market..
I do the same thing. I have a spreadsheet dashboard that tracks my finances and every year (for the past 10 years) I’ve recorded the number. I started with £644 in 2014. It’s now £100,000+
Lol - my excel knowledge is deficient and this was the format I created when I first did this - but thanks for noting that this would probably be better!! Once you have the format though, you can just copy and paste it for new spending each year, so not a huge deal! Hopefully the overall system and way of looking at your finances was helpful though 🤗
@@timothymarchanthe's not giving financial advice... and what has ability with excel got to do with it even if he was? That's like saying you can't be an art teacher if you're not experienced with spray cans. Excel is just a tool. You can be a master of excel and terrible with personal finance (many are) and the exact opposite can also be true
The legend is back. Thank you for pushing me to go and apply for vacation schemes when they open in September any tips on them especially for clifford chance would be amazing ❤
Good luck with them! Emphasise what life experience you have and how you have taken steps in that to have a positive impact - show what you have made happen! 🤗
This is amazing and seems a worthwhile effort. However, as a lawyer from across the pond, the expenditures are striking between the two comparative markets (London vs NYC/Philly suburb). Our mortgage, obtained when rates were low, is $2500 and includes insurance and property tax; 2 bedroom rentals are $2100 per month at a minimum (plus electric (200+), gas (40), water (50), sewer (30), trash pickup (20), lawn or maintenance service(50)). Food expenses are significantly higher, for groceries and take out (you have several different food categories, but based on the total of non essentials, that amount would cover lunch out at work for the month. Forget pizza night!). Mobile is $100-200 a month; TV/internet/subscriptions around $250 monthly. And at $50, you could only get your hair cut three times a year! A man's cut is $20 with tip. I know the pound has more purchasing power, but wow! Also, very impressed with your low spending on "goods." Any Americans have ideas on cutting expenses?
@@SoulRBG I suppose if you are splitting the rent or renting a room it's possible. But even assuming a 50% tax rate, he only needs to make 80k quid per year in a high end market to live comfortably. I think American metro areas have a much higher cost of living.
My mortgage (ldonon lawyer) was about US$120,000 a year at one point ( at its very worst), however so it depends your life stage (we have children, a bigger house etc). My broadband as I pay for two accounts is about US$260 a month. And once you have children in the US and UK the costs go sky high - 50% of our net salaries in first year of the baby in the 1980s and one of my children pays about US$78k a year divided by her and her spouse so half each but still a vast sum just to be able to work because of UK Government very very high employer taxes on top of the wage page.
Investing in mutual funds offers a structured and diversified approach to building wealth, managed by professional fund managers. While there are costs and some limitations, the benefits of diversification, professional management, and ease of access make mutual funds a popular choice for achieving a variety of financial goals.
Exactly, I used to doubt the value of a financial advisor until my wife's company assigned her an investment adviser in 2020. Honestly, it’s been the best financial decision I’ve made. It helped tremendously; I went from barely making any profit to having a well-diversified portfolio that has grown significantly, with gains exceeding $850k.
My CFA is Karen Marie Gendron, a renowned figure in her line of work. I recommend researching her credentials further... She has many years of experience and is a valuable resource for anyone looking to navigate the financial market..
Thank you for your openness with regarding your personal finances. It makes it a lot easier to understand and it is nothing which I consider to take for granted.
Good job. My approach is similar. Don't forget to check all that stuff...as invoices, statements, salary bulletin, etc. are electronic there's a tendency to not look at them anymore. Then things go under the radar.
I am at the beginning of my "investment journey", planning to put 85K into dividend stocks so that I will be making up to 30% per year in dividend returns. Any advice?
Investing without proper guidance can lead to mistakes and losses. I've learned this from my own experience.If you're new to investing or don't have much time, it's best to get advice from an expert.
If you are thinking of investing in the stock market and you are not well versed, its advisable to work with a financial advisor who is an expert to guide you through the process. this way you could make more profit with less risk
you are completely right, Advisors have information and paths that are not disclosed to the public.. I profited $560k in 2023 under the tutelage of my Fiduciary-counselor. Am I selling? Absolutely not.. I am going to sit back and observe how this all plays out.
Due to my demanding job, I lack the time to thoroughly assess my investments and analyze individual stocks. Consequently, for the past seven years, I have enlisted the services of a fiduciary who actively manages my portfolio to adapt to the current market conditions. This strategy has allowed me to navigate the financial landscape successfully, making informed decisions on when to buy and sell. Perhaps you should consider a similar approach.
One thing I do is identify the recurring items, such as subscriptions, the annual renewals, the budget/forecasts, you would need to up your excel skills to do that. I like the auto-investing, it ensures that the fund(s) are topped up, so you don't miss the money. It also leaves you to focus on other priorities such as career, health, etc. as the funds make the decisions on what to buy and sell. Over the years, I have lost a lot on poor timing as I was distracted by other demands. You are very fortunate to have such a high salary, it's wise to save lots while you can. Beware of property, it is entering a very risky ear due to the changing tax environment, it also can take a lot of your time, particularly if you are not familiar with methods used by the more experienced.
I've entered the formula (tweaked the columns as I am using G instead of F and my total is 0. Any ideas what I am doing wrong? I have also changed the category
I own a spreadsheet consultancy/data consultancy company so if you ever want to speed up your bank statement section you could do it monthly and it be a singular click and automatically done
Another great video, thank you. Is there any chance you could consider a video, or a Q&A video regarding what someone aspiring to a corporate law degree should be looking for: A levels, Duke of Edinburgh, good uni's that firms look for, the need dor internships etc ?
Can you please do a video on paying off your student loan plan 2, I'm a high earner and I know that it is the right thing at 8% interest compounding monthly but I can't bring myself to start paying it down as everyone tells you not to. This is due to it wiping in 30 years, the govt can change the terms at any point and it's income contingent. Trouble is I'm looking at paying £100k for my degree, if I start paying it down early it will cost £66k. Both options aren't great but it would be good to hear your thoughts as I know you've started to pay yours down. Thank you so much x
If you're a higher earner and expect to remain a high earner then it's a debt not a tax so pay it off ASAP. Rules can change but given state of the public purse it's highly unlikely that changes will be favourable
Hi Liam, interested to know if you use credit cards for your day to day spending to take advantage of bonuses/points or whether all of the spending shown in the video is using debit cards? Or what your general view on this is. Thanks
I have the same question. As I would have to run this exercise using Credit Card data, if that is even possible to download in CSV format. Surely you are losing lots of benefits by not using a credit card?
Great video - thnx Excel wise, you can highlight the entire row, copy it, then go on data tab and remove duplicates, you will have a condensed list. Can then simplifying/speed up the sumif: change =SUMIF(F:F,”Bank Fees”,D:D) to =SUMIF(F:F,I3,D:D) and drag it down. Could also insert a pivot table. How do you categorise stuff that you have no idea what it is (i.e. random shop in a different city 9 months ago)? Aldi etc is easy but there are some random descriptions about like "izettle" Also be interested on your views on student loan for average salary graduates. Clearly makes sense for you to chip away at yours as you will pay it off anyway and save on the interest
Hey George, thanks so much for this - lawyers don’t excel, so appreciate that the excel steps could be streamlined! Still hope the overall system and way of looking at your finances was helpful 🤗 I generally categorise all foreign currency transactions (assuming I’m not living abroad!) as holiday. If there is stuff I have no idea about, I take a reasonable guess at the spending, but it is very rare that there is a material expense for > £100 that I can’t figure out in a minute or two based on the date and my iPhone calendar 🤗
And on student loans - if you are not confident you will pay the whole thing off within 15-30 years, I wouldn’t ever overpay. You will lose the present value of your cash overpaying it, and then also likely never actually see the gain of getting more of your pay check into your account each month 😊 Beth, for example, has left hers and will likely never pay it off!
Because my excel knowledge is deficient and this was the format I created when I first did this - but thanks for noting that this would probably be better!! Once you have the format though, you can just copy and paste it for new spending each year, so not a huge deal! Hopefully the overall system and way of looking at your finances was helpful though!
I used to do a complete financial analysis every quarter, categorized everything, balanced my check book bi-weekly, etc. I spent hours knowing exactly where every penny of my $$ was coming from & where it was going (expenses by category, savings, investments). Then one day I realized that I knew w/i $2-$5 range the numbers that mattered most without this effort. So, now I save that time waste doing other things & enjoying life w/o worry.
Yes. As humans...we are creatures of habit. So without any extra events or abnormal situations occurring, we literally spend about the same each month. If your food bill was $400 last month it's more than likely not you're not gonna spend $800 the next. It's usually gonna be a small range. And other expenses like mortgage and utilities are pretty much fixed costs.
hey, I love your channel, but please control that clickbait 😭. That system does NOT make you millonaire, rather your salary. have been using a budget, saving and investing what I can for years and I am very far from where you are.
Hey! Thanks for your support! I appreciate this, but unfortunately RUclips’s algorithm is so strongly impacted by getting people to click on a title and thumbnail, it’s the only way videos get any views now unfortunately! I test different thumbnails and titles to see what gets the highest click through rate and then use that. It’s a shame, but sadly what is needed to get people to see what I still hope is very helpful content behind that title and thumbnail! 🤗
@@liam.porritt thanks for answering liam. did not meant to sound shaming or anything. i hate that aspect of youtube, even though i completely understand that side for creators. good luck and keep it up with your content ❤️
@@liam.porritt I see nothing wrong with the title, would help if you added in a minute of, based on current projects I'll have my net worth of a million by 2029...? And explain how this exercise connects to that. Currently a "slight" disconnnect between title and content. Otherwise. Great Video!
I reckon you're losing as much interest as you are gaining, Liam. I used to be subbed but hit the button again for this reason; it just makes videos feel like a let down. Be true to yourself and be true to those that support you. Bye mate.
Used to do the same for years with transactions, then just decided to pay for Snoop subscription (Emma and other similar ones would do the trick) - save myself hours of work
This is pointless when you can just pay a few dollars a month to easily see your spending across your accounts. This is way too time-consuming for the average bloke.
@@texasowl5356There are apps that account for every dollar and help you make sure that you have no CC debt. I use YNAB currently. It’s not cheap but time savings is worth it for me.
@@texasowl5356exactly… i have friends who have the automated apps and they have no idea where their money is going… because they dont have to look at it since it’s done automatically. Automation for financial tracking defeats the purpose… you spend more money on an app and you dont hold yourself accountable for each transaction since you dont have to type it in. I update my spreadsheet weekly not once a year though, it takes probably 15-20mins and i follow everything to the last cent.
5:35 it’s painful to watch you do it this way. Have you heard about pivot tables? If not please at least use the formula =unique(F:F) and the sumif use the cells in col I instead of typing the categories
Also a biglaw associate, although not a junior, here. Your approach is way too tedious. No wonder you can’t do this more than once a year. I do this monthly. Pay for a finance app. There are plenty around and not that expensive. Otherwise, learn to excel. For example, you could’ve listed unique from your categories and then make your sumif pull from that column and just drag down to automate everything at once. Learning to excel makes it so much faster
Why should I believe you track you money if you don't police your comments section based on what I see are probably some bot comments? Dude not saying you don't but it is very hard to believe you have bot looking comments but have the time to track cash? Like how does that make logical sense?
£90 per month on mobile phone bill?!?!....I pay O2 £8.70 per month and they don't have roaming fees in the EU 😉 Never buy cell phones through a contract, especially on your salary
So many poeple saying there are apps that will categorise this automatically. And I kinda disagree. While you can connect your bank accounts to such apps, they will miss a lot of categorisations, creating inaccurate reports. But most importantly, I feeling counting this manually gives me a good sense and realisation of what's going on with my finances. Whereas if I automate it, I tend to forget about it. It's so (or not so) satisfying adding a spending of +200 bucks in clothes and realising you didn't need them, so you can take action and stop overspending in clothing
@ so what leave the money in the bank to rot? Obviously you’d cycle the savings into investments that compound into thousands and thus after 7 years, bublu tera chacha gandu
All these "millionaires" are so charitable they spend every waking moment on you tube, with the rasp voice explaining to the rest of us how simple it is... All these you tube millionaire are bullshit, if they were so rich they wouldnt be peddling it on you tube.
Diversification is the secret to optimal performance. This is why I have my interests set on market sectors based on performance and projected growth, such as the EV sector, renewable energy, Tech, and Health. Keep investing regularly and you'll be blown away how much it can change in a few short years. Here's to $1 million and to FIRE
If you don’t understand the markets, stick to an index like the S&P 500. Dollar cost average and hold long term, or better still consider financial advisory to avoid losses
Sometimes I'm surprised most people don't even know they can do that. I've been making at least 200k every year from my investments by working with an FA. When you realise it, it feels like a life hack.
Wow, that's interesting . I've recently been exploring the option of working with an FA too. Any chance you could recommend who you work with? in her area and works for Empower Financial
‘’Aileen Gertrude Tippy’’ is her name. She is regarded as a geniusl Services. By looking her up online, you can quickly verify her level of experience. She is well knowledgeable about financial markets.
Thanks a lot for the recommendation. I'll send her an email and I hope I'm able to connect with her.
Every crash/collapse brings with it an equivalent market chance if you are early informed and equipped, I've seen folks amass up to $1m amid economy crisis, and even pull it off easily in favorable conditions. Unequivocally, the collapse is getting somebody somewhere rich.
I do not disagree, there are strategies that could be put in place for solid gains regardless of economy or market condition, but such execution are usually carried out by investment experts with experience since the 08' crash.
The issue is people have the "I want to do it myself mentality" but not equipped enough for a crash, hence get burnt. Ideally, advisors are reps for investing jobs, and at first-hand encounter, my portfolio has yielded over 300% since 2020 just after the pandemic to date.
NICOLE ANASTASIA PLUMLEE' is her name. She is regarded as a genius in her area and works for Empower Financial Services. She’s quite known in her field, look-her up.
🚨🚨🚨 SCAM ALERT 🚨🚨🚨
This is the most bot comment I have ever seen 🫢
4:37 - Easier to copy the list of descriptions in the category column and paste as values, remove duplicates in the data header and use 'SUMIFS', =SUMIFS(D:D,F:F,$I2). Way easier and less manual work. Or create a pivot table
Thanks for this Dale - lawyers don’t excel, so appreciate this tip! Still hope the overall system and way of looking at your finances was helpful 🤗
Came here to say just this - as someone that works with data I begged to help with efficiency!
Use UNIQUE to populate I column also
Yeah easiest way is a pivot table
@@danielhague good tip
It is easier to use a pivot table and see the sum of all your expenses than to try and create complicated calculations.
Also, you should add subcategories ie. Essential -> Sub-category Food. That way you can pivot your table on the category and then if needed break down everything into a sub-category and see where you over/under spent!
As an lnvesting enthusiast, I often wonder how top level investors are able to become millionaires off investing. . I’ve been sitting on over $545K equity from a home sale and I’m not sure where to go from here, is it a good time to buy into stocks or do I wait for another opportunity?.
If you are thinking of investing in the stock market and you are not well versed, its advisable to work with a financial advisor who is an expert to guide you through the process. this way you could make more profit with less risk
Working with a financial advisor has been a game-changer for me. They provided invaluable insights and tailored strategies that aligned perfectly with my risk tolerance and financial objectives. With their support, I've seen significant growth in my investments and gained confidence in my financial future.
@@PatrickLloyd- Could you kindly elaborate on the advisor's background and qualifications?
I'd recommend SOPHIE LYNN CARRABUS. She is a genius when it comes to diversifying her holdings. You can verify her identity for yourself by looking her up online. She is well knowledgeable about the financial markets.
My CFA SOPHIE LYNN CARRABUS a renowned figure in her line of work. I recommend researching her credentials further... She has many years of experience and is a valuable resource for anyone looking to navigate the financial market..
I do the same thing. I have a spreadsheet dashboard that tracks my finances and every year (for the past 10 years) I’ve recorded the number. I started with £644 in 2014. It’s now £100,000+
Bro needs a pivot table
Lol - my excel knowledge is deficient and this was the format I created when I first did this - but thanks for noting that this would probably be better!! Once you have the format though, you can just copy and paste it for new spending each year, so not a huge deal! Hopefully the overall system and way of looking at your finances was helpful though 🤗
@@liam.porritt Pivot tables are for Excel novices, Liam - using formulae gives you so much more control over how your data looks.
Excel knowledge not good? Why are you giving financial advice?
@@timothymarchanthe's not giving financial advice... and what has ability with excel got to do with it even if he was? That's like saying you can't be an art teacher if you're not experienced with spray cans. Excel is just a tool. You can be a master of excel and terrible with personal finance (many are) and the exact opposite can also be true
@@timothymarchanthes not… he’s showing you how he tracks his net worth… you’re definitely poor 😂
The legend is back. Thank you for pushing me to go and apply for vacation schemes when they open in September any tips on them especially for clifford chance would be amazing ❤
Good luck with them! Emphasise what life experience you have and how you have taken steps in that to have a positive impact - show what you have made happen! 🤗
@@liam.porritt thank you so much hopefully seeing you there soon !
This is amazing and seems a worthwhile effort. However, as a lawyer from across the pond, the expenditures are striking between the two comparative markets (London vs NYC/Philly suburb). Our mortgage, obtained when rates were low, is $2500 and includes insurance and property tax; 2 bedroom rentals are $2100 per month at a minimum (plus electric (200+), gas (40), water (50), sewer (30), trash pickup (20), lawn or maintenance service(50)). Food expenses are significantly higher, for groceries and take out (you have several different food categories, but based on the total of non essentials, that amount would cover lunch out at work for the month. Forget pizza night!). Mobile is $100-200 a month; TV/internet/subscriptions around $250 monthly. And at $50, you could only get your hair cut three times a year! A man's cut is $20 with tip. I know the pound has more purchasing power, but wow! Also, very impressed with your low spending on "goods." Any Americans have ideas on cutting expenses?
I was thinking the same thing as I was doing the conversions to USD. Imagine if housing costs were less than $1500/m...
@@SoulRBG I suppose if you are splitting the rent or renting a room it's possible. But even assuming a 50% tax rate, he only needs to make 80k quid per year in a high end market to live comfortably. I think American metro areas have a much higher cost of living.
My mortgage (ldonon lawyer) was about US$120,000 a year at one point ( at its very worst), however so it depends your life stage (we have children, a bigger house etc). My broadband as I pay for two accounts is about US$260 a month. And once you have children in the US and UK the costs go sky high - 50% of our net salaries in first year of the baby in the 1980s and one of my children pays about US$78k a year divided by her and her spouse so half each but still a vast sum just to be able to work because of UK Government very very high employer taxes on top of the wage page.
Buy a $40k RV with a loan and pay a min of $950 USD/mo at 14% interest and within a few years, youll own an RV instead of paying rent to your landlord
Legend, thanks for the excel tips - that actually has really helped me.
Investing in mutual funds offers a structured and diversified approach to building wealth, managed by professional fund managers. While there are costs and some limitations, the benefits of diversification, professional management, and ease of access make mutual funds a popular choice for achieving a variety of financial goals.
ADBE, VWINX and FSPGX are all still good buy, but what do I know I’m not a financial advisor lol
Exactly, I used to doubt the value of a financial advisor until my wife's company assigned her an investment adviser in 2020. Honestly, it’s been the best financial decision I’ve made. It helped tremendously; I went from barely making any profit to having a well-diversified portfolio that has grown significantly, with gains exceeding $850k.
I’ve been worried sick about the current state of my portfolio, who is your advisor?
My CFA is Karen Marie Gendron, a renowned figure in her line of work. I recommend researching her credentials further... She has many years of experience and is a valuable resource for anyone looking to navigate the financial market..
Just ran an online search on her name and came across her website, pretty well educated. thank you for sharing.
Thank you for your openness with regarding your personal finances. It makes it a lot easier to understand and it is nothing which I consider to take for granted.
Nice one! You could also create a pivot table instead of using the sumifs, it simplifies the step! :)
Thanx for your videos. Have just began watching your channel and I already loving it. Keep up your good works and have a nice summer
Thanks so much Torben! Hope you have a great summer too!
This is a really good vid and very clear for anyone to follow and still has lot of takeaways for people who have control on finances. Great work Liam!
This is great, but a budgeting app like Emma would save time and do a lot more than this.
Good job. My approach is similar. Don't forget to check all that stuff...as invoices, statements, salary bulletin, etc. are electronic there's a tendency to not look at them anymore. Then things go under the radar.
I am at the beginning of my "investment journey", planning to put 85K into dividend stocks so that I will be making up to 30% per year in dividend returns. Any advice?
Investing without proper guidance can lead to mistakes and losses. I've learned this from my own experience.If you're new to investing or don't have much time, it's best to get advice from an expert.
If you are thinking of investing in the stock market and you are not well versed, its advisable to work with a financial advisor who is an expert to guide you through the process. this way you could make more profit with less risk
you are completely right, Advisors have information and paths that are not disclosed to the public.. I profited $560k in 2023 under the tutelage of my Fiduciary-counselor. Am I selling? Absolutely not.. I am going to sit back and observe how this all plays out.
Due to my demanding job, I lack the time to thoroughly assess my investments and analyze individual stocks. Consequently, for the past seven years, I have enlisted the services of a fiduciary who actively manages my portfolio to adapt to the current market conditions. This strategy has allowed me to navigate the financial landscape successfully, making informed decisions on when to buy and sell. Perhaps you should consider a similar approach.
@@SeanTalkoff I’ve been worried sick about the current state of my portfolio, who is your advisor?
One thing I do is identify the recurring items, such as subscriptions, the annual renewals, the budget/forecasts, you would need to up your excel skills to do that. I like the auto-investing, it ensures that the fund(s) are topped up, so you don't miss the money. It also leaves you to focus on other priorities such as career, health, etc. as the funds make the decisions on what to buy and sell. Over the years, I have lost a lot on poor timing as I was distracted by other demands. You are very fortunate to have such a high salary, it's wise to save lots while you can. Beware of property, it is entering a very risky ear due to the changing tax environment, it also can take a lot of your time, particularly if you are not familiar with methods used by the more experienced.
I've entered the formula (tweaked the columns as I am using G instead of F and my total is 0. Any ideas what I am doing wrong? I have also changed the category
Wheres this excel template
Can you share the spreedsheets ?
I own a spreadsheet consultancy/data consultancy company so if you ever want to speed up your bank statement section you could do it monthly and it be a singular click and automatically done
Another great video, thank you. Is there any chance you could consider a video, or a Q&A video regarding what someone aspiring to a corporate law degree should be looking for: A levels, Duke of Edinburgh, good uni's that firms look for, the need dor internships etc ?
Could you do an updated morning routine?
Can you please do a video on paying off your student loan plan 2, I'm a high earner and I know that it is the right thing at 8% interest compounding monthly but I can't bring myself to start paying it down as everyone tells you not to. This is due to it wiping in 30 years, the govt can change the terms at any point and it's income contingent. Trouble is I'm looking at paying £100k for my degree, if I start paying it down early it will cost £66k. Both options aren't great but it would be good to hear your thoughts as I know you've started to pay yours down. Thank you so much x
If you're a higher earner and expect to remain a high earner then it's a debt not a tax so pay it off ASAP. Rules can change but given state of the public purse it's highly unlikely that changes will be favourable
Interesting video!
Great progress!
Great videos always!
How do small businesses navigate early setbacks and challenges to transform into a successful business?
This is crazy free game
Hi Liam, interested to know if you use credit cards for your day to day spending to take advantage of bonuses/points or whether all of the spending shown in the video is using debit cards? Or what your general view on this is. Thanks
I have the same question. As I would have to run this exercise using Credit Card data, if that is even possible to download in CSV format. Surely you are losing lots of benefits by not using a credit card?
Living in debt is frowned upon in Europe.
I love your videos to watch. They are so inspiring and informative 😊❤
Thank you so much!
Great video - thnx
Excel wise, you can highlight the entire row, copy it, then go on data tab and remove duplicates, you will have a condensed list. Can then simplifying/speed up the sumif: change =SUMIF(F:F,”Bank Fees”,D:D) to =SUMIF(F:F,I3,D:D) and drag it down. Could also insert a pivot table.
How do you categorise stuff that you have no idea what it is (i.e. random shop in a different city 9 months ago)? Aldi etc is easy but there are some random descriptions about like "izettle"
Also be interested on your views on student loan for average salary graduates. Clearly makes sense for you to chip away at yours as you will pay it off anyway and save on the interest
He's a lawyer and excel isn't usually a core skill required :P
Hey George, thanks so much for this - lawyers don’t excel, so appreciate that the excel steps could be streamlined! Still hope the overall system and way of looking at your finances was helpful 🤗
I generally categorise all foreign currency transactions (assuming I’m not living abroad!) as holiday. If there is stuff I have no idea about, I take a reasonable guess at the spending, but it is very rare that there is a material expense for > £100 that I can’t figure out in a minute or two based on the date and my iPhone calendar 🤗
And on student loans - if you are not confident you will pay the whole thing off within 15-30 years, I wouldn’t ever overpay. You will lose the present value of your cash overpaying it, and then also likely never actually see the gain of getting more of your pay check into your account each month 😊 Beth, for example, has left hers and will likely never pay it off!
Can I have your spreadsheet please
Hogyan lehet magyar feliratot beállítani? Köszönöm szépen!
Why don’t you use a pivot table?
Because my excel knowledge is deficient and this was the format I created when I first did this - but thanks for noting that this would probably be better!! Once you have the format though, you can just copy and paste it for new spending each year, so not a huge deal! Hopefully the overall system and way of looking at your finances was helpful though!
I used to do a complete financial analysis every quarter, categorized everything, balanced my check book bi-weekly, etc. I spent hours knowing exactly where every penny of my $$ was coming from & where it was going (expenses by category, savings, investments). Then one day I realized that I knew w/i $2-$5 range the numbers that mattered most without this effort. So, now I save that time waste doing other things & enjoying life w/o worry.
Yes. As humans...we are creatures of habit. So without any extra events or abnormal situations occurring, we literally spend about the same each month. If your food bill was $400 last month it's more than likely not you're not gonna spend $800 the next. It's usually gonna be a small range. And other expenses like mortgage and utilities are pretty much fixed costs.
This is such a thorough breakdown! I feel like a simple app could automate 90% of this process. What’s stopping you from going fully digital? 🤔
Wheres this excel template? You show it off then dont provide it? Thanks bruh
You make it yourself lol, it depends on your bank accounts bruh
Finary does it good to !
You could use Finary and connect everything
hey, I love your channel, but please control that clickbait 😭. That system does NOT make you millonaire, rather your salary.
have been using a budget, saving and investing what I can for years and I am very far from where you are.
Hey! Thanks for your support! I appreciate this, but unfortunately RUclips’s algorithm is so strongly impacted by getting people to click on a title and thumbnail, it’s the only way videos get any views now unfortunately! I test different thumbnails and titles to see what gets the highest click through rate and then use that. It’s a shame, but sadly what is needed to get people to see what I still hope is very helpful content behind that title and thumbnail! 🤗
@@liam.porritt thanks for answering liam. did not meant to sound shaming or anything. i hate that aspect of youtube, even though i completely understand that side for creators. good luck and keep it up with your content ❤️
@@liam.porritt I see nothing wrong with the title, would help if you added in a minute of, based on current projects I'll have my net worth of a million by 2029...? And explain how this exercise connects to that. Currently a "slight" disconnnect between title and content. Otherwise. Great Video!
I reckon you're losing as much interest as you are gaining, Liam. I used to be subbed but hit the button again for this reason; it just makes videos feel like a let down. Be true to yourself and be true to those that support you. Bye mate.
Please use a pivot table 90% of the copy and paste and formulas can be done with a pivot table.
Hi Liam , I am fifteen I love the idea of being a lawyer. Is the newly qualified salary gained on the third year of being a corporate lawyer?
Want an updated what’s on my iPhone video
Hey Liam great video! What is your current amount you have spent? Over 500k :)?
Used to do the same for years with transactions, then just decided to pay for Snoop subscription (Emma and other similar ones would do the trick) - save myself hours of work
This is pointless when you can just pay a few dollars a month to easily see your spending across your accounts. This is way too time-consuming for the average bloke.
lol found the guy with CC debt. By having the system…. Every dollar is accounted for (literally) not just glanced at on an app.
@@texasowl5356that’s your take away?
@@JP7onEarthwhat bank is that? Thanx
@@texasowl5356There are apps that account for every dollar and help you make sure that you have no CC debt. I use YNAB currently. It’s not cheap but time savings is worth it for me.
@@texasowl5356exactly… i have friends who have the automated apps and they have no idea where their money is going… because they dont have to look at it since it’s done automatically. Automation for financial tracking defeats the purpose… you spend more money on an app and you dont hold yourself accountable for each transaction since you dont have to type it in. I update my spreadsheet weekly not once a year though, it takes probably 15-20mins and i follow everything to the last cent.
but excel reads csv files...
You could just do a pivot table and it would work this out for you after you do your category’s
1:45 Dude says he pays mortgage but his spreadsheets show he pays rent £11,200
Pivot instead of sum if, so much quicker
Mac in the thumbnail, Windows in the video. Macs give better click rates or why bother?
I thought it was a Mac too, but if you look closely it’s a PC.
What was your income in your first year as a corporate lawyer in comparison to now?
I wish I knew how to use excel bc I hand write monthly 😭
Pivot tables could do that in minutes
Somebody introduce this poor man to Quicken.
Just one word: Monzo
double inverted commas😐
An objective observation: you speak a lot in stacatto. Idk if it’s really you or if it’s something with the mic
Double inverted commas? You mean quotation marks......? Is that a Brit thing, because I've never heard it called that before.
Looks like a lot of work. Easiest and most efficient way to do it is in Notion.
Dude loves spending just £1 in Aldi
This “system” doesn’t make you a millionaire. Just better with money. This is facilitated with a 6 figure job and RUclips money.
5:35 it’s painful to watch you do it this way. Have you heard about pivot tables? If not please at least use the formula =unique(F:F) and the sumif use the cells in col I instead of typing the categories
Time Stamps man?
Added now!! Sorry and thanks! 🤗
Also a biglaw associate, although not a junior, here.
Your approach is way too tedious. No wonder you can’t do this more than once a year. I do this monthly.
Pay for a finance app. There are plenty around and not that expensive.
Otherwise, learn to excel. For example, you could’ve listed unique from your categories and then make your sumif pull from that column and just drag down to automate everything at once. Learning to excel makes it so much faster
Why should I believe you track you money if you don't police your comments section based on what I see are probably some bot comments? Dude not saying you don't but it is very hard to believe you have bot looking comments but have the time to track cash? Like how does that make logical sense?
Dude - there’s apps that do all this for you
Sir i am going to pursue my llb in uk can you please give me some advices personally
You will need to improve your English writing.
£90 per month on mobile phone bill?!?!....I pay O2 £8.70 per month and they don't have roaming fees in the EU 😉 Never buy cell phones through a contract, especially on your salary
Pivot tables pal
Use finary
So many poeple saying there are apps that will categorise this automatically. And I kinda disagree.
While you can connect your bank accounts to such apps, they will miss a lot of categorisations, creating inaccurate reports. But most importantly, I feeling counting this manually gives me a good sense and realisation of what's going on with my finances. Whereas if I automate it, I tend to forget about it. It's so (or not so) satisfying adding a spending of +200 bucks in clothes and realising you didn't need them, so you can take action and stop overspending in clothing
As an accountant, I’m surprised you’re not lol
How about buy properties in auction, house flip and sell? It works down here in Brazil.
this was painful to watch. so glad my bank does this for me.
So after all that you don't even show us the breakdown of your assets 😂 what was the point?
125,000 pounds a year? Geeeez
Does help that you’re on £150k+ per year. I would be a millionaire within 7 years on that salary and multi within 10
After paying taxes, you would not be a millionaire.
@ so what leave the money in the bank to rot? Obviously you’d cycle the savings into investments that compound into thousands and thus after 7 years, bublu tera chacha gandu
your excel skill is embarrassing
Bank fees, that bank can go pound sand.
All these "millionaires" are so charitable they spend every waking moment on you tube, with the rasp voice explaining to the rest of us how simple it is... All these you tube millionaire are bullshit, if they were so rich they wouldnt be peddling it on you tube.