Ecommerce Cash Flow Template

Start with the 13-Week Cash Flow sheet. Download the file, open it in Excel or Google Sheets, and begin by entering your current cash balance in the starting balance cell. Then populate the inflow rows with your expected weekly revenue by channel — check your Shopify, Amazon Seller Central, or other platform dashboards for recent weekly averages. For outflows, work through each row: your next inventory purchase date, your average weekly ad spend, your fulfillment cost per order multiplied by expected order volume, and your platform fee rate. This first pass takes about 30-45 minutes and gives you a 13-week projection.

Once the 13-week sheet is set up, move to the Inventory Cash Timing sheet if you order from overseas suppliers. Enter your upcoming purchase orders, supplier payment terms, and expected lead times. The sheet will show you exactly when cash leaves and when you can expect goods to arrive — which tells you whether you have enough cash on hand to fund the next order cycle without drawing on a credit line. If you run paid ads at scale, also fill in the Ad Spend & Payout Tracker with your weekly ad budgets and the average payout delay for each platform.

Update the 13-week view weekly — it takes about 10-15 minutes if you pull your actual weekly revenue from your platform dashboards. Replace projected figures with actuals as each week closes and review the next 4-6 weeks of projected cash balance. The dashboard's runway indicator will tell you immediately if something has shifted. Most ecommerce operators find that weekly updates catch inventory funding issues 3-4 weeks before they become a real problem, which is enough time to arrange a short-term credit line or adjust purchase orders.

Ecommerce businesses are profitable on paper much more often than they're cash-positive in practice. The gap comes from timing: you pay suppliers 30-90 days before products sell, ad platforms charge your card before the revenue from those ads arrives, and marketplace payouts come on a fixed schedule that doesn't align with when orders are placed. A 35% gross margin business can still run out of cash if inventory and advertising are scaling faster than payouts clear. This is why cash flow management is a more pressing problem for ecommerce than for service businesses where revenue and cash receipt happen on the same day.

The ecommerce cash flow cycle has three main timing gaps worth modeling. First, the inventory gap: most ecommerce brands buying from overseas suppliers pay 30-50% upfront at order placement, with the balance due before shipment — often 60-90 days before the goods are available for sale. Second, the ad spend gap: when you scale acquisition, you're spending on customer acquisition today against revenue that will arrive in your payout cycle days or weeks later. Third, the returns gap: ecommerce return rates run 15-30% depending on category, and those refunds hit your cash balance before you've recovered the inventory costs. A good cash flow template makes all three of these gaps visible so you can plan around them.

The most valuable use of a cash flow statement in ecommerce isn't historical — it's forward-looking. Plug in your Q4 inventory purchase plan in July, and you'll immediately see whether you have enough cash to fund it or need to arrange a line of credit. Model a 20% increase in ad spend for a new product launch, and you'll see how many weeks it takes before the revenue from that spend lands in your account. This template is structured for that forward-looking workflow: start with actuals, extend with projections, and use the runway indicator on the dashboard to flag when your cash position needs attention.