Cash flow forecasting in Sage X3 — how to keep your forecast up to date

A profitable month can still leave a business short of cash. A customer pays a week late, but payroll and supplier payments are due on the original dates. The sales figure may be unchanged, yet the business has less money available when it needs it.

An up-to-date cash flow forecast gives finance time to act. It shows when receipts and payments are expected, which assumptions matter most and when the balance could fall below the level the business needs. Sage X3 can provide much of the underlying information from the orders, invoices and bank records teams already use.

Separate today’s cash, historical reporting and the forecast

These three views answer different questions. The current bank position tells you where you start. Historical reporting explains what actually came in and went out. The forecast estimates what is likely to happen next. A forecast is most useful when it starts from a reconciled position and uses the latest information about when money will move.

For example, a £45,000 invoice due on Friday is not the same as £45,000 in the bank. If the customer confirms they will pay the following week, update the expected receipt in the forecast and retain the original due date for credit control. The two dates serve different purposes.

Build the forecast from Sage X3 transactions

Sage X3’s Cash Forecast Generation function uses eligible outstanding invoice balances, known in X3 as open items, and can include selected documents that have yet to be invoiced. Eligible sales orders and deliveries can contribute expected receipts; eligible purchase orders and receipts can contribute expected payments. The documents included depend on the company and site setup, selection criteria and the status of the underlying records.

This gives finance a view beyond the sales and purchase ledgers. For example, a confirmed purchase order for stock arriving next month can affect the cash plan before the supplier invoice arrives. The forecast estimates the date and value from the source document and relevant payment terms. Check the result against when the business actually expects to pay.

Choose the forecast sources deliberately. An accepted order and an unconfirmed quote carry different levels of certainty. Consider keeping speculative receipts outside the working forecast, or showing them separately in a scenario that management can review.

Add the payments the order book cannot show

Cash Forecast Management lets finance review generated entries and add manual forecasts for amounts not already represented by X3 documents. These can include payroll, rent, tax instalments or loan repayments. Regular items can be set up as recurring forecasts.

Review these entries as actual invoices and payments appear. For example, a manual estimate for an annual insurance premium should not remain in the forecast alongside the supplier invoice for the same payment. Also review manual overrides: Sage documents that a forecast with Modified status is protected from replacement during regeneration, so a fresh run does not necessarily replace an old assumption.

Report on the position and use it to manage cash

Use bank statement reconciliation to match imported statement lines to X3 bank entries and investigate differences. Agree which accounts and balances are in scope and the cut-off for each forecast run.

The Banking Position inquiry shows an opening balance, open items and forecasts over a chosen period for a bank or bank group. The List of Cash Forecasts report helps explain the entries behind those totals, and the Business Partner Cash Forecast report brings together actual and forecast open items for business-partner analysis.

For a management pack, show the opening position, receipts, payments, closing balance and lowest projected balance. Highlight the transactions that changed since the last review. For groups, check each company’s cash separately as well as the group view: cash held in one company may not be immediately available to another. Align currency assumptions and make sure intercompany flows are handled consistently in any combined report.

Use the exceptions to focus the week’s work. Credit control can follow up a major overdue receipt, while accounts payable can compare the upcoming payment run with the forecast. X3’s Payment Proposals can help select and review open items for payment under the business’s normal approvals.

Worked example: one late receipt changes the week

Imagine the business starts the week with £70,000 in available cash, expects £55,000 in receipts and has £85,000 in payments due. The week is forecast to close with £40,000. Then the largest customer moves a £45,000 receipt into the following week.

The updated forecast shows the gap while there is still time to confirm the receipt date, review planned spending and discuss options. The £45,000 is moved to the following week, not counted in both. Look at the dates within each week too: the balance can dip before Friday even when the weekly closing position is positive.

Keep the forecast useful after go-live

Start with a rolling weekly view, such as the next 13 weeks, and use daily detail where timing is tight. Assign owners for bank reconciliation, customer payment updates and manual commitments. Refresh the forecast on a regular schedule and after material changes, and compare each period’s forecast with what actually happened. Record whether the variance came from timing, amount or something missing altogether.

Sage documents FUNTRTCFO as a batch task for cash forecast generation. Once the rules are proven, the team can schedule a refresh and arrange for reporting to follow a successful run. See our guide to scheduled processing and report emails in Sage X3. Schedule the refresh after the source data is ready and keep a review step for exceptions.

The goal is a forecast the finance team can explain and use. Start with cash you can reconcile, make the major assumptions visible, and update them when the business learns something new. Discuss Sage X3 cash flow forecasting with Impress Solutions.