Understanding the Age Analysis on a Tenant Statement
Understanding the Age Analysis on a Tenant Statement
This article explains how the Age Analysis is calculated on a tenant statement.
Important things to note
Payments are allocated to the oldest outstanding charges first (FIFO).
Whenever a tenant makes a payment, it is automatically allocated against the oldest outstanding balance before reducing newer charges. This may affect the amounts shown in each ageing bucket.
The ageing calculation is based on the statement "To" date.
In this example, the statement has been generated with a To Date of 25 June 2026. The selected statement date determines the date ranges used for each ageing bucket.
Future-dated transactions are excluded.
Any transactions dated after the statement To Date are not yet due and therefore do not form part of the age analysis.
Ageing buckets
Since the statement has been generated as at 25 June 2026, the ageing buckets are calculated as follows:
Ageing Bucket | Days Outstanding | Date Range |
| Current | 0 - 30 days | 26 May 2026 - 25 June 2026 |
| 30 Days | 31 - 60 days | 26 April 2026 - 25 May 2026 |
| 60 Days | 61 - 90 days | 27 March 2026 - 25 April 2026 |
| 90 Days | 91 - 120 days | 25 February 2026 - 26 March 2026 |
| 120+ Days | 121+ days | 24 February 2026 and earlier |
Example tenant statement
The tenant statement below has been colour coded to show how each outstanding charge falls into the relevant ageing bucket.
Each charge is assigned to an ageing bucket according to its transaction date relative to the statement To Date.
Example calculation
The same statement has been exported to Excel to illustrate how the age analysis is calculated.
In this example:
- There are no outstanding charges that fall within the 61 to 90 day period, so the 60 Days bucket is R0.00.
- Charges dated 1 July 2026 do not form part of the calculation because the statement was generated as at 25 June 2026. These transactions are future dated and are therefore not yet due.
Ageing Bucket | Amount |
| Current | R39,132.51 |
| 30 Days | R39,213.94 |
| 60 Days | R0.00 |
| 90 Days | R39,354.96 |
| 120+ Days | R199,710.01 |
| Outstanding Balance | R317,411.42 |
Why isn't the ageing based on calendar months?
The Age Analysis is calculated using the actual number of days outstanding, based on the statement's To Date. Because months have different numbers of days, it is possible for a bucket (such as the 60 Days bucket) to contain no transactions, as shown in this example. This is expected behaviour.
Related Articles
View Tenant Arrears Age Analysis Report
The Arrears Debtors Report provides detailed information on overdue payments and outstanding debts. It includes an Age Analysis section that breaks down and assesses overdue payments based on their durations. This analysis helps identify how long ...Distribute Bulk Tenant Arrears Notifications
1. Access the arrears report, this can be access from two method: Method 1: To access the report from the balances screen, start by clicking on Accounting in the Main Menu. Click on Tenant Statements. Click on Balances then Tenant Age Analysis. ...View Pro-Forma Age Analysis
Once a predefined fee is debited, the fee will be removed from the pro-forma age analysis report and appear on the debited Fee reports. 1. Click on Accounting on the Main Menu. 2. Click on Fees 3. On the main ribbon bar, select Pro-Forma Age analysis ...Company analytics: Company Lease Reports
1. To access the company lease reports reports, start by clicking on Accounting in the Main Menu. 2. Click on Company Reports. 3. Click on Company Lease Reports on the main menu 4. Under the Company Lease Reports menu, there are reports: Rent Summary ...Tenant Statements Balances Reports
There are two tenant statement options available for users to access: Statement Balances Detailed Statement Balance 1. To access the various statement reports, start by clicking on Accounting in the Main Menu. 2. Click on Tenant Statements. 3. Click ...