NEW – April 2019
Automatically Sync Appfolio Tenant / Lease Data
Once you have your Appfolio property / unit sync enabled, you can also sync your Appfolio tenant / lease info into zInspector. You must have properties synced before you can set up tenant sync for those properties—so refer to our Appfolio Sync support article here as needed.
Set up is quick and easy, with five basic steps:
- Obtain Your Appfolio Sync ID from zInspector.
- Generate and Save a Custom Tenant Directory Report in Appfolio.
- Email the Custom Report to zInspector for the Initial Sync.
- Confirm the Initial Sync in zInspector.
- Create a Scheduled Report in Appfolio to Sync the Custom Report Daily.
The video below provides step-by-step instructions for setting up your Appfolio Tenant / Lease Sync.
A detailed written walkthrough follows the video.
Note: You will need Admin permissions in zInspector and Property Management (or better) permissions in Appfolio to set up the sync.
STEP 1: Obtain your Appfolio Sync ID from zInspector
1. On the zInspector website, go to Settings –> Admin Settings –> Accounting Software Integration.
2. Select AF (Appfolio) from the drop-down, and verify that Appfolio is synced and enabled.
3. Click Import / Sync ID.
4. In the Link to AF window, copy the Scheduled Report Email Address (see screenshot below).
STEP 2: Generate and Save a Custom Tenant Directory Report in Appfolio
1. In Appfolio, go to Reporting, then Reports, and select the Tenant Directory.
2. Customize the report with the following selections:
3. Click Update to generate the report.
STEP 3: Email the Report to zInspector for the Initial Sync
1. With the generated report now open, click on Actions, then Email.
2. In the Customize Report window do the following:
- Change the Format to CSV.
- Paste the email address you copied earlier from zInspector into the Email Body:
- You now need to alter the email address by replacing “unit” with “tenant” like this:
STEP 4: Confirm the Initial Tenant Sync in zInspector
1. On the zInspector website, go to Advanced –> Contacts.
2. Click on the Tenants tab. The initial sync may take up to five minutes. After a five or so minutes, refresh the page and confirm that the tenant info has synced successfully.
Still not syncing? If your tenant and lease information has not synced after five minutes, check the following:
- When the Contacts page opens, it typically defaults to the Vendors tab. To make sure you see your tenant sync data as soon as it arrives, make sure you are on the correct tab—Tenants.
- If you are designated to a specific User Group, you may not have access to the properties to which the tenant and lease data is synced. Depending on your user privileges, you (or an Admin user on your team) can check your User Group assignation by going to Group –> User Group tab and selecting All Units in the User Group drop-down for your username. Return to Advanced –> Contacts –> Tenants tab to see if the sync data shows up.
3. Now go to Advanced –> Leasing. See the additional info brought over by the sync—namely the relationships between the Tenants, Properties, and Lease data. You can use the searchboxes and drop-downs in the column headers, or click one of the filters (below) to narrow your results:
Tip: Select Moving In to see all incoming tenants, and click Invite next to their names to invite them to complete their own zInspector Move-In Inspections.
STEP 5: Create a Scheduled Report in Appfolio to Sync the Custom Report Daily
1. In Appfolio, return to your previously generated Tenant Directory Report, select Actions, then Save as Layout.
3. Still in Appfolio, go to Reporting, then Scheduled Reports, and click on New Scheduled Report.
4. In the Schedule Name field, enter the previously chosen report save name (e.g., “zTenantSync”).
5. In the Saved Reports searchbox, again select the saved report by name.
6. Select the Format CSV.
7. Paste the previously altered email address into the Message field; confirm that it begins with “aftenant.”
8. Paste the email address again, this time into Recipients.
9. Set the Frequency to Daily.
10. Click Save—and you’re done!
1) Lease From is an essential Appfolio field—you included that column when generating the tenant report above. Any tenant/lease row without a date in the Lease From field cannot be imported.
2) Emails is an essential Appfolio field required for syncing your Appfolio tenant / lease data correctly—you included that column when generating the tenant report above. Any tenant/lease row with a blank Emails field will not be imported. To determine if any of your tenants have not synced for this reason, go to the Accounting Integration page and simply hover your mouse cursor over the Last Sync/Change field:
- If nothing happens—congratulations, you have no blank Emails fields interfering with your sync.
- If the message “Tenant with blank email cannot be imported” appears, we advise you to add tenant email addresses in Appfolio.
- If the message “There are properties with blank names in the report that will not be imported” appears instead, a similar situation is occurring with your Property / Unit Sync, and you should refer to the corresponding article for more information.
A screenshot illustrating this situation is provided here:
Still have questions? Create a Support Ticket, and tell us what’s going on. The more info you include, the better!