Skip to main content

Lot/Serial Costing

Track the actual cost of each specific unit or lot - required for serialized items and lot-tracked inventory.


How Specific Identification Works

Lot/Serial Costing Concept
─────────────────────────────────────────────────────────────────

Each unit/lot maintains its OWN cost

Serial Numbers:
SN-001: 1 unit @ $1,000
SN-002: 1 unit @ $1,050
SN-003: 1 unit @ $980

Lot Numbers:
LOT-A: 100 units @ $10.00
LOT-B: 50 units @ $12.00
LOT-C: 75 units @ $11.50

When sold, COGS = the specific cost of THAT unit/lot

Cost Flow Diagram

Lot/Serial Costing Flow
─────────────────────────────────────────────────────────────────

Purchases with Lots:

LOT-A: 100 @ $10.00 = $1,000
LOT-B: 50 @ $12.00 = $600
LOT-C: 75 @ $11.50 = $863

Sale: 80 units from LOT-A

COGS: 80 @ $10.00 = $800 (specific lot cost)

Remaining:
LOT-A: 20 @ $10.00 = $200
LOT-B: 50 @ $12.00 = $600
LOT-C: 75 @ $11.50 = $863

Serial Number Tracking

Purchase with Serial Numbers

Serial Number Receipt
─────────────────────────────────────────────────────────────────

Item Receipt #IR-001
├── Item: High-Value Equipment
├── Quantity: 3
├── Serial Numbers:
│ ├── SN-001: $1,000.00
│ ├── SN-002: $1,050.00
│ └── SN-003: $980.00
└── Total: $3,030.00

Each serial number has its own cost

GL Impact (Serial Purchase)

AccountDebitCreditWhy?
Inventory Asset$3,030Total of all serials
IRNB (or A/P)$3,030Liability for purchase

Sale with Serial Number

Serial Number Sale
─────────────────────────────────────────────────────────────────

Invoice #INV-001
├── Item: High-Value Equipment
├── Serial Number: SN-002
└── Cost: $1,050.00 (specific to SN-002)

COGS is the exact cost of SN-002
Not an average, not oldest, not newest
The ACTUAL cost of that specific unit

GL Impact (Serial Sale)

AccountDebitCreditWhy?
COGS$1,050Actual cost of SN-002
Inventory Asset$1,050Remove specific unit

Lot Number Tracking

Purchase with Lot Numbers

Lot Number Receipt
─────────────────────────────────────────────────────────────────

Item Receipt #IR-002
├── Item: Chemical Product
├── Lot Number: LOT-2024-001
├── Quantity: 500 units
├── Unit Cost: $8.50
├── Total: $4,250
└── Expiration: 2025-06-30

All units in lot have same cost ($8.50)

Sale from Specific Lot

Lot Number Sale
─────────────────────────────────────────────────────────────────

Invoice #INV-002
├── Item: Chemical Product
├── Lot Number: LOT-2024-001
├── Quantity: 100 units
└── COGS: 100 @ $8.50 = $850

Must specify which lot is being sold
COGS from that lot's specific cost

When to Use

Serial Numbers Required

ScenarioExample
High-value itemsElectronics, machinery
Warranty trackingNeed to know purchase date
RecallsMust identify specific units
Asset trackingFixed assets, equipment
RegulatoryMedical devices, aircraft parts

Lot Numbers Required

ScenarioExample
Expiration datesFood, pharmaceuticals
Batch productionManufacturing lots
Quality issuesTrack back to production batch
FIFO enforcementEnsure oldest lots sold first

Expiration and FEFO

FEFO (First Expired, First Out)

FEFO with Lot Tracking
─────────────────────────────────────────────────────────────────

Lots with Expiration:
LOT-A: 100 units, Expires: 2024-03-15 ← Sell first
LOT-B: 50 units, Expires: 2024-05-20
LOT-C: 75 units, Expires: 2024-04-01

Sale of 80 units:
System suggests LOT-A (expires soonest)
COGS: 80 @ LOT-A cost

Transfers with Lot/Serial

Lot Transfer
─────────────────────────────────────────────────────────────────

Transfer Order:
From: Warehouse A
To: Warehouse B
Item: Chemical Product
Lot: LOT-2024-001
Quantity: 50 units

Lot number and cost follow the inventory:
Warehouse B receives LOT-2024-001 at same cost

Inventory Adjustments

Adjustment with Serial Numbers

Serial Adjustment
─────────────────────────────────────────────────────────────────

Adjustment (decrease):
Item: High-Value Equipment
Serial Number: SN-003
Reason: Damaged

GL Entry:
Inventory Loss $980 Dr ← Actual cost of SN-003
Inventory $980 Cr ← Remove specific unit

Adjustment with Lot Numbers

Lot Adjustment
─────────────────────────────────────────────────────────────────

Adjustment (decrease):
Item: Chemical Product
Lot: LOT-2024-001
Quantity: 20 units
Reason: Expired

GL Entry:
Write-Off Expense $170 Dr ← 20 @ $8.50 lot cost
Inventory $170 Cr ← Remove from lot

Advantages and Disadvantages

Advantages

AdvantageDescription
Exact costKnow true cost of each sale
TraceabilityFull audit trail
ComplianceMeet regulatory requirements
WarrantyLink to purchase date

Disadvantages

DisadvantageDescription
ComplexityMore data entry
ProcessingSlower transactions
SelectionMust choose specific unit/lot
StorageMore data stored

Quick Reference

Lot vs Serial

AspectLot NumberSerial Number
QuantityMany units per lotOne unit per serial
CostSame for all in lotUnique per serial
TrackingBatch levelUnit level
Use caseBulk goodsHigh-value items

GL Summary

TransactionCost Used
PurchaseActual purchase cost
SaleSpecific lot/serial cost
TransferOriginal lot/serial cost
AdjustmentSpecific lot/serial cost

Next Steps