How to See How Much Money You’ve Spent on Amazon


(*2*)
Hadrian/Shutterstock.com(*20*)

Maximum folks have spent relatively somewhat of cash on Amazon through the years, particularly throughout the pandemic. For those who’re curious precisely what quantity of money you’ve ever spent for your Amazon account, there’s a option to take a look at the whole.

(*18*)Why Test Your Amazon Acquire Historical past?

For some other folks, sparsely monitoring purchases is a part of their trade operations. Actually, the gear we will be able to use within the how-to portion of the thing are supposed for trade use, however we’re borrowing them to root round in our acquire histories.

For the remainder of us, despite the fact that, it’s in large part an issue of interest. We’ve checked out methods to take a look at your first Amazon acquire—my first Amazon acquire, a textbook, was once beautiful dull—and as of late, we’re going to dig even deeper into your Amazon acquire historical past to assist remedy all forms of curiosities.

For those who’ve ever questioned how a lot you’ve spent in overall on Amazon, what your costliest acquire was once, how a lot you spend once a year for your flurry of last-minute Amazon-centered Christmas buying groceries, or anything that may be quantified and looked after about your Amazon spending behavior, you’ll be able to dig in and to find out.

(*18*)Methods to See Your Amazon Acquire Totals and Extra

We will’t analyze information we don’t have, so step one is to get your palms for your Amazon acquire information in some way this is simple to kind and analyze. Paging thru years of purchases in the usual Amazon order historical past interface and hand totaling issues isn’t going to chop it.

Request Your Amazon Order Acquire Historical past

Whilst logged into your Amazon account on a pc (no longer the app for your telephone or pill), navigate to the Order Historical past Reviews menu.

You’ll leap without delay to the menu via the use of this URL. You’ll achieve this via clicking on “Accounts & Lists” after which deciding on “Accounts” from the drop-down menu.

At the major Account web page, scroll all the way down to the “Order and Buying groceries Personal tastes” phase and click on on “Obtain Order Reviews.”

As soon as you might be within the ensuing sub-page, “Order Historical past Reviews,” you’ll be able to use the “Request Order Historical past Record” field on the most sensible of the web page to request the reviews we want.

To get a correct have a look at your Amazon historical past and provides us the facility to reply to questions like how a lot you’ve spent through the years, we if truth be told want to request more than one reviews.

First, you wish to have to request an “Pieces” file with a get started date that corresponds along with your first Amazon acquire and ends with the present date. This will likely generate a file, in a Comma Separated Worth (.CSV report) spreadsheet layout, appearing each and every unmarried acquire and the related information.

2nd, you wish to have to request further reviews for file sort “Refunds”—you’ll be able to skip asking for the “Returns” file sort as a result of Returns information most effective displays pieces bodily returned to Amazon, doesn’t come with the financial quantity, and doesn’t come with information on pieces for which you won money back however didn’t go back an merchandise (comparable to getting money back for a broken or misplaced cargo).

In case you have an Amazon account with long acquire historical past, be forewarned that you’ll have to attend any place from mins to hours for the request to finish.

In some circumstances, chances are you’ll even finally end up with a failed file request. If that occurs, we propose splitting up your acquire historical past dates. So as a substitute of asking for an Pieces file that spans 01/01/1999 to the current, select a place within the heart and damage it up like 01/01/1999 to 12/31/2022 after which 01/01/2022 to the current. You’ll obtain two reviews, but it surely’s simply easy spreadsheet information you’ll be able to merge in combination.

Methods to Analyze Your Amazon Acquire Historical past

(*1*)
“Ya’ll aren’t gonna imagine how a lot I’ve spent on LEGO Famous person Wars.” Andrey_Popov/Shutterstock.com(*20*)

After you have the CSV information, it’s simply an issue of opening them for your most popular spreadsheet application and the use of some elementary spreadsheet purposes like summing and sorting to tug out the knowledge you wish to have. You’ll use Microsoft Excel, Google Sheets, OpenOffice Calc, or Apple Numbers, or some other spreadsheet application that helps CSV

With the “Pieces” spreadsheet and the “Refunds” spreadsheet loaded, listed here are some attention-grabbing questions you’ll be able to solution about your Amazon acquire historical past and the way to reply to them.

The formatting of those Amazon acquire historical past spreadsheets has stayed very constant over the years, with reviews we’ve pulled at issues through the years the use of the similar formatting conventions. Within the following directions, we’ll be referencing the column letter and identify with self assurance it’ll glance the similar for you, however please alter the directions to mirror any adjustments to the column association.

What Used to be the First Factor I Bought on Amazon?

