Savings Tracker And Price Guide Spreadsheet

 
 
LinkBack Thread Tools Rating: Thread Rating: 1 votes, 5.00 average. Display Modes
  #1  
Old 05-31-2011, 07:29 PM
Slightly overwhelmed with this site
New Member
 
Join Date: May 2011
Posts: 18
dgphelps has posted more than 25 good deals
Savings Tracker and Price Guide Spreadsheet

I mentioned this in another thread and thought it might be useful to others.

I've created a spreadsheet to track how much we spend and save and what good deals are. Here is a link to a template in Google Docs. If you'd like to use it yourself go to File --> Make a Copy and it will copy and editable version to your own Google Docs.

https://spreadsheets.google.com/spre...thkey=CJK0wOoP

There are two parts to this worksheet:

Savings Tracker:
This is where I track each trip to the store for groceries and calculate the regular price, the price after sales and coupons, the total savings, and the percent saved.

At the end of each month I tally up by store to see where I spent the most and what my spend was per week. This sheet is easy to use and quick though it may require adding new stores into the month total section which is easy if you copy the formulas.

Grocery Itemized Pricing:
This is the time consuming page. It stands alone and does not speak to the other sheet. This sheet tracks each item per visit along with the regular cost and sales cost and breaks it out into a weight and a unit price. In the sample, I have sorted the rows by name of item to give a month summary of what was purchased. If you look at sugar, you can see that I got a much better deal at Safeway and in the future I will shoot to stock up when I see it that price or lower.

The idea for this sheet is to get a picture over time of what the regular cost is per item we frequently buy and what kind of deals (and when) we get. I plan to print this out and keep it handy when planning shopping trips so we know how much is too much and when/where to buy.

There is likely a lot more I could add to this. If anyone has any specific requests or questions let me know and I can try to fiddle with it to update and make it better for general use.
Become a AFC Supporting Member Today and Make These Ads Go Away!

Advertisement

Advertisement

  #2  
Old 05-31-2011, 09:23 PM

RE: Savings Tracker and Price Guide Spreadsheet

busysoaplady's Avatar
is surfing AFC for the latest deals!
Coupon Goldie
 
Join Date: Apr 2011
Location: Northern California
Posts: 31
My Mood/Status:
busysoaplady has posted more than 10 good deals
this is great! thanks!
  #3  
Old 05-31-2011, 09:27 PM

RE: Savings Tracker and Price Guide Spreadsheet

is surfing AFC for the latest deals!
New Member
 
Join Date: May 2011
Posts: 16
My Mood/Status:
Kerikay has posted more than 1 good deal
I may need to start tracking. Thanks
  #4  
Old 05-31-2011, 09:30 PM

RE: Savings Tracker and Price Guide Spreadsheet

is surfing AFC for the latest deals!
New Member
 
Join Date: May 2011
Location: Alabaster, AL.
Posts: 13
My Mood/Status:
SouthernladyRTR has posted more than 1 good deal
That's great! Thanks =)
  #5  
Old 05-31-2011, 09:37 PM

RE: Savings Tracker and Price Guide Spreadsheet

1NMMom's Avatar
is surfing AFC for the latest deals!
Senior Member
 
Join Date: Apr 2010
Location: New Mexico
Posts: 6,102
My Mood/Status:
1NMMom has posted more than 2000 great deals! WHOA!!1NMMom has posted more than 2000 great deals! WHOA!!1NMMom has posted more than 2000 great deals! WHOA!!1NMMom has posted more than 2000 great deals! WHOA!!1NMMom has posted more than 2000 great deals! WHOA!!1NMMom has posted more than 2000 great deals! WHOA!!1NMMom has posted more than 2000 great deals! WHOA!!1NMMom has posted more than 2000 great deals! WHOA!!1NMMom has posted more than 2000 great deals! WHOA!!1NMMom has posted more than 2000 great deals! WHOA!!1NMMom has posted more than 2000 great deals! WHOA!!
This is great
__________________

To view links or images in signatures your post count must be 15 or greater. You currently have 0 posts.
Anne
  #6  
