E-commerce Cash Flow Forecasting Guide (2026)

Why E-commerce Businesses Run Out of Cash (Even While Profitable)

On paper, your e-commerce store is thriving. Your dashboard shows ₹10 lakh in gross sales this month, your blended return on ad spend (ROAS) is 3.5x, and your gross margins sit at a healthy 40%.

Yet your current account is empty, you are scrambling to pay your suppliers for next week's inventory, and the GST return payment on the 20th is looming.

This is the central paradox of Indian e-commerce: profitability does not equal liquidity.

In e-commerce, money rarely moves in sync with sales. Payouts from marketplaces are delayed by 7 to 14 days, Cash on Delivery (COD) remittances take even longer, customers return 20% of orders, and suppliers demand advance payments 60 days before the festive season.

A cash flow forecast is the single most important tool to ensure your business survives these cash traps. Here is how to build an actionable, realistic cash flow forecast specifically designed for Indian e-commerce sellers and D2C brands.

---

The 4 Cash Traps Unique to Indian E-commerce

Standard accounting templates fail online sellers because they ignore the unique frictions of Indian retail and e-commerce:

1. Marketplace Settlement Lags and Holdbacks

When you sell on Amazon India, Flipkart, or Meesho, you do not receive payment on the day of the sale:

• Settlement cycles: Marketplaces disburse funds on a 7- to 14-day rolling cycle.
• Account reserves / holdbacks: Platforms retain a percentage of your balance to cover customer returns, chargebacks, and A-to-z guarantee claims. If your sales spike rapidly, the holdback amount increases, locking away working capital precisely when you need it most.
• Deductions at source: Marketplaces deduct referral fees, closing fees, FBA/Fulfillment charges, and 1% TCS (Tax Collected at Source under GST Section 52) before depositing the net amount into your bank.

2. The COD & RTO Cash Drain

In India, Cash on Delivery (COD) accounts for 50% to 65% of orders for emerging D2C brands. This introduces two distinct cash flow shocks:

• Remittance latency: Third-party logistics partners (3PLs) typically remit COD cash 3 to 7 days after successful delivery. That means an order shipped on Day 1 might not turn into cash until Day 10 or 14.
• Return to Origin (RTO): If a customer refuses a COD order at the doorstep, you collect ₹0 in revenue, but you still pay the courier company for forward shipping and reverse shipping (typically ₹80–₹160 per shipment). You must budget an explicit cash reserve for RTO losses.

3. The Festive Pre-Stocking Gap

During festive seasons like Diwali, Dussehra, and the Big Billion Days, sales can surge 3x to 5x. However:

• Manufacturers and suppliers require a 30% to 50% advance in August and September to produce goods in time.
• The inventory arrives in late September.
• The customer buys in October.
• The marketplace or courier pays you in late October or November.

That creates a 60- to 75-day cash deficit where cash outflows spike months before cash inflows arrive.

4. Statutory Tax Outflows

Unlike physical retailers who collect cash immediately and remit GST later, e-commerce sellers must pay their monthly GSTR-3B tax on the 20th of every month based on the previous month's invoiced sales—even if the marketplace has not yet disbursed all the corresponding funds.

---

The 13-Week Cash Flow Forecast Framework

For online sellers, an annual forecast is too slow to catch liquidity crunches. The gold standard is a rolling 13-week cash flow forecast updated every Monday morning.

Forecast Structure

Opening Cash Balance (Monday 9:00 AM)
+ Operational Cash Inflows
  - Marketplace Payouts (Amazon, Flipkart, Meesho net of fees)
  - D2C Payment Gateway Settlements (Razorpay, Cashfree net of 2% MDR)
  - COD Remittances from 3PLs (Shiprocket, Delhivery)
  - Other Inflows (B2B wholesale, refunds received)
= Total Available Cash

- Operational Cash Outflows
  - Inventory Purchases & Supplier Advances
  - Courier & Shipping Charges (Forward + RTO freight)
  - Performance Marketing & Ad Spend (Meta, Google, Amazon Ads)
  - Packaging & Warehousing Costs
  - Salaries, Contractor & Freelancer Fees
  - Software & Subscriptions (Shopify, ERP, tools)
  - Statutory Dues (GSTR-3B payment on 20th, Advance Tax, TDS)
  - Loan EMIs & Financing Costs
