How to Make a Monthly Budget Excel Spreadsheet | Cashflow, Income, Fixed and Variable Expenses
In this Excel free tutorial video, we gonna se how to quickly and easily create your own digital monthly budget planner in Excel.
I wanted to create a Monthly Budget Spreadsheet that included my Income, my Fixed Expenses, my Variable Expenses, my Bills etc.
All this informations I'm gonna use inside the same tab in Excel.
Learn how to start a monthly budget with the Excel Personal Monthly Budget template, including projected and actual income and costs, can be a useful skill.
We gonna use the formula to make de Balance and the to make the remaining value.
The function Sum in the Excel is also used in this tutorial.
The SUM function in excel adds the numerical values in a range of cells.
Being categorized under the Math and Trigonometry function, it is entered by typing “=SUM” followed by the values to be summed.
The values supplied to the function can be numbers, cell references or ranges.
#JopaExcel #Dashboard #HowtoExcel
Пікірлер: 158
This is the best spreadsheet “expense planner” video I have found. It gives very detailed directions. All of the others seem to think that the viewer is already extremely familiar with how excel spreadsheets work. Thank you from a person new to excel who is trying get a clearer view of my financials.
Thank you for being a teacher and not a salesman. There is an undeniable difference. I will donate to you.
Exactly what I needed to get started! You explained very simply and easily for a beginner. I was able to watch on my tablet as I followed along creating my first monthly budget on my computer. Thank you! 🤗
This was better than a previous spreadsheet I done. I love this one the best. I did not add credit card b/c I pay everything with it to get the awards points. I just pay the card off each month. I followed this video better than having all the different pie charts and graphs like the other videos. Plus, I like seeing for the whole year even though I only tracked since aug. I will start 2024 off using this spreadsheet.
PLEASE never delete this!
@JopaExcel
4 ай бұрын
Ok!! 🤣🤣 Thanks 🙏👍
@elgatogordo9523
3 ай бұрын
I totally agree 👍 This is Gold!
Thank you so much. This is the first Excel video I have watched that is so clearly set out and so simply practical. It’s exactly what I had hoped to learn. Blessings to you from New Zealand. Thanks heaps.
This tutorial is very simple and perfectly explained. I have followed along and managed to create my own monthly budget for the first time. Thank you so much and God bless you. Receive lots of love from Kenya.
Very helpful and beginner-friendly! I'm 19 and I was able to finish this in a day's time.
This is brilliant! Thank you very much for taking the time to create and share such a clear, helpful video!
Perfectly explained. Thank you!
Super easy to follow, and more importantly: Extremely useful! Thank you!!
@JopaExcel
11 ай бұрын
Thank you 🙏👍
This was SO helpful for me, I followed step by step and FINALLY have a spreadsheet that I like and can understand. Thank you very much!
Thank you so much. I'm glad I found you. Best tutorial ever!! So helpful.😊
@JopaExcel
8 ай бұрын
Thanks! 🙏👍
Great presentation! Thank you.
Bro you’re the best i swear you saved me
@JopaExcel
Ай бұрын
Thank youu! 🙏👍
You made that so simple. Thank you so much!
@JopaExcel
11 ай бұрын
Thank you! 🙏👍
Loved this video. Steps were clearly described. Thank you!
Awesome! I'll watch this again tom once I'm on the computer.
@JopaExcel
Жыл бұрын
Thanks! 🙏👍 If you have any questions let me know!
BEST video out there that I could find - thank YOU very much!!!!
@JopaExcel
3 ай бұрын
Thank you 🙏👍
👍simple and effective. I like what you did with the balances.
@JopaExcel
Жыл бұрын
Thank you, mate! 🙏👍
Thank you, really helpful!
Very easy to follow along! Helped me out a good bit. Many thanks ~
@JopaExcel
11 ай бұрын
I'm glad it helped you! 😁
Thank you very much. This will really help me get my finances on track.
This was a great tutorial. Thank you, it was very helpful!
now i know how to make my monthly budget excll❤
Thank you so much for this free tutorial! The flow and explanation was amazing and easy to follow. Really enjoyed it. I'm a new subscriber!
@JopaExcel
7 ай бұрын
Glad it was useful. Thank you 😁🙏👍
Great job Jopal, i love it, thank you for the tutorial.
@JopaExcel
Жыл бұрын
Thank you, Simon! 🙏👍
At last, video that makes a lot of sense, thanks.😊
🤩 LOVED IT THANK YOU I LEARNED SOMETHING NEW
thank you so much!! helped me alot with excell. more powers!
Thank you so much no one is doing theirs like this
Thank you for your informative video. Just what i needed! Will creating this spread sheet as a guide. Retiring in a xouplenof years and this willncome in handy!
Excellent video! so freaking simple! thanks man!
@JopaExcel
9 ай бұрын
I'm glad it was useful for you. Appreciate it! 🙏👍
Very helpful. Appreciate you taking the time to make this tutorial!
@JopaExcel
8 ай бұрын
Glad it was helpful!
Thank you! This was so easy to follow!
@JopaExcel
9 ай бұрын
I'm glad it helped you. 🙏👍 Thanks for the feedback!
Thanks you showed me a few tricks I wish I had learned years ago.
Thank you, that helped a lot!
this video was awesome. definitely helped me figure excel out for my first try and left me amazed and intrigued. fire.
Thank you; this is very helpful.
May God guide and bless you brother. Thank you soo much 😇
Your instruction is great. If you should have a template that I could use that would save me a lot of time and eliminate mistakes. Thanks, Frank
thank you mr jopa for your excellent tutorial very big help for me i labya😘
Thank you so much. I'm glad I found you.
@JopaExcel
9 ай бұрын
I'm glad it helped you. 🙏👍 Thanks for the feedback!
Thank you for sharing this was very easy to understand
Thanks for your video.
This tutorial saved me thank you!! 😭🙏🙏
Thanks a lot you have done great for me 😊
This was the BEST explanation of Excel I have ever received. I learned more from this video than I’ve learned from other in the past year. What an excellent video and excellent teaching. I love my spreadsheets now!!! Thank you 🙏🏽!!!
thank you for the lesson!
@JopaExcel
10 ай бұрын
Thanks!
very simple and easy thank you
Very nice video! Thank you! Just what I needed!
@JopaExcel
Ай бұрын
You're welcome!🙏👍
Great video! Thank you.
@JopaExcel
6 ай бұрын
Glad you liked it! 🙏👍
Its very helpful . thank you so much
Thanks Baiya.
I really enjoyed your teaching ❤
Thank you so much! Simple, effective, and to the point.
@JopaExcel
Жыл бұрын
Thank you, Carine! 😁👍
LOVE YOU BROTHER IT WAS ESY AND SIMPLE … I JUST SUBCRIBE TO YOUR CHANNEL
Thank u very much yo such a good teacher
Thank you for this video it really helps me a lot 😊 I have to subscribe and likes and definitely share with others who need this help I’m now my own accountant 😊😊
wow the best video I have ever get regarding excel spreadsheet thank you!!
@JopaExcel
2 ай бұрын
Glad you enjoyed it! 🙏👍
Awesome job!!! This was my first time doing a spreadsheet and it was simple thanks to you. I have one question how do I add Owner contribution to spreadsheet, so that it will populate?
Thank you so much!
@JopaExcel
10 ай бұрын
Thank you! 🙏👍
I’m like everybody else in the comments this is exactly what I was looking for.
@JopaExcel
2 ай бұрын
Thanks for the feedback. I'm glad the video helped you 👍
Great JOb!
@JopaExcel
Жыл бұрын
Thank you, Isidro! 🙏👍
It's really helping thanks you sir
AWESOME ,THANKS
@JopaExcel
8 ай бұрын
😁🙏👍
Super helpful bro
Hello! First of all, you really helped me! I don't understand a thing about excel and because of you, I made my first spreadsheet and it seemed super simple, all because of your amazing explanation. I just have one doubt: If i make savings from my paycheck - for example take 200€ from my 400€ paycheck - how do I add it to the spreadsheet? Thank you so much in advance and much love from Portugal!
Amazing Thank you so much
@JopaExcel
10 ай бұрын
I'm glad you liked it! Thank you 🙏👍
Thank you!
@JopaExcel
4 ай бұрын
Welcome! 🙏👍
Very useful thanks for this content
@JopaExcel
Ай бұрын
Glad it was helpful!
Thanks, I realized there should be other source of income of employees, workers, business person's to whatever category belongingness, to whoever Matter or bigger Magog carriers, I learned that from your presented example personal data with many expenses though with improving income, maybe later.
This is gold
thanks so much
You make this look soooo simple! Excellent template. Thank you, Sub'd
@JopaExcel
2 ай бұрын
Glad you like it! Thanks 🙏👍
Thanks man 😇
@JopaExcel
4 ай бұрын
Welcome 🙏👍
Very good and easy to understand. Liked and subscribed :)
@JopaExcel
9 ай бұрын
Ivan, thanks for the feedback! 🙏👍
amazing video deserve more views
@JopaExcel
8 ай бұрын
Thanks 🙏👍
nice...
@JopaExcel
2 ай бұрын
Thank you!
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.
@mohammedabboud4891
11 ай бұрын
i would say add the gross income onto the spreadsheet and add TAX as a variable expense obviously most months it will be $0 but when th time comes to pay tax u add it in as an expense, that way u account for everything. It also makes sense to add the gross income as that will be the amount u hold until u pay tax, so in simple terms just count the TAX as an expense.
Thanks
@JopaExcel
10 ай бұрын
Thanks so much, man! I appreciate it.
Hello, how would we go into the next year and the following years? Just clear out the previous year's data for each month?
Great video would love to know how you put in budget bs actual
@JopaExcel
11 ай бұрын
Good question. I gonna make a better video about this subject. A 2.0 spreadsheet version. I gonna make some improvements! Thanks 🙏👍
You are so amazing
@JopaExcel
4 ай бұрын
Thank you. 🙏👍
Tanx bro!, what if july am inserting abig numner in the cell (2000000), what should I do??
what could be the reason my SUM formula wont work? i googled and tried to fix it but it still wont work. sorry but im beginner with excel lol! great video!
It was a little more difficult for me since I am using OpenOffice which has different buttons and some are missing (since it is free). I would rather use Excell but there is no free version. I have a question. How do you set up to add to your variable expenses as you go. So if each day I have different amounts to add to one or more of the expenses, how can I add to the expense without calculating it myself? Can you create a second page or something where you just something like "food" where you type in a new value and it adds to the old value during the same month?
@JopaExcel
8 ай бұрын
Brian, thank you very much for the question. Your question is really good. Maybe, what can you do is, let's say you are in the January month, and in case you had many expenses during this month, you can, within the same cell, add the amounts spent on food, for example: = 9.90+20.00+10.00... But, the ideal would be to create a "daily" instead of a "monthly" one, this way, each spreadsheet would have a month, there would be a spreadsheet for the January, another for February and so on. And in each column, you would have a day. First day, second day, third day etc. I will create a new spreadsheet to be able to better meet this demand, your question is really valid, thank you.
Thanks - this is very helpful! Very well explained. But although I followed you carefully I was not able to click-hold-drag to get the formula to repeat for each month. Is there a trick that I am missing?! thanks
@JopaExcel
6 ай бұрын
I'm glad it was useful for you, Cath! 🙏👍 Look, if the "hold drag down" isn't working, you can try copie and past instead. Ctrl C and Ctrl V. Ctrl C the cell with the formula, select the rest of the cells where you need to input the same function and then Ctrl V. I reckon this can solve your problem.
@user-rc1zy7sj6x
6 ай бұрын
Thank you very much @@JopaExcel - this was exactly the trick I needed! I appreciate you taking the time to help. Great video!
@JopaExcel
6 ай бұрын
🙏👍😁@@user-rc1zy7sj6x
@thegmastert7656
5 ай бұрын
Yes
How we handle the invoices. Example: when paid invoices how will update the budget. So do we have to get separate spreadsheet for invoices tracker? but how it will update the budget in a dynamic way?
@joukenienhuis6888
11 ай бұрын
You have to make a separate spreadsheet for the tracking of the expenses. And don't confuse both of them, because an expense tracker tracks down all your expenses. Budgets are only planned expenses and not real expenses. They are made to give any idea of what you are going to spend. If you have made the two sheets, you can compare them and see if you have spent too much or if you have money left.
I subscribed to you can you make a budget on a restaurant and mostly I'm watching on your channel
I like this alot but wish it had a transaction page to work with it😊
@JopaExcel
9 ай бұрын
Eric, thanks for the feedback. I'm always bringing new videos. I will bring new updates with this suggestion. Thanks!
@mccartneyjustin
9 ай бұрын
@@JopaExcel First off, great video. I would also like to see the transaction page video as well!
@bobmatters
6 ай бұрын
@@JopaExcel Also want to say thanks for the great video, if you have made a transactions video to go along with this one, can you link it? Thanks
prepare the budget for the above company for agust september october november december 2021 .(you have to apply appropriate layout ,formating formula etc)show the variance of expenses and revenue using appropriate graphs.plz this one how to create 😊
If i create a table of income and expense in worksheet 1 and within each of the income and expense i have a lot of sub-category expenses/income like laptop, income, supplies, etc. then in worksheet 2 i use data validation to categorize my income and expenses by their sub-category . How do I add the monthly total of the sub-category in worksheet 3? Example: 01/01/24: supplies $10.00 01/02/24: revenue $100 01/02/24: meal $10.00 01/03/24: meal $10.00 So for month Jan my total meal is $20, how would i be able to create a formula in worksheet 3 to have the sum total of meal for jan?
Is the template available?
❤it
@JopaExcel
Жыл бұрын
Thanks, man! 🙏👍
How can a chart be made of all the data?
This would be much better if the file you are working on could be downloaded so we can follow along.
Could you do this in googlesheets please.
@JopaExcel
Жыл бұрын
Hey, Renee! I just made it, kzread.info/dash/bejne/pKecw86BpsvYnLw.html. I saw your comment a couple days ago and here it's, the spreadsheet for GoogleSheets. 🙏👍
@ReneeThompson-mo4qj
7 ай бұрын
Thank you
my iphone doesnt work on last formula. icant make 925 to the next cells.
@JopaExcel
Ай бұрын
Excel for desktop is different from Excel for mobile. I believe that is the problem. But try doing it via desktop or at least via Excel web, I believe it can solve the problem.
can you share the template
@villa_fan8882
7 ай бұрын
I can yes…. It’s £50 and it’s all yours! :)
@ShOookYx
7 ай бұрын
@@villa_fan8882 lol