Commercial Real Estate Debt & Equity White Papers & Articles | Rockport

A better alternative to fragmented systems: how Rockport CORE builds a regulator-ready deal record

Written by Rockport Editorial Team | Nov 20, 2026, 10:46:29 AM

What makes a commercial real estate deal record defensible?

A defensible deal record is a single, time-stamped record of a loan that shows what the institution knew, who decided what, and when. When an examiner, auditor, or investor challenges a decision, the analysis is rarely the weak point. The weak point is proving which version of the analysis was used, who approved it, and what changed afterwards.

That matters more now. The Mortgage Bankers Association reports that $875 billion of US commercial mortgages, 17% of the $5.0 trillion outstanding, is scheduled to mature in 2026. Every maturity that turns into an extension, a modification, or a workout is a decision someone may later be asked to defend. Rockport CORE builds that record as the loan moves through the system, rather than asking someone to assemble it after the question arrives.

Key takeaways

  • A defensible deal record is a single, time-stamped record showing what the institution knew and when.
  • Supervisory guidance expects documented, well-supported decisions on workouts and on updating collateral values. Fragmented files tend to fail on version control and change history, not on the analysis itself.
  • Rockport CORE enforces data integrity by deal stage and logs changes at field level, including changes written back from Microsoft Excel®.
  • Exposure across borrowers, sponsors, and guarantors is linked in the record, not assembled by hand when someone asks.
  • Outsourced underwriting, servicing, and asset management partners can work inside the record with limited privileges instead of by email.

What do examiners and auditors expect to find in a CRE loan file?

Examiners expect to see that a lender’s decisions on a loan were supported by current information at the time they were made. Two pieces of US interagency guidance set out what that means for commercial real estate.

The 2023 policy statement on CRE accommodations and workouts

In June 2023, the OCC, the Federal Reserve, the FDIC, and the NCUA issued the Policy Statement on Prudent Commercial Real Estate Loan Accommodations and Workouts (OCC Bulletin 2023-23). Among other things, it looks for:

  • A workout plan for each loan, supported by updated and comprehensive financial information on the borrower and realistic projections of the borrower’s cash flow.
  • Current valuations of the collateral, with the institution considering whether there has been material deterioration that calls for a new appraisal or evaluation.
  • Evidence on guarantors and sponsors, including whether a guarantor has the financial ability to support the loan. The statement treats financially responsible sponsors in a similar way to guarantors.
  • Management information systems and internal controls that identify and track loan performance and risk.

The Interagency Appraisal and Evaluation Guidelines

The Interagency Appraisal and Evaluation Guidelines, issued in December 2010, call for strong internal controls over appraisals and evaluations. They also expect institutions to monitor and periodically update collateral values on existing loans, including for modifications and workouts.

Both apply to federally regulated banks and credit unions. Insurance companies, GSE lenders, and other lenders answer to different regulators, auditors, and investors, but the questions they get asked are often much the same: what did you know, when did you know it, and who signed off?

Why do fragmented systems fail that test?

Fragmented systems fail because the record of a decision is spread across places that don’t keep history. The credit memo is in one folder, the underwriting model in another, the approval in an inbox, and the latest rent roll in whichever spreadsheet someone last saved.

  • Version control. Three copies of the model exist, and nobody can say for certain which one went to committee.
  • Change history. A value changed, but the file doesn’t record who changed it, when, or why.
  • Approvals. The sign-off is an email reply, detached from the numbers it approved.
  • Exposure. The answer to “how much do we have with this sponsor?” depends on someone matching names across files.
  • Monitoring. Covenants and maturities are tracked in calendars and side spreadsheets after funding, so the loan’s later history is the hardest part to reconstruct.

None of this means the original analysis was wrong. It means the institution can’t prove it was right, which in an exam or an audit, amounts to much the same thing.

What is commercial real estate debt management software?

Commercial real estate debt management software is the system a lender uses to manage CRE loans from origination through ongoing monitoring and reporting. It holds the loan, property, borrower, and sponsor data, controls who can change it, and records what happened to the loan over its life. Rockport CORE covers origination, underwriting, closing, and asset management. Loan servicing and accounting sit in a separate Rockport product, Rockport ACT.

How does Rockport CORE build the deal record?

Rockport CORE builds the deal record through four mechanisms that work as the loan moves through the system, so nobody has to assemble the file after the fact.

Controls by deal stage

