Example Rent Roll: 7 Templates for Multifamily Underwriting in 2026

Example Rent Roll: 7 Templates for Multifamily Underwriting in 2026

Discover example rent roll templates for multifamily underwriting—lender-grade, investor-facing, and operational samples to boost your deals.

Domingo Valadez

Mar 5, 2026

Blog

For multifamily investors and syndicators, a deal's success or failure often hinges on the quality of its rent roll. This single document is the financial heartbeat of a property, detailing revenue streams, lease terms, and occupancy status. A disorganized or inaccurate rent roll can obscure critical risks, leading to flawed underwriting and costly mistakes. Conversely, a clear, detailed, and verifiable example rent roll is the cornerstone of confident decision-making.

A flawless rent roll is your most valuable asset, especially when it comes to the rigorous process of financial due diligence for unlocking your next deal. It provides the granular data needed to validate a seller's claims, forecast future performance, and secure financing. Without a solid rent roll, you're essentially flying blind.

This guide moves beyond theory to provide actionable examples and downloadable templates. We will break down several types of rent rolls, from institutional-grade formats required by Fannie Mae and Freddie Mac to user-friendly versions perfect for smaller operators. For each example, we'll provide a field-by-field analysis, strategic insights, and practical takeaways you can apply immediately. You'll find direct links and screenshots to help you find and implement the right format for your underwriting, due diligence, and investor reporting needs. We will explore:

• Unit-level, pro forma, and investor-facing summary examples.
• Common pitfalls and critical validation checks.
• How sponsors use this data to model returns and identify opportunities.

Our goal is to equip you with the tools and knowledge to master the rent roll, turning a simple spreadsheet into a powerful instrument for building your real estate portfolio. Let's dive into the examples that will sharpen your analysis.

1. Fannie Mae Multifamily Rent Roll Template (official)

When your goal is institutional-grade financing, starting with the end in mind is a critical advantage. The official Fannie Mae Multifamily Rent Roll Template is the definitive example rent roll for any sponsor or syndicator preparing for agency debt. It isn't just a random spreadsheet; it's the required format for loan delivery, making it the gold standard for multifamily underwriting.

This template stands out because it removes guesswork. It is built to align with the Commercial Mortgage-Backed Securities (CMBS) industry's C‑MISMO data standards, which means the fields included are precisely what agency lenders need to see. Using it from the outset of your due diligence or asset management can dramatically reduce the back-and-forth that often occurs during the financing process.

Strategic Breakdown & Analysis

The template's structure is intentionally rigid. It prescribes specific tab names, locks header rows, and uses data validation to enforce correct formatting. While this might feel restrictive for simple, internal tracking, its purpose is to ensure data integrity for securitization.

Key Insight: The most significant feature is its explicit handling of Non-public Personal Information (NPI). The template requires tenant names to be left blank, a crucial compliance step that many operators overlook. This demonstrates an institutional understanding of data privacy to potential lenders.

Another key aspect is the clear distinction between required and optional fields. The accompanying guidance document explains what each field means and how to handle common scenarios, like vacant units or corporate leases. This level of documentation is invaluable and far exceeds what you find in generic templates. For a deeper dive into the specific columns and their purpose, you can find a detailed field-by-field breakdown in this comprehensive rent roll example analysis.

Actionable Takeaways

• Prepare for Financing Early: Adopt this template as your master rent roll, even if you aren't immediately seeking agency financing. It forces best practices and prepares your data for future capital events.
• Use the Guidance Document: Don't just download the spreadsheet. Read the official instructions to understand how to correctly input data for items like concessions, other income, and lease terms. This prevents common errors that can slow down underwriting.
• Mind the NPI: Train your property management and acquisitions teams to use this format and always exclude tenant names for any version shared with external parties like lenders or brokers.

This resource is free to download directly from the Fannie Mae website. Its value comes not from its complexity, but from its authority. It's the answer key to the test, given to you before the exam begins.

Website:Fannie Mae Multifamily

2. Freddie Mac Multifamily PRS / CREFC Rent Roll (official)

Similar to its counterpart, Freddie Mac sets a high bar for data integrity through its reporting standards. While not a simple downloadable spreadsheet, the Freddie Mac Property Reporting System (PRS) and its reliance on the CREFC (Commercial Real Estate Finance Council) Investor Reporting Package provides a definitive example rent roll framework. This system is what approved servicers use for ongoing asset management reporting, making its structure a crucial reference for anyone preparing a deal for Freddie Mac financing or servicing.

