# Item Wise Inventory Counting

<p class="doc-lead">Counted stock versus system stock for each item, with the variance highlighted. Use it to review physical count results and act on the differences.</p>

<div class="doc-toc">
<p class="doc-toc-title">On this page</p>
<div class="doc-toc-links">
<a href="#/inventory/reports/item-wise-inventory-counting?id=overview">Overview</a>
<a href="#/inventory/reports/item-wise-inventory-counting?id=use-cases">Use Cases</a>
<a href="#/inventory/reports/item-wise-inventory-counting?id=filters">Filters</a>
<a href="#/inventory/reports/item-wise-inventory-counting?id=columns">Columns</a>
<a href="#/inventory/reports/item-wise-inventory-counting?id=actions">Actions</a>
<a href="#/inventory/reports/item-wise-inventory-counting?id=faq">FAQ</a>
</div>
</div>

<hr class="doc-section-divider">

<h2 id="overview">Overview</h2>

Go to <b>Inventory → Inventory Reports → Item Wise Inventory Counting</b>.

<p><b>What it shows.</b> One row per item with the <b>Counted Quantity</b> recorded during inventory counting, the <b>System Quantity</b> on record, and the <b>Variance</b> between them. Rows with a non-zero variance are highlighted. Select one or more rows to create an <b>Inventory Adjustment</b> directly from the differences. Use the date filter to pick the counting period and the counting-status filter to focus on what is counted, resolved or still pending.</p>

<p><b>When to use it.</b> Use after a stock count to compare physical figures with system stock, to find items that need adjustment, and to track which items are counted and resolved.</p>

<hr class="doc-section-divider">

<h2 id="use-cases">Use Cases</h2>

<ul>
<li><b>Store keeper</b> — Which items differ between the count and the system? Sort attention to the highlighted variance rows.</li>
<li><b>Inventory controller</b> — Which counted items still have an unresolved variance? Set the status filter to <b>Variance and not resolved</b>.</li>
<li><b>Branch manager</b> — How is my center's count progressing? Filter by <b>Center</b> and the <b>Is Counted</b> / <b>Not Counted</b> status.</li>
<li><b>Auditor</b> — Were the differences corrected? Select rows and create an inventory adjustment, or review <b>Is Resolved</b> items.</li>
</ul>

<hr class="doc-section-divider">

<h2 id="filters">Filters</h2>

<b>Date</b> range and a counting-status selector (All, Is Counted, Not Counted, Is Resolved, Not Resolved, Variance and not resolved, Variance and resolved). <b>Advanced Filter</b>: Item, Item Type, Center, Branch, Variant, Brand, Item Group, Employee In charge, Status (Item Status-All, Suspended, Active).

<hr class="doc-section-divider">

<h2 id="columns">Columns</h2>

| **Column** | **Description** |
|------------|-----------------|
| (select) | Checkbox to select the item for a follow-up action. |
| Item Code | Item code. Click to open item enquiry. |
| Item | Item name. Click to open item enquiry. |
| Unit | Inventory keeping unit. |
| Counted Quantity | Quantity recorded during the physical count. |
| System Quantity | Quantity on record in the system. |
| Variance | Difference between counted and system quantity (non-zero rows are highlighted). |

<i>A Total row sums the counted quantity, system quantity and variance.</i>

<hr class="doc-section-divider">

<h2 id="actions">Actions</h2>

<ul>
<li><b>Generate</b> — run the report for the selected filters</li>
<li><b>Create Inventory Adjustment</b> — select rows, then create an adjustment from the variances</li>
<li><b>Show Other Items</b> — switch to the other-items stock view; <b>Hide Zero Quantity</b> hides zero-stock rows there</li>
<li><b>Export All</b> — export the full report to Excel</li>
<li><b>Print</b> — print the report</li>
<li><b>Advanced Filter</b> — open additional filter fields</li>
<li><b>clear</b> — reset active advanced filters</li>
</ul>

<hr class="doc-section-divider">

<h2 id="faq">FAQ</h2>

<p><b>What does Variance mean?</b><br>It is the counted quantity minus the system quantity for the item. A non-zero variance means the physical count and the system stock do not match, and the row is highlighted.</p>

<p><b>How do I correct the differences?</b><br>Select the items with a variance and use <b>Create Inventory Adjustment</b> to post the correction. Choose either all increases or all decreases in one adjustment.</p>

<p><b>Can I see only items that are not yet counted?</b><br>Yes. Set the counting-status selector to <b>Not Counted</b> (or <b>Variance and not resolved</b> for differences still open).</p>

<p><b>How is this different from Item wise Inventory Adjustment?</b><br>This report compares counted stock with system stock and helps you raise corrections. <a href="#/inventory/reports/item-wise-inventory-adjustment">Item wise Inventory Adjustment</a> summarises adjustments that have already been posted.</p>

<p><b>Which counting statuses can I filter?</b><br>On Going, Finished, Closed, Not Counted, and variance-not-resolved options depending on the counting-status selector.</p>

<p><b>Why can't I add an item to a new count from here?</b><br>An item already in another On Going count at the same center is blocked — finish that count first.</p>

<p><b>Why is my report empty?</b><br>No inventory countings match the begin date, center, or counting-status filters.</p>