Skip to main content

Stock Adjustments

Audience: Warehouse managers, inventory control team, finance team

Overview​

A stock adjustment is a transaction that corrects inventory levels when the physical count doesn't match the system records. Unlike purchases or sales, adjustments don't involve external parties—they're internal corrections to fix discrepancies.

Key Point: Adjustments should be the exception, not the rule. Frequent adjustments indicate underlying problems.

What is a Stock Adjustment?​

Definition​

A transaction that increases or decreases inventory quantity at a specific location to match physical reality.

Examples:

  • Physical count shows 95 bottles, system shows 100 → Adjust down by 5
  • Found 10 bottles in wrong location → Adjust up by 10
  • Damaged 3 bottles during handling → Adjust down by 3
  • System error double-counted → Adjust down to correct

Not an Adjustment​

  • Receiving from supplier → Use Purchase Receipt
  • Shipping to customer → Use Sales Shipment
  • Moving between locations → Use Stock Movement
  • Using in production → Use Assembly Transaction

Rule: Only use adjustments to correct errors or exceptions.

Types of Adjustments​

1. Positive Adjustments (Increases)​

Meaning: Add inventory to the system

Common Reasons:

  • Found items: Discovered inventory that wasn't recorded
  • Incorrect count: Previous count was too low
  • System error: Transaction failed to record receipt
  • Return from scrap: Items thought damaged were actually good

Example:

Item: Lavender Perfume 50ml
Location: Main Warehouse - Zone A
Current System Quantity: 100 bottles
Physical Count: 110 bottles
Adjustment: +10 bottles (increase)
New System Quantity: 110 bottles

2. Negative Adjustments (Decreases)​

Meaning: Remove inventory from the system

Common Reasons:

  • Missing items: Physical count shows less than system
  • Damaged items: Broken, expired, or unusable
  • Theft or loss: Items stolen or lost
  • System error: Transaction recorded twice
  • Shrinkage: Normal loss over time (evaporation, spillage)

Example:

Item: Rose Fragrance Oil
Location: Production Floor
Current System Quantity: 50 liters
Physical Count: 45 liters
Adjustment: -5 liters (decrease)
Reason: "Spillage during production"
New System Quantity: 45 liters

When to Use Adjustments​

Valid Reasons​

  1. Physical Count Discrepancies

    • Annual inventory count finds differences
    • Cycle count reveals errors
    • Spot check shows mismatch

  2. Damage or Spoilage

    • Items broken during handling
    • Products expired or degraded
    • Quality failure after receipt

  3. Found Inventory

    • Items discovered in unexpected locations
    • Misplaced inventory recovered

  4. System Errors

    • Transaction failed mid-process
    • Data entry error
    • System bug caused duplicate/missing records

  5. Theft or Loss

    • Confirmed missing items
    • Security investigation concluded

Invalid Reasons (Use Different Transaction)​

  • ❌ Received from supplier → Purchase Receipt
  • ❌ Sold to customer → Sales Shipment
  • ❌ Moved to another location → Stock Movement
  • ❌ Used in production → Assembly Transaction
  • ❌ Samples given away → Sales Shipment (zero value) or Adjustment with clear policy

How Stock Adjustments Work​

What Gets Recorded​

Every adjustment captures:

  1. Item - What's being adjusted
  2. Location - Where the adjustment occurs
  3. Current Quantity - What system currently shows
  4. New Quantity - What it should be
  5. Adjustment Amount - Difference (+ or -)
  6. Reason - Required explanation
  7. Date & Time - When adjustment occurred
  8. Who Authorized - User performing adjustment
  9. Reference - Optional link to count sheet, incident report, etc.

Financial Impact​

Inventory Value Changes:

  • Positive adjustment: Increases inventory asset value
  • Negative adjustment: Decreases inventory asset value, creates expense

Accounting:

  • Adjustments typically post to "Inventory Variance" or "Shrinkage" account
  • Finance reviews regularly to identify trends

See: Finance Integration

Real-World Scenarios​

Scenario 1: Physical Count Discrepancy​

