Skip to main content
AboutResources888.999.0280Schedule a Call
Home/Resources/Article
E-CommerceE-Commerce

Inventory Cash Flow Planning: Stop Letting Dead Stock Kill Your Business

Every dollar sitting in unsold inventory is a dollar you cannot spend on advertising, product development, or growth. For e-commerce brands, inventory is the largest cash trap in the business.

By Lorenzo Nourafchan | December 20, 2025 | 9 min read

Key Takeaways

Every dollar locked in unsold inventory is unavailable for growth, advertising, or product development, even when the P&L shows strong margins

Track inventory turnover by product category and target 4 to 12 turns per year depending on your business model

Use the Economic Order Quantity formula to balance ordering costs against holding costs and avoid over-purchasing

Set reorder points based on actual lead times and sales velocity, not guesswork, to prevent both stockouts and excess inventory

Run a monthly dead stock audit and liquidate any SKU with over 180 days of projected inventory within 30 days of identification

The Inventory Cash Trap

In e-commerce, inventory is typically the largest use of cash in the business. A brand doing $2 million in annual revenue with 60 days of inventory on hand is carrying roughly $330,000 in stock at any given time. That $330,000 is cash that has been converted into physical products sitting in a warehouse, waiting to be sold.

The P&L does not reflect this cash commitment until the inventory sells. Under standard accounting (and IRS rules), inventory is an asset on the balance sheet, not an expense. When a unit sells, its cost moves from the balance sheet to the income statement as cost of goods sold. Until then, it sits quietly on the balance sheet, consuming cash that the income statement never acknowledges.

This is why e-commerce brands can show strong profit margins while running dangerously low on cash. The profit is real, but it is locked up in inventory. The disconnect between profitability and liquidity is the core challenge of inventory-based businesses.

Understanding Inventory Turns

Inventory turnover measures how many times per year you sell through your average inventory balance. The formula is: Annual COGS / Average Inventory Value.

If your annual COGS is $800,000 and your average inventory value is $200,000, your inventory turns 4 times per year. That means each dollar of inventory sits in the warehouse for an average of 91 days (365 / 4) before it sells.

Higher turns are better. A brand that turns inventory 8 times per year has 45 days of stock on hand and is using cash far more efficiently than a brand turning 3 times per year with 122 days on hand.

The target varies by product category and business model. Fast-moving consumer goods brands should target 6 to 12 turns. Fashion and apparel brands typically achieve 4 to 6 turns. Durable goods and specialty products may only turn 2 to 4 times.

Low turns are not always bad if they are intentional (e.g., you are building inventory for a major product launch or seasonal peak). But unintentionally low turns signal overpurchasing, poor demand forecasting, or dead stock accumulation.

Economic Order Quantity: How Much to Buy

The economic order quantity (EOQ) formula helps you determine the optimal order size that minimizes total inventory costs. It balances two competing costs:

Ordering costs: Every purchase order incurs fixed costs regardless of size. These include inbound shipping (which has a base fee plus a per-unit component), customs brokerage (for imports), receiving and put-away labor, and the administrative time to place and manage the order.

Holding costs: Every unit in your warehouse incurs ongoing costs. These include storage fees (3PL charges or your own warehouse rent), insurance, capital cost (the return you could earn on the cash tied up in inventory), and obsolescence risk (the probability the product will not sell).

The classic EOQ formula is: EOQ = square root of (2 x Annual demand x Ordering cost per order / Annual holding cost per unit). For most e-commerce brands, a simplified approach works: calculate the total cost of placing orders at different quantities (2 months of supply, 3 months, 4 months, 6 months) and compare the total annual cost of each scenario. The quantity that minimizes the total of ordering plus holding costs is your approximate EOQ.

In practice, EOQ is a starting point that must be adjusted for supplier MOQs (minimum order quantities), supplier lead times, seasonal demand patterns, and available cash.

Reorder Point Calculation

Your reorder point (ROP) is the inventory level at which you must place a new order to avoid stockouts. The formula is:

ROP = (Average daily sales x Supplier lead time in days) + Safety stock

Average daily sales is calculated from your trailing 30 to 90 days of sales data, depending on how much your demand fluctuates.

Supplier lead time is the total time from placing the order to receiving the inventory in your warehouse, including production time, shipping time, customs clearance (for imports), and receiving/put-away time.

Safety stock is a buffer to protect against demand spikes and lead time variability. A common approach is to set safety stock at 1 to 2 weeks of average sales, increasing the buffer for products with highly variable demand or long lead times.

Example: A SKU sells 20 units per day. Supplier lead time is 45 days (30 days production plus 15 days ocean freight and receiving). Safety stock is 14 days of sales (280 units). ROP = (20 x 45) + 280 = 1,180 units. When inventory drops to 1,180 units, it is time to place the next order.

If your lead time is 45 days and your EOQ suggests ordering 90 days of supply (1,800 units), you will place an order when inventory hits 1,180 units and receive the new stock approximately when your remaining inventory drops to the safety stock level of 280 units.

Identifying Dead Stock

