Store Closing Report - kwentra Help Center

See the quantity and value of each item in each store on a selected date.

Report Business Value

See what is in each store on any date.
See the money value of each store’s stock.
Run it after store settlement to check the final quantities and values.

Use Cases

A cost controller runs the report after store settlement to confirm closing stock.
A store keeper checks the quantity of certain items in one store.
A finance manager uses the grand total to value stock at month end.

How It Works

Where: Reports → BO → Inventory → Store Closing

Running the Report

Select the date.
Optional: select one or more stores. Leave it empty to include all stores.
Optional: select certain items. Leave it empty to include all items in the selected stores.
Choose the file type: XLS, XLSX, ODS or PDF.

Report Layout

Items are grouped by store, sorted by store serial number from lowest to highest.
Inside each store, items are grouped by item group, such as Vegetables or Canned Goods.
Each item group ends with the total value of its items.
Each store has a total of all its item groups. It shows the store’s value on the report date.
A Grand Total at the end adds up all groups and stores.

Report Columns

Column	Description
Item	The item and its serial number, under its item group and store.
Unit	The item’s store unit, such as KG, Packet or Each.
Price	The item’s price from its last purchase order or receiving order.
Qty	Quantity available on the report date.
Value	Price × Qty.

Note: The report uses your system’s base currency.