Aantar Books
Adjust Quantity/Value on Hand
Write off stock that was damaged, lost or miscounted, or add stock found on a count, with a reason and a cost, and see what it does to the books.
Where: Vendors ▸ Inventory Activities ▸ Adjust Quantity/Value on Hand · Inventory ▸ Adjustments
An inventory adjustment changes the quantity of stock you hold without a sale or a purchase behind it. You use one when the shelf and the books disagree: goods broken in the stockroom, stolen, spoiled or past their date, a count that came up short, or a count that found more than the books say. Every adjustment carries a reason, a cost and the name of the person who recorded it, and it reaches the books the moment you save it.
Aantar Books keeps every adjustment on one register, the Stock Adjustments list, including the ones it creates for you (see Adjustments Aantar Books records for you).
Opening the Adjustments screen
- Vendors ▸ Inventory Activities ▸ Adjust Quantity/Value on Hand, or
- Inventory ▸ Adjustments.
The Stock Adjustments list
The heading shows how many adjustments are listed. Period limits the list to a date range (Today, This month, Last month, This year and so on, or a custom range); it starts on all dates and remembers your choice. Refresh reads the list again; New Adjustment starts one.
The list shows 50 adjustments at a time, newest first. When the period holds more, the arrows at the foot of the list (Page 1 of 4) step to older and newer ones.
| Column | What it shows |
|---|---|
| Ref | The adjustment's Ref. No.: the one typed on it, or the number Aantar Books gave it. |
| Date | Its Adjustment Date, with the time it was recorded. |
| Location | Where the stock moved. |
| Reason | The reason typed when it was recorded, or — if none was given. |
| Type | Stock found (stock added), Damage / loss or Correction (both remove stock). |
| Lines | How many items are on it. |
| Value | Its total value at cost. |
The footer reminds you that a Stock found row adds stock at the cost given and every other row removes it. You can sort, resize and choose columns, and use Email this or Export (CSV, Excel or PDF), as on other lists.
Double-click a row, or select it and press Enter, to open its page (see The adjustment page).
Entering a physical count (New Quantity)
This is how the dialog opens: you type what you counted and Aantar Books works out the difference.
- Click New Adjustment. Check the Adjustment Date, Ref. No. and Location at the top (see Date, Ref. No. and Location). Counted quantity is selected below them.
- Search for each item you counted (Search the item you counted…) and click it. Each line shows On hand: what the books say is at this location now, read live when you add the item.
- Type what you counted in New qty. The difference shows beside it: green with a + when you counted more, red when you counted less. An item whose count matches the books moves nothing.
- Check each line's Cost (see step 3 below).
- If any line is short, choose Damage / loss or Normal correction for it.
- Type the Reason, for example Year-end count, aisle 4, and click Record the count.
Aantar Books records the lines counted short as one Stock out adjustment and the lines counted over as one Stock found adjustment, each at its own difference, and tells you both numbers. When you typed a Ref. No. and the count makes both, the second carries it with -2 (SA-100 and SA-100-2). The Physical Inventory Worksheet is the sheet to count on.
Tip: Counting a whole location, or more items than fit comfortably in this dialog? Use a Physical Count voucher: it loads every item at once, can be saved and finished later, and has an Adjustment Account and value adjustment.
To type the quantity to add or remove instead, choose Quantity to add or remove at the top and follow the steps below.
Recording an adjustment by quantity
- Click New Adjustment, then choose Quantity to add or remove at the top. If your role is not allowed to post stock adjustments, Aantar Books asks for approval first (see Permissions).
- In the search box (Search the item being written off…, or Search the item you counted more of… once Stock found is chosen), type at least two letters of the item's name, variation or code, then click the item in the list that drops down. It is added as a line with a quantity of 1. Repeat for every item on this adjustment; an item already on it is not added twice.
- Wait for each line's cost to appear. Under the item name you see finding the purchase cost…, then cost $X each. If Aantar Books cannot find a cost, the line says no purchase cost found — enter what it cost in red; type the cost in Cost.
- Enter the quantity in Qty for each line. Always a positive number: the direction is set in the next step.
- Choose the direction:
- Stock out (the default) — you counted less than the books say. Then choose Damage / loss (breakage, theft, spoilage) or Normal correction (a plain miscount).
- Stock found — you counted more than the books say.
- Type the Reason, for example Broken in the stockroom or Year-end count, aisle 4. It is recorded in the audit trail and printed on the note.
- Optionally tick what should happen as soon as it is saved: Print, Save PDF, Email or WhatsApp the adjustment note.
- Click Write off stock (for Stock out) or Add found stock (for Stock found).
A message confirms it with the adjustment's number (Adjustment … recorded — stock reduced. or … recorded — stock added.). The stock changes at once and the list refreshes.
The adjustment is dated with its Adjustment Date and moves stock at the Location chosen at the top.
Date, Ref. No. and Location
The top of the New stock adjustment dialog has three fields:
- Adjustment Date — the day the adjustment belongs to. It starts on today; type a date or pick one to record a count on the day it was taken. A date on or before your closing date is refused (see Set Closing Date and Year-End).
- Ref. No. — leave it blank and Aantar Books numbers the adjustment when it is saved, in the year of the Adjustment Date (an adjustment dated 28 December and saved on 2 January belongs to the old year). Type a number to use your own. A number already used by another adjustment or physical count is refused: Ref. No. … is already used by another stock adjustment or physical count. Type a different number, or leave Ref. No. blank for the next automatic one. If Edit ▸ Preferences ▸ Items & Inventory ▸ Stock adjustment numbers is I type them, the field says Required and the adjustment cannot be saved without it, from any screen. The adjustments Aantar Books records for you (damaged returns, bin counts) are still numbered automatically.
- Location — where the stock is. It starts on this computer's own location; choose another to adjust a warehouse from here. On hand on every line is read again for the location you choose.
Note: These three fields are on the Aantar Books form. The Aantar POS till keeps today's date, an automatic number and the till's own location.
The New stock adjustment fields
| Field | What to enter / what it means |
|---|---|
| Adjustment Date | The date the adjustment is recorded on. |
| Ref. No. | Blank for an automatic number, or the number you type. |
| Location | Where the stock moves. |
| Search the item being written off… / Search the item you counted more of… | Finds items by name, variation or code (at least two characters). Click a result to add it. |
| Adjustment Account | The account the value of the adjustment goes to. Leave it on Inventory shrinkage (default) to use the account set in Accounting Setup, or choose another expense or cost of goods sold account. |
| Cost | What one unit cost you. Filled in from the last price you paid for the item, or its standard purchase cost if there is no purchase; on a company using Average cost (see Preferences), from the item's average cost. Change it if the goods are worth something else; once you type, Aantar Books stops filling it in. |
| Qty | How many units to remove or add. Must be more than zero. |
| U/M | The unit Qty, New qty and Cost are typed in, for an item with larger units: pick cs and type 3 rather than 36. The cost follows the unit; the adjustment is recorded in the item's own unit. See Units of measure. |
| Bin icon | Removes the line. |
| Counted quantity / Quantity to add or remove | Whether you type what you counted (New qty, with On hand and the difference shown) or the quantity to move. |
| On hand / New qty | With Counted quantity: what the books say is here now, and what you counted. |
| Stock out / Stock found | With Quantity to add or remove: which way the count goes. The subtitle and the button change to match. |
| Damage / loss / Normal correction | For stock out only: what kind of loss it is. Shown as the Type on the list and on the note. |
| Value adjustment | For stock found. Off (the default): on a company using Average cost, found stock comes in at the item's average cost on the Adjustment Date, whatever the Cost column shows. On: it comes in at the Cost you typed. |
| VALUE | The total of quantity × cost for every line: the amount that will post to the books. |
| Reason (recorded in the audit trail) | Why stock is being adjusted. |
| On writing off, also / On recording, also | Print, save, email or WhatsApp the note as soon as it is saved. Email and WhatsApp ask for the address or number, because an adjustment has no customer or vendor to send it to. |
The Write off stock / Add found stock button stays greyed out until every line has a quantity above zero and a cost above zero, and no cost is still being looked up. A line at no cost would move stock without moving any value, so Aantar Books does not allow it.
Tip: The cost matters most for Stock found. On FIFO, found units enter your stock at the cost you give them, and that is the cost of goods sold Aantar Books records when they sell. On Average cost they come in at the average unless you tick Value adjustment.
What happens in the books
An adjustment posts to two accounts: Inventory on hand (your inventory asset account) and its Adjustment Account. When you leave the Adjustment Account on its default, that is the Damage / shrinkage write-offs account chosen in Accounting Setup (called Inventory Adjustment (Shrinkage) in a new chart of accounts).
| Adjustment | Debit | Credit | Amount |
|---|---|---|---|
| Stock out (Damage / loss or Correction) | Damage / shrinkage write-offs | Inventory on hand | The adjustment's value (quantity × cost) |
| Stock found | Inventory on hand | Damage / shrinkage write-offs | The adjustment's value (quantity × cost) |
Both directions use the same expense account on purpose: a miscount one month and its correction the next cancel out in one place, and the account shows what counting really cost you over the year.
Stock written off is valued at the cost on the line. On a company using Average cost, stock written off is valued at the item's average cost on the adjustment's date, whatever the Cost column shows; the saved adjustment shows that cost and value. Found stock is valued the same way, at the average, unless Value adjustment was ticked. Found stock is added as a new costed batch, so later sales of those units take their cost from it. Found stock carries no sales tax: nobody invoiced it, so there is no input tax to claim.
On Average cost, an adjustment, a bill or a credit memo entered later with an earlier date changes the average from that date, and Aantar Books costs again the sales, write-offs and credit memos dated after it. Anything on or before your closing date keeps the cost it was posted at.
If either account is not set up in Accounting Setup, the stock still changes but nothing posts, and Aantar Books' ledger health check reports the adjustment as a document missing from the ledger. See How each transaction posts to the books.
Important: An adjustment cannot be edited. One entered by mistake can be deleted, as in QuickBooks: open it and click Delete adjustment, or choose Edit ▸ Delete Transaction. Aantar Books asks Are you sure you want to delete adjustment …?, then puts the stock back as it was before the adjustment and removes its entries from the books.
Delete an adjustment
Deleting needs the Delete Stock Adjustment right (Inventory ▸ Adjustments in Roles and permissions). Aantar Books refuses, and says why, when deleting would make the books wrong:
| Message | What to do |
|---|---|
| … of the … units of 'Item' this adjustment added have since been sold or used, and their cost came from it… | Found stock that has been sold cannot be taken back: those sales were costed from it. Record a Stock out for the units that are really not there instead. |
| Only … of 'Item' are on hand at this location, and deleting this adjustment would take … off… | Fewer units are on the shelf than the adjustment added. Record an adjustment for what is really there. |
| This adjustment was posted by Physical Count … | Open the count and use Reverse, so the count and the stock agree. |
| A message that the period is closed | The adjustment is on or before your closing date. |
An adjustment that cannot be deleted can still be undone with another in the opposite direction: a Stock found for units written off by mistake, or a Stock out for units added by mistake, at the same cost.
The adjustment page
Opening an adjustment shows it as a page:
- Adjustment and its number, a Stock found, Damage / loss or Correction tag, and the date and time.
- Stock removed at (or Stock added at for Stock found) — the location.
- REASON GIVEN — the reason, or No reason was recorded.
- The lines: SKU, Item, Qty out, Unit cost and Value lost. For Stock found they read Qty in and Value added, and each quantity shows with a +. Double-click a line to open that item's Product 360.
- What left stock: Lines, Units removed and VALUE WRITTEN OFF. For Stock found: What was added, Units added and VALUE ADDED.
- Send the write-off note (Send the found-stock note for Stock found): Print, Save PDF, Email and WhatsApp.
Found units also appear on the item's stock card as Opening stock.
The adjustment note
The printed note is headed STOCK ADJUSTMENT with the number and says what the adjustment was: Stock written off (Damage / loss), Stock corrected (Correction) or Stock found. It lists the details, the reason given, and each item with QTY OUT, UNIT COST and VALUE LOST, then the units removed and the VALUE WRITTEN OFF. A Stock found note reads QTY IN, VALUE ADDED and Units added instead. It has signature lines for Recorded by and Authorised by, so it can be filed with your count sheets.
Adjustments Aantar Books records for you
These appear on the same list, with a reason that says where they came from:
- Damaged returns. When you take back goods on a credit memo and mark them damaged, the return first puts them back in stock and an adjustment then writes them off again, so damaged goods never look sellable. See Create Credit Memos and Refunds.
- Bin counts. When a count of a warehouse bin comes up short, the shortage is written off with the reason Cycle count — bin …. See Warehouse and bin locations.
- Goods lost in transit. When a transfer arrives short and you choose Lost/damaged in transit, the missing units are written off at the sending location. See Transfer Inventory between locations.
Permissions
Recording an adjustment needs the Post Stock Adjustment permission (under Inventory ▸ Adjustments in the role's permissions). A role that has not been given Aantar Books permissions uses its older Inventory access instead.
If your role does not have it, clicking New Adjustment opens an approval box: This is locked for your role. Anyone who has access to it can approve this one action. A colleague who has the permission enters their Login ID and Password to approve this one adjustment. See Roles and permissions explained.
Messages you may see
| Message | What to do |
|---|---|
| no purchase cost found — enter what it cost | Aantar Books has no purchase for this item and no standard cost. Type the unit cost in Cost. |
| 'Item' does not track stock, so there is no count to correct. | Stock found was chosen for an item that keeps no stock (a service or non-inventory item). There is nothing to adjust. |
| 'Item' tracks serial/IMEI numbers, so found units have to carry them… | Serial-numbered items cannot be added through a quantity. Receive them on a bill or import them with their serial numbers. |
| 'Item': found stock needs a unit cost… | Enter a cost above zero. |
| A message that a quantity or unit cost is not plausible | Found stock with a very large quantity, unit cost or line value is refused as a likely typing mistake. Check the figures. |
| ERROR: NOT ALLOWED: Mismatch between stock adjustment and purchase quantity. Product: … | You are writing off more of the item than Aantar Books has received into this location. Check Stock Levels and the item's stock card, and write off no more than is on hand. |
| This stock adjustment is dated …, which falls in a period closed on … | The Adjustment Date is on or before your closing date. Choose a later date, or ask an administrator to move the closing date (or enter the closing date password if one is set). See Set Closing Date and Year-End. |
| Ref. No. … is already used by another stock adjustment or physical count… | Type a different number, or clear Ref. No. for the next automatic one. Nothing was saved. |
| Something went wrong — the adjustment was NOT recorded | Nothing was saved and no stock moved. Try again; if it repeats, contact support. |
Tips
- Count first, adjust second. Print the Physical Inventory Worksheet (Reports ▸ Inventory), count, then record one adjustment per location for the differences.
- Always give a reason. An adjustment is the one stock movement with no customer or vendor to vouch for it; the reason is what an accountant or auditor reads.
- The Stock Adjustment Detail report (Reports ▸ Inventory) lists write-offs for any period you choose. See Inventory reports.
Note: The form has an Adjustment Date, Ref. No., Adjustment Account and a Location. A quantity found is valued at the average cost; Value adjustment sets the value instead. To revalue stock you already hold, use a Physical Count voucher with Adjust value.
Related articles
- Stock Levels
- Warehouse and bin locations
- Transfer Inventory between locations
- Accounting Setup (posting accounts)
- How each transaction posts to the books
- Set Closing Date and Year-End
- Inventory reports
Related articles
Something unclear or out of date? Write to support@aantar.com and name this page.