Commercial Real Estate Due Diligence Checklist for Lenders
A commercial real estate due diligence checklist for lenders covers four areas: property cash flow (rent roll, T-12, leases, estoppels), collateral (appraisal, environmental, property condition, title and zoning), the borrower and sponsor (financials, credit, KYC) and legal documents. Each finding ties back to DSCR, LTV and debt yield, and every exception is recorded in the credit memo. Clik.ai helps US lenders automate the cash flow portion by turning rent rolls and operating statements into underwriting-ready data.
One misread rent roll or an overstated NOI can turn a performing CRE loan into a watch-list asset, yet most lender diligence still runs on PDFs, spreadsheets and long email threads. This checklist sets out the documents and verification steps, then covers the tools that automate intake, rent roll digitization, spreading and underwriting.
The Lender Due Diligence Checklist
Property and cash flow
Cash flow verification starts with four documents:
| Document | What it answers |
|---|---|
| Rent roll | Contractual income by unit or suite |
| T-12 operating statement | What was collected and spent over the last 12 months |
| Executed leases | Rent, escalations, free rent and expiration dates |
| Tenant estoppels | What tenants confirm about their own leases |
Reconcile the rent roll to the T-12 first, because the gap between them is where most underwriting errors begin. Then match in-place rents to lease terms and normalize NOI: apply a market vacancy factor, account for concessions and bad debt, include replacement reserves, and impute a management fee even when the sponsor self-manages. The aim is to rebuild NOI from verified documents. Our guide to reading and normalizing a T-12 covers that step.
Collateral
- Appraisal and valuation support
- Phase I environmental site assessment
- Property condition assessment
- Title commitment and ALTA survey
- Zoning report and certificate of occupancy
- Insurance certificates and coverage review
Every finding should tie back to the core credit tests of DSCR, LTV and debt yield. The OCC’s Commercial Real Estate Lending handbook treats these as complementary measures, so no single metric decides the loan.
Borrower and sponsor
- Sponsor financials and personal financial statements
- Two to three years of tax returns
- Schedule of real estate owned
- Liquidity and net worth tested against guarantor covenants
- Credit reports, plus KYC and OFAC screening on every principal and entity in the ownership chain
Legal
- Formation documents, operating agreements and signing authority
- Guarantees
- Existing debt and any intercreditor arrangements
- SNDAs for major tenants
Record every exception in the credit memo. A file that explains why an exception was accepted can withstand examination, and an unexplained one invites findings.
Automating Due Diligence: How the Tools Compare
Software categories
Lenders usually assemble a stack from five categories:
- Loan origination systems (LOS) handle pipeline workflow, approvals and document tracking.
- Document intake and OCR platforms collect files through borrower portals and classify them.
- Automated financial spreading tools pull data from tax returns, bank statements and financial statements into lender templates.
- CRE underwriting and NOI modeling tools normalize income and size the loan.
- Rent roll digitization tools turn rent rolls in different formats into structured data.
Evaluation criteria
Test any of them on your own files, using vendor samples only as a first look.
| Criterion | Why it matters to credit teams |
|---|---|
| Extraction accuracy on rent rolls and T-12s | Errors carry straight into NOI and loan sizing |
| Document classification | Removes manual sorting of large loan packages |
| Bank statement and tax return spreading | Speeds up sponsor and guarantor analysis |
| Cash flow analysis and credit memo inputs | Shortens the step from data to approval |
| Integration with core and LOS systems | Avoids re-entering data across platforms |
| Audit trails and scalability | Holds up to examiner review as volume grows |
Where Clik.ai Fits
Most lender stacks break at the handoffs. Intake runs in one system, spreading in another, and the underwriting model sits in an analyst’s Excel file. We close those gaps. Loan Setup digitizes the loan file, rent roll processing and Smart Extract pull rent roll and operating statement data into a standardized schema with 99% accuracy, and AutoUW spreads the financials into your underwriting template.
| Dimension | Manual workflow | Point solutions | Clik.ai |
|---|---|---|---|
| Speed | Days per deal on data entry | Faster per task, slowed by handoffs | 24-hour turnaround from intake to underwriting-ready data |
| Accuracy | Rekeying errors build up | Varies by tool | 99% accuracy, with every value traceable to its source |
| Consistency | Depends on each analyst | Formats differ between tools | One schema across every deal |
| Portfolio reporting | Rebuilt by hand each quarter | Fragmented | Structured data ready for analysis |
Analysts stop retyping numbers and spend that time on credit judgment, the work that protects the portfolio.
Closing the Gap Between Diligence and Scale
A rigorous checklist protects credit quality. Applying it consistently across hundreds of loans takes automated intake, extraction and spreading tied directly to underwriting, and ongoing monitoring of rent rolls and cash flow is only practical when that data is already structured. Book a Clik.ai demo and we will turn your own rent rolls and T-12s into underwriting-ready data.
Frequently Asked Questions
What tools automate CRE underwriting?
US lenders usually pair an LOS with AI document extraction, automated spreading and NOI and cash flow modeling. Unified platforms such as Clik.ai cut the handoffs and rekeying that slow underwriting and introduce errors. Our CRE underwriting services page covers how we support lender due diligence.
Which tools automate loan intake?
Intake automation combines borrower portals, OCR and document classification. These tools collect, sort and extract data from loan file documents before underwriting starts.
How do you digitize rent rolls?
Use extraction software that converts PDF and Excel rent rolls into a standardized schema and reconciles them against the leases. Flag expired leases, rent outliers and unit count mismatches before the data feeds NOI calculations.