Skip to content
Tutorials Center
My learning

Topics

Lesson 24 of 38 ยท Inventory

Batches, Expiry Dates and Bill of Materials in Tally Prime

Track batch-wise stock and expiry dates in Tally Prime, define a bill of materials, record manufacturing with a stock journal and cost the finished goods.

Some goods need more than a quantity. Medicine and food have an expiry date. Paint and fabric come in batches whose shades differ. A factory turns raw material into finished goods using a bill of materials (BOM), a recipe. Tally Prime supports all three, and this lesson shows the setup and the calculations behind them.

Tally cannot run on this site, so the screens are described and Python stand-ins illustrate the logic.

Batch-wise details

Enable Maintain batch-wise details in F11 (Features) and, if needed, Track date of manufacturing and Use expiry dates. In the stock item master set Maintain in batches to Yes. Optionally turn on Track date of manufacturing and Use expiry dates.

From then on, every voucher line for that item asks for a Batch / Lot No. You type a new batch name on a purchase (with manufacture and expiry dates), and choose an existing batch on a sale. Tally shows batches with balance, so you can sell the right one.

First expiry, first out

Tally does not force FIFO by expiry, but you can list batches in the Batch Summary and Stock Ageing reports (and the Expiring batches view in many releases) and pick the batch that expires first. The stand-in does the same:

Python Stand-in: sell from the batch that expires first (FEFO)

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

The output is [('B-100', 25), ('B-101', 25)] followed by the remaining quantities: B-101 15 left, B-100 empty, B-102 untouched.

Bill of materials

A BOM lists the components (and quantities) needed to produce one unit, or a standard batch, of a finished item. Enable Enable component list (BOM) in features, then in the finished item's master choose Set components (BOM) and enter each component with quantity per unit of output. Many releases let you give several BOMs (different recipes) a name.

Example: a gift hamper needs 1 box, 2 jars of jam and 3 sachets of tea.

TEXT
Finished item: Gift Hamper (unit: Nos)
  Components per 1 Hamper:
    Gift Box        1 Nos
    Jam Jar         2 Nos
    Tea Sachet      3 Nos

Recording production with a stock journal

Production is recorded with a Stock Journal (or a Manufacturing Journal voucher, available when BOM is enabled). When you select the finished item under Production (Destination), Tally can fill the Consumption (Source) lines automatically from the BOM, scaled to the quantity you produce. Raw materials go down, finished goods go up, and the value of the finished goods becomes the cost of the consumed material plus any additional costs (labour, power) you add to the voucher.

Python Stand-in: explode a BOM and cost the finished goods

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

The output shows material 6760.0 (40 x (25 + 120 + 24)), labour 400.0 and a cost per hamper of 179.0.

Component alternatives, by-products and scrap

Beyond the basics, a BOM can carry:

  • Alternate components, used when the primary is out of stock.
  • By-products and co-products recorded as extra items in the production section with their own value.
  • Scrap/wastage, shown as a consumption with no production, which lowers the material efficiency.

Reports to watch

  • Stock Summary with batches, to see balance by batch.
  • Stock Ageing Analysis, showing how old each stock layer is.
  • Production/Manufacturing reports and BOM reports (Gateway of Tally > Display More Reports > Statements of Inventory).
  • Item-wise profitability, comparing cost and sale price.

Common mistakes

  1. Typing batch names inconsistently (B101 vs B-101), which splits stock across fake batches.
  2. Selling an item from a batch that has expired because dates were not enabled.
  3. Forgetting additional costs on the stock journal, so finished goods are understated and profit is overstated.

Check your understanding

Quick check ยท 4 questions

of 4 answered You scored / 4 ยท perfect!

  1. 1. What does a bill of materials define?

    A BOM is the recipe: components and quantities per unit of output.
  2. 2. Which voucher records production in Tally?

    A stock journal consumes raw material and produces finished goods.
  3. 3. Why enable expiry dates for batches?

    Dates let you review expiring batches and avoid selling expired goods.
  4. 4. A hamper needs 2 jars at 60 each. Producing 10 hampers consumes jam worth:

    10 hampers x 2 jars = 20 jars; 20 x 60 = 1,200.

Summary

  • Batch tracking records batch numbers, manufacture and expiry dates in vouchers.
  • Sell expiring batches first and review ageing reports.
  • A BOM lists components per unit; stock journals consume them and produce finished goods.
  • Finished goods cost = material + additional costs; include all costs.
  • Name batches consistently to avoid fake stock splits.

Next: Enabling GST and company GST details