Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowI hear you, @PBJ10. I appreciate your input between QuickBooks Desktop (QBDT) and QuickBooks Online (QBO) reporting features.
While I can't provide specific formulas and a particular name for the third-party app, I can still share guidance to accomplish your goal of creating the Average Days to Pay Report as in QBDT.
It's correct that manually calculating the average number of days each customer takes to pay their invoices should involve data on the payment date and the corresponding invoice. The closest report we can generate in QBO is the Invoices and Received Payments report. Then, customize the report to show the invoice due date. Here's how:
In your Excel, you can consider organizing your data to show the Invoice Due Date, Payment Date, and Customer. Then, another column to calculate the difference between Payment Date and Invoice Due Date.
Since this involves manual calculation, let me suggest keywords to help find a third-party app in your QBO. Here's how:
Also, if you're considering switching from QBO back to QBDT, please refer to this article: Move data from QuickBooks Online to QuickBooks Desktop.
It's important that the software accommodates various business needs, and your experience highlights where it needs to improve. I still encourage sending feedback to our product engineers to consider adding this report in future updates.
To get guidance on scheduling your sales reports, let me add this article as a future reference: Set schedule and email information for a memorized report.
We'll be here in the Community if you have further questions about generating sales reports in QBO. We'll do our best to assist. Take care.