Shoprite: Share Your Shopping Spreadsheet

[donnamcole]

This is in Excel format. It can be used for any store, though the example it is my current week's list for ShopRite. Bold means the order is done, orange is totally free after coupons, bright blue indicates a promo item. Questions... just yell You might have to click on "sheet 1" after opening the link to see the details.

The spreadsheet tallies total before and after Qs per order, promo items before and after Qs, and totals for the week for ALL orders. The last line gives the oop for the week AFTER MIRs... I just add the rebate amounts manually, since I never have more than 1 or 2 for the week, but it has occurred to me that this might be a good place to add lines with rebate info, including address and date mailed. Right now, I track these elsewhere.

http://spreadsheets.google.com/ccc?k...Ic3FmcFE&hl=en

Donna

[neglectarino]

I altered the title slightly so if anyone else has any ideas or spreadsheets that they'd like to share, they can just add them to this thread.

[buddysmom]

Techno dweeb here.
OK, I see alot of blank boxes. I dont expect anyone to explain it - I'm sure its complicated....but it just cracked me up

[donnamcole]

Techno dweeb here.
OK, I see alot of blank boxes. I dont expect anyone to explain it - I'm sure its complicated....but it just cracked me up

Chris,

Click "sheet 1" near the bottom left. You are getting the Excel chart. I have NO idea why that shows up on google docs, because I do not use that page, but it always does. You should be able to see the details if you click "sheet 1"

Donna

[talk2ham.1]

Donna, your spreadsheet is great! I think I'm inspired. I'm using yours as a model.
I noticed you included a spot for tax. Do you know off hand what is taxed and what isn't in NJ? I haven't figured out the pattern. I don't really care at SR. It's CVS that the tax always throws me off.

[donnamcole]

Donna, your spreadsheet is great! I think I'm inspired. I'm using yours as a model.
I noticed you included a spot for tax. Do you know off hand what is taxed and what isn't in NJ? I haven't figured out the pattern. I don't really care at SR. It's CVS that the tax always throws me off.

Glad you like the spreadsheet I do the best I can with it before I shop, price checking with the online shopping thing (though my store doesn't offer this service and sometimes does not have the same prices as the store I choose for price checking), then update it from my receipt after... I bold items purchased and coupons rung... updating it allows me to track actual spending (I rarely toss unplanned items in the cart, but if flank steak is marked down to 3.99 lb, I'll cave!) and doublecheck that they got the prices and coupons correct. A big advantage is being able to search that folder later and KNOW the last time Perdue was 50% or Powerade was .79

I have a general idea on sales tax.. tp and paper towels are NOT taxed, but cleaning supplies and hba products in general (windex, shampoo, deodorant) are... all at the lovely 7% Gov Corswine has decreed (grrrr). Candy (unless it contains FLOUR which means licorice is NOT candy but some granola bars ARE candy), soda and sports drinks like Powerade ARE taxable. Magazines and newspapers are taxable (they were not until the last tax change a few years ago). Prepared foods (made in store sandwiches, deli platters, rotisserie chicken) are taxable. MOST edible food items are not taxable in NJ. Oddly enough, bakery items prepared in the store are NOT taxable.

Most stores do not tax the portion of the product that comes off as a store coupon. Example: Powerade is 79 cents, you have a .75/2 Q and buy 2.. taxable amount equals 83 cents (.79 x 2 = 1.58 - .75 man - .75 store double, but the store's 75 cents is considered a discount off the price and is thus not taxable), so the tax on the 2 bottles of Powerade is .06 cents. I know CVS in my area only taxes on the part you actually pay oop plus the value of any man Qs.

But if you really want THE GOSPEL on NJ sales tax, we need to page WJMorris. He has the NJ sales tax DOWN to where it sort of scares me Where are you, WJ?

Donna

[emm38]

Thanks for sharing the spreadsheet. It looks similar to the one my husband made for me and that I never have time to fill out. :sad:
I have to get my rear end in gear and start it. It really helps to be organized and that is what I strive for.

It's not to hard to make one if you are handy with excel.