FIFO Perpetual

FIFO Perpetual is one of the stock valuation methods used for calculating closing balance of inventory in Tally.ERP 9. The inventory reports use valuation methods in case of intra-year reporting.

In this intra-year reporting, when books are closed at the end of a financial year, closing balance is carried forward to next financial year. Thus inventory reports use the values from closing balance for reporting in the new financial year.

FIFO Perpetual valuation method helps in carrying forward balances based on actual purchase costs and it displays the cost/consumption values in inventory reports of the new financial year accordingly.

For example ,

Scenario 1: Valuation method - FIFO

The closing balance for the stock item at the time of closing of books:

Transaction

Item

Quantity

Rate

Value

Purchase

00001

100

100

10000

Purchase

00001

100

120

12000

Item: 00001

Quantity: 200

Value: 22000

When stock item 00001 is used in the new financial year, the inventory reports will display the cost /consumption value of these items at the rate - 100 (Rate= 22000 (Value)/200 (Quantity) .

Scenario 2: Valuation Method – FIFO Perpetual

Transaction

Item

Quantity

Rate

Value

Purchase

00002

100

100

10000

Purchase

00002

100

120

12000

The closing balance for the stock item at the time of closing of books:

Item: 00002

Quantity: 200

Value: 22000

When stock item 00002 is used in the next financial year, the inventory reports will display the cost/consumption value at the rate – 100 for the first batch of stock and 120 for the second batch i.e. based on the actual purchase price.