HomeTurbodata Business IntelligenceTurbodata predictive analyticsTally Data ConsolidationNavision Business IntelligenceData Capture ServicesData CleaningData Normalization-Data CompressionDashboard and Report Design-Data MiningManagement TeamContact UsCase Studies-Turbodata

FIFO/LIFO Valuation-Tally

FIFO valuation implies that the items that are first to be purchased(put on shelf) are the first to be sold. That is the oldest goods are sold first. This is valid for those firms where inventory is perishable.

When could FIFO be used?

·         When inventory is perishable.

·         When the prices are going up, then FIFO gives a lower Cost of Goods sold.

·         In case the prices are going down then FIFO should also help in lowering the tax liabilities.


LIFO valuation: LIFO valuation implies that the items to be put last on the shelf are to be sold first.

What are the implications of LIFO?

·         In case the prices are going up it should help lower tax liability.

·         It could inflate profit margins


Moving average method: This is defined as follows:

Beginning inventory+net purchases-Cost of goods sold=ending inventory.

Most of the softwares help correctly give the moving average valuation.


How can M&N Business Intelligence help?

·         M&N Business Intelligence has developed modules for calculation to LIFO/FIFO and moving average calculation. Our logic incorporates entries without batches also.

·         We can consolidate the data from multiple data sources to give accurate inventory valuation. We can also provide changes in the LIFO/FIFO valuation due to changes in vouchers over periods in time.


·         Our logic incorporates returns, godown transfer, items with batches and without batches and so on.

The revised Cost of Goods sold entries could then be used as part of the profit and loss statements.

The case studies using various Business Intelligence tools are attached herewith.