How the numbers work
A pipeline figure is only useful if the next screen agrees with it. These are the rules every total in the product follows.
Every figure is worked out from the deals themselves
Open deals per account, pipeline value, win probability and the forecast are not stored anywhere. They are calculated from the deals each time you look. So when a deal moves stage, the account, the board and the forecast all change together, because there is no second copy of the number to fall out of step.
Overdue deals get their own row
An open deal whose expected close date has passed is shown as overdue, separately — not folded into this month, where it would flatter the forecast, and not left in a past month that has scrolled out of view.
Deals with no close date are counted, not dropped
Open deals without a close date appear in their own “No close date” row. A forecast that quietly leaves them out improves every time someone forgets to fill in a field.
Won and lost deals count in the month they closed
Attainment is a question about what happened, so a closed deal is counted in the month it was actually won or lost, not the month it was expected to close.
Win probability is weighted by value
Each stage carries a probability. An account's win probability is the value-weighted average across its open deals, so a large deal at an early stage pulls the figure more than a small one at a late stage. A plain average would treat a $500 deal and a $50,000 deal as equally important.
Money is exact
Amounts are stored as whole cents, never as floating-point numbers, and imported values such as $100.25 stay $100.25 through every edit, total and export. Amounts are in US dollars.
Slipping deals are visible
Every change to a deal's stage and close date is recorded by the database and cannot be edited afterwards. So the weekly review can show which deals have been postponed and how many times, and the answer to “who moved this date, and when” is always there.