A step by step guide on how to create a budget from scratch with free Excel spreadsheet!!
FREE SPREADSHEET TEMPLATE:
*(To make copy go to “FILE and MAKE A COPY”)*
If you would like to support my channel!:
Mint Mobile (save on your cell phone):
Books I’m Reading
The Dawn of Everything:
Who Moved My Cheese:
Outlier: The Story of Success:
Chapters
00:00 Start Here
00:49 Step 1: Get Set Up
02:02 Step 2: Track Your Expenses
05:14 Step 3: Subtract Spending From Income
07:02 Step 4: Analyze Your Expenses
11:14 Step 5: Create Saving Goals
12:33 Step 6: Constantly Revisit And Revise
Creating a budget is something that empowers you to have the control over your financial situation. In this video, I give a step by step guide on how to create a budget from scratch.
Step 1: Get Set Up
Before you begin creating your budget, you first need to gather up the materials you need that allow you to create it. The first thing you need is all of your statements that have your spending from the last month like bank statements, credit card statements, and debt statements. The second thing you need is to open up the free spreadsheet linked above. To create a copy click “File and Make A Copy.” Now we can begin creating our budget.
Step 2: Track Your Expenses
The first step to making a budget is to take the time to track all of your expenses from the past month on the spreadsheet. This is something that will take time, but will allow you to see the entire picture of your financial situation. First, fill out the date and expense you made. Next, in the “Expense Category” column, choose the correct category for the expense. Then, in the “Spending Type” category, choose if it is a “Fixed Expense,” meaning the expense is the same amount each month like rent; or “Variable Expense,” meaning the expense is a different amount each month. Next, choose if it is a want or need from the “Want/Need” column. Finally, put the exact amount down to the penny in the “Amount” column.
Take the time to write down all of your expenses from the past month and off to the side, the charts will automatically populate giving you a clear picture of your finances.
Step 3: Subtract Spending From Income
A sustainable budget is one where you are spending less than you are making. To figure this out, you simply need to subtract your spending from your income. On the bottom of the spreadsheet is a tab labeled, “Budget Breakdown,” go to that sheet. The first table you should put your income sources. Off to the right the information will automatically populate and it will give the amount remaining. If you are spending more than you are making, then you need to analyze your budget.
Step 4: Analyze Your Expenses
Since we tracked all of our expenses on the spreadsheet, we can easily analyze our expenses to see why our budget isn’t sustainable and how to fix it. In order to do that we need to review three things. The first is want/need spending where we can simply cut out our wants to save money. The second is our variable expenses where we can analyze if anything can be lowered or cut out. If there is something that can, go to the “Budget Breakdown” tab and record it on the “Variable Expenses Savings” table. The third is our fixed expenses and see if anything can be lowered or cut out. If there is something that can, go to the “Fixed Expenses Savings” table to record it.
Once you analyze the different things you can save money on and input them in the tables, it will automatically populate on the blue table and you can see if you budget is sustainable with the savings.
Step 5: Create Saving Goals
Once you create a sustainable budget where you are no longer spending more than you’re making, you can create savings goals. On the spreadsheet there is a tab labeled, “Savings Goals,” this is where you will record your financial goals. On the top is the amount remaining after all your bills are paid and you can use that to create realistic goals.
Step 6: Constantly Revisit And Revise
There never comes a point when you are finished with your budget, but it is something that you need to constantly revisit and revise to make sure you are living in a sustainable way. Over time your lifestyle and spending habits will change and so you have to constantly be updating it. However, once you create a sustainable budget, it will empower you to have more control over your financial life.
**I am not a financial advisor. The ideas presented in this video are for entertainment purposes only. You are responsible for the financial decisions that you make. Links above are affiliate links where if you click and order, I will receive a commission at no cost to you. **
What are other "how to" videos you'd like to watch?
Hello! I tried to click on the template, but it said I only had view only access so I had to send you a message. Can you please assist me with this? Thanks so much!
I tried to make a copy of the spreadsheet but it says it is unable to make a copy and that the page does not exist
so do you create a brand-new copy of the spreadsheet for each month or do you just continually add expenses to the master list for every consecutive month?
Also the Replacement costs of items like vehicles, changes in living,…
So simply explained thank you a great help
Now I have more knowledge about personal finance, thanks to your channel, I just subscribed.Big ups to everyone working effortlessly trying to earn a living while building wealth in this recession. I’m 45 and my husband is 51, we are both retired, no debts. We are currently living a frugal and financially savvy lifestyle and generating passive income even during this recessionary period. Our commitment to saving and investing in the financial market has enabled us to maintain this lifestyle and continue earning monthly passively through investment.Traveling is now on our horizon, thanks to our financial choices*
Thank you for your advice! happy Holidays!
Austin!!! Doing this helped us discover SCAM TRANSACTIONS! Thank you so much! My husband and i do not share a bank account, he doesn't really check his account history… Long story short, we sat down to go through some accounts and found some fake companies taking small yet frequent sums out. The bank has refunded us close to 500 dollars. Again, thank you ❤
This is the best video i HAVE EVER SEEN TODAY. – God bless you!
Thanks for the template. Customized it a bit to suit my needs a bit more, but great starting template. Thumbs up!
Hi Austin can u share a example budget sheet for learning thanks
I went to a budgeting seminar where the speaker said, internet, and a car are not needs–they are wants or luxuries. She said you can take the bus instead of having a car. Buses only run during certain day time hours so that doesn't always work. Has anyone tried to grocery shop and take them home on a bus? Otherwise it was a good seminar. It's hard to sustain a really pared down budget! If it's imperative to get out of debt, I have done this for 2 yrs and having 2 jobs.
What I'm having a difficult time with now is I'm on SS and my rent eats up almost 1/2 of my monthly income. Rent is really high in today's world. I'm 74 yrs old,so I'm not going to go buy a condo or a house.
Hello Austin. Thanks for sharing your budget strategies and your Excel with us. I found it very useful, so I translated it into Spanish for my mom in Peru. https://docs.google.com/spreadsheets/d/1g89_KTqF4FEz_0V2fTFESJXc8YKjrvSIRs-CNIfgSsk/edit?usp=sharing
Very Good Video
Thank you so much! This is a life-saver!
Thank you so much. This is so helpful.
Thanks for the free spreadsheet Austin!!!
I'm having issues with the free spreadsheet though. There is no chart??
The free spreadsheet is view only doesn't have options to edit
@ELAgustin
Hello, Austin I DL your free spreadsheet, starting to use it. Ran into a hiccup when trying to add new “expense category” for “christmas gifts” and “Christmas decorations” and now when I get to add the amount. It’s conflicting with a rule or something. Also is there a way to add in paychecks? Can you help? Thanks in advance
Interesting that Internet has become a need.
DId a budget for the first time with my husband after 13 years of being together and 8 years of marriage, and we discovered much – thank you for being a part of our new chapter. We'll be back. Any chance you can do a video (if you haven't already) on ways to stay accountable as we move forward in the beginning stages? Thank you, Austin. Signed, "thanks for the wake-up call" from Canada
This was so Fricking helpful thanks MAN!
Thank you man really valuable!
Question: On Budget breakdown B7-B10 are not adding value to the total outcome. Why is that?
How do I (can I) add or subtract items currently found in the category section?
So should we be making a copy of this spreadsheet for every month?
are you gay ??
This is great but the pie charts are not showing up to put the date together. How do I get them to show up?
Thanks a lot for this video
I’m so glad I found your channel I have been trying to budget and save money for the last couple years but failing miserably, you’re a god send my Dude!! Thank you!
wow!!! I can't belive the VALUE on this video and template. THANK YOU SO MUCH!!!
❤❤❤thank you so much, Austin,God bless you😊😊😊😊