UPDATED: due to the many questions & comments I’ve gotten on this tool, I will be holding a FREE LIVE WEBCAST on Monday, January 10th at 8pm PST on this blog to share more of my vision on how this works, and help you get your grocery budget together for 2011. For details, please see this post.
Rejoice! It’s here!
The new and improved Savings Tracker 2011 is available for FREE download in either Excel or Google Docs.
What is this Savings Tracker?
If you’re new, you should know that I care about numbers. A lot. And it’s important to me that you see that your hard work couponing pays off. My free Savings Tracker will enable you to see exactly how much you’re saving each month and year-to-date thanks to your coupon-clippin’, penny-pinchin’ ways. And even more importantly, you’ll be able to set a grocery budget for each month and track your spending against your budget!
How do I use it?
First decide if you want the Excel or Google version. Download and save to your computer. Then, get acquainted with this spreadsheet. You’ll notice there are several tabs. I HIGHLY recommend you read the “Getting Started” tab first. From there, decide what your grocery budget will be for each month, head to the “Summary” tab and enter in the appropriate months for the “Goal” column. This is the ONLY place you’ll make an entry on that tab – everything else is hard coded with formulas (i.e. don’t touch!).
For each month, there’s a new tab. Using your receipt, enter how much the shelf price was, the coupons you used, rebates, and so forth. The formulas in the spreadsheet will do all the rest calculating your savings in dollars and percentages, and letting you know exactly how much you have left in your budget for the month.
Anything new for 2011?
Based on your comments, I’ve added a “tax” column. Go ahead and enter your sales tax here (if you pay it). I’ve also added an “Earn Credit” column so you can jot down if you received any Catalina coupons or Register Rewards. But please note, my intention is that when you redeem them, you simply include them in your coupon totals. (After all, these ARE coupons.) I will provide further illustration in January.
This is great! Can I share it?
I would LOVE for you to share my work with a friend, your blog’s readers, Facebook followers and the like. However, I have one small request. Please just direct them to my site HERE for the download. In other words, don’t make the download available directly from your site – I want folks to come here to get it so I can keep tabs on its use. As you might expect, this is for personal use only.
Um. I’m still lost.
I plan on spending considerable time in January showing you how I’m using my own Savings Tracker to manage my goals. So if you learn best by seeing, just wait! It’s coming!
Wait, is this free? What’s the Catch?
No catch. It’s free. Consider it my holiday gift to you for being ridiculously rad and awesome readers and following me on this frugal journey.
Oh, and if you ever want to find it? Just look in the “Downloads” tab under my Navigation Bar – it’s there now!