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​