Aantar Books
Inventory reports
What stock you hold, where it is, what it is worth, how it moved, what is running low, what is not selling, and what was written off.
Where: Reports ▸ Inventory · Reports ▸ Report Centre ▸ Inventory
The Inventory reports tell you what stock you hold, where it is, what it is worth, how it got there, and what needs attention: items running low, items not selling, items the books think you have fewer than none of, and stock written off. Use them for month-end stock valuation, before a stocktake, when deciding what to reorder, and when the stock value in your books does not agree with the shelf.
Only items that track stock are included. Services and other items with no quantity to count are left out.
Where to find them
- Reports ▸ Inventory lists Inventory Valuation Summary, Inventory Valuation Detail, Inventory Stock Status by Item, Inventory Stock Status by Vendor, Physical Inventory Worksheet, Pending Builds, Stock by Location, Stock Movement Summary, Stock Adjustment Detail, Slow-moving Stock, Inventory Aging and Negative Stock. The same submenu opens four inventory screens that are not Report Centre reports; they are listed at the end of this article.
- Reports ▸ Report Centre, category Inventory, has all fourteen reports, including Days of Stock Cover and ABC Analysis, which are not on the menu. The menu's Inventory Stock Status by Item is called Stock Status by Item in the Report Centre.
How stock is valued and counted
- On hand is the live quantity, the same figure the rest of Aantar Books uses when you sell or transfer.
- Value at cost on every inventory report (Inventory Valuation Summary, Stock Status by Item, Stock by Location, Slow-moving Stock, Stock Movement Summary, ABC Analysis, Inventory Aging and Negative Stock) follows your company's inventory costing method (Edit ▸ Preferences ▸ Items & Inventory, see Preferences), at the unit cost the Inventory Valuation Summary shows: on Average cost, each item's running average cost; on FIFO, the bills still on the shelf at what each one cost. These are the figures your Inventory Asset account is built from. An item with nothing on hand to cost (or fewer than none) uses its cost as set on the item. Each report shows the cost per piece it values with beside the value (Avg cost on Average cost, Unit cost on FIFO), so Value at cost is always the quantity times the cost beside it. Value at retail uses the item's selling price before tax.
- In larger units: when an item is also bought or sold in a larger unit (a case), the Inventory Valuation Summary, Stock Status by Item, Stock by Location and the Physical Inventory Worksheet add a column with its stock told in whole cases and the pieces left over, for example 3 cs 6 ea for 42 each in cases of 12. It uses the item's sales unit when that is a larger one, else its largest unit. The column appears only when at least one item has a larger unit. See Units of measure and larger units.
- Reports that show Current in the Report Centre have no date: they show stock as it is now. Reports with a period show movement in that period.
- Location: most reports follow the location picker at the top of the window. With All locations chosen, quantities are added across every store and warehouse. Stock by Location and Inventory Stock Status by Vendor always show every location; Pending Builds has no location filter.
For the toolbar, search, sorting and export, see Running a report.
Valuation
Inventory Valuation Summary
What it answers: what your stock is worth right now, item by item.
Date: none (current). Filters: location. The subtitle names the location, or says All locations.
Columns:
| Column | What it shows |
|---|---|
| Item | The item (and its variant, where it has variants). |
| Code | The item's SKU or code. |
| Category | Its category. |
| On hand | Current quantity. |
| Unit | Its unit of measure. |
| Avg cost (on Average cost) or Unit cost (on FIFO) | What one unit on hand cost, by your costing method. An item with nothing costed yet shows its cost as set on the item. |
| Value at cost | What the stock on hand cost, by your costing method. With All locations, it is exactly what the item's bills, sales, returns and adjustments put into and took out of Inventory Asset. For one location, it is that location's quantity times the unit cost. |
| Selling price | The item's selling price before tax, as set on the item. |
| Value at retail | On hand times Selling price: what the stock would sell for, not what it is worth in your books. An item with no selling price shows 0.00, and the note says how many there are. |
| % of stock | This item's share of the value of the stock you hold. |
| On hand in larger units | On hand in whole cases and pieces, for example 3 cs 6 ea. Only when an item has a larger unit. |
Rows: one per item with a quantity other than zero, alphabetically, then a TOTAL row.
Notes under the report:
- When your Inventory Asset account is set in Accounting Setup, the report compares its total value at cost with that account's balance. It says Agrees with the Inventory Asset account in the ledger, or gives both figures and the difference. A difference usually means stock arrived without a bill or opening-stock entry, or an opening balance was never journalled.
- Items with a negative quantity are counted in the value total but get no % of stock, and a note says how many there are. Fix them with an adjustment; until then the valuation is understated.
- The first note names the costing method the report used.
- On Average cost, a line Cost left on items with none on hand can appear: the last cents of an average, or landed cost applied after the last unit sold. It is part of Inventory Asset, so it is counted in the total; the next bill for the item takes it into that item's average.
- If an item's quantity on hand differs from its cost records (usually because a quantity was changed directly instead of with an adjustment), it is valued at its unit cost and a note says how many items that applies to.
Drill down: double-click a line to open Inventory Valuation Detail for that item, from the first document in your books to today, so its running column ends at the quantity on hand: every bill, sale, adjustment and transfer, with who it was with. Double-click the item's name instead to open the item itself (see An item's history and drill-down).
Note: On Average cost (the method new companies start on) Avg cost is each item's running average cost and Value at cost its asset value. On FIFO it values the stock at what the bills still on the shelf cost. There is no as-of date: run it on the day you need the figure, or use Stock Movement Summary to see how a past closing quantity was reached.
Inventory Valuation Detail
What it answers: every movement in and out of stock in a period, item by item.
Date: a period. Filters: location. (Opened from another report, it can be narrowed to one item.)
Columns:
| Column | What it shows |
|---|---|
| Date | The document's date. |
| Type | Bill, Opening Stock, Debit Note (returned to a vendor), Invoice, Credit Note, Stock Adjustment, Transfer Out or Transfer In. |
| Num | The document's number. |
| Name | Who the movement was with: the vendor on a bill, opening stock or debit note, the customer on an invoice or credit note. Blank for a stock adjustment or a transfer. |
| In / Out | The quantity that came in or went out. |
| Running | The running total of movement for the item. |
| Sale price | What an invoice or credit note charged for one unit. Blank on other lines. |
| Unit cost | What one unit went into or out of Inventory Asset at: on a bill or opening stock its cost with the landed cost put on it; on an adjustment or transfer its cost; on an invoice its cost of goods sold (the purchase batches it used, or the item's cost where none is recorded); on a credit note the cost it came back at. |
| Value | The quantity times Unit cost: plus for stock in, minus for stock out. |
| Running value | The running total of Value, starting at zero, as Running does for the quantity. |
Rows: one section per item, headed with the item's name and its code (for example Ajwain Cookie 350 Gms · 880009395778), then a Net movement line with the total in, total out and net for the period, and the net value moved. Because the code is in the heading, Search in the report finds an item by its code as well as its name.
Drill down: double-click a line to open the document that moved the stock, including a stock adjustment.
Important: The Running column starts at zero at the beginning of the period. It is the movement in the period, not the quantity on hand. For what is on the shelf now, use Inventory Valuation Summary.
Note: Transfers still in transit and purchase orders not yet received are not movements and are left out. Across all locations, a transfer's two halves cancel; for one location, only its own half shows.
Landed Cost Detail
What it answers: the audit trail of every freight, customs duty, brokerage or other charge put on goods with Landed Cost: who charged it, which goods it went on, how it was spread, and what it did to each item's unit cost.
Date: a period (the date of the vendor's bill for the charge; for freight on the goods bill itself, the bill's date). Filters: vendor (the one who charged it).
Columns:
| Column | What it shows |
|---|---|
| Date | The charge's date. |
| Vendor | Who charged it: the broker, customs or the carrier. |
| Vendor Invoice # | Their invoice number (their bill's Ref. No.). |
| Goods Bill | The bill the goods came in on (the receipt). |
| Charge Type | Freight, Customs Duty, Brokerage, Shipping, Handling, Insurance or Other; (on the bill) for the goods bill's own freight. |
| Method | By cost, By quantity, By weight, By volume or By hand. |
| Item, SKU | The item the charge went on. |
| Qty | The quantity on the goods bill. |
| Original Unit Cost | What one unit cost before the charge. |
| Landed per Unit | What the charge added to one unit. |
| Final Unit Cost | What one unit cost after it. |
| Amount Allocated | The part of the charge on this line. |
| To COGS (sold) | The part that went to Cost of Goods Sold because those goods were already sold when the charge arrived (average cost). |
Rows: one per item a charge went on, then a TOTAL row. A note gives how much went to Cost of Goods Sold and how much into Inventory.
Drill down: double-click a line to open the vendor's bill; double-click the Goods Bill to open that bill; double-click the item or its SKU to open its Product 360.
Note: Recoverable GST/HST and QST are on the input tax credit account and are not in these amounts. Tax that is not recoverable (PST) is part of the amount, because it is part of what the goods cost.
Stock Movement Summary
What it answers: the stock reconciliation. For each item: opening quantity, plus everything in, less everything out, equals closing.
Date: a period. Filters: location.
Columns:
| Column | What it shows |
|---|---|
| Item, Code | The item. Click the name to open it. |
| Opening | Quantity at the start of the period. |
| Received | Bills received, opening stock and builds. |
| Returned to suppliers | Vendor credits (negative). |
| Sold | Invoices (negative). |
| Returned by customers | Credit notes. |
| Adjusted | Stock adjustments. |
| Transferred | Transfers in less transfers out. |
| Closing | Quantity at the end of the period. |
| Avg cost (on Average cost) or Unit cost (on FIFO) | The cost of one piece the closing value is taken at. Not added up in the TOTAL row. |
| Closing value at cost | Closing times the cost beside it. |
A movement column is blank when nothing of that kind happened.
Rows: one per item, then a TOTAL row.
Drill down: double-click an item that moved to open Inventory Valuation Detail for that item and period, with every document behind the figures.
Note: The closing quantity is worked back from today's quantity on hand, less everything that moved after the period, so it always matches the shelf. Stock set without a document (for example by an import) therefore sits in the Opening figure rather than in a column.
Stock
Inventory Stock Status by Item
Shown in the Report Centre as Stock Status by Item.
What it answers: every inventory item's stock against its reorder point, and which ones you need to buy.
Date: none (current). Filters: location.
Which items are listed: every item that tracks stock. The Order column is ticked for items with nothing (or less than nothing) on hand, and for items whose on hand plus on order is below their reorder point; the note says how many. Use Filters to narrow to the ticked ones.
Columns:
| Column | What it shows |
|---|---|
| Item, Code, Category | The item. |
| On hand | Current quantity. |
| Reorder point | The item's Warn me below quantity, from the Reordering section of the item form. |
| On order | Quantity on open purchase orders not yet received, for the location in the picker (every location when it is on all). These are the same orders, and the same quantities, as Qty to come on the Open Purchase Orders reports. |
| Shortfall | Reorder point less (on hand plus on order). |
| Order | ✓ when the item needs buying. |
| Avg cost (on Average cost) or Unit cost (on FIFO) | The cost of one piece by your costing method. |
| Value at cost | On hand times the cost beside it. |
| In larger units | Beside On hand: the stock in whole cases and pieces, when an item has a larger unit. |
Drill down: double-click a line for the item's history (Inventory Valuation Detail for that item, from the first document in your books), or double-click the item's name to open the item.
Related: Reorder Levels goes further, using the item's forecast and lead time to say when to order and how many.
Inventory Stock Status by Vendor
What it answers: your stock grouped by the vendor you buy each item from, ready for placing orders vendor by vendor.
Date: none (as of today). Filters: none; every location is included.
Rows: one section per vendor, alphabetically. An item's vendor is the one it was last bought from; items never bought are under (no vendor).
Columns:
| Column | What it shows |
|---|---|
| Item | The item (and variant). |
| SKU | Its code. |
| Reorder Pt | The item's reorder point (Warn me below). |
| On Hand | Quantity across all locations. |
| Avg cost (on Average cost) or Unit cost (on FIFO) | The cost of one piece by your costing method. |
| Value at cost | On Hand times the cost beside it. Each vendor's section ends with its Total, and the report with a TOTAL. |
| Order | A tick when on hand is at or below the reorder point. |
| On PO | Quantity on open purchase orders not yet received: the same orders the Open Purchase Orders reports list. |
| Next Deliv | The earliest expected delivery date of those orders. |
Note: The vendor is taken from the most recent bill; there is no Preferred Vendor field.
Physical Inventory Worksheet
What it answers: a count sheet to print and take to the shelves.
Date: none (current). Filters: location. The subtitle names the location and today's date.
Columns: Item, Code, Category, Unit, On hand per system, In larger units (the same stock in whole cases and pieces, when an item has a larger unit, to count the shelf as it is stacked) and Physical count, which is a blank line for you to write on.
Rows: every stock item, including those at zero, grouped by category.
Drill down: double-click an item to open its movement history. This helps when a count disagrees with the system.
To count your stock:
- Choose the location in the location picker at the top of the window.
- Open Reports ▸ Inventory ▸ Physical Inventory Worksheet and click Print.
- Count each shelf and write the real quantity in Physical count.
- Type the counts into a Physical Count voucher for the location and post it, or enter a few items with Adjust Quantity/Value on Hand.
A Physical Count voucher opens this sheet for its own location with Count sheet.
Important: Correct counts with an adjustment rather than by editing an item's quantity. An adjustment leaves a record of what changed and why; a direct edit does not.
Tip: Hide the On hand per system column with Columns before printing if you want a blind count.
Stock by Location
What it answers: where your stock physically is.
Date: none (current). This report always shows every location, one column each.
Columns: Item, Code, then for each location its quantity and its value, headed with the location's name and value (that quantity at the item's cost), then Total, In larger units (when an item has a larger unit), Avg cost or Unit cost, and Value at cost. The locations' values add up to the item's value at cost.
Rows: one per item that has stock somewhere, then a TOTAL row with each location's quantity and value.
Drill down: double-click a quantity under a location to open the item's stock card at that location: every movement on that shelf. Click the item's name or the row to open the item.
Tip: Use it to decide what to move between stores, then do it with Transfer Inventory.
Slow-moving Stock
What it answers: items in stock that sold nothing at all in the period: money sitting on a shelf.
Date: a period. Filters: location.
Columns: Item, Code, Category, On hand, Sold in period (always blank, by definition), Last sold and Tied-up cash (on hand at cost).
Last sold is the last time the item ever sold, not just within the period. Never means it has never been sold.
Rows: the most money tied up first, then a TOTAL TIED UP row. An item that sold and was then returned in full did move, so it is not listed.
Drill down: double-click an item to open it.
Days of Stock Cover
Report Centre only.
What it answers: how long the stock you have will last, at the rate it sold in the period.
Date: a period (the sales rate is taken from it). Filters: location.
Columns:
| Column | What it shows |
|---|---|
| Item, Code | The item. Click the name to open it. |
| Sold in period | Units sold, net of returns. |
| Per day | Sold in period divided by the days in the period. |
| On hand | Current quantity. |
| Reorder level | The item's reorder point. |
| Days of cover | On hand divided by the daily rate. |
| Runs out about | Today plus the days of cover. |
Rows: the item running out soonest first. Items that did not sell in the period have no rate and are listed last.
Drill down: double-click an item that sold to open Sales by Item Detail for it and the period; for an item that did not sell, the item opens.
Tip: Choose a period that looks like normal trading. A holiday month overstates the rate and makes cover look shorter than it is.
ABC Analysis
Report Centre only.
What it answers: which few items make most of your sales, and which make up the long tail.
Date: a period. Filters: location.
Items are ranked by sales excluding tax, net of returns. A items together make the first 80% of sales, B the next 15%, C the last 5%.
Columns: Item, Code, Class, Units sold, Sales excl. tax, Share, Cumulative share, On hand and Stock value at cost (today's).
Rows: three sections, A, B and C, each with its item count and a subtotal, then a TOTAL row. Items that sold nothing are not ranked; see Slow-moving Stock for those.
Drill down: double-click an item to open it; click its Sales excl. tax to open Sales by Item Detail for it.
Tip: Never let an A item run out. Look hard at C items with a large stock value: they may not earn their shelf space.
Inventory Aging
What it answers: how long stock has been sitting, by age bracket.
Date: none (as of today). Filters: location.
Each item is aged from the last time it was received, by bill or opening stock.
Rows: sections 0 – 30 days, 31 – 90 days, 91 – 180 days, 181 – 365 days, Over a year and No receipt on record (stock that arrived without a bill or opening-stock entry, so there is nothing to age it from). Within each, the largest value first, with a subtotal. A TOTAL row closes the report.
Columns: Item, Code, On hand, Last received, Days and Value at cost.
Drill down: double-click an item to open it.
Negative Stock
What it answers: items the books believe there are fewer than none of.
Date: none (current). Filters: location.
Columns: Item, Code, Location, On hand (negative) and Value at cost.
Rows: one per item per location, most negative first. The total line counts the shelf locations affected.
Drill down: double-click a line to open the item's stock card at that location, with every movement there.
Why it matters: negative stock usually means goods were sold before the bill or receipt was entered, or were received at a different location. Until the receipt or a count corrects it, both the stock value and the cost of goods sold are wrong.
Tip: Enter the missing bill or receipt first. If the stock really is not there, count it and adjust with Adjust Quantity/Value on Hand.
Adjustments
Stock Adjustment Detail
What it answers: everything written off, corrected or found on a count in a period, and why.
Date: a period. Filters: location.
Columns:
| Column | What it shows |
|---|---|
| Date | The adjustment date. |
| Reference | Its Ref. No. |
| Location | Where the stock was adjusted. |
| Type | Damage / loss, Correction or Stock found. |
| Reason | The start of the note on the adjustment. |
| Item | The item. Click it to open the item. |
| Code | The item's code (SKU). |
| Qty | The quantity, signed: negative for stock taken out, positive for stock found on a count. |
| Value at cost | Quantity times the cost recorded on the adjustment, signed the same way. |
Rows: one per adjustment line, then a TOTAL row. Because Qty and Value are signed, the total is the net change to your stock. When both directions appear, a note gives the amount removed and the amount found. When an amount was recovered on the adjustments (insurance, a vendor credit or salvage), a note gives the total recovered.
Drill down: double-click a line to open the adjustment; double-click the item or its code to open the item.
Physical Count Detail
What it answers: every item counted on a posted Physical Count voucher: what the books held, what was counted, the difference, and what it did to the value of your stock.
Date: a period (the vouchers' Adjustment Dates). Filters: location.
Columns:
| Column | What it shows |
|---|---|
| Voucher | The voucher, as Physical Count 12. |
| Date | The voucher's Adjustment Date. |
| Ref. No. | The voucher's number. |
| Location | The location counted. |
| Item, Code | The item. Click either to open the item's Product 360. |
| On hand | What the books held when the voucher was posted. |
| Counted | What was counted. |
| Difference | Counted less On hand. |
| Value change | What posting did to the value of the stock (with Adjust Value, the change in cost as well). |
Rows: one per counted item, then a TOTAL row. Items left blank on a voucher were not counted and are not listed. Drafts and reversed vouchers are left out.
Drill down: double-click a line to open its voucher.
Assemblies
Pending Builds
What it answers: builds that were saved but not yet finished.
Date: none (current). Filters: none.
Columns: Date, Num, Item (what is being built), Code, Qty and Memo. A note gives the number of pending builds.
Drill down: double-click a build to open it and finish it. See Build Assemblies.
Other screens on this menu
Inventory Reports
Reports ▸ Inventory ▸ Inventory Reports opens the inventory screen of the report tabs: each item's on hand, unit cost, stock value and retail value, with each row opening the item's ledger across every location. See The Sales, Purchases, Inventory, Damaged and Tax report screens.
Damaged Goods
Reports ▸ Inventory ▸ Damaged Goods lists stock written off as damaged, with the loss value, the warehouse, the invoice and customer it came back from, and the reason. See The Sales, Purchases, Inventory, Damaged and Tax report screens.
Serial Number Lookup
Reports ▸ Inventory ▸ Serial Number Lookup finds a serial number and shows where it came from and where it went. See Serial Number Lookup.
Lot Expiration
Reports ▸ Inventory ▸ Lot Expiration lists lots and their expiry dates. See Lot numbers and expiry.
Common problems
Inventory Valuation Summary does not agree with the Inventory Asset account. Read the note: it gives both figures. The report values stock at each item's current cost, while the books recorded the cost on each bill when the goods arrived, so a small difference is expected when costs change. A large one usually means stock was added without a bill or opening-stock entry, or opening stock was never journalled. Run Control Account Reconciliation in the Accountant & Taxes reports.
Inventory Valuation Detail does not end at the quantity on hand. It is not meant to: its running column starts at zero at the beginning of the period. Use Stock Movement Summary to see opening and closing quantities.
An item is missing from Inventory Stock Status by Item. Only items that track stock are listed. Turn on stock tracking on the item to have it listed; set Warn me below to have it watched for reordering.
Negative quantities appear. Open Negative Stock, click each line and look at the movements at that location. Usually a bill or receipt is missing or was entered at the wrong location.
Related articles
- Stock Levels
- Adjust Quantity/Value on Hand
- Transfer Inventory between locations
- Reorder Levels
- Purchases reports
- Drilling down from a report
Related articles
Something unclear or out of date? Write to support@aantar.com and name this page.