This simple trick shows you how much money you’ve wasted shopping on Amazon
Oh god, I’m not sure I want to know this…
Amazon is the place to shop online in the U.S. Depending on who you ask, it either 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 actually 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 Jeff Bezos since opening your account.
Here’s how to know just how much you’ve spent on Amazon
Want to know how much you’ve spent on Amazon since opening your account? What about just this year? You can easily do that.
- 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
- You’ll get a form to fill out here. Add the start date you want (either January 1, 2006, if you want your total Amazon spend, or January 1, 2019, if you only want this year), choose Orders and shipments from the report type drop-down, and click Use today for the end date
- 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. 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.
- 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.