The 13-Week E-commerce Cashflow Forecast: How It Works and Why Your Business Needs One

Most e-commerce businesses don't fail because they're unprofitable. They fail because they run out of cash — usually during their busiest trading period, when stock requirements and advertising spend are highest and Amazon's payment reserve has never been larger.

The 13-week rolling cashflow forecast is the tool that prevents this. A week-by-week projection of every significant cash inflow and outflow for the next 13 weeks, updated monthly with actuals. See the shortfall coming in week 11 and you have 11 weeks to act.

Why 13 Weeks?

13 weeks is one quarter — long enough to see seasonal patterns and plan for quarterly events (VAT payments, inventory purchasing, Q4 stock buying), but short enough to forecast with reasonable accuracy. The rolling element is critical: every week, you drop the oldest week off and add a new week to the front, keeping the model perpetually covering the next 13 weeks.

The Five Cash Inflows to Model

• Platform payouts: Amazon settles bi-monthly with 7-14 day delay. Shopify Payments pays daily or weekly. eBay pays on 3-5 day basis. Model each platform's payout separately using the actual settlement schedule.
• Direct website sales: payment typically clears within 1-3 business days depending on the gateway.
• Wholesale and B2B payments: if you sell on 30-day or 60-day terms, model receivables by due date, not invoice date.
• Reimbursements: Amazon reimbursements for lost or damaged stock can be significant — include when expected.
• Financing proceeds: stock finance drawdowns and repayments must be modelled accurately by date.

The Six Cash Outflows to Model

• Inventory purchases: model each purchase order by payment due date — when money leaves, not when goods arrive. Include deposits on future orders separately from balance payments.
• Shipping and fulfilment: direct fulfilment costs (packaging, postage, 3PL fees) appear as separate bank payments.
• Platform and software fees: Shopify subscription, software, and other recurring SaaS costs.
• VAT payments: UK VAT is due one month and seven days after each quarter end. Often one of the largest single cash outflows of the quarter.
• Tax payments: corporation tax due 9 months and 1 day after accounting period end. Sole trader income tax payments on account in January and July.
• Operating costs: salaries, rent, insurance — the most predictable outflows.

The Amazon Timing Problem

A seller who spends £40,000 on Q4 stock in September doesn't receive the November revenue cash until just before Christmas. During October, November, and most of December, they're funding £40,000 of stock from their own working capital. A 13-week forecast built in August shows this gap clearly — with enough lead time to arrange a stock finance facility.

Building the Model

• Week 1-4: model with high confidence from known purchase orders, confirmed advertising commitments, and historical payout patterns
• Week 5-8: model with good confidence using seasonal projections and known upcoming payments
• Week 9-13: model with moderate confidence using trend extrapolation — these weeks update as they approach
• Flag every week where the cumulative cash position goes negative
• For each problem week, identify the earliest possible action: delay a stock order, draw on credit, request extended supplier terms

When to Get a Virtual CFO

If your business turns over more than £500,000 per year or you're experiencing cashflow stress despite growing revenue, this model is worth professional help. A specialist e-commerce Virtual CFO builds it correctly from the start, connects it to your accounting data for automated updates, and interprets the outputs with strategic experience. Typical cost: £500-£2,000/month.