The Aging Report gives you an idea of how old past due balances are on a unit’s ledger. It breaks down the total past due amount by how long charges have remained unpaid in increments, and then gives you the total amount of debt on each unit ledger.
This report is sorted in order by unit number and can be exported via PDF or Excel/CSV. The CSV version of the report includes an extra column, business name, that you will not find on the other versions of the report.
Columns and calculations
- Unit: The unit column contains the unit number that has a past due balance on its ledger.
- Tenant Name: This column contains the name of the tenant who is renting the unit.
- Business Name (CSV): This column only appears on the CSV version of the report and contains the business name associated with the rental, if applicable.
- 0-30:The amount that appears here is the overdue amount from days 0-30 of nonpayment.
- 31-60: The amount that appears here is the overdue amount from days 31-60 of nonpayment.
- 61-90: The amount that appears here is the overdue amount from days 61-90 of nonpayment.
- 120+: The amount that appears here is the overdue amount that was owed after 120 days of nonpayment.
- Total: The number in this column is the tenant’s total past due balance. It is calculated by adding all overdue balances in the previous columns together. This is calculated by adding the amounts from columns 0-30 through 120+. The tenant may have more charges that are not past due on their ledger, so this number is not necessarily the total amount due for the tenant.
- Move Out: If the tenant renting the unit has moved out, their move-out date will appear here.
To confirm Account Receivable balances:
1. Pull the report for the last day of the prior month and the last day of the current month
2. Subtract the totals to record the difference.
3. Access the General Ledger report
4. Add the credit column of Accounts Receivables and subtract the debit column of Accounts Receivables and record the difference.
5. The difference from the Aging reports should match the difference from the General Ledger report.
For example, March 31st Aging report total is $1000 and April 30th Aging report ending balance is $2000 for a difference of $1000.
On the General Ledger report, the credit column minus the debit column for Account Receivables should be $1000.
Important Note: You must use the Aging Report to reconcile to the General Ledger Accounts Receivable amounts rather than the Management Summary. The Aging report lists all unpaid amounts for current and past tenants for every category of revenue (rent, fees, services, etc). The Management Summary's "Amount Due by Oldest Charge (Current Tenants)" section excludes tenants who owe money but have moved out. It also excludes current tenants who owe non-rent money. For more information, see the Management Summary help article.