7 MIN READ
How to Budget if Spreadsheets Make You Want to Gouge Your Eyeballs Out
If you’re anything like me, you’re perpetually swinging between vowing to cut all unnecessary spending cold turkey and humming “Treat Yo Self” as you order your third UberEats meal in 12 hours.
Which one you are depends on the day — and how long it’s been since your last paycheck.
The result: a pitiful savings account balance, scrimping to pay the minimum on your credit card, and feeling like you’re still living paycheck to paycheck even though your income has come a long way since your first job out of college.
You know there is a way to solve this problem. You know that if you just create a budget — and by some miracle, stick to it — you could finally get the financial freedom everyone else seems to have already figured out.
You also know budgeting is a buzzkill.
But if you give it a genuine shot, I promise I will, too. We’re in this together.
How to Budget in 4 Easy Steps
Creating a budget doesn’t have to be a grueling process. If you take some time to prepare and learn how to budget in a way that makes the most sense for your lifestyle, you can start on the road toward controlling your finances in no time.
We laid out exactly what you need to do in four pretty easy steps.
Step 1: Know How Much You Make and Spend
Before you can make a budget that works, you need to know your numbers. Log in to your bank account online, and grab your last couple statements. While you’re at it, grab your credit card statements, too.
First, write down how much you bring in each month.
Your biweekly paycheck. Any extra money that comes in from your side hustles. Child support payments. Recurring bonuses or stipends. Financial aid payments. Include it all.
Up next, the painful part: It’s time to log your expenses.
Start with the recurring stuff: Your rent or mortgage, car note and car insurance, health insurance, phone bill, internet and utilities. Don’t forget the fun stuff, like your Netflix and Spotify Premium accounts.
From here, you’ll want to start adding up your discretionary expenses. How much are you spending on shopping, eating out and drinks with friends?
To get a full picture, you can put these things in categories. For example, movies, concerts and museum visits can all go under entertainment. Your gym membership, yoga membership and the drop-in rate on that one CrossFit class can all go under fitness.
Look at a few months of statements for this part, too. That will give you a more accurate picture of your finances.
Step 2: Set Your Financial Goals
If you’re going to succeed at this budgeting game, you need have an idea of what you’re hoping to accomplish.
It can be a simple short-term goal like learning to budget so you can save for a vacation with your college besties. Or a long-term one, like learning to budget so your kid can go to college without student loan debt.
Set a goal, and make it good — it could be the only thing that stops you from buying yet another pair of shoes this weekend.
I take it a step further and mix my financial goals with my personal ones.
For example, I tend to overspend on restaurant meals. But budgeting less for eating out means I cook more healthy meals at home, so I save while staying on track to accomplish my weight loss goals, too. Then, I can use the money I save to build up my emergency fund as I pay down debt a bit faster.
Step 3: Find Your Favorite Budgeting Method
Once you have a complete picture of your finances, it’s time to pick the budgeting method that works best for you. The one you choose will depend on how much time and energy you have to devote to it. If you feel comfortable with an Excel file, you can do that.
But we’ve got a few super simple ideas you can try if charts make your eyes glaze over.
You don’t have to spend several hours a month working on a budget. The easiest way to budget is to grab a pen and paper and simply write down how much you make. Then, figure out how much you need to spend and how much money you need to save.
That’s it. You’re done.
I’d suggest keeping that sheet of paper somewhere visible to remind you to rein in your spending.
The zero-based budget takes the bare-bones budget one step further. The goal here is to get to zero at the end of each month. It helps you account for each dollar on the way.
Write down how much you make, and divide it to cover all your bills, savings and discretionary spending until you hit $0 at the end of the month.
Although this plan encourages you to get down to nothing, the idea isn’t to spend without regard; it’s to make sure every dollar goes exactly where you intend for it to go every month.
This takes all the guesswork out of deciding which expenses should stay in your budget and which ones need to go.
With the 50/20/30 plan, 50% of your money goes to essential expenses like housing, utilities and your car payment. From there, 20% will go to financial goals like savings and investments. The final 30% is yours to spend on the fun stuff like restaurants, movies and drinks with friends.
Once you’ve picked your favorite budgeting method, don’t be afraid to bend it a little to fit your financial situation.
Step 4: Find the Best Budgeting Books, Apps and Software for You
While budgeting by hand works great, your smartphone can streamline it.
My favorite free app is Mint, which is available on iPhone and Android devices. You can connect your bank account and credit cards, and set a dollar amount for how much you plan to spend in each category.
Mint will then automatically analyze your spending and notify you when you get close to your budget or overspend. It’s pretty easy to use and can save you lots of time. The only downside is that the “You’ve exceeded your budget” emails can sometimes feel a little judgmental.
If Mint isn’t for you, there are a few other books and software apps you can try that come highly recommended by my Penny Hoarding co-workers:
You Need a Budget: This started out as an app and then became a book, too. It hinges on four rules:
- Give every dollar a job.
- Embrace your true expenses, not your ideal ones.
- Roll with the punches, and adjust your budget as you spend.
- “Age your money,” and start to break the habits that leave you living paycheck to paycheck.
This is more hands-on than other apps. It’s also the only option that’s not free. After the 34-day trial, you’ll pay $6.99 per month for the service.
Every Dollar: If you’re a fan of the zero-based budget, this is the free app for you. It’s also perfect for the side hustlers whose income can fluctuate from month to month. As you manually track your spending with the app, use it to make sure every dollar you make is accounted for.
Prism: This isn’t technically a budgeting tool. But it’s still worth mentioning. This free app puts all your bills in one place so you always know exactly how much money you have and how much you owe. You can connect everything from rent and car insurance to student loan payments and your Tidal music streaming account, and you can pay your bills right from the app.
“The One Week Budget”: This book is an Amazon bestseller by Tiffany “The Budgetnista” Aliche. We’ve even got a copy in our library at The Penny Hoarder HQ. With a series of worksheets, it walks you through how to analyze your income, track your spending, and pay down debt fast so you can get back to saving for the life you want.
“The Total Money Makeover”: This book was written by financial guru Dave Ramsey. A few Penny Hoarders who have paid off heaps of debt swear by his teachings. His book is also an Amazon bestseller and could be the perfect place to start if you want to break some of those not-so-great money habits and start building a budget that works.
Desiree Stennett (@desi_stennett) is a senior writer at The Penny Hoarder.
The Penny Hoarder Promise: We provide accurate, reliable information. Here’s why you can trust us and how we make money.