Step 1
The existing book entering each year: every account approved before January, at what it billed in December.
| Entering | December revenue | Of it, last year’s new accounts | Billing accounts | Of them, last year’s new | Next December’s revenue | Revenue kept | Next December’s billing accounts | Accounts kept |
|---|---|---|---|---|---|---|---|---|
| 2021 | $2.10M | $385K | 5,631 | 1,471 | $1.79M | 85.4% | 4,280 | 76.0% |
| 2022 | $2.30M | $508K | 6,231 | 1,951 | $1.97M | 85.6% | 4,739 | 76.1% |
| 2023 | $2.58M | $609K | 6,851 | 2,112 | $2.18M | 84.6% | 5,142 | 75.1% |
| 2024 | $2.73M | $555K | 7,585 | 2,443 | $2.38M | 87.2% | 5,695 | 75.1% |
| 2025 | $3.02M | $634K | 8,289 | 2,594 | $2.58M | 85.5% | 6,179 | 74.5% |
| 2026 | $3.22M | $639K | 8,760 | 2,581 | $2.74M | 85.2% | 6,634 | 75.7% |
| Average, 2021 to 2025 | 85.6% | 75.3% |
What billed Still billing a year later Forecast at the October close (Step 2) The rate the accounts line uses
A billing account billed more than zero that month. Last year’s new accounts join the book heading into January. An older account not billing in December has closed and isn’t counted.
Sample data: an invented payments portfolio, no client data.