Stocktaking

Stocktaking is an important tool to ensure that a company’s inventory is accurately recorded. Over time, data about the goods in stock may become inaccurate due to errors in stock entries, deliveries or sales. Stocktaking helps identify these differences and correct the data so that the recorded stock matches the actual inventory.
According to the Accounting Act § 15 (3), assets and liabilities must be inventoried at least once a year, before the end of the financial year.

A stocktaking record can be created manually or imported from a file.

Stocktaking import

Warehouse -> Stocktaking -> select “Import” from the Actions menu.

In the stocktaking preview, define the mappings. The required data fields are:

  1. stocktaking date
  2. inventoried warehouse
  3. item code
  4. counted amount

You can also enter the item’s cost price, if needed. This information is optional.

After the necessary mappings are set, click “Import” (5).

If the import file contains rows where the “Counted amount” column is empty, those rows will be deleted and will not shown in the stocktaking.

Manual stocktaking entry

Warehouse -> Stocktaking -> New stocktaking

General information panel

  1. Counting date – the date when the stocktaking is performed
  2. Person in charge – select from the drop-down menu the employee responsible for carrying out the stocktaking
  3. Warehouse – the warehouse whose goods are being inventoried. Once the warehouse is selected, the items stored in that warehouse will be loaded into the stocktaking lines (up to 1000 rows).

Only items that have previously had a stock balance or movements will appear in the stocktaking. It is not possible to record items in stocktaking that have not previously been part of the warehouse inventory.

Stocktaking rows panel

When entering the stocktaking, the actual amount of the item must be entered in the “Counted amount” column.

  1. If the actual quantity is lower than the recorded stock balance, the difference will be displayed with a minus sign. The cost price is added when the stocktaking is saved. If the goods come from multiple batches, they will be written off according to the FIFO method, and the write-off cost will be determined accordingly.
  2. If the actual quantity is higher than the recorded stock balance and the balance is not zero, the cost price will be shown based on the last purchase price.
  3. If the recorded stock balance is zero but the counted quantity is higher, the cost price must be entered manually, based on the last purchase price.
If there is an item on the stocktaking page that you do not want to include, delete the row by clicking the cross icon at the end of the line.

Item rows can be rearranged by clicking the “dots” at the beginning of the row and dragging the row up or down while holding the left mouse button.

Transactions related to stocktaking
Once the stocktaking has been saved, you can see the warehouse transaction(s) and the corresponding financial transaction.

Clicking the magnifier icon opens the detailed warehouse transaction.

The item that was found to be in smaller quantity came from two different batches, and here you can see the quantities and prices at which it was written off.

Here you can see the items that were actually found in a greater quantity. For item 1103, the cost price was manually added in the stocktaking entry view, and it is now reflected in the warehouse balance.

Important Once the stocktaking is completed, the stock balances of the inventoried items are locked, and no further changes can be made to these items for periods prior to the stocktaking. If any adjustments are required, the items must first be removed from the stocktaking.

If you have any additional questions, please write to us at support@simplbooks.ee

Was this article helpful?

Related Articles

Leave A Comment?