The stock count for the day the accountant asks about
Quarter end, year end, the day before the sale
Any captured day, by product, variant and location, with the value at cost beside it. The count your accountant wants, without a spreadsheet from memory.
Two dates side by side
Run it for the first and last day of the month and the difference is your movement. "Stock over time" charts the days between.
Captured on the last day, every month
Schedule it for the first of the month, asking for the previous day, as Excel to finance. The month-end count arrives on its own.
Or we build the version you need
One sheet per location, or value at cost by vendor on a date? Describe it in the app and our team builds it. How it works.
What it looks like
Pick a date when the report runs and it shows every product, variant and location as they stood at the end of that day: the units, and what they were worth at cost and at retail. Sorted by product. This version leaves out the unavailable units, available value and currency columns the built-in also carries. The bottle has no cost in Shopify, so its on-hand value is blank.
| Snapshot date | Product | Variant | SKU | Location | Available | On hand | Committed | Incoming | On-hand value | Retail value |
|---|---|---|---|---|---|---|---|---|---|---|
| 30 Sep 2026 | Alpine Shell Jacket | Navy, M | ASJ-NVY-M | Reno warehouse | 102 | 108 | 6 | 0 | $9,558.00 | $24,480.00 |
| 30 Sep 2026 | Daypack 22L | Green | DP22-GRN | Reno warehouse | 150 | 158 | 8 | 200 | $4,297.60 | $13,500.00 |
| 30 Sep 2026 | Insulated Bottle 750ml | Steel | IB750-STL | Reno warehouse | 470 | 486 | 16 | 0 | $11,750.00 | |
| 30 Sep 2026 | Merino Crew Sock 3-pack | L | MCS-3PK-L | Reno warehouse | 905 | 950 | 45 | 600 | $8,930.00 | $25,340.00 |
| 30 Sep 2026 | Merino Crew Sock 3-pack | L | MCS-3PK-L | Toronto 3PL | 230 | 236 | 6 | 0 | $2,218.40 | $6,440.00 |
| 30 Sep 2026 | Trail Runner 2 | Black, 10 | TR2-BLK-10 | Reno warehouse | 260 | 284 | 24 | 120 | $11,644.00 | $33,800.00 |
What each number means
So the figure means the same thing to everyone who reads it.
- Snapshot date
- The day you asked for, in your store's timezone. The report asks for it each time it runs, so one saved report answers for any day.
- Available, on hand, committed, incoming
- The same four counts as "Inventory by location", as they stood at the end of that day. Unavailable units are a column you can add back.
- On-hand value
- On-hand units times the cost per item recorded that day. A variant with no cost shows blank rather than zero.
- Retail value
- Available units times the selling price recorded that day.
- How far back
- ReportNerds captures your stock every day from the time it is installed, so history starts then. A day that was never captured stays blank instead of showing a made-up zero.
- Shopify's own version
- Shopify's "Month-end inventory snapshot" report shows on-hand units at the end of each month (Shopify Help). This report gives you any day, per location, with the value beside it.
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?
Inventory value
What is the stock we hold worth right now, at cost and at retail?
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?
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.