Open AR Analytics to see what tenants owe, grouped by how long it has been owed, as of the month you choose.
Before you start
- Your role needs the A/R Reports permission with the Access action. Without it, the AR Analytics page does not open.
- Accounting go-live must be complete. If it is not, the page shows a setup card in place of the report. The card names the next setup step.
Steps
- Select Reports in the sidebar.
- In the Accounts Receivable section, select AR Analytics. The report is also in Favorites by default.
- Under Report Type, choose a type. The list has four types: Receivable Detail, Receivable Summary, Aging Summary and Aging Detail. The screen opens on Receivable Detail. For the aging reports, choose one of these:
- Aging Summary to see totals for each tenant, grouped by property.
- Aging Detail to see each open charge, payment and credit on its own line.
- Set As of Month to the month you want to measure to. The report counts to the last day of that month. It defaults to the current month.
- Set any of these filters. Leave a filter blank to include everything.
- Property and Tenant limit the report to the properties and tenants you pick. The lists show "All Active Properties" and "Select All Tenants" when blank.
- Status limits the report to one lease status: Current, Notice, Future, Eviction or Moved out.
- Charge Code appears only for Aging Detail.
- Summary Type appears for Aging Summary. Choose Tenant. The Account option is shown but cannot be selected.
- Person Type is set to Tenant. The Vendor and Owner options are shown but cannot be selected.
- Select Display to show the report with the filters you set.
- Read the table below the filters. Select Clear to reset the screen.
What the report shows
Aging Summary has these columns: Tenant, Total Charged, Future Charges, 0-30, 31-60, 61-90, 91-120, 121-150, Over 150, Pre-Payments, Current Owed and Total Owed. The rows are grouped by property, with a total for each property and a grand total at the end.
Aging Detail has these columns: Owner, Property, Unit, Charge To, Trans#, Charge Code, Invoice Date, Due Date, Post Month, Total Charges, Future Charges, Current Owed, and the six bucket columns 0-30 to Over 150.
How the balance is counted
- Each charge is aged from its Invoice Date, not its Due Date. The bucket counts the days from that date to the last day of the As of Month.
- A charge dated after the end of the As of Month has no bucket. It appears in Future Charges.
- Current Owed is the total of the six buckets, from 0-30 to Over 150.
- Pre-Payments are unapplied payments and credits.
- Total Owed is Current Owed plus Pre-Payments.
What happens next
- The results stay on the screen. The Excel, PDF and Email buttons above the results are disabled, so you cannot export or email this report from the screen.
- Below the results, an AI report insights panel appears. On an Aging Summary, select Get AI Insights to generate a review-only summary of the aging totals. When AI report insights are unavailable for your workspace, the panel says so, and the report stays available.
Common problems
- This status is not one the report offers. Choose a status from the list and run the report again. Choose a status from the Status list, then select Display.
- A charge in this report has a charge code that its charge code list does not name, so Aging Detail cannot show it. Name the charge code in Charge Codes, then run the report again. Name the charge code in Charge Codes, then select Display again.
- These report filters are not valid. Clear them and choose the filters again. Select Clear, choose the filters again and select Display.
- AR Analytics could not load this report. Try again. Select Display again.
To find a tenant's contact details, run the Tenant Statement or Tenant Invoice report and select Display. Each result has a Contact column. It shows the tenant's primary email, or the primary phone when there is no primary email. When neither is set, the Tenant Statement shows a dash and the Tenant Invoice shows "NA".
Related articles