Understanding these requirements gives sponsors an inside look at the data points servicers track quarterly and annually. The PRS CREFC Bulk Template Desk Reference, though technical, details the required data structure, file naming conventions, and validation logic. Aligning your internal rent roll with these standards means your data will translate seamlessly into the servicer’s system post-closing, demonstrating operational sophistication.

Strategic Breakdown & Analysis

The Freddie Mac approach is less about providing a direct template and more about defining the data standard. The CREFC framework is the key, as it standardizes how property-level data is reported across the industry for CMBS. The PRS system is simply the mechanism through which Freddie Mac ingests this standardized data from its network of servicers.

Key Insight: The biggest takeaway is the emphasis on validation logic. The PRS documentation explains the specific checks the system runs (e.g., ensuring lease start dates are before expiration dates). Adopting these checks into your own spreadsheet models can drastically improve data accuracy and reduce errors during underwriting.

While the primary tools within PRS are login-gated and intended for approved servicers, the publicly available desk reference guides are invaluable. They outline the expectations for rent roll attachments and other financial reporting. This documentation effectively serves as a blueprint for building a servicer-grade rent roll, covering everything from multifamily to healthcare properties.

Actionable Takeaways

• Study the Desk Reference: Even without PRS access, download and review the CREFC reporting documentation. Focus on the required fields and validation rules to build a robust internal rent roll. This prepares you for servicer scrutiny.
• Standardize Your Naming Conventions: The system mandates specific file naming conventions for attachments. Adopting a similar logical approach for your own due diligence files (e.g., PropertyName_RentRoll_YYYY-MM-DD.xlsx) makes your package look professional and easy to navigate.
• Build for the Servicer, Not Just the Lender: Your relationship with the servicer lasts the life of the loan. Providing data in a format they can easily use from day one builds goodwill and makes annual reporting and compliance much smoother.

Accessing the documentation is free via the Freddie Mac website, though the PRS platform itself is restricted. The value here is in reverse-engineering the requirements of a major agency lender's servicing arm. It provides a clear guide to building an institutional-quality rent roll example from the ground up.

Website:Freddie Mac Multifamily

3. Stessa – Free Rent Roll Template

For independent investors and owners of small to mid-sized portfolios, a practical and approachable example rent roll is often more valuable than a complex institutional form. Stessa provides a free, user-friendly template that strikes a perfect balance between necessary detail and simplicity, making it an excellent starting point for new investors or for managing assets not immediately destined for agency debt. It is offered in both Excel and Google Sheets, catering to different workflow preferences.

What makes Stessa’s offering distinct is the educational material that accompanies it. The template download is paired with a clear guide and a pre-filled example that demonstrates how to correctly populate each field. This approach lowers the barrier to entry, allowing owners, new team members, or brokers to quickly understand and adopt a professional format for tracking property performance.

Strategic Breakdown & Analysis

Stessa's template is designed with the private investor in mind. It focuses on the core metrics needed to evaluate an asset's health and communicate its performance to partners, lenders, or potential buyers. The columns are intuitive, covering essentials like unit details, tenant information, lease dates, rent amounts, security deposits, and notes.

Key Insight: The template’s greatest strength is its accessibility. By providing a working example alongside the blank template, Stessa demystifies the process. Users can see precisely how to handle vacant units, pro-rated rent, and other common scenarios without having to guess, which helps ensure data consistency from day one.

While it lacks the strict C-MISMO compliance of the Fannie Mae version, its structure is a significant step up from a homegrown, disorganized spreadsheet. The layout cleanly separates scheduled gross income from actual collections and other charges. This format closely mirrors what a local bank or a private buyer would want to see during underwriting, making it a highly practical tool for most real estate investors. For those already using Stessa's asset management software, the platform can generate a similar rent roll report automatically.

Actionable Takeaways

• Standardize Your Internal Reporting: If you manage a small portfolio, adopt this template across all your properties. It creates a uniform reporting standard that simplifies portfolio-level analysis and makes preparing for a sale or refinance much easier.
• Use It as a Training Tool: The included guide and example make this an ideal resource for training new property managers or assistants. It teaches them what data is important and how to record it correctly.
• Bridge the Gap to Software: Use this template as your entry point. Once your data is clean and organized, importing it into a dedicated asset management platform like Stessa becomes a straightforward process, moving you beyond manual spreadsheets.

