How to Track Stock In and Stock Out Using Barcodes

Stock in stock out tracking fails when people type quantities from memory. Barcodes force a physical touch: scan the unit, then change the number. That single habit cuts most “ghost inventory”.

Define the two movements

Stock in: PO receipt, returns, production output. Stock out: sales, transfers, scrap, samples. Same barcode; different quantity direction or reason column.

Simple sheet design

• Barcode
• On-hand qty (adjustable number)
• Last movement type (dropdown: in / out / count)
• Location
• Optional reference (PO #, order #)

Floor process

1. Stock in Scan each line (or carton QR), enter received qty, save.
2. Stock out Scan picks; decrease qty or use auto-decrease columns where configured.
3. Audit Cycle-count a bin; overwrite on-hand when physical differs.

Pick a model: movement log or running balance

There are two honest ways to track stock in and out, and choosing up front avoids a messy sheet later.

Model	How it works	Best when
Running balance	One row per item; Quantity goes up/down on each scan	You mainly need current on‑hand
Movement log	One row per event (In/Out, qty, time, ref)	You need an audit trail of every move

Running‑balance setup

Keep Barcode, Name, Quantity, Location. Use triggers so a “stock in” scan runs increment and a “stock out” scan runs decrement on Quantity—no mental math at the shelf. Add a Min‑stock column and a notify rule so the sheet tells you when to reorder.

Movement‑log setup

Column	Example
Barcode	8690000000017
Direction	In / Out (dropdown)
Quantity	12
Reference	PO‑1042 / Order‑5571
Timestamp	auto date‑time

A movement log is slower to read for “current stock”, but it is the better choice when you must explain exactly how a number changed. You can summarise current on‑hand later with a grouped report.

Reconcile with a periodic count

Whichever model you choose, run a cycle count on a schedule and correct the sheet against the shelf. Scanning removes most entry errors, but physical counts catch shrinkage and mis‑scans.

Example movement columns

Column	Use
Barcode	Item key
Quantity	On-hand after movement
Direction	In / Out (or separate sheets)
Reference	PO / order id (optional)

Automate reactions with Cloud sheet triggers (notify / webhook) when quantity changes—without claiming automatic ERP sync.