Amazon is a force to be reckoned with these days from their venture into the fashion retailer space to innovative methods of shipping via… well, drones. For those of us that shop heavily at Amazon, the convenience this e-tailer provides when it comes to streamlined shopping, delivery and customer service is second to none. From the multitude of advantages that Amazon Prime membership offers and the millions of products available online, you’ll be surprised to see how much you’ve REALLY spent on Amazon.
Let that thought settle in for a bit. How long have you been on Amazon? You’re probably thinking, “I picked up a few items here and there, can’t be that much…” well, you’d be dead wrong.
A DealsPlus member ran the lifetime total he spent on Amazon since 2006, and guess how much he’s spent so far? $18,000.
To uncover your current lifetime expenses from Amazon, did you know that you can download a spreadsheet for full details on your order totals through the years? You can also filter the time range you’d like to see and use a few simple steps below to rack up the total numbers.
Log in to your account at Amazon.com.
Open up this page on Amazon.
Spot the Orders section at the top of the page and click on Download Order Reports.
For Report Type, set to Items.
For Start Date, set to January 1st for the oldest available year (this is likely the year you signed up for Amazon).
For End Date, click on Use Today beside the input box.
Hit the Request Report button and your “.CSV” file should download automatically.
Open the saved file on your PC or laptop with either Microsoft Excel or Google Sheets (free to use for all gmail users!).
Locate the Item Total cell and scroll all the way down the document. At the bottom of the Item Total cell column, type in =SUM(X1:X1000) and hit enter. Remember to replace “X1” and “X1000” with the actual name for that cell column (located at top of document) and input the real range numbers.
For example, if you only have 70 transactions with Amazon, and your cell column for Transactions or Item Total is “AD”, your formula at the bottom would be =SUM(AD1:AD70).
Tweet: How to Calculate How Much You've Spent on Amazon Over Your Entire Life http://ctt.ec/J10fr+
Well, did you guess right? What’s your real total amount spent at Amazon so far? Surprised? We sure are. Tell us about your results in the comments!
Don't be discouraged by these numbers though. These are results from years of purchasing on Amazon! Plus, it just shows what a trusted e-tailer they are if you're willing to spend and rely on Amazon time and time again for the majority of your necessities. If you're trying to cut costs and save where you can, give the Amazon coupon page a quick scan to see what coupon codes and promotional offers are currently available from Amazon.