How to Run a Lease Audit


Before You Start

Make sure that:

  • Pivott has set up the property for Lease Auditor. Pivott staff handle the forms and control leases, so you don't need to.
  • You have the Admin or Editor role. View + Add users can't upload files or run audits.
  • The property is active. Audits can't run on inactive properties.
  • Your lease documents are PDFs.

Upload the Rent Roll

  1. Open the property and click Lease Auditor.
  2. Click Settings > Rent Roll.
  3. Click Upload New Rent Roll.
  4. Select a CSV, XLS, or XLSX file, then click Next.
  5. In Unit Number, select the column with unit numbers.
  6. If you see Rent Roll Effective Date, enter the rent roll's "As of" date.
  7. Optional: For Resident Name, Lease Begin, and Lease End, select the matching column.
  8. For each rent roll row that has a matching lease field, select the form in Lease Form Type and the field in Field Name in the Lease.
  9. Click Create Rent Roll.

Check the Field Mappings

After you upload a rent roll, you can check which rent roll column feeds each lease field.

  1. Click Settings > Rent Roll.
  2. Select the rent roll version you want to check.
  3. Click Field Mappings to expand the panel.

Mappings are grouped by lease form. Each row shows the rent roll column first, as it appears in your file, and then the lease form field it maps to, for example PET-SECURITY-DEPOSIT. If a field gets its value from more than one column, the row lists every column, separated by commas.

The panel is read-only. To change a mapping, contact your Account Manager.

You won't see the Field Mappings panel for a rent roll version that has no mapped fields, or for older versions that Pivott doesn't have column details for.


Upload Lease Documents

A batch is a group of lease documents that Lease Auditor audits together.

  1. Click the Files tab.
  2. Click Create New Batch.
  3. Drag your lease PDFs into the batch, or click Browse Files to select them.
  4. Wait until every file shows Uploaded.

Each file in a batch needs a unique name. If two files have the same name, rename one before you upload it.


Run the Audit

  1. On the Files tab, click Run Audit for the batch.
  2. In the Run New Audit window, select the Control Lease Version and Rent Roll Version. Both default to the newest upload.
  3. Optional: In People to Notify, add anyone who should be notified when the audit is complete.
  4. Click Start Audit.

Read the Results

  1. Click the Audits tab. The Status column shows whether each audit is Running, Complete, or Failed. The status updates on its own when an audit finishes.
  2. Click an audit. The table lists every unit, with the units that have the most errors at the top.
  3. Optional: To find a unit, type its number in the search field next to the Status menu. To sort by unit number, click the Unit column header. Click it again to reverse the order.
  4. Click a unit.
  5. Click the Errors & Omissions tab and compare the Rent Roll and Lease values in each row.
  6. Optional: To change the unit's status, select one from the menu at the top right.

What the audit table shows

  • Matches, Errors & Omissions and Uncertain show how many fields in each unit got each result.
  • Dollar Summary shows each unit's dollar differences, rounded to whole dollars.
  • Click a row to expand it. The expanded row shows the Rent Roll / Control Lease value, the Lease value, and the Difference to the cent.
  • The table sorts by Errors & Omissions, highest first, until you pick a different sort. Your browser remembers the sort you pick.

Resident names are hidden

To protect resident privacy, the Resident Name column shows only the first two letters of each name, for example El******* Jo***. To show the full names, click the eye icon in the Resident Name column header. Click it again to hide them. Names are hidden again when you reload or leave the page.

Name hiding applies only to the audit table on screen. Exports and the unit pages still show full resident names.

To audit updated data, upload a new rent roll version, then click Re-Run Audit on the audit page or on the batch in the Files tab.


Troubleshooting

The Run Audit button is disabled

Hover over Run Audit to see why. The button is disabled if:

  • You don't have the Admin or Editor role.
  • Files in the batch haven't finished uploading and processing.
  • Another audit is already running for the property.

My audit is taking a long time

Large batches can take several hours. An audit can run for up to 24 hours. If it hasn't finished after 24 hours, it times out and stops. To try again, click Run Audit on the batch. If it times out again, contact your Account Manager.

You can't see the forms or control lease settings

Only Pivott staff can access these settings. To request changes, contact your Account Manager.

You don't see the Lease Auditor tab

Lease Auditor isn't turned on for your company yet. Contact your Account Manager.

A field shows an unexpected result

Open Settings > Rent Roll > Field Mappings and check that the right rent roll column feeds that lease field.


Next Steps

To save the results to Excel, read How to Export Lease Audit Results.