Let's connect

Blog

Want to know how much you’ve spent at Amazon.com since you opened your account?

August 1, 2016 / in How To / by

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.

The Data

Amazon LogoUsing 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

  1. Download Order ReportsLog into your Amazon.com account.
  2. 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.)
  3. You will end up at a Request Order History Report form.
  4. 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.)
  5. 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.
  6. For End Date, click the Use Today link and today’s date will be used for the end date.
  7. 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.

  1. 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.
  2. 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.)
  3. Once the file is downloaded, open it in your favorite spreadsheet application like Excel or Google Sheets.
  4. 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.

In Closing

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!

  1. Fun post! Not sure I want to know how much I’ve spent (especially since I often buy things for work) but I plan to justify it by reminding myself that a portion of all my purchases goes to support my favorite charity. Maybe a post on smile.amazon.com might be in order for those needing the same justification??? Thanks, Jason!

  2. Worked like a champ. Couldn’t go back to 2004 when I began, only went to 2006. It was interesting to see how my purchases increased every year. With almost $20k in purchases I have no complaints with Amazon but have had two real heated arguments via email with two sellers. Amazon backed me all the way and I received my refunds. Thanks a lot for the info.

Comments are closed.

Get our blog posts

Direct to your mailbox

Ready to tell your story? (913) 944-4980

Let's connect
© 2024 Blue Gurus. All rights reserved.