Inventory Reconciliation with Shopify Reports

Inventory reconciliation is key to avoiding stock errors and ensuring smooth operations for your Shopify store. Here's why it matters and how to do it effectively:

Why It Matters: Mismatched inventory can lead to overselling, canceled orders, or lost sales, damaging customer trust and financial accuracy. In 2021, retail shrinkage cost U.S. businesses $94.5 billion.
How to Start: Use a single, reliable system for Shopify inventory management. If Shopify is your main channel, it can act as your primary system. For multi-channel businesses, an external ERP or order management system might work better.
Steps to Reconcile:
1. Set Up Your System: Ensure all apps and integrations align with your inventory data.
2. Audit Your Stock: Compare Shopify's records with physical inventory and adjust for discrepancies.
3. Fix Errors: Identify causes like human mistakes or system issues and correct them in Shopify.
4. Schedule Regular Checks: Use methods like cycle counting or ABC prioritization to reconcile inventory frequently.
5. Leverage Shopify Reports: Tools like Inventory Adjustment Changes and Month-end Inventory Snapshot help track and resolve issues.

Shopify’s New Month-End Inventory Report Explained

Shopify

Step 1: Set Up Your Primary Inventory System

Start by creating a single, reliable source for your inventory data. When multiple platforms - like Shopify, an ERP, or a warehouse management system - try to update inventory at the same time, you can run into issues like phantom adjustments, overwritten data, or missed updates. These problems make reconciling your inventory a nightmare.

As David Vance from Nventory puts it: "The moment you add Amazon, Walmart, or a B2B channel, this model [Shopify as Source of Truth] collapses - you cannot have two systems of record for the same inventory".

This confusion over the "source of truth" is a major cause of inventory headaches. To avoid problems like double-selling or inventory discrepancies, every sale, return, or cancellation should update your records in near-real-time through one authoritative system. Once you’ve established this, choose the system that best fits your sales channels.

Choose the Right System for Your Business

If Shopify is your only sales channel, it makes sense to use it as your primary system. Shopify tracks inventory at the variant level, meaning it monitors stock based on attributes like size, color, and location.

But if you’re selling across multiple channels - like Amazon, Walmart, wholesale, or physical retail - this approach won’t cut it. Multi-channel businesses often benefit from using an external ERP or order management system as their main inventory hub, with Shopify receiving updates from that system. On average, retailers only have accurate inventory visibility 70% of the time, so having a centralized system is crucial.

Once you’ve chosen your primary system, ensure all integrations are aligned to keep it accurate.

Optimize Your App Integrations

Take a close look at every app connected to your Shopify store that interacts with inventory data. Shopify uses a "last update wins" rule, meaning if two apps push updates to the same product, the most recent update will overwrite the earlier one - even if it’s less accurate. For instance, if your warehouse management app updates at 2:15 PM and your marketplace sync app updates at 2:16 PM, the latter update will take priority.

To minimize errors, separate ADD feeds (for adding new products) from SYNC feeds (for inventory and price updates). ADD feeds should only run when launching new products, while SYNC feeds can run every 2–5 minutes to keep inventory and pricing up to date. This approach not only helps prevent accidental overwrites but also reduces strain on your API limits. Always map products using SKUs or barcodes - not titles - and update inventory using Shopify's inventory_levels/set or adjust endpoints for better speed and reliability.

For Shopify-based brands looking to streamline inventory management, tools like Forstock provide a centralized dashboard, real-time analytics, and automated workflows to maintain a single, dependable inventory system.

Step 2: Run Your First Inventory Audit

After setting up your main inventory system, the next step is to establish a baseline. This involves comparing Shopify's inventory data with what's physically in your stockroom. Creating this baseline helps you catch and prevent costly mismatches moving forward.

Map Your Inventory Data Flow

Before diving into the count, it’s important to understand how your inventory moves. Shopify tracks inventory shifts through four main sources: manual changes in the admin panel, inventory apps, transfers, and order fulfillments. These movements affect inventory states like Available, Committed, Unavailable, and Incoming.

To get a clear picture, use Shopify’s Inventory Adjustment Changes Report. This report logs every inventory change, such as when an order reduces the "Available" count by three units and increases the "Committed" count by the same amount. Shopify keeps these records for 180 days, allowing you to trace changes made by third-party apps or automated processes. For more detailed insights, create a custom report using the Reference Document URI dimension to identify which external app or purchase order caused a specific adjustment.

One common issue to watch for is inconsistent units of measure. For example, if your warehouse counts inventory in cases while Shopify tracks individual pieces, you might see discrepancies that aren’t actually errors. To avoid this, make sure all systems use the same unit of measure before starting your audit.

Count Your Physical Inventory

