Inventory Aging Report

Overview

In this article, you will learn about Sellercloud’s Inventory Aging Report. This report provides an analysis of the estimated age of the inventory in stock based on previous receivings of particular items. The accounting principle used in making these calculations is referred to as FIFO (first-in, first-out), where when an item is sold, the oldest inventory items (earliest purchased items) are considered as sold first.

It is important to note that in this report:

  • Shadow inventory is grouped under the Parent SKU.
  • Inventory in Dropship and Interim Warehouses is excluded from the calculation.

For example, let’s say that Product A has a current quantity of 7 which was received on two different dates:

  1. The most recent receive date was 15 days ago with a received quantity of 5.
  2. The previous receive date was 45 days ago, also with a received quantity of 5.
  3. The report will show that Product A has a quantity of 5 with an inventory age between 0-30 and a quantity of 2 with an age of 30-60
  4. Finally, it will provide an Average Inventory Age based on the calculation of the sum total receiving of the day divided by the quantity in stock. The calculation is (5*15(most recent receive date))+(2*45(earlier receive date))/7 =23.57 

For key points about Sellercloud’s Inventory reports, see the Inventory Value Reports Overview

You can run this report automatically on a regular basis with Scheduled Tasks.
For more information about Sellercloud’s Financial Reporting Suite, see the Reports FAQ.

Access and Customize the Report

To use the report, follow these steps:

  1. Navigate to Reports > Inventory > Inventory Aging Report.
  2. Set up the Default and Custom filters to have the report show precisely what you need.
  3. Click Search. Each filter you apply gets highlighted in a different color. If a filter is gray or not displayed at all, it’s not active.
  4. To manage the columns in the report, click the three dots icon on the top right and select Customize Columns. You can:
    1. Reorder columns by dragging them up or down in the list;
    2. Hide columns by clicking the Trash icons;
    3. Add columns by clicking Add column.
  5. To sort the data differently, use the Sort by menu.
  6. To save your filtering and sorting options, click Save view, type a Name and click Save.
  7. To export the full report to a spreadsheet, click Actions on the bottom right and select Export to Excel. Spreadsheets include all columns, including those hidden in the report.

Filter and Column Definitions

Click the drop-downs below for filter and column descriptions.

Default Filters
FILTERDESCRIPTION
CompanyInclude only products from one or more companies.

Custom Filters
BrandInclude only products from one or more brands.
Calculate Age of Independent Kits based on Kit Assembly DateWhether to calculate the age of independent kits based on their assembly date or not.
Company GroupsInclude only products from one or more company groups.
ManufacturerInclude only products from one or more manufacturers.
Product StatusInclude only active or inactive products.
ProductGroupsInclude only products from one or more product groups.
PurchaserInclude only products assigned to one or more purchasers.
SKUInclude only one or more SKUs.
VendorInclude only products from one or more vendors.
Report Data
COLUMNDESCRIPTION
SKU / Product IDShows the unique SKU code assigned to the product. Shadow products are grouped with the Parent SKU.
Product NameShows the product’s name.
Age: 0-30, 31-60, 61-90, 91-120, 121-180, 180+Shows the number of units in a specific age range.
Average AgeShows the average age of the available product units.
Last SoldShows when the product was last sold.
Last PO / Date of Last PurchaseShows the creation date of the last purchase order including the product.
Last ReceivedShows the date on which a purchase order including the product was last received.
Qty From Last ReceivingShows the number of units received from the last purchase order.
Qty Prior To Last ReceivingShows the number of units available before the last purchase order.
Age Since Last ReceivingShows the number of days passed since the product was last received.
Cost On Last POShows the price of a single product unit in the last purchase order.
Available QtyCorresponds to Available Qty on the product page. If a warehouse is not sellable, you will see 0.
Adjustment QtyShows any positive or negative adjustment amounts to orders.
Inventory CostShows the total cost of the product inventory.
Potential ProfitShows a calculation of the potential profit between sales and the current availability of the product.

(InventoryAvailableQty * SitePrice) – (InventoryAvailableQty * SiteCost)

Profit MarginShows the markup percentage of profit between sales and the current availability of the product.

((InventoryAvailableQty * SitePrice) – (InventoryAvailableQty * SiteCost)) / (InventoryAvailableQty * SitePrice) * 100)

Product MarginShows the markup percentage of profit between the Site Price and costs of the product.

(SitePrice- ProductCostOnLastPO) / SitePrice

Note: Your products must have a Site Price set for this calculation.

Site CostShows the current value in the Product Summary’s Site Cost field.
Site PriceShows the default product price used for website and sales channels.
Average Cost**Average Cost – Shows the cost of units continually averaged. Costs are averaged from the price on the PO at the time the POs are received. Learn more about average cost here.

**Only available when you export the report data to a spreadsheet.


Was this article helpful?

Need Support?
Can't find the answer you're looking for?
Contact Support