Skip to main content

Apartment income evidence

Multifamily acquisition review: connect rent to collections

A multifamily screen becomes useful when the rent roll, operating statement and collections describe the same units and period. Start with that reconciliation before asking AI to estimate value or identify upside. The practical output is a record of contractual rent, concessions, unpaid balances and actual receipts, with each difference assigned to a document request.

NextAutomation editorial research method. Public sources establish the framework; the worksheet example is fictional and no property has been verified.

Conceptual illustration of apartment rent rolls, concessions and collections

What changes the decision

Read the operating model before the headline

01

Occupied does not mean collected

The OCC’s CRE handbook distinguishes reported occupancy from actual rent collections. Use this as the starting question for an apartment review. A tenant can occupy a unit while carrying an unpaid balance, and a deposit can reach the bank without being earned rent. Preserve both the unit status and the accounting treatment.

Source 1
02

Time is part of the evidence

A current rent roll cannot explain an entire trailing year by itself. Ask for monthly snapshots, the dates of ownership or management changes and the period covered by each ledger. Renovations, concessions and write-offs should remain attached to the month in which they occurred rather than being smoothed into a favorable average.

03

Keep the improvement thesis separate

A proposed renovation premium is an assumption until supported by relevant achieved leases and the work required to deliver them. Separate current collections, documented completed turns and proposed future changes. AI can connect invoices and lease references, but it should not treat an asking rent as an achieved rent or quietly erase vacancy during construction.

Keep these separate

Three distinctions to preserve in the file

Evidence or situationWhat it tells youWhat to establish next
Scheduled rentContractual or system charges before adjustmentsTrace concessions, credits and unpaid balances into the same-period ledger.
Cash receivedReceipts may include deposits, arrears or non-rent itemsIdentify the receipt period and accounting classification before comparing it with charges.
Proposed premiumA future leasing assumptionObtain completed-turn costs and comparable executed leases without counting the proposal as current income.
Conceptual illustration of apartment rent rolls, concessions and collections

A practical review sequence

Build a file another reviewer can follow

Use the sequence below to turn the initial description into specific document requests. Preserve contradictory records instead of choosing the more favorable version.

  1. Freeze the review period

    Choose a month-end and the trailing period to be reviewed. Record unit IDs consistently across the rent roll, delinquency schedule and ledger. Flag units that appear in only one file. Do not resolve a missing unit by deleting it from the property inventory.

  2. Trace a small set of exceptions

    Start with a vacant unit, a concession, a past-due account and a recent renewal. Follow each from lease to charges to cash and adjustment entries. Expand the review if these samples reveal inconsistent treatment; a small sample is a diagnostic, not proof of the entire ledger.

  3. Separate recurring and unusual items

    Ask the accountant to explain reimbursements, insurance proceeds, one-time repairs and capitalized work. Preserve the reported statement before creating an adjusted view. Every adjustment needs a reason and evidence location so another reviewer can reproduce the bridge instead of accepting a model’s unexplained normalization.

  4. Build the next request list

    Group missing evidence by owner: manager for unit status, bookkeeper for collections, leasing team for concessions and contractor for turn invoices. Export the worksheet with unresolved differences intact. A clean document list is a useful next step even when the information cannot yet support a dependable operating baseline.

Questions that arise during review

Resolve the ambiguity before the model

Can AI read a rent roll safely?

It can organize supplied fields and flag mismatches when the file is legible. Review extracted dates, unit IDs and amounts against the original, especially merged cells and handwritten notes. Do not upload resident personal information merely to test the workflow.

Should a concession be removed from rent?

Record its contractual terms and accounting treatment first. A one-time concession and a recurring discount can produce different comparisons. Ask the accountant to reconcile the lease, ledger and cash before adopting an adjusted income figure.

Does this kit calculate NOI?

No. It prepares the evidence needed for a later operating model. It does not choose capitalization rates, forecast rent increases or certify financial statements. The useful result is a specific explanation of what matches, what conflicts and what is still missing.

From the page to your next task

Start with the useful output.

Monthly rent-to-receipts exception bridge

Build an editable monthly rent-to-receipts exception bridge, retain document references and open decisions, then export your team's working file.

Scope: apartment rent rolls, concessions and collections

Bring
An optional file nickname Status, observations and document references for the four evidence items; unknown is acceptable
Leave with
Monthly rent-to-receipts exception bridge with editable, expandable records and document locators Two fictional worked rows showing mismatches and decisions to review CSV and readable text exports with row provenance, method sources and edition A separate document-request companion with suggested reviewers

Edition 2026-09-30.1

Put the reviewed inputs to work

Continue with a relevant template.

The Complete Claude Playbook: Multi-Family Underwriting

Use the apartment playbook’s normalization workflow when reconciling a rent roll, T12 and offering memorandum. Keep source periods and unresolved collection differences visible; an analyst must verify the figures before using the first-pass model.

Explore the existing resource ↗

Evidence and scope

Follow each claim to its source.

Commercial Real Estate Lending, Comptroller’s Handbook, version 2.0

Office of the Comptroller of the Currency · Checked 2026-09-30

March 2022 supervisory handbook; lease review, property income, re-leasing costs and property-type distinctions.

  • Bank supervisory guidance, not a property appraisal, current market survey or universal financing standard. No handbook percentage is adopted as a deal assumption.
Open original source ↗