Savings Tracking Tool




In 2009, I created the first version of my Savings Tracking spreadsheet. I have received SO MUCH interest in that document since it’s creation. Last year, I updated the spreadsheet with a few formulas and think it’s pretty slick. Well, mostly but I realize some of you still had problems with excel :(

Since I have personally seen the value of tracking my savings and spending, I wanted to find a way to add this spreadsheet as a tool on the site that is easier for everyone to use. I’m excited to officially launch the new Savings Tracking Tool!

This works much like the spreadsheet, only you can just enter your data and not mess with moving cells and downloading the spreadsheet and it not populating the fields correctly and… I really should just get on with telling you how easy it is to use…or you can watch the video above to see for yourself or follow the instructions below :)

So the idea is that you will enter the total amount spent and saved at every store you shop. While my initial intention is to use this to track my grocery savings, it can go beyond that (you could enter retail savings, dining out savings, etc). So let’s talk about each field really quick on the page.

You can easily create a new account by clicking here. Once your account is up you will see your dashboard which looks like this.

The dashboard headers in blue calculate all of your individual entries. The fields calculate exactly how the savings tracking spreadsheet does. Only no need for messing up formulas.

Average/Month
This gives you the average amount spent each month based on the total amount spent and the total number of trips. This helps to show you if you are staying within your monthly budget…or blowing it out of the water cuz you’re a shopping superstar!

Total % Savings
This takes all of your transaction values and calculates the total % savings overall.

Out of Pocket
The total amount of money you have spent out of pocket for every transaction.

Total $$ Savings
This takes all of your transaction values and calculates the total dollar amount savings overall.

Savings $$ Coupons
This takes all of your Savings-Coupon entries and calculates the total coupon savings overall.

Total # Store Visits
This shows you how many transactions or store visits you have entered. I always enter each receipt as a separate transaction or store visit since each has a different value or savings total.

Savings Sale/Store
This field will auto-populate to give you the result of the coupon savings minus the overall savings. As a default, that will typically always be the sale/store promotion value so it shows you what you have saved as a result of store promotions primarily.

Grand Value Products
This calculates your total value of products by adding the out of pocket with the overall savings numbers. This is important to see since many times you can reduce your bill drastically just by coupons. It’s fun to know how much the product value is overall!

Date
A date picker will popup for you to select the date of your store trip or transaction.

Store Name
Enter the Store Name. This is a freeform field so you can enter any store you want. This is good to have in case you want to do individual store analysis.

Out of Pocket
Enter the total out of pocket amount spent at the store.

Savings – Overall
Enter the total savings you achieved at the store. Many stores will give you an overall savings amount on your receipt.

Savings – Coupons
If your store splits out the total savings into store savings, coupon savings, or anything else, list the Coupon Savings here. Many of the stores I shop do this. It’s interesting to see how much of the savings come from the sale versus the coupon. If your store doesn’t split out the savings reasons, just enter a zero.

Notes
Just a place to enter any notes on the transaction. This is a good way to start to remember sales cycles and store promotions as well.


Once you add all of your data, it saves in this Transaction History section. The nice thing about this is that you can quickly select the Comments+ link and see all of your notes.

I REALLY hope you like the new tool. Sign up to use the Savings Tracking Tool for FREE! I’m excited to have this developed and rolling out at the beginning of the year so you can use it all year long and track how your planning, couponing and stockpiling is adding up to something tangible in the grand scheme of your budget!

By the way, the Savings Tracking spreadsheet will remain available to use if you are an Excel geek like me. But, even I plan on using this tool so I can start entering everything online at any computer.

by Savings Lifestyle: Andrea on January 26, 2012

