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

Just a heads up, if you buy something through our links, we may get a small share of the sale. It’s one of the ways we keep the lights on here. Click here for more.

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

• Then scroll down to the Ordering and shopping preferences section and click on Download order reports

• Then scroll down to the Ordering and shopping preferences section and click on Download order reports

• 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:

• A fully-loaded Mac Pro costs more than a Tesla Model 3
• Amazon is reportedly launching cashierless supermarkets and pop-up stores in 2020
• MacOS Catalina broke a bunch of Adobe products – here are the best alternatives to check out
• Tech Hangover: Apple’s new Mac Pro is very, very expensive

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

Joe Rice-Jones

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.