How the summary cards add up

How the summary cards add up

The three money cards at the top of the dashboardPipeline, Collections, Planned — measure three things that never overlap: work you haven’t won yet, money that has arrived, and money you expect to collect. Because they don’t overlap, they also add up, which is what lets All Spaces equal the sum of the spaces it summarizes.

This page spells out the rules behind each card, for every business type, with a worked example you can check against your own numbers.

The card labels change with your business type — a services space says Total Pipeline where a SaaS space says Open Pipeline — but the maths behind them does not. One rule, four vocabularies. The label table lives in the Business-type terminology matrix.

The three rules

Card Counts Ignores
Pipeline Records on a stage whose category is active or at risk Won, lost and inactive records; anything on an excluded stage
Collections Collections marked Paid, dated in the card’s year Pending and overdue rows; refunds (negative amounts)
Planned Collection plan rows for the card’s year, on a collectible stage category Plans on excluded stages, and on stage categories you haven’t marked collectible

“At risk” belongs in pipeline: a wobbling proposal is still an open proposal. Only won moves out of pipeline and into the Planned / Collections side of the picture.

Which amount gets counted

Pipeline follows the dashboard’s year selector, and how it reads an amount depends on what you picked:

Year selector What each record contributes
A specific year (or a year combination) That record’s collection-plan rows for that year. A record with no plans at all falls back to its full amount, placed in its close-date year. A record with neither plans nor a close date has no year to belong to and stays out.
All Years Every open record’s full amount, once.

This is what keeps a three-year subscription from landing entirely on one year, and it is why a large deal can be worth 120.000 € in All Years but nothing in 2026 — it closes in 2027.

Collections and Planned always read the single year printed on the card itself. A year selection moves them with it; All Years and two-year combinations don’t — those cards keep the last single year they were set to, and their labels always name it. When a figure looks off, read the label first.

A worked example

Meet Northwind Studio, a fictional organization with four spaces — one of each business type. All figures below are invented and rounded for readability.

Advisory — services

Stages: Lead (active), Proposal (active), Negotiation (at risk), Won (won), Lost (lost).

Record Stage Amount Plans Close date
Harbour migration Proposal 120.000 € 2027-03-01
Kestrel rollout Negotiation 60.000 € 2026-09-30
Lantern audit Lead 90.000 € 2026: 30.000 € · 2027: 60.000 € 2026-12-01
Beacon retainer Won 200.000 € 2026: 200.000 € 2026-02-01

Storefront — e-commerce

Stages: Inquiry (active), Quote Sent (active), Paused (at risk), Order Placed (won), Cancelled (inactive).

Record Stage Amount Close date
Linen shirt Quote Sent 18.000 € 2026-06-01
Wool scarf Paused 12.000 € 2026-11-01
Ceramic mug Paused 40.000 € 2026-08-15
Canvas tote Order Placed 50.000 € 2026-03-01

Templates — digital products

Stages: Idea (active), Beta (active), Launched (won), Retired (inactive).

Record Stage Amount
Pitch deck kit Beta 8.000 €
Invoice pack Launched 25.000 € (planned for 2026)
Old landing kit Retired 5.000 €

Subscriptions — SaaS

Stages: Lead (active), Trial (active), Negotiation (active), Active (won), Churned (lost).

Here the record’s amount is the whole multi-year contract, so the plan rows are what describe a single year.

Account Stage Contract 2026 2027 2028
Meridian Corp Trial 180.000 € 60.000 € 60.000 € 60.000 €
Foxglove Ltd Negotiation 90.000 € 30.000 € 30.000 € 30.000 €
Aster Group Active 240.000 € 80.000 € 80.000 € 80.000 €

The two SaaS cards are complements: 90.000 € of business still to win, 80.000 € already recurring.

All Spaces is the sum

With the four spaces above, and the current year selected:

Space Pipeline Planned
Advisory 90.000 € 200.000 €
Storefront 70.000 € 50.000 €
Templates 8.000 € 25.000 €
Subscriptions 90.000 € 80.000 €
All Spaces 258.000 € 355.000 €

Switch the selector to All Years and the pipeline column becomes 270.000 + 70.000 + 8.000 + 270.000 = 618.000 €. The rule doesn’t change; only the amounts each record contributes do.

If your All Spaces figure doesn’t match the spaces underneath it, the usual causes are a Stage or Unit filter left on something other than ALL, or a currency conversion — mixed-currency records are converted at the closest available rate per record, so a converted total won’t equal a naive sum. See Multi-currency.

The same stage name can mean two things

Stages belong to a space, so two spaces can use one name for different things. In the example above, Advisory treats Paused as inactive — work that has gone quiet — while Storefront treats Paused as at risk, a live order waiting on stock.

A combined view has to answer “is this record open?” for both. It answers it per record, using that record’s own space, which is why Storefront’s 40.000 € Ceramic mug counts in All Spaces exactly as it counts in Storefront. Judged by Advisory’s meaning of the word it would have silently vanished, and All Spaces would have read 218.000 € against four space cards summing to 258.000 €.

Nothing is required of you here — it just works. But it’s worth knowing when you name stages: the name is yours to reuse, and each space keeps its own meaning.

What decides “excluded” and “collectible”

Two organization settings shape these cards. Both live in Settings → General → Data Labels (Custom labels & terminology).

Setting Written as Effect
Excluded stages Stage names Records on these stages are dropped from pipeline and planned figures, in every space and in All Spaces.
Collection stages Stage categories Which categories count as collectible. Revenue Active by default.

Collection stages is expressed in categories rather than names on purpose: the setting belongs to the organization, while stage names belong to one space. A name list could only ever be a pile of every space’s vocabulary applied to all of them — which is how one organization ended up marking every active-category record collectible because a single space happened to have a stage called “Active”.

Clearing the setting entirely is read as “no opinion” and leaves your plans untouched, rather than zeroing the forecast.

The other two cards


Prev: The dashboard Next: Reports Up: User guide index