Skip to content

Cash-flow forecast from Bank

Updated:

Fixed 13-week forecast with a customer-payment scenario.

Open Bank & payments in Fiatto
In this article

Under Bank & payments → Cashflow & forecast → Cash-flow forecast (/dashboard/bank/kasstroomprognose) sits a full 13-week forecast: debtor collections, direct debits, payment-plan instalments, work in progress and open care claims in; creditors, payment batches, lease, payroll, VAT remittance and open purchase orders out.

Steps

  1. Open Cash-flow forecast.
  2. Pick the Scenario for customer payment behaviour: On time or Prudent (+14d).
  3. Read the KPIs Opening cash, Net 13 weeks and First shortfall, plus the breakdown per week and category.
  4. Steer via payment advice and the payment calendar.

Tips

  • Export CSV beside the scenario choice downloads the weekly table for your own planning.
  • Work in progress (orders, subscriptions, milestones, rentals; excl. VAT) is work that is already agreed but not yet invoiced: the remainder of open sales orders on the expected delivery date, the coming periods of active subscriptions, planned project milestones and rentals without a rental invoice on their end date. The expected receipt is that invoice date plus the customer's payment term, with the same scenario shift as for debtors. Below the weekly table you see the split across the four sources; work in another currency and project milestones without a date are not included. Work in progress requires approver rights.
  • A planned project milestone counts at the milestone amount minus the advance offset, as the milestone invoice bills it; the advance itself comes in through its own invoice. A milestone that is fully offset drops out.
  • With the Care receivables module, open care claims appear in the forecast as Care funders (municipality, care office, insurer): on the submission date plus the funder's payment term (30 days by default), capped by what is still receivable under the production ceiling after payments and the advance. The forecast mentions the part above that separately.
  • The horizon is fixed at 13 weeks across the whole company — there is no horizon, entity or account choice. Forecast ≠ posting.
  • Bank & payments → Cashflow & forecast → Cash flow (Balance & cash flow, /dashboard/bank/kasstroom) shows the current Balance per account and a short six-week outlook: released, not yet reconciled batches on their execution date plus open invoices on their due date. It also shows the Liquidity warning for accounts that fall below their Minimum buffer (alert) now or after scheduled payments; you set that buffer per account on the Bank & payments start page.
  • Realised figures per period are in Accounting → General ledger → Review & reporting → Statements.
  • Deposits and loans affect the financing column — see treasury. Approved dividend distributions that have not been paid yet also count as an outflow.
  • Below the weekly table sit Forecast quality (bias and mean deviation from earlier weekly snapshots) and Months from the plan — up to 18 months ahead, based on the forecast or the adopted budget in Planning & control. The three-statement forecast reconciles its cash with this horizon month by month.
  • Further down the page: With open proposals (what carrying out open proposals from Actions does to cash), External signals in this forecast (effect of interest-rate and commodity movements, not included in the balance), Revenue and cash flow forecast (per month from your own history), What is already in the pipeline (orders, quotes and opportunities weighted by win rate) and Forecast versus actuals by category.
  • If you click through on a week in the CFO cockpit, the forecast opens with Week of …: the expected receipts and payments per category, each linking to the open items behind it.
Was this article helpful?
View all articles in this topic

Find another answer

A task, feature or short question is enough.