My sister has gotten into the whole Extreme Couponing that seems to have swept the US because of some show they are watching. I'm not able to see the show, and here in the UK they do not offer manufacturing coupons. I do ask my sister and other friends and family to send me their expired coupons because they are good at the commissary here. So far I am able to save enough to pay for the gas to drive the two hours to the commissary, but I can't seem to figure out how to save 80% on my groceries like others have.
Although I cannot participate in this extreme couponing going on in the states, I thought I would create a way to say thank you to all those who have been sending me coupons. I worked with my sister to come up with some requirements that couponers look for in a spreadsheet.
The first sheet of the spreadsheet is a summary of all the categories which tells you how many items you are buying and what your subtotal will be in each category as well as a grand total. I suggest you make a file for each grocery store you intend to shop at.
Next I have created a sheet/tab for each category of shopping you would want, according to my sister. Now if you download the file feel free to change the category titles at the top of the page, but do not mess with the name of the sheets/tabs because it will mess up the summary page formulas.
Each category lets you input the Aisle, Product Name, Original/Sales Price, Manufacturing coupons, Store coupons, then it goes into the price per item,number of coupons and sales tax. At the top of each page there is a sales tax rate in the top left hand corner. You must fill that out in order to get the formulas to work out properly. I have three options for sales tax though: 1 - No Tax, 2 - Food Sales Tax, and 3 Non-Food Item Sales Tax. I did that because some states have sales tax on food, which is typically lower than sales tax on non-food items. The most important thing is not to delete the gray fields because they have the formulas in them. Ok there are lots of forumlas in the totals and summary pages, but I just highlighted to columns that have formulas.
Now if you want this document you have a few options. Since Blogger doesn't really host file downloads, I uploaded this into my Google Docs. From there you can either use the template and save it into your Google Docs, or you can download it and save it to your computer. Google Docs allows you to save it in multiple formats. I have included a pic of how to save the document to your computer from the Google Docs link.
Note: I have received a few comments on how the original template did not calculate the sales tax properly. I have recently updated the spreadsheet which you can find at:
Coupon Spreadsheet v2
I have kept link to download the original here: Coupon Spreadsheet Template