How to Track Batch and Expiry Dates in TallyPrime

Batch and expiry tracking in TallyPrime allows you to manage inventory lot-wise and monitor product shelf life. Enable batch tracking at the stock item level, then record batch numbers and expiry dates during purchase and sale transactions.

What Is Batch and Expiry Tracking?

Batch and expiry tracking is a core inventory feature in TallyPrime that lets you track stock by lot number or batch code and monitor expiry dates. This is essential for industries like pharmaceuticals, food and beverages, cosmetics, and fast-moving consumer goods (FMCG) where shelf life and product rotation matter. When batch tracking is enabled on a stock item, every purchase receipt, sales invoice, and stock transfer must include batch number and expiry date. TallyPrime then maintains a detailed ledger of which batch is in which godown, how much quantity remains, and when it expires. This helps you comply with regulatory requirements, reduce waste, and ensure first-in-first-out (FIFO) stock rotation.

Why Batch and Expiry Tracking Matters

Regulatory compliance is the primary driver. Pharma, food, and FMCG companies must track batch numbers for traceability and recall management. If a product issue arises, you can quickly identify which batches are affected and which customers received them. From a business perspective, batch tracking prevents expired stock from being sold, reduces write-offs, and improves customer trust. It also helps you optimize stock rotation and identify slow-moving batches. For audit and GST purposes, batch-wise records provide transparency and support your inventory reconciliation.

How to Enable Batch Tracking on a Stock Item

Batch tracking is enabled at the individual stock item level, not globally. Open TallyPrime and navigate to Gateway of Tally > Create > Inventory Masters > Stock Item. If the item already exists, press Alt+B to edit it. In the stock item master form, scroll down to the Batch Details section. You will see a field labeled "Batch Tracking." Set it to "Yes." Once you save the item, TallyPrime will require batch and expiry information for all future transactions involving that item. If you want to track expiry dates as well, the Batch Details section will also show an "Expiry Date Tracking" option. Set it to "Yes" too. Save the item master. From now on, every purchase order, purchase receipt, sales invoice, and stock transfer must include batch number and expiry date for this item.

Setting Up Batch Details in the Stock Item Master

When you enable batch tracking, TallyPrime adds a Batch Details section to the stock item master. Here you can configure how batches are handled. The key fields are: Batch Tracking (Yes/No), Expiry Date Tracking (Yes/No), and optionally a default expiry date format or batch naming convention. Some businesses use sequential batch numbers (B001, B002), others use date-based codes (20250115-001). TallyPrime does not enforce a format, so you can use any naming scheme that suits your business. If you enable Expiry Date Tracking, you must enter an expiry date for each batch during purchase. TallyPrime will then use this date in stock reports and alerts.

Recording Batch Details During Purchase

When you create a purchase receipt or purchase invoice for a batch-tracked item, TallyPrime will prompt you to enter batch number and expiry date. In the purchase invoice form, after selecting the item, press Tab or Enter to move to the Batch field. Type the batch number (e.g., "BATCH-2025-001"). Then move to the Expiry Date field and enter the date in the format DDMMYYYY or use the date picker. For example, if the product expires on 31 December 2026, enter 31122026. TallyPrime will store this batch and expiry date against the quantity you are receiving. If you receive multiple batches in one invoice, add separate line items for each batch, even if the item and quantity are the same. This ensures accurate batch-wise tracking.

Recording Batch Details During Sale

When you create a sales invoice for a batch-tracked item, you must specify which batch is being sold. TallyPrime does not automatically pick the oldest batch (FIFO), so you must manually select the batch. In the sales invoice form, after selecting the item, move to the Batch field and enter the batch number. TallyPrime will then show the available quantity for that batch. Enter the sale quantity. If you want to sell from multiple batches in one invoice, add separate line items for each batch. This manual selection gives you control but also requires discipline to enforce FIFO. Many businesses use a separate process or checklist to ensure older batches are sold first.

Batch-Wise Stock Reports

To view your current stock by batch, go to Gateway of Tally > Display > Statements of Inventory > Stock Items. Select the item you want to review. TallyPrime will show a list of all batches, quantities on hand, and expiry dates. You can also generate a Batch-wise Stock report by going to Gateway of Tally > Display More Reports > Inventory > Batch-wise Stock. This report shows all batches across all items (if you have multiple batch-tracked items), their quantities, godowns, and expiry dates. Use this report regularly to identify batches nearing expiry and plan clearance sales or write-offs.

Worked Example: Batch and Expiry in Action

Let us walk through a real scenario. ABC Pharma Ltd in Purnea uses TallyPrime Gold to manage inventory. They sell Paracetamol 500mg tablets. On 5 January 2025, they receive 1000 tablets in Batch A-2025-001, expiring 30 June 2026. On 12 January 2025, they receive 500 tablets in Batch A-2025-002, expiring 31 August 2026. On 20 January 2025, they sell 600 tablets. They manually select Batch A-2025-001 (the older batch) for 600 tablets. After this sale, their stock report shows: Batch A-2025-001 has 400 tablets remaining (expiry 30 June 2026), and Batch A-2025-002 has 500 tablets (expiry 31 August 2026). On 25 June 2026, they run a Batch-wise Stock report and see Batch A-2025-001 is expiring in 5 days with 400 tablets still in stock. They create a stock journal to write off these 400 tablets as expired inventory. This keeps their records accurate and compliant.

