# How to Calculate Your Total Amazon Spending

Head over to Amazon, I have tried this on Amazon.in. I believe it should still work in other countries.

1. Log in and go to your dashboard
    
2. Under your profile section in the right-top corner, click on “Your Account”
    

![](https://substackcdn.com/image/fetch/w_1456,c_limit,f_auto,q_auto:good,fl_progressive:steep/https%3A%2F%2Fsubstack-post-media.s3.amazonaws.com%2Fpublic%2Fimages%2F720af48c-9393-4cc2-96df-a02090d6f2cf_2996x1648.png align="left")

3. Scroll down to the bottom section, under “Manage your data” and click on “Request your data”
    

![](https://substackcdn.com/image/fetch/w_1456,c_limit,f_auto,q_auto:good,fl_progressive:steep/https%3A%2F%2Fsubstack-post-media.s3.amazonaws.com%2Fpublic%2Fimages%2F8a2d08b1-ab60-4cd7-b74e-463c074e09da_2996x1648.png align="left")

4. Under the dropdown, you can see a list of things you can request data for
    
    1. Orders (We are interested in this)
        
    2. Addresses
        
    3. Payment options
        
    4. Subscriptions
        
    5. Search History
        
    6. Alexa and Echo Devices
        
    7. Kindle
        
    8. Fire TB
        
    9. Fire Tablets
        
    10. Advertising
        
    11. Amazon Photos and Drive
        
    12. Apps and More
        
    13. Amazon Music
        
    14. Prime Video
        
    15. Audible
        
    16. Customer Support Communication
        
    17. Request All Your Data (all the data)
        

![](https://substackcdn.com/image/fetch/w_1456,c_limit,f_auto,q_auto:good,fl_progressive:steep/https%3A%2F%2Fsubstack-post-media.s3.amazonaws.com%2Fpublic%2Fimages%2F153ff952-f544-4f57-a22e-d15607d59883_2734x1648.png align="left")

Since we want to calculate the order sum, select “Your Orders”.

5. Once you click submit, you will receive a confirmation email in your registered email.
    

![](https://substackcdn.com/image/fetch/w_1456,c_limit,f_auto,q_auto:good,fl_progressive:steep/https%3A%2F%2Fsubstack-post-media.s3.amazonaws.com%2Fpublic%2Fimages%2Ff01c027f-9b04-4c99-ac9b-4e391038d766_2196x1250.png align="left")

6. In the email, click on “Confirm Data Request”
    
7. They mention that it will take lots of time to receive the data. But, from the past trials, it’s usually in an hour or so.
    
8. When the downloads are ready, you will receive another email.
    
    ![](https://substackcdn.com/image/fetch/w_1456,c_limit,f_auto,q_auto:good,fl_progressive:steep/https%3A%2F%2Fsubstack-post-media.s3.amazonaws.com%2Fpublic%2Fimages%2F22ac8923-2471-4f95-a3e5-a80329656e00_2214x1332.png align="left")
    
9. You can download the data and extract it.
    

![](https://substackcdn.com/image/fetch/w_1456,c_limit,f_auto,q_auto:good,fl_progressive:steep/https%3A%2F%2Fsubstack-post-media.s3.amazonaws.com%2Fpublic%2Fimages%2F51f98715-56db-4934-9c66-0278e73fd0a7_1984x1361.png align="left")

The orders folder should resemble the structure shown above. Interestingly, it includes invoices for all orders, even covering digital goods like eBooks. Our focus, however, is on the “Retail.OrderHistory” folder, which contains the detailed order history.

Upload the CSV file to Google Sheets or open it with Microsoft Excel.

![](https://substackcdn.com/image/fetch/w_2400,c_limit,f_auto,q_auto:good,fl_progressive:steep/https%3A%2F%2Fsubstack-post-media.s3.amazonaws.com%2Fpublic%2Fimages%2Fadb0b9ac-e379-4b26-add2-a09b8f157779_2142x1146.png align="left")

The column of interest here is "Total Owed." By selecting this column, you can view the total sum conveniently displayed at the bottom-right corner.

I hope this was helpful, have fun getting depressed.

---

Thanks for reading The Evilhead! Subscribe for free to receive new similar posts and support my work. I promise to keep it interesting, without spam