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..
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!
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!
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 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!
"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.)
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.
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'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 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!
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).
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.
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?
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.
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.
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 RUclips consistently for a while now, so not sure that I'll make a new video on it!
oh wow I didn't know that hahaha clearly like I said in the video my knowledge of excel isn't the best! I still have so much to learn, thank you for telling me :)
Thank you so much for your explanation and template! RUclips recommended your video to me so it's my first time visiting your RUclips 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
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!!!!
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.
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!💰✨
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!
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 :)
Looking for a laptop, as a finance major and need one more year until graduation and land a job. Looking at this lenovo x1 carbon and mac pro mostly bc of the battery and software. I am aware of the Excel shortcut, and Bootcamp.. Is it doable, or what do you recommend?
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
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 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
@@asifbarlaskar1159 Foo stands for "Financial Order of Operations". It can be broken down into the following 9 steps: 1 - Deductibles Covered 2 - Employer Match 3 - High-Interest Debt 4 - Emergency Reserves 5 - Roth IRA and HSA Contributions 6 - Max-Out Retirement Options 7 - Hyper-Accumulation 8 - Prepaid Future Expenses 9 - Low-Interest Debt Pre-payment Here's a RUclips vid explaining it in more detail. ruclips.net/video/v0lOBmTnxhE/видео.html
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
Hi! This is such a helpful video. I do have a question though, for the income monthly budget, how are those number's determined? I'm sorry very new to budgeting and not the best at math😭
for the budget section - that would be your predicted income! you just make an estimate based on what you're used to earning/what you expect. And then for each month you actually input what you end up earning :)
I probably won't be doing that honestly!! But you can definitely follow along with the video, copy exactly what I did, and you'll get the same spreadsheet setup :)
@@lina.lecompte if you copy the total cell at the end of the month you can paste it to the next month. The summed cells should change to the current month.
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
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!
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 :)
this is the best one I have seen. I needed something simple and cannot find anything
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 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!
I wish I could like this twice! been searching for a video just like this!
"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.)
Starting to get my life together and working on savings and budgeting Is my first steps! Love the video!!
That had to be the best commercial I have seen in a loooong time. Thanks for the great work.
Really appreciate this. Seems pretty sustainable and straight forward to remain a consistent habit.
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!
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!
Can you share this template please?
I am interested
Im interested
i am interested
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!
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!!
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 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.
I love the music you chose! Your whole vibe is amazing!
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).
your editing is so good on this video!
ahhhhh thank youuu!
love it! thank you for sharing
Truly informative!!! I loved it!!! 👌🏻
This seems so simple and useful! Thank you!
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🥰
That watch commercial had no end
😂
Thanks for this useful content ❤
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.
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?
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 so much for the Google Sheets template, it has helped so much!
Thank you for your videos, it help me a lot especially the pattern. You are amazinggg
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 :)
YESSS! Excel helped me a lot in tracking my finances. It's such a huge tool, which can do almost everything :)
Thank you for this ! I'm watching this to kick myself in the ass with my expenses!
I came for the knowledge but stayed for the smile 👍
“If you don’t budget your spending
you’ll spend your budget”
❤❤❤thanks Lina. Lovely presentation n simplistic. Everything u do, u do it mindfully. Im working on my monthly budget now.😊Thanks!
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 RUclips consistently for a while now, so not sure that I'll make a new video on 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!
oh wow I didn't know that hahaha clearly like I said in the video my knowledge of excel isn't the best! I still have so much to learn, thank you for telling me :)
@@lina.lecompte no problem! I hope it helped you 🦋
I came here to see how other people do their finances, thanks for the info.
Thank you so much for your explanation and template! RUclips recommended your video to me so it's my first time visiting your RUclips 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
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!!!!
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.
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!💰✨
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!
i like that u put OUTRO as a timestamp! its interesting. By the way, i like the innocent honesty with which you explain
the editing is superb
Thanks for your video! This is super helpful!
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 :)
After I became a personal finance content creator I was very into budget and saving because I realized that only 25% of people save your money
Well.... first of all, you're adorable... second, I'll design my expenses sheet based on your clear and concise explanation!!.... Love from Spain
This is literally my cure for depression. Thank you so much Lina!
I WISH gas just cost 100$ a month. 😂 Great video!
This was very helpful! Thank you for providing your sheet for free! Subscribing and liking for this :)
That intro was 🧼 clean 🤩
thankyou so much for this,I saw lot of videos but this one is what Im folowing.Its so simple to undertsand😀
Thank you so much for offering this info. It helped out a lot! :)
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 :)
simple and elaborate. Settled on this template after searching online
Looking for a laptop, as a finance major and need one more year until graduation and land a job. Looking at this lenovo x1 carbon and mac pro mostly bc of the battery and software. I am aware of the Excel shortcut, and Bootcamp.. Is it doable, or what do you recommend?
Thank you. Exactly what I was looking for. 💓
Do Nordgreen watches come in diamonds as in diamond watches with diamond watchbands?
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!
Wonderful! You are very talented and you explain the topic in a friendly manner. Thanks a million
Greetings, thank you for this video. I now have made my own trackers. Thank you
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 :)
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.
thanks! this was a great tutorial
thanks for helping me organise my life
ahh this makes me happy! thanks for watching!
Good video. Tip: take an excel class, =Sum() is not the answer to everything
thank you for saving my life!
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 🙂
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
Be sure to follow the FOO in your budget to ensure that you do everything in the right order.
what is the FOO?
@@asifbarlaskar1159 Foo stands for "Financial Order of Operations".
It can be broken down into the following 9 steps:
1 - Deductibles Covered
2 - Employer Match
3 - High-Interest Debt
4 - Emergency Reserves
5 - Roth IRA and HSA Contributions
6 - Max-Out Retirement Options
7 - Hyper-Accumulation
8 - Prepaid Future Expenses
9 - Low-Interest Debt Pre-payment
Here's a RUclips vid explaining it in more detail.
ruclips.net/video/v0lOBmTnxhE/видео.html
Thanks for this. It's helpful, I been trying to see more into tracking my money
You're so welcome!
Thanks, the business expenses sheet in the last is helpful :)
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
what is the use of (purpose) monthly budget in income section?
Is there anyway of importing your credit card details into excel directly and sorting them into the different categories?
thank you so much I definitely needed it
For eating out I put in Food and Drink as a category.
You look great. You sound great. The purpose I was here not fulfilled. But I got positive vibes from you hence subscribed.Thanks.
How much did you get paid for Monster High 2?
Hi, Lina! Thanks for sharing. Plus you are so gorgeous. I love how you discuss everything and love how you speak. Hahaha *fan-girling*
If you have a RUclips channel, do you have to have a certain amount of subscribers to get paid? Or does it not matter?
Hi! Yes, you need to have 1,000 subscribers and 4,000 valid public watch hours in the last 12 months :)
Not sure of you mentioned bills. not many channels mention internet bill. Good info 👍🏻
Hi! This is such a helpful video. I do have a question though, for the income monthly budget, how are those number's determined? I'm sorry very new to budgeting and not the best at math😭
Is it your income of that month or like predicted income?
for the budget section - that would be your predicted income! you just make an estimate based on what you're used to earning/what you expect. And then for each month you actually input what you end up earning :)
@@lina.lecompte omg thank you that makes sense! :))
This was genius! Thank you!
Can we get a copy of your spreadsheet setup , Or maybe a video on how to create a income and expense sheet on excel !🙏🏻
I probably won't be doing that honestly!! But you can definitely follow along with the video, copy exactly what I did, and you'll get the same spreadsheet setup :)
@@lina.lecompte if you copy the total cell at the end of the month you can paste it to the next month. The summed cells should change to the current month.
Is this about managing finances or a commercial for watches?
You can easily skip the ad! Like I said in the video, sponsorships are part of my income, I have bills to pay too :)
awesome, thank you so much for sharing with us that useful tool.
Thanks a lot now I have a clear picture of where my money goes
This was so helpful!!!!
Thank you for the template. ❤
Thank you, Lina!
Excellent editing! You're extremely thorough and the sponsorship advertisement was amazing. Definitely saving for the watch. Thank you ❤