How should you forecast financial health when you have multi-year contracts with holdbacks and payment delays?

Question

Pulse RevOps · The Machine · Accepted Answer

## Brief
Book revenue when signed; recognize it monthly. Holdbacks = cash timing risk. Model cash flow separately: billings + payment terms. Bridge Group calls it "cash basis" vs. "accrual basis" forecasting.

## Detail

Multi-year contracts create an accounting vs. cash gap that trips up forecasting. You can show 100% ARR growth while running out of cash:

**Two Forecasting Lenses**:

1. **Accrual Basis** (revenue recognition):
   - Book: $300K three-year deal = $100K ARR (recognized monthly)
   - Matches GAAP for board reporting
   - Shows run-rate sustainability
   - But hides cash timing

2. **Cash Basis** (billings + payment terms):
   - Bill: $300K upfront, customer pays 50% day 1 + 50% day 60
   - Day 1 cash: **$150K** (not $100K)
   - Day 60 cash: **$150K** (total $300K)
   - Reveals runway implications
   - Holdbacks (e.g., "payment only after go-live") delay cash further

**Real Example**:
- Signed $5M three-year book
- Accrual ARR: $5M ÷ 3 = **$1.67M** (looks great)
- Billings: $5M
- Cash received Q1: **$2.5M** (50% upfront, 50% in 60 days)
- Holdbacks: **$500K** (held until go-live, 45 days post-start)
- Actual Q1 cash impact: **$2M** (less than billings, much less than ARR)

Pavilion field research: **40% of enterprise deals have holdbacks**, averaging **10-20% of contract value**. Bridge Group notes companies often underestimate cash timing, creating false runway signals.

**Forecast Template** (3-month rolling):

| Metric | Q2 Accrual | Q2 Billings | Q2 Cash (50/50 terms) | Q2 Holdback | Net Q2 Cash |
|--------|-------------|-------------|----------------------|-------------|-------------|
| New Bookings | — | $3M | $1.5M | $400K | $1.1M |
| Existing Cash (ARR basis) | $2M | — | $2M | $200K | $1.8M |
| Churn Cash Impact | -$400K | — | -$400K | — | -$400K |
| **Total** | **$1.6M** | **$3M** | **$3.1M** | **$600K** | **$2.5M** |

```mermaid
flowchart TD
    A["$1M Three-Year Deal Signed"] --> B["Accrual Basis"]
    A --> C["Cash Basis"]
    B --> D["$333K ARR"]
    B --> E["Monthly Revenue Ramp"]
    C --> F["50/50 Payment Term"]
    C --> G["$500K Cash Day 1"]
    C --> H["$500K Cash Day 60"]
    G --> I{"Holdback?"}
    I -->|"Yes, 15%"| J["Hold $75K until Go-Live"]
    I -->|"No"| K["Full $500K Available"]
    J --> L["Net Cash Impact: $425K Q1"]
    K --> L
    D --> M["ARR Forecast: $333K recurring"]
    L --> N["Cash Forecast: $425K lump, then $333K monthly"]
```

**Operator moves**:
- Forecast in two columns: accrual ARR (for revenue targets) and cash billings (for runway)
- Track holdback percentage by cohort; set max holdback threshold (e.g., no deals >20% holdback)
- Model payment term impact: Net 30 vs. Net 60 vs. 50/50 split each cost 15-30 days cash
- Board presentation: "We signed $5M ARR, billings $5M, cash $3.8M after holdbacks and terms. Runway 24 months."

TAGS: cash-forecasting,multi-year-contracts,holdbacks,billing-terms,board-reporting

Metric	Q2 Accrual	Q2 Billings	Q2 Cash (50/50 terms)	Q2 Holdback	Net Q2 Cash
New Bookings	—	$3M	$1.5M	$400K	$1.1M
Existing Cash (ARR basis)	$2M	—	$2M	$200K	$1.8M
Churn Cash Impact	-$400K	—	-$400K	—	-$400K
Total	$1.6M	$3M	$3.1M	$600K	$2.5M

How should you forecast financial health when you have multi-year contracts with holdbacks and payment delays?

Brief

Detail

What does the score mean?