Days to pay report for vendors

Hello there.

Let me make it up to you by making sure you're able to run a report that'll show the days to pay for vendors, @jroneill.

In QuickBooks Desktop (QBDT), we have a variety of reports available about vendors. Since we want to know the days to pay for vendors, we can run either the A/P Aging Detail, Unpaid Bills Detail, and Transaction List by Vendor reports. However, when running the Transaction List by Vendor report, you'll need to customize the accounts into Accounts Payable only.

Here's how to run these reports:

1. Go to the Reports menu.
2. Select Vendors and Payables.
   
   
    
3. Select either one of the reports to open.
   • For the Transaction List by Vendor,
       4. Click on Customize report and select Filter.    
       5. In the Account dropdown, select All accounts payable.   
       6. When done, click OK.

On the other hand, would you mind if I ask you for some more details regarding viewing ADtP? This is for me to provide you with a suitable answer based on the information you wish to access, as ADP's payroll service, which we use in QBDT, offers tailored payroll services. I want to know if you are referring to this or something else. Any extra details would be greatly appreciated.

Additionally, know that you can memorize reports in QuickBooks Desktop if you want the same thing of the customized report to be available for future use: Create, access and modify memorized reports. 

Should you have additional questions about accessing reports in QBDT, please don't hesitate to reply to this post. I'll be willing to lend a hand. Have a good one.

Hello, I am looking to see how long it takes us to pay our vendors. Average Days to Pay. 

Thanks for getting back to us, @jroneill. I'd like to provide additional information about the days to pay from your vendors in QuickBooks Desktop (QBDT). 

QuickBooks Desktop automatically enters a date two banking days in the future in the Payment section > Date field. This is the date that will appear on your printed checks. Remember that Direct Deposit checks must be sent to the Direct Deposit service by 5:00 p.m. (Pacific time) at least two banking days before the check date. 

For additional insights, you may also check out the article about how to pay bills through direct deposit: Pay bills for vendors through Direct Deposit. 

Feel free to visit our Expenses and vendors page for more insights about managing your vendor's transactions.

Let me know if you have further questions about the vendor feature. I'm always here should you have any follow-up questions or concerns. Take care, and have a great rest of the week.

I think there is a misunderstanding. Here, I've got an example. 

We buy widget 1. from VENDOR A. It takes us 35 days to pay this vendor. 

We buy widget 2 from VENDOR B. It takes us 32 days to pay this vendor. 

Etc... etc...

I want to get a report that will tell me at what point (amount of days) that we paid these bills. I am looking to get an average for the company to see how long it takes us to pay our bills vs check date. There is a column "Average days to pay" in the reports I am pulling up, but I cannot get that column to populate any number other than zero. 

Thanks for getting back with the Community, jroneill. I appreciate your detailed information.
 

Initially, I'd recommend checking the date range you're using on your report. Its date range will affect the data that's used to produce it. If an incorrect range is entered, it could explain why you're not seeing the data you expect to be seeing on it.
 

In the event you've confirmed you have an appropriate date range entered, but are still seeing zeros in your Avg Days to Pay column, you'll want to try running the Average Days to Pay report. This report is built to display an average of how many days it takes you to pay vendor bills.
 

I've also included a detailed resource about working with reports which may come in handy moving forward: How to run & customize reports
 

Please don't hesitate to send a reply if there's any additional questions. Have a wonderful day!

I keep seeing information on the average days to pay report, but this is for customers paying us. I want to run a report on us paying vendors. 

Thank you for getting back regarding running a report showing the average days to pay your vendors in QuickBooks Desktop (QBDT), @jroneill.

You’re correct that the report mentioned by my colleague above only shows the average number of days your customers will pay you. I understand how can this be beneficial for your business.

We want to comprehend what business owners demand in the application to help them use the application most efficiently. That said, I suggest you send this feedback directly to our product development team. 

They might also include this feature in subsequent releases, depending on how many requests they receive. To do so, you can follow the steps outlined below:

1. Click the Help menu located at the top.
2. Choose to Send Feedback Online then click Product Suggestion.
3. Type in your feedback or feature request.
4. Click the Send Feedback button.

Let me know if you need further assistance with your QuickBooks preference. I’ll get back to you to offer more help. Stay safe!