- Before
- “Show me which study and which cost is off, and why — not another spreadsheet.” Leads the quarter-end accrual for eight studies and six vendors, and prepares the Veltrimab studies herself.
- Now
- Opens one map with every study against every vendor's estimate, reads the reason in the cell and decides what to keep.
One quarter-end close, from the CRO's estimate to a posted entry
Q3 2026, working day 5. Eight studies, six vendors, entries post Thu Oct 8 at 12:00. Tessaly Research's accrual confirmation for NXL-301 — Talmirex with standard chemotherapy in non-small cell lung cancer, Phase 3, 46 sites — lands at 07:55. Here is what happens next, screen by screen, in the working solution.
- 01Working day 5
Every study and cost category on one accrual map
Dana Okafor · Clinical accounting leadStudies run down the side, cost categories across: CRO fees, site costs, lab and imaging, change orders and pass-throughs. Each cell is the work done to Sep 30 and not yet billed, coloured by how far it is from the vendor's own estimate — within 10%, 10–25%, over 25%, or not in the estimate. Seven studies were built overnight: $3.56M against the vendors' $2.82M, with VLT-302's lab and imaging 83% above Kestrel's estimate.
“Larkfield’s confirmation was sent on Sep 9 and counts the 1,184 August kits only.”
- 0207:55 · one click
“Load NXL-301 data” — four agents build the study
The agentsDana loads Tessaly's confirmation on the map. The contract reader turns the contracts into a rate card, the activity matcher takes the EDC, CTMS and imaging exports at the Sep 30 cut-off, the accrual calculator works out earned against billed for 5 lines, and the billing checker runs its six checks. The NXL-301 row fills in cell by cell.
Every step shows what it read and what it found, with its timing.
- 03Seconds later
Site costs turn red — with the reason already written
Accrual calculatorOur site-costs accrual is $112,200; Tessaly's estimate is $81,300, a difference of $30,900, or 38%. Tessaly dated its confirmation Sep 26 and assumed 31 screening visits in September. The EDC cut-off shows 43 — 12 extra patients screened in the last four days of the quarter — and at the $2,575 screening grant in the site budgets that is the whole $30,900.
Sources: “EDC screening log · cut-off Sep 30”, “Site budgets · screening visit”, “Tessaly confirmation · Sep 26”.
- 04Same cell
The bridge from Q2, and how good Q2 turned out
Dana Okafor · Clinical accounting leadEach cell carries its bridge: the Q2 accrual, the invoices against it, the amount billed for Q2 work, the new Q3 work and the Q3 accrual. The Q2 look-back reading recolours the whole map by how close last quarter's accrual came to the invoices that followed — 93.3% on this cell.
- 05Her decision
Keep our accrual, ask Tessaly to confirm
Dana Okafor · Clinical accounting leadDana keeps the $112,200 — the reason goes into the accrual memo — and sends Tessaly the variance with its sources; the reply lands in the cell. She opens the schedule: NXL-301 accrues $203,800, with $20,240 in prepaid. Click any amount and the passage behind it opens: 4,410 patient visits at each site's budget rate, earned $5,402,300, billed $5,290,100.
“Each completed visit in EDC priced with its own site’s budget.”
- 06VLT-302
Five flags on Kestrel's invoice, each with its evidence
Billing checkerLine 14 of Kestrel invoice KC-2026-0917 bills 300 Visit 6 (Week 12) visits; EDC shows 150, so $177,000 is billed with no recorded visit. Screen failures are billed above the one-in-three cap ($30,080), Change Order 2's new monitoring rate is applied to 69 May visits ($14,490), Larkfield has not invoiced August and September ($730,128), and Change Order 3 started Sep 15 and is not billed ($184,800).
“The suggested action is a proposal — you decide.”
- 07Across the close
Every flag in one list, with the amount at stake
Dana Okafor · Clinical accounting leadNine open flags across four studies: $300k billed above the work, to dispute before accounts payable pays, and $1.01M of work with no invoice, to accrue. Invoice ALD-55120 on NXL-105 was billed twice; 88 standard tumour reads on NXL-301 were billed at the expedited rate. Dispute letters go to the vendors with the evidence.
- 08Ready to sign
The entry by cost family and the memo, drafted
Journal and memo writerFor CVT-201, Corventa in pulmonary arterial hypertension, the entry debits R&D clinical expense by cost family and credits accrued clinical costs: $755,660, balanced, auto-reversing Oct 1. The memo states the method, the result, each judgement — the duplicated echo reads disputed, patient travel above the $620,000 ceiling accepted with a note — the bridge and the look-back: Q2 invoices came to 96.1% of the estimate.
- 09Second signature
The controller approves, with the meaning of his signature
Omar Haddad · R&D controllerSam Patel signed as preparer on Oct 6. Omar Haddad records the controller approval — “Approved for posting — review control performed” — with his password.
“The signature is recorded with name, time and meaning in the audit trail.”
- 10Posted
Posted to the ERP, reversing on the first of the month
Sam Patel and Omar HaddadApproval posts JE 2026-09-4484 to period 09-2026 with an auto-reversal on Oct 1, sends the dispute letters to the vendors and files the schedule, sources, decisions, memo and signatures to the audit pack.