Inventory On-Hand & Valuation Reports
AccuArk provides four reports under the On-Hand & Valuation submenu that give you a clear picture of what inventory you currently have, where it is located, what it is worth, and what needs to be reordered. These reports are essential for day-to-day inventory management and financial planning.
Accessing These Reports
From the main menu bar, navigate to:
Reports > Inventory > On-Hand & Valuation
You will see four report options:
- Stock Availability Report
- Stock by Location
- Inventory Valuation Report
- Reorder Alert Report
Permission Required
All four reports require the RPT_VIEW_INV_ONHAND permission. Super Admins and Location Admins have this permission by default. Other roles need it explicitly assigned through the role permissions screen.
Stock Availability Report
The Stock Availability Report shows current inventory quantities for every item, broken down by what is physically on hand, what is committed to open orders, and what is actually available for new sales.
Columns
| Column | Description |
|---|---|
| Item | Product name |
| SKU | Stock keeping unit identifier |
| Category | Product category |
| Location | Store or warehouse location |
| Qty On Hand | Total physical quantity at the location |
| Qty Committed | Quantity reserved by open invoices or orders |
| Qty Available | On Hand minus Committed; the quantity free for new sales |
| Reorder Point | The threshold below which the item should be reordered |
Understanding the Quantity Fields
- Qty On Hand is the total physical stock count at a location. This number changes when items are received, sold, adjusted, or transferred.
- Qty Committed represents stock that has been allocated to open invoices, pending orders, or transfer requests but has not yet left the building. These items are physically present but spoken for.
- Qty Available is the difference: On Hand minus Committed. This is the true sellable quantity. If a customer asks whether you have something in stock, Qty Available is the number to reference.
Filters
- Location — View stock for a single location or across all locations
Tips
- Export this report to CSV and use it as a picking reference when fulfilling orders
- Sort by Qty Available ascending to quickly find items that are running low
- If Qty Committed is consistently high relative to Qty On Hand, consider increasing reorder points
Stock by Location
The Stock by Location report presents a cross-tabular view of inventory quantities across all your locations. Each location gets its own column, making it easy to compare stock levels side by side.
Columns
| Column | Description |
|---|---|
| Item | Product name |
| Location 1 Qty | Quantity on hand at the first location |
| Location 2 Qty | Quantity on hand at the second location |
| ... | Additional columns for each location |
| Total Qty | Sum of all location quantities |
Tips
- Use this report to identify imbalances where one location is overstocked while another is running low
- This report is especially useful before initiating inter-location transfers
- Export to CSV for further analysis in a spreadsheet, particularly if you have many locations
Inventory Valuation Report
The Inventory Valuation Report calculates the total monetary value of your current inventory using cost-based valuation. This is critical for financial reporting, insurance, and understanding your investment in inventory.
Columns
| Column | Description |
|---|---|
| Item | Product name |
| SKU | Stock keeping unit identifier |
| Qty On Hand | Current quantity in stock |
| Unit Cost | Cost per unit (your purchase price) |
| Extended Cost | Qty On Hand multiplied by Unit Cost |
| Retail Price | Your current selling price |
| Extended Retail | Qty On Hand multiplied by Retail Price |
| Potential Margin | Extended Retail minus Extended Cost |
How Valuation Works
AccuArk uses cost-based inventory valuation. Each item's value is calculated by multiplying the current quantity on hand by its recorded unit cost. The unit cost is updated when you receive purchase orders and can also be manually adjusted.
The Extended Cost column represents the actual investment tied up in that product. The sum of all Extended Cost values at the bottom of the report gives you your total inventory value at cost.
The Potential Margin column shows how much gross profit you would earn if you sold all remaining stock at the current retail price. This is a theoretical maximum, not a guarantee, since discounts, promotions, and markdowns will affect actual margins.
Filters
- Location — View valuation for one location or all locations combined
- Date Range — The report uses a point-in-time snapshot; set the date to see valuation as of that date
Tips
- Run this report at month-end or year-end for financial statements
- Compare Extended Cost totals month over month to track whether your inventory investment is growing or shrinking
- Items with high Extended Cost but low Potential Margin may need price adjustments
Reorder Alert Report
The Reorder Alert Report lists all items whose current stock has fallen to or below their configured reorder point. This is your action list for purchasing.
Columns
| Column | Description |
|---|---|
| Item | Product name |
| SKU | Stock keeping unit identifier |
| Current Qty | Current quantity on hand |
| Reorder Point | The threshold that triggered this alert |
| Reorder Qty | Suggested quantity to order (configured per item) |
| Preferred Vendor | The default vendor for this item |
| Last Order Date | Date of the most recent purchase order for this item |
How Reorder Points Work
Each inventory item can have a reorder point and a reorder quantity configured in its item settings. When the current stock falls to or below the reorder point, the item appears on this report. The reorder quantity is the suggested amount to purchase to bring stock back to an optimal level.
For example, if an item has a reorder point of 10 and a reorder quantity of 50, it will appear on this report when stock drops to 10 or fewer units, and the report will suggest ordering 50 units.
Tips
- Review this report at the start of each day or week as part of your purchasing routine
- The Preferred Vendor column helps you quickly group items by vendor for consolidated purchase orders
- Check the Last Order Date to avoid duplicate orders for items that have already been reordered but not yet received
- Items that appear on this report repeatedly may need their reorder point or reorder quantity adjusted upward
Related Articles
- Inventory Movement & Control Reports — Track how inventory moves through your business
- Inventory Analytics Reports — Turnover, dead stock, and velocity analysis
- Getting Started with Reports & Analytics — Overview of the reporting system