Try ERPNext Try Frappe Cloud Buy Support Partners Foundation

Stock Adjustment Effect

When we took profit and loss account, there are several entries of stock adjustment being entered automatically by the system. These entries seem to come in when we do material transfer. But I fail to understand how these are calculated and what effect it is having on our profit and loss statement.

Hi Tejas,

I’m guessing you have enabled perpetual inventory. Perpetual Inventory means that every stock transaction has a corresponding accounting transaction.

So, if you did any Stock Entry Purpose Material Issue or Material Receipt. Or when you did a manufacturing entry, the total incoming valuation of the material has to balance with the outgoing valuation (the concept behind double entry book keeping).

So when there is an imbalance (typically in Material Issue/Receipt or when the sum of valuation of the manufactured items is different from the sum of valuations of the input items, the Difference Account is automatically charged for the Imbalance account. Now if the account you used there was a P&L account, it would affect your P&L.

You have to analyze the entries into the Difference Accounts you’ve used, see why those entries occurred in the first instance, and then make appropriate adjustment entries.

Hope this helps.

Thanks

Jay

@JayRam
In What scenario would there be a difference amount on Material Transfer?

There are no additional costs for transfer , the stock is just going from one warehouse to another , but at times it still shows me an entry for stock adjustment against stock in hand , sometimes in credit or debit .

I am failing to understand what can be the reason for this amount when an item is just going from one warehouse to another .

Hi Taher,

You have to see why Material Transfer is posting entries. Usually you will have a debit and credit entries for the same amount which is equivalent to the valuation of the items in the source warehouse. Sometimes if you have the Valuation Rate of the item set in the Item Master you may end up posting entries to the ledger to balance the incoming and outgoing rates.

I am afraid you have to painstakingly analyze the transactions that are getting posted to the difference account and try and figure out why this is happening.

My clients complain about these things too, but so far, there has always been a reason that ERPNext has posted such ledger entries, and there has been a way to prevent that going forward.

Hope this helps.

Thanks

Jay