How to get a report in QuickBooks Desktop Accounts payable average time paid

@CP72  I notice that the Average Days To Pay report you reference has the option to change the Name filter from 'All Customers/Jobs' to 'All Vendors' under the Customize Report button.

My clients are too small to really use bills, but you might try and see if that works for you.

QuickBooks Desktop doesn't have a similar report that shows the average days to pay for A/P transactions, CP72. Let me provide a workaround to help you get the data that you need.

You can use the Vendor Balance Detail report, which provides a list of bills alongside their corresponding payments. You can then export this report to Excel to create a formula that calculates the average days to pay.

Here's how:

1. Go to the Reports menu, look for Vendors and Payables, and then click Vendor Balance Detail.
2. Change the date in the Dates filter depending on the period that you need.
3. Click Excel, then choose Create New Worksheet.

Check out these articles for additional details about this:

• Export reports as Excel workbooks in QuickBooks Desktop
• Customize vendor reports

Additionally, here are some other resources that can help when running reports and managing accounts payable in QuickBooks:

• Customize company and financial reports
• Resolve accounts receivable and accounts payable balances on a cash basis balance sheet

Remember, the Community is always available if you need extra support with analyzing data or tracking vendor transactions in QuickBooks. Don't hesitate to reach out, we're here to help.

Dose not work

Thank you for answering, 

Can you please share the formula that I can use in excel to get the average time to pay? 

Thank you for coming back, CP72. Allow me to share another workaround and formula you can use to get the average days to pay.

Please check if the vendor transaction has the Vendor name and Date, then export it to Excel. From the exported file, add two columns for the bill date and the payment date. Then use the sample formula: =datedif and =averageif.

Let's do this:

1. Sort by Vendor Name.
2. Add a new column, then name it Days to Pay.
3. Use the "=datedif" formula to Bill Date and Date Paid for bills.
   
    
4. Add another column, then name it Average Days to Pay.
5. Use the "=averageif" formula.
6. Use the Vendor name column, then let the formula find the specific vendor to calculate the average.
   
    
7. Use the Days to Pay column to calculate the average.

For multiple vendors, change the name inside the "=averageif" formula to another vendor to calculate the unique average for each entity. Please make sure to sort the name by vendor first before doing this. If you need help with the required values for the formula, you can check Microsoft's Excel forum.

You can also refer to these articles from the Microsoft support site:

• Create a simple formula in Excel
• Calculate an average

You may refer to the article fix export to Excel issues in QuickBooks Desktop for future reference. Having this resource handy ensures you can quickly and efficiently resolve any export problems, minimizing disruptions to your workflow.

The Community team and I are all ears and willing to help you further. You may drop them into this thread and we'll get back to you as soon as we can.