How to Manage Batch Wise Inventory for Expiry Based Products
Managing inventory becomes challenging when products have different manufacturing dates, expiry dates, and shelf lives. A business may have hundreds of units of the same product, but each batch can have a different expiry timeline. Without proper tracking, businesses risk selling expired products, losing money on dead stock, or failing to identify which items need immediate attention.
A proper batch wise inventory management system helps retailers, wholesalers, distributors, pharma businesses, and FMCG sellers track every product batch from purchase to sale. It records batch numbers, manufacturing dates, expiry dates, available quantities, and stock movement.
For businesses dealing with medicines, food products, cosmetics, beverages, or other expiry-based goods, accurate expiry stock management is essential for reducing wastage and maintaining customer trust. Modern billing and inventory systems help automate this process by connecting stock tracking with purchases, sales invoices, reports, and alerts.
Key Takeaways
- Batch-wise inventory tracks products based on unique batch numbers instead of only product names.
- Manufacturing dates and expiry dates help businesses identify ageing stock.
- FEFO (First Expiry, First Out) is generally more suitable than FIFO for expiry-based products.
- Near-expiry alerts help businesses take action before stock becomes a loss.
- Inventory software can connect batch tracking with billing, stock reports, and GST workflows.
What Is Batch Wise Inventory Management?
Batch wise inventory means maintaining separate stock records for every batch or lot of a product. Instead of showing only “100 units of Product X,” the system records details such as:
Product | Batch Number | Manufacturing Date | Expiry Date | Quantity |
Vitamin Tablets | VT2601A | Jan 2026 | Jan 2028 | 200 boxes |
Protein Powder | PP2603B | Mar 2026 | Mar 2027 | 75 jars |
Packaged Juice | PJ2605C | May 2026 | Nov 2026 | 150 cartons |
For example, a pharmacy may receive the same medicine from a supplier three times during the year. Each purchase may have a different batch number and expiry date. A batch tracking system allows the pharmacy owner to know which batch should be sold first and which products are approaching expiry.
Businesses can maintain these details while adding products and managing stock through inventory software. GimBooks supports product-level stock management with options such as batch-wise inventory and low stock alerts during product setup. adding products with inventory details in GimBooks
How to Track Batch Numbers and Expiry Dates in Inventory
Effective batch and expiry management begins when products are received and continues until they are sold, returned or removed from inventory.
Step 1: Record Batch Details During Purchase
When stock arrives, record the product name, batch number, manufacturing date where applicable, expiry date, purchase quantity and supplier details.
Different batches of the same product should have separate records, even when their selling prices are identical.
Step 2: Maintain Batch-Wise Stock Quantities
Track opening stock, purchases, sales, returns and adjustments for each batch.
For example, if Batch A contains 100 units and 25 units are sold, its available quantity should reduce to 75 units without affecting Batch B.
Step 3: Select the Correct Batch During Billing
Employees should select the batch actually being dispatched. This ensures that inventory records reflect physical stock movement.
For businesses managing large product catalogues, accurate product-master setup is important. Refer to GimBooks' guide to adding products in billing software for product setup information.
Step 4: Monitor Expiry Dates
Review batches approaching their expiry dates and identify products requiring permitted sales, transfers, supplier returns or other action.
Step 5: Reconcile Physical and Recorded Stock
Compare batch-wise reports with physical quantities regularly. Investigate incorrect batch selection, missing returns, damaged goods and unrecorded adjustments.
Following this process helps businesses maintain accurate batch tracking inventory rather than relying only on total product quantities.
Why Expiry Based Businesses Need Batch Tracking
Expiry-based businesses face unique inventory challenges:
1. Prevent Expired Stock Losses
Without batch tracking, expired products can remain unnoticed in warehouses or shelves. This is common in industries where products have short shelf lives, such as:
- Pharmaceuticals
- Food and beverages
- Cosmetics
- Nutritional supplements
- FMCG products
Tracking expiry dates allows businesses to identify products that require faster movement, supplier returns, discounts, or promotional clearance.
2. Improve Stock Rotation
Proper stock rotation ensures older or earlier-expiry batches are sold before newer inventory arrives.
For example:
A distributor receives:
- Batch A: Expires March 2027
- Batch B: Expires November 2026
Even if Batch A arrived first, Batch B should be prioritised because it has an earlier expiry date.
This is where FEFO inventory management becomes important.
FEFO vs FIFO: Which Inventory Method Works Better?
Businesses often confuse FIFO and FEFO methods. Both help maintain stock movement discipline, but they work differently.
Method | Meaning | Suitable For |
FIFO | First In, First Out. Older purchased stock is sold first. | General inventory, non-expiry products |
FEFO | First Expiry, First Out. Products with earliest expiry are sold first. | Pharma, FMCG, food, healthcare products |
For expiry-based products, FEFO is usually more practical because the priority is reducing expiry risk rather than only selling older purchases.
A pharma distributor may have a recently purchased batch that expires sooner than an older batch. FEFO ensures the shorter shelf-life product moves first.
How Does FEFO Work in Batch-Wise Inventory Management?
In FEFO inventory management, products with the earliest expiry dates are prioritised for sale or dispatch, even if they were purchased later.
For example, a medical store receives two batches of the same medicine:
Batch | Received On | Expiry Date | Stock |
MED-101 | 5 October 2026 | June 2027 | 100 units |
MED-102 | 15 October 2026 | March 2027 | 80 units |
Although MED-101 arrived first, MED-102 should normally be selected first because it expires earlier.
This helps pharmacies, FMCG distributors and supplement sellers reduce the risk of leaving older-expiring stock unsold.
However, FEFO should apply only to batches eligible for sale. Expired, recalled or quarantined products must be excluded from normal stock selection.
Businesses should verify that their batch-wise inventory software supports accurate batch selection during billing and updates the quantity of the batch actually sold.
How to Manage Batch Wise Inventory for Expiry Based Products
1. Assign a Unique Batch Number to Every Product Lot
Every incoming stock batch should have:
- Product name
- Batch number
- Supplier details
- Purchase date
- Manufacturing date
- Expiry date
- Quantity received
- Purchase price
This creates complete visibility from supplier purchase to customer sale.
2. Record Manufacturing and Expiry Dates During Stock Entry
Incorrect expiry information can create major inventory problems.
During purchase entry, businesses should verify:
- Batch number printed on the product
- Manufacturing date
- Expiry date
- Available quantity
- MRP and purchase price
For pharma inventory billing, accurate batch information is especially important because medicines with different expiry dates should not be mixed together.
3. Use Near Expiry Stock Reports
A near-expiry stock report helps businesses identify products that may expire before they are sold.
Instead of checking expiry dates manually, businesses can maintain a report showing the product name, batch number, available quantity, expiry date and stock value.
Product | Batch Number | Available Stock | Expiry Date | Recommended Action |
Vitamin Tablets | VT-102 | 120 units | 15 December 2026 | Urgent review |
Protein Powder | PP-205 | 45 units | 20 January 2027 | Check demand |
Packaged Juice | PJ-301 | 80 units | 10 February 2027 | Monitor stock |
Illustrative inventory data.
Set Expiry Alerts Based on Product Shelf Life
Businesses can configure internal alert periods such as:
- 90 days before expiry: Review stock levels and sales movement.
- 60 days before expiry: Identify slow-moving batches and supplier-return options.
- 30 days before expiry: Prioritise urgent permitted action.
- After expiry: Block sales and segregate the affected stock.
These are suggested monitoring periods, not universal legal requirements.
Calculate Near-Expiry Stock Value
Use the formula:
Near-Expiry Stock Value = Available Batch Quantity × Unit Purchase Cost
For example, if 50 units remain in a batch and each unit costs ₹200, the stock value at risk is ₹10,000.
Tracking both quantity and value helps businesses prioritise expensive batches and improve expiry date inventory management.
Managing Expired and Near-Expiry Stock
A strong expiry stock management process should include:
Identify
Review batch reports regularly to find products nearing expiry.
Take Action
Depending on business policies, owners can:
- Move products faster through sales campaigns
- Return eligible stock to suppliers
- Separate damaged or expired products
- Adjust purchasing decisions
Prevent Repeat Issues
Analyse why stock expired:
- Overstocking
- Incorrect demand forecasting
- Slow product movement
- Poor stock rotation
How to Manage Expired Stock, Batch Returns and Product Recalls
Expired inventory should not remain mixed with products available for normal sale.
Businesses dealing with medicines, packaged food, cosmetics and supplements should maintain clear batch statuses to prevent unsuitable stock from being dispatched.
Separate Saleable and Non-Saleable Batches
Maintain statuses such as:
Batch Status | Recommended Action |
Active | Available for sale |
Near Expiry | Review remaining shelf life and sales movement |
Quarantined | Hold for inspection or further decision |
Expired | Block sales and arrange authorised return or disposal |
Recalled | Stop dispatch and identify affected stock |
Track Supplier Returns by Batch Number
When returning near-expiry, damaged or otherwise eligible stock to a supplier, record the batch number, returned quantity and supporting documentation.
The returned quantity should be deducted from the correct batch.
Maintain Batch Traceability During Product Recalls
If a manufacturer recalls a particular batch, businesses should be able to identify how much stock remains and which sales invoices included that batch.
For example, if Batch MED-205 is recalled, the inventory records should help the business identify:
- Total quantity purchased
- Remaining stock
- Quantity already sold
- Customers or locations supplied
- Returned or recovered quantity
This makes batch tracking inventory valuable for product traceability as well as expiry management.
Returned products should not automatically be added back to saleable inventory without the appropriate checks.
How Billing Software Helps With Batch Wise Inventory
Manual registers and spreadsheets become difficult when businesses manage hundreds of products. Inventory connected with billing helps maintain accuracy because every sale automatically updates stock.
A complete workflow looks like this:
Business Activity | Inventory Update |
Purchase entry | New batch added with quantity and expiry |
Sales invoice creation | Sold quantity deducted from selected batch |
Stock review | Remaining quantity visible batch-wise |
Reports | Identify low stock and expiry risks |
For distributors and wholesalers, combining billing with inventory management helps manage bulk orders, stock levels, batch numbers, expiry dates, and business reports from one system. GimBooks Distributor Billing Software
Batch-Wise Inventory Excel Format for Expiry-Based Products
Small businesses can start with a batch-wise inventory Excel sheet to record stock quantities and expiry dates.
A basic sheet should contain:
Column | Field |
A | Product Name |
B | Batch Number |
C | Manufacturing Date |
D | Expiry Date |
E | Opening Stock |
F | Purchases |
G | Sales |
H | Supplier Returns |
I | Damaged/Expired Write-offs |
J | Available Stock |
K | Days Until Expiry |
Formula for Available Batch Stock
If opening stock is in E2, purchases in F2, sales in G2, supplier returns in H2 and write-offs in I2, use:
=E2+F2-G2-H2-I2
Formula for Days Until Expiry
If the expiry date is in D2, use:
=D2-TODAY()
This helps identify batches approaching expiry.
While spreadsheets can work for smaller inventories, they require careful manual updates. Businesses handling frequent transactions or multiple batches may benefit from batch-wise inventory software that connects purchase records, billing and stock movements.
For related inventory setup guidance, read How to Add Products in GimBooks Billing Software.
Features to Look for in Batch-Wise Inventory Software
Businesses handling expiry-based products should select inventory software that can track individual batches instead of maintaining only total stock quantities.
Important features include:
- Batch number tracking: Maintain separate records for different product lots.
- Manufacturing and expiry dates: Record important product shelf-life information.
- Batch selection during billing: Deduct stock from the batch actually sold.
- Near-expiry reports: Identify batches approaching their expiry dates.
- FEFO inventory management: Support earlier-expiring eligible stock being dispatched first.
- Batch-wise stock reports: View available quantities and stock movement.
- Purchase and sales returns: Record returns against the correct batches.
- GST billing integration: Connect sales invoices with inventory updates.
- Stock adjustment records: Track damaged, expired and written-off quantities.
- Batch traceability: Identify affected stock during quality complaints or recalls.
For medical retailers, the selection process should also consider pharmacy-specific billing and inventory requirements. Read GimBooks' guide to GST invoice software for medical stores for related considerations.
Before choosing a solution, confirm which expiry alerts, batch-blocking and FEFO features are actually supported by the software.
Best Practices for FMCG Batch Tracking and Pharma Inventory Billing
Follow these practices to improve accuracy:
Maintain Standard Batch Naming
Use consistent batch formats so employees can identify products quickly.
Train Staff on Batch Selection
During billing, staff should select the correct batch instead of manually reducing random stock quantities.
Review Expiry Reports Weekly
Regular monitoring prevents last-minute losses.
Avoid Overstocking Slow-Moving Products
Purchase decisions should consider previous sales patterns and current stock levels.
Use Low Stock Alerts
Low stock notifications help businesses reorder fast-moving products while avoiding unnecessary excess inventory.
Common Mistakes in Expiry Stock Management
Tracking Only Product Quantity
Knowing “500 units available” is not enough when products have different expiry dates.
Ignoring Near Expiry Products
Businesses often notice expiry issues only after products become unsellable.
Mixing Multiple Batches Together
Combining batches removes visibility and increases the chances of incorrect sales.
Using Manual Records Without Regular Updates
Delayed updates create differences between actual warehouse stock and system records.
FAQs
1. What is batch wise inventory management?
Batch wise inventory management is a method of tracking stock separately based on batch numbers, manufacturing dates, expiry dates, and quantities. It helps businesses monitor product movement and expiry timelines accurately.
2. Why is batch tracking important for pharma and FMCG businesses?
Batch tracking helps pharma and FMCG businesses identify product expiry dates, manage stock rotation, reduce wastage, and maintain accurate sales and purchase records.
3. Should expiry-based businesses use FIFO or FEFO?
Businesses dealing with expiry products should generally follow FEFO because products with the earliest expiry date are sold first, reducing the risk of expired inventory.
4. How can businesses manage expired stock?
Businesses should identify expired batches through stock reports, separate them from active inventory, follow return or disposal processes, and review purchasing patterns to prevent future losses.
5. Can inventory software track batch numbers and expiry dates?
Yes, inventory software can help businesses record batch details, monitor expiry dates, generate stock reports, and connect inventory updates with billing processes. GimBooks Medical Billing Software
6. How does batch tracking help with GST billing?
Batch tracking improves inventory accuracy while GST billing software helps businesses create invoices, maintain sales records, and manage tax-related reporting workflows.
7. Which businesses need batch wise inventory management?
Pharmacies, medical distributors, FMCG wholesalers, grocery businesses, food manufacturers, cosmetics sellers, and healthcare product retailers benefit from batch-wise inventory management.
Manage Expiry-Based Inventory More Efficiently with Batch Tracking
Managing expiry-based inventory requires more than counting available stock. Businesses need visibility into every batch, expiry date, and stock movement. With proper batch tracking, FEFO-based rotation, expiry reports, and connected billing workflows, retailers and distributors can reduce wastage and improve inventory control. GimBooks helps businesses manage billing, inventory tracking, stock reports, and batch-related workflows in a more organised way.