DecCF./ˈdɛk.ɛf/

Choose metrics and build custom financial statements

The presentation editor determines which results are visible. All calculated metrics and time series remain in the calculation result and export even when the presentation shows only a few.

Cards appear in the order of the list. metrics: [] displays no cards. Without a selection, MetricCards displays all published metrics. Use MetricsTable on a separate detail tab when all metrics should be available for review.

Select a specific year

This displays only the selected year's postings. If the year is missing, no observations are displayed; the report does not switch to another year. Without an explicit year selection, the ordinary income statement keeps its period overview.

Account groups and summaries

Use groups to choose which accounts to show, their order, and each group's heading. categories selects an entire account category and its descendants. For example, personal.expenses.housing also includes personal.expenses.housing.rent, but not another category that merely starts with the same letters. accounts selects exact account references or exported account identifiers. If both are supplied, their selections are combined without duplicates within the group. excludeCategories and excludeAccounts remove items from the selection.

id is used when summary rows select groups. summaries adds the groups listed in add and subtracts those in subtract. The same account can intentionally appear in different groups; choose summary groups so the same amount is not counted more than once.

groupBy: "category" combines accounts in the same category, such as several people's salaries, on one row. Otherwise, each account is displayed separately. details: false displays only the group subtotal. subtotal can be a custom heading, true, or false. emphasis: "result" highlights a summary row and distinguishes positive from negative results; "subtotal" uses a simpler subtotal style.

The report reads the year's posted movements, with credits as positive and debits as negative. Income is therefore positive and expenses negative. Closing transfers and opening balances are not counted as new income or payments. movement: "debit" or "credit" selects only that side; sign: -1 reverses the sign. To show loan repayments, a group can select the debt account with movement: "debit", sign: -1. New loan drawdowns are then not counted as principal repayment. A payment statement like this has a different meaning from a pure income statement: principal repayment is a payment that reduces debt.

A column can select a person or business with owner. A column without its own owner selection shows the combined selection. monthlyAverage divides the selected periods' total by the number of months those periods represent, including periods without payments. A monthly period represents one month, a quarterly period three months, and an annual period twelve months. For example, the combined amount from two quarterly periods is divided by six. Daily and weekly periods use the fraction of days covered in each calendar month. The report shows the denominator; fractional denominators are rounded for display and marked as approximate. The calculation uses the unrounded denominator. The average does not describe an actual payment in any particular month.

Year selection follows the engine's period start: all postings in a period belong to the year in which that period begins. An annual period starting in July 2027 therefore belongs to the 2027 selection and its total is divided by twelve. It is not split between calendar years 2027 and 2028. Read such a selection as periods starting in 2027, not as an exact total of payments from January through December. A year with no period start has no observations even if an earlier period extends into that year. Use a sufficiently fine timeline when the report needs to follow payment dates within periods.

One column per person or business

Use owners when the list should contain one column per actual person or business in each scenario. The column heading uses the current name; if a name is missing, it uses label followed by a number. A reference missing from the scenario has no column. An empty list creates no owner columns. A column without an owner selection can still show the total. owner: [personA, personB] keeps its previous meaning: one combined column for both. Do not set owner and owners in the same column or repeat the same owner with the same aggregation.

Here, people.outputs.person contains the person references from a repeated model component. The presentation selects the references present in each calculated scenario, even when the list length or names have changed.

One statement per report group

With reportGroups: {prefix: "homes."}, one group template becomes a separate group for each published report group whose identifier starts with homes.. Each heading shows the report group's name. Choose a prefix that the model actually publishes; there are no predefined names for people, homes, or other assets.

The selected categories and accounts are limited to the exact accounts in each report group. Two homes with the same account categories therefore have separate values. Without categories or accounts, all accounts in the report group are selected. Exclusions with excludeCategories and excludeAccounts still apply. A summary that names the template's id adds all of its expanded groups. If the prefix matches nothing, the template adds no values; an account selection with no posted movements is not treated as observed data.

Different aggregations on different rows

A group or summary row can set aggregation: "sum" or "monthlyAverage". The row's selection applies to all its columns and takes precedence over a column's setting. Without a row setting, the column's aggregation is used. A summary always combines the groups' original period amounts and then applies its own aggregation once. A group displayed by month therefore does not change the amount in a yearly summary.

When rows use different units, each amount cell shows its unit, such as SEK/year or SEK/month. Column headings then show the currency. The monthly average uses the same calendar duration and exact year selection described above, even when set on a group or summary row.

Compare before and after

You can declare two scenario suggestions in the model as described in the scenario guide, using the names referenced by the presentation. Then run both scenarios. One scenario should contain the assumptions before the change and the other those after. The same groups, columns, and year can be inherited from a surrounding panel:

The reports use the actual calculation for each scenario. They do not change inputs or create comparison scenarios themselves. On wide screens they appear side by side; on narrower screens they stack vertically.

Rows from published amount allocations

A group can use a published calculation with one amount per person and a total. This is useful, for example, for an analytical allocation of a shared payment while the actual debt and payment are still posted once.

source.values selects a published calculation, a list, or a keyed collection of such calculations. The calculation's amounts is a keyed Money allocation and total is its authoritative Money total. Select different field names with amountsPath and totalPath. source.owners maps the allocation keys to actual people. When it is a repeated component, ownerPath selects its person output; a direct keyed map of person references needs no such path.

Amounts are summed for the exact selected year and converted once to the column or row unit. Summaries can combine ordinary account groups and these calculation groups. Zero is observed; missing observations display a dash. Recipient amounts must preserve the total and use the report currency. An analytical allocation of principal repayment creates no expense or extra posting.

Indirect cash flow

Use CashflowStatement({method: "indirect"}) for a reconciled explanation of cash changes. The complete cash flow reference documents the standard layout, account selectors, exact-coverage groups and interleaved summaries with complete presentation-editor examples. Existing direct statements keep their behavior.