Video není dostupné.
Omlouváme se.
Add a Savings Account | Automate your Budget | Excel Budget Template | Personal Finance
Vložit
- čas přidán 13. 08. 2024
- This video is part three of my Excel Budget Template Tutorial. It will show you how to add a savings account to your Budget. After adding the savings account, anytime you add a transfer to or from your savings account, your Savings balance will update! You can also add savings goals!
*BEFORE YOU WATCH: ensure you watch the first two videos in the series…
Build Your Own Personal Budget Dashboard | Budget Spreadsheet | Personal Finance
• • Build Your Own Persona...
Excel Budget Template | Automate your budget in 15 minutes
• • Excel Budget Template ...
Other Resources:
pre-built, easy to use spreadsheets, try this link. There you can find cash flow planning, invoices, expense reports, personal budgets, and more! (THIS BUDGET IS NOT AVAILABLE)
• www.simpleshee...
Excel University:
www.simpleshee...
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
Your videos have taken my money management to a whole new level. Thank you!
Awesome. Love to hear it!!
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!
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?
I cant wait until you make Google spreadsheet. thank you for your help
Shouldn’t have to wait too long!
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
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.
Hi! Can we also please have a section for tracking investments like mutual funds, crypto, etc.? Thanks so much!😊
Now I just need a debt tracker, in Google sheets pretty please! 😆☺️🤞
That’s two videos from now!!!
Yay! 😃
Great Videos I followed the enitre series. This will help me manage my goals.
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.
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 video as always!! Can't wait to update mine!!
Love it! Thanks!
Great video! Thank you so much! Setting mine up today!
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...
You are a great teacher! Love your videos, thank you!
It's great to have you back mate
Thank you. I’ve missed it too!
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.
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?
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.
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.
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.
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.
the formula for the savings transfer gave me zero... driving me nuts trying to fix it
advice please
Thank you. That helps.
Love your work, Just wondering how I could add the savings account to the year to date tracker?
love this stuff
Great Video
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.
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
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.
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
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
Thanks!
Thank you!!
How do I move my excel spreadsheet to a share file?
You need Microsoft teamsites
How can download file?
How can download this 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
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 can download this file?
Much more rewarding to complete the task yourself
@@whyworksmarternotharder pl share file
That's not a savings account