Preparing a self-storage move-in and move-out summary for financing
A move-in/move-out summary is one of the most operationally revealing documents a self-storage sponsor can prepare for a lender. This guide explains how to build a clean, auditable record of unit turnover, reconcile it with the rent roll and trailing operating statements, and present it in a way that supports the property's income story.
A move-in/move-out summary is one of the most operationally revealing documents a self-storage sponsor can prepare for a lender. This guide explains how to build a clean, auditable record of unit turnover, reconcile it with the rent roll and trailing operating statements, and present it in a way that supports the property's income story.
A self-storage financing request should explain occupancy changes as well as the ending occupancy position. A unit-level move-in and move-out summary can help reconcile activity with dated rent rolls and operating statements. State the reporting period and source basis, and ask the actual lender which history and format it requires. The workpaper is supporting evidence, not a financing approval. [1]
What a move-in and move-out summary should contain
The summary is a log of unit-level activity. For each event, record the unit number, the event date, the event type (move-in or move-out), the rent at the time of the event, and any concession or discount applied. If the property uses a management software that exports this data, use that export as the starting point. If the records are kept manually, compile them into a spreadsheet with one row per event.
Choose a reporting period that can be reconciled to the other financial information. If using a trailing twelve-month period, show each month and the cutoff date; confirm the lender's actual request. The move-in and move-out summary is not a replacement for the T-12 operating statement, but it is the operational counterpart that explains the revenue line items in that statement.
Reconciling the summary with the rent roll
The rent roll is a snapshot of the property on a single date. It shows which units are occupied, at what rent, and which are vacant. The move-in and move-out summary, by contrast, is a historical record of changes over time. To reconcile them, pick the last day of the T-12 period and compare the rent roll on that date to what the summary would predict.
Start with the unit count. The rent roll should show a total number of rentable units. The summary, when you add up all move-ins and subtract all move-outs over the twelve months, should produce the same net change in occupied units as the difference between the beginning and ending rent rolls. If it does not, there is a gap in the records that needs to be found and corrected.
Next, compare the rent amounts. For each occupied unit on the ending rent roll, the rent shown should match the most recent move-in or rent-change event in the summary. Any discrepancy may indicate a data entry error, an unrecorded rent change, or a concession that was not captured in the summary.
A suggested way to prepare this reconciliation is to create a simple workpaper: a spreadsheet with columns for unit number, beginning rent roll status, ending rent roll status, move-in events, move-out events, and a check column that flags any unit where the numbers do not balance. This workpaper is not a lender requirement, but it is a practical tool for catching errors before the lender sees the file.
Reconciling the summary with the trailing twelve-month operating statement
The operating statement (the T-12) reports total rental income each month. The move-in and move-out summary, when combined with the rent roll at the start of each month, should produce a calculated rental income that matches the T-12 line item.
To do this, for each month in the T-12, calculate the expected rental income as follows: take the rent roll at the beginning of the month, add the rent from any move-ins during the month (prorated if the move-in occurred mid-month), and subtract the rent lost from any move-outs during the month (again prorated). The result should equal the gross potential rent for that month, before any concessions or discounts. Then subtract any concessions or discounts recorded in the summary to arrive at the gross collected rent, which should match the T-12's rental income line.
If the calculated amount does not match the T-12, identify the source of the difference. Common causes include unrecorded rent changes, concessions that were not logged in the summary, or timing differences between when a move-out is recorded in the summary and when the unit is actually vacated and re-rented. [1] The OCC Commercial Real Estate Lending handbook notes that environmental contamination can hurt a property's usability and result in the loss of tenants and reduction in rental income, but for self-storage the more immediate risk to income is operational: inaccurate or incomplete records make it difficult for a lender to underwrite the property's cash flow. [1]
Distinguishing gross rent, collected income, and net operating income
A move-in and move-out summary directly supports the calculation of gross rent. But a lender's underwriting focuses on net operating income (NOI), which is gross collected income minus operating expenses. The summary alone does not produce NOI, but it is essential for verifying the gross collected income component.
Gross rent is the total rent that would be collected if all units were occupied at their posted rates. Gross collected income is what the property actually received after vacancies, concessions, and bad debt. The difference between the two is often called rental loss. The move-in and move-out summary, when reconciled with the rent roll, provides the unit-level detail to calculate rental loss.
Show cash flow after capital expenditures and debt service as a separate measure; these deductions should not be silently relabeled as NOI. Capex items, such as replacing unit doors or paving the driveway, are not captured in the move-in and move-out summary, but they affect the property's condition and, over time, its ability to attract and retain tenants. The summary shows turnover patterns, which can inform whether capex is needed to reduce vacancy or improve rent levels.
How the summary affects the financing discussion
A clean, reconciled move-in and move-out summary signals to a lender that the sponsor understands the property's operations and has reliable records. [2] A well-prepared summary is one of those materials, and presenting it in a clear, auditable format reduces the number of follow-up questions from the lender.
Conversely, a summary that does not reconcile with the rent roll or the T-12 raises questions about the reliability of the entire operating history. [1] The OCC handbook discusses operational risk, noting that insufficient staffing or lack of staff expertise can increase operational risk, and examiners assess operational risk by evaluating the adequacy of governance and risk management. [1] While the OCC's guidance is addressed to banks, the same principle applies to a sponsor's preparation: a lender may view a poorly prepared file as an indicator of higher operational risk, which could affect the terms offered or the lender's willingness to proceed.
Practical steps to prepare the summary
- Export or compile the unit activity log for the trailing twelve months. Include unit number, event date, event type, rent amount, and any concession.
- Create a rent roll snapshot for the first and last day of the T-12 period.
- Reconcile the summary with the rent roll by comparing unit counts and rent amounts.
- Calculate the expected monthly rental income from the summary and compare it to the T-12 operating statement.
- Identify and resolve any discrepancies. Common fixes include correcting data entry errors, adding missing concessions, or adjusting for timing differences.
- Present the summary as a single document with the reconciliation workpaper attached.
FAQs
How far back should the move-in and move-out summary go?
Ask the lender which reporting period it needs and make the summary's start and end dates explicit. If the property has been owned for less than twelve months, cover the entire ownership period and note the date of acquisition. The lender may also ask for any available records from the prior owner.
What if my records are incomplete or I find discrepancies?
Document what you have and note any gaps or discrepancies. A lender would rather see an honest summary with explained gaps than a polished document that does not match the operating statements. Use the reconciliation workpaper to show where the numbers do not balance and what steps you took to resolve the issue.
Does the move-in and move-out summary replace the rent roll or the T-12?
No. The summary is a supporting document that reconciles the rent roll and the T-12. All three are typically part of the loan request package. The summary provides the unit-level detail that explains the revenue line in the T-12 and the occupancy changes in the rent roll.
If you are preparing a self-storage financing request and want to discuss how to present the move-in and move-out summary alongside the rest of the package, send us the property, the business plan, and the capital you need. We will tell you how we would approach it.
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.
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.
Requests are reviewed by Wraith Real Estate, a commercial real estate debt advisor (not a lender).