How I Track My Savings Goals With A Savings Tracker in Excel {Tutorial}

This website may earn commissions from purchases made through links in this post.

Tutorial on how to create a savings tracker in Excel to track multiple savings goals.

track your savings using Excel
[MclittleStock]/stock.adobe.com

Working towards multiple savings goals?

Want to keep track of how much you’ve saved towards your upcoming bills?

Even though I stopped keeping a traditional budget and moved onto a more effective budgeting system, I still like to track our individual savings goals. It’s not essential, but it’s motivating to keep track of your goals.

These days you can have multiple savings accounts to separate your savings, but I find it easier to manage a single account and then use an excel spreadsheet to allocate a single savings amount to different savings goals and expenses.

Updating this spreadsheet takes me about 3 minutes a fortnight, a few minutes longer if I’m paying bills. That’s all the time I now spend on budgeting, and yet we now find it easier to stick to our budget than we ever did when I was tracking expenses. 

Disclaimer: This is general information only. In this blog, I share my savings and budget planning and what works for us. You should always consult a qualified financial expert when making money decisions to tailor plans to suit your circumstances.

It’s important to note that this is a two-step system.

Step one: (this one is the most important) I automate our savings. If you’ve calculated how much you need in advance, it’s not essential to track your savings goals unless you like to watch your progress for motivation or you’re a data lover like me.

Step two: allocate your savings. The rest of this post is all about how I do this in Excel.

Now, you can create a much simpler spreadsheet if you prefer, or you can just use an exercise book and pen, which is how I tracked my savings for years. The most important thing is to do what works for you. 

Below is the system I use.

How to Track Savings Using Excel

This tutorial goes into detail on how I set up a savings tracker in Excel, but it assumes some basic Excel understanding. If you have any questions about Excel, feel free to email me.

1. Set Up the Backbone of the Spreadsheet

1. Start by creating the headings as per the image below. Add your own savings categories down the side of the spreadsheet. (You can click to enlarge the pics).

Along the side are your savings goals or the things you want to save for. Put in specific goals you want to save for. For ideas, check out the articles:

Along the top includes:

  • Your Target – the amount you want to save
  • Your opening balance – how much you’ve already saved
  • Add adjustments – (optional) in case you get extra money to add or want to swap some money between your savings goals
  • The months of the year
  • Total savings for this year
  • Less expenses – for when you spend some money
  • Less adjustments – (optional) in case you want to swap money between savings goals
  • The total amount you have for that savings goal, including your opening balance, expenses and adjustments
  • Remaining – how much more you have to save to reach your goal.

It might look a bit complicated at this point, but once we add the formulas, this all calculates automatically; all you have to do is put in your savings amount each month.

(click images for a larger view)

track your savings with excel

2. Add Your Formulas

In each subtotal row, enter the subtotal formula, following the steps in the image below. 

track your savings using excel

Then enter the formula:

track your savings using excel

Then you can easily calculate the total for the column.

Important!: Don’t forget to enter some numbers to make sure it’s all calculating properly!

track your savings using excel

If you have an older version of Excel, rather than using the subtotal function, you can use the Autosum function on each subtotal row and then add each subtotal row together, as shown below.

track your savings using excel

Once you have your formulas, use the fill handle to copy them along to December.

Also, copy and paste the subtotal formulas in the subtotals row for less adjustments and less expenses headings.

track your savings using excel
track your savings using excel

Next, in the Total Savings for the Year column, use the Autosum Function to add together all the savings amounts from January to December. Drag to copy this formula down the column. 

track your savings using excel
track your savings using excel

In the Total column, you want to calculate exactly how much you have saved towards your goal, including opening balances, expenses and adjustments. So in the Total column, type the following formula

=Opening Balance + Add Adjustments + Total Savings for the Year – Less Adjustments – Less Expenses

track your savings using excel

Again, copy your formula down and test by adding a few numbers.

Finally, in the Remaining to Save column, calculate how much you have left to save until you reach your savings goal with this formula:

= Target – Total

track your savings using excel

Finally, test test test.

Type in a few numbers in the cells to make sure it’s all calculating as it should.

3. Formatting Your Spreadsheet

Select all of the cells that contain numbers and format them to currency.

track your savings using excel

Format headings, fonts and colours to your liking. This isn’t just to make things look pretty; it helps you to read and understand your spreadsheet, so take a few moments to pretty things up.

track your savings using excel

At this point, you’re all set up!

Now it’s a matter of simply entering your savings each month. You won’t have to go through this process again; simply Save As your spreadsheet each year. 

There are, however, two more things I like to add to this spreadsheet to make sure it’s all working accurately. The first is a little Checksum / Reconciliation at the bottom of the spreadsheet to make sure the spreadsheet reflects the total amount I have in the bank.

At the bottom, I add a spot to type in the balance at the bank.

Underneath, I enter the formula:

=Bank Balance – Total Savings

track your savings using excel

If these numbers aren’t the same, then there’s either an error in the spreadsheet or I’ve been paid interest that I haven’t added!

I also like to track inflows and outflows to see how my savings are progressing overall.

Inflows = total savings for the year (not total savings all up) Type “=” and then click on the Total Savings cell and then press enter.

Outflows = total expenses for the year. Again, type “=” then click on the Total Expenses cell and then press enter.

Net Savings = Inflows – Outflows as shown below. You can click on the cells instead of typing them.

track your savings using excel

And that’s it. You’re all ready to reach your savings goals. Don’t forget to automate your savings, and you’ll never look back.

I hope that these instructions make sense. If not, drop me a line. If you have any suggestions for improvement or would like to share how you track your savings, please let me know.

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *

6 Comments

  1. i have multiple savings goal over many months ; want to spend on some of them while trying to save enough to cover all of them. how do i calculate ?

  2. Hi S Klee,

    This spreadsheet is for tracking multiple savings goals. If you have a deadline for your goals, put that date on your goal and divided the amount you need to save by the number of weeks you have to save it, to get an idea of how much you need to be putting aside to reach your goals. Because of the way this spreadsheet is set out, the bottom amount isn’t so important as the lines for each savings goal. I think I will go into more detail on this topic in a post next week.

  3. This is exactly what I was looking for! Except I have no Excel experience and am lost trying to understand step 2. Add Your Formulas…I know this post is old, but any chance someone seeing this could help or point me in the direction of where I could go to understand this stuff?

  4. Hi Melissa,

    I wonder how you would feel about selling your spreadsheet. Instead of people including myself who are not wonders on excel, spending an hour setting up a spreadsheet I’d be happy to spend $8 – $15 to download yours and just change your headings.
    Just a thought.

    Jacqui

    1. Melissa Goodwin says:

      Hi, thanks for the suggestion.

  5. I wish a sample file was attached