I have a relatively simple solution that provides a couple of extra benefits: 1) a formula to separate sub-customer names from their jobs i.e. customer name:order#. 2) Association of Payment Dates with each invoice.
In short, the Invoices and Payments Received Report is distilled with a few steps to support a cross-tab that calculates the Average Days to Pay for each Customer. This allows all payments from a customer to be analyzed together, and 2) you get a list of company names and Average Days to Pay that may be used for lookup.
Be sure to see all the notes.
Reach out if you need the original Excel file.
