Inventory Value
Report Guide for Users
What this report shows, the choices you make when running it, and how to read each section.
What this report is for
The Inventory Value report tells you what your inventory was worth as of a specific date — both at cost (what you paid for it) and at retail (what it would sell for). It's useful for accounting purposes, like valuing inventory at the end of a month or year.
How the report works
You choose a single "as of" date. The report looks back at each active product's inventory balance as it stood on that date and multiplies it by that product's unit cost and unit price to calculate the total cost value and total retail value of your inventory at that point in time.
The choices you make when running it
There's only one setting to consider.
| Setting | What it does |
|---|---|
| As Of Date | The point-in-time date you want to value your inventory as of. Balances are pulled from the most recent inventory record on or before this date. |
Columns on the report
| Column | Description |
|---|---|
| Product Id | The internal identifier for the product. |
| Product Name | The name of the product. |
| Unit Cost | What you pay per unit of the product. |
| Unit Price | What you sell the product for per unit. |
| Current Balance | The quantity of that product on hand as of your As Of Date. |
| Current Balance Cost | The value of that balance at cost (Current Balance × Unit Cost) — what that quantity of inventory cost you. |
| Current Balance Price | The value of that balance at retail (Current Balance × Unit Price) — what that quantity of inventory would sell for. |
How to read the layout
Products are listed alphabetically by name, with one row per active product. At the bottom of the report, the Current Balance Cost and Current Balance Price columns are totaled, giving you your total inventory value at cost and at retail as of the date you selected.
Comments
Please sign in to leave a comment.