Ecommerce Cash Flow: How to Forecast and Manage It

In ecommerce, cash goes out long before it comes back: stock is paid for months ahead, ads are paid today for sales next week, and marketplaces release payouts on their own schedule. Growth makes all of this bigger. This playbook sets out the routines that keep an online store’s cash under control. For why ecommerce cash flow works this way and a worked peak-season example, see the ecommerce cash flow forecast page.

The weekly routine

1. Payouts received from each channel against forecast.
2. Ad spend against plan, and return on ad spend for the last two weeks.
3. Stock position: weeks of cover for top products, and anything overstocked.
4. Purchase orders due for payment in the next eight weeks.
5. Returns and refunds against forecast.
6. The lowest balance in the next 13 weeks.

Inventory planning from lead times

Plan purchases backwards from sales:

Order quantity = forecast sales over the lead time and cover period − stock on hand − stock on order

Then place the payment in the week it’s due, which may be on order, on shipment or on arrival. For imported goods, add freight, duties and customs fees in their own weeks. Review top sellers weekly and slow movers monthly, and discontinue products that tie up cash without selling.

A worked stock decision

A store’s best seller sells about 400 units a week at a cost of $12 each. The supplier’s lead time is eight weeks from order to arrival, and payment is due on shipment, four weeks after ordering. The owner wants four weeks of safety stock.

Order quantity for the next cycle: 400 units × (8 weeks of lead time + 4 weeks of cover) = 4,800 units, less 1,600 on hand and 1,200 on order, gives an order of 2,000 units, costing $24,000, payable in four weeks. The forecast shows that week already carries a $9,000 marketplace fee settlement and an $8,000 ad bill, pushing the balance close to the buffer. The owner asks the supplier to split shipment and payment into two halves two weeks apart. The stock still arrives in time, and the lowest balance stays above the buffer.

Ad spend and payback

Advertising is cash out now, and for many online stores it’s the second-largest cost after stock. Know your payback period: how long it takes for the gross margin from customers acquired to repay the ad spend. If payback is 60 days and you double ad spend, cash falls for two months before it recovers. Scale spend with the forecast, not just with return-on-ad-spend dashboards.

Marketplace and payment payouts

Each channel pays differently:

Forecast each channel’s payouts on its actual schedule, net of fees. Check your payout reports monthly: fees, reserves and holds change, and a new hold on a marketplace account can remove a week or more of cash without warning.

Returns and refunds

Forecast returns as a percentage of sales by channel, paid out in the weeks after the original sale. Allow a higher rate after peak season and for categories like apparel. Include return shipping and any stock that can’t be resold.

Sales tax and VAT

Tax collected on sales isn’t yours. Set it aside as it comes in and forecast each remittance on its due date. Rules differ by country and region and can be complex for cross-border sales, so take advice.

Peak season preparation

For a Q4-heavy store:

• Summer: forecast peak sales and the stock needed; confirm the cash to pay for it.
• August to September: place and pay for peak stock; ad testing.
• October: stock arriving, cash at its lowest point of the year.
• November to December: sales, heavy ad spend, payouts.
• January: returns, lower sales, paying down any seasonal facility.

The lowest balance often falls in September or October. Arrange any inventory finance before then.

Apps, subscriptions and fulfilment

Monthly software subscriptions for the store, email, reviews, shipping and analytics often grow quietly. Review them every quarter. If you use a third-party logistics provider, their fees usually combine storage, pick and pack, and shipping; forecast them as a percentage of orders plus a fixed storage cost, and remember storage fees rise when stock builds before peak season.

Pricing and discounting

Deep discounts move stock but reduce the cash each sale brings in, and frequent promotions can train customers to wait. Use the forecast to compare a clearance discount on slow stock, which releases cash tied up in inventory, with a site-wide promotion that cuts margin on products that would have sold anyway.

Warning signs

• Weeks of stock cover rising on slow products
• Ad spend growing faster than gross margin
• Payouts held or delayed by a marketplace
• Return rates rising
• Supplier payments due before the stock can sell
• Credit cards funding inventory
• Growth in revenue but not in the bank balance over several months
• Discounting more often to hit monthly sales targets

Wholesale and B2B orders

Wholesale orders can be large and welcome, but they usually mean producing or buying stock in advance and waiting 30 to 60 days for payment. Before accepting a big wholesale order, forecast the stock cost, the payment date and any deposit you can ask for. A 30 to 50 percent deposit on large first orders is common and protects your cash.

When cash gets tight

1. Pause or cut ad campaigns with the longest payback.
2. Clear slow-moving stock with promotions.
3. Negotiate staged payments or longer terms with suppliers.
4. Split large orders into smaller shipments.
5. Consider inventory or revenue-based financing with a clear repayment plan.

Tools

The premium Ecommerce template includes a Stock Purchases tab that pulls purchase payments forward by your lead time, an Order Costs tab for fulfilment, payment fees, returns and sales tax, scenarios for a weaker peak, and a dashboard. See also cash conversion cycle and seasonal cash flow.