HomeTallyPrimeInventoryMarket Valuation Methods

 

Table of Contents

 

Market Valuation Methods in TallyPrime

With the various valuation methods offered by TallyPrime, you will be able to determine the best sale price for your stock items.

The following methods will help you in setting appropriate selling rates for your closing stock.

At Zero Price

If you select this valuation method, by default there will be no rate included when recording the voucher. You have to decide the price at which you should sell each item and key in the rate.

Average Price

Using this method, you will be able to derive the average rate at which you will sell the stock item and yield maximum profit. The average price for selling the stock items is calculated by dividing the total amount at which the stock items were sold by the total quantity of the item sold so far.

In TallyPrime, this is the default valuation method for deciding the price at which stock items may be sold. 

Initially, you will have to key in the rate at which you will sell the stock item. Later on, TallyPrime will calculate the average price for the item and show it in the invoice. Whenever you want to change the rate, you can key in a different rate. Going forward, the average price will be calculated considering the revised rates too.

Assume that you are selling ball pens at varied rates over a period of time.

Date Quantity Rate Amount

10.10.2022

(first sale)

10

10

(keyed in)

100

20.10.2022

(second sale)

10

12

(keyed in)

120

30.10.2022

(third sale)

15

11

[calculated as (100+120)/20]

165

08.11.2022

(fourth sale)

15

14

(keyed in)

210

10.12.2022

(fifth sale)

10

12.5

[calculated as (100+150+165+210)/50]

125

The selling price of the stock item is calculated by multiplying the average price and the quantity. 

Last Sales Price

Under this method, the selling price of the stock item is based on the last price at which the stock item was sold. When you make multiple sales of the same product over a period of time, due to reasons such as inflation, seasonal variation, increase in demand, limited availability, and so on, the price of the product may fluctuate. In this case, the last sale price will be shown for reference while deciding the selling price of the stock item.

Initially, you will have to key in the rate at which you will sell the stock item. Later on, TallyPrime will show the last selling price for the item in the voucher. Whenever you want to change the rate, you can key in a different rate.

Consider that you have sold sneakers at varied rates over a period of time. The following table shows the last sales price that TallyPrime shows in the voucher.

Date Quantity Rate Displayed Rate Entered Amount

25.06.2022

(first sale)

50 — 400 20000
30.11.2022 100 400 450 45000
13.12.2022 200 450 — 90000
25.12.2022 150 450 500 75000

On selecting this valuation method, the price at which the sneakers were sold earlier will be prefilled in the voucher. You can change the selling price as required.

Standard Price

You can set standard prices for the stock items. The standard price of an item is set after adding charges like the cost of raw materials, production costs and other overhead charges that were required to make the final product.
Suppose you sell jute bags and due to the increasing price of jute, you decide to increase the price of the jute bags. After adding the overhead charges, you list the items for sale based on the set standard price. Thereafter, the sale will be done as per the prevailing standard price.

Date Quantity Rate per Item Amount
01.09.2022 30 300 9000
10.12.2022 50 400 20000
03.03.2023 50 550 27500

In this case, the sale will be at the rate of 300 until 10.12.2022. Then, the rate will change to 400 and will continue till 03.03.2023. Thereafter, the rate will change to 550.

 

Is this information useful?
YesNo
TallyHelpwhatsAppbanner
Is this information useful?
YesNo
TARA