Skip to content
TraceBenchBY SMARTFACT

FREE LOT AND BATCH TRACEABILITY

What is forward and backward traceability?

Updated

Forward traceability follows a lot from its source to where it went, such as the batches it was used in and the shipments that carried them; backward traceability follows a product or shipment back to the lots that went into it. TraceBench does both free in your browser from one or two CSV exports, showing the recorded row behind every link.

Free to use. No account, email address or trial. Your files are never uploaded.

TraceBench result for shipment S-503 traced backwards from the despatch file, under the heading What went into it?
A shipment traced backwards to the lots behind it.

Where did it go? Tracing forwards

Start from a supplier lot or an input batch and choose Forwards: where did it go? TraceBench follows each recorded production operation to its outputs and, once you have confirmed the link between the two files, each despatch record to the shipments that carried them. Where several inputs share one operation, every input may relate to every output, and the link is labelled as potential attribution.

TraceBench Trace direction set to Forwards: where did it go? for batch B-1001, chosen as the starting record from the production file
The direction chosen for one exact starting record.

What went into it? Tracing backwards

Start from a finished batch, a serial unit or a shipment and choose Backwards: what went into it? A shipment is always traced backwards, through its recorded contents. The result shows each batch and supplier lot reached, with the row behind each link.

TraceBench Lot, serial or shipment code field with shipment S-503 entered, showing Looking for S-503
A shipment number as the starting point.

Why does the same code need a choice?

A batch number can appear in both files, as an output in production and as an item in despatch. TraceBench lists each place the code occurs, with its file and numbering, and asks you to choose the exact starting record, so a trace never switches files because the text matches.

TraceBench saying This code appears in more than one declared place for B-1001, above a Starting record list
One code in two declared places: you choose the start.

How do the two files join up?

Only where you say so. A matching code in the other file stays a possible link until you confirm that one exact pair is the same, or declare that two material columns use the same numbering, each with a reason. Withdrawing a decision is recorded too, and affects new traces only.

TraceBench Links between the two files after one exact pair for batch B-1001 is confirmed, with the reason recorded
One pair confirmed, labelled as your confirmation.

What TraceBench does not do

It does not infer links from dates, descriptions, quantities or row order, and it does not allocate quantities between inputs and outputs. It follows two current files at a time and up to 20 manufacturing steps, and says when a trace stops at a limit.

MADE FOR THE FLOOR

For production, planning and supply chain staff who need to answer where a lot went or what went into a batch or shipment, from records they already export.

A USEFUL STARTING POINT

Both directions, from the same records

A complaint arrives with a shipment number; a supplier warns about a lot. One needs a backward trace and the other a forward one, often across a production file and a despatch file. TraceBench follows the same recorded links in either direction, so both answers come from the same evidence, with the same gaps shown.

FROM QUESTION TO EVIDENCE

Three steps to a useful result.

  1. 01

    Load one or two files

    A production file alone shows what went into each batch. Add the despatch file to reach shipments. Say what each column means before using it.

  2. 02

    Choose the start and direction

    Scan or type the exact code, choose the starting record and pick forwards or backwards. A shipment is traced backwards.

  3. 03

    Follow every link

    Run the trace and open any link to see its file, record number and original cells. Download the result as a PDF or CSV.

A CONCRETE EXAMPLE

Backwards from one shipment

In the built-in example, shipment S-503 traced backwards reaches batch B-1002 and supplier lot SL-0042, and not batch B-1001, because the despatch file records only B-1002 in that shipment. The answer is still Partial: a production record within the file's declared sequence range is missing, and TraceBench says so.

USED IN PRODUCTION

When tracing becomes quality work for a team.

TraceBench answers one question at a time, from files you load on one device. When traces become regular work for a quality team, LotTrail keeps the declared sources, reviewed identity links and evidence together. LotTrail is an invited trial, with scope agreed with you.

Invited trial

LotTrail

LotTrail follows a lot or serial number through the records your factory already keeps, with the source of each link and the gaps shown. Sources are declared, mappings are reviewed, identity links are approved by a supervisor and the evidence is retained for quality work. The invited trial covers two declared sources at one site.

BEFORE YOU START

A few practical answers.

Can I trace serial numbers?

Yes. Each code column is declared as a material lot or batch, or as a serial unit, with its own numbering name. A serial number and a lot number are never joined to each other.

Do I need both files?

No. One file is enough: a production file alone shows what went into each batch and where each lot was used in production. Add a second file, such as despatch, when you need to trace across systems.

Why did my trace stop at the other file?

Because matching codes are only possible links. Confirm the exact pair or declare the shared numbering under Links between the two files, then run the trace again. Until then the result names the unconfirmed link as a gap.

What are the current limits?

TraceBench is a reading of the records you load, not a recall decision or proof of what physically happened. It has no recall, hold, stock or customer-notification actions, does not allocate or reconcile quantities, and never links records because their codes, times, descriptions or row order look alike. Two current files at a time, each UTF-8 CSV with column names in the first row, up to 5 MiB, 5,000 data records and 40 columns, and 10,000 recorded facts across both. A trace follows up to 20 manufacturing steps and stops at its limits with a stated reason. XLSX files are not read, and there is no connection to your ERP or any other system.