Fields can be set as required or read-only by deal stage. Required fields mean key data has to be in place at each stage, and read-only fields protect values from being changed later.

Permissions by role

Role-based access and permissions control who can see and edit what, with custom screen views by role.

Document checklists

Document and checklist management, including dynamic checklists, keeps documents with the deal they relate to, and automated notifications and reminders flag what is still outstanding.

A field-level audit trail, including Excel

Rockport CORE keeps a field-level audit trail across the life of the loan. That includes changes written back from Excel, which matters because underwriters keep working in their own Excel models and write selected results back to the loan record. The question “who changed this value, and when?” has an answer even when the change started in a spreadsheet.

Underneath sits the infrastructure: Rockport CORE is independently audited to SOC 2 Type II standards. SSAE SOC 1 and SOC 2 Type II audits, encryption in transit and at rest, and single sign-on information can all be found on our Cyber Security page.

How does a single record make exposure visible?

Rockport CORE links borrowers, sponsors, and guarantors across every loan, so total exposure is a search rather than a project. That supports the kind of guarantor and sponsor assessment the 2023 policy statement describes, and it answers the question credit committees ask first when a sponsor runs into trouble.

  • Dashboards stratify the portfolio and drill from a chart to the loans behind it.
  • Loan and property dashboards show DSCR, LTV, and risk rating trends over time, with an activity timeline from origination to today.
  • More than 60 standard reports cover operational, credit, and portfolio views, and users can run ad hoc reports without an IT ticket.

How does the record keep working after closing?

Most of what an examiner asks about a workout happens years after closing, so the record has to keep working after funding. In Rockport CORE, it does.

  • Operating statements against underwriting. Incoming operating statements and rent rolls are tracked period over period and compared with the original underwriting.
  • Covenants. Covenant tracking includes threshold testing, exception tracking, and reminder notifications.
  • Modifications and consents. Extensions, property releases, rate changes, and assumptions are recorded on the loan, not in a side file.
  • Collateral evidence. Third-party reports, including appraisal, property condition, and environmental data, can be brought into the record.
  • Revaluation in a workout. We’ve seen this in a recent case: a deal that had been performing began to show distress; the team took a deeper look in Rockport VAL, and the result passed back into Rockport CORE for reporting.

How do outsourced partners work inside the record?

Many lenders outsource parts of underwriting, servicing, or asset management. Rockport CORE gives those firms permissioned, limited-privilege access to the specific data or deals they work on. Their work lands in the same record, under the same audit trail, instead of arriving as an email attachment that someone has to re-key.

What Rockport built for Fannie Mae

Rockport built three platforms for Fannie Mae: DUS Disclose®, DUS Insights®, and DUS 360™. Rockport says supporting them has built deep GSE expertise into Rockport CORE. DUS 360 is the closest match to the subject of this post.

  • It is the internal asset management team’s primary system for managing Fannie Mae’s multifamily portfolio, and it is used well beyond that team, including by origination, credit, and underwriting.
  • It is the system of record at Fannie Mae for several high-stakes data points: risk ratings, loss forecasts that flow to the accounting books, loan assignments, property valuations, and the quarterly certification of the portfolio, including valuations and risk ratings.
  • It keeps property history across loans, including financial statements, valuations, inspections, the lender, and the sponsor on each past transaction.
  • It shows every loan or property a counterparty has been involved in, which is a critical view when working through a workout with a borrower.

Fragmented file vs single system of record

Question you get asked

Fragmented file

Rockport CORE

Which version of the analysis was used?

Whichever copy someone finds

Required and read-only fields by stage protect what informed each step

Who changed this value, and when?

Not recorded

Field-level audit trail, including Excel write-backs

Who could edit it?

Anyone with the file

Role-based permissions, defined by the client

Where is the supporting evidence?

Shared drives and inboxes

Document checklists on the deal

What is our total exposure to this sponsor?

Days of matching names

Borrowers, sponsors, and guarantors linked across loans

What happened after closing?

Calendars and side spreadsheets

Covenants, statements, and modifications on the same record

What did the outsourced team do?

Email attachments

Limited-privilege access inside the record

 

Rule of thumb: no system makes a lender compliant on its own. What a system of record does is make the evidence possible to produce, quickly, and in one place.

 

Frequently asked questions

 

 

Test your own file

Pick a loan that was extended or modified in the last year, and time how long it takes to show who changed what, and when. If the answer is more than a few minutes, let’s talk through it. Contact us →

 

 

Related reading