How can I get a receivables ageing based on invoice dates?

Hi fadi-Kibrite,

The Accounts Receivable Ageing reports (Detail and Summary) in QuickBooks Online provide a detailed overview of your customers' outstanding balances. They highlight who is behind on payments, the amounts that are still due, and how long those balances have been overdue. By default, the report organizes invoices based on their Due dates. You can use this link for reference: Run an accounts receivable ageing report.

Invoices are displayed based on their invoice dates only if the Due date is set to match the Invoice date.

In such cases, you can add the Past due column to the Accounts Receivable Ageing Detail report to see precisely how long payments have been overdue from the Invoice date to the Report period or the Ageing Method of the report.

Here's how you can add the Past Due column:

Modern View

1. Click the Columns option located on the right side of the report.
2. Scroll down and select the checkbox for Past due.
   
    

Classic View

1. From the modern view of the report, click Switch to classic view.
   
2. Click the Customise button and select Change columns under Rows/Columns.
3. Scroll down and select the checkbox for Past due.
4. Select Run report.

You'll then see how long the invoice was open from the invoice date.

Feel free to reach out if you need further assistance.