Skip to main content
Avalara Help Center

Amazon FBA Inventory Report

Feature

By connecting your Amazon Seller Central account to TrustFile you will have access to reports detailing total FBA sales fulfilled out of each warehouse, total FBA sales volume by state, and first sale date for each state. 

What are the benefits of this feature?

The FBA Inventory Report will give you detailed insight into where your inventory has been throughout Amazon's warehouse infrastructure as well as the sales you have had out of each location. You can use this information to help you determine possible physical and economic Nexus.

How to access this feature?

Once you have connected your Amazon Seller Central account to TrustFile, you will see the following image halfway down on the right hand side of the dashboard.

FBA Waiting.PNG

It takes roughly a week for the reports to generate. Once they are ready you will see the image change and you will be able to run the reports.

FBA Ready.PNG

Upon clicking the Download free Amazon FBA inventory report button, a pop-up will appear asking you how far back you would like to pull the report. You are able to view reports up to the last 18 months. Note: most economic nexus look back periods are 12 months from effective date so it may be helpful to use that 12 month look back as a guide for which Starting Date to select.

FBA Pop-up.PNG

The reports will then be generated for the period selected.

How to read the reports

After clicking Get Reports a new tab will open in your browser with the generated reports. There are three separate reports: Fulfillment & Sales SummarySales to State, and Fulfillment by Center. The first report you see will be the Fulfillment & Sales Summary; you can navigate to the others by clicking the orange buttons under Select the report type.

Fulfillment & Sales Summary

The first report you will see is the Fulfillment & Sales Summary report. 

This report provides information for each state in which an Amazon warehouse is located. It includes when you first had an order fulfilled from that state, when you first sold into that state, and the total gross sales, average monthly gross sales and tax collected into that state for the period you looked up. The states in which you are not collecting tax will be bold to highlight areas you may be non-compliant. You can organize the report by any of the column headers by clicking the arrows on the right side of the column.

FBA Inventory Report_SUMMARY.PNG

Sales to State

The Sales to State report breaks down the gross sales and tax collected into each state by month. From this report you will be able to see trends throughout the year to better understand which months you have higher volumes of sales. If you have states on the cusp of qualifying under economic nexus this report can give you insight into when you can expect to surpass the threshold to prepare yourself to get registered. 

FBA Inventory Report_STATE.PNG

Fulfillment by Center

The final report is the Fulfillment by Center report. This report breaks down your sales from each warehouse location (information exclusive to the TrustFile FBA Inventory Report) to not only assist you in determining where you may have physical nexus liability but also gives you the details of where your product has actually been. The information on this report provides the gross sales, # of orders, and # of items sold from each warehouse every month. The default organization is by date, but you may find it more useful to arrange this by one of the other columns. 

FBA Inventory Report_FC.PNG

Summary

The information provided in the three FBA inventory reports should supply a good starting point to determine where you may have physical and/or economic nexus based on your Amazon FBA sales. 

Tips

  • All reports default to showing 20 entries at a time. For a full view choose Show All from the dropdown on the right side.
  • The reports can be exported to a csv file to be viewed in Excel. If you click Email me the csv a link to download the csv will be emailed to the email on your TrustFile account.
  • If you have questions around tax liability or nexus requirements please reach out to a tax professional. More information on nexus can be found here.

 

  • Was this article helpful?