Cash-flow forecasting

Cash Flow is part of Advanced Reporting. Open Cash Flow, choose one project or all projects and select the available forecast window. Review weekly inflow, outflow, estimated outflow, net and cumulative net, then inspect the source lists below the chart. This is a forecast of recorded obligations and estimates, not a live bank balance.

1. 01

   Choose the forecast scope

   Open Cash Flow from the sidebar and select a project or the available all-project view and forecast window.

2. 02

   Inspect the weeks and sources

   Find weeks with pressure on net cash and inspect their contributing items. Check expected dates against the current commercial position.

3. 03

   Correct source records and follow up

   Update an incorrect source through its own module and allow the forecast to refresh. Agree collection or payment follow-up with the responsible person.

Sources include approved payments, purchase orders, agreement milestones, payroll estimates and certified IPCs when their source features are available. An estimate badge means the amount is projected rather than a finalized payment. Missing payment terms, dates or linked records can affect timing and totals. Follow the source link and correct the source data rather than treating the chart as an editable budget.

If PKR 500,000 is expected next week but PKR 700,000 is due out, the week has a projected PKR 200,000 shortfall before any opening cash you hold outside this report. Check the largest source items and their confidence before changing payment arrangements. Review again after entering receipts, payments or updated due dates. The available CSV export reflects the selected forecast; it does not certify a bank reconciliation.

Receivables aging groups outstanding certified IPC amounts using the expected due date. The first bucket includes amounts not yet due and amounts up to 30 days overdue; “current” does not always mean nothing is late. Older balances fall into 31–60, 61–90 and over-90-day groups. Check the certificate before making a collection call.

The retention ledger accumulates retention from Paid IPCs. Its current calculation does not record retention releases, so the displayed held balance is not a complete settlement ledger. Keep an agreed release record separately and reconcile it with the source certificates. A partial receipt that moved an IPC to Paid can also remove it from certified-only receivables; see the IPC receipt limitation.

Forecast dates use recorded dates and company payment terms. Payroll estimates use recent recorded labour payments, so stale or missing pay records affect the estimate. Reports can take a few minutes to refresh after source changes.