From the Admin > General Setting > General tab, select Aged Debtor/Creditor Report Period Length - Quarter.

You have the option to display overdue invoices according to the Invoice Date or according to the Invoice Due Date (where an invoice has a grace period and is therefore due on a different date than the invoice date.)

Note: When the config is set to use the Invoice Due Date, if the invoice date is prior to the report date, and the invoice due date falls within the Current period, the Current column displays those invoices with that invoice due date.

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

The report lists all debtors (contacts with outstanding sales invoices) for the company.

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 2019 – the report shows the balance from 1 April 2019 until 30 June 2019.

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

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

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

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

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.

Note: Allocated payments are excluded from the report provided that both the payment and the invoice that it is allocated to are dated on or before the report date.

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

Note: Paid invoices are excluded from the report provided that both the invoice and the payment that the invoice is allocated to are dated on or before the report date.

The end balance is not be split by period.

In the example below, the report is run on 5 Feb 2020, which falls in the quarter of Jan-Mar.

There is an Invoice Date of 25 Dec 2019 with an Invoice Due Date of 19 Jan 2020. The config is set to use the Invoice Due Date; therefore, the invoice is included in the Current column rather than in the Oct-Dec column.

Introduced in version 2017.11.14.4503 released on 29/11/2017