Cash Forecasting for E-commerce Brands: The 13-Week Model Explained

Profitable e-commerce brands go bankrupt every month. They look at a P&L showing 12% net margin, take it as proof things are fine, and then run out of cash in week 8 of the next inventory cycle. The reason is simple: P&L profit and cash are not the same thing. Inventory ties up cash months before revenue arrives. Marketing spends today; the customer pays the card processor today; the deposit hits your bank in 2–7 days; suppliers want their money in 30; the ad-bill is monthly. The 13-week direct cash forecast is the only tool that maps this honestly.

What the 13-week forecast is

A weekly view of every dollar going in and out of your bank accounts for the next 13 weeks. "Direct" means it's built bottom-up from actual receipts and payments — not derived from a P&L. The output is your projected bank balance at the end of each week. The first failed week is the deadline for action.

Why 13 weeks (not 12, not 26)

• 13 weeks = roughly one quarter, long enough to see the next inventory order land but short enough that the inputs are still reliable.
• Anything beyond 13 weeks should sit in the annual budget with monthly granularity.
• Weekly cadence catches problems while you can still act — monthly views catch them when it's too late.

The structure (inflows minus outflows)

Inflows

• Card processor deposits (Shopify Payments, Stripe, PayPal) — model the lag from order to deposit per processor.
• Marketplace settlements (Amazon every 14 days, Etsy weekly, etc.).
• Wholesale receivables, by customer with expected payment date.
• Refunds & chargebacks (negative).
• Loans / line of credit draws.
• Owner contributions, equity raises.

Outflows

• Inventory PO payments (deposit, balance on shipment, balance on landing).
• Freight, customs, duties.
• 3PL invoices (storage + per-order fees).
• Outbound shipping carriers.
• Ad spend by channel.
• Payroll (semi-monthly or biweekly).
• SaaS, app subscriptions.
• Rent, utilities, insurance.
• Tax payments (sales tax, payroll tax, income tax).
• Loan principal & interest.
• Owner draws.

Inputs you must have weekly

• Last 7 days of sales by channel and the resulting deposit schedule.
• Open POs with confirmed shipment and landing dates.
• AP aging from the bookkeeping system.
• Planned ad spend by channel for the next 13 weeks.
• Payroll calendar.
• Bank balances Monday morning.

How to build it

• Columns: 13 weekly columns (W1 = current week start).
• Rows: every inflow line, every outflow line, ending with Net Change, Beginning Cash, Ending Cash, Minimum Threshold.
• Highlight any week where Ending Cash falls below your minimum threshold (typically 4–6 weeks of operating expenses).
• Compare actuals vs forecast every Monday and roll the model forward by one week.

Common cash traps the model exposes

• Q4 inventory: buying for Black Friday in August/September can drain cash for 90 days before sales return it.
• Growth shock: a 40% YoY growth quarter typically requires 25–35% more working capital than the prior quarter.
• Marketplace lag: Amazon brands routinely have $80K–$300K in transit between marketplace and bank at any time.
• Returns spike post-promo: model returns 3–6 weeks after large discount events.
• Tax bombs: estimated quarterly tax payments and annual sales tax remittances are easy to forget until they hit.

What to do when a week goes red

• Accelerate inflows: faster wholesale collection, deposit terms on new orders, sell aged inventory.
• Delay outflows: negotiate supplier terms, defer non-critical SaaS and capex.
• Cut variable spend: pause underperforming ad campaigns first, not the best ones.
• Activate financing: line of credit draw, inventory financing, revenue-based financing.
• Avoid panic-discounting — it kills future contribution margin.

Run this every Monday morning, no exceptions. Brands that adopt the 13-week forecast typically reduce surprise cash crunches to zero within two quarters.