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 the length of time charges have remained unpaid, in increments, and then gives you the total debt on each unit ledger.
Trailing-day data This report is built on trailing-day data, meaning it can only be generated up to the prior day, not for the current day. Using trailing-day data ensures static data and guarantees data completeness and accuracy.
This report is sorted by unit number and can be exported as a PDF or Excel/CSV file. The CSV version of the report includes an extra column, business name, that you will not find in the other versions.
Columns and calculations
Unit: The unit column contains the unit number with a past-due balance in 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 shown here is the overdue amount for days 0-30 of nonpayment.
31-60: The amount shown here is the overdue amount for days 31-60 of nonpayment.
61-90: The amount shown here is the overdue amount for 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.
When a tenant has a credit with a date of today or older that is applied to a future charge, that credit amount will show up on the Aging Report as a negative amount.
Accrual Facilities
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 Receivable and subtract the debit column of Accounts Receivable, and record the difference.
5. The difference from the Aging reports should match the difference from the General Ledger report.
For example, the March 31st Aging report total is $1000, and the 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 Accounts Receivable should be $1000.
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 across all revenue categories (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.