Skip to main content

Physical Inventory Counts

Verify and reconcile physical inventory against system records.


Count Overview

PHYSICAL COUNT FLOW
─────────────────────────────────────────────────────────────────

┌─────────────────┐ ┌─────────────────┐ ┌─────────────────┐
│ INVENTORY COUNT │ │ COUNT ITEMS │ │ ADJUST TO │
│ (Create/Plan) │ ──▶ │ (Enter qty) │ ──▶ │ ACTUAL │
│ │ │ │ │ │
│ GL: None │ │ GL: None │ │ GL: Adjustment │
│ Inv: None │ │ Inv: None │ │ Inv: ↑ or ↓ │
└─────────────────┘ └─────────────────┘ └─────────────────┘

Creating an Inventory Count

What Happens

ActionResult
Create countCount record created
Select locationWhere to count
Add itemsItems to be counted
Assign countersWho will count
StatusNot Started

Count Creation Methods

COUNT CREATION METHODS
─────────────────────────────────────────────────────────────────

Method 1: ALL ITEMS AT LOCATION
Count all inventory items at a location
└── Best for: Annual physical inventory

Method 2: SPECIFIC ITEMS
Select specific items to count
└── Best for: Cycle counting, high-value items

Method 3: SAVED SEARCH
Items matching search criteria
└── Best for: By category, by vendor, by value

Method 4: BIN-BASED
Count by bin location
└── Best for: Bin-managed warehouses

Inventory Count Record

INVENTORY COUNT CREATION
─────────────────────────────────────────────────────────────────

Inventory Count #IC-001
├── Location: Main Warehouse
├── Count Type: Full Physical
├── Items to Count:
│ ├── Widget-A (Current On Hand: 100)
│ ├── Widget-B (Current On Hand: 75)
│ └── Widget-C (Current On Hand: 200)
├── Assigned To: Warehouse Team
└── Status: Not Started

Next: Print count sheets, count items, enter results

Conducting the Count

Count Process

COUNT PROCESS STEPS
─────────────────────────────────────────────────────────────────

Step 1: PREPARE
├── Print count sheets
├── Stop inventory movement (freeze)
├── Organize warehouse
└── Brief counting team

Step 2: COUNT
├── Count all items physically
├── Record quantities
├── Double-count variances
└── Investigate discrepancies

Step 3: ENTER
├── Enter counted quantities
├── Review variances
└── Approve adjustments

Step 4: POST
├── Post adjustments
└── Review GL entries

Entering Count Results

ENTERING COUNT RESULTS
─────────────────────────────────────────────────────────────────

Inventory Count #IC-001

Item | System | Counted | Variance
─────────────┼────────┼─────────┼──────────
Widget-A | 100 | 98 | -2
Widget-B | 75 | 80 | +5
Widget-C | 200 | 200 | 0

Status: Counted

Next: Review variances, then adjust

Adjusting to Actual

After counting, adjust system quantities to match physical count.

What Happens

ActionResult
Review variancesConfirm discrepancies
Approve adjustmentAuthorize changes
Post adjustmentGL entries created
Update inventoryOn Hand corrected

Adjustment Process

ADJUSTMENT FROM COUNT
─────────────────────────────────────────────────────────────────

Inventory Count #IC-001

│ Post Adjustments

Inventory Adjustment #IA-001
├── Widget-A: -2 units @ $10 = -$20 (decrease)
├── Widget-B: +5 units @ $25 = +$125 (increase)
└── Widget-C: 0 units (no change)

Net Adjustment: +$105

GL Impact

AccountDebitCreditWhy?
Inventory Asset$125Widget-B found (Asset ↑)
Inventory Asset$20Widget-A missing (Asset ↓)
Inventory Adjustment$20Loss recognized (Expense ↑)
Inventory Adjustment$125Gain recognized (Expense ↓)
COUNT ADJUSTMENT GL EXPLAINED
─────────────────────────────────────────────────────────────────

Net Effect:
Inventory increases by $105 (net found more than lost)
Adjustment account decreases by $105

For Widget-A (lost 2 units):
Adjustment Expense $20 Dr ← Loss of 2 units
Inventory $20 Cr ← 2 units gone

For Widget-B (found 5 units):
Inventory $125 Dr ← Found 5 units
Adjustment Income $125 Cr ← Unexpected gain

Inventory Impact

INVENTORY AFTER COUNT ADJUSTMENT
─────────────────────────────────────────────────────────────────

Before Count:
┌─────────────────────────────────────────┐
│ Widget-A: On Hand: 100 │
│ Widget-B: On Hand: 75 │
│ Widget-C: On Hand: 200 │
└─────────────────────────────────────────┘

After Adjustment:
┌─────────────────────────────────────────┐
│ Widget-A: On Hand: 98 (corrected) │
│ Widget-B: On Hand: 80 (corrected) │
│ Widget-C: On Hand: 200 (no change) │
└─────────────────────────────────────────┘

System now matches physical reality

Cycle Counting

Continuous counting throughout the year instead of annual count.

Cycle Count Methods

CYCLE COUNT METHODS
─────────────────────────────────────────────────────────────────

ABC ANALYSIS:
A Items (High Value): Count monthly
B Items (Medium Value): Count quarterly
C Items (Low Value): Count annually

LOCATION ROTATION:
Week 1: Aisle A
Week 2: Aisle B
Week 3: Aisle C
...

TRANSACTION-BASED:
Count items that had transactions recently
Focus on high-movement items

Benefits of Cycle Counting

BenefitDescription
Less disruptionNo warehouse shutdown
Faster correctionIssues found sooner
Better accuracyRegular verification
Lower costSpread workload

Count Variance Investigation

When counts don't match system:

VARIANCE INVESTIGATION
─────────────────────────────────────────────────────────────────

Variance Found: Widget-A is 5 units short

Investigation Steps:
1. Re-count (confirm variance)
2. Check recent transactions
├── Pending shipments not fulfilled?
├── Returns not received?
└── Transfers in transit?
3. Check other locations
└── Accidentally stored elsewhere?
4. Review access logs
└── Potential theft?
5. Document findings
6. Adjust if confirmed

Quick Reference

Count Statuses

StatusMeaning
Not StartedCreated, not counted
In ProgressCounting underway
CountedAll counts entered
ApprovedVariances approved
PostedAdjustments made
ClosedComplete

Count Types

TypeFrequencyScope
Full PhysicalAnnualAll items
Cycle CountOngoingRotating subset
Spot CheckRandomSample items
TriggeredEvent-basedSpecific items

Best Practices

PracticeBenefit
Freeze inventoryAccurate count
Double-count variancesReduce errors
Investigate before adjustingFind root cause
Document reasonsAudit trail
Review trendsPrevent future issues

Next Steps