The Aged Debtor Report displays the balance for each debtor on a given date to easily see the breakdown of the default debtor nominal.

The Aged Debtor report is available from the main Reports > Aged Debtor Report and from the company Reports > Aged Debtor Report.

The aged debtor report lists all debtors with outstanding sales invoices as well as unallocated payments for a specified company. It also accounts for credit notes; however, the report excludes tenants that have unallocated payments equal to their debt balance.

Each debtor's balance displays for the default debtors account up until the report date.

The report lists the breakdown of the balance per period. Periods are defined as:

• 1 January – 31 March
• 1 April – 30 June
• 1 July – 30 September
• 1 October – 31 December

Current – the current period – if the report is run for 30 June 2017 – the report shows the balance from 1 April 2017 until 30 June 2017.

Period 1 – the previous period – if the report is run for 30 June 2017 – the report shows the balance from 1 January 2017 until 31 March 2017.

Period 2 – the period before Period 1 – if the report is run for 30 June 2017 – the report shows the balance from 1 October 2016 until 31 December 2016.  

Period 3 – the period before Period 2 – if the report is run for 30 June 2017 – the report shows the balance from 1 July 2016 until 30 September 2016.

Older – the balance from before Period 3 – if the report is run for 30 June 2017 – the report shows the balance from before 1 July 2016.  

Since payments that are not allocated to an invoice do not appear in the default debtors account, the sum of unallocated payments up until the report date are included as a separate figure.

The report displays the sum of the balance and unallocated payments amounts as the end balance.

The end balance is not split by period.

Note: Invoices that have already been paid BEFORE THE REPORT DATE are filtered out.

Introduced in version 2017.11.14.4503 released on 29/11/2017