This template is completely free and available for immediate download from the Stessa website. It’s an invaluable tool that provides a professional framework without the intimidating complexity of institutional forms, making it the perfect rent roll example for the everyday investor.

Website:Stessa Rent Roll Template

4. Ownwell – 2025 Rent Roll Templates

For sponsors and investors who need a clean, immediate, and versatile example rent roll, Ownwell’s free templates offer a perfect balance of simplicity and function. This resource provides ready-to-use rent rolls in XLSX, Google Sheets, and even PDF formats, making it incredibly easy to deploy across a team or share with external partners like brokers and local lenders without compatibility issues.

The primary strength of Ownwell's offering is its straightforward, month-by-month structure laid out for a full calendar year. This design is highly practical for tracking key metrics over time, such as occupancy, delinquency, and rental income trends per unit. It presents a clear financial snapshot that is easy for anyone to understand, from property managers to potential equity partners, serving as an excellent foundational document.

Strategic Breakdown & Analysis

Ownwell’s templates prioritize speed and accessibility over the granular detail required by institutional lenders. The fields are intuitive: unit number, tenant, square footage, market rent, actual rent, and monthly columns for payment status. This simplicity is its main feature, allowing for rapid implementation with almost no learning curve.

Key Insight: The month-by-month layout makes this template an exceptional tool for visualizing performance and identifying trends at a glance. You can quickly spot a unit with recurring delinquency or see the immediate impact of a rent increase across the property, making it a powerful tool for monthly asset management meetings.

Unlike agency-mandated formats, these templates lack complex fields for concessions amortization, loss-to-lease calculations, or utility reimbursements. While this means it may need to be supplemented for a full underwriting package, it is ideal for initial due diligence, broker opinion of value (BOV) requests, and internal reporting where a heavy, data-intensive spreadsheet would be overkill. It’s the perfect “first look” rent roll.

Actionable Takeaways

• Standardize Your Initial Analysis: Use the Google Sheets version as a master template for your acquisitions team. When analyzing a new deal, they can quickly input data from a seller's messy rent roll into this clean format for a standardized preliminary review.
• Create a "Light" Reporting Package: Pair the filled-out template with a simple profit and loss statement to create a concise monthly or quarterly update for your investors. The clear layout makes financial performance easy to digest.
• Prepare for Multiple Scenarios: Download all three formats. Use the XLSX or Sheets version for internal work and save a PDF copy for sending to parties who only need to view, not edit, the data. This prevents accidental changes to your master file.

This resource is completely free and accessible directly from the Ownwell website with no sign-up required. Its value lies in its immediate utility and lender-friendly presentation, providing a professional and effective tool for a wide range of common real estate tasks.

Website:Ownwell Templates

5. Smartsheet – Lease Tracker Template

While a traditional spreadsheet is effective for static analysis, a modern asset management workflow requires more dynamic capabilities. Smartsheet’s Lease Tracker Template transforms the rent roll from a simple record into an active operational tool. It centralizes all the core data-units, tenants, rents, and key dates-into a grid that functions like a supercharged spreadsheet, adding automations for alerts, reminders, and team collaboration.

This template’s value lies in its ability to enforce operational discipline beyond what a static file can offer. It’s designed for active collaboration between asset managers, property managers, and leasing agents. By building workflows directly into the rent roll, it closes the gap between data collection and on-the-ground action, which is critical for executing a business plan.

Strategic Breakdown & Analysis

Smartsheet’s platform combines the familiarity of a spreadsheet with the power of project management software. The Lease Tracker template comes pre-configured with columns for lease expirations, inspection dates, and renewal status. Its primary advantage is the ability to create automated alerts and notifications based on date-sensitive columns. For instance, you can set a rule to automatically notify the leasing team 90 days before a lease expires, assigning a task to begin renewal discussions.

Key Insight: The template’s strength is its workflow integration. Rather than just viewing data, teams can act on it within the same interface. An asset manager can see a flag for an upcoming vacancy, assign the task of marketing the unit to a leasing agent, and track its status-all within the same row of the rent roll. This creates a clear audit trail and accountability.

While this template is a powerful internal tool, it is not formatted for institutional lenders. Its layout is optimized for operational management, not for underwriting. Therefore, data will need to be exported and reformatted into an agency-compliant example rent roll like the Fannie Mae template before approaching lenders for financing or a sale. Access also requires a Smartsheet account, which typically involves a paid subscription or a free trial.

Actionable Takeaways

