I have been looking for a way to report/track average days to pay accounts payable. Does such a thing exist?

I'll ensure that you'll be able to get the data that you're looking for, @jessica.d. You came in the right place for a response.

I can give you a report where you can track your accounts payable average days to pay. By doing so, you'll know when the vendor's transactions will be due.

Yes, tracking the average days to pay is exists in QuickBooks Online. To get this, please run the Accounts Payable Aging Detail report and customize the necessary details.

Here's how: 

1. Go to the Reports tab on the left side. 
2. Type the mentioned report in the search box and press Enter on your keyboard. 
3. Click the Customize button and ensure that you check the Past Due box in the Rows/Columns section.
4. Filter the necessary information and click Run report when you're ready. 

For more details about customization, see this link: Customize reports in QuickBooks Online.

You can also click the Save Customization button to memorize the report. It'll help you save time since it automatically updates every time there are newly added transactions. For further information, check out this article: Memorize reports in QuickBooks.

In addition, consult the following articles to learn about how to print, export, and email different reports available in your subscription:

• Reports included in your QuickBooks Online subscription
• Run reports in QuickBooks

I can show you another guide or overview if you have other questions about your account. Feel free to leave a comment below, and the support is just a pole away. Be safe, jessica.d.

Thank you.  I am looking for one tat shows bills already paid...

I can help you with generating the report that you need, @jessica.d. 

You can run the Bills and Applied Payments report. This will show you the payments you’ve made and the bills that go with them.

Here's how to generate the report:

1. Go to the Reports menu.
2. Scroll down to the What you owe section and look for Bill and Applied Payments.
3. Click to run the report.

You can apply filters to customize the report based on your needs, check out this guide for your reference: Customize reports in QuickBooks Online.

After you've customized it, save them so you can run the same report in the future with ease: Memorize reports in QuickBooks Online. 

I'm always here if you need more help in getting the reports that you need and or anything else. I'm always glad to help in any way I can. Have a great rest of the day!

This is not remotely close to what the OP was asking for....

You need to create an Average Days to Pay report for Accounts Receivable. This should show the date an invoice was sent out and the date it was eventually paid on - preferably with the total number of days the balance was owed for as well. SIMPLE.... why are you guys dragging your feet making this available????

So many reports missing still from Quickbooks online platform...why is this simple report still not available?? ?

Hi there, 

Is there a report that can provide the average # of days we take to pay suppliers? 

I'm in the ''Who you Owe'' section, and under Bills and Applied Payments there dosent seem to be a column option that would show information on how long it took to pay the invoice. 

Thank you, 

CL 

Hi, 

Is there a report that will provide an Average # of days that it takes our business to pay our suppliers? 

I cant find any customizations in the Bills and Applied Payments report that could help me find this information. 

Thank you, 

CL

Hello there, CL.

I know the importance of having the Average number of days to pay on the report. Rest assured, I'm here to provide an alternative way to achieve your goal.

Although QuickBooks Online doesn't provide an Average Days to Pay report to help you assess your payment schedule with suppliers, you can export the Bill and Applied Payments report to Excel and compute the average days manually outside QuickBooks.

1. Navigate to the Reports tab.
2. Search for and select the report you want to export.
3. At the top of the report, select the Export icon. Then click Export to Excel.
4. Save the file somewhere you can easily find, like your Downloads folder or desktop.

Alternatively, you can explore a third-party application that offers this functionality. You can visit our QuickBooks App Store to look for an app that can integrate with QBO and suit the needs of your business.

Moreover, to effectively monitor all the payments made to your vendors within a specific date range, I suggest reading the following resources: Run a report with vendor totals.

Keep me posted if you need further assistance with reports in QuickBooks. I'll be here to provide you with the support that you need. Keep safe.

Hello, 

What are the settings I need to have in place in order to see the days it took to pay the bill? 

I'm looking for an average # of days it takes our company to pay our suppliers. 

So far on this report on the far left, I see a date (which is the bill date) 

and I can add, in the settings, the due date, but so far I cant seem to find a column that represents the paid date. 

Any suggestions? Thank you, 

CL

Hi there, @CL94.

I'm here to guide you to find the column that displays the paid date of your bill. While using the Bills and Applied Payments report, you can see two different transactions for a bill after paying it, whether partially or full amount. 

Here's how:

1. Go to Reports and search for Bills and Applied Payments.
2. Identify the Bill transaction and Bill Payment transaction.
3. You can see the differences between the Bill Payment and Bill date under the Date column.

We're constantly striving to enhance our services and are open-minded to your suggestions. However, the feature to display the average number of days that your company pays a bill isn't currently available. I recommend following the workaround that my colleague has provided above. I also suggest sending your feedback directly to our product engineers.

Here's how:

1. Select the Gear icon and choose Feedback.
2. Fill in your suggestions in the Feedback field.
3. Select Next to send it.

Furthermore, you can learn how to customize reports in QuickBooks Online to personalize and filter your reports based on your preference.

Feel free to comment below if you have further concerns about bills and bill payments. I'm always here to assist you.