How much have you spent on Amazon?

According to Consumer Intelligence Research Partners’ 2017 research[1], as an average Prime member, you spend about $1,300 per year on Amazon. $700 if you’re a non-member customer. Curious what’s your number?

If you’re using Mint or similar service to track all your household expenses it is fairly easy to filter spendings down by a vendor. If you don’t have a way to track all your expenses across all your cards, here’s a way to find your total amount spend on Amazon.

  1. Log in to your Amazon account.
  2. In the Ordering and shopping preferences click on Download order reports

  3. Choose “Orders and shipments” option as the Report Type. Earliest start date as possible (the earliest year is the year you became a customer) and hit Request Report.
  4. After a couple seconds you will see your report ready to be downloaded in Your Reports table below. Let’s Download it and take a look in Excel (if you don’t have Excel just import it into Google Sheets).
  5. Now let’s brush off some of your basic Excel skills, select column U, click Σ Auto Sum and confirm.

  6. Voilà, your Amazon Grand Total number!

Uh oh, looks like we’re a double average Amazon Prime customer with spending $2,627 per year. When I saw the number for the first time I thought it also includes returns, but it doesn’t… Hope your number is better.


  2. Consumer Intelligence Research Partners, LLC (CIRP)

Leave a Reply

Your email address will not be published. Required fields are marked *