QuickBooks HelpQuickBooksHelpIntuit

How to create an average days to pay report

SOLVEDby QuickBooksUpdated January 19, 2023

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 doesn't provide support in creating the formulas in Excel). (Note: You can only export a report to Excel one at a time.) To do this:
    1. Go to Business overview and select Reports (Take me there).
    2. Search for and open the report you'd like to view.
    3. Select Export and select Export to Excel.
  • Investigate if there is a third party reporting application that would create this report for you in the QuickBooks App Store (Additional charges may apply).

Now you're able to create an Average Days to Pay report.

Was this helpful?

You must sign in to vote, reply, or post

Sign in for the best experience

Ask questions, get answers, and join our large community of QuickBooks users.