Stock Management

Understanding Stock Flow: In, Out, and Audit

Complete guide to understanding Kelola's three stock management operations. Learn when to use Stock In, Stock Out, and Stock Audit for accurate inventory control.

On This Page

What You’ll Learn

By the end of this guide, you’ll understand:

  • The difference between Stock In, Out, and Audit
  • When to use each operation
  • How they affect your inventory
  • Best practices for each

The Three Stock Operations

Kelola provides three ways to manage inventory:

OperationIconPurposeStock Effect
Stock In📥Add inventoryIncreases quantity
Stock Out📤Remove inventoryDecreases quantity
Stock Audit🔍Correct inventoryAdjusts to match reality

Stock In: Adding Inventory

What It Does

Stock In records products entering your inventory.

Stock change: ⬆️ Quantity increases

When to Use Stock In

ScenarioExample
Purchasing from suppliersReceived 100 units from vendor
Customer returnsCustomer brought back 5 items
Production completionManufactured 50 new units
Finding extra stockDiscovered 10 units not recorded
Transfer from locationReceived stock from Store B

What Gets Recorded

  • Product(s) added
  • Quantity received
  • Buying price (cost)
  • Supplier (optional)
  • Date
  • Notes

Example Workflow

Purchase Order → Delivery Received → Stock In Recorded → Inventory Updated

Result:

  • Before: Coffee Beans = 50 units
  • Stock In: +100 units
  • After: Coffee Beans = 150 units

Stock Out: Removing Inventory

What It Does

Stock Out records products leaving your inventory.

Stock change: ⬇️ Quantity decreases

When to Use Stock Out

ScenarioExample
Sales to customersSold 3 units to customer
Internal useUsed 10 units for production
Damage/loss5 units broken, unsellable
Samples givenGave 2 units as free samples
Transfer to locationSent stock to Store B
Returns to supplierSent 20 defective units back

What Gets Recorded

  • Product(s) removed
  • Quantity sold/used
  • Selling price (revenue)
  • Customer (optional)
  • Payment status
  • Date
  • Notes

Example Workflow

Customer Order → Items Picked → Stock Out Recorded → Inventory Updated

Result:

  • Before: Coffee Beans = 150 units
  • Stock Out: -3 units
  • After: Coffee Beans = 147 units

Stock Audit: Correcting Inventory

What It Does

Stock Audit adjusts inventory to match physical count. Use when system and reality don’t match.

Stock change: ⬆️⬇️ Adjusts up or down to match actual

When to Use Stock Audit

ScenarioWhy Audit
Periodic stock countMonthly/quarterly inventory check
Discrepancy foundSystem says 100, shelf has 95
After stock lossTheft, damage, expiration discovered
System errorsWrong entry discovered later
Year-end closingAnnual inventory verification

Audit vs. Stock In/Out

SituationUse ThisWhy
Bought from supplierStock InNormal business flow
Sold to customerStock OutNormal business flow
Counted 95, system says 100Stock AuditCorrection needed
Found 5 extra unitsStock AuditAdjust to reality

What Gets Recorded

  • Product audited
  • Physical quantity counted
  • System quantity (auto-filled)
  • Adjustment amount
  • Reason for adjustment
  • Date
  • Notes

Example Workflow

Physical Count → Compare to System → Record Discrepancy → Audit Adjustment

Result:

  • System shows: Coffee Beans = 147 units
  • Physical count: 145 units
  • Audit: -2 units adjustment
  • After: Coffee Beans = 145 units (matches reality)

Comparison Table

AspectStock InStock OutStock Audit
PurposeAdd inventoryRemove inventoryCorrect inventory
DirectionInwardOutwardAdjustment
Normal usePurchasesSalesCorrections
Financial impactCost recordedRevenue recordedAdjustment recorded
Supplier linkYesNoNo
Customer linkNoYesNo
FrequencyDailyDailyWeekly/Monthly
Who usesAll staffAll staffAdmin/Owner

Decision Flowchart

Which Operation Do I Need?