What happens to my data?

Your files stay in this browser. Work is held in memory until you choose Save on this device, which keeps the whole project, original files included, in this browser. Files are read and fingerprinted on your device and never uploaded, and there is no account or email step. Reports and backups contain your records and file names, so check them before sharing. Google Analytics is optional and loads only after you accept; it never receives codes, rows, file names or results. Use Analytics settings to change your choice; see /privacy/.

ONE SMALL JOB, DONE WELL

Put TraceBench to work.

Open the free tool and start with one known example.

Start a free trace →

THE SMARTFACT SUITE

Practical tools. Useful on their own.
Better around the same floor.

Automate factory decisions with rules you describe in plain English. Explore focused SmartFACT services, plus free tools for everyday checks.

Invited trialSuggested next step

LotTrail

Follow a lot or serial number through the records your factory already keeps, with the source of each link and the gaps shown. Explore an invited trial with two declared sources.

Explore LotTrail ↗
Invited trial

LabelRules

Describe label rules in plain English. Automatically select layouts, resolve customer codes and check each job before printing.

Explore LabelRules ↗
Early access

KitProof

Turn plain English component rules into automatic kit checklists, then check scans against the expected parts and quantities.

Explore KitProof ↗
Early access

WorkSteps

Turn plain English rules into automatic step selection for each unit, with required evidence and a record of completed work.

Explore WorkSteps ↗
Early access

FactorySpec

Apply approved product rules and calculations automatically to turn dimensions and options into manufacturing requirements.

Register early-access interest ↗
Early access

ConfigSheets

Bring data in from uploaded sheets or the Shopify, WooCommerce and PrestaShop connectors, check each change and deliver it to the products that use it.

Explore ConfigSheets ↗
Early access

ParcelOffice

Scan the work order and the parcel choice to book the courier and print the labels. Approved plain English rules recommend or choose the parcel.

Explore ParcelOffice ↗
Early access

RefillFlow

Scan an empty container to send the right refill request to stores. Approved plain English rules set the stores queue, priority, ticket printer and escalation.

Explore RefillFlow ↗
Early access

RemnantRack

Label each offcut, find a suitable length before cutting new stock and record what you used. Approved plain English rules decide what to keep and where it goes.

Explore RemnantRack ↗
Invited trial

ToolCustody

Check a shared tool before handover, record who has it and keep damaged or overdue tools out of the next issue. Explore an invited trial for one factory crib.

Explore ToolCustody ↗
Invited trial

StoresFlow

Receive, put away, reserve and issue stores material with barcode checks, keeping held, reserved and available stock apart. Explore an invited trial for one stockroom.

Explore StoresFlow ↗
Early access

CheckStation

Scan an identified unit to get its approved final-inspection checks, then record exact readings with their result, holds and release history.

Register early-access interest ↗
Free tool

ScannerBench

See the text and key events your keyboard scanner sends. Compare them with the value you expected.

Test a scanner ↗
Free tool

PrintBench

Print a known PDF, measure its reference marks and compare scans from the printed codes.

Check a print ↗
Free tool

CardBench

Create 100 × 50 mm bin and rack cards with Code 128 or QR, from one record or a CSV.

Make bin cards ↗
Free tool

CountBench

Count stock by location with a barcode scanner, compare it with a stock file and export the results. No account needed.

Start a free count ↗
Free tool

BarcodeBench

See exactly what a scanned barcode contains, with hidden characters shown and GS1 fields, check digits and dates explained. No account needed.

Inspect a barcode ↗
Free tool

MatchBench

Scan a reference and each label, see an exact match or the first difference, and download the results. No account needed.

Start a free comparison ↗
Free tool

TagBench

Scan an item or location, note what needs attention, print a review tag and keep a review list. No account needed.

Make a free tag ↗
Free tool

FindBench

Load your own parts and locations CSV, scan a code and see every location it lists. No account needed.

Start a free lookup ↗
Free tool

ManifestBench

Check cartons, pallets or serial numbers against a list with a phone or scanner and see what is missing. No account needed.

Start a free check ↗
Free tool

FeedBench

Check CSV and JSON files exactly as written, preview a column mapping and compare two versions by key. No account needed.

Check a file free ↗
Free tool

CycleBench

Time work cycles and changeovers on a phone, record interruptions with reasons and download the results. No account needed.

Start a free study ↗
Free tool

OffcutBench

Label the offcuts on your rack, find a piece long enough before cutting new stock and record what you used. No account needed.

Track offcuts free ↗
Free tool

TraceBench

Load one or two CSV exports and follow a lot or serial forwards or backwards, with the row behind every link. No account needed.

You are here
Help

SmartFACT Help

Step-by-step guides and interactive demonstrations for the SmartFACT suite. Read the instructions, watch a task or practise with real product screens and sample data.

Open SmartFACT Help ↗