cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 1

Filter Average Days to Pay Report

Right now when I pull the average days to pay report it shows me everything. Assuming that because their is a 'paid date' column I figured I would be able to filter that to a specific month - however every attempt at that does not produce the right information. Any ideas how to achieve this?

13 Comments 13
Highlighted
Moderator

Filter Average Days to Pay Report

I see this is your first question so let me take the time to welcome you here to the Intuit community, @aheftler.

 

I can help walk you through filtering the Average Days to Pay report to a specific month in QuickBooks Desktop (QBDT).

 

Here's how:

 

1. On that report, click Customize Report at the upper left.
2. Go to The Filters tab, then on the Choose Filter field, pick Paid Through on the Filter drop-down.
3. Select a date range on the drop-down list or on From and To, then OK.

 

 

Just in case, you can also check out this article for future reference: Customize reports in QuickBooks Desktop.

 

That's it! Please let me know how it goes in the comment section. I'm always here should you have any follow-up questions or concerns. Take care and have a great rest of the week.

Highlighted
Level 1

Filter Average Days to Pay Report

Yes, I attempted that however it only yielded a total of 3 vendors and 6 payments when in actuality there was more than 30 vendors that we received payments from in January.

 

I exported the full report to excel and filtered the paid date to show only 2019, however it is quite cumbersome and the data and formulas all become skewed. 

 

Any other ideas?

Highlighted
Anonymous
Not applicable

Filter Average Days to Pay Report

Hello, aheftler. 

 

There isn’t a direct way to filter Average Days to Pay report by month. As a workaround you can take note of the invoice numbers used for a certain month and use them to filter the report. For instance, for the month of December, you’ve used invoice numbers 250 to 350.

  1. Click the Customize Report tab at the top
  2. Go to Filters tab and choose Number from the filter list.
  3. Enter the first invoice number you’ve use for that month on the first box.
  4. Enter the last invoice number you’ve use for that month on the second box.
  5. Click Ok.

You can also request your preferred way of customizing the report through feedback. Just go to Help, choose Send Feedback Online and select Product Suggestion.

 

Please visit us again anytime you need help with QuickBooks.

1.PNG

Highlighted
Level 1

Filter Average Days to Pay Report

The paid through filtering works fine on the detail report, however the summary report does not filter properly.  The number of days on the report is for all transactions, and then drilling down to a specific customer, the detail is the correct filtering but the report does not tie to the detail.  Any suggestions on how to correct this?

Highlighted
QuickBooks Team

Filter Average Days to Pay Report

Hi there, @Micahel Rhyce.

 

Thanks for joining this thread. Allow me to help provide some insights about customizing reports in QuickBooks Desktop.

 

In order to show the same information both Detail and Summary report would work, make sure to customize it with the same filters such as Accounting method, Customer's name, Paid through and etc.

 

I'd like to ask some additional information such as the screenshots of both filtered reports so I can determine the difference.

 

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

 

Please let me know how it goes by clicking the Reply button below. I'll be around to help.

Highlighted
Level 1

Filter Average Days to Pay Report

Even if I enter a filtered date range, the report still goes all the way back to our start date of transactions.  I entered June 1, 2018 through May 30, 2019 and the report still included 2016 activity.

Highlighted
QuickBooks Team

Filter Average Days to Pay Report

Hello @Missdree,

 

You can filter the Date and the Dues Date altogether to show the correct data on 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. Click on Customize Report.
  4. In the Filters tab, choose the Date.
  5. Choose the date range by clicking on the Calendar icon.
  6. Choose Due Date.
  7. Edit the date range by clicking again on the Calendar icon.
  8. Click on OK.

That's it. The report now shows your transactions by date of creation and their due date.

 

You can also visit our Help Articles to learn more "How do I" steps.

 

Don't hesitate to let me know if you have any other concerns. I'll be sure to get back to you.

Highlighted
Level 1

Filter Average Days to Pay Report

I want to run the Average Days to Pay Summary for the year 2019.  I want to see the average days to pay between 1/1/2019 and 12/31/2019.  When I do this, it is pulling in payments in 2020.  I only want invoices paid in 2019 and date parameters are correct.  Why does the report pull in 2020 info??

 

Highlighted
QuickBooks Team

Filter Average Days to Pay Report

I appreciate the screenshot you've provided, @NavIngersoll.

 

I had replicated your concern to see the information you're referring to. 

The date parameters in the report refer to the date when the transactions are created. The Average Days to Pay displays information on how many days a customer pay their dues. To calculate this, you'll have to know when it was actually paid.

 

4.GIF

Instead of using the Average Days to Pay report, you can run the A/R Aging Detail report. This also displays complete details on the average days your customers were able to pay their outstanding balance for a specific date range.

 

5.GIF

On the other hand, the accounting method used in your QuickBooks account affects the data that reflects in your report.

 

If you've set your accounting method into the Accrual method, ensure to choose the same method in generating your reports. An accrual-basis report shows income regardless of whether your customers have paid your invoices and expenses regardless of whether you have paid all your bills. You can change your QuickBooks accounting preferences and make sure that your reports match with it.

 

Here's how:

  1. Click on Edit menu.
  2. Select Preferences.
  3. Click on Reports & Graphs from the left pane.
  4. Go to the Company Preferences.
  5. Select Accrual under Summary Reports Basis.
  6. Click OK.

a3 accrual.PNG

Once done, all your reports will default to Accrual basis. You can refer to this article for more information about the difference between cash and accrual basis, you can check this article: Differentiate Cash and Accrual basis.

 

Leave a comment below if you have other questions about managing your transactions and reports in your QuickBooks account. I'm always here to help.

Highlighted
Level 1

Filter Average Days to Pay Report

@IamjuViel  thanks for your response!

I had the accrual on under customer preferences clicked already in the summary reports basis.

Any other thoughts why payments are being included when outside the date parameters

Highlighted
QuickBooks Team

Filter Average Days to Pay Report

Hi there, NavIngersoll.

 

Yes, you can customize the report by the specific date. Let me show you how to do that.

 

  1. Go to the Reports tab and select the Customers and Receivables tab.
  2. Select Average Days to Pay Summary tab.
  3. Click on the Customize Report button then under the Display section choose Customize on the dates.
  4. Enter the dates for From and To boxes.
  5. Go to the Filters section and enter Date in the Search tab. 
  6. Then click OK button.

 

You can also check this article to know more about customizing the reports in QuickBooks Desktop.

 

Please click the Reply button if you have questions in mind. I'm here to back you up. Take care.

Highlighted
Level 1

Filter Average Days to Pay Report

@MarsStephanieL thank you for your reply!

I am familiar with customizing reports, however this is my issue.  I enter the the dates 1/1/2019-12/31/2019 and the report is still pulling in payments from 2020.  I just don't understand this glitch. Has anyone else ever had issues with this?  

Highlighted
QuickBooks Team

Filter Average Days to Pay Report

Hello there, @NavIngersoll.

 

Let me provide additional information about the payments that will show up in your reports.

 

The Average Days to pay report will list all paid invoices and statement charges under Accrual Basis. QuickBooks will calculate the days to pay as the difference between the invoice or statement charge date and the paid date.

 

If the invoice has been paid later this year, the report will still pulling up the payments from 2020. As a workaround, we can pull up 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.

On the other hand, if there are any features you’re having trouble locating or any that aren’t working as they should, these articles will come in handy: QuickBooks Desktop Help Articles.

 

 I'm just here if you need more help. Take good care.

 

Need to get in touch?

Contact us