Stock recording usually includes counting the number of products, conducting direct inspections, and making arrangements that will facilitate business operations when a certain product is needed.

At DealPOS, you can adjust your product by using Stock Take by Web Spreadsheet.

This article explain, how to do adjustment by using web spreadsheet. It will readjust current product inventory with new inventory quantity that you have inputted. It will make stock take easier if there were only a few items that you need to readjust and synchronize our system with your physical inventory.

Step 1. Go to Adjustment, then Click Tab Stock Take by Web Spreadsheet


Step 2. Choose Outlet & Category to Adjust, then Click Next

adjustment by web spreadsheet

You can choose which outlet you want to make adjustments to at which outlet. For categories, if you want to display all products, you don't need to select the category.

Step 3. Fill Counted with Real Time Inventory, then Click Next

Fill Counted Stock

Then you can immediately fill in the real stock that is in what outlet, in the counted column.

Step 4. Confirm Adjustment, then Click Next

Confirm Adjustment

This review section will display all the products that you want to adjust beforehand. The point is to avoid mistakes so that they are not directly adjusted, so it can be reviewed first whether the adjustment is correct or not, here also seen the difference for the addition of product stock when adjusted.

Step 5. Adjustment was Created

Adjustment was Created

Step 6. Recheck Adjustment History

Recheck Adjustment History

You can check out the history that you have changed on archieve tab, and the type of adjustment made is update inventory.

Table Index :




Stock in DealPOS system


Counted Stock / Stock in Hand / Stock in your outlet

You might also like to read these articles below :


Did this answer your question?