Now it’s time to count what’s physically in your stockroom. Start by organizing and labeling your inventory to make the process smoother. If you have a large number of SKUs, use an ABC analysis to prioritize and forecast inventory costs. Focus first on Category A items, which account for roughly 80% of your revenue. Category C items, which contribute the least, can be checked less frequently.

To minimize disruptions, use cycle counting. This method audits one section or category at a time, keeping your operations running while ensuring accuracy. For quick checks between full audits, spot-check high-turnover or high-discrepancy items.

Using barcode scanners can speed up the process and help you document discrepancies on the spot with photos. Before starting the count, fulfill any outstanding orders so Shopify’s "Available" count reflects what’s truly on your shelves.

"Clean inventory numbers help us not only replenish our existing stock as needed but allow us to make more accurate predictions on how and when to replenish our inventory."
– Adam Besheer, Co-founder, Greenery Unlimited

Compare Physical and Digital Records

Once your physical count is complete, compare it to Shopify’s digital records. Use Shopify's Month-end Inventory Snapshot, which shows the "Ending quantity" for each product variant. This represents the trackable Available inventory at the end of a period, excluding committed and incoming units. Avoid comparing your count to the broader "On Hand" figure, which includes stock that isn’t immediately sellable.

If you’re using Shopify POS, the Stocky app's Stocktake feature can simplify this step. As you scan items during the count, Stocky highlights discrepancies, flagging any products the system expected but weren’t scanned. The "Missed" tab points to areas needing immediate attention.

To calculate discrepancies, use this formula: Inventory Discrepancy = System Count - Physical Count. For example, if Shopify shows 50 units but your count is 47, the discrepancy is +3, meaning Shopify lists three more units than you physically have. Additionally, track your shrinkage rate with the formula (Recorded Inventory Value - Actual Inventory Value) / Sales × 100. Most retailers aim to keep shrinkage below 1%.

For businesses managing inventory across multiple locations, tools like Forstock can streamline the process. These platforms offer real-time analytics and centralized dashboards, making it easier to reconcile physical and digital records.

Here’s a quick breakdown of how different inventory states affect the "Available" count:

Inventory State	What It Means	Included in "Available" Count?
Available	Units in stock and ready to sell	Yes
Committed	Units sold but not yet shipped	No
Unavailable	Units damaged, in quality control, or set aside as safety stock	No
Incoming	Units currently in transit	No

Step 3: Fix Inventory Discrepancies

Once you've spotted inventory mismatches, the next step is to dig into the reasons behind them and resolve the issues. Tackling discrepancies effectively is key to preventing them from escalating into larger problems.

Find the Root Cause of Discrepancies

Before making any changes, it's crucial to figure out why the discrepancies happened in the first place. Here are some common culprits:

Human error: Mistakes like typos during manual data entry, skipped barcode scans, or double-counting during stock checks.
Shrinkage and loss: Issues such as theft, product damage, expiration, or items going missing during transit.
System and integration issues: Problems syncing data between Shopify and third-party tools like Warehouse Management Systems or Point of Sale systems.
Process inconsistencies: Errors during receiving, misplaced stock, or unrecorded customer returns.
Supplier errors: Vendors sending the wrong quantities or mislabeled items.

To identify the source of the problem, use Shopify's Adjustment History page. Go to Admin > Products > Inventory > Adjustment history to see a detailed log of stock changes, including the date, activity performed, and the person responsible. Shopify retains these records for 180 days. For a more in-depth look, run the Inventory Adjustment Changes report and filter by "Inventory Change Reason" or "Reference document type." This can help you spot patterns, such as which staff members or apps frequently make adjustments. Analyze the data by SKU, category, and location to uncover recurring issues. If you're managing inventory across multiple locations, cloud inventory tools like Forstock offer real-time analytics and centralized dashboards to help you identify trends and prevent repeat problems.

Once you've pinpointed the issues, you can adjust your records directly in Shopify.

Make Manual Adjustments in Shopify

After identifying the cause, update Shopify inventory to match your physical count. Adjust the On hand (or Available) quantity by selecting the relevant location, making the necessary changes, and saving them. For damaged items, mark them as Unavailable using the appropriate category. Keep in mind that when you adjust the "On hand" quantity, the "Available" quantity is updated by the same amount. Shopify provides specific categories for adjustments, such as Damaged, Quality Control, Safety Stock, and Other.

When making adjustments, always choose a specific reason code to improve reporting accuracy. Avoid the default "Correction" option unless absolutely necessary. Instead, use categories like "Damaged", "Theft or loss", "Quality control", or "Promotion or donation." Here's a quick breakdown of common adjustment reasons:

