Forecast Cash Flow
forecast_cash_flowCash flow forecast weighted by invoice age. Weighs what each open invoice still owes by its age (current 100%, overdue under 30 days 90%, under 60 days 50%, 60 days or more 25%), adds the value of all unbilled billable time to date, approved or not (not hours a retainer fee covers), and adds sent or accepted proposals not yet invoiced. Also totals what open invoices still owe, unweighted. Money is in currency units. Unbilled time here is all unbilled billable time to date, approved or not, valued as expected cash; it is not WIP for one period. Proposals appear only as expected cash, not as offers or sales opportunities. Answers questions like "what cash can we expect?", "what is outstanding?", "how much unbilled time do we have in total?" or "forecast our receivables".
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| asOf | No | ||
| totals | No | ||
| unavailable | No | Parts that could not be read just now, so the totals leave them out | |
| unbilledTime | No | ||
| proposalCount | No | Every proposal counted in the totals; the list holds the 25 most recent | |
| otherCurrencies | No | Receivables and pipeline in other currencies, summed apart, never in the totals | |
| proposalPipeline | No | ||
| receivablesCount | No | Every open invoice counted in the totals; the list holds the 25 oldest | |
| invoiceReceivables | No |