# Compute the inventory valuation in P&L and BS (average costing method and manual valuation)¶

The manual inventory valuation method suggest that the valuation of an inventory has to be manage manually in financial accounting. The periodic journal entry has to be passed on regular internal so keep updated the valuation in balance sheet and cost of goods sold in profit and loss account.

On every regular internal an accounting entry has to be passed as below:

Description Debit Credit
Inventory Valuation   800
Cost of Goods Sold 800

To compute the cost of goods sold use the below formula

COGS = Inventory Valuation as per Balance sheet - Inventory Valuation as per Inventory

## Product Cost price¶

As your inventory costing method is average, you are allowed to change the cost price of the product, assumed that you increase the cost price.

Tip

Make sure you change the cost price on the product once your valuation is equal for inventory and balance sheet, else you may have a wrong cost of goods sold entry.

When you see a COGS is having a negative value it means that your value of the inventory increased in warehouse this should be reflect in the balance sheet too.

To increase the value in balance sheet you have to pass below journal entry

Description Debit Credit
Inventory Valuation 800
Inventory Valuation Difference   800

Or, when you see a COGS is having a positive value it means that your value of the inventory decreased in warehouse and this should be reflect in the balance sheet too.

To decrease the value in balance sheet you have to pass below journal entry

Description Debit Credit
Inventory Valuation   800
Inventory Valuation Difference 800