Skip to content
       

Blog

Quarterly Lender Reporting Package: T-12, Rent Roll and What You Certify

Quarterly Lender Reporting Package: T-12, Rent Roll and What You Certify

A quarterly lender reporting package commonly includes:

  • an operating statement for the quarter and the year to date, often including a trailing twelve months, or T-12

  • a current rent roll

  • leasing or occupancy summaries, where the loan requires them

  • covenant reporting, where the loan requires it

  • a certificate signed by an officer of the borrower, where the loan requires one

The loan agreement sets the exact contents and deadline, often 45 days after the quarter ends. Every number should tie to the books, because someone signs to say it's true.

For example: it's day 41 after quarter-end, and the lender wants the package by Friday.

The controller has the operating statement from the general ledger. The rent roll came from the leasing system, exported on a different day. And the lender will calculate the debt service coverage ratio using the loan agreement's definition of income, not the one the asset management team uses.

Three documents, three sources, one signature. The controller is the person signing.

That's what makes the lender package different from internal reporting. Internal reports can be revised next month. The lender package gets certified.

What's usually in a lender reporting package?

Loan agreements differ, but publicly filed agreements show a consistent pattern:

Page

What it shows

What it should tie to

Operating statement

Revenue, operating expenses, net operating income (NOI) and net cash flow, for the quarter and year to date

The closed general ledger

T-12

The same lines for the last twelve months

Twelve closed months

Rent roll

Each tenant, current rent, lease expiry, and the share of space leased, as of the last day of the quarter

Billed rent in the ledger, as of the same date

Leasing and occupancy summaries

Current and upcoming lease activity, and occupancy

The rent roll

Budget variances

Material differences from the property's operating budget

The approved budget

Covenant reporting

Calculations such as the debt service coverage ratio, where the loan requires them

The loan agreement's own definitions

Officer's certificate

A signed statement that the package is accurate

The reports it covers

The example sources for these rows are filed loan agreements:

  • Operating statement: one requires a current rent roll and a detailed operating statement within 45 days of each quarter, showing revenue, operating expenses, operating income and net cash flow.

  • Rent roll: another requires a rent roll showing the percentage of space leased, the current annual rent and each lease's expiry date.

  • Leasing summaries and variances: others require leasing status reports and occupancy summaries, and operating statements that note material variations from the property's budget.

When is it due?

Your loan agreement says, and the deadlines vary. Examples in filed loan agreements include:

  • Quarterly: 45 days after the quarter ends, for the operating statement and rent roll.

  • Annually: 90 days after year-end for annual statements. Some loans allow longer for the final quarter, such as 120 days.

  • Monthly: some loans also require a monthly rent roll and operating statement, within 20 days of month-end.

Put every loan's deadlines in one calendar. A portfolio with ten loans can have ten different reporting schedules.

What exactly does the signer certify?

This is the part that makes the package personal. Certificates in filed loan agreements typically say that:

  • the financial statements fairly represent the borrower's financial condition and results in all material respects

  • no event of default exists, or, if one does, what it is and what's being done about it

  • the rent roll is true, correct and complete in all material respects as of its date

Who signs depends on the loan. One agreement requires certification by the borrower's chief financial representative. Another requires it from the portfolio account controller.

Either way, the signature attests that the numbers are accurate, not just that they were produced.

The tie-out sequence

This is the framework: seven steps, in order, so the signature rests on numbers that agree.

1. Close the quarter first. Build the package from a closed period. Figures from an open period can change after they're sent.

2. Align the dates. Run the rent roll as of the last day of the quarter, the date the operating statement's period ends. A rent roll from a different date gives a different answer.

3. Tie the rent roll to billed rent. Each tenancy on the rent roll should match its billing in the ledger, allowing for documented concessions, prorations and amendments. RIOO's guide to month-end rent roll reconciliation covers the checks.

4. Build the T-12 from closed months only. Add a short note for anything unusual in the twelve months, such as a one-off repair, a tax refund or a lease termination fee, so the lender doesn't treat it as a trend.

