Field guide · E-commerce brands · Shopify

Shopify year-end inventory report: get the December 31 value

Shopify’s year-end inventory report is the Month-end inventory value report. Run it for a range ending December 31 and it multiplies each variant’s On hand quantity at the end of that day by its cost per item.

Published · Get the PDF

Before the total goes to your accountant, find the items with no cost, check the committed and damaged units, and compare it with a physical count.

Can Shopify still show stock as of December 31?

Yes. Inventory report history goes back to October 1, 2023, so you can run December 31, 2025 now and December 31, 2026 any time after that day.

  • Per-product history is 180 days. Older answers say 90; for anything older, use the Inventory adjustment changes report.
  • Deleted locations drop out. Their history stops showing in inventory reports, so export before you delete a warehouse or 3PL location.
  • Deleted products stop at deletion. A variant deleted after January 14, 2026 shows data only up to its deletion date.

How do you run the December 31 value in Shopify?

  1. Open the report. Go to Analytics > Reports, click the Category filter, click Inventory, then click Month-end inventory value.
  2. Set the date. Click the Calendar icon, choose Custom range, enter December 1, 2026 to December 31, 2026, and click Apply.
  3. Read the total. The Summary row adds up Total inventory value, which is Cost × Ending quantity for each variant.
  4. Export it. Click the Horizontal menu icon, choose Export, pick CSV, and click Export.
  5. Export the Month-end inventory snapshot for the same range. It lists ending quantities for variants adjusted or ordered in the last three years.
  6. Repeat both for December 2025. That is your beginning inventory for the year.

From October 1, 2026 these reports count On hand (Available, Committed and Unavailable) instead of Available. Earlier data still shows Available, so your December 2025 and December 2026 figures measure different things.

What makes Shopify’s number wrong?

  • Variants with no cost add nothing. The report totals only products with a cost per item.
  • Cost is typed, not calculated. Cost per item is whatever someone entered on the product, in the bulk editor or by CSV.
  • On hand includes sold and damaged units. Committed covers unfulfilled orders, draft orders and transfers marked ready to ship; Unavailable can include damaged, quality control and safety stock. The IRS says to leave out goods you have sold once title passes to the buyer, and to value damaged goods “at their bona fide selling price minus direct cost of disposition.”
  • Goods in transit are left out. Incoming transfer units are excluded, yet the IRS counts purchased goods once title passes, “even if the merchandise is in transit.” The Purchases on order report lists open purchase orders with no linked transfer.
  • The counts drift. Oversold variants and variants with tracking turned off can end the month below zero. See why Shopify stock counts drift and adding a 3PL to Shopify without breaking stock counts.

How do you check it against a count and QuickBooks Online?

  1. Find the uncosted items. Match the snapshot export to the value export on SKU. Every SKU with a positive ending quantity and no cost needs one from its supplier invoice.
  2. Count the stock. The IRS says “You must take a physical inventory at reasonable intervals” and the book amount “must be adjusted to agree with the actual inventory.” Count on December 31 or before the first January shipment.
  3. Use Shopify stock counts, or paper. Go to Products > Inventory > Stock counts, click Create count, click Select location to count, add products, click Add to count, then Save. One count covers one location, approving it updates inventory and can’t be undone, and counts can’t be exported.
  4. Price the differences. The free inventory count variance report matches your count sheet to a Shopify export on SKU and prices each gap at cost.
  5. Compare with QuickBooks Online. If you track inventory there, run the Inventory Valuation Summary for December 31 on an accrual basis. Intuit says quantity on hand, COGS and inventory asset values may be wrong on a cash basis.
  6. Book the count. On Plus or Advanced, go to + Create > Inventory qty adjustment, set the Adjustment date to 12/31/2026, and pick the Inventory adjustment account your accountant names.

Example:

SKUShopify on hand, Dec 31Cost per itemIn Shopify’s totalCountedValue at count
TEE-BLK-M1206.50780.00112728.00
MUG-12OZ40none0.0040124.00 at 3.10 from the invoice
CAP-NVY15, 5 of them damaged4.0060.0015Ask your accountant about the 5

Ending inventory also sets cost of goods sold, so a wrong December 31 value moves your profit. Fixing missing costs in the Shopify COGS report covers the rest of that sum.

When does your accountant need it?

The IRS says “you must value your inventory at the beginning and end of each tax year,” with an exception for some small businesses. Ask your accountant which applies to you.

An S corporation files Form 1120-S by the 15th day of the 3rd month after its tax year ends (March 15, 2027 for calendar 2026) and attaches Form 1125-A, Cost of Goods Sold, if it applies. Ask your accountant when they need the figure.

What are your options?

OptionGood whenWatch for
Do it yourselfOne location, costs on every variant, and a count you trustUncosted variants and committed units slip into the total
Buy an inventory or reporting appMany SKUs and locations, and you want costs from purchase ordersIt reports only the costs and counts it is given
Hire a freelancerA bookkeeper who knows Shopify can run the count and the QuickBooks entryWhether next year’s report can be run without them
Bring in an outside team (Reports & answers)You want the December 31 value rebuilt, priced and tied to QuickBooksNeeds a count and supplier invoices from your side

Sources

Have one problem in mind?

Walk us through it on a free 30-minute call. Within two business days you get a one-page note on what we’d fix first, yours to keep.

Walk us through one problemFree 30-minute call.