Old 05-31-2011, 10:12 PM

RE: Savings Tracker and Price Guide Spreadsheet

AmersBee's Avatar
I started my stockpile =)
New Member
 
Join Date: May 2011
Posts: 38
My Mood/Status:
AmersBee has posted more than 10 good deals
Excellent idea. I need to track better. I am scared I won't know what the best deal for something is when I see it. I might think it is the best deal but it might not be. So thanks bunches =)
  #7  
Old 06-01-2011, 06:02 AM

RE: Savings Tracker and Price Guide Spreadsheet

is surfing AFC for the latest deals!
New Member
 
Join Date: Jun 2009
Location: Northeast TN - Southwest VA
Posts: 9
kharlan
This is great, thanks.

I've been playing with this idea for a few weeks now trying to decide how I wanted to organize a spreadsheet and you've done an excellent job!

I've also been saving my sales ads for a few weeks so I can create a spreadsheet of the products we use and track the sales cycles of the different stores, ie: CVS, Riteaid, WAGS, Kroger, etc.

Karen
  #8  
Old 06-01-2011, 11:06 AM

RE: Savings Tracker and Price Guide Spreadsheet

is surfing AFC for the latest deals!
Super Member
 
Join Date: May 2011
Posts: 422
Eboonesews has posted more than 300 great deals!Eboonesews has posted more than 300 great deals!Eboonesews has posted more than 300 great deals!Eboonesews has posted more than 300 great deals!
This is great. I love it.
What is the "Thrown out" column for?
  #9  
Old 06-01-2011, 12:11 PM

RE: Savings Tracker and Price Guide Spreadsheet

vnme99's Avatar
taking a break
Senior Member
 
Join Date: May 2011
Location: Granbury, Texas
Posts: 5,703
My Mood/Status:
vnme99 has posted more than 7000 great deals! WHOA!!vnme99 has posted more than 7000 great deals! WHOA!!vnme99 has posted more than 7000 great deals! WHOA!!vnme99 has posted more than 7000 great deals! WHOA!!vnme99 has posted more than 7000 great deals! WHOA!!vnme99 has posted more than 7000 great deals! WHOA!!vnme99 has posted more than 7000 great deals! WHOA!!vnme99 has posted more than 7000 great deals! WHOA!!vnme99 has posted more than 7000 great deals! WHOA!!vnme99 has posted more than 7000 great deals! WHOA!!vnme99 has posted more than 7000 great deals! WHOA!!
Thank you so much for this! The grocery itemized page is a little confusing to me but I'm sure after I play around with it I'll understand it better! The savings tracker is exactly what I was trying to do but for some reason I just couldn't get it to work for me. Thank you for sharing!

Thanks!!!!!!!
  #10  
Old 06-01-2011, 07:28 PM

RE: Savings Tracker and Price Guide Spreadsheet

is surfing AFC for the latest deals!
Junior Member
 
Join Date: May 2011
Posts: 76
MLM5787 has posted more than 25 good deals
I want to do a price tracker so bad but I dont feel like we consistently buy a specifuc product
  #11  
Old 06-01-2011, 07:43 PM

RE: Savings Tracker and Price Guide Spreadsheet

I
Grounded for Life
 
Join Date: Apr 2009
Location: Alabama
Posts: 115
My Mood/Status:
Blog Entries: 6
tre8jse has posted more than 50 good deals
Thanks for sharing!!! This is a great idea!
  #12  
Old 06-02-2011, 12:15 AM

RE: Savings Tracker and Price Guide Spreadsheet

Slightly overwhelmed with this site
New Member
 
Join Date: May 2011
Posts: 18
dgphelps has posted more than 25 good deals
Thanks all for the words of encouragement.

Sorry I forgot to mention throw out. That's my attempt to keep an eye on foods that spoil or don't get used. There is nothing worse than throwing out meat or produce so this is my attempt to be extra diligent by tracking what I am throwing away in terms of cost.
  #13  
Old 06-02-2011, 08:02 AM

RE: Savings Tracker and Price Guide Spreadsheet

