Back to Home

Track aging inventory with Square for Retail

Who is this article for?
This article is for business owners and their team members making purchasing decisions, price adjustments, by tracking and identifying slow-moving or dead stock from their Square Dashboard. Learn more about Square Staff and custom permissions.

Before you begin

This feature is only available with a subscription to Square for Retail Plus. If you don’t have a subscription, you can sign up for a free 30 day trial.

About aging inventory

The Square for Retail Inventory Sell-through Report provides you with an organized daily snapshot of all of the information you need to effectively manage your inventory — making purchasing decisions, price adjustments, and identifying any dead stock easier.

The aging inventory report shows:

  • Average age of inventory: This metric represents the weighted average number of days items and variations have been in stock. A higher average age indicates that a larger portion of your inventory has been sitting in your store for an extended period.

  • Turn rate: This measures how many days it takes to sell through your inventory on hand. It's calculated by dividing an item's total sales over the last 12 months by the current quantity of stock on hand. Note that turn rate can only be calculated for items present in your catalog for more than 12 months.

  • Last Received Date: Indicates when each item and variation was last received.

  • Age Segmentation: Displays the quantity of items in stock within the last 30, 60, 90, 120 days, and beyond.

  • Total On-Hand Stock Quantity and Inventory Value: Provides insights into the total quantity and value of items currently in stock. You can also search by name, SKU, or GTIN and filter by location, category, and vendors.

To address aging inventory, consider implementing strategies like discounts, targeted marketing efforts, bundling with other products, or even donation. While these actions may lead to a temporary dip in profitability, they effectively clear out space in your store for faster-selling and more profitable items.

Track aging inventory

To generate your aging inventory report:

  1. From your Square Dashboard, click Reports.

  2. Click Inventory Reports and select Aging inventory.

  3. Click Export to generate a complete report of your aging inventory.

Related articles