Inventory Aging Report

Overview

In this article, you will learn about Sellercloud’s Inventory Aging Report. This report is mainly helpful for checking the age of your inventory. However, you also get additional information about product quantities, costs and pricing, and historical data about sales and purchases.

You can see information about:

  • Products SKU and product names.
  • Inventory age specific ages: 0-30, 31-60, 61-90, 91-120, 121-180, 180+; average age and age since the last receiving.
  • Costs and pricing – cost on last purchase order, inventory cost, site cost, site price, product margin, potential profit, and profit margin.
  • Inventory quantity – last received quantity, quantity before the last receiving, and adjustment quantity.
  • Historical data last sold, last purchase order, and last received.
For key information about inventory value reports, see the Inventory Value Reports Overview.
For answers to general questions 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
FILTER DESCRIPTION
Company Include only products from one or more companies.

Custom Filters
Brand Include only products from one or more brands.
Calculate Age of Independent Kits based on Kit Assembly Date Whether to calculate the age of independent kits based on their assembly date or not.
Company Groups Include only products from one or more company groups.
Manufacturer Include only products from one or more manufacturers.
Product Status Include only active or inactive products.
ProductGroups Include only products from one or more product groups.
Purchaser Include only products assigned to one or more purchasers.
SKU Include only one or more SKUs.
Vendor Include only products from one or more vendors.
Report Data
COLUMN DESCRIPTION
SKU / Product ID Shows the unique SKU code assigned to the product.
Product Name Shows 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 Age Shows the average age of the available product units.
Last Sold Shows when the product was last sold.
Last PO / Date of Last Purchase Shows the creation date of the last purchase order including the product.
Last Received Shows the date on which a purchase order including the product was last received.
Qty From Last Receiving Shows the number of units received from the last purchase order.
Qty Prior To Last Receiving Shows the number of units available before the last purchase order.
Age Since Last Receiving Shows the number of days passed since the product was last received.
Cost On Last PO Shows the price of a single product unit in the last purchase order.
Available Qty Corresponds to Available Qty on the product page. If a warehouse is not sellable, you will see 0.
Adjustment Qty Shows any positive or negative adjustment amounts to orders.
Inventory Cost Shows the total cost of the product inventory.
Potential Profit Shows a calculation of the potential profit between sales and the current availability of the product.

(InventoryAvailableQty * SitePrice) – (InventoryAvailableQty * SiteCost)

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

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

Product Margin Shows 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 Cost Shows the current value in the Product Summary’s Site Cost field.
Site Price Shows 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?

Related Articles