Skip to main content
Batchlane tracks inventory at the lot level, not just by item quantity. Instead of recording “50 kg of flour,” Batchlane knows you have 30 kg from Lot F-240301-01 expiring March 2025 and 20 kg from Lot F-240415-02 expiring September 2025 — each with its own cost, location, and quality status. This granularity is what makes FEFO picking, traceability, and accurate COGS possible without bolting on a separate system.

Items vs. Lots

An item is the product template — the definition of what something is. A lot is the real-world instance — the actual batch you received, produced, or packaged. Every lot belongs to an item, but a single item can have many active lots at the same time.

Item

The product definition. Holds the name, unit of measure, item code, and default settings. Examples: “Roasted Tomato Base,” “500 mL Glass Bottle,” “Sea Salt.”

Lot

A specific, received or produced batch of an item. Tied to a supplier, a date, and a quantity. Multiple lots of the same item can exist simultaneously.
Each lot in Batchlane carries the following fields:
  • Lot number — your unique identifier for this batch (e.g., SALT-240601-01)
  • Item — the parent item this lot belongs to
  • Quantity — current on-hand quantity, updated in real time as the lot is consumed
  • Unit — the unit of measure (kg, L, each, etc.)
  • Expiry date — the best-before or use-by date used for FEFO sorting and alerts
  • Cost per unit — the landed cost per unit, used to calculate inventory value and COGS
  • Location — the storage location (warehouse zone, fridge, shelf, etc.)
  • COA status — whether a Certificate of Analysis has been received, reviewed, and linked
  • Movement history — a full, append-only log of every quantity change and the document that caused it

The Inventory Ledger

The inventory ledger is your real-time view of every active lot across all items and locations. Each row represents one lot, giving you a precise snapshot of what you have, where it is, and how long you have before it expires.
ColumnWhat it shows
ItemThe parent item name and code
LotThe lot number
QtyCurrent on-hand quantity and unit
ExpiryThe lot’s expiry date
LocationThe assigned storage location
COA StatusMissing, Uploaded, Reviewed, or Linked
The ledger sorts by expiry date ascending by default, so the most time-sensitive lots always appear at the top. This means FEFO order is built directly into the view — you never have to manually sort to find what should be used next.

Lot States

As a lot moves through your operation, Batchlane updates its state automatically based on the documents that reference it.
  • Available — the lot is on hand and can be selected for production
  • Allocated — the lot has been reserved for a planned batch run but not yet consumed
  • In Production — the lot is actively being consumed in an open batch record
  • Finished — the lot is an output lot produced by a completed batch record
  • Archived — the lot has been fully consumed, expired, or manually closed and no longer appears in the active ledger

COA Status

A Certificate of Analysis (COA) is the supplier document confirming that a received lot meets your quality and safety specifications. Batchlane tracks four COA statuses per lot:
  • Missing — no COA has been received for this lot yet
  • Uploaded — a document has been attached to the lot but has not been reviewed
  • Reviewed — a team member has opened and reviewed the document
  • Linked — the COA has been formally linked to the lot record, completing the quality intake step
Growth and Pro plans unlock the full document queue, which lets you manage COA intake across all pending lots from a single view and set required-review rules before a lot can be used in production. The Free plan supports manual COA file attachment on individual lots but does not include the document queue or intake workflow.

CSV Import

You can import both items and lots into Batchlane using CSV files — useful when you’re getting started with existing inventory data or migrating from a spreadsheet. Download the import template from the Settings → Import page, fill in the required columns, and upload the file to create records in bulk. For a step-by-step walkthrough of your first import, see the Quickstart guide.
Adopt a consistent lot number format from day one. A format like ITEM-YYMMDD-SEQ (for example, TBASE-240601-01) sorts chronologically, includes the item code for quick identification, and makes traceability searches much faster. Standardizing this convention across your team pays dividends the first time you run a recall drill.