Inventory On Specific Day Report for Shopify
A point-in-time snapshot of exactly what you had in stock on any past date — by product, variant, SKU, and location — for month-end accounting, audits, and cross-date comparison.
5 from 1,800+ merchants
2,000+ data fields
Trusted by 40,000+ Shopify stores
Updated June 2026
.png)
.png)
.svg)
.svg)
.svg)
Why this report matters
Shopify shows you what’s in stock now. It does not let you ask "what did I have on March 31st?" — and that question is exactly what accounting, audits, and period-end close depend on. Without historical snapshots, reconstructing a past stock position means guesswork.
The Inventory On Specific Day Report solves this by reading from a daily snapshot that records your stock at the close of every day. Pick a date, and the report rebuilds your exact position: units per variant, per location, with cost and retail value. That gives finance a defensible ending-inventory figure for the balance sheet, gives auditors a clean trail, and lets analysts compare any two dates to see how stock actually moved.
It also captures the messy reality of inventory — incoming stock that arrived, units rejected as damaged, and returns to suppliers — so the snapshot reflects sellable stock, not just gross receipts.
What’s included in the report
Snapshot Date
The specific past date the report reconstructs. Inventory values are shown exactly as they were at the end of that day.
Example: Snapshot Date = 2026-03-31 returns your stock position for fiscal month-end.
Heads up: Report Pundit can only return accurate historical data from the moment the Snapshot feature is enabled for your store. For dates before activation, stock can be approximated from order and date values, but that approximation is less accurate if products were restocked during the period.
Identification
Product Title
Name of the product.
Variant Title
The variant — color, size, etc.
SKU
Unique stock-keeping identifier.
Location
The warehouse, store, or 3PL the stock sat in on that date.
Example: main_warehouse, flagship_store, shipbob_east
Quantity & value (as of the date)
Inventory Quantity
Units in stock for that variant at that location on the snapshot date.
Incoming Inventory
Units booked in as received on that date.
Example: Order 100 tees from a supplier; all 100 arrive and are booked → snapshot shows 100 incoming for that location that day.
Rejected Inventory
Units that arrived but couldn’t be sold — damaged, defective, or mis-shipped — and were recorded as rejected rather than added to sellable stock.
Example: Of those 100 tees, 10 arrive with print defects → 10 recorded as rejected, 90 added to available stock.
Inventory Cost
Formula: Product Cost × Inventory Quantity
Value of the snapshot stock at cost — the figure finance needs for ending inventory.
Inventory Value
Formula: Product Price × Inventory Quantity
Value of the snapshot stock at retail price.
Vendor · Product Type · Collections · Product Status · Starting vs. ending day comparison · Cross-date delta
Who uses this report
01. Finance teams closing the month
02. Auditors verifying historical stock
03. Analysts comparing two dates
04. Ops teams investigating a discrepancy
How to read the report
Patterns to look for first:
- Incoming vs. rejected on the same date. A high rejected count on a receiving day points to a supplier quality problem worth tracking.
- Cross-date deltas. Comparing two snapshots reveals real movement — and any unexplained shrink between them.
- Pre-activation dates are approximations. Anything before Snapshot was enabled is estimated from orders, not recorded — treat it as directional, not exact.
- Location-level reconstruction. Snapshots are per location, so you can see exactly where stock sat on any given day, not just the total.
How to build the report in Report Pundit
A one-time enablement, then 5 minutes per report. No code, no SQL.
- Install Report Pundit. from the Shopify App Store — 14-day free trial, no card required.
- Enable the Snapshot feature. this report runs on daily snapshots, which are turned on by a one-time request to Report Pundit support. From the moment it’s enabled, your store records inventory at the end of every day.
- Open Pre-built Reports. and select Inventory On Specific Day from the Inventory category.
- Choose the snapshot date. pick the past date you want to reconstruct — month-end, quarter-end, or any specific day.
- Apply filters. narrow by location, vendor, product type, or collection.
- Customize columns. add Incoming Inventory, Rejected Inventory, cost, and retail value as needed.
- Run the report. the report rebuilds your exact stock position for that date.
- Export or schedule. export to PDF for the audit trail, or schedule a month-end snapshot to finance automatically.
Customization & filters
- Pick any snapshot date — month-end, quarter-end, or a specific day.
- Compare two dates — run start-of-period and end-of-period snapshots side by side.
- Filter by location — reconstruct stock at one warehouse or all.
- Add Incoming / Rejected columns — see receiving activity on the date.
- Add cost and retail value — for accounting and valuation.
- Schedule month-end — auto-deliver the period-end snapshot to finance.
Automate & export
- Schedules — hourly, daily, weekly, monthly, or custom cron
- Delivery formats — Excel, CSV, PDF, or push to Google Sheets in real time
- Group by month or week — trends instead of a static snapshot
- Destinations — email (multiple recipients), Google Sheets, Google Drive, FTP/SFTP, Looker Studio, BigQuery
- Conditional alerts — get notified only if a channel's net sales drop more than X% week-over-week
Report Pundit vs Shopify's native Sales by Channel report
Frequently Asked Questions
A report that reconstructs your exact stock position on any chosen past date — units, location, and value for every product and variant — using Report Pundit’s daily inventory snapshot.
The report depends on the Snapshot feature, which is turned on by a one-time request to Report Pundit support. From the moment it’s enabled, your store records inventory at the close of each day.
Only as an approximation. Report Pundit can estimate pre-activation stock from order and date values, but it’s less accurate if products were restocked during that period. Accurate data is available from activation onward.
Benefits
.svg)
Granular Product-Level Insights
.png)
Discount Analysis
.svg)
Order Tracking
Related Reports
Inventory by Location
A report organized by inventory locations, detailing products and variants on hand, with a breakdown of the value for each product.
Out of Stock Product
A report listing products that are out of stock, including essential details such as product inventory and the location where the stock was depleted.
Inventory Reorder Point
This report helps identify the exact point at which inventory should be restocked to prevent any interruptions in product availability, ensuring a smooth supply chain from both your inventory and your vendor's end. It informs the merchant about the sales velocity, lead time, and safety stock.
Low Stock Product
The Low Stock Product Report highlights products that are approaching or have reached a low stock threshold, helping Shopify merchants proactively manage restocking needs. This report is crucial for preventing stockouts on popular items and ensuring seamless sales without interruption
Inventory by Collections
This report provides a detailed view of inventory levels, organized by product collections, allowing businesses to track stock availability and manage inventory efficiently.
Inventory on Hand
A real-time snapshot of every product, variant, and SKU in stock - across every warehouse, retail location, and 3PL - with vendor, cost, and inventory value in a single view.
Inventory by Product Type
This is grouped inventory data organized by custom product types, alongside product and variant details, providing a comprehensive view to analyze overall inventory status.
Inventory level Indicator
The report provides Shopify merchants with a real-time analysis of stock levels, highlighting products that are overstocked, optimally stocked, or understocked. This report is essential for monitoring stock health and ensuring that inventory levels align with demand.
Inventory Status
A comprehensive overview of product inventory, detailing the quantity available for products that are live, in draft, or have been archived.
Inventory Replenishment
A ready-to-action list of exactly which products need reordering now — driven by real sell-through velocity, adjusted for stock already on its way, and broken down by location.
Inventory Sale Value
A report outlining the sale value of your inventory, including details on product quantities, variants, collections, and total value based on current sale prices for analysis.
Inventory Sell-Through
The percentage of stock that actually sold for every product and variant so you can separate the fast-movers worth reordering from the dead stock eating your shelf space and cash.
Build and automate your Shopify Reporting
Unlock the full potential of your Shopify store with Report Pundit. Gain access to over 2000 data fields, automate reports, and make data-backed decisions to grow your business.