Stock report templates: ledger, usable stock and count variance
Download our original stock ledger workbook. Reconcile receipts, issues, held stock and count differences using one item, store, unit and cut-off.

Use a stock report to answer a specific factory question: what is physically here, what can production use, and which movement explains the difference? In Optiwise, our item, stores, receipt, issue and transfer records keep those questions connected.
Download the stock ledger and reconciliation worksheet
stock ledger and reconciliation worksheet (Excel workbook) includes a worked example and a separate sheet for your inputs. Blue cells are editable; formula cells calculate the result. Replace the illustrative figures with your factory records.

Keep one item, location, unit and cut-off together
A current-stock report needs an item code, store, unit and reporting time. A stock ledger adds the receipts, issues, transfers and authorised adjustments that explain how the balance changed. Record the source document against each movement. A transfer is an issue from one location and a receipt into another; do not add both sides as new company stock.
The workbook uses one item in Main stores. It starts with 100 pieces, receives 50 and issues 40 to a job, leaving 110 physical pieces. Thirty are held, so 80 are usable. Held quantity is part of the physical total; adding it again would overstate stock.
Investigate the count difference before changing the balance
The worked count finds 108 pieces against the 110-piece ledger balance. The variance is −2. Check the count time, item identity, unit and movements around the cut-off. A late issue entry or stock counted in the wrong location needs its own correction; an unexplained loss should not disappear through an automatic adjustment.
Keep the counted quantity, investigated reason and authorised correction together. Our counting guide explains how to control movements during a count.
Choose the report that leads to the next action
Use current stock and the ledger for the basic balance. Use a low-stock report alongside open purchases and indents when deciding whether to replenish. Use receipt dates for stock age, and movement dates for recent activity; those dates answer different questions.
For dispatch, separate accepted finished goods from reserved and held quantities. For material issues, keep the job reference, quantity and return trail. For reconciliation, compare the same item and location at the same cut-off. A valuation report also needs its stated costing basis; the quantity workbook does not calculate accounting value.
Follow the records in Optiwise
Our live inventory and item drilldowns show stores, low or excess stock, rejected inventory, open POs, pending indents and the movement ledger. Dynamic reports support filters and Excel export. A storekeeper can follow the receipt or issue that changed the balance; purchasing can review the requirement before creating another order.
ERPNext’s stock-ledger documentation provides another example of transaction-based inventory reporting. Use the definitions in your own system consistently when reconciling quantities.
Review the balance behind one shortage
Bring an item, store, held quantity and a recent issue or receipt. We will trace the movement and next stock action. Explore the Optiwise workflow or book a factory walkthrough. We charge ₹0 for implementation. Subscription, optional add-ons and IoT hardware are separate.
Related Posts

Kanban System | Optiwise
Learn how a Kanban system works in manufacturing, where it helps, where it fails, and how Optiwise connects Kanban signals with inventory, purchase, and production planning.
12 Jun 2026Read more →
ERP for Factory Operations: Follow Each Handoff
Follow a manufacturing order through material planning, buying, production, inspection and dispatch, with an owner for each delay or exception.
12 Jun 2026Read more →
ERP for FMCG Companies in India
A practical guide to ERP for FMCG companies in India, covering distributor orders, batch tracking, expiry, inventory, production, schemes, costing, and reporting.
11 Jun 2026Read more →
Optiwise, Odoo, Acumatica and Business Central for Manufacturing
Compare manufacturing workflows in Optiwise, Odoo, Acumatica and Dynamics 365 Business Central. See what your factory can run in Optiwise.
11 Jun 2026Read more →