= Total Cash Outflows

= Closing Cash Balance (Friday 6:00 PM)

---

Worked Example: A ₹10 Lakhs/Month E-commerce Seller

Let's look at how this plays out in practice for an apparel seller doing ₹10,00,000 in monthly Gross Merchandise Value (GMV) across marketplaces (60%) and Shopify D2C (40%):

Line Item	Monthly Figures (₹)	Timing & Cash Flow Impact
Gross Sales (GMV)	₹10,00,000	Invoiced revenue
Less: Returns & Cancellations (20%)	(₹2,00,000)	No cash collected; RTO freight incurred
Net Delivered Sales	₹8,00,000	Realized revenue
Less: Marketplace Fees & Commissions (22%)	(₹1,32,000)	Deducted automatically from payouts
Less: Payment Gateway MDR (2% on D2C)	(₹6,400)	Deducted at settlement
Net Cash Inflow from Sales	₹6,61,600	Lands in bank in batches across Weeks 1–4
Outflows: Inventory (COGS at 35%)	(₹3,50,000)	Often paid 30–45 days in advance
Outflows: Ad Spend (25% of GMV)	(₹2,50,000)	Charged to credit card or debited weekly
Outflows: Shipping & RTO Costs	(₹85,000)	Billed weekly by 3PL
Outflows: GST Liability (net of ITC)	(₹45,000)	Due on 20th of the following month
Outflows: Overheads & Packaging	(₹40,000)	Fixed monthly costs
Total Cash Outflows	(₹7,70,000)	Cash leaving current account
Net Cash Flow for the Month	-₹1,08,400	Temporary Cash Deficit

Notice that even with healthy gross margins, scaling inventory and ad spend creates a negative monthly cash flow of ₹1,08,400. Without a forecast, the seller would be blindsided by a bounced supplier cheque or unpaid GST.

---

4 Levers to Fix Cash Flow Shortfalls

When your forecast indicates a negative closing balance in 3 or 4 weeks, you have time to act rather than panic:

1. Model Product Margins Before Scaling Ads

Never scale marketing on a product without calculating your net take-home margin after returns, commissions, and shipping. Use our free Marketplace Profit Calculator to stress-test your unit economics at different return rates.

2. Use Non-Dilutive Working Capital Financing

Rather than slowing down sales during peak seasons, bridge the 60-day inventory gap with a short-term working capital facility or marketplace seller loan.

• Calculate your monthly EMI and interest burden with the Working Capital Loan Calculator.
• Compare top lenders like Lendingkart, Indifi, and banks in our Best Business Loans for E-commerce Sellers Guide.

3. Unlock Receivables via TReDS

If you supply B2B goods to corporate buyers, retail chains, or government PSUs alongside your e-commerce sales, do not wait 60 to 90 days for payment. Discount your invoices within 48 hours using the RBI-regulated TReDS system.

4. Build a Dedicated Festive GST Reserve

During Diwali and festive sales, higher sales translate into large GST liabilities due the following month. Set aside 10–12% of every marketplace payout into a separate sub-account to prevent a cash crisis on the 20th.

---

Summary Checklist: Your Weekly Cash Flow Routine

1. Every Monday morning: Download pending settlements from Amazon, Flipkart, and your payment gateway.
2. Review COD aging: Check 3PL portals for undelivered shipments and initiated RTOs.
3. Update the 13-week sheet: Input confirmed outflows (vendor payments, payroll, tax deadlines).
4. Identify the minimum cash point: Look ahead 4 weeks. If the projected closing balance drops below your emergency buffer (typically 1 month of fixed expenses), initiate financing or adjust marketing spend immediately.

---

Related Tools & Guides on Dhanaay:

• Explore the Finance & Loans Hub and E-commerce Hub
• Marketplace Profit Calculator — model net margin after fees and returns
• Working Capital Loan Calculator — calculate financing costs for inventory
• Best Business Loans for E-commerce Sellers (2026)
• Best Business Current Accounts Online
• Business Finance Guide for D2C Brands
• TReDS Guide for MSMEs

Official References: Review statutory GST settlement and TCS guidelines on gst.gov.in.