Step 1
Net new revenue. Rows are the month the accounts were approved. Columns are the month they billed.
| Approved | 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 | |
| Mar | 306 | $43.3K | $72.0K | $84.1K | $89.4K | $68.8K | $53.7K | $49.8K | $49.7K | $43.8K | $44.2K | $598.6K | ||
| Apr | 271 | $31.4K | $57.1K | $65.8K | $68.1K | $65.3K | $61.8K | $60.7K | $57.9K | $57.9K | $525.9K | |||
| May | 266 | $27.5K | $50.2K | $54.8K | $58.7K | $55.5K | $52.0K | $49.3K | $51.4K | $399.5K | ||||
| Jun | 254 | $23.9K | $42.3K | $50.3K | $49.4K | $48.9K | $48.5K | $45.9K | $309.2K | |||||
| Jul | 283 | $29.7K | $50.6K | $56.2K | $58.3K | $59.2K | $59.6K | $313.7K | ||||||
| Aug | 275 | $34.0K | $57.3K | $66.2K | $65.5K | $68.8K | $291.9K | |||||||
| Sep | 257 | $28.1K | $51.6K | $58.1K | $66.8K | $204.7K | ||||||||
| Oct | 259 | $22.8K | $38.7K | $45.6K | $107.0K | |||||||||
| Nov | 255 | $30.4K | $57.5K | $87.9K | ||||||||||
| Dec | 278 | $32.0K | $32.0K | |||||||||||
| Billed in the month | 3,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.