How to Export Lease Audit Results

Lease Auditor has three exports: all results, a single audit, or a filtered view of a single audit.


Export All Results

  1. Open the property and click Lease Auditor.
  2. Click the Overview tab.
  3. Click Export All Data.
  4. Read the Confirm Export window. The window states which audit results the file holds.
  5. Optional: Move the Minimum weight slider.
  6. Click Export Now.

Your browser downloads an Excel file. The file name holds the property name and the date.

  • A lower Minimum weight shows more fields on the Non-Dollar Findings sheet, and a higher number shows only the fields with the highest weight.
  • The full export holds the most recent audit result for each unit. If a unit was not in the latest audit, the file holds the result from the last audit that included that unit.
  • This export ignores the filters on the Audits tab. To export only the units that you filtered, read Export a Filtered View.

Export One Audit

  1. Click the Audits tab, then click an audit.
  2. Click Export Audit Data.
  3. In the Confirm Export window, click Export Now.

The file holds only the units in that audit.

This export ignores the filters on the Audits tab. To export only the units that you filtered, read Export a Filtered View.


Export a Filtered View of One Audit

Use this export to save only the units that the table shows after you filter it.

  1. Click the Audits tab, then click an audit.
  2. Filter the table to show the units that you want.
  3. Click the download icon on the table.
  4. Click the CSV icon or the Excel icon.

Your browser downloads a file containing only the units the table shows. The file follows the Status filter, the search field and the Show units not audited toggle.


What the Full Export Holds

The Export All Data and Export Audit Data files are each one Excel workbook. The Confirm Export window lists every sheet. The sheets fall into these groups:

  • An Overview of the results
  • Export Audit Data only: the Errors & Omissions sheet, with every issue that needs fixing, one row per issue. See The Errors & Omissions Sheet.
  • The rent roll that you uploaded
  • The control lease
  • A comparison of billed values and lease values for each unit (Billing vs Lease). The last column, Signature, shows whether each lease is Signed or Not Signed.
  • Summaries of the findings, such as dollar totals by field (Financials) and the Non-Dollar Findings sheet
  • Export All Data only: the Raw Data sheet, with every field Pivott read from each lease. See The Raw Data Sheet.

Blank and zero amounts

A blank amount counts as zero. If the rent roll bills a charge and the lease has no amount for it, the charge is Overcharged by the full rent roll amount. If the lease has an amount and the rent roll is blank or zero, the charge is Undercharged by the full lease amount. A blank and a zero, or two blanks, are a Match.

The sheets don't all calculate the difference the same way. On Billing vs Lease, Variance is the rent roll amount minus the lease amount, so a positive number means overcharged. On Financials and Errors & Omissions, the difference is the lease amount minus the rent roll or expected amount, so a negative number means overcharged.


The Errors & Omissions Sheet

The Errors & Omissions sheet lists everything in the audit that needs fixing, in one long list. Use it to work through the audit unit by unit. It's the second sheet in the Export Audit Data file, after Overview. The Export All Data file doesn't include it.

The sheet has one row for each issue:

  • A rent roll value that doesn't match the lease, or is missing from it
  • A control lease value that doesn't match the lease, or is missing from it. These rows follow the Minimum weight setting.
  • A lease that isn't confidently signed
  • A field that caused a Wrong Lease status (the resident name, or the lease begin and end dates)

Matches and Uncertain field results aren't on this sheet.

Column What it shows
Unit The unit name.
Resident The resident name from the rent roll.
Source Where the issue comes from: Rent Roll, Control Lease, Signature or Wrong lease.
Field The field with the issue, for example Rent or Lease Signed Status.
Expected The rent roll or control lease value. Blank when that source has no value.
Lease The value Pivott read from the lease. Blank when the lease has no value.
Difference For amounts and dates, the lease value minus the expected value. Dates show the difference in days. Text fields have no difference.
Operator Notes Always empty when you export. Use it to track your own work in the file.
  • Rows are sorted by unit. Within a unit, Wrong lease rows come first, then signature, amounts, dates and other fields.
  • If the same issue shows up against both the rent roll and the control lease, you see two rows, one for each source.
  • If the audit has no issues, the sheet shows No issues found.
  • If Pivott didn't check signatures for this audit, the sheet says so. It doesn't mean the leases are signed.

The Raw Data Sheet

The Raw Data sheet is the last sheet in the Export All Data file. It holds every field Pivott read from each lease, including fields that aren't on the rent roll or control lease, such as vehicle or pet details.

  • Each row is one unit. Each column is one field.
  • The first header row shows the form the field comes from. The second header row shows the field name.
  • A cell is blank when Pivott found no value for that unit.
  • If a unit has more than one lease file in the audit, the sheet uses the newest file.
  • If a field is missing from the audit upload, the sheet uses the value from an earlier upload and adds (from earlier upload) after it.
  • Checkboxes show as TRUE or FALSE.
  • Names on this sheet are partly hidden, for example Jo**** Sm****.

The Raw Data sheet is very wide. Use Excel's filter and freeze-panes tools to find the fields you need.


Units With No Lease on File in Exports

Units that are on the rent roll but have no lease file in the audit show the status No lease on file. To learn more, read Understanding Lease Audit Results.

Export How these units appear
Export All Data The Billing vs Lease sheet lists each unit on the latest rent roll that no completed audit covers. These rows are marked No lease on file, and the charge cells are empty. The resident name, lease begin and end dates, unit type and square footage come from the rent roll. The Overview sheet shows the same coverage as the Overview tab.
Export Audit Data The same as above, for the units in that audit that have no lease file.
Filtered view (CSV or Excel) The Status cell says No lease on file, and the number cells are empty. Turn off Show units not audited before you download to leave these units out.

Next Steps

To learn how to run an audit, read How to Run a Lease Audit.