Dead stock is inventory that has stopped selling or is selling so slowly that it will take over 180 days to clear at the current sales velocity. Dead stock is not just sitting in your warehouse; it is actively costing you money through storage fees, insurance, and the opportunity cost of the cash tied up in it.

The Monthly Dead Stock Audit

Every month, pull a report showing each SKU's current inventory quantity, trailing 90-day sales velocity, and projected days of inventory remaining (current quantity / average daily sales).

Flag any SKU with over 180 days of projected inventory as dead stock. Flag any SKU with 120 to 180 days as at-risk inventory.

Why Dead Stock Persists

Brands hold onto dead stock for emotional and cognitive reasons, not financial ones. The product was expensive to develop. The founder 'believes in it.' The marketing team is 'planning a push.' Meanwhile, the inventory is racking up storage fees and the cash that funded it is unavailable for products that actually sell.

The financial reality is straightforward. The cost of a product was incurred when you purchased it. That cash is gone regardless of whether you sell the product at full price, discount it, or throw it away. The only question now is: what is the best use of the warehouse space and the cash you could recover by liquidating?

Liquidation Strategies

When dead stock is identified, act within 30 days. The longer you wait, the less the inventory is worth and the more storage costs you accumulate.

Tiered Markdown Strategy

Start with a moderate discount (20% to 30% off) through your existing channels. Run the discount for two to three weeks. If the inventory does not move, increase the discount to 40% to 50%. If it still does not move at that level, escalate to a liquidation channel.

Liquidation Channels

Flash sale sites (Rue La La, Gilt, Zulily) move branded inventory at 50% to 70% off retail. They work best for fashion, home, and beauty products with recognizable brand names.

Wholesale liquidators buy dead stock in bulk at 10 to 20 cents on the dollar. The recovery is minimal, but it is immediate cash and it frees warehouse space.

Amazon Outlet and Warehouse Deals allow FBA sellers to offer discounts on slow-moving inventory through Amazon's own liquidation channels.

Donation generates a tax deduction at fair market value (subject to limitations). For products approaching expiration or with minimal resale value, donation may produce a better financial outcome than liquidation.

Destruction. In rare cases, the cost of liquidating dead stock exceeds the recovery. If the product cannot be sold, donated, or given away at a reasonable cost, disposal is the right answer. Write off the inventory, take the tax deduction, and move on.

Cash Flow Modeling for Inventory Cycles

The 13-Week Inventory Cash Flow Model

A rolling 13-week cash flow model is the essential tool for managing inventory-driven cash flow. For each of the next 13 weeks, project the following:

Cash inflows: Expected sales revenue (based on sales forecasts, marketing plans, and seasonal patterns), accounts receivable collections (for wholesale channels), and any other cash inflows.

Cash outflows: Supplier payments due (based on purchase orders already placed and payment terms), freight and logistics costs, warehousing fees, and all other operating expenses.

The cash position: Opening cash balance plus net cash flow for each week equals the closing balance. Any week where the projected closing balance drops below your minimum cash threshold (typically 2 to 4 weeks of operating expenses) is a warning sign.

Scenario Planning

Run the model under three scenarios: base case (sales at current velocity), upside (sales increase 20%, requiring faster reorders), and downside (sales decrease 20%, extending your inventory days on hand and delaying cash recovery).

The downside scenario is the most important. It answers the question: if sales slow down, how long can you sustain operations before you run out of cash? If the answer is less than 8 weeks, you have an inventory risk problem that needs immediate attention, either by reducing upcoming purchase orders, accelerating liquidation of slow-moving stock, or securing a line of credit.

Seasonal Inventory Planning

E-commerce brands with seasonal peaks face a unique cash flow challenge. The inventory for a Q4 holiday season must be ordered in June or July (for imported goods with 90-day lead times), paid for in August or September, and stored until November and December when sales peak.

This means your cash outflows are heaviest 3 to 6 months before your cash inflows peak. The seasonal gap can be enormous. A brand that does 40% of its annual revenue in Q4 might need to deploy $300,000 in inventory cash between July and September while collecting only $100,000 in revenue during those months.

Planning for this gap requires either sufficient retained earnings to self-fund the inventory build, a line of credit or inventory financing facility, or creative supplier terms (extended payment schedules that align with your selling season).

The worst possible outcome is ordering seasonal inventory you cannot sell. Dead stock from a holiday season is worth a fraction of its cost by January, and you have been carrying the cash outlay for six months. Conservative seasonal ordering, combined with the ability to reorder quickly if demand exceeds expectations, is almost always preferable to aggressive seasonal builds based on optimistic forecasts.

Build your seasonal inventory plan no later than six months before the peak selling period. Model the cash flow impact week by week, stress-test the forecast under downside scenarios, and secure financing before you need it. The brands that plan early have options. The brands that plan late have crises.

LN

Lorenzo Nourafchan

Founder & CEO, Northstar Financial

Lorenzo Nourafchanis the Founder & CEO of Northstar Financial Advisory.

Want to talk about this?

If this article raised questions about your own business, we are happy to walk through the specifics with you. No pitch, no obligation.

Schedule a Free Strategy Call

Or call us directly: 888.999.0280