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

Note: When this option is selected, the report displays according to invoices that are outstanding as of the last 30 days (beginning with today), followed by the next 30 days, and so forth.

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 Date, the Current column does not display as any outstanding invoices due today are included in the 0-30 days column.

From the Company/Partnership Reports tab or from the global Reports list, select Aged Debtors Report.

Select the Date from which to run the report and click Export to Excel.

The report displays as of the date selected according to the following breakdown:

Balance = the total amount of outstanding invoices as of the report date.

Current = Any invoices whose invoice date is already due but due to a grace period, the invoice is not yet overdue.

0-30 Days = all invoices with an invoice due date of today through the last 30 days, less any credit notes.

31-60 Days = all invoices with an invoice due date of 31 days prior to today until 60 days prior to today, less any credit notes.

61-90 Days = all invoices with an invoice due date of 61 days prior to today until 90 days prior to today, less any credit notes.

91+ Days = all invoices with an invoice due date of 91 days prior and older, less any credit notes.

Unallocated Payments are payments that are not allocated to an invoice as of the date of the report.

The End Balance equals the total overdue invoices as of the selected date, minus any unallocated payments.