UPDATE: Since some of you requested it, I have now added a template of the sheet I used in the video in the description of this video. You can make your own copy and rename things according to your own finances. A bit more info in the description box. Hope it helps! Please let me know if for some reason it doesn't work, and I'll try to fix it ASAP.
@@litokoba9976 everyone has access to it with the link in the description box - All you have to do is hit "File -- Make a Copy" and you'll have your own copy to edit.
thanks for the template! I'm planning to use it as base and automate it bit more to provide margins, cashflow info along with assets, liabilities . If you want me to share this file, please do let me know, I would feel happy to help
Successful people don't become that way overnight. What most people see at a glance- wealth, a great career, purpose-is the result of hard work and hustle over time. I pray that anyone who reads this will be successful in life..
Your template was so helpful! I worked out my spending for the year, figured out where I should cut back on subscriptions, and set up a new blank version with a potential budget for next year. Thank you!
A massive thank you Lina! This advice and spreadsheet has definitely saved my finances for the future!! I have always been lazy with managing money because havent had the need for it. Last few years have been tough since my monthly commisson has changed drastically and I didnt react to it. Started going into debt with budgets. With my calculations I will be debt free in 7 months. Im so happy! Greetings from Finland!
Thank you for sharing this informative video on budgeting! I really appreciate the clear and concise explanations, and I feel much more confident about creating a budget for myself. Great work!
There’s also a ‘sum’ button in excel which you can just click, whilst the values you want to add up are highlighted. It’s a Sigma symbol in the top right.
Thank you so much for this video! I ve been looking for a template and a way to track my money, in a way which speaks and appeals to me, and which feels intuitive, without being too overly complicated. Thanks a ton, this has been a great start and has helped me get going!
I've been tracking my finances via Excel for a few years and it's so rewarding! I update my spreadsheet weekly because I like the regular check ins, especially for categories like food and entertainment. Some areas I struggled with were budgeting for the expenses that went on my credit card but then not having a schedule for when I transferred money to pay it off. Now I check my cc every 2-3 days and transfer the balance in full (versus monthly). I also have a section for my investments because I love entering the numbers and seeing it grow. I'm also in Canada!
Thanks for the tips! Just a suggestion that will make things easier for your subscribers: Sharing the template of the sheet you used in a video will be very helpful to people who enjoyed your model and want to start using your template, so they don't need to spend time going through the video to make a similar template, instead they can just download it.
Thank you so much for the spreadsheet, you're the only one who linked it for free and i appreiciate it so much as a fresh graduate student who's struggling living alone. Also thanks for the financial information :)
"Would you like me to give you a formula for success? It's quite simple, really: Double your rate of failure. You are thinking of failure as the enemy of success. But it isn't at all. You can be discouraged by failure or you can learn from it, so go ahead and make mistakes. Make all you can. Because remember that's where you will find success." -- Thomas J. Watson----
I love this spreadsheet! Thank you! 1. You can set conditional formatting on the monthly expenditure cells to, for example, turn red if the amount goes over the budget. 2. You can add a column after the Budget column (make a new Column "C") to show if you are within budget for the year. For each row, enter a formula that sums the values of cells for that row (Jan to Dec) and divides by the number of cells with data (COUNTIF(B12:N12,NULL) to show how much you are over or under so far for the year. Note: It's been a few years since I used Excel so I probably don't have the best syntax but you get the idea.)
Thanks for the work. The Daywork alouds awesome personal overviews and graphics for yourself. Make this for years ... and is going every day better and better.
Forget typing sum and brackets etc when wanting to add up just select the column or rows and add an empty box at the end then click auto Sum or the Greek E button and it adds it up for you and fills that number in the empty box. Bit easier.
I generally budget in my head, and write things down; but as of recently I’ve gotten into a few different income revenue from different things. So now I feel like I need to excel or google sheets it, thank you for the tips. Also in a yr or two (kinda late, but because of life) in investing in a Roth IRA for retirement. I’m a new sub!!!!
you're right, there is a better way to do it. I was doing it like you and now it's all automated for me. If you're interested I can share my template with you.. it gives you a dashboard too. All in google sheets.. all you have to do is do the daily journal entries and everything else is automated.
thank you very much. This really helped in more ways than one. I've been looking for these types of videos and this is the most efficient by far, thank you
Thank you so much for your explanation and template! TH-cam recommended your video to me so it's my first time visiting your TH-cam channel! I loved your video and just downloaded your template! it's amazing and so easy for a finance noob like me!!! many thanks and you just got a new subscriber here!!! love you and will be supporting you!!! you're so awesome
Thank you so much for sharing this. I am also a freelance actor/director in my 20s and one of the steps I’m trying to take to get my life together is to manage my personal expenses, but all systems assume a fixed income set up, which aren’t friendly for creative freelance lifestyles. This finally gave me some direction of how I can go about my own budgeting and finance tracking. Cheers and break a leg in all your acting related endeavors. 🎬
I'm so happy this was helpful to you! I totally get that, being self-employed makes things a bit more difficult in terms of keeping track of our finances but it's totally do-able! I've changed my business set up a little bit now, I think as you start tracking you'll see what changed would be good to make to your own set up until you have it all good to go
This is the only video I found that fit me PERFECTLY. I've downloaded the sheet and am using it. It's exactly what I needed to track my personal finances and my art business
Thank you. Useful table, as an option it would be nice to make a distinction between bills and contingencies, plus add a separate column to the bills with their due dates, just to remember when to pay.
Ran into your video after I acquired a business half a year ago. Would be interesting to know what your spreadsheet looks like now and/or if it’s gotten refined (or if you have a bookkeeper handling everything)
my personal one is pretty similar but my business sheet is quite different now! I just had to adjust as I learnt more, I still handle it all on my own. But I haven't been doing TH-cam consistently for a while now, so not sure that I'll make a new video on it!
I’m 21 and just started my own zero based budget!! sine starting 2 months ago, i have been able to recover from a shopping addiction and lazy spendings! I will never go back!💰✨
first of all, you are so beautifullllllllll!! i love your accent and it is easy to understand and thanks for this tipss, i will definitely use it from now onn
Keep track of income and expenses is easily done by categories and sums like you showed. But the tricky part is to know your balance on each of your credit card and accounts continuously. How do you do that in excel?
I hope I will not fail to excel office work and housework. I will not fail in doing everything that I want to do. I will not fail in every career pathway that I choose. I will not die. I will not fail to excel every life struggles that each and every person is afraid of.
Hi Lina -- this template was super helpful, thank you so much for sharing! Just had a quick question on the Credit Card section. I'm trying to keep track of how much my CC spend is but also have it be included as part of my overall spending (as I will be using money from my checking account to pay off this card every month). Not really sure the best way to go about tracking for both at the same time without double counting? (Not sure if this makes sense).
Oops, I should've included that in this video! At the end of the year, I basically add some lines for "total yearly income", "total yearly net income", etc. And then I actually start a brand new excel sheet for the new year so that each year has it's own document.
I clicked to see if I can probably see amy adjustmemts my Excel expense sheet but seems like it's very similar. I haven't been doing a good job with tracking my Bank account and paid a $5 from December 2022 so I am watching this video for motivation to do better. The pandemic got me fucked up eith stay at home for 1 year made me lazy.
What an amazing tutorial and a spreadsheet. I only have one question, when it comes on putting your income sources, are you putting them on gross income or net income??? Assuming someone with a regular job and investment or side hustle, for a job it will be tax right away, in short, net income. On the other hand, making an income on investments and side hustle, such as, capital gains and dividends is I consider gross income. Also, it will only be tax on filing season. Which part of the income should I put on the spreadsheet, the gross/pre tax or the net/after taxes to make everything accurate??? Thank you and have a great day.
6 months late but how would you fill out the bank account and credit card portions? From what I grasped in the video, I think you track how much is in your account at the beginning of the month for bank accounts and for credit cards, it's how much you've accumulated within a month?
Nope at the end of the month!! Everything I do for each month is calculated at the end of the month. So I would state how much money each of those accounts has at the end. For credit cards, I'll put in whatever my statement balance was for that month - the exact number that's on my statement. Thankfully, my statements come pretty close to the end of the month, so it works out that way... but if your credit card statements come midway through the month or something and you want to reorganize yourself, I know some credit card providers will let you change the statement closing date by calling them up! :) hope that makes sense!
UPDATE: Since some of you requested it, I have now added a template of the sheet I used in the video in the description of this video. You can make your own copy and rename things according to your own finances. A bit more info in the description box. Hope it helps! Please let me know if for some reason it doesn't work, and I'll try to fix it ASAP.
I like the template! I personally use mint to track my spending, income and net worth.
Can you please grant me access to it!
@@litokoba9976 everyone has access to it with the link in the description box - All you have to do is hit "File -- Make a Copy" and you'll have your own copy to edit.
I liked and subscribed because of this , thanks
thanks for the template! I'm planning to use it as base and automate it bit more to provide margins, cashflow info along with assets, liabilities . If you want me to share this file, please do let me know, I would feel happy to help
Successful people don't become that way overnight. What most people see at a glance- wealth, a great career, purpose-is the result of hard work and hustle over time. I pray that anyone who reads this will be successful in life..
Assets that can make one successful in life
I.bitcoin
2.Stocks
3. forex
@@jamesmurphy9772 You're right
But I don't know why people remain poor due to ignorance
please I have been hearing about this Mr Aitor Lorenzo from my colleagues at work. How do I easily contact him
Your template was so helpful! I worked out my spending for the year, figured out where I should cut back on subscriptions, and set up a new blank version with a potential budget for next year. Thank you!
Yayyy!! look at you go! all ready for the new year! glad I could help :)
A massive thank you Lina! This advice and spreadsheet has definitely saved my finances for the future!! I have always been lazy with managing money because havent had the need for it. Last few years have been tough since my monthly commisson has changed drastically and I didnt react to it. Started going into debt with budgets. With my calculations I will be debt free in 7 months. Im so happy! Greetings from Finland!
this is the best one I have seen. I needed something simple and cannot find anything
Thank you for sharing this informative video on budgeting! I really appreciate the clear and concise explanations, and I feel much more confident about creating a budget for myself. Great work!
Starting to get my life together and working on savings and budgeting Is my first steps! Love the video!!
Really appreciate this. Seems pretty sustainable and straight forward to remain a consistent habit.
There’s also a ‘sum’ button in excel which you can just click, whilst the values you want to add up are highlighted. It’s a Sigma symbol in the top right.
I wish I could like this twice! been searching for a video just like this!
Thank you so much for this video!
I ve been looking for a template and a way to track my money, in a way which speaks and appeals to me, and which feels intuitive, without being too overly complicated.
Thanks a ton, this has been a great start and has helped me get going!
thank you Lina!!! I just move out from home, that's definitely a useful tool/ skill for me to study money,and live in abundance !!!
You're so welcome! glad its helpful!!
That had to be the best commercial I have seen in a loooong time. Thanks for the great work.
That watch commercial had no end
This seems so simple and useful! Thank you!
This is literally my cure for depression. Thank you so much Lina!
I came for the knowledge but stayed for the smile 👍
I love the music you chose! Your whole vibe is amazing!
I've been tracking my finances via Excel for a few years and it's so rewarding! I update my spreadsheet weekly because I like the regular check ins, especially for categories like food and entertainment. Some areas I struggled with were budgeting for the expenses that went on my credit card but then not having a schedule for when I transferred money to pay it off. Now I check my cc every 2-3 days and transfer the balance in full (versus monthly). I also have a section for my investments because I love entering the numbers and seeing it grow. I'm also in Canada!
Thanks for the tips! Just a suggestion that will make things easier for your subscribers: Sharing the template of the sheet you used in a video will be very helpful to people who enjoyed your model and want to start using your template, so they don't need to spend time going through the video to make a similar template, instead they can just download it.
Oh this is a really great idea! I didn't think of that when I was making the video. I might do that soon, thanks for the suggestion :)
@@lina.lecompte You're welcome!
@@lina.lecompte you can just import/copy the excel file into google sheets, so everyone can make a copy for themselves
@@lina.lecompte Hey Lina, have you included the template? Would be really grateful if you do
@@tealucijaivic9985 Hi! thank you for letting me know! I just did exactly what you said :) I've added it to the description box. thank you!
Truly informative!!! I loved it!!! 👌🏻
There’s an option on the top that sums them all up, average them, and more. That would be easier than doing all of that!
Thanks a bunch! I've been looking for a way to sort my money out and how lucky I am to find your video! Best of luck🥰
Thank you so much for the spreadsheet, you're the only one who linked it for free and i appreiciate it so much as a fresh graduate student who's struggling living alone. Also thanks for the financial information :)
you're so welcome!! I totally get how it can be hahaha thanks for watching :)
thank you for this!! I just graduated college and am trying to get my life together! Your spreadsheet helps a lot!
so happy to hear that!
Lol literally same.
❤❤❤thanks Lina. Lovely presentation n simplistic. Everything u do, u do it mindfully. Im working on my monthly budget now.😊Thanks!
“If you don’t budget your spending
you’ll spend your budget”
YESSS! Excel helped me a lot in tracking my finances. It's such a huge tool, which can do almost everything :)
"Would you like me to give you a formula for success? It's quite simple, really: Double your rate of failure. You are thinking of failure as the enemy of success. But it isn't at all. You can be discouraged by failure or you can learn from it, so go ahead and make mistakes. Make all you can. Because remember that's where you will find success."
-- Thomas J. Watson----
your editing is so good on this video!
ahhhhh thank youuu!
love it! thank you for sharing
I love this spreadsheet! Thank you!
1. You can set conditional formatting on the monthly expenditure cells to, for example, turn red if the amount goes over the budget.
2. You can add a column after the Budget column (make a new Column "C") to show if you are within budget for the year. For each row, enter a formula that sums the values of cells for that row (Jan to Dec) and divides by the number of cells with data (COUNTIF(B12:N12,NULL) to show how much you are over or under so far for the year. Note: It's been a few years since I used Excel so I probably don't have the best syntax but you get the idea.)
I WISH gas just cost 100$ a month. 😂 Great video!
Thanks for the work. The Daywork alouds awesome personal overviews and graphics for yourself. Make this for years ... and is going every day better and better.
Thank you for this ! I'm watching this to kick myself in the ass with my expenses!
Forget typing sum and brackets etc when wanting to add up just select the column or rows and add an empty box at the end then click auto Sum or the Greek E button and it adds it up for you and fills that number in the empty box. Bit easier.
ahhh that's way easier! wish I'd shown it that way in the video! thanks for the tip!
Thank you so much for the Google Sheets template, it has helped so much!
I generally budget in my head, and write things down; but as of recently I’ve gotten into a few different income revenue from different things. So now I feel like I need to excel or google sheets it, thank you for the tips. Also in a yr or two (kinda late, but because of life) in investing in a Roth IRA for retirement. I’m a new sub!!!!
you're right, there is a better way to do it. I was doing it like you and now it's all automated for me. If you're interested I can share my template with you.. it gives you a dashboard too. All in google sheets.. all you have to do is do the daily journal entries and everything else is automated.
I'm interested!
I am interested
Im interested
i am interested
thank you very much. This really helped in more ways than one. I've been looking for these types of videos and this is the most efficient by far, thank you
Thank you so much for your explanation and template! TH-cam recommended your video to me so it's my first time visiting your TH-cam channel! I loved your video and just downloaded your template! it's amazing and so easy for a finance noob like me!!! many thanks and you just got a new subscriber here!!! love you and will be supporting you!!! you're so awesome
Thanks for this useful content ❤
Thank you for your videos, it help me a lot especially the pattern. You are amazinggg
i like that u put OUTRO as a timestamp! its interesting. By the way, i like the innocent honesty with which you explain
I came here to see how other people do their finances, thanks for the info.
Thank you so much for sharing this. I am also a freelance actor/director in my 20s and one of the steps I’m trying to take to get my life together is to manage my personal expenses, but all systems assume a fixed income set up, which aren’t friendly for creative freelance lifestyles. This finally gave me some direction of how I can go about my own budgeting and finance tracking. Cheers and break a leg in all your acting related endeavors. 🎬
I'm so happy this was helpful to you! I totally get that, being self-employed makes things a bit more difficult in terms of keeping track of our finances but it's totally do-able! I've changed my business set up a little bit now, I think as you start tracking you'll see what changed would be good to make to your own set up until you have it all good to go
This is the only video I found that fit me PERFECTLY. I've downloaded the sheet and am using it. It's exactly what I needed to track my personal finances and my art business
Wonderful! You are very talented and you explain the topic in a friendly manner. Thanks a million
Well.... first of all, you're adorable... second, I'll design my expenses sheet based on your clear and concise explanation!!.... Love from Spain
thankyou so much for this,I saw lot of videos but this one is what Im folowing.Its so simple to undertsand😀
Thank you. Useful table, as an option it would be nice to make a distinction between bills and contingencies, plus add a separate column to the bills with their due dates, just to remember when to pay.
Excellent editing! You're extremely thorough and the sponsorship advertisement was amazing. Definitely saving for the watch. Thank you ❤
Ran into your video after I acquired a business half a year ago. Would be interesting to know what your spreadsheet looks like now and/or if it’s gotten refined (or if you have a bookkeeper handling everything)
my personal one is pretty similar but my business sheet is quite different now! I just had to adjust as I learnt more, I still handle it all on my own. But I haven't been doing TH-cam consistently for a while now, so not sure that I'll make a new video on it!
Thanks a lot now I have a clear picture of where my money goes
This really helped me see how much I am spending per month. oops! Thank you!!
I am almost 21 and dont do half the stuff you do. Keep up the good work, proud of you famm 💪🏻
I started doing this when I was 20-21, so you can definitely get on it! thanks so much!
I’m 21 and just started my own zero based budget!! sine starting 2 months ago, i have been able to recover from a shopping addiction and lazy spendings! I will never go back!💰✨
This was very helpful! Thank you for providing your sheet for free! Subscribing and liking for this :)
Thanks for sharing tips on how to track expenses. That was by far the most sorted way to do it.
you're welcome!! happy it was helpful :)
simple and elaborate. Settled on this template after searching online
Thank you. Exactly what I was looking for. 💓
Thank you so much for offering this info. It helped out a lot! :)
first of all, you are so beautifullllllllll!! i love your accent and it is easy to understand and thanks for this tipss, i will definitely use it from now onn
awee thanks so much! glad it helped!
thanks for helping me organise my life
ahh this makes me happy! thanks for watching!
"Epidemic Sound" 😄 oh gosh, irony not lost there
Ayo I been watching u for a minute now and just wanted to tell u ur killing it
thank you so so much! I really appreciate that :)
Thanks for your video! This is super helpful!
"Manifestation" category lol I like it.
Thanks, the business expenses sheet in the last is helpful :)
Thanks for this. It's helpful, I been trying to see more into tracking my money
You're so welcome!
Greetings, thank you for this video. I now have made my own trackers. Thank you
You look great. You sound great. The purpose I was here not fulfilled. But I got positive vibes from you hence subscribed.Thanks.
thank you for saving my life!
Appreciate for the simplicity !
you are a very interesting person and this video helps me a lot
Thanks dear now I found the very basics and clean excel sheets new fan here 🙂
Hi, Lina! Thanks for sharing. Plus you are so gorgeous. I love how you discuss everything and love how you speak. Hahaha *fan-girling*
Hi Lina! Thank you for sharing your insights! It was nice watching a system based on a creative career (: Wish you all the best!
Hi! thanks so much for watching! Yes, definitely a bit different from what other people might do haha, but it's what works for now!
That intro was 🧼 clean 🤩
For eating out I put in Food and Drink as a category.
Keep track of income and expenses is easily done by categories and sums like you showed. But the tricky part is to know your balance on each of your credit card and accounts continuously. How do you do that in excel?
I hope I will not fail to excel office work and housework. I will not fail in doing everything that I want to do. I will not fail in every career pathway that I choose. I will not die. I will not fail to excel every life struggles that each and every person is afraid of.
Thank you for your template!
Hi Lina -- this template was super helpful, thank you so much for sharing! Just had a quick question on the Credit Card section. I'm trying to keep track of how much my CC spend is but also have it be included as part of my overall spending (as I will be using money from my checking account to pay off this card every month). Not really sure the best way to go about tracking for both at the same time without double counting? (Not sure if this makes sense).
2:28 i was about to sub till this part ☠☠
Great template
USING THIS IN 2022
the editing is superb
What do you do after the end of a year?
Do you calculate the savings or just start over with another year?
Oops, I should've included that in this video! At the end of the year, I basically add some lines for "total yearly income", "total yearly net income", etc. And then I actually start a brand new excel sheet for the new year so that each year has it's own document.
@@lina.lecompte thank you :)
thank you so much I definitely needed it
Thank you for the template. ❤
YEAS THANK YOU that's what I was wanting to do with Excel lol I liked this video yes!!!!👍😅
This was genius! Thank you!
thanks! this was a great tutorial
I clicked to see if I can probably see amy adjustmemts my Excel expense sheet but seems like it's very similar. I haven't been doing a good job with tracking my Bank account and paid a $5 from December 2022 so I am watching this video for motivation to do better. The pandemic got me fucked up eith stay at home for 1 year made me lazy.
What an amazing tutorial and a spreadsheet. I only have one question, when it comes on putting your income sources, are you putting them on gross income or net income??? Assuming someone with a regular job and investment or side hustle, for a job it will be tax right away, in short, net income. On the other hand, making an income on investments and side hustle, such as, capital gains and dividends is I consider gross income. Also, it will only be tax on filing season. Which part of the income should I put on the spreadsheet, the gross/pre tax or the net/after taxes to make everything accurate??? Thank you and have a great day.
I legit found the pun really funny 😂😂 Thank you so much for this video and for the template too! ❤️❤️
Good video. Tip: take an excel class, =Sum() is not the answer to everything
Great information Lina, I am a bit old school so will use your template. Thank you very much for sharing. Love the watches also🤩🤩
Glad it was helpful!
Thank you very much this was a great help!
6 months late but how would you fill out the bank account and credit card portions? From what I grasped in the video, I think you track how much is in your account at the beginning of the month for bank accounts and for credit cards, it's how much you've accumulated within a month?
Nope at the end of the month!! Everything I do for each month is calculated at the end of the month. So I would state how much money each of those accounts has at the end. For credit cards, I'll put in whatever my statement balance was for that month - the exact number that's on my statement. Thankfully, my statements come pretty close to the end of the month, so it works out that way... but if your credit card statements come midway through the month or something and you want to reorganize yourself, I know some credit card providers will let you change the statement closing date by calling them up! :) hope that makes sense!