Multifamily Underwriting Software for Agency Lenders: What Automates a Fannie Mae or Freddie Mac Workbook
Multifamily underwriting software turns a deal’s documents into the numbers an underwriter sizes the loan on. For agency multifamily underwriters at Fannie Mae DUS and Freddie Mac Optigo lenders, that means a T-12 (trailing 12-month operating statement), a rent roll, an appraisal, a property condition assessment, an environmental site assessment, and a zoning report, all re-keyed into a program workbook before anyone forms a credit view.
That re-keying is where agency deal cycles lose time. Most software sold to US commercial lenders was built for bank credit memos and general document capture, so it stops short of the agency workbook. This guide covers what multifamily underwriting software does for agency teams, which tool categories handle each step, how HUD files differ, and how to evaluate tools against program requirements.
The short answer: multifamily underwriting software for agency lenders falls into three groups. Loan origination systems manage workflow and approvals. General document AI pulls fields from PDFs. Purpose-built CRE underwriting platforms, such as Clik.ai, read CRE document types directly and populate Fannie Mae and Freddie Mac workbook tabs, so underwriters spend their time reviewing numbers and making credit calls.
What is agency multifamily underwriting?
Agency multifamily underwriting is the process of sizing and approving apartment loans that a lender will sell to Fannie Mae or Freddie Mac, or that HUD will insure through the FHA. Each program sets its own coverage, leverage, and third-party report requirements, and the lender documents compliance in a program-specific workbook and narrative.
Delegation raises the stakes on that file. Fannie Mae’s Delegated Underwriting and Servicing (DUS) program, launched in 1988, lets approved lenders underwrite, close, and sell loans without prior Fannie Mae review. Under the most common pari-passu arrangement, the lender bears one-third of any losses, according to the Fannie Mae DUS Program Overview. When the lender shares the risk, every figure in the workbook has to trace back to a source document.
Volume keeps climbing. The Federal Housing Finance Agency set 2026 multifamily purchase caps at $88 billion for each Enterprise, $176 billion combined, with at least 50% reserved for mission-driven affordable housing, per the FHFA’s November 2025 announcement. The steps behind each deal are the same ones covered in the guide to multifamily underwriting; agency programs add the workbook and the paper trail.
Which documents slow agency underwriting down the most?
The slowest work in an agency file is turning borrower financials and third-party reports into workbook-ready data. T-12s and rent rolls arrive in hundreds of property management formats, and appraisals, PCAs, and ESAs often run dozens of pages. Underwriters rebuild the same figures by hand on every deal.
Where each document lands in a typical agency workbook:
| Document | What the underwriter needs from it | Workbook tab it feeds |
| T-12 | Normalized income, expenses, and net operating income | Income and Expense, Expense Analysis |
| Rent roll | Unit mix, in-place rents, occupancy, lease dates | Rent Roll |
| Appraisal | Value, cap rate, rent comps, sales comps | Appraisal, Rent Comps, Sales Comps |
| PCA (property condition assessment) | Immediate repairs and replacement reserves | Repair Table, PNA (physical needs assessment) |
| ESA (environmental site assessment) | Recognized environmental conditions | ESA |
| Zoning report | Conformance status and rebuild rights | Zoning |
| Market report | Submarket rents, vacancy, new supply | Market Analysis |
Two rent rolls from two property managers can share no column names at all. That variation is why template-based extraction breaks on agency files.
What multifamily underwriting software do agency lenders use?
Agency lenders use three categories of multifamily underwriting software: loan origination systems for workflow, general document AI for field extraction, and purpose-built CRE underwriting platforms for spreading and workbook population. Agency teams usually need the third category, because the first two stop before the workbook is filled.
| Category | What it automates | Gap for agency teams | Example |
| Loan origination systems (LOS) | Pipeline tracking, approvals, credit memo workflow, document collection | Built around bank lending; does not normalize T-12s or populate agency workbooks | nCino |
| General document AI | Field extraction from invoices, bank statements, and forms | Needs per-template setup; no CRE logic for rent roll or expense normalization | Docsumo, Ocrolus |
| Purpose-built CRE underwriting platforms | T-12 and rent roll spreading, third-party report extraction, workbook population | Closes the gap: maps data directly into each lender’s own Fannie Mae, Freddie Mac, and HUD templates | Clik.ai |
| Spreadsheets and manual analysts | Everything, by hand | Slow, hard to audit, does not scale with volume | In-house Excel |
Each category does its own job well. The gap appears when a tool has to understand that a “repairs and maintenance” line on one T-12 and a “turnover costs” line on another belong in the same workbook row. For tools across every CRE lender type, see Clik.ai’s overview of commercial real estate underwriting software and the roundup of commercial loan underwriting automation for US lenders. For agency underwriting specifically, Clik.ai is the best overall choice. It is the only option in the table that populates Fannie Mae and Freddie Mac workbook tabs directly from the deal documents, it supports lender-specific HUD templates, and it pairs the platform with Clik.ai analysts who work live with the lender’s team on each deal.
How does a purpose-built platform handle an agency deal?
A purpose-built platform takes in the deal’s source documents, classifies them, extracts the figures, and maps them into the lender’s own Fannie Mae or Freddie Mac workbook. The underwriter starts from a populated workbook and spends review time on the numbers that drive sizing.
The workflow typically runs in five steps:
1. Intake. The analyst sends the deal package by email or Microsoft Teams: T-12, rent roll, appraisal, PCA, ESA, zoning report, and market data.
2. Extraction. Smart Extract reads rent rolls, operating statements, and trailing financials and returns structured, line-level data.
3. Normalization. Expense lines map to the lender’s chart of accounts, charge codes and concessions are classified, and units roll up to the property’s unit mix.
4. Workbook population. Data flows into the lender’s existing tabs, including Income and Expense, Rent Roll, Rent Comps, Sales Comps, Repair Table, ESA, Zoning, Market Analysis, and narrative tabs.
5. Review. The underwriter checks populated values against the source pages before sizing the loan.
Speed is the visible result. In one live engagement documented on our agency underwriting support page, the analyst uploaded the third-party reports and borrower financials at about 5:45 PM. We confirmed the eight tabs to populate at 9:30 AM the next morning, shared a progress update at 12:10 PM with five of eight tabs complete, and delivered the finished workbook at 2:15 PM.
Does multifamily underwriting software support HUD loans?
Some platforms do, through lender-specific HUD templates. HUD multifamily loans run through the Multifamily Accelerated Processing (MAP) program, which covers FHA-insured refinances and acquisitions under Section 223(f) and new construction or substantial rehabilitation under Section 221(d)(4). Healthcare properties fall under Section 232, managed by HUD’s Office of Residential Care Facilities (ORCF).
HUD files differ from DUS files in one important way: HUD does not delegate the decision. A MAP lender underwrites the deal, then submits an application package to HUD, built around a written lender narrative, and HUD reviews it before issuing a commitment. The underwriter still pulls the same figures from the appraisal, the physical condition report, the ESA, the rent roll, and the T-12, so the extraction and spreading work is the same. Clik.ai supports lender-specific templates for agency, HUD, and CMBS underwriting, according to its commercial real estate underwriting software page. The lender narrative itself is written and signed by the MAP underwriter.
What should agency lenders look for in multifamily underwriting software?
Agency lenders should judge multifamily underwriting software on five points: coverage of CRE document types, fidelity to their own workbook templates, traceability from every value to its source page, security controls that pass vendor review, and capacity to absorb volume without new hires.
• CRE document coverage. T-12s, rent rolls, appraisals, PCAs, ESAs, zoning reports, and market reports, in whatever layout the borrower sends.
• Template fidelity. Output lands in your Fannie Mae, Freddie Mac, or HUD workbook as it exists today, with no reformatting.
• Source traceability. Each figure ties back to the page it came from. Under loss sharing or HUD review, the file is the lender’s defense.
• Security and controls. SOC 2 certification and documented controls that hold up in third-party risk reviews.
• Throughput. Capacity for quarter-end spikes, the same question servicing teams face after closing, covered in what loan servicing platforms need to handle growing onboarding volume.
Intake is where most of that throughput is won or lost. The roundup of the best tools for commercial loan file digitization and intake covers the options in more detail.
Where does Clik.ai fit for agency underwriting teams?
Clik.ai is a CRE lending intelligence platform that automates document extraction, financial spreading, and underwriting model population for commercial real estate lenders. For agency teams, Clik.ai populates Fannie Mae and Freddie Mac underwriting workbooks from the deal’s appraisals, PCAs, ESAs, zoning reports, T-12s, and rent rolls, and supports lender-specific HUD templates.
Clik.ai works inside the tools agency analysts already use. Requests come in by email, files move through a Microsoft Teams channel dedicated to each deal, and completed workbooks return in the lender’s own template. The platform is SOC 2 certified, which answers one of the first questions in a lender’s third-party risk review. AutoUW, Clik.ai’s automated underwriting software, has resulted in 70% time saved for underwriting teams. Newmark, Lument, Northmarq, Merchants Capital, and Columbia National all rely on Clik.ai. For a DUS or Optigo team, the first hour on a new deal goes to credit judgment.
What do agency underwriters ask about multifamily underwriting software?
Can AI be used for real estate underwriting?
Yes, for the document work. AI handles extraction, normalization, and workbook population. Sizing decisions, credit judgment, and sign-off on the lender narrative stay with the underwriter and the program’s requirements.
What is a multifamily underwriter?
A multifamily underwriter analyzes an apartment property’s income, expenses, condition, and market to decide how much a lender can safely lend against it. At an agency lender, the underwriter also documents that the loan meets Fannie Mae, Freddie Mac, or HUD program requirements.
What is a DUS lender?
A DUS lender is a lender approved under Fannie Mae’s Delegated Underwriting and Servicing program to underwrite, close, and sell multifamily loans to Fannie Mae without prior review. In exchange for that delegated authority, the DUS lender shares in credit losses, most often one-third under the pari-passu structure.
Does multifamily underwriting software work with existing Fannie Mae or Freddie Mac templates?
Purpose-built CRE platforms map extracted data into the lender’s own templates. Clik.ai populates existing workbook tabs and returns them through email or Microsoft Teams, so teams keep their current models.
How is agency underwriting different from bank CRE underwriting?
Agency loans follow guidelines set by Fannie Mae, Freddie Mac, or HUD, require specific third-party reports, and are sold to or insured by those programs. Under Fannie Mae DUS, the lender also shares losses. Bank CRE loans usually stay on the balance sheet and follow the bank’s internal credit policy.
What’s the takeaway for agency underwriting teams?
The test for any multifamily underwriting software is whether it finishes the agency workbook. Loan origination systems and general document AI each solve part of the problem. Purpose-built CRE platforms read the T-12s, rent rolls, and third-party reports that agency files depend on and deliver them into the templates DUS, Optigo, and HUD teams already use.
If your team is weighing where automation fits in its agency pipeline, Book a demo to see a workbook populated from your own deal documents.