Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.

Reply to message

View discussion in a popup

Replying to:
Erika_K
QuickBooks Team

Reply to message

I have details on the availability of the Average Days to Pay report, PBJ10. I can also show you a workaround to obtain a copy of this financial data.

 

The Average Days to Pay report is unavailable in QuickBooks Online (QBO). As a workaround, you can pull up either the Transaction List by Customer or the Invoices and Received Payments or any report you can use to determine how long your customers generally take to pay their invoices. After that, export it into an Excel file to allow for the creation of formulas to calculate the variance between the invoice dates and their corresponding payments. Then, you can calculate the mean of these variances to find the average number of days it takes for each customer to make payments. 

 

Let me show you how:

 

  1. Go to the Reports menu.
  2. On the Find report by name, search for the suggested or any report.
  3. Customize the date and add the necessary filter.
  4. Once done, click the Export/Print dropdown menu and select Export to Excel.

 

Additionally, you can also explore other third-party applications to help you generate this type of report. You can directly find one on the QuickBooks App Store or through the QBO Apps menu.


Drop by again if you have more questions or follow-up concerns about the different financial reports in QBO or other related tasks, PBJ10, and I'll be sure to offer a helping hand. Just leave a comment below.  Stay safe, and don't hesitate to seek our assistance whenever necessary.   

Need to get in touch?

Contact us