A schedule of real estate owned (SREO) is a lender-facing report listing every property an owner or guarantor holds with its value, debt, lender, rate, maturity, occupancy and cash flow; a debt summary is the internal counterpart, listing every loan with its terms, balance, rate, hedge, maturity and key covenants, usually with portfolio totals and exposure views. Both are assembled quarterly, or on demand for a loan application, from the same loan data, and both are wrong in at least one line the day they are finished because a balance moved, a rate reset or a valuation changed. This guide covers what each report has to contain, why manual assembly fails, and what it takes to generate them live.
What the SREO has to contain
Agencies and most banks have their own templates, and a guarantor with loans at several lenders produces several versions of the same information. Typical columns: property name and address, type, units or square feet, ownership percentage, acquisition date and cost, current value and basis, lender, loan balance, rate and type, maturity, monthly debt service, occupancy, NOI, and cash flow after debt service. Guarantor SREOs add contingent liabilities and recourse exposure per loan.
The agencies expect their conventions: how value is stated, how partial ownership is shown, how construction and land are treated. A bank’s template differs. The data is the same; the presentation is not.
What the debt summary has to contain
Every loan with lender, servicer, balance, rate or index and spread, floor, hedge instrument and strike, maturity and extension options, amortization status and IO expiry, prepayment convention and current cost, recourse, key covenant thresholds and current values, and critical dates in the next twelve months. Portfolio totals: weighted average rate and maturity, fixed versus floating split net of hedges, maturities by year, exposure by lender. See loan portfolio dashboards with real-time rates.
| Aspect | SREO | Debt summary |
|---|---|---|
| Audience | Lenders, agencies and credit committees | The owner’s team and the board |
| One line per | Property | Loan |
| Core columns | Value and basis, lender, balance, rate, maturity, debt service, occupancy, NOI, cash flow after debt service | Balance, rate or index and spread, floor, hedge, maturity and extensions, IO expiry, prepayment cost, recourse, covenant thresholds, critical dates |
| Roll-ups | Contingent liabilities and recourse exposure per loan on guarantor versions | Weighted average rate and maturity, fixed versus floating net of hedges, maturities by year, exposure by lender |
| Format | Each lender’s or agency’s template | The version the team already uses |
Why manual assembly fails
- Sources. Balances from servicer statements, rates from confirmations, values from appraisals or internal marks, NOI from accounting, occupancy from property management. Five systems, one spreadsheet.
- Timing. Each source updates on its own cycle. The SREO is a snapshot of five different dates.
- Templates. Each lender’s template is rebuilt by hand, so a change in one loan is made in four places.
- Volume. A 60-loan owner with four lender templates produces 240 loan-lines per quarter, by hand.
- Trust. The first question at every credit committee is whether the SREO is current. If it was assembled two weeks ago, the honest answer is no.
A worked example: the Tuesday the SREO was wrong
A guarantor with 22 properties applies for a new agency loan. The lender requests the SREO on the agency template. The analyst opens last quarter’s version, updates balances from the servicer statements that have arrived (16 of 22), leaves the rest, updates values from the most recent internal marks, and sends it on Tuesday.
The lender’s underwriter compares it with the SREO the same guarantor submitted to a different lender three weeks earlier for a bank line. Four balances differ. Two values differ. One property appears on one schedule and not the other. The underwriter asks for an explanation and a reconciliation, and the loan’s timeline slips two weeks while the analyst rebuilds both.
Nothing was fabricated. The two SREOs were built by hand from different snapshots on different dates for different templates. Each was approximately right and they disagreed, and the disagreement is what the underwriter saw.
With live generation, both SREOs render from the same loan data and the same value table with as-of dates shown. They agree with each other and with the debt summary the board saw the week before, because they are the same numbers.
What the debt summary should show the board
One page, refreshed on the accounting close and the rate feed:
- Total debt, weighted average rate, weighted average remaining term.
- Fixed versus floating, gross and net of caps and swaps.
- Maturities by year for five years, with extension options shown separately.
- Floating exposure: the change in annual debt service for a 100 basis point move.
- Covenant status: loans within 10% of a threshold.
- Critical dates in the next twelve months.
- Prepayment cost to exit the portfolio today, as a reference.
- As-of dates for balances, financials and rates.
The same page, produced by hand, takes two days and is dated by the time it is read.
What live generation requires
- Loan data as fields, abstracted once and updated on amendment. See the 400-field loan abstract.
- Balances from the amortization engine, including re-amortization on floaters, reconciled to servicer statements.
- Financials from accounting, integrated on a schedule. See Yardi, MRI and RealPage integrations.
- Values and occupancy from the source the owner uses, with dates.
- Templates as output formats, so the same data renders in the agency’s layout, the bank’s and the board’s without rekeying.
- Export to Excel and PDF, because lenders still receive files.
How this looks in LoanBoss
The SREO is generated in real time on agency conventions and exportable, from abstracted loan data, live balances and integrated financials. The debt summary is one of the reports LoanBoss rebuilds from the version the team already uses, so the board sees the report it is used to, refreshed automatically. A sample debt summary is downloadable on loanboss.com. Because every report reads the same data, the SREO for one lender, the SREO for another and the internal summary agree with each other, which is the property manual assembly never achieves.
Frequently Asked Questions
Can the platform produce a guarantor-level SREO across entities?
Yes. Loans and properties roll up by guarantor, with ownership percentages and contingent liability per loan.
Our lender wants values from our own marks, not appraisals. Can both be shown?
Yes. Values are stored with source and date; the template selects which to display.
How current is a live SREO?
As current as the last accounting sync and rate refresh, which for most customers means the prior month’s close and today’s rates. The report shows the as-of dates.
Does automating the SREO change what we send the lender?
No. The lender receives the same template. What changes is that the team did not spend two days building it.
Why do two SREOs from the same owner disagree?
Because each was built by hand from a different snapshot on a different date for a different template. With live generation both render from the same loan data and the same value table with as-of dates shown, so they agree with each other and with the debt summary.
Key takeaways
- The SREO and the debt summary are the same loan data rendered for different audiences; assembled by hand, they disagree with each other and with themselves.
- Lenders compare the SREOs an owner sends to different parties. Inconsistencies cost time and credibility at the worst moment, during a loan application.
- Live generation requires abstracted loan data, engine-calculated balances reconciled to servicers, integrated financials, values with as-of dates and templates as output formats.
- The board’s debt summary should fit on one page and refresh on the accounting close and the rate feed.
- Automation does not change what the lender receives; it removes the assembly and the inconsistency.
- Every report should show its as-of dates for balances, financials and rates.
Related reading
- Lender reporting automation that keeps your Excel reports
- Single source of truth for CRE debt
- Managing agency loans
- Debt tracking software for multifamily owners
- Loan-to-value in the glossary
Send your reports. We take the spreadsheets you already use and build them in LoanBoss so they are always live. Your boss keeps the report they are comfortable with.
Sources
- Fannie Mae and Freddie Mac, borrower and guarantor SREO templates (2026)
- Mortgage Bankers Association, commercial and multifamily reporting practices
- Public bank guarantor reporting requirements
- LoanBoss sample debt summary and agency SREO, loanboss.com