Tracking Due Diligence Costs Across Workstreams: The Roll-Up Problem

Most deal teams can tell you what their legal advisor has billed and what their financial advisor has billed. What almost none of them can produce on demand is the one number their investment committee actually asks for: total expected diligence spend to close, across every workstream, that survives being poked at. Tracking due diligence costs across workstreams is rarely where things break. The break is one step later, at the roll-up, when four or five separately-tracked workstreams have to become a single figure a director will sign against, and the act of summing them quietly destroys the thing that made each line trustworthy.

The reason is not arithmetic. It is that the lines you are adding together are not the same kind of thing. A fixed-fee legal number is a commitment; a time-and-materials financial number is a forecast; a tax line confirmed three weeks ago is stale; a commercial line updated this morning is current. Add them and you get a number with no consistent meaning, presented to a committee as if it had one.

Why does tracking due diligence costs across workstreams break at the roll-up, not the tracking?#

The roll-up breaks because it sums numbers that mean different things and were measured at different times, then presents the result as if it were one clean figure. You can track each workstream impeccably and still produce a misleading total, because consolidation is its own discipline, not a side effect of good tracking. This post assumes you already capture committed and actual spend per advisor; if that part is not yet in place, start with our field guide to due diligence cost management, which covers the per-workstream cost mechanics this one builds on top of. The focus here is everything that happens after each line is current: turning four good lines into one number nobody can puncture.

The scale of the problem is the first thing manual consolidation underestimates. A full diligence exercise can run to twelve distinct workstreams, from financial and tax through to data privacy and environmental, opened progressively as the deal advances rather than all at once. A mid-market buy-side deal rarely runs all twelve, but in my experience it is normal to have several live at the same moment, each a separate engagement on its own clock. Rolling those up is not adding a column of like-for-like figures. It is reconciling several different reporting formats, fee structures and update cadences into one line, by hand, usually against a committee deadline.

The first failure is the mixed-meaning sum. A fixed-fee workstream contributes a near-certainty; a time-and-materials workstream contributes a projection of a meter still running. Added into one figure, the certain and the speculative become indistinguishable, and the total inherits the softness of its softest line without flagging it. A £2.1m roll-up that is 85% fixed-fee commitment is a different object from a £2.1m roll-up that is 60% open T&M forecast, but on a single line they read identically. The committee cannot price the difference because the number has hidden it.

The second failure is simultaneity. A roll-up is only valid if every line is current as of the same instant, and on a live deal that is exactly what a manual consolidation cannot guarantee. The legal line might be a fortnight old, the financial line updated this morning, the tax line a verbal figure someone half-remembers. The sum is internally inconsistent, a composite of four different Tuesdays, and its error is invisible because nothing on the page records when each input was last true. This is a different problem from per-line staleness; you can have four reasonably fresh lines and still have a roll-up that never represented a single real moment.

Both failures share a root cause, which is that the deal lead is the only integration layer between the workstreams and the number. Assembling the figure means pulling several sources that disagree, normalising their formats and chasing whoever has gone quiet, and that work crowds out the part that has value. The FP&A Trends Group's 2024 FP&A Trends Survey, based on 383 finance practitioners, found only 35% of finance professionals' time goes to high-value work such as generating insight; the rest goes to collecting and validating data. A deal lead hand-reconciling five workstreams the night before a committee is living that statistic, and the hours spent building the number are hours not spent questioning it.

How do you roll workstreams up into one number the IC will trust?#

You roll workstreams up by normalising what you are adding before you add it, snapshotting every line as of one date, and carrying the committed-versus-forecast split into the total rather than dissolving it. The committee does not want last month's actuals; it wants total expected spend to close and a defensible reason for the shape of it. That number exists only if the consolidation is disciplined, because the drift between fee estimates and actuals compounds across lines and a careless sum buries it.

Normalising means recording, on every line, which kind of number it is: a fixed-fee commitment, a billed actual, or a T&M forecast. The roll-up then carries three subtotals up, not one, so the headline figure can be read as "£X, of which £Y is committed and £Z is still forecast." That single decomposition answers the question a committee actually asks, which is not "what will it cost" but "how firm is that." It also makes the soft money visible: if the open T&M forecast is a third of the total, the committee knows precisely where its exposure sits without anyone having to confess it.

