How do I find how long all invoices have aged before payment per customer? I need to see how may days late they have been over the course of a couple of years.

I've had a couple of chronic late-payers myself, and seeing the aging history really helps make that tough call.

Here’s a straightforward way to get what you need in QuickBooks:
Go to Reports, then search for the Customer Balance Detail report. Once there, customize it,
add the Due Date and Open Balance columns if they aren’t already showing. You can also add the Aging columns (like 1-30, 31-60 days, etc.).

But to see exactly how many days late each invoice was before payment, you’ll need to export the report to Excel. Once exported, you can create a simple column to calculate Date Paid minus Due Date for each invoice. That way, you’ll get the actual number of days late, not just the aging bucket.

If you want a quicker overview inside QuickBooks without exporting, you can use the A/R Aging Detail report. It shows outstanding balances by aging period, but it won’t directly show historical payment lateness per invoice after they’re paid.

I usually use a combo: check A/R Aging for current trends, then export the detail to Excel when I need to analyze payment behavior over the years

You can run an Invoices and Received Payments report and filter the customer that you want to check, @spayne3.

Please note that QuickBooks Online currently doesn't have a report that calculates the age of an invoice using its creation and payment dates. But you can view the interval between these dates, which may help you review your customer's payment history.

Here's how:
 

1. Log in to your QuickBooks Online account.
2. In the left-hand menu, click Reports.
3. Navigate to the Who owes you section and select Invoices and Received Payments.
4. Ensure you're in the Classic View and set your preferred report period.
5. Click the Customize tab, then open the Filter dropdown and choose the specific customer you want to focus on.
6. Finally, click Run report to view the results.

You can also use the report mentioned by Poll and export it to Excel. Add a new column to calculate the number of days between the due date and the payment date, providing clearer insights into payment timeliness.

To simplify managing your financial records in QBO, our QuickBooks Live Assisted team is here to help. They can support you in enhancing your understanding of your business management.

For more assistance with reports in QBO, return to this thread. We are here to ensure you receive the necessary support in managing your business tasks.