How to Build a 13-Week Cashflow Forecast

If there is one financial tool that separates E-commerce founders who sleep well at night from those who constantly worry about making payroll, it is the 13-week cashflow forecast. Not a 12-month plan built on optimistic assumptions. Not a set of annual projections gathering dust in a slide deck. A rolling, week-by-week view of exactly how much cash is coming in, how much is going out, and what your bank balance will look like every Friday for the next quarter.

Why 13 Weeks?

Thirteen weeks equals one quarter — long enough to see meaningful trends and upcoming pinch points, short enough to forecast with real accuracy. Annual or even six-month forecasts rely heavily on assumptions that drift further from reality with every passing month. A 13-week forecast uses data you already have: confirmed orders, committed expenses, known payroll dates, VAT due dates, and inventory purchase orders. The result is a forecast you can actually trust and act on.

Start with Your Bank Balances

The first row of your forecast is today's opening cash balance — the real number sitting in your bank accounts right now. Every week flows forward from that starting point. This is not about accounting profit; it is about physical cash. Money in the bank. If you have multiple accounts or currencies, consolidate them into a single opening position so you have one clear starting number.

Categorise Your Inflows

Cash inflows for most E-commerce businesses come from a handful of sources. Break them down clearly: sales by channel (Amazon settlements, Shopify payments, TikTok payouts, wholesale invoices), refunds and returns (these reduce your inflows, so model them separately), and any other income such as interest, grants, or insurance claims. The key is to use actual settlement timings, not the date of the sale. Amazon might pay you fortnightly; Shopify might settle daily. Map the cash to the week it actually hits your bank, not the week the order was placed.

Categorise Your Outflows

This is where most founders underestimate the complexity. Your outflows should be broken into clear categories: cost of goods sold (supplier payments based on purchase order terms), inventory purchases and deposits for upcoming orders, marketing spend (ad platforms typically charge weekly or on a billing threshold), payroll and contractor payments, rent and warehouse costs, software subscriptions and tools, VAT and tax payments, loan repayments, and any one-off costs like equipment or legal fees. Be precise about payment dates. A supplier invoice dated 1 March with 30-day terms means cash leaves your account in the first week of April, not March.

Weekly vs Monthly Buckets

The first four to six weeks should be modelled weekly — this is where precision matters most and where you have the most reliable data. Weeks seven through thirteen can be slightly broader in their assumptions, but still weekly in structure. Avoid the temptation to collapse the later weeks into monthly buckets; the whole point of a 13-week forecast is weekly granularity so you can spot a problem in week nine today, not in week eight when it is too late to act.

Stress-Test Your Scenarios

Once your base case is built, create at least two alternative scenarios. A downside case should answer: what happens if sales drop 20% for three consecutive weeks while inventory commitments stay fixed? An upside case should test whether you have the cash to fund accelerated growth if a channel takes off. Stress testing is not about predicting the future — it is about understanding how fragile or resilient your cash position really is. Most founders are shocked to discover that even a modest sales dip can push them into negative cash territory within six weeks because of pre-committed inventory and fixed costs.

Common Mistakes to Avoid

The most common mistake is building the forecast once and never updating it. A 13-week forecast should be refreshed every Monday with actual figures from the previous week and updated assumptions for the weeks ahead. The second mistake is confusing revenue with cash — just because you sold a product on Amazon does not mean the cash is in your account yet. Settlement delays, chargebacks, and holds can create significant gaps between reported sales and available cash. The third mistake is excluding VAT. For UK-based E-commerce brands, quarterly VAT payments can represent a six-figure cash outflow that catches founders off guard every single time if it is not built into the forecast.

Using the Forecast for Decisions

The 13-week forecast is not a report to file away. It is a decision-making tool. Use it to answer questions like: can we afford to place that next inventory order, or should we split it across two months? Do we need to negotiate extended payment terms with our manufacturer before cash gets tight? Should we pull back marketing spend in week six to protect cash for a VAT payment in week eight? Can we hire that new team member, or should we wait until week ten when the cash position strengthens?

When the forecast becomes a weekly operating habit, you stop reacting to cash problems and start preventing them. That single shift — from reactive to proactive — is the difference between a founder who scales with control and one who scales into a crisis.

Building a 13-week cashflow forecast is not complicated, but it does require accuracy, consistency, and discipline. If you are running an E-commerce brand above half a million in revenue and you do not have one, it should be the first financial tool you build this week.