Background:

  • Annual physical inventory count
  • Item: Midnight Rose Perfume 100ml
  • Location: Main Warehouse - Zone B - Bin B1-05

Count Results:

System Quantity:     150 bottles
Physical Count:      143 bottles
Difference:           -7 bottles

Action: Create negative adjustment

Adjustment:

  • Item: Midnight Rose Perfume 100ml
  • Location: Bin B1-05
  • Current Quantity: 150
  • New Quantity: 143
  • Adjustment: -7
  • Reason: "Annual physical count variance - bottles missing"
  • Reference: "Count Sheet #2024-456"
  • Authorized By: Warehouse Manager

Result: System now matches reality (143 bottles)

Financial Impact: $70 shrinkage expense (7 bottles × $10 cost each)

Scenario 2: Damaged Goods​

Background:

  • Forklift accident in warehouse
  • 5 bottles of perfume damaged beyond repair

Before:

Item: Jasmine Perfume 50ml
Location: Main Warehouse - Zone A
Quantity: 500 bottles

Action: Create negative adjustment

Adjustment:

  • Item: Jasmine Perfume 50ml
  • Location: Zone A
  • Current Quantity: 500
  • New Quantity: 495
  • Adjustment: -5
  • Reason: "Forklift damage - Incident #2024-789"
  • Reference: "Safety Report #2024-789"
  • Authorized By: Warehouse Supervisor

Result: System reflects 495 bottles

Financial Impact: $125 inventory loss (5 bottles × $25 cost each)

Scenario 3: Found Inventory​

Background:

  • During reorganization, found 15 bottles in wrong location
  • These were never recorded in system

Before:

Item: Lavender Perfume 100ml
Location: Main Warehouse - Zone C
Quantity: 200 bottles

Action: Create positive adjustment

Adjustment:

  • Item: Lavender Perfume 100ml
  • Location: Zone C
  • Current Quantity: 200
  • New Quantity: 215
  • Adjustment: +15
  • Reason: "Found during warehouse reorganization - misplaced inventory"
  • Reference: "Reorganization Project 2024"
  • Authorized By: Inventory Manager

Result: System now shows 215 bottles

Financial Impact: $300 inventory gain (15 bottles × $20 cost each)

Scenario 4: Evaporation/Shrinkage​

Background:

  • Bulk fragrance oil stored for 6 months
  • Natural evaporation occurred

Before:

Item: Rose Fragrance Oil (bulk)
Location: Raw Materials Storage
Quantity: 100 liters

Physical Measurement: 97 liters

Action: Create negative adjustment

Adjustment:

  • Item: Rose Fragrance Oil
  • Location: Raw Materials Storage
  • Current Quantity: 100 liters
  • New Quantity: 97 liters
  • Adjustment: -3 liters
  • Reason: "Natural evaporation over 6-month storage period"
  • Reference: "Monthly measurement - October 2024"
  • Authorized By: Production Manager

Result: System reflects actual 97 liters

Financial Impact: Shrinkage expense

Adjustment Workflow​

Business Rules​

Rule 1: Reason is Mandatory​

Always Required: Every adjustment must have a clear, documented reason.

Poor Reasons:

  • "Adjustment"
  • "Fixing quantity"
  • "Error"

Good Reasons:

  • "Annual physical count variance - Count Sheet #2024-456"
  • "Damaged during forklift incident #2024-789 - 5 bottles broken"
  • "Found misplaced inventory during Zone A reorganization"
  • "System error - Purchase Receipt #PO-12345 posted twice"

Why: Audit trail and pattern analysis

Rule 2: Large Adjustments Require Approval​

Example Threshold:

  • < $500 variance: Warehouse supervisor can approve
  • $500 - $2,000: Warehouse manager approval required
  • > $2,000: Finance approval required

Why: Prevent fraud, ensure investigation of large discrepancies

Rule 3: Adjustments Are Immutable​

Once posted, adjustments cannot be edited.

If mistake:

  • Create a reversing adjustment (opposite direction)
  • Document why the reversal was needed

Why: Audit integrity

Rule 4: Monitor Adjustment Frequency​

