CashForecast

Object

sources

Signed source amounts after applying the forecast's existing settlement and currency rules.

workspaceId

asOf

The day the forecast is struck: every open document, both subledger controls and the books balance below are read as of it. Not startDate, which is the Monday week 1 opens on — the days between the two are this week's movement, and reading a figure at one date against a figure at the other double-counts everything that moved in them.

startDate

Start of week 1 — the Monday of the week asOf falls in.

endDate

buckets

band

Contracted, not-yet-invoiced inflow across the thirteen-week window.

history

Thirteen calendar weeks of cash balance history per the general ledger, when readable.

booksBalance

Cash per books as of asOf: every posted cash-account line dated on or before that day, this week's movement included and later-dated postings excluded. The position a projection opens from when no bank balance is usable, and null where the ledger holds no readable cash balance. Not the last history point, which closes on the previous Sunday: a payment posted since then has already left both the open bills and this figure, and anchoring on the older one would take it off the bills while still counting its cash.

openingCash

The position the projection actually opens from: cash per books, with every cash GL account whose bank balance is fresh anchored on that balance instead. Equal to booksBalance wherever no bank balance leads, and null with it — a bank total alone would state the workspace's cash as the balance of however many accounts happen to be mapped.

bankCash

What the bank says the workspace's mapped cash GL accounts hold, beside what the books say — null where no connection running the balances-and-pending scope maps a balance-reporting account to a cash GL account.

months

Calendar-month forecast buckets following the thirteen-week window.

minimumCash

Workspace minimum-cash floor. Null means no floor has been configured.

overdue

Arrears ahead of week 1, or null where the workspace is current on both sides. The weekly buckets carry scheduled flows only, so a reader ignoring this field sees a forecast that understates both what is owed and what is owing.

nettingBlockedRowCount

Open-document rows the A/R and A/P control netting could not read exactly. A non-zero count means invoice inflows or bill outflows may be overstated.

outflowBasis

Expected-out contributions for overdue items plus the next thirteen weekly buckets.

postedThrough

The last day cash was posted to the ledger on or before the forecast start, or null where no cash account holds a posted line. The books the projection opens from reach this far and no further.