Know what your stock is worth, at cost and at retail
Captured dates, not just month end
Today, the last day of the quarter, the day before the sale started. Value history shows how it moved.
By location, by vendor, by type
Open "Inventory by location" for available, on hand, committed and incoming per site. Group by vendor to see where the money is sitting.
With finance before they ask
Schedule it for the first of the month as an Excel attachment. Add a Unit cost column and a filter for empty costs, and the clean-up list comes with it.
Or we build it in your shape
One row per location with cost and retail side by side? Describe it in the app and our team builds it. How it works.
What it looks like
One row per variant: the units available right now, what they cost you and what they would sell for. This version adds a Unit cost column to the built-in. The last row has no cost in Shopify, so its value at cost is $0.00 and the blank tells you which variant to fix.
| SKU | Variant | Available | Unit cost | Value at cost | Price | Value at retail |
|---|---|---|---|---|---|---|
| TR2-BLK-10 | Trail Runner 2, Black, 10 | 318 | $41.00 | $13,038.00 | $130.00 | $41,340.00 |
| TR2-BLK-11 | Trail Runner 2, Black, 11 | 264 | $41.00 | $10,824.00 | $130.00 | $34,320.00 |
| MCS-3PK-L | Merino Crew Sock 3-pack, L | 1,020 | $9.40 | $9,588.00 | $28.00 | $28,560.00 |
| ASJ-NVY-M | Alpine Shell Jacket, Navy, M | 96 | $88.50 | $8,496.00 | $240.00 | $23,040.00 |
| DP22-GRN | Daypack 22L, Green | 141 | $27.20 | $3,835.20 | $90.00 | $12,690.00 |
| IB750-STL | Insulated Bottle 750ml, Steel | 455 | $0.00 | $25.00 | $11,375.00 | |
| Total | 2,294 | $45,781.20 | $151,325.00 |
What each number means
So the figure means the same thing to everyone who reads it.
- Available
- Units available to sell across your locations. On hand, committed and incoming are separate fields you can add.
- Unit cost
- The cost per item on the variant in Shopify.
- Value at cost
- Available times unit cost. A variant with no cost in Shopify contributes $0.00, and an added Unit cost column shows you which ones.
- Price
- The variant's current selling price.
- Value at retail
- Available times price. What the stock would bring in at full price.
- Past dates
- This report is today's picture. "Inventory on a date" and "Inventory value history" give you the same figures for any captured date.
Already have Shopify's reports?
Shopify's own reports can be edited, saved and exported to a spreadsheet (Shopify Help). That covers a one-off. ReportNerds keeps the exact version your team needs, sends it on a schedule, and our nerds build the ones you would rather not.
More reports
Sales by product
What did each product actually earn after discounts and refunds?
Gross margin by product
Which products make money after the cost of goods, and which only look like they do?
Sales by vendor
Which vendors' products earned the most after discounts and refunds?
Inventory by location
How many units of each SKU sit at each location, and how many are already spoken for?
Inventory on a date
What did we hold, where, and what was it worth, on any past day?
Monthly tax summary
How much tax was recorded on last month's orders, and where?
Custom reporting
Your reports, your shape, on schedule. Or our team builds them for you.