The chart is illustrative, but the point is structural rather than numerical: two deals can carry the same headline roll-up and represent completely different levels of certainty. A committee that sees only the £2.1m bar cannot tell the firm deal from the speculative one. The split is the information the roll-up usually throws away, and it is the cheapest possible thing to preserve if you decide up front that the total is three numbers wearing a trench coat, not one.

Once the number is built this way, the natural output is an IC-ready cost report for due diligence, which takes this consolidated figure and surrounds it with the workstream table, scope-change log and narrative a committee pack needs. That post covers what the report contains and how to lay it out; the concern here is upstream of it, the integrity of the single number the report is built around. Get the roll-up wrong and a beautifully formatted report just presents a wrong number with confidence.

There is a governance reason the firmness split matters more in 2026 than it used to. Deloitte's 2026 M&A Trends Pulse Survey, which surveyed 500 corporate and private-equity M&A leaders in April 2026, found dealmakers re-engaging with deals but doing so with markedly more discipline on execution and cost. A committee operating with that discipline does not accept a single diligence number at face value; it asks how much is committed, what is still open, and what moves it. A roll-up that cannot answer those questions reads as loss of control even when every underlying decision was sound.

What does a disciplined roll-up actually involve, step by step?#

A disciplined roll-up normalises fee types, snapshots all lines to one date, splits the total by firmness, and reconciles the result back to agreed scope before it goes near a committee. The per-workstream tracking is assumed; these steps are only the consolidation operation that sits on top of it, and they are where manual processes quietly fail.

The honest limit is that a disciplined team can do all four of these by hand for one slow, mostly fixed-fee deal, and the roll-up will hold. What does not survive manual effort is the combination this post is about: several workstreams, a real T&M strand, and an IC date you do not control, where the normalising and snapshotting have to happen on demand rather than over a quiet afternoon. The spreadsheet-versus-diligence-cost-software decision turns almost entirely on this point, because a sheet can store the lines but cannot guarantee they were all true at the same instant when you press print.

What changes when the roll-up is generated from live data, which is the problem AdviLink is built to remove, is narrow but decisive: the single number stops being something the deal lead assembles and starts being something they interrogate. Instead of spending the day before the committee reconstructing the figure, they spend it understanding why the forecast portion grew, which is the part of the job that actually needs judgement. The deal team that can see a £2.1m total resolve into £1.4m committed and £0.7m open, current as of this morning, is not running a tidier spreadsheet. It is holding a number it can defend one question deeper than the team next door.

Frequently Asked Questions#

How do you roll multiple diligence workstreams up into one cost number?#

Normalise before you sum: tag each line as a fixed-fee commitment, a billed actual or a time-and-materials forecast, snapshot every workstream as of the same date, and carry a committed-versus-forecast split into the headline figure rather than dissolving it. A raw sum of differently-typed lines measured at different times produces a number with no consistent meaning, which is why most cross-workstream totals fall apart under a second question.

Why is a single rolled-up diligence cost number misleading?#

Because it hides two things the committee needs: how firm the number is, and when it was true. A fixed-fee commitment and an open T&M forecast read identically once summed, so a £2m total that is mostly locked looks the same as one that is mostly speculative. And a roll-up stitched from lines updated on different days never represented a single real moment, so its error is invisible.

What is the committed-versus-forecast split, and why show it to the IC?#

It is the breakdown of a total into money already committed or billed versus money still only forecast, usually on open time-and-materials work. Showing it answers the question a committee actually asks, which is not "what will diligence cost" but "how sure are you of that number." Naming the soft money up front is also what stops it surfacing as an unexplained surprise at close.

Can a spreadsheet produce a reliable cross-workstream roll-up?#

For one slow, mostly fixed-fee deal, yes. It breaks once you run several advisors in parallel with any time-and-materials exposure and an IC date you do not control, because a sheet can store the workstream lines but cannot guarantee they were all current as of the same instant when you consolidate them, nor keep the firmness split intact as the numbers move.

Sources#

1. 2024 FP&A Trends Survey — FP&A Trends Group, 2024. Survey of 383 finance practitioners; only 35% of finance professionals' time goes to high-value work such as generating insight, the rest to collecting and validating data.
2. The M&A Due Diligence Checklist: 12 Workstreams — Govern365, 2026. A full diligence exercise broken into twelve distinct workstreams, from financial and tax to data privacy and environmental, opened progressively across the deal timeline.
3. 2026 M&A Trends Pulse Survey — Deloitte, 2026. Survey of 500 corporate and private-equity M&A leaders (April 2026); dealmakers re-engaging with deals but with greater discipline on execution and cost.