Summarise scenarios
The scenarios screen’s Summary tab: per month, the cash flow’s final balance beside each
scenario’s. Give period, or both from and to, or neither for the tab’s own window,
this month and the twelve after it.
The window widens to whole months. cash_flow_final_balance is the cash flow’s final
balance as the cash flow screen shows it, projected for months that end after today.
A scenario’s final_balance is its starting balance plus its net result, as its own
tab shows it, and is null in months outside the scenario’s. The cash flow’s final
balance also carries opened accounts, transfers and excluded movements, so a scenario’s
final balance can differ from it even in months the scenario does not change.
With interval=total there is one row, with the balances at the end of the window.
Amounts are in the workspace currency and are never converted.
The cash flow and every scenario, month by month, for the next year
Authorizations
Query Parameters
A named window, resolved against the workspace's local day and echoed in the response. Takes precedence over from and to.
A named window resolved on the server. last_30_days and last_90_days end today and include it; last_12_months starts the day after today minus twelve months. next_month, next_quarter and next_year cover the whole next calendar month, quarter or year.
this_month, last_month, this_quarter, last_quarter, this_year, last_year, month_to_date, quarter_to_date, year_to_date, last_30_days, last_90_days, last_12_months, next_month, next_quarter, next_year The period rows are grouped into. month for each calendar month, total for the whole window as one period.
A period bucket for budget and scenario rows, which are monthly. total reports the whole window as one period, as the budgets screen's Total column does.
month, total