Skip to main content
A
aheftler
February 4, 2019
Question

Filter Average Days to Pay Report

  • February 4, 2019
  • 2 replies
  • 0 views

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?

2 replies

AlcaeusF
AlcaeusF
February 4, 2019

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.

A
aheftlerAuthor
February 4, 2019

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?

A
Anonymous
February 4, 2019

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.

K
KPellock
August 5, 2021

I am sorry, but this report needs to be fixed.  We shouldn't have to jump through hoops to find out the Average days to pay.  It is a normal repor that is used in a variety of ways and if you cannot fix it, you need to find another solution.  I have spent hours trying to gather the data.  No matter what I change my filters to, I get the same result for each customer.  It is NOT working and it SHOULD be fixed.

I have been asking abut this from support for years.  

    K
    KendallN
    October 14, 2021

    This report does not function as required as all of the other people have reported above.  For example, if I run this report separately for January, then February, then March (etc), I get the SAME number for each month, a complete impossibility.  The formulas need to be fixed to reflect the specific time frame the operator chooses.  

     

    I am happy to speak directly to your programmers if one of them will please call me.

     

    Thanks,

     

    Kendall Nolan

    [Removed]

    C
    Catherine_B
    October 15, 2021

    Hello there, Kendall.

     

    I know how convenient it is for your business to be able to correctly show the amount and pull up the report by month as well.  

     

    For now, the report provides a simple overview of the average days to pay for each custmoer. The report calculates the difference between the transaction date and the paid date. It also averages the days to pay for all invoices and statement charges per customer.

     

    We can look into other detailed sales reports that will show the same data you need like the Accounts Receivable report. Then, you can export it to Excel and manually calculate the average from there. You can also check this article to know more about customizing the reports in QuickBooks Desktop.

     

    I can also show you how to submit feedback to our engineers so they can add these options to future updates. Here's how: 

     

    1. Go to Help and click Send Feedback Online.
    2. Click Product Suggestion.
    3. Enter the details and a brief description of your suggestion about the Average Days to Pay Report.
    4. Click Send Feedback.

    You might also want to visit our feedback forum to check the recent updates made in QuickBooks. You'll want to bookmark this link: Resource Hub. This will provide you with resources and videos about managing your QuickBooks Desktop reports.

     

    Please know that the Community forum is always open if you need further assistance running reports. Keep safe and take care.

    Terms & ConditionsAccessibility statement