~Em~'s Avatar
Thankful, and oh so blessed!
Looser of Marbles
 
Join Date: Apr 2011
Location: South Florida
Posts: 1,044
My Mood/Status:
~Em~ has posted more than 1500 great deals! WHOA!!~Em~ has posted more than 1500 great deals! WHOA!!~Em~ has posted more than 1500 great deals! WHOA!!~Em~ has posted more than 1500 great deals! WHOA!!~Em~ has posted more than 1500 great deals! WHOA!!~Em~ has posted more than 1500 great deals! WHOA!!~Em~ has posted more than 1500 great deals! WHOA!!~Em~ has posted more than 1500 great deals! WHOA!!~Em~ has posted more than 1500 great deals! WHOA!!~Em~ has posted more than 1500 great deals! WHOA!!~Em~ has posted more than 1500 great deals! WHOA!!
Thanks that is clever! I don't know much about these documents, but going to look into it a bit more
  #14  
Old 06-02-2011, 11:05 AM

RE: Savings Tracker and Price Guide Spreadsheet

is surfing AFC for the latest deals!
New Member
 
Join Date: Apr 2011
Posts: 7
kathyc13357
Thank you! I'll try it!
  #15  
Old 06-02-2011, 11:19 AM

RE: Savings Tracker and Price Guide Spreadsheet

is surfing AFC for the latest deals!
Junior Member
 
Join Date: Jun 2011
Location: Conroe, Texas
Posts: 74
My Mood/Status:
wiser_dude has posted more than 50 good deals
I've thought about doing the same thing except I can never seem to get the register receipt and sit down long enough to do it. I have all of my coupons listed in an Excel spreadsheet and keep track of the expiration dates through it.

I've just begun the learning curve to couponing and am still trying to figure out what how to be effective and efficient while getting the most bang for my buck.

Thank you - SO MUCH - for sharing your spreadsheet with us. Yours is quite a bit more sophisticated than the one I started.
  #16  
Old 06-05-2011, 01:27 AM

RE: Savings Tracker and Price Guide Spreadsheet

is surfing AFC for the latest deals!
New Member
 
Join Date: May 2011
Posts: 2
My Mood/Status:
luv2qpon has posted more than 1 good deal
Thank you sooooo much for this. I've always thought about doing this, but just didn't have a clue in putting it together. So thank you thank you!!
  #17  
Old 06-06-2011, 02:15 AM

RE: Savings Tracker and Price Guide Spreadsheet

is surfing AFC for the latest deals!
New Member
 
Join Date: Jun 2011
Posts: 8
NanaMG has posted more than 1 good deal
I made a copy of the first worksheet and it is going to be immensely helpful, but where is the second worksheet? I am so glad I ran into this forum, you just don't know!!!
  #18  
Old 06-06-2011, 10:05 AM

RE: Savings Tracker and Price Guide Spreadsheet

Slightly overwhelmed with this site
New Member
 
Join Date: May 2011
Posts: 18
dgphelps has posted more than 25 good deals
Hi Nana, you should see two tabs at the bottom which will take you to each sheet. I imagine your copy has both already.
  #19  
Old 06-06-2011, 10:13 AM

RE: Savings Tracker and Price Guide Spreadsheet

is surfing AFC for the latest deals!
New Member
 
Join Date: May 2011
Posts: 14
My Mood/Status:
CKNu2Saving has posted more than 1 good deal
This is awesome! Thanks!
  #20  
Old 06-06-2011, 10:47 AM

RE: Savings Tracker and Price Guide Spreadsheet

is surfing AFC for the latest deals!
New Member
 
Join Date: May 2011
Location: Eastern Ohio
Posts: 25
My Mood/Status:
dzingirl has posted more than 10 good deals
Great ideas - thanks!
  #21  
Old 06-07-2011, 04:17 PM

RE: Savings Tracker and Price Guide Spreadsheet

is surfing AFC for the latest deals!
Junior Member
 
