Item Summary Report - Kwentra Help Center

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.

​Business Value

​Use Cases

​How It Works

​Running the Report

​Report Layout & Grouping

​Report Columns