A single source of truth for commercial real estate debt is one system that holds every loan’s complete terms as abstracted from the executed documents, the current balance as reconciled to the servicer, the financials as closed in the accounting system, the hedge as confirmed by the counterparty and valued at live rates. Every calculation, date and report derives from those inputs, so that the capital markets team, asset management, accounting, the lender and the board are all reading the same number. The phrase is overused in software marketing. In debt management it has a precise meaning, because the alternative is specific: five sources, four of them stale, and a spreadsheet reconciling them by hand. The record has a defined content, a set of parties who feed it and read it, and a routine that keeps it true.
The five sources it replaces
- The closing binder. The terms, as of closing. Amendments are elsewhere.
- The servicer portal. Balances and payments, per servicer, in each servicer’s format.
- The accounting system. NOI, rent rolls and the GL’s view of the loan balance, which may differ from the servicer’s.
- The hedge confirmations and counterparty statements. Terms, valuations and settlements, per bank.
- The spreadsheet. Where someone combines the four, quarterly, with formulas that approximate the documents.
Each is authoritative for something. None is authoritative for the whole. The single source of truth does not replace them; it reconciles them, once, into a record everyone uses.
What the record contains
- Loan terms, every provision as a field: rate mechanics, amortization, prepayment, covenants and adjustments, hedge requirements, reserves, triggers, recourse and burndown, extensions, consents, releases, supplementals, reporting. See the 400-field loan abstract.
- Balances, from the amortization engine under the loan’s conventions, reconciled to servicer statements with differences flagged. See floating-rate re-amortization and SOFR tracking.
- Financials, from the accounting system on a schedule, mapped to each loan’s definitions. See Yardi, MRI and RealPage integrations.
- Rates, live: SOFR, Term SOFR, Treasuries, swap curve.
- Hedges, terms and live valuations. See hedge requirements.
- Calculations, derived on demand: covenant tests, trigger tests, prepayment costs, cash flows, exposure. See DSCR and debt yield tests and real-time prepayment calculations.
- Dates, derived and alerted. See loan critical date tracking.
- Reports, rendered from the record in each audience’s format. See automating the SREO and debt summary and lender reporting automation.
- Documents and correspondence, filed against the loan: the agreement, amendments, consents, compliance packages sent.
- An audit trail: who changed what, when, and why.
Who feeds it, who reads it
| Party | Feeds | Reads |
|---|---|---|
| Capital markets | Documents, amendments, hedge confirmations, interpretations | Everything; owns the record |
| Accounting | Closed financials via integration | Balances, debt service, reconciliations |
| Asset management | Rent roll events, business plan dates | Covenant trajectory, triggers, consent thresholds, release tests |
| Lenders and servicers | Statements (reconciled against) | Compliance packages, SREOs, financial packages |
| Investment committee and board | Sale and refinancing assumptions | Valuations, scenarios, maturity schedule, exposure |
| Auditors | Nothing | Schedules, support, access logs |
| Investors | Nothing | Fund-level debt reporting |
The point of the table is that every reader gets the same record rendered for their purpose. Asset management’s covenant number is capital markets’ covenant number is the lender’s covenant number.
How it stays true
Abstraction on amendment. Every document change is re-abstracted on receipt, by the team that abstracted the original. See AI loan document extraction.
Reconciliation as a routine. Balances to servicers monthly; tests to lender calculations each cycle; reports to prior versions.
Integration, not upload. Financials arrive on a schedule from the system that closed them.
Live rates. Every rate-dependent number refreshes daily.
Access control and audit. Changes are attributed; readers see what they need. See SOC 2 Type II and loan management software.
One owner. Capital markets owns the record and the interpretations recorded in it.
A worked example: one number, five versions
On the first Monday of the quarter, five people are asked the balance of the same $33 million floating-rate loan.
- The controller reads the general ledger: $32,614,200, the balance after the last payment posted, using the amortization schedule loaded at closing.
- The capital markets analyst reads the spreadsheet: $32,598,750, updated from the servicer statement two months ago and rolled forward with the closing-model amortization.
- The asset manager reads the BI dashboard: $32,650,000, imported from the spreadsheet at the last quarterly refresh.
- The servicer’s portal says $32,571,318, after last month’s reset re-amortized the loan.
- The lender’s compliance analyst, preparing the annual test, uses $32,571,318 and the owner’s rent roll.
The servicer is right. The controller is $43,000 high because the GL schedule does not re-amortize. The analyst is $27,000 high because the roll-forward used the wrong rate. The dashboard is $79,000 high because it is two refreshes old. The lender’s DSCR uses the right balance and the owner’s certificate, prepared from the spreadsheet, uses the wrong one; the two do not reconcile and the lender asks why.
None of the five was careless. Each read the source they trust, and the sources disagree. The single source of truth is the loan record that re-amortizes at each reset, reconciles to the servicer monthly, and is the number all five read.
Signs you do not have one
- Two reports produced the same week show different balances for the same loan.
- A lender’s calculation differs from yours and nobody can say which adjustment explains it.
- A prepayment quote from the servicer surprises the deal team.
- The board’s maturity schedule and the fund model’s disagree on a date.
- The answer to “what is our floating exposure” takes more than a day.
- An amendment is in a folder and not in any system.
What it is not
It is not the accounting system. As loanboss.com puts it, the property accounting systems are the central nervous system of the organization; they provide the source-of-truth financial data, and the debt platform runs the complex math. It is not an asset management suite or an investor portal; those read from it. It is not a data warehouse; it is the debt record, with the calculations, that a warehouse might store a copy of. See what CRE CFOs ask for on why finance leaders do not want a one-stop shop.
How this looks in LoanBoss
LoanBoss unifies loan abstracts, accounting feeds and live rates to automatically refresh DSCR, balances, rates, mark-to-markets and cash flows, so risks are spotted early and one source of truth is shared. Loans are abstracted by an in-house team to 400+ fields with two rounds of QA. Integrations with Yardi, MRI and RealPage supply financials. Every calculation runs on the record; every report renders from it; every date is derived from it. The platform runs 600 million-plus calculations a day across $250B+ in managed loans. A customer’s Chief Investment Officer described it as an invaluable part of managing the portfolio and adjusting strategy in a dynamic environment.
Frequently Asked Questions
We have a data warehouse. Isn’t that the single source of truth?
A warehouse stores what it is given. If the loan terms it is given came from a spreadsheet, the warehouse is a well-organized copy of the spreadsheet. The debt record has to be built from the documents and reconciled to the servicers first.
Can asset management and capital markets both edit the record?
Asset management supplies events; capital markets owns terms and interpretations. Role-based access enforces it and the audit trail records it.
How long does it take to build the record?
It is the onboarding: 92% of LoanBoss clients within six weeks. See spreadsheets to platform without disruption.
What happens when the servicer’s balance and ours differ?
The difference is flagged, traced to a convention (observation date, floor, business day rule), and the convention is corrected. The record is right when it reconciles, not when it is entered.
Who owns the single source of truth?
Capital markets owns the record and the interpretations recorded in it. Accounting feeds closed financials through the integration, asset management supplies rent roll events and business plan dates, and lenders, auditors, the board and investors read from it in their own formats.
Related reading
- Why Excel breaks for loan portfolios
- Loan portfolio dashboards with real-time rates
- AI-powered debt portfolio surveillance
- Loan portfolio management for private equity real estate funds
- Lobby CRE alternatives
Your portfolio is complex. The answers should not be. One record, reconciled, live, read by everyone.
Sources
- Mortgage Bankers Association, commercial servicing data standards (MISMO)
- NCREIF and PREA, institutional data governance practices
- Customer statements published on loanboss.com
- LoanBoss product documentation, loanboss.com