5. Calculate covenants the lender's way. Use the loan agreement's definitions of income, expenses and debt service, not your internal ones. Swara's guide to real estate portfolio analytics covers DSCR as a covenant metric.

6. Explain the variances. Where the loan requires it, note material differences from budget before the lender asks.

7. Review, then sign. The signer should see the tie-outs, not just the final pages.

Where do lender packages usually break?

Break

Why it happens

The fix

The rent roll and operating statement disagree

They were run on different dates, from different systems

Run both as of quarter-end, from the same records

The covenant doesn't match the lender's calculation

Internal NOI includes or excludes items differently from the loan's definition

Keep a schedule that rebuilds the figure using the loan's definitions

The rent roll shows rent the ledger never billed

A lease change was entered in leasing but not in billing

Reconcile the rent roll to billing before the package goes out

A property's results land in the wrong entity

The property is mapped to the wrong subsidiary or borrower

Confirm each property's owning entity before the close

Who owns each step?

Step

Usually owned by

Done when

Reporting calendar

Controller

Every loan's deadlines are in one calendar

Quarter close

Property accountant

The period is closed

Rent roll and tie-out

Property accountant, with leasing

The rent roll is dated quarter-end and ties to billing

T-12 and variance notes

Controller

Twelve closed months, with one-offs noted

Covenant calculations

Controller or asset manager

Recalculated using the loan's definitions

Review and certificate

Controller or CFO, as the loan requires

Tie-outs reviewed and the certificate signed

Delivery

Asset manager

Sent by the deadline, with a record of what was sent

What should leadership watch?

Two things across the portfolio:

  • Covenant headroom. How close each loan is to its thresholds, not just whether it passed. A property with a thin margin needs attention before the next quarter, not after.

  • Deadline performance. Packages sent late, or revised after they were sent. Both are worth a conversation with the team before the lender raises them.

And one control question: for the last package you sent, can the team show how the rent roll ties to billing, and how the covenant figure was rebuilt from the loan's definitions, in one file? If those tie-outs live in someone's head, the signature carries more risk than it should.

Where RIOO fits

RIOO is property management software built directly on NetSuite.

  • Reports over live transactions. The rent roll, occupancy and NOI per property come from dashboards over live transactions, so the package draws on the same records the ledger closes from.

  • The right entity, every time. Each property is mapped to its owning subsidiary, so property P&Ls roll up to the right legal entity, which is the one the loan is made to.

Note: This blog is operational guidance, not legal or accounting advice. Every loan sets its own reporting requirements, definitions and deadlines. Last reviewed October 2026. Your loan agreement controls, so confirm the requirements with your lender and counsel.

Frequently asked questions

Q1. What is a lender reporting package?
The set of financial reports a borrower sends its lender on a schedule set by the loan agreement. It typically includes an operating statement, a rent roll, leasing and occupancy summaries, covenant calculations and a signed certificate.

Q2. What is a T-12?
A trailing twelve-month operating statement: income, expenses and net operating income for the most recent twelve months. Lenders use it to see current performance without waiting for the annual statement.

Q3. When is a quarterly lender package due?
Whenever the loan agreement says. In many filed loan agreements, quarterly reports are due 45 days after quarter-end, and annual reports 90 days after year-end, though some loans allow longer for the final quarter.

Q4. What does the officer's certificate say?
Typically, that the financial statements fairly represent the borrower's results in all material respects, that no event of default exists (or what it is), and that the rent roll is true, correct and complete in all material respects.

Q5. Who signs the lender package?
Whoever the loan agreement names, often the borrower's chief financial officer, another officer, or a portfolio controller.

Q6. What does a lender rent roll include?
Usually each tenant, the current rent, each lease's expiry date and the share of space leased, as of the last day of the reporting period. Some loans ask for more, such as subtenants.

Q7. Why doesn't our DSCR match the lender's?
Usually because the loan agreement defines income, expenses or debt service differently from your internal reports. Calculate covenants using the loan's definitions, and keep a schedule that shows the rebuild.

Q8. How is a lender package different from investor reporting?
A lender package follows the loan agreement's requirements and focuses on the property's performance and covenant compliance. Investor reporting serves equity owners and usually covers returns and capital accounts.