#AMAZON MY HISTORY ORDERS HOW TO#

To get an accurate look at how much you have spent on Amazon over the years, we need to use the SUM function to add up two values: how much you've paid out to Amazon and how much they've refunded you.įirst, in the 'Items' spreadsheet, you need to locate column AD, 'Item Total.' This column indicates what you actually paid with the tax included. If you want to know how many orders you have placed, sans returns and refunds for damaged shipments and such, you can also subtract the same value (number of lines minus one) found in the 'Refunds' spreadsheet from your total orders. If your spreadsheet is 1,295 lines, for example, you have played 1,294 orders on Amazon. The number of Amazon orders you have placed on Amazon is the total number of lines in the 'Items' spreadsheet minus one (because one row of the spreadsheet is the headers at the top).

#AMAZON MY HISTORY ORDERS HOW TO#

Related: How to See the First Amazon Purchase You Ever Made In my case, it's the textbook I mentioned at the start of the article.

The top entry should be the earliest purchase. Or, in the Items spreadsheet, you can sort column A, 'Order Date' using the A-Z sort function. You can look in the regular Orders page on your Amazon account to see the first thing you ever purchased on Amazon. What Was the First Thing I Purchased on Amazon? In the following instructions, we'll be referencing the column letter and title with confidence it will look the same for you, but please adjust the instructions to reflect any changes to the column arrangement.

The formatting of these Amazon purchase history spreadsheets has stayed very consistent over time, with reports we've pulled at points over the years using the same formatting conventions. With the 'Items' spreadsheet and the 'Refunds' spreadsheet loaded, here are some interesting questions you can answer about your Amazon purchase history and how to answer them.

Amazon my history orders