When it comes to saving money, every dollar has a purpose. This guide will show you how to create T accounts for a budget. A T account is a simple system that helps you track your finances and savings, like a budget within a budget. They are a simple way to keep your saving, and spending, in check and to be sure you always have money for emergencies.
*This post was originally published on August 8, 2013 and updated on January 17, 2020.*
*This post was written by my husband Jesse, the builder of our budget.*
Hands down my favorite part of doing our finances is saving money. There is nothing better than watching a small sum of money turn into a large pile which you then get to blow on vacation, house, remodeling, TV, you name it!
Saving money doesn’t have to be complicated. The biggest tip I have is to remember: Every dollar has a purpose! This is the key to how we do our finances. Each dollar in our bank account that is left over after paying our bills is designated to a purpose. There is no “extra” money. If we have $200 after we do all of our bills that $200 is divided up and put towards a saving purpose. For example, if Ashley wants $40 to paint the bathroom we need to have at least $40 saved in our “fun house” money. We could have money in the bank, but if we don’t have any set aside for the house, we can’t paint the bathroom.
Creating “T Accounts” to Budget for Saving Money
Let’s work through an example with J&J. In the last section J&J created their household budget, but now they need to budget their savings. J&J are all paid up on their bills and they have $900 in the bank. Before we set up their savings spreadsheet they need to identify what their goals are and what they are saving money for.
After talking it out, J&J have decided they would like to save for a house, a TV, and they would like money to spend on clothes or other fun things. So let’s create a new tab on our spreadsheet called “Savings.”
Now we are going to build something accountants call a “ T account.” Yes, it sounds dreadful and complicated, but I promise it’s not. They are a very simple tool for tracking what is coming and going. Ashley even uses them (and she hates all things math).
Let’s start with creating a “House fund” to save for a down payment. Let’s put “House” in B1 and “description” in A1 and D1. If you want, you can merge cells B1 and C1 to make it pretty looking for our T account.
Now we need to add lines in the shape of a “T”.
That’s a fine looking T account. Go ahead and add two more for “TV” and “Fun+Clothing.” I just copied the first account and renamed them.
The truth is you need to decide what is best for your situation. Look at the risks and what could go wrong. Do you rent or do you have a house to take care of? Does your partner work or are you the sole provider? Is your work steady? These are all questions you need to ask yourself and then determine what amount is right for you.
Here is a good example of how allocating your savings can work: When I originally wrote this post in 2013, there was a contractor working on the roof because it was damaged during a storm, Ashley was sick and had to go to the Dr., we were booking our big European vacation, and I was in furlough status at work (meaning I got 25% less take home pay). However, I wasn’t too worried! Because we had set aside emergency money for the house/sickness/job loss and we had saved up all the money for our vacation. So despite income loss, house damages, and sickness, our vacation was still on track!
So, go ahead, and add another account for “emergency.”
Let’s add $200 to the TV fund by putting it on the left side of the T account. The descriptions are optional, but they are more helpful for when you spend money.
Score we have $200 saved for the TV. Lets fast forward in time and add $150 and $250.
Notice how the T account added everything up. We’ve got $600 so let’s buy a TV! The TV was on sale and cost us $479, plus we had to buy a surge protector for $33 and some cables for $25. Now let’s put those on the right side of the T account. Remember, Left in Right out.
Notice what happened at the bottom of the T account, it should say $63. That’s because it adds everything on the right and subtracts if from the left. So we added $600 (200+150+250) to the TV fund and spent $537(497+33+25) which left us with $63. Notice how I used the descriptions too, helps me keep track of where my money went.
So now we have a TV but we still have $63 in our TV fund. Since we have a TV now we don’t need a TV fund, so let’s move that money somewhere else. Let’s move it to the house fund. Remember “Right in, Left out”.
So J&J have paid all their bills and have $900 in their bank account. They have decided to allocate:
Let’s go ahead and enter those in.
We want to summarize our T accounts so we can just look at the totals. In cells A1 and A2 lets add “Fund” and “Total”. Now let’s get the information from our “Savings” tab. To do that all we need to do is type “=” in A2 then click on the savings tab, then click on cell B1, and press enter. The formula should read “=Savings!B1”.
If everything worked out you will see “House” in A2 on the summary Sheet. Now lets add the total for the house fund by typing “=” in B2, clicking on the savings tab, then clicking on cell B20, and press enter. The formula should read “=Savings!B20”.
Go ahead and add in the rest of the accounts by repeating the steps above.
Let’s add a total now. And add the numbers together by using our “=sum” function.
So we’ve learned how to create a budget and how to use T accounts to track our savings and set money aside for our goals, all that’s left is to put it into practice!
What is your strategy for saving money? How do you save up for those big purchases? Do you have an emergency savings built up?
I love me some Excel, but I’ve never used it to track our finances. This is such great advice! I’m looking forward to sharing it with my husband! 🙂
These are great tips and the tutorials are super helpful! One of my questions would be- do you keep all the savings in one savings account or do you end up with 2 or 3 for the various things you’re saving for?
I was wondering the same thing. Do I need to have multiple checking and savings accounts for all of this? On that note…what bank(s) give the best interest rates or don’t charge for multiple accounts?
Or is it best to go old school and keep the money in cash in a cookie jar? Haha
Just one actual bank account. But you can have multiple, like a checking and savings account. Just take the total amount that is in the bank accounts and work with that on the spreadsheet to keep track of how much is designated for what. For example if I have $500 in checking and $1000 in savings. I would use a total of $1,500 on my spreadsheet when dividing the money up.
Great job again, Jesse!
Kevin and I have three savings accounts: Big House Fund (for all our big remodels), Vacation Fund, and Emergency/General Savings. We have caps on all of these accounts, so that when we reach a certain savings goal, anything over that goal we add to our monthly student loan payment to help pay those puppies off sooner.
Aren’t student loans ANNOYING!