Cash Flow Forecasting for Small Businesses Without a Finance Team

Profitable businesses fail. Not often for dramatic reasons. They fail because money arrives later than it leaves, and nobody was watching closely enough to see it coming.

The tool that prevents this is a cash flow forecast. Most small businesses do not have one, usually because they picture something complicated. It is not complicated. It is a list of money coming in, a list of money going out, and dates.
Why the profit and loss account does not warn you
Your P&L records an invoice as revenue when you issue it. Your bank account records it when the client pays, which under French payment terms might be sixty days later.

A company can show a strong month on paper and be unable to pay salaries in the same month. The P&L is a scoreboard for a game that already happened. A cash flow forecast is a weather report for the game ahead.
The thirteen-week rolling forecast
Thirteen weeks is the standard horizon because it is long enough to see a problem coming with time to act, and short enough that your estimates are worth something. Beyond a quarter you are guessing.

Rolling means you add a week every week, so you always have thirteen weeks ahead of you rather than watching a fixed window shrink.

Build it like this.

Start with your actual bank balance today. Not the accounting figure. The number in the account.

List every expected receipt by the week you expect it to arrive. Issued invoices with due dates. Recurring subscription revenue. Anything else. Use the date the client will realistically pay, not the due date on the invoice, and if a client is habitually three weeks late then put them three weeks late.

List every expected payment the same way. Salaries and contributions. Rent. Suppliers. Loan repayments. VAT. Corporation tax instalments. Insurance. Subscriptions. The annual and quarterly items are the ones people forget, and they are the ones that hurt.

Each week, calculate opening balance plus receipts minus payments to get the closing balance, which becomes the next week's opening balance.

That is the whole model. A spreadsheet is fine.
Reading it
The number that matters is the lowest closing balance across the thirteen weeks, and the week it occurs.

If that low point is comfortably positive, you have time to think about growth. If it is thin, you know exactly which week is tight and you have weeks of notice to do something about it. If it is negative, you have found the problem early enough to act, which is the entire point.
The mistakes that make forecasts useless
Optimistic collection dates. The single most common error. If a client has paid at seventy days for a year, they will pay at seventy days again. Forecast the behaviour you observe, not the terms you agreed.

Forgetting VAT. For a business collecting VAT, the payment to the tax authority is often one of the largest single outflows, and it is money that passed through your account and was never yours. Treating collected VAT as available cash is how businesses find themselves short on a filing date.

Missing the annual items. Insurance renewals, the accountant's fee, the CFE, equipment replacement. They are predictable and they are routinely left out.

Building it once. A forecast that is not updated is a historical document. Ten minutes a week is enough.

Too much detail. A forecast with two hundred line items does not get maintained. Group your suppliers. Precision you cannot sustain is worse than approximation you can.
Where automation genuinely helps
The tedious part is not the arithmetic. It is gathering the inputs: what is in the bank, which invoices are outstanding, what is due to go out, what payroll costs next month.

That data already exists in your systems. It just sits in three or four different places. Pulling it together by hand is the reason forecasts stop being updated by week three.

Tools connected across banking, accounting and payroll can assemble it automatically. Mirage Cloud integrates with Qonto, Pennylane and PayFit, which covers the three sources most French small businesses need, and its finance agent is scoped to cash position, budgets and the kind of question you actually want answered, such as whether a hire in September is affordable given what is due in August.

Automation does not replace the judgement. Deciding whether a client will pay late, or whether to delay a purchase, is still yours. What it removes is the data gathering, which is the part that kills the habit.
Start smaller than you think
If thirteen weeks feels like too much, do four. Four weeks of visibility is enormously better than none, and once the habit exists, extending it is easy.

The forecast is not there to make you feel organised. It is there so that the worst week of your next quarter is a week you saw coming.

read more..