Stock ledger report
Audience: Finance teams, inventory managers, and auditors who need a transaction-level audit trail of every stock-changing event.
The stock ledger report provides a transaction-level view of all stock movements in your organization. Every event that changes inventory — purchases, deliveries, transfers, checkouts, conversions, adjustments, audits, returns, and bundles — appears as a line item in the ledger, giving you a complete audit trail of how stock levels changed over time.
This report is part of the modern reporting framework and uses the advanced grid view with full sorting, filtering, column resizing, and aggregation support.
Navigation: Reports > Inventory > Stock Ledger.
Before you begin
- You must have the appropriate report permission to access this report.
Permission: Stock Ledger Report under the Inventory report permissions group — required to access the Stock Ledger report.
Run the report
- Navigate to Reports. The Reports Dashboard is the landing page.
- In the Inventory section, select Stock Ledger.
- The report opens in the V2 grid interface.
Filters
Configure the following filters to narrow the report data:
| Filter | Description |
|---|---|
| Centers | Select one or more centers to include. |
| Date range | The time period for transactions. |
| Categories | Filter by product category. |
| Brands | Filter by product brand. |
| Product types | Retail, consumable, or all. |
| Vendors | Filter by vendor. |
| Subcategories | Filter by product subcategory. |
| Business units | Filter by business unit. |
| Transaction types | Filter by specific transaction types (PO delivery, transfer, checkout, adjustment, audit, conversion, bundle, return, etc.). |
| Products | Search for specific products. |
| Costing method | Select Perpetual Average Cost or FIFO (the two values of the StockCostingMethods enum). The cost columns recalculate based on the selected method. |
| Search | Free-text search across product name and code. |
| Group column | Group results by a selected dimension (center, category, vendor, etc.). |
Report columns
The stock ledger report contains 34 columns covering transaction details, quantities, and values. The default columns, in order, are:
| Column | Description |
|---|---|
| Transaction Date | The date when the stock movement occurred. |
| Center Code | The short code identifying the center. |
| Center Name | The name of the center where the transaction occurred. |
| Product Code | The product's unique code. |
| Product Name | The product involved in the transaction. |
| Product Category | The product's category. |
| Product Type | Whether the product is "Retail" or "Consumable". |
| Brand | The product brand name. |
| Initial Stock | The stock quantity before this transaction was applied. |
| Initial Cost | The total stock cost before this transaction. |
| Transaction Type | The type of transaction (PO Delivery, Transfer In, Transfer Out, Checkout, Adjustment, Audit, Conversion, Bundle, Unbundle, Return, Opening Stock). |
| Description | A short description of the transaction. |
| Stock-In | The quantity of stock added by this transaction (for PO deliveries, transfer in, adjustments adding stock, etc.). |
| Stock-Out | The quantity of stock removed by this transaction (for checkouts, transfer out, adjustments removing stock, etc.). |
| Transaction Cost | The monetary value of this transaction, based on the selected costing method. |
| Balance Quantity | The running stock quantity after this transaction. |
| Balance Stock Cost | The running stock cost after this transaction. |
Additional columns
Beyond the default columns above, the report also includes these columns (visible via column show/hide):
| Column | Description |
|---|---|
| Unit Cost | The cost per unit at the time of the transaction. |
| Total Value | The total value of the transaction (quantity multiplied by unit cost). |
| Vendor | The vendor associated with the transaction (for PO-related entries). |
| Batch Number | The batch or lot number (for batch-tracked products). |
| Reference Number | The PO, TO, or adjustment reference number. |
| User | The user who performed the transaction. |
| Sub-Category | The product's sub-category. |
| Business Unit | The business unit the product belongs to. |
| Transfer Center | For transfer orders, the source or destination center name. |
| Service Name | For consumption transactions, the service during which the product was used. |
| Bundle Code | For bundle/unbundle transactions, the bundle product code. |
| Conversion Code | For conversion transactions, the conversion reference code. |
| Checkout Code | For checkout transactions, the checkout reference code. |
| Invoice No | The invoice number for the transaction. |
| Purchase Price | The configured purchase price for the product. |
| Perpetual Average Cost | The running weighted average cost per unit at the time of the transaction. |
| Action Quantity | The absolute quantity changed (always positive). |
| Product Vendor | The vendor mapped to the product. |
Transaction types reference
The stock ledger tracks 23 distinct transaction types:
| # | Transaction Type | Direction | Description |
|---|---|---|---|
| 1 | Sale | Outflow | Product sold to a guest at the point of sale. |
| 2 | Refund and Restock | Inflow | Product returned by a guest and added back to stock. |
| 3 | Service Consumption | Outflow | Product consumed automatically during a service appointment. |
| 4 | Checkout for Consumption | Outflow | Product manually checked out for internal use. |
| 5 | Added from Audit | Inflow | Stock quantity increased as a result of audit reconciliation. |
| 6 | Decreased from Audit | Outflow | Stock quantity decreased as a result of audit reconciliation. |
| 7 | Stock In from Purchase Order | Inflow | Stock received from a vendor via PO delivery. |
| 8 | Stock Out from Purchase Order | Outflow | Stock deducted due to a PO correction or reversal. |
| 9 | Stock In from PO Return | Inflow | Stock returned to inventory from a cancelled vendor return. |
| 10 | Stock Out from PO Return | Outflow | Stock sent back to vendor via a return PO. |
| 11 | Stock In from Transfer Order | Inflow | Stock received at a center from a transfer order delivery. |
| 12 | Stock Out from Transfer Order | Outflow | Stock dispatched from a center via a transfer order. |
| 13 | Stock In from TO Return | Inflow | Stock returned from a transfer order return (inbound). |
| 14 | Stock Out from TO Return | Outflow | Stock sent back via a transfer order return (outbound). |
| 15 | Stock In from Bundling | Inflow | Bundle (kit) product added to stock after assembly. |
| 16 | Stock In from Unbundling | Inflow | Component products added to stock after disassembly. |
| 17 | Stock Out from Bundling | Outflow | Component products deducted from stock during assembly. |
| 18 | Stock Out from Unbundling | Outflow | Bundle product deducted from stock during disassembly. |
| 19 | Stock In from Conversion | Inflow | Stock added to the target type (retail or consumable) during conversion. |
| 20 | Stock Out from Conversion | Outflow | Stock deducted from the source type during conversion. |
| 21 | Added from Adjustment | Inflow | Stock quantity increased via a manual adjustment. |
| 22 | Decreased from Adjustment | Outflow | Stock quantity decreased via a manual adjustment. |
| 23 | Stock In from Cross-Center Retail Refund | Inflow | Stock restocked at a different center than where the original sale occurred. |
Grouping
You can group the report by one of the following dimensions:
- Center — group transactions by center.
- Category — group by product category.
- Sub-Category — group by product sub-category.
- Brand — group by product brand.
- Vendor — group by vendor association.
Grouping displays subtotals per group and allows expanding or collapsing group rows.
Report features
This report supports the standard V2 grid features (sort, filter, resize, reorder columns; pagination; column show/hide; flat-file CSV export). Numeric columns aggregate to sum totals in the footer. For framework-wide grid behaviors, see Inventory reports — Access V2 reports.
Worked example
A center receives a PO delivery, then makes a sale, then performs an audit. The ledger shows:
| Date | Transaction Type | Inflow | Outflow | Balance |
|---|---|---|---|---|
| Day 1 | Opening Stock | 100 | 0 | 100 |
| Day 2 | Stock In from Purchase Order | 50 | 0 | 150 |
| Day 3 | Sale | 0 | 3 | 147 |
| Day 4 | Decreased from Audit | 0 | 2 | 145 |
The running Balance Qty represents the on-hand quantity after each transaction, computed per product per center, sorted by Transaction Date. Back-dated transactions (allowed for audits with the AUDIT_BACK_DATE permission) cause the running balance to recompute for affected dates.
Video: Stock Ledger Report (1:26) — Overview of the Stock Ledger report.