Run an aging inventory report

Who is this article for?

Account owners or team members with the reports permission to view inventory reports. Set permissions in Square Dashboard.

Square for Retail Plus and Premium subscribers

Square Plus and Premium subscribers with advanced inventory capabilities added. Add capabilities in Square Dashboard.

About an aging inventory report

The 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 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.

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.