You’ll glance within the (*12*)common Orders web page for your Amazon account to peer the very first thing you ever bought on Amazon. Or, within the Pieces spreadsheet, you’ll be able to kind column A, “Order Date” the use of the A-Z kind serve as. The highest access will have to be the earliest acquire. In my case, it’s the textbook I discussed initially of the thing.

RELATED: Methods to See the First Amazon Acquire You Ever Made

How Many Amazon Orders Have I Positioned?

The choice of Amazon orders you may have put on Amazon is the whole choice of strains within the “Pieces” spreadsheet minus one (as a result of one row of the spreadsheet is the headers on the most sensible). In case your spreadsheet is 1,295 strains, as an example, you may have performed 1,294 orders on Amazon.

If you wish to know the way many orders you may have positioned, sans returns and refunds for broken shipments and such, you’ll be able to additionally subtract the similar worth (choice of strains minus one) discovered within the “Refunds” spreadsheet out of your overall orders.

How A lot Have I Spent on Amazon?

To get a correct have a look at how a lot you may have spent on Amazon through the years, we want to use the SUM serve as so as to add up two values: how a lot you’ve paid out to Amazon and what kind of they’ve refunded you.

First, within the “Pieces” spreadsheet, you wish to have to find column AD, “Merchandise Overall.” This column signifies what you if truth be told paid with the tax incorporated. Different columns within the spreadsheet, comparable to column M “Acquire Worth In line with Unit,” display the pre-tax value, and column L, “Checklist Worth In line with Unit,” displays the record value, no longer the real value.

Scroll to the ground of the column and create a easy sum serve as for your spreadsheet application like =SUM(AD2:ADX) the place the general worth X is the price of the final information row, comparable to AD1209 . The ensuing worth is the sum of the column and represents the whole amount of cash you may have paid Amazon.

Now, repeat the method via making a SUM serve as at the “Refunds” file. Since the refund file supplies the acquisition value refund and tax refund in separate columns, we want to mix them. Scroll to the ground and mix column J “Refund Quantity” with column Okay “Refund Tax Quantity” the use of the serve as =SUM(J2:JX, K2:KX) the place you may have changed the X with the choice of the general row, comparable to J40 and K40 .

Now simply subtract the price of the acquisition and tax refund from the whole worth we simply created at the “Pieces” spreadsheet. In case your overall acquire historical past involves $20,000 and the whole refund historical past involves $1,600, then the whole quantity you’ve if truth be told spent on Amazon is $18,400.

What Pieces Had been Items?

This actual query is somewhat tough to reply to as a result of no longer each and every reward you bought on Amazon was once essentially shipped via Amazon to the recipient.

You could have to pore over the knowledge and search for purchases made round vacations you have a good time comparable to members of the family’ birthdays, Christmas, or different gift-giving vacations, to actually dial it in.

However if you happen to use Amazon so much to send items to family and friends across the nation, you’re in good fortune. You’ll kind column T, “Delivery Cope with Identify,” to kind your entire Amazon shipments via the identify in their recipient. Then simply skip over your personal identify and have a look at the whole lot you’ve shipped to everybody else.

What Is the Maximum Dear Factor I’ve Purchased Off Amazon?

To search out the costliest factor you’ve bought on Amazon, you’ll be able to select to kind via the pre-tax or post-tax value. Sooner than you achieve this, despite the fact that, it’s roughly a amusing recreation to check out and wager what you suppose the object is. I, as an example, guessed that certainly the costliest factor I’ve ever purchased off Amazon was once a GPU, a high-end observe, or any other similarly pricey little bit of tech package.

Whenever you’ve taken a wager, merely kind column AD “Merchandise Overall” (for post-tax value) or column M “Acquire Worth In line with Unit” (for pre-tax value) with the Z-A type serve as to show the absolute best worth on the most sensible of the web page.

A GPU and a high-end observe had been, in reality, amongst my most sensible 10 costliest purchases, but it surely seems the highest two issues had been an ultra-lightweight wheelchair for my better half’s father and a top class saddle-style window air conditioner.

Of the entire sorting I did, I’ve to mention that sorting via the costliest purchases if truth be told ended up being my favourite approach of inspecting the knowledge. Once I seemed on the overall cash spent and skimmed over the acquisition historical past typically, I used to be left with a way of “What am I doing with my existence? I’ve purchased a large number of dumb issues through the years.”

However some of the costliest issues I’ve bought, they’re all both nonetheless in use or had been used till they wore out or had been retired. Which I assume makes up for my extra doubtful purchases like seldom used health equipment or that point I purchased (*10*)that odd snow shovel with the enormous wheel, proper?

Expectantly, you achieve the similar conclusions, however no matter nuggets you to find for your Amazon acquire historical past, no less than now you already know the place to seek out this data and methods to analyze it backward and forwards.