Budgeting for Beginners: An Easy 5-Step Plan to Making a Budget in Excel

One of the most common things that I hear from people is “I don’t have any money”.  The advice from most personal finance people is “just budget”, but there’s countless “budgeting for beginners” templates that are anything but for beginners. It’s not helpful to someone just starting out.

So I’ve written this guide. If you like Excel and making spreadsheets, you’ll probably like it. This is how I personally manage a budget and how I’d recommend many beginners to budgeting and personal finance to start.

So, if we really examine why most people have any money… we can come up with some observations…

I oftentimes see my friends blow money mindlessly and then when it comes time for them to do something to benefit themselves, they claim to not have money.  I know people that will go out and spend hundreds of dollars at restaurants, at bars, on sporting tickets, video games, and other unnecessary items but claim that they are not able to save money each paycheck. 

When it comes down to it, this is nothing more than an excuse.  I used to be one of these people.  I was in awful credit card debt when I was in college, but I did the best thing that anyone can do…

Stop.  Spending.  Money.  Mindlessly.

I sat down, confronted my fears, and wrote down everything that I was spending money on.  You know that person I described earlier?  That was me.  Nowadays I have different priorities. 

Before my money even touches my checking account I have already had part of my check direct deposited into my savings account, my 401k, my Roth IRA and my Brokerage account. 

Those four accounts are never touched as all my bills and “fun money” are used from the remaining funds in my checking account.  A number one way that I was able to grab control of my finances was to begin budgeting. 

I tried many ways and failed, but it’s not how many times you fail, it’s that you continue to get back up and keep trying.  I finally found a method that works for myself and I think it will work for you too.  Below are five beginner steps that I followed that really helped me get a hold of my spending habits:

1. Understand the reason why you want to start budgeting.  What is causing this change in your life that makes you want to grab your finances by the horns and take charge?  Is it just that you want to “grow up?” do you want to save more? Do you have something you’re saving for, like an engagement ring or a wedding? Maybe you want to go to the Final Four and need to save for $1000 tickets!  It could be anything – the point is, you need to know your reason as this will drive you to stay focused and dedicated.

2. Confront your fears.  You are probably scared to look at your finances and where all your money is going.  I know I was.  But this is the only way that you can get better.  For some of you, you might prefer to use the app Mint, or write them down, but I prefer to track mine in Excel.  When I first started, I went back and downloaded the last three months of spending from my checking account/credit cards and export the transactions into a csv file.  This allowed me to take a look at where my money was going and try to find ways cut out the unnecessary spending.  There’s no better way to predict the future than to look at the past, so this is the first place to start.  I have an example below of how I did this:

As you can see, each transaction has a date, the purchase, the payment method (53 stands for Fifth Third Bank which I use for my checking), the amount, and then the category. 

The Purchase and the Category are similar but also different as the Category can encompass many types of purchases that fall into it.  Once you’ve listed out all your purchases, group them into Categories like I did. 

Note that for the first line item the Purchase is LA Fitness for my gym and the category is gym.  I do this because I might have other purchases that can go under the “gym” category, such as if I rent a bike, do a drop-in class at a different gym, etc. 

I also code things in acronyms a lot, as you can see I have “BED” listed.  BED stands for Bars, Eating Out, Dinners for me as a catch all for those types of items.  I do this to give myself some extra flexibility if I want a nicer dinner and want to not spend money going to bars with friends. 

I also use GACH as an acronym which stands for Groceries, Animals, Cleaning, House.  This also is a fitting acronym because it’s often a very large portion of my monthly spending and it truly does GACH my budget. 

See what I did there?  I apologize for the bad humor. 

Anyways, GACH encompasses a lot, but really is focused around my purchases at the grocery store and Amazon each month.  Again, it makes it easier to group things together and I view these all as needs rather than wants.  I strongly encourage you to only group needs with needs and wants with wants, otherwise things can become skewed and wants might overpower needs.  Some common groups that I have are:

  • Income – include all income.  This is the most important as you need a starting point.
  • Fixed Expenses – these are the same each month and never change.  Popular items include Rent/Mortgage, Personal loans, Credit Card loans, cable, cell phone, gym, parking, car payment, car insurance, and electric.
  • Variable Expenses – Groceries or “GACH”, “BED”, Presents for people, travel expenses, gas for your car, uber/lyft, haircuts, laundry, workout supplements, clothes, medicine, music, car maintenance, misc. spending.
  • Savings – many people choose to include this as a line item in their budget.  Personally, I prefer to set up automatic payments from my checking so I don’t have to worry about it.  Then, I simply just use my income number – savings amount.  For instance, if I get paid bimonthly at $1500/check, and I want to save $300/month into my savings, simply use $2700 as your income.  That $300 is automatically transferred and is “Untouchable Income” as I like to call it.

3. Analyze your spending.  Now that everything I spent money on the last three months was grouped, I quickly realized that I was spending wayyyy to much out with friends and at restaurants.  I always felt that was the case, but I never really put any pen to paper and noticed just how bad it was. 

Not only that, but I was spending money on Hulu, Netflix and Cable each month…why did I need all three?  The answer, I didn’t.  I barely used Hulu. 

Not a ton of money, but $8/month is nearly $100/year.  Won’t make or break your budget, but if someone offered you a $96 check each December when you’re doing Christmas shopping for your family, I’m guessing you wouldn’t turn it down. 

4. Assign appropriate dollar values.  Now that you’ve grouped your purchases into categories and inputted your income, the next step is to find appropriate dollar values to associate with each one. 

Obviously, at the end of the day, you want your income to be greater than your spending totals. 

The more you can increase that difference between income and spending, the better off you are – but you need to be careful.  A budget is just a budget.  It’s an app, spreadsheet, piece of paper, etc. – and nothing more.  A budget is just a plan. 

Anyone can put in their budget that they’re only going to spend $50 on eating out in a month, but when you take your girlfriend to a steak dinner and spend $200, then what do you do? 

The point I’m getting at is yes, try to spend low and constrict expenses, but also be realistic.  There’s nothing saying you can’t spend $200 on a steak dinner if she has a birthday coming up and you want to treat her, but make sure you have room to do so. 

If you don’t, you need to make sure you’re prepared to sacrifice something else to save money to spend on that dinner. 

If you’re not willing to make these sacrifices and tough decisions, you will fail before you even start.  I have included an example of how my budgeting format that beginners can use, which is below:

5. Track, Monitor, and Update.  I recommend that you track purchases at least twice/month.  When I first started, I was inputting purchases every few days to make sure I was staying on top of it. 

Not to mention, when I went a few days without spending a lot, it was exhilarating!  It was motivating!  And especially addicting. 

I loved seeing the days go by and still having a lot left to spend (or even better, not spend, and then use to save once I got to the end of the month). 

It’s important to remember that from month to month your purchasing will change.  Your budget should change as well. 

If you know you have to change your oil or replace your tires, make sure to put that in your budget. 

If you decide to grow your hair out and don’t want a haircut, eliminate the spending you had allotted for that category!  A budget is a living, breathing, flexible item, just as your life is very fluid and changes on a constant basis.

Hopefully these five steps will help you get control of your spending and start saving! 

The key is to stay focused and up to date on your budget.  Even if you fall off the horse for a weekend or two, confront your fears, track that spending and get back at it. 

At the end of the day, you’re in control of your own destiny and a budget is just a tool that can help guide you to financial freedom!

Andy Shuler, Guest Contributor.

Learn the art of investing in 30 minutes

Join over 45k+ readers and instantly download the free ebook: 7 Steps to Understanding the Stock Market.

WordPress management provided by OptSus.com