Features

Follow the quantity.
Keep the context.

A small tool for one practical question: does the stock I can count match the movements I recorded?

Apply a reviewed physical recount while preserving stock movements.

One bridge per product

Opening + made + physically restocked returns − fulfilled sales − losses/samples + other adjustments = expected closing stock. Difference is counted minus expected.

Differences that don’t cancel each other out

Two products can have opposite errors while the combined total balances. BatchTrace reports each product separately, including negative expected balances that deserve another look.

Save, export and reopen

Save the current worksheet and up to ten named count copies in this browser. Preserve each count’s location, cutoffs, source context and notes; review it, export text, or make an editable historical copy. Full JSON backups retain the collection, and CSV exports retain the current calculated bridge. Loading asks before replacing current work. Explore count sessions.

Validation before calculation

Unique product codes, explicit quantities and up to three decimal places. Signed adjustments are allowed; other quantities cannot be negative. Up to 500 products per worksheet.

What comes next

Comma CSV mapping is available: choose source columns, preview the validated batch and confirm replacement. Product code and counted quantity are required; unassigned movements become zero. Linked evidence, shared investigations and team history remain planned. No inventory account is connected.

Keep the discrepancy decision

Record investigation, recount or proposed adjustment decisions against exact source quantities. Review a local adjustment and retain its before/after explanation in the full backup. Document a stock decision.