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

# Item Summary Report

> Audit your stores by item — opening, received, transferred/consumed, sold, and closing quantities and values for any date range, now with an Item filter.

Audit your stores by item — see opening, received, transferred/consumed, sold, and closing quantities and values over any date range.

### **Business Value**

* Audit store quantities and values after settlement, comparing opening against closing.
* Track the full effect of receiving, transfers, and usage on every item.
* Surface unsubmitted transactions when Qty and Submitted Qty don't match.
* Filter to specific items, stores, or categories — no post-export filtering needed.
* Review sold quantities, values, and revenue for profit-generating items.

### **Use Cases**

* Cost controller runs the report at month end to reconcile physical counts against system closing quantities per store.
* Inventory analyst filters to a few specific items to compare their receiving and consumption over a date range.
* Finance manager reviews opening versus closing values per store to value inventory for the period.

### **How It Works**

#### **Running the Report**

| **Where:** Reports → BO → Inventory → Item Summary |
| -------------------------------------------------- |

Set the parameters, then choose a file type and run the report:

* **From date** — Start of the reporting period.
* **To date** — End of the reporting period.
* **Store** — Optional, multi-select. Leave empty to include all stores.
* **Item family** — Optional, multi-select. Filters the Item category, Item group, and Item options below it.
* **Item category** — Optional, multi-select. Filters Item group and Item.
* **Item group** — Optional, multi-select. Filters Item.
* **Item** — Optional, multi-select. Leave empty to include all items that match the filters above; select one or more to restrict the report to those items only.
* **Sold** — Show or hide the Sold column group. Use Show only when auditing profit-generating items sold from your outlets.
* **Detail level** — Group the output by Item Family, Item Category, Item Group, or Item.
* **File type** — XLS, XLSX, ODS, or PDF.

Available actions: **Download**, **Preview**, and **Print**.

| **Before you run:** make sure all Journal Vouchers are reviewed and posted, and all transfers, usages, and receiving orders are reviewed and submitted — otherwise opening and submitted quantities will not match. |
| ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |

#### **Report Layout & Grouping**

The report is grouped by store, sorted ascending by store serial number. Within each store, items are grouped by item group, with a total per group showing the group's quantities and values. After all groups in a store are listed, a store total is shown for the value columns (opening versus closing). A **Grand Total** at the end sums the value columns across every store in the report.

#### **Report Columns**

| Column                       | Description                                                                                                                   | Example         |
| ---------------------------- | ----------------------------------------------------------------------------------------------------------------------------- | --------------- |
| Item Number                  | The item's serial number.                                                                                                     | 161005          |
| Item Description             | The name of the item.                                                                                                         | HOT DOG HALWENY |
| Unit                         | The store unit the item is tracked in.                                                                                        | K.G             |
| Opening · Qty                | Quantity in store at the start of the date range.                                                                             | 2.00            |
| Opening · Submitted Qty      | Submitted opening quantity; should match Opening Qty — a difference means an unsubmitted receiving order, transfer, or usage. | 2.00            |
| Opening · Value              | Opening value, based on the purchasing-cycle price (purchase order / receiving order).                                        | 437.71          |
| Received · Qty               | Quantity received during the date range.                                                                                      | 45.00           |
| Received · Value             | Value received, based on the receiving order price.                                                                           | 10,125.00       |
| Transferred/Consumed · Qty   | Quantity transferred out or consumed during the date range.                                                                   | 0.00            |
| Transferred/Consumed · Value | Value transferred or consumed from the store.                                                                                 | 0.00            |
| Sold · Qty                   | Quantity sold (only when Sold = Show).                                                                                        | 0.00            |
| Sold · Value                 | Value of the quantities sold.                                                                                                 | 0.00            |
| Sold · Revenue               | Revenue generated from selling the item.                                                                                      | 0.00            |
| Closing · Qty                | Quantity available at the end of the date range.                                                                              | 47.00           |
| Closing · Submitted Qty      | Submitted closing quantity; should equal Closing Qty.                                                                         | 47.00           |
| Closing · Value              | Total value of the item in the store at the end of the date range.                                                            | 10,562.71       |

| The previous **Item Summary** report has been removed. The report previously labelled **Item Summary - Beta** is now the standard **Item Summary** report for all users. |
| ------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |