Accounting for Inventory Adjustment

The inspection and control of the quantity and quality of storable products in the warehouse is an important part of the business activities of the Enterprise. However, whether the product inventory is carried out at scheduled intervals or at any time according to the needs and the type of business that the Enterprise follows, the discovery of excess and loss of goods in the warehouse is inevitable.

Viindoo All-in-one Enterprise Management Solution supports accountants and warehouse managers in managing and dealing with the loss/excess of products during the inventory.

Requirements

This tutorial requires the installation of the following applications/modules:

Configuring Inventory Adjustment Location

After installing the Inventory module, you need to activate the Storage Locations feature by going to Configuration > Settings > Warehouse > Storage Locations > Save.

Activating Viindoo Storage locations

Next, you navigate to Inventory > Configuration > Locations, turn off the Internal filter then select the Virtual Locations/Inventory adjustment location.

Inventory adjustment location

Update the following information:

  • Location Type: Select Inventory Loss;

  • Accounting Information: Configure an account to record the accounting entries generated from the excess or lost value of goods.

Configuring accounting accounts for storage location in Viindoo

Accounting for loss/excess of products during Inventory Adjustment

On a monthly, quarterly, or annual basis, which depends on the plan or random warehouse inventory according to the needs of the Enterprise, you can record the inventory adjustment by navigating to Inventory > Operations > Inventory Adjustment.

To have journal entries created automatically right after a loss/excess of products is detected, you need to set up products with the Storable type and belong to a product category that has the automated inventory valuation configured.

Viindoo Inventory Adjustment

At this stage, you enter the counted quantity to create an inventory adjustment according to the adjustment time of the Enterprise.

Inventory adjusment details in Viindoo

Details of the inventory will be listed by products, on-hand quantities, counted quantities, and the difference representing the loss/excess of products after the inventory. You click Apply.

Inventory difference in Viindoo

Once the On Hand Quantity is updated with the new value.

Inventory difference in Viindoo

An accounting entry will be automatically generated to record the value corresponding to the amount of excess and lost products that had occurred after the inventory. You can view accounting entries details by navigating to Accounting > Accounting > Journal Entries and use the filter tool to search for accounting entries of the Inventory Adjustment journal.

Accounting entries for excess/loss of products after Inventory in Viindoo
In which:
  • On-hand quantities > Counted quantities: Missing products after the inventory, the generated accounting entry records the decrease in the value of products in stock.

  • On-hand quantities < Counted quantities: Excessive products after the inventory, the generated accounting entry records the increase in the value of products in stock.