Can I Afford This Property?Commercial real estate financing, worked out

Preparing a financing data-room index with document dates and owners

A practical guide to building a data-room index that tracks document dates and owners, helping sponsors present a complete, organized financing package to lenders.

Source: CodexTopic: Financing process and document control1163 wordsUpdated 2026-11-19

A practical guide to building a data-room index that tracks document dates and owners, helping sponsors present a complete, organized financing package to lenders.

The purpose of a data-room index

A data-room index is a master list of every document a lender will review during underwriting. It records what each document is, the date it was created or last updated, and who prepared or owns it. The index serves as a map for the lender and a checklist for the sponsor. When a lender asks for the rent roll, the index tells you which version you sent and when. Without an index, documents can be misfiled, outdated, or duplicated, and the lender may assume the file is incomplete.

Bank supervisory guidance includes questions for banks about whether they maintain safeguards to protect notes and other documents and whether they use a check sheet to ensure required documents are received and on file [1]. While this guidance is directed at banks, the same logic works for sponsors preparing a package. A well-organized index shows the lender that the sponsor has control over the information and reduces back-and-forth requests.

What to include in the index

The index should list every document the lender will request. For a typical commercial real estate financing, these include the business plan, sources and uses of funds, development budget and schedule (for construction), rent roll and trailing twelve months of operating statements (for existing properties), pro forma with assumptions, sponsor’s schedule of real estate owned, financial statements for principals and guarantors, and organizational documents for the borrowing entity [2].

For each document, record the following columns: - Document name (as it will be referred to in the loan request) - Date of document (the date it was prepared or last updated) - Owner (the person or entity who prepared or maintains it) - File name or location (the actual file name in your data room) - Status (draft, final, or updated)

A suggested way to prepare this information is to create a spreadsheet with these columns. This is not a mandatory lender process, but it helps you track what you have and what is missing.

Distinguishing current and historical financials

A common mistake is mixing current and historical financial data. A current rent roll is a snapshot of the property’s tenants, occupancy, and rental rates as of a specific date. A trailing twelve months (T-12) of operating statements shows twelve historical months of income and expenses. The timing difference matters. The rent roll shows what is happening now, while the T-12 shows what has happened over the past year. Comparing totals from the two without adjusting for timing can produce misleading results.

When you prepare the index, record the date of the rent roll and the period covered by the T-12. For example, the rent roll might be dated March 31, 2025, while the T-12 covers April 2024 through March 2025. This allows the lender to see the relationship between current occupancy and historical performance.

Key financial metrics to track in the index

The index should also note which financial metrics are derived from each document. Common metrics include gross rent, collected income, net operating income (NOI), capital expenditures, debt service, and equity cash flow. These are not the same. Gross rent is the total rent billed, while collected income is what the landlord actually receives after vacancies and bad debt. NOI is collected income minus operating expenses, before debt service and capital expenditures. Capital expenditures are major improvements that are not expensed annually. Debt service is the principal and interest payments on the loan. Equity cash flow is what remains after all expenses, debt service, and capital improvements.

Debt yield is a metric lenders may calculate from NOI and loan amount [1]. The index can include a note that the debt yield is calculated from the NOI in the operating statements and the requested loan amount. This is not a mandatory field, but it helps you see how the lender will size the loan.

Organizing by document type and owner

Group documents by type. For example, place all financial statements under a “Financial” section, all legal documents under a “Legal” section, and all property reports under a “Property” section. Within each section, list documents by owner. The sponsor’s financial statements are owned by the sponsor. The rent roll is typically owned by the property manager. The appraisal is owned by the appraiser. Recording the owner helps you know who to contact if the lender needs an updated version.

Bank supervisory guidance includes a question for banks about whether responsibility for document files has been established [1]. While this guidance is for banks, the same principle applies to sponsors. Assign one person to maintain the index and update it as documents are added or revised.

A concrete workpaper: the document status tracker

Prepare a document status tracker as a spreadsheet. The tracker should have the following columns: - Document name - Date of document - Owner - File name - Status (draft, final, updated) - Notes (e.g., “waiting for updated T-12” or “appraisal scheduled for May 15”)

This tracker is a concrete workpaper you can prepare and share with the lender. It is not a mandatory lender process, but it shows the lender that you have a systematic approach to document control.

How the index affects the financing discussion

The index affects the financing discussion in several ways. First, it shows the lender that you are organized and prepared, which can reduce the time it takes to underwrite the loan. Second, it helps you identify gaps in your documentation early. If you are missing a rent roll or a T-12, you can address it before the lender asks. Third, it allows you to track which documents the lender has reviewed and which are still pending.

Bank supervisory guidance includes questions about whether loan commitments are issued in written form and whether loan officers are prohibited from processing loan payments [1]. While these are internal bank controls, they underscore the importance of documentation. A complete and organized data room helps the lender follow its own procedures.

Common questions about the data-room index

What if a document is updated after the index is created?

Record the new date and owner in the index. Keep the old version in the data room with a note that it has been superseded. The lender may want to see the history of changes.

How often should the index be updated?

Update the index whenever a document is added, removed, or revised. A suggested way to prepare this is to set a recurring reminder to review the index weekly during the financing process.

Who should maintain the index?

Assign one person on the sponsor’s team to maintain the index. This person should be familiar with all the documents and able to answer the lender’s questions about them.


If you would like to discuss your property, business plan, amount, and timing, visit the website to request financing. Submission is a preliminary request, not an engagement or lender submission.

Run the numbers on your deal

Try your own NOI, value and lender tests to see which one limits the loan: DSCR, LTV or debt yield.

Open the loan sizing calculator

Talk through your financing

Working on a real property? Send us the deal and a financing advisor will review it and get back to you. It costs nothing to ask and does not commit you to anything.

Contact us

Requests are reviewed by Wraith Real Estate, a commercial real estate debt advisor (not a lender).

Sources

  1. OCC Commercial Real Estate Lending handbook
  2. Wraith commercial real estate debt