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

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.