Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Where did you see this and how do you get to it or make it visible?
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.
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 . . .
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here