YARDI® Reporting Has Changed

Yardi Spreadsheet Reporting (YSR) is Yardi's built-in tool for creating custom reports in Voyager using Excel and Word templates connected to live data. It replaced Yardi Correspondence as the standard reporting tool and gives property management teams the ability to build boardroom-quality financial reports, investor packages, and operational summaries without writing SQL or waiting on IT. In our 2026 industry survey, 18% of CRE respondents cited reporting and data quality as a top priority, reflecting growing demand for exactly this kind of capability.

If your organization still relies on Correspondence templates, manual Excel exports, or outdated Crystal Reports, YSR is the path forward. And if your reporting needs go beyond what a spreadsheet can handle, tools like SSRS and Power BI through Yardi Data Connect fill the gap. Here's how the pieces fit together.

What Yardi Spreadsheet Reporting Actually Does

YSR connects Excel and Word to your Voyager database. You design a template in your spreadsheet application, map cells to Voyager data fields, and the report populates automatically when it runs. The output is a formatted document that pulls live data every time, eliminating the copy-paste-format cycle that most Yardi users know too well.

The practical workflow looks like this:

1. Configure the report setup in Voyager: Define the data source, parameters (date range, property, entity), and output format
2. Design the template in Excel or Word: Build your layout with headers, formulas, charts, and conditional formatting, then insert YSR field codes where live data should appear
3. Run the report: Voyager populates your template with current data. The output is a standard .xlsx or .docx file you can distribute, print, or archive

Because the template uses native Excel, you get full access to formulas, VLOOKUP/INDEX-MATCH, pivot-ready layouts, charts, and conditional formatting. This is a significant upgrade from Correspondence, which had a basic text editor with limited formatting control.

What YSR Replaced: Correspondence vs. Spreadsheet Reporting

Yardi Correspondence was the original template-based reporting tool in Voyager. It worked, but it was limited. YSR replaced it as the recommended approach for custom report development. Here's how they compare:

Capability	Correspondence	YSR (Spreadsheet Reporting)
Template editor	Built-in text editor	Microsoft Excel or Word
Formulas and calculations	Basic	Full Excel formula library
Charts and graphs	Not supported	Native Excel charting
Conditional formatting	Not supported	Full Excel conditional formatting
Multi-sheet workbooks	Not supported	Supported
Tenant correspondence	Primary use case	Supported (billing statements, notices)
Financial reporting	Limited formatting	Boardroom-quality output
Learning curve	Yardi-specific syntax	Familiar Excel skills

The most common YSR use cases we see across client engagements like Goldfarb Properties include multi-property financial rollups, custom rent rolls with calculated fields, investor reporting packages, and tenant billing statements that previously ran through Correspondence.

When YSR Is Not Enough

YSR covers the majority of custom reporting needs, but it has boundaries. Understanding where those boundaries are helps you avoid building the wrong report in the wrong tool.

Use SSRS when you need:

• Complex SQL joins: Reports pulling from multiple database tables with relationships that YSR's field mapping can't express
• Pixel-perfect formatting: Regulatory filings, HUD submissions, or audit documents with strict layout requirements
• High-volume batch output: Generating hundreds of individual reports (per-property, per-investor) in a single run
• Subreports and drill-through: Reports that link to detailed sub-reports based on user clicks

SSRS requires SQL development skills, and Yardi is gradually steering new development toward YSR. But for organizations with existing SSRS report libraries, like Harbor Retirement Associates' 15+ custom reports, SSRS remains a reliable production tool. For a detailed comparison, see our YSR vs. SSRS vs. Power BI reporting guide. If you're upgrading to Voyager 8, see how the reporting stack changed in Voyager 8, including the shift from SSRS to YSR and the new Report Builder.

Use Power BI when you need:

• Interactive dashboards: Visuals that users can filter, slice, and drill into on their own
• Cross-source analytics: Combining Yardi data with market data, banking feeds, or other software platforms
• Portfolio-level KPIs: Executive views across hundreds of properties with real-time refresh

Yardi offers two paths to Power BI: Data Connect (a managed data feed from Voyager to Power BI) and Replicate (real-time data replication to Snowflake, AWS, or Azure for organizations that want their own data warehouse). Both eliminate manual exports and keep dashboards current. For a practical breakdown of audience fit, reporting boundaries, and rollout considerations, see our guide to Yardi Data Connect and Power BI.

Why Teams Get Stuck on Manual Excel Workflows

The most common pattern we see isn't that teams lack reporting tools. It's that they've built manual workarounds that feel good enough. A controller exports a trial balance to Excel, adds formulas and formatting, and emails it to ownership every month. It works, but it takes hours and introduces error risk every time.

YSR can automate that exact workflow. The Excel template preserves the controller's preferred layout and formulas. The difference is that the data populates from Voyager automatically instead of being copied and pasted. The report that took two hours now takes two minutes.

This is where working with a Yardi consultant accelerates the transition. Converting your most time-consuming manual reports to YSR templates is typically a project-based engagement: we analyze your current Excel workflow, build the YSR template to match it, validate the output against your manual version, and hand it back to your team ready to run.

Getting Your Reporting Strategy Right

Most Yardi shops benefit from a layered approach:

1. Yardi Analytics for standard canned reports (rent rolls, aging, financial statements). Teams looking to go deeper should also explore financial analytics notes in Yardi, which add narrative context directly to these standard outputs
2. YSR for custom operational and financial reports that need specific formatting or calculations
3. SSRS for technically complex or regulatory reports that require direct SQL access
4. Power BI for interactive dashboards and executive-level portfolio analytics

The right mix depends on your portfolio size, reporting cadence, and team capabilities. A 500-unit multifamily operator may need nothing beyond YSR. A diversified portfolio with institutional investors probably needs all four layers. Through the BCS Concierge Club, clients get access to a custom report library and ongoing report development as part of their support retainer.