A 13-week cash flow is a weekly plan of all cash receipts and payments for the next three months. It shows early when cash will get tight and gives you time to act: postpone purchasing, negotiate payment terms, request financing. In e-commerce it is especially valuable because purchasing, advertising and marketplace payouts are far apart in time.
Why the profit and loss statement is not enough
A business can be profitable and still run into a cash crunch. Typical reasons in online retail:
- goods are paid for months before they sell
- advertising is charged immediately, revenue comes later
- marketplaces pay out with delays and hold reserves
- VAT, duties and one-off items fall due in bulk
- growth ties up additional capital in inventory
The profit and loss statement shows income and expenses, not the timing of cash. The 13-week cash flow closes this gap.
Structure
| Line | Content |
|---|---|
| opening balance | balances of all accounts at start of week |
| receipts shop | payouts from payment providers |
| receipts marketplaces | payouts per marketplace by payout schedule |
| other receipts | B2B receivables, refunds, financing |
| purchasing | deposits and balance payments per supplier terms |
| freight and customs | sea freight, air freight, import duties |
| fulfilment | warehouse, shipping, service providers |
| marketing | ad accounts by billing schedule |
| staff | salaries, freelancers |
| other costs | software, rent, advisers |
| taxes | VAT, prepayments |
| financing | interest and repayment |
| closing balance | opening balance plus receipts minus payments |
The closing balance of one week is the opening balance of the next.
Data sources
- account balances and open items from accounting
- marketplace payout reports and reserves
- supplier orders with payment schedule
- advertising budgets and billing schedule
- weekly revenue forecast
- tax deadlines
For the revenue forecast, a simple method is enough at first: the same week last year plus expected change. More important than precision is that assumptions are visible.
E-commerce specifics
Marketplace payouts
Marketplaces pay out at fixed intervals and may hold reserves, for example for returns. Plan by the actual payout date, not the sale date.
Purchasing
Imported goods often involve a deposit on order and a balance before shipment, plus freight and import duties. A single reorder can tie up several weeks of cash. See Inventory Planning for Marketplace Sellers.
Seasonality
Capital needs rise sharply before peak season because goods and advertising are pre-financed. The 13-week cash flow should therefore be set up well ahead of the peak.
Scenarios
Create at least three versions:
- base: realistic expectation
- cautious: lower revenue, delayed payouts
- stress: significantly lower revenue, a delayed shipment, a paused marketplace account
The stress scenario shows how much buffer is needed and which measures would then apply.
Rhythm
- Every week, reconcile the past week with actual figures
- Explain variances
- Add a new week at the end
- Adjust assumptions for the coming weeks
Comparing plan and actuals is where the learning happens. After a few weeks, forecasts improve noticeably.
Levers when cash is tight
- postpone purchases or reduce quantities
- negotiate payment terms with suppliers
- concentrate advertising budget on the most profitable campaigns
- sell down slow-moving stock
- request financing in good time; see Financing Growth
In good time means before the shortfall occurs. Banks and capital providers respond much better to early, well-evidenced requests than to short-notice ones.
Common mistakes
- planning by revenue date instead of payment date
- forgetting tax payments
- not planning balance payments for goods
- creating the plan once and never updating it
- no minimum cash buffer defined
Checklist
- all accounts in the opening balance
- payout schedules per channel recorded
- payment schedule for all orders
- tax deadlines entered
- three scenarios
- weekly plan-versus-actual review
- defined minimum cash level
If you want to run this with your own numbers, I can help in e-commerce and business consulting.
Related: Restructuring a Property Portfolio: Options for Owners
Facing a question about structure?
Send me a short description of the starting point. I prepare the decision with you; you settle legal and tax questions with your professionals.
Book an initial call E-Commerce & MarketingFAQ
Why 13 weeks?
Three months is long enough to see shortfalls early and short enough to plan weekly with reasonable accuracy.
Do I need special software?
No. A spreadsheet is enough to start. What matters is a clear structure, current data and the weekly review.
How large should the cash buffer be?
That depends on the business model. The stress scenario shows which minimum level is needed to get through several weak weeks.
Who should maintain the cash flow?
Someone with access to accounting, purchasing and channel reports, often the managing director or finance lead, ideally with a fixed weekly slot.