What Amazon report should I upload? Where do I find it?

Learn how to customize a report in Amazon Seller Central to upload transaction data to LumaTax.
LI
Written by LumaTax IT
Updated 2 years ago

Amazon reports automatically map to LumaTax for easy upload of transaction history. If your clients sell on Amazon, use the steps below to export data from Amazon to .csv for upload into LumaTax.  

LumaTax works best with both Payments reports and Orders reports from Amazon Seller Central.

The Payments reports are also known as Date Range Reports. Payments reports are preferred because they include refunds, which Orders reports omit. Additionally, the Payments reports include a marketplace facilitator flag, which some Orders reports omit.

Amazon limits users to 365 days per report. You will need to run a report for each year. We recommend running reports for 2017 to present. 

In Amazon Seller Central:

  1. Navigate to the Date Range tab and click Generate Report. 
  2. Select Transaction Report (CSV).
  3. Select a Custom reporting range and select the start and end date for a calendar year 01/01/20XX to 12/31/20XX. 
  4. Click Generate. Reports can take up to 1 hour to generate. If you don't see your report in the list yet, check back later.
  5. Repeat for each year. 

In LumaTax: 

  1. Navigate to the Client Dashboard for this client by selecting them from the drop down in the upper left. 
  2. Go to the card for Data and click the Upload Data button.  Note: You will not be able to upload the data until the client's profile is completed. 
  3. Click Continue. Locate and select the file on your computer. 
  4. The files should automatically map. You will know this was successful if the amazon logo appears at the top of the page after upload. Click Continue
  5. Review the valid and invalid rows and download your validation report. 
  6. When ready, upload additional files or return to the Client Dashboard to run a Nexus Analysis Report. 
Did this answer your question?