• Create Proactive Workflows: Use the automation features to set up reminders for lease renewals, scheduled maintenance, and annual unit inspections. This moves your team from a reactive to a proactive management stance.
• Centralize Team Communication: Instead of managing leasing and maintenance updates through email chains, use the commenting and task assignment features within the sheet. This keeps all communication tied directly to the specific unit and tenant.
• Develop an Export Process: Since the format is not lender-ready, create a standardized process for exporting data from Smartsheet and mapping it to your preferred agency or investor-facing rent roll template. Practice this quarterly to ensure data integrity.

This tool is not free and requires a Smartsheet subscription, but its value is in the operational efficiency it creates. For sponsors focused on improving property performance through disciplined, collaborative management, it's a significant upgrade from a basic spreadsheet.

Website:Smartsheet Marketplace

6. Quadratic – Interactive Rent Roll Template

For teams who want to move beyond static spreadsheets, Quadratic’s rent roll template offers a modern, analytics-forward environment. It's designed for active asset management, providing built-in charts and automated flags that turn a raw data file into a dynamic operational dashboard. This makes it an excellent example rent roll for those focused on weekly performance reviews and recurring investor updates.

This template stands apart by embedding analytics directly into the spreadsheet interface. Instead of exporting data to build charts in another program, Quadratic’s engine visualizes trends and identifies issues like late or underpaid rent in real time. This immediate feedback loop is perfect for property management meetings where quick, data-driven decisions are necessary. The no-code setup means your team can adopt it without needing advanced spreadsheet skills.

Strategic Breakdown & Analysis

The template's core strength is its ability to surface insights without manual work. It automatically calculates and visualizes collection trends, vacancy loss, and delinquency rates. The structure is more flexible than institutional formats, prioritizing operational clarity over strict lender compliance. It's a tool for managing the asset week-to-week, not just for reporting at a single point in time.

Key Insight: The most powerful feature is the automated flagging of payment discrepancies. By comparing 'Rent Charged' to 'Rent Paid', the template instantly highlights underpayments and late payments, allowing managers to address collection issues before they escalate and impact gross potential rent.

Another important aspect is its presentation-ready format. The built-in dashboards provide a professional and easily digestible summary of property performance, ideal for sharing in weekly team huddles or including in monthly investor reports. While it runs in Quadratic’s proprietary spreadsheet engine, this is what enables its interactive features, setting it apart from a standard Excel file.

Actionable Takeaways

• Elevate Weekly Meetings: Use this template as the central document for weekly property management reviews. The visual dashboards for collections and delinquency allow for quick identification of operational issues.
• Streamline Investor Updates: Instead of building charts from scratch, copy the dashboard visuals directly into your monthly or quarterly investor communications for a clean, professional look.
• Manage Data Flow: Since it lives in a non-Excel environment, establish a clear process. Use this template for internal analysis and operational management, but be prepared to export the raw data to a compliant format (like the Fannie Mae template) for lender submissions.

This template is free to use within the Quadratic platform. Its value lies in its speed and visual clarity, making it a strong choice for asset managers who prioritize continuous operational improvement and efficient reporting over rigid, finance-centric formats.

Website:Quadratic Rent Roll Template

7. Someka – Rent Roll Excel Template (freemium)

For landlords and small-scale investors managing their own properties, an institutional-grade template can be overkill. Someka’s Rent Roll Excel Template fills this gap by offering a clean, user-friendly solution designed for straightforward asset management. It’s an ideal example rent roll for those who need organized tracking and printable reports without the steep learning curve of more complex underwriting tools.

This template stands out due to its simplicity and dual-view functionality. Users can toggle between a standard rent roll layout and a monthly receipts view, which is helpful for day-to-day payment tracking. Its primary strength lies in its presentation-ready format, making it easy to generate a clean, professional-looking document for a local bank, potential partner, or buyer who doesn't require CMBS-level data standardization.

Strategic Breakdown & Analysis

Someka’s template is built entirely within Microsoft Excel, ensuring wide compatibility and a familiar interface for most users. The structure is intuitive, focusing on core data points like tenant information, rent amount, security deposit, and move-in/out dates. It lacks the rigid data validation of agency templates, which provides flexibility for smaller operators to adapt columns for their specific needs.

Key Insight: The template includes a built-in dashboard with simple charts that visualize occupancy, total rent, and payment status. This automated summary is a valuable feature for DIY landlords who may not have the time or Excel skills to build their own financial snapshots.

