At this time, QuickBooks Online does not have an Average Days to Pay report to help you determine how long your customers normally take to pay their invoices.
(There is a QuickBooks Online Feature Request for this report. You can vote for this feature enhancement to increase the visibility of this request.)
To prepare a similar report, you can use the following workaround options:
- Send reports to excel and use excel to calculate this value (Intuit does not provide support in creating the formulas in excel). (Note: You can only export a report to excel one at a time.) To do this:
- Select Reports.
- Search for and open the report you'd like to view.
- Select Export, then choose Export to Excel.
- Investigate if there is a third party reporting application that would create this report for you in the Appcenter (Additional charges may apply).
Now you're able to create an Average Days to Pay report.