Why Firms Struggle to Forecast Near-Term Cash

Many large companies continue to struggle to forecast near-term cash because corporate treasury teams lack a consolidated, normalized view of payables and receivables held across multiple ERP systems, currencies and legal entities. Accounting records contain invoice amounts, counterparties, currencies and due dates, but fragmentation prevents a single reconciled feed and forces treasuries to rely on spreadsheet extracts, emails and manual aggregation.

Multinational groups often run several ERPs, subsidiaries use different accounting platforms and acquired businesses can remain on legacy systems. Accounts Payable and Accounts Receivable therefore sit in different places with inconsistent representations of currencies, entities, suppliers and payment dates.

Due dates recorded in accounting do not always match settlement dates at banks. Suppliers may be paid on scheduled runs that differ from invoice dates, customers may pay early or late, disputes can delay receipts, and payments may be split or combined. Treasury requires likely settlement dates to manage liquidity and foreign-exchange exposure.

One practical measure is to assemble payables and receivables already recorded in accounting systems and normalise them by expected date, currency, bank and entity. Consolidating known invoices and payment instructions can provide a clearer view of expected cash flows without replacing ERPs or Treasury Management Systems.

For example, over a two-week horizon an organisation might expect £8 million of sterling receipts, €5 million of euro payments, $4 million of dollar receipts and CHF 1 million of supplier outflows. Presented together by date, currency and bank, those items show where funding or hedges may be required.

Comparing consolidated expectations with actual bank activity lets treasury teams identify patterns. The organisation can track which customers consistently pay late, which entities run supplier payment runs on fixed days and how behaviour varies by currency or invoice size. Expected settlement dates can be refined as bank evidence accumulates.

Information earlier in the commercial process — orders, contracts, sales opportunities and procurement commitments — can provide earlier signals of future cash events but carries greater uncertainty than recorded payables and receivables. A staged approach uses records closest to cash first, then adds upstream signals where they improve forecasting accuracy.

Greater visibility of near-term cash movements enables treasury teams to update forecasts as invoices are issued, delivery notes are posted, disputes are lodged or payments arrive. That view supports decisions on intragroup funding, external borrowing and foreign-exchange positioning.