DecCF./ˈdɛk.ɛf/

Cash flow statements

Use CashflowStatement in the presentation editor to explain actual changes in cash. The widget reads the calculation's accounts, complete journal postings and observed balances. It never creates or changes transactions.

Direct and indirect methods

Existing CashflowStatement and CashflowStatement({method: "direct"}) calls keep the direct report: opening cash, booked cash movements by flow and closing cash. Choose method: "indirect" to start with profit or loss and explain the cash change through adjustments, working capital, investment and financing.

Paste this complete presentation into the presentation editor of an app that books balanced transactions:

The indirect report displays one column per observed period, an optional aggregate column and these standard groups, in order:

Group IDMeaning
resultIncome less expenses, before closing entries. Paid interest and tax remain here.
depreciationAdd-back of depreciation and amortisation; the noncash asset counterpart is removed from investment movements.
non-cashOther noncash balance adjustments and explicit disposal gain/loss reversals.
working-capitalReceivables, inventory, prepayments, trade payables and tax/payroll liabilities.
investingActual payments for or proceeds from fixed assets and investments.
financingLoans, repayments and owner equity contributions or withdrawals.
owner-transferTransfers crossing the selected owners' boundary, including direct cash transfers between owners.
unclassifiedMovements without sufficient standard classification; account and journal details remain visible.

A cumulative operating cash flow follows working capital. Opening cash, net cash flow, closing cash and reconciliation difference are always shown. A pure depreciation entry produces a negative result and an equal add-back, with zero cash flow. A noncash asset purchase funded directly by a loan does not invent cash investment or financing. Internal transfers between selected cash accounts cancel.

Company classifications use published account roles/tags and the company account plan's category hierarchy. Personal classifications use the personal plan's actual categories; company account numbers are never guessed from personal account names. An ambiguous mixed disposal stays unclassified with its source details. Known company disposal gain/loss categories preserve the result and explicitly reclassify the gain/loss into actual investment proceeds. Unknown classifications never disappear into a balancing amount.

Options and defaults

OptionSupported value and meaning
method"indirect" opts in. Omitted or "direct" preserves the direct method; other values fail.
titleDisplay text, or false to hide the heading.
owner, assetOne entity reference/exact owner ID, or an array. asset is an alias. Omitted means all owners. A local owner control can narrow this scope.
cashAccountsNonempty array of account references/exact IDs. Each must be an asset in the selected owner scope. Omitted uses existing cash roles, tags and categories. An explicit asset selection can define cash more narrowly or widely.
scenarioExisting scenario name, index, "scenario:0" identifier, an array of selectors, "active", or "all". Omitted selects the active scenario. Each selected scenario is reconciled separately.
period"months" or "years"; "monthly" and "yearly" are aliases. Omitted follows the surrounding period selection, normally months. Columns represent actual model periods, including quarterly/annual periods; yearly columns group their start dates.
yearA four-digit year as a string or number. Fixes the actual start year without inventing missing periods or falling back to another year.
yearPageZero-based page of up to ten observed years in yearly view; default 0.
controlsfalse hides the existing owner, grain and year controls. Otherwise they are available.
totalsfalse hides the extra aggregate column only. Reconciliation rows remain. Opening/closing aggregate values use the first/last observed balance; activity aggregates sum the displayed periods.
visibleExisting presentation visibility option. "auto" hides a selection with no observed periods. Observed zero cash flow remains valid, including depreciation-only results.
groupsOptional nonempty array of exact-coverage groups, described below. Omitted selects the standard eight groups.
rowsGroup IDs and interleaved summary objects. Omitted displays the groups in their declared order; the standard layout also inserts the operating subtotal.

Account/flow filters (accounts or flows on the widget) cannot be used for indirect reporting: dropping counterpart legs would invalidate the explanation. Use cashAccounts to define cash and groups to classify explanatory amounts. Choose owner scope on the widget or a surrounding AssetPanel, and periods/scenarios through the usual presentation containers. Reports use existing theme, mobile table scrolling and tabular export values.

Groups and exact coverage

Each group accepts:

  • id: unique nonempty stable ID; label: optional nonempty visible text, defaulting to the ID.
  • kinds: a nonempty array of the standard contribution kinds from the first table.
  • accounts: account references/exact IDs, and categories: exact category paths and their descendants. These inclusions form a union. If kinds are also present, the account/category selection intersects them.
  • excludeAccounts and excludeCategories: arrays removing exact accounts or category subtrees. Category personal.expenses.housing includes its descendants, but not personal.expenses.housing_extra.
  • details: true: display account rows with expandable journal sources. Otherwise only group amounts appear. Unclassified sources remain visible even if details are disabled.

A group needs kinds and/or account/category inclusions. Unknown account IDs/categories, duplicate IDs, unknown kinds and unsupported sign/movement overrides fail. Every nonzero explanatory contribution must match exactly one group; omissions and overlaps are errors, even if their final totals would cancel. A zero-net reclassification can have multiple traceable contributions from the same journal posting, each representing a different kind.

Custom order and interleaved summaries

This complete presentation uses exhaustive kinds, an explicit group summary and two cumulative summaries. It works with the same balanced app as the standard example:

Each base group appears once in rows. A summary has unique id and nonempty label, plus either add/subtract arrays of base group IDs or cumulative: true. Explicit references may select groups appearing later, but cannot select other summaries. A cumulative summary includes only the preceding base groups. Earlier summaries are never counted again. Unknown/duplicate references, missing/repeated group rows, duplicate summary IDs and combining cumulative with explicit references fail. Summaries display raw group sums; they do not change classification, cash balances or reconciliation.

Reconciliation and incomplete results

All monetary amounts use the calculation currency and debit/credit signs; there is no implicit currency conversion. Each touched journal cohort must balance, including counterparts outside a selected owner. Every selected account's postings must explain its actual opening-to-closing movement in each selected model period. Both sides of period-close entries are verified and excluded from explanatory activity. A closing entry that moves selected cash is invalid.

The first simulated period needs the authoritative graph.accounts[].opening_balance observation. An older saved result can use an actual preceding period-ending balance when the selection begins later. If neither exists, rerun the calculation; the report never infers an opening that could conceal missing postings. Missing balance observations, inconsistent dates/owners/types, incomplete or unbalanced journals and currency mismatches fail with a specific explanation. An imported closing snapshot alone does not explain the historical cash movements or a depreciation counterpart; use complete balanced historical bookings, or explicitly select a later forecast year with actual preceding balances. See Result format.

Reconciliation is closing cash minus opening cash minus explained net flow. The report checks a small floating-point tolerance scaled to the amounts (max(1, absolute amounts) × Number.EPSILON × 64), keeps raw values for tabular export and never adds a balancing plug. Display rounding does not change the accounting. Unclassified rows reconcile numerically but require the model author to review their visible source accounts and postings before assigning a more specific group.