Want to know how much you’ve spent at Amazon.com since you opened your account?
August 1, 2016 /
in How To /
by Jason Terry
Hi friends! It’s Jason again with this week’s story. And if you shop on Amazon.com a lot, you are going to love this… or maybe not if you suffer from retail therapy.
Did you know that you can run a report in your Amazon.com account to see how much you’ve spent over time? You can go all the way back to when you opened your account. So basically, you can see exactly how much you’ve spent at Amazon.com since you opened your account.
Using the instructions below, I determined the total amount I’ve spent at Amazon.com since I opened my account in 2006. I was really curious!
I was a bit shocked at the total. I love Amazon.com and have a Prime membership. I use it a lot… and the number I saw proved it.
My first order was placed in January 2006 for a whopping total of $20.99. It was a Logitech cordless mouse and keyboard that normally cost $49.95 and was on sale for $14.50. There were no Prime memberships yet, so I had to pay $6.49 for shipping. The good news was that this was before tax was charged online if there was no brick and mortar store in your state, so there was no tax.
My biggest order was in December 2014 for $2,500. Sadly, there was $201.16 worth of tax this time. But a whole bunch of heavy stuff shipped to my house for free with my Amazon Prime membership!
Determining the total amount of your Amazon.com orders
Step One: Generate a report of all the orders you’ve ever made
- Log into your Amazon.com account.
- Click the Your Account link towards the top right of the screen. It will take you to a page with all your account settings. There is a major section named Orders. In that area, under Order History, there’s a Download Order Reports link. Click that link. (Check out the image to the right.)
- You will end up at a Request Order History Report form.
- In the Report Type dropdown, choose Orders and Shipments. (This is important… I didn’t do this the first time and the report failed, so just make sure to make sure the report type is Orders and Shipments.)
- For Start Date, specify January 1st and use the Year dropdown to specify the oldest year possible… this is the year that you opened your account.
- For End Date, click the Use Today link and today’s date will be used for the end date.
- Click the Request Report button.
At this point, Amazon will start generating your report for you. If you’ve had your Amazon account for years, it might take a minute before your report is available.
Step Two: Use Excel or Google Sheets to total the order amount column.
- Once your report is ready, there will be a link that you can click to download your report. The Download link will be to the right under Actions.
- Click on that link and you’ll be able to download the .CSV file to your computer. (Be sure to keep track of where you save it.)
- Once the file is downloaded, open it in your favorite spreadsheet application like Excel or Google Sheets.
- There is a column titled Total Charged that is almost the last column to the right. (It’s the third from the right.) You need to sum this column… in Excel, go to the bottom of the data, select an empty cell under the Total Charged column and click the AutoSum button in the toolbar to sum the entire column. Click enter to apply the formula to the cell, and you’ll see the total amount you’ve spent on Amazon.com since you opened your account.
If you’ve ever wondered how much you’ve spent with Amazon.com, I hope you found this article helpful! Please let me know if you used this info to see for yourself how much you’ve spent!