Skip to main content
Notes

The eighty-format problem: why financial spreading in private credit breaks templates and BPO queues

Middle-market borrowers never report in a single standard layout. Here is why rigid portal templates and fragile Excel macros break at quarter end, and how bitemporal chart-of-accounts mapping solves private credit spreading.

By Briefed EditorialChecked 30 October 20266 min read

Public equity analysts enjoy a luxury that private credit desks never see: XBRL taxonomies, standardised regulatory filings and uniform quarterly press releases. In private credit and middle-market direct lending, every borrower is a private company running its own accounting software, its own management reporting cadence and its own board pack layout.

Across an eighty-borrower portfolio, a direct lending desk receives eighty distinct formats every quarter: scanned PDF management presentations, multi-tab Xero or NetSuite trial balance exports, sponsor KPI packs and custom compliance certificates. Turning that heterogeneous flood into a consistent, auditable time series is the core challenge of financial spreading.

Why the three conventional approaches break

Private credit funds have historically tried to solve the eighty-format problem in one of three ways, and each breaks down as the book scales past thirty loans:

1. Mandatory borrower portal templates (the iLevel model)

Legacy portfolio monitoring platforms such as S&P Global iLevel were designed around standardised Excel collection templates. In theory, the lender sends a locked template to every borrower CFO each quarter, the CFO fills in the cells and the portal ingests the file cleanly.

In practice, sponsor-backed CFOs and middle-market finance teams refuse to re-key their monthly management packs into five different lender templates. They upload their standard board PDF and their existing Excel pack and consider their reporting covenant satisfied. The burden falls straight back onto the lender’s associates, who spend days manually copying figures from the borrower’s PDF into the portal’s upload template. Worse, once a number is typed into a template cell, its citation link to the underlying footnote in the management pack is lost forever.

2. Offshore BPO and managed spreading teams (the Oxane model)

To relieve associate burnout, many funds contract tech-enabled service providers such as Oxane Partners or Alter Domus to manually spread borrower files offshore. While this removes raw keystrokes from the deal team, it introduces a five-to-ten business day service-level turnaround right during the quarter-end crunch.

When a borrower is drifting toward distress and delivers its pack on the final permissible day, waiting a week for an external BPO queue to return the spread eats directly into the lender’s reservation-of-rights and equity cure timeline. Furthermore, generalist BPO analysts rarely hold the full context of bespoke credit-agreement amendments, forcing the deal team to re-audit the spread before taking it to credit committee.

3. Fragile in-house Excel macros and generic LLM chat

Internal VBA macros or Python scripts built by a junior analyst break the moment a borrower CFO adds a new cost-of-sales row, renames a subsidiary tab or restates prior-quarter comparatives. Meanwhile, pasting a management pack into a generic LLM or a point-in-time document matrix like Hebbia produces plausible prose summaries without maintaining a longitudinal chart of accounts or guaranteeing that balance sheets tie to the penny.

What institutional-grade AI financial spreading requires

Building a spreading engine that a credit committee can rely on requires four architectural properties that Briefed enforces out of the box:

  • Semantic chart-of-accounts mapping with memory: Briefed maps each borrower’s native line items to your house credit template on first ingestion and remembers that borrower’s specific accounting conventions across every subsequent quarter, even when rows are reordered.
  • Hard accounting tie-outs (halts on imbalance): Assets must equal liabilities plus equity; cash flow movements must reconcile to opening and closing cash; LTM bridges must equal Q3 plus FY minus Q3-prior. If a borrower omits a page or a schedule fails to tie by £1, Briefed halts the run and flags the exact discrepancy rather than plugging the number.
  • Bitemporal restatement tracking: Middle-market borrowers frequently restate prior-quarter management figures when audit adjustments land. Briefed records both what the borrower reported at the time and the restated series so historical covenant compliance and trend velocity are never silently overwritten.
  • One-click cell-to-page provenance: Every number in Briefed Workspace and every exported Excel cell retains a permanent link back to the exact bounding box on the source PDF or workbook tab it was read from.

Media

Independent financial journalism

Live market reporting, weekday and Sunday editions, a searchable archive and the editorial standards behind every story.