Inventory
How to import opening stock from Excel
Load initial quantities and tracked stock details at the right location and date, then check the import results.
Choose a location and effective date
Go to Inventory › Opening Stock. Select the Inventory location and the Effective date for the initial balance. If a product is marked Use Stock Adjustment because inventory has already moved, resolve it through Stock Adjustment.
Download the workbook for that location
Open Import and choose Template. Use the downloaded .xlsx file and keep its sheet names and column headings. In the Opening Stock sheet, match the Product Code and fill Opening Stock only for rows you want to import. Complete cost and other applicable fields using the template instructions.
Add batch and serial details
Use the workbook’s tracking detail sheets when the product is batch- or serial-tracked. Enter the actual batch numbers and required dates, or the individual serial numbers. Check that the tracked quantities agree with the opening quantity before uploading.
Import and verify the balances
With the same location and date selected, use Import › Import and choose the completed file. Review the import results, correct any rejected rows and verify the saved quantities for representative products before entering regular inventory transactions.