This guide shows you what you need to take note and how to perform stock take and also stock adjustment if any difference arise.
Some company perform stock take once every month or once every year. You can print out the Stock Take Sheet in SQL Account and pass it along to your storekeeper to do a count of the stock in hand.
How to Print Stock Take Sheet.
Print Stock Physical Worksheet.
Filter the information you need. You can also Filter or Group by Location and Batch (if you have these 2 modules).
Print a copy out. Storekeeper will then count and write down the actual stock quantity exist in the warehouse.
How to Enter Stock Count & Adjustment in SQL Account.
Now that your storekeeper has fill up the actual stock count in your warehouse, proceed to the next step.
Open Stock Adjustment.
Open Print Stock Physical Worksheet.
Make these two screens to displayed side-by-side.
Click on one of the item in Print Stock Physical Worksheet. Hold CTRL+A (keyboard) to select all items.
Use your mouse to drag and drop the items from Print Stock Physical Worksheet to Stock Adjustment.
Wait for SQL Account to finish copy over your items. You can close Print Stock Physical Worksheet screen once the copy is done.
Based on the storekeeper's report, fill in the actual stock count into Physical Qty column. SQL Account will based on the Book Qty in system to calculate the difference and show automatically in the Qty column.
Physical Qty: Actual quantity in your warehouse.
Book Qty: Quantity recorded in SQL Account.
Qty: Difference between Physical and Book Qty. System will auto-adjust the quantity to update accordingly (Positive Qty = Actual > Book Qty; Negative Qty = Actual < Book Qty).