How should forecast models handle multi-year deals that straddle revenue recognition boundaries?

Question

Pulse RevOps · The Machine · Accepted Answer

## Multi-Year Deal Forecasting **Direct:** Count only **current-year revenue** in quarterly forecast (GAAP ARR slice). Report **TCV** separately as "book value." Multi-year deals create false forecast inflation if not sliced by period. ### Operator Detail A 3-year $300K deal doesn't close as $300K revenue this quarter. Forecasting fiction dies when you separate TCV (Total Contract Value) from actual quarterly cash and revenue. **The three deal value layers:** **Total Contract Value (TCV):** - What: Full dollar amount customer will pay over entire contract - Example: 3-year at $100K/year = $300K TCV - Use: Board celebrates "$300K booked" (marketing speak) - Forecast impact: **Zero** on quarterly revenue forecast **Annual Recurring Revenue (ARR):** - What: Normalized to 12-month basis (even if contract is 2 or 3 years) - Example: Same $300K 3-year deal = $100K ARR - Use: Executive reporting, valuation metrics - Forecast impact: **Counts in quarterly forecast** as ($100K ÷ 4 quarters = $25K per quarter) **Current-Quarter Revenue (Cash Close):** - What: Actual revenue recognized in current quarter under ASC 606 (GAAP) - Example: If deal starts April 1, April-June = $25K recognized (Q2) - Use: **Only number that hits quarterly forecast and revenue board line** - Forecast impact: This is the only number that matters for close forecast ### Multi-Year Deal Mechanics **3-year deal, $100K/year (signed mid-quarter):** | Item | Value | Forecast Use | |------|-------|----------| | TCV | $300K | Not forecast (book separately) | | ARR | $100K | For ARR report; shows annualized | | Q2 Revenue (mid-q start) | ~$12.5K | This counts in Q2 forecast | | Q3-Q4, following year | $25K each | Next quarter forecasts | ### Forecast Clean-Up Rule When deal closes: 1. **Record TCV in deal size field** (for historical analytics) 2. **Record start date and term length** (to calculate revenue slice) 3. **Forecast includes only current-year revenue** (quarterly recognition slice) 4. **Report separately to board:** "TCV $300K, but Q2 revenue recognition $12.5K" ### Why Companies Get This Wrong **Pavilion** analysis: **41%** of companies with multi-year deals misforecast by inflating TCV into quarterly numbers. A company closing $5M TCV (multi-year) might forecast $5M quarterly—real revenue is $1.5-2M annualized. ### Board Transparency Split reporting: - **Forecast (GAAP):** Quarterly revenue only = $1.2M - **Bookings (Cash):** Multi-year TCV closed = $3.2M - **ARR (Valuation):** Annualized run rate = $2.8M Boards understand this construct. Conflating them kills credibility. ```mermaid flowchart TD A["Multi-Year Deal Closed
3-Year Term
$300K TCV"] --> B["Split by Year
Year 1: $100K
Year 2: $100K
Year 3: $100K"] B --> C{"Current Quarter
Revenue?"} C -->|Q2 mid-year start| D["Q2: $25K
Q3: $25K
Q4: $25K
Next Y1: $100K"] C -->|Q1 full year| E["Q1-Q4: $25K each"] D --> F["Forecast includes
only Q2: $25K"] E --> F F --> G["Board sees:
Forecast $1.2M
Bookings $3.2M
ARR $2.8M"] ``` TAGS: multi-year-deals,revenue-recognition,tcv-vs-arr,gaap-revenue,bookings-forecast,contract-mechanics

Item	Value	Forecast Use
TCV	$300K	Not forecast (book separately)
ARR	$100K	For ARR report; shows annualized
Q2 Revenue (mid-q start)	~$12.5K	This counts in Q2 forecast
Q3-Q4, following year	$25K each	Next quarter forecasts

How should forecast models handle multi-year deals that straddle revenue recognition boundaries?

Multi-Year Deal Forecasting

Operator Detail

Multi-Year Deal Mechanics

Forecast Clean-Up Rule

Why Companies Get This Wrong

Board Transparency

What does the score mean?