Avoiding double counts in a pipeline-to-revenue forecast
Model conversion from opportunities to bookings and from bookings to delivered revenue. Remove anything already included in the backlog.
Wall Street Playbook ·
Work the bridge
There is $600,000 of signed backlog scheduled for the quarter. Active pipeline is $1m, including $200,000 copied into both lists. Remove the copied amount. If half of the remaining $800,000 books and half of that delivers in-quarter, pipeline adds $200,000. The resulting forecast is $800,000 under these assumptions.
Audit the workflow
Use one opportunity identifier across teams and flag signed items intentionally. Test delivery capacity and close dates separately. A high win rate does not accelerate delivery by itself. Keep a bridge showing what moved from pipeline to backlog when you update the forecast.
FP&A Interview & Case Workbook
Get the complete guide when you’re ready for more practice.
Sale price $50.15 Original price $59