Why cash flow catches businesses out

Ask most finance managers how healthy their business is and they will point to the profit and loss account. Ask them what their cash position will look like in six weeks and the answer is often a shrug, or a spreadsheet that was last updated on a Friday afternoon three weeks ago.

That gap matters. A profitable business can still run out of money if customers pay late, suppliers demand payment on delivery, or a large order lands at the wrong moment in the payment cycle. Cash flow is simply cash receipts minus cash payments over a period, but getting a reliable forward view of it is where most small and mid-sized businesses fall down.

Dynamics 365 Business Central, Microsoft's cloud ERP for growing businesses, includes a cash flow forecast feature built specifically to close that gap. Rather than asking someone to build a forecast from memory and a handful of reports, it pulls directly from the records already in the system.

How cash flow forecasting works inside Business Central

A cash flow forecast in Business Central is built from several live sources of data, not a single static report:

• Sales orders. Open sales orders tell the system what money is expected to come in, and roughly when, based on agreed payment terms.
• Purchase orders. Outstanding purchase orders show committed spend that has not yet left the bank account, so upcoming supplier payments are visible ahead of time.
• Outstanding invoices. Unpaid sales and purchase invoices feed in as receivables and payables, each carrying its own due date.
• General ledger and bank balances. Current liquid funds and budgeted revenue and expenses give the forecast its starting point.
• Manual entries. Anything not yet reflected in a posted transaction, such as a planned loan repayment or an expected grant, can be added by hand so the forecast reflects reality rather than just what has been keyed into the ledger.

Business Central then combines these sources on a rolling basis, using each customer or supplier's actual payment behaviour (not just their stated terms) to work out when money is genuinely likely to move. The result is a week-by-week or period-by-period projection of cash position, viewable as a chart or worksheet, that updates automatically as new orders, invoices and payments are posted. For businesses that want the forecast to extend further into the future than open orders alone allow, Business Central can also apply Azure AI to project trends from historic transaction data.

This is the core distinction worth understanding: a cash flow forecast in Business Central is not a document somebody produces once a month. It is a live projection that moves in step with the business.

Why manual spreadsheet forecasting goes stale fast

Spreadsheets are not the problem in themselves. The problem is what happens the moment they are finished.

A typical cash flow spreadsheet is built by exporting figures from the accounting system, copying in outstanding invoices, guessing at a few upcoming purchase orders, and applying some assumptions about when customers will actually pay. That process might take half a day. By the time it is circulated, new orders have been raised, a customer has paid early, another has paid late, and a supplier invoice has landed that nobody had accounted for. The forecast is out of date before anyone has acted on it.

Three problems tend to recur with spreadsheet-based forecasting:

1. No live link to source data. The numbers are a snapshot, manually re-created each time, rather than a live pull from sales orders, purchase orders and invoices.
2. Assumptions replace behaviour. Spreadsheets typically use stated payment terms rather than how customers and suppliers actually pay, which quietly skews the projection.
3. It relies on one person's time. When forecasting depends on someone manually rebuilding a model, it gets deprioritised the moment that person is busy with something else, which is usually exactly when cash pressure is building.

None of this is a criticism of the people doing the work. It is simply what happens when a forecast is disconnected from the transactional system generating the numbers.

How automated forecasting improves accuracy

Because Business Central's forecast draws directly from live sales orders, purchase orders, invoices and ledger entries, it removes the manual re-entry step that introduces both delay and error. Every time an order is raised, an invoice is posted, or a payment is recorded, the underlying data the forecast relies on is already current.

Accuracy also improves because the forecast can use actual payment behaviour rather than assumed terms. If a particular customer consistently pays ten days late, or a supplier is reliably paid early to secure a discount, that pattern feeds into when the forecast expects the cash to actually move, not just when the invoice says it is due.

The practical benefit is time as much as accuracy. Finance teams stop spending hours rebuilding a model from scratch and instead spend that time interpreting what the forecast is showing, which is a far better use of a finance manager's judgement.

A worked example: spotting a cash gap early

Picture a distribution business with steady monthly revenue but a lumpy purchasing pattern, because stock has to be bought in bulk ahead of a busy season.

In week one, the business places a large purchase order to restock ahead of its peak period. On its own, that order would not raise any alarm. But Business Central's forecast also shows two of the business's largest customers have open sales orders with payment terms that push their receipts into the following month, and a VAT payment is due in the same window as the supplier payment.

Viewed separately in an accounting system, none of these three items looks urgent. Viewed together in the cash flow forecast, a five-week window emerges where outgoing payments clearly outpace incoming receipts, weeks before the actual shortfall would hit the bank account.

With that early warning, the business has options it would not have had with a month-end spreadsheet: negotiate a short extension with the supplier, chase early payment from one of the two customers, or draw down a portion of an existing credit facility on its own terms rather than under pressure. The point is not that the gap disappears. It is that the business gets to choose how to handle it, instead of discovering the problem when a payment fails.

That is the practical value of a live forecast over a periodic one: it turns a crisis that would otherwise surface in the bank account into a planning decision made weeks in advance.

Who this matters most for

Cash flow forecasting has the biggest impact for businesses with irregular payment cycles: those that buy stock in bulk ahead of demand, invoice on long payment terms, or work across multiple currencies where exchange movements add another layer of uncertainty. If your business raises sales orders and purchase orders regularly, that data already exists in Business Central. The forecast simply puts it to work, rather than asking someone to reconstruct it from scratch every month.

It is also worth being clear about what a cash flow forecast is not. It is not a replacement for budgeting, and it will not tell you why a customer is paying late or whether a supplier relationship needs renegotiating. What it does is give you visibility early enough to ask those questions on your own timeline, rather than being forced into a reactive conversation once cash is already tight.

Getting cash flow forecasting working for your business

Cash flow forecasting in Business Central is only as useful as its setup. Getting the chart of cash flow accounts, payment terms and forecast sources configured correctly is what determines whether the forecast reflects your business accurately from day one.

If your team is still rebuilding cash flow forecasts by hand each month, it is worth finding out what your existing Business Central system can already do. Get in touch with Creative Computing to talk through setting up cash flow forecasting in your Business Central system, and start working from a forward view of your cash position instead of a rear-view one.