Red Flags:

  • Same item adjusted repeatedly
  • Same location with frequent adjustments
  • Same user creating many adjustments

Action: Investigate root cause (process issue, training needed, potential fraud)

Best Practices​

1. Investigate Before Adjusting​

Always Ask:

  • Why is there a discrepancy?
  • Is the physical count accurate?
  • Could there be a pending transaction?
  • Is this a system error or a real variance?

Example:

  • Problem: System shows 100 bottles, physical shows 80
  • Investigation: Check recent transactions
  • Finding: Sales shipment created but not yet processed
  • Solution: Wait for shipment to process (no adjustment needed)

2. Document Thoroughly​

Minimum Documentation:

  • Clear, specific reason
  • Reference to count sheet / incident report
  • Date of physical count or event
  • Name of person who discovered discrepancy

Example:

Reason: Annual physical inventory count on 2024-10-15
Reference: Count Sheet #2024-0456, Counter: John Smith
Variance: -7 bottles
Possible cause: Suspected theft or unrecorded damage

3. Batch Similar Adjustments​

Scenario: Annual physical count finds 50 variances

Wrong:

  • Create 50 separate adjustment transactions

Right:

  • Group by location or count session
  • Use multi-line adjustments (if supported)
  • Reference same count sheet

Benefit: Easier to audit, less transaction clutter

4. Regular Cycle Counting​

Prevention Strategy:

  • Count a portion of inventory regularly (e.g., 10% per month)
  • Catch discrepancies early (when small)
  • Avoid large year-end surprises

See: Physical counts process documentation

5. Review Adjustment Reports Monthly​

Management Review:

  • Total adjustment value
  • Adjustments by location
  • Adjustments by item
  • Adjustments by user

Look For Patterns:

  • Repeated adjustments → Process issue
  • Large negative adjustments → Theft or damage control needed
  • Specific locations → Training or security needed

Common Questions​

Q: Can I adjust inventory at multiple locations in one transaction?​

A: Depends on the system. Some allow multi-line adjustments, others require separate transactions per location.

Best Practice: Adjust one location at a time for clarity.

Q: What if I'm not sure of the exact quantity?​

A: Don't guess! Perform a physical count first, then adjust.

Never create an adjustment without verification.

Q: Can I undo an adjustment?​

A: No. Adjustments are permanent.

To correct: Create a reversal adjustment in the opposite direction with explanation.

Q: What if physical count matches system?​

A: No adjustment needed! Only adjust when there's a confirmed discrepancy.

Q: Who should have permission to create adjustments?​

A: Limit to trusted personnel:

  • Warehouse supervisors
  • Inventory control team
  • Managers

Never: General warehouse staff or temporary employees

Reporting and Analytics​

Adjustment Summary Report​

Adjustment Summary - October 2024

Type                Count      Value
─────────────────────────────────────────
Positive Adj.          15    +$3,500
Negative Adj.          42    -$8,200
─────────────────────────────────────────
Net Variance           57    -$4,700

Insight: Net shrinkage of $4,700 for the month

Adjustments by Reason​

Reason                         Count     Value
──────────────────────────────────────────────
Physical count variance           25   -$3,200
Damage                           12   -$2,800
Found inventory                   8   +$2,100
System error                      7   -$1,500
Evaporation/shrinkage            5     -$300
──────────────────────────────────────────────
Total                            57   -$4,700

Insight: Physical count and damage are main causes

Top Adjusted Items​

Item                          Adjustments     Net Variance
──────────────────────────────────────────────────────────
Rose Perfume 50ml                    8          -$850
Lavender Oil (bulk)                  6          -$600
Midnight Rose 100ml                  5          -$450

Insight: These items need attention (better controls, different storage, etc.)

Integration with Other Concepts​

Physical Inventory Counts​

Relationship: Counts discover variances, adjustments correct them

Stock Movements​

Comparison: Movements transfer between locations; adjustments correct quantities

See: Stock Movements

Finance Integration​

Impact: Adjustments affect inventory value and financial statements

See: Finance Integration

Last Updated: 2025-10-28