Confession: I love spreadsheets! I also love automation. I’ve tried several budgeting tools, but I always return to the dependable and easy electronic checkbook register for one important reason – it’s a powerful forecasting tool. Here’s how I use it to keep my budget in line and to forecast into the future.
Does the budget drive your financial plan, or does your financial plan drive your budget? What’s that you say? You don’t have a financial plan? How about a budget? Let’s back up a bit. What do I mean by a financial plan? Here’s what I’m not talking about: an expensive complicated treatise developed by a financial planner. Instead, it’s a pretty basic template. In 2005, after devouring David Bach’s Smart Women Finish Rich book, I set up my first financial plan. I update it each year and it’s interesting to see how my priorities have shifted over the years. And it’s been fun to think about how to use “extra” money after major goals, like paying off the mortgage, have been accomplished.
Before I launch into budgets, let’s spend a bit more time on the components of your basic financial plan:
The three baskets are retirement, savings, and dream funds. What’s a dream fund you ask? It can be anything, from saving enough money to retire early to paying for a new car to being a VIP guest at a superstar concert. Even if you don’t have a specific dream, put money away into the dream basket. Believe me, you will have a dream a year from now and be thankful you put the money aside!
Your priorities will change over time. That’s the way life works. My first priority, and this should be yours as well, was to sock money away into an emergency savings account. I make sure I have at least six months worth of living expenses set aside for an emergency. Examples of other priorities include opening a Roth IRA, maxing out your retirement contribution, paying off your mortgage, or saving for a new car.
Turn your priorities into action by setting goals for each of the next four years. Why four years? Because it’s manageable. You can tackle a five or ten year plan if you like, but it’s easier to stick to four years. Your goals should be very specific. For instance, I will build my savings account to $10,000 by the end of this year. Give each goal an action and a deadline.
This is the fun part! You’ll want to give yourself a gold star, or perhaps take yourself out for a celebratory dinner, when you reach major accomplishments. And the cool thing is that you’ll have money freed up to divert to other goals.
There’s a symbiotic relationship between your financial plan and your budget. Your income might not support your lofty goals. So then it’s a matter of adjusting your goals – or bringing in more income and cutting expenses. It’s really that basic!
Now that you have a financial plan with specific goals, it’s time to get to work. Don’t let the length of this post intimidate you – I’m giving you step by step instructions. Follow these steps and you’ll be on your way to being a budget master who builds wealth over time!
Download the Free Excel Checkbook Register Template. Yep, it’s free. You’ll need a little bit of working knowledge of Excel spreadsheets. Here’s what the template will look like (minus extraneous columns).
Now it’s time to personalize the template. If you want to rename the file, now’s the time to do it. In addition, I’d suggest doing the following:
I know it looks like a lot of moving parts here, but it’s pretty intuitive. Once you’ve customized the spreadsheet, you are ready to groove!
Now it’s time to play with the spreadsheet and use it as a crystal ball into the future. Here are the next steps:
Do you get paid every week? Every other week? Hopefully, you have direct deposit set up – if not, that’s a “to do” item for sure. Why not enter those dates and deposit amounts now? Even if your paychecks vary week to week, enter an average amount. Don’t worry, you’ll modify the amount once your deposit has been made. And don’t forget to account for any raises that you anticipate receiving.
Now it’s time to look at the other side of balance sheet – your regular expenses. What are their due dates? If your mortgage or rent is due on the same date each month, enter those expenses. You can enter new rows at any time so make sure your transactions are entered chronologically. Do the same thing for your other regular expenses, like car payments, utilities (use averages), student loan payments, and insurance premiums.
Do you have some big expenses that are due quarterly, semi-annually, or annually? For example, I pay homeowner association fees and property taxes semi-annually. Enter those items into the spreadsheet (again, use an estimate if you are uncertain of the amount).
I use a couple of primary credit cards to pay for my other expenses – a cash back credit card (Chase Freedom) and a Target REDCard. Based on a combination of previous spending and my goal to limit future spending, I enter a monthly budget for each credit card into the spreadsheet. For instance, my Chase credit card payment is due on the 14th of each month and my budget amount is $1,500. And YES, you must pay off the full balance each month! You’ll want to leave a cushion as unexpected expenses always pop up. And it may take a couple of months before you figure out a realistic amount to enter into this ‘Other’ category.
Yes, I did say LEFTOVER MONEY! Yippee!!! Now you are on your way to building wealth. If you don’t have leftover money, it’s time to seriously think of ways you can increase your income and/or decrease your expenses. If your goal is financial independence, it’s time to buckle down.
Once you have all your anticipated transactions entered into the spreadsheet, you can tweak your plans to reach your retirement, savings, and dream goals. For instance, you can toy around with diverting additional funds into your work retirement plan. Can you afford to max out your contributions? Or can you contribute $50 more every pay period? On the contrary, perhaps you are putting TOO MUCH into retirement and neglecting your emergency savings goal? It’s time to match your priorities with your actions!
I’ll demonstrate how I use my not-so-fancy spreadsheet to fund my other accounts. I have a couple of checking accounts at Capital One 360 – one for fun and one for gifts. And this leads to another confession: I realized my frugality was shortchanging my ability to do fun stuff, so I created a separate FUN account so that I don’t feel guilty! I automatically send $75 each month into those accounts. Using “leftover money,” I’m also able to divert funds into my Betterment account, which houses my home remodeling fund.
One of the neat things about the simple Excel spreadsheet is that once you have your major transactions figured out, you can project into the next year. Remember back in step 2 when I asked you to rename your worksheet to the current year? That’s because I want you to copy your current worksheet into a new worksheet, and rename that one with next year. Here are the details using the current year as an example:
You can then go into next year’s worksheet (‘2018’) and enter transactions to complete the year. As next year rolls around, modify the new worksheet as needed. And just like that, you have an easy-to-use tool that puts you on the path toward wealth!
The Excel spreadsheet works well if you want a “hands-on” approach to your finances. I’ll admit, it’s not for everybody. You might have better luck with an online tool, like YouNeedABudget (YNAB) or Quicken software. The reason why I keep returning to my simple spreadsheet is that it allows me to project into the future. Once it’s set up, it’s easy to maintain. In fact, I’m in the process of training my newly employed 19 year-old daughter on how to use the spreadsheet to reach her goals! The bottom line is that this simple budget spreadsheet will EMPOWER you to take charge of your future!
Dr. Brenda is a sociologist, educator, blogger, motivator, and financial coach. In addition to blogging at The Five Journeys, she writes 30-day challenges at BetterLifeChallenges.com. Her passion is guiding people on their journey to financial freedom through coaching at DrBrendaMoneyCoach and online courses at EarlyExitAcademy.com.