Skip to content
TraceBenchBY SMARTFACT

FREE LOT AND BATCH TRACEABILITY

One up, one down traceability: linking what came in to what went out

Updated

One up, one down traceability means recording, for every lot, the supplier it came from and the customer it went to, and keeping the link between the two. TraceBench shows that link free in your browser, from one or two CSV exports of your own records: it follows only the links your rows state or you confirm, shows the row behind each one and names every gap.

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

TraceBench trace from supplier lot SL-0042: reached batches B-1002 and B-1001, B-1001 in Despatch and shipments S-501 and S-502, then the link B-1001 to B-1001 from Production to Despatch, marked Your confirmation, with its reason
The batch link you confirmed carries the trace from production to the shipments.

One step back: the supplier lot

One step back means knowing which supplier lot went into each of your batches. In TraceBench that comes from a production file: choose Production: input into output, then the column that holds the supplier's lot number as the input, and give it a numbering name such as supplier lots. That numbering stays separate from your own batch numbers, so a supplier's lot is never joined to one of yours because the codes look alike.

TraceBench production file mapping with the input column chosen as the Input code column
The column that holds the supplier's lot number.

One step forward: the customer shipment

One step forward means knowing which shipment, and so which customer, each batch went to. That comes from a despatch file: choose Despatch: item in a shipment, then the batch column and the shipment column. TraceBench keeps no customer list of its own, so keep the customer in the despatch row: each link shows the whole row, exactly as written. A shipment number can also be the starting point, traced backwards to the batches in it.

TraceBench Lot, serial or shipment code field with shipment S-503 scanned, and Looking for S-503 below it
A shipment number from the despatch records as the starting point.

The link inside your business

The link between what came in and what went out is your own production record: this supplier lot went into this batch, and this batch went into that shipment. When production and despatch are separate files, a batch number in both is only a possible link until you say so: confirm one exact pair, or declare that the two batch columns use the same numbering, each with a reason. The link is then labelled Your confirmation or Your declaration, and withdrawing it is recorded too.

TraceBench Links between the two files after the pair B-1001 in production and B-1001 in despatch is confirmed, listed under Your confirmation with its reason
One exact pair confirmed, with the reason for it.

Following it beyond one step

Each business in a supply chain keeps its own one up, one down records. Inside your business, the same records go further than one step: a supplier lot traced forwards reaches every batch made from it, through up to 20 manufacturing steps, and, once the two files are linked, every shipment recorded for those batches. Traced backwards, a shipment reaches the batches in it and the supplier lots behind them.

TraceBench result for supplier lot SL-0042 traced forwards, under Where did it go?: Partial: some of the answer is missing, with 8 reached identities, 7 recorded links and confirmations and 1 relevant gap
Inside your business the same records go further: every batch and shipment recorded for the supplier lot.

What TraceBench does not do

TraceBench reads the records you load; it does not tell you which rules apply to your business or whether your records meet them. It reads two current CSV files at a time, has no connection to your ERP or to your suppliers' and customers' systems, and links records only where your rows state the link or you confirm it. It shows quantities as written without balancing them, and it has no recall, hold or customer-notification actions.

MADE FOR THE FLOOR

For quality, technical and supply chain staff at small food and engineering manufacturers who need to show which supplier each lot came from and which customer it went to.

A USEFUL STARTING POINT

The link in the middle is the hard part

Most businesses know their suppliers and their customers. The harder part is the link between them: which supplier lots went into which batch, and which batch went to which customer. TraceBench follows that link through the production and despatch records you already keep, shows the row behind each step and says where the records stop.

FROM QUESTION TO EVIDENCE

Three steps to a useful result.

  1. 01

    Load production and despatch

    Export the production records that say which supplier lot went into each batch, and the despatch records that say which batch went into each shipment. Load them as CSV and say what each column means.

  2. 02

    Connect the two files

    Confirm one exact pair, or declare that the batch columns in both files use the same numbering, with your reason.

  3. 03

    Trace one up and one down

    Trace a supplier lot forwards to its shipments, or a shipment backwards to its supplier lots, and download the result as a PDF or CSV.

A CONCRETE EXAMPLE

From supplier lot to shipment

In the built-in example, the production file records supplier lot SL-0042 going into batches B-1001 and B-1002, and the despatch file records B-1001 in shipments S-501 and S-502 and B-1002 in S-503. With the batch numbering declared as shared, SL-0042 traced forwards reaches all three shipments, each link showing its row. The answer is Partial, because a production record within the declared sequence range is missing, and TraceBench names it.

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.

Is traceability a legal requirement?

One up, one down is a common baseline in food and supply-chain rules, but what applies to you depends on your products, your markets and your customers, so check with your trade body, certification scheme or adviser. TraceBench does not give legal advice; it shows, from your own records, whether each lot links to its supplier and to its customer.

Is one up, one down the same as a traceability exercise?

No. One up, one down is what your records should hold; a traceability exercise tests whether they do, by following a lot both ways against the clock. See /traceability-exercise/.

Do I need both files?

For both steps, yes: the production file gives the supplier lot in each batch, and the despatch file gives the shipment for each batch. A production file alone shows one step back.

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 ↗