Household Budget Template and Tutorial (Excel)
HTML-код
- Опубликовано: 21 авг 2024
- UPDATE! :) I'm excited to announce that the third and newest version of this workbook is now available!
Follow this link to see the new video: • Household Budget Templ...
Follow this link to download it: georgemhayward...
---------------------------------------------------------------------------------------------------------------------------------------------------------------
This is a tutorial describing how to use a household budgeting workbook. To download the free Excel template (this is now the older version) and/or a blank version of it for your personal use, follow the link: www.dropbox.co...
For ease of viewing or review, feel free to jump to the discussion of any particular sheet:
Summary: 0:29
Income: 3:15
Expenses: 4:40
Bank Balances: 7:11
Budget: 8:09
Pie Income: 11:12
Bar Income: 11:58
Pie Expenses: 12:15
Bar Expenses: 12:45
Income | Expenses: 12:56
Categories: 15:08
Balances: 17:20
Lists: 18:24
FAQ: 19:10
Here is my previous budget video for reference: • Household Budget and F...
This is a versatile home and personal finance template with interactive components to help with tracking and managing your finances over time. It provides daily, monthly, and yearly data and can be used by individuals or households.
If you find this workbook to be helpful, please consider keeping George fueled with a cup of coffee or small donation :)
www.paypal.me/...
venmo.com/ (@georgemhayward)
Thank you to everyone who provided feedback on the earlier version of this workbook! All of your suggestions were taken very seriously and I trust that this workbook has improved greatly because of your thoughtful comments and questions!
After watching many videos, this was the best of them all. In essence, it is simple to understand, functional, and more than just a budgeting template, but rather gives you an entire overview of your financial health. I've added other areas of finance to it like tracking expense categories based on your budget, tracking loans between family and friends, debt balances like credit cards, CDs, etc. It took a while but in the process I sharpened my excel skills (which I think should be part of high school curriculum if it isn't) and am very very pleased with having this template as a starting point. Thanks, George!
Hi everyone! Thank you for all the comments, feedback, and support on this workbook. I'm working on some updates and planning (hoping) to post them before January 2020!
Hello George
I'm Bolivian, I've been using this spreadsheet for 1 year now and I cant stress enough how grateful I am for people like you.
You have changed the lives of many people here in Bolivia, just so you know, all the friends and family I introduced your spreadsheet and taught them to use it know can't live without it. I have translated several parts of your spreadsheet to Spanish.
Maybe one suggestion for your next version, it'd be very useful to include a TAB or option to keep track of savings and investments.
Saludos desde Bolivia!
@@gonzalosossa7437 Hi Gonzalo! Thank you for your comment and kind words :) I'm so glad to hear that this has been useful to you, your friends, and your family. Thanks for passing that message along! I appreciate your suggestion as well. Coincidentally, that's part of the plan :) The other big part of the plan has to do with projections of savings into the future. If you think of any other suggestions over the next few months, please do let me know and I'll try to add them.
@@georgemhayward Thank you George! a version in Spanish would save me a lot of time haha! I could translate it for you as a thank you gesture for sharing your tool with us.
Im looking forward to the new changes. God bless you my friend.
@@gonzalosossa7437 Hi Gonzalo! I wish I knew Spanish well enough to translate it! If you want to translate it, you are definitely welcome to! That would be very kind of you. No one has specifically asked for a Spanish version, though I'm sure it would get a lot of usage. If this is something you want to do, I'd be happy to post it alongside my other one. Hopefully I'll have an updated version by 2020, though I'll still keep the old version up in case people like it better. Hope you are doing well! :)
@@georgemhayward Hey again George! this is something I'd definitely love to do and Spanish speaking people will find this very beneficial to them. Please send me an email when you have the chance: gonzalo.tabh@gmail.com so we can discuss this matter further. This is a great tool you have created and deserves to be seen by more people.
Again I will be doing this for free!
Blessings and have a nice weekend
I don't know what else to say that wasn't said in 388 comments... I'm Beyond impressed! Thank you!
This is exactly what I've been looking for. Thought I'd have to make something myself but this looks much nicer and more detailed than what I could do. Great work!
Thank you, Devon! :)
As a broke ass fella straight out of college, with massive debt, this will help me immensely. thank you very much. If I had money to donate, i would... if...
I appreciate the thought! Hopefully this will help you get on the right track! :)
It was like as if I was about to fall into an abyss of deathly pains. Then your reply was a song from nature! Your tender, virtuous voice reached back in time and made a new pump. Balance was restored, I leap over my awful troubles and received a rewarding drink of a unique nature. Because I was aware of this gorgeous feat of practical sense was available, yet my search was vain, filled with doubt driven by living extra stress. But again you, a stranger amongst billions enter a work of nature like a still lake reflecting a beautiful sky. Like if an old fashion book and record player had a baby, and you painted a picture of that great and revered baby, your picture would look like your excel dox. Thanks for being there for me. Saving me from falling in. LOL thanks I wanted this like I was a friendly dog respectfully searching for my master because when I found this excel doc it was like that dog got unconditional love back. Thanks from most top management internal division.
Haha, Kaj, you should be a poet! Thanks for the kind words :)
Hello George. I spent most my Christmas holidays in creating a similar work sheet that actually works for me. I tried all the ready software out there and realized they are too general to fit my needs. I learned a few very nice things from your work book which now I have to figure out how you did them !!! Very nice job and thoughtful of you in sharing with everyone . Well done...
Hi! Thanks so much for the kind words. Good luck! I hope it will be useful to you.
Downloaded this some time ago. It is now time to use it. You provide a valuable service in making this tutorial available. Happy Holidays and thank you. Mike
wow I thought I would never find a budgeting workbook that I liked, this is perfect thanks for sharing and explaining it too!
Thanks Brett! Happy to help :)
This is what I have needed and looked for to help me keep a visual of what's really going on! Thanks! This is very thorough...love it!
I did not want to make one on my own... you've pretty much done it all for me right here!
I prefer using monthly bottom-line expenses and percentages per each budget account based on that bottom line.
In this, the more I make, the more I am able to save per account.
Example:
I make about 622.50 a week, which comes out to about 2,645.50 monthly.
My monthly bottom line for expenses is 2,200. This means the monthly amount for each account that is pre-established, including expected mandatory bills such as rent and utilities and insurance, need not be completely re-calculated each payday, and each account saves more each payday than the bottom line so long as the bottom line is less than the actual monthly amount earned.
Let's say I have the following:
Rent - $450 per month as my monthly bottom line. (5 people, 1 rental house, $1350 monthly; I pay extra for my sister, niece, and brother-in-law)
My total bottom line is $2,200
The percentage would be calculated as 450 / 2200 = 20.45%
Dave Ramsey suggestions a rent/mortgage between 25% and 33%, about 1/4 to 1/3 of your income. You can see I easily beat this.
I stated I make about 2,645.50 monthly.
2645.50 x 20.45% = 541.00, which is $91 more each month saved for rent.
Now, extrapolate that across the entire budget and you have your 3-6 months savings (Dave Ramsey's Baby Step 3; though, I advocate for 12-months savings specifically for sinking accounts and earning interest in Money Market accounts on expenses saved) already being saved while you are simply running your standard budget.
Little bit of work on the front-end, maximum payout on the back-end.
Lastly, I recommend financial study in these areas if you are just starting out, Budgeting 101, Double-Entry Accounting 101, Data Analysis 101, and Financial Strategy 101.
These four basics make a financial cycle: Budget > DE Accounting > Data Analysis > Financial Strategy > Budgeting.
As a result, Quality Assurance is built into this financial process to improve itself simply by using it as intended.
Hope this inspires some great ideas. I believe you will all do well.
Could you do a tutorial of how to create this workbook? You've definitely use some functions I never even knew existed. I would like to get an understanding of some of these functions.
Thank you so much for sharing, my household just changed from 1 to 4. I've been looking for something simple but detailed enough to help manage our household budget.
No problem, and good luck! I hope it will be useful to you! :)
Wow! Thank you for making this free. I’m really struggling to budget my expenses so I’m taking a leap of faith to see if this will work
No problem, and good luck! :)
Thank you so much! I can't wait to get started! This is going to be so helpful. You have put a lot of time and effort and obvious talent into this. Please know it's greatly appreciated!
Hi Chris! Thanks so much for the kind words! Those are equally as appreciated :) Good luck with the workbook and let me know if you have any questions down the road!
Man, this is seriously impressive! Thank you so much! I have been looking for something like this for months. Thank you! Keep it going.
Thank you, Martino! I really appreciate the kind words :) Also, thanks for the donation! Good luck as you begin to use it, and please let me know if any questions pop up.
George hi, I have ben using your budget workbook (which, again, is wonderful!) and I had a question. Can you adapt it for a 9-month stipend cycle? How would I do that?
George "HEATWAVE" Hayward, changing the world for the better!!! :D Incredible, super spectacular job!!!!!!!
Thanks my man E!
What can i say, George, giving this spreadsheet away is so kind of you!
thank you very much!!!
No problem! Glad you like it :)
Very nice excel sheet. Started entering my information on the sheet.
What i like about the spreadsheet is that i can put it on my usb and use it /update it on my tablet, work pc, or note 8 .
Awesome! Glad you like it, Cynthia! Thanks for leaving a comment, and good luck! :)
Fantastic resource. Thanks for all you do.
Very impressive! The one thing that I have in my workbook that is missing is net worth, along with assets and debt.
Thank you for this template. It’s just what I needed. I couldn’t do it on my own. Thank you!
don't u just love the internet, thanks so much G. Hayward!
No problem! Thanks for reaching out and for the kind words! :)
Got it! Thanks for this excellent excel layout. Looks like you've got some good CPA...CFO..chops. Keep up the great work.... Go for it. Appreciate your help.
Thanks so much! :)
I am trying to learn how to use excel and this workbook template is pretty much what I need for my purposes!!! Thank you for creating and sharing :)
No problem! Good luck! :)
Thanks for sharing. I will use it next year.
Wow. Exactly what I have been looking for... You rock man. Thank you!!
Thank you, Kya! And thanks for your gift! It means a lot :) Best of luck with the template! Let me know if any questions pop up.
Thanks so much for an awesome worksheet and perfect presentation.
No problem! Thanks for the kind words :)
I deeply appreciate your template. I have been using it for about a year. Thank you.
Hi Rick! That's so encouraging to hear! I'm so glad you like it. Hopefully I will have another update coming this summer or so. I have some backlogged ideas for improvements but have been tied up with graduate school. If you have thought of any ideas for improvement, please let me know! :)
@@georgemhayward Looking forward to your updates!
Wish this workbook had a sheet, in which you could define any of your accounts in different banks like bank1 account, bank2 account and etc. and you could define how much money you have in each one of them in the beginning and as you spend from each account or your income is received in each account, that sheet would show you the balance of that account and in the end calculate your cumulative capital! and also you could get a capital growth/loss report for each month!
Hi Afshin, thanks for your comment! The Bank Balance sheet does allow you to do something similar, though I'm happy to say that I've also improved this sheet for the next version (posted in next week or two, hopefully). The new version allows you to track any kind of monthly balance and is also shown on the summary tab for quick glance statistics. There will also be a projections tab that allows people to forecast future balances. Keep your eye out for that! Hope you like the workbook.
So so so professional! Thanks for such great video and all the time you invested!
Thanks so much for the kind words! (And sorry for the very slow response!)
Hi George, just started using this and so far I love it, thanks so much, what a great job!
Thanks so much! Glad you like it :)
This is fantastic! Thank you so much for this resource.
Fantastic presentation. Excellent workbook. Thanks!
Thanks for the kind words, Bill :) So glad you like it!
Thank you so much. I will start using this Excel Sample in January. I know will be super helpful. I will let you know after using it for 6 month how it works for me.
Hi Daniel! Thanks for reaching out. I will hopefully be posting the new version of the workbook this week, so if you're going to start in January, I'd suggesting use that one instead of this one! I see that you subscribed, so you should get the notification when I post it. Good luck!
Fantastic. Very sincere work 👌👍. Much appreciate sharing it with others
Thank you so much! :) There is also a newer version of this workbook available if you are interested - linked in the description!
this template is amazing and have everything i need except there is no credit card payment/debt. it will be more helpful included debt/loan payment. then it prefect.
Hi! Thanks so much for posting this. Really helps with giving me an idea with what I'm doing with my money. Would just like to ask, how can I make a new page with the pie/bar charts to show me my monthly expense rather than cumulative? Not too familiar with Excel yet. Thanks again!
Just what I have been looking for, I'm looking forward to start using it!! Thank you!
No problem! Good luck! :)
Also, I forgot to mention this but there is a newer version available if you would rather try that. See description!
This is an awesome template!! Thank you so much for putting this together. Great tutorial. I'm a little confused about how to do Data Validation as it talks about it in the list tab.
Hi! Thanks for your kind note :) What specifically are you trying to do on the Lists tab?
Wow! Thank you so much for providing and explaining this!!! You rock!
No problem! Thanks for the kind words :)
Hey George, Thanks for this amazing work you have done,
just hope you could make a video and teach how to create a workbook like this from blank!
That would be so much educative:)
Hi Afshin, thanks for the suggestion! I might do that in the future, but it would take a while! Would need to think about how to do that. For the next version (hopefully coming in a few weeks), I do hope to have a series of videos showing how it works. Hope you enjoy the workbook!
@@georgemhayward Thank you so much sir!
George, love the template! It's exactly what I was looking for. I have one question - In the "Expenses" tab, is there a way for me to see the sum of expenses only for the current month as opposed to all expenses recorded to date?
This is very good and will be very useful for me. Thank you so much for sharing.
No problem! Thanks for the kind words, glad you like it! :)
You are the best. Thank you for sharing this template. God bless you.
No problem! Glad you like it :)
thanks for taking the time and effort! this is exactly what i needed!
No problem! Good luck! :)
Mr. Howard ... I love your Excel sheet. THe problem I have with it is (1) when I go to walmart i have multiple categories (how do I log this?), (2) I have 2 checking accounts and 2 savings accounts (how do I log these?). Looking forward to responses. :-)
Hi John! Sorry for the slow reply. When I go to places like Walmart, I just manually categorize items and enter them as separate expenses. Of course, if you do that, just make sure the separate expenses all add up to the correct total on the receipt. For your accounts, it's fine to keep them separate. That's what I do as well. Just record the balances for each account individually. Does that help?
Thank you very much your video was the most easy to understand for me and all the writing on it telling you what to do was extremely helpful. I will let you know how it goes for me as I've been fighting to make a budget of my own that works out but haven't been able to make one I like. So I decided to check on RUclips to see if someone did one I like that I can use properly. Thanks again
Hi Sky! No problem! Glad you like it :) Let me know if any questions pop up as you begin to use it.
I had some but so far I've managed to answer them myself. Oh if I put the data in for the next month will it show up on the income verses expenses ? So far I put in expenses and income for June and July but only June's is showing up on the income verses expenses chart.
Hi Sky, that might be because cell A3 is set to "Last 12 months", which will always stop at the current month. Try changing that cell to "Financial Year" and selecting 2018. Does that fix it?
I have it set to "Financial Year" and selected 2018 but it still wont show beyond June. Could it be because I've set it to go from June to May in that part ? I would like to see my upcoming months if that is possible so that I can see how its going to go with certain changes. I love having my entire budget in one thing rather then page after page that I was doing myself.
Hmm, I would try adjusting the financial year on the summary tab. Then, on the income and expenses tab, look at cell E2-E3. It will say "Your Range will Cover" and then will tell you the range. If you try a few different options between Financial Year" and "Last 12 Months" (Cell A3), and a few different options for the financial year on the Summary tab, I think you should be able to get the range you want. Let me know if that still doesn't work though, we'll figure it out!
Great template George! Definitely the best I've seen. Do you have any templates that also track things like paying off credit cards, savings funds (emergency fund, new house downpayment fund) and other "funds" like car and home maintenance where you set aside a certain amount each month and use as needed?
Hi Danielle! Thanks :) I don't currently have other templates for the things you mentioned, unfortunately. However, you could always add sheets to the end of this workbook and keep track of those things there. For example, if I wanted to do those things, I would probably make a separate sheet for debt payments and then another sheet for savings funds. On the debt payments sheet, you could have a simple table with a column for date, account (e.g., credit card #1), and payment. Something similar would work for emergency funds. Another person once asked a question similar to yours, so maybe I'll add these features in the future. I've made a note of it and will see if I get similar requests! Let me know if you come up with any ideas that could work.
Ok, thank you! Will do! Can you direct me to a video that would show me how to get data from one worksheet that updates in another...the same way yours update to your summary? Ive been trying to figure it out for awhile and haven't found the right tutorial yet.
I don't know of any particular videos, but there is a RUclips channel called ExcellsFun and it has a ton of content: ruclips.net/user/ExcelIsFun. I usually just go to Google or RUclips and search for whatever I'm trying to make work. As for data updating in other sheets, most of the time that can be easily done with a formula. It's hard to explain succinctly, but a simple example would be just typing = and then clicking on another sheet and selecting the cells you want to reference. For charts and graphs that you want to move or put on their own sheets, you can just select your data, make the chart, right-click on the chart, and then click "move chart." One of the options will be to move it to its own sheet and the other option will be to place it on an existing sheet. The budget workbook has a lot of different examples of data being referenced across multiple sheets. Some formulas/features took me a very long time to figure out, so it can definitely can be tricky. I'm happy to walk you through any specific examples if you find something that you want to replicate elsewhere. A lot of it was trial and error but somehow it came together! :)
George, awesome tutorial thank you for sharing this!! I as well am interested in tracking networth, since I have a number of properties and investments that show as expenses but there is no way for me to offset this by tracking the loan principal repayment and the market value increase. Would you be able to show us how to add this to this workbook? I really enjoy your clean and thorough setup of this workbook the networth worksheet would just be the icing on the cake?? Thank you so much for your help! Im sharing your chanel with friends and family now!
Hi! I'm so glad you like it and thanks for sharing! :) I got a notification that you saw my response to GetFreshCoinLaundry above, so just let me know if you have any additional questions about the net worth portion. I see that part of your question is different...about expenses toward loans that then correspond to lower principle balances. You are right in that there is no component for this currently. I like the idea, though, and I think it would be fairly simple to add a sheet for loan balances. I'll have to think about how to do that, though, since (I think) it would require integration of an amortization schedule that separates payments into principle and interest. I'd welcome any suggestions here. Either way, I've made note of it and will revisit it soon. Will respond to your other question now! :)
Sorry multiple posts. When changing expense names in List, the changes don't automatically carry to Summary Page. Mismatches have little notes in Summary Page. Whats the trick to get the new list in LIST to agree with the list in Summary. Thanks.
Hi again! Basically, every modified or added expense needs to be manually updated on the Summary sheet. For example, if you change "Groceries" to "Grocery Shopping," just go to Summary tab, click the down arrow for "Groceries" and then select the new title from the menu. You could also just delete the old "Groceries" row from the table and add "Grocery Shopping" at the bottom of the table. You could then re-sort it and everything will adjust. For anything you add to the bottom of the table (e.g., new expense categories), just click in the first white box on the Summary table, select the expense you want to add, and then drag the bottom right corner of the table downward. The total and average calculations will automatically update. Be sure to do the same procedure for name changes on the Budget tab. Does that help?
This is exactly what I need, thanks George
No problem! Glad you like it! :)
Amazing work! thx a lot for sharing and providing the file too!
Hi Christian! Thanks, and no problem! So glad you like it :)
Wow, Smashed the like button in the first 15 seconds. Thank you!
Awesome! Thank you! :) Also, there is a newer version linked in the description, if you are interested. Good luck!
This is an excellent video. Thanks for sharing.
Thank you! :)
Thank you so much for sharing this! You are God's gift!
Thank you so much! :) If you're interested, there is also a newer version in the description. Best of luck, and sorry for the slew reply.
This is wonderful! Thank you so much for sharing this! :)
No problem! Glad you like it :)
Hello, I needed this!! How can I obtain the updated excel you are using in this tutorial? I am only able to download the older version. Thanks in advance.
Hi George. First of all, let me thank you for your video and for the template. I would like to ask you if you can make a video to show how to build it step by step. In particular, i am interested in how to make the last part of the budget where the sheet and the graph change dynamically based on the length of the budget selected.
Hi! Creating in-depth videos about each sheet (or just some sheets) is something my wife suggested a while ago, coincidentally, and I'm definitely open to it! One issue is that those videos might become irrelevant as I update the template, but the general principles would stay the same. With my current schedule, I don't know when I would be able make a video like this, but I added your suggestion to my list of feedback and can hopefully follow-up with it :) Those dynamic sheets were definitely the toughest, but it was a great learning experience to go through that process. One thing that may help you in the meantime, depending on your Excel knowledge, is looking through the formulas. I intentionally kept the formulas unhidden so that people could modify the workbook as they wanted, but they could also be used to learn the mechanics of the workbook or any individual sheet. Of course, I agree that a video would be far simpler, but for now that is an option for you. And I'd also be happy to answer any questions if they come up. Hope that helps!
George Hayward thank you very much for the time you took to answer me. I will definitely look into the formulas in the meantime. Thank you again for your contribution.
No problem! And good luck! :)
George, Thank you. I water to ask if you have a balance or I come sheet.
Hello George , I have searched all over to get a better budget system in place and this one is amazing ! Great work Here, Really like the way the Pie charts show percentage as I am trying to get to a 50-20-30 Budget principle with my Finance.
Couple questions ? 1. Is there something that will show my savings account balance and when I make deposits will it add up in the summary.
2. I made some slight changes to category names but some where along the change path I lost the formula that calculates Average monthly expenses & the difference box . Can you tell where it pulls the data ( formula calculation from so I can get that corrected. I am new user of excel and still learning my way around .
Thanks , Oh and A cup of coffee ( Donation) will be coming next pay day as this is something that will make u huge impact on how I spend my money in the future.
Hi Robert! Thanks for your questions, kind words, and donation! They mean a lot, and I'm glad this is working for you! :) For your first question, there isn't a way currently to integrate bank accounts in real time, unfortunately. So, I don't think it can do what you're looking for there, unless you wanted to modify the workbook and manually keep track of all bank deposits and debits (probably a lot more work than it's worth). I just monitor my bank accounts regularly and use this workbook in tandem with them. Perhaps one day soon I'll be able to link bank account info! For your second question, the average monthly expenses on the Summary tab has this formula: [=Budget!I23] and the difference calculation has this formula: [=F16-F17]. You should be able to copy and paste those in directly (without the brackets) and everything should be back to normal. Let me know if that doesn't work or if you have other questions!
Great sheet, thanks! Switching to this from YNAB.
Hi Jeremy! Just saw this comment now. Awesome! Glad you like it :)
Thanks for your hard work and effort!
You're welcome, thanks for the kind words! :)
Question: What do you do with your credit card payments every month? Can you show us how to do that in this sheet? Thank you so much! I've been using your previous version for almost 3 years now and I absolutely love it!
Hi Christina, thanks for your question, and I'm so glad you've been using the budget for so long! That's always great to hear. As for credit card payments, I personally pay off the credit card each month and record it as an "expense" for $0. Then I just leave a note in the last column that says something like, "Paying off credit card bill for $575." That way I keep track of them but don't double count expenses. Does that help?
@@georgemhayward understood, George. Thank you! I appreciate you and your efforts so much.. keep up the wonderful work!
@@christinalee3279 Thank you! :)
You are AhMAZING!! Thank you, thank you, thank you!!!
Thanks for the kind words! Good luck! :)
Wow this is amazing and will save me lots of time as I help a friend who wants to track his expenses. He would like to be able to have a drop down list for the place (or vendor) and be able to summarize the annual amount spent per place (or vendor) just as you have the ability to summarize the annual amount spent per category. Would it be possible to easily add a link on the list page to be able to insert all places (vendors) so he may select from them then add a tab to summarize expenses per place (vendor)?
Thank you for your detailed spreadsheet you have so freely shared!
Hi Ilene! Thanks for the kind words and for your question. That's a great suggestion but there isn't currently a way to do that. It's definitely possible but not necessarily easy. If you're proficient with Excel, take a shot and let me know how it goes! I made myself a note to revisit this topic when I eventually update this version. In the meantime, if you decide to try this, I think you'd first have to add the data validation. Then, I'd probably recommend duplicating the Categories tab and using that as a base for the modifications. You will have to change the formulas a bit. If you'd rather not do that, you could always just filter the Place column on the Expenses tab and add them manually. That's not as efficient as the prior option, of course, but it wouldn't require the large amount of labor up front. Hopefully those thoughts are at least a little helpful!
Thanks for the hard work, very helpful
No problem! Happy to help :) Thanks for the kind words!
Hi George, question for you. Do I just continue adding my income each month in the first tab or do I delete that month and start again?
How is the best way to start the workbook... all your information is already in the work book for several months.... if I wanted to start today how would I begin putting in my information... as I start on my own it keeps putting me way into the negative because all my money is already in my account and I have been using it but I don't have the income to back it up because again it's already in my account... could you possibly show or explain how best to begin using the workbook
Thank you very much for sharing this hard work !!!!
No problem! Happy to help :)
Hi! I've tried to respond to this many times but for some reason my comments won't post! Sorry about that. Try clicking the link in the description to my newer video and then clicking the DropBox link from there. Hope that helps!
hi. could you please make a worksheet with romanian LEU ? i tried to change it but it messes up the whole worksheet. could you just change everything ro romanian LEU please ?
This is great however I want to add weekly and biweekly bills, not just monthly. Do you have any formulas for this?
This. is. AMAZING. Thank you so much, George! One question: is it possible to have the exchange rates for different currencies included in a formula between two columns (one for USD, the other column for another currency? For example, when living abroad while keeping both US and foreign accounts and keeping money in both of those for various expenses on either side)
Hi Layo! Sorry for the slow response! There's not currently a way to do that, but I think it would be pretty easy to do if you're familiar with Excel. For example, on the Income tab, you could add a column after "Amount" and set those cells to equal to a foreign currency (converted from USD). Conversely, you could use the Amount column for a foreign currency and make a new column for USD. So, if you use the amount column for USD, the new column could be called something like "Euros" and the formula would be =.84*Income[@Amount]. The "Income[@Amount]" will generate automatically when you click in the cell that you are multiplying by. Does that make sense? Hope that helps!
Ahhhh thank you so so much!!!! That was really helpful, I appreciate your time!
No problem! Happy to help :) I'm so glad you like the workbook, please let me know if other questions pop up!
This was and is extremely helpful!!!!
Thanks! So glad to hear :)
@@georgemhayward Hey Morning, is there a way for me to contact you???
how do i filter the budget for example i want to check how much i spent on food in april of 2022
Sorry for all of the questions. I am having a problem with one of the tabs, the income tab. It appears as if all the blank columns now have a header "Column 4, Column 5, etc" with a filter on each column. I have tried everything to delete it and nothing seems to work. It is a problem because it is really slowing down the workbook and every time I try to delete a row, it tells me the operation affects a large number of cells and may take a significant amount of time to complete.
How would you track just transfers between accounts. if I get Direct deposit into my Checking but manually move X amount to savings. tracking it as a expense for checking then income for savings seems to be double dipping. and would screw up my total income
Thank you for the thorough explanation and for the template. I have downloaded the template and I am starting to populate with my own data. I need to know how to "save" it to my computer?
Hi! If you just click File > Save As, you should be able to give it a new name and save it to wherever you want on your computer. Hopefully that helps!
This is very cool and hoping it will help me manage family funds. I do have a question for you. I run all of my money into my checking account. From there I pay all bills and expenses and transfer money to various savings or investment accounts. Using this budget, how do you account for moving money to other accounts? It is a debit from the checking account but it shouldn't affect my overall expenses as the money is still avaible and in a savings account. Any ideas?
Very very great video and will be utilizing!! 1 question though. Do you have another video or sheet that's set up to give insight into creating a spreadsheet that assist with seeing running balances, monthly payments and payments made to credit card and loan accounts?? Possibly a sheet that you input the minimum payment, payment date, ect. Thanks ahead
Hi! There is no video or current feature for that, unfortunately, but a few other people have mentioned it. I've made note of it and will try to add something like that for my next round of revisions. If it helps at all, I record my car payments on the Expenses tab like any other expense, though I don't do that for credit card expenses (since I record each individual expense and just pay the bill when it comes). There is also a running balances tab for bank accounts but not yet for credit cards or other loans (like cars), so I think I should be able make something similar. If you think of any other suggestions for it, please let me know! Thanks :)
what is the easiest way to change to £ instead of $ without messing up the columns or cells please
This is exactly what I am looking for but I don't have Excel. Do you have a Google Sheets version?
Hey George! Great video and very well explained. I have a question, why does all the drop down manues start at the end with all the blansks? How can I change that? :) Thank you!
Hi Roberto! Thanks for your question :) I'm happy to help. I'm not quite sure what you mean about the drop down menus starting at the end with the blanks, though. Are you referring to a specific cell/sheet or drop-down menus in general?
Hi, thank you for creating this document, so far looks like exactly what I need. My only challenge is revising the validation on the list tab. I'm adding cells to the Account column but it seems to only update through the original validation on the bank balances tab. Might be user error :) but wanted to get your thoughts. Using Office 2013
Hi Kim, are you adding cells on the Lists tab between D6 and D13? As long as you stay in that range, all relevant drop-down lists should update automatically. If they aren't, what specifically do you see that is going wrong (e.g., cells X-Y on sheet Z)? If you meant that you are trying to add more accounts than there are spaces for (i.e., you need to go lower than D13), then you will need to update the validation on the relevant drop-down lists. The directions in the first orange box might help. Let me know if I can assist further! :)
Just tried again, it's working.
Glad you got it working! :) What was the issue?
unfortunately the summary sheet does not update when I make alterations on the lists sheet
hi thank you for this. This is very helpful. A few questions, is there a way to just have all of my information in the various tabs where I don't need to have the bank balances tab. Also cant the net income be calculated by looking at the income tab?
I am not able to populate the formula on the summary sheet for the expenses so that it pulls data from the expenses sheet for specific expenses. ? When I use the formula you have and just change the relevant cells it doesn't work...
Thank you so much for this video, it's really a great and ideally to use
Thank you & warmest regrads
No problem! Good luck! :)
Great video! When making purchases and then getting receipts for those purchases from wherever it may be such as gas, groceries, clothing will I do the manual calculations and then enter those in their respective category or is there a place to keep a running total that calculates it for you?
Hi Clay! I'm not quite sure what you mean about a running total, but as long as you enter the expenses on the Expenses sheet (or income on the Income sheet) the totals will be calculated automatically for you. You can see the totals for any income or expense category on the Categories tab. In the top left corner, just choose your viewing preference, and then choose the specific categories you want to see using the drop-down menus on the top right. It sounds like you are interested in the "Total" column in the table, which will vary by whichever viewing preference you choose (last 12 months or financial year). Let me know if I can clarify anything further!
Is there a way (maybe in a future version if not now) to add a column on the Expense sheet where you could mark a transaction when it clears the bank? Thanks for this awesome workbook!
Hi Peter! Thanks for your question. Also, were you able to download the workbook? I got an email from Dropbox saying that you requested access, but you should just be able to download it by clicking the download button in the top right. As for your question, there's definitely a way to do that. Just right click on the table and add a new column wherever you want it. Then, you could just add data validation for responses like "yes" or "no" for whether the transaction cleared. I don't think that would affect anything else in the workbook. Let me know if you still need help!
@@georgemhayward Hi George! Thanks for the response! I was able to download the workbook and did add the column! Thanks again!
I would like to know how to use the template for a new fiscal year. I filled it for an entire year, but want to reuse it, without losing all of my categories.. I thought I had figured out how to do it, but the Budget tabs don't seem to be calculating properly. Please advise! thanks!
Hi DJ, thanks for your question. Which tab, specifically, is not calculating properly? Just the tab titled "Budget"?
Excellent Video,
Hello George,Just starting to become familiar with your worksheet, looks good, I am trying to add some custom "expenses". I made the changes from the list sheet, but they do not transfer over to the summary page. I read your notes, but not sure how to make the changes from the summary sheet?appreciate any feedback.....Thank You very much
Hi! Hmm...it sounds like you already looked through the notes on the Lists tab, so I'm wondering what else could be wrong. There is a second box that you may have missed on Lists tab - the box that says, "if you added items to the 'types of expenses' list." Basically, every modified or added expense need to update it on the Summary sheet. For example, if you change "Groceries" to "Grocery Shopping," just go to Summary tab, click the down arrow for "Groceries" and then select the new title from the menu. You could also just delete the old "Groceries" row from the table and add "Grocery Shopping" at the bottom of the table. You could then re-sort it and everything will adjust. For anything you add to the bottom of the table (e.g., new expense categories), just click in the first white box, select the expense you want to add, and then drag the bottom right corner of the table downward. The total and average calculations will automatically update. Does that help? Thanks for asking! :)
How do you add multiple or additional accounts the bank Balances? Also, I treat my savings as expenses. How do add that variable to the expense type?
Man this is very much appreciated!
No problem! Thanks for the kind words :)
Great video! Thank you very much!
No problem! Good luck!
Today with the interest of setting up a 'control' sheet for my own finances, I happened to chance upon your video for the first time here. I clicked the link to your template, however it does not display any template. It display a continuous stream of HTML code only.
Living in Japan, I noticed there is no option for dealiing with multiple currencies. Most of my transactions are done in JPY (Japanese Yen) but there are situations say like retirement income that gets deposited in USD and I would like to know the equivalent of that based on the current exchange rate. Another situation is when travelling overseas and I might need to deal with THB (Thai Bhat), SGD (Singapore Dollar). It would be nice if there was a way to insert the current exchange rate for a transaction and have that convert to the equivalent amount in terms of the base currecny JPY.
I also gleaned from the tail end of your video that this is not designed to be fully functional to work in Google Shsets. This si unfortunate to read as I do most of my spreadsheet work in Google Sheets (or would like to). Being that it is cloud-based and free to use, I can access, modify, update anywhere, any time regardless of the device I am on. I could consider one of the open source suites such as Open Office, Libre Office, etc., but then, that mererly becomes a local solution and not a mobile / cloud-based solution. Given the nature of this day and age of mobility and accessibility, such features are important to me. Thanks for this video.
Hi Jerry, thanks so much for your comments! I'm sorry to hear that the link didn't work. Has it worked since? I just tried it two different ways and it worked both times. You are right that there is no integration of exchange rates for different currencies. That's a pretty cool idea. I thought about adding that a while ago but didn't think it would get much usage relative to the time needed to integrate that effectively. My best suggestion would be to just convert everything manually and then leave notes in the space provided about the original currency. You are also right that this workbook is not designed to be fully functional in Google Sheets. Another commenter on this video said that he did get it working in Google Sheets, but I don't have the expertise (or time right now, unfortunately) to build and maintain a compatible version. This is something I'd like to do in the future, but for now you may have to adapt it manually if you wish to use Google Sheets. Hopefully some of that was helpful. Good luck!
Just found this, thanks for your hard work George! This covers most everything I want it to do but can it be adapted to envelope budgeting so that I can see a running balance of what is squirreled away for a particular category? Thanks!
Hi Peter! Sorry for slow response...I was out of town for bit during the holidays. There isn't currently a way to do what you suggest, but I do think you could fairly easily adapt the workbook for that. For example, on the Budget tab, you could add a column to the table on the left. That column could equal the projected average minus the current month. Then, you could change the projected average to be the amount in your envelope for a particularly category. If you do that, the new column would be the running balance for any given category. Does that make sense? Hopefully that helps!
Hi George,
Thank you so much for providing such a great tool ! Do you know a way I can download to your template our Citibank Excel spreadsheet of our yearly summary of charges? Their spreadsheet is already separated into a few categories which I would probably need to break into more specific ones. Thank you for your help! Stephanie
Hi Stephanie, and thanks for your question. Sorry about the slow reply! Hmm, I'm not sure how to do that. Perhaps you could copy and paste information from that sheet into this one, but I don't know of another way off the top of my head. When I find forgotten expenses from our bank statements I just enter them manually. Hopefully you can find a good solution. Good luck!