Cash Flow Forecast Template for Ecommerce Stores

Ecommerce businesses usually run short of cash when sales are growing, not when they’re falling. Stock for the holiday season has to be paid for two or three months before it sells, ads are paid daily while revenue follows, and marketplaces hold payouts for days or weeks. A cash flow forecast shows how much stock you can afford to buy, and when.

Why ecommerce cash flow is different

• Inventory is bought ahead of sales. With manufacturing and shipping lead times, you may pay for Q4 stock in August.
• Payouts lag orders. Shopify and other platforms settle in days; marketplaces such as Amazon may hold funds longer and deduct fees first.
• Ads come before revenue. Paid acquisition is spent immediately and earns back over weeks.
• Returns are real costs. Refunds, return shipping and unsellable stock reduce cash after the sale.
• Sales tax is collected, not earned. It must be paid over, usually monthly or quarterly.

A worked example

A store sells about $95,000 a month, rising to $150,000 in November. Cost of goods is 40 percent of sales, and stock is paid for two months before it sells.

The business is profitable across the season, but September and October are negative because it’s paying for November’s stock. Without a forecast, the owner sees cash falling and cuts ad spend, which is the opposite of what the plan needs.

How to build an ecommerce cash forecast

1. Forecast sales by month and channel, with seasonal peaks.
2. Calculate stock purchases as cost of goods, pulled forward by your lead time.
3. Enter payouts in the week each platform actually pays.
4. Add ad spend, fulfilment or 3PL costs, payment fees and returns as percentages of sales.
5. Schedule sales tax remittances and freight and duty payments.
6. Plan inventory financing if the stock build is larger than your cash buffer.

Common mistakes

Ordering peak-season stock without checking cash two months earlier. Forgetting duties and freight on imports. Ignoring returns in January. And measuring ads by revenue rather than the cash they tie up.

What the template gives you

The Ecommerce template includes a Stock Purchases tab that calculates what you need to pay for stock each month from your sales forecast, cost of goods percentage and lead time. An Order Costs tab ties fulfilment, payment fees, returns and sales tax to sales. Change your November forecast and the August stock payment updates automatically.

Key assumptions built into the Ecommerce template

• The Stock Purchases tab calculates what you pay for stock each month: cost of goods at 40% of shopify / store payouts, marketplace payouts (amazon, etsy) and wholesale orders, paid 2 months before it sells. Raise next season’s sales forecast and the stock payments move earlier and grow automatically.
• The Order Costs tab calculates fulfilment and 3pl at 9% of shopify / store payouts and marketplace payouts (amazon, etsy), payment processing at 2.9% of shopify / store payouts, returns and refunds at 6% of shopify / store payouts and marketplace payouts (amazon, etsy) and sales tax at 6.5% of shopify / store payouts, paid 1 month later. Change a percentage once and every month of the forecast updates, so costs rise and fall with the sales that drive them.
• 4 cash in lines and 8 cash out lines are already named for ecommerce businesses, and every one can be renamed or extended. Loans and investment (inventory financing) are kept out of the runway calculation and don’t grow automatically in the 3-year outlook.
• The example figures follow a typical ecommerce year, busiest in December and November and quietest in February and January, so the tight months show up where they usually fall.

Every assumption sits in a yellow input cell, so you replace the example with your own numbers in minutes. The same figures flow through a 13-week weekly view, a 12-month monthly view and a 3-year outlook, and a dashboard shows your lowest balance, the weeks that fall below your minimum buffer and your cash runway.

Free or premium?

If you only need the basics, the free 12-month template or the free 13-week template will get you started today. The premium Ecommerce template saves the setup time and adds the tabs above, best and worst case scenarios, and an actual vs forecast tracker that shows where your forecast was wrong, so next month’s is better.

Ecommerce cash flow forecasting: questions

How far ahead should an ecommerce store forecast inventory?

At least as far as your total lead time from order to sellable stock, plus one month. For imported goods that’s often four to six months.

How do marketplace payouts affect cash flow?

Marketplaces pay out after deducting fees and may hold funds for a period, so cash arrives later than the order date and is lower than the order value.

Why is my online store profitable but short of cash?

Usually because stock for future sales is paid for months ahead, and growth increases that stock investment faster than sales cash comes in.