ARR bridge and revenue quality
One register of every contract you have signed, and from it the monthly ARR bridge and the revenue-quality split the next investor will price.
Enter each contract line once, and it builds the monthly bridge (opening, new, expansion, contraction, churn and closing) and the split between recurring revenue and everything else. A check row must read zero every month.
What’s inside
- Revenue register: every contract line, and the only tab you type on
- Monthly bridge: opening, new, expansion, contraction, churn and closing, by month
- Revenue quality: the headline number, the split, concentration and flags
- Definitions: the revenue definitions investors use
Start here. Enter every signed customer line with its start and end dates and annual value, set the first month on the Monthly bridge, then read the headline ARR on the Revenue quality tab.
Every file comes filled in with a worked example for Northlight AI Ltd, a fictional company. Blue cells are yours to overwrite; white cells calculate. Formats show £: for €, change the currency format on the number cells.
