Amazon expense report

[TrudyCampbell]

I saw on the money matters board that you can go on Amazon and see how many orders you placed in 2012.

I accidentally screwed it up and thought I spent $28,000+ on Amazon last year. Once I recovered from my heart failure, I realized I added up the wrong column.

I had 226 orders :-| :-| :-| :-| :-| :-| :-| :-| :-|

[lolaburns]

Lol! I would have had a coronary!


Sent from my iPad using ProBoards app

[thedahliharpa]

But think how much you saved w/ Amazon Prime.

[charlielove]

Holy crap. That is a lot of orders. Free shipping makes it all too easy to just click away on there.

[neverlosthope]

I didn't have that many orders BUT I spent almost $2k there last year. To be fair though, MOST of that was baby gear, so I guess it makes sense.

[Deleted]

Damn! We had 60 it looks like but pretty much all of them were more than one item.

[fusion]

256 orders . . . dang. I don't even want to add up the actual $$$ amount.

[ruby412]

Wow, I had 104. 228 is crazy!

[sunshineluv]

Ugh, I ran it and spent $1,580 this year, ouch. I love prime though.

[jfh]

Oooh, I need to do this. Amazon's business model is brilliant.

[The Foozzler]

Where can I find this? I feel like mine is probably a lot.

[The Foozzler]

Oh, NM. I found it. I only had 35 orders but many were for multiple items. That is up from 4 orders in 2011.

[eav2c]

Only 55 orders and $2,303.10 spent. I thought it'd be way worse considering that includes when my H ordered his Mac. I bet the year before was a lot worse... I'm tempted to look.

Random fun fact: We bought our sofa off of amazon, lol.

[AndyCohen]

13 orders. I only order on amazon if I can't find something in a store near me.

[devotchka]

HOLY SHIT WE SPENT $3,537.29 at Amazon LAST YEAR!!!

We buy a LOT of stuff online - diapers included... but yikes.

[ruby412]

How do you find out how much you spent? I only see where it says the number of orders.

[TrudyCampbell]

Jan 5, 2013 9:26:06 GMT -5 ruby412 said:

How do you find out how much you spent? I only see where it says the number of orders.

You have to click on the column in excel so that it adds it up for you. Don't feel embarrassed to share your number because I guarantee I have you beat!

[ruby412]

I'm obviously slow because I'm having a hard time figure this out! I went into my account, then my orders and showed all the orders for 2012. That's how I see how many orders I have. But I don't see how to open it in excel or show total spent... still playing around with it.

[TrudyCampbell]

When I'm on my computer ill help you

[ruby412]

Thanks, Trudy! I think I may have figured it out. I ordered the History Report and it's downloading.

[ruby412]

Oh my lord, I must be doing something wrong on this Excel file because that number can't be right!!

[TrudyCampbell]

Jan 5, 2013 10:03:39 GMT -5 ruby412 said:

Oh my lord, I must be doing something wrong on this Excel file because that number can't be right!!

Yea, it's not the last column! Is that what you used? That's what gave me 28000 haha

[ruby412]

No, it is the last column, I think?? But I accidentally included the words Item Subtotal, which H tells me translates to numbers in excel. I re-added it up and it's significantly less but still a lot!

[ruby412]

And in the interest of not Vague-boarding, we spent $12,327.82. But, in my defense it's practically all baby stuff, k-cups, and gifts for others. However, I should probably look at ways to pare that down!

[TrudyCampbell]

Mine was $8000+ so I think you added the wrong column?

[The Foozzler]

I thought mine wasn't so bad but then I realized I was only adding up one of each item when I bought multiple of expensive items like car seat bases. When I multiplied the column of unit price times the quantity my total went way up.

Damn that Sophie for being so expensive.

[thedahliharpa]

Jan 5, 2013 10:18:24 GMT -5 ruby412 said:

And in the interest of not Vague-boarding, we spent $12,327.82. But, in my defense it's practically all baby stuff, k-cups, and gifts for others. However, I should probably look at ways to pare that down!

I find the K-cup part amusing because I am imagining 12k worth of Kcups spilling out of your cupboards.

I'm glad diapers.com doesn't have this feature. It would be scary considering we CD and only buy nighttime diapers and and regular diapers on rare occasions. H thinks you can get everything from diapers.com and that they are some magical box bringing fairy.

[ruby412]

Jan 5, 2013 10:27:44 GMT -5 TrudyCampbell said:

Mine was $8000+ so I think you added the wrong column?

I don't think so. H and I did it together. Highlight last column but not words at the top, hit sigma key, total on bottom bar. The middle column is the price per item but sometimes you order more than one. Our 100ish orders were mostly around $100ish. So it adds up. Try yours again. I think your 8k is a lowball.

[ruby412]

Dahli - it's a total k-cup fest around here! If you're ever on the east coast and need a cup of joe, you can always stop by here!

[The Foozzler]

The last column is your order subtotals, but if you ordered multiple items in one order, the entire order subtotal shows up more than once.

For example, I ordered a car seat base, a sophie, and a taggie in the same order. The last column said $83 three times for that order even though the base was $56, the sophie was $17 and the Taggie was $10.

You want add up the column that gives you the price per unit. If you ordered more than 1 of some items, you first want to multiply that column by the quantity column.

I am an excel nerd.