Create an average days to pay report in QuickBooks Online

Learn how to create an average days to pay report in QuickBooks Online.

QuickBooks Online doesn't have a report on how long customers usually take to pay invoices. However, there are other ways to get this info to help them plan when to pay their bills. Here’s how.

Option 1: Export reports to Excel

Send reports to Excel and use it to create the ones you need. 

Note: Intuit doesn't provide support in creating ‌formulas in Excel. You can only export a report to Excel one at a time.

1. Go to Reports (Take me there).
2. Select a report similar to the one you want to create and customize it as needed. 
3. Select Export/Print and select Export to Excel.

Option 2: Use third-party apps

You can look in the QuickBooks App store for a reporting app to make this report. 
Note: Some apps may charge separately.