Manage Your Money With a Simple Budget Spreadsheet

Learn Where Your Money’s Going—And If You’re on the Right Budget Track

By
Lora Shinn
Reviewed by
Full Bio
Peggy James is a CPA with 8 years of experience in corporate accounting and finance who currently works at a private university, and prior to her accounting career, she spent 18 years in newspaper advertising. She is also a freelance writer and business consultant.
Article Reviewed on October 11, 2020
Read The Balance's Financial Review Board
Margaret James
Updated January 06, 2021
An illustration depicting people taking on a variety of personal finance tasks.

The Balance

You’ve added up income, categorized expenses, and created a rough outline for a budget. Now, you’re ready to set up a simple budget spreadsheet. You can find budget templates online, use an app, or try out The Balance’s Simple 50/30/20 Budget spreadsheet. 

Create Your Budget

Lay out your budget in a spreadsheet, considering both the broad categories of spending (such as housing, food, transportation) and your needs (50%), wants (30%), and savings (20%). Remember that broad categories may help you capture your spending with the most ease and least fuss—and increase your chances of sticking with a budget. 

A screenshot of The Balance's Simple 50/30/20 Budget
The Balance's Simple 50/30/20 budgeting spreadsheet.

The Balance

Track Your Expenses

Throughout the day, write down your expenses in a notebook, keep track in an app, or on your smartphone.

“Tracking expenses isn't a time to judge good or bad or to even take action,” said Jenifer Sapel, president of Kirkland, Washington-based Utor Wealth, by email to The Balance. “Think of it as like reading a book or meditating. It’s a time just to take note of the data.”

Then, enter your expenses into the spreadsheet at the end of the day or week. But if you’re intimidated by spreadsheets, that’s okay, she explained—the tool isn’t as important as the process of taking inventory. 

Budgets and credit cards can mix. Financial blogger Alene Laney uses her credit card for everyday purchases to earn miles and points. Then she uses the card issuer’s spending reports to review expenses, which she prefers over her bank’s spending report. “When you have good spending habits in place, it won't matter whether you use a credit card or a debit card,” she said in an email to The Balance.

Adjust Your Habits

Money coach and Certified Financial Behavior Specialist Carrie Friedberg suggested undertaking a line-by-line review of your plan, mid-month. 

“Compare the budget versus actuals to date, and make adjustments for the money available while there’s still time,” she said in an email to The Balance. “(At month’s end) reflect on what happened over the last month and use that data to create a more accurate plan for the upcoming month.”

If you need to reduce some of your “fun” spending, first decide what’s particularly enjoyable about that expense, Sapel suggested. Then, brainstorm more affordable ways to earn that enjoyment.

“For example, in a pre-Covid world, I was a regular pedicure goer,” she said. “That expense for me isn't about my nails, though. It’s about having an hour of quiet me-time. I can accomplish the same with a solo walk or visit to the library.” 

Automate some spending to save time, reduce stress, and avoid late payments, suggested money coach and Certified Financial Education Instructor Willita Cherie. Signing up with the provider is the safest method. Bank auto-payments may not always deliver on time, so schedule payment a few days in advance of the due date, Cherie said in an email to The Balance. In either case, request email or physical receipts to track proof of payment. 

Next Steps and More Resources

You can use The Balance’s Simple 50/30/20 Budget spreadsheet to track your income and spending and see how you're doing. Or, if you’d like to use more automated apps or software to create and maintain a budget, options include Tiller Money, You Need a Budget (YNAB), and Mint. 

Next, you’re going to learn how gamifying your budget might help you reach your goals.

You can also learn more about keeping pace with your budget: