COD Is Growing Your D2C Sales. But Is RTO Quietly Killing Your Profit? Posted on September 22, 2026 by ca Cash on Delivery can be great for conversion. A customer discovers your brand on Instagram, likes the product, reaches checkout and hesitates before paying online. Then they see: Cash on Delivery Available. The order gets placed. Your Shopify dashboard records another ₹1,500 order. Your marketing dashboard attributes the conversion. Revenue appears to be growing. But three days later, the customer does not answer the delivery call. The courier tries again. The shipment fails. The product comes back to your warehouse. You collected ₹0. But you may already have paid for the ad, packaging, forward shipping, reverse logistics and order processing. Your inventory has also spent days outside the warehouse before becoming available for sale again. This is the real ecommerce RTO cost India D2C founders need to understand. RTO—Return to Origin—is not simply a logistics metric. It is a profitability metric. And if your finance team is not tracking COD return cost, ecommerce unit economics and RTO accounting properly, your sales dashboard may be making the business look healthier than it actually is. For D2C founders and finance heads, the right question is no longer: “How many COD orders did we generate?” It is: “How much contribution did those COD orders actually leave after delivery failures?” Visual suggestion: Opening illustration showing a ₹1,500 COD order travelling from “Ad → Checkout → Warehouse → Courier → Failed Delivery → Warehouse,” while costs keep adding at every stage and revenue ultimately becomes ₹0. Attention: A ₹1,500 COD Order Is Not ₹1,500 of Useful Revenue Imagine your brand receives a ₹1,500 COD order. The marketing dashboard records: Revenue: ₹1,500 But an order placed is not the same thing as cash collected. Until delivery succeeds, that ₹1,500 is still conditional. If the order becomes RTO: No customer payment is collected Ad spend has already been incurred Packaging may already be consumed Forward freight has already been paid Reverse freight may now be charged Warehouse teams need to receive and inspect the product again Inventory remains unavailable during the delivery cycle The product may return damaged or unsellable That is why D2C profitability cannot be measured using gross order value alone. A finance-led D2C business should distinguish between: Orders placed → Orders shipped → Orders delivered → Cash collected → Contribution earned Those are very different numbers. Interest: The RTO Numbers Are Bigger Than Many Founders Expect India’s D2C market continues to grow rapidly. Unicommerce’s FY26 analysis, based on more than 410 million shipments across 6,000+ brands, found that D2C order volumes increased approximately 33% during FY26. Demand is also spreading beyond major metros, with Tier 2 and Tier 3 markets driving a large share of incremental orders. But the RTO numbers deserve just as much attention as the growth numbers. During the festive quarter, Unicommerce reported that 58% of COD orders were returned, compared with under 15% for prepaid orders in its dataset. Even after the festive spike eased, Shipway data cited by Unicommerce showed overall RTO levels falling from around 39% in November 2025 to approximately 21% by early 2026. Shiprocket separately estimates that COD orders commonly experience RTO rates of around 20–30%, while prepaid shipments generally perform considerably better. Think about what that means financially. At a 25% RTO rate: 1 out of every 4 COD shipments may fail to generate revenue after operational costs have already been incurred. At 40%: 2 out of every 5 shipments may come back. That is not just a logistics problem. That can completely change your ecommerce unit economics. The SCQA Framework: Why Growing Sales Can Still Produce Weak Profit Situation Your COD option increases conversions. More people order. Revenue and order volume grow. Complication A meaningful percentage of those orders never complete successfully. Marketing still paid to acquire the customer. The warehouse still packed the order. The courier still attempted delivery. When the order returns, reverse logistics and reprocessing add even more cost. Question How do you know whether COD is genuinely growing your business or simply creating expensive order volume? Answer You need to measure profitability at the delivered-order level, then allocate the financial cost of RTO back across every COD order dispatched. That requires proper Financial Analytics, accurate RTO accounting, reliable Bookkeeping Services India, and management reporting that connects logistics with the P&L. What Exactly Is RTO? RTO stands for Return to Origin. It happens when an order is shipped but cannot be successfully delivered and is returned to the seller. Common causes include: Customer refusing delivery Customer changing their mind Customer unavailable after repeated attempts Incorrect address Incorrect phone number Delivery delays Customer placing duplicate orders Impulse COD purchases Fake orders Unserviceable or difficult locations RTO should not be confused with a normal customer return. RTO The customer never successfully receives the order. Customer Return The order is delivered, but the customer later sends it back. Financially, both matter. But the cost structure and accounting trail can be different. The Real Cost of a ₹1,500 COD Order Consider an illustrative D2C product. Successful COD Order Item Amount Product MRP ₹1,800 Discount -₹300 Customer order value ₹1,500 Product cost -₹550 Allocated ad spend -₹280 Packaging -₹45 Forward shipping -₹90 COD/payment cost -₹40 Contribution ₹495 At first glance, this looks reasonable. You collected ₹1,500 and retained approximately ₹495 before fixed operating costs. Now look at the same order when it becomes RTO. Failed COD Order Cost incurred Approx. amount Revenue collected ₹0 Advertising cost -₹280 Packaging -₹45 Forward shipping -₹90 Reverse/RTO shipping -₹90 Receiving, QC and repacking -₹35 Inventory blockage/finance allocation -₹25 Immediate RTO leakage -₹565 These figures are illustrative—the exact shipping, packaging and acquisition costs will vary by brand, courier, zone and product. But the financial principle is important. The successful order generates around: ₹495 contribution The failed order can consume around: ₹565 And that is before considering damage, expiry, failed packaging, additional warehousing or markdowns. Visual suggestion: Waterfall graphic for the ₹1,500 COD order. One path ends with +₹495 contribution, while the RTO path ends with -₹565 cost. What Happens to the Product Cost When an Order Becomes RTO? This is where RTO accounting needs more precision. If the ₹550 product returns in completely saleable condition, the product itself has not necessarily been permanently lost. It may return to inventory after inspection. But that does not mean the RTO was free. Cash remained locked in that inventory while it was: Packed → Shipped → Attempted → Returned → Inspected → Restocked During that period, the item could not be sold to another customer. If the product comes back damaged, opened, expired, stained or otherwise unsellable, there may also be a write-down or inventory loss. Therefore, finance should separate: Recoverable inventory value Permanent inventory loss Logistics cost Marketing cost Packaging loss Reprocessing cost Working-capital impact The Metric That Matters: RTO-Adjusted Contribution Suppose your delivered COD order generates ₹495 contribution. Your average RTO costs ₹565. Now imagine your COD RTO rate is 25%. For every 100 COD orders: 75 delivered × ₹495 = ₹37,125 contribution But: 25 RTO × ₹565 = ₹14,125 loss Net contribution: ₹23,000 Average contribution per COD order dispatched: ₹230 Without RTO adjustment, management might assume each order is generating ₹495. In reality, the expected contribution from every dispatched COD order is only about ₹230 in this example. That is less than half. A useful formula is: Expected COD Contribution = (Delivery Rate × Delivered Contribution) − (RTO Rate × RTO Cost) This is one of the most useful Financial Analytics metrics for a COD-heavy D2C brand. Now Imagine Festive RTO Levels Using the same illustrative economics: At a 39% RTO rate: 61% × ₹495 = ₹301.95 39% × ₹565 = ₹220.35 Expected contribution: ₹81.60 per dispatched order At a 58% RTO rate: 42% × ₹495 = ₹207.90 58% × ₹565 = ₹327.70 Expected contribution: -₹119.80 per dispatched order Again, these are illustrative economics—not industry profit averages. But they demonstrate why Unicommerce’s reported festive COD return rate of 58% should get the attention of a CFO, not just the logistics team. Your campaign may still show revenue. Your dispatch report may still show volume. But the underlying order cohort can become economically destructive. Why Marketing ROAS Can Hide RTO Losses Suppose Meta attributes: ₹15 lakh of COD order value against: ₹3 lakh of advertising spend. The dashboard may initially show: 5X ROAS That looks excellent. But suppose 30% becomes RTO. A significant portion of attributed order value never becomes realised customer collection. Meanwhile, much of the marketing spend has already been incurred. That means your real business economics may be significantly weaker than the advertising platform suggests. This is why marketing reports should eventually reconcile with: Delivered revenue Cancelled orders RTO Customer returns Refunds Actual cash collections D2C profitability should be measured after the order lifecycle is substantially complete—not at the moment someone clicks “Place Order.” The Costs Founders Commonly Forget Forward Shipping Even failed orders travelled toward the customer. That trip costs money. Reverse Logistics Shiprocket explains that RTO charges cover the return journey after a delivery fails, creating an additional freight cost on top of the original forward shipment. Packaging Boxes, labels, tapes, inserts and protective material may need replacement before the product can be sold again. Advertising Meta and Google do not refund your acquisition cost because the customer rejected the COD parcel. Warehouse Handling Someone packed the order originally. Someone must now receive, inspect and restock it. Inventory Blockage The product may be unavailable for days—or weeks—before returning to saleable inventory. Damage Risk Certain products lose resale value after excessive movement or failed delivery. Discount Economics A discount may help generate the order, but it reduces contribution on successful deliveries. So even when discount itself is not an RTO cash cost after a failed sale, it should still be included when determining whether COD economics are attractive enough to absorb your expected RTO losses. RTO Accounting: What Your Books and MIS Should Capture Most accounting systems are designed around invoices and payments. D2C businesses need another layer: Order lifecycle accounting. Your order statuses should distinguish: Order placed Confirmed Shipped Delivered COD collected RTO initiated RTO received Customer return Refund issued Inventory restocked Inventory damaged For management reporting, undelivered RTO orders should not be confused with realised sales merely because the website initially created an order value. Your Accounting Services India partner should reconcile: OMS / Website → Courier → Payment Gateway/COD Settlement → Accounting → Inventory When these systems do not match, founders start managing the business using GMV rather than economics. Build an RTO P&L Every D2C MIS should have a monthly section dedicated to RTO. Track: Metric What It Tells You Total orders Demand generated COD orders COD exposure Prepaid orders Lower-risk order base COD delivered Real conversion COD RTO Failed delivery RTO % Operational risk Forward freight on RTO Initial logistics loss Reverse freight Return cost Ad spend allocated to RTO Acquisition leakage Packaging loss Operational leakage Damaged RTO stock Inventory loss Total RTO cost Financial impact This converts RTO from: “Our courier performance is bad.” into: “RTO reduced contribution margin by ₹4.2 lakh this month.” That is a management conversation. Analyse RTO by More Than One Percentage A company-wide RTO percentage is useful. But it does not tell you what to fix. Use Financial Analytics to analyse RTO by: Pin code City State Courier SKU Product category Order value First-time vs repeat customer Marketing channel Campaign COD vs prepaid Delivery speed Discount percentage You may discover: Overall RTO: 22% But: Mumbai: 11% Delhi: 16% Tier 3 COD: 34% One fashion SKU: 41% Repeat customers: 7% First-time COD customers: 31% Now the solution becomes much clearer. Action: How to Reduce RTO Without Killing COD Sales COD still matters in India. The answer is not necessarily to switch it off. It is to manage it intelligently. Step 1: Confirm COD Orders Use WhatsApp, SMS, IVR or manual verification for higher-risk COD orders. Step 2: Verify Addresses Before Dispatch Incomplete and inaccurate addresses create avoidable failed delivery attempts. Step 3: Encourage Prepaid Checkout Offer a modest prepaid benefit where economics support it: Small prepaid discount Cashback Free shipping Faster dispatch The objective is not simply to discount more. Compare the incentive with the RTO cost avoided. Step 4: Use Pin-Code-Level Courier Performance Do not automatically send every shipment through the same courier. Route orders based on actual delivery performance by location. Unicommerce’s FY26 analysis associates lower RTO performance with operational measures including prepaid incentives, address verification and pin-code-based courier routing. Step 5: Act Quickly on NDR NDR means Non-Delivery Report. When a delivery fails: Contact the customer quickly Verify the address Reschedule Provide landmarks Confirm availability Saving the second delivery attempt can protect both revenue and contribution. Step 6: Score High-Risk COD Orders Look at: Previous RTO history Customer phone verification Pin-code performance High-risk SKUs Unusually high order value Duplicate orders Not every customer needs the same checkout policy. Step 7: Measure RTO-Adjusted CAC If you spent ₹3 lakh acquiring 1,000 COD orders: Reported CAC: ₹300 But if only 700 are successfully delivered: Effective acquisition cost per delivered COD customer: ₹429 That is the number finance should use when evaluating ecommerce unit economics. Why Bookkeeping Services Matter More Than Founders Think RTO looks operational. But the numbers flow through accounting. Good Bookkeeping Services India for e-commerce should reconcile: Courier invoices RTO freight COD remittances Marketplace settlements Inventory returned Damaged inventory Credit notes Refunds Marketing expenditure Warehouse costs If these remain scattered across logistics portals and spreadsheets, your P&L can understate how expensive failed delivery really is. Your Accounting Services India partner should help translate operational data into financial reporting. What CFO Advisory Services Should Tell a D2C Founder A CFO should not simply say: “RTO is 24%.” That is an operations statistic. Useful CFO Advisory Services should tell you: “Your 24% COD RTO generated ₹6.4 lakh of direct logistics and acquisition leakage this month and reduced contribution margin by 4.1 percentage points.” Then management can decide: Should prepaid incentives increase? Should COD be restricted in certain pin codes? Should certain campaigns stop targeting COD-heavy customers? Should shipping partners change? Which products create the highest RTO losses? Is the current COD growth strategy actually profitable? That is why MIS Reporting Services, e-commerce accounting and CFO advisory should work together. Bonus How-To: Transitioning Your Home to Renewable Energy Although separate from D2C economics, households interested in reducing grid-electricity dependence can begin with rooftop solar. Step 1: Review Electricity Consumption Analyse approximately 12 months of electricity bills. Step 2: Assess the Rooftop Check: Available shadow-free area Structural condition Sun exposure Ownership or society permissions Step 3: Estimate Solar Capacity Match system size to actual electricity consumption rather than choosing only on available roof area. Step 4: Compare Economics Review: Installation cost Expected annual generation Warranty Maintenance Electricity savings Estimated payback Step 5: Check the Official Process The Ministry of New and Renewable Energy directs residential consumers to the PM Surya Ghar rooftop-solar framework and provides DISCOM information and application guidance through the official portal. Step 6: Compare Vendors Evaluate equipment specifications, expected generation, warranties and after-sales support. Step 7: Monitor Actual Savings After commissioning, compare actual solar generation with projected output and electricity-bill savings. Key Takeaways COD can absolutely help an Indian D2C brand grow. But COD order volume is not the same thing as profitable revenue. A ₹1,500 COD order that successfully reaches the customer may generate healthy contribution. The same ₹1,500 order becoming RTO can generate: ₹0 collection + advertising cost + forward freight + reverse freight + packaging cost + handling cost + inventory blockage. That is the real COD return cost. For founders trying to understand how RTO and COD returns affect ecommerce profitability in India, the solution is to move beyond the logistics dashboard. Track: Delivered revenue COD RTO % RTO cost per order Effective CAC per delivered customer Contribution after RTO RTO by SKU RTO by pin code RTO by campaign Inventory returned and damaged Strong RTO accounting, reliable Bookkeeping Services India, actionable Financial Analytics, proper MIS Reporting Services, and experienced CFO Advisory Services turn these numbers into business decisions. Because a growing order count is useful. A growing delivered contribution margin is much better. If you removed every COD order that eventually became RTO from last month’s sales dashboard—and added back every cost those orders created—would your D2C profitability still look the same? Frequently Asked Questions 1. What is RTO in e-commerce? RTO stands for Return to Origin. It occurs when an order is shipped but cannot be successfully delivered and is sent back to the seller. Common reasons include customer refusal, incorrect addresses, unavailability, fake COD orders and repeated failed delivery attempts. 2. How does RTO affect D2C profitability? RTO can create costs without generating customer revenue. The business may still pay advertising, packaging, forward shipping, reverse shipping and warehouse-handling expenses. Inventory also remains blocked while the product is in transit. High RTO can therefore significantly reduce contribution margin even when gross order volume is growing. 3. How should a D2C brand calculate its COD return cost? Calculate the direct expenses associated with failed orders, including allocated ad spend, packaging, forward freight, RTO freight, reprocessing and any inventory damage or financing cost. Brands should then calculate RTO-adjusted contribution across all COD orders rather than evaluating only successfully delivered orders. 4. Why can reported CAC be misleading when RTO is high? Traditional CAC may divide advertising spend by total orders placed. But some of those orders may never be delivered. A more useful metric for COD-heavy businesses is acquisition cost per successfully delivered customer. For example, ₹3 lakh spent to generate 1,000 orders appears to be a ₹300 CAC, but if only 700 are delivered, the effective acquisition cost is approximately ₹429 per delivered order. 5. How can Accounting Services and CFO Advisory Services help reduce RTO losses? Strong Accounting Services India can reconcile orders, COD settlements, courier bills, RTO charges and inventory movements so the financial impact is visible. CFO Advisory Services can then analyse RTO-adjusted margins by product, location, channel and campaign, helping management decide where to promote prepaid payments, change courier routing, restrict risky COD orders or improve unit economics.
Excess Inventory Cash Flow: How Financial Analytics Can Expose Dead Stock and Hidden Costs Posted on August 29, 2026 by ca Your warehouse looks full. Your sales report looks healthy. Your balance sheet shows a significant inventory asset. But your bank account keeps getting tighter. For many D2C brands, e-commerce founders, manufacturers and traditional businesses, this is the hidden excess inventory cash flow problem: money that appears to exist on the balance sheet but is actually sitting in products, raw materials or components that are moving too slowly—or not moving at all. Inventory can create a false sense of financial strength. ₹50 lakh of stock may appear as an asset, but if ₹15 lakh of it has not moved for nine months, that portion may not be worth ₹15 lakh commercially. It is occupying warehouse space, consuming working capital and potentially moving closer to discounting, obsolescence or write-off. This is where Excess Inventory Cash Flow, an Operational Audit, CFO Advisory Services and a structured Business Process Audit can change the conversation. Attention: Inventory Is Not Cash Until Someone Buys It Businesses naturally need inventory. A D2C brand needs finished goods available before campaigns go live. A manufacturer requires raw materials and components to maintain production. A distributor cannot fulfil customer orders with an empty warehouse. The problem begins when stock exceeds realistic demand. Consider a business holding ₹80 lakh of inventory. On paper, the balance sheet may look strong. But imagine: ₹30 lakh is expected to sell within 60 days. ₹20 lakh may take three to six months. ₹15 lakh has barely moved for six months. ₹10 lakh belongs to discontinued or weak-selling SKUs. ₹5 lakh is damaged, obsolete or commercially difficult to sell. The accounting system may still display ₹80 lakh of inventory. From a cash-flow perspective, however, those categories are very different. That is why understanding excess inventory cash flow requires looking beyond the inventory total. Interest: Excess Inventory Is a Much Bigger Financial Problem Than It Appears Inventory distortion remains enormous worldwide. IHL Group’s 2026 Inventory Distortion Study estimates that overstocks and out-of-stocks together cost global retail approximately $1.7 trillion annually, equivalent to around 6.2% of global retail sales. Overstocks alone represent approximately 34.4% of that distortion problem. And this is not only a retail problem. McKinsey reported in 2025 that some medical-technology businesses hold as much as three times more inventory than companies in sectors such as consumer packaged goods and electronics. Its analysis suggests that better inventory management can reduce inventory by as much as 30%, releasing cash while reducing potential write-offs. The numbers become even more striking in complex manufacturing environments. McKinsey’s 2025 aerospace and defence analysis found that some manufacturers discovered 60% to 80% of the value of parts on hand was not required to support the following 12 months of production. Those examples come from very different industries, but the financial principle is the same: Inventory can absorb enormous amounts of capital without appearing as an obvious expense on the monthly P&L. That is why businesses need Financial Analytics that connect inventory movement with working capital—not merely an inventory valuation report. The SCQA Framework: Why Profitable Businesses Still Feel Cash-Strapped Situation Sales are growing. The business is profitable on paper. Inventory is available to support customers. Complication As the business grows, purchasing also increases. More SKUs are introduced. Safety stock rises. Teams order larger quantities to negotiate better prices. Forecasts turn out to be optimistic. Slow-moving products accumulate quietly. Soon, cash that could have funded marketing, salaries, new machinery or expansion is sitting on warehouse shelves. Question How do you know whether your inventory is supporting growth or quietly weakening cash flow? Answer You need to analyse inventory by age, movement, margin, demand and cash value, then investigate the processes responsible for excess stock. That requires a combination of Financial Analytics, Operational Audit and Business Process Audit rather than a simple stock count. Desire: What Good Inventory Visibility Should Tell a Founder A useful inventory report should answer questions such as: How much cash is currently tied up in inventory? Which SKUs have not moved for 90, 180 or 365 days? Which products are overstocked relative to demand? Which products repeatedly go out of stock? Which SKUs produce strong revenue but poor margins? Which vendors force unnecessarily high minimum order quantities? How accurate are purchase forecasts? Which inventory will become obsolete within the next six months? What is our inventory turnover by product category? How much working capital could realistically be released? The objective is not to carry the lowest possible inventory. The objective is to carry the right inventory. What Is Dead Stock? Dead stock is inventory that has remained unsold or unused for an extended period and has little realistic probability of moving through normal business activity. It may include: Discontinued products Old packaging Outdated designs Seasonal stock Expired products Obsolete components Damaged goods Raw materials no longer required Products replaced by newer versions Promotional inventory from discontinued campaigns Dead stock differs from slow-moving stock. A slow-moving product may still sell occasionally. Dead stock may require discounting, bundling, liquidation, return to vendor, repurposing or eventual write-off. The financial danger is waiting too long to recognise the difference. The Hidden Costs of Excess Inventory The purchase cost is only the first cost. 1. Working Capital Gets Locked Suppose a business spends ₹25 lakh on stock expected to sell within three months. Instead, it takes nine months. That ₹25 lakh cannot simultaneously fund: Advertising Payroll Vendor advances New product development Machinery Expansion Debt repayment Excess stock therefore has an opportunity cost even when the inventory is eventually sold. 2. Warehousing Costs Increase More inventory may require: Additional warehouse space Racking Handling Labour Security Insurance Utilities These expenses often appear elsewhere in the P&L, making the connection to poor inventory decisions difficult to see. 3. Discounting Erodes Gross Margin When ageing stock eventually becomes a problem, management usually tries to clear it. A product originally expected to generate a 50% gross margin may eventually be sold at: 20% discount 30% discount Buy-one-get-one offer Clearance pricing The inventory value has not simply delayed cash. It may have permanently reduced profitability. 4. Obsolescence Risk Increases This is particularly important for: Fashion Beauty Electronics Nutraceuticals Food Packaging Machinery components Technology products The longer inventory sits, the greater the possibility that its commercial value declines. 5. Management Attention Gets Diverted Dead stock creates meetings. Teams debate pricing. Warehouses rearrange space. Marketing creates clearance campaigns. Finance reviews provisions. Procurement negotiates returns. Operations counts and recounts ageing inventory. The cost is not only financial. It is organisational. Financial Analytics: Stop Looking Only at Total Inventory A strong Financial Analytics system should break inventory into meaningful management categories. Inventory Ageing An example: Inventory Age Stock Value % of Inventory Management View 0–30 days ₹28 lakh 35% Healthy 31–90 days ₹24 lakh 30% Monitor 91–180 days ₹14 lakh 17.5% Review 181–365 days ₹9 lakh 11.25% High risk 365+ days ₹5 lakh 6.25% Potential dead stock Total inventory = ₹80 lakh. But management should immediately focus on the ₹14 lakh sitting beyond 180 days. That is where the excess inventory cash flow discussion begins. Track Inventory Turnover A commonly used formula is: Inventory Turnover = Cost of Goods Sold ÷ Average Inventory If annual COGS is ₹3 crore and average inventory is ₹75 lakh: Inventory turnover = 4 times That means inventory is theoretically cycling approximately four times per year. However, company-level turnover is not enough. A business could have: SKU A turning 12 times SKU B turning 6 times SKU C turning twice SKU D not moving at all The overall average hides the problem. Analyse turnover at SKU, category and location level. Calculate Days Inventory Outstanding Another useful metric is: DIO = Average Inventory ÷ COGS × Number of Days If inventory days increase from 70 to 110 while sales remain stable, more capital is being trapped in stock. That should trigger an investigation. The objective is not always to minimize DIO. Some businesses legitimately require longer inventory cycles. What matters is understanding why the number changed. Create an Inventory-to-Cash Dashboard A useful founder dashboard should include: Inventory KPIs Total inventory value Inventory ageing Slow-moving value Dead-stock value Inventory turnover Days inventory outstanding Stock-out rate Excess-stock percentage Financial KPIs Cash tied up in stock Working-capital cycle Gross margin by SKU Markdown losses Inventory provisions Warehousing costs Finance cost attributable to working capital Operational KPIs Forecast accuracy Purchase-order lead time Supplier minimum order quantity Reorder frequency Sell-through rate Returns Production-plan variance ow D2C and E-commerce Brands Build Excess Stock For D2C brands, the problem often starts with optimistic forecasting. A product performs well for two weeks. Marketing expects demand to continue. Procurement orders three months of stock. Then: CAC increases Campaign performance declines A competitor launches Customer preference changes A new SKU cannibalises the old one Inventory remains. Another Common Problem: Buying for Discounts A supplier offers: “Order 10,000 units instead of 5,000 and save ₹12 per unit.” The purchasing team sees: ₹60,000 potential saving. Finance should ask: How long will the additional stock take to sell? What cash gets locked? What is the carrying cost? Is there expiry or obsolescence risk? Could the money generate a higher return elsewhere? A lower purchase price does not automatically mean a better financial decision. Manufacturing Businesses Have a Different Inventory Problem Manufacturers often carry four layers: Raw material Work in progress Finished goods Spares and consumables Excess inventory may therefore develop without appearing in finished-stock reports. Examples include: Raw material bought for cancelled orders Components linked to discontinued models Excess safety stock Slow-moving spare parts Unfinished production Rejected batches awaiting decision McKinsey has found that digital planning approaches in consumer-goods supply chains can reduce inventory levels by approximately 10% to 20% while maintaining service requirements. The opportunity is therefore not simply clearing old stock. It is preventing unnecessary stock from being created in the first place. Why an Operational Audit Matters An Operational Audit investigates how inventory actually moves through the business. It may examine: Demand forecasting Purchase requisitions Purchase approvals Minimum order quantities Reorder levels Goods receipt Warehousing Production planning Stock transfers Returns and damaged inventory Inventory write-offs The goal is to find the process causing the financial problem. Suppose analytics show ₹20 lakh of stock older than 180 days. That is the symptom. The Operational Audit may discover the cause: Buyers are rewarded based on purchase-price savings rather than inventory turnover. That incentive encourages large orders. The finance problem originated in an operational process. What a Business Process Audit Can Reveal A Business Process Audit goes further by asking whether systems, responsibilities and controls are aligned. For example: Problem: Duplicate Purchasing Purchase teams cannot see stock at another warehouse. Result: The same SKU is purchased even though sufficient inventory exists elsewhere. Problem: No Ownership of Dead Stock Finance identifies ageing stock. Operations says sales should clear it. Sales says procurement bought too much. Procurement says marketing forecast demand. Nobody owns the action. Problem: Reordering Based on Intuition Purchase quantities are determined by experience instead of: Actual sell-through Lead time Seasonality Existing stock Open purchase orders Forecast demand A Business Process Audit helps redesign these workflows before they create the next inventory problem. How CFO Advisory Services Turn Inventory Into a Financial Decision Good Virtual CFO Services India connects inventory decisions to business strategy. The discussion moves from: “We have ₹80 lakh of inventory.” to: “₹14 lakh is more than 180 days old. If we liquidate ₹8 lakh over the next 60 days and reduce purchasing by ₹10 lakh, we can release approximately ₹18 lakh of working capital.”That is actionable. A CFO-level review should connect inventory with: Cash flow forecasts Vendor payment cycles Borrowing requirements Gross margins Sales forecasts Production plans Marketing calendars Expansion requirements Inventory management becomes a capital-allocation decision. Action: How to Expose Dead Stock in 8 Steps Step 1: Download SKU-Level Inventory Include quantity, value, location and last movement date. Step 2: Create Age Buckets Start with: 0–30 days 31–90 91–180 181–365 365+ Adjust for your industry’s normal cycle. Step 3: Add Sales Velocity Calculate units sold per month for every SKU. Step 4: Calculate Months of Stock If you have 1,200 units and average monthly sales of 100: You hold approximately 12 months of inventory. Step 5: Identify Excess Compare stock on hand with realistic forecast demand and lead time. Step 6: Quantify Cash Locked Convert excess units into rupee value. Do not stop at quantity. Step 7: Decide the Action Possible actions include: Pause purchasing Transfer stock Bundle products Create targeted promotions Renegotiate supplier returns Repurpose material Liquidate Write down obsolete stock Step 8: Fix the Process Ask why the excess stock existed. This is where Financial Analytics, Operational Audit and Business Process Audit need to work together. Prevention Is More Valuable Than Liquidation Selling ₹10 lakh of dead stock at ₹6 lakh may release cash. But preventing the next ₹10 lakh from becoming dead stock is far more valuable. Build monthly controls around: SKU ageing Reorder approval Purchase forecasting Open purchase orders Inventory turnover Forecast accuracy Minimum order quantities Slow-moving stock ownership Management should discuss ageing inventory every month—not once a year during audit. Bonus How-To: Transitioning Your Home to Renewable Energy The financial logic is similar: understand the economics before investing. Step 1: Analyse Electricity Consumption Review approximately 12 months of electricity bills to understand average household consumption. Step 2: Assess Your Roof Consider: Available area Shading Structural condition Sunlight exposure Society or ownership permissions Step 3: Estimate Solar Capacity Ask qualified rooftop-solar vendors to recommend capacity based on actual consumption and available space. Step 4: Compare Total Cost and Savings Review: Installation cost Expected electricity generation Equipment life Warranty Maintenance Expected bill savings Estimated payback Step 5: Check DISCOM Requirements Residential consumers should verify the relevant technical-feasibility and metering procedures through their electricity distribution company and the official rooftop-solar framework. Step 6: Select a Suitable Vendor Compare equipment specifications, warranties, projected output and after-sales service rather than selecting solely on installation price. Step 7: Monitor Actual Performance After commissioning, compare expected generation with monthly output and electricity savings. Key Takeaways Excess inventory does more than occupy warehouse space. It occupies cash. A business can appear profitable while struggling for liquidity because too much working capital has moved into slow-moving stock. The solution begins by analysing inventory differently. Do not look only at total inventory. Look at: Age Movement Demand Margin Turnover Months of stock Cash value Future commercial relevance Financial Analytics identifies where the money is trapped. An Operational Audit explains how the problem developed. A Business Process Audit helps redesign the systems that allowed it to happen. And CFO Advisory Services connect those findings with working capital, cash flow and business strategy. The objective is not to empty the warehouse. It is to make sure every rupee invested in inventory has a clear commercial purpose and a realistic path back to cash. If you reviewed every SKU in your warehouse today, how much of your reported inventory would you confidently expect to convert into cash within the next 90 days? Frequently Asked Questions 1. How does excess inventory affect cash flow? Excess inventory uses cash that could otherwise fund payroll, marketing, vendor payments, expansion or debt reduction. Until the stock is sold and payment is collected, that working capital remains tied up. Slow-moving inventory can also create additional warehousing, financing and discounting costs. 2. How can a business identify dead stock? Start with an inventory-ageing report and review the last sale or movement date of every SKU. Products that have remained inactive beyond the normal selling cycle should be investigated. Sales velocity, months of stock, demand forecasts and future product relevance can help distinguish slow-moving inventory from genuine dead stock. 3. Which Financial Analytics metrics are most useful for inventory management? Useful metrics include inventory turnover, days inventory outstanding, SKU ageing, sell-through rate, months of stock, stock-out rate, excess-stock value, gross margin by SKU and cash tied up in slow-moving inventory. These should be reviewed together rather than in isolation. 4. What is the difference between an Operational Audit and a Business Process Audit? An Operational Audit examines how effectively activities such as purchasing, warehousing, production and inventory control are being performed. A Business Process Audit focuses more closely on workflows, approvals, responsibilities, systems and controls. Together, they can identify both the inventory problem and the process that created it. 5. How can CFO Advisory Services help reduce excess inventory? CFO Advisory Services connect inventory decisions with cash-flow forecasting, purchasing plans, margins and working-capital requirements. A CFO advisor can quantify cash trapped in excess stock, identify priority SKUs, set inventory KPIs and help management create purchasing and liquidation strategies that improve liquidity.
