Run an aging inventory report
About aging inventory
The Square for Retail Aging Inventory Report is a crucial tool that provides valuable insights into inventory movement speed. If offers key stock age data, including:
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.
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 donations. 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.
Before you begin
You can view your aging inventory report from Square Dashboard.
Before you can track aging inventory, you need to set up inventory tracking. Learn how to View, receive and adjust inventory and adjust inventory levels.
Track aging inventory
To generate your aging inventory report:
Sign in to Square Dashboard and go to Reports > Inventory > Aging inventory.
Click Export to generate a complete report of your aging inventory.