Batch Tracking and Godowns

Batch tracking works seamlessly with godowns (warehouses) in TallyPrime. Each batch can be stored in multiple godowns, and TallyPrime tracks quantity by batch and godown. For example, Batch A-2025-001 might have 300 tablets in Godown-1 and 100 tablets in Godown-2. When you create a stock transfer between godowns, you specify the batch, and TallyPrime updates the batch-wise stock in each godown. This is useful for multi-location businesses or those managing central and branch warehouses. Use the Batch-wise Stock by Godown report to see this breakdown.

Batch Tracking and Stock Journals

Stock journals are used to adjust batch-wise stock for reasons like damage, theft, or expiry write-offs. To create a stock journal for a batch-tracked item, go to Gateway of Tally > Create > Inventory Vouchers > Stock Journal. Select the item, enter the batch number, and specify the quantity adjustment (positive for receipt, negative for issue). For example, if 50 tablets from Batch A-2025-001 are damaged, create a stock journal with a negative quantity of 50 for that batch. TallyPrime will reduce the batch-wise stock accordingly. Learn more about stock journals in TallyPrime for detailed guidance.

Batch Tracking and GST

Batch and expiry tracking do not directly affect GST calculations in TallyPrime. GST is applied at the item level based on the HSN code and tax rate, not the batch. However, batch information is useful for GST compliance because it supports traceability. If you need to file a GST return or respond to a GST audit, batch-wise records help you prove that you sold genuine, non-expired products. Enable GST in TallyPrime by pressing F11 (Settings) and setting the GST flag to "Yes." Then configure tax rates for your items. Batch details will be recorded alongside GST information in your invoices and reports.

Best Practices for Batch and Expiry Management

First, enforce FIFO discipline. Train your sales team to always select the oldest batch first. Use batch-wise stock reports weekly to monitor expiry dates. Second, use consistent batch naming. Pick a format (date-based, sequential, or supplier-based) and stick to it. Third, create a write-off policy for expired stock. Define a process for identifying expired batches, creating stock journals to remove them, and documenting the reason. Fourth, reconcile batch-wise stock regularly with physical counts. Discrepancies may indicate data entry errors or theft. Fifth, use stock item masters correctly. Ensure batch tracking is enabled only for items that require it. Enabling it for non-perishable items adds unnecessary complexity.

Batch Tracking Limitations and Workarounds

TallyPrime does not automatically prevent sales of expired stock. You must manually check expiry dates before invoicing. There is no built-in alert system that stops you from selling a batch past its expiry date. To work around this, run Batch-wise Stock reports before creating sales invoices and filter out expired batches. Some businesses use a pre-sales checklist or a separate inventory management app integrated with TallyPrime. Also, TallyPrime does not support fractional batches. If you split a batch (e.g., 500 tablets from a batch of 1000), both portions are treated as the same batch with the same expiry date. This is usually acceptable, but if you need to track sub-batches, you may need a custom solution.

Batch Tracking in TallyPrime Silver vs Gold

Batch and expiry tracking is available in both TallyPrime Silver and Gold editions. There is no separate module or add-on cost. Silver (single-user, perpetual licence at Rs 22,500 + 18% GST) and Gold (unlimited users on LAN, Rs 67,500 + 18% GST) both include full batch tracking functionality. The difference is in the number of concurrent users and network scope. Choose Silver if you are a small business with one or two staff members. Choose Gold if you have multiple users across a network. Both include 1 year of Technical Support Service (TSS) free. After that, TSS renewal is Rs 4,500 per year for Silver and Rs 13,500 per year for Gold (plus GST). These prices are indicative for 2026.

Batch Tracking on Tally on Cloud

If you use Tally on Cloud, batch and expiry tracking works exactly the same as on-premise TallyPrime. You access TallyPrime via secure RDP on Windows, Mac, Linux, Android, or iOS. Your batch data is stored on the cloud server with daily backups and ~99.9% uptime. Tally on Cloud pricing starts from Rs 175-290 per user per month (bring-your-own-licence) or Rs 899-1,299 per month (with licence included). Batch-wise reports are generated on the cloud server and available instantly. This is ideal if you have multiple locations or remote staff who need to access inventory data.

Getting Help with Batch and Expiry Setup

If you are new to TallyPrime or need hands-on help setting up batch and expiry tracking, Global IT Care, a Tally 3 Star Certified Partner in Purnea, Bihar (since 2010), can guide you. We have trained hundreds of businesses in Purnea and surrounding areas to use batch tracking for compliance and efficiency. Whether you are on TallyPrime Silver, Gold, or Tally on Cloud, we can help you configure stock items, train your team, and optimize your batch management process. Contact us today at +91 75469 00951 for a free consultation or to schedule a training session.