Tracking Stock Item Details Batch-Wise in TallyPrime: 2 Methods

TallyPrime allows you to track stock item details at a granular level by utilizing the batch functionality. This is beneficial for:

• Inventory Management: Gain insights into the quantity and value of each stock item within specific batches.
• Expiry Tracking (Perishables): Monitor expiry dates associated with each batch to prioritize older stock for sales.
• Quality Control: Track stock quality based on batches and identify potential issues.

Here’s a detailed explanation on how to track stock item details batch-wise in TallyPrime with examples:

1. Prerequisites for Tracking Stock Item Details Batch-Wise in TallyPrime:

1. Enable Batches:

Ensure the “Maintain Batches” feature is enabled in Company Features (Gateway of Tally > Accounts & Taxes > Company > Configure Features).

2. Stock Item Configuration:

The stock item you want to track should have “Maintain in Batches” enabled in its Stock Item Master (explained previously in the response on Setting Up Batches for Stock Items).

Tracking Methods:

There are two primary ways to track stock item details batch-wise in TallyPrime:

Method 1: Using the Stock Ledger Enquiry Report

1. Gateway of Tally (Alt+F12):

Launch TallyPrime and navigate to the Gateway of Tally menu.

2. Display (Alt+F8):

Select “Display” and choose “Statements of Inventory” from the submenu.

3. Stock Ledger Enquiry:

Within “Statements of Inventory,” select “Stock Ledger Enquiry.”

4. Stock Item Selection:

In the Stock Ledger Enquiry report, choose the specific stock item you want to track by batch.

5. Batch-wise Details (F8):

Press F8 (Batch-wise) to view the report categorized by batches.

6. Report Output:

The report will display details like:

• Batch Name: Identifies the specific batch for each entry.
• Date: Transaction date associated with the stock movement (purchase, sale, consumption, etc.).
• Voucher Type: Indicates the type of transaction that affected the stock quantity (e.g., Purchase Voucher, Sales Invoice).
• Inward Qty: Quantity of stock added to the specific batch.
• Outward Qty: Quantity of stock removed from the specific batch.
• Balance: Current stock quantity remaining in the batch.

2. Example: Using the Stock Ledger Enquiry Report

Tracking Paracetamol Batches

You want to track the details of “Paracetamol 500mg” (set up with batches) to monitor expiry dates.

1. Navigate to the Stock Ledger Enquiry report as described above.
2. Select “Paracetamol 500mg” as the stock item.
3. Press F8 (Batch-wise) to view the report categorized by batches.

The report will display details for each batch (e.g., Batch A, Batch B) created for “Paracetamol 500mg,” including the purchase date, expiry date (if entered), quantity received or sold, and the remaining stock quantity within each batch.

Method 2: Using the Batch Summary Report

1. Gateway of Tally (Alt+F12):

Launch TallyPrime and navigate to the Gateway of Tally menu.

2. Reports (Alt+F8):

Select “Reports” and choose “Inventory Books” from the submenu.

3. Batch Voucher:

Within “Inventory Books,” select “Batch Voucher.”

4. Stock Item Selection:

Choose the stock item you want to track by batch.

5. Batch Selection (Optional):

You can optionally select a specific batch to view details for that particular batch.

Leaving it blank displays a summary for all batches.

7. Report Output:

The Batch Summary report provides information like:

• Batch Name: Identifies the specific batch.
• Opening Balance: Stock quantity in the batch at the beginning of the selected period.
• Purchase Qty: Total quantity purchased and added to the batch during the period.
• Sales Qty: Total quantity sold from the batch during the period.
• Consumption Qty: Total quantity consumed from the batch during the period (if applicable).
• Closing Balance: Current stock quantity remaining in the batch at the end of the selected period.

3. Example: Batch Summary for Medicine

You want a general overview of the stock movement for all batches of “Paracetamol 500mg.”

1. Navigate to the Batch Summary report as described above.
2. Select “Paracetamol 500mg” as the stock item.
3. Leave the “Batch Name” field blank to view the summary for all batches.

The report will display a summary for each batch (e.g., Batch A, Batch B) created for “Paracetamol 500mg,” including the opening balance, purchase and sales quantities, and the closing stock quantity for each batch within the selected period.

4. Benefits of Batch Tracking in TallyPrime:

1. Improved Decision Making:

By analyzing batch-wise stock details, you can make informed decisions regarding:

1. Inventory Replenishment:

Identify which batches require restocking based on current stock levels and expiry dates.

2. Pricing Strategies:

Adjust pricing for specific batches nearing expiry to encourage sales.

3. Quality Control Measures:

Track the performance of different batches to identify potential quality issues and take corrective actions.

5. Additional Considerations:

1. Regular Reporting:

Generate batch-wise stock reports periodically to maintain an updated view of your inventory.

2. Physical Stock Verification:

Regularly conduct physical stock verification to ensure accuracy and reconcile any discrepancies with the batch tracking data in TallyPrime.

3. Integration with Barcode Scanners:

Consider integrating barcode scanners with TallyPrime to improve efficiency and accuracy while entering and tracking batch details during purchases and sales.

4. Third-Party Add-ons:

Explore third-party add-ons for TallyPrime that might offer advanced functionalities for batch management, reporting, and expiry alerts.

6. Conclusion:

Effective utilization of batch tracking in TallyPrime empowers you to gain a deeper understanding of your inventory at a granular level.

This translates to improved inventory management practices, better control over expiry dates (for perishable goods), and ultimately, increased profitability for your business.