Loading…
Loading…
A reference for running an accurate physical count in ERPNext — freeze the window, count by warehouse, and true up quantity and valuation with a Stock Reconciliation.
32 checks · 6 sections
A stock take is only trustworthy if the system stops moving while you count and the true-up is posted the right way. This is a reference guide to how a physical count or cycle count actually works in ERPNext — the doctypes, reports and accounts involved — not a tick-box tracker. Use it to plan a full annual count or a rolling A/B/C cycle count, count warehouse by warehouse, and post variances through a Stock Reconciliation so both quantity and valuation land correctly in the Stock Ledger. Every step below names the real ERPNext screen you will use.
Choose full count vs cycle count + 4 more
Run the Stock Balance report + 4 more
Count one warehouse at a time + 4 more
Create a Stock Reconciliation with Purpose 'Stock Reconciliation' + 5 more
Reconcile serial/batch items via the Serial and Batch Bundle + 4 more
Investigate every material variance + 5 more
All 32 checks across 6 sections as a clean branded Excel — each item with the guidance for why it matters, ready to share with your team. Free, no email required.
Use a Stock Reconciliation with Purpose set to 'Stock Reconciliation'. You enter the counted quantity and valuation rate per Item and Warehouse; ERPNext compares them to the current figures, posts the quantity and value differences to the Stock Ledger, and books the value gap to your chosen Difference Account.
Yes. Because Stock Reconciliation posts against a specific cut-off date and time, you should pause Delivery Notes, Purchase Receipts and Stock Entries for the warehouses being counted, and enable 'Edit Posting Date and Time' so the correction is booked at your true cut-off rather than when you save.
On the Stock Reconciliation row, serial and batch items are handled through a Serial and Batch Bundle instead of a plain quantity. Use 'Add Serial / Batch No' to record the exact serial numbers or batch numbers and quantities you counted, and reconcile them against the current bundle so missing or extra units are corrected explicitly.
Rank items A/B/C by value and movement, then count A items most frequently, B items less often and C items least. Rolling cycle counts, each closed out with a small Stock Reconciliation, keep Bin balances accurate without freezing the entire warehouse for a full annual count.
Get a clear plan, an honest timeline, and a fixed scope. Talk to a real expert today — whether or not you work with us.
Kochi (Kadavanthra & Infopark) · Thiruvananthapuram · across India & overseas · In business since 2011