17 Comments

  • alrockmore - January 27, 2012 @ 11:07 pm
    1

    OMG! I just love this! I always keep my receipts so I can gloat over my savings while I file them away.I wanted to start some sort of sheet to keep up with it but never followed through. This is quick, easy, and self explanatory. This is going to be my new addiction! LOVE IT! Thanks for sharing!!!

  • MDSchwer - January 28, 2012 @ 10:27 pm
    2

    I’m not seeing my percentage of savings showing up. It still says 0%. Is there a problem with that part? Thanks! :)

  • StepNerd - January 30, 2012 @ 1:35 pm
    3

    Hi there!

    My total percent savings field is still staying zero percent. I am not sure what I am doing wrong. Is there a way I can upload this tracker to my computer so that I do not have to log in to the website every time?

    Thanks,

  • MDSchwer - February 05, 2012 @ 9:43 pm
    4

    Thanks for fixing it, Andrea! Appreciate all you do! :)

    Melanie

  • twokds2002 - February 27, 2012 @ 6:59 pm
    5

    Thanks, I love it!

  • jenstarr - October 08, 2012 @ 1:57 am
    6

    Thank you for this quick and easy Savings Tracking Tool… I would love to see in the next update a way we can see the savings per calendar month. It’s great to see how much I’ve saved since I started using the tracker but my husband wanted to see what I had saved just in September and there wasn’t an option to select just the month I wanted. Everything else is great.. Keep up the good work :)

  • Chellsy Brereton - January 01, 2013 @ 8:31 pm
    7

    How do you record a moneymaker? Particularly with Ibotta, I think we are going to have more transactions like that. For example, today at Meijer I purchased:

    Reach Floss $1
    Dove Conditioner $3.49
    Dove Hair spray $4.09
    Lady Speedstick $2
    Special K cereal $2.50
    Frosted Flakes $2.50
    Eggo Waffles $2
    Total = $17.58 + .18 Michigan sales tax = $17.76

    Instant discount for purchasing 2 Dove products = – $2
    Brings total to $15.76

    Paper manuf. coupons I had:
    $.70 off Special K
    $1 off Reach floss
    $.50 off Frosted Flakes (doubled at Meijer to equal $1 off)
    Total in paper coupons (including doublers) = -$2.70

    Brings total to $13.06

    I additionally had a Meijer mperks digital coupon for $10 off grocery/health/beauty purchases
    Brings total to $3.06 OOP

    I can enter all of this information but now with Ibotta, I had the following:

    1.25 off Lady Speedstick
    1.75 off Dove conditioner
    1.75 off Dove hairspray
    1.00 off Special K
    1.00 off Frosted Flakes
    1.00 Eggo Waffles
    Total in Ibotta rewards = $7.75

    So, since I only paid $3.06 OOP and made $7.75 from Ibotta, this was a $4.69 moneymaker for me. The way the online tool and spreadsheet is set up, it doesn’t really allow for moneymakers in this way. Would it calculate it correctly if I entered the transaction without the Ibotta rewards and then entered another transaction of $0 oop and $7.75 savings? I don’t know. Any suggestions would be appreciated. Thanks!

    • Savings Lifestyle: Andrea - January 05, 2013 @ 12:35 pm
      7.1

      Chellsy, since iBotta is so new, I would add the iBotta rewards as savings in your original transaction and show a -$4.69 purchase amount. Or, you could also do as you have suggested. We are going to work on making some more cool updates to this tool this year.

  • ejerian2012 - January 30, 2013 @ 3:56 pm
    8

    I am trying to go to page 2 of my transactions to see if I had already input one of my receipts. Everytime I click on the 2 or next, it acts like it is working but it stays on page 1. Please help.

    • Savings Lifestyle: Andrea - February 01, 2013 @ 12:54 pm
      8.1

      I’m looking into this with my developer. Not sure what’s going on. I’ll email you when we have a resolution. Thanks for your patience!

  • Susan Sullivan - July 31, 2013 @ 8:03 pm
    9

    I just started with this an my last few purchase were under $1 out of pocket but I noticed it is not keeping in the change. Is there a way I can change that?

  • Bev Swain - April 11, 2014 @ 11:48 am
    10

    I am VERY frustrated!! I had used the tracker last week, but forgot my user name/password, & I can’t find ANYWHERE to reset it or retrieve it. HELP!!!

Leave a Comment