Reporting Explained: Physical Inventory Summarized

Reporting Explained: Physical Inventory Summarized


Use this report to review summarized physical inventory results. It helps you:

  • Validate inventory accuracy
  • Identify variances in quantity and cost
  • Confirm the financial impact of a physical inventory

 
Standard Reports > Physical Inventories  


The Physical Inventory Summary report provides a high-level view of inventory before and after a physical count.

It includes:

  • On-hand quantities before the physical
  • Counted quantities and costs
  • Updated on-hand values after commitment
  • Variances in quantity and cost

You can run the report by:

  • Category
  • Department
  • Store 

Generate the report

  1. Go to Reports > Standard Reports
  2. Select Physical Inventories
  3. Select a report version:
    • Category
    • Department
    • Store
  4. Apply filters (date and store)
  5. Click Generate  
 

ColumnDescription
Previous On HandQuantity on hand immediately before the physical (based on effective date/time)
Item Counted QuantityQuantity of inventory items counted
Related Counted QuantityQuantity of related items (child or batch items) counted
Total Counted QuantityTotal counted quantity, including items and related counts
Counted CostCost of counted items at the time of the physical
New On HandUpdated on-hand quantity after the physical is committed
New On Hand CostTotal cost of inventory after the physical is committed
Variance QuantityDifference between expected and counted quantities
Variance CostFinancial impact of the variance

    • Related Articles

    • Reporting Explained: Summary By Period

      The Inventory Summary by Period report provides an overview of inventory activity for a selected date and time range. It shows the starting inventory cost, all inventory movements during the period, and the ending inventory cost. Reports > Standard ...
    • Reporting Explained: Inventory Transfers

      Admin / power user · Yellow Dog Inventory 2026 WHY IT'S IMPORTANT The Inventory Transfers Report provides an overview of transfers issued and accepted within a selected time period. It shows the issuing and accepting locations, the issued and ...
    • Reporting Explained: Inventory Chart on Hand by Selected Dimension

      Use this report to visualize on-hand inventory totals by dimension. It helps you: Compare inventory across categories (for example, size, type, or location) Identify concentration of inventory value Support purchasing and inventory balancing ...
    • Reporting Explained: Physical Inventory (detailed by Physical)

      The Physical Inventory > Detailed (select by physical) report provides a comprehensive view of a Physical Inventory. It shows: All items included in the physical Quantities counted Previous on-hand quantities Variance quantities and variance costs ...
    • Reporting Explained: Inventory Requests

      Use this report to: Track request activity over time Monitor request status and completion Review quantities and costs Standard Reports > Purchasing > Inventory Requests The report pulls all inventory requests based on your selected filters. It ...
    • Popular Articles

    • How To: Find Your Yellow Dog Inventory Version

      Understanding which version of Yellow Dog Inventory you're using is essential when exploring new features, as some enhancements and functionalities are specific to certain versions. All client types can benefit from knowing their Yellow Dog Inventory ...
    • Feature Overview: Par & Re-Order Points

      Par levels and reorder points help streamline purchasing in Yellow Dog. Par level is the ideal quantity to keep on hand. Reorder point is the minimum quantity that triggers reordering. You can update par and reorder points in the following locations: ...
    • How To: Install the Zebra ZD411 Printer Driver

      End user · Yellow Dog Inventory 2026 WHY IT'S IMPORTANT When you install the correct driver, Windows can communicate with your Zebra ZD411 printer so it prints labels and tags reliably from Yellow Dog Inventory. Without the driver, the ZD411 will not ...
    • FAQs: What are Bins?

      End user · Yellow Dog Inventory 2026 Question: What are Bins? Answer: Bins are optional location identifiers that specify exactly where an item is stored. The Bin field is free text, so you can use letters or numbers. You don’t need to create bins in ...
    • Food and Beverage User Manual

      The Food & Beverage User Manual is your key to understanding the potential of Yellow Dog. Whether you're a first-time user or a seasoned pro, this detailed manual will help you understand how to best utilize your Yellow Dog Inventory system. Download ...