CASE STUDIES

88% increase in efficiency by streamlining financial reporting using automated solutions

Challenge

An international REIT firm headquartered in Florida with more than 20 offices around the world lacked the in-house expertise to generate its critical monthly reports of investment & portfolio performance. Process delays, data errors, and inconsistent formatting standards made report generation error-prone and time-consuming. The use of disparate data templates further complicated the data collection and analysis processes.

The GO Creative™ Solution

At the outset, RRD fixed the data sources to accelerate the collection of raw data. It segmented the data by period, period comparison, entity, deals, NOI, and top and bottom-performing portfolios so the reader could obtain meaningful information at a glance. The team used macros to consolidate, formulate, and standardize data templates from various financial reports, and set up a Tableau dashboard that offered the user multiple display options for comprehensive, easy-to-understand, and visually arresting reports.

Outcomes Achieved

Our REIT Accounting Services team’s integrated, customized solution, and consultative approach to business transformation helped the client achieve:

  • 100% reporting accuracy
  • 88% increase in efficiency over the manual process
  • Informed decision-making
  • Compliance with SOX 302 by leveraging key internal controls
  • Simpler drafting of the management discussions and analysis notes of the SEC compliance filing every quarter