The Spreadsheet I Use to Track My Groceries

In case you would like to track your grocery spending to see exactly how much you save with coupons and sales, here is the one I use. It is very easy to use. Take the full price of each food item before sale and coupon and add that up for the first column "C". That will give you the retail value of the food before your discounts. That way you will know exactly how much food you got for what you paid. Then add up the amount that was taken off for the B1G1 sales (column "D"), regular sales (column "E"), and coupons you used (column "F"). Then add in the tax (column "H") and it will compute what you paid. It should match your receipt if you entered everything correctly. Then in column "J", I type in everything I bought.

http://www.geocities.com/pooh5497/Groceries_blank.xls

If you have any questions, please ask!!!

Before I start typing in items and amounts for the month, I click "save as" and save it for the month (for example grocery_June2009)

You can change the top titles to be the stores that you use, those are just the 3 grocery stores around me. I use the 4th page to enter all the food I buy from target, Walmart, CVS and Walgreen's (and any other store that I may get food at).