Step 1

Last year, one line for each month’s new accounts: the revenue

Net new revenue. Rows are the month the accounts were approved. Columns are the month they billed.

ApprovedAccountsJanFebMarAprMayJunJulAugSepOctNovDecYear
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
Mar306$43.3K$72.0K$84.1K$89.4K$68.8K$53.7K$49.8K$49.7K$43.8K$44.2K$598.6K
Apr271$31.4K$57.1K$65.8K$68.1K$65.3K$61.8K$60.7K$57.9K$57.9K$525.9K
May266$27.5K$50.2K$54.8K$58.7K$55.5K$52.0K$49.3K$51.4K$399.5K
Jun254$23.9K$42.3K$50.3K$49.4K$48.9K$48.5K$45.9K$309.2K
Jul283$29.7K$50.6K$56.2K$58.3K$59.2K$59.6K$313.7K
Aug275$34.0K$57.3K$66.2K$65.5K$68.8K$291.9K
Sep257$28.1K$51.6K$58.1K$66.8K$204.7K
Oct259$22.8K$38.7K$45.6K$107.0K
Nov255$30.4K$57.5K$87.9K
Dec278$32.0K$32.0K
Billed in the month3,250$27.1K$77.3K$157.9K$230.2K$298.3K$356.2K$387.4K$435.3K$472.0K$521.0K$557.8K$638.8K$4,159.3K

The bottom row is the PY row Straight Line started from. Every row above it is what that one row averaged together.

Sample data: an invented payments portfolio, no client data.