Sunday, February 28, 2016

Amazing Amazon: How to See How Much You Have Spent on Amazon.com

We love Amazon. It makes our lives so much easier. We joined officially in 2005, and, in 2008, we set up our Subscribe and Save account for diapers.

Can I tell you how easy and wonderful it is to have diapers delivered to your door monthly?  Life.Saver. Seriously.  No more dashes to the store, no more worries, no more unexpected expenses as you forgot to budget for it.

We use Subscribe and Save for more than just diapers and wipes. It is great for those routine things that you know you will need such as vitamins, air filters, toilet paper, fish food, dish detergent, rinse aid, bulk organic lollipops, and more.

We have these lollipops set for delivery every six months.


But Amazon is more than just Subscribe and Save. We use it for clothing.  Need a skirt to complete your daughter's American Heritage Girl uniform? Check! And I even ordered that while bathing our three year old!  Need a vacuum ASAP because you accidentally ripped the electrical cord out of yours? Check!  Need a really good reflective dog collar because your dog lost hers in the woods (again!)? Check!  Need some wall hanging guitar mounts, a magazine rack, something to organize your aprons, badminton birdies/shuttlecocks that are out of season, masa harina to make corn tortillas? ... You get the idea

We obviously use Amazon a lot.  We would prefer to buy local when possible, but our current phase of life with several small children is just not conducive to making lots of trips to the store.  Imagine comparing brands of a product you are new to like active charcoal and nutritional yeast while your baby becomes fussy and your three older children begin to run out of patience.  With Amazon, we can compare prices and reviews and buy with one-click.

When I heard there is a way to see how much you have spent with Amazon, I jumped right on it to see how much we have spent.  While the total number we have spent there seemed mind blowing, it broke down to about $136 per month since 2005.  When you buy a couple of cases of diapers and a case of baby wipes each month with a few other items, you reach that amount pretty quickly.

Here's how to download your report:
  1. Sign in.
  2. Go to "Your Account."
  3. Select "Download Order Reports" under "Orders."
  4. Enter a start date of January 1 for the earliest year in the drop down box.
  5. Enter an end date of today's date.
  6. Select "Request Report."
When your report is through generating, you can download it from the same page under "Your Reports."  The report will open in a spreadsheet. Sum column "AD" (Item Total) to see how much you have spent.  To add these numbers, click an empty cell, enter =SUM(, highlight all of the cells in column AD except the header cell of "Item Total", enter ), and press enter. That is how much you have spent.

We took it a step further and added the "List Price Per Unit" column in another cell. Then we subtracted the "Item Total" from the "List Price Per Unit."  We "saved" over $6,000 in the past 11 years, not to mention the gas, time, and stress we saved.



No comments:

Post a Comment