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

# Store Usage/Transfers Report

> Track every store transfer and usage by date, store, item, or status — grouped by item group with full request and approval details.

Track every store transfer and usage by date, store, item, or status — grouped by item group with full request and approval details.

### **Business Value**

* Monitor all store transfers and usages within any date range in one report.
* Filter by source store, destination store, expense account, or item.
* Compare requested, approved, and available quantities side by side.
* Track each movement's status and the staff who requested and approved it.

### **Use Cases**

* Inventory controller reviews all transfers between stores for the week to verify stock movements.
* Cost controller filters by expense account to see usages charged to a specific department.
* Store manager checks Draft requests still awaiting approval before month-end close.

### **How It Works**

| **Where:** Back Office → Reports → BO → Store Usage/Transfers |
| ------------------------------------------------------------- |

#### **Running the Report**

**From Date / To Date:** Reporting period — returns transfers and usages with a request date in this range.

**From Store:** (Optional) Filter to movements out of one or more source stores.

**To Store:** (Optional) Filter to transfers into one or more destination stores.

**Expense Account:** (Optional) Filter to usages charged to one or more expense accounts.

**Item:** (Optional) Filter to one or more specific items.

**State:** Filter by document state. Set to **All** to include every state, or pick a specific one (e.g., Draft, Approved).

**Report Type:** Filter by movement type. Set to **All** to include both, or choose **Transfer** or **Usage** only.

**File Type:** Choose the export format — XLS, XLSX, ODS, or PDF.

Available actions: Download  |  Preview  |  Print

#### **Report Layout**

* Results are grouped under an **item group header** (e.g., *BAKERY ITEMS*).
* Each item lists its individual transfer/usage lines, followed by a **Total** row that sums the Requested Qty, Approved Qty, and Available Qty for that item.

#### **Report Columns**

| **Column**       | **Description**                                     | **Example**     |
| ---------------- | --------------------------------------------------- | --------------- |
| Item Number      | System item code for the moved item.                | 140014          |
| Item Description | Name of the item.                                   | BREAD CRAMBS    |
| Type             | Movement type — Transfer or Usage.                  | Transfer        |
| ID               | The transfer or usage document number.              | 808             |
| Request Date     | Date the transfer or usage was requested.           | 2026-05-30      |
| Requested Qty    | Quantity originally requested on the document.      | 9               |
| Approved Qty     | Quantity approved for the movement.                 | 9               |
| Available Qty    | Quantity available in the source store at the time. | 118             |
| Status           | Current document status (e.g., Approved, Draft).    | Approved        |
| Requester        | User who created the transfer/usage request.        | kit\@alkasr     |
| Approver         | User who approved the movement.                     | M.salah\@alkasr |

| Note: A **Total** row appears after each item, summing its Requested Qty, Approved Qty, and Available Qty. Items are grouped by item group. |
| ------------------------------------------------------------------------------------------------------------------------------------------- |

## ***Update: June 10, 2026***

### **Price and Total Columns**

The report now shows the unit price and total cost for every item, giving you full financial visibility into store movements.

### **What's New?**

Two new columns — **Price** and **Total** — are added to the report, placed after the **Approved Qty** column and before the **Available Qty** column.

### **How It Works**

* **Price** shows the unit price of the item in the transfer or usage.
* **Total** shows the total cost (Price × Approved Qty) for the line.
* The **Total** column is summed at both the item level and the item group level.

<img src="https://mintcdn.com/kwentra/NM3ejhm3HxJBcBDx/images/back-office/bo-reports/store-usage-transfers-report/price-and-total-columns.png?fit=max&auto=format&n=NM3ejhm3HxJBcBDx&q=85&s=51d28f8d1ad920da0bcb196f8ade212f" alt="Store Usage/Transfers Report showing the new Price and Total columns after Approved Qty" width="1775" height="345" data-path="images/back-office/bo-reports/store-usage-transfers-report/price-and-total-columns.png" />