Poor inventory management for ecommerce is one of the fastest ways to drain cash from a business. You might be generating strong revenue on Amazon or Shopify, yet find yourself short on operating cash because too much money is locked inside unsold units sitting in a warehouse. That gap between revenue and real profitability is almost always tied to how you manage stock.
Most Amazon sellers and Shopify store owners do not realize that inventory problems are also tax and cash flow problems. When COGS (cost of goods sold, meaning what you paid for the products you actually sold) is calculated incorrectly, your taxable income is wrong. That means your tax bill is wrong, too. AMZ Accountant works specifically with eCommerce sellers to fix the connection between inventory accuracy and financial health.
Keep reading to learn how to track the right metrics, forecast demand more accurately, build a recordkeeping system that works across channels, and avoid the mistakes that kill margin.
Why Stock Control Drives Profit
Every dollar tied up in slow-moving inventory is a dollar you cannot use to reorder bestsellers, run ads, or cover operating costs. Stock control is not just a warehouse function; it directly shapes your profit margin and your cash position at the end of every month.
How Excess Units Tie Up Cash
Overstocking is a silent cash drain. When you buy more units than you can sell in a reasonable time frame, that capital is frozen. It cannot pay your supplier for the next purchase order, nor fund a marketing push for a new product.
Amazon FBA sellers face an additional layer of cost here. Amazon charges monthly storage fees that increase significantly in Q4. Units sitting unsold in October, November, and December cost far more per cubic foot than in January. That fee structure punishes overbuying in a way that does not show up clearly until you reconcile your Seller Central reports.
The fix starts with knowing your average unit velocity (how fast a SKU sells per day or week) and buying to that number, not to a round-case minimum or a supplier’s suggested quantity.
Why Stockouts Hurt Ranking and Revenue
Running out of stock is just as costly as overstocking, especially on Amazon. When your listing goes out of stock, your organic ranking drops. Amazon’s algorithm treats stock availability as a signal of seller reliability, and recovering lost ranking can take weeks.
On Shopify, a stockout means a missed sale and often a lost customer who does not return. For DTC brands scaling from six to seven figures, that lost repeat-purchase revenue compounds quickly.
Maintaining a safety stock buffer (extra units held in reserve for unexpected demand spikes) protects against both scenarios. A lean buffer based on your supplier lead time and daily sales rate is far more effective than guessing.
Where Margin Gets Lost in Storage and Returns
Margin erosion happens quietly across three areas: long-term storage fees, return processing costs, and aged inventory write-downs. None of these show up prominently on a basic income statement unless your bookkeeping is built to capture them.
Returns on Amazon, for example, come back in various conditions. Some units are resellable. Others are damaged and must be written off. If you do not track the status of returned units at the SKU level, your COGS is understated, and your true margin is overstated. That means you think you are more profitable than you actually are.
Understanding where margin bleeds out of your operation sets the stage for knowing which metrics to track, and that is exactly where the next section starts.
Core Metrics Every Seller Should Track
Tracking the right numbers turns stock management from a guessing game into a repeatable system. These four metric categories are the foundation of sound inventory management for eCommerce businesses at any scale.
Sell-Through Rate and Inventory Turnover
Sell-through rate tells you what percentage of your starting inventory you sold during a given period. Inventory turnover tells you how many times you cycled through your entire stock in a year. Both metrics reveal whether you are buying the right quantities.
A sell-through rate below 50 percent over a 60-day window is a warning sign. It means you are holding more stock than your demand supports. An inventory turnover ratio below 4 for most physical product categories suggests slow-moving stock is accumulating.
| Metric | Formula | Healthy Benchmark |
| Sell-Through Rate | Units Sold / Beginning Units x 100 | 60% or higher per 60 days |
| Inventory Turnover | COGS / Average Inventory Value | 4 to 8 per year (category-dependent) |
| Days on Hand | 365 / Inventory Turnover | 45 to 90 days for most eCommerce |
| Reorder Point | (Daily Sales x Lead Time) + Safety Stock | Varies by SKU and supplier |
Days on Hand and Reorder Point
Days on hand (DOH) tells you how long your current stock will last at your current sales pace. A DOH of 30 means you have 30 days of supply left. Knowing this number prevents both stockouts and emergency reorders at premium freight costs.
Your reorder point is the inventory level that triggers a new purchase order. Calculate it by multiplying your daily sales rate by your supplier’s lead time, then adding a safety stock buffer. For a product that sells 10 units per day with a 20-day lead time, your reorder point is at least 200 units, plus any buffer you need.
Carrying Costs and Landed Cost
Carrying cost is the total cost of holding inventory: storage fees, insurance, financing costs, and the opportunity cost of capital tied up in unsold goods. For Amazon FBA sellers, Amazon’s storage fees are a direct carrying cost that hits your P&L every month.
Landed cost is the true cost of getting a unit to your warehouse, including product cost, freight, import duties, inspection fees, and prep costs. If you only track the invoice price from your supplier, your COGS is understated, and your margins look better than they are. Always build landed cost into your per-unit cost in QuickBooks Online so your profit reports reflect reality.
Shrinkage, Returns, and Aged Stock
Shrinkage (inventory that is lost, damaged, or unaccounted for) erodes your reported stock levels and overstates your profitability. Returns add complexity because a returned unit may have a different value than a new unit.
Aged stock, typically units that have sat unsold for 180 days or more, often needs to be written down or liquidated. From a tax planning standpoint, writing down aged or worthless inventory in the correct period reduces your taxable income for that year.
That is a real tax savings opportunity that most sellers miss because they are not tracking aged stock at all. Once you know which metrics matter, the next challenge is using real data to predict what you will need before you run out.
Forecast Demand With Better Inputs
Accurate demand forecasting keeps your stock levels lean and your cash flow healthy. The goal is to order what you need when you need it, based on data rather than instinct.
Using Seasonality, Promotions, and Lead Times
Historical sales data is your most reliable forecasting input. Pull your unit velocity by SKU for the last 12 months and look for seasonal patterns. A product that doubles in sales in November needs a different replenishment plan than one with flat year-round demand.
Layer in planned promotions. If you are running a Prime Day deal or a Shopify flash sale, demand will spike during that window. Build that into your purchase order timeline so you have enough stock on hand before the event, not after.
Lead times from overseas suppliers can range from 30 to 90 days depending on the manufacturer and shipping method. Factor in buffer time for customs delays, especially for air-to-sea transitions. Missing a promotional window because your shipment is held at port is a costly and avoidable mistake.
Adjusting for Marketplace Fees and Channel Mix
If you sell on Amazon, Shopify, Walmart, and eBay simultaneously, your true sales velocity is spread across channels. A tool like A2X pulls transaction-level data from each platform into QuickBooks Online, giving you a consolidated view of units sold per channel per period.
That consolidated view matters for forecasting because channel mix shifts. A Shopify sale has different fees than an Amazon FBA sale. If you are allocating more marketing budget to Shopify, your Amazon velocity may slow. Use channel-level data to forecast by platform, not just by SKU total.
Planning Around Supplier Delays and Cash Constraints
Supplier delays are a real constraint, especially when manufacturing is concentrated in one region. Build a delay scenario into your safety stock calculation. If your supplier has a history of shipping 10 days late, your safety stock should account for that gap.
Cash constraints affect how much you can order at once. If your available cash covers only two-thirds of your ideal purchase order, prioritize your highest-turnover SKUs first. Understanding your cash position before you place an order requires clean, up-to-date financial statements, not a bank balance estimate.
With your forecasting inputs clear, the next step is to ensure your recordkeeping system captures all this data accurately across every channel.
Build an Accurate Recordkeeping System
Your inventory data is only useful if it is accurate, timely, and connected to your accounting system. A patchwork of spreadsheets and platform-native reports will fail at scale.
Sync Sales Channels, Warehouse Data, and COGS
A2X automates pulling settlement data from Amazon and Shopify directly into QuickBooks Online. Each payout is broken down into revenue, fees, refunds, and adjustments, which means your COGS entries reflect actual transactions rather than deposited net amounts.
If you use a third-party logistics provider (3PL), make sure its warehouse management system exports inventory movements you can reconcile with your sales channel data. Gaps between units shipped and units sold are a red flag for both shrinkage and billing errors.
Set Up SKU-Level Reporting for Clear Decisions
Aggregate reporting hides problems. A blended gross margin of 40 percent across 50 SKUs might look healthy until you break it down and find that 10 SKUs are running at 15 percent margin while subsidizing the rest.
Set up SKU-level reporting in QuickBooks Online using classes or items to segment your products. This lets you see which products are actually profitable after Amazon fees, shipping, and returns, and which ones are dragging down your overall margin.
| Reporting Level | What You Can See | What You Miss |
| Aggregate (total sales) | Total revenue, blended margin | Poor-performing SKUs, fee spikes |
| Channel-level | Per-platform revenue and fees | SKU mix within each channel |
| SKU-level | True margin per product | Nothing, this is the target view |
Use Cycle Counts to Catch Errors Early
A cycle count is a rolling physical count of a portion of your inventory on a regular schedule, rather than one big annual count. Counting 10 to 20 percent of your SKUs each week means you catch discrepancies fast, before they compound into large accounting adjustments at year-end.
For Amazon FBA sellers, reconcile your Seller Central inventory report against your own records monthly. Amazon does lose and damage units, and you are entitled to reimbursements for those losses. Tracking this systematically can recover meaningful amounts that sellers routinely leave unclaimed.
Clean, SKU-level records also feed directly into the tax planning conversations that determine how much you owe at year-end, but only if your books are structured to capture them correctly.
Common Mistakes That Create Costly Inventory Problems
These three mistakes show up repeatedly among Amazon FBA sellers and Shopify owners, and each has a direct financial consequence that goes beyond the wrong stock levels.
Reordering From Revenue Instead of Forecasts
Many sellers trigger a new purchase order when their bank account looks healthy, not when their inventory data says it is time to reorder. These two signals are rarely aligned. Strong revenue in one month may reflect seasonal demand that is about to drop.
Buying based on revenue rather than a reorder point derived from actual sales velocity leads to either overstocking during slow periods or stockouts when demand is steady. Both outcomes damage cash flow. Build your purchase order triggers based on your DOH and reorder point calculations, not on your bank balance.
Ignoring Dead Stock Until Fees Pile Up
Dead stock (units that have not sold in 90 or more days) generates fees and ties up capital that could be redeployed. Many sellers avoid dealing with it because the write-down or liquidation feels like a loss. But the cost of inaction is higher.
On Amazon, units stored longer than 365 days incur long-term storage fees charged monthly. Running a removal order or a liquidation deal removes those fees and frees warehouse space. From a tax standpoint, a documented write-off of worthless inventory reduces your taxable income in the year you take the deduction.
Separating Inventory Decisions From Tax and Cash Planning
Inventory is not just an operations issue. It sits on your balance sheet as a current asset, affects your COGS on your income statement, and influences your taxable income every year. Treating inventory planning as separate from your financial and tax planning means you make purchase decisions without fully understanding their impact.
For example, a large inventory buy in December lowers your year-end taxable income because it increases COGS when those units are eventually sold. But the timing of that deduction depends on your accounting method (cash vs. accrual) and whether the units are sold in the same tax year.
These nuances require a CPA who understands eCommerce, not a generalist. Understanding these mistakes points directly to the decisions that turn better inventory habits into better financial outcomes.
Turn Better Inventory Decisions Into Stronger Financials
Good inventory habits eventually show up on your financial statements, but only if you know when to act and what data to use.
When to Tighten Purchase Orders
Tighten your purchase orders when your sell-through rate is declining, your DOH is rising above 90 days, or your carrying costs are eating into your net margin. These are signals that demand has softened relative to your supply.
Reducing order size during slow periods preserves cash for fixed operating costs like payroll (processed through Gusto for most eCommerce teams), advertising, and software subscriptions. Protecting cash during slow periods is what lets you buy aggressively when demand picks back up.
How Cleaner Data Supports Tax Planning
When your COGS is accurately tracked at the SKU level, and your inventory records reconcile cleanly each month, your tax return reflects reality. That means you are not overpaying taxes because your COGS was understated. It also means you are not underpaying and triggering an IRS audit because your records cannot support your deductions.
Proactive tax planning for eCommerce sellers depends on having clean financials to work from. If your inventory records are a mess, your CPA cannot identify legitimate deductions, time your write-offs strategically, or model the tax impact of a large Q4 inventory buy. Accurate books are the foundation of every dollar saved in taxes.
Next Steps for Amazon Sellers and Shopify Owners
If you are an Amazon FBA seller, start with a monthly reconciliation of your Seller Central inventory report against your QuickBooks Online records using A2X. Identify any unaccounted-for units and file reimbursement claims before Amazon’s claim window closes.
If you run a Shopify store, set up SKU-level reporting with your actual landed costs loaded into each product record. Run a sell-through report every 30 days and flag any SKU below 50 percent for a buying review. These two habits alone will make your financials more accurate and your purchasing more disciplined.
Frequently Asked Questions
What’s the Cleanest Way to Reconcile Units-on-Hand to COGS Each Month?
Use A2X to pull a full settlement breakdown from Amazon or Shopify into QuickBooks Online each month. Match units sold in the settlement report to your beginning inventory minus ending inventory, and confirm the result matches your COGS entry. Any gap needs a journal entry to account for returns, damaged goods, or shrinkage.
How Do I Set Reorder Points That Prevent Stockouts Without Tying Up Cash in Dead Inventory?
Multiply your average daily unit sales by your supplier’s lead time in days, then add a safety stock buffer equal to roughly 20 to 30 percent of that number. Review and adjust your reorder points every 60 days as your sales velocity changes by season or channel.
Which Inventory Tools Handle Multi-Channel Listings Without Creating Duplicate SKUs and Phantom Stock?
A2X handles financial reconciliation across Amazon and Shopify without duplicating SKUs in QuickBooks Online. For warehouse-level stock tracking across a 3PL and multiple sales channels, a dedicated inventory management platform that pushes quantity updates to each channel simultaneously is the right layer to add.
How Should I Track Landed Cost So Margins Don’t Lie on My Shopify P&L?
Build a landed cost per unit by adding your product invoice cost, inbound freight, import duties, and any prep or inspection fees, then divide by total units received. Enter this as your unit cost in QuickBooks Online so every COGS entry reflects what you actually paid to get that unit into your warehouse.
What’s the Best Workflow for Cycle Counts So Shrinkage Shows Up Fast?
Divide your SKUs into weekly count groups and rotate through all of them over a four-week cycle. After each count, compare physical units to your system records in QuickBooks Online and create an adjustment entry for any variance. For FBA inventory, run a monthly reconciliation against your Seller Central inventory report.
How Do I Keep Inventory and QuickBooks in Sync When Returns, Bundles, and Kitting Change Quantities Daily?
Set up a clear item hierarchy in QuickBooks Online to distinguish between component and bundle SKUs. Use A2X to import returns as separate line items, not as negative revenue. For bundles, configure your inventory system to decrement component quantities when a bundle sells so your on-hand counts stay accurate without manual adjustments.
Inventory Accuracy Is How You Actually Get Paid
Your eCommerce business generates real profit only when the numbers behind it are accurate. Stock control, COGS tracking, and demand forecasting are not just operational tasks. They directly determine your cash position, your margin, and your tax liability every single year.
Every dollar you lose to long-term storage fees, write-offs from ignored dead stock, or miscalculated COGS is a dollar that should have stayed in your business or reduced your tax bill. The sellers who scale past seven figures are the ones who treat inventory as a financial discipline, not just a logistics function.
If you are ready to connect your inventory data to a real tax and cash flow strategy, a free strategy call with AMZ Accountant shows you exactly where your books are creating exposure and where you could be saving money this year.