What you’ll need
Net new revenue.
Across the top: the month it billed. Down the side: the month it was approved.
| Approved in | Accounts | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Year |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Jan | 251 | $27.1K | $48.4K | $58.2K | $60.7K | $60.1K | $56.7K | $56.0K | $53.8K | $49.0K | $47.2K | $46.6K | $47.6K | $611.4K |
| Feb | 295 | $28.9K | $56.5K | $66.1K | $69.6K | $70.2K | $67.7K | $69.1K | $64.8K | $63.6K | $59.8K | $61.6K | $677.7K |
January’s 251 accounts billed $27.1K in January and $48.4K in February. February’s 295 have no January: they weren’t on the book yet.
Straight Line and Seasonal needed the billing month alone. Cohort needs both dates on the revenue, for every account.
Sample data: an invented payments portfolio, no client data.