---
title: How do I see the quantity of an item on a specific date?
description: The Inventory Summary report always shows your current inventory, so it can't be used to look up quantities from a past date.
---

[Skip to content](https://help.sortly.com/how-do-i-see-the-quantity-of-an-item-on-a-specific-date#main-content)

![logo-1](https://help.sortly.com/hs-fs/hubfs/logo-1.png?width=200&height=75&name=logo-1.png)

Open main navigation

Close main navigation

 Looking for answers? Start here.

- There are no suggestions because the search field is empty.

1. [Sortly Help Center](https://help.sortly.com/?hsLang=en)
2. [FAQs](https://help.sortly.com/faqs?hsLang=en)
3. [FAQ](https://help.sortly.com/faqs?hsLang=en#faq)

# How do I see the quantity of an item on a specific date?

Find out how many of an item you had on a specific date, even though the Inventory Summary report only shows your current inventory. Use the Transactions report instead: export it and read the New QTY column to see the quantity on hand at the end of any date range. This article walks you through what the key columns mean, how to export the report, and how to read the quantity for each item.

In this article

1. [Understanding the key columns](https://help.sortly.com/how-do-i-see-the-quantity-of-an-item-on-a-specific-date#key-columns)
2. [Find the quantity on a past date](https://help.sortly.com/how-do-i-see-the-quantity-of-an-item-on-a-specific-date#find-quantity)
3. [Items deleted or with no transactions](https://help.sortly.com/how-do-i-see-the-quantity-of-an-item-on-a-specific-date#delete-note)

### Understanding the key columns

Before you start, it helps to know the difference between two columns in the exported report:

Column

What it means

QTY Change

The amount added or removed in that one transaction. Do not add these up to get a total.

New QTY

The item's quantity after that transaction. On the most recent transaction for each item in your date range, this is the quantity on hand at that point in time.

---

### Find the quantity on a past date

1

Select Reports in the left menu, then select Transactions.

![Transactions highlighted in the Reports list](https://help.sortly.com/hubfs/Knowledge%20Base%20Import/51770335766427.png)

2

Select the date filter at the top right of the report. It starts on This Month. Pick a range, or select Custom, enter the dates under From and To, and select Apply. For example, to see quantities for May, set the range from May 1 to May 31.

![Date filter menu open with ranges from Today to Custom and From and To fields](https://help.sortly.com/hubfs/Knowledge%20Base%20Import/51770340215707.png)

3

Optional: to narrow the results, select Any item or Any folder, or use the search bar. Skip this step to export all items across all folders.

![Search bar with Any item and Any folder filters highlighted](https://help.sortly.com/hubfs/Knowledge%20Base%20Import/51770335773723.png)

4

Select Export. To get an Excel file instead of a CSV, select the Export as .xlsx (Excel) switch. Then select Export in the window. Open the file in Excel or Google Sheets.

![Export window with export settings and fields to export](https://help.sortly.com/hubfs/Knowledge%20Base%20Import/51770340217627.png)

5

In your spreadsheet, sort the Transaction Date column from newest to oldest.

6

For each unique Sortly ID (SID), find the first row after sorting. The New QTY value on that row is the quantity on hand at the end of your selected date range.

✅ Use the New QTY column, not QTY Change. Adding up QTY Change values will not give you the correct total.

![Spreadsheet rows for Brushes showing New QTY by folder](https://help.sortly.com/hubfs/Knowledge%20Base%20Import/51770340218651.png)

#### Example: Brushes at end of May

In the spreadsheet above, the most recent row for each folder gives the ending quantity for Brushes:

Folder

New QTY (ending quantity)

Warehouse 1

22

123 Main Street

3

1800 State Street

3

---

### Items deleted or with no transactions

⚠️ If an item's most recent transaction in your date range is a Delete, its New QTY will show as 0. This means the item was removed from that folder during the period, and 0 is the correct ending quantity for that folder.

⚠️ If an item has no transactions in your date range, its quantity did not change during that period. Expand the date range until a transaction appears, then read the New QTY from that row.

[![Sortly-logo-Red-rgb](https://help.sortly.com/hs-fs/hubfs/Sortly-logo-Red-rgb.png?width=150&height=60&name=Sortly-logo-Red-rgb.png "Sortly-logo-Red-rgb")](https://www.sortly.com/)

<https://www.facebook.com/SortlyApp/> <https://www.instagram.com/sortly_app> <https://www.linkedin.com/company/sortly.com/posts/?feedView=all>

Copyright © 2026, Sortly Inc.