The design prioritizes clarity and printability. Headers are clear, and the layout is clean, which is a significant advantage when you need to quickly share property performance with a third party. While it isn't built for sophisticated underwriting, it serves as an excellent operational tool for managing a small portfolio and provides a solid foundation for data collection.

Actionable Takeaways

• Use for Operational Tracking: This template is best suited for day-to-day property management. Use the monthly view to track payments and the main sheet as your master tenant database for a small number of units.
• Leverage the Freemium Model: Download the free version to test its functionality and see if it fits your workflow. The limitations of the free version will quickly show you whether you need the expanded features offered in the paid product.
• Prepare for Data Migration: If you plan to scale your portfolio and eventually seek institutional financing, view this template as a starting point. Keep your data clean and be prepared to migrate it to a more robust format, like the Fannie Mae template, when the time comes for a capital event.

The template is available as a freemium download, with a paid version unlocking additional features and removing limitations. Its value is in its accessibility and ease of use for operators who prioritize simplicity over institutional complexity.

Website:Someka Rent Roll Excel Template

Top 7 Rent Roll Templates Compared

From Template to Triumph: Systematizing Your Rent Roll Workflow

Throughout this guide, we've moved beyond simply looking at an example rent roll; we've dissected its anatomy, understood its strategic importance, and explored how different templates serve distinct purposes. From the institutional rigor of Fannie Mae and Freddie Mac forms to the user-friendly design of templates from Stessa and Ownwell, the core lesson remains the same: a rent roll is far more than a list of tenants and payments. It's the operational heartbeat of your multifamily asset and the narrative you present to lenders, partners, and investors.

The true power of this document is unlocked not by its format, but by the accuracy, consistency, and depth of the data it contains. A well-maintained rent roll is your single source of truth, enabling confident underwriting, smooth due diligence, and transparent investor reporting. It reveals opportunities for value-add strategies, flags operational weaknesses, and validates your entire investment thesis.

Key Insights and Actionable Takeaways

As you move from theory to practice, keep these critical points at the forefront of your workflow:

• Consistency is Non-Negotiable: Your internal rent roll must be the unwavering source for all other versions. Whether you're populating an investor summary or filling out a lender's specific template, the data-from lease start dates to security deposit amounts-must be identical across all documents.
• Context Defines the Format: Don't use a one-size-fits-all approach. An internal, unit-level rent roll should be exhaustive. A pro forma version is for underwriting future potential. An investor-facing summary must be clear, concise, and focused on key performance indicators. Always tailor the presentation to your audience.
• Validation is Your Best Defense: Regularly perform the sanity checks we discussed. Cross-reference totals with your property management software and accounting ledgers. Question anomalies. A single incorrect formula or data entry error can undermine an entire analysis, leading to flawed projections and damaged credibility.

Strategic Point: The most successful sponsors treat their rent roll not as a static report but as a dynamic management tool. They use it weekly to spot trends in delinquency, monitor lease expirations, and track the performance of their leasing team.

Choosing Your Tools and Building Your System

The templates provided in this article, from the official agency forms to the interactive models from Quadratic and Someka, are excellent starting points. Your choice depends on your immediate needs and technical comfort.

• For early-stage investors: A simple Excel or Google Sheets template (like Stessa's) is often sufficient for tracking a smaller portfolio. Focus on mastering the fundamental data points first.
• For active syndicators: A more robust system is necessary. You might use an advanced Excel template as your central database and then create specific views or exports for different stakeholders.
• For growing operators: As your portfolio expands, manual template management becomes a significant operational drag. This is the point where dedicated software becomes a necessity, not a luxury.

To truly elevate your rent roll management from template-based to a fully integrated system, consider exploring the best property management apps available. These platforms often automate rent roll generation, sync directly with your bank accounts, and provide a live, accurate view of property performance without the risks of manual data entry.

Ultimately, your goal is to build a repeatable, scalable system. Whether that system is built on a meticulously organized spreadsheet or a powerful software platform, it should remove guesswork and instill confidence. The journey from a basic example rent roll to a sophisticated operational system is a hallmark of a professional real estate investor. It's how you turn data into decisions, and decisions into returns.

Ready to centralize your deal analysis and investor relations in one place? Homebase provides an integrated platform where you can manage your rent rolls, underwrite deals with institutional-grade models, and create a professional investor portal. Move beyond scattered spreadsheets and see how Homebase can become the command center for your entire real estate portfolio.

DOMINGO VALADEZ is the co-founder at Homebase and a former product strategy manager at Google.