Inventory Adjustment Reason	Activity Log Label	Usage Scenario
Correction	Inventory correction	General errors or default option.
Count	Inventory manually counted	After physical stocktakes reveal discrepancies.
Damaged	Damaged	For marking inventory as "Unavailable" due to damage.
Quality control	Quality control	Holds inventory for inspection before it’s available.
Theft or loss	Theft or loss	Records shrinkage from theft or misplacement.
Promotion or donation	Promotion or donation	For items given away for marketing or charitable use.

Accurate adjustments are the foundation for smoother audits and better reconciliation.

Document Changes for Accountability

Every inventory adjustment in Shopify is logged with the user, date, SKU, and quantity, ensuring full traceability. This documentation is critical for tracking why and when inventory levels changed. It also helps identify patterns, such as recurring shrinkage, supplier fraud, or administrative errors.

"Clean inventory numbers help us not only replenish our existing stock as needed but allow us to make more accurate predictions on how and when to replenish our inventory."
– Adam Besheer, Co-founder, Greenery Unlimited

When performing manual adjustments, add detailed notes for context. For example, instead of simply marking an item as "Damaged", specify whether it was damaged during transit, storage, or a customer return. These details are invaluable for spotting trends or demonstrating compliance during financial reviews. Apply adjustments at the SKU or variant level to avoid errors that could lead to overstocking one variant while underselling another.

If you’re using Shopify alongside external systems like ERPs or third-party logistics providers, clearly define which system serves as the authoritative source. This helps prevent synchronization conflicts and double entries. Consistent documentation connects today’s corrections with tomorrow’s risk management. Aim to keep your shrinkage rate below 1%. By maintaining thorough adjustment records, you’ll be able to identify when you're exceeding this benchmark and take action before it affects your profitability.

Step 4: Create a Regular Reconciliation Schedule

Staying on top of inventory reconciliation can keep minor issues from turning into major headaches. How often you should reconcile depends on your business size, how quickly products move, and the revenue each item generates.

Decide How Often to Reconcile

Once your main system is in place and discrepancies are resolved, the next step is setting a reconciliation schedule. The ABC method is a great way to prioritize:

A-grade items (top 80% of revenue): Reconcile monthly.
B-grade items: Reconcile every four months.
C-grade items: Reconcile every six months.

For high-volume stores, daily or weekly cycle counts are more effective than waiting for an annual inventory shutdown. Cycle counting involves auditing smaller portions of your inventory regularly instead of tackling everything at once. John Frigo, Ecommerce Manager at Best Price Nutrition, shares their process:

"We do a physical inventory four times a year and do spot inventory checks on select brands and products included in stacks about once a month".

Smaller businesses, like boutiques with fewer SKUs (around 120), might opt for monthly full counts. Larger retailers, however, should focus on weekly cycle counts for fast-moving products.

Seasonal businesses should time reconciliations ahead of peak demand. For instance, a winter boot retailer should count inventory in August to ensure accurate forecasting for the busy season. And don’t skip the year-end physical count - it’s a must for tax compliance.

Use the 3-Way Reconciliation Method

The 3-way reconciliation method is a thorough process that cross-checks three key data sources:

Your physical warehouse count.
Shopify digital records.
Supplier purchase orders.

This approach helps pinpoint whether discrepancies are due to sales errors, shipping issues, or even theft .

Here’s how it works:

Start by pulling Shopify data, including sales orders, returns, and adjustments.
Conduct a physical inventory count using barcode scanners.
Compare your findings against supplier invoices and receiving records.

For example, if your physical inventory shows 50 units, but the supplier’s PO indicates 60 were shipped, you’ve identified a short-shipment. Or, if Shopify records show 45 units sold but only 40 remain, you’ve uncovered shrinkage .

Once you spot a mismatch, dig deeper. Is it an administrative error? Supplier fraud? Physical shrinkage? After identifying the cause, update Shopify to reflect reality and document the issue. This method catches problems that might slip through a simple physical-versus-digital comparison.

Automate Reconciliation Tasks

Automation can save you a ton of time. Syncing Shopify data with your warehouse system ensures inventory levels automatically update in real time when an order is picked - no manual data entry required.

Platforms like Forstock take it a step further with AI-powered tools. They analyze sales trends, lead times, and seasonality to predict demand up to 12 months in advance. When stock hits the reorder point, the system triggers a reconciliation check before generating a purchase order. This prevents over-ordering when inventory records don’t align .

Forstock’s centralized dashboard also provides real-time visibility across multiple locations, allowing you to catch discrepancies as they happen, rather than weeks later during manual counts.

"Having a system that does inventory for you allows you to focus on the more creative parts of running a business".

Next up: how Shopify reports can further streamline your reconciliation process.

Step 5: Use Shopify Reports for Reconciliation

