Request for files and Setup of Automated Data Transfer

PHASE 1 : Select the Following Reports with specified Parameters

FILES TO EXPORT

PARAMETERS

Rent Roll

As of Date = Current Date

Example of how your Rent Roll should look:
Yardi - Rent Roll.png

Aged Receivables

Current Period

Example of how your Aged Receivables should look:
Yardi - Aged Receivables.png

Unit Availability Details with Amenities

As of Date = Current Date

Showing Pre-Leased: = Yes

Showing Occupied: = Yes

Example of how your Unit Availability Details with Amenities should look:
Yardi - UADwA.png

Market Rent Schedule

As of Date = Current Date

Example of how your Market Rent Schedule should look:
Yardi - Market Rent Schedule.png

12-Month Budget Export

Book = Accrual

Account Tree = YSI Standard Budget

Period = {January 1 of fiscal year to December 31 of fiscal year}

Example of how your 12-Month Budget Export should look:
Yardi - 12-Month Budget Export.png

Income Statement

Book = Accrual

Account Tree = YSI Standard Income Statement

Period = Current Fiscal Period

Example of how your Income Statement should look:
Yardi - Income Statement - Fiscal Period.png

Balance Sheet

Book = Accrual

Account Tree = YSI Standard Balance Sheet

Period = Current Fiscal Period

Example of how your Balance Sheet should look:
Yardi - Balance Sheet - Fiscal Period.png

Trial Balance

Book = Accrual

Account Tree = YSI Standard Trial Balance

Period = Current Fiscal Period

Example of how your Trial Balance should look:
Yardi - Trial Balance - Fiscal Period.png

Chart of Accounts

Chart Code: system
From Account: Leave this field blank
To Account: Leave this field blank
Normal Balance: Either
Account Type: Any
Report Type: Either
Destination: Screen

Example of how your Chart of Accounts should look:
Yardi - Chart of Accounts.png

1.

2.

3.

 

Export each of the requested reports utilizing Yardi's Scheduler.

Upload the exported Excel documents to the Box folder that NavigatorCRE has invited you to (reference link in the invite you will receive from Box.com)

NavigatorCRE Data Engineering team will:

A. Make any necessary modifications to program scripts

B. Ingest the data into the SQL Server instance

C. Provide you with a separate Globally Unique Identifier (GUID) via email, for each file.

PHASE 2 : Setup the Automated Data Transfer (ETL)

4. Once you’ve received the GUIDs, configure the Report Scheduler Event in Yardi Voyager for each report to establish an automated nightly feed into NavigatorCRE:

A. Email Address: ETL@NavigatorCRE.com

B. Optional: You can combine all four files into a single ‘Zip’ file, by selecting the ‘Zip file(s)’ option as shown below (‘B’).

C. Enter the four files into the ‘File or Script’ section that constitutes the contents of your packet.

D. Copy-and-paste the GUID provided to you in step #3 into the ‘Message’ field shown in ‘D’, below. (It is critical to match the report name in ‘C’ with the associated GUID in ‘D’.)

Yardi - Phase2-Setup.jpg

5. Set the Report Scheduler to run nightly between Midnight and 8:00 AM (EDT)

PHASE 3 : Follow up for additional data

  • Historical Data associated with the scheduled reports

    • Rent Roll

    • Aged Receivables

  • Lease Trade Out (LTO)