Did inventory physically arrive from outside?
├── YES → Did you pay for it?
│   ├── YES → STOCK IN (purchase)
│   └── NO → STOCK IN (return to stock)
└── NO → Did inventory physically leave?
    ├── YES → Was it sold?
    │   ├── YES → STOCK OUT (sale)
    │   └── NO → STOCK OUT (loss/use)
    └── NO → Does system match physical count?
        ├── YES → No action needed
        └── NO → STOCK AUDIT (adjustment)

Common Mistakes

❌ Wrong: Using Stock In for Found Items

Mistake:

  • Found 5 extra units
  • Recorded as Stock In

Problem:

  • Appears as purchase in reports
  • Distorts buying costs
  • Messes up supplier history

✅ Correct:

  • Use Stock Audit
  • Add note: “Found during stock count”

❌ Wrong: Using Stock Out for Damaged Goods

Mistake:

  • 3 units damaged
  • Recorded as Stock Out with $0

Problem:

  • Appears as sale in reports
  • Affects revenue numbers
  • Wrong financial data

✅ Correct:

  • Use Stock Audit (decrease)
  • Add note: “Damaged goods - unsellable”
  • Or use dedicated “Damage/Loss” reason

❌ Wrong: Multiple Audits for Small Corrections

Mistake:

  • Found discrepancy
  • Audited immediately
  • Found another issue
  • Audited again same day

Problem:

  • Clutters transaction history
  • Hard to track
  • Looks unprofessional

✅ Correct:

  • Complete full physical count first
  • Record all discrepancies
  • Single audit for all corrections

Best Practices

For Stock In

Always link to supplier

  • Better purchase tracking
  • Vendor performance data
  • Reorder history

Record immediately

  • Don’t let deliveries pile up
  • Same day as receipt
  • While unpacking

Check quantities

  • Verify against delivery note
  • Note discrepancies
  • Photo damaged items

For Stock Out

Always link to customer

  • Purchase history
  • Debt tracking
  • Customer analytics

Record before delivery

  • Prevents forgotten sales
  • Accurate real-time stock
  • Better customer service

Note payment method

  • Cash flow tracking
  • Reconciliation aid
  • Audit trail

For Stock Audit

Do regularly

  • Monthly: Fast-moving items
  • Quarterly: All inventory
  • Annually: Full audit

Count when closed

  • No transactions during count
  • More accurate
  • Less disruption

Document reasons

  • Why adjustment needed
  • Who authorized
  • Prevent recurrence

Investigate discrepancies

  • Don’t just adjust
  • Find root cause
  • Fix process if needed

Integration with Reports

How Each Affects Reports

Stock In affects:

  • Inventory valuation (increases)
  • Purchase reports
  • Supplier performance
  • Cost of goods available

Stock Out affects:

  • Revenue reports
  • Customer purchase history
  • Sales analytics
  • Inventory valuation (decreases)

Stock Audit affects:

  • Inventory accuracy
  • Loss/theft tracking
  • Shrinkage reports
  • Correction history

Troubleshooting

”Can’t choose Stock Audit”

Cause: Permission restricted

Solution:

  • Only Admin/Owner can audit
  • Staff need stock_audit permission
  • Contact business owner

”Audit shows wrong adjustment”

Check:

  • Physical count accuracy
  • Pending transactions
  • Unit of measure (box vs unit)

“Stock In/Out not changing inventory”

Check:

  • Transaction submitted (not draft)
  • Sync completed
  • Correct product selected
  • No error messages

FAQ

Q: Can I undo a Stock In/Out/Audit? A: Yes, go to History, find the transaction, and delete it. Stock reverts automatically.

Q: What’s the difference between Stock Out and Stock Audit (decrease)? A: Stock Out is normal business (sales). Audit is correction when things don’t match.

Q: Should I use Stock In for opening inventory? A: Yes, for initial setup. Record your starting stock as Stock In with notes “Opening inventory”.

Q: How often should I audit stock? A: A-items (fast movers): weekly. B-items: monthly. C-items: quarterly. Full audit: annually.

Q: Can I audit multiple products at once? A: Yes, Stock Audit allows selecting multiple products for batch auditing.

Q: Do I need to audit if I use Kelola perfectly? A: Still recommended. Physical counts catch: theft, damage, expiration, system errors.