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.
Note: 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.
To confirm Account Receivable balances:
1. Pull the report for the last day of the month prior 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.