What it means to give your investment committee a single reconciled book

Ryan Alfred 7 min read
What it means to give your investment committee a single reconciled book cover image

The phrase "single reconciled book" gets used frequently in private credit operations conversations. It's used as shorthand for a goal: give the investment committee one data view they can trust, rather than three data views they have to audit against each other before drawing any conclusions.

But what does it actually require to get there? The answer is more specific than most discussions acknowledge, and the gap between "we have a position spreadsheet" and "we have a single reconciled book" is larger than it looks from the outside.

The IC's actual data problem

In most private credit funds we talk to, the IC's data problem is not that information is unavailable. It's that the same information arrives from multiple sources, and the sources don't agree. The servicer tape says one thing about a borrower's outstanding balance. The covenant tracking spreadsheet says something slightly different about when the payment was received. The CFO's model, which was built to mirror the servicer data, reflects neither cleanly because it was last updated two weeks ago.

The IC meeting proceeds, but some portion of it is consumed by questions like "which number do we trust here" and "didn't we close that position last quarter." Those are not investment questions. They're data reconciliation questions, and they belong in operations, not in the IC room.

The single reconciled book idea is that by the time data reaches the IC, all of those consistency questions have already been answered. The book reflects one authoritative view of positions, covenants, and cash flows, built from reconciled source data, not assembled from multiple unreconciled outputs.

Three source systems that need to agree before one book is possible

In a typical direct lending fund, the data feeding an IC report comes from at least three distinct sources: the loan administration system (Allvue, Black Mountain, or a servicer-operated system), the servicer's periodic tape deliveries (which may or may not match what the loan admin system shows), and the fund's own tracking records, which often live in a spreadsheet maintained by the ops team.

Each of these sources has legitimate authority over different parts of the position record. The servicer tape is authoritative for actual payment activity. The loan administration system may be more current on amendment terms. The fund's internal records capture portfolio-level context, like watchlist designations and IC commentary, that the servicer doesn't know about.

A single reconciled book is not a single input source, it is a reconciled output of multiple input sources. That distinction matters for how you build toward it. The goal is not to eliminate source diversity, it's to resolve the conflicts between sources systematically, with an explicit rule for which source wins in each conflict type, and an audit trail for every resolution.

What "reconciled" means operationally

Reconciliation, in the precise operational sense, means comparing the current position record against the prior period's record and against each source's current delivery, flagging differences, categorizing them, and resolving them into an authoritative current position view.

A reconciliation break is a specific, named discrepancy: a balance difference greater than tolerance, a payment recorded in the servicer tape but not yet reflected in the loan admin system, a new position in the tape that has no corresponding record in the internal tracking sheet. Each type of break has a standard resolution path.

What most funds call their "reconciled book" is actually a spreadsheet that someone has manually checked and marked as correct. That's not the same thing. A manually verified spreadsheet has no machine-readable audit trail for how each discrepancy was resolved, no defined tolerance rules that were applied, and no linkage between the current position record and the source records that produced it. When the IC asks why a number changed, the answer is in someone's head, not in the data.

The audit trail requirement

One aspect of the single reconciled book that often gets overlooked in the initial planning conversation is the audit trail requirement. A book that the IC can trust is not just accurate at the moment it's presented. It's accurate in a way that can be defended to a third party: an LP auditor, a lender, an SEC examiner conducting an examination of fund records.

That defensibility comes from having a complete record of how each position was built: which tape delivery it came from, what reconciliation run processed it, what exceptions were flagged and how they were resolved, and what the source field values were at the time of the reconciliation. Without that, you have a number that might be right, but that you can only defend by reconstructing the chain of reasoning from memory.

We're not saying every private credit fund needs audit-grade recordkeeping from day one. An emerging manager running 20 positions on a single servicer has different requirements than a multi-vehicle fund at $2B AUM. But the direction of the requirement is constant: as funds grow, LP expectations for data defensibility grow with them, and building a reconciliation process without an audit trail from the start means rebuilding it later when the stakes are higher.

What has to be true before the IC sees the book

Given all of the above, here is the specific sequence that has to happen before an IC report can honestly be called a single reconciled book.

First, all source tapes for the period have to be received and confirmed. A reconciliation run that hasn't received the Allvue tape for one of three vehicles is not a complete reconciliation, even if the other two tapes match cleanly.

Second, the normalization step has to map all incoming fields to the same position schema. Outstanding balance should mean the same thing regardless of which servicer delivered the tape. Payment received date should be in the same format and reference the same period definition across sources.

Third, the reconciliation run has to surface all breaks above tolerance and record the resolution for each one. Breaks that are resolved by accepting the servicer's number over the internal record should be noted as such. Breaks that are resolved by overriding the servicer (because the ops team knows about an amendment the servicer hasn't yet reflected) should be noted differently, with the amendment documentation referenced.

Fourth, the position view that goes to the IC should be the direct output of that reconciliation, not a re-export or a copy-paste into a separate document. Every number in the IC report should trace back to a reconciliation run record, not to an analyst's manual entry.

That's a higher bar than most funds currently operate at. It's also achievable, and the cost of not operating at that bar accumulates quietly until it produces a data question in an IC meeting that no one in the room can answer confidently.

Building toward it incrementally

Moving from a manual quarterly rebuild to a genuine single reconciled book doesn't require doing all four of those things at once. The most practical path starts with normalization: get all of your tape sources mapped to the same schema so that comparisons are apples-to-apples. That alone eliminates a large fraction of the manual work in a typical reconciliation cycle.

The reconciliation run with defined tolerances and break categories comes next. And the audit trail, where every resolution links to a source record, is the final layer. Each step makes the IC book cleaner and more defensible, and each step is worth doing independently even if the others aren't yet in place.

The goal is not perfect data. It is data that the IC can rely on for investment decisions and that the ops team can defend when it's questioned. That's what a single reconciled book actually means, and the distance between that and a well-maintained spreadsheet is larger than it appears until you try to explain a number under time pressure.

Ready to stop rebuilding your portfolio view every quarter?

Bring your loan tape. We'll show you the reconciled output in the first session.