Item Summary Report - kwentra Help Center

Audit your stores by item. See opening, received, transferred/consumed, sold and closing quantities and values for any dates.

Audit store quantities and values after stock settlement. Compare opening with closing.
See how receiving, transfers and usage change every item.
Find unsubmitted transactions when Qty and Submitted Qty do not match.
Filter to certain items, stores or categories. No filtering after export.
Review sold quantities, values and revenue for items you sell.

A cost controller runs the report at month end. They compare physical counts with closing quantities per store.
An inventory analyst filters to a few items and compares their receiving and usage over a date range.
A finance manager compares opening and closing values per store to value stock for the period.

Where: Reports → BO → Inventory → Item Summary

Set the parameters. Then choose a file type and run the report:

From date — first day of the report.
To date — last day of the report.
Store — optional, multi-select. Leave it empty to include all stores.
Item family — optional, multi-select. It filters the Item category, Item group and Item lists below it.
Item category — optional, multi-select. It filters Item group and Item.
Item group — optional, multi-select. It filters Item.
Item — optional, multi-select. Leave it empty to include all items that match the filters above. Pick items to show only those items.
Sold — show or hide the Sold columns. Use Show only to audit 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.

Actions: Download, Preview and Print.

Before you run: review and post all journal vouchers. Review and submit all transfers, usages and receiving orders. If not, opening and submitted quantities will not match.

The report is grouped by store, sorted by store serial number from lowest to highest.
Inside each store, items are grouped by item group. Each group has a total row with its quantities and values.
After the last group, a store total shows the value columns (opening and closing).
A Grand Total at the end adds up the value columns for all stores.

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 the store at the start of the date range.	2.00
Opening · Submitted Qty	Submitted opening quantity. It should match Opening Qty. A difference means an unsubmitted receiving order, transfer or usage.	2.00
Opening · Value	Opening value, from the purchase order or receiving order price.	437.71
Received · Qty	Quantity received in the date range.	45.00
Received · Value	Value received, from the receiving order price.	10,125.00
Transferred/Consumed · Qty	Quantity transferred out or used in the date range.	0.00
Transferred/Consumed · Value	Value transferred or used 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 from selling the item.	0.00
Closing · Qty	Quantity left at the end of the date range.	47.00
Closing · Submitted Qty	Submitted closing quantity. It 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 old Item Summary report is removed. The report called Item Summary - Beta is now the standard Item Summary report for all users.