Track Your Savings Free Worksheet ~ Boot Camp Episode #4
What better way to hold yourself accountable and motivate you so save, than tracking your savings? Several years ago I created an Excel worksheet that I used to track our monthly savings at the 5 major stores I shop at.
Sign up for Saving The Family Money FREE newsletter and you get this worksheet for free. (It will arrive in your inbox within an hour of signing up.)
There are 7 separate tabs. The first one is a Totals page. The rest are specific stores. I have them set up to track the following stores:
- Miscellaneous (Combination of stores I shopped at like Home Depot and JoAnn Fabrics)
You can relabel them for the stores you use frequently. You will not have to enter any information on the Totals Page, it will automatically fill in when the store tabs are updated. The only information you will need to enter is the date, the OOP and Savings on the store tabs that are highlighted in green.
It will total the months for you and autofill the Totals Page. In the comments section I list key items from that particular shopping trip. Sometimes it’s nice seeing how long it had been since I bought coffee creamer! On the miscellaneous page, I list the store and what I bought.
Several things I learned from tracking our savings this way. Publix was easy to enter because the receipt is easy to read and very straight forward. Target was difficult. The receipt shows savings, but it’s usually only coupon savings. It does not include clearance savings for instance. I learned in the first 2 months that I didn’t save very much money at Walmart! So I started avoiding that store altogether. It’s also a bit of a drive for me so it was easy to eliminate. I realized I was bad at picking up ‘impulse items’ at Walmart.