Most of us have spent enough money on Amazon over the years, especially during the pandemic. If you’re wondering how much you’ve spent on your Amazon account, there’s a way to check your total.
Why Check Your Amazon Purchase History?
For some people, carefully tracking purchases is part of business operations. In fact, the tools we will use in the how-to section of the article are intended for business use, but we borrow them to root in our purchase histories.
For the rest of us, it’s mostly a matter of curiosity. We’ve looked at how to verify your first Amazon purchase – my first Amazon purchase, the tutorial was pretty boring – and today we’re going to delve deeper into your Amazon purchase history to address any concerns.
If you’ve ever wondered how much you spend on Amazon in total, what your most expensive purchase was, how much you spend each year on last-minute Amazon-centric Christmas shopping, or anything else measurable. and when you sort through your Amazon spending habits, you can dig in and learn.
How to See Your Amazon Purchase Totals and More
We can’t analyze data we don’t have, so the first step is to get your Amazon purchase data in a way that’s easy to sort and analyze. Tracking years of purchases and getting everything in the standard Amazon order history interface won’t cut it.
Claim your Amazon Order Purchase Date
When signed into your Amazon account on a computer (not the app on your phone or tablet), go to the Order History Reports menu.
You can go directly to the menu using this URL. You can do this by clicking on “Accounts & Lists” and then selecting “Accounts” from the drop-down menu.
On the Main Account page, go to “Order & Shopping Options” and click “Download Order Reports”.
Once you have accessed the sub-page called “Order History Reports”, you can use the “Order History Report Request” box at the top of the page to request the reports we need.
We actually need to request several reports to get an accurate look at your Amazon history and allow us to answer questions like how much you’ve spent over the years.
First, you need to request an “Items” report with a start date that matches your first Amazon purchase and ends with the current date. This will generate a report in a Comma Separated Value (.CSV file) table format, showing each purchase and related information.
Second, you need to request additional reports for the “Returns” report type — you can skip requesting the “Rules” report type because the Returns data only shows items that have been physically returned to Amazon, does not include a monetary amount, and does not include data. on items you returned but did not return the product (such as a refund for damaged or lost shipping).
If you have an Amazon account with a long purchase history, be warned that you may have to wait minutes to hours for the request to complete.
In some cases, you may even end up with a failed reporting request. If this happens, we recommend splitting your purchase history. So instead of asking for the Items report from 01/01/1999 to date, pick a point in the middle and run it from 01/01/1999 to 12/31/2011, then 01/01/2012- divide from to now. . You’ll get two reports, but it’s a simple spreadsheet of data that you can merge together.
How to analyze your Amazon purchase history
Once you have the CSV files, just open them in your spreadsheet program of choice and use some basic spreadsheet functions, such as summing and sorting, to extract the data you want. You can use Microsoft Excel, Google Sheets, OpenOffice Calc, or Apple Numbers, or any other spreadsheet program that supports CSV.
With the “Items” table and the “Returns” table loaded, here are some interesting questions you can answer about your Amazon purchase history and how to answer them.
The formatting of these Amazon purchase history tables has remained very consistent with the reports we’ve had over the years using the same formatting conventions. In the instructions below, we’ll be sure to refer to the column letter and title so it will look the same to you, but please adjust the instructions to reflect any changes in column layout.
What was the first thing I bought from Amazon?
To see the first thing you bought on Amazon, you can look at the regular Orders page in your Amazon account. Or, in the Items table, you can sort column A, “Order Date,” using the AZ sort function. The top entry should be the earliest purchase. In my case, it is the tutorial I mentioned at the beginning of the article.
RELATED: How to see the first Amazon purchase you ever made
How many Amazon orders have I placed?
The number of Amazon orders you place on Amazon is equal to one of the total number of rows in the “Products” table (since one row of the table is the headings above). If your spreadsheet is 1295 rows, for example, you played 1294 orders on Amazon.
If you want to know how much you ordered, whether there were returns or refunds for damaged shipments, etc., you can also subtract the same value (number of rows minus one) from your total orders found in the “Returns” table.
How much money have I spent on Amazon?
To find out exactly how much you’ve spent on Amazon over the years, we need to use the SUM function to add up two values: how much you paid Amazon and how much they gave you back.
First, you need to find the AD column, Total Item, in the Items table. This column shows what you actually paid, including tax. Other columns in the table, such as Column M, “Purchase Price per Unit,” shows the pre-tax price, and Column L, “List Price per Unit,” shows the list price, not the actual price.
Scroll down the column and create a simple sum function in your spreadsheet application
=SUM(AD2:ADX) here is the last value
X as is the value of the last data row
AD1209 . The resulting value is the column total and represents the total amount you paid Amazon.
Now repeat the process by creating a SUM function in the Refunds report. Since the refund report presents the purchase price refund and the tax refund in separate columns, we need to combine them. Scroll down and combine column J with ‘Refund Amount’ and column K with ‘Refund Amount of Tax’ using the function.
=SUM(J2:JX, K2:KX) where did you replace it
X with the number of the last row as
Now simply subtract the purchase and tax return value from the total value we created in the Products table. If your total purchase history totals $20,000 and your return history totals $1,600, then the total amount you’ve actually spent on Amazon is $18,400.
What were the gifts?
This question is a bit difficult to answer because not every gift you buy on Amazon is necessarily shipped by Amazon to the recipient.
To actually enter, you may have to sift through the information and look for purchases made around family members’ birthdays, Christmas, or other gift-giving holidays you celebrate.
But if you use Amazon a lot to send gifts to friends and family across the country, you’re in luck. You can sort the “Ship To Address Name” T column to sort all your Amazon shipments by recipient name. Then just go to your name and see everything you’ve sent to others.
What’s the most expensive thing I’ve bought on Amazon?
To find the most expensive thing you’ve bought on Amazon, you can sort by price before or after tax. Before you do that, though, it’s kind of a fun game to guess what the item is. For example, I estimated that the most expensive thing I buy from Amazon is a GPU, high-end monitor, or other equally expensive piece of tech.
After estimating, sort column AD “Total” (for price after tax) or column M “Purchase price per unit” (for price before tax) with the ZA sort function to show the highest value. top of the page.
A GPU and a high-end monitor were actually among my top 10 most expensive purchases, but it turned out that the two best things were an ultralight wheelchair for my father-in-law and a premium saddle-type window air conditioner. air conditioning.
Of all the sorting I’ve done, I have to say that sorting by most expensive purchases has actually been my favorite way to analyze data. When I look at the total money spent and the purchase history in general, I have the question, “What am I doing with my life? I’ve bought a lot of stupid things over the years.”
But among the most expensive things I’ve bought, they’re all either still in use, worn out, or used to retirement. That’s what makes up for my more questionable purchases, like the times I buy rarely used fitness equipment or that weird snow shovel with giant wheels, right?
Hopefully you’re getting the same results, but whatever you find in your Amazon purchase history, at least now you know where to find that information and how to analyze it backwards and forwards.