I just got into learning how to budget and trying to figure out formulas i have never been good at math my whole life but after all the videos i have watched on trying to learn all this confusing stuff with being able to pause yours and the way you are teaching them i am finally understanding it finally got a budget created custom style for myself which is automated now all thanks to you.
Am I the only one who is excited for the Google one to come out ? I find his video a few days ago and I make by budget follow exactly how he showed us and I am loving it...now I can control my $ and loving it
Love your budgeting sheets. On the Savings sheet is there any way to show a negative amount after you go below you initial starting balance. Would love to see it in red with quotes around it. Thanks for all the lesons...
Tip the formula's are different for newer dutch version of exel it's =SOM.ALS(Tabel1[categorie];"transfer to savings";Tabel1[income]) =SOM.ALS(Tabel1[categorie];"transfer to checking";Tabel1[income] hope this helps
I came to scroll through the comments to ask this exact question! I usually will charge my credit card for most, if not all, of my expenses, and I'll use the checking acct to pay off the card. But doing that doesn't exactly work with the checking and savings templates he has on here.
My budget is exactly this except I didn't know how to do the fine details with formulas and the automatic cell transfers. Thanks this will be so helpful. Expect my Savings Account spreadsheet is broken-down into categories. Do you have a video that would show how to make the transfer to saving go to specific categories? Example being a $1000 in saving but it's split up into smaller categories?
Love your content. I am working on my finances, and this really helps me to organize. I do have a question. How do I incorporate overdraft frees from my savings account?
hi this is great and good. if it's possible can you share if there's an adjustment to the actual budget how to display the changes for 6months and display the actual vs adjusted budget with actual spent , for my case is every six month need to adjust the budget thanks.
Your videos was just what i needed. But can you tell if I want have two or more than two bank accounts managed individually which i would enter in the log but should be reflected individually. As it seems daye , month, year is required which is already present. Now we just need multiple bank accounts. Thanks in advance.
Hey, I appreciate you sharing your knowledge with us here. It has helped me so much, because I've been wanting to track my finances for a very long time and you helped me. Is there a way we can insert monthly deductions?
So, I save my money in cash & have a separate sheet under " cash savings" with the financial categories in E, F & G under Cash withdrawn, Cash Spent & Cash savings. This made sense to me as cash in my mind is separate to online banking but I'm racking my brains trying to figure out how to seamlessly merge this information into the main log.
Looks like a great start. But 2 questions: - Why only limit it to categories & not use sub-categories - Why not use a pivot table instead of the sumifs?
hi, looks like he does not reply to comments anymore and you seem like a smart guy. I have a question. In one of his previous videos he showed how to add a month column to the log sheet by using the =month() function to get the month value from the date column. but how do I do the same with the year column? the function =year() seeems to be different from =month(). Do you know how to do it?
@@extrawagant Just saw the comment (too many notifications man). Same thing - get a pivot table & filter by year. I do everything like that. I sort by categories & sub-categories on the rows, then put the year & month on the columns (but for me it's part of the same date/day that excel breaks down into 4 things: year, quarter, month & day). Then, of course, you put the value into the values section of the pivot (credit/debit doesn't matter as long as all your debit is positive & you convert all your credit into negatives. This you can do by just multiplying a filtered list of credits by -1 (if you copy paste a cell that has -1 & then special paste it)). PS Apologies for the many brackets, but I hope this helps :D
What would you recommend I do if I transfer money from my checking into my savings account, every check, but then transfer back from savings to checking when it's time to spend the money.
Could you maybe do a stock portfolio ledger connected to the personal budget document as well? (I tried it personally but did not work very well) I added a extra page in the document and had set up an name for that table. Tried to connect it to the Log, but from there I coudn'd connect it to my dashboard. It was a mess in the end. Maybe more people who are interested in that?
First let me say thank you for doing this … how do you add a line graph show to the dashboard to measure a savings goal … ie a saving account goal of 10k … can you make it show the projected date you will hit the goal based on the balance currently in the account?
This is a really awesome spreadsheet. Is it possible to also add credit cards tracking to it? Also, sometimes my purchases need to be split between two or more different categories. Is there a way to incorporate this into the spreadsheet?
I'm not sure this really does it for me. How do I deal with different "entries" in my Savings account, such as service charges, interest payments, and any other withdrawals or deposits?
Greetings from "down Under , I am 86 years of age, I think I may have been trying to set a budget for perhaps 80 of them !?, I have built your "Build your own Personal Budget" in Excel, and I think you may have saved me from insanity and perhaps given me another 14 years??. I have also built in the savings account, brilliant thank you, thank you. Query, if I pay a bill from savings, how can I record that or must I transfer back to Checking Account, Thank you again Cheers Phill
@@whyworksmarternotharder for my job I have end of month reports, I have to fill out one form then transfer all that to another income statement, which breaks down income and expenses, what I want to do is create a ledger where I can put all my expenses for the year, month to month, but would sum up all fuel purchases buy month then puts in in the appropriate spot on the yearly income statement, instead of having 5 different sheets for each expenses that I’ll do a total monthly and in the statement use the = formula. If that makes since. I tried to use your budget video to do that but still not what I need. If that makes any since. I’ll be happy to send you the sheets if you would like a better visual. How can I private message you my email
Suppose Multi pal Saving accounts ,Credit Card ,Google Pay,Payzapp etc, how to add it Add Subcategory Add Log Column Types means Income,Expense,transfer
Really like the simplicity of it all. I still need to watch it a dozen times to make a little imprint in my brain plus I save the video. Thanks!
This makes it look soooo easy but i still need to watch it really really slowly as i am coming into this quite late in life. thanks alot
I hear you I am 80 but found his instructions pretty easy to follow. Hang in there and take it one step at a time.
I just got into learning how to budget and trying to figure out formulas i have never been good at math my whole life but after all the videos i have watched on trying to learn all this confusing stuff with being able to pause yours and the way you are teaching them i am finally understanding it finally got a budget created custom style for myself which is automated now all thanks to you.
Awesome! Glad it’s working for you!
Your videos have taken my money management to a whole new level. Thank you!
Awesome. Love to hear it!!
Hi! Can we also please have a section for tracking investments like mutual funds, crypto, etc.? Thanks so much!😊
Great tutorial vid. Thank you so much! I've been working on basic excel on my own during my free time and I did it bcoz of you.
I cant wait until you make Google spreadsheet. thank you for your help
Shouldn’t have to wait too long!
It's great to have you back mate
Thank you. I’ve missed it too!
Am I the only one who is excited for the Google one to come out ? I find his video a few days ago and I make by budget follow exactly how he showed us and I am loving it...now I can control my $ and loving it
Coming hopefully today!!
@@whyworksmarternotharder soon?
Yeah this man seriously changed my life with the budget + dashboard
Great Videos I followed the enitre series. This will help me manage my goals.
Love your budgeting sheets. On the Savings sheet is there any way to show a negative amount after you go below you initial starting balance. Would love to see it in red with quotes around it. Thanks for all the lesons...
Great video! Thank you so much! Setting mine up today!
Tip the formula's are different for newer dutch version of exel it's
=SOM.ALS(Tabel1[categorie];"transfer to savings";Tabel1[income])
=SOM.ALS(Tabel1[categorie];"transfer to checking";Tabel1[income]
hope this helps
You are a great teacher! Love your videos, thank you!
Now I just need a debt tracker, in Google sheets pretty please! 😆☺️🤞
That’s two videos from now!!!
Yay! 😃
Great videos so far. My Excel Budget file is getting better. Thank you so much. Can we please have a Credit Card monitoring template too?
Coming soon!!
I came to scroll through the comments to ask this exact question! I usually will charge my credit card for most, if not all, of my expenses, and I'll use the checking acct to pay off the card. But doing that doesn't exactly work with the checking and savings templates he has on here.
Great video as always!! Can't wait to update mine!!
Love it! Thanks!
Love your work, Just wondering how I could add the savings account to the year to date tracker?
My budget is exactly this except I didn't know how to do the fine details with formulas and the automatic cell transfers. Thanks this will be so helpful. Expect my Savings Account spreadsheet is broken-down into categories. Do you have a video that would show how to make the transfer to saving go to specific categories? Example being a $1000 in saving but it's split up into smaller categories?
Your videos have been vary helpful could you make one adding in stock investments or how to add charts and graphs please. Thank you for these.
Love your content. I am working on my finances, and this really helps me to organize. I do have a question. How do I incorporate overdraft frees from my savings account?
hi this is great and good. if it's possible can you share if there's an adjustment to the actual budget how to display the changes for 6months and display the actual vs adjusted budget with actual spent , for my case is every six month need to adjust the budget thanks.
Your videos was just what i needed. But can you tell if I want have two or more than two bank accounts managed individually which i would enter in the log but should be reflected individually. As it seems daye , month, year is required which is already present. Now we just need multiple bank accounts. Thanks in advance.
Hey, I appreciate you sharing your knowledge with us here. It has helped me so much, because I've been wanting to track my finances for a very long time and you helped me.
Is there a way we can insert monthly deductions?
Yes. I would add that into the fixed expense page.
Thank you. That helps.
love this stuff
So, I save my money in cash & have a separate sheet under " cash savings" with the financial categories in E, F & G under Cash withdrawn, Cash Spent & Cash savings. This made sense to me as cash in my mind is separate to online banking but I'm racking my brains trying to figure out how to seamlessly merge this information into the main log.
Great Video
Looks like a great start. But 2 questions:
- Why only limit it to categories & not use sub-categories
- Why not use a pivot table instead of the sumifs?
hi, looks like he does not reply to comments anymore and you seem like a smart guy. I have a question. In one of his previous videos he showed how to add a month column to the log sheet by using the =month() function to get the month value from the date column. but how do I do the same with the year column? the function =year() seeems to be different from =month(). Do you know how to do it?
@@extrawagant Just saw the comment (too many notifications man).
Same thing - get a pivot table & filter by year. I do everything like that. I sort by categories & sub-categories on the rows, then put the year & month on the columns (but for me it's part of the same date/day that excel breaks down into 4 things: year, quarter, month & day). Then, of course, you put the value into the values section of the pivot (credit/debit doesn't matter as long as all your debit is positive & you convert all your credit into negatives. This you can do by just multiplying a filtered list of credits by -1 (if you copy paste a cell that has -1 & then special paste it)).
PS Apologies for the many brackets, but I hope this helps :D
What would you recommend I do if I transfer money from my checking into my savings account, every check, but then transfer back from savings to checking when it's time to spend the money.
the formula for the savings transfer gave me zero... driving me nuts trying to fix it
advice please
Could you maybe do a stock portfolio ledger connected to the personal budget document as well?
(I tried it personally but did not work very well) I added a extra page in the document and had set up an name for that table. Tried to connect it to the Log, but from there I coudn'd connect it to my dashboard. It was a mess in the end.
Maybe more people who are interested in that?
More to come. The plan is to do a 2022 budget series
First let me say thank you for doing this … how do you add a line graph show to the dashboard to measure a savings goal … ie a saving account goal of 10k … can you make it show the projected date you will hit the goal based on the balance currently in the account?
hi, did you ever figure out how to do this? i would like to know as well
This is a really awesome spreadsheet. Is it possible to also add credit cards tracking to it? Also, sometimes my purchases need to be split between two or more different categories. Is there a way to incorporate this into the spreadsheet?
Credit cards will be coming for sure. The only way to split expenses between categories would be to make two expenses
Thanks!
Thank you!!
I'm not sure this really does it for me. How do I deal with different "entries" in my Savings account, such as service charges, interest payments, and any other withdrawals or deposits?
Greetings from "down Under ,
I am 86 years of age, I think I may have been trying to set a budget for perhaps 80 of them !?, I have built your "Build your own Personal Budget" in
Excel, and I think you may have saved me from insanity and perhaps given me another 14 years??. I have also built in the savings account, brilliant thank you, thank you.
Query, if I pay a bill from savings, how can I record that or must I transfer back to Checking Account, Thank you again Cheers Phill
Using this format, you would have to transfer it back to checking. PS sorry for the delay in response.
I need to auto-transfer bank/visa statements directly into budget sheet without having to enter transactions manually. Can this be done? thks
It can be. Very hard to make a template for everyone though because all banks have statements in different formats.
How can download this file
I wish I could hire you to help me with a project I’m working on
What do you have going on?
@@whyworksmarternotharder for my job I have end of month reports, I have to fill out one form then transfer all that to another income statement, which breaks down income and expenses, what I want to do is create a ledger where I can put all my expenses for the year, month to month, but would sum up all fuel purchases buy month then puts in in the appropriate spot on the yearly income statement, instead of having 5 different sheets for each expenses that I’ll do a total monthly and in the statement use the = formula. If that makes since. I tried to use your budget video to do that but still not what I need. If that makes any since. I’ll be happy to send you the sheets if you would like a better visual. How can I private message you my email
How do I move my excel spreadsheet to a share file?
You need Microsoft teamsites
How can download file?
How can download this file?
Much more rewarding to complete the task yourself
@@whyworksmarternotharder pl share file
Suppose Multi pal Saving accounts ,Credit Card ,Google Pay,Payzapp etc, how to add it
Add Subcategory
Add Log Column Types means Income,Expense,transfer
That's not a savings account