Join Date: Sep 2009
Location: Hopkinsville, Kentucky
Posts: 73
Nnitabugg has posted more than 75 good deals!
WOW...thanks so much. I can see this will be very useful...now, to make myself focus on tracking it.
  #22  
Old 06-08-2011, 01:41 AM

RE: Savings Tracker and Price Guide Spreadsheet

xxdrksideofthemoonxx's Avatar
ello!
Newbie
 
Join Date: May 2011
Location: Saint Louis, MO
Posts: 5
My Mood/Status:
xxdrksideofthemoonxx has posted more than 1 good deal
Thanx a bunch! but one question whats the best way to keep track of what coupons you have and they're expiration dates using a spreadsheet?
__________________
Bad Things Happen When You Party Naked
  #23  
Old 06-08-2011, 01:56 AM

RE: Savings Tracker and Price Guide Spreadsheet

is surfing AFC for the latest deals!
New Member
 
Join Date: Jun 2011
Posts: 7
My Mood/Status:
Secret Shopper
This is great! Thanks for sharing it.
  #24  
Old 06-08-2011, 09:20 AM

RE: Savings Tracker and Price Guide Spreadsheet

is surfing AFC for the latest deals!
Junior Member
 
Join Date: Jun 2011
Location: Conroe, Texas
Posts: 74
My Mood/Status:
wiser_dude has posted more than 50 good deals
Quote:
Originally Posted by xxdrksideofthemoonxx View Post
Thanx a bunch! but one question whats the best way to keep track of what coupons you have and they're expiration dates using a spreadsheet?
Spreadsheets are very flexible. Let me answer the expiration question first.

In order to know which coupons I have that are coming up for expiration, I sort the sheet by the expiration date - oldest date first - which is the ascending option within sort.

To keep track, you must delete coupons that you have redeemed and add new coupons to the sheet. Deleting redeemed coupons isn't a big deal and can be done very easily. Adding coupons is the toughest part. You have to find a way to get them added and that could mean entering them in the sheet by typing. If you use my listing of the new coupons being issued, you first enter (if you want) the number of coupons you have and then copy my spreadsheet and paste it into yours, then save it with the changes.

So, knowing your way around Excel to maintain the spreadsheet is a necessity if you are to utilize a spreadsheet to manage your coupon inventory.

I have the ability to take the raw data from the Sunday coupon review and use the text file to create an Excel spreadsheet with very little work using Excel to automate the process for me. I will continue posting the files as long as I am able - currently, I am unemployed and am using couponing to make my available dollars stretch to the max. If I should find employment, I may still coupon, but may not have time to post in these forums to the extent I am now.

If I have enough people that like the spreadsheet that I am creating and posting, I will stop posting it for free and charge a small sum for my work by emailing it directly to all who subscribe to receive it. I've spent the last twenty years expanding my computer and software knowledge and should be able to use those developed skills to help earn a living while I am unemployed by offseting my time and effort providing the spreadsheet as a time saver for all those here who want to use a spreadsheet, but don't have the level of skill needed to produce the sheet without typing to input it into their spreadsheet.

I hope I've answered your question and haven't rambled on too long about my situation.

I will continue posting the spreadsheet for a couple of weeks for all to use. After that, if it is a time saver for those using it and people are using it to manage their coupons, I'd like to charge a small fee (to be determined - probably not more tha $1.00 per week) to supplement my lack of income while providing a useful service.
__________________
Married to the same woman since March 2, 1971
2005 Goldwing- Looking for a riding partner

Last edited by wiser_dude; 06-08-2011 at 09:23 AM.
The Following 2 Users Say Thank You to wiser_dude For This Useful Post:
  #25  
Old 06-08-2011, 09:35 AM

RE: Savings Tracker and Price Guide Spreadsheet

whatshequilted's Avatar
is surfing AFC for the latest deals!
New Member
 
Join Date: May 2011
Posts: 46
My Mood/Status:
whatshequilted has posted more than 25 good deals
Thanks!!
 

Tags
excel, price guide, savings, spreadsheet, tracker


Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
CVS savings tracker spreadsheet lolobean Deal Graveyard 0 04-23-2008 11:33 AM