Inventory Batch Adjustment
From theΒ global createΒ window, you now find theΒ inventory quantity adjustmentΒ feature. Click on this new feature, and once stocktake has taken place you can now batch edit the new quantity on hand and the change will generate. This saves you time by adjusting a number of different stock quantities in one entry.
Hint: To run your stocktake, run either theΒ product/service listΒ or theΒ inventory valuation detailΒ report. Customise so only the columns that you require are viewed, for example products name and quantity, then clickΒ export to ExcelΒ button. Once in Excel add a column for quantity on hand. You can either print this report whilst counting or leave open on laptop or device whilst running your stocktake. Once the stocktake is complete youβre ready for a batch adjustment for stock requiring adjustments.
Β
Ensure you use the correct date of stocktake, in theΒ new quantityΒ column enter the new amount after stocktake. QuickBooks Online intuitively calculates the difference in theΒ change in quantityΒ column.Β Save and closeΒ to save the new quantity on hand.