A commercial real estate loan abstract is a structured summary of a loan’s documents (note, loan agreement, mortgage, guaranties, hedge confirmations, cash management and reserve agreements, amendments) that records every term, date, test, threshold and obligation as a discrete field so that the loan can be tracked and calculated without re-reading the documents. The number of fields is the depth of the abstract. Fifty fields cover the note: parties, balance, rate, maturity, payment. Four hundred cover the deal: how the rate resets, how prepayment is calculated on any date, what the lender excludes from NOI, when the cap must be replaced, what triggers the sweep, how the guaranty burns down. This article walks through what the additional fields are and why an abstract without them leaves the work in the documents.
LoanBoss abstracts 400+ fields per loan with an in-house team and two rounds of QA. That is the standard we describe here.
The fifty fields everyone captures
Borrower and lender entities, servicer, loan amount and outstanding balance, note rate or index and spread, floor, origination and maturity dates, payment date and amount, amortization term, interest-only period, escrow balances, recourse type, collateral description, guarantor names. This is what a servicer statement and a closing binder cover sheet contain, and it is what most internal spreadsheets track. It is enough to pay the loan. It is not enough to manage it.
The next 350
| Field group | Approximate fields | What the fields record |
|---|---|---|
| Rate mechanics | 30 | Index and tenor, lookback, daycount, floor and ceiling, spread step-ups, reset frequency, fallback provisions |
| Amortization | 20 | Type, schedule start, IO expiry, re-amortization triggers, balloon calculation, scheduled paydowns |
| Prepayment | 40 | Lockout end, open period, prepayment type by period, reference rate and lookback, notice, partial prepayment rules |
| Covenant tests | 60 | Metric, threshold, measurement period, frequency, every lender adjustment, cure rights and consequences |
| Hedge requirements | 25 | Instrument, strike, notional, term, counterparty rating, replacement timing and escrow formula |
| Escrows and reserves | 30 | Purpose, funding formula, cap, springing and disbursement conditions, repair completion dates |
| Cash management | 20 | Trigger events and thresholds, cure conditions, account structure, waterfall order, distribution rules |
| Recourse and guaranties | 25 | Type and amount, carve-outs, burndown milestones and formulas, guarantor covenants and reporting |
| Extensions and options | 20 | Number and length, tests, notice windows, fees, rate and amortization changes, hedge requirements |
| Consents and approvals | 25 | Lease thresholds, transfer restrictions, management changes, secondary financing, fees, timelines |
| Release, substitution and supplementals | 20 | Release prices and premiums, post-release tests, substitution rights, supplemental eligibility |
| Insurance and reporting | 25 | Coverage and limits, deductible maximums, carrier ratings, reporting deliverables, deadlines and formats |
Rate mechanics (about 30 fields)
Index and tenor, lookback and observation method, business day convention, daycount, floor and ceiling, spread step-ups by period, rate reset frequency, rounding, in-advance versus in-arrears, fallback provisions. Every one changes the interest calculation. See floating-rate re-amortization and SOFR tracking.
Amortization (about 20 fields)
Type (mortgage style, straight line, step-up, step-down, agency floater, fixed payment, partial IO, custom), schedule start, IO expiry, re-amortization triggers, balloon calculation, scheduled paydowns. See interest-only expiry planning.
Prepayment (about 40 fields)
Lockout end, open period start, prepayment type by period (lockout, flat percentage, step-down schedule, spread maintenance, yield maintenance, make-whole, swap breakage, defeasance), reference rate and lookback for yield maintenance, discounting method, minimum penalty, notice requirements, partial prepayment rules, prepayment on casualty or condemnation. See real-time prepayment calculations.
Covenant tests (about 60 fields)
For each test: metric, threshold, measurement period, test frequency, and every revenue, expense and debt service adjustment the lender applies. Cure rights and consequences. See DSCR and debt yield tests with lender-specific adjustments.
Hedge requirements (about 25 fields)
Required instrument, strike, notional, term, counterparty rating minimum, replacement timing, replacement escrow formula, assignment requirements, existing hedge terms. See hedge requirements.
Escrows and reserves (about 30 fields)
Each reserve’s purpose, funding formula, cap, springing conditions, disbursement conditions and deadlines; repair schedules with completion dates. See escrows, reserves and repair schedules.
Cash management (about 20 fields)
Trigger events with thresholds, cure conditions, account structure, waterfall order, borrower distribution rules. See cash management triggers and cash sweeps.
Recourse and guaranties (about 25 fields)
Type and amount per guaranty, carve-outs, burndown milestones and formulas, guarantor financial covenants and reporting. See recourse and guaranty burndown.
Extensions and options (about 20 fields)
Number and length of extensions, tests, notice windows, fees, rate and amortization changes, hedge requirements per extension. See bridge and debt fund loans.
Consents and approvals (about 25 fields)
Lease approval thresholds, transfer restrictions, management change rules, secondary financing prohibitions, fee schedules, processing timelines. See lender consent requirements.
Release, substitution and supplementals (about 20 fields)
Release prices and premiums, post-release tests, substitution rights, supplemental loan eligibility and combined tests. See partial release provisions and supplemental loans.
Insurance and reporting (about 25 fields)
Coverage types and limits, deductible maximums, carrier rating requirements, reporting deliverables with deadlines and formats.
Critical dates (derived)
Every date above rolled into a calendar with alerts. See loan critical date tracking.
A worked example: what the extra fields caught
A bank loan closed in 2022 and amended in 2024. The fifty-field abstract from closing shows a $19 million balance, 1-month Term SOFR plus 240, a 2027 maturity, 25-year amortization, and a 1.25x DSCR covenant. The owner’s spreadsheet carries exactly that.
The 400-field abstract, done in 2026 including the amendment, adds the following, each of which changed a decision that year:
- The amendment extended maturity to 2028 and added a 0.50% floor. The spreadsheet had the wrong maturity and was projecting interest below the floor.
- A springing cash sweep at 1.15x DSCR on the lender’s definition, which excludes tenants within six months of expiry. The largest tenant expires in seven months. The sweep is one month from springing and the owner had not started the renewal.
- A swap with the same bank on $15 million of the balance, with breakage included in the prepayment cost. The swap is $380,000 in the owner’s favor at current rates; a planned partial prepayment would realize it.
- A lease approval threshold of 15% of square footage. A lease under negotiation is 17%.
- Recourse at 50% burning down to 25% at 1.35x DSCR for two consecutive quarters on the lender’s definition. The property has been at 1.38x for three quarters; the burndown was never requested.
- Insurance deductible maximum of $50,000. The current policy carries $100,000.
None of these is exotic. All of them were in the documents. The fifty-field abstract was not wrong; it was silent.
Services versus software
Abstraction services (Realogic, SitusAMC, Springbord and others) deliver an abstract as a document or spreadsheet, typically to a template, priced per loan. They are useful for due diligence and one-time projects. The limitation is that the abstract is static: the fields are not connected to a calculation engine or to live financials, and amendments require a new engagement.
Software platforms vary in how the abstract is produced. Some have the customer enter data to a schema. Some use AI extraction with review. LoanBoss combines the two models: an in-house team of loan specialists abstracts every loan to your specifications, each abstract goes through two rounds of QA, and the fields feed the calculation engine directly, so the prepayment cost, the covenant test and the critical date calendar are live from the day the abstract is complete. Amendments are re-abstracted on receipt. See AI loan document extraction for how AI fits.
Frequently Asked Questions
Do we really need 400 fields on a simple loan?
A simple loan uses fewer. The point is that the schema has a place for every provision, so nothing is dropped because the template lacked a column.
How long does abstraction take?
It is part of LoanBoss onboarding; 92% of clients are fully onboarded within six weeks.
Can we get the abstract out of the platform?
Yes. A sample loan abstract is downloadable on loanboss.com, and customer abstracts are exportable.
Who checks the abstract?
Two rounds of QA by the LoanBoss team, then the customer’s review, then reconciliation against the servicer statement during the first reporting cycle.
What is the difference between an abstraction service and abstraction software?
A service delivers a static document or spreadsheet to a template, priced per loan, and an amendment requires a new engagement. In software the fields feed a calculation engine, so the prepayment cost, the covenant test and the critical date calendar are live, and amendments are re-abstracted on receipt.
Related reading
- Single source of truth for CRE debt
- Implementation timelines and what onboarding should include
- Why Excel breaks for loan portfolios
- Pereview alternatives
- Loan abstract in the glossary
Any solution that does not provide this level of detail is not really a solution. That sentence is on loanboss.com, and it is the standard we hold ourselves to.
Sources
- Public loan abstraction service descriptions from Realogic, SitusAMC and Springbord (accessed September 2026)
- Mortgage Bankers Association, commercial servicing data standards
- LoanBoss sample loan abstract and onboarding guide, loanboss.com