Cash Forecast
Receivables at their EXPECTED date, payables at the chosen one, payroll, tax and debt service. Versioned, because accuracy cannot be measured without keeping the forecasts that were wrong.
Where to find it
- Module: Accounting
- Group: Working Capital
- Section: Treasury
- Screen: Cash Forecast
Address in the console: /accounting/cash-forecasts
Read-only list · 14 columns · 2 actions
This list is read-only: its records are written by the work that produces them. A correction, where one is possible at all, is made where the record was created.
What the list shows
These are the columns of the list, in the order they are drawn. Any of them can be sorted on, filtered on, hidden, or exported.
| Column | Kind | Field name |
|---|---|---|
| Forecast | Code | forecast_no |
| As of | Date | as_of_date |
| Version | Number | version |
| Scenario | Status | scenario |
| Grain | Status | grain |
| Opening | Amount | opening_balance |
| In | Amount | total_inflow |
| Out | Amount | total_outflow |
| Closing | Amount | closing_balance |
| Low point | Amount | minimum_balance |
| Low on | Date | minimum_date |
| Shortfall | Yes or no | has_shortfall |
| Accuracy % | Number | measured_accuracy_pct |
| Status | Status | status |
What you can do here
Build a forecast primary
Asks for: Name From Horizon (days) Grain Scenario Extra collection delay (days) Extra payment delay (days)
The curve
The rules that apply here
Everything on this screen obeys the platform rules rather than rules of its own. The ones worth knowing before you use it:
- Narrowing a list — search, conditions, sort, totals, export and saved views.
- What may be changed — the five grounds a record may not be edited on.
- Companies and business units — what the switcher above this list is doing to it.