Browse the documentation

Concepts

Scenarios and actuals

Branches let a model hold a base plan, what-if scenarios and imported actuals side by side, with budget versus actual and a real-to-forecast cutover.

A model has one base plan and any number of branches. A branch stores only what differs from the base, so the model reads as base + branch: change an assumption in the base and every scenario that does not override it follows.

Scenarios

A scenario branch (Upside, Downside, Delayed hire, Fundraise in Q3) overrides input cells. Switching branches in the app, or passing a branch_id to the API and the MCP tools, reads the model under that scenario. Structural changes (a new line, a new formula) are always model-wide: a scenario varies numbers, not logic.

A formula can compare branches directly: Revenue - LAYER(Revenue, Budget). A KPI, a chart or a mini-table can show a line under several branches side by side.

Actuals

Actuals are real figures brought in from a source (a ledger export, a bank feed, an accounting tool). They land on a branch, usually through mapping rules (see Sources and mapping), and can override computed lines too: an actual revenue figure replaces the forecast for that month and feeds everything downstream.

The cutover

actuals_through is the last closed period. Up to it, the model shows actuals; after it, forecast. It follows each import (a new closed month moves it forward), can be pinned on the model or per branch, and is readable in formulas:

Revenue = IF(IS_ACTUAL, Booked revenue, Pipeline * Conversion)

Budget versus actual

With a budget on the base and actuals on a branch, variance needs no extra line: a KPI or a mini-table compares the two branches at a period, with the gap in value and in percent, and a bridge chart decomposes the difference line by line. Year to date (period_mode: "ytd") sums flows from January and recomputes ratios on the cumulated figures.

Reading a branch

Without a branch, reads and writes are the base plan. With a branch, values come back as the branch view, and the difference to the base is available alongside. Deleting a branch removes its cells and the sources that fed only that branch.