Once you've established a regular reconciliation schedule, Shopify's reporting tools can help you stay on top of inventory management. These reports provide essential data to identify discrepancies, monitor changes, and make informed decisions. With these tools, you can maintain inventory accuracy without relying on time-consuming manual checks.

Key Reports for Inventory Accuracy

One of the most useful tools is the Inventory Adjustment Changes Report, which tracks every inventory update - whether it's from manual changes, app integrations, or stock transfers. If a physical count reveals discrepancies, this report shows you when the change occurred, who made it, and why it happened.

The Month-end Inventory Snapshot offers a historical view of stock levels at the end of each month. A negative "Ending quantity" in this report could indicate overselling or disabled inventory tracking.

The Inventory Adjustments by Count report helps you identify trends. By filtering data by staff member, location, or adjustment reason (like "Theft or loss" or "Damaged"), you can pinpoint whether certain individuals or warehouses require attention. This insight can reveal training gaps, process inefficiencies, or more serious concerns.

For prioritizing efforts, the ABC Product Analysis is invaluable. It categorizes inventory into three groups based on revenue contribution: A-grade (80%), B-grade (15%), and C-grade (5%). Since A-grade products drive the majority of revenue, focusing your reconciliation efforts on these items has the greatest financial impact.

Another helpful tool is the Days of Inventory Remaining report, which predicts how long your stock will last based on sales trends over the past 28 days. For instance, if a product shows 10 days of stock remaining but the supplier's lead time is 7 days, it's time to reorder to avoid running out.

Use Reports to Make Better Decisions

These reports don't just highlight issues - they also guide proactive inventory management. For example, you can combine the Days of Inventory Remaining data with supplier lead times to set reorder points. Alerts can notify you when stock levels dip below these thresholds, helping you avoid last-minute scramble orders.

The Product Sell-through Rate report is another powerful tool, showing the percentage of inventory that's actually selling. Slow-moving C-grade stock, for example, can tie up capital unnecessarily. If an item has a 12% sell-through rate compared to your store's average of 45%, it might be time to discount it and free up cash flow. Keep in mind, though, that this report usually has a two- to three-day processing delay.

For businesses with multiple locations, exporting reports for each site separately and then merging them can give you a complete company-wide picture. Shopify reports typically provide location-specific data, so consolidating them prevents errors like double-counting. Note that historical data for inventory metrics only goes back to October 1, 2023, so older records will require your own archived exports.

If you're using Forstock, its dashboard integrates seamlessly with Shopify reports. It triggers real-time reconciliation checks whenever it detects discrepancies between expected and actual inventory levels. This prevents costly mistakes, like over-ordering based on inaccurate data, and keeps your inventory management system running smoothly.

Conclusion

Inventory reconciliation is essential for protecting your profits. In 2021, retail shrinkage cost the industry a staggering $94.5 billion, and retailers, on average, only achieve 70% accuracy in inventory visibility. The five-step process detailed here offers a straightforward way to keep your inventory records precise. This approach not only minimizes expensive mistakes but also boosts profitability.

Regular audits to correct inventory discrepancies can increase sales by about 11%. Accurate tracking also supports better forecasting and smarter replenishment decisions, helping you maintain the right stock levels without overcommitting your capital.

By combining Forstock's AI-powered forecasting tools with Shopify's reporting features, you can turn routine inventory checks into actionable business insights. Shopify's built-in inventory reports provide a clear view of stock levels and adjustments, cutting down on the need for manual spreadsheets. Pair this with Forstock's manual vs. automated purchase order creation and real-time analytics, and inventory reconciliation becomes a strategic tool. This combination helps you catch errors early, avoid costly problems, and free up time to focus on growing your business.

Focus on your most important products by using cycle counts and the three-way reconciliation method to compare Shopify data with physical counts and purchase orders. The aim isn’t flawless accuracy but rather consistent precision that leads to smarter purchasing decisions, prevents stockouts, and keeps your cash flow healthy.

FAQs

Which system should be my inventory source of truth?

Your inventory system should be the go-to resource for all stock-related information. It provides a centralized hub for monitoring stock levels, recording adjustments, and tracking sales. By routinely comparing this system data with your actual physical inventory, you can ensure accuracy and keep your stock management on point.

What’s the fastest way to find why Shopify inventory changed?

To figure out why your Shopify inventory has changed, the best tool is the adjustment history reports. These reports give you a clear breakdown of inventory changes, showing the reasons behind them, timestamps, and specific adjustment details. You can find these reports in your admin by navigating to Analytics > Reports. If you're looking for details on a particular product or variant, you can also review its individual inventory adjustment history to track fluctuations more precisely.

Which Shopify report should I use for my physical count?

To keep your stock levels accurate and current, you can use Shopify's Inventory reports or design custom inventory adjustment reports. These tools make it easier to track and reconcile your physical inventory counts effectively.