# 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, and each row carries a checkbox for selection. Turn on <b>Show Other Items</b> to switch to a second view listing uncounted stock — items not covered by the count — with their current <b>Stock</b>. 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? Set the status filter to <b>Is Resolved</b> to review the closed variances.</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>

<p>When <b>Show Other Items</b> is on, the report switches to the uncounted-stock view with these columns:</p>

| **Column** | **Description** |
|------------|-----------------|
| (select) | Checkbox to select the item. |
| Item Code | Item code. Click to open item enquiry. |
| Item | Item name. Click to open item enquiry. |
| Unit | Inventory keeping unit. |
| Stock | Current stock on record for the item. |

<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>Show All / Hide Zero Quantity</b> — show every item or hide rows with zero quantity</li>
<li><b>More</b> — toggle Show Other Items / Hide Other Items to switch between the counting view and the uncounted-stock view</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>
<li><b>Selection action bar</b> — tick one or more rows to reveal a follow-up action: in the counting view, <b>Create Inventory Adjustment</b> to correct the selected items; in the <b>Show Other Items</b> view, <b>Create Inventory Counting</b> to add the selected items to a count</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 act on the differences?</b><br>Tick the items with a variance and use <b>Create Inventory Adjustment</b> from the action bar to post the correction so system stock matches the count. You can also open <a href="#/inventory/reports/item-wise-inventory-adjustment">Inventory Adjustment</a> directly.</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>All, Is Counted, Not Counted, Is Resolved, Not Resolved, Variance and not resolved, and Variance and resolved.</p>

<p><b>What is the Show Other Items view?</b><br>Turn on <b>Show Other Items</b> from the <b>More</b> menu to list stock for items not covered by the count, with a <b>Stock</b> column. Use <b>Hide Zero Quantity</b> to leave out zero-stock rows.</p>

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