How to calculate a customer's average days to pay over a specific period?

Hello there, @Carl. Let me share insights about the average days to pay report in QuickBooks.

The Average Days to Pay report will help you determine how long your customers normally take to pay their invoices. It is available in both summary and detail formats. The detailed version shows the time to pay each invoice plus an overall average number of days.

In your case, you'll want to make sure that you filter it to the correct days so it will show in the report. To filter your report, you can follow the steps below:

1. Click on Reports from the menu bar.
2. Choose Customers & Receivables, then select Average Days to Pay.
3. On that report, click Customize Report at the upper left.
4. Go to The Filters tab, then on the Choose Filter field, pick Paid Through on the Filter drop-down.
5. Select a date range on the drop-down list or on From and To, then OK.
6. Filter the necessary details you want to include in the report.

On the other hand, you can also pull up the A/R Aging Detail report. It will display complete details on the average days your customers were able to pay their outstanding balance for a specific date range.

Here's how: 

1. Go to the Reports menu.
2. Select Customers and Receivables.
3. Click A/R aging Detail.
4. Choose Custom in the Dates drop-down arrow and filter the dates.

For additional reference, you can check this article on how to customize reports in QuickBooks Desktop.

In case you're working on the same reports on a daily, weekly, monthly, or quarterly basis, you can automate this task. For more details, please see this article: Set up and modify Scheduled Reports.

I'll be glad to help you again if you have more questions about running reports. I'm still here to help you. Have a good one!

Ok, that helps, but is there a way to get the same results with the summary report instead of having to use the detail report?  The detail report outputs too much extraneous data to meaningfully manipulate when I just want Customer ID and given average for a date range.  I don't need the individual invoice listings that the detail report gives.

I appreciate your prompt response and thank you for providing additional information, Carl. Allow me to chime in on this thread and provide additional information.

The Average Days to Pay report displays the data of the current total average time your customers pay you. I understand that you only need the customer ID and average days.

Since this is a detailed report, we're unable to remove the invoices. You may consider unchecking the columns that you don't need for a simpler report.

Let's customize your report further:

1. Run the Average Days to Pay report.
2. Click Customize Report.
3. In the Display tab, uncheck the details you don't want to show in the report.
4. In the Filter tab, type in Paid Through.
5. Choose Custom in the dropdown and fill in the From and To.
6. Click OK.

Additionally, please check these articles to personalize your reports:

• Create, access and modify memorized reports
• Customize reports in QuickBooks Desktop

Return to this thread if you need further assistance with running your reports. I'll be here to help you in any way I can. Have a great day!

That's not the solution I'm looking for.  I'm trying to condense the report down to a single line item per customer ID, while still including the average time to pay for all invoices during that time period.  Reducing the number of columns displayed is still returning a line item per transaction, which is more information than I need for the report.  The "Average Days to Pay Summary" report is useless, since it calculates the customer's lifetime average, regardless of what date range I set for "Paid Through."

I have another way how you can show a report to a single-line item per customer, 

For now, being able to show information in a single line is unavailable in QuickBooks. As a workaround, you can export a report to an Excel file so you can edit the information from there so it shows on a single line item only. To do so, follow the steps outlined below:

1. Go to Reports, then Reports Center.
2. Find and double-click the report you want to export.
3. Select the Excel ▼dropdown, then Create New Worksheet or Update Existing Worksheet.
4. If you see a message that says your report has too many columns, select Advanced, then uncheck the Space between columns checkbox. Select OK.
5. When you’re ready to export, select OK.

To give you more details on exporting a report, go through this article for complete steps: Export Report As Excel WorkBooks In QuickBooks Desktop.

I've also added this article to make sure you're able to customize information and be able to get what your company needs most, I've got this for your reference: Customize Reports In QuickBooks Desktop.

Please touch base with us here if you have any other concerns about the average days to pay report or any reports in QuickBooks. We're here to help you and get you covered.

The functionality that is being requested is also something I have sought as well.  If Quickbooks wants to truly help business owners, we must have the reporting we need.  Cashflow is one of the most important aspects of running a business, so knowing when we need to follow up with a customer regarding payment is critical.  I don't particularly care how a client has paid over the life of their relationship.  Let me know how they're paying in time periods that matter to me so I can make informed decisions.  Please make this a priority!!

@Carl Endres @Ajohnston 

"The "Average Days to Pay Summary" report is useless, since it calculates the customer's lifetime average, regardless of what date range I set for "Paid Through.""

Go to Reports > Customers & Receivables > Average Days to Pay Summary.  Click 'Customize Report', choose the date range you want, select OK.  That should give you the average days to pay by customer over the specified time period as one line item per customer.  

@Carl Endres @Ajohnston 

If average days to pay is a critical report for you, be aware that QB Online doesn't have that report should you ever consider switching from Desktop.  Desktop is far more robust than Online. 

I can see the importance of having the reporting you need in your business, @Ajohnston. 

While the ability to generate a report that shows information in a single line item isn't possible, I suggest providing feedback directly to our product engineers about this idea. They may consider adding this ability for future product enhancements. Here's how:

1. Open your QuickBooks Desktop.
2. Go to the Help menu.
3. Select Send Feedback Online then choose Product Suggestion.
4. Enter your suggestion.
5. Click Send Feedback.

Moreover, you may visit these articles that can help you manage different reports: 

• Customize reports in QuickBooks Desktop  
• Set up and modify Scheduled Reports

Should you have further questions or concerns about generating reports in QuickBooks, never hesitate to leave a reply below. The Community is 24/7 available to assist. 

I assure you it doesn't.  It doesn't matter what date range or "Paid through" range you set for the Summary report, it only ever returns the lifetime average for the customer.

@Carl Endres 

It works fine for me.  Don't apply any filters.  The fact that you're referencing 'Paid Through' indicates you're applying a filter.   Click 'Customize' and change the date range on the 'Display' tab.  Any time I change the date range, it changes the average days to pay for every customer as one line item per customer.  Just run the Average Days To Pay Summary report and change the date range.  No filters required.