Price Tracker Sheet

Price Tracker, Price, Book, Amy Dacyczyn, pricebook

The use of this form is described in more detail in our book, Cut Your Grocery Bill in Half with America's Cheapest Family.

We used this form when we were first learning our prices (we got the idea from Amy Dacyczyn's Tightwad Gazette newsletter and modified it for us). It's a great tool to track prices between stores and price increases over time. Use one page for each item you want to track. You can fill in prices from the grocery ads or as you walk the aisles of the store. When you see a low price you'll know it's time to stock up and save!

We've reproduced the form in .xls.doc and .pdf formats

After you've tried the form, leave a comment here and tell us if it helped you save any money.

Author: 
Steve and Annette Economides
Scottsdale, AZ
03/2010
Tips: 
field_vote: 

Comments

<p>I just downloaded this form and can't wait to start using it not just only for groceries but for anything I <strong>need</strong> to buy or replace. The only thing I would like to suggest to Steve and Annette is that it needs a comments line for things like tax, shipping, sale dates and so on as I do buy many things online too (<strong>saves</strong> <strong>gas</strong> and wear and tear on my car) and always order the <strong>best price</strong> on that item with <strong>free</strong> shipping or the lowest price of shipping offered.</p>

<p>Sounds like you're a gung ho price shopper. If you come up with a form that works for you, could you send it to us? We'd love to give it a try.</p><p>These are awesome ideas!!!</p><p>&nbsp;</p><p>S&amp;A</p>

<p>I think the idea of a price tracker is great! It seems it would be easier to put on an excel sheet so that it can later be easily sorted and include an 'item' category in the "A" column just to the left of where your date starts.</p>

<p>If you send us your version of an excel spread sheet for tracking prices, we'll give it a try.&nbsp;</p><p>We're all about taking ideas and improving them. Keep leading the way.</p><p>S&amp;A</p>

<p><span style="font-size: 12px; line-height: 16px;">&nbsp;</span></p><p style="margin-top: 1em; margin-right: 0px; margin-bottom: 1em; margin-left: 0px;">Thanks to a generous, frugal and computer savvy friend, we now have a price tracker sheet available in Excel!</p><p style="margin-top: 1em; margin-right: 0px; margin-bottom: 1em; margin-left: 0px;"><a style="text-decoration: none; color: #0048cb;" href="http://www.americascheapestfamily.com/sites/default/files/Price%20Tracker%20Sheet.xls" target="_blank">Price Tracker in Excel</a></p><p style="margin-top: 1em; margin-right: 0px; margin-bottom: 1em; margin-left: 0px;">Give it a try and let us know how it works for you.</p>

<P>Originally I used an old address book. It worked great to quickly thumb through tabs to look up an item. But I'm nothing if not thorough and I soon ran out of space. I also worried that I might lose my only copy and have to start over. I print this version and carry it, marking up changes in pencil. I'm overdue to update the Excel file and print a new copy for my purse. Let me know where to send it to you.</P>

<P>My husband has asked me to compare prices&nbsp;in the past and I've balked at the idea.&nbsp;&nbsp;This would be a much easier&nbsp;way to do it!&nbsp; I'd love to have the file too, if I may.&nbsp; Thank you so much for providing these great tools!&nbsp; I first heard you a couple of months ago on Janet Parshall's program on Moody Radio.&nbsp; I&nbsp;just purchased the Kindle version of your new book last week and am really enjoying the well laid out information.&nbsp; Not reinventing the wheel is important to me -- as are the baby steps.&nbsp; For me, the first step is better organizing my time (around home schooling) so that I can plan consistently and well.&nbsp; God bless your ministry and mission ~ Kristi</P>

<p>Thanks to a generous, frugal and computer savvy friend, we now have a price tracker sheet available in Excel!</p><p><a href="/sites/default/files/Price Tracker Sheet.xls" target="_blank">Price Tracker in Excel</a></p><p>Give it a try and let us know how it works for you.</p>

<p>The new price tracker is now posted on the website.</p><p>Thanks for taking time to prepare and test it!</p><p><span style="font-size: 12px; line-height: 16px;">&nbsp;</span></p><p style="margin-top: 1em; margin-right: 0px; margin-bottom: 1em; margin-left: 0px;"><a style="text-decoration: none; color: #0048cb;" href="http://www.americascheapestfamily.com/sites/default/files/Price%20Tracker%20Sheet.xls" target="_blank">Price Tracker in Excel</a></p>

<p>I know you won't all have a smart phone but if you do, you might try <a href="Kids, Holidays and Financial Gifts Question: I have your three books and have read about the Money System; I have a question regarding giving money for holidays (to your children). Do you give money to your children for holidays or do you have a rule to not give money? Answer: We don’t usually give money to our kids for Christmas, as our family enjoys the tradition of opening presents. Yes, it is more work for us, but so much more fun! We do set a dollar amount that we spend on each gift recipient, but the cool thing is that because we shop all year long, we’re able to lavish them with a larger number of gifts. This is because we can usually find things at steep discounts as we watch and wait all year long. While a flat dollar amount might be easier, being able to give lots of presents for the same amount we might have given is more rewarding. We also try to find appropriate presents for birthdays, but depending on how busy we are, sometimes we do simply give money, especially if we know the kids are saving for something in particular. The older married kids get a gift card to one of their favorite stores. Our son John is a new homeowner so he loves Home Depot gift cards." target="_blank">Sharky Shopping</a>. &nbsp;It is a FREE price book for Android phones/tablets that:</p><ul><li>Allows you to keep track of your expenses and shows the best/average and worst unit prices you've paid.</li><li>Provides a history of your purchases.</li><li>Allows you to generate a shopping list based on the best prices you have recorded.</li><li>It's free!</li></ul><div>Thanks for your consideration.</div>

<p><span style="font-size: small; font-family: tahoma,arial,helvetica,sans-serif;">First, thank you so much for tackling this endeavor to help people!&nbsp; A few years ago, I read and loved Amy Dacyczyn's <em>The Tightwad Gazette</em> and started implementing her suggestions.&nbsp; I've been looking for more current advice in a comprehensive format, and your books and website seem to be just what I've been needing.&nbsp; In comparing prices, I started with a little hand-held notepad, devoting a page to each product.&nbsp; I found that I didn't like the difficulty in alphabetizing, though, so I created an Excel spreadsheet that I could easily sort by product.&nbsp; It's actually exactly like your sheet, but has an additional column at the front in which to enter the product.&nbsp; I also have a few other columns so Excel will do more of the work for me.&nbsp; </span></p>

<p>It's an awesome way to create great tools when other frugal friends share their improvements! We'd love to see what you created and make it available to others. Could you share it with us?</p>