Shopify stock report for any past date

What did we hold, where, and what was it worth, on any past day?

Install on Shopify

14-day free trial.

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.

Sample output, 30 September 2026The built-in "Inventory on a date" report. Made-up store, made-up numbers.
Snapshot dateProductVariantSKULocationAvailableOn handCommittedIncomingOn-hand valueRetail value
30 Sep 2026Alpine Shell JacketNavy, MASJ-NVY-MReno warehouse10210860$9,558.00$24,480.00
30 Sep 2026Daypack 22LGreenDP22-GRNReno warehouse1501588200$4,297.60$13,500.00
30 Sep 2026Insulated Bottle 750mlSteelIB750-STLReno warehouse470486160$11,750.00
30 Sep 2026Merino Crew Sock 3-packLMCS-3PK-LReno warehouse90595045600$8,930.00$25,340.00
30 Sep 2026Merino Crew Sock 3-packLMCS-3PK-LToronto 3PL23023660$2,218.40$6,440.00
30 Sep 2026Trail Runner 2Black, 10TR2-BLK-10Reno warehouse26028424120$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.

Want this report for your store?

Install ReportNerds and run it on your own orders, or tell us the version you need and our nerds build it. 14-day free trial.

Install on Shopify