Stock Sync & Reconciliation

Raw / WIP / Finished split per warehouse and gap detection

Inventory analyst 9 gaps

Every kilogram, bucketed and reconciled

30.86 MT on hand across 5 warehouses · Raw 0 kg · WIP 0 kg · Finished 30.86 MT

Warehouses
Raw
0 kg
Awaiting processing
WIP
0 kg
In progress on the floor
Finished
30.86 MT
QC pass · ready / packed
Reconciliation gaps
9
4 batch · 5 warehouse

Per-warehouse RM / WIP / FG split

Stacked by category. Width is total kg in that warehouse.

JNPT Bonded W-315.20 MT
Raw: 0 kgWIP: 0 kgFinished: 15.20 MT
Bawana Dry Hub800 kg
Raw: 0 kgWIP: 0 kgFinished: 800 kg
Whitefield Cold-1410 kg
Raw: 0 kgWIP: 0 kgFinished: 410 kg
Kandla Port WH-712.00 MT
Raw: 0 kgWIP: 0 kgFinished: 12.00 MT
Pulwama FPO Store2.45 MT
Raw: 0 kgWIP: 0 kgFinished: 2.45 MT

Warehouse reconciliation

Occupied kg on the warehouse record vs. Σ StockLine kg in that warehouse. They should be equal — any drift means a movement was logged without a stock-line update or vice versa.

WarehouseOccupied (record)Σ stock linesGapStatus
JNPT Bonded W-3
Navi Mumbai
412.00 MT15.20 MT+396.80 MT Gap
Bawana Dry Hub
Delhi
158.00 MT800 kg+157.20 MT Gap
Whitefield Cold-1
Bengaluru
41.00 MT410 kg+40.59 MT Gap
Kandla Port WH-7
Kandla
198.00 MT12.00 MT+186.00 MT Gap
Pulwama FPO Store
Pulwama
18.00 MT2.45 MT+15.55 MT Gap

Batch reconciliation

Stock = Batch.remainingKg + Σ FG kg. FG kg sums all non-dispatched units packed against the batch. Gaps usually mean an FG record exists but the batch's remainingKg wasn't decremented (or vice versa).

BatchVariety / kindRemaining+ FG kg= Expected stockActual stockGap
BTC-2025-5021Australian Independence
Finished
12.00 MT12.00 MT24.00 MT12.00 MT12.00 MT
BTC-2025-1101Nonpareil (Carmel-Cut)
Finished
5.40 MT2.60 MT8.00 MT5.40 MT2.60 MT
BTC-2025-3034Gurbandi (Choti Giri)
Finished
2.10 MT2.10 MT4.20 MT2.10 MT2.10 MT
BTC-2025-2010Mamra Premium
Finished
800 kg400 kg1.20 MT800 kg400 kg
BTC-2025-1102California Supreme
Finished
9.80 MT9.80 MT9.80 MT ok
BTC-2025-3033Gurbandi (Choti Giri)
Finished
350 kg350 kg350 kg ok
BTC-2025-4007Spanish Marcona
Finished
410 kg410 kg410 kg ok