Inventory Reports – Month & Year End

There are at least 3 Amazon Reports you can run to get your inventory count at FBA. I have done mock up reports below. Each one has its uses.

1 Reports – Fulfillment – Amazon Fulfilled Inventory – simplest report for cost of goods (COG)
2 Reports – Fulfillment – Manage FBA Inventory  – includes selling (list) price, inbound, reserved, etc.
3 Reports – Fulfillment – Daily (or Monthly) Inventory History –  run year-end inventory at any time of the year, but may not be available for up to 10 days after the month’s end.

1. Reports – Fulfillment – Amazon Fulfilled Inventory

Pros

  • Simple report, only 6 columns, combines total of 1 SKU from different warehouses
  • Can run at any time to find out your COG, i.e. how much money is invested in inventory
  • Start a habit of downloading 1st of each month to get the total of unsold inventory
  • Insert a column with your COG (easiest when you’ve included the cost in your SKU and can type it or use a formula to extract it into a new column), and multiply by the quantity column

Cons

  • Is time sensitive and lists inventory at that moment in time – doesn’t have a date range selection
  • Lists ALL inventory since beginning of time, even items you’ve deleted but not yet purged
  • No prices, but Amazon has the sellable price, not the price you paid for them (cost of goods)
  • Uses Seller’s MSKU to identify product, no description , disadvantage if you don’t create MSKU

Notes

  • Download the report on 1st of New Year for year-end inventory as close to midnight your time 12/31
  • It does list ALL inventory, so “data” sort quantity column “largest to smallest” and delete all the zeros
  • This is a good report to see what Amazon has on record that you are selling, and you may want to purge inventory you no longer sell, in case an item becomes a problem in the future
  • Add any inventory that is in transit to FBA, or that is stored at home or in own warehouse

Data sorted by Column F, with header, largest to smallest, delete rows with zeros:

Insert a column to add your COG and Total. If you put your cost in the SKU you can easily find it.  To multiply 2 columns go to the cell you want the end result in, for example F2 and type =sum(D2)*(E2)

Since I always put an X at the end of my SKU’s someone helped me create a formula to extract it.

… Assuming consistency of format – always an “X” at the end and price is always 4 digits, I can use the formula: =LEFT(RIGHT(A1,5),4)/100

2. Reports – Fulfillment – Manage FBA Inventory

Pros

  • Lists inventory for sale on Amazon, FBA and Merchant Fulfilled (if listed)
  • 16 columns – Lists inbound and unfulfillable inventory too
  • Includes List* price of inventory – great if want to know value if all sold
  • Add column to put in price you bought it at
  • Combines total inventory from different warehouses
  • Includes product description – great if you haven’t created a legible MSKU

Cons

  • Is time sensitive and lists inventory at that moment in time – doesn’t have a date range selection
  • If you are running a sale on any inventory it doesn’t change the price in this report, it only gives the list price

*List price is the price you have established for it. Not the MRSP (manufacturer’s recommended sales price) and not the price if you are running a Sale. You will need to adjust the column to the Sale price if you want an accurate amount that would come in if you sold it all at the current prices. This applies to Amazon’s reports and software program reports (Inventory Lab, etc.)

Notes

  • Add any inventory that is stored at home/warehouse and isn’t available for sale yet

 

 3. Reports – Fulfillment – Daily (or Monthly) Inventory History

Pros

  • Accessible for year-end inventory ANY TIME of year because you can select a date range
  • Can go back years to retrieve your year-end inventory
  • Shows the different warehouses (FC = Fulfillment Centers) that your inventory is stored in
  • Can run report at any time to calculate your COG. Add column to put in price you bought it at
  • Includes product description – great if you haven’t created a legible MSKU
  • Report also good to see warehouse damaged, customer damaged, as well as sellable inventory

Cons

  • Lists inventory by warehouse(s) so takes some manipulating to group same items together
  • Allow a few days after the end of the month or year you want the report on. Until it is ready it will say ‘no data available’. It has been known to take as little as 6 days, as long as 12 days.
  • No prices are given
  • Does include inactive listings too that haven’t been deleted yet

Here’s how to get your (year-end) inventory count at any time of the year.

Daily Inventory History Report

or you can do the Monthly Inventory History Report for the whole month

There’s a column with the end quantity of the date range covered, so as of 12/31/15 at 11:59 PM

.

As a side note, these reports record your inventory checked into Amazon’s warehouse.

Inbound inventory that’s not checked in can be found on Reports – Fulfillment – Manage FBA Inventory, or on your Manage FBA Inventory page.

Did you enjoy this article?
Signup today and receive free updates straight in your inbox. We will never share or sell your email address.
I agree to have my personal information transfered to MailChimp ( more information )

About the author: Karen Holmes

Leave a Reply

Your email address will not be published.