How to Forecast Cash Flow for E-commerce Growth

A profitable e-commerce business can still run short of cash. A strong sales month may be followed by a supplier payment, VAT quarter, payroll run and marketplace payout delay, leaving less in the bank than expected. Learning how to forecast cash flow gives directors a clearer view of those pressure points before they become urgent decisions.

For owner-managed businesses, a cash flow forecast is not simply an accounting exercise. It is a practical management tool for deciding when to reorder stock, whether a marketing campaign is affordable, how much can be withdrawn, and when finance may be needed. The most useful forecast is built around the way money actually moves through your business, rather than relying on sales figures alone.

What a cash flow forecast should show

A cash flow forecast estimates your opening bank balance, expected cash received, expected cash paid out and closing bank balance over a defined period. Most growing businesses should forecast weekly for the next 13 weeks, then monthly for the remainder of the financial year.

The 13-week view is particularly useful because it is detailed enough to manage immediate commitments while providing enough notice to change course. A monthly forecast can hide a difficult week in which several large payments fall due before customer cash arrives.

The core calculation is straightforward:

Opening cash + cash receipts - cash payments = closing cash

The judgement sits behind the numbers. A dependable forecast recognises the difference between a customer placing an order, a marketplace confirming a sale and the proceeds reaching your bank account. It also separates costs that look manageable in the profit and loss account from payments that create a genuine cash outflow at a specific date.

How to forecast cash flow accurately

Start with the current cleared bank balance, not the balance shown in a report that includes payments still pending. If your business operates several accounts, include all accounts used for trading, tax reserves, payment processors and foreign currency. A forecast is only as useful as its opening position.

Next, map expected receipts by the date they are likely to arrive. For a direct-to-consumer business, this may mean modelling Shopify or website sales, less refunds and chargebacks, based on normal settlement timings. For Amazon, eBay and other marketplaces, use actual payout schedules and account for funds held in reserve. Wholesale businesses should use invoice due dates adjusted for their customers' real payment behaviour, not merely their contractual terms.

Then add payments according to their due dates. This is where many first forecasts become too optimistic. Include the timing of supplier deposits and final balances, freight, customs duty, fulfilment charges, advertising spend, payroll, rent, software, loan repayments and professional fees. Payments for stock often fall weeks or months before that stock produces revenue, which makes inventory planning central to e-commerce cash flow.

Finally, calculate each week's closing balance and carry it into the following week as the opening balance. Review the lowest projected balance, rather than looking only at the closing figure at the end of the period. A forecast that finishes the quarter positively can still reveal a short-term funding gap that needs attention.

Separate cash from profit

Profit does not pay a supplier until it becomes cash. Your accounts may show a healthy gross margin while cash is tied up in unsold stock, customer invoices or marketplace reserves. Equally, a cash surplus can be temporary if VAT, corporation tax or a large supplier invoice has not yet fallen due.

This distinction matters when deciding what the business can afford. A director considering a dividend, additional salary or a major equipment purchase should first look at the forecast after all known liabilities have been included. Company cash is not automatically available for extraction simply because the bank balance is high.

Include VAT and tax at the right time

VAT is one of the most common reasons a forecast appears healthy until it suddenly does not. Add the anticipated VAT payment or refund in the week it is due, based on your accounting method and filing cycle. Businesses using the Flat Rate Scheme, cash accounting or trading across different VAT treatments may need a more tailored calculation.

Corporation tax should also be forecast as a future payment, even though it is normally due after the end of the accounting period. If your company is profitable, setting aside cash monthly is generally more disciplined than treating the full liability as a distant issue. PAYE, National Insurance and pension contributions need the same treatment, with payment dates aligned to your payroll timetable.

For businesses importing goods or selling internationally, include customs duty, import VAT where it creates a cash cost, currency conversion charges and overseas tax obligations. These amounts can be material, particularly where stock lead times are long or exchange rates move sharply.

Build the forecast around your trading cycle

A generic template can provide a starting point, but it will not reflect the commercial reality of every business. Your forecast should follow the drivers that determine cash movement in your operation.

For e-commerce businesses, these commonly include:

• expected order volumes, average order value and refund rates;

• payment gateway and marketplace settlement lags;

• stock purchase orders, minimum order quantities and supplier terms;

• advertising commitments and seasonal marketing spend;

• VAT, payroll, tax and finance repayment dates.

Seasonality requires particular care. A business preparing for Black Friday or Christmas may need to commit substantial cash to stock, photography, packaging and advertising well before peak trading begins. The forecast should show the funding requirement during the build-up, not just the anticipated sales uplift once the campaign is live.

It is also sensible to distinguish between committed and discretionary spending. A supplier invoice for goods already ordered is a committed outflow. A proposed paid social campaign may be adjustable if cash falls below the level you consider safe. That distinction gives management a more realistic set of options when trading changes.

Use assumptions, then test them

Every forecast contains assumptions. The objective is not to pretend they are certain, but to make them visible and test their effect on cash.

Create a base case using the most likely trading assumptions, then consider a downside case. For example, sales might be 15 per cent below plan, a shipment may arrive later than expected, or returns may rise after a promotional period. You may also want an upside case where higher demand requires an earlier stock reorder. Growth can create a cash requirement as readily as weaker sales can.

The key question is not whether the forecast is perfect. It is whether the business has enough time to respond if the assumptions prove wrong. If the downside case shows a negative balance in six weeks, management can reduce discretionary spend, renegotiate supplier terms, defer an order, accelerate collections or arrange funding while choices are still available.

Avoid treating a cash forecast as a one-off annual document. Update it at least weekly, replacing estimates with actual bank movements and revising future assumptions. Compare forecast receipts and payments with what happened, then investigate significant differences. Over time, this process improves the accuracy of settlement assumptions, inventory planning and marketing decisions.

Choose tools that preserve control

A spreadsheet remains effective for many smaller businesses because it can be tailored to specific payout cycles, stock orders and tax dates. However, it needs clear ownership, version control and regular reconciliation to the bank. A static spreadsheet updated only when a problem arises creates false reassurance.

Cloud accounting software such as Xero can provide current bank feeds, aged debtor information and reporting that supports a more disciplined forecast. Forecasting applications and integrated dashboards may add useful automation where transaction volumes are high. The right choice depends on complexity, data quality and who will maintain the model. Automation speeds up data collection, but it does not replace commercial judgement about sales, stock and timing.

A practical approach is to use accounting records as the source of truth for historic performance and liabilities, while maintaining a forward-looking cash model that captures planned trading activity not yet recorded in the ledger.

Turn the forecast into decisions

A forecast should lead to defined actions. Set a minimum cash buffer that reflects your fixed costs, trading volatility and access to finance. If projected cash falls below that level, identify the decision required and the date by which it must be taken.

That may mean reducing a marketing budget, moving a stock order, collecting overdue invoices, reviewing pricing, using a short-term facility or delaying a planned director withdrawal. The appropriate response depends on the cause of the pressure. Cutting advertising may protect cash in the short term but damage momentum if the campaign has a proven return. Delaying stock purchases can be sensible, unless it creates costly stock-outs during a high-demand period.

For businesses with growing complexity, external finance support can bring useful discipline to this process. Fortis Accounting can help e-commerce directors connect current bookkeeping, tax obligations and trading plans into a forecast that supports better decisions.

The value of a cash flow forecast lies in the conversations it creates before the bank balance forces the issue. Keep it current, challenge its assumptions and use it to make deliberate choices about growth, tax, stock and spending.