Skip to content
Tutorials Center
My learning

Topics

Lesson 23 of 38 ยท Inventory

Stock Valuation Methods in Tally Prime: FIFO, Average Cost and More

Learn how Tally Prime values closing stock with average cost, FIFO, LIFO, last purchase cost and standard cost, and compare the methods with a runnable calculator.

When you sell 50 units that you bought at three different prices, which price counts as the cost of goods sold? The answer decides your profit and the value of the stock left on the shelf. This choice is the stock valuation method, and Tally Prime lets you pick one per stock item or per stock group.

Tally is not runnable here, so the menus are described and the maths is shown in labelled Python stand-ins. The numbers below come from running that code.

Where to set it

In Gateway of Tally > Alter > Stock Item (or at stock group level), find Costing Method (how the cost of goods sold is computed) and Market Valuation Method (how the stock is valued in the balance sheet). The main costing methods Tally offers are:

Method Idea
Avg. Cost Weighted average of all purchase costs so far
FIFO First in, first out: oldest purchases are consumed first
LIFO Annual / Perpetual Latest purchases are consumed first (annual or after each sale)
Last Purchase Cost Value at the most recent purchase rate
Std. Cost A fixed rate you define, with a date
Zero Cost Value at nil (rarely used)

Market valuation options include Avg. Price, Last Sale Price, Std. Price and Last Purchase Cost, and are used for the "market" side of reports that compare cost and market value. LIFO is not accepted for tax purposes in some countries; check your local rules before choosing it.

Choose a method once and apply it consistently. Changing it mid-year changes your profit and may need an accountant's approval.

A worked example

Purchases of one item during the month:

Date Qty Rate
1st 100 10
10th 100 12
20th 100 15

You sell 150 units on the 25th. Total cost bought: 100x10 + 100x12 + 100x15 = 3,700 for 300 units.

  • FIFO: consume 100 at 10 and 50 at 12 = 1,600 cost; remaining 150 units cost 50x12 + 100x15 = 2,100.
  • Average cost: average = 3,700/300 = 12.3333; cost of 150 = 1,850; remaining = 1,850.
  • LIFO (periodic): consume 100 at 15 and 50 at 12 = 2,100; remaining 100x10 + 50x12 = 1,600.

Revenue is the same under all three, so a higher cost of goods sold gives lower profit. LIFO shows the lowest profit here, FIFO the highest.

Python Stand-in: FIFO, LIFO and average cost side by side

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 FIFO 1600/2100, LIFO 2100/1600 and Average 1850.0/1850.0. In every case COGS plus closing stock equals the 3,700 total purchased, which is a good check on any valuation.

Profit under each method

If the 150 units sold for 20 each, revenue is 3,000. Gross profit is 3,000 - 1,600 = 1,400 (FIFO), 1,150 (average) or 900 (LIFO). In rising-price periods FIFO reports the highest profit and the highest closing stock; LIFO the opposite.

Python Stand-in: gross profit by method

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.

How Tally uses the method

When you save a sales voucher, the stock item's costing method works out the cost of the units sold from the earlier purchases. You see the result in:

  • Stock Summary (closing value uses the valuation method),
  • Profit and Loss Account (closing stock is deducted from purchases to get cost of goods sold),
  • Stock Item Monthly Summary and Item-wise Profitability (Gateway of Tally > Display More Reports > Statements of Inventory), with cost and margin per sale.

Remember that Tally's profit and loss uses closing stock: if the stock side is wrong (missing receipts, wrong opening balance), the profit is wrong too. The Stock Valuation Method also affects the "stock items with negative balance" calculation, so fix negative stock before relying on valuation reports.

Alternatives to consider

  • Standard cost is common in manufacturing. Define a standard rate and its effective date; differences between actual cost and standard are tracked as variances (see BOM lesson).
  • Last purchase cost is quick but swings with every new purchase, so it is not ideal for audited accounts.

Common mistakes

  1. Using different methods for the same item in different years without noting it.
  2. Selling before purchases are entered, so Tally uses the wrong cost layers until the purchase is recorded late.
  3. Ignoring freight and customs in purchase cost: add them as part of the item's landed cost (purchase Additional Cost allocation) when it affects valuation.

Check your understanding

Quick check ยท 4 questions

of 4 answered You scored / 4 ยท perfect!

  1. 1. In a period of rising prices, which method usually shows the highest profit?

    FIFO consumes the oldest, cheapest layers first, so COGS is lower and profit higher.
  2. 2. Purchases: 100 at 10 and 100 at 20. You sell 100. FIFO cost of goods sold is:

    FIFO takes the first layer: 100 x 10 = 1,000.
  3. 3. What must COGS plus closing stock equal, ignoring other adjustments?

    Whatever you bought or held at the start is either sold (COGS) or still in stock.
  4. 4. Where do you set an item's costing method?

    Costing and market valuation methods are item or group settings.

Summary

  • The valuation method decides which cost leaves stock when you sell, and so your profit and closing stock.
  • Tally offers average cost, FIFO, LIFO, last purchase cost, standard cost and more.
  • COGS plus closing stock always equals opening stock plus purchases.
  • Pick a method, apply it consistently, and keep stock entries complete and timely.

Next: Batches, expiry dates and bill of materials