Connect with us
hellotech banner ad

Amazon

This simple trick shows how much money you’ve wasted at Amazon

Oh god, I’m not sure I want to know this…

amazon delivery boxes stacked on a porch
Image: Joe Rice-Jones / KnowTechie

Amazon is the place to shop online in the U.S. Depending on who you ask; it takes up over 50% of online sales or closer to 40% if you adjust for those things only sold by Amazon.com.

Millions of Prime members bolster that total, with each spending an average of over $1,400 per year.

Do you have Amazon Prime? Do you know how much you spend per year? How about since you opened your account? No?

Well, you’re not alone in that, but there’s a simple way to find just how much of your hard-earned cash you’ve thrown at Amazon since opening your account.

How to see how much money you spent on Amazon

Want to know how much you’ve spent on Amazon since opening your account? What do you think about just this year? You can easily do that, besides counting the stacks of Amazon boxes. Here’s how.

  • Go to Amazon.com and sign in to your account
  • Click on Account & Lists in the top-right hand corner
Image: KnowTechie
  • Then scroll down to the Ordering and shopping preferences section and click on Download order reports
Image: KnowTechie
  • Then scroll down to the Ordering and shopping preferences section and click on Download order reports
amazon spending habits
Image: KnowTechie
  • Now click on Request Report and wait for it to generate and start downloading
  • Open up either Google Sheets or Excel, start a new spreadsheet, then import the CSV file that Amazon created. In Google Sheets, it’s File > Import > Upload > Select file > Import data
  • Now all your orders should show up in the spreadsheet.
  • Click on the Item Total column, then go to the Format menu, click on Number and then Automatic.
  • You’ll now get the total sum of your orders in the bottom right corner of your Sheet. Are you scared yet?

There you go. One (possibly) huge number showing just how easy it is to overspend when you have that sweet, sweet, fast, Prime shipping guarantee.

Did you check out your totals spent on Amazon? Were you surprised by the total amount? Let us know down below in the comments or carry the discussion over to our Twitter or Facebook.

Editors’ Recommendations:

Just a heads up, if you buy something through our links, we may get a small share of the sale. Click here for more.

Follow us on Flipboard, Google News, or Apple News

Maker, meme-r, and unabashed geek with nearly half a decade of blogging experience at KnowTechie, SlashGear and XDA Developers. If it runs on electricity (or even if it doesn't), Joe probably has one around his office somewhere, with particular focus in gadgetry and handheld gaming. Shoot him an email at joe@knowtechie.com.

Click to comment

Leave a Reply

Your email address will not be published. Required fields are marked *

More in Amazon

mcafeee banner ad