A shop can achieve a healthy margin and still experience cash-flow pressure. The reason is timing: merchandise is ordered before it is sold, some bills fall due on fixed dates and busy periods may require restocking several weeks in advance. A cash-flow forecast helps reveal these gaps.
Bpifrance Création includes a monthly cash-flow forecast among the essential financial projections in a business plan. For a retailer, it then becomes a management tool to update every month.
Track actual cash received and paid out
The income statement and the cash position do not tell exactly the same story. A cash-flow forecast records when money actually enters or leaves the bank account. Month by month, list receipts from sales, owner contributions and financing, followed by merchandise purchases, rent, operating costs, wages, VAT, insurance, subscriptions, loan repayments, investments and marketing expenses.
For a physical shop where customers pay immediately, delays in customer payments are limited. However, supplier payment terms and the amount invested in stock can be significant.
Plan a stock purchasing calendar
Merchandise expenditure should not simply be entered as a constant percentage of sales. Orders follow a timetable. A shop may buy more in September and October ahead of the year-end season, then receive much of the corresponding sales income in November and December. Your plan should reflect this pattern.
Also distinguish initial stock purchases from restocking. Launch stock belongs in the initial financing plan; subsequent replenishment should be covered by the business's normal operating cycle.
Include VAT and overlooked payment deadlines
Some cash in the bank account is not permanently available to the business. Depending on its tax regime, VAT collected must be paid over after deducting recoverable input VAT. You must also budget for social contributions, taxes, insurance renewals, bank fees, maintenance and annual expenses that do not occur every month.
Include opening and closing cash balances
The table should begin with the cash available on the first day of the month. Add cash receipts, deduct payments and calculate the closing balance, which becomes the opening balance for the following month. This method immediately highlights months when the shop may fall below its minimum cash reserve.
The aim is not to wait for a negative balance before responding. Several months' advance warning gives you time to reduce an order, negotiate supplier terms, postpone an investment or arrange financing.
Work with three sales scenarios
A cash-flow forecast based only on the desired turnover scenario is fragile. It is better to prepare a central, a low and a high scenario. The low scenario must answer a key question: if sales grow more slowly than expected, how many months can the shop continue operating without additional funding?
This approach helps determine the cash safety buffer needed at launch. It also reduces the risk of tying up too much cash too quickly in an excessively broad product range.
Update actual results every month
After opening, add a column of actual figures to the forecast. Analyse differences between forecast and reality: lower sales, different margins, earlier stock purchases or unexpected expenses. After a few months, the plan becomes more reliable as the shop's own seasonal patterns emerge.
This discipline directly complements stock management. Our guide How to manage stock without tying up your cash explains the relationship between stock turnover and liquidity.
Turn the cash-flow forecast into a decision-making tool
The main value of this document is not simply accounting. It tells you when to order, how much to keep in reserve, when an expense is affordable and whether growth can genuinely be financed. Paradoxically, a shop whose sales rise may need more cash if it must hold more stock.
The Bpifrance Création cash-flow forecast resource provides more detail on building the table. Initial assumptions can also be structured in the Esotericæ business plan generator.