> ## Documentation Index
> Fetch the complete documentation index at: https://help.vori.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Compare Purchases and Sales with Item Sell-Through

> Use the Item Sell-Through report to see what you ordered, were invoiced, received, and sold for every product, and what you paid and earned, by department or vendor for any date range.

The **Item Sell-Through** report puts what you bought next to what you sold. For any date range, you can see how much you spent with each vendor, how much each product sold, and how the two compare, by product, vendor, or department.

### Overview video

<video src="https://mintcdn.com/vori/wqO6RXbSDxUZhyJm/images/reporting/item-sell-through-walkthrough.mp4?fit=max&auto=format&n=wqO6RXbSDxUZhyJm&q=85&s=c5716abe3951732a3b427fe7bd5b8b2c" poster="/images/reporting/item-sell-through-walkthrough-poster.webp" controls playsInline style={{ width: "100%", maxWidth: "960px", borderRadius: "8px" }} data-path="images/reporting/item-sell-through-walkthrough.mp4">Walkthrough of the Item Sell-Through report: setting the date range and filters, drilling from store to product, reading the quantity and dollar columns, and tracing a number back to the vendor's original invoice</video>

<Note>
  Item Sell-Through is enabled per store by Vori as part of inventory tracking. If you don't see it in your Back Office yet, contact Vori Support.
</Note>

***

### Open the report

1. Select **Reports** from the main menu, then **[Overview](https://app.vori.com/retail/reporting)**.

2. Select the **Inventory** tab.

3. Select **[Item Sell-Through](https://app.vori.com/retail/reporting/inventory/item-sell-through)**.

***

### Choose the period and filters

* **Date range:** Pick a preset such as **Previous Week (Sun-Sat)**, **Previous Month**, or **Quarter To Date**, or choose **Custom Date Range** to set your own dates.

* **Department:** Select one or more departments. Select **Only** next to a department to show just that one.

* **Vendor:** Search for and select one or more vendors. The report then shows the products you ordered or were invoiced from those vendors during the period, along with all of their sales.

***

### Drill from store to product

The table groups results by **Store ID**, **Parent Department**, **Department**, and **Vendor**. Each product sits under its vendor.

* Select the arrow next to any row to open the level beneath it.

* Select **Expand all** to open every level at once, or **Collapse all** to close them.

* Remove a level with the **×** on its chip in the grouping bar, or drag the chips to change the order.

When you view reports for more than one store, the table starts with one row per store. Every row adds up the products beneath it.

***

### Read the columns

Products counted by the unit fill the **Qty** columns. Products sold by weight fill the **Lb** columns.

| Column | What it shows |
| - | - |
| **PO Qty / PO Lb** | What you ordered on purchase orders submitted during the period. Case quantities are converted to units using the case size. |
| **Invoiced Qty / Invoiced Lb** | What your vendors shipped and billed you on invoices dated during the period. Case quantities are converted to units using the case size. |
| **Received Qty / Received Lb** | How much of those invoices posted to your inventory. |
| **Sold Qty / Sold Lb** | What rang up at the register during the period, net of refunds. |
| **Sell-Through %** | Sold divided by what came in. What came in is Received when an invoice has posted to inventory, otherwise Invoiced, otherwise Ordered. |
| **PO Cost** | The cost of what you ordered. |
| **Invoiced Cost** | What your vendors billed you for those products. |
| **Sold COGS** | The cost of the goods you sold. |
| **Net Sales** | What those sales rang up for, before tax. |

<Tip>
  The dollar columns sit to the right of the quantity columns. Scroll the table sideways to see **Invoiced Cost**, **Sold COGS**, and **Net Sales**.
</Tip>

<Note>
  Received counts what an invoice posted to the inventory ledger, whether or not the invoice is finished.
</Note>

***

### Answer common questions

#### How much did we spend on purchasing?

* Use **Invoiced Cost** for what your vendors billed you, and **PO Cost** for what you ordered.

* Group by **Vendor** to see spend per vendor, or open a department to see spend per product.

#### How much did we sell?

* Use **Sold Qty** or **Sold Lb** for volume and **Net Sales** for dollars, at any level from store down to product.

* For more sales detail, such as margin by product, see [Generate a Report of the Top-Selling Items per Department](/reporting/sales-and-product-performance/generate-a-report-of-the-top-selling-items-per-department).

#### How do sales compare to what we bought?

* Compare **Invoiced** with **Sold** on the same row, in units or pounds.

* Check **Sell-Through %** to spot products that are selling slower than you're buying them.

* Compare **Invoiced Cost** with **Sold COGS** and **Net Sales** to see the same comparison in dollars.

***

### See the invoices and sales behind a number

1. Hover over any row and select the table icon at the end of the row (**View underlying data**).

2. A panel opens with every purchase order, invoice, sale, and refund line behind that row. Each line shows the date, vendor, document number, quantity, and amount.

3. Use the search box in the panel to filter the lines. For example, search **Invoice** to see only invoice lines.

4. To open an invoice, hover over its number in the **Transaction** column and select **Open**. The invoice opens with every line the vendor billed, the product each line maps to, and its cost, retail price, and margin.

5. Select **View Invoice** to see the vendor's original invoice next to those lines.

6. Select **Export to CSV** in the panel to download the lines.

***

### Export or schedule the report

* Select **CSV** above the table to download it.

* Select **Export** in the top-right corner to download the report as a PDF, or choose **Schedule recurring email…** to have it sent to you on a schedule. For details, see [Schedule a Report Export](/reporting/tax-and-financial-reports/how-to-schedule-a-report-export).


## Related topics

- [Track Movement and Inventory Reports](/reporting/inventory-and-purchase-reports/track-movement-and-inventory-reports.md)
- [Generate a Report of the Top-Selling Items per Department](/reporting/sales-and-product-performance/generate-a-report-of-the-top-selling-items-per-department.md)
- [Sell, Redeem, and Top Up Gift Cards on the POS](/point-of-sale-pos/vori-store-gift-cards/sell-redeem-and-top-up-gift-cards-on-the-pos.md)
