Stock Counts
Physical inventory counting and reconciliation
Stock Counts
Verify actual inventory through physical counting.
Count Types
Full Physical Count
Count all inventory:
- Typically annual
- May require operations pause
- Most comprehensive
Cycle Counting
Count portions regularly:
- Ongoing throughout year
- No operations pause needed
- Based on schedule or triggers
Spot Count
Count specific items:
- Triggered by discrepancy
- Random audit
- High-value verification
Count Workflow
Status Definitions
| Status | Description |
|---|---|
| Planned | Scheduled, not started |
| In Progress | Counting active |
| Pending Review | Submitted for approval |
| Approved | Complete, adjustments made |
Creating Stock Counts
Step 1: Plan Count
- Go to ERP > Stock > Stock Counts
- Click New Stock Count
- Configure:
- Stock site
- Count type
- Products/categories to include
- Scheduled date
Step 2: Generate Count Sheet
- Click Generate Count Sheet
- System creates list of items
- Optional: Hide expected quantities
Step 3: Perform Count
- Assign counters
- Physically count items
- Enter counted quantities
- Note any issues
Counted quantities are saved to the server automatically as you type, so progress is durable and visible to everyone with access to the count — not just on the device that did the counting. Any user with the Update Count permission can submit a count for review; this no longer requires a tenant admin.
Step 4: Review Results
- Compare counted vs expected
- Review discrepancies
- Investigate significant variances
- Document findings
Step 5: Approve and Adjust
When a count is submitted for approval, all tenant administrators receive an in-app notification linking directly to the count, so an approver knows to review it without having to poll the overview.
- Approve count results
- System creates adjustments
- Inventory updated
Count Methods
Blind Counting
Counter doesn't see expected quantity:
- Reduces bias
- More accurate
- Recommended for audits
Assisted Counting
Counter sees expected quantity:
- Faster execution
- Confirm-and-adjust approach
- Good for verification
Barcode Counting
Scan items during count:
- Very accurate
- Faster for many items
- Requires equipment
Cycle Counting Strategies
ABC Analysis
Count by value/velocity:
| Class | Frequency | Criteria |
|---|---|---|
| A | Weekly/Monthly | High value, high velocity |
| B | Monthly/Quarterly | Medium value/velocity |
| C | Quarterly/Annually | Low value/velocity |
Location-Based
Count by physical area:
- Rotate through locations
- Complete facility over time
- Systematic coverage
Random Sampling
Statistical approach:
- Random product selection
- Confidence level based
- Efficient for large inventories
Handling Discrepancies
Small Variances
Within tolerance:
- Approve adjustment
- No investigation required
- Monitor patterns
Significant Variances
Above tolerance:
- Recount to verify
- Investigate cause
- Document findings
- Approve with notes
Common Causes
| Cause | Signs | Resolution |
|---|---|---|
| Miscount | Recount differs | Recount |
| Mislocation | Found elsewhere | Relocate |
| Timing | Pending transactions | Book transactions, then Refresh System Qty |
| Theft | Pattern of loss | Security review |
| Damage | Physical evidence | Write off |
Refreshing System Quantities
The System quantity shown next to each counted item is a snapshot taken when the product was added to the count — it does not update on its own when stock transactions change afterwards.
So if the system was behind reality at the time the count was created (e.g. a delivery or issue hadn't been booked yet), the variance will keep showing the old figure even after you book the missing transactions.
To fix this, book the outstanding transactions and then click Refresh System Qty on the count. This re-reads the current system stock levels onto the count and recalculates the variance.
- Available on a count at any stage before it is completed (Draft, Counting, and Review).
- Your physically counted quantities are kept — only the System column and the resulting variance change.
- During review, any product whose System figure changes has its approval cleared, so it must be reviewed again against the corrected variance.
Do not complete a count whose System figures are stale. Completing applies the variance (counted − system) as an adjustment, so an out-of-date System value would post a wrong adjustment and double-count the correction. Refresh first, then complete.
Count Reports
| Report | Purpose |
|---|---|
| Count Sheets | Print for counting |
| Variance Report | Discrepancies found |
| Adjustment History | Changes made |
| Count Accuracy | Accuracy metrics |
Best Practices
Preparation
- Notify operations team
- Complete pending transactions
- Organize storage areas
- Brief counters
Execution
- Count systematically
- Double-count high-value items
- Document issues immediately
- Don't adjust before approval
Follow-up
- Investigate large variances
- Update procedures as needed
- Train on common errors
- Track accuracy trends