![]() ![]() Jason has over a decade of experience in publishing and has penned thousands of articles during his time at LifeSavvy, Review Geek, How-To Geek, and Lifehacker. Prior to that, he was the Founding Editor of Review Geek. Prior to his current role, Jason spent several years as Editor-in-Chief of LifeSavvy, How-To Geek's sister site focused on tips, tricks, and advice on everything from kitchen gadgets to home improvement. He oversees the day-to-day operations of the site to ensure readers have the most up-to-date information on everything from operating systems to gadgets. Jason Fitzpatrick is the Editor-in-Chief of How-To Geek. Then just skip over your own name and look at everything you've shipped to everyone else. You can sort column T, "Shipping Address Name," to sort all your Amazon shipments by the name of their recipient. You may have to pore over the data and look for purchases made around holidays you celebrate such as family members' birthdays, Christmas, or other gift-giving holidays, to really dial it in.īut if you use Amazon a lot to ship gifts to friends and family around the country, you're in luck. This particular question is a bit tricky to answer because not every gift you purchased on Amazon was necessarily shipped by Amazon to the recipient. If your total purchase history comes to $20,000 and the total refund history comes to $1,600, then the total amount you've actually spent on Amazon is $18,400. Now just subtract the value of the purchase and tax refund from the total value we just created on the "Items" spreadsheet. With the number of the final row, such as J40 Scroll to the bottom and combine column J "Refund Amount" with column K "Refund Tax Amount" using the function ![]() Because the refund report provides the purchase price refund and tax refund in separate columns, we need to combine them. Now, repeat the process by creating a SUM function on the "Refunds" report. The resulting value is the sum of the column and represents the total amount of money you have paid Amazon. Is the value of the last data row, such as AD1209 Scroll to the bottom of the column and create a simple sum function in your spreadsheet application like =SUM(AD2:ADX) Other columns in the spreadsheet, such as column M "Purchase Price Per Unit," show the pre-tax price, and column L, "List Price Per Unit," shows the list price, not the actual price. 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). ![]() 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? If you've ever wondered how much you've spent in total on Amazon, what your most expensive purchase was, how much you spend every year in your flurry of last-minute Amazon-centered Christmas shopping, or anything else that can be quantified and sorted about your Amazon spending habits, you can dig in and find out. We've looked at how to check your first Amazon purchase-my first Amazon purchase, a textbook, was pretty boring-and today, we're going to dig even deeper into your Amazon purchase history to help solve all sorts of curiosities. Related: How to See the First Amazon Purchase You Ever Madeįor the rest of us, though, it's largely a matter of curiosity. In fact, the tools we will use in the how-to portion of the article are intended for business use, but we're borrowing them to root around in our purchase histories. Why Check Your Amazon Purchase History?įor some folks, carefully tracking purchases is part of their business operations. If you're curious exactly how much money you've ever spent on your Amazon account, there's a way to check the total. Most of us have spent quite a bit of money on Amazon over the years, especially during the pandemic. How to See Your Amazon Purchase Totals and More.Why Check Your Amazon Purchase History?.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |