Skip to main content
All CollectionsAdjustmentStock Take
Stock Take by Web Spreadsheet
Stock Take by Web Spreadsheet

Adjustments are made when there is a difference between the number of products in the system and the stock at the outlet.

Teguh Warsono avatar
Written by Teguh Warsono
Updated over a week ago

Stock recording usually includes counting the number of products, conducting direct inspections, and making arrangements to 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 explains, how to make adjustments by using a web spreadsheet. It will readjust the current product inventory with the new inventory quantity that you have inputted. It will make stock take easier if there are only a few items that you need to readjust and synchronize our system with your physical inventory.


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

Adjustment by Web Spreadsheet

Step 2. Select an outlet (Mandatory) and other optional filter as needed, then Click Next

Choose Outlet & Category to Adjust

Notes:

You can choose which outlet you want to make adjustments to at which outlet. You can also filter the storage location to make adjustments based on the product's location. To add and manage storage locations, you can check the following article: Manage Product Storage Location.

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

Fill Counted Column

Notes:

Then you can immediately fill in the real stock that is in what outlet, in the counted column. If there are no changes, then the counted column can be left blank

Step 4. Click Confirm Adjustment

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. Inventory Adjustment was Completed

Inventory Adjustment was Completed

Step 6. Recheck Adjustment History on Adjustment List

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

Recheck Adjustment History on Adjustment List

Table Index:

Column

Description

Expected

Stock in DealPOS system

Counted

Counted Stock/Stock in Hand/Stock in your outlet


Related Articles:


DealPOS is an online point-of-sale (POS) application specifically designed for retail businesses in categories like Fashion, Minimarkets, Electronics, Fresh Food, and Building Material Stores.

With DealPOS, you can manage both online and offline store inventory in real-time on a single platform. You can also sell through omnichannel (offline and online) as DealPOS integrates with marketplaces (Shopee, Tokopedia, TikTok Shop, Lazada) and instant web stores (Shopify and WooCommerce).

dealpos-trial-indonesia
Did this answer your question?