What you’ll need

Two dates on every revenue number

Net new revenue.

Across the top: the month it billed. Down the side: the month it was approved.

Approved inAccountsJanFebMarAprMayJunJulAugSepOctNovDecYear
Jan251$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
Feb295$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.