From quarterly guesses to daily precision
MeridianLink rebuilt revenue forecasting with 12,500 contracts modeled individually. Forecast cadence doubled from quarterly to twice-monthly. Pipeline connects directly to bookings to revenue recognition.
High-level forecasts missing the truth
MeridianLink's finance team was forecasting revenue the way most SaaS companies do: aggregate bookings by month or quarter, apply a revenue recognition rate, and hope for accuracy. But this approach has a fundamental problem — it hides contract-level risk.
When you're sitting on 12,500 contracts with different terms, renewal dates, and revenue recognition profiles, a top-level forecast misses early warning signals. A large customer showing signs of churn gets buried in the aggregate. A contract that's delayed by two weeks doesn't show up as a line item to watch.
MeridianLink's forecasting happened quarterly. By the time they saw a miss, it was too late to course-correct. Sales couldn't see which deals were at risk of slipping to next quarter. Finance couldn't tell the board which contracts were driving variance. It was all rolling up to a single number that, when it missed, surprised everyone.
The team needed visibility at the contract level — to see pipeline flowing through to bookings to revenue, with enough frequency to catch problems early. But building that in a spreadsheet or their existing tools was unrealistic.
Contract-level forecasting architecture
PlanFlamingo built a contract-level revenue forecasting model in Anaplan where each of MeridianLink's 12,500 contracts is modeled as an individual line.
1. Contract-level data model. Every contract has its own row: customer name, deal size, contract start/end date, revenue recognition method (SaaS, perpetual, services), and payment terms. Contracts flow from a CRM feed directly into the model, eliminating manual data entry.
2. Pipeline to revenue bridge. Deals are pulled in three states: pipeline (forecast probability), committed bookings (won deals not yet recognized), and revenue (recognized based on contract terms). The model threads them together so leadership can see the entire deal lifecycle in one view.
3. Automated revenue schedules. For each contract, revenue is calculated based on its start date, term, and recognition method. Monthly revenue automatically appears in the right period. When a contract is updated or a deal closes early, the revenue schedule recalculates automatically.
4. Variance analysis by contract.** Finance can now drill into any forecast miss and see which specific contracts caused it. A $500K variance in Q2? That's three contracts: one delayed 30 days, one smaller-than-expected deal, and one early renewal. That level of clarity was impossible before.
5. Twice-monthly refresh cycle. Instead of quarterly forecasts, the model updates twice monthly when pipeline and booking data refresh. Sales reps see contract-by-contract forecasts. Finance produces board materials with two-week-old data instead of six-month-old data.
Accuracy and speed in a single system
The operational impact was immediate. Reforecasting that used to take an entire week — pulling data from multiple systems, reconciling contracts, building pivot tables, validating numbers — now happens in one day. The data is two weeks fresher, which matters when board meetings are weeks away.
Sales leadership now has visibility into deal risk. They can see which contracts are at risk of slipping, which customers are approaching renewal, and what the pipeline looks like two months out. Finance can answer questions like "What if we lose this deal?" in minutes instead of days.
Most importantly, MeridianLink's forecasts became more reliable. When a deal slips or a contract is smaller than expected, it surfaces immediately at the contract level. The forecast doesn't get blind-sided by aggregate surprises anymore.
"We can now reforecast in one day instead of a week. Board materials are ready by day 3 of close instead of week 2. More importantly, we see problems early. When a deal slips, we know it. When a customer is at risk, we see it. That level of visibility has changed how we think about revenue management."
— VP FP&A, MeridianLink*Suggested quote, pending client approval
Ready to replace spreadsheet forecasting?
If your revenue forecast is a black box, or reforecasting takes weeks, let's talk about building something more precise. 30 minutes, no obligation.