Stock Balance Adjustment
Stock Balance Adjustment loads stock quantities and values. It is how opening stock enters the system at cut-over, and how bulk corrections are applied afterwards. Both positive and negative quantities are accepted.
Where to find it
Go to Setup > Import Export > Inventory Adjustments. Import items first.
Format Data
| Column | What it holds |
|---|---|
| Date | The date the stock is recognised. For opening stock this is your cut-over date. |
| Location | The warehouse the stock sits in. Import per location where you hold stock in several places. |
| Stock ID | The item code. Must match an item that exists. |
| Batch | The batch number, for batch-tracked items. |
| Expiry Date | The batch expiry, where tracked. |
| Qty | The quantity. Negative values are accepted for corrections. |
| Standard Cost | The unit cost. This becomes the item's cost basis, so it must be cost, not selling price. |
| Memo | A note explaining the adjustment. |
Value opening stock at cost. The figure here becomes the cost of goods sold on everything later sold from that stock, so an inflated cost understates your margin from day one.
Options
| Option | Effect |
|---|---|
| Stock Adjustment Date | The date applied where the file does not carry one. |
| Default Location for QOH | The warehouse used where a row has no location. |
| Skip If Stock Exists | Leaves items that already hold a quantity untouched — useful when re-running a partial import. |
What it posts
Stock increases at the location, with the contra going to the inventory adjustment account set in System and GL Setup.
Errors and exports
If rows fail, the system returns your file with a Memo column added, naming the problem on each bad row — fix those rows and upload again. Every module supports export as well as import, so you can pull current data out in the same format.
The rules common to all imports — never rename headers, dates in Y/m/d, codes must already exist, test a few rows first — are set out in Importing Your Data.
Related pages
- Items and Services Import — must run first
- Opening Balances — opening stock in context
- Importing Your Data — shared rules
- System and GL Setup — the adjustment account