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.

Next, you navigate to Inventory > Configuration > Locations, turn off the Internal filter then select the Virtual Locations/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 > Physical Inventory.

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.

See also

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

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.

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

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.