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?
- Open the report. Go to Analytics > Reports, click the Category filter, click Inventory, then click Month-end inventory value.
- Set the date. Click the Calendar icon, choose Custom range, enter December 1, 2026 to December 31, 2026, and click Apply.
- Read the total. The Summary row adds up Total inventory value, which is Cost × Ending quantity for each variant.
- Export it. Click the Horizontal menu icon, choose Export, pick CSV, and click Export.
- Export the Month-end inventory snapshot for the same range. It lists ending quantities for variants adjusted or ordered in the last three years.
- 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?
- 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.
- 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.
- 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.
- 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.
- 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.
- 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:
| SKU | Shopify on hand, Dec 31 | Cost per item | In Shopify’s total | Counted | Value at count |
|---|---|---|---|---|---|
| TEE-BLK-M | 120 | 6.50 | 780.00 | 112 | 728.00 |
| MUG-12OZ | 40 | none | 0.00 | 40 | 124.00 at 3.10 from the invoice |
| CAP-NVY | 15, 5 of them damaged | 4.00 | 60.00 | 15 | Ask 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?
| Option | Good when | Watch for |
|---|---|---|
| Do it yourself | One location, costs on every variant, and a count you trust | Uncosted variants and committed units slip into the total |
| Buy an inventory or reporting app | Many SKUs and locations, and you want costs from purchase orders | It reports only the costs and counts it is given |
| Hire a freelancer | A bookkeeper who knows Shopify can run the count and the QuickBooks entry | Whether 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 QuickBooks | Needs a count and supplier invoices from your side |
Sources
- Inventory reports, Shopify Help Center,
- Understanding inventory states, Shopify Help Center,
- Adding cost per item to products, Shopify Help Center,
- Viewing inventory adjustment history, Shopify Help Center,
- Set a date or time range for a report, Shopify Help Center,
- Exporting reports, Shopify Help Center,
- Purchase order reports, Shopify Help Center,
- Creating and managing stock counts, Shopify Help Center,
- Publication 538, Accounting Periods and Methods, IRS,
- Instructions for Form 1120-S (2025), IRS,
- Impacts of inventory tracking on the Balance Sheet and Profit & Loss reports in QuickBooks Online, Intuit QuickBooks,
- Adjust inventory quantity on hand in QuickBooks Online, Intuit QuickBooks,