best excel book for finance This is a topic that many people are looking for. bluevelvetrestaurant.com is a channel providing useful information about learning, life, digital marketing and online courses …. it will help you have an overview and solid multi-faceted knowledge . Today, bluevelvetrestaurant.com would like to introduce to you The Smart Personal Budget Template – YouTube. Following along are instructions in the video below:
“Hello and welcome to my channel. My name is abdullah camel and today. I m m gonna be showing you a template that i designed. And it s called personal and the reason that i designed this template is because i looked through microsoft website trying to find a personal budget template and i didn t really find anything useful all of them are liking something and some of them are really just rubbish anyway so i decided to take on this challenge.
But the way i work the way the way. I designed templates is you know i need to have a goal. Okay. I need to have something to achieve.
Okay. A reason. Why i m doing this okay. So i thought why anybody wants to design personal budget template for me.
You know the only reason is to save money. And probably the second reason is just to know where does your money go because because all of us has been there when you know when suddenly you think okay where did my money go where what did what did i spend my money on okay so. But basically. It s just to save money okay so the way i design templates is to to keep that goal always in in the back of my head.
Always something you know like a beacon. You know something that i want you to get to anyway so the first thing is always separate your input from your output. Okay and by the way before we get any further what i m gonna be showing. You is how the philosophy of designing this template and how it works what i m not gonna be showing.
You is how to create it yourself from scratch and the reason for that and not because i don t want to do it. Because it takes almost an hour and the video will be an hour long probably okay if we re going to go through everything okay. And i think that s a long time for a video. But if i find a lot of people wants to actually have a video about it and how to actually create it from scratch.
You know i ll probably do it for you guys okay..
But meanwhile what i m gonna do i m gonna provide the link for the in the description for this video. Where you can actually download this template use it share. It you know do whatever you want with it change it maybe even feedback me on maybe and some improving improvement that you want to add to it maybe okay the other thing just we want to actually agree on here is just the you might disagree with some of my you know calculations here. Because people are different okay for me.
I m always keeping that beacon as i told you saving money for me saving money includes having these visuals that you see in front of you available. You know always as long as i can see something like this in front of me i can you know save money i can spend less okay for you things might be different all right so let s start with the input okay as we said separates your input from the dashboard or from your reports from your insight from your outputs. Okay and the input you need to simplify. It as much as possible.
This is the way you know i work always you know i think of any simplot that i design as an app right so you need to simplify the inputs as much as possible and enrich on the other hand. The outputs. Okay make them as big as possible as complex as possible you know go wild alright. So what the input is actually is just three columns.
Okay and those three columns you can probably get from your online bank account or you just entered them yourself okay so in okay. So we have the expenses. But we also have the income in the same table. And this is a strategic move to kind of simplify you know the the process and the month and year you know columns here there are calculations and everything else here they are also calculations you know just to help us produce.
These graphs okay. The only other input that i might add is just the starting balance and this is basically how much money did you have when you started you know using the template. Okay. This is your starting balance.
Okay. A disclaimer all of the numbers here that you see there are random numbers that are that are not my expenses or anybody else s okay there they are randomly generated using the random between functions okay anyway so going back to the dashboard. Okay and the things that i think are important okay our income year to date. I want always to have an idea of how much income.
I had from the beginning of the year until now okay and i need to see the year..
Okay the current here and it s telling me now. It s 2017 okay same goes for expenses year to date and current balance. I want to know how much expenses. I had years to date and how much you know my current balance is at the moment.
Okay. This table is also important to me i want to know how much money. I spent on each category years to. Date.
Okay so i know the total of my. Expenses here which is. 40000 almost 15000. But i want them broken down by expense category.
Okay and the other column here i want to have an idea on how much did i spend on each expense category this month. Okay and the last column here you know i need to have an idea how much i spend on each category in the previous month. That s important for me because it will give me you know a soft cap that i can always you know keep in mind watch for not to exceed you know so if i can manage you know to hit the end of the month with you know less expenses this month. You know in a certain category compares the previous month then i m making improvements thus i m making you know i m saving money so as i told you it s always look for that beacon you know always keep it in the back of your head.
Okay. The next chart here the biggest you know thing that i want to look at is you know the total expenses this month. So this chart you know is basically just showing expenses for this month. She s showing me the total here and the colors here for the donut chart is showing me what is the biggest you know what s taking up the biggest chunk of my you know monthly expenses and i could see you can see here.
It s groceries. Okay the next chart here is something also i want to know to be able to save money is an idea of how my expenses compares to my income for each month. Okay so as long as i have some green shading here you know it and as you can see here a choosing this chart. And it s not a stack chart these are just columns on top of each.
Other okay so expenses will be filling up you know the income chart..
So as long as i have green shading. I m in good shape. If i don t have any green shading in a certain month. Then i m not i didn t do good in that this is what it means period.
Okay and all of these months are for the current here okay something to keep in mind. And this is what i want this is what i want to see maybe for you things will be different. Maybe you want to see two months back maybe maybe you want something like this. I don t know the last chart that you see here is the waterfall chart and the waterfall chart for me is important because it will give me a quick snapshot on my you know financials years to date.
Okay it just telling me very quickly did i save money or not okay. So i shown me the year start balance has shown me the total income years to date. Shown me the total expenses year to date. And the last column here is showing me the current balance.
So as long as my current balance actually bigger than my year start balance then i m in good shape. I m saving money if my current balance is less than my start year starts balance then i m not gonna go cheap. I m in a bad shape. I m using up my savings and this is in no way i situation i would like to be in okay.
And i should do something about it okay so i left some blank areas here because i m sure i will have you know new ideas in the future. Maybe for new charts for things that you know become more important now than ever than before right so. What has been maybe important for me before maybe now is not as important new things might come up an example of that is if you have three years. Worth of data you know and suddenly you can look at the chart.
And see oh i don t have anything that s comparing years to year. And something that you want to have because you want to see over the years are you improving are you moving in the right direction. Did your income increase for example. You know your income is decreasing or so you start adding a new chart as you go along.
But with with the goal in mind to save money or maybe to make more money you know something also that you need to think about okay so it s always look for that beacon..
Anyway. So this is what i think you should know about the template. So far. And there are a lot of good templates.
A lot of good ideas here on how to design. It and i would actually advise you to always protect your dashboard or a report you can call it whatever you want here protected. But don t use a password so if we protect it here remove everything you know so nothing can be changed or even selected okay and don t put a password and click ok. It will be protected it just you cannot select anything you know there s actually something weird happened anyway so when you protect it that selection should go away actually yeah.
It s gone away. So yeah. So you cannot change anything here alright. So i m ok.
I think we hit the end of the video. So i ll put the link as i promised in the description feel free to download it share. It and if you have any feedback on it anything that you think might improve the template and give me a shout and i ll see what i can do and and if you want me to make a video on how to make it from scratch. Please.
Again put. A comment on the video. So in the end thanks so much for listening. And i hope to see you next time music.
Thank you for watching all the articles on the topic The Smart Personal Budget Template – YouTube. All shares of bluevelvetrestaurant.com are very good. We hope you are satisfied with the article. For any questions, please leave a comment below. Hopefully you guys support our website even more.
Download the Template file from the link below:
Don t Request Access, just download the file by clicking on the download icon
Everybody hates personal budget spreadsheets right? well hopefully not this one, because it is not like anything out there, because this one is focusing on encouraging you to save money.
I designed it for myself, I asked myself “If I am going to ever use a personal budget file, what should it look like?
Personal Budget, Excel, Advanced Excel, SUMIF, SUMIFS, Named Ranges, Waterfall Chart, Excel Templates, Home budgeting Template Excel