Case Study: A Case of Overflowing Yardi Data

33Floors solved a case of overflowing Yardi data for operations and accounting personnel at a large U.S.-based multinational commercial real estate owner/developer with hundreds of employees.

Client challenges

The client’s Yardi database contained an immense amount of data pertinent to both property operators and accounting personnel that wasn’t used or disseminated effectively. The data included critical dates — lease expirations, rent steps, mortgage payments and report responsibilities — as well as data validation and user activity issues. 33Floors was tasked with parsing the information to the appropriate end-users efficiently and conveniently. The client wished to:

33Floors IMPLEMENTATION

33Floors SUPPORT

33Floors DEVELOPMENT

33Floors DATA SCIENCE

33Floors Solution

Identified

the critical dates and issues to be addressed.

Added

a new table to capture property-level critical dates.

Incorporated

a new script to build critical dates, encompassing both the added table and previously unaddressed critical dates.

Wrote

Wrote a new Daily Issues Report generating emails with critical dates, cash balances, aged receivable and payable balances, disbursements made and checks cleared.

Delivered

the Daily Issues Report appropriately via each user’s identified roles to ensure the correct information is put in the right hands.

Results

By starting each day with a single email summarizing pertinent issues, users are better prepared to manage their portfolios, saving time and resources.

33Floors solutions helped reduce the overall policy violation rate of 18.4% of transactions to an average of 4.3%.

The system recorded and sent notices as designed, with minimal management involvement needed to drive the reduction in violations.

Let’s get above it.

Implementation

Support

Development

Data Science