- Before
- “Show me what the number rests on, and I can sign it today.” Reserves were signed on working day 9.
- Now
- Opens each step of the bridge to its formula and source clause, decides the three variances above threshold and signs program by program.
One quarter, from the bridge to signed reserves
Northwind Bio closes Q3 2026: $6.84B of gross sales across Veltrimab, Talmirex and Corventa, seven reserve programs, working day 5 of 7, reserves lock Thursday Oct 8 at 17:00. Here is what happens next, screen by screen, in the working solution.
- 01Working day 5
The whole quarter on one bridge
Lena Ortiz · Revenue ControllerLena's home screen is the gross-to-net waterfall: $6.84B gross steps down through seven programs to $3.27B net. Each step is marked your decision, ready to sign or signed. Commercial PBM, Medicaid and Medicare Part D wait on her, 340B and chargebacks are ready, GPO and fees and copay were signed on Oct 6. Below it, the reserve roll-forward from Jun 30 to Sep 30 and the auditor's open requests.
“3 steps need your decision · 2 ready to sign · 2 of 7 signed · 257 of 262 assumptions tied to a source.”
- 02Before she arrived
Every schedule checked against a second estimate
Variance CheckerThe Reserve Builder rebuilt each program from source and the Lag Curve Analyst produced an independent estimate from 12 quarters of payments. The Variance Checker compared the two: commercial PBM $1,420.0M against $1,439.4M, Medicaid $684.0M against $701.7M, Part D $612.0M against $623.4M — all above policy RA-12's threshold, so all three are routed to Lena. The other four agree within $1.2M.
“Review threshold: $5.0M or 2% of the program provision, whichever is lower.”
- 03One click
She opens the commercial PBM step and sees how it is built
Lena Ortiz · Revenue ControllerThe build opens under the bridge: 91,000 eligible units on Crestline Rx exclusive plans × $7,120 WAC × a 41.0% base rebate = $265.7M for Veltrimab. The rate is flagged — its source says 44.0%. Beside it, every assumption with its document — 64 of 66 tied to a source — and the clause itself: Crestline Rx Amendment No. 3, §4.2, signed Jun 24, 2026.
“Effective July 1, 2026, for Plans in which the Product is placed on an Exclusive Preferred position, the Base Rebate shall be forty-four percent (44%) of WAC for each Eligible Unit dispensed.”
- 04Her decision
She takes the contract rate, and net revenue moves
Lena Ortiz · Revenue Controller91,000 units × $7,120 × 3.0 points is $19.4M. Lena chooses “Use the contract rate — 44.0%”. The Reserve Builder updates the schedule and the roll-forward at once: the step becomes $1,439.4M, ready to sign, and net revenue drops to $3.25B. Keeping the schedule rate was the other option — with a reason.
“Commercial PBM provision now $1,439.4M — net revenue $3.25B; ready for your signature.”
- 05Signed
A signature with its meaning, and the program locks
Lena Ortiz · Revenue ControllerThe signing screen shows the Q3 provision, the Sep 30 reserve of $2,646.4M, the independent estimate, her decision and the evidence: 64 of 66 assumptions cited. She signs with the meaning “I reviewed this reserve and its evidence and approve it”. The program locks; a later change needs a new version and a reason.
“Signing locks the program. A later change needs a new version with a reason; both stay in the audit trail.”
- 06Next program
Medicaid: the four-quarter average no longer fits
Lena Ortiz · Revenue ControllerTalmirex's Medicaid share has risen four quarters running, to 38.7% on Q2 state invoices, and two states made Talmirex preferred on July 1. The schedule still uses the 36.4% four-quarter average. Lena sees three options with their effect: use 38.0% (+$17.7M, recommended), use 37.5% weighted over three quarters (+$12.1M), or keep 36.4%. The URA of $986.00 matches the Q3 pricing file.
The Q2 memo allows a departure from the average for a known formulary change — the agent cites it rather than assuming it.
- 07Short history
Part D: refund claims ahead of the model
Lag Curve AnalystCorventa's negotiated-price refund claims for Q3 are 445,000 units against a run-rate model of 412,000, at $344 a unit (WAC $612 less the $268 negotiated price). With nine months of history, the policy books the higher end of the range so a significant reversal is not probable: +$11.4M. Every agent step that built the number is shown, with its time.
“Short history flagged: 9 months for negotiated-price refunds.”
- 08Redraft
The reserve memo rewrites only what changed
Memo WriterLena's decision makes the RA-12 memo draft stale. The Memo Writer redrafts it: section 4.1 now records Amendment No. 3, the 41% the schedule had used and the $19.4M increase to $1,439.4M, decided by the Revenue Controller on Oct 7. Medicaid and Part D still show as waiting, not guessed. All 41 numbers are linked to a source passage and re-checked.
The Memo Writer never guesses a pending decision — it shows it as waiting.
- 09Same morning
The auditor's request answers itself
Priya Raman · External audit liaisonHartwell & Lane LLP sent 12 requests, due Oct 14. PBC-03 asks for the commercial rebate agreements and amendments effective in Q3. The Audit Pack Assembler has already attached Amendment No. 3 and the contract listing and confirmed the listing is complete against the contract system (20 of 20). Once commercial PBM is signed, it drafts the response. Priya reads it and sends it.
“Six amendments were effective in Q3; one changed a rate used in the reserve — Crestline Rx Amendment No. 3, 44% of WAC from July 1.”
- 10Quarter over quarter
Reserve accuracy, lags and true-ups in one view
Sam Patel · FP&A net price leadThe dashboard tracks prior-period true-ups as a share of provision — 0.73% this quarter against 1.4% in Q4 2025 and a target under 0.5% — with payment lag curves for Medicaid (168 days), commercial PBM (118) and Part D (74), and true-ups by program. Medicaid's +5.3% shows where the earlier estimate was furthest off.