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