Hi there, HVACER. 

Thank you for reaching out to the Community for assistance. I am here to help you resolve any issues you may be experiencing. To ensure that I provide you with the most accurate and helpful solutions, can you provide me with more detailed information about your issue? 
 

Could you please share some screenshots or further details regarding your queries? This would assist me in gaining a better understanding of the problem you are facing. Specifically, what are you trying to view or make visible? The more information you can provide me, the better resolution I can give you. 
 

Please don't hesitate to ask any follow-up questions you may have. I am here to help and look forward to working with you to find a solution. Have a great day!

These quickbooks support staff don't even read our messages.

https://www.dropbox.com/scl/fi/isz3mjz8guwtqiwurx05i/AverageDayExample.xlsx?rlkey=8fvktm5xb5pg03bsfh...

The link provides a functional workbook for use with a slightly modified QuickBooks Online Invoices and Received Payments report.

Pick the date range for the report. More data points is typically better for averages to be meaningful. You may massage the data or clean it depending on your observations and needs.

You must modify the report to include the Customer field and move the field to the top of the report. Sample shown in the workbook.

You export the report to Excel, add filters, delete all rows where Date is "(Blanks)" and paste the non-blank rows into the Modified Report gray area. There are formulas to the left and right. The one on the left works to resolve sub-customers by splitting at the separating ":" if found. The one on the right calculates the number of days between Invoice and payment.

That data is then presented in the cross tab that shows the Average Days to Pay by Customer.

It’s not just a few people that want this feature! Many of us Bookkeepers need this especially when granting credit. Please follow up with your management about this concern! All of us would like an easy way to run this report, as Quickbooks should have this feature since it is an accounting software!!!!!!

This thread was created January 2019.  It is now almost July 2024.  5 1/2 years later and STILL NOTHING has been done to create this report that we are all screaming for. 

Seriously, who do I have to get fired to get this 1 report built?  I know a lot of PE and hedge fund guys who would love to short Intuit stock just to make a few bucks.  Customer negligence is the #1 reason companies fail.  And when Short Sellers smell blood in the water . . .

Thank you for this. But my "K" is giving me #VALUE! error on all the cells with invoices. Please assist. What might be the cause. l tried changing the formats of "G" and "J" to numbers and dates again to no avail.