Easily Export a Report from Amazon on How Much You Bought From Them

Amazon Logo Last month I wrote a post called Arizona Use Tax for Online Purchases pointing out that Arizona has included a line on the tax form for 2011 where we can easily pay our use tax.  Use tax is applied to purchases made out of state (online) for items which will be used or consumed in Arizona, but does not apply to most food items, prescription medicines or items for resale.  Learn more by reading Publication 610, Use Tax.

If you don’t keep track of your purchases all year long, then you’ll find yourself going through your inbox looking for receipts, or visiting the various businesses where you shopped, logging in and going through purchases.  If you, like me, shopped quite a bit at Amazon, I can tell you how to export a report which will make tax time that much easier.  Also, be aware if you bought a lot of items it may take several hours to retrieve your report.  I requested my report around 2pm but it wasn’t available until the next day, and I bought 67 items from Amazon during 2011. UPDATE: I ran this report again today, July 23, 2012 and it was ready within a few minutes.

Follow These Steps:

  1. Log into your Amazon account.
  2. Go to Your Account
  3. Find the ORDER heading, then locate “Download Order Reports
  4. At Report Type, from the drop down menu, select “Orders and Shipments
  5. Choose Start Date and End Date (to the right there are also “Quick Set Options”)
  6. Enter a name for your report (I named mine Amazon Purchases 2011)
  7. Click Request Report

The Orders and Shipments report will contain information regarding how much tax you did or did not pay.

I mentioned earlier, it might take some time to retrieve your report so be prepared to wait.  You can close the browser window and Amazon will send you an email notifying you that your report is ready.

This report will not remain active in your Amazon account so if you wait too long to check back on it you will need to run it again.  The email will have these words in the subject line: Your order history report for 01 Jan 2011 to 31 Dec 2011 is ready.

Amazon provides a link in the email to your account, so just look under the Order heading for Download Order Reports. Your report should have a link to download.

These are the headers contained in the Orders and Shipments report, which comes in Comma Separated Values and can be opened using Microsoft Excel.

Order date
Shipment date
Payment – last 4 digits
Amazon order ID
Purchase order number
Ordering customer’s email
Shipping address name
Shipping address street 1
Shipping address street 2
Shipping address city
Shipping address state
Shipping address zip
Shipment/order condition
Subtotal
Shipping
Tax Before Promotions
Total Promotions
Tax Charged
Total Charged
Carrier Name
Tracking Number

There is another report called Items, and this report contains the following headers. It does not contain tax information.

Order date
Shipment date
Title
Format
Condition
Seller
Quantity
ASIN/ISBN
Primary Contributor
Release Date
Payment – last 4 digits
Per unit price
Amazon order ID
Purchase order number
Ordering customer’s email
Shipping address name
Shipping address street 1
Shipping address street 2
Shipping address city
Shipping address state
Shipping address zip
Shipment/order condition
Carrier Name
Tracking Number
Item subtotal

 

This has been immensely helpful for me in gathering this information from Amazon.  Have you used it and found it helpful?

 

 

OUT OF DEBT AGAIN is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to AMAZON.COM. OUT OF DEBT AGAIN is an affiliate for several companies and may be compensated through advertising and marketing channels. This post may contain affiliate links.

Be Sociable, Share!

Leave a Reply

 

 

 

